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.WMS_ASN_INTERFACE dependencies on WMS_LPN_CONTENTS

Line 66: DELETE wms_lpn_contents

62:
63: DELETE mtl_serial_numbers
64: WHERE lpn_id = l_lpn_id;
65:
66: DELETE wms_lpn_contents
67: WHERE parent_lpn_id = l_lpn_id;
68:
69: DELETE wms_license_plate_numbers
70: WHERE lpn_id = l_lpn_id;

Line 117: FROM wms_lpn_contents_interface

113: item_description,
114: quantity,
115: uom_code,
116: serial_transaction_intf_id
117: FROM wms_lpn_contents_interface
118: WHERE interface_transaction_id = p_interface_transaction_id;
119:
120: CURSOR l_print_lpn_curs
121: (v_group_id NUMBER)

Line 151: FROM wms_lpn_contents_interface

147: -- Bug# 1546081
148:
149: CURSOR l_lpn_interface_UOM_curs IS
150: SELECT uom_code
151: FROM wms_lpn_contents_interface
152: WHERE interface_transaction_id = p_interface_transaction_id;
153:
154:
155: l_lpn_interface_rec l_cur_lpn_interface%ROWTYPE;

Line 261: -- from wms_lpn_contents_interface again as

257:
258: -- IF g_num_recs_per_group = 0 THEN
259: -- if g_num_recs_per_group > l_num_recs_per_group
260: -- the rti is cascaded and we don't need to do count
261: -- from wms_lpn_contents_interface again as
262: -- the contents of wms_lpn_contents_interface does not
263: -- exist anymore and already processed.
264:
265: SELECT COUNT(*)

Line 262: -- the contents of wms_lpn_contents_interface does not

258: -- IF g_num_recs_per_group = 0 THEN
259: -- if g_num_recs_per_group > l_num_recs_per_group
260: -- the rti is cascaded and we don't need to do count
261: -- from wms_lpn_contents_interface again as
262: -- the contents of wms_lpn_contents_interface does not
263: -- exist anymore and already processed.
264:
265: SELECT COUNT(*)
266: INTO l_num_recs_per_group

Line 267: FROM wms_lpn_contents_interface

263: -- exist anymore and already processed.
264:
265: SELECT COUNT(*)
266: INTO l_num_recs_per_group
267: FROM wms_lpn_contents_interface
268: WHERE group_id = l_rcv_txn_interface_rec.group_id
269: ;
270:
271: IF (l_debug = 1) THEN

Line 299: -- validate the total quantity within WMS_LPN_CONTENTS_INTERFACE for one RTI record

295:
296:
297: l_progress := '50';
298:
299: -- validate the total quantity within WMS_LPN_CONTENTS_INTERFACE for one RTI record
300: -- matches RTI quantity
301:
302: --
303: -- Validate the quantity based on group and item

Line 335: FROM wms_lpn_contents_interface

331: BEGIN
332:
333: SELECT nvl(SUM(quantity),0)
334: INTO l_total_quantity
335: FROM wms_lpn_contents_interface
336: WHERE group_id = c_group.group_id
337: AND item_num = c_group.item_num
338: ;
339:

Line 349: print_debug('Unexpected error while calculating total quantity within WMS_LPN_CONTENTS_INTERFACE.', 4);

345: ;
346: EXCEPTION
347: WHEN OTHERS THEN
348: IF (l_debug = 1) THEN
349: print_debug('Unexpected error while calculating total quantity within WMS_LPN_CONTENTS_INTERFACE.', 4);
350: END IF;
351: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
352: END;
353:

Line 356: print_debug('Total quantity within WMS_LPN_CONTENTS_INTERFACE shpuld not be less than quantity in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_id at any time : ' || p_interface_transaction_id, 4);

352: END;
353:
354: IF l_total_quantity < l_total_quantity_rti THEN
355: IF (l_debug = 1) THEN
356: print_debug('Total quantity within WMS_LPN_CONTENTS_INTERFACE shpuld not be less than quantity in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_id at any time : ' || p_interface_transaction_id, 4);
357: print_debug('l_total_quantity = ' || l_total_quantity, 4);
358: print_debug('l_total_quantity_rti = ' || l_total_quantity_rti, 4);
359: print_debug('l_rcv_txn_interface_rec.quantity = '|| l_rcv_txn_interface_rec.quantity, 4);
360: END IF;

Line 368: -- validate UOM Code within WMS_LPN_CONTENTS_INTERFACE for one RTI record

364: end loop;
365:
366: end if;
367:
368: -- validate UOM Code within WMS_LPN_CONTENTS_INTERFACE for one RTI record
369: -- matches RTI UOM Code
370:
371: BEGIN
372: SELECT uom_code

Line 405: -- loop through WMS_LPN_CONTENTS_INTERFACE records for this txn_intf_id

401:
402: l_progress := '55';
403:
404: OPEN l_cur_lpn_interface;
405: -- loop through WMS_LPN_CONTENTS_INTERFACE records for this txn_intf_id
406: LOOP
407: FETCH l_cur_lpn_interface INTO l_lpn_interface_rec;
408: EXIT WHEN l_cur_lpn_interface%notfound;
409:

Line 518: print_debug('Lot number exists in WMS_LPN_CONTENTS_INTERFACE : ' || l_lpn_interface_rec.lot_number, 4);

514:
515: -- validate/insert lot
516: IF l_lpn_interface_rec.lot_number IS NOT NULL THEN
517: IF (l_debug = 1) THEN
518: print_debug('Lot number exists in WMS_LPN_CONTENTS_INTERFACE : ' || l_lpn_interface_rec.lot_number, 4);
519: END IF;
520: l_progress := '110';
521:
522: IF l_lot_control_code <> 2 THEN

Line 665: print_debug('Serial numbers exist in WMS_LPN_CONTENTS_INTERFACE - FROM : ' || l_lpn_interface_rec.from_serial_number || ' TO : ' || l_lpn_interface_rec.to_serial_number, 4);

661: IF l_lpn_interface_rec.from_serial_number IS NOT NULL
662: AND l_lpn_interface_rec.to_serial_number IS NOT NULL THEN
663:
664: IF (l_debug = 1) THEN
665: print_debug('Serial numbers exist in WMS_LPN_CONTENTS_INTERFACE - FROM : ' || l_lpn_interface_rec.from_serial_number || ' TO : ' || l_lpn_interface_rec.to_serial_number, 4);
666: END IF;
667: l_progress := '170';
668:
669: IF l_serial_control_code <> 2 AND

Line 862: -- Commented this Part to do the Quantity Check for wms_lpn_contents_interface

858: );
859:
860:
861:
862: -- Commented this Part to do the Quantity Check for wms_lpn_contents_interface
863: --
864: -- DELETE wms_lpn_contents_interface
865: -- WHERE interface_transaction_id = p_interface_transaction_id;
866:

Line 864: -- DELETE wms_lpn_contents_interface

860:
861:
862: -- Commented this Part to do the Quantity Check for wms_lpn_contents_interface
863: --
864: -- DELETE wms_lpn_contents_interface
865: -- WHERE interface_transaction_id = p_interface_transaction_id;
866:
867: l_progress := '250';
868:

Line 870: print_debug('Process - after processing WMS_LPN_CONTENTS_INTERFACE - g_num_recs_per_group = ' || g_num_recs_per_group, 4);

866:
867: l_progress := '250';
868:
869: IF (l_debug = 1) THEN
870: print_debug('Process - after processing WMS_LPN_CONTENTS_INTERFACE - g_num_recs_per_group = ' || g_num_recs_per_group, 4);
871: END IF;
872:
873: l_progress := '260';
874:

Line 878: print_debug('Process - Processing WMS_LPN_CONTENTS_INTERFACE - Before Deletion from wms_lpn_contents_interface ' , 4);

874:
875: IF g_num_recs_per_group = l_num_recs_per_group THEN -- this is the last record in this group for LPN, call printing
876:
877: IF (l_debug = 1) THEN
878: print_debug('Process - Processing WMS_LPN_CONTENTS_INTERFACE - Before Deletion from wms_lpn_contents_interface ' , 4);
879: END IF;
880:
881: DELETE wms_lpn_contents_interface
882: WHERE group_id = l_rcv_txn_interface_rec.group_id ;

Line 881: DELETE wms_lpn_contents_interface

877: IF (l_debug = 1) THEN
878: print_debug('Process - Processing WMS_LPN_CONTENTS_INTERFACE - Before Deletion from wms_lpn_contents_interface ' , 4);
879: END IF;
880:
881: DELETE wms_lpn_contents_interface
882: WHERE group_id = l_rcv_txn_interface_rec.group_id ;
883:
884: OPEN l_print_lpn_curs (l_rcv_txn_interface_rec.group_id);
885: