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

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

131: AND user_status_id = p_status_id
132: ;
133:
134: -- foreward procedure and function declarations
135: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
136: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
137: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
138:
139: PROCEDURE Complete_Score_Rec (

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

132: ;
133:
134: -- foreward procedure and function declarations
135: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
136: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
137: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
138:
139: PROCEDURE Complete_Score_Rec (
140: p_score_rec IN Score_Rec_Type,

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

133:
134: -- foreward procedure and function declarations
135: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
136: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
137: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
138:
139: PROCEDURE Complete_Score_Rec (
140: p_score_rec IN Score_Rec_Type,
141: x_complete_rec OUT NOCOPY Score_Rec_Type

Line 288: FND_MSG_PUB.initialize;

284:
285: -- Initialize message list if p_init_msg_list is set to TRUE.
286: IF FND_API.to_Boolean( p_init_msg_list )
287: THEN
288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: -- Standard call to check for call compatibility.
292: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

314: OPEN c_Score_b;
315: FETCH c_Score_b INTO l_score_id;
316: IF (c_Score_b%NOTFOUND) THEN
317: CLOSE c_Score_b;
318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
319: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
320: FND_MSG_PUB.add;
321: END IF;
322: RAISE FND_API.g_exc_error;

Line 320: FND_MSG_PUB.add;

316: IF (c_Score_b%NOTFOUND) THEN
317: CLOSE c_Score_b;
318: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
319: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
320: FND_MSG_PUB.add;
321: END IF;
322: RAISE FND_API.g_exc_error;
323: END IF;
324:

Line 328: FND_MSG_PUB.count_and_get(

324:
325: CLOSE c_Score_b;
326:
327: -------------------- finish --------------------------
328: FND_MSG_PUB.count_and_get(
329: p_encoded => FND_API.g_false,
330: p_count => x_msg_count,
331: p_data => x_msg_data);
332: IF (AMS_DEBUG_HIGH_ON) THEN

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

336: EXCEPTION
337:
338: WHEN AMS_Utility_PVT.resource_locked THEN
339: x_return_status := FND_API.g_ret_sts_error;
340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
341: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
342: FND_MSG_PUB.add;
343: END IF;
344:

Line 342: FND_MSG_PUB.add;

338: WHEN AMS_Utility_PVT.resource_locked THEN
339: x_return_status := FND_API.g_ret_sts_error;
340: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
341: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
342: FND_MSG_PUB.add;
343: END IF;
344:
345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO LOCK_Score_PVT;

Line 349: FND_MSG_PUB.Count_And_Get (

345: WHEN FND_API.G_EXC_ERROR THEN
346: ROLLBACK TO LOCK_Score_PVT;
347: x_return_status := FND_API.G_RET_STS_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 359: FND_MSG_PUB.Count_And_Get (

355: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
356: ROLLBACK TO LOCK_Score_PVT;
357: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
358: -- Standard call to get message count and if count=1, get the message
359: FND_MSG_PUB.Count_And_Get (
360: p_encoded => FND_API.G_FALSE,
361: p_count => x_msg_count,
362: p_data => x_msg_data
363: );

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

364:
365: WHEN OTHERS THEN
366: ROLLBACK TO LOCK_Score_PVT;
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
371: END IF;
372: -- Standard call to get message count and if count=1, get the message

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

366: ROLLBACK TO LOCK_Score_PVT;
367: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
368: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
369: THEN
370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
371: END IF;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,

Line 373: FND_MSG_PUB.Count_And_Get (

369: THEN
370: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
371: END IF;
372: -- Standard call to get message count and if count=1, get the message
373: FND_MSG_PUB.Count_And_Get (
374: p_encoded => FND_API.G_FALSE,
375: p_count => x_msg_count,
376: p_data => x_msg_data
377: );

Line 464: FND_MSG_PUB.initialize;

460: END IF;
461:
462: -- Initialize message list if p_init_msg_list is set to TRUE.
463: IF FND_API.to_Boolean( p_init_msg_list ) THEN
464: FND_MSG_PUB.initialize;
465: END IF;
466:
467: -- Debug Message
468: IF (AMS_DEBUG_HIGH_ON) THEN

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

477: -- ******************************************************************
478: -- Validate Environment
479: -- ******************************************************************
480: IF FND_GLOBAL.User_Id IS NULL THEN
481: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
482: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
483: FND_MSG_PUB.ADD;
484: END IF;
485: RAISE FND_API.G_EXC_ERROR;

Line 483: FND_MSG_PUB.ADD;

479: -- ******************************************************************
480: IF FND_GLOBAL.User_Id IS NULL THEN
481: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
482: FND_MESSAGE.Set_Name('AMS', 'USER_PROFILE_MISSING');
483: FND_MSG_PUB.ADD;
484: END IF;
485: RAISE FND_API.G_EXC_ERROR;
486: END IF;
487:

Line 671: FND_MSG_PUB.Count_And_Get

667: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
668: END IF;
669:
670: -- Standard call to get message count and if count is 1, get message info.
671: FND_MSG_PUB.Count_And_Get
672: (p_count => x_msg_count,
673: p_data => x_msg_data
674: );
675: EXCEPTION

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

675: EXCEPTION
676:
677: WHEN AMS_Utility_PVT.resource_locked THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
680: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
681: FND_MSG_PUB.add;
682: END IF;
683:

Line 681: FND_MSG_PUB.add;

677: WHEN AMS_Utility_PVT.resource_locked THEN
678: x_return_status := FND_API.g_ret_sts_error;
679: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
680: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
681: FND_MSG_PUB.add;
682: END IF;
683:
684: WHEN FND_API.G_EXC_ERROR THEN
685: ROLLBACK TO CREATE_Score_PVT;

Line 688: FND_MSG_PUB.Count_And_Get (

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

Line 698: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 712: FND_MSG_PUB.Count_And_Get (

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

Line 784: FND_MSG_PUB.initialize;

780: END IF;
781:
782: -- Initialize message list if p_init_msg_list is set to TRUE.
783: IF FND_API.to_Boolean( p_init_msg_list ) THEN
784: FND_MSG_PUB.initialize;
785: END IF;
786:
787: -- Debug Message
788: IF (AMS_DEBUG_HIGH_ON) THEN

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

809: OPEN c_reference (l_tar_score_rec.score_id);
810: FETCH c_reference INTO l_reference_rec;
811: IF (c_reference%NOTFOUND) THEN
812: CLOSE c_reference;
813: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
814: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
815: FND_MESSAGE.Set_Token ('INFO', 'dm_score', FALSE);
816: FND_MSG_PUB.Add;
817: END IF;

Line 816: FND_MSG_PUB.Add;

812: CLOSE c_reference;
813: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR) THEN
814: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_UPDATE_TARGET');
815: FND_MESSAGE.Set_Token ('INFO', 'dm_score', FALSE);
816: FND_MSG_PUB.Add;
817: END IF;
818: RAISE FND_API.G_EXC_ERROR;
819: END IF;
820:

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

1227:
1228: -- Debug Message
1229: IF (AMS_DEBUG_LOW_ON) THEN
1230:
1231: AMS_UTILITY_PVT.debug_message('Private API: Calling update table handler',FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
1232: END IF;
1233:
1234: BEGIN
1235: -- Invoke table handler(AMS_DM_scoreS_B_PKG.Update_Row)

Line 1307: FND_MSG_PUB.Count_And_Get

1303: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1304: END IF;
1305:
1306: -- Standard call to get message count and if count is 1, get message info.
1307: FND_MSG_PUB.Count_And_Get
1308: (p_count => x_msg_count,
1309: p_data => x_msg_data
1310: );
1311:

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

1317: EXCEPTION
1318:
1319: WHEN AMS_Utility_PVT.resource_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF;
1325:

Line 1323: FND_MSG_PUB.add;

1319: WHEN AMS_Utility_PVT.resource_locked THEN
1320: x_return_status := FND_API.g_ret_sts_error;
1321: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1322: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1323: FND_MSG_PUB.add;
1324: END IF;
1325:
1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK TO UPDATE_Score_PVT;

Line 1330: FND_MSG_PUB.Count_And_Get (

1326: WHEN FND_API.G_EXC_ERROR THEN
1327: ROLLBACK TO UPDATE_Score_PVT;
1328: x_return_status := FND_API.G_RET_STS_ERROR;
1329: -- Standard call to get message count and if count=1, get the message
1330: FND_MSG_PUB.Count_And_Get (
1331: p_encoded => FND_API.G_FALSE,
1332: p_count => x_msg_count,
1333: p_data => x_msg_data
1334: );

Line 1340: FND_MSG_PUB.Count_And_Get (

1336: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1337: ROLLBACK TO UPDATE_Score_PVT;
1338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1339: -- Standard call to get message count and if count=1, get the message
1340: FND_MSG_PUB.Count_And_Get (
1341: p_encoded => FND_API.G_FALSE,
1342: p_count => x_msg_count,
1343: p_data => x_msg_data
1344: );

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

1345:
1346: WHEN OTHERS THEN
1347: ROLLBACK TO UPDATE_Score_PVT;
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: THEN
1351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1352: END IF;
1353: -- Standard call to get message count and if count=1, get the message

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

1347: ROLLBACK TO UPDATE_Score_PVT;
1348: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1349: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1350: THEN
1351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1352: END IF;
1353: -- Standard call to get message count and if count=1, get the message
1354: FND_MSG_PUB.Count_And_Get (
1355: p_encoded => FND_API.G_FALSE,

Line 1354: FND_MSG_PUB.Count_And_Get (

1350: THEN
1351: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1352: END IF;
1353: -- Standard call to get message count and if count=1, get the message
1354: FND_MSG_PUB.Count_And_Get (
1355: p_encoded => FND_API.G_FALSE,
1356: p_count => x_msg_count,
1357: p_data => x_msg_data
1358: );

Line 1401: FND_MSG_PUB.initialize;

1397:
1398: -- Initialize message list if p_init_msg_list is set to TRUE.
1399: IF FND_API.to_Boolean( p_init_msg_list )
1400: THEN
1401: FND_MSG_PUB.initialize;
1402: END IF;
1403:
1404: -- Debug Message
1405: IF (AMS_DEBUG_HIGH_ON) THEN

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

1423:
1424: Fetch c_obj_version into l_object_version_number;
1425:
1426: If ( c_obj_version%NOTFOUND) Then
1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_DELETE_TARGET');
1430: FND_MESSAGE.Set_Token ('INFO', 'dm_scores', FALSE);
1431: FND_MSG_PUB.Add;

Line 1431: FND_MSG_PUB.Add;

1427: IF FND_MSG_PUB.Check_Msg_Level (FND_MSG_PUB.G_MSG_LVL_ERROR)
1428: THEN
1429: FND_MESSAGE.Set_Name('AMS', 'API_MISSING_DELETE_TARGET');
1430: FND_MESSAGE.Set_Token ('INFO', 'dm_scores', FALSE);
1431: FND_MSG_PUB.Add;
1432: END IF;
1433: raise FND_API.G_EXC_ERROR;
1434: END IF;
1435: -- Debug Message

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

1442: --
1443: -- Api body
1444: --
1445: IF P_Object_Version_Number <> l_object_version_number THEN
1446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1447: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
1448: FND_MESSAGE.Set_Token('INFO', 'dm_score', FALSE);
1449: FND_MSG_PUB.ADD;
1450: END IF;

Line 1449: FND_MSG_PUB.ADD;

1445: IF P_Object_Version_Number <> l_object_version_number THEN
1446: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1447: FND_MESSAGE.Set_Name('AMS', 'API_RECORD_CHANGED');
1448: FND_MESSAGE.Set_Token('INFO', 'dm_score', FALSE);
1449: FND_MSG_PUB.ADD;
1450: END IF;
1451: raise FND_API.G_EXC_ERROR;
1452: END IF;
1453:

Line 1483: FND_MSG_PUB.Count_And_Get

1479: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
1480: END IF;
1481:
1482: -- Standard call to get message count and if count is 1, get message info.
1483: FND_MSG_PUB.Count_And_Get
1484: (p_count => x_msg_count,
1485: p_data => x_msg_data
1486: );
1487:

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

1488: EXCEPTION
1489:
1490: WHEN AMS_Utility_PVT.resource_locked THEN
1491: x_return_status := FND_API.g_ret_sts_error;
1492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1493: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1494: FND_MSG_PUB.add;
1495: END IF;
1496:

Line 1494: FND_MSG_PUB.add;

1490: WHEN AMS_Utility_PVT.resource_locked THEN
1491: x_return_status := FND_API.g_ret_sts_error;
1492: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1493: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
1494: FND_MSG_PUB.add;
1495: END IF;
1496:
1497: WHEN FND_API.G_EXC_ERROR THEN
1498: ROLLBACK TO DELETE_Score_PVT;

Line 1501: FND_MSG_PUB.Count_And_Get (

1497: WHEN FND_API.G_EXC_ERROR THEN
1498: ROLLBACK TO DELETE_Score_PVT;
1499: x_return_status := FND_API.G_RET_STS_ERROR;
1500: -- Standard call to get message count and if count=1, get the message
1501: FND_MSG_PUB.Count_And_Get (
1502: p_encoded => FND_API.G_FALSE,
1503: p_count => x_msg_count,
1504: p_data => x_msg_data
1505: );

Line 1511: FND_MSG_PUB.Count_And_Get (

1507: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1508: ROLLBACK TO DELETE_Score_PVT;
1509: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1510: -- Standard call to get message count and if count=1, get the message
1511: FND_MSG_PUB.Count_And_Get (
1512: p_encoded => FND_API.G_FALSE,
1513: p_count => x_msg_count,
1514: p_data => x_msg_data
1515: );

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

1516:
1517: WHEN OTHERS THEN
1518: ROLLBACK TO DELETE_Score_PVT;
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1521: THEN
1522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1523: END IF;
1524: -- Standard call to get message count and if count=1, get the message

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

1518: ROLLBACK TO DELETE_Score_PVT;
1519: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1520: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1521: THEN
1522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1523: END IF;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_MSG_PUB.Count_And_Get (
1526: p_encoded => FND_API.G_FALSE,

Line 1525: FND_MSG_PUB.Count_And_Get (

1521: THEN
1522: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1523: END IF;
1524: -- Standard call to get message count and if count=1, get the message
1525: FND_MSG_PUB.Count_And_Get (
1526: p_encoded => FND_API.G_FALSE,
1527: p_count => x_msg_count,
1528: p_data => x_msg_data
1529: );

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

1572: );
1573: END IF;
1574:
1575: IF l_valid_flag = FND_API.g_false THEN
1576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1577: THEN
1578: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_DUP_ID');
1579: FND_MSG_PUB.add;
1580: END IF;

Line 1579: FND_MSG_PUB.add;

1575: IF l_valid_flag = FND_API.g_false THEN
1576: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1577: THEN
1578: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_DUP_ID');
1579: FND_MSG_PUB.add;
1580: END IF;
1581: x_return_status := FND_API.g_ret_sts_error;
1582: RETURN;
1583: END IF;

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

1593: CLOSE c_score_name_updt ;
1594: END IF;
1595:
1596: IF l_dummy IS NOT NULL THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1598: FND_MESSAGE.set_name('AMS', 'AMS_SCORE_DUPLICATE_NAME');
1599: FND_MSG_PUB.add;
1600: END IF;
1601: x_return_status := FND_API.g_ret_sts_error;

Line 1599: FND_MSG_PUB.add;

1595:
1596: IF l_dummy IS NOT NULL THEN
1597: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
1598: FND_MESSAGE.set_name('AMS', 'AMS_SCORE_DUPLICATE_NAME');
1599: FND_MSG_PUB.add;
1600: END IF;
1601: x_return_status := FND_API.g_ret_sts_error;
1602: RETURN;
1603: END IF;

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

1628: AMS_UTILITY_PVT.debug_message('Private API: id ' || p_score_rec.score_id);
1629: END IF;
1630: IF p_score_rec.model_id = FND_API.g_miss_num
1631: OR p_score_rec.model_id IS NULL THEN
1632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1633: THEN
1634: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_MOD_ID');
1635: FND_MSG_PUB.add;
1636: END IF;

Line 1635: FND_MSG_PUB.add;

1631: OR p_score_rec.model_id IS NULL THEN
1632: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1633: THEN
1634: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_MOD_ID');
1635: FND_MSG_PUB.add;
1636: END IF;
1637: x_return_status := FND_API.g_ret_sts_error;
1638: END IF;
1639:

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

1639:
1640:
1641: IF p_score_rec.user_status_id = FND_API.g_miss_num
1642: OR p_score_rec.user_status_id IS NULL THEN
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1644: THEN
1645: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_USR_STAT_ID');
1646: FND_MSG_PUB.add;
1647: END IF;

Line 1646: FND_MSG_PUB.add;

1642: OR p_score_rec.user_status_id IS NULL THEN
1643: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1644: THEN
1645: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_USR_STAT_ID');
1646: FND_MSG_PUB.add;
1647: END IF;
1648: x_return_status := FND_API.g_ret_sts_error;
1649: END IF;
1650:

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

1649: END IF;
1650:
1651: IF p_score_rec.owner_user_id = FND_API.g_miss_num
1652: OR p_score_rec.owner_user_id IS NULL THEN
1653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1654: THEN
1655: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_OWNER_USR_ID');
1656: FND_MSG_PUB.add;
1657: END IF;

Line 1656: FND_MSG_PUB.add;

1652: OR p_score_rec.owner_user_id IS NULL THEN
1653: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1654: THEN
1655: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_OWNER_USR_ID');
1656: FND_MSG_PUB.add;
1657: END IF;
1658: x_return_status := FND_API.g_ret_sts_error;
1659: END IF;
1660:

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

1659: END IF;
1660:
1661: IF p_score_rec.score_name = FND_API.g_miss_char
1662: OR p_score_rec.score_name IS NULL THEN
1663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1664: THEN
1665: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_NAME');
1666: FND_MSG_PUB.add;
1667: END IF;

Line 1666: FND_MSG_PUB.add;

1662: OR p_score_rec.score_name IS NULL THEN
1663: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1664: THEN
1665: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_NAME');
1666: FND_MSG_PUB.add;
1667: END IF;
1668: x_return_status := FND_API.g_ret_sts_error;
1669: END IF;
1670:

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

1669: END IF;
1670:
1671: ELSE -- update operation
1672: IF p_score_rec.score_id IS NULL THEN
1673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1674: THEN
1675: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_ID');
1676: FND_MSG_PUB.add;
1677: END IF;

Line 1676: FND_MSG_PUB.add;

1672: IF p_score_rec.score_id IS NULL THEN
1673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1674: THEN
1675: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_ID');
1676: FND_MSG_PUB.add;
1677: END IF;
1678: x_return_status := FND_API.g_ret_sts_error;
1679: END IF;
1680:

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

1683: x_return_status := FND_API.g_ret_sts_error;
1684: END IF;
1685:
1686: IF p_score_rec.model_id IS NULL THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_MOD_ID');
1690: FND_MSG_PUB.add;
1691: END IF;

Line 1690: FND_MSG_PUB.add;

1686: IF p_score_rec.model_id IS NULL THEN
1687: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1688: THEN
1689: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_MOD_ID');
1690: FND_MSG_PUB.add;
1691: END IF;
1692: x_return_status := FND_API.g_ret_sts_error;
1693: END IF;
1694:

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

1693: END IF;
1694:
1695:
1696: IF p_score_rec.user_status_id IS NULL THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1698: THEN
1699: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_USR_STAT_ID');
1700: FND_MSG_PUB.add;
1701: END IF;

Line 1700: FND_MSG_PUB.add;

1696: IF p_score_rec.user_status_id IS NULL THEN
1697: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1698: THEN
1699: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_USR_STAT_ID');
1700: FND_MSG_PUB.add;
1701: END IF;
1702: x_return_status := FND_API.g_ret_sts_error;
1703: END IF;
1704:

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

1702: x_return_status := FND_API.g_ret_sts_error;
1703: END IF;
1704:
1705: IF p_score_rec.owner_user_id IS NULL THEN
1706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1707: THEN
1708: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_OWNER_USR_ID');
1709: FND_MSG_PUB.add;
1710: END IF;

Line 1709: FND_MSG_PUB.add;

1705: IF p_score_rec.owner_user_id IS NULL THEN
1706: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1707: THEN
1708: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_NO_OWNER_USR_ID');
1709: FND_MSG_PUB.add;
1710: END IF;
1711: x_return_status := FND_API.g_ret_sts_error;
1712: END IF;
1713: END IF;

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

1732: 'MODEL_ID',
1733: p_score_rec.model_id
1734: ) = FND_API.g_false
1735: THEN
1736: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1737: THEN
1738: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_MOD_ID');
1739: FND_MSG_PUB.add;
1740: END IF;

Line 1739: FND_MSG_PUB.add;

1735: THEN
1736: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1737: THEN
1738: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_MOD_ID');
1739: FND_MSG_PUB.add;
1740: END IF;
1741: x_return_status := FND_API.g_ret_sts_error;
1742: END IF;
1743: END IF;

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

1749: 'USER_STATUS_ID',
1750: p_score_rec.user_status_id
1751: ) = FND_API.g_false
1752: THEN
1753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1754: THEN
1755: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_USR_STAT_ID');
1756: FND_MSG_PUB.add;
1757: END IF;

Line 1756: FND_MSG_PUB.add;

1752: THEN
1753: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1754: THEN
1755: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_USR_STAT_ID');
1756: FND_MSG_PUB.add;
1757: END IF;
1758: x_return_status := FND_API.g_ret_sts_error;
1759: END IF;
1760: END IF;

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

1778: p_lookup_type => G_STATUS_TYPE_SCORE,
1779: p_lookup_code => p_score_rec.status_code
1780: ) = FND_API.g_false
1781: THEN
1782: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1783: THEN
1784: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_STAT_CODE');
1785: FND_MSG_PUB.add;
1786: END IF;

Line 1785: FND_MSG_PUB.add;

1781: THEN
1782: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
1783: THEN
1784: FND_MESSAGE.set_name('AMS', 'AMS_DM_SCORE_BAD_STAT_CODE');
1785: FND_MSG_PUB.add;
1786: END IF;
1787:
1788: x_return_status := FND_API.g_ret_sts_error;
1789: END IF;

Line 2144: FND_MSG_PUB.initialize;

2140: END IF;
2141:
2142: -- Initialize message list if p_init_msg_list is set to TRUE.
2143: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2144: FND_MSG_PUB.initialize;
2145: END IF;
2146:
2147: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
2148: Check_Score_Items(

Line 2188: FND_MSG_PUB.Count_And_Get

2184: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2185: END IF;
2186:
2187: -- Standard call to get message count and if count is 1, get message info.
2188: FND_MSG_PUB.Count_And_Get
2189: (p_count => x_msg_count,
2190: p_data => x_msg_data
2191: );
2192: EXCEPTION

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

2192: EXCEPTION
2193:
2194: WHEN AMS_Utility_PVT.resource_locked THEN
2195: x_return_status := FND_API.g_ret_sts_error;
2196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2197: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2198: FND_MSG_PUB.add;
2199: END IF;
2200:

Line 2198: FND_MSG_PUB.add;

2194: WHEN AMS_Utility_PVT.resource_locked THEN
2195: x_return_status := FND_API.g_ret_sts_error;
2196: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
2197: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
2198: FND_MSG_PUB.add;
2199: END IF;
2200:
2201: WHEN FND_API.G_EXC_ERROR THEN
2202: ROLLBACK TO VALIDATE_Score_;

Line 2205: FND_MSG_PUB.Count_And_Get (

2201: WHEN FND_API.G_EXC_ERROR THEN
2202: ROLLBACK TO VALIDATE_Score_;
2203: x_return_status := FND_API.G_RET_STS_ERROR;
2204: -- Standard call to get message count and if count=1, get the message
2205: FND_MSG_PUB.Count_And_Get (
2206: p_encoded => FND_API.G_FALSE,
2207: p_count => x_msg_count,
2208: p_data => x_msg_data
2209: );

Line 2215: FND_MSG_PUB.Count_And_Get (

2211: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2212: ROLLBACK TO VALIDATE_Score_;
2213: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2214: -- Standard call to get message count and if count=1, get the message
2215: FND_MSG_PUB.Count_And_Get (
2216: p_encoded => FND_API.G_FALSE,
2217: p_count => x_msg_count,
2218: p_data => x_msg_data
2219: );

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

2220:
2221: WHEN OTHERS THEN
2222: ROLLBACK TO VALIDATE_Score_;
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2225: THEN
2226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2227: END IF;
2228: -- Standard call to get message count and if count=1, get the message

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

2222: ROLLBACK TO VALIDATE_Score_;
2223: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2224: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
2225: THEN
2226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2227: END IF;
2228: -- Standard call to get message count and if count=1, get the message
2229: FND_MSG_PUB.Count_And_Get (
2230: p_encoded => FND_API.G_FALSE,

Line 2229: FND_MSG_PUB.Count_And_Get (

2225: THEN
2226: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
2227: END IF;
2228: -- Standard call to get message count and if count=1, get the message
2229: FND_MSG_PUB.Count_And_Get (
2230: p_encoded => FND_API.G_FALSE,
2231: p_count => x_msg_count,
2232: p_data => x_msg_data
2233: );

Line 2260: FND_MSG_PUB.initialize;

2256: BEGIN
2257: -- Initialize message list if p_init_msg_list is set to TRUE.
2258: IF FND_API.to_Boolean( p_init_msg_list )
2259: THEN
2260: FND_MSG_PUB.initialize;
2261: END IF;
2262:
2263: -- Initialize API return status to SUCCESS
2264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2378: FND_MSG_PUB.Count_And_Get

2374: END IF;
2375: -- End add rosharma 28-Nov-2002
2376:
2377: -- Standard call to get message count and if count is 1, get message info.
2378: FND_MSG_PUB.Count_And_Get
2379: (p_count => x_msg_count,
2380: p_data => x_msg_data
2381: );
2382: END Validate_Score_Rec;

Line 2793: FND_MSG_PUB.initialize;

2789: END IF;
2790:
2791: -- Initialize message list if p_init_msg_list is set to TRUE.
2792: IF FND_API.to_Boolean( p_init_msg_list )THEN
2793: FND_MSG_PUB.initialize;
2794: END IF;
2795:
2796: IF (AMS_DEBUG_HIGH_ON) THEN
2797:

Line 2975: FND_MSG_PUB.Count_And_Get (

2971: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || ' end');
2972: END IF;
2973:
2974: -- Standard call to get message count and if count is 1, get message info.
2975: FND_MSG_PUB.Count_And_Get (
2976: p_count => x_msg_count,
2977: p_data => x_msg_data
2978: );
2979: EXCEPTION

Line 2984: FND_MSG_PUB.Count_And_Get (

2980: WHEN FND_API.G_EXC_ERROR THEN
2981: ROLLBACK TO ams_score_pvt_copy_score;
2982: x_return_status := FND_API.G_RET_STS_ERROR;
2983: -- Standard call to get message count and if count=1, get the message
2984: FND_MSG_PUB.Count_And_Get (
2985: p_encoded => FND_API.G_FALSE,
2986: p_count => x_msg_count,
2987: p_data => x_msg_data
2988: );

Line 2993: FND_MSG_PUB.Count_And_Get (

2989: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2990: ROLLBACK TO ams_score_pvt_copy_score;
2991: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2992: -- Standard call to get message count and if count=1, get the message
2993: FND_MSG_PUB.Count_And_Get (
2994: p_encoded => FND_API.G_FALSE,
2995: p_count => x_msg_count,
2996: p_data => x_msg_data
2997: );

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

2997: );
2998: WHEN OTHERS THEN
2999: ROLLBACK TO ams_score_pvt_copy_score;
3000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3003: END IF;
3004: -- Standard call to get message count and if count=1, get the message
3005: FND_MSG_PUB.Count_And_Get (

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

2998: WHEN OTHERS THEN
2999: ROLLBACK TO ams_score_pvt_copy_score;
3000: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
3001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3003: END IF;
3004: -- Standard call to get message count and if count=1, get the message
3005: FND_MSG_PUB.Count_And_Get (
3006: p_encoded => FND_API.G_FALSE,

Line 3005: FND_MSG_PUB.Count_And_Get (

3001: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR) THEN
3002: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
3003: END IF;
3004: -- Standard call to get message count and if count=1, get the message
3005: FND_MSG_PUB.Count_And_Get (
3006: p_encoded => FND_API.G_FALSE,
3007: p_count => x_msg_count,
3008: p_data => x_msg_data
3009: );