195: l_total_wdd_req_qty := -1;
196: l_extra_rsv_quantity := 0;
197: l_extra_rsv_quantity2 := 0;
198: l_total_rsv_quantity2 := 0;
199: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
200:
201: IF p_line_id IS NOT NULL
202: THEN
203: -- {
1326:
1327: -- {{
1328: -- BEGIN reduce_move_order_quantity }}
1329: --
1330: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1331:
1332: IF (l_debug = 1) THEN
1333: DEBUG('Entered with parameters: '
1334: || ' p_line_id: ' || to_char(p_line_id)
2260: l_deleted_quantity NUMBER;
2261: l_return_status VARCHAR2(1);
2262: l_error_code NUMBER;
2263: l_ato_serial_pick VARCHAR2(1); -- Bug 7190635
2264: l_retain_ato_profile VARCHAR2(1) := NVL(fnd_profile.VALUE('WSH_RETAIN_ATO_RESERVATIONS'),'N'); --Bug 7190635
2265:
2266: CURSOR c_primary_uom IS
2267: SELECT primary_uom_code
2268: FROM mtl_system_items
2268: FROM mtl_system_items
2269: WHERE organization_id = l_organization_id
2270: AND inventory_item_id = l_inventory_item_id;
2271:
2272: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2273: BEGIN
2274: IF (l_debug = 1) THEN
2275: DEBUG('Setting Savepoint', 'reduce_rsv_allocation');
2276: END IF;
2546: DEBUG('carton group id: ' || p_carton_grouping_id, 'update_mol_carton_group');
2547: DEBUG('before update statement...', 'update_mol_carton_group');
2548: END IF;
2549:
2550: l_debug := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
2551: x_return_status := fnd_api.g_ret_sts_success;
2552:
2553: -- {{
2554: -- BEGIN update_mol_carton_group }}