Playing a specific media file after activity selection

All - please help!

I would like to play a specific video media file (think: THX or DTS theme) when the user selects a specific activity on the remote. We have a full-time media server and RoomieAgent in the setup, as well as several iPads.

Any idea on how to accomplish this???