DBA Data[Home] [Help]

APPS.ECX_INBOUND_TRIG dependencies on ECX_OUT_WF_QH

Line 1226: -- call ecx_out_wf_qh.enqueue with the correct parameters

1222: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1223: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1224: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1225: end if;
1226: -- call ecx_out_wf_qh.enqueue with the correct parameters
1227: wf_event_t.initialize(i_event);
1228: i_event.addParameterToList('PARTY_TYPE', i_party_type);
1229: i_event.addParameterToList('PARTYID', i_party_id);
1230: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);

Line 1231: -- added this for passthrough logging purposes in ecx_out_wf_qh

1227: wf_event_t.initialize(i_event);
1228: i_event.addParameterToList('PARTY_TYPE', i_party_type);
1229: i_event.addParameterToList('PARTYID', i_party_id);
1230: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);
1231: -- added this for passthrough logging purposes in ecx_out_wf_qh
1232: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1233: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1234: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1235: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);

Line 1272: i_out_msgid := ecx_out_wf_qh.msgid;

1268: end if;
1269: wf_event.send(i_event);
1270: ecx_errorlog.outbound_log(i_event);
1271:
1272: i_out_msgid := ecx_out_wf_qh.msgid;
1273:
1274: -- check the retcode and retmsg. This should be populated here only
1275: -- in the case of dup val index when inserting in doclogs (since no
1276: -- exception is raised in this case)

Line 1277: if (ecx_out_wf_qh.retmsg is not null) then

1273:
1274: -- check the retcode and retmsg. This should be populated here only
1275: -- in the case of dup val index when inserting in doclogs (since no
1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);

Line 1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;

1275: -- in the case of dup val index when inserting in doclogs (since no
1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,

Line 1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;

1276: -- exception is raised in this case)
1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1284: ecx_utils.i_errparams),i_method_name); -- MLS

Line 1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);

1277: if (ecx_out_wf_qh.retmsg is not null) then
1278: --ecx_utils.error_type := 30;
1279: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1280: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1281: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1282: if(l_statementEnabled) then
1283: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1284: ecx_utils.i_errparams),i_method_name); -- MLS
1285: end if;

Line 1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)

1299: end if;
1300: raise ecx_utils.program_exit;
1301: when others then
1302: --dbms_lob.freetemporary(i_xmldoc);
1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;

Line 1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;

1303: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;

Line 1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;

1304: then
1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then

Line 1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);

1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1306: else
1307: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1308: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1309: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1310: end if;
1311: --ecx_utils.error_type := 30;
1312: if(l_unexpectedEnabled) then
1313: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,