Public Morals (1996)

Ruggs turns up to work without his pants and explains to Lt. Fogarty that a nine-year-old boy, Robert, mugged him. Fogarty, who is on a cheese-only diet, becomes obsessed with a strange smell in his office until Ruggs realizes it's the lieutenant who smells. While Richie is persuaded by John to see if Richie's dog likes his so the two pets can have companionship, Schuler gets a date through the personal ads. All seems to go well until, walking home, she demands Schuler's shoes at gunpoint.