109:
110: IF FND_GLOBAL.User_Id IS NULL
111: THEN
112: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
113: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
114: FND_MSG_PUB.add;
115: END IF;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
319: FETCH c_get_Enty_Attr_Validation INTO l_ref_enty_attr_validation_rec ;
320:
321: If ( c_get_Enty_Attr_Validation%NOTFOUND) THEN
322: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));
327: FND_MSG_PUB.add;
320:
321: If ( c_get_Enty_Attr_Validation%NOTFOUND) THEN
322: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));
327: FND_MSG_PUB.add;
328: END IF;
321: If ( c_get_Enty_Attr_Validation%NOTFOUND) THEN
322: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));
327: FND_MSG_PUB.add;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
322: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));
327: FND_MSG_PUB.add;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
338:
339: If (l_tar_enty_attr_validation_rec.object_version_number is NULL or
340: l_tar_enty_attr_validation_rec.object_version_number = FND_API.G_MISS_NUM ) Then
341: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
342: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
343: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
344: FND_MSG_PUB.add;
345: END IF;
346: RAISE FND_API.G_EXC_ERROR;
339: If (l_tar_enty_attr_validation_rec.object_version_number is NULL or
340: l_tar_enty_attr_validation_rec.object_version_number = FND_API.G_MISS_NUM ) Then
341: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
342: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
343: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
344: FND_MSG_PUB.add;
345: END IF;
346: RAISE FND_API.G_EXC_ERROR;
347: End if;
348:
349: -- Check Whether record has been changed by someone else
350: If (l_tar_enty_attr_validation_rec.object_version_number <> l_ref_enty_attr_validation_rec.object_version_number) Then
351: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
352: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
353: FND_MESSAGE.set_token('VALUE','Enty_Attr_Validation');
354: FND_MSG_PUB.add;
355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
349: -- Check Whether record has been changed by someone else
350: If (l_tar_enty_attr_validation_rec.object_version_number <> l_ref_enty_attr_validation_rec.object_version_number) Then
351: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
352: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
353: FND_MESSAGE.set_token('VALUE','Enty_Attr_Validation');
354: FND_MSG_PUB.add;
355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
357: End if;
654:
655: IF (c_Enty_Attr_Validation%NOTFOUND) THEN
656: CLOSE c_Enty_Attr_Validation;
657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
658: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
659: FND_MSG_PUB.add;
660: END IF;
661: RAISE FND_API.g_exc_error;
662: END IF;
740: END IF;
741:
742: IF l_valid_flag = FND_API.g_false THEN
743: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
744: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
745: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_validation_rec.VALIDATION_ID) );
746: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validations');
747: FND_MSG_PUB.add;
748: END IF;
741:
742: IF l_valid_flag = FND_API.g_false THEN
743: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
744: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
745: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_validation_rec.VALIDATION_ID) );
746: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validations');
747: FND_MSG_PUB.add;
748: END IF;
749: x_return_status := FND_API.g_ret_sts_error;
742: IF l_valid_flag = FND_API.g_false THEN
743: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
744: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
745: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_validation_rec.VALIDATION_ID) );
746: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validations');
747: FND_MSG_PUB.add;
748: END IF;
749: x_return_status := FND_API.g_ret_sts_error;
750: RETURN;
768:
769: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
770: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
771: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
773: FND_MESSAGE.set_token('COLUMN','validation_id');
774: FND_MSG_PUB.add;
775: END IF;
776: x_return_status := FND_API.g_ret_sts_error;
769: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
770: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
771: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
773: FND_MESSAGE.set_token('COLUMN','validation_id');
774: FND_MSG_PUB.add;
775: END IF;
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
781: IF p_enty_attr_validation_rec.last_update_date = FND_API.g_miss_date
782: OR p_enty_attr_validation_rec.last_update_date IS NULL THEN
783:
784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
785: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
786: FND_MESSAGE.set_token('COLUMN','last_update_date');
787: FND_MSG_PUB.add;
788: END IF;
789: x_return_status := FND_API.g_ret_sts_error;
782: OR p_enty_attr_validation_rec.last_update_date IS NULL THEN
783:
784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
785: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
786: FND_MESSAGE.set_token('COLUMN','last_update_date');
787: FND_MSG_PUB.add;
788: END IF;
789: x_return_status := FND_API.g_ret_sts_error;
790: RETURN;
793:
794: IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
795: OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
796: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
797: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
798: FND_MESSAGE.set_token('COLUMN','last_updated_by');
799: FND_MSG_PUB.add;
800: END IF;
801: x_return_status := FND_API.g_ret_sts_error;
794: IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
795: OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
796: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
797: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
798: FND_MESSAGE.set_token('COLUMN','last_updated_by');
799: FND_MSG_PUB.add;
800: END IF;
801: x_return_status := FND_API.g_ret_sts_error;
802: RETURN;
805:
806: IF p_enty_attr_validation_rec.creation_date = FND_API.g_miss_date
807: OR p_enty_attr_validation_rec.creation_date IS NULL THEN
808: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
809: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
810: FND_MESSAGE.set_token('COLUMN','creation_date');
811: FND_MSG_PUB.add;
812: END IF;
813: x_return_status := FND_API.g_ret_sts_error;
806: IF p_enty_attr_validation_rec.creation_date = FND_API.g_miss_date
807: OR p_enty_attr_validation_rec.creation_date IS NULL THEN
808: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
809: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
810: FND_MESSAGE.set_token('COLUMN','creation_date');
811: FND_MSG_PUB.add;
812: END IF;
813: x_return_status := FND_API.g_ret_sts_error;
814: RETURN;
817:
818: IF p_enty_attr_validation_rec.created_by = FND_API.g_miss_num
819: OR p_enty_attr_validation_rec.created_by IS NULL THEN
820: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
821: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
822: FND_MESSAGE.set_token('COLUMN','created_by');
823: FND_MSG_PUB.add;
824: END IF;
825: x_return_status := FND_API.g_ret_sts_error;
818: IF p_enty_attr_validation_rec.created_by = FND_API.g_miss_num
819: OR p_enty_attr_validation_rec.created_by IS NULL THEN
820: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
821: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
822: FND_MESSAGE.set_token('COLUMN','created_by');
823: FND_MSG_PUB.add;
824: END IF;
825: x_return_status := FND_API.g_ret_sts_error;
826: RETURN;
829:
830: IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
831: OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
832: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
833: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
834: FND_MESSAGE.set_token('COLUMN','last_update_login');
835: FND_MSG_PUB.add;
836: END IF;
837: x_return_status := FND_API.g_ret_sts_error;
830: IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
831: OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
832: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
833: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
834: FND_MESSAGE.set_token('COLUMN','last_update_login');
835: FND_MSG_PUB.add;
836: END IF;
837: x_return_status := FND_API.g_ret_sts_error;
838: RETURN;
841:
842: IF p_enty_attr_validation_rec.object_version_number = FND_API.g_miss_num
843: OR p_enty_attr_validation_rec.object_version_number IS NULL THEN
844: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
845: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
846: FND_MESSAGE.set_token('COLUMN','object_version_number');
847: FND_MSG_PUB.add;
848: END IF;
849: x_return_status := FND_API.g_ret_sts_error;
842: IF p_enty_attr_validation_rec.object_version_number = FND_API.g_miss_num
843: OR p_enty_attr_validation_rec.object_version_number IS NULL THEN
844: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
845: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
846: FND_MESSAGE.set_token('COLUMN','object_version_number');
847: FND_MSG_PUB.add;
848: END IF;
849: x_return_status := FND_API.g_ret_sts_error;
850: RETURN;
853:
854: IF p_enty_attr_validation_rec.validation_date = FND_API.g_miss_date
855: OR p_enty_attr_validation_rec.validation_date IS NULL THEN
856: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
858: FND_MESSAGE.set_token('COLUMN','validation_date');
859: FND_MSG_PUB.add;
860: END IF;
861: x_return_status := FND_API.g_ret_sts_error;
854: IF p_enty_attr_validation_rec.validation_date = FND_API.g_miss_date
855: OR p_enty_attr_validation_rec.validation_date IS NULL THEN
856: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
857: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
858: FND_MESSAGE.set_token('COLUMN','validation_date');
859: FND_MSG_PUB.add;
860: END IF;
861: x_return_status := FND_API.g_ret_sts_error;
862: RETURN;
865:
866: IF p_enty_attr_validation_rec.validated_by_resource_id = FND_API.g_miss_num
867: OR p_enty_attr_validation_rec.validated_by_resource_id IS NULL THEN
868: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
869: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
870: FND_MESSAGE.set_token('COLUMN','validated_by_resource_id');
871: FND_MSG_PUB.add;
872: END IF;
873: x_return_status := FND_API.g_ret_sts_error;
866: IF p_enty_attr_validation_rec.validated_by_resource_id = FND_API.g_miss_num
867: OR p_enty_attr_validation_rec.validated_by_resource_id IS NULL THEN
868: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
869: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
870: FND_MESSAGE.set_token('COLUMN','validated_by_resource_id');
871: FND_MSG_PUB.add;
872: END IF;
873: x_return_status := FND_API.g_ret_sts_error;
874: RETURN;
879:
880: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
881: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
882: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
883: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
884: FND_MESSAGE.set_token('COLUMN','validation_id');
885: FND_MSG_PUB.add;
886: END IF;
887: x_return_status := FND_API.g_ret_sts_error;
880: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
881: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
882: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
883: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
884: FND_MESSAGE.set_token('COLUMN','validation_id');
885: FND_MSG_PUB.add;
886: END IF;
887: x_return_status := FND_API.g_ret_sts_error;
888: RETURN;
892: IF p_enty_attr_validation_rec.last_update_date = FND_API.g_miss_date
893: OR p_enty_attr_validation_rec.last_update_date IS NULL THEN
894:
895: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
896: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
897: FND_MESSAGE.set_token('COLUMN','last_update_date');
898: FND_MSG_PUB.add;
899: END IF;
900: x_return_status := FND_API.g_ret_sts_error;
893: OR p_enty_attr_validation_rec.last_update_date IS NULL THEN
894:
895: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
896: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
897: FND_MESSAGE.set_token('COLUMN','last_update_date');
898: FND_MSG_PUB.add;
899: END IF;
900: x_return_status := FND_API.g_ret_sts_error;
901: RETURN;
904:
905: IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
906: OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
907: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
908: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
909: FND_MESSAGE.set_token('COLUMN','last_updated_by');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
905: IF p_enty_attr_validation_rec.last_updated_by = FND_API.g_miss_num
906: OR p_enty_attr_validation_rec.last_updated_by IS NULL THEN
907: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
908: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
909: FND_MESSAGE.set_token('COLUMN','last_updated_by');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: RETURN;
916:
917: IF p_enty_attr_validation_rec.creation_date = FND_API.g_miss_date
918: OR p_enty_attr_validation_rec.creation_date IS NULL THEN
919: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
920: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
921: FND_MESSAGE.set_token('COLUMN','creation_date');
922: FND_MSG_PUB.add;
923: END IF;
924: x_return_status := FND_API.g_ret_sts_error;
917: IF p_enty_attr_validation_rec.creation_date = FND_API.g_miss_date
918: OR p_enty_attr_validation_rec.creation_date IS NULL THEN
919: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
920: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
921: FND_MESSAGE.set_token('COLUMN','creation_date');
922: FND_MSG_PUB.add;
923: END IF;
924: x_return_status := FND_API.g_ret_sts_error;
925: RETURN;
928:
929: IF p_enty_attr_validation_rec.created_by = FND_API.g_miss_num
930: OR p_enty_attr_validation_rec.created_by IS NULL THEN
931: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
932: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
933: FND_MESSAGE.set_token('COLUMN','created_by');
934: FND_MSG_PUB.add;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_error;
929: IF p_enty_attr_validation_rec.created_by = FND_API.g_miss_num
930: OR p_enty_attr_validation_rec.created_by IS NULL THEN
931: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
932: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
933: FND_MESSAGE.set_token('COLUMN','created_by');
934: FND_MSG_PUB.add;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;
940:
941: IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
942: OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
943: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
944: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
945: FND_MESSAGE.set_token('COLUMN','last_update_login');
946: FND_MSG_PUB.add;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;
941: IF p_enty_attr_validation_rec.last_update_login = FND_API.g_miss_num
942: OR p_enty_attr_validation_rec.last_update_login IS NULL THEN
943: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
944: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
945: FND_MESSAGE.set_token('COLUMN','last_update_login');
946: FND_MSG_PUB.add;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;
949: RETURN;
952:
953: IF p_enty_attr_validation_rec.object_version_number = FND_API.g_miss_num
954: OR p_enty_attr_validation_rec.object_version_number IS NULL THEN
955: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
956: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
957: FND_MESSAGE.set_token('COLUMN','object_version_number');
958: FND_MSG_PUB.add;
959: END IF;
960: x_return_status := FND_API.g_ret_sts_error;
953: IF p_enty_attr_validation_rec.object_version_number = FND_API.g_miss_num
954: OR p_enty_attr_validation_rec.object_version_number IS NULL THEN
955: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
956: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
957: FND_MESSAGE.set_token('COLUMN','object_version_number');
958: FND_MSG_PUB.add;
959: END IF;
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;
964:
965: IF p_enty_attr_validation_rec.validation_date = FND_API.g_miss_date
966: OR p_enty_attr_validation_rec.validation_date IS NULL THEN
967: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
968: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
969: FND_MESSAGE.set_token('COLUMN','validation_date');
970: FND_MSG_PUB.add;
971: END IF;
972: x_return_status := FND_API.g_ret_sts_error;
965: IF p_enty_attr_validation_rec.validation_date = FND_API.g_miss_date
966: OR p_enty_attr_validation_rec.validation_date IS NULL THEN
967: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
968: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
969: FND_MESSAGE.set_token('COLUMN','validation_date');
970: FND_MSG_PUB.add;
971: END IF;
972: x_return_status := FND_API.g_ret_sts_error;
973: RETURN;
976:
977: IF p_enty_attr_validation_rec.validated_by_resource_id = FND_API.g_miss_num
978: OR p_enty_attr_validation_rec.validated_by_resource_id IS NULL THEN
979: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
980: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
981: FND_MESSAGE.set_token('COLUMN','validated_by_resource_id');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
977: IF p_enty_attr_validation_rec.validated_by_resource_id = FND_API.g_miss_num
978: OR p_enty_attr_validation_rec.validated_by_resource_id IS NULL THEN
979: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
980: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
981: FND_MESSAGE.set_token('COLUMN','validated_by_resource_id');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;