eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.FTE_FREIGHT_PRICING_SPECIAL dependencies on WSH_WV_UTILS

Line 704: l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.wdd_weight_uom_code,

700: l_target_uom := p_target_uom;
701:
702: IF (p_top_level_rec.container_flag = 'N') THEN
703: IF (l_target_uom IS NOT NULL) THEN
704: l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.wdd_weight_uom_code,
705: l_target_uom,
706: p_top_level_rec.wdd_gross_weight,
707: 0); -- Within same UOM class
708: --l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,

Line 708: --l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,

704: l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.wdd_weight_uom_code,
705: l_target_uom,
706: p_top_level_rec.wdd_gross_weight,
707: 0); -- Within same UOM class
708: --l_temp_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,
709: -- l_target_uom,
710: -- p_top_level_rec.gross_weight,
711: -- 0); -- Within same UOM class
712: l_temp_uom := l_target_uom;

Line 736: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,

732: l_target_uom := FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom;
733: END IF;
734:
735: IF (FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom <> l_target_uom ) THEN
736: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,
737: l_target_uom,
738: FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_quantity,
739: 0); -- Within same UOM class
740: ELSE

Line 761: l_temp_tare_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,

757: --l_gross_wt := fte_freight_pricing.g_shipment_line_rows(p_top_level_rec.content_id).gross_weight;
758: --l_gross_wt_uom := fte_freight_pricing.g_shipment_line_rows(p_top_level_rec.content_id).weight_uom_code;
759:
760: IF ( l_temp_uom <> p_top_level_rec.weight_uom ) THEN
761: l_temp_tare_wt := WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,
762: l_temp_uom,
763: p_top_level_rec.gross_weight,
764: 0); -- Within same UOM class
765: ELSE

Line 771: x_gross_wt := WSH_WV_UTILS.convert_uom(l_gross_wt_uom,

767: END IF;
768:
769: IF (l_gross_wt IS NOT NULL) THEN
770: IF (l_gross_wt_uom <> l_temp_uom) THEN
771: x_gross_wt := WSH_WV_UTILS.convert_uom(l_gross_wt_uom,
772: l_temp_uom,
773: l_gross_wt,
774: 0); -- Within same UOM class
775: ELSE

Line 783: x_gross_wt := l_temp_wt + WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,

779: ELSE
780:
781: /*
782: IF ( l_temp_uom <> p_top_level_rec.weight_uom ) THEN
783: x_gross_wt := l_temp_wt + WSH_WV_UTILS.convert_uom( p_top_level_rec.weight_uom,
784: l_temp_uom,
785: p_top_level_rec.gross_weight,
786: 0); -- Within same UOM class
787: ELSE

Line 1046: converted_vol := WSH_WV_UTILS.convert_uom(p_top_level_rec.volume_uom,

1042: fte_freight_pricing_util.print_msg(l_log_level,'use volume');
1043: -- Use volume
1044: IF (p_top_level_rec.volume_uom <> min_vol_uom ) THEN
1045: --convert input vol uom to param vol uom
1046: converted_vol := WSH_WV_UTILS.convert_uom(p_top_level_rec.volume_uom,
1047: min_vol_uom,
1048: p_top_level_rec.volume,
1049: 0); -- Within same UOM class
1050: ELSE

Line 1059: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1055: fte_freight_pricing_util.print_msg(l_log_level,'use L*W*H');
1056: -- use L*W*H
1057: IF (p_top_level_rec.dim_uom <> dim_uom_param ) THEN
1058: --convert input wt uom to param wt uom
1059: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1060: dim_uom_param,
1061: nvl(p_top_level_rec.length,0),
1062: 0); -- Within same UOM class
1063: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

Line 1063: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1059: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1060: dim_uom_param,
1061: nvl(p_top_level_rec.length,0),
1062: 0); -- Within same UOM class
1063: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1064: dim_uom_param,
1065: nvl(p_top_level_rec.width,0),
1066: 0); -- Within same UOM class
1067:

Line 1068: converted_height := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1064: dim_uom_param,
1065: nvl(p_top_level_rec.width,0),
1066: 0); -- Within same UOM class
1067:
1068: converted_height := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1069: dim_uom_param,
1070: nvl(p_top_level_rec.height,0),
1071: 0); -- Within same UOM class
1072: ELSE

Line 1084: converted_vol := WSH_WV_UTILS.convert_uom(vol_uom_param,

1080: -- The assumption here is that dim_uom and vol_uom parameter for dim_wt are in synch.
1081:
1082: IF ( vol_uom_param <> min_vol_uom ) THEN
1083: --convert input vol uom to param vol uom
1084: converted_vol := WSH_WV_UTILS.convert_uom(vol_uom_param,
1085: min_vol_uom,
1086: l_cont_volume,
1087: --converted_length*converted_width*converted_height,
1088: 0); -- Within same UOM class

Line 1133: converted_vol := WSH_WV_UTILS.convert_uom(p_top_level_rec.volume_uom,

1129: IF (p_top_level_rec.volume IS NOT NULL) THEN
1130: -- Use volume
1131: IF (p_top_level_rec.volume_uom <> vol_uom_param ) THEN
1132: --convert input vol uom to param vol uom
1133: converted_vol := WSH_WV_UTILS.convert_uom(p_top_level_rec.volume_uom,
1134: vol_uom_param,
1135: p_top_level_rec.volume,
1136: 0); -- Within same UOM class
1137: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'converted_vol = '||converted_vol);

Line 1152: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1148: ELSIF (p_top_level_rec.length IS NOT NULL AND p_top_level_rec.width IS NOT NULL AND p_top_level_rec.height IS NOT NULL) THEN
1149: -- use L*W*H
1150: IF (p_top_level_rec.dim_uom <> dim_uom_param ) THEN
1151: --convert input wt uom to param wt uom
1152: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1153: dim_uom_param,
1154: nvl(p_top_level_rec.length,0),
1155: 0); -- Within same UOM class
1156: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

Line 1156: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1152: converted_length := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1153: dim_uom_param,
1154: nvl(p_top_level_rec.length,0),
1155: 0); -- Within same UOM class
1156: converted_width := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1157: dim_uom_param,
1158: nvl(p_top_level_rec.width,0),
1159: 0); -- Within same UOM class
1160:

Line 1161: converted_height := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,

1157: dim_uom_param,
1158: nvl(p_top_level_rec.width,0),
1159: 0); -- Within same UOM class
1160:
1161: converted_height := WSH_WV_UTILS.convert_uom(p_top_level_rec.dim_uom,
1162: dim_uom_param,
1163: nvl(p_top_level_rec.height,0),
1164: 0); -- Within same UOM class
1165:

Line 1459: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(p_top_level_rows(i).weight_uom,

1455: l_target_uom := p_top_level_rows(i).weight_uom;
1456: END IF;
1457:
1458: IF (p_top_level_rows(i).weight_uom <> l_target_uom) THEN
1459: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(p_top_level_rows(i).weight_uom,
1460: l_target_uom,
1461: p_top_level_rows(i).gross_weight,
1462: 0); -- Within same UOM class
1463: ELSE

Line 1484: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,

1480: l_target_uom := FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom;
1481: END IF;
1482:
1483: IF (FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom <> l_target_uom ) THEN
1484: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,
1485: l_target_uom,
1486: FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_quantity,
1487: 0); -- Within same UOM class
1488: ELSE

Line 1588: l_new_wt := p_orig_wt + WSH_WV_UTILS.convert_uom(p_add_uom, --from

1584: IF (p_orig_uom = p_add_uom) THEN
1585: l_new_wt := p_orig_wt + p_add_wt;
1586: l_new_uom := p_orig_uom;
1587: ELSE
1588: l_new_wt := p_orig_wt + WSH_WV_UTILS.convert_uom(p_add_uom, --from
1589: p_orig_uom, --to
1590: p_add_wt,
1591: 0); -- Within same UOM class
1592: l_new_uom := p_orig_uom;

Line 1596: x_new_wt := WSH_WV_UTILS.convert_uom(l_new_uom, --from

1592: l_new_uom := p_orig_uom;
1593: END IF;
1594:
1595: IF (p_target_uom IS NOT NULL AND p_target_uom <> l_new_uom) THEN
1596: x_new_wt := WSH_WV_UTILS.convert_uom(l_new_uom, --from
1597: p_target_uom, --to
1598: l_new_wt,
1599: 0); -- Within same UOM class
1600: x_new_uom := p_target_uom;

Line 1626: l_new_wt_2 := WSH_WV_UTILS.convert_uom(p_uom_2,

1622: IF (p_uom_1 = p_uom_2) THEN
1623: x_wt := GREATEST(p_wt_1,p_wt_2);
1624: x_uom := p_uom_1;
1625: ELSE
1626: l_new_wt_2 := WSH_WV_UTILS.convert_uom(p_uom_2,
1627: p_uom_1,
1628: p_wt_2,
1629: 0); -- Within same UOM class
1630: IF (p_wt_1 >= l_new_wt_2 ) THEN

Line 1641: x_wt := WSH_WV_UTILS.convert_uom(x_uom,

1637:
1638: END IF;
1639:
1640: IF (p_target_uom IS NOT NULL AND p_target_uom <> x_uom) THEN
1641: x_wt := WSH_WV_UTILS.convert_uom(x_uom,
1642: p_target_uom,
1643: x_wt,
1644: 0); -- Within same UOM class
1645: x_uom := p_target_uom;

Line 1678: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,

1674: l_target_uom := FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom;
1675: END IF;
1676:
1677: IF (FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom <> l_target_uom ) THEN
1678: l_temp_wt := l_temp_wt + WSH_WV_UTILS.convert_uom(FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_uom,
1679: l_target_uom,
1680: FTE_FREIGHT_PRICING.g_rolledup_lines(j).line_quantity,
1681: 0); -- Within same UOM class
1682: ELSE

Line 1749: l_curr_wt := WSH_WV_UTILS.convert_uom(p_top_level_rows(i).weight_uom,

1745: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'l_content_id = '||l_content_id);
1746:
1747: IF (p_top_level_rows(i).container_flag = 'N') THEN
1748: IF (l_cum_uom <> p_top_level_rows(i).weight_uom ) THEN
1749: l_curr_wt := WSH_WV_UTILS.convert_uom(p_top_level_rows(i).weight_uom,
1750: l_cum_uom,
1751: p_top_level_rows(i).gross_weight,
1752: 0); -- Within same UOM class
1753: l_curr_uom := l_cum_uom;

Line 1884: l_temp_min_wt := WSH_WV_UTILS.convert_uom(p_min_wt_uom,

1880: END IF;
1881:
1882: if (p_wt_uom <> p_min_wt_uom) THEN
1883: --convert min wt uom to current uom
1884: l_temp_min_wt := WSH_WV_UTILS.convert_uom(p_min_wt_uom,
1885: p_wt_uom,
1886: p_min_package_wt,
1887: 0); -- Within same UOM class
1888: l_temp_min_uom := p_wt_uom;

Line 1968: WSH_WV_UTILS.convert_uom(g_lane_parameters(i).uom_code,

1964: raise fte_freight_pricing_util.g_invalid_uom_conversion;
1965: END IF;
1966:
1967: /*
1968: WSH_WV_UTILS.convert_uom(g_lane_parameters(i).uom_code,
1969: p_total_wt_uom,
1970: g_lane_parameters(i).value_from,
1971: 0); -- Within same UOM class
1972: */

Line 2355: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,

2351: l_attr_rec.input_index := p_pricing_engine_rows(i).input_index;
2352: l_attr_rec.attribute_name := 'TOTAL_ITEM_QUANTITY';
2353:
2354: IF (p_pricing_engine_rows(i).line_uom <> l_total_wt_uom ) THEN
2355: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,
2356: p_pricing_engine_rows(i).line_uom,
2357: l_total_wt,
2358: 0); -- Within same UOM class
2359: l_attr_rec.attribute_value := to_char(l_temp_wt);

Line 2522: l_temp_wt := WSH_WV_UTILS.convert_uom(l_next_weight_break_uom,

2518: l_attr_rec.input_index := l_new_index;
2519: l_attr_rec.attribute_name := 'TOTAL_ITEM_QUANTITY';
2520:
2521: IF (p_pricing_engine_rows(i).line_uom <> l_next_weight_break_uom ) THEN
2522: l_temp_wt := WSH_WV_UTILS.convert_uom(l_next_weight_break_uom,
2523: p_pricing_engine_rows(i).line_uom,
2524: l_next_weight_break,
2525: 0); -- Within same UOM class
2526: l_attr_rec.attribute_value := to_char(l_temp_wt);

Line 2741: l_converted_def_wt := WSH_WV_UTILS.convert_uom(l_deficit_wt_uom,

2737: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'lowest priced uom : '||l_lowest_up_priced_uom);
2738: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'lowest priced qty : '||l_lowest_up_tot_qty);
2739:
2740: IF l_deficit_wt_uom <> l_lowest_up_priced_uom THEN
2741: l_converted_def_wt := WSH_WV_UTILS.convert_uom(l_deficit_wt_uom,
2742: l_lowest_up_priced_uom,
2743: l_deficit_wt,
2744: 0); -- Within same UOM class
2745: fte_freight_pricing_util.print_msg(fte_freight_pricing_util.G_DBG,'converted def wt : '||l_converted_def_wt);

Line 3148: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,

3144: l_attr_rec.input_index := p_pricing_engine_rows(i).input_index;
3145: l_attr_rec.attribute_name := 'TOTAL_ITEM_QUANTITY';
3146:
3147: IF (p_pricing_engine_rows(i).line_uom <> l_total_wt_uom ) THEN
3148: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,
3149: p_pricing_engine_rows(i).line_uom,
3150: l_total_wt,
3151: 0); -- Within same UOM class
3152: l_attr_rec.attribute_value := to_char(l_temp_wt);

Line 3356: l_temp_qty := WSH_WV_UTILS.convert_uom(p_new_uom,

3352: -- only get rollup lines which match category and basis on engine row
3353: -- bump up each rolledup row
3354:
3355: IF (p_new_uom <> p_orig_uom) THEN
3356: l_temp_qty := WSH_WV_UTILS.convert_uom(p_new_uom,
3357: p_orig_uom,
3358: p_new_line_qty,
3359: 0); -- Within same UOM class
3360:

Line 3771: l_temp_wt := WSH_WV_UTILS.convert_uom(l_bumped_up_wt_uom,

3767: l_total_wt_uom := l_bumped_up_wt_uom;
3768: ELSE
3769:
3770: IF (l_bumped_up_wt_uom <> l_total_wt_uom ) THEN
3771: l_temp_wt := WSH_WV_UTILS.convert_uom(l_bumped_up_wt_uom,
3772: l_total_wt_uom,
3773: l_bumped_up_wt,
3774: 0); -- Within same UOM class
3775: l_total_wt := l_total_wt + l_temp_wt;

Line 3890: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,

3886: l_attr_rec.input_index := l_new_index;
3887: l_attr_rec.attribute_name := 'TOTAL_ITEM_QUANTITY';
3888:
3889: IF (p_pricing_engine_rows(i).line_uom <> l_total_wt_uom ) THEN
3890: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,
3891: p_pricing_engine_rows(i).line_uom,
3892: l_total_wt,
3893: 0); -- Within same UOM class
3894: l_attr_rec.attribute_value := to_char(l_temp_wt);

Line 3974: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,

3970: l_attr_rec.input_index := p_pricing_engine_rows(i).input_index;
3971: l_attr_rec.attribute_name := 'TOTAL_ITEM_QUANTITY';
3972:
3973: IF (p_pricing_engine_rows(i).line_uom <> l_total_wt_uom ) THEN
3974: l_temp_wt := WSH_WV_UTILS.convert_uom(l_total_wt_uom,
3975: p_pricing_engine_rows(i).line_uom,
3976: l_total_wt,
3977: 0); -- Within same UOM class
3978: l_attr_rec.attribute_value := to_char(l_temp_wt);

Line 5263: l_tmp := WSH_WV_UTILS.convert_uom(

5259:
5260: IF x_weight_uom = p_top_level_rows(i).wdd_weight_uom_code THEN
5261: x_total_container_weight := x_total_container_weight + p_top_level_rows(i).wdd_tare_weight;
5262: ELSE
5263: l_tmp := WSH_WV_UTILS.convert_uom(
5264: p_top_level_rows(i).wdd_weight_uom_code,
5265: x_weight_uom,
5266: p_top_level_rows(i).wdd_tare_weight,
5267: NULL,0);

Line 5269: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');

5265: x_weight_uom,
5266: p_top_level_rows(i).wdd_tare_weight,
5267: NULL,0);
5268: IF l_tmp <= 0 THEN
5269: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');
5270: raise FND_API.G_EXC_ERROR;
5271: ELSE
5272: x_total_container_weight := x_total_container_weight + l_tmp;
5273: END IF;

Line 5422: l_lowest_fc_old_line_quantity := WSH_WV_UTILS.convert_uom(

5418:
5419: IF l_container_weight_uom = x_pricing_engine_rows(l_lowest_fc_input_index1).line_uom THEN
5420: l_lowest_fc_old_line_quantity := x_pricing_engine_rows(l_lowest_fc_input_index1).line_quantity;
5421: ELSE
5422: l_lowest_fc_old_line_quantity := WSH_WV_UTILS.convert_uom(
5423: x_pricing_engine_rows(l_lowest_fc_input_index1).line_uom,
5424: l_container_weight_uom,
5425: x_pricing_engine_rows(l_lowest_fc_input_index1).line_quantity,
5426: NULL,0);

Line 5435: + WSH_WV_UTILS.convert_uom(

5431: l_lowest_fc_old_line_quantity := l_lowest_fc_old_line_quantity
5432: + x_pricing_engine_rows(l_lowest_fc_input_index2).line_quantity;
5433: ELSE
5434: l_lowest_fc_old_line_quantity := l_lowest_fc_old_line_quantity
5435: + WSH_WV_UTILS.convert_uom(
5436: x_pricing_engine_rows(l_lowest_fc_input_index2).line_uom,
5437: l_container_weight_uom,
5438: x_pricing_engine_rows(l_lowest_fc_input_index2).line_quantity,
5439: NULL,0);

Line 5661: l_tmp := WSH_WV_UTILS.convert_uom(

5657: IF l_pricing_engine_rows(1).line_uom = FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_uom THEN
5658: l_pricing_engine_rows(1).line_quantity := l_pricing_engine_rows(1).line_quantity
5659: + FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity;
5660: ELSE
5661: l_tmp := WSH_WV_UTILS.convert_uom(
5662: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_uom,
5663: l_pricing_engine_rows(1).line_uom,
5664: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity,
5665: NULL,0);

Line 5667: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');

5663: l_pricing_engine_rows(1).line_uom,
5664: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity,
5665: NULL,0);
5666: IF l_tmp <= 0 THEN
5667: FTE_FREIGHT_PRICING_UTIL.print_msg(l_log_level,'WSH_WV_UTILS.convert_uom return 0');
5668: raise FND_API.G_EXC_ERROR;
5669: ELSE
5670: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_quantity := l_tmp;
5671: FTE_FREIGHT_PRICING.g_rolledup_lines(i).line_uom := l_pricing_engine_rows(1).line_uom;