DBA Data[Home] [Help]

APPS.ECX_OUTBOUND dependencies on ECX_OUT_WF_QH

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

1501: i_xmldoc,
1502: i_message_type
1503: );
1504:
1505: -- call ecx_out_wf_qh.enqueue with the correct parameters
1506: ecx_utils.g_event.addParameterToList('PARTY_TYPE', i_party_type);
1507: ecx_utils.g_event.addParameterToList('PARTYID', i_destination_code);
1508: ecx_utils.g_event.addParameterToList('PARTY_SITE_ID', i_destination_code);
1509: ecx_utils.g_event.addParameterToList('DOCUMENT_NUMBER', ecx_utils.g_document_id);

Line 1579: i_msgid := ecx_out_wf_qh.msgid;

1575: if (upper(i_destination_type) = 'SOAP') or
1576: (upper(i_destination_type) = 'JMS') then
1577: i_msgid := wf_event.g_msgid; -- JMS QH store enqueue msgid in wf_event.g_msgid
1578: else
1579: i_msgid := ecx_out_wf_qh.msgid;
1580: end if;
1581:
1582: -- check the retcode and retmsg. This should be populated here only
1583: -- in the case of dup val index when inserting in doclogs (since no

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

1581:
1582: -- check the retcode and retmsg. This should be populated here only
1583: -- in the case of dup val index when inserting in doclogs (since no
1584: -- exception is raised in this case)
1585: if (ecx_out_wf_qh.retmsg is not null) then
1586: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1587: if(l_unexpectedEnabled) then
1588: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1589: end if;

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

1582: -- check the retcode and retmsg. This should be populated here only
1583: -- in the case of dup val index when inserting in doclogs (since no
1584: -- exception is raised in this case)
1585: if (ecx_out_wf_qh.retmsg is not null) then
1586: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1587: if(l_unexpectedEnabled) then
1588: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1589: end if;
1590: end if;

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

1635: raise ecx_utils.program_exit;
1636: end if;
1637:
1638: WHEN OTHERS THEN
1639: if (ecx_out_wf_qh.retmsg is null AND ecx_out_wf_qh.retcode = 0)
1640: then
1641: ecx_debug.setErrorInfo(2, 30, SQLERRM);
1642: if(l_unexpectedEnabled) then
1643: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);

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

1642: if(l_unexpectedEnabled) then
1643: ecx_debug.log(l_unexpected, 'ECX', SQLERRM,i_method_name);
1644: end if;
1645: else
1646: ecx_debug.setErrorInfo(ecx_out_wf_qh.retcode, 30, ecx_out_wf_qh.retmsg);
1647: if(l_unexpectedEnabled) then
1648: ecx_debug.log(l_unexpected, 'msg and code set in queue handler',i_method_name);
1649: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1650: end if;