[Home] [Help]
3490:
3491: /*
3492: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3493:
3494: DELETE FROM MSC_UOM_CONVERSIONS
3495: WHERE SR_INSTANCE_ID IN ( MSC_CL_COLLECTION.v_instance_id, -MSC_CL_COLLECTION.v_instance_id);
3496:
3497: COMMIT;
3498:
3505:
3506: BEGIN
3507:
3508: /* changed the where cond to update the row based on UOM code as a new
3509: index on MSC_UOM_CONVERSIONS(INVENTORY_ITEM_ID,UOM_CODE) is introduced */
3510:
3511: UPDATE MSC_UOM_CONVERSIONS muc
3512: SET UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE,
3513: UOM_CODE= c_rec.UOM_CODE,
3507:
3508: /* changed the where cond to update the row based on UOM code as a new
3509: index on MSC_UOM_CONVERSIONS(INVENTORY_ITEM_ID,UOM_CODE) is introduced */
3510:
3511: UPDATE MSC_UOM_CONVERSIONS muc
3512: SET UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE,
3513: UOM_CODE= c_rec.UOM_CODE,
3514: UOM_CLASS= c_rec.UOM_CLASS,
3515: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
3524: AND muc.UOM_CODE = c_rec.UOM_CODE;
3525:
3526: IF SQL%NOTFOUND THEN
3527:
3528: insert into MSC_UOM_CONVERSIONS
3529: ( UNIT_OF_MEASURE,
3530: UOM_CODE,
3531: UOM_CLASS,
3532: INVENTORY_ITEM_ID,
3570:
3571: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3572: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3573: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3574: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CONVERSIONS');
3575: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3576:
3577: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3578: RAISE;
3583:
3584: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3585: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3586: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3587: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CONVERSIONS');
3588: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3589:
3590: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3591: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.item_name');