We have an application that needs to connect to the modem through an IP Socket, and use AT commands to send and receive SMS messages. Is it possible?

Yes, you can make a TCP socket connection and control the wireless modem directly and you can use it to send / receive SMS messages.