[Home] [Help]
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;
162: l_message VARCHAR2(2000);
163: l_count NUMBER;
164: l_from_serial_number VARCHAR2(30);
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;
162: l_message VARCHAR2(2000);
163: l_count NUMBER;
164: l_from_serial_number VARCHAR2(30);
165: l_to_serial_number VARCHAR2(30);
382: COMMIT;
383: IF (l_debug = 1) THEN
384: print_debug('auto pick confirm');
385: END IF;
386: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_trolin_tbl(1).line_id);
387: l_mold_tbl_temp := l_mold_tbl;
388:
389: IF (l_mold_tbl.COUNT = 0) THEN
390: l_return_status := fnd_api.g_ret_sts_unexp_error;
990: l_error_code NUMBER;
991: l_count NUMBER;
992: l_success BOOLEAN;
993: l_umconvert_trans_quantity NUMBER := 0;
994: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
995: l_primary_uom VARCHAR2(10);
996: l_ato_item NUMBER := 0;
997: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
998: BEGIN
1045: IF l_ato_item = 1 THEN
1046: -- If item is ato item, reduce the detailed quantity by the transaction
1047: -- quantity and retain the reservation.Convert to primary uom before
1048: -- reducing detailed quantity.
1049: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
1050: l_umconvert_trans_quantity := p_transaction_quantity;
1051:
1052: IF l_mmtt_rec.inventory_item_id IS NOT NULL
1053: AND l_mmtt_rec.transaction_uom IS NOT NULL THEN
1142: because, if this procedure is called from the 'Transact Move Order Line Allocations' form when the user
1143: presses the DELETE button, deletion of these rows is already handled.*/
1144: /*Bug10015753,the MSN mark label not removed caused by bug5505709,
1145: since the issue ''FRM-40510: Oracle error: unable to DELETE record.' reported on bug5505709,
1146: it caused by double MMTT deleting, we only need to add the condition on calling inv_mo_line_detail_util.delete_row from the 'Transact Move Order Line Allocations' form,
1147: we should call clear_record API to remove the orphan records in MSNT/MTLT.
1148: */
1149: CLEAR_RECORD(p_transaction_temp_id, l_success);
1150:
1152: RAISE fnd_api.g_exc_error;
1153: END IF;
1154:
1155: IF (p_delete_temp_records) THEN
1156: inv_mo_line_detail_util.delete_row( x_return_status => l_return_status
1157: , p_line_id => p_move_order_line_id
1158: , p_line_detail_id => p_transaction_temp_id);
1159:
1160: /* select count(1) into l_count
1367: , x_msg_count OUT NOCOPY NUMBER
1368: , x_msg_data OUT NOCOPY VARCHAR2
1369: ) IS
1370: l_transaction_temp_id NUMBER := p_transaction_temp_id;
1371: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1372: l_next_id NUMBER;
1373: l_return_status VARCHAR2(1);
1374: l_count NUMBER;
1375: l_primary_quantity NUMBER;
1379: SELECT mtl_material_transactions_s.NEXTVAL
1380: INTO l_next_id
1381: FROM DUAL;
1382:
1383: l_mmtt_rec := inv_mo_line_detail_util.query_row(l_transaction_temp_id);
1384: --inv_debug.message('l_next_id ' || l_next_id);
1385: l_mmtt_rec.transaction_temp_id := l_next_id;
1386: l_mmtt_rec.transaction_quantity := p_detailed_quantity - p_transaction_quantity - p_missing_quantity;
1387:
1407: END IF;
1408:
1409: l_mmtt_rec.transaction_status := 2;
1410: l_mmtt_rec.transaction_header_id := NULL;
1411: inv_mo_line_detail_util.insert_row(x_return_status => l_return_status, p_mo_line_detail_rec => l_mmtt_rec);
1412:
1413: --inv_debug.message('after insert row '|| l_return_status );
1414: SELECT COUNT(*)
1415: INTO l_count
1450: ) IS
1451: l_line_id NUMBER := p_line_id;
1452: l_return_status VARCHAR2(1);
1453: l_grouping_rule_id NUMBER;
1454: l_mold_tbl inv_mo_line_detail_util.g_mmtt_tbl_type;
1455: l_message VARCHAR2(2000);
1456: l_count NUMBER;
1457: l_from_serial_number VARCHAR2(30);
1458: l_to_serial_number VARCHAR2(30);
1462: --inv_debug.message('auto pick confirm');
1463: --inv_debug.message('get trolin');
1464: l_trolin_tbl := inv_trolin_util.query_rows(p_line_id => l_line_id);
1465: --inv_debug.message('get mold');
1466: l_mold_tbl := inv_mo_line_detail_util.query_rows(p_line_id => l_line_id);
1467: --inv_debug.message('number of mold record is ' || l_mold_tbl.count);
1468: inv_pick_wave_pick_confirm_pub.pick_confirm(
1469: p_api_version_number => 1.0
1470: , p_init_msg_list => fnd_api.g_false
1569: l_return_status VARCHAR2(1);
1570: l_msg_count NUMBER;
1571: l_msg_data VARCHAR2(2000);
1572: l_error_code NUMBER;
1573: l_mmtt_rec inv_mo_line_detail_util.g_mmtt_rec;
1574: l_mmtt_count NUMBER;
1575: l_reservation_id NUMBER := p_reservation_id;
1576: l_original_serial_number inv_reservation_global.serial_number_tbl_type;
1577: l_to_serial_number inv_reservation_global.serial_number_tbl_type;
1600: l_lot_transaction_quantity NUMBER;
1601: l_debug NUMBER := NVL(fnd_profile.VALUE('INV_DEBUG_TRACE'), 0);
1602: BEGIN
1603: --inv_Debug.message('ssia', 'Inside changed_from_subinventory');
1604: l_mmtt_rec := inv_mo_line_detail_util.query_row(p_transaction_temp_id);
1605:
1606: --inv_Debug.message('ssia', 'transaction_temp_id is ' || p_transaction_temp_id);
1607:
1608: SELECT reservable_type