Aaron Carter's death touched off a chaotic situation inside his L.A. home ... as his housekeeper was heard screaming over the police scanner after discovering his body.