[Home] [Help]
146: l_serial_number VARCHAR2(30);
147: l_mtl_reservation inv_reservation_global.mtl_reservation_tbl_type;
148: l_trolin_tbl inv_move_order_pub.trolin_tbl_type;
149: l_auto_pick_confirm NUMBER;
150: l_pick_release_status inv_pick_release_pub.inv_release_status_tbl_type;
151: l_return_status VARCHAR2(1);
152: l_grouping_rule_id NUMBER;
153: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
154: l_mold_tbl_temp inv_mo_line_detail_util.g_mmtt_tbl_type;
214: CLOSE c_mtrh;
215:
216: IF p_move_order_type = inv_globals.g_move_order_pick_wave THEN
217: IF l_debug = 1 THEN
218: print_debug('Pickwave MO. Calling INV_PICK_RELEASE_PUB.PICK_RELEASE to allocate');
219: END IF;
220:
221: IF p_auto_pick_confirm IS NOT NULL AND p_auto_pick_confirm = FALSE THEN
222: l_auto_pick_flag := 'N';
268: ELSE
269: l_commit := fnd_api.g_false;
270: END IF;
271:
272: inv_pick_release_pub.pick_release(
273: p_api_version => 1.0
274: , p_init_msg_list => fnd_api.g_false
275: , p_commit => l_commit
276: , x_return_status => l_return_status
284: , p_plan_tasks => p_plan_tasks
285: );
286:
287: IF (l_debug = 1) THEN
288: print_debug('l_return_status from inv_pick_release_pub.pick_release is ' || l_return_status);
289: END IF;
290:
291: IF (l_return_status <> fnd_api.g_ret_sts_success) THEN
292: IF (l_debug = 1) THEN
1388: l_missing_quantity NUMBER := p_missing_quantity;
1389: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1390: BEGIN
1391: -- call the reserve unconfirmed quantity
1392: inv_pick_release_pub.reserve_unconfirmed_quantity(
1393: p_api_version => 1.0
1394: , x_return_status => l_return_status
1395: , x_msg_count => x_msg_count
1396: , x_msg_data => x_msg_data