APPS.WSH_RCV_CORR_RTV_TXN_PKG dependencies on WSH_WV_UTILS

Line 712: -- correction, we call WSH_WV_UTILS.Detail_Weight_Volume

708: -- becomes null or zero), then we call
709: -- WSH_DELIVERY_DETAILS_ACTIONS.Unassign_Multiple_Details
710: -- to unassign those lines from the delivery.
711: -- 5. If there were any lines for which there was a receipt
712: -- correction, we call WSH_WV_UTILS.Detail_Weight_Volume
713: -- to re-calculate the wt-vol of the lines.
714: -- 6. Similary if there were any lines for which there was a
715: -- receipt correction, then we get the corresponding deliveries
716: -- and then call the APIs

Line 1272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1268: --
1269: -- Debug Statements
1270: --
1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1273: END IF;
1274: --
1275: WSH_WV_UTILS.Detail_Weight_Volume(
1276: p_detail_rows => l_wv_detail_tab,

Line 1275: WSH_WV_UTILS.Detail_Weight_Volume(

1271: IF l_debug_on THEN
1272: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1273: END IF;
1274: --
1275: WSH_WV_UTILS.Detail_Weight_Volume(
1276: p_detail_rows => l_wv_detail_tab,
1277: p_override_flag => 'Y',
1278: p_calc_wv_if_frozen => 'N',
1279: x_return_status => l_return_status);

Line 1301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1297: --
1298: -- Debug Statements
1299: --
1300: IF l_debug_on THEN
1301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1302: END IF;
1303: --
1304: WSH_WV_UTILS.Delivery_Weight_Volume(
1305: p_del_rows => l_wv_recalc_del_id_tab,

Line 1304: WSH_WV_UTILS.Delivery_Weight_Volume(

1300: IF l_debug_on THEN
1301: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1302: END IF;
1303: --
1304: WSH_WV_UTILS.Delivery_Weight_Volume(
1305: p_del_rows => l_wv_recalc_del_id_tab,
1306: p_update_flag => 'Y',
1307: p_calc_wv_if_frozen => 'N',
1308: x_return_status => l_return_status);

Line 1334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

1330: --
1331: -- Debug Statements
1332: --
1333: IF l_debug_on THEN
1334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1335: END IF;
1336: --
1337: WSH_WV_UTILS.Delivery_Weight_Volume(
1338: p_del_rows => l_delivery_id_tab,

Line 1337: WSH_WV_UTILS.Delivery_Weight_Volume(

1333: IF l_debug_on THEN
1334: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
1335: END IF;
1336: --
1337: WSH_WV_UTILS.Delivery_Weight_Volume(
1338: p_del_rows => l_delivery_id_tab,
1339: p_update_flag => 'Y',
1340: p_calc_wv_if_frozen => 'N',
1341: x_return_status => l_return_status);

Line 2026: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

2022: -- Debug Statements
2023: --
2024: IF l_debug_on THEN
2025: WSH_DEBUG_SV.log(l_module_name,'Need to recalculate weight and volume for del detail --- ',l_update_del_det_id);
2026: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2027: END IF;
2028: --
2029: WSH_WV_UTILS.Detail_Weight_Volume(
2030: p_detail_rows => l_update_del_det_id_tab,

Line 2029: WSH_WV_UTILS.Detail_Weight_Volume(

2025: WSH_DEBUG_SV.log(l_module_name,'Need to recalculate weight and volume for del detail --- ',l_update_del_det_id);
2026: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2027: END IF;
2028: --
2029: WSH_WV_UTILS.Detail_Weight_Volume(
2030: p_detail_rows => l_update_del_det_id_tab,
2031: p_override_flag => 'Y',
2032: p_calc_wv_if_frozen => 'N',
2033: x_return_status => l_return_status);

Line 2072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);

2068: l_update_rec.record_changed_flag_tab;
2069: close l_rem_ret_qty_csr;
2070: IF l_debug_on THEN
2071: WSH_DEBUG_SV.log(l_module_name,'Need to recalculate weight and volume for del detail --- ',l_update_del_det_id);
2072: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DETAIL_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
2073: END IF;
2074: -- This loop is exact repetition (except for the deletes) of the above loop
2075: -- but since this is just to take care of a corner
2076: -- case, we are repeating the code.