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 755: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);

751: IF l_pps_number_hr IS NOT NULL THEN
752: ppsno_cnt := ppsno_cnt+1;
753: l_pps_number(ppsno_cnt) :=r_pay.pps_number_hr;
754: --fnd_file.put_line(l_pps_number(ppsno_cnt));
755: hr_utility.set_location('PPS Number..'||l_pps_number_hr,420);
756: -- checks for standard rate tax to be mandatory
757: IF l_std_rate_of_tax IS NULL THEN
758: raise std_rate_of_tax_is_null;
759: END IF; --l_std_rate_of_tax

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

783: -- checks for exact rate of tax
784: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
785: raise normal_tax_mismatch;
786: END IF; --r_pay.exemption_indicator
787: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
788: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
789: --
790: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
791: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then

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

784: IF r_pay.exemption_indicator='N' AND r_pay.higher_rate_of_tax <> l_tax_rate_high then
785: raise normal_tax_mismatch;
786: END IF; --r_pay.exemption_indicator
787: hr_utility.set_location('PPS Number..Initial check'||l_pps_number_hr,421);
788: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,101);
789: --
790: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
791: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
792: raise pay_to_date;

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

790: IF r_pay.tot_pay_to_date is null and r_pay.tot_pay_to_date is null and
791: (r_pay.wk_mth_indicator = 0 or (r_pay.wk_mth_indicator=1 and r_pay.exemption_indicator='Y')) then
792: raise pay_to_date;
793: END IF;
794: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,422);
795:
796: -- check if cerificate start date is before or equal to certificate end date
797:
798: pay_ipd_bus.chk_cert_start_end_dates(

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

798: pay_ipd_bus.chk_cert_start_end_dates(
799: p_certificate_start_date => r_pay.cert_start_date
800: , p_certificate_end_date => r_pay.cert_end_date
801: );
802: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
803: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
804: -- Bug Fix 3500192
805: -- tax basis is set as per the value of week month indicator in the interface table
806: IF (r_pay.wk_mth_indicator = 1) THEN

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

799: p_certificate_start_date => r_pay.cert_start_date
800: , p_certificate_end_date => r_pay.cert_end_date
801: );
802: hr_utility.set_location('PPS Number..third check'||l_pps_number_hr,423);
803: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,102);
804: -- Bug Fix 3500192
805: -- tax basis is set as per the value of week month indicator in the interface table
806: IF (r_pay.wk_mth_indicator = 1) THEN
807: l_tax_basis := 'IE_WEEK1_MONTH1';

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

816: l_tax_basis := 'IE_EXEMPTION';
817: END IF;
818: END IF;
819:
820: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
821: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
822: -- check if amounts are valid for the given tax basis, for 'Emergency'
823: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must
824: -- be null and for other values of tax basis weekly or monthly amounts

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

817: END IF;
818: END IF;
819:
820: hr_utility.set_location('l_tax_basis'||l_tax_basis,424);
821: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,103);
822: -- check if amounts are valid for the given tax basis, for 'Emergency'
823: -- tax basis weekly and monthly tax credits ans std rate cut-off amounts must
824: -- be null and for other values of tax basis weekly or monthly amounts
825: -- (depending on payroll frequency) must be not null.

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

835: , p_monthly_tax_credit => r_pay.mth_tax_credit
836: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
837: );*/
838:
839: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
840: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
841: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
842: to true else for all modes it is set to false*/
843:

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

836: , p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
837: );*/
838:
839: hr_utility.set_location('pay_ipd_bus.chk_tax_basis_amounts'||l_pps_number_hr,424);
840: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,104);
841: /* If the validate mode is 'Validate and Rollback' then set the validation input paramter
842: to true else for all modes it is set to false*/
843:
844: IF p_validate_mode = 'IE_VALIDATE_ROLLBACK' THEN

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

848: END IF;
849:
850: --IF (r_pay.paye_details_id IS NOT NULL AND
851: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
852: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
853: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
854: OPEN get_paye_details(r_pay.assignment_id);
855: FETCH get_paye_details INTO l_paye_count;
856: CLOSE get_paye_details;

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

849:
850: --IF (r_pay.paye_details_id IS NOT NULL AND
851: IF (p_validate_mode = 'IE_VALIDATE_ROLLBACK' OR p_validate_mode = 'IE_VALIDATE_COMMIT') THEN
852: hr_utility.set_location('PPS Number..'||l_pps_number_hr,425);
853: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,105);
854: OPEN get_paye_details(r_pay.assignment_id);
855: FETCH get_paye_details INTO l_paye_count;
856: CLOSE get_paye_details;
857: -- to check if the payroll is attached to the assignment as of certificate

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

868: ,p_monthly_tax_credit => r_pay.mth_tax_credit
869: ,p_monthly_std_rate_cut_off => r_pay.mth_rate_cutoff
870: );
871: IF l_paye_count <> 0 THEN
872: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
873:
874:
875: hr_utility.set_location(r_pay.cert_date, 10);
876:

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

871: IF l_paye_count <> 0 THEN
872: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,426);
873:
874:
875: hr_utility.set_location(r_pay.cert_date, 10);
876:
877: pay_ie_paye_pkg.update_paye_change_freq --4878630
878: (p_assignment_id => r_pay.assignment_id
879: ,p_effective_date => l_effective_date -- Bug 6929566 -- r_pay.cert_date -- 5724436

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

890: ,p_tax_deducted_to_date => r_pay.tot_tax_to_date
891: ,p_pay_to_date => r_pay.tot_pay_to_date
892: ,p_cert_date =>r_pay.cert_date);
893:
894: hr_utility.set_location(r_pay.cert_date, 20);
895: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
896: ELSE
897: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
898: hr_utility.set_location(r_pay.cert_date, 30);

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

891: ,p_pay_to_date => r_pay.tot_pay_to_date
892: ,p_cert_date =>r_pay.cert_date);
893:
894: hr_utility.set_location(r_pay.cert_date, 20);
895: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
896: ELSE
897: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
898: hr_utility.set_location(r_pay.cert_date, 30);
899: pay_ie_paye_api.create_ie_paye_details --4878630

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

893:
894: hr_utility.set_location(r_pay.cert_date, 20);
895: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
896: ELSE
897: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
898: hr_utility.set_location(r_pay.cert_date, 30);
899: pay_ie_paye_api.create_ie_paye_details --4878630
900: (p_validate => false
901: ,p_effective_date => l_effective_date -- Bug 6929566

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

894: hr_utility.set_location(r_pay.cert_date, 20);
895: hr_utility.set_location('l_paye_count <> 0'||l_pps_number_hr,427);
896: ELSE
897: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,428);
898: hr_utility.set_location(r_pay.cert_date, 30);
899: pay_ie_paye_api.create_ie_paye_details --4878630
900: (p_validate => false
901: ,p_effective_date => l_effective_date -- Bug 6929566
902: ,p_assignment_id => r_pay.assignment_id

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

917: ,p_paye_details_id => o_paye_details_id
918: ,p_object_version_number => o_ovn
919: ,p_effective_start_date => o_effective_start_date
920: ,p_effective_end_date => o_effective_end_date);
921: hr_utility.set_location(r_pay.cert_date, 40);
922: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
923: END IF;
924: END IF;
925: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);

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

918: ,p_object_version_number => o_ovn
919: ,p_effective_start_date => o_effective_start_date
920: ,p_effective_end_date => o_effective_end_date);
921: hr_utility.set_location(r_pay.cert_date, 40);
922: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
923: END IF;
924: END IF;
925: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
926: retcode := 0;

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

921: hr_utility.set_location(r_pay.cert_date, 40);
922: hr_utility.set_location('l_paye_count = 0'||l_pps_number_hr,429);
923: END IF;
924: END IF;
925: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,106);
926: retcode := 0;
927:
928:
929: /*Update interface table and set processed flag to 'Yes' to record that record has been updated or

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

933: UPDATE pay_ie_tax_body_interface
934: SET processed_flag = 'Y'
935: WHERE pps_number = r_pay.pps_number_int;
936: END IF;
937: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,107);
938: IF p_validate_mode <> 'IE_VALIDATE' THEN
939: 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');
940: ELSE
941: IF g_validate_count =1 then

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

938: IF p_validate_mode <> 'IE_VALIDATE' THEN
939: 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');
940: ELSE
941: IF g_validate_count =1 then
942: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
943: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
944: OPEN c_get_paye_details(r_pay.assignment_id,
945: r_pay.pps_number_int,
946: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,

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

939: 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');
940: ELSE
941: IF g_validate_count =1 then
942: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,841);
943: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,108);
944: OPEN c_get_paye_details(r_pay.assignment_id,
945: r_pay.pps_number_int,
946: l_effective_date, -- Bug 6929566 -- r_pay.cert_date,
947: r_pay.employee_no_int);

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

969: r_paye_details.MONTHLY_STD_RATE_CUT_OFF := nvl(r_paye_details.MONTHLY_STD_RATE_CUT_OFF,0);
970: END IF;
971: -- end bug 5837091
972: CLOSE c_get_paye_details;
973: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,842);
974:
975: OPEN csr_pay_freq (r_pay.assignment_id,l_effective_date); -- Bug 6929566 --r_pay.cert_date);
976: FETCH csr_pay_freq INTO pay_freq_rec;
977: --

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

976: FETCH csr_pay_freq INTO pay_freq_rec;
977: --
978: IF csr_pay_freq%NOTFOUND THEN
979: CLOSE csr_pay_freq;
980: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
981: hr_utility.raise_error;
982: END IF;
983: --
984: CLOSE csr_pay_freq;

Line 981: hr_utility.raise_error;

977: --
978: IF csr_pay_freq%NOTFOUND THEN
979: CLOSE csr_pay_freq;
980: hr_utility.set_message(801, 'HR_IE_ASG_NOT_IN_PAYROLL');
981: hr_utility.raise_error;
982: END IF;
983: --
984: CLOSE csr_pay_freq;
985: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);

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

981: hr_utility.raise_error;
982: END IF;
983: --
984: CLOSE csr_pay_freq;
985: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
986:
987: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
988: OPEN get_p45_details(r_pay.assignment_id);
989: FETCH get_p45_details INTO l_max_action_id;

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

983: --
984: CLOSE csr_pay_freq;
985: hr_utility.set_location('PPS Number..Second check'||l_pps_number_hr,843);
986:
987: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,109);
988: OPEN get_p45_details(r_pay.assignment_id);
989: FETCH get_p45_details INTO l_max_action_id;
990: CLOSE get_p45_details;
991:

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

988: OPEN get_p45_details(r_pay.assignment_id);
989: FETCH get_p45_details INTO l_max_action_id;
990: CLOSE get_p45_details;
991:
992: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
993: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
994: -- This will be called only if has any assignment actions.
995: IF l_max_action_id <> 0 THEN
996: hr_utility.set_location('Assignment Action ID is not null',112);

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

989: FETCH get_p45_details INTO l_max_action_id;
990: CLOSE get_p45_details;
991:
992: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
993: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
994: -- This will be called only if has any assignment actions.
995: IF l_max_action_id <> 0 THEN
996: hr_utility.set_location('Assignment Action ID is not null',112);
997: l_pay_to_date := NVL (

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

992: hr_utility.set_location('Assignment Number..'||r_pay.employee_no_int,110);
993: hr_utility.set_location('Assignment Action ID..'||l_max_action_id,110);
994: -- This will be called only if has any assignment actions.
995: IF l_max_action_id <> 0 THEN
996: hr_utility.set_location('Assignment Action ID is not null',112);
997: l_pay_to_date := NVL (
998: ROUND (
999: TO_NUMBER (
1000: pay_balance_pkg.get_value (

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

1024: ),
1025: 0
1026: );
1027: ELSE
1028: hr_utility.set_location('Assignment Action ID is null',113);
1029: l_pay_to_date := 0;
1030: l_tax_to_date := 0;
1031: END IF;
1032: -- print the values.