16:
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Deliverable_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(
17: G_PKG_NAME CONSTANT VARCHAR2(30):= 'AMS_Deliverable_PUB';
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(
25: p_deliv_rec_pub IN deliv_rec_type,
18: G_FILE_NAME CONSTANT VARCHAR2(12) := 'amspdelb.pls';
19:
20: AMS_DEBUG_HIGH_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_HIGH);
21: AMS_DEBUG_LOW_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_LOW);
22: AMS_DEBUG_MEDIUM_ON boolean := FND_MSG_PUB.CHECK_MSG_LEVEL(FND_MSG_PUB.G_MSG_LVL_DEBUG_MEDIUM);
23:
24: PROCEDURE Convert_PubRec_To_PvtRec(
25: p_deliv_rec_pub IN deliv_rec_type,
26: x_deliv_rec_pvt OUT NOCOPY AMS_Deliverable_PVT.deliv_rec_type
154:
155: -- Initialize message list if p_init_msg_list is set to TRUE.
156: IF FND_API.to_Boolean( p_init_msg_list )
157: THEN
158: FND_MSG_PUB.initialize;
159: END IF;
160:
161: -- Debug Message
162: IF (AMS_DEBUG_HIGH_ON) THEN
203: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
204: END IF;
205:
206: -- Standard call to get message count and if count is 1, get message info.
207: FND_MSG_PUB.Count_And_Get
208: (p_count => x_msg_count,
209: p_data => x_msg_data
210: );
211:
212: EXCEPTION
213:
214: WHEN AMS_Utility_PVT.resource_locked THEN
215: x_return_status := FND_API.g_ret_sts_error;
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
217: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
218: FND_MSG_PUB.add;
219: END IF;
220:
214: WHEN AMS_Utility_PVT.resource_locked THEN
215: x_return_status := FND_API.g_ret_sts_error;
216: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
217: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
218: FND_MSG_PUB.add;
219: END IF;
220:
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO CREATE_deliv_PUB;
221: WHEN FND_API.G_EXC_ERROR THEN
222: ROLLBACK TO CREATE_deliv_PUB;
223: x_return_status := FND_API.G_RET_STS_ERROR;
224: -- Standard call to get message count and if count=1, get the message
225: FND_MSG_PUB.Count_And_Get (
226: p_encoded => FND_API.G_FALSE,
227: p_count => x_msg_count,
228: p_data => x_msg_data
229: );
231: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
232: ROLLBACK TO CREATE_deliv_PUB;
233: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
234: -- Standard call to get message count and if count=1, get the message
235: FND_MSG_PUB.Count_And_Get (
236: p_encoded => FND_API.G_FALSE,
237: p_count => x_msg_count,
238: p_data => x_msg_data
239: );
240:
241: WHEN OTHERS THEN
242: ROLLBACK TO CREATE_deliv_PUB;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
242: ROLLBACK TO CREATE_deliv_PUB;
243: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
244: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
245: THEN
246: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
247: END IF;
248: -- Standard call to get message count and if count=1, get the message
249: FND_MSG_PUB.Count_And_Get (
250: p_encoded => FND_API.G_FALSE,
251: p_count => x_msg_count,
252: p_data => x_msg_data
253: );
295:
296: -- Initialize message list if p_init_msg_list is set to TRUE.
297: IF FND_API.to_Boolean( p_init_msg_list )
298: THEN
299: FND_MSG_PUB.initialize;
300: END IF;
301:
302: -- Debug Message
303: IF (AMS_DEBUG_HIGH_ON) THEN
412: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
413: END IF;
414:
415: -- Standard call to get message count and if count is 1, get message info.
416: FND_MSG_PUB.Count_And_Get
417: (p_count => x_msg_count,
418: p_data => x_msg_data
419: );
420:
421: EXCEPTION
422:
423: WHEN AMS_Utility_PVT.resource_locked THEN
424: x_return_status := FND_API.g_ret_sts_error;
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
426: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
427: FND_MSG_PUB.add;
428: END IF;
429:
423: WHEN AMS_Utility_PVT.resource_locked THEN
424: x_return_status := FND_API.g_ret_sts_error;
425: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_error) THEN
426: FND_MESSAGE.set_name('AMS', 'AMS_API_RESOURCE_LOCKED');
427: FND_MSG_PUB.add;
428: END IF;
429:
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_Deliverable_PUB;
430: WHEN FND_API.G_EXC_ERROR THEN
431: ROLLBACK TO CREATE_Deliverable_PUB;
432: x_return_status := FND_API.G_RET_STS_ERROR;
433: -- Standard call to get message count and if count=1, get the message
434: FND_MSG_PUB.Count_And_Get (
435: p_encoded => FND_API.G_FALSE,
436: p_count => x_msg_count,
437: p_data => x_msg_data
438: );
440: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
441: ROLLBACK TO CREATE_Deliverable_PUB;
442: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
443: -- Standard call to get message count and if count=1, get the message
444: FND_MSG_PUB.Count_And_Get (
445: p_encoded => FND_API.G_FALSE,
446: p_count => x_msg_count,
447: p_data => x_msg_data
448: );
449:
450: WHEN OTHERS THEN
451: ROLLBACK TO CREATE_Deliverable_PUB;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
451: ROLLBACK TO CREATE_Deliverable_PUB;
452: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
453: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
454: THEN
455: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
456: END IF;
457: -- Standard call to get message count and if count=1, get the message
458: FND_MSG_PUB.Count_And_Get (
459: p_encoded => FND_API.G_FALSE,
460: p_count => x_msg_count,
461: p_data => x_msg_data
462: );
498:
499: -- Initialize message list if p_init_msg_list is set to TRUE.
500: IF FND_API.to_Boolean( p_init_msg_list )
501: THEN
502: FND_MSG_PUB.initialize;
503: END IF;
504:
505: -- Debug Message
506: IF (AMS_DEBUG_HIGH_ON) THEN
541: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
542: END IF;
543:
544: -- Standard call to get message count and if count is 1, get message info.
545: FND_MSG_PUB.Count_And_Get
546: (p_count => x_msg_count,
547: p_data => x_msg_data
548: );
549: EXCEPTION
555: WHEN FND_API.G_EXC_ERROR THEN
556: ROLLBACK TO UPDATE_Deliv_PUB;
557: x_return_status := FND_API.G_RET_STS_ERROR;
558: -- Standard call to get message count and if count=1, get the message
559: FND_MSG_PUB.Count_And_Get (
560: p_encoded => FND_API.G_FALSE,
561: p_count => x_msg_count,
562: p_data => x_msg_data
563: );
565: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
566: ROLLBACK TO UPDATE_Deliv_PUB;
567: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
568: -- Standard call to get message count and if count=1, get the message
569: FND_MSG_PUB.Count_And_Get (
570: p_encoded => FND_API.G_FALSE,
571: p_count => x_msg_count,
572: p_data => x_msg_data
573: );
574:
575: WHEN OTHERS THEN
576: ROLLBACK TO UPDATE_Deliv_PUB;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
576: ROLLBACK TO UPDATE_Deliv_PUB;
577: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
578: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
583: FND_MSG_PUB.Count_And_Get (
584: p_encoded => FND_API.G_FALSE,
579: THEN
580: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
581: END IF;
582: -- Standard call to get message count and if count=1, get the message
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: );
624:
625: -- Initialize message list if p_init_msg_list is set to TRUE.
626: IF FND_API.to_Boolean( p_init_msg_list )
627: THEN
628: FND_MSG_PUB.initialize;
629: END IF;
630:
631: -- Debug Message
632: IF (AMS_DEBUG_HIGH_ON) THEN
729: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
730: END IF;
731:
732: -- Standard call to get message count and if count is 1, get message info.
733: FND_MSG_PUB.Count_And_Get
734: (p_count => x_msg_count,
735: p_data => x_msg_data
736: );
737: EXCEPTION
743: WHEN FND_API.G_EXC_ERROR THEN
744: ROLLBACK TO UPDATE_Deliverable_PUB;
745: x_return_status := FND_API.G_RET_STS_ERROR;
746: -- Standard call to get message count and if count=1, get the message
747: FND_MSG_PUB.Count_And_Get (
748: p_encoded => FND_API.G_FALSE,
749: p_count => x_msg_count,
750: p_data => x_msg_data
751: );
753: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
754: ROLLBACK TO UPDATE_Deliverable_PUB;
755: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
756: -- Standard call to get message count and if count=1, get the message
757: FND_MSG_PUB.Count_And_Get (
758: p_encoded => FND_API.G_FALSE,
759: p_count => x_msg_count,
760: p_data => x_msg_data
761: );
762:
763: WHEN OTHERS THEN
764: ROLLBACK TO UPDATE_Deliverable_PUB;
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
764: ROLLBACK TO UPDATE_Deliverable_PUB;
765: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
766: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
771: FND_MSG_PUB.Count_And_Get (
772: p_encoded => FND_API.G_FALSE,
767: THEN
768: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
769: END IF;
770: -- Standard call to get message count and if count=1, get the message
771: FND_MSG_PUB.Count_And_Get (
772: p_encoded => FND_API.G_FALSE,
773: p_count => x_msg_count,
774: p_data => x_msg_data
775: );
815:
816: -- Initialize message list if p_init_msg_list is set to TRUE.
817: IF FND_API.to_Boolean( p_init_msg_list )
818: THEN
819: FND_MSG_PUB.initialize;
820: END IF;
821:
822: -- Debug Message
823: IF (AMS_DEBUG_HIGH_ON) THEN
931: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
932: END IF;
933:
934: -- Standard call to get message count and if count is 1, get message info.
935: FND_MSG_PUB.Count_And_Get
936: (p_count => x_msg_count,
937: p_data => x_msg_data
938: );
939: EXCEPTION
945: WHEN FND_API.G_EXC_ERROR THEN
946: ROLLBACK TO DELETE_Deliverable_PUB;
947: x_return_status := FND_API.G_RET_STS_ERROR;
948: -- Standard call to get message count and if count=1, get the message
949: FND_MSG_PUB.Count_And_Get (
950: p_encoded => FND_API.G_FALSE,
951: p_count => x_msg_count,
952: p_data => x_msg_data
953: );
955: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
956: ROLLBACK TO DELETE_Deliverable_PUB;
957: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
958: -- Standard call to get message count and if count=1, get the message
959: FND_MSG_PUB.Count_And_Get (
960: p_encoded => FND_API.G_FALSE,
961: p_count => x_msg_count,
962: p_data => x_msg_data
963: );
964:
965: WHEN OTHERS THEN
966: ROLLBACK TO DELETE_Deliverable_PUB;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
966: ROLLBACK TO DELETE_Deliverable_PUB;
967: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
968: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
973: FND_MSG_PUB.Count_And_Get (
974: p_encoded => FND_API.G_FALSE,
969: THEN
970: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
971: END IF;
972: -- Standard call to get message count and if count=1, get the message
973: FND_MSG_PUB.Count_And_Get (
974: p_encoded => FND_API.G_FALSE,
975: p_count => x_msg_count,
976: p_data => x_msg_data
977: );
1002:
1003: -- initialize the message list;
1004: -- won't do it again when calling private API
1005: IF FND_API.to_boolean(p_init_msg_list) THEN
1006: FND_MSG_PUB.initialize;
1007: END IF;
1008:
1009: -- Initialize API return status to SUCCESS
1010: x_return_status := FND_API.G_RET_STS_SUCCESS;
1097: -- Debug Message
1098: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'end');
1099:
1100: -- Standard call to get message count and if count is 1, get message info.
1101: FND_MSG_PUB.Count_And_Get
1102: (p_count => x_msg_count,
1103: p_data => x_msg_data
1104: );
1105:
1107:
1108: WHEN FND_API.g_exc_error THEN
1109: ROLLBACK TO validate_Deliverable_pub;
1110: x_return_status := FND_API.g_ret_sts_error;
1111: FND_MSG_PUB.count_and_get(
1112: p_encoded => FND_API.g_false,
1113: p_count => x_msg_count,
1114: p_data => x_msg_data
1115: );
1116:
1117: WHEN FND_API.g_exc_unexpected_error THEN
1118: ROLLBACK TO validate_Deliverable_pub;
1119: x_return_status := FND_API.g_ret_sts_unexp_error ;
1120: FND_MSG_PUB.count_and_get(
1121: p_encoded => FND_API.g_false,
1122: p_count => x_msg_count,
1123: p_data => x_msg_data
1124: );
1127: WHEN OTHERS THEN
1128: ROLLBACK TO validate_Deliverable_pub;
1129: x_return_status := FND_API.g_ret_sts_unexp_error ;
1130:
1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:
1129: x_return_status := FND_API.g_ret_sts_unexp_error ;
1130:
1131: IF FND_MSG_PUB.check_msg_level(FND_MSG_PUB.g_msg_lvl_unexp_error)
1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1132: THEN
1133: FND_MSG_PUB.add_exc_msg(g_pkg_name, l_api_name);
1134: END IF;
1135:
1136: FND_MSG_PUB.count_and_get(
1137: p_encoded => FND_API.g_false,
1138: p_count => x_msg_count,
1139: p_data => x_msg_data
1140: );
1176:
1177: -- Initialize message list if p_init_msg_list is set to TRUE.
1178: IF FND_API.to_Boolean( p_init_msg_list )
1179: THEN
1180: FND_MSG_PUB.initialize;
1181: END IF;
1182:
1183: -- Debug Message
1184: AMS_UTILITY_PVT.debug_message('Public API: ' || l_api_name || 'start');
1288: WHEN FND_API.G_EXC_ERROR THEN
1289: ROLLBACK TO LOCK_Deliverable_PUB;
1290: x_return_status := FND_API.G_RET_STS_ERROR;
1291: -- Standard call to get message count and if count=1, get the message
1292: FND_MSG_PUB.Count_And_Get (
1293: p_encoded => FND_API.G_FALSE,
1294: p_count => x_msg_count,
1295: p_data => x_msg_data
1296: );
1298: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1299: ROLLBACK TO LOCK_Deliverable_PUB;
1300: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1301: -- Standard call to get message count and if count=1, get the message
1302: FND_MSG_PUB.Count_And_Get (
1303: p_encoded => FND_API.G_FALSE,
1304: p_count => x_msg_count,
1305: p_data => x_msg_data
1306: );
1307:
1308: WHEN OTHERS THEN
1309: ROLLBACK TO LOCK_Deliverable_PUB;
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1309: ROLLBACK TO LOCK_Deliverable_PUB;
1310: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1311: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1312: THEN
1313: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1314: END IF;
1315: -- Standard call to get message count and if count=1, get the message
1316: FND_MSG_PUB.Count_And_Get (
1317: p_encoded => FND_API.G_FALSE,
1318: p_count => x_msg_count,
1319: p_data => x_msg_data
1320: );