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.WSH_CONTAINER_ACTIONS dependencies on WSH_CONTAINER_ACTIONS

Line 1: PACKAGE BODY wsh_container_actions as

1: PACKAGE BODY wsh_container_actions as
2: /* $Header: WSHCMACB.pls 120.19.12000000.4 2007/02/01 22:49:29 jishen ship $ */
3:
4: LIMITED_PRECISION NUMBER := 5;
5: c_wms_code_present varchar2(2) := 'Y';

Line 103: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_ACTIONS';

99: C_SUCCESS_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
100: C_UNEXP_ERROR_STATUS CONSTANT VARCHAR2(1) := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
101:
102: --
103: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_ACTIONS';
104: --
105:
106: --Bug #3005780 : Added the local function Get_Gcd
107: /*

Line 215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container',l_module_name);

211: WSH_DEBUG_SV.pop(l_module_name);
212: END IF;
213: EXCEPTION
214: WHEN Others THEN
215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container',l_module_name);
216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
217: --
218: IF l_debug_on THEN
219: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 641: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.default_container_attr',l_module_name);

637: END IF;
638: --
639:
640: WHEN Others THEN
641: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.default_container_attr',l_module_name);
642: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
643:
644: --
645: IF l_debug_on THEN

Line 735: l_cont_rec wsh_container_actions.cont_inst_rec;

731: l_cont_name VARCHAR2(30);
732: l_org_name VARCHAR2(240);
733:
734: l_item_name VARCHAR2(2000);
735: l_cont_rec wsh_container_actions.cont_inst_rec;
736: l_cont_tab wsh_container_actions.cont_inst_tab;
737: i NUMBER;
738: j NUMBER;
739: cnt NUMBER;

Line 736: l_cont_tab wsh_container_actions.cont_inst_tab;

732: l_org_name VARCHAR2(240);
733:
734: l_item_name VARCHAR2(2000);
735: l_cont_rec wsh_container_actions.cont_inst_rec;
736: l_cont_tab wsh_container_actions.cont_inst_tab;
737: i NUMBER;
738: j NUMBER;
739: cnt NUMBER;
740: l_cont_dummy_tab WSH_UTIL_CORE.id_tab_type;

Line 1204: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);

1200:
1201: WHEN Others THEN
1202: WSH_WMS_LPN_GRP.g_call_group_api := l_orig_value;
1203: WSH_WMS_LPN_GRP.g_update_to_container := l_orig_update_cont_value;
1204: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi',l_module_name);
1205: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1206:
1207: --
1208: IF l_debug_on THEN

Line 1539: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Delete_Containers',l_module_name);

1535: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:UNASSIGN_DEL_ERROR');
1536: END IF;
1537: --
1538: WHEN Others THEN
1539: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Delete_Containers',l_module_name);
1540: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1541:
1542: --
1543: IF l_debug_on THEN

Line 1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

1751: -- container as the first line..
1752:
1753: --
1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1756: END IF;
1757: --
1758: wsh_container_actions.Check_Cont_Attributes (
1759: p_container_instance_id,

Line 1758: wsh_container_actions.Check_Cont_Attributes (

1754: IF l_debug_on THEN
1755: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
1756: END IF;
1757: --
1758: wsh_container_actions.Check_Cont_Attributes (
1759: p_container_instance_id,
1760: l_attr_flag,
1761: x_return_status);
1762:

Line 2028: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2024:
2025: --dbms_output.put_line('calling update cont hierarchy with ' || p_container_instance_id);
2026: --
2027: IF l_debug_on THEN
2028: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2029: END IF;
2030: --
2031: wsh_container_actions.Update_Cont_Hierarchy (
2032: l_del_detail_id,

Line 2031: wsh_container_actions.Update_Cont_Hierarchy (

2027: IF l_debug_on THEN
2028: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2029: END IF;
2030: --
2031: wsh_container_actions.Update_Cont_Hierarchy (
2032: l_del_detail_id,
2033: NULL,
2034: p_container_instance_id,
2035: x_return_status);

Line 2105: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_Detail',l_module_name);

2101: --
2102: EXCEPTION
2103:
2104: WHEN Others THEN
2105: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_Detail',l_module_name);
2106: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2107:
2108: --
2109: IF l_debug_on THEN

Line 2425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2421: --dbms_output.put_line('calling last assigned line for ' || l_del_detail_rec(i));
2422:
2423: --
2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2426: END IF;
2427: --
2428: wsh_container_actions.Last_Assigned_Line (
2429: l_del_detail_rec(i),

Line 2428: wsh_container_actions.Last_Assigned_Line (

2424: IF l_debug_on THEN
2425: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2426: END IF;
2427: --
2428: wsh_container_actions.Last_Assigned_Line (
2429: l_del_detail_rec(i),
2430: l_cont_tab(i),
2431: l_last_line_flag,
2432: x_return_status);

Line 2461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

2457: --dbms_output.put_line('calling check cont attr with ' || l_cont_tab(i));
2458:
2459: --
2460: IF l_debug_on THEN
2461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2462: END IF;
2463: --
2464: wsh_container_actions.Check_Cont_Attributes (
2465: l_cont_tab(i),

Line 2464: wsh_container_actions.Check_Cont_Attributes (

2460: IF l_debug_on THEN
2461: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2462: END IF;
2463: --
2464: wsh_container_actions.Check_Cont_Attributes (
2465: l_cont_tab(i),
2466: l_attr_flag,
2467: x_return_status);
2468: --

Line 2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2552: END IF;
2553:
2554: --
2555: IF l_debug_on THEN
2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2557: END IF;
2558: --
2559: wsh_container_actions.Update_Cont_Hierarchy (
2560: l_cont_tab(i),

Line 2559: wsh_container_actions.Update_Cont_Hierarchy (

2555: IF l_debug_on THEN
2556: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2557: END IF;
2558: --
2559: wsh_container_actions.Update_Cont_Hierarchy (
2560: l_cont_tab(i),
2561: NULL,
2562: l_cont_tab(i),
2563: x_return_status);

Line 2667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);

2663: END IF;
2664:
2665: --
2666: IF l_debug_on THEN
2667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2668: END IF;
2669: --
2670: wsh_container_actions.Last_Assigned_Line (
2671: NULL,

Line 2670: wsh_container_actions.Last_Assigned_Line (

2666: IF l_debug_on THEN
2667: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.LAST_ASSIGNED_LINE',WSH_DEBUG_SV.C_PROC_LEVEL);
2668: END IF;
2669: --
2670: wsh_container_actions.Last_Assigned_Line (
2671: NULL,
2672: l_del_detail_rec(i),
2673: l_last_line_flag,
2674: x_return_status);

Line 2701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

2697: --dbms_output.put_line('calling check cont attr with ' || l_del_detail_rec(i));
2698:
2699: --
2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2702: END IF;
2703: --
2704: wsh_container_actions.Check_Cont_Attributes (
2705: l_del_detail_rec(i),

Line 2704: wsh_container_actions.Check_Cont_Attributes (

2700: IF l_debug_on THEN
2701: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
2702: END IF;
2703: --
2704: wsh_container_actions.Check_Cont_Attributes (
2705: l_del_detail_rec(i),
2706: l_attr_flag,
2707: x_return_status);
2708: --

Line 2790: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

2786: END IF;
2787:
2788: --
2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: END IF;
2792: --
2793: wsh_container_actions.Update_Cont_Hierarchy (
2794: l_del_detail_rec(i),

Line 2793: wsh_container_actions.Update_Cont_Hierarchy (

2789: IF l_debug_on THEN
2790: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
2791: END IF;
2792: --
2793: wsh_container_actions.Update_Cont_Hierarchy (
2794: l_del_detail_rec(i),
2795: NULL,
2796: l_del_detail_rec(i),
2797: x_return_status);

Line 3027: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);

3023: --
3024: EXCEPTION
3025:
3026: WHEN Others THEN
3027: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);
3028: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3029:
3030: --
3031: IF l_debug_on THEN

Line 3081: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.Unassign_Detail',WSH_DEBUG_SV.C_PROC_LEVEL);

3077: END IF;
3078: --
3079: --
3080: IF l_debug_on THEN
3081: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.Unassign_Detail',WSH_DEBUG_SV.C_PROC_LEVEL);
3082: END IF;
3083: --
3084: Unassign_Detail
3085: (

Line 3103: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);

3099: --
3100: EXCEPTION
3101:
3102: WHEN Others THEN
3103: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Unassign_Detail',l_module_name);
3104: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3105: --
3106: IF l_debug_on THEN
3107: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 3247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);

3243: IF l_cont_org = l_del_org THEN
3244:
3245: --
3246: IF l_debug_on THEN
3247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
3248: END IF;
3249: --
3250: wsh_container_actions.Create_Delivery_Assignment(
3251: p_container_instance_id,

Line 3250: wsh_container_actions.Create_Delivery_Assignment(

3246: IF l_debug_on THEN
3247: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_DELIVERY_ASSIGNMENT',WSH_DEBUG_SV.C_PROC_LEVEL);
3248: END IF;
3249: --
3250: wsh_container_actions.Create_Delivery_Assignment(
3251: p_container_instance_id,
3252: p_delivery_id,
3253: x_return_status,
3254: x_dlvy_has_lines,

Line 3309: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);

3305: --
3306: EXCEPTION
3307:
3308: WHEN Others THEN
3309: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);
3310: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3311:
3312: --
3313: IF l_debug_on THEN

Line 3379: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);

3375: --
3376: EXCEPTION
3377: WHEN others THEN
3378: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3379: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Assign_To_Delivery',l_module_name);
3380: --
3381: IF l_debug_on THEN
3382: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3383: END IF;

Line 3468: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);

3464: END IF;
3465: --
3466: EXCEPTION
3467: WHEN Others THEN
3468: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);
3469: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3470: --
3471: IF l_debug_on THEN
3472: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 3537: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);

3533: --
3534: EXCEPTION
3535: WHEN others THEN
3536: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3537: wsh_util_core.default_handler('WSH_CONTAINER_ACTIONS.Create_Delivery_Assignment',l_module_name);
3538: --
3539: IF l_debug_on THEN
3540: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
3541: END IF;

Line 3914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

3910: END IF;
3911:
3912: --
3913: IF l_debug_on THEN
3914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3915: END IF;
3916: --
3917: wsh_container_actions.Check_Cont_Attributes (
3918: p_det_cont_inst_id,

Line 3917: wsh_container_actions.Check_Cont_Attributes (

3913: IF l_debug_on THEN
3914: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3915: END IF;
3916: --
3917: wsh_container_actions.Check_Cont_Attributes (
3918: p_det_cont_inst_id,
3919: l_det_attr_flag,
3920: x_return_status);
3921:

Line 3940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

3936:
3937:
3938: --
3939: IF l_debug_on THEN
3940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3941: END IF;
3942: --
3943: wsh_container_actions.Check_Cont_Attributes (
3944: p_par_cont_inst_id,

Line 3943: wsh_container_actions.Check_Cont_Attributes (

3939: IF l_debug_on THEN
3940: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CHECK_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
3941: END IF;
3942: --
3943: wsh_container_actions.Check_Cont_Attributes (
3944: p_par_cont_inst_id,
3945: l_par_attr_flag,
3946: x_return_status);
3947:

Line 4058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

4054: --
4055: -- Debug Statements
4056: --
4057: IF l_debug_on THEN
4058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4059: END IF;
4060: --
4061: wsh_container_actions.Update_Cont_Hierarchy (
4062: p_par_cont_inst_id,

Line 4061: wsh_container_actions.Update_Cont_Hierarchy (

4057: IF l_debug_on THEN
4058: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4059: END IF;
4060: --
4061: wsh_container_actions.Update_Cont_Hierarchy (
4062: p_par_cont_inst_id,
4063: l_det_del_id,
4064: p_det_cont_inst_id,
4065: x_return_status );

Line 4146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);

4142: END IF;
4143:
4144: --
4145: IF l_debug_on THEN
4146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4147: END IF;
4148: --
4149: wsh_container_actions.Update_Cont_Hierarchy (
4150: p_det_cont_inst_id,

Line 4149: wsh_container_actions.Update_Cont_Hierarchy (

4145: IF l_debug_on THEN
4146: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_HIERARCHY',WSH_DEBUG_SV.C_PROC_LEVEL);
4147: END IF;
4148: --
4149: wsh_container_actions.Update_Cont_Hierarchy (
4150: p_det_cont_inst_id,
4151: l_par_del_id,
4152: p_par_cont_inst_id,
4153: x_return_status );

Line 4321: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Container',l_module_name);

4317: --
4318: EXCEPTION
4319:
4320: WHEN Others THEN
4321: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Assign_To_Container',l_module_name);
4322: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
4323:
4324: --
4325: IF l_debug_on THEN

Line 4505: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info returned '||x_return_status||' with error count '||x_error_cnt);

4501: x_max_vol := g_cont_msi_tab(p_container_item_id).mtl_max_vol;
4502: x_wt_uom := g_cont_msi_tab(p_container_item_id).mtl_wt_uom;
4503: x_vol_uom := g_cont_msi_tab(p_container_item_id).mtl_vol_uom;
4504: --x_inventory_item_status_code := g_cont_msi_tab(p_container_item_id).inventory_item_status_code;
4505: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info returned '||x_return_status||' with error count '||x_error_cnt);
4506:
4507: --
4508: IF l_debug_on THEN
4509: WSH_DEBUG_SV.log(l_module_name,'MAX LOAD',x_max_load);

Line 4521: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info',l_module_name);

4517: WHEN Others THEN
4518: IF (Get_Cont_Msi%ISOPEN) THEN
4519: CLOSE Get_Cont_Msi;
4520: END IF;
4521: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Get_Cont_Load_Vol_info',l_module_name);
4522: x_return_status := C_UNEXP_ERROR_STATUS;
4523:
4524: --
4525: IF l_debug_on THEN

Line 4597: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag returned '||x_return_status);

4593: -- HW OPMCONV - No need to populate this value
4594: -- x_process_flag := l_param_info.process_flag;
4595: END IF;
4596:
4597: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag returned '||x_return_status);
4598:
4599: --
4600: IF l_debug_on THEN
4601: WSH_DEBUG_SV.pop(l_module_name);

Line 4613: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag',l_module_name);

4609: END IF;
4610: --
4611: EXCEPTION
4612: WHEN Others THEN
4613: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Fill_Basis_and_proc_flag',l_module_name);
4614: x_return_status := C_UNEXP_ERROR_STATUS;
4615: --
4616: IF l_debug_on THEN
4617: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 4745: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Pref_Container returned '||x_return_status||' with error count '||x_error_cnt);

4741: --dbms_output.put_line('Caching Cont/Load info');
4742: END IF;
4743: x_cont_item_id := g_cache_cont_load_info_tab(p_inventory_item_id).cont_item_id;
4744: x_max_load_qty := g_cache_cont_load_info_tab(p_inventory_item_id).max_load_qty;
4745: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Calc_Pref_Container returned '||x_return_status||' with error count '||x_error_cnt);
4746:
4747: --
4748: IF l_debug_on THEN
4749: WSH_DEBUG_SV.pop(l_module_name);

Line 4764: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Pref_Container',l_module_name);

4760: WHEN Others THEN
4761: IF (Get_Cont_Load%ISOPEN) THEN
4762: CLOSE Get_Cont_Load;
4763: END IF;
4764: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Calc_Pref_Container',l_module_name);
4765: x_return_status := C_UNEXP_ERROR_STATUS;
4766:
4767: --
4768: IF l_debug_on THEN

Line 4787: p_line_cont_rec IN wsh_container_actions.line_cont_info,

4783: ------------------------------------------------------------------------------
4784: */
4785:
4786: PROCEDURE Pack_Delivery_Detail(
4787: p_line_cont_rec IN wsh_container_actions.line_cont_info,
4788: x_return_status OUT NOCOPY VARCHAR2) IS
4789:
4790: l_mtl_max_load NUMBER;
4791: l_mtl_max_vol NUMBER;

Line 5463: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Delivery_Detail',l_module_name);

5459: RETURN;
5460:
5461: EXCEPTION
5462: WHEN Others THEN
5463: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Delivery_Detail',l_module_name);
5464: x_return_status := C_UNEXP_ERROR_STATUS;
5465:
5466: --
5467: IF l_debug_on THEN

Line 5496: x_line_cont_tab OUT NOCOPY wsh_container_actions.line_cont_info_tab,

5492:
5493: PROCEDURE Validate_Dd_for_Pack(
5494: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
5495: p_del_detail_tab IN WSH_UTIL_CORE.id_tab_type,
5496: x_line_cont_tab OUT NOCOPY wsh_container_actions.line_cont_info_tab,
5497: x_error_cnt OUT NOCOPY NUMBER,
5498: x_warn_cnt OUT NOCOPY NUMBER,
5499: x_fill_pc_warn_cnt OUT NOCOPY NUMBER, -- bug 3562797 jckwok
5500: x_release_warn_cnt OUT NOCOPY NUMBER) IS

Line 6244: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Dd_For_Pack',l_module_name);

6240: END IF;
6241: IF (Get_Cont_Item_Load%ISOPEN) THEN
6242: CLOSE Get_Cont_Item_Load;
6243: END IF;
6244: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Dd_For_Pack',l_module_name);
6245: --
6246: IF l_debug_on THEN
6247: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
6248: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 6374: --l_cont_tab wsh_container_actions.cont_inst_tab;

6370: l_fill_pc_warn_count NUMBER := 0; -- bug 3562797 jckwok
6371: l_error_cnt NUMBER := 0;
6372:
6373: l_new_contid_count NUMBER := 0;
6374: --l_cont_tab wsh_container_actions.cont_inst_tab;
6375: l_cont_tab WSH_UTIL_CORE.id_tab_type;
6376:
6377: TYPE NumList IS TABLE OF NUMBER INDEX BY BINARY_INTEGER;
6378: TYPE CharList IS TABLE OF VARCHAR2(3) INDEX BY BINARY_INTEGER;

Line 6486: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Lines...');

6482: --dbms_output.put_line('==================================================');
6483: --dbms_output.put_line(' AUTO PACK LINES ');
6484: --dbms_output.put_line('==================================================');
6485:
6486: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Lines...');
6487: -- Delete all Global PL/SQL tables to start with
6488: --
6489: --
6490:

Line 6724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

6720: l_cont_name := null;
6721:
6722: --
6723: IF l_debug_on THEN
6724: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
6725: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Containers'||g_new_container_tab(cnt).number_of_containers);
6726: WSH_DEBUG_SV.log(l_module_name,'Create Container'||g_new_container_tab(cnt).container_item_id||'<'||g_new_container_tab(cnt).organization_id||'>'||g_new_container_tab(cnt).number_of_containers);
6727: END IF;
6728: --

Line 6729: wsh_container_actions.Create_Cont_Instance_Multi (

6725: WSH_DEBUG_SV.logmsg(l_module_name,'Number of Containers'||g_new_container_tab(cnt).number_of_containers);
6726: WSH_DEBUG_SV.log(l_module_name,'Create Container'||g_new_container_tab(cnt).container_item_id||'<'||g_new_container_tab(cnt).organization_id||'>'||g_new_container_tab(cnt).number_of_containers);
6727: END IF;
6728: --
6729: wsh_container_actions.Create_Cont_Instance_Multi (
6730: x_cont_name => l_cont_name,
6731: p_cont_item_id => g_new_container_tab(cnt).container_item_id,
6732: x_cont_instance_id => l_cont_instance_id,
6733: p_par_detail_id => NULL,

Line 7728: -- 100.1 Call WSH_CONTAINER_ACTIONS.Auto_Pack_Conts depending on

7724: IF l_debug_on THEN
7725: WSH_DEBUG_SV.logmsg(l_module_name,'2L ret status -'||l_return_status);
7726: WSH_DEBUG_SV.logmsg(l_module_name,'2X ret status -'||x_return_status);
7727: END IF;
7728: -- 100.1 Call WSH_CONTAINER_ACTIONS.Auto_Pack_Conts depending on
7729: -- p_pack_cont_flag and if new detail containers are created
7730: IF l_detail_cont_tab.count > 0 AND p_pack_cont_flag = 'Y' THEN
7731:
7732: l_group_id_tab.delete;

Line 7737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);

7733:
7734: --dbms_output.put_line('Calling AUTO PACK CONTS With x_cont_instance count of ' || x_cont_instance_tab.count);
7735: --
7736: IF l_debug_on THEN
7737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);
7738: END IF;
7739: --
7740: wsh_container_actions.Auto_Pack_Conts (
7741: l_group_id_tab,

Line 7740: wsh_container_actions.Auto_Pack_Conts (

7736: IF l_debug_on THEN
7737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_CONTS',WSH_DEBUG_SV.C_PROC_LEVEL);
7738: END IF;
7739: --
7740: wsh_container_actions.Auto_Pack_Conts (
7741: l_group_id_tab,
7742: l_detail_cont_tab,
7743: x_cont_instance_tab,
7744: l_mast_cont_tab,

Line 7772: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Auto_Pack_Conts created '||l_mast_cont_tab.COUNT||' Master Containers');

7768: x_return_status := C_WARNING_STATUS;
7769: END IF;
7770: END IF;
7771:
7772: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Auto_Pack_Conts created '||l_mast_cont_tab.COUNT||' Master Containers');
7773: IF l_mast_cont_tab.COUNT > 0 THEN
7774: i := 1;
7775: cnt := x_cont_instance_tab.COUNT;
7776: WHILE i <= l_mast_cont_tab.COUNT LOOP

Line 7833: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Lines',l_module_name);

7829: CLOSE c_get_tare_weight;
7830: END IF;
7831: -- End of OTM R12 : assign delivery detail
7832:
7833: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Lines',l_module_name);
7834: x_return_status := C_UNEXP_ERROR_STATUS;
7835:
7836: --
7837: IF l_debug_on THEN

Line 8009: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);

8005: ELSE
8006:
8007: --
8008: IF l_debug_on THEN
8009: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
8010: END IF;
8011: --
8012:
8013: wsh_container_actions.Auto_Pack_Lines (

Line 8013: wsh_container_actions.Auto_Pack_Lines (

8009: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.AUTO_PACK_LINES',WSH_DEBUG_SV.C_PROC_LEVEL);
8010: END IF;
8011: --
8012:
8013: wsh_container_actions.Auto_Pack_Lines (
8014: l_group_id_tab,
8015: l_del_detail_tab,
8016: p_pack_cont_flag,
8017: l_cont_instance_tab,

Line 8021: WSH_DEBUG_SV.log(l_module_name,'Return status from wsh_container_actions.Auto_Pack_Lines -',l_return_status);

8017: l_cont_instance_tab,
8018: l_return_status);
8019:
8020: IF l_debug_on THEN
8021: WSH_DEBUG_SV.log(l_module_name,'Return status from wsh_container_actions.Auto_Pack_Lines -',l_return_status);
8022: END IF;
8023: IF (l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR OR l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR) THEN
8024: --dbms_output.put_line('autopack lines failed');
8025: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 8198: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery',l_module_name);

8194: END IF;
8195:
8196: WHEN Others THEN
8197: --
8198: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_Delivery',l_module_name);
8199: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
8200:
8201: IF l_debug_on THEN
8202: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_LPN_SYNC_COMM_PKG.SYNC_LPNS_TO_WMS FROM WHEN OTHERS',WSH_DEBUG_SV.C_PROC_LEVEL);

Line 8892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

8888: l_tmp_det_tab(1) := l_det_tab(j).delivery_detail_id;
8889:
8890: IF l_debug_on THEN
8891: WSH_DEBUG_SV.log(l_module_name,'assigning detail ' || l_tmp_det_tab(1) || ' to container ' || l_cont_tab(i).container_instance_id);
8892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
8893: END IF;
8894:
8895: --
8896: wsh_container_actions.Assign_Detail (

Line 8896: wsh_container_actions.Assign_Detail (

8892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
8893: END IF;
8894:
8895: --
8896: wsh_container_actions.Assign_Detail (
8897: l_cont_tab(i).container_instance_id,
8898: l_tmp_det_tab,
8899: l_pack_status,
8900: x_return_status,FALSE);

Line 9077: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9073:
9074: END IF;
9075: --
9076: IF l_debug_on THEN
9077: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9078: END IF;
9079: --
9080: wsh_container_actions.Assign_Detail (
9081: l_cont_tab(i).container_instance_id,

Line 9080: wsh_container_actions.Assign_Detail (

9076: IF l_debug_on THEN
9077: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9078: END IF;
9079: --
9080: wsh_container_actions.Assign_Detail (
9081: l_cont_tab(i).container_instance_id,
9082: l_tmp_det_tab,
9083: l_pack_status,
9084: x_return_status,FALSE);

Line 9413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);

9409: --dbms_output.put_line('* * * ASSIGNING detail ' || l_tmp_det_tab(1) || ' to container ' || l_cont_tab(i).container_instance_id);
9410:
9411: --
9412: IF l_debug_on THEN
9413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9414: END IF;
9415: --
9416: wsh_container_actions.Assign_Detail (
9417: l_cont_tab(i).container_instance_id,

Line 9416: wsh_container_actions.Assign_Detail (

9412: IF l_debug_on THEN
9413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_DETAIL',WSH_DEBUG_SV.C_PROC_LEVEL);
9414: END IF;
9415: --
9416: wsh_container_actions.Assign_Detail (
9417: l_cont_tab(i).container_instance_id,
9418: l_tmp_det_tab,
9419: l_pack_status,
9420: x_return_status,FALSE);

Line 9926: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Multi',l_module_name);

9922: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:E_RETURN_EXCP');
9923: END IF;
9924: WHEN Others THEN
9925: --
9926: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Multi',l_module_name);
9927: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
9928: --
9929: IF l_debug_on THEN
9930: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);

Line 10173: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Shipped_Qty',l_module_name);

10169: --
10170: EXCEPTION
10171:
10172: WHEN Others THEN
10173: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Shipped_Qty',l_module_name);
10174: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
10175:
10176: --
10177: IF l_debug_on THEN

Line 10387: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Container',l_module_name);

10383: END IF;
10384: --
10385: EXCEPTION
10386: WHEN Others THEN
10387: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Pack_Container',l_module_name);
10388: x_return_status := C_UNEXP_ERROR_STATUS;
10389:
10390: --
10391: IF l_debug_on THEN

Line 10420: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,

10416:
10417: PROCEDURE Validate_Container_For_Pack(
10418: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
10419: p_cont_info_tab IN wsh_util_core.id_tab_type,
10420: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
10421: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,
10422: x_error_cnt OUT NOCOPY NUMBER,
10423: x_warn_cnt OUT NOCOPY NUMBER,
10424: x_fill_pc_warn_cnt OUT NOCOPY NUMBER -- bug 3421823

Line 10421: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,

10417: PROCEDURE Validate_Container_For_Pack(
10418: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
10419: p_cont_info_tab IN wsh_util_core.id_tab_type,
10420: p_mast_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
10421: x_line_cont_tab OUT NOCOPY wsh_container_actions.cont_info_tab,
10422: x_error_cnt OUT NOCOPY NUMBER,
10423: x_warn_cnt OUT NOCOPY NUMBER,
10424: x_fill_pc_warn_cnt OUT NOCOPY NUMBER -- bug 3421823
10425: ) IS

Line 10451: line_cont_rec wsh_container_actions.cont_info;

10447: WHERE load_item_id = v_inv_item_id
10448: AND container_item_id = v_cont_item_id
10449: AND master_organization_id = v_organization_id;
10450:
10451: line_cont_rec wsh_container_actions.cont_info;
10452: line_cont_tab wsh_container_actions.cont_info_tab;
10453:
10454: l_return_status VARCHAR2(1);
10455: l_last_organization_id NUMBER;

Line 10452: line_cont_tab wsh_container_actions.cont_info_tab;

10448: AND container_item_id = v_cont_item_id
10449: AND master_organization_id = v_organization_id;
10450:
10451: line_cont_rec wsh_container_actions.cont_info;
10452: line_cont_tab wsh_container_actions.cont_info_tab;
10453:
10454: l_return_status VARCHAR2(1);
10455: l_last_organization_id NUMBER;
10456: l_dd_count NUMBER;

Line 10981: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container_For_Pack',l_module_name);

10977: END IF;
10978: IF (Get_Cont_Item_Load%ISOPEN) THEN
10979: CLOSE Get_Cont_Item_Load;
10980: END IF;
10981: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Validate_Container_For_Pack',l_module_name);
10982: --
10983: IF l_debug_on THEN
10984: WSH_DEBUG_SV.logmsg(l_module_name,'Unexpected error has occured. Oracle error message is '|| SQLERRM,WSH_DEBUG_SV.C_UNEXPEC_ERR_LEVEL);
10985: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');

Line 11026: p_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,

11022: */
11023:
11024: PROCEDURE Auto_Pack_Conts (
11025: p_group_id_tab IN WSH_UTIL_CORE.id_tab_type,
11026: p_cont_info_tab IN wsh_container_actions.empty_cont_info_tab,
11027: p_cont_detail_tab IN WSH_UTIL_CORE.id_tab_type,
11028: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11029: x_return_status OUT NOCOPY VARCHAR2) IS
11030:

Line 11031: line_cont_rec wsh_container_actions.cont_info;

11027: p_cont_detail_tab IN WSH_UTIL_CORE.id_tab_type,
11028: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11029: x_return_status OUT NOCOPY VARCHAR2) IS
11030:
11031: line_cont_rec wsh_container_actions.cont_info;
11032: line_cont_tab wsh_container_actions.cont_info_tab;
11033:
11034: l_group_id_temp_tab WSH_UTIL_CORE.id_tab_type;
11035: l_group_id_tab WSH_UTIL_CORE.id_tab_type;

Line 11032: line_cont_tab wsh_container_actions.cont_info_tab;

11028: x_cont_instance_tab IN OUT NOCOPY WSH_UTIL_CORE.id_tab_type,
11029: x_return_status OUT NOCOPY VARCHAR2) IS
11030:
11031: line_cont_rec wsh_container_actions.cont_info;
11032: line_cont_tab wsh_container_actions.cont_info_tab;
11033:
11034: l_group_id_temp_tab WSH_UTIL_CORE.id_tab_type;
11035: l_group_id_tab WSH_UTIL_CORE.id_tab_type;
11036: l_del_row_tab WSH_UTIL_CORE.id_tab_type;

Line 11095: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Conts...');

11091: --
11092: BEGIN
11093:
11094: --dbms_output.put_line('==================================================');
11095: --dbms_output.put_line('Start of WSH_CONTAINER_ACTIONS.Auto_Pack_Conts...');
11096: --dbms_output.put_line('==================================================');
11097:
11098: -- Delete all Global PL/SQL tables to start with
11099: --

Line 11293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);

11289:
11290: --
11291: -- K LPN CONV. rv
11292: IF l_debug_on THEN
11293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
11294: END IF;
11295: --
11296: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
11297: x_cont_name => l_cont_name,

Line 11296: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(

11292: IF l_debug_on THEN
11293: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.CREATE_CONT_INSTANCE_MULTI',WSH_DEBUG_SV.C_PROC_LEVEL);
11294: END IF;
11295: --
11296: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
11297: x_cont_name => l_cont_name,
11298: p_cont_item_id => g_new_container_tab(cnt).container_item_id,
11299: x_cont_instance_id => l_cont_instance_id,
11300: p_par_detail_id => NULL,

Line 11429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);

11425:
11426: IF (l_cont_instance_id is NOT NULL) THEN
11427: --
11428: IF l_debug_on THEN
11429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);
11430: END IF;
11431: --
11432: wsh_container_actions.Assign_To_Container (
11433: p_det_cont_inst_id => g_assign_detail_tab(cnt).delivery_detail_id,

Line 11432: wsh_container_actions.Assign_To_Container (

11428: IF l_debug_on THEN
11429: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.ASSIGN_TO_CONTAINER',WSH_DEBUG_SV.C_PROC_LEVEL);
11430: END IF;
11431: --
11432: wsh_container_actions.Assign_To_Container (
11433: p_det_cont_inst_id => g_assign_detail_tab(cnt).delivery_detail_id,
11434: p_par_cont_inst_id => l_cont_instance_id,
11435: x_return_status => l_return_status);
11436: IF l_debug_on THEN

Line 11440: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Assign_To_Container returned '||l_return_status);

11436: IF l_debug_on THEN
11437: WSH_DEBUG_SV.log(l_module_name,'return status',l_return_status);
11438: END IF;
11439:
11440: --dbms_output.put_line('WSH_CONTAINER_ACTIONS.Assign_To_Container returned '||l_return_status);
11441: IF l_return_status = C_ERROR_STATUS THEN
11442: error_cnt := error_cnt + 1;
11443: ELSIF l_return_status = C_WARNING_STATUS THEN
11444: warn_cnt := warn_cnt + 1;

Line 11498: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_conts',l_module_name);

11494: END IF;
11495: --
11496: EXCEPTION
11497: WHEN Others THEN
11498: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Auto_Pack_conts',l_module_name);
11499: x_return_status := C_UNEXP_ERROR_STATUS;
11500:
11501: --
11502: IF l_debug_on THEN

Line 11810: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Attributes',l_module_name);

11806: --
11807: EXCEPTION
11808:
11809: WHEN Others THEN
11810: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Attributes',l_module_name);
11811: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11812:
11813: --
11814: IF l_debug_on THEN

Line 11966: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Check_Cont_Attributes',l_module_name);

11962: --
11963: EXCEPTION
11964:
11965: WHEN Others THEN
11966: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Check_Cont_Attributes',l_module_name);
11967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
11968:
11969: --
11970: IF l_debug_on THEN

Line 12083: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);

12079: --dbms_output.put_line('calling update cont attr with ' || cont.delivery_detail_id);
12080:
12081: --
12082: IF l_debug_on THEN
12083: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
12084: END IF;
12085: --
12086: wsh_container_actions.Update_Cont_Attributes (
12087: p_del_detail_id,

Line 12086: wsh_container_actions.Update_Cont_Attributes (

12082: IF l_debug_on THEN
12083: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_ACTIONS.UPDATE_CONT_ATTRIBUTES',WSH_DEBUG_SV.C_PROC_LEVEL);
12084: END IF;
12085: --
12086: wsh_container_actions.Update_Cont_Attributes (
12087: p_del_detail_id,
12088: p_delivery_id,
12089: cont.delivery_detail_id,
12090: l_return_status);

Line 12136: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Hierarchy',l_module_name);

12132: --
12133: EXCEPTION
12134:
12135: WHEN Others THEN
12136: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_Cont_Hierarchy',l_module_name);
12137: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12138:
12139: --
12140: IF l_debug_on THEN

Line 12284: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Last_Assigned_Line',l_module_name);

12280: --
12281: EXCEPTION
12282:
12283: WHEN Others THEN
12284: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Last_Assigned_Line',l_module_name);
12285: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
12286:
12287: --
12288: IF l_debug_on THEN

Line 12537: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(

12533: --
12534: --
12535: -- K LPN CONV. rv
12536: --
12537: WSH_CONTAINER_ACTIONS.Create_Cont_Instance_Multi(
12538: x_cont_name => l_cont_name,
12539: p_cont_item_id => NULL,
12540: x_cont_instance_id => l_container_instance_id,
12541: p_par_detail_id => NULL,

Line 12762: wsh_util_core.default_handler('wsh_container_actions.pack_inbound_lines', l_module_name);

12758:
12759: G_CALLED_FROM_INBOUND := FALSE;
12760: ROLLBACK TO pack_inbound_lines_sp;
12761: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
12762: wsh_util_core.default_handler('wsh_container_actions.pack_inbound_lines', l_module_name);
12763: IF l_debug_on THEN
12764: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
12765: END IF;
12766: --

Line 12968: wsh_util_core.default_handler('wsh_container_actions.unpack_inbound_delivery', l_module_name);

12964: WHEN OTHERS THEN
12965:
12966: ROLLBACK TO unpack_inbound_delivery_sp;
12967: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
12968: wsh_util_core.default_handler('wsh_container_actions.unpack_inbound_delivery', l_module_name);
12969: IF l_debug_on THEN
12970: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
12971: END IF;
12972: --

Line 13105: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Multiple_Cont_names',l_module_name);

13101: --
13102: EXCEPTION
13103:
13104: WHEN Others THEN
13105: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Create_Multiple_Cont_names',l_module_name);
13106: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13107:
13108:
13109: IF l_debug_on THEN

Line 13215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_child_inv_info',l_module_name);

13211: END IF;
13212: --
13213: WHEN Others THEN
13214: rollback to s_Update_child_inv_info;
13215: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_ACTIONS.Update_child_inv_info',l_module_name);
13216: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
13217:
13218:
13219: IF l_debug_on THEN

Line 14081: wsh_util_core.default_handler('wsh_container_actions.Assign_Container_to_Consol', l_module_name);

14077:
14078: WHEN OTHERS THEN
14079:
14080: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR ;
14081: wsh_util_core.default_handler('wsh_container_actions.Assign_Container_to_Consol', l_module_name);
14082: IF l_debug_on THEN
14083: WSH_DEBUG_SV.pop(l_module_name,'EXCEPTION:OTHERS');
14084: END IF;
14085:

Line 14363: wsh_util_core.default_handler('wsh_container_actions.unassign_detail_from_consol',l_module_name);

14359: END IF;
14360: --
14361:
14362: WHEN OTHERS THEN
14363: wsh_util_core.default_handler('wsh_container_actions.unassign_detail_from_consol',l_module_name);
14364: --
14365: IF l_debug_on THEN
14366: wsh_debug_sv.pop(l_module_name, 'EXCEPTION:OTHERS');
14367: END IF;

Line 14371: END wsh_container_actions;

14367: END IF;
14368:
14369: END Unpack_Details_from_Consol;
14370:
14371: END wsh_container_actions;