APPS.PV_ENTITY_ATTRIBUTE_PVT dependencies on FND_MESSAGE

Line 119: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_ERROR');

115: and l_display_style in ('CHECK','MULTI','SINGLE','RADIO'))
116: ) then
117:
118: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
119: Fnd_Message.set_name('PV', 'PV_ENTY_ATTR_ERROR');
120: FOR x IN (select meaning from pv_lookups
121: where lookup_type = 'PV_ATTRIBUTE_ENTITY_TYPE'
122: and lookup_code = p_entity_attr_rec.entity
123: ) LOOP

Line 126: Fnd_Message.set_token('ENTITY',l_meaning);

122: and lookup_code = p_entity_attr_rec.entity
123: ) LOOP
124: l_meaning := x.meaning;
125: END LOOP;
126: Fnd_Message.set_token('ENTITY',l_meaning);
127:
128: FOR x IN (select meaning from pv_lookups
129: where lookup_type = 'PV_ATTRIBUTE_TYPE'
130: and lookup_code = l_attribute_type

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

130: and lookup_code = l_attribute_type
131: ) LOOP
132: l_meaning := x.meaning;
133: END LOOP;
134: Fnd_Message.set_token('ATTR_TYPE',l_meaning);
135:
136: FOR x IN (select meaning from pv_lookups
137: where lookup_type = 'PV_ATTR_DISPLAY_STYLE'
138: and lookup_code = l_display_style

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

138: and lookup_code = l_display_style
139: ) LOOP
140: l_meaning := x.meaning;
141: END LOOP;
142: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
143:
144:
145: Fnd_Msg_Pub.ADD;
146: END IF;

Line 205: Fnd_Message.set_name('PV', 'PV_API_USER_PROFILE_MISSING');

201:
202: IF Fnd_Global.User_Id IS NULL
203: THEN
204: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
205: Fnd_Message.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
206: Fnd_Msg_Pub.ADD;
207: END IF;
208: RAISE Fnd_Api.G_EXC_ERROR;
209: END IF;

Line 444: Fnd_Message.set_name('PV', 'PV_API_MISSING_ENTITY');

440:
441: FETCH c_get_Entity_Attribute INTO l_ref_entity_attr_rec ;
442:
443: IF ( c_get_Entity_Attribute%NOTFOUND) THEN
444: Fnd_Message.set_name('PV', 'PV_API_MISSING_ENTITY');
445: Fnd_Message.set_token('MODE','Update');
446: Fnd_Message.set_token('ENTITY','Entity_Attribute');
447: Fnd_Message.set_token('ID',TO_CHAR(l_tar_entity_attr_rec.entity_attr_id));
448: Fnd_Msg_Pub.ADD;

Line 445: Fnd_Message.set_token('MODE','Update');

441: FETCH c_get_Entity_Attribute INTO l_ref_entity_attr_rec ;
442:
443: IF ( c_get_Entity_Attribute%NOTFOUND) THEN
444: Fnd_Message.set_name('PV', 'PV_API_MISSING_ENTITY');
445: Fnd_Message.set_token('MODE','Update');
446: Fnd_Message.set_token('ENTITY','Entity_Attribute');
447: Fnd_Message.set_token('ID',TO_CHAR(l_tar_entity_attr_rec.entity_attr_id));
448: Fnd_Msg_Pub.ADD;
449: RAISE Fnd_Api.G_EXC_ERROR;

Line 446: Fnd_Message.set_token('ENTITY','Entity_Attribute');

442:
443: IF ( c_get_Entity_Attribute%NOTFOUND) THEN
444: Fnd_Message.set_name('PV', 'PV_API_MISSING_ENTITY');
445: Fnd_Message.set_token('MODE','Update');
446: Fnd_Message.set_token('ENTITY','Entity_Attribute');
447: Fnd_Message.set_token('ID',TO_CHAR(l_tar_entity_attr_rec.entity_attr_id));
448: Fnd_Msg_Pub.ADD;
449: RAISE Fnd_Api.G_EXC_ERROR;
450: END IF;

Line 447: Fnd_Message.set_token('ID',TO_CHAR(l_tar_entity_attr_rec.entity_attr_id));

443: IF ( c_get_Entity_Attribute%NOTFOUND) THEN
444: Fnd_Message.set_name('PV', 'PV_API_MISSING_ENTITY');
445: Fnd_Message.set_token('MODE','Update');
446: Fnd_Message.set_token('ENTITY','Entity_Attribute');
447: Fnd_Message.set_token('ID',TO_CHAR(l_tar_entity_attr_rec.entity_attr_id));
448: Fnd_Msg_Pub.ADD;
449: RAISE Fnd_Api.G_EXC_ERROR;
450: END IF;
451:

Line 521: Fnd_Message.set_name('PV', 'PV_API_VERSION_MISSING');

517: end if;
518: IF (l_tar_entity_attr_rec.object_version_number IS NULL OR
519: l_tar_entity_attr_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
521: Fnd_Message.set_name('PV', 'PV_API_VERSION_MISSING');
522: Fnd_Message.set_token('COLUMN','Last_Update_Date');
523: Fnd_Msg_Pub.ADD;
524: END IF;
525: RAISE Fnd_Api.G_EXC_ERROR;

Line 522: Fnd_Message.set_token('COLUMN','Last_Update_Date');

518: IF (l_tar_entity_attr_rec.object_version_number IS NULL OR
519: l_tar_entity_attr_rec.object_version_number = Fnd_Api.G_MISS_NUM ) THEN
520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
521: Fnd_Message.set_name('PV', 'PV_API_VERSION_MISSING');
522: Fnd_Message.set_token('COLUMN','Last_Update_Date');
523: Fnd_Msg_Pub.ADD;
524: END IF;
525: RAISE Fnd_Api.G_EXC_ERROR;
526: END IF;

Line 532: Fnd_Message.set_name('PV', 'PV_API_RECORD_CHANGED');

528: -- Check Whether record has been changed by someone else
529: --DBMS_OUTPUT.PUT_LINE('l_tar_entity_attr_rec.object_version_number = '||TO_CHAR(l_tar_entity_attr_rec.object_version_number));
530: --DBMS_OUTPUT.PUT_LINE('l_ref_entity_attr_rec.object_version_number = '||TO_CHAR(l_ref_entity_attr_rec.object_version_number));
531: IF (l_tar_entity_attr_rec.object_version_number <> l_ref_entity_attr_rec.object_version_number) THEN
532: Fnd_Message.set_name('PV', 'PV_API_RECORD_CHANGED');
533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
534: Fnd_Message.set_token('VALUE','Entity_Attribute');
535: Fnd_Msg_Pub.ADD;
536: END IF;

Line 534: Fnd_Message.set_token('VALUE','Entity_Attribute');

530: --DBMS_OUTPUT.PUT_LINE('l_ref_entity_attr_rec.object_version_number = '||TO_CHAR(l_ref_entity_attr_rec.object_version_number));
531: IF (l_tar_entity_attr_rec.object_version_number <> l_ref_entity_attr_rec.object_version_number) THEN
532: Fnd_Message.set_name('PV', 'PV_API_RECORD_CHANGED');
533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
534: Fnd_Message.set_token('VALUE','Entity_Attribute');
535: Fnd_Msg_Pub.ADD;
536: END IF;
537: RAISE Fnd_Api.G_EXC_ERROR;
538: END IF;

Line 751: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');

747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
748: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
749: THEN
750:
751: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
752: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
753: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
754: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
755: FND_MSG_PUB.Add;

Line 752: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

748: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
749: THEN
750:
751: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
752: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
753: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
754: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
755: FND_MSG_PUB.Add;
756: END IF;

Line 753: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

749: THEN
750:
751: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
752: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
753: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
754: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
755: FND_MSG_PUB.Add;
756: END IF;
757:

Line 754: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

750:
751: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
752: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
753: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
754: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
755: FND_MSG_PUB.Add;
756: END IF;
757:
758: RAISE FND_API.G_EXC_ERROR;

Line 781: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');

777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
778: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
779: THEN
780:
781: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
782: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
783: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
784: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
785: FND_MSG_PUB.Add;

Line 782: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

778: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
779: THEN
780:
781: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
782: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
783: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
784: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
785: FND_MSG_PUB.Add;
786: END IF;

Line 783: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

779: THEN
780:
781: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
782: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
783: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
784: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
785: FND_MSG_PUB.Add;
786: END IF;
787:

Line 784: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

780:
781: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
782: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
783: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
784: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
785: FND_MSG_PUB.Add;
786: END IF;
787:
788: RAISE FND_API.G_EXC_ERROR;

Line 811: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');

807: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
808: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
809: THEN
810:
811: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
813:
814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

Line 812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');

808: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
809: THEN
810:
811: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
813:
814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
816: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

Line 814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

810:
811: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
813:
814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
816: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
817: FND_MSG_PUB.Add;
818: END IF;

Line 815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

811: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
813:
814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
816: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
817: FND_MSG_PUB.Add;
818: END IF;
819:

Line 816: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

812: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
813:
814: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
815: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
816: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
817: FND_MSG_PUB.Add;
818: END IF;
819:
820: RAISE FND_API.G_EXC_ERROR;

Line 830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');

826: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
827: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
828: THEN
829:
830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

Line 831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');

827: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
828: THEN
829:
830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
835: FND_MSG_PUB.Add;

Line 832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

828: THEN
829:
830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
835: FND_MSG_PUB.Add;
836: END IF;

Line 833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

829:
830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
835: FND_MSG_PUB.Add;
836: END IF;
837:

Line 834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

830: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_SYNTX_ERROR');
831: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
832: FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
833: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
834: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
835: FND_MSG_PUB.Add;
836: END IF;
837:
838: RAISE FND_API.G_EXC_ERROR;

Line 1036: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');

1032: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1033: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1034: THEN
1035:
1036: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1038:
1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

Line 1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');

1033: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1034: THEN
1035:
1036: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1038:
1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1041: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

Line 1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

1035:
1036: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1038:
1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1041: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1042: FND_MSG_PUB.Add;
1043: END IF;

Line 1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

1036: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1038:
1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1041: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1042: FND_MSG_PUB.Add;
1043: END IF;
1044:

Line 1041: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

1037: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1038:
1039: --FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1040: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1041: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1042: FND_MSG_PUB.Add;
1043: END IF;
1044:
1045: RAISE FND_API.G_EXC_ERROR;

Line 1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');

1054: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1055: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1056: THEN
1057:
1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

Line 1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');

1055: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1056: THEN
1057:
1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1063: FND_MSG_PUB.Add;

Line 1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);

1056: THEN
1057:
1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1063: FND_MSG_PUB.Add;
1064: END IF;

Line 1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);

1057:
1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1063: FND_MSG_PUB.Add;
1064: END IF;
1065:

Line 1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );

1058: FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_LOV_SYNTX_ERROR');
1059: --FND_MESSAGE.Set_Name('PV', 'PV_DERIVED_SQLTEXT_PARSE_ERROR');
1060: -- FND_MESSAGE.Set_Token('ENTITY',l_entity_meaning);
1061: --FND_MESSAGE.Set_Token('ERROR_CODE',l_error_code);
1062: --FND_MESSAGE.Set_Token('ERROR_MESSAGE',l_error_message );
1063: FND_MSG_PUB.Add;
1064: END IF;
1065:
1066: RAISE FND_API.G_EXC_ERROR;

Line 1240: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');

1236: if(l_delete_flag = 'N') then
1237:
1238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1239: THEN
1240: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');
1241: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1242: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1243: --FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1244: FND_MSG_PUB.Add;

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

1237:
1238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1239: THEN
1240: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');
1241: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1242: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1243: --FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1244: FND_MSG_PUB.Add;
1245: END IF;

Line 1242: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );

1238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1239: THEN
1240: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');
1241: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1242: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1243: --FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1246:

Line 1243: --FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );

1239: THEN
1240: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_VALUE');
1241: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1242: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1243: --FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1244: FND_MSG_PUB.Add;
1245: END IF;
1246:
1247: RAISE FND_API.G_EXC_ERROR;

Line 1264: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');

1260: if(l_delete_flag = 'N') then
1261:
1262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1263: THEN
1264: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');
1265: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1266: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1267: FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1268: FND_MSG_PUB.Add;

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

1261:
1262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1263: THEN
1264: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');
1265: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1266: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1267: FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1268: FND_MSG_PUB.Add;
1269: END IF;

Line 1266: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );

1262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
1263: THEN
1264: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');
1265: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1266: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1267: FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1268: FND_MSG_PUB.Add;
1269: END IF;
1270:

Line 1267: FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );

1263: THEN
1264: FND_MESSAGE.Set_Name('PV', 'PV_ENTITYATTR_REF_PROGRAM');
1265: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
1266: FND_MESSAGE.Set_Token('ENTITY',l_attribute_name );
1267: FND_MESSAGE.Set_Token('PROGRAM_LIST',substr(l_being_used_list,2) );
1268: FND_MSG_PUB.Add;
1269: END IF;
1270:
1271: RAISE FND_API.G_EXC_ERROR;

Line 1392: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');

1388: FETCH c_Entity_Attribute INTO l_ENTITY_ATTR_ID;
1389: IF (c_Entity_Attribute%NOTFOUND) THEN
1390: CLOSE c_Entity_Attribute;
1391: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN
1392: Fnd_Message.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
1393: Fnd_Msg_Pub.ADD;
1394: END IF;
1395: RAISE Fnd_Api.g_exc_error;
1396: END IF;

Line 1468: Fnd_Message.set_name('PV', 'PV_API_DUPLICATE_ENTITY');

1464: );
1465: END IF;
1466: IF l_valid_flag = Fnd_Api.g_false THEN
1467: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1468: Fnd_Message.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1469: Fnd_Message.set_token('ID',TO_CHAR(p_entity_attr_rec.entity_attr_ID) );
1470: Fnd_Message.set_token('ENTITY','Entity_Attribute');
1471: Fnd_Msg_Pub.ADD;
1472: END IF;

Line 1469: Fnd_Message.set_token('ID',TO_CHAR(p_entity_attr_rec.entity_attr_ID) );

1465: END IF;
1466: IF l_valid_flag = Fnd_Api.g_false THEN
1467: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1468: Fnd_Message.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1469: Fnd_Message.set_token('ID',TO_CHAR(p_entity_attr_rec.entity_attr_ID) );
1470: Fnd_Message.set_token('ENTITY','Entity_Attribute');
1471: Fnd_Msg_Pub.ADD;
1472: END IF;
1473: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1470: Fnd_Message.set_token('ENTITY','Entity_Attribute');

1466: IF l_valid_flag = Fnd_Api.g_false THEN
1467: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1468: Fnd_Message.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1469: Fnd_Message.set_token('ID',TO_CHAR(p_entity_attr_rec.entity_attr_ID) );
1470: Fnd_Message.set_token('ENTITY','Entity_Attribute');
1471: Fnd_Msg_Pub.ADD;
1472: END IF;
1473: x_return_status := Fnd_Api.g_ret_sts_error;
1474: RETURN;

Line 1498: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1494: -- TO_CHAR(p_entity_attr_rec.entity_attr_id));
1495: IF p_entity_attr_rec.entity_attr_id = Fnd_Api.g_miss_num
1496: OR p_entity_attr_rec.entity_attr_id IS NULL THEN
1497: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1498: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1499: Fnd_Message.set_token('COLUMN','entity_attr_id');
1500: Fnd_Msg_Pub.ADD;
1501: END IF;
1502: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1499: Fnd_Message.set_token('COLUMN','entity_attr_id');

1495: IF p_entity_attr_rec.entity_attr_id = Fnd_Api.g_miss_num
1496: OR p_entity_attr_rec.entity_attr_id IS NULL THEN
1497: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1498: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1499: Fnd_Message.set_token('COLUMN','entity_attr_id');
1500: Fnd_Msg_Pub.ADD;
1501: END IF;
1502: x_return_status := Fnd_Api.g_ret_sts_error;
1503: RETURN;

Line 1507: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1503: RETURN;
1504: END IF;
1505: IF p_entity_attr_rec.last_update_date = Fnd_Api.g_miss_date OR p_entity_attr_rec.last_update_date IS NULL THEN
1506: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1507: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1508: Fnd_Message.set_token('COLUMN','last_update_date');
1509: Fnd_Msg_Pub.ADD;
1510: END IF;
1511: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1508: Fnd_Message.set_token('COLUMN','last_update_date');

1504: END IF;
1505: IF p_entity_attr_rec.last_update_date = Fnd_Api.g_miss_date OR p_entity_attr_rec.last_update_date IS NULL THEN
1506: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1507: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1508: Fnd_Message.set_token('COLUMN','last_update_date');
1509: Fnd_Msg_Pub.ADD;
1510: END IF;
1511: x_return_status := Fnd_Api.g_ret_sts_error;
1512: RETURN;

Line 1516: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1512: RETURN;
1513: END IF;
1514: IF p_entity_attr_rec.last_updated_by = Fnd_Api.g_miss_num OR p_entity_attr_rec.last_updated_by IS NULL THEN
1515: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1516: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1517: Fnd_Message.set_token('COLUMN','last_updated_by');
1518: Fnd_Msg_Pub.ADD;
1519: END IF;
1520: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1517: Fnd_Message.set_token('COLUMN','last_updated_by');

1513: END IF;
1514: IF p_entity_attr_rec.last_updated_by = Fnd_Api.g_miss_num OR p_entity_attr_rec.last_updated_by IS NULL THEN
1515: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1516: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1517: Fnd_Message.set_token('COLUMN','last_updated_by');
1518: Fnd_Msg_Pub.ADD;
1519: END IF;
1520: x_return_status := Fnd_Api.g_ret_sts_error;
1521: RETURN;

Line 1525: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1521: RETURN;
1522: END IF;
1523: IF p_entity_attr_rec.creation_date = Fnd_Api.g_miss_date OR p_entity_attr_rec.creation_date IS NULL THEN
1524: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1525: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1526: Fnd_Message.set_token('COLUMN','creation_date');
1527: Fnd_Msg_Pub.ADD;
1528: END IF;
1529: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1526: Fnd_Message.set_token('COLUMN','creation_date');

1522: END IF;
1523: IF p_entity_attr_rec.creation_date = Fnd_Api.g_miss_date OR p_entity_attr_rec.creation_date IS NULL THEN
1524: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1525: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1526: Fnd_Message.set_token('COLUMN','creation_date');
1527: Fnd_Msg_Pub.ADD;
1528: END IF;
1529: x_return_status := Fnd_Api.g_ret_sts_error;
1530: RETURN;

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

1530: RETURN;
1531: END IF;
1532: IF p_entity_attr_rec.created_by = Fnd_Api.g_miss_num OR p_entity_attr_rec.created_by IS NULL THEN
1533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1534: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1535: Fnd_Message.set_token('COLUMN','created_by');
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','created_by');

1531: END IF;
1532: IF p_entity_attr_rec.created_by = Fnd_Api.g_miss_num OR p_entity_attr_rec.created_by IS NULL THEN
1533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1534: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1535: Fnd_Message.set_token('COLUMN','created_by');
1536: Fnd_Msg_Pub.ADD;
1537: END IF;
1538: x_return_status := Fnd_Api.g_ret_sts_error;
1539: RETURN;

Line 1544: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1540: END IF;
1541: IF p_entity_attr_rec.last_update_login = Fnd_Api.g_miss_num OR
1542: p_entity_attr_rec.last_update_login IS NULL THEN
1543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1544: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1545: Fnd_Message.set_token('COLUMN','last_update_login');
1546: Fnd_Msg_Pub.ADD;
1547: END IF;
1548: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1545: Fnd_Message.set_token('COLUMN','last_update_login');

1541: IF p_entity_attr_rec.last_update_login = Fnd_Api.g_miss_num OR
1542: p_entity_attr_rec.last_update_login IS NULL THEN
1543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1544: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1545: Fnd_Message.set_token('COLUMN','last_update_login');
1546: Fnd_Msg_Pub.ADD;
1547: END IF;
1548: x_return_status := Fnd_Api.g_ret_sts_error;
1549: RETURN;

Line 1553: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1549: RETURN;
1550: END IF;
1551: IF p_entity_attr_rec.object_version_number = Fnd_Api.g_miss_num OR p_entity_attr_rec.object_version_number IS NULL THEN
1552: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1553: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1554: Fnd_Message.set_token('COLUMN','object_version_number');
1555: Fnd_Msg_Pub.ADD;
1556: END IF;
1557: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1554: Fnd_Message.set_token('COLUMN','object_version_number');

1550: END IF;
1551: IF p_entity_attr_rec.object_version_number = Fnd_Api.g_miss_num OR p_entity_attr_rec.object_version_number IS NULL THEN
1552: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1553: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1554: Fnd_Message.set_token('COLUMN','object_version_number');
1555: Fnd_Msg_Pub.ADD;
1556: END IF;
1557: x_return_status := Fnd_Api.g_ret_sts_error;
1558: RETURN;

Line 1564: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1560:
1561: IF p_entity_attr_rec.attribute_id = Fnd_Api.g_miss_num OR
1562: p_entity_attr_rec.attribute_id IS NULL THEN
1563: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1564: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1565: Fnd_Message.set_token('COLUMN','attribute_id');
1566: Fnd_Msg_Pub.ADD;
1567: END IF;
1568: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1565: Fnd_Message.set_token('COLUMN','attribute_id');

1561: IF p_entity_attr_rec.attribute_id = Fnd_Api.g_miss_num OR
1562: p_entity_attr_rec.attribute_id IS NULL THEN
1563: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1564: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1565: Fnd_Message.set_token('COLUMN','attribute_id');
1566: Fnd_Msg_Pub.ADD;
1567: END IF;
1568: x_return_status := Fnd_Api.g_ret_sts_error;
1569: RETURN;

Line 1575: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1571:
1572:
1573: IF p_entity_attr_rec.entity = Fnd_Api.g_miss_char OR p_entity_attr_rec.entity IS NULL THEN
1574: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1575: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1576: Fnd_Message.set_token('COLUMN','entity');
1577: Fnd_Msg_Pub.ADD;
1578: END IF;
1579: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1576: Fnd_Message.set_token('COLUMN','entity');

1572:
1573: IF p_entity_attr_rec.entity = Fnd_Api.g_miss_char OR p_entity_attr_rec.entity IS NULL THEN
1574: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1575: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1576: Fnd_Message.set_token('COLUMN','entity');
1577: Fnd_Msg_Pub.ADD;
1578: END IF;
1579: x_return_status := Fnd_Api.g_ret_sts_error;
1580: RETURN;

Line 1584: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1580: RETURN;
1581: END IF;
1582: IF p_entity_attr_rec.enabled_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.enabled_flag IS NULL THEN
1583: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1584: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1585: Fnd_Message.set_token('COLUMN','enabled_flag');
1586: Fnd_Msg_Pub.ADD;
1587: END IF;
1588: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1585: Fnd_Message.set_token('COLUMN','enabled_flag');

1581: END IF;
1582: IF p_entity_attr_rec.enabled_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.enabled_flag IS NULL THEN
1583: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1584: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1585: Fnd_Message.set_token('COLUMN','enabled_flag');
1586: Fnd_Msg_Pub.ADD;
1587: END IF;
1588: x_return_status := Fnd_Api.g_ret_sts_error;
1589: RETURN;

Line 1593: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1589: RETURN;
1590: END IF;
1591: IF p_entity_attr_rec.display_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.display_flag IS NULL THEN
1592: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1593: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1594: Fnd_Message.set_token('COLUMN','display_flag');
1595: Fnd_Msg_Pub.ADD;
1596: END IF;
1597: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1594: Fnd_Message.set_token('COLUMN','display_flag');

1590: END IF;
1591: IF p_entity_attr_rec.display_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.display_flag IS NULL THEN
1592: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1593: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1594: Fnd_Message.set_token('COLUMN','display_flag');
1595: Fnd_Msg_Pub.ADD;
1596: END IF;
1597: x_return_status := Fnd_Api.g_ret_sts_error;
1598: RETURN;

Line 1602: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1598: RETURN;
1599: END IF;
1600: /*IF p_entity_attr_rec.auto_assign_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.auto_assign_flag IS NULL THEN
1601: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1602: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1603: Fnd_Message.set_token('COLUMN','auto_assign_flag');
1604: Fnd_Msg_Pub.ADD;
1605: END IF;
1606: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1603: Fnd_Message.set_token('COLUMN','auto_assign_flag');

1599: END IF;
1600: /*IF p_entity_attr_rec.auto_assign_flag = Fnd_Api.g_miss_char OR p_entity_attr_rec.auto_assign_flag IS NULL THEN
1601: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1602: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1603: Fnd_Message.set_token('COLUMN','auto_assign_flag');
1604: Fnd_Msg_Pub.ADD;
1605: END IF;
1606: x_return_status := Fnd_Api.g_ret_sts_error;
1607: RETURN;

Line 1613: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1609: */
1610: ELSE
1611: IF p_entity_attr_rec.entity_attr_id IS NULL THEN
1612: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1613: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1614: Fnd_Message.set_token('COLUMN','entity_attr_id');
1615: Fnd_Msg_Pub.ADD;
1616: END IF;
1617: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1614: Fnd_Message.set_token('COLUMN','entity_attr_id');

1610: ELSE
1611: IF p_entity_attr_rec.entity_attr_id IS NULL THEN
1612: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1613: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1614: Fnd_Message.set_token('COLUMN','entity_attr_id');
1615: Fnd_Msg_Pub.ADD;
1616: END IF;
1617: x_return_status := Fnd_Api.g_ret_sts_error;
1618: RETURN;

Line 1622: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1618: RETURN;
1619: END IF;
1620: IF p_entity_attr_rec.last_update_date IS NULL THEN
1621: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1622: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1623: Fnd_Message.set_token('COLUMN','last_update_date');
1624: Fnd_Msg_Pub.ADD;
1625: END IF;
1626: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1623: Fnd_Message.set_token('COLUMN','last_update_date');

1619: END IF;
1620: IF p_entity_attr_rec.last_update_date IS NULL THEN
1621: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1622: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1623: Fnd_Message.set_token('COLUMN','last_update_date');
1624: Fnd_Msg_Pub.ADD;
1625: END IF;
1626: x_return_status := Fnd_Api.g_ret_sts_error;
1627: RETURN;

Line 1631: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1627: RETURN;
1628: END IF;
1629: IF p_entity_attr_rec.last_updated_by IS NULL THEN
1630: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1631: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1632: Fnd_Message.set_token('COLUMN','last_updated_by');
1633: Fnd_Msg_Pub.ADD;
1634: END IF;
1635: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1632: Fnd_Message.set_token('COLUMN','last_updated_by');

1628: END IF;
1629: IF p_entity_attr_rec.last_updated_by IS NULL THEN
1630: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1631: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1632: Fnd_Message.set_token('COLUMN','last_updated_by');
1633: Fnd_Msg_Pub.ADD;
1634: END IF;
1635: x_return_status := Fnd_Api.g_ret_sts_error;
1636: RETURN;

Line 1640: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1636: RETURN;
1637: END IF;
1638: IF p_entity_attr_rec.creation_date IS NULL THEN
1639: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1640: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1641: Fnd_Message.set_token('COLUMN','creation_date');
1642: Fnd_Msg_Pub.ADD;
1643: END IF;
1644: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1641: Fnd_Message.set_token('COLUMN','creation_date');

1637: END IF;
1638: IF p_entity_attr_rec.creation_date IS NULL THEN
1639: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1640: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1641: Fnd_Message.set_token('COLUMN','creation_date');
1642: Fnd_Msg_Pub.ADD;
1643: END IF;
1644: x_return_status := Fnd_Api.g_ret_sts_error;
1645: RETURN;

Line 1649: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1645: RETURN;
1646: END IF;
1647: IF p_entity_attr_rec.created_by IS NULL THEN
1648: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1649: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1650: Fnd_Message.set_token('COLUMN','created_by');
1651: Fnd_Msg_Pub.ADD;
1652: END IF;
1653: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1650: Fnd_Message.set_token('COLUMN','created_by');

1646: END IF;
1647: IF p_entity_attr_rec.created_by IS NULL THEN
1648: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1649: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1650: Fnd_Message.set_token('COLUMN','created_by');
1651: Fnd_Msg_Pub.ADD;
1652: END IF;
1653: x_return_status := Fnd_Api.g_ret_sts_error;
1654: RETURN;

Line 1658: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1654: RETURN;
1655: END IF;
1656: IF p_entity_attr_rec.last_update_login IS NULL THEN
1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1658: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1659: Fnd_Message.set_token('COLUMN','last_update_login');
1660: Fnd_Msg_Pub.ADD;
1661: END IF;
1662: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1659: Fnd_Message.set_token('COLUMN','last_update_login');

1655: END IF;
1656: IF p_entity_attr_rec.last_update_login IS NULL THEN
1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1658: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1659: Fnd_Message.set_token('COLUMN','last_update_login');
1660: Fnd_Msg_Pub.ADD;
1661: END IF;
1662: x_return_status := Fnd_Api.g_ret_sts_error;
1663: RETURN;

Line 1667: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1663: RETURN;
1664: END IF;
1665: IF p_entity_attr_rec.object_version_number IS NULL THEN
1666: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1667: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1668: Fnd_Message.set_token('COLUMN','object_version_number');
1669: Fnd_Msg_Pub.ADD;
1670: END IF;
1671: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1668: Fnd_Message.set_token('COLUMN','object_version_number');

1664: END IF;
1665: IF p_entity_attr_rec.object_version_number IS NULL THEN
1666: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1667: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1668: Fnd_Message.set_token('COLUMN','object_version_number');
1669: Fnd_Msg_Pub.ADD;
1670: END IF;
1671: x_return_status := Fnd_Api.g_ret_sts_error;
1672: RETURN;

Line 1676: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1672: RETURN;
1673: END IF;
1674: IF p_entity_attr_rec.attribute_id IS NULL THEN
1675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1676: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1677: Fnd_Message.set_token('COLUMN','attribute_id');
1678: Fnd_Msg_Pub.ADD;
1679: END IF;
1680: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1677: Fnd_Message.set_token('COLUMN','attribute_id');

1673: END IF;
1674: IF p_entity_attr_rec.attribute_id IS NULL THEN
1675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1676: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1677: Fnd_Message.set_token('COLUMN','attribute_id');
1678: Fnd_Msg_Pub.ADD;
1679: END IF;
1680: x_return_status := Fnd_Api.g_ret_sts_error;
1681: RETURN;

Line 1685: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1681: RETURN;
1682: END IF;
1683: IF p_entity_attr_rec.entity IS NULL THEN
1684: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1685: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1686: Fnd_Message.set_token('COLUMN','entity');
1687: Fnd_Msg_Pub.ADD;
1688: END IF;
1689: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1686: Fnd_Message.set_token('COLUMN','entity');

1682: END IF;
1683: IF p_entity_attr_rec.entity IS NULL THEN
1684: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1685: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1686: Fnd_Message.set_token('COLUMN','entity');
1687: Fnd_Msg_Pub.ADD;
1688: END IF;
1689: x_return_status := Fnd_Api.g_ret_sts_error;
1690: RETURN;

Line 1694: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1690: RETURN;
1691: END IF;
1692: IF p_entity_attr_rec.enabled_flag IS NULL THEN
1693: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1694: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1695: Fnd_Message.set_token('COLUMN','enabled_flag');
1696: Fnd_Msg_Pub.ADD;
1697: END IF;
1698: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1695: Fnd_Message.set_token('COLUMN','enabled_flag');

1691: END IF;
1692: IF p_entity_attr_rec.enabled_flag IS NULL THEN
1693: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1694: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1695: Fnd_Message.set_token('COLUMN','enabled_flag');
1696: Fnd_Msg_Pub.ADD;
1697: END IF;
1698: x_return_status := Fnd_Api.g_ret_sts_error;
1699: RETURN;

Line 1703: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1699: RETURN;
1700: END IF;
1701: IF p_entity_attr_rec.display_flag IS NULL THEN
1702: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1703: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1704: Fnd_Message.set_token('COLUMN','display_flag');
1705: Fnd_Msg_Pub.ADD;
1706: END IF;
1707: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1704: Fnd_Message.set_token('COLUMN','display_flag');

1700: END IF;
1701: IF p_entity_attr_rec.display_flag IS NULL THEN
1702: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1703: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1704: Fnd_Message.set_token('COLUMN','display_flag');
1705: Fnd_Msg_Pub.ADD;
1706: END IF;
1707: x_return_status := Fnd_Api.g_ret_sts_error;
1708: RETURN;

Line 1712: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');

1708: RETURN;
1709: END IF;
1710: /*IF p_entity_attr_rec.auto_assign_flag IS NULL THEN
1711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1712: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1713: Fnd_Message.set_token('COLUMN','auto_assign_flag');
1714: Fnd_Msg_Pub.ADD;
1715: END IF;
1716: x_return_status := Fnd_Api.g_ret_sts_error;

Line 1713: Fnd_Message.set_token('COLUMN','auto_assign_flag');

1709: END IF;
1710: /*IF p_entity_attr_rec.auto_assign_flag IS NULL THEN
1711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1712: Fnd_Message.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1713: Fnd_Message.set_token('COLUMN','auto_assign_flag');
1714: Fnd_Msg_Pub.ADD;
1715: END IF;
1716: x_return_status := Fnd_Api.g_ret_sts_error;
1717: RETURN;