DBA Data[Home] [Help]

APPS.AMS_MET_TPL_DTL_PVT dependencies on AMS_UTILITY_PVT

Line 88: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

84:
85: -- Debug Message
86: IF (AMS_DEBUG_HIGH_ON) THEN
87:
88: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
89: END IF;
90:
91: --sunkumar 30/01/2003
92: --check if the template is a seeded one

Line 96: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');

92: --check if the template is a seeded one
93: /* IF p_met_tpl_dtl_rec.metric_tpl_header_id < 10000 THEN
94: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
95: THEN
96: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
97: END IF;
98:
99: RAISE FND_API.G_EXC_ERROR;
100: END IF; */

Line 130: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

126: -- =========================================================================
127:
128: IF FND_GLOBAL.User_Id IS NULL
129: THEN
130: Ams_Utility_Pvt.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
131: RAISE FND_API.G_EXC_ERROR;
132: END IF;
133:
134: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 139: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl');

135: THEN
136: -- Debug message
137: IF (AMS_DEBUG_HIGH_ON) THEN
138:
139: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl');
140: END IF;
141:
142: -- Invoke validation procedures
143: Validate_met_tpl_dtl(

Line 162: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');

158:
159: -- Debug Message
160: IF (AMS_DEBUG_HIGH_ON) THEN
161:
162: Ams_Utility_Pvt.debug_message( 'Private API: Calling create table handler');
163: END IF;
164:
165: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Insert_Row)
166: Ams_Met_Tpl_Details_Pkg.Insert_Row(

Line 196: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

192:
193: -- Debug Message
194: IF (AMS_DEBUG_HIGH_ON) THEN
195:
196: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
197: END IF;
198:
199: -- Standard call to get message count and if count is 1, get message info.
200: FND_MSG_PUB.Count_And_Get

Line 206: WHEN Ams_Utility_Pvt.resource_locked THEN

202: p_data => x_msg_data
203: );
204: EXCEPTION
205:
206: WHEN Ams_Utility_Pvt.resource_locked THEN
207: x_return_status := FND_API.g_ret_sts_error;
208: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
209:
210: WHEN FND_API.G_EXC_ERROR THEN

Line 208: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

204: EXCEPTION
205:
206: WHEN Ams_Utility_Pvt.resource_locked THEN
207: x_return_status := FND_API.g_ret_sts_error;
208: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
209:
210: WHEN FND_API.G_EXC_ERROR THEN
211: ROLLBACK TO CREATE_Met_Tpl_Dtl_PVT;
212: x_return_status := FND_API.G_RET_STS_ERROR;

Line 306: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

302:
303: -- Debug Message
304: IF (AMS_DEBUG_HIGH_ON) THEN
305:
306: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
307: END IF;
308:
309:
310: -- Initialize API return status to SUCCESS

Line 316: Ams_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');

312:
313: -- Debug Message
314: IF (AMS_DEBUG_HIGH_ON) THEN
315:
316: Ams_Utility_Pvt.debug_message('Private API: - Open Cursor to Select');
317: END IF;
318:
319: OPEN c_get_Met_Tpl_Dtl( l_tar_met_tpl_dtl_rec.metric_template_detail_id);
320:

Line 325: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

321: FETCH c_get_Met_Tpl_Dtl INTO l_ref_met_tpl_dtl_rec;
322:
323: IF ( c_get_Met_Tpl_Dtl%NOTFOUND) THEN
324: CLOSE c_get_Met_Tpl_Dtl;
325: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
326: p_token_name => 'INFO',
327: p_token_value => 'Met_Tpl_Dtl');
328: RAISE FND_API.G_EXC_ERROR;
329: END IF;

Line 334: Ams_Utility_Pvt.debug_message('Private API: - Close Cursor');

330:
331: -- Debug Message
332: IF (AMS_DEBUG_HIGH_ON) THEN
333:
334: Ams_Utility_Pvt.debug_message('Private API: - Close Cursor');
335: END IF;
336: CLOSE c_get_Met_Tpl_Dtl;
337:
338: Complete_met_tpl_dtl_rec(l_ref_met_tpl_dtl_rec, l_tar_met_tpl_dtl_rec);

Line 342: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',

338: Complete_met_tpl_dtl_rec(l_ref_met_tpl_dtl_rec, l_tar_met_tpl_dtl_rec);
339:
340: IF (l_tar_met_tpl_dtl_rec.object_version_number IS NULL OR
341: l_tar_met_tpl_dtl_rec.object_version_number = FND_API.G_MISS_NUM ) THEN
342: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_VERSION_MISSING',
343: p_token_name => 'COLUMN',
344: p_token_value => 'Last_Update_Date');
345: RAISE FND_API.G_EXC_ERROR;
346: END IF;

Line 350: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',

346: END IF;
347:
348: -- Check Whether record has been changed by someone else
349: IF (l_tar_met_tpl_dtl_rec.object_version_number <> l_ref_met_tpl_dtl_rec.object_version_number) THEN
350: Ams_Utility_Pvt.Error_Message(p_message_name => 'API_RECORD_CHANGED',
351: p_token_name => 'INFO',
352: p_token_value => 'Met_Tpl_Dtl');
353: RAISE FND_API.G_EXC_ERROR;
354: END IF;

Line 366: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');

362: OR (l_tar_met_tpl_dtl_rec.metric_tpl_header_id <>l_ref_met_tpl_dtl_rec.metric_tpl_header_id))
363: AND (l_tar_met_tpl_dtl_rec.enabled_flag=l_ref_met_tpl_dtl_rec.enabled_flag)) THEN
364: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
365: THEN
366: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED_MOD');
367: END IF;
368:
369:
370: RAISE FND_API.G_EXC_ERROR;

Line 382: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl');

378: THEN
379: -- Debug message
380: IF (AMS_DEBUG_HIGH_ON) THEN
381:
382: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl');
383: END IF;
384:
385: -- Invoke validation procedures
386: Validate_met_tpl_dtl(

Line 398: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl: return status='||x_return_status);

394: x_msg_data => x_msg_data);
395: -- Debug message
396: IF (AMS_DEBUG_HIGH_ON) THEN
397:
398: Ams_Utility_Pvt.debug_message('Private API: Validate_Met_Tpl_Dtl: return status='||x_return_status);
399: END IF;
400: END IF;
401:
402: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN

Line 412: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');

408:
409: -- Debug Message
410: IF (AMS_DEBUG_HIGH_ON) THEN
411:
412: Ams_Utility_Pvt.debug_message('Private API: Calling update table handler');
413: END IF;
414:
415: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Update_Row)
416: Ams_Met_Tpl_Details_Pkg.Update_Row(

Line 440: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

436:
437: -- Debug Message
438: IF (AMS_DEBUG_HIGH_ON) THEN
439:
440: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
441: END IF;
442:
443: -- Standard call to get message count and if count is 1, get message info.
444: FND_MSG_PUB.Count_And_Get

Line 450: WHEN Ams_Utility_Pvt.resource_locked THEN

446: p_data => x_msg_data
447: );
448: EXCEPTION
449:
450: WHEN Ams_Utility_Pvt.resource_locked THEN
451: x_return_status := FND_API.g_ret_sts_error;
452: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
453:
454: WHEN FND_API.G_EXC_ERROR THEN

Line 452: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

448: EXCEPTION
449:
450: WHEN Ams_Utility_Pvt.resource_locked THEN
451: x_return_status := FND_API.g_ret_sts_error;
452: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
453:
454: WHEN FND_API.G_EXC_ERROR THEN
455: ROLLBACK TO UPDATE_Met_Tpl_Dtl_PVT;
456: x_return_status := FND_API.G_RET_STS_ERROR;

Line 529: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

525:
526: -- Debug Message
527: IF (AMS_DEBUG_HIGH_ON) THEN
528:
529: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
530: END IF;
531:
532: --sunkumar 30/01/2003
533: --check if the template is a seeded one

Line 537: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');

533: --check if the template is a seeded one
534: IF p_metric_template_detail_id < 10000 THEN
535: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error)
536: THEN
537: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_METR_TPL_SEEDED');
538: END IF;
539:
540: RAISE FND_API.G_EXC_ERROR;
541: END IF;

Line 552: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');

548: --
549: -- Debug Message
550: IF (AMS_DEBUG_HIGH_ON) THEN
551:
552: Ams_Utility_Pvt.debug_message( 'Private API: Calling delete table handler');
553: END IF;
554:
555: -- Invoke table handler(AMS_MET_TPL_DETAILS_PKG.Delete_Row)
556: Ams_Met_Tpl_Details_Pkg.Delete_Row(

Line 572: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');

568:
569: -- Debug Message
570: IF (AMS_DEBUG_HIGH_ON) THEN
571:
572: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': end');
573: END IF;
574:
575: -- Standard call to get message count and if count is 1, get message info.
576: FND_MSG_PUB.Count_And_Get

Line 582: WHEN Ams_Utility_Pvt.resource_locked THEN

578: p_data => x_msg_data
579: );
580: EXCEPTION
581:
582: WHEN Ams_Utility_Pvt.resource_locked THEN
583: x_return_status := FND_API.g_ret_sts_error;
584: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
585:
586: WHEN FND_API.G_EXC_ERROR THEN

Line 584: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

580: EXCEPTION
581:
582: WHEN Ams_Utility_Pvt.resource_locked THEN
583: x_return_status := FND_API.g_ret_sts_error;
584: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
585:
586: WHEN FND_API.G_EXC_ERROR THEN
587: ROLLBACK TO DELETE_Met_Tpl_Dtl_PVT;
588: x_return_status := FND_API.G_RET_STS_ERROR;

Line 654: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');

650:
651: -- Debug Message
652: IF (AMS_DEBUG_HIGH_ON) THEN
653:
654: Ams_Utility_Pvt.debug_message('Private API: ' || l_api_name || ': start');
655: END IF;
656:
657: -- Initialize message list if p_init_msg_list is set to TRUE.
658: IF FND_API.to_Boolean( p_init_msg_list )

Line 683: Ams_Utility_Pvt.debug_message(l_full_name||': start');

679: IF (AMS_DEBUG_HIGH_ON) THEN
680:
681:
682:
683: Ams_Utility_Pvt.debug_message(l_full_name||': start');
684:
685: END IF;
686: OPEN c_Met_Tpl_Dtl;
687:

Line 708: Ams_Utility_Pvt.debug_message(l_full_name ||': end');

704: p_count => x_msg_count,
705: p_data => x_msg_data);
706: IF (AMS_DEBUG_HIGH_ON) THEN
707:
708: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
709: END IF;
710: EXCEPTION
711:
712: WHEN Ams_Utility_Pvt.resource_locked THEN

Line 712: WHEN Ams_Utility_Pvt.resource_locked THEN

708: Ams_Utility_Pvt.debug_message(l_full_name ||': end');
709: END IF;
710: EXCEPTION
711:
712: WHEN Ams_Utility_Pvt.resource_locked THEN
713: x_return_status := FND_API.g_ret_sts_error;
714: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
715:
716: WHEN FND_API.G_EXC_ERROR THEN

Line 714: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

710: EXCEPTION
711:
712: WHEN Ams_Utility_Pvt.resource_locked THEN
713: x_return_status := FND_API.g_ret_sts_error;
714: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
715:
716: WHEN FND_API.G_EXC_ERROR THEN
717: ROLLBACK TO LOCK_Met_Tpl_Dtl_PVT;
718: x_return_status := FND_API.G_RET_STS_ERROR;

Line 768: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(

764:
765: BEGIN
766: x_return_status := FND_API.g_ret_sts_success;
767: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
768: l_valid_flag := Ams_Utility_Pvt.check_uniqueness(
769: 'AMS_MET_TPL_DETAILS',
770: 'METRIC_TEMPLATE_DETAIL_ID = ' || p_met_tpl_dtl_rec.METRIC_TEMPLATE_DETAIL_ID
771: );
772: END IF;

Line 775: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_ID_DUP');

771: );
772: END IF;
773:
774: IF l_valid_flag = FND_API.g_false THEN
775: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_ID_DUP');
776: x_return_status := FND_API.g_ret_sts_error;
777: RETURN;
778: END IF;
779:

Line 784: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_DUP_METRIC_ID');

780: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
781: OPEN c_check_duplicate(p_met_tpl_dtl_rec.metric_id, p_met_tpl_dtl_rec.metric_tpl_header_id);
782: FETCH c_check_duplicate INTO l_dummy;
783: IF c_check_duplicate%FOUND THEN
784: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_DUP_METRIC_ID');
785: x_return_status := FND_API.g_ret_sts_error;
786: END IF;
787: CLOSE c_check_duplicate;
788: END IF;

Line 834: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_MET_TPL_DTL_ID');

830:
831: ELSE -- Update
832:
833: IF p_met_tpl_dtl_rec.metric_template_detail_id IS NULL THEN
834: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_MET_TPL_DTL_ID');
835: x_return_status := FND_API.g_ret_sts_error;
836: RETURN;
837: END IF;
838:

Line 840: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_METRIC_TPL_HEADER_ID');

836: RETURN;
837: END IF;
838:
839: IF p_met_tpl_dtl_rec.metric_tpl_header_id IS NULL THEN
840: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_METRIC_TPL_HEADER_ID');
841: x_return_status := FND_API.g_ret_sts_error;
842: RETURN;
843: END IF;
844:

Line 847: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_METRIC_ID');

843: END IF;
844:
845:
846: IF p_met_tpl_dtl_rec.metric_id IS NULL THEN
847: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_METRIC_ID');
848: x_return_status := FND_API.g_ret_sts_error;
849: RETURN;
850: END IF;
851:

Line 854: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_ENABLED_FLAG');

850: END IF;
851:
852:
853: IF p_met_tpl_dtl_rec.enabled_flag IS NULL THEN
854: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_MTD_NO_ENABLED_FLAG');
855: x_return_status := FND_API.g_ret_sts_error;
856: RETURN;
857: END IF;
858: END IF;

Line 888: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_HEADER_ID');

884: -- Validate metric_tpl_header_id exists.
885: OPEN c_check_header_id(p_met_tpl_dtl_rec.metric_tpl_header_id);
886: FETCH c_check_header_id INTO l_dummy;
887: IF c_check_header_id%NOTFOUND THEN
888: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_HEADER_ID');
889: x_return_status := FND_API.g_ret_sts_error;
890: END IF;
891: CLOSE c_check_header_id;
892:

Line 897: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_METRIC_ID');

893: -- Validate the metric_id exists and is FUNCTION or MANUAL
894: OPEN c_check_metric(p_met_tpl_dtl_rec.metric_id);
895: FETCH c_check_metric INTO l_dummy;
896: IF c_check_metric%NOTFOUND THEN
897: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_METRIC_ID');
898: x_return_status := FND_API.g_ret_sts_error;
899: END IF;
900: CLOSE c_check_metric;
901:

Line 913: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_dtl_rec.enabled_flag) = FND_API.G_FALSE THEN

909: BEGIN
910: x_return_status := FND_API.g_ret_sts_success;
911:
912: -- Enter custom code here
913: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_dtl_rec.enabled_flag) = FND_API.G_FALSE THEN
914: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_ENABLED_FLAG');
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;
917:

Line 914: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_ENABLED_FLAG');

910: x_return_status := FND_API.g_ret_sts_success;
911:
912: -- Enter custom code here
913: IF Ams_Utility_Pvt.is_y_or_n(p_met_tpl_dtl_rec.enabled_flag) = FND_API.G_FALSE THEN
914: Ams_Utility_Pvt.error_message(p_message_name => 'AMS_MTD_BAD_ENABLED_FLAG');
915: x_return_status := FND_API.g_ret_sts_error;
916: END IF;
917:
918: END check_met_tpl_dtl_Lookup_items;

Line 1114: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');

1110:
1111: -- Debug Message
1112: IF (AMS_DEBUG_HIGH_ON) THEN
1113:
1114: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': START');
1115: END IF;
1116:
1117:
1118: -- Initialize API return status to SUCCESS

Line 1125: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');

1121:
1122: -- Debug Message
1123: IF (AMS_DEBUG_HIGH_ON) THEN
1124:
1125: Ams_Utility_Pvt.debug_message('PRIVATE API: ' || l_api_name || ': END');
1126: END IF;
1127:
1128: -- Standard call to get message count and if count is 1, get message info.
1129: FND_MSG_PUB.Count_And_Get

Line 1135: WHEN Ams_Utility_Pvt.resource_locked THEN

1131: p_data => x_msg_data
1132: );
1133: EXCEPTION
1134:
1135: WHEN Ams_Utility_Pvt.resource_locked THEN
1136: x_return_status := FND_API.g_ret_sts_error;
1137: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN

Line 1137: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1133: EXCEPTION
1134:
1135: WHEN Ams_Utility_Pvt.resource_locked THEN
1136: x_return_status := FND_API.g_ret_sts_error;
1137: Ams_Utility_Pvt.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1138:
1139: WHEN FND_API.G_EXC_ERROR THEN
1140: ROLLBACK TO VALIDATE_Met_Tpl_Dtl_;
1141: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1202: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_dtl_rec');

1198:
1199: -- Debug Message
1200: IF (AMS_DEBUG_HIGH_ON) THEN
1201:
1202: Ams_Utility_Pvt.debug_message('PRIVATE API: Validate_met_tpl_dtl_rec');
1203: END IF;
1204: -- Standard call to get message count and if count is 1, get message info.
1205: FND_MSG_PUB.Count_And_Get
1206: (p_count => x_msg_count,