238: RAISE FND_API.G_EXC_ERROR;
239: END IF;
240: END IF;
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
239: END IF;
240: END IF;
241:
242: -- Invoke table handler(CSC_PLAN_LINES_PKG.Insert_Row)
243: CSC_PLAN_LINES_PKG.Insert_Row(
244: px_LINE_ID => x_LINE_ID,
245: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
246: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
247: p_CREATION_DATE => SYSDATE,
512: IF x_return_status<>FND_API.G_RET_STS_SUCCESS THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: -- Invoke table handler(CSC_PLAN_LINES_PKG.Update_Row)
517: CSC_PLAN_LINES_PKG.Update_Row(
518: p_LINE_ID => p_CSC_PLAN_LINES_rec.LINE_ID,
519: p_PLAN_ID => p_CSC_PLAN_LINES_rec.PLAN_ID,
520: p_CONDITION_ID => p_CSC_PLAN_LINES_rec.CONDITION_ID,
521: p_CREATION_DATE => SYSDATE,
624:
625: -- Initialize API return status to SUCCESS
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)
629: CSC_PLAN_LINES_PKG.Delete_Row(
630: p_PLAN_ID => P_PLAN_ID,
631: p_LINE_ID => P_LINE_ID);
632:
625: -- Initialize API return status to SUCCESS
626: x_return_status := FND_API.G_RET_STS_SUCCESS;
627:
628: -- Invoke table handler(CSC_PLAN_LINES_PKG.Delete_Row)
629: CSC_PLAN_LINES_PKG.Delete_Row(
630: p_PLAN_ID => P_PLAN_ID,
631: p_LINE_ID => P_LINE_ID);
632:
633: -- Standard check for p_commit