DBA Data[Home] [Help]

APPS.PV_PRGM_PMT_MODE_PVT dependencies on FND_MESSAGE

Line 79: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

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

Line 80: FND_MESSAGE.set_token('MODE','find');

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);

Line 81: FND_MESSAGE.set_token('ENTITY','Payment Method Meaning');

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;

Line 82: FND_MESSAGE.set_token('ID','Payment Method: '||p_program_payment_mode

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

Line 135: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

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;

Line 136: FND_MESSAGE.set_token('MODE','');

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

Line 137: FND_MESSAGE.set_token('ENTITY','GET_pmnt_method_PVT');

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:

Line 138: FND_MESSAGE.set_token('ID','No Data found in c_get_geo_hierarchy');

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');

Line 249: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');

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:

Line 511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');

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;

Line 512: FND_MESSAGE.set_token('MODE','Update');

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;

Line 513: FND_MESSAGE.set_token('ENTITY','prgm_pmt_mode');

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;

Line 514: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_pmt_mode_rec.program_payment_mode_id));

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:

Line 529: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');

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;

Line 530: FND_MESSAGE.set_token('COLUMN','object_version_number');

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:

Line 539: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');

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;

Line 540: FND_MESSAGE.set_token('VALUE','prgm_pmt_mode');

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:

Line 884: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

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;

Line 991: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

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;

Line 992: FND_MESSAGE.set_token('ID',to_char(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;
996: RETURN;

Line 993: FND_MESSAGE.set_token('ENTITY','PRGM_PMT_MODE');

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;

Line 1018: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');

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;

Line 1021: FND_MESSAGE.set_token('ENTITY1', l_mode_of_payment);

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);

Line 1027: FND_MESSAGE.set_token('ENTITY2', l_location_type_name);

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;

Line 1028: FND_MESSAGE.set_token('ENTITY3', l_geo_area_name);

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;

Line 1051: FND_MESSAGE.set_name('PV', 'PV_PMNT_MODE_DUPLICATE_ENTITY');

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;

Line 1052: FND_MESSAGE.set_token('ENTITY1',x_pmt_mode_desc);

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:

Line 1053: FND_MESSAGE.set_token('ENTITY2',x_location_type_name);

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;

Line 1054: FND_MESSAGE.set_token('ENTITY3',x_geo_area_name);

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;

Line 1083: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1084: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');

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;

Line 1093: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1094: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');

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;

Line 1103: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1104: FND_MESSAGE.set_token('COLUMN','geo_hierarchy_id');

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;

Line 1113: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1114: FND_MESSAGE.set_token('COLUMN','MODE_OF_PAYMENT');

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;

Line 1122: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1123: FND_MESSAGE.set_token('COLUMN','mode_type');

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;

Line 1131: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1132: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');

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;

Line 1141: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1142: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');

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;

Line 1151: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1152: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');

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;

Line 1166: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1167: FND_MESSAGE.set_token('COLUMN','CREATED_BY');

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;

Line 1176: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1177: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');

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;

Line 1186: FND_MESSAGE.set_name('PV','PV_API_MISSING_REQ_COLUMN');

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;

Line 1187: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

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;

Line 1195: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;

Line 1196: FND_MESSAGE.set_token('COLUMN','PROGRAM_PAYMENT_MODE_ID');

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;

Line 1203: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

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;

Line 1204: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');

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;

Line 1246: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');

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;

Line 1283: FND_MESSAGE.set_name('PV', 'PV_NOT_A_GEO_HIERARCHY');

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;

Line 1314: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_MODE_TYPE');

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;