Replies posted by EnsPrabhP

1 Reply

dsj
Superhero (Partner)
dsjSuperhero (Partner)
asked in Framework & Experience (Infrastructure, Cloud, Integration, Dev Tools)

PLSQL Routing - error message

Hi,  I had similar issue while integrating IFSAPPS with our scanning application. We just want to show the IFS error message (in case of any error/exception) while performing IFS transaction (like move part, PO Receive ) using handheld device(e.g. CK device ). To overcome this  I created a function(as below) which returns the IFS error message when we pass the Oracle trace message.  FUNCTION Get_Error_Message(error_msg_ IN VARCHAR2) RETURN VARCHAR2  IS   error_ VARCHAR2(32767) := ''; BEGIN     error_ := substr(error_msg_, instr(error_msg_,':') +1, length(error_msg_));          WHILE instr(error_, ':') > 0 loop         error_ := substr(error_, instr(error_,':') +1, length(error_));     end loop;          return error_; END Get_Error_Message;    Used the function as below:  PROCEDURE PO_RECEIVE( order_no_ IN VARCHAR2,                                                     -----                                                   X_RETURN_STATUS      OUT VARCHAR2,                          

2
dsj
Superhero (Partner)
4 years ago

Badges

Show all badges
Terms & ConditionsCookie settings