any app that supports notifications has its own notification settings.. for example, go to the email app, menu/settings/notifications and u can choose the tone for the email app. same for the messaging app
if u just go to the settings menu from ur homescreen, that takes u to the main android settings page, going to sounds/notfications here just sets the default notification.