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_ENTY_ATTR_VALIDATIONS_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:

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

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

Line 114: FND_MSG_PUB.add;

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

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

118:
119: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
120: THEN
121: -- Debug message
122: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
123: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Validate_enty_attr_validation');
124: END IF;
125:
126: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : Before Validate_attr_value' );

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

158:
159: --DBMS_OUTPUT.PUT_LINE(l_full_name||' : After Validate' );
160:
161: -- Debug Message
162: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
163: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling create table handler');
164: END IF;
165:
166: -- Invoke table handler(PV_ENTY_ATTR_VALUES_PKG.Insert_Row)

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

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

Line 206: FND_MSG_PUB.Count_And_Get (

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

Line 221: FND_MSG_PUB.Count_And_Get (

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

Line 231: FND_MSG_PUB.Count_And_Get (

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

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

236:
237: WHEN OTHERS THEN
238: ROLLBACK TO Create_Enty_Attr_Validation;
239: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
240: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
241: THEN
242: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
243: END IF;
244: -- Standard call to get message count and if count=1, get the message

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

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

Line 245: FND_MSG_PUB.Count_And_Get (

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

Line 301: FND_MSG_PUB.initialize;

297:
298: -- Initialize message list if p_init_msg_list is set to TRUE.
299: IF FND_API.to_Boolean( p_init_msg_list )
300: THEN
301: FND_MSG_PUB.initialize;
302: END IF;
303:
304: -- Debug Message
305: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

301: FND_MSG_PUB.initialize;
302: END IF;
303:
304: -- Debug Message
305: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
306: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
307: END IF;
308:
309: -- Initialize API return status to SUCCESS

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

309: -- Initialize API return status to SUCCESS
310: x_return_status := FND_API.G_RET_STS_SUCCESS;
311:
312: -- Debug Message
313: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
314: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Open Cursor to Select');
315: END IF;
316:
317: OPEN c_get_Enty_Attr_Validation( l_tar_enty_attr_validation_rec.validation_id);

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

318:
319: FETCH c_get_Enty_Attr_Validation INTO l_ref_enty_attr_validation_rec ;
320:
321: If ( c_get_Enty_Attr_Validation%NOTFOUND) THEN
322: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));

Line 327: FND_MSG_PUB.add;

323: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_ENTITY');
324: FND_MESSAGE.set_token('MODE','Update');
325: FND_MESSAGE.set_token('ENTITY','Enty_Attr_Validation');
326: FND_MESSAGE.set_token('ID',TO_CHAR(l_tar_enty_attr_validation_rec.validation_id));
327: FND_MSG_PUB.add;
328: END IF;
329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:

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

329: RAISE FND_API.G_EXC_ERROR;
330: END IF;
331:
332: -- Debug Message
333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
334: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Close Cursor');
335: END IF;
336: CLOSE c_get_Enty_Attr_Validation;
337:

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

337:
338:
339: If (l_tar_enty_attr_validation_rec.object_version_number is NULL or
340: l_tar_enty_attr_validation_rec.object_version_number = FND_API.G_MISS_NUM ) Then
341: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
342: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
343: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
344: FND_MSG_PUB.add;
345: END IF;

Line 344: FND_MSG_PUB.add;

340: l_tar_enty_attr_validation_rec.object_version_number = FND_API.G_MISS_NUM ) Then
341: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
342: FND_MESSAGE.set_name('PV', 'PV_API_VERSION_MISSING');
343: FND_MESSAGE.set_token('COLUMN','Last_Update_Date');
344: FND_MSG_PUB.add;
345: END IF;
346: RAISE FND_API.G_EXC_ERROR;
347: End if;
348:

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

347: End if;
348:
349: -- Check Whether record has been changed by someone else
350: If (l_tar_enty_attr_validation_rec.object_version_number <> l_ref_enty_attr_validation_rec.object_version_number) Then
351: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
352: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
353: FND_MESSAGE.set_token('VALUE','Enty_Attr_Validation');
354: FND_MSG_PUB.add;
355: END IF;

Line 354: FND_MSG_PUB.add;

350: If (l_tar_enty_attr_validation_rec.object_version_number <> l_ref_enty_attr_validation_rec.object_version_number) Then
351: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
352: FND_MESSAGE.set_name('PV', 'PV_API_RECORD_CHANGED');
353: FND_MESSAGE.set_token('VALUE','Enty_Attr_Validation');
354: FND_MSG_PUB.add;
355: END IF;
356: RAISE FND_API.G_EXC_ERROR;
357: End if;
358: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

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

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

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

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

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

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

Line 422: FND_MSG_PUB.Count_And_Get (

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

Line 436: FND_MSG_PUB.Count_And_Get (

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

Line 446: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 460: FND_MSG_PUB.Count_And_Get (

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

Line 506: FND_MSG_PUB.initialize;

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

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

506: FND_MSG_PUB.initialize;
507: END IF;
508:
509: -- Debug Message
510: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
511: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
512: END IF;
513: -- Initialize API return status to SUCCESS
514: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

516: --
517: -- Api body
518: --
519: -- Debug Message
520: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
521: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - Calling delete table handler');
522: END IF;
523:
524: -- Invoke table handler(PV_ENTY_ATTR_VALIDATIONS_PKG.Delete_Row)

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

534: COMMIT WORK;
535: END IF;
536:
537: -- Debug Message
538: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
539: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
540: END IF;
541:
542: -- Standard call to get message count and if count is 1, get message info.

Line 543: FND_MSG_PUB.Count_And_Get (

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

Line 557: FND_MSG_PUB.Count_And_Get (

553: WHEN FND_API.G_EXC_ERROR THEN
554: ROLLBACK TO Delete_Enty_Attr_Validation;
555: x_return_status := FND_API.G_RET_STS_ERROR;
556: -- Standard call to get message count and if count=1, get the message
557: FND_MSG_PUB.Count_And_Get (
558: p_encoded => FND_API.G_FALSE
559: ,p_count => x_msg_count
560: ,p_data => x_msg_data
561: );

Line 567: FND_MSG_PUB.Count_And_Get (

563: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
564: ROLLBACK TO Delete_Enty_Attr_Validation;
565: x_return_status := FND_API.G_RET_STS_UNEXP_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 576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

572:
573: WHEN OTHERS THEN
574: ROLLBACK TO Delete_Enty_Attr_Validation;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message

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

574: ROLLBACK TO Delete_Enty_Attr_Validation;
575: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
576: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE

Line 581: FND_MSG_PUB.Count_And_Get (

577: THEN
578: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
579: END IF;
580: -- Standard call to get message count and if count=1, get the message
581: FND_MSG_PUB.Count_And_Get (
582: p_encoded => FND_API.G_FALSE
583: ,p_count => x_msg_count
584: ,p_data => x_msg_data
585: );

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

618: -- Standard Start of API savepoint
619: SAVEPOINT Lock_Enty_Attr_Validation;
620:
621: -- Debug Message
622: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
623: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
624: END IF;
625:
626: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 629: FND_MSG_PUB.initialize;

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

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

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

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

653: FETCH c_Enty_Attr_Validation INTO l_ENTY_ATTR_VALIDATION_ID;
654:
655: IF (c_Enty_Attr_Validation%NOTFOUND) THEN
656: CLOSE c_Enty_Attr_Validation;
657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
658: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
659: FND_MSG_PUB.add;
660: END IF;
661: RAISE FND_API.g_exc_error;

Line 659: FND_MSG_PUB.add;

655: IF (c_Enty_Attr_Validation%NOTFOUND) THEN
656: CLOSE c_Enty_Attr_Validation;
657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
658: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
659: FND_MSG_PUB.add;
660: END IF;
661: RAISE FND_API.g_exc_error;
662: END IF;
663:

Line 667: FND_MSG_PUB.count_and_get(

663:
664: CLOSE c_Enty_Attr_Validation;
665:
666: -------------------- finish --------------------------
667: FND_MSG_PUB.count_and_get(
668: p_encoded => FND_API.g_false
669: ,p_count => x_msg_count
670: ,p_data => x_msg_data
671: );

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

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

Line 685: FND_MSG_PUB.Count_And_Get (

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

Line 695: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 709: FND_MSG_PUB.Count_And_Get (

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

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

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

Line 747: FND_MSG_PUB.add;

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

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

767:
768:
769: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
770: OR p_enty_attr_validation_rec.validation_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','validation_id');
774: FND_MSG_PUB.add;
775: END IF;

Line 774: FND_MSG_PUB.add;

770: OR p_enty_attr_validation_rec.validation_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','validation_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 784: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN

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

Line 787: FND_MSG_PUB.add;

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

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

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

Line 799: FND_MSG_PUB.add;

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

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

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

Line 811: FND_MSG_PUB.add;

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

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

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

Line 823: FND_MSG_PUB.add;

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

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

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

Line 835: FND_MSG_PUB.add;

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

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

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

Line 847: FND_MSG_PUB.add;

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

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

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

Line 859: FND_MSG_PUB.add;

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

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

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

Line 871: FND_MSG_PUB.add;

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

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

878: ELSE
879:
880: IF p_enty_attr_validation_rec.validation_id = FND_API.g_miss_num
881: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
882: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
883: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
884: FND_MESSAGE.set_token('COLUMN','validation_id');
885: FND_MSG_PUB.add;
886: END IF;

Line 885: FND_MSG_PUB.add;

881: OR p_enty_attr_validation_rec.validation_id IS NULL THEN
882: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
883: FND_MESSAGE.set_name('PV', 'PV_API_MISSING_REQ_COLUMN');
884: FND_MESSAGE.set_token('COLUMN','validation_id');
885: FND_MSG_PUB.add;
886: END IF;
887: x_return_status := FND_API.g_ret_sts_error;
888: RETURN;
889: END IF;

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

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

Line 898: FND_MSG_PUB.add;

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

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

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

Line 910: FND_MSG_PUB.add;

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

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

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

Line 922: FND_MSG_PUB.add;

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

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

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

Line 934: FND_MSG_PUB.add;

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

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

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

Line 946: FND_MSG_PUB.add;

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

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

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

Line 958: FND_MSG_PUB.add;

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

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

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

Line 970: FND_MSG_PUB.add;

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

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

975:
976:
977: IF p_enty_attr_validation_rec.validated_by_resource_id = FND_API.g_miss_num
978: OR p_enty_attr_validation_rec.validated_by_resource_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','validated_by_resource_id');
982: FND_MSG_PUB.add;
983: END IF;

Line 982: FND_MSG_PUB.add;

978: OR p_enty_attr_validation_rec.validated_by_resource_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','validated_by_resource_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 1204: FND_MSG_PUB.initialize;

1200:
1201: -- Initialize message list if p_init_msg_list is set to TRUE.
1202: IF FND_API.to_Boolean( p_init_msg_list )
1203: THEN
1204: FND_MSG_PUB.initialize;
1205: END IF;
1206: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1207:
1208: Check_Enty_Attr_vldtn_Items (

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

1242: END IF;
1243: END IF;
1244:
1245: -- Debug Message
1246: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1247: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - start');
1248: END IF;
1249:
1250: -- Initialize API return status to SUCCESS

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

1250: -- Initialize API return status to SUCCESS
1251: x_return_status := FND_API.G_RET_STS_SUCCESS;
1252:
1253: -- Debug Message
1254: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1255: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.

Line 1259: FND_MSG_PUB.Count_And_Get (

1255: PVX_Utility_PVT.debug_message('Private API: '||l_full_name||' - end');
1256: END IF;
1257:
1258: -- Standard call to get message count and if count is 1, get message info.
1259: FND_MSG_PUB.Count_And_Get (
1260: p_count => x_msg_count
1261: ,p_data => x_msg_data
1262: );
1263: EXCEPTION

Line 1273: FND_MSG_PUB.Count_And_Get (

1269: WHEN FND_API.G_EXC_ERROR THEN
1270: ROLLBACK TO Validate_Enty_Attr_Validation;
1271: x_return_status := FND_API.G_RET_STS_ERROR;
1272: -- Standard call to get message count and if count=1, get the message
1273: FND_MSG_PUB.Count_And_Get (
1274: p_encoded => FND_API.G_FALSE
1275: ,p_count => x_msg_count
1276: ,p_data => x_msg_data
1277: );

Line 1283: FND_MSG_PUB.Count_And_Get (

1279: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1280: ROLLBACK TO Validate_Enty_Attr_Validation;
1281: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1282: -- Standard call to get message count and if count=1, get the message
1283: FND_MSG_PUB.Count_And_Get (
1284: p_encoded => FND_API.G_FALSE
1285: ,p_count => x_msg_count
1286: ,p_data => x_msg_data
1287: );

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

1288:
1289: WHEN OTHERS THEN
1290: ROLLBACK TO Validate_Enty_Attr_Validation;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
1296: -- Standard call to get message count and if count=1, get the message

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

1290: ROLLBACK TO Validate_Enty_Attr_Validation;
1291: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1292: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
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

Line 1297: FND_MSG_PUB.Count_And_Get (

1293: THEN
1294: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1295: END IF;
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 1321: FND_MSG_PUB.initialize;

1317: BEGIN
1318: -- Initialize message list if p_init_msg_list is set to TRUE.
1319: IF FND_API.to_Boolean( p_init_msg_list )
1320: THEN
1321: FND_MSG_PUB.initialize;
1322: END IF;
1323:
1324: -- Initialize API return status to SUCCESS
1325: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

1329: -- THEN
1330: -- x_return_status := FND_API.G_RET_STS_ERROR;
1331:
1332: -- Debug Message
1333: IF (FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_ERROR)) THEN
1334: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.

Line 1338: FND_MSG_PUB.Count_And_Get (

1334: PVX_Utility_PVT.debug_message('Private API: Validate_dm_model_rec');
1335: END IF;
1336:
1337: -- Standard call to get message count and if count is 1, get message info.
1338: FND_MSG_PUB.Count_And_Get (
1339: p_count => x_msg_count
1340: ,p_data => x_msg_data
1341: );
1342: END Validate_enty_attr_vldtn_rec;