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

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

135: end;
136:
137: begin
138:
139: hr_utility.set_location('Entering:'||l_proc, 5);
140: open c_paye_tax_basis;
141:
142: fetch c_paye_tax_basis into p_tax_basis;
143:

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

147: return 0;
148: end if;
149:
150: close c_paye_tax_basis;
151: hr_utility.set_location('Leaving:'||l_proc, 30);
152: return 1;
153:
154: exception when others then
155: initialise;

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

185: AND paaf.effective_end_date >= ptp.start_date;
186:
187: BEGIN
188:
189: hr_utility.set_location('Entering:'||l_proc, 5);
190:
191: OPEN chk_multi_asgn_tax_basis;
192: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
193:

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

192: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
193:
194: IF chk_multi_asgn_tax_basis%NOTFOUND THEN
195: close chk_multi_asgn_tax_basis;
196: hr_utility.set_location('Leaving:'||l_proc, 30);
197: return 0;
198: ELSE
199: close chk_multi_asgn_tax_basis;
200: hr_utility.set_location('Leaving:'||l_proc, 31);

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

196: hr_utility.set_location('Leaving:'||l_proc, 30);
197: return 0;
198: ELSE
199: close chk_multi_asgn_tax_basis;
200: hr_utility.set_location('Leaving:'||l_proc, 31);
201: return 1;
202: END IF;
203:
204: exception when others then

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

235: AND paaf.effective_end_date >= ptp.start_date;
236:
237: BEGIN
238:
239: hr_utility.set_location('Entering:'||l_proc, 5);
240:
241: OPEN chk_multi_asgn_tax_basis;
242: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
243:

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

242: FETCH chk_multi_asgn_tax_basis INTO l_sec_assignment;
243:
244: IF chk_multi_asgn_tax_basis%NOTFOUND THEN
245: close chk_multi_asgn_tax_basis;
246: hr_utility.set_location('Leaving:'||l_proc, 30);
247: return 0;
248: ELSE
249: close chk_multi_asgn_tax_basis;
250: hr_utility.set_location('Leaving:'||l_proc, 31);

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

246: hr_utility.set_location('Leaving:'||l_proc, 30);
247: return 0;
248: ELSE
249: close chk_multi_asgn_tax_basis;
250: hr_utility.set_location('Leaving:'||l_proc, 31);
251: return 1;
252: END IF;
253:
254: exception when others then

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

396: --end Local vriables---------
397:
398: begin
399:
400: hr_utility.set_location('Entering:'||l_proc, 5);
401: /********************************/
402: p_reduced_tax_credit:=0;
403: p_reduced_std_rate_cutoff:=0;
404: p_benefit_amount:=0;

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

525: fetch cur_c_soc_ben into total_benefit_amount;
526: close cur_c_soc_ben;
527: -- @D:/Comm/IE/Social_ben/pyietax.pkb
528: p_benefit_amount := nvl(total_benefit_amount,0);
529: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
530: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
531: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
532:
533: close c_paye_dtl;

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

526: close cur_c_soc_ben;
527: -- @D:/Comm/IE/Social_ben/pyietax.pkb
528: p_benefit_amount := nvl(total_benefit_amount,0);
529: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
530: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
531: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
532:
533: close c_paye_dtl;
534: hr_utility.set_location('Leaving:'||l_proc, 30);

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

527: -- @D:/Comm/IE/Social_ben/pyietax.pkb
528: p_benefit_amount := nvl(total_benefit_amount,0);
529: hr_utility.set_location('benefit amt:'||p_benefit_amount, 15);
530: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
531: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
532:
533: close c_paye_dtl;
534: hr_utility.set_location('Leaving:'||l_proc, 30);
535: return 1;

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

530: hr_utility.set_location('p_monthly_tax_credit: '||p_monthly_tax_credit, 25);
531: hr_utility.set_location('p_monthly_std_rate_cutoff:'||p_monthly_std_rate_cutoff, 35);
532:
533: close c_paye_dtl;
534: hr_utility.set_location('Leaving:'||l_proc, 30);
535: return 1;
536:
537: exception when others then
538: initialise;

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

623:
624:
625: begin
626:
627: hr_utility.set_location('Entering:'||l_proc, 5);
628:
629: open c_usc_dtl;
630:
631: fetch c_usc_dtl into p_tax_basis

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

652: initialise;
653: return 0;
654: end if;
655: close c_usc_dtl;
656: hr_utility.set_location('Leaving:'||l_proc, 30);
657: return 1;
658:
659: exception when others then
660: initialise;

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

683: l_proc varchar2(72) := g_package||'get_payroll_details';
684:
685: begin
686:
687: hr_utility.set_location('Entering:'||l_proc, 35);
688:
689: open c_payroll_details;
690: fetch c_payroll_details into p_period_num
691: ,p_payroll_type;

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

690: fetch c_payroll_details into p_period_num
691: ,p_payroll_type;
692: close c_payroll_details;
693:
694: hr_utility.set_location('Leaving:'||l_proc, 50);
695:
696: return 1;
697: exception when others then
698: return 0;

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

756: and pipd.assignment_id = p_assignment_id
757: and ppa.effective_date between pipd.effective_start_date and pipd.effective_end_date;
758: --
759: Begin
760: hr_utility.set_location('Entering : '||l_func, 10);
761: OPEN csr_pps_number;
762: FETCH csr_pps_number into l_pps_number;
763: CLOSE csr_pps_number;
764: --

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

762: FETCH csr_pps_number into l_pps_number;
763: CLOSE csr_pps_number;
764: --
765: IF l_pps_number = 'X' then
766: hr_utility.set_location('In : '||l_func, 20);
767: RETURN 1;
768: ELSE
769: hr_utility.set_location('In : '||l_func, 30);
770: OPEN csr_emer_no_pps_basis;

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

765: IF l_pps_number = 'X' then
766: hr_utility.set_location('In : '||l_func, 20);
767: RETURN 1;
768: ELSE
769: hr_utility.set_location('In : '||l_func, 30);
770: OPEN csr_emer_no_pps_basis;
771: FETCH csr_emer_no_pps_basis into l_tax_basis;
772: CLOSE csr_emer_no_pps_basis;
773: IF l_tax_basis IS NULL THEN

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

770: OPEN csr_emer_no_pps_basis;
771: FETCH csr_emer_no_pps_basis into l_tax_basis;
772: CLOSE csr_emer_no_pps_basis;
773: IF l_tax_basis IS NULL THEN
774: hr_utility.set_location('In : '||l_func, 35);
775: l_tax_basis := 'X';
776: END IF;
777: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
778: hr_utility.set_location('In : '||l_func, 40);

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

774: hr_utility.set_location('In : '||l_func, 35);
775: l_tax_basis := 'X';
776: END IF;
777: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
778: hr_utility.set_location('In : '||l_func, 40);
779: RETURN 0;
780: ELSE
781: hr_utility.set_location('In : '||l_func, 50);
782: RETURN 1;

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

777: IF l_tax_basis <> 'IE_EMERGENCY_NO_PPS' THEN
778: hr_utility.set_location('In : '||l_func, 40);
779: RETURN 0;
780: ELSE
781: hr_utility.set_location('In : '||l_func, 50);
782: RETURN 1;
783: END IF;
784: hr_utility.set_location('In : '||l_func, 60);
785: END IF;

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

780: ELSE
781: hr_utility.set_location('In : '||l_func, 50);
782: RETURN 1;
783: END IF;
784: hr_utility.set_location('In : '||l_func, 60);
785: END IF;
786: hr_utility.set_location('In : '||l_func, 70);
787: END get_pps_number;
788: --

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

782: RETURN 1;
783: END IF;
784: hr_utility.set_location('In : '||l_func, 60);
785: END IF;
786: hr_utility.set_location('In : '||l_func, 70);
787: END get_pps_number;
788: --
789: -- Bug 2943335 added function to see if work incident exist for the person
790: -- This would return true if the work incident

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

830: begin
831: --
832: -- Added for GSI Bug 5472781
833: --
834: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
835: --
836: open g_absence_dates (p_element_entry_id);
837: for i in 1..2 loop
838: if i=1 then

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

843: into l_absence_end_date;
844: end if;
845: end loop;
846: close g_absence_dates ;
847: hr_utility.trace('In: ' || l_procedure_name) ;
848: if l_absence_start_date is not null and l_absence_end_date is not null then
849: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
850: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
851: hr_utility.raise_error;

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

846: close g_absence_dates ;
847: hr_utility.trace('In: ' || l_procedure_name) ;
848: if l_absence_start_date is not null and l_absence_end_date is not null then
849: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
850: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
851: hr_utility.raise_error;
852: end if;
853: end if;
854: hr_utility.trace('Out: ' || l_procedure_name) ;

Line 851: hr_utility.raise_error;

847: hr_utility.trace('In: ' || l_procedure_name) ;
848: if l_absence_start_date is not null and l_absence_end_date is not null then
849: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
850: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
851: hr_utility.raise_error;
852: end if;
853: end if;
854: hr_utility.trace('Out: ' || l_procedure_name) ;
855: END IF;

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

850: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
851: hr_utility.raise_error;
852: end if;
853: end if;
854: hr_utility.trace('Out: ' || l_procedure_name) ;
855: END IF;
856: end insert_element_entry ;
857: --
858: procedure update_element_entry

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

864: begin
865: --
866: -- Added for GSI Bug 5472781
867: --
868: IF hr_utility.chk_product_install('Oracle Human Resources', 'IE') THEN
869: --
870: open g_absence_dates (p_element_entry_id);
871: for i in 1..2 loop
872: if i=1 then

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

877: into l_absence_end_date;
878: end if;
879: end loop;
880: close g_absence_dates ;
881: hr_utility.trace('In: ' || l_procedure_name) ;
882: if l_absence_start_date is not null and l_absence_end_date is not null then
883: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
884: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
885: hr_utility.raise_error;

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

880: close g_absence_dates ;
881: hr_utility.trace('In: ' || l_procedure_name) ;
882: if l_absence_start_date is not null and l_absence_end_date is not null then
883: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
884: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
885: hr_utility.raise_error;
886: end if;
887: end if;
888: hr_utility.trace('Out: ' || l_procedure_name) ;

Line 885: hr_utility.raise_error;

881: hr_utility.trace('In: ' || l_procedure_name) ;
882: if l_absence_start_date is not null and l_absence_end_date is not null then
883: if FND_DATE.CANONICAL_TO_DATE(l_absence_start_date) > FND_DATE.CANONICAL_TO_DATE(l_absence_end_date) then
884: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
885: hr_utility.raise_error;
886: end if;
887: end if;
888: hr_utility.trace('Out: ' || l_procedure_name) ;
889: END IF;

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

884: hr_utility.set_message(801,'HR_IE_SOCIAL_BENEFIT_DATES');
885: hr_utility.raise_error;
886: end if;
887: end if;
888: hr_utility.trace('Out: ' || l_procedure_name) ;
889: END IF;
890: end update_element_entry ;
891: --
892: /* End of BUG 3030621 */

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

1363: l_new_payroll_id := p_payroll_id;
1364: l_effective_date :=p_effective_date;
1365: l_assignment_id := p_assignment_id;
1366: /*Checking whether pay frequency is changed or not*/
1367: hr_utility.set_location('In update_paye_change_freq',840);
1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);

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

1364: l_effective_date :=p_effective_date;
1365: l_assignment_id := p_assignment_id;
1366: /*Checking whether pay frequency is changed or not*/
1367: hr_utility.set_location('In update_paye_change_freq',840);
1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);

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

1365: l_assignment_id := p_assignment_id;
1366: /*Checking whether pay frequency is changed or not*/
1367: hr_utility.set_location('In update_paye_change_freq',840);
1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);

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

1366: /*Checking whether pay frequency is changed or not*/
1367: hr_utility.set_location('In update_paye_change_freq',840);
1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);

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

1367: hr_utility.set_location('In update_paye_change_freq',840);
1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);

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

1368: hr_utility.set_location('effective date..'||l_effective_date,841);
1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);

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

1369: hr_utility.set_location('p_payroll_id..'||p_payroll_id,842);
1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);

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

1370: hr_utility.set_location('p_tax_upload_flag..'||p_tax_upload_flag,843);
1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);

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

1371: hr_utility.set_location('p_tax_basis..'|| p_tax_basis,844);
1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);

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

1372: hr_utility.set_location('p_cert_start_date..'|| p_cert_start_date,845);
1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1380:

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

1373: hr_utility.set_location('p_cert_end_date..'|| p_cert_end_date,846);
1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1380:
1381:

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

1374: hr_utility.set_location('p_weekly_tax_credit ..'|| p_weekly_tax_credit,847);
1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1380:
1381:
1382: if l_new_payroll_id is not null then

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

1375: hr_utility.set_location('p_monthly_tax_credit..'|| p_monthly_tax_credit,848);
1376: hr_utility.set_location('p_weekly_std_rate_cut_off..'|| p_weekly_std_rate_cut_off,849);
1377: hr_utility.set_location('p_monthly_std_rate_cut_off..'|| p_monthly_std_rate_cut_off,850);
1378: hr_utility.set_location('p_tax_deducted_to_date..'|| p_tax_deducted_to_date,851);
1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1380:
1381:
1382: if l_new_payroll_id is not null then
1383: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);

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

1379: hr_utility.set_location('p_pay_to_date..'|| p_pay_to_date,852);
1380:
1381:
1382: if l_new_payroll_id is not null then
1383: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);
1384: if p_tax_upload_flag <> 'TU' then --4878630
1385: hr_utility.set_location('p_tax_upload_flag <> TU..'|| l_new_payroll_id,854);
1386: open csr_get_assg(l_assignment_id,l_effective_date);
1387: fetch csr_get_assg into l_prim_payroll_id,l_asg_effective_start_date;

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

1381:
1382: if l_new_payroll_id is not null then
1383: hr_utility.set_location('l_new_payroll_id is not null..'|| l_new_payroll_id,853);
1384: if p_tax_upload_flag <> 'TU' then --4878630
1385: hr_utility.set_location('p_tax_upload_flag <> TU..'|| l_new_payroll_id,854);
1386: open csr_get_assg(l_assignment_id,l_effective_date);
1387: fetch csr_get_assg into l_prim_payroll_id,l_asg_effective_start_date;
1388: close csr_get_assg;
1389:

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

1402: end if; -- p_tax_upload_flag <> 'TU'
1403:
1404: if ( l_new_flag <> l_old_flag or p_tax_upload_flag <> 'X' ) then -- --4878630
1405: /*Fetching global values */
1406: hr_utility.set_location('l_new_flag <> l_old_flag or p_tax_upload_flag <> X',855);
1407: if l_new_flag =1 and p_tax_upload_flag <> 'TU' then
1408: hr_utility.set_location('l_new_flag =1',856);
1409: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1410: fetch get_global_val into l_monthly_tax_credit;

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

1404: if ( l_new_flag <> l_old_flag or p_tax_upload_flag <> 'X' ) then -- --4878630
1405: /*Fetching global values */
1406: hr_utility.set_location('l_new_flag <> l_old_flag or p_tax_upload_flag <> X',855);
1407: if l_new_flag =1 and p_tax_upload_flag <> 'TU' then
1408: hr_utility.set_location('l_new_flag =1',856);
1409: open get_global_val('IE_MONTHLY_TAX_CREDIT',l_effective_date);
1410: fetch get_global_val into l_monthly_tax_credit;
1411: close get_global_val;
1412: open get_global_val('IE_MONTHLY_STANDARD_RATE_CUT_OFF',l_effective_date);

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

1415: /* For monthly payroll, weekly values must be null */
1416: l_weekly_tax_credit :=NULL;
1417: l_weekly_std_rate_cut_off :=NULL;
1418: elsif l_new_flag = 0 and p_tax_upload_flag <> 'TU' then
1419: hr_utility.set_location('l_new_flag =0',857);
1420: open get_global_val('IE_WEEKLY_TAX_CREDIT',l_effective_date);
1421: fetch get_global_val into l_weekly_tax_credit;
1422: close get_global_val;
1423: open get_global_val('IE_WEEKLY_STANDARD_RATE_CUT_OFF',l_effective_date);

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

1426: /* For weekly payroll, monthly values must be null */
1427: l_monthly_tax_credit :=NULL;
1428: l_monthly_std_rate_cut_off :=NULL;
1429: elsif p_tax_upload_flag = 'TU' then -- --4878630
1430: hr_utility.set_location('p_tax_upload_flag =TU',858);
1431: l_weekly_tax_credit := p_weekly_tax_credit;
1432: l_monthly_tax_credit := p_monthly_tax_credit;
1433: l_weekly_std_rate_cut_off := p_weekly_std_rate_cut_off;
1434: l_monthly_std_rate_cut_off := p_monthly_std_rate_cut_off;

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

1437:
1438: open c_effective_paye ;
1439: fetch c_effective_paye into c_effective_paye_fetch;
1440: if c_effective_paye%found then
1441: hr_utility.set_location('if found',859);
1442: -- delete all future records ie diff paye_details_id
1443: open c_future_paye(c_effective_paye_fetch.paye_details_id);
1444: loop
1445: fetch c_future_paye into c_future_paye_fetch;

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

1443: open c_future_paye(c_effective_paye_fetch.paye_details_id);
1444: loop
1445: fetch c_future_paye into c_future_paye_fetch;
1446: EXIT when c_future_paye%NOTFOUND;
1447: hr_utility.set_location('if loop',860);
1448: pay_ie_paye_api.delete_ie_paye_details
1449: (p_validate => FALSE
1450: ,p_effective_date => c_future_paye_fetch.effective_start_date
1451: ,p_datetrack_delete_mode => 'ZAP'

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

1457: end loop;
1458: close c_future_paye;
1459: -- FETCH OVN
1460: l_api_ovn := c_effective_paye_fetch.object_version_number;
1461: hr_utility.set_location('l_api_ovn..'||l_api_ovn,861);
1462: --if the start date is the effective date in the form then only mode possible should be CORRECTION
1463: if (c_effective_paye_fetch.tax_basis <> 'IE_CUMULATIVE' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPTION'
1464: and c_effective_paye_fetch.tax_basis <> 'IE_WEEK1_MONTH1' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPT_WEEK_MONTH'
1465: and p_tax_upload_flag <> 'TU' ) then

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

1462: --if the start date is the effective date in the form then only mode possible should be CORRECTION
1463: if (c_effective_paye_fetch.tax_basis <> 'IE_CUMULATIVE' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPTION'
1464: and c_effective_paye_fetch.tax_basis <> 'IE_WEEK1_MONTH1' and c_effective_paye_fetch.tax_basis <> 'IE_EXEMPT_WEEK_MONTH'
1465: and p_tax_upload_flag <> 'TU' ) then
1466: hr_utility.set_location('Emergency ..',862);
1467: l_weekly_tax_credit:=NULL;
1468: l_weekly_std_rate_cut_off:=NULL;
1469: l_monthly_tax_credit:=NULL;
1470: l_monthly_std_rate_cut_off:=NULL;

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

1471: end if;
1472: --if there are no future changes to the paye record.
1473: if c_effective_paye_fetch.effective_end_date <> to_date('31-12-4712','DD-MM-YYYY') then
1474: --if there are future changes.Then just leave one till 4712 using mode future change
1475: hr_utility.set_location('date <> 31-12-4712',863);
1476: pay_ie_paye_api.delete_ie_paye_details
1477: (p_validate => FALSE
1478: ,p_effective_date => c_effective_paye_fetch.effective_start_date
1479: ,p_datetrack_delete_mode => 'FUTURE_CHANGE'

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

1485:
1486: end if;
1487:
1488: if c_effective_paye_fetch.effective_start_date = p_effective_date then
1489: hr_utility.set_location('c_effective_paye_fetch.effective_start_date = p_effective_date',864);
1490: --if P_DATETRACK_UPDATE_MODE = 'CORRECTION' then
1491: pay_ie_paye_api.update_ie_paye_details
1492: (p_validate => FALSE
1493: ,p_effective_date => p_effective_date

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

1552: else --c_effective_paye_fetch.effective_start_date <> p_effective_date
1553: -- should always be update with new credits and cutoffs
1554: if P_DATETRACK_UPDATE_MODE = 'CORRECTION' then
1555: -- check with asg start date
1556: hr_utility.set_location('Correction and <> TU',865);
1557: if (l_asg_effective_start_date <= c_effective_paye_fetch.effective_start_date ) then
1558: pay_ie_paye_api.update_ie_paye_details
1559: (p_validate => FALSE
1560: ,p_effective_date => p_effective_date

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

1616: ,p_usc_info_source => c_effective_paye_fetch.usc_info_source
1617: --13359423
1618: );
1619: else -- asg start date > paye start date then update using asg start date
1620: hr_utility.set_location('Correction and <> TU',865);
1621: pay_ie_paye_api.update_ie_paye_details
1622: (p_validate => FALSE
1623: ,p_effective_date => l_asg_effective_start_date
1624: ,p_datetrack_update_mode => 'UPDATE'

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

1680: --13359423
1681: );
1682: end if; -- end of check with asg start date
1683: else -- P_DATETRACK_UPDATE_MODE <> 'CORRECTION'
1684: hr_utility.set_location('UPDATE and = TU',866);
1685: pay_ie_paye_api.update_ie_paye_details
1686: (p_validate => FALSE
1687: ,p_effective_date => p_effective_date
1688: ,p_datetrack_update_mode => 'UPDATE'

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

1743: ,p_usc_info_source => decode_value_char(p_tax_upload_flag='X',c_effective_paye_fetch.usc_info_source,p_usc_info_source)
1744: --13359423
1745: );
1746: end if; --P_DATETRACK_UPDATE_MODE = 'CORRECTION'
1747: hr_utility.set_location('After datetrack check',867);
1748: end if; -- c_effective_paye_fetch.effective_start_date = p_effective_date
1749: else -- not found
1750: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1751: --the effective date.this record should be extended upto 4712

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

1748: end if; -- c_effective_paye_fetch.effective_start_date = p_effective_date
1749: else -- not found
1750: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1751: --the effective date.this record should be extended upto 4712
1752: hr_utility.set_location('Effective date does not lie between paye start and end date',868);
1753: if p_tax_upload_flag <> 'TU' then --4878630
1754: hr_utility.set_location('<> TU',869);
1755: open c_future_paye(null);
1756: fetch c_future_paye into c_future_paye_fetch ;

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

1750: --get the first record as of effective date.This is becasue there mare reocrds only afte the effective date.Nothing as of
1751: --the effective date.this record should be extended upto 4712
1752: hr_utility.set_location('Effective date does not lie between paye start and end date',868);
1753: if p_tax_upload_flag <> 'TU' then --4878630
1754: hr_utility.set_location('<> TU',869);
1755: open c_future_paye(null);
1756: fetch c_future_paye into c_future_paye_fetch ;
1757: l_min_paye_id := c_future_paye_fetch.paye_details_id ;
1758: l_min_effective_date := c_future_paye_fetch.effective_start_date;

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

1803: l_usc_info_source := c_future_paye_fetch.usc_info_source;
1804: --13359423
1805: close c_future_paye;
1806: else --4878630
1807: hr_utility.set_location('= TU',870);
1808: open c_tax_effective_paye(null,p_effective_date);
1809: fetch c_tax_effective_paye into c_tax_upload_paye;
1810: l_max_paye_id := c_tax_upload_paye.paye_details_id;
1811: l_max_effective_start_date := c_tax_upload_paye.effective_start_date;

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

1813: l_api_ovn := c_tax_upload_paye.object_version_number;
1814: l_info_source := c_tax_upload_paye.info_source;
1815: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1816: CLOSE c_tax_effective_paye;
1817: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1818: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1819: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1820: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1821: hr_utility.set_location('l_info_source.'|| l_info_source,875);

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

1814: l_info_source := c_tax_upload_paye.info_source;
1815: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1816: CLOSE c_tax_effective_paye;
1817: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1818: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1819: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1820: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1821: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1822:

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

1815: --l_tax_assess_basis := c_tax_upload_paye.tax_assess_basis;
1816: CLOSE c_tax_effective_paye;
1817: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1818: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1819: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1820: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1821: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1822:
1823: end if;

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

1816: CLOSE c_tax_effective_paye;
1817: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1818: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1819: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1820: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1821: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1822:
1823: end if;
1824: IF p_tax_upload_flag <> 'TU' then

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

1817: hr_utility.set_location('l_max_paye_id..'|| l_max_paye_id,871);
1818: hr_utility.set_location('l_max_effective_start_date.'|| l_max_effective_start_date,872);
1819: hr_utility.set_location('l_futrec_effective_end_date '|| l_futrec_effective_end_date,873);
1820: hr_utility.set_location('l_api_ovn '|| l_api_ovn,874);
1821: hr_utility.set_location('l_info_source.'|| l_info_source,875);
1822:
1823: end if;
1824: IF p_tax_upload_flag <> 'TU' then
1825: --delete any other future records ie different paye_details_id

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

1926: );
1927: END IF;-- futrec is null
1928: ELSE -- p_tax_upload_flag = 'TU'
1929: --delete any other future records ie different paye_details_id
1930: hr_utility.set_location('else of future paye.'|| l_info_source,876);
1931: open c_tax_effective_paye(l_max_paye_id,l_max_effective_start_date);
1932: loop
1933: fetch c_tax_effective_paye into c_tax_upload_paye;
1934: EXIT when c_tax_effective_paye%NOTFOUND;

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

1931: open c_tax_effective_paye(l_max_paye_id,l_max_effective_start_date);
1932: loop
1933: fetch c_tax_effective_paye into c_tax_upload_paye;
1934: EXIT when c_tax_effective_paye%NOTFOUND;
1935: hr_utility.set_location('In loop',878);
1936: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1937: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1938:
1939: pay_ie_paye_api.delete_ie_paye_details

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

1932: loop
1933: fetch c_tax_effective_paye into c_tax_upload_paye;
1934: EXIT when c_tax_effective_paye%NOTFOUND;
1935: hr_utility.set_location('In loop',878);
1936: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1937: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1938:
1939: pay_ie_paye_api.delete_ie_paye_details
1940: (p_validate => FALSE

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

1933: fetch c_tax_effective_paye into c_tax_upload_paye;
1934: EXIT when c_tax_effective_paye%NOTFOUND;
1935: hr_utility.set_location('In loop',878);
1936: hr_utility.set_location('c_tax_upload_paye.effective_start_date '|| c_tax_upload_paye.effective_start_date ,879);
1937: hr_utility.set_location('c_tax_upload_paye.paye_details_id.'||c_tax_upload_paye.paye_details_id,880);
1938:
1939: pay_ie_paye_api.delete_ie_paye_details
1940: (p_validate => FALSE
1941: ,p_effective_date => c_tax_upload_paye.effective_start_date

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

1945: ,p_effective_start_date => l_start_date
1946: ,p_effective_end_date => l_end_date
1947: );
1948: end loop;
1949: hr_utility.set_location('else of future paye After ZAping',881);
1950: close c_tax_effective_paye;
1951:
1952: hr_utility.set_location('l_futrec_effective_end_date..'|| l_futrec_effective_end_date,879);
1953: if l_futrec_effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')

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

1948: end loop;
1949: hr_utility.set_location('else of future paye After ZAping',881);
1950: close c_tax_effective_paye;
1951:
1952: hr_utility.set_location('l_futrec_effective_end_date..'|| l_futrec_effective_end_date,879);
1953: if l_futrec_effective_end_date <> to_date('31-12-4712','DD-MM-YYYY')
1954: AND (l_futrec_effective_end_date IS NOT NULL)
1955: then
1956: --extend the first record after the effective date till 4712

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

1966: end if;
1967:
1968: --only mode possible should be correction, using the new credits and cutoffs
1969: IF (l_futrec_effective_end_date IS NOT NULL) THEN
1970: hr_utility.set_location('The last Mode',880);
1971: pay_ie_paye_api.update_ie_paye_details
1972: (p_validate => FALSE
1973: ,p_effective_date => l_max_effective_start_date
1974: ,p_datetrack_update_mode => 'CORRECTION'

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

2028: ,p_usc_tax_basis => p_usc_tax_basis
2029: ,p_usc_info_source => p_usc_info_source
2030: --13359423
2031: );
2032: hr_utility.set_location('After The last Mode',881);
2033: END IF;-- futrec is null
2034:
2035: END If; -- p_tax_upload_flag <> 'TU'
2036: end if; --if c_effective_paye%found

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

2097: AND p_date_earned BETWEEN paf.effective_start_date AND paf.effective_end_date;
2098: --
2099: BEGIN
2100: --
2101: -- hr_utility.set_location('Entering:'|| l_proc, 5);
2102:
2103: --
2104: /*OPEN get_period_dates;
2105: FETCH get_period_dates INTO l_period_start_date,l_period_end_date;

Line 2115: hr_utility.set_location('- Name = '|| v_last_name, 5);

2111: OPEN get_dob;
2112: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
2113: CLOSE get_dob;
2114:
2115: hr_utility.set_location('- Name = '|| v_last_name, 5);
2116: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
2117:
2118: RETURN(TRUNC(MONTHS_BETWEEN(l_last_day_of_year,l_dob)/12));
2119:

Line 2116: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);

2112: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
2113: CLOSE get_dob;
2114:
2115: hr_utility.set_location('- Name = '|| v_last_name, 5);
2116: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
2117:
2118: RETURN(TRUNC(MONTHS_BETWEEN(l_last_day_of_year,l_dob)/12));
2119:
2120: /*l_age_last_day_month := TRUNC(MONTHS_BETWEEN(last_day(p_date_earned),l_dob)/12);

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

2162: AND l_date_paid BETWEEN paf.effective_start_date AND paf.effective_end_date;
2163: --
2164: BEGIN
2165: --
2166: -- hr_utility.set_location('Entering:'|| l_proc, 5);
2167:
2168: --
2169: OPEN get_period_dates;
2170: FETCH get_period_dates INTO l_date_paid;

Line 2180: hr_utility.set_location('- Name = '|| v_last_name, 5);

2176: OPEN get_dob;
2177: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
2178: CLOSE get_dob;
2179:
2180: hr_utility.set_location('- Name = '|| v_last_name, 5);
2181: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
2182:
2183: RETURN(TRUNC(MONTHS_BETWEEN(l_last_day_of_year,l_dob)/12));
2184:

Line 2181: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);

2177: FETCH get_dob INTO l_dob,v_last_name,v_asg_number;
2178: CLOSE get_dob;
2179:
2180: hr_utility.set_location('- Name = '|| v_last_name, 5);
2181: hr_utility.set_location('- Asg No = '|| v_asg_number, 5);
2182:
2183: RETURN(TRUNC(MONTHS_BETWEEN(l_last_day_of_year,l_dob)/12));
2184:
2185: /*l_age_last_day_month := TRUNC(MONTHS_BETWEEN(last_day(p_date_earned),l_dob)/12);

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

2257: l_proc varchar2(72) := g_package||'get_last_period';
2258:
2259: BEGIN
2260:
2261: hr_utility.set_location('Entering:'||l_proc, 35);
2262:
2263: open c_last_pay_period;
2264: fetch c_last_pay_period into p_last_period_num;
2265: close c_last_pay_period;

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

2267: if p_period_type = 'Bi-Week' then
2268: p_last_period_num := p_last_period_num * 2;
2269: end if;
2270:
2271: hr_utility.set_location('Leaving:'||l_proc, 50);
2272: FND_FILE.PUT_LINE(FND_FILE.LOG, 'p_last_period_num ' || p_last_period_num);
2273: RETURN 1;
2274:
2275: exception when others then