Yes definitely apologise. I'm sure he'll forgive you. Keep the drinking to a minimum. And if it makes you feel any better. Several years ago (over five) when I was young and liked to party more, I've been know to actually throw up mid intimacy.. . . . yeah, it doesnt get any worse than that. So like RomanSunburn suggested, take him out to lunch or maybe even dinner (minus the alcohol) to apologize, it'll help smoove things over. Good luck.

Yeah, sorry, I didn't know how this got posted twice instead of being edited.