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

Line 294: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

290: EXCEPTION
291: WHEN OTHERS THEN
292: hr_utility.set_location('Error in function fetch_p60_payroll_det ', 15);
293: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
294: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
295: RAISE;
296: END fetch_p60_payroll_det;
297:
298: --

Line 549: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

545: EXCEPTION
546: WHEN OTHERS THEN
547: hr_utility.set_location('Error in function fetch_p60_emp_det ', 15);
548: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
549: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
550: RAISE;
551: END fetch_p60_emp_det;
552:
553: --

Line 1191: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

1187: EXCEPTION
1188: WHEN OTHERS THEN
1189: hr_utility.set_location('Error in function fetch_p60_asg_det ', 15);
1190: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
1191: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1192: RAISE;
1193: END fetch_p60_asg_det;
1194: --
1195: -- Procedure to insert data to the archive table pay_action_information

Line 3157: fnd_file.put_line (fnd_file.LOG,'You must provide a Unique Test ID if the EDI Test Indicator is Yes.');

3153:
3154: -- Unique Test ID is mandatory if EDI Test indicator is Yes
3155:
3156: IF (l_test_indicator = 'Y' AND l_unique_test_id IS NULL) THEN
3157: fnd_file.put_line (fnd_file.LOG,'You must provide a Unique Test ID if the EDI Test Indicator is Yes.');
3158: -- RAISE test_indicator_error;
3159: END IF;
3160:
3161: -- End BUG 5909829 EOY

Line 3191: fnd_file.put_line(fnd_file.log,

3187: hr_utility.set_location('Leaving: '||l_proc,40);
3188: EXCEPTION
3189: WHEN OTHERS THEN
3190: hr_utility.set_location(' Leaving: '||l_proc,50);
3191: fnd_file.put_line(fnd_file.log,
3192: substr('Error in rangecode '||sqlerrm(sqlcode),1,80));
3193: -- Return cursor that selects no rows
3194: sqlstr := 'select 1 from dual where to_char(:payroll_action_id) = dummy';
3195: END range_cursor;

Line 3806: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);

3802: hr_utility.set_location('Leaving '|| l_proc, 10);
3803:
3804: EXCEPTION
3805: WHEN OTHERS THEN
3806: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
3807: hr_utility.raise_error;
3808: END archinit;
3809: --
3810: --

Line 4145: fnd_file.put_line (fnd_file.LOG,'NO RTI Reporting asg for :'|| l_asg_id);

4141: hr_utility.set_location('l_ni_rpt_date: ' || l_ni_rpt_date, 50);
4142:
4143: if l_ni_rpt_asg_id is null then
4144: hr_utility.set_location('NO RTI Reporting asg for :'|| l_asg_id, 50);
4145: fnd_file.put_line (fnd_file.LOG,'NO RTI Reporting asg for :'|| l_asg_id);
4146: end if;
4147: end if;
4148:
4149: if (l_per_ni_agg_flag1 = 'Y' and l_ni_rpt_asg_id = l_asg_id) then

Line 4445: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');

4441: hr_utility.set_location('Leaving: '||l_proc,999);
4442: EXCEPTION
4443: WHEN error_found THEN
4444: -- reset_flag('GB_RTI_ASG_DETAILS',g_reset_flag_type, p_assactid);
4445: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
4446: raise_application_error(-20001,'Errors found while archiving data.');
4447:
4448: WHEN already_processed THEN
4449: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');

Line 4449: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');

4445: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
4446: raise_application_error(-20001,'Errors found while archiving data.');
4447:
4448: WHEN already_processed THEN
4449: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');
4450:
4451: WHEN OTHERS THEN
4452: fnd_file.put_line(fnd_file.LOG,'An error encountered was - '||SQLERRM);
4453: raise_application_error(-20001,'An error encountered was - '||SQLERRM);

Line 4452: fnd_file.put_line(fnd_file.LOG,'An error encountered was - '||SQLERRM);

4448: WHEN already_processed THEN
4449: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');
4450:
4451: WHEN OTHERS THEN
4452: fnd_file.put_line(fnd_file.LOG,'An error encountered was - '||SQLERRM);
4453: raise_application_error(-20001,'An error encountered was - '||SQLERRM);
4454: END archive_code;
4455: --
4456: --

Line 4627: fnd_file.put_line(fnd_file.output,' ');

4623: END IF;
4624:
4625: l_form_name :='RTI - P60 Archive Process';
4626:
4627: fnd_file.put_line(fnd_file.output,' ');
4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

Line 4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);

4624:
4625: l_form_name :='RTI - P60 Archive Process';
4626:
4627: fnd_file.put_line(fnd_file.output,' ');
4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

Line 4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

4625: l_form_name :='RTI - P60 Archive Process';
4626:
4627: fnd_file.put_line(fnd_file.output,' ');
4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

Line 4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

4626:
4627: fnd_file.put_line(fnd_file.output,' ');
4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

Line 4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

4627: fnd_file.put_line(fnd_file.output,' ');
4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
4635:

Line 4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

4628: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
4635:
4636: IF LENGTH(l_addr2) > 0 THEN

Line 4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

4629: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
4635:
4636: IF LENGTH(l_addr2) > 0 THEN
4637: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

Line 4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

4630: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
4631: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
4632: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
4635:
4636: IF LENGTH(l_addr2) > 0 THEN
4637: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
4638: END IF;

Line 4637: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

4633: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
4634: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
4635:
4636: IF LENGTH(l_addr2) > 0 THEN
4637: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
4638: END IF;
4639: IF LENGTH(l_addr3) > 0 THEN
4640: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
4641: END IF;

Line 4640: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);

4636: IF LENGTH(l_addr2) > 0 THEN
4637: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
4638: END IF;
4639: IF LENGTH(l_addr3) > 0 THEN
4640: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
4641: END IF;
4642: IF LENGTH(l_addr4) > 0 THEN
4643: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
4644: END IF;

Line 4643: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);

4639: IF LENGTH(l_addr3) > 0 THEN
4640: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
4641: END IF;
4642: IF LENGTH(l_addr4) > 0 THEN
4643: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
4644: END IF;
4645:
4646: END write_header;
4647: ---

Line 4653: fnd_file.put_line(fnd_file.output,NULL);

4649: p_type VARCHAR2,
4650: report_type VARCHAR2)
4651: IS
4652: BEGIN
4653: fnd_file.put_line(fnd_file.output,NULL);
4654: IF p_type = 'E' THEN
4655: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
4656: ELSIF p_type = 'W' THEN
4657: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');

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

4651: IS
4652: BEGIN
4653: fnd_file.put_line(fnd_file.output,NULL);
4654: IF p_type = 'E' THEN
4655: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
4656: ELSIF p_type = 'W' THEN
4657: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
4658: ELSE
4659: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

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

4653: fnd_file.put_line(fnd_file.output,NULL);
4654: IF p_type = 'E' THEN
4655: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
4656: ELSIF p_type = 'W' THEN
4657: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
4658: ELSE
4659: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
4660: END IF;
4661:

Line 4659: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

4655: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
4656: ELSIF p_type = 'W' THEN
4657: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
4658: ELSE
4659: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
4660: END IF;
4661:
4662: IF p_type = 'W' THEN -- warning records
4663: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)

Line 4663: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)

4659: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
4660: END IF;
4661:
4662: IF p_type = 'W' THEN -- warning records
4663: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
4664: || rpad('Warning Messages',30));
4665: ELSIF p_type <> 'E' THEN --Completed records
4666: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
4667: ELSE -- errored records

Line 4666: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));

4662: IF p_type = 'W' THEN -- warning records
4663: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
4664: || rpad('Warning Messages',30));
4665: ELSIF p_type <> 'E' THEN --Completed records
4666: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
4667: ELSE -- errored records
4668: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
4669: || rpad('Error Messages',30));
4670: END IF;

Line 4668: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)

4664: || rpad('Warning Messages',30));
4665: ELSIF p_type <> 'E' THEN --Completed records
4666: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
4667: ELSE -- errored records
4668: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
4669: || rpad('Error Messages',30));
4670: END IF;
4671:
4672: IF p_type = 'W' THEN -- warning records

Line 4673: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '

4669: || rpad('Error Messages',30));
4670: END IF;
4671:
4672: IF p_type = 'W' THEN -- warning records
4673: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
4674: || rpad('-',30,'-'));
4675: ELSIF p_type <> 'E' THEN -- Completed records
4676: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
4677: ELSE -- errored records

Line 4676: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));

4672: IF p_type = 'W' THEN -- warning records
4673: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
4674: || rpad('-',30,'-'));
4675: ELSIF p_type <> 'E' THEN -- Completed records
4676: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
4677: ELSE -- errored records
4678: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
4679: || rpad('-',30,'-'));
4680: END IF;

Line 4678: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '

4674: || rpad('-',30,'-'));
4675: ELSIF p_type <> 'E' THEN -- Completed records
4676: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
4677: ELSE -- errored records
4678: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
4679: || rpad('-',30,'-'));
4680: END IF;
4681: END write_sub_header;
4682: ---

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

4785: open csr_get_eff_date(pactid);
4786: fetch csr_get_eff_date into l_effective_date;
4787: close csr_get_eff_date;
4788:
4789: fnd_file.put_line(fnd_file.LOG, 'l_effective_date: ' || l_effective_date);
4790: --Completed Records
4791:
4792: IF p_type = 'ET'THEN
4793: FOR action_id IN get_asg_action_id

Line 4800: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '

4796: FETCH get_person_details INTO et_asg_rec;
4797: CLOSE get_person_details;
4798: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
4799: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4800: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4801: || rpad(l_et_temp,50) );
4802: ELSE
4803: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4804: || rpad(l_et_temp,50));

Line 4803: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '

4799: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4800: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4801: || rpad(l_et_temp,50) );
4802: ELSE
4803: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
4804: || rpad(l_et_temp,50));
4805: END IF;
4806: l_count := l_count + 1;
4807: END LOOP;

Line 4830: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

4826: l_error_flag := 'Y';
4827:
4828: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4829: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4830: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4831: || ' ' || rpad(err_msg,120) ); -- error message
4832: ELSE
4833: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4834: || ' ' || rpad(err_msg,120) ); -- error message

Line 4833: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

4829: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4830: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4831: || ' ' || rpad(err_msg,120) ); -- error message
4832: ELSE
4833: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4834: || ' ' || rpad(err_msg,120) ); -- error message
4835: END IF;
4836:
4837: -- To print remaining error messgaes if any

Line 4842: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg,120));

4838: LOOP
4839: FETCH csr_err_msg INTO err_msg;
4840: EXIT
4841: WHEN csr_err_msg%notfound;
4842: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg,120));
4843: END LOOP;
4844:
4845: CLOSE csr_err_msg;
4846: l_count := l_count + 1;

Line 4849: fnd_file.put_line(fnd_file.output,NULL);

4845: CLOSE csr_err_msg;
4846: l_count := l_count + 1;
4847: END LOOP;
4848: END IF;
4849: fnd_file.put_line(fnd_file.output,NULL);
4850:
4851: -- Warning Records
4852: IF p_type = 'W'THEN
4853:

Line 4870: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

4866: NULL;
4867: ELSE
4868: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
4869: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4870: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4871: || ' ' || rpad(err_msg,100) );
4872: ELSE
4873: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4874: || ' ' || rpad(err_msg,100) );

Line 4873: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)

4869: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
4870: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4871: || ' ' || rpad(err_msg,100) );
4872: ELSE
4873: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
4874: || ' ' || rpad(err_msg,100) );
4875: END IF;
4876: l_count_warns := l_count_warns + 1;
4877: END IF;

Line 4883: fnd_file.put_line(fnd_file.output,NULL);

4879:
4880: END LOOP;
4881:
4882: END IF;
4883: fnd_file.put_line(fnd_file.output,NULL);
4884:
4885: IF p_type = 'E' THEN
4886: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
4887: ELSIF p_type = 'W' THEN

Line 4886: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);

4882: END IF;
4883: fnd_file.put_line(fnd_file.output,NULL);
4884:
4885: IF p_type = 'E' THEN
4886: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
4887: ELSIF p_type = 'W' THEN
4888: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
4889: ELSE
4890: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

Line 4888: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);

4884:
4885: IF p_type = 'E' THEN
4886: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
4887: ELSIF p_type = 'W' THEN
4888: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
4889: ELSE
4890: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
4891: END IF;
4892: l_counter := l_counter + l_count;

Line 4890: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

4886: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
4887: ELSIF p_type = 'W' THEN
4888: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
4889: ELSE
4890: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
4891: END IF;
4892: l_counter := l_counter + l_count;
4893: END write_body;
4894: ---

Line 4914: fnd_file.put_line(fnd_file.output,NULL);

4910: OPEN get_person_count;
4911: FETCH get_person_count INTO l_person_count;
4912: CLOSE get_person_count;
4913:
4914: fnd_file.put_line(fnd_file.output,NULL);
4915: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
4916: fnd_file.put_line(fnd_file.output,NULL);
4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
4918: END write_footer;

Line 4915: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);

4911: FETCH get_person_count INTO l_person_count;
4912: CLOSE get_person_count;
4913:
4914: fnd_file.put_line(fnd_file.output,NULL);
4915: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
4916: fnd_file.put_line(fnd_file.output,NULL);
4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
4918: END write_footer;
4919: ---------------------

Line 4916: fnd_file.put_line(fnd_file.output,NULL);

4912: CLOSE get_person_count;
4913:
4914: fnd_file.put_line(fnd_file.output,NULL);
4915: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
4916: fnd_file.put_line(fnd_file.output,NULL);
4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
4918: END write_footer;
4919: ---------------------
4920: BEGIN

Line 4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);

4913:
4914: fnd_file.put_line(fnd_file.output,NULL);
4915: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
4916: fnd_file.put_line(fnd_file.output,NULL);
4917: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
4918: END write_footer;
4919: ---------------------
4920: BEGIN
4921: hr_utility.trace('Entering deinit: '||l_proc);

Line 4958: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');

4954: hr_utility.set_location('Leaving: '||l_proc,999);
4955:
4956: EXCEPTION
4957: When l_exp then
4958: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
4959: raise_application_error(-20001,'Errors found while archiving data.');
4960: END deinitialization_code;
4961: --
4962: /**

Line 4972: fnd_file.put_line(fnd_file.LOG,'p_column_name: ' || p_column_name || '-' ||'p_peop_grp_id: '|| p_peop_grp_id);

4968: l_col_val varchar2(100);
4969: begin
4970: hr_utility.set_location('p_column_name: ' || p_column_name,60);
4971: hr_utility.set_location('p_peop_grp_id: '|| p_peop_grp_id,60);
4972: fnd_file.put_line(fnd_file.LOG,'p_column_name: ' || p_column_name || '-' ||'p_peop_grp_id: '|| p_peop_grp_id);
4973:
4974: if p_column_name is not null and p_peop_grp_id is not null then
4975: l_stmt := 'select '|| p_column_name ||' from pay_people_groups pp where pp.people_group_id = :PEOPLE_GRP_ID';
4976: execute immediate l_stmt into l_col_val using p_peop_grp_id;

Line 4977: fnd_file.put_line(fnd_file.LOG,'P-value: ' || l_col_val);

4973:
4974: if p_column_name is not null and p_peop_grp_id is not null then
4975: l_stmt := 'select '|| p_column_name ||' from pay_people_groups pp where pp.people_group_id = :PEOPLE_GRP_ID';
4976: execute immediate l_stmt into l_col_val using p_peop_grp_id;
4977: fnd_file.put_line(fnd_file.LOG,'P-value: ' || l_col_val);
4978: return l_col_val;
4979: else
4980: return null;
4981: end if;