1: package body jai_ap_tds_processing_pkg as
2: /* $Header: jai_ap_tds_prc.plb 120.11.12010000.3 2008/11/24 09:37:20 mbremkum ship $ */
3: /* ----------------------------------------------------------------------------
4: FILENAME : jai_ap_tds_prc.plb
5:
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 ;
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
1167:
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;
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 ******************************************* */
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:
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 ;
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
1773:
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 ***************************************** */
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 */
1780: end process_tds_certificates;
1781: /* ****************************** process_tds_certificates ***************************************** */
1782: /* End added for bug#4448293 */
1783:
1784: END jai_ap_tds_processing_pkg;