eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PV_ENTITY_ATTRIBUTE_PVT dependencies on FND_MSG_PUB

Line 87: Fnd_Msg_Pub.initialize;

83:
84: -- Initialize message list if p_init_msg_list is set to TRUE.
85: IF Fnd_Api.to_Boolean( p_init_msg_list )
86: THEN
87: Fnd_Msg_Pub.initialize;
88: END IF;
89:
90: -- Debug Message
91: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

Line 91: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

87: Fnd_Msg_Pub.initialize;
88: END IF;
89:
90: -- Debug Message
91: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
92: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || ' start');
93: END IF;
94:
95: -- Initialize API return status to SUCCESS

Line 118: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

114: and not (l_attribute_type = 'DROPDOWN'
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

Line 145: Fnd_Msg_Pub.ADD;

141: END LOOP;
142: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
143:
144:
145: Fnd_Msg_Pub.ADD;
146: END IF;
147: RAISE Fnd_Api.G_EXC_ERROR;
148: end if;
149: */

Line 204: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

200: -- =========================================================================
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;

Line 206: Fnd_Msg_Pub.ADD;

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;
210:

Line 214: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

210:
211: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
212: THEN
213: -- Debug message
214: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
215: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Entity_Attr');
216: END IF;
217: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_Entity_Attr' );
218:

Line 251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

247:
248: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
249:
250: -- Debug Message
251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
252: Pvx_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
253: END IF;
254:
255: --display flag should be Y for LEAd entity for the following types

Line 321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

317: THEN
318: COMMIT WORK;
319: END IF;
320: -- Debug Message
321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
322: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
323: END IF;
324: -- Standard call to get message count and if count is 1, get message info.
325: Fnd_Msg_Pub.Count_And_Get

Line 325: Fnd_Msg_Pub.Count_And_Get

321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
322: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
323: END IF;
324: -- Standard call to get message count and if count is 1, get message info.
325: Fnd_Msg_Pub.Count_And_Get
326: (p_count => x_msg_count,
327: p_data => x_msg_data
328: );
329: EXCEPTION

Line 339: Fnd_Msg_Pub.Count_And_Get (

335: WHEN Fnd_Api.G_EXC_ERROR THEN
336: ROLLBACK TO Create_Entity_Attr_PVT;
337: x_return_status := Fnd_Api.G_RET_STS_ERROR;
338: -- Standard call to get message count and if count=1, get the message
339: Fnd_Msg_Pub.Count_And_Get (
340: p_encoded => Fnd_Api.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );

Line 348: Fnd_Msg_Pub.Count_And_Get (

344: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
345: ROLLBACK TO Create_Entity_Attr_PVT;
346: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
347: -- Standard call to get message count and if count=1, get the message
348: Fnd_Msg_Pub.Count_And_Get (
349: p_encoded => Fnd_Api.G_FALSE,
350: p_count => x_msg_count,
351: p_data => x_msg_data
352: );

Line 356: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

352: );
353: WHEN OTHERS THEN
354: ROLLBACK TO Create_Entity_Attr_PVT;
355: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
356: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360: -- Standard call to get message count and if count=1, get the message

Line 358: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

354: ROLLBACK TO Create_Entity_Attr_PVT;
355: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
356: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
357: THEN
358: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360: -- Standard call to get message count and if count=1, get the message
361: Fnd_Msg_Pub.Count_And_Get (
362: p_encoded => Fnd_Api.G_FALSE,

Line 361: Fnd_Msg_Pub.Count_And_Get (

357: THEN
358: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
359: END IF;
360: -- Standard call to get message count and if count=1, get the message
361: Fnd_Msg_Pub.Count_And_Get (
362: p_encoded => Fnd_Api.G_FALSE,
363: p_count => x_msg_count,
364: p_data => x_msg_data
365: );

Line 425: Fnd_Msg_Pub.initialize;

421:
422: -- Initialize message list if p_init_msg_list is set to TRUE.
423: IF Fnd_Api.to_Boolean( p_init_msg_list )
424: THEN
425: Fnd_Msg_Pub.initialize;
426: END IF;
427:
428: -- Debug Message
429: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 429: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

425: Fnd_Msg_Pub.initialize;
426: END IF;
427:
428: -- Debug Message
429: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
430: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
431: END IF;
432: -- Initialize API return status to SUCCESS
433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 436: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

432: -- Initialize API return status to SUCCESS
433: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
434:
435: -- Debug Message
436: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
437: Pvx_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
438: END IF;
439: OPEN c_get_Entity_Attribute( l_tar_entity_attr_rec.entity_attr_id);
440:

Line 448: Fnd_Msg_Pub.ADD;

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:
452: -- Debug Message

Line 453: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

449: RAISE Fnd_Api.G_EXC_ERROR;
450: END IF;
451:
452: -- Debug Message
453: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
454: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
455: END IF;
456:
457: CLOSE c_get_Entity_Attribute;

Line 520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

516: end if;
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;

Line 523: Fnd_Msg_Pub.ADD;

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;
527:

Line 533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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;
537: RAISE Fnd_Api.G_EXC_ERROR;

Line 535: Fnd_Msg_Pub.ADD;

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;
539:

Line 543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

539:
540: IF ( P_validation_level >= Fnd_Api.G_VALID_LEVEL_FULL)
541: THEN
542: -- Debug message
543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
544: Pvx_Utility_Pvt.debug_message('Private API: Validate_Entity_Attr');
545: END IF;
546: -- Invoke validation procedures
547: Validate_Entity_Attr(

Line 561: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

557: IF x_return_status<>Fnd_Api.G_RET_STS_SUCCESS THEN
558: RAISE Fnd_Api.G_EXC_ERROR;
559: END IF;
560: -- Debug Message
561: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
562: Pvx_Utility_Pvt.debug_message('Private API: '||l_full_name||' - Calling update table handler');
563: END IF;
564:
565:

Line 605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

601: THEN
602: COMMIT WORK;
603: END IF;
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
606: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
607: END IF;
608: -- Standard call to get message count and if count is 1, get message info.
609: Fnd_Msg_Pub.Count_And_Get

Line 609: Fnd_Msg_Pub.Count_And_Get

605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
606: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
607: END IF;
608: -- Standard call to get message count and if count is 1, get message info.
609: Fnd_Msg_Pub.Count_And_Get
610: (p_count => x_msg_count,
611: p_data => x_msg_data
612: );
613: EXCEPTION

Line 623: Fnd_Msg_Pub.Count_And_Get (

619: WHEN Fnd_Api.G_EXC_ERROR THEN
620: ROLLBACK TO Update_Entity_Attr_PVT;
621: x_return_status := Fnd_Api.G_RET_STS_ERROR;
622: -- Standard call to get message count and if count=1, get the message
623: Fnd_Msg_Pub.Count_And_Get (
624: p_encoded => Fnd_Api.G_FALSE,
625: p_count => x_msg_count,
626: p_data => x_msg_data
627: );

Line 632: Fnd_Msg_Pub.Count_And_Get (

628: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
629: ROLLBACK TO Update_Entity_Attr_PVT;
630: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
631: -- Standard call to get message count and if count=1, get the message
632: Fnd_Msg_Pub.Count_And_Get (
633: p_encoded => Fnd_Api.G_FALSE,
634: p_count => x_msg_count,
635: p_data => x_msg_data
636: );

Line 640: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

636: );
637: WHEN OTHERS THEN
638: ROLLBACK TO Update_Entity_Attr_PVT;
639: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
640: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message

Line 642: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

638: ROLLBACK TO Update_Entity_Attr_PVT;
639: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
640: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
641: THEN
642: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
645: Fnd_Msg_Pub.Count_And_Get (
646: p_encoded => Fnd_Api.G_FALSE,

Line 645: Fnd_Msg_Pub.Count_And_Get (

641: THEN
642: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
643: END IF;
644: -- Standard call to get message count and if count=1, get the message
645: Fnd_Msg_Pub.Count_And_Get (
646: p_encoded => Fnd_Api.G_FALSE,
647: p_count => x_msg_count,
648: p_data => x_msg_data
649: );

Line 704: Fnd_Msg_Pub.initialize;

700:
701: -- Initialize message list if p_init_msg_list is set to TRUE.
702: IF Fnd_Api.to_Boolean( p_init_msg_list )
703: THEN
704: Fnd_Msg_Pub.initialize;
705: END IF;
706: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
707: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
708: END IF;

Line 706: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

702: IF Fnd_Api.to_Boolean( p_init_msg_list )
703: THEN
704: Fnd_Msg_Pub.initialize;
705: END IF;
706: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
707: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
708: END IF;
709:
710: -- Initialize API return status to SUCCESS

Line 747: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

743:
744:
745: if((l_left_bracket_pos = 0 or l_right_bracket_pos = 0) and p_sql_text is not null ) then
746:
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');

Line 748: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

744:
745: if((l_left_bracket_pos = 0 or l_right_bracket_pos = 0) and p_sql_text is not null ) then
746:
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);

Line 755: FND_MSG_PUB.Add;

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;
759: end if;

Line 777: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

773: (length(p_sql_text)- length(replace(p_sql_text,',','')) <>1)
774: )
775: ) then
776: -- no of parameters are more
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');

Line 778: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

774: )
775: ) then
776: -- no of parameters are more
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);

Line 785: FND_MSG_PUB.Add;

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;
789: end if;

Line 807: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

803: l_error_code := ''||SQLCODE;
804: l_error_message := ''|| SQLERRM;
805: l_parse_error2 := 'Y';
806:
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');

Line 808: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

804: l_error_message := ''|| SQLERRM;
805: l_parse_error2 := 'Y';
806:
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');

Line 817: FND_MSG_PUB.Add;

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;
821:

Line 826: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

822: end;
823:
824:
825: if(l_parse_error2 = 'Y' and p_sql_text is not null ) then
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');

Line 827: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

823:
824:
825: if(l_parse_error2 = 'Y' and p_sql_text is not null ) then
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');

Line 835: FND_MSG_PUB.Add;

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;
839: end if;

Line 845: Fnd_Msg_Pub.Count_And_Get

841: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
842: -- Debug Message
843: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
844: -- Standard call to get message count and if count is 1, get message info.
845: Fnd_Msg_Pub.Count_And_Get
846: (p_count => x_msg_count
847: ,p_data => x_msg_data
848: );
849: EXCEPTION

Line 859: Fnd_Msg_Pub.Count_And_Get (

855: WHEN Fnd_Api.G_EXC_ERROR THEN
856: ROLLBACK TO Validate_sql_text;
857: x_return_status := Fnd_Api.G_RET_STS_ERROR;
858: -- Standard call to get message count and if count=1, get the message
859: Fnd_Msg_Pub.Count_And_Get (
860: p_encoded => Fnd_Api.G_FALSE,
861: p_count => x_msg_count,
862: p_data => x_msg_data
863: );

Line 868: Fnd_Msg_Pub.Count_And_Get (

864: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
865: ROLLBACK TO Validate_sql_text;
866: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
867: -- Standard call to get message count and if count=1, get the message
868: Fnd_Msg_Pub.Count_And_Get (
869: p_encoded => Fnd_Api.G_FALSE,
870: p_count => x_msg_count,
871: p_data => x_msg_data
872: );

Line 877: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

873:
874: WHEN OTHERS THEN
875: ROLLBACK TO Validate_sql_text;
876: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
877: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: -- Standard call to get message count and if count=1, get the message

Line 879: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

875: ROLLBACK TO Validate_sql_text;
876: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
877: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
878: THEN
879: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: -- Standard call to get message count and if count=1, get the message
882: Fnd_Msg_Pub.Count_And_Get (
883: p_encoded => Fnd_Api.G_FALSE

Line 882: Fnd_Msg_Pub.Count_And_Get (

878: THEN
879: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
880: END IF;
881: -- Standard call to get message count and if count=1, get the message
882: Fnd_Msg_Pub.Count_And_Get (
883: p_encoded => Fnd_Api.G_FALSE
884: ,p_count => x_msg_count
885: ,p_data => x_msg_data
886: );

Line 946: Fnd_Msg_Pub.initialize;

942:
943: -- Initialize message list if p_init_msg_list is set to TRUE.
944: IF Fnd_Api.to_Boolean( p_init_msg_list )
945: THEN
946: Fnd_Msg_Pub.initialize;
947: END IF;
948: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
949: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
950: END IF;

Line 948: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

944: IF Fnd_Api.to_Boolean( p_init_msg_list )
945: THEN
946: Fnd_Msg_Pub.initialize;
947: END IF;
948: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
949: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'Start');
950: END IF;
951:
952: -- Initialize API return status to SUCCESS

Line 976: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

972: 'execute immediate ' ||''''|| l_lov_string || '''' ||
973: ' into lookup_code, lookup_meaning, lookup_description ' ||
974: ' using '|| p_attribute_id || ' ; end;'
975: ;
976: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
977: Pvx_Utility_Pvt.debug_message('Private API: ' || 'The query:--' || l_exec_sql_text);
978: END IF;
979:
980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);

Line 983: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

979:
980: DBMS_SQL.parse(v_cursor, l_exec_sql_text ,DBMS_SQL.NATIVE);
981: */
982:
983: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
984: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );
985: END IF;
986:
987: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;

Line 993: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

989:
990:
991: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;
992: EXIT WHEN lc_lov_cursor%NOTFOUND;
993: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
994: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );
995: END IF;
996:
997:

Line 1000: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

996:
997:
998: l_lov_result := l_lov_result || l_lookup_meaning || ', ';
999:
1000: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1001: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );
1002: END IF;
1003:
1004:

Line 1009: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1005: END LOOP;
1006:
1007: CLOSE lc_lov_cursor;
1008:
1009: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1010: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );
1011: END IF;
1012:
1013: x_lov_result := substr(l_lov_result,1, length(l_lov_result)-2);

Line 1024: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1020: l_error_message := ''|| SQLERRM;
1021: l_parse_error2 := 'Y';
1022:
1023:
1024: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1025: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Code:--' || l_error_code);
1026: END IF;
1027:
1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1024: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1025: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Code:--' || l_error_code);
1026: END IF;
1027:
1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);
1030: END IF;
1031:
1032: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

Line 1032: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1028: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);
1030: END IF;
1031:
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');

Line 1033: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1029: Pvx_Utility_Pvt.debug_message('Private API: ' || 'error Message:--' || l_error_message);
1030: END IF;
1031:
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');

Line 1042: FND_MSG_PUB.Add;

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;
1046:

Line 1049: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1045: RAISE FND_API.G_EXC_ERROR;
1046:
1047: end;
1048:
1049: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1050: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Lov String:--' || l_lov_string);
1051: END IF;
1052: /*
1053: if(l_parse_error2 = 'Y' and l_lov_string is not null ) then

Line 1054: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1050: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Lov String:--' || l_lov_string);
1051: END IF;
1052: /*
1053: if(l_parse_error2 = 'Y' and l_lov_string is not null ) then
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');

Line 1055: --IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1051: END IF;
1052: /*
1053: if(l_parse_error2 = 'Y' and l_lov_string is not null ) then
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');

Line 1063: FND_MSG_PUB.Add;

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;
1067: else

Line 1069: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1065:
1066: RAISE FND_API.G_EXC_ERROR;
1067: else
1068:
1069: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1070: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before opening cursor' );
1071: END IF;
1072:
1073: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;

Line 1076: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1072:
1073: OPEN lc_lov_cursor FOR l_lov_string USING p_attribute_id;
1074: LOOP
1075: EXIT WHEN lc_lov_cursor%NOTFOUND;
1076: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1077: Pvx_Utility_Pvt.debug_message('Private API: ' || 'Before fetching1' );
1078: END IF;
1079:
1080: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;

Line 1083: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1079:
1080: FETCH lc_lov_cursor INTO l_lookup_code, l_lookup_meaning, l_lookup_description;
1081:
1082: l_lov_result := l_lov_result || ',' || l_lookup_meaning || ' ';
1083: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1084: Pvx_Utility_Pvt.debug_message('Private API:' || l_lookup_meaning || ':' );
1085: END IF;
1086:
1087: END LOOP;

Line 1091: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1087: END LOOP;
1088:
1089: CLOSE lc_lov_cursor;
1090:
1091: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1092: Pvx_Utility_Pvt.debug_message('Private API: ' || 'closing cursor' );
1093: END IF;
1094: x_lov_result := substr(l_lov_result,1, length(l_lov_result)-1);
1095:

Line 1105: Fnd_Msg_Pub.Count_And_Get

1101: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1102: -- Debug Message
1103: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1104: -- Standard call to get message count and if count is 1, get message info.
1105: Fnd_Msg_Pub.Count_And_Get
1106: (p_count => x_msg_count
1107: ,p_data => x_msg_data
1108: );
1109: EXCEPTION

Line 1119: Fnd_Msg_Pub.Count_And_Get (

1115: WHEN Fnd_Api.G_EXC_ERROR THEN
1116: ROLLBACK TO Validate_lov_string;
1117: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1118: -- Standard call to get message count and if count=1, get the message
1119: Fnd_Msg_Pub.Count_And_Get (
1120: p_encoded => Fnd_Api.G_FALSE,
1121: p_count => x_msg_count,
1122: p_data => x_msg_data
1123: );

Line 1128: Fnd_Msg_Pub.Count_And_Get (

1124: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1125: ROLLBACK TO Validate_lov_string;
1126: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1127: -- Standard call to get message count and if count=1, get the message
1128: Fnd_Msg_Pub.Count_And_Get (
1129: p_encoded => Fnd_Api.G_FALSE,
1130: p_count => x_msg_count,
1131: p_data => x_msg_data
1132: );

Line 1137: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1133:
1134: WHEN OTHERS THEN
1135: ROLLBACK TO Validate_lov_string;
1136: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1137: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1140: END IF;
1141: -- Standard call to get message count and if count=1, get the message

Line 1139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1135: ROLLBACK TO Validate_lov_string;
1136: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1137: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1138: THEN
1139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1140: END IF;
1141: -- Standard call to get message count and if count=1, get the message
1142: Fnd_Msg_Pub.Count_And_Get (
1143: p_encoded => Fnd_Api.G_FALSE

Line 1142: Fnd_Msg_Pub.Count_And_Get (

1138: THEN
1139: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1140: END IF;
1141: -- Standard call to get message count and if count=1, get the message
1142: Fnd_Msg_Pub.Count_And_Get (
1143: p_encoded => Fnd_Api.G_FALSE
1144: ,p_count => x_msg_count
1145: ,p_data => x_msg_data
1146: );

Line 1207: Fnd_Msg_Pub.initialize;

1203: END IF;
1204: -- Initialize message list if p_init_msg_list is set to TRUE.
1205: IF Fnd_Api.to_Boolean( p_init_msg_list )
1206: THEN
1207: Fnd_Msg_Pub.initialize;
1208: END IF;
1209: -- Debug Message
1210: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1211: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');

Line 1210: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1206: THEN
1207: Fnd_Msg_Pub.initialize;
1208: END IF;
1209: -- Debug Message
1210: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1211: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
1212: END IF;
1213: -- Initialize API return status to SUCCESS
1214: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 1238: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1234:
1235:
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 );

Line 1244: FND_MSG_PUB.Add;

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;
1248:

Line 1262: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)

1258:
1259:
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 );

Line 1268: FND_MSG_PUB.Add;

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;
1272:

Line 1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1275:
1276:
1277:
1278: -- Debug Message
1279: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1280: Pvx_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
1281: END IF;
1282: -- Invoke table handler(PV_ENTITY_ATTRS_PKG.Delete_Row)
1283: Pv_Entity_Attrs_Pkg.Delete_Row(

Line 1294: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1290: THEN
1291: COMMIT WORK;
1292: END IF;
1293: -- Debug Message
1294: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1295: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1296: END IF;
1297: -- Standard call to get message count and if count is 1, get message info.
1298: Fnd_Msg_Pub.Count_And_Get

Line 1298: Fnd_Msg_Pub.Count_And_Get

1294: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1295: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
1296: END IF;
1297: -- Standard call to get message count and if count is 1, get message info.
1298: Fnd_Msg_Pub.Count_And_Get
1299: (p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );
1302: EXCEPTION

Line 1312: Fnd_Msg_Pub.Count_And_Get (

1308: WHEN Fnd_Api.G_EXC_ERROR THEN
1309: ROLLBACK TO Delete_Entity_Attr_PVT;
1310: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1311: -- Standard call to get message count and if count=1, get the message
1312: Fnd_Msg_Pub.Count_And_Get (
1313: p_encoded => Fnd_Api.G_FALSE,
1314: p_count => x_msg_count,
1315: p_data => x_msg_data
1316: );

Line 1321: Fnd_Msg_Pub.Count_And_Get (

1317: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1318: ROLLBACK TO Delete_Entity_Attr_PVT;
1319: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1320: -- Standard call to get message count and if count=1, get the message
1321: Fnd_Msg_Pub.Count_And_Get (
1322: p_encoded => Fnd_Api.G_FALSE,
1323: p_count => x_msg_count,
1324: p_data => x_msg_data
1325: );

Line 1329: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1325: );
1326: WHEN OTHERS THEN
1327: ROLLBACK TO Delete_Entity_Attr_PVT;
1328: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1329: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1332: END IF;
1333: -- Standard call to get message count and if count=1, get the message

Line 1331: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1327: ROLLBACK TO Delete_Entity_Attr_PVT;
1328: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1329: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1330: THEN
1331: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1332: END IF;
1333: -- Standard call to get message count and if count=1, get the message
1334: Fnd_Msg_Pub.Count_And_Get (
1335: p_encoded => Fnd_Api.G_FALSE,

Line 1334: Fnd_Msg_Pub.Count_And_Get (

1330: THEN
1331: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1332: END IF;
1333: -- Standard call to get message count and if count=1, get the message
1334: Fnd_Msg_Pub.Count_And_Get (
1335: p_encoded => Fnd_Api.G_FALSE,
1336: p_count => x_msg_count,
1337: p_data => x_msg_data
1338: );

Line 1364: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1360: AND object_version_number = p_object_version
1361: FOR UPDATE NOWAIT;
1362: BEGIN
1363: -- Debug Message
1364: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1365: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
1366: END IF;
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF Fnd_Api.to_Boolean( p_init_msg_list )

Line 1370: Fnd_Msg_Pub.initialize;

1366: END IF;
1367: -- Initialize message list if p_init_msg_list is set to TRUE.
1368: IF Fnd_Api.to_Boolean( p_init_msg_list )
1369: THEN
1370: Fnd_Msg_Pub.initialize;
1371: END IF;
1372: -- Standard call to check for call compatibility.
1373: IF NOT Fnd_Api.Compatible_API_Call ( l_api_version_number,
1374: p_api_version_number,

Line 1384: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1380: -- Initialize API return status to SUCCESS
1381: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
1382:
1383: ------------------------ lock -------------------------
1384: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1385: Pvx_Utility_Pvt.debug_message(l_full_name||': start');
1386: END IF;
1387: OPEN c_Entity_Attribute;
1388: FETCH c_Entity_Attribute INTO l_ENTITY_ATTR_ID;

Line 1391: IF Fnd_Msg_Pub.check_msg_level(Fnd_Msg_Pub.g_msg_lvl_error) THEN

1387: OPEN c_Entity_Attribute;
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;

Line 1393: Fnd_Msg_Pub.ADD;

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;
1397: CLOSE c_Entity_Attribute;

Line 1399: Fnd_Msg_Pub.count_and_get(

1395: RAISE Fnd_Api.g_exc_error;
1396: END IF;
1397: CLOSE c_Entity_Attribute;
1398: -------------------- finish --------------------------
1399: Fnd_Msg_Pub.count_and_get(
1400: p_encoded => Fnd_Api.g_false,
1401: p_count => x_msg_count,
1402: p_data => x_msg_data);
1403: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

Line 1403: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

1399: Fnd_Msg_Pub.count_and_get(
1400: p_encoded => Fnd_Api.g_false,
1401: p_count => x_msg_count,
1402: p_data => x_msg_data);
1403: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1404: Pvx_Utility_Pvt.debug_message(l_full_name ||': end');
1405: END IF;
1406: EXCEPTION
1407: /*

Line 1416: Fnd_Msg_Pub.Count_And_Get (

1412: WHEN Fnd_Api.G_EXC_ERROR THEN
1413: ROLLBACK TO Lock_Entity_Attr_PVT;
1414: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1415: -- Standard call to get message count and if count=1, get the message
1416: Fnd_Msg_Pub.Count_And_Get (
1417: p_encoded => Fnd_Api.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );

Line 1425: Fnd_Msg_Pub.Count_And_Get (

1421: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1422: ROLLBACK TO Lock_Entity_Attr_PVT;
1423: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1424: -- Standard call to get message count and if count=1, get the message
1425: Fnd_Msg_Pub.Count_And_Get (
1426: p_encoded => Fnd_Api.G_FALSE,
1427: p_count => x_msg_count,
1428: p_data => x_msg_data
1429: );

Line 1433: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

1429: );
1430: WHEN OTHERS THEN
1431: ROLLBACK TO Lock_Entity_Attr_PVT;
1432: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1433: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1436: END IF;
1437:

Line 1435: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1431: ROLLBACK TO Lock_Entity_Attr_PVT;
1432: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1433: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
1434: THEN
1435: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1436: END IF;
1437:
1438: -- Standard call to get message count and if count=1, get the message
1439: Fnd_Msg_Pub.Count_And_Get (

Line 1439: Fnd_Msg_Pub.Count_And_Get (

1435: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1436: END IF;
1437:
1438: -- Standard call to get message count and if count=1, get the message
1439: Fnd_Msg_Pub.Count_And_Get (
1440: p_encoded => Fnd_Api.G_FALSE,
1441: p_count => x_msg_count,
1442: p_data => x_msg_data
1443: );

Line 1467: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1463: ''' AND ENTITY_ATTR_ID <> ' || p_entity_attr_rec.ENTITY_ATTR_ID
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;

Line 1471: Fnd_Msg_Pub.ADD;

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;
1475: END IF;

Line 1497: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1493:
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;

Line 1500: Fnd_Msg_Pub.ADD;

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;
1504: END IF;

Line 1506: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1502: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1509: Fnd_Msg_Pub.ADD;

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;
1513: END IF;

Line 1515: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1511: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1518: Fnd_Msg_Pub.ADD;

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;
1522: END IF;

Line 1524: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1520: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1527: Fnd_Msg_Pub.ADD;

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;
1531: END IF;

Line 1533: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1529: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1536: Fnd_Msg_Pub.ADD;

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;
1540: END IF;

Line 1543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1539: RETURN;
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;

Line 1546: Fnd_Msg_Pub.ADD;

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;
1550: END IF;

Line 1552: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1548: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1555: Fnd_Msg_Pub.ADD;

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;
1559: END IF;

Line 1563: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1559: END IF;
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;

Line 1566: Fnd_Msg_Pub.ADD;

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;
1570: END IF;

Line 1574: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1570: END IF;
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;

Line 1577: Fnd_Msg_Pub.ADD;

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;
1581: END IF;

Line 1583: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1579: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1586: Fnd_Msg_Pub.ADD;

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;
1590: END IF;

Line 1592: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1588: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1595: Fnd_Msg_Pub.ADD;

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;
1599: END IF;

Line 1601: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1597: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1604: Fnd_Msg_Pub.ADD;

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;
1608: END IF;

Line 1612: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1608: END IF;
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;

Line 1615: Fnd_Msg_Pub.ADD;

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;
1619: END IF;

Line 1621: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1617: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1624: Fnd_Msg_Pub.ADD;

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;
1628: END IF;

Line 1630: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1626: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1633: Fnd_Msg_Pub.ADD;

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;
1637: END IF;

Line 1639: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1635: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1642: Fnd_Msg_Pub.ADD;

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;
1646: END IF;

Line 1648: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1644: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1651: Fnd_Msg_Pub.ADD;

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;
1655: END IF;

Line 1657: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1653: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1660: Fnd_Msg_Pub.ADD;

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;
1664: END IF;

Line 1666: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1662: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1669: Fnd_Msg_Pub.ADD;

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;
1673: END IF;

Line 1675: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1671: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1678: Fnd_Msg_Pub.ADD;

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;
1682: END IF;

Line 1684: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1680: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1687: Fnd_Msg_Pub.ADD;

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;
1691: END IF;

Line 1693: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1689: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1696: Fnd_Msg_Pub.ADD;

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;
1700: END IF;

Line 1702: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1698: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1705: Fnd_Msg_Pub.ADD;

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;
1709: END IF;

Line 1711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

1707: x_return_status := Fnd_Api.g_ret_sts_error;
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;

Line 1714: Fnd_Msg_Pub.ADD;

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;
1718: END IF;

Line 1994: Fnd_Msg_Pub.initialize;

1990:
1991: -- Initialize message list if p_init_msg_list is set to TRUE.
1992: IF Fnd_Api.to_Boolean( p_init_msg_list )
1993: THEN
1994: Fnd_Msg_Pub.initialize;
1995: END IF;
1996:
1997: IF p_validation_level >= Jtf_Plsql_Api.g_valid_level_item THEN
1998:

Line 2036: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

2032: RAISE Fnd_Api.G_EXC_UNEXPECTED_ERROR;
2033: END IF;
2034: END IF;
2035: -- Debug Message
2036: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2037: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'start');
2038: END IF;
2039: -- Initialize API return status to SUCCESS
2040: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 2042: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

2038: END IF;
2039: -- Initialize API return status to SUCCESS
2040: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;
2041: -- Debug Message
2042: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2043: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
2044: END IF;
2045: -- Standard call to get message count and if count is 1, get message info.
2046: Fnd_Msg_Pub.Count_And_Get

Line 2046: Fnd_Msg_Pub.Count_And_Get

2042: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2043: Pvx_Utility_Pvt.debug_message('Private API: ' || l_api_name || 'end');
2044: END IF;
2045: -- Standard call to get message count and if count is 1, get message info.
2046: Fnd_Msg_Pub.Count_And_Get
2047: (p_count => x_msg_count
2048: ,p_data => x_msg_data
2049: );
2050: EXCEPTION

Line 2060: Fnd_Msg_Pub.Count_And_Get (

2056: WHEN Fnd_Api.G_EXC_ERROR THEN
2057: ROLLBACK TO Validate_Entity_Attr_;
2058: x_return_status := Fnd_Api.G_RET_STS_ERROR;
2059: -- Standard call to get message count and if count=1, get the message
2060: Fnd_Msg_Pub.Count_And_Get (
2061: p_encoded => Fnd_Api.G_FALSE,
2062: p_count => x_msg_count,
2063: p_data => x_msg_data
2064: );

Line 2069: Fnd_Msg_Pub.Count_And_Get (

2065: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
2066: ROLLBACK TO Validate_Entity_Attr_;
2067: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2068: -- Standard call to get message count and if count=1, get the message
2069: Fnd_Msg_Pub.Count_And_Get (
2070: p_encoded => Fnd_Api.G_FALSE,
2071: p_count => x_msg_count,
2072: p_data => x_msg_data
2073: );

Line 2078: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)

2074:
2075: WHEN OTHERS THEN
2076: ROLLBACK TO Validate_Entity_Attr_;
2077: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2078: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: -- Standard call to get message count and if count=1, get the message

Line 2080: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);

2076: ROLLBACK TO Validate_Entity_Attr_;
2077: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
2078: IF Fnd_Msg_Pub.Check_Msg_Level ( Fnd_Msg_Pub.G_MSG_LVL_UNEXP_ERROR)
2079: THEN
2080: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: -- Standard call to get message count and if count=1, get the message
2083: Fnd_Msg_Pub.Count_And_Get (
2084: p_encoded => Fnd_Api.G_FALSE

Line 2083: Fnd_Msg_Pub.Count_And_Get (

2079: THEN
2080: Fnd_Msg_Pub.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2081: END IF;
2082: -- Standard call to get message count and if count=1, get the message
2083: Fnd_Msg_Pub.Count_And_Get (
2084: p_encoded => Fnd_Api.G_FALSE
2085: ,p_count => x_msg_count
2086: ,p_data => x_msg_data
2087: );

Line 2105: Fnd_Msg_Pub.initialize;

2101: BEGIN
2102: -- Initialize message list if p_init_msg_list is set to TRUE.
2103: IF Fnd_Api.to_Boolean( p_init_msg_list )
2104: THEN
2105: Fnd_Msg_Pub.initialize;
2106: END IF;
2107:
2108: -- Initialize API return status to SUCCESS
2109: x_return_status := Fnd_Api.G_RET_STS_SUCCESS;

Line 2117: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

2113: -- THEN
2114: -- x_return_status := FND_API.G_RET_STS_ERROR;
2115:
2116: -- Debug Message
2117: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2118: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
2119: END IF;
2120:
2121: -- Standard call to get message count and if count is 1, get message info.

Line 2122: Fnd_Msg_Pub.Count_And_Get (

2118: Pvx_Utility_Pvt.debug_message('Private API: Validate_dm_model_rec');
2119: END IF;
2120:
2121: -- Standard call to get message count and if count is 1, get message info.
2122: Fnd_Msg_Pub.Count_And_Get (
2123: p_count => x_msg_count
2124: ,p_data => x_msg_data
2125: );
2126: END Validate_Entity_Attr_Rec;