eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ECX_INBOUND_TRIG dependencies on ECX_INBOUND_TRIG

Line 1: package body ecx_inbound_trig as

1: package body ecx_inbound_trig as
2: -- $Header: ECXINBTB.pls 120.20.12020000.5 2013/04/30 18:17:07 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;

Line 29: i_method_name varchar2(2000):='ecx_inbound_trig.is_routing_supported';

25: p_map_id IN pls_integer
26: ) return boolean is
27:
28: l_tar_obj_type Varchar2(200);
29: i_method_name varchar2(2000):='ecx_inbound_trig.is_routing_supported';
30:
31: begin
32: SELECT object_type
33: INTO l_tar_obj_type

Line 47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');

43:
44: exception
45: when others then
46: ecx_debug.setErrorInfo(2, 30,
47: SQLERRM||' - ECX_INBOUND_TRIG.IS_ROUTING_SUPPORTED');
48: if(l_unexpectedEnabled) then
49: --ecx_debug.log(l_statement, ecx_utils.i_errbuf, i_method_name);
50: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
51: end if;

Line 65: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';

61: )
62: is
63:
64:
65: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
66: nl xmlDOM.DOMNodeList := null;
67: n pls_integer;
68: pnode xmlDOM.DOMNode;
69: cnode xmlDOM.DOMNode;

Line 102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');

98: end if;
99: exception
100: when others then
101: ecx_debug.setErrorInfo(2,30,
102: SQLERRM ||' - ECX_INBOUND_TRIG.GET_ELEMENT_VALUE');
103: if(l_unexpectedEnabled) then
104: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
105: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
106: end if;

Line 118: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';

114: i_standard_type in varchar2
115: )
116: is
117:
118: i_method_name varchar2(2000) := 'ecx_inbound_trig.get_element_value';
119: cursor get_attributes
120: (
121: p_standard_code IN varchar2,
122: p_standard_type IN varchar2

Line 191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');

187: ecx_debug.pop(i_method_name);
188: end if;
189: exception
190: when others then
191: ecx_debug.setErrorInfo(2,30,SQLERRM ||' - ECX_INBOUND_TRIG.getAttributes');
192: if(l_unexpectedEnabled) then
193: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
194: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
195: end if;

Line 209: i_method_name varchar2(2000) := 'ecx_inbound_trig.parsepayload';

205: i_payload IN CLOB
206: )
207: is
208:
209: i_method_name varchar2(2000) := 'ecx_inbound_trig.parsepayload';
210: begin
211: if (l_procedureEnabled) then
212: ecx_debug.push(i_method_name);
213: end if;

Line 321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');

317: ecx_debug.pop(i_method_name);
318: end if;
319: raise ecx_utils.program_exit;
320: when others then
321: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.PARSEPAYLOAD ');
322: if(l_unexpectedEnabled) then
323: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
324: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
325: end if;

Line 341: i_method_name varchar2(2000) := 'ecx_inbound_trig.writexmltofile';

337: (
338: i_xmldoc IN OUT NOCOPY CLOB
339: )
340: is
341: i_method_name varchar2(2000) := 'ecx_inbound_trig.writexmltofile';
342: i_logdir varchar2(200);
343:
344: attachment_id pls_integer;
345: ctemp varchar2(32767);

Line 402: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxmldata';

398: i_message_type IN varchar2
399: )
400: is
401:
402: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxmldata';
403: i_doc xmlDOM.DOMDocument;
404: l_same_map Boolean;
405: l_parseXML boolean;
406:

Line 511: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');

507: end;
508: raise ecx_utils.program_exit;
509:
510: when others then
511: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');
512: if(l_unexpectedEnabled) then
513: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
514: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
515: ecx_debug.log(l_unexpected,'Clean-up last_printed',i_method_name);

Line 546: i_method_name varchar2(2000) := 'ecx_inbound_trig.validate_message';

542: m_payload IN clob,
543: m_message_type IN varchar2
544: )
545: is
546: i_method_name varchar2(2000) := 'ecx_inbound_trig.validate_message';
547: i_map_id pls_integer;
548: o_ret_code pls_integer;
549: o_ret_msg varchar2(2000);
550: i_dtd_id pls_integer;

Line 948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');

944: end if;
945: raise ecx_utils.program_exit;
946: when others then
947: --ecx_utils.g_map_id := -1;
948: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
949: if(l_unexpectedEnabled) then
950: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
951: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
952: end if;

Line 971: i_method_name varchar2(2000) := 'ecx_inbound_trig.getmsg_from_queue';

967: i_queue_name IN varchar2,
968: i_msgid OUT NOCOPY RAW
969: )
970: is
971: i_method_name varchar2(2000) := 'ecx_inbound_trig.getmsg_from_queue';
972: v_message system.ecxmsg;
973: v_dequeueoptions dbms_aq.dequeue_options_t;
974: v_messageproperties dbms_aq.message_properties_t;
975: c_nummessages CONSTANT INTEGER :=1;

Line 1072: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');

1068: exception
1069: when ecx_utils.program_exit then
1070: raise;
1071: when others then
1072: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1073: if(l_unexpectedEnabled) then
1074: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1075: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1076: end if;

Line 1091: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';

1087: )
1088: is
1089:
1090:
1091: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1092: e_qtimeout exception;
1093:
1094: i_out_msgid raw(16);
1095: i_standard_type varchar2(20);

Line 1305: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');

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;
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);

Line 1331: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';

1327: i_document_number IN varchar2,
1328: i_tp_detail_id IN pls_integer
1329: )
1330: is
1331: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1332: v_message system.ecxmsg;
1333: v_enqueueoptions dbms_aq.enqueue_options_t;
1334: v_messageproperties dbms_aq.message_properties_t;
1335: i_msgid raw(16);

Line 1579: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');

1575: end if;
1576: raise ecx_utils.program_exit;
1577: when others then
1578: i_hub_user_id := null;
1579: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1580: if(l_unexpectedEnabled) then
1581: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1582: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1583: end if;

Line 1596: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_queue';

1592: i_queue_name IN varchar2,
1593: i_debug_level IN pls_integer
1594: )
1595: is
1596: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_queue';
1597: v_msgid raw(16);
1598: i_logdir varchar2(200);
1599: i_trigger_id pls_integer;
1600:

Line 1666: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';

1662: ecx_debug.print_log;
1663: ecx_debug.disable_debug;
1664: END IF;
1665: when others then
1666: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1667: if(l_unexpectedEnabled) then
1668: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1669: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1670: end if;

Line 1684: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_table';

1680: i_msgid IN RAW,
1681: i_debug_level IN pls_integer
1682: )
1683: is
1684: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_table';
1685: i_logdir varchar2(200);
1686: i_trigger_id pls_integer;
1687:
1688: -- logging enabled

Line 1751: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';

1747: ecx_debug.disable_debug;
1748: END IF;
1749:
1750: when others then
1751: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1752: if(l_unexpectedEnabled) then
1753: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1754: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1755: end if;

Line 1773: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';

1769: i_debug_level IN pls_integer
1770: )
1771: is
1772: g_instlmode VARCHAR2(100);
1773: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';
1774: i_logdir varchar2(200);
1775: i_logfile varchar2(200);
1776: msg_not_found exception;
1777:

Line 1999: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');

1995: close get_msg;
1996: raise;
1997: when others then
1998: --ecx_utils.g_map_id := -1;
1999: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2000: if(l_unexpectedEnabled) then
2001: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2002: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2003: end if;

Line 2027: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';

2023: i_debug_level IN pls_integer,
2024: i_trigger_id OUT NOCOPY pls_integer
2025: )
2026: is
2027: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';
2028: i_logdir varchar2(200);
2029: i_logfile varchar2(200);
2030: PRAGMA AUTONOMOUS_TRANSACTION;
2031: msg_not_found exception;

Line 2225: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');

2221: close get_msg;
2222: rollback;
2223: when others then
2224: --ecx_utils.g_map_id := -1;
2225: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2226: if(l_unexpectedEnabled) then
2227: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2228: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2229: end if;

Line 2251: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxml';

2247: i_message_standard IN varchar2,
2248: i_message_type IN varchar2
2249: )
2250: is
2251: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxml';
2252: i_logdir varchar2(200);
2253: i_logfile varchar2(200);
2254: i_map_id pls_integer;
2255: g_instlmode VARCHAR2(100);

Line 2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');

2448:
2449: when others then
2450: --dbms_lob.freetemporary(o_payload);
2451: --ecx_utils.g_map_id := -1;
2452: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2453: if(l_unexpectedEnabled) then
2454: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2455: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2456: ecx_utils.i_errparams),i_method_name);

Line 2502: ecx_inbound_trig.wrap_validate_message

2498:
2499: */
2500:
2501: begin
2502: ecx_inbound_trig.wrap_validate_message
2503: (
2504: i_msgid,
2505: i_debug_level
2506: );

Line 2549: l_method_name varchar2(200):='ecx_inbound_trig.raiseEvent';

2545: i_rcv_tp_id in pls_integer,
2546: i_payload IN clob,
2547: i_no_routing in varchar2)
2548: as
2549: l_method_name varchar2(200):='ecx_inbound_trig.raiseEvent';
2550: l_event wf_event_t;
2551: l_event_name varchar2(100) :='oracle.apps.ecx.inbound.process_at_java';
2552: l_event_key varchar (100);
2553: l_process_id varchar2(200);

Line 2636: end ecx_inbound_trig;

2632: i_errcode );
2633: end;
2634: end setWFFunctionErrorStatus;
2635:
2636: end ecx_inbound_trig;
2637: