eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_GB_P11D_MILEAGE_EXTRACT dependencies on HR_UTILITY

Line 87: hr_utility.set_location('get_param_tax_year',1);

83: --
84: BEGIN
85:
86: BEGIN
87: hr_utility.set_location('get_param_tax_year',1);
88:
89: l_tax_year := hruserdt.get_table_value(p_bus_grp_id,
90: 'PAY GB P11D Mileage Extract',
91: 'Parameter Value',

Line 101: hr_utility.set_location('get_param_tax_year',2);

97:
98: WHEN others THEN
99: -- tax year parameter not set or wrong format
100: -- raise an error
101: hr_utility.set_location('get_param_tax_year',2);
102: hr_utility.trace('ERROR: Seeded value for tax year not found or data corrupt');
103: raise;
104:
105: END;

Line 102: hr_utility.trace('ERROR: Seeded value for tax year not found or data corrupt');

98: WHEN others THEN
99: -- tax year parameter not set or wrong format
100: -- raise an error
101: hr_utility.set_location('get_param_tax_year',2);
102: hr_utility.trace('ERROR: Seeded value for tax year not found or data corrupt');
103: raise;
104:
105: END;
106: --

Line 107: hr_utility.set_location('get_param_tax_year',3);

103: raise;
104:
105: END;
106: --
107: hr_utility.set_location('get_param_tax_year',3);
108:
109: hr_utility.trace('Tax year: '||to_char(l_tax_year));
110: hr_utility.set_location('get_param_tax_year',99);
111:

Line 109: hr_utility.trace('Tax year: '||to_char(l_tax_year));

105: END;
106: --
107: hr_utility.set_location('get_param_tax_year',3);
108:
109: hr_utility.trace('Tax year: '||to_char(l_tax_year));
110: hr_utility.set_location('get_param_tax_year',99);
111:
112: RETURN l_tax_year;
113:

Line 110: hr_utility.set_location('get_param_tax_year',99);

106: --
107: hr_utility.set_location('get_param_tax_year',3);
108:
109: hr_utility.trace('Tax year: '||to_char(l_tax_year));
110: hr_utility.set_location('get_param_tax_year',99);
111:
112: RETURN l_tax_year;
113:
114: end get_param_tax_year;

Line 133: hr_utility.set_location('get_tax_year_start',1);

129: l_cal_year_start date;
130: --
131: BEGIN
132:
133: hr_utility.set_location('get_tax_year_start',1);
134:
135: l_tax_year := get_param_tax_year(p_bus_grp_id);
136:
137: hr_utility.set_location('get_tax_year_start',2);

Line 137: hr_utility.set_location('get_tax_year_start',2);

133: hr_utility.set_location('get_tax_year_start',1);
134:
135: l_tax_year := get_param_tax_year(p_bus_grp_id);
136:
137: hr_utility.set_location('get_tax_year_start',2);
138:
139: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
140:
141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));

Line 143: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));

139: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
140:
141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
142:
143: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
144: hr_utility.set_location('get_tax_year_start',99);
145:
146: RETURN l_tax_year_start;
147:

Line 144: hr_utility.set_location('get_tax_year_start',99);

140:
141: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
142:
143: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
144: hr_utility.set_location('get_tax_year_start',99);
145:
146: RETURN l_tax_year_start;
147:
148: end get_tax_year_start;

Line 167: hr_utility.set_location('get_tax_year_end',1);

163: l_cal_year_start date;
164: --
165: BEGIN
166:
167: hr_utility.set_location('get_tax_year_end',1);
168:
169: l_tax_year := get_param_tax_year(p_bus_grp_id);
170: --
171: hr_utility.set_location('get_tax_year_end',2);

Line 171: hr_utility.set_location('get_tax_year_end',2);

167: hr_utility.set_location('get_tax_year_end',1);
168:
169: l_tax_year := get_param_tax_year(p_bus_grp_id);
170: --
171: hr_utility.set_location('get_tax_year_end',2);
172:
173: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
174:
175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));

Line 177: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));

173: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
174:
175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
176:
177: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
178: hr_utility.set_location('get_tax_year_end',99);
179:
180: RETURN l_tax_year_end;
181:

Line 178: hr_utility.set_location('get_tax_year_end',99);

174:
175: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
176:
177: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
178: hr_utility.set_location('get_tax_year_end',99);
179:
180: RETURN l_tax_year_end;
181:
182: end get_tax_year_end;

Line 196: hr_utility.set_location('get_param_ext_end_date',1);

192: --
193: BEGIN
194:
195: BEGIN
196: hr_utility.set_location('get_param_ext_end_date',1);
197:
198: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
199: 'PAY GB P11D Mileage Extract',
200: 'Parameter Value',

Line 212: hr_utility.set_location('get_param_ext_end_date',2);

208:
209: WHEN others THEN
210: -- extract date parameter not set or wrong format
211: -- default to end of fiscal year
212: hr_utility.set_location('get_param_ext_end_date',2);
213:
214: l_ext_end_date := get_tax_year_end(p_bus_group_id);
215:
216: END;

Line 218: hr_utility.set_location('get_param_ext_end_date',99);

214: l_ext_end_date := get_tax_year_end(p_bus_group_id);
215:
216: END;
217: --
218: hr_utility.set_location('get_param_ext_end_date',99);
219:
220: RETURN l_ext_end_date;
221:
222: END get_param_ext_end_date;

Line 480: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);

476:
477: --
478: BEGIN
479:
480: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);
481:
482: -- Get Business Group Id
483: l_bus_group_id := get_bus_group_id(p_assignment_id);
484:

Line 496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));

492: l_ext_asg_set_id := get_param_assignment_set_id(l_bus_group_id);
493:
494: --
495:
496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));

Line 497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));

493:
494: --
495:
496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
501:

Line 498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);

494: --
495:
496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
501:
502: --

Line 499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));

495:
496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
501:
502: --
503: -- Get details of primary assignment

Line 500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));

496: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
497: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
498: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
499: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
500: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
501:
502: --
503: -- Get details of primary assignment
504: -- Start with effective dates

Line 509: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));

505: OPEN get_asg_eff_dates(p_assignment_id);
506: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
507: CLOSE get_asg_eff_dates;
508: --
509: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
510: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
511: --
512:
513: IF l_min_start_date > l_ext_end_date OR l_max_end_date < get_tax_year_start(l_bus_group_id) THEN

Line 510: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));

506: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
507: CLOSE get_asg_eff_dates;
508: --
509: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
510: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
511: --
512:
513: IF l_min_start_date > l_ext_end_date OR l_max_end_date < get_tax_year_start(l_bus_group_id) THEN
514: -- Person not active within input date range therefore exclude

Line 530: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);

526: l_asg_set_include := 'Y'; -- no input asg set specified
527: END IF;
528:
529: --
530: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);
531:
532: -- Loop through all changes in the assignment during the input date range
533: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
534: --

Line 535: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);

531:
532: -- Loop through all changes in the assignment during the input date range
533: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
534: --
535: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
536: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
537: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
538: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
539: --

Line 536: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);

532: -- Loop through all changes in the assignment during the input date range
533: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
534: --
535: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
536: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
537: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
538: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
539: --
540: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)

Line 537: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);

533: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
534: --
535: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
536: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
537: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
538: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
539: --
540: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
541: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)

Line 538: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);

534: --
535: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
536: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
537: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
538: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
539: --
540: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
541: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)
542: AND nvl(l_ext_tax_dist, nvl(asg_det_rec.tax_dist, 'ZZZ')) = nvl(asg_det_rec.tax_dist, 'ZZZ')

Line 559: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);

555:
556: end if;
557:
558: --
559: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);
560: END IF;
561: END LOOP;
562:
563: --

Line 564: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);

560: END IF;
561: END LOOP;
562:
563: --
564: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);
565:
566: RETURN l_asg_include;
567: --
568: END check_asg_inclusion;

Line 598: hr_utility.set_location('get_latest_asg_act_ext',1);

594: and p_ext_end_date;
595:
596: begin
597:
598: hr_utility.set_location('get_latest_asg_act_ext',1);
599:
600: open csr_latest_asg_act_id;
601: fetch csr_latest_asg_act_id into l_asg_act_id;
602: close csr_latest_asg_act_id;

Line 604: hr_utility.trace('Asg act id: '||l_asg_act_id);

600: open csr_latest_asg_act_id;
601: fetch csr_latest_asg_act_id into l_asg_act_id;
602: close csr_latest_asg_act_id;
603:
604: hr_utility.trace('Asg act id: '||l_asg_act_id);
605: hr_utility.set_location('get_latest_asg_act_ext',99);
606:
607: return l_asg_act_id;
608:

Line 605: hr_utility.set_location('get_latest_asg_act_ext',99);

601: fetch csr_latest_asg_act_id into l_asg_act_id;
602: close csr_latest_asg_act_id;
603:
604: hr_utility.trace('Asg act id: '||l_asg_act_id);
605: hr_utility.set_location('get_latest_asg_act_ext',99);
606:
607: return l_asg_act_id;
608:
609: exception

Line 612: hr_utility.set_location('get_latest_asg_act_ext',999);

608:
609: exception
610:
611: when others then
612: hr_utility.set_location('get_latest_asg_act_ext',999);
613: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
614: raise;
615:
616: end get_latest_asg_act_ext;

Line 613: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

609: exception
610:
611: when others then
612: hr_utility.set_location('get_latest_asg_act_ext',999);
613: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
614: raise;
615:
616: end get_latest_asg_act_ext;
617:

Line 646: hr_utility.set_location('get_latest_asg_act_tye',1);

642: and p_tax_year_end_date;
643:
644: begin
645:
646: hr_utility.set_location('get_latest_asg_act_tye',1);
647:
648: open csr_latest_asg_act_id;
649: fetch csr_latest_asg_act_id into l_asg_act_id;
650: close csr_latest_asg_act_id;

Line 652: hr_utility.trace('Asg act id: '||l_asg_act_id);

648: open csr_latest_asg_act_id;
649: fetch csr_latest_asg_act_id into l_asg_act_id;
650: close csr_latest_asg_act_id;
651:
652: hr_utility.trace('Asg act id: '||l_asg_act_id);
653: hr_utility.set_location('get_latest_asg_act_tye',99);
654:
655: return l_asg_act_id;
656:

Line 653: hr_utility.set_location('get_latest_asg_act_tye',99);

649: fetch csr_latest_asg_act_id into l_asg_act_id;
650: close csr_latest_asg_act_id;
651:
652: hr_utility.trace('Asg act id: '||l_asg_act_id);
653: hr_utility.set_location('get_latest_asg_act_tye',99);
654:
655: return l_asg_act_id;
656:
657: exception

Line 660: hr_utility.set_location('get_latest_asg_act_tye',999);

656:
657: exception
658:
659: when others then
660: hr_utility.set_location('get_latest_asg_act_tye',999);
661: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
662: raise;
663:
664: end get_latest_asg_act_tye;

Line 661: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

657: exception
658:
659: when others then
660: hr_utility.set_location('get_latest_asg_act_tye',999);
661: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
662: raise;
663:
664: end get_latest_asg_act_tye;
665:

Line 677: hr_utility.set_location('check_odd_even_year',1);

673: l_odd_even_marker varchar2(5);
674:
675: begin
676:
677: hr_utility.set_location('check_odd_even_year',1);
678:
679: hr_utility.trace('Tax Year End Date: '||p_tax_year_end_date);
680:
681: if mod(to_number(to_char(p_tax_year_end_date,'YYYY')),2) = 0

Line 679: hr_utility.trace('Tax Year End Date: '||p_tax_year_end_date);

675: begin
676:
677: hr_utility.set_location('check_odd_even_year',1);
678:
679: hr_utility.trace('Tax Year End Date: '||p_tax_year_end_date);
680:
681: if mod(to_number(to_char(p_tax_year_end_date,'YYYY')),2) = 0
682: then
683:

Line 692: hr_utility.set_location('check_odd_even_year',99);

688: l_odd_even_marker := 'ODD';
689:
690: end if;
691:
692: hr_utility.set_location('check_odd_even_year',99);
693: return l_odd_even_marker;
694:
695: end check_odd_even_year;
696: ---------------------------------------------------------------------------

Line 720: hr_utility.set_location('ben_start_date',1);

716: and paf.assignment_id = p_assignment_id;
717:
718: begin
719:
720: hr_utility.set_location('ben_start_date',1);
721:
722: l_bus_group_id := get_bus_group_id(p_assignment_id);
723: l_tax_year_start := get_tax_year_start(l_bus_group_id);
724:

Line 725: hr_utility.set_location('ben_start_date',2);

721:
722: l_bus_group_id := get_bus_group_id(p_assignment_id);
723: l_tax_year_start := get_tax_year_start(l_bus_group_id);
724:
725: hr_utility.set_location('ben_start_date',2);
726:
727: open csr_ben_start_date;
728: fetch csr_ben_start_date into l_ben_start_date;
729: close csr_ben_start_date;

Line 731: hr_utility.trace('Benefit start date: '||to_char(l_ben_start_date,'DD-MON-YYYY'));

727: open csr_ben_start_date;
728: fetch csr_ben_start_date into l_ben_start_date;
729: close csr_ben_start_date;
730:
731: hr_utility.trace('Benefit start date: '||to_char(l_ben_start_date,'DD-MON-YYYY'));
732: hr_utility.set_location('ben_start_date',99);
733:
734: return to_char(l_ben_start_date,'DD-MON-YYYY');
735:

Line 732: hr_utility.set_location('ben_start_date',99);

728: fetch csr_ben_start_date into l_ben_start_date;
729: close csr_ben_start_date;
730:
731: hr_utility.trace('Benefit start date: '||to_char(l_ben_start_date,'DD-MON-YYYY'));
732: hr_utility.set_location('ben_start_date',99);
733:
734: return to_char(l_ben_start_date,'DD-MON-YYYY');
735:
736: exception

Line 739: hr_utility.set_location('ben_start_date',999);

735:
736: exception
737:
738: when others then
739: hr_utility.set_location('ben_start_date',999);
740: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
741: raise;
742:
743: end ben_start_date;

Line 740: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

736: exception
737:
738: when others then
739: hr_utility.set_location('ben_start_date',999);
740: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
741: raise;
742:
743: end ben_start_date;
744:

Line 767: hr_utility.set_location('ben_end_date',1);

763: and paf.assignment_id = p_assignment_id;
764:
765: begin
766:
767: hr_utility.set_location('ben_end_date',1);
768:
769: l_bus_group_id := get_bus_group_id(p_assignment_id);
770: l_tax_year_end := get_tax_year_end(l_bus_group_id);
771:

Line 772: hr_utility.set_location('ben_end_date',2);

768:
769: l_bus_group_id := get_bus_group_id(p_assignment_id);
770: l_tax_year_end := get_tax_year_end(l_bus_group_id);
771:
772: hr_utility.set_location('ben_end_date',2);
773:
774: open csr_ben_end_date;
775: fetch csr_ben_end_date into l_ben_end_date;
776: close csr_ben_end_date;

Line 778: hr_utility.trace('Benefit end date: '||to_char(l_ben_end_date,'DD-MON-YYYY'));

774: open csr_ben_end_date;
775: fetch csr_ben_end_date into l_ben_end_date;
776: close csr_ben_end_date;
777:
778: hr_utility.trace('Benefit end date: '||to_char(l_ben_end_date,'DD-MON-YYYY'));
779: hr_utility.set_location('ben_end_date',99);
780:
781: return to_char(l_ben_end_date,'DD-MON-YYYY');
782:

Line 779: hr_utility.set_location('ben_end_date',99);

775: fetch csr_ben_end_date into l_ben_end_date;
776: close csr_ben_end_date;
777:
778: hr_utility.trace('Benefit end date: '||to_char(l_ben_end_date,'DD-MON-YYYY'));
779: hr_utility.set_location('ben_end_date',99);
780:
781: return to_char(l_ben_end_date,'DD-MON-YYYY');
782:
783: exception

Line 786: hr_utility.set_location('ben_end_date',999);

782:
783: exception
784:
785: when others then
786: hr_utility.set_location('ben_end_date',999);
787: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
788: raise;
789:
790: end ben_end_date;

Line 787: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

783: exception
784:
785: when others then
786: hr_utility.set_location('ben_end_date',999);
787: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
788: raise;
789:
790: end ben_end_date;
791:

Line 810: hr_utility.set_location('asg_start_date',1);

806: where paf.assignment_id = p_assignment_id;
807:
808: begin
809:
810: hr_utility.set_location('asg_start_date',1);
811:
812: l_bus_group_id := get_bus_group_id(p_assignment_id);
813: l_tax_year_start := get_tax_year_start(l_bus_group_id);
814:

Line 815: hr_utility.set_location('asg_start_date',2);

811:
812: l_bus_group_id := get_bus_group_id(p_assignment_id);
813: l_tax_year_start := get_tax_year_start(l_bus_group_id);
814:
815: hr_utility.set_location('asg_start_date',2);
816:
817: open csr_asg_start_date;
818: fetch csr_asg_start_date into l_asg_start_date;
819: close csr_asg_start_date;

Line 821: hr_utility.trace('Asg start date: '||to_char(l_asg_start_date,'DD-MON-YYYY'));

817: open csr_asg_start_date;
818: fetch csr_asg_start_date into l_asg_start_date;
819: close csr_asg_start_date;
820:
821: hr_utility.trace('Asg start date: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
822: hr_utility.set_location('asg_start_date',99);
823:
824: return to_char(l_asg_start_date,'DD-MON-YYYY');
825:

Line 822: hr_utility.set_location('asg_start_date',99);

818: fetch csr_asg_start_date into l_asg_start_date;
819: close csr_asg_start_date;
820:
821: hr_utility.trace('Asg start date: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
822: hr_utility.set_location('asg_start_date',99);
823:
824: return to_char(l_asg_start_date,'DD-MON-YYYY');
825:
826: exception

Line 829: hr_utility.set_location('asg_start_date',999);

825:
826: exception
827:
828: when others then
829: hr_utility.set_location('asg_start_date',999);
830: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
831: raise;
832:
833: end asg_start_date;

Line 830: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

826: exception
827:
828: when others then
829: hr_utility.set_location('asg_start_date',999);
830: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
831: raise;
832:
833: end asg_start_date;
834:

Line 857: hr_utility.set_location('asg_end_date',1);

853: and paf.assignment_status_type_id = past.assignment_status_type_id;
854:
855: begin
856:
857: hr_utility.set_location('asg_end_date',1);
858:
859: l_bus_group_id := get_bus_group_id(p_assignment_id);
860: l_tax_year_end := get_tax_year_end(l_bus_group_id);
861:

Line 862: hr_utility.set_location('asg_end_date',2);

858:
859: l_bus_group_id := get_bus_group_id(p_assignment_id);
860: l_tax_year_end := get_tax_year_end(l_bus_group_id);
861:
862: hr_utility.set_location('asg_end_date',2);
863:
864: open csr_asg_end_date;
865: fetch csr_asg_end_date into l_asg_end_date;
866: close csr_asg_end_date;

Line 868: hr_utility.trace('Asg end date: '||to_char(l_asg_end_date,'DD-MON-YYYY'));

864: open csr_asg_end_date;
865: fetch csr_asg_end_date into l_asg_end_date;
866: close csr_asg_end_date;
867:
868: hr_utility.trace('Asg end date: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
869: hr_utility.set_location('asg_end_date',99);
870:
871: return to_char(l_asg_end_date,'DD-MON-YYYY');
872:

Line 869: hr_utility.set_location('asg_end_date',99);

865: fetch csr_asg_end_date into l_asg_end_date;
866: close csr_asg_end_date;
867:
868: hr_utility.trace('Asg end date: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
869: hr_utility.set_location('asg_end_date',99);
870:
871: return to_char(l_asg_end_date,'DD-MON-YYYY');
872:
873: exception

Line 876: hr_utility.set_location('asg_end_date',999);

872:
873: exception
874:
875: when others then
876: hr_utility.set_location('asg_end_date',999);
877: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
878: raise;
879:
880: end asg_end_date;

Line 877: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

873: exception
874:
875: when others then
876: hr_utility.set_location('asg_end_date',999);
877: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
878: raise;
879:
880: end asg_end_date;
881:

Line 931: hr_utility.set_location('mileage_balance',1);

927: l_balance_amt number;
928:
929: begin
930:
931: hr_utility.set_location('mileage_balance',1);
932:
933: -- get necessary data
934:
935: l_bus_group_id := get_bus_group_id(p_assignment_id);

Line 937: hr_utility.set_location('mileage_balance',2);

933: -- get necessary data
934:
935: l_bus_group_id := get_bus_group_id(p_assignment_id);
936:
937: hr_utility.set_location('mileage_balance',2);
938:
939: l_tax_year_end := get_tax_year_end(l_bus_group_id);
940:
941: hr_utility.set_location('mileage_balance',3);

Line 941: hr_utility.set_location('mileage_balance',3);

937: hr_utility.set_location('mileage_balance',2);
938:
939: l_tax_year_end := get_tax_year_end(l_bus_group_id);
940:
941: hr_utility.set_location('mileage_balance',3);
942:
943:
944: -- check whether year in which tax year end date falls is odd or even
945:

Line 950: hr_utility.set_location('mileage_balance',4);

946: l_odd_even_marker := check_odd_even_year(l_tax_year_end);
947:
948: -- retrieve appropriate odd/even defined balance id for Mileage Taxable Amt
949: -- based on odd/even marker
950: hr_utility.set_location('mileage_balance',4);
951:
952: if l_odd_even_marker = 'ODD'
953: then
954:

Line 967: hr_utility.set_location('mileage_balance',5);

963: close csr_get_even_def_bal_id;
964:
965: end if;
966:
967: hr_utility.set_location('mileage_balance',5);
968:
969: -- get params to pass to get_latest_asg_act
970:
971: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);

Line 973: hr_utility.set_location('mileage_balance',6);

969: -- get params to pass to get_latest_asg_act
970:
971: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
972:
973: hr_utility.set_location('mileage_balance',6);
974:
975: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
976:
977: hr_utility.set_location('mileage_balance',7);

Line 977: hr_utility.set_location('mileage_balance',7);

973: hr_utility.set_location('mileage_balance',6);
974:
975: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
976:
977: hr_utility.set_location('mileage_balance',7);
978:
979: -- fetch latest assignment action ids for that assignment as at TYE and
980: -- extract end date (or closest asg action to either)
981:

Line 992: hr_utility.set_location('mileage_balance',8);

988: p_ben_start_date => l_ben_start_date);
989:
990: -- now get ASG_YTD balances for that assignment, using defined balance id
991: -- and latest assignment actions just obtained
992: hr_utility.set_location('mileage_balance',8);
993:
994: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
995: p_assignment_action_id => l_asg_act_id_ext);
996:

Line 1000: hr_utility.trace('l_ext_balance: '||l_ext_balance);

996:
997: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
998: p_assignment_action_id => l_asg_act_id_tye);
999:
1000: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1001: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1002:
1003: if l_tye_balance <> l_ext_balance
1004: -- e.g. if user has processed back-dated mileage claims after TYE so balance

Line 1001: hr_utility.trace('l_tye_balance: '||l_tye_balance);

997: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
998: p_assignment_action_id => l_asg_act_id_tye);
999:
1000: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1001: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1002:
1003: if l_tye_balance <> l_ext_balance
1004: -- e.g. if user has processed back-dated mileage claims after TYE so balance
1005: -- as of extract end date is greater

Line 1017: hr_utility.set_location('mileage_balance',9);

1013: l_balance_amt := l_tye_balance;
1014:
1015: end if;
1016:
1017: hr_utility.set_location('mileage_balance',9);
1018: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1019: hr_utility.trace('Assignment id: '||p_assignment_id);
1020:
1021: hr_utility.set_location('mileage_balance',99);

Line 1018: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);

1014:
1015: end if;
1016:
1017: hr_utility.set_location('mileage_balance',9);
1018: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1019: hr_utility.trace('Assignment id: '||p_assignment_id);
1020:
1021: hr_utility.set_location('mileage_balance',99);
1022:

Line 1019: hr_utility.trace('Assignment id: '||p_assignment_id);

1015: end if;
1016:
1017: hr_utility.set_location('mileage_balance',9);
1018: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1019: hr_utility.trace('Assignment id: '||p_assignment_id);
1020:
1021: hr_utility.set_location('mileage_balance',99);
1022:
1023: return to_char(l_balance_amt);

Line 1021: hr_utility.set_location('mileage_balance',99);

1017: hr_utility.set_location('mileage_balance',9);
1018: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1019: hr_utility.trace('Assignment id: '||p_assignment_id);
1020:
1021: hr_utility.set_location('mileage_balance',99);
1022:
1023: return to_char(l_balance_amt);
1024:
1025: exception

Line 1028: hr_utility.set_location('mileage_balance',999);

1024:
1025: exception
1026:
1027: when others then
1028: hr_utility.set_location('mileage_balance',999);
1029: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1030: raise;
1031:
1032: end mileage_balance;

Line 1029: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

1025: exception
1026:
1027: when others then
1028: hr_utility.set_location('mileage_balance',999);
1029: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1030: raise;
1031:
1032: end mileage_balance;
1033:

Line 1083: hr_utility.set_location('add_pass_balance',1);

1079: l_balance_amt number;
1080:
1081: begin
1082:
1083: hr_utility.set_location('add_pass_balance',1);
1084:
1085: -- get necessary data
1086:
1087: l_bus_group_id := get_bus_group_id(p_assignment_id);

Line 1089: hr_utility.set_location('add_pass_balance',2);

1085: -- get necessary data
1086:
1087: l_bus_group_id := get_bus_group_id(p_assignment_id);
1088:
1089: hr_utility.set_location('add_pass_balance',2);
1090:
1091: l_tax_year_end := get_tax_year_end(l_bus_group_id);
1092:
1093: hr_utility.set_location('add_pass_balance',3);

Line 1093: hr_utility.set_location('add_pass_balance',3);

1089: hr_utility.set_location('add_pass_balance',2);
1090:
1091: l_tax_year_end := get_tax_year_end(l_bus_group_id);
1092:
1093: hr_utility.set_location('add_pass_balance',3);
1094:
1095: -- check whether year in which tax year end date falls is odd or even
1096:
1097: l_odd_even_marker := check_odd_even_year(l_tax_year_end);

Line 1101: hr_utility.set_location('add_pass_balance',4);

1097: l_odd_even_marker := check_odd_even_year(l_tax_year_end);
1098:
1099: -- retrieve appropriate odd/even defined balance id for Mileage Taxable Amt
1100: -- based on odd/even marker
1101: hr_utility.set_location('add_pass_balance',4);
1102:
1103: if l_odd_even_marker = 'ODD'
1104: then
1105:

Line 1118: hr_utility.set_location('add_pass_balance',5);

1114: close csr_get_even_def_bal_id;
1115:
1116: end if;
1117:
1118: hr_utility.set_location('add_pass_balance',5);
1119:
1120: -- get params to pass to get_latest_asg_act
1121:
1122: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);

Line 1124: hr_utility.set_location('add_pass_balance',6);

1120: -- get params to pass to get_latest_asg_act
1121:
1122: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1123:
1124: hr_utility.set_location('add_pass_balance',6);
1125:
1126: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1127:
1128: hr_utility.set_location('add_pass_balance',7);

Line 1128: hr_utility.set_location('add_pass_balance',7);

1124: hr_utility.set_location('add_pass_balance',6);
1125:
1126: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1127:
1128: hr_utility.set_location('add_pass_balance',7);
1129:
1130: -- fetch latest assignment action ids for that assignment as at TYE and
1131: -- extract end date (or closest asg act to either)
1132:

Line 1143: hr_utility.set_location('add_pass_balance',8);

1139: p_ben_start_date => l_ben_start_date);
1140:
1141: -- now get ASG_YTD balances for that assignment, using defined balance id
1142: -- and latest assignment actions just obtained
1143: hr_utility.set_location('add_pass_balance',8);
1144:
1145: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1146: p_assignment_action_id => l_asg_act_id_ext);
1147:

Line 1151: hr_utility.trace('l_ext_balance: '||l_ext_balance);

1147:
1148: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1149: p_assignment_action_id => l_asg_act_id_tye);
1150:
1151: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1152: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1153:
1154: if l_tye_balance <> l_ext_balance
1155: -- e.g. if user has processed back-dated mileage claims after TYE so balance

Line 1152: hr_utility.trace('l_tye_balance: '||l_tye_balance);

1148: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1149: p_assignment_action_id => l_asg_act_id_tye);
1150:
1151: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1152: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1153:
1154: if l_tye_balance <> l_ext_balance
1155: -- e.g. if user has processed back-dated mileage claims after TYE so balance
1156: -- as of extract end date is greater

Line 1168: hr_utility.set_location('add_pass_balance',9);

1164: l_balance_amt := l_tye_balance;
1165:
1166: end if;
1167:
1168: hr_utility.set_location('add_pass_balance',9);
1169: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1170: hr_utility.trace('Assignment id: '||p_assignment_id);
1171:
1172: hr_utility.set_location('add_pass_balance',99);

Line 1169: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);

1165:
1166: end if;
1167:
1168: hr_utility.set_location('add_pass_balance',9);
1169: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1170: hr_utility.trace('Assignment id: '||p_assignment_id);
1171:
1172: hr_utility.set_location('add_pass_balance',99);
1173:

Line 1170: hr_utility.trace('Assignment id: '||p_assignment_id);

1166: end if;
1167:
1168: hr_utility.set_location('add_pass_balance',9);
1169: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1170: hr_utility.trace('Assignment id: '||p_assignment_id);
1171:
1172: hr_utility.set_location('add_pass_balance',99);
1173:
1174: return to_char(l_balance_amt);

Line 1172: hr_utility.set_location('add_pass_balance',99);

1168: hr_utility.set_location('add_pass_balance',9);
1169: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1170: hr_utility.trace('Assignment id: '||p_assignment_id);
1171:
1172: hr_utility.set_location('add_pass_balance',99);
1173:
1174: return to_char(l_balance_amt);
1175:
1176: exception

Line 1179: hr_utility.set_location('mileage_balance',999);

1175:
1176: exception
1177:
1178: when others then
1179: hr_utility.set_location('mileage_balance',999);
1180: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1181: raise;
1182:
1183: end add_pass_balance;

Line 1180: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

1176: exception
1177:
1178: when others then
1179: hr_utility.set_location('mileage_balance',999);
1180: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1181: raise;
1182:
1183: end add_pass_balance;
1184:

Line 1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);

1212: l_chk_exists chk_exists%ROWTYPE;
1213:
1214: BEGIN
1215:
1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);

Line 1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);

1213:
1214: BEGIN
1215:
1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);

Line 1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);

1214: BEGIN
1215:
1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);

Line 1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);

1215:
1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1223: --

Line 1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);

1216: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1223: --
1224: -- CHeck if record already exists

Line 1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);

1217: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1223: --
1224: -- CHeck if record already exists
1225: OPEN chk_exists;

Line 1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);

1218: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1219: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_mileage_balance='||p_mileage_balance);
1220: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_add_pass_balance='||p_add_pass_balance);
1221: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1222: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1223: --
1224: -- CHeck if record already exists
1225: OPEN chk_exists;
1226: FETCH chk_exists INTO l_chk_exists;

Line 1255: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);

1251: ,p_val_15 => '~~'
1252: ,p_val_16 => '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~'
1253: ,p_object_version_number => l_object_version_no);
1254:
1255: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);
1256:
1257:
1258: EXCEPTION WHEN others THEN
1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));

Line 1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));

1255: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);
1256:
1257:
1258: EXCEPTION WHEN others THEN
1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1260: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1261: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1262: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1263: RAISE;

Line 1260: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));

1256:
1257:
1258: EXCEPTION WHEN others THEN
1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1260: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1261: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1262: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1263: RAISE;
1264: END;

Line 1261: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));

1257:
1258: EXCEPTION WHEN others THEN
1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1260: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1261: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1262: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1263: RAISE;
1264: END;
1265: END IF;

Line 1262: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));

1258: EXCEPTION WHEN others THEN
1259: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1260: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1261: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1262: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1263: RAISE;
1264: END;
1265: END IF;
1266: --

Line 1298: hr_utility.set_location('process_sec_asg',1);

1294: l_asg_start_date varchar2(30);
1295: l_asg_end_date varchar2(30);
1296: --
1297: BEGIN
1298: hr_utility.set_location('process_sec_asg',1);
1299: hr_utility.trace('p_asg_id= '||p_asg_id);
1300: --
1301: -- Loop through all secondary assignments
1302: FOR sec_asg_rec IN csr_sec_asg LOOP

Line 1299: hr_utility.trace('p_asg_id= '||p_asg_id);

1295: l_asg_end_date varchar2(30);
1296: --
1297: BEGIN
1298: hr_utility.set_location('process_sec_asg',1);
1299: hr_utility.trace('p_asg_id= '||p_asg_id);
1300: --
1301: -- Loop through all secondary assignments
1302: FOR sec_asg_rec IN csr_sec_asg LOOP
1303: --

Line 1304: hr_utility.set_location('process_sec_asg',2);

1300: --
1301: -- Loop through all secondary assignments
1302: FOR sec_asg_rec IN csr_sec_asg LOOP
1303: --
1304: hr_utility.set_location('process_sec_asg',2);
1305: l_asg_include := 'N';
1306: l_asg_include := check_asg_inclusion(sec_asg_rec.assignment_id);
1307: --
1308: -- if assignment meets criteria and mileage balance for that assignment

Line 1314: hr_utility.set_location('process_sec_asg',3);

1310: -- detail record
1311: IF l_asg_include = 'Y' and to_number(mileage_balance(sec_asg_rec.assignment_id)) > 0
1312: THEN
1313:
1314: hr_utility.set_location('process_sec_asg',3);
1315:
1316: l_ben_start_date := ben_start_date(sec_asg_rec.assignment_id);
1317: l_ben_end_date := ben_end_date(sec_asg_rec.assignment_id);
1318: l_mileage_balance := mileage_balance(sec_asg_rec.assignment_id);

Line 1335: hr_utility.set_location('process_sec_asg',99);

1331: END IF;
1332:
1333: END LOOP;
1334: --
1335: hr_utility.set_location('process_sec_asg',99);
1336:
1337: exception
1338:
1339: when others then

Line 1341: hr_utility.set_location('process_sec_asg',999);

1337: exception
1338:
1339: when others then
1340:
1341: hr_utility.set_location('process_sec_asg',999);
1342: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1343: raise;
1344:
1345: END process_sec_asg;

Line 1342: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

1338:
1339: when others then
1340:
1341: hr_utility.set_location('process_sec_asg',999);
1342: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1343: raise;
1344:
1345: END process_sec_asg;
1346:

Line 1378: hr_utility.set_location('process_term_primary_asg',1);

1374: l_asg_start_date varchar2(30);
1375: l_asg_end_date varchar2(30);
1376: --
1377: BEGIN
1378: hr_utility.set_location('process_term_primary_asg',1);
1379: hr_utility.trace('p_asg_id= '||p_asg_id);
1380: --
1381: -- Loop through all terminated primary assignments
1382: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP

Line 1379: hr_utility.trace('p_asg_id= '||p_asg_id);

1375: l_asg_end_date varchar2(30);
1376: --
1377: BEGIN
1378: hr_utility.set_location('process_term_primary_asg',1);
1379: hr_utility.trace('p_asg_id= '||p_asg_id);
1380: --
1381: -- Loop through all terminated primary assignments
1382: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP
1383: --

Line 1384: hr_utility.set_location('process_term_primary_asg',2);

1380: --
1381: -- Loop through all terminated primary assignments
1382: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP
1383: --
1384: hr_utility.set_location('process_term_primary_asg',2);
1385: l_asg_include := 'N';
1386: l_asg_include := check_asg_inclusion(term_prim_asg_rec.assignment_id);
1387: --
1388: -- if assignment meets criteria and mileage balance for that assignment

Line 1394: hr_utility.set_location('process_term_primary_asg',3);

1390: -- detail record
1391: IF l_asg_include = 'Y' and to_number(mileage_balance(term_prim_asg_rec.assignment_id)) > 0
1392: THEN
1393:
1394: hr_utility.set_location('process_term_primary_asg',3);
1395:
1396: l_ben_start_date := ben_start_date(term_prim_asg_rec.assignment_id);
1397: l_ben_end_date := ben_end_date(term_prim_asg_rec.assignment_id);
1398: l_mileage_balance := mileage_balance(term_prim_asg_rec.assignment_id);

Line 1415: hr_utility.set_location('process_term_primary_asg',99);

1411: END IF;
1412:
1413: END LOOP;
1414: --
1415: hr_utility.set_location('process_term_primary_asg',99);
1416:
1417: exception
1418:
1419: when others then

Line 1421: hr_utility.set_location('process_term_primary_asg',999);

1417: exception
1418:
1419: when others then
1420:
1421: hr_utility.set_location('process_term_primary_asg',999);
1422: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1423: raise;
1424:
1425: END process_term_primary_asg;

Line 1422: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

1418:
1419: when others then
1420:
1421: hr_utility.set_location('process_term_primary_asg',999);
1422: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1423: raise;
1424:
1425: END process_term_primary_asg;
1426:

Line 1483: hr_utility.trace('Entering POST_PROCESS_RULE, p_ext_rslt_id='||p_ext_rslt_id);

1479: l_asg_include VARCHAR2(1);
1480: --
1481: BEGIN
1482:
1483: hr_utility.trace('Entering POST_PROCESS_RULE, p_ext_rslt_id='||p_ext_rslt_id);
1484:
1485: g_ext_rslt_id := p_ext_rslt_id;
1486:
1487: -- Get assignment details record id

Line 1492: hr_utility.trace('POST_PROCESS_RULE: l_asg_rcd_id='||l_asg_rcd_id);

1488: OPEN csr_asg_record_id;
1489: FETCH csr_asg_record_id INTO l_asg_rcd_id;
1490: CLOSE csr_asg_record_id;
1491: --
1492: hr_utility.trace('POST_PROCESS_RULE: l_asg_rcd_id='||l_asg_rcd_id);
1493:
1494: -- Get Balance Detail Record Id
1495: OPEN csr_detail_record_id;
1496: FETCH csr_detail_record_id INTO g_veh_rcd_id;

Line 1499: hr_utility.trace('POST_PROCESS_RULE: g_veh_rcd_id='||g_veh_rcd_id);

1495: OPEN csr_detail_record_id;
1496: FETCH csr_detail_record_id INTO g_veh_rcd_id;
1497: CLOSE csr_detail_record_id;
1498: --
1499: hr_utility.trace('POST_PROCESS_RULE: g_veh_rcd_id='||g_veh_rcd_id);
1500:
1501: -- Loop through all people extracted
1502: FOR ext_asg_rec IN csr_ext_asg LOOP
1503:

Line 1510: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);

1506:
1507: g_person_id := ext_asg_rec.person_id;
1508: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1509: --
1510: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1511: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1512:
1513: -- Fetch in full detail record for primary assignment
1514: -- Delete balance detail record if mileage ASG_YTD balance is zero

Line 1511: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);

1507: g_person_id := ext_asg_rec.person_id;
1508: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1509: --
1510: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1511: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1512:
1513: -- Fetch in full detail record for primary assignment
1514: -- Delete balance detail record if mileage ASG_YTD balance is zero
1515: OPEN csr_balance_detail(ext_asg_rec.person_id);

Line 1519: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.ext_rslt_dtl_id= '||l_balance_detail.ext_rslt_dtl_id);

1515: OPEN csr_balance_detail(ext_asg_rec.person_id);
1516: FETCH csr_balance_detail INTO l_balance_detail;
1517: CLOSE csr_balance_detail;
1518: --
1519: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.ext_rslt_dtl_id= '||l_balance_detail.ext_rslt_dtl_id);
1520: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.val_12(mileage balance)= '||l_balance_detail.val_12);
1521:
1522: --
1523: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);

Line 1520: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.val_12(mileage balance)= '||l_balance_detail.val_12);

1516: FETCH csr_balance_detail INTO l_balance_detail;
1517: CLOSE csr_balance_detail;
1518: --
1519: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.ext_rslt_dtl_id= '||l_balance_detail.ext_rslt_dtl_id);
1520: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.val_12(mileage balance)= '||l_balance_detail.val_12);
1521:
1522: --
1523: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);
1524:

Line 1529: hr_utility.trace('Primary asg does not qualify for extract - deleting detail record');

1525: IF l_balance_detail.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N'
1526: THEN
1527: -- Primary assignment does not qualify for extract
1528: -- Delete this detail record
1529: hr_utility.trace('Primary asg does not qualify for extract - deleting detail record');
1530: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
1531: p_object_version_number => l_balance_detail.object_version_number);
1532:
1533: END IF;

Line 1542: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');

1538: --
1539: -- Process any secondary assignments which may qualify
1540: process_sec_asg(ext_asg_rec.asg_id);
1541: --
1542: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1543: l_obj_no := ext_asg_rec.object_version_number;
1544: -- Delete this assignment details record
1545: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1546: p_object_version_number => l_obj_no);

Line 1550: hr_utility.trace('Leaving Post_process_rule.');

1546: p_object_version_number => l_obj_no);
1547: --
1548: END LOOP;
1549: --
1550: hr_utility.trace('Leaving Post_process_rule.');
1551: RETURN 'Y';
1552: --
1553: exception
1554:

Line 1557: hr_utility.set_location('post_process_rule',999);

1553: exception
1554:
1555: when others then
1556:
1557: hr_utility.set_location('post_process_rule',999);
1558: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1559: raise;
1560:
1561:

Line 1558: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));

1554:
1555: when others then
1556:
1557: hr_utility.set_location('post_process_rule',999);
1558: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1559: raise;
1560:
1561:
1562:

Line 1587: hr_utility.trace('Entering CHECK_PERSON_INCLUSION, p_assignment_id='||p_assignment_id);

1583: l_asg_id NUMBER;
1584:
1585: BEGIN
1586:
1587: hr_utility.trace('Entering CHECK_PERSON_INCLUSION, p_assignment_id='||p_assignment_id);
1588:
1589: -- check whether any assignment qualifies
1590: OPEN get_all_asg;
1591: LOOP

Line 1601: hr_utility.trace('Leaving CHECK_PERSON_INCLUSION, l_person_include='||l_person_include);

1597: EXIT WHEN (get_all_asg%NOTFOUND OR l_person_include = 'Y');
1598:
1599: END LOOP;
1600: --
1601: hr_utility.trace('Leaving CHECK_PERSON_INCLUSION, l_person_include='||l_person_include);
1602:
1603: RETURN l_person_include;
1604: --
1605: END check_person_inclusion;