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.2.12000000.5 2007/07/11 12:20:19 susaha 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 684: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_NODE');

680: end if;
681: raise ecx_utils.program_exit;
682:
683: WHEN others then
684: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_NODE');
685: if(l_unexpectedEnabled) then
686: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
687: end if;
688: if (l_procedureEnabled) then

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

693:
694:
695: procedure printNodeInfoStack
696: is
697: i_method_name varchar2(2000) := 'ecx_inbound_new.printNodeInfoStack';
698: begin
699: for i in node_info_stack.first..node_info_stack.last loop
700: if(l_statementEnabled) then
701: ecx_debug.log(l_statement,'Stack('||i||')',

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

707: end if;
708: end loop;
709: exception
710: when others then
711: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.printNodeInfoStack');
712: if(l_unexpectedEnabled) then
713: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
714: end if;
715: raise ecx_utils.program_exit;

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

718:
719: procedure pushNodeInfoStack (
720: p_parent_index IN pls_integer
721: ) is
722: i_method_name varchar2(2000) := 'ecx_inbound_new.pushNodeInfoStack';
723: l_stack_indx pls_integer;
724:
725: begin
726: l_stack_indx := node_info_stack.COUNT + 1;

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

733: WHEN ecx_utils.program_exit then
734: raise ecx_utils.program_exit;
735:
736: when others then
737: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushNodeInfoStack');
738: if(l_unexpectedEnabled) then
739: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
740: end if;
741: raise ecx_utils.program_exit;

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

745: procedure popNodeInfoStack (
746: p_parent_index IN pls_integer
747: ) is
748:
749: i_method_name varchar2(2000) := 'ecx_inbound_new.popNodeInfoStack';
750: l_stack_indx pls_integer;
751:
752: begin
753: l_stack_indx := node_info_stack.COUNT;

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

768: WHEN ecx_utils.program_exit then
769: raise ecx_utils.program_exit;
770:
771: when others then
772: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popNodeInfoStack');
773: if(l_unexpectedEnabled) then
774: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
775: end if;
776: raise ecx_utils.program_exit;

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

785: p_count IN pls_integer,
786: x_err_msg OUT NOCOPY varchar2
787: ) is
788:
789: i_method_name varchar2(2000) := 'ecx_inbound_new.processLevel';
790:
791: l_node_name Varchar2(2000);
792: l_node_value Varchar2(4000);
793:

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

906: -- to determine if any error occurred.
907:
908: when others then
909: clean_up_tables;
910: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESSLEVEL');
911: if(l_unexpectedEnabled) then
912: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
913: end if;
914: x_err_msg := ecx_utils.i_errbuf;

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

920:
921:
922: procedure startDocument is
923:
924: i_method_name varchar2(2000) := 'ecx_inbound_new.startDocument';
925: i_root_name varchar2(2000);
926:
927: BEGIN
928: if (l_procedureEnabled) then

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

970: end if;
971: raise ecx_utils.program_exit;
972:
973: WHEN OTHERS THEN
974: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.STARTDOCUMENT');
975: if(l_unexpectedEnabled) then
976: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
977: end if;
978: if (l_procedureEnabled) then

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

985: procedure endDocument (
986: x_xmlclob OUT NOCOPY clob,
987: x_parseXML OUT NOCOPY boolean) is
988:
989: i_method_name varchar2(2000) := 'ecx_inbound_new.endDocument';
990: begin
991: if (l_procedureEnabled) then
992: ecx_debug.push(i_method_name);
993: end if;

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

1023: end if;
1024: raise ecx_utils.program_exit;
1025:
1026: WHEN OTHERS THEN
1027: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.ENDDOCUMENT');
1028: if(l_unexpectedEnabled) then
1029: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1030: end if;
1031: if (l_procedureEnabled) then

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

1051: p_err_code IN pls_integer,
1052: p_err_msg IN Varchar2
1053: ) is
1054:
1055: i_method_name varchar2(2000) := 'ecx_inbound_new.raise_loadxml_err';
1056:
1057: begin
1058: if (p_err_code = PROCESS_LEVEL_EXCEPTION) then
1059: raise ecx_utils.program_exit;

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

1109: x_xmlclob OUT NOCOPY clob,
1110: x_parseXML OUT NOCOPY boolean
1111: ) is
1112:
1113: i_method_name varchar2(2000) := 'ecx_inbound_new.process_xml_doc';
1114: l_map_code Varchar2(50);
1115: l_err_code pls_integer;
1116: l_err_msg Varchar2(2000);
1117:

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

1152: raise ecx_utils.program_exit;
1153:
1154: WHEN OTHERS THEN
1155: clean_up_tables;
1156: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.PROCESS_XML_DOC');
1157: if(l_unexpectedEnabled) then
1158: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1159: end if;
1160: if (l_procedureEnabled) then

Line 1167: END ecx_inbound_new;

1163: raise ecx_utils.program_exit;
1164: end process_xml_doc;
1165:
1166:
1167: END ecx_inbound_new;