Skip to main content

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!

Be the first to reply!

Reply