2818:
2819: l_prefix VARCHAR2(10);
2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2819: l_prefix VARCHAR2(10);
2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2820: l_result BOOLEAN;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2821: l_valid_serial_range NUMBER;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2822: l_org INV_VALIDATE.org;
2823: l_item INV_VALIDATE.item;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2824: l_lot INV_VALIDATE.lot;
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2825: l_locator INV_VALIDATE.locator;
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2826: l_sub INV_VALIDATE.sub;
2827:
2828: p_fm_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2829: p_to_serial INV_VALIDATE.SERIAL_NUMBER_TBL;
2830: x_errored_serials INV_VALIDATE.SERIAL_NUMBER_TBL;
2831:
2832: /************************MATERIAL STATUS CONTROL ********/
2833:
2834: l_line_inv_rec wsh_delivery_details_inv.line_inv_info;
3115: l_sub.secondary_inventory_name := l_line_inv_rec.subinventory;
3116: l_lot.lot_number := l_line_inv_rec.lot_number;
3117: l_locator.inventory_location_id := l_line_inv_rec.locator_id;
3118:
3119: l_valid_serial_range := INV_VALIDATE.validate_serial_range(
3120: p_fm_serial => p_fm_serial,
3121: p_to_serial => p_to_serial,
3122: p_org => l_org,
3123: p_item => l_item ,
3144: return;
3145: END IF;
3146:
3147: ELSE
3148: WSH_DELIVERY_DETAILS_INV.Validate_Serial( p_serial_number => l_line_inv_rec.serial_number,
3149: p_lot_number => l_line_inv_rec.lot_number,
3150: p_organization_id => l_line_inv_rec.organization_id ,
3151: p_inventory_item_id => l_line_inv_rec.inventory_item_id ,
3152: p_subinventory => l_line_inv_rec.subinventory ,