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_UTILITIES

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

1433: -- to a closed or in-transit delivery (only open deliveries allowed)
1434:
1435: --
1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: END IF;
1439: --
1440: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
1441: p_container_id,

Line 1440: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

1436: IF l_debug_on THEN
1437: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1438: END IF;
1439: --
1440: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
1441: p_container_id,
1442: l_del_id,
1443: l_del_sts,
1444: x_return_status);

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

1733: -- to a closed or in-transit delivery (only open deliveries allowed)
1734:
1735: --
1736: IF l_debug_on THEN
1737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1738: END IF;
1739: --
1740: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,
1741: l_delivery_id,

Line 1740: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,

1736: IF l_debug_on THEN
1737: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1738: END IF;
1739: --
1740: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,
1741: l_delivery_id,
1742: l_del_status,
1743: x_return_status);
1744:

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

1874: CLOSE Get_Cont_Item;
1875: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1876: --
1877: IF l_debug_on THEN
1878: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1879: END IF;
1880: --
1881: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1882: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

1877: IF l_debug_on THEN
1878: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1879: END IF;
1880: --
1881: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1882: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1883: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1884: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
1885: x_return_status := l_ret_sts;

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

1991: -- success always..
1992:
1993: --
1994: IF l_debug_on THEN
1995: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.VALIDATE_HAZARD_CLASS',WSH_DEBUG_SV.C_PROC_LEVEL);
1996: END IF;
1997: --
1998: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (
1999: l_del_detail_id,

Line 1998: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (

1994: IF l_debug_on THEN
1995: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.VALIDATE_HAZARD_CLASS',WSH_DEBUG_SV.C_PROC_LEVEL);
1996: END IF;
1997: --
1998: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (
1999: l_del_detail_id,
2000: p_container_instance_id,
2001: x_return_status);
2002:

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

2069: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2070: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2071: --
2072: IF l_debug_on THEN
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2074: END IF;
2075: --
2076: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2077: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2072: IF l_debug_on THEN
2073: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2074: END IF;
2075: --
2076: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2077: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2078: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2079: END IF;
2080:

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

2315: END IF;
2316:
2317: --
2318: IF l_debug_on THEN
2319: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2320: END IF;
2321: --
2322: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2323: l_cont_instance_id,

Line 2322: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

2318: IF l_debug_on THEN
2319: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2320: END IF;
2321: --
2322: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2323: l_cont_instance_id,
2324: l_delivery_id,
2325: l_del_status,
2326: x_return_status);

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

2471: ) THEN
2472: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LAST_LINE_ERROR');
2473: --
2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2476: END IF;
2477: --
2478: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2479: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2478: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));

2474: IF l_debug_on THEN
2475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2476: END IF;
2477: --
2478: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2479: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2480: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2481: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2482: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2601: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2602: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2603: --
2604: IF l_debug_on THEN
2605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2606: END IF;
2607: --
2608: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2609: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2608: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));

2604: IF l_debug_on THEN
2605: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2606: END IF;
2607: --
2608: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2609: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2610: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2611: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2612: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2653: ELSIF l_cont_flag = 'Y' THEN --}{
2654:
2655: --
2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659: --
2660: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2661: l_del_detail_rec(i),

Line 2660: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

2656: IF l_debug_on THEN
2657: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2658: END IF;
2659: --
2660: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2661: l_del_detail_rec(i),
2662: l_delivery_id,
2663: l_del_status,
2664: x_return_status);

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

2711: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN --{
2712: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LAST_LINE_ERROR');
2713: --
2714: IF l_debug_on THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717: --
2718: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2719: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2718: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));

2714: IF l_debug_on THEN
2715: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2716: END IF;
2717: --
2718: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2719: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2720: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2721:
2722: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN

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

2838: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN --{
2839: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2840: --
2841: IF l_debug_on THEN
2842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2843: END IF;
2844: --
2845: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2846: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2845: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));

2841: IF l_debug_on THEN
2842: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2843: END IF;
2844: --
2845: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2846: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2847: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2848: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2849: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2903: IF SQL%ROWCOUNT > 1 OR SQL%NOTFOUND THEN
2904: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CHILD_UPD_ERROR');
2905: --
2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2908: END IF;
2909: --
2910: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2911: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2910: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));

2906: IF l_debug_on THEN
2907: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2908: END IF;
2909: --
2910: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2911: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2912: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2913: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2914: END IF;

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

2916: END IF;
2917:
2918: --
2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922: --
2923: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (
2924: l_del_detail_rec(i),

Line 2923: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (

2919: IF l_debug_on THEN
2920: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2921: END IF;
2922: --
2923: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (
2924: l_del_detail_rec(i),
2925: l_master_serial_number,
2926: x_return_status);
2927: --

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

2933: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2934: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GET_SRL_ERROR');
2935: --
2936: IF l_debug_on THEN
2937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2938: END IF;
2939: --
2940: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2941: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 2940: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));

2936: IF l_debug_on THEN
2937: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2938: END IF;
2939: --
2940: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2941: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2942: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2943: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2944: END IF;

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

2946: END IF;
2947:
2948: --
2949: IF l_debug_on THEN
2950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
2951: END IF;
2952: --
2953: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
2954: l_del_detail_rec(i),

Line 2953: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

2949: IF l_debug_on THEN
2950: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
2951: END IF;
2952: --
2953: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
2954: l_del_detail_rec(i),
2955: l_master_cont_name,
2956: l_master_serial_number,
2957: x_return_status);

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

2963:
2964: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2965: --
2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2968: END IF;
2969: --
2970: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2971: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

Line 2970: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));

2966: IF l_debug_on THEN
2967: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2968: END IF;
2969: --
2970: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2971: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
2972: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2973: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2974: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3014:
3015: IF l_fill_status = 'O' THEN
3016:
3017: IF l_debug_on THEN
3018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3019: END IF;
3020: --
3021: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3022: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');

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

3017: IF l_debug_on THEN
3018: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3019: END IF;
3020: --
3021: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3022: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
3023: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3024: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3025: WSH_UTIL_CORE.Add_Message(l_return_status);

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

3026: x_pack_status := 'Overpacked';
3027:
3028: ELSIF l_fill_status = 'U' THEN
3029: IF l_debug_on THEN
3030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3031: END IF;
3032: --
3033: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3034: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');

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

3029: IF l_debug_on THEN
3030: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3031: END IF;
3032: --
3033: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3034: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
3035: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3036: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3037: WSH_UTIL_CORE.Add_Message(l_return_status);

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

3246: IF Get_Cont_Org%NOTFOUND THEN
3247: CLOSE Get_Cont_Org;
3248: --
3249: IF l_debug_on THEN
3250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3251: END IF;
3252: --
3253: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3254: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

3249: IF l_debug_on THEN
3250: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3251: END IF;
3252: --
3253: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3254: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3255: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3256: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3257: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3325: END IF;
3326: ELSE
3327: --
3328: IF l_debug_on THEN
3329: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3330: END IF;
3331: --
3332: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3333: --

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

3328: IF l_debug_on THEN
3329: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3330: END IF;
3331: --
3332: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3333: --
3334: IF l_debug_on THEN
3335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3336: END IF;

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

3719: IF Get_Cont_Org%NOTFOUND THEN
3720: CLOSE Get_Cont_Org;
3721: --
3722: IF l_debug_on THEN
3723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3724: END IF;
3725: --
3726: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3727: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 3726: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

3722: IF l_debug_on THEN
3723: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3724: END IF;
3725: --
3726: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3727: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3728: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3729: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3730: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3747: IF Get_Cont_Org%NOTFOUND THEN
3748: CLOSE Get_Cont_Org;
3749: --
3750: IF l_debug_on THEN
3751: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3752: END IF;
3753: --
3754: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3755: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 3754: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);

3750: IF l_debug_on THEN
3751: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3752: END IF;
3753: --
3754: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3755: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3756: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3757: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3758: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3770:
3771: IF l_det_cont_org <> l_par_cont_org THEN
3772: --
3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3775: END IF;
3776: --
3777: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3778: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');

Line 3777: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

3773: IF l_debug_on THEN
3774: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3775: END IF;
3776: --
3777: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3778: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3779: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3780: --
3781: IF l_debug_on THEN

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

3778: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3779: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3780: --
3781: IF l_debug_on THEN
3782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3783: END IF;
3784: --
3785: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3786: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);

Line 3785: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);

3781: IF l_debug_on THEN
3782: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3783: END IF;
3784: --
3785: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3786: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);
3787: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3788: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3789: --

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

3798: -- to a closed or in-transit delivery (only open deliveries allowed)
3799:
3800: --
3801: IF l_debug_on THEN
3802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3803: END IF;
3804: --
3805: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,
3806: l_par_del_id,

Line 3805: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,

3801: IF l_debug_on THEN
3802: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3803: END IF;
3804: --
3805: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,
3806: l_par_del_id,
3807: l_del_status,
3808: x_return_status);
3809:

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

3839: -- to a closed or in-transit delivery (only open deliveries allowed)
3840:
3841: --
3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3844: END IF;
3845: --
3846: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,
3847: l_det_del_id,

Line 3846: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,

3842: IF l_debug_on THEN
3843: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3844: END IF;
3845: --
3846: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,
3847: l_det_del_id,
3848: l_del_status,
3849: x_return_status);
3850:

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

3906:
3907:
3908: --
3909: IF l_debug_on THEN
3910: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3911: END IF;
3912: --
3913: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3914: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');

Line 3913: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

3909: IF l_debug_on THEN
3910: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3911: END IF;
3912: --
3913: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3914: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');
3915: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3916: --
3917: IF l_debug_on THEN

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

3914: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');
3915: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3916: --
3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3919: END IF;
3920: --
3921: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3922: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);

Line 3921: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);

3917: IF l_debug_on THEN
3918: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3919: END IF;
3920: --
3921: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3922: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);
3923: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3924: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3925: --

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

3935: END IF;
3936:
3937: --
3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
3940: END IF;
3941: --
3942: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (
3943: p_par_cont_inst_id,

Line 3942: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (

3938: IF l_debug_on THEN
3939: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
3940: END IF;
3941: --
3942: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (
3943: p_par_cont_inst_id,
3944: l_master_cont_id,
3945: l_master_cont_name,
3946: l_master_serial_number,

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

3953: --dbms_output.put_line('error while getting master serial for parent ' || p_par_cont_inst_id);
3954: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GET_MASTER_ERROR');
3955: --
3956: IF l_debug_on THEN
3957: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3958: END IF;
3959: --
3960: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3961: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 3960: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);

3956: IF l_debug_on THEN
3957: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3958: END IF;
3959: --
3960: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3961: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3962: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3963: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3964: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

Line 4048: -- l_master_cont_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_det_cont_inst_id);

4044: --
4045: return;
4046: END IF;
4047:
4048: -- l_master_cont_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_det_cont_inst_id);
4049:
4050:
4051: --
4052: IF l_debug_on THEN

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

4049:
4050:
4051: --
4052: IF l_debug_on THEN
4053: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4054: END IF;
4055: --
4056: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4057: p_det_cont_inst_id,

Line 4056: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4052: IF l_debug_on THEN
4053: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4054: END IF;
4055: --
4056: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4057: p_det_cont_inst_id,
4058: l_master_cont_id,
4059: l_master_serial_number,
4060: x_return_status);

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

4065:
4066: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4067: --
4068: IF l_debug_on THEN
4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4070: END IF;
4071: --
4072: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4073: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

Line 4072: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4068: IF l_debug_on THEN
4069: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4070: END IF;
4071: --
4072: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4073: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4074: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4075: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4076: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

4128: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4129: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GRP_ATTR_WARN');
4130: --
4131: IF l_debug_on THEN
4132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4133: END IF;
4134: --
4135: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4136: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 4135: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4131: IF l_debug_on THEN
4132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4133: END IF;
4134: --
4135: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4136: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4137: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
4138: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
4139: END IF;

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

4139: END IF;
4140:
4141: --
4142: IF l_debug_on THEN
4143: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4144: END IF;
4145: --
4146: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4147: p_det_cont_inst_id,

Line 4146: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4142: IF l_debug_on THEN
4143: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4144: END IF;
4145: --
4146: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4147: p_det_cont_inst_id,
4148: l_master_cont_id,
4149: l_master_serial_number,
4150: x_return_status);

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

4154:
4155: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4156: --
4157: IF l_debug_on THEN
4158: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4159: END IF;
4160: --
4161: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4162: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

Line 4161: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4157: IF l_debug_on THEN
4158: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4159: END IF;
4160: --
4161: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4162: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4163: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4164: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4165: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

4216: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4217: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GRP_ATTR_WARN');
4218: --
4219: IF l_debug_on THEN
4220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4221: END IF;
4222: --
4223: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4224: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 4223: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4219: IF l_debug_on THEN
4220: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4221: END IF;
4222: --
4223: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4224: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4225: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
4226: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
4227: END IF;

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

4227: END IF;
4228:
4229: --
4230: IF l_debug_on THEN
4231: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4232: END IF;
4233: --
4234: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4235: p_det_cont_inst_id,

Line 4234: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4230: IF l_debug_on THEN
4231: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4232: END IF;
4233: --
4234: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4235: p_det_cont_inst_id,
4236: l_master_cont_id,
4237: l_master_serial_number,
4238: x_return_status);

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

4242:
4243: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4244: --
4245: IF l_debug_on THEN
4246: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4247: END IF;
4248: --
4249: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

Line 4249: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4245: IF l_debug_on THEN
4246: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4247: END IF;
4248: --
4249: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4250: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4251: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4252: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4253: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

4331:
4332: -- call update cont attributes to update grouping attr.
4333: --
4334: IF l_debug_on THEN
4335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4336: END IF;
4337: --
4338: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4339: p_det_cont_inst_id,

Line 4338: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4334: IF l_debug_on THEN
4335: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4336: END IF;
4337: --
4338: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4339: p_det_cont_inst_id,
4340: l_master_cont_id,
4341: l_master_serial_number,
4342: x_return_status);

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

4346:
4347: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4348: --
4349: IF l_debug_on THEN
4350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4351: END IF;
4352: --
4353: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4354: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

Line 4353: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);

4349: IF l_debug_on THEN
4350: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4351: END IF;
4352: --
4353: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4354: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4355: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4356: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4357: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

8896:
8897: IF Get_Cont_Info%NOTFOUND THEN
8898: --
8899: IF l_debug_on THEN
8900: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8901: END IF;
8902: --
8903: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8904: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 8903: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

8899: IF l_debug_on THEN
8900: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8901: END IF;
8902: --
8903: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8904: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
8905: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
8906: x_pack_status := 'Error';
8907: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

8944:
8945: l_cont_tab(i).pack_status := 'Warning';
8946: --
8947: IF l_debug_on THEN
8948: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8949: END IF;
8950: --
8951: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8952: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

Line 8951: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

8947: IF l_debug_on THEN
8948: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8949: END IF;
8950: --
8951: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8952: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
8953: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
8954:
8955:

Line 8984: -- WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers (

8980: l_cont_avail_pc := 1 - (nvl(l_cont_fill_pc,0)/100);
8981:
8982: IF (l_cont_org_id = l_det_org_id) THEN
8983:
8984: -- WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers (
8985: -- replacing with TPA enabled API..
8986:
8987: --
8988: IF l_debug_on THEN

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

9050:
9051: IF l_fill_status = 'O' THEN
9052: --
9053: IF l_debug_on THEN
9054: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9055: END IF;
9056: --
9057: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9058:

Line 9057: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9053: IF l_debug_on THEN
9054: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9055: END IF;
9056: --
9057: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9058:
9059: --dbms_output.put_line('container ' || l_cont_name || ' overpacked ');
9060:
9061:

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

9423:
9424: IF Get_Cont_Info%NOTFOUND THEN
9425: --
9426: IF l_debug_on THEN
9427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9428: END IF;
9429: --
9430: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9431: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

Line 9430: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9426: IF l_debug_on THEN
9427: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9428: END IF;
9429: --
9430: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9431: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
9432: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9433: -- x_pack_status := 'Error';
9434: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9600: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NO_MATCH');
9601: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_det_tab(j).delivery_detail_id);
9602: --
9603: IF l_debug_on THEN
9604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9605: END IF;
9606: --
9607: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9608: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 9607: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9603: IF l_debug_on THEN
9604: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9605: END IF;
9606: --
9607: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9608: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9609:
9610: END IF; -- cont org and det org id check
9611:

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

9843: cont_err := cont_err + 1;
9844: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NOT_PACKED');
9845: --
9846: IF l_debug_on THEN
9847: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9848: END IF;
9849: --
9850: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9851: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 9850: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9846: IF l_debug_on THEN
9847: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9848: END IF;
9849: --
9850: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9851: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9852: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
9853: ELSIF l_cont_tab(i).pack_status = 'Overpacked' THEN
9854: cont_warn := cont_warn + 1;

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

9854: cont_warn := cont_warn + 1;
9855: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
9856: --
9857: IF l_debug_on THEN
9858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9859: END IF;
9860: --
9861: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9862: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 9861: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9857: IF l_debug_on THEN
9858: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9859: END IF;
9860: --
9861: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9862: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9863: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9864: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
9865: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

9868: cont_warn := cont_warn + 1;
9869: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
9870: --
9871: IF l_debug_on THEN
9872: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9873: END IF;
9874: --
9875: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9876: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 9875: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9871: IF l_debug_on THEN
9872: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9873: END IF;
9874: --
9875: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9876: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9877: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9878: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
9879: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

9882: cont_warn := cont_warn + 1;
9883: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
9884: --
9885: IF l_debug_on THEN
9886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9887: END IF;
9888: --
9889: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9890: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 9889: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);

9885: IF l_debug_on THEN
9886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9887: END IF;
9888: --
9889: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9890: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9891: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9892:
9893: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

10803: IF (l_return_status <> C_SUCCESS_STATUS) THEN
10804: --dbms_output.put_line('WSH_TPA_CONTAINER_PKG.Container_Weight_Volume did not return success');
10805: --
10806: IF l_debug_on THEN
10807: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10808: END IF;
10809: --
10810: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10811: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

Line 10810: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);

10806: IF l_debug_on THEN
10807: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10808: END IF;
10809: --
10810: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10811: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
10812: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
10813: IF l_return_status = C_WARNING_STATUS THEN
10814: warn_cnt := warn_cnt + 1;

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

10939: IF (l_return_status <> C_SUCCESS_STATUS) THEN
10940: --dbms_output.put_line('WSH_TPA_CONTAINER_PKG.Container_Weight_Volume did not return success');
10941: --
10942: IF l_debug_on THEN
10943: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10944: END IF;
10945: --
10946: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10947: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

Line 10946: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);

10942: IF l_debug_on THEN
10943: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10944: END IF;
10945: --
10946: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10947: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
10948: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
10949: IF l_return_status = C_WARNING_STATUS THEN
10950: warn_cnt := warn_cnt + 1;

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

11538:
11539: IF SQL%NOTFOUND THEN
11540: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11541: IF l_debug_on THEN
11542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11543: END IF;
11544: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_instance_id);
11545: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11546: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

Line 11544: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_instance_id);

11540: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11541: IF l_debug_on THEN
11542: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11543: END IF;
11544: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_instance_id);
11545: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11546: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11547: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
11548: IF l_debug_on THEN

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

11926: --dbms_output.put_line('could not update container ' || p_container_instance_id);
11927: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11928: --
11929: IF l_debug_on THEN
11930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11931: END IF;
11932: --
11933: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
11934: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

11929: IF l_debug_on THEN
11930: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11931: END IF;
11932: --
11933: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
11934: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11935: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11936: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
11937: --

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

12190: END IF;
12191: --
12192: --
12193: IF l_debug_on THEN
12194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12195: END IF;
12196: --
12197: l_master_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id(p_container_instance_id);
12198:

Line 12197: l_master_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id(p_container_instance_id);

12193: IF l_debug_on THEN
12194: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12195: END IF;
12196: --
12197: l_master_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id(p_container_instance_id);
12198:
12199: IF l_master_cont_inst_id IS NULL THEN
12200: l_master_cont_inst_id := p_container_instance_id;
12201: END IF;

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

12245: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12246: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
12247: --
12248: IF l_debug_on THEN
12249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
12250: END IF;
12251: --
12252: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(cont.delivery_detail_id);
12253: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

Line 12252: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(cont.delivery_detail_id);

12248: IF l_debug_on THEN
12249: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
12250: END IF;
12251: --
12252: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(cont.delivery_detail_id);
12253: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
12254: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
12255: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
12256: END IF;

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

12361: END IF;
12362: --
12363: --
12364: IF l_debug_on THEN
12365: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12366: END IF;
12367: --
12368: l_mast_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_container_instance_id);
12369:

Line 12368: l_mast_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_container_instance_id);

12364: IF l_debug_on THEN
12365: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12366: END IF;
12367: --
12368: l_mast_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_container_instance_id);
12369:
12370: IF l_mast_cont_inst_id IS NULL THEN
12371: l_mast_cont_inst_id := p_container_instance_id;
12372: END IF;