Is there a way to customize the iPhone sounds on things like text, mail notification, etc?

I saw this website on it, but don't see how to get to the indicated locations. Does this require a jailbreak?

http://www.everythingicafe.com/forum...nds-27083.html