62: END IF;
63:
64: -- Initialize message list if p_init_msg_list is set to TRUE.
65: IF FND_API.to_Boolean( p_init_msg_list ) THEN
66: FND_MSG_PUB.initialize;
67: END IF;
68:
69: -- Initialize API return status to success
70: x_return_status := FND_API.G_RET_STS_SUCCESS;
82:
83: -- End of API body.
84:
85: -- Standard call to get message count and if count is 1, get message info.
86: FND_MSG_PUB.Count_And_Get
87: (p_count => x_msg_count ,
88: p_data => x_msg_data );
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
88: p_data => x_msg_data );
89: EXCEPTION
90: WHEN FND_API.G_EXC_ERROR THEN
91: x_return_status := FND_API.G_RET_STS_ERROR ;
92: FND_MSG_PUB.Count_And_Get
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
93: (p_count => x_msg_count ,
94: p_data => x_msg_data );
95: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
96: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
97: FND_MSG_PUB.Count_And_Get
98: (p_count => x_msg_count ,
99: p_data => x_msg_data );
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
98: (p_count => x_msg_count ,
99: p_data => x_msg_data );
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level
103: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
104: THEN
105: FND_MSG_PUB.Add_Exc_Msg
106: (G_PKG_NAME ,
99: p_data => x_msg_data );
100: WHEN OTHERS THEN
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level
103: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
104: THEN
105: FND_MSG_PUB.Add_Exc_Msg
106: (G_PKG_NAME ,
107: l_api_name );
101: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
102: IF FND_MSG_PUB.Check_Msg_Level
103: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
104: THEN
105: FND_MSG_PUB.Add_Exc_Msg
106: (G_PKG_NAME ,
107: l_api_name );
108: END IF;
109: FND_MSG_PUB.Count_And_Get
105: FND_MSG_PUB.Add_Exc_Msg
106: (G_PKG_NAME ,
107: l_api_name );
108: END IF;
109: FND_MSG_PUB.Count_And_Get
110: (p_count => x_msg_count ,
111: p_data => x_msg_data );
112:
113: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
178: END IF;
179:
180: -- Initialize message list if p_init_msg_list is set to TRUE.
181: IF FND_API.to_Boolean( p_init_msg_list ) THEN
182: FND_MSG_PUB.initialize;
183: END IF;
184:
185: -- Initialize API return status to success
186: x_return_status := FND_API.G_RET_STS_SUCCESS;
200:
201: -- End of API body.
202:
203: -- Standard call to get message count and if count is 1, get message info.
204: FND_MSG_PUB.Count_And_Get
205: (p_count => x_msg_count ,
206: p_data => x_msg_data );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
206: p_data => x_msg_data );
207: EXCEPTION
208: WHEN FND_API.G_EXC_ERROR THEN
209: x_return_status := FND_API.G_RET_STS_ERROR ;
210: FND_MSG_PUB.Count_And_Get
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
211: (p_count => x_msg_count ,
212: p_data => x_msg_data );
213: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
214: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
215: FND_MSG_PUB.Count_And_Get
216: (p_count => x_msg_count ,
217: p_data => x_msg_data );
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
216: (p_count => x_msg_count ,
217: p_data => x_msg_data );
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level
221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg
224: (G_PKG_NAME ,
217: p_data => x_msg_data );
218: WHEN OTHERS THEN
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level
221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg
224: (G_PKG_NAME ,
225: l_api_name );
219: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
220: IF FND_MSG_PUB.Check_Msg_Level
221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
222: THEN
223: FND_MSG_PUB.Add_Exc_Msg
224: (G_PKG_NAME ,
225: l_api_name );
226: END IF;
227: FND_MSG_PUB.Count_And_Get
223: FND_MSG_PUB.Add_Exc_Msg
224: (G_PKG_NAME ,
225: l_api_name );
226: END IF;
227: FND_MSG_PUB.Count_And_Get
228: (p_count => x_msg_count ,
229: p_data => x_msg_data );
230:
231: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
284: END IF;
285:
286: -- Initialize message list if p_init_msg_list is set to TRUE.
287: IF FND_API.to_Boolean( p_init_msg_list ) THEN
288: FND_MSG_PUB.initialize;
289: END IF;
290:
291: -- Initialize API return status to success
292: x_return_status := FND_API.G_RET_STS_SUCCESS;
319:
320: -- End of API body.
321:
322: -- Standard call to get message count and if count is 1, get message info.
323: FND_MSG_PUB.Count_And_Get
324: (p_count => x_msg_count ,
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
325: p_data => x_msg_data );
326: EXCEPTION
327: WHEN FND_API.G_EXC_ERROR THEN
328: x_return_status := FND_API.G_RET_STS_ERROR ;
329: FND_MSG_PUB.Count_And_Get
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
330: (p_count => x_msg_count ,
331: p_data => x_msg_data );
332: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
334: FND_MSG_PUB.Count_And_Get
335: (p_count => x_msg_count ,
336: p_data => x_msg_data );
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
335: (p_count => x_msg_count ,
336: p_data => x_msg_data );
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339: IF FND_MSG_PUB.Check_Msg_Level
340: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: FND_MSG_PUB.Add_Exc_Msg
343: (G_PKG_NAME ,
336: p_data => x_msg_data );
337: WHEN OTHERS THEN
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339: IF FND_MSG_PUB.Check_Msg_Level
340: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: FND_MSG_PUB.Add_Exc_Msg
343: (G_PKG_NAME ,
344: l_api_name );
338: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
339: IF FND_MSG_PUB.Check_Msg_Level
340: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
341: THEN
342: FND_MSG_PUB.Add_Exc_Msg
343: (G_PKG_NAME ,
344: l_api_name );
345: END IF;
346: FND_MSG_PUB.Count_And_Get
342: FND_MSG_PUB.Add_Exc_Msg
343: (G_PKG_NAME ,
344: l_api_name );
345: END IF;
346: FND_MSG_PUB.Count_And_Get
347: (p_count => x_msg_count ,
348: p_data => x_msg_data );
349:
350: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
416: END IF;
417:
418: -- Initialize message list if p_init_msg_list is set to TRUE.
419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
420: FND_MSG_PUB.initialize;
421: END IF;
422:
423: -- Initialize API return status to success
424: x_return_status := FND_API.G_RET_STS_SUCCESS;
437:
438: -- End of API body.
439:
440: -- Standard call to get message count and if count is 1, get message info.
441: FND_MSG_PUB.Count_And_Get
442: (p_count => x_msg_count ,
443: p_data => x_msg_data );
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
443: p_data => x_msg_data );
444: EXCEPTION
445: WHEN FND_API.G_EXC_ERROR THEN
446: x_return_status := FND_API.G_RET_STS_ERROR ;
447: FND_MSG_PUB.Count_And_Get
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
448: (p_count => x_msg_count ,
449: p_data => x_msg_data );
450: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
451: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
452: FND_MSG_PUB.Count_And_Get
453: (p_count => x_msg_count ,
454: p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
453: (p_count => x_msg_count ,
454: p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level
458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg
461: (G_PKG_NAME ,
454: p_data => x_msg_data );
455: WHEN OTHERS THEN
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level
458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg
461: (G_PKG_NAME ,
462: l_api_name );
456: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
457: IF FND_MSG_PUB.Check_Msg_Level
458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
459: THEN
460: FND_MSG_PUB.Add_Exc_Msg
461: (G_PKG_NAME ,
462: l_api_name );
463: END IF;
464: FND_MSG_PUB.Count_And_Get
460: FND_MSG_PUB.Add_Exc_Msg
461: (G_PKG_NAME ,
462: l_api_name );
463: END IF;
464: FND_MSG_PUB.Count_And_Get
465: (p_count => x_msg_count ,
466: p_data => x_msg_data );
467:
468: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
531: END IF;
532:
533: -- Initialize message list if p_init_msg_list is set to TRUE.
534: IF FND_API.to_Boolean( p_init_msg_list ) THEN
535: FND_MSG_PUB.initialize;
536: END IF;
537:
538: -- Initialize API return status to success
539: x_return_status := FND_API.G_RET_STS_SUCCESS;
551:
552: -- End of API body.
553:
554: -- Standard call to get message count and if count is 1, get message info.
555: FND_MSG_PUB.Count_And_Get
556: (p_count => x_msg_count ,
557: p_data => x_msg_data );
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
557: p_data => x_msg_data );
558: EXCEPTION
559: WHEN FND_API.G_EXC_ERROR THEN
560: x_return_status := FND_API.G_RET_STS_ERROR ;
561: FND_MSG_PUB.Count_And_Get
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
562: (p_count => x_msg_count ,
563: p_data => x_msg_data );
564: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
565: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
566: FND_MSG_PUB.Count_And_Get
567: (p_count => x_msg_count ,
568: p_data => x_msg_data );
569: WHEN OTHERS THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
567: (p_count => x_msg_count ,
568: p_data => x_msg_data );
569: WHEN OTHERS THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: (G_PKG_NAME ,
568: p_data => x_msg_data );
569: WHEN OTHERS THEN
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: (G_PKG_NAME ,
576: l_api_name );
570: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
571: IF FND_MSG_PUB.Check_Msg_Level
572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
573: THEN
574: FND_MSG_PUB.Add_Exc_Msg
575: (G_PKG_NAME ,
576: l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get
574: FND_MSG_PUB.Add_Exc_Msg
575: (G_PKG_NAME ,
576: l_api_name );
577: END IF;
578: FND_MSG_PUB.Count_And_Get
579: (p_count => x_msg_count ,
580: p_data => x_msg_data );
581:
582: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
644: END IF;
645:
646: -- Initialize message list if p_init_msg_list is set to TRUE.
647: IF FND_API.to_Boolean( p_init_msg_list ) THEN
648: FND_MSG_PUB.initialize;
649: END IF;
650:
651: -- Initialize API return status to success
652: x_return_status := FND_API.G_RET_STS_SUCCESS;
664:
665: -- End of API body.
666:
667: -- Standard call to get message count and if count is 1, get message info.
668: FND_MSG_PUB.Count_And_Get
669: (p_count => x_msg_count ,
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
670: p_data => x_msg_data );
671: EXCEPTION
672: WHEN FND_API.G_EXC_ERROR THEN
673: x_return_status := FND_API.G_RET_STS_ERROR ;
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
675: (p_count => x_msg_count ,
676: p_data => x_msg_data );
677: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
678: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
679: FND_MSG_PUB.Count_And_Get
680: (p_count => x_msg_count ,
681: p_data => x_msg_data );
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
680: (p_count => x_msg_count ,
681: p_data => x_msg_data );
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: IF FND_MSG_PUB.Check_Msg_Level
685: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg
688: (G_PKG_NAME ,
681: p_data => x_msg_data );
682: WHEN OTHERS THEN
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: IF FND_MSG_PUB.Check_Msg_Level
685: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg
688: (G_PKG_NAME ,
689: l_api_name );
683: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
684: IF FND_MSG_PUB.Check_Msg_Level
685: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
686: THEN
687: FND_MSG_PUB.Add_Exc_Msg
688: (G_PKG_NAME ,
689: l_api_name );
690: END IF;
691: FND_MSG_PUB.Count_And_Get
687: FND_MSG_PUB.Add_Exc_Msg
688: (G_PKG_NAME ,
689: l_api_name );
690: END IF;
691: FND_MSG_PUB.Count_And_Get
692: (p_count => x_msg_count ,
693: p_data => x_msg_data );
694:
695: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
811: END IF;
812:
813: -- Initialize message list if p_init_msg_list is set to TRUE.
814: IF FND_API.to_Boolean( p_init_msg_list ) THEN
815: FND_MSG_PUB.initialize;
816: END IF;
817:
818: -- Initialize API return status to success
819: x_return_status := FND_API.G_RET_STS_SUCCESS;
869:
870: -- End of API body.
871:
872: -- Standard call to get message count and if count is 1, get message info.
873: FND_MSG_PUB.Count_And_Get
874: (p_count => x_msg_count ,
875: p_data => x_msg_data );
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
875: p_data => x_msg_data );
876: EXCEPTION
877: WHEN FND_API.G_EXC_ERROR THEN
878: x_return_status := FND_API.G_RET_STS_ERROR ;
879: FND_MSG_PUB.Count_And_Get
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
880: (p_count => x_msg_count ,
881: p_data => x_msg_data );
882: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
883: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
884: FND_MSG_PUB.Count_And_Get
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );
887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
885: (p_count => x_msg_count ,
886: p_data => x_msg_data );
887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level
890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
891: THEN
892: FND_MSG_PUB.Add_Exc_Msg
893: (G_PKG_NAME ,
886: p_data => x_msg_data );
887: WHEN OTHERS THEN
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level
890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
891: THEN
892: FND_MSG_PUB.Add_Exc_Msg
893: (G_PKG_NAME ,
894: l_api_name );
888: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
889: IF FND_MSG_PUB.Check_Msg_Level
890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
891: THEN
892: FND_MSG_PUB.Add_Exc_Msg
893: (G_PKG_NAME ,
894: l_api_name );
895: END IF;
896: FND_MSG_PUB.Count_And_Get
892: FND_MSG_PUB.Add_Exc_Msg
893: (G_PKG_NAME ,
894: l_api_name );
895: END IF;
896: FND_MSG_PUB.Count_And_Get
897: (p_count => x_msg_count ,
898: p_data => x_msg_data );
899:
900: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
976: END IF;
977:
978: -- Initialize message list if p_init_msg_list is set to TRUE.
979: IF FND_API.to_Boolean( p_init_msg_list ) THEN
980: FND_MSG_PUB.initialize;
981: END IF;
982:
983: -- Initialize API return status to success
984: x_return_status := FND_API.G_RET_STS_SUCCESS;
1038:
1039: -- End of API body.
1040:
1041: -- Standard call to get message count and if count is 1, get message info.
1042: FND_MSG_PUB.Count_And_Get
1043: (p_count => x_msg_count ,
1044: p_data => x_msg_data );
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1044: p_data => x_msg_data );
1045: EXCEPTION
1046: WHEN FND_API.G_EXC_ERROR THEN
1047: x_return_status := FND_API.G_RET_STS_ERROR ;
1048: FND_MSG_PUB.Count_And_Get
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1049: (p_count => x_msg_count ,
1050: p_data => x_msg_data );
1051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1052: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1053: FND_MSG_PUB.Count_And_Get
1054: (p_count => x_msg_count ,
1055: p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1054: (p_count => x_msg_count ,
1055: p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: (G_PKG_NAME ,
1055: p_data => x_msg_data );
1056: WHEN OTHERS THEN
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: (G_PKG_NAME ,
1063: l_api_name );
1057: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1058: IF FND_MSG_PUB.Check_Msg_Level
1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1060: THEN
1061: FND_MSG_PUB.Add_Exc_Msg
1062: (G_PKG_NAME ,
1063: l_api_name );
1064: END IF;
1065: FND_MSG_PUB.Count_And_Get
1061: FND_MSG_PUB.Add_Exc_Msg
1062: (G_PKG_NAME ,
1063: l_api_name );
1064: END IF;
1065: FND_MSG_PUB.Count_And_Get
1066: (p_count => x_msg_count ,
1067: p_data => x_msg_data );
1068:
1069: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then
1152: END IF;
1153:
1154: -- Initialize message list if p_init_msg_list is set to TRUE.
1155: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1156: FND_MSG_PUB.initialize;
1157: END IF;
1158:
1159: -- Initialize API return status to success
1160: x_return_status := FND_API.G_RET_STS_SUCCESS;
1189: END LOOP; -- End of eachgroup
1190: -- End of API body.
1191:
1192: -- Standard call to get message count and if count is 1, get message info.
1193: FND_MSG_PUB.Count_And_Get
1194: (p_count => x_msg_count ,
1195: p_data => x_msg_data );
1196: EXCEPTION
1197: WHEN FND_API.G_EXC_ERROR THEN
1195: p_data => x_msg_data );
1196: EXCEPTION
1197: WHEN FND_API.G_EXC_ERROR THEN
1198: x_return_status := FND_API.G_RET_STS_ERROR ;
1199: FND_MSG_PUB.Count_And_Get
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1200: (p_count => x_msg_count ,
1201: p_data => x_msg_data );
1202: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1203: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1204: FND_MSG_PUB.Count_And_Get
1205: (p_count => x_msg_count ,
1206: p_data => x_msg_data );
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1205: (p_count => x_msg_count ,
1206: p_data => x_msg_data );
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level
1210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg
1213: (G_PKG_NAME ,
1206: p_data => x_msg_data );
1207: WHEN OTHERS THEN
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level
1210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg
1213: (G_PKG_NAME ,
1214: l_api_name );
1208: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1209: IF FND_MSG_PUB.Check_Msg_Level
1210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1211: THEN
1212: FND_MSG_PUB.Add_Exc_Msg
1213: (G_PKG_NAME ,
1214: l_api_name );
1215: END IF;
1216: FND_MSG_PUB.Count_And_Get
1212: FND_MSG_PUB.Add_Exc_Msg
1213: (G_PKG_NAME ,
1214: l_api_name );
1215: END IF;
1216: FND_MSG_PUB.Count_And_Get
1217: (p_count => x_msg_count ,
1218: p_data => x_msg_data );
1219:
1220: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then