[Home] [Help]
1010: l_validation_level NUMBER := fnd_api.g_valid_level_full; --bug 5068433
1011: BEGIN
1012:
1013: IF (l_debug = 1) THEN
1014: print_debug('=== Calling WMS_Container_PUB.PackUnpack_Container ===');
1015: print_debug('p_lpn_id =>' || p_lpn_id);
1016: print_debug('p_lot_number =>' || p_lot_number);
1017: print_debug('p_from_serial_number =>' || p_from_serial_number);
1018: print_debug('p_to_serial_number =>' || p_to_serial_number);
1049: l_validation_level := fnd_api.g_valid_level_none;
1050: END IF;
1051:
1052:
1053: WMS_Container_PUB.PackUnpack_Container(
1054: p_api_version => 1.0,
1055: p_validation_level => l_validation_level,--bug 5048633
1056: x_return_status => x_return_status,
1057: x_msg_count => x_msg_count,
1571: -- receiving' as packunpack api may have changed it to
1572: -- 'Defined but not used'
1573:
1574: UPDATE wms_license_plate_numbers
1575: SET lpn_context = wms_container_pub.lpn_context_rcv
1576: WHERE lpn_id = l_pack_lpn;
1577:
1578: ELSIF ((i.lpn_id IS NOT NULL OR i.transfer_lpn_id IS NOT NULL) AND
1579: l_parent_transaction_type in ('RECEIVE','RETURN TO VENDOR','RETURN TO CUSTOMER')) THEN
1690: -- packunpack api might have changed the context
1691: -- to 'Defined But not used'
1692: IF (l_parent_transaction_type = 'RECEIVE') THEN
1693: UPDATE wms_license_plate_numbers
1694: SET lpn_context = wms_container_pub.lpn_context_rcv
1695: WHERE lpn_id = l_lpn_id;
1696: END IF;
1697:
1698: END IF;
2340: l_primary_uom VARCHAR2(10);
2341: l_uom VARCHAR2(3);--BUG 4939647: For non-serial controlled item, always pass the txn uom
2342:
2343: -- bug 4411792
2344: l_lpn_update WMS_CONTAINER_PUB.LPN;
2345: l_return_status VARCHAR2(1);
2346: l_msg_count NUMBER;
2347: l_msg_data VARCHAR2(2000);
2348:
2749:
2750: END LOOP;
2751:
2752: UPDATE wms_license_plate_numbers
2753: SET lpn_context = wms_container_pub.lpn_context_rcv
2754: WHERE lpn_id = p_lpn_id;
2755:
2756: UPDATE mtl_txn_request_lines
2757: SET wms_process_flag = 2