DBA Data[Home] [Help]

APPS.PV_ATTRIBUTE_USAGE_PVT dependencies on FND_MESSAGE

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

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:

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

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;

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

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;

Line 320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');

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;

Line 321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));

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;

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

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;

Line 340: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_usage_rec.last_update_date));

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;

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

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;

Line 350: FND_MESSAGE.set_token('VALUE','Attribute_Usage');

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;

Line 660: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');

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;

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

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;

Line 744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );

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;

Line 745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');

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;

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

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;

Line 773: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');

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;

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

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;

Line 785: FND_MESSAGE.set_token('COLUMN','last_update_date');

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;

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

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;

Line 797: FND_MESSAGE.set_token('COLUMN','last_updated_by');

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;

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

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;

Line 809: FND_MESSAGE.set_token('COLUMN','creation_date');

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;

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

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;

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

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;

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

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;

Line 833: FND_MESSAGE.set_token('COLUMN','object_version_number');

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;

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

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;

Line 845: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');

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;

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

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;

Line 857: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');

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;

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

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;

Line 869: FND_MESSAGE.set_token('COLUMN','attribute_id');

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;

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

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;

Line 881: FND_MESSAGE.set_token('COLUMN','enabled_flag');

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;

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

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;

Line 893: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');

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;

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

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;

Line 904: FND_MESSAGE.set_token('COLUMN','last_update_date');

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;

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

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;

Line 915: FND_MESSAGE.set_token('COLUMN','last_updated_by');

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;

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

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;

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

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;

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

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;

Line 937: FND_MESSAGE.set_token('COLUMN','created_by');

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;

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

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;

Line 948: FND_MESSAGE.set_token('COLUMN','object_version_number');

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;

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

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;

Line 959: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');

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;

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

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;

Line 970: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');

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;

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

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;

Line 981: FND_MESSAGE.set_token('COLUMN','attribute_id');

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;

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

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;

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

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;