If you create a folder on your SD Card and call it Notifications, put the tunes you want to use in there and they will appear in the list of available options when setting tones.
The global tone can be set via Settings -> Sound, but normally within each app (Gmail, Messaging, Email, Talk), there are individual notification options for each app.
Is that what you mean?