[Home] [Help]
153: l_serial_number VARCHAR2(30);
154: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
155: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
156: l_auto_pick_confirm NUMBER;
157: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
158: l_return_status VARCHAR2(1);
159: l_grouping_rule_id NUMBER;
160: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
161: l_mold_tbl_temp inv_mo_line_detail_util.g_mmtt_tbl_type;
245: CLOSE c_mtrh;
246:
247: IF p_move_order_type = inv_globals.g_move_order_pick_wave THEN
248: IF l_debug = 1 THEN
249: print_debug('Pickwave MO. Calling INV_PICK_RELEASE_PUB.PICK_RELEASE to allocate');
250: END IF;
251:
252: IF p_auto_pick_confirm IS NOT NULL AND p_auto_pick_confirm = FALSE THEN
253: l_auto_pick_flag := 'N';
299: ELSE
300: l_commit := fnd_api.g_false;
301: END IF;
302:
303: inv_pick_release_pub.pick_release(
304: p_api_version => 1.0
305: , p_init_msg_list => fnd_api.g_false
306: , p_commit => l_commit
307: , x_return_status => l_return_status
315: , p_plan_tasks => p_plan_tasks
316: );
317:
318: IF (l_debug = 1) THEN
319: print_debug('l_return_status from inv_pick_release_pub.pick_release is ' || l_return_status);
320: END IF;
321:
322: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
323: IF (l_debug = 1) THEN
1520: l_missing_quantity NUMBER := p_missing_quantity;
1521: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1522: BEGIN
1523: -- call the reserve unconfirmed quantity
1524: inv_pick_release_pub.reserve_unconfirmed_quantity(
1525: p_api_version => 1.0
1526: , x_return_status => l_return_status
1527: , x_msg_count => x_msg_count
1528: , x_msg_data => x_msg_data