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 899: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');

895: /* Changed the reference to US from USA */
896: IF(p_main_address_country = 'US' AND
897: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
898: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
899: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
900: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
901: l_msg_text := FND_MESSAGE.GET;
902: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);

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

896: IF(p_main_address_country = 'US' AND
897: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
898: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
899: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
900: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
901: l_msg_text := FND_MESSAGE.GET;
902: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
904: l_vendor_id := p_vendor_id;

Line 901: l_msg_text := FND_MESSAGE.GET;

897: (p_taxpayer_number IS NULL or length(p_taxpayer_number)<>9)) THEN
898: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
899: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_CHANGE_INVALID');
900: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
901: l_msg_text := FND_MESSAGE.GET;
902: insert_for_report(p_duns,18,l_msg_text,null,null,null,null);
903: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text);
904: l_vendor_id := p_vendor_id;
905: ELSE

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

905: ELSE
906: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
907: IF(nvl(l_pay_site_id,0)=0 AND
908: l_num_1099 <> p_taxpayer_number) THEN
909: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
910: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
911: l_msg_text := FND_MESSAGE.GET;
912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
913: l_module_name,l_msg_text);

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

906: get_vendor_name(p_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
907: IF(nvl(l_pay_site_id,0)=0 AND
908: l_num_1099 <> p_taxpayer_number) THEN
909: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
910: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
911: l_msg_text := FND_MESSAGE.GET;
912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
913: l_module_name,l_msg_text);
914: insert_for_report(p_duns,16,l_msg_text,null,

Line 911: l_msg_text := FND_MESSAGE.GET;

907: IF(nvl(l_pay_site_id,0)=0 AND
908: l_num_1099 <> p_taxpayer_number) THEN
909: FND_MESSAGE.SET_NAME('FV','FV_CCR_DUNS_TAXPAYER_ASSIGN');
910: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
911: l_msg_text := FND_MESSAGE.GET;
912: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
913: l_module_name,l_msg_text);
914: insert_for_report(p_duns,16,l_msg_text,null,
915: null,null,null);

Line 917: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED');

913: l_module_name,l_msg_text);
914: insert_for_report(p_duns,16,l_msg_text,null,
915: null,null,null);
916: ELSIF(l_num_1099 <> p_taxpayer_number) THEN
917: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED');
918: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
919: l_msg_text := FND_MESSAGE.GET;
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
921: l_module_name,l_msg_text);

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

914: insert_for_report(p_duns,16,l_msg_text,null,
915: null,null,null);
916: ELSIF(l_num_1099 <> p_taxpayer_number) THEN
917: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED');
918: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
919: l_msg_text := FND_MESSAGE.GET;
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
921: l_module_name,l_msg_text);
922: insert_for_report(p_duns,16,l_msg_text,null,

Line 919: l_msg_text := FND_MESSAGE.GET;

915: null,null,null);
916: ELSIF(l_num_1099 <> p_taxpayer_number) THEN
917: FND_MESSAGE.SET_NAME('FV','FV_CCR_TAXPAYER_NUM_CHANGED');
918: FND_MESSAGE.SET_TOKEN('DUNS',p_duns);
919: l_msg_text := FND_MESSAGE.GET;
920: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
921: l_module_name,l_msg_text);
922: insert_for_report(p_duns,16,l_msg_text,null,
923: null,null,null);

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

928:
929:
930: IF (p_org_type_lookup IS NOT NULL) AND
931: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
932: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);

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

929:
930: IF (p_org_type_lookup IS NOT NULL) AND
931: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
932: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);

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

930: IF (p_org_type_lookup IS NOT NULL) AND
931: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
932: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;

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

931: (NVL(l_org_type_lookup,'-XXX') <> p_org_type_lookup) THEN
932: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;
939:

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

932: FND_MESSAGE.SET_NAME('FV','FV_CCR_ORG_LKUP_CHANGED');
933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;
939:
940: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,

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

933: FND_MESSAGE.SET_TOKEN('OLDORGTYPE',l_org_type_lookup);
934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;
939:
940: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
941: l_module_name,l_msg_text);

Line 938: l_msg_text := FND_MESSAGE.GET;

934: FND_MESSAGE.SET_TOKEN('NAME', l_vendor_name);
935: FND_MESSAGE.SET_TOKEN('TIN', l_num_1099);
936: FND_MESSAGE.SET_TOKEN('NEWORGTYPE', p_org_type_lookup);
937: FND_MESSAGE.SET_TOKEN('DUNS', p_duns);
938: l_msg_text := FND_MESSAGE.GET;
939:
940: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
941: l_module_name,l_msg_text);
942: insert_for_report(p_duns,16,l_msg_text,null,

Line 976: l_excp_msg := FND_MESSAGE.GET;

972: EXCEPTION
973: WHEN OTHERS THEN
974: l_header_conc_req_status := 'E';
975: IF(l_msg IS NULL) THEN
976: l_excp_msg := FND_MESSAGE.GET;
977: ELSE
978: l_excp_msg := l_msg;
979: END IF;
980: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');

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

976: l_excp_msg := FND_MESSAGE.GET;
977: ELSE
978: l_excp_msg := l_msg;
979: END IF;
980: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
981: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
982: l_msg_text := FND_MESSAGE.GET;
983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
984: l_module_name,l_msg_text||'Error Code:' ||

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

977: ELSE
978: l_excp_msg := l_msg;
979: END IF;
980: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
981: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
982: l_msg_text := FND_MESSAGE.GET;
983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
984: l_module_name,l_msg_text||'Error Code:' ||
985: SQLCODE ||' Error Text:' || SQLERRM);

Line 982: l_msg_text := FND_MESSAGE.GET;

978: l_excp_msg := l_msg;
979: END IF;
980: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_UPDATE');
981: FND_MESSAGE.SET_TOKEN('VENDORNAME',l_vendor_name);
982: l_msg_text := FND_MESSAGE.GET;
983: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,
984: l_module_name,l_msg_text||'Error Code:' ||
985: SQLCODE ||' Error Text:' || SQLERRM);
986: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null

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

1019: END IF;
1020: IF(p_insert_vendor_flag = 'N' AND p_prev_vendor_id <> 0) THEN
1021: l_vendor_id := p_prev_vendor_id;
1022: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1023: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1024: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1025: l_msg_text := FND_MESSAGE.GET;
1026: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1027: l_module_name,l_msg_text);

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

1020: IF(p_insert_vendor_flag = 'N' AND p_prev_vendor_id <> 0) THEN
1021: l_vendor_id := p_prev_vendor_id;
1022: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1023: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1024: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1025: l_msg_text := FND_MESSAGE.GET;
1026: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1027: l_module_name,l_msg_text);
1028: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);

Line 1025: l_msg_text := FND_MESSAGE.GET;

1021: l_vendor_id := p_prev_vendor_id;
1022: get_vendor_name(l_vendor_id,l_vendor_name,l_num_1099,l_org_type_lookup);
1023: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1024: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1025: l_msg_text := FND_MESSAGE.GET;
1026: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1027: l_module_name,l_msg_text);
1028: insert_for_report(p_duns,16,l_msg_text,null,null,null,null);
1029: ELSE

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

1038: l_vendor_id :=0;
1039:
1040: IF(l_supp_num_exist IS NOT NULL
1041: AND l_supp_num_exist = 'Y') THEN
1042: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1043: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1044: l_msg_text:= FND_MESSAGE.GET;
1045: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1046: l_module_name,l_msg_text);

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

1039:
1040: IF(l_supp_num_exist IS NOT NULL
1041: AND l_supp_num_exist = 'Y') THEN
1042: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1043: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1044: l_msg_text:= FND_MESSAGE.GET;
1045: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1046: l_module_name,l_msg_text);
1047: insert_for_report(p_duns,18,l_msg_text,null,

Line 1044: l_msg_text:= FND_MESSAGE.GET;

1040: IF(l_supp_num_exist IS NOT NULL
1041: AND l_supp_num_exist = 'Y') THEN
1042: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_NUM_EXIST');
1043: FND_MESSAGE.SET_TOKEN('NUM',l_supplier_number);
1044: l_msg_text:= FND_MESSAGE.GET;
1045: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT,
1046: l_module_name,l_msg_text);
1047: insert_for_report(p_duns,18,l_msg_text,null,
1048: null,null,null);

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

1050:
1051: END IF;
1052: ELSE
1053: IF(p_taxpayer_number IS NOT NULL) THEN
1054: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1055: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1056: l_msg_text := FND_MESSAGE.GET;
1057: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1058: ,l_module_name,l_msg_text);

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

1051: END IF;
1052: ELSE
1053: IF(p_taxpayer_number IS NOT NULL) THEN
1054: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1055: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1056: l_msg_text := FND_MESSAGE.GET;
1057: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1058: ,l_module_name,l_msg_text);
1059: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1056: l_msg_text := FND_MESSAGE.GET;

1052: ELSE
1053: IF(p_taxpayer_number IS NOT NULL) THEN
1054: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_TAXPAYER_EXIST');
1055: FND_MESSAGE.SET_TOKEN('SUPPLIER',l_vendor_name);
1056: l_msg_text := FND_MESSAGE.GET;
1057: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1058: ,l_module_name,l_msg_text);
1059: insert_for_report(p_duns,16,l_msg_text,null,null
1060: ,null,null);

Line 1108: l_excp_msg := FND_MESSAGE.GET;

1104: EXCEPTION
1105: WHEN OTHERS THEN
1106: l_header_conc_req_status := 'E';
1107: IF(l_msg IS NULL) THEN
1108: l_excp_msg := FND_MESSAGE.GET;
1109: ELSE
1110: l_excp_msg := l_msg;
1111: END IF;
1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');

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

1108: l_excp_msg := FND_MESSAGE.GET;
1109: ELSE
1110: l_excp_msg := l_msg;
1111: END IF;
1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1113: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1114: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1115: l_msg_text := FND_MESSAGE.GET ;
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,

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

1109: ELSE
1110: l_excp_msg := l_msg;
1111: END IF;
1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1113: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1114: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1115: l_msg_text := FND_MESSAGE.GET ;
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1117: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'

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

1110: l_excp_msg := l_msg;
1111: END IF;
1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1113: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1114: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1115: l_msg_text := FND_MESSAGE.GET ;
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1117: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1118: || SQLERRM);

Line 1115: l_msg_text := FND_MESSAGE.GET ;

1111: END IF;
1112: FND_MESSAGE.SET_NAME('FV','FV_CCR_VENDOR_INSERT');
1113: --FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',p_legal_bus_name);
1114: FND_MESSAGE.SET_TOKEN('LEGALBUSNAME',l_legal_bus_name);
1115: l_msg_text := FND_MESSAGE.GET ;
1116: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,
1117: l_msg_text||' Error Code:' || SQLCODE ||' Error Text:'
1118: || SQLERRM);
1119: insert_for_report(p_duns,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

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

1203: l_plus4 := 'LOC'||p_duns;
1204:
1205: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1206: l_assgn_conc_req_status := 'E';
1207: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1208: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1209: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1210: l_msg_text := FND_MESSAGE.GET;
1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

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

1204:
1205: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1206: l_assgn_conc_req_status := 'E';
1207: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1208: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1209: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1210: l_msg_text := FND_MESSAGE.GET;
1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1212: ,l_module_name,l_msg_text);

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

1205: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1206: l_assgn_conc_req_status := 'E';
1207: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1208: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1209: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1210: l_msg_text := FND_MESSAGE.GET;
1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1212: ,l_module_name,l_msg_text);
1213: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1210: l_msg_text := FND_MESSAGE.GET;

1206: l_assgn_conc_req_status := 'E';
1207: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1208: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1209: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1210: l_msg_text := FND_MESSAGE.GET;
1211: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1212: ,l_module_name,l_msg_text);
1213: insert_for_report(p_duns,16,l_msg_text,null,null
1214: ,null,null);

Line 1319: l_excp_msg := FND_MESSAGE.GET;

1315: EXCEPTION
1316: WHEN OTHERS THEN
1317: l_assgn_conc_req_status := 'E';
1318: IF(l_msg IS NULL) THEN
1319: l_excp_msg := FND_MESSAGE.GET;
1320: ELSE
1321: l_excp_msg := l_msg;
1322: END IF;
1323: IF(nvl(l_main_add_site_id,0) = 0) THEN

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

1320: ELSE
1321: l_excp_msg := l_msg;
1322: END IF;
1323: IF(nvl(l_main_add_site_id,0) = 0) THEN
1324: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1325: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1326: l_msg_text := FND_MESSAGE.GET;
1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1328: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

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

1321: l_excp_msg := l_msg;
1322: END IF;
1323: IF(nvl(l_main_add_site_id,0) = 0) THEN
1324: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1325: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1326: l_msg_text := FND_MESSAGE.GET;
1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1328: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1329: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1326: l_msg_text := FND_MESSAGE.GET;

1322: END IF;
1323: IF(nvl(l_main_add_site_id,0) = 0) THEN
1324: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_INSERT');
1325: FND_MESSAGE.SET_TOKEN('DUNS',l_duns_for_report);
1326: l_msg_text := FND_MESSAGE.GET;
1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1328: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1329: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1330: ELSE

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

1327: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1328: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1329: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1330: ELSE
1331: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1332: get_vendor_site_code(p_main_add_site_id,l_site_code);
1333: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1334: l_msg_text := FND_MESSAGE.GET;
1335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||

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

1329: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1330: ELSE
1331: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1332: get_vendor_site_code(p_main_add_site_id,l_site_code);
1333: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1334: l_msg_text := FND_MESSAGE.GET;
1335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1336: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1337: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1334: l_msg_text := FND_MESSAGE.GET;

1330: ELSE
1331: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1332: get_vendor_site_code(p_main_add_site_id,l_site_code);
1333: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1334: l_msg_text := FND_MESSAGE.GET;
1335: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1336: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1337: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1338: END IF;

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

1363: duplicate_vendor_site_code(l_vendor_id,l_plus4,p_org_id,l_dup_site_code,
1364: l_site_id_site_code,l_duns_site_code);
1365: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1366: l_assgn_conc_req_status := 'E';
1367: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1368: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1369: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1370: l_msg_text := FND_MESSAGE.GET;
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT

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

1364: l_site_id_site_code,l_duns_site_code);
1365: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1366: l_assgn_conc_req_status := 'E';
1367: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1368: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1369: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1370: l_msg_text := FND_MESSAGE.GET;
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1372: ,l_module_name,l_msg_text);

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

1365: IF(nvl(l_dup_site_code,'F') = 'T') THEN
1366: l_assgn_conc_req_status := 'E';
1367: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1368: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1369: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1370: l_msg_text := FND_MESSAGE.GET;
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1372: ,l_module_name,l_msg_text);
1373: insert_for_report(p_duns,16,l_msg_text,null,null

Line 1370: l_msg_text := FND_MESSAGE.GET;

1366: l_assgn_conc_req_status := 'E';
1367: FND_MESSAGE.SET_NAME('FV','FV_CCR_SITE_CODE_EXISTS');
1368: FND_MESSAGE.SET_TOKEN('ORGNAME',p_org_name);
1369: FND_MESSAGE.SET_TOKEN('DEFAULTCODE',l_plus4);
1370: l_msg_text := FND_MESSAGE.GET;
1371: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT
1372: ,l_module_name,l_msg_text);
1373: insert_for_report(p_duns,16,l_msg_text,null,null
1374: ,null,null);

Line 1433: l_excp_msg := FND_MESSAGE.GET;

1429: EXCEPTION
1430: WHEN OTHERS THEN
1431: l_assgn_conc_req_status := 'E';
1432: IF(l_msg IS NULL) THEN
1433: l_excp_msg := FND_MESSAGE.GET;
1434: ELSE
1435: l_excp_msg := l_msg;
1436: END IF;
1437: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');

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

1433: l_excp_msg := FND_MESSAGE.GET;
1434: ELSE
1435: l_excp_msg := l_msg;
1436: END IF;
1437: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1438: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1439: l_msg_text := FND_MESSAGE.GET;
1440: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1441: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

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

1434: ELSE
1435: l_excp_msg := l_msg;
1436: END IF;
1437: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1438: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1439: l_msg_text := FND_MESSAGE.GET;
1440: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1441: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1442: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1439: l_msg_text := FND_MESSAGE.GET;

1435: l_excp_msg := l_msg;
1436: END IF;
1437: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_INSERT');
1438: FND_MESSAGE.SET_TOKEN('DUNS',l_plus4);
1439: l_msg_text := FND_MESSAGE.GET;
1440: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1441: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1442: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1443: l_account_uses_insert_flag := 'N';

Line 1511: l_excp_msg:=FND_MESSAGE.GET;

1507: EXCEPTION
1508: WHEN OTHERS THEN
1509: l_assgn_conc_req_status := 'E';
1510: IF(l_msg IS NULL) THEN
1511: l_excp_msg:=FND_MESSAGE.GET;
1512: ELSE
1513: l_excp_msg:=l_msg;
1514: END IF;
1515: get_vendor_site_code(p_pay_site_id,l_site_code);

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

1512: ELSE
1513: l_excp_msg:=l_msg;
1514: END IF;
1515: get_vendor_site_code(p_pay_site_id,l_site_code);
1516: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1517: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1518: l_msg_text := FND_MESSAGE.GET;
1519: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1520: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

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

1513: l_excp_msg:=l_msg;
1514: END IF;
1515: get_vendor_site_code(p_pay_site_id,l_site_code);
1516: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1517: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1518: l_msg_text := FND_MESSAGE.GET;
1519: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1520: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1521: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1518: l_msg_text := FND_MESSAGE.GET;

1514: END IF;
1515: get_vendor_site_code(p_pay_site_id,l_site_code);
1516: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1517: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1518: l_msg_text := FND_MESSAGE.GET;
1519: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1520: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1521: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1522:

Line 1635: l_excp_msg := FND_MESSAGE.GET;

1631: EXCEPTION
1632: WHEN OTHERS THEN
1633: l_assgn_conc_req_status := 'E';
1634: IF(l_msg IS NULL) THEN
1635: l_excp_msg := FND_MESSAGE.GET;
1636: ELSE
1637: l_excp_msg := l_msg;
1638: END IF;
1639: get_vendor_site_code(p_pay_site_id,l_site_code);

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

1636: ELSE
1637: l_excp_msg := l_msg;
1638: END IF;
1639: get_vendor_site_code(p_pay_site_id,l_site_code);
1640: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1641: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1642: l_msg_text := FND_MESSAGE.GET;
1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1644: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

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

1637: l_excp_msg := l_msg;
1638: END IF;
1639: get_vendor_site_code(p_pay_site_id,l_site_code);
1640: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1641: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1642: l_msg_text := FND_MESSAGE.GET;
1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1644: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1645: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1642: l_msg_text := FND_MESSAGE.GET;

1638: END IF;
1639: get_vendor_site_code(p_pay_site_id,l_site_code);
1640: FND_MESSAGE.SET_NAME('FV','FV_CCR_PAY_SITE_UPDATE');
1641: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1642: l_msg_text := FND_MESSAGE.GET;
1643: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1644: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1645: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1646: END;

Line 1693: l_excp_msg := FND_MESSAGE.GET;

1689: EXCEPTION
1690: WHEN OTHERS THEN
1691: l_assgn_conc_req_status := 'E';
1692: IF(l_msg IS NULL) THEN
1693: l_excp_msg := FND_MESSAGE.GET;
1694: ELSE
1695: l_excp_msg := l_msg;
1696: END IF;
1697: get_vendor_site_code(p_main_add_site_id,l_site_code);

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

1694: ELSE
1695: l_excp_msg := l_msg;
1696: END IF;
1697: get_vendor_site_code(p_main_add_site_id,l_site_code);
1698: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1699: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1700: l_msg_text := FND_MESSAGE.GET;
1701: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1702: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);

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

1695: l_excp_msg := l_msg;
1696: END IF;
1697: get_vendor_site_code(p_main_add_site_id,l_site_code);
1698: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1699: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1700: l_msg_text := FND_MESSAGE.GET;
1701: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1702: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1703: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);

Line 1700: l_msg_text := FND_MESSAGE.GET;

1696: END IF;
1697: get_vendor_site_code(p_main_add_site_id,l_site_code);
1698: FND_MESSAGE.SET_NAME('FV','FV_CCR_MAIN_SITE_UPDATE');
1699: FND_MESSAGE.SET_TOKEN('VENDORSITECODE',l_site_code);
1700: l_msg_text := FND_MESSAGE.GET;
1701: FV_UTILITY.LOG_MESG(FND_LOG.LEVEL_STATEMENT,l_module_name,l_msg_text||
1702: ' Error Code:' || SQLCODE ||' Error Text:' || SQLERRM);
1703: insert_for_report(l_duns_for_report,19,l_msg_text||nvl(l_excp_msg,''),null,null,null,null);
1704: END;