[Home] [Help]
3480:
3481: /*
3482: IF MSC_CL_COLLECTION.v_is_complete_refresh THEN
3483:
3484: DELETE FROM MSC_UOM_CONVERSIONS
3485: WHERE SR_INSTANCE_ID IN ( MSC_CL_COLLECTION.v_instance_id, -MSC_CL_COLLECTION.v_instance_id);
3486:
3487: COMMIT;
3488:
3495:
3496: BEGIN
3497:
3498: /* changed the where cond to update the row based on UOM code as a new
3499: index on MSC_UOM_CONVERSIONS(INVENTORY_ITEM_ID,UOM_CODE) is introduced */
3500:
3501: UPDATE MSC_UOM_CONVERSIONS muc
3502: SET UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE,
3503: UOM_CODE= c_rec.UOM_CODE,
3497:
3498: /* changed the where cond to update the row based on UOM code as a new
3499: index on MSC_UOM_CONVERSIONS(INVENTORY_ITEM_ID,UOM_CODE) is introduced */
3500:
3501: UPDATE MSC_UOM_CONVERSIONS muc
3502: SET UNIT_OF_MEASURE= c_rec.UNIT_OF_MEASURE,
3503: UOM_CODE= c_rec.UOM_CODE,
3504: UOM_CLASS= c_rec.UOM_CLASS,
3505: INVENTORY_ITEM_ID= c_rec.INVENTORY_ITEM_ID,
3514: AND muc.UOM_CODE = c_rec.UOM_CODE;
3515:
3516: IF SQL%NOTFOUND THEN
3517:
3518: insert into MSC_UOM_CONVERSIONS
3519: ( UNIT_OF_MEASURE,
3520: UOM_CODE,
3521: UOM_CLASS,
3522: INVENTORY_ITEM_ID,
3560:
3561: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3562: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3563: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3564: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CONVERSIONS');
3565: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3566:
3567: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, SQLERRM);
3568: RAISE;
3573:
3574: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, '========================================');
3575: FND_MESSAGE.SET_NAME('MSC', 'MSC_OL_DATA_ERR_HEADER');
3576: FND_MESSAGE.SET_TOKEN('PROCEDURE', 'LOAD_UOM');
3577: FND_MESSAGE.SET_TOKEN('TABLE', 'MSC_UOM_CONVERSIONS');
3578: MSC_UTIL.LOG_MSG(MSC_UTIL.G_D_STATUS, FND_MESSAGE.GET);
3579:
3580: FND_MESSAGE.SET_NAME('MSC','MSC_OL_DATA_ERR_DETAIL');
3581: FND_MESSAGE.SET_TOKEN('COLUMN', 'MSC_CL_ITEM_ODS_LOAD.item_name');