I hate to go internet diagnosing, but upper abdominal pain from alcohol abuse might be acute pancreatitis, which can sometimes go very badly.
Whatever the details, your body is trying to tell you that the party's over. If alcohol was a mountain, you climbed it. Time to put the cork in the bottle and find some new hobbies.