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.WSH_WV_PVT dependencies on WSH_WV_PVT

Line 1: PACKAGE BODY WSH_WV_PVT as

1: PACKAGE BODY WSH_WV_PVT as
2: /* $Header: WSHUTWVB.pls 115.10 99/07/16 08:24:16 porting ship $ */
3:
4: -- Name departure_weight_volume
5: -- Purpose Validates parameters and invokes dep_weight_volume

Line 72: WSH_WV_PVT.dep_weight_volume(

68: status := -1;
69: -- **Message: invalid parameter values
70: FND_MESSAGE.Set_Name('OE', 'WSH_WV_INVALID_VALUES');
71: ELSE
72: WSH_WV_PVT.dep_weight_volume(
73: source, departure_id, organization_id,
74: wv_flag, update_flag, menu_flag, dpw_pack_flag, x_sc_wv_mode,
75: master_weight_uom, net_weight, tare_weight,
76: master_volume_uom, volume,

Line 83: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(1)');

79:
80: EXCEPTION
81: WHEN OTHERS THEN
82: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
83: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(1)');
84: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
85: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
86: status := -1;
87: END departure_weight_volume;

Line 145: SELECT NVL(SUM( wsh_wv_pvt.convert_uom(msi.weight_uom_code, x_to_uom,

141: -- bug 650601 fix: this cursor added to calculate tare weight
142: -- which will be used to adjust departure's net weight.
143: CURSOR del_tare_weight(x_del_id NUMBER, x_o_id NUMBER,
144: x_to_uom VARCHAR2) IS
145: SELECT NVL(SUM( wsh_wv_pvt.convert_uom(msi.weight_uom_code, x_to_uom,
146: NVL(msi.unit_weight, 0))
147: * pc.quantity),
148: 0) tare_weight
149: FROM wsh_packed_containers pc,

Line 179: WSH_WV_PVT.del_autopack(d.delivery_id, organization_id, pack_status);

175: x_volume := 0;
176: x_gross_weight := 0;
177:
178: IF source = 'DPW' AND dpw_pack_flag = 'Y' THEN
179: WSH_WV_PVT.del_autopack(d.delivery_id, organization_id, pack_status);
180:
181: IF pack_status = 1 AND NOT overpack_warned THEN
182: overpack_warned := TRUE;
183: -- Set status to warning only if it was success

Line 211: WSH_WV_PVT.del_weight(source, d.delivery_id, organization_id,

207:
208: IF menu_flag = 'Y' THEN
209: -- Always recalculate
210:
211: WSH_WV_PVT.del_weight(source, d.delivery_id, organization_id,
212: menu_flag, x_sc_wv_mode,
213: master_weight_uom, x_gross_weight,
214: status);
215: net_weight := net_weight + x_gross_weight;

Line 217: WSH_WV_PVT.del_volume(source, d.delivery_id, organization_id,

213: master_weight_uom, x_gross_weight,
214: status);
215: net_weight := net_weight + x_gross_weight;
216:
217: WSH_WV_PVT.del_volume(source, d.delivery_id, organization_id,
218: x_sc_wv_mode,
219: master_volume_uom, x_volume,
220: status);
221: volume := volume + x_volume;

Line 226: WSH_WV_PVT.del_weight(source, d.delivery_id, organization_id,

222:
223: ELSIF wv_flag = 'ALWAYS' THEN
224:
225: IF d.gross_weight IS NULL THEN
226: WSH_WV_PVT.del_weight(source, d.delivery_id, organization_id,
227: menu_flag, x_sc_wv_mode,
228: master_weight_uom, x_gross_weight,
229: status);
230: net_weight := net_weight + x_gross_weight;

Line 232: net_weight := net_weight + WSH_WV_PVT.convert_uom(d.weight_uom_code,

228: master_weight_uom, x_gross_weight,
229: status);
230: net_weight := net_weight + x_gross_weight;
231: ELSE
232: net_weight := net_weight + WSH_WV_PVT.convert_uom(d.weight_uom_code,
233: master_weight_uom,
234: d.gross_weight);
235: END IF;
236:

Line 238: WSH_WV_PVT.del_volume(source, d.delivery_id, organization_id,

234: d.gross_weight);
235: END IF;
236:
237: IF d.volume IS NULL THEN
238: WSH_WV_PVT.del_volume(source, d.delivery_id, organization_id,
239: x_sc_wv_mode,
240: master_volume_uom, x_volume,
241: status);
242: volume := volume + x_volume;

Line 244: volume := volume + WSH_WV_PVT.convert_uom(d.volume_uom_code,

240: master_volume_uom, x_volume,
241: status);
242: volume := volume + x_volume;
243: ELSE
244: volume := volume + WSH_WV_PVT.convert_uom(d.volume_uom_code,
245: master_volume_uom,
246: d.volume);
247: END IF;
248: END IF;

Line 268: WSH_WV_PVT.dep_loose_weight_volume(

264: END LOOP;
265:
266: -- now add weight and volume of items loose in this departure
267:
268: WSH_WV_PVT.dep_loose_weight_volume(
269: source,
270: departure_id,
271: organization_id,
272: x_sc_wv_mode,

Line 290: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(2)');

286:
287: EXCEPTION
288: WHEN OTHERS THEN
289: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
290: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(2)');
291: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
292: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
293: IF delivery_recs%ISOPEN THEN
294: CLOSE delivery_recs;

Line 337: WSH_WV_PVT.convert_uom(sld.unit_code,

333: IS
334:
335: CURSOR dpw_loose_weight(x_dep_id NUMBER, x_o_id NUMBER) IS
336: SELECT SUM( NVL(msi.unit_weight, 0) *
337: WSH_WV_PVT.convert_uom(sld.unit_code,
338: msi.primary_uom_code,
339: sld.quantity,
340: sld.inventory_item_id) ) weight,
341: msi.weight_uom_code uom

Line 352: WSH_WV_PVT.convert_uom(sld.unit_code,

348: GROUP BY msi.weight_uom_code;
349:
350: CURSOR dpw_loose_volume(x_dep_id NUMBER, x_o_id NUMBER) IS
351: SELECT SUM( NVL(msi.unit_volume, 0) *
352: WSH_WV_PVT.convert_uom(sld.unit_code,
353: msi.primary_uom_code,
354: sld.quantity,
355: sld.inventory_item_id) ) volume,
356: msi.volume_uom_code uom

Line 368: WSH_WV_PVT.convert_uom(sl.unit_code,

364:
365:
366: CURSOR dpw_bo_loose_weight(x_dep_id NUMBER, x_o_id NUMBER) IS
367: SELECT SUM( NVL(msi.unit_weight, 0) *
368: WSH_WV_PVT.convert_uom(sl.unit_code,
369: msi.primary_uom_code,
370: sld.requested_quantity,
371: sl.inventory_item_id) ) weight,
372: msi.weight_uom_code uom

Line 386: WSH_WV_PVT.convert_uom(sl.unit_code,

382: GROUP BY msi.weight_uom_code;
383:
384: CURSOR dpw_bo_loose_volume(x_dep_id NUMBER, x_o_id NUMBER) IS
385: SELECT SUM( NVL(msi.unit_volume, 0) *
386: WSH_WV_PVT.convert_uom(sl.unit_code,
387: msi.primary_uom_code,
388: sld.requested_quantity,
389: sl.inventory_item_id) ) volume,
390: msi.volume_uom_code uom

Line 476: WSH_WV_PVT.convert_uom(sl.unit_code,

472: m_msi.unit_volume, i_msi.unit_volume;
473:
474: CURSOR sc_loose_weight(x_dep_id NUMBER, x_o_id NUMBER, x_wv_mode NUMBER) IS
475: SELECT SUM( NVL(msi.unit_weight, 0) *
476: WSH_WV_PVT.convert_uom(sl.unit_code,
477: msi.primary_uom_code,
478: NVL(sld.shipped_quantity,
479: x_wv_mode*sld.requested_quantity),
480: sl.inventory_item_id) ) weight,

Line 495: WSH_WV_PVT.convert_uom(sl.unit_code,

491: GROUP BY msi.weight_uom_code;
492:
493: CURSOR sc_loose_volume(x_dep_id NUMBER, x_o_id NUMBER, x_wv_mode NUMBER) IS
494: SELECT SUM( NVL(msi.unit_volume, 0) *
495: WSH_WV_PVT.convert_uom(sl.unit_code,
496: msi.primary_uom_code,
497: NVL(sld.shipped_quantity,
498: x_wv_mode*sld.requested_quantity),
499: sl.inventory_item_id) ) volume,

Line 584: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,

580:
581: IF source = 'DPW' THEN
582:
583: FOR w IN dpw_loose_weight(departure_id, organization_id) LOOP
584: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,
585: w.weight);
586: END LOOP;
587: FOR w IN dpw_bo_loose_weight(departure_id, organization_id) LOOP
588: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,

Line 588: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,

584: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,
585: w.weight);
586: END LOOP;
587: FOR w IN dpw_bo_loose_weight(departure_id, organization_id) LOOP
588: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,
589: w.weight);
590: END LOOP;
591:
592: FOR v IN dpw_loose_volume(departure_id, organization_id) LOOP

Line 593: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,

589: w.weight);
590: END LOOP;
591:
592: FOR v IN dpw_loose_volume(departure_id, organization_id) LOOP
593: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,
594: v.volume);
595: END LOOP;
596: FOR v IN dpw_bo_loose_volume(departure_id, organization_id) LOOP
597: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,

Line 597: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,

593: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,
594: v.volume);
595: END LOOP;
596: FOR v IN dpw_bo_loose_volume(departure_id, organization_id) LOOP
597: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,
598: v.volume);
599: END LOOP;
600:
601: FOR a IN dpw_loose_ato(departure_id) LOOP

Line 637: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,

633: WV_MODE := 1;
634: END IF;
635:
636: FOR w IN sc_loose_weight(departure_id, organization_id, wv_mode) LOOP
637: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,
638: w.weight);
639: END LOOP;
640: FOR v IN sc_loose_volume(departure_id, organization_id, wv_mode) LOOP
641: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,

Line 641: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,

637: weight := weight + WSH_WV_PVT.convert_uom(w.uom, master_weight_uom,
638: w.weight);
639: END LOOP;
640: FOR v IN sc_loose_volume(departure_id, organization_id, wv_mode) LOOP
641: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_volume_uom,
642: v.volume);
643: END LOOP;
644:
645: FOR a IN sc_loose_ato(departure_id,

Line 664: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(3)');

660:
661: EXCEPTION
662: WHEN OTHERS THEN
663: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
664: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(3)');
665: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
666: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
667: status := -1;
668: END dep_loose_weight_volume;

Line 805: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(4)');

801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
805: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(4)');
806: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
807: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
808: IF container_fill%ISOPEN THEN
809: CLOSE container_fill;

Line 868: WSH_WV_PVT.del_autopack(del_id, organization_id, pack_status);

864: x_master_weight_uom := master_weight_uom;
865: x_master_volume_uom := master_volume_uom;
866:
867: IF source = 'DPW' AND dpw_pack_flag = 'Y' THEN
868: WSH_WV_PVT.del_autopack(del_id, organization_id, pack_status);
869: IF pack_status = 1 THEN
870: IF status = 0 then -- don't want to change error into warning.
871: status := 1;
872: END IF;

Line 877: WSH_WV_PVT.del_weight(source, del_id, organization_id,

873: FND_MESSAGE.Set_Name('OE', 'WSH_WV_AUTOPACK_BELOW_MIN_FILL');
874: END IF;
875: END IF;
876:
877: WSH_WV_PVT.del_weight(source, del_id, organization_id,
878: menu_flag, x_sc_wv_mode,
879: master_weight_uom, x_gross_weight,
880: status);
881: gross_weight := x_gross_weight;

Line 883: WSH_WV_PVT.del_volume(source, del_id, organization_id,

879: master_weight_uom, x_gross_weight,
880: status);
881: gross_weight := x_gross_weight;
882:
883: WSH_WV_PVT.del_volume(source, del_id, organization_id,
884: x_sc_wv_mode,
885: master_volume_uom, x_volume,
886: status);
887: volume := x_volume;

Line 919: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(5)');

915:
916: EXCEPTION
917: WHEN OTHERS THEN
918: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
919: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(5)');
920: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
921: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
922: status := -1;
923: END;

Line 969: WSH_WV_PVT.convert_uom(sld.unit_code,

965: GROUP BY msi.volume_uom_code;
966:
967: CURSOR dpw_unpacked_volume(x_del_id NUMBER, x_o_id NUMBER) IS
968: SELECT SUM( NVL(msi.unit_volume, 0) *
969: WSH_WV_PVT.convert_uom(sld.unit_code,
970: msi.primary_uom_code,
971: sld.quantity,
972: sld.inventory_item_id) ) volume,
973: msi.volume_uom_code uom

Line 985: WSH_WV_PVT.convert_uom(sl.unit_code,

981: GROUP BY msi.volume_uom_code;
982:
983: CURSOR dpw_unpacked_bo_volume(x_del_id NUMBER, x_o_id NUMBER) IS
984: SELECT SUM( NVL(msi.unit_volume, 0) *
985: WSH_WV_PVT.convert_uom(sl.unit_code,
986: msi.primary_uom_code,
987: sld.requested_quantity,
988: sl.inventory_item_id) ) volume,
989: msi.volume_uom_code uom

Line 1050: WSH_WV_PVT.convert_uom(sl.unit_code,

1046:
1047: CURSOR sc_unpacked_volume(x_del_id NUMBER, x_o_id NUMBER,
1048: x_wv_mode NUMBER) IS
1049: SELECT SUM( NVL(msi.unit_volume, 0) *
1050: WSH_WV_PVT.convert_uom(sl.unit_code,
1051: msi.primary_uom_code,
1052: NVL(sld.shipped_quantity,
1053: x_wv_mode*sld.requested_quantity),
1054: sl.inventory_item_id) ) volume,

Line 1103: volume := volume + WSH_WV_PVT.convert_uom(dv.uom, master_uom, dv.volume);

1099:
1100: BEGIN
1101: volume := 0;
1102: FOR dv IN delivery_volumes(delivery_id, organization_id) LOOP
1103: volume := volume + WSH_WV_PVT.convert_uom(dv.uom, master_uom, dv.volume);
1104: END LOOP;
1105:
1106: -- include volume of unpacked items in this delivery.
1107:

Line 1111: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);

1107:
1108: IF source = 'DPW' THEN
1109:
1110: FOR v IN dpw_unpacked_volume(delivery_id, organization_id) LOOP
1111: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1112: END LOOP;
1113:
1114: FOR v IN dpw_unpacked_bo_volume(delivery_id, organization_id) LOOP
1115: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);

Line 1115: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);

1111: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1112: END LOOP;
1113:
1114: FOR v IN dpw_unpacked_bo_volume(delivery_id, organization_id) LOOP
1115: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1116: END LOOP;
1117:
1118: FOR a IN dpw_unpacked_ato(delivery_id) LOOP
1119: wsh_wvx_pvt.ato_weight_volume(source,

Line 1151: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);

1147: WV_MODE := 1;
1148: END IF;
1149:
1150: FOR v IN sc_unpacked_volume(delivery_id, organization_id, wv_mode) LOOP
1151: volume := volume + WSH_WV_PVT.convert_uom(v.uom, master_uom, v.volume);
1152: END LOOP;
1153:
1154: FOR a IN sc_unpacked_ato(delivery_id, wv_mode) LOOP
1155: wsh_wvx_pvt.ato_weight_volume(source,

Line 1171: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(6)');

1167:
1168: EXCEPTION
1169: WHEN OTHERS THEN
1170: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1171: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(6)');
1172: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1173: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1174: status := -1;
1175: END del_volume;

Line 1222: WSH_WV_PVT.convert_uom(sld.unit_code,

1218: -- cursors are for DPW case.
1219:
1220: CURSOR net_weight(x_del_id NUMBER, x_o_id NUMBER) IS
1221: SELECT SUM( NVL(msi.unit_weight, 0) *
1222: WSH_WV_PVT.convert_uom(sld.unit_code,
1223: msi.primary_uom_code,
1224: sld.quantity,
1225: sld.inventory_item_id) ) weight,
1226: msi.weight_uom_code uom

Line 1236: WSH_WV_PVT.convert_uom(sl.unit_code,

1232: GROUP BY msi.weight_uom_code;
1233:
1234: CURSOR net_bo_weight(x_del_id NUMBER, x_o_id NUMBER) IS
1235: SELECT SUM( NVL(msi.unit_weight, 0) *
1236: WSH_WV_PVT.convert_uom(sl.unit_code,
1237: msi.primary_uom_code,
1238: sld.requested_quantity,
1239: sl.inventory_item_id) ) weight,
1240: msi.weight_uom_code uom

Line 1313: + WSH_WV_PVT.convert_uom(dw.uom, master_uom, dw.weight);

1309: IF source = 'DPW' THEN
1310: -- Add the tare weights.
1311: FOR dw IN delivery_weights(delivery_id, organization_id) LOOP
1312: gross_weight := gross_weight
1313: + WSH_WV_PVT.convert_uom(dw.uom, master_uom, dw.weight);
1314: END LOOP;
1315:
1316: -- Add the estimated net weight of delivery.
1317: FOR nw IN net_weight(delivery_id, organization_id) LOOP

Line 1319: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);

1315:
1316: -- Add the estimated net weight of delivery.
1317: FOR nw IN net_weight(delivery_id, organization_id) LOOP
1318: gross_weight := gross_weight
1319: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);
1320: END LOOP;
1321: FOR nw IN net_bo_weight(delivery_id, organization_id) LOOP
1322: gross_weight := gross_weight
1323: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);

Line 1323: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);

1319: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);
1320: END LOOP;
1321: FOR nw IN net_bo_weight(delivery_id, organization_id) LOOP
1322: gross_weight := gross_weight
1323: + WSH_WV_PVT.convert_uom(nw.uom, master_uom, nw.weight);
1324: END LOOP;
1325:
1326: FOR a IN ato(delivery_id) LOOP
1327: wsh_wvx_pvt.ato_weight_volume(source,

Line 1351: WSH_WV_PVT.containers_weight(delivery_id, organization_id,

1347: gross_weight := gross_weight + ato_weight;
1348: END LOOP;
1349:
1350: ELSIF source = 'SC' THEN
1351: WSH_WV_PVT.containers_weight(delivery_id, organization_id,
1352: NULL,
1353: menu_flag, x_sc_wv_mode,
1354: master_uom, weight_c, status);
1355:

Line 1358: WSH_WV_PVT.containers_weight(delivery_id, organization_id,

1354: master_uom, weight_c, status);
1355:
1356: FOR c in sc_other_master_containers(delivery_id) LOOP
1357: -- weight_c will accumulate, as we weight the other containers
1358: WSH_WV_PVT.containers_weight(delivery_id, organization_id,
1359: c.parent_sequence_number,
1360: menu_flag, x_sc_wv_mode,
1361: master_uom, weight_c, status);
1362: END LOOP;

Line 1366: WSH_WV_PVT.unpacked_items_weight(delivery_id, organization_id,

1362: END LOOP;
1363:
1364: -- Add unpacked items,
1365: -- even if this addition may inflate the gross_weight value.
1366: WSH_WV_PVT.unpacked_items_weight(delivery_id, organization_id,
1367: x_sc_wv_mode,
1368: master_uom, weight_ui, status);
1369:
1370: gross_weight := weight_c + weight_ui;

Line 1380: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(7)');

1376:
1377: EXCEPTION
1378: WHEN OTHERS THEN
1379: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1380: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(7)');
1381: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1382: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1383: IF delivery_weights%ISOPEN THEN
1384: CLOSE delivery_weights;

Line 1468: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(8)');

1464:
1465: EXCEPTION
1466: WHEN OTHERS THEN
1467: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1468: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(8)');
1469: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1470: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1471: if unpacked_items%ISOPEN then
1472: close unpacked_items;

Line 1576: IF WSH_WV_PVT.convert_uom(ci.w_uom_code, ci.mw_uom_code, ci.weight)

1572:
1573: IF ci.w_uom_code = ci.mw_uom_code THEN
1574: overweight := TRUE;
1575: ELSE
1576: IF WSH_WV_PVT.convert_uom(ci.w_uom_code, ci.mw_uom_code, ci.weight)
1577: > ci.max_weight THEN
1578: overweight := TRUE;
1579: END IF;
1580: END IF;

Line 1605: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(9)');

1601:
1602: EXCEPTION
1603: WHEN OTHERS THEN
1604: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1605: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(9)');
1606: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1607: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1608: IF containers_info%ISOPEN THEN
1609: CLOSE containers_info;

Line 1665: WSH_WV_PVT.convert_uom(pl.unit_code,

1661: CURSOR contents_lookups(x_del_id NUMBER, x_o_id NUMBER, x_cont_id NUMBER,
1662: x_wv_mode NUMBER) IS
1663: SELECT pl.inventory_item_id,
1664: SUM( NVL(msi.unit_weight, 0) *
1665: WSH_WV_PVT.convert_uom(pl.unit_code,
1666: msi.primary_uom_code,
1667: NVL(cc.shipped_quantity,
1668: x_wv_mode*cc.requested_quantity),
1669: pl.inventory_item_id) ) weight,

Line 1743: WSH_WV_PVT.containers_weight(delivery_id, organization_id,

1739: -- 1. Recursively weight the containers inside this container
1740: -- only if the container has a (non-NULL) sequence number.
1741:
1742: IF container.sequence_number IS NOT NULL THEN
1743: WSH_WV_PVT.containers_weight(delivery_id, organization_id,
1744: container.sequence_number,
1745: menu_flag, x_sc_wv_mode,
1746: master_uom, cont_weight, status);
1747: END IF;

Line 1753: + WSH_WV_PVT.convert_uom(contents.uom_code, master_uom,

1749: -- 2. Add the weights of items "loose" in this container, including ATO.
1750: FOR contents IN contents_lookups(delivery_id, organization_id,
1751: container.id, wv_mode) LOOP
1752: cont_weight := cont_weight
1753: + WSH_WV_PVT.convert_uom(contents.uom_code, master_uom,
1754: contents.weight);
1755: END LOOP;
1756:
1757: FOR a IN packed_ato(delivery_id, container.id, wv_mode) LOOP

Line 1773: + WSH_WV_PVT.convert_uom(container.uom_code, master_uom,

1769: -- 3. Include the container's tare weight, scaled by its quantity.
1770: -- (The contents are independent of the container's quantity,
1771: -- so their weight isn't scaled in step 2.)
1772: cont_weight := cont_weight
1773: + WSH_WV_PVT.convert_uom(container.uom_code, master_uom,
1774: container.unit_weight)
1775: * container.quantity;
1776:
1777: -- 4. Now update the table.

Line 1787: cont_weight := WSH_WV_PVT.convert_uom(container.gross_uom_code,

1783: WHERE rowid = container.rid;
1784:
1785: ELSE
1786: -- Use its aggregate gross weight which has been entered into the table.
1787: cont_weight := WSH_WV_PVT.convert_uom(container.gross_uom_code,
1788: master_uom,
1789: container.gross_weight);
1790: END IF;
1791:

Line 1798: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(10)');

1794:
1795: EXCEPTION
1796: WHEN OTHERS THEN
1797: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1798: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(10)');
1799: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1800: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1801: IF container_lookups%ISOPEN THEN
1802: CLOSE container_lookups;

Line 1837: WSH_WV_PVT.convert_uom(spl.unit_code,

1833: status IN OUT NUMBER)
1834: IS
1835: CURSOR unpacked_items(x_del_id NUMBER, x_o_id NUMBER, x_wv_mode NUMBER) IS
1836: SELECT SUM(NVL(msi.unit_weight, 0) *
1837: WSH_WV_PVT.convert_uom(spl.unit_code,
1838: msi.primary_uom_code,
1839: NVL(spld.shipped_quantity,
1840: x_wv_mode*spld.requested_quantity),
1841: spl.inventory_item_id) ) weight,

Line 1899: + WSH_WV_PVT.convert_uom(ti.uom, master_uom, ti.weight);

1895: END IF;
1896:
1897: FOR ti IN unpacked_items(delivery_id, organization_id, wv_mode) LOOP
1898: total_weight := total_weight
1899: + WSH_WV_PVT.convert_uom(ti.uom, master_uom, ti.weight);
1900: END LOOP;
1901:
1902: FOR a IN unpacked_ato(delivery_id, wv_mode) LOOP
1903: wsh_wvx_pvt.ato_weight_volume('SC',

Line 1919: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(11)');

1915:
1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
1919: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(11)');
1920: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
1921: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
1922: status := -1;
1923: END unpacked_items_weight;

Line 1966: WSH_WV_PVT.convert_uom(dl.unit_code,

1962:
1963: CURSOR autopack_list(x_del_id NUMBER, x_o_id NUMBER) IS
1964: SELECT dl.load_seq_number load_seq_number,
1965: wcl.container_item_id iid,
1966: WSH_WV_PVT.convert_uom(dl.unit_code,
1967: item_msi.primary_uom_code,
1968: dl.quantity,
1969: dl.inventory_item_id)
1970: / wcl.max_load_quantity raw_qty,

Line 1995: WSH_WV_PVT.convert_uom(spl.unit_code,

1991: UNION ALL
1992: -- copied from SELECT above and modified for backordered picking lines
1993: SELECT dl.load_seq_number load_seq_number,
1994: wcl.container_item_id iid,
1995: WSH_WV_PVT.convert_uom(spl.unit_code,
1996: item_msi.primary_uom_code,
1997: NVL(dl.shipped_quantity,
1998: dl.requested_quantity),
1999: spl.inventory_item_id)

Line 2060: WSH_WV_PVT.del_packcont(del_id,

2056:
2057: /* Bug 770276 :Increment the sequence number by 10 */
2058: load_seq_number := nvl(load_seq_number,0) + 10;
2059:
2060: WSH_WV_PVT.del_packcont(del_id,
2061: organization_id,
2062: current_container_item_id,
2063: raw_qty,
2064: min_fill,

Line 2093: WSH_WV_PVT.del_packcont(del_id,

2089:
2090: /* Bug 770276 :Increment the sequence number by 10 */
2091: load_seq_number := nvl(load_seq_number,0) + 10;
2092:
2093: WSH_WV_PVT.del_packcont(del_id,
2094: organization_id,
2095: current_container_item_id,
2096: raw_qty,
2097: min_fill,

Line 2112: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(12)');

2108: EXCEPTION
2109: WHEN OTHERS THEN
2110: ROLLBACK TO before_autopack;
2111: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
2112: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(12)');
2113: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
2114: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
2115: status := -1;
2116: END del_autopack;

Line 2187: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(13)');

2183:
2184: EXCEPTION
2185: WHEN OTHERS THEN
2186: FND_MESSAGE.Set_Name('OE','OE_QUERY_ERROR');
2187: FND_MESSAGE.Set_Token('PACKAGE','wsh_wv_pvt(13)');
2188: FND_MESSAGE.Set_Token('ORA_ERROR',to_char(sqlcode));
2189: FND_MESSAGE.Set_Token('ORA_TEXT',SQLERRM);
2190: status := -1;
2191: END del_packcont;

Line 2303: END WSH_WV_PVT;

2299:
2300: END set_messages;
2301:
2302:
2303: END WSH_WV_PVT;