DBA Data[Home] [Help]

APPS.AMS_SYSTEM_PRETTY_URL_PVT dependencies on AMS_UTILITY_PVT

Line 76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

72: FND_MSG_PUB.initialize;
73: END IF;
74:
75: -- Debug Message
76: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
77:
78:
79: -- Initialize API return status to SUCCESS
80: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 104: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');

100: -- =========================================================================
101:
102: IF FND_GLOBAL.User_Id IS NULL
103: THEN
104: AMS_Utility_PVT.Error_Message(p_message_name => 'USER_PROFILE_MISSING');
105: RAISE FND_API.G_EXC_ERROR;
106: END IF;
107:
108: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)

Line 111: AMS_UTILITY_PVT.debug_message('Private API: Validate_System_Pretty_Url');

107:
108: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
109: THEN
110: -- Debug message
111: AMS_UTILITY_PVT.debug_message('Private API: Validate_System_Pretty_Url');
112:
113: -- Invoke validation procedures
114: Validate_system_pretty_url(
115: p_api_version_number => 1.0,

Line 130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');

126: END IF;
127:
128:
129: -- Debug Message
130: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
131:
132: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row)
133: AMS_SYSTEM_PRETTY_URL_PKG.Insert_Row(
134: px_system_url_id => l_system_url_id,

Line 163: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

159: END IF;
160:
161:
162: -- Debug Message
163: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
164:
165: -- Standard call to get message count and if count is 1, get message info.
166: FND_MSG_PUB.Count_And_Get
167: (p_count => x_msg_count,

Line 172: WHEN AMS_Utility_PVT.resource_locked THEN

168: p_data => x_msg_data
169: );
170: EXCEPTION
171:
172: WHEN AMS_Utility_PVT.resource_locked THEN
173: x_return_status := FND_API.g_ret_sts_error;
174: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
175:
176: WHEN FND_API.G_EXC_ERROR THEN

Line 174: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

170: EXCEPTION
171:
172: WHEN AMS_Utility_PVT.resource_locked THEN
173: x_return_status := FND_API.g_ret_sts_error;
174: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
175:
176: WHEN FND_API.G_EXC_ERROR THEN
177: ROLLBACK TO CREATE_System_Pretty_Url_PVT;
178: x_return_status := FND_API.G_RET_STS_ERROR;

Line 260: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

256: FND_MSG_PUB.initialize;
257: END IF;
258:
259: -- Debug Message
260: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
261:
262:
263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 267: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');

263: -- Initialize API return status to SUCCESS
264: x_return_status := FND_API.G_RET_STS_SUCCESS;
265:
266: -- Debug Message
267: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
268:
269: /*
270: OPEN c_get_System_Pretty_Url( l_tar_system_pretty_url_rec.system_url_id);
271:

Line 275: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',

271:
272: FETCH c_get_System_Pretty_Url INTO l_ref_system_pretty_url_rec ;
273:
274: If ( c_get_System_Pretty_Url%NOTFOUND) THEN
275: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
276: p_token_name => 'INFO',
277: p_token_value => 'System_Pretty_Url') ;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;

Line 281: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');

277: p_token_value => 'System_Pretty_Url') ;
278: RAISE FND_API.G_EXC_ERROR;
279: END IF;
280: -- Debug Message
281: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
282: CLOSE c_get_System_Pretty_Url;
283: */
284:
285:

Line 288: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',

284:
285:
286: If (l_tar_system_pretty_url_rec.object_version_number is NULL or
287: l_tar_system_pretty_url_rec.object_version_number = FND_API.G_MISS_NUM ) Then
288: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
289: p_token_name => 'COLUMN',
290: p_token_value => 'Last_Update_Date') ;
291: raise FND_API.G_EXC_ERROR;
292: End if;

Line 295: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',

291: raise FND_API.G_EXC_ERROR;
292: End if;
293: -- Check Whether record has been changed by someone else
294: If (l_tar_system_pretty_url_rec.object_version_number <> l_ref_system_pretty_url_rec.object_version_number) Then
295: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
296: p_token_name => 'INFO',
297: p_token_value => 'System_Pretty_Url') ;
298: raise FND_API.G_EXC_ERROR;
299: End if;

Line 303: AMS_UTILITY_PVT.debug_message('Private API: Validate_System_Pretty_Url');

299: End if;
300: IF ( P_validation_level >= FND_API.G_VALID_LEVEL_FULL)
301: THEN
302: -- Debug message
303: AMS_UTILITY_PVT.debug_message('Private API: Validate_System_Pretty_Url');
304:
305: -- Invoke validation procedures
306: Validate_system_pretty_url(
307: p_api_version_number => 1.0,

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

318: END IF;
319:
320:
321: -- Debug Message
322: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
323:
324: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Update_Row)
325: AMS_SYSTEM_PRETTY_URL_PKG.Update_Row(
326: p_system_url_id => p_system_pretty_url_rec.system_url_id,

Line 350: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

346: END IF;
347:
348:
349: -- Debug Message
350: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
351:
352: -- Standard call to get message count and if count is 1, get message info.
353: FND_MSG_PUB.Count_And_Get
354: (p_count => x_msg_count,

Line 359: WHEN AMS_Utility_PVT.resource_locked THEN

355: p_data => x_msg_data
356: );
357: EXCEPTION
358:
359: WHEN AMS_Utility_PVT.resource_locked THEN
360: x_return_status := FND_API.g_ret_sts_error;
361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
362:
363: WHEN FND_API.G_EXC_ERROR THEN

Line 361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

357: EXCEPTION
358:
359: WHEN AMS_Utility_PVT.resource_locked THEN
360: x_return_status := FND_API.g_ret_sts_error;
361: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
362:
363: WHEN FND_API.G_EXC_ERROR THEN
364: ROLLBACK TO UPDATE_System_Pretty_Url_PVT;
365: x_return_status := FND_API.G_RET_STS_ERROR;

Line 436: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

432: FND_MSG_PUB.initialize;
433: END IF;
434:
435: -- Debug Message
436: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
437:
438:
439: -- Initialize API return status to SUCCESS
440: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 446: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');

442: --
443: -- Api body
444: --
445: -- Debug Message
446: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
447:
448: -- Invoke table handler(AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row)
449: AMS_SYSTEM_PRETTY_URL_PKG.Delete_Row(
450: p_SYSTEM_URL_ID => p_SYSTEM_URL_ID);

Line 463: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

459: END IF;
460:
461:
462: -- Debug Message
463: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
464:
465: -- Standard call to get message count and if count is 1, get message info.
466: FND_MSG_PUB.Count_And_Get
467: (p_count => x_msg_count,

Line 472: WHEN AMS_Utility_PVT.resource_locked THEN

468: p_data => x_msg_data
469: );
470: EXCEPTION
471:
472: WHEN AMS_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN

Line 474: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

470: EXCEPTION
471:
472: WHEN AMS_Utility_PVT.resource_locked THEN
473: x_return_status := FND_API.g_ret_sts_error;
474: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
475:
476: WHEN FND_API.G_EXC_ERROR THEN
477: ROLLBACK TO DELETE_System_Pretty_Url_PVT;
478: x_return_status := FND_API.G_RET_STS_ERROR;

Line 542: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

538:
539: BEGIN
540:
541: -- Debug Message
542: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
543:
544: -- Initialize message list if p_init_msg_list is set to TRUE.
545: IF FND_API.to_Boolean( p_init_msg_list )
546: THEN

Line 566: AMS_Utility_PVT.debug_message(l_full_name||': start');

562:
563:
564: ------------------------ lock -------------------------
565:
566: AMS_Utility_PVT.debug_message(l_full_name||': start');
567: OPEN c_System_Pretty_Url;
568:
569: FETCH c_System_Pretty_Url INTO l_SYSTEM_URL_ID;
570:

Line 587: AMS_Utility_PVT.debug_message(l_full_name ||': end');

583: FND_MSG_PUB.count_and_get(
584: p_encoded => FND_API.g_false,
585: p_count => x_msg_count,
586: p_data => x_msg_data);
587: AMS_Utility_PVT.debug_message(l_full_name ||': end');
588: EXCEPTION
589:
590: WHEN AMS_Utility_PVT.resource_locked THEN
591: x_return_status := FND_API.g_ret_sts_error;

Line 590: WHEN AMS_Utility_PVT.resource_locked THEN

586: p_data => x_msg_data);
587: AMS_Utility_PVT.debug_message(l_full_name ||': end');
588: EXCEPTION
589:
590: WHEN AMS_Utility_PVT.resource_locked THEN
591: x_return_status := FND_API.g_ret_sts_error;
592: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
593:
594: WHEN FND_API.G_EXC_ERROR THEN

Line 592: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

588: EXCEPTION
589:
590: WHEN AMS_Utility_PVT.resource_locked THEN
591: x_return_status := FND_API.g_ret_sts_error;
592: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
593:
594: WHEN FND_API.G_EXC_ERROR THEN
595: ROLLBACK TO LOCK_System_Pretty_Url_PVT;
596: x_return_status := FND_API.G_RET_STS_ERROR;

Line 640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

636:
637: BEGIN
638: x_return_status := FND_API.g_ret_sts_success;
639: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
640: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
641: 'AMS_SYSTEM_PRETTY_URL',
642: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||''''
643: );
644: ELSE

Line 645: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

641: 'AMS_SYSTEM_PRETTY_URL',
642: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||''''
643: );
644: ELSE
645: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
646: 'AMS_SYSTEM_PRETTY_URL',
647: 'SYSTEM_URL_ID = ''' || p_system_pretty_url_rec.SYSTEM_URL_ID ||
648: ''' AND SYSTEM_URL_ID <> ' || p_system_pretty_url_rec.SYSTEM_URL_ID
649: );

Line 653: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SYSTEM_URL_ID_DUPLICATE');

649: );
650: END IF;
651:
652: IF l_valid_flag = FND_API.g_false THEN
653: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_SYSTEM_URL_ID_DUPLICATE');
654: x_return_status := FND_API.g_ret_sts_error;
655: RETURN;
656: END IF;
657:

Line 673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');

669: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
670:
671:
672: IF p_system_pretty_url_rec.system_url_id = FND_API.g_miss_num OR p_system_pretty_url_rec.system_url_id IS NULL THEN
673: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');
674: x_return_status := FND_API.g_ret_sts_error;
675: RETURN;
676: END IF;
677:

Line 680: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');

676: END IF;
677:
678:
679: IF p_system_pretty_url_rec.creation_date = FND_API.g_miss_date OR p_system_pretty_url_rec.creation_date IS NULL THEN
680: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');
681: x_return_status := FND_API.g_ret_sts_error;
682: RETURN;
683: END IF;
684:

Line 687: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');

683: END IF;
684:
685:
686: IF p_system_pretty_url_rec.created_by = FND_API.g_miss_num OR p_system_pretty_url_rec.created_by IS NULL THEN
687: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');
688: x_return_status := FND_API.g_ret_sts_error;
689: RETURN;
690: END IF;
691:

Line 694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

690: END IF;
691:
692:
693: IF p_system_pretty_url_rec.last_update_date = FND_API.g_miss_date OR p_system_pretty_url_rec.last_update_date IS NULL THEN
694: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');
695: x_return_status := FND_API.g_ret_sts_error;
696: RETURN;
697: END IF;
698:

Line 701: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

697: END IF;
698:
699:
700: IF p_system_pretty_url_rec.last_updated_by = FND_API.g_miss_num OR p_system_pretty_url_rec.last_updated_by IS NULL THEN
701: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');
702: x_return_status := FND_API.g_ret_sts_error;
703: RETURN;
704: END IF;
705:

Line 708: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');

704: END IF;
705:
706:
707: IF p_system_pretty_url_rec.pretty_url_id = FND_API.g_miss_num OR p_system_pretty_url_rec.pretty_url_id IS NULL THEN
708: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');
709: x_return_status := FND_API.g_ret_sts_error;
710: RETURN;
711: END IF;
712:

Line 715: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');

711: END IF;
712:
713:
714: IF p_system_pretty_url_rec.system_url = FND_API.g_miss_char OR p_system_pretty_url_rec.system_url IS NULL THEN
715: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');
716: x_return_status := FND_API.g_ret_sts_error;
717: RETURN;
718: END IF;
719: ELSE

Line 723: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');

719: ELSE
720:
721:
722: IF p_system_pretty_url_rec.system_url_id IS NULL THEN
723: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url_id');
724: x_return_status := FND_API.g_ret_sts_error;
725: RETURN;
726: END IF;
727:

Line 730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');

726: END IF;
727:
728:
729: IF p_system_pretty_url_rec.creation_date IS NULL THEN
730: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_creation_date');
731: x_return_status := FND_API.g_ret_sts_error;
732: RETURN;
733: END IF;
734:

Line 737: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');

733: END IF;
734:
735:
736: IF p_system_pretty_url_rec.created_by IS NULL THEN
737: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_created_by');
738: x_return_status := FND_API.g_ret_sts_error;
739: RETURN;
740: END IF;
741:

Line 744: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');

740: END IF;
741:
742:
743: IF p_system_pretty_url_rec.last_update_date IS NULL THEN
744: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_update_date');
745: x_return_status := FND_API.g_ret_sts_error;
746: RETURN;
747: END IF;
748:

Line 751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');

747: END IF;
748:
749:
750: IF p_system_pretty_url_rec.last_updated_by IS NULL THEN
751: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_last_updated_by');
752: x_return_status := FND_API.g_ret_sts_error;
753: RETURN;
754: END IF;
755:

Line 758: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');

754: END IF;
755:
756:
757: IF p_system_pretty_url_rec.pretty_url_id IS NULL THEN
758: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_pretty_url_id');
759: x_return_status := FND_API.g_ret_sts_error;
760: RETURN;
761: END IF;
762:

Line 765: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');

761: END IF;
762:
763:
764: IF p_system_pretty_url_rec.system_url IS NULL THEN
765: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_system_pretty_url_NO_system_url');
766: x_return_status := FND_API.g_ret_sts_error;
767: RETURN;
768: END IF;
769: END IF;

Line 995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

991: END IF;
992:
993:
994: -- Debug Message
995: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
996:
997:
998: -- Initialize API return status to SUCCESS
999: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1003: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');

999: x_return_status := FND_API.G_RET_STS_SUCCESS;
1000:
1001:
1002: -- Debug Message
1003: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1004:
1005: -- Standard call to get message count and if count is 1, get message info.
1006: FND_MSG_PUB.Count_And_Get
1007: (p_count => x_msg_count,

Line 1012: WHEN AMS_Utility_PVT.resource_locked THEN

1008: p_data => x_msg_data
1009: );
1010: EXCEPTION
1011:
1012: WHEN AMS_Utility_PVT.resource_locked THEN
1013: x_return_status := FND_API.g_ret_sts_error;
1014: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1015:
1016: WHEN FND_API.G_EXC_ERROR THEN

Line 1014: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');

1010: EXCEPTION
1011:
1012: WHEN AMS_Utility_PVT.resource_locked THEN
1013: x_return_status := FND_API.g_ret_sts_error;
1014: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1015:
1016: WHEN FND_API.G_EXC_ERROR THEN
1017: ROLLBACK TO VALIDATE_System_Pretty_Url_;
1018: x_return_status := FND_API.G_RET_STS_ERROR;

Line 1077: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');

1073: -- THEN
1074: -- x_return_status := FND_API.G_RET_STS_ERROR;
1075:
1076: -- Debug Message
1077: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1078: -- Standard call to get message count and if count is 1, get message info.
1079: FND_MSG_PUB.Count_And_Get
1080: (p_count => x_msg_count,
1081: p_data => x_msg_data