DBA Data[Home] [Help]

APPS.PAY_JP_SPR_EFILE_PKG dependencies on FND_FILE

Line 4403: fnd_file.put_line(fnd_file.log,fnd_message.get_string('PAY','PAY_JP_WIC_DESC_TRUNCATED'));

4399: or g_warning_header <> 'Y' then
4400: --
4401: g_warning_header := 'Y';
4402: --
4403: fnd_file.put_line(fnd_file.log,fnd_message.get_string('PAY','PAY_JP_WIC_DESC_TRUNCATED'));
4404: --
4405: end if;
4406: --
4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);

Line 4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);

4403: fnd_file.put_line(fnd_file.log,fnd_message.get_string('PAY','PAY_JP_WIC_DESC_TRUNCATED'));
4404: --
4405: end if;
4406: --
4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);
4408: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
4409: pay_jp_report_pkg.show_warning(fnd_file.log,g_body_tbl(p_assignment_action_id).long_description);
4410: fnd_file.put_line(fnd_file.log,' ');
4411: --

Line 4408: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

4404: --
4405: end if;
4406: --
4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);
4408: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
4409: pay_jp_report_pkg.show_warning(fnd_file.log,g_body_tbl(p_assignment_action_id).long_description);
4410: fnd_file.put_line(fnd_file.log,' ');
4411: --
4412: end if;

Line 4409: pay_jp_report_pkg.show_warning(fnd_file.log,g_body_tbl(p_assignment_action_id).long_description);

4405: end if;
4406: --
4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);
4408: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
4409: pay_jp_report_pkg.show_warning(fnd_file.log,g_body_tbl(p_assignment_action_id).long_description);
4410: fnd_file.put_line(fnd_file.log,' ');
4411: --
4412: end if;
4413: --

Line 4410: fnd_file.put_line(fnd_file.log,' ');

4406: --
4407: fnd_file.put_line(fnd_file.log,g_body_tbl(p_assignment_action_id).o_employee_number||' : '||g_body_tbl(p_assignment_action_id).o_full_name);
4408: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
4409: pay_jp_report_pkg.show_warning(fnd_file.log,g_body_tbl(p_assignment_action_id).long_description);
4410: fnd_file.put_line(fnd_file.log,' ');
4411: --
4412: end if;
4413: --
4414: l_file_ind := g_body_tbl(p_assignment_action_id).file_ind;

Line 4889: -- file close for fnd_file open_cursor limitation

4885: --
4886: if g_assact_tbl(i) is not null then
4887: --
4888: -- -----------------------------------------------------
4889: -- file close for fnd_file open_cursor limitation
4890: -- -----------------------------------------------------
4891: -- close all open file
4892: -- this can be closed as efficient because g_body_tbl consists of data sorted by sequential district code
4893: -- consider fnd_file log, out count

Line 4893: -- consider fnd_file log, out count

4889: -- file close for fnd_file open_cursor limitation
4890: -- -----------------------------------------------------
4891: -- close all open file
4892: -- this can be closed as efficient because g_body_tbl consists of data sorted by sequential district code
4893: -- consider fnd_file log, out count
4894: if l_open_file_tbl.count = (c_max_file_open - 1 - 2) then
4895: --
4896: <>
4897: for j in l_open_file_tbl.first..l_open_file_tbl.last loop

Line 5514: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

5510: l_all_district_cnt := 0;
5511: l_all_emp_cnt := 0;
5512: l_all_term_emp_cnt := 0;
5513: --
5514: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5515: fnd_file.put_line(fnd_file.log,'File Name - Municipality Code : Special Withholding Agent / Employee / Retired Employee');
5516: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5517: --
5518: for j in 1..g_summary_tbl.count loop

Line 5515: fnd_file.put_line(fnd_file.log,'File Name - Municipality Code : Special Withholding Agent / Employee / Retired Employee');

5511: l_all_emp_cnt := 0;
5512: l_all_term_emp_cnt := 0;
5513: --
5514: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5515: fnd_file.put_line(fnd_file.log,'File Name - Municipality Code : Special Withholding Agent / Employee / Retired Employee');
5516: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5517: --
5518: for j in 1..g_summary_tbl.count loop
5519: --

Line 5516: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

5512: l_all_term_emp_cnt := 0;
5513: --
5514: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5515: fnd_file.put_line(fnd_file.log,'File Name - Municipality Code : Special Withholding Agent / Employee / Retired Employee');
5516: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5517: --
5518: for j in 1..g_summary_tbl.count loop
5519: --
5520: fnd_file.put_line(fnd_file.log,

Line 5520: fnd_file.put_line(fnd_file.log,

5516: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5517: --
5518: for j in 1..g_summary_tbl.count loop
5519: --
5520: fnd_file.put_line(fnd_file.log,
5521: g_summary_tbl(j).file_name||' - '||
5522: g_summary_tbl(j).district_code||' : '||
5523: to_char(g_summary_tbl(j).itax_org_cnt)||' / '||
5524: to_char(g_summary_tbl(j).emp_cnt)||' / '||

Line 5538: fnd_file.put_line(fnd_file.log,' ');

5534: l_all_term_emp_cnt := l_all_term_emp_cnt + g_summary_tbl(j).term_emp_cnt;
5535: --
5536: end loop;
5537: --
5538: fnd_file.put_line(fnd_file.log,' ');
5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');
5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5542: fnd_file.put_line(fnd_file.log,

Line 5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

5535: --
5536: end loop;
5537: --
5538: fnd_file.put_line(fnd_file.log,' ');
5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');
5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5542: fnd_file.put_line(fnd_file.log,
5543: 'Total : '||

Line 5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');

5536: end loop;
5537: --
5538: fnd_file.put_line(fnd_file.log,' ');
5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');
5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5542: fnd_file.put_line(fnd_file.log,
5543: 'Total : '||
5544: to_char(l_all_district_cnt)||' / '||

Line 5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');

5537: --
5538: fnd_file.put_line(fnd_file.log,' ');
5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');
5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5542: fnd_file.put_line(fnd_file.log,
5543: 'Total : '||
5544: to_char(l_all_district_cnt)||' / '||
5545: to_char(l_all_emp_cnt)||' / '||

Line 5542: fnd_file.put_line(fnd_file.log,

5538: fnd_file.put_line(fnd_file.log,' ');
5539: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5540: fnd_file.put_line(fnd_file.log,'Total : Municipality Code / Employee / Retired Employee');
5541: fnd_file.put_line(fnd_file.log,'----------------------------------------------------------------------------------------------------');
5542: fnd_file.put_line(fnd_file.log,
5543: 'Total : '||
5544: to_char(l_all_district_cnt)||' / '||
5545: to_char(l_all_emp_cnt)||' / '||
5546: to_char(l_all_term_emp_cnt));

Line 5547: fnd_file.put_line(fnd_file.log,' ');

5543: 'Total : '||
5544: to_char(l_all_district_cnt)||' / '||
5545: to_char(l_all_emp_cnt)||' / '||
5546: to_char(l_all_term_emp_cnt));
5547: fnd_file.put_line(fnd_file.log,' ');
5548: --
5549: end if;
5550: --
5551: end if;