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_GB_P11D_ARCHIVE_SS dependencies on FND_FILE

Line 800: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

796: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
797: fnd_message.set_token('NAME', 'Benefit Start Date');
798: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));
799: fnd_message.set_token('VAL2', '05-04-' ||l_rep_run);
800: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
801: hr_utility.raise_error;
802: End if;
803:
804: If fnd_date.canonical_to_date(l_benefit_end_date) <

Line 818: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

814: fnd_message.set_name('PER', 'HR_78076_P11D_DATE_PARAM_ERR');
815: fnd_message.set_token('NAME', 'Benefit End Date');
816: fnd_message.set_token('VAL1', '06-04-' ||to_char(to_number(l_rep_run)-1));
817: fnd_message.set_token('VAL2', '05-04-' ||l_rep_run);
818: fnd_file.put_line(fnd_file.LOG,fnd_message.get);
819: hr_utility.raise_error;
820: End if;
821: hr_utility.set_location('Step '|| l_proc, 20);
822: hr_utility.set_location('l_benefit_start_date = '|| l_benefit_start_date, 20);

Line 1372: -- fnd_file.put_line(fnd_file.output,'Tax Office Name contains illegal character(s) :' || l_tax_office_name );

1368: hr_utility.TRACE(' Found InsidePopulate_Payroll_info');
1369:
1370: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_tax_office_name) ) > 0
1371: THEN
1372: -- fnd_file.put_line(fnd_file.output,'Tax Office Name contains illegal character(s) :' || l_tax_office_name );
1373: RAISE tax_office_name_error;
1374: END IF;
1375:
1376: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_address),'P11D_EDI' ) > 0

Line 1378: -- fnd_file.put_line(fnd_file.output,'Employers Address contains illegal character(s) :' || l_employer_address );

1374: END IF;
1375:
1376: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_address),'P11D_EDI' ) > 0
1377: THEN
1378: -- fnd_file.put_line(fnd_file.output,'Employers Address contains illegal character(s) :' || l_employer_address );
1379: RAISE employer_address_error;
1380: END IF;
1381:
1382: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employers_ref_no) ) > 0

Line 1384: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);

1380: END IF;
1381:
1382: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employers_ref_no) ) > 0
1383: THEN
1384: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);
1385: RAISE employers_ref_no_error;
1386: END IF;
1387:
1388: IF pay_gb_eoy_magtape.validate_input(to_number(substr(l_pay_info_tab(p_payroll_id).l_employers_ref_no,1,3)),'NUMBER') > 0

Line 1395: -- fnd_file.put_line(fnd_file.output,'Employers Name contains illegal character(s) :' || l_employer_name );

1391: END IF;
1392:
1393: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employer_name),'P11D_EDI' ) > 0
1394: THEN
1395: -- fnd_file.put_line(fnd_file.output,'Employers Name contains illegal character(s) :' || l_employer_name );
1396: RAISE employer_name_error;
1397: END IF;
1398: END IF;
1399: END;

Line 3785: fnd_file.put_line(

3781:
3782: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3783: IS
3784: BEGIN
3785: fnd_file.put_line(
3786: fnd_file.output,
3787: RPAD(NVL(employers_name, ' '), 20) || RPAD(NVL(person_name, ' '), 25) || RPAD(NVL(employee_num, ' '), 15) || err_text);
3788: END;
3789:

Line 3786: fnd_file.output,

3782: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3783: IS
3784: BEGIN
3785: fnd_file.put_line(
3786: fnd_file.output,
3787: RPAD(NVL(employers_name, ' '), 20) || RPAD(NVL(person_name, ' '), 25) || RPAD(NVL(employee_num, ' '), 15) || err_text);
3788: END;
3789:
3790: PROCEDURE deinitialization_code(pactid IN NUMBER)

Line 3912: fnd_file.put_line(fnd_file.output,null);

3908: person_table(l_count).person_id := x.action_information10;
3909: person_table(l_count).employee_no := x.action_information11;
3910: person_table(l_count).ni_number := x.action_information12;
3911: end loop;
3912: fnd_file.put_line(fnd_file.output,null);
3913: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3914: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3915: rpad(' Employee Name',26) ||
3916: rpad(' Employee Number',16));

Line 3913: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');

3909: person_table(l_count).employee_no := x.action_information11;
3910: person_table(l_count).ni_number := x.action_information12;
3911: end loop;
3912: fnd_file.put_line(fnd_file.output,null);
3913: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3914: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3915: rpad(' Employee Name',26) ||
3916: rpad(' Employee Number',16));
3917: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||

Line 3914: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||

3910: person_table(l_count).ni_number := x.action_information12;
3911: end loop;
3912: fnd_file.put_line(fnd_file.output,null);
3913: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3914: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3915: rpad(' Employee Name',26) ||
3916: rpad(' Employee Number',16));
3917: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||
3918: rpad('-',25,'-') || ' ' ||

Line 3917: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||

3913: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3914: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3915: rpad(' Employee Name',26) ||
3916: rpad(' Employee Number',16));
3917: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||
3918: rpad('-',25,'-') || ' ' ||
3919: rpad('-',16,'-') || ' ' ||
3920: rpad('-',55,'-'));
3921:

Line 3930: fnd_file.put_line(fnd_file.output,

3926: if l_curr > 1 then
3927: if (person_table(l_curr).ni_number = person_table(l_prev).ni_number
3928: and
3929: person_table(l_curr).person_id <> person_table(l_prev).person_id) then
3930: fnd_file.put_line(fnd_file.output,
3931: rpad(person_table(l_prev).employer_name,21) ||
3932: rpad(person_table(l_prev).full_name,26) ||
3933: rpad(person_table(l_prev).employee_no,16) ||
3934: 'This employee has a duplicate NI number ' || person_table(l_prev).ni_number);

Line 3935: fnd_file.put_line(fnd_file.output,

3931: rpad(person_table(l_prev).employer_name,21) ||
3932: rpad(person_table(l_prev).full_name,26) ||
3933: rpad(person_table(l_prev).employee_no,16) ||
3934: 'This employee has a duplicate NI number ' || person_table(l_prev).ni_number);
3935: fnd_file.put_line(fnd_file.output,
3936: rpad(person_table(l_curr).employer_name,21) ||
3937: rpad(person_table(l_curr).full_name,26) ||
3938: rpad(person_table(l_curr).employee_no,16) ||
3939: 'This employee has a duplicate NI number ' || person_table(l_curr).ni_number);

Line 4180: fnd_file.put_line(fnd_file.output,'Employer Name : ' || p_employer_name);

4176: l_int_free_total number;
4177:
4178: PROCEDURE write_header(p_employer_name varchar2) IS
4179: BEGIN
4180: fnd_file.put_line(fnd_file.output,'Employer Name : ' || p_employer_name);
4181: fnd_file.put_line(fnd_file.output,
4182: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4183: rpad('# People', 10) || rpad('# Entries', 10) ||
4184: rpad('Class 1A',16) || rpad('Non Class 1A',15));

Line 4181: fnd_file.put_line(fnd_file.output,

4177:
4178: PROCEDURE write_header(p_employer_name varchar2) IS
4179: BEGIN
4180: fnd_file.put_line(fnd_file.output,'Employer Name : ' || p_employer_name);
4181: fnd_file.put_line(fnd_file.output,
4182: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4183: rpad('# People', 10) || rpad('# Entries', 10) ||
4184: rpad('Class 1A',16) || rpad('Non Class 1A',15));
4185: fnd_file.put_line(fnd_file.output,

Line 4185: fnd_file.put_line(fnd_file.output,

4181: fnd_file.put_line(fnd_file.output,
4182: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4183: rpad('# People', 10) || rpad('# Entries', 10) ||
4184: rpad('Class 1A',16) || rpad('Non Class 1A',15));
4185: fnd_file.put_line(fnd_file.output,
4186: rpad('-',30,'-') || ' ' ||
4187: rpad('-',28,'-') || ' ' ||
4188: rpad('-',9,'-') || ' ' ||
4189: rpad('-',9,'-') || ' ' ||

Line 4202: fnd_file.put_line(fnd_file.output,

4198: p_value varchar2,
4199: p_class_A boolean) IS
4200: BEGIN
4201: if p_class_A then
4202: fnd_file.put_line(fnd_file.output,
4203: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4204: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4205: rpad(p_value,15) || ' ' || rpad(' ',15));
4206: else

Line 4207: fnd_file.put_line(fnd_file.output,

4203: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4204: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4205: rpad(p_value,15) || ' ' || rpad(' ',15));
4206: else
4207: fnd_file.put_line(fnd_file.output,
4208: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4209: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4210: rpad(' ',15) || ' ' || rpad(p_value,15));
4211: end if;

Line 4218: fnd_file.put_line(fnd_file.output,null);

4214: PROCEDURE write_footer(p_class_a_value varchar2,
4215: p_nclass_value varchar2,
4216: p_total varchar2) IS
4217: BEGIN
4218: fnd_file.put_line(fnd_file.output,null);
4219: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4220: rpad(p_nclass_value,15) || rpad(p_total,16));
4221: fnd_file.put_line(fnd_file.output,null);
4222: END write_footer;

Line 4219: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||

4215: p_nclass_value varchar2,
4216: p_total varchar2) IS
4217: BEGIN
4218: fnd_file.put_line(fnd_file.output,null);
4219: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4220: rpad(p_nclass_value,15) || rpad(p_total,16));
4221: fnd_file.put_line(fnd_file.output,null);
4222: END write_footer;
4223:

Line 4221: fnd_file.put_line(fnd_file.output,null);

4217: BEGIN
4218: fnd_file.put_line(fnd_file.output,null);
4219: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4220: rpad(p_nclass_value,15) || rpad(p_total,16));
4221: fnd_file.put_line(fnd_file.output,null);
4222: END write_footer;
4223:
4224: BEGIN
4225: fnd_file.put_line(fnd_file.output,null);

Line 4225: fnd_file.put_line(fnd_file.output,null);

4221: fnd_file.put_line(fnd_file.output,null);
4222: END write_footer;
4223:
4224: BEGIN
4225: fnd_file.put_line(fnd_file.output,null);
4226: fnd_file.put_line(fnd_file.output,'P11D Summary Report');
4227: FOR employer IN get_employer(p_pact_id)
4228: LOOP
4229: l_1a_total := 0;

Line 4226: fnd_file.put_line(fnd_file.output,'P11D Summary Report');

4222: END write_footer;
4223:
4224: BEGIN
4225: fnd_file.put_line(fnd_file.output,null);
4226: fnd_file.put_line(fnd_file.output,'P11D Summary Report');
4227: FOR employer IN get_employer(p_pact_id)
4228: LOOP
4229: l_1a_total := 0;
4230: l_n1a_total := 0;

Line 4352: fnd_file.put_line(fnd_file.output,null);

4348: order by paf.assignment_number, element_name, pml.line_sequence;
4349:
4350: PROCEDURE write_header(p_type varchar2) IS
4351: BEGIN
4352: fnd_file.put_line(fnd_file.output,null);
4353: if p_type = 'F' then
4354: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4355: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4356: rpad('Assignment Number', 18) ||

Line 4354: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');

4350: PROCEDURE write_header(p_type varchar2) IS
4351: BEGIN
4352: fnd_file.put_line(fnd_file.output,null);
4353: if p_type = 'F' then
4354: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4355: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4356: rpad('Assignment Number', 18) ||
4357: rpad('Error Message',87));
4358: else

Line 4355: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||

4351: BEGIN
4352: fnd_file.put_line(fnd_file.output,null);
4353: if p_type = 'F' then
4354: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4355: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4356: rpad('Assignment Number', 18) ||
4357: rpad('Error Message',87));
4358: else
4359: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');

Line 4359: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');

4355: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4356: rpad('Assignment Number', 18) ||
4357: rpad('Error Message',87));
4358: else
4359: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');
4360: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4361: rpad('Assignment Number', 18) ||
4362: rpad('Warning Message',87));
4363: end if;

Line 4360: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||

4356: rpad('Assignment Number', 18) ||
4357: rpad('Error Message',87));
4358: else
4359: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');
4360: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4361: rpad('Assignment Number', 18) ||
4362: rpad('Warning Message',87));
4363: end if;
4364: fnd_file.put_line(fnd_file.output,rpad('-',25,'-') || ' ' ||

Line 4364: fnd_file.put_line(fnd_file.output,rpad('-',25,'-') || ' ' ||

4360: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4361: rpad('Assignment Number', 18) ||
4362: rpad('Warning Message',87));
4363: end if;
4364: fnd_file.put_line(fnd_file.output,rpad('-',25,'-') || ' ' ||
4365: rpad('-',17,'-') || ' ' ||
4366: rpad('-',87,'-'));
4367: END write_header;
4368:

Line 4396: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||

4392: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4393: select length(l_msg) into l_msg_length from dual;
4394: if l_first then
4395: l_first := false;
4396: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4397: rpad(p_emp_no, 17) || ' ' ||
4398: rpad(nvl(p_element,' '),30) || '-' ||
4399: rpad(l_out,56));
4400: else

Line 4401: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||

4397: rpad(p_emp_no, 17) || ' ' ||
4398: rpad(nvl(p_element,' '),30) || '-' ||
4399: rpad(l_out,56));
4400: else
4401: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||
4402: rpad(' ', 17) || ' ' ||
4403: rpad(' ', 30) || ' ' ||
4404: rpad(l_out,56));
4405: end if;

Line 4409: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||

4405: end if;
4406: end loop;
4407: if l_first then
4408: l_first := false;
4409: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4410: rpad(p_emp_no, 17) || ' ' ||
4411: rpad(nvl(p_element,' '),30) || '-' ||
4412: rpad(l_msg,56));
4413: else

Line 4414: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||

4410: rpad(p_emp_no, 17) || ' ' ||
4411: rpad(nvl(p_element,' '),30) || '-' ||
4412: rpad(l_msg,56));
4413: else
4414: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||
4415: rpad(' ', 17) || ' ' ||
4416: rpad(' ', 30) || ' ' ||
4417: rpad(l_msg,56));
4418: end if;

Line 4424: fnd_file.put_line(fnd_file.output,null);

4420:
4421: PROCEDURE write_footer(p_type varchar2,
4422: p_total varchar2) IS
4423: BEGIN
4424: fnd_file.put_line(fnd_file.output,null);
4425: if p_type = 'F' then
4426: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4427: else
4428: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));

Line 4426: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));

4422: p_total varchar2) IS
4423: BEGIN
4424: fnd_file.put_line(fnd_file.output,null);
4425: if p_type = 'F' then
4426: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4427: else
4428: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));
4429: end if;
4430: END write_footer;

Line 4428: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));

4424: fnd_file.put_line(fnd_file.output,null);
4425: if p_type = 'F' then
4426: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4427: else
4428: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));
4429: end if;
4430: END write_footer;
4431:
4432: BEGIN

Line 4515: fnd_file.put_line(fnd_file.output,

4511:
4512: hr_utility.trace('Summing expenses payments ');
4513: FOR expenses_payment_chk IN csr_expenses_payment_chk
4514: LOOP
4515: fnd_file.put_line(fnd_file.output,
4516: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');
4517: fnd_file.put_line(fnd_file.output,
4518: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4519: END LOOP;

Line 4517: fnd_file.put_line(fnd_file.output,

4513: FOR expenses_payment_chk IN csr_expenses_payment_chk
4514: LOOP
4515: fnd_file.put_line(fnd_file.output,
4516: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');
4517: fnd_file.put_line(fnd_file.output,
4518: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4519: END LOOP;
4520:
4521: write_error_log(pactid);