DBA Data[Home] [Help]

APPS.OZF_QUAL_MARKET_OPTION_PVT dependencies on FND_MSG_PUB

Line 258: FND_MSG_PUB.initialize;

254: END IF;
255: -- Initialize message list if p_init_msg_list is set to TRUE.
256: IF FND_API.to_Boolean( p_init_msg_list )
257: THEN
258: FND_MSG_PUB.initialize;
259: END IF;
260:
261: -- Debug Message
262: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 309: FND_MSG_PUB.Count_And_Get

305:
306: -- collect message
307:
308: -- Standard call to get message count and if count is 1, get message info.
309: FND_MSG_PUB.Count_And_Get
310: (p_count => x_msg_count,
311: p_data => x_msg_data
312: );
313: -- exception

Line 325: FND_MSG_PUB.Count_And_Get (

321: WHEN FND_API.G_EXC_ERROR THEN
322: ROLLBACK TO validate_qual_mkt_options_pvt;
323: x_return_status := FND_API.G_RET_STS_ERROR;
324: -- Standard call to get message count and if count=1, get the message
325: FND_MSG_PUB.Count_And_Get (
326: p_encoded => FND_API.G_FALSE,
327: p_count => x_msg_count,
328: p_data => x_msg_data
329: );

Line 335: FND_MSG_PUB.Count_And_Get (

331: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
332: ROLLBACK TO validate_qual_mkt_options_pvt;
333: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
334: -- Standard call to get message count and if count=1, get the message
335: FND_MSG_PUB.Count_And_Get (
336: p_encoded => FND_API.G_FALSE,
337: p_count => x_msg_count,
338: p_data => x_msg_data
339: );

Line 344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

340:
341: WHEN OTHERS THEN
342: ROLLBACK TO validate_qual_mkt_options_pvt;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
345: THEN
346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: -- Standard call to get message count and if count=1, get the message

Line 346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

342: ROLLBACK TO validate_qual_mkt_options_pvt;
343: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
344: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
345: THEN
346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: -- Standard call to get message count and if count=1, get the message
349: FND_MSG_PUB.Count_And_Get (
350: p_encoded => FND_API.G_FALSE,

Line 349: FND_MSG_PUB.Count_And_Get (

345: THEN
346: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
347: END IF;
348: -- Standard call to get message count and if count=1, get the message
349: FND_MSG_PUB.Count_And_Get (
350: p_encoded => FND_API.G_FALSE,
351: p_count => x_msg_count,
352: p_data => x_msg_data
353: );

Line 433: FND_MSG_PUB.initialize;

429:
430: -- Initialize message list if p_init_msg_list is set to TRUE.
431: IF FND_API.to_Boolean( p_init_msg_list )
432: THEN
433: FND_MSG_PUB.initialize;
434: END IF;
435:
436: -- Debug Message
437: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');

Line 515: FND_MSG_PUB.Count_And_Get

511: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
512: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
513: -- Standard call to get message count and if count is 1, get message info.
514:
515: FND_MSG_PUB.Count_And_Get
516: (p_count => x_msg_count,
517: p_data => x_msg_data
518: );
519:

Line 526: FND_MSG_PUB.Count_And_Get (

522: WHEN FND_API.G_EXC_ERROR THEN
523: ROLLBACK TO Create_qual_market_options_pvt;
524: x_return_status := FND_API.G_RET_STS_ERROR;
525: -- Standard call to get message count and if count=1, get the message
526: FND_MSG_PUB.Count_And_Get (
527: p_encoded => FND_API.G_FALSE,
528: p_count => x_msg_count,
529: p_data => x_msg_data
530: );

Line 536: FND_MSG_PUB.Count_And_Get (

532: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
533: ROLLBACK TO Create_qual_market_options_pvt;
534: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
535: -- Standard call to get message count and if count=1, get the message
536: FND_MSG_PUB.Count_And_Get (
537: p_encoded => FND_API.G_FALSE,
538: p_count => x_msg_count,
539: p_data => x_msg_data
540: );

Line 545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

541:
542: WHEN OTHERS THEN
543: ROLLBACK TO Create_qual_market_options_pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
548: END IF;
549: -- Standard call to get message count and if count=1, get the message

Line 547: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

543: ROLLBACK TO Create_qual_market_options_pvt;
544: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
545: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
548: END IF;
549: -- Standard call to get message count and if count=1, get the message
550: FND_MSG_PUB.Count_And_Get (
551: p_encoded => FND_API.G_FALSE,

Line 550: FND_MSG_PUB.Count_And_Get (

546: THEN
547: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
548: END IF;
549: -- Standard call to get message count and if count=1, get the message
550: FND_MSG_PUB.Count_And_Get (
551: p_encoded => FND_API.G_FALSE,
552: p_count => x_msg_count,
553: p_data => x_msg_data
554: );

Line 601: FND_MSG_PUB.initialize;

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

Line 674: FND_MSG_PUB.Count_And_Get

670: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
671: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
672: -- Standard call to get message count and if count is 1, get message info.
673:
674: FND_MSG_PUB.Count_And_Get
675: (p_count => x_msg_count,
676: p_data => x_msg_data
677: );
678: --exception

Line 685: FND_MSG_PUB.Count_And_Get (

681: WHEN FND_API.G_EXC_ERROR THEN
682: ROLLBACK TO update_qual_market_options_pvt;
683: x_return_status := FND_API.G_RET_STS_ERROR;
684: -- Standard call to get message count and if count=1, get the message
685: FND_MSG_PUB.Count_And_Get (
686: p_encoded => FND_API.G_FALSE,
687: p_count => x_msg_count,
688: p_data => x_msg_data
689: );

Line 695: FND_MSG_PUB.Count_And_Get (

691: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
692: ROLLBACK TO update_qual_market_options_pvt;
693: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
694: -- Standard call to get message count and if count=1, get the message
695: FND_MSG_PUB.Count_And_Get (
696: p_encoded => FND_API.G_FALSE,
697: p_count => x_msg_count,
698: p_data => x_msg_data
699: );

Line 704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

700:
701: WHEN OTHERS THEN
702: ROLLBACK TO update_qual_market_options_pvt;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
705: THEN
706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
707: END IF;
708: -- Standard call to get message count and if count=1, get the message

Line 706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

702: ROLLBACK TO update_qual_market_options_pvt;
703: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
704: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
705: THEN
706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
707: END IF;
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,

Line 709: FND_MSG_PUB.Count_And_Get (

705: THEN
706: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
707: END IF;
708: -- Standard call to get message count and if count=1, get the message
709: FND_MSG_PUB.Count_And_Get (
710: p_encoded => FND_API.G_FALSE,
711: p_count => x_msg_count,
712: p_data => x_msg_data
713: );

Line 750: FND_MSG_PUB.initialize;

746:
747: -- Initialize message list if p_init_msg_list is set to TRUE.
748: IF FND_API.to_Boolean( p_init_msg_list )
749: THEN
750: FND_MSG_PUB.initialize;
751: END IF;
752:
753: -- Initialize API return status to SUCCESS
754: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 768: FND_MSG_PUB.Count_And_Get

764: COMMIT WORK;
765: END IF;
766:
767: -- Standard call to get message count and if count is 1, get message info.
768: FND_MSG_PUB.Count_And_Get
769: (p_count => x_msg_count,
770: p_data => x_msg_data
771: );
772: -- exception

Line 784: FND_MSG_PUB.Count_And_Get (

780: WHEN FND_API.G_EXC_ERROR THEN
781: ROLLBACK TO Delete_qual_market_options_PVT;
782: x_return_status := FND_API.G_RET_STS_ERROR;
783: -- Standard call to get message count and if count=1, get the message
784: FND_MSG_PUB.Count_And_Get (
785: p_encoded => FND_API.G_FALSE,
786: p_count => x_msg_count,
787: p_data => x_msg_data
788: );

Line 794: FND_MSG_PUB.Count_And_Get (

790: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
791: ROLLBACK TO Delete_qual_market_options_PVT;
792: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
793: -- Standard call to get message count and if count=1, get the message
794: FND_MSG_PUB.Count_And_Get (
795: p_encoded => FND_API.G_FALSE,
796: p_count => x_msg_count,
797: p_data => x_msg_data
798: );

Line 803: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)

799:
800: WHEN OTHERS THEN
801: ROLLBACK TO Delete_qual_market_options_PVT;
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: -- Standard call to get message count and if count=1, get the message

Line 805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);

801: ROLLBACK TO Delete_qual_market_options_PVT;
802: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
803: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
804: THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: -- Standard call to get message count and if count=1, get the message
808: FND_MSG_PUB.Count_And_Get (
809: p_encoded => FND_API.G_FALSE,

Line 808: FND_MSG_PUB.Count_And_Get (

804: THEN
805: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
806: END IF;
807: -- Standard call to get message count and if count=1, get the message
808: FND_MSG_PUB.Count_And_Get (
809: p_encoded => FND_API.G_FALSE,
810: p_count => x_msg_count,
811: p_data => x_msg_data
812: );