DBA Data[Home] [Help]

APPS.CN_ROLLUP_PVT dependencies on FND_MSG_PUB

Line 66: FND_MSG_PUB.initialize;

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;

Line 86: FND_MSG_PUB.Count_And_Get

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

Line 92: FND_MSG_PUB.Count_And_Get

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 ;

Line 97: 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 ;
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 ;

Line 102: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 103: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 105: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 182: FND_MSG_PUB.initialize;

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;

Line 204: FND_MSG_PUB.Count_And_Get

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

Line 210: FND_MSG_PUB.Count_And_Get

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 ;

Line 215: 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 ;
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 ;

Line 220: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 221: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 223: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 288: FND_MSG_PUB.initialize;

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;

Line 323: FND_MSG_PUB.Count_And_Get

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

Line 329: FND_MSG_PUB.Count_And_Get

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 ;

Line 334: 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 ;
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 ;

Line 339: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 340: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 342: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 420: FND_MSG_PUB.initialize;

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;

Line 441: FND_MSG_PUB.Count_And_Get

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

Line 447: FND_MSG_PUB.Count_And_Get

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 ;

Line 452: 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 ;
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 ;

Line 457: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 458: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 460: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 535: FND_MSG_PUB.initialize;

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;

Line 555: FND_MSG_PUB.Count_And_Get

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

Line 561: FND_MSG_PUB.Count_And_Get

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 ;

Line 566: 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 ;
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 ;

Line 571: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 572: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 574: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 648: FND_MSG_PUB.initialize;

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;

Line 668: FND_MSG_PUB.Count_And_Get

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

Line 674: FND_MSG_PUB.Count_And_Get

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 ;

Line 679: 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 ;
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 ;

Line 684: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 685: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 687: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 815: FND_MSG_PUB.initialize;

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;

Line 873: FND_MSG_PUB.Count_And_Get

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

Line 879: FND_MSG_PUB.Count_And_Get

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 ;

Line 884: 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 ;
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 ;

Line 889: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 890: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 892: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 980: FND_MSG_PUB.initialize;

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;

Line 1042: FND_MSG_PUB.Count_And_Get

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

Line 1048: FND_MSG_PUB.Count_And_Get

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 ;

Line 1053: 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 ;
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 ;

Line 1058: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 1059: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 1061: FND_MSG_PUB.Add_Exc_Msg

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

Line 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

Line 1156: FND_MSG_PUB.initialize;

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;

Line 1193: FND_MSG_PUB.Count_And_Get

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

Line 1199: FND_MSG_PUB.Count_And_Get

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 ;

Line 1204: 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 ;
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 ;

Line 1209: IF FND_MSG_PUB.Check_Msg_Level

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 ,

Line 1210: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

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 );

Line 1212: FND_MSG_PUB.Add_Exc_Msg

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

Line 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