457: l_api_version_number CONSTANT NUMBER := 1.0;
458: l_object_version_number NUMBER;
459: l_vo_mo_rec vo_mo_rec_type;
460: BEGIN
461: -- Standard Start of API savepoint
462: SAVEPOINT validate_market_options_pvt;
463:
464: -- Standard call to check for call compatibility.
465: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
460: BEGIN
461: -- Standard Start of API savepoint
462: SAVEPOINT validate_market_options_pvt;
463:
464: -- Standard call to check for call compatibility.
465: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
466: p_api_version_number,
467: l_api_name,
468: G_PKG_NAME)
523: -- Debug Message
524: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
525:
526:
527: -- Standard call to get message count and if count is 1, get message info.
528: FND_MSG_PUB.Count_And_Get
529: (p_count => x_msg_count,
530: p_data => x_msg_data
531: );
537:
538: WHEN FND_API.G_EXC_ERROR THEN
539: ROLLBACK TO validate_market_options_pvt;
540: x_return_status := FND_API.G_RET_STS_ERROR;
541: -- Standard call to get message count and if count=1, get the message
542: FND_MSG_PUB.Count_And_Get (
543: p_encoded => FND_API.G_FALSE,
544: p_count => x_msg_count,
545: p_data => x_msg_data
547:
548: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
549: ROLLBACK TO validate_market_options_pvt;
550: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
551: -- Standard call to get message count and if count=1, get the message
552: FND_MSG_PUB.Count_And_Get (
553: p_encoded => FND_API.G_FALSE,
554: p_count => x_msg_count,
555: p_data => x_msg_data
561: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
562: THEN
563: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
564: END IF;
565: -- Standard call to get message count and if count=1, get the message
566: FND_MSG_PUB.Count_And_Get (
567: p_encoded => FND_API.G_FALSE,
568: p_count => x_msg_count,
569: p_data => x_msg_data
631:
632: BEGIN
633: -- initialize
634: --initialize
635: -- Standard Start of API savepoint
636: SAVEPOINT Create_market_options_pvt;
637:
638: -- Standard call to check for call compatibility.
639: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
634: --initialize
635: -- Standard Start of API savepoint
636: SAVEPOINT Create_market_options_pvt;
637:
638: -- Standard call to check for call compatibility.
639: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
640: p_api_version_number,
641: l_api_name,
642: G_PKG_NAME)
738: END IF;
739: -- Debug Message
740: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'Return status is : '|| x_return_status);
741: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
742: -- Standard call to get message count and if count is 1, get message info.
743:
744: FND_MSG_PUB.Count_And_Get
745: (p_count => x_msg_count,
746: p_data => x_msg_data
750: EXCEPTION
751: WHEN FND_API.G_EXC_ERROR THEN
752: ROLLBACK TO Create_market_options_pvt;
753: x_return_status := FND_API.G_RET_STS_ERROR;
754: -- Standard call to get message count and if count=1, get the message
755: FND_MSG_PUB.Count_And_Get (
756: p_encoded => FND_API.G_FALSE,
757: p_count => x_msg_count,
758: p_data => x_msg_data
760:
761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
762: ROLLBACK TO Create_market_options_pvt;
763: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
764: -- Standard call to get message count and if count=1, get the message
765: FND_MSG_PUB.Count_And_Get (
766: p_encoded => FND_API.G_FALSE,
767: p_count => x_msg_count,
768: p_data => x_msg_data
774: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
775: THEN
776: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
777: END IF;
778: -- Standard call to get message count and if count=1, get the message
779: FND_MSG_PUB.Count_And_Get (
780: p_encoded => FND_API.G_FALSE,
781: p_count => x_msg_count,
782: p_data => x_msg_data
845: l_tar_mo_rec vo_mo_rec_type := p_mo_rec ;
846: l_rowid ROWID;
847: BEGIN
848: --initialize
849: -- Standard Start of API savepoint
850: SAVEPOINT Update_market_options_pvt;
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
853: p_api_version_number,
847: BEGIN
848: --initialize
849: -- Standard Start of API savepoint
850: SAVEPOINT Update_market_options_pvt;
851: -- Standard call to check for call compatibility.
852: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
853: p_api_version_number,
854: l_api_name,
855: G_PKG_NAME)
936: COMMIT WORK;
937: END IF;
938: -- Debug Message
939: OZF_Volume_Offer_disc_PVT.debug_message('Private API: ' || l_api_name || 'end');
940: -- Standard call to get message count and if count is 1, get message info.
941: FND_MSG_PUB.Count_And_Get
942: (p_count => x_msg_count,
943: p_data => x_msg_data
944: );
952:
953: WHEN FND_API.G_EXC_ERROR THEN
954: ROLLBACK TO Update_market_options_pvt;
955: x_return_status := FND_API.G_RET_STS_ERROR;
956: -- Standard call to get message count and if count=1, get the message
957: FND_MSG_PUB.Count_And_Get (
958: p_encoded => FND_API.G_FALSE,
959: p_count => x_msg_count,
960: p_data => x_msg_data
962:
963: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
964: ROLLBACK TO Update_market_options_pvt;
965: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
966: -- Standard call to get message count and if count=1, get the message
967: FND_MSG_PUB.Count_And_Get (
968: p_encoded => FND_API.G_FALSE,
969: p_count => x_msg_count,
970: p_data => x_msg_data
976: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
977: THEN
978: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
979: END IF;
980: -- Standard call to get message count and if count=1, get the message
981: FND_MSG_PUB.Count_And_Get (
982: p_encoded => FND_API.G_FALSE,
983: p_count => x_msg_count,
984: p_data => x_msg_data
1034: l_api_name CONSTANT VARCHAR2(30) := 'Delete_market_options';
1035: l_api_version_number CONSTANT NUMBER := 1.0;
1036: l_object_version_number NUMBER;
1037: BEGIN
1038: -- Standard Start of API savepoint
1039: SAVEPOINT Delete_market_options_PVT;
1040:
1041: -- Standard call to check for call compatibility.
1042: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1037: BEGIN
1038: -- Standard Start of API savepoint
1039: SAVEPOINT Delete_market_options_PVT;
1040:
1041: -- Standard call to check for call compatibility.
1042: IF NOT FND_API.Compatible_API_Call ( l_api_version_number,
1043: p_api_version_number,
1044: l_api_name,
1045: G_PKG_NAME)
1069: --
1070: -- End of API body
1071: --
1072:
1073: -- Standard check for p_commit
1074: IF FND_API.to_Boolean( p_commit )
1075: THEN
1076: COMMIT WORK;
1077: END IF;
1075: THEN
1076: COMMIT WORK;
1077: END IF;
1078:
1079: -- Standard call to get message count and if count is 1, get message info.
1080: FND_MSG_PUB.Count_And_Get
1081: (p_count => x_msg_count,
1082: p_data => x_msg_data
1083: );
1089:
1090: WHEN FND_API.G_EXC_ERROR THEN
1091: ROLLBACK TO Delete_market_options_PVT;
1092: x_return_status := FND_API.G_RET_STS_ERROR;
1093: -- Standard call to get message count and if count=1, get the message
1094: FND_MSG_PUB.Count_And_Get (
1095: p_encoded => FND_API.G_FALSE,
1096: p_count => x_msg_count,
1097: p_data => x_msg_data
1099:
1100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1101: ROLLBACK TO Delete_market_options_PVT;
1102: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
1103: -- Standard call to get message count and if count=1, get the message
1104: FND_MSG_PUB.Count_And_Get (
1105: p_encoded => FND_API.G_FALSE,
1106: p_count => x_msg_count,
1107: p_data => x_msg_data
1113: IF FND_MSG_PUB.Check_Msg_Level ( FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)
1114: THEN
1115: FND_MSG_PUB.Add_Exc_Msg( G_PKG_NAME,l_api_name);
1116: END IF;
1117: -- Standard call to get message count and if count=1, get the message
1118: FND_MSG_PUB.Count_And_Get (
1119: p_encoded => FND_API.G_FALSE,
1120: p_count => x_msg_count,
1121: p_data => x_msg_data