APPS.WSH_CONTAINER_ACTIONS dependencies on WSH_CONTAINER_UTILITIES

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

1406: -- to a closed or in-transit delivery (only open deliveries allowed)
1407:
1408: --
1409: IF l_debug_on THEN
1410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1411: END IF;
1412: --
1413: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
1414: p_container_id,

Line 1413: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

1409: IF l_debug_on THEN
1410: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1411: END IF;
1412: --
1413: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
1414: p_container_id,
1415: l_del_id,
1416: l_del_sts,
1417: x_return_status);

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

1706: -- to a closed or in-transit delivery (only open deliveries allowed)
1707:
1708: --
1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1711: END IF;
1712: --
1713: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,
1714: l_delivery_id,

Line 1713: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,

1709: IF l_debug_on THEN
1710: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
1711: END IF;
1712: --
1713: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_container_instance_id,
1714: l_delivery_id,
1715: l_del_status,
1716: x_return_status);
1717:

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

1847: CLOSE Get_Cont_Item;
1848: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_ERROR;
1849: --
1850: IF l_debug_on THEN
1851: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1852: END IF;
1853: --
1854: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1855: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

1850: IF l_debug_on THEN
1851: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
1852: END IF;
1853: --
1854: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
1855: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
1856: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
1857: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
1858: x_return_status := l_ret_sts;

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

1964: -- success always..
1965:
1966: --
1967: IF l_debug_on THEN
1968: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.VALIDATE_HAZARD_CLASS',WSH_DEBUG_SV.C_PROC_LEVEL);
1969: END IF;
1970: --
1971: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (
1972: l_del_detail_id,

Line 1971: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (

1967: IF l_debug_on THEN
1968: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.VALIDATE_HAZARD_CLASS',WSH_DEBUG_SV.C_PROC_LEVEL);
1969: END IF;
1970: --
1971: WSH_CONTAINER_UTILITIES.Validate_Hazard_Class (
1972: l_del_detail_id,
1973: p_container_instance_id,
1974: x_return_status);
1975:

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

2042: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2043: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2044: --
2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2047: END IF;
2048: --
2049: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2050: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2045: IF l_debug_on THEN
2046: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2047: END IF;
2048: --
2049: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2050: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2051: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2052: END IF;
2053:

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

2285: END IF;
2286:
2287: --
2288: IF l_debug_on THEN
2289: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2290: END IF;
2291: --
2292: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2293: l_cont_instance_id,

Line 2292: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

2288: IF l_debug_on THEN
2289: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2290: END IF;
2291: --
2292: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2293: l_cont_instance_id,
2294: l_delivery_id,
2295: l_del_status,
2296: x_return_status);

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

2441: ) THEN
2442: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LAST_LINE_ERROR');
2443: --
2444: IF l_debug_on THEN
2445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2446: END IF;
2447: --
2448: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2449: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2444: IF l_debug_on THEN
2445: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2446: END IF;
2447: --
2448: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2449: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2450: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2451: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2452: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2570: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2571: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2572: --
2573: IF l_debug_on THEN
2574: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2575: END IF;
2576: --
2577: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2578: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2573: IF l_debug_on THEN
2574: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2575: END IF;
2576: --
2577: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i));
2578: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2579: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2580: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2581: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2622: ELSIF l_cont_flag = 'Y' THEN --}{
2623:
2624: --
2625: IF l_debug_on THEN
2626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2627: END IF;
2628: --
2629: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2630: l_del_detail_rec(i),

Line 2629: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (

2625: IF l_debug_on THEN
2626: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
2627: END IF;
2628: --
2629: WSH_CONTAINER_UTILITIES.Get_Delivery_Status (
2630: l_del_detail_rec(i),
2631: l_delivery_id,
2632: l_del_status,
2633: x_return_status);

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

2681: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN --{
2682: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_LAST_LINE_ERROR');
2683: --
2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2686: END IF;
2687: --
2688: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2689: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2684: IF l_debug_on THEN
2685: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2686: END IF;
2687: --
2688: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2689: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2690: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
2691: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2692: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2804: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN --{
2805: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
2806: --
2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2809: END IF;
2810: --
2811: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2812: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2807: IF l_debug_on THEN
2808: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2809: END IF;
2810: --
2811: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2812: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2813: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
2814: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2815: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

2869: IF SQL%ROWCOUNT > 1 OR SQL%NOTFOUND THEN
2870: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_CHILD_UPD_ERROR');
2871: --
2872: IF l_debug_on THEN
2873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2874: END IF;
2875: --
2876: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2877: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

2872: IF l_debug_on THEN
2873: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2874: END IF;
2875: --
2876: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2877: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2878: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
2879: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2880: END IF;

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

2882: END IF;
2883:
2884: --
2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2887: END IF;
2888: --
2889: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (
2890: l_del_detail_rec(i),

Line 2889: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (

2885: IF l_debug_on THEN
2886: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_SERIAL_NUMBER',WSH_DEBUG_SV.C_PROC_LEVEL);
2887: END IF;
2888: --
2889: WSH_CONTAINER_UTILITIES.Get_Master_Serial_Number (
2890: l_del_detail_rec(i),
2891: l_master_serial_number,
2892: x_return_status);
2893: --

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

2899: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2900: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GET_SRL_ERROR');
2901: --
2902: IF l_debug_on THEN
2903: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2904: END IF;
2905: --
2906: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2907: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

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

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

2912: END IF;
2913:
2914: --
2915: IF l_debug_on THEN
2916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
2917: END IF;
2918: --
2919: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
2920: l_del_detail_rec(i),

Line 2919: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

2915: IF l_debug_on THEN
2916: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
2917: END IF;
2918: --
2919: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
2920: l_del_detail_rec(i),
2921: l_master_cont_name,
2922: l_master_serial_number,
2923: x_return_status);

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

2929:
2930: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
2931: --
2932: IF l_debug_on THEN
2933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2934: END IF;
2935: --
2936: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_del_detail_rec(i));
2937: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

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

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

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

2980:
2981: IF l_fill_status = 'O' THEN
2982:
2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2988: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');

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

2983: IF l_debug_on THEN
2984: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2985: END IF;
2986: --
2987: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
2988: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
2989: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
2990: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
2991: WSH_UTIL_CORE.Add_Message(l_return_status);

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

2992: x_pack_status := 'Overpacked';
2993:
2994: ELSIF l_fill_status = 'U' THEN
2995: IF l_debug_on THEN
2996: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2997: END IF;
2998: --
2999: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3000: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');

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

2995: IF l_debug_on THEN
2996: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
2997: END IF;
2998: --
2999: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3000: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
3001: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3002: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
3003: WSH_UTIL_CORE.Add_Message(l_return_status);

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

3192: IF Get_Cont_Org%NOTFOUND THEN
3193: CLOSE Get_Cont_Org;
3194: --
3195: IF l_debug_on THEN
3196: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3197: END IF;
3198: --
3199: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3200: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

3195: IF l_debug_on THEN
3196: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3197: END IF;
3198: --
3199: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3200: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3201: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3202: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3203: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3271: END IF;
3272: ELSE
3273: --
3274: IF l_debug_on THEN
3275: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3276: END IF;
3277: --
3278: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3279: --

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

3274: IF l_debug_on THEN
3275: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3276: END IF;
3277: --
3278: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
3279: --
3280: IF l_debug_on THEN
3281: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_NEW_DELIVERIES_PVT.GET_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3282: END IF;

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

3662: IF Get_Cont_Org%NOTFOUND THEN
3663: CLOSE Get_Cont_Org;
3664: --
3665: IF l_debug_on THEN
3666: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3667: END IF;
3668: --
3669: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

3665: IF l_debug_on THEN
3666: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3667: END IF;
3668: --
3669: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3670: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3671: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3672: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3673: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3690: IF Get_Cont_Org%NOTFOUND THEN
3691: CLOSE Get_Cont_Org;
3692: --
3693: IF l_debug_on THEN
3694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3695: END IF;
3696: --
3697: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3698: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

3693: IF l_debug_on THEN
3694: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3695: END IF;
3696: --
3697: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3698: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
3699: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3700: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3701: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

3713:
3714: IF l_det_cont_org <> l_par_cont_org THEN
3715: --
3716: IF l_debug_on THEN
3717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3718: END IF;
3719: --
3720: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3721: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');

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

3716: IF l_debug_on THEN
3717: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3718: END IF;
3719: --
3720: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3721: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3722: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3723: --
3724: IF l_debug_on THEN

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

3721: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_ORG_DIFF');
3722: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3723: --
3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3726: END IF;
3727: --
3728: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3729: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);

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

3724: IF l_debug_on THEN
3725: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3726: END IF;
3727: --
3728: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3729: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);
3730: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3731: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3732: --

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

3741: -- to a closed or in-transit delivery (only open deliveries allowed)
3742:
3743: --
3744: IF l_debug_on THEN
3745: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3746: END IF;
3747: --
3748: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,
3749: l_par_del_id,

Line 3748: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,

3744: IF l_debug_on THEN
3745: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3746: END IF;
3747: --
3748: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_par_cont_inst_id,
3749: l_par_del_id,
3750: l_del_status,
3751: x_return_status);
3752:

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

3781: -- to a closed or in-transit delivery (only open deliveries allowed)
3782:
3783: --
3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3786: END IF;
3787: --
3788: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,
3789: l_det_del_id,

Line 3788: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,

3784: IF l_debug_on THEN
3785: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_DELIVERY_STATUS',WSH_DEBUG_SV.C_PROC_LEVEL);
3786: END IF;
3787: --
3788: WSH_CONTAINER_UTILITIES.Get_Delivery_Status ( p_det_cont_inst_id,
3789: l_det_del_id,
3790: l_del_status,
3791: x_return_status);
3792:

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

3848:
3849:
3850: --
3851: IF l_debug_on THEN
3852: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3853: END IF;
3854: --
3855: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3856: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');

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

3851: IF l_debug_on THEN
3852: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3853: END IF;
3854: --
3855: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
3856: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');
3857: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3858: --
3859: IF l_debug_on THEN

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

3856: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_ASSG_DEL_DIFF');
3857: FND_MESSAGE.SET_TOKEN('ENTITY1',l_cont_name);
3858: --
3859: IF l_debug_on THEN
3860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3861: END IF;
3862: --
3863: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3864: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);

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

3859: IF l_debug_on THEN
3860: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3861: END IF;
3862: --
3863: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3864: FND_MESSAGE.SET_TOKEN('ENTITY2',l_cont_name);
3865: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
3866: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
3867: --

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

3877: END IF;
3878:
3879: --
3880: IF l_debug_on THEN
3881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
3882: END IF;
3883: --
3884: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (
3885: p_par_cont_inst_id,

Line 3884: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (

3880: IF l_debug_on THEN
3881: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_SERIAL',WSH_DEBUG_SV.C_PROC_LEVEL);
3882: END IF;
3883: --
3884: WSH_CONTAINER_UTILITIES.Get_Master_Cont_Serial (
3885: p_par_cont_inst_id,
3886: l_master_cont_id,
3887: l_master_cont_name,
3888: l_master_serial_number,

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

3895: --dbms_output.put_line('error while getting master serial for parent ' || p_par_cont_inst_id);
3896: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GET_MASTER_ERROR');
3897: --
3898: IF l_debug_on THEN
3899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3900: END IF;
3901: --
3902: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3903: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

3898: IF l_debug_on THEN
3899: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
3900: END IF;
3901: --
3902: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_par_cont_inst_id);
3903: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
3904: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
3905: IF l_ret_sts <> WSH_UTIL_CORE.G_RET_STS_ERROR THEN
3906: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

3986: --
3987: return;
3988: END IF;
3989:
3990: -- l_master_cont_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_det_cont_inst_id);
3991:
3992:
3993: --
3994: IF l_debug_on THEN

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

3991:
3992:
3993: --
3994: IF l_debug_on THEN
3995: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3996: END IF;
3997: --
3998: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
3999: p_det_cont_inst_id,

Line 3998: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

3994: IF l_debug_on THEN
3995: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
3996: END IF;
3997: --
3998: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
3999: p_det_cont_inst_id,
4000: l_master_cont_id,
4001: l_master_serial_number,
4002: x_return_status);

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

4007:
4008: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4009: --
4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4012: END IF;
4013: --
4014: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4015: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

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

4010: IF l_debug_on THEN
4011: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4012: END IF;
4013: --
4014: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4015: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4016: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4017: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4018: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

4070: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4071: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_GRP_ATTR_WARN');
4072: --
4073: IF l_debug_on THEN
4074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4075: END IF;
4076: --
4077: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4078: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

4073: IF l_debug_on THEN
4074: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4075: END IF;
4076: --
4077: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4078: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4079: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
4080: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
4081: END IF;

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

4081: END IF;
4082:
4083: --
4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4086: END IF;
4087: --
4088: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4089: p_det_cont_inst_id,

Line 4088: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4084: IF l_debug_on THEN
4085: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4086: END IF;
4087: --
4088: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4089: p_det_cont_inst_id,
4090: l_master_cont_id,
4091: l_master_serial_number,
4092: x_return_status);

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

4096:
4097: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4098: --
4099: IF l_debug_on THEN
4100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4101: END IF;
4102: --
4103: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4104: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

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

4099: IF l_debug_on THEN
4100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4101: END IF;
4102: --
4103: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4104: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4105: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4106: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4107: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

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

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

4161: IF l_debug_on THEN
4162: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4163: END IF;
4164: --
4165: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4166: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4167: l_ret_sts := WSH_UTIL_CORE.G_RET_STS_WARNING;
4168: WSH_UTIL_CORE.Add_Message(l_ret_sts,l_module_name);
4169: END IF;

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

4169: END IF;
4170:
4171: --
4172: IF l_debug_on THEN
4173: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4174: END IF;
4175: --
4176: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4177: p_det_cont_inst_id,

Line 4176: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4172: IF l_debug_on THEN
4173: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4174: END IF;
4175: --
4176: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4177: p_det_cont_inst_id,
4178: l_master_cont_id,
4179: l_master_serial_number,
4180: x_return_status);

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

4184:
4185: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4186: --
4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4189: END IF;
4190: --
4191: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4192: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

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

4187: IF l_debug_on THEN
4188: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4189: END IF;
4190: --
4191: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4192: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4193: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4194: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4195: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

4273:
4274: -- call update cont attributes to update grouping attr.
4275: --
4276: IF l_debug_on THEN
4277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4278: END IF;
4279: --
4280: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4281: p_det_cont_inst_id,

Line 4280: WSH_CONTAINER_UTILITIES.Update_Child_Containers (

4276: IF l_debug_on THEN
4277: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.UPDATE_CHILD_CONTAINERS',WSH_DEBUG_SV.C_PROC_LEVEL);
4278: END IF;
4279: --
4280: WSH_CONTAINER_UTILITIES.Update_Child_Containers (
4281: p_det_cont_inst_id,
4282: l_master_cont_id,
4283: l_master_serial_number,
4284: x_return_status);

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

4288:
4289: IF x_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
4290: --
4291: IF l_debug_on THEN
4292: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4293: END IF;
4294: --
4295: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4296: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');

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

4291: IF l_debug_on THEN
4292: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
4293: END IF;
4294: --
4295: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_det_cont_inst_id);
4296: FND_MESSAGE.SET_NAME('WSH', 'WSH_CONT_CHILD_UPD_ERROR');
4297: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
4298: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
4299: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);

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

8767:
8768: IF Get_Cont_Info%NOTFOUND THEN
8769: --
8770: IF l_debug_on THEN
8771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8772: END IF;
8773: --
8774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

8770: IF l_debug_on THEN
8771: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8772: END IF;
8773: --
8774: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8775: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
8776: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
8777: x_pack_status := 'Error';
8778: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

8815:
8816: l_cont_tab(i).pack_status := 'Warning';
8817: --
8818: IF l_debug_on THEN
8819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8820: END IF;
8821: --
8822: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8823: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

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

8818: IF l_debug_on THEN
8819: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8820: END IF;
8821: --
8822: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8823: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
8824: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
8825:
8826:

Line 8855: -- WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers (

8851: l_cont_avail_pc := 1 - (nvl(l_cont_fill_pc,0)/100);
8852:
8853: IF (l_cont_org_id = l_det_org_id) THEN
8854:
8855: -- WSH_CONTAINER_UTILITIES.Estimate_Detail_Containers (
8856: -- replacing with TPA enabled API..
8857:
8858: --
8859: IF l_debug_on THEN

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

8921:
8922: IF l_fill_status = 'O' THEN
8923: --
8924: IF l_debug_on THEN
8925: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8926: END IF;
8927: --
8928: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8929:

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

8924: IF l_debug_on THEN
8925: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
8926: END IF;
8927: --
8928: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
8929:
8930: --dbms_output.put_line('container ' || l_cont_name || ' overpacked ');
8931:
8932:

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

9294:
9295: IF Get_Cont_Info%NOTFOUND THEN
9296: --
9297: IF l_debug_on THEN
9298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9299: END IF;
9300: --
9301: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9302: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');

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

9297: IF l_debug_on THEN
9298: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9299: END IF;
9300: --
9301: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9302: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
9303: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9304: -- x_pack_status := 'Error';
9305: l_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

9471: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_DET_NO_MATCH');
9472: FND_MESSAGE.SET_TOKEN('DETAIL_ID',l_det_tab(j).delivery_detail_id);
9473: --
9474: IF l_debug_on THEN
9475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9476: END IF;
9477: --
9478: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9479: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

9474: IF l_debug_on THEN
9475: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9476: END IF;
9477: --
9478: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9479: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9480:
9481: END IF; -- cont org and det org id check
9482:

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

9714: cont_err := cont_err + 1;
9715: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_NOT_PACKED');
9716: --
9717: IF l_debug_on THEN
9718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9719: END IF;
9720: --
9721: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9722: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

9717: IF l_debug_on THEN
9718: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9719: END IF;
9720: --
9721: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9722: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9723: WSH_UTIL_CORE.Add_Message(l_return_status,l_module_name);
9724: ELSIF l_cont_tab(i).pack_status = 'Overpacked' THEN
9725: cont_warn := cont_warn + 1;

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

9725: cont_warn := cont_warn + 1;
9726: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_OVERPACKED');
9727: --
9728: IF l_debug_on THEN
9729: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9730: END IF;
9731: --
9732: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9733: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

9728: IF l_debug_on THEN
9729: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9730: END IF;
9731: --
9732: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9733: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9734: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9735: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
9736: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

9739: cont_warn := cont_warn + 1;
9740: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UNDERPACKED');
9741: --
9742: IF l_debug_on THEN
9743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9744: END IF;
9745: --
9746: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9747: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

9742: IF l_debug_on THEN
9743: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9744: END IF;
9745: --
9746: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9747: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9748: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9749: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
9750: l_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;

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

9753: cont_warn := cont_warn + 1;
9754: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
9755: --
9756: IF l_debug_on THEN
9757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9758: END IF;
9759: --
9760: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9761: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

9756: IF l_debug_on THEN
9757: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
9758: END IF;
9759: --
9760: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_tab(i).container_instance_id);
9761: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
9762: WSH_UTIL_CORE.Add_Message(WSH_UTIL_CORE.G_RET_STS_WARNING,l_module_name);
9763:
9764: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN

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

10674: IF (l_return_status <> C_SUCCESS_STATUS) THEN
10675: --dbms_output.put_line('WSH_TPA_CONTAINER_PKG.Container_Weight_Volume did not return success');
10676: --
10677: IF l_debug_on THEN
10678: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10679: END IF;
10680: --
10681: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10682: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

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

10677: IF l_debug_on THEN
10678: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10679: END IF;
10680: --
10681: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10682: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
10683: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
10684: IF l_return_status = C_WARNING_STATUS THEN
10685: warn_cnt := warn_cnt + 1;

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

10810: IF (l_return_status <> C_SUCCESS_STATUS) THEN
10811: --dbms_output.put_line('WSH_TPA_CONTAINER_PKG.Container_Weight_Volume did not return success');
10812: --
10813: IF l_debug_on THEN
10814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10815: END IF;
10816: --
10817: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10818: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');

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

10813: IF l_debug_on THEN
10814: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
10815: END IF;
10816: --
10817: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(line_cont_rec.delivery_detail_id);
10818: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_WT_VOL_FAILED');
10819: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
10820: IF l_return_status = C_WARNING_STATUS THEN
10821: warn_cnt := warn_cnt + 1;

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

11409:
11410: IF SQL%NOTFOUND THEN
11411: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11412: IF l_debug_on THEN
11413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11414: END IF;
11415: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_instance_id);
11416: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11417: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;

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

11411: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11412: IF l_debug_on THEN
11413: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11414: END IF;
11415: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(l_cont_instance_id);
11416: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11417: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11418: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
11419: IF l_debug_on THEN

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

11776: --dbms_output.put_line('could not update container ' || p_container_instance_id);
11777: FND_MESSAGE.SET_NAME('WSH','WSH_INVALID_CONTAINER');
11778: --
11779: IF l_debug_on THEN
11780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11781: END IF;
11782: --
11783: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
11784: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

11779: IF l_debug_on THEN
11780: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
11781: END IF;
11782: --
11783: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(p_container_instance_id);
11784: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
11785: x_return_status := WSH_UTIL_CORE.G_RET_STS_ERROR;
11786: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
11787: --

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

12040: END IF;
12041: --
12042: --
12043: IF l_debug_on THEN
12044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12045: END IF;
12046: --
12047: l_master_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id(p_container_instance_id);
12048:

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

12043: IF l_debug_on THEN
12044: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12045: END IF;
12046: --
12047: l_master_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id(p_container_instance_id);
12048:
12049: IF l_master_cont_inst_id IS NULL THEN
12050: l_master_cont_inst_id := p_container_instance_id;
12051: END IF;

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

12095: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
12096: FND_MESSAGE.SET_NAME('WSH','WSH_CONT_UPD_ATTR_ERROR');
12097: --
12098: IF l_debug_on THEN
12099: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
12100: END IF;
12101: --
12102: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(cont.delivery_detail_id);
12103: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);

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

12098: IF l_debug_on THEN
12099: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_CONT_NAME',WSH_DEBUG_SV.C_PROC_LEVEL);
12100: END IF;
12101: --
12102: l_cont_name := WSH_CONTAINER_UTILITIES.Get_Cont_Name(cont.delivery_detail_id);
12103: FND_MESSAGE.SET_TOKEN('CONT_NAME',l_cont_name);
12104: x_return_status := WSH_UTIL_CORE.G_RET_STS_WARNING;
12105: WSH_UTIL_CORE.Add_Message(x_return_status,l_module_name);
12106: END IF;

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

12211: END IF;
12212: --
12213: --
12214: IF l_debug_on THEN
12215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12216: END IF;
12217: --
12218: l_mast_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_container_instance_id);
12219:

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

12214: IF l_debug_on THEN
12215: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_CONTAINER_UTILITIES.GET_MASTER_CONT_ID',WSH_DEBUG_SV.C_PROC_LEVEL);
12216: END IF;
12217: --
12218: l_mast_cont_inst_id := WSH_CONTAINER_UTILITIES.Get_Master_Cont_Id (p_container_instance_id);
12219:
12220: IF l_mast_cont_inst_id IS NULL THEN
12221: l_mast_cont_inst_id := p_container_instance_id;
12222: END IF;