APPS.ECX_INBOUND_NEW dependencies on ECX_UTILS

Line 38: ecx_utils.g_node_tbl.DELETE;

34: begin
35: l_level_stack.DELETE;
36: ecx_print_local.i_tmpxml.DELETE;
37: ecx_print_local.l_node_stack.DELETE;
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');

Line 44: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);

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;
47: end clean_up_tables;
48:

Line 46: raise ecx_utils.program_exit;

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;
47: end clean_up_tables;
48:
49:
50: procedure get_element_value (

Line 76: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);

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;
79: end get_element_value;
80:

Line 78: raise ecx_utils.program_exit;

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;
79: end get_element_value;
80:
81:
82: function setDocLogsAttributes (

Line 113: if ecx_utils.g_standard_id is null

109: end if;
110: i_found := false;
111: i_update := false;
112:
113: if ecx_utils.g_standard_id is null
114: then
115: if (l_procedureEnabled) then
116: ecx_debug.pop(i_method_name);
117: end if;

Line 122: for c1 in get_Attributes(p_standard_id => ecx_utils.g_standard_id)

118: return true;
119: end if;
120:
121: /** Get all the Attributes and capture the value **/
122: for c1 in get_Attributes(p_standard_id => ecx_utils.g_standard_id)
123: loop
124: if (c1.attribute_name is not null and c1.element_tag_name is not null) then
125: get_element_value (p_nodeList, p_count, c1.element_tag_name, i_found, i_value);
126:

Line 148: i_string := i_string || ' where msgid = HEXTORAW('||i_single||ecx_utils.g_msgid||i_single||')';

144: if i_update
145: then
146: /** remove the last , and put the statement for the where clause **/
147: i_string := substr(i_string,1,length(i_string)-1);
148: i_string := i_string || ' where msgid = HEXTORAW('||i_single||ecx_utils.g_msgid||i_single||')';
149: if(l_statementEnabled) then
150: ecx_debug.log(l_statement,'i_string',i_string,i_method_name);
151: end if;
152: execute immediate i_string;

Line 161: WHEN ecx_utils.program_exit then

157:
158: return i_update;
159:
160: exception
161: WHEN ecx_utils.program_exit then
162: if (l_procedureEnabled) then
163: ecx_debug.pop(i_method_name);
164: end if;
165: raise ecx_utils.program_exit;

Line 165: raise ecx_utils.program_exit;

161: WHEN ecx_utils.program_exit then
162: if (l_procedureEnabled) then
163: ecx_debug.pop(i_method_name);
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

Line 170: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
173: ecx_debug.pop(i_method_name);
174: end if;

Line 175: raise ecx_utils.program_exit;

171: end if;
172: if (l_procedureEnabled) then
173: ecx_debug.pop(i_method_name);
174: end if;
175: raise ecx_utils.program_exit;
176: end setDocLogsAttributes;
177:
178:
179: procedure print_stack is

Line 195: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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;
198: end print_stack;
199:

Line 197: raise ecx_utils.program_exit;

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;
198: end print_stack;
199:
200:
201: procedure popStack

Line 241: WHEN ecx_utils.program_exit then

237: ecx_debug.pop(i_method_name);
238: end if;
239:
240: exception
241: WHEN ecx_utils.program_exit then
242: if (l_procedureEnabled) then
243: ecx_debug.pop(i_method_name);
244: end if;
245: raise ecx_utils.program_exit;

Line 245: raise ecx_utils.program_exit;

241: WHEN ecx_utils.program_exit then
242: if (l_procedureEnabled) then
243: ecx_debug.pop(i_method_name);
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

Line 250: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
253: ecx_debug.pop(i_method_name);
254: end if;

Line 255: raise ecx_utils.program_exit;

251: end if;
252: if (l_procedureEnabled) then
253: ecx_debug.pop(i_method_name);
254: end if;
255: raise ecx_utils.program_exit;
256: end popStack;
257:
258:
259: procedure pushStack

Line 315: WHEN ecx_utils.program_exit then

311: ecx_debug.pop(i_method_name);
312: end if;
313:
314: exception
315: WHEN ecx_utils.program_exit then
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
318: end if;
319: raise ecx_utils.program_exit;

Line 319: raise ecx_utils.program_exit;

315: WHEN ecx_utils.program_exit then
316: if (l_procedureEnabled) then
317: ecx_debug.pop(i_method_name);
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

Line 324: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
327: ecx_debug.pop(i_method_name);
328: end if;

Line 329: raise ecx_utils.program_exit;

325: end if;
326: if (l_procedureEnabled) then
327: ecx_debug.pop(i_method_name);
328: end if;
329: raise ecx_utils.program_exit;
330: end pushStack;
331:
332:
333: procedure popall is

Line 357: WHEN ecx_utils.program_exit then

353: if (l_procedureEnabled) then
354: ecx_debug.pop(i_method_name);
355: end if;
356: exception
357: WHEN ecx_utils.program_exit then
358: if (l_procedureEnabled) then
359: ecx_debug.pop(i_method_name);
360: end if;
361: raise ecx_utils.program_exit;

Line 361: raise ecx_utils.program_exit;

357: WHEN ecx_utils.program_exit then
358: if (l_procedureEnabled) then
359: ecx_debug.pop(i_method_name);
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

Line 366: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
369: ecx_debug.pop(i_method_name);
370: end if;

Line 371: raise ecx_utils.program_exit;

367: end if;
368: if (l_procedureEnabled) then
369: ecx_debug.pop(i_method_name);
370: end if;
371: raise ecx_utils.program_exit;
372: end popall;
373:
374:
375: procedure get_cond_node_value(

Line 416: WHEN ecx_utils.program_exit then

412: ecx_debug.pop(i_method_name);
413: end if;
414:
415: exception
416: WHEN ecx_utils.program_exit then
417: if (l_procedureEnabled) then
418: ecx_debug.pop(i_method_name);
419: end if;
420: raise ecx_utils.program_exit;

Line 420: raise ecx_utils.program_exit;

416: WHEN ecx_utils.program_exit then
417: if (l_procedureEnabled) then
418: ecx_debug.pop(i_method_name);
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

Line 425: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
428: ecx_debug.pop(i_method_name);
429: end if;

Line 430: raise ecx_utils.program_exit;

426: end if;
427: if (l_procedureEnabled) then
428: ecx_debug.pop(i_method_name);
429: end if;
430: raise ecx_utils.program_exit;
431: end get_cond_node_value;
432:
433:
434: function get_node_id (

Line 466: ecx_debug.log(l_statement, 'No of Elements in Source', ecx_utils.g_source.count,i_method_name);

462: ecx_debug.log(l_statement, 'p_parent_node_id', p_parent_node_id,i_method_name);
463: ecx_debug.log(l_statement, 'p_parent_node_pos', p_parent_node_pos,i_method_name);
464: ecx_debug.log(l_statement, 'p_occur', p_occur,i_method_name);
465: ecx_debug.log(l_statement, 'p_node_value', p_node_value,i_method_name);
466: ecx_debug.log(l_statement, 'No of Elements in Source', ecx_utils.g_source.count,i_method_name);
467: end if;
468:
469: x_node_pos := -1;
470: i_parent_node_pos := p_parent_node_pos;

Line 478: for i in i_parent_node_pos..ecx_utils.g_source.last

474: if(p_parent_node_pos < 0) then
475: i_parent_node_pos := 0;
476: end if;
477:
478: for i in i_parent_node_pos..ecx_utils.g_source.last
479: loop
480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
482: then

Line 480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and

476: end if;
477:
478: for i in i_parent_node_pos..ecx_utils.g_source.last
479: loop
480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
482: then
483: p_cond_node := ecx_utils.g_source(i).cond_node;
484: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;

Line 481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)

477:
478: for i in i_parent_node_pos..ecx_utils.g_source.last
479: loop
480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
482: then
483: p_cond_node := ecx_utils.g_source(i).cond_node;
484: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
485:

Line 483: p_cond_node := ecx_utils.g_source(i).cond_node;

479: loop
480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
482: then
483: p_cond_node := ecx_utils.g_source(i).cond_node;
484: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
485:
486: if (p_cond_node is not null) then
487:

Line 484: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;

480: if (ecx_utils.g_source(i).attribute_name = p_node_name) and
481: (ecx_utils.g_source(i).parent_attribute_id = p_parent_node_id)
482: then
483: p_cond_node := ecx_utils.g_source(i).cond_node;
484: p_cond_node_type := ecx_utils.g_source(i).cond_node_type;
485:
486: if (p_cond_node is not null) then
487:
488: if(l_statementEnabled) then

Line 504: if (l_cond_node_value = ecx_utils.g_source(i).cond_value) then

500: l_cond_node_value := p_node_value;
501: end if;
502:
503: -- find the mapping that match the condition.
504: if (l_cond_node_value = ecx_utils.g_source(i).cond_value) then
505: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
506: then
507: x_node_pos := i;
508: l_node_id := ecx_utils.g_source(i).attribute_id;

Line 505: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )

501: end if;
502:
503: -- find the mapping that match the condition.
504: if (l_cond_node_value = ecx_utils.g_source(i).cond_value) then
505: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
506: then
507: x_node_pos := i;
508: l_node_id := ecx_utils.g_source(i).attribute_id;
509: exit;

Line 508: l_node_id := ecx_utils.g_source(i).attribute_id;

504: if (l_cond_node_value = ecx_utils.g_source(i).cond_value) then
505: if ( p_parent_node_id = ecx_utils.g_source(i).parent_attribute_id )
506: then
507: x_node_pos := i;
508: l_node_id := ecx_utils.g_source(i).attribute_id;
509: exit;
510: end if;
511: end if;
512:

Line 516: ((ecx_utils.g_source(i).occurrence is null) or

512:
513: -- there is no conditional mapping. This is a mapping
514: -- depends on the occurrence.
515: elsif
516: ((ecx_utils.g_source(i).occurrence is null) or
517: (p_occur = ecx_utils.g_source(i).occurrence)) then
518: x_node_pos := i;
519: l_node_id := ecx_utils.g_source(i).attribute_id;
520: exit;

Line 517: (p_occur = ecx_utils.g_source(i).occurrence)) then

513: -- there is no conditional mapping. This is a mapping
514: -- depends on the occurrence.
515: elsif
516: ((ecx_utils.g_source(i).occurrence is null) or
517: (p_occur = ecx_utils.g_source(i).occurrence)) then
518: x_node_pos := i;
519: l_node_id := ecx_utils.g_source(i).attribute_id;
520: exit;
521:

Line 519: l_node_id := ecx_utils.g_source(i).attribute_id;

515: elsif
516: ((ecx_utils.g_source(i).occurrence is null) or
517: (p_occur = ecx_utils.g_source(i).occurrence)) then
518: x_node_pos := i;
519: l_node_id := ecx_utils.g_source(i).attribute_id;
520: exit;
521:
522: elsif (l_node_id = p_parent_node_id) then
523: if(l_statementEnabled) then

Line 527: l_node_id := ecx_utils.g_source(i).attribute_id;

523: if(l_statementEnabled) then
524: ecx_debug.log(l_statement,'l_node_id', l_node_id,i_method_name);
525: end if;
526: x_node_pos := i;
527: l_node_id := ecx_utils.g_source(i).attribute_id;
528: exit;
529: end if;
530: end if;
531: end loop;

Line 544: WHEN ecx_utils.program_exit then

540: end if;
541: return (l_node_id);
542:
543: EXCEPTION
544: WHEN ecx_utils.program_exit then
545: if (l_procedureEnabled) then
546: ecx_debug.pop(i_method_name);
547: end if;
548: raise ecx_utils.program_exit;

Line 548: raise ecx_utils.program_exit;

544: WHEN ecx_utils.program_exit then
545: if (l_procedureEnabled) then
546: ecx_debug.pop(i_method_name);
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

Line 553: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
556: ecx_debug.pop(i_method_name);
557: end if;

Line 558: raise ecx_utils.program_exit;

554: end if;
555: if (l_procedureEnabled) then
556: ecx_debug.pop(i_method_name);
557: end if;
558: raise ecx_utils.program_exit;
559: END get_node_id;
560:
561:
562: procedure process_node (

Line 588: l_cat_id := ecx_utils.g_source(p_int_col_pos).xref_category_id;

584: ecx_debug.log(l_statement, 'node value', p_value,i_method_name);
585: ecx_debug.log(l_statement, 'p_cdata_flag',p_cdata_flag,i_method_name);
586: end if;
587:
588: l_cat_id := ecx_utils.g_source(p_int_col_pos).xref_category_id;
589:
590: if (l_cat_id is not null) then
591: ecx_code_conversion_pvt.convert_external_value
592: (

Line 599: p_snd_tp_id => ecx_utils.g_snd_tp_id,

595: p_msg_count => l_msg_count,
596: p_msg_data => l_msg_data,
597: p_value => p_value,
598: p_category_id => l_cat_id,
599: p_snd_tp_id => ecx_utils.g_snd_tp_id,
600: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
601: p_standard_id => ecx_utils.g_standard_id
602: );
603:

Line 600: p_rec_tp_id => ecx_utils.g_rec_tp_id ,

596: p_msg_data => l_msg_data,
597: p_value => p_value,
598: p_category_id => l_cat_id,
599: p_snd_tp_id => ecx_utils.g_snd_tp_id,
600: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
601: p_standard_id => ecx_utils.g_standard_id
602: );
603:
604: If l_return_status = 'X' OR l_return_status = 'R' Then

Line 601: p_standard_id => ecx_utils.g_standard_id

597: p_value => p_value,
598: p_category_id => l_cat_id,
599: p_snd_tp_id => ecx_utils.g_snd_tp_id,
600: p_rec_tp_id => ecx_utils.g_rec_tp_id ,
601: p_standard_id => ecx_utils.g_standard_id
602: );
603:
604: If l_return_status = 'X' OR l_return_status = 'R' Then
605: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;

Line 605: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;

601: p_standard_id => ecx_utils.g_standard_id
602: );
603:
604: If l_return_status = 'X' OR l_return_status = 'R' Then
605: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;
606: else
607: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;
608: end if;
609:

Line 607: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;

603:
604: If l_return_status = 'X' OR l_return_status = 'R' Then
605: ecx_utils.g_source(p_int_col_pos).xref_retcode := 1;
606: else
607: ecx_utils.g_source(p_int_col_pos).xref_retcode := 0;
608: end if;
609:
610:
611: if(l_statementEnabled) then

Line 613: ecx_utils.g_source(p_int_col_pos).xref_retcode,

609:
610:
611: if(l_statementEnabled) then
612: ecx_debug.log(l_statement,'xref return code',
613: ecx_utils.g_source(p_int_col_pos).xref_retcode,
614: i_method_name);
615: end if;
616:
617: if (l_return_status = ecx_code_conversion_pvt.G_RET_STS_ERROR) or

Line 639: ecx_utils.g_source(p_int_col_pos).value := p_value;

635: end if;
636:
637:
638: if ((p_value is null and p_clob_value is null) OR (p_value is not null) ) then
639: ecx_utils.g_source(p_int_col_pos).value := p_value;
640: else
641: l_len := dbms_lob.getlength(p_clob_value);
642: if(l_len <= ecx_utils.G_CLOB_VARCHAR_LEN) Then
643: /** Fix for bug 8845448*/

Line 642: if(l_len <= ecx_utils.G_CLOB_VARCHAR_LEN) Then

638: if ((p_value is null and p_clob_value is null) OR (p_value is not null) ) then
639: ecx_utils.g_source(p_int_col_pos).value := p_value;
640: else
641: l_len := dbms_lob.getlength(p_clob_value);
642: if(l_len <= ecx_utils.G_CLOB_VARCHAR_LEN) Then
643: /** Fix for bug 8845448*/
644: begin
645: dbms_lob.read(p_clob_value,l_len,1,l_temp);
646: ecx_utils.g_source(p_int_col_pos).value := l_temp;

Line 646: ecx_utils.g_source(p_int_col_pos).value := l_temp;

642: if(l_len <= ecx_utils.G_CLOB_VARCHAR_LEN) Then
643: /** Fix for bug 8845448*/
644: begin
645: dbms_lob.read(p_clob_value,l_len,1,l_temp);
646: ecx_utils.g_source(p_int_col_pos).value := l_temp;
647: ecx_utils.g_source(p_int_col_pos).clob_value := null;
648: ecx_utils.g_source(p_int_col_pos).clob_length := null;
649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception

Line 647: ecx_utils.g_source(p_int_col_pos).clob_value := null;

643: /** Fix for bug 8845448*/
644: begin
645: dbms_lob.read(p_clob_value,l_len,1,l_temp);
646: ecx_utils.g_source(p_int_col_pos).value := l_temp;
647: ecx_utils.g_source(p_int_col_pos).clob_value := null;
648: ecx_utils.g_source(p_int_col_pos).clob_length := null;
649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception
651: when others then

Line 648: ecx_utils.g_source(p_int_col_pos).clob_length := null;

644: begin
645: dbms_lob.read(p_clob_value,l_len,1,l_temp);
646: ecx_utils.g_source(p_int_col_pos).value := l_temp;
647: ecx_utils.g_source(p_int_col_pos).clob_value := null;
648: ecx_utils.g_source(p_int_col_pos).clob_length := null;
649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception
651: when others then
652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;

Line 649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';

645: dbms_lob.read(p_clob_value,l_len,1,l_temp);
646: ecx_utils.g_source(p_int_col_pos).value := l_temp;
647: ecx_utils.g_source(p_int_col_pos).clob_value := null;
648: ecx_utils.g_source(p_int_col_pos).clob_length := null;
649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception
651: when others then
652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;

Line 652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;

648: ecx_utils.g_source(p_int_col_pos).clob_length := null;
649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception
651: when others then
652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
655: end;
656: else

Line 653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;

649: ecx_utils.g_source(p_int_col_pos).is_clob := 'N';
650: exception
651: when others then
652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
655: end;
656: else
657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;

Line 654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';

650: exception
651: when others then
652: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
655: end;
656: else
657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
658: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;

Line 657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;

653: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
655: end;
656: else
657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
658: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
659: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
660: end if;
661: end if;

Line 658: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;

654: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
655: end;
656: else
657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
658: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
659: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
660: end if;
661: end if;
662: if (p_cdata_flag = 'Y') then

Line 659: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';

655: end;
656: else
657: ecx_utils.g_source(p_int_col_pos).clob_value := p_clob_value;
658: ecx_utils.g_source(p_int_col_pos).clob_length := l_len;
659: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
660: end if;
661: end if;
662: if (p_cdata_flag = 'Y') then
663: ecx_utils.g_source(p_int_col_pos).is_clob := p_cdata_flag;

Line 663: ecx_utils.g_source(p_int_col_pos).is_clob := p_cdata_flag;

659: ecx_utils.g_source(p_int_col_pos).is_clob := 'Y';
660: end if;
661: end if;
662: if (p_cdata_flag = 'Y') then
663: ecx_utils.g_source(p_int_col_pos).is_clob := p_cdata_flag;
664: end if;
665:
666:
667: if(l_statementEnabled) then

Line 668: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,

664: end if;
665:
666:
667: if(l_statementEnabled) then
668: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
669: ecx_utils.g_source(p_int_col_pos).value||' '||
670: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
671: p_int_col_pos,i_method_name);
672: end if;

Line 669: ecx_utils.g_source(p_int_col_pos).value||' '||

665:
666:
667: if(l_statementEnabled) then
668: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
669: ecx_utils.g_source(p_int_col_pos).value||' '||
670: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
671: p_int_col_pos,i_method_name);
672: end if;
673:

Line 670: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||

666:
667: if(l_statementEnabled) then
668: ecx_debug.log(l_statement,ecx_utils.g_source(p_int_col_pos).attribute_name ,
669: ecx_utils.g_source(p_int_col_pos).value||' '||
670: ecx_utils.g_source(p_int_col_pos).base_column_name||' '||' '||
671: p_int_col_pos,i_method_name);
672: end if;
673:
674: if (l_procedureEnabled) then

Line 688: WHEN ecx_utils.program_exit then

684: if (l_procedureEnabled) then
685: ecx_debug.pop(i_method_name);
686: end if;
687:
688: WHEN ecx_utils.program_exit then
689: if (l_procedureEnabled) then
690: ecx_debug.pop(i_method_name);
691: end if;
692: raise ecx_utils.program_exit;

Line 692: raise ecx_utils.program_exit;

688: WHEN ecx_utils.program_exit then
689: if (l_procedureEnabled) then
690: ecx_debug.pop(i_method_name);
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

Line 697: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
700: ecx_debug.pop(i_method_name);
701: end if;

Line 702: raise ecx_utils.program_exit;

698: end if;
699: if (l_procedureEnabled) then
700: ecx_debug.pop(i_method_name);
701: end if;
702: raise ecx_utils.program_exit;
703: END process_node;
704:
705:
706: procedure printNodeInfoStack

Line 724: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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;
727: end printNodeInfoStack;
728:

Line 726: raise ecx_utils.program_exit;

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;
727: end printNodeInfoStack;
728:
729:
730: procedure pushNodeInfoStack (

Line 744: WHEN ecx_utils.program_exit then

740: node_info_stack(l_stack_indx).parent_xml_node_indx := p_parent_index;
741:
742: printNodeInfoStack;
743: exception
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');

Line 745: raise ecx_utils.program_exit;

741:
742: printNodeInfoStack;
743: exception
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

Line 750: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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;
753: end pushNodeInfoStack;
754:

Line 752: raise ecx_utils.program_exit;

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;
753: end pushNodeInfoStack;
754:
755:
756: procedure popNodeInfoStack (

Line 779: WHEN ecx_utils.program_exit then

775: end loop;
776: printNodeInfoStack;
777:
778: exception
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');

Line 780: raise ecx_utils.program_exit;

776: printNodeInfoStack;
777:
778: exception
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

Line 785: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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;
788: end popNodeInfoStack;
789:

Line 787: raise ecx_utils.program_exit;

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;
788: end popNodeInfoStack;
789:
790:
791: /* This procedure is called by the Java LoadMap to do level processing. */

Line 902: ecx_utils.g_total_records := ecx_utils.g_total_records + 1;

898:
899: end loop;
900:
901: ecx_inbound.process_data(p_level, 20, p_next);
902: ecx_utils.g_total_records := ecx_utils.g_total_records + 1;
903:
904: if (l_procedureEnabled) then
905: ecx_debug.pop(i_method_name);
906: end if;

Line 909: WHEN ecx_utils.program_exit then

905: ecx_debug.pop(i_method_name);
906: end if;
907:
908: EXCEPTION
909: WHEN ecx_utils.program_exit then
910: clean_up_tables;
911: x_err_msg := ecx_utils.i_errbuf;
912: if (l_procedureEnabled) then
913: ecx_debug.pop(i_method_name);

Line 911: x_err_msg := ecx_utils.i_errbuf;

907:
908: EXCEPTION
909: WHEN ecx_utils.program_exit then
910: clean_up_tables;
911: x_err_msg := ecx_utils.i_errbuf;
912: if (l_procedureEnabled) then
913: ecx_debug.pop(i_method_name);
914: end if;
915: -- if do a raise here, then java can't get the x_err_msg info.

Line 923: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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;
926: if (l_procedureEnabled) then
927: ecx_debug.pop(i_method_name);

Line 925: x_err_msg := ecx_utils.i_errbuf;

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;
926: if (l_procedureEnabled) then
927: ecx_debug.pop(i_method_name);
928: end if;
929: -- same reason as above in program_exit

Line 944: ecx_utils.g_previous_level := 0;

940: ecx_debug.push(i_method_name);
941: end if;
942:
943: -- Initialize global variable and the Stack for the Levels
944: ecx_utils.g_previous_level := 0;
945: l_level_stack.DELETE;
946:
947: /** Initialize the attr table **/
948: l_attr_rec.DELETE;

Line 961: if (not (ecx_utils.dom_printing) and (ecx_utils.structure_printing))

957:
958: l_next_pos := 0;
959:
960: -- if necessary initialize the printing
961: if (not (ecx_utils.dom_printing) and (ecx_utils.structure_printing))
962: then
963: ecx_inbound.structurePrintingSetup(i_root_name);
964: end if;
965:

Line 978: WHEN ecx_utils.program_exit then

974: ecx_debug.pop(i_method_name);
975: end if;
976:
977: EXCEPTION
978: WHEN ecx_utils.program_exit then
979: if (l_procedureEnabled) then
980: ecx_debug.pop(i_method_name);
981: end if;
982: raise ecx_utils.program_exit;

Line 982: raise ecx_utils.program_exit;

978: WHEN ecx_utils.program_exit then
979: if (l_procedureEnabled) then
980: ecx_debug.pop(i_method_name);
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

Line 987: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
990: ecx_debug.pop(i_method_name);
991: end if;

Line 992: raise ecx_utils.program_exit;

988: end if;
989: if (l_procedureEnabled) then
990: ecx_debug.pop(i_method_name);
991: end if;
992: raise ecx_utils.program_exit;
993: END startDocument;
994:
995:
996: procedure endDocument (

Line 1007: if (ecx_utils.structure_printing)

1003: ecx_debug.push(i_method_name);
1004: end if;
1005: popall;
1006:
1007: if (ecx_utils.structure_printing)
1008: then
1009: ecx_print_local.xmlPopall(x_xmlclob);
1010: ecx_util_api.parseXML(ecx_utils.g_inb_parser, x_xmlclob,
1011: x_parseXML, ecx_utils.g_xmldoc);

Line 1010: ecx_util_api.parseXML(ecx_utils.g_inb_parser, x_xmlclob,

1006:
1007: if (ecx_utils.structure_printing)
1008: then
1009: ecx_print_local.xmlPopall(x_xmlclob);
1010: ecx_util_api.parseXML(ecx_utils.g_inb_parser, x_xmlclob,
1011: x_parseXML, ecx_utils.g_xmldoc);
1012: end if;
1013:
1014: -- Execute the Stage 30 for Level 0

Line 1011: x_parseXML, ecx_utils.g_xmldoc);

1007: if (ecx_utils.structure_printing)
1008: then
1009: ecx_print_local.xmlPopall(x_xmlclob);
1010: ecx_util_api.parseXML(ecx_utils.g_inb_parser, x_xmlclob,
1011: x_parseXML, ecx_utils.g_xmldoc);
1012: end if;
1013:
1014: -- Execute the Stage 30 for Level 0
1015: -- Post-Processing for Target

Line 1023: ecx_utils.g_total_records - 1,i_method_name);

1019: ecx_actions.execute_stage_data(30,0,'S');
1020:
1021: if(l_statementEnabled) then
1022: ecx_debug.log(l_statement, 'Total record processed',
1023: ecx_utils.g_total_records - 1,i_method_name);
1024: end if;
1025:
1026: if (l_procedureEnabled) then
1027: ecx_debug.pop(i_method_name);

Line 1031: WHEN ecx_utils.program_exit then

1027: ecx_debug.pop(i_method_name);
1028: end if;
1029:
1030: EXCEPTION
1031: WHEN ecx_utils.program_exit then
1032: if (l_procedureEnabled) then
1033: ecx_debug.pop(i_method_name);
1034: end if;
1035: raise ecx_utils.program_exit;

Line 1035: raise ecx_utils.program_exit;

1031: WHEN ecx_utils.program_exit then
1032: if (l_procedureEnabled) then
1033: ecx_debug.pop(i_method_name);
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

Line 1040: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
1043: ecx_debug.pop(i_method_name);
1044: end if;

Line 1045: raise ecx_utils.program_exit;

1041: end if;
1042: if (l_procedureEnabled) then
1043: ecx_debug.pop(i_method_name);
1044: end if;
1045: raise ecx_utils.program_exit;
1046: END endDocument;
1047:
1048:
1049: Function LoadXML

Line 1070: raise ecx_utils.program_exit;

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;
1071:
1072: elsif (p_err_code = SAX_EXCEPTION) then
1073: --Since in 10g, XDB XML_PARSE_EXCEPTION is appearing as SAX_EXCEPTION
1074: --incorporating the same exception handling of XML_PARSE_EXCEPTION here,

Line 1076: -- raise ecx_utils.program_exit;

1072: elsif (p_err_code = SAX_EXCEPTION) then
1073: --Since in 10g, XDB XML_PARSE_EXCEPTION is appearing as SAX_EXCEPTION
1074: --incorporating the same exception handling of XML_PARSE_EXCEPTION here,
1075: --otherwise it is appearing as user-defined exception.
1076: -- raise ecx_utils.program_exit;
1077: ecx_debug.setErrorInfo(1, 20, p_err_msg);
1078: if(l_unexpectedEnabled) then
1079: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1080: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

Line 1080: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

1076: -- raise ecx_utils.program_exit;
1077: ecx_debug.setErrorInfo(1, 20, p_err_msg);
1078: if(l_unexpectedEnabled) then
1079: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1080: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1081: end if;
1082: raise ecx_utils.program_exit;
1083:
1084: elsif (p_err_code = SQL_EXCEPTION) then

Line 1082: raise ecx_utils.program_exit;

1078: if(l_unexpectedEnabled) then
1079: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1080: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1081: end if;
1082: raise ecx_utils.program_exit;
1083:
1084: elsif (p_err_code = SQL_EXCEPTION) then
1085: raise Load_XML_Exception;
1086:

Line 1094: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

1090: elsif (p_err_code = XML_PARSE_EXCEPTION) then
1091: ecx_debug.setErrorInfo(1, 20, p_err_msg);
1092: if(l_unexpectedEnabled) then
1093: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1094: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1095: end if;
1096: raise ecx_utils.program_exit;
1097:
1098: elsif (p_err_code = OTHER_EXCEPTION) then

Line 1096: raise ecx_utils.program_exit;

1092: if(l_unexpectedEnabled) then
1093: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1094: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1095: end if;
1096: raise ecx_utils.program_exit;
1097:
1098: elsif (p_err_code = OTHER_EXCEPTION) then
1099: raise Load_XML_Exception;
1100: end if;

Line 1107: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

1103: when Load_XML_Exception then
1104: ecx_debug.setErrorInfo(2, 30, p_err_msg);
1105: if(l_unexpectedEnabled) then
1106: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1107: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1108: end if;
1109: raise ecx_utils.program_exit;
1110:
1111: when ecx_utils.program_exit then

Line 1109: raise ecx_utils.program_exit;

1105: if(l_unexpectedEnabled) then
1106: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);
1107: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1108: end if;
1109: raise ecx_utils.program_exit;
1110:
1111: when ecx_utils.program_exit then
1112: raise;
1113: end raise_loadxml_err;

Line 1111: when ecx_utils.program_exit then

1107: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1108: end if;
1109: raise ecx_utils.program_exit;
1110:
1111: when ecx_utils.program_exit then
1112: raise;
1113: end raise_loadxml_err;
1114:
1115:

Line 1158: WHEN ecx_utils.program_exit then

1154: ecx_debug.pop(i_method_name);
1155: end if;
1156:
1157: EXCEPTION
1158: WHEN ecx_utils.program_exit then
1159: clean_up_tables;
1160: if (l_procedureEnabled) then
1161: ecx_debug.pop(i_method_name);
1162: end if;

Line 1163: raise ecx_utils.program_exit;

1159: clean_up_tables;
1160: if (l_procedureEnabled) then
1161: ecx_debug.pop(i_method_name);
1162: end if;
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');

Line 1169: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);

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
1172: ecx_debug.pop(i_method_name);
1173: end if;

Line 1174: raise ecx_utils.program_exit;

1170: end if;
1171: if (l_procedureEnabled) then
1172: ecx_debug.pop(i_method_name);
1173: end if;
1174: raise ecx_utils.program_exit;
1175: end process_xml_doc;
1176:
1177:
1178: END ecx_inbound_new;