Emerald used flags so far:
0x860 - Pokemon Menu
0x861 - Pokedex Menu
0x862 - Pokenav Menu
We don't know very much of Emerald's flags. But, we do advise you Emerald hackers to try Ruby's and Sapphire's flags to see if anything comes up. And if something does, please report them to me.
For the fanfare... I don't know honestly... Depending in which case you're referring to, is it for a pokemon battle or the give pokemon command? I would look at one of those two scripts and find the fanfare command with 0xNUMBERS numbers being the offsets etc.