I agree with James - it depends who is saying this.
If the speaker is using British English, it means that they have the impression that the other person is drunk. If they are using American English, it means that they think the other person is annoyed about something.
Note that this is a informal term, and, in the case of the British usage, fairly vulgar.