135: x_return_status := FND_API.G_RET_STS_SUCCESS;
136:
137:
138: ------------------------ lock -------------------------
139: OZF_DISC_LINE_PKG.Lock_Row(l_offer_discount_line_id,p_object_version);
140:
141:
142: -------------------- finish --------------------------
143: FND_MSG_PUB.count_and_get(
1051: END IF;
1052:
1053: -- Debug Message
1054: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1055: -- Invoke table handler(OZF_DISC_LINE_PKG.Insert_Row)
1056: OZF_DISC_LINE_PKG.Insert_Row(
1057: px_offer_discount_line_id => l_offer_discount_line_id,
1058: p_parent_discount_line_id => l_ozf_offer_line_rec.parent_discount_line_id,
1059: p_volume_from => l_ozf_offer_line_rec.volume_from,
1052:
1053: -- Debug Message
1054: OZF_UTILITY_PVT.debug_message( 'Private API: Calling create table handler');
1055: -- Invoke table handler(OZF_DISC_LINE_PKG.Insert_Row)
1056: OZF_DISC_LINE_PKG.Insert_Row(
1057: px_offer_discount_line_id => l_offer_discount_line_id,
1058: p_parent_discount_line_id => l_ozf_offer_line_rec.parent_discount_line_id,
1059: p_volume_from => l_ozf_offer_line_rec.volume_from,
1060: p_volume_to => l_ozf_offer_line_rec.volume_to,
1314: END IF;
1315:
1316: -- Debug Message
1317:
1318: -- Invoke table handler(OZF_DISC_LINE_PKG.Update_Row)
1319: OZF_DISC_LINE_PKG.Update_Row(
1320: p_offer_discount_line_id => p_ozf_offer_line_rec.offer_discount_line_id,
1321: p_parent_discount_line_id => p_ozf_offer_line_rec.parent_discount_line_id,
1322: p_volume_from => p_ozf_offer_line_rec.volume_from,
1315:
1316: -- Debug Message
1317:
1318: -- Invoke table handler(OZF_DISC_LINE_PKG.Update_Row)
1319: OZF_DISC_LINE_PKG.Update_Row(
1320: p_offer_discount_line_id => p_ozf_offer_line_rec.offer_discount_line_id,
1321: p_parent_discount_line_id => p_ozf_offer_line_rec.parent_discount_line_id,
1322: p_volume_from => p_ozf_offer_line_rec.volume_from,
1323: p_volume_to => p_ozf_offer_line_rec.volume_to,
1510: --
1511: -- Debug Message
1512: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1513:
1514: -- Invoke table handler(OZF_DISC_LINE_PKG.Delete_Row)
1515: OZF_DISC_LINE_PKG.Delete_Row(
1516: p_offer_discount_line_id => p_offer_discount_line_id,
1517: p_object_version_number => p_object_version_number );
1518: --
1511: -- Debug Message
1512: OZF_UTILITY_PVT.debug_message( 'Private API: Calling delete table handler');
1513:
1514: -- Invoke table handler(OZF_DISC_LINE_PKG.Delete_Row)
1515: OZF_DISC_LINE_PKG.Delete_Row(
1516: p_offer_discount_line_id => p_offer_discount_line_id,
1517: p_object_version_number => p_object_version_number );
1518: --
1519: -- End of API body
6832: OZF_UTILITY_PVT.ERROR_MESSAGE('PARENT_NOT_PBH');
6833: RAISE FND_API.G_EXC_ERROR;
6834: END IF;
6835:
6836: OZF_DISC_LINE_PKG.delete_tiers(p_parent_discount_line_id);
6837: --
6838: EXCEPTION
6839: WHEN FND_API.G_EXC_ERROR THEN
6840: ROLLBACK TO Delete_Disc_tiers_PVT;