You need to create a folder on your sd card or internal storage called /media/audio/notifications.  Pleace your mp3 file in that folder, and then it should appear when you view the list of available tones for your text messages.