Where do you find manaphy?

u need Pokemon ranger and do the last mission and then transfer the egg to Pokemon pearl or diamond :)

You can get manaphys' data for your sinnoh dex if you read the book on Mr. backlots desk in the pokemansion:o

And Rotom is in the tv at the haunted house at night.