DBA Data[Home] [Help]

APPS.FV_DUE_DATE_CALCULATION dependencies on FND_FILE

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

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

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

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

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

391: WHERE set_of_books_id = v_sob;
392: */
393:
394: x_err_code := 3;
395: -- FND_FILE.PUT_LINE(FND_FILE.LOG,'Receipt acc days are :' ||v_receipt_acceptance_days);
396: SELECT constructive_acceptance_days,
397: invoice_return_days
398: INTO v_con_acc_days,
399: v_invoice_return_days

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

399: v_invoice_return_days
400: FROM fv_terms_types
401: WHERE term_id = v_terms_id;
402:
403: FND_FILE.PUT_LINE(FND_FILE.LOG,'Cons acceptance days are :'||v_con_acc_days);
404: /* Calculating due date for invoice which has po distribution */
405: v_rec_trxn_flag := 'N';
406:
407: SELECT SUM(quantity_invoiced) INTO v_quantity_billed

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

407: SELECT SUM(quantity_invoiced) INTO v_quantity_billed
408: FROM ap_invoice_distributions
409: WHERE invoice_id = v_invoice_id;
410:
411: FND_FILE.PUT_LINE(FND_FILE.LOG,'Quantity Invoiced is: ' || v_quantity_billed);
412:
413: -- if(v_po_distribution_id is not null) then
414: v_transaction_date := null;
415: v_shipment_header_id := null;

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

484: ' Type : ' || v_transaction_type
485: || ' Qty ' || TO_CHAR(v_quantity) || ' Billed ' ||
486: TO_CHAR(v_quantity_billed) );
487: END IF;
488: /*FND_FILE.PUT_LINE(FND_FILE.LOG, 'Id :' || v_transaction_id ||
489: ' Type : ' || v_transaction_type
490: || ' Qty ' || to_char(v_quantity) || ' Billed ' ||
491: to_char(v_quantity_billed) ); */
492: -- summing the corrected qty for transaction type RECEIVE

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

544: -- this is for customers who are using the goods_received_date instead
545: -- of receiving features in payables to capture the receive date.
546: -- bug fix 2178745
547: v_transaction_date := v_goods_rec_date;
548: -- fnd_file.put_line(FND_FILE.LOG,'v_transaction_date = '||v_transaction_date);
549:
550: ELSE
551:
552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

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

552: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
553: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'TRANSACTION DATE ' ||
554: TO_CHAR(v_transaction_date));
555: END IF;
556: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Transaction date ' ||
557: to_char(v_transaction_date)); */
558: /* selecting latest Qty recevied date using
559: parent transaction */
560: IF(v_con_acc_days IS NOT NULL )

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

569: CLOSE c2_parent_receive ;
570: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
571: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'RECEIPT DATE IS '||TO_CHAR(V_REC_TRANSACTION_DATE));
572: END IF;
573: --FND_FILE.PUT_LINE(FND_FILE.LOG, 'Receipt date is '||to_char(v_rec_transaction_date));
574:
575: /* Read new transaction date,if any defined on */
576: BEGIN
577: SELECT actual_transaction_date

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

672: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
673: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'FETCHED ACCEPTANCE DATE IS '
674: || TO_CHAR(v_transaction_date,'DD-MON-YYYY'));
675: END IF;
676: /*FND_FILE.PUT_LINE(FND_FILE.LOG,'Fetched Acceptance Date is '
677: || to_char(v_transaction_date,'DD-MON-YYYY'));*/
678:
679: /* adding constructive acceptence days */
680: IF (v_con_acc_days IS NOT NULL ) THEN

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

749: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
750: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'CHECKING INV RETURN DAYS NOT NULL');
751: END IF;
752:
753: --FND_FILE.put_line(FND_FILE.LOG,'checking inv return days not null');
754: IF(v_invoice_return_days IS NOT NULL ) THEN
755: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
756: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'YES IT IS NOT NULL');
757: END IF;

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

796: IF ( FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
797: FV_UTILITY.DEBUG_MESG(FND_LOG.LEVEL_STATEMENT, l_module_name,'DUE DATE UPDATE FLAG ' || V_DUE_DATE_FLAG);
798: END IF;
799:
800: --FND_FILE.PUT_LINE(FND_FILE.LOG,'due date update flag ' || v_due_date_flag);
801:
802: ---------------------------------------------------------
803: /* check whether due_date falls on any weekend or holiday */
804: