eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.WMS_POSTALLOC_PVT dependencies on WMS_CARTNZN_PUB

Line 2169: WMS_CARTNZN_PUB.cartonize_single_item

2165:
2166: l_api_return_status := fnd_api.g_ret_sts_success;
2167: FOR ii IN rules_table.FIRST .. rules_table.LAST LOOP --{
2168: IF rules_table(ii).return_type_id = 1 THEN
2169: WMS_CARTNZN_PUB.cartonize_single_item
2170: ( x_return_status => l_api_return_status
2171: , x_msg_count => l_msg_count
2172: , x_msg_data => l_msg_data
2173: , p_out_bound => 'Y'

Line 2179: WMS_CARTNZN_PUB.cartonize_mixed_item

2175: , p_move_order_header_id => p_move_order_header_id
2176: , p_subinventory_name => rules_table(ii).from_subinventory_name
2177: );
2178: ELSIF rules_table(ii).return_type_id = 2 THEN
2179: WMS_CARTNZN_PUB.cartonize_mixed_item
2180: ( x_return_status => l_api_return_status
2181: , x_msg_count => l_msg_count
2182: , x_msg_data => l_msg_data
2183: , p_out_bound => 'Y'

Line 2191: WMS_CARTNZN_PUB.pack_level := 0;

2187: , p_subinventory_name => rules_table(ii).from_subinventory_name
2188: , p_pack_level => 0
2189: , p_stop_level => 0
2190: );
2191: WMS_CARTNZN_PUB.pack_level := 0;
2192: ELSIF rules_table(ii).return_type_id = 3 THEN
2193: WMS_CARTNZN_PUB.g_cartonize_pick_slip := 'Y';
2194: WMS_CARTNZN_PUB.cartonize_pick_slip
2195: ( p_org_id => rules_table(ii).from_organization_id

Line 2193: WMS_CARTNZN_PUB.g_cartonize_pick_slip := 'Y';

2189: , p_stop_level => 0
2190: );
2191: WMS_CARTNZN_PUB.pack_level := 0;
2192: ELSIF rules_table(ii).return_type_id = 3 THEN
2193: WMS_CARTNZN_PUB.g_cartonize_pick_slip := 'Y';
2194: WMS_CARTNZN_PUB.cartonize_pick_slip
2195: ( p_org_id => rules_table(ii).from_organization_id
2196: , p_move_order_header_id => p_move_order_header_id
2197: , p_subinventory_name => rules_table(ii).from_subinventory_name

Line 2194: WMS_CARTNZN_PUB.cartonize_pick_slip

2190: );
2191: WMS_CARTNZN_PUB.pack_level := 0;
2192: ELSIF rules_table(ii).return_type_id = 3 THEN
2193: WMS_CARTNZN_PUB.g_cartonize_pick_slip := 'Y';
2194: WMS_CARTNZN_PUB.cartonize_pick_slip
2195: ( p_org_id => rules_table(ii).from_organization_id
2196: , p_move_order_header_id => p_move_order_header_id
2197: , p_subinventory_name => rules_table(ii).from_subinventory_name
2198: , x_return_status => l_api_return_status

Line 2201: WMS_CARTNZN_PUB.cartonize_customer_logic

2197: , p_subinventory_name => rules_table(ii).from_subinventory_name
2198: , x_return_status => l_api_return_status
2199: );
2200: ELSIF rules_table(ii).return_type_id = 4 THEN
2201: WMS_CARTNZN_PUB.cartonize_customer_logic
2202: ( p_org_id => rules_table(ii).from_organization_id
2203: , p_move_order_header_id => p_move_order_header_id
2204: , p_subinventory_name => rules_table(ii).from_subinventory_name
2205: , x_return_status => l_api_return_status

Line 2211: print_debug('Error status from WMS_CARTNZN_PUB APIs: '

2207: END IF;
2208:
2209: IF l_api_return_status <> fnd_api.g_ret_sts_success THEN
2210: IF g_debug = 1 THEN
2211: print_debug('Error status from WMS_CARTNZN_PUB APIs: '
2212: || l_api_return_status, l_api_name);
2213: END IF;
2214: IF l_api_return_status = fnd_api.g_ret_sts_error THEN
2215: RAISE fnd_api.g_exc_error;

Line 2236: WMS_CARTNZN_PUB.cartonize_default_logic

2232: -- If there are any more rows left for cartonization for first level,
2233: -- cartonize through default logic
2234: IF l_count > 0 THEN
2235: l_api_return_status := fnd_api.g_ret_sts_success;
2236: WMS_CARTNZN_PUB.cartonize_default_logic
2237: ( p_org_id => p_org_id
2238: , p_move_order_header_id => p_move_order_header_id
2239: , p_out_bound => 'Y'
2240: , x_return_status => l_api_return_status

Line 2262: WMS_CARTNZN_PUB.pack_level := 0;

2258: print_debug( 'Done with FIRST LEVEL OF CARTONIZATION, inserting packaging history'
2259: , l_api_name);
2260: END IF;
2261:
2262: WMS_CARTNZN_PUB.pack_level := 0;
2263:
2264: l_api_return_status := fnd_api.g_ret_sts_success;
2265: WMS_CARTNZN_PUB.insert_ph
2266: ( p_move_order_header_id => p_move_order_header_id

Line 2265: WMS_CARTNZN_PUB.insert_ph

2261:
2262: WMS_CARTNZN_PUB.pack_level := 0;
2263:
2264: l_api_return_status := fnd_api.g_ret_sts_success;
2265: WMS_CARTNZN_PUB.insert_ph
2266: ( p_move_order_header_id => p_move_order_header_id
2267: , p_current_header_id => p_move_order_header_id
2268: , x_return_status => l_api_return_status
2269: );

Line 2283: print_debug( 'Done with WMS_CARTNZN_PUB.insert_ph', l_api_name);

2279: END IF;
2280: END IF;
2281:
2282: IF g_debug = 1 THEN
2283: print_debug( 'Done with WMS_CARTNZN_PUB.insert_ph', l_api_name);
2284: print_debug( 'Calling CARTONIZE_MIXED_ITEM for doing MULTI-LEVEL CARTONIZATION'
2285: , l_api_name);
2286: END IF;
2287:

Line 2289: WMS_CARTNZN_PUB.cartonize_mixed_item

2285: , l_api_name);
2286: END IF;
2287:
2288: l_api_return_status := fnd_api.g_ret_sts_success;
2289: WMS_CARTNZN_PUB.cartonize_mixed_item
2290: ( x_return_status => l_api_return_status
2291: , x_msg_count => l_msg_count
2292: , x_msg_data => l_msg_data
2293: , p_out_bound => 'Y'

Line 2316: WMS_CARTNZN_PUB.generate_lpns

2312: print_debug('Calling Generate_LPNs', l_api_name);
2313: END IF;
2314:
2315: BEGIN
2316: WMS_CARTNZN_PUB.generate_lpns
2317: ( p_header_id => p_move_order_header_id
2318: , p_organization_id => p_org_id
2319: );
2320: EXCEPTION

Line 2370: v1 wms_cartnzn_pub.wct_row_type;

2366: , x_return_status OUT NOCOPY VARCHAR2
2367: ) IS
2368:
2369: l_api_name CONSTANT VARCHAR2(30) := 'cartonize';
2370: v1 wms_cartnzn_pub.wct_row_type;
2371: cartonization_profile VARCHAR2(1) := 'Y';
2372: v_cart_value NUMBER;
2373: v_container_item_id NUMBER := NULL;
2374: v_qty NUMBER := -1;

Line 2418: packaging_mode NUMBER := wms_cartnzn_pub.pr_pkg_mode;

2414: l_serial_code VARCHAR2(1);
2415: l_is_revision_control BOOLEAN;
2416: l_is_lot_control BOOLEAN;
2417: l_is_serial_control BOOLEAN;
2418: packaging_mode NUMBER := wms_cartnzn_pub.pr_pkg_mode;
2419: l_qoh NUMBER;
2420: l_lpn_fully_allocated VARCHAR2(1) :='N';
2421: percent_fill_basis VARCHAR2(1) :='W';
2422: l_valid_container VARCHAR2(1) := 'Y';

Line 2461: , wms_cartnzn_pub.get_lpn_itemid (content_lpn_id)

2457: , DECODE( content_lpn_id
2458: , NULL, inventory_item_id
2459: , DECODE( SIGN(p_hdr_id)
2460: , -1, inventory_item_id
2461: , wms_cartnzn_pub.get_lpn_itemid (content_lpn_id)
2462: )
2463: )
2464: , ABS(transaction_temp_id);
2465:

Line 2506: WMS_CARTNZN_PUB.outbound := 'Y';

2502: 'p_move_order_header_id =>' || p_move_order_header_id
2503: , l_api_name);
2504: END IF;
2505:
2506: WMS_CARTNZN_PUB.outbound := 'Y';
2507:
2508: --making sure that we are starting with an empty table
2509: DELETE wms_cartonization_temp;
2510:

Line 2511: WMS_CARTNZN_PUB.pkg_attr_table.DELETE;

2507:
2508: --making sure that we are starting with an empty table
2509: DELETE wms_cartonization_temp;
2510:
2511: WMS_CARTNZN_PUB.pkg_attr_table.DELETE;
2512: WMS_CARTNZN_PUB.lpn_attr_table.DELETE;
2513: WMS_CARTNZN_PUB.lpns_generated_tb.DELETE;
2514:
2515: --get the values related to cartonization from org parameters

Line 2512: WMS_CARTNZN_PUB.lpn_attr_table.DELETE;

2508: --making sure that we are starting with an empty table
2509: DELETE wms_cartonization_temp;
2510:
2511: WMS_CARTNZN_PUB.pkg_attr_table.DELETE;
2512: WMS_CARTNZN_PUB.lpn_attr_table.DELETE;
2513: WMS_CARTNZN_PUB.lpns_generated_tb.DELETE;
2514:
2515: --get the values related to cartonization from org parameters
2516: BEGIN

Line 2513: WMS_CARTNZN_PUB.lpns_generated_tb.DELETE;

2509: DELETE wms_cartonization_temp;
2510:
2511: WMS_CARTNZN_PUB.pkg_attr_table.DELETE;
2512: WMS_CARTNZN_PUB.lpn_attr_table.DELETE;
2513: WMS_CARTNZN_PUB.lpns_generated_tb.DELETE;
2514:
2515: --get the values related to cartonization from org parameters
2516: BEGIN
2517: SELECT NVL(cartonization_flag,-1)

Line 2522: , WMS_CARTNZN_PUB.g_allocate_serial_flag

2518: , NVL(cartonize_sales_orders,'Y')
2519: , NVL(allocate_serial_flag,'N')
2520: INTO v_cart_value
2521: , l_cartonize_sales_orders
2522: , WMS_CARTNZN_PUB.g_allocate_serial_flag
2523: FROM mtl_parameters
2524: WHERE organization_id = p_org_id;
2525: EXCEPTION
2526: WHEN OTHERS THEN

Line 2559: WMS_CARTNZN_PUB.g_sublvlctrl := v_sublvlctrl; -- used when calling cartonize_mixed_item

2555: END IF;
2556: RETURN;
2557: END IF;
2558:
2559: WMS_CARTNZN_PUB.g_sublvlctrl := v_sublvlctrl; -- used when calling cartonize_mixed_item
2560: -- from rule based cartonization
2561: IF g_debug = 1 THEN
2562: print_debug( 'WMS_CARTNZN_PUB.g_sublvlctrl: '||WMS_CARTNZN_PUB.g_sublvlctrl
2563: , l_api_name);

Line 2562: print_debug( 'WMS_CARTNZN_PUB.g_sublvlctrl: '||WMS_CARTNZN_PUB.g_sublvlctrl

2558:
2559: WMS_CARTNZN_PUB.g_sublvlctrl := v_sublvlctrl; -- used when calling cartonize_mixed_item
2560: -- from rule based cartonization
2561: IF g_debug = 1 THEN
2562: print_debug( 'WMS_CARTNZN_PUB.g_sublvlctrl: '||WMS_CARTNZN_PUB.g_sublvlctrl
2563: , l_api_name);
2564: END IF;
2565:
2566: BEGIN

Line 2587: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';

2583: AND from_organization_id = p_org_id
2584: AND ROWNUM = 1;
2585:
2586: IF l_rulebased_setup_exists > 0 THEN
2587: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2588: IF v_cart_value = 1 or v_cart_value = 3 THEN
2589: l_api_return_status := fnd_api.g_ret_sts_success;
2590: rulebased_cartonization
2591: ( x_return_status => l_api_return_status

Line 2620: ', outbound is ' || WMS_CARTNZN_PUB.outbound ||

2616: -- End of Rule Based Cartonization
2617:
2618: IF g_debug = 1 THEN
2619: print_debug('Cartonization profile is ' || cartonization_profile ||
2620: ', outbound is ' || WMS_CARTNZN_PUB.outbound ||
2621: ', controlled at sub level is ' || v_sublvlctrl
2622: , l_api_name);
2623: print_debug(' Percent fill basis ' || percent_fill_basis, l_api_name);
2624: END IF;

Line 2626: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';

2622: , l_api_name);
2623: print_debug(' Percent fill basis ' || percent_fill_basis, l_api_name);
2624: END IF;
2625:
2626: WMS_CARTNZN_PUB.table_name := 'wms_cartonization_temp';
2627:
2628: IF g_debug = 1 THEN
2629: print_debug('Inserting mmtt rows of this header into wms_cartonization_temp '
2630: || p_move_order_header_id , l_api_name);

Line 2654: WMS_CARTNZN_PUB.pack_level := 0;

2650: END IF;
2651: END IF;
2652:
2653: l_stop_level := -1;
2654: WMS_CARTNZN_PUB.pack_level := 0;
2655: l_current_header_id := p_move_order_header_id;
2656:
2657: IF cartonization_profile = 'Y' THEN --{
2658: --- This is the Multi level Cartonization loop

Line 2661: print_debug( 'cur lev ' || WMS_CARTNZN_PUB.pack_level ||

2657: IF cartonization_profile = 'Y' THEN --{
2658: --- This is the Multi level Cartonization loop
2659: LOOP --{
2660: IF g_debug = 1 THEN
2661: print_debug( 'cur lev ' || WMS_CARTNZN_PUB.pack_level ||
2662: ', stop lev ' || l_stop_level
2663: , l_api_name);
2664: END IF;
2665:

Line 2666: EXIT WHEN ((WMS_CARTNZN_PUB.pack_level >= l_stop_level) AND (l_stop_level <> -1));

2662: ', stop lev ' || l_stop_level
2663: , l_api_name);
2664: END IF;
2665:
2666: EXIT WHEN ((WMS_CARTNZN_PUB.pack_level >= l_stop_level) AND (l_stop_level <> -1));
2667:
2668: v_prev_item_id := -1;
2669: v_prev_move_order_line_id := -1;
2670:

Line 2676: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN

2672: print_debug( 'Opening cusror hdr id: ' || l_current_header_id
2673: , l_api_name);
2674: END IF;
2675:
2676: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN
2677: error_code := 'CARTONIZE 70';
2678: IF g_debug = 1 THEN
2679: print_debug('Opening wct_rows', l_api_name);
2680: END IF;

Line 2700: print_debug(' Fetching rows::pack_level: ' || WMS_CARTNZN_PUB.pack_level ||

2696: error_code := 'CARTONIZE 100';
2697:
2698: LOOP --{
2699: IF g_debug = 1 THEN
2700: print_debug(' Fetching rows::pack_level: ' || WMS_CARTNZN_PUB.pack_level ||
2701: ', outbound: ' || WMS_CARTNZN_PUB.outbound
2702: , l_api_name);
2703: END IF;
2704:

Line 2701: ', outbound: ' || WMS_CARTNZN_PUB.outbound

2697:
2698: LOOP --{
2699: IF g_debug = 1 THEN
2700: print_debug(' Fetching rows::pack_level: ' || WMS_CARTNZN_PUB.pack_level ||
2701: ', outbound: ' || WMS_CARTNZN_PUB.outbound
2702: , l_api_name);
2703: END IF;
2704:
2705: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{

Line 2705: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{

2701: ', outbound: ' || WMS_CARTNZN_PUB.outbound
2702: , l_api_name);
2703: END IF;
2704:
2705: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{
2706: error_code := 'CARTONIZE 110';
2707: FETCH wct_rows INTO v1;
2708: EXIT WHEN wct_rows%notfound;
2709:

Line 2757: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)

2753:
2754: IF l_qoh = v1.primary_quantity THEN
2755: l_lpn_fully_allocated := 'Y';
2756: SELECT v1.transaction_temp_id, 'Y'
2757: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)
2758: FROM DUAL;
2759: ELSE
2760: l_lpn_fully_allocated := 'N';
2761: SELECT v1.transaction_temp_id, 'N'

Line 2762: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)

2758: FROM DUAL;
2759: ELSE
2760: l_lpn_fully_allocated := 'N';
2761: SELECT v1.transaction_temp_id, 'N'
2762: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)
2763: FROM DUAL;
2764: END IF;
2765: --}
2766: ELSE

Line 2769: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)

2765: --}
2766: ELSE
2767: l_lpn_fully_allocated := 'Y';
2768: SELECT v1.transaction_temp_id, 'Y'
2769: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)
2770: FROM DUAL;
2771: END IF ;
2772: --}
2773: ELSE

Line 2794: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)

2790: NULL;
2791: ELSE --{
2792: --populate lpn_alloc_flag with null for loose item
2793: SELECT v1.transaction_temp_id, NULL
2794: INTO WMS_CARTNZN_PUB.t_lpn_alloc_flag_table(v1.transaction_temp_id)
2795: FROM DUAL;
2796:
2797: -- If the content_lpn_id is populated on the mmtt record
2798: -- could be two cases. Either we are trying to pack an LPN

Line 2816: v1.inventory_item_id := WMS_CARTNZN_PUB.get_lpn_itemid(v1.content_lpn_id);

2812: IF v1.transaction_header_id < 0 THEN
2813: error_code := 'CARTONIZE 150';
2814: ELSE
2815: error_code := 'CARTONIZE 160';
2816: v1.inventory_item_id := WMS_CARTNZN_PUB.get_lpn_itemid(v1.content_lpn_id);
2817: END IF;
2818:
2819: -- When we are packaing an lpn or a package the qty is
2820: -- always 1

Line 2847: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) AND

2843: print_debug('secondary_transaction_quantity: '||v1.secondary_transaction_quantity, l_api_name);
2844: print_debug('secondary_uom_code: ' ||v1.secondary_uom_code, l_api_name);
2845: END IF;
2846:
2847: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) AND
2848: (v_prev_move_order_line_id <> v1.move_order_line_id) THEN
2849: l_prev_condition := 'Y';
2850: ELSIF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level <> 0) AND
2851: ((v_prev_move_order_line_id <> v1.move_order_line_id) OR

Line 2850: ELSIF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level <> 0) AND

2846:
2847: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) AND
2848: (v_prev_move_order_line_id <> v1.move_order_line_id) THEN
2849: l_prev_condition := 'Y';
2850: ELSIF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level <> 0) AND
2851: ((v_prev_move_order_line_id <> v1.move_order_line_id) OR
2852: (v1.inventory_item_id <> v_prev_item_id)) THEN
2853: l_prev_condition := 'Y';
2854: ELSIF (WMS_CARTNZN_PUB.outbound = 'N') AND

Line 2854: ELSIF (WMS_CARTNZN_PUB.outbound = 'N') AND

2850: ELSIF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level <> 0) AND
2851: ((v_prev_move_order_line_id <> v1.move_order_line_id) OR
2852: (v1.inventory_item_id <> v_prev_item_id)) THEN
2853: l_prev_condition := 'Y';
2854: ELSIF (WMS_CARTNZN_PUB.outbound = 'N') AND
2855: (v1.inventory_item_id <> v_prev_item_id) THEN
2856: l_prev_condition := 'Y';
2857: ELSE
2858: l_prev_condition := 'N';

Line 2885: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) --{

2881: v_qty := -1;
2882: space_avail_for := 0;
2883: l_valid_container := 'Y';
2884:
2885: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) --{
2886: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
2887: error_code := 'CARTONIZE 180';
2888: wsh_interface.Get_Max_Load_Qty
2889: ( p_move_order_line_id => v1.move_order_line_id

Line 2886: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN

2882: space_avail_for := 0;
2883: l_valid_container := 'Y';
2884:
2885: IF (WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) --{
2886: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
2887: error_code := 'CARTONIZE 180';
2888: wsh_interface.Get_Max_Load_Qty
2889: ( p_move_order_line_id => v1.move_order_line_id
2890: , x_max_load_quantity => v_qty_per_cont

Line 3049: WMS_CARTNZN_PUB.update_mmtt

3045: ELSE
3046: l_upd_qty_flag := 'N';
3047: END IF;
3048:
3049: WMS_CARTNZN_PUB.update_mmtt
3050: ( p_transaction_temp_id => v1.transaction_temp_id
3051: , p_primary_quantity => v1.primary_quantity
3052: , p_transaction_quantity => v1.transaction_quantity
3053: , p_secondary_quantity => v1.secondary_transaction_quantity

Line 3099: WMS_CARTNZN_PUB.insert_mmtt

3095: print_debug( 'Tr space avail for: ' || tr_space_avail_for
3096: , l_api_name);
3097: END IF;
3098:
3099: WMS_CARTNZN_PUB.insert_mmtt
3100: ( p_transaction_temp_id => v1.transaction_temp_id
3101: , p_primary_quantity => space_avail_for
3102: , p_transaction_quantity => tr_space_avail_for
3103: , p_secondary_quantity => sec_tr_space_avail_for

Line 3191: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;

3187: print_debug('primary_quantity <= qty per conatiner or ' ||
3188: 'NUMBER OF cont = 1', l_api_name);
3189: END IF;
3190:
3191: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;
3192:
3193: IF g_debug = 1 THEN
3194: print_debug('Generated label Id '||v_lpn_id, l_api_name);
3195: END IF;

Line 3197: WMS_CARTNZN_PUB.update_mmtt

3193: IF g_debug = 1 THEN
3194: print_debug('Generated label Id '||v_lpn_id, l_api_name);
3195: END IF;
3196:
3197: WMS_CARTNZN_PUB.update_mmtt
3198: ( p_transaction_temp_id => v1.transaction_temp_id
3199: , p_primary_quantity => v1.primary_quantity
3200: , p_transaction_quantity => v1.transaction_quantity
3201: , p_secondary_quantity => v1.secondary_transaction_quantity

Line 3219: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;

3215: IF g_debug = 1 THEN
3216: print_debug('NUMBER OF cont: ' || v_qty, l_api_name);
3217: END IF;
3218:
3219: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;
3220: IF g_debug = 1 THEN
3221: print_debug('Generated label ID: ' || v_lpn_id, l_api_name);
3222: print_debug('Calling update_mmtt', l_api_name);
3223: END IF;

Line 3225: WMS_CARTNZN_PUB.update_mmtt

3221: print_debug('Generated label ID: ' || v_lpn_id, l_api_name);
3222: print_debug('Calling update_mmtt', l_api_name);
3223: END IF;
3224:
3225: WMS_CARTNZN_PUB.update_mmtt
3226: ( p_transaction_temp_id => v1.transaction_temp_id
3227: , p_primary_quantity => v_qty_per_cont
3228: , p_transaction_quantity => v_tr_qty_per_cont
3229: , p_secondary_quantity => v_sec_tr_qty_per_cont

Line 3244: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;

3240:
3241: LOOP --{
3242: EXIT WHEN v_loop < 2;
3243:
3244: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;
3245: IF g_debug = 1 THEN
3246: print_debug('Generated label ID: ' || v_lpn_id, l_api_name);
3247: print_debug('Calling insert mmtt', l_api_name);
3248: END IF;

Line 3249: WMS_CARTNZN_PUB.insert_mmtt

3245: IF g_debug = 1 THEN
3246: print_debug('Generated label ID: ' || v_lpn_id, l_api_name);
3247: print_debug('Calling insert mmtt', l_api_name);
3248: END IF;
3249: WMS_CARTNZN_PUB.insert_mmtt
3250: ( p_transaction_temp_id => v1.transaction_temp_id
3251: , p_primary_quantity => v_qty_per_cont
3252: , p_transaction_quantity => v_tr_qty_per_cont
3253: , p_secondary_quantity => v_sec_tr_qty_per_cont

Line 3267: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;

3263: END IF;
3264: v_loop := v_loop - 1;
3265: END LOOP; --}
3266:
3267: v_lpn_id := WMS_CARTNZN_PUB.get_next_package_id;
3268: IF g_debug = 1 THEN
3269: print_debug('Generated label ID: ' || v_lpn_id, l_api_name);
3270: END IF;
3271:

Line 3291: WMS_CARTNZN_PUB.insert_mmtt

3287:
3288: IF g_debug = 1 THEN
3289: print_debug('calling insert mmtt', l_api_name);
3290: END IF;
3291: WMS_CARTNZN_PUB.insert_mmtt
3292: ( p_transaction_temp_id => v1.transaction_temp_id
3293: , p_primary_quantity => v_left_prim_quant
3294: , p_transaction_quantity => v_left_tr_quant
3295: , p_secondary_quantity => v_sec_left_tr_quant

Line 3321: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{

3317: IF g_debug = 1 THEN
3318: print_debug('Calling item-category cartonization', l_api_name);
3319: END IF;
3320:
3321: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{
3322: print_debug('p_move_order_header_id: ' || p_move_order_header_id ||
3323: ', outbound: ' || WMS_CARTNZN_PUB.outbound ||
3324: ', v_sublvlctrl: ' || v_sublvlctrl ||
3325: ', percent_fill_basis: ' || percent_fill_basis

Line 3323: ', outbound: ' || WMS_CARTNZN_PUB.outbound ||

3319: END IF;
3320:
3321: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN --{
3322: print_debug('p_move_order_header_id: ' || p_move_order_header_id ||
3323: ', outbound: ' || WMS_CARTNZN_PUB.outbound ||
3324: ', v_sublvlctrl: ' || v_sublvlctrl ||
3325: ', percent_fill_basis: ' || percent_fill_basis
3326: , l_api_name);
3327:

Line 3328: ret_value := WMS_CARTNZN_PUB.do_cartonization

3324: ', v_sublvlctrl: ' || v_sublvlctrl ||
3325: ', percent_fill_basis: ' || percent_fill_basis
3326: , l_api_name);
3327:
3328: ret_value := WMS_CARTNZN_PUB.do_cartonization
3329: ( p_move_order_header_id
3330: , 0
3331: , WMS_CARTNZN_PUB.outbound
3332: , v_sublvlctrl

Line 3331: , WMS_CARTNZN_PUB.outbound

3327:
3328: ret_value := WMS_CARTNZN_PUB.do_cartonization
3329: ( p_move_order_header_id
3330: , 0
3331: , WMS_CARTNZN_PUB.outbound
3332: , v_sublvlctrl
3333: , percent_fill_basis
3334: );
3335: --}

Line 3340: print_debug('Passing outbound: ' || WMS_CARTNZN_PUB.outbound, l_api_name);

3336: ELSE --{
3337: IF g_debug = 1 THEN
3338: print_debug('In else for cartonization', l_api_name);
3339: print_debug('Passing header id: ' || l_current_header_id, l_api_name);
3340: print_debug('Passing outbound: ' || WMS_CARTNZN_PUB.outbound, l_api_name);
3341: print_debug('Passing Sub level Control: ' || v_sublvlctrl, l_api_name);
3342: END IF;
3343:
3344: ret_value := WMS_CARTNZN_PUB.do_cartonization

Line 3344: ret_value := WMS_CARTNZN_PUB.do_cartonization

3340: print_debug('Passing outbound: ' || WMS_CARTNZN_PUB.outbound, l_api_name);
3341: print_debug('Passing Sub level Control: ' || v_sublvlctrl, l_api_name);
3342: END IF;
3343:
3344: ret_value := WMS_CARTNZN_PUB.do_cartonization
3345: ( 0
3346: , l_current_header_id
3347: , WMS_CARTNZN_PUB.outbound
3348: , v_sublvlctrl

Line 3347: , WMS_CARTNZN_PUB.outbound

3343:
3344: ret_value := WMS_CARTNZN_PUB.do_cartonization
3345: ( 0
3346: , l_current_header_id
3347: , WMS_CARTNZN_PUB.outbound
3348: , v_sublvlctrl
3349: , percent_fill_basis
3350: );
3351: --}

Line 3359: WMS_CARTNZN_PUB.split_lot_serials (p_org_id);

3355: print_debug('Cartonization returned: ' || ret_value, l_api_name);
3356: print_debug('Calling split_lot_serials', l_api_name);
3357: END IF;
3358:
3359: WMS_CARTNZN_PUB.split_lot_serials (p_org_id);
3360:
3361: IF g_debug = 1 THEN
3362: print_debug('Populating Packaging History Table', l_api_name);
3363: END IF;

Line 3372: l_current_header_id := WMS_CARTNZN_PUB.get_next_header_id;

3368: IF g_debug = 1 THEN
3369: print_debug('Prev header ID: ' || l_prev_header_id, l_api_name);
3370: END IF;
3371:
3372: l_current_header_id := WMS_CARTNZN_PUB.get_next_header_id;
3373:
3374: IF g_debug = 1 THEN
3375: print_debug('Current_header_id: ' || l_current_header_id, l_api_name);
3376: END IF;

Line 3379: WMS_CARTNZN_PUB.t_lpn_alloc_flag_table.DELETE;

3375: print_debug('Current_header_id: ' || l_current_header_id, l_api_name);
3376: END IF;
3377:
3378: error_code := 'CARTONIZE 225';
3379: WMS_CARTNZN_PUB.t_lpn_alloc_flag_table.DELETE;
3380: error_code := 'CARTONIZE 226';
3381: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN
3382: error_code := 'CARTONIZE 227';
3383: OPEN opackages(l_prev_header_id);

Line 3381: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN

3377:
3378: error_code := 'CARTONIZE 225';
3379: WMS_CARTNZN_PUB.t_lpn_alloc_flag_table.DELETE;
3380: error_code := 'CARTONIZE 226';
3381: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN
3382: error_code := 'CARTONIZE 227';
3383: OPEN opackages(l_prev_header_id);
3384: ELSE
3385: error_code := 'CARTONIZE 228';

Line 3400: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN

3396: END IF;
3397:
3398: error_code := 'CARTONIZE 240';
3399:
3400: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN
3401: FETCH opackages
3402: INTO l_temp_id
3403: , l_item_id
3404: , l_qty

Line 3446: WMS_CARTNZN_PUB.insert_mmtt

3442: print_debug( 'Inserting a new row for package ' || l_package_id
3443: , l_api_name);
3444: END IF;
3445:
3446: WMS_CARTNZN_PUB.insert_mmtt
3447: ( p_transaction_temp_id => l_temp_id
3448: , p_primary_quantity => l_qty
3449: , p_transaction_quantity => l_tr_qty
3450: , p_secondary_quantity => l_sec_tr_qty

Line 3452: , p_new_txn_tmp_id => WMS_CARTNZN_PUB.get_next_temp_id

3448: , p_primary_quantity => l_qty
3449: , p_transaction_quantity => l_tr_qty
3450: , p_secondary_quantity => l_sec_tr_qty
3451: , p_new_txn_hdr_id => l_current_header_id
3452: , p_new_txn_tmp_id => WMS_CARTNZN_PUB.get_next_temp_id
3453: , p_clpn_id => l_package_id
3454: , p_item_id => l_citem_id
3455: , x_return_status => l_api_return_status
3456: , x_msg_count => l_msg_count

Line 3466: IF WMS_CARTNZN_PUB.outbound = 'Y' THEN

3462: IF g_debug = 1 THEN
3463: print_debug('Calling InsertPH for temp_id ' || l_temp_id, l_api_name);
3464: END IF;
3465:
3466: IF WMS_CARTNZN_PUB.outbound = 'Y' THEN
3467: WMS_CARTNZN_PUB.insert_ph (p_move_order_header_id, l_temp_id);
3468: -- Insert_PH is overloaded in WMSCRTNS.pls. careful
3469: END IF;
3470: --}

Line 3467: WMS_CARTNZN_PUB.insert_ph (p_move_order_header_id, l_temp_id);

3463: print_debug('Calling InsertPH for temp_id ' || l_temp_id, l_api_name);
3464: END IF;
3465:
3466: IF WMS_CARTNZN_PUB.outbound = 'Y' THEN
3467: WMS_CARTNZN_PUB.insert_ph (p_move_order_header_id, l_temp_id);
3468: -- Insert_PH is overloaded in WMSCRTNS.pls. careful
3469: END IF;
3470: --}
3471: END IF;

Line 3474: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN

3470: --}
3471: END IF;
3472: END LOOP; --}
3473:
3474: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0) ) THEN
3475: IF opackages%ISOPEN THEN
3476: CLOSE opackages;
3477: END IF;
3478: ELSE

Line 3489: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN

3485: IF g_debug = 1 THEN
3486: print_debug('No labels generated in the previous level-EXITING', l_api_name);
3487: END IF;
3488:
3489: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN
3490: IF wct_rows%ISOPEN then
3491: CLOSE wct_rows;
3492: END IF;
3493: ELSE

Line 3502: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN

3498:
3499: EXIT;
3500: END IF;
3501:
3502: IF ((WMS_CARTNZN_PUB.outbound = 'Y') AND (WMS_CARTNZN_PUB.pack_level = 0)) THEN
3503: IF wct_rows%ISOPEN THEN
3504: CLOSE wct_rows;
3505: END IF;
3506: ELSE

Line 3512: WMS_CARTNZN_PUB.pack_level := WMS_CARTNZN_PUB.pack_level + 1;

3508: CLOSE bpack_rows;
3509: END IF;
3510: END IF;
3511:
3512: WMS_CARTNZN_PUB.pack_level := WMS_CARTNZN_PUB.pack_level + 1;
3513: IF g_debug = 1 THEN
3514: print_debug('Incremented the current level', l_api_name);
3515: print_debug('going back to the multi-cart loop', l_api_name);
3516: END IF;

Line 3533: WMS_CARTNZN_PUB.generate_lpns

3529:
3530: BEGIN
3531: error_code := 'CARTONIZE 250';
3532:
3533: WMS_CARTNZN_PUB.generate_lpns
3534: ( p_header_id => l_header_id
3535: , p_organization_id => p_org_id
3536: );
3537: EXCEPTION