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

Line 596: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);

592: IF l_pps_number_hr IS NOT NULL THEN
593: ppsno_cnt := ppsno_cnt+1;
594: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
595: --fnd_file.put_line(l_pps_number(ppsno_cnt));
596: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
597: -- checks for standard rate tax to be mandatory
598: IF l_std_rate_of_tax IS NULL THEN
599: raise std_rate_of_tax_is_null;
600: END IF; --l_std_rate_of_tax

Line 627: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);

623: -- checks for exact rate of tax
624: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
625: raise normal_tax_mismatch;
626: END IF; --r_pay.exemption_indicator
627: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
628: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
629: --
630: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
631: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then

Line 628: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);

624: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
625: raise normal_tax_mismatch;
626: END IF; --r_pay.exemption_indicator
627: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
628: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
629: --
630: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
631: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
632: raise pay_to_date;

Line 634: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,422);

630: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
631: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
632: raise pay_to_date;
633: END IF;
634: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,422);
635:
636: -- check if cerificate start date is before or equal to certificate end date
637:
638: pay_ipd_bus.chk_cert_start_end_dates(

Line 642: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);

638: pay_ipd_bus.chk_cert_start_end_dates(
639: p_certificate_start_date => r_pay.cert_start_date
640: , p_certificate_end_date => r_pay.cert_end_date
641: );
642: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
643: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
644: -- Bug Fix 3500192
645: -- tax basis is set as per the value of week month indicator in the interface table
646: IF (r_pay.wk_mth_indicator = 1) THEN

Line 643: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);

639: p_certificate_start_date => r_pay.cert_start_date
640: , p_certificate_end_date => r_pay.cert_end_date
641: );
642: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
643: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
644: -- Bug Fix 3500192
645: -- tax basis is set as per the value of week month indicator in the interface table
646: IF (r_pay.wk_mth_indicator = 1) THEN
647: l_tax_basis := 'IE_WEEK1_MONTH1';

Line 670: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);

666: l_usc_tax_basis := 'IE_CUMULATIVE';
667: END IF;
668: END IF;
669:
670: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
671: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
672:
673: -- check if amounts are valid for the given tax basis, for 'Emergency'
674: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must

Line 671: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);

667: END IF;
668: END IF;
669:
670: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
671: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
672:
673: -- check if amounts are valid for the given tax basis, for 'Emergency'
674: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must
675: -- be null and for other values of tax basis weekly or monthly amounts

Line 690: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);

686: , p_monthly_tax_credit => r_pay.mth_tax_credit
687: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
688: );*/
689:
690: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
691: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
692: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
693: to true else for all modes it is set to false*/
694:

Line 691: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);

687: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
688: );*/
689:
690: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
691: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
692: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
693: to true else for all modes it is set to false*/
694:
695: IF p_validate_mode = 'IE_VALIDATE_ROLLBACK' THEN

Line 703: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);

699: END IF;
700:
701: --IF (r_pay.paye_details_id IS NOT NULL AND
702: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
703: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
704: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
705:
706: OPEN get_paye_details(r_pay.assignment_id);
707: FETCH get_paye_details INTO l_paye_count;

Line 704: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);

700:
701: --IF (r_pay.paye_details_id IS NOT NULL AND
702: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
703: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
704: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
705:
706: OPEN get_paye_details(r_pay.assignment_id);
707: FETCH get_paye_details INTO l_paye_count;
708: CLOSE get_paye_details;

Line 724: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);

720: ,p_monthly_tax_credit => r_pay.mth_tax_credit
721: ,p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
722: );
723: IF l_paye_count <> 0 THEN
724: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
725:
726: hr_utility.set_location(r_pay.cert_date, 10);
727:
728: pay_ie_paye_pkg.update_paye_change_freq --4878630

Line 726: hr_utility.set_location(r_pay.cert_date, 10);

722: );
723: IF l_paye_count <> 0 THEN
724: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
725:
726: hr_utility.set_location(r_pay.cert_date, 10);
727:
728: pay_ie_paye_pkg.update_paye_change_freq --4878630
729: (p_assignment_id => r_pay.assignment_id
730: ,p_effective_date => l_effective_date -- Bug 6929566 -- r_pay.cert_date -- 5724436

Line 784: hr_utility.set_location(r_pay.cert_date, 20);

780: ,p_usc_info_source => 'IE_ELECTRONIC'
781: --13359423
782: );
783:
784: hr_utility.set_location(r_pay.cert_date, 20);
785: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
786: ELSE
787: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
788: hr_utility.set_location(r_pay.cert_date, 30);

Line 785: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);

781: --13359423
782: );
783:
784: hr_utility.set_location(r_pay.cert_date, 20);
785: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
786: ELSE
787: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
788: hr_utility.set_location(r_pay.cert_date, 30);
789: pay_ie_paye_api.create_ie_paye_details --4878630

Line 787: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);

783:
784: hr_utility.set_location(r_pay.cert_date, 20);
785: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
786: ELSE
787: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
788: hr_utility.set_location(r_pay.cert_date, 30);
789: pay_ie_paye_api.create_ie_paye_details --4878630
790: (p_validate => false
791: ,p_effective_date => l_effective_date -- Bug 6929566

Line 788: hr_utility.set_location(r_pay.cert_date, 30);

784: hr_utility.set_location(r_pay.cert_date, 20);
785: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
786: ELSE
787: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
788: hr_utility.set_location(r_pay.cert_date, 30);
789: pay_ie_paye_api.create_ie_paye_details --4878630
790: (p_validate => false
791: ,p_effective_date => l_effective_date -- Bug 6929566
792: ,p_assignment_id => r_pay.assignment_id

Line 850: hr_utility.set_location(r_pay.cert_date, 40);

846: ,p_usc_tax_basis => l_usc_tax_basis
847: ,p_usc_info_source => 'IE_ELECTRONIC'
848: --13359423
849: );
850: hr_utility.set_location(r_pay.cert_date, 40);
851: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
852: END IF;
853: END IF;
854: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);

Line 851: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);

847: ,p_usc_info_source => 'IE_ELECTRONIC'
848: --13359423
849: );
850: hr_utility.set_location(r_pay.cert_date, 40);
851: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
852: END IF;
853: END IF;
854: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
855: retcode := 0;

Line 854: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);

850: hr_utility.set_location(r_pay.cert_date, 40);
851: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
852: END IF;
853: END IF;
854: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
855: retcode := 0;
856:
857:
858: /*Update interface table and set processed flag to 'Yes' to record that record has been updated or

Line 866: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);

862: UPDATE pay_ie_tax_body_interface
863: SET processed_flag = 'Y'
864: WHERE pps_number = r_pay.pps_number_int;
865: END IF;
866: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);
867: IF p_validate_mode <> 'IE_VALIDATE' THEN
868: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
869: ELSE
870: IF g_validate_count =1 then

Line 871: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);

867: IF p_validate_mode <> 'IE_VALIDATE' THEN
868: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
869: ELSE
870: IF g_validate_count =1 then
871: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
872: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
873: OPEN c_get_paye_details(r_pay.assignment_id,
874: r_pay.pps_number_int,
875: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,

Line 872: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);

868: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
869: ELSE
870: IF g_validate_count =1 then
871: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
872: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
873: OPEN c_get_paye_details(r_pay.assignment_id,
874: r_pay.pps_number_int,
875: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,
876: r_pay.employee_no_int);

Line 902: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,842);

898: r_paye_details.MONTHLY_STD_RATE_CUT_OFF := nvl(r_paye_details.MONTHLY_STD_RATE_CUT_OFF,0);
899: END IF;
900: -- end bug 5837091
901: CLOSE c_get_paye_details;
902: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,842);
903:
904: OPEN csr_pay_freq (r_pay.assignment_id,l_effective_date); -- Bug 6929566 --r_pay.cert_date);
905: FETCH csr_pay_freq INTO pay_freq_rec;
906: --

Line 909: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');

905: FETCH csr_pay_freq INTO pay_freq_rec;
906: --
907: IF csr_pay_freq%NOTFOUND THEN
908: CLOSE csr_pay_freq;
909: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
910: hr_utility.raise_error;
911: END IF;
912: --
913: CLOSE csr_pay_freq;

Line 910: hr_utility.raise_error;

906: --
907: IF csr_pay_freq%NOTFOUND THEN
908: CLOSE csr_pay_freq;
909: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
910: hr_utility.raise_error;
911: END IF;
912: --
913: CLOSE csr_pay_freq;
914: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);

Line 914: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);

910: hr_utility.raise_error;
911: END IF;
912: --
913: CLOSE csr_pay_freq;
914: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
915:
916: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
917: OPEN get_p45_details(r_pay.assignment_id);
918: FETCH get_p45_details INTO l_max_action_id;

Line 916: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);

912: --
913: CLOSE csr_pay_freq;
914: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
915:
916: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
917: OPEN get_p45_details(r_pay.assignment_id);
918: FETCH get_p45_details INTO l_max_action_id;
919: CLOSE get_p45_details;
920:

Line 921: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);

917: OPEN get_p45_details(r_pay.assignment_id);
918: FETCH get_p45_details INTO l_max_action_id;
919: CLOSE get_p45_details;
920:
921: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
922: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
923: -- This will be called only if has any assignment actions.
924: IF l_max_action_id <> 0 THEN
925: hr_utility.set_location('Assignment Action ID is not null',112);

Line 922: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);

918: FETCH get_p45_details INTO l_max_action_id;
919: CLOSE get_p45_details;
920:
921: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
922: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
923: -- This will be called only if has any assignment actions.
924: IF l_max_action_id <> 0 THEN
925: hr_utility.set_location('Assignment Action ID is not null',112);
926: l_pay_to_date := NVL (

Line 925: hr_utility.set_location('Assignment Action ID is not null',112);

921: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
922: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
923: -- This will be called only if has any assignment actions.
924: IF l_max_action_id <> 0 THEN
925: hr_utility.set_location('Assignment Action ID is not null',112);
926: l_pay_to_date := NVL (
927: ROUND (
928: TO_NUMBER (
929: pay_balance_pkg.get_value (

Line 990: hr_utility.set_location('Assignment Action ID is null',113);

986: );
987: --13359423
988:
989: ELSE
990: hr_utility.set_location('Assignment Action ID is null',113);
991: l_pay_to_date := 0;
992: l_tax_to_date := 0;
993:
994: --13359423

Line 2394: hr_utility.trace('Beginning line is :'||l_present_line);

2390: THEN
2391: retcode := 2;
2392: errbuf := 'Invalid file format.';
2393: fnd_file.PUT_LINE(FND_FILE.LOG,'File not started with HC_TAX_YEAR');
2394: hr_utility.trace('Beginning line is :'||l_present_line);
2395: raise invalid_file_format;
2396: END IF;
2397:
2398: utl_file.get_line(l_file_handle,l_present_line);--Reading Header values

Line 2457: hr_utility.trace('Beginning line is :'||l_present_line);

2453: THEN
2454: retcode := 2;
2455: errbuf := 'Invalid file format.';
2456: fnd_file.PUT_LINE(FND_FILE.LOG,'Body not started with ID_PPSN');
2457: hr_utility.trace('Beginning line is :'||l_present_line);
2458: raise invalid_file_format;
2459: END IF;
2460:
2461: --fnd_file.PUT_LINE(FND_FILE.LOG, '+++++++++BODY+++++++++');

Line 2890: hr_utility.set_location( l_pkg ,100);

2886:
2887: EXCEPTION
2888: WHEN e_fatal_error
2889: THEN
2890: hr_utility.set_location( l_pkg ,100);
2891:
2892: WHEN UTL_FILE.INVALID_OPERATION
2893: THEN
2894:

Line 2896: hr_utility.set_location( l_pkg ,110);

2892: WHEN UTL_FILE.INVALID_OPERATION
2893: THEN
2894:
2895: UTL_FILE.FCLOSE(l_file_handle);
2896: hr_utility.set_location( l_pkg ,110);
2897: retcode:=2;
2898: errbuf := 'Reading File - Invalid Operation (file not found).';
2899:
2900: WHEN UTL_FILE.INTERNAL_ERROR

Line 2904: hr_utility.set_location( l_pkg,120);

2900: WHEN UTL_FILE.INTERNAL_ERROR
2901: THEN
2902:
2903: UTL_FILE.FCLOSE(l_file_handle);
2904: hr_utility.set_location( l_pkg,120);
2905: retcode:=2;
2906: errbuf := 'Reading File - Internal Error.';
2907: WHEN UTL_FILE.INVALID_MODE
2908: THEN

Line 2911: hr_utility.set_location( l_pkg,130);

2907: WHEN UTL_FILE.INVALID_MODE
2908: THEN
2909:
2910: UTL_FILE.FCLOSE(l_file_handle);
2911: hr_utility.set_location( l_pkg,130);
2912: retcode:=2;
2913: errbuf := 'Reading Flat File - Invalid Mode.';
2914:
2915: WHEN UTL_FILE.INVALID_PATH

Line 2919: hr_utility.set_location( l_pkg ||'PAYE Upload',140);

2915: WHEN UTL_FILE.INVALID_PATH
2916: THEN
2917:
2918: UTL_FILE.FCLOSE(l_file_handle);
2919: hr_utility.set_location( l_pkg ||'PAYE Upload',140);
2920: retcode:=2;
2921: errbuf := 'Reading File - Invalid Path.';
2922:
2923: WHEN UTL_FILE.INVALID_FILEHANDLE

Line 2927: hr_utility.set_location( l_pkg,150);

2923: WHEN UTL_FILE.INVALID_FILEHANDLE
2924: THEN
2925:
2926: UTL_FILE.FCLOSE(l_file_handle);
2927: hr_utility.set_location( l_pkg,150);
2928: retcode:=2;
2929: errbuf := 'Reading File - Invalid File Handle.';
2930:
2931: WHEN UTL_FILE.READ_ERROR

Line 2935: hr_utility.set_location( l_pkg,160);

2931: WHEN UTL_FILE.READ_ERROR
2932: THEN
2933:
2934: UTL_FILE.FCLOSE(l_file_handle);
2935: hr_utility.set_location( l_pkg,160);
2936: retcode:=2;
2937: errbuf := 'Reading File - Read Error.';
2938:
2939: WHEN NO_DATA_FOUND

Line 2942: hr_utility.set_location( l_pkg,170);

2938:
2939: WHEN NO_DATA_FOUND
2940: THEN
2941: UTL_FILE.FCLOSE(l_file_handle);
2942: hr_utility.set_location( l_pkg,170);
2943: retcode:=2;
2944: errbuf := 'No Data Found.';
2945:
2946: WHEN INVALID_FILE_FORMAT

Line 2949: hr_utility.set_location( l_pkg,180);

2945:
2946: WHEN INVALID_FILE_FORMAT
2947: THEN
2948: UTL_FILE.FCLOSE(l_file_handle);
2949: hr_utility.set_location( l_pkg,180);
2950: retcode:=2;
2951: errbuf := 'Reading File - Invalid File Format.';
2952:
2953: WHEN NO_REC_FOUND_IN_FILE

Line 2956: hr_utility.set_location( l_pkg,190);

2952:
2953: WHEN NO_REC_FOUND_IN_FILE
2954: THEN
2955: UTL_FILE.FCLOSE(l_file_handle);
2956: hr_utility.set_location( l_pkg,190);
2957: retcode:=2;
2958: errbuf := 'Reading File - No Records found.';
2959:
2960: WHEN e_invlid_tax_year

Line 2962: hr_utility.set_location( l_pkg,200);

2958: errbuf := 'Reading File - No Records found.';
2959:
2960: WHEN e_invlid_tax_year
2961: THEN
2962: hr_utility.set_location( l_pkg,200);
2963: retcode:=2;
2964: errbuf := 'Invalid Tax Year.';
2965:
2966: WHEN others

Line 2970: hr_utility.set_location( l_pkg,210);

2966: WHEN others
2967: THEN
2968: retcode:=2;
2969: errbuf := 'Exception occured :'||sqlerrm;
2970: hr_utility.set_location( l_pkg,210);
2971:
2972: END read_tax_file;
2973: --13359423
2974:

Line 3723: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);

3719: IF l_pps_number_hr IS NOT NULL THEN
3720: ppsno_cnt := ppsno_cnt+1;
3721: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
3722: --fnd_file.put_line(l_pps_number(ppsno_cnt));
3723: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
3724: -- checks for standard rate tax to be mandatory
3725: IF l_std_rate_of_tax IS NULL THEN
3726: raise std_rate_of_tax_is_null;
3727: END IF; --l_std_rate_of_tax

Line 3755: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);

3751: -- checks for exact rate of tax
3752: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
3753: raise normal_tax_mismatch;
3754: END IF; --r_pay.exemption_indicator
3755: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
3756: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
3757: --
3758: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
3759: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then

Line 3756: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);

3752: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
3753: raise normal_tax_mismatch;
3754: END IF; --r_pay.exemption_indicator
3755: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
3756: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
3757: --
3758: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
3759: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
3760: raise pay_to_date;

Line 3762: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,422);

3758: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
3759: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
3760: raise pay_to_date;
3761: END IF;
3762: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,422);
3763:
3764: -- check if cerificate start date is before or equal to certificate end date
3765:
3766: pay_ipd_bus.chk_cert_start_end_dates(

Line 3770: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);

3766: pay_ipd_bus.chk_cert_start_end_dates(
3767: p_certificate_start_date => r_pay.cert_start_date
3768: , p_certificate_end_date => r_pay.cert_end_date
3769: );
3770: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
3771: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
3772: -- Bug Fix 3500192
3773: -- tax basis is set as per the value of week month indicator in the interface table
3774: IF (r_pay.wk_mth_indicator = 1) THEN

Line 3771: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);

3767: p_certificate_start_date => r_pay.cert_start_date
3768: , p_certificate_end_date => r_pay.cert_end_date
3769: );
3770: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
3771: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
3772: -- Bug Fix 3500192
3773: -- tax basis is set as per the value of week month indicator in the interface table
3774: IF (r_pay.wk_mth_indicator = 1) THEN
3775: l_tax_basis := 'IE_WEEK1_MONTH1';

Line 3788: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);

3784: l_tax_basis := 'IE_EXEMPTION';
3785: END IF;
3786: END IF;
3787:
3788: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
3789: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
3790: -- check if amounts are valid for the given tax basis, for 'Emergency'
3791: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must
3792: -- be null and for other values of tax basis weekly or monthly amounts

Line 3789: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);

3785: END IF;
3786: END IF;
3787:
3788: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
3789: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
3790: -- check if amounts are valid for the given tax basis, for 'Emergency'
3791: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must
3792: -- be null and for other values of tax basis weekly or monthly amounts
3793: -- (depending on payroll frequency) must be not null.

Line 3807: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);

3803: , p_monthly_tax_credit => r_pay.mth_tax_credit
3804: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
3805: );*/
3806:
3807: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
3808: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
3809: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
3810: to true else for all modes it is set to false*/
3811:

Line 3808: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);

3804: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
3805: );*/
3806:
3807: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
3808: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
3809: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
3810: to true else for all modes it is set to false*/
3811:
3812: IF p_validate_mode = 'IE_VALIDATE_ROLLBACK' THEN

Line 3820: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);

3816: END IF;
3817:
3818: --IF (r_pay.paye_details_id IS NOT NULL AND
3819: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
3820: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
3821: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
3822: OPEN get_paye_details(r_pay.assignment_id);
3823: FETCH get_paye_details INTO l_paye_count;
3824: CLOSE get_paye_details;

Line 3821: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);

3817:
3818: --IF (r_pay.paye_details_id IS NOT NULL AND
3819: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
3820: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
3821: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
3822: OPEN get_paye_details(r_pay.assignment_id);
3823: FETCH get_paye_details INTO l_paye_count;
3824: CLOSE get_paye_details;
3825: -- to check if the payroll is attached to the assignment as of certificate

Line 3840: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);

3836: ,p_monthly_tax_credit => r_pay.mth_tax_credit
3837: ,p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
3838: );
3839: IF l_paye_count <> 0 THEN
3840: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
3841:
3842:
3843: hr_utility.set_location(r_pay.cert_date, 10);
3844:

Line 3843: hr_utility.set_location(r_pay.cert_date, 10);

3839: IF l_paye_count <> 0 THEN
3840: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
3841:
3842:
3843: hr_utility.set_location(r_pay.cert_date, 10);
3844:
3845: pay_ie_paye_pkg.update_paye_change_freq --4878630
3846: (p_assignment_id => r_pay.assignment_id
3847: ,p_effective_date => l_effective_date -- Bug 6929566 -- r_pay.cert_date -- 5724436

Line 3862: hr_utility.set_location(r_pay.cert_date, 20);

3858: ,p_tax_deducted_to_date => r_pay.tot_tax_to_date
3859: ,p_pay_to_date => r_pay.tot_pay_to_date
3860: ,p_cert_date =>r_pay.cert_date);
3861:
3862: hr_utility.set_location(r_pay.cert_date, 20);
3863: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
3864: ELSE
3865: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
3866: hr_utility.set_location(r_pay.cert_date, 30);

Line 3863: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);

3859: ,p_pay_to_date => r_pay.tot_pay_to_date
3860: ,p_cert_date =>r_pay.cert_date);
3861:
3862: hr_utility.set_location(r_pay.cert_date, 20);
3863: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
3864: ELSE
3865: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
3866: hr_utility.set_location(r_pay.cert_date, 30);
3867: pay_ie_paye_api.create_ie_paye_details --4878630

Line 3865: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);

3861:
3862: hr_utility.set_location(r_pay.cert_date, 20);
3863: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
3864: ELSE
3865: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
3866: hr_utility.set_location(r_pay.cert_date, 30);
3867: pay_ie_paye_api.create_ie_paye_details --4878630
3868: (p_validate => false
3869: ,p_effective_date => l_effective_date -- Bug 6929566

Line 3866: hr_utility.set_location(r_pay.cert_date, 30);

3862: hr_utility.set_location(r_pay.cert_date, 20);
3863: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
3864: ELSE
3865: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
3866: hr_utility.set_location(r_pay.cert_date, 30);
3867: pay_ie_paye_api.create_ie_paye_details --4878630
3868: (p_validate => false
3869: ,p_effective_date => l_effective_date -- Bug 6929566
3870: ,p_assignment_id => r_pay.assignment_id

Line 3889: hr_utility.set_location(r_pay.cert_date, 40);

3885: ,p_paye_details_id => o_paye_details_id
3886: ,p_object_version_number => o_ovn
3887: ,p_effective_start_date => o_effective_start_date
3888: ,p_effective_end_date => o_effective_end_date);
3889: hr_utility.set_location(r_pay.cert_date, 40);
3890: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
3891: END IF;
3892: END IF;
3893: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);

Line 3890: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);

3886: ,p_object_version_number => o_ovn
3887: ,p_effective_start_date => o_effective_start_date
3888: ,p_effective_end_date => o_effective_end_date);
3889: hr_utility.set_location(r_pay.cert_date, 40);
3890: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
3891: END IF;
3892: END IF;
3893: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
3894: retcode := 0;

Line 3893: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);

3889: hr_utility.set_location(r_pay.cert_date, 40);
3890: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
3891: END IF;
3892: END IF;
3893: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
3894: retcode := 0;
3895:
3896:
3897: /*Update interface table and set processed flag to 'Yes' to record that record has been updated or

Line 3905: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);

3901: UPDATE pay_ie_tax_body_interface
3902: SET processed_flag = 'Y'
3903: WHERE pps_number = r_pay.pps_number_int;
3904: END IF;
3905: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);
3906: IF p_validate_mode <> 'IE_VALIDATE' THEN
3907: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
3908: ELSE
3909: IF g_validate_count =1 then

Line 3910: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);

3906: IF p_validate_mode <> 'IE_VALIDATE' THEN
3907: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
3908: ELSE
3909: IF g_validate_count =1 then
3910: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
3911: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
3912: OPEN c_get_paye_details(r_pay.assignment_id,
3913: r_pay.pps_number_int,
3914: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,

Line 3911: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);

3907: fnd_file.put_line(fnd_file.output,lpad(r_pay.pps_number_int,11,' ')||lpad(substr(r_pay.employee_no_int,1,12),13,' ')||lpad(' ',20,' ')||'Success');
3908: ELSE
3909: IF g_validate_count =1 then
3910: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
3911: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
3912: OPEN c_get_paye_details(r_pay.assignment_id,
3913: r_pay.pps_number_int,
3914: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,
3915: r_pay.employee_no_int);

Line 3941: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,842);

3937: r_paye_details.MONTHLY_STD_RATE_CUT_OFF := nvl(r_paye_details.MONTHLY_STD_RATE_CUT_OFF,0);
3938: END IF;
3939: -- end bug 5837091
3940: CLOSE c_get_paye_details;
3941: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,842);
3942:
3943: OPEN csr_pay_freq (r_pay.assignment_id,l_effective_date); -- Bug 6929566 --r_pay.cert_date);
3944: FETCH csr_pay_freq INTO pay_freq_rec;
3945: --

Line 3948: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');

3944: FETCH csr_pay_freq INTO pay_freq_rec;
3945: --
3946: IF csr_pay_freq%NOTFOUND THEN
3947: CLOSE csr_pay_freq;
3948: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
3949: hr_utility.raise_error;
3950: END IF;
3951: --
3952: CLOSE csr_pay_freq;

Line 3949: hr_utility.raise_error;

3945: --
3946: IF csr_pay_freq%NOTFOUND THEN
3947: CLOSE csr_pay_freq;
3948: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
3949: hr_utility.raise_error;
3950: END IF;
3951: --
3952: CLOSE csr_pay_freq;
3953: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);

Line 3953: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);

3949: hr_utility.raise_error;
3950: END IF;
3951: --
3952: CLOSE csr_pay_freq;
3953: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
3954:
3955: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
3956: OPEN get_p45_details(r_pay.assignment_id);
3957: FETCH get_p45_details INTO l_max_action_id;

Line 3955: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);

3951: --
3952: CLOSE csr_pay_freq;
3953: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
3954:
3955: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
3956: OPEN get_p45_details(r_pay.assignment_id);
3957: FETCH get_p45_details INTO l_max_action_id;
3958: CLOSE get_p45_details;
3959:

Line 3960: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);

3956: OPEN get_p45_details(r_pay.assignment_id);
3957: FETCH get_p45_details INTO l_max_action_id;
3958: CLOSE get_p45_details;
3959:
3960: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
3961: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
3962: -- This will be called only if has any assignment actions.
3963: IF l_max_action_id <> 0 THEN
3964: hr_utility.set_location('Assignment Action ID is not null',112);

Line 3961: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);

3957: FETCH get_p45_details INTO l_max_action_id;
3958: CLOSE get_p45_details;
3959:
3960: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
3961: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
3962: -- This will be called only if has any assignment actions.
3963: IF l_max_action_id <> 0 THEN
3964: hr_utility.set_location('Assignment Action ID is not null',112);
3965: l_pay_to_date := NVL (

Line 3964: hr_utility.set_location('Assignment Action ID is not null',112);

3960: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
3961: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
3962: -- This will be called only if has any assignment actions.
3963: IF l_max_action_id <> 0 THEN
3964: hr_utility.set_location('Assignment Action ID is not null',112);
3965: l_pay_to_date := NVL (
3966: ROUND (
3967: TO_NUMBER (
3968: pay_balance_pkg.get_value (

Line 3996: hr_utility.set_location('Assignment Action ID is null',113);

3992: ),
3993: 0
3994: );
3995: ELSE
3996: hr_utility.set_location('Assignment Action ID is null',113);
3997: l_pay_to_date := 0;
3998: l_tax_to_date := 0;
3999: END IF;
4000: -- print the values.