Whether you have an iPhone or an iPad, you’ll notice that you can customize notification sounds for pre-installed apps in the Settings app’s Notifications preference pane. This includes, but isn’t limited to: Calendar events, FaceTime calls, phone calls, iMessage/SMS messages, and Reminders, among other things.
NotiSound lets jailbreakers customize notification sounds for all apps individually