Your thread brings back memories of my quest on Flyertalk to find Fanta Melon Soda:

http://www.flyertalk.com/forum/showthread.php?t=424100

I actually received no replies, and there is some useful information listed in this thread. Most Japanese markets will have melon soda, just not the exact kind you are looking for.