APPS.PV_ATTRIBUTE_PVT dependencies on FND_MSG_PUB

Line 75: FND_MSG_PUB.initialize;

71:
72: -- Initialize message list if p_init_msg_list is set to TRUE.
73: IF FND_API.to_Boolean( p_init_msg_list )
74: THEN
75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: --DBMS_output.put_line('Private API: ' || L_FULL_NAME || ' start');

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

76: END IF;
77:
78: -- Debug Message
79: --DBMS_output.put_line('Private API: ' || L_FULL_NAME || ' start');
80: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
81: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');
82: end if;
83:
84:

Line 115: FND_MSG_PUB.add;

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

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

118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
123: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');
124: END IF;
125:
126: --DBMS_output.put_line('Before validate_attribute');

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

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

Line 177: FND_MSG_PUB.Add;

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

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

241: END IF;
242:
243:
244: -- Debug Message
245: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
246: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
247: END IF;
248:
249: -- Standard call to get message count and if count is 1, get message info.

Line 250: FND_MSG_PUB.Count_And_Get

246: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
247: END IF;
248:
249: -- Standard call to get message count and if count is 1, get message info.
250: FND_MSG_PUB.Count_And_Get
251: (p_count => x_msg_count,
252: p_data => x_msg_data
253: );
254: EXCEPTION

Line 266: FND_MSG_PUB.Count_And_Get (

262: WHEN FND_API.G_EXC_ERROR THEN
263: ROLLBACK TO CREATE_Attribute_PVT;
264: x_return_status := FND_API.G_RET_STS_ERROR;
265: -- Standard call to get message count and if count=1, get the message
266: FND_MSG_PUB.Count_And_Get (
267: p_encoded => FND_API.G_FALSE,
268: p_count => x_msg_count,
269: p_data => x_msg_data
270: );

Line 276: FND_MSG_PUB.Count_And_Get (

272: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
273: ROLLBACK TO CREATE_Attribute_PVT;
274: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
275: -- Standard call to get message count and if count=1, get the message
276: FND_MSG_PUB.Count_And_Get (
277: p_encoded => FND_API.G_FALSE,
278: p_count => x_msg_count,
279: p_data => x_msg_data
280: );

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

281:
282: WHEN OTHERS THEN
283: ROLLBACK TO CREATE_Attribute_PVT;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
288: END IF;
289: -- Standard call to get message count and if count=1, get the message

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

283: ROLLBACK TO CREATE_Attribute_PVT;
284: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
285: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
286: THEN
287: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
288: END IF;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,

Line 290: FND_MSG_PUB.Count_And_Get (

286: THEN
287: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
288: END IF;
289: -- Standard call to get message count and if count=1, get the message
290: FND_MSG_PUB.Count_And_Get (
291: p_encoded => FND_API.G_FALSE,
292: p_count => x_msg_count,
293: p_data => x_msg_data
294: );

Line 366: FND_MSG_PUB.initialize;

362:
363: -- Initialize message list if p_init_msg_list is set to TRUE.
364: IF FND_API.to_Boolean( p_init_msg_list )
365: THEN
366: FND_MSG_PUB.initialize;
367: END IF;
368:
369: -- Debug Message
370: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

366: FND_MSG_PUB.initialize;
367: END IF;
368:
369: -- Debug Message
370: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
371: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
372: END IF;
373:
374:

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

375: -- Initialize API return status to SUCCESS
376: x_return_status := FND_API.G_RET_STS_SUCCESS;
377:
378: -- Debug Message
379: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
380: PVX_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
381: END IF;
382:
383:

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

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

Line 395: FND_MSG_PUB.add;

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

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

397: RAISE FND_API.G_EXC_ERROR;
398: END IF;
399:
400: -- Debug Message
401: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
402: PVX_UTILITY_PVT.debug_message('Private API: - Close Cursor');
403: END IF;
404: CLOSE c_get_Attribute;
405:

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

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

Line 428: FND_MSG_PUB.Add;

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

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

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

Line 450: FND_MSG_PUB.Add;

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

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

466:
467:
468: if(l_delete_flag = 'N') then
469:
470: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
471: FND_MESSAGE.Set_Name('PV', 'PV_VALUE_TYPE_REFERENCED_RULE');
472: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',p_attribute_rec.name );
473: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
474: FND_MSG_PUB.Add;

Line 474: FND_MSG_PUB.Add;

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

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

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

Line 498: FND_MSG_PUB.Add;

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

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

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

Line 518: FND_MSG_PUB.Add;

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

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

534: -- l_ref_attribute_rec.display_style in ('SINGLE') and
535: -- p_attribute_rec.display_style in ('SINGLE')
536: -- )
537: -- THEN
538: -- IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
539:
540: -- FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
541: -- FND_MESSAGE.set_token('NAME',p_attribute_rec.name);
542:

Line 567: -- FND_MSG_PUB.add;

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

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

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

Line 600: FND_MSG_PUB.add;

596:
597: /*FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
598: FND_MESSAGE.set_token('TEXT', 'Can not :' || p_attribute_rec.attribute_type || ':' ||
599: l_ref_attribute_rec.display_style || ':' ||p_attribute_rec.display_style ||':');
600: FND_MSG_PUB.add;
601: */
602:
603: FND_MESSAGE.set_name('PV', 'PV_ATTR_NOT_CHANGE_STYLE');
604: FND_MESSAGE.set_token('NAME',p_attribute_rec.name);

Line 630: FND_MSG_PUB.add;

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

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

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

Line 654: FND_MSG_PUB.add;

650:
651: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
652: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
653: FND_MESSAGE.set_token('COLUMN', TO_CHAR(l_tar_attribute_rec.last_update_date));
654: FND_MSG_PUB.add;
655: END IF;
656: RAISE FND_API.G_EXC_ERROR;
657: End if;
658: -- Check Whether record has been changed by someone else

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

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

Line 663: FND_MSG_PUB.add;

659: If (l_tar_attribute_rec.object_version_number <> l_ref_attribute_rec.object_version_number) Then
660: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
661: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
662: FND_MESSAGE.set_token('VALUE','Attribute');
663: FND_MSG_PUB.add;
664: END IF;
665: RAISE FND_API.G_EXC_ERROR;
666: End if;
667: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

666: End if;
667: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
668: THEN
669: -- Debug message
670: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
671: PVX_UTILITY_PVT.debug_message('Private API: Validate_Attribute');
672: END IF;
673: --dbms_output.put_line('Before Validate_attribute');
674: -- Invoke validation procedures

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

690: RAISE FND_API.G_EXC_ERROR;
691: END IF;
692:
693: -- Debug Message
694: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
695: PVX_UTILITY_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
696: END IF;
697:
698: --DBMS_output.put_line('Before update_row');

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

745: END IF;
746:
747:
748: -- Debug Message
749: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
750: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
751: END IF;
752:
753: -- Standard call to get message count and if count is 1, get message info.

Line 754: FND_MSG_PUB.Count_And_Get

750: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
751: END IF;
752:
753: -- Standard call to get message count and if count is 1, get message info.
754: FND_MSG_PUB.Count_And_Get
755: (p_count => x_msg_count,
756: p_data => x_msg_data
757: );
758: EXCEPTION

Line 770: FND_MSG_PUB.Count_And_Get (

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

Line 780: FND_MSG_PUB.Count_And_Get (

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

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

785:
786: WHEN OTHERS THEN
787: ROLLBACK TO UPDATE_Attribute_PVT;
788: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
789: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
790: THEN
791: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
792: END IF;
793: -- Standard call to get message count and if count=1, get the message

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

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

Line 794: FND_MSG_PUB.Count_And_Get (

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

Line 902: FND_MSG_PUB.initialize;

898:
899: -- Initialize message list if p_init_msg_list is set to TRUE.
900: IF FND_API.to_Boolean( p_init_msg_list )
901: THEN
902: FND_MSG_PUB.initialize;
903: END IF;
904:
905: -- Debug Message
906: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

902: FND_MSG_PUB.initialize;
903: END IF;
904:
905: -- Debug Message
906: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
907: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || ' start');
908: END IF;
909:
910: -- Initialize API return status to SUCCESS

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

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

Line 936: FND_MSG_PUB.add;

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

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

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

Line 949: FND_MSG_PUB.Add;

945: THEN
946: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_SEEDED');
947: FND_MESSAGE.Set_Token('ATTRIBUTE_NAME',l_attribute_name );
948:
949: FND_MSG_PUB.Add;
950: END IF;
951:
952: RAISE FND_API.G_EXC_ERROR;
953:

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

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

Line 979: FND_MSG_PUB.add;

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

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

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

Line 989: FND_MSG_PUB.Add;

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

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

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

Line 1012: FND_MSG_PUB.Add;

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

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

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

Line 1035: FND_MSG_PUB.Add;

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

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

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

Line 1058: FND_MSG_PUB.Add;

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

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

1066:
1067:
1068:
1069: --start deleting
1070: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1071: PVX_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1072: END IF;
1073:
1074:

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

1075: --delete all rows from pv_attr_codes table
1076:
1077: for x in lc_attribute_codes (pc_attribute_id =>p_attribute_id)
1078: loop
1079: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1080: PVX_UTILITY_PVT.debug_message( 'Calling PV_ATTRIBUTE_CODE_PVT.Delete_Attribute_Code for : ' ||x.attr_code_id );
1081: END IF;
1082:
1083: PV_ATTRIBUTE_CODE_PVT.Delete_Attribute_Code(

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

1123:
1124: for x in lc_entity_attrs (pc_attribute_id =>p_attribute_id)
1125: loop
1126:
1127: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1128: PVX_UTILITY_PVT.debug_message( 'Calling PV_Entity_Attribute_Pvt.Delete_Entity_Attr for : ' ||x.entity_attr_id );
1129: END IF;
1130: PV_Entity_Attribute_Pvt.Delete_Entity_Attr(
1131: p_api_version_number => p_api_version_number

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

1158: END IF;
1159:
1160:
1161: -- Debug Message
1162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1163: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.

Line 1167: FND_MSG_PUB.Count_And_Get

1163: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1164: END IF;
1165:
1166: -- Standard call to get message count and if count is 1, get message info.
1167: FND_MSG_PUB.Count_And_Get
1168: (p_count => x_msg_count,
1169: p_data => x_msg_data
1170: );
1171: EXCEPTION

Line 1183: FND_MSG_PUB.Count_And_Get (

1179: WHEN FND_API.G_EXC_ERROR THEN
1180: ROLLBACK TO DELETE_Attribute_PVT;
1181: x_return_status := FND_API.G_RET_STS_ERROR;
1182: -- Standard call to get message count and if count=1, get the message
1183: FND_MSG_PUB.Count_And_Get (
1184: p_encoded => FND_API.G_FALSE,
1185: p_count => x_msg_count,
1186: p_data => x_msg_data
1187: );

Line 1193: FND_MSG_PUB.Count_And_Get (

1189: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1190: ROLLBACK TO DELETE_Attribute_PVT;
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: -- Standard call to get message count and if count=1, get the message
1193: FND_MSG_PUB.Count_And_Get (
1194: p_encoded => FND_API.G_FALSE,
1195: p_count => x_msg_count,
1196: p_data => x_msg_data
1197: );

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

1198:
1199: WHEN OTHERS THEN
1200: ROLLBACK TO DELETE_Attribute_PVT;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1205: END IF;
1206: -- Standard call to get message count and if count=1, get the message

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

1200: ROLLBACK TO DELETE_Attribute_PVT;
1201: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1202: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1205: END IF;
1206: -- Standard call to get message count and if count=1, get the message
1207: FND_MSG_PUB.Count_And_Get (
1208: p_encoded => FND_API.G_FALSE,

Line 1207: FND_MSG_PUB.Count_And_Get (

1203: THEN
1204: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1205: END IF;
1206: -- Standard call to get message count and if count=1, get the message
1207: FND_MSG_PUB.Count_And_Get (
1208: p_encoded => FND_API.G_FALSE,
1209: p_count => x_msg_count,
1210: p_data => x_msg_data
1211: );

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

1242:
1243: BEGIN
1244:
1245: -- Debug Message
1246: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1247: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
1248: END IF;
1249:
1250: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 1253: FND_MSG_PUB.initialize;

1249:
1250: -- Initialize message list if p_init_msg_list is set to TRUE.
1251: IF FND_API.to_Boolean( p_init_msg_list )
1252: THEN
1253: FND_MSG_PUB.initialize;
1254: END IF;
1255:
1256: -- Standard call to check for call compatibility.
1257: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

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

Line 1281: FND_MSG_PUB.add;

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

Line 1289: FND_MSG_PUB.count_and_get(

1285:
1286: CLOSE c_Attribute;
1287:
1288: -------------------- finish --------------------------
1289: FND_MSG_PUB.count_and_get(
1290: p_encoded => FND_API.g_false,
1291: p_count => x_msg_count,
1292: p_data => x_msg_data);
1293: PVX_UTILITY_PVT.debug_message(l_full_name ||': end');

Line 1304: FND_MSG_PUB.Count_And_Get (

1300: WHEN FND_API.G_EXC_ERROR THEN
1301: ROLLBACK TO LOCK_Attribute_PVT;
1302: x_return_status := FND_API.G_RET_STS_ERROR;
1303: -- Standard call to get message count and if count=1, get the message
1304: FND_MSG_PUB.Count_And_Get (
1305: p_encoded => FND_API.G_FALSE,
1306: p_count => x_msg_count,
1307: p_data => x_msg_data
1308: );

Line 1314: FND_MSG_PUB.Count_And_Get (

1310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1311: ROLLBACK TO LOCK_Attribute_PVT;
1312: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1313: -- Standard call to get message count and if count=1, get the message
1314: FND_MSG_PUB.Count_And_Get (
1315: p_encoded => FND_API.G_FALSE,
1316: p_count => x_msg_count,
1317: p_data => x_msg_data
1318: );

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

1319:
1320: WHEN OTHERS THEN
1321: ROLLBACK TO LOCK_Attribute_PVT;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1324: THEN
1325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1326: END IF;
1327: -- Standard call to get message count and if count=1, get the message

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

1321: ROLLBACK TO LOCK_Attribute_PVT;
1322: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1323: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1324: THEN
1325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1326: END IF;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,

Line 1328: FND_MSG_PUB.Count_And_Get (

1324: THEN
1325: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1326: END IF;
1327: -- Standard call to get message count and if count=1, get the message
1328: FND_MSG_PUB.Count_And_Get (
1329: p_encoded => FND_API.G_FALSE,
1330: p_count => x_msg_count,
1331: p_data => x_msg_data
1332: );

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

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

Line 1369: FND_MSG_PUB.add;

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

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

1381: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1382: for x in lc_get_attr_name
1383: loop
1384: if (UPPER(p_attribute_rec.name)=UPPER(x.name)) then
1385: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1386:
1387: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1388: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1389: --FND_MESSAGE.set_token('ID',to_char(p_attribute_rec.ATTRIBUTE_ID) || ':::' || p_attribute_rec.name);

Line 1391: FND_MSG_PUB.add;

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

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

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

Line 1411: FND_MSG_PUB.add;

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

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

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

Line 1436: FND_MSG_PUB.add;

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

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

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

Line 1447: FND_MSG_PUB.add;

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

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

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

Line 1458: FND_MSG_PUB.add;

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

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

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

Line 1469: FND_MSG_PUB.add;

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

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

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

Line 1480: FND_MSG_PUB.add;

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

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

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

Line 1491: FND_MSG_PUB.add;

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

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

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

Line 1502: FND_MSG_PUB.add;

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

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

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

Line 1513: FND_MSG_PUB.add;

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

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

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

Line 1523: FND_MSG_PUB.add;

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

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

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

Line 1536: FND_MSG_PUB.add;

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

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

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

Line 1547: FND_MSG_PUB.add;

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

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

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

Line 1558: FND_MSG_PUB.add;

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

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

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

Line 1569: FND_MSG_PUB.add;

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

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

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

Line 1580: FND_MSG_PUB.add;

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

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

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

Line 1591: FND_MSG_PUB.add;

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

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

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

Line 1602: FND_MSG_PUB.add;

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

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

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

Line 1613: FND_MSG_PUB.add;

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

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

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

Line 1625: FND_MSG_PUB.add;

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

Line 1924: FND_MSG_PUB.initialize;

1920:
1921: -- Initialize message list if p_init_msg_list is set to TRUE.
1922: IF FND_API.to_Boolean( p_init_msg_list )
1923: THEN
1924: FND_MSG_PUB.initialize;
1925: END IF;
1926: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1927:
1928: --DBMS_output.put_line('Before Check_attribute_Items');

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

1968: END IF;
1969: END IF;
1970:
1971: -- Debug Message
1972: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1973: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'start');
1974: END IF;
1975:
1976:

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

1977: -- Initialize API return status to SUCCESS
1978: x_return_status := FND_API.G_RET_STS_SUCCESS;
1979:
1980: -- Debug Message
1981: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1982: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1983: END IF;
1984:
1985: -- Standard call to get message count and if count is 1, get message info.

Line 1986: FND_MSG_PUB.Count_And_Get

1982: PVX_UTILITY_PVT.debug_message('Private API: ' || L_FULL_NAME || 'end');
1983: END IF;
1984:
1985: -- Standard call to get message count and if count is 1, get message info.
1986: FND_MSG_PUB.Count_And_Get
1987: (p_count => x_msg_count,
1988: p_data => x_msg_data
1989: );
1990: EXCEPTION

Line 2001: FND_MSG_PUB.Count_And_Get (

1997: WHEN FND_API.G_EXC_ERROR THEN
1998: ROLLBACK TO VALIDATE_Attribute_PVT;
1999: x_return_status := FND_API.G_RET_STS_ERROR;
2000: -- Standard call to get message count and if count=1, get the message
2001: FND_MSG_PUB.Count_And_Get (
2002: p_encoded => FND_API.G_FALSE,
2003: p_count => x_msg_count,
2004: p_data => x_msg_data
2005: );

Line 2011: FND_MSG_PUB.Count_And_Get (

2007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2008: ROLLBACK TO VALIDATE_Attribute_PVT;
2009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2010: -- Standard call to get message count and if count=1, get the message
2011: FND_MSG_PUB.Count_And_Get (
2012: p_encoded => FND_API.G_FALSE,
2013: p_count => x_msg_count,
2014: p_data => x_msg_data
2015: );

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

2016:
2017: WHEN OTHERS THEN
2018: ROLLBACK TO VALIDATE_Attribute_PVT;
2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2021: THEN
2022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2023: END IF;
2024: -- Standard call to get message count and if count=1, get the message

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

2018: ROLLBACK TO VALIDATE_Attribute_PVT;
2019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2021: THEN
2022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2023: END IF;
2024: -- Standard call to get message count and if count=1, get the message
2025: FND_MSG_PUB.Count_And_Get (
2026: p_encoded => FND_API.G_FALSE,

Line 2025: FND_MSG_PUB.Count_And_Get (

2021: THEN
2022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2023: END IF;
2024: -- Standard call to get message count and if count=1, get the message
2025: FND_MSG_PUB.Count_And_Get (
2026: p_encoded => FND_API.G_FALSE,
2027: p_count => x_msg_count,
2028: p_data => x_msg_data
2029: );

Line 2051: FND_MSG_PUB.initialize;

2047:
2048: -- Initialize message list if p_init_msg_list is set to TRUE.
2049: IF FND_API.to_Boolean( p_init_msg_list )
2050: THEN
2051: FND_MSG_PUB.initialize;
2052: END IF;
2053:
2054: -- Initialize API return status to SUCCESS
2055: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

2059: -- THEN
2060: -- x_return_status := FND_API.G_RET_STS_ERROR;
2061:
2062: -- Debug Message
2063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2064: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2065: END IF;
2066: -- Standard call to get message count and if count is 1, get message info.
2067: FND_MSG_PUB.Count_And_Get

Line 2067: FND_MSG_PUB.Count_And_Get

2063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
2064: PVX_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2065: END IF;
2066: -- Standard call to get message count and if count is 1, get message info.
2067: FND_MSG_PUB.Count_And_Get
2068: (p_count => x_msg_count,
2069: p_data => x_msg_data
2070: );
2071: