[Home] [Help]
371: IF (l_par_lpn_id > 0 ) THEN
372: IF (l_debug = 1) THEN
373: debug('Unpacking LPN_id '||l_lpn_id || ' from '||l_par_lpn_id);
374: END IF;
375: wms_container_pvt.packunpack_container
376: (p_api_version => 1.0
377: ,p_content_lpn_id => l_lpn_id -- child LPN ID
378: ,p_lpn_id => l_par_lpn_id -- Parent LPN ID
379: ,p_operation => 2 -- Unpack
4815: IF (l_parent_lpn_id IS NOT NULL) THEN
4816: IF (l_debug = 1) THEN
4817: DEBUG(' Unpacking LPN from Parent LPN' ,l_proc_name,9);
4818: END IF;
4819: wms_container_pvt.packunpack_container
4820: (p_api_version => 1.0
4821: ,p_content_lpn_id => p_lpn_id
4822: ,p_lpn_id => l_parent_lpn_id
4823: ,p_operation => 2 /* Unpack */
6016: DEBUG('Packing LPN ' || Nvl(p_lpn_id, -999) ||
6017: ' into Parent LPN ' || Nvl(p_parent_lpn_id, -999), l_proc_name,9);
6018: END IF;
6019:
6020: wms_container_pvt.packunpack_container
6021: (p_api_version => 1.0
6022: ,p_content_lpn_id => p_lpn_id
6023: ,p_lpn_id => p_parent_lpn_id
6024: ,p_operation => 1 -- Pack
7582: IF l_parent_lpn_id IS NOT NULL THEN
7583: IF(l_debug = 1) THEN
7584: debug('Receiving LPN, Parent lpn is not null, Unpack '||p_from_lpn_id||' from ' ||l_parent_lpn_id);
7585: END IF;
7586: wms_container_pvt.packunpack_container
7587: (p_api_version => 1.0
7588: ,p_content_lpn_id => p_from_lpn_id
7589: ,p_lpn_id => l_parent_lpn_id
7590: ,p_operation => 2 -- Unpack
7613:
7614: -- Only modify LPN sub/loc if it is WIP LPN, since the RCV case
7615: -- won't even reach this point
7616: IF (l_lpn_context=2 AND l_sub_loc_changed = 'Y') THEN
7617: wms_container_pvt.modify_lpn_wrapper
7618: ( p_api_version => 1.0
7619: ,x_return_status => x_return_status
7620: ,x_msg_count => x_msg_count
7621: ,x_msg_data => x_msg_data
7630: END IF;
7631: END IF;
7632: END IF;
7633:
7634: wms_container_pvt.packunpack_container
7635: (p_api_version => 1.0
7636: ,p_content_lpn_id => p_from_lpn_id
7637: ,p_lpn_id => p_to_lpn_id
7638: ,p_operation => 1 --Pack
8458: debug('Resides in WIP LPN, Parent lpn is not null, Unpack '||p_from_lpn_id||' from ' ||p_parent_lpn_id);
8459: END IF;
8460:
8461: -- unpack from LPN from its parent.
8462: wms_container_pvt.packunpack_container
8463: (p_api_version => 1.0
8464: ,p_content_lpn_id => p_from_lpn_id
8465: ,p_lpn_id => p_parent_lpn_id
8466: ,p_operation => 2 -- Unpack
8546: IF(l_debug = 1) THEN
8547: debug('WIP LPN, Parent lpn is not null, Unpack '||l_lpn_id||' from ' ||p_from_lpn_id);
8548: END IF;
8549:
8550: wms_container_pvt.packunpack_container
8551: (p_api_version => 1.0
8552: ,p_content_lpn_id => l_lpn_id -- child LPN ID
8553: ,p_lpn_id => p_from_lpn_id -- Parent LPN ID
8554: ,p_operation => 2 -- Unpack
9340: l_progress := '160';
9341:
9342: -- Call packunpack on each inner LPN
9343: FOR i IN 1 .. l_lpn_ids.COUNT LOOP
9344: wms_container_pvt.packunpack_container
9345: (p_api_version => 1.0
9346: ,p_content_lpn_id => l_lpn_ids(i)
9347: ,p_lpn_id => p_from_lpn_id
9348: ,p_operation => 2 /* Unpack */
9359: END IF;
9360: RAISE fnd_api.g_exc_error;
9361: END IF;
9362:
9363: wms_container_pvt.packunpack_container
9364: (p_api_version => 1.0
9365: ,p_content_lpn_id => l_lpn_ids(i)
9366: ,p_lpn_id => p_into_lpn_Id
9367: ,p_operation => 1 /* Pack */
9447: '||l_wlpnc_rec.inventory_item_id,
9448: 'transfer_contents',9);
9449: END IF;
9450:
9451: wms_container_pvt.packunpack_container
9452: (p_api_version => 1.0
9453: ,p_lpn_id => p_from_lpn_id
9454: ,p_operation => 2 -- UNPACK
9455: ,p_organization_id => l_org_id
9470: END IF;
9471: RAISE fnd_api.g_exc_error;
9472: END IF;
9473:
9474: wms_container_pvt.packunpack_container
9475: (p_api_version => 1.0
9476: ,p_lpn_id => p_into_lpn_id
9477: ,p_operation => 1 -- PACK
9478: ,p_organization_id => l_org_id
9520: IF (l_debug = 1) THEN
9521: DEBUG('transfer_contents: unpacking serial number:'
9522: || l_serial_numbers(i),9);
9523: END IF;
9524: wms_container_pvt.packunpack_container
9525: (p_api_version => 1.0
9526: ,p_lpn_id => p_from_lpn_id
9527: ,p_operation => 2 -- UNPACK
9528: ,p_organization_id => l_org_id
9543: p_from_lpn_id,'transfer_contents',9);
9544: END IF;
9545: RAISE fnd_api.g_exc_error;
9546: END IF;
9547: wms_container_pvt.packunpack_container
9548: (p_api_version => 1.0
9549: ,p_lpn_id => p_into_lpn_id
9550: ,p_operation => 1 -- PACK
9551: ,p_organization_id => l_org_id
9588:
9589: l_progress := '210';
9590:
9591: FOR i IN 1 .. l_lpn_ids.COUNT LOOP
9592: wms_container_pvt.packunpack_container
9593: (p_api_version => 1.0
9594: ,p_content_lpn_id => l_lpn_ids(i)
9595: ,p_lpn_id => p_from_lpn_id
9596: ,p_operation => 2 /* Unpack */
9606: p_from_lpn_id,'transfer_contents',9);
9607: END IF;
9608: RAISE fnd_api.g_exc_error;
9609: END IF;
9610: wms_container_pvt.packunpack_container
9611: (p_api_version => 1.0
9612: ,p_content_lpn_id => l_lpn_ids(i)
9613: ,p_lpn_id => p_into_lpn_Id
9614: ,p_operation => 1 /* Pack */