to drunk to function

is it possible for a guy to have drunken to much and not get hard? Even when I tried to do everything possible to get him there?