281: CLOSE ProdTxn_Cur_Type;
282: debug('object version number fetched ['||l_Product_Txn_Rec.Object_Version_NUMBER||']');
283:
284: -- Validate Product_Transaction_Id is null
285: CSD_PROCESS_UTIL.Check_Reqd_Param(p_param_value => p_Upd_ProdTxn_Rec.Product_Transaction_id,
286: p_param_name => 'Product Transaction ID',
287: p_api_name => C_API_Name);
288:
289: debug('Validating the prod txn id');
288:
289: debug('Validating the prod txn id');
290: -- Validate the Product_Transaction_Id exists in csd_product_transactions
291: IF NOT
292: (CSD_PROCESS_UTIL.Validate_prod_txn_id(p_prod_txn_id => p_Upd_ProdTxn_Rec.Product_Transaction_id))
293: THEN
294: RAISE FND_API.G_EXC_ERROR;
295: END IF;
296: