It is narrated from Sayyiduna Ibn Umar (may Allah be pleased with them both) that the Prophet (peace and blessings be upon him) said: "Whoever drinks wine and puts it into his stomach, his prayer is not accepted for seven (days), and if he dies in that state he dies a disbeliever. And if it makes his mind heedless of any of the obligations, his prayer is not accepted for forty days, and if he dies in that state he dies a disbeliever."
Hadith Referenceالمعجم الكبير للطبراني / باب العين / 13435