DBA Data[Home] [Help]

APPS.OZF_QP_PRODUCTS_PVT dependencies on FND_MSG_PUB

Line 279: FND_MSG_PUB.Count_And_Get (

275: WHEN FND_API.G_EXC_ERROR THEN
276: -- ROLLBACK TO validate_market_options_pvt;
277: x_return_status := FND_API.G_RET_STS_ERROR;
278: -- Standard call to get message count and if count=1, get the message
279: FND_MSG_PUB.Count_And_Get (
280: p_encoded => FND_API.G_FALSE,
281: p_count => x_msg_count,
282: p_data => x_msg_data
283: );

Line 289: FND_MSG_PUB.Count_And_Get (

285: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
286: -- ROLLBACK TO validate_market_options_pvt;
287: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
288: -- Standard call to get message count and if count=1, get the message
289: FND_MSG_PUB.Count_And_Get (
290: p_encoded => FND_API.G_FALSE,
291: p_count => x_msg_count,
292: p_data => x_msg_data
293: );

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

294:
295: WHEN OTHERS THEN
296: -- ROLLBACK TO validate_market_options_pvt;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message

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

296: -- ROLLBACK TO validate_market_options_pvt;
297: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
298: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
299: THEN
300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message
303: FND_MSG_PUB.Count_And_Get (
304: p_encoded => FND_API.G_FALSE,

Line 303: FND_MSG_PUB.Count_And_Get (

299: THEN
300: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
301: END IF;
302: -- Standard call to get message count and if count=1, get the message
303: FND_MSG_PUB.Count_And_Get (
304: p_encoded => FND_API.G_FALSE,
305: p_count => x_msg_count,
306: p_data => x_msg_data
307: );

Line 384: FND_MSG_PUB.initialize;

380: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
381: END IF;
382: -- initialize messages
383: IF FND_API.to_boolean(p_init_msg_list) THEN
384: FND_MSG_PUB.initialize;
385: END IF;
386: -- debug message start
387: ozf_utility_pvt.debug_message('Private API: '|| l_api_name|| 'start');
388: -- set return status

Line 455: FND_MSG_PUB.COUNT_AND_GET

451: END IF;
452:
453: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'end');
454:
455: FND_MSG_PUB.COUNT_AND_GET
456: (
457: p_count => x_msg_count
458: ,p_data => x_msg_data
459: );

Line 466: FND_MSG_PUB.COUNT_AND_GET

462: EXCEPTION
463: WHEN FND_API.G_EXC_ERROR THEN
464: ROLLBACK TO create_ozf_qp_product_pvt;
465: x_return_status := FND_API.G_RET_STS_ERROR;
466: FND_MSG_PUB.COUNT_AND_GET
467: (
468: p_encoded => FND_API.G_FALSE
469: , p_count => x_msg_count
470: , p_data => x_msg_data

Line 476: FND_MSG_PUB.COUNT_AND_GET

472:
473: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
474: ROLLBACK TO create_ozf_qp_products_pvt;
475: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
476: FND_MSG_PUB.COUNT_AND_GET
477: (
478: p_encoded => FND_API.G_FALSE
479: , p_count => x_msg_count
480: , p_data => x_msg_data

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

482:
483: WHEN OTHERS THEN
484: ROLLBACK TO create_ozf_qp_products_pvt;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message

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

484: ROLLBACK TO create_ozf_qp_products_pvt;
485: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
486: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,

Line 491: FND_MSG_PUB.Count_And_Get (

487: THEN
488: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
489: END IF;
490: -- Standard call to get message count and if count=1, get the message
491: FND_MSG_PUB.Count_And_Get (
492: p_encoded => FND_API.G_FALSE,
493: p_count => x_msg_count,
494: p_data => x_msg_data
495: );

Line 574: FND_MSG_PUB.initialize;

570: END IF;
571:
572: IF FND_API.to_Boolean( p_init_msg_list )
573: THEN
574: FND_MSG_PUB.initialize;
575: END IF;
576: -- Debug Message
577: OZF_UTILITY_PVT.debug_message('Private API: ' || l_api_name || 'start');
578:

Line 641: FND_MSG_PUB.count_and_get

637: IF FND_API.to_boolean(p_commit) THEN
638: COMMIT WORK;
639: END IF;
640: ozf_utility_pvt.debug_message('Private API : '||l_api_name || ' End');
641: FND_MSG_PUB.count_and_get
642: (
643: p_count => x_msg_count
644: , p_data => x_msg_data
645: );

Line 655: FND_MSG_PUB.count_and_get(

651:
652: WHEN FND_API.G_EXC_ERROR THEN
653: ROLLBACK TO Update_ozf_qp_product_pvt;
654: x_return_status := FND_API.G_RET_STS_ERROR;
655: FND_MSG_PUB.count_and_get(
656: p_encoded => FND_API.g_false
657: , p_count => x_msg_count
658: , p_data => x_msg_data
659: );

Line 663: FND_MSG_PUB.count_and_get(

659: );
660: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
661: ROLLBACK TO Update_ozf_qp_product_pvt;
662: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
663: FND_MSG_PUB.count_and_get(
664: p_encoded => FND_API.G_FALSE
665: , p_count => x_msg_count
666: , p_data => x_msg_data
667: );

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

667: );
668: WHEN OTHERS THEN
669: ROLLBACK TO Update_ozf_qp_product_pvt;
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;
675: -- Standard call to get message count and if count=1, get the message

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

669: ROLLBACK TO Update_ozf_qp_product_pvt;
670: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
671: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
672: THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,

Line 676: FND_MSG_PUB.Count_And_Get (

672: THEN
673: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
674: END IF;
675: -- Standard call to get message count and if count=1, get the message
676: FND_MSG_PUB.Count_And_Get (
677: p_encoded => FND_API.G_FALSE,
678: p_count => x_msg_count,
679: p_data => x_msg_data
680: );

Line 744: FND_MSG_PUB.initialize;

740: ) THEN
741: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
742: END IF;
743: IF FND_API.to_boolean(p_init_msg_list) THEN
744: FND_MSG_PUB.initialize;
745: END IF;
746: x_return_status := FND_API.G_RET_STS_SUCCESS;
747: -- delete
748: OZF_QP_PRODUCTS_PKG.Delete_Row(

Line 758: FND_MSG_PUB.count_and_get(

754: IF FND_API.to_boolean(p_commit) THEN
755: COMMIT WORK;
756: END IF;
757: -- get messages
758: FND_MSG_PUB.count_and_get(
759: p_count => x_msg_count
760: , p_data => x_msg_data
761: );
762: -- exception

Line 770: FND_MSG_PUB.COUNT_AND_GET(

766: x_return_status := FND_API.g_ret_sts_error;
767: WHEN FND_API.G_EXC_ERROR THEN
768: rollback to Delete_ozf_qp_product_pvt;
769: x_return_status := FND_API.G_RET_STS_ERROR;
770: FND_MSG_PUB.COUNT_AND_GET(
771: p_encoded => FND_API.G_FALSE
772: , p_count => x_msg_count
773: , p_data => x_msg_data
774: );

Line 778: FND_MSG_PUB.count_and_get(

774: );
775: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
776: ROLLBACK TO Delete_ozf_qp_product_pvt;
777: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
778: FND_MSG_PUB.count_and_get(
779: p_encoded => FND_API.G_FALSE
780: , p_count => x_msg_count
781: , p_data => x_msg_data
782: );

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

782: );
783: WHEN OTHERS THEN
784: ROLLBACK TO Delete_market_options_PVT;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message

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

784: ROLLBACK TO Delete_market_options_PVT;
785: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
786: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,

Line 791: FND_MSG_PUB.Count_And_Get (

787: THEN
788: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
789: END IF;
790: -- Standard call to get message count and if count=1, get the message
791: FND_MSG_PUB.Count_And_Get (
792: p_encoded => FND_API.G_FALSE,
793: p_count => x_msg_count,
794: p_data => x_msg_data
795: );