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

Line 4: l_procedure PLS_INTEGER := ecx_debug.g_procedure;

1: PACKAGE BODY ecx_attachment AS
2: -- $Header: ECXATCHB.pls 120.2 2006/05/24 16:05:25 susaha 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_attachment AS
2: -- $Header: ECXATCHB.pls 120.2 2006/05/24 16:05:25 susaha 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: ECXATCHB.pls 120.2 2006/05/24 16:05:25 susaha 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: -- private variables, types and functions

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: -- private variables, types and functions
12: EMBEDDED_PROGRAM_NAME CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';

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: -- private variables, types and functions
12: EMBEDDED_PROGRAM_NAME CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';
13: EMBEDDED_PROGRAM_TAG CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';

Line 82: ecx_debug.push(i_method_name);

78:
79: BEGIN
80:
81: if (l_procedureEnabled) then
82: ecx_debug.push(i_method_name);
83: end if;
84: if(l_statementEnabled) then
85: ecx_debug.log(l_statement,'i_main_doc_id', i_main_doc_id,i_method_name);
86: ecx_debug.log(l_statement,'i_file_content_type', i_file_content_type,i_method_name);

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

81: if (l_procedureEnabled) then
82: ecx_debug.push(i_method_name);
83: end if;
84: if(l_statementEnabled) then
85: ecx_debug.log(l_statement,'i_main_doc_id', i_main_doc_id,i_method_name);
86: ecx_debug.log(l_statement,'i_file_content_type', i_file_content_type,i_method_name);
87: ecx_debug.log(l_statement,'i_file_format', i_file_format,i_method_name);
88: end if;
89:

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

82: ecx_debug.push(i_method_name);
83: end if;
84: if(l_statementEnabled) then
85: ecx_debug.log(l_statement,'i_main_doc_id', i_main_doc_id,i_method_name);
86: ecx_debug.log(l_statement,'i_file_content_type', i_file_content_type,i_method_name);
87: ecx_debug.log(l_statement,'i_file_format', i_file_format,i_method_name);
88: end if;
89:
90: -- Check mode

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

83: end if;
84: if(l_statementEnabled) then
85: ecx_debug.log(l_statement,'i_main_doc_id', i_main_doc_id,i_method_name);
86: ecx_debug.log(l_statement,'i_file_content_type', i_file_content_type,i_method_name);
87: ecx_debug.log(l_statement,'i_file_format', i_file_format,i_method_name);
88: end if;
89:
90: -- Check mode
91: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

Line 207: ecx_debug.log(l_statement,'attached_document_id in FND_ATTACHED_DOCUMENTS', l_attached_id,i_method_name);

203: l_dynamic_sql_str6 := 'SELECT fnd_attached_documents_s.nextval FROM dual';
204: EXECUTE IMMEDIATE l_dynamic_sql_str6 INTO l_attached_id;
205:
206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement,'attached_document_id in FND_ATTACHED_DOCUMENTS', l_attached_id,i_method_name);
208: ecx_debug.log(l_statement,'current_attachment_id in FND_ATTACHED_DOCUMENTS',l_cur_doc_id,i_method_name);
209: ecx_debug.log(l_statement,'seq_num in FND_ATTACHED_DOCUMENTS', l_seq_num,i_method_name);
210: ecx_debug.log(l_statement,'pk2_value in FND_ATTACHED_DOCUMENTS', i_main_doc_id,i_method_name);
211: end if;

Line 208: ecx_debug.log(l_statement,'current_attachment_id in FND_ATTACHED_DOCUMENTS',l_cur_doc_id,i_method_name);

204: EXECUTE IMMEDIATE l_dynamic_sql_str6 INTO l_attached_id;
205:
206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement,'attached_document_id in FND_ATTACHED_DOCUMENTS', l_attached_id,i_method_name);
208: ecx_debug.log(l_statement,'current_attachment_id in FND_ATTACHED_DOCUMENTS',l_cur_doc_id,i_method_name);
209: ecx_debug.log(l_statement,'seq_num in FND_ATTACHED_DOCUMENTS', l_seq_num,i_method_name);
210: ecx_debug.log(l_statement,'pk2_value in FND_ATTACHED_DOCUMENTS', i_main_doc_id,i_method_name);
211: end if;
212:

Line 209: ecx_debug.log(l_statement,'seq_num in FND_ATTACHED_DOCUMENTS', l_seq_num,i_method_name);

205:
206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement,'attached_document_id in FND_ATTACHED_DOCUMENTS', l_attached_id,i_method_name);
208: ecx_debug.log(l_statement,'current_attachment_id in FND_ATTACHED_DOCUMENTS',l_cur_doc_id,i_method_name);
209: ecx_debug.log(l_statement,'seq_num in FND_ATTACHED_DOCUMENTS', l_seq_num,i_method_name);
210: ecx_debug.log(l_statement,'pk2_value in FND_ATTACHED_DOCUMENTS', i_main_doc_id,i_method_name);
211: end if;
212:
213: l_dynamic_sql_str7 := 'INSERT INTO fnd_attached_documents

Line 210: ecx_debug.log(l_statement,'pk2_value in FND_ATTACHED_DOCUMENTS', i_main_doc_id,i_method_name);

206: if(l_statementEnabled) then
207: ecx_debug.log(l_statement,'attached_document_id in FND_ATTACHED_DOCUMENTS', l_attached_id,i_method_name);
208: ecx_debug.log(l_statement,'current_attachment_id in FND_ATTACHED_DOCUMENTS',l_cur_doc_id,i_method_name);
209: ecx_debug.log(l_statement,'seq_num in FND_ATTACHED_DOCUMENTS', l_seq_num,i_method_name);
210: ecx_debug.log(l_statement,'pk2_value in FND_ATTACHED_DOCUMENTS', i_main_doc_id,i_method_name);
211: end if;
212:
213: l_dynamic_sql_str7 := 'INSERT INTO fnd_attached_documents
214: (attached_document_id,

Line 259: ecx_debug.pop(i_method_name);

255:
256: l_progress := '0004';
257:
258: if (l_procedureEnabled) then
259: ecx_debug.pop(i_method_name);
260: end if;
261:
262: EXCEPTION
263:

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

265:
266: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
267: ecx_utils.i_ret_code := 0;
268: if(l_unexpectedEnabled) then
269: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
270: end if;
271: if (l_procedureEnabled) then
272: ecx_debug.pop(i_method_name);
273: end if;

Line 272: ecx_debug.pop(i_method_name);

268: if(l_unexpectedEnabled) then
269: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
270: end if;
271: if (l_procedureEnabled) then
272: ecx_debug.pop(i_method_name);
273: end if;
274: RAISE ecx_utils.PROGRAM_EXIT;
275:
276: WHEN OTHERS THEN

Line 280: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

276: WHEN OTHERS THEN
277:
278:
279: if(l_unexpectedEnabled) then
280: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
281: 'ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT');
282: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
283: end if;
284: ecx_utils.error_type := 30;

Line 282: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

278:
279: if(l_unexpectedEnabled) then
280: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
281: 'ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT');
282: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
283: end if;
284: ecx_utils.error_type := 30;
285: ecx_utils.i_ret_code := 2;
286: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT';

Line 288: ecx_debug.pop(i_method_name);

284: ecx_utils.error_type := 30;
285: ecx_utils.i_ret_code := 2;
286: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT';
287: if (l_procedureEnabled) then
288: ecx_debug.pop(i_method_name);
289: end if;
290: RAISE ecx_utils.PROGRAM_EXIT;
291:
292: END deposit_blob_attachment;

Line 314: ecx_debug.push(i_method_name);

310:
311: BEGIN
312:
313: if (l_procedureEnabled) then
314: ecx_debug.push(i_method_name);
315: end if;
316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);

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

313: if (l_procedureEnabled) then
314: ecx_debug.push(i_method_name);
315: end if;
316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);

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

314: ecx_debug.push(i_method_name);
315: end if;
316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);

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

315: end if;
316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
323: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);

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

316: if(l_statementEnabled) then
317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
323: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
324: end if;

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

317: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
323: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
324: end if;
325:

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

318: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
323: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
324: end if;
325:
326: IF (i_entity_name IS NOT NULL) THEN

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

319: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
320: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
321: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
322: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
323: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
324: end if;
325:
326: IF (i_entity_name IS NOT NULL) THEN
327:

Line 404: ecx_debug.pop(i_method_name);

400:
401: END IF;
402:
403: if (l_procedureEnabled) then
404: ecx_debug.pop(i_method_name);
405: end if;
406:
407: EXCEPTION
408:

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

410:
411: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.FORMULATE_CONTENT_ID INVALID INPUTS' || SQLERRM;
412: ecx_utils.i_ret_code := 0;
413: if(l_unexpectedEnabled) then
414: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
415: end if;
416: if (l_procedureEnabled) then
417: ecx_debug.pop(i_method_name);
418: end if;

Line 417: ecx_debug.pop(i_method_name);

413: if(l_unexpectedEnabled) then
414: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
415: end if;
416: if (l_procedureEnabled) then
417: ecx_debug.pop(i_method_name);
418: end if;
419: RAISE ecx_utils.PROGRAM_EXIT;
420:
421: WHEN OTHERS THEN

Line 424: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

420:
421: WHEN OTHERS THEN
422:
423: if(l_unexpectedEnabled) then
424: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
425: 'ECX_ATTACHMENT.FORMULATE_CONTENT_ID');
426: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
427: end if;
428: ecx_utils.error_type := 30;

Line 426: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

422:
423: if(l_unexpectedEnabled) then
424: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
425: 'ECX_ATTACHMENT.FORMULATE_CONTENT_ID');
426: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
427: end if;
428: ecx_utils.error_type := 30;
429: ecx_utils.i_ret_code := 2;
430: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.FORMULATE_CONTENT_ID';

Line 432: ecx_debug.pop(i_method_name);

428: ecx_utils.error_type := 30;
429: ecx_utils.i_ret_code := 2;
430: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.FORMULATE_CONTENT_ID';
431: if (l_procedureEnabled) then
432: ecx_debug.pop(i_method_name);
433: end if;
434: RAISE ecx_utils.PROGRAM_EXIT;
435:
436: END formulate_content_id;

Line 456: ecx_debug.push(i_method_name);

452:
453: BEGIN
454:
455: if (l_procedureEnabled) then
456: ecx_debug.push(i_method_name);
457: end if;
458: if(l_statementEnabled) then
459: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
460: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);

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

455: if (l_procedureEnabled) then
456: ecx_debug.push(i_method_name);
457: end if;
458: if(l_statementEnabled) then
459: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
460: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
461: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
462: end if;
463:

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

456: ecx_debug.push(i_method_name);
457: end if;
458: if(l_statementEnabled) then
459: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
460: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
461: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
462: end if;
463:
464:

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

457: end if;
458: if(l_statementEnabled) then
459: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
460: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
461: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
462: end if;
463:
464:
465: -- Prelimnary check of inputs validity

Line 560: ecx_debug.pop(i_method_name);

556:
557: END IF; -- EMBEDDED MODE
558:
559: if (l_procedureEnabled) then
560: ecx_debug.pop(i_method_name);
561: end if;
562:
563: EXCEPTION
564:

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

566:
567: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE INVALID INPUT: CID or FID '|| SQLERRM;
568: ecx_utils.i_ret_code := 0;
569: if(l_unexpectedEnabled) then
570: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
571: end if;
572: if (l_procedureEnabled) then
573: ecx_debug.pop(i_method_name);
574: end if;

Line 573: ecx_debug.pop(i_method_name);

569: if(l_unexpectedEnabled) then
570: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
571: end if;
572: if (l_procedureEnabled) then
573: ecx_debug.pop(i_method_name);
574: end if;
575: RAISE ecx_utils.PROGRAM_EXIT;
576:
577: WHEN mode_not_support THEN

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

578:
579: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE MODE NOT SUPPORT' || SQLERRM;
580: ecx_utils.i_ret_code := 0;
581: if(l_unexpectedEnabled) then
582: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
583: end if;
584: if (l_procedureEnabled) then
585: ecx_debug.pop(i_method_name);
586: end if;

Line 585: ecx_debug.pop(i_method_name);

581: if(l_unexpectedEnabled) then
582: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
583: end if;
584: if (l_procedureEnabled) then
585: ecx_debug.pop(i_method_name);
586: end if;
587: RAISE ecx_utils.PROGRAM_EXIT;
588:
589: WHEN OTHERS THEN

Line 592: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

588:
589: WHEN OTHERS THEN
590:
591: if(l_unexpectedEnabled) then
592: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
593: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');
594: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
595: end if;
596: ecx_utils.error_type := 30;

Line 594: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

590:
591: if(l_unexpectedEnabled) then
592: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
593: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');
594: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
595: end if;
596: ecx_utils.error_type := 30;
597: ecx_utils.i_ret_code := 2;
598: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE';

Line 600: ecx_debug.pop(i_method_name);

596: ecx_utils.error_type := 30;
597: ecx_utils.i_ret_code := 2;
598: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE';
599: if (l_procedureEnabled) then
600: ecx_debug.pop(i_method_name);
601: end if;
602: RAISE ecx_utils.PROGRAM_EXIT;
603:
604: END register_attachment_offline;

Line 625: ecx_debug.push(i_method_name);

621:
622: BEGIN
623:
624: if (l_procedureEnabled) then
625: ecx_debug.push(i_method_name);
626: end if;
627: if(l_statementEnabled) then
628: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
629: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);

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

624: if (l_procedureEnabled) then
625: ecx_debug.push(i_method_name);
626: end if;
627: if(l_statementEnabled) then
628: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
629: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
630: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
631: end if;
632:

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

625: ecx_debug.push(i_method_name);
626: end if;
627: if(l_statementEnabled) then
628: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
629: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
630: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
631: end if;
632:
633:

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

626: end if;
627: if(l_statementEnabled) then
628: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
629: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
630: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
631: end if;
632:
633:
634: -- Prelimnary check of inputs validity

Line 739: ecx_debug.pop(i_method_name);

735:
736: END IF; -- EMBEDDED MODE
737:
738: if (l_procedureEnabled) then
739: ecx_debug.pop(i_method_name);
740: end if;
741:
742: EXCEPTION
743:

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

745:
746: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT INVALID INPUT: CID or FID '|| SQLERRM;
747: ecx_utils.i_ret_code := 0;
748: if(l_unexpectedEnabled) then
749: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
750: end if;
751: if (l_procedureEnabled) then
752: ecx_debug.pop(i_method_name);
753: end if;

Line 752: ecx_debug.pop(i_method_name);

748: if(l_unexpectedEnabled) then
749: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
750: end if;
751: if (l_procedureEnabled) then
752: ecx_debug.pop(i_method_name);
753: end if;
754: RAISE ecx_utils.PROGRAM_EXIT;
755:
756: WHEN mode_not_support THEN

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

757:
758: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
759: ecx_utils.i_ret_code := 0;
760: if(l_unexpectedEnabled) then
761: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
762: end if;
763: if (l_procedureEnabled) then
764: ecx_debug.pop(i_method_name);
765: end if;

Line 764: ecx_debug.pop(i_method_name);

760: if(l_unexpectedEnabled) then
761: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
762: end if;
763: if (l_procedureEnabled) then
764: ecx_debug.pop(i_method_name);
765: end if;
766: RAISE ecx_utils.PROGRAM_EXIT;
767:
768: WHEN OTHERS THEN

Line 771: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

767:
768: WHEN OTHERS THEN
769:
770: if(l_unexpectedEnabled) then
771: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
772: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');
773: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
774: end if;
775: ecx_utils.error_type := 30;

Line 773: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

769:
770: if(l_unexpectedEnabled) then
771: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
772: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');
773: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
774: end if;
775: ecx_utils.error_type := 30;
776: ecx_utils.i_ret_code := 2;
777: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT';

Line 779: ecx_debug.pop(i_method_name);

775: ecx_utils.error_type := 30;
776: ecx_utils.i_ret_code := 2;
777: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT';
778: if (l_procedureEnabled) then
779: ecx_debug.pop(i_method_name);
780: end if;
781: RAISE ecx_utils.PROGRAM_EXIT;
782:
783:

Line 803: ecx_debug.push(i_method_name);

799: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment_offline';
800: BEGIN
801:
802: if (l_procedureEnabled) then
803: ecx_debug.push(i_method_name);
804: end if;
805:
806:
807: formulate_content_id(i_file_id,

Line 819: ecx_debug.pop(i_method_name);

815:
816: register_attachment_offline(x_cid, i_file_id, i_data_type);
817:
818: if (l_procedureEnabled) then
819: ecx_debug.pop(i_method_name);
820: end if;
821:
822: EXCEPTION
823:

Line 827: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

823:
824: WHEN OTHERS THEN
825:
826: if(l_unexpectedEnabled) then
827: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
828: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');
829: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
830: end if;
831: ecx_utils.error_type := 30;

Line 829: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

825:
826: if(l_unexpectedEnabled) then
827: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
828: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');
829: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
830: end if;
831: ecx_utils.error_type := 30;
832: ecx_utils.i_ret_code := 2;
833: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE';

Line 835: ecx_debug.pop(i_method_name);

831: ecx_utils.error_type := 30;
832: ecx_utils.i_ret_code := 2;
833: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE';
834: if (l_procedureEnabled) then
835: ecx_debug.pop(i_method_name);
836: end if;
837: RAISE ecx_utils.PROGRAM_EXIT;
838:
839: END register_attachment_offline;

Line 858: ecx_debug.push(i_method_name);

854: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment ';
855: BEGIN
856:
857: if (l_procedureEnabled) then
858: ecx_debug.push(i_method_name);
859: end if;
860:
861: formulate_content_id(i_file_id,
862: i_entity_name,

Line 873: ecx_debug.pop(i_method_name);

869:
870: register_attachment(x_cid, i_file_id, i_data_type);
871:
872: if (l_procedureEnabled) then
873: ecx_debug.pop(i_method_name);
874: end if;
875:
876: EXCEPTION
877:

Line 881: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

877:
878: WHEN OTHERS THEN
879:
880: if(l_unexpectedEnabled) then
881: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
882: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');
883: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
884: end if;
885: ecx_utils.error_type := 30;

Line 883: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

879:
880: if(l_unexpectedEnabled) then
881: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
882: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');
883: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
884: end if;
885: ecx_utils.error_type := 30;
886: ecx_utils.i_ret_code := 2;
887: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT';

Line 889: ecx_debug.pop(i_method_name);

885: ecx_utils.error_type := 30;
886: ecx_utils.i_ret_code := 2;
887: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.REGISTER_ATTACHMENT';
888: if (l_procedureEnabled) then
889: ecx_debug.pop(i_method_name);
890: end if;
891: RAISE ecx_utils.PROGRAM_EXIT;
892:
893: END register_attachment;

Line 902: ecx_debug.push('ECX_ATTACHMENT.REMOVE_ATTACHMENTMAPS_OFFLINE');

898: ) AS
899:
900: BEGIN
901:
902: ecx_debug.push('ECX_ATTACHMENT.REMOVE_ATTACHMENTMAPS_OFFLINE');
903:
904: x_attachment_maps := i_attachment_maps;
905: i_attachment_maps := NULL;
906:

Line 907: ecx_debug.pop('ECX_ATTACHMENT.REMOVE_ATTACHMENTMAPS_OFFLINE');

903:
904: x_attachment_maps := i_attachment_maps;
905: i_attachment_maps := NULL;
906:
907: ecx_debug.pop('ECX_ATTACHMENT.REMOVE_ATTACHMENTMAPS_OFFLINE');
908:
909: END remove_attachmentMaps_offline;
910:
911:

Line 937: ecx_debug.push(i_method_name);

933:
934: BEGIN
935:
936: if (l_procedureEnabled) then
937: ecx_debug.push(i_method_name);
938: end if;
939: if(l_statementEnabled) then
940: ecx_debug.log(l_statement,'ei_attachments', i_attachments,i_method_name);
941: end if;

Line 940: ecx_debug.log(l_statement,'ei_attachments', i_attachments,i_method_name);

936: if (l_procedureEnabled) then
937: ecx_debug.push(i_method_name);
938: end if;
939: if(l_statementEnabled) then
940: ecx_debug.log(l_statement,'ei_attachments', i_attachments,i_method_name);
941: end if;
942:
943:
944: IF (i_attachments IS NOT NULL) THEN

Line 1024: ecx_debug.pop(i_method_name);

1020:
1021: END IF;
1022:
1023: if (l_procedureEnabled) then
1024: ecx_debug.pop(i_method_name);
1025: end if;
1026:
1027: EXCEPTION
1028:

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

1030:
1031: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.GET_ATTACHMENT_RECORDS RECORDED ATTACHMENTS ARE WRONG '|| SQLERRM;
1032: ecx_utils.i_ret_code := 0;
1033: if(l_unexpectedEnabled) then
1034: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1035: end if;
1036: if (l_procedureEnabled) then
1037: ecx_debug.pop(i_method_name);
1038: end if;

Line 1037: ecx_debug.pop(i_method_name);

1033: if(l_unexpectedEnabled) then
1034: ecx_debug.log(l_unexpected, ecx_utils.i_errbuf,i_method_name);
1035: end if;
1036: if (l_procedureEnabled) then
1037: ecx_debug.pop(i_method_name);
1038: end if;
1039: RAISE ecx_utils.PROGRAM_EXIT;
1040:
1041:

Line 1058: ecx_debug.push(i_method_name);

1054:
1055: BEGIN
1056:
1057: if (l_procedureEnabled) then
1058: ecx_debug.push(i_method_name);
1059: end if;
1060: if(l_statementEnabled) then
1061: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1062: end if;

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

1057: if (l_procedureEnabled) then
1058: ecx_debug.push(i_method_name);
1059: end if;
1060: if(l_statementEnabled) then
1061: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1062: end if;
1063:
1064: l_install_mode := wf_core.translate('WF_INSTALL');
1065: IF (ecx_utils.g_event is NULL) THEN

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

1073:
1074: l_attachments_info := RTRIM(l_attachments_info);
1075: l_attachments_info := LTRIM(l_attachments_info);
1076: if(l_statementEnabled) then
1077: ecx_debug.log(l_statement,'l_attachments_info', l_attachments_info,i_method_name);
1078: end if;
1079:
1080: -- Book keep the attachments info if it exists
1081: IF (l_attachments_info is NOT NULL) THEN

Line 1114: ecx_debug.pop(i_method_name);

1110:
1111: END IF;
1112:
1113: if (l_procedureEnabled) then
1114: ecx_debug.pop(i_method_name);
1115: end if;
1116:
1117: EXCEPTION
1118:

Line 1122: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1118:
1119: WHEN OTHERS THEN
1120:
1121: if(l_unexpectedEnabled) then
1122: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1123: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');
1124: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1125: end if;
1126: ecx_utils.error_type := 30;

Line 1124: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1120:
1121: if(l_unexpectedEnabled) then
1122: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1123: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');
1124: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1125: end if;
1126: ecx_utils.error_type := 30;
1127: ecx_utils.i_ret_code := 2;
1128: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';

Line 1130: ecx_debug.pop(i_method_name);

1126: ecx_utils.error_type := 30;
1127: ecx_utils.i_ret_code := 2;
1128: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';
1129: if (l_procedureEnabled) then
1130: ecx_debug.pop(i_method_name);
1131: end if;
1132: RAISE ecx_utils.PROGRAM_EXIT;
1133:
1134: END map_attachments;

Line 1150: ecx_debug.push(i_method_name);

1146:
1147: BEGIN
1148:
1149: if (l_procedureEnabled) then
1150: ecx_debug.push(i_method_name);
1151: end if;
1152:
1153: if(l_statementEnabled) then
1154: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);

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

1150: ecx_debug.push(i_method_name);
1151: end if;
1152:
1153: if(l_statementEnabled) then
1154: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1155: end if;
1156:
1157: l_install_mode := wf_core.translate('WF_INSTALL');
1158: IF (i_event is not NULL) THEN

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

1163:
1164: l_attachments_info := RTRIM(l_attachments_info);
1165: l_attachments_info := LTRIM(l_attachments_info);
1166: if(l_statementEnabled) then
1167: ecx_debug.log(l_statement,'l_attachments_info', l_attachments_info,i_method_name);
1168: end if;
1169:
1170: -- Book keep the attachments info if it exists
1171: IF (l_attachments_info is NOT NULL) THEN

Line 1206: ecx_debug.pop(i_method_name);

1202:
1203: END IF;
1204:
1205: if (l_procedureEnabled) then
1206: ecx_debug.pop(i_method_name);
1207: end if;
1208:
1209: EXCEPTION
1210:

Line 1214: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1210:
1211: WHEN OTHERS THEN
1212:
1213: if(l_unexpectedEnabled) then
1214: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1215: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');
1216: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1217: end if;
1218: ecx_utils.error_type := 30;

Line 1216: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1212:
1213: if(l_unexpectedEnabled) then
1214: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1215: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');
1216: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1217: end if;
1218: ecx_utils.error_type := 30;
1219: ecx_utils.i_ret_code := 2;
1220: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';

Line 1222: ecx_debug.pop(i_method_name);

1218: ecx_utils.error_type := 30;
1219: ecx_utils.i_ret_code := 2;
1220: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';
1221: if (l_procedureEnabled) then
1222: ecx_debug.pop(i_method_name);
1223: end if;
1224: RAISE ecx_utils.PROGRAM_EXIT;
1225:
1226: END map_attachments;

Line 1245: ecx_debug.push(i_method_name);

1241:
1242: BEGIN
1243:
1244: if (l_procedureEnabled) then
1245: ecx_debug.push(i_method_name);
1246: end if;
1247: if(l_statementEnabled) then
1248: ecx_debug.log(l_statement,'i_msgid of the passthrough document', i_msgid,i_method_name);
1249: end if;

Line 1248: ecx_debug.log(l_statement,'i_msgid of the passthrough document', i_msgid,i_method_name);

1244: if (l_procedureEnabled) then
1245: ecx_debug.push(i_method_name);
1246: end if;
1247: if(l_statementEnabled) then
1248: ecx_debug.log(l_statement,'i_msgid of the passthrough document', i_msgid,i_method_name);
1249: end if;
1250:
1251: l_progress := '0000';
1252:

Line 1293: ecx_debug.pop(i_method_name);

1289: END IF;
1290: l_progress := '0002';
1291:
1292: if (l_procedureEnabled) then
1293: ecx_debug.pop(i_method_name);
1294: end if;
1295:
1296:
1297:

Line 1303: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1299:
1300: WHEN OTHERS THEN
1301:
1302: if(l_unexpectedEnabled) then
1303: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1304: 'ECX_ATTACHMENT.REMAP_ATTACHMENTS');
1305: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1306: end if;
1307: ecx_utils.error_type := 30;

Line 1305: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1301:
1302: if(l_unexpectedEnabled) then
1303: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1304: 'ECX_ATTACHMENT.REMAP_ATTACHMENTS');
1305: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1306: end if;
1307: ecx_utils.error_type := 30;
1308: ecx_utils.i_ret_code := 2;
1309: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';

Line 1311: ecx_debug.pop(i_method_name);

1307: ecx_utils.error_type := 30;
1308: ecx_utils.i_ret_code := 2;
1309: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_ATTACHMENTS';
1310: if (l_procedureEnabled) then
1311: ecx_debug.pop(i_method_name);
1312: end if;
1313:
1314: RAISE ecx_utils.PROGRAM_EXIT;
1315:

Line 1342: ecx_debug.push(i_method_name);

1338:
1339: BEGIN
1340:
1341: if (l_procedureEnabled) then
1342: ecx_debug.push(i_method_name);
1343: end if;
1344: if(l_statementEnabled) then
1345: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1346: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);

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

1341: if (l_procedureEnabled) then
1342: ecx_debug.push(i_method_name);
1343: end if;
1344: if(l_statementEnabled) then
1345: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1346: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1347: end if;
1348:
1349: -- Check mode

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

1342: ecx_debug.push(i_method_name);
1343: end if;
1344: if(l_statementEnabled) then
1345: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1346: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1347: end if;
1348:
1349: -- Check mode
1350: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

Line 1397: ecx_debug.pop(i_method_name);

1393:
1394: END IF; -- EMBEDDED MODE
1395:
1396: if (l_procedureEnabled) then
1397: ecx_debug.pop(i_method_name);
1398: end if;
1399:
1400: EXCEPTION
1401:

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

1403:
1404: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;
1405: ecx_utils.i_ret_code := 0;
1406: if(l_unexpectedEnabled) then
1407: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1408: end if;
1409: if (l_procedureEnabled) then
1410: ecx_debug.pop(i_method_name);
1411: end if;

Line 1410: ecx_debug.pop(i_method_name);

1406: if(l_unexpectedEnabled) then
1407: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1408: end if;
1409: if (l_procedureEnabled) then
1410: ecx_debug.pop(i_method_name);
1411: end if;
1412: RAISE ecx_utils.PROGRAM_EXIT;
1413:
1414:

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

1416:
1417: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
1418: ecx_utils.i_ret_code := 0;
1419: if(l_unexpectedEnabled) then
1420: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1421: end if;
1422: if (l_procedureEnabled) then
1423: ecx_debug.pop(i_method_name);
1424: end if;

Line 1423: ecx_debug.pop(i_method_name);

1419: if(l_unexpectedEnabled) then
1420: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1421: end if;
1422: if (l_procedureEnabled) then
1423: ecx_debug.pop(i_method_name);
1424: end if;
1425: RAISE ecx_utils.PROGRAM_EXIT;
1426:
1427:

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

1429:
1430: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;
1431: ecx_utils.i_ret_code := 0;
1432: if(l_unexpectedEnabled) then
1433: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1434: end if;
1435: if (l_procedureEnabled) then
1436: ecx_debug.pop(i_method_name);
1437: end if;

Line 1436: ecx_debug.pop(i_method_name);

1432: if(l_unexpectedEnabled) then
1433: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1434: end if;
1435: if (l_procedureEnabled) then
1436: ecx_debug.pop(i_method_name);
1437: end if;
1438: RAISE ecx_utils.PROGRAM_EXIT;
1439:
1440: WHEN OTHERS THEN

Line 1443: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1439:
1440: WHEN OTHERS THEN
1441:
1442: if(l_unexpectedEnabled) then
1443: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1444: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1445: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1446: end if;
1447: ecx_utils.error_type := 30;

Line 1445: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1441:
1442: if(l_unexpectedEnabled) then
1443: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1444: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1445: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1446: end if;
1447: ecx_utils.error_type := 30;
1448: ecx_utils.i_ret_code := 2;
1449: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';

Line 1451: ecx_debug.pop(i_method_name);

1447: ecx_utils.error_type := 30;
1448: ecx_utils.i_ret_code := 2;
1449: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';
1450: if (l_procedureEnabled) then
1451: ecx_debug.pop(i_method_name);
1452: end if;
1453: RAISE ecx_utils.PROGRAM_EXIT;
1454:
1455: END retrieve_attachment;

Line 1481: ecx_debug.push(i_method_name);

1477:
1478: BEGIN
1479:
1480: if (l_procedureEnabled) then
1481: ecx_debug.push(i_method_name);
1482: end if;
1483: if(l_statementEnabled) then
1484: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1485: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);

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

1480: if (l_procedureEnabled) then
1481: ecx_debug.push(i_method_name);
1482: end if;
1483: if(l_statementEnabled) then
1484: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1485: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1486: end if;
1487:
1488: -- Check mode

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

1481: ecx_debug.push(i_method_name);
1482: end if;
1483: if(l_statementEnabled) then
1484: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1485: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1486: end if;
1487:
1488: -- Check mode
1489: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

Line 1538: ecx_debug.pop(i_method_name);

1534:
1535: END IF; -- EMBEDDED MODE
1536:
1537: if (l_procedureEnabled) then
1538: ecx_debug.pop(i_method_name);
1539: end if;
1540:
1541:
1542: EXCEPTION

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

1545:
1546: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;
1547: ecx_utils.i_ret_code := 0;
1548: if(l_unexpectedEnabled) then
1549: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1550: end if;
1551: if (l_procedureEnabled) then
1552: ecx_debug.pop(i_method_name);
1553: end if;

Line 1552: ecx_debug.pop(i_method_name);

1548: if(l_unexpectedEnabled) then
1549: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1550: end if;
1551: if (l_procedureEnabled) then
1552: ecx_debug.pop(i_method_name);
1553: end if;
1554:
1555: RAISE ecx_utils.PROGRAM_EXIT;
1556:

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

1559:
1560: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
1561: ecx_utils.i_ret_code := 0;
1562: if(l_unexpectedEnabled) then
1563: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1564: end if;
1565: if (l_procedureEnabled) then
1566: ecx_debug.pop(i_method_name);
1567: end if;

Line 1566: ecx_debug.pop(i_method_name);

1562: if(l_unexpectedEnabled) then
1563: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1564: end if;
1565: if (l_procedureEnabled) then
1566: ecx_debug.pop(i_method_name);
1567: end if;
1568: RAISE ecx_utils.PROGRAM_EXIT;
1569:
1570:

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

1572:
1573: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;
1574: ecx_utils.i_ret_code := 0;
1575: if(l_unexpectedEnabled) then
1576: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1577: end if;
1578: if (l_procedureEnabled) then
1579: ecx_debug.pop(i_method_name);
1580: end if;

Line 1579: ecx_debug.pop(i_method_name);

1575: if(l_unexpectedEnabled) then
1576: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1577: end if;
1578: if (l_procedureEnabled) then
1579: ecx_debug.pop(i_method_name);
1580: end if;
1581: RAISE ecx_utils.PROGRAM_EXIT;
1582:
1583: WHEN OTHERS THEN

Line 1586: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1582:
1583: WHEN OTHERS THEN
1584:
1585: if(l_unexpectedEnabled) then
1586: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1587: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1588: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1589: end if;
1590: ecx_utils.error_type := 30;

Line 1588: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1584:
1585: if(l_unexpectedEnabled) then
1586: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1587: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1588: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1589: end if;
1590: ecx_utils.error_type := 30;
1591: ecx_utils.i_ret_code := 2;
1592: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';

Line 1594: ecx_debug.pop(i_method_name);

1590: ecx_utils.error_type := 30;
1591: ecx_utils.i_ret_code := 2;
1592: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';
1593: if (l_procedureEnabled) then
1594: ecx_debug.pop(i_method_name);
1595: end if;
1596: RAISE ecx_utils.PROGRAM_EXIT;
1597:
1598: END retrieve_attachment;

Line 1624: ecx_debug.push(i_method_name);

1620:
1621: BEGIN
1622:
1623: if (l_procedureEnabled) then
1624: ecx_debug.push(i_method_name);
1625: end if;
1626: if(l_statementEnabled) then
1627: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
1628: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);

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

1623: if (l_procedureEnabled) then
1624: ecx_debug.push(i_method_name);
1625: end if;
1626: if(l_statementEnabled) then
1627: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
1628: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
1629: end if;
1630:
1631: -- Check mode

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

1624: ecx_debug.push(i_method_name);
1625: end if;
1626: if(l_statementEnabled) then
1627: ecx_debug.log(l_statement,'i_file_id', i_file_id,i_method_name);
1628: ecx_debug.log(l_statement,'i_data_type', i_data_type,i_method_name);
1629: end if;
1630:
1631: -- Check mode
1632: l_install_mode := wf_core.translate('WF_INSTALL');

Line 1672: ecx_debug.pop(i_method_name);

1668:
1669: END IF; -- EMBEDDED MODE
1670:
1671: if (l_procedureEnabled) then
1672: ecx_debug.pop(i_method_name);
1673: end if;
1674:
1675: EXCEPTION
1676:

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

1678:
1679: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;
1680: ecx_utils.i_ret_code := 0;
1681: if(l_unexpectedEnabled) then
1682: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1683: end if;
1684: if (l_procedureEnabled) then
1685: ecx_debug.pop(i_method_name);
1686: end if;

Line 1685: ecx_debug.pop(i_method_name);

1681: if(l_unexpectedEnabled) then
1682: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1683: end if;
1684: if (l_procedureEnabled) then
1685: ecx_debug.pop(i_method_name);
1686: end if;
1687: RAISE ecx_utils.PROGRAM_EXIT;
1688:
1689:

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

1691:
1692: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
1693: ecx_utils.i_ret_code := 0;
1694: if(l_unexpectedEnabled) then
1695: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1696: end if;
1697: if (l_procedureEnabled) then
1698: ecx_debug.pop(i_method_name);
1699: end if;

Line 1698: ecx_debug.pop(i_method_name);

1694: if(l_unexpectedEnabled) then
1695: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1696: end if;
1697: if (l_procedureEnabled) then
1698: ecx_debug.pop(i_method_name);
1699: end if;
1700: RAISE ecx_utils.PROGRAM_EXIT;
1701:
1702:

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

1704:
1705: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;
1706: ecx_utils.i_ret_code := 0;
1707: if(l_unexpectedEnabled) then
1708: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1709: end if;
1710: if (l_procedureEnabled) then
1711: ecx_debug.pop(i_method_name);
1712: end if;

Line 1711: ecx_debug.pop(i_method_name);

1707: if(l_unexpectedEnabled) then
1708: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1709: end if;
1710: if (l_procedureEnabled) then
1711: ecx_debug.pop(i_method_name);
1712: end if;
1713: RAISE ecx_utils.PROGRAM_EXIT;
1714:
1715: WHEN OTHERS THEN

Line 1718: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1714:
1715: WHEN OTHERS THEN
1716:
1717: if(l_unexpectedEnabled) then
1718: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1719: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1720: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1721: end if;
1722: ecx_utils.error_type := 30;

Line 1720: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1716:
1717: if(l_unexpectedEnabled) then
1718: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1719: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');
1720: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1721: end if;
1722: ecx_utils.error_type := 30;
1723: ecx_utils.i_ret_code := 2;
1724: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';

Line 1726: ecx_debug.pop(i_method_name);

1722: ecx_utils.error_type := 30;
1723: ecx_utils.i_ret_code := 2;
1724: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RETRIEVE_ATTACHMENT';
1725: if (l_procedureEnabled) then
1726: ecx_debug.pop(i_method_name);
1727: end if;
1728: RAISE ecx_utils.PROGRAM_EXIT;
1729:
1730: END retrieve_attachment;

Line 1761: ecx_debug.push(i_method_name);

1757:
1758: BEGIN
1759:
1760: if (l_procedureEnabled) then
1761: ecx_debug.push(i_method_name);
1762: end if;
1763: if(l_statementEnabled) then
1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);

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

1760: if (l_procedureEnabled) then
1761: ecx_debug.push(i_method_name);
1762: end if;
1763: if(l_statementEnabled) then
1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);

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

1761: ecx_debug.push(i_method_name);
1762: end if;
1763: if(l_statementEnabled) then
1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);

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

1762: end if;
1763: if(l_statementEnabled) then
1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);

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

1763: if(l_statementEnabled) then
1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);

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

1764: ecx_debug.log(l_statement,'i_msgid', i_msgid,i_method_name);
1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);

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

1765: ecx_debug.log(l_statement,'i_cid', i_cid,i_method_name);
1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);

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

1766: ecx_debug.log(l_statement,'i_entity_name', i_entity_name,i_method_name);
1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);
1774: ecx_debug.log(l_statement,'i_request_id', i_request_id,i_method_name);

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

1767: ecx_debug.log(l_statement,'i_pk1_value', i_pk1_value,i_method_name);
1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);
1774: ecx_debug.log(l_statement,'i_request_id', i_request_id,i_method_name);
1775: end if;

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

1768: ecx_debug.log(l_statement,'i_pk2_value', i_pk2_value,i_method_name);
1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);
1774: ecx_debug.log(l_statement,'i_request_id', i_request_id,i_method_name);
1775: end if;
1776: IF (i_entity_name IS NULL) THEN

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

1769: ecx_debug.log(l_statement,'i_pk3_value', i_pk3_value,i_method_name);
1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);
1774: ecx_debug.log(l_statement,'i_request_id', i_request_id,i_method_name);
1775: end if;
1776: IF (i_entity_name IS NULL) THEN
1777:

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

1770: ecx_debug.log(l_statement,'i_pk4_value', i_pk4_value,i_method_name);
1771: ecx_debug.log(l_statement,'i_pk5_value', i_pk5_value,i_method_name);
1772: ecx_debug.log(l_statement,'i_program_app_id', i_program_app_id,i_method_name);
1773: ecx_debug.log(l_statement,'i_program_id', i_program_id,i_method_name);
1774: ecx_debug.log(l_statement,'i_request_id', i_request_id,i_method_name);
1775: end if;
1776: IF (i_entity_name IS NULL) THEN
1777:
1778: RAISE invalid_input;

Line 1837: ecx_debug.pop(i_method_name);

1833:
1834: END IF;
1835:
1836: if (l_procedureEnabled) then
1837: ecx_debug.pop(i_method_name);
1838: end if;
1839: EXCEPTION
1840:
1841: WHEN invalid_input THEN

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

1842:
1843: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT INVALID INPUTS' || SQLERRM;
1844: ecx_utils.i_ret_code := 0;
1845: if(l_unexpectedEnabled) then
1846: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1847: end if;
1848: if (l_procedureEnabled) then
1849: ecx_debug.pop(i_method_name);
1850: end if;

Line 1849: ecx_debug.pop(i_method_name);

1845: if(l_unexpectedEnabled) then
1846: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1847: end if;
1848: if (l_procedureEnabled) then
1849: ecx_debug.pop(i_method_name);
1850: end if;
1851: RAISE ecx_utils.PROGRAM_EXIT;
1852:
1853: WHEN mode_not_support THEN

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

1854:
1855: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;
1856: ecx_utils.i_ret_code := 0;
1857: if(l_unexpectedEnabled) then
1858: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1859: end if;
1860: if (l_procedureEnabled) then
1861: ecx_debug.pop(i_method_name);
1862: end if;

Line 1861: ecx_debug.pop(i_method_name);

1857: if(l_unexpectedEnabled) then
1858: ecx_debug.log(l_unexpected,ecx_utils.i_errbuf,i_method_name);
1859: end if;
1860: if (l_procedureEnabled) then
1861: ecx_debug.pop(i_method_name);
1862: end if;
1863: RAISE ecx_utils.PROGRAM_EXIT;
1864:
1865: WHEN OTHERS THEN

Line 1868: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',

1864:
1865: WHEN OTHERS THEN
1866:
1867: if(l_unexpectedEnabled) then
1868: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1869: 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT');
1870: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1871: end if;
1872: ecx_utils.error_type := 30;

Line 1870: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);

1866:
1867: if(l_unexpectedEnabled) then
1868: ecx_debug.log(l_unexpected,'ECX','ECX_PROGRAM_ERROR',i_method_name,'PROGRESS_LEVEL',
1869: 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT');
1870: ecx_debug.log(l_unexpected,'ECX','ECX_ERROR_MESSAGE',i_method_name,'ERROR_MESSAGE',SQLERRM);
1871: end if;
1872: ecx_utils.error_type := 30;
1873: ecx_utils.i_ret_code := 2;
1874: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RECONFIG_ATTACHMENT';

Line 1876: ecx_debug.pop(i_method_name);

1872: ecx_utils.error_type := 30;
1873: ecx_utils.i_ret_code := 2;
1874: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.RECONFIG_ATTACHMENT';
1875: if (l_procedureEnabled) then
1876: ecx_debug.pop(i_method_name);
1877: end if;
1878: RAISE ecx_utils.PROGRAM_EXIT;
1879:
1880: END reconfig_attachment;