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 799: fnd_file.put_line(fnd_file.LOG,fnd_message.get);

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

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

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

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

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

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

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

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

1379: END IF;
1380:
1381: IF pay_gb_eoy_magtape.validate_input(UPPER(l_pay_info_tab(p_payroll_id).l_employers_ref_no) ) > 0
1382: THEN
1383: -- fnd_file.put_line(fnd_file.output,'Employers Reference Number contains illegal character(s) :' || l_employers_ref_no);
1384: RAISE employers_ref_no_error;
1385: END IF;
1386:
1387: 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 1394: -- fnd_file.put_line(fnd_file.output,'Employers Name contains illegal character(s) :' || l_employer_name );

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

Line 3719: fnd_file.put_line(

3715:
3716: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3717: IS
3718: BEGIN
3719: fnd_file.put_line(
3720: fnd_file.output,
3721: RPAD(NVL(employers_name, ' '), 20) || RPAD(NVL(person_name, ' '), 25) || RPAD(NVL(employee_num, ' '), 15) || err_text);
3722: END;
3723:

Line 3720: fnd_file.output,

3716: PROCEDURE write_log(employers_name VARCHAR2, person_name VARCHAR2, employee_num VARCHAR2, err_text VARCHAR2)
3717: IS
3718: BEGIN
3719: fnd_file.put_line(
3720: fnd_file.output,
3721: RPAD(NVL(employers_name, ' '), 20) || RPAD(NVL(person_name, ' '), 25) || RPAD(NVL(employee_num, ' '), 15) || err_text);
3722: END;
3723:
3724: PROCEDURE deinitialization_code(pactid IN NUMBER)

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

3842: person_table(l_count).person_id := x.action_information10;
3843: person_table(l_count).employee_no := x.action_information11;
3844: person_table(l_count).ni_number := x.action_information12;
3845: end loop;
3846: fnd_file.put_line(fnd_file.output,null);
3847: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3848: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3849: rpad(' Employee Name',26) ||
3850: rpad(' Employee Number',16));

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

3843: person_table(l_count).employee_no := x.action_information11;
3844: person_table(l_count).ni_number := x.action_information12;
3845: end loop;
3846: fnd_file.put_line(fnd_file.output,null);
3847: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3848: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3849: rpad(' Employee Name',26) ||
3850: rpad(' Employee Number',16));
3851: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||

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

3844: person_table(l_count).ni_number := x.action_information12;
3845: end loop;
3846: fnd_file.put_line(fnd_file.output,null);
3847: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3848: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3849: rpad(' Employee Name',26) ||
3850: rpad(' Employee Number',16));
3851: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||
3852: rpad('-',25,'-') || ' ' ||

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

3847: fnd_file.put_line(fnd_file.output,'Duplicate NI Number Report');
3848: fnd_file.put_line(fnd_file.output,rpad('Employer Name',20) ||
3849: rpad(' Employee Name',26) ||
3850: rpad(' Employee Number',16));
3851: fnd_file.put_line(fnd_file.output,rpad('-',20,'-') || ' ' ||
3852: rpad('-',25,'-') || ' ' ||
3853: rpad('-',16,'-') || ' ' ||
3854: rpad('-',55,'-'));
3855:

Line 3864: fnd_file.put_line(fnd_file.output,

3860: if l_curr > 1 then
3861: if (person_table(l_curr).ni_number = person_table(l_prev).ni_number
3862: and
3863: person_table(l_curr).person_id <> person_table(l_prev).person_id) then
3864: fnd_file.put_line(fnd_file.output,
3865: rpad(person_table(l_prev).employer_name,21) ||
3866: rpad(person_table(l_prev).full_name,26) ||
3867: rpad(person_table(l_prev).employee_no,16) ||
3868: 'This employee has a duplicate NI number ' || person_table(l_prev).ni_number);

Line 3869: fnd_file.put_line(fnd_file.output,

3865: rpad(person_table(l_prev).employer_name,21) ||
3866: rpad(person_table(l_prev).full_name,26) ||
3867: rpad(person_table(l_prev).employee_no,16) ||
3868: 'This employee has a duplicate NI number ' || person_table(l_prev).ni_number);
3869: fnd_file.put_line(fnd_file.output,
3870: rpad(person_table(l_curr).employer_name,21) ||
3871: rpad(person_table(l_curr).full_name,26) ||
3872: rpad(person_table(l_curr).employee_no,16) ||
3873: 'This employee has a duplicate NI number ' || person_table(l_curr).ni_number);

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

4072: l_person_count number;
4073:
4074: PROCEDURE write_header(p_employer_name varchar2) IS
4075: BEGIN
4076: fnd_file.put_line(fnd_file.output,'Employer Name : ' || p_employer_name);
4077: fnd_file.put_line(fnd_file.output,
4078: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4079: rpad('# People', 10) || rpad('# Entries', 10) ||
4080: rpad('Class 1A',16) || rpad('Non Class 1A',15));

Line 4077: fnd_file.put_line(fnd_file.output,

4073:
4074: PROCEDURE write_header(p_employer_name varchar2) IS
4075: BEGIN
4076: fnd_file.put_line(fnd_file.output,'Employer Name : ' || p_employer_name);
4077: fnd_file.put_line(fnd_file.output,
4078: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4079: rpad('# People', 10) || rpad('# Entries', 10) ||
4080: rpad('Class 1A',16) || rpad('Non Class 1A',15));
4081: fnd_file.put_line(fnd_file.output,

Line 4081: fnd_file.put_line(fnd_file.output,

4077: fnd_file.put_line(fnd_file.output,
4078: rpad('Benefit Type Element', 31) || rpad('Input Value', 29) ||
4079: rpad('# People', 10) || rpad('# Entries', 10) ||
4080: rpad('Class 1A',16) || rpad('Non Class 1A',15));
4081: fnd_file.put_line(fnd_file.output,
4082: rpad('-',30,'-') || ' ' ||
4083: rpad('-',28,'-') || ' ' ||
4084: rpad('-',9,'-') || ' ' ||
4085: rpad('-',9,'-') || ' ' ||

Line 4098: fnd_file.put_line(fnd_file.output,

4094: p_value varchar2,
4095: p_class_A boolean) IS
4096: BEGIN
4097: if p_class_A then
4098: fnd_file.put_line(fnd_file.output,
4099: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4100: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4101: rpad(p_value,15) || ' ' || rpad(' ',15));
4102: else

Line 4103: fnd_file.put_line(fnd_file.output,

4099: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4100: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4101: rpad(p_value,15) || ' ' || rpad(' ',15));
4102: else
4103: fnd_file.put_line(fnd_file.output,
4104: rpad(p_ben_name, 31) || rpad(p_inp_name, 29) ||
4105: lpad(p_nos_person,9) || ' ' || lpad(p_nos_entries,9) || ' ' ||
4106: rpad(' ',15) || ' ' || rpad(p_value,15));
4107: end if;

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

4110: PROCEDURE write_footer(p_class_a_value varchar2,
4111: p_nclass_value varchar2,
4112: p_total varchar2) IS
4113: BEGIN
4114: fnd_file.put_line(fnd_file.output,null);
4115: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4116: rpad(p_nclass_value,15) || rpad(p_total,16));
4117: fnd_file.put_line(fnd_file.output,null);
4118: END write_footer;

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

4111: p_nclass_value varchar2,
4112: p_total varchar2) IS
4113: BEGIN
4114: fnd_file.put_line(fnd_file.output,null);
4115: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4116: rpad(p_nclass_value,15) || rpad(p_total,16));
4117: fnd_file.put_line(fnd_file.output,null);
4118: END write_footer;
4119:

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

4113: BEGIN
4114: fnd_file.put_line(fnd_file.output,null);
4115: fnd_file.put_line(fnd_file.output,rpad('Total',80) || rpad(p_class_a_value,15) || ' ' ||
4116: rpad(p_nclass_value,15) || rpad(p_total,16));
4117: fnd_file.put_line(fnd_file.output,null);
4118: END write_footer;
4119:
4120: BEGIN
4121: fnd_file.put_line(fnd_file.output,null);

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

4117: fnd_file.put_line(fnd_file.output,null);
4118: END write_footer;
4119:
4120: BEGIN
4121: fnd_file.put_line(fnd_file.output,null);
4122: fnd_file.put_line(fnd_file.output,'P11D Summary Report');
4123: FOR employer IN get_employer(p_pact_id)
4124: LOOP
4125: l_1a_total := 0;

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

4118: END write_footer;
4119:
4120: BEGIN
4121: fnd_file.put_line(fnd_file.output,null);
4122: fnd_file.put_line(fnd_file.output,'P11D Summary Report');
4123: FOR employer IN get_employer(p_pact_id)
4124: LOOP
4125: l_1a_total := 0;
4126: l_n1a_total := 0;

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

4228: order by paf.assignment_number, element_name, pml.line_sequence;
4229:
4230: PROCEDURE write_header(p_type varchar2) IS
4231: BEGIN
4232: fnd_file.put_line(fnd_file.output,null);
4233: if p_type = 'F' then
4234: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4235: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4236: rpad('Assignment Number', 18) ||

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

4230: PROCEDURE write_header(p_type varchar2) IS
4231: BEGIN
4232: fnd_file.put_line(fnd_file.output,null);
4233: if p_type = 'F' then
4234: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4235: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4236: rpad('Assignment Number', 18) ||
4237: rpad('Error Message',87));
4238: else

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

4231: BEGIN
4232: fnd_file.put_line(fnd_file.output,null);
4233: if p_type = 'F' then
4234: fnd_file.put_line(fnd_file.output,'The following assignments have completed with error');
4235: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4236: rpad('Assignment Number', 18) ||
4237: rpad('Error Message',87));
4238: else
4239: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');

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

4235: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4236: rpad('Assignment Number', 18) ||
4237: rpad('Error Message',87));
4238: else
4239: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');
4240: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4241: rpad('Assignment Number', 18) ||
4242: rpad('Warning Message',87));
4243: end if;

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

4236: rpad('Assignment Number', 18) ||
4237: rpad('Error Message',87));
4238: else
4239: fnd_file.put_line(fnd_file.output,'The following assignments have completed with warning');
4240: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4241: rpad('Assignment Number', 18) ||
4242: rpad('Warning Message',87));
4243: end if;
4244: fnd_file.put_line(fnd_file.output,rpad('-',25,'-') || ' ' ||

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

4240: fnd_file.put_line(fnd_file.output,rpad('Employee Name', 26) ||
4241: rpad('Assignment Number', 18) ||
4242: rpad('Warning Message',87));
4243: end if;
4244: fnd_file.put_line(fnd_file.output,rpad('-',25,'-') || ' ' ||
4245: rpad('-',17,'-') || ' ' ||
4246: rpad('-',87,'-'));
4247: END write_header;
4248:

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

4272: select substr(l_msg,1,l_pos), substr(l_msg,l_pos + 1) into l_out, l_msg from dual;
4273: select length(l_msg) into l_msg_length from dual;
4274: if l_first then
4275: l_first := false;
4276: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4277: rpad(p_emp_no, 17) || ' ' ||
4278: rpad(nvl(p_element,' '),30) || '-' ||
4279: rpad(l_out,56));
4280: else

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

4277: rpad(p_emp_no, 17) || ' ' ||
4278: rpad(nvl(p_element,' '),30) || '-' ||
4279: rpad(l_out,56));
4280: else
4281: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||
4282: rpad(' ', 17) || ' ' ||
4283: rpad(' ', 30) || ' ' ||
4284: rpad(l_out,56));
4285: end if;

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

4285: end if;
4286: end loop;
4287: if l_first then
4288: l_first := false;
4289: fnd_file.put_line(fnd_file.output,rpad(p_emp_name, 25) || ' ' ||
4290: rpad(p_emp_no, 17) || ' ' ||
4291: rpad(nvl(p_element,' '),30) || '-' ||
4292: rpad(l_msg,56));
4293: else

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

4290: rpad(p_emp_no, 17) || ' ' ||
4291: rpad(nvl(p_element,' '),30) || '-' ||
4292: rpad(l_msg,56));
4293: else
4294: fnd_file.put_line(fnd_file.output,rpad(' ', 25) || ' ' ||
4295: rpad(' ', 17) || ' ' ||
4296: rpad(' ', 30) || ' ' ||
4297: rpad(l_msg,56));
4298: end if;

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

4300:
4301: PROCEDURE write_footer(p_type varchar2,
4302: p_total varchar2) IS
4303: BEGIN
4304: fnd_file.put_line(fnd_file.output,null);
4305: if p_type = 'F' then
4306: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4307: else
4308: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));

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

4302: p_total varchar2) IS
4303: BEGIN
4304: fnd_file.put_line(fnd_file.output,null);
4305: if p_type = 'F' then
4306: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4307: else
4308: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));
4309: end if;
4310: END write_footer;

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

4304: fnd_file.put_line(fnd_file.output,null);
4305: if p_type = 'F' then
4306: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with error :',45) || rpad(p_total,15));
4307: else
4308: fnd_file.put_line(fnd_file.output,rpad('Total Number of assignments with warning :',45) || rpad(p_total,15));
4309: end if;
4310: END write_footer;
4311:
4312: BEGIN

Line 4395: fnd_file.put_line(fnd_file.output,

4391:
4392: hr_utility.trace('Summing expenses payments ');
4393: FOR expenses_payment_chk IN csr_expenses_payment_chk
4394: LOOP
4395: fnd_file.put_line(fnd_file.output,
4396: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');
4397: fnd_file.put_line(fnd_file.output,
4398: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4399: END LOOP;

Line 4397: fnd_file.put_line(fnd_file.output,

4393: FOR expenses_payment_chk IN csr_expenses_payment_chk
4394: LOOP
4395: fnd_file.put_line(fnd_file.output,
4396: 'For Expenses Payments benefit, the Trading Orgainization Indicator has different values for different employees. ');
4397: fnd_file.put_line(fnd_file.output,
4398: 'All employees in your Business Group must have the same Trading Orgainization Indicator. ');
4399: END LOOP;
4400:
4401: write_error_log(pactid);