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 536: Fnd_File.put_line(Fnd_File.LOG, ' Start of procedure jai_ap_tds_processing_pkg.process_tds_payments ');

532: begin
533:
534:
535: /* Get the statis fnd values for populating into the table */
536: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
537: ln_record_count := 0;
538: ln_user_id := fnd_global.user_id;
539: ln_last_update_login := fnd_global.login_id ;
540: ln_program_id := fnd_global.conc_program_id ;

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

548: /* Check regenerate option */
549: if pv_regenerate_flag = lv_pv_regenerate_flag then
550:
551: /* Flush the check records that have been processed earlier but are not paid */
552: Fnd_File.put_line(Fnd_File.LOG, ' Flushing the data as regenration option is set to Yes');
553: delete JAI_AP_TDS_INV_PAYMENTS
554: where check_id in
555: (
556: select

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

582: and nvl(jitc.section_code,'XYZ') = nvl(pv_tds_section,nvl(jitc.section_code,'XYZ')) /*bduvarag for Bug#5647725*/
583: )
584: and form16_hdr_id is null;
585:
586: Fnd_File.put_line(Fnd_File.LOG, ' No of records flushed : ' || to_char(sql%rowcount) );
587:
588: end if; /*if pv_regenerate_flag = 'Y' */
589:
590:

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

588: end if; /*if pv_regenerate_flag = 'Y' */
589:
590:
591: /* Get all payments from ap_checks_all */
592: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Payment **');
593: for cur_rec in
594: c_process_tds_payments
595: (
596: ld_tds_payment_from_date ,

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

603: pn_vendor_site_id
604: )
605: loop
606:
607: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );
608:
609: ln_taxable_basis := cur_rec.taxable_basis;
610: lv_parent_invoice_cancel_flag := null;
611:

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

699: end loop; /* process tds payments */
700:
701:
702: /* Check for invoices generated prior to TDS threshold patch */
703: --Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS clean up if any **');
704: --commented the above and added the below by Sanjikum for Bug#5219225
705: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS Threshold if any **');
706:
707: for cur_rec in

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

701:
702: /* Check for invoices generated prior to TDS threshold patch */
703: --Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS clean up if any **');
704: --commented the above and added the below by Sanjikum for Bug#5219225
705: Fnd_File.put_line(Fnd_File.LOG, 'Start Processing Invoices created prior to TDS Threshold if any **');
706:
707: for cur_rec in
708: c_process_old_tds_payments
709: (

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

714: pn_tds_authority_site_id
715: )
716: loop
717:
718: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Check : ' || cur_rec.invoice_num || ' / ' || cur_rec.check_number );
719: ln_parent_invoice_id := null;
720: lv_parent_invoice_cancel_flag := null;
721: lv_section_code := null;
722: ln_tax_id := null;

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

887:
888: end loop; /* c_process_old_tds_payments */
889:
890: /* Payemnt by Prepayments */
891: Fnd_File.put_line(Fnd_File.LOG, 'Processing Prepayment if any ');
892:
893: for cur_rec in
894: c_tds_invoice_paid_by_prepay
895: (

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

900: pn_tds_authority_site_id
901: )
902: loop
903:
904: Fnd_File.put_line(Fnd_File.LOG, ' Processing Invoice / Prepayment invoice id : ' || cur_rec.invoice_num || ' / ' || cur_rec.prepay_invoice_id );
905:
906: ln_threshold_trx_id := null;
907: ln_parent_invoice_id := null;
908: lv_parent_invoice_cancel_flag := null;

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

1159: END LOOP ;
1160: /* END, Bgowrava for Bug#6069891*/
1161:
1162: <>
1163: Fnd_File.put_line(Fnd_File.LOG, 'No of records inserted into JAI_AP_TDS_INV_PAYMENTS : ' || to_char(ln_record_count));
1164: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1165:
1166: return;
1167:

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

1160: /* END, Bgowrava for Bug#6069891*/
1161:
1162: <>
1163: Fnd_File.put_line(Fnd_File.LOG, 'No of records inserted into JAI_AP_TDS_INV_PAYMENTS : ' || to_char(ln_record_count));
1164: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1165:
1166: return;
1167:
1168: exception

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

1168: exception
1169: when others then
1170: retcode := 2;
1171: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm;
1172: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1173: Fnd_File.put_line(Fnd_File.LOG, '** Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1174:
1175: end process_tds_payments;
1176: /* ******************************** process_tds_payments ******************************************* */

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

1169: when others then
1170: retcode := 2;
1171: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm;
1172: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1173: Fnd_File.put_line(Fnd_File.LOG, '** Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments **');
1174:
1175: end process_tds_payments;
1176: /* ******************************** process_tds_payments ******************************************* */
1177:

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

1413:
1414: begin
1415:
1416: /* Get the statis fnd values for populating into the table */
1417: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1418:
1419: ln_user_id := fnd_global.user_id ;
1420: ln_last_update_login := fnd_global.login_id ;
1421: ln_program_id := fnd_global.conc_program_id ;

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

1455: )
1456: loop
1457:
1458:
1459: Fnd_File.put_line(Fnd_File.LOG, 'Processing operating unit : ' || cur_ou.operating_unit_id);
1460:
1461: --Commented below by Bgowrava for Bug#6129650
1462: /*
1463: open c_hr_operating_units(cur_ou.operating_unit_id);

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

1477: pn_vendor_site_id ,
1478: cur_ou.operating_unit_id
1479: )
1480: loop
1481: Fnd_File.put_line(Fnd_File.LOG, 'Processing cur_invoice_date : ' || cur_invoice_date.invoice_date);
1482:
1483: 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
1484: fetch c_ja_in_tds_year_info into r_ja_in_tds_year_info;
1485: close c_ja_in_tds_year_info;

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

1483: 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
1484: fetch c_ja_in_tds_year_info into r_ja_in_tds_year_info;
1485: close c_ja_in_tds_year_info;
1486:
1487: Fnd_File.put_line(Fnd_File.LOG, 'Updating ' || r_ja_in_tds_year_info.fin_year);
1488:
1489: update jai_ap_tds_inv_payments
1490: set fin_year = r_ja_in_tds_year_info.fin_year
1491: where parent_invoice_id is not null

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

1507: );/*bduvarag for Bug#5647725*/
1508:
1509:
1510:
1511: Fnd_File.put_line(Fnd_File.LOG, ' No of records updated with Fin year : ' || to_char(sql%rowcount) );
1512:
1513: end loop; /*c_get_distinct_invoice_date */
1514:
1515:

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

1561: END LOOP; /*c_group_for_no_certificate*/
1562: /*Bug 5647725 end bduvarag*/
1563: /* Group for TDS Certificates */
1564:
1565: Fnd_File.put_line(Fnd_File.LOG, ' Generating Certificates ' );
1566:
1567: for cur_rec in
1568: c_group_for_certificate
1569: (

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

1619: if sql%rowcount = 0 then
1620: goto continue_with_next_certificate;
1621: end if;
1622:
1623: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
1624: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1625: ln_certificate_count := ln_certificate_count + 1;
1626:
1627: if ln_certificate_num = 1 then

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

1620: goto continue_with_next_certificate;
1621: end if;
1622:
1623: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
1624: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1625: ln_certificate_count := ln_certificate_count + 1;
1626:
1627: if ln_certificate_num = 1 then
1628: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');

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

1624: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
1625: ln_certificate_count := ln_certificate_count + 1;
1626:
1627: if ln_certificate_num = 1 then
1628: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
1629: insert into jai_ap_tds_cert_nums
1630: (
1631: fin_yr_cert_id ,
1632: regime_code ,

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

1654: );
1655:
1656: else
1657:
1658: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
1659: update jai_ap_tds_cert_nums
1660: set certificate_num = ln_certificate_num
1661: where org_tan_num = pv_org_tan_num
1662: and fin_yr = cur_rec.fin_year

Line 1669: 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));

1665: end if;
1666:
1667: /* insert into jai_ap_tds_f16_hdrs_all */
1668: IF lv_tds_section = 'TDS' THEN/*bduvarag for Bug#5647725*/
1669: 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));
1670: insert into jai_ap_tds_f16_hdrs_all
1671: (
1672: form16_hdr_id ,
1673: fin_yr ,

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

1728: ln_prev_parent_invoice_id := -9999;
1729: -- lv_prev_tds_event := 'INITIAL';
1730: /*Bug 5647725 bduvarag*/
1731:
1732: Fnd_File.put_line(Fnd_File.LOG, 'Puching certificate line numbers ');
1733:
1734: for tds_payment in c_form16_cert_lines(ln_form16_hdr_id)
1735: loop
1736:

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

1753: update jai_ap_tds_inv_payments
1754: set certificate_line_num = ln_cert_line_num
1755: where current of c_form16_cert_lines;
1756:
1757: Fnd_File.put_line(Fnd_File.LOG, 'Line number / No of records for the line :'
1758: || to_char(ln_cert_line_num) || ' / ' || to_char(sql%rowcount) );
1759: end loop;
1760:
1761:

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

1765: end loop; /* c_group_for_certificate */
1766:
1767:
1768: <>
1769: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
1770: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1771:
1772: return;
1773:

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

1766:
1767:
1768: <>
1769: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
1770: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tds_processing_pkg.process_tds_certificates **');
1771:
1772: return;
1773:
1774: exception

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

1774: exception
1775: when others then
1776: retcode := 2;
1777: errbuf := 'Error from jai_ap_tds_processing_pkg.process_tds_certificates : ' || sqlerrm;
1778: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tds_processing_pkg.process_tds_payments : ' || sqlerrm);
1779:
1780: end process_tds_certificates;
1781: /* ****************************** process_tds_certificates ***************************************** */
1782: /* End added for bug#4448293 */