DBA Data[Home] [Help]

APPS.JAI_CMN_RCV_MATCHING_PKG dependencies on FND_FILE

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

175:
176: v_RctQtyAvailableInIssueUOM := v_ReceiptQtyAvailable * v_UomConversion;
177: v_QtyToMatchInRctUOM := v_QtyToMatch / v_UomConversion;
178:
179: fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);
180: -- Receipt Qty is less than Delivery Detail Qty,
181: -- then loop through Receipts for Matching entire Delivery Detail Qty
182:
183: IF v_QtyToMatch > v_RctQtyAvailableInIssueUOM

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

203:
204: Open c_duplicate_record(rg23d_entry.register_id, match_detail.delivery_detail_id);
205: Fetch c_duplicate_record Into v_exist;
206: Close c_duplicate_record;
207: --fnd_file.put_line(fnd_file.log, '2 v_QtyToMatch = '||v_QtyToMatch||', v_RctQtyAvailableInIssueUOM = '||v_RctQtyAvailableInIssueUOM);
208: IF NVL(v_exist,0) <> 1 Then
209: INSERT INTO JAI_CMN_MATCH_RECEIPTS (
210: receipt_id, ref_line_id,
211: subinventory, quantity_applied,

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

234: END IF;
235: END IF; --xyz
236: END LOOP;
237:
238: fnd_file.put_line(fnd_file.log, match_detail.delivery_id ||', '||match_detail.delivery_detail_id ||', Matched receipts = '||v_MatchedRcptsForDetail);
239: IF v_QtyToMatch > 0 THEN
240: ROLLBACK;
241: errbuf := 'Enough receipt quantity is not available for the Detail ' || match_detail.delivery_detail_id||', Delivery = '||match_detail.delivery_id;
242: 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);