To get fucked up by a various means simultaneously, normally with drugs and alchohol. Taken from a spoof on an Old Navy commercail, it just sounds like a good way to describe being totally wasted.
"Let's get campy"
"Ok pass the bong over here and grab me a beer from the fridge"
There's nothing better than getting campy on friday night.