[Home] [Help]
1014:
1015: BEGIN
1016:
1017: IF (l_debug = 1) THEN
1018: print_debug('=== Calling WMS_Container_PUB.PackUnpack_Container ===');
1019: print_debug('p_lpn_id =>' || p_lpn_id);
1020: print_debug('p_lot_number =>' || p_lot_number);
1021: print_debug('p_from_serial_number =>' || p_from_serial_number);
1022: print_debug('p_to_serial_number =>' || p_to_serial_number);
1066: print_debug('l_sec_qty =>' || l_sec_qty);--bug13011555
1067: END IF;
1068:
1069:
1070: WMS_Container_PUB.PackUnpack_Container(
1071: p_api_version => 1.0,
1072: p_validation_level => l_validation_level,--bug 5048633
1073: x_return_status => x_return_status,
1074: x_msg_count => x_msg_count,
1590: -- receiving' as packunpack api may have changed it to
1591: -- 'Defined but not used'
1592:
1593: UPDATE wms_license_plate_numbers
1594: SET lpn_context = wms_container_pub.lpn_context_rcv
1595: WHERE lpn_id = l_pack_lpn;
1596:
1597: ELSIF ((i.lpn_id IS NOT NULL OR i.transfer_lpn_id IS NOT NULL) AND
1598: l_parent_transaction_type in ('RECEIVE','RETURN TO VENDOR','RETURN TO CUSTOMER')) THEN
1709: -- packunpack api might have changed the context
1710: -- to 'Defined But not used'
1711: IF (l_parent_transaction_type = 'RECEIVE') THEN
1712: UPDATE wms_license_plate_numbers
1713: SET lpn_context = wms_container_pub.lpn_context_rcv
1714: WHERE lpn_id = l_lpn_id;
1715: END IF;
1716:
1717: END IF;
2391: l_primary_uom VARCHAR2(10);
2392: l_uom VARCHAR2(3);--BUG 4939647: For non-serial controlled item, always pass the txn uom
2393:
2394: -- bug 4411792
2395: l_lpn_update WMS_CONTAINER_PUB.LPN;
2396: l_return_status VARCHAR2(1);
2397: l_msg_count NUMBER;
2398: l_msg_data VARCHAR2(2000);
2399:
3661:
3662: END LOOP;
3663:
3664: UPDATE wms_license_plate_numbers
3665: SET lpn_context = wms_container_pub.lpn_context_rcv
3666: WHERE lpn_id = p_lpn_id;
3667:
3668: UPDATE mtl_txn_request_lines
3669: SET wms_process_flag = 2