DBA Data[Home] [Help]

APPS.PAY_SE_TAX_DECL_REPORT dependencies on FND_FILE

Line 230: fnd_file.put_line(fnd_file.LOG,'before globals');

226: l_regular_Year:=rg_Tax_Decl.Year-65;
227: l_65_Year:=l_regular_Year-1;
228: l_Pension_Start:=rg_Tax_Decl.Year-25;
229: l_Pension_End:=rg_Tax_Decl.Year-19;
230: fnd_file.put_line(fnd_file.LOG,'before globals');
231: fnd_file.put_line(fnd_file.LOG,'l_effective_date'||l_effective_date);
232: OPEN csr_global('SE_EMPLOYER_TAX_PERC',l_effective_date);
233: FETCH csr_global INTO l_temp; --l_gen_tax_perc;
234: CLOSE csr_global;

Line 231: fnd_file.put_line(fnd_file.LOG,'l_effective_date'||l_effective_date);

227: l_65_Year:=l_regular_Year-1;
228: l_Pension_Start:=rg_Tax_Decl.Year-25;
229: l_Pension_End:=rg_Tax_Decl.Year-19;
230: fnd_file.put_line(fnd_file.LOG,'before globals');
231: fnd_file.put_line(fnd_file.LOG,'l_effective_date'||l_effective_date);
232: OPEN csr_global('SE_EMPLOYER_TAX_PERC',l_effective_date);
233: FETCH csr_global INTO l_temp; --l_gen_tax_perc;
234: CLOSE csr_global;
235: fnd_file.put_line(fnd_file.LOG,'l_temp'||l_temp);

Line 235: fnd_file.put_line(fnd_file.LOG,'l_temp'||l_temp);

231: fnd_file.put_line(fnd_file.LOG,'l_effective_date'||l_effective_date);
232: OPEN csr_global('SE_EMPLOYER_TAX_PERC',l_effective_date);
233: FETCH csr_global INTO l_temp; --l_gen_tax_perc;
234: CLOSE csr_global;
235: fnd_file.put_line(fnd_file.LOG,'l_temp'||l_temp);
236: l_gen_tax_perc:=l_temp;
237: fnd_file.put_line(fnd_file.LOG,'l_gen_tax_perc'||l_gen_tax_perc);
238: fnd_file.put_line(fnd_file.LOG,'after globals');
239:

Line 237: fnd_file.put_line(fnd_file.LOG,'l_gen_tax_perc'||l_gen_tax_perc);

233: FETCH csr_global INTO l_temp; --l_gen_tax_perc;
234: CLOSE csr_global;
235: fnd_file.put_line(fnd_file.LOG,'l_temp'||l_temp);
236: l_gen_tax_perc:=l_temp;
237: fnd_file.put_line(fnd_file.LOG,'l_gen_tax_perc'||l_gen_tax_perc);
238: fnd_file.put_line(fnd_file.LOG,'after globals');
239:
240: OPEN csr_global('SE_SIT_AGE_ABOVE_65',l_effective_date);
241: FETCH csr_global INTO l_spl_65_perc;

Line 238: fnd_file.put_line(fnd_file.LOG,'after globals');

234: CLOSE csr_global;
235: fnd_file.put_line(fnd_file.LOG,'l_temp'||l_temp);
236: l_gen_tax_perc:=l_temp;
237: fnd_file.put_line(fnd_file.LOG,'l_gen_tax_perc'||l_gen_tax_perc);
238: fnd_file.put_line(fnd_file.LOG,'after globals');
239:
240: OPEN csr_global('SE_SIT_AGE_ABOVE_65',l_effective_date);
241: FETCH csr_global INTO l_spl_65_perc;
242: CLOSE csr_global;

Line 1681: fnd_file.put_line(fnd_file.LOG,'p_xml'||p_xml);

1677: + 1;
1678:
1679: writetoclob (p_xml);
1680: --INSERT INTO raaj VALUES (p_xml);
1681: fnd_file.put_line(fnd_file.LOG,'p_xml'||p_xml);
1682:
1683: END get_data;
1684: -----------------------------------------------------------------------------------------------------------------
1685: PROCEDURE writetoclob (p_xfdf_clob OUT NOCOPY CLOB)

Line 1879: fnd_file.put_line (fnd_file.LOG, 'Entering into GET_XML');

1875:
1876: l_month varchar2(5);
1877: l_full_month varchar2(25);
1878: BEGIN
1879: fnd_file.put_line (fnd_file.LOG, 'Entering into GET_XML');
1880: hr_utility.set_location ('Entered Procedure GETDATA', 10);
1881:
1882: l_payroll_action_id :=
1883: get_archive_payroll_action_id (p_payroll_action_id);