303: FETCH RepairStatus_Cur_Type
304: INTO l_RO_NUMBER, l_RO_Status_Meaning;
305: CLOSE RepairStatus_Cur_Type;
306: -- RAISE Error message
307: FND_MESSAGE.SET_NAME('CSD', 'CSD_RO_NOT_OPEN_NO_PRODTXN_UPD');
308: FND_MESSAGE.SET_TOKEN('RO_NUMBER', l_RO_NUMBER);
309: FND_MESSAGE.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
304: INTO l_RO_NUMBER, l_RO_Status_Meaning;
305: CLOSE RepairStatus_Cur_Type;
306: -- RAISE Error message
307: FND_MESSAGE.SET_NAME('CSD', 'CSD_RO_NOT_OPEN_NO_PRODTXN_UPD');
308: FND_MESSAGE.SET_TOKEN('RO_NUMBER', l_RO_NUMBER);
309: FND_MESSAGE.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312:
305: CLOSE RepairStatus_Cur_Type;
306: -- RAISE Error message
307: FND_MESSAGE.SET_NAME('CSD', 'CSD_RO_NOT_OPEN_NO_PRODTXN_UPD');
308: FND_MESSAGE.SET_TOKEN('RO_NUMBER', l_RO_NUMBER);
309: FND_MESSAGE.SET_TOKEN('RO_STATUS', l_RO_Status_Meaning);
310: FND_MSG_PUB.ADD;
311: RAISE FND_API.G_EXC_ERROR;
312:
313: END IF;
318: IF l_Product_Txn_Rec.Object_Version_NUMBER <>
319: p_Upd_ProdTxn_Rec.Object_Version_Number
320: THEN
321:
322: FND_MESSAGE.SET_NAME('CSD', 'CSD_OBJECT_VERSION_NUMBER');
323: FND_MSG_PUB.ADD;
324: RAISE FND_API.G_EXC_ERROR;
325:
326: END IF;