Can I use Custom Error pages in SAP HANA?

You are correct as XSA supports the custom error pages but classic does not support custom error messages.

In case you need to do in any way, then what you can try out is you need to parse all requests through a load balancer or a proxy and then show custom error message. And it is not a easy and maintainable approach.