How can I turn off the notification sounds?

Tap the Settings app on your home screen, then tap Notification Center. Find “Deliveries” in the list and tap it. Tap the switch next to Sounds to turn it off.

Don’t have Delivery Status? Get it for iPhone, iPad, and iPod touch or for Mac.
Then check out Notefile for iPhone, iPad, and iPod touch or for Mac.