Kumar,
we used SQL query and also CSVs to created new location roles. As a precautionary information, we are not using OTM for planning but for visibility.
If you are planning shipment or any business object with your custom role, then i am not sure how it can be mapped with planning. and also hw OTM will use it during planning
?
Please look into Planning parameters which might throw some ideas. and let us know if you find any.
Cheers,
neo