You should get your room number text after your room is ready.
You won't get it before it's ready, but it may not come at all for some reason.
If it doesn't come by the time you arrive at the resort, go to the check in desk.
Once (if) you get the text with your room number, your magic band will work to get into the room, you won't have to stop at the front desk away all.