[Home] [Help]
134: x_return_status := FND_API.G_RET_STS_SUCCESS;
135:
136:
137: ------------------------ lock -------------------------
138: OZF_DISC_LINE_PKG.Lock_Row(l_offer_discount_line_id,p_object_version);
139:
140:
141: -------------------- finish --------------------------
142: FND_MSG_PUB.count_and_get(
1050: END IF;
1051:
1052: -- Debug Message
1053: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1054: -- Invoke table handler(OZF_DISC_LINE_PKG.Insert_Row)
1055: OZF_DISC_LINE_PKG.Insert_Row(
1056: px_offer_discount_line_id => l_offer_discount_line_id,
1057: p_parent_discount_line_id => l_ozf_offer_line_rec.parent_discount_line_id,
1058: p_volume_from => l_ozf_offer_line_rec.volume_from,
1051:
1052: -- Debug Message
1053: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1054: -- Invoke table handler(OZF_DISC_LINE_PKG.Insert_Row)
1055: OZF_DISC_LINE_PKG.Insert_Row(
1056: px_offer_discount_line_id => l_offer_discount_line_id,
1057: p_parent_discount_line_id => l_ozf_offer_line_rec.parent_discount_line_id,
1058: p_volume_from => l_ozf_offer_line_rec.volume_from,
1059: p_volume_to => l_ozf_offer_line_rec.volume_to,
1313: END IF;
1314:
1315: -- Debug Message
1316:
1317: -- Invoke table handler(OZF_DISC_LINE_PKG.Update_Row)
1318: OZF_DISC_LINE_PKG.Update_Row(
1319: p_offer_discount_line_id => p_ozf_offer_line_rec.offer_discount_line_id,
1320: p_parent_discount_line_id => p_ozf_offer_line_rec.parent_discount_line_id,
1321: p_volume_from => p_ozf_offer_line_rec.volume_from,
1314:
1315: -- Debug Message
1316:
1317: -- Invoke table handler(OZF_DISC_LINE_PKG.Update_Row)
1318: OZF_DISC_LINE_PKG.Update_Row(
1319: p_offer_discount_line_id => p_ozf_offer_line_rec.offer_discount_line_id,
1320: p_parent_discount_line_id => p_ozf_offer_line_rec.parent_discount_line_id,
1321: p_volume_from => p_ozf_offer_line_rec.volume_from,
1322: p_volume_to => p_ozf_offer_line_rec.volume_to,
1509: --
1510: -- Debug Message
1511: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1512:
1513: -- Invoke table handler(OZF_DISC_LINE_PKG.Delete_Row)
1514: OZF_DISC_LINE_PKG.Delete_Row(
1515: p_offer_discount_line_id => p_offer_discount_line_id,
1516: p_object_version_number => p_object_version_number );
1517: --
1510: -- Debug Message
1511: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1512:
1513: -- Invoke table handler(OZF_DISC_LINE_PKG.Delete_Row)
1514: OZF_DISC_LINE_PKG.Delete_Row(
1515: p_offer_discount_line_id => p_offer_discount_line_id,
1516: p_object_version_number => p_object_version_number );
1517: --
1518: -- End of API body
6795: OZF_UTILITY_PVT.ERROR_MESSAGE('PARENT_NOT_PBH');
6796: RAISE FND_API.G_EXC_ERROR;
6797: END IF;
6798:
6799: OZF_DISC_LINE_PKG.delete_tiers(p_parent_discount_line_id);
6800: --
6801: EXCEPTION
6802: WHEN FND_API.G_EXC_ERROR THEN
6803: ROLLBACK TO Delete_Disc_tiers_PVT;