DBA Data[Home] [Help]

APPS.WSH_TRIPS_ACTIONS dependencies on WSH_WV_UTILS

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

5332: IF (l_vehicle_item_id IS NOT NULL) AND (l_vehicle_org_id IS NOT NULL) THEN
5333:
5334: IF (l_fill_basis = 'W') AND (l_trip_max_weight IS NOT NULL) AND (l_trip_weight_uom IS NOT NULL) THEN
5335: IF l_debug_on THEN
5336: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5337: END IF;
5338: --
5339: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
5340: IF (l_wt_vol_tmp > 0) THEN

Line 5339: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);

5335: IF l_debug_on THEN
5336: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5337: END IF;
5338: --
5339: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
5340: IF (l_wt_vol_tmp > 0) THEN
5341: x_stop_fill_percent := round( 100 * p_gross_weight / l_wt_vol_tmp);
5342: END IF;
5343: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN

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

5342: END IF;
5343: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN
5344:
5345: IF l_debug_on THEN
5346: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5347: END IF;
5348: --
5349: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
5350: IF (l_wt_vol_tmp > 0) THEN

Line 5349: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);

5345: IF l_debug_on THEN
5346: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5347: END IF;
5348: --
5349: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
5350: IF (l_wt_vol_tmp > 0) THEN
5351: x_stop_fill_percent := round( 100 * p_volume / l_wt_vol_tmp );
5352: END IF;
5353: ELSE

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

5806: --
5807: -- Debug Statements
5808: --
5809: IF l_debug_on THEN
5810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5811: END IF;
5812: --
5813: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);
5814: --

Line 5813: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);

5809: IF l_debug_on THEN
5810: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5811: END IF;
5812: --
5813: l_total_net_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_net_weight);
5814: --
5815: -- Debug Statements
5816: --
5817: IF l_debug_on THEN

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

5814: --
5815: -- Debug Statements
5816: --
5817: IF l_debug_on THEN
5818: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5819: END IF;
5820: --
5821: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);
5822: --

Line 5821: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);

5817: IF l_debug_on THEN
5818: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5819: END IF;
5820: --
5821: l_total_gross_weight := wsh_wv_utils.convert_uom(l_prev_wt_uom, l_stop_wt_uom, l_total_gross_weight);
5822: --
5823: -- Debug Statements
5824: --
5825: IF l_debug_on THEN

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

5822: --
5823: -- Debug Statements
5824: --
5825: IF l_debug_on THEN
5826: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5827: END IF;
5828: --
5829: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);
5830:

Line 5829: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);

5825: IF l_debug_on THEN
5826: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5827: END IF;
5828: --
5829: l_volume := wsh_wv_utils.convert_uom(l_prev_vol_uom, l_stop_vol_uom, l_total_volume);
5830:
5831: g_return_status := WSH_UTIL_CORE.G_RET_STS_SUCCESS;
5832:
5833: IF l_debug_on THEN

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

5840: --
5841: -- Debug Statements
5842: --
5843: IF l_debug_on THEN
5844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5845: END IF;
5846: --
5847: wsh_wv_utils.delivery_weight_volume(
5848: p_delivery_id => pkup_dl.d_id,

Line 5847: wsh_wv_utils.delivery_weight_volume(

5843: IF l_debug_on THEN
5844: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DELIVERY_WEIGHT_VOLUME',WSH_DEBUG_SV.C_PROC_LEVEL);
5845: END IF;
5846: --
5847: wsh_wv_utils.delivery_weight_volume(
5848: p_delivery_id => pkup_dl.d_id,
5849: p_update_flag => 'Y',
5850: p_calc_wv_if_frozen => p_calc_wv_if_frozen,
5851: x_gross_weight => l_gross_weight,

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

5888: -- J: W/V Changes
5889: IF l_net_weight >= 0 THEN
5890: IF pkup_dl.wt_uom <> l_stop_wt_uom THEN
5891: IF l_debug_on THEN
5892: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5893: END IF;
5894: --
5895: IF l_net_weight > 0
5896: THEN

Line 5897: l_total_net_weight := l_total_net_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_net_weight);

5893: END IF;
5894: --
5895: IF l_net_weight > 0
5896: THEN
5897: l_total_net_weight := l_total_net_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_net_weight);
5898: ELSE
5899: l_total_net_weight := l_total_net_weight + l_net_weight;
5900: END IF;
5901: ELSE

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

5905:
5906: IF l_gross_weight >= 0 THEN
5907: IF pkup_dl.wt_uom <> l_stop_wt_uom THEN
5908: IF l_debug_on THEN
5909: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5910: END IF;
5911: --
5912: IF l_gross_weight > 0
5913: THEN

Line 5914: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);

5910: END IF;
5911: --
5912: IF l_gross_weight > 0
5913: THEN
5914: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5915: --R12 MDC
5916: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5917: ELSE
5918: l_total_gross_weight := l_total_gross_weight + l_gross_weight;

Line 5916: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);

5912: IF l_gross_weight > 0
5913: THEN
5914: l_total_gross_weight := l_total_gross_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5915: --R12 MDC
5916: l_total_pick_up_weight := l_total_pick_up_weight + wsh_wv_utils.convert_uom(pkup_dl.wt_uom, l_stop_wt_uom, l_gross_weight);
5917: ELSE
5918: l_total_gross_weight := l_total_gross_weight + l_gross_weight;
5919: --R12 MDC
5920: l_total_pick_up_weight := l_total_pick_up_weight + l_gross_weight;

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

5928:
5929: IF l_volume >= 0 THEN
5930: IF pkup_dl.vol_uom <> l_stop_vol_uom THEN
5931: IF l_debug_on THEN
5932: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5933: END IF;
5934: --
5935: IF l_volume > 0
5936: THEN

Line 5937: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);

5933: END IF;
5934: --
5935: IF l_volume > 0
5936: THEN
5937: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5938: --R12 MDC
5939: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5940: ELSE
5941: l_total_volume := l_total_volume + l_volume;

Line 5939: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);

5935: IF l_volume > 0
5936: THEN
5937: l_total_volume := l_total_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5938: --R12 MDC
5939: l_total_pick_up_volume := l_total_pick_up_volume + wsh_wv_utils.convert_uom(pkup_dl.vol_uom, l_stop_vol_uom, l_volume);
5940: ELSE
5941: l_total_volume := l_total_volume + l_volume;
5942: --R12 MDC
5943: l_total_pick_up_volume := l_total_pick_up_volume + l_volume;

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

5974: -- J: W/V Changes
5975: IF pickup_del_tab(dpoff_dl.d_id).net_weight > 0 THEN
5976: IF pickup_del_tab(dpoff_dl.d_id).wt_uom <> l_stop_wt_uom THEN
5977: IF l_debug_on THEN
5978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5979: END IF;
5980: --
5981: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom , pickup_del_tab(dpoff_dl.d_id).net_weight);
5982: ELSE

Line 5981: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom , pickup_del_tab(dpoff_dl.d_id).net_weight);

5977: IF l_debug_on THEN
5978: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5979: END IF;
5980: --
5981: l_total_net_weight := l_total_net_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom , pickup_del_tab(dpoff_dl.d_id).net_weight);
5982: ELSE
5983: l_total_net_weight := l_total_net_weight - pickup_del_tab(dpoff_dl.d_id).net_weight;
5984: END IF;
5985: END IF;

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

5987:
5988: IF pickup_del_tab(dpoff_dl.d_id).gross_weight > 0 THEN
5989: IF pickup_del_tab(dpoff_dl.d_id).wt_uom <> l_stop_wt_uom THEN
5990: IF l_debug_on THEN
5991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5992: END IF;
5993: --
5994: IF l_stop_id <> l_last_stop_id THEN
5995: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);

Line 5995: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);

5991: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
5992: END IF;
5993: --
5994: IF l_stop_id <> l_last_stop_id THEN
5995: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);
5996: END IF;
5997: --R12 MDC
5998: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);
5999: ELSE

Line 5998: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);

5994: IF l_stop_id <> l_last_stop_id THEN
5995: l_total_gross_weight := l_total_gross_weight - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);
5996: END IF;
5997: --R12 MDC
5998: l_total_drop_off_weight := l_total_drop_off_weight + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).wt_uom, l_stop_wt_uom, pickup_del_tab(dpoff_dl.d_id).gross_weight);
5999: ELSE
6000: IF l_stop_id <> l_last_stop_id THEN
6001: l_total_gross_weight := l_total_gross_weight - pickup_del_tab(dpoff_dl.d_id).gross_weight;
6002: END IF;

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

6007:
6008: IF pickup_del_tab(dpoff_dl.d_id).volume > 0 THEN
6009: IF pickup_del_tab(dpoff_dl.d_id).vol_uom <> l_stop_vol_uom THEN
6010: IF l_debug_on THEN
6011: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6012: END IF;
6013: --
6014: IF l_stop_id <> l_last_stop_id THEN
6015: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);

Line 6015: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);

6011: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6012: END IF;
6013: --
6014: IF l_stop_id <> l_last_stop_id THEN
6015: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);
6016: END IF;
6017: --R12 MDC
6018: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);
6019: ELSE

Line 6018: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);

6014: IF l_stop_id <> l_last_stop_id THEN
6015: l_total_volume := l_total_volume - wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);
6016: END IF;
6017: --R12 MDC
6018: l_total_drop_off_volume := l_total_drop_off_volume + wsh_wv_utils.convert_uom(pickup_del_tab(dpoff_dl.d_id).vol_uom, l_stop_vol_uom, pickup_del_tab(dpoff_dl.d_id).volume);
6019: ELSE
6020: IF l_stop_id <> l_last_stop_id THEN
6021: l_total_volume := l_total_volume - pickup_del_tab(dpoff_dl.d_id).volume;
6022: END IF;

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

6045: --
6046: -- Debug Statements
6047: --
6048: IF l_debug_on THEN
6049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6050: END IF;
6051: --
6052: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
6053: IF (l_wt_vol_tmp > 0) THEN

Line 6052: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);

6048: IF l_debug_on THEN
6049: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6050: END IF;
6051: --
6052: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_weight_uom, l_stop_wt_uom, l_trip_max_weight);
6053: IF (l_wt_vol_tmp > 0) THEN
6054: l_stop_fill_percent := round( 100 * l_total_gross_weight / l_wt_vol_tmp);
6055: END IF;
6056: ELSIF (l_fill_basis = 'V') AND (l_trip_max_volume IS NOT NULL) AND (l_trip_volume_uom IS NOT NULL) THEN

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

6058: --
6059: -- Debug Statements
6060: --
6061: IF l_debug_on THEN
6062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6063: END IF;
6064: --
6065: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
6066: IF (l_wt_vol_tmp > 0) THEN

Line 6065: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);

6061: IF l_debug_on THEN
6062: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.CONVERT_UOM',WSH_DEBUG_SV.C_PROC_LEVEL);
6063: END IF;
6064: --
6065: l_wt_vol_tmp := wsh_wv_utils.convert_uom(l_trip_volume_uom, l_stop_vol_uom, l_trip_max_volume);
6066: IF (l_wt_vol_tmp > 0) THEN
6067: l_stop_fill_percent := round( 100 * l_total_volume / l_wt_vol_tmp );
6068: END IF;
6069: ELSE

Line 8349: l_pickup_weight_convert := WSH_WV_UTILS.Convert_Uom(

8345:
8346: IF nvl(l_cs_tripstops_tab(j).PICK_UP_WEIGHT,0) <> 0 THEN
8347:
8348: IF l_cs_tripstops_tab(j).weight_uom_code <> l_base_weight_uom THEN
8349: l_pickup_weight_convert := WSH_WV_UTILS.Convert_Uom(
8350: from_uom => l_cs_tripstops_tab(j).weight_uom_code,
8351: to_uom => l_base_weight_uom,
8352: quantity => l_cs_tripstops_tab(j).PICK_UP_WEIGHT);
8353: ELSE

Line 8362: l_pickup_volume_convert := WSH_WV_UTILS.Convert_Uom(

8358:
8359: IF nvl(l_cs_tripstops_tab(j).PICK_UP_volume,0) <> 0 THEN
8360:
8361: IF l_cs_tripstops_tab(j).volume_uom_code <> l_base_volume_uom THEN
8362: l_pickup_volume_convert := WSH_WV_UTILS.Convert_Uom(
8363: from_uom => l_cs_tripstops_tab(j).volume_uom_code,
8364: to_uom => l_base_volume_uom,
8365: quantity => l_cs_tripstops_tab(j).PICK_UP_volume);
8366: ELSE