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_UTILS

Line 91: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

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');
92: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
93:
94: l_install_mode := wf_core.translate('WF_INSTALL');
95: IF (l_install_mode = 'EMBEDDED') THEN

Line 92: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN

88: end if;
89:
90: -- Check mode
91: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
92: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
93:
94: l_install_mode := wf_core.translate('WF_INSTALL');
95: IF (l_install_mode = 'EMBEDDED') THEN
96:

Line 266: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

262: EXCEPTION
263:
264: WHEN mode_not_support THEN
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;

Line 267: ecx_utils.i_ret_code := 0;

263:
264: WHEN mode_not_support THEN
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

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 274: RAISE ecx_utils.PROGRAM_EXIT;

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
277:
278:

Line 284: ecx_utils.error_type := 30;

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';
287: if (l_procedureEnabled) then
288: ecx_debug.pop(i_method_name);

Line 285: ecx_utils.i_ret_code := 2;

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';
287: if (l_procedureEnabled) then
288: ecx_debug.pop(i_method_name);
289: end if;

Line 286: ecx_utils.i_errbuf := SQLERRM || ' at 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';
287: if (l_procedureEnabled) then
288: ecx_debug.pop(i_method_name);
289: end if;
290: RAISE ecx_utils.PROGRAM_EXIT;

Line 290: RAISE ecx_utils.PROGRAM_EXIT;

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;
293:
294:

Line 411: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.FORMULATE_CONTENT_ID INVALID INPUTS' || SQLERRM;

407: EXCEPTION
408:
409: WHEN invalid_input THEN
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;

Line 412: ecx_utils.i_ret_code := 0;

408:
409: WHEN invalid_input THEN
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

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 419: RAISE ecx_utils.PROGRAM_EXIT;

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
422:
423: if(l_unexpectedEnabled) then

Line 428: ecx_utils.error_type := 30;

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';
431: if (l_procedureEnabled) then
432: ecx_debug.pop(i_method_name);

Line 429: ecx_utils.i_ret_code := 2;

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';
431: if (l_procedureEnabled) then
432: ecx_debug.pop(i_method_name);
433: end if;

Line 430: ecx_utils.i_errbuf := SQLERRM || ' at 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';
431: if (l_procedureEnabled) then
432: ecx_debug.pop(i_method_name);
433: end if;
434: RAISE ecx_utils.PROGRAM_EXIT;

Line 434: RAISE ecx_utils.PROGRAM_EXIT;

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;
437:
438: PROCEDURE register_attachment_offline(

Line 485: -- into the ecx_utils.g_event's ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT name/value pair

481: l_attachments := LTRIM(l_attachments);
482: IF ((l_attachments is NULL) OR (l_attachments = ' ')) THEN
483:
484: -- No attachments yet, just append the current i_cid and i_file_id
485: -- into the ecx_utils.g_event's ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT name/value pair
486: l_progress := '0001';
487: l_attachments := i_cid || ATTACHMENT_FIELD_DELIMITOR ||
488: i_file_id || ATTACHMENT_FIELD_DELIMITOR ||
489: i_data_type || ATTACHMENT_RECORD_DELIMITOR;

Line 567: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE INVALID INPUT: CID or FID '|| SQLERRM;

563: EXCEPTION
564:
565: WHEN invalid_input THEN
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;

Line 568: ecx_utils.i_ret_code := 0;

564:
565: WHEN invalid_input THEN
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

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 575: RAISE ecx_utils.PROGRAM_EXIT;

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
578:
579: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE MODE NOT SUPPORT' || SQLERRM;

Line 579: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE MODE NOT SUPPORT' || SQLERRM;

575: RAISE ecx_utils.PROGRAM_EXIT;
576:
577: WHEN mode_not_support THEN
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;

Line 580: ecx_utils.i_ret_code := 0;

576:
577: WHEN mode_not_support THEN
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

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 587: RAISE ecx_utils.PROGRAM_EXIT;

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
590:
591: if(l_unexpectedEnabled) then

Line 596: ecx_utils.error_type := 30;

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';
599: if (l_procedureEnabled) then
600: ecx_debug.pop(i_method_name);

Line 597: ecx_utils.i_ret_code := 2;

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';
599: if (l_procedureEnabled) then
600: ecx_debug.pop(i_method_name);
601: end if;

Line 598: ecx_utils.i_errbuf := SQLERRM || ' at 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';
599: if (l_procedureEnabled) then
600: ecx_debug.pop(i_method_name);
601: end if;
602: RAISE ecx_utils.PROGRAM_EXIT;

Line 602: RAISE ecx_utils.PROGRAM_EXIT;

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;
605:
606:

Line 642: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

638:
639: END IF;
640:
641: -- Check mode
642: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
643: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
644:
645: l_install_mode := wf_core.translate('WF_INSTALL');
646: IF (l_install_mode = 'EMBEDDED') THEN

Line 643: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN

639: END IF;
640:
641: -- Check mode
642: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
643: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
644:
645: l_install_mode := wf_core.translate('WF_INSTALL');
646: IF (l_install_mode = 'EMBEDDED') THEN
647:

Line 649: -- ecx_utils.g_event workflow event

645: l_install_mode := wf_core.translate('WF_INSTALL');
646: IF (l_install_mode = 'EMBEDDED') THEN
647:
648: -- Retrieve ECX_ATTACHMENT name/value pairs from the
649: -- ecx_utils.g_event workflow event
650: l_progress := '0000';
651: IF (ecx_utils.g_event is NULL)
652: THEN
653: wf_event_t.initialize(ecx_utils.g_event);

Line 651: IF (ecx_utils.g_event is NULL)

647:
648: -- Retrieve ECX_ATTACHMENT name/value pairs from the
649: -- ecx_utils.g_event workflow event
650: l_progress := '0000';
651: IF (ecx_utils.g_event is NULL)
652: THEN
653: wf_event_t.initialize(ecx_utils.g_event);
654: END IF;
655: l_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);

Line 653: wf_event_t.initialize(ecx_utils.g_event);

649: -- ecx_utils.g_event workflow event
650: l_progress := '0000';
651: IF (ecx_utils.g_event is NULL)
652: THEN
653: wf_event_t.initialize(ecx_utils.g_event);
654: END IF;
655: l_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);
656: l_attachments := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,
657: l_parameterlist);

Line 655: l_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);

651: IF (ecx_utils.g_event is NULL)
652: THEN
653: wf_event_t.initialize(ecx_utils.g_event);
654: END IF;
655: l_parameterlist := wf_event_t.getParameterList(ecx_utils.g_event);
656: l_attachments := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,
657: l_parameterlist);
658:
659: l_attachments := RTRIM(l_attachments);

Line 664: -- into the ecx_utils.g_event's ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT name/value pair

660: l_attachments := LTRIM(l_attachments);
661: IF ((l_attachments is NULL) OR (l_attachments = ' ')) THEN
662:
663: -- No attachments yet, just append the current i_cid and i_file_id
664: -- into the ecx_utils.g_event's ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT name/value pair
665: l_progress := '0001';
666: l_attachments := i_cid || ATTACHMENT_FIELD_DELIMITOR ||
667: i_file_id || ATTACHMENT_FIELD_DELIMITOR ||
668: i_data_type || ATTACHMENT_RECORD_DELIMITOR;

Line 729: ecx_utils.g_event.addParameterToList(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT, l_attachments);

725:
726: END IF;
727:
728: -- Push the newly modified
729: ecx_utils.g_event.addParameterToList(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT, l_attachments);
730:
731: ELSE
732:
733: -- Standalone mode is not yet supported

Line 746: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT INVALID INPUT: CID or FID '|| SQLERRM;

742: EXCEPTION
743:
744: WHEN invalid_input THEN
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;

Line 747: ecx_utils.i_ret_code := 0;

743:
744: WHEN invalid_input THEN
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

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 754: RAISE ecx_utils.PROGRAM_EXIT;

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
757:
758: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

Line 758: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.REGISTER_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

754: RAISE ecx_utils.PROGRAM_EXIT;
755:
756: WHEN mode_not_support THEN
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;

Line 759: ecx_utils.i_ret_code := 0;

755:
756: WHEN mode_not_support THEN
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

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 766: RAISE ecx_utils.PROGRAM_EXIT;

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
769:
770: if(l_unexpectedEnabled) then

Line 775: ecx_utils.error_type := 30;

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';
778: if (l_procedureEnabled) then
779: ecx_debug.pop(i_method_name);

Line 776: ecx_utils.i_ret_code := 2;

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';
778: if (l_procedureEnabled) then
779: ecx_debug.pop(i_method_name);
780: end if;

Line 777: ecx_utils.i_errbuf := SQLERRM || ' at 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';
778: if (l_procedureEnabled) then
779: ecx_debug.pop(i_method_name);
780: end if;
781: RAISE ecx_utils.PROGRAM_EXIT;

Line 781: RAISE ecx_utils.PROGRAM_EXIT;

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:
784: END register_attachment;
785:

Line 831: ecx_utils.error_type := 30;

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';
834: if (l_procedureEnabled) then
835: ecx_debug.pop(i_method_name);

Line 832: ecx_utils.i_ret_code := 2;

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';
834: if (l_procedureEnabled) then
835: ecx_debug.pop(i_method_name);
836: end if;

Line 833: ecx_utils.i_errbuf := SQLERRM || ' at 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';
834: if (l_procedureEnabled) then
835: ecx_debug.pop(i_method_name);
836: end if;
837: RAISE ecx_utils.PROGRAM_EXIT;

Line 837: RAISE ecx_utils.PROGRAM_EXIT;

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;
840:
841:

Line 885: ecx_utils.error_type := 30;

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';
888: if (l_procedureEnabled) then
889: ecx_debug.pop(i_method_name);

Line 886: ecx_utils.i_ret_code := 2;

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';
888: if (l_procedureEnabled) then
889: ecx_debug.pop(i_method_name);
890: end if;

Line 887: ecx_utils.i_errbuf := SQLERRM || ' at 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';
888: if (l_procedureEnabled) then
889: ecx_debug.pop(i_method_name);
890: end if;
891: RAISE ecx_utils.PROGRAM_EXIT;

Line 891: RAISE ecx_utils.PROGRAM_EXIT;

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;
894:
895:

Line 1031: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.GET_ATTACHMENT_RECORDS RECORDED ATTACHMENTS ARE WRONG '|| SQLERRM;

1027: EXCEPTION
1028:
1029: WHEN l_invalid_records THEN
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;

Line 1032: ecx_utils.i_ret_code := 0;

1028:
1029: WHEN l_invalid_records THEN
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

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 1039: RAISE ecx_utils.PROGRAM_EXIT;

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:
1042: END get_attachment_records;
1043:

Line 1065: IF (ecx_utils.g_event is NULL) 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
1066:
1067: wf_event_t.initialize(ecx_utils.g_event);
1068:
1069: END IF;

Line 1067: wf_event_t.initialize(ecx_utils.g_event);

1063:
1064: l_install_mode := wf_core.translate('WF_INSTALL');
1065: IF (ecx_utils.g_event is NULL) THEN
1066:
1067: wf_event_t.initialize(ecx_utils.g_event);
1068:
1069: END IF;
1070: l_parameterList := wf_event_t.getParameterList(ecx_utils.g_event);
1071: l_attachments_info := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,

Line 1070: l_parameterList := wf_event_t.getParameterList(ecx_utils.g_event);

1066:
1067: wf_event_t.initialize(ecx_utils.g_event);
1068:
1069: END IF;
1070: l_parameterList := wf_event_t.getParameterList(ecx_utils.g_event);
1071: l_attachments_info := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,
1072: l_parameterList);
1073:
1074: l_attachments_info := RTRIM(l_attachments_info);

Line 1126: ecx_utils.error_type := 30;

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';
1129: if (l_procedureEnabled) then
1130: ecx_debug.pop(i_method_name);

Line 1127: ecx_utils.i_ret_code := 2;

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';
1129: if (l_procedureEnabled) then
1130: ecx_debug.pop(i_method_name);
1131: end if;

Line 1128: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1129: if (l_procedureEnabled) then
1130: ecx_debug.pop(i_method_name);
1131: end if;
1132: RAISE ecx_utils.PROGRAM_EXIT;

Line 1132: RAISE ecx_utils.PROGRAM_EXIT;

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;
1135:
1136: PROCEDURE map_attachments(

Line 1218: ecx_utils.error_type := 30;

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';
1221: if (l_procedureEnabled) then
1222: ecx_debug.pop(i_method_name);

Line 1219: ecx_utils.i_ret_code := 2;

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';
1221: if (l_procedureEnabled) then
1222: ecx_debug.pop(i_method_name);
1223: end if;

Line 1220: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1221: if (l_procedureEnabled) then
1222: ecx_debug.pop(i_method_name);
1223: end if;
1224: RAISE ecx_utils.PROGRAM_EXIT;

Line 1224: RAISE ecx_utils.PROGRAM_EXIT;

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;
1227:
1228:

Line 1307: ecx_utils.error_type := 30;

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';
1310: if (l_procedureEnabled) then
1311: ecx_debug.pop(i_method_name);

Line 1308: ecx_utils.i_ret_code := 2;

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';
1310: if (l_procedureEnabled) then
1311: ecx_debug.pop(i_method_name);
1312: end if;

Line 1309: ecx_utils.i_errbuf := SQLERRM || ' at ECX_ATTACHMENT.MAP_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';
1310: if (l_procedureEnabled) then
1311: ecx_debug.pop(i_method_name);
1312: end if;
1313:

Line 1314: RAISE ecx_utils.PROGRAM_EXIT;

1310: if (l_procedureEnabled) then
1311: ecx_debug.pop(i_method_name);
1312: end if;
1313:
1314: RAISE ecx_utils.PROGRAM_EXIT;
1315:
1316: END remap_attachments;
1317:
1318:

Line 1350: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

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');
1351: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
1352:
1353: l_install_mode := wf_core.translate('WF_INSTALL');
1354: IF (l_install_mode = 'EMBEDDED') THEN

Line 1351: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN

1347: end if;
1348:
1349: -- Check mode
1350: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
1351: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
1352:
1353: l_install_mode := wf_core.translate('WF_INSTALL');
1354: IF (l_install_mode = 'EMBEDDED') THEN
1355:

Line 1404: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;

1400: EXCEPTION
1401:
1402: WHEN no_data_found THEN
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;

Line 1405: ecx_utils.i_ret_code := 0;

1401:
1402: WHEN no_data_found THEN
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

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 1412: RAISE ecx_utils.PROGRAM_EXIT;

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:
1415: WHEN mode_not_support THEN
1416:

Line 1417: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

1413:
1414:
1415: WHEN mode_not_support THEN
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;

Line 1418: ecx_utils.i_ret_code := 0;

1414:
1415: WHEN mode_not_support THEN
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

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 1425: RAISE ecx_utils.PROGRAM_EXIT;

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:
1428: WHEN mode_mismatch THEN
1429:

Line 1430: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;

1426:
1427:
1428: WHEN mode_mismatch THEN
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;

Line 1431: ecx_utils.i_ret_code := 0;

1427:
1428: WHEN mode_mismatch THEN
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

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 1438: RAISE ecx_utils.PROGRAM_EXIT;

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
1441:
1442: if(l_unexpectedEnabled) then

Line 1447: ecx_utils.error_type := 30;

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';
1450: if (l_procedureEnabled) then
1451: ecx_debug.pop(i_method_name);

Line 1448: ecx_utils.i_ret_code := 2;

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';
1450: if (l_procedureEnabled) then
1451: ecx_debug.pop(i_method_name);
1452: end if;

Line 1449: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1450: if (l_procedureEnabled) then
1451: ecx_debug.pop(i_method_name);
1452: end if;
1453: RAISE ecx_utils.PROGRAM_EXIT;

Line 1453: RAISE ecx_utils.PROGRAM_EXIT;

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;
1456:
1457:

Line 1489: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');

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');
1490: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
1491:
1492: l_install_mode := wf_core.translate('WF_INSTALL');
1493: IF (l_install_mode = 'EMBEDDED') THEN

Line 1490: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN

1486: end if;
1487:
1488: -- Check mode
1489: -- ecx_utils.g_install_mode := wf_core.translate('WF_INSTALL');
1490: -- IF (ecx_utils.g_install_mode = 'EMBEDDED') THEN
1491:
1492: l_install_mode := wf_core.translate('WF_INSTALL');
1493: IF (l_install_mode = 'EMBEDDED') THEN
1494:

Line 1546: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;

1542: EXCEPTION
1543:
1544: WHEN no_data_found THEN
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;

Line 1547: ecx_utils.i_ret_code := 0;

1543:
1544: WHEN no_data_found THEN
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

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 1555: RAISE ecx_utils.PROGRAM_EXIT;

1551: if (l_procedureEnabled) then
1552: ecx_debug.pop(i_method_name);
1553: end if;
1554:
1555: RAISE ecx_utils.PROGRAM_EXIT;
1556:
1557:
1558: WHEN mode_not_support THEN
1559:

Line 1560: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

1556:
1557:
1558: WHEN mode_not_support THEN
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;

Line 1561: ecx_utils.i_ret_code := 0;

1557:
1558: WHEN mode_not_support THEN
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

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 1568: RAISE ecx_utils.PROGRAM_EXIT;

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:
1571: WHEN mode_mismatch THEN
1572:

Line 1573: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;

1569:
1570:
1571: WHEN mode_mismatch THEN
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;

Line 1574: ecx_utils.i_ret_code := 0;

1570:
1571: WHEN mode_mismatch THEN
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

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 1581: RAISE ecx_utils.PROGRAM_EXIT;

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
1584:
1585: if(l_unexpectedEnabled) then

Line 1590: ecx_utils.error_type := 30;

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';
1593: if (l_procedureEnabled) then
1594: ecx_debug.pop(i_method_name);

Line 1591: ecx_utils.i_ret_code := 2;

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';
1593: if (l_procedureEnabled) then
1594: ecx_debug.pop(i_method_name);
1595: end if;

Line 1592: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1593: if (l_procedureEnabled) then
1594: ecx_debug.pop(i_method_name);
1595: end if;
1596: RAISE ecx_utils.PROGRAM_EXIT;

Line 1596: RAISE ecx_utils.PROGRAM_EXIT;

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;
1599:
1600:

Line 1679: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT NO DATA FOUND IN ECX_ATTACHMENT_MAP TABLE' || SQLERRM;

1675: EXCEPTION
1676:
1677: WHEN no_data_found THEN
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;

Line 1680: ecx_utils.i_ret_code := 0;

1676:
1677: WHEN no_data_found THEN
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

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 1687: RAISE ecx_utils.PROGRAM_EXIT;

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:
1690: WHEN mode_not_support THEN
1691:

Line 1692: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

1688:
1689:
1690: WHEN mode_not_support THEN
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;

Line 1693: ecx_utils.i_ret_code := 0;

1689:
1690: WHEN mode_not_support THEN
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

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 1700: RAISE ecx_utils.PROGRAM_EXIT;

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:
1703: WHEN mode_mismatch THEN
1704:

Line 1705: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT MODE MISMATCHES' || SQLERRM;

1701:
1702:
1703: WHEN mode_mismatch THEN
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;

Line 1706: ecx_utils.i_ret_code := 0;

1702:
1703: WHEN mode_mismatch THEN
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

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 1713: RAISE ecx_utils.PROGRAM_EXIT;

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
1716:
1717: if(l_unexpectedEnabled) then

Line 1722: ecx_utils.error_type := 30;

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';
1725: if (l_procedureEnabled) then
1726: ecx_debug.pop(i_method_name);

Line 1723: ecx_utils.i_ret_code := 2;

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';
1725: if (l_procedureEnabled) then
1726: ecx_debug.pop(i_method_name);
1727: end if;

Line 1724: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1725: if (l_procedureEnabled) then
1726: ecx_debug.pop(i_method_name);
1727: end if;
1728: RAISE ecx_utils.PROGRAM_EXIT;

Line 1728: RAISE ecx_utils.PROGRAM_EXIT;

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;
1731:
1732:

Line 1843: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT INVALID INPUTS' || SQLERRM;

1839: EXCEPTION
1840:
1841: WHEN invalid_input THEN
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;

Line 1844: ecx_utils.i_ret_code := 0;

1840:
1841: WHEN invalid_input THEN
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

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 1851: RAISE ecx_utils.PROGRAM_EXIT;

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
1854:
1855: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

Line 1855: ecx_utils.i_errbuf := 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT MODE NOT SUPPORT' || SQLERRM;

1851: RAISE ecx_utils.PROGRAM_EXIT;
1852:
1853: WHEN mode_not_support THEN
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;

Line 1856: ecx_utils.i_ret_code := 0;

1852:
1853: WHEN mode_not_support THEN
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

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 1863: RAISE ecx_utils.PROGRAM_EXIT;

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
1866:
1867: if(l_unexpectedEnabled) then

Line 1872: ecx_utils.error_type := 30;

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';
1875: if (l_procedureEnabled) then
1876: ecx_debug.pop(i_method_name);

Line 1873: ecx_utils.i_ret_code := 2;

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';
1875: if (l_procedureEnabled) then
1876: ecx_debug.pop(i_method_name);
1877: end if;

Line 1874: ecx_utils.i_errbuf := SQLERRM || ' at 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';
1875: if (l_procedureEnabled) then
1876: ecx_debug.pop(i_method_name);
1877: end if;
1878: RAISE ecx_utils.PROGRAM_EXIT;

Line 1878: RAISE ecx_utils.PROGRAM_EXIT;

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;
1881:
1882: