eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_KR_YEA_PDF_PKG dependencies on FND_FILE

Line 558: --fnd_file.put_line(fnd_file.log,'g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));

554: p_assignment_set_id);
555: fetch csr_kr_ass_yea bulk collect into g_pdf_tbl;
556: close csr_kr_ass_yea;
557: --
558: --fnd_file.put_line(fnd_file.log,'g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));
559: --
560: if g_debug then
561: hr_utility.trace('g_pdf_tbl.count : '||to_char(g_pdf_tbl.count));
562: end if;

Line 825: fnd_file.put_line(fnd_file.log,g_msg);

821: fnd_message.set_name('PAY','PAY_KR_YEA_PDF_LOCK_STATUS');
822: fnd_message.set_token('ASS_ID',to_char(p_assignment_id));
823: g_msg := fnd_message.get;
824: --
825: fnd_file.put_line(fnd_file.log,g_msg);
826: --
827: if g_debug then
828: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
829: end if;

Line 890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);

886: hr_utility.trace('res reg num : '||l_csr_map_name.res_reg_num);
887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --
890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);
891: --fnd_file.put_line(fnd_file.log,'ass id : '||to_char(l_csr_map_name.assignment_id));
892: end if;
893: --
894: /* skip for multiple assignment */

Line 891: --fnd_file.put_line(fnd_file.log,'ass id : '||to_char(l_csr_map_name.assignment_id));

887: hr_utility.trace('emp num : '||l_csr_map_name.emp_num);
888: hr_utility.trace('ass id : '||to_char(l_csr_map_name.assignment_id));
889: --
890: --fnd_file.put_line(fnd_file.log,'emp num : '||l_csr_map_name.emp_num);
891: --fnd_file.put_line(fnd_file.log,'ass id : '||to_char(l_csr_map_name.assignment_id));
892: end if;
893: --
894: /* skip for multiple assignment */
895: if l_file_id is null then

Line 950: --fnd_file.put_line(fnd_file.log,'g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));

946: --
947: end loop;
948: close csr_map_name;
949: --
950: --fnd_file.put_line(fnd_file.log,'g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
951: if g_debug then
952: --
953: hr_utility.trace('g_ass_yea_tbl.count : '||to_char(g_ass_yea_tbl.count));
954: hr_utility.trace('g_ass_yea_ind : '||to_char(g_ass_yea_ind));

Line 993: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');

989: if nvl(g_load_type,'X') <> 'L' then
990: --
991: if nvl(g_imp_output_hd_show,'N') = 'N' then
992: --
993: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
994: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_IMP_FILE'));
995: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
996: --
997: g_imp_output_hd_show := 'Y';

Line 994: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_IMP_FILE'));

990: --
991: if nvl(g_imp_output_hd_show,'N') = 'N' then
992: --
993: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
994: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_IMP_FILE'));
995: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
996: --
997: g_imp_output_hd_show := 'Y';
998: --

Line 995: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');

991: if nvl(g_imp_output_hd_show,'N') = 'N' then
992: --
993: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
994: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_IMP_FILE'));
995: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
996: --
997: g_imp_output_hd_show := 'Y';
998: --
999: end if;

Line 1004: fnd_file.put_line(fnd_file.output,g_import_path||g_path_delimiter||g_ass_yea_tbl(i).file_name);

1000: --
1001: /* show only one for multiple assignment */
1002: if l_ass_cnt = 0 then
1003: --
1004: fnd_file.put_line(fnd_file.output,g_import_path||g_path_delimiter||g_ass_yea_tbl(i).file_name);
1005: --
1006: end if;
1007: --
1008: end if;

Line 1103: --fnd_file.put_line(fnd_file.log,'come get_pdf_blob : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id)||','||g_pdf_tbl(g_pdf_ind).emp_num);

1099: p_emp_name := g_pdf_tbl(g_pdf_ind).emp_name;
1100: p_pdf_pwd := substrb(g_pdf_tbl(g_pdf_ind).ni_num,-7);
1101: p_blob := g_pdf_tbl(g_pdf_ind).pdf_file;
1102: --
1103: --fnd_file.put_line(fnd_file.log,'come get_pdf_blob : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id)||','||g_pdf_tbl(g_pdf_ind).emp_num);
1104: if g_debug then
1105: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').assignment_id : '||to_char(g_pdf_tbl(g_pdf_ind).assignment_id));
1106: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').ni_num : '||g_pdf_tbl(g_pdf_ind).ni_num);
1107: hr_utility.trace('g_pdf_tbl('||to_char(g_pdf_ind)||').emp_num : '||g_pdf_tbl(g_pdf_ind).emp_num);

Line 3305: fnd_file.put_line(fnd_file.log,g_msg);

3301: fnd_message.set_name('PAY','PAY_KR_YEA_PDF_LOCK_STATUS');
3302: fnd_message.set_token('ASS_ID',to_char(p_assignment_id));
3303: g_msg := fnd_message.get;
3304: --
3305: fnd_file.put_line(fnd_file.log,g_msg);
3306: --
3307: if g_debug then
3308: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
3309: end if;

Line 3648: fnd_file.put_line(fnd_file.log,g_msg);

3644: fnd_message.set_name('PAY','PAY_KR_YEA_PDF_LOCK_STATUS');
3645: fnd_message.set_token('ASS_ID',to_char(p_assignment_id));
3646: g_msg := fnd_message.get;
3647: --
3648: fnd_file.put_line(fnd_file.log,g_msg);
3649: --
3650: if g_debug then
3651: hr_utility.trace('skipped because p_assignment_id : '||to_char(p_assignment_id)||' entry status was locked.');
3652: end if;

Line 3960: fnd_file.put_line(fnd_file.log,g_msg);

3956: fnd_message.set_token('CON_NI',p_con_ni);
3957: --
3958: g_msg := fnd_message.get;
3959: --
3960: fnd_file.put_line(fnd_file.log,g_msg);
3961: --
3962: end if;
3963: --
3964: p_contact_extra_info_id := l_contact_extra_info_id;

Line 4006: fnd_file.put_line(fnd_file.log,dbms_lob.substr(p_xml,l_len_size,l_len_st));

4002: l_len_size := l_xml_len - l_len_st + 1;
4003: --
4004: end if;
4005: --
4006: fnd_file.put_line(fnd_file.log,dbms_lob.substr(p_xml,l_len_size,l_len_st));
4007: --
4008: if l_len_st + c_len_size - 1 > l_xml_len then
4009: --
4010: exit;

Line 4573: fnd_file.put_line(fnd_file.log,g_msg);

4569: fnd_message.set_token('EMP_NO',p_emp_num);
4570: --
4571: g_msg := fnd_message.get;
4572: --
4573: fnd_file.put_line(fnd_file.log,g_msg);
4574: --
4575: end if;
4576: --
4577: --

Line 6266: fnd_file.put_line(fnd_file.log,g_msg);

6262: fnd_message.set_token('EMP_NO',p_emp_num);
6263: --
6264: g_msg := fnd_message.get;
6265: --
6266: fnd_file.put_line(fnd_file.log,g_msg);
6267: --
6268: end;
6269: --
6270: if l_tmp is not null then

Line 6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));

6268: end;
6269: --
6270: if l_tmp is not null then
6271: --
6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));
6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));

Line 6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));

6269: --
6270: if l_tmp is not null then
6271: --
6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));
6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));

Line 6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));

6270: if l_tmp is not null then
6271: --
6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));
6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));

Line 6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));

6271: --
6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));
6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));
6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));

Line 6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));

6272: --fnd_file.put_line(fnd_file.log,'ins_prem_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).ins_prem_nts));
6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));
6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));
6280: --

Line 6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));

6273: --fnd_file.put_line(fnd_file.log,'med_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).med_exp_nts));
6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));
6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));
6280: --
6281: load_cei_dpnt_info(

Line 6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));

6274: --fnd_file.put_line(fnd_file.log,'educ_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).educ_exp_nts));
6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));
6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));
6280: --
6281: load_cei_dpnt_info(
6282: p_assignment_id => p_assignment_id,

Line 6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));

6275: --fnd_file.put_line(fnd_file.log,'card_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).card_exp_nts));
6276: --fnd_file.put_line(fnd_file.log,'cash_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).cash_exp_nts));
6277: --fnd_file.put_line(fnd_file.log,'dis_ins_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).dis_ins_nts));
6278: --fnd_file.put_line(fnd_file.log,'don_exp_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).don_exp_nts));
6279: --fnd_file.put_line(fnd_file.log,'direct_payment_nts : '||to_char(l_ass_dpnt_tbl(get_dpnt_ind(l_ass_dpnt_ind_tbl,l_ass_dpnt_ind_tbl(i))).direct_payment_nts));
6280: --
6281: load_cei_dpnt_info(
6282: p_assignment_id => p_assignment_id,
6283: p_effective_date => g_target_eoy,

Line 6532: fnd_file.put_line(fnd_file.log,g_msg||' '||l_return_message);

6528: fnd_message.set_token('FAIL_REC',l_failed_record);
6529: --
6530: g_msg := fnd_message.get;
6531: --
6532: fnd_file.put_line(fnd_file.log,g_msg||' '||l_return_message);
6533: --
6534: -- same behavior YeaAMImpl.updateEntryStatus.SUBMIT_FAILED
6535: if l_ass_data_rec_n.entry_status in ('IU','FU','C') then
6536: --

Line 6555: fnd_file.put_line(fnd_file.log,g_msg||' '||l_return_message);

6551: fnd_message.set_token('EMP_NO',p_emp_num);
6552: --
6553: g_msg := fnd_message.get;
6554: --
6555: fnd_file.put_line(fnd_file.log,g_msg||' '||l_return_message);
6556: --
6557: l_ass_data_rec_n.validation_status := l_return_status;
6558: l_ass_data_rec_n.entry_error1 := l_ff_message0;
6559: l_ass_data_rec_n.entry_error2 := l_ff_message1;

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

6616: p_assignment_yea_info_id => l_assignment_yea_info_id);
6617: --
6618: else
6619: --
6620: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6621: fnd_file.put_line(fnd_file.log,'debug upload data');
6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;

Line 6621: fnd_file.put_line(fnd_file.log,'debug upload data');

6617: --
6618: else
6619: --
6620: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6621: fnd_file.put_line(fnd_file.log,'debug upload data');
6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));

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

6618: else
6619: --
6620: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6621: fnd_file.put_line(fnd_file.log,'debug upload data');
6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');

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

6619: --
6620: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6621: fnd_file.put_line(fnd_file.log,'debug upload data');
6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');
6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;

Line 6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));

6621: fnd_file.put_line(fnd_file.log,'debug upload data');
6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');
6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;
6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');

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

6622: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6623: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_MEDICAL_EXP_INFO --');
6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');
6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;
6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');
6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;

Line 6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');

6624: l_ass_med_tbl := l_ass_data_rec.med_tbl;
6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');
6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;
6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');
6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;
6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');

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

6625: fnd_file.put_line(fnd_file.log,'B : '||to_char(l_ass_med_tbl.count));
6626: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DETAIL_DONATION_INFO --');
6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;
6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');
6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;
6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');
6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;

Line 6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));

6627: l_ass_don_tbl := l_ass_data_rec.don_tbl;
6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');
6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;
6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');
6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;
6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');

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

6628: fnd_file.put_line(fnd_file.log,'L : '||to_char(l_ass_don_tbl.count)||'('||to_char(l_don_tbl_tmp.count)||')');
6629: fnd_file.put_line(fnd_file.log,'-- KR_YEA_DPNT_EDUC_TAX_EXEM_INFO --');
6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;
6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');
6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;
6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');
6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;

Line 6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));

6630: l_ass_educ_tbl := l_ass_data_rec.educ_tbl;
6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');
6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;
6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');
6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;
6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');

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

6631: fnd_file.put_line(fnd_file.log,'C : '||to_char(l_ass_educ_tbl.count));
6632: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SEP_PEN_DETAILS --');
6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;
6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');
6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;
6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');
6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;

Line 6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));

6633: l_ass_saving_tbl := l_ass_data_rec.sep_pen_saving_tbl;
6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');
6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;
6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');
6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;
6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');

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

6634: fnd_file.put_line(fnd_file.log,'F : '||to_char(l_ass_saving_tbl.count));
6635: fnd_file.put_line(fnd_file.log,'-- KR_YEA_PEN_SAVING_DETAILS --');
6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;
6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');
6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;
6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;

Line 6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));

6636: l_ass_saving_tbl := l_ass_data_rec.pen_saving_tbl;
6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');
6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;
6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');

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

6637: fnd_file.put_line(fnd_file.log,'D/E : '||to_char(l_ass_saving_tbl.count));
6638: fnd_file.put_line(fnd_file.log,'-- KR_YEA_LT_STOCK_SAVING_DETAILS --');
6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;
6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);

Line 6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));

6639: l_ass_saving_tbl := l_ass_data_rec.lts_saving_tbl;
6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);

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

6640: fnd_file.put_line(fnd_file.log,'M : '||to_char(l_ass_saving_tbl.count));
6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);

Line 6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);

6641: fnd_file.put_line(fnd_file.log,'-- KR_YEA_HOU_SAVING_DETAILS --');
6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);

Line 6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);

6642: l_ass_saving_tbl := l_ass_data_rec.hou_saving_tbl;
6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);

Line 6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);

6643: fnd_file.put_line(fnd_file.log,'J : '||to_char(l_ass_saving_tbl.count));
6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);

Line 6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);

6644: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO --');
6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);

Line 6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);

6645: fnd_file.put_line(fnd_file.log,'pers_ins_prem : A01 : '||l_ass_data_rec.pers_ins_prem);
6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);

Line 6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);

6646: fnd_file.put_line(fnd_file.log,'disabled_ins_prem : A01 : '||l_ass_data_rec.disabled_ins_prem);
6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);

Line 6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);

6647: fnd_file.put_line(fnd_file.log,'med_exp : B01 : '||l_ass_data_rec.med_exp);
6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);

Line 6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);

6648: fnd_file.put_line(fnd_file.log,'med_exp_aged : B01 : '||l_ass_data_rec.med_exp_aged);
6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');

Line 6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);

6649: fnd_file.put_line(fnd_file.log,'ee_educ_exp : C01/03/04 : '||l_ass_data_rec.ee_educ_exp);
6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);

Line 6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);

6650: fnd_file.put_line(fnd_file.log,'housing_loan_repay : J01 : '||l_ass_data_rec.housing_loan_repay);
6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);

Line 6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);

6651: fnd_file.put_line(fnd_file.log,'housing_loan_date : J01 : '||l_ass_data_rec.housing_loan_date);
6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);

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

6652: fnd_file.put_line(fnd_file.log,'lt_housing_loan_interest_rep : J02 : '||l_ass_data_rec.lt_housing_loan_interest_rep);
6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);

Line 6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);

6653: fnd_file.put_line(fnd_file.log,'political_donation1 : L01 '||l_ass_data_rec.political_donation1);
6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');

Line 6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);

6654: fnd_file.put_line(fnd_file.log,'med_exp_emp : B01 : '||l_ass_data_rec.med_exp_emp);
6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);

Line 6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);

6655: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_1 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_1);
6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);

Line 6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);

6656: fnd_file.put_line(fnd_file.log,'-- KR_YEA_SP_TAX_EXEM_INFO2 --');
6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);

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

6657: fnd_file.put_line(fnd_file.log,'ee_occupation_educ_exp : C02 : '||l_ass_data_rec.ee_occupation_educ_exp);
6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);

Line 6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);

6658: fnd_file.put_line(fnd_file.log,'lt_housing_loan_int_repay_2 : J02 : '||l_ass_data_rec.lt_housing_loan_int_repay_2);
6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);

Line 6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);

6659: fnd_file.put_line(fnd_file.log,'lt_2012_fixed_intr_wo_grace : J02 : '||l_ass_data_rec.lt_2012_fixed_intr_wo_grace);
6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);

Line 6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);

6660: fnd_file.put_line(fnd_file.log,'lt_2012_housing_other_intr : J02 : '||l_ass_data_rec.lt_2012_housing_other_intr);
6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);

Line 6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);

6661: fnd_file.put_line(fnd_file.log,'-- KR_YEA_TAX_EXEM_INFO --');
6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);

Line 6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);

6662: fnd_file.put_line(fnd_file.log,'pers_pension_prem : D01 : '||l_ass_data_rec.pers_pension_prem);
6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');

Line 6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);

6663: fnd_file.put_line(fnd_file.log,'credit_card_exp : G01 : '||l_ass_data_rec.credit_card_exp);
6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);

Line 6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);

6664: fnd_file.put_line(fnd_file.log,'credit_tm_exp : G01 : '||l_ass_data_rec.credit_tm_exp);
6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);

Line 6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);

6665: fnd_file.put_line(fnd_file.log,'direct_card_exp : G03 : '||l_ass_data_rec.direct_card_exp);
6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);

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

6666: fnd_file.put_line(fnd_file.log,'direct_tm_exp : G03 : '||l_ass_data_rec.direct_tm_exp);
6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);

Line 6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);

6667: fnd_file.put_line(fnd_file.log,'cash_receipt_exp : G02 : '||l_ass_data_rec.cash_receipt_exp);
6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);

Line 6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);

6668: fnd_file.put_line(fnd_file.log,'cash_tm_exp : G02 : '||l_ass_data_rec.cash_tm_exp);
6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);

Line 6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);

6669: fnd_file.put_line(fnd_file.log,'small_bus_install : K01 : '||l_ass_data_rec.small_bus_install);
6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);

Line 6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);

6670: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);

Line 6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);

6671: fnd_file.put_line(fnd_file.log,'med_exp_nts : B ; '||l_ass_data_rec.med_exp_nts);
6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');

Line 6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);

6672: fnd_file.put_line(fnd_file.log,'educ_exp_nts : C : '||l_ass_data_rec.educ_exp_nts);
6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;

Line 6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);

6673: fnd_file.put_line(fnd_file.log,'card_exp_nts : G01 : '||l_ass_data_rec.card_exp_nts);
6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;

Line 6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);

6674: fnd_file.put_line(fnd_file.log,'card_tm _nts : G01 : '||l_ass_data_rec.card_tm_nts);
6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;
6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));

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

6675: fnd_file.put_line(fnd_file.log,'don_exp_nts : L01 : '||l_ass_data_rec.don_exp_nts);
6676: fnd_file.put_line(fnd_file.log,'ins_exp_nts : A01/A03 : '||l_ass_data_rec.ins_exp_nts);
6677: fnd_file.put_line(fnd_file.log,'direct_payment_nts : G03 : '||l_ass_data_rec.direct_payment_nts);
6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;
6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));
6683: fnd_file.put_line(fnd_file.log,'dpnt_tbl : '||to_char(l_ass_dpnt_tbl.count));

Line 6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));

6678: fnd_file.put_line(fnd_file.log,'direct_tm_nts : G03 : '||l_ass_data_rec.direct_tm_nts);
6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;
6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));
6683: fnd_file.put_line(fnd_file.log,'dpnt_tbl : '||to_char(l_ass_dpnt_tbl.count));
6684: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6685: --
6686: l_status := 'U';

Line 6683: fnd_file.put_line(fnd_file.log,'dpnt_tbl : '||to_char(l_ass_dpnt_tbl.count));

6679: fnd_file.put_line(fnd_file.log,'-- KR_YEA_EMP_EXPENSE_DETAILS --');
6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;
6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));
6683: fnd_file.put_line(fnd_file.log,'dpnt_tbl : '||to_char(l_ass_dpnt_tbl.count));
6684: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6685: --
6686: l_status := 'U';
6687: --

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

6680: l_ass_dpnt_ind_tbl := l_ass_data_rec.dpnt_ind_tbl;
6681: l_ass_dpnt_tbl := l_ass_data_rec.dpnt_tbl;
6682: fnd_file.put_line(fnd_file.log,'dpnt_ind_tbl : '||to_char(l_ass_dpnt_ind_tbl.count));
6683: fnd_file.put_line(fnd_file.log,'dpnt_tbl : '||to_char(l_ass_dpnt_tbl.count));
6684: fnd_file.put_line(fnd_file.log,'-----------------------------------------------------------------------------');
6685: --
6686: l_status := 'U';
6687: --
6688: end if;

Line 6814: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');

6810: if p_status = 'C' then
6811: --
6812: if nvl(g_upl_output_hd_show,'N') = 'N' then
6813: --
6814: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6815: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_UPL_EMP'));
6816: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6817: --
6818: g_upl_output_hd_show := 'Y';

Line 6815: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_UPL_EMP'));

6811: --
6812: if nvl(g_upl_output_hd_show,'N') = 'N' then
6813: --
6814: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6815: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_UPL_EMP'));
6816: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6817: --
6818: g_upl_output_hd_show := 'Y';
6819: --

Line 6816: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');

6812: if nvl(g_upl_output_hd_show,'N') = 'N' then
6813: --
6814: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6815: fnd_file.put_line(fnd_file.output,fnd_message.get_string('PAY','PAY_KR_YEA_PDF_UPL_EMP'));
6816: fnd_file.put_line(fnd_file.output,'-----------------------------------------------------------------------------');
6817: --
6818: g_upl_output_hd_show := 'Y';
6819: --
6820: end if;

Line 6824: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) ');

6820: end if;
6821: --
6822: if nvl(g_load_type,'X') <> 'L' then
6823: --
6824: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) ');
6825: --
6826: else
6827: --
6828: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) : '||g_import_path||g_path_delimiter||p_file_name);

Line 6828: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) : '||g_import_path||g_path_delimiter||p_file_name);

6824: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) ');
6825: --
6826: else
6827: --
6828: fnd_file.put_line(fnd_file.output,p_emp_name||' ( '||p_emp_num||' ) : '||g_import_path||g_path_delimiter||p_file_name);
6829: --
6830: end if;
6831: --
6832: end if;