DBA Data[Home] [Help]

APPS.WSH_PICK_LIST dependencies on WSH_DELIVERY_DETAILS_UTILITIES

Line 1807: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;

1803: l_cc_stop_attr_tab WSH_TRIP_STOPS_PVT.Stop_Attr_Tbl_Type;
1804: l_cc_in_ids WSH_UTIL_CORE.Id_Tab_Type;
1805: l_cc_fail_ids WSH_UTIL_CORE.Id_Tab_Type;
1806: -- deliveryMerge
1807: l_appended_det_tbl WSH_DELIVERY_DETAILS_UTILITIES.delivery_assignment_rec_tbl;
1808: l_unappended_det_tbl WSH_UTIL_CORE.Id_Tab_Type;
1809: l_default_ship_confirm_rule_id NUMBER := NULL;
1810: l_appended_del_tbl WSH_UTIL_CORE.Id_Tab_Type;
1811: l_tmp_del_tbl WSH_UTIL_CORE.Id_Tab_Type;

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

1929: END LOOP;
1930: --{
1931: IF l_debug_on THEN
1932: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1934: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1935: END IF;
1936: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1937: p_delivery_detail_tbl => l_id_tab_temp,

Line 1936: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (

1932: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_id_tab_temp.count);
1933: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
1934: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
1935: END IF;
1936: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries (
1937: p_delivery_detail_tbl => l_id_tab_temp,
1938: p_append_flag => p_append_flag,
1939: p_group_by_header => p_use_header_flag,
1940: p_commit => FND_API.G_FALSE,

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

1950: END IF;
1951: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
1952: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
1953: x_return_status := l_return_status;
1954: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
1955: IF l_debug_on THEN
1956: WSH_DEBUG_SV.pop(l_module_name);
1957: END IF;
1958: RETURN;

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

2096: --{
2097: -- deliveryMerge
2098: IF l_debug_on THEN
2099: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2101: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2102: END IF;
2103: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2104: p_delivery_detail_tbl => l_del_details_tbl,

Line 2103: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2099: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2100: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2101: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2102: END IF;
2103: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2104: p_delivery_detail_tbl => l_del_details_tbl,
2105: p_append_flag => p_append_flag,
2106: p_group_by_header => p_use_header_flag,
2107: p_commit => FND_API.G_FALSE,

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

2117: END IF;
2118: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR
2119: OR l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2120: x_return_status := l_return_status;
2121: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2122: IF l_debug_on THEN
2123: WSH_DEBUG_SV.pop(l_module_name);
2124: END IF;
2125: RETURN;

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

2206: --{
2207: -- deliveryMerge
2208: IF l_debug_on THEN
2209: WSH_DEBUG_SV.log(l_module_name,'det. tab count: '|| l_del_details_tbl.count);
2210: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2211: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2212: END IF;
2213:
2214: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

Line 2214: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(

2210: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries' ,WSH_DEBUG_SV.C_PROC_LEVEL);
2211: WSH_DEBUG_SV.log(l_module_name,'Current Time is ',SYSDATE);
2212: END IF;
2213:
2214: WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries(
2215: p_delivery_detail_tbl => l_del_details_tbl,
2216: p_append_flag => p_append_flag,
2217: p_group_by_header => p_use_header_flag,
2218: p_commit => FND_API.G_FALSE,

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

2231: IF l_return_status = WSH_UTIL_CORE.G_RET_STS_ERROR OR
2232: l_return_status = WSH_UTIL_CORE.G_RET_STS_UNEXP_ERROR THEN
2233: --{
2234: x_return_status := l_return_status;
2235: WSH_UTIL_CORE.PrintMsg('Error occurred in WSH_DELIVERY_DETAILS_UTILITIES.Append_to_Deliveries');
2236: IF l_debug_on THEN
2237: WSH_DEBUG_SV.pop(l_module_name);
2238: END IF;
2239: RETURN;