DBA Data[Home] [Help]

APPS.AMS_LIST_GROUP_PVT dependencies on AMS_UTILITY_PVT

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

73:
74: -- Debug Message
75: IF (AMS_DEBUG_HIGH_ON) THEN
76:
77: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
78: END IF;
79:
80:
81: -- Initialize API return status to SUCCESS

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

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

Line 115: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Group');

111: THEN
112: -- Debug message
113: IF (AMS_DEBUG_HIGH_ON) THEN
114:
115: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Group');
116: END IF;
117:
118: -- Invoke validation procedures
119: Validate_list_group(

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

133:
134: -- Debug Message
135: IF (AMS_DEBUG_HIGH_ON) THEN
136:
137: AMS_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
138: END IF;
139:
140: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Insert_Row)
141: AMS_ACT_LIST_GROUPS_PKG.Insert_Row(

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

179:
180: -- Debug Message
181: IF (AMS_DEBUG_HIGH_ON) THEN
182:
183: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
184: END IF;
185:
186: -- Standard call to get message count and if count is 1, get message info.
187: FND_MSG_PUB.Count_And_Get

Line 193: WHEN AMS_Utility_PVT.resource_locked THEN

189: p_data => x_msg_data
190: );
191: EXCEPTION
192:
193: WHEN AMS_Utility_PVT.resource_locked THEN
194: x_return_status := FND_API.g_ret_sts_error;
195: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
196:
197: WHEN FND_API.G_EXC_ERROR THEN

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

191: EXCEPTION
192:
193: WHEN AMS_Utility_PVT.resource_locked THEN
194: x_return_status := FND_API.g_ret_sts_error;
195: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
196:
197: WHEN FND_API.G_EXC_ERROR THEN
198: ROLLBACK TO CREATE_List_Group_PVT;
199: x_return_status := FND_API.G_RET_STS_ERROR;

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

279:
280: -- Debug Message
281: IF (AMS_DEBUG_HIGH_ON) THEN
282:
283: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
284: END IF;
285:
286:
287: -- Initialize API return status to SUCCESS

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

289:
290: -- Debug Message
291: IF (AMS_DEBUG_HIGH_ON) THEN
292:
293: AMS_UTILITY_PVT.debug_message('Private API: - Open Cursor to Select');
294: END IF;
295:
296: OPEN c_get_List_Group( l_tar_list_group_rec.act_list_group_id);
297:

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

297:
298: FETCH c_get_List_Group INTO l_ref_list_group_rec ;
299:
300: If ( c_get_List_Group%NOTFOUND) THEN
301: AMS_Utility_PVT.Error_Message(p_message_name => 'API_MISSING_UPDATE_TARGET',
302: p_token_name => 'INFO',
303: p_token_value => 'List_Group') ;
304: RAISE FND_API.G_EXC_ERROR;
305: END IF;

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

305: END IF;
306: -- Debug Message
307: IF (AMS_DEBUG_HIGH_ON) THEN
308:
309: AMS_UTILITY_PVT.debug_message('Private API: - Close Cursor');
310: END IF;
311: CLOSE c_get_List_Group;
312:
313:

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

312:
313:
314: If (l_tar_list_group_rec.object_version_number is NULL or
315: l_tar_list_group_rec.object_version_number = FND_API.G_MISS_NUM ) Then
316: AMS_Utility_PVT.Error_Message(p_message_name => 'API_VERSION_MISSING',
317: p_token_name => 'COLUMN',
318: p_token_value => 'Last_Update_Date') ;
319: raise FND_API.G_EXC_ERROR;
320: End if;

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

319: raise FND_API.G_EXC_ERROR;
320: End if;
321: -- Check Whether record has been changed by someone else
322: If (l_tar_list_group_rec.object_version_number <> l_ref_list_group_rec.object_version_number) Then
323: AMS_Utility_PVT.Error_Message(p_message_name => 'API_RECORD_CHANGED',
324: p_token_name => 'INFO',
325: p_token_value => 'List_Group') ;
326: raise FND_API.G_EXC_ERROR;
327: End if;

Line 333: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Group');

329: THEN
330: -- Debug message
331: IF (AMS_DEBUG_HIGH_ON) THEN
332:
333: AMS_UTILITY_PVT.debug_message('Private API: Validate_List_Group');
334: END IF;
335:
336: -- Invoke validation procedures
337: Validate_list_group(

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

351:
352: -- Debug Message
353: IF (AMS_DEBUG_HIGH_ON) THEN
354:
355: AMS_UTILITY_PVT.debug_message(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW, 'Private API: Calling update table handler');
356: END IF;
357:
358: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Update_Row)
359: AMS_ACT_LIST_GROUPS_PKG.Update_Row(

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

393:
394: -- Debug Message
395: IF (AMS_DEBUG_HIGH_ON) THEN
396:
397: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
398: END IF;
399:
400: -- Standard call to get message count and if count is 1, get message info.
401: FND_MSG_PUB.Count_And_Get

Line 407: WHEN AMS_Utility_PVT.resource_locked THEN

403: p_data => x_msg_data
404: );
405: EXCEPTION
406:
407: WHEN AMS_Utility_PVT.resource_locked THEN
408: x_return_status := FND_API.g_ret_sts_error;
409: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
410:
411: WHEN FND_API.G_EXC_ERROR THEN

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

405: EXCEPTION
406:
407: WHEN AMS_Utility_PVT.resource_locked THEN
408: x_return_status := FND_API.g_ret_sts_error;
409: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
410:
411: WHEN FND_API.G_EXC_ERROR THEN
412: ROLLBACK TO UPDATE_List_Group_PVT;
413: x_return_status := FND_API.G_RET_STS_ERROR;

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

482:
483: -- Debug Message
484: IF (AMS_DEBUG_HIGH_ON) THEN
485:
486: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
487: END IF;
488:
489:
490: -- Initialize API return status to SUCCESS

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

495: --
496: -- Debug Message
497: IF (AMS_DEBUG_HIGH_ON) THEN
498:
499: AMS_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
500: END IF;
501:
502: -- Invoke table handler(AMS_ACT_LIST_GROUPS_PKG.Delete_Row)
503: AMS_ACT_LIST_GROUPS_PKG.Delete_Row(

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

515:
516: -- Debug Message
517: IF (AMS_DEBUG_HIGH_ON) THEN
518:
519: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
520: END IF;
521:
522: -- Standard call to get message count and if count is 1, get message info.
523: FND_MSG_PUB.Count_And_Get

Line 529: WHEN AMS_Utility_PVT.resource_locked THEN

525: p_data => x_msg_data
526: );
527: EXCEPTION
528:
529: WHEN AMS_Utility_PVT.resource_locked THEN
530: x_return_status := FND_API.g_ret_sts_error;
531: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
532:
533: WHEN FND_API.G_EXC_ERROR THEN

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

527: EXCEPTION
528:
529: WHEN AMS_Utility_PVT.resource_locked THEN
530: x_return_status := FND_API.g_ret_sts_error;
531: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
532:
533: WHEN FND_API.G_EXC_ERROR THEN
534: ROLLBACK TO DELETE_List_Group_PVT;
535: x_return_status := FND_API.G_RET_STS_ERROR;

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

597:
598: -- Debug Message
599: IF (AMS_DEBUG_HIGH_ON) THEN
600:
601: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
602: END IF;
603:
604: -- Initialize message list if p_init_msg_list is set to TRUE.
605: IF FND_API.to_Boolean( p_init_msg_list )

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

626: IF (AMS_DEBUG_HIGH_ON) THEN
627:
628:
629:
630: AMS_Utility_PVT.debug_message(l_full_name||': start');
631:
632: END IF;
633: OPEN c_List_Group;
634:

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

651: p_count => x_msg_count,
652: p_data => x_msg_data);
653: IF (AMS_DEBUG_HIGH_ON) THEN
654:
655: AMS_Utility_PVT.debug_message(l_full_name ||': end');
656: END IF;
657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN

Line 659: WHEN AMS_Utility_PVT.resource_locked THEN

655: AMS_Utility_PVT.debug_message(l_full_name ||': end');
656: END IF;
657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN

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

657: EXCEPTION
658:
659: WHEN AMS_Utility_PVT.resource_locked THEN
660: x_return_status := FND_API.g_ret_sts_error;
661: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
662:
663: WHEN FND_API.G_EXC_ERROR THEN
664: ROLLBACK TO LOCK_List_Group_PVT;
665: x_return_status := FND_API.G_RET_STS_ERROR;

Line 709: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

705:
706: BEGIN
707: x_return_status := FND_API.g_ret_sts_success;
708: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
709: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
710: 'AMS_ACT_LIST_GROUPS',
711: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||''''
712: );
713: ELSE

Line 714: l_valid_flag := AMS_Utility_PVT.check_uniqueness(

710: 'AMS_ACT_LIST_GROUPS',
711: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||''''
712: );
713: ELSE
714: l_valid_flag := AMS_Utility_PVT.check_uniqueness(
715: 'AMS_ACT_LIST_GROUPS',
716: 'ACT_LIST_GROUP_ID = ''' || p_list_group_rec.ACT_LIST_GROUP_ID ||
717: ''' AND ACT_LIST_GROUP_ID <> ' || p_list_group_rec.ACT_LIST_GROUP_ID
718: );

Line 722: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ACT_LIST_GROUP_ID_DUPLICATE');

718: );
719: END IF;
720:
721: IF l_valid_flag = FND_API.g_false THEN
722: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_ACT_LIST_GROUP_ID_DUPLICATE');
723: x_return_status := FND_API.g_ret_sts_error;
724: RETURN;
725: END IF;
726:

Line 742: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_group_id');

738: IF p_validation_mode = JTF_PLSQL_API.g_create THEN
739:
740:
741: IF p_list_group_rec.act_list_group_id = FND_API.g_miss_num OR p_list_group_rec.act_list_group_id IS NULL THEN
742: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_group_id');
743: x_return_status := FND_API.g_ret_sts_error;
744: RETURN;
745: END IF;
746:

Line 749: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_used_by_id');

745: END IF;
746:
747:
748: IF p_list_group_rec.act_list_used_by_id = FND_API.g_miss_num OR p_list_group_rec.act_list_used_by_id IS NULL THEN
749: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_used_by_id');
750: x_return_status := FND_API.g_ret_sts_error;
751: RETURN;
752: END IF;
753:

Line 756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_arc_act_list_used_by');

752: END IF;
753:
754:
755: IF p_list_group_rec.arc_act_list_used_by = FND_API.g_miss_char OR p_list_group_rec.arc_act_list_used_by IS NULL THEN
756: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_arc_act_list_used_by');
757: x_return_status := FND_API.g_ret_sts_error;
758: RETURN;
759: END IF;
760:

Line 763: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_group_code');

759: END IF;
760:
761:
762: IF p_list_group_rec.group_code = FND_API.g_miss_char OR p_list_group_rec.group_code IS NULL THEN
763: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_group_code');
764: x_return_status := FND_API.g_ret_sts_error;
765: RETURN;
766: END IF;
767:

Line 770: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_update_date');

766: END IF;
767:
768:
769: IF p_list_group_rec.last_update_date = FND_API.g_miss_date OR p_list_group_rec.last_update_date IS NULL THEN
770: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_update_date');
771: x_return_status := FND_API.g_ret_sts_error;
772: RETURN;
773: END IF;
774:

Line 777: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_updated_by');

773: END IF;
774:
775:
776: IF p_list_group_rec.last_updated_by = FND_API.g_miss_num OR p_list_group_rec.last_updated_by IS NULL THEN
777: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_updated_by');
778: x_return_status := FND_API.g_ret_sts_error;
779: RETURN;
780: END IF;
781:

Line 784: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_creation_date');

780: END IF;
781:
782:
783: IF p_list_group_rec.creation_date = FND_API.g_miss_date OR p_list_group_rec.creation_date IS NULL THEN
784: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_creation_date');
785: x_return_status := FND_API.g_ret_sts_error;
786: RETURN;
787: END IF;
788:

Line 791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_created_by');

787: END IF;
788:
789:
790: IF p_list_group_rec.created_by = FND_API.g_miss_num OR p_list_group_rec.created_by IS NULL THEN
791: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_created_by');
792: x_return_status := FND_API.g_ret_sts_error;
793: RETURN;
794: END IF;
795: ELSE

Line 799: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_group_id');

795: ELSE
796:
797:
798: IF p_list_group_rec.act_list_group_id IS NULL THEN
799: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_group_id');
800: x_return_status := FND_API.g_ret_sts_error;
801: RETURN;
802: END IF;
803:

Line 806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_used_by_id');

802: END IF;
803:
804:
805: IF p_list_group_rec.act_list_used_by_id IS NULL THEN
806: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_act_list_used_by_id');
807: x_return_status := FND_API.g_ret_sts_error;
808: RETURN;
809: END IF;
810:

Line 813: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_arc_act_list_used_by');

809: END IF;
810:
811:
812: IF p_list_group_rec.arc_act_list_used_by IS NULL THEN
813: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_arc_act_list_used_by');
814: x_return_status := FND_API.g_ret_sts_error;
815: RETURN;
816: END IF;
817:

Line 820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_group_code');

816: END IF;
817:
818:
819: IF p_list_group_rec.group_code IS NULL THEN
820: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_group_code');
821: x_return_status := FND_API.g_ret_sts_error;
822: RETURN;
823: END IF;
824:

Line 827: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_update_date');

823: END IF;
824:
825:
826: IF p_list_group_rec.last_update_date IS NULL THEN
827: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_update_date');
828: x_return_status := FND_API.g_ret_sts_error;
829: RETURN;
830: END IF;
831:

Line 834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_updated_by');

830: END IF;
831:
832:
833: IF p_list_group_rec.last_updated_by IS NULL THEN
834: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_last_updated_by');
835: x_return_status := FND_API.g_ret_sts_error;
836: RETURN;
837: END IF;
838:

Line 841: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_creation_date');

837: END IF;
838:
839:
840: IF p_list_group_rec.creation_date IS NULL THEN
841: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_creation_date');
842: x_return_status := FND_API.g_ret_sts_error;
843: RETURN;
844: END IF;
845:

Line 848: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_created_by');

844: END IF;
845:
846:
847: IF p_list_group_rec.created_by IS NULL THEN
848: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_list_group_NO_created_by');
849: x_return_status := FND_API.g_ret_sts_error;
850: RETURN;
851: END IF;
852: END IF;

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

1132:
1133: -- Debug Message
1134: IF (AMS_DEBUG_HIGH_ON) THEN
1135:
1136: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
1137: END IF;
1138:
1139:
1140: -- Initialize API return status to SUCCESS

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

1143:
1144: -- Debug Message
1145: IF (AMS_DEBUG_HIGH_ON) THEN
1146:
1147: AMS_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
1148: END IF;
1149:
1150: -- Standard call to get message count and if count is 1, get message info.
1151: FND_MSG_PUB.Count_And_Get

Line 1157: WHEN AMS_Utility_PVT.resource_locked THEN

1153: p_data => x_msg_data
1154: );
1155: EXCEPTION
1156:
1157: WHEN AMS_Utility_PVT.resource_locked THEN
1158: x_return_status := FND_API.g_ret_sts_error;
1159: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN

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

1155: EXCEPTION
1156:
1157: WHEN AMS_Utility_PVT.resource_locked THEN
1158: x_return_status := FND_API.g_ret_sts_error;
1159: AMS_Utility_PVT.Error_Message(p_message_name => 'AMS_API_RESOURCE_LOCKED');
1160:
1161: WHEN FND_API.G_EXC_ERROR THEN
1162: ROLLBACK TO VALIDATE_List_Group_;
1163: x_return_status := FND_API.G_RET_STS_ERROR;

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

1220:
1221: -- Debug Message
1222: IF (AMS_DEBUG_HIGH_ON) THEN
1223:
1224: AMS_UTILITY_PVT.debug_message('Private API: Validate_dm_model_rec');
1225: END IF;
1226: -- Standard call to get message count and if count is 1, get message info.
1227: FND_MSG_PUB.Count_And_Get
1228: (p_count => x_msg_count,