as salam alaikum
there are ahadith stating that the prayer for the one who have consumed wine will not be accepted for forty days. There is no mention in those ahadith that his dhikr or du'a won't be accepted and actually it is said that such practices can accompany Muslims in all circumstances of life.
In the mentioned case, the person should also not forget to do istighfar and ask forgiveness for the sin that he committed. If he sincerely repents and has resolution of not committing the sin anymore, Allah is certainly All-Forgiving.
With prayers for your success.