DBA Data[Home] [Help]

APPS.PAY_ZA_TYE_ARCHIVE_PKG dependencies on FND_FILE

Line 537: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);

533: l_asg_set_id number;
534: l_person_id number;
535:
536: begin
537: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
538: hr_utility.set_location('Entering '||l_proc,10);
539:
540: -- Archive Legal Entity Level (Employer) Information
541:

Line 552: fnd_file.put_line (fnd_file.LOG, '$$$ PERIOD_RECON '||l_period_recon);

548: l_legal_entity_org := get_parameter('LEGAL_ENTITY', leg_param);
549: l_tax_year := get_parameter('TAX_YEAR', leg_param);
550: l_cert_type_param := get_parameter('CERT_TYPE', leg_param);
551: l_period_recon := NVL(get_parameter('PERIOD_RECON',leg_param),'02'); -- 9877034 fix
552: fnd_file.put_line (fnd_file.LOG, '$$$ PERIOD_RECON '||l_period_recon);
553:
554: l_asg_set_id := get_parameter('ASG_SET_ID', leg_param);
555: l_person_id := get_parameter('PERSON_ID', leg_param);
556:

Line 670: fnd_file.put_line(fnd_file.log,'sql_range:' ||sql_range);

666: end if;
667:
668: sql_range := sql_range|| ' ORDER BY paf.person_id';
669:
670: fnd_file.put_line(fnd_file.log,'sql_range:' ||sql_range);
671:
672: sqlstr := sql_range;
673: hr_utility.set_location('Leaving '||l_proc,999);
674: end ;

Line 811: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);

807: BEGIN
808:
809: -- hr_utility.trace_on(null,'ZATRC');
810: hr_utility.set_location('Entering '||l_proc, 10);
811: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
812:
813: -- Get the legislative parameters from the archiver payroll action
814: select legislative_parameters,payroll_id
815: into leg_param,l_ppa_payroll_id

Line 1216: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);

1212:
1213: begin
1214: null;
1215: -- hr_utility.trace_on(null,'ZATRC');
1216: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
1217: hr_utility.set_location('Entering '||l_proc,1);
1218: hr_utility.set_location('p_assactid : '||p_assactid,1);
1219: hr_utility.set_location('p_effective_date : '||p_effective_date,1);
1220: ------------------------------------------------------------------------

Line 2330: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);

2326: l_itreg_batch varchar2(1);
2327: l_itreg_cert_num varchar2(30) := lpad('0',30,'0');
2328: l_period_recon varchar2(30); -- 9877034 fix
2329: begin
2330: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
2331:
2332: hr_utility.set_location('Entering '|| l_proc,10);
2333:
2334: select legislative_parameters

Line 2391: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unable to Create Tax Certificate Exception Log');

2387: '','','','','','','','','','',
2388: '','','','','','','','','');
2389:
2390: IF (l_req_id = 0) THEN
2391: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Unable to Create Tax Certificate Exception Log');
2392: END IF;
2393:
2394: hr_utility.set_location('Leaving '|| l_proc,999);
2395:

Line 2486: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);

2482: l_normal_count number := 1;
2483: l_def_bal_id number;
2484: l_proc varchar2(100) := g_package||'set_code_tables';
2485: begin
2486: fnd_file.put_line(fnd_file.log,'inside ' ||l_proc);
2487: hr_utility.set_location('Entering '|| l_proc,10);
2488:
2489: for code_rec in csr_code_details
2490: loop

Line 2778: fnd_file.put_line (fnd_file.LOG, '$$$ l_period_recon_last_date '||l_period_recon_last_date);

2774: select last_day(decode(l_period_recon, '02', to_date(l_tax_year||'-02-01','yyyy-mm-dd'), '08', to_date(l_tax_year-1 ||'-08-01','yyyy-mm-dd')))
2775: into l_period_recon_last_date
2776: from dual;
2777:
2778: fnd_file.put_line (fnd_file.LOG, '$$$ l_period_recon_last_date '||l_period_recon_last_date);
2779: -- 9877034 ends
2780:
2781: -- fetch person and assignment details
2782: open csr_asg_info;

Line 2858: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_end_date '||l_tax_year_end_date);

2854: where payroll_id = l_payroll_id
2855: and prd_information1 = l_tax_year
2856: and end_date <= l_period_recon_last_date;
2857: end if;
2858: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_end_date '||l_tax_year_end_date);
2859: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_start_date '||l_tax_year_start_date);
2860: -- 9877034 ends
2861:
2862: l_days_in_tax_year := l_tax_year_end_date - l_tax_year_start_date + 1 ;

Line 2859: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_start_date '||l_tax_year_start_date);

2855: and prd_information1 = l_tax_year
2856: and end_date <= l_period_recon_last_date;
2857: end if;
2858: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_end_date '||l_tax_year_end_date);
2859: fnd_file.put_line (fnd_file.LOG, '$$$ l_tax_year_start_date '||l_tax_year_start_date);
2860: -- 9877034 ends
2861:
2862: l_days_in_tax_year := l_tax_year_end_date - l_tax_year_start_date + 1 ;
2863: