Where is Archie in sapphire?

Archie is an event npc, you cannot find him if you are not in those events.

he'll appear in mt. chimney trying to activate the volcano with a meteorite.

he'll appear later in mt pyre stealing the red orb.

and finally on seafloor caver resurrecting kyogre