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_CARTNZN_PUB dependencies on WMS_CARTNZN_PUB

Line 1: PACKAGE BODY WMS_CARTNZN_PUB AS

1: PACKAGE BODY WMS_CARTNZN_PUB AS
2: /* $Header: WMSCRTNB.pls 120.26.12020000.7 2013/02/22 03:16:21 sahmahes ship $*/
3: --
4: -- File : WMSCRTNB.pls
5: -- Content : WMS_CARTNZN_PUB package specification

Line 5: -- Content : WMS_CARTNZN_PUB package specification

1: PACKAGE BODY WMS_CARTNZN_PUB AS
2: /* $Header: WMSCRTNB.pls 120.26.12020000.7 2013/02/22 03:16:21 sahmahes ship $*/
3: --
4: -- File : WMSCRTNB.pls
5: -- Content : WMS_CARTNZN_PUB package specification
6: -- Description : WMS cartonization API
7: -- Notes :
8: -- Modified : 09/12/2000 cjandhya created
9:

Line 60: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';

56: p_input_for_bulk IN WMS_BULK_PICK.bulk_input_rec DEFAULT null
57: );
58:
59:
60: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';
61: g_current_release_level CONSTANT NUMBER := WMS_CONTROL.G_CURRENT_RELEASE_LEVEL;
62: g_j_release_level CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;
63: g_k_release_level CONSTANT NUMBER := INV_RELEASE.G_K_RELEASE_LEVEL; -- ER : 6682436
64: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;

Line 2228: wms_cartnzn_pub.g_wms_pack_hist_seq,

2224: )
2225: VALUES
2226: (l_org_id,
2227: p_orig_header_id,
2228: wms_cartnzn_pub.g_wms_pack_hist_seq,
2229: pack_level,
2230: l_item_id,
2231: Sysdate,
2232: fnd_global.user_id,

Line 2254: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;

2250: packaging_mode,
2251: l_temp_id
2252: );
2253:
2254: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2255:
2256: counter := counter -1;
2257: END LOOP;
2258:

Line 2305: wms_cartnzn_pub.g_wms_pack_hist_seq,

2301: )
2302: VALUES
2303: (l_org_id,
2304: p_orig_header_id,
2305: wms_cartnzn_pub.g_wms_pack_hist_seq,
2306: pack_level,
2307: NULL,
2308: Sysdate,
2309: fnd_global.user_id,

Line 2330: wms_cartnzn_pub.g_wms_pack_hist_seq :=

2326: l_content_volume_uom_code,
2327: packaging_mode,
2328: l_temp_id
2329: );
2330: wms_cartnzn_pub.g_wms_pack_hist_seq :=
2331: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2332: END IF;
2333:
2334: ELSE

Line 2331: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;

2327: packaging_mode,
2328: l_temp_id
2329: );
2330: wms_cartnzn_pub.g_wms_pack_hist_seq :=
2331: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2332: END IF;
2333:
2334: ELSE
2335: --HEADER ID < 0

Line 2383: wms_cartnzn_pub.g_wms_pack_hist_seq,

2379: VALUES
2380: (
2381: l_org_id,
2382: p_orig_header_id,
2383: wms_cartnzn_pub.g_wms_pack_hist_seq,
2384: pack_level,
2385: l_cont_item_id,
2386: Sysdate,
2387: fnd_global.user_id,

Line 2411: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;

2407: l_tare_weight,
2408: l_tare_weight_uom_code
2409: );
2410:
2411: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2412: END IF;
2413:
2414: EXCEPTION
2415: WHEN OTHERS THEN

Line 2895: IF packaging_mode <> wms_cartnzn_pub.PR_pKG_mode THEN

2891: parent_lpn_id IS NOT NULL AND
2892: parent_package_id IS NOT NULL AND
2893: header_id = p_header_id;
2894:
2895: IF packaging_mode <> wms_cartnzn_pub.PR_pKG_mode THEN
2896: --need not be called in pick release mode
2897: update_gross_weight(p_header_id,p_organization_id);
2898: END IF;
2899:

Line 3328: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),

3324: order by move_order_line_id,
3325: decode(content_lpn_id,null,inventory_item_id,
3326: decode(sign(p_hdr_id),
3327: -1,
3328: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),
3329: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3330: ) ); */
3331:
3332:

Line 3329: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

3325: decode(content_lpn_id,null,inventory_item_id,
3326: decode(sign(p_hdr_id),
3327: -1,
3328: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),
3329: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3330: ) ); */
3331:
3332:
3333: CURSOR bpack_rows(p_hdr_id NUMBER) IS

Line 3345: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

3341: decode(content_lpn_id,null,inventory_item_id,
3342: decode(sign(p_hdr_id),
3343: -1,
3344: inventory_item_id,
3345: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3346: ) ),Abs(transaction_temp_id);
3347:
3348:
3349: CURSOR packages(p_hdr_id NUMBER) IS

Line 3425: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR

3421:
3422: -- Setting the global variable for sequence
3423: --sequence_id := 1;
3424:
3425: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3427: outbound := 'Y';
3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3429: wms_cartnzn_pub.mob_bP_pkg_mode ,

Line 3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN

3422: -- Setting the global variable for sequence
3423: --sequence_id := 1;
3424:
3425: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3427: outbound := 'Y';
3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3429: wms_cartnzn_pub.mob_bP_pkg_mode ,
3430: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

Line 3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,

3424:
3425: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3427: outbound := 'Y';
3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3429: wms_cartnzn_pub.mob_bP_pkg_mode ,
3430: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3431: outbound := 'N';
3432: ELSE

Line 3429: wms_cartnzn_pub.mob_bP_pkg_mode ,

3425: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3427: outbound := 'Y';
3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3429: wms_cartnzn_pub.mob_bP_pkg_mode ,
3430: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3431: outbound := 'N';
3432: ELSE
3433: outbound := p_out_bound;

Line 3430: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

3426: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3427: outbound := 'Y';
3428: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3429: wms_cartnzn_pub.mob_bP_pkg_mode ,
3430: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3431: outbound := 'N';
3432: ELSE
3433: outbound := p_out_bound;
3434: END IF;

Line 3460: wms_cartnzn_pub.g_default_pick_op_plan_id

3456: l_cartonize_sales_orders,
3457: l_cartonize_manufacturing,
3458: --Bug 3528061 fix
3459: g_allocate_serial_flag,
3460: wms_cartnzn_pub.g_default_pick_op_plan_id
3461: FROM mtl_parameters
3462: WHERE organization_id = p_org_id;
3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;

Line 3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;

3460: wms_cartnzn_pub.g_default_pick_op_plan_id
3461: FROM mtl_parameters
3462: WHERE organization_id = p_org_id;
3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3466: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3467: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3468:

Line 3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;

3461: FROM mtl_parameters
3462: WHERE organization_id = p_org_id;
3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3466: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3467: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3468:
3469: EXCEPTION

Line 3466: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;

3462: WHERE organization_id = p_org_id;
3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3466: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3467: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3468:
3469: EXCEPTION
3470: WHEN OTHERS THEN

Line 3467: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;

3463:
3464: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3465: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3466: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3467: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3468:
3469: EXCEPTION
3470: WHEN OTHERS THEN
3471: v_cart_value := NULL;

Line 3476: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)

3472: END;
3473:
3474: IF( v_cart_value = 1) THEN
3475:
3476: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3477: AND (l_cartonize_sales_orders = 'Y'))
3478: OR
3479: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3480: AND (l_cartonize_manufacturing = 'Y'))

Line 3479: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)

3475:
3476: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3477: AND (l_cartonize_sales_orders = 'Y'))
3478: OR
3479: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3480: AND (l_cartonize_manufacturing = 'Y'))
3481: THEN
3482: -- Cartonization is enabled for the whole organization
3483: v_sublvlctrl := '1';

Line 3491: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)

3487: END IF;
3488:
3489: ELSIF( v_cart_value = 3) THEN
3490:
3491: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3492: AND (l_cartonize_sales_orders = 'Y'))
3493: OR
3494: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3495: AND (l_cartonize_manufacturing = 'Y'))

Line 3494: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)

3490:
3491: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3492: AND (l_cartonize_sales_orders = 'Y'))
3493: OR
3494: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3495: AND (l_cartonize_manufacturing = 'Y'))
3496: THEN
3497: --cartonization is controlled at the subinventory level
3498: v_sublvlctrl := '3';

Line 3517: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;

3513: INTO percent_fill_basis
3514: FROM wsh_shipping_parameters
3515: WHERE organization_id = p_org_id AND
3516: ROWNUM = 1;
3517: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: percent_fill_basis := 'W';
3521: wms_cartnzn_pub.g_percent_fill_basis := 'W';

Line 3521: wms_cartnzn_pub.g_percent_fill_basis := 'W';

3517: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;
3518: EXCEPTION
3519: WHEN OTHERS THEN
3520: percent_fill_basis := 'W';
3521: wms_cartnzn_pub.g_percent_fill_basis := 'W';
3522: END;
3523:
3524: IF(g_trace_on = 1) THEN
3525: log_event(' cartonization profile is '||cartonization_profile||' outbound is'||outbound || ' controlled at sub level is '||v_sublvlctrl);

Line 3546: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;

3542: IF l_auto_pick_confirm_flag = 'Y' THEN
3543: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3544: END IF;
3545:
3546: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;
3547: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;
3548:
3549: EXCEPTION
3550: WHEN OTHERS THEN

Line 3547: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;

3543: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3544: END IF;
3545:
3546: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;
3547: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;
3548:
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: l_auto_pick_confirm_flag := 'N';

Line 3552: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := 'N';

3548:
3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: l_auto_pick_confirm_flag := 'N';
3552: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := 'N';
3553: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := 'N';
3554: END;
3555: END IF;
3556:

Line 3553: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := 'N';

3549: EXCEPTION
3550: WHEN OTHERS THEN
3551: l_auto_pick_confirm_flag := 'N';
3552: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := 'N';
3553: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := 'N';
3554: END;
3555: END IF;
3556:
3557: ------------------------ ER : 6682436 START ---------------------------------

Line 3562: log_event('wms_cartnzn_pub.PR_pKG_mode : '|| wms_cartnzn_pub.PR_pKG_mode);

3558: -- Rule based cartonization will only be called for Pick Release Mode -------
3559:
3560: IF(g_trace_on = 1) THEN
3561: log_event('Packagin mode : '|| packaging_mode);
3562: log_event('wms_cartnzn_pub.PR_pKG_mode : '|| wms_cartnzn_pub.PR_pKG_mode);
3563: END IF;
3564:
3565: IF WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= 120001
3566: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

Line 3566: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

3562: log_event('wms_cartnzn_pub.PR_pKG_mode : '|| wms_cartnzn_pub.PR_pKG_mode);
3563: END IF;
3564:
3565: IF WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= 120001
3566: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
3567:
3568: IF(g_trace_on = 1) THEN
3569: log_event('Checking the rules setup');
3570: END IF;

Line 3587: IF wms_cartnzn_pub.g_org_cartonization_value IN (1,3) THEN

3583: END IF;
3584:
3585: table_name := 'wms_cartonization_temp';
3586:
3587: IF wms_cartnzn_pub.g_org_cartonization_value IN (1,3) THEN
3588: log_event('Calling rulebased cartonization ');
3589: WMS_CARTNZN_PUB.rulebased_cartonization
3590: (
3591: x_return_status => l_api_return_status,

Line 3589: WMS_CARTNZN_PUB.rulebased_cartonization

3585: table_name := 'wms_cartonization_temp';
3586:
3587: IF wms_cartnzn_pub.g_org_cartonization_value IN (1,3) THEN
3588: log_event('Calling rulebased cartonization ');
3589: WMS_CARTNZN_PUB.rulebased_cartonization
3590: (
3591: x_return_status => l_api_return_status,
3592: x_msg_count => x_msg_count,
3593: x_msg_data => x_msg_data,

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

4006: --Bug 2478970 fix
4007: l_valid_container := 'Y';
4008:
4009: IF (outbound = 'Y') AND (pack_level = 0)
4010: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
4011: error_code := 'CARTONIZE 180';
4012: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => v1.move_order_line_id,
4013: x_max_load_quantity => v_qty_per_cont,
4014: x_container_item_id => v_container_item_id,

Line 4671: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,

4667: generate_lpns(p_header_id => l_header_id,
4668: p_organization_id => p_org_id);
4669: EXCEPTION
4670: WHEN OTHERS THEN
4671: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4672: wms_cartnzn_pub.mob_bP_pkg_mode ,
4673: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4674: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4675: RAISE fnd_api.g_exc_unexpected_error;

Line 4672: wms_cartnzn_pub.mob_bP_pkg_mode ,

4668: p_organization_id => p_org_id);
4669: EXCEPTION
4670: WHEN OTHERS THEN
4671: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4672: wms_cartnzn_pub.mob_bP_pkg_mode ,
4673: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4674: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4675: RAISE fnd_api.g_exc_unexpected_error;
4676: ELSE

Line 4673: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

4669: EXCEPTION
4670: WHEN OTHERS THEN
4671: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4672: wms_cartnzn_pub.mob_bP_pkg_mode ,
4673: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4674: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4675: RAISE fnd_api.g_exc_unexpected_error;
4676: ELSE
4677: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;

Line 4728: WMS_CARTNZN_PUB.assigntts(

4724: -- since the return value is not set up inside above procedure, so no need to check it
4725: -- but above procedure will throw unexpected error in case of errors, so this API will capture the
4726: -- error.
4727:
4728: WMS_CARTNZN_PUB.assigntts(
4729: p_api_version => 1.0,
4730: p_move_order_header_id => p_move_order_header_id,
4731: x_return_status => l_return_status,
4732: x_msg_count => l_msg_count,

Line 4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR

4854:
4855: IF --(l_lpn_id_tbl IS NOT NULL) AND bug 2720653 fix
4856: (lpns_generated_tb.count > 0) THEN
4857:
4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;

Line 4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN

4855: IF --(l_lpn_id_tbl IS NOT NULL) AND bug 2720653 fix
4856: (lpns_generated_tb.count > 0) THEN
4857:
4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;
4863:

Line 4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;

4856: (lpns_generated_tb.count > 0) THEN
4857:
4858: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4859: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4860: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4861:
4862: l_return_status := fnd_api.g_ret_sts_success;
4863:
4864: inv_label.print_label

Line 4874: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;

4870: , p_print_mode => 1
4871: , p_business_flow_code => 22
4872: , p_transaction_id => lpns_generated_tb
4873: );
4874: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4875:
4876: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4877: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4878: FND_MSG_PUB.ADD;

Line 4886: if (g_trace_on = 1) then log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS')); END IF;

4882: --x_msg_data := l_msg_data;
4883: --x_msg_count := l_msg_count;
4884: --END IF;
4885:
4886: if (g_trace_on = 1) then log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS')); END IF;
4887: END IF;
4888: END IF; -- end packaging_mode in 1
4889:
4890: ELSE

Line 4893: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,

4889:
4890: ELSE
4891: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4892:
4893: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4894: wms_cartnzn_pub.mob_bP_pkg_mode ,
4895: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4896: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4897: x_return_status := fnd_api.g_ret_sts_error;

Line 4894: wms_cartnzn_pub.mob_bP_pkg_mode ,

4890: ELSE
4891: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4892:
4893: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4894: wms_cartnzn_pub.mob_bP_pkg_mode ,
4895: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4896: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4897: x_return_status := fnd_api.g_ret_sts_error;
4898: END IF;

Line 4895: wms_cartnzn_pub.prepack_pkg_mode)) THEN

4891: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4892:
4893: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4894: wms_cartnzn_pub.mob_bP_pkg_mode ,
4895: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4896: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4897: x_return_status := fnd_api.g_ret_sts_error;
4898: END IF;
4899:

Line 5312: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';

5308: l_mesg VARCHAR2(255);
5309: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5310: BEGIN
5311:
5312: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5313:
5314: --inv_pick_wave_pick_confirm_pub.TraceLog(err_msg => p_message,
5315: -- module => 'WMS_CARTNZN_PUB'
5316: -- );

Line 5315: -- module => 'WMS_CARTNZN_PUB'

5311:
5312: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5313:
5314: --inv_pick_wave_pick_confirm_pub.TraceLog(err_msg => p_message,
5315: -- module => 'WMS_CARTNZN_PUB'
5316: -- );
5317:
5318:
5319: l_mesg := to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') || p_message;

Line 5323: inv_trx_util_pub.trace(l_mesg, 'WMS_CARTNZN_PUB');

5319: l_mesg := to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') || p_message;
5320:
5321: IF (l_debug = 1) THEN
5322: -- dbms_output.put_line(l_mesg);
5323: inv_trx_util_pub.trace(l_mesg, 'WMS_CARTNZN_PUB');
5324: END IF;
5325:
5326:
5327: END log_event;

Line 5761: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,

5757: END IF;
5758:
5759: v1 := to_mmtt(v2);
5760:
5761: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
5762: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN
5763:
5764: v1.transfer_lpn_id := v1.cartonization_id;
5765:

Line 5762: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN

5758:
5759: v1 := to_mmtt(v2);
5760:
5761: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
5762: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN
5763:
5764: v1.transfer_lpn_id := v1.cartonization_id;
5765:
5766: END IF;

Line 6070: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

6066: decode(content_lpn_id,null,inventory_item_id,
6067: decode(sign(p_hdr_id),
6068: -1,
6069: inventory_item_id,
6070: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
6071: ) ),Abs(transaction_temp_id);
6072:
6073: CURSOR packages(p_hdr_id NUMBER) IS
6074: SELECT

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

6326: --Bug 2478970 fix
6327: l_valid_container := 'Y';
6328:
6329: IF (outbound = 'Y') AND (pack_level = 0)
6330: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
6331: error_code := 'CARTONIZE 180';
6332: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => v1.move_order_line_id,
6333: x_max_load_quantity => v_qty_per_cont,
6334: x_container_item_id => v_container_item_id,

Line 6861: log_event('Auto Pick Confirm Flag is : '|| WMS_CARTNZN_PUB.g_auto_pick_confirm_flag);

6857: END IF;
6858: g_cartonize_pick_slip := 'N';
6859:
6860: IF (g_trace_on = 1) THEN
6861: log_event('Auto Pick Confirm Flag is : '|| WMS_CARTNZN_PUB.g_auto_pick_confirm_flag);
6862: END IF;
6863:
6864: IF WMS_CARTNZN_PUB.g_auto_pick_confirm_flag = 'N' THEN
6865:

Line 6864: IF WMS_CARTNZN_PUB.g_auto_pick_confirm_flag = 'N' THEN

6860: IF (g_trace_on = 1) THEN
6861: log_event('Auto Pick Confirm Flag is : '|| WMS_CARTNZN_PUB.g_auto_pick_confirm_flag);
6862: END IF;
6863:
6864: IF WMS_CARTNZN_PUB.g_auto_pick_confirm_flag = 'N' THEN
6865:
6866: IF (g_trace_on = 1) THEN
6867: log_event(' move order header id '||p_move_order_header_id);
6868: END IF;

Line 7163: -- wms_cartnzn_pub.assigntts only assigns task type to the parent tasks, not the child tasks.

7159: END IF;
7160:
7161:
7162: --start bug 10202064: added assigntts call after bulking, so that user task type appears for parent tasks.
7163: -- wms_cartnzn_pub.assigntts only assigns task type to the parent tasks, not the child tasks.
7164: -- if (g_trace_on = 1) then log_event(' calling assigntts for bug 10202064'); END IF;
7165: WMS_CARTNZN_PUB.assigntts(
7166: p_api_version => 1.0,
7167: p_move_order_header_id => p_move_order_header_id,

Line 7165: WMS_CARTNZN_PUB.assigntts(

7161:
7162: --start bug 10202064: added assigntts call after bulking, so that user task type appears for parent tasks.
7163: -- wms_cartnzn_pub.assigntts only assigns task type to the parent tasks, not the child tasks.
7164: -- if (g_trace_on = 1) then log_event(' calling assigntts for bug 10202064'); END IF;
7165: WMS_CARTNZN_PUB.assigntts(
7166: p_api_version => 1.0,
7167: p_move_order_header_id => p_move_order_header_id,
7168: x_return_status => l_return_status,
7169: x_msg_count => l_msg_count,

Line 7199: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

7195: --Bug 6873966
7196: --moved the label printing call after stamping the cartonization_id on the mmtt
7197: IF (lpns_generated_tb.COUNT > 0) THEN
7198:
7199: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7200: IF (g_trace_on = 1) THEN
7201: log_event('wms_cartnzn_pub before inv_label.print_label ');
7202: END IF;
7203: l_return_status := fnd_api.g_ret_sts_success;

Line 7201: log_event('wms_cartnzn_pub before inv_label.print_label ');

7197: IF (lpns_generated_tb.COUNT > 0) THEN
7198:
7199: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7200: IF (g_trace_on = 1) THEN
7201: log_event('wms_cartnzn_pub before inv_label.print_label ');
7202: END IF;
7203: l_return_status := fnd_api.g_ret_sts_success;
7204:
7205: inv_label.print_label

Line 7218: log_event('wms_cartnzn_pub after inv_label.print_label ');

7214: , p_transaction_id => lpns_generated_tb
7215: );
7216:
7217: IF (g_trace_on = 1) THEN
7218: log_event('wms_cartnzn_pub after inv_label.print_label ');
7219: END IF;
7220:
7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7222: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD

Line 7225: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));

7221: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7222: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7223: FND_MSG_PUB.ADD;
7224: IF (g_trace_on = 1) THEN
7225: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));
7226: END IF;
7227: END IF;
7228: END IF; -- end packaging_mode in 1
7229: ELSE

Line 7382: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

7378: decode(content_lpn_id,null,inventory_item_id,
7379: decode(sign(p_hdr_id),
7380: -1,
7381: inventory_item_id,
7382: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
7383: ) ),Abs(transaction_temp_id);
7384:
7385:
7386: CURSOR packages(p_hdr_id NUMBER) IS

Line 7504: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);

7500: END IF;
7501:
7502: IF ( (outbound = 'Y') AND (pack_level = 0) ) THEN
7503: ret_value:= do_cartonization(p_move_order_header_id,0,outbound,
7504: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);
7505:
7506: ELSE
7507: IF (g_trace_on = 1) THEN
7508: log_event('in else for cartonization');

Line 7514: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);

7510: log_event('passing outbound '||outbound);
7511: log_event('passing Sub level Control'||v_sublvlctrl);
7512: END IF;
7513: ret_value:= do_cartonization(0,curr_header_id_for_mixed,outbound,
7514: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);
7515:
7516: END IF;
7517:
7518: IF (g_trace_on = 1) THEN

Line 8586: END WMS_CARTNZN_PUB;

8582: END insert_ph;
8583:
8584:
8585:
8586: END WMS_CARTNZN_PUB;