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.FV_CCR_UTIL_PVT dependencies on FND_MESSAGE

Line 952: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');

948: /* Changed the reference to US from USA */
949: IF(p_main_address_country = 'US' AND
950: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
951: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
952: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
953: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
954: l_msg_text := FND_MESSAGE.GET;
955: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
956: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);

Line 953: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);

949: IF(p_main_address_country = 'US' AND
950: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
951: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
952: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
953: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
954: l_msg_text := FND_MESSAGE.GET;
955: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
956: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
957: l_vendor_id := p_vendor_id;

Line 954: l_msg_text := FND_MESSAGE.GET;

950: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
951: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
952: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
953: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
954: l_msg_text := FND_MESSAGE.GET;
955: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
956: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
957: l_vendor_id := p_vendor_id;
958: ELSE

Line 962: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');

958: ELSE
959: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
960: IF(nvl(l_pay_site_id,0)=0 AND
961: l_num_1099 <> p_taxpayer_number) THEN
962: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
963: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
964: l_msg_text := FND_MESSAGE.GET;
965: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
966: l_module_name,l_msg_text);

Line 963: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);

959: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
960: IF(nvl(l_pay_site_id,0)=0 AND
961: l_num_1099 <> p_taxpayer_number) THEN
962: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
963: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
964: l_msg_text := FND_MESSAGE.GET;
965: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
966: l_module_name,l_msg_text);
967: insert_for_report(p_duns,16,l_msg_text,null,

Line 964: l_msg_text := FND_MESSAGE.GET;

960: IF(nvl(l_pay_site_id,0)=0 AND
961: l_num_1099 <> p_taxpayer_number) THEN
962: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
963: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
964: l_msg_text := FND_MESSAGE.GET;
965: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
966: l_module_name,l_msg_text);
967: insert_for_report(p_duns,16,l_msg_text,null,
968: null,null,null);

Line 981: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_N');

977: and (fco.pay_site_id is not null or fco.MAIN_ADDRESS_SITE_ID is not null);
978:
979: if ((nvl(l_update_tin_prf, 'No') <> 'Yes') or (l_vendor_cnt > 0))then
980: l_update_tin_flg := 'No';
981: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_N');
982: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
983: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
984: l_msg_text := FND_MESSAGE.GET;
985:

Line 982: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);

978:
979: if ((nvl(l_update_tin_prf, 'No') <> 'Yes') or (l_vendor_cnt > 0))then
980: l_update_tin_flg := 'No';
981: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_N');
982: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
983: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
984: l_msg_text := FND_MESSAGE.GET;
985:
986: elsif nvl(l_update_tin_prf, 'No') = 'Yes' then

Line 983: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);

979: if ((nvl(l_update_tin_prf, 'No') <> 'Yes') or (l_vendor_cnt > 0))then
980: l_update_tin_flg := 'No';
981: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_N');
982: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
983: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
984: l_msg_text := FND_MESSAGE.GET;
985:
986: elsif nvl(l_update_tin_prf, 'No') = 'Yes' then
987:

Line 984: l_msg_text := FND_MESSAGE.GET;

980: l_update_tin_flg := 'No';
981: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_N');
982: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
983: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
984: l_msg_text := FND_MESSAGE.GET;
985:
986: elsif nvl(l_update_tin_prf, 'No') = 'Yes' then
987:
988: l_update_tin_flg := 'Yes';

Line 989: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_Y');

985:
986: elsif nvl(l_update_tin_prf, 'No') = 'Yes' then
987:
988: l_update_tin_flg := 'Yes';
989: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_Y');
990: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
992: l_msg_text := FND_MESSAGE.GET;
993: end if;

Line 990: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);

986: elsif nvl(l_update_tin_prf, 'No') = 'Yes' then
987:
988: l_update_tin_flg := 'Yes';
989: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_Y');
990: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
992: l_msg_text := FND_MESSAGE.GET;
993: end if;
994:

Line 991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);

987:
988: l_update_tin_flg := 'Yes';
989: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_Y');
990: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
992: l_msg_text := FND_MESSAGE.GET;
993: end if;
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317

Line 992: l_msg_text := FND_MESSAGE.GET;

988: l_update_tin_flg := 'Yes';
989: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED_Y');
990: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
992: l_msg_text := FND_MESSAGE.GET;
993: end if;
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317
996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);

Line 995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317

991: FND_MESSAGE.SET_TOKEN('VENDOR',l_vendor_name);
992: l_msg_text := FND_MESSAGE.GET;
993: end if;
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317
996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
997: -- l_msg_text := FND_MESSAGE.GET;
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
999: l_module_name,l_msg_text);

Line 996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);

992: l_msg_text := FND_MESSAGE.GET;
993: end if;
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317
996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
997: -- l_msg_text := FND_MESSAGE.GET;
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
999: l_module_name,l_msg_text);
1000: insert_for_report(p_duns,16,l_msg_text,null,

Line 997: -- l_msg_text := FND_MESSAGE.GET;

993: end if;
994:
995: -- FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED'); Bug 9179317
996: -- FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
997: -- l_msg_text := FND_MESSAGE.GET;
998: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
999: l_module_name,l_msg_text);
1000: insert_for_report(p_duns,16,l_msg_text,null,
1001: null,null,null);

Line 1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');

1006:
1007:
1008: IF (p_org_type_lookup IS NOT NULL) AND
1009: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);

Line 1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);

1007:
1008: IF (p_org_type_lookup IS NOT NULL) AND
1009: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);

Line 1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);

1008: IF (p_org_type_lookup IS NOT NULL) AND
1009: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;

Line 1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);

1009: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;
1017:

Line 1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);

1010: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;
1017:
1018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

Line 1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);

1011: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;
1017:
1018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1019: l_module_name,l_msg_text);

Line 1016: l_msg_text := FND_MESSAGE.GET;

1012: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
1013: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
1014: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
1015: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
1016: l_msg_text := FND_MESSAGE.GET;
1017:
1018: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1019: l_module_name,l_msg_text);
1020: insert_for_report(p_duns,16,l_msg_text,null,

Line 1054: l_excp_msg := FND_MESSAGE.GET;

1050: EXCEPTION
1051: WHEN OTHERS THEN
1052: l_header_conc_req_status := 'E';
1053: IF(l_msg IS NULL) THEN
1054: l_excp_msg := FND_MESSAGE.GET;
1055: ELSE
1056: l_excp_msg := l_msg;
1057: END IF;
1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');

Line 1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');

1054: l_excp_msg := FND_MESSAGE.GET;
1055: ELSE
1056: l_excp_msg := l_msg;
1057: END IF;
1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
1059: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
1060: l_msg_text := FND_MESSAGE.GET;
1061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1062: l_module_name,l_msg_text||'Error Code:' ||

Line 1059: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);

1055: ELSE
1056: l_excp_msg := l_msg;
1057: END IF;
1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
1059: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
1060: l_msg_text := FND_MESSAGE.GET;
1061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1062: l_module_name,l_msg_text||'Error Code:' ||
1063: SQLCODE ||' Error Text:' || SQLERRM);

Line 1060: l_msg_text := FND_MESSAGE.GET;

1056: l_excp_msg := l_msg;
1057: END IF;
1058: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
1059: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
1060: l_msg_text := FND_MESSAGE.GET;
1061: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
1062: l_module_name,l_msg_text||'Error Code:' ||
1063: SQLCODE ||' Error Text:' || SQLERRM);
1064: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null

Line 1102: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');

1098: END IF;
1099: IF(p_insert_vendor_flag = 'N' AND p_prev_vendor_id <> 0) THEN
1100: l_vendor_id := p_prev_vendor_id;
1101: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1102: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1103: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1104: l_msg_text := FND_MESSAGE.GET;
1105: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1106: l_module_name,l_msg_text);

Line 1103: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);

1099: IF(p_insert_vendor_flag = 'N' AND p_prev_vendor_id <> 0) THEN
1100: l_vendor_id := p_prev_vendor_id;
1101: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1102: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1103: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1104: l_msg_text := FND_MESSAGE.GET;
1105: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1106: l_module_name,l_msg_text);
1107: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);

Line 1104: l_msg_text := FND_MESSAGE.GET;

1100: l_vendor_id := p_prev_vendor_id;
1101: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1102: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1103: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1104: l_msg_text := FND_MESSAGE.GET;
1105: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1106: l_module_name,l_msg_text);
1107: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);
1108: ELSE

Line 1121: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');

1117: l_vendor_id :=0;
1118:
1119: IF(l_supp_num_exist IS NOT NULL
1120: AND l_supp_num_exist = 'Y') THEN
1121: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1122: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1123: l_msg_text:= FND_MESSAGE.GET;
1124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1125: l_module_name,l_msg_text);

Line 1122: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);

1118:
1119: IF(l_supp_num_exist IS NOT NULL
1120: AND l_supp_num_exist = 'Y') THEN
1121: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1122: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1123: l_msg_text:= FND_MESSAGE.GET;
1124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1125: l_module_name,l_msg_text);
1126: insert_for_report(p_duns,18,l_msg_text,null,

Line 1123: l_msg_text:= FND_MESSAGE.GET;

1119: IF(l_supp_num_exist IS NOT NULL
1120: AND l_supp_num_exist = 'Y') THEN
1121: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1122: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1123: l_msg_text:= FND_MESSAGE.GET;
1124: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1125: l_module_name,l_msg_text);
1126: insert_for_report(p_duns,18,l_msg_text,null,
1127: null,null,null);

Line 1133: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');

1129:
1130: END IF;
1131: ELSE
1132: IF(p_taxpayer_number IS NOT NULL) THEN
1133: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1134: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1135: l_msg_text := FND_MESSAGE.GET;
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1137: ,l_module_name,l_msg_text);

Line 1134: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);

1130: END IF;
1131: ELSE
1132: IF(p_taxpayer_number IS NOT NULL) THEN
1133: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1134: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1135: l_msg_text := FND_MESSAGE.GET;
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1137: ,l_module_name,l_msg_text);
1138: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1135: l_msg_text := FND_MESSAGE.GET;

1131: ELSE
1132: IF(p_taxpayer_number IS NOT NULL) THEN
1133: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1134: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1135: l_msg_text := FND_MESSAGE.GET;
1136: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1137: ,l_module_name,l_msg_text);
1138: insert_for_report(p_duns,16,l_msg_text,null,null
1139: ,null,null);

Line 1187: l_excp_msg := FND_MESSAGE.GET;

1183: EXCEPTION
1184: WHEN OTHERS THEN
1185: l_header_conc_req_status := 'E';
1186: IF(l_msg IS NULL) THEN
1187: l_excp_msg := FND_MESSAGE.GET;
1188: ELSE
1189: l_excp_msg := l_msg;
1190: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');

Line 1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');

1187: l_excp_msg := FND_MESSAGE.GET;
1188: ELSE
1189: l_excp_msg := l_msg;
1190: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1194: l_msg_text := FND_MESSAGE.GET ;
1195: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

Line 1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);

1188: ELSE
1189: l_excp_msg := l_msg;
1190: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1194: l_msg_text := FND_MESSAGE.GET ;
1195: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1196: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'

Line 1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);

1189: l_excp_msg := l_msg;
1190: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1194: l_msg_text := FND_MESSAGE.GET ;
1195: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1196: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1197: || SQLERRM);

Line 1194: l_msg_text := FND_MESSAGE.GET ;

1190: END IF;
1191: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1192: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1193: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1194: l_msg_text := FND_MESSAGE.GET ;
1195: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1196: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1197: || SQLERRM);
1198: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');

1282: l_plus4 := 'LOC'||p_duns;
1283:
1284: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1285: l_assgn_conc_req_status := 'E';
1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1289: l_msg_text := FND_MESSAGE.GET;
1290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

Line 1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);

1283:
1284: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1285: l_assgn_conc_req_status := 'E';
1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1289: l_msg_text := FND_MESSAGE.GET;
1290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1291: ,l_module_name,l_msg_text);

Line 1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);

1284: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1285: l_assgn_conc_req_status := 'E';
1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1289: l_msg_text := FND_MESSAGE.GET;
1290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1291: ,l_module_name,l_msg_text);
1292: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1289: l_msg_text := FND_MESSAGE.GET;

1285: l_assgn_conc_req_status := 'E';
1286: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1287: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1288: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1289: l_msg_text := FND_MESSAGE.GET;
1290: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1291: ,l_module_name,l_msg_text);
1292: insert_for_report(p_duns,16,l_msg_text,null,null
1293: ,null,null);

Line 1398: l_excp_msg := FND_MESSAGE.GET;

1394: EXCEPTION
1395: WHEN OTHERS THEN
1396: l_assgn_conc_req_status := 'E';
1397: IF(l_msg IS NULL) THEN
1398: l_excp_msg := FND_MESSAGE.GET;
1399: ELSE
1400: l_excp_msg := l_msg;
1401: END IF;
1402: IF(nvl(l_main_add_site_id,0) = 0) THEN

Line 1403: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');

1399: ELSE
1400: l_excp_msg := l_msg;
1401: END IF;
1402: IF(nvl(l_main_add_site_id,0) = 0) THEN
1403: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1404: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1405: l_msg_text := FND_MESSAGE.GET;
1406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1407: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

Line 1404: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);

1400: l_excp_msg := l_msg;
1401: END IF;
1402: IF(nvl(l_main_add_site_id,0) = 0) THEN
1403: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1404: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1405: l_msg_text := FND_MESSAGE.GET;
1406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1407: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1408: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1405: l_msg_text := FND_MESSAGE.GET;

1401: END IF;
1402: IF(nvl(l_main_add_site_id,0) = 0) THEN
1403: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1404: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1405: l_msg_text := FND_MESSAGE.GET;
1406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1407: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1408: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1409: ELSE

Line 1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');

1406: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1407: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1408: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1409: ELSE
1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1411: get_vendor_site_code(p_main_add_site_id,l_site_code);
1412: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1413: l_msg_text := FND_MESSAGE.GET;
1414: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

Line 1412: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);

1408: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1409: ELSE
1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1411: get_vendor_site_code(p_main_add_site_id,l_site_code);
1412: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1413: l_msg_text := FND_MESSAGE.GET;
1414: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1415: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1416: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1413: l_msg_text := FND_MESSAGE.GET;

1409: ELSE
1410: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1411: get_vendor_site_code(p_main_add_site_id,l_site_code);
1412: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1413: l_msg_text := FND_MESSAGE.GET;
1414: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1415: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1416: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1417: END IF;

Line 1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');

1533: duplicate_vendor_site_code(l_vendor_id,l_plus4,p_org_id,l_dup_site_code,
1534: l_site_id_site_code,l_duns_site_code);
1535: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1536: l_assgn_conc_req_status := 'E';
1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1540: l_msg_text := FND_MESSAGE.GET;
1541: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

Line 1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);

1534: l_site_id_site_code,l_duns_site_code);
1535: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1536: l_assgn_conc_req_status := 'E';
1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1540: l_msg_text := FND_MESSAGE.GET;
1541: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1542: ,l_module_name,l_msg_text);

Line 1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);

1535: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1536: l_assgn_conc_req_status := 'E';
1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1540: l_msg_text := FND_MESSAGE.GET;
1541: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1542: ,l_module_name,l_msg_text);
1543: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1540: l_msg_text := FND_MESSAGE.GET;

1536: l_assgn_conc_req_status := 'E';
1537: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1538: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1539: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1540: l_msg_text := FND_MESSAGE.GET;
1541: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1542: ,l_module_name,l_msg_text);
1543: insert_for_report(p_duns,16,l_msg_text,null,null
1544: ,null,null);

Line 1603: l_excp_msg := FND_MESSAGE.GET;

1599: EXCEPTION
1600: WHEN OTHERS THEN
1601: l_assgn_conc_req_status := 'E';
1602: IF(l_msg IS NULL) THEN
1603: l_excp_msg := FND_MESSAGE.GET;
1604: ELSE
1605: l_excp_msg := l_msg;
1606: END IF;
1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');

Line 1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');

1603: l_excp_msg := FND_MESSAGE.GET;
1604: ELSE
1605: l_excp_msg := l_msg;
1606: END IF;
1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1608: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1609: l_msg_text := FND_MESSAGE.GET;
1610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1611: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

Line 1608: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);

1604: ELSE
1605: l_excp_msg := l_msg;
1606: END IF;
1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1608: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1609: l_msg_text := FND_MESSAGE.GET;
1610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1611: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1612: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1609: l_msg_text := FND_MESSAGE.GET;

1605: l_excp_msg := l_msg;
1606: END IF;
1607: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1608: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1609: l_msg_text := FND_MESSAGE.GET;
1610: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1611: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1612: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1613: l_account_uses_insert_flag := 'N';

Line 1681: l_excp_msg:=FND_MESSAGE.GET;

1677: EXCEPTION
1678: WHEN OTHERS THEN
1679: l_assgn_conc_req_status := 'E';
1680: IF(l_msg IS NULL) THEN
1681: l_excp_msg:=FND_MESSAGE.GET;
1682: ELSE
1683: l_excp_msg:=l_msg;
1684: END IF;
1685: get_vendor_site_code(p_pay_site_id,l_site_code);

Line 1686: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');

1682: ELSE
1683: l_excp_msg:=l_msg;
1684: END IF;
1685: get_vendor_site_code(p_pay_site_id,l_site_code);
1686: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1687: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1688: l_msg_text := FND_MESSAGE.GET;
1689: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1690: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

Line 1687: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);

1683: l_excp_msg:=l_msg;
1684: END IF;
1685: get_vendor_site_code(p_pay_site_id,l_site_code);
1686: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1687: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1688: l_msg_text := FND_MESSAGE.GET;
1689: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1690: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1691: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1688: l_msg_text := FND_MESSAGE.GET;

1684: END IF;
1685: get_vendor_site_code(p_pay_site_id,l_site_code);
1686: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1687: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1688: l_msg_text := FND_MESSAGE.GET;
1689: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1690: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1691: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1692:

Line 1854: l_excp_msg := FND_MESSAGE.GET;

1850: EXCEPTION
1851: WHEN OTHERS THEN
1852: l_assgn_conc_req_status := 'E';
1853: IF(l_msg IS NULL) THEN
1854: l_excp_msg := FND_MESSAGE.GET;
1855: ELSE
1856: l_excp_msg := l_msg;
1857: END IF;
1858: get_vendor_site_code(p_pay_site_id,l_site_code);

Line 1859: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');

1855: ELSE
1856: l_excp_msg := l_msg;
1857: END IF;
1858: get_vendor_site_code(p_pay_site_id,l_site_code);
1859: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1860: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1861: l_msg_text := FND_MESSAGE.GET;
1862: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1863: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

Line 1860: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);

1856: l_excp_msg := l_msg;
1857: END IF;
1858: get_vendor_site_code(p_pay_site_id,l_site_code);
1859: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1860: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1861: l_msg_text := FND_MESSAGE.GET;
1862: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1863: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1864: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1861: l_msg_text := FND_MESSAGE.GET;

1857: END IF;
1858: get_vendor_site_code(p_pay_site_id,l_site_code);
1859: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1860: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1861: l_msg_text := FND_MESSAGE.GET;
1862: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1863: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1864: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1865: END;

Line 1914: l_excp_msg := FND_MESSAGE.GET;

1910: EXCEPTION
1911: WHEN OTHERS THEN
1912: l_assgn_conc_req_status := 'E';
1913: IF(l_msg IS NULL) THEN
1914: l_excp_msg := FND_MESSAGE.GET;
1915: ELSE
1916: l_excp_msg := l_msg;
1917: END IF;
1918: get_vendor_site_code(p_main_add_site_id,l_site_code);

Line 1919: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');

1915: ELSE
1916: l_excp_msg := l_msg;
1917: END IF;
1918: get_vendor_site_code(p_main_add_site_id,l_site_code);
1919: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1920: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1921: l_msg_text := FND_MESSAGE.GET;
1922: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1923: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

Line 1920: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);

1916: l_excp_msg := l_msg;
1917: END IF;
1918: get_vendor_site_code(p_main_add_site_id,l_site_code);
1919: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1920: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1921: l_msg_text := FND_MESSAGE.GET;
1922: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1923: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1924: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1921: l_msg_text := FND_MESSAGE.GET;

1917: END IF;
1918: get_vendor_site_code(p_main_add_site_id,l_site_code);
1919: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1920: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1921: l_msg_text := FND_MESSAGE.GET;
1922: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1923: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1924: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1925: END;