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.FV_DUE_DATE_CALCULATION dependencies on FND_FILE

Line 314: --fnd_file.put_line(FND_FILE.LOG,'v_goods_rec_date = '||v_goods_rec_date);

310: v_invoice_date;
311: EXIT WHEN c1_main_select%NOTFOUND;
312: /* Get the original Due date from ap_payment_schedules */
313:
314: --fnd_file.put_line(FND_FILE.LOG,'v_goods_rec_date = '||v_goods_rec_date);
315: SELECT due_date
316: INTO v_org_due_date
317: FROM ap_payment_schedules
318: WHERE invoice_id = v_invoice_id;

Line 344: FND_FILE.PUT_LINE(FND_FILE.LOG,'Due days are '|| v_due_days);

340: FROM AP_TERMS_LINES
341: WHERE term_id = v_terms_id;
342:
343:
344: FND_FILE.PUT_LINE(FND_FILE.LOG,'Due days are '|| v_due_days);
345:
346: ---------------------------------------------------------------
347: -- derive the original dates ,discount date ,if the
348: -- invoice been already picked up

Line 388: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Receipt acc days are :' ||v_receipt_acceptance_days);

384: WHERE set_of_books_id = v_sob;
385: */
386:
387: x_err_code := 3;
388: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Receipt acc days are :' ||v_receipt_acceptance_days);
389: SELECT constructive_acceptance_days,
390: invoice_return_days
391: INTO v_con_acc_days,
392: v_invoice_return_days

Line 396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cons acceptance days are :'||v_con_acc_days);

392: v_invoice_return_days
393: FROM fv_terms_types
394: WHERE term_id = v_terms_id;
395:
396: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cons acceptance days are :'||v_con_acc_days);
397: /* Calculating due date for invoice which has po distribution */
398: v_rec_trxn_flag := 'N';
399:
400: SELECT SUM(quantity_invoiced) INTO v_quantity_billed

Line 404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quantity Invoiced is: ' || v_quantity_billed);

400: SELECT SUM(quantity_invoiced) INTO v_quantity_billed
401: FROM ap_invoice_distributions
402: WHERE invoice_id = v_invoice_id;
403:
404: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quantity Invoiced is: ' || v_quantity_billed);
405:
406: -- if(v_po_distribution_id is not null) then
407: v_transaction_date := null;
408: v_shipment_header_id := null;

Line 481: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Id :' || v_transaction_id ||

477: ' Type : ' || v_transaction_type
478: || ' Qty ' || TO_CHAR(v_quantity) || ' Billed ' ||
479: TO_CHAR(v_quantity_billed) );
480: END IF;
481: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Id :' || v_transaction_id ||
482: ' Type : ' || v_transaction_type
483: || ' Qty ' || to_char(v_quantity) || ' Billed ' ||
484: to_char(v_quantity_billed) ); */
485: -- summing the corrected qty for transaction type RECEIVE

Line 541: -- fnd_file.put_line(FND_FILE.LOG,'v_transaction_date = '||v_transaction_date);

537: -- this is for customers who are using the goods_received_date instead
538: -- of receiving features in payables to capture the receive date.
539: -- bug fix 2178745
540: v_transaction_date := v_goods_rec_date;
541: -- fnd_file.put_line(FND_FILE.LOG,'v_transaction_date = '||v_transaction_date);
542:
543: ELSE
544:
545: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 549: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction date ' ||

545: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
546: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSACTION DATE ' ||
547: TO_CHAR(v_transaction_date));
548: END IF;
549: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction date ' ||
550: to_char(v_transaction_date)); */
551: /* selecting latest Qty recevied date using
552: parent transaction */
553: IF(v_con_acc_days IS NOT NULL )

Line 566: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Receipt date is '||to_char(v_rec_transaction_date));

562: CLOSE c2_parent_receive ;
563: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
564: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECEIPT DATE IS '||TO_CHAR(V_REC_TRANSACTION_DATE));
565: END IF;
566: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Receipt date is '||to_char(v_rec_transaction_date));
567:
568: /* Read new transaction date,if any defined on */
569: BEGIN
570: SELECT actual_transaction_date

Line 669: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Fetched Acceptance Date is '

665: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
666: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FETCHED ACCEPTANCE DATE IS '
667: || TO_CHAR(v_transaction_date,'DD-MON-YYYY'));
668: END IF;
669: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Fetched Acceptance Date is '
670: || to_char(v_transaction_date,'DD-MON-YYYY'));*/
671:
672: /* adding constructive acceptence days */
673: IF (v_con_acc_days IS NOT NULL ) THEN

Line 741: --FND_FILE.put_line(FND_FILE.LOG,'checking inv return days not null');

737: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
738: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CHECKING INV RETURN DAYS NOT NULL');
739: END IF;
740:
741: --FND_FILE.put_line(FND_FILE.LOG,'checking inv return days not null');
742: IF(v_invoice_return_days IS NOT NULL ) THEN
743: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
744: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'YES IT IS NOT NULL');
745: END IF;

Line 788: --FND_FILE.PUT_LINE(FND_FILE.LOG,'due date update flag ' || v_due_date_flag);

784: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
785: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DUE DATE UPDATE FLAG ' || V_DUE_DATE_FLAG);
786: END IF;
787:
788: --FND_FILE.PUT_LINE(FND_FILE.LOG,'due date update flag ' || v_due_date_flag);
789:
790: ---------------------------------------------------------
791: /* check whether due_date falls on any weekend or holiday */
792: