Question

IFS API to translate Oracle Error Messages

  • 21 March 2022
  • 0 replies
  • 90 views

Userlevel 1
Badge +3

Is there an IFS function to handle oracle exceptions and return just the user facing message? 

When executing an IFS Procedure the following error will be returned for example:

ORA-20110: ShopOrderOperation.OPERCLOSED2: Operation is closed. Not allowed to modify qty complete.
ORA-06512: at "IFSAPP.ERROR_SYS", line 1017
ORA-06512: at "IFSAPP.ERROR_SYS", line 92
ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 11735
ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 12283
ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10169
ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10190
ORA-06512: at "IFSAPP.SHOP_ORDER_OPERATION_API", line 10213
ORA-06512: at line 1

 

However in the IFS Frontend application the application will only show the human readable error message such as:

 

Operation is closed. Not allowed to modify qty complete

 

Since I could be calling any IFS Procedure and I could experience any call-stack, I’m trying to figure out how I can retrieve just the user facing error message from any procedure that I call. If you have any advice let me know! Thanks!


0 replies

Be the first to reply!

Reply