9109: FETCH l_int_pricing_effective_date into l_pricing_effective_date;
9110: CLOSE l_int_pricing_effective_date;
9111: END IF;
9112:
9113: QP_COUPON_PVT.Set_Expiration_Dates
9114: (l_dummy,
9115: l_expiration_period_end_date,
9116: p_number_expiration_period,
9117: p_expiration_period_uom_code,
9128: EXCEPTION
9129:
9130: WHEN E_Coupon_Error THEN
9131: IF G_DEBUG_ENGINE = FND_API.G_TRUE THEN
9132: engine_debug('Error returned by QP_COUPON_PVT.Set_Expiration_Dates');
9133: END IF;
9134: x_status_code := FND_API.G_RET_STS_ERROR;
9135: x_status_text :=l_routine||':'||l_status_text;
9136: WHEN OTHERS THEN
33862: END IF;
33863: END IF;
33864:
33865:
33866: l_status_text:='QP_COUPON_PVT.REDEEM_COUPONS';
33867: QP_COUPON_PVT.REDEEM_COUPONS(p_control_rec.simulation_flag, l_return_status, l_status_text);
33868:
33869: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
33870: l_status_text:= 'QP_COUPON_PVT.REDEEM_COUPONS'||l_status_text;
33863: END IF;
33864:
33865:
33866: l_status_text:='QP_COUPON_PVT.REDEEM_COUPONS';
33867: QP_COUPON_PVT.REDEEM_COUPONS(p_control_rec.simulation_flag, l_return_status, l_status_text);
33868:
33869: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
33870: l_status_text:= 'QP_COUPON_PVT.REDEEM_COUPONS'||l_status_text;
33871: RAISE E_ROUTINE_ERRORS;
33866: l_status_text:='QP_COUPON_PVT.REDEEM_COUPONS';
33867: QP_COUPON_PVT.REDEEM_COUPONS(p_control_rec.simulation_flag, l_return_status, l_status_text);
33868:
33869: IF(l_return_status = FND_API.G_RET_STS_ERROR) THEN
33870: l_status_text:= 'QP_COUPON_PVT.REDEEM_COUPONS'||l_status_text;
33871: RAISE E_ROUTINE_ERRORS;
33872: END IF;
33873: -----------------END: Specific to PL/SQL Engine----------------------
33874: ELSE --Java Engine installed