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.AMS_DMSOURCE_PVT dependencies on FND_MSG_PUB

Line 66: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);

62: -- Randomly set the build data flag to indicate that
63: -- an individual row in model data selection is to be
64: -- used for either training or testing.
65: --
66: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70:

Line 67: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

63: -- an individual row in model data selection is to be
64: -- used for either training or testing.
65: --
66: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70:
71: -- ODM External Schema Lookup Code

Line 68: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);

64: -- used for either training or testing.
65: --
66: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
67: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
68: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
69:
70:
71: -- ODM External Schema Lookup Code
72: G_ODM_SCHEMA_LOOKUP VARCHAR2(30) := 'ODMSCHEMA';

Line 188: FND_MSG_PUB.initialize;

184:
185: -- Initialize message list if p_init_msg_list is set to TRUE.
186: IF FND_API.to_Boolean( p_init_msg_list )
187: THEN
188: FND_MSG_PUB.initialize;
189: END IF;
190:
191: -- Standard call to check for call compatibility.
192: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

216: FETCH c_Source INTO l_SOURCE_ID;
217:
218: IF (c_Source%NOTFOUND) THEN
219: CLOSE c_Source;
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
222: FND_MSG_PUB.add;
223: END IF;
224: RAISE FND_API.g_exc_error;

Line 222: FND_MSG_PUB.add;

218: IF (c_Source%NOTFOUND) THEN
219: CLOSE c_Source;
220: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
221: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
222: FND_MSG_PUB.add;
223: END IF;
224: RAISE FND_API.g_exc_error;
225: END IF;
226:

Line 230: FND_MSG_PUB.count_and_get(

226:
227: CLOSE c_Source;
228:
229: -------------------- finish --------------------------
230: FND_MSG_PUB.count_and_get(
231: p_encoded => FND_API.g_false,
232: p_count => x_msg_count,
233: p_data => x_msg_data);
234: IF (AMS_DEBUG_HIGH_ON) THEN

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

238: EXCEPTION
239:
240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
243: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
244: FND_MSG_PUB.add;
245: END IF;
246:

Line 244: FND_MSG_PUB.add;

240: WHEN AMS_Utility_PVT.resource_locked THEN
241: x_return_status := FND_API.g_ret_sts_error;
242: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
243: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
244: FND_MSG_PUB.add;
245: END IF;
246:
247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO LOCK_source_PVT;

Line 251: FND_MSG_PUB.Count_And_Get (

247: WHEN FND_API.G_EXC_ERROR THEN
248: ROLLBACK TO LOCK_source_PVT;
249: x_return_status := FND_API.G_RET_STS_ERROR;
250: -- Standard call to get message count and if count=1, get the message
251: FND_MSG_PUB.Count_And_Get (
252: p_encoded => FND_API.G_FALSE,
253: p_count => x_msg_count,
254: p_data => x_msg_data
255: );

Line 261: FND_MSG_PUB.Count_And_Get (

257: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
258: ROLLBACK TO LOCK_source_PVT;
259: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
260: -- Standard call to get message count and if count=1, get the message
261: FND_MSG_PUB.Count_And_Get (
262: p_encoded => FND_API.G_FALSE,
263: p_count => x_msg_count,
264: p_data => x_msg_data
265: );

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

266:
267: WHEN OTHERS THEN
268: ROLLBACK TO LOCK_source_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message

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

268: ROLLBACK TO LOCK_source_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,

Line 275: FND_MSG_PUB.Count_And_Get (

271: THEN
272: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
273: END IF;
274: -- Standard call to get message count and if count=1, get the message
275: FND_MSG_PUB.Count_And_Get (
276: p_encoded => FND_API.G_FALSE,
277: p_count => x_msg_count,
278: p_data => x_msg_data
279: );

Line 333: FND_MSG_PUB.initialize;

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

Line 438: FND_MSG_PUB.Count_And_Get

434: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
435: END IF;
436:
437: -- Standard call to get message count and if count is 1, get message info.
438: FND_MSG_PUB.Count_And_Get
439: (p_count => x_msg_count,
440: p_data => x_msg_data
441: );
442: EXCEPTION

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

442: EXCEPTION
443:
444: WHEN AMS_Utility_PVT.resource_locked THEN
445: x_return_status := FND_API.g_ret_sts_error;
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
447: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
448: FND_MSG_PUB.add;
449: END IF;
450:

Line 448: FND_MSG_PUB.add;

444: WHEN AMS_Utility_PVT.resource_locked THEN
445: x_return_status := FND_API.g_ret_sts_error;
446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
447: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
448: FND_MSG_PUB.add;
449: END IF;
450:
451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO CREATE_source_PVT;

Line 455: FND_MSG_PUB.Count_And_Get (

451: WHEN FND_API.G_EXC_ERROR THEN
452: ROLLBACK TO CREATE_source_PVT;
453: x_return_status := FND_API.G_RET_STS_ERROR;
454: -- Standard call to get message count and if count=1, get the message
455: FND_MSG_PUB.Count_And_Get (
456: p_encoded => FND_API.G_FALSE,
457: p_count => x_msg_count,
458: p_data => x_msg_data
459: );

Line 465: FND_MSG_PUB.Count_And_Get (

461: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
462: ROLLBACK TO CREATE_source_PVT;
463: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
464: -- Standard call to get message count and if count=1, get the message
465: FND_MSG_PUB.Count_And_Get (
466: p_encoded => FND_API.G_FALSE,
467: p_count => x_msg_count,
468: p_data => x_msg_data
469: );

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

470:
471: WHEN OTHERS THEN
472: ROLLBACK TO CREATE_source_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
475: THEN
476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
477: END IF;
478: -- Standard call to get message count and if count=1, get the message

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

472: ROLLBACK TO CREATE_source_PVT;
473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
474: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
475: THEN
476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
477: END IF;
478: -- Standard call to get message count and if count=1, get the message
479: FND_MSG_PUB.Count_And_Get (
480: p_encoded => FND_API.G_FALSE,

Line 479: FND_MSG_PUB.Count_And_Get (

475: THEN
476: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
477: END IF;
478: -- Standard call to get message count and if count=1, get the message
479: FND_MSG_PUB.Count_And_Get (
480: p_encoded => FND_API.G_FALSE,
481: p_count => x_msg_count,
482: p_data => x_msg_data
483: );

Line 532: FND_MSG_PUB.initialize;

528:
529: -- Initialize message list if p_init_msg_list is set to TRUE.
530: IF FND_API.to_Boolean( p_init_msg_list )
531: THEN
532: FND_MSG_PUB.initialize;
533: END IF;
534:
535: -- Debug Message
536: IF (AMS_DEBUG_HIGH_ON) THEN

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

551: OPEN c_reference (l_tar_source_rec.source_id);
552: FETCH c_reference INTO l_reference_rec;
553: IF ( c_reference%NOTFOUND) THEN
554: CLOSE c_reference;
555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
556: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
557: FND_MESSAGE.Set_Token ('INFO', 'dm_source', FALSE);
558: FND_MSG_PUB.Add;
559: END IF;

Line 558: FND_MSG_PUB.Add;

554: CLOSE c_reference;
555: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
556: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
557: FND_MESSAGE.Set_Token ('INFO', 'dm_source', FALSE);
558: FND_MSG_PUB.Add;
559: END IF;
560: RAISE FND_API.g_exc_error;
561: END IF;
562: -- Debug Message

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

567: CLOSE c_reference;
568:
569: -- Check Whether record has been changed by someone else
570: IF (l_tar_source_rec.object_version_number <> l_reference_rec.object_version_number) THEN
571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
573: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
574: FND_MSG_PUB.ADD;
575: END IF;

Line 574: FND_MSG_PUB.ADD;

570: IF (l_tar_source_rec.object_version_number <> l_reference_rec.object_version_number) THEN
571: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
572: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
573: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
574: FND_MSG_PUB.ADD;
575: END IF;
576: RAISE FND_API.g_exc_error;
577: END IF;
578:

Line 605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);

601:
602: -- Debug Message
603: IF (AMS_DEBUG_LOW_ON) THEN
604:
605: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler', FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
606: END IF;
607:
608: -- Invoke table handler(ams_dm_source_PKG.Update_Row)
609: ams_dm_source_PKG.Update_Row(

Line 643: FND_MSG_PUB.Count_And_Get

639: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
640: END IF;
641:
642: -- Standard call to get message count and if count is 1, get message info.
643: FND_MSG_PUB.Count_And_Get
644: (p_count => x_msg_count,
645: p_data => x_msg_data
646: );
647: EXCEPTION

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

647: EXCEPTION
648:
649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
652: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
653: FND_MSG_PUB.add;
654: END IF;
655:

Line 653: FND_MSG_PUB.add;

649: WHEN AMS_Utility_PVT.resource_locked THEN
650: x_return_status := FND_API.g_ret_sts_error;
651: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
652: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
653: FND_MSG_PUB.add;
654: END IF;
655:
656: WHEN FND_API.G_EXC_ERROR THEN
657: ROLLBACK TO UPDATE_source_PVT;

Line 660: FND_MSG_PUB.Count_And_Get (

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

Line 670: FND_MSG_PUB.Count_And_Get (

666: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
667: ROLLBACK TO UPDATE_source_PVT;
668: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
669: -- Standard call to get message count and if count=1, get the message
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: );

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

675:
676: WHEN OTHERS THEN
677: ROLLBACK TO UPDATE_source_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
680: THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
682: END IF;
683: -- Standard call to get message count and if count=1, get the message

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

677: ROLLBACK TO UPDATE_source_PVT;
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
679: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
680: THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
682: END IF;
683: -- Standard call to get message count and if count=1, get the message
684: FND_MSG_PUB.Count_And_Get (
685: p_encoded => FND_API.G_FALSE,

Line 684: FND_MSG_PUB.Count_And_Get (

680: THEN
681: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
682: END IF;
683: -- Standard call to get message count and if count=1, get the message
684: FND_MSG_PUB.Count_And_Get (
685: p_encoded => FND_API.G_FALSE,
686: p_count => x_msg_count,
687: p_data => x_msg_data
688: );

Line 729: FND_MSG_PUB.initialize;

725:
726: -- Initialize message list if p_init_msg_list is set to TRUE.
727: IF FND_API.to_Boolean( p_init_msg_list )
728: THEN
729: FND_MSG_PUB.initialize;
730: END IF;
731:
732: -- Debug Message
733: IF (AMS_DEBUG_HIGH_ON) THEN

Line 799: FND_MSG_PUB.Count_And_Get

795: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
796: END IF;
797:
798: -- Standard call to get message count and if count is 1, get message info.
799: FND_MSG_PUB.Count_And_Get
800: (p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803: ELSE

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

800: (p_count => x_msg_count,
801: p_data => x_msg_data
802: );
803: ELSE
804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
805: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
806: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
807: FND_MSG_PUB.ADD;
808: END IF;

Line 807: FND_MSG_PUB.ADD;

803: ELSE
804: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
805: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
806: FND_MESSAGE.Set_Token('INFO', 'dm_source', FALSE);
807: FND_MSG_PUB.ADD;
808: END IF;
809: raise FND_API.G_EXC_ERROR;
810: END IF;
811:

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

812: EXCEPTION
813:
814: WHEN AMS_Utility_PVT.resource_locked THEN
815: x_return_status := FND_API.g_ret_sts_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
818: FND_MSG_PUB.add;
819: END IF;
820:

Line 818: FND_MSG_PUB.add;

814: WHEN AMS_Utility_PVT.resource_locked THEN
815: x_return_status := FND_API.g_ret_sts_error;
816: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
817: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
818: FND_MSG_PUB.add;
819: END IF;
820:
821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO DELETE_source_PVT;

Line 825: FND_MSG_PUB.Count_And_Get (

821: WHEN FND_API.G_EXC_ERROR THEN
822: ROLLBACK TO DELETE_source_PVT;
823: x_return_status := FND_API.G_RET_STS_ERROR;
824: -- Standard call to get message count and if count=1, get the message
825: FND_MSG_PUB.Count_And_Get (
826: p_encoded => FND_API.G_FALSE,
827: p_count => x_msg_count,
828: p_data => x_msg_data
829: );

Line 835: FND_MSG_PUB.Count_And_Get (

831: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
832: ROLLBACK TO DELETE_source_PVT;
833: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
834: -- Standard call to get message count and if count=1, get the message
835: FND_MSG_PUB.Count_And_Get (
836: p_encoded => FND_API.G_FALSE,
837: p_count => x_msg_count,
838: p_data => x_msg_data
839: );

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

840:
841: WHEN OTHERS THEN
842: ROLLBACK TO DELETE_source_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
845: THEN
846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;
848: -- Standard call to get message count and if count=1, get the message

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

842: ROLLBACK TO DELETE_source_PVT;
843: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
844: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
845: THEN
846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;
848: -- Standard call to get message count and if count=1, get the message
849: FND_MSG_PUB.Count_And_Get (
850: p_encoded => FND_API.G_FALSE,

Line 849: FND_MSG_PUB.Count_And_Get (

845: THEN
846: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
847: END IF;
848: -- Standard call to get message count and if count=1, get the message
849: FND_MSG_PUB.Count_And_Get (
850: p_encoded => FND_API.G_FALSE,
851: p_count => x_msg_count,
852: p_data => x_msg_data
853: );

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

880: );
881: END IF;
882:
883: IF l_valid_flag = FND_API.g_false THEN
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');
886: FND_MSG_PUB.add;
887: END IF;
888: x_return_status := FND_API.g_ret_sts_error;

Line 886: FND_MSG_PUB.add;

882:
883: IF l_valid_flag = FND_API.g_false THEN
884: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
885: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_ID_DUPLICATE');
886: FND_MSG_PUB.add;
887: END IF;
888: x_return_status := FND_API.g_ret_sts_error;
889: END IF;
890:

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

904: x_return_status := FND_API.g_ret_sts_success;
905:
906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
907: IF p_source_rec.ARC_USED_FOR_OBJECT = FND_API.g_miss_char OR p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;

Line 910: FND_MSG_PUB.add;

906: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
907: IF p_source_rec.ARC_USED_FOR_OBJECT = FND_API.g_miss_char OR p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
908: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
909: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
910: FND_MSG_PUB.add;
911: END IF;
912: x_return_status := FND_API.g_ret_sts_error;
913: END IF;
914:

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

913: END IF;
914:
915:
916: IF p_source_rec.USED_FOR_OBJECT_ID = FND_API.g_miss_num OR p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
918: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
919: FND_MSG_PUB.add;
920: END IF;
921: x_return_status := FND_API.g_ret_sts_error;

Line 919: FND_MSG_PUB.add;

915:
916: IF p_source_rec.USED_FOR_OBJECT_ID = FND_API.g_miss_num OR p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN
917: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
918: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
919: FND_MSG_PUB.add;
920: END IF;
921: x_return_status := FND_API.g_ret_sts_error;
922: END IF;
923:

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

922: END IF;
923:
924:
925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
928: FND_MSG_PUB.add;
929: END IF;
930: x_return_status := FND_API.g_ret_sts_error;

Line 928: FND_MSG_PUB.add;

924:
925: IF p_source_rec.PARTY_ID = FND_API.g_miss_num OR p_source_rec.PARTY_ID IS NULL THEN
926: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
927: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
928: FND_MSG_PUB.add;
929: END IF;
930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932: ELSE -- update mode

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

930: x_return_status := FND_API.g_ret_sts_error;
931: END IF;
932: ELSE -- update mode
933: IF p_source_rec.SOURCE_ID IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_SOURCE_ID');
936: FND_MSG_PUB.add;
937: END IF;
938: x_return_status := FND_API.g_ret_sts_error;

Line 936: FND_MSG_PUB.add;

932: ELSE -- update mode
933: IF p_source_rec.SOURCE_ID IS NULL THEN
934: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
935: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_SOURCE_ID');
936: FND_MSG_PUB.add;
937: END IF;
938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:

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

938: x_return_status := FND_API.g_ret_sts_error;
939: END IF;
940:
941: IF p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
943: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
944: FND_MSG_PUB.add;
945: END IF;
946: x_return_status := FND_API.g_ret_sts_error;

Line 944: FND_MSG_PUB.add;

940:
941: IF p_source_rec.ARC_USED_FOR_OBJECT IS NULL THEN
942: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
943: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_ARC_USED_FOR_OBJ');
944: FND_MSG_PUB.add;
945: END IF;
946: x_return_status := FND_API.g_ret_sts_error;
947: END IF;
948:

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

947: END IF;
948:
949:
950: IF p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN
951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
952: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
953: FND_MSG_PUB.add;
954: END IF;
955: x_return_status := FND_API.g_ret_sts_error;

Line 953: FND_MSG_PUB.add;

949:
950: IF p_source_rec.USED_FOR_OBJECT_ID IS NULL THEN
951: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
952: FND_MESSAGE.set_name('AMS', 'AMS_DM_SRC_NO_USED_FOR_OBJ_ID');
953: FND_MSG_PUB.add;
954: END IF;
955: x_return_status := FND_API.g_ret_sts_error;
956: END IF;
957:

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

956: END IF;
957:
958:
959: IF p_source_rec.PARTY_ID IS NULL THEN
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
962: FND_MSG_PUB.add;
963: END IF;
964: x_return_status := FND_API.g_ret_sts_error;

Line 962: FND_MSG_PUB.add;

958:
959: IF p_source_rec.PARTY_ID IS NULL THEN
960: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
961: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_NO_PARTY_ID');
962: FND_MSG_PUB.add;
963: END IF;
964: x_return_status := FND_API.g_ret_sts_error;
965: END IF;
966: END IF;

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

987: 'model_id',
988: p_source_rec.used_for_object_id
989: ) = FND_API.g_false
990: THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;

Line 993: FND_MSG_PUB.add;

989: ) = FND_API.g_false
990: THEN
991: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
992: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_MODEL_ID');
993: FND_MSG_PUB.add;
994: END IF;
995: x_return_status := FND_API.g_ret_sts_error;
996: END IF;
997: END IF;

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

1002: 'score_id',
1003: p_source_rec.used_for_object_id
1004: ) = FND_API.g_false
1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: x_return_status := FND_API.g_ret_sts_error;

Line 1008: FND_MSG_PUB.add;

1004: ) = FND_API.g_false
1005: THEN
1006: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1007: FND_MESSAGE.set_name('AMS', 'AMS_DM_SOURCE_BAD_SCORE_ID');
1008: FND_MSG_PUB.add;
1009: END IF;
1010: x_return_status := FND_API.g_ret_sts_error;
1011: END IF;
1012: END IF;

Line 1103: FND_MSG_PUB.initialize;

1099:
1100: -- Initialize message list if p_init_msg_list is set to TRUE.
1101: IF FND_API.to_Boolean( p_init_msg_list )
1102: THEN
1103: FND_MSG_PUB.initialize;
1104: END IF;
1105: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
1106: Check_source_Items(
1107: p_source_rec => p_source_rec,

Line 1159: FND_MSG_PUB.Count_And_Get

1155: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1156: END IF;
1157:
1158: -- Standard call to get message count and if count is 1, get message info.
1159: FND_MSG_PUB.Count_And_Get
1160: (p_count => x_msg_count,
1161: p_data => x_msg_data
1162: );
1163: EXCEPTION

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

1163: EXCEPTION
1164:
1165: WHEN AMS_Utility_PVT.resource_locked THEN
1166: x_return_status := FND_API.g_ret_sts_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1168: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1169: FND_MSG_PUB.add;
1170: END IF;
1171:

Line 1169: FND_MSG_PUB.add;

1165: WHEN AMS_Utility_PVT.resource_locked THEN
1166: x_return_status := FND_API.g_ret_sts_error;
1167: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1168: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1169: FND_MSG_PUB.add;
1170: END IF;
1171:
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1175: FND_MSG_PUB.Count_And_Get (

1171:
1172: WHEN FND_API.G_EXC_ERROR THEN
1173: x_return_status := FND_API.G_RET_STS_ERROR;
1174: -- Standard call to get message count and if count=1, get the message
1175: FND_MSG_PUB.Count_And_Get (
1176: p_encoded => FND_API.G_FALSE,
1177: p_count => x_msg_count,
1178: p_data => x_msg_data
1179: );

Line 1184: FND_MSG_PUB.Count_And_Get (

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

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

1188: );
1189:
1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1195: END IF;
1196: -- Standard call to get message count and if count=1, get the message

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

1190: WHEN OTHERS THEN
1191: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1192: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1193: THEN
1194: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1195: END IF;
1196: -- Standard call to get message count and if count=1, get the message
1197: FND_MSG_PUB.Count_And_Get (
1198: p_encoded => FND_API.G_FALSE,

Line 1197: FND_MSG_PUB.Count_And_Get (

1193: THEN
1194: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1195: END IF;
1196: -- Standard call to get message count and if count=1, get the message
1197: FND_MSG_PUB.Count_And_Get (
1198: p_encoded => FND_API.G_FALSE,
1199: p_count => x_msg_count,
1200: p_data => x_msg_data
1201: );

Line 1218: FND_MSG_PUB.initialize;

1214: BEGIN
1215: -- Initialize message list if p_init_msg_list is set to TRUE.
1216: IF FND_API.to_Boolean( p_init_msg_list )
1217: THEN
1218: FND_MSG_PUB.initialize;
1219: END IF;
1220:
1221: -- Initialize API return status to SUCCESS
1222: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1235: FND_MSG_PUB.Count_And_Get

1231:
1232: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1233: END IF;
1234: -- Standard call to get message count and if count is 1, get message info.
1235: FND_MSG_PUB.Count_And_Get
1236: (p_count => x_msg_count,
1237: p_data => x_msg_data
1238: );
1239: END Validate_source_rec;

Line 1272: FND_MSG_PUB.initialize;

1268: x_return_status := FND_API.G_RET_STS_SUCCESS;
1269:
1270: -- Initialize message list if p_init_msg_list is set to TRUE.
1271: IF FND_API.to_Boolean (p_init_msg_list) THEN
1272: FND_MSG_PUB.initialize;
1273: END IF;
1274:
1275: UPDATE ams_dm_source
1276: SET decile = (10 - FLOOR (LEAST (99, continuous_score)/10))

Line 1295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

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

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

1292: WHEN OTHERS THEN
1293: ROLLBACK TO bin_probability;
1294: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1297: END IF;
1298: -- Standard call to get message count and if count=1, get the message
1299: FND_MSG_PUB.Count_And_Get (
1300: p_encoded => FND_API.G_FALSE,

Line 1299: FND_MSG_PUB.Count_And_Get (

1295: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1296: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1297: END IF;
1298: -- Standard call to get message count and if count=1, get the message
1299: FND_MSG_PUB.Count_And_Get (
1300: p_encoded => FND_API.G_FALSE,
1301: p_count => x_msg_count,
1302: p_data => x_msg_data
1303: );

Line 1376: FND_MSG_PUB.initialize;

1372: END IF;
1373:
1374: -- Initialize message list if p_init_msg_list is set to TRUE.
1375: IF FND_API.to_Boolean (p_init_msg_list) THEN
1376: FND_MSG_PUB.initialize;
1377: END IF;
1378:
1379: -- Initialize API return status to SUCCESS
1380: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1447: EXCEPTION
1448: WHEN OTHERS THEN
1449: ROLLBACK TO process_scores;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1453: END IF;
1454: -- Standard call to get message count and if count=1, get the message
1455: FND_MSG_PUB.Count_And_Get (

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

1448: WHEN OTHERS THEN
1449: ROLLBACK TO process_scores;
1450: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1453: END IF;
1454: -- Standard call to get message count and if count=1, get the message
1455: FND_MSG_PUB.Count_And_Get (
1456: p_encoded => FND_API.G_FALSE,

Line 1455: FND_MSG_PUB.Count_And_Get (

1451: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1452: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1453: END IF;
1454: -- Standard call to get message count and if count=1, get the message
1455: FND_MSG_PUB.Count_And_Get (
1456: p_encoded => FND_API.G_FALSE,
1457: p_count => x_msg_count,
1458: p_data => x_msg_data
1459: );

Line 1617: FND_MSG_PUB.initialize;

1613: END IF;
1614:
1615: -- Initialize message list if p_init_msg_list is set to TRUE.
1616: IF FND_API.to_Boolean (p_init_msg_list) THEN
1617: FND_MSG_PUB.initialize;
1618: END IF;
1619:
1620: -- Initialize API return status to SUCCESS
1621: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1765: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN

1761: p_arc_log_used_by => p_object_type,
1762: p_log_used_by_id => p_object_id,
1763: p_msg_data => ' Exception in generate_odm_input_views status ' || x_return_status
1764: );
1765: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1766: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1767: END IF;
1768: -- Standard call to get message count and if count=1, get the message
1769: FND_MSG_PUB.Count_And_Get (

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

1762: p_log_used_by_id => p_object_id,
1763: p_msg_data => ' Exception in generate_odm_input_views status ' || x_return_status
1764: );
1765: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1766: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1767: END IF;
1768: -- Standard call to get message count and if count=1, get the message
1769: FND_MSG_PUB.Count_And_Get (
1770: p_encoded => FND_API.G_FALSE,

Line 1769: FND_MSG_PUB.Count_And_Get (

1765: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
1766: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1767: END IF;
1768: -- Standard call to get message count and if count=1, get the message
1769: FND_MSG_PUB.Count_And_Get (
1770: p_encoded => FND_API.G_FALSE,
1771: p_count => x_msg_count,
1772: p_data => x_msg_data
1773: );