DBA Data[Home] [Help]

APPS.PV_PRGM_BENEFITS_PVT dependencies on FND_MESSAGE

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

107:
108: END IF;
109:
110: IF FND_GLOBAL.User_Id IS NULL THEN
111: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
112: FND_MSG_PUB.add;
113: RAISE FND_API.G_EXC_ERROR;
114: END IF;
115:

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

326: OPEN c_get_Prgm_Benefits( l_tar_prgm_benefits_rec.program_benefits_id);
327: FETCH c_get_Prgm_Benefits INTO l_ref_prgm_benefits_rec ;
328:
329: IF ( c_get_Prgm_Benefits%NOTFOUND) THEN
330: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
331: FND_MESSAGE.set_token('MODE','Update');
332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');
333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));
334: FND_MSG_PUB.ADD;

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

327: FETCH c_get_Prgm_Benefits INTO l_ref_prgm_benefits_rec ;
328:
329: IF ( c_get_Prgm_Benefits%NOTFOUND) THEN
330: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
331: FND_MESSAGE.set_token('MODE','Update');
332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');
333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));
334: FND_MSG_PUB.ADD;
335: RAISE FND_API.G_EXC_ERROR;

Line 332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');

328:
329: IF ( c_get_Prgm_Benefits%NOTFOUND) THEN
330: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
331: FND_MESSAGE.set_token('MODE','Update');
332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');
333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));
334: FND_MSG_PUB.ADD;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;

Line 333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));

329: IF ( c_get_Prgm_Benefits%NOTFOUND) THEN
330: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
331: FND_MESSAGE.set_token('MODE','Update');
332: FND_MESSAGE.set_token('ENTITY','Program_Benefits');
333: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_prgm_benefits_rec.program_benefits_id));
334: FND_MSG_PUB.ADD;
335: RAISE FND_API.G_EXC_ERROR;
336: END IF;
337:

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

344:
345: If (l_tar_prgm_benefits_rec.object_version_number is NULL or
346: l_tar_prgm_benefits_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
347:
348: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
349: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;

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

345: If (l_tar_prgm_benefits_rec.object_version_number is NULL or
346: l_tar_prgm_benefits_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
347:
348: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
349: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
350: FND_MSG_PUB.add;
351: RAISE FND_API.G_EXC_ERROR;
352: END IF;
353:

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

352: END IF;
353:
354: -- Check Whether record has been changed by someone else
355: IF (l_tar_prgm_benefits_rec.object_version_number <> l_ref_prgm_benefits_rec.object_version_number) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
357: FND_MESSAGE.set_token('VALUE','PROGRAM_BENEFITS');
358: FND_MSG_PUB.ADD;
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;

Line 357: FND_MESSAGE.set_token('VALUE','PROGRAM_BENEFITS');

353:
354: -- Check Whether record has been changed by someone else
355: IF (l_tar_prgm_benefits_rec.object_version_number <> l_ref_prgm_benefits_rec.object_version_number) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
357: FND_MESSAGE.set_token('VALUE','PROGRAM_BENEFITS');
358: FND_MSG_PUB.ADD;
359: RAISE FND_API.G_EXC_ERROR;
360: END IF;
361:

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

657:
658: IF (c_Prgm_Benefits%NOTFOUND) THEN
659: CLOSE c_Prgm_Benefits;
660: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
661: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
662: FND_MSG_PUB.add;
663: END IF;
664: RAISE FND_API.g_exc_error;
665: END IF;

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

742: 'program_benefits_id = ''' || p_prgm_benefits_rec.program_benefits_id ||''''
743: );
744:
745: IF l_valid_flag = FND_API.g_false THEN
746: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
747: FND_MESSAGE.set_token('ID',to_char(p_prgm_benefits_rec.program_benefits_id) );
748: FND_MESSAGE.set_token('ENTITY','PARTNER_BENEFITS');
749: FND_MSG_PUB.add;
750: x_return_status := FND_API.g_ret_sts_error;

Line 747: FND_MESSAGE.set_token('ID',to_char(p_prgm_benefits_rec.program_benefits_id) );

743: );
744:
745: IF l_valid_flag = FND_API.g_false THEN
746: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
747: FND_MESSAGE.set_token('ID',to_char(p_prgm_benefits_rec.program_benefits_id) );
748: FND_MESSAGE.set_token('ENTITY','PARTNER_BENEFITS');
749: FND_MSG_PUB.add;
750: x_return_status := FND_API.g_ret_sts_error;
751: RETURN;

Line 748: FND_MESSAGE.set_token('ENTITY','PARTNER_BENEFITS');

744:
745: IF l_valid_flag = FND_API.g_false THEN
746: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
747: FND_MESSAGE.set_token('ID',to_char(p_prgm_benefits_rec.program_benefits_id) );
748: FND_MESSAGE.set_token('ENTITY','PARTNER_BENEFITS');
749: FND_MSG_PUB.add;
750: x_return_status := FND_API.g_ret_sts_error;
751: RETURN;
752: END IF;

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

776: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
777:
778: IF p_prgm_benefits_rec.program_benefits_id = FND_API.g_miss_num
779: OR p_prgm_benefits_rec.program_benefits_id IS NULL THEN
780: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
781: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
782: FND_MSG_PUB.add;
783: x_return_status := FND_API.g_ret_sts_error;
784: RETURN;

Line 781: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');

777:
778: IF p_prgm_benefits_rec.program_benefits_id = FND_API.g_miss_num
779: OR p_prgm_benefits_rec.program_benefits_id IS NULL THEN
780: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
781: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
782: FND_MSG_PUB.add;
783: x_return_status := FND_API.g_ret_sts_error;
784: RETURN;
785: END IF;

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

786:
787:
788: IF p_prgm_benefits_rec.program_id = FND_API.g_miss_num
789: OR p_prgm_benefits_rec.program_id IS NULL THEN
790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
791: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
792: FND_MSG_PUB.add;
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;

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

787:
788: IF p_prgm_benefits_rec.program_id = FND_API.g_miss_num
789: OR p_prgm_benefits_rec.program_id IS NULL THEN
790: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
791: FND_MESSAGE.set_token('COLUMN','PROGRAM_ID');
792: FND_MSG_PUB.add;
793: x_return_status := FND_API.g_ret_sts_error;
794: RETURN;
795: END IF;

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

796:
797: /*
798: IF p_prgm_benefits_rec.benefit_code = FND_API.g_miss_char
799: OR p_prgm_benefits_rec.benefit_code IS NULL THEN
800: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
801: FND_MESSAGE.set_token('COLUMN','BENEFIT_CODE');
802: FND_MSG_PUB.add;
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;

Line 801: FND_MESSAGE.set_token('COLUMN','BENEFIT_CODE');

797: /*
798: IF p_prgm_benefits_rec.benefit_code = FND_API.g_miss_char
799: OR p_prgm_benefits_rec.benefit_code IS NULL THEN
800: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
801: FND_MESSAGE.set_token('COLUMN','BENEFIT_CODE');
802: FND_MSG_PUB.add;
803: x_return_status := FND_API.g_ret_sts_error;
804: RETURN;
805: END IF;

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

806: */
807:
808: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
809: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
811: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
812: FND_MSG_PUB.add;
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;

Line 811: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');

807:
808: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
809: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
810: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
811: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
812: FND_MSG_PUB.add;
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
815: END IF;

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

816:
817:
818: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
819: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
822: FND_MSG_PUB.add;
823: x_return_status := FND_API.g_ret_sts_error;
824: RETURN;

Line 821: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');

817:
818: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
819: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
822: FND_MSG_PUB.add;
823: x_return_status := FND_API.g_ret_sts_error;
824: RETURN;
825: END IF;

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

826:
827:
828: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
829: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
830: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
831: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
832: FND_MSG_PUB.add;
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;

Line 831: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');

827:
828: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
829: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
830: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
831: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
832: FND_MSG_PUB.add;
833: x_return_status := FND_API.g_ret_sts_error;
834: RETURN;
835: END IF;

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

836:
837:
838: IF p_prgm_benefits_rec.last_update_login = FND_API.g_miss_num
839: OR p_prgm_benefits_rec.last_update_login IS NULL THEN
840: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
841: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
842: FND_MSG_PUB.add;
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;

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

837:
838: IF p_prgm_benefits_rec.last_update_login = FND_API.g_miss_num
839: OR p_prgm_benefits_rec.last_update_login IS NULL THEN
840: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
841: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
842: FND_MSG_PUB.add;
843: x_return_status := FND_API.g_ret_sts_error;
844: RETURN;
845: END IF;

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

846:
847:
848: IF p_prgm_benefits_rec.object_version_number = FND_API.g_miss_num
849: OR p_prgm_benefits_rec.object_version_number IS NULL THEN
850: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
851: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
852: FND_MSG_PUB.add;
853: x_return_status := FND_API.g_ret_sts_error;
854: RETURN;

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

847:
848: IF p_prgm_benefits_rec.object_version_number = FND_API.g_miss_num
849: OR p_prgm_benefits_rec.object_version_number IS NULL THEN
850: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
851: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
852: FND_MSG_PUB.add;
853: x_return_status := FND_API.g_ret_sts_error;
854: RETURN;
855: END IF;

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

856:
857:
858: IF p_prgm_benefits_rec.last_update_date = FND_API.g_miss_date
859: OR p_prgm_benefits_rec.last_update_date IS NULL THEN
860: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
861: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;

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

857:
858: IF p_prgm_benefits_rec.last_update_date = FND_API.g_miss_date
859: OR p_prgm_benefits_rec.last_update_date IS NULL THEN
860: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
861: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;

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

866:
867:
868: IF p_prgm_benefits_rec.last_updated_by = FND_API.g_miss_num
869: OR p_prgm_benefits_rec.last_updated_by IS NULL THEN
870: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
871: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
872: FND_MSG_PUB.add;
873: x_return_status := FND_API.g_ret_sts_error;
874: RETURN;

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

867:
868: IF p_prgm_benefits_rec.last_updated_by = FND_API.g_miss_num
869: OR p_prgm_benefits_rec.last_updated_by IS NULL THEN
870: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
871: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
872: FND_MSG_PUB.add;
873: x_return_status := FND_API.g_ret_sts_error;
874: RETURN;
875: END IF;

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

881: END IF;
882:
883: IF p_prgm_benefits_rec.created_by = FND_API.g_miss_num
884: OR p_prgm_benefits_rec.created_by IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
887: FND_MSG_PUB.add;
888: x_return_status := FND_API.g_ret_sts_error;
889: RETURN;

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

882:
883: IF p_prgm_benefits_rec.created_by = FND_API.g_miss_num
884: OR p_prgm_benefits_rec.created_by IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
887: FND_MSG_PUB.add;
888: x_return_status := FND_API.g_ret_sts_error;
889: RETURN;
890: END IF;

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

891:
892:
893: IF p_prgm_benefits_rec.creation_date = FND_API.g_miss_date
894: OR p_prgm_benefits_rec.creation_date IS NULL THEN
895: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
896: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
897: FND_MSG_PUB.add;
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;

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

892:
893: IF p_prgm_benefits_rec.creation_date = FND_API.g_miss_date
894: OR p_prgm_benefits_rec.creation_date IS NULL THEN
895: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
896: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
897: FND_MSG_PUB.add;
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;
900: END IF;

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

900: END IF;
901: ELSE
902:
903: IF p_prgm_benefits_rec.program_benefits_id IS NULL THEN
904: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
905: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
906: FND_MSG_PUB.add;
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;

Line 905: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');

901: ELSE
902:
903: IF p_prgm_benefits_rec.program_benefits_id IS NULL THEN
904: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
905: FND_MESSAGE.set_token('COLUMN','PROGRAM_BENEFITS_ID');
906: FND_MSG_PUB.add;
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
909: END IF;

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

909: END IF;
910:
911: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
912: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
913: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
914: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
915: FND_MSG_PUB.add;
916: x_return_status := FND_API.g_ret_sts_error;
917: RETURN;

Line 914: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');

910:
911: IF p_prgm_benefits_rec.benefit_id = FND_API.g_miss_num
912: OR p_prgm_benefits_rec.benefit_id IS NULL THEN
913: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
914: FND_MESSAGE.set_token('COLUMN','BENEFIT_ID');
915: FND_MSG_PUB.add;
916: x_return_status := FND_API.g_ret_sts_error;
917: RETURN;
918: END IF;

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

919:
920:
921: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
922: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
923: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
924: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
925: FND_MSG_PUB.add;
926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;

Line 924: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');

920:
921: IF p_prgm_benefits_rec.benefit_type_code = FND_API.g_miss_char
922: OR p_prgm_benefits_rec.benefit_type_code IS NULL THEN
923: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
924: FND_MESSAGE.set_token('COLUMN','BENEFIT_TYPE_CODE');
925: FND_MSG_PUB.add;
926: x_return_status := FND_API.g_ret_sts_error;
927: RETURN;
928: END IF;

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

929:
930:
931: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
932: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
933: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
934: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
935: FND_MSG_PUB.add;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;

Line 934: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');

930:
931: IF p_prgm_benefits_rec.delete_flag = FND_API.g_miss_char
932: OR p_prgm_benefits_rec.delete_flag IS NULL THEN
933: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
934: FND_MESSAGE.set_token('COLUMN','DELETE_FLAG');
935: FND_MSG_PUB.add;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;
938: END IF;

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

938: END IF;
939:
940:
941: IF p_prgm_benefits_rec.object_version_number IS NULL THEN
942: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
943: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
944: FND_MSG_PUB.add;
945: x_return_status := FND_API.g_ret_sts_error;
946: RETURN;

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

939:
940:
941: IF p_prgm_benefits_rec.object_version_number IS NULL THEN
942: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
943: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
944: FND_MSG_PUB.add;
945: x_return_status := FND_API.g_ret_sts_error;
946: RETURN;
947: END IF;

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

980: ) = FND_API.g_false
981: THEN
982: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
983: THEN
984: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PARTNER_PROGRAM');
985: FND_MSG_PUB.add;
986: END IF;
987:
988: x_return_status := FND_API.g_ret_sts_error;

Line 1026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_BENEFIT');

1022: ) = FND_API.g_false
1023: THEN
1024: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1025: THEN
1026: FND_MESSAGE.set_name('PV', 'PV_NOT_A_VALID_PROGRAM_BENEFIT');
1027: FND_MSG_PUB.add;
1028: END IF;
1029: x_return_status := FND_API.g_ret_sts_error;
1030: RETURN;