APPS.PV_ATTRIBUTE_CODE_PVT dependencies on FND_MESSAGE

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

108:
109: IF FND_GLOBAL.User_Id IS NULL
110: THEN
111: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
112: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
113: FND_MSG_PUB.add;
114: end if;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;

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

352: FETCH c_get_attribute_code INTO l_ref_attribute_code_rec ;
353:
354: IF ( c_get_attribute_code%NOTFOUND) THEN
355: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));
360: FND_MSG_PUB.add;

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

353:
354: IF ( c_get_attribute_code%NOTFOUND) THEN
355: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));
360: FND_MSG_PUB.add;
361: end if;

Line 358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');

354: IF ( c_get_attribute_code%NOTFOUND) THEN
355: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));
360: FND_MSG_PUB.add;
361: end if;
362: RAISE FND_API.G_EXC_ERROR;

Line 359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));

355: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));
360: FND_MSG_PUB.add;
361: end if;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;

Line 376: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_SEEDED');

372: --check for seeded attribute code
373: /* if(p_attribute_code_rec.attr_code_id <10000) then
374: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
375: THEN
376: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_SEEDED');
377: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
378: FND_MSG_PUB.Add;
379: END IF;
380: RAISE FND_API.G_EXC_ERROR;

Line 377: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );

373: /* if(p_attribute_code_rec.attr_code_id <10000) then
374: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
375: THEN
376: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_SEEDED');
377: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
378: FND_MSG_PUB.Add;
379: END IF;
380: RAISE FND_API.G_EXC_ERROR;
381: end if;

Line 396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');

392: if(l_delete_flag = 'N') then
393:
394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');
397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
399: FND_MSG_PUB.Add;
400: END IF;

Line 397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );

393:
394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');
397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
399: FND_MSG_PUB.Add;
400: END IF;
401:

Line 398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );

394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');
397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
399: FND_MSG_PUB.Add;
400: END IF;
401:
402: RAISE FND_API.G_EXC_ERROR;

Line 423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');

419: if(l_delete_flag = 'N') then
420:
421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');
424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );
426: FND_MSG_PUB.Add;
427: END IF;

Line 424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );

420:
421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');
424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );
426: FND_MSG_PUB.Add;
427: END IF;
428:

Line 425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );

421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');
424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );
426: FND_MSG_PUB.Add;
427: END IF;
428:
429: RAISE FND_API.G_EXC_ERROR;

Line 444: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');

440: l_delete_flag := 'N';
441: l_being_used_list := l_being_used_list || ','|| x.entity ;
442: end loop;
443: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
444: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
445: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
446: FND_MSG_PUB.add;
447: END IF;
448:

Line 445: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );

441: l_being_used_list := l_being_used_list || ','|| x.entity ;
442: end loop;
443: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
444: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
445: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
446: FND_MSG_PUB.add;
447: END IF;
448:
449:

Line 454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');

450: if(l_delete_flag = 'N') then
451:
452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');
455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
457: FND_MSG_PUB.Add;
458: END IF;

Line 455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );

451:
452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');
455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
457: FND_MSG_PUB.Add;
458: END IF;
459:

Line 456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );

452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');
455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
457: FND_MSG_PUB.Add;
458: END IF;
459:
460: RAISE FND_API.G_EXC_ERROR;

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

467: IF (l_tar_attribute_code_rec.object_version_number is NULL or
468: l_tar_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM ) Then
469:
470: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
471: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
472: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_code_rec.last_update_date));
473: FND_MSG_PUB.add;
474: end if;
475: RAISE FND_API.G_EXC_ERROR;

Line 472: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_code_rec.last_update_date));

468: l_tar_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM ) Then
469:
470: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
471: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
472: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_code_rec.last_update_date));
473: FND_MSG_PUB.add;
474: end if;
475: RAISE FND_API.G_EXC_ERROR;
476: End if;

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

477:
478: -- Check Whether record has been changed by someone else
479: If (l_tar_attribute_code_rec.object_version_number <> l_ref_attribute_code_rec.object_version_number) Then
480: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
481: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
482: FND_MESSAGE.set_token('VALUE','Attribute_Code');
483: FND_MSG_PUB.add;
484: end if;
485: RAISE FND_API.G_EXC_ERROR;

Line 482: FND_MESSAGE.set_token('VALUE','Attribute_Code');

478: -- Check Whether record has been changed by someone else
479: If (l_tar_attribute_code_rec.object_version_number <> l_ref_attribute_code_rec.object_version_number) Then
480: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
481: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
482: FND_MESSAGE.set_token('VALUE','Attribute_Code');
483: FND_MSG_PUB.add;
484: end if;
485: RAISE FND_API.G_EXC_ERROR;
486: End if;

Line 697: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');

693: loop
694: l_attr_code := x.attr_code;
695:
696: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
697: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
698: FND_MESSAGE.set_token('TEXT', 'Attr Code:-- '|| l_attr_code);
699: FND_MSG_PUB.add;
700: END IF;
701: end loop;

Line 698: FND_MESSAGE.set_token('TEXT', 'Attr Code:-- '|| l_attr_code);

694: l_attr_code := x.attr_code;
695:
696: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
697: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
698: FND_MESSAGE.set_token('TEXT', 'Attr Code:-- '|| l_attr_code);
699: FND_MSG_PUB.add;
700: END IF;
701: end loop;
702:

Line 712: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');

708:
709: l_attribute_name := x.name;
710:
711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
712: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
713: FND_MESSAGE.set_token('TEXT', 'Attr:-- '|| l_attribute_id );
714: FND_MSG_PUB.add;
715: END IF;
716: end loop;

Line 713: FND_MESSAGE.set_token('TEXT', 'Attr:-- '|| l_attribute_id );

709: l_attribute_name := x.name;
710:
711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
712: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
713: FND_MESSAGE.set_token('TEXT', 'Attr:-- '|| l_attribute_id );
714: FND_MSG_PUB.add;
715: END IF;
716: end loop;
717:

Line 722: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');

718: --check for seeded attribute code
719: if(p_attr_code_id <10000) then
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');
723: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
724: FND_MSG_PUB.Add;
725: END IF;
726: RAISE FND_API.G_EXC_ERROR;

Line 723: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );

719: if(p_attr_code_id <10000) then
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');
723: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
724: FND_MSG_PUB.Add;
725: END IF;
726: RAISE FND_API.G_EXC_ERROR;
727: end if;

Line 742: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_VADOF_RESELLERS');

738: if(l_delete_flag = 'N') then
739:
740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
741: THEN
742: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_VADOF_RESELLERS');
743: FND_MESSAGE.Set_Token('NAME',l_attribute_name );
744: FND_MSG_PUB.Add;
745: END IF;
746:

Line 743: FND_MESSAGE.Set_Token('NAME',l_attribute_name );

739:
740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
741: THEN
742: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_VADOF_RESELLERS');
743: FND_MESSAGE.Set_Token('NAME',l_attribute_name );
744: FND_MSG_PUB.Add;
745: END IF;
746:
747: RAISE FND_API.G_EXC_ERROR;

Line 762: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_USAGE');

758: if(l_delete_flag = 'N') then
759:
760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_USAGE');
763: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
764: FND_MSG_PUB.Add;
765: END IF;
766:

Line 763: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );

759:
760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_USAGE');
763: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
764: FND_MSG_PUB.Add;
765: END IF;
766:
767: RAISE FND_API.G_EXC_ERROR;

Line 791: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');

787: l_meaning:='';
788: end loop;
789:
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
792: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
793: FND_MSG_PUB.add;
794: END IF;
795:

Line 792: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );

788: end loop;
789:
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
792: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
793: FND_MSG_PUB.add;
794: END IF;
795:
796:

Line 801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');

797: if(l_delete_flag = 'N') then
798:
799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');
802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
804: FND_MSG_PUB.Add;
805: END IF;

Line 802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );

798:
799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');
802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
804: FND_MSG_PUB.Add;
805: END IF;
806:

Line 803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );

799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');
802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
804: FND_MSG_PUB.Add;
805: END IF;
806:
807: RAISE FND_API.G_EXC_ERROR;

Line 823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');

819: if(l_delete_flag = 'N') then
820:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
826: FND_MSG_PUB.Add;
827: END IF;

Line 824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );

820:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
826: FND_MSG_PUB.Add;
827: END IF;
828:

Line 825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );

821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
826: FND_MSG_PUB.Add;
827: END IF;
828:
829: RAISE FND_API.G_EXC_ERROR;

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

971:
972: IF (c_Attribute_Code%NOTFOUND) THEN
973: CLOSE c_Attribute_Code;
974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
976: FND_MSG_PUB.add;
977: END IF;
978: RAISE FND_API.g_exc_error;
979: END IF;

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

1060:
1061:
1062: IF l_valid_flag = FND_API.g_false THEN
1063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1064: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );
1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1067: FND_MSG_PUB.add;
1068: END IF;

Line 1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );

1061:
1062: IF l_valid_flag = FND_API.g_false THEN
1063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1064: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );
1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.g_ret_sts_error;

Line 1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');

1062: IF l_valid_flag = FND_API.g_false THEN
1063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1064: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );
1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.g_ret_sts_error;
1070: RETURN;

Line 1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');

1076: loop
1077: if (UPPER(p_attribute_code_rec.attr_code)=UPPER(x.attr_code)) then
1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1079:
1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);
1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1084: FND_MSG_PUB.add;

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

1077: if (UPPER(p_attribute_code_rec.attr_code)=UPPER(x.attr_code)) then
1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1079:
1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);
1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1084: FND_MSG_PUB.add;
1085: END IF;

Line 1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);

1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1079:
1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);
1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1084: FND_MSG_PUB.add;
1085: END IF;
1086: --x_return_status := FND_API.g_ret_sts_error;

Line 1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');

1079:
1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);
1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1084: FND_MSG_PUB.add;
1085: END IF;
1086: --x_return_status := FND_API.g_ret_sts_error;
1087: RAISE FND_API.G_EXC_ERROR;

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

1105:
1106: IF p_attribute_code_rec.attr_code_id = FND_API.G_MISS_NUM
1107: OR p_attribute_code_rec.attr_code_id IS NULL THEN
1108: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1109: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1110: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1111: FND_MSG_PUB.add;
1112: END IF;
1113: x_return_status := FND_API.g_ret_sts_error;

Line 1110: FND_MESSAGE.set_token('COLUMN','attr_code_id');

1106: IF p_attribute_code_rec.attr_code_id = FND_API.G_MISS_NUM
1107: OR p_attribute_code_rec.attr_code_id IS NULL THEN
1108: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1109: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1110: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1111: FND_MSG_PUB.add;
1112: END IF;
1113: x_return_status := FND_API.g_ret_sts_error;
1114: RETURN;

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

1116:
1117: IF p_attribute_code_rec.attr_code = FND_API.G_MISS_CHAR
1118: OR p_attribute_code_rec.attr_code IS NULL THEN
1119: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1120: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1121: FND_MESSAGE.set_token('COLUMN','attr_code');
1122: FND_MSG_PUB.add;
1123: END IF;
1124: x_return_status := FND_API.g_ret_sts_error;

Line 1121: FND_MESSAGE.set_token('COLUMN','attr_code');

1117: IF p_attribute_code_rec.attr_code = FND_API.G_MISS_CHAR
1118: OR p_attribute_code_rec.attr_code IS NULL THEN
1119: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1120: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1121: FND_MESSAGE.set_token('COLUMN','attr_code');
1122: FND_MSG_PUB.add;
1123: END IF;
1124: x_return_status := FND_API.g_ret_sts_error;
1125: RETURN;

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

1127:
1128: IF p_attribute_code_rec.last_update_date = FND_API.G_MISS_DATE
1129: OR p_attribute_code_rec.last_update_date IS NULL THEN
1130: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1131: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','last_update_date');
1133: FND_MSG_PUB.add;
1134: END IF;
1135: x_return_status := FND_API.g_ret_sts_error;

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

1128: IF p_attribute_code_rec.last_update_date = FND_API.G_MISS_DATE
1129: OR p_attribute_code_rec.last_update_date IS NULL THEN
1130: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1131: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','last_update_date');
1133: FND_MSG_PUB.add;
1134: END IF;
1135: x_return_status := FND_API.g_ret_sts_error;
1136: RETURN;

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

1138:
1139: IF p_attribute_code_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR p_attribute_code_rec.last_updated_by IS NULL THEN
1141: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1142: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1143: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1144: FND_MSG_PUB.add;
1145: END IF;
1146: x_return_status := FND_API.g_ret_sts_error;

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

1139: IF p_attribute_code_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR p_attribute_code_rec.last_updated_by IS NULL THEN
1141: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1142: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1143: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1144: FND_MSG_PUB.add;
1145: END IF;
1146: x_return_status := FND_API.g_ret_sts_error;
1147: RETURN;

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

1149:
1150: IF p_attribute_code_rec.creation_date = FND_API.G_MISS_DATE
1151: OR p_attribute_code_rec.creation_date IS NULL THEN
1152: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1153: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1154: FND_MESSAGE.set_token('COLUMN','creation_date');
1155: FND_MSG_PUB.add;
1156: END IF;
1157: x_return_status := FND_API.g_ret_sts_error;

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

1150: IF p_attribute_code_rec.creation_date = FND_API.G_MISS_DATE
1151: OR p_attribute_code_rec.creation_date IS NULL THEN
1152: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1153: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1154: FND_MESSAGE.set_token('COLUMN','creation_date');
1155: FND_MSG_PUB.add;
1156: END IF;
1157: x_return_status := FND_API.g_ret_sts_error;
1158: RETURN;

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

1160:
1161: IF p_attribute_code_rec.created_by = FND_API.G_MISS_NUM
1162: OR p_attribute_code_rec.created_by IS NULL THEN
1163: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1164: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1165: FND_MESSAGE.set_token('COLUMN','created_by');
1166: FND_MSG_PUB.add;
1167: END IF;
1168: x_return_status := FND_API.g_ret_sts_error;

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

1161: IF p_attribute_code_rec.created_by = FND_API.G_MISS_NUM
1162: OR p_attribute_code_rec.created_by IS NULL THEN
1163: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1164: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1165: FND_MESSAGE.set_token('COLUMN','created_by');
1166: FND_MSG_PUB.add;
1167: END IF;
1168: x_return_status := FND_API.g_ret_sts_error;
1169: RETURN;

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

1171:
1172: IF p_attribute_code_rec.last_update_login = FND_API.G_MISS_NUM
1173: OR p_attribute_code_rec.last_update_login IS NULL THEN
1174: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1175: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1176: FND_MESSAGE.set_token('COLUMN','last_update_login');
1177: FND_MSG_PUB.add;
1178: END IF;
1179: x_return_status := FND_API.g_ret_sts_error;

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

1172: IF p_attribute_code_rec.last_update_login = FND_API.G_MISS_NUM
1173: OR p_attribute_code_rec.last_update_login IS NULL THEN
1174: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1175: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1176: FND_MESSAGE.set_token('COLUMN','last_update_login');
1177: FND_MSG_PUB.add;
1178: END IF;
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;

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

1182:
1183: IF p_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM
1184: OR p_attribute_code_rec.object_version_number IS NULL THEN
1185: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1186: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','object_version_number');
1188: FND_MSG_PUB.add;
1189: END IF;
1190: x_return_status := FND_API.g_ret_sts_error;

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

1183: IF p_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM
1184: OR p_attribute_code_rec.object_version_number IS NULL THEN
1185: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1186: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','object_version_number');
1188: FND_MSG_PUB.add;
1189: END IF;
1190: x_return_status := FND_API.g_ret_sts_error;
1191: RETURN;

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

1193:
1194: IF p_attribute_code_rec.attribute_id = FND_API.G_MISS_NUM
1195: OR p_attribute_code_rec.attribute_id IS NULL THEN
1196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1197: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1198: FND_MESSAGE.set_token('COLUMN','attribute_id');
1199: FND_MSG_PUB.add;
1200: END IF;
1201: x_return_status := FND_API.g_ret_sts_error;

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

1194: IF p_attribute_code_rec.attribute_id = FND_API.G_MISS_NUM
1195: OR p_attribute_code_rec.attribute_id IS NULL THEN
1196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1197: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1198: FND_MESSAGE.set_token('COLUMN','attribute_id');
1199: FND_MSG_PUB.add;
1200: END IF;
1201: x_return_status := FND_API.g_ret_sts_error;
1202: RETURN;

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

1204:
1205: IF p_attribute_code_rec.enabled_flag = FND_API.G_MISS_CHAR
1206: OR p_attribute_code_rec.enabled_flag IS NULL THEN
1207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1208: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1209: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1210: FND_MSG_PUB.add;
1211: END IF;
1212: x_return_status := FND_API.g_ret_sts_error;

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

1205: IF p_attribute_code_rec.enabled_flag = FND_API.G_MISS_CHAR
1206: OR p_attribute_code_rec.enabled_flag IS NULL THEN
1207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1208: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1209: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1210: FND_MSG_PUB.add;
1211: END IF;
1212: x_return_status := FND_API.g_ret_sts_error;
1213: RETURN;

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

1216:
1217: IF p_attribute_code_rec.description = FND_API.G_MISS_CHAR
1218: OR p_attribute_code_rec.description IS NULL THEN
1219: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1220: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1221: FND_MESSAGE.set_token('COLUMN','description');
1222: FND_MSG_PUB.add;
1223: END IF;
1224: x_return_status := FND_API.g_ret_sts_error;

Line 1221: FND_MESSAGE.set_token('COLUMN','description');

1217: IF p_attribute_code_rec.description = FND_API.G_MISS_CHAR
1218: OR p_attribute_code_rec.description IS NULL THEN
1219: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1220: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1221: FND_MESSAGE.set_token('COLUMN','description');
1222: FND_MSG_PUB.add;
1223: END IF;
1224: x_return_status := FND_API.g_ret_sts_error;
1225: RETURN;

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

1228: ELSE
1229:
1230: IF p_attribute_code_rec.attr_code_id IS NULL THEN
1231: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1232: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1233: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1234: FND_MSG_PUB.add;
1235: END IF;
1236: x_return_status := FND_API.g_ret_sts_error;

Line 1233: FND_MESSAGE.set_token('COLUMN','attr_code_id');

1229:
1230: IF p_attribute_code_rec.attr_code_id IS NULL THEN
1231: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1232: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1233: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1234: FND_MSG_PUB.add;
1235: END IF;
1236: x_return_status := FND_API.g_ret_sts_error;
1237: RETURN;

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

1238: END IF;
1239:
1240: IF p_attribute_code_rec.attr_code IS NULL THEN
1241: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1242: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1243: FND_MESSAGE.set_token('COLUMN','attr_code');
1244: FND_MSG_PUB.add;
1245: END IF;
1246: x_return_status := FND_API.g_ret_sts_error;

Line 1243: FND_MESSAGE.set_token('COLUMN','attr_code');

1239:
1240: IF p_attribute_code_rec.attr_code IS NULL THEN
1241: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1242: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1243: FND_MESSAGE.set_token('COLUMN','attr_code');
1244: FND_MSG_PUB.add;
1245: END IF;
1246: x_return_status := FND_API.g_ret_sts_error;
1247: RETURN;

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

1248: END IF;
1249:
1250: IF p_attribute_code_rec.last_update_date IS NULL THEN
1251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1252: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1253: FND_MESSAGE.set_token('COLUMN','last_update_date');
1254: FND_MSG_PUB.add;
1255: END IF;
1256: x_return_status := FND_API.g_ret_sts_error;

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

1249:
1250: IF p_attribute_code_rec.last_update_date IS NULL THEN
1251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1252: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1253: FND_MESSAGE.set_token('COLUMN','last_update_date');
1254: FND_MSG_PUB.add;
1255: END IF;
1256: x_return_status := FND_API.g_ret_sts_error;
1257: RETURN;

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

1258: END IF;
1259:
1260: IF p_attribute_code_rec.last_updated_by IS NULL THEN
1261: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1262: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1263: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1264: FND_MSG_PUB.add;
1265: END IF;
1266: x_return_status := FND_API.g_ret_sts_error;

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

1259:
1260: IF p_attribute_code_rec.last_updated_by IS NULL THEN
1261: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1262: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1263: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1264: FND_MSG_PUB.add;
1265: END IF;
1266: x_return_status := FND_API.g_ret_sts_error;
1267: RETURN;

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

1268: END IF;
1269:
1270: IF p_attribute_code_rec.creation_date IS NULL THEN
1271: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1272: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1273: FND_MESSAGE.set_token('COLUMN','creation_date');
1274: FND_MSG_PUB.add;
1275: END IF;
1276: x_return_status := FND_API.g_ret_sts_error;

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

1269:
1270: IF p_attribute_code_rec.creation_date IS NULL THEN
1271: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1272: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1273: FND_MESSAGE.set_token('COLUMN','creation_date');
1274: FND_MSG_PUB.add;
1275: END IF;
1276: x_return_status := FND_API.g_ret_sts_error;
1277: RETURN;

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

1278: END IF;
1279:
1280: IF p_attribute_code_rec.created_by IS NULL THEN
1281: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1282: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1283: FND_MESSAGE.set_token('COLUMN','created_by');
1284: FND_MSG_PUB.add;
1285: END IF;
1286: x_return_status := FND_API.g_ret_sts_error;

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

1279:
1280: IF p_attribute_code_rec.created_by IS NULL THEN
1281: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1282: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1283: FND_MESSAGE.set_token('COLUMN','created_by');
1284: FND_MSG_PUB.add;
1285: END IF;
1286: x_return_status := FND_API.g_ret_sts_error;
1287: RETURN;

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

1288: END IF;
1289:
1290: IF p_attribute_code_rec.last_update_login IS NULL THEN
1291: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1292: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1293: FND_MESSAGE.set_token('COLUMN','last_update_login');
1294: FND_MSG_PUB.add;
1295: END IF;
1296: x_return_status := FND_API.g_ret_sts_error;

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

1289:
1290: IF p_attribute_code_rec.last_update_login IS NULL THEN
1291: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1292: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1293: FND_MESSAGE.set_token('COLUMN','last_update_login');
1294: FND_MSG_PUB.add;
1295: END IF;
1296: x_return_status := FND_API.g_ret_sts_error;
1297: RETURN;

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

1298: END IF;
1299:
1300: IF p_attribute_code_rec.object_version_number IS NULL THEN
1301: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1302: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1303: FND_MESSAGE.set_token('COLUMN','object_version_number');
1304: FND_MSG_PUB.add;
1305: END IF;
1306: x_return_status := FND_API.g_ret_sts_error;

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

1299:
1300: IF p_attribute_code_rec.object_version_number IS NULL THEN
1301: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1302: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1303: FND_MESSAGE.set_token('COLUMN','object_version_number');
1304: FND_MSG_PUB.add;
1305: END IF;
1306: x_return_status := FND_API.g_ret_sts_error;
1307: RETURN;

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

1308: END IF;
1309:
1310: IF p_attribute_code_rec.attribute_id IS NULL THEN
1311: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1312: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1313: FND_MESSAGE.set_token('COLUMN','attribute_id');
1314: FND_MSG_PUB.add;
1315: END IF;
1316: x_return_status := FND_API.g_ret_sts_error;

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

1309:
1310: IF p_attribute_code_rec.attribute_id IS NULL THEN
1311: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1312: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1313: FND_MESSAGE.set_token('COLUMN','attribute_id');
1314: FND_MSG_PUB.add;
1315: END IF;
1316: x_return_status := FND_API.g_ret_sts_error;
1317: RETURN;

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

1318: END IF;
1319:
1320: IF p_attribute_code_rec.enabled_flag IS NULL THEN
1321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1322: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1323: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1324: FND_MSG_PUB.add;
1325: END IF;
1326: x_return_status := FND_API.g_ret_sts_error;

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

1319:
1320: IF p_attribute_code_rec.enabled_flag IS NULL THEN
1321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1322: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1323: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1324: FND_MSG_PUB.add;
1325: END IF;
1326: x_return_status := FND_API.g_ret_sts_error;
1327: RETURN;

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

1330:
1331:
1332: IF p_attribute_code_rec.description IS NULL THEN
1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1335: FND_MESSAGE.set_token('COLUMN','description');
1336: FND_MSG_PUB.add;
1337: END IF;
1338: x_return_status := FND_API.g_ret_sts_error;

Line 1335: FND_MESSAGE.set_token('COLUMN','description');

1331:
1332: IF p_attribute_code_rec.description IS NULL THEN
1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1335: FND_MESSAGE.set_token('COLUMN','description');
1336: FND_MSG_PUB.add;
1337: END IF;
1338: x_return_status := FND_API.g_ret_sts_error;
1339: RETURN;