APPS.PV_ENTY_ATTR_VALUE_PVT dependencies on FND_MESSAGE

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

128:
129: IF FND_GLOBAL.User_Id IS NULL
130: THEN
131: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
132: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
133: FND_MSG_PUB.add;
134: END IF;
135: RAISE FND_API.G_EXC_ERROR;
136: END IF;

Line 211: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_VAL_MULTI_ERROR');

207: and l_DISPLAY_STYLE in ('EXTERNAL_LOV','MULTI','CHECK','PERCENTAGE')
208: )
209: ) then
210: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
211: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_VAL_MULTI_ERROR');
212:
213:
214: FOR x IN (select meaning from pv_lookups
215: where lookup_type = 'PV_ATTRIBUTE_TYPE'

Line 220: Fnd_Message.set_token('ATTR_TYPE',l_meaning);

216: and lookup_code = l_attribute_type
217: ) LOOP
218: l_meaning := x.meaning;
219: END LOOP;
220: Fnd_Message.set_token('ATTR_TYPE',l_meaning);
221:
222: FOR x IN (select meaning from pv_lookups
223: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
224: and lookup_code = l_display_style

Line 228: Fnd_Message.set_token('ATTR_STYLE',l_meaning);

224: and lookup_code = l_display_style
225: ) LOOP
226: l_meaning := x.meaning;
227: END LOOP;
228: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
229:
230:
231: Fnd_Msg_Pub.ADD;
232: END IF;

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

403: FETCH c_get_Enty_Attr_Value INTO l_ref_enty_attr_val_rec ;
404:
405: If ( c_get_Enty_Attr_Value%NOTFOUND) THEN
406: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
407: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
408: FND_MESSAGE.set_token('MODE','Update');
409: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
410: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_val_rec.enty_attr_val_id));
411: FND_MSG_PUB.add;

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

404:
405: If ( c_get_Enty_Attr_Value%NOTFOUND) THEN
406: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
407: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
408: FND_MESSAGE.set_token('MODE','Update');
409: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
410: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_val_rec.enty_attr_val_id));
411: FND_MSG_PUB.add;
412: END IF;

Line 409: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');

405: If ( c_get_Enty_Attr_Value%NOTFOUND) THEN
406: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
407: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
408: FND_MESSAGE.set_token('MODE','Update');
409: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
410: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_val_rec.enty_attr_val_id));
411: FND_MSG_PUB.add;
412: END IF;
413: RAISE FND_API.G_EXC_ERROR;

Line 410: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_val_rec.enty_attr_val_id));

406: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
407: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
408: FND_MESSAGE.set_token('MODE','Update');
409: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
410: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_val_rec.enty_attr_val_id));
411: FND_MSG_PUB.add;
412: END IF;
413: RAISE FND_API.G_EXC_ERROR;
414: END IF;

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

422:
423: If (l_tar_enty_attr_val_rec.object_version_number is NULL or
424: l_tar_enty_attr_val_rec.object_version_number = FND_API.G_MISS_NUM ) Then
425: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
426: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
427: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.G_EXC_ERROR;

Line 427: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');

423: If (l_tar_enty_attr_val_rec.object_version_number is NULL or
424: l_tar_enty_attr_val_rec.object_version_number = FND_API.G_MISS_NUM ) Then
425: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
426: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
427: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
428: FND_MSG_PUB.add;
429: END IF;
430: RAISE FND_API.G_EXC_ERROR;
431: End if;

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

432:
433: -- Check Whether record has been changed by someone else
434: If (l_tar_enty_attr_val_rec.object_version_number <> l_ref_enty_attr_val_rec.object_version_number) Then
435: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
436: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
437: FND_MESSAGE.set_token('VALUE','Enty_Attr_Value');
438: FND_MSG_PUB.add;
439: END IF;
440: RAISE FND_API.G_EXC_ERROR;

Line 437: FND_MESSAGE.set_token('VALUE','Enty_Attr_Value');

433: -- Check Whether record has been changed by someone else
434: If (l_tar_enty_attr_val_rec.object_version_number <> l_ref_enty_attr_val_rec.object_version_number) Then
435: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
436: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
437: FND_MESSAGE.set_token('VALUE','Enty_Attr_Value');
438: FND_MSG_PUB.add;
439: END IF;
440: RAISE FND_API.G_EXC_ERROR;
441: End if;

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

743:
744: IF (c_Enty_Attr_Value%NOTFOUND) THEN
745: CLOSE c_Enty_Attr_Value;
746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
747: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
748: FND_MSG_PUB.add;
749: END IF;
750: RAISE FND_API.g_exc_error;
751: END IF;

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

829: END IF;
830:
831: IF l_valid_flag = FND_API.g_false 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_DUPLICATE_ENTITY');
834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );
835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
836: FND_MSG_PUB.add;
837: END IF;

Line 834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );

830:
831: IF l_valid_flag = FND_API.g_false 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_DUPLICATE_ENTITY');
834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );
835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
836: FND_MSG_PUB.add;
837: END IF;
838: x_return_status := FND_API.g_ret_sts_error;

Line 835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');

831: IF l_valid_flag = FND_API.g_false 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_DUPLICATE_ENTITY');
834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );
835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
836: FND_MSG_PUB.add;
837: END IF;
838: x_return_status := FND_API.g_ret_sts_error;
839: RETURN;

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

861:
862: IF p_enty_attr_val_rec.enty_attr_val_id = FND_API.g_miss_num
863: OR p_enty_attr_val_rec.enty_attr_val_id IS NULL THEN
864: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
865: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
866: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');
867: FND_MSG_PUB.add;
868: END IF;
869: x_return_status := FND_API.g_ret_sts_error;

Line 866: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');

862: IF p_enty_attr_val_rec.enty_attr_val_id = FND_API.g_miss_num
863: OR p_enty_attr_val_rec.enty_attr_val_id IS NULL THEN
864: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
865: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
866: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');
867: FND_MSG_PUB.add;
868: END IF;
869: x_return_status := FND_API.g_ret_sts_error;
870: RETURN;

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

878:
879: --DBMS_OUTPUT.PUT_LINE('p_enty_attr_val_rec.LAST_UPDATE_DATE = '||
880: -- TO_CHAR(p_enty_attr_val_rec.last_update_date));
881: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
882: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
883: FND_MESSAGE.set_token('COLUMN','last_update_date');
884: FND_MSG_PUB.add;
885: END IF;
886: x_return_status := FND_API.g_ret_sts_error;

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

879: --DBMS_OUTPUT.PUT_LINE('p_enty_attr_val_rec.LAST_UPDATE_DATE = '||
880: -- TO_CHAR(p_enty_attr_val_rec.last_update_date));
881: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
882: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
883: FND_MESSAGE.set_token('COLUMN','last_update_date');
884: FND_MSG_PUB.add;
885: END IF;
886: x_return_status := FND_API.g_ret_sts_error;
887: RETURN;

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

892:
893: IF p_enty_attr_val_rec.last_updated_by = FND_API.g_miss_num
894: OR p_enty_attr_val_rec.last_updated_by IS NULL THEN
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_updated_by');
898: FND_MSG_PUB.add;
899: END IF;
900: x_return_status := FND_API.g_ret_sts_error;

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

893: IF p_enty_attr_val_rec.last_updated_by = FND_API.g_miss_num
894: OR p_enty_attr_val_rec.last_updated_by IS NULL THEN
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_updated_by');
898: FND_MSG_PUB.add;
899: END IF;
900: x_return_status := FND_API.g_ret_sts_error;
901: RETURN;

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

904:
905: IF p_enty_attr_val_rec.creation_date = FND_API.g_miss_date
906: OR p_enty_attr_val_rec.creation_date 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','creation_date');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;

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

905: IF p_enty_attr_val_rec.creation_date = FND_API.g_miss_date
906: OR p_enty_attr_val_rec.creation_date 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','creation_date');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: RETURN;

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

916:
917: IF p_enty_attr_val_rec.created_by = FND_API.g_miss_num
918: OR p_enty_attr_val_rec.created_by 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','created_by');
922: FND_MSG_PUB.add;
923: END IF;
924: x_return_status := FND_API.g_ret_sts_error;

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

917: IF p_enty_attr_val_rec.created_by = FND_API.g_miss_num
918: OR p_enty_attr_val_rec.created_by 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','created_by');
922: FND_MSG_PUB.add;
923: END IF;
924: x_return_status := FND_API.g_ret_sts_error;
925: RETURN;

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

928:
929: IF p_enty_attr_val_rec.last_update_login = FND_API.g_miss_num
930: OR p_enty_attr_val_rec.last_update_login 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','last_update_login');
934: FND_MSG_PUB.add;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_error;

Line 933: FND_MESSAGE.set_token('COLUMN','last_update_login');

929: IF p_enty_attr_val_rec.last_update_login = FND_API.g_miss_num
930: OR p_enty_attr_val_rec.last_update_login 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','last_update_login');
934: FND_MSG_PUB.add;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;

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

940:
941: IF p_enty_attr_val_rec.object_version_number = FND_API.g_miss_num
942: OR p_enty_attr_val_rec.object_version_number 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','object_version_number');
946: FND_MSG_PUB.add;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;

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

941: IF p_enty_attr_val_rec.object_version_number = FND_API.g_miss_num
942: OR p_enty_attr_val_rec.object_version_number 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','object_version_number');
946: FND_MSG_PUB.add;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;
949: RETURN;

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

952:
953: IF p_enty_attr_val_rec.entity = FND_API.g_miss_char
954: OR p_enty_attr_val_rec.entity 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','entity');
958: FND_MSG_PUB.add;
959: END IF;
960: x_return_status := FND_API.g_ret_sts_error;

Line 957: FND_MESSAGE.set_token('COLUMN','entity');

953: IF p_enty_attr_val_rec.entity = FND_API.g_miss_char
954: OR p_enty_attr_val_rec.entity 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','entity');
958: FND_MSG_PUB.add;
959: END IF;
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;

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

964:
965: IF p_enty_attr_val_rec.attribute_id = FND_API.g_miss_num
966: OR p_enty_attr_val_rec.attribute_id 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','attribute_id');
970: FND_MSG_PUB.add;
971: END IF;
972: x_return_status := FND_API.g_ret_sts_error;

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

965: IF p_enty_attr_val_rec.attribute_id = FND_API.g_miss_num
966: OR p_enty_attr_val_rec.attribute_id 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','attribute_id');
970: FND_MSG_PUB.add;
971: END IF;
972: x_return_status := FND_API.g_ret_sts_error;
973: RETURN;

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

976:
977: IF p_enty_attr_val_rec.enabled_flag = FND_API.g_miss_char
978: OR p_enty_attr_val_rec.enabled_flag 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','enabled_flag');
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','enabled_flag');

977: IF p_enty_attr_val_rec.enabled_flag = FND_API.g_miss_char
978: OR p_enty_attr_val_rec.enabled_flag 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','enabled_flag');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;

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

988:
989: IF p_enty_attr_val_rec.entity_id = FND_API.g_miss_num
990: OR p_enty_attr_val_rec.entity_id IS NULL THEN
991: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
992: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
993: FND_MESSAGE.set_token('COLUMN','entity_id');
994: FND_MSG_PUB.add;
995: END IF;
996: x_return_status := FND_API.g_ret_sts_error;

Line 993: FND_MESSAGE.set_token('COLUMN','entity_id');

989: IF p_enty_attr_val_rec.entity_id = FND_API.g_miss_num
990: OR p_enty_attr_val_rec.entity_id IS NULL THEN
991: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
992: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
993: FND_MESSAGE.set_token('COLUMN','entity_id');
994: FND_MSG_PUB.add;
995: END IF;
996: x_return_status := FND_API.g_ret_sts_error;
997: RETURN;

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

1000: ELSE
1001:
1002: IF p_enty_attr_val_rec.enty_attr_val_id IS NULL THEN
1003: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1004: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1005: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');
1006: FND_MSG_PUB.add;
1007: END IF;
1008: x_return_status := FND_API.g_ret_sts_error;

Line 1005: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');

1001:
1002: IF p_enty_attr_val_rec.enty_attr_val_id IS NULL THEN
1003: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1004: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1005: FND_MESSAGE.set_token('COLUMN','enty_attr_val_id');
1006: FND_MSG_PUB.add;
1007: END IF;
1008: x_return_status := FND_API.g_ret_sts_error;
1009: RETURN;

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

1011:
1012:
1013: IF p_enty_attr_val_rec.last_update_date IS NULL THEN
1014: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1015: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1016: FND_MESSAGE.set_token('COLUMN','last_update_date');
1017: FND_MSG_PUB.add;
1018: END IF;
1019: x_return_status := FND_API.g_ret_sts_error;

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

1012:
1013: IF p_enty_attr_val_rec.last_update_date IS NULL THEN
1014: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1015: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1016: FND_MESSAGE.set_token('COLUMN','last_update_date');
1017: FND_MSG_PUB.add;
1018: END IF;
1019: x_return_status := FND_API.g_ret_sts_error;
1020: RETURN;

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

1022:
1023:
1024: IF p_enty_attr_val_rec.last_updated_by IS NULL THEN
1025: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1026: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1027: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1028: FND_MSG_PUB.add;
1029: END IF;
1030: x_return_status := FND_API.g_ret_sts_error;

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

1023:
1024: IF p_enty_attr_val_rec.last_updated_by IS NULL THEN
1025: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1026: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1027: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1028: FND_MSG_PUB.add;
1029: END IF;
1030: x_return_status := FND_API.g_ret_sts_error;
1031: RETURN;

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

1033:
1034:
1035: IF p_enty_attr_val_rec.creation_date IS NULL THEN
1036: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1037: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1038: FND_MESSAGE.set_token('COLUMN','creation_date');
1039: FND_MSG_PUB.add;
1040: END IF;
1041: x_return_status := FND_API.g_ret_sts_error;

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

1034:
1035: IF p_enty_attr_val_rec.creation_date IS NULL THEN
1036: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1037: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1038: FND_MESSAGE.set_token('COLUMN','creation_date');
1039: FND_MSG_PUB.add;
1040: END IF;
1041: x_return_status := FND_API.g_ret_sts_error;
1042: RETURN;

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

1045:
1046: IF p_enty_attr_val_rec.created_by IS NULL THEN
1047:
1048: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1049: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1050: FND_MESSAGE.set_token('COLUMN','created_by');
1051: FND_MSG_PUB.add;
1052: END IF;
1053: x_return_status := FND_API.g_ret_sts_error;

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

1046: IF p_enty_attr_val_rec.created_by IS NULL THEN
1047:
1048: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1049: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1050: FND_MESSAGE.set_token('COLUMN','created_by');
1051: FND_MSG_PUB.add;
1052: END IF;
1053: x_return_status := FND_API.g_ret_sts_error;
1054: RETURN;

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

1056:
1057:
1058: IF p_enty_attr_val_rec.last_update_login IS NULL THEN
1059: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1060: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1061: FND_MESSAGE.set_token('COLUMN','last_update_login');
1062: FND_MSG_PUB.add;
1063: END IF;
1064: x_return_status := FND_API.g_ret_sts_error;

Line 1061: FND_MESSAGE.set_token('COLUMN','last_update_login');

1057:
1058: IF p_enty_attr_val_rec.last_update_login IS NULL THEN
1059: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1060: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1061: FND_MESSAGE.set_token('COLUMN','last_update_login');
1062: FND_MSG_PUB.add;
1063: END IF;
1064: x_return_status := FND_API.g_ret_sts_error;
1065: RETURN;

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

1067:
1068:
1069: IF p_enty_attr_val_rec.object_version_number IS NULL THEN
1070: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1071: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN','object_version_number');
1073: FND_MSG_PUB.add;
1074: END IF;
1075: x_return_status := FND_API.g_ret_sts_error;

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

1068:
1069: IF p_enty_attr_val_rec.object_version_number IS NULL THEN
1070: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1071: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1072: FND_MESSAGE.set_token('COLUMN','object_version_number');
1073: FND_MSG_PUB.add;
1074: END IF;
1075: x_return_status := FND_API.g_ret_sts_error;
1076: RETURN;

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

1078:
1079:
1080: IF p_enty_attr_val_rec.entity IS NULL THEN
1081: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1082: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1083: FND_MESSAGE.set_token('COLUMN','entity');
1084: FND_MSG_PUB.add;
1085: END IF;
1086: x_return_status := FND_API.g_ret_sts_error;

Line 1083: FND_MESSAGE.set_token('COLUMN','entity');

1079:
1080: IF p_enty_attr_val_rec.entity IS NULL THEN
1081: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1082: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1083: FND_MESSAGE.set_token('COLUMN','entity');
1084: FND_MSG_PUB.add;
1085: END IF;
1086: x_return_status := FND_API.g_ret_sts_error;
1087: RETURN;

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

1089:
1090:
1091: IF p_enty_attr_val_rec.attribute_id IS NULL THEN
1092: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1093: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1094: FND_MESSAGE.set_token('COLUMN','attribute_id');
1095: FND_MSG_PUB.add;
1096: END IF;
1097: x_return_status := FND_API.g_ret_sts_error;

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

1090:
1091: IF p_enty_attr_val_rec.attribute_id IS NULL THEN
1092: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1093: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1094: FND_MESSAGE.set_token('COLUMN','attribute_id');
1095: FND_MSG_PUB.add;
1096: END IF;
1097: x_return_status := FND_API.g_ret_sts_error;
1098: RETURN;

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

1100:
1101:
1102: IF p_enty_attr_val_rec.enabled_flag IS NULL THEN
1103: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1104: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1105: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1106: FND_MSG_PUB.add;
1107: END IF;
1108: x_return_status := FND_API.g_ret_sts_error;

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

1101:
1102: IF p_enty_attr_val_rec.enabled_flag IS NULL THEN
1103: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1104: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1105: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1106: FND_MSG_PUB.add;
1107: END IF;
1108: x_return_status := FND_API.g_ret_sts_error;
1109: RETURN;

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

1111:
1112:
1113: IF p_enty_attr_val_rec.entity_id IS NULL THEN
1114: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1115: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1116: FND_MESSAGE.set_token('COLUMN','entity_id');
1117: FND_MSG_PUB.add;
1118: END IF;
1119: x_return_status := FND_API.g_ret_sts_error;

Line 1116: FND_MESSAGE.set_token('COLUMN','entity_id');

1112:
1113: IF p_enty_attr_val_rec.entity_id IS NULL THEN
1114: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1115: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1116: FND_MESSAGE.set_token('COLUMN','entity_id');
1117: FND_MSG_PUB.add;
1118: END IF;
1119: x_return_status := FND_API.g_ret_sts_error;
1120: RETURN;

Line 1167: FND_MESSAGE.set_name('PV', 'PV_ATTRIBUTE_NOT_EXISTS');

1163: end loop;
1164:
1165: if(l_exists = false) then
1166: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1167: FND_MESSAGE.set_name('PV', 'PV_ATTRIBUTE_NOT_EXISTS');
1168: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);
1169: FND_MSG_PUB.add;
1170: END IF;
1171: x_return_status := FND_API.g_ret_sts_error;

Line 1168: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);

1164:
1165: if(l_exists = false) then
1166: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1167: FND_MESSAGE.set_name('PV', 'PV_ATTRIBUTE_NOT_EXISTS');
1168: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);
1169: FND_MSG_PUB.add;
1170: END IF;
1171: x_return_status := FND_API.g_ret_sts_error;
1172: return;

Line 1184: FND_MESSAGE.set_name('PV', 'PV_ATTR_ENTITY_NOT_EXISTS');

1180: end loop;
1181:
1182: if(l_exists = false) then
1183: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1184: FND_MESSAGE.set_name('PV', 'PV_ATTR_ENTITY_NOT_EXISTS');
1185: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);
1186: FND_MESSAGE.set_token('ENTITY',p_enty_attr_val_rec.entity);
1187: FND_MSG_PUB.add;
1188: END IF;

Line 1185: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);

1181:
1182: if(l_exists = false) then
1183: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1184: FND_MESSAGE.set_name('PV', 'PV_ATTR_ENTITY_NOT_EXISTS');
1185: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);
1186: FND_MESSAGE.set_token('ENTITY',p_enty_attr_val_rec.entity);
1187: FND_MSG_PUB.add;
1188: END IF;
1189: x_return_status := FND_API.g_ret_sts_error;

Line 1186: FND_MESSAGE.set_token('ENTITY',p_enty_attr_val_rec.entity);

1182: if(l_exists = false) then
1183: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1184: FND_MESSAGE.set_name('PV', 'PV_ATTR_ENTITY_NOT_EXISTS');
1185: FND_MESSAGE.set_token('ATTRIBUTE_ID',p_enty_attr_val_rec.attribute_id);
1186: FND_MESSAGE.set_token('ENTITY',p_enty_attr_val_rec.entity);
1187: FND_MSG_PUB.add;
1188: END IF;
1189: x_return_status := FND_API.g_ret_sts_error;
1190: return;