APPS.PV_ENTY_ATTR_VALUE_PVT dependencies on FND_MSG_PUB

Line 94: FND_MSG_PUB.initialize;

90:
91: -- Initialize message list if p_init_msg_list is set to TRUE.
92: IF FND_API.to_Boolean( p_init_msg_list )
93: THEN
94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Debug Message
98: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

94: FND_MSG_PUB.initialize;
95: END IF;
96:
97: -- Debug Message
98: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
99: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
100: END IF;
101:
102:

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

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

Line 133: FND_MSG_PUB.add;

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

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

153: --We would not validate for entity ENRQ.
154: if ( p_enty_attr_val_rec.entity <> 'ENRQ')
155: then
156: -- Debug message
157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
158: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');
159: END IF;
160:
161: -- Invoke validation procedures

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

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

Line 231: Fnd_Msg_Pub.ADD;

227: END LOOP;
228: Fnd_Message.set_token('ATTR_STYLE',l_meaning);
229:
230:
231: Fnd_Msg_Pub.ADD;
232: END IF;
233: RAISE Fnd_Api.G_EXC_ERROR;
234:
235:

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

281: END IF;
282:
283:
284: -- Debug Message
285: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
286: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.

Line 290: FND_MSG_PUB.Count_And_Get (

286: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
287: END IF;
288:
289: -- Standard call to get message count and if count is 1, get message info.
290: FND_MSG_PUB.Count_And_Get (
291: p_count => x_msg_count
292: ,p_data => x_msg_data
293: );
294:

Line 305: FND_MSG_PUB.Count_And_Get (

301: WHEN FND_API.G_EXC_ERROR THEN
302: ROLLBACK TO Create_Attr_Value_PVT;
303: x_return_status := FND_API.G_RET_STS_ERROR;
304: -- Standard call to get message count and if count=1, get the message
305: FND_MSG_PUB.Count_And_Get (
306: p_encoded => FND_API.G_FALSE
307: ,p_count => x_msg_count
308: ,p_data => x_msg_data
309: );

Line 315: FND_MSG_PUB.Count_And_Get (

311: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
312: ROLLBACK TO Create_Attr_Value_PVT;
313: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
314: -- Standard call to get message count and if count=1, get the message
315: FND_MSG_PUB.Count_And_Get (
316: p_encoded => FND_API.G_FALSE
317: ,p_count => x_msg_count
318: ,p_data => x_msg_data
319: );

Line 324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

320:
321: WHEN OTHERS THEN
322: ROLLBACK TO Create_Attr_Value_PVT;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
327: END IF;
328: -- Standard call to get message count and if count=1, get the message

Line 326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

322: ROLLBACK TO Create_Attr_Value_PVT;
323: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
324: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
325: THEN
326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
327: END IF;
328: -- Standard call to get message count and if count=1, get the message
329: FND_MSG_PUB.Count_And_Get (
330: p_encoded => FND_API.G_FALSE

Line 329: FND_MSG_PUB.Count_And_Get (

325: THEN
326: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
327: END IF;
328: -- Standard call to get message count and if count=1, get the message
329: FND_MSG_PUB.Count_And_Get (
330: p_encoded => FND_API.G_FALSE
331: ,p_count => x_msg_count
332: ,p_data => x_msg_data
333: );

Line 385: FND_MSG_PUB.initialize;

381:
382: -- Initialize message list if p_init_msg_list is set to TRUE.
383: IF FND_API.to_Boolean( p_init_msg_list )
384: THEN
385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: -- Debug Message
389: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

385: FND_MSG_PUB.initialize;
386: END IF;
387:
388: -- Debug Message
389: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
390: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
391: END IF;
392:
393: -- Initialize API return status to SUCCESS

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

393: -- Initialize API return status to SUCCESS
394: x_return_status := FND_API.G_RET_STS_SUCCESS;
395:
396: -- Debug Message
397: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
398: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
399: END IF;
400:
401: OPEN c_get_Enty_Attr_Value( l_tar_enty_attr_val_rec.enty_attr_val_id);

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

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

Line 411: FND_MSG_PUB.add;

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

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

413: RAISE FND_API.G_EXC_ERROR;
414: END IF;
415:
416: -- Debug Message
417: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
418: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
419: END IF;
420: CLOSE c_get_Enty_Attr_Value;
421:

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

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

Line 428: FND_MSG_PUB.add;

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

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

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

Line 438: FND_MSG_PUB.add;

434: If (l_tar_enty_attr_val_rec.object_version_number <> l_ref_enty_attr_val_rec.object_version_number) Then
435: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
436: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
437: FND_MESSAGE.set_token('VALUE','Enty_Attr_Value');
438: FND_MSG_PUB.add;
439: END IF;
440: RAISE FND_API.G_EXC_ERROR;
441: End if;
442: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

445: --We would not validate for entity ENRQ.
446: if(p_enty_attr_val_rec.entity <> 'ENRQ')
447: then
448: -- Debug message
449: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
450: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_attr_value');
451: END IF;
452:
453: -- Invoke validation procedures

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

470: END IF;
471:
472:
473: -- Debug Message
474: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
475: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
476: END IF;
477:
478: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Update_Row)

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

509: COMMIT WORK;
510: END IF;
511:
512: -- Debug Message
513: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
514: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get (

Line 517: FND_MSG_PUB.Count_And_Get (

513: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
514: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
515: END IF;
516: -- Standard call to get message count and if count is 1, get message info.
517: FND_MSG_PUB.Count_And_Get (
518: p_count => x_msg_count
519: ,p_data => x_msg_data
520: );
521: EXCEPTION

Line 531: FND_MSG_PUB.Count_And_Get (

527: WHEN FND_API.G_EXC_ERROR THEN
528: ROLLBACK TO Update_Attr_Value_PVT;
529: x_return_status := FND_API.G_RET_STS_ERROR;
530: -- Standard call to get message count and if count=1, get the message
531: FND_MSG_PUB.Count_And_Get (
532: p_encoded => FND_API.G_FALSE
533: ,p_count => x_msg_count
534: ,p_data => x_msg_data
535: );

Line 541: FND_MSG_PUB.Count_And_Get (

537: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
538: ROLLBACK TO Update_Attr_Value_PVT;
539: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
540: -- Standard call to get message count and if count=1, get the message
541: FND_MSG_PUB.Count_And_Get (
542: p_encoded => FND_API.G_FALSE
543: ,p_count => x_msg_count
544: ,p_data => x_msg_data
545: );

Line 550: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

546:
547: WHEN OTHERS THEN
548: ROLLBACK TO Update_Attr_Value_PVT;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN
552: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
553: END IF;
554: -- Standard call to get message count and if count=1, get the message

Line 552: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

548: ROLLBACK TO Update_Attr_Value_PVT;
549: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
550: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
551: THEN
552: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
553: END IF;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE

Line 555: FND_MSG_PUB.Count_And_Get (

551: THEN
552: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
553: END IF;
554: -- Standard call to get message count and if count=1, get the message
555: FND_MSG_PUB.Count_And_Get (
556: p_encoded => FND_API.G_FALSE
557: ,p_count => x_msg_count
558: ,p_data => x_msg_data
559: );

Line 601: FND_MSG_PUB.initialize;

597:
598: -- Initialize message list if p_init_msg_list is set to TRUE.
599: IF FND_API.to_Boolean( p_init_msg_list )
600: THEN
601: FND_MSG_PUB.initialize;
602: END IF;
603:
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

601: FND_MSG_PUB.initialize;
602: END IF;
603:
604: -- Debug Message
605: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
606: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
607: END IF;
608: -- Initialize API return status to SUCCESS
609: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

611: --
612: -- Api body
613: --
614: -- Debug Message
615: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
616: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
617: END IF;
618: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Delete_Row)
619: PV_ENTY_ATTR_VALUES_PKG.Delete_Row(

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

628: COMMIT WORK;
629: END IF;
630:
631: -- Debug Message
632: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
633: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
634: END IF;
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get (

Line 636: FND_MSG_PUB.Count_And_Get (

632: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
633: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
634: END IF;
635: -- Standard call to get message count and if count is 1, get message info.
636: FND_MSG_PUB.Count_And_Get (
637: p_count => x_msg_count
638: ,p_data => x_msg_data
639: );
640: EXCEPTION

Line 650: FND_MSG_PUB.Count_And_Get (

646: WHEN FND_API.G_EXC_ERROR THEN
647: ROLLBACK TO Delete_Attr_Value_PVT;
648: x_return_status := FND_API.G_RET_STS_ERROR;
649: -- Standard call to get message count and if count=1, get the message
650: FND_MSG_PUB.Count_And_Get (
651: p_encoded => FND_API.G_FALSE
652: ,p_count => x_msg_count
653: ,p_data => x_msg_data
654: );

Line 660: FND_MSG_PUB.Count_And_Get (

656: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
657: ROLLBACK TO Delete_Attr_Value_PVT;
658: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
659: -- Standard call to get message count and if count=1, get the message
660: FND_MSG_PUB.Count_And_Get (
661: p_encoded => FND_API.G_FALSE
662: ,p_count => x_msg_count
663: ,p_data => x_msg_data
664: );

Line 669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

665:
666: WHEN OTHERS THEN
667: ROLLBACK TO Delete_Attr_Value_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
670: THEN
671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
672: END IF;
673: -- Standard call to get message count and if count=1, get the message

Line 671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

667: ROLLBACK TO Delete_Attr_Value_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
670: THEN
671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
672: END IF;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE

Line 674: FND_MSG_PUB.Count_And_Get (

670: THEN
671: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
672: END IF;
673: -- Standard call to get message count and if count=1, get the message
674: FND_MSG_PUB.Count_And_Get (
675: p_encoded => FND_API.G_FALSE
676: ,p_count => x_msg_count
677: ,p_data => x_msg_data
678: );

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

708:
709: BEGIN
710:
711: -- Debug Message
712: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
713: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
714: END IF;
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )

Line 718: FND_MSG_PUB.initialize;

714: END IF;
715: -- Initialize message list if p_init_msg_list is set to TRUE.
716: IF FND_API.to_Boolean( p_init_msg_list )
717: THEN
718: FND_MSG_PUB.initialize;
719: END IF;
720:
721: -- Standard call to check for call compatibility.
722: IF NOT FND_API.Compatible_API_Call (

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

733: x_return_status := FND_API.G_RET_STS_SUCCESS;
734:
735:
736: ------------------------ lock -------------------------
737: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
738: PVX_Utility_PVT.debug_message(l_full_name||': start');
739: END IF;
740: OPEN c_Enty_Attr_Value;
741:

Line 746: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN

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

Line 748: FND_MSG_PUB.add;

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

Line 756: FND_MSG_PUB.count_and_get(

752:
753: CLOSE c_Enty_Attr_Value;
754:
755: -------------------- finish --------------------------
756: FND_MSG_PUB.count_and_get(
757: p_encoded => FND_API.g_false
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data
760: );

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

757: p_encoded => FND_API.g_false
758: ,p_count => x_msg_count
759: ,p_data => x_msg_data
760: );
761: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
762: PVX_Utility_PVT.debug_message(l_full_name ||': end');
763: END IF;
764: EXCEPTION
765: /*

Line 774: FND_MSG_PUB.Count_And_Get (

770: WHEN FND_API.G_EXC_ERROR THEN
771: ROLLBACK TO Lock_Attr_Value_PVT;
772: x_return_status := FND_API.G_RET_STS_ERROR;
773: -- Standard call to get message count and if count=1, get the message
774: FND_MSG_PUB.Count_And_Get (
775: p_encoded => FND_API.G_FALSE
776: ,p_count => x_msg_count
777: ,p_data => x_msg_data
778: );

Line 784: FND_MSG_PUB.Count_And_Get (

780: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
781: ROLLBACK TO Lock_Attr_Value_PVT;
782: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get (
785: p_encoded => FND_API.G_FALSE
786: ,p_count => x_msg_count
787: ,p_data => x_msg_data
788: );

Line 793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

789:
790: WHEN OTHERS THEN
791: ROLLBACK TO Lock_Attr_Value_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
796: END IF;
797: -- Standard call to get message count and if count=1, get the message

Line 795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

791: ROLLBACK TO Lock_Attr_Value_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
794: THEN
795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
796: END IF;
797: -- Standard call to get message count and if count=1, get the message
798: FND_MSG_PUB.Count_And_Get (
799: p_encoded => FND_API.G_FALSE

Line 798: FND_MSG_PUB.Count_And_Get (

794: THEN
795: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
796: END IF;
797: -- Standard call to get message count and if count=1, get the message
798: FND_MSG_PUB.Count_And_Get (
799: p_encoded => FND_API.G_FALSE
800: ,p_count => x_msg_count
801: ,p_data => x_msg_data
802: );

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

828: );
829: END IF;
830:
831: IF l_valid_flag = FND_API.g_false THEN
832: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
833: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );
835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
836: FND_MSG_PUB.add;

Line 836: FND_MSG_PUB.add;

832: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
833: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
834: FND_MESSAGE.set_token('ID',to_char(p_enty_attr_val_rec.ENTY_ATTR_VAL_ID) );
835: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Value');
836: FND_MSG_PUB.add;
837: END IF;
838: x_return_status := FND_API.g_ret_sts_error;
839: RETURN;
840: END IF;

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

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

Line 867: FND_MSG_PUB.add;

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

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

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

Line 884: FND_MSG_PUB.add;

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

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

891: -- TO_CHAR(p_enty_attr_val_rec.last_updated_by));
892:
893: IF p_enty_attr_val_rec.last_updated_by = FND_API.g_miss_num
894: OR p_enty_attr_val_rec.last_updated_by IS NULL THEN
895: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
896: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
897: FND_MESSAGE.set_token('COLUMN','last_updated_by');
898: FND_MSG_PUB.add;
899: END IF;

Line 898: FND_MSG_PUB.add;

894: OR p_enty_attr_val_rec.last_updated_by IS NULL THEN
895: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
896: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
897: FND_MESSAGE.set_token('COLUMN','last_updated_by');
898: FND_MSG_PUB.add;
899: END IF;
900: x_return_status := FND_API.g_ret_sts_error;
901: RETURN;
902: END IF;

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

903:
904:
905: IF p_enty_attr_val_rec.creation_date = FND_API.g_miss_date
906: OR p_enty_attr_val_rec.creation_date IS NULL THEN
907: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
908: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
909: FND_MESSAGE.set_token('COLUMN','creation_date');
910: FND_MSG_PUB.add;
911: END IF;

Line 910: FND_MSG_PUB.add;

906: OR p_enty_attr_val_rec.creation_date IS NULL THEN
907: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
908: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
909: FND_MESSAGE.set_token('COLUMN','creation_date');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: RETURN;
914: END IF;

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

915:
916:
917: IF p_enty_attr_val_rec.created_by = FND_API.g_miss_num
918: OR p_enty_attr_val_rec.created_by IS NULL THEN
919: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
920: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
921: FND_MESSAGE.set_token('COLUMN','created_by');
922: FND_MSG_PUB.add;
923: END IF;

Line 922: FND_MSG_PUB.add;

918: OR p_enty_attr_val_rec.created_by IS NULL THEN
919: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
920: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
921: FND_MESSAGE.set_token('COLUMN','created_by');
922: FND_MSG_PUB.add;
923: END IF;
924: x_return_status := FND_API.g_ret_sts_error;
925: RETURN;
926: END IF;

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

927:
928:
929: IF p_enty_attr_val_rec.last_update_login = FND_API.g_miss_num
930: OR p_enty_attr_val_rec.last_update_login IS NULL THEN
931: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
932: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
933: FND_MESSAGE.set_token('COLUMN','last_update_login');
934: FND_MSG_PUB.add;
935: END IF;

Line 934: FND_MSG_PUB.add;

930: OR p_enty_attr_val_rec.last_update_login IS NULL THEN
931: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
932: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
933: FND_MESSAGE.set_token('COLUMN','last_update_login');
934: FND_MSG_PUB.add;
935: END IF;
936: x_return_status := FND_API.g_ret_sts_error;
937: RETURN;
938: END IF;

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

939:
940:
941: IF p_enty_attr_val_rec.object_version_number = FND_API.g_miss_num
942: OR p_enty_attr_val_rec.object_version_number IS NULL THEN
943: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
944: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
945: FND_MESSAGE.set_token('COLUMN','object_version_number');
946: FND_MSG_PUB.add;
947: END IF;

Line 946: FND_MSG_PUB.add;

942: OR p_enty_attr_val_rec.object_version_number IS NULL THEN
943: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
944: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
945: FND_MESSAGE.set_token('COLUMN','object_version_number');
946: FND_MSG_PUB.add;
947: END IF;
948: x_return_status := FND_API.g_ret_sts_error;
949: RETURN;
950: END IF;

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

951:
952:
953: IF p_enty_attr_val_rec.entity = FND_API.g_miss_char
954: OR p_enty_attr_val_rec.entity IS NULL THEN
955: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
956: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
957: FND_MESSAGE.set_token('COLUMN','entity');
958: FND_MSG_PUB.add;
959: END IF;

Line 958: FND_MSG_PUB.add;

954: OR p_enty_attr_val_rec.entity IS NULL THEN
955: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
956: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
957: FND_MESSAGE.set_token('COLUMN','entity');
958: FND_MSG_PUB.add;
959: END IF;
960: x_return_status := FND_API.g_ret_sts_error;
961: RETURN;
962: END IF;

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

963:
964:
965: IF p_enty_attr_val_rec.attribute_id = FND_API.g_miss_num
966: OR p_enty_attr_val_rec.attribute_id IS NULL THEN
967: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
968: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
969: FND_MESSAGE.set_token('COLUMN','attribute_id');
970: FND_MSG_PUB.add;
971: END IF;

Line 970: FND_MSG_PUB.add;

966: OR p_enty_attr_val_rec.attribute_id IS NULL THEN
967: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
968: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
969: FND_MESSAGE.set_token('COLUMN','attribute_id');
970: FND_MSG_PUB.add;
971: END IF;
972: x_return_status := FND_API.g_ret_sts_error;
973: RETURN;
974: END IF;

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

975:
976:
977: IF p_enty_attr_val_rec.enabled_flag = FND_API.g_miss_char
978: OR p_enty_attr_val_rec.enabled_flag IS NULL THEN
979: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
980: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
981: FND_MESSAGE.set_token('COLUMN','enabled_flag');
982: FND_MSG_PUB.add;
983: END IF;

Line 982: FND_MSG_PUB.add;

978: OR p_enty_attr_val_rec.enabled_flag IS NULL THEN
979: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
980: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
981: FND_MESSAGE.set_token('COLUMN','enabled_flag');
982: FND_MSG_PUB.add;
983: END IF;
984: x_return_status := FND_API.g_ret_sts_error;
985: RETURN;
986: END IF;

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

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

Line 994: FND_MSG_PUB.add;

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

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

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

Line 1006: FND_MSG_PUB.add;

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

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

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

Line 1017: FND_MSG_PUB.add;

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

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

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

Line 1028: FND_MSG_PUB.add;

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

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

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

Line 1039: FND_MSG_PUB.add;

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

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

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

Line 1051: FND_MSG_PUB.add;

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

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

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

Line 1062: FND_MSG_PUB.add;

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

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

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

Line 1073: FND_MSG_PUB.add;

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

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

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

Line 1084: FND_MSG_PUB.add;

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

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

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

Line 1095: FND_MSG_PUB.add;

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

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

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

Line 1106: FND_MSG_PUB.add;

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

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

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

Line 1117: FND_MSG_PUB.add;

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

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

1144: l_api_name CONSTANT VARCHAR2(30) := 'Create_Attr_Value';
1145: l_full_name CONSTANT VARCHAR2(60) := g_pkg_name ||'.'|| l_api_name;
1146:
1147: BEGIN
1148: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1149: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1150: END IF;
1151:
1152: x_return_status := FND_API.g_ret_sts_success;

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

1152: x_return_status := FND_API.g_ret_sts_success;
1153:
1154: -- Enter custom code here
1155:
1156: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1157: PVX_Utility_PVT.debug_message('Attribute Id:'|| p_enty_attr_val_rec.attribute_id||': - entity:' || p_enty_attr_val_rec.entity );
1158: END IF;
1159:
1160: for x in c_check_attr_exists(cv_attribute_id => p_enty_attr_val_rec.attribute_id )

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

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

Line 1169: FND_MSG_PUB.add;

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

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

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

Line 1187: FND_MSG_PUB.add;

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

Line 1429: FND_MSG_PUB.initialize;

1425:
1426: -- Initialize message list if p_init_msg_list is set to TRUE.
1427: IF FND_API.to_Boolean( p_init_msg_list )
1428: THEN
1429: FND_MSG_PUB.initialize;
1430: END IF;
1431: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1432:
1433: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_attr_value_Items' );

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

1471: END IF;
1472: END IF;
1473:
1474: -- Debug Message
1475: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1476: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1477: END IF;
1478: -- Initialize API return status to SUCCESS
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1478: -- Initialize API return status to SUCCESS
1479: x_return_status := FND_API.G_RET_STS_SUCCESS;
1480:
1481: -- Debug Message
1482: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1483: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1484: END IF;
1485: -- Standard call to get message count and if count is 1, get message info.
1486: FND_MSG_PUB.Count_And_Get (

Line 1486: FND_MSG_PUB.Count_And_Get (

1482: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1483: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1484: END IF;
1485: -- Standard call to get message count and if count is 1, get message info.
1486: FND_MSG_PUB.Count_And_Get (
1487: p_count => x_msg_count
1488: ,p_data => x_msg_data
1489: );
1490: EXCEPTION

Line 1500: FND_MSG_PUB.Count_And_Get (

1496: WHEN FND_API.G_EXC_ERROR THEN
1497: ROLLBACK TO Validate_attr_value;
1498: x_return_status := FND_API.G_RET_STS_ERROR;
1499: -- Standard call to get message count and if count=1, get the message
1500: FND_MSG_PUB.Count_And_Get (
1501: p_encoded => FND_API.G_FALSE
1502: ,p_count => x_msg_count
1503: ,p_data => x_msg_data
1504: );

Line 1510: FND_MSG_PUB.Count_And_Get (

1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: ROLLBACK TO Validate_attr_value;
1508: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1509: -- Standard call to get message count and if count=1, get the message
1510: FND_MSG_PUB.Count_And_Get (
1511: p_encoded => FND_API.G_FALSE
1512: ,p_count => x_msg_count
1513: ,p_data => x_msg_data
1514: );

Line 1519: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1515:
1516: WHEN OTHERS THEN
1517: ROLLBACK TO Validate_attr_value;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1522: END IF;
1523: -- Standard call to get message count and if count=1, get the message

Line 1521: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

1517: ROLLBACK TO Validate_attr_value;
1518: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1519: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1520: THEN
1521: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1522: END IF;
1523: -- Standard call to get message count and if count=1, get the message
1524: FND_MSG_PUB.Count_And_Get (
1525: p_encoded => FND_API.G_FALSE

Line 1524: FND_MSG_PUB.Count_And_Get (

1520: THEN
1521: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1522: END IF;
1523: -- Standard call to get message count and if count=1, get the message
1524: FND_MSG_PUB.Count_And_Get (
1525: p_encoded => FND_API.G_FALSE
1526: ,p_count => x_msg_count
1527: ,p_data => x_msg_data
1528: );

Line 1546: FND_MSG_PUB.initialize;

1542: BEGIN
1543: -- Initialize message list if p_init_msg_list is set to TRUE.
1544: IF FND_API.to_Boolean( p_init_msg_list )
1545: THEN
1546: FND_MSG_PUB.initialize;
1547: END IF;
1548:
1549: -- Initialize API return status to SUCCESS
1550: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1554: -- THEN
1555: -- x_return_status := FND_API.G_RET_STS_ERROR;
1556:
1557: -- Debug Message
1558: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1559: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1560: END IF;
1561: -- Standard call to get message count and if count is 1, get message info.
1562: FND_MSG_PUB.Count_And_Get (

Line 1562: FND_MSG_PUB.Count_And_Get (

1558: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1559: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1560: END IF;
1561: -- Standard call to get message count and if count is 1, get message info.
1562: FND_MSG_PUB.Count_And_Get (
1563: p_count => x_msg_count
1564: ,p_data => x_msg_data
1565: );
1566: END Validate_attr_val_rec;