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

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

613: EXCEPTION
614: WHEN OTHERS THEN
615: hr_utility.trace('Exception in get hours worked end of function block.');
616: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
617: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
618: return null;
619: END get_hours_worked;
620:
621: /*

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

766: EXCEPTION
767: WHEN OTHERS THEN
768: hr_utility.trace('Exception in get_periods_covered end of function block.');
769: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
770: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
771: return null;
772: END get_periods_covered;
773:
774:

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

922: EXCEPTION
923: WHEN OTHERS THEN
924: hr_utility.trace('Exception in get_irregular_payment end of function block.');
925: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
926: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
927: return null;
928: END get_irregular_payment;
929:
930:

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

1076: EXCEPTION
1077: WHEN OTHERS THEN
1078: hr_utility.trace('Exception in get_oneoff_payment end of function block.');
1079: hr_utility.trace(SQLCODE || ' - ' || sqlerrm );
1080: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
1081: return null;
1082: END get_oneoff_payment;
1083: /*
1084: Returns the passport number for the person from the source configured in Configuration

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

2147: EXCEPTION
2148: WHEN OTHERS THEN
2149: hr_utility.set_location('Error in function fetch_fps_asg_det1 ', 15);
2150: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
2151: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
2152: RAISE;
2153: END fetch_fps_asg_det1;
2154: --
2155:

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

2962: EXCEPTION
2963: WHEN OTHERS THEN
2964: hr_utility.set_location('Error in function fetch_fps_asg_det1 ', 15);
2965: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
2966: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
2967: RAISE;
2968: END fetch_fps_nopay_asg_det1;
2969:
2970: -- Function to fetch Assignment details for Aggregated employees (CONTEXT - GB_RTI_FPS_ASG_DET1)

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

3769: EXCEPTION
3770: WHEN OTHERS THEN
3771: hr_utility.set_location('Error in function fetch_fps_aggr_asg_det1 ', 15);
3772: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
3773: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
3774: RAISE;
3775: END fetch_fps_aggr_asg_det1;
3776: --
3777:

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

4204: EXCEPTION
4205: WHEN OTHERS THEN
4206: hr_utility.set_location('Error in function fetch_fps_asg_det2 ', 15);
4207: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
4208: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
4209: RAISE;
4210:
4211: END fetch_first_fps_asg_det2;
4212:

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

4443: EXCEPTION
4444: WHEN OTHERS THEN
4445: hr_utility.set_location('Error in function fetch_first_fps_agg_asg_det2 ', 15);
4446: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
4447: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
4448: RAISE;
4449:
4450: END fetch_first_fps_agg_asg_det2;
4451:

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

5108: EXCEPTION
5109: WHEN OTHERS THEN
5110: hr_utility.set_location('Error in function fetch_fps_asg_det2 ', 15);
5111: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
5112: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
5113: RAISE;
5114: END fetch_fps_asg_det2;
5115: --
5116: --

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

5788: EXCEPTION
5789: WHEN OTHERS THEN
5790: hr_utility.set_location('Error in function fetch_fps_agg_asg_det2 ', 15);
5791: hr_utility.trace('Exception:' || SQLCODE || ' - ' || SQLERRM );
5792: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
5793: RAISE;
5794: END fetch_fps_agg_asg_det2;
5795:
5796: PROCEDURE populate_run_msg(

Line 6099: fnd_file.put_line (fnd_file.LOG,'Error : First FPS has already been run for the requested payroll. Either rollback or select to run a normal FPS.');

6095: fetch c_first_fps_ran into l_frst_fps_ran;
6096: close c_first_fps_ran;
6097:
6098: if l_frst_fps_ran = 'Y' then
6099: fnd_file.put_line (fnd_file.LOG,'Error : First FPS has already been run for the requested payroll. Either rollback or select to run a normal FPS.');
6100: raise first_fps_ran_already_error;
6101: end if;
6102: end if;
6103:

Line 6106: fnd_file.put_line (fnd_file.LOG,'Error : First FPS date should not be entered when First FPS Indicator is not Yes.');

6102: end if;
6103:
6104: if l_first_fps_ind is not null and l_first_fps_ind <> 'Y'
6105: and l_first_fps_date is not null then
6106: fnd_file.put_line (fnd_file.LOG,'Error : First FPS date should not be entered when First FPS Indicator is not Yes.');
6107: RAISE first_fps_indicator_error;
6108: end if;
6109:
6110: if l_first_fps_ind = 'Y' and l_first_fps_date is null then

Line 6111: fnd_file.put_line (fnd_file.LOG,'Error : Enter the First FPS date when First FPS Indicator is Yes.');

6107: RAISE first_fps_indicator_error;
6108: end if;
6109:
6110: if l_first_fps_ind = 'Y' and l_first_fps_date is null then
6111: fnd_file.put_line (fnd_file.LOG,'Error : Enter the First FPS date when First FPS Indicator is Yes.');
6112: RAISE first_fps_indicator_error;
6113: end if;
6114:
6115: sqlstr := 'select distinct PERSON_ID '|| 'from per_all_assignments_f paaf, '

Line 6860: fnd_file.put_line (fnd_file.LOG,'No Payment has been made for assignment ' || asg_record.assignment_id|| '.');

6856:
6857: -- If there are no assignment action ids, no payment has been made for the assignment
6858: -- This assignment will not be archived.
6859: IF l_last_asg_action_id is null then
6860: fnd_file.put_line (fnd_file.LOG,'No Payment has been made for assignment ' || asg_record.assignment_id|| '.');
6861: l_flag:= 'N';
6862: end if;
6863: CLOSE csr_last_action;
6864:

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

7087:
7088: if l_ni_rpt_asg_id is null then
7089:
7090: hr_utility.set_location('NO RTI Reporting asg for :'|| l_asg_number, 50);
7091: fnd_file.put_line (fnd_file.LOG,'NO RTI Reporting asg for :'|| l_asg_number);
7092: --raise_application_error(-20001,'NO RTI Reporting asg for :'|| asg_rec.assignment_id);
7093: else
7094: -- check whether the RTI reporting is being processed in the current assignment.
7095: open csr_rti_rpt_proc_prepay(l_ni_rpt_asg_id,l_pre_pact_id);

Line 7536: fnd_file.put_line(fnd_file.LOG,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');

7532: if (g_start_year <= l_pre_pact_effective_date and g_end_year >= l_pre_pact_effective_date) then
7533: hr_utility.trace('Valid Effective Date for FPS Concurrent Program');
7534: else
7535: hr_utility.trace('Invalid Effective Date for FPS Concurrent Program');
7536: fnd_file.put_line(fnd_file.LOG,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7537: fnd_file.put_line(fnd_file.output,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7538: raise_application_error(-20001,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7539: end if;
7540:

Line 7537: fnd_file.put_line(fnd_file.output,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');

7533: hr_utility.trace('Valid Effective Date for FPS Concurrent Program');
7534: else
7535: hr_utility.trace('Invalid Effective Date for FPS Concurrent Program');
7536: fnd_file.put_line(fnd_file.LOG,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7537: fnd_file.put_line(fnd_file.output,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7538: raise_application_error(-20001,'FPS Program Effective date must be within the tax year of corresponding Pre-Payment Process Effective Date.');
7539: end if;
7540:
7541: /*

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

7597: hr_utility.set_location('Leaving '|| l_proc, 10);
7598:
7599: EXCEPTION
7600: WHEN OTHERS THEN
7601: fnd_file.put_line(fnd_file.LOG,'Exception:' || SQLCODE || ' - ' || SQLERRM);
7602: hr_utility.raise_error;
7603: END archinit;
7604: --
7605: procedure add_other_asg_ni_ytd(c_asg_act_id in number , p_archive_tab in out nocopy act_info_rec) is

Line 9832: fnd_file.put_line (fnd_file.LOG,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');

9828: end if;
9829: exception
9830: when others then
9831: populate_run_msg(p_assactid, 'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
9832: fnd_file.put_line (fnd_file.LOG,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
9833: raise_application_error(-20001,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
9834: end;
9835:
9836: hr_utility.trace('l_large_bacs_payment: '||l_large_bacs_payment);

Line 10144: fnd_file.put_line(fnd_file.LOG,'Not Archiving');

10140: IF l_archive_person AND l_archive_addr AND l_archive_asg_det1 AND l_archive_asg_det2 THEN
10141: IF l_personaddr_val_err OR l_fps_val_err OR l_fps_ni_val_err -- If validation fails , that record will not be archived.
10142: THEN
10143: hr_utility.set_location('Validation failed, raise error.',999);
10144: fnd_file.put_line(fnd_file.LOG,'Not Archiving');
10145: raise error_found;
10146: ELSE
10147: hr_utility.set_location('Validation successful, archive data.',999);
10148: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);

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

10298: --Raising Exception for the current assignment
10299: if (csr_aggr_all_payroll_actions%NOTFOUND) then
10300: hr_utility.trace('Current Assignment is already processed in an earlier FPS run. Hence, not processing now.');
10301: populate_run_msg(p_assactid, 'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.','W');
10302: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');
10303: raise already_processed;
10304: end if;
10305: --
10306: hr_utility.trace('l_single_payroll_run_exists start point: ' ||l_single_payroll_run_exists);

Line 10374: fnd_file.put_line (fnd_file.LOG,' Pre payment is not run for the assignment '||l_assignment_number||' (asg action id: '|| l_cur_asg_action_id||')');

10370: CLOSE csr_asg_num;
10371:
10372: hr_utility.set_location('Pre payment is not run for asg action id: '|| l_cur_asg_action_id,999);
10373: populate_run_msg(p_assactid, ' Pre payment is not run for the assignment '||l_assignment_number||' (asg action id: '|| l_cur_asg_action_id||')');
10374: fnd_file.put_line (fnd_file.LOG,' Pre payment is not run for the assignment '||l_assignment_number||' (asg action id: '|| l_cur_asg_action_id||')');
10375: raise error_found;
10376:
10377: --prepayment run check ends here
10378: else

Line 10507: fnd_file.put_line (fnd_file.log,'Hash error1 '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');

10503: END IF;
10504: EXCEPTION
10505: WHEN others THEN
10506: populate_run_msg (p_assactid,'Hash error1 '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');
10507: fnd_file.put_line (fnd_file.log,'Hash error1 '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');
10508: raise_application_error(-20001,'Hash error1 '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
10509: END;
10510:
10511: hr_utility.trace('l_large_bacs_payment: '||l_large_bacs_payment);

Line 10868: fnd_file.put_line (fnd_file.LOG,' Assignment ' || l_assignment_number|| ' is already processed.');

10864: if (nvl(l_asg_act_processed_earlier,-1) <> 0 and l_retry_req_flag is not null ) then
10865: hr_utility.trace('Current Assignment is already processed in an earlier FPS run. Hence, not processing now.');
10866: l_archive_flag := 'N';
10867: populate_run_msg(p_assactid, ' Assignment ' || l_assignment_number|| ' is already processed.','W');
10868: fnd_file.put_line (fnd_file.LOG,' Assignment ' || l_assignment_number|| ' is already processed.');
10869:
10870: else --this else is for nvl(l_asg_act_processed_earlier,-1) <> 0
10871:
10872: hr_utility.trace('l_processed_in_prepayment: ' ||l_processed_in_prepayment);

Line 10907: fnd_file.put_line (fnd_file.log,'Hash error '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');

10903: END IF;
10904: EXCEPTION
10905: WHEN others THEN
10906: populate_run_msg (p_assactid,'Hash error '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');
10907: fnd_file.put_line (fnd_file.log,'Hash error '|| sqlerrm|| ' for the assignment '|| l_assignment_number|| '.');
10908: raise_application_error(-20001,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
10909: END;
10910:
10911: hr_utility.trace('l_large_bacs_payment: '||l_large_bacs_payment);

Line 11288: fnd_file.put_line (fnd_file.LOG,' Assignment ' || l_assignment_number|| ' is already processed.');

11284: if (nvl(l_asg_act_processed_earlier,-1) <> 0 and l_retry_req_flag is null) then
11285: hr_utility.trace('Current Assignment is already processed in an earlier FPS run. Hence, not processing now.');
11286: l_archive_flag := 'N';
11287: populate_run_msg(p_assactid, ' Assignment ' || l_assignment_number|| ' is already processed.','W');
11288: fnd_file.put_line (fnd_file.LOG,' Assignment ' || l_assignment_number|| ' is already processed.');
11289:
11290: end if;
11291:
11292: end if;

Line 11409: fnd_file.put_line(fnd_file.LOG,'Not Archiving');

11405: -- IF l_personaddr_val_err OR l_fps_val_err OR l_fps_ni_val_err -- If validation fails , that record will not be archived.
11406: IF l_personaddr_val_err OR l_fps_val_err OR l_fps_ni_val_err -- If validation fails , that record will not be archived.
11407: THEN
11408: hr_utility.set_location('Validation failed, raise error.',999);
11409: fnd_file.put_line(fnd_file.LOG,'Not Archiving');
11410: raise error_found;
11411: ELSE
11412: hr_utility.set_location('Validation successful, archive data.',999);
11413: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);

Line 11541: fnd_file.put_line (fnd_file.LOG,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');

11537: end if;
11538: exception
11539: when others then
11540: populate_run_msg(p_assactid, 'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
11541: fnd_file.put_line (fnd_file.LOG,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
11542: raise_application_error(-20001,'Hash error '||SQLERRM||' for the assignment ' || l_assignment_number|| '.');
11543: end;
11544:
11545: hr_utility.trace('l_large_bacs_payment: '||l_large_bacs_payment);

Line 12002: fnd_file.put_line(fnd_file.LOG,'Not Archiving');

11998: -- IF l_personaddr_val_err OR l_fps_val_err OR l_fps_ni_val_err -- If validation fails , that record will not be archived.
11999: IF l_personaddr_val_err OR l_fps_val_err OR l_fps_ni_val_err-- If validation fails , that record will not be archived.
12000: THEN
12001: hr_utility.set_location('Validation failed, raise error.',999);
12002: fnd_file.put_line(fnd_file.LOG,'Not Archiving');
12003: raise error_found;
12004: ELSE
12005: hr_utility.set_location('Validation successful, archive data.',999);
12006: if l_ni_rti_flag = 'Y' then

Line 12274: fnd_file.put_line(fnd_file.LOG,'No NI reporting assignment for the assignment: ' || l_asg_id);

12270: );
12271: end if; --l_ni_aggr_max_act_id = l_last_asg_action_id
12272: else
12273: hr_utility.set_location('No NI reporting assignment for the assignment: ' || l_asg_id ,1000);
12274: fnd_file.put_line(fnd_file.LOG,'No NI reporting assignment for the assignment: ' || l_asg_id);
12275: populate_run_msg(p_assactid, 'No NI reporting assignment for the assignment: '||l_assignment_number);
12276: raise error_found;
12277: end if; -- l_ni_rpt_asg_id is not null
12278: -- make the NI YTD to 0.

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

12318:
12319: EXCEPTION
12320: WHEN error_found THEN
12321: reset_flag('GB_RTI_ASG_DETAILS',g_reset_flag_type, p_assactid);
12322: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
12323: raise_application_error(-20001,'Errors found while archiving data.');
12324:
12325: WHEN already_processed THEN
12326: 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 12326: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');

12322: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
12323: raise_application_error(-20001,'Errors found while archiving data.');
12324:
12325: WHEN already_processed THEN
12326: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');
12327:
12328: WHEN OTHERS THEN
12329: fnd_file.put_line(fnd_file.LOG,'An error encountered was - '||SQLERRM);
12330: raise_application_error(-20001,'An error encountered was - '||SQLERRM);

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

12325: WHEN already_processed THEN
12326: fnd_file.put_line (fnd_file.LOG,'Current Assignment '|| l_assignment_number ||' is already processed in an earlier FPS run. Hence, not processing now.');
12327:
12328: WHEN OTHERS THEN
12329: fnd_file.put_line(fnd_file.LOG,'An error encountered was - '||SQLERRM);
12330: raise_application_error(-20001,'An error encountered was - '||SQLERRM);
12331: END archive_code;
12332: --
12333: --

Line 12547: fnd_file.put_line(fnd_file.output,'Pre-Payments is not run for few errored employments. Must Rollback this FPS, Complete Pre-Payments and then Re-Submit FPS.');

12543: OPEN csr_prepay_err_msg(action_id.asg_action_id);
12544: FETCH csr_prepay_err_msg INTO l_err_msg;
12545: exit when csr_prepay_err_msg%notfound;
12546:
12547: fnd_file.put_line(fnd_file.output,'Pre-Payments is not run for few errored employments. Must Rollback this FPS, Complete Pre-Payments and then Re-Submit FPS.');
12548: -- exit when csr_prepay_err_msg%found;
12549: CLOSE csr_prepay_err_msg;
12550: END loop;
12551:

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

12548: -- exit when csr_prepay_err_msg%found;
12549: CLOSE csr_prepay_err_msg;
12550: END loop;
12551:
12552: fnd_file.put_line(fnd_file.output,' ');
12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

Line 12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');

12549: CLOSE csr_prepay_err_msg;
12550: END loop;
12551:
12552: fnd_file.put_line(fnd_file.output,' ');
12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));

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

12550: END loop;
12551:
12552: fnd_file.put_line(fnd_file.output,' ');
12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);

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

12551:
12552: fnd_file.put_line(fnd_file.output,' ');
12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

Line 12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);

12552: fnd_file.put_line(fnd_file.output,' ');
12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));

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

12553: fnd_file.put_line(fnd_file.output,'EDI Transmission Report:');
12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);

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

12554: fnd_file.put_line(fnd_file.output,' ');
12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

Line 12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);

12555: fnd_file.put_line(fnd_file.output,rpad('Form Type : ',32) || l_form_name);
12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);

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

12556: fnd_file.put_line(fnd_file.output,rpad('Sender : ',32) || l_det.sender_id);
12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);

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

12557: fnd_file.put_line(fnd_file.output,rpad('Date : ',32) || TO_CHAR(sysdate, 'DD/MM/YYYY HH24:MI:SS'));
12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
12565:

Line 12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);

12558: fnd_file.put_line(fnd_file.output,rpad('Interchange Control Reference : ',32) || l_param.control_id);
12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
12565:
12566: IF LENGTH(l_addr2) > 0 THEN

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

12559: fnd_file.put_line(fnd_file.output,rpad('Test Transmission : ',32) || l_test);
12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
12565:
12566: IF LENGTH(l_addr2) > 0 THEN
12567: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);

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

12560: fnd_file.put_line(fnd_file.output,rpad('-',80,'-'));
12561: fnd_file.put_line(fnd_file.output,rpad('Employers PAYE Reference : ',32) || l_tax_ref);
12562: fnd_file.put_line(fnd_file.output,rpad('HRMC Office : ',32) || l_det.hrmc_office);
12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
12565:
12566: IF LENGTH(l_addr2) > 0 THEN
12567: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
12568: END IF;

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

12563: fnd_file.put_line(fnd_file.output,rpad('Employer Name : ',32) || l_det.er_name);
12564: fnd_file.put_line(fnd_file.output,rpad('Employer Address : ',32) || l_addr1);
12565:
12566: IF LENGTH(l_addr2) > 0 THEN
12567: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
12568: END IF;
12569: IF LENGTH(l_addr3) > 0 THEN
12570: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
12571: END IF;

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

12566: IF LENGTH(l_addr2) > 0 THEN
12567: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr2);
12568: END IF;
12569: IF LENGTH(l_addr3) > 0 THEN
12570: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
12571: END IF;
12572: IF LENGTH(l_addr4) > 0 THEN
12573: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
12574: END IF;

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

12569: IF LENGTH(l_addr3) > 0 THEN
12570: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr3);
12571: END IF;
12572: IF LENGTH(l_addr4) > 0 THEN
12573: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
12574: END IF;
12575:
12576: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
12577: fnd_file.put_line(fnd_file.output,rpad('Prepayment Effective Date : ',32) || l_prepay_eff_date);

Line 12576: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);

12572: IF LENGTH(l_addr4) > 0 THEN
12573: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
12574: END IF;
12575:
12576: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
12577: fnd_file.put_line(fnd_file.output,rpad('Prepayment Effective Date : ',32) || l_prepay_eff_date);
12578:
12579: END write_header;
12580: ---

Line 12577: fnd_file.put_line(fnd_file.output,rpad('Prepayment Effective Date : ',32) || l_prepay_eff_date);

12573: fnd_file.put_line(fnd_file.output,rpad(' ',32) || l_addr4);
12574: END IF;
12575:
12576: fnd_file.put_line(fnd_file.output,rpad('Payroll : ',32) || l_payroll_name);
12577: fnd_file.put_line(fnd_file.output,rpad('Prepayment Effective Date : ',32) || l_prepay_eff_date);
12578:
12579: END write_header;
12580: ---
12581: PROCEDURE write_sub_header(

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

12582: p_type VARCHAR2,
12583: report_type VARCHAR2)
12584: IS
12585: BEGIN
12586: fnd_file.put_line(fnd_file.output,NULL);
12587: IF p_type = 'E' THEN
12588: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
12589: ELSIF p_type = 'W' THEN
12590: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');

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

12584: IS
12585: BEGIN
12586: fnd_file.put_line(fnd_file.output,NULL);
12587: IF p_type = 'E' THEN
12588: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
12589: ELSIF p_type = 'W' THEN
12590: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
12591: ELSE
12592: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');

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

12586: fnd_file.put_line(fnd_file.output,NULL);
12587: IF p_type = 'E' THEN
12588: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
12589: ELSIF p_type = 'W' THEN
12590: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
12591: ELSE
12592: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
12593: END IF;
12594:

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

12588: fnd_file.put_line(fnd_file.output,'The following employments have completed with error');
12589: ELSIF p_type = 'W' THEN
12590: fnd_file.put_line(fnd_file.output,'The following employments have completed with warning');
12591: ELSE
12592: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
12593: END IF;
12594:
12595: IF p_type = 'W' THEN -- warning records
12596: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)

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

12592: fnd_file.put_line(fnd_file.output,'The following employments have completed successfully');
12593: END IF;
12594:
12595: IF p_type = 'W' THEN -- warning records
12596: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
12597: || rpad('Warning Messages',30));
12598: ELSIF p_type <> 'E' THEN --Completed records
12599: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
12600: ELSE -- errored records

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

12595: IF p_type = 'W' THEN -- warning records
12596: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
12597: || rpad('Warning Messages',30));
12598: ELSIF p_type <> 'E' THEN --Completed records
12599: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
12600: ELSE -- errored records
12601: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
12602: || rpad('Error Messages',30));
12603: END IF;

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

12597: || rpad('Warning Messages',30));
12598: ELSIF p_type <> 'E' THEN --Completed records
12599: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51));
12600: ELSE -- errored records
12601: fnd_file.put_line(fnd_file.output,rpad('Assignment Number',19) || rpad('NI Number',11) || rpad('Employee Name', 51)
12602: || rpad('Error Messages',30));
12603: END IF;
12604:
12605: IF p_type = 'W' THEN -- warning records

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

12602: || rpad('Error Messages',30));
12603: END IF;
12604:
12605: IF p_type = 'W' THEN -- warning records
12606: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
12607: || rpad('-',30,'-'));
12608: ELSIF p_type <> 'E' THEN -- Completed records
12609: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
12610: ELSE -- errored records

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

12605: IF p_type = 'W' THEN -- warning records
12606: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
12607: || rpad('-',30,'-'));
12608: ELSIF p_type <> 'E' THEN -- Completed records
12609: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
12610: ELSE -- errored records
12611: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
12612: || rpad('-',30,'-'));
12613: END IF;

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

12607: || rpad('-',30,'-'));
12608: ELSIF p_type <> 'E' THEN -- Completed records
12609: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-'));
12610: ELSE -- errored records
12611: fnd_file.put_line(fnd_file.output,rpad('-',18,'-') || ' ' || rpad('-',10,'-') || ' ' || rpad('-',50,'-') || ' '
12612: || rpad('-',30,'-'));
12613: END IF;
12614: END write_sub_header;
12615: ---

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

12717: l_count_warns := 0;
12718: open csr_get_prepayment_date(g_pre_pact_id);
12719: fetch csr_get_prepayment_date into l_effective_date;
12720: close csr_get_prepayment_date;
12721: fnd_file.put_line(fnd_file.LOG, 'l_effective_date: ' || l_effective_date);
12722: --Completed Records
12723: IF p_type = 'ET'THEN
12724: FOR action_id IN get_asg_action_id
12725: LOOP

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

12727: FETCH get_person_details INTO et_asg_rec;
12728: CLOSE get_person_details;
12729: l_et_temp := et_asg_rec.l_name || ', '|| et_asg_rec.title || ' ' || et_asg_rec.f_name || ' ' || et_asg_rec.m_name;
12730: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12731: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
12732: || rpad(l_et_temp,50) );
12733: ELSE
12734: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
12735: || rpad(l_et_temp,50));

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

12730: IF et_asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12731: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
12732: || rpad(l_et_temp,50) );
12733: ELSE
12734: fnd_file.put_line(fnd_file.output,rpad(et_asg_rec.emp_no, 18) || ' ' || rpad(et_asg_rec.ni_no ,10) || ' '
12735: || rpad(l_et_temp,50));
12736: END IF;
12737: l_count := l_count + 1;
12738: END LOOP;

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

12757: l_error_flag := 'Y';
12758:
12759: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
12760: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12761: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12762: || ' ' || rpad(err_msg,120) ); -- error message
12763: ELSE
12764: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12765: || ' ' || rpad(err_msg,120) ); -- error message

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

12760: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12761: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12762: || ' ' || rpad(err_msg,120) ); -- error message
12763: ELSE
12764: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12765: || ' ' || rpad(err_msg,120) ); -- error message
12766: END IF;
12767:
12768: -- To print remaining error messgaes if any

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

12769: LOOP
12770: FETCH csr_err_msg INTO err_msg;
12771: EXIT
12772: WHEN csr_err_msg%notfound;
12773: fnd_file.put_line(fnd_file.output,rpad(' ',81,' ')||rpad(err_msg,120));
12774: END LOOP;
12775:
12776: CLOSE csr_err_msg;
12777: l_count := l_count + 1;

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

12776: CLOSE csr_err_msg;
12777: l_count := l_count + 1;
12778: END LOOP;
12779: END IF;
12780: fnd_file.put_line(fnd_file.output,NULL);
12781:
12782: -- Warning Records
12783: IF p_type = 'W'THEN
12784:

Line 12793: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);

12789: OPEN get_person_details(action_id.assignment_id);
12790: FETCH get_person_details INTO asg_rec;
12791: CLOSE get_person_details;
12792:
12793: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
12794:
12795: OPEN csr_warn_msg(action_id.asg_action_id);
12796: FETCH csr_warn_msg INTO err_msg;
12797:

Line 12798: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);

12794:
12795: OPEN csr_warn_msg(action_id.asg_action_id);
12796: FETCH csr_warn_msg INTO err_msg;
12797:
12798: -- fnd_file.put_line(fnd_file.LOG,'action_id.asg_action_id: '||action_id.asg_action_id);
12799:
12800: /* if csr_err_msg%notfound then
12801: SELECT LINE_TEXT into err_msg FROM pay_message_lines WHERE source_id = action_id.asg_action_id
12802: AND MESSAGE_LEVEL = 'W' and rownum <=1;

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

12807: NULL;
12808: ELSE
12809: l_temp := asg_rec.l_name || ', '|| asg_rec.title || ' ' || asg_rec.f_name || ' ' || asg_rec.m_name;
12810: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12811: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12812: || ' ' || rpad(err_msg,100) );
12813: ELSE
12814: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12815: || ' ' || rpad(err_msg,100) );

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

12810: IF asg_rec.end_date = fnd_date.canonical_to_date('4712/12/31 00:00:00') THEN
12811: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12812: || ' ' || rpad(err_msg,100) );
12813: ELSE
12814: fnd_file.put_line(fnd_file.output,rpad(asg_rec.emp_no, 18) || ' ' || rpad(asg_rec.ni_no ,10) || ' ' || rpad(l_temp,50)
12815: || ' ' || rpad(err_msg,100) );
12816: END IF;
12817: l_count_warns := l_count_warns + 1;
12818: END IF;

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

12820:
12821: END LOOP;
12822:
12823: END IF;
12824: fnd_file.put_line(fnd_file.output,NULL);
12825:
12826: IF p_type = 'E' THEN
12827: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
12828: ELSIF p_type = 'W' THEN

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

12823: END IF;
12824: fnd_file.put_line(fnd_file.output,NULL);
12825:
12826: IF p_type = 'E' THEN
12827: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
12828: ELSIF p_type = 'W' THEN
12829: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
12830: ELSE
12831: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);

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

12825:
12826: IF p_type = 'E' THEN
12827: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
12828: ELSIF p_type = 'W' THEN
12829: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
12830: ELSE
12831: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
12832: END IF;
12833: l_counter := l_counter + l_count;

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

12827: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with error : ' || l_count);
12828: ELSIF p_type = 'W' THEN
12829: fnd_file.put_line(fnd_file.output,'Total Number of employments completed with warning : ' || l_count_warns);
12830: ELSE
12831: fnd_file.put_line(fnd_file.output,'Total Number of employments completed successfully :' || l_count);
12832: END IF;
12833: l_counter := l_counter + l_count;
12834: END write_body;
12835: ---

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

12853: OPEN get_person_count;
12854: FETCH get_person_count INTO l_person_count;
12855: CLOSE get_person_count;
12856:
12857: fnd_file.put_line(fnd_file.output,NULL);
12858: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
12859: fnd_file.put_line(fnd_file.output,NULL);
12860: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
12861: END write_footer;

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

12854: FETCH get_person_count INTO l_person_count;
12855: CLOSE get_person_count;
12856:
12857: fnd_file.put_line(fnd_file.output,NULL);
12858: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
12859: fnd_file.put_line(fnd_file.output,NULL);
12860: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
12861: END write_footer;
12862: ---------------------

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

12855: CLOSE get_person_count;
12856:
12857: fnd_file.put_line(fnd_file.output,NULL);
12858: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
12859: fnd_file.put_line(fnd_file.output,NULL);
12860: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
12861: END write_footer;
12862: ---------------------
12863: BEGIN

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

12856:
12857: fnd_file.put_line(fnd_file.output,NULL);
12858: fnd_file.put_line(fnd_file.output,'Total Number of employments : ' || l_counter);
12859: fnd_file.put_line(fnd_file.output,NULL);
12860: fnd_file.put_line(fnd_file.output,'Total Number of employees successfully processed : ' || l_person_count);
12861: END write_footer;
12862: ---------------------
12863: BEGIN
12864: hr_utility.trace('Entering deinit: '||l_proc);

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

13020: end if;
13021: */
13022: EXCEPTION
13023: When l_exp then
13024: fnd_file.put_line(fnd_file.LOG,'Errors found while archiving data.');
13025: raise_application_error(-20001,'Errors found while archiving data.');
13026: END deinitialization_code;
13027: --
13028: END PAY_GB_RTI_FPS;