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_DM_MODEL_PVT dependencies on FND_MSG_PUB

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

149: -- model status.
150: --
151: -- History
152: -- 21-Feb-2001 choang Created.
153: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
154: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
155: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
156:
157: PROCEDURE check_access (

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

150: --
151: -- History
152: -- 21-Feb-2001 choang Created.
153: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
154: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
155: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
156:
157: PROCEDURE check_access (
158: p_model_rec IN dm_model_rec_type,

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

151: -- History
152: -- 21-Feb-2001 choang Created.
153: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
154: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
155: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
156:
157: PROCEDURE check_access (
158: p_model_rec IN dm_model_rec_type,
159: p_validation_mode IN VARCHAR2,

Line 304: FND_MSG_PUB.initialize;

300:
301: -- Initialize message list if p_init_msg_list is set to TRUE.
302: IF FND_API.to_Boolean( p_init_msg_list )
303: THEN
304: FND_MSG_PUB.initialize;
305: END IF;
306:
307: OPEN c_status_check;
308: FETCH c_status_check INTO l_status_check;

Line 322: FND_MSG_PUB.Count_And_Get

318: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
319: END IF;
320:
321: -- Standard call to get message count and if count is 1, get message info.
322: FND_MSG_PUB.Count_And_Get
323: (p_count => x_msg_count,
324: p_data => x_msg_data
325: );
326: EXCEPTION

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

326: EXCEPTION
327:
328: WHEN AMS_Utility_PVT.resource_locked THEN
329: x_return_status := FND_API.g_ret_sts_error;
330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
331: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
332: FND_MSG_PUB.add;
333: END IF;
334:

Line 332: FND_MSG_PUB.add;

328: WHEN AMS_Utility_PVT.resource_locked THEN
329: x_return_status := FND_API.g_ret_sts_error;
330: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
331: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
332: FND_MSG_PUB.add;
333: END IF;
334:
335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO VALIDATE_NEXT_STATUS;

Line 339: FND_MSG_PUB.Count_And_Get (

335: WHEN FND_API.G_EXC_ERROR THEN
336: ROLLBACK TO VALIDATE_NEXT_STATUS;
337: x_return_status := FND_API.G_RET_STS_ERROR;
338: -- Standard call to get message count and if count=1, get the message
339: FND_MSG_PUB.Count_And_Get (
340: p_encoded => FND_API.G_FALSE,
341: p_count => x_msg_count,
342: p_data => x_msg_data
343: );

Line 349: FND_MSG_PUB.Count_And_Get (

345: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
346: ROLLBACK TO VALIDATE_NEXT_STATUS;
347: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
348: -- Standard call to get message count and if count=1, get the message
349: FND_MSG_PUB.Count_And_Get (
350: p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => x_msg_data
353: );

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

354:
355: WHEN OTHERS THEN
356: ROLLBACK TO VALIDATE_NEXT_STATUS;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
359: THEN
360: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
361: END IF;
362: -- Standard call to get message count and if count=1, get the message

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

356: ROLLBACK TO VALIDATE_NEXT_STATUS;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
359: THEN
360: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
361: END IF;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,

Line 363: FND_MSG_PUB.Count_And_Get (

359: THEN
360: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
361: END IF;
362: -- Standard call to get message count and if count=1, get the message
363: FND_MSG_PUB.Count_And_Get (
364: p_encoded => FND_API.G_FALSE,
365: p_count => x_msg_count,
366: p_data => x_msg_data
367: );

Line 410: FND_MSG_PUB.initialize;

406:
407: -- Initialize message list if p_init_msg_list is set to TRUE.
408: IF FND_API.to_Boolean( p_init_msg_list )
409: THEN
410: FND_MSG_PUB.initialize;
411: END IF;
412:
413: -- Standard call to check for call compatibility.
414: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

434: FETCH c_dm_model_b INTO l_MODEL_ID;
435:
436: IF (c_dm_model_b%NOTFOUND) THEN
437: CLOSE c_dm_model_b;
438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
439: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
440: FND_MSG_PUB.add;
441: END IF;
442: RAISE FND_API.g_exc_error;

Line 440: FND_MSG_PUB.add;

436: IF (c_dm_model_b%NOTFOUND) THEN
437: CLOSE c_dm_model_b;
438: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
439: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
440: FND_MSG_PUB.add;
441: END IF;
442: RAISE FND_API.g_exc_error;
443: END IF;
444:

Line 448: FND_MSG_PUB.count_and_get(

444:
445: CLOSE c_dm_model_b;
446:
447: -------------------- finish --------------------------
448: FND_MSG_PUB.count_and_get(
449: p_encoded => FND_API.g_false,
450: p_count => x_msg_count,
451: p_data => x_msg_data);
452: IF (AMS_DEBUG_HIGH_ON) THEN

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

456: EXCEPTION
457:
458: WHEN AMS_Utility_PVT.resource_locked THEN
459: x_return_status := FND_API.g_ret_sts_error;
460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
461: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
462: FND_MSG_PUB.add;
463: END IF;
464:

Line 462: FND_MSG_PUB.add;

458: WHEN AMS_Utility_PVT.resource_locked THEN
459: x_return_status := FND_API.g_ret_sts_error;
460: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
461: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
462: FND_MSG_PUB.add;
463: END IF;
464:
465: WHEN FND_API.G_EXC_ERROR THEN
466: ROLLBACK TO LOCK_DM_MODEL_PVT;

Line 469: FND_MSG_PUB.Count_And_Get (

465: WHEN FND_API.G_EXC_ERROR THEN
466: ROLLBACK TO LOCK_DM_MODEL_PVT;
467: x_return_status := FND_API.G_RET_STS_ERROR;
468: -- Standard call to get message count and if count=1, get the message
469: FND_MSG_PUB.Count_And_Get (
470: p_encoded => FND_API.G_FALSE,
471: p_count => x_msg_count,
472: p_data => x_msg_data
473: );

Line 479: FND_MSG_PUB.Count_And_Get (

475: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
476: ROLLBACK TO LOCK_DM_MODEL_PVT;
477: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
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 488: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

484:
485: WHEN OTHERS THEN
486: ROLLBACK TO LOCK_DM_MODEL_PVT;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
491: END IF;
492: -- Standard call to get message count and if count=1, get the message

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

486: ROLLBACK TO LOCK_DM_MODEL_PVT;
487: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
488: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
489: THEN
490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
491: END IF;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,

Line 493: FND_MSG_PUB.Count_And_Get (

489: THEN
490: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
491: END IF;
492: -- Standard call to get message count and if count=1, get the message
493: FND_MSG_PUB.Count_And_Get (
494: p_encoded => FND_API.G_FALSE,
495: p_count => x_msg_count,
496: p_data => x_msg_data
497: );

Line 567: FND_MSG_PUB.initialize;

563:
564: -- Initialize message list if p_init_msg_list is set to TRUE.
565: IF FND_API.to_Boolean( p_init_msg_list )
566: THEN
567: FND_MSG_PUB.initialize;
568: END IF;
569:
570: -- Initialize API return status to SUCCESS
571: x_return_status := FND_API.G_RET_STS_SUCCESS;

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

579: -- ******************************************************************
580: -- Validate Environment
581: -- ******************************************************************
582: IF FND_GLOBAL.User_Id IS NULL THEN
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
584: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
585: FND_MSG_PUB.ADD;
586: END IF;
587: RAISE FND_API.G_EXC_ERROR;

Line 585: FND_MSG_PUB.ADD;

581: -- ******************************************************************
582: IF FND_GLOBAL.User_Id IS NULL THEN
583: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
584: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
585: FND_MSG_PUB.ADD;
586: END IF;
587: RAISE FND_API.G_EXC_ERROR;
588: END IF;
589:

Line 773: FND_MSG_PUB.Count_And_Get

769: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
770: END IF;
771:
772: -- Standard call to get message count and if count is 1, get message info.
773: FND_MSG_PUB.Count_And_Get
774: (p_count => x_msg_count,
775: p_data => x_msg_data
776: );
777: EXCEPTION

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

777: EXCEPTION
778:
779: WHEN AMS_Utility_PVT.resource_locked THEN
780: x_return_status := FND_API.g_ret_sts_error;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
782: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
783: FND_MSG_PUB.add;
784: END IF;
785:

Line 783: FND_MSG_PUB.add;

779: WHEN AMS_Utility_PVT.resource_locked THEN
780: x_return_status := FND_API.g_ret_sts_error;
781: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
782: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
783: FND_MSG_PUB.add;
784: END IF;
785:
786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO CREATE_DM_MODEL_PVT;

Line 790: FND_MSG_PUB.Count_And_Get (

786: WHEN FND_API.G_EXC_ERROR THEN
787: ROLLBACK TO CREATE_DM_MODEL_PVT;
788: x_return_status := FND_API.G_RET_STS_ERROR;
789: -- Standard call to get message count and if count=1, get the message
790: FND_MSG_PUB.Count_And_Get (
791: p_encoded => FND_API.G_FALSE,
792: p_count => x_msg_count,
793: p_data => x_msg_data
794: );

Line 800: FND_MSG_PUB.Count_And_Get (

796: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
797: ROLLBACK TO CREATE_DM_MODEL_PVT;
798: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
799: -- Standard call to get message count and if count=1, get the message
800: FND_MSG_PUB.Count_And_Get (
801: p_encoded => FND_API.G_FALSE,
802: p_count => x_msg_count,
803: p_data => x_msg_data
804: );

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

805:
806: WHEN OTHERS THEN
807: ROLLBACK TO CREATE_DM_MODEL_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
812: END IF;
813: -- Standard call to get message count and if count=1, get the message

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

807: ROLLBACK TO CREATE_DM_MODEL_PVT;
808: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
809: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
810: THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
812: END IF;
813: -- Standard call to get message count and if count=1, get the message
814: FND_MSG_PUB.Count_And_Get (
815: p_encoded => FND_API.G_FALSE,

Line 814: FND_MSG_PUB.Count_And_Get (

810: THEN
811: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
812: END IF;
813: -- Standard call to get message count and if count=1, get the message
814: FND_MSG_PUB.Count_And_Get (
815: p_encoded => FND_API.G_FALSE,
816: p_count => x_msg_count,
817: p_data => x_msg_data
818: );

Line 882: FND_MSG_PUB.initialize;

878:
879: -- Initialize message list if p_init_msg_list is set to TRUE.
880: IF FND_API.to_Boolean( p_init_msg_list )
881: THEN
882: FND_MSG_PUB.initialize;
883: END IF;
884:
885: -- Debug Message
886: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1393: FND_MSG_PUB.Count_And_Get

1389: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1390: END IF;
1391:
1392: -- Standard call to get message count and if count is 1, get message info.
1393: FND_MSG_PUB.Count_And_Get
1394: (p_count => x_msg_count,
1395: p_data => x_msg_data
1396: );
1397:

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

1403: EXCEPTION
1404:
1405: WHEN AMS_Utility_PVT.resource_locked THEN
1406: x_return_status := FND_API.g_ret_sts_error;
1407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1408: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1409: FND_MSG_PUB.add;
1410: END IF;
1411:

Line 1409: FND_MSG_PUB.add;

1405: WHEN AMS_Utility_PVT.resource_locked THEN
1406: x_return_status := FND_API.g_ret_sts_error;
1407: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1408: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1409: FND_MSG_PUB.add;
1410: END IF;
1411:
1412: WHEN FND_API.G_EXC_ERROR THEN
1413: ROLLBACK TO UPDATE_DM_MODEL_PVT;

Line 1416: FND_MSG_PUB.Count_And_Get (

1412: WHEN FND_API.G_EXC_ERROR THEN
1413: ROLLBACK TO UPDATE_DM_MODEL_PVT;
1414: x_return_status := FND_API.G_RET_STS_ERROR;
1415: -- Standard call to get message count and if count=1, get the message
1416: FND_MSG_PUB.Count_And_Get (
1417: p_encoded => FND_API.G_FALSE,
1418: p_count => x_msg_count,
1419: p_data => x_msg_data
1420: );

Line 1426: FND_MSG_PUB.Count_And_Get (

1422: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1423: ROLLBACK TO UPDATE_DM_MODEL_PVT;
1424: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1425: -- Standard call to get message count and if count=1, get the message
1426: FND_MSG_PUB.Count_And_Get (
1427: p_encoded => FND_API.G_FALSE,
1428: p_count => x_msg_count,
1429: p_data => x_msg_data
1430: );

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

1431:
1432: WHEN OTHERS THEN
1433: ROLLBACK TO UPDATE_DM_MODEL_PVT;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message

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

1433: ROLLBACK TO UPDATE_DM_MODEL_PVT;
1434: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1435: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message
1440: FND_MSG_PUB.Count_And_Get (
1441: p_encoded => FND_API.G_FALSE,

Line 1440: FND_MSG_PUB.Count_And_Get (

1436: THEN
1437: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1438: END IF;
1439: -- Standard call to get message count and if count=1, get the message
1440: FND_MSG_PUB.Count_And_Get (
1441: p_encoded => FND_API.G_FALSE,
1442: p_count => x_msg_count,
1443: p_data => x_msg_data
1444: );

Line 1481: FND_MSG_PUB.initialize;

1477:
1478: -- Initialize message list if p_init_msg_list is set to TRUE.
1479: IF FND_API.to_Boolean( p_init_msg_list )
1480: THEN
1481: FND_MSG_PUB.initialize;
1482: END IF;
1483:
1484: -- Debug Message
1485: IF (AMS_DEBUG_HIGH_ON) THEN

Line 1530: FND_MSG_PUB.Count_And_Get

1526: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1527: END IF;
1528:
1529: -- Standard call to get message count and if count is 1, get message info.
1530: FND_MSG_PUB.Count_And_Get
1531: (p_count => x_msg_count,
1532: p_data => x_msg_data
1533: );
1534: EXCEPTION

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

1534: EXCEPTION
1535:
1536: WHEN AMS_Utility_PVT.resource_locked THEN
1537: x_return_status := FND_API.g_ret_sts_error;
1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1539: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1540: FND_MSG_PUB.add;
1541: END IF;
1542:

Line 1540: FND_MSG_PUB.add;

1536: WHEN AMS_Utility_PVT.resource_locked THEN
1537: x_return_status := FND_API.g_ret_sts_error;
1538: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1539: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1540: FND_MSG_PUB.add;
1541: END IF;
1542:
1543: WHEN FND_API.G_EXC_ERROR THEN
1544: ROLLBACK TO DELETE_DM_MODEL_PVT;

Line 1547: FND_MSG_PUB.Count_And_Get (

1543: WHEN FND_API.G_EXC_ERROR THEN
1544: ROLLBACK TO DELETE_DM_MODEL_PVT;
1545: x_return_status := FND_API.G_RET_STS_ERROR;
1546: -- Standard call to get message count and if count=1, get the message
1547: FND_MSG_PUB.Count_And_Get (
1548: p_encoded => FND_API.G_FALSE,
1549: p_count => x_msg_count,
1550: p_data => x_msg_data
1551: );

Line 1557: FND_MSG_PUB.Count_And_Get (

1553: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1554: ROLLBACK TO DELETE_DM_MODEL_PVT;
1555: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1556: -- Standard call to get message count and if count=1, get the message
1557: FND_MSG_PUB.Count_And_Get (
1558: p_encoded => FND_API.G_FALSE,
1559: p_count => x_msg_count,
1560: p_data => x_msg_data
1561: );

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

1562:
1563: WHEN OTHERS THEN
1564: ROLLBACK TO DELETE_DM_MODEL_PVT;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1569: END IF;
1570: -- Standard call to get message count and if count=1, get the message

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

1564: ROLLBACK TO DELETE_DM_MODEL_PVT;
1565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1566: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1569: END IF;
1570: -- Standard call to get message count and if count=1, get the message
1571: FND_MSG_PUB.Count_And_Get (
1572: p_encoded => FND_API.G_FALSE,

Line 1571: FND_MSG_PUB.Count_And_Get (

1567: THEN
1568: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1569: END IF;
1570: -- Standard call to get message count and if count=1, get the message
1571: FND_MSG_PUB.Count_And_Get (
1572: p_encoded => FND_API.G_FALSE,
1573: p_count => x_msg_count,
1574: p_data => x_msg_data
1575: );

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

1653: p_lookup_type => 'AMS_DM_MODEL_TYPE',
1654: p_lookup_code => p_dm_model_rec.model_type
1655: ) = FND_API.g_false
1656: THEN
1657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1658: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1659: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_model_rec.model_type);
1660: FND_MESSAGE.set_token ('COLUMN_NAME', 'MODEL_TYPE');
1661: FND_MSG_PUB.add;

Line 1661: FND_MSG_PUB.add;

1657: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1658: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1659: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_model_rec.model_type);
1660: FND_MESSAGE.set_token ('COLUMN_NAME', 'MODEL_TYPE');
1661: FND_MSG_PUB.add;
1662: END IF;
1663: x_return_status := FND_API.g_ret_sts_error;
1664: END IF;
1665: END IF;

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

1670: p_lookup_type => 'AMS_DM_MODEL_STATUS',
1671: p_lookup_code => p_dm_model_rec.status_code
1672: ) = FND_API.g_false
1673: THEN
1674: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1675: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1676: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_model_rec.status_code);
1677: FND_MESSAGE.set_token ('COLUMN_NAME', 'STATUS_CODE');
1678: FND_MSG_PUB.add;

Line 1678: FND_MSG_PUB.add;

1674: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1675: FND_MESSAGE.set_name('AMS', 'AMS_API_INVALID_LOOKUP');
1676: FND_MESSAGE.set_token ('LOOKUP_CODE', p_dm_model_rec.status_code);
1677: FND_MESSAGE.set_token ('COLUMN_NAME', 'STATUS_CODE');
1678: FND_MSG_PUB.add;
1679: END IF;
1680: x_return_status := FND_API.g_ret_sts_error;
1681: END IF;
1682: END IF;

Line 1694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1690: p_lookup_type => 'AMS_DM_TARGET_GROUP_TYPE',
1691: p_lookup_code => p_dm_model_rec.target_group_type
1692: ) = FND_API.g_false
1693: THEN
1694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1695: THEN
1696: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_BAD_TARGET_GROUP');
1697: FND_MSG_PUB.add;
1698: END IF;

Line 1697: FND_MSG_PUB.add;

1693: THEN
1694: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1695: THEN
1696: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_BAD_TARGET_GROUP');
1697: FND_MSG_PUB.add;
1698: END IF;
1699:
1700: x_return_status := FND_API.g_ret_sts_error;
1701: END IF;

Line 1749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)

1745: ''' AND MODEL_ID <> ' || p_dm_model_rec.model_id);
1746: END IF;
1747:
1748: IF l_valid_flag = FND_API.g_false THEN
1749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_DUPLICATE_ID');
1752: FND_MSG_PUB.add;
1753: END IF;

Line 1752: FND_MSG_PUB.add;

1748: IF l_valid_flag = FND_API.g_false THEN
1749: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1750: THEN
1751: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_DUPLICATE_ID');
1752: FND_MSG_PUB.add;
1753: END IF;
1754: x_return_status := FND_API.g_ret_sts_error;
1755: END IF;
1756:

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

1765: CLOSE c_model_name_updt ;
1766: END IF;
1767:
1768: IF l_dummy IS NOT NULL THEN
1769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1770: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_DUPLICATE_NAME');
1771: FND_MSG_PUB.add;
1772: END IF;
1773: x_return_status := FND_API.g_ret_sts_error;

Line 1771: FND_MSG_PUB.add;

1767:
1768: IF l_dummy IS NOT NULL THEN
1769: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1770: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_DUPLICATE_NAME');
1771: FND_MSG_PUB.add;
1772: END IF;
1773: x_return_status := FND_API.g_ret_sts_error;
1774: END IF;
1775:

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

1801: ams_utility_pvt.debug_message('Private API:check_dm_model_req_items for update');
1802: END IF;
1803:
1804: IF (p_dm_model_rec.model_id IS NULL OR p_dm_model_rec.model_id = FND_API.G_MISS_NUM) THEN
1805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1806: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_MODEL_ID');
1807: FND_MSG_PUB.add;
1808: END IF;
1809: x_return_status := FND_API.g_ret_sts_error;

Line 1807: FND_MSG_PUB.add;

1803:
1804: IF (p_dm_model_rec.model_id IS NULL OR p_dm_model_rec.model_id = FND_API.G_MISS_NUM) THEN
1805: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1806: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_MODEL_ID');
1807: FND_MSG_PUB.add;
1808: END IF;
1809: x_return_status := FND_API.g_ret_sts_error;
1810: END IF;
1811:

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

1814: x_return_status := FND_API.g_ret_sts_error;
1815: END IF;
1816:
1817: IF p_dm_model_rec.model_type IS NULL THEN
1818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1819: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_MODEL_TYPE');
1820: FND_MSG_PUB.add;
1821: END IF;
1822: x_return_status := FND_API.g_ret_sts_error;

Line 1820: FND_MSG_PUB.add;

1816:
1817: IF p_dm_model_rec.model_type IS NULL THEN
1818: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1819: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_MODEL_TYPE');
1820: FND_MSG_PUB.add;
1821: END IF;
1822: x_return_status := FND_API.g_ret_sts_error;
1823: END IF;
1824:

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

1822: x_return_status := FND_API.g_ret_sts_error;
1823: END IF;
1824:
1825: IF p_dm_model_rec.user_status_id IS NULL THEN
1826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1827: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_USER_STATUS_ID');
1828: FND_MSG_PUB.add;
1829: END IF;
1830: x_return_status := FND_API.g_ret_sts_error;

Line 1828: FND_MSG_PUB.add;

1824:
1825: IF p_dm_model_rec.user_status_id IS NULL THEN
1826: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1827: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_USER_STATUS_ID');
1828: FND_MSG_PUB.add;
1829: END IF;
1830: x_return_status := FND_API.g_ret_sts_error;
1831: END IF;
1832:

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

1830: x_return_status := FND_API.g_ret_sts_error;
1831: END IF;
1832:
1833: IF p_dm_model_rec.status_code IS NULL THEN
1834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1835: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_STATUS_CODE');
1836: FND_MSG_PUB.add;
1837: END IF;
1838: x_return_status := FND_API.g_ret_sts_error;

Line 1836: FND_MSG_PUB.add;

1832:
1833: IF p_dm_model_rec.status_code IS NULL THEN
1834: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1835: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_STATUS_CODE');
1836: FND_MSG_PUB.add;
1837: END IF;
1838: x_return_status := FND_API.g_ret_sts_error;
1839: END IF;
1840:

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

1838: x_return_status := FND_API.g_ret_sts_error;
1839: END IF;
1840:
1841: IF p_dm_model_rec.status_date IS NULL THEN
1842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1843: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_STATUS_DATE');
1844: FND_MSG_PUB.add;
1845: END IF;
1846: x_return_status := FND_API.g_ret_sts_error;

Line 1844: FND_MSG_PUB.add;

1840:
1841: IF p_dm_model_rec.status_date IS NULL THEN
1842: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1843: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_STATUS_DATE');
1844: FND_MSG_PUB.add;
1845: END IF;
1846: x_return_status := FND_API.g_ret_sts_error;
1847: END IF;
1848:

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

1846: x_return_status := FND_API.g_ret_sts_error;
1847: END IF;
1848:
1849: IF p_dm_model_rec.owner_user_id IS NULL THEN
1850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1851: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_OWNER_USER_ID');
1852: FND_MSG_PUB.add;
1853: END IF;
1854: x_return_status := FND_API.g_ret_sts_error;

Line 1852: FND_MSG_PUB.add;

1848:
1849: IF p_dm_model_rec.owner_user_id IS NULL THEN
1850: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1851: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_OWNER_USER_ID');
1852: FND_MSG_PUB.add;
1853: END IF;
1854: x_return_status := FND_API.g_ret_sts_error;
1855: END IF;
1856:

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

1855: END IF;
1856:
1857: /*** choang - 05-jun-2002 - OBSELETED
1858: IF p_dm_model_rec.target_group_type IS NULL THEN
1859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1860: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_TARGET_GROUP_TYPE');
1861: FND_MSG_PUB.add;
1862: END IF;
1863: x_return_status := FND_API.g_ret_sts_error;

Line 1861: FND_MSG_PUB.add;

1857: /*** choang - 05-jun-2002 - OBSELETED
1858: IF p_dm_model_rec.target_group_type IS NULL THEN
1859: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1860: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_TARGET_GROUP_TYPE');
1861: FND_MSG_PUB.add;
1862: END IF;
1863: x_return_status := FND_API.g_ret_sts_error;
1864: END IF;
1865: ***/

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

1864: END IF;
1865: ***/
1866:
1867: IF p_dm_model_rec.RESULTS_FLAG IS NULL THEN
1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1869: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_RESULTS_FLAG');
1870: FND_MSG_PUB.add;
1871: END IF;
1872: x_return_status := FND_API.g_ret_sts_error;

Line 1870: FND_MSG_PUB.add;

1866:
1867: IF p_dm_model_rec.RESULTS_FLAG IS NULL THEN
1868: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1869: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_RESULTS_FLAG');
1870: FND_MSG_PUB.add;
1871: END IF;
1872: x_return_status := FND_API.g_ret_sts_error;
1873: END IF;
1874:

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

1872: x_return_status := FND_API.g_ret_sts_error;
1873: END IF;
1874:
1875: IF p_dm_model_rec.LOGS_FLAG IS NULL THEN
1876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1877: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_LOGS_FLAG');
1878: FND_MSG_PUB.add;
1879: END IF;
1880: x_return_status := FND_API.g_ret_sts_error;

Line 1878: FND_MSG_PUB.add;

1874:
1875: IF p_dm_model_rec.LOGS_FLAG IS NULL THEN
1876: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1877: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_LOGS_FLAG');
1878: FND_MSG_PUB.add;
1879: END IF;
1880: x_return_status := FND_API.g_ret_sts_error;
1881: END IF;
1882:

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

1881: END IF;
1882:
1883:
1884: IF p_dm_model_rec.row_selection_type IS NULL THEN
1885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1886: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_ROW_SELECT_TYPE');
1887: FND_MSG_PUB.add;
1888: END IF;
1889: x_return_status := FND_API.g_ret_sts_error;

Line 1887: FND_MSG_PUB.add;

1883:
1884: IF p_dm_model_rec.row_selection_type IS NULL THEN
1885: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1886: FND_MESSAGE.set_name('AMS', 'AMS_MODEL_NO_ROW_SELECT_TYPE');
1887: FND_MSG_PUB.add;
1888: END IF;
1889: x_return_status := FND_API.g_ret_sts_error;
1890: RETURN;
1891: END IF;

Line 2093: FND_MSG_PUB.initialize;

2089: l_reference_rec c_reference%ROWTYPE;
2090: BEGIN
2091: -- Initialize message list if p_init_msg_list is set to TRUE.
2092: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2093: FND_MSG_PUB.initialize;
2094: END IF;
2095:
2096: -- Initialize API return status to SUCCESS
2097: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2221: FND_MSG_PUB.Count_And_Get

2217: IF (AMS_DEBUG_HIGH_ON) THEN
2218: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
2219: END IF;
2220: -- Standard call to get message count and if count is 1, get message info.
2221: FND_MSG_PUB.Count_And_Get
2222: (p_count => x_msg_count,
2223: p_data => x_msg_data
2224: );
2225: END Validate_dm_model_rec;

Line 2568: FND_MSG_PUB.initialize;

2564:
2565: -- Initialize message list if p_init_msg_list is set to TRUE.
2566: IF FND_API.to_Boolean( p_init_msg_list )
2567: THEN
2568: FND_MSG_PUB.initialize;
2569: END IF;
2570: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2571: IF (AMS_DEBUG_HIGH_ON) THEN
2572:

Line 2610: FND_MSG_PUB.Count_And_Get

2606: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2607: END IF;
2608:
2609: -- Standard call to get message count and if count is 1, get message info.
2610: FND_MSG_PUB.Count_And_Get
2611: (p_count => x_msg_count,
2612: p_data => x_msg_data
2613: );
2614: EXCEPTION

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

2613: );
2614: EXCEPTION
2615: WHEN AMS_Utility_PVT.resource_locked THEN
2616: x_return_status := FND_API.g_ret_sts_error;
2617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2618: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2619: FND_MSG_PUB.add;
2620: END IF;
2621: WHEN FND_API.G_EXC_ERROR THEN

Line 2619: FND_MSG_PUB.add;

2615: WHEN AMS_Utility_PVT.resource_locked THEN
2616: x_return_status := FND_API.g_ret_sts_error;
2617: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2618: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2619: FND_MSG_PUB.add;
2620: END IF;
2621: WHEN FND_API.G_EXC_ERROR THEN
2622: ROLLBACK TO VALIDATE_DM_MODEL;
2623: x_return_status := FND_API.G_RET_STS_ERROR;

Line 2625: FND_MSG_PUB.Count_And_Get (

2621: WHEN FND_API.G_EXC_ERROR THEN
2622: ROLLBACK TO VALIDATE_DM_MODEL;
2623: x_return_status := FND_API.G_RET_STS_ERROR;
2624: -- Standard call to get message count and if count=1, get the message
2625: FND_MSG_PUB.Count_And_Get (
2626: p_encoded => FND_API.G_FALSE,
2627: p_count => x_msg_count,
2628: p_data => x_msg_data
2629: );

Line 2634: FND_MSG_PUB.Count_And_Get (

2630: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2631: ROLLBACK TO VALIDATE_DM_MODEL;
2632: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2633: -- Standard call to get message count and if count=1, get the message
2634: FND_MSG_PUB.Count_And_Get (
2635: p_encoded => FND_API.G_FALSE,
2636: p_count => x_msg_count,
2637: p_data => x_msg_data
2638: );

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

2638: );
2639: WHEN OTHERS THEN
2640: ROLLBACK TO VALIDATE_DM_MODEL;
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2643: THEN
2644: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2645: END IF;
2646: -- Standard call to get message count and if count=1, get the message

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

2640: ROLLBACK TO VALIDATE_DM_MODEL;
2641: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2642: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2643: THEN
2644: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2645: END IF;
2646: -- Standard call to get message count and if count=1, get the message
2647: FND_MSG_PUB.Count_And_Get (
2648: p_encoded => FND_API.G_FALSE,

Line 2647: FND_MSG_PUB.Count_And_Get (

2643: THEN
2644: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2645: END IF;
2646: -- Standard call to get message count and if count=1, get the message
2647: FND_MSG_PUB.Count_And_Get (
2648: p_encoded => FND_API.G_FALSE,
2649: p_count => x_msg_count,
2650: p_data => x_msg_data
2651: );

Line 3255: FND_MSG_PUB.initialize;

3251: END IF;
3252:
3253: -- Initialize message list if p_init_msg_list is set to TRUE.
3254: IF FND_API.to_Boolean( p_init_msg_list )THEN
3255: FND_MSG_PUB.initialize;
3256: END IF;
3257:
3258: IF (AMS_DEBUG_HIGH_ON) THEN
3259:

Line 3457: FND_MSG_PUB.Count_And_Get (

3453: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
3454: END IF;
3455:
3456: -- Standard call to get message count and if count is 1, get message info.
3457: FND_MSG_PUB.Count_And_Get (
3458: p_count => x_msg_count,
3459: p_data => x_msg_data
3460: );
3461: EXCEPTION

Line 3466: FND_MSG_PUB.Count_And_Get (

3462: WHEN FND_API.G_EXC_ERROR THEN
3463: ROLLBACK TO ams_model_pvt_copy_model;
3464: x_return_status := FND_API.G_RET_STS_ERROR;
3465: -- Standard call to get message count and if count=1, get the message
3466: FND_MSG_PUB.Count_And_Get (
3467: p_encoded => FND_API.G_FALSE,
3468: p_count => x_msg_count,
3469: p_data => x_msg_data
3470: );

Line 3475: FND_MSG_PUB.Count_And_Get (

3471: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3472: ROLLBACK TO ams_model_pvt_copy_model;
3473: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3474: -- Standard call to get message count and if count=1, get the message
3475: FND_MSG_PUB.Count_And_Get (
3476: p_encoded => FND_API.G_FALSE,
3477: p_count => x_msg_count,
3478: p_data => x_msg_data
3479: );

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

3479: );
3480: WHEN OTHERS THEN
3481: ROLLBACK TO ams_model_pvt_copy_model;
3482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3483: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3485: END IF;
3486: -- Standard call to get message count and if count=1, get the message
3487: FND_MSG_PUB.Count_And_Get (

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

3480: WHEN OTHERS THEN
3481: ROLLBACK TO ams_model_pvt_copy_model;
3482: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3483: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3485: END IF;
3486: -- Standard call to get message count and if count=1, get the message
3487: FND_MSG_PUB.Count_And_Get (
3488: p_encoded => FND_API.G_FALSE,

Line 3487: FND_MSG_PUB.Count_And_Get (

3483: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3484: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3485: END IF;
3486: -- Standard call to get message count and if count=1, get the message
3487: FND_MSG_PUB.Count_And_Get (
3488: p_encoded => FND_API.G_FALSE,
3489: p_count => x_msg_count,
3490: p_data => x_msg_data
3491: );