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

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

74: G_MODEL_TYPE_PROD CONSTANT VARCHAR2(30) := 'PRODUCT_AFFINITY';
75:
76:
77: -- forward procedure/function declarations
78: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
79: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
80: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
81:
82: /*

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

75:
76:
77: -- forward procedure/function declarations
78: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
79: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
80: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
81:
82: /*
83: -- Moved the definition to body

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

76:
77: -- forward procedure/function declarations
78: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
79: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
80: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
81:
82: /*
83: -- Moved the definition to body
84: -- 3/24/2005 kbasavar for 4259733

Line 146: FND_MSG_PUB.initialize;

142: END IF;
143:
144: -- Initialize message list if p_init_msg_list is set to TRUE.
145: IF FND_API.to_Boolean( p_init_msg_list ) THEN
146: FND_MSG_PUB.initialize;
147: END IF;
148:
149: -- Debug Message
150: IF (AMS_DEBUG_HIGH_ON) THEN

Line 247: FND_MSG_PUB.Count_And_Get

243: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
244: END IF;
245:
246: -- Standard call to get message count and if count is 1, get message info.
247: FND_MSG_PUB.Count_And_Get
248: (p_count => x_msg_count,
249: p_data => x_msg_data
250: );
251: EXCEPTION

Line 261: FND_MSG_PUB.Count_And_Get (

257: WHEN FND_API.G_EXC_ERROR THEN
258: ROLLBACK TO CREATE_Scoreresult_PVT;
259: x_return_status := FND_API.G_RET_STS_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 271: FND_MSG_PUB.Count_And_Get (

267: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
268: ROLLBACK TO CREATE_Scoreresult_PVT;
269: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
270: -- Standard call to get message count and if count=1, get the message
271: FND_MSG_PUB.Count_And_Get (
272: p_encoded => FND_API.G_FALSE,
273: p_count => x_msg_count,
274: p_data => x_msg_data
275: );

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

276:
277: WHEN OTHERS THEN
278: ROLLBACK TO CREATE_Scoreresult_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message

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

278: ROLLBACK TO CREATE_Scoreresult_PVT;
279: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
280: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,

Line 285: FND_MSG_PUB.Count_And_Get (

281: THEN
282: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
283: END IF;
284: -- Standard call to get message count and if count=1, get the message
285: FND_MSG_PUB.Count_And_Get (
286: p_encoded => FND_API.G_FALSE,
287: p_count => x_msg_count,
288: p_data => x_msg_data
289: );

Line 335: FND_MSG_PUB.initialize;

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

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

399:
400: -- Debug Message
401: IF (AMS_DEBUG_HIGH_ON) THEN
402:
403: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
404: END IF;
405:
406: -- Invoke table handler(AMS_DM_SCORE_RESULTS_PKG.Update_Row)
407: AMS_DM_SCORE_RESULTS_PKG.Update_Row(

Line 439: FND_MSG_PUB.Count_And_Get

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

Line 453: FND_MSG_PUB.Count_And_Get (

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

Line 463: FND_MSG_PUB.Count_And_Get (

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

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

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

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

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

Line 477: FND_MSG_PUB.Count_And_Get (

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

Line 515: FND_MSG_PUB.initialize;

511:
512: -- Initialize message list if p_init_msg_list is set to TRUE.
513: IF FND_API.to_Boolean( p_init_msg_list )
514: THEN
515: FND_MSG_PUB.initialize;
516: END IF;
517:
518: -- Debug Message
519: IF (AMS_DEBUG_HIGH_ON) THEN

Line 558: FND_MSG_PUB.Count_And_Get

554: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
555: END IF;
556:
557: -- Standard call to get message count and if count is 1, get message info.
558: FND_MSG_PUB.Count_And_Get
559: (p_count => x_msg_count,
560: p_data => x_msg_data
561: );
562: EXCEPTION

Line 572: FND_MSG_PUB.Count_And_Get (

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

Line 582: FND_MSG_PUB.Count_And_Get (

578: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
579: ROLLBACK TO DELETE_Scoreresult_PVT;
580: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
581: -- Standard call to get message count and if count=1, get the message
582: FND_MSG_PUB.Count_And_Get (
583: p_encoded => FND_API.G_FALSE,
584: p_count => x_msg_count,
585: p_data => x_msg_data
586: );

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

587:
588: WHEN OTHERS THEN
589: ROLLBACK TO DELETE_Scoreresult_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
594: END IF;
595: -- Standard call to get message count and if count=1, get the message

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

589: ROLLBACK TO DELETE_Scoreresult_PVT;
590: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
591: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
592: THEN
593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
594: END IF;
595: -- Standard call to get message count and if count=1, get the message
596: FND_MSG_PUB.Count_And_Get (
597: p_encoded => FND_API.G_FALSE,

Line 596: FND_MSG_PUB.Count_And_Get (

592: THEN
593: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
594: END IF;
595: -- Standard call to get message count and if count=1, get the message
596: FND_MSG_PUB.Count_And_Get (
597: p_encoded => FND_API.G_FALSE,
598: p_count => x_msg_count,
599: p_data => x_msg_data
600: );

Line 641: FND_MSG_PUB.initialize;

637:
638: -- Initialize message list if p_init_msg_list is set to TRUE.
639: IF FND_API.to_Boolean( p_init_msg_list )
640: THEN
641: FND_MSG_PUB.initialize;
642: END IF;
643:
644: -- Standard call to check for call compatibility.
645: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,

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

669: FETCH c_Scoreresult INTO l_SCORE_RESULT_ID;
670:
671: IF (c_Scoreresult%NOTFOUND) THEN
672: CLOSE c_Scoreresult;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
675: FND_MSG_PUB.add;
676: END IF;
677: RAISE FND_API.g_exc_error;

Line 675: FND_MSG_PUB.add;

671: IF (c_Scoreresult%NOTFOUND) THEN
672: CLOSE c_Scoreresult;
673: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
674: FND_MESSAGE.set_name('AMS', 'AMS_API_RECORD_NOT_FOUND');
675: FND_MSG_PUB.add;
676: END IF;
677: RAISE FND_API.g_exc_error;
678: END IF;
679:

Line 683: FND_MSG_PUB.count_and_get(

679:
680: CLOSE c_Scoreresult;
681:
682: -------------------- finish --------------------------
683: FND_MSG_PUB.count_and_get(
684: p_encoded => FND_API.g_false,
685: p_count => x_msg_count,
686: p_data => x_msg_data);
687: IF (AMS_DEBUG_HIGH_ON) THEN

Line 701: FND_MSG_PUB.Count_And_Get (

697: WHEN FND_API.G_EXC_ERROR THEN
698: ROLLBACK TO LOCK_Scoreresult_PVT;
699: x_return_status := FND_API.G_RET_STS_ERROR;
700: -- Standard call to get message count and if count=1, get the message
701: FND_MSG_PUB.Count_And_Get (
702: p_encoded => FND_API.G_FALSE,
703: p_count => x_msg_count,
704: p_data => x_msg_data
705: );

Line 711: FND_MSG_PUB.Count_And_Get (

707: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
708: ROLLBACK TO LOCK_Scoreresult_PVT;
709: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
710: -- Standard call to get message count and if count=1, get the message
711: FND_MSG_PUB.Count_And_Get (
712: p_encoded => FND_API.G_FALSE,
713: p_count => x_msg_count,
714: p_data => x_msg_data
715: );

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

716:
717: WHEN OTHERS THEN
718: ROLLBACK TO LOCK_Scoreresult_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message

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

718: ROLLBACK TO LOCK_Scoreresult_PVT;
719: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
720: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,

Line 725: FND_MSG_PUB.Count_And_Get (

721: THEN
722: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
723: END IF;
724: -- Standard call to get message count and if count=1, get the message
725: FND_MSG_PUB.Count_And_Get (
726: p_encoded => FND_API.G_FALSE,
727: p_count => x_msg_count,
728: p_data => x_msg_data
729: );

Line 963: FND_MSG_PUB.initialize;

959:
960: -- Initialize message list if p_init_msg_list is set to TRUE.
961: IF FND_API.to_Boolean( p_init_msg_list )
962: THEN
963: FND_MSG_PUB.initialize;
964: END IF;
965: IF p_validation_level >= JTF_PLSQL_API.g_valid_level_item THEN
966: Check_scoreresult_Items(
967: p_scoreresult_rec => p_scoreresult_rec,

Line 1018: FND_MSG_PUB.Count_And_Get

1014: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1015: END IF;
1016:
1017: -- Standard call to get message count and if count is 1, get message info.
1018: FND_MSG_PUB.Count_And_Get
1019: (p_count => x_msg_count,
1020: p_data => x_msg_data
1021: );
1022: EXCEPTION

Line 1032: FND_MSG_PUB.Count_And_Get (

1028: WHEN FND_API.G_EXC_ERROR THEN
1029: ROLLBACK TO VALIDATE_Scoreresult_;
1030: x_return_status := FND_API.G_RET_STS_ERROR;
1031: -- Standard call to get message count and if count=1, get the message
1032: FND_MSG_PUB.Count_And_Get (
1033: p_encoded => FND_API.G_FALSE,
1034: p_count => x_msg_count,
1035: p_data => x_msg_data
1036: );

Line 1042: FND_MSG_PUB.Count_And_Get (

1038: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1039: ROLLBACK TO VALIDATE_Scoreresult_;
1040: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1041: -- Standard call to get message count and if count=1, get the message
1042: FND_MSG_PUB.Count_And_Get (
1043: p_encoded => FND_API.G_FALSE,
1044: p_count => x_msg_count,
1045: p_data => x_msg_data
1046: );

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

1047:
1048: WHEN OTHERS THEN
1049: ROLLBACK TO VALIDATE_Scoreresult_;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message

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

1049: ROLLBACK TO VALIDATE_Scoreresult_;
1050: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1051: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,

Line 1056: FND_MSG_PUB.Count_And_Get (

1052: THEN
1053: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1054: END IF;
1055: -- Standard call to get message count and if count=1, get the message
1056: FND_MSG_PUB.Count_And_Get (
1057: p_encoded => FND_API.G_FALSE,
1058: p_count => x_msg_count,
1059: p_data => x_msg_data
1060: );

Line 1077: FND_MSG_PUB.initialize;

1073: BEGIN
1074: -- Initialize message list if p_init_msg_list is set to TRUE.
1075: IF FND_API.to_Boolean( p_init_msg_list )
1076: THEN
1077: FND_MSG_PUB.initialize;
1078: END IF;
1079:
1080: -- Initialize API return status to SUCCESS
1081: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1094: FND_MSG_PUB.Count_And_Get

1090:
1091: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1092: END IF;
1093: -- Standard call to get message count and if count is 1, get message info.
1094: FND_MSG_PUB.Count_And_Get
1095: (p_count => x_msg_count,
1096: p_data => x_msg_data
1097: );
1098: END Validate_scoreresult_Rec;

Line 1480: FND_MSG_PUB.initialize;

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

Line 1563: FND_MSG_PUB.Count_And_Get (

1559: WHEN FND_API.G_EXC_ERROR THEN
1560: ROLLBACK TO summarize_Scoreresult_PVT;
1561: x_return_status := FND_API.G_RET_STS_ERROR;
1562: -- Standard call to get message count and if count=1, get the message
1563: FND_MSG_PUB.Count_And_Get (
1564: p_encoded => FND_API.G_FALSE,
1565: p_count => x_msg_count,
1566: p_data => x_msg_data
1567: );

Line 1572: FND_MSG_PUB.Count_And_Get (

1568: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1569: ROLLBACK TO summarize_Scoreresult_PVT;
1570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1571: -- Standard call to get message count and if count=1, get the message
1572: FND_MSG_PUB.Count_And_Get (
1573: p_encoded => FND_API.G_FALSE,
1574: p_count => x_msg_count,
1575: p_data => x_msg_data
1576: );

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

1576: );
1577: WHEN OTHERS THEN
1578: ROLLBACK TO summarize_Scoreresult_PVT;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message

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

1578: ROLLBACK TO summarize_Scoreresult_PVT;
1579: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1580: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,

Line 1585: FND_MSG_PUB.Count_And_Get (

1581: THEN
1582: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1583: END IF;
1584: -- Standard call to get message count and if count=1, get the message
1585: FND_MSG_PUB.Count_And_Get (
1586: p_encoded => FND_API.G_FALSE,
1587: p_count => x_msg_count,
1588: p_data => x_msg_data
1589: );

Line 1671: Fnd_Msg_Pub.initialize;

1667: l_insertSql VARCHAR2(1000);
1668: l_scoreListId NUMBER;
1669:
1670: BEGIN
1671: Fnd_Msg_Pub.initialize;
1672:
1673: IF (AMS_DEBUG_HIGH_ON) THEN
1674: AMS_UTILITY_PVT.debug_message('Private API: generate_list start');
1675: END IF;

Line 1793: Fnd_Msg_Pub.Count_And_Get (

1789: EXCEPTION
1790: WHEN Fnd_Api.G_EXC_ERROR THEN
1791: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1792: -- Standard call to get message count and if count=1, get the message
1793: Fnd_Msg_Pub.Count_And_Get (
1794: p_encoded => Fnd_Api.G_FALSE,
1795: p_count => x_msg_count,
1796: p_data => x_msg_data
1797: );

Line 1802: Fnd_Msg_Pub.Count_And_Get (

1798:
1799: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1800: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1801: -- Standard call to get message count and if count=1, get the message
1802: Fnd_Msg_Pub.Count_And_Get (
1803: p_encoded => Fnd_Api.G_FALSE,
1804: p_count => x_msg_count,
1805: p_data => x_msg_data
1806: );

Line 1853: Fnd_Msg_Pub.Count_And_Get (

1849: EXCEPTION
1850: WHEN Fnd_Api.G_EXC_ERROR THEN
1851: x_return_status := Fnd_Api.G_RET_STS_ERROR;
1852: -- Standard call to get message count and if count=1, get the message
1853: Fnd_Msg_Pub.Count_And_Get (
1854: p_encoded => Fnd_Api.G_FALSE,
1855: p_count => x_msg_count,
1856: p_data => x_msg_data
1857: );

Line 1862: Fnd_Msg_Pub.Count_And_Get (

1858:
1859: WHEN Fnd_Api.G_EXC_UNEXPECTED_ERROR THEN
1860: x_return_status := Fnd_Api.G_RET_STS_UNEXP_ERROR;
1861: -- Standard call to get message count and if count=1, get the message
1862: Fnd_Msg_Pub.Count_And_Get (
1863: p_encoded => Fnd_Api.G_FALSE,
1864: p_count => x_msg_count,
1865: p_data => x_msg_data
1866: );