APPS.JAI_AP_TCS_PROCESSING_PKG dependencies on FND_FILE

Line 141: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');

137: begin
138: /* */
139:
140: /* Get the statis fnd values for populating into the table */
141: Fnd_File.put_line(Fnd_File.LOG, '** Start of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
142:
143: ln_user_id := fnd_global.user_id ;
144: ln_last_update_login := fnd_global.login_id ;
145: ln_program_id := fnd_global.conc_program_id ;

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

155: CLOSE cur_regime_id;
156:
157: /* Group for TCS Certificates */
158:
159: Fnd_File.put_line(Fnd_File.LOG, ' Generating Certificates ' );
160:
161: for cur_rec in
162: c_group_for_certificate
163: (

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

207: if sql%rowcount = 0 then
208: goto continue_with_next_certificate;
209: end if;
210:
211: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
212: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
213: ln_certificate_count := ln_certificate_count + 1;
214:
215: if ln_certificate_num = 1 then

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

208: goto continue_with_next_certificate;
209: end if;
210:
211: Fnd_File.put_line(Fnd_File.LOG, 'Certificate Number : ' || ln_certificate_num);
212: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
213: ln_certificate_count := ln_certificate_count + 1;
214:
215: if ln_certificate_num = 1 then
216: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');

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

212: Fnd_File.put_line(Fnd_File.LOG, ' No of Records for the Certificate : ' || to_char(sql%rowcount) );
213: ln_certificate_count := ln_certificate_count + 1;
214:
215: if ln_certificate_num = 1 then
216: Fnd_File.put_line(Fnd_File.LOG, 'Created a certificate record in jai_ap_tds_cert_nums');
217: insert into jai_ap_tds_cert_nums
218: (
219: FIN_YR_CERT_ID , -- Date 22/06/2007 by sacsethi for bug 6144923
220: regime_code ,

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

243:
244: else
245:
246:
247: Fnd_File.put_line(Fnd_File.LOG, 'Updated certificate number in jai_ap_tds_cert_nums');
248: update jai_ap_tds_cert_nums
249: set certificate_num = ln_certificate_num
250: where org_tan_num = pv_org_tan_num
251: and fin_yr = cur_rec.fin_year

Line 256: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in JAI_RGM_CERTIFICATES with certificate_id : ' || to_char(ln_certificate_id));

252: and regime_code = jai_constants.tcs_regime;
253: end if;
254:
255: /* insert into JAI_RGM_CERTIFICATES */
256: Fnd_File.put_line(Fnd_File.LOG, 'Inserting record in JAI_RGM_CERTIFICATES with certificate_id : ' || to_char(ln_certificate_id));
257:
258: INSERT INTO
259: jai_rgm_certificates( CERTIFICATE_ID ,
260: CERTIFICATE_NUM ,

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

316: end loop; /* c_group_for_certificate */
317:
318:
319: <>
320: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
321: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
322:
323: return;
324:

Line 321: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');

317:
318:
319: <>
320: Fnd_File.put_line(Fnd_File.LOG, 'No of Certificates Generated : ' || to_char(ln_certificate_count));
321: Fnd_File.put_line(Fnd_File.LOG, '** Successful End of procedure jai_ap_tcs_processing_pkg.generate_tcs_certificates **');
322:
323: return;
324:
325: exception

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

325: exception
326: when others then
327: retcode := 2;
328: errbuf := 'Error from jai_ap_tcs_processing_pkg.generate_tcs_certificates : ' || sqlerrm;
329: Fnd_File.put_line(Fnd_File.LOG, 'Error End of procedure jai_ap_tcs_processing_pkg.process_tds_payments : ' || sqlerrm);
330:
331: end generate_tcs_certificates;
332:
333: /* ****************************** generate_tcs_certificates ***************************************** */