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.EDR_ATTACHMENTS_GRP dependencies on WF_LOG_PKG

Line 772: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Inside Atonomous');

768: l_category_name VARCHAR2(30);
769: l_user_id NUMBER;
770: l_login_id NUMBER;
771: BEGIN
772: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Inside Atonomous');
773: l_user_id := fnd_global.user_id;
774: l_login_id := fnd_global.login_id;
775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);

Line 775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);

771: BEGIN
772: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Inside Atonomous');
773: l_user_id := fnd_global.user_id;
774: l_login_id := fnd_global.login_id;
775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);
777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);
778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);
779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);

Line 776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);

772: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Inside Atonomous');
773: l_user_id := fnd_global.user_id;
774: l_login_id := fnd_global.login_id;
775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);
777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);
778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);
779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);
780:

Line 777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);

773: l_user_id := fnd_global.user_id;
774: l_login_id := fnd_global.login_id;
775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);
777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);
778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);
779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);
780:
781:

Line 778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);

774: l_login_id := fnd_global.login_id;
775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);
777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);
778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);
779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);
780:
781:
782: if (upper(p_pk2_value) = '''NULL''') then

Line 779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);

775: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK1 Value...'|| p_pk1_value);
776: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK2 Value...'|| p_pk2_value);
777: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK3 Value...'|| p_pk3_value);
778: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','PK4 Value...'|| p_pk4_value);
779: wf_log_pkg.string(6, 'ATTACH','PK5 Value...'|| p_pk5_value);
780:
781:
782: if (upper(p_pk2_value) = '''NULL''') then
783: l_pk2_value := NULL;

Line 823: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Category PArsed');

819: --parse the string of semicolon separated category names and get the
820: --individual category name
821: l_category_name := edr_utilities.get_delimited_string(l_category_names,';');
822:
823: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Category PArsed');
824: loop
825:
826: begin
827: if (l_category_name is not null) then

Line 832: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Calling Copy API');

828: select category_id into l_category_id
829: from fnd_document_categories_vl
830: where name = l_category_name;
831: end if;
832: wf_log_pkg.string(6, 'ATTACH_ERP_AUT','Calling Copy API');
833: --call the fnd api to copy the attachment from the original
834: --business entity to the ERECORD entity
835: --change the category of the attachment to ERES
836:

Line 865: wf_log_pkg.string(6, 'EDR_ATTACHMENTS_GRP.ATTACH_ERP_AUT','Category Not Found: '||l_category_name);

861: X_to_category_id => l_category_id);
862: --Bug 4381237: End
863: exception
864: when no_data_found then
865: wf_log_pkg.string(6, 'EDR_ATTACHMENTS_GRP.ATTACH_ERP_AUT','Category Not Found: '||l_category_name);
866: end;
867:
868: --get the new value of the category name
869: if (l_category_name is not null) then

Line 895: wf_log_pkg.string(6, 'ATTACH_ERP','Inside Attachment Package');

891: l_erecord_id number;
892: BEGIN
893: -- get the erecord id from the temporary table populate by the subscription
894: -- rule function before invoking XML Gateway
895: wf_log_pkg.string(6, 'ATTACH_ERP','Inside Attachment Package');
896:
897: -- Bug 3186732
898: -- Issue if XML Map has attachment procedure call then
899: -- for those maps user used to get "NO DATA FOUND" Error

Line 911: wf_log_pkg.string(6, 'ATTACH_ERP','Event ID '||l_erecord_id);

907: OPEN GET_TEMP_EREC_ID;
908: FETCH GET_TEMP_EREC_ID INTO l_erecord_id;
909: CLOSE GET_TEMP_EREC_ID;
910:
911: wf_log_pkg.string(6, 'ATTACH_ERP','Event ID '||l_erecord_id);
912:
913: /* Call ATTACH_ERP_AUT only when temp eRecord ID present in GET_TEMP_EREC_ID */
914:
915: IF l_eRecord_id is not null THEN

Line 987: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','File status is not Pending.');

983: p_parameter_name1 => 'FILE_STATUS',
984: p_parameter_value1 => l_event_status
985: );
986: else
987: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','File status is not Pending.');
988: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Cannot do any post op processing');
989: end if;
990: EXCEPTION
991: WHEN OTHERS THEN

Line 988: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Cannot do any post op processing');

984: p_parameter_value1 => l_event_status
985: );
986: else
987: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','File status is not Pending.');
988: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Cannot do any post op processing');
989: end if;
990: EXCEPTION
991: WHEN OTHERS THEN
992: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error in post op');

Line 992: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error in post op');

988: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Cannot do any post op processing');
989: end if;
990: EXCEPTION
991: WHEN OTHERS THEN
992: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error in post op');
993: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);
994: END EVENT_POST_OP;
995:
996: PROCEDURE GET_CATEGORY_NAME (P_CATEGORY_NAME IN VARCHAR2,

Line 993: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);

989: end if;
990: EXCEPTION
991: WHEN OTHERS THEN
992: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error in post op');
993: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);
994: END EVENT_POST_OP;
995:
996: PROCEDURE GET_CATEGORY_NAME (P_CATEGORY_NAME IN VARCHAR2,
997: P_DISPLAY_NAME in out nocopy VARCHAR2)

Line 1000: wf_log_pkg.string(6, 'GET_CATEGORY_NAME','In the get_category_name procedure');

996: PROCEDURE GET_CATEGORY_NAME (P_CATEGORY_NAME IN VARCHAR2,
997: P_DISPLAY_NAME in out nocopy VARCHAR2)
998: AS
999: BEGIN
1000: wf_log_pkg.string(6, 'GET_CATEGORY_NAME','In the get_category_name procedure');
1001:
1002: SELECT USER_NAME INTO P_DISPLAY_NAME
1003: FROM FND_DOCUMENT_CATEGORIES_VL
1004: WHERE NAME = P_CATEGORY_NAME;

Line 1008: wf_log_pkg.string(6, 'GET_CATEGORY_NAME','Returning from get_category_name procedure');

1004: WHERE NAME = P_CATEGORY_NAME;
1005: EXCEPTION WHEN NO_DATA_FOUND then
1006: P_DISPLAY_NAME := 'Invalid Category';
1007:
1008: wf_log_pkg.string(6, 'GET_CATEGORY_NAME','Returning from get_category_name procedure');
1009:
1010: END GET_CATEGORY_NAME;
1011:
1012: PROCEDURE GET_DESC_FLEX_ALL_PROMPTS(P_APPLICATION_ID IN VARCHAR2,

Line 1058: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','In the get_desc_flex_all_prompts procedure');

1054: L_PROMPT29 VARCHAR2(255);
1055: L_PROMPT30 VARCHAR2(255);
1056:
1057: BEGIN
1058: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','In the get_desc_flex_all_prompts procedure');
1059:
1060: EDR_STANDARD.GET_DESC_FLEX_ALL_PROMPTS(
1061: P_APPLICATION_ID => P_APPLICATION_ID,
1062: P_DESC_FLEX_DEF_NAME => P_DESC_FLEX_DEF_NAME,

Line 1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);

1102: P_COLUMN28_PROMPT => L_PROMPT28,
1103: P_COLUMN29_PROMPT => L_PROMPT29,
1104: P_COLUMN30_PROMPT => L_PROMPT30);
1105:
1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);

Line 1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);

1103: P_COLUMN29_PROMPT => L_PROMPT29,
1104: P_COLUMN30_PROMPT => L_PROMPT30);
1105:
1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);

Line 1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);

1104: P_COLUMN30_PROMPT => L_PROMPT30);
1105:
1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);

Line 1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);

1105:
1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);

Line 1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);

1106: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt1 '||P_COLUMN1_PROMPT);
1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);

Line 1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);

1107: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt2 '||P_COLUMN2_PROMPT);
1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);

Line 1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);

1108: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt3 '||P_COLUMN3_PROMPT);
1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);
1116:

Line 1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);

1109: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt4 '||P_COLUMN4_PROMPT);
1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);
1116:
1117: END GET_DESC_FLEX_ALL_PROMPTS;

Line 1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);

1110: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt5 '||P_COLUMN5_PROMPT);
1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);
1116:
1117: END GET_DESC_FLEX_ALL_PROMPTS;
1118:

Line 1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);

1111: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt6 '||P_COLUMN6_PROMPT);
1112: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt7 '||P_COLUMN7_PROMPT);
1113: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt8 '||P_COLUMN8_PROMPT);
1114: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt9 '||P_COLUMN9_PROMPT);
1115: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_PROMPTS','Prompt10 '||P_COLUMN10_PROMPT);
1116:
1117: END GET_DESC_FLEX_ALL_PROMPTS;
1118:
1119: -- Bug 4501520 : rvsingh:start

Line 1176: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','In the GET_DESC_FLEX_ALL_VALUES procedure');

1172: L_VAL29 VARCHAR2(255);
1173: L_VAL30 VARCHAR2(255);
1174:
1175: BEGIN
1176: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','In the GET_DESC_FLEX_ALL_VALUES procedure');
1177:
1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);

Line 1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);

1174:
1175: BEGIN
1176: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','In the GET_DESC_FLEX_ALL_VALUES procedure');
1177:
1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);

Line 1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);

1175: BEGIN
1176: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','In the GET_DESC_FLEX_ALL_VALUES procedure');
1177:
1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);

Line 1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);

1176: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','In the GET_DESC_FLEX_ALL_VALUES procedure');
1177:
1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);

Line 1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);

1177:
1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);

Line 1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);

1178: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL1 '||P_COLUMN1_ID_VAL);
1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);

Line 1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);

1179: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL2 '||P_COLUMN2_ID_VAL);
1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);
1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);

Line 1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);

1180: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL3 '||P_COLUMN3_ID_VAL);
1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);
1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);
1188:

Line 1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);

1181: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL4 '||P_COLUMN4_ID_VAL);
1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);
1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);
1188:
1189: EDR_STANDARD.GET_DESC_FLEX_ALL_VALUES(

Line 1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);

1182: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL5 '||P_COLUMN5_ID_VAL);
1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);
1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);
1188:
1189: EDR_STANDARD.GET_DESC_FLEX_ALL_VALUES(
1190: P_APPLICATION_ID => P_APPLICATION_ID,

Line 1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);

1183: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL6 '||P_COLUMN6_ID_VAL);
1184: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL7 '||P_COLUMN7_ID_VAL);
1185: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL8 '||P_COLUMN8_ID_VAL);
1186: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL9 '||P_COLUMN9_ID_VAL);
1187: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','ID_VAL10 '||P_COLUMN10_ID_VAL);
1188:
1189: EDR_STANDARD.GET_DESC_FLEX_ALL_VALUES(
1190: P_APPLICATION_ID => P_APPLICATION_ID,
1191: P_DESC_FLEX_DEF_NAME => P_DESC_FLEX_DEF_NAME,

Line 1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);

1240: P_COLUMN28_VAL => L_VAL28,
1241: P_COLUMN29_VAL => L_VAL29,
1242: P_COLUMN30_VAL => L_VAL30);
1243:
1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);
1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);

Line 1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);

1241: P_COLUMN29_VAL => L_VAL29,
1242: P_COLUMN30_VAL => L_VAL30);
1243:
1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);
1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);

Line 1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);

1242: P_COLUMN30_VAL => L_VAL30);
1243:
1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);
1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);

Line 1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);

1243:
1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);
1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);

Line 1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);

1244: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL1 '||P_COLUMN1_VAL);
1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);

Line 1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);

1245: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL2 '||P_COLUMN2_VAL);
1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);
1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);

Line 1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);

1246: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL3 '||P_COLUMN3_VAL);
1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);
1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);
1254:

Line 1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);

1247: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL4 '||P_COLUMN4_VAL);
1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);
1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);
1254:
1255:

Line 1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);

1248: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL5 '||P_COLUMN5_VAL);
1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);
1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);
1254:
1255:
1256: END GET_DESC_FLEX_ALL_VALUES;

Line 1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);

1249: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL6 '||P_COLUMN6_VAL);
1250: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL7 '||P_COLUMN7_VAL);
1251: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL8 '||P_COLUMN8_VAL);
1252: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL9 '||P_COLUMN9_VAL);
1253: wf_log_pkg.string(6, 'GET_DESC_FLEX_ALL_VALUES','VAL10 '||P_COLUMN10_VAL);
1254:
1255:
1256: END GET_DESC_FLEX_ALL_VALUES;
1257:

Line 1270: wf_log_pkg.string(6, 'ATTACH_FILE','Inside Attachment Package, ATTACH_FILE procedure');

1266:
1267: BEGIN
1268: -- get the erecord id from the temporary table populate by the subscription
1269: -- rule function before invoking XML Gateway
1270: wf_log_pkg.string(6, 'ATTACH_FILE','Inside Attachment Package, ATTACH_FILE procedure');
1271: -- Bug 3186732
1272: -- Issue if XML Map has attachment procedure call then
1273: -- for those maps user used to get "NO DATA FOUND" Error
1274: -- because getting eRecord ID from edr_erecord_id_temp

Line 1287: wf_log_pkg.string(6, 'ATTACH_FILE','Event ID '||l_erecord_id);

1283:
1284: CLOSE GET_TEMP_EREC_ID;
1285:
1286: -- select document_id into l_erecord_id from edr_erecord_id_temp;
1287: wf_log_pkg.string(6, 'ATTACH_FILE','Event ID '||l_erecord_id);
1288: IF l_eRecord_id is not null THEN
1289: ATTACH_FILE_AUT(p_document_id, l_erecord_id);
1290: END IF;
1291: END ATTACH_FILE;

Line 1304: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','The FND Document id is '||l_document_id);

1300: l_media_id NUMBER;
1301: l_language VARCHAR2(10);
1302: BEGIN
1303: l_document_id := p_document_id;
1304: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','The FND Document id is '||l_document_id);
1305:
1306: select fnd_attached_documents_s.nextval into l_atc_doc_id
1307: from dual;
1308:

Line 1342: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error while writing to FND tables');

1338:
1339: commit;
1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error while writing to FND tables');
1343: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);
1344:
1345: END ATTACH_FILE_AUT;
1346:

Line 1343: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);

1339: commit;
1340: EXCEPTION
1341: WHEN OTHERS THEN
1342: wf_log_pkg.string(6, 'ATTACH_FILE_AUT','Unexpected error while writing to FND tables');
1343: wf_log_pkg.string(6, 'ATTACH_FILE_AUT',SQLERRM);
1344:
1345: END ATTACH_FILE_AUT;
1346:
1347: