Skip to main content
Question

IFS API to translate Oracle Error Messages


Forum|alt.badge.img+4
  • Sidekick (Customer)
  • 5 replies

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


Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings