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_AP_TDS_PROCESSING_PKG dependencies on FND_FILE

Line 549: Fnd_File.put_line(Fnd_File.LOG, ' Start of procedure jai_ap_tds_processing_pkg.process_tds_payments ');

545: begin
546:
547:
548: /* Get the statis fnd values for populating into the table */
549: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
550: ln_record_count := 0;
551: ln_user_id := fnd_global.user_id;
552: ln_last_update_login := fnd_global.login_id ;
553: ln_program_id := fnd_global.conc_program_id ;

Line 565: Fnd_File.put_line(Fnd_File.LOG, ' Flushing the data as regenration option is set to Yes');

561: /* Check regenerate option */
562: if pv_regenerate_flag = lv_pv_regenerate_flag then
563:
564: /* Flush the check records that have been processed earlier but are not paid */
565: Fnd_File.put_line(Fnd_File.LOG, ' Flushing the data as regenration option is set to Yes');
566: delete JAI_AP_TDS_INV_PAYMENTS
567: where check_id in
568: (
569: select

Line 599: Fnd_File.put_line(Fnd_File.LOG, ' No of records flushed : ' || to_char(sql%rowcount) );

595: and nvl(jitc.section_code,'XYZ') = nvl(pv_tds_section,nvl(jitc.section_code,'XYZ')) /*bduvarag for Bug#5647725*/
596: )
597: and form16_hdr_id is null;
598:
599: Fnd_File.put_line(Fnd_File.LOG, ' No of records flushed : ' || to_char(sql%rowcount) );
600:
601: end if; /*if pv_regenerate_flag = 'Y' */
602:
603:

Line 605: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Payment **');

601: end if; /*if pv_regenerate_flag = 'Y' */
602:
603:
604: /* Get all payments from ap_checks_all */
605: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Payment **');
606: for cur_rec in
607: c_process_tds_payments
608: (
609: ld_tds_payment_from_date ,

Line 620: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );

616: pn_vendor_site_id
617: )
618: loop
619:
620: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );
621:
622: ln_taxable_basis := cur_rec.taxable_basis;
623: lv_parent_invoice_cancel_flag := null;
624:

Line 716: --Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS clean up if any **');

712: end loop; /* process tds payments */
713:
714:
715: /* Check for invoices generated prior to TDS threshold patch */
716: --Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS clean up if any **');
717: --commented the above and added the below by Sanjikum for Bug#5219225
718: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS Threshold if any **');
719:
720: for cur_rec in

Line 718: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS Threshold if any **');

714:
715: /* Check for invoices generated prior to TDS threshold patch */
716: --Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS clean up if any **');
717: --commented the above and added the below by Sanjikum for Bug#5219225
718: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS Threshold if any **');
719:
720: for cur_rec in
721: c_process_old_tds_payments
722: (

Line 731: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );

727: pn_tds_authority_site_id
728: )
729: loop
730:
731: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );
732: ln_parent_invoice_id := null;
733: lv_parent_invoice_cancel_flag := null;
734: lv_section_code := null;
735: ln_tax_id := null;

Line 904: Fnd_File.put_line(Fnd_File.LOG, 'Processing Prepayment if any ');

900:
901: end loop; /* c_process_old_tds_payments */
902:
903: /* Payemnt by Prepayments */
904: Fnd_File.put_line(Fnd_File.LOG, 'Processing Prepayment if any ');
905:
906: for cur_rec in
907: c_tds_invoice_paid_by_prepay
908: (

Line 917: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Prepayment invoice id : ' || cur_rec.invoice_num || ' / ' || cur_rec.prepay_invoice_id );

913: pn_tds_authority_site_id
914: )
915: loop
916:
917: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Prepayment invoice id : ' || cur_rec.invoice_num || ' / ' || cur_rec.prepay_invoice_id );
918:
919: ln_threshold_trx_id := null;
920: ln_parent_invoice_id := null;
921: lv_parent_invoice_cancel_flag := null;

Line 1176: Fnd_File.put_line(Fnd_File.LOG, 'No of records inserted into JAI_AP_TDS_INV_PAYMENTS : ' || to_char(ln_record_count));

1172: END LOOP ;
1173: /* END, Bgowrava for Bug#6069891*/
1174:
1175: <>
1176: Fnd_File.put_line(Fnd_File.LOG, 'No of records inserted into JAI_AP_TDS_INV_PAYMENTS : ' || to_char(ln_record_count));
1177: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1178:
1179: return;
1180:

Line 1177: Fnd_File.put_line(Fnd_File.LOG, ' Successful End of procedure jai_ap_tds_processing_pkg.process_tds_payments ');

1173: /* END, Bgowrava for Bug#6069891*/
1174:
1175: <>
1176: Fnd_File.put_line(Fnd_File.LOG, 'No of records inserted into JAI_AP_TDS_INV_PAYMENTS : ' || to_char(ln_record_count));
1177: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1178:
1179: return;
1180:
1181: exception

Line 1185: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);

1181: exception
1182: when others then
1183: retcode := 2;
1184: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm;
1185: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1186: Fnd_File.put_line(Fnd_File.LOG, '** Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1187:
1188: end process_tds_payments;
1189: /* ******************************** process_tds_payments ******************************************* */

Line 1186: Fnd_File.put_line(Fnd_File.LOG, ' Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments ');

1182: when others then
1183: retcode := 2;
1184: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm;
1185: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1186: Fnd_File.put_line(Fnd_File.LOG, '** Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1187:
1188: end process_tds_payments;
1189: /* ******************************** process_tds_payments ******************************************* */
1190:

Line 1449: Fnd_File.put_line(Fnd_File.LOG, ' Start of procedure jai_ap_tds_processing_pkg.process_tds_certificates ');

1445:
1446: begin
1447:
1448: /* Get the statis fnd values for populating into the table */
1449: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1450:
1451: ln_user_id := fnd_global.user_id ;
1452: ln_last_update_login := fnd_global.login_id ;
1453: ln_program_id := fnd_global.conc_program_id ;

Line 1485: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_from_date : ' || ld_tds_payment_from_date);

1481: /*Bug 10621438 - Replaced parameters with derived dates*/
1482: ld_tds_payment_from_date := ld_start_date;--Date 12-jun-2007 sacsethi for bug 6119195
1483: ld_tds_payment_to_date := ld_end_date;--Date 12-jun-2007 sacsethi for bug 6119195
1484:
1485: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_from_date : ' || ld_tds_payment_from_date);
1486: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_to_date : ' || ld_tds_payment_to_date);
1487:
1488: /*bduvarag for Bug#5647725 start*/
1489:

Line 1486: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_to_date : ' || ld_tds_payment_to_date);

1482: ld_tds_payment_from_date := ld_start_date;--Date 12-jun-2007 sacsethi for bug 6119195
1483: ld_tds_payment_to_date := ld_end_date;--Date 12-jun-2007 sacsethi for bug 6119195
1484:
1485: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_from_date : ' || ld_tds_payment_from_date);
1486: Fnd_File.put_line(Fnd_File.LOG, 'ld_tds_payment_to_date : ' || ld_tds_payment_to_date);
1487:
1488: /*bduvarag for Bug#5647725 start*/
1489:
1490: OPEN cur_get_tds_section;

Line 1516: Fnd_File.put_line(Fnd_File.LOG, 'Processing operating unit : ' || cur_ou.operating_unit_id);

1512: )
1513: loop
1514:
1515:
1516: Fnd_File.put_line(Fnd_File.LOG, 'Processing operating unit : ' || cur_ou.operating_unit_id);
1517:
1518: --Commented below by Bgowrava for Bug#6129650
1519: /*
1520: open c_hr_operating_units(cur_ou.operating_unit_id);

Line 1538: Fnd_File.put_line(Fnd_File.LOG, 'Processing cur_invoice_date : ' || cur_invoice_date.invoice_date);

1534: pn_vendor_site_id ,
1535: cur_ou.operating_unit_id
1536: )
1537: loop
1538: Fnd_File.put_line(Fnd_File.LOG, 'Processing cur_invoice_date : ' || cur_invoice_date.invoice_date);
1539:
1540: open c_ja_in_tds_year_info(cur_ou.operating_unit_id, cur_invoice_date.invoice_date); --changed r_hr_operating_units.default_legal_context_id to cur_ou.operating_unit_id for Bug#6129650
1541: fetch c_ja_in_tds_year_info into r_ja_in_tds_year_info;
1542: close c_ja_in_tds_year_info;

Line 1544: Fnd_File.put_line(Fnd_File.LOG, 'Updating ' || r_ja_in_tds_year_info.fin_year);

1540: open c_ja_in_tds_year_info(cur_ou.operating_unit_id, cur_invoice_date.invoice_date); --changed r_hr_operating_units.default_legal_context_id to cur_ou.operating_unit_id for Bug#6129650
1541: fetch c_ja_in_tds_year_info into r_ja_in_tds_year_info;
1542: close c_ja_in_tds_year_info;
1543:
1544: Fnd_File.put_line(Fnd_File.LOG, 'Updating ' || r_ja_in_tds_year_info.fin_year);
1545:
1546: update jai_ap_tds_inv_payments
1547: set fin_year = r_ja_in_tds_year_info.fin_year
1548: where parent_invoice_id is not null

Line 1568: Fnd_File.put_line(Fnd_File.LOG, ' No of records updated with Fin year : ' || to_char(sql%rowcount) );

1564: );/*bduvarag for Bug#5647725*/
1565:
1566:
1567:
1568: Fnd_File.put_line(Fnd_File.LOG, ' No of records updated with Fin year : ' || to_char(sql%rowcount) );
1569:
1570: end loop; /*c_get_distinct_invoice_date */
1571:
1572:

Line 1622: Fnd_File.put_line(Fnd_File.LOG, ' Generating Certificates ' );

1618: END LOOP; /*c_group_for_no_certificate*/
1619: /*Bug 5647725 end bduvarag*/
1620: /* Group for TDS Certificates */
1621:
1622: Fnd_File.put_line(Fnd_File.LOG, ' Generating Certificates ' );
1623:
1624: for cur_rec in
1625: c_group_for_certificate
1626: (

Line 1688: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);

1684: FETCH c_get_cert_date INTO ld_cert_date;
1685: CLOSE c_get_cert_date;
1686: /*Bug 10621438 - Fetch the MAX Invoice Date of all the Payments in the Certificate - End*/
1687:
1688: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
1689: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1690: ln_certificate_count := ln_certificate_count + 1;
1691:
1692: if ln_certificate_num = 1 then

Line 1689: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );

1685: CLOSE c_get_cert_date;
1686: /*Bug 10621438 - Fetch the MAX Invoice Date of all the Payments in the Certificate - End*/
1687:
1688: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
1689: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1690: ln_certificate_count := ln_certificate_count + 1;
1691:
1692: if ln_certificate_num = 1 then
1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');

Line 1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');

1689: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1690: ln_certificate_count := ln_certificate_count + 1;
1691:
1692: if ln_certificate_num = 1 then
1693: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1694: insert into jai_ap_tds_cert_nums
1695: (
1696: fin_yr_cert_id ,
1697: regime_code ,

Line 1723: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');

1719: );
1720:
1721: else
1722:
1723: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1724: update jai_ap_tds_cert_nums
1725: set certificate_num = ln_certificate_num
1726: where org_tan_num = pv_org_tan_num
1727: and fin_yr = cur_rec.fin_year

Line 1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));

1730: end if;
1731:
1732: /* insert into jai_ap_tds_f16_hdrs_all */
1733: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1734: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in jai_ap_tds_f16_hdrs_all with form16_hdr_id : ' || to_char(ln_form16_hdr_id));
1735: insert into jai_ap_tds_f16_hdrs_all
1736: (
1737: form16_hdr_id ,
1738: fin_yr ,

Line 1797: Fnd_File.put_line(Fnd_File.LOG, 'Puching certificate line numbers ');

1793: ln_prev_parent_invoice_id := -9999;
1794: -- lv_prev_tds_event := 'INITIAL';
1795: /*Bug 5647725 bduvarag*/
1796:
1797: Fnd_File.put_line(Fnd_File.LOG, 'Puching certificate line numbers ');
1798:
1799: for tds_payment in c_form16_cert_lines(ln_form16_hdr_id)
1800: loop
1801:

Line 1822: Fnd_File.put_line(Fnd_File.LOG, 'Line number / No of records for the line :'

1818: update jai_ap_tds_inv_payments
1819: set certificate_line_num = ln_cert_line_num
1820: where current of c_form16_cert_lines;
1821:
1822: Fnd_File.put_line(Fnd_File.LOG, 'Line number / No of records for the line :'
1823: || to_char(ln_cert_line_num) || ' / ' || to_char(sql%rowcount) );
1824: end loop;
1825:
1826:

Line 1834: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));

1830: end loop; /* c_group_for_certificate */
1831:
1832:
1833: <>
1834: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
1835: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1836:
1837: return;
1838:

Line 1835: Fnd_File.put_line(Fnd_File.LOG, ' Successful End of procedure jai_ap_tds_processing_pkg.process_tds_certificates ');

1831:
1832:
1833: <>
1834: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
1835: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1836:
1837: return;
1838:
1839: exception

Line 1843: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);

1839: exception
1840: when others then
1841: retcode := 2;
1842: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_certificates : ' || sqlerrm;
1843: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1844:
1845: end process_tds_certificates;
1846: /* ****************************** process_tds_certificates ***************************************** */
1847: /* End added for bug#4448293 */