DBA Data[Home] [Help]

APPS.ECX_INBOUND_TRIG dependencies on ECX_OUT_WF_QH

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

1207: ecx_debug.log(l_statement,'i_party_id',i_party_id,i_method_name);
1208: ecx_debug.log(l_statement,'i_party_site_id', i_party_site_id,i_method_name);
1209: ecx_debug.log(l_statement,'i_party_type', i_party_type,i_method_name);
1210: end if;
1211: -- call ecx_out_wf_qh.enqueue with the correct parameters
1212: wf_event_t.initialize(i_event);
1213: i_event.addParameterToList('PARTY_TYPE', i_party_type);
1214: i_event.addParameterToList('PARTYID', i_party_id);
1215: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);

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

1212: wf_event_t.initialize(i_event);
1213: i_event.addParameterToList('PARTY_TYPE', i_party_type);
1214: i_event.addParameterToList('PARTYID', i_party_id);
1215: i_event.addParameterToList('PARTY_SITE_ID', i_source_code);
1216: -- added this for passthrough logging purposes in ecx_out_wf_qh
1217: i_event.addParameterToList('INT_PARTY_SITE_ID', i_party_site_id);
1218: i_event.addParameterToList('DOCUMENT_NUMBER', i_document_number);
1219: i_event.addParameterToList('MESSAGE_TYPE', i_standard_type);
1220: i_event.addParameterToList('MESSAGE_STANDARD', i_standard_code);

Line 1257: i_out_msgid := ecx_out_wf_qh.msgid;

1253: end if;
1254: wf_event.send(i_event);
1255: ecx_errorlog.outbound_log(i_event);
1256:
1257: i_out_msgid := ecx_out_wf_qh.msgid;
1258:
1259: -- check the retcode and retmsg. This should be populated here only
1260: -- in the case of dup val index when inserting in doclogs (since no
1261: -- exception is raised in this case)

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

1258:
1259: -- check the retcode and retmsg. This should be populated here only
1260: -- in the case of dup val index when inserting in doclogs (since no
1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);

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

1260: -- in the case of dup val index when inserting in doclogs (since no
1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,

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

1261: -- exception is raised in this case)
1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS

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

1262: if (ecx_out_wf_qh.retmsg is not null) then
1263: --ecx_utils.error_type := 30;
1264: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1265: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1266: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1267: if(l_statementEnabled) then
1268: ecx_debug.log(l_statement,ecx_debug.getMessage(ecx_utils.i_errbuf,
1269: ecx_utils.i_errparams),i_method_name); -- MLS
1270: end if;

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

1284: end if;
1285: raise ecx_utils.program_exit;
1286: when others then
1287: --dbms_lob.freetemporary(i_xmldoc);
1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;

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

1288: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;

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

1289: then
1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then

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

1290: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1291: else
1292: --ecx_utils.i_ret_code := ecx_out_wf_qh.retcode;
1293: --ecx_utils.i_errbuf := ecx_out_wf_qh.retmsg;
1294: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode,30,ecx_out_wf_qh.retmsg);
1295: end if;
1296: --ecx_utils.error_type := 30;
1297: if(l_unexpectedEnabled) then
1298: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,