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_NEW dependencies on ECX_INBOUND_NEW

Line 1: PACKAGE BODY ecx_inbound_new as

1: PACKAGE BODY ecx_inbound_new as
2: --$Header: ECXINNB.pls 120.7 2011/03/14 09:37:12 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;

Line 32: i_method_name varchar2(2000) := 'ecx_inbound_new.clean_up_tables';

28: node_info_stack node_info_table;
29: Load_XML_Exception Exception;
30:
31: procedure clean_up_tables is
32: i_method_name varchar2(2000) := 'ecx_inbound_new.clean_up_tables';
33:
34: begin
35: l_level_stack.DELETE;
36: ecx_print_local.i_tmpxml.DELETE;

Line 42: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.CLEAN_UP_TABLES');

38: ecx_utils.g_node_tbl.DELETE;
39:
40: exception
41: when others then
42: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.CLEAN_UP_TABLES');
43: if(l_unexpectedEnabled) then
44: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
45: end if;
46: raise ecx_utils.program_exit;

Line 58: i_method_name varchar2(2000) := 'ecx_inbound_new.get_element_value';

54: x_found OUT NOCOPY boolean,
55: x_elem_value OUT NOCOPY varchar2
56: ) is
57:
58: i_method_name varchar2(2000) := 'ecx_inbound_new.get_element_value';
59: begin
60: x_found := false;
61: x_elem_value := null;
62:

Line 74: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_ELEMENT_VALUE');

70: end loop;
71:
72: exception
73: when others then
74: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_ELEMENT_VALUE');
75: if(l_unexpectedEnabled) then
76: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
77: end if;
78: raise ecx_utils.program_exit;

Line 87: i_method_name varchar2(2000) := 'ecx_inbound_new.setDocLogsAttributes';

83: p_nodeList IN ECX_NODE_TBL_TYPE,
84: p_count IN pls_integer
85: ) return boolean is
86:
87: i_method_name varchar2(2000) := 'ecx_inbound_new.setDocLogsAttributes';
88: cursor get_attributes
89: (
90: p_standard_id IN pls_integer
91: )

Line 168: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.setDocLogsAttributes');

164: end if;
165: raise ecx_utils.program_exit;
166:
167: when others then
168: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.setDocLogsAttributes');
169: if(l_unexpectedEnabled) then
170: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
171: end if;
172: if (l_procedureEnabled) then

Line 180: i_method_name varchar2(2000) := 'ecx_inbound_new.print_stack';

176: end setDocLogsAttributes;
177:
178:
179: procedure print_stack is
180: i_method_name varchar2(2000) := 'ecx_inbound_new.print_stack';
181: begin
182: if(l_statementEnabled) then
183: ecx_debug.log(l_statement,'Level Stack Status','====',i_method_name);
184: end if;

Line 193: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PRINT_STACK');

189: end if;
190: end loop;
191: exception
192: when others then
193: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PRINT_STACK');
194: if(l_unexpectedEnabled) then
195: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
196: end if;
197: raise ecx_utils.program_exit;

Line 205: i_method_name varchar2(2000) := 'ecx_inbound_new.popstack';

201: procedure popStack
202: (
203: p_level in pls_integer
204: ) is
205: i_method_name varchar2(2000) := 'ecx_inbound_new.popstack';
206:
207: begin
208: if (l_procedureEnabled) then
209: ecx_debug.push(i_method_name);

Line 248: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popStack');

244: end if;
245: raise ecx_utils.program_exit;
246:
247: when others then
248: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popStack');
249: if(l_unexpectedEnabled) then
250: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
251: end if;
252: if (l_procedureEnabled) then

Line 263: i_method_name varchar2(2000) := 'ecx_inbound_new.pushstack';

259: procedure pushStack
260: (
261: i in pls_integer
262: ) is
263: i_method_name varchar2(2000) := 'ecx_inbound_new.pushstack';
264: begin
265: if (l_procedureEnabled) then
266: ecx_debug.push(i_method_name);
267: end if;

Line 322: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushStack');

318: end if;
319: raise ecx_utils.program_exit;
320:
321: when others then
322: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushStack');
323: if(l_unexpectedEnabled) then
324: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
325: end if;
326: if (l_procedureEnabled) then

Line 334: i_method_name varchar2(2000) := 'ecx_inbound_new.popall';

330: end pushStack;
331:
332:
333: procedure popall is
334: i_method_name varchar2(2000) := 'ecx_inbound_new.popall';
335: begin
336: if (l_procedureEnabled) then
337: ecx_debug.push(i_method_name);
338: end if;

Line 364: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popall');

360: end if;
361: raise ecx_utils.program_exit;
362:
363: when others then
364: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popall');
365: if(l_unexpectedEnabled) then
366: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
367: end if;
368: if (l_procedureEnabled) then

Line 382: i_method_name varchar2(2000) := 'ecx_inbound_new.get_cond_node_value';

378: p_node_name IN Varchar2,
379: p_xmlParentIndex IN pls_integer,
380: x_node_value OUT NOCOPY Varchar2
381: ) is
382: i_method_name varchar2(2000) := 'ecx_inbound_new.get_cond_node_value';
383: begin
384: if (l_procedureEnabled) then
385: ecx_debug.push(i_method_name);
386: end if;

Line 423: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_COND_NODE_VALUE');

419: end if;
420: raise ecx_utils.program_exit;
421:
422: when others then
423: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_COND_NODE_VALUE');
424: if(l_unexpectedEnabled) then
425: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
426: end if;
427: if (l_procedureEnabled) then

Line 446: i_method_name varchar2(2000) := 'ecx_inbound_new.get_node_id';

442: p_node_value IN varchar2,
443: x_node_pos OUT NOCOPY pls_integer
444: ) return pls_integer IS
445:
446: i_method_name varchar2(2000) := 'ecx_inbound_new.get_node_id';
447:
448: i pls_integer;
449: l_node_id pls_integer := -1;
450: l_cond_node_value Varchar2(4000) := null;

Line 551: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_NODE_ID');

547: end if;
548: raise ecx_utils.program_exit;
549:
550: when others then
551: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_NODE_ID');
552: if(l_unexpectedEnabled) then
553: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
554: end if;
555: if (l_procedureEnabled) then

Line 568: i_method_name varchar2(2000) := 'ecx_inbound_new.process_node';

564: p_value IN OUT NOCOPY varchar2,
565: p_clob_value IN Clob default null,
566: p_cdata_flag IN varchar2 default 'N') IS
567:
568: i_method_name varchar2(2000) := 'ecx_inbound_new.process_node';
569:
570: l_cat_id pls_integer;
571: l_return_status Varchar2(1);
572: l_msg_count pls_integer;

Line 695: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_NODE');

691: end if;
692: raise ecx_utils.program_exit;
693:
694: WHEN others then
695: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_NODE');
696: if(l_unexpectedEnabled) then
697: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
698: end if;
699: if (l_procedureEnabled) then

Line 708: i_method_name varchar2(2000) := 'ecx_inbound_new.printNodeInfoStack';

704:
705:
706: procedure printNodeInfoStack
707: is
708: i_method_name varchar2(2000) := 'ecx_inbound_new.printNodeInfoStack';
709: begin
710: for i in node_info_stack.first..node_info_stack.last loop
711: if(l_statementEnabled) then
712: ecx_debug.log(l_statement,'Stack('||i||')',

Line 722: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.printNodeInfoStack');

718: end if;
719: end loop;
720: exception
721: when others then
722: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.printNodeInfoStack');
723: if(l_unexpectedEnabled) then
724: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
725: end if;
726: raise ecx_utils.program_exit;

Line 733: i_method_name varchar2(2000) := 'ecx_inbound_new.pushNodeInfoStack';

729:
730: procedure pushNodeInfoStack (
731: p_parent_index IN pls_integer
732: ) is
733: i_method_name varchar2(2000) := 'ecx_inbound_new.pushNodeInfoStack';
734: l_stack_indx pls_integer;
735:
736: begin
737: l_stack_indx := node_info_stack.COUNT + 1;

Line 748: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushNodeInfoStack');

744: WHEN ecx_utils.program_exit then
745: raise ecx_utils.program_exit;
746:
747: when others then
748: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushNodeInfoStack');
749: if(l_unexpectedEnabled) then
750: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
751: end if;
752: raise ecx_utils.program_exit;

Line 760: i_method_name varchar2(2000) := 'ecx_inbound_new.popNodeInfoStack';

756: procedure popNodeInfoStack (
757: p_parent_index IN pls_integer
758: ) is
759:
760: i_method_name varchar2(2000) := 'ecx_inbound_new.popNodeInfoStack';
761: l_stack_indx pls_integer;
762:
763: begin
764: l_stack_indx := node_info_stack.COUNT;

Line 783: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popNodeInfoStack');

779: WHEN ecx_utils.program_exit then
780: raise ecx_utils.program_exit;
781:
782: when others then
783: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popNodeInfoStack');
784: if(l_unexpectedEnabled) then
785: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
786: end if;
787: raise ecx_utils.program_exit;

Line 800: i_method_name varchar2(2000) := 'ecx_inbound_new.processLevel';

796: p_count IN pls_integer,
797: x_err_msg OUT NOCOPY varchar2
798: ) is
799:
800: i_method_name varchar2(2000) := 'ecx_inbound_new.processLevel';
801:
802: l_node_name Varchar2(2000);
803: l_node_value Varchar2(4000);
804:

Line 921: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESSLEVEL');

917: -- to determine if any error occurred.
918:
919: when others then
920: clean_up_tables;
921: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESSLEVEL');
922: if(l_unexpectedEnabled) then
923: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
924: end if;
925: x_err_msg := ecx_utils.i_errbuf;

Line 935: i_method_name varchar2(2000) := 'ecx_inbound_new.startDocument';

931:
932:
933: procedure startDocument is
934:
935: i_method_name varchar2(2000) := 'ecx_inbound_new.startDocument';
936: i_root_name varchar2(2000);
937:
938: BEGIN
939: if (l_procedureEnabled) then

Line 985: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.STARTDOCUMENT');

981: end if;
982: raise ecx_utils.program_exit;
983:
984: WHEN OTHERS THEN
985: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.STARTDOCUMENT');
986: if(l_unexpectedEnabled) then
987: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
988: end if;
989: if (l_procedureEnabled) then

Line 1000: i_method_name varchar2(2000) := 'ecx_inbound_new.endDocument';

996: procedure endDocument (
997: x_xmlclob OUT NOCOPY clob,
998: x_parseXML OUT NOCOPY boolean) is
999:
1000: i_method_name varchar2(2000) := 'ecx_inbound_new.endDocument';
1001: begin
1002: if (l_procedureEnabled) then
1003: ecx_debug.push(i_method_name);
1004: end if;

Line 1038: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.ENDDOCUMENT');

1034: end if;
1035: raise ecx_utils.program_exit;
1036:
1037: WHEN OTHERS THEN
1038: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.ENDDOCUMENT');
1039: if(l_unexpectedEnabled) then
1040: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1041: end if;
1042: if (l_procedureEnabled) then

Line 1066: i_method_name varchar2(2000) := 'ecx_inbound_new.raise_loadxml_err';

1062: p_err_code IN pls_integer,
1063: p_err_msg IN Varchar2
1064: ) is
1065:
1066: i_method_name varchar2(2000) := 'ecx_inbound_new.raise_loadxml_err';
1067:
1068: begin
1069: if (p_err_code = PROCESS_LEVEL_EXCEPTION) then
1070: raise ecx_utils.program_exit;

Line 1124: i_method_name varchar2(2000) := 'ecx_inbound_new.process_xml_doc';

1120: x_xmlclob OUT NOCOPY clob,
1121: x_parseXML OUT NOCOPY boolean
1122: ) is
1123:
1124: i_method_name varchar2(2000) := 'ecx_inbound_new.process_xml_doc';
1125: l_map_code Varchar2(50);
1126: l_err_code pls_integer;
1127: l_err_msg Varchar2(2000);
1128:

Line 1167: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_XML_DOC');

1163: raise ecx_utils.program_exit;
1164:
1165: WHEN OTHERS THEN
1166: clean_up_tables;
1167: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_XML_DOC');
1168: if(l_unexpectedEnabled) then
1169: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1170: end if;
1171: if (l_procedureEnabled) then

Line 1178: END ecx_inbound_new;

1174: raise ecx_utils.program_exit;
1175: end process_xml_doc;
1176:
1177:
1178: END ecx_inbound_new;