106: -- =========================================================================
107:
108: IF FND_GLOBAL.User_Id IS NULL
109: THEN
110: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
111: FND_MSG_PUB.add;
112: RAISE FND_API.G_EXC_ERROR;
113: END IF;
114:
307: FETCH c_get_Attr_Principal INTO l_ref_Attr_Principal_rec ;
308:
309: IF ( c_get_Attr_Principal%NOTFOUND) THEN
310: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
311: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
312: FND_MESSAGE.set_token('MODE','Update');
313: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
314: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_Attr_Principal_rec.Attr_Principal_id));
315: FND_MSG_PUB.add;
308:
309: IF ( c_get_Attr_Principal%NOTFOUND) THEN
310: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
311: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
312: FND_MESSAGE.set_token('MODE','Update');
313: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
314: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_Attr_Principal_rec.Attr_Principal_id));
315: FND_MSG_PUB.add;
316: END IF;
309: IF ( c_get_Attr_Principal%NOTFOUND) THEN
310: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
311: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
312: FND_MESSAGE.set_token('MODE','Update');
313: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
314: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_Attr_Principal_rec.Attr_Principal_id));
315: FND_MSG_PUB.add;
316: END IF;
317: RAISE FND_API.G_EXC_ERROR;
310: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
311: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
312: FND_MESSAGE.set_token('MODE','Update');
313: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
314: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_Attr_Principal_rec.Attr_Principal_id));
315: FND_MSG_PUB.add;
316: END IF;
317: RAISE FND_API.G_EXC_ERROR;
318: END IF;
328: IF (l_tar_Attr_Principal_rec.object_version_number is NULL or
329: l_tar_Attr_Principal_rec.object_version_number = FND_API.G_MISS_NUM ) Then
330:
331: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
332: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
333: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_Attr_Principal_rec.last_update_date));
334: FND_MSG_PUB.add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
329: l_tar_Attr_Principal_rec.object_version_number = FND_API.G_MISS_NUM ) Then
330:
331: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
332: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
333: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_Attr_Principal_rec.last_update_date));
334: FND_MSG_PUB.add;
335: END IF;
336: RAISE FND_API.G_EXC_ERROR;
337: End if;
338:
339: -- Check Whether record has been changed by someone else
340: If (l_tar_Attr_Principal_rec.object_version_number <> l_ref_Attr_Principal_rec.object_version_number) 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_RECORD_CHANGED');
343: FND_MESSAGE.set_token('VALUE','Attr_Principal');
344: FND_MSG_PUB.add;
345: END IF;
346: RAISE FND_API.G_EXC_ERROR;
339: -- Check Whether record has been changed by someone else
340: If (l_tar_Attr_Principal_rec.object_version_number <> l_ref_Attr_Principal_rec.object_version_number) 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_RECORD_CHANGED');
343: FND_MESSAGE.set_token('VALUE','Attr_Principal');
344: FND_MSG_PUB.add;
345: END IF;
346: RAISE FND_API.G_EXC_ERROR;
347: End if;
643: IF (c_Attr_Principal%NOTFOUND) THEN
644: CLOSE c_Attr_Principal;
645: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
646: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
647: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
648: FND_MSG_PUB.add;
649: END IF;
650: END IF;
651: RAISE FND_API.g_exc_error;
726: END IF;
727:
728: IF l_valid_flag = FND_API.g_false THEN
729: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
730: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
731: FND_MESSAGE.set_token('ID',to_char(p_Attr_Principal_rec.Attr_Principal_ID) );
732: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
733: FND_MSG_PUB.add;
734: END IF;
727:
728: IF l_valid_flag = FND_API.g_false THEN
729: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
730: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
731: FND_MESSAGE.set_token('ID',to_char(p_Attr_Principal_rec.Attr_Principal_ID) );
732: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
733: FND_MSG_PUB.add;
734: END IF;
735: x_return_status := FND_API.g_ret_sts_error;
728: IF l_valid_flag = FND_API.g_false THEN
729: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
730: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
731: FND_MESSAGE.set_token('ID',to_char(p_Attr_Principal_rec.Attr_Principal_ID) );
732: FND_MESSAGE.set_token('ENTITY','Attr_Principal');
733: FND_MSG_PUB.add;
734: END IF;
735: x_return_status := FND_API.g_ret_sts_error;
736: RETURN;
754: -- TO_CHAR(p_Attr_Principal_rec.Attr_Principal_id));
755: IF p_Attr_Principal_rec.Attr_Principal_id = FND_API.g_miss_num
756: OR p_Attr_Principal_rec.Attr_Principal_id IS NULL THEN
757: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
758: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
759: FND_MESSAGE.set_token('COLUMN','Attr_Principal_id');
760: FND_MSG_PUB.add;
761: END IF;
762: x_return_status := FND_API.g_ret_sts_error;
755: IF p_Attr_Principal_rec.Attr_Principal_id = FND_API.g_miss_num
756: OR p_Attr_Principal_rec.Attr_Principal_id IS NULL THEN
757: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
758: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
759: FND_MESSAGE.set_token('COLUMN','Attr_Principal_id');
760: FND_MSG_PUB.add;
761: END IF;
762: x_return_status := FND_API.g_ret_sts_error;
763: RETURN;
765:
766: IF p_Attr_Principal_rec.last_update_date = FND_API.g_miss_date
767: OR p_Attr_Principal_rec.last_update_date IS NULL THEN
768: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
769: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
770: FND_MESSAGE.set_token('COLUMN','last_update_date');
771: FND_MSG_PUB.add;
772: END IF;
773: x_return_status := FND_API.g_ret_sts_error;
766: IF p_Attr_Principal_rec.last_update_date = FND_API.g_miss_date
767: OR p_Attr_Principal_rec.last_update_date IS NULL THEN
768: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
769: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
770: FND_MESSAGE.set_token('COLUMN','last_update_date');
771: FND_MSG_PUB.add;
772: END IF;
773: x_return_status := FND_API.g_ret_sts_error;
774: RETURN;
776:
777: IF p_Attr_Principal_rec.last_updated_by = FND_API.g_miss_num
778: OR p_Attr_Principal_rec.last_updated_by IS NULL THEN
779: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
780: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
781: FND_MESSAGE.set_token('COLUMN','last_updated_by');
782: FND_MSG_PUB.add;
783: END IF;
784: x_return_status := FND_API.g_ret_sts_error;
777: IF p_Attr_Principal_rec.last_updated_by = FND_API.g_miss_num
778: OR p_Attr_Principal_rec.last_updated_by IS NULL THEN
779: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
780: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
781: FND_MESSAGE.set_token('COLUMN','last_updated_by');
782: FND_MSG_PUB.add;
783: END IF;
784: x_return_status := FND_API.g_ret_sts_error;
785: RETURN;
787:
788: IF p_Attr_Principal_rec.creation_date = FND_API.g_miss_date
789: OR p_Attr_Principal_rec.creation_date IS NULL THEN
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
792: FND_MESSAGE.set_token('COLUMN','creation_date');
793: FND_MSG_PUB.add;
794: END IF;
795: x_return_status := FND_API.g_ret_sts_error;
788: IF p_Attr_Principal_rec.creation_date = FND_API.g_miss_date
789: OR p_Attr_Principal_rec.creation_date IS NULL THEN
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
792: FND_MESSAGE.set_token('COLUMN','creation_date');
793: FND_MSG_PUB.add;
794: END IF;
795: x_return_status := FND_API.g_ret_sts_error;
796: RETURN;
798:
799: IF p_Attr_Principal_rec.created_by = FND_API.g_miss_num
800: OR p_Attr_Principal_rec.created_by IS NULL THEN
801: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
802: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
803: FND_MESSAGE.set_token('COLUMN','created_by');
804: FND_MSG_PUB.add;
805: END IF;
806: x_return_status := FND_API.g_ret_sts_error;
799: IF p_Attr_Principal_rec.created_by = FND_API.g_miss_num
800: OR p_Attr_Principal_rec.created_by IS NULL THEN
801: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
802: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
803: FND_MESSAGE.set_token('COLUMN','created_by');
804: FND_MSG_PUB.add;
805: END IF;
806: x_return_status := FND_API.g_ret_sts_error;
807: RETURN;
809:
810: IF p_Attr_Principal_rec.object_version_number = FND_API.g_miss_num
811: OR p_Attr_Principal_rec.object_version_number IS NULL THEN
812: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
813: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
814: FND_MESSAGE.set_token('COLUMN','object_version_number');
815: FND_MSG_PUB.add;
816: END IF;
817: x_return_status := FND_API.g_ret_sts_error;
810: IF p_Attr_Principal_rec.object_version_number = FND_API.g_miss_num
811: OR p_Attr_Principal_rec.object_version_number IS NULL THEN
812: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
813: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
814: FND_MESSAGE.set_token('COLUMN','object_version_number');
815: FND_MSG_PUB.add;
816: END IF;
817: x_return_status := FND_API.g_ret_sts_error;
818: RETURN;
822:
823: IF p_Attr_Principal_rec.attribute_id = FND_API.g_miss_num
824: OR p_Attr_Principal_rec.attribute_id IS NULL THEN
825: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
827: FND_MESSAGE.set_token('COLUMN','attribute_id');
828: FND_MSG_PUB.add;
829: END IF;
830: x_return_status := FND_API.g_ret_sts_error;
823: IF p_Attr_Principal_rec.attribute_id = FND_API.g_miss_num
824: OR p_Attr_Principal_rec.attribute_id IS NULL THEN
825: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
826: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
827: FND_MESSAGE.set_token('COLUMN','attribute_id');
828: FND_MSG_PUB.add;
829: END IF;
830: x_return_status := FND_API.g_ret_sts_error;
831: RETURN;
833:
834: IF p_Attr_Principal_rec.jtf_auth_principal_id = FND_API.g_miss_num
835: OR p_Attr_Principal_rec.jtf_auth_principal_id IS NULL THEN
836: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
838: FND_MESSAGE.set_token('COLUMN','jtf_auth_principal_id');
839: FND_MSG_PUB.add;
840: END IF;
841: x_return_status := FND_API.g_ret_sts_error;
834: IF p_Attr_Principal_rec.jtf_auth_principal_id = FND_API.g_miss_num
835: OR p_Attr_Principal_rec.jtf_auth_principal_id IS NULL THEN
836: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
837: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
838: FND_MESSAGE.set_token('COLUMN','jtf_auth_principal_id');
839: FND_MSG_PUB.add;
840: END IF;
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
844: ELSE
845:
846: IF p_Attr_Principal_rec.Attr_Principal_id IS NULL THEN
847: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
848: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
849: FND_MESSAGE.set_token('COLUMN','Attr_Principal_id');
850: FND_MSG_PUB.add;
851: END IF;
852: x_return_status := FND_API.g_ret_sts_error;
845:
846: IF p_Attr_Principal_rec.Attr_Principal_id IS NULL THEN
847: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
848: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
849: FND_MESSAGE.set_token('COLUMN','Attr_Principal_id');
850: FND_MSG_PUB.add;
851: END IF;
852: x_return_status := FND_API.g_ret_sts_error;
853: RETURN;
854: END IF;
855:
856: IF p_Attr_Principal_rec.last_update_date IS NULL THEN
857: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
858: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
859: FND_MESSAGE.set_token('COLUMN','last_update_date');
860: FND_MSG_PUB.add;
861: END IF;
862: x_return_status := FND_API.g_ret_sts_error;
855:
856: IF p_Attr_Principal_rec.last_update_date IS NULL THEN
857: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
858: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
859: FND_MESSAGE.set_token('COLUMN','last_update_date');
860: FND_MSG_PUB.add;
861: END IF;
862: x_return_status := FND_API.g_ret_sts_error;
863: RETURN;
864: END IF;
865:
866: IF p_Attr_Principal_rec.last_updated_by 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','last_updated_by');
870: FND_MSG_PUB.add;
871: END IF;
872: x_return_status := FND_API.g_ret_sts_error;
865:
866: IF p_Attr_Principal_rec.last_updated_by 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','last_updated_by');
870: FND_MSG_PUB.add;
871: END IF;
872: x_return_status := FND_API.g_ret_sts_error;
873: RETURN;
874: END IF;
875:
876: IF p_Attr_Principal_rec.creation_date IS NULL THEN
877: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
878: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
879: FND_MESSAGE.set_token('COLUMN','creation_date');
880: FND_MSG_PUB.add;
881: END IF;
882: x_return_status := FND_API.g_ret_sts_error;
875:
876: IF p_Attr_Principal_rec.creation_date IS NULL THEN
877: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
878: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
879: FND_MESSAGE.set_token('COLUMN','creation_date');
880: FND_MSG_PUB.add;
881: END IF;
882: x_return_status := FND_API.g_ret_sts_error;
883: RETURN;
884: END IF;
885:
886: IF p_Attr_Principal_rec.created_by IS NULL THEN
887: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
888: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
889: FND_MESSAGE.set_token('COLUMN','created_by');
890: FND_MSG_PUB.add;
891: END IF;
892: x_return_status := FND_API.g_ret_sts_error;
885:
886: IF p_Attr_Principal_rec.created_by IS NULL THEN
887: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
888: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
889: FND_MESSAGE.set_token('COLUMN','created_by');
890: FND_MSG_PUB.add;
891: END IF;
892: x_return_status := FND_API.g_ret_sts_error;
893: RETURN;
894: END IF;
895:
896: IF p_Attr_Principal_rec.object_version_number IS NULL THEN
897: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
898: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
899: FND_MESSAGE.set_token('COLUMN','object_version_number');
900: FND_MSG_PUB.add;
901: END IF;
902: x_return_status := FND_API.g_ret_sts_error;
895:
896: IF p_Attr_Principal_rec.object_version_number IS NULL THEN
897: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
898: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
899: FND_MESSAGE.set_token('COLUMN','object_version_number');
900: FND_MSG_PUB.add;
901: END IF;
902: x_return_status := FND_API.g_ret_sts_error;
903: RETURN;
904: END IF;
905:
906: IF p_Attr_Principal_rec.attribute_id 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','attribute_id');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
905:
906: IF p_Attr_Principal_rec.attribute_id 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','attribute_id');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: RETURN;
914: END IF;
915:
916: IF p_Attr_Principal_rec.jtf_auth_principal_id IS NULL THEN
917: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
918: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
919: FND_MESSAGE.set_token('COLUMN','enabled_flag');
920: FND_MSG_PUB.add;
921: END IF;
922: x_return_status := FND_API.g_ret_sts_error;
915:
916: IF p_Attr_Principal_rec.jtf_auth_principal_id IS NULL THEN
917: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
918: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
919: FND_MESSAGE.set_token('COLUMN','enabled_flag');
920: FND_MSG_PUB.add;
921: END IF;
922: x_return_status := FND_API.g_ret_sts_error;
923: RETURN;