Is the prayer of the one who consumes alcohol accepted?

Allaah says (interpretation of the meaning):

"O you who believe! Intoxicants (all kinds of alcoholic drinks), and gambling, and Al-Ansaab (stone altars for sacrifices to idols, jinn, etc), and Al-Azlaam (arrows for seeking luck or decision) are an abomination of Shaytaan's (Satan's) handiwork. So avoid (strictly all) that (abomination) in order that you may be successful" [Surah al-Maa'idah:90]

As for his prayers, then it will not be accepted for forty days. As it comes in the narration of Abd-Allaah ibn `Amr said: The Messenger of Allaah (peace and blessings of Allaah be upon him) said:
"Whoever drinks alcohol and gets drunk, his prayers will not be accepted for forty days, and if he dies he will go to Hell, but if he repents, Allaah will accept his repentance. If he drinks wine again and gets drunk, his prayer will not be accepted for forty days, and if he dies he will go to Hell, but if he repents, Allaah will accept his repentance. If he drinks wine again and gets drunk, his prayer will not be accepted for forty days, and if he dies he will go to Hell, but if he repents, Allaah will accept his repentance. If he does that again, Allaah will give him to drink of the mud of khabaal on the Day of Resurrection." They said, "O Messenger of Allaah, what is the mud of khabaal?" He said, "The juice of the people of Hell."

[Narrated by Ibn Maajah, 3377; classed as saheeh by al-Albaani in Saheeh Ibn Maajah, 2722]

Abu `Abd-Allaah ibn Mandah said:
The phrase "his prayers will not be accepted" means that he will not be rewarded for his prayers for forty days, as a punishment for drinking alcohol. This is like what they said about the one who speaks when the imam is delivering the khutbah on Friday: he prays Jumu'ah [Friday prayer] but there is no Jumu'ah for him, meaning that he will not be given the reward for praying Jumu'ah, as a punishment for his sin.

[Ta'zeem Qadr al-Salaah, 2/587, 588]

An-Nawawi said:
"With regard to his prayer not being accepted, what this means is that he will not be rewarded for it, even though it is valid, and he does not have to repeat it"

And Allaah Knows Best