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.15.12010000.2 2008/08/19 09:53:37 anviswan 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.15.12010000.2 2008/08/19 09:53:37 anviswan 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 113: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';

109: p_input_for_bulk IN WMS_BULK_PICK.bulk_input_rec DEFAULT null
110: );
111:
112:
113: G_PKG_NAME CONSTANT VARCHAR2(30) := 'WMS_CARTNZN_PUB';
114: g_current_release_level CONSTANT NUMBER := WMS_CONTROL.G_CURRENT_RELEASE_LEVEL;
115: g_j_release_level CONSTANT NUMBER := INV_RELEASE.G_J_RELEASE_LEVEL;
116: g_k_release_level CONSTANT NUMBER := INV_RELEASE.G_K_RELEASE_LEVEL; -- ER : 6682436
117: g_move_order_pick_wave CONSTANT NUMBER := inv_globals.g_move_order_pick_wave;

Line 2253: wms_cartnzn_pub.g_wms_pack_hist_seq,

2249: )
2250: VALUES
2251: (l_org_id,
2252: p_orig_header_id,
2253: wms_cartnzn_pub.g_wms_pack_hist_seq,
2254: pack_level,
2255: l_item_id,
2256: Sysdate,
2257: fnd_global.user_id,

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

2275: packaging_mode,
2276: l_temp_id
2277: );
2278:
2279: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2280:
2281: counter := counter -1;
2282: END LOOP;
2283:

Line 2330: wms_cartnzn_pub.g_wms_pack_hist_seq,

2326: )
2327: VALUES
2328: (l_org_id,
2329: p_orig_header_id,
2330: wms_cartnzn_pub.g_wms_pack_hist_seq,
2331: pack_level,
2332: NULL,
2333: Sysdate,
2334: fnd_global.user_id,

Line 2355: wms_cartnzn_pub.g_wms_pack_hist_seq :=

2351: l_content_volume_uom_code,
2352: packaging_mode,
2353: l_temp_id
2354: );
2355: wms_cartnzn_pub.g_wms_pack_hist_seq :=
2356: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2357: END IF;
2358:
2359: ELSE

Line 2356: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;

2352: packaging_mode,
2353: l_temp_id
2354: );
2355: wms_cartnzn_pub.g_wms_pack_hist_seq :=
2356: wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2357: END IF;
2358:
2359: ELSE
2360: --HEADER ID < 0

Line 2408: wms_cartnzn_pub.g_wms_pack_hist_seq,

2404: VALUES
2405: (
2406: l_org_id,
2407: p_orig_header_id,
2408: wms_cartnzn_pub.g_wms_pack_hist_seq,
2409: pack_level,
2410: l_cont_item_id,
2411: Sysdate,
2412: fnd_global.user_id,

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

2432: l_tare_weight,
2433: l_tare_weight_uom_code
2434: );
2435:
2436: wms_cartnzn_pub.g_wms_pack_hist_seq := wms_cartnzn_pub.g_wms_pack_hist_seq + 1;
2437: END IF;
2438:
2439: EXCEPTION
2440: WHEN OTHERS THEN

Line 2915: IF packaging_mode <> wms_cartnzn_pub.PR_pKG_mode THEN

2911: parent_lpn_id IS NOT NULL AND
2912: parent_package_id IS NOT NULL AND
2913: header_id = p_header_id;
2914:
2915: IF packaging_mode <> wms_cartnzn_pub.PR_pKG_mode THEN
2916: --need not be called in pick release mode
2917: update_gross_weight(p_header_id,p_organization_id);
2918: END IF;
2919:

Line 3346: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),

3342: order by move_order_line_id,
3343: decode(content_lpn_id,null,inventory_item_id,
3344: decode(sign(p_hdr_id),
3345: -1,
3346: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),
3347: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3348: ) ); */
3349:
3350:

Line 3347: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

3343: decode(content_lpn_id,null,inventory_item_id,
3344: decode(sign(p_hdr_id),
3345: -1,
3346: wms_cartnzn_pub.Get_package_ItemId(content_lpn_id),
3347: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3348: ) ); */
3349:
3350:
3351: CURSOR bpack_rows(p_hdr_id NUMBER) IS

Line 3363: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

3359: decode(content_lpn_id,null,inventory_item_id,
3360: decode(sign(p_hdr_id),
3361: -1,
3362: inventory_item_id,
3363: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
3364: ) ),Abs(transaction_temp_id);
3365:
3366:
3367: CURSOR packages(p_hdr_id NUMBER) IS

Line 3443: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR

3439:
3440: -- Setting the global variable for sequence
3441: --sequence_id := 1;
3442:
3443: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3445: outbound := 'Y';
3446: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3447: wms_cartnzn_pub.mob_bP_pkg_mode ,

Line 3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN

3440: -- Setting the global variable for sequence
3441: --sequence_id := 1;
3442:
3443: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3445: outbound := 'Y';
3446: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3447: wms_cartnzn_pub.mob_bP_pkg_mode ,
3448: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

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

3442:
3443: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3445: outbound := 'Y';
3446: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3447: wms_cartnzn_pub.mob_bP_pkg_mode ,
3448: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3449: outbound := 'N';
3450: ELSE

Line 3447: wms_cartnzn_pub.mob_bP_pkg_mode ,

3443: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3445: outbound := 'Y';
3446: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3447: wms_cartnzn_pub.mob_bP_pkg_mode ,
3448: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3449: outbound := 'N';
3450: ELSE
3451: outbound := p_out_bound;

Line 3448: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

3444: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
3445: outbound := 'Y';
3446: ELSIF(packaging_mode IN (wms_cartnzn_pub.int_bP_pkg_mode,
3447: wms_cartnzn_pub.mob_bP_pkg_mode ,
3448: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
3449: outbound := 'N';
3450: ELSE
3451: outbound := p_out_bound;
3452: END IF;

Line 3478: wms_cartnzn_pub.g_default_pick_op_plan_id

3474: l_cartonize_sales_orders,
3475: l_cartonize_manufacturing,
3476: --Bug 3528061 fix
3477: g_allocate_serial_flag,
3478: wms_cartnzn_pub.g_default_pick_op_plan_id
3479: FROM mtl_parameters
3480: WHERE organization_id = p_org_id;
3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;

Line 3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;

3478: wms_cartnzn_pub.g_default_pick_op_plan_id
3479: FROM mtl_parameters
3480: WHERE organization_id = p_org_id;
3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3484: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3485: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3486:

Line 3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;

3479: FROM mtl_parameters
3480: WHERE organization_id = p_org_id;
3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3484: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3485: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3486:
3487: EXCEPTION

Line 3484: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;

3480: WHERE organization_id = p_org_id;
3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3484: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3485: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3486:
3487: EXCEPTION
3488: WHEN OTHERS THEN

Line 3485: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;

3481:
3482: wms_cartnzn_pub.g_org_cartonization_value := v_cart_value;
3483: wms_cartnzn_pub.g_org_cartonize_so_flag := l_cartonize_sales_orders;
3484: wms_cartnzn_pub.g_org_cartonize_mfg_flag := l_cartonize_manufacturing;
3485: wms_cartnzn_pub.g_org_allocate_serial_flag := g_allocate_serial_flag;
3486:
3487: EXCEPTION
3488: WHEN OTHERS THEN
3489: v_cart_value := NULL;

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

3490: END;
3491:
3492: IF( v_cart_value = 1) THEN
3493:
3494: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3495: AND (l_cartonize_sales_orders = 'Y'))
3496: OR
3497: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3498: AND (l_cartonize_manufacturing = 'Y'))

Line 3497: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)

3493:
3494: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3495: AND (l_cartonize_sales_orders = 'Y'))
3496: OR
3497: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3498: AND (l_cartonize_manufacturing = 'Y'))
3499: THEN
3500: -- Cartonization is enabled for the whole organization
3501: v_sublvlctrl := '1';

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

3505: END IF;
3506:
3507: ELSIF( v_cart_value = 3) THEN
3508:
3509: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3510: AND (l_cartonize_sales_orders = 'Y'))
3511: OR
3512: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3513: AND (l_cartonize_manufacturing = 'Y'))

Line 3512: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)

3508:
3509: IF ((packaging_mode = wms_cartnzn_pub.pr_pkg_mode)
3510: AND (l_cartonize_sales_orders = 'Y'))
3511: OR
3512: ((packaging_mode = wms_cartnzn_pub.mfg_pr_pkg_mode)
3513: AND (l_cartonize_manufacturing = 'Y'))
3514: THEN
3515: --cartonization is controlled at the subinventory level
3516: v_sublvlctrl := '3';

Line 3535: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;

3531: INTO percent_fill_basis
3532: FROM wsh_shipping_parameters
3533: WHERE organization_id = p_org_id AND
3534: ROWNUM = 1;
3535: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;
3536: EXCEPTION
3537: WHEN OTHERS THEN
3538: percent_fill_basis := 'W';
3539: wms_cartnzn_pub.g_percent_fill_basis := 'W';

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

3535: wms_cartnzn_pub.g_percent_fill_basis := percent_fill_basis;
3536: EXCEPTION
3537: WHEN OTHERS THEN
3538: percent_fill_basis := 'W';
3539: wms_cartnzn_pub.g_percent_fill_basis := 'W';
3540: END;
3541:
3542: IF(g_trace_on = 1) THEN
3543: log_event(' cartonization profile is '||cartonization_profile||' outbound is'||outbound || ' controlled at sub level is '||v_sublvlctrl);

Line 3564: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;

3560: IF l_auto_pick_confirm_flag = 'Y' THEN
3561: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3562: END IF;
3563:
3564: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;
3565: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;
3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN

Line 3565: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;

3561: IF (g_trace_on = 1) THEN log_event('Auto pick confirm is ON for this batch'); END IF;
3562: END IF;
3563:
3564: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := l_autocreate_delivery_flag;
3565: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := l_auto_pick_confirm_flag;
3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: l_auto_pick_confirm_flag := 'N';

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

3566:
3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: l_auto_pick_confirm_flag := 'N';
3570: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := 'N';
3571: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := 'N';
3572: END;
3573: END IF;
3574:

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

3567: EXCEPTION
3568: WHEN OTHERS THEN
3569: l_auto_pick_confirm_flag := 'N';
3570: WMS_CARTNZN_PUB.g_autocreate_delivery_flag := 'N';
3571: WMS_CARTNZN_PUB.g_auto_pick_confirm_flag := 'N';
3572: END;
3573: END IF;
3574:
3575: ------------------------ ER : 6682436 START ---------------------------------

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

3576: -- Rule based cartonization will only be called for Pick Release Mode -------
3577:
3578: IF(g_trace_on = 1) THEN
3579: log_event('Packagin mode : '|| packaging_mode);
3580: log_event('wms_cartnzn_pub.PR_pKG_mode : '|| wms_cartnzn_pub.PR_pKG_mode);
3581: END IF;
3582:
3583: IF WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= 120001
3584: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

Line 3584: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

3580: log_event('wms_cartnzn_pub.PR_pKG_mode : '|| wms_cartnzn_pub.PR_pKG_mode);
3581: END IF;
3582:
3583: IF WMS_CONTROL.G_CURRENT_RELEASE_LEVEL >= 120001
3584: AND packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
3585:
3586: IF(g_trace_on = 1) THEN
3587: log_event('Checking the rules setup');
3588: END IF;

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

3601: END IF;
3602:
3603: table_name := 'wms_cartonization_temp';
3604:
3605: IF wms_cartnzn_pub.g_org_cartonization_value IN (1,3) THEN
3606: log_event('Calling rulebased cartonization ');
3607: WMS_CARTNZN_PUB.rulebased_cartonization
3608: (
3609: x_return_status => l_api_return_status,

Line 3607: WMS_CARTNZN_PUB.rulebased_cartonization

3603: table_name := 'wms_cartonization_temp';
3604:
3605: IF wms_cartnzn_pub.g_org_cartonization_value IN (1,3) THEN
3606: log_event('Calling rulebased cartonization ');
3607: WMS_CARTNZN_PUB.rulebased_cartonization
3608: (
3609: x_return_status => l_api_return_status,
3610: x_msg_count => x_msg_count,
3611: x_msg_data => x_msg_data,

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

4024: --Bug 2478970 fix
4025: l_valid_container := 'Y';
4026:
4027: IF (outbound = 'Y') AND (pack_level = 0)
4028: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
4029: error_code := 'CARTONIZE 180';
4030: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => v1.move_order_line_id,
4031: x_max_load_quantity => v_qty_per_cont,
4032: x_container_item_id => v_container_item_id,

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

4674: generate_lpns(p_header_id => l_header_id,
4675: p_organization_id => p_org_id);
4676: EXCEPTION
4677: WHEN OTHERS THEN
4678: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4679: wms_cartnzn_pub.mob_bP_pkg_mode ,
4680: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4681: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4682: RAISE fnd_api.g_exc_unexpected_error;

Line 4679: wms_cartnzn_pub.mob_bP_pkg_mode ,

4675: p_organization_id => p_org_id);
4676: EXCEPTION
4677: WHEN OTHERS THEN
4678: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4679: wms_cartnzn_pub.mob_bP_pkg_mode ,
4680: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4681: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4682: RAISE fnd_api.g_exc_unexpected_error;
4683: ELSE

Line 4680: wms_cartnzn_pub.prepack_pkg_mode) ) THEN

4676: EXCEPTION
4677: WHEN OTHERS THEN
4678: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4679: wms_cartnzn_pub.mob_bP_pkg_mode ,
4680: wms_cartnzn_pub.prepack_pkg_mode) ) THEN
4681: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4682: RAISE fnd_api.g_exc_unexpected_error;
4683: ELSE
4684: if (g_trace_on = 1) then log_event('not erroring out since the mode is Pick release '); END IF;

Line 4735: WMS_CARTNZN_PUB.assigntts(

4731: -- since the return value is not set up inside above procedure, so no need to check it
4732: -- but above procedure will throw unexpected error in case of errors, so this API will capture the
4733: -- error.
4734:
4735: WMS_CARTNZN_PUB.assigntts(
4736: p_api_version => 1.0,
4737: p_move_order_header_id => p_move_order_header_id,
4738: x_return_status => l_return_status,
4739: x_msg_count => l_msg_count,

Line 4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR

4861:
4862: IF --(l_lpn_id_tbl IS NOT NULL) AND bug 2720653 fix
4863: (lpns_generated_tb.count > 0) THEN
4864:
4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;

Line 4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN

4862: IF --(l_lpn_id_tbl IS NOT NULL) AND bug 2720653 fix
4863: (lpns_generated_tb.count > 0) THEN
4864:
4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;
4870:

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

4863: (lpns_generated_tb.count > 0) THEN
4864:
4865: IF( packaging_mode = wms_cartnzn_pub.PR_pKG_mode OR
4866: packaging_mode = wms_cartnzn_pub.mfg_PR_pKG_mode) THEN
4867: if (g_trace_on = 1) then log_event('wms_cartnzn_pub before inv_label.print_label '); END IF;
4868:
4869: l_return_status := fnd_api.g_ret_sts_success;
4870:
4871: inv_label.print_label

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

4877: , p_print_mode => 1
4878: , p_business_flow_code => 22
4879: , p_transaction_id => lpns_generated_tb
4880: );
4881: if (g_trace_on = 1) then log_event('wms_cartnzn_pub after inv_label.print_label '); END IF;
4882:
4883: IF l_return_status <> fnd_api.g_ret_sts_success THEN
4884: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
4885: FND_MSG_PUB.ADD;

Line 4893: 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;

4889: --x_msg_data := l_msg_data;
4890: --x_msg_count := l_msg_count;
4891: --END IF;
4892:
4893: 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;
4894: END IF;
4895: END IF; -- end packaging_mode in 1
4896:
4897: ELSE

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

4896:
4897: ELSE
4898: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4899:
4900: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4901: wms_cartnzn_pub.mob_bP_pkg_mode ,
4902: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4903: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4904: x_return_status := fnd_api.g_ret_sts_error;

Line 4901: wms_cartnzn_pub.mob_bP_pkg_mode ,

4897: ELSE
4898: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4899:
4900: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4901: wms_cartnzn_pub.mob_bP_pkg_mode ,
4902: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4903: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4904: x_return_status := fnd_api.g_ret_sts_error;
4905: END IF;

Line 4902: wms_cartnzn_pub.prepack_pkg_mode)) THEN

4898: if (g_trace_on = 1) then log_event('could not cartonize any of the lines'); END IF;
4899:
4900: IF( packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
4901: wms_cartnzn_pub.mob_bP_pkg_mode ,
4902: wms_cartnzn_pub.prepack_pkg_mode)) THEN
4903: if (g_trace_on = 1) then log_event('erroring out since the mode is bulk pack '); END IF;
4904: x_return_status := fnd_api.g_ret_sts_error;
4905: END IF;
4906:

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

5282: l_mesg VARCHAR2(255);
5283: l_debug number := NVL(FND_PROFILE.VALUE('INV_DEBUG_TRACE'),0);
5284: BEGIN
5285:
5286: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5287:
5288: --inv_pick_wave_pick_confirm_pub.TraceLog(err_msg => p_message,
5289: -- module => 'WMS_CARTNZN_PUB'
5290: -- );

Line 5289: -- module => 'WMS_CARTNZN_PUB'

5285:
5286: l_module := 'wms.plsql.' || 'wms_cartnzn_pub' || '.' || 'cartonization';
5287:
5288: --inv_pick_wave_pick_confirm_pub.TraceLog(err_msg => p_message,
5289: -- module => 'WMS_CARTNZN_PUB'
5290: -- );
5291:
5292:
5293: l_mesg := to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') || p_message;

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

5293: l_mesg := to_char(sysdate, 'YYYY-MM-DD HH:DD:SS') || p_message;
5294:
5295: IF (l_debug = 1) THEN
5296: -- dbms_output.put_line(l_mesg);
5297: inv_trx_util_pub.trace(l_mesg, 'WMS_CARTNZN_PUB');
5298: END IF;
5299:
5300:
5301: END log_event;

Line 5725: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,

5721: END IF;
5722:
5723: v1 := to_mmtt(v2);
5724:
5725: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
5726: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN
5727:
5728: v1.transfer_lpn_id := v1.cartonization_id;
5729:

Line 5726: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN

5722:
5723: v1 := to_mmtt(v2);
5724:
5725: IF packaging_mode IN (wms_cartnzn_pub.int_bp_pkg_mode,
5726: wms_cartnzn_pub.mob_bp_pkg_mode ) THEN
5727:
5728: v1.transfer_lpn_id := v1.cartonization_id;
5729:
5730: END IF;

Line 6025: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

6021: decode(content_lpn_id,null,inventory_item_id,
6022: decode(sign(p_hdr_id),
6023: -1,
6024: inventory_item_id,
6025: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
6026: ) ),Abs(transaction_temp_id);
6027:
6028: CURSOR packages(p_hdr_id NUMBER) IS
6029: SELECT

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

6281: --Bug 2478970 fix
6282: l_valid_container := 'Y';
6283:
6284: IF (outbound = 'Y') AND (pack_level = 0)
6285: AND (packaging_mode = wms_cartnzn_pub.pr_pkg_mode) THEN
6286: error_code := 'CARTONIZE 180';
6287: wsh_interface.Get_Max_Load_Qty(p_move_order_line_id => v1.move_order_line_id,
6288: x_max_load_quantity => v_qty_per_cont,
6289: x_container_item_id => v_container_item_id,

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

6796: END IF;
6797: g_cartonize_pick_slip := 'N';
6798:
6799: IF (g_trace_on = 1) THEN
6800: log_event('Auto Pick Confirm Flag is : '|| WMS_CARTNZN_PUB.g_auto_pick_confirm_flag);
6801: END IF;
6802:
6803: IF WMS_CARTNZN_PUB.g_auto_pick_confirm_flag = 'N' THEN
6804:

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

6799: IF (g_trace_on = 1) THEN
6800: log_event('Auto Pick Confirm Flag is : '|| WMS_CARTNZN_PUB.g_auto_pick_confirm_flag);
6801: END IF;
6802:
6803: IF WMS_CARTNZN_PUB.g_auto_pick_confirm_flag = 'N' THEN
6804:
6805: IF (g_trace_on = 1) THEN
6806: log_event(' move order header id '||p_move_order_header_id);
6807: END IF;

Line 7119: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN

7115: --Bug 6873966
7116: --moved the label printing call after stamping the cartonization_id on the mmtt
7117: IF (lpns_generated_tb.COUNT > 0) THEN
7118:
7119: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7120: IF (g_trace_on = 1) THEN
7121: log_event('wms_cartnzn_pub before inv_label.print_label ');
7122: END IF;
7123: l_return_status := fnd_api.g_ret_sts_success;

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

7117: IF (lpns_generated_tb.COUNT > 0) THEN
7118:
7119: IF packaging_mode = wms_cartnzn_pub.PR_pKG_mode THEN
7120: IF (g_trace_on = 1) THEN
7121: log_event('wms_cartnzn_pub before inv_label.print_label ');
7122: END IF;
7123: l_return_status := fnd_api.g_ret_sts_success;
7124:
7125: inv_label.print_label

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

7134: , p_transaction_id => lpns_generated_tb
7135: );
7136:
7137: IF (g_trace_on = 1) THEN
7138: log_event('wms_cartnzn_pub after inv_label.print_label ');
7139: END IF;
7140:
7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7142: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD

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

7141: IF l_return_status <> fnd_api.g_ret_sts_success THEN
7142: FND_MESSAGE.SET_NAME('INV', 'INV_RCV_CRT_PRINT_LAB_FAIL'); -- MSGTBD
7143: FND_MSG_PUB.ADD;
7144: IF (g_trace_on = 1) THEN
7145: log_event('wms_cartnzn_pub inv_label.print_label FAILED;'|| to_char(sysdate, 'YYYY-MM-DD HH:DD:SS'));
7146: END IF;
7147: END IF;
7148: END IF; -- end packaging_mode in 1
7149: ELSE

Line 7299: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)

7295: decode(content_lpn_id,null,inventory_item_id,
7296: decode(sign(p_hdr_id),
7297: -1,
7298: inventory_item_id,
7299: wms_cartnzn_pub.Get_LPN_ItemId(content_lpn_id)
7300: ) ),Abs(transaction_temp_id);
7301:
7302:
7303: CURSOR packages(p_hdr_id NUMBER) IS

Line 7421: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);

7417: END IF;
7418:
7419: IF ( (outbound = 'Y') AND (pack_level = 0) ) THEN
7420: ret_value:= do_cartonization(p_move_order_header_id,0,outbound,
7421: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);
7422:
7423: ELSE
7424: IF (g_trace_on = 1) THEN
7425: log_event('in else for cartonization');

Line 7431: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);

7427: log_event('passing outbound '||outbound);
7428: log_event('passing Sub level Control'||v_sublvlctrl);
7429: END IF;
7430: ret_value:= do_cartonization(0,curr_header_id_for_mixed,outbound,
7431: v_sublvlctrl,WMS_CARTNZN_PUB.g_percent_fill_basis);
7432:
7433: END IF;
7434:
7435: IF (g_trace_on = 1) THEN

Line 8491: END WMS_CARTNZN_PUB;

8487: END insert_ph;
8488:
8489:
8490:
8491: END WMS_CARTNZN_PUB;