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

Line 232: hr_utility.set_location('Entering : '||l_proc,111);

228:
229: l_addr_rec csr_address%rowtype;
230:
231: BEGIN
232: hr_utility.set_location('Entering : '||l_proc,111);
233: l_arch := true;
234:
235: open csr_address;
236: fetch csr_address into l_addr_rec;

Line 293: hr_utility.trace('Address Line 1 : '||l_address_line1);

289: l_addr_rec.post_code:= ' ';
290: end if;
291:
292: --Trace Messages
293: hr_utility.trace('Address Line 1 : '||l_address_line1);
294: hr_utility.trace('Address Line 2 : '||l_address_line2);
295: hr_utility.trace('Address Line 3 : '||l_address_line3);
296: hr_utility.trace('Address Line 4 : '||l_address_line4);
297:

Line 294: hr_utility.trace('Address Line 2 : '||l_address_line2);

290: end if;
291:
292: --Trace Messages
293: hr_utility.trace('Address Line 1 : '||l_address_line1);
294: hr_utility.trace('Address Line 2 : '||l_address_line2);
295: hr_utility.trace('Address Line 3 : '||l_address_line3);
296: hr_utility.trace('Address Line 4 : '||l_address_line4);
297:
298: p_addr_rec.assignment_id := p_assignment_id;

Line 295: hr_utility.trace('Address Line 3 : '||l_address_line3);

291:
292: --Trace Messages
293: hr_utility.trace('Address Line 1 : '||l_address_line1);
294: hr_utility.trace('Address Line 2 : '||l_address_line2);
295: hr_utility.trace('Address Line 3 : '||l_address_line3);
296: hr_utility.trace('Address Line 4 : '||l_address_line4);
297:
298: p_addr_rec.assignment_id := p_assignment_id;
299: p_addr_rec.action_info_category := 'ADDRESS DETAILS';

Line 296: hr_utility.trace('Address Line 4 : '||l_address_line4);

292: --Trace Messages
293: hr_utility.trace('Address Line 1 : '||l_address_line1);
294: hr_utility.trace('Address Line 2 : '||l_address_line2);
295: hr_utility.trace('Address Line 3 : '||l_address_line3);
296: hr_utility.trace('Address Line 4 : '||l_address_line4);
297:
298: p_addr_rec.assignment_id := p_assignment_id;
299: p_addr_rec.action_info_category := 'ADDRESS DETAILS';
300: p_addr_rec.act_info5 := l_address_line1;

Line 307: hr_utility.set_location('Leaving: '||l_proc,999);

303: p_addr_rec.act_info8 := l_address_line4;
304: p_addr_rec.act_info12 := l_addr_rec.post_code;
305: p_addr_rec.act_info13 := l_addr_rec.country;
306:
307: hr_utility.set_location('Leaving: '||l_proc,999);
308: return l_arch;
309:
310: END fetch_address_rec;
311: --

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

396:
397: l_person_rec csr_person_details_active%rowtype;
398: BEGIN
399:
400: hr_utility.set_location('Entering: '||l_proc,1);
401: l_arch := true;
402:
403: open csr_person_details_active;
404: fetch csr_person_details_active into l_person_rec;

Line 419: hr_utility.trace('Termination date ' ||l_person_rec.actual_termination_date);

415: close csr_person_details_terminated;
416: end if;
417: close csr_person_details_active;
418:
419: hr_utility.trace('Termination date ' ||l_person_rec.actual_termination_date);
420: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);
421: hr_utility.trace('Current employee flag' ||l_person_rec.current_employee_flag);
422:
423: p_person_rec.person_id := l_person_rec.p_person_id;

Line 420: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);

416: end if;
417: close csr_person_details_active;
418:
419: hr_utility.trace('Termination date ' ||l_person_rec.actual_termination_date);
420: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);
421: hr_utility.trace('Current employee flag' ||l_person_rec.current_employee_flag);
422:
423: p_person_rec.person_id := l_person_rec.p_person_id;
424: p_person_rec.assignment_id := l_person_rec.assignment_id;

Line 421: hr_utility.trace('Current employee flag' ||l_person_rec.current_employee_flag);

417: close csr_person_details_active;
418:
419: hr_utility.trace('Termination date ' ||l_person_rec.actual_termination_date);
420: hr_utility.trace('Start date ' ||l_person_rec.effective_start_date);
421: hr_utility.trace('Current employee flag' ||l_person_rec.current_employee_flag);
422:
423: p_person_rec.person_id := l_person_rec.p_person_id;
424: p_person_rec.assignment_id := l_person_rec.assignment_id;
425: p_person_rec.action_info_category := 'GB RTI EMPLOYEE DETAILS';

Line 439: hr_utility.set_location('Leaving: '||l_proc,999);

435: p_person_rec.act_info17 := l_person_rec.emp_no;
436: p_person_rec.act_info18 := l_person_rec.current_employee_flag;
437: p_person_rec.act_info19 := to_char(l_person_rec.actual_termination_date,'YYYY-MM-DD');
438:
439: hr_utility.set_location('Leaving: '||l_proc,999);
440: return l_arch;
441: END fetch_person_rec;
442: --
443: -- Function to fetch Assignment details (CONTEXT - GB_RTI_ASG_DETAILS)

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

585: and p_eff_date between papf.effective_start_date and papf.effective_end_date;
586:
587:
588: BEGIN
589: hr_utility.set_location('Entering: '||l_proc,1);
590: l_arch := true;
591:
592: SELECT distinct element_type_id
593: into g_paye_details_id

Line 607: hr_utility.trace('Continous emp l_final_eff_start_date : '||l_final_eff_start_date);

603: fetch csr_check_cont_emp into l_final_eff_start_date,l_final_eff_end_date,l_prev_asg_id;
604:
605: if l_final_eff_start_date is not null then
606: close csr_check_cont_emp;
607: hr_utility.trace('Continous emp l_final_eff_start_date : '||l_final_eff_start_date);
608: hr_utility.trace('Continous emp l_final_eff_end_date : '||l_final_eff_end_date);
609:
610: l_final_eff_start_date := get_eff_start_date(l_prev_asg_id,l_final_eff_start_date,l_tax_ref);
611: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_final_eff_end_date,l_tax_ref);

Line 608: hr_utility.trace('Continous emp l_final_eff_end_date : '||l_final_eff_end_date);

604:
605: if l_final_eff_start_date is not null then
606: close csr_check_cont_emp;
607: hr_utility.trace('Continous emp l_final_eff_start_date : '||l_final_eff_start_date);
608: hr_utility.trace('Continous emp l_final_eff_end_date : '||l_final_eff_end_date);
609:
610: l_final_eff_start_date := get_eff_start_date(l_prev_asg_id,l_final_eff_start_date,l_tax_ref);
611: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_final_eff_end_date,l_tax_ref);
612: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);

Line 612: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);

608: hr_utility.trace('Continous emp l_final_eff_end_date : '||l_final_eff_end_date);
609:
610: l_final_eff_start_date := get_eff_start_date(l_prev_asg_id,l_final_eff_start_date,l_tax_ref);
611: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_final_eff_end_date,l_tax_ref);
612: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);
613: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);
614: else
615: close csr_check_cont_emp;
616: open csr_get_start_end_dates(l_eff_date,l_tax_ref);

Line 613: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);

609:
610: l_final_eff_start_date := get_eff_start_date(l_prev_asg_id,l_final_eff_start_date,l_tax_ref);
611: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_final_eff_end_date,l_tax_ref);
612: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);
613: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);
614: else
615: close csr_check_cont_emp;
616: open csr_get_start_end_dates(l_eff_date,l_tax_ref);
617: fetch csr_get_start_end_dates into l_eff_start_date,l_eff_end_date;

Line 621: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);

617: fetch csr_get_start_end_dates into l_eff_start_date,l_eff_end_date;
618: if csr_get_start_end_dates%found then
619: l_final_eff_start_date := get_eff_start_date(p_person_rec.assignment_id,l_eff_start_date,l_tax_ref);
620: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_eff_end_date,l_tax_ref);
621: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);
622: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);
623: end if;
624: close csr_get_start_end_dates;
625: end if;

Line 622: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);

618: if csr_get_start_end_dates%found then
619: l_final_eff_start_date := get_eff_start_date(p_person_rec.assignment_id,l_eff_start_date,l_tax_ref);
620: l_final_eff_end_date := get_eff_end_date(p_person_rec.assignment_id,l_eff_end_date,l_tax_ref);
621: hr_utility.trace('Asg l_final_eff_start_date : '||l_final_eff_start_date);
622: hr_utility.trace('Asg l_final_eff_end_date : '||l_final_eff_end_date);
623: end if;
624: close csr_get_start_end_dates;
625: end if;
626:

Line 634: hr_utility.trace('Effective date : '||l_eff_date||' Termination Date : '||p_person_rec.act_info19);

630:
631: -- To fetch Terminated Employee Details
632: if p_person_rec.act_info18 is null or p_person_rec.act_info18 <> 'Y' then
633: l_effective_date := least(l_eff_date,(to_date(substr(p_person_rec.act_info19,1,10),'YYYY-MM-DD')));
634: hr_utility.trace('Effective date : '||l_eff_date||' Termination Date : '||p_person_rec.act_info19);
635: hr_utility.trace('l_effective_date : '||l_effective_date);
636: else
637: l_effective_date := least (p_effective_date, l_final_eff_end_date);
638: hr_utility.trace('l_effective_date : '||l_effective_date);

Line 635: hr_utility.trace('l_effective_date : '||l_effective_date);

631: -- To fetch Terminated Employee Details
632: if p_person_rec.act_info18 is null or p_person_rec.act_info18 <> 'Y' then
633: l_effective_date := least(l_eff_date,(to_date(substr(p_person_rec.act_info19,1,10),'YYYY-MM-DD')));
634: hr_utility.trace('Effective date : '||l_eff_date||' Termination Date : '||p_person_rec.act_info19);
635: hr_utility.trace('l_effective_date : '||l_effective_date);
636: else
637: l_effective_date := least (p_effective_date, l_final_eff_end_date);
638: hr_utility.trace('l_effective_date : '||l_effective_date);
639: end if;

Line 638: hr_utility.trace('l_effective_date : '||l_effective_date);

634: hr_utility.trace('Effective date : '||l_eff_date||' Termination Date : '||p_person_rec.act_info19);
635: hr_utility.trace('l_effective_date : '||l_effective_date);
636: else
637: l_effective_date := least (p_effective_date, l_final_eff_end_date);
638: hr_utility.trace('l_effective_date : '||l_effective_date);
639: end if;
640:
641: open csr_get_asg_no;
642: fetch csr_get_asg_no into l_asg_no;

Line 662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);

658: l_final_eff_end_date := l_effective_date;
659: end if;
660:
661: -- Trace Messages
662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);
663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);

Line 663: hr_utility.set_location('Asg no : '||l_asg_no,20);

659: end if;
660:
661: -- Trace Messages
662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);
663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);
667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);

Line 664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);

660:
661: -- Trace Messages
662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);
663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);
667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);
668:

Line 665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);

661: -- Trace Messages
662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);
663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);
667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);
668:
669: -- If tax basis is non cumulative('N') then making it as 'Y' else ' '

Line 666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);

662: hr_utility.set_location('Asg id : '||p_person_rec.assignment_id,20);
663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);
667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);
668:
669: -- If tax basis is non cumulative('N') then making it as 'Y' else ' '
670: if l_taxbasis_screen_value = 'N' then

Line 667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);

663: hr_utility.set_location('Asg no : '||l_asg_no,20);
664: hr_utility.set_location('Tax code : '||l_tax_screen_value,20);
665: hr_utility.set_location('Tax basis : '||l_taxbasis_screen_value,20);
666: hr_utility.set_location('Start Date: '||l_final_eff_start_date,20);
667: hr_utility.set_location('End Date : '||l_final_eff_end_date,20);
668:
669: -- If tax basis is non cumulative('N') then making it as 'Y' else ' '
670: if l_taxbasis_screen_value = 'N' then
671: l_taxbasis_screen_value := 'Y';

Line 701: hr_utility.set_location('Leaving: '||l_proc,999);

697: p_eas_rec.act_info7 := l_tax_screen_value;
698: p_eas_rec.act_info8 := l_taxbasis_screen_value;
699:
700:
701: hr_utility.set_location('Leaving: '||l_proc,999);
702: return l_arch;
703: END fetch_eas_asg_rec;
704: --
705: --

Line 730: hr_utility.trace('Error occured in populate_run_msg');

726: );
727: COMMIT;
728: EXCEPTION
729: WHEN OTHERS THEN
730: hr_utility.trace('Error occured in populate_run_msg');
731: RAISE;
732: END populate_run_msg;
733:
734: -- Function to validate assignment details for EAS report

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

757: l_eas_start_asg_date date;
758: l_eas_end_asg_date date;
759:
760: BEGIN
761: hr_utility.set_location('Entering: '||l_proc,1);
762:
763: edi_validation_fail := 'N'; -- Initialized validation fail to N
764: l_assignment_number := p_tab_rec_data(0).act_info17;
765: l_payroll_id := p_tab_rec_data(2).act_info3;

Line 773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);

769: l_eas_start_asg_date := (to_date(substr(p_tab_rec_data(2).act_info5,1,10),'YYYY-MM-DD'));
770: l_eas_end_asg_date := (to_date(substr(p_tab_rec_data(2).act_info6,1,10),'YYYY-MM-DD'));
771:
772: -- Trace Messages
773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);
774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);

Line 774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);

770: l_eas_end_asg_date := (to_date(substr(p_tab_rec_data(2).act_info6,1,10),'YYYY-MM-DD'));
771:
772: -- Trace Messages
773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);
774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);
778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);

Line 775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);

771:
772: -- Trace Messages
773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);
774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);
778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);
779:

Line 776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);

772: -- Trace Messages
773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);
774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);
778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);
779:
780:

Line 777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);

773: hr_utility.set_location('Payroll Id : '||l_payroll_id,10);
774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);
778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);
779:
780:
781: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)

Line 778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);

774: hr_utility.set_location('Process type : '||l_process_type_in_use,20);
775: hr_utility.set_location('Tax code : '||l_tax_code_in_use,30);
776: hr_utility.set_location('Tax basis : '||l_tax_basis_in_use,40);
777: hr_utility.set_location('Start date : '||l_eas_start_asg_date,50);
778: hr_utility.set_location('End date : '||l_eas_end_asg_date,60);
779:
780:
781: IF ((l_payroll_id <> ' ' and l_payroll_id IS NOT NULL)
782: and validate_input(l_payroll_id,'PAYROLLID') > 0) THEN

Line 810: hr_utility.trace('l_eff_date = '|| l_eff_date);

806: CLOSE get_effective_date;
807:
808:
809: l_eff_date := trunc (l_eff_date);
810: hr_utility.trace('l_eff_date = '|| l_eff_date);
811:
812: l_msg_value := pay_gb_eoy_magtape.validate_tax_code_yrfil(p_assactid,l_tax_code_in_use,l_eff_date); -- Tax code validation
813:
814: --Tax code

Line 845: hr_utility.set_location('Leaving: '||l_proc,111);

841: fnd_file.put_line (fnd_file.LOG,'Tax Basis ' ||l_tax_basis_in_use ||' for assignment ' || l_assignment_number||' is invalid.');
842: edi_validation_fail := 'Y';
843: END IF;
844:
845: hr_utility.set_location('Leaving: '||l_proc,111);
846:
847: END eas_asg_etext_validations;
848: --
849: -- Person Address validations

Line 894: hr_utility.set_location('Entering '||l_proc,10);

890: l_year1 number;
891: l_year2 number;
892:
893: BEGIN
894: hr_utility.set_location('Entering '||l_proc,10);
895:
896: l_count_char_errors := 0;
897: l_count_missing_val := 0;
898:

Line 1059: hr_utility.set_location('Leaving'||l_proc,10);

1055: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the assignment '|| l_assignment_number || ' is invalid.');
1056: edi_validation_fail := 'Y';
1057: END IF;
1058:
1059: hr_utility.set_location('Leaving'||l_proc,10);
1060: END person_addr_validations;
1061: --
1062:
1063: -- Person Address validations

Line 1109: hr_utility.set_location('Entering '||l_proc,10);

1105: l_year1 number;
1106: l_year2 number;
1107:
1108: BEGIN
1109: hr_utility.set_location('Entering '||l_proc,10);
1110:
1111: l_count_char_errors := 0;
1112: l_count_missing_val := 0;
1113:

Line 1273: hr_utility.set_location('Leaving'||l_proc,10);

1269: fnd_file.put_line (fnd_file.LOG,'The Date of Birth of the employee '|| l_employee_number || ' is invalid.');
1270: edi_validation_fail := 'Y';
1271: END IF;
1272:
1273: hr_utility.set_location('Leaving'||l_proc,10);
1274: END person_addr_validations_nino;
1275: --
1276:
1277: --

Line 1300: hr_utility.trace('Entering validate_input');

1296: l_translated_value varchar2(200); -- Required to output failing char.
1297: --
1298: BEGIN
1299: --
1300: hr_utility.trace('Entering validate_input');
1301: hr_utility.trace('p_validate_mode='||p_validate_mode);
1302: hr_utility.trace('p_input_value='||p_input_value);
1303: --
1304:

Line 1301: hr_utility.trace('p_validate_mode='||p_validate_mode);

1297: --
1298: BEGIN
1299: --
1300: hr_utility.trace('Entering validate_input');
1301: hr_utility.trace('p_validate_mode='||p_validate_mode);
1302: hr_utility.trace('p_input_value='||p_input_value);
1303: --
1304:
1305: if p_validate_mode = 'EMP_NAME' then

Line 1302: hr_utility.trace('p_input_value='||p_input_value);

1298: BEGIN
1299: --
1300: hr_utility.trace('Entering validate_input');
1301: hr_utility.trace('p_validate_mode='||p_validate_mode);
1302: hr_utility.trace('p_input_value='||p_input_value);
1303: --
1304:
1305: if p_validate_mode = 'EMP_NAME' then
1306: if ( substr(p_input_value,1,1) =' ') then

Line 1307: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1303: --
1304:
1305: if p_validate_mode = 'EMP_NAME' then
1306: if ( substr(p_input_value,1,1) =' ') then
1307: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1308: l_valid := 2;
1309: else
1310: l_translated_value :=
1311: translate(p_input_value,

Line 1315: hr_utility.trace('Invalid chars found: '||l_translated_value);

1311: translate(p_input_value,
1312: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_A||l_space,l_invalid_char);
1313:
1314: if l_translated_value is not null then
1315: hr_utility.trace('Invalid chars found: '||l_translated_value);
1316: l_valid := 1; -- Not valid
1317: else
1318: l_valid := 0; -- Valid
1319: end if;

Line 1331: hr_utility.trace('Invalid chars found: '||l_translated_value);

1327: translate(p_input_value,
1328: l_invalid_char||l_number_chk,l_invalid_char);
1329:
1330: if l_translated_value is not null then
1331: hr_utility.trace('Invalid chars found: '||l_translated_value);
1332: l_valid := 1; -- Not valid
1333: else
1334: l_valid := 0; -- Valid
1335: end if;

Line 1342: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1338: --
1339: -- Check for Valid First Char
1340: --
1341: if ( substr(p_input_value,1,1) =' ') then
1342: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1343: l_valid := 2;
1344: else
1345: l_translated_value :=
1346: translate(p_input_value,

Line 1350: hr_utility.trace('Invalid chars found: '||l_translated_value);

1346: translate(p_input_value,
1347: l_invalid_char||l_char_chk||l_number_chk||l_char_set_B||l_space,l_invalid_char);
1348:
1349: if l_translated_value is not null then
1350: hr_utility.trace('Invalid chars found: '||l_translated_value);
1351: l_valid := 1; -- Not valid
1352: else
1353: l_valid := 0; -- Valid
1354: end if;

Line 1363: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1359: -- Check for Valid First Char
1360: --
1361: if not (substr(p_input_value,1,1) between 'A' and 'Z'
1362: or substr(p_input_value,1,1) between 'a' and 'z') then
1363: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1364: l_valid := 2;
1365: else
1366: l_translated_value :=
1367: translate(p_input_value,

Line 1371: hr_utility.trace('Invalid chars found: '||l_translated_value);

1367: translate(p_input_value,
1368: l_invalid_char||l_mix_chars||l_char_set_D||l_space,l_invalid_char);
1369:
1370: if l_translated_value is not null then
1371: hr_utility.trace('Invalid chars found: '||l_translated_value);
1372: l_valid := 1; -- Not valid
1373: else
1374: l_valid := 0; -- Valid
1375: end if;

Line 1384: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1380: -- Check for Valid First Char
1381: --
1382: if not (substr(p_input_value,1,1) between 'A' and 'Z'
1383: or substr(p_input_value,1,1) between 'a' and 'z') then
1384: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1385: l_valid := 2;
1386: else
1387: l_translated_value :=
1388: translate(p_input_value,

Line 1392: hr_utility.trace('Invalid chars found: '||l_translated_value);

1388: translate(p_input_value,
1389: l_invalid_char||l_mix_chars||l_char_set_C||l_space,l_invalid_char);
1390:
1391: if l_translated_value is not null then
1392: hr_utility.trace('Invalid chars found: '||l_translated_value);
1393: l_valid := 1; -- Not valid
1394: else
1395: l_valid := 0; -- Valid
1396: end if;

Line 1406: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1402: --
1403: if not (substr(p_input_value,1,1) between 'A' and 'Z'
1404: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
1405: -- First char invalid
1406: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1407: l_valid := 2;
1408: else
1409: l_translated_value :=
1410: translate(p_input_value,

Line 1414: hr_utility.trace('Invalid chars found: '||l_translated_value);

1410: translate(p_input_value,
1411: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
1412:
1413: if l_translated_value is not null then
1414: hr_utility.trace('Invalid chars found: '||l_translated_value);
1415: l_valid := 1; --Invalid
1416: else
1417: l_valid := 0; -- Valid
1418: end if;

Line 1424: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1420:
1421: elsif p_validate_mode = 'COUNTRY' then
1422: if not (substr(p_input_value,1,1) between 'A' and 'Z' or
1423: substr(p_input_value,1,1) between 'a' and 'z' ) then
1424: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1425: l_valid := 2;
1426: else
1427: l_translated_value :=
1428: translate(p_input_value,

Line 1432: hr_utility.trace('Invalid chars found: '||l_translated_value);

1428: translate(p_input_value,
1429: l_invalid_char||l_mix_chars||l_number_chk||l_space||l_char_set_B,l_invalid_char);
1430:
1431: if l_translated_value is not null then
1432: hr_utility.trace('Invalid chars found: '||l_translated_value);
1433: l_valid := 1; -- Not valid
1434: else
1435: l_valid := 0; -- Valid
1436: end if;

Line 1445: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1441:
1442: if not (substr(p_input_value,1,1) between 'A' and 'Z'
1443: or substr(p_input_value,1,1) between 'a' and 'z' or substr(p_input_value,1,1) between '0' and '9') then
1444: -- First char invalid
1445: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1446: l_valid := 2;
1447: else
1448: l_translated_value := translate(p_input_value,
1449: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);

Line 1452: hr_utility.trace('Invalid chars found: '||l_translated_value);

1448: l_translated_value := translate(p_input_value,
1449: l_invalid_char||l_mix_chars||l_number_chk||l_space,l_invalid_char);
1450: --
1451: if l_translated_value is not null then
1452: hr_utility.trace('Invalid chars found: '||l_translated_value);
1453: l_valid := 1; -- Not valid
1454: else
1455: l_valid := 0; -- Valid
1456: end if;

Line 1461: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));

1457: end if;
1458:
1459: elsif p_validate_mode = 'PAYROLLID' then
1460: if ( substr(p_input_value,1,1) =' ') then
1461: hr_utility.trace('Invalid first char: '||substr(p_input_value,1,1));
1462: l_valid := 2;
1463: else
1464: l_translated_value :=
1465: translate(p_input_value,

Line 1469: hr_utility.trace('Invalid chars found: '||l_translated_value);

1465: translate(p_input_value,
1466: l_invalid_char||l_mix_chars||l_number_chk||l_char_set_B||l_space,l_invalid_char);
1467:
1468: if l_translated_value is not null then
1469: hr_utility.trace('Invalid chars found: '||l_translated_value);
1470: l_valid := 1; -- Not valid
1471: else
1472: l_valid := 0; -- Valid
1473: end if;

Line 1478: hr_utility.trace('Leaving validate_input');

1474: end if ;
1475:
1476: END IF;
1477: --
1478: hr_utility.trace('Leaving validate_input');
1479: return l_valid;
1480: end validate_input;
1481:
1482: -- Procedure to set New Starter RTI Sent flag

Line 1496: hr_utility.trace('Entering set_new_starter_rti_sent');

1492: l_starter_flag varchar2(1);
1493: l_object_version_number number;
1494:
1495: begin
1496: hr_utility.trace('Entering set_new_starter_rti_sent');
1497:
1498: open csr_asg_extra_info;
1499: fetch csr_asg_extra_info into l_asg_extra_info_id,l_starter_flag,l_object_version_number;
1500: close csr_asg_extra_info;

Line 1516: hr_utility.trace('New Assignment extra info id : '||l_asg_extra_info_id);

1512: p_object_version_number => l_object_version_number,
1513: p_assignment_extra_info_id => l_asg_extra_info_id
1514: );
1515:
1516: hr_utility.trace('New Assignment extra info id : '||l_asg_extra_info_id);
1517: elsif l_starter_flag <> 'Y' then
1518: -- Update the flag to Yes
1519: hr_assignment_extra_info_api.update_assignment_extra_info
1520: (p_validate => false,

Line 1527: hr_utility.trace('Existing Assignment extra info id : '||l_asg_extra_info_id);

1523: p_aei_information_category => 'GB_RTI_ASG_DETAILS',
1524: p_aei_information8 => 'Y'
1525: );
1526:
1527: hr_utility.trace('Existing Assignment extra info id : '||l_asg_extra_info_id);
1528: end if;
1529:
1530: hr_utility.trace('Leaving set_new_starter_rti_sent');
1531: end set_new_starter_rti_sent;

Line 1530: hr_utility.trace('Leaving set_new_starter_rti_sent');

1526:
1527: hr_utility.trace('Existing Assignment extra info id : '||l_asg_extra_info_id);
1528: end if;
1529:
1530: hr_utility.trace('Leaving set_new_starter_rti_sent');
1531: end set_new_starter_rti_sent;
1532:
1533: -- Procedure to insert data to the archive table pay_action_information
1534: PROCEDURE insert_archive_row(p_assactid IN NUMBER,

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

1537: l_proc CONSTANT VARCHAR2(50):= g_package||'insert_archive_row';
1538: l_ovn number;
1539: l_action_id number;
1540: BEGIN
1541: hr_utility.set_location('Entering: '||l_proc,1);
1542: if p_tab_rec_data.count > 0 then
1543: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
1544: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
1545: hr_utility.trace('action_context_id = '|| p_assactid);

Line 1544: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);

1540: BEGIN
1541: hr_utility.set_location('Entering: '||l_proc,1);
1542: if p_tab_rec_data.count > 0 then
1543: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
1544: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
1545: hr_utility.trace('action_context_id = '|| p_assactid);
1546: if p_tab_rec_data(i).action_info_category is not null then
1547: pay_action_information_api.create_action_information(
1548: p_action_information_id => l_action_id,

Line 1545: hr_utility.trace('action_context_id = '|| p_assactid);

1541: hr_utility.set_location('Entering: '||l_proc,1);
1542: if p_tab_rec_data.count > 0 then
1543: for i in p_tab_rec_data.first .. p_tab_rec_data.last loop
1544: hr_utility.trace('Defining category '|| p_tab_rec_data(i).action_info_category);
1545: hr_utility.trace('action_context_id = '|| p_assactid);
1546: if p_tab_rec_data(i).action_info_category is not null then
1547: pay_action_information_api.create_action_information(
1548: p_action_information_id => l_action_id,
1549: p_object_version_number => l_ovn,

Line 1589: hr_utility.set_location('Leaving: '||l_proc,999);

1585: );
1586: end if;
1587: end loop;
1588: end if;
1589: hr_utility.set_location('Leaving: '||l_proc,999);
1590: END insert_archive_row;
1591: --
1592: --
1593: /*------------ PUBLIC PROCEDURES --------------*/

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

1620: l_assignment_set varchar2(25);
1621:
1622: l_proc CONSTANT VARCHAR2(35):= g_package||'range_cursor';
1623: BEGIN
1624: hr_utility.set_location('Entering: '||l_proc,1);
1625:
1626: OPEN csr_parameter_info;
1627: fetch csr_parameter_info into l_report_type;
1628: CLOSE csr_parameter_info ;

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

1634: 'pay_payroll_actions ppa '||
1635: 'where ppa.payroll_action_id = :payroll_action_id '||
1636: 'and ppa.business_group_id = ppf.business_group_id '||
1637: 'order by ppf.person_id';
1638: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
1639: hr_utility.set_location(' Leaving: '||l_proc,100);
1640: END IF;
1641:
1642:

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

1635: 'where ppa.payroll_action_id = :payroll_action_id '||
1636: 'and ppa.business_group_id = ppf.business_group_id '||
1637: 'order by ppf.person_id';
1638: hr_utility.trace(' Range Cursor Statement : '||sqlstr);
1639: hr_utility.set_location(' Leaving: '||l_proc,100);
1640: END IF;
1641:
1642:
1643:

Line 1663: hr_utility.trace(' Payroll : '||l_payroll_id);

1659: p_payroll_action_id => pactid,
1660: p_token_name => 'EMPID',
1661: p_token_value => l_employee_number);
1662:
1663: hr_utility.trace(' Payroll : '||l_payroll_id);
1664: hr_utility.trace(' Assignment Set : '||l_assignment_set);
1665: hr_utility.trace(' Employee ID : '||l_employee_number);
1666:
1667: IF (l_payroll_id is null) THEN

Line 1664: hr_utility.trace(' Assignment Set : '||l_assignment_set);

1660: p_token_name => 'EMPID',
1661: p_token_value => l_employee_number);
1662:
1663: hr_utility.trace(' Payroll : '||l_payroll_id);
1664: hr_utility.trace(' Assignment Set : '||l_assignment_set);
1665: hr_utility.trace(' Employee ID : '||l_employee_number);
1666:
1667: IF (l_payroll_id is null) THEN
1668: sqlstr := 'select distinct person_id '||

Line 1665: hr_utility.trace(' Employee ID : '||l_employee_number);

1661: p_token_value => l_employee_number);
1662:
1663: hr_utility.trace(' Payroll : '||l_payroll_id);
1664: hr_utility.trace(' Assignment Set : '||l_assignment_set);
1665: hr_utility.trace(' Employee ID : '||l_employee_number);
1666:
1667: IF (l_payroll_id is null) THEN
1668: sqlstr := 'select distinct person_id '||
1669: 'from per_all_people_f ppf, '||

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

1885: l_asg_end_date date;
1886:
1887: BEGIN
1888:
1889: hr_utility.set_location('Entering: '||l_proc,1);
1890:
1891: open csr_parameter_info;
1892: fetch csr_parameter_info into l_tax_ref,
1893: l_effective_date,

Line 1896: hr_utility.set_location('Process effective date'||l_effective_date,20);

1892: fetch csr_parameter_info into l_tax_ref,
1893: l_effective_date,
1894: l_business_group_id;
1895: close csr_parameter_info;
1896: hr_utility.set_location('Process effective date'||l_effective_date,20);
1897: l_tax_year_start_date := fetch_soy(l_effective_date);
1898:
1899: hr_utility.set_location('Active Assignments',15);
1900: -- To fetch Active Assignments

Line 1899: hr_utility.set_location('Active Assignments',15);

1895: close csr_parameter_info;
1896: hr_utility.set_location('Process effective date'||l_effective_date,20);
1897: l_tax_year_start_date := fetch_soy(l_effective_date);
1898:
1899: hr_utility.set_location('Active Assignments',15);
1900: -- To fetch Active Assignments
1901: for asg_rec in csr_asg_active loop
1902:
1903: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

Line 1903: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

1899: hr_utility.set_location('Active Assignments',15);
1900: -- To fetch Active Assignments
1901: for asg_rec in csr_asg_active loop
1902:
1903: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
1904: l_flag := 'Y';
1905: -- If Aggregate flag is set then ignore non primary assignments
1906: if asg_rec.per_agg_flag = 'Y' then
1907: if asg_rec.asg_primary_flag <> 'Y' then

Line 1908: hr_utility.trace(' Aggregation Found. This is not primary assignment.');

1904: l_flag := 'Y';
1905: -- If Aggregate flag is set then ignore non primary assignments
1906: if asg_rec.per_agg_flag = 'Y' then
1907: if asg_rec.asg_primary_flag <> 'Y' then
1908: hr_utility.trace(' Aggregation Found. This is not primary assignment.');
1909: l_flag:= 'N';
1910: end if;
1911: end if;
1912: /*

Line 1924: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);

1920: open csr_get_terminated_date(asg_rec.assignment_id);
1921: fetch csr_get_terminated_date into l_asg_end_date;
1922: close csr_get_terminated_date;
1923:
1924: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);
1925:
1926: if l_asg_end_date < l_tax_year_start_date then
1927: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');
1928: l_flag:= 'N';

Line 1927: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');

1923:
1924: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);
1925:
1926: if l_asg_end_date < l_tax_year_start_date then
1927: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');
1928: l_flag:= 'N';
1929: end if;
1930:
1931: -- To check whether continous employment exist for this assignment

Line 1936: hr_utility.trace('Continous Employment.Ignore this assignment.');

1932: if asg_rec.status = 'TERM_ASSIGN' and l_flag = 'Y' then
1933: open csr_find_next_asg(asg_rec.person_id,asg_rec.assignment_id);
1934: fetch csr_find_next_asg into l_next_asg;
1935: if csr_find_next_asg%found then
1936: hr_utility.trace('Continous Employment.Ignore this assignment.');
1937: l_flag:= 'N';
1938: end if;
1939: close csr_find_next_asg;
1940: end if;

Line 1945: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);

1941:
1942: if l_flag = 'Y' then
1943:
1944: -- Create one assignment action for every assignment
1945: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
1946: select pay_assignment_actions_s.nextval
1947: into lockingactid
1948: from dual;
1949:

Line 1964: hr_utility.set_location('Terminated Assignments',15);

1960: end if;
1961: end loop;
1962:
1963: -- To fetch Terminated assignments
1964: hr_utility.set_location('Terminated Assignments',15);
1965: for asg_rec in csr_asg_terminated loop
1966: l_flag := 'Y';
1967: /* Check the cached value of person id .
1968: If the assignment has been archived already, skip the assignment again

Line 1972: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

1968: If the assignment has been archived already, skip the assignment again
1969: when appers in date tracked records.
1970: */
1971: if l_prev_asg <> asg_rec.assignment_id then
1972: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
1973:
1974: -- If Aggregate flag is set then ignore non primary assignments
1975:
1976: open csr_get_agg_flag(asg_rec.person_id);

Line 1979: hr_utility.set_location('Aggregation Flag:'||l_per_agg_flag,1515);

1975:
1976: open csr_get_agg_flag(asg_rec.person_id);
1977: fetch csr_get_agg_flag into l_per_agg_flag;
1978: close csr_get_agg_flag;
1979: hr_utility.set_location('Aggregation Flag:'||l_per_agg_flag,1515);
1980: if l_per_agg_flag = 'Y' then
1981: if asg_rec.asg_primary_flag <> 'Y' then
1982: hr_utility.trace(' Aggregation Found. This is not primary assignment.');
1983: l_flag:= 'N';

Line 1982: hr_utility.trace(' Aggregation Found. This is not primary assignment.');

1978: close csr_get_agg_flag;
1979: hr_utility.set_location('Aggregation Flag:'||l_per_agg_flag,1515);
1980: if l_per_agg_flag = 'Y' then
1981: if asg_rec.asg_primary_flag <> 'Y' then
1982: hr_utility.trace(' Aggregation Found. This is not primary assignment.');
1983: l_flag:= 'N';
1984: end if;
1985: end if;
1986:

Line 1992: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);

1988: open csr_get_terminated_date(asg_rec.assignment_id);
1989: fetch csr_get_terminated_date into l_asg_end_date;
1990: close csr_get_terminated_date;
1991:
1992: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);
1993:
1994: if l_asg_end_date < l_tax_year_start_date then
1995: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');
1996: l_flag:= 'N';

Line 1995: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');

1991:
1992: hr_utility.trace('Assignment actual end date : '||l_asg_end_date);
1993:
1994: if l_asg_end_date < l_tax_year_start_date then
1995: hr_utility.trace(' Assignment terminated before start of the Tax Year.Ignore the assignment.');
1996: l_flag:= 'N';
1997: end if;
1998:
1999: if l_flag = 'Y' then

Line 2002: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);

1998:
1999: if l_flag = 'Y' then
2000:
2001: -- Create one assignment action for every assignment
2002: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2003: select pay_assignment_actions_s.nextval
2004: into lockingactid
2005: from dual;
2006:

Line 2022: hr_utility.set_location('Leaving: '||l_proc,999);

2018: end if;
2019: end if; -- cache check end
2020: end loop;
2021:
2022: hr_utility.set_location('Leaving: '||l_proc,999);
2023: END internal_action_creation_eas;
2024:
2025: --
2026: --

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

2117:
2118: l_prev_person number:=0;
2119: l_flag varchar2(1) :='Y';
2120: BEGIN
2121: hr_utility.set_location('Entering: '||l_proc,1);
2122: open csr_parameter_info;
2123: fetch csr_parameter_info into l_payroll_id,
2124: l_tax_ref,
2125: l_emp_num,

Line 2134: hr_utility.set_location('Assignment Set Id '||l_assignment_set,11);

2130: PAY_GB_P11D_ARCHIVE_SS.get_parameters(
2131: p_payroll_action_id => pactid,
2132: p_token_name => 'ASSET',
2133: p_token_value => l_assignment_set);
2134: hr_utility.set_location('Assignment Set Id '||l_assignment_set,11);
2135:
2136: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);
2137: for asg_rec in csr_asg loop
2138: l_flag := 'Y';

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

2132: p_token_name => 'ASSET',
2133: p_token_value => l_assignment_set);
2134: hr_utility.set_location('Assignment Set Id '||l_assignment_set,11);
2135:
2136: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);
2137: for asg_rec in csr_asg loop
2138: l_flag := 'Y';
2139: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
2140:

Line 2139: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);

2135:
2136: hr_utility.set_location('Before CSR_ASG cursor effective_date '|| to_char(l_effective_date),10);
2137: for asg_rec in csr_asg loop
2138: l_flag := 'Y';
2139: hr_utility.set_location('Assignment ID :' || asg_rec.assignment_id,15);
2140:
2141:
2142:
2143: open csr_exc_inc ;

Line 2155: hr_utility.set_location('Assignment Set -FormulaID :' || l_formula_id,11);

2151: pqp_budget_maintenance.get_asg_set_details(p_assignment_set_id => l_assignment_set
2152: ,p_formula_id => l_formula_id
2153: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
2154: );
2155: hr_utility.set_location('Assignment Set -FormulaID :' || l_formula_id,11);
2156: hr_utility.set_location('Assignment Set -Amendments Count :' || l_tab_asg_set_amnds.count,11);
2157:
2158: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
2159: hr_utility.set_location('Assignment Set -FormulaID :' || asg_rec.assignment_id,15);

Line 2156: hr_utility.set_location('Assignment Set -Amendments Count :' || l_tab_asg_set_amnds.count,11);

2152: ,p_formula_id => l_formula_id
2153: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
2154: );
2155: hr_utility.set_location('Assignment Set -FormulaID :' || l_formula_id,11);
2156: hr_utility.set_location('Assignment Set -Amendments Count :' || l_tab_asg_set_amnds.count,11);
2157:
2158: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
2159: hr_utility.set_location('Assignment Set -FormulaID :' || asg_rec.assignment_id,15);
2160: l_flag := 'N'; -- Assignment Action not to be created

Line 2159: hr_utility.set_location('Assignment Set -FormulaID :' || asg_rec.assignment_id,15);

2155: hr_utility.set_location('Assignment Set -FormulaID :' || l_formula_id,11);
2156: hr_utility.set_location('Assignment Set -Amendments Count :' || l_tab_asg_set_amnds.count,11);
2157:
2158: If l_formula_id is null and l_tab_asg_set_amnds.count = 0 then
2159: hr_utility.set_location('Assignment Set -FormulaID :' || asg_rec.assignment_id,15);
2160: l_flag := 'N'; -- Assignment Action not to be created
2161: end if;
2162:
2163:

Line 2170: hr_utility.set_location('Assignment Id - l_flag :' || l_flag,11);

2166: ,p_formula_id => l_formula_id
2167: ,p_tab_asg_set_amnds => l_tab_asg_set_amnds
2168: ,p_effective_date => l_effective_date
2169: );
2170: hr_utility.set_location('Assignment Id - l_flag :' || l_flag,11);
2171: End if;
2172:
2173:
2174: if l_flag = 'Y' then

Line 2177: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);

2173:
2174: if l_flag = 'Y' then
2175:
2176: -- Create one assignment action for every assignment
2177: hr_utility.set_location('Archiving for assignment_id '||asg_rec.assignment_id, 50);
2178: select pay_assignment_actions_s.nextval
2179: into lockingactid
2180: from dual;
2181:

Line 2196: hr_utility.set_location('Leaving: '||l_proc,999);

2192: end if;
2193: --l_prev_person := asg_rec.person_id;
2194: end loop;
2195:
2196: hr_utility.set_location('Leaving: '||l_proc,999);
2197: END internal_action_creation_nino;
2198: --
2199:
2200: --

Line 2247: hr_utility.set_location('Entering '|| l_proc, 10);

2243:
2244: l_payroll_rec csr_payroll_details%rowtype;
2245:
2246: BEGIN
2247: hr_utility.set_location('Entering '|| l_proc, 10);
2248: l_err := FALSE;
2249:
2250: open csr_payroll_details(p_payroll_action_id);
2251: fetch csr_payroll_details into l_payroll_rec;

Line 2256: hr_utility.set_location('l_sender_id '|| l_sender_id, 10);

2252: close csr_payroll_details;
2253:
2254: l_rep_typ := l_payroll_rec.report_type;
2255:
2256: hr_utility.set_location('l_sender_id '|| l_sender_id, 10);
2257:
2258: IF l_rep_typ in ('RTI_EAS_REP','RTI_NINO_REP')
2259: THEN
2260: hr_utility.set_location('Calling header validations', 10);

Line 2260: hr_utility.set_location('Calling header validations', 10);

2256: hr_utility.set_location('l_sender_id '|| l_sender_id, 10);
2257:
2258: IF l_rep_typ in ('RTI_EAS_REP','RTI_NINO_REP')
2259: THEN
2260: hr_utility.set_location('Calling header validations', 10);
2261:
2262:
2263: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
2264: hr_utility.set_location('The HMRC Office Number is missing.',10);

Line 2264: hr_utility.set_location('The HMRC Office Number is missing.',10);

2260: hr_utility.set_location('Calling header validations', 10);
2261:
2262:
2263: if l_payroll_rec.tax_office_no = ' ' or l_payroll_rec.tax_office_no is null then
2264: hr_utility.set_location('The HMRC Office Number is missing.',10);
2265: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2266: l_err := true;
2267: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2268: then

Line 2269: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);

2265: fnd_file.put_line(fnd_file.output,'The HMRC Office Number is missing.');
2266: l_err := true;
2267: elsif validate_input(substr(l_payroll_rec.tax_office_no,1,3),'NUMBER') > 0
2268: then
2269: hr_utility.set_location('The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.',10);
2270: fnd_file.put_line(fnd_file.output,'The HMRC Office Number '||l_payroll_rec.tax_office_no||' has invalid characters.');
2271: l_err := true;
2272: end if;
2273:

Line 2275: hr_utility.set_location('The Employer PAYE Reference is missing.',10);

2271: l_err := true;
2272: end if;
2273:
2274: if l_payroll_rec.tax_ref_no = ' ' or l_payroll_rec.tax_ref_no is null then
2275: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2276: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2277: l_err := true;
2278: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2279: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

Line 2279: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);

2275: hr_utility.set_location('The Employer PAYE Reference is missing.',10);
2276: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference is missing.');
2277: l_err := true;
2278: elsif validate_input(l_payroll_rec.tax_ref_no,'FULL_EDI') > 0 then
2279: hr_utility.set_location('The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.',10);
2280: fnd_file.put_line(fnd_file.output,'The Employer PAYE Reference '||l_payroll_rec.tax_ref_no||' has invalid characters.');
2281: l_err := true;
2282: end if;
2283:

Line 2285: hr_utility.set_location('The Employer Name is missing.',10);

2281: l_err := true;
2282: end if;
2283:
2284: if l_payroll_rec.employer_name = ' ' or l_payroll_rec.employer_name is null then
2285: hr_utility.set_location('The Employer Name is missing.',10);
2286: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2287: l_err := true;
2288: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2289: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);

Line 2289: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);

2285: hr_utility.set_location('The Employer Name is missing.',10);
2286: fnd_file.put_line(fnd_file.output,'The Employer Name is missing.');
2287: l_err := true;
2288: elsif validate_input(l_payroll_rec.employer_name,'EMP_NAME') > 0 then
2289: hr_utility.set_location('The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.',10);
2290: fnd_file.put_line(fnd_file.output,'The Employer Name '||l_payroll_rec.employer_name||' has invalid characters.');
2291: l_err := true;
2292: end if;
2293:

Line 2295: hr_utility.set_location('The Account Office Reference Number is missing.',10);

2291: l_err := true;
2292: end if;
2293:
2294: if l_payroll_rec.acc_ref_no = ' ' or l_payroll_rec.acc_ref_no is null then
2295: hr_utility.set_location('The Account Office Reference Number is missing.',10);
2296: fnd_file.put_line(fnd_file.output,'The Account Office Reference Number is missing.');
2297: l_err := true;
2298:
2299: elsif (length(l_payroll_rec.acc_ref_no) > 13

Line 2302: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);

2298:
2299: elsif (length(l_payroll_rec.acc_ref_no) > 13
2300: OR REGEXP_INSTR(l_payroll_rec.acc_ref_no,'^([[:digit:]]{1,3})P([[:alpha:]]{1})([[:digit:]]{1,7})([[:digit:]]|X)$') = 0 ) THEN
2301:
2302: hr_utility.set_location ('Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.',10);
2303: fnd_file.put_line(fnd_file.output,'Incorrect format entered for Accounts Office Ref Num field. Valid format is NNNPANNNNNNNX.');
2304: l_err := true;
2305: END IF;
2306:

Line 2313: hr_utility.set_location('Leaving '|| l_proc, 10);

2309: if (l_err) then
2310: raise l_exp;
2311: end if;
2312:
2313: hr_utility.set_location('Leaving '|| l_proc, 10);
2314: EXCEPTION
2315: when l_exp then
2316: g_validation_check := 'N';
2317: raise_application_error(-20001,'Errors found while archiving data.');

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

2384: )
2385: and l_effective_date between pay.EFFECTIVE_START_DATE and pay.EFFECTIVE_END_DATE;
2386:
2387: BEGIN
2388: hr_utility.set_location('Entering: '||l_proc,1);
2389:
2390: open csr_archive_type;
2391: fetch csr_archive_type into l_archive_type,l_pact_id,l_tax_ref;
2392: close csr_archive_type;

Line 2410: hr_utility.set_location('Archive Code l_effective_date Value:'||l_effective_date,909);

2406: -- For EAS
2407: IF l_archive_type = 'RTI_EAS_REP'
2408: THEN l_effective_date := l_eff_date;
2409: END IF;
2410: hr_utility.set_location('Archive Code l_effective_date Value:'||l_effective_date,909);
2411: l_archive_person := fetch_person_rec(p_assactid, l_effective_date,l_archive_tab(0));
2412:
2413: l_archive_addr := fetch_address_rec(l_archive_tab(0).person_id,
2414: l_archive_tab(0).assignment_id,

Line 2420: hr_utility.trace('employee flag '||l_archive_tab(0).act_info18);

2416: l_archive_tab(1));
2417:
2418: -- Fetching element details
2419:
2420: hr_utility.trace('employee flag '||l_archive_tab(0).act_info18);
2421:
2422: --Fetching assignments details for EAS
2423: IF l_archive_type = 'RTI_EAS_REP'
2424: THEN

Line 2425: hr_utility.set_location('Fetching Assignment details ',30);

2421:
2422: --Fetching assignments details for EAS
2423: IF l_archive_type = 'RTI_EAS_REP'
2424: THEN
2425: hr_utility.set_location('Fetching Assignment details ',30);
2426: l_archive_asg := fetch_eas_asg_rec(l_eff_date,p_assactid,l_archive_tab(0),l_archive_tab(2));
2427: END IF;
2428:
2429: -- Validating fetched Person,Address,Assignment details for EAS

Line 2432: hr_utility.set_location('Calling Person Address validations', 10);

2428:
2429: -- Validating fetched Person,Address,Assignment details for EAS
2430: IF l_archive_type = 'RTI_EAS_REP'
2431: THEN
2432: hr_utility.set_location('Calling Person Address validations', 10);
2433: person_addr_validations(p_assactid, p_effective_date, l_archive_tab, l_archive_type, l_per_addr_val_flag);
2434: hr_utility.trace('person address' ||l_per_addr_val_flag);
2435: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
2436: l_personaddr_val_err := TRUE;

Line 2434: hr_utility.trace('person address' ||l_per_addr_val_flag);

2430: IF l_archive_type = 'RTI_EAS_REP'
2431: THEN
2432: hr_utility.set_location('Calling Person Address validations', 10);
2433: person_addr_validations(p_assactid, p_effective_date, l_archive_tab, l_archive_type, l_per_addr_val_flag);
2434: hr_utility.trace('person address' ||l_per_addr_val_flag);
2435: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
2436: l_personaddr_val_err := TRUE;
2437: END IF;
2438:

Line 2439: hr_utility.set_location('Calling EAS validations', 10);

2435: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
2436: l_personaddr_val_err := TRUE;
2437: END IF;
2438:
2439: hr_utility.set_location('Calling EAS validations', 10);
2440: eas_asg_etext_validations(p_assactid, p_effective_date, l_archive_tab, l_eas_etext_asg_flag);
2441: IF l_eas_etext_asg_flag = 'Y' THEN -- If validation fails
2442: l_eas_val_err := TRUE;
2443: END IF;

Line 2449: hr_utility.set_location('Calling Person Address validations', 10);

2445: END IF;
2446: -- Validating fetched Person,Address details for NINO
2447: IF l_archive_type = 'RTI_NINO_REP'
2448: THEN
2449: hr_utility.set_location('Calling Person Address validations', 10);
2450: person_addr_validations_nino(p_assactid, p_effective_date, l_archive_tab, l_archive_type, l_per_addr_val_flag);
2451: hr_utility.trace('person address' ||l_per_addr_val_flag);
2452: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
2453: l_personaddr_val_err := TRUE;

Line 2451: hr_utility.trace('person address' ||l_per_addr_val_flag);

2447: IF l_archive_type = 'RTI_NINO_REP'
2448: THEN
2449: hr_utility.set_location('Calling Person Address validations', 10);
2450: person_addr_validations_nino(p_assactid, p_effective_date, l_archive_tab, l_archive_type, l_per_addr_val_flag);
2451: hr_utility.trace('person address' ||l_per_addr_val_flag);
2452: IF l_per_addr_val_flag = 'Y' THEN -- If validation fails
2453: l_personaddr_val_err := TRUE;
2454: END IF;
2455: END IF;

Line 2463: hr_utility.set_location('Validation failed, raise error.',999);

2459: IF l_archive_type = 'RTI_EAS_REP'
2460: THEN
2461: IF l_personaddr_val_err OR l_eas_val_err -- If validation fails , that record will not be archived.
2462: THEN
2463: hr_utility.set_location('Validation failed, raise error.',999);
2464: raise error_found;
2465: ELSE
2466: hr_utility.set_location('Validation successful, archive data.',999);
2467: set_new_starter_rti_sent(l_archive_tab(0).assignment_id);

Line 2466: hr_utility.set_location('Validation successful, archive data.',999);

2462: THEN
2463: hr_utility.set_location('Validation failed, raise error.',999);
2464: raise error_found;
2465: ELSE
2466: hr_utility.set_location('Validation successful, archive data.',999);
2467: set_new_starter_rti_sent(l_archive_tab(0).assignment_id);
2468:
2469: -- Set the RTI Sent for the other assignments of the PAYE Aggregation
2470: open fetch_other_paye_agg_asg;

Line 2474: hr_utility.set_location('Checking the RTI Sent flag for other assignments in PAYE Aggregation.',999);

2470: open fetch_other_paye_agg_asg;
2471: loop
2472: fetch fetch_other_paye_agg_asg into l_assignment_id;
2473: exit when fetch_other_paye_agg_asg%notfound;
2474: hr_utility.set_location('Checking the RTI Sent flag for other assignments in PAYE Aggregation.',999);
2475: set_new_starter_rti_sent(l_assignment_id);
2476: end loop;
2477: close fetch_other_paye_agg_asg;
2478:

Line 2487: hr_utility.set_location('Validation failed, raise error.',999);

2483: IF l_archive_type = 'RTI_NINO_REP'
2484: THEN
2485: IF l_personaddr_val_err -- If validation fails , that record will not be archived.
2486: THEN
2487: hr_utility.set_location('Validation failed, raise error.',999);
2488: raise error_found;
2489: ELSE
2490: hr_utility.set_location('Validation successful, archive data.',999);
2491: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);

Line 2490: hr_utility.set_location('Validation successful, archive data.',999);

2486: THEN
2487: hr_utility.set_location('Validation failed, raise error.',999);
2488: raise error_found;
2489: ELSE
2490: hr_utility.set_location('Validation successful, archive data.',999);
2491: insert_archive_row(p_assactid, p_effective_date,l_archive_tab);
2492: END IF;
2493: END IF;
2494:

Line 2499: hr_utility.set_location('Leaving: '||l_proc,999);

2495: else
2496: raise error_found;
2497: end if;
2498:
2499: hr_utility.set_location('Leaving: '||l_proc,999);
2500:
2501: EXCEPTION
2502: when error_found then
2503: IF l_archive_type in ('RTI_EAS_REP','RTI_NINO_REP')

Line 2507: hr_utility.raise_error;

2503: IF l_archive_type in ('RTI_EAS_REP','RTI_NINO_REP')
2504: THEN
2505: raise_application_error(-20001,'Errors found while archiving data.');
2506: ELSE
2507: hr_utility.raise_error;
2508: END IF;
2509: END archive_code;
2510: --
2511: --

Line 2958: hr_utility.set_location('l_nino_eff_date '||l_nino_eff_date,009);

2954: open csr_parameter_date;
2955: fetch csr_parameter_date into l_nino_eff_date;
2956: close csr_parameter_date;
2957:
2958: hr_utility.set_location('l_nino_eff_date '||l_nino_eff_date,009);
2959: end if;
2960: --Completed Records
2961: IF p_type = 'ET' THEN
2962: FOR action_id IN get_asg_action_id LOOP

Line 3098: hr_utility.trace('Entering deinit: '||l_proc);

3094:
3095: ---------------------
3096: ---------------------
3097: BEGIN
3098: hr_utility.trace('Entering deinit: '||l_proc);
3099:
3100: -- To avoid re-archiving while Retry
3101: delete from pay_action_information pai
3102: where pai.action_context_id = pactid

Line 3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);

3108: close csr_payroll_details;
3109:
3110: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
3111:
3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);

Line 3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);

3109:
3110: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
3111:
3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:

Line 3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);

3110: pay_balance_pkg.set_context('PAYROLL_ACTION_ID',pactid);
3111:
3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:
3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);

Line 3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);

3111:
3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:
3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
3119:

Line 3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);

3112: hr_utility.set_location('l_payroll_rec.bus_grp_id = ' || l_payroll_rec.bus_grp_id,10);
3113: hr_utility.set_location('l_payroll_rec.act_param_grp_id = ' || l_payroll_rec.act_param_grp_id,20);
3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:
3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
3119:
3120: pay_action_information_api.create_action_information (

Line 3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);

3114: hr_utility.set_location('l_sender_id = '||l_payroll_rec.sender_id,30);
3115: hr_utility.set_location('l_test_indicator = '||l_payroll_rec.test_indicator,40);
3116: hr_utility.set_location('l_request_id = '||l_payroll_rec.request_id,50);
3117:
3118: hr_utility.set_location('Archiving RTI PAYROLL INFO',60);
3119:
3120: pay_action_information_api.create_action_information (
3121: p_action_information_id => l_action_info_id
3122: , p_action_context_id => pactid

Line 3162: hr_utility.set_location('Spawning RTI Employer Alignment Submission Output process',1);

3158:
3159: -- For Spawning the output Concurrent Program
3160: IF (l_is_etext_report='RTI_EAS_REP') THEN
3161:
3162: hr_utility.set_location('Spawning RTI Employer Alignment Submission Output process',1);
3163:
3164: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYGBRTIEASOP','en','US','ETEXT');
3165: IF (xml_layout = true and g_validation_check = 'Y')
3166: THEN

Line 3178: hr_utility.set_location('Error spawning new process',1);

3174: Commit;
3175: --check for process submit error
3176: IF l_request_id = 0
3177: THEN
3178: hr_utility.set_location('Error spawning new process',1);
3179: END IF;
3180: END IF;
3181: END IF;
3182: IF (l_is_etext_report='RTI_NINO_REP') THEN

Line 3184: hr_utility.set_location('Spawning RTI NINO verification Output process',1);

3180: END IF;
3181: END IF;
3182: IF (l_is_etext_report='RTI_NINO_REP') THEN
3183:
3184: hr_utility.set_location('Spawning RTI NINO verification Output process',1);
3185:
3186: xml_layout := FND_REQUEST.ADD_LAYOUT('PAY','PYGBRTININOOP','en','US','ETEXT');
3187:
3188: IF xml_layout = true

Line 3222: hr_utility.set_location('Error spawning new process',1);

3218:
3219: --check for process submit error
3220: IF l_request_id = 0
3221: THEN
3222: hr_utility.set_location('Error spawning new process',1);
3223: END IF;
3224: END IF;
3225:
3226:

Line 3229: hr_utility.set_location('Leaving: '||l_proc,999);

3225:
3226:
3227: END IF;
3228:
3229: hr_utility.set_location('Leaving: '||l_proc,999);
3230:
3231: END deinitialization_code;
3232: --
3233: -- Function for validating Date fields

Line 3278: hr_utility.set_location('date_validate.l_effective_date '||l_effective_date,1);

3274: l_tax_year_start := add_months(l_tax_date,-12)+1 ;
3275:
3276: l_date_valid := p_validate_date;
3277:
3278: hr_utility.set_location('date_validate.l_effective_date '||l_effective_date,1);
3279: hr_utility.set_location('date_validate.l_tax_date'||l_tax_date,1);
3280:
3281: -- Start Date Validation
3282: if (p_mode = 'UK_EMPL_DATE') then

Line 3279: hr_utility.set_location('date_validate.l_tax_date'||l_tax_date,1);

3275:
3276: l_date_valid := p_validate_date;
3277:
3278: hr_utility.set_location('date_validate.l_effective_date '||l_effective_date,1);
3279: hr_utility.set_location('date_validate.l_tax_date'||l_tax_date,1);
3280:
3281: -- Start Date Validation
3282: if (p_mode = 'UK_EMPL_DATE') then
3283: if (l_test_submission = 'N') then