2948: INTO
2949: l_po_header_id, l_po_line_id, l_po_line_location_id,
2950: l_transaction_type, l_transaction_date, l_inventory_item_id
2951: FROM
2952: rcv_transactions rt,
2953: rcv_shipment_lines rsl
2954: WHERE
2955: transaction_id = p_rcv_transaction_id
2956: AND rt.shipment_line_id = rsl.shipment_line_id;
2975:
2976: IF (l_po_header_id IS NULL) OR (l_po_line_id IS NULL) OR
2977: (l_po_line_location_id IS NULL) THEN
2978: IF l_debug = 1 then
2979: print_debug('Insufficient information in rcv_transactions', l_api_name);
2980: END IF;
2981: fnd_message.set_name('INV', 'INV_NO_RCVTXN_INFO');
2982: fnd_msg_pub.add;
2983: RAISE fnd_api.g_exc_error;
3257: INTO l_organization_id, l_transaction_date
3258: FROM ic_whse_mst WHS
3259: , oe_order_lines_all OEL
3260: , oe_order_headers_all OEH
3261: , rcv_transactions RCT
3262: , po_requisition_headers_all poh
3263: , po_requisition_lines_all pol
3264: WHERE poh.requisition_header_id = pol.requisition_header_id
3265: AND pol.requisition_line_id = oel.orig_sys_document_Ref
3315: l_progress := 3;
3316: BEGIN
3317: select rcv.organization_id, transaction_date
3318: into l_organization_id, l_transaction_date
3319: FROM rcv_transactions rcv
3320: WHERE rcv.transaction_id = p_reference_id;
3321: EXCEPTION
3322: WHEN NO_DATA_FOUND then
3323: FND_MESSAGE.SET_NAME('INV', 'INV_INVALID_RCV_TRANSACTION');