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.JAI_ST_REVERSAL_EXTRACT_PKG dependencies on JAI_CMN_DEBUG_CONTEXTS_PKG

Line 516: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context

512: BEGIN
513: lv_member_name := 'EXTRACT_ST_REVERSAL_TRXS';
514: set_debug_context;
515: p_process_flag := jai_constants.SUCCESSFUL;
516: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
517: , pn_reg_id => ln_reg_id
518: );
519:
520: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

Line 520: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||

516: jai_cmn_debug_contexts_pkg.register ( pv_context => lv_context
517: , pn_reg_id => ln_reg_id
518: );
519:
520: jai_cmn_debug_contexts_pkg.print (ln_reg_id, 'Call Parameters:' || fnd_global.local_chr(10) ||
521: 'pv_registration_num =' ||pv_registration_num || fnd_global.local_chr(10) ||
522: 'pn_organization_id =' ||pn_organization_id || fnd_global.local_chr(10) ||
523: 'pn_location_id =' ||pn_location_id || fnd_global.local_chr(10) ||
524: 'pv_source =' ||pv_source || fnd_global.local_chr(10) ||

Line 531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );

527: 'pv_invoice_number =' ||pv_invoice_number || fnd_global.local_chr(10) ||
528: 'pd_invoice_date =' ||pd_invoice_date || fnd_global.local_chr(10) ||
529: 'pd_as_of_date =' ||pd_as_of_date
530: );
531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );
532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );

Line 532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );

528: 'pd_invoice_date =' ||pd_invoice_date || fnd_global.local_chr(10) ||
529: 'pd_as_of_date =' ||pd_as_of_date
530: );
531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );
532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );

Line 533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );

529: 'pd_as_of_date =' ||pd_as_of_date
530: );
531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );
532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );

Line 534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );

530: );
531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );
532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );

Line 535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );

531: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_registration_num =' ||pv_registration_num );
532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );
539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );

Line 536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );

532: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_organization_id =' ||pn_organization_id );
533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );
539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );
540:

Line 537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );

533: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_location_id =' ||pn_location_id );
534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );
539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );
540:
541: OPEN c_get_st_accrual_date(pn_organization_id, pn_location_id);

Line 538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );

534: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_source =' ||pv_source );
535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );
539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );
540:
541: OPEN c_get_st_accrual_date(pn_organization_id, pn_location_id);
542: FETCH c_get_st_accrual_date INTO ld_accrual_date;

Line 539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );

535: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_id =' ||pn_vendor_id );
536: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pn_vendor_site_id =' ||pn_vendor_site_id );
537: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pv_invoice_number =' ||pv_invoice_number );
538: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_invoice_date =' ||pd_invoice_date );
539: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'pd_as_of_date =' ||pd_as_of_date );
540:
541: OPEN c_get_st_accrual_date(pn_organization_id, pn_location_id);
542: FETCH c_get_st_accrual_date INTO ld_accrual_date;
543: CLOSE c_get_st_accrual_date;

Line 561: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'lv_reversal_unit='||lv_reversal_unit);

557: FETCH c_ar_reversal_num INTO ln_reversal_num;
558: CLOSE c_ar_reversal_num;
559: END IF;
560:
561: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'lv_reversal_unit='||lv_reversal_unit);
562: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_reversal_num='||ln_reversal_num);
563:
564: IF lv_reversal_unit = 'DAY' THEN
565: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 begin*/

Line 562: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_reversal_num='||ln_reversal_num);

558: CLOSE c_ar_reversal_num;
559: END IF;
560:
561: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'lv_reversal_unit='||lv_reversal_unit);
562: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_reversal_num='||ln_reversal_num);
563:
564: IF lv_reversal_unit = 'DAY' THEN
565: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 begin*/
566: SELECT decode(sign(pd_as_of_date - SYSDATE)

Line 587: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_new_as_of_date='||ld_new_as_of_date);

583: INTO ld_new_as_of_date
584: FROM dual;
585: /*Modified by Qinglei 14-Dec-2011 bug# 13395658 end*/
586: END IF;
587: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_new_as_of_date='||ld_new_as_of_date);
588:
589: /*Commented by Qinglei 14-Dec-2011 bug# 13395658*/
590: /*IF ld_new_as_of_date > pd_as_of_date THEN
591: ld_new_as_of_date := pd_as_of_date;

Line 604: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_standard_ap.invoice_id);

600: ,pv_invoice_number
601: ,pd_invoice_date
602: ,ld_new_as_of_date)
603: LOOP
604: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_standard_ap.invoice_id);
605: IF lv_reversal_unit = 'DAY' THEN
606: ld_grace_date := r_standard_ap.accounting_date + ln_reversal_num;
607: ELSE
608: SELECT add_months(r_standard_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;

Line 628: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_max_payment_date='||ld_max_payment_date);

624:
625: END IF;
626: ld_max_payment_date := get_max_date(ld_max_payment_date,ld_max_prepayment_date);
627:
628: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_max_payment_date='||ld_max_payment_date);
629: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
630: IF trunc(ld_max_payment_date) <= trunc(ld_grace_date) THEN
631: lv_reversal_flag := 'N';
632: END IF;--this condition indicate that the payment has been done before grace date, no need to reversal.

Line 629: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);

625: END IF;
626: ld_max_payment_date := get_max_date(ld_max_payment_date,ld_max_prepayment_date);
627:
628: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ld_max_payment_date='||ld_max_payment_date);
629: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
630: IF trunc(ld_max_payment_date) <= trunc(ld_grace_date) THEN
631: lv_reversal_flag := 'N';
632: END IF;--this condition indicate that the payment has been done before grace date, no need to reversal.
633: END IF;--payment status flag is 'Y'

Line 642: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);

638: CLOSE c_sum_all_tax_amt_standard;
639:
640: ln_original_line_amt := r_standard_ap.line_amount + ln_sum_tax_amt;
641:
642: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);
643: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);
644: OPEN c_sum_rv_st_tax_amt_standard(r_standard_ap.invoice_id, r_standard_ap.invoice_line_number,ld_new_as_of_date);
645: FETCH c_sum_rv_st_tax_amt_standard INTO ln_rcv_st_amt;
646: CLOSE c_sum_rv_st_tax_amt_standard;

Line 643: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);

639:
640: ln_original_line_amt := r_standard_ap.line_amount + ln_sum_tax_amt;
641:
642: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);
643: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);
644: OPEN c_sum_rv_st_tax_amt_standard(r_standard_ap.invoice_id, r_standard_ap.invoice_line_number,ld_new_as_of_date);
645: FETCH c_sum_rv_st_tax_amt_standard INTO ln_rcv_st_amt;
646: CLOSE c_sum_rv_st_tax_amt_standard;
647:

Line 662: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);

658: CLOSE c_prepaid_amt;
659:
660: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
661:
662: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
663: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
664: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
665: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
666:

Line 663: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);

659:
660: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
661:
662: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
663: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
664: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
665: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
666:
667: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;

Line 664: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);

660: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
661:
662: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
663: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
664: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
665: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
666:
667: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
668: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;

Line 665: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);

661:
662: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'grace_date='||ld_grace_date);
663: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
664: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
665: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
666:
667: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
668: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
669: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;

Line 671: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);

667: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
668: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
669: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
670:
671: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
672: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
673: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
674: r_reversal_gt.SERIAL_NUM := ln_serial_num;
675: r_reversal_gt.INVOICE_NUM := r_standard_ap.invoice_num;

Line 672: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);

668: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
669: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
670:
671: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
672: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
673: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
674: r_reversal_gt.SERIAL_NUM := ln_serial_num;
675: r_reversal_gt.INVOICE_NUM := r_standard_ap.invoice_num;
676: r_reversal_gt.LINE_NUMBER := r_standard_ap.invoice_line_number;

Line 673: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);

669: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
670:
671: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
672: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
673: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
674: r_reversal_gt.SERIAL_NUM := ln_serial_num;
675: r_reversal_gt.INVOICE_NUM := r_standard_ap.invoice_num;
676: r_reversal_gt.LINE_NUMBER := r_standard_ap.invoice_line_number;
677: r_reversal_gt.ACCOUNTING_DATE := r_standard_ap.accounting_date;

Line 704: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_matched_ap.invoice_id);

700: ,pd_invoice_date
701: ,ld_new_as_of_date)
702:
703: LOOP
704: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_matched_ap.invoice_id);
705: IF lv_reversal_unit = 'DAY' THEN
706: ld_grace_date := r_matched_ap.accounting_date + ln_reversal_num;
707: ELSE
708: SELECT add_months(r_matched_ap.accounting_date,ln_reversal_num) INTO ld_grace_date FROM dual;

Line 747: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);

743: CLOSE c_sum_all_tax_amt_matched;
744:
745: ln_original_line_amt := r_matched_ap.line_amount + ln_sum_tax_amt;
746:
747: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);
748: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);
749: OPEN c_sum_rv_st_tax_amt_matched(r_matched_ap.invoice_id, r_matched_ap.line_number,ld_new_as_of_date,r_matched_ap.match_type);
750: FETCH c_sum_rv_st_tax_amt_matched INTO ln_rcv_st_amt;
751: CLOSE c_sum_rv_st_tax_amt_matched;

Line 748: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);

744:
745: ln_original_line_amt := r_matched_ap.line_amount + ln_sum_tax_amt;
746:
747: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_sum_tax_amt='||ln_sum_tax_amt);
748: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);
749: OPEN c_sum_rv_st_tax_amt_matched(r_matched_ap.invoice_id, r_matched_ap.line_number,ld_new_as_of_date,r_matched_ap.match_type);
750: FETCH c_sum_rv_st_tax_amt_matched INTO ln_rcv_st_amt;
751: CLOSE c_sum_rv_st_tax_amt_matched;
752:

Line 766: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);

762: FETCH c_prepaid_amt INTO ln_prepaid_amt;
763: CLOSE c_prepaid_amt;
764:
765: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
766: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
767: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
768: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
769:
770: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;

Line 767: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);

763: CLOSE c_prepaid_amt;
764:
765: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
766: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
767: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
768: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
769:
770: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
771: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;

Line 768: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);

764:
765: ln_paid_amt := nvl(ln_paid_amt,0) + nvl (ln_prepaid_amt,0);
766: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
767: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
768: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
769:
770: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
771: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
772: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;

Line 774: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);

770: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
771: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
772: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
773:
774: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
775: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
776: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
777: r_reversal_gt.SERIAL_NUM := ln_serial_num;
778: r_reversal_gt.INVOICE_NUM := r_matched_ap.invoice_num;

Line 775: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);

771: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
772: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
773:
774: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
775: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
776: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
777: r_reversal_gt.SERIAL_NUM := ln_serial_num;
778: r_reversal_gt.INVOICE_NUM := r_matched_ap.invoice_num;
779: r_reversal_gt.LINE_NUMBER := r_matched_ap.line_number;

Line 776: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);

772: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
773:
774: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
775: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
776: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
777: r_reversal_gt.SERIAL_NUM := ln_serial_num;
778: r_reversal_gt.INVOICE_NUM := r_matched_ap.invoice_num;
779: r_reversal_gt.LINE_NUMBER := r_matched_ap.line_number;
780: r_reversal_gt.match_type := r_matched_ap.match_type;

Line 798: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'Process or AR invoices.');

794: ln_serial_num := ln_serial_num + 1;
795: END IF;
796: END LOOP;
797: ELSE
798: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'Process or AR invoices.');
799: FOR r_ar IN c_ar( ld_accrual_date
800: ,pn_organization_id
801: ,pn_location_id
802: ,pn_vendor_id

Line 809: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_ar.invoice_id);

805: ,pd_invoice_date
806: ,ld_new_as_of_date)
807:
808: LOOP
809: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'invoice_id='||r_ar.invoice_id);
810: OPEN c_total_ar_amount(r_ar.invoice_id);
811: FETCH c_total_ar_amount INTO ln_total_amt,ln_un_applied_amt;
812: CLOSE c_total_ar_amount;
813:

Line 830: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);

826: OPEN c_total_ar_line_amount(r_ar.invoice_id, r_ar.line_number,ld_new_as_of_date);
827: FETCH c_total_ar_line_amount INTO ln_original_line_amt;
828: CLOSE c_total_ar_line_amount;
829:
830: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_original_line_amt='||ln_original_line_amt);
831: ln_rcv_st_amt := 0;
832: FOR r_ar_rc_st_amount IN c_ar_rc_st_amount(r_ar.invoice_id, r_ar.line_number,ld_new_as_of_date)
833: LOOP
834: ln_rcv_st_amt := ln_rcv_st_amt + r_ar_rc_st_amount.tax_amount * r_ar_rc_st_amount.mod_cr_percentage/100;

Line 837: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);

833: LOOP
834: ln_rcv_st_amt := ln_rcv_st_amt + r_ar_rc_st_amount.tax_amount * r_ar_rc_st_amount.mod_cr_percentage/100;
835: END LOOP;
836:
837: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
838: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
839: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
840:
841: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;

Line 838: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);

834: ln_rcv_st_amt := ln_rcv_st_amt + r_ar_rc_st_amount.tax_amount * r_ar_rc_st_amount.mod_cr_percentage/100;
835: END LOOP;
836:
837: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
838: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
839: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
840:
841: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
842: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;

Line 839: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);

835: END LOOP;
836:
837: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_rcv_st_amt='||ln_rcv_st_amt);
838: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_total_amt='||ln_total_amt);
839: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_paid_amt='||ln_paid_amt);
840:
841: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
842: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
843: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;

Line 845: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);

841: ln_unpaid_pctg := 1 - ln_paid_amt/ln_total_amt;
842: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
843: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
844:
845: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
846: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
847: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
848: r_reversal_gt.SERIAL_NUM := ln_serial_num;
849: r_reversal_gt.INVOICE_NUM := r_ar.invoice_number;

Line 846: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);

842: ln_open_amt := ln_original_line_amt * ln_unpaid_pctg;
843: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
844:
845: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
846: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
847: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
848: r_reversal_gt.SERIAL_NUM := ln_serial_num;
849: r_reversal_gt.INVOICE_NUM := r_ar.invoice_number;
850: r_reversal_gt.LINE_NUMBER := r_ar.line_number;

Line 847: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);

843: ln_tax_to_be_adjusted := ln_rcv_st_amt * ln_unpaid_pctg;
844:
845: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_unpaid_pctg='||ln_unpaid_pctg);
846: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_open_amt='||ln_open_amt);
847: jai_cmn_debug_contexts_pkg.print (ln_reg_id,'ln_tax_to_be_adjusted='||ln_tax_to_be_adjusted);
848: r_reversal_gt.SERIAL_NUM := ln_serial_num;
849: r_reversal_gt.INVOICE_NUM := r_ar.invoice_number;
850: r_reversal_gt.LINE_NUMBER := r_ar.line_number;
851: r_reversal_gt.ACCOUNTING_DATE := r_ar.gl_date;

Line 874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);

870: exception
871: when others then
872: p_process_flag := jai_constants.unexpected_error;
873: p_process_message := lv_context||'->'||sqlerrm;
874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
875: jai_cmn_debug_contexts_pkg.print_stack;
876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS

Line 875: jai_cmn_debug_contexts_pkg.print_stack;

871: when others then
872: p_process_flag := jai_constants.unexpected_error;
873: p_process_message := lv_context||'->'||sqlerrm;
874: jai_cmn_debug_contexts_pkg.print(ln_reg_id,lv_context||'->'||sqlerrm,jai_cmn_debug_contexts_pkg.summary);
875: jai_cmn_debug_contexts_pkg.print_stack;
876: END extract_reversal_trxs;
877:
878: PROCEDURE insert_trxs (r_reversal_trx JAI_ST_INVOICE_REVERSAL_GT%ROWTYPE) IS
879: BEGIN