APPS.WMS_ASN_INTERFACE dependencies on RCV_TRANSACTIONS_INTERFACE

Line 125: rcv_transactions_interface rti

121: (v_group_id NUMBER)
122: IS
123: SELECT DISTINCT wlpn.lpn_id
124: FROM wms_license_plate_numbers wlpn,
125: rcv_transactions_interface rti
126: WHERE wlpn.source_header_id = rti.shipment_header_id
127: AND wlpn.lpn_context = 7
128: AND wlpn.source_type_id = 1
129: AND rti.group_id = v_group_id;

Line 144: FROM rcv_transactions_interface

140: unit_of_measure,
141: uom_code,
142: header_interface_id,
143: shipment_num
144: FROM rcv_transactions_interface
145: WHERE interface_transaction_id = p_interface_transaction_id;
146:
147: -- Bug# 1546081
148:

Line 216: FROM rcv_transactions_interface

212: /*
213: BEGIN
214: SELECT *
215: INTO l_rcv_txn_interface_rec
216: FROM rcv_transactions_interface
217: WHERE interface_transaction_id = p_interface_transaction_id;
218: EXCEPTION
219: WHEN OTHERS THEN
220: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 246: print_debug('No record exists in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_ID', 4);

242: /*Start of fix for Bug 1900958 */
243: IF c_rcv_txn_interface_rec%NOTFOUND THEN
244: CLOSE c_rcv_txn_interface_rec;
245: IF (l_debug = 1) THEN
246: print_debug('No record exists in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_ID', 4);
247: END IF;
248:
249: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
250: END IF;

Line 322: FROM rcv_transactions_interface where group_id = l_rcv_txn_interface_rec.group_id

318: validation_flag,
319: processing_status_code,
320: PO_LINE_LOCATION_ID,
321: SHIPMENT_NUM
322: FROM rcv_transactions_interface where group_id = l_rcv_txn_interface_rec.group_id
323: and item_id is not null )
324: loop
325: IF (l_debug = 1) THEN
326: print_debug(' 1. Group Id' || c_group.group_id , 4);

Line 342: FROM rcv_transactions_interface

338: ;
339:
340: SELECT nvl(SUM(quantity),0)
341: INTO l_total_quantity_rti
342: FROM rcv_transactions_interface
343: WHERE group_id = c_group.group_id
344: AND item_id = c_group.item_id
345: ;
346: EXCEPTION

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 393: print_debug('UOM Code in WMS_LPN_Content_Interface does not match the UOM Code in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_id : ' || p_interface_transaction_id, 4);

389:
390: IF l_lpn_interface_UOM_rec.uom_code IS NOT NULL AND
391: l_rcv_txn_interface_rec.uom_code <> l_lpn_interface_UOM_rec.uom_code THEN
392: IF (l_debug = 1) THEN
393: print_debug('UOM Code in WMS_LPN_Content_Interface does not match the UOM Code in RCV_TRANSACTIONS_INTERFACE for this interface_transaction_id : ' || p_interface_transaction_id, 4);
394: END IF;
395: RAISE FND_API.G_EXC_ERROR;
396: END IF;
397: