A firearms officer with South Yorkshire Police has been given a written warning, over an allegation he fell asleep while in possession of two loaded guns.