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.

[Home] [Help]

APPS.PAY_IE_PAYE_PKG dependencies on HR_UTILITY

Line 129: hr_utility.set_location('Entering:'||l_proc, 5);

125: end;
126:
127: begin
128:
129: hr_utility.set_location('Entering:'||l_proc, 5);
130: open c_paye_tax_basis;
131:
132: fetch c_paye_tax_basis into p_tax_basis;
133:

Line 141: hr_utility.set_location('Leaving:'||l_proc, 30);

137: return 0;
138: end if;
139:
140: close c_paye_tax_basis;
141: hr_utility.set_location('Leaving:'||l_proc, 30);
142: return 1;
143:
144: exception when others then
145: initialise;

Line 179: hr_utility.set_location('Entering:'||l_proc, 5);

175: AND paaf.effective_end_date >= ptp.start_date;
176:
177: BEGIN
178:
179: hr_utility.set_location('Entering:'||l_proc, 5);
180:
181: OPEN chk_multi_asgn_tax_basis;
182: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
183:

Line 186: hr_utility.set_location('Leaving:'||l_proc, 30);

182: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
183:
184: IF chk_multi_asgn_tax_basis%NOTFOUND THEN
185: close chk_multi_asgn_tax_basis;
186: hr_utility.set_location('Leaving:'||l_proc, 30);
187: return 0;
188: ELSE
189: close chk_multi_asgn_tax_basis;
190: hr_utility.set_location('Leaving:'||l_proc, 31);

Line 190: hr_utility.set_location('Leaving:'||l_proc, 31);

186: hr_utility.set_location('Leaving:'||l_proc, 30);
187: return 0;
188: ELSE
189: close chk_multi_asgn_tax_basis;
190: hr_utility.set_location('Leaving:'||l_proc, 31);
191: return 1;
192: END IF;
193:
194: exception when others then

Line 229: hr_utility.set_location('Entering:'||l_proc, 5);

225: AND paaf.effective_end_date >= ptp.start_date;
226:
227: BEGIN
228:
229: hr_utility.set_location('Entering:'||l_proc, 5);
230:
231: OPEN chk_multi_asgn_tax_basis;
232: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
233:

Line 236: hr_utility.set_location('Leaving:'||l_proc, 30);

232: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
233:
234: IF chk_multi_asgn_tax_basis%NOTFOUND THEN
235: close chk_multi_asgn_tax_basis;
236: hr_utility.set_location('Leaving:'||l_proc, 30);
237: return 0;
238: ELSE
239: close chk_multi_asgn_tax_basis;
240: hr_utility.set_location('Leaving:'||l_proc, 31);

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

236: hr_utility.set_location('Leaving:'||l_proc, 30);
237: return 0;
238: ELSE
239: close chk_multi_asgn_tax_basis;
240: hr_utility.set_location('Leaving:'||l_proc, 31);
241: return 1;
242: END IF;
243:
244: exception when others then

Line 390: hr_utility.set_location('Entering:'||l_proc, 5);

386: --end Local vriables---------
387:
388: begin
389:
390: hr_utility.set_location('Entering:'||l_proc, 5);
391: /********************************/
392: p_reduced_tax_credit:=0;
393: p_reduced_std_rate_cutoff:=0;
394: p_benefit_amount:=0;

Line 519: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);

515: fetch cur_c_soc_ben into total_benefit_amount;
516: close cur_c_soc_ben;
517: -- @D:/Comm/IE/Social_ben/pyietax.pkb
518: p_benefit_amount := nvl(total_benefit_amount,0);
519: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
520: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
521: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
522:
523: close c_paye_dtl;

Line 520: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);

516: close cur_c_soc_ben;
517: -- @D:/Comm/IE/Social_ben/pyietax.pkb
518: p_benefit_amount := nvl(total_benefit_amount,0);
519: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
520: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
521: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
522:
523: close c_paye_dtl;
524: hr_utility.set_location('Leaving:'||l_proc, 30);

Line 521: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);

517: -- @D:/Comm/IE/Social_ben/pyietax.pkb
518: p_benefit_amount := nvl(total_benefit_amount,0);
519: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
520: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
521: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
522:
523: close c_paye_dtl;
524: hr_utility.set_location('Leaving:'||l_proc, 30);
525: return 1;

Line 524: hr_utility.set_location('Leaving:'||l_proc, 30);

520: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
521: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
522:
523: close c_paye_dtl;
524: hr_utility.set_location('Leaving:'||l_proc, 30);
525: return 1;
526:
527: exception when others then
528: initialise;

Line 555: hr_utility.set_location('Entering:'||l_proc, 35);

551: l_proc varchar2(72) := g_package||'get_payroll_details';
552:
553: begin
554:
555: hr_utility.set_location('Entering:'||l_proc, 35);
556:
557: open c_payroll_details;
558: fetch c_payroll_details into p_period_num
559: ,p_payroll_type;

Line 562: hr_utility.set_location('Leaving:'||l_proc, 50);

558: fetch c_payroll_details into p_period_num
559: ,p_payroll_type;
560: close c_payroll_details;
561:
562: hr_utility.set_location('Leaving:'||l_proc, 50);
563:
564: return 1;
565: exception when others then
566: return 0;

Line 628: hr_utility.set_location('Entering : '||l_func, 10);

624: and pipd.assignment_id = p_assignment_id
625: and ppa.effective_date between pipd.effective_start_date and pipd.effective_end_date;
626: --
627: Begin
628: hr_utility.set_location('Entering : '||l_func, 10);
629: OPEN csr_pps_number;
630: FETCH csr_pps_number into l_pps_number;
631: CLOSE csr_pps_number;
632: --

Line 634: hr_utility.set_location('In : '||l_func, 20);

630: FETCH csr_pps_number into l_pps_number;
631: CLOSE csr_pps_number;
632: --
633: IF l_pps_number = 'X' then
634: hr_utility.set_location('In : '||l_func, 20);
635: RETURN 1;
636: ELSE
637: hr_utility.set_location('In : '||l_func, 30);
638: OPEN csr_emer_no_pps_basis;

Line 637: hr_utility.set_location('In : '||l_func, 30);

633: IF l_pps_number = 'X' then
634: hr_utility.set_location('In : '||l_func, 20);
635: RETURN 1;
636: ELSE
637: hr_utility.set_location('In : '||l_func, 30);
638: OPEN csr_emer_no_pps_basis;
639: FETCH csr_emer_no_pps_basis into l_tax_basis;
640: CLOSE csr_emer_no_pps_basis;
641: IF l_tax_basis IS NULL THEN

Line 642: hr_utility.set_location('In : '||l_func, 35);

638: OPEN csr_emer_no_pps_basis;
639: FETCH csr_emer_no_pps_basis into l_tax_basis;
640: CLOSE csr_emer_no_pps_basis;
641: IF l_tax_basis IS NULL THEN
642: hr_utility.set_location('In : '||l_func, 35);
643: l_tax_basis := 'X';
644: END IF;
645: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
646: hr_utility.set_location('In : '||l_func, 40);

Line 646: hr_utility.set_location('In : '||l_func, 40);

642: hr_utility.set_location('In : '||l_func, 35);
643: l_tax_basis := 'X';
644: END IF;
645: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
646: hr_utility.set_location('In : '||l_func, 40);
647: RETURN 0;
648: ELSE
649: hr_utility.set_location('In : '||l_func, 50);
650: RETURN 1;

Line 649: hr_utility.set_location('In : '||l_func, 50);

645: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
646: hr_utility.set_location('In : '||l_func, 40);
647: RETURN 0;
648: ELSE
649: hr_utility.set_location('In : '||l_func, 50);
650: RETURN 1;
651: END IF;
652: hr_utility.set_location('In : '||l_func, 60);
653: END IF;

Line 652: hr_utility.set_location('In : '||l_func, 60);

648: ELSE
649: hr_utility.set_location('In : '||l_func, 50);
650: RETURN 1;
651: END IF;
652: hr_utility.set_location('In : '||l_func, 60);
653: END IF;
654: hr_utility.set_location('In : '||l_func, 70);
655: END get_pps_number;
656: --

Line 654: hr_utility.set_location('In : '||l_func, 70);

650: RETURN 1;
651: END IF;
652: hr_utility.set_location('In : '||l_func, 60);
653: END IF;
654: hr_utility.set_location('In : '||l_func, 70);
655: END get_pps_number;
656: --
657: -- Bug 2943335 added function to see if work incident exist for the person
658: -- This would return true if the work incident

Line 702: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

698: begin
699: --
700: -- Added for GSI Bug 5472781
701: --
702: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
703: --
704: open g_absence_dates (p_element_entry_id);
705: for i in 1..2 loop
706: if i=1 then

Line 715: hr_utility.trace('In: ' || l_procedure_name) ;

711: into l_absence_end_date;
712: end if;
713: end loop;
714: close g_absence_dates ;
715: hr_utility.trace('In: ' || l_procedure_name) ;
716: if l_absence_start_date is not null and l_absence_end_date is not null then
717: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
719: hr_utility.raise_error;

Line 718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');

714: close g_absence_dates ;
715: hr_utility.trace('In: ' || l_procedure_name) ;
716: if l_absence_start_date is not null and l_absence_end_date is not null then
717: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
719: hr_utility.raise_error;
720: end if;
721: end if;
722: hr_utility.trace('Out: ' || l_procedure_name) ;

Line 719: hr_utility.raise_error;

715: hr_utility.trace('In: ' || l_procedure_name) ;
716: if l_absence_start_date is not null and l_absence_end_date is not null then
717: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
719: hr_utility.raise_error;
720: end if;
721: end if;
722: hr_utility.trace('Out: ' || l_procedure_name) ;
723: END IF;

Line 722: hr_utility.trace('Out: ' || l_procedure_name) ;

718: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
719: hr_utility.raise_error;
720: end if;
721: end if;
722: hr_utility.trace('Out: ' || l_procedure_name) ;
723: END IF;
724: end insert_element_entry ;
725: --
726: procedure update_element_entry

Line 736: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN

732: begin
733: --
734: -- Added for GSI Bug 5472781
735: --
736: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
737: --
738: open g_absence_dates (p_element_entry_id);
739: for i in 1..2 loop
740: if i=1 then

Line 749: hr_utility.trace('In: ' || l_procedure_name) ;

745: into l_absence_end_date;
746: end if;
747: end loop;
748: close g_absence_dates ;
749: hr_utility.trace('In: ' || l_procedure_name) ;
750: if l_absence_start_date is not null and l_absence_end_date is not null then
751: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
753: hr_utility.raise_error;

Line 752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');

748: close g_absence_dates ;
749: hr_utility.trace('In: ' || l_procedure_name) ;
750: if l_absence_start_date is not null and l_absence_end_date is not null then
751: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
753: hr_utility.raise_error;
754: end if;
755: end if;
756: hr_utility.trace('Out: ' || l_procedure_name) ;

Line 753: hr_utility.raise_error;

749: hr_utility.trace('In: ' || l_procedure_name) ;
750: if l_absence_start_date is not null and l_absence_end_date is not null then
751: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
753: hr_utility.raise_error;
754: end if;
755: end if;
756: hr_utility.trace('Out: ' || l_procedure_name) ;
757: END IF;

Line 756: hr_utility.trace('Out: ' || l_procedure_name) ;

752: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
753: hr_utility.raise_error;
754: end if;
755: end if;
756: hr_utility.trace('Out: ' || l_procedure_name) ;
757: END IF;
758: end update_element_entry ;
759: --
760: /* End of BUG 3030621 */

Line 1156: hr_utility.set_location('In update_paye_change_freq',840);

1152: l_new_payroll_id := p_payroll_id;
1153: l_effective_date :=p_effective_date;
1154: l_assignment_id := p_assignment_id;
1155: /*Checking whether pay frequency is changed or not*/
1156: hr_utility.set_location('In update_paye_change_freq',840);
1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);

Line 1157: hr_utility.set_location('effective date..'||l_effective_date,841);

1153: l_effective_date :=p_effective_date;
1154: l_assignment_id := p_assignment_id;
1155: /*Checking whether pay frequency is changed or not*/
1156: hr_utility.set_location('In update_paye_change_freq',840);
1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);

Line 1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);

1154: l_assignment_id := p_assignment_id;
1155: /*Checking whether pay frequency is changed or not*/
1156: hr_utility.set_location('In update_paye_change_freq',840);
1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);

Line 1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);

1155: /*Checking whether pay frequency is changed or not*/
1156: hr_utility.set_location('In update_paye_change_freq',840);
1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);

Line 1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);

1156: hr_utility.set_location('In update_paye_change_freq',840);
1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);

Line 1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);

1157: hr_utility.set_location('effective date..'||l_effective_date,841);
1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);

Line 1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);

1158: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);

Line 1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);

1159: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);

Line 1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);

1160: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);

Line 1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);

1161: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1169:

Line 1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);

1162: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1169:
1170:

Line 1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);

1163: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1169:
1170:
1171: if l_new_payroll_id is not null then

Line 1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);

1164: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1165: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1166: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1167: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1169:
1170:
1171: if l_new_payroll_id is not null then
1172: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);

Line 1172: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);

1168: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1169:
1170:
1171: if l_new_payroll_id is not null then
1172: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);
1173: if p_tax_upload_flag <> 'TU' then --4878630
1174: hr_utility.set_location('p_tax_upload_flag <> TU..'|| l_new_payroll_id,854);
1175: open csr_get_assg(l_assignment_id,l_effective_date);
1176: fetch csr_get_assg into l_prim_payroll_id,l_asg_effective_start_date;

Line 1174: hr_utility.set_location('p_tax_upload_flag <> TU..'|| l_new_payroll_id,854);

1170:
1171: if l_new_payroll_id is not null then
1172: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);
1173: if p_tax_upload_flag <> 'TU' then --4878630
1174: hr_utility.set_location('p_tax_upload_flag <> TU..'|| l_new_payroll_id,854);
1175: open csr_get_assg(l_assignment_id,l_effective_date);
1176: fetch csr_get_assg into l_prim_payroll_id,l_asg_effective_start_date;
1177: close csr_get_assg;
1178:

Line 1195: hr_utility.set_location('l_new_flag <> l_old_flag or p_tax_upload_flag <> X',855);

1191: end if; -- p_tax_upload_flag <> 'TU'
1192:
1193: if ( l_new_flag <> l_old_flag or p_tax_upload_flag <> 'X' ) then -- --4878630
1194: /*Fetching global values */
1195: hr_utility.set_location('l_new_flag <> l_old_flag or p_tax_upload_flag <> X',855);
1196: if l_new_flag =1 and p_tax_upload_flag <> 'TU' then
1197: hr_utility.set_location('l_new_flag =1',856);
1198: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1199: fetch get_global_val into l_monthly_tax_credit;

Line 1197: hr_utility.set_location('l_new_flag =1',856);

1193: if ( l_new_flag <> l_old_flag or p_tax_upload_flag <> 'X' ) then -- --4878630
1194: /*Fetching global values */
1195: hr_utility.set_location('l_new_flag <> l_old_flag or p_tax_upload_flag <> X',855);
1196: if l_new_flag =1 and p_tax_upload_flag <> 'TU' then
1197: hr_utility.set_location('l_new_flag =1',856);
1198: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1199: fetch get_global_val into l_monthly_tax_credit;
1200: close get_global_val;
1201: open get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF',l_effective_date);

Line 1208: hr_utility.set_location('l_new_flag =0',857);

1204: /* For monthly payroll, weekly values must be null */
1205: l_weekly_tax_credit :=NULL;
1206: l_weekly_std_rate_cut_off :=NULL;
1207: elsif l_new_flag = 0 and p_tax_upload_flag <> 'TU' then
1208: hr_utility.set_location('l_new_flag =0',857);
1209: open get_global_val('IE_WEEKLY_TAX_CREDIT',l_effective_date);
1210: fetch get_global_val into l_weekly_tax_credit;
1211: close get_global_val;
1212: open get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF',l_effective_date);

Line 1219: hr_utility.set_location('p_tax_upload_flag =TU',858);

1215: /* For weekly payroll, monthly values must be null */
1216: l_monthly_tax_credit :=NULL;
1217: l_monthly_std_rate_cut_off :=NULL;
1218: elsif p_tax_upload_flag = 'TU' then -- --4878630
1219: hr_utility.set_location('p_tax_upload_flag =TU',858);
1220: l_weekly_tax_credit := p_weekly_tax_credit;
1221: l_monthly_tax_credit := p_monthly_tax_credit;
1222: l_weekly_std_rate_cut_off := p_weekly_std_rate_cut_off;
1223: l_monthly_std_rate_cut_off := p_monthly_std_rate_cut_off;

Line 1230: hr_utility.set_location('if found',859);

1226:
1227: open c_effective_paye ;
1228: fetch c_effective_paye into c_effective_paye_fetch;
1229: if c_effective_paye%found then
1230: hr_utility.set_location('if found',859);
1231: -- delete all future records ie diff paye_details_id
1232: open c_future_paye(c_effective_paye_fetch.paye_details_id);
1233: loop
1234: fetch c_future_paye into c_future_paye_fetch;

Line 1236: hr_utility.set_location('if loop',860);

1232: open c_future_paye(c_effective_paye_fetch.paye_details_id);
1233: loop
1234: fetch c_future_paye into c_future_paye_fetch;
1235: EXIT when c_future_paye%NOTFOUND;
1236: hr_utility.set_location('if loop',860);
1237: pay_ie_paye_api.delete_ie_paye_details
1238: (p_validate => FALSE
1239: ,p_effective_date => c_future_paye_fetch.effective_start_date
1240: ,p_datetrack_delete_mode => 'ZAP'

Line 1250: hr_utility.set_location('l_api_ovn..'||l_api_ovn,861);

1246: end loop;
1247: close c_future_paye;
1248: -- FETCH OVN
1249: l_api_ovn := c_effective_paye_fetch.object_version_number;
1250: hr_utility.set_location('l_api_ovn..'||l_api_ovn,861);
1251: --if the start date is the effective date in the form then only mode possible should be CORRECTION
1252: if (c_effective_paye_fetch.tax_basis <> 'IE_CUMULATIVE' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPTION'
1253: and c_effective_paye_fetch.tax_basis <> 'IE_WEEK1_MONTH1' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPT_WEEK_MONTH'
1254: and p_tax_upload_flag <> 'TU' ) then

Line 1255: hr_utility.set_location('Emergency ..',862);

1251: --if the start date is the effective date in the form then only mode possible should be CORRECTION
1252: if (c_effective_paye_fetch.tax_basis <> 'IE_CUMULATIVE' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPTION'
1253: and c_effective_paye_fetch.tax_basis <> 'IE_WEEK1_MONTH1' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPT_WEEK_MONTH'
1254: and p_tax_upload_flag <> 'TU' ) then
1255: hr_utility.set_location('Emergency ..',862);
1256: l_weekly_tax_credit:=NULL;
1257: l_weekly_std_rate_cut_off:=NULL;
1258: l_monthly_tax_credit:=NULL;
1259: l_monthly_std_rate_cut_off:=NULL;

Line 1264: hr_utility.set_location('date <> 31-12-4712',863);

1260: end if;
1261: --if there are no future changes to the paye record.
1262: if c_effective_paye_fetch.effective_end_date <> to_date('31-12-4712','DD-MM-YYYY') then
1263: --if there are future changes.Then just leave one till 4712 using mode future change
1264: hr_utility.set_location('date <> 31-12-4712',863);
1265: pay_ie_paye_api.delete_ie_paye_details
1266: (p_validate => FALSE
1267: ,p_effective_date => c_effective_paye_fetch.effective_start_date
1268: ,p_datetrack_delete_mode => 'FUTURE_CHANGE'

Line 1278: hr_utility.set_location('c_effective_paye_fetch.effective_start_date = p_effective_date',864);

1274:
1275: end if;
1276:
1277: if c_effective_paye_fetch.effective_start_date = p_effective_date then
1278: hr_utility.set_location('c_effective_paye_fetch.effective_start_date = p_effective_date',864);
1279: --if P_DATETRACK_UPDATE_MODE = 'CORRECTION' then
1280: pay_ie_paye_api.update_ie_paye_details
1281: (p_validate => FALSE
1282: ,p_effective_date => p_effective_date

Line 1307: hr_utility.set_location('Correction and <> TU',865);

1303: else --c_effective_paye_fetch.effective_start_date <> p_effective_date
1304: -- should always be update with new credits and cutoffs
1305: if P_DATETRACK_UPDATE_MODE = 'CORRECTION' then
1306: -- check with asg start date
1307: hr_utility.set_location('Correction and <> TU',865);
1308: if (l_asg_effective_start_date <= c_effective_paye_fetch.effective_start_date ) then
1309: pay_ie_paye_api.update_ie_paye_details
1310: (p_validate => FALSE
1311: ,p_effective_date => p_effective_date

Line 1332: hr_utility.set_location('Correction and <> TU',865);

1328: ,p_object_version_number => l_api_ovn
1329: ,p_effective_start_date => l_start_date
1330: ,p_effective_end_date => l_end_date);
1331: else -- asg start date > paye start date then update using asg start date
1332: hr_utility.set_location('Correction and <> TU',865);
1333: pay_ie_paye_api.update_ie_paye_details
1334: (p_validate => FALSE
1335: ,p_effective_date => l_asg_effective_start_date
1336: ,p_datetrack_update_mode => 'UPDATE'

Line 1357: hr_utility.set_location('UPDATE and = TU',866);

1353: ,p_effective_start_date => l_start_date
1354: ,p_effective_end_date => l_end_date);
1355: end if; -- end of check with asg start date
1356: else -- P_DATETRACK_UPDATE_MODE <> 'CORRECTION'
1357: hr_utility.set_location('UPDATE and = TU',866);
1358: pay_ie_paye_api.update_ie_paye_details
1359: (p_validate => FALSE
1360: ,p_effective_date => p_effective_date
1361: ,p_datetrack_update_mode => 'UPDATE'

Line 1381: hr_utility.set_location('After datetrack check',867);

1377: ,p_object_version_number => l_api_ovn
1378: ,p_effective_start_date => l_start_date
1379: ,p_effective_end_date => l_end_date);
1380: end if; --P_DATETRACK_UPDATE_MODE = 'CORRECTION'
1381: hr_utility.set_location('After datetrack check',867);
1382: end if; -- c_effective_paye_fetch.effective_start_date = p_effective_date
1383: else -- not found
1384: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1385: --the effective date.this record should be extended upto 4712

Line 1386: hr_utility.set_location('Effective date does not lie between paye start and end date',868);

1382: end if; -- c_effective_paye_fetch.effective_start_date = p_effective_date
1383: else -- not found
1384: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1385: --the effective date.this record should be extended upto 4712
1386: hr_utility.set_location('Effective date does not lie between paye start and end date',868);
1387: if p_tax_upload_flag <> 'TU' then --4878630
1388: hr_utility.set_location('<> TU',869);
1389: open c_future_paye(null);
1390: fetch c_future_paye into c_future_paye_fetch ;

Line 1388: hr_utility.set_location('<> TU',869);

1384: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1385: --the effective date.this record should be extended upto 4712
1386: hr_utility.set_location('Effective date does not lie between paye start and end date',868);
1387: if p_tax_upload_flag <> 'TU' then --4878630
1388: hr_utility.set_location('<> TU',869);
1389: open c_future_paye(null);
1390: fetch c_future_paye into c_future_paye_fetch ;
1391: l_min_paye_id := c_future_paye_fetch.paye_details_id ;
1392: l_min_effective_date := c_future_paye_fetch.effective_start_date;

Line 1403: hr_utility.set_location('= TU',870);

1399: l_tax_assess_basis := c_future_paye_fetch.tax_assess_basis;
1400: l_futrec_effective_end_date := c_future_paye_fetch.effective_end_date;
1401: close c_future_paye;
1402: else --4878630
1403: hr_utility.set_location('= TU',870);
1404: open c_tax_effective_paye(null,p_effective_date);
1405: fetch c_tax_effective_paye into c_tax_upload_paye;
1406: l_max_paye_id := c_tax_upload_paye.paye_details_id;
1407: l_max_effective_start_date := c_tax_upload_paye.effective_start_date;

Line 1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);

1409: l_api_ovn := c_tax_upload_paye.object_version_number;
1410: l_info_source := c_tax_upload_paye.info_source;
1411: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1412: CLOSE c_tax_effective_paye;
1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);

Line 1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);

1410: l_info_source := c_tax_upload_paye.info_source;
1411: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1412: CLOSE c_tax_effective_paye;
1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1418:

Line 1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);

1411: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1412: CLOSE c_tax_effective_paye;
1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1418:
1419: end if;

Line 1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);

1412: CLOSE c_tax_effective_paye;
1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1418:
1419: end if;
1420: IF p_tax_upload_flag <> 'TU' then

Line 1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);

1413: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1414: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1415: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1416: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1417: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1418:
1419: end if;
1420: IF p_tax_upload_flag <> 'TU' then
1421: --delete any other future records ie different paye_details_id

Line 1488: hr_utility.set_location('else of future paye.'|| l_info_source,876);

1484: );
1485: END IF;-- futrec is null
1486: ELSE -- p_tax_upload_flag = 'TU'
1487: --delete any other future records ie different paye_details_id
1488: hr_utility.set_location('else of future paye.'|| l_info_source,876);
1489: open c_tax_effective_paye(l_max_paye_id,l_max_effective_start_date);
1490: loop
1491: fetch c_tax_effective_paye into c_tax_upload_paye;
1492: EXIT when c_tax_effective_paye%NOTFOUND;

Line 1493: hr_utility.set_location('In loop',878);

1489: open c_tax_effective_paye(l_max_paye_id,l_max_effective_start_date);
1490: loop
1491: fetch c_tax_effective_paye into c_tax_upload_paye;
1492: EXIT when c_tax_effective_paye%NOTFOUND;
1493: hr_utility.set_location('In loop',878);
1494: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1495: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1496:
1497: pay_ie_paye_api.delete_ie_paye_details

Line 1494: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);

1490: loop
1491: fetch c_tax_effective_paye into c_tax_upload_paye;
1492: EXIT when c_tax_effective_paye%NOTFOUND;
1493: hr_utility.set_location('In loop',878);
1494: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1495: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1496:
1497: pay_ie_paye_api.delete_ie_paye_details
1498: (p_validate => FALSE

Line 1495: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);

1491: fetch c_tax_effective_paye into c_tax_upload_paye;
1492: EXIT when c_tax_effective_paye%NOTFOUND;
1493: hr_utility.set_location('In loop',878);
1494: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1495: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1496:
1497: pay_ie_paye_api.delete_ie_paye_details
1498: (p_validate => FALSE
1499: ,p_effective_date => c_tax_upload_paye.effective_start_date

Line 1507: hr_utility.set_location('else of future paye After ZAping',881);

1503: ,p_effective_start_date => l_start_date
1504: ,p_effective_end_date => l_end_date
1505: );
1506: end loop;
1507: hr_utility.set_location('else of future paye After ZAping',881);
1508: close c_tax_effective_paye;
1509:
1510: hr_utility.set_location('l_futrec_effective_end_date..'|| l_futrec_effective_end_date,879);
1511: if l_futrec_effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')

Line 1510: hr_utility.set_location('l_futrec_effective_end_date..'|| l_futrec_effective_end_date,879);

1506: end loop;
1507: hr_utility.set_location('else of future paye After ZAping',881);
1508: close c_tax_effective_paye;
1509:
1510: hr_utility.set_location('l_futrec_effective_end_date..'|| l_futrec_effective_end_date,879);
1511: if l_futrec_effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')
1512: AND (l_futrec_effective_end_date IS NOT NULL)
1513: then
1514: --extend the first record after the effective date till 4712

Line 1528: hr_utility.set_location('The last Mode',880);

1524: end if;
1525:
1526: --only mode possible should be correction, using the new credits and cutoffs
1527: IF (l_futrec_effective_end_date IS NOT NULL) THEN
1528: hr_utility.set_location('The last Mode',880);
1529: pay_ie_paye_api.update_ie_paye_details
1530: (p_validate => FALSE
1531: ,p_effective_date => l_max_effective_start_date
1532: ,p_datetrack_update_mode => 'CORRECTION'

Line 1552: hr_utility.set_location('After The last Mode',881);

1548: ,p_object_version_number => l_api_ovn
1549: ,p_effective_start_date => l_start_date
1550: ,p_effective_end_date => l_end_date
1551: );
1552: hr_utility.set_location('After The last Mode',881);
1553: END IF;-- futrec is null
1554:
1555: END If; -- p_tax_upload_flag <> 'TU'
1556: end if; --if c_effective_paye%found