75: OPEN c_get_pv_prgm_pmt_mode(p_program_payment_mode , p_program_id, p_geo_hierarchy_id);
76: FETCH c_get_pv_prgm_pmt_mode INTO x_pmt_mode_desc ;
77: IF c_get_pv_prgm_pmt_mode%NOTFOUND THEN
78: CLOSE c_get_pv_prgm_pmt_mode;
79: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
80: FND_MESSAGE.set_token('MODE','find');
81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');
82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode
83: ||' Program Id: '||p_program_id
76: FETCH c_get_pv_prgm_pmt_mode INTO x_pmt_mode_desc ;
77: IF c_get_pv_prgm_pmt_mode%NOTFOUND THEN
78: CLOSE c_get_pv_prgm_pmt_mode;
79: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
80: FND_MESSAGE.set_token('MODE','find');
81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');
82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode
83: ||' Program Id: '||p_program_id
84: ||' Geo Hierarchy Id: '|| p_geo_hierarchy_id);
77: IF c_get_pv_prgm_pmt_mode%NOTFOUND THEN
78: CLOSE c_get_pv_prgm_pmt_mode;
79: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
80: FND_MESSAGE.set_token('MODE','find');
81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');
82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode
83: ||' Program Id: '||p_program_id
84: ||' Geo Hierarchy Id: '|| p_geo_hierarchy_id);
85: FND_MSG_PUB.add;
78: CLOSE c_get_pv_prgm_pmt_mode;
79: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
80: FND_MESSAGE.set_token('MODE','find');
81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');
82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode
83: ||' Program Id: '||p_program_id
84: ||' Geo Hierarchy Id: '|| p_geo_hierarchy_id);
85: FND_MSG_PUB.add;
86: IF (PV_DEBUG_HIGH_ON) THEN
131:
132: OPEN c_get_geo_hierarchy(p_program_payment_mode , p_program_id, p_geo_hierarchy_id);
133: FETCH c_get_geo_hierarchy INTO x_geo_area_name, x_location_type_name ;
134: IF c_get_geo_hierarchy%NOTFOUND THEN
135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
136: FND_MESSAGE.set_token('MODE','');
137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');
138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');
139: FND_MSG_PUB.add;
132: OPEN c_get_geo_hierarchy(p_program_payment_mode , p_program_id, p_geo_hierarchy_id);
133: FETCH c_get_geo_hierarchy INTO x_geo_area_name, x_location_type_name ;
134: IF c_get_geo_hierarchy%NOTFOUND THEN
135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
136: FND_MESSAGE.set_token('MODE','');
137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');
138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');
139: FND_MSG_PUB.add;
140: IF (PV_DEBUG_HIGH_ON) THEN
133: FETCH c_get_geo_hierarchy INTO x_geo_area_name, x_location_type_name ;
134: IF c_get_geo_hierarchy%NOTFOUND THEN
135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
136: FND_MESSAGE.set_token('MODE','');
137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');
138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');
139: FND_MSG_PUB.add;
140: IF (PV_DEBUG_HIGH_ON) THEN
141:
134: IF c_get_geo_hierarchy%NOTFOUND THEN
135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
136: FND_MESSAGE.set_token('MODE','');
137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');
138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');
139: FND_MSG_PUB.add;
140: IF (PV_DEBUG_HIGH_ON) THEN
141:
142: PVX_UTILITY_PVT.debug_message('No Data found for the payment method description');
245:
246: END IF;
247:
248: IF FND_GLOBAL.User_Id IS NULL THEN
249: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
250: FND_MSG_PUB.add;
251: RAISE FND_API.G_EXC_ERROR;
252: END IF;
253:
507: OPEN c_get_prgm_pmt_mode( l_tar_prgm_pmt_mode_rec.program_payment_mode_id);
508: FETCH c_get_prgm_pmt_mode INTO l_ref_prgm_pmt_mode_rec ;
509:
510: IF ( c_get_prgm_pmt_mode%NOTFOUND) THEN
511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
512: FND_MESSAGE.set_token('MODE','Update');
513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');
514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));
515: FND_MSG_PUB.add;
508: FETCH c_get_prgm_pmt_mode INTO l_ref_prgm_pmt_mode_rec ;
509:
510: IF ( c_get_prgm_pmt_mode%NOTFOUND) THEN
511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
512: FND_MESSAGE.set_token('MODE','Update');
513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');
514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));
515: FND_MSG_PUB.add;
516: RAISE FND_API.G_EXC_ERROR;
509:
510: IF ( c_get_prgm_pmt_mode%NOTFOUND) THEN
511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
512: FND_MESSAGE.set_token('MODE','Update');
513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');
514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));
515: FND_MSG_PUB.add;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
510: IF ( c_get_prgm_pmt_mode%NOTFOUND) THEN
511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
512: FND_MESSAGE.set_token('MODE','Update');
513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');
514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));
515: FND_MSG_PUB.add;
516: RAISE FND_API.G_EXC_ERROR;
517: END IF;
518:
525:
526: If (l_tar_prgm_pmt_mode_rec.object_version_number is NULL or
527: l_tar_prgm_pmt_mode_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
528:
529: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
530: FND_MESSAGE.set_token('COLUMN','object_version_number');
531: FND_MSG_PUB.add;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
526: If (l_tar_prgm_pmt_mode_rec.object_version_number is NULL or
527: l_tar_prgm_pmt_mode_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
528:
529: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
530: FND_MESSAGE.set_token('COLUMN','object_version_number');
531: FND_MSG_PUB.add;
532: RAISE FND_API.G_EXC_ERROR;
533: END IF;
534:
535:
536:
537: -- Check Whether record has been changed by someone else
538: IF (l_tar_prgm_pmt_mode_rec.object_version_number <> l_ref_prgm_pmt_mode_rec.object_version_number) THEN
539: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
540: FND_MESSAGE.set_token('VALUE','prgm_pmt_mode');
541: FND_MSG_PUB.add;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
536:
537: -- Check Whether record has been changed by someone else
538: IF (l_tar_prgm_pmt_mode_rec.object_version_number <> l_ref_prgm_pmt_mode_rec.object_version_number) THEN
539: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
540: FND_MESSAGE.set_token('VALUE','prgm_pmt_mode');
541: FND_MSG_PUB.add;
542: RAISE FND_API.G_EXC_ERROR;
543: END IF;
544:
880:
881: IF (c_prgm_pmt_mode%NOTFOUND) THEN
882: CLOSE c_prgm_pmt_mode;
883: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
885: FND_MSG_PUB.add;
886: END IF;
887: RAISE FND_API.g_exc_error;
888: END IF;
987: 'program_payment_mode_id = ''' || p_prgm_pmt_mode_rec.program_payment_mode_id ||''''
988: );
989:
990: IF l_valid_flag = FND_API.g_false THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
992: FND_MESSAGE.set_token('ID',to_char(p_prgm_pmt_mode_rec.program_payment_mode_id) );
993: FND_MESSAGE.set_token('ENTITY','PRGM_PMT_MODE');
994: FND_MSG_PUB.add;
995: x_return_status := FND_API.g_ret_sts_error;
988: );
989:
990: IF l_valid_flag = FND_API.g_false THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
992: FND_MESSAGE.set_token('ID',to_char(p_prgm_pmt_mode_rec.program_payment_mode_id) );
993: FND_MESSAGE.set_token('ENTITY','PRGM_PMT_MODE');
994: FND_MSG_PUB.add;
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;
989:
990: IF l_valid_flag = FND_API.g_false THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
992: FND_MESSAGE.set_token('ID',to_char(p_prgm_pmt_mode_rec.program_payment_mode_id) );
993: FND_MESSAGE.set_token('ENTITY','PRGM_PMT_MODE');
994: FND_MSG_PUB.add;
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;
997: END IF;
1014: p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID||''' '
1015: );
1016:
1017: IF l_valid_flag = FND_API.g_false THEN
1018: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1019: OPEN c_payment_code(p_prgm_pmt_mode_rec.mode_of_payment);
1020: FETCH c_payment_code into l_mode_of_payment;
1021: FND_MESSAGE.set_token('ENTITY1', l_mode_of_payment);
1022: CLOSE c_payment_code;
1017: IF l_valid_flag = FND_API.g_false THEN
1018: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1019: OPEN c_payment_code(p_prgm_pmt_mode_rec.mode_of_payment);
1020: FETCH c_payment_code into l_mode_of_payment;
1021: FND_MESSAGE.set_token('ENTITY1', l_mode_of_payment);
1022: CLOSE c_payment_code;
1023:
1024: -- Get the get_area_name
1025: OPEN c_geo_area_name(p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID);
1023:
1024: -- Get the get_area_name
1025: OPEN c_geo_area_name(p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID);
1026: FETCH c_geo_area_name into l_geo_area_name, l_location_type_name;
1027: FND_MESSAGE.set_token('ENTITY2', l_location_type_name);
1028: FND_MESSAGE.set_token('ENTITY3', l_geo_area_name);
1029: CLOSE c_geo_area_name;
1030:
1031: FND_MSG_PUB.ADD;
1024: -- Get the get_area_name
1025: OPEN c_geo_area_name(p_prgm_pmt_mode_rec.GEO_HIERARCHY_ID);
1026: FETCH c_geo_area_name into l_geo_area_name, l_location_type_name;
1027: FND_MESSAGE.set_token('ENTITY2', l_location_type_name);
1028: FND_MESSAGE.set_token('ENTITY3', l_geo_area_name);
1029: CLOSE c_geo_area_name;
1030:
1031: FND_MSG_PUB.ADD;
1032: x_return_status := Fnd_Api.g_ret_sts_error;
1047: , x_location_type_name
1048: );
1049:
1050:
1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);
1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);
1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);
1055: FND_MSG_PUB.add;
1048: );
1049:
1050:
1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);
1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);
1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);
1055: FND_MSG_PUB.add;
1056:
1049:
1050:
1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);
1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);
1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);
1055: FND_MSG_PUB.add;
1056:
1057: x_return_status := FND_API.g_ret_sts_error;
1050:
1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');
1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);
1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);
1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);
1055: FND_MSG_PUB.add;
1056:
1057: x_return_status := FND_API.g_ret_sts_error;
1058: RETURN;
1079: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1080:
1081: IF p_prgm_pmt_mode_rec.program_payment_mode_id = FND_API.g_miss_num
1082: OR p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1083: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1084: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1085: FND_MSG_PUB.add;
1086: x_return_status := FND_API.g_ret_sts_error;
1087: RETURN;
1080:
1081: IF p_prgm_pmt_mode_rec.program_payment_mode_id = FND_API.g_miss_num
1082: OR p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1083: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1084: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1085: FND_MSG_PUB.add;
1086: x_return_status := FND_API.g_ret_sts_error;
1087: RETURN;
1088: END IF;
1089:
1090: /**
1091: IF p_prgm_pmt_mode_rec.program_id = FND_API.g_miss_num OR
1092: p_prgm_pmt_mode_rec.program_id IS NULL THEN
1093: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1094: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
1095: FND_MSG_PUB.add;
1096: x_return_status := FND_API.g_ret_sts_error;
1097: RETURN;
1090: /**
1091: IF p_prgm_pmt_mode_rec.program_id = FND_API.g_miss_num OR
1092: p_prgm_pmt_mode_rec.program_id IS NULL THEN
1093: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1094: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
1095: FND_MSG_PUB.add;
1096: x_return_status := FND_API.g_ret_sts_error;
1097: RETURN;
1098: END IF;
1099:
1100: */
1101: IF p_prgm_pmt_mode_rec.geo_hierarchy_id = FND_API.g_miss_num OR
1102: p_prgm_pmt_mode_rec.geo_hierarchy_id IS NULL THEN
1103: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1104: FND_MESSAGE.set_token('COLUMN','geo_hierarchy_id');
1105: FND_MSG_PUB.add;
1106: x_return_status := FND_API.g_ret_sts_error;
1107: RETURN;
1100: */
1101: IF p_prgm_pmt_mode_rec.geo_hierarchy_id = FND_API.g_miss_num OR
1102: p_prgm_pmt_mode_rec.geo_hierarchy_id IS NULL THEN
1103: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1104: FND_MESSAGE.set_token('COLUMN','geo_hierarchy_id');
1105: FND_MSG_PUB.add;
1106: x_return_status := FND_API.g_ret_sts_error;
1107: RETURN;
1108: END IF;
1109:
1110:
1111: IF p_prgm_pmt_mode_rec.mode_of_payment = FND_API.g_miss_char OR
1112: p_prgm_pmt_mode_rec.mode_of_payment IS NULL THEN
1113: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1114: FND_MESSAGE.set_token('COLUMN','MODE_OF_PAYMENT');
1115: FND_MSG_PUB.add;
1116: x_return_status := FND_API.g_ret_sts_error;
1117: RETURN;
1110:
1111: IF p_prgm_pmt_mode_rec.mode_of_payment = FND_API.g_miss_char OR
1112: p_prgm_pmt_mode_rec.mode_of_payment IS NULL THEN
1113: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1114: FND_MESSAGE.set_token('COLUMN','MODE_OF_PAYMENT');
1115: FND_MSG_PUB.add;
1116: x_return_status := FND_API.g_ret_sts_error;
1117: RETURN;
1118: END IF;
1118: END IF;
1119:
1120: IF p_prgm_pmt_mode_rec.mode_type = FND_API.g_miss_char OR
1121: p_prgm_pmt_mode_rec.mode_type IS NULL THEN
1122: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1123: FND_MESSAGE.set_token('COLUMN','mode_type');
1124: FND_MSG_PUB.add;
1125: x_return_status := FND_API.g_ret_sts_error;
1126: RETURN;
1119:
1120: IF p_prgm_pmt_mode_rec.mode_type = FND_API.g_miss_char OR
1121: p_prgm_pmt_mode_rec.mode_type IS NULL THEN
1122: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1123: FND_MESSAGE.set_token('COLUMN','mode_type');
1124: FND_MSG_PUB.add;
1125: x_return_status := FND_API.g_ret_sts_error;
1126: RETURN;
1127: END IF;
1127: END IF;
1128:
1129: IF p_prgm_pmt_mode_rec.last_update_date = FND_API.g_miss_date OR
1130: p_prgm_pmt_mode_rec.last_update_date IS NULL THEN
1131: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
1133: FND_MSG_PUB.add;
1134: x_return_status := FND_API.g_ret_sts_error;
1135: RETURN;
1128:
1129: IF p_prgm_pmt_mode_rec.last_update_date = FND_API.g_miss_date OR
1130: p_prgm_pmt_mode_rec.last_update_date IS NULL THEN
1131: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
1133: FND_MSG_PUB.add;
1134: x_return_status := FND_API.g_ret_sts_error;
1135: RETURN;
1136: END IF;
1137:
1138:
1139: IF p_prgm_pmt_mode_rec.last_updated_by = FND_API.g_miss_num OR
1140: p_prgm_pmt_mode_rec.last_updated_by IS NULL THEN
1141: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1142: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
1143: FND_MSG_PUB.add;
1144: x_return_status := FND_API.g_ret_sts_error;
1145: RETURN;
1138:
1139: IF p_prgm_pmt_mode_rec.last_updated_by = FND_API.g_miss_num OR
1140: p_prgm_pmt_mode_rec.last_updated_by IS NULL THEN
1141: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1142: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
1143: FND_MSG_PUB.add;
1144: x_return_status := FND_API.g_ret_sts_error;
1145: RETURN;
1146: END IF;
1147:
1148:
1149: IF p_prgm_pmt_mode_rec.creation_date = FND_API.g_miss_date OR
1150: p_prgm_pmt_mode_rec.creation_date IS NULL THEN
1151: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1152: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
1153: FND_MSG_PUB.add;
1154: x_return_status := FND_API.g_ret_sts_error;
1155: RETURN;
1148:
1149: IF p_prgm_pmt_mode_rec.creation_date = FND_API.g_miss_date OR
1150: p_prgm_pmt_mode_rec.creation_date IS NULL THEN
1151: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1152: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
1153: FND_MSG_PUB.add;
1154: x_return_status := FND_API.g_ret_sts_error;
1155: RETURN;
1156: END IF;
1162: END IF;
1163:
1164: IF p_prgm_pmt_mode_rec.created_by = FND_API.g_miss_num OR
1165: p_prgm_pmt_mode_rec.created_by IS NULL THEN
1166: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1167: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
1168: FND_MSG_PUB.add;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: RETURN;
1163:
1164: IF p_prgm_pmt_mode_rec.created_by = FND_API.g_miss_num OR
1165: p_prgm_pmt_mode_rec.created_by IS NULL THEN
1166: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1167: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
1168: FND_MSG_PUB.add;
1169: x_return_status := FND_API.g_ret_sts_error;
1170: RETURN;
1171: END IF;
1172:
1173:
1174: IF p_prgm_pmt_mode_rec.last_update_login = FND_API.g_miss_num OR
1175: p_prgm_pmt_mode_rec.last_update_login IS NULL THEN
1176: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1177: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
1178: FND_MSG_PUB.add;
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;
1173:
1174: IF p_prgm_pmt_mode_rec.last_update_login = FND_API.g_miss_num OR
1175: p_prgm_pmt_mode_rec.last_update_login IS NULL THEN
1176: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1177: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
1178: FND_MSG_PUB.add;
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;
1181: END IF;
1182:
1183:
1184: IF p_prgm_pmt_mode_rec.object_version_number = FND_API.g_miss_num OR
1185: p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1186: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1188: FND_MSG_PUB.add;
1189: x_return_status := FND_API.g_ret_sts_error;
1190: RETURN;
1183:
1184: IF p_prgm_pmt_mode_rec.object_version_number = FND_API.g_miss_num OR
1185: p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1186: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1188: FND_MSG_PUB.add;
1189: x_return_status := FND_API.g_ret_sts_error;
1190: RETURN;
1191: END IF;
1191: END IF;
1192: ELSE
1193:
1194: IF p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1195: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1196: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1197: FND_MSG_PUB.add;
1198: x_return_status := FND_API.g_ret_sts_error;
1199: RETURN;
1192: ELSE
1193:
1194: IF p_prgm_pmt_mode_rec.program_payment_mode_id IS NULL THEN
1195: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1196: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');
1197: FND_MSG_PUB.add;
1198: x_return_status := FND_API.g_ret_sts_error;
1199: RETURN;
1200: END IF;
1199: RETURN;
1200: END IF;
1201:
1202: IF p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1203: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1204: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1205: FND_MSG_PUB.add;
1206: x_return_status := FND_API.g_ret_sts_error;
1207: RETURN;
1200: END IF;
1201:
1202: IF p_prgm_pmt_mode_rec.object_version_number IS NULL THEN
1203: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1204: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1205: FND_MSG_PUB.add;
1206: x_return_status := FND_API.g_ret_sts_error;
1207: RETURN;
1208: END IF;
1242: ) = FND_API.g_false
1243: THEN
1244: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1245: THEN
1246: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
1247: FND_MSG_PUB.add;
1248: END IF;
1249:
1250: x_return_status := FND_API.g_ret_sts_error;
1279: ) = FND_API.g_false
1280: THEN
1281: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1282: THEN
1283: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');
1284: FND_MSG_PUB.add;
1285: END IF;
1286:
1287: x_return_status := FND_API.g_ret_sts_error;
1310: ) = FND_API.g_false
1311: THEN
1312: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1313: THEN
1314: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_MODE_TYPE');
1315: FND_MSG_PUB.add;
1316: END IF;
1317: x_return_status := FND_API.g_ret_sts_error;
1318: RETURN;