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. Like Roman Sunburn suggested, taking him out to lunch or even dinner (minus the alchohol) to apologise might help smoove things over. Good luck.