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