How do DMs handle lingering injuries on characters?

At what point does a character get scared or lose a limb? Is it based solely on the DMG?