107: -- =========================================================================
108:
109: IF FND_GLOBAL.User_Id IS NULL
110: 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:
314: FETCH c_get_Attribute_Usage INTO l_ref_attribute_usage_rec ;
315:
316: IF ( c_get_Attribute_Usage%NOTFOUND) THEN
317: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));
322: FND_MSG_PUB.add;
315:
316: IF ( c_get_Attribute_Usage%NOTFOUND) THEN
317: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));
322: FND_MSG_PUB.add;
323: END IF;
316: IF ( c_get_Attribute_Usage%NOTFOUND) THEN
317: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));
322: FND_MSG_PUB.add;
323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
317: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));
322: FND_MSG_PUB.add;
323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
335: IF (l_tar_attribute_usage_rec.object_version_number is NULL or
336: l_tar_attribute_usage_rec.object_version_number = FND_API.G_MISS_NUM ) Then
337:
338: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
339: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
340: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_usage_rec.last_update_date));
341: FND_MSG_PUB.add;
342: END IF;
343: RAISE FND_API.G_EXC_ERROR;
336: l_tar_attribute_usage_rec.object_version_number = FND_API.G_MISS_NUM ) Then
337:
338: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
339: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
340: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_usage_rec.last_update_date));
341: FND_MSG_PUB.add;
342: END IF;
343: RAISE FND_API.G_EXC_ERROR;
344: End if;
345:
346: -- Check Whether record has been changed by someone else
347: If (l_tar_attribute_usage_rec.object_version_number <> l_ref_attribute_usage_rec.object_version_number) Then
348: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
349: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
350: FND_MESSAGE.set_token('VALUE','Attribute_Usage');
351: FND_MSG_PUB.add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR;
346: -- Check Whether record has been changed by someone else
347: If (l_tar_attribute_usage_rec.object_version_number <> l_ref_attribute_usage_rec.object_version_number) Then
348: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
349: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
350: FND_MESSAGE.set_token('VALUE','Attribute_Usage');
351: FND_MSG_PUB.add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR;
354: End if;
656: IF (c_Attribute_Usage%NOTFOUND) THEN
657: CLOSE c_Attribute_Usage;
658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
659: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
660: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
661: FND_MSG_PUB.add;
662: END IF;
663: END IF;
664: RAISE FND_API.g_exc_error;
739: END IF;
740:
741: IF l_valid_flag = FND_API.g_false THEN
742: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
743: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );
745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
746: FND_MSG_PUB.add;
747: END IF;
740:
741: IF l_valid_flag = FND_API.g_false THEN
742: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
743: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );
745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
746: FND_MSG_PUB.add;
747: END IF;
748: x_return_status := FND_API.g_ret_sts_error;
741: IF l_valid_flag = FND_API.g_false THEN
742: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
743: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );
745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
746: FND_MSG_PUB.add;
747: END IF;
748: x_return_status := FND_API.g_ret_sts_error;
749: RETURN;
768:
769: IF p_attribute_usage_rec.attribute_usage_id = FND_API.g_miss_num
770: OR p_attribute_usage_rec.attribute_usage_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','attribute_usage_id');
774: FND_MSG_PUB.add;
775: END IF;
776: x_return_status := FND_API.g_ret_sts_error;
769: IF p_attribute_usage_rec.attribute_usage_id = FND_API.g_miss_num
770: OR p_attribute_usage_rec.attribute_usage_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','attribute_usage_id');
774: FND_MSG_PUB.add;
775: END IF;
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
780:
781: IF p_attribute_usage_rec.last_update_date = FND_API.g_miss_date
782: OR p_attribute_usage_rec.last_update_date IS NULL THEN
783: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
784: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
785: FND_MESSAGE.set_token('COLUMN','last_update_date');
786: FND_MSG_PUB.add;
787: END IF;
788: x_return_status := FND_API.g_ret_sts_error;
781: IF p_attribute_usage_rec.last_update_date = FND_API.g_miss_date
782: OR p_attribute_usage_rec.last_update_date IS NULL THEN
783: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
784: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
785: FND_MESSAGE.set_token('COLUMN','last_update_date');
786: FND_MSG_PUB.add;
787: END IF;
788: x_return_status := FND_API.g_ret_sts_error;
789: RETURN;
792:
793: IF p_attribute_usage_rec.last_updated_by = FND_API.g_miss_num
794: OR p_attribute_usage_rec.last_updated_by IS NULL THEN
795: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','last_updated_by');
798: FND_MSG_PUB.add;
799: END IF;
800: x_return_status := FND_API.g_ret_sts_error;
793: IF p_attribute_usage_rec.last_updated_by = FND_API.g_miss_num
794: OR p_attribute_usage_rec.last_updated_by IS NULL THEN
795: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','last_updated_by');
798: FND_MSG_PUB.add;
799: END IF;
800: x_return_status := FND_API.g_ret_sts_error;
801: RETURN;
804:
805: IF p_attribute_usage_rec.creation_date = FND_API.g_miss_date
806: OR p_attribute_usage_rec.creation_date IS NULL THEN
807: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
808: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
809: FND_MESSAGE.set_token('COLUMN','creation_date');
810: FND_MSG_PUB.add;
811: END IF;
812: x_return_status := FND_API.g_ret_sts_error;
805: IF p_attribute_usage_rec.creation_date = FND_API.g_miss_date
806: OR p_attribute_usage_rec.creation_date IS NULL THEN
807: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
808: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
809: FND_MESSAGE.set_token('COLUMN','creation_date');
810: FND_MSG_PUB.add;
811: END IF;
812: x_return_status := FND_API.g_ret_sts_error;
813: RETURN;
816:
817: IF p_attribute_usage_rec.created_by = FND_API.g_miss_num
818: OR p_attribute_usage_rec.created_by IS NULL THEN
819: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','created_by');
822: FND_MSG_PUB.add;
823: END IF;
824: x_return_status := FND_API.g_ret_sts_error;
817: IF p_attribute_usage_rec.created_by = FND_API.g_miss_num
818: OR p_attribute_usage_rec.created_by IS NULL THEN
819: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','created_by');
822: FND_MSG_PUB.add;
823: END IF;
824: x_return_status := FND_API.g_ret_sts_error;
825: RETURN;
828:
829: IF p_attribute_usage_rec.object_version_number = FND_API.g_miss_num
830: OR p_attribute_usage_rec.object_version_number IS NULL THEN
831: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
832: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
833: FND_MESSAGE.set_token('COLUMN','object_version_number');
834: FND_MSG_PUB.add;
835: END IF;
836: x_return_status := FND_API.g_ret_sts_error;
829: IF p_attribute_usage_rec.object_version_number = FND_API.g_miss_num
830: OR p_attribute_usage_rec.object_version_number IS NULL THEN
831: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
832: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
833: FND_MESSAGE.set_token('COLUMN','object_version_number');
834: FND_MSG_PUB.add;
835: END IF;
836: x_return_status := FND_API.g_ret_sts_error;
837: RETURN;
840:
841: IF p_attribute_usage_rec.attribute_usage_type = FND_API.g_miss_char
842: OR p_attribute_usage_rec.attribute_usage_type IS NULL THEN
843: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
844: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
845: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
846: FND_MSG_PUB.add;
847: END IF;
848: x_return_status := FND_API.g_ret_sts_error;
841: IF p_attribute_usage_rec.attribute_usage_type = FND_API.g_miss_char
842: OR p_attribute_usage_rec.attribute_usage_type IS NULL THEN
843: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
844: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
845: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
846: FND_MSG_PUB.add;
847: END IF;
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
852:
853: IF p_attribute_usage_rec.attribute_usage_code = FND_API.g_miss_char
854: OR p_attribute_usage_rec.attribute_usage_code IS NULL THEN
855: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
856: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
857: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
858: FND_MSG_PUB.add;
859: END IF;
860: x_return_status := FND_API.g_ret_sts_error;
853: IF p_attribute_usage_rec.attribute_usage_code = FND_API.g_miss_char
854: OR p_attribute_usage_rec.attribute_usage_code IS NULL THEN
855: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
856: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
857: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
858: FND_MSG_PUB.add;
859: END IF;
860: x_return_status := FND_API.g_ret_sts_error;
861: RETURN;
864:
865: IF p_attribute_usage_rec.attribute_id = FND_API.g_miss_num
866: OR p_attribute_usage_rec.attribute_id IS NULL THEN
867: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
868: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
869: FND_MESSAGE.set_token('COLUMN','attribute_id');
870: FND_MSG_PUB.add;
871: END IF;
872: x_return_status := FND_API.g_ret_sts_error;
865: IF p_attribute_usage_rec.attribute_id = FND_API.g_miss_num
866: OR p_attribute_usage_rec.attribute_id IS NULL THEN
867: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
868: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
869: FND_MESSAGE.set_token('COLUMN','attribute_id');
870: FND_MSG_PUB.add;
871: END IF;
872: x_return_status := FND_API.g_ret_sts_error;
873: RETURN;
876:
877: IF p_attribute_usage_rec.enabled_flag = FND_API.g_miss_char
878: OR p_attribute_usage_rec.enabled_flag IS NULL THEN
879: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
880: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
881: FND_MESSAGE.set_token('COLUMN','enabled_flag');
882: FND_MSG_PUB.add;
883: END IF;
884: x_return_status := FND_API.g_ret_sts_error;
877: IF p_attribute_usage_rec.enabled_flag = FND_API.g_miss_char
878: OR p_attribute_usage_rec.enabled_flag IS NULL THEN
879: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
880: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
881: FND_MESSAGE.set_token('COLUMN','enabled_flag');
882: FND_MSG_PUB.add;
883: END IF;
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
888:
889:
890: IF p_attribute_usage_rec.attribute_usage_id IS NULL THEN
891: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
892: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
893: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
894: FND_MSG_PUB.add;
895: END IF;
896: x_return_status := FND_API.g_ret_sts_error;
889:
890: IF p_attribute_usage_rec.attribute_usage_id IS NULL THEN
891: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
892: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
893: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
894: FND_MSG_PUB.add;
895: END IF;
896: x_return_status := FND_API.g_ret_sts_error;
897: RETURN;
899:
900:
901: IF p_attribute_usage_rec.last_update_date IS NULL THEN
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
903: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
904: FND_MESSAGE.set_token('COLUMN','last_update_date');
905: FND_MSG_PUB.add;
906: END IF;
907: x_return_status := FND_API.g_ret_sts_error;
900:
901: IF p_attribute_usage_rec.last_update_date IS NULL THEN
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
903: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
904: FND_MESSAGE.set_token('COLUMN','last_update_date');
905: FND_MSG_PUB.add;
906: END IF;
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
910:
911:
912: IF p_attribute_usage_rec.last_updated_by IS NULL THEN
913: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
914: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
915: FND_MESSAGE.set_token('COLUMN','last_updated_by');
916: FND_MSG_PUB.add;
917: END IF;
918: x_return_status := FND_API.g_ret_sts_error;
911:
912: IF p_attribute_usage_rec.last_updated_by IS NULL THEN
913: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
914: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
915: FND_MESSAGE.set_token('COLUMN','last_updated_by');
916: FND_MSG_PUB.add;
917: END IF;
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
921:
922:
923: IF p_attribute_usage_rec.creation_date IS NULL THEN
924: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','creation_date');
927: FND_MSG_PUB.add;
928: END IF;
929: x_return_status := FND_API.g_ret_sts_error;
922:
923: IF p_attribute_usage_rec.creation_date IS NULL THEN
924: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','creation_date');
927: FND_MSG_PUB.add;
928: END IF;
929: x_return_status := FND_API.g_ret_sts_error;
930: RETURN;
932:
933:
934: IF p_attribute_usage_rec.created_by IS NULL THEN
935: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
936: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
937: FND_MESSAGE.set_token('COLUMN','created_by');
938: FND_MSG_PUB.add;
939: END IF;
940: x_return_status := FND_API.g_ret_sts_error;
933:
934: IF p_attribute_usage_rec.created_by IS NULL THEN
935: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
936: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
937: FND_MESSAGE.set_token('COLUMN','created_by');
938: FND_MSG_PUB.add;
939: END IF;
940: x_return_status := FND_API.g_ret_sts_error;
941: RETURN;
943:
944:
945: IF p_attribute_usage_rec.object_version_number IS NULL THEN
946: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
947: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
948: FND_MESSAGE.set_token('COLUMN','object_version_number');
949: FND_MSG_PUB.add;
950: END IF;
951: x_return_status := FND_API.g_ret_sts_error;
944:
945: IF p_attribute_usage_rec.object_version_number IS NULL THEN
946: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
947: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
948: FND_MESSAGE.set_token('COLUMN','object_version_number');
949: FND_MSG_PUB.add;
950: END IF;
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;
954:
955:
956: IF p_attribute_usage_rec.attribute_usage_type IS NULL THEN
957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
958: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
959: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
960: FND_MSG_PUB.add;
961: END IF;
962: x_return_status := FND_API.g_ret_sts_error;
955:
956: IF p_attribute_usage_rec.attribute_usage_type IS NULL THEN
957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
958: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
959: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
960: FND_MSG_PUB.add;
961: END IF;
962: x_return_status := FND_API.g_ret_sts_error;
963: RETURN;
965:
966:
967: IF p_attribute_usage_rec.attribute_usage_code IS NULL THEN
968: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
969: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
970: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
971: FND_MSG_PUB.add;
972: END IF;
973: x_return_status := FND_API.g_ret_sts_error;
966:
967: IF p_attribute_usage_rec.attribute_usage_code IS NULL THEN
968: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
969: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
970: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
971: FND_MSG_PUB.add;
972: END IF;
973: x_return_status := FND_API.g_ret_sts_error;
974: RETURN;
976:
977:
978: IF p_attribute_usage_rec.attribute_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','attribute_id');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
977:
978: IF p_attribute_usage_rec.attribute_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','attribute_id');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;
987:
988:
989: IF p_attribute_usage_rec.enabled_flag IS NULL THEN
990: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
992: FND_MESSAGE.set_token('COLUMN','enabled_flag');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;
988:
989: IF p_attribute_usage_rec.enabled_flag IS NULL THEN
990: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
992: FND_MESSAGE.set_token('COLUMN','enabled_flag');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;
996: RETURN;