You can go in the menu Display->views and edit the file show of the view affiliate.
There, you can add your message:
Code:
if(empty($this->user->user_id)){
$app =& JFactory::getApplication();
$app->enqueueMessage('You must be registered and logged in to view our affiliate details.');
}
