DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on FND_FILE

Line 238: fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);

234:
235: v_RctQtyAvailableInIssueUOM := v_ReceiptQtyAvailable * v_UomConversion;
236: v_QtyToMatchInRctUOM := v_QtyToMatch / v_UomConversion;
237:
238: fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);
239: -- Receipt Qty is less than Delivery Detail Qty,
240: -- then loop through Receipts for Matching entire Delivery Detail Qty
241:
242: IF v_QtyToMatch > v_RctQtyAvailableInIssueUOM

Line 266: --fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);

262:
263: Open c_duplicate_record(rg23d_entry.register_id, match_detail.delivery_detail_id);
264: Fetch c_duplicate_record Into v_exist;
265: Close c_duplicate_record;
266: --fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);
267: IF NVL(v_exist,0) <> 1 Then
268: INSERT INTO JAI_CMN_MATCH_RECEIPTS (
269: receipt_id, ref_line_id,
270: subinventory, quantity_applied,

Line 297: fnd_file.put_line(fnd_file.log, match_detail.delivery_id ||', '||match_detail.delivery_detail_id ||', Matched receipts = '||v_MatchedRcptsForDetail);

293: END IF;
294: END IF; --xyz
295: END LOOP;
296:
297: fnd_file.put_line(fnd_file.log, match_detail.delivery_id ||', '||match_detail.delivery_detail_id ||', Matched receipts = '||v_MatchedRcptsForDetail);
298: IF v_QtyToMatch > 0 THEN
299: ROLLBACK;
300: errbuf := 'Enough receipt quantity is not available for the Detail ' || match_detail.delivery_detail_id||', Delivery = '||match_detail.delivery_id;
301: RAISE_APPLICATION_ERROR(-20120, '11 Enough Quantity is not available for the Delivery = '||match_detail.delivery_id||', and Delivery Line = ' || match_detail.delivery_detail_id);