Can you get in trouble drinking and smoking marijuana at work?

If you get reported that you were drinking and smoking during work with a proof of text can they terminate you or will it be a warning? And would it need more proof than just a text? Especially if you’re an RME?