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_OUTPUT dependencies on HR_UTILITY

Line 38: hr_utility.set_location('Entering: '||l_proc,1);

34: test_indicator_error EXCEPTION;
35: l_proc CONSTANT VARCHAR2(50):= g_package||'range_cursor';
36: BEGIN
37:
38: hr_utility.set_location('Entering: '||l_proc,1);
39:
40: sqlstr := 'select distinct person_id '||
41: 'from per_people_f ppf, '||
42: 'pay_payroll_actions ppa '||

Line 47: hr_utility.set_location(' Leaving: '||l_proc,100);

43: 'where ppa.payroll_action_id = :pactid '||
44: 'and ppa.business_group_id = ppf.business_group_id '||
45: 'order by ppf.person_id';
46:
47: hr_utility.set_location(' Leaving: '||l_proc,100);
48: END range_cursor;
49: --
50: --
51:

Line 64: hr_utility.set_location('Entering: '||l_proc,1);

60: l_output VARCHAR2(4000);
61: EOL VARCHAR2(5);
62: l_proc CONSTANT VARCHAR2(50):= g_package||'convert_2_xml';
63: BEGIN
64: hr_utility.set_location('Entering: '||l_proc,1);
65:
66: SELECT
67: fnd_global.local_chr(13) || fnd_global.local_chr(10)
68: INTO EOL

Line 101: hr_utility.set_location(' Leaving: '||l_proc,2);

97: END IF;
98: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
99: || ''||EOL;
100: END IF;
101: hr_utility.set_location(' Leaving: '||l_proc,2);
102: RETURN l_output;
103: END convert_2_xml;
104:
105: /*****************************************************************************/

Line 174: hr_utility.set_location('Entering : '||l_proc,4);

170: l_arch_pay_action_id number;
171:
172: BEGIN
173:
174: hr_utility.set_location('Entering : '||l_proc,4);
175:
176:
177: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
178: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);

Line 178: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);

174: hr_utility.set_location('Entering : '||l_proc,4);
175:
176:
177: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
178: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);
179:
180: open csr_arch_payroll_action_id(l_mag_payroll_actid);
181: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
182: close csr_arch_payroll_action_id;

Line 184: hr_utility.trace('RTI FPS Archive Payroll action ='||l_arch_pay_action_id);

180: open csr_arch_payroll_action_id(l_mag_payroll_actid);
181: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
182: close csr_arch_payroll_action_id;
183:
184: hr_utility.trace('RTI FPS Archive Payroll action ='||l_arch_pay_action_id);
185: open get_footer_details(l_arch_pay_action_id);
186: fetch get_footer_details
187: into l_final_submission_ceased,
188: l_final_submission_year,

Line 239: hr_utility.trace('Final output : '||l_final_xml_string );

235: --''||EOL||
236: '';
237:
238: pay_core_files.write_to_magtape_lob(l_final_xml_string);
239: hr_utility.trace('Final output : '||l_final_xml_string );
240: hr_utility.set_location(' Leaving: '||l_proc,4);
241:
242:
243: END;

Line 240: hr_utility.set_location(' Leaving: '||l_proc,4);

236: '';
237:
238: pay_core_files.write_to_magtape_lob(l_final_xml_string);
239: hr_utility.trace('Final output : '||l_final_xml_string );
240: hr_utility.set_location(' Leaving: '||l_proc,4);
241:
242:
243: END;
244: END end_of_file;

Line 315: hr_utility.trace('+==========================================================+');

311:
312:
313: BEGIN
314:
315: hr_utility.trace('+==========================================================+');
316: hr_utility.trace('Entering fps_header_proc');
317:
318: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
319: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);

Line 316: hr_utility.trace('Entering fps_header_proc');

312:
313: BEGIN
314:
315: hr_utility.trace('+==========================================================+');
316: hr_utility.trace('Entering fps_header_proc');
317:
318: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
319: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);
320:

Line 319: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);

315: hr_utility.trace('+==========================================================+');
316: hr_utility.trace('Entering fps_header_proc');
317:
318: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
319: hr_utility.trace('RTI FPS Mag Payroll action ='||l_mag_payroll_actid);
320:
321: open csr_arch_payroll_action_id(l_mag_payroll_actid);
322: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
323: close csr_arch_payroll_action_id;

Line 325: hr_utility.trace('RTI FPS Archive Payroll action ='||l_arch_pay_action_id);

321: open csr_arch_payroll_action_id(l_mag_payroll_actid);
322: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
323: close csr_arch_payroll_action_id;
324:
325: hr_utility.trace('RTI FPS Archive Payroll action ='||l_arch_pay_action_id);
326: open get_header_details(l_arch_pay_action_id);
327: fetch get_header_details
328: into l_payroll_prod_ver,
329: l_employer_name,

Line 381: hr_utility.trace('Final output : '||l_final_xml_string );

377: tab_header(tax_year)||EOL||
378: '';
379:
380: pay_core_files.write_to_magtape_lob(l_final_xml_string);
381: hr_utility.trace('Final output : '||l_final_xml_string );
382: hr_utility.trace('X==========================================================X');
383:
384: END;
385: END fps_header_proc;

Line 382: hr_utility.trace('X==========================================================X');

378: '';
379:
380: pay_core_files.write_to_magtape_lob(l_final_xml_string);
381: hr_utility.trace('Final output : '||l_final_xml_string );
382: hr_utility.trace('X==========================================================X');
383:
384: END;
385: END fps_header_proc;
386:

Line 776: hr_utility.set_location(' Entering: '||l_proc,15);

772:
773:
774:
775: BEGIN
776: hr_utility.set_location(' Entering: '||l_proc,15);
777: hr_utility.set_location('Employee Record',16);
778:
779: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
780: hr_utility.set_location('RTI FPS Mag Payroll action ='||l_mag_payroll_actid,17);

Line 777: hr_utility.set_location('Employee Record',16);

773:
774:
775: BEGIN
776: hr_utility.set_location(' Entering: '||l_proc,15);
777: hr_utility.set_location('Employee Record',16);
778:
779: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
780: hr_utility.set_location('RTI FPS Mag Payroll action ='||l_mag_payroll_actid,17);
781:

Line 780: hr_utility.set_location('RTI FPS Mag Payroll action ='||l_mag_payroll_actid,17);

776: hr_utility.set_location(' Entering: '||l_proc,15);
777: hr_utility.set_location('Employee Record',16);
778:
779: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
780: hr_utility.set_location('RTI FPS Mag Payroll action ='||l_mag_payroll_actid,17);
781:
782: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
783: hr_utility.set_location('RTI FPS Mag Assignment action ='|| to_char(l_mag_asg_action_id),18);
784:

Line 783: hr_utility.set_location('RTI FPS Mag Assignment action ='|| to_char(l_mag_asg_action_id),18);

779: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
780: hr_utility.set_location('RTI FPS Mag Payroll action ='||l_mag_payroll_actid,17);
781:
782: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
783: hr_utility.set_location('RTI FPS Mag Assignment action ='|| to_char(l_mag_asg_action_id),18);
784:
785:
786:
787: open csr_arch_payroll_action_id(l_mag_payroll_actid);

Line 791: hr_utility.set_location('RTI FPS Archive Payroll action ='|| to_char(l_arch_pay_action_id),19);

787: open csr_arch_payroll_action_id(l_mag_payroll_actid);
788: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
789: close csr_arch_payroll_action_id;
790:
791: hr_utility.set_location('RTI FPS Archive Payroll action ='|| to_char(l_arch_pay_action_id),19);
792:
793: open get_arch_asg_actid
794: (l_mag_payroll_actid,
795: l_mag_asg_action_id,

Line 801: hr_utility.set_location('RTI FPS Archive Assignment action ='|| to_char(l_arch_asg_action_id),20);

797: fetch get_arch_asg_actid
798: into l_arch_asg_action_id;
799: close get_arch_asg_actid;
800:
801: hr_utility.set_location('RTI FPS Archive Assignment action ='|| to_char(l_arch_asg_action_id),20);
802:
803: l_process_flag := 'Y';
804:
805: open get_other_asg_act_ids (l_arch_pay_action_id, l_arch_asg_action_id);

Line 812: hr_utility.set_location('Current assignment_action_id '|| to_char(l_arch_asg_action_id)|| 'is already processed,

808: into l_other_asg_arch_id,
809: l_other_asg_act_arch_id;
810:
811: if l_other_asg_act_arch_id < l_arch_asg_action_id then
812: hr_utility.set_location('Current assignment_action_id '|| to_char(l_arch_asg_action_id)|| 'is already processed,
813: while processing the assignment_id '||l_other_asg_arch_id,25);
814: l_process_flag := 'N';
815: end if;
816:

Line 829: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,32);

825: -- Below if will be for complete reporting logic
826: if l_process_flag = 'Y' then
827:
828: open get_emp_details (l_arch_asg_action_id);
829: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,32);
830: fetch get_emp_details
831: into l_address_line1,
832: l_address_line2,
833: l_address_line3,

Line 1099: hr_utility.set_location('Creating FPS Employee XML String',34);

1095: := convert_2_xml(l_bacs_hash_code,'BACS');
1096:
1097:
1098:
1099: hr_utility.set_location('Creating FPS Employee XML String',34);
1100: l_final_xml_string := ''
1101: ||EOL||
1102: tab_employee(address_line1)||
1103: tab_employee(address_line2)||

Line 1120: hr_utility.set_location('Creating FPS Assignment XML String',35);

1116: tab_employee(partner_first_name)||
1117: tab_employee(partner_second_name)||
1118: tab_employee(partner_ni_number);
1119:
1120: hr_utility.set_location('Creating FPS Assignment XML String',35);
1121: l_final_xml_string := l_final_xml_string||''||
1122: tab_employee(start_empl_date)||
1123: tab_employee(date_of_leaving)||
1124: tab_employee(payment_date)||

Line 1241: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_pay_action_id :'||l_arch_pay_action_id,36);

1237:
1238: ------------
1239:
1240: open get_other_asg_act_ids(l_arch_pay_action_id, l_arch_asg_action_id );
1241: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_pay_action_id :'||l_arch_pay_action_id,36);
1242: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_asg_action_id :'||l_arch_asg_action_id,37);
1243:
1244: loop
1245: fetch get_other_asg_act_ids

Line 1242: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_asg_action_id :'||l_arch_asg_action_id,37);

1238: ------------
1239:
1240: open get_other_asg_act_ids(l_arch_pay_action_id, l_arch_asg_action_id );
1241: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_pay_action_id :'||l_arch_pay_action_id,36);
1242: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_asg_action_id :'||l_arch_asg_action_id,37);
1243:
1244: loop
1245: fetch get_other_asg_act_ids
1246: into l_other_asg_arch_id,

Line 1248: hr_utility.set_location('l_other_asg_arch_id :'||l_other_asg_arch_id,38);

1244: loop
1245: fetch get_other_asg_act_ids
1246: into l_other_asg_arch_id,
1247: l_other_asg_act_arch_id;
1248: hr_utility.set_location('l_other_asg_arch_id :'||l_other_asg_arch_id,38);
1249: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);
1250:
1251: exit when get_other_asg_act_ids%notfound;
1252:

Line 1249: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);

1245: fetch get_other_asg_act_ids
1246: into l_other_asg_arch_id,
1247: l_other_asg_act_arch_id;
1248: hr_utility.set_location('l_other_asg_arch_id :'||l_other_asg_arch_id,38);
1249: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);
1250:
1251: exit when get_other_asg_act_ids%notfound;
1252:
1253:

Line 1255: hr_utility.set_location('Inside get_asg_details1 2nd Time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,33);

1251: exit when get_other_asg_act_ids%notfound;
1252:
1253:
1254: open get_asg_details1 (l_other_asg_act_arch_id);
1255: hr_utility.set_location('Inside get_asg_details1 2nd Time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,33);
1256: fetch get_asg_details1
1257: into l_start_empl_date,
1258: l_date_of_leaving,
1259: l_payment_date,

Line 1286: hr_utility.set_location('Inside get_asg_details2 2nd Time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,33);

1282: l_bacs_hash_code;
1283: close get_asg_details1;
1284:
1285: open get_asg_details2 (l_other_asg_act_arch_id);
1286: hr_utility.set_location('Inside get_asg_details2 2nd Time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,33);
1287: fetch get_asg_details2
1288: into l_taxable_pay_to_date,
1289: l_total_tax,
1290: l_student_loan_rec,

Line 1313: hr_utility.set_location('Creating FPS Assignment XML String',41);

1309: l_week_month_indicator;
1310:
1311: close get_asg_details2;
1312:
1313: hr_utility.set_location('Creating FPS Assignment XML String',41);
1314:
1315:
1316: tab_employee(start_empl_date)
1317: := convert_2_xml(l_start_empl_date,'S_DATE');

Line 1581: hr_utility.set_location('Created Final FPS XML Output:'||l_final_xml_string,42);

1577: ------------
1578:
1579: end loop;
1580: l_final_xml_string := l_final_xml_string||'';
1581: hr_utility.set_location('Created Final FPS XML Output:'||l_final_xml_string,42);
1582: close get_other_asg_act_ids;
1583:
1584: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1585:

Line 1588: hr_utility.set_location(' Leaving: '||l_proc,43);

1584: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1585:
1586: end if;
1587:
1588: hr_utility.set_location(' Leaving: '||l_proc,43);
1589: END;
1590:
1591: END fps_employee_proc;
1592:

Line 1633: hr_utility.set_location('Entering: '||l_proc,53);

1629: lockingactid number;
1630: lv_assignment_id number;
1631: l_arch_payroll_action_id number;
1632: BEGIN
1633: hr_utility.set_location('Entering: '||l_proc,53);
1634: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),54);
1635:
1636: open csr_arch_payroll_action_id;
1637: fetch csr_arch_payroll_action_id into l_arch_payroll_action_id;

Line 1634: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),54);

1630: lv_assignment_id number;
1631: l_arch_payroll_action_id number;
1632: BEGIN
1633: hr_utility.set_location('Entering: '||l_proc,53);
1634: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),54);
1635:
1636: open csr_arch_payroll_action_id;
1637: fetch csr_arch_payroll_action_id into l_arch_payroll_action_id;
1638: close csr_arch_payroll_action_id;

Line 1640: hr_utility.set_location('RTI FPS Archive Payroll action ='|| to_char(l_arch_payroll_action_id),55);

1636: open csr_arch_payroll_action_id;
1637: fetch csr_arch_payroll_action_id into l_arch_payroll_action_id;
1638: close csr_arch_payroll_action_id;
1639:
1640: hr_utility.set_location('RTI FPS Archive Payroll action ='|| to_char(l_arch_payroll_action_id),55);
1641:
1642: open csr_asg(l_arch_payroll_action_id);
1643: loop
1644: fetch csr_asg into lv_assignment_id;

Line 1646: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);

1642: open csr_asg(l_arch_payroll_action_id);
1643: loop
1644: fetch csr_asg into lv_assignment_id;
1645: exit when csr_asg%notfound;
1646: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1647:
1648: -- Create one assignment action for every assignment
1649: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1650: select pay_assignment_actions_s.nextval

Line 1649: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);

1645: exit when csr_asg%notfound;
1646: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1647:
1648: -- Create one assignment action for every assignment
1649: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1650: select pay_assignment_actions_s.nextval
1651: into lockingactid
1652: from dual;
1653:

Line 1667: hr_utility.set_location('Leaving: '||l_proc,58);

1663:
1664: end loop;
1665: close csr_asg;
1666:
1667: hr_utility.set_location('Leaving: '||l_proc,58);
1668: --
1669: END action_creation;
1670:
1671: end PAY_GB_RTI_FPS_OUTPUT;