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_ATTACHMENT

Line 1: PACKAGE BODY ecx_attachment AS

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;

Line 12: EMBEDDED_PROGRAM_NAME CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';

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';
14: EMBEDDED_FND_KEY1 CONSTANT VARCHAR2(100) := 'ECX_ATTACHMENT_KEY1';
15: EMBEDDED_ECX_ENTITY_NAME CONSTANT VARCHAR2(40) := 'ECX_ATTACHMENT_ENTITY';
16: EMBEDDED_FND_SEQ_INIT CONSTANT NUMBER := 88;

Line 13: EMBEDDED_PROGRAM_TAG CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';

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';
14: EMBEDDED_FND_KEY1 CONSTANT VARCHAR2(100) := 'ECX_ATTACHMENT_KEY1';
15: EMBEDDED_ECX_ENTITY_NAME CONSTANT VARCHAR2(40) := 'ECX_ATTACHMENT_ENTITY';
16: EMBEDDED_FND_SEQ_INIT CONSTANT NUMBER := 88;
17: EMBEDDED_FND_SEQ_INTERVAL CONSTANT NUMBER := 10;

Line 14: EMBEDDED_FND_KEY1 CONSTANT VARCHAR2(100) := 'ECX_ATTACHMENT_KEY1';

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';
14: EMBEDDED_FND_KEY1 CONSTANT VARCHAR2(100) := 'ECX_ATTACHMENT_KEY1';
15: EMBEDDED_ECX_ENTITY_NAME CONSTANT VARCHAR2(40) := 'ECX_ATTACHMENT_ENTITY';
16: EMBEDDED_FND_SEQ_INIT CONSTANT NUMBER := 88;
17: EMBEDDED_FND_SEQ_INTERVAL CONSTANT NUMBER := 10;
18:

Line 15: EMBEDDED_ECX_ENTITY_NAME CONSTANT VARCHAR2(40) := 'ECX_ATTACHMENT_ENTITY';

11: -- private variables, types and functions
12: EMBEDDED_PROGRAM_NAME CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';
13: EMBEDDED_PROGRAM_TAG CONSTANT VARCHAR2(32) := 'ECX_ATTACHMENT';
14: EMBEDDED_FND_KEY1 CONSTANT VARCHAR2(100) := 'ECX_ATTACHMENT_KEY1';
15: EMBEDDED_ECX_ENTITY_NAME CONSTANT VARCHAR2(40) := 'ECX_ATTACHMENT_ENTITY';
16: EMBEDDED_FND_SEQ_INIT CONSTANT NUMBER := 88;
17: EMBEDDED_FND_SEQ_INTERVAL CONSTANT NUMBER := 10;
18:
19: ATTACHMENT_RECORD_DELIMITOR CONSTANT VARCHAR2(1) := '!';

Line 50: i_method_name varchar2(2000) := 'ecx_attachment.deposit_blob_attachment';

46: i_file_format IN VARCHAR2 DEFAULT NULL,
47: x_file_id OUT NOCOPY NUMBER
48: ) AS
49:
50: i_method_name varchar2(2000) := 'ecx_attachment.deposit_blob_attachment';
51: l_org_id VARCHAR2(60);
52: l_cur_doc_id NUMBER := NULL;
53: l_security_id NUMBER := NULL;
54: l_attached_id NUMBER := NULL;

Line 138: ecx_attachment.EMBEDDED_LOB_DATA_TYPE,

134: 0,
135: SYSDATE,
136: 0,
137: 0,
138: ecx_attachment.EMBEDDED_LOB_DATA_TYPE,
139: l_category_id_tmp,
140: 1,
141: l_security_id,
142: 'Y',

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 281: 'ECX_ATTACHMENT.DEPOSIT_BLOB_ATTACHMENT');

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;
285: ecx_utils.i_ret_code := 2;

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 305: i_method_name varchar2(2000) := 'ecx_attachment.formulate_content_id';

301: i_pk4_value IN VARCHAR2,
302: i_pk5_value IN VARCHAR2,
303: x_cid OUT NOCOPY VARCHAR2
304: ) AS
305: i_method_name varchar2(2000) := 'ecx_attachment.formulate_content_id';
306: l_progress VARCHAR2(4) := NULL;
307: l_file_name VARCHAR2(256) := NULL;
308: l_dynamic_sql_str0 VARCHAR2(2000) := NULL;
309: invalid_input EXCEPTION;

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 425: 'ECX_ATTACHMENT.FORMULATE_CONTENT_ID');

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;
429: ecx_utils.i_ret_code := 2;

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 443: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment_offline';

439: i_cid IN VARCHAR2,
440: i_file_id IN NUMBER,
441: i_data_type IN NUMBER
442: ) AS
443: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment_offline';
444: l_is_append BOOLEAN := TRUE;
445: l_parameterlist wf_parameter_list_t;
446: l_attachments VARCHAR2(2000) := NULL;
447: l_install_mode VARCHAR2(200) := NULL;

Line 449: l_records ecx_attachment.attachment_records_type;

445: l_parameterlist wf_parameter_list_t;
446: l_attachments VARCHAR2(2000) := NULL;
447: l_install_mode VARCHAR2(200) := NULL;
448: l_progress VARCHAR2(4) := NULL;
449: l_records ecx_attachment.attachment_records_type;
450: mode_not_support EXCEPTION;
451: invalid_input EXCEPTION;
452:
453: BEGIN

Line 476: -- Retrieve ECX_ATTACHMENT name/value pairs, which may have registered earlier

472: -- Check mode
473: l_install_mode := wf_core.translate('WF_INSTALL');
474: IF (l_install_mode = 'EMBEDDED') THEN
475:
476: -- Retrieve ECX_ATTACHMENT name/value pairs, which may have registered earlier
477: l_progress := '0000';
478: l_attachments := i_attachment_maps;
479:
480: l_attachments := RTRIM(l_attachments);

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 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 593: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');

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;
597: ecx_utils.i_ret_code := 2;

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 612: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment';

608: i_cid IN VARCHAR2,
609: i_file_id IN NUMBER,
610: i_data_type IN NUMBER
611: ) AS
612: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment';
613: l_is_append BOOLEAN := TRUE;
614: l_parameterlist wf_parameter_list_t;
615: l_attachments VARCHAR2(2000) := NULL;
616: l_install_mode VARCHAR2(200) := NULL;

Line 618: l_records ecx_attachment.attachment_records_type;

614: l_parameterlist wf_parameter_list_t;
615: l_attachments VARCHAR2(2000) := NULL;
616: l_install_mode VARCHAR2(200) := NULL;
617: l_progress VARCHAR2(4) := NULL;
618: l_records ecx_attachment.attachment_records_type;
619: mode_not_support EXCEPTION;
620: invalid_input EXCEPTION;
621:
622: BEGIN

Line 648: -- Retrieve ECX_ATTACHMENT name/value pairs from the

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

Line 656: l_attachments := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,

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);
660: l_attachments := LTRIM(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 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 772: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');

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;
776: ecx_utils.i_ret_code := 2;

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 799: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment_offline';

795: i_data_type IN NUMBER,
796: x_cid OUT NOCOPY VARCHAR2
797: ) AS
798:
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);

Line 828: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT_OFFLINE');

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;
832: ecx_utils.i_ret_code := 2;

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 854: i_method_name varchar2(2000) := 'ecx_attachment.register_attachment ';

850: i_data_type IN NUMBER,
851: x_cid OUT NOCOPY VARCHAR2
852: ) AS
853:
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);

Line 882: 'ECX_ATTACHMENT.REGISTER_ATTACHMENT');

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;
886: ecx_utils.i_ret_code := 2;

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 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 918: i_method_name varchar2(2000) := 'ecx_attachment.get_attachment_records';

914: i_attachments IN VARCHAR2,
915: x_records OUT NOCOPY attachment_records_type
916: ) AS
917:
918: i_method_name varchar2(2000) := 'ecx_attachment.get_attachment_records';
919: l_record_counter NUMBER := 0;
920: l_inner_position NUMBER := 0;
921: l_inner_begin NUMBER := 1;
922: l_occurrence NUMBER := 1;

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 1048: i_method_name varchar2(2000) := 'ecx_attachment.map_attachments';

1044: PROCEDURE map_attachments(
1045: i_msgid IN RAW
1046: )AS
1047:
1048: i_method_name varchar2(2000) := 'ecx_attachment.map_attachments';
1049: l_progress VARCHAR2(4) := NULL;
1050: l_attachments_info VARCHAR2(2000) := NULL;
1051: l_install_mode VARCHAR2(200) := NULL;
1052: l_parameterList wf_parameter_list_t;

Line 1053: l_records ecx_attachment.attachment_records_type;

1049: l_progress VARCHAR2(4) := NULL;
1050: l_attachments_info VARCHAR2(2000) := NULL;
1051: l_install_mode VARCHAR2(200) := NULL;
1052: l_parameterList wf_parameter_list_t;
1053: l_records ecx_attachment.attachment_records_type;
1054:
1055: BEGIN
1056:
1057: if (l_procedureEnabled) then

Line 1071: l_attachments_info := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,

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);
1075: l_attachments_info := LTRIM(l_attachments_info);

Line 1090: INSERT INTO ecx_attachment_maps

1086:
1087: l_progress := '0001';
1088: FOR i IN l_records.FIRST .. l_records.LAST LOOP
1089:
1090: INSERT INTO ecx_attachment_maps
1091: (msgid,
1092: cid,
1093: fid,
1094: dataType,

Line 1123: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');

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;
1127: ecx_utils.i_ret_code := 2;

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 1140: i_method_name varchar2(2000) := 'ecx_attachment.map_attachments';

1136: PROCEDURE map_attachments(
1137: i_event IN WF_EVENT_T,
1138: i_msgid IN RAW
1139: )AS
1140: i_method_name varchar2(2000) := 'ecx_attachment.map_attachments';
1141: l_progress VARCHAR2(4) := NULL;
1142: l_attachments_info VARCHAR2(2000) := NULL;
1143: l_install_mode VARCHAR2(200) := NULL;
1144: l_parameterList wf_parameter_list_t;

Line 1145: l_records ecx_attachment.attachment_records_type;

1141: l_progress VARCHAR2(4) := NULL;
1142: l_attachments_info VARCHAR2(2000) := NULL;
1143: l_install_mode VARCHAR2(200) := NULL;
1144: l_parameterList wf_parameter_list_t;
1145: l_records ecx_attachment.attachment_records_type;
1146:
1147: BEGIN
1148:
1149: if (l_procedureEnabled) then

Line 1161: l_attachments_info := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,

1157: l_install_mode := wf_core.translate('WF_INSTALL');
1158: IF (i_event is not NULL) THEN
1159:
1160: l_parameterList := wf_event_t.getParameterList(i_event);
1161: l_attachments_info := wf_event.getValueForParameter(ecx_attachment.ECX_UTIL_EVENT_ATTACHMENT,
1162: l_parameterList);
1163:
1164: l_attachments_info := RTRIM(l_attachments_info);
1165: l_attachments_info := LTRIM(l_attachments_info);

Line 1180: INSERT INTO ecx_attachment_maps

1176:
1177: l_progress := '0001';
1178: FOR i IN l_records.FIRST .. l_records.LAST LOOP
1179:
1180: INSERT INTO ecx_attachment_maps
1181: (msgid,
1182: cid,
1183: fid,
1184: dataType,

Line 1215: 'ECX_ATTACHMENT.MAP_ATTACHMENTS');

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;
1219: ecx_utils.i_ret_code := 2;

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 1233: i_method_name varchar2(2000) := 'ecx_attachment.remap_attachments';

1229:
1230: PROCEDURE remap_attachments(
1231: i_msgid IN RAW
1232: )AS
1233: i_method_name varchar2(2000) := 'ecx_attachment.remap_attachments';
1234: l_progress VARCHAR2(4) := NULL;
1235: l_in_aqMsgid RAW(16) := NULL;
1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;
1237: CURSOR l_map_cursor (msgid RAW) IS

Line 1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;

1232: )AS
1233: i_method_name varchar2(2000) := 'ecx_attachment.remap_attachments';
1234: l_progress VARCHAR2(4) := NULL;
1235: l_in_aqMsgid RAW(16) := NULL;
1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;
1237: CURSOR l_map_cursor (msgid RAW) IS
1238: SELECT *
1239: FROM ecx_attachment_maps
1240: WHERE MSGID = msgid;

Line 1239: FROM ecx_attachment_maps

1235: l_in_aqMsgid RAW(16) := NULL;
1236: l_map_row ECX_ATTACHMENT_MAPS%ROWTYPE;
1237: CURSOR l_map_cursor (msgid RAW) IS
1238: SELECT *
1239: FROM ecx_attachment_maps
1240: WHERE MSGID = msgid;
1241:
1242: BEGIN
1243:

Line 1268: INSERT INTO ecx_attachment_maps (msgId,

1264:
1265: IF (l_map_row.msgid = l_in_aqMsgid)
1266: THEN
1267:
1268: INSERT INTO ecx_attachment_maps (msgId,
1269: cId,
1270: fId,
1271: dataType,
1272: orderIndex,

Line 1304: 'ECX_ATTACHMENT.REMAP_ATTACHMENTS');

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;
1308: ecx_utils.i_ret_code := 2;

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 1329: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';

1325: x_file_data OUT NOCOPY BLOB,
1326: x_ora_charset OUT NOCOPY VARCHAR2,
1327: x_file_format OUT NOCOPY VARCHAR2
1328: ) AS
1329: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';
1330: l_file_id NUMBER := NULL;
1331: l_datatype NUMBER := NULL;
1332: l_mode VARCHAR2(200) := NULL;
1333: l_progress VARCHAR2(4) := NULL;

Line 1359: FROM ecx_attachment_maps

1355:
1356: l_progress := '0000';
1357: SELECT fid, datatype
1358: INTO l_file_id, l_datatype
1359: FROM ecx_attachment_maps
1360: WHERE msgid = i_msgid AND cid = i_cid;
1361:
1362: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1363:

Line 1366: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN

1362: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1363:
1364: l_progress := '0001';
1365:
1366: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN
1367:
1368: l_progress := '0002';
1369: l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
1370: file_data, oracle_charset, file_format

Line 1377: ELSIF (l_datatype = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN

1373: EXECUTE IMMEDIATE l_dynamic_sql_str0
1374: INTO x_file_name, x_file_content_type,
1375: x_file_data, x_ora_charset, x_file_format;
1376:
1377: ELSIF (l_datatype = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN
1378:
1379: x_file_content_type := 'text';
1380:
1381: -- XXX

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 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 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 1444: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');

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;
1448: ecx_utils.i_ret_code := 2;

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 1468: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';

1464: x_language OUT NOCOPY VARCHAR2,
1465: x_ora_charset OUT NOCOPY VARCHAR2,
1466: x_file_format OUT NOCOPY VARCHAR2
1467: ) AS
1468: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';
1469: l_file_id NUMBER := NULL;
1470: l_datatype NUMBER := NULL;
1471: l_mode VARCHAR2(200) := NULL;
1472: l_progress VARCHAR2(4) := NULL;

Line 1498: FROM ecx_attachment_maps

1494:
1495: l_progress := '0000';
1496: SELECT fid, datatype
1497: INTO l_file_id, l_datatype
1498: FROM ecx_attachment_maps
1499: WHERE msgid = i_msgid AND cid = i_cid;
1500:
1501: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1502:

Line 1505: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN

1501: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1502:
1503: l_progress := '0001';
1504:
1505: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN
1506:
1507: l_progress := '0002';
1508: l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
1509: file_data, oracle_charset, file_format,

Line 1518: ELSIF (l_datatype = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN

1514: INTO x_file_name, x_file_content_type,
1515: x_file_data, x_ora_charset, x_file_format,
1516: x_language;
1517:
1518: ELSIF (l_datatype = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN
1519:
1520: x_file_content_type := 'text';
1521:
1522: -- XXX

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 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 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 1587: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');

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;
1591: ecx_utils.i_ret_code := 2;

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 1611: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';

1607: x_language OUT NOCOPY VARCHAR2,
1608: x_ora_charset OUT NOCOPY VARCHAR2,
1609: x_file_format OUT NOCOPY VARCHAR2
1610: ) AS
1611: i_method_name varchar2(2000) := 'ecx_attachment.retrieve_attachment';
1612: l_file_id NUMBER := NULL;
1613: l_datatype NUMBER := NULL;
1614: l_mode VARCHAR2(200) := NULL;
1615: l_progress VARCHAR2(4) := NULL;

Line 1639: IF (i_data_type = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN

1635: l_progress := '0000';
1636: IF ((i_file_id is NOT NULL) AND (i_data_type is NOT NULL)) THEN
1637:
1638: l_progress := '0001';
1639: IF (i_data_type = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN
1640:
1641: l_progress := '0002';
1642: l_dynamic_sql_str0 := 'SELECT file_name, file_content_type,
1643: file_data, oracle_charset, file_format,

Line 1652: ELSIF (i_data_type = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN

1648: INTO x_file_name, x_file_content_type,
1649: x_file_data, x_ora_charset, x_file_format,
1650: x_language;
1651:
1652: ELSIF (i_data_type = ecx_attachment.EMBEDDED_SHORTTEXT_DATA_TYPE) THEN
1653:
1654: x_file_content_type := 'text';
1655:
1656: -- XXX

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 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 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 1719: 'ECX_ATTACHMENT.RETRIEVE_ATTACHMENT');

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;
1723: ecx_utils.i_ret_code := 2;

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 1747: i_method_name varchar2(2000) := 'ecx_attachment.deposit_blob_attachment';

1743: i_program_id IN NUMBER,
1744: i_request_id IN NUMBER,
1745: x_document_id OUT NOCOPY NUMBER
1746: ) AS
1747: i_method_name varchar2(2000) := 'ecx_attachment.deposit_blob_attachment';
1748: l_file_id NUMBER := NULL;
1749: l_datatype NUMBER := NULL;
1750: l_install_mode VARCHAR2(200) := NULL;
1751: l_mode VARCHAR2(200) := NULL;

Line 1790: FROM ecx_attachment_maps

1786:
1787: l_progress := '0000';
1788: SELECT fid, datatype
1789: INTO l_file_id, l_datatype
1790: FROM ecx_attachment_maps
1791: WHERE msgid = i_msgid AND cid = i_cid;
1792:
1793: IF ((l_file_id is NOT NULL) AND (l_datatype is NOT NULL)) THEN
1794:

Line 1804: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN

1800:
1801: EXECUTE IMMEDIATE l_dynamic_sql_str1 INTO x_document_id;
1802:
1803:
1804: IF (l_datatype = ecx_attachment.EMBEDDED_LOB_DATA_TYPE) THEN
1805:
1806: l_progress := '0002';
1807: l_dynamic_sql_str0 := 'UPDATE fnd_attached_documents SET
1808: entity_name = :1,

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 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 1869: 'ECX_ATTACHMENT.RECONFIG_ATTACHMENT');

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;
1873: ecx_utils.i_ret_code := 2;

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 1883: END ecx_attachment;

1879:
1880: END reconfig_attachment;
1881:
1882:
1883: END ecx_attachment;