He is already back in England, according to tmz. I don't think they are very happy with him right now.
Tmz may be right in that he's now back in England but I sincerely doubt tmz has an 'in' with the Queen. Whatever disapproval might be expressed publicly - and that's highly unlikely I wouldn't expect anything except a lofty and tacit refusal to comment - I am pretty sure that behind closed doors it's not so much what he was doing at the party that will earn him censure but the fact that he was stupid enough to allow such slight acquaintances the opportunity to sell him out to the press - ie not in trouble for what he did but rather for getting caught on camera doing what he did.
Thing is, HM, as I said before has weathered far worse storms than this nothing of a scandal. Harry's Uncle, Prince Andrew came this *pinching thumb and index finger together* close to marrying a soft-*advertiser censored* star (maybe they should have let him since it transpired that she had more class, discretion and circumspection in her little finger than the woman he eventually married had in her entire body), had numerous amorous 'encounters' as a bachelor and was the victim of several 'kiss and tells', the Royal Family survived his escapades and they all flared up quickly as news items and burned out just as quickly as will Harry's.