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_UTILITIES dependencies on WSH_CONTAINER_UTILITIES

Line 1: PACKAGE BODY WSH_CONTAINER_UTILITIES as

1: PACKAGE BODY WSH_CONTAINER_UTILITIES as
2: /* $Header: WSHCMUTB.pls 120.5 2006/10/30 23:13:42 wrudge noship $ */
3:
4:
5: /*

Line 19: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_UTILITIES';

15: */
16:
17:
18: --
19: G_PKG_NAME CONSTANT VARCHAR2(50) := 'WSH_CONTAINER_UTILITIES';
20: --
21: FUNCTION Get_Master_Cont_Id (p_cont_instance_id IN NUMBER) RETURN NUMBER IS
22:
23: l_mast_cont_id NUMBER;

Line 1005: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(2)');

1001: --
1002: EXCEPTION
1003:
1004: WHEN Others THEN
1005: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(2)');
1006: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1007:
1008: --
1009: -- Debug Statements

Line 1673: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(1)');

1669: --
1670: EXCEPTION
1671:
1672: WHEN Others THEN
1673: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers(1)');
1674: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
1675:
1676: --
1677: -- Debug Statements

Line 2189: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Master_Containers');

2185: --
2186: EXCEPTION
2187:
2188: WHEN Others THEN
2189: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Estimate_Master_Containers');
2190: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2191:
2192: --
2193: -- Debug Statements

Line 2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2281: --
2282: -- Debug Statements
2283: --
2284: IF l_debug_on THEN
2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2286: END IF;
2287: --
2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);

2284: IF l_debug_on THEN
2285: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2286: END IF;
2287: --
2288: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2289: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2290: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2291: WSH_UTIL_CORE.Add_Message(x_return_status);
2292: --

Line 2310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2306: --
2307: -- Debug Statements
2308: --
2309: IF l_debug_on THEN
2310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2311: END IF;
2312: --
2313: x_master_container_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(x_master_container_id);
2314:

Line 2313: x_master_container_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(x_master_container_id);

2309: IF l_debug_on THEN
2310: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2311: END IF;
2312: --
2313: x_master_container_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(x_master_container_id);
2314:
2315: OPEN Get_Serial_Number (x_master_container_id);
2316: FETCH Get_Serial_Number INTO x_master_serial_number, l_det_id, l_cont_flag;
2317:

Line 2325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2321: --
2322: -- Debug Statements
2323: --
2324: IF l_debug_on THEN
2325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2326: END IF;
2327: --
2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);

2324: IF l_debug_on THEN
2325: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2326: END IF;
2327: --
2328: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2329: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2330: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2331: WSH_UTIL_CORE.Add_Message(x_return_status);
2332: --

Line 2358: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Container');

2354: --
2355: EXCEPTION
2356:
2357: WHEN Others THEN
2358: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Container');
2359: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2360:
2361: --
2362: -- Debug Statements

Line 2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2515: --
2516: -- Debug Statements
2517: --
2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');

Line 2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);

2518: IF l_debug_on THEN
2519: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2520: END IF;
2521: --
2522: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2523: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NO_CHILD');
2524: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2525: WSH_UTIL_CORE.Add_Message(x_return_status);
2526: --

Line 2600: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2596: --
2597: -- Debug Statements
2598: --
2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2601: END IF;
2602: --
2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);
2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);

2599: IF l_debug_on THEN
2600: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2601: END IF;
2602: --
2603: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(det.delivery_detail_id);
2604: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2605: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2606: WSH_UTIL_CORE.Add_Message(x_return_status);
2607: END IF;

Line 2626: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Update_Child_Containers');

2622: --
2623: EXCEPTION
2624:
2625: WHEN Others THEN
2626: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Update_Child_Containers');
2627: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2628:
2629: --
2630: -- Debug Statements

Line 2695: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Master_serial_Number');

2691: --
2692: EXCEPTION
2693:
2694: WHEN Others THEN
2695: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Master_serial_Number');
2696: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2697:
2698: --
2699: -- Debug Statements

Line 2771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

2767: --
2768: -- Debug Statements
2769: --
2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2772: END IF;
2773: --
2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);

2770: IF l_debug_on THEN
2771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2772: END IF;
2773: --
2774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
2776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2777: WSH_UTIL_CORE.Add_Message(x_return_status);
2778: --

Line 2804: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number');

2800: --
2801: EXCEPTION
2802:
2803: WHEN Others THEN
2804: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number');
2805: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2806:
2807: --
2808: -- Debug Statements

Line 2905: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty');

2901: --
2902: EXCEPTION
2903:
2904: WHEN Others THEN
2905: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty');
2906: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
2907:
2908: --
2909: -- Debug Statements

Line 3010: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty2');

3006: IF c_details_exist%ISOPEN THEN
3007: close c_details_exist;
3008: END IF;
3009:
3010: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Is_Empty2');
3011: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3012:
3013: --
3014: -- Debug Statements

Line 3087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);

3083: --
3084: -- Debug Statements
3085: --
3086: IF l_debug_on THEN
3087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3088: END IF;
3089: --
3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);

3086: IF l_debug_on THEN
3087: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3088: END IF;
3089: --
3090: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3091: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3092: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3093: WSH_UTIL_CORE.Add_Message(x_return_status);
3094: --

Line 3122: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Fill_Percent');

3118: --
3119: EXCEPTION
3120:
3121: WHEN Others THEN
3122: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Fill_Percent');
3123: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3124:
3125: --
3126: -- Debug Statements

Line 3240: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Delivery_Status');

3236: --
3237: EXCEPTION
3238:
3239: WHEN Others THEN
3240: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Get_Delivery_Status');
3241: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3242:
3243: --
3244: -- Debug Statements

Line 3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);

3363: --
3364: -- Debug Statements
3365: --
3366: IF l_debug_on THEN
3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3368: END IF;
3369: --
3370: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
3371: p_container_instance_id,

Line 3370: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

3366: IF l_debug_on THEN
3367: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3368: END IF;
3369: --
3370: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
3371: p_container_instance_id,
3372: l_del_id,
3373: l_del_sts,
3374: x_return_status);

Line 3416: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Container');

3412: --
3413: EXCEPTION
3414:
3415: WHEN Others THEN
3416: WSH_UTIL_CORE.Default_Handler('WSH_CONTAINER_UTILITIES.Validate_Container');
3417: x_return_status := WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR;
3418:
3419: --
3420: -- Debug Statements

Line 3429: END WSH_CONTAINER_UTILITIES;

3425: END IF;
3426: --
3427: END Validate_Container;
3428:
3429: END WSH_CONTAINER_UTILITIES;