601: ** To identify lot corruption in WMS enabled orgs --bug#10415632
602: */
603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN
602: */
603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN
610: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Lot Control code : ' || l_lot_code||', Lot Number : '|| l_lot_number);
603: --13390994
604: --Removed the query to fetch Lot Control and got it from Cache
605: IF inv_cache.set_item_rec(p_org_id , l_inventory_item_id) THEN
606: l_lot_code := inv_cache.item_rec.lot_control_code;
607: l_serial_control_code := inv_cache.item_rec.serial_number_control_code;
608: END IF;
609: IF (l_debug = 1) THEN
610: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Lot Control code : ' || l_lot_code||', Lot Number : '|| l_lot_number);
611: mydebug('create_mo: Item Id : ' || l_inventory_item_id || ', Serial Control Code : ' || l_serial_control_code);