You can get your Sim drunk with the Drink Maker. Click "Make Drinks", then feed your Sim all those drinks. Do this twice or more times. When you get your Sim drunk, this will cause vomiting. Note: You cannot do this with children.