DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_DELIVERY_DETAILS_UTILITIES

Line 1868: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

1864: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1865: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1866: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1867: -- deliveryMerge
1868: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1869: l_unappended_det_tbl WSH_UTIL_CORE.Id_Tab_Type;
1870: l_default_ship_confirm_rule_id NUMBER := NULL;
1871: l_appended_del_tbl WSH_UTIL_CORE.Id_Tab_Type;
1872: l_tmp_del_tbl WSH_UTIL_CORE.Id_Tab_Type;

Line 1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

1990: END LOOP;
1991: --{
1992: IF l_debug_on THEN
1993: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1995: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1996: END IF;
1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1998: p_delivery_detail_tbl => l_id_tab_temp,

Line 1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (

1993: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1994: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1995: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1996: END IF;
1997: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1998: p_delivery_detail_tbl => l_id_tab_temp,
1999: p_append_flag => p_append_flag,
2000: p_group_by_header => p_use_header_flag,
2001: p_commit => FND_API.G_FALSE,

Line 2015: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2011: END IF;
2012: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2013: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2014: x_return_status := l_return_status;
2015: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2016: IF l_debug_on THEN
2017: WSH_DEBUG_SV.pop(l_module_name);
2018: END IF;
2019: RETURN;

Line 2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

2157: --{
2158: -- deliveryMerge
2159: IF l_debug_on THEN
2160: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2162: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2163: END IF;
2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2165: p_delivery_detail_tbl => l_del_details_tbl,

Line 2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2160: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2161: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2162: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2163: END IF;
2164: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2165: p_delivery_detail_tbl => l_del_details_tbl,
2166: p_append_flag => p_append_flag,
2167: p_group_by_header => p_use_header_flag,
2168: p_commit => FND_API.G_FALSE,

Line 2182: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2178: END IF;
2179: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2180: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2181: x_return_status := l_return_status;
2182: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2183: IF l_debug_on THEN
2184: WSH_DEBUG_SV.pop(l_module_name);
2185: END IF;
2186: RETURN;

Line 2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);

2267: --{
2268: -- deliveryMerge
2269: IF l_debug_on THEN
2270: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2272: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2273: END IF;
2274:
2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

Line 2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2271: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2272: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2273: END IF;
2274:
2275: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2276: p_delivery_detail_tbl => l_del_details_tbl,
2277: p_append_flag => p_append_flag,
2278: p_group_by_header => p_use_header_flag,
2279: p_commit => FND_API.G_FALSE,

Line 2296: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');

2292: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2293: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2294: --{
2295: x_return_status := l_return_status;
2296: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2297: IF l_debug_on THEN
2298: WSH_DEBUG_SV.pop(l_module_name);
2299: END IF;
2300: RETURN;