Just make a normal sleight of hand check. There is no failure, in that the guards will not beat the crap out of you. However, you may not get anything in the door (or have anything to get through). For example, a 6 isn't really good enough to get any supplies. On the other hand, a 23 could get some rather useful supplies into a cell.

Correct on both accounts for the Pathfinder default setting.