1996:
1997: BEGIN
1998: SELECT trim(message_standard)
1999: INTO l_message_standard
2000: FROM ecx_doclogs
2001: WHERE INTERNAL_CONTROL_NUMBER = l_internal_control_number;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
2004: l_msg_data := 'ECX DOCLOGS has no entry corresponding to the given Internal Control Number';
2000: FROM ecx_doclogs
2001: WHERE INTERNAL_CONTROL_NUMBER = l_internal_control_number;
2002: EXCEPTION
2003: WHEN NO_DATA_FOUND THEN
2004: l_msg_data := 'ECX DOCLOGS has no entry corresponding to the given Internal Control Number';
2005: l_return_msg_tp := 'Issues in the Trading Partner Setup. No Record in AQ';
2006: l_return_status_tp := '99';
2007: END;
2008: