APPS.PV_ATTRIBUTE_PVT dependencies on FND_MESSAGE

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

110: -- =========================================================================
111:
112: IF FND_GLOBAL.User_Id IS NULL
113: THEN
114: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
115: FND_MSG_PUB.add;
116: RAISE FND_API.G_EXC_ERROR;
117: END IF;
118:

Line 160: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_TYPE_STYLE_NOT_CREATE');

156: (l_attribute_rec.attribute_type = 'FUNCTION' and l_attribute_rec.display_style not in ('NUMBER','STRING','LOV','DATE','CURRENCY','PERCENTAGE'))
157: ) THEN
158:
159: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
160: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_TYPE_STYLE_NOT_CREATE');
161:
162: FOR x IN (select meaning from pv_lookups
163: where lookup_type = 'PV_ATTRIBUTE_TYPE'
164: and lookup_code = l_attribute_rec.attribute_type

Line 168: Fnd_Message.set_token('ATTRIBUTE_TYPE',l_meaning);

164: and lookup_code = l_attribute_rec.attribute_type
165: ) LOOP
166: l_meaning := x.meaning;
167: END LOOP;
168: Fnd_Message.set_token('ATTRIBUTE_TYPE',l_meaning);
169:
170: FOR x IN (select meaning from pv_lookups
171: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
172: and lookup_code = l_attribute_rec.display_style

Line 176: FND_MESSAGE.Set_Token('DISPLAY_STYLE',l_meaning );

172: and lookup_code = l_attribute_rec.display_style
173: ) LOOP
174: l_meaning := x.meaning;
175: END LOOP;
176: FND_MESSAGE.Set_Token('DISPLAY_STYLE',l_meaning );
177: FND_MSG_PUB.Add;
178: END IF;
179:
180: RAISE FND_API.G_EXC_ERROR;

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

387: FETCH c_get_Attribute INTO l_ref_attribute_rec ;
388:
389: IF ( c_get_Attribute%NOTFOUND) THEN
390: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
391: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
392: FND_MESSAGE.set_token('MODE','Update');
393: FND_MESSAGE.set_token('ENTITY','Attribute');
394: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_rec.attribute_id));
395: FND_MSG_PUB.add;

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

388:
389: IF ( c_get_Attribute%NOTFOUND) THEN
390: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
391: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
392: FND_MESSAGE.set_token('MODE','Update');
393: FND_MESSAGE.set_token('ENTITY','Attribute');
394: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_rec.attribute_id));
395: FND_MSG_PUB.add;
396: END IF;

Line 393: FND_MESSAGE.set_token('ENTITY','Attribute');

389: IF ( c_get_Attribute%NOTFOUND) THEN
390: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
391: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
392: FND_MESSAGE.set_token('MODE','Update');
393: FND_MESSAGE.set_token('ENTITY','Attribute');
394: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_rec.attribute_id));
395: FND_MSG_PUB.add;
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;

Line 394: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_rec.attribute_id));

390: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
391: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
392: FND_MESSAGE.set_token('MODE','Update');
393: FND_MESSAGE.set_token('ENTITY','Attribute');
394: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_rec.attribute_id));
395: FND_MSG_PUB.add;
396: END IF;
397: RAISE FND_API.G_EXC_ERROR;
398: END IF;

Line 425: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_RULE');

421:
422: if(l_delete_flag = 'N') then
423:
424: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
425: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_RULE');
426: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
427: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
428: FND_MSG_PUB.Add;
429: END IF;

Line 426: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );

422: if(l_delete_flag = 'N') then
423:
424: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
425: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_RULE');
426: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
427: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
428: FND_MSG_PUB.Add;
429: END IF;
430:

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

423:
424: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
425: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_RULE');
426: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
427: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
428: FND_MSG_PUB.Add;
429: END IF;
430:
431: RAISE FND_API.G_EXC_ERROR;

Line 447: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_MATCHING');

443:
444: if(l_delete_flag = 'N') then
445:
446: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
447: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_MATCHING');
448: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
449: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
450: FND_MSG_PUB.Add;
451: END IF;

Line 448: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );

444: if(l_delete_flag = 'N') then
445:
446: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
447: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_MATCHING');
448: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
449: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
450: FND_MSG_PUB.Add;
451: END IF;
452:

Line 449: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );

445:
446: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
447: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_NOTDISABLED_MATCHING');
448: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
449: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
450: FND_MSG_PUB.Add;
451: END IF;
452:
453: RAISE FND_API.G_EXC_ERROR;

Line 471: FND_MESSAGE.Set_Name('PV', 'PV_VALUE_TYPE_REFERENCED_RULE');

467:
468: if(l_delete_flag = 'N') 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_VALUE_TYPE_REFERENCED_RULE');
472: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
473: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
474: FND_MSG_PUB.Add;
475: END IF;

Line 472: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );

468: if(l_delete_flag = 'N') 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_VALUE_TYPE_REFERENCED_RULE');
472: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
473: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
474: FND_MSG_PUB.Add;
475: END IF;
476:

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

469:
470: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
471: FND_MESSAGE.Set_Name('PV', 'PV_VALUE_TYPE_REFERENCED_RULE');
472: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
473: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
474: FND_MSG_PUB.Add;
475: END IF;
476:
477: RAISE FND_API.G_EXC_ERROR;

Line 495: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_REFERENCED_RULE');

491:
492: if(l_delete_flag = 'N') then
493:
494: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
495: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_REFERENCED_RULE');
496: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
497: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
498: FND_MSG_PUB.Add;
499: END IF;

Line 496: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );

492: if(l_delete_flag = 'N') then
493:
494: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
495: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_REFERENCED_RULE');
496: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
497: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
498: FND_MSG_PUB.Add;
499: END IF;
500:

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

493:
494: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
495: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_REFERENCED_RULE');
496: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
497: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
498: FND_MSG_PUB.Add;
499: END IF;
500:
501: RAISE FND_API.G_EXC_ERROR;

Line 515: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_NOTDISABLED');

511:
512: if(l_delete_flag = 'N') then
513:
514: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
515: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_NOTDISABLED');
516: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
517: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
518: FND_MSG_PUB.Add;
519: END IF;

Line 516: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );

512: if(l_delete_flag = 'N') then
513:
514: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
515: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_NOTDISABLED');
516: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
517: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
518: FND_MSG_PUB.Add;
519: END IF;
520:

Line 517: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );

513:
514: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
515: FND_MESSAGE.Set_Name('PV', 'PV_MATCHING_NOTDISABLED');
516: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
517: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
518: FND_MSG_PUB.Add;
519: END IF;
520:
521: RAISE FND_API.G_EXC_ERROR;

Line 540: -- FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');

536: -- )
537: -- THEN
538: -- IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
539:
540: -- FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
541: -- FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
542:
543: -- FOR x IN (select meaning from pv_lookups
544: -- where lookup_type = 'PV_ATTRIBUTE_TYPE'

Line 541: -- FND_MESSAGE.set_token('NAME',p_attribute_rec.name);

537: -- THEN
538: -- IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
539:
540: -- FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
541: -- FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
542:
543: -- FOR x IN (select meaning from pv_lookups
544: -- where lookup_type = 'PV_ATTRIBUTE_TYPE'
545: -- and lookup_code = p_attribute_rec.attribute_type

Line 549: -- Fnd_Message.set_token('TYPE',l_meaning);

545: -- and lookup_code = p_attribute_rec.attribute_type
546: -- ) LOOP
547: -- l_meaning := x.meaning;
548: -- END LOOP;
549: -- Fnd_Message.set_token('TYPE',l_meaning);
550:
551: -- FOR x IN (select meaning from pv_lookups
552: -- where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
553: -- and lookup_code = l_ref_attribute_rec.display_style

Line 557: -- FND_MESSAGE.set_token('FROM',l_meaning);

553: -- and lookup_code = l_ref_attribute_rec.display_style
554: -- ) LOOP
555: -- l_meaning := x.meaning;
556: -- END LOOP;
557: -- FND_MESSAGE.set_token('FROM',l_meaning);
558:
559: -- FOR x IN (select meaning from pv_lookups
560: -- where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
561: -- and lookup_code = p_attribute_rec.display_style

Line 566: -- FND_MESSAGE.set_token('TO',l_meaning);

562: -- ) LOOP
563: -- l_meaning := x.meaning;
564: -- END LOOP;
565:
566: -- FND_MESSAGE.set_token('TO',l_meaning);
567: -- FND_MSG_PUB.add;
568:
569: -- END IF;
570: -- RAISE FND_API.G_EXC_ERROR;

Line 597: /*FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');

593: ) THEN
594:
595: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
596:
597: /*FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
598: FND_MESSAGE.set_token('TEXT', 'Can not :' || p_attribute_rec.attribute_type || ':' ||
599: l_ref_attribute_rec.display_style || ':' ||p_attribute_rec.display_style ||':');
600: FND_MSG_PUB.add;
601: */

Line 598: FND_MESSAGE.set_token('TEXT', 'Can not :' || p_attribute_rec.attribute_type || ':' ||

594:
595: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
596:
597: /*FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
598: FND_MESSAGE.set_token('TEXT', 'Can not :' || p_attribute_rec.attribute_type || ':' ||
599: l_ref_attribute_rec.display_style || ':' ||p_attribute_rec.display_style ||':');
600: FND_MSG_PUB.add;
601: */
602:

Line 603: FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');

599: l_ref_attribute_rec.display_style || ':' ||p_attribute_rec.display_style ||':');
600: FND_MSG_PUB.add;
601: */
602:
603: FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
604: FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
605:
606: FOR x IN (select meaning from pv_lookups
607: where lookup_type = 'PV_ATTRIBUTE_TYPE'

Line 604: FND_MESSAGE.set_token('NAME',p_attribute_rec.name);

600: FND_MSG_PUB.add;
601: */
602:
603: FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
604: FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
605:
606: FOR x IN (select meaning from pv_lookups
607: where lookup_type = 'PV_ATTRIBUTE_TYPE'
608: and lookup_code = p_attribute_rec.attribute_type

Line 612: Fnd_Message.set_token('TYPE',l_meaning);

608: and lookup_code = p_attribute_rec.attribute_type
609: ) LOOP
610: l_meaning := x.meaning;
611: END LOOP;
612: Fnd_Message.set_token('TYPE',l_meaning);
613:
614: FOR x IN (select meaning from pv_lookups
615: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
616: and lookup_code = l_ref_attribute_rec.display_style

Line 620: FND_MESSAGE.set_token('FROM',l_meaning);

616: and lookup_code = l_ref_attribute_rec.display_style
617: ) LOOP
618: l_meaning := x.meaning;
619: END LOOP;
620: FND_MESSAGE.set_token('FROM',l_meaning);
621:
622: FOR x IN (select meaning from pv_lookups
623: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
624: and lookup_code = p_attribute_rec.display_style

Line 629: FND_MESSAGE.set_token('TO',l_meaning);

625: ) LOOP
626: l_meaning := x.meaning;
627: END LOOP;
628:
629: FND_MESSAGE.set_token('TO',l_meaning);
630: FND_MSG_PUB.add;
631:
632: END IF;
633: RAISE FND_API.G_EXC_ERROR;

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

648: If (l_tar_attribute_rec.object_version_number is NULL or
649: l_tar_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then
650:
651: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
652: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
653: FND_MESSAGE.set_token('COLUMN', TO_CHAR(l_tar_attribute_rec.last_update_date));
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;

Line 653: FND_MESSAGE.set_token('COLUMN', TO_CHAR(l_tar_attribute_rec.last_update_date));

649: l_tar_attribute_rec.object_version_number = FND_API.G_MISS_NUM ) Then
650:
651: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
652: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
653: FND_MESSAGE.set_token('COLUMN', TO_CHAR(l_tar_attribute_rec.last_update_date));
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;
657: End if;

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

657: End if;
658: -- Check Whether record has been changed by someone else
659: If (l_tar_attribute_rec.object_version_number <> l_ref_attribute_rec.object_version_number) Then
660: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
661: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
662: FND_MESSAGE.set_token('VALUE','Attribute');
663: FND_MSG_PUB.add;
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;

Line 662: FND_MESSAGE.set_token('VALUE','Attribute');

658: -- Check Whether record has been changed by someone else
659: If (l_tar_attribute_rec.object_version_number <> l_ref_attribute_rec.object_version_number) Then
660: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
661: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
662: FND_MESSAGE.set_token('VALUE','Attribute');
663: FND_MSG_PUB.add;
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;
666: End if;

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

930: l_delete_flag :='N';
931: end if;
932: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
933:
934: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
935: FND_MESSAGE.set_token('TEXT', 'Is it Seeded '|| x.seeded_flag);
936: FND_MSG_PUB.add;
937:
938: END IF;

Line 935: FND_MESSAGE.set_token('TEXT', 'Is it Seeded '|| x.seeded_flag);

931: end if;
932: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
933:
934: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
935: FND_MESSAGE.set_token('TEXT', 'Is it Seeded '|| x.seeded_flag);
936: FND_MSG_PUB.add;
937:
938: END IF;
939: end loop;

Line 946: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_SEEDED');

942: if(l_delete_flag = 'N') then
943:
944: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
945: THEN
946: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_SEEDED');
947: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
948:
949: FND_MSG_PUB.Add;
950: END IF;

Line 947: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );

943:
944: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
945: THEN
946: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_SEEDED');
947: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
948:
949: FND_MSG_PUB.Add;
950: END IF;
951:

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

973: end loop;
974:
975: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
976:
977: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
978: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list);
979: FND_MSG_PUB.add;
980: END IF;
981:

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

974:
975: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
976:
977: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
978: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list);
979: FND_MSG_PUB.add;
980: END IF;
981:
982: if(l_delete_flag = 'N') then

Line 986: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_ENTITY');

982: if(l_delete_flag = 'N') then
983:
984: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
985: THEN
986: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_ENTITY');
987: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
988: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
989: FND_MSG_PUB.Add;
990: END IF;

Line 987: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );

983:
984: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
985: THEN
986: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_ENTITY');
987: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
988: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
989: FND_MSG_PUB.Add;
990: END IF;
991:

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

984: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
985: THEN
986: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_ENTITY');
987: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
988: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
989: FND_MSG_PUB.Add;
990: END IF;
991:
992: RAISE FND_API.G_EXC_ERROR;

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

1005: if(l_delete_flag = 'N') then
1006:
1007: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1008: THEN
1009: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
1010: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1011: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
1012: FND_MSG_PUB.Add;
1013: END IF;

Line 1010: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );

1006:
1007: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1008: THEN
1009: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
1010: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1011: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
1012: FND_MSG_PUB.Add;
1013: END IF;
1014:

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

1007: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1008: THEN
1009: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
1010: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1011: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
1012: FND_MSG_PUB.Add;
1013: END IF;
1014:
1015: RAISE FND_API.G_EXC_ERROR;

Line 1032: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_MATCHING');

1028: if(l_delete_flag = 'N') then
1029:
1030: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1031: THEN
1032: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_MATCHING');
1033: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1034: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
1035: FND_MSG_PUB.Add;
1036: END IF;

Line 1033: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );

1029:
1030: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1031: THEN
1032: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_MATCHING');
1033: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1034: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
1035: FND_MSG_PUB.Add;
1036: END IF;
1037:

Line 1034: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );

1030: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1031: THEN
1032: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_MATCHING');
1033: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1034: FND_MESSAGE.Set_Token('RESPONSIBILITY_LIST',substr(l_being_used_list,2) );
1035: FND_MSG_PUB.Add;
1036: END IF;
1037:
1038: RAISE FND_API.G_EXC_ERROR;

Line 1055: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RESP_MAP');

1051: if(l_delete_flag = 'N') then
1052:
1053: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1054: THEN
1055: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RESP_MAP');
1056: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1057: FND_MESSAGE.Set_Token('MAP_LIST',substr(l_being_used_list,2) );
1058: FND_MSG_PUB.Add;
1059: END IF;

Line 1056: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );

1052:
1053: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1054: THEN
1055: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RESP_MAP');
1056: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1057: FND_MESSAGE.Set_Token('MAP_LIST',substr(l_being_used_list,2) );
1058: FND_MSG_PUB.Add;
1059: END IF;
1060:

Line 1057: FND_MESSAGE.Set_Token('MAP_LIST',substr(l_being_used_list,2) );

1053: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR))
1054: THEN
1055: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RESP_MAP');
1056: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1057: FND_MESSAGE.Set_Token('MAP_LIST',substr(l_being_used_list,2) );
1058: FND_MSG_PUB.Add;
1059: END IF;
1060:
1061: RAISE FND_API.G_EXC_ERROR;

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

1276:
1277: IF (c_Attribute%NOTFOUND) THEN
1278: CLOSE c_Attribute;
1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1280: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
1281: FND_MSG_PUB.add;
1282: END IF;
1283: RAISE FND_API.g_exc_error;
1284: END IF;

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

1362: END IF;
1363:
1364: IF l_valid_flag = FND_API.g_false THEN
1365: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1366: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1367: FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) );
1368: FND_MESSAGE.set_token('ENTITY','Attribute');
1369: FND_MSG_PUB.add;
1370: END IF;

Line 1367: FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) );

1363:
1364: IF l_valid_flag = FND_API.g_false THEN
1365: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1366: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1367: FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) );
1368: FND_MESSAGE.set_token('ENTITY','Attribute');
1369: FND_MSG_PUB.add;
1370: END IF;
1371: x_return_status := FND_API.g_ret_sts_error;

Line 1368: FND_MESSAGE.set_token('ENTITY','Attribute');

1364: IF l_valid_flag = FND_API.g_false THEN
1365: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1366: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1367: FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) );
1368: FND_MESSAGE.set_token('ENTITY','Attribute');
1369: FND_MSG_PUB.add;
1370: END IF;
1371: x_return_status := FND_API.g_ret_sts_error;
1372: RETURN;

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

1383: loop
1384: if (UPPER(p_attribute_rec.name)=UPPER(x.name)) then
1385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1386:
1387: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1388: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);
1390: --FND_MESSAGE.set_token('ENTITY','Attribute');
1391: FND_MSG_PUB.add;

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

1384: if (UPPER(p_attribute_rec.name)=UPPER(x.name)) then
1385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1386:
1387: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1388: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);
1390: --FND_MESSAGE.set_token('ENTITY','Attribute');
1391: FND_MSG_PUB.add;
1392: END IF;

Line 1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);

1385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1386:
1387: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1388: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);
1390: --FND_MESSAGE.set_token('ENTITY','Attribute');
1391: FND_MSG_PUB.add;
1392: END IF;
1393: --x_return_status := FND_API.g_ret_sts_error;

Line 1390: --FND_MESSAGE.set_token('ENTITY','Attribute');

1386:
1387: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1388: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);
1390: --FND_MESSAGE.set_token('ENTITY','Attribute');
1391: FND_MSG_PUB.add;
1392: END IF;
1393: --x_return_status := FND_API.g_ret_sts_error;
1394: RAISE FND_API.G_EXC_ERROR;

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

1406: END IF ;
1407:
1408: IF l_valid_tl_flag = FND_API.g_false THEN
1409: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1410: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1411: FND_MSG_PUB.add;
1412: END IF;
1413: x_return_status := FND_API.g_ret_sts_error;
1414: RETURN;

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

1430: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1431:
1432: IF p_attribute_rec.attribute_id = FND_API.g_miss_num OR p_attribute_rec.attribute_id IS NULL THEN
1433: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1434: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1435: FND_MESSAGE.set_token('COLUMN','attribute_id');
1436: FND_MSG_PUB.add;
1437: END IF;
1438: x_return_status := FND_API.g_ret_sts_error;

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

1431:
1432: IF p_attribute_rec.attribute_id = FND_API.g_miss_num OR p_attribute_rec.attribute_id IS NULL THEN
1433: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1434: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1435: FND_MESSAGE.set_token('COLUMN','attribute_id');
1436: FND_MSG_PUB.add;
1437: END IF;
1438: x_return_status := FND_API.g_ret_sts_error;
1439: RETURN;

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

1441:
1442:
1443: IF p_attribute_rec.last_update_date = FND_API.g_miss_date OR p_attribute_rec.last_update_date IS NULL THEN
1444: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1445: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1446: FND_MESSAGE.set_token('COLUMN','last_update_date');
1447: FND_MSG_PUB.add;
1448: END IF;
1449: x_return_status := FND_API.g_ret_sts_error;

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

1442:
1443: IF p_attribute_rec.last_update_date = FND_API.g_miss_date OR p_attribute_rec.last_update_date IS NULL THEN
1444: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1445: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1446: FND_MESSAGE.set_token('COLUMN','last_update_date');
1447: FND_MSG_PUB.add;
1448: END IF;
1449: x_return_status := FND_API.g_ret_sts_error;
1450: RETURN;

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

1452:
1453:
1454: IF p_attribute_rec.last_updated_by = FND_API.g_miss_num OR p_attribute_rec.last_updated_by IS NULL THEN
1455: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1456: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1457: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1458: FND_MSG_PUB.add;
1459: END IF;
1460: x_return_status := FND_API.g_ret_sts_error;

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

1453:
1454: IF p_attribute_rec.last_updated_by = FND_API.g_miss_num OR p_attribute_rec.last_updated_by IS NULL THEN
1455: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1456: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1457: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1458: FND_MSG_PUB.add;
1459: END IF;
1460: x_return_status := FND_API.g_ret_sts_error;
1461: RETURN;

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

1463:
1464:
1465: IF p_attribute_rec.creation_date = FND_API.g_miss_date OR p_attribute_rec.creation_date IS NULL THEN
1466: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1467: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1468: FND_MESSAGE.set_token('COLUMN','creation_date');
1469: FND_MSG_PUB.add;
1470: END IF;
1471: x_return_status := FND_API.g_ret_sts_error;

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

1464:
1465: IF p_attribute_rec.creation_date = FND_API.g_miss_date OR p_attribute_rec.creation_date IS NULL THEN
1466: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1467: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1468: FND_MESSAGE.set_token('COLUMN','creation_date');
1469: FND_MSG_PUB.add;
1470: END IF;
1471: x_return_status := FND_API.g_ret_sts_error;
1472: RETURN;

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

1474:
1475:
1476: IF p_attribute_rec.created_by = FND_API.g_miss_num OR p_attribute_rec.created_by IS NULL THEN
1477: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1478: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1479: FND_MESSAGE.set_token('COLUMN','created_by');
1480: FND_MSG_PUB.add;
1481: END IF;
1482: x_return_status := FND_API.g_ret_sts_error;

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

1475:
1476: IF p_attribute_rec.created_by = FND_API.g_miss_num OR p_attribute_rec.created_by IS NULL THEN
1477: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1478: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1479: FND_MESSAGE.set_token('COLUMN','created_by');
1480: FND_MSG_PUB.add;
1481: END IF;
1482: x_return_status := FND_API.g_ret_sts_error;
1483: RETURN;

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

1485:
1486:
1487: IF p_attribute_rec.last_update_login = FND_API.g_miss_num OR p_attribute_rec.last_update_login IS NULL THEN
1488: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1489: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1490: FND_MESSAGE.set_token('COLUMN','last_update_login');
1491: FND_MSG_PUB.add;
1492: END IF;
1493: x_return_status := FND_API.g_ret_sts_error;

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

1486:
1487: IF p_attribute_rec.last_update_login = FND_API.g_miss_num OR p_attribute_rec.last_update_login IS NULL THEN
1488: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1489: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1490: FND_MESSAGE.set_token('COLUMN','last_update_login');
1491: FND_MSG_PUB.add;
1492: END IF;
1493: x_return_status := FND_API.g_ret_sts_error;
1494: RETURN;

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

1496:
1497:
1498: IF p_attribute_rec.object_version_number = FND_API.g_miss_num OR p_attribute_rec.object_version_number IS NULL THEN
1499: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1500: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1501: FND_MESSAGE.set_token('COLUMN','object_version_number');
1502: FND_MSG_PUB.add;
1503: END IF;
1504: x_return_status := FND_API.g_ret_sts_error;

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

1497:
1498: IF p_attribute_rec.object_version_number = FND_API.g_miss_num OR p_attribute_rec.object_version_number IS NULL THEN
1499: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1500: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1501: FND_MESSAGE.set_token('COLUMN','object_version_number');
1502: FND_MSG_PUB.add;
1503: END IF;
1504: x_return_status := FND_API.g_ret_sts_error;
1505: RETURN;

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

1507:
1508:
1509: IF p_attribute_rec.enabled_flag = FND_API.g_miss_char OR p_attribute_rec.enabled_flag IS NULL THEN
1510: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1512: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1513: FND_MSG_PUB.add;
1514: END IF;
1515: x_return_status := FND_API.g_ret_sts_error;

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

1508:
1509: IF p_attribute_rec.enabled_flag = FND_API.g_miss_char OR p_attribute_rec.enabled_flag IS NULL THEN
1510: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1511: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1512: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1513: FND_MSG_PUB.add;
1514: END IF;
1515: x_return_status := FND_API.g_ret_sts_error;
1516: RETURN;

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

1517: END IF;
1518:
1519: IF p_attribute_rec.short_name = FND_API.g_miss_char OR p_attribute_rec.short_name IS NULL THEN
1520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1521: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1522: FND_MESSAGE.set_token('COLUMN','short_name');
1523: FND_MSG_PUB.add;
1524: END IF;
1525: x_return_status := FND_API.g_ret_sts_error;

Line 1522: FND_MESSAGE.set_token('COLUMN','short_name');

1518:
1519: IF p_attribute_rec.short_name = FND_API.g_miss_char OR p_attribute_rec.short_name IS NULL THEN
1520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1521: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1522: FND_MESSAGE.set_token('COLUMN','short_name');
1523: FND_MSG_PUB.add;
1524: END IF;
1525: x_return_status := FND_API.g_ret_sts_error;
1526: RETURN;

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

1530:
1531:
1532: IF p_attribute_rec.attribute_id IS NULL THEN
1533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1534: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1535: FND_MESSAGE.set_token('COLUMN','attribute_id');
1536: FND_MSG_PUB.add;
1537: END IF;
1538: x_return_status := FND_API.g_ret_sts_error;

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

1531:
1532: IF p_attribute_rec.attribute_id IS NULL THEN
1533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1534: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1535: FND_MESSAGE.set_token('COLUMN','attribute_id');
1536: FND_MSG_PUB.add;
1537: END IF;
1538: x_return_status := FND_API.g_ret_sts_error;
1539: RETURN;

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

1541:
1542:
1543: IF p_attribute_rec.last_update_date IS NULL THEN
1544: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1545: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1546: FND_MESSAGE.set_token('COLUMN','last_update_date');
1547: FND_MSG_PUB.add;
1548: END IF;
1549: x_return_status := FND_API.g_ret_sts_error;

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

1542:
1543: IF p_attribute_rec.last_update_date IS NULL THEN
1544: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1545: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1546: FND_MESSAGE.set_token('COLUMN','last_update_date');
1547: FND_MSG_PUB.add;
1548: END IF;
1549: x_return_status := FND_API.g_ret_sts_error;
1550: RETURN;

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

1552:
1553:
1554: IF p_attribute_rec.last_updated_by IS NULL THEN
1555: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1556: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1557: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1558: FND_MSG_PUB.add;
1559: end if;
1560: x_return_status := FND_API.g_ret_sts_error;

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

1553:
1554: IF p_attribute_rec.last_updated_by IS NULL THEN
1555: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1556: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1557: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1558: FND_MSG_PUB.add;
1559: end if;
1560: x_return_status := FND_API.g_ret_sts_error;
1561: RETURN;

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

1563:
1564:
1565: IF p_attribute_rec.creation_date IS NULL THEN
1566: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1567: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1568: FND_MESSAGE.set_token('COLUMN','creation_date');
1569: FND_MSG_PUB.add;
1570: end if;
1571: x_return_status := FND_API.g_ret_sts_error;

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

1564:
1565: IF p_attribute_rec.creation_date IS NULL THEN
1566: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1567: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1568: FND_MESSAGE.set_token('COLUMN','creation_date');
1569: FND_MSG_PUB.add;
1570: end if;
1571: x_return_status := FND_API.g_ret_sts_error;
1572: RETURN;

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

1574:
1575:
1576: IF p_attribute_rec.created_by IS NULL THEN
1577: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1578: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1579: FND_MESSAGE.set_token('COLUMN','created_by');
1580: FND_MSG_PUB.add;
1581: end if;
1582: x_return_status := FND_API.g_ret_sts_error;

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

1575:
1576: IF p_attribute_rec.created_by IS NULL THEN
1577: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1578: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1579: FND_MESSAGE.set_token('COLUMN','created_by');
1580: FND_MSG_PUB.add;
1581: end if;
1582: x_return_status := FND_API.g_ret_sts_error;
1583: RETURN;

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

1585:
1586:
1587: IF p_attribute_rec.last_update_login IS NULL THEN
1588: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1589: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1590: FND_MESSAGE.set_token('COLUMN','last_update_login');
1591: FND_MSG_PUB.add;
1592: end if;
1593: x_return_status := FND_API.g_ret_sts_error;

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

1586:
1587: IF p_attribute_rec.last_update_login IS NULL THEN
1588: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1589: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1590: FND_MESSAGE.set_token('COLUMN','last_update_login');
1591: FND_MSG_PUB.add;
1592: end if;
1593: x_return_status := FND_API.g_ret_sts_error;
1594: RETURN;

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

1596:
1597:
1598: IF p_attribute_rec.object_version_number IS NULL THEN
1599: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1600: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1601: FND_MESSAGE.set_token('COLUMN','object_version_number');
1602: FND_MSG_PUB.add;
1603: end if;
1604: x_return_status := FND_API.g_ret_sts_error;

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

1597:
1598: IF p_attribute_rec.object_version_number IS NULL THEN
1599: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1600: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1601: FND_MESSAGE.set_token('COLUMN','object_version_number');
1602: FND_MSG_PUB.add;
1603: end if;
1604: x_return_status := FND_API.g_ret_sts_error;
1605: RETURN;

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

1607:
1608:
1609: IF p_attribute_rec.enabled_flag IS NULL THEN
1610: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1611: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1612: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1613: FND_MSG_PUB.add;
1614: end if;
1615: x_return_status := FND_API.g_ret_sts_error;

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

1608:
1609: IF p_attribute_rec.enabled_flag IS NULL THEN
1610: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1611: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1612: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1613: FND_MSG_PUB.add;
1614: end if;
1615: x_return_status := FND_API.g_ret_sts_error;
1616: RETURN;

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

1619:
1620:
1621: IF p_attribute_rec.short_name IS NULL THEN
1622: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1623: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1624: FND_MESSAGE.set_token('COLUMN','short_name');
1625: FND_MSG_PUB.add;
1626: end if;
1627: x_return_status := FND_API.g_ret_sts_error;

Line 1624: FND_MESSAGE.set_token('COLUMN','short_name');

1620:
1621: IF p_attribute_rec.short_name IS NULL THEN
1622: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1623: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1624: FND_MESSAGE.set_token('COLUMN','short_name');
1625: FND_MSG_PUB.add;
1626: end if;
1627: x_return_status := FND_API.g_ret_sts_error;
1628: RETURN;