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 778: FND_MSG_PUB.initialize;

774: END IF;
775:
776: -- Initialize message list if p_init_msg_list is set to TRUE.
777: IF FND_API.to_Boolean( p_init_msg_list ) THEN
778: FND_MSG_PUB.initialize;
779: END IF;
780:
781: -- Initialize API return status to success
782: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 836: FND_MSG_PUB.Count_And_Get

832:
833: -- End of API body.
834:
835: -- Standard call to get message count and if count is 1, get message info.
836: FND_MSG_PUB.Count_And_Get
837: (p_count => x_msg_count ,
838: p_data => x_msg_data );
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN

Line 842: FND_MSG_PUB.Count_And_Get

838: p_data => x_msg_data );
839: EXCEPTION
840: WHEN FND_API.G_EXC_ERROR THEN
841: x_return_status := FND_API.G_RET_STS_ERROR ;
842: FND_MSG_PUB.Count_And_Get
843: (p_count => x_msg_count ,
844: p_data => x_msg_data );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 847: FND_MSG_PUB.Count_And_Get

843: (p_count => x_msg_count ,
844: p_data => x_msg_data );
845: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
846: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
847: FND_MSG_PUB.Count_And_Get
848: (p_count => x_msg_count ,
849: p_data => x_msg_data );
850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 852: IF FND_MSG_PUB.Check_Msg_Level

848: (p_count => x_msg_count ,
849: p_data => x_msg_data );
850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: IF FND_MSG_PUB.Check_Msg_Level
853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: FND_MSG_PUB.Add_Exc_Msg
856: (G_PKG_NAME ,

Line 853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

849: p_data => x_msg_data );
850: WHEN OTHERS THEN
851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: IF FND_MSG_PUB.Check_Msg_Level
853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: FND_MSG_PUB.Add_Exc_Msg
856: (G_PKG_NAME ,
857: l_api_name );

Line 855: FND_MSG_PUB.Add_Exc_Msg

851: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
852: IF FND_MSG_PUB.Check_Msg_Level
853: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
854: THEN
855: FND_MSG_PUB.Add_Exc_Msg
856: (G_PKG_NAME ,
857: l_api_name );
858: END IF;
859: FND_MSG_PUB.Count_And_Get

Line 859: FND_MSG_PUB.Count_And_Get

855: FND_MSG_PUB.Add_Exc_Msg
856: (G_PKG_NAME ,
857: l_api_name );
858: END IF;
859: FND_MSG_PUB.Count_And_Get
860: (p_count => x_msg_count ,
861: p_data => x_msg_data );
862:
863: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 943: FND_MSG_PUB.initialize;

939: END IF;
940:
941: -- Initialize message list if p_init_msg_list is set to TRUE.
942: IF FND_API.to_Boolean( p_init_msg_list ) THEN
943: FND_MSG_PUB.initialize;
944: END IF;
945:
946: -- Initialize API return status to success
947: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1005: FND_MSG_PUB.Count_And_Get

1001:
1002: -- End of API body.
1003:
1004: -- Standard call to get message count and if count is 1, get message info.
1005: FND_MSG_PUB.Count_And_Get
1006: (p_count => x_msg_count ,
1007: p_data => x_msg_data );
1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN

Line 1011: FND_MSG_PUB.Count_And_Get

1007: p_data => x_msg_data );
1008: EXCEPTION
1009: WHEN FND_API.G_EXC_ERROR THEN
1010: x_return_status := FND_API.G_RET_STS_ERROR ;
1011: FND_MSG_PUB.Count_And_Get
1012: (p_count => x_msg_count ,
1013: p_data => x_msg_data );
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1016: FND_MSG_PUB.Count_And_Get

1012: (p_count => x_msg_count ,
1013: p_data => x_msg_data );
1014: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1015: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1016: FND_MSG_PUB.Count_And_Get
1017: (p_count => x_msg_count ,
1018: p_data => x_msg_data );
1019: WHEN OTHERS THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1021: IF FND_MSG_PUB.Check_Msg_Level

1017: (p_count => x_msg_count ,
1018: p_data => x_msg_data );
1019: WHEN OTHERS THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: IF FND_MSG_PUB.Check_Msg_Level
1022: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1023: THEN
1024: FND_MSG_PUB.Add_Exc_Msg
1025: (G_PKG_NAME ,

Line 1022: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1018: p_data => x_msg_data );
1019: WHEN OTHERS THEN
1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: IF FND_MSG_PUB.Check_Msg_Level
1022: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1023: THEN
1024: FND_MSG_PUB.Add_Exc_Msg
1025: (G_PKG_NAME ,
1026: l_api_name );

Line 1024: FND_MSG_PUB.Add_Exc_Msg

1020: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1021: IF FND_MSG_PUB.Check_Msg_Level
1022: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1023: THEN
1024: FND_MSG_PUB.Add_Exc_Msg
1025: (G_PKG_NAME ,
1026: l_api_name );
1027: END IF;
1028: FND_MSG_PUB.Count_And_Get

Line 1028: FND_MSG_PUB.Count_And_Get

1024: FND_MSG_PUB.Add_Exc_Msg
1025: (G_PKG_NAME ,
1026: l_api_name );
1027: END IF;
1028: FND_MSG_PUB.Count_And_Get
1029: (p_count => x_msg_count ,
1030: p_data => x_msg_data );
1031:
1032: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 1119: FND_MSG_PUB.initialize;

1115: END IF;
1116:
1117: -- Initialize message list if p_init_msg_list is set to TRUE.
1118: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1119: FND_MSG_PUB.initialize;
1120: END IF;
1121:
1122: -- Initialize API return status to success
1123: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 1156: FND_MSG_PUB.Count_And_Get

1152: END LOOP; -- End of eachgroup
1153: -- End of API body.
1154:
1155: -- Standard call to get message count and if count is 1, get message info.
1156: FND_MSG_PUB.Count_And_Get
1157: (p_count => x_msg_count ,
1158: p_data => x_msg_data );
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN

Line 1162: FND_MSG_PUB.Count_And_Get

1158: p_data => x_msg_data );
1159: EXCEPTION
1160: WHEN FND_API.G_EXC_ERROR THEN
1161: x_return_status := FND_API.G_RET_STS_ERROR ;
1162: FND_MSG_PUB.Count_And_Get
1163: (p_count => x_msg_count ,
1164: p_data => x_msg_data );
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1167: FND_MSG_PUB.Count_And_Get

1163: (p_count => x_msg_count ,
1164: p_data => x_msg_data );
1165: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1166: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1167: FND_MSG_PUB.Count_And_Get
1168: (p_count => x_msg_count ,
1169: p_data => x_msg_data );
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;

Line 1172: IF FND_MSG_PUB.Check_Msg_Level

1168: (p_count => x_msg_count ,
1169: p_data => x_msg_data );
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (G_PKG_NAME ,

Line 1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

1169: p_data => x_msg_data );
1170: WHEN OTHERS THEN
1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (G_PKG_NAME ,
1177: l_api_name );

Line 1175: FND_MSG_PUB.Add_Exc_Msg

1171: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR ;
1172: IF FND_MSG_PUB.Check_Msg_Level
1173: (FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1174: THEN
1175: FND_MSG_PUB.Add_Exc_Msg
1176: (G_PKG_NAME ,
1177: l_api_name );
1178: END IF;
1179: FND_MSG_PUB.Count_And_Get

Line 1179: FND_MSG_PUB.Count_And_Get

1175: FND_MSG_PUB.Add_Exc_Msg
1176: (G_PKG_NAME ,
1177: l_api_name );
1178: END IF;
1179: FND_MSG_PUB.Count_And_Get
1180: (p_count => x_msg_count ,
1181: p_data => x_msg_data );
1182:
1183: if (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then