DBA Data[Home] [Help]

APPS.PV_PARTNER_PGM_TYPE_PVT dependencies on FND_MESSAGE

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

114:
115: --------------- validate -------------------------
116:
117: IF FND_GLOBAL.User_Id IS NULL THEN
118: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
119: FND_MSG_PUB.add;
120: RAISE FND_API.G_EXC_ERROR;
121: END IF;
122:

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

353: OPEN c_get_Partner_Pgm_Type(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID);
354: FETCH c_get_Partner_Pgm_Type INTO l_ref_ptr_prgm_type_rec ;
355:
356: IF (c_get_Partner_Pgm_Type%NOTFOUND) THEN
357: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
358: FND_MESSAGE.set_token('MODE','Update');
359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');
360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
361: FND_MSG_PUB.add;

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

354: FETCH c_get_Partner_Pgm_Type INTO l_ref_ptr_prgm_type_rec ;
355:
356: IF (c_get_Partner_Pgm_Type%NOTFOUND) THEN
357: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
358: FND_MESSAGE.set_token('MODE','Update');
359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');
360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
361: FND_MSG_PUB.add;
362: RAISE FND_API.G_EXC_ERROR;

Line 359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');

355:
356: IF (c_get_Partner_Pgm_Type%NOTFOUND) THEN
357: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
358: FND_MESSAGE.set_token('MODE','Update');
359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');
360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
361: FND_MSG_PUB.add;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;

Line 360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));

356: IF (c_get_Partner_Pgm_Type%NOTFOUND) THEN
357: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
358: FND_MESSAGE.set_token('MODE','Update');
359: FND_MESSAGE.set_token('ENTITY','Partner_Pgm_Type');
360: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
361: FND_MSG_PUB.add;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364:

Line 370: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ID');

366:
367: IF (l_tar_ptr_prgm_type_rec.object_version_number IS NULL OR
368: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
369:
370: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ID');
371: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
372: FND_MSG_PUB.add;
373: RAISE FND_API.G_EXC_ERROR;
374: End if;

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

367: IF (l_tar_ptr_prgm_type_rec.object_version_number IS NULL OR
368: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
369:
370: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ID');
371: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
372: FND_MSG_PUB.add;
373: RAISE FND_API.G_EXC_ERROR;
374: End if;
375:

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

374: End if;
375:
376: -- Check Whether record has been changed by someone else
377: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
378: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
379: FND_MESSAGE.set_token('VALUE','ptr_prgm_type');
380: FND_MSG_PUB.add;
381: RAISE FND_API.G_EXC_ERROR;
382: End if;

Line 379: FND_MESSAGE.set_token('VALUE','ptr_prgm_type');

375:
376: -- Check Whether record has been changed by someone else
377: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
378: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
379: FND_MESSAGE.set_token('VALUE','ptr_prgm_type');
380: FND_MSG_PUB.add;
381: RAISE FND_API.G_EXC_ERROR;
382: End if;
383:

Line 423: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_INACTIVE');

419: IF (l_tar_ptr_prgm_type_rec.active_flag <> FND_API.g_miss_char and
420: l_tar_ptr_prgm_type_rec.active_flag = 'N' and
421: l_tar_ptr_prgm_type_rec.active_flag <> l_ref_ptr_prgm_type_rec.active_flag) THEN
422: IF NOT Can_Be_Inactive(l_tar_ptr_prgm_type_rec.program_type_id) THEN
423: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_INACTIVE');
424: FND_MSG_PUB.add;
425: RAISE FND_API.G_EXC_ERROR;
426: END IF;
427: END IF;

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

577: END IF;
578: IF (p_object_version_number is NULL or
579: p_object_version_number = FND_API.G_MISS_NUM ) THEN
580:
581: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
582: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
583: FND_MSG_PUB.add;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;

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

578: IF (p_object_version_number is NULL or
579: p_object_version_number = FND_API.G_MISS_NUM ) THEN
580:
581: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
582: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
583: FND_MSG_PUB.add;
584: RAISE FND_API.G_EXC_ERROR;
585: END IF;
586:

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

593: OPEN c_get_ptr_prgm_type_rec(p_PROGRAM_TYPE_ID);
594: FETCH c_get_ptr_prgm_type_rec INTO l_ref_ptr_prgm_type_rec ;
595:
596: IF ( c_get_ptr_prgm_type_rec%NOTFOUND) THEN
597: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
598: FND_MESSAGE.set_token('MODE','Update');
599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');
600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
601: FND_MSG_PUB.add;

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

594: FETCH c_get_ptr_prgm_type_rec INTO l_ref_ptr_prgm_type_rec ;
595:
596: IF ( c_get_ptr_prgm_type_rec%NOTFOUND) THEN
597: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
598: FND_MESSAGE.set_token('MODE','Update');
599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');
600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
601: FND_MSG_PUB.add;
602: RAISE FND_API.G_EXC_ERROR;

Line 599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');

595:
596: IF ( c_get_ptr_prgm_type_rec%NOTFOUND) THEN
597: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
598: FND_MESSAGE.set_token('MODE','Update');
599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');
600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
601: FND_MSG_PUB.add;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;

Line 600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));

596: IF ( c_get_ptr_prgm_type_rec%NOTFOUND) THEN
597: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
598: FND_MESSAGE.set_token('MODE','Update');
599: FND_MESSAGE.set_token('ENTITY','Partner_Program_Type');
600: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_ptr_prgm_type_rec.PROGRAM_TYPE_ID));
601: FND_MSG_PUB.add;
602: RAISE FND_API.G_EXC_ERROR;
603: END IF;
604:

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

611:
612: IF (l_tar_ptr_prgm_type_rec.object_version_number is NULL or
613: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
614:
615: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
616: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
617: FND_MSG_PUB.add;
618: raise FND_API.G_EXC_ERROR;
619: End if;

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

612: IF (l_tar_ptr_prgm_type_rec.object_version_number is NULL or
613: l_tar_ptr_prgm_type_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
614:
615: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
616: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
617: FND_MSG_PUB.add;
618: raise FND_API.G_EXC_ERROR;
619: End if;
620:

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

619: End if;
620:
621: -- Check Whether record has been changed by someone else
622: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
623: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
624: FND_MESSAGE.set_token('VALUE','Partner_Program_Type');
625: FND_MSG_PUB.add;
626: raise FND_API.G_EXC_ERROR;
627: End if;

Line 624: FND_MESSAGE.set_token('VALUE','Partner_Program_Type');

620:
621: -- Check Whether record has been changed by someone else
622: If (l_tar_ptr_prgm_type_rec.object_version_number <> l_ref_ptr_prgm_type_rec.object_version_number) THEN
623: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
624: FND_MESSAGE.set_token('VALUE','Partner_Program_Type');
625: FND_MSG_PUB.add;
626: raise FND_API.G_EXC_ERROR;
627: End if;
628:

Line 631: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_DELETE');

627: End if;
628:
629: -- Check whether this program type can be deleted
630: IF NOT Can_Be_Deleted(p_PROGRAM_TYPE_ID) THEN
631: FND_MESSAGE.set_name('PV', 'PV_PRGM_TYPE_CAN_NOT_DELETE');
632: FND_MSG_PUB.add;
633: RAISE FND_API.G_EXC_ERROR;
634: END IF;
635:

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

767:
768: IF (c_Partner_Pgm_Type%NOTFOUND) THEN
769: CLOSE c_Partner_Pgm_Type;
770: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
771: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
772: FND_MSG_PUB.add;
773: END IF;
774: RAISE FND_API.g_exc_error;
775: END IF;

Line 859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');

855: PVX_UTILITY_PVT.debug_message('- In Check_UK_Items API after PROGRAM_TYPE_ID check' );
856: END IF;
857:
858: IF l_valid_flag = FND_API.g_false THEN
859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');
860: FND_MESSAGE.set_token('ID',to_char( p_ptr_prgm_type_rec.PROGRAM_TYPE_ID) );
861: FND_MESSAGE.set_token('ENTITY','ptr_prgm_type');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;

Line 860: FND_MESSAGE.set_token('ID',to_char( p_ptr_prgm_type_rec.PROGRAM_TYPE_ID) );

856: END IF;
857:
858: IF l_valid_flag = FND_API.g_false THEN
859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');
860: FND_MESSAGE.set_token('ID',to_char( p_ptr_prgm_type_rec.PROGRAM_TYPE_ID) );
861: FND_MESSAGE.set_token('ENTITY','ptr_prgm_type');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;

Line 861: FND_MESSAGE.set_token('ENTITY','ptr_prgm_type');

857:
858: IF l_valid_flag = FND_API.g_false THEN
859: FND_MESSAGE.set_name('PVX', 'PV_API_DUPLICATE_ENTITY');
860: FND_MESSAGE.set_token('ID',to_char( p_ptr_prgm_type_rec.PROGRAM_TYPE_ID) );
861: FND_MESSAGE.set_token('ENTITY','ptr_prgm_type');
862: FND_MSG_PUB.add;
863: x_return_status := FND_API.g_ret_sts_error;
864: RETURN;
865: END IF;

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

881: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
882:
883: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
884: OR p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
887: FND_MSG_PUB.add;
888: x_return_status := FND_API.g_ret_sts_error;
889: RETURN;

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

882:
883: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID = FND_API.g_miss_num
884: OR p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
885: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
886: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
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_ptr_prgm_type_rec.active_flag = FND_API.g_miss_char
894: OR p_ptr_prgm_type_rec.active_flag IS NULL THEN
895: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
896: FND_MESSAGE.set_token('COLUMN','ACTIVE_FLAG');
897: FND_MSG_PUB.add;
898: x_return_status := FND_API.g_ret_sts_error;
899: RETURN;

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

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

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

901:
902:
903: IF p_ptr_prgm_type_rec.enabled_flag = FND_API.g_miss_char
904: OR p_ptr_prgm_type_rec.enabled_flag IS NULL THEN
905: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
906: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');
907: FND_MSG_PUB.add;
908: x_return_status := FND_API.g_ret_sts_error;
909: RETURN;

Line 906: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');

902:
903: IF p_ptr_prgm_type_rec.enabled_flag = FND_API.g_miss_char
904: OR p_ptr_prgm_type_rec.enabled_flag IS NULL THEN
905: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
906: FND_MESSAGE.set_token('COLUMN','ENABLED_FLAG');
907: FND_MSG_PUB.add;
908: x_return_status := FND_API.g_ret_sts_error;
909: RETURN;
910: END IF;

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

911:
912:
913: IF p_ptr_prgm_type_rec.program_type_name = FND_API.g_miss_char
914: OR p_ptr_prgm_type_rec.program_type_name IS NULL THEN
915: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
916: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_NAME');
917: FND_MSG_PUB.add;
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;

Line 916: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_NAME');

912:
913: IF p_ptr_prgm_type_rec.program_type_name = FND_API.g_miss_char
914: OR p_ptr_prgm_type_rec.program_type_name IS NULL THEN
915: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
916: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_NAME');
917: FND_MSG_PUB.add;
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
920: END IF;

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

921:
922:
923: IF p_ptr_prgm_type_rec.object_version_number = FND_API.g_miss_num
924: OR p_ptr_prgm_type_rec.object_version_number IS NULL THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
927: FND_MSG_PUB.add;
928: x_return_status := FND_API.g_ret_sts_error;
929: RETURN;

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

922:
923: IF p_ptr_prgm_type_rec.object_version_number = FND_API.g_miss_num
924: OR p_ptr_prgm_type_rec.object_version_number IS NULL THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
927: FND_MSG_PUB.add;
928: x_return_status := FND_API.g_ret_sts_error;
929: RETURN;
930: END IF;

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

931:
932:
933: IF p_ptr_prgm_type_rec.creation_date = FND_API.g_miss_date
934: OR p_ptr_prgm_type_rec.creation_date IS NULL THEN
935: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
936: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
937: FND_MSG_PUB.add;
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;

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

932:
933: IF p_ptr_prgm_type_rec.creation_date = FND_API.g_miss_date
934: OR p_ptr_prgm_type_rec.creation_date IS NULL THEN
935: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
936: FND_MESSAGE.set_token('COLUMN','CREATION_DATE');
937: FND_MSG_PUB.add;
938: x_return_status := FND_API.g_ret_sts_error;
939: RETURN;
940: END IF;

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

947:
948:
949: IF p_ptr_prgm_type_rec.created_by = FND_API.g_miss_num
950: OR p_ptr_prgm_type_rec.created_by IS NULL THEN
951: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
952: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
953: FND_MSG_PUB.add;
954: x_return_status := FND_API.g_ret_sts_error;
955: RETURN;

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

948:
949: IF p_ptr_prgm_type_rec.created_by = FND_API.g_miss_num
950: OR p_ptr_prgm_type_rec.created_by IS NULL THEN
951: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
952: FND_MESSAGE.set_token('COLUMN','CREATED_BY');
953: FND_MSG_PUB.add;
954: x_return_status := FND_API.g_ret_sts_error;
955: RETURN;
956: END IF;

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

957:
958:
959: IF p_ptr_prgm_type_rec.last_update_date = FND_API.g_miss_date
960: OR p_ptr_prgm_type_rec.last_update_date IS NULL THEN
961: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
962: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
963: FND_MSG_PUB.add;
964: x_return_status := FND_API.g_ret_sts_error;
965: RETURN;

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

958:
959: IF p_ptr_prgm_type_rec.last_update_date = FND_API.g_miss_date
960: OR p_ptr_prgm_type_rec.last_update_date IS NULL THEN
961: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
962: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_DATE');
963: FND_MSG_PUB.add;
964: x_return_status := FND_API.g_ret_sts_error;
965: RETURN;
966: END IF;

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

967:
968:
969: IF p_ptr_prgm_type_rec.last_updated_by = FND_API.g_miss_num
970: OR p_ptr_prgm_type_rec.last_updated_by IS NULL THEN
971: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
972: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
973: FND_MSG_PUB.add;
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;

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

968:
969: IF p_ptr_prgm_type_rec.last_updated_by = FND_API.g_miss_num
970: OR p_ptr_prgm_type_rec.last_updated_by IS NULL THEN
971: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
972: FND_MESSAGE.set_token('COLUMN','LAST_UPDATED_BY');
973: FND_MSG_PUB.add;
974: x_return_status := FND_API.g_ret_sts_error;
975: RETURN;
976: END IF;

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

977:
978:
979: IF p_ptr_prgm_type_rec.last_update_login = FND_API.g_miss_num
980: OR p_ptr_prgm_type_rec.last_update_login IS NULL THEN
981: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
982: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
983: FND_MSG_PUB.add;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;

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

978:
979: IF p_ptr_prgm_type_rec.last_update_login = FND_API.g_miss_num
980: OR p_ptr_prgm_type_rec.last_update_login IS NULL THEN
981: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
982: FND_MESSAGE.set_token('COLUMN','LAST_UPDATE_LOGIN');
983: FND_MSG_PUB.add;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;
986: END IF;

Line 991: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

987: ELSE
988:
989:
990: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
991: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
992: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
993: x_return_status := FND_API.g_ret_sts_error;
994: RETURN;
995: END IF;

Line 992: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');

988:
989:
990: IF p_ptr_prgm_type_rec.PROGRAM_TYPE_ID IS NULL THEN
991: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
992: FND_MESSAGE.set_token('COLUMN','PROGRAM_TYPE_ID');
993: x_return_status := FND_API.g_ret_sts_error;
994: RETURN;
995: END IF;
996:

Line 999: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

995: END IF;
996:
997:
998: IF p_ptr_prgm_type_rec.object_version_number IS NULL THEN
999: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1000: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1001: x_return_status := FND_API.g_ret_sts_error;
1002: RETURN;
1003: END IF;

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

996:
997:
998: IF p_ptr_prgm_type_rec.object_version_number IS NULL THEN
999: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1000: FND_MESSAGE.set_token('COLUMN','OBJECT_VERSION_NUMBER');
1001: x_return_status := FND_API.g_ret_sts_error;
1002: RETURN;
1003: END IF;
1004: END IF;