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_PRINT_LOCAL dependencies on ECX_DEBUG

Line 4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

1: package body ecx_print_local as
2: -- $Header: ECXLXMLB.pls 120.4.12010000.2 2008/08/22 20:00:06 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

Line 5: l_statement PLS_INTEGER := ecx_debug.g_statement;

1: package body ecx_print_local as
2: -- $Header: ECXLXMLB.pls 120.4.12010000.2 2008/08/22 20:00:06 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

Line 6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;

2: -- $Header: ECXLXMLB.pls 120.4.12010000.2 2008/08/22 20:00:06 cpeixoto ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:

Line 7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;

3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11:

Line 8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;

4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11:
12: -- fix for bug 6900831: max number of loops before we consider infinite loop

Line 9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;

5: l_statement PLS_INTEGER := ecx_debug.g_statement;
6: l_unexpected PLS_INTEGER := ecx_debug.g_unexpected;
7: l_procedureEnabled boolean := ecx_debug.g_procedureEnabled;
8: l_statementEnabled boolean := ecx_debug.g_statementEnabled;
9: l_unexpectedEnabled boolean := ecx_debug.g_unexpectedEnabled;
10:
11:
12: -- fix for bug 6900831: max number of loops before we consider infinite loop
13: l_loop_max PLS_INTEGER := 5;

Line 46: ecx_debug.push(i_method_name);

42: i_temp varchar2(32767);
43:
44: begin
45: if (l_procedureEnabled) then
46: ecx_debug.push(i_method_name);
47: end if;
48:
49: i_writeamount :=0;
50: i_length :=0;

Line 64: ecx_debug.log(l_statement,'Buffer Length', to_char(i_length),i_method_name);

60: -- set append status to true
61: -- check if temp buffer is full
62: if(i_writeamount+i_length > 10000) then
63: if(l_statementEnabled) then
64: ecx_debug.log(l_statement,'Buffer Length', to_char(i_length),i_method_name);
65: end if;
66: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);
67: if(l_statementEnabled) then
68: ecx_debug.log(l_statement, i_temp,i_method_name);

Line 68: ecx_debug.log(l_statement, i_temp,i_method_name);

64: ecx_debug.log(l_statement,'Buffer Length', to_char(i_length),i_method_name);
65: end if;
66: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);
67: if(l_statementEnabled) then
68: ecx_debug.log(l_statement, i_temp,i_method_name);
69: end if;
70: i_temp:='';
71: i_length:=i_writeamount;
72: i_temp:=i_tmpxml(i);

Line 84: ecx_debug.log(l_statement, i_temp,i_method_name);

80: if(i_tmpxml.COUNT > 0)
81: then
82: dbms_lob.writeappend(i_xmldoc,i_length, i_temp);
83: if(l_statementEnabled) then
84: ecx_debug.log(l_statement, i_temp,i_method_name);
85: end if;
86: end if;
87: i_tmpxml.DELETE;
88:

Line 90: ecx_debug.pop(i_method_name);

86: end if;
87: i_tmpxml.DELETE;
88:
89: if (l_procedureEnabled) then
90: ecx_debug.pop(i_method_name);
91: end if;
92: exception
93: when value_error then
94: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

Line 94: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

90: ecx_debug.pop(i_method_name);
91: end if;
92: exception
93: when value_error then
94: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
95: if(l_unexpectedEnabled) then
96: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
97: end if;
98: raise ECX_UTILS.PROGRAM_EXIT;

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

92: exception
93: when value_error then
94: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
95: if(l_unexpectedEnabled) then
96: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
97: end if;
98: raise ECX_UTILS.PROGRAM_EXIT;
99:
100: when ecx_utils.program_exit then

Line 104: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB');

100: when ecx_utils.program_exit then
101: raise ECX_UTILS.PROGRAM_EXIT;
102:
103: when others then
104: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB');
105: if(l_unexpectedEnabled) then
106: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB',i_method_name);
107: end if;
108: raise ECX_UTILS.PROGRAM_EXIT;

Line 106: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB',i_method_name);

102:
103: when others then
104: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB');
105: if(l_unexpectedEnabled) then
106: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.APPEND_CLOB',i_method_name);
107: end if;
108: raise ECX_UTILS.PROGRAM_EXIT;
109: end append_clob;
110:

Line 131: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

127: End if;
128:
129: exception
130: when value_error then
131: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
132: if(l_unexpectedEnabled) then
133: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
134: end if;
135: raise ECX_UTILS.PROGRAM_EXIT;

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

129: exception
130: when value_error then
131: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
132: if(l_unexpectedEnabled) then
133: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
134: end if;
135: raise ECX_UTILS.PROGRAM_EXIT;
136: when ecx_utils.program_exit then
137: raise ECX_UTILS.PROGRAM_EXIT;

Line 139: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE');

135: raise ECX_UTILS.PROGRAM_EXIT;
136: when ecx_utils.program_exit then
137: raise ECX_UTILS.PROGRAM_EXIT;
138: when others then
139: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE');
140: if(l_unexpectedEnabled) then
141: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE',i_method_name);
142: end if;
143: raise ECX_UTILS.PROGRAM_EXIT;

Line 141: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE',i_method_name);

137: raise ECX_UTILS.PROGRAM_EXIT;
138: when others then
139: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE');
140: if(l_unexpectedEnabled) then
141: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_VALUE',i_method_name);
142: end if;
143: raise ECX_UTILS.PROGRAM_EXIT;
144: end element_value;
145:

Line 173: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

169: End if;
170:
171: exception
172: when value_error then
173: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
174: if(l_unexpectedEnabled) then
175: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
176: end if;
177: raise ECX_UTILS.PROGRAM_EXIT;

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

171: exception
172: when value_error then
173: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
174: if(l_unexpectedEnabled) then
175: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
176: end if;
177: raise ECX_UTILS.PROGRAM_EXIT;
178: when ecx_utils.program_exit then
179: raise ECX_UTILS.PROGRAM_EXIT;

Line 181: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE');

177: raise ECX_UTILS.PROGRAM_EXIT;
178: when ecx_utils.program_exit then
179: raise ECX_UTILS.PROGRAM_EXIT;
180: when others then
181: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE');
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE',
184: i_method_name);
185: end if;

Line 183: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE',

179: raise ECX_UTILS.PROGRAM_EXIT;
180: when others then
181: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE');
182: if(l_unexpectedEnabled) then
183: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || '- ECX_PRINT_LOCAL.CDATA_ELEMENT_VALUE',
184: i_method_name);
185: end if;
186: raise ECX_UTILS.PROGRAM_EXIT;
187: end cdata_element_value;

Line 203: ecx_debug.log(l_statement,'Counter'||i,l_node_stack(i),i_method_name);

199: then
200: for i in l_node_stack.first..l_node_stack.last
201: loop
202: if(l_statementEnabled) then
203: ecx_debug.log(l_statement,'Counter'||i,l_node_stack(i),i_method_name);
204: end if;
205: end loop;
206: end if;
207: end if;

Line 229: ecx_debug.push(i_method_name);

225:
226: begin
227:
228: if (l_procedureEnabled) then
229: ecx_debug.push(i_method_name);
230: end if;
231:
232: if(l_statementEnabled) then
233: ecx_debug.log(l_statement, 'i_last_stack_id', i_last_stack_id,i_method_name);

Line 233: ecx_debug.log(l_statement, 'i_last_stack_id', i_last_stack_id,i_method_name);

229: ecx_debug.push(i_method_name);
230: end if;
231:
232: if(l_statementEnabled) then
233: ecx_debug.log(l_statement, 'i_last_stack_id', i_last_stack_id,i_method_name);
234: ecx_debug.log(l_statement, 'l_node_stack.LAST', l_node_stack(l_node_stack.LAST),i_method_name);
235: end if;
236:
237: if (i_last_stack_id <> l_node_stack(l_node_stack.LAST))

Line 234: ecx_debug.log(l_statement, 'l_node_stack.LAST', l_node_stack(l_node_stack.LAST),i_method_name);

230: end if;
231:
232: if(l_statementEnabled) then
233: ecx_debug.log(l_statement, 'i_last_stack_id', i_last_stack_id,i_method_name);
234: ecx_debug.log(l_statement, 'l_node_stack.LAST', l_node_stack(l_node_stack.LAST),i_method_name);
235: end if;
236:
237: if (i_last_stack_id <> l_node_stack(l_node_stack.LAST))
238: then

Line 260: ecx_debug.log(l_statement,'',i_method_name);

256: );
257: end if;
258:
259: if(l_statementEnabled) then
260: ecx_debug.log(l_statement,'',i_method_name);
261: end if;
262: end if;
263: xmlPOP;
264: end loop;

Line 268: ecx_debug.pop(i_method_name);

264: end loop;
265: end if;
266:
267: if (l_procedureEnabled) then
268: ecx_debug.pop(i_method_name);
269: end if;
270:
271: exception
272: when ecx_utils.program_exit then

Line 274: ecx_debug.pop(i_method_name);

270:
271: exception
272: when ecx_utils.program_exit then
273: if (l_procedureEnabled) then
274: ecx_debug.pop(i_method_name);
275: end if;
276: raise ECX_UTILS.PROGRAM_EXIT;
277: when others then
278: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS');

Line 278: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS');

274: ecx_debug.pop(i_method_name);
275: end if;
276: raise ECX_UTILS.PROGRAM_EXIT;
277: when others then
278: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS');
279: if(l_unexpectedEnabled) then
280: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS',i_method_name);
281: end if;
282: if (l_procedureEnabled) then

Line 280: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS',i_method_name);

276: raise ECX_UTILS.PROGRAM_EXIT;
277: when others then
278: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS');
279: if(l_unexpectedEnabled) then
280: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS',i_method_name);
281: end if;
282: if (l_procedureEnabled) then
283: ecx_debug.pop(i_method_name);
284: end if;

Line 283: ecx_debug.pop(i_method_name);

279: if(l_unexpectedEnabled) then
280: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.POP_DISCONT_ELEMENTS',i_method_name);
281: end if;
282: if (l_procedureEnabled) then
283: ecx_debug.pop(i_method_name);
284: end if;
285: raise ECX_UTILS.PROGRAM_EXIT;
286: end pop_discont_elements;
287:

Line 320: ecx_debug.push(i_method_name);

316: descendant_found boolean := false;
317:
318: begin
319: if (l_procedureEnabled) then
320: ecx_debug.push(i_method_name);
321: end if;
322:
323: if(l_statementEnabled) then
324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);

Line 324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);

320: ecx_debug.push(i_method_name);
321: end if;
322:
323: if(l_statementEnabled) then
324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);
325: ecx_debug.log(l_statement, 'i_end_pos', i_end_pos,i_method_name);
326: ecx_debug.log(l_statement, 'i_parent_attr_id', i_parent_attr_id,i_method_name);
327: ecx_debug.log(l_statement, 'i_ext_level', i_ext_level,i_method_name);
328: end if;

Line 325: ecx_debug.log(l_statement, 'i_end_pos', i_end_pos,i_method_name);

321: end if;
322:
323: if(l_statementEnabled) then
324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);
325: ecx_debug.log(l_statement, 'i_end_pos', i_end_pos,i_method_name);
326: ecx_debug.log(l_statement, 'i_parent_attr_id', i_parent_attr_id,i_method_name);
327: ecx_debug.log(l_statement, 'i_ext_level', i_ext_level,i_method_name);
328: end if;
329:

Line 326: ecx_debug.log(l_statement, 'i_parent_attr_id', i_parent_attr_id,i_method_name);

322:
323: if(l_statementEnabled) then
324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);
325: ecx_debug.log(l_statement, 'i_end_pos', i_end_pos,i_method_name);
326: ecx_debug.log(l_statement, 'i_parent_attr_id', i_parent_attr_id,i_method_name);
327: ecx_debug.log(l_statement, 'i_ext_level', i_ext_level,i_method_name);
328: end if;
329:
330: for k in i_start_pos..i_end_pos

Line 327: ecx_debug.log(l_statement, 'i_ext_level', i_ext_level,i_method_name);

323: if(l_statementEnabled) then
324: ecx_debug.log(l_statement, 'i_start_pos', i_start_pos,i_method_name);
325: ecx_debug.log(l_statement, 'i_end_pos', i_end_pos,i_method_name);
326: ecx_debug.log(l_statement, 'i_parent_attr_id', i_parent_attr_id,i_method_name);
327: ecx_debug.log(l_statement, 'i_ext_level', i_ext_level,i_method_name);
328: end if;
329:
330: for k in i_start_pos..i_end_pos
331: loop

Line 345: ecx_debug.log(l_statement, 'print_id', print_id,i_method_name);

341: if (not elements_found)
342: then
343: print_id := curr_id;
344: if(l_statementEnabled) then
345: ecx_debug.log(l_statement, 'print_id', print_id,i_method_name);
346: end if;
347: elements_found := true;
348: end if;
349: end if;

Line 366: ecx_debug.pop(i_method_name);

362: exit when not descendant_found;
363: end loop;
364:
365: if (l_procedureEnabled) then
366: ecx_debug.pop(i_method_name);
367: end if;
368:
369: exception
370: when ecx_utils.program_exit then

Line 372: ecx_debug.pop(i_method_name);

368:
369: exception
370: when ecx_utils.program_exit then
371: if (l_procedureEnabled) then
372: ecx_debug.pop(i_method_name);
373: end if;
374: raise ECX_UTILS.PROGRAM_EXIT;
375: when others then
376: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS');

Line 376: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS');

372: ecx_debug.pop(i_method_name);
373: end if;
374: raise ECX_UTILS.PROGRAM_EXIT;
375: when others then
376: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS');
377: if(l_unexpectedEnabled) then
378: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS',i_method_name);
379: end if;
380: if (l_procedureEnabled) then

Line 378: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS',i_method_name);

374: raise ECX_UTILS.PROGRAM_EXIT;
375: when others then
376: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS');
377: if(l_unexpectedEnabled) then
378: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS',i_method_name);
379: end if;
380: if (l_procedureEnabled) then
381: ecx_debug.pop(i_method_name);
382: end if;

Line 381: ecx_debug.pop(i_method_name);

377: if(l_unexpectedEnabled) then
378: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.PRINT_DISCONT_ELEMENTS',i_method_name);
379: end if;
380: if (l_procedureEnabled) then
381: ecx_debug.pop(i_method_name);
382: end if;
383: raise ECX_UTILS.PROGRAM_EXIT;
384: end print_discont_elements;
385:

Line 400: ecx_debug.push(i_method_name);

396: i_method_name varchar2(2000) := 'ecx_print_local.is_descendant';
397: curr_pid pls_integer;
398: begin
399: if (l_procedureEnabled) then
400: ecx_debug.push(i_method_name);
401: end if;
402:
403: curr_pid := ecx_utils.g_target(i_element_id).parent_attribute_id;
404: loop

Line 408: ecx_debug.log(l_statement,'Returning true',i_method_name);

404: loop
405: if (curr_pid = i_parent_id)
406: then
407: if(l_statementEnabled) then
408: ecx_debug.log(l_statement,'Returning true',i_method_name);
409: end if;
410: if (l_procedureEnabled) then
411: ecx_debug.pop(i_method_name);
412: end if;

Line 411: ecx_debug.pop(i_method_name);

407: if(l_statementEnabled) then
408: ecx_debug.log(l_statement,'Returning true',i_method_name);
409: end if;
410: if (l_procedureEnabled) then
411: ecx_debug.pop(i_method_name);
412: end if;
413: return (true);
414: elsif (curr_pid < i_parent_id)
415: then

Line 417: ecx_debug.log(l_statement,'Returning false',i_method_name);

413: return (true);
414: elsif (curr_pid < i_parent_id)
415: then
416: if(l_statementEnabled) then
417: ecx_debug.log(l_statement,'Returning false',i_method_name);
418: end if;
419: if (l_procedureEnabled) then
420: ecx_debug.pop(i_method_name);
421: end if;

Line 420: ecx_debug.pop(i_method_name);

416: if(l_statementEnabled) then
417: ecx_debug.log(l_statement,'Returning false',i_method_name);
418: end if;
419: if (l_procedureEnabled) then
420: ecx_debug.pop(i_method_name);
421: end if;
422: return (false);
423: else
424: curr_pid := ecx_utils.g_target(curr_pid).parent_attribute_id;

Line 433: ecx_debug.log(l_statement,'Returning true: 0 is the ancestor',i_method_name);

429: -- for the special case where 0 is the ancestor
430: if (curr_pid = 0 AND curr_pid = i_parent_id)
431: then
432: if(l_statementEnabled) then
433: ecx_debug.log(l_statement,'Returning true: 0 is the ancestor',i_method_name);
434: end if;
435: if (l_procedureEnabled) then
436: ecx_debug.pop(i_method_name);
437: end if;

Line 436: ecx_debug.pop(i_method_name);

432: if(l_statementEnabled) then
433: ecx_debug.log(l_statement,'Returning true: 0 is the ancestor',i_method_name);
434: end if;
435: if (l_procedureEnabled) then
436: ecx_debug.pop(i_method_name);
437: end if;
438: return (true);
439: end if;
440:

Line 442: ecx_debug.log(l_statement,'Returning false',i_method_name);

438: return (true);
439: end if;
440:
441: if(l_statementEnabled) then
442: ecx_debug.log(l_statement,'Returning false',i_method_name);
443: end if;
444: return (false);
445: if (l_procedureEnabled) then
446: ecx_debug.pop(i_method_name);

Line 446: ecx_debug.pop(i_method_name);

442: ecx_debug.log(l_statement,'Returning false',i_method_name);
443: end if;
444: return (false);
445: if (l_procedureEnabled) then
446: ecx_debug.pop(i_method_name);
447: end if;
448: exception
449: when ecx_utils.program_exit then
450: if (l_procedureEnabled) then

Line 451: ecx_debug.pop(i_method_name);

447: end if;
448: exception
449: when ecx_utils.program_exit then
450: if (l_procedureEnabled) then
451: ecx_debug.pop(i_method_name);
452: end if;
453: raise ECX_UTILS.PROGRAM_EXIT;
454: when others then
455: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT');

Line 455: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT');

451: ecx_debug.pop(i_method_name);
452: end if;
453: raise ECX_UTILS.PROGRAM_EXIT;
454: when others then
455: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT');
456: if(l_unexpectedEnabled) then
457: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT',i_method_name);
458: end if;
459: if (l_procedureEnabled) then

Line 457: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT',i_method_name);

453: raise ECX_UTILS.PROGRAM_EXIT;
454: when others then
455: ecx_debug.setErrorInfo(2, 30, SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT');
456: if(l_unexpectedEnabled) then
457: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT',i_method_name);
458: end if;
459: if (l_procedureEnabled) then
460: ecx_debug.pop(i_method_name);
461: end if;

Line 460: ecx_debug.pop(i_method_name);

456: if(l_unexpectedEnabled) then
457: ecx_debug.log(l_unexpected,'ECX', SQLERRM ||' - ECX_PRINT_LOCAL.IS_DESCENDANT',i_method_name);
458: end if;
459: if (l_procedureEnabled) then
460: ecx_debug.pop(i_method_name);
461: end if;
462: raise ECX_UTILS.PROGRAM_EXIT;
463: end is_descendant;
464:

Line 520: ecx_debug.log(l_statement,'', i_method_name);

516: ecx_utils.g_target(l_node_stack(l_node_stack.LAST)).attribute_name
517: );
518: end if;
519: if(l_statementEnabled) then
520: ecx_debug.log(l_statement,'', i_method_name);
521: end if;
522: end if;
523: xmlPOP;
524: end loop;

Line 543: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL');

539: end if;
540: raise ECX_UTILS.PROGRAM_EXIT;
541:
542: when others then
543: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL');
544: if(l_unexpectedEnabled) then
545: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL',i_method_name);
546: end if;
547: if dbms_lob.istemporary(i_xmldoc) = 1 then

Line 545: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL',i_method_name);

541:
542: when others then
543: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL');
544: if(l_unexpectedEnabled) then
545: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.xmlPOPALL',i_method_name);
546: end if;
547: if dbms_lob.istemporary(i_xmldoc) = 1 then
548: dbms_lob.freetemporary(i_xmldoc);
549: i_xmldoc := null;

Line 588: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

584: begin
585: i_tmpxml(i_tmpxml.COUNT+1) := i_elestarttag||tag_name||' ';
586: exception
587: when value_error then
588: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
589: if(l_unexpectedEnabled) then
590: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
591: end if;
592: raise ECX_UTILS.PROGRAM_EXIT;

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

586: exception
587: when value_error then
588: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
589: if(l_unexpectedEnabled) then
590: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
591: end if;
592: raise ECX_UTILS.PROGRAM_EXIT;
593: when ecx_utils.program_exit then
594: raise ECX_UTILS.PROGRAM_EXIT;

Line 596: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN');

592: raise ECX_UTILS.PROGRAM_EXIT;
593: when ecx_utils.program_exit then
594: raise ECX_UTILS.PROGRAM_EXIT;
595: when others then
596: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN');
597: if(l_unexpectedEnabled) then
598: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN',i_method_name);
599: end if;
600: raise ECX_UTILS.PROGRAM_EXIT;

Line 598: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN',i_method_name);

594: raise ECX_UTILS.PROGRAM_EXIT;
595: when others then
596: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN');
597: if(l_unexpectedEnabled) then
598: ecx_debug.log(l_unexpected,'ECX', SQLERRM || '- ECX_PRINT_LOCAL.ELEMENT_OPEN',i_method_name);
599: end if;
600: raise ECX_UTILS.PROGRAM_EXIT;
601: end;
602:

Line 611: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

607: begin
608: i_tmpxml(i_tmpxml.COUNT+1) := i_eleendtag;
609: exception
610: when value_error then
611: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
612: if(l_unexpectedEnabled) then
613: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf, i_method_name);
614: end if;
615: raise ECX_UTILS.PROGRAM_EXIT;

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

609: exception
610: when value_error then
611: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
612: if(l_unexpectedEnabled) then
613: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf, i_method_name);
614: end if;
615: raise ECX_UTILS.PROGRAM_EXIT;
616: when ecx_utils.program_exit then
617: raise ECX_UTILS.PROGRAM_EXIT;

Line 619: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE');

615: raise ECX_UTILS.PROGRAM_EXIT;
616: when ecx_utils.program_exit then
617: raise ECX_UTILS.PROGRAM_EXIT;
618: when others then
619: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE');
620: if(l_unexpectedEnabled) then
621: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE',i_method_name);
622: end if;
623: raise ECX_UTILS.PROGRAM_EXIT;

Line 621: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE',i_method_name);

617: raise ECX_UTILS.PROGRAM_EXIT;
618: when others then
619: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE');
620: if(l_unexpectedEnabled) then
621: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_CLOSE',i_method_name);
622: end if;
623: raise ECX_UTILS.PROGRAM_EXIT;
624: end element_close;
625:

Line 651: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

647: End if;
648:
649: exception
650: when value_error then
651: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
652: if(l_unexpectedEnabled) then
653: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
654: end if;
655: raise ECX_UTILS.PROGRAM_EXIT;

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

649: exception
650: when value_error then
651: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
652: if(l_unexpectedEnabled) then
653: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
654: end if;
655: raise ECX_UTILS.PROGRAM_EXIT;
656: when ecx_utils.program_exit then
657: raise ECX_UTILS.PROGRAM_EXIT;

Line 659: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN');

655: raise ECX_UTILS.PROGRAM_EXIT;
656: when ecx_utils.program_exit then
657: raise ECX_UTILS.PROGRAM_EXIT;
658: when others then
659: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN');
660: if(l_unexpectedEnabled) then
661: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN',i_method_name);
662: end if;
663: raise ECX_UTILS.PROGRAM_EXIT;

Line 661: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN',i_method_name);

657: raise ECX_UTILS.PROGRAM_EXIT;
658: when others then
659: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN');
660: if(l_unexpectedEnabled) then
661: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_OPEN',i_method_name);
662: end if;
663: raise ECX_UTILS.PROGRAM_EXIT;
664: end element_node_open;
665:

Line 678: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

674: begin
675: i_tmpxml(i_tmpxml.COUNT+1) := i_eleclosetag||tag_name||i_eleendtag;
676: exception
677: when value_error then
678: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
679: if(l_unexpectedEnabled) then
680: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
681: end if;
682: raise ECX_UTILS.PROGRAM_EXIT;

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

676: exception
677: when value_error then
678: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
679: if(l_unexpectedEnabled) then
680: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
681: end if;
682: raise ECX_UTILS.PROGRAM_EXIT;
683: when ecx_utils.program_exit then
684: raise ECX_UTILS.PROGRAM_EXIT;

Line 686: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE');

682: raise ECX_UTILS.PROGRAM_EXIT;
683: when ecx_utils.program_exit then
684: raise ECX_UTILS.PROGRAM_EXIT;
685: when others then
686: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE');
687: if(l_unexpectedEnabled) then
688: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE',i_method_name);
689: end if;
690: raise ECX_UTILS.PROGRAM_EXIT;

Line 688: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE',i_method_name);

684: raise ECX_UTILS.PROGRAM_EXIT;
685: when others then
686: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE');
687: if(l_unexpectedEnabled) then
688: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE_CLOSE',i_method_name);
689: end if;
690: raise ECX_UTILS.PROGRAM_EXIT;
691: end element_node_close;
692:

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

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

Line 724: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_OPEN',

720: raise ECX_UTILS.PROGRAM_EXIT;
721: when others then
722: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_OPEN');
723: if(l_unexpectedEnabled) then
724: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_OPEN',
725: i_method_name);
726: end if;
727: raise ECX_UTILS.PROGRAM_EXIT;
728: end;

Line 747: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE');

743: exception
744: when ecx_utils.program_exit then
745: raise ECX_UTILS.PROGRAM_EXIT;
746: when others then
747: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE');
748: if(l_unexpectedEnabled) then
749: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE',
750: i_method_name);
751: end if;

Line 749: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE',

745: raise ECX_UTILS.PROGRAM_EXIT;
746: when others then
747: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE');
748: if(l_unexpectedEnabled) then
749: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.CDATA_ELEMENT_NODE_CLOSE',
750: i_method_name);
751: end if;
752: raise ECX_UTILS.PROGRAM_EXIT;
753: end;

Line 786: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

782: end if;
783: i_tmpxml(i_tmpxml.COUNT+1) := i_eleclosetag||tag_name||i_eleendtag;
784: exception
785: when value_error then
786: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
787: if(l_unexpectedEnabled) then
788: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
789: end if;
790: raise ECX_UTILS.PROGRAM_EXIT;

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

784: exception
785: when value_error then
786: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
787: if(l_unexpectedEnabled) then
788: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
789: end if;
790: raise ECX_UTILS.PROGRAM_EXIT;
791: when ecx_utils.program_exit then
792: raise ECX_UTILS.PROGRAM_EXIT;

Line 794: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE');

790: raise ECX_UTILS.PROGRAM_EXIT;
791: when ecx_utils.program_exit then
792: raise ECX_UTILS.PROGRAM_EXIT;
793: when others then
794: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE');
795: if(l_unexpectedEnabled) then
796: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE',
797: i_method_name);
798: end if;

Line 796: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE',

792: raise ECX_UTILS.PROGRAM_EXIT;
793: when others then
794: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE');
795: if(l_unexpectedEnabled) then
796: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ELEMENT_NODE',
797: i_method_name);
798: end if;
799: raise ECX_UTILS.PROGRAM_EXIT;
800: end element_node;

Line 832: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

828: i_tmpxml(i_tmpxml.COUNT + 1) := '"';
829: end if;
830: exception
831: when value_error then
832: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
833: if(l_unexpectedEnabled) then
834: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
835: end if;
836: raise ECX_UTILS.PROGRAM_EXIT;

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

830: exception
831: when value_error then
832: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
833: if(l_unexpectedEnabled) then
834: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
835: end if;
836: raise ECX_UTILS.PROGRAM_EXIT;
837: when ecx_utils.program_exit then
838: raise ECX_UTILS.PROGRAM_EXIT;

Line 840: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE');

836: raise ECX_UTILS.PROGRAM_EXIT;
837: when ecx_utils.program_exit then
838: raise ECX_UTILS.PROGRAM_EXIT;
839: when others then
840: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE');
841: if(l_unexpectedEnabled) then
842: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE',i_method_name);
843: end if;
844: raise ECX_UTILS.PROGRAM_EXIT;

Line 842: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE',i_method_name);

838: raise ECX_UTILS.PROGRAM_EXIT;
839: when others then
840: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE');
841: if(l_unexpectedEnabled) then
842: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE',i_method_name);
843: end if;
844: raise ECX_UTILS.PROGRAM_EXIT;
845: end;
846:

Line 882: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

878: i_tmpxml(i_tmpxml.COUNT+1) := '>';
879: end if;
880: exception
881: when value_error then
882: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
883: if(l_unexpectedEnabled) then
884: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
885: end if;
886: raise ECX_UTILS.PROGRAM_EXIT;

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

880: exception
881: when value_error then
882: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
883: if(l_unexpectedEnabled) then
884: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
885: end if;
886: raise ECX_UTILS.PROGRAM_EXIT;
887: when ecx_utils.program_exit then
888: raise ECX_UTILS.PROGRAM_EXIT;

Line 890: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE');

886: raise ECX_UTILS.PROGRAM_EXIT;
887: when ecx_utils.program_exit then
888: raise ECX_UTILS.PROGRAM_EXIT;
889: when others then
890: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE');
891: if(l_unexpectedEnabled) then
892: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE',
893: i_method_name);
894: end if;

Line 892: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE',

888: raise ECX_UTILS.PROGRAM_EXIT;
889: when others then
890: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE');
891: if(l_unexpectedEnabled) then
892: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.ATTRIBUTE_NODE_CLOSE',
893: i_method_name);
894: end if;
895: raise ECX_UTILS.PROGRAM_EXIT;
896: end;

Line 912: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE');

908: exception
909: when ecx_utils.program_exit then
910: raise ECX_UTILS.PROGRAM_EXIT;
911: when others then
912: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE');
913: if(l_unexpectedEnabled) then
914: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE',i_method_name);
915: end if;
916: raise ECX_UTILS.PROGRAM_EXIT;

Line 914: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE',i_method_name);

910: raise ECX_UTILS.PROGRAM_EXIT;
911: when others then
912: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE');
913: if(l_unexpectedEnabled) then
914: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PI_NODE',i_method_name);
915: end if;
916: raise ECX_UTILS.PROGRAM_EXIT;
917: end pi_node;
918:

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

944: exception
945: when ecx_utils.program_exit then
946: raise ECX_UTILS.PROGRAM_EXIT;
947: when others then
948: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.DOCUMENT_NODE');
949: if(l_unexpectedEnabled) then
950: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.DOCUMENT_NODE',i_method_name);
951: end if;
952: raise ECX_UTILS.PROGRAM_EXIT;

Line 950: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.DOCUMENT_NODE',i_method_name);

946: raise ECX_UTILS.PROGRAM_EXIT;
947: when others then
948: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.DOCUMENT_NODE');
949: if(l_unexpectedEnabled) then
950: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.DOCUMENT_NODE',i_method_name);
951: end if;
952: raise ECX_UTILS.PROGRAM_EXIT;
953: end document_node;
954:

Line 967: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE');

963: exception
964: when ecx_utils.program_exit then
965: raise ECX_UTILS.PROGRAM_EXIT;
966: when others then
967: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE');
968: if(l_unexpectedEnabled) then
969: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE',i_method_name);
970: end if;
971: raise ECX_UTILS.PROGRAM_EXIT;

Line 969: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE',i_method_name);

965: raise ECX_UTILS.PROGRAM_EXIT;
966: when others then
967: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE');
968: if(l_unexpectedEnabled) then
969: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.COMMENT_NODE',i_method_name);
970: end if;
971: raise ECX_UTILS.PROGRAM_EXIT;
972: end comment_node;
973:

Line 982: ecx_debug.PUSH(i_method_name);

978: i_method_name varchar2(2000) := 'ecx_print_local.print_waiting_nodes';
979: i_last_node_printed pls_integer;
980: begin
981: if(l_procedureEnabled) then
982: ecx_debug.PUSH(i_method_name);
983: end if;
984:
985: i_last_node_printed := last_node_printed + 1;
986:

Line 1017: ecx_debug.POP(i_method_name);

1013: end if;
1014: last_node_printed := l_node_stack.LAST;
1015:
1016: if(l_procedureEnabled) then
1017: ecx_debug.POP(i_method_name);
1018: end if;
1019:
1020: exception
1021: when ecx_utils.program_exit

Line 1024: ecx_debug.pop(i_method_name);

1020: exception
1021: when ecx_utils.program_exit
1022: then
1023: if (l_procedureEnabled) then
1024: ecx_debug.pop(i_method_name);
1025: end if;
1026: raise ECX_UTILS.PROGRAM_EXIT;
1027: when others then
1028: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES');

Line 1028: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES');

1024: ecx_debug.pop(i_method_name);
1025: end if;
1026: raise ECX_UTILS.PROGRAM_EXIT;
1027: when others then
1028: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES');
1029: if(l_statementEnabled) then
1030: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES',
1031: i_method_name);
1032: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);

Line 1030: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES',

1026: raise ECX_UTILS.PROGRAM_EXIT;
1027: when others then
1028: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES');
1029: if(l_statementEnabled) then
1030: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES',
1031: i_method_name);
1032: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);
1033: end if;
1034: ecx_print_local.first_time_printing := true;

Line 1032: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);

1028: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES');
1029: if(l_statementEnabled) then
1030: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES',
1031: i_method_name);
1032: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);
1033: end if;
1034: ecx_print_local.first_time_printing := true;
1035: if (l_procedureEnabled)
1036: then

Line 1037: ecx_debug.pop(i_method_name);

1033: end if;
1034: ecx_print_local.first_time_printing := true;
1035: if (l_procedureEnabled)
1036: then
1037: ecx_debug.pop(i_method_name);
1038: end if;
1039: raise ECX_UTILS.PROGRAM_EXIT;
1040: end print_waiting_nodes;
1041:

Line 1049: ecx_debug.PUSH(i_method_name);

1045: i_method_name varchar2(2000) := 'ecx_print_local.print_waiting_nodes_attr';
1046: i_last_node_printed pls_integer;
1047: begin
1048: if(l_procedureEnabled) then
1049: ecx_debug.PUSH(i_method_name);
1050: end if;
1051:
1052: i_last_node_printed := last_node_printed + 1;
1053:

Line 1089: ecx_debug.POP(i_method_name);

1085: end if;
1086: last_node_printed := l_node_stack.LAST;
1087:
1088: if(l_procedureEnabled) then
1089: ecx_debug.POP(i_method_name);
1090: end if;
1091:
1092: exception
1093: when ecx_utils.program_exit

Line 1096: ecx_debug.pop(i_method_name);

1092: exception
1093: when ecx_utils.program_exit
1094: then
1095: if (l_procedureEnabled) then
1096: ecx_debug.pop(i_method_name);
1097: end if;
1098: raise ECX_UTILS.PROGRAM_EXIT;
1099: when others then
1100: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR');

Line 1100: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR');

1096: ecx_debug.pop(i_method_name);
1097: end if;
1098: raise ECX_UTILS.PROGRAM_EXIT;
1099: when others then
1100: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR');
1101: if(l_statementEnabled) then
1102: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR',
1103: i_method_name);
1104: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);

Line 1102: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR',

1098: raise ECX_UTILS.PROGRAM_EXIT;
1099: when others then
1100: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR');
1101: if(l_statementEnabled) then
1102: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR',
1103: i_method_name);
1104: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);
1105: end if;
1106: ecx_print_local.first_time_printing := true;

Line 1104: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);

1100: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR');
1101: if(l_statementEnabled) then
1102: ecx_debug.log(l_statement, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_WAITING_NODES_ATTR',
1103: i_method_name);
1104: ecx_debug.log(l_statement, 'resetting first_time',i_method_name);
1105: end if;
1106: ecx_print_local.first_time_printing := true;
1107: if (l_procedureEnabled)
1108: then

Line 1109: ecx_debug.pop(i_method_name);

1105: end if;
1106: ecx_print_local.first_time_printing := true;
1107: if (l_procedureEnabled)
1108: then
1109: ecx_debug.pop(i_method_name);
1110: end if;
1111: raise ECX_UTILS.PROGRAM_EXIT;
1112: end print_waiting_nodes_attr;
1113:

Line 1121: ecx_debug.push(i_method_name);

1117: l_suppress varchar2(1) := 'N';
1118: i_method_name varchar2(2000) := 'ecx_print_local.get_suppress_profile';
1119: begin
1120: if (l_procedureEnabled) then
1121: ecx_debug.push(i_method_name);
1122: end if;
1123: if (ecx_utils.g_install_mode is null) then
1124: ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
1125: end if;

Line 1137: ecx_debug.log(l_statement, 'ECX_SUPPRESS_EMPTY_TAGS',l_suppress,i_method_name);

1133: l_suppress := wf_core.translate('ECX_SUPPRESS_EMPTY_TAGS');
1134: end if;
1135:
1136: if(l_statementEnabled) then
1137: ecx_debug.log(l_statement, 'ECX_SUPPRESS_EMPTY_TAGS',l_suppress,i_method_name);
1138: end if;
1139: /* if profile option is not set assume empty tags should not be suppressed */
1140: if (l_suppress is null) then
1141: return false;

Line 1145: ecx_debug.POP(i_method_name);

1141: return false;
1142: end if;
1143:
1144: if(l_procedureEnabled) then
1145: ecx_debug.POP(i_method_name);
1146: end if;
1147:
1148: return (l_suppress = 'Y') OR (l_suppress = 'y');
1149:

Line 1155: ecx_debug.pop(i_method_name);

1151: when ecx_utils.program_exit
1152: then
1153: if (l_procedureEnabled)
1154: then
1155: ecx_debug.pop(i_method_name);
1156: end if;
1157: raise ECX_UTILS.PROGRAM_EXIT;
1158: when others
1159: then

Line 1160: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE');

1156: end if;
1157: raise ECX_UTILS.PROGRAM_EXIT;
1158: when others
1159: then
1160: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE');
1161: if(l_unexpectedEnabled)
1162: then
1163: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE',
1164: i_method_name);

Line 1163: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE',

1159: then
1160: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE');
1161: if(l_unexpectedEnabled)
1162: then
1163: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE',
1164: i_method_name);
1165: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);
1166: end if;
1167: ecx_print_local.first_time_printing := true;

Line 1165: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);

1161: if(l_unexpectedEnabled)
1162: then
1163: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.GET_SUPPRESS_PROFILE',
1164: i_method_name);
1165: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);
1166: end if;
1167: ecx_print_local.first_time_printing := true;
1168: if (l_procedureEnabled)
1169: then

Line 1170: ecx_debug.pop(i_method_name);

1166: end if;
1167: ecx_print_local.first_time_printing := true;
1168: if (l_procedureEnabled)
1169: then
1170: ecx_debug.pop(i_method_name);
1171: end if;
1172: raise ECX_UTILS.PROGRAM_EXIT;
1173:
1174: end get_suppress_profile;

Line 1201: ecx_debug.push(i_method_name);

1197: w_current_position pls_integer := -1;
1198:
1199: begin
1200: if (l_procedureEnabled) then
1201: ecx_debug.push(i_method_name);
1202: end if;
1203: if(l_statementEnabled) then
1204: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
1205: ecx_debug.log(l_statement,'i_index',i_index,i_method_name);

Line 1204: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);

1200: if (l_procedureEnabled) then
1201: ecx_debug.push(i_method_name);
1202: end if;
1203: if(l_statementEnabled) then
1204: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
1205: ecx_debug.log(l_statement,'i_index',i_index,i_method_name);
1206: end if;
1207: if(l_statementEnabled) then
1208: ecx_debug.log(l_statement,'count',ecx_utils.g_xml_frag.count,i_method_name);

Line 1205: ecx_debug.log(l_statement,'i_index',i_index,i_method_name);

1201: ecx_debug.push(i_method_name);
1202: end if;
1203: if(l_statementEnabled) then
1204: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
1205: ecx_debug.log(l_statement,'i_index',i_index,i_method_name);
1206: end if;
1207: if(l_statementEnabled) then
1208: ecx_debug.log(l_statement,'count',ecx_utils.g_xml_frag.count,i_method_name);
1209: end if;

Line 1208: ecx_debug.log(l_statement,'count',ecx_utils.g_xml_frag.count,i_method_name);

1204: ecx_debug.log(l_statement,'i_level',i_level,i_method_name);
1205: ecx_debug.log(l_statement,'i_index',i_index,i_method_name);
1206: end if;
1207: if(l_statementEnabled) then
1208: ecx_debug.log(l_statement,'count',ecx_utils.g_xml_frag.count,i_method_name);
1209: end if;
1210: if (ecx_utils.g_xml_frag.count >0) then
1211: for i in ecx_utils.g_xml_frag.FIRST .. ecx_utils.g_xml_frag.LAST
1212: loop

Line 1214: ecx_debug.log(l_statement,'var_pos',ecx_utils.g_xml_frag(i).variable_pos,i_method_name);

1210: if (ecx_utils.g_xml_frag.count >0) then
1211: for i in ecx_utils.g_xml_frag.FIRST .. ecx_utils.g_xml_frag.LAST
1212: loop
1213: if(l_statementEnabled) then
1214: ecx_debug.log(l_statement,'var_pos',ecx_utils.g_xml_frag(i).variable_pos,i_method_name);
1215: ecx_debug.log(l_statement,'value',ecx_utils.g_xml_frag(i).value,i_method_name);
1216: end if;
1217: end loop;
1218: end if;

Line 1215: ecx_debug.log(l_statement,'value',ecx_utils.g_xml_frag(i).value,i_method_name);

1211: for i in ecx_utils.g_xml_frag.FIRST .. ecx_utils.g_xml_frag.LAST
1212: loop
1213: if(l_statementEnabled) then
1214: ecx_debug.log(l_statement,'var_pos',ecx_utils.g_xml_frag(i).variable_pos,i_method_name);
1215: ecx_debug.log(l_statement,'value',ecx_utils.g_xml_frag(i).value,i_method_name);
1216: end if;
1217: end loop;
1218: end if;
1219:

Line 1228: ecx_debug.log(l_statement,'Current DTD Node=>'||i,ecx_utils.g_target(i).attribute_name,i_method_name);

1224:
1225: loop
1226: exit when i = ecx_utils.g_target.COUNT;
1227: if(l_statementEnabled) then
1228: ecx_debug.log(l_statement,'Current DTD Node=>'||i,ecx_utils.g_target(i).attribute_name,i_method_name);
1229: print_node_stack;
1230: end if;
1231:
1232: current_position := i;

Line 1234: ecx_debug.log(l_statement,'Set current position to', current_position,i_method_name);

1230: end if;
1231:
1232: current_position := i;
1233: if(l_statementEnabled) then
1234: ecx_debug.log(l_statement,'Set current position to', current_position,i_method_name);
1235: end if;
1236:
1237: if ecx_utils.g_target(i).attribute_type = 2
1238: then

Line 1243: ecx_debug.log(l_statement,'Attribute Value is not null',i_method_name);

1239: begin
1240: if(ecx_utils.g_target(i).value is not null)
1241: then
1242: if(l_statementEnabled) then
1243: ecx_debug.log(l_statement,'Attribute Value is not null',i_method_name);
1244: end if;
1245:
1246: print_waiting_nodes_attr;
1247:

Line 1256: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);

1252: ecx_utils.g_target(i).attribute_name,
1253: ecx_utils.g_target(i).value
1254: );
1255: if(l_statementEnabled) then
1256: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);
1257: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'="">',
1258: i_method_name);
1259: end if;
1260: if ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).is_clob is not null Then

Line 1257: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'="">',

1253: ecx_utils.g_target(i).value
1254: );
1255: if(l_statementEnabled) then
1256: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);
1257: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'="">',
1258: i_method_name);
1259: end if;
1260: if ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).is_clob is not null Then
1261: cdata_element_value(

Line 1272: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,

1268: element_value(ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).clob_value,
1269: ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value);
1270: end if;
1271: if(l_statementEnabled) then
1272: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,
1273: i_method_name);
1274: end if;
1275: end if;
1276:

Line 1285: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'=""',i_method_name);

1281: ecx_utils.g_target(i).attribute_name,
1282: ecx_utils.g_target(i).value
1283: );
1284: if(l_statementEnabled) then
1285: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'=""',i_method_name);
1286: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);
1287: end if;
1288: end if;
1289: else -- to close the parent if none of the attributes are to be printed.

Line 1286: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);

1282: ecx_utils.g_target(i).value
1283: );
1284: if(l_statementEnabled) then
1285: ecx_debug.log(l_statement,ecx_utils.g_target(i).attribute_name||'=""',i_method_name);
1286: ecx_debug.log(l_statement,ecx_utils.g_target(i).value,i_method_name);
1287: end if;
1288: end if;
1289: else -- to close the parent if none of the attributes are to be printed.
1290: if(last_node_printed = l_node_stack.LAST) -- if parent is on top stack and has been printed

Line 1309: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,i_method_name);

1305: ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value);
1306: end if;
1307: if(l_statementEnabled)
1308: then
1309: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,i_method_name);
1310: end if;
1311: end if;
1312: end if;
1313: end if;

Line 1324: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).value,i_method_name);

1320: ecx_utils.g_target(i).attribute_name,
1321: ecx_utils.g_target(i).value
1322: );
1323: if(l_unexpectedEnabled) then
1324: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).value,i_method_name);
1325: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).attribute_name||'="">',i_method_name);
1326: end if;
1327: if ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).is_clob is not null Then
1328: cdata_element_value(

Line 1325: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).attribute_name||'="">',i_method_name);

1321: ecx_utils.g_target(i).value
1322: );
1323: if(l_unexpectedEnabled) then
1324: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).value,i_method_name);
1325: ecx_debug.log(l_unexpected,ecx_utils.g_target(i).attribute_name||'="">',i_method_name);
1326: end if;
1327: if ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).is_clob is not null Then
1328: cdata_element_value(
1329: ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).clob_value,

Line 1339: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,

1335: element_value(ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).clob_value,
1336: ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value);
1337: end if;
1338: if(l_statementEnabled) then
1339: ecx_debug.log(l_statement,ecx_utils.g_target(ecx_utils.g_target(i).parent_attribute_id).value,
1340: i_method_name);
1341: end if;
1342: end if;
1343:

Line 1348: ecx_debug.log(l_statement, 'last_printed 1', last_printed,i_method_name);

1344: end;
1345:
1346: last_printed := ecx_utils.g_target(i).attribute_id;
1347: if(l_statementEnabled) then
1348: ecx_debug.log(l_statement, 'last_printed 1', last_printed,i_method_name);
1349: end if;
1350:
1351: elsif ecx_utils.g_target(i).attribute_type = 1
1352: then

Line 1369: ecx_debug.log(l_statement, 'condition true',i_method_name);

1365: if ecx_utils.g_target(i).parent_attribute_id =
1366: l_node_stack(l_node_stack.LAST)
1367: then
1368: if(l_statementEnabled) then
1369: ecx_debug.log(l_statement, 'condition true',i_method_name);
1370: end if;
1371: do_printing := true;
1372: else
1373: do_printing := false;

Line 1375: ecx_debug.log(l_statement, 'condition false',i_method_name);

1371: do_printing := true;
1372: else
1373: do_printing := false;
1374: if(l_statementEnabled) then
1375: ecx_debug.log(l_statement, 'condition false',i_method_name);
1376: end if;
1377: end if;
1378: end if;
1379: if (do_printing)

Line 1401: ecx_debug.log(l_statement,'value:',ecx_utils.g_target(i).value,

1397: */
1398: pop_discont_elements(ecx_utils.g_target(i).parent_attribute_id);
1399: end if;
1400: if(l_statementEnabled) then
1401: ecx_debug.log(l_statement,'value:',ecx_utils.g_target(i).value,
1402: i_method_name);
1403: ecx_debug.log(l_statement,'flag:',ecx_utils.g_target(i).required_flag,
1404: i_method_name);
1405: ecx_debug.log(l_statement,'attribute name:',ecx_utils.g_target(i).attribute_name,

Line 1403: ecx_debug.log(l_statement,'flag:',ecx_utils.g_target(i).required_flag,

1399: end if;
1400: if(l_statementEnabled) then
1401: ecx_debug.log(l_statement,'value:',ecx_utils.g_target(i).value,
1402: i_method_name);
1403: ecx_debug.log(l_statement,'flag:',ecx_utils.g_target(i).required_flag,
1404: i_method_name);
1405: ecx_debug.log(l_statement,'attribute name:',ecx_utils.g_target(i).attribute_name,
1406: i_method_name);
1407: end if;

Line 1405: ecx_debug.log(l_statement,'attribute name:',ecx_utils.g_target(i).attribute_name,

1401: ecx_debug.log(l_statement,'value:',ecx_utils.g_target(i).value,
1402: i_method_name);
1403: ecx_debug.log(l_statement,'flag:',ecx_utils.g_target(i).required_flag,
1404: i_method_name);
1405: ecx_debug.log(l_statement,'attribute name:',ecx_utils.g_target(i).attribute_name,
1406: i_method_name);
1407: end if;
1408:
1409: -- if suppress profile is true and node is optional and does not have a value then push it on the stack .

Line 1428: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name,

1424: if ecx_utils.g_target(i).has_attributes > 0
1425: then
1426: element_open(ecx_utils.g_target(i).attribute_name);
1427: if(l_statementEnabled) then
1428: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name,
1429: i_method_name);
1430: end if;
1431: else
1432: /** Change required for Clob Support -- 2263729 ***/

Line 1453: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name||'>',

1449: );
1450: end if;
1451: end if;
1452: if(l_statementEnabled) then
1453: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name||'>',
1454: i_method_name);
1455: end if;
1456: end if;
1457: xmlPUSH(ecx_utils.g_target(i).attribute_id);

Line 1460: ecx_debug.log(l_statement,'last_node_printed = ', last_node_printed, i_method_name);

1456: end if;
1457: xmlPUSH(ecx_utils.g_target(i).attribute_id);
1458: last_node_printed := l_node_stack.LAST;
1459: if(l_statementEnabled) then
1460: ecx_debug.log(l_statement,'last_node_printed = ', last_node_printed, i_method_name);
1461: end if;
1462: end if;
1463: ecx_print_local.last_printed := ecx_utils.g_target(i).attribute_id;
1464: if(l_statementEnabled) then

Line 1465: ecx_debug.log(l_statement,'last_printed ', last_printed,i_method_name);

1461: end if;
1462: end if;
1463: ecx_print_local.last_printed := ecx_utils.g_target(i).attribute_id;
1464: if(l_statementEnabled) then
1465: ecx_debug.log(l_statement,'last_printed ', last_printed,i_method_name);
1466: end if;
1467:
1468: elsif ecx_utils.g_target(i).parent_attribute_id <> l_node_stack(l_node_stack.LAST)
1469: then

Line 1476: ecx_debug.log(l_statement,'Abnormal Termination, Node Stack:','stack',i_method_name);

1472: exit when l_node_stack(l_node_stack.LAST) =
1473: ecx_utils.g_target(i).parent_attribute_id;
1474: -- or loop_count >= l_loop_max;
1475: if loop_count >= l_loop_max then
1476: ecx_debug.log(l_statement,'Abnormal Termination, Node Stack:','stack',i_method_name);
1477: print_node_stack;
1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);
1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);
1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);

Line 1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);

1474: -- or loop_count >= l_loop_max;
1475: if loop_count >= l_loop_max then
1476: ecx_debug.log(l_statement,'Abnormal Termination, Node Stack:','stack',i_method_name);
1477: print_node_stack;
1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);
1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);
1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);
1481: ecx_debug.log(l_statement,'Current target element: ',ecx_utils.g_target(i).attribute_name,i_method_name);
1482: raise_application_error(-20000,'Abnormal condition encountered, infinite loop detected');

Line 1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);

1475: if loop_count >= l_loop_max then
1476: ecx_debug.log(l_statement,'Abnormal Termination, Node Stack:','stack',i_method_name);
1477: print_node_stack;
1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);
1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);
1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);
1481: ecx_debug.log(l_statement,'Current target element: ',ecx_utils.g_target(i).attribute_name,i_method_name);
1482: raise_application_error(-20000,'Abnormal condition encountered, infinite loop detected');
1483: end if;

Line 1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);

1476: ecx_debug.log(l_statement,'Abnormal Termination, Node Stack:','stack',i_method_name);
1477: print_node_stack;
1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);
1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);
1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);
1481: ecx_debug.log(l_statement,'Current target element: ',ecx_utils.g_target(i).attribute_name,i_method_name);
1482: raise_application_error(-20000,'Abnormal condition encountered, infinite loop detected');
1483: end if;
1484:

Line 1481: ecx_debug.log(l_statement,'Current target element: ',ecx_utils.g_target(i).attribute_name,i_method_name);

1477: print_node_stack;
1478: ecx_debug.log(l_statement,'Value for i: ',i,i_method_name);
1479: ecx_debug.log(l_statement,'Start position: ',start_pos,i_method_name);
1480: ecx_debug.log(l_statement,'Current position: ',current_position,i_method_name);
1481: ecx_debug.log(l_statement,'Current target element: ',ecx_utils.g_target(i).attribute_name,i_method_name);
1482: raise_application_error(-20000,'Abnormal condition encountered, infinite loop detected');
1483: end if;
1484:
1485: /*

Line 1549: ecx_debug.log(l_statement,'',

1545: );
1546: end if;
1547:
1548: if(l_statementEnabled) then
1549: ecx_debug.log(l_statement,'',
1550: i_method_name);
1551: end if;
1552: end if;
1553: xmlPOP;

Line 1561: ecx_debug.log(l_statement,'l_loop_max reached: '||l_loop_max, i_method_name);

1557: if ( loop_count >= l_loop_max )
1558: then
1559: if(l_statementEnabled)
1560: then
1561: ecx_debug.log(l_statement,'l_loop_max reached: '||l_loop_max, i_method_name);
1562: end if;
1563: end if;
1564:
1565: /*

Line 1603: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name, i_method_name);

1599: then
1600: element_open(ecx_utils.g_target(i).attribute_name);
1601: if(l_statementEnabled)
1602: then
1603: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name, i_method_name);
1604: end if;
1605: else
1606: /** Change required for Clob Support -- 2263729 ***/
1607: if ecx_utils.g_target(i).is_clob is not null Then

Line 1627: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name||'>',

1623: );
1624: end if;
1625: end if;
1626: if(l_statementEnabled) then
1627: ecx_debug.log(l_statement,'<'||ecx_utils.g_target(i).attribute_name||'>',
1628: i_method_name);
1629: end if;
1630: end if;
1631: xmlPUSH(ecx_utils.g_target(i).attribute_id);

Line 1634: ecx_debug.log(l_statement, 'last_node_printed = ', last_node_printed,i_method_name);

1630: end if;
1631: xmlPUSH(ecx_utils.g_target(i).attribute_id);
1632: last_node_printed := l_node_stack.LAST;
1633: if(l_statementEnabled) then
1634: ecx_debug.log(l_statement, 'last_node_printed = ', last_node_printed,i_method_name);
1635: end if;
1636: end if;
1637: ecx_print_local.last_printed := ecx_utils.g_target(i).attribute_id;
1638: if(l_statementEnabled) then

Line 1639: ecx_debug.log(l_statement, 'last_printed', last_printed,i_method_name);

1635: end if;
1636: end if;
1637: ecx_print_local.last_printed := ecx_utils.g_target(i).attribute_id;
1638: if(l_statementEnabled) then
1639: ecx_debug.log(l_statement, 'last_printed', last_printed,i_method_name);
1640: end if;
1641: end if;
1642: end if;
1643: exit when ecx_utils.g_target.LAST = i;

Line 1651: ecx_debug.pop(i_method_name);

1647:
1648: append_clob;
1649:
1650: if (l_procedureEnabled) then
1651: ecx_debug.pop(i_method_name);
1652: end if;
1653:
1654: exception
1655: when ecx_utils.program_exit then

Line 1657: ecx_debug.pop(i_method_name);

1653:
1654: exception
1655: when ecx_utils.program_exit then
1656: if (l_procedureEnabled) then
1657: ecx_debug.pop(i_method_name);
1658: end if;
1659: ecx_print_local.suppress_profile := false;
1660: raise ECX_UTILS.PROGRAM_EXIT;
1661: when others then

Line 1662: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL');

1658: end if;
1659: ecx_print_local.suppress_profile := false;
1660: raise ECX_UTILS.PROGRAM_EXIT;
1661: when others then
1662: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL');
1663: if(l_unexpectedEnabled) then
1664: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL',
1665: i_method_name);
1666: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);

Line 1664: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL',

1660: raise ECX_UTILS.PROGRAM_EXIT;
1661: when others then
1662: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL');
1663: if(l_unexpectedEnabled) then
1664: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL',
1665: i_method_name);
1666: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);
1667: end if;
1668: ecx_print_local.first_time_printing := true;

Line 1666: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);

1662: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL');
1663: if(l_unexpectedEnabled) then
1664: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_NEW_LEVEL',
1665: i_method_name);
1666: ecx_debug.log(l_unexpected, 'resetting first_time',i_method_name);
1667: end if;
1668: ecx_print_local.first_time_printing := true;
1669: ecx_print_local.suppress_profile := false;
1670: if (l_procedureEnabled) then

Line 1671: ecx_debug.pop(i_method_name);

1667: end if;
1668: ecx_print_local.first_time_printing := true;
1669: ecx_print_local.suppress_profile := false;
1670: if (l_procedureEnabled) then
1671: ecx_debug.pop(i_method_name);
1672: end if;
1673: raise ECX_UTILS.PROGRAM_EXIT;
1674: end print_new_level;
1675:

Line 1696: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

1692: x_value := replace(x_value,i_apos, i_amp||'apos;');
1693: x_value := replace(x_value,i_quot, i_amp||'quot;');
1694: exception
1695: when value_error then
1696: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1697: if(l_unexpectedEnabled) then
1698: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1699: end if;
1700: raise ECX_UTILS.PROGRAM_EXIT;

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

1694: exception
1695: when value_error then
1696: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1697: if(l_unexpectedEnabled) then
1698: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1699: end if;
1700: raise ECX_UTILS.PROGRAM_EXIT;
1701: when ecx_utils.program_exit then
1702: raise ECX_UTILS.PROGRAM_EXIT;

Line 1704: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char');

1700: raise ECX_UTILS.PROGRAM_EXIT;
1701: when ecx_utils.program_exit then
1702: raise ECX_UTILS.PROGRAM_EXIT;
1703: when others then
1704: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char');
1705: if(l_unexpectedEnabled) then
1706: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char',i_method_name);
1707: end if;
1708: raise ecx_utils.program_exit;

Line 1706: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char',i_method_name);

1702: raise ECX_UTILS.PROGRAM_EXIT;
1703: when others then
1704: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char');
1705: if(l_unexpectedEnabled) then
1706: ecx_debug.log(l_unexpected,'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.escape_spec_char',i_method_name);
1707: end if;
1708: raise ecx_utils.program_exit;
1709: end escape_spec_char;
1710:

Line 1720: ecx_debug.log(l_statement, 'p_value', p_value,i_method_name);

1716: i_method_name varchar2(2000) := 'ecx_print_local.replace_spec_char';
1717:
1718: begin
1719: if(l_statementEnabled) then
1720: ecx_debug.log(l_statement, 'p_value', p_value,i_method_name);
1721: end if;
1722: if (p_value is null) then
1723: return;
1724: end if;

Line 1745: ecx_debug.log(l_statement,'x_value', x_value,i_method_name);

1741: x_value := replace(x_value,i_amp||'#x27;', i_apos);
1742: x_value := replace(x_value,i_amp||'#x22;', i_quot);
1743:
1744: if(l_statementEnabled) then
1745: ecx_debug.log(l_statement,'x_value', x_value,i_method_name);
1746: end if;
1747: exception
1748: when others then
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char');

Line 1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char');

1745: ecx_debug.log(l_statement,'x_value', x_value,i_method_name);
1746: end if;
1747: exception
1748: when others then
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char',i_method_name);
1752: end if;
1753: raise ecx_utils.program_exit;

Line 1751: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char',i_method_name);

1747: exception
1748: when others then
1749: ecx_debug.setErrorInfo(2, 30, SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char');
1750: if(l_unexpectedEnabled) then
1751: ecx_debug.log(l_unexpected, 'ECX', SQLERRM || ' - ECX_PRINT_LOCAL.replace_spec_char',i_method_name);
1752: end if;
1753: raise ecx_utils.program_exit;
1754: end replace_spec_char;
1755: procedure get_chunks

Line 1785: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

1781: i := i+ g_split_threshold;
1782: end loop;
1783: Exception
1784: when value_error then
1785: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1786: if(l_unexpectedEnabled) then
1787: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1788: end if;
1789: raise ECX_UTILS.PROGRAM_EXIT;

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

1783: Exception
1784: when value_error then
1785: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1786: if(l_unexpectedEnabled) then
1787: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1788: end if;
1789: raise ECX_UTILS.PROGRAM_EXIT;
1790: when ecx_utils.program_exit then
1791: raise ECX_UTILS.PROGRAM_EXIT;

Line 1793: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');

1789: raise ECX_UTILS.PROGRAM_EXIT;
1790: when ecx_utils.program_exit then
1791: raise ECX_UTILS.PROGRAM_EXIT;
1792: When Others Then
1793: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');
1794: if(l_unexpectedEnabled) then
1795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',
1796: i_method_Name);
1797: end if;

Line 1795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',

1791: raise ECX_UTILS.PROGRAM_EXIT;
1792: When Others Then
1793: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');
1794: if(l_unexpectedEnabled) then
1795: ecx_debug.log(l_unexpected, 'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',
1796: i_method_Name);
1797: end if;
1798: raise ecx_utils.program_exit;
1799: End;

Line 1830: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');

1826: i := i+ g_split_threshold;
1827: end loop;
1828: Exception
1829: when value_error then
1830: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1831: if(l_unexpectedEnabled) then
1832: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1833: end if;
1834: raise ECX_UTILS.PROGRAM_EXIT;

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

1828: Exception
1829: when value_error then
1830: ecx_debug.setErrorInfo(1, 30, 'ECX_INVALID_VARCHAR2_LEN');
1831: if(l_unexpectedEnabled) then
1832: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1833: end if;
1834: raise ECX_UTILS.PROGRAM_EXIT;
1835: when ecx_utils.program_exit then
1836: raise ECX_UTILS.PROGRAM_EXIT;

Line 1838: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');

1834: raise ECX_UTILS.PROGRAM_EXIT;
1835: when ecx_utils.program_exit then
1836: raise ECX_UTILS.PROGRAM_EXIT;
1837: When Others Then
1838: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');
1839: if(l_unexpectedEnabled) then
1840: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',
1841: i_method_name);
1842: end if;

Line 1840: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',

1836: raise ECX_UTILS.PROGRAM_EXIT;
1837: When Others Then
1838: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS');
1839: if(l_unexpectedEnabled) then
1840: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.GET_CHUNKS',
1841: i_method_name);
1842: end if;
1843: raise ecx_utils.program_exit;
1844: End;

Line 1875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT');

1871: return FALSE;
1872: end if;
1873: exception
1874: When Others Then
1875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT');
1876: if(l_unexpectedEnabled) then
1877: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT',
1878: i_method_name);
1879: end if;

Line 1877: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT',

1873: exception
1874: When Others Then
1875: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT');
1876: if(l_unexpectedEnabled) then
1877: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.HAS_FRAGMENT',
1878: i_method_name);
1879: end if;
1880: raise ecx_utils.program_exit;
1881:

Line 1910: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' -

1906: return FALSE;
1907: end if;
1908: EXCEPTION
1909: When Others Then
1910: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' -
1911: ECX_PRINT_LOCAL.HAS_FRAGMENT_VALUE');
1912: if(l_unexpectedEnabled) then
1913: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' -
1914: ECX_PRINT_LOCAL.HAS_FRAGMENT_VALUE',

Line 1913: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' -

1909: When Others Then
1910: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' -
1911: ECX_PRINT_LOCAL.HAS_FRAGMENT_VALUE');
1912: if(l_unexpectedEnabled) then
1913: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' -
1914: ECX_PRINT_LOCAL.HAS_FRAGMENT_VALUE',
1915: i_method_name);
1916: end if;
1917: raise ecx_utils.program_exit;

Line 1927: ecx_debug.push(i_method_name);

1923: is
1924: i_method_name varchar2(2000) := 'ecx_print_local.print_xml_fragment';
1925: begin
1926: if (l_procedureEnabled) then
1927: ecx_debug.push(i_method_name);
1928: end if;
1929:
1930: if(l_statementEnabled) then
1931: ecx_debug.log(l_statement,'attribute_name',

Line 1931: ecx_debug.log(l_statement,'attribute_name',

1927: ecx_debug.push(i_method_name);
1928: end if;
1929:
1930: if(l_statementEnabled) then
1931: ecx_debug.log(l_statement,'attribute_name',
1932: ecx_utils.g_target(var_pos).attribute_name,i_method_name);
1933: end if;
1934:
1935: if (print_tag) then

Line 1951: ecx_debug.pop(i_method_name);

1947: end if;
1948: end loop;
1949: end if;
1950: if (l_procedureEnabled) then
1951: ecx_debug.pop(i_method_name);
1952: end if;
1953: EXCEPTION
1954: When Others Then
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT');

Line 1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT');

1951: ecx_debug.pop(i_method_name);
1952: end if;
1953: EXCEPTION
1954: When Others Then
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT');
1956: if(l_unexpectedEnabled) then
1957: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT',
1958: i_method_name);
1959: end if;

Line 1957: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT',

1953: EXCEPTION
1954: When Others Then
1955: ecx_debug.setErrorInfo(2, 30, ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT');
1956: if(l_unexpectedEnabled) then
1957: ecx_debug.log(l_unexpected,'ECX', ecx_utils.i_errbuf || SQLERRM || ' - ECX_PRINT_LOCAL.PRINT_XML_FRAGMENT',
1958: i_method_name);
1959: end if;
1960: raise ecx_utils.program_exit;
1961: end;