It means that the message or post will not be approved and viewable by others until either a moderator has seen and approved it (usually for posts) or the member has approved it (if it's on their visitor's wall and they're settings are that they must approve all posts to their wall first).