APPS.PV_ATTRIBUTE_USAGE_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: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

75: FND_MSG_PUB.initialize;
76: END IF;
77:
78: -- Debug Message
79: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
80: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
81: END IF;
82:
83: -- Initialize API return status to SUCCESS

Line 112: FND_MSG_PUB.add;

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

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

115:
116: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
117: THEN
118: -- Debug message
119: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
120: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Usage');
121: end if;
122:
123: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_attribute_usage' );

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

151: END IF;
152:
153: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
154: -- Debug Message
155: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
156: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
157: END IF;
158:
159: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Insert_Row)

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

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

Line 203: FND_MSG_PUB.Count_And_Get

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

Line 217: FND_MSG_PUB.Count_And_Get (

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

Line 227: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 241: FND_MSG_PUB.Count_And_Get (

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

Line 295: FND_MSG_PUB.initialize;

291:
292: -- Initialize message list if p_init_msg_list is set to TRUE.
293: IF FND_API.to_Boolean( p_init_msg_list )
294: THEN
295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Debug Message
299: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

295: FND_MSG_PUB.initialize;
296: END IF;
297:
298: -- Debug Message
299: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
300: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
301: END IF;
302:
303:

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

304: -- Initialize API return status to SUCCESS
305: x_return_status := FND_API.G_RET_STS_SUCCESS;
306:
307: -- Debug Message
308: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
309: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
310: END IF;
311:
312: OPEN c_get_Attribute_Usage( l_tar_attribute_usage_rec.attribute_usage_id);

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

313:
314: FETCH c_get_Attribute_Usage INTO l_ref_attribute_usage_rec ;
315:
316: IF ( c_get_Attribute_Usage%NOTFOUND) THEN
317: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));

Line 322: FND_MSG_PUB.add;

318: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
319: FND_MESSAGE.set_token('MODE','Update');
320: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
321: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_attribute_usage_rec.attribute_usage_id));
322: FND_MSG_PUB.add;
323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: -- Debug Message

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

323: END IF;
324: RAISE FND_API.G_EXC_ERROR;
325: END IF;
326: -- Debug Message
327: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
328: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
329: END IF;
330:
331: CLOSE c_get_Attribute_Usage;

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

334:
335: IF (l_tar_attribute_usage_rec.object_version_number is NULL or
336: l_tar_attribute_usage_rec.object_version_number = FND_API.G_MISS_NUM ) Then
337:
338: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
339: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
340: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_usage_rec.last_update_date));
341: FND_MSG_PUB.add;
342: END IF;

Line 341: FND_MSG_PUB.add;

337:
338: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
339: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
340: FND_MESSAGE.set_token('COLUMN',TO_CHAR(l_tar_attribute_usage_rec.last_update_date));
341: FND_MSG_PUB.add;
342: END IF;
343: RAISE FND_API.G_EXC_ERROR;
344: End if;
345:

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

344: End if;
345:
346: -- Check Whether record has been changed by someone else
347: If (l_tar_attribute_usage_rec.object_version_number <> l_ref_attribute_usage_rec.object_version_number) Then
348: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
349: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
350: FND_MESSAGE.set_token('VALUE','Attribute_Usage');
351: FND_MSG_PUB.add;
352: END IF;

Line 351: FND_MSG_PUB.add;

347: If (l_tar_attribute_usage_rec.object_version_number <> l_ref_attribute_usage_rec.object_version_number) Then
348: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
349: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
350: FND_MESSAGE.set_token('VALUE','Attribute_Usage');
351: FND_MSG_PUB.add;
352: END IF;
353: RAISE FND_API.G_EXC_ERROR;
354: End if;
355: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

354: End if;
355: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
356: THEN
357: -- Debug message
358: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
359: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_Attribute_Usage');
360: END IF;
361:
362: -- Invoke validation procedures

Line 382: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');

378: END IF;
379:
380:
381: -- Debug Message
382: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
383: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:

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

379:
380:
381: -- Debug Message
382: --PVX_Utility_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_ERROR, 'Private API: Calling update table handler');
383: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
384: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling update table handler');
385: END IF;
386:
387: -- Invoke table handler(PV_ATTRIBUTE_USAGES_PKG.Update_Row)

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

416: END IF;
417:
418:
419: -- Debug Message
420: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
421: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
422: END IF;
423:
424: -- Standard call to get message count and if count is 1, get message info.

Line 425: FND_MSG_PUB.Count_And_Get

421: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
422: END IF;
423:
424: -- Standard call to get message count and if count is 1, get message info.
425: FND_MSG_PUB.Count_And_Get
426: (p_count => x_msg_count,
427: p_data => x_msg_data
428: );
429: EXCEPTION

Line 439: FND_MSG_PUB.Count_And_Get (

435: WHEN FND_API.G_EXC_ERROR THEN
436: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
437: x_return_status := FND_API.G_RET_STS_ERROR;
438: -- Standard call to get message count and if count=1, get the message
439: FND_MSG_PUB.Count_And_Get (
440: p_encoded => FND_API.G_FALSE,
441: p_count => x_msg_count,
442: p_data => x_msg_data
443: );

Line 449: FND_MSG_PUB.Count_And_Get (

445: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
446: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
447: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
448: -- Standard call to get message count and if count=1, get the message
449: FND_MSG_PUB.Count_And_Get (
450: p_encoded => FND_API.G_FALSE,
451: p_count => x_msg_count,
452: p_data => x_msg_data
453: );

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

454:
455: WHEN OTHERS THEN
456: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
461: END IF;
462: -- Standard call to get message count and if count=1, get the message

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

456: ROLLBACK TO UPDATE_Attribute_Usage_PVT;
457: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
458: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
461: END IF;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,

Line 463: FND_MSG_PUB.Count_And_Get (

459: THEN
460: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
461: END IF;
462: -- Standard call to get message count and if count=1, get the message
463: FND_MSG_PUB.Count_And_Get (
464: p_encoded => FND_API.G_FALSE,
465: p_count => x_msg_count,
466: p_data => x_msg_data
467: );

Line 507: FND_MSG_PUB.initialize;

503:
504: -- Initialize message list if p_init_msg_list is set to TRUE.
505: IF FND_API.to_Boolean( p_init_msg_list )
506: THEN
507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Debug Message
511: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

507: FND_MSG_PUB.initialize;
508: END IF;
509:
510: -- Debug Message
511: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
512: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
513: END IF;
514:
515:

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

519: --
520: -- Api body
521: --
522: -- Debug Message
523: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
524: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
525: END IF;
526:
527:

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

539: END IF;
540:
541:
542: -- Debug Message
543: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
544: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.

Line 548: FND_MSG_PUB.Count_And_Get

544: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
545: END IF;
546:
547: -- Standard call to get message count and if count is 1, get message info.
548: FND_MSG_PUB.Count_And_Get
549: (p_count => x_msg_count,
550: p_data => x_msg_data
551: );
552: EXCEPTION

Line 562: FND_MSG_PUB.Count_And_Get (

558: WHEN FND_API.G_EXC_ERROR THEN
559: ROLLBACK TO DELETE_Attribute_Usage_PVT;
560: x_return_status := FND_API.G_RET_STS_ERROR;
561: -- Standard call to get message count and if count=1, get the message
562: FND_MSG_PUB.Count_And_Get (
563: p_encoded => FND_API.G_FALSE,
564: p_count => x_msg_count,
565: p_data => x_msg_data
566: );

Line 572: FND_MSG_PUB.Count_And_Get (

568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
569: ROLLBACK TO DELETE_Attribute_Usage_PVT;
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
571: -- Standard call to get message count and if count=1, get the message
572: FND_MSG_PUB.Count_And_Get (
573: p_encoded => FND_API.G_FALSE,
574: p_count => x_msg_count,
575: p_data => x_msg_data
576: );

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

577:
578: WHEN OTHERS THEN
579: ROLLBACK TO DELETE_Attribute_Usage_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
584: END IF;
585: -- Standard call to get message count and if count=1, get the message

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

579: ROLLBACK TO DELETE_Attribute_Usage_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
584: END IF;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,

Line 586: FND_MSG_PUB.Count_And_Get (

582: THEN
583: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
584: END IF;
585: -- Standard call to get message count and if count=1, get the message
586: FND_MSG_PUB.Count_And_Get (
587: p_encoded => FND_API.G_FALSE,
588: p_count => x_msg_count,
589: p_data => x_msg_data
590: );

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

620:
621: BEGIN
622:
623: -- Debug Message
624: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
625: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
626: END IF;
627:
628: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 631: FND_MSG_PUB.initialize;

627:
628: -- Initialize message list if p_init_msg_list is set to TRUE.
629: IF FND_API.to_Boolean( p_init_msg_list )
630: THEN
631: FND_MSG_PUB.initialize;
632: END IF;
633:
634: -- Standard call to check for call compatibility.
635: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

645: x_return_status := FND_API.G_RET_STS_SUCCESS;
646:
647:
648: ------------------------ lock -------------------------
649: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
650: PVX_Utility_PVT.debug_message(l_full_name||': start');
651: END IF;
652: OPEN c_Attribute_Usage;
653:

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

654: FETCH c_Attribute_Usage INTO l_ATTRIBUTE_USAGE_ID;
655:
656: IF (c_Attribute_Usage%NOTFOUND) THEN
657: CLOSE c_Attribute_Usage;
658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
659: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
660: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
661: FND_MSG_PUB.add;
662: END IF;

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

655:
656: IF (c_Attribute_Usage%NOTFOUND) THEN
657: CLOSE c_Attribute_Usage;
658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
659: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
660: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
661: FND_MSG_PUB.add;
662: END IF;
663: END IF;

Line 661: FND_MSG_PUB.add;

657: CLOSE c_Attribute_Usage;
658: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
659: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
660: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_NOT_FOUND');
661: FND_MSG_PUB.add;
662: END IF;
663: END IF;
664: RAISE FND_API.g_exc_error;
665: END IF;

Line 670: FND_MSG_PUB.count_and_get(

666:
667: CLOSE c_Attribute_Usage;
668:
669: -------------------- finish --------------------------
670: FND_MSG_PUB.count_and_get(
671: p_encoded => FND_API.g_false,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

670: FND_MSG_PUB.count_and_get(
671: p_encoded => FND_API.g_false,
672: p_count => x_msg_count,
673: p_data => x_msg_data);
674: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
675: PVX_Utility_PVT.debug_message(l_full_name ||': end');
676: END IF;
677: EXCEPTION
678: /*

Line 687: FND_MSG_PUB.Count_And_Get (

683: WHEN FND_API.G_EXC_ERROR THEN
684: ROLLBACK TO LOCK_Attribute_Usage_PVT;
685: x_return_status := FND_API.G_RET_STS_ERROR;
686: -- Standard call to get message count and if count=1, get the message
687: FND_MSG_PUB.Count_And_Get (
688: p_encoded => FND_API.G_FALSE,
689: p_count => x_msg_count,
690: p_data => x_msg_data
691: );

Line 697: FND_MSG_PUB.Count_And_Get (

693: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
694: ROLLBACK TO LOCK_Attribute_Usage_PVT;
695: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
696: -- Standard call to get message count and if count=1, get the message
697: FND_MSG_PUB.Count_And_Get (
698: p_encoded => FND_API.G_FALSE,
699: p_count => x_msg_count,
700: p_data => x_msg_data
701: );

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

702:
703: WHEN OTHERS THEN
704: ROLLBACK TO LOCK_Attribute_Usage_PVT;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
707: THEN
708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
709: END IF;
710: -- Standard call to get message count and if count=1, get the message

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

704: ROLLBACK TO LOCK_Attribute_Usage_PVT;
705: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
706: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
707: THEN
708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
709: END IF;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,

Line 711: FND_MSG_PUB.Count_And_Get (

707: THEN
708: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
709: END IF;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );

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

738: );
739: END IF;
740:
741: IF l_valid_flag = FND_API.g_false THEN
742: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
743: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );
745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
746: FND_MSG_PUB.add;

Line 746: FND_MSG_PUB.add;

742: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
743: FND_MESSAGE.set_name('PV', 'PV_API_DUPLICATE_ENTITY');
744: FND_MESSAGE.set_token('ID',to_char(p_attribute_usage_rec.ATTRIBUTE_USAGE_ID) );
745: FND_MESSAGE.set_token('ENTITY','Attribute_Usage');
746: FND_MSG_PUB.add;
747: END IF;
748: x_return_status := FND_API.g_ret_sts_error;
749: RETURN;
750: END IF;

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

767: -- TO_CHAR(p_attribute_usage_rec.attribute_usage_id));
768:
769: IF p_attribute_usage_rec.attribute_usage_id = FND_API.g_miss_num
770: OR p_attribute_usage_rec.attribute_usage_id IS NULL THEN
771: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
773: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
774: FND_MSG_PUB.add;
775: END IF;

Line 774: FND_MSG_PUB.add;

770: OR p_attribute_usage_rec.attribute_usage_id IS NULL THEN
771: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
772: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
773: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
774: FND_MSG_PUB.add;
775: END IF;
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
778: END IF;

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

779:
780:
781: IF p_attribute_usage_rec.last_update_date = FND_API.g_miss_date
782: OR p_attribute_usage_rec.last_update_date IS NULL THEN
783: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
784: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
785: FND_MESSAGE.set_token('COLUMN','last_update_date');
786: FND_MSG_PUB.add;
787: END IF;

Line 786: FND_MSG_PUB.add;

782: OR p_attribute_usage_rec.last_update_date IS NULL THEN
783: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
784: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
785: FND_MESSAGE.set_token('COLUMN','last_update_date');
786: FND_MSG_PUB.add;
787: END IF;
788: x_return_status := FND_API.g_ret_sts_error;
789: RETURN;
790: END IF;

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

791:
792:
793: IF p_attribute_usage_rec.last_updated_by = FND_API.g_miss_num
794: OR p_attribute_usage_rec.last_updated_by IS NULL THEN
795: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','last_updated_by');
798: FND_MSG_PUB.add;
799: END IF;

Line 798: FND_MSG_PUB.add;

794: OR p_attribute_usage_rec.last_updated_by IS NULL THEN
795: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
796: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
797: FND_MESSAGE.set_token('COLUMN','last_updated_by');
798: FND_MSG_PUB.add;
799: END IF;
800: x_return_status := FND_API.g_ret_sts_error;
801: RETURN;
802: END IF;

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

803:
804:
805: IF p_attribute_usage_rec.creation_date = FND_API.g_miss_date
806: OR p_attribute_usage_rec.creation_date IS NULL THEN
807: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
808: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
809: FND_MESSAGE.set_token('COLUMN','creation_date');
810: FND_MSG_PUB.add;
811: END IF;

Line 810: FND_MSG_PUB.add;

806: OR p_attribute_usage_rec.creation_date IS NULL THEN
807: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
808: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
809: FND_MESSAGE.set_token('COLUMN','creation_date');
810: FND_MSG_PUB.add;
811: END IF;
812: x_return_status := FND_API.g_ret_sts_error;
813: RETURN;
814: END IF;

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

815:
816:
817: IF p_attribute_usage_rec.created_by = FND_API.g_miss_num
818: OR p_attribute_usage_rec.created_by IS NULL THEN
819: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','created_by');
822: FND_MSG_PUB.add;
823: END IF;

Line 822: FND_MSG_PUB.add;

818: OR p_attribute_usage_rec.created_by IS NULL THEN
819: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
820: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
821: FND_MESSAGE.set_token('COLUMN','created_by');
822: FND_MSG_PUB.add;
823: END IF;
824: x_return_status := FND_API.g_ret_sts_error;
825: RETURN;
826: END IF;

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

827:
828:
829: IF p_attribute_usage_rec.object_version_number = FND_API.g_miss_num
830: OR p_attribute_usage_rec.object_version_number IS NULL THEN
831: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
832: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
833: FND_MESSAGE.set_token('COLUMN','object_version_number');
834: FND_MSG_PUB.add;
835: END IF;

Line 834: FND_MSG_PUB.add;

830: OR p_attribute_usage_rec.object_version_number IS NULL THEN
831: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
832: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
833: FND_MESSAGE.set_token('COLUMN','object_version_number');
834: FND_MSG_PUB.add;
835: END IF;
836: x_return_status := FND_API.g_ret_sts_error;
837: RETURN;
838: END IF;

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

839:
840:
841: IF p_attribute_usage_rec.attribute_usage_type = FND_API.g_miss_char
842: OR p_attribute_usage_rec.attribute_usage_type IS NULL THEN
843: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
844: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
845: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
846: FND_MSG_PUB.add;
847: END IF;

Line 846: FND_MSG_PUB.add;

842: OR p_attribute_usage_rec.attribute_usage_type IS NULL THEN
843: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
844: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
845: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
846: FND_MSG_PUB.add;
847: END IF;
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;

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

851:
852:
853: IF p_attribute_usage_rec.attribute_usage_code = FND_API.g_miss_char
854: OR p_attribute_usage_rec.attribute_usage_code IS NULL THEN
855: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
856: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
857: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
858: FND_MSG_PUB.add;
859: END IF;

Line 858: FND_MSG_PUB.add;

854: OR p_attribute_usage_rec.attribute_usage_code IS NULL THEN
855: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
856: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
857: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
858: FND_MSG_PUB.add;
859: END IF;
860: x_return_status := FND_API.g_ret_sts_error;
861: RETURN;
862: END IF;

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

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

Line 870: FND_MSG_PUB.add;

866: OR p_attribute_usage_rec.attribute_id IS NULL THEN
867: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
868: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
869: FND_MESSAGE.set_token('COLUMN','attribute_id');
870: FND_MSG_PUB.add;
871: END IF;
872: x_return_status := FND_API.g_ret_sts_error;
873: RETURN;
874: END IF;

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

875:
876:
877: IF p_attribute_usage_rec.enabled_flag = FND_API.g_miss_char
878: OR p_attribute_usage_rec.enabled_flag IS NULL THEN
879: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
880: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
881: FND_MESSAGE.set_token('COLUMN','enabled_flag');
882: FND_MSG_PUB.add;
883: END IF;

Line 882: FND_MSG_PUB.add;

878: OR p_attribute_usage_rec.enabled_flag IS NULL THEN
879: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
880: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
881: FND_MESSAGE.set_token('COLUMN','enabled_flag');
882: FND_MSG_PUB.add;
883: END IF;
884: x_return_status := FND_API.g_ret_sts_error;
885: RETURN;
886: END IF;

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

887: ELSE
888:
889:
890: IF p_attribute_usage_rec.attribute_usage_id IS NULL THEN
891: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
892: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
893: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
894: FND_MSG_PUB.add;
895: END IF;

Line 894: FND_MSG_PUB.add;

890: IF p_attribute_usage_rec.attribute_usage_id IS NULL THEN
891: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
892: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
893: FND_MESSAGE.set_token('COLUMN','attribute_usage_id');
894: FND_MSG_PUB.add;
895: END IF;
896: x_return_status := FND_API.g_ret_sts_error;
897: RETURN;
898: END IF;

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

898: END IF;
899:
900:
901: IF p_attribute_usage_rec.last_update_date IS NULL THEN
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
903: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
904: FND_MESSAGE.set_token('COLUMN','last_update_date');
905: FND_MSG_PUB.add;
906: END IF;

Line 905: FND_MSG_PUB.add;

901: IF p_attribute_usage_rec.last_update_date IS NULL THEN
902: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
903: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
904: FND_MESSAGE.set_token('COLUMN','last_update_date');
905: FND_MSG_PUB.add;
906: END IF;
907: x_return_status := FND_API.g_ret_sts_error;
908: RETURN;
909: END IF;

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

909: END IF;
910:
911:
912: IF p_attribute_usage_rec.last_updated_by IS NULL THEN
913: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
914: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
915: FND_MESSAGE.set_token('COLUMN','last_updated_by');
916: FND_MSG_PUB.add;
917: END IF;

Line 916: FND_MSG_PUB.add;

912: IF p_attribute_usage_rec.last_updated_by IS NULL THEN
913: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
914: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
915: FND_MESSAGE.set_token('COLUMN','last_updated_by');
916: FND_MSG_PUB.add;
917: END IF;
918: x_return_status := FND_API.g_ret_sts_error;
919: RETURN;
920: END IF;

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

920: END IF;
921:
922:
923: IF p_attribute_usage_rec.creation_date IS NULL THEN
924: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','creation_date');
927: FND_MSG_PUB.add;
928: END IF;

Line 927: FND_MSG_PUB.add;

923: IF p_attribute_usage_rec.creation_date IS NULL THEN
924: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
925: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
926: FND_MESSAGE.set_token('COLUMN','creation_date');
927: FND_MSG_PUB.add;
928: END IF;
929: x_return_status := FND_API.g_ret_sts_error;
930: RETURN;
931: END IF;

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

931: END IF;
932:
933:
934: IF p_attribute_usage_rec.created_by IS NULL THEN
935: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
936: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
937: FND_MESSAGE.set_token('COLUMN','created_by');
938: FND_MSG_PUB.add;
939: END IF;

Line 938: FND_MSG_PUB.add;

934: IF p_attribute_usage_rec.created_by IS NULL THEN
935: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
936: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
937: FND_MESSAGE.set_token('COLUMN','created_by');
938: FND_MSG_PUB.add;
939: END IF;
940: x_return_status := FND_API.g_ret_sts_error;
941: RETURN;
942: END IF;

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

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

Line 949: FND_MSG_PUB.add;

945: IF p_attribute_usage_rec.object_version_number IS NULL THEN
946: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
947: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
948: FND_MESSAGE.set_token('COLUMN','object_version_number');
949: FND_MSG_PUB.add;
950: END IF;
951: x_return_status := FND_API.g_ret_sts_error;
952: RETURN;
953: END IF;

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

953: END IF;
954:
955:
956: IF p_attribute_usage_rec.attribute_usage_type IS NULL THEN
957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
958: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
959: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
960: FND_MSG_PUB.add;
961: END IF;

Line 960: FND_MSG_PUB.add;

956: IF p_attribute_usage_rec.attribute_usage_type IS NULL THEN
957: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
958: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
959: FND_MESSAGE.set_token('COLUMN','attribute_usage_type');
960: FND_MSG_PUB.add;
961: END IF;
962: x_return_status := FND_API.g_ret_sts_error;
963: RETURN;
964: END IF;

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

964: END IF;
965:
966:
967: IF p_attribute_usage_rec.attribute_usage_code IS NULL THEN
968: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
969: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
970: FND_MESSAGE.set_token('COLUMN','attribute_usage_code');
971: FND_MSG_PUB.add;
972: END IF;

Line 971: FND_MSG_PUB.add;

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

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

975: END IF;
976:
977:
978: IF p_attribute_usage_rec.attribute_id IS NULL THEN
979: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
980: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
981: FND_MESSAGE.set_token('COLUMN','attribute_id');
982: FND_MSG_PUB.add;
983: END IF;

Line 982: FND_MSG_PUB.add;

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

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

986: END IF;
987:
988:
989: IF p_attribute_usage_rec.enabled_flag IS NULL THEN
990: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
991: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
992: FND_MESSAGE.set_token('COLUMN','enabled_flag');
993: FND_MSG_PUB.add;
994: END IF;

Line 993: FND_MSG_PUB.add;

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

Line 1217: FND_MSG_PUB.initialize;

1213:
1214: -- Initialize message list if p_init_msg_list is set to TRUE.
1215: IF FND_API.to_Boolean( p_init_msg_list )
1216: THEN
1217: FND_MSG_PUB.initialize;
1218: END IF;
1219: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1220: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Check_Attr_Usage_Items' );
1221: Check_Attr_Usage_Items(

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

1255: END IF;
1256:
1257:
1258: -- Debug Message
1259: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1260: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1261: END IF;
1262:
1263: -- Initialize API return status to SUCCESS

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

1264: x_return_status := FND_API.G_RET_STS_SUCCESS;
1265:
1266:
1267: -- Debug Message
1268: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1269: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.

Line 1273: FND_MSG_PUB.Count_And_Get

1269: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1270: END IF;
1271:
1272: -- Standard call to get message count and if count is 1, get message info.
1273: FND_MSG_PUB.Count_And_Get
1274: (p_count => x_msg_count,
1275: p_data => x_msg_data
1276: );
1277: EXCEPTION

Line 1287: FND_MSG_PUB.Count_And_Get (

1283: WHEN FND_API.G_EXC_ERROR THEN
1284: ROLLBACK TO VALIDATE_Attribute_Usage;
1285: x_return_status := FND_API.G_RET_STS_ERROR;
1286: -- Standard call to get message count and if count=1, get the message
1287: FND_MSG_PUB.Count_And_Get (
1288: p_encoded => FND_API.G_FALSE,
1289: p_count => x_msg_count,
1290: p_data => x_msg_data
1291: );

Line 1297: FND_MSG_PUB.Count_And_Get (

1293: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1294: ROLLBACK TO VALIDATE_Attribute_Usage;
1295: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1296: -- Standard call to get message count and if count=1, get the message
1297: FND_MSG_PUB.Count_And_Get (
1298: p_encoded => FND_API.G_FALSE,
1299: p_count => x_msg_count,
1300: p_data => x_msg_data
1301: );

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

1302:
1303: WHEN OTHERS THEN
1304: ROLLBACK TO VALIDATE_Attribute_Usage;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1309: END IF;
1310: -- Standard call to get message count and if count=1, get the message

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

1304: ROLLBACK TO VALIDATE_Attribute_Usage;
1305: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1306: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1309: END IF;
1310: -- Standard call to get message count and if count=1, get the message
1311: FND_MSG_PUB.Count_And_Get (
1312: p_encoded => FND_API.G_FALSE,

Line 1311: FND_MSG_PUB.Count_And_Get (

1307: THEN
1308: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1309: END IF;
1310: -- Standard call to get message count and if count=1, get the message
1311: FND_MSG_PUB.Count_And_Get (
1312: p_encoded => FND_API.G_FALSE,
1313: p_count => x_msg_count,
1314: p_data => x_msg_data
1315: );

Line 1333: FND_MSG_PUB.initialize;

1329: BEGIN
1330: -- Initialize message list if p_init_msg_list is set to TRUE.
1331: IF FND_API.to_Boolean( p_init_msg_list )
1332: THEN
1333: FND_MSG_PUB.initialize;
1334: END IF;
1335:
1336: -- Initialize API return status to SUCCESS
1337: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1341: -- THEN
1342: -- x_return_status := FND_API.G_RET_STS_ERROR;
1343:
1344: -- Debug Message
1345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1346: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1347: END IF;
1348: -- Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get

Line 1349: FND_MSG_PUB.Count_And_Get

1345: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1346: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1347: END IF;
1348: -- Standard call to get message count and if count is 1, get message info.
1349: FND_MSG_PUB.Count_And_Get
1350: (p_count => x_msg_count,
1351: p_data => x_msg_data
1352: );
1353: END Validate_Attr_Usage_Rec;