APPS.ECX_INBOUND_NEW dependencies on ECX_DEBUG

Line 4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

1: PACKAGE BODY ecx_inbound_new as
2: --$Header: ECXINNB.pls 120.7 2011/03/14 09:37:12 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
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_inbound_new as
2: --$Header: ECXINNB.pls 120.7 2011/03/14 09:37:12 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
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: ECXINNB.pls 120.7 2011/03/14 09:37:12 jmaddila ship $
3:
4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;
5: l_statement PLS_INTEGER := ecx_debug.g_statement;
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: p_current_element_pos PLS_INTEGER:=-1;

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: p_current_element_pos PLS_INTEGER:=-1;
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: p_current_element_pos PLS_INTEGER:=-1;
11:
12: TYPE attribute_rec is RECORD

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: p_current_element_pos PLS_INTEGER:=-1;
11:
12: TYPE attribute_rec is RECORD
13: (

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

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

Line 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 74: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.GET_ELEMENT_VALUE');

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

Line 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 108: ecx_debug.push(i_method_name);

104: i_single varchar2(3):= '''';
105: begin
106:
107: if (l_procedureEnabled) then
108: ecx_debug.push(i_method_name);
109: end if;
110: i_found := false;
111: i_update := false;
112:

Line 116: ecx_debug.pop(i_method_name);

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;
118: return true;
119: end if;
120:

Line 135: ecx_debug.log(l_statement,l_attr_rec(l_attr_rec.COUNT).attribute_name,

131: l_attr_rec(l_attr_rec.COUNT).value := i_value;
132:
133: -- Search for the attribute in the XML File
134: if(l_statementEnabled) then
135: ecx_debug.log(l_statement,l_attr_rec(l_attr_rec.COUNT).attribute_name,
136: l_attr_rec(l_attr_rec.COUNT).value,i_method_name);
137: end if;
138: i_string := i_string ||' '||l_attr_rec(l_attr_rec.COUNT).attribute_name ||
139: ' = '|| i_single||l_attr_rec(l_attr_rec.COUNT).value || i_single||' ,';

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

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;
153: end if;
154: if (l_procedureEnabled) then

Line 155: ecx_debug.pop(i_method_name);

151: end if;
152: execute immediate i_string;
153: end if;
154: if (l_procedureEnabled) then
155: ecx_debug.pop(i_method_name);
156: end if;
157:
158: return i_update;
159:

Line 163: ecx_debug.pop(i_method_name);

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;
166:
167: when others then

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

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

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

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;
175: raise ecx_utils.program_exit;
176: end setDocLogsAttributes;
177:

Line 183: ecx_debug.log(l_statement,'Level Stack Status','====',i_method_name);

179: procedure print_stack is
180: i_method_name varchar2(2000) := 'ecx_inbound_new.print_stack';
181: begin
182: if(l_statementEnabled) then
183: ecx_debug.log(l_statement,'Level Stack Status','====',i_method_name);
184: end if;
185: for i in 1..l_level_stack.COUNT
186: loop
187: if(l_statementEnabled) then

Line 188: ecx_debug.log(l_statement,l_level_stack(i),i_method_name);

184: end if;
185: for i in 1..l_level_stack.COUNT
186: loop
187: if(l_statementEnabled) then
188: ecx_debug.log(l_statement,l_level_stack(i),i_method_name);
189: end if;
190: end loop;
191: exception
192: when others then

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

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

Line 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 209: ecx_debug.push(i_method_name);

205: i_method_name varchar2(2000) := 'ecx_inbound_new.popstack';
206:
207: begin
208: if (l_procedureEnabled) then
209: ecx_debug.push(i_method_name);
210: end if;
211: if(l_statementEnabled) then
212: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
213: print_stack;

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

208: if (l_procedureEnabled) then
209: ecx_debug.push(i_method_name);
210: end if;
211: if(l_statementEnabled) then
212: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
213: print_stack;
214: end if;
215:
216: if l_level_stack.COUNT = 0

Line 219: ecx_debug.log(l_statement,'Stack Error. Nothing to pop','xxxxx',i_method_name);

215:
216: if l_level_stack.COUNT = 0
217: then
218: if(l_statementEnabled) then
219: ecx_debug.log(l_statement,'Stack Error. Nothing to pop','xxxxx',i_method_name);
220: end if;
221: if (l_procedureEnabled) then
222: ecx_debug.pop(i_method_name);
223: end if;

Line 222: ecx_debug.pop(i_method_name);

218: if(l_statementEnabled) then
219: ecx_debug.log(l_statement,'Stack Error. Nothing to pop','xxxxx',i_method_name);
220: end if;
221: if (l_procedureEnabled) then
222: ecx_debug.pop(i_method_name);
223: end if;
224: return;
225: end if;
226:

Line 237: ecx_debug.pop(i_method_name);

233: print_stack;
234: end if;
235:
236: if (l_procedureEnabled) then
237: ecx_debug.pop(i_method_name);
238: end if;
239:
240: exception
241: WHEN ecx_utils.program_exit then

Line 243: ecx_debug.pop(i_method_name);

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;
246:
247: when others then

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

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

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

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;
255: raise ecx_utils.program_exit;
256: end popStack;
257:

Line 266: ecx_debug.push(i_method_name);

262: ) is
263: i_method_name varchar2(2000) := 'ecx_inbound_new.pushstack';
264: begin
265: if (l_procedureEnabled) then
266: ecx_debug.push(i_method_name);
267: end if;
268: if(l_statementEnabled) then
269: ecx_debug.log(l_statement,i,i_method_name);
270: print_stack;

Line 269: ecx_debug.log(l_statement,i,i_method_name);

265: if (l_procedureEnabled) then
266: ecx_debug.push(i_method_name);
267: end if;
268: if(l_statementEnabled) then
269: ecx_debug.log(l_statement,i,i_method_name);
270: print_stack;
271: end if;
272:
273: if (l_level_stack.COUNT = 0) or

Line 282: ecx_debug.pop(i_method_name);

278: print_stack;
279: end if;
280:
281: if (l_procedureEnabled) then
282: ecx_debug.pop(i_method_name);
283: end if;
284: return;
285: end if;
286:

Line 291: ecx_debug.pop(i_method_name);

287: if (i = l_level_stack(l_level_stack.COUNT)) then
288: popStack(i);
289: l_level_stack(l_level_stack.COUNT+1) := i;
290: if (l_procedureEnabled) then
291: ecx_debug.pop(i_method_name);
292: end if;
293: return;
294: end if;
295:

Line 311: ecx_debug.pop(i_method_name);

307: print_stack;
308: end if;
309:
310: if (l_procedureEnabled) then
311: ecx_debug.pop(i_method_name);
312: end if;
313:
314: exception
315: WHEN ecx_utils.program_exit then

Line 317: ecx_debug.pop(i_method_name);

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;
320:
321: when others then

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

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

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

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;
329: raise ecx_utils.program_exit;
330: end pushStack;
331:

Line 337: ecx_debug.push(i_method_name);

333: procedure popall is
334: i_method_name varchar2(2000) := 'ecx_inbound_new.popall';
335: begin
336: if (l_procedureEnabled) then
337: ecx_debug.push(i_method_name);
338: end if;
339:
340: if(l_statementEnabled) then
341: print_stack;

Line 354: ecx_debug.pop(i_method_name);

350: print_stack;
351: end if;
352:
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

Line 359: 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;
362:
363: when others then

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

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

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

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;
371: raise ecx_utils.program_exit;
372: end popall;
373:

Line 385: ecx_debug.push(i_method_name);

381: ) is
382: i_method_name varchar2(2000) := 'ecx_inbound_new.get_cond_node_value';
383: begin
384: if (l_procedureEnabled) then
385: ecx_debug.push(i_method_name);
386: end if;
387: x_node_value := null;
388:
389: if(l_statementEnabled) then

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

386: end if;
387: x_node_value := null;
388:
389: if(l_statementEnabled) then
390: ecx_debug.log(l_statement,'p_nodeStartIndex', p_nodeStartIndex,i_method_name);
391: ecx_debug.log(l_statement, 'p_xmlParentIndex', p_xmlParentIndex,i_method_name);
392: end if;
393:
394: for i in p_nodeStartIndex+1..p_nodeList.COUNT loop

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

387: x_node_value := null;
388:
389: if(l_statementEnabled) then
390: ecx_debug.log(l_statement,'p_nodeStartIndex', p_nodeStartIndex,i_method_name);
391: ecx_debug.log(l_statement, 'p_xmlParentIndex', p_xmlParentIndex,i_method_name);
392: end if;
393:
394: for i in p_nodeStartIndex+1..p_nodeList.COUNT loop
395: if (p_nodeList(i).parentIndex > p_xmlParentIndex) then

Line 399: ecx_debug.log(l_statement,'value', p_nodeList(i).value,i_method_name);

395: if (p_nodeList(i).parentIndex > p_xmlParentIndex) then
396: if (p_nodeList(i).name = p_node_name) then
397: x_node_value := p_nodeList(i).value;
398: if(l_statementEnabled) then
399: ecx_debug.log(l_statement,'value', p_nodeList(i).value,i_method_name);
400: end if;
401: exit;
402: end if;
403: else

Line 409: ecx_debug.log(l_statement, 'cond node value', x_node_value,i_method_name);

405: end if;
406: end loop;
407:
408: if(l_statementEnabled) then
409: ecx_debug.log(l_statement, 'cond node value', x_node_value,i_method_name);
410: end if;
411: if (l_procedureEnabled) then
412: ecx_debug.pop(i_method_name);
413: end if;

Line 412: ecx_debug.pop(i_method_name);

408: if(l_statementEnabled) then
409: ecx_debug.log(l_statement, 'cond node value', x_node_value,i_method_name);
410: end if;
411: if (l_procedureEnabled) then
412: ecx_debug.pop(i_method_name);
413: end if;
414:
415: exception
416: WHEN ecx_utils.program_exit then

Line 418: ecx_debug.pop(i_method_name);

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;
421:
422: when others then

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

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

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

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;
430: raise ecx_utils.program_exit;
431: end get_cond_node_value;
432:

Line 457: ecx_debug.push(i_method_name);

453: i_parent_node_pos pls_integer;
454:
455: BEGIN
456: if (l_procedureEnabled) then
457: ecx_debug.push(i_method_name);
458: end if;
459:
460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,i_method_name);

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

457: ecx_debug.push(i_method_name);
458: end if;
459:
460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,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);

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

458: end if;
459:
460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,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);

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

459:
460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,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;

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

460: if(l_statementEnabled) then
461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,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:

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

461: ecx_debug.log(l_statement, 'p_node_name', p_node_name,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;

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 489: ecx_debug.log(l_statement,'p_cond_node', p_cond_node,i_method_name);

485:
486: if (p_cond_node is not null) then
487:
488: if(l_statementEnabled) then
489: ecx_debug.log(l_statement,'p_cond_node', p_cond_node,i_method_name);
490: ecx_debug.log(l_statement, 'p_cond_node_type', p_cond_node_type,
491: i_method_name);
492: end if;
493: if (p_cond_node <> p_node_name) then

Line 490: ecx_debug.log(l_statement, 'p_cond_node_type', p_cond_node_type,

486: if (p_cond_node is not null) then
487:
488: if(l_statementEnabled) then
489: ecx_debug.log(l_statement,'p_cond_node', p_cond_node,i_method_name);
490: ecx_debug.log(l_statement, 'p_cond_node_type', p_cond_node_type,
491: i_method_name);
492: end if;
493: if (p_cond_node <> p_node_name) then
494: get_cond_node_value(p_nodeList,

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

520: exit;
521:
522: elsif (l_node_id = p_parent_node_id) then
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;

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

531: end loop;
532: end if;
533:
534: if(l_statementEnabled) then
535: ecx_debug.log(l_statement,'l_node_id', l_node_id,i_method_name);
536: ecx_debug.log(l_statement, 'x_node_pos', x_node_pos,i_method_name);
537: end if;
538: if (l_procedureEnabled) then
539: ecx_debug.pop(i_method_name);

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

532: end if;
533:
534: if(l_statementEnabled) then
535: ecx_debug.log(l_statement,'l_node_id', l_node_id,i_method_name);
536: ecx_debug.log(l_statement, 'x_node_pos', x_node_pos,i_method_name);
537: end if;
538: if (l_procedureEnabled) then
539: ecx_debug.pop(i_method_name);
540: end if;

Line 539: ecx_debug.pop(i_method_name);

535: ecx_debug.log(l_statement,'l_node_id', l_node_id,i_method_name);
536: ecx_debug.log(l_statement, 'x_node_pos', x_node_pos,i_method_name);
537: end if;
538: if (l_procedureEnabled) then
539: ecx_debug.pop(i_method_name);
540: end if;
541: return (l_node_id);
542:
543: EXCEPTION

Line 546: ecx_debug.pop(i_method_name);

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;
549:
550: when others then

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

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

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

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;
558: raise ecx_utils.program_exit;
559: END get_node_id;
560:

Line 578: ecx_debug.push(i_method_name);

574: l_len NUMBER;
575: l_temp varchar2(32767);
576: BEGIN
577: if (l_procedureEnabled) then
578: ecx_debug.push(i_method_name);
579: end if;
580:
581:
582: if(l_statementEnabled) then

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

579: end if;
580:
581:
582: if(l_statementEnabled) then
583: ecx_debug.log(l_statement,'p_int_col_pos', p_int_col_pos,i_method_name);
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:

Line 584: ecx_debug.log(l_statement, 'node value', p_value,i_method_name);

580:
581:
582: if(l_statementEnabled) then
583: ecx_debug.log(l_statement,'p_int_col_pos', p_int_col_pos,i_method_name);
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;

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

581:
582: if(l_statementEnabled) then
583: ecx_debug.log(l_statement,'p_int_col_pos', p_int_col_pos,i_method_name);
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:

Line 612: ecx_debug.log(l_statement,'xref return code',

608: end if;
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:

Line 621: ecx_debug.log(l_statement, 'Code Conversion uses the original code.',

617: if (l_return_status = ecx_code_conversion_pvt.G_RET_STS_ERROR) or
618: (l_return_status = ecx_code_conversion_pvt.G_RET_STS_UNEXP_ERROR) or
619: (l_return_status = ECX_CODE_CONVERSION_PVT.g_xref_not_found) then
620: if(l_statementEnabled) then
621: ecx_debug.log(l_statement, 'Code Conversion uses the original code.',
622: i_method_name);
623: end if;
624: else
625: if (l_return_status = ECX_CODE_CONVERSION_PVT.g_recv_xref_not_found) then

Line 627: ecx_debug.log(l_statement, 'Code Conversion uses the sender converted value',

623: end if;
624: else
625: if (l_return_status = ECX_CODE_CONVERSION_PVT.g_recv_xref_not_found) then
626: if(l_statementEnabled) then
627: ecx_debug.log(l_statement, 'Code Conversion uses the sender converted value',
628: p_value,i_method_name);
629: end if;
630: end if;
631: if(l_statementEnabled) then

Line 632: ecx_debug.log(l_statement, 'node value', p_value,i_method_name);

628: p_value,i_method_name);
629: end if;
630: end if;
631: if(l_statementEnabled) then
632: ecx_debug.log(l_statement, 'node value', p_value,i_method_name);
633: end if;
634: end if;
635: end if;
636:

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 675: ecx_debug.pop(i_method_name);

671: p_int_col_pos,i_method_name);
672: end if;
673:
674: if (l_procedureEnabled) then
675: ecx_debug.pop(i_method_name);
676: end if;
677:
678: EXCEPTION
679: WHEN no_data_found then

Line 681: ecx_debug.log(l_unexpected, 'Internal Column Position and Level not mapped for ',

677:
678: EXCEPTION
679: WHEN no_data_found then
680: if(l_unexpectedEnabled) then
681: ecx_debug.log(l_unexpected, 'Internal Column Position and Level not mapped for ',
682: p_int_col_pos,i_method_name);
683: end if;
684: if (l_procedureEnabled) then
685: ecx_debug.pop(i_method_name);

Line 685: ecx_debug.pop(i_method_name);

681: ecx_debug.log(l_unexpected, 'Internal Column Position and Level not mapped for ',
682: p_int_col_pos,i_method_name);
683: end if;
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

Line 690: 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;
693:
694: WHEN others then

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

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

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

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;
702: raise ecx_utils.program_exit;
703: END process_node;
704:

Line 712: ecx_debug.log(l_statement,'Stack('||i||')',

708: i_method_name varchar2(2000) := 'ecx_inbound_new.printNodeInfoStack';
709: begin
710: for i in node_info_stack.first..node_info_stack.last loop
711: if(l_statementEnabled) then
712: ecx_debug.log(l_statement,'Stack('||i||')',
713: node_info_stack(i).parent_node_id||'-'||
714: node_info_stack(i).parent_node_pos||'-'||
715: node_info_stack(i).pre_child_name||'-'||
716: node_info_stack(i).parent_xml_node_indx||'-'||

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

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

Line 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 748: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.pushNodeInfoStack');

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

Line 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 783: ecx_debug.setErrorInfo(2, 30, SQLERRM || '- ECX_INBOUND_NEW.popNodeInfoStack');

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

Line 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 815: ecx_debug.push(i_method_name);

811: l_cdata_flag varchar2(1) := 'N';
812:
813: begin
814: if (l_procedureEnabled) then
815: ecx_debug.push(i_method_name);
816: end if;
817: if(l_statementEnabled) then
818: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
819: ecx_debug.log(l_statement, 'p_next', p_next,i_method_name);

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

814: if (l_procedureEnabled) then
815: ecx_debug.push(i_method_name);
816: end if;
817: if(l_statementEnabled) then
818: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
819: ecx_debug.log(l_statement, 'p_next', p_next,i_method_name);
820: ecx_debug.log(l_statement, 'p_count', p_count,i_method_name);
821: end if;
822: if not (l_docLogsAttrSet) then

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

815: ecx_debug.push(i_method_name);
816: end if;
817: if(l_statementEnabled) then
818: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
819: ecx_debug.log(l_statement, 'p_next', p_next,i_method_name);
820: ecx_debug.log(l_statement, 'p_count', p_count,i_method_name);
821: end if;
822: if not (l_docLogsAttrSet) then
823: l_docLogsAttrSet := setDocLogsAttributes(p_nodeList, p_count);

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

816: end if;
817: if(l_statementEnabled) then
818: ecx_debug.log(l_statement,'p_level', p_level,i_method_name);
819: ecx_debug.log(l_statement, 'p_next', p_next,i_method_name);
820: ecx_debug.log(l_statement, 'p_count', p_count,i_method_name);
821: end if;
822: if not (l_docLogsAttrSet) then
823: l_docLogsAttrSet := setDocLogsAttributes(p_nodeList, p_count);
824: end if;

Line 839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);

835: l_cdata_flag := p_nodelist(i).isCDATA;
836:
837:
838: if(l_statementEnabled) then
839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);
840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);

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

836:
837:
838: if(l_statementEnabled) then
839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);
840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',

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

837:
838: if(l_statementEnabled) then
839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);
840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',
845: dbms_lob.getLength(l_node_clob_value),i_method_name);

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

838: if(l_statementEnabled) then
839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);
840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',
845: dbms_lob.getLength(l_node_clob_value),i_method_name);
846: ecx_debug.log(l_statement, 'l_cdata_flag is',l_cdata_flag,i_method_name);

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

839: ecx_debug.log(l_statement,'l_node_indx', i,i_method_name);
840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',
845: dbms_lob.getLength(l_node_clob_value),i_method_name);
846: ecx_debug.log(l_statement, 'l_cdata_flag is',l_cdata_flag,i_method_name);
847: end if;

Line 844: ecx_debug.log(l_statement, 'l_node_clob_value length',

840: ecx_debug.log(l_statement, 'l_node_name', l_node_name,i_method_name);
841: ecx_debug.log(l_statement, 'l_node_value', l_node_value,i_method_name);
842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',
845: dbms_lob.getLength(l_node_clob_value),i_method_name);
846: ecx_debug.log(l_statement, 'l_cdata_flag is',l_cdata_flag,i_method_name);
847: end if;
848: -- compare the current node parent to the previous node parent.

Line 846: ecx_debug.log(l_statement, 'l_cdata_flag is',l_cdata_flag,i_method_name);

842: ecx_debug.log(l_statement, 'l_node_type', l_node_type,i_method_name);
843: ecx_debug.log(l_statement, 'l_parent_index', l_parent_index,i_method_name);
844: ecx_debug.log(l_statement, 'l_node_clob_value length',
845: dbms_lob.getLength(l_node_clob_value),i_method_name);
846: ecx_debug.log(l_statement, 'l_cdata_flag is',l_cdata_flag,i_method_name);
847: end if;
848: -- compare the current node parent to the previous node parent.
849: -- if current < previous, then it means the new node is at a highter level.
850: -- if current > previous, then it means the new xml node is a child of previous.

Line 905: ecx_debug.pop(i_method_name);

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;
907:
908: EXCEPTION
909: WHEN ecx_utils.program_exit then

Line 913: ecx_debug.pop(i_method_name);

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.
916: -- setErrorInfo has already set and java needs the x_err_msg
917: -- to determine if any error occurred.

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

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

Line 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 927: ecx_debug.pop(i_method_name);

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
930: end processLevel;
931:

Line 940: ecx_debug.push(i_method_name);

936: i_root_name varchar2(2000);
937:
938: BEGIN
939: if (l_procedureEnabled) then
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;

Line 974: ecx_debug.pop(i_method_name);

970: -- In-processing for Document level
971: ecx_actions.execute_stage_data(20,0,'T');
972:
973: if (l_procedureEnabled) then
974: ecx_debug.pop(i_method_name);
975: end if;
976:
977: EXCEPTION
978: WHEN ecx_utils.program_exit then

Line 980: ecx_debug.pop(i_method_name);

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;
983:
984: WHEN OTHERS THEN

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

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

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

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;
992: raise ecx_utils.program_exit;
993: END startDocument;
994:

Line 1003: ecx_debug.push(i_method_name);

999:
1000: i_method_name varchar2(2000) := 'ecx_inbound_new.endDocument';
1001: begin
1002: if (l_procedureEnabled) then
1003: ecx_debug.push(i_method_name);
1004: end if;
1005: popall;
1006:
1007: if (ecx_utils.structure_printing)

Line 1022: ecx_debug.log(l_statement, 'Total record processed',

1018: -- Post-Processing for Source
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

Line 1027: ecx_debug.pop(i_method_name);

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);
1028: end if;
1029:
1030: EXCEPTION
1031: WHEN ecx_utils.program_exit then

Line 1033: ecx_debug.pop(i_method_name);

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;
1036:
1037: WHEN OTHERS THEN

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

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

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

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;
1045: raise ecx_utils.program_exit;
1046: END endDocument;
1047:

Line 1077: ecx_debug.setErrorInfo(1, 20, p_err_msg);

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);
1081: end if;

Line 1079: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);

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);
1081: end if;
1082: raise ecx_utils.program_exit;
1083:

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 1091: ecx_debug.setErrorInfo(1, 20, p_err_msg);

1087: elsif (p_err_code = IO_EXCEPTION) then
1088: raise Load_XML_Exception;
1089:
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;

Line 1093: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);

1089:
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:

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 1104: ecx_debug.setErrorInfo(2, 30, p_err_msg);

1100: end if;
1101:
1102: exception
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;

Line 1106: ecx_debug.log(l_unexpected,'Error Code: ' ||p_err_code,i_method_name);

1102: exception
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:

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 1137: ecx_debug.push(i_method_name);

1133: where map_id = p_map_id;
1134:
1135: begin
1136: if (l_procedureEnabled) then
1137: ecx_debug.push(i_method_name);
1138: end if;
1139:
1140: open get_map_code(p_map_id);
1141: fetch get_map_code

Line 1147: l_err_msg := LoadXML(ecx_debug.g_debug_level, p_payload, l_map_code, l_err_code);

1143: close get_map_code;
1144: startDocument;
1145:
1146:
1147: l_err_msg := LoadXML(ecx_debug.g_debug_level, p_payload, l_map_code, l_err_code);
1148:
1149: if (l_err_code is not null and l_err_code > 0) then
1150: raise_loadxml_err(l_err_code, l_err_msg);
1151: end if;

Line 1154: ecx_debug.pop(i_method_name);

1150: raise_loadxml_err(l_err_code, l_err_msg);
1151: end if;
1152: endDocument (x_xmlclob, x_parseXML);
1153: if (l_procedureEnabled) then
1154: ecx_debug.pop(i_method_name);
1155: end if;
1156:
1157: EXCEPTION
1158: WHEN ecx_utils.program_exit then

Line 1161: ecx_debug.pop(i_method_name);

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;
1163: raise ecx_utils.program_exit;
1164:
1165: WHEN OTHERS THEN

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

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

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

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;
1174: raise ecx_utils.program_exit;
1175: end process_xml_doc;
1176: