It appears anywhere on the website as a yellow tab, and features two links. One to the message, the other to the user who messaged you. How do you like it? Could it be better? Post your opinions here!
Honestly, I find it distracting and a little obstructive. I'm personally comfortable with just having the messages/alerts bar up top. But it does somewhat address the idea of an Activity box on every page.