DBA Data[Home] [Help]

APPS.WSH_NEW_DELIVERIES_PVT dependencies on WSH_WV_UTILS

Line 659: l_old_gross_wt := WSH_WV_UTILS.Convert_Uom(

655: END IF;
656:
657: IF l_weight_uom_code <> p_delivery_info.weight_uom_code THEN
658:
659: l_old_gross_wt := WSH_WV_UTILS.Convert_Uom(
660: from_uom => l_weight_uom_code,
661: to_uom => p_delivery_info.weight_uom_code,
662: quantity => l_gross_wt);
663:

Line 664: l_old_net_wt := WSH_WV_UTILS.Convert_Uom(

660: from_uom => l_weight_uom_code,
661: to_uom => p_delivery_info.weight_uom_code,
662: quantity => l_gross_wt);
663:
664: l_old_net_wt := WSH_WV_UTILS.Convert_Uom(
665: from_uom => l_weight_uom_code,
666: to_uom => p_delivery_info.weight_uom_code,
667: quantity => l_net_wt);
668: ELSE

Line 677: l_old_volume := WSH_WV_UTILS.Convert_Uom(

673: END IF;
674:
675: IF l_volume_uom_code <> p_delivery_info.volume_uom_code THEN
676:
677: l_old_volume := WSH_WV_UTILS.Convert_Uom(
678: from_uom => l_volume_uom_code,
679: to_uom => p_delivery_info.volume_uom_code,
680: quantity => l_volume);
681:

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

1063: -- If UOM changes then compute the delta (difference between new W/V and old W/V)
1064: IF ( NVL(l_weight_uom_code,'-99') <> NVL(p_delivery_info.weight_uom_code,'-99') AND
1065: l_gross_weight is not null ) THEN -- BugFix #4587421
1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(
1070: from_uom => p_delivery_info.weight_uom_code,
1071: to_uom => l_weight_uom_code,

Line 1069: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(

1065: l_gross_weight is not null ) THEN -- BugFix #4587421
1066: IF l_debug_on THEN
1067: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1068: END IF;
1069: l_diff_gross_wt := WSH_WV_UTILS.convert_uom(
1070: from_uom => p_delivery_info.weight_uom_code,
1071: to_uom => l_weight_uom_code,
1072: quantity => l_gross_weight) - NVL(l_gross_wt,0); -- BugFix #4587421
1073:

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

1071: to_uom => l_weight_uom_code,
1072: quantity => l_gross_weight) - NVL(l_gross_wt,0); -- BugFix #4587421
1073:
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: END IF;
1077: l_diff_net_wt := WSH_WV_UTILS.convert_uom(
1078: from_uom => p_delivery_info.weight_uom_code,
1079: to_uom => l_weight_uom_code,

Line 1077: l_diff_net_wt := WSH_WV_UTILS.convert_uom(

1073:
1074: IF l_debug_on THEN
1075: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1076: END IF;
1077: l_diff_net_wt := WSH_WV_UTILS.convert_uom(
1078: from_uom => p_delivery_info.weight_uom_code,
1079: to_uom => l_weight_uom_code,
1080: quantity => l_net_weight) - NVL(l_net_wt,0); -- BigFix #4587421
1081: ELSE

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

1085:
1086: IF (NVL(l_volume_uom_code,'-99') <> NVL(p_delivery_info.volume_uom_code,'-99') AND
1087: p_delivery_info.volume is not null) THEN
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1090: END IF;
1091: l_diff_vol := WSH_WV_UTILS.convert_uom(
1092: from_uom => p_delivery_info.volume_uom_code,
1093: to_uom => l_volume_uom_code,

Line 1091: l_diff_vol := WSH_WV_UTILS.convert_uom(

1087: p_delivery_info.volume is not null) THEN
1088: IF l_debug_on THEN
1089: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.convert_uom',WSH_DEBUG_SV.C_PROC_LEVEL);
1090: END IF;
1091: l_diff_vol := WSH_WV_UTILS.convert_uom(
1092: from_uom => p_delivery_info.volume_uom_code,
1093: to_uom => l_volume_uom_code,
1094: quantity => p_delivery_info.volume) - NVL(l_volume,0);
1095: ELSE

Line 1108: l_diff_gross_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,

1104: --
1105: IF (l_weight_uom_code<>p_delivery_info.weight_uom_code) THEN
1106:
1107: IF (l_diff_gross_wt IS NOT NULL) THEN
1108: l_diff_gross_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,
1109: to_uom =>p_delivery_info.weight_uom_code,
1110: quantity => l_diff_gross_wt);
1111: END IF;
1112:

Line 1114: l_diff_net_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,

1110: quantity => l_diff_gross_wt);
1111: END IF;
1112:
1113: IF (l_diff_net_wt IS NOT NULL) THEN
1114: l_diff_net_wt := WSH_WV_UTILS.convert_uom( from_uom => l_weight_uom_code,
1115: to_uom =>p_delivery_info.weight_uom_code,
1116: quantity => l_diff_net_wt);
1117: END IF;
1118: END IF;

Line 1121: l_diff_vol:= WSH_WV_UTILS.convert_uom( from_uom => l_volume_uom_code,

1117: END IF;
1118: END IF;
1119:
1120: IF (l_volume_uom_code<>p_delivery_info.volume_uom_code AND l_diff_vol IS NOT NULL) THEN
1121: l_diff_vol:= WSH_WV_UTILS.convert_uom( from_uom => l_volume_uom_code,
1122: to_uom => p_delivery_info.volume_uom_code,
1123: quantity => l_diff_vol);
1124:
1125: END IF;

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

1128: -- Bug No:4085560 - 11.5.10.1CU:INCORRECT WT SHOWN FOR THE STOP(end)
1129: --
1130:
1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DEL_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134:
1135: WSH_WV_UTILS.DEL_WV_Post_Process(
1136: p_delivery_id => p_delivery_info.delivery_id,

Line 1135: WSH_WV_UTILS.DEL_WV_Post_Process(

1131: IF l_debug_on THEN
1132: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.DEL_WV_Post_Process',WSH_DEBUG_SV.C_PROC_LEVEL);
1133: END IF;
1134:
1135: WSH_WV_UTILS.DEL_WV_Post_Process(
1136: p_delivery_id => p_delivery_info.delivery_id,
1137: p_diff_gross_wt => l_diff_gross_wt,
1138: p_diff_net_wt => l_diff_net_wt,
1139: p_diff_volume => l_diff_vol,

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

1152: IF NVL(p_delivery_info.delivery_type, 'STANDARD')='STANDARD' AND NVL(p_delivery_info.PRORATE_WT_FLAG,'N')='Y'
1153: AND (nvl(l_diff_gross_wt,0) <> 0 OR nvl(l_diff_net_wt,0) <> 0) THEN --{
1154: --
1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.prorate_weight',WSH_DEBUG_SV.C_PROC_LEVEL);
1157: END IF;
1158: --
1159: WSH_WV_UTILS.prorate_weight(
1160: p_entity_type => 'DELIVERY',

Line 1159: WSH_WV_UTILS.prorate_weight(

1155: IF l_debug_on THEN
1156: WSH_DEBUG_SV.logmsg(l_module_name,'Calling program unit WSH_WV_UTILS.prorate_weight',WSH_DEBUG_SV.C_PROC_LEVEL);
1157: END IF;
1158: --
1159: WSH_WV_UTILS.prorate_weight(
1160: p_entity_type => 'DELIVERY',
1161: p_entity_id => p_delivery_info.delivery_id,
1162: p_old_gross_wt => l_gross_wt,
1163: p_new_gross_wt => l_gross_weight, -- BigFix #4587421

Line 1172: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);

1168: IF l_return_status <> WSH_UTIL_CORE.G_RET_STS_SUCCESS THEN
1169: x_return_status := l_return_status;
1170: --
1171: IF l_debug_on THEN
1172: wsh_debug_sv.log(l_module_name,'Return Status After Calling WSH_WV_UTILS.prorate_weight',l_return_status);
1173: END IF;
1174: --
1175: wsh_util_core.api_post_call(
1176: p_return_status => l_return_status,