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.16.12000000.3 2007/09/18 15:35:00 cpeixoto 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 510: ecx_debug.setErrorInfo(1,20,SQLERRM||' - ECX_INBOUND_TRIG.processXMLData ');

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

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

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

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

929: end if;
930: raise ecx_utils.program_exit;
931: when others then
932: --ecx_utils.g_map_id := -1;
933: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.VALIDATE_MESSAGE ');
934: if(l_unexpectedEnabled) then
935: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
936: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
937: end if;

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

952: i_queue_name IN varchar2,
953: i_msgid OUT NOCOPY RAW
954: )
955: is
956: i_method_name varchar2(2000) := 'ecx_inbound_trig.getmsg_from_queue';
957: v_message system.ecxmsg;
958: v_dequeueoptions dbms_aq.dequeue_options_t;
959: v_messageproperties dbms_aq.message_properties_t;
960: c_nummessages CONSTANT INTEGER :=1;

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

1053: exception
1054: when ecx_utils.program_exit then
1055: raise;
1056: when others then
1057: ecx_debug.setErrorInfo(2,30,SQLERRM||' - ECX_INBOUND_TRIG.GETMSG_FROM_QUEUE');
1058: if(l_unexpectedEnabled) then
1059: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1060: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1061: end if;

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

1072: )
1073: is
1074:
1075:
1076: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1077: e_qtimeout exception;
1078:
1079: i_out_msgid raw(16);
1080: i_standard_type varchar2(20);

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

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

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

1312: i_document_number IN varchar2,
1313: i_tp_detail_id IN pls_integer
1314: )
1315: is
1316: i_method_name varchar2(2000) := 'ecx_inbound_trig.put_on_outbound';
1317: v_message system.ecxmsg;
1318: v_enqueueoptions dbms_aq.enqueue_options_t;
1319: v_messageproperties dbms_aq.message_properties_t;
1320: i_msgid raw(16);

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

1560: end if;
1561: raise ecx_utils.program_exit;
1562: when others then
1563: i_hub_user_id := null;
1564: ecx_debug.setErrorInfo(2,30, SQLERRM|| ' - ECX_INBOUND_TRIG.PUT_ON_OUTBOUND');
1565: if(l_unexpectedEnabled) then
1566: --ecx_debug.log(l_statement,ecx_utils.i_errbuf,i_method_name);
1567: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1568: end if;

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

1577: i_queue_name IN varchar2,
1578: i_debug_level IN pls_integer
1579: )
1580: is
1581: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_queue';
1582: v_msgid raw(16);
1583: i_logdir varchar2(200);
1584: i_trigger_id pls_integer;
1585:

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

1647: ecx_debug.print_log;
1648: ecx_debug.disable_debug;
1649: END IF;
1650: when others then
1651: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_QUEUE';
1652: if(l_unexpectedEnabled) then
1653: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1654: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1655: end if;

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

1665: i_msgid IN RAW,
1666: i_debug_level IN pls_integer
1667: )
1668: is
1669: i_method_name varchar2(2000) := 'ecx_inbound_trig.processmsg_from_table';
1670: i_logdir varchar2(200);
1671: i_trigger_id pls_integer;
1672:
1673: -- logging enabled

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

1732: ecx_debug.disable_debug;
1733: END IF;
1734:
1735: when others then
1736: ecx_utils.i_errbuf := SQLERRM || ' - ECX_INBOUND_TRIG.PROCESSMSG_FROM_TABLE';
1737: if(l_unexpectedEnabled) then
1738: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1739: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1740: end if;

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

1754: i_debug_level IN pls_integer
1755: )
1756: is
1757: g_instlmode VARCHAR2(100);
1758: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';
1759: i_logdir varchar2(200);
1760: i_logfile varchar2(200);
1761: msg_not_found exception;
1762:

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

1980: close get_msg;
1981: raise;
1982: when others then
1983: --ecx_utils.g_map_id := -1;
1984: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
1985: if(l_unexpectedEnabled) then
1986: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1987: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
1988: end if;

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

2008: i_debug_level IN pls_integer,
2009: i_trigger_id OUT NOCOPY pls_integer
2010: )
2011: is
2012: i_method_name varchar2(2000) := 'ecx_inbound_trig.wrap_validate_message';
2013: i_logdir varchar2(200);
2014: i_logfile varchar2(200);
2015: PRAGMA AUTONOMOUS_TRANSACTION;
2016: msg_not_found exception;

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

2206: close get_msg;
2207: rollback;
2208: when others then
2209: --ecx_utils.g_map_id := -1;
2210: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2211: if(l_unexpectedEnabled) then
2212: --ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
2213: ecx_debug.log(l_unexpected,ecx_debug.getMessage(ecx_utils.i_errbuf,ecx_utils.i_errparams),i_method_name);
2214: end if;

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

2232: i_message_standard IN varchar2,
2233: i_message_type IN varchar2
2234: )
2235: is
2236: i_method_name varchar2(2000) := 'ecx_inbound_trig.processxml';
2237: i_logdir varchar2(200);
2238: i_logfile varchar2(200);
2239: i_map_id pls_integer;
2240: g_instlmode VARCHAR2(100);

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

2410:
2411: when others then
2412: --dbms_lob.freetemporary(o_payload);
2413: --ecx_utils.g_map_id := -1;
2414: ecx_debug.setErrorInfo(2,30,SQLERRM || ' - ECX_INBOUND_TRIG.WRAP_VALIDATE_MESSAGE');
2415: if(l_unexpectedEnabled) then
2416: ecx_debug.log(l_unexpected,'Ret Code',ecx_utils.i_ret_code,i_method_name);
2417: ecx_debug.log(l_unexpected, 'Ret Msg ',ecx_debug.getMessage(ecx_utils.i_errbuf,
2418: ecx_utils.i_errparams),i_method_name);

Line 2464: ecx_inbound_trig.wrap_validate_message

2460:
2461: */
2462:
2463: begin
2464: ecx_inbound_trig.wrap_validate_message
2465: (
2466: i_msgid,
2467: i_debug_level
2468: );

Line 2498: end ecx_inbound_trig;

2494: i_errbuf := ecx_utils.i_errbuf;
2495: raise;
2496: end reprocess;
2497:
2498: end ecx_inbound_trig;