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.ISC_DBI_WSH_FTE_OBJECTS_C dependencies on OPI_DBI_REP_UOM_PKG

Line 153: g_reporting_weight_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('WT');

149:
150: FUNCTION get_reporting_uom RETURN NUMBER IS
151:
152: BEGIN
153: g_reporting_weight_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('WT');
154: IF (g_reporting_weight_uom IS NULL) THEN
155: g_retcode := 1;
156: g_errbuf := g_errbuf || 'DBI Weight Reporting UOM has not been set up.';
157: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 164: g_reporting_volume_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('VOL');

160: ELSE
161: BIS_COLLECTION_UTILITIES.put_line('The reporting weight uom is ' || g_reporting_weight_uom);
162: END IF;
163:
164: g_reporting_volume_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('VOL');
165: IF (g_reporting_volume_uom IS NULL) THEN
166: g_retcode := 1;
167: g_errbuf := g_errbuf || 'DBI Volume Reporting UOM has not been set up.';
168: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 175: g_reporting_distance_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('DIS');

171: ELSE
172: BIS_COLLECTION_UTILITIES.put_line('The reporting volume uom is ' || g_reporting_volume_uom);
173: END IF;
174:
175: g_reporting_distance_uom := opi_dbi_rep_uom_pkg.get_reporting_uom('DIS');
176: IF (g_reporting_distance_uom IS NULL) THEN
177: g_retcode := 1;
178: g_errbuf := g_errbuf || 'DBI Distance Reporting UOM has not been set up.';
179: BIS_COLLECTION_UTILITIES.put_line(' ');

Line 577: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))

573:
574: IF g_reporting_weight_uom IS NOT NULL THEN
575: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
576: SELECT 'WT', from_uom, g_reporting_weight_uom, NULL inventory_item_id,
577: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))
578: FROM (SELECT /*+ PARALLEL(tmp1) */ DISTINCT weight_uom_code FROM_UOM
579: FROM isc_dbi_tmp_del_legs tmp1
580: WHERE weight_uom_code is not null);
581: END IF;

Line 586: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))

582:
583: IF g_reporting_volume_uom IS NOT NULL THEN
584: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
585: SELECT 'VOL', from_uom, g_reporting_volume_uom, NULL inventory_item_id,
586: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))
587: FROM (SELECT /*+ PARALLEL(tmp2) */ DISTINCT volume_uom_code FROM_UOM
588: FROM isc_dbi_tmp_del_legs tmp2
589: WHERE volume_uom_code is not null);
590: END IF;

Line 595: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))

591:
592: IF g_reporting_distance_uom IS NOT NULL THEN
593: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
594: SELECT 'DIS', from_uom, g_reporting_distance_uom, NULL inventory_item_id,
595: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))
596: FROM (SELECT /*+ PARALLEL(tmp3) */ DISTINCT distance_uom_code FROM_UOM
597: FROM isc_dbi_tmp_trip_stops tmp3
598: where distance_uom_code is not null);
599: END IF;

Line 603: -- decode(from_uom, to_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, to_uom))

599: END IF;
600:
601: -- INSERT INTO isc_dbi_fte_uom_rates (FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
602: -- SELECT from_uom, to_uom, NULL inventory_item_id,
603: -- decode(from_uom, to_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, to_uom))
604: -- FROM (SELECT /*+ PARALLEL(tmp1) */ DISTINCT weight_uom_code FROM_UOM, 'WT' TO_UOM
605: -- FROM isc_dbi_tmp_del_legs tmp1
606: -- WHERE weight_uom_code is not null
607: -- UNION

Line 965: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))

961:
962: IF g_reporting_weight_uom IS NOT NULL THEN
963: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
964: SELECT 'WT', from_uom, g_reporting_weight_uom, NULL inventory_item_id,
965: decode(from_uom, g_reporting_weight_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_weight_uom))
966: FROM (SELECT DISTINCT weight_uom_code FROM_UOM
967: FROM isc_dbi_tmp_del_legs
968: WHERE weight_uom_code is not null);
969: END IF;

Line 974: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))

970:
971: IF g_reporting_volume_uom IS NOT NULL THEN
972: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
973: SELECT 'VOL', from_uom, g_reporting_volume_uom, NULL inventory_item_id,
974: decode(from_uom, g_reporting_volume_uom, 1, opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_volume_uom))
975: FROM (SELECT DISTINCT volume_uom_code FROM_UOM
976: FROM isc_dbi_tmp_del_legs
977: WHERE volume_uom_code is not null);
978: END IF;

Line 983: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))

979:
980: IF g_reporting_distance_uom IS NOT NULL THEN
981: INSERT INTO isc_dbi_fte_uom_rates (MEASURE_CODE, FROM_UOM_CODE, TO_UOM_CODE, INVENTORY_ITEM_ID, CONVERSION_RATE)
982: SELECT 'DIS', from_uom, g_reporting_distance_uom, NULL inventory_item_id,
983: decode(from_uom,g_reporting_distance_uom,1,opi_dbi_rep_uom_pkg.uom_convert(NULL, NULL, 1, from_uom, g_reporting_distance_uom))
984: FROM (SELECT DISTINCT distance_uom_code FROM_UOM
985: FROM isc_dbi_tmp_trip_stops
986: where distance_uom_code is not null);
987: END IF;

Line 1772: OPI_DBI_REP_UOM_PKG.err_msg_header;

1768: IF Missing_UOM_Conversion%ROWCOUNT <> 0 THEN
1769: BIS_COLLECTION_UTILITIES.Put_Line('Collection failed because there are missing UOM conversion rates.');
1770: BIS_COLLECTION_UTILITIES.Put_Line(fnd_message.get_string('BIS', 'BIS_DBI_UOM_NO_LOAD'));
1771:
1772: OPI_DBI_REP_UOM_PKG.err_msg_header;
1773: WHILE Missing_UOM_Conversion%FOUND LOOP
1774: l_total := l_total + 1;
1775:
1776: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms(

Line 1776: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms(

1772: OPI_DBI_REP_UOM_PKG.err_msg_header;
1773: WHILE Missing_UOM_Conversion%FOUND LOOP
1774: l_total := l_total + 1;
1775:
1776: OPI_DBI_REP_UOM_PKG.err_msg_missing_uoms(
1777: nvl(l_record.from_unit,' '),
1778: nvl(l_record.to_unit,' '));
1779:
1780: FETCH Missing_UOM_Conversion INTO l_record;

Line 1782: OPI_DBI_REP_UOM_PKG.Err_Msg_Footer;

1778: nvl(l_record.to_unit,' '));
1779:
1780: FETCH Missing_UOM_Conversion INTO l_record;
1781: END LOOP;
1782: OPI_DBI_REP_UOM_PKG.Err_Msg_Footer;
1783:
1784: ELSE -- Missing_UOM_Conversion%ROWCOUNT = 0
1785: BIS_COLLECTION_UTILITIES.Put_Line(' ');
1786: BIS_COLLECTION_UTILITIES.Put_Line(' THERE IS NO MISSING UOM CONVERSION RATE ');