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

Line 27: g_debug BOOLEAN := hr_utility.debug_enabled;

23: =============================================================================*/
24: --
25: --
26:
27: g_debug BOOLEAN := hr_utility.debug_enabled;
28: EOL VARCHAR2(5) := fnd_global.local_chr(10);
29:
30: TYPE act_info_rec IS RECORD
31: ( assignment_id number(20)

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

92: l_report_type varchar2(15);
93: test_indicator_error EXCEPTION;
94: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
95: BEGIN
96: hr_utility.set_location('Entering: '||l_proc,1);
97:
98: sqlstr := 'select distinct person_id '||
99: 'from per_people_f ppf, '||
100: 'pay_payroll_actions ppa '||

Line 106: hr_utility.trace(' Range Cursor Statement : '||sqlstr);

102: 'and ppa.business_group_id = ppf.business_group_id '||
103: 'order by ppf.person_id';
104:
105:
106: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
107: hr_utility.set_location(' Leaving: '||l_proc,100);
108: END range_cursor;
109: --
110: --

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

103: 'order by ppf.person_id';
104:
105:
106: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
107: hr_utility.set_location(' Leaving: '||l_proc,100);
108: END range_cursor;
109: --
110: --
111:

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

121: l_output VARCHAR2(4000);
122: EOL VARCHAR2(5);
123: l_proc CONSTANT VARCHAR2(35):= g_package||'convert_2_xml';
124: BEGIN
125: hr_utility.set_location('Entering: '||l_proc,1);
126:
127: SELECT
128: fnd_global.local_chr(13) || fnd_global.local_chr(10)
129: INTO EOL

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

158: END IF;
159: l_output := '<' || trim(p_tag) || '>' || trim(l_data)
160: || ''||EOL;
161: END IF;
162: hr_utility.set_location(' Leaving: '||l_proc,2);
163: RETURN l_output;
164: END convert_2_xml;
165:
166: /*****************************************************************************/

Line 175: hr_utility.set_location('Entering: '||l_proc,3);

171: DECLARE
172: l_final_xml_string VARCHAR2(32000);
173: BEGIN
174:
175: hr_utility.set_location('Entering: '||l_proc,3);
176:
177: l_final_xml_string := '';
178:
179: hr_utility.trace(l_final_xml_string );

Line 179: hr_utility.trace(l_final_xml_string );

175: hr_utility.set_location('Entering: '||l_proc,3);
176:
177: l_final_xml_string := '';
178:
179: hr_utility.trace(l_final_xml_string );
180: pay_core_files.write_to_magtape_lob(l_final_xml_string);
181: hr_utility.set_location(' Leaving: '||l_proc,4);
182:
183: END;

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

177: l_final_xml_string := '';
178:
179: hr_utility.trace(l_final_xml_string );
180: pay_core_files.write_to_magtape_lob(l_final_xml_string);
181: hr_utility.set_location(' Leaving: '||l_proc,4);
182:
183: END;
184: END end_of_file;
185: /*****************************************************************************/

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

249: l_arch_pay_action_id number;
250:
251:
252: BEGIN
253: hr_utility.trace('+==========================================================+');
254: hr_utility.trace('Entering eas_header_proc');
255:
256: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
257: hr_utility.trace('RTI EAS Mag Payroll action ='||l_mag_payroll_actid);

Line 254: hr_utility.trace('Entering eas_header_proc');

250:
251:
252: BEGIN
253: hr_utility.trace('+==========================================================+');
254: hr_utility.trace('Entering eas_header_proc');
255:
256: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
257: hr_utility.trace('RTI EAS Mag Payroll action ='||l_mag_payroll_actid);
258:

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

253: hr_utility.trace('+==========================================================+');
254: hr_utility.trace('Entering eas_header_proc');
255:
256: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
257: hr_utility.trace('RTI EAS Mag Payroll action ='||l_mag_payroll_actid);
258:
259: open csr_arch_payroll_action_id(l_mag_payroll_actid);
260: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
261: close csr_arch_payroll_action_id;

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

259: open csr_arch_payroll_action_id(l_mag_payroll_actid);
260: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
261: close csr_arch_payroll_action_id;
262:
263: hr_utility.trace('RTI EAS Archive Payroll action ='||l_arch_pay_action_id);
264: open get_heder_details(l_arch_pay_action_id);
265: fetch get_heder_details
266: into l_payroll_prod_ver,
267: l_employer_name,

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

322: tab_header(system_date)||
323: '';
324:
325: pay_core_files.write_to_magtape_lob(l_final_xml_string);
326: hr_utility.trace('Final output : '||l_final_xml_string );
327: hr_utility.trace('X==========================================================X');
328:
329: END;
330: END eas_header_proc;

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

323: '';
324:
325: pay_core_files.write_to_magtape_lob(l_final_xml_string);
326: hr_utility.trace('Final output : '||l_final_xml_string );
327: hr_utility.trace('X==========================================================X');
328:
329: END;
330: END eas_header_proc;
331:

Line 402: hr_utility.set_location(' Entering: '||l_proc,11);

398: l_mag_payroll_actid number;
399: l_arch_pay_action_id number;
400:
401: BEGIN
402: hr_utility.set_location(' Entering: '||l_proc,11);
403:
404: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
405: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,12);
406:

Line 405: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,12);

401: BEGIN
402: hr_utility.set_location(' Entering: '||l_proc,11);
403:
404: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
405: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,12);
406:
407: open csr_arch_payroll_action_id(l_mag_payroll_actid);
408: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
409: close csr_arch_payroll_action_id;

Line 411: hr_utility.set_location('RTI NINO Archive Payroll action ='||l_arch_pay_action_id,13);

407: open csr_arch_payroll_action_id(l_mag_payroll_actid);
408: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
409: close csr_arch_payroll_action_id;
410:
411: hr_utility.set_location('RTI NINO Archive Payroll action ='||l_arch_pay_action_id,13);
412: open get_heder_details(l_arch_pay_action_id);
413: fetch get_heder_details
414: into l_payroll_prod_ver,
415: l_employer_name,

Line 456: hr_utility.set_location('Creating NINO Header XML String',12);

452: := convert_2_xml(l_system_time,'SYSTEM_TIME');
453:
454: -- Concatenation of XML Fields to create the Header
455:
456: hr_utility.set_location('Creating NINO Header XML String',12);
457:
458: l_final_xml_string := '
459: ' || EOL||
460: tab_header(sender_id)||

Line 477: hr_utility.set_location('Created NINO Header XML String',13);

473: tab_header(hmrc_office_no)||EOL||
474: tab_header(system_date)||
475: '';
476:
477: hr_utility.set_location('Created NINO Header XML String',13);
478: pay_core_files.write_to_magtape_lob(l_final_xml_string);
479: hr_utility.set_location(' Leaving: '||l_proc,14);
480:
481: END;

Line 479: hr_utility.set_location(' Leaving: '||l_proc,14);

475: '';
476:
477: hr_utility.set_location('Created NINO Header XML String',13);
478: pay_core_files.write_to_magtape_lob(l_final_xml_string);
479: hr_utility.set_location(' Leaving: '||l_proc,14);
480:
481: END;
482: END nino_header_proc;
483: /*****************************************************************************/

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

659: and pai_asg.action_information_category = 'GB RTI ASG DETAILS'
660: and pai_asg.action_context_type = 'AAP';
661:
662: BEGIN
663: hr_utility.set_location(' Entering: '||l_proc,15);
664: hr_utility.set_location('Employee Record',16);
665:
666: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
667: hr_utility.set_location('RTI EAS Mag Payroll action ='||l_mag_payroll_actid,17);

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

660: and pai_asg.action_context_type = 'AAP';
661:
662: BEGIN
663: hr_utility.set_location(' Entering: '||l_proc,15);
664: hr_utility.set_location('Employee Record',16);
665:
666: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
667: hr_utility.set_location('RTI EAS Mag Payroll action ='||l_mag_payroll_actid,17);
668:

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

663: hr_utility.set_location(' Entering: '||l_proc,15);
664: hr_utility.set_location('Employee Record',16);
665:
666: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
667: hr_utility.set_location('RTI EAS Mag Payroll action ='||l_mag_payroll_actid,17);
668:
669: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
670: hr_utility.set_location('RTI EAS Mag Assignment action ='|| to_char(l_mag_asg_action_id),18);
671:

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

666: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
667: hr_utility.set_location('RTI EAS Mag Payroll action ='||l_mag_payroll_actid,17);
668:
669: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
670: hr_utility.set_location('RTI EAS Mag Assignment action ='|| to_char(l_mag_asg_action_id),18);
671:
672:
673:
674: open csr_arch_payroll_action_id(l_mag_payroll_actid);

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

674: open csr_arch_payroll_action_id(l_mag_payroll_actid);
675: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
676: close csr_arch_payroll_action_id;
677:
678: hr_utility.set_location('RTI EAS Archive Payroll action ='|| to_char(l_arch_pay_action_id),19);
679:
680: open get_arch_asg_actid
681: (l_mag_payroll_actid,
682: l_mag_asg_action_id,

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

684: fetch get_arch_asg_actid
685: into l_arch_asg_action_id;
686: close get_arch_asg_actid;
687:
688: hr_utility.set_location('RTI EAS Archive Assignment action ='|| to_char(l_arch_asg_action_id),20);
689:
690: l_process_flag := 'Y';
691:
692: open get_other_asg_act_ids (l_arch_pay_action_id, l_arch_asg_action_id);

Line 693: hr_utility.set_location('l_arch_pay_action_id = '|| to_char(l_arch_pay_action_id),27);

689:
690: l_process_flag := 'Y';
691:
692: open get_other_asg_act_ids (l_arch_pay_action_id, l_arch_asg_action_id);
693: hr_utility.set_location('l_arch_pay_action_id = '|| to_char(l_arch_pay_action_id),27);
694: hr_utility.set_location('l_arch_asg_action_id = '|| to_char(l_arch_asg_action_id),28);
695:
696: hr_utility.set_location('Inside open get_other_asg_act_ids',21);
697:

Line 694: hr_utility.set_location('l_arch_asg_action_id = '|| to_char(l_arch_asg_action_id),28);

690: l_process_flag := 'Y';
691:
692: open get_other_asg_act_ids (l_arch_pay_action_id, l_arch_asg_action_id);
693: hr_utility.set_location('l_arch_pay_action_id = '|| to_char(l_arch_pay_action_id),27);
694: hr_utility.set_location('l_arch_asg_action_id = '|| to_char(l_arch_asg_action_id),28);
695:
696: hr_utility.set_location('Inside open get_other_asg_act_ids',21);
697:
698: hr_utility.set_location('rowcount check: '||get_other_asg_act_ids%rowcount,23);

Line 696: hr_utility.set_location('Inside open get_other_asg_act_ids',21);

692: open get_other_asg_act_ids (l_arch_pay_action_id, l_arch_asg_action_id);
693: hr_utility.set_location('l_arch_pay_action_id = '|| to_char(l_arch_pay_action_id),27);
694: hr_utility.set_location('l_arch_asg_action_id = '|| to_char(l_arch_asg_action_id),28);
695:
696: hr_utility.set_location('Inside open get_other_asg_act_ids',21);
697:
698: hr_utility.set_location('rowcount check: '||get_other_asg_act_ids%rowcount,23);
699:
700:

Line 698: hr_utility.set_location('rowcount check: '||get_other_asg_act_ids%rowcount,23);

694: hr_utility.set_location('l_arch_asg_action_id = '|| to_char(l_arch_asg_action_id),28);
695:
696: hr_utility.set_location('Inside open get_other_asg_act_ids',21);
697:
698: hr_utility.set_location('rowcount check: '||get_other_asg_act_ids%rowcount,23);
699:
700:
701:
702: loop

Line 703: hr_utility.set_location('Inside if1',24);

699:
700:
701:
702: loop
703: hr_utility.set_location('Inside if1',24);
704: fetch get_other_asg_act_ids
705: into l_other_asg_arch_id,
706: l_other_asg_act_arch_id;
707:

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

705: into l_other_asg_arch_id,
706: l_other_asg_act_arch_id;
707:
708: if l_other_asg_act_arch_id < l_arch_asg_action_id then
709: hr_utility.set_location('Current assignment_action_id '|| to_char(l_arch_asg_action_id)|| 'is already processed,
710: while processing the assignment_id '||l_other_asg_arch_id,25);
711: hr_utility.set_location('Inside if2',26);
712: l_process_flag := 'N';
713: end if;

Line 711: hr_utility.set_location('Inside if2',26);

707:
708: if l_other_asg_act_arch_id < l_arch_asg_action_id then
709: hr_utility.set_location('Current assignment_action_id '|| to_char(l_arch_asg_action_id)|| 'is already processed,
710: while processing the assignment_id '||l_other_asg_arch_id,25);
711: hr_utility.set_location('Inside if2',26);
712: l_process_flag := 'N';
713: end if;
714:
715: if (l_process_flag='N') then

Line 721: hr_utility.set_location('Outside if1',29);

717: end if;
718:
719: exit when get_other_asg_act_ids%notfound;
720: end loop;
721: hr_utility.set_location('Outside if1',29);
722:
723:
724:
725: hr_utility.set_location('Outside if2',30);

Line 725: hr_utility.set_location('Outside if2',30);

721: hr_utility.set_location('Outside if1',29);
722:
723:
724:
725: hr_utility.set_location('Outside if2',30);
726: close get_other_asg_act_ids;
727:
728: -- Below if will be for complete reporting logic
729: if l_process_flag = 'Y' then

Line 730: hr_utility.set_location('Inside if l_process_flag=Y',31);

726: close get_other_asg_act_ids;
727:
728: -- Below if will be for complete reporting logic
729: if l_process_flag = 'Y' then
730: hr_utility.set_location('Inside if l_process_flag=Y',31);
731:
732:
733: open get_emp_details (l_arch_asg_action_id);
734: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,32);

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

730: hr_utility.set_location('Inside if l_process_flag=Y',31);
731:
732:
733: open get_emp_details (l_arch_asg_action_id);
734: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,32);
735: fetch get_emp_details
736: into l_address_line1,
737: l_address_line2,
738: l_address_line3,

Line 781: hr_utility.set_location('Inside get_asg_details l_arch_asg_action_id :'||l_arch_asg_action_id,33);

777: tab_employee(gender)
778: := convert_2_xml(l_gender,'GENDER');
779:
780: open get_asg_details (l_arch_asg_action_id);
781: hr_utility.set_location('Inside get_asg_details l_arch_asg_action_id :'||l_arch_asg_action_id,33);
782: fetch get_asg_details
783: into l_payroll_id,
784: l_emp_indicator,
785: l_start_empl_date,

Line 804: hr_utility.set_location('Creating EAS Employee XML String',34);

800: := convert_2_xml(l_tax_code,'TAX_CODE');
801: tab_employee(tax_basis)
802: := convert_2_xml(l_tax_basis,'TAX_BASIS');
803:
804: hr_utility.set_location('Creating EAS Employee XML String',34);
805: l_final_xml_string := ''
806: ||EOL||
807: tab_employee(address_line1)||
808: tab_employee(address_line2)||

Line 821: hr_utility.set_location('Creating EAS Assignment XML String',35);

817: tab_employee(dob)||
818: tab_employee(ni_number)||
819: tab_employee(gender);
820:
821: hr_utility.set_location('Creating EAS Assignment XML String',35);
822: l_final_xml_string := l_final_xml_string||''||
823: tab_employee(payroll_id)||
824: tab_employee(emp_indicator)||
825: tab_employee(start_empl_date)||

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

828: tab_employee(tax_basis)||
829: '';
830:
831: open get_other_asg_act_ids(l_arch_pay_action_id, l_arch_asg_action_id );
832: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_pay_action_id :'||l_arch_pay_action_id,36);
833: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_asg_action_id :'||l_arch_asg_action_id,37);
834:
835: loop
836: fetch get_other_asg_act_ids

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

829: '';
830:
831: open get_other_asg_act_ids(l_arch_pay_action_id, l_arch_asg_action_id );
832: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_pay_action_id :'||l_arch_pay_action_id,36);
833: hr_utility.set_location('Inside get_other_asg_act_ids 2nd time l_arch_asg_action_id :'||l_arch_asg_action_id,37);
834:
835: loop
836: fetch get_other_asg_act_ids
837: into l_other_asg_arch_id,

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

835: loop
836: fetch get_other_asg_act_ids
837: into l_other_asg_arch_id,
838: l_other_asg_act_arch_id;
839: hr_utility.set_location('l_other_asg_arch_id :'||l_other_asg_arch_id,38);
840: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);
841:
842: exit when get_other_asg_act_ids%notfound;
843: open get_asg_details (l_other_asg_act_arch_id);

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

836: fetch get_other_asg_act_ids
837: into l_other_asg_arch_id,
838: l_other_asg_act_arch_id;
839: hr_utility.set_location('l_other_asg_arch_id :'||l_other_asg_arch_id,38);
840: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);
841:
842: exit when get_other_asg_act_ids%notfound;
843: open get_asg_details (l_other_asg_act_arch_id);
844: hr_utility.set_location('Inside get_asg_details 2nd time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,40);

Line 844: hr_utility.set_location('Inside get_asg_details 2nd time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,40);

840: hr_utility.set_location('l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,39);
841:
842: exit when get_other_asg_act_ids%notfound;
843: open get_asg_details (l_other_asg_act_arch_id);
844: hr_utility.set_location('Inside get_asg_details 2nd time l_other_asg_act_arch_id :'||l_other_asg_act_arch_id,40);
845: fetch get_asg_details
846: into l_payroll_id,
847: l_emp_indicator,
848: l_start_empl_date,

Line 853: hr_utility.set_location('Creating EAS Assignment XML String',41);

849: l_date_of_leaving,
850: l_tax_code,
851: l_tax_basis;
852: close get_asg_details;
853: hr_utility.set_location('Creating EAS Assignment XML String',41);
854: tab_employee(payroll_id)
855: := convert_2_xml(l_payroll_id,'PAYROLL_ID');
856: tab_employee(emp_indicator)
857: := convert_2_xml(l_emp_indicator,'EMP_INDICATOR');

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

873: tab_employee(tax_basis)||
874: '';
875: end loop;
876: l_final_xml_string := l_final_xml_string||'';
877: hr_utility.set_location('Created Final EAS XML Output:'||l_final_xml_string,42);
878: close get_other_asg_act_ids;
879:
880:
881: pay_core_files.write_to_magtape_lob(l_final_xml_string);

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

881: pay_core_files.write_to_magtape_lob(l_final_xml_string);
882:
883: end if;
884:
885: hr_utility.set_location(' Leaving: '||l_proc,43);
886: END;
887:
888: END eas_employee_proc;
889:

Line 1010: hr_utility.set_location(' Entering: '||l_proc,44);

1006: and pai_empl.action_context_type = 'AAP';
1007:
1008:
1009: BEGIN
1010: hr_utility.set_location(' Entering: '||l_proc,44);
1011: hr_utility.set_location('Employee Record',45);
1012:
1013: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1014: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,46);

Line 1011: hr_utility.set_location('Employee Record',45);

1007:
1008:
1009: BEGIN
1010: hr_utility.set_location(' Entering: '||l_proc,44);
1011: hr_utility.set_location('Employee Record',45);
1012:
1013: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1014: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,46);
1015:

Line 1014: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,46);

1010: hr_utility.set_location(' Entering: '||l_proc,44);
1011: hr_utility.set_location('Employee Record',45);
1012:
1013: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1014: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,46);
1015:
1016: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
1017: hr_utility.set_location('RTI NINO Mag Assignment action ='|| to_char(l_mag_asg_action_id),47);
1018:

Line 1017: hr_utility.set_location('RTI NINO Mag Assignment action ='|| to_char(l_mag_asg_action_id),47);

1013: l_mag_payroll_actid := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_PAYROLL_ACTION_ID'));
1014: hr_utility.set_location('RTI NINO Mag Payroll action ='||l_mag_payroll_actid,46);
1015:
1016: l_mag_asg_action_id := to_number(pay_magtape_generic.get_parameter_value('TRANSFER_ACT_ID'));
1017: hr_utility.set_location('RTI NINO Mag Assignment action ='|| to_char(l_mag_asg_action_id),47);
1018:
1019:
1020:
1021: open csr_arch_payroll_action_id(l_mag_payroll_actid);

Line 1025: hr_utility.set_location('RTI NINO Archive Payroll action ='|| to_char(l_arch_pay_action_id),48);

1021: open csr_arch_payroll_action_id(l_mag_payroll_actid);
1022: fetch csr_arch_payroll_action_id into l_arch_pay_action_id;
1023: close csr_arch_payroll_action_id;
1024:
1025: hr_utility.set_location('RTI NINO Archive Payroll action ='|| to_char(l_arch_pay_action_id),48);
1026:
1027: open get_arch_asg_actid
1028: (l_mag_payroll_actid,
1029: l_mag_asg_action_id,

Line 1035: hr_utility.set_location('RTI NINO Archive Assignment action ='|| to_char(l_arch_asg_action_id),49);

1031: fetch get_arch_asg_actid
1032: into l_arch_asg_action_id;
1033: close get_arch_asg_actid;
1034:
1035: hr_utility.set_location('RTI NINO Archive Assignment action ='|| to_char(l_arch_asg_action_id),49);
1036:
1037: l_process_flag := 'Y';
1038:
1039:

Line 1041: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,50);

1037: l_process_flag := 'Y';
1038:
1039:
1040: open get_emp_details (l_arch_asg_action_id);
1041: hr_utility.set_location('Inside get_emp_details l_arch_asg_action_id :'||l_arch_asg_action_id,50);
1042: fetch get_emp_details
1043: into l_address_line1,
1044: l_address_line2,
1045: l_address_line3,

Line 1106: hr_utility.set_location('Created Final NINO XML String'||l_final_xml_string,51 );

1102:
1103:
1104:
1105: l_final_xml_string := l_final_xml_string||'';
1106: hr_utility.set_location('Created Final NINO XML String'||l_final_xml_string,51 );
1107: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1108:
1109:
1110: hr_utility.set_location(' Leaving: '||l_proc,52);

Line 1110: hr_utility.set_location(' Leaving: '||l_proc,52);

1106: hr_utility.set_location('Created Final NINO XML String'||l_final_xml_string,51 );
1107: pay_core_files.write_to_magtape_lob(l_final_xml_string);
1108:
1109:
1110: hr_utility.set_location(' Leaving: '||l_proc,52);
1111: END;
1112:
1113: END nino_employee_proc;
1114: /**************************************************************************/

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

1157: lockingactid number;
1158: lv_assignment_id number;
1159: l_arch_payroll_action_id number;
1160: BEGIN
1161: hr_utility.set_location('Entering: '||l_proc,53);
1162:
1163: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),54);
1164:
1165: open csr_arch_payroll_action_id;

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

1159: l_arch_payroll_action_id number;
1160: BEGIN
1161: hr_utility.set_location('Entering: '||l_proc,53);
1162:
1163: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),54);
1164:
1165: open csr_arch_payroll_action_id;
1166: fetch csr_arch_payroll_action_id into l_arch_payroll_action_id;
1167: close csr_arch_payroll_action_id;

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

1165: open csr_arch_payroll_action_id;
1166: fetch csr_arch_payroll_action_id into l_arch_payroll_action_id;
1167: close csr_arch_payroll_action_id;
1168:
1169: hr_utility.set_location('RTI EAS Archive Payroll action ='|| to_char(l_arch_payroll_action_id),55);
1170:
1171: open csr_asg(l_arch_payroll_action_id);
1172: loop
1173: fetch csr_asg into lv_assignment_id;

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

1171: open csr_asg(l_arch_payroll_action_id);
1172: loop
1173: fetch csr_asg into lv_assignment_id;
1174: exit when csr_asg%notfound;
1175: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1176:
1177: -- Create one assignment action for every assignment
1178: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1179: select pay_assignment_actions_s.nextval

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

1174: exit when csr_asg%notfound;
1175: hr_utility.set_location('Assignment ID :' || lv_assignment_id,56);
1176:
1177: -- Create one assignment action for every assignment
1178: hr_utility.set_location('Archiving for assignment_id '||lv_assignment_id, 57);
1179: select pay_assignment_actions_s.nextval
1180: into lockingactid
1181: from dual;
1182:

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

1192:
1193: end loop;
1194: close csr_asg;
1195:
1196: hr_utility.set_location('Leaving: '||l_proc,58);
1197: --
1198: END action_creation;
1199:
1200: end PAY_GB_RTI_OUTPUT;