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

APPS.PV_ATTRIBUTE_CODE_PVT dependencies on FND_MSG_PUB

Line 74: FND_MSG_PUB.initialize;

70:
71: -- Initialize message list if p_init_msg_list is set to TRUE.
72: IF FND_API.to_Boolean( p_init_msg_list )
73: THEN
74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Debug Message
78: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

74: FND_MSG_PUB.initialize;
75: END IF;
76:
77: -- Debug Message
78: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
79: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
80: end if;
81:
82:

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

107: -- =========================================================================
108:
109: IF FND_GLOBAL.User_Id IS NULL
110: THEN
111: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
112: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
113: FND_MSG_PUB.add;
114: end if;
115: RAISE FND_API.G_EXC_ERROR;

Line 113: FND_MSG_PUB.add;

109: IF FND_GLOBAL.User_Id IS NULL
110: THEN
111: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
112: FND_MESSAGE.set_name('PV', 'PV_API_USER_PROFILE_MISSING');
113: FND_MSG_PUB.add;
114: end if;
115: RAISE FND_API.G_EXC_ERROR;
116: END IF;
117:

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

117:
118: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
119: THEN
120: -- Debug message
121: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
122: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');
123: end if;
124:
125: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_attribute_Code' );

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

153: END IF;
154:
155: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
156: -- Debug Message
157: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
158: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
159: end if;
160:
161: -- Invoke table handler(PV_ATTRIBUTE_CODE_PKG.Insert_Row)

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

192: END IF;
193:
194:
195: -- Debug Message
196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
197: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
198: end if;
199:
200: -- Standard call to get message count and if count is 1, get message info.

Line 201: FND_MSG_PUB.Count_And_Get

197: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
198: end if;
199:
200: -- Standard call to get message count and if count is 1, get message info.
201: FND_MSG_PUB.Count_And_Get
202: (p_count => x_msg_count,
203: p_data => x_msg_data
204: );
205: EXCEPTION

Line 215: FND_MSG_PUB.Count_And_Get (

211: WHEN FND_API.G_EXC_ERROR THEN
212: ROLLBACK TO CREATE_Attribute_Code_PVT;
213: x_return_status := FND_API.G_RET_STS_ERROR;
214: -- Standard call to get message count and if count=1, get the message
215: FND_MSG_PUB.Count_And_Get (
216: p_encoded => FND_API.G_FALSE,
217: p_count => x_msg_count,
218: p_data => x_msg_data
219: );

Line 225: FND_MSG_PUB.Count_And_Get (

221: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
222: ROLLBACK TO CREATE_Attribute_Code_PVT;
223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );

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

230:
231: WHEN OTHERS THEN
232: ROLLBACK TO CREATE_Attribute_Code_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message

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

232: ROLLBACK TO CREATE_Attribute_Code_PVT;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,

Line 239: FND_MSG_PUB.Count_And_Get (

235: THEN
236: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
237: END IF;
238: -- Standard call to get message count and if count=1, get the message
239: FND_MSG_PUB.Count_And_Get (
240: p_encoded => FND_API.G_FALSE,
241: p_count => x_msg_count,
242: p_data => x_msg_data
243: );

Line 332: FND_MSG_PUB.initialize;

328:
329: -- Initialize message list if p_init_msg_list is set to TRUE.
330: IF FND_API.to_Boolean( p_init_msg_list )
331: THEN
332: FND_MSG_PUB.initialize;
333: END IF;
334:
335: -- Debug Message
336: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

332: FND_MSG_PUB.initialize;
333: END IF;
334:
335: -- Debug Message
336: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
337: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
338: end if;
339:
340:

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

341: -- Initialize API return status to SUCCESS
342: x_return_status := FND_API.G_RET_STS_SUCCESS;
343:
344: -- Debug Message
345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
346: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
347: end if;
348:
349:

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

351:
352: FETCH c_get_attribute_code INTO l_ref_attribute_code_rec ;
353:
354: IF ( c_get_attribute_code%NOTFOUND) THEN
355: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));

Line 360: FND_MSG_PUB.add;

356: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
357: FND_MESSAGE.set_token('MODE','Update');
358: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
359: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_code_rec.attr_code_id));
360: FND_MSG_PUB.add;
361: end if;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message

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

361: end if;
362: RAISE FND_API.G_EXC_ERROR;
363: END IF;
364: -- Debug Message
365: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
366: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
367: end if;
368: CLOSE c_get_attribute_code;
369:

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

370: if(l_ref_attribute_code_rec.enabled_flag = 'Y' and p_attribute_code_rec.enabled_flag= 'N') then
371:
372: --check for seeded attribute code
373: /* if(p_attribute_code_rec.attr_code_id <10000) then
374: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
375: THEN
376: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_SEEDED');
377: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
378: FND_MSG_PUB.Add;

Line 378: FND_MSG_PUB.Add;

374: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
375: THEN
376: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_SEEDED');
377: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
378: FND_MSG_PUB.Add;
379: END IF;
380: RAISE FND_API.G_EXC_ERROR;
381: end if;
382: */

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

390:
391:
392: if(l_delete_flag = 'N') then
393:
394: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
395: THEN
396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');
397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );

Line 399: FND_MSG_PUB.Add;

395: THEN
396: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_RULE');
397: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
398: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
399: FND_MSG_PUB.Add;
400: END IF;
401:
402: RAISE FND_API.G_EXC_ERROR;
403:

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

417:
418:
419: if(l_delete_flag = 'N') then
420:
421: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
422: THEN
423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');
424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );

Line 426: FND_MSG_PUB.Add;

422: THEN
423: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_PROGR');
424: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
425: FND_MESSAGE.Set_Token('PROGRAMS_LIST',substr(l_being_used_list,2) );
426: FND_MSG_PUB.Add;
427: END IF;
428:
429: RAISE FND_API.G_EXC_ERROR;
430:

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

439: loop
440: l_delete_flag := 'N';
441: l_being_used_list := l_being_used_list || ','|| x.entity ;
442: end loop;
443: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
444: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
445: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
446: FND_MSG_PUB.add;
447: END IF;

Line 446: FND_MSG_PUB.add;

442: end loop;
443: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
444: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
445: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
446: FND_MSG_PUB.add;
447: END IF;
448:
449:
450: if(l_delete_flag = 'N') then

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

448:
449:
450: if(l_delete_flag = 'N') then
451:
452: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
453: THEN
454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');
455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );

Line 457: FND_MSG_PUB.Add;

453: THEN
454: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDISABLED_ENTITY');
455: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',p_attribute_code_rec.attr_code );
456: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
457: FND_MSG_PUB.Add;
458: END IF;
459:
460: RAISE FND_API.G_EXC_ERROR;
461:

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

466: end if;
467: IF (l_tar_attribute_code_rec.object_version_number is NULL or
468: l_tar_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM ) 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_API_VERSION_MISSING');
472: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_code_rec.last_update_date));
473: FND_MSG_PUB.add;
474: end if;

Line 473: FND_MSG_PUB.add;

469:
470: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
471: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
472: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_code_rec.last_update_date));
473: FND_MSG_PUB.add;
474: end if;
475: RAISE FND_API.G_EXC_ERROR;
476: End if;
477:

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

476: End if;
477:
478: -- Check Whether record has been changed by someone else
479: If (l_tar_attribute_code_rec.object_version_number <> l_ref_attribute_code_rec.object_version_number) Then
480: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
481: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
482: FND_MESSAGE.set_token('VALUE','Attribute_Code');
483: FND_MSG_PUB.add;
484: end if;

Line 483: FND_MSG_PUB.add;

479: If (l_tar_attribute_code_rec.object_version_number <> l_ref_attribute_code_rec.object_version_number) Then
480: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
481: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
482: FND_MESSAGE.set_token('VALUE','Attribute_Code');
483: FND_MSG_PUB.add;
484: end if;
485: RAISE FND_API.G_EXC_ERROR;
486: End if;
487: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

486: End if;
487: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
488: THEN
489: -- Debug message
490: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
491: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Code');
492: end if;
493:
494: -- Invoke validation procedures

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

510: END IF;
511:
512:
513: -- Debug Message
514: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
515: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
516: end if;
517:
518: -- Invoke table handler(PV_ATTRIBUTE_CODE_PKG.Update_Row)

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

544: END IF;
545:
546:
547: -- Debug Message
548: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
549: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
550: end if;
551:
552: -- Standard call to get message count and if count is 1, get message info.

Line 553: FND_MSG_PUB.Count_And_Get

549: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
550: end if;
551:
552: -- Standard call to get message count and if count is 1, get message info.
553: FND_MSG_PUB.Count_And_Get
554: (p_count => x_msg_count,
555: p_data => x_msg_data
556: );
557: EXCEPTION

Line 567: FND_MSG_PUB.Count_And_Get (

563: WHEN FND_API.G_EXC_ERROR THEN
564: ROLLBACK TO UPDATE_Attribute_Code_PVT;
565: x_return_status := FND_API.G_RET_STS_ERROR;
566: -- Standard call to get message count and if count=1, get the message
567: FND_MSG_PUB.Count_And_Get (
568: p_encoded => FND_API.G_FALSE,
569: p_count => x_msg_count,
570: p_data => x_msg_data
571: );

Line 577: FND_MSG_PUB.Count_And_Get (

573: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
574: ROLLBACK TO UPDATE_Attribute_Code_PVT;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: -- Standard call to get message count and if count=1, get the message
577: FND_MSG_PUB.Count_And_Get (
578: p_encoded => FND_API.G_FALSE,
579: p_count => x_msg_count,
580: p_data => x_msg_data
581: );

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

582:
583: WHEN OTHERS THEN
584: ROLLBACK TO UPDATE_Attribute_Code_PVT;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message

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

584: ROLLBACK TO UPDATE_Attribute_Code_PVT;
585: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
586: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
591: FND_MSG_PUB.Count_And_Get (
592: p_encoded => FND_API.G_FALSE,

Line 591: FND_MSG_PUB.Count_And_Get (

587: THEN
588: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
589: END IF;
590: -- Standard call to get message count and if count=1, get the message
591: FND_MSG_PUB.Count_And_Get (
592: p_encoded => FND_API.G_FALSE,
593: p_count => x_msg_count,
594: p_data => x_msg_data
595: );

Line 674: FND_MSG_PUB.initialize;

670:
671: -- Initialize message list if p_init_msg_list is set to TRUE.
672: IF FND_API.to_Boolean( p_init_msg_list )
673: THEN
674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: -- Debug Message
678: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

674: FND_MSG_PUB.initialize;
675: END IF;
676:
677: -- Debug Message
678: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
679: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
680: end if;
681:
682:

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

692: for x in lc_get_attr_code_details (pc_attr_code_id =>p_attr_code_id)
693: loop
694: l_attr_code := x.attr_code;
695:
696: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
697: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
698: FND_MESSAGE.set_token('TEXT', 'Attr Code:-- '|| l_attr_code);
699: FND_MSG_PUB.add;
700: END IF;

Line 699: FND_MSG_PUB.add;

695:
696: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
697: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
698: FND_MESSAGE.set_token('TEXT', 'Attr Code:-- '|| l_attr_code);
699: FND_MSG_PUB.add;
700: END IF;
701: end loop;
702:
703:

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

707: l_attribute_id := x.attribute_id;
708:
709: l_attribute_name := x.name;
710:
711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
712: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
713: FND_MESSAGE.set_token('TEXT', 'Attr:-- '|| l_attribute_id );
714: FND_MSG_PUB.add;
715: END IF;

Line 714: FND_MSG_PUB.add;

710:
711: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
712: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
713: FND_MESSAGE.set_token('TEXT', 'Attr:-- '|| l_attribute_id );
714: FND_MSG_PUB.add;
715: END IF;
716: end loop;
717:
718: --check for seeded attribute code

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

716: end loop;
717:
718: --check for seeded attribute code
719: if(p_attr_code_id <10000) then
720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');
723: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
724: FND_MSG_PUB.Add;

Line 724: FND_MSG_PUB.Add;

720: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
721: THEN
722: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_NOTDELETE_SEEDED');
723: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
724: FND_MSG_PUB.Add;
725: END IF;
726: RAISE FND_API.G_EXC_ERROR;
727: end if;
728:

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

736: end if;
737:
738: if(l_delete_flag = 'N') then
739:
740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
741: THEN
742: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_VADOF_RESELLERS');
743: FND_MESSAGE.Set_Token('NAME',l_attribute_name );
744: FND_MSG_PUB.Add;

Line 744: FND_MSG_PUB.Add;

740: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
741: THEN
742: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_VADOF_RESELLERS');
743: FND_MESSAGE.Set_Token('NAME',l_attribute_name );
744: FND_MSG_PUB.Add;
745: END IF;
746:
747: RAISE FND_API.G_EXC_ERROR;
748:

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

756:
757:
758: if(l_delete_flag = 'N') then
759:
760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_USAGE');
763: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
764: FND_MSG_PUB.Add;

Line 764: FND_MSG_PUB.Add;

760: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
761: THEN
762: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_USAGE');
763: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
764: FND_MSG_PUB.Add;
765: END IF;
766:
767: RAISE FND_API.G_EXC_ERROR;
768:

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

786: l_being_used_list := l_being_used_list || ','|| l_meaning ;
787: l_meaning:='';
788: end loop;
789:
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
792: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
793: FND_MSG_PUB.add;
794: END IF;

Line 793: FND_MSG_PUB.add;

789:
790: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
791: FND_MESSAGE.set_name('PV', 'PV_DEBUG_MESSAGE');
792: FND_MESSAGE.set_token('TEXT', 'Entity List '|| l_being_used_list );
793: FND_MSG_PUB.add;
794: END IF;
795:
796:
797: if(l_delete_flag = 'N') then

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

795:
796:
797: if(l_delete_flag = 'N') then
798:
799: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
800: THEN
801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');
802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );

Line 804: FND_MSG_PUB.Add;

800: THEN
801: FND_MESSAGE.Set_Name('PV', 'PV_ATTRCODE_REFERENCED_ENTITY');
802: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
803: FND_MESSAGE.Set_Token('ENTITY_LIST',substr(l_being_used_list,2) );
804: FND_MSG_PUB.Add;
805: END IF;
806:
807: RAISE FND_API.G_EXC_ERROR;
808:

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

817:
818:
819: if(l_delete_flag = 'N') then
820:
821: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)
822: THEN
823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );

Line 826: FND_MSG_PUB.Add;

822: THEN
823: FND_MESSAGE.Set_Name('PV', 'PV_ATTR_REFERENCED_RULE');
824: FND_MESSAGE.Set_Token('ATTRIBUTE_CODE',l_attr_code );
825: FND_MESSAGE.Set_Token('RULES_LIST',substr(l_being_used_list,2) );
826: FND_MSG_PUB.Add;
827: END IF;
828:
829: RAISE FND_API.G_EXC_ERROR;
830:

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

830:
831: end if;
832:
833: -- Debug Message
834: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
835: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
836: END IF;
837:
838:

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

854: END IF;
855:
856:
857: -- Debug Message
858: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
859: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.

Line 863: FND_MSG_PUB.Count_And_Get

859: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
860: END IF;
861:
862: -- Standard call to get message count and if count is 1, get message info.
863: FND_MSG_PUB.Count_And_Get
864: (p_count => x_msg_count,
865: p_data => x_msg_data
866: );
867: EXCEPTION

Line 877: FND_MSG_PUB.Count_And_Get (

873: WHEN FND_API.G_EXC_ERROR THEN
874: ROLLBACK TO DELETE_Attribute_Code_PVT;
875: x_return_status := FND_API.G_RET_STS_ERROR;
876: -- Standard call to get message count and if count=1, get the message
877: FND_MSG_PUB.Count_And_Get (
878: p_encoded => FND_API.G_FALSE,
879: p_count => x_msg_count,
880: p_data => x_msg_data
881: );

Line 887: FND_MSG_PUB.Count_And_Get (

883: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
884: ROLLBACK TO DELETE_Attribute_Code_PVT;
885: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
886: -- Standard call to get message count and if count=1, get the message
887: FND_MSG_PUB.Count_And_Get (
888: p_encoded => FND_API.G_FALSE,
889: p_count => x_msg_count,
890: p_data => x_msg_data
891: );

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

892:
893: WHEN OTHERS THEN
894: ROLLBACK TO DELETE_Attribute_Code_PVT;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
899: END IF;
900: -- Standard call to get message count and if count=1, get the message

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

894: ROLLBACK TO DELETE_Attribute_Code_PVT;
895: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
896: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
899: END IF;
900: -- Standard call to get message count and if count=1, get the message
901: FND_MSG_PUB.Count_And_Get (
902: p_encoded => FND_API.G_FALSE,

Line 901: FND_MSG_PUB.Count_And_Get (

897: THEN
898: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
899: END IF;
900: -- Standard call to get message count and if count=1, get the message
901: FND_MSG_PUB.Count_And_Get (
902: p_encoded => FND_API.G_FALSE,
903: p_count => x_msg_count,
904: p_data => x_msg_data
905: );

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

937: -- Standard Start of API savepoint
938: SAVEPOINT LOCK_Attribute_Code_PVT;
939:
940: -- Debug Message
941: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
942: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
943: END IF;
944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 948: FND_MSG_PUB.initialize;

944:
945: -- Initialize message list if p_init_msg_list is set to TRUE.
946: IF FND_API.to_Boolean( p_init_msg_list )
947: THEN
948: FND_MSG_PUB.initialize;
949: END IF;
950:
951: -- Standard call to check for call compatibility.
952: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

970: FETCH c_Attribute_Code INTO l_ATTR_CODE_ID;
971:
972: IF (c_Attribute_Code%NOTFOUND) THEN
973: CLOSE c_Attribute_Code;
974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
976: FND_MSG_PUB.add;
977: END IF;
978: RAISE FND_API.g_exc_error;

Line 976: FND_MSG_PUB.add;

972: IF (c_Attribute_Code%NOTFOUND) THEN
973: CLOSE c_Attribute_Code;
974: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
975: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
976: FND_MSG_PUB.add;
977: END IF;
978: RAISE FND_API.g_exc_error;
979: END IF;
980:

Line 984: FND_MSG_PUB.count_and_get(

980:
981: CLOSE c_Attribute_Code;
982:
983: -------------------- finish --------------------------
984: FND_MSG_PUB.count_and_get(
985: p_encoded => FND_API.g_false,
986: p_count => x_msg_count,
987: p_data => x_msg_data);
988: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN

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

984: FND_MSG_PUB.count_and_get(
985: p_encoded => FND_API.g_false,
986: p_count => x_msg_count,
987: p_data => x_msg_data);
988: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
989: PVX_Utility_PVT.debug_message(l_full_name ||': end');
990: END IF;
991: EXCEPTION
992: /*

Line 1001: FND_MSG_PUB.Count_And_Get (

997: WHEN FND_API.G_EXC_ERROR THEN
998: ROLLBACK TO LOCK_Attribute_Code_PVT;
999: x_return_status := FND_API.G_RET_STS_ERROR;
1000: -- Standard call to get message count and if count=1, get the message
1001: FND_MSG_PUB.Count_And_Get (
1002: p_encoded => FND_API.G_FALSE,
1003: p_count => x_msg_count,
1004: p_data => x_msg_data
1005: );

Line 1011: FND_MSG_PUB.Count_And_Get (

1007: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1008: ROLLBACK TO LOCK_Attribute_Code_PVT;
1009: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1010: -- Standard call to get message count and if count=1, get the message
1011: FND_MSG_PUB.Count_And_Get (
1012: p_encoded => FND_API.G_FALSE,
1013: p_count => x_msg_count,
1014: p_data => x_msg_data
1015: );

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

1016:
1017: WHEN OTHERS THEN
1018: ROLLBACK TO LOCK_Attribute_Code_PVT;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message

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

1018: ROLLBACK TO LOCK_Attribute_Code_PVT;
1019: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1020: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,

Line 1025: FND_MSG_PUB.Count_And_Get (

1021: THEN
1022: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1023: END IF;
1024: -- Standard call to get message count and if count=1, get the message
1025: FND_MSG_PUB.Count_And_Get (
1026: p_encoded => FND_API.G_FALSE,
1027: p_count => x_msg_count,
1028: p_data => x_msg_data
1029: );

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

1059: END IF;
1060:
1061:
1062: IF l_valid_flag = FND_API.g_false THEN
1063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1064: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );
1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1067: FND_MSG_PUB.add;

Line 1067: FND_MSG_PUB.add;

1063: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1064: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1065: FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) );
1066: FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1067: FND_MSG_PUB.add;
1068: END IF;
1069: x_return_status := FND_API.g_ret_sts_error;
1070: RETURN;
1071: END IF;

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

1074: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1075: for x in lc_get_attr_code (pc_attribute_id =>p_attribute_code_rec.attribute_id)
1076: loop
1077: if (UPPER(p_attribute_code_rec.attr_code)=UPPER(x.attr_code)) then
1078: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1079:
1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);

Line 1084: FND_MSG_PUB.add;

1080: FND_MESSAGE.set_name('PV', 'PV_DUPLICATE_RECORD');
1081: --FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
1082: --FND_MESSAGE.set_token('ID',to_char(p_attribute_code_rec.ATTR_CODE_ID) || ':::' || p_attribute_code_rec.ATTR_CODE);
1083: --FND_MESSAGE.set_token('ENTITY','Attribute_Code');
1084: FND_MSG_PUB.add;
1085: END IF;
1086: --x_return_status := FND_API.g_ret_sts_error;
1087: RAISE FND_API.G_EXC_ERROR;
1088: end if;

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

1104: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
1105:
1106: IF p_attribute_code_rec.attr_code_id = FND_API.G_MISS_NUM
1107: OR p_attribute_code_rec.attr_code_id IS NULL THEN
1108: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1109: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1110: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1111: FND_MSG_PUB.add;
1112: END IF;

Line 1111: FND_MSG_PUB.add;

1107: OR p_attribute_code_rec.attr_code_id IS NULL THEN
1108: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1109: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1110: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1111: FND_MSG_PUB.add;
1112: END IF;
1113: x_return_status := FND_API.g_ret_sts_error;
1114: RETURN;
1115: END IF;

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

1115: END IF;
1116:
1117: IF p_attribute_code_rec.attr_code = FND_API.G_MISS_CHAR
1118: OR p_attribute_code_rec.attr_code IS NULL THEN
1119: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1120: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1121: FND_MESSAGE.set_token('COLUMN','attr_code');
1122: FND_MSG_PUB.add;
1123: END IF;

Line 1122: FND_MSG_PUB.add;

1118: OR p_attribute_code_rec.attr_code IS NULL THEN
1119: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1120: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1121: FND_MESSAGE.set_token('COLUMN','attr_code');
1122: FND_MSG_PUB.add;
1123: END IF;
1124: x_return_status := FND_API.g_ret_sts_error;
1125: RETURN;
1126: END IF;

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

1126: END IF;
1127:
1128: IF p_attribute_code_rec.last_update_date = FND_API.G_MISS_DATE
1129: OR p_attribute_code_rec.last_update_date IS NULL THEN
1130: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1131: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','last_update_date');
1133: FND_MSG_PUB.add;
1134: END IF;

Line 1133: FND_MSG_PUB.add;

1129: OR p_attribute_code_rec.last_update_date IS NULL THEN
1130: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1131: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1132: FND_MESSAGE.set_token('COLUMN','last_update_date');
1133: FND_MSG_PUB.add;
1134: END IF;
1135: x_return_status := FND_API.g_ret_sts_error;
1136: RETURN;
1137: END IF;

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

1137: END IF;
1138:
1139: IF p_attribute_code_rec.last_updated_by = FND_API.G_MISS_NUM
1140: OR p_attribute_code_rec.last_updated_by IS NULL THEN
1141: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1142: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1143: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1144: FND_MSG_PUB.add;
1145: END IF;

Line 1144: FND_MSG_PUB.add;

1140: OR p_attribute_code_rec.last_updated_by IS NULL THEN
1141: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1142: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1143: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1144: FND_MSG_PUB.add;
1145: END IF;
1146: x_return_status := FND_API.g_ret_sts_error;
1147: RETURN;
1148: END IF;

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

1148: END IF;
1149:
1150: IF p_attribute_code_rec.creation_date = FND_API.G_MISS_DATE
1151: OR p_attribute_code_rec.creation_date IS NULL THEN
1152: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1153: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1154: FND_MESSAGE.set_token('COLUMN','creation_date');
1155: FND_MSG_PUB.add;
1156: END IF;

Line 1155: FND_MSG_PUB.add;

1151: OR p_attribute_code_rec.creation_date IS NULL THEN
1152: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1153: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1154: FND_MESSAGE.set_token('COLUMN','creation_date');
1155: FND_MSG_PUB.add;
1156: END IF;
1157: x_return_status := FND_API.g_ret_sts_error;
1158: RETURN;
1159: END IF;

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

1159: END IF;
1160:
1161: IF p_attribute_code_rec.created_by = FND_API.G_MISS_NUM
1162: OR p_attribute_code_rec.created_by IS NULL THEN
1163: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1164: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1165: FND_MESSAGE.set_token('COLUMN','created_by');
1166: FND_MSG_PUB.add;
1167: END IF;

Line 1166: FND_MSG_PUB.add;

1162: OR p_attribute_code_rec.created_by IS NULL THEN
1163: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1164: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1165: FND_MESSAGE.set_token('COLUMN','created_by');
1166: FND_MSG_PUB.add;
1167: END IF;
1168: x_return_status := FND_API.g_ret_sts_error;
1169: RETURN;
1170: END IF;

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

1170: END IF;
1171:
1172: IF p_attribute_code_rec.last_update_login = FND_API.G_MISS_NUM
1173: OR p_attribute_code_rec.last_update_login IS NULL THEN
1174: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1175: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1176: FND_MESSAGE.set_token('COLUMN','last_update_login');
1177: FND_MSG_PUB.add;
1178: END IF;

Line 1177: FND_MSG_PUB.add;

1173: OR p_attribute_code_rec.last_update_login IS NULL THEN
1174: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1175: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1176: FND_MESSAGE.set_token('COLUMN','last_update_login');
1177: FND_MSG_PUB.add;
1178: END IF;
1179: x_return_status := FND_API.g_ret_sts_error;
1180: RETURN;
1181: END IF;

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

1181: END IF;
1182:
1183: IF p_attribute_code_rec.object_version_number = FND_API.G_MISS_NUM
1184: OR p_attribute_code_rec.object_version_number IS NULL THEN
1185: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1186: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','object_version_number');
1188: FND_MSG_PUB.add;
1189: END IF;

Line 1188: FND_MSG_PUB.add;

1184: OR p_attribute_code_rec.object_version_number IS NULL THEN
1185: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1186: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1187: FND_MESSAGE.set_token('COLUMN','object_version_number');
1188: FND_MSG_PUB.add;
1189: END IF;
1190: x_return_status := FND_API.g_ret_sts_error;
1191: RETURN;
1192: END IF;

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

1192: END IF;
1193:
1194: IF p_attribute_code_rec.attribute_id = FND_API.G_MISS_NUM
1195: OR p_attribute_code_rec.attribute_id IS NULL THEN
1196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1197: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1198: FND_MESSAGE.set_token('COLUMN','attribute_id');
1199: FND_MSG_PUB.add;
1200: END IF;

Line 1199: FND_MSG_PUB.add;

1195: OR p_attribute_code_rec.attribute_id IS NULL THEN
1196: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1197: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1198: FND_MESSAGE.set_token('COLUMN','attribute_id');
1199: FND_MSG_PUB.add;
1200: END IF;
1201: x_return_status := FND_API.g_ret_sts_error;
1202: RETURN;
1203: END IF;

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

1203: END IF;
1204:
1205: IF p_attribute_code_rec.enabled_flag = FND_API.G_MISS_CHAR
1206: OR p_attribute_code_rec.enabled_flag IS NULL THEN
1207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1208: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1209: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1210: FND_MSG_PUB.add;
1211: END IF;

Line 1210: FND_MSG_PUB.add;

1206: OR p_attribute_code_rec.enabled_flag IS NULL THEN
1207: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1208: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1209: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1210: FND_MSG_PUB.add;
1211: END IF;
1212: x_return_status := FND_API.g_ret_sts_error;
1213: RETURN;
1214: END IF;

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

1215:
1216:
1217: IF p_attribute_code_rec.description = FND_API.G_MISS_CHAR
1218: OR p_attribute_code_rec.description IS NULL THEN
1219: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1220: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1221: FND_MESSAGE.set_token('COLUMN','description');
1222: FND_MSG_PUB.add;
1223: END IF;

Line 1222: FND_MSG_PUB.add;

1218: OR p_attribute_code_rec.description IS NULL THEN
1219: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1220: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1221: FND_MESSAGE.set_token('COLUMN','description');
1222: FND_MSG_PUB.add;
1223: END IF;
1224: x_return_status := FND_API.g_ret_sts_error;
1225: RETURN;
1226: END IF;

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

1227:
1228: ELSE
1229:
1230: IF p_attribute_code_rec.attr_code_id IS NULL THEN
1231: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1232: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1233: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1234: FND_MSG_PUB.add;
1235: END IF;

Line 1234: FND_MSG_PUB.add;

1230: IF p_attribute_code_rec.attr_code_id IS NULL THEN
1231: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1232: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1233: FND_MESSAGE.set_token('COLUMN','attr_code_id');
1234: FND_MSG_PUB.add;
1235: END IF;
1236: x_return_status := FND_API.g_ret_sts_error;
1237: RETURN;
1238: END IF;

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

1237: RETURN;
1238: END IF;
1239:
1240: IF p_attribute_code_rec.attr_code IS NULL THEN
1241: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1242: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1243: FND_MESSAGE.set_token('COLUMN','attr_code');
1244: FND_MSG_PUB.add;
1245: END IF;

Line 1244: FND_MSG_PUB.add;

1240: IF p_attribute_code_rec.attr_code IS NULL THEN
1241: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1242: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1243: FND_MESSAGE.set_token('COLUMN','attr_code');
1244: FND_MSG_PUB.add;
1245: END IF;
1246: x_return_status := FND_API.g_ret_sts_error;
1247: RETURN;
1248: END IF;

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

1247: RETURN;
1248: END IF;
1249:
1250: IF p_attribute_code_rec.last_update_date IS NULL THEN
1251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1252: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1253: FND_MESSAGE.set_token('COLUMN','last_update_date');
1254: FND_MSG_PUB.add;
1255: END IF;

Line 1254: FND_MSG_PUB.add;

1250: IF p_attribute_code_rec.last_update_date IS NULL THEN
1251: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1252: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1253: FND_MESSAGE.set_token('COLUMN','last_update_date');
1254: FND_MSG_PUB.add;
1255: END IF;
1256: x_return_status := FND_API.g_ret_sts_error;
1257: RETURN;
1258: END IF;

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

1257: RETURN;
1258: END IF;
1259:
1260: IF p_attribute_code_rec.last_updated_by IS NULL THEN
1261: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1262: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1263: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1264: FND_MSG_PUB.add;
1265: END IF;

Line 1264: FND_MSG_PUB.add;

1260: IF p_attribute_code_rec.last_updated_by IS NULL THEN
1261: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1262: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1263: FND_MESSAGE.set_token('COLUMN','last_updated_by');
1264: FND_MSG_PUB.add;
1265: END IF;
1266: x_return_status := FND_API.g_ret_sts_error;
1267: RETURN;
1268: END IF;

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

1267: RETURN;
1268: END IF;
1269:
1270: IF p_attribute_code_rec.creation_date IS NULL THEN
1271: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1272: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1273: FND_MESSAGE.set_token('COLUMN','creation_date');
1274: FND_MSG_PUB.add;
1275: END IF;

Line 1274: FND_MSG_PUB.add;

1270: IF p_attribute_code_rec.creation_date IS NULL THEN
1271: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1272: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1273: FND_MESSAGE.set_token('COLUMN','creation_date');
1274: FND_MSG_PUB.add;
1275: END IF;
1276: x_return_status := FND_API.g_ret_sts_error;
1277: RETURN;
1278: END IF;

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

1277: RETURN;
1278: END IF;
1279:
1280: IF p_attribute_code_rec.created_by IS NULL THEN
1281: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1282: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1283: FND_MESSAGE.set_token('COLUMN','created_by');
1284: FND_MSG_PUB.add;
1285: END IF;

Line 1284: FND_MSG_PUB.add;

1280: IF p_attribute_code_rec.created_by IS NULL THEN
1281: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1282: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1283: FND_MESSAGE.set_token('COLUMN','created_by');
1284: FND_MSG_PUB.add;
1285: END IF;
1286: x_return_status := FND_API.g_ret_sts_error;
1287: RETURN;
1288: END IF;

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

1287: RETURN;
1288: END IF;
1289:
1290: IF p_attribute_code_rec.last_update_login IS NULL THEN
1291: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1292: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1293: FND_MESSAGE.set_token('COLUMN','last_update_login');
1294: FND_MSG_PUB.add;
1295: END IF;

Line 1294: FND_MSG_PUB.add;

1290: IF p_attribute_code_rec.last_update_login IS NULL THEN
1291: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1292: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1293: FND_MESSAGE.set_token('COLUMN','last_update_login');
1294: FND_MSG_PUB.add;
1295: END IF;
1296: x_return_status := FND_API.g_ret_sts_error;
1297: RETURN;
1298: END IF;

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

1297: RETURN;
1298: END IF;
1299:
1300: IF p_attribute_code_rec.object_version_number IS NULL THEN
1301: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1302: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1303: FND_MESSAGE.set_token('COLUMN','object_version_number');
1304: FND_MSG_PUB.add;
1305: END IF;

Line 1304: FND_MSG_PUB.add;

1300: IF p_attribute_code_rec.object_version_number IS NULL THEN
1301: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1302: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1303: FND_MESSAGE.set_token('COLUMN','object_version_number');
1304: FND_MSG_PUB.add;
1305: END IF;
1306: x_return_status := FND_API.g_ret_sts_error;
1307: RETURN;
1308: END IF;

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

1307: RETURN;
1308: END IF;
1309:
1310: IF p_attribute_code_rec.attribute_id IS NULL THEN
1311: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1312: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1313: FND_MESSAGE.set_token('COLUMN','attribute_id');
1314: FND_MSG_PUB.add;
1315: END IF;

Line 1314: FND_MSG_PUB.add;

1310: IF p_attribute_code_rec.attribute_id IS NULL THEN
1311: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1312: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1313: FND_MESSAGE.set_token('COLUMN','attribute_id');
1314: FND_MSG_PUB.add;
1315: END IF;
1316: x_return_status := FND_API.g_ret_sts_error;
1317: RETURN;
1318: END IF;

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

1317: RETURN;
1318: END IF;
1319:
1320: IF p_attribute_code_rec.enabled_flag IS NULL THEN
1321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1322: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1323: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1324: FND_MSG_PUB.add;
1325: END IF;

Line 1324: FND_MSG_PUB.add;

1320: IF p_attribute_code_rec.enabled_flag IS NULL THEN
1321: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1322: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1323: FND_MESSAGE.set_token('COLUMN','enabled_flag');
1324: FND_MSG_PUB.add;
1325: END IF;
1326: x_return_status := FND_API.g_ret_sts_error;
1327: RETURN;
1328: END IF;

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

1329:
1330:
1331:
1332: IF p_attribute_code_rec.description IS NULL THEN
1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1335: FND_MESSAGE.set_token('COLUMN','description');
1336: FND_MSG_PUB.add;
1337: END IF;

Line 1336: FND_MSG_PUB.add;

1332: IF p_attribute_code_rec.description IS NULL THEN
1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
1335: FND_MESSAGE.set_token('COLUMN','description');
1336: FND_MSG_PUB.add;
1337: END IF;
1338: x_return_status := FND_API.g_ret_sts_error;
1339: RETURN;
1340: END IF;

Line 1539: FND_MSG_PUB.initialize;

1535:
1536: -- Initialize message list if p_init_msg_list is set to TRUE.
1537: IF FND_API.to_Boolean( p_init_msg_list )
1538: THEN
1539: FND_MSG_PUB.initialize;
1540: END IF;
1541: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1542: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_Attr_Code_Items' );
1543: Check_Attr_Code_Items(

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

1578:
1579:
1580: -- Debug Message
1581:
1582: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1583: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1584: END IF;
1585: -- Initialize API return status to SUCCESS
1586: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1586: x_return_status := FND_API.G_RET_STS_SUCCESS;
1587:
1588:
1589: -- Debug Message
1590: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1591: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1592: END IF;
1593:
1594: -- Standard call to get message count and if count is 1, get message info.

Line 1595: FND_MSG_PUB.Count_And_Get

1591: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1592: END IF;
1593:
1594: -- Standard call to get message count and if count is 1, get message info.
1595: FND_MSG_PUB.Count_And_Get
1596: (p_count => x_msg_count,
1597: p_data => x_msg_data
1598: );
1599: EXCEPTION

Line 1609: FND_MSG_PUB.Count_And_Get (

1605: WHEN FND_API.G_EXC_ERROR THEN
1606: ROLLBACK TO Validate_Attribute_Code;
1607: x_return_status := FND_API.G_RET_STS_ERROR;
1608: -- Standard call to get message count and if count=1, get the message
1609: FND_MSG_PUB.Count_And_Get (
1610: p_encoded => FND_API.G_FALSE,
1611: p_count => x_msg_count,
1612: p_data => x_msg_data
1613: );

Line 1619: FND_MSG_PUB.Count_And_Get (

1615: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1616: ROLLBACK TO Validate_Attribute_Code;
1617: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1618: -- Standard call to get message count and if count=1, get the message
1619: FND_MSG_PUB.Count_And_Get (
1620: p_encoded => FND_API.G_FALSE,
1621: p_count => x_msg_count,
1622: p_data => x_msg_data
1623: );

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

1624:
1625: WHEN OTHERS THEN
1626: ROLLBACK TO Validate_Attribute_Code;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message

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

1626: ROLLBACK TO Validate_Attribute_Code;
1627: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1628: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,

Line 1633: FND_MSG_PUB.Count_And_Get (

1629: THEN
1630: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1631: END IF;
1632: -- Standard call to get message count and if count=1, get the message
1633: FND_MSG_PUB.Count_And_Get (
1634: p_encoded => FND_API.G_FALSE,
1635: p_count => x_msg_count,
1636: p_data => x_msg_data
1637: );

Line 1655: FND_MSG_PUB.initialize;

1651: BEGIN
1652: -- Initialize message list if p_init_msg_list is set to TRUE.
1653: IF FND_API.to_Boolean( p_init_msg_list )
1654: THEN
1655: FND_MSG_PUB.initialize;
1656: END IF;
1657:
1658: -- Initialize API return status to SUCCESS
1659: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1663: -- THEN
1664: -- x_return_status := FND_API.G_RET_STS_ERROR;
1665:
1666: -- Debug Message
1667: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW)) THEN
1668: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1669: END IF;
1670:
1671: -- Standard call to get message count and if count is 1, get message info.

Line 1672: FND_MSG_PUB.Count_And_Get

1668: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1669: END IF;
1670:
1671: -- Standard call to get message count and if count is 1, get message info.
1672: FND_MSG_PUB.Count_And_Get
1673: (p_count => x_msg_count,
1674: p_data => x_msg_data
1675: );
1676: END VALIDATE_ATTR_CODE_REC;