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 92: hr_utility.set_location('get_param_tax_year',1);

88: --
89: BEGIN
90:
91: BEGIN
92: hr_utility.set_location('get_param_tax_year',1);
93:
94: l_tax_year := hruserdt.get_table_value(p_bus_grp_id,
95: 'PAY GB P11d Mileage Extract',
96: 'Parameter Value',

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

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

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

103: WHEN others THEN
104: -- tax year parameter not set or wrong format
105: -- raise an error
106: hr_utility.set_location('get_param_tax_year',2);
107: hr_utility.trace('ERROR: Seeded value for tax year not found or data corrupt');
108: raise;
109:
110: END;
111: --

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

108: raise;
109:
110: END;
111: --
112: hr_utility.set_location('get_param_tax_year',3);
113:
114: hr_utility.trace('Tax year: '||to_char(l_tax_year));
115: hr_utility.set_location('get_param_tax_year',99);
116:

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

110: END;
111: --
112: hr_utility.set_location('get_param_tax_year',3);
113:
114: hr_utility.trace('Tax year: '||to_char(l_tax_year));
115: hr_utility.set_location('get_param_tax_year',99);
116:
117: RETURN l_tax_year;
118:

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

111: --
112: hr_utility.set_location('get_param_tax_year',3);
113:
114: hr_utility.trace('Tax year: '||to_char(l_tax_year));
115: hr_utility.set_location('get_param_tax_year',99);
116:
117: RETURN l_tax_year;
118:
119: end get_param_tax_year;

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

134: l_cal_year_start date;
135: --
136: BEGIN
137:
138: hr_utility.set_location('get_tax_year_start',1);
139:
140: l_tax_year := get_param_tax_year(p_bus_grp_id);
141:
142: hr_utility.set_location('get_tax_year_start',2);

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

138: hr_utility.set_location('get_tax_year_start',1);
139:
140: l_tax_year := get_param_tax_year(p_bus_grp_id);
141:
142: hr_utility.set_location('get_tax_year_start',2);
143:
144: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
145:
146: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));

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

144: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
145:
146: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
147:
148: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
149: hr_utility.set_location('get_tax_year_start',99);
150:
151: RETURN l_tax_year_start;
152:

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

145:
146: l_tax_year_start := fnd_date.displaydate_to_date('06-APR-'||to_char(l_cal_year_start - 365, 'YYYY'));
147:
148: hr_utility.trace('Tax year start: '||to_char(l_tax_year_start,'DD-MON-YYYY'));
149: hr_utility.set_location('get_tax_year_start',99);
150:
151: RETURN l_tax_year_start;
152:
153: end get_tax_year_start;

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

168: l_cal_year_start date;
169: --
170: BEGIN
171:
172: hr_utility.set_location('get_tax_year_end',1);
173:
174: l_tax_year := get_param_tax_year(p_bus_grp_id);
175: --
176: hr_utility.set_location('get_tax_year_end',2);

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

172: hr_utility.set_location('get_tax_year_end',1);
173:
174: l_tax_year := get_param_tax_year(p_bus_grp_id);
175: --
176: hr_utility.set_location('get_tax_year_end',2);
177:
178: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
179:
180: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));

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

178: l_cal_year_start := fnd_date.displaydate_to_date('01-JAN-'||to_char(l_tax_year));
179:
180: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
181:
182: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
183: hr_utility.set_location('get_tax_year_end',99);
184:
185: RETURN l_tax_year_end;
186:

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

179:
180: l_tax_year_end := fnd_date.displaydate_to_date('05-APR-'||to_char(l_cal_year_start,'YYYY'));
181:
182: hr_utility.trace('Tax year end: '||to_char(l_tax_year_end,'DD-MON-YYYY'));
183: hr_utility.set_location('get_tax_year_end',99);
184:
185: RETURN l_tax_year_end;
186:
187: end get_tax_year_end;

Line 199: hr_utility.set_location('get_param_ext_start_date',1);

195: l_ext_start_date DATE;
196: --
197: BEGIN
198: BEGIN
199: hr_utility.set_location('get_param_ext_start_date',1);
200:
201: l_ext_start_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
202: 'PAY GB P11D Mileage Extract',
203: 'Parameter Value',

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

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

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

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

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

229: --
230: BEGIN
231:
232: BEGIN
233: hr_utility.set_location('get_param_ext_end_date',1);
234:
235: l_ext_end_date := fnd_date.displaydate_to_date(hruserdt.get_table_value(p_bus_group_id,
236: 'PAY GB P11D Mileage Extract',
237: 'Parameter Value',

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

245:
246: WHEN others THEN
247: -- extract date parameter not set or wrong format
248: -- default to end of fiscal year
249: hr_utility.set_location('get_param_ext_end_date',2);
250:
251: l_ext_end_date := get_tax_year_end(p_bus_group_id);
252:
253: END;

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

251: l_ext_end_date := get_tax_year_end(p_bus_group_id);
252:
253: END;
254: --
255: hr_utility.set_location('get_param_ext_end_date',99);
256:
257: RETURN l_ext_end_date;
258:
259: END get_param_ext_end_date;

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

513:
514: --
515: BEGIN
516:
517: hr_utility.trace('Entering CHECK_ASG_INCLUSION, p_assignment_id='||p_assignment_id);
518:
519: -- Get Business Group Id
520: l_bus_group_id := get_bus_group_id(p_assignment_id);
521:

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

529: l_ext_asg_set_id := get_param_assignment_set_id(l_bus_group_id);
530:
531: --
532:
533: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
534: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
535: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
536: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
537: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));

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

530:
531: --
532:
533: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
534: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
535: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
536: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
537: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
538:

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

531: --
532:
533: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
534: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
535: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
536: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
537: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
538:
539: --

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

532:
533: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
534: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
535: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
536: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
537: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
538:
539: --
540: -- Get details of primary assignment

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

533: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_end_date='||to_char(l_ext_end_date, 'DD-MON-YYYY'));
534: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_payroll_id='||to_char(l_ext_payroll_id));
535: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_tax_dist='||l_ext_tax_dist);
536: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_con_set_id='||to_char(l_ext_con_set_id));
537: hr_utility.trace('CHECK_ASG_INCLUSION: l_ext_asg_set_id='||to_char(l_ext_asg_set_id));
538:
539: --
540: -- Get details of primary assignment
541: -- Start with effective dates

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

542: OPEN get_asg_eff_dates(p_assignment_id);
543: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
544: CLOSE get_asg_eff_dates;
545: --
546: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
547: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
548: --
549:
550: IF l_min_start_date > l_ext_end_date OR l_max_end_date < get_tax_year_start(l_bus_group_id) THEN

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

543: FETCH get_asg_eff_dates INTO l_min_start_date, l_max_end_date;
544: CLOSE get_asg_eff_dates;
545: --
546: hr_utility.trace('CHECK_ASG_INCLUSION: l_min_start_date='||to_char(l_min_start_date, 'DD-MON-YYYY'));
547: hr_utility.trace('CHECK_ASG_INCLUSION: l_max_end_date='||to_char(l_max_end_date, 'DD-MON-YYYY'));
548: --
549:
550: IF l_min_start_date > l_ext_end_date OR l_max_end_date < get_tax_year_start(l_bus_group_id) THEN
551: -- Person not active within input date range therefore exclude

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

563: l_asg_set_include := 'Y'; -- no input asg set specified
564: END IF;
565:
566: --
567: hr_utility.trace('CHECK_ASG_INCLUSION: l_asg_set_include='||l_asg_set_include);
568:
569: -- Loop through all changes in the assignment during the input date range
570: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
571: --

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

568:
569: -- Loop through all changes in the assignment during the input date range
570: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
571: --
572: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
573: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
574: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
575: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
576: --

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

569: -- Loop through all changes in the assignment during the input date range
570: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
571: --
572: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
573: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
574: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
575: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
576: --
577: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)

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

570: FOR asg_det_rec IN get_asg_details(p_assignment_id) LOOP
571: --
572: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
573: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
574: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
575: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
576: --
577: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
578: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)

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

571: --
572: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.payroll_id='||asg_det_rec.payroll_id);
573: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.person_id='||asg_det_rec.person_id);
574: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.tax_dist='||asg_det_rec.tax_dist);
575: hr_utility.trace('CHECK_ASG_INCLUSION: asg_det_rec.consolidation_set_id='||asg_det_rec.consolidation_set_id);
576: --
577: IF (nvl(l_ext_payroll_id, nvl(asg_det_rec.payroll_id, -999)) = nvl(asg_det_rec.payroll_id, -999)
578: AND nvl(l_ext_person_id, nvl(asg_det_rec.person_id, -999)) = nvl(asg_det_rec.person_id, -999)
579: AND nvl(l_ext_tax_dist, nvl(asg_det_rec.tax_dist, 'ZZZ')) = nvl(asg_det_rec.tax_dist, 'ZZZ')

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

592:
593: end if;
594:
595: --
596: hr_utility.trace('CHECK_ASG_INCLUSION: In Loop, l_asg_include='||l_asg_include);
597: END IF;
598: END LOOP;
599:
600: --

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

597: END IF;
598: END LOOP;
599:
600: --
601: hr_utility.trace('Leaving CHECK_ASG_INCLUSION, l_asg_include='||l_asg_include);
602:
603: RETURN l_asg_include;
604: --
605: END check_asg_inclusion;

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

632: and p_ext_end_date;
633:
634: begin
635:
636: hr_utility.set_location('get_latest_asg_act_ext',1);
637:
638: open csr_latest_asg_act_id;
639: fetch csr_latest_asg_act_id into l_asg_act_id;
640: close csr_latest_asg_act_id;

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

638: open csr_latest_asg_act_id;
639: fetch csr_latest_asg_act_id into l_asg_act_id;
640: close csr_latest_asg_act_id;
641:
642: hr_utility.trace('Asg act id: '||l_asg_act_id);
643: hr_utility.set_location('get_latest_asg_act_ext',99);
644:
645: return l_asg_act_id;
646:

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

639: fetch csr_latest_asg_act_id into l_asg_act_id;
640: close csr_latest_asg_act_id;
641:
642: hr_utility.trace('Asg act id: '||l_asg_act_id);
643: hr_utility.set_location('get_latest_asg_act_ext',99);
644:
645: return l_asg_act_id;
646:
647: exception

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

646:
647: exception
648:
649: when others then
650: hr_utility.set_location('get_latest_asg_act_ext',999);
651: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
652: raise;
653:
654: end get_latest_asg_act_ext;

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

647: exception
648:
649: when others then
650: hr_utility.set_location('get_latest_asg_act_ext',999);
651: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
652: raise;
653:
654: end get_latest_asg_act_ext;
655:

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

681: and p_tax_year_end_date;
682:
683: begin
684:
685: hr_utility.set_location('get_latest_asg_act_tye',1);
686:
687: open csr_latest_asg_act_id;
688: fetch csr_latest_asg_act_id into l_asg_act_id;
689: close csr_latest_asg_act_id;

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

687: open csr_latest_asg_act_id;
688: fetch csr_latest_asg_act_id into l_asg_act_id;
689: close csr_latest_asg_act_id;
690:
691: hr_utility.trace('Asg act id: '||l_asg_act_id);
692: hr_utility.set_location('get_latest_asg_act_tye',99);
693:
694: return l_asg_act_id;
695:

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

688: fetch csr_latest_asg_act_id into l_asg_act_id;
689: close csr_latest_asg_act_id;
690:
691: hr_utility.trace('Asg act id: '||l_asg_act_id);
692: hr_utility.set_location('get_latest_asg_act_tye',99);
693:
694: return l_asg_act_id;
695:
696: exception

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

695:
696: exception
697:
698: when others then
699: hr_utility.set_location('get_latest_asg_act_tye',999);
700: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
701: raise;
702:
703: end get_latest_asg_act_tye;

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

696: exception
697:
698: when others then
699: hr_utility.set_location('get_latest_asg_act_tye',999);
700: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
701: raise;
702:
703: end get_latest_asg_act_tye;
704:

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

712: l_odd_even_marker varchar2(5);
713:
714: begin
715:
716: hr_utility.set_location('check_odd_even_year',1);
717:
718: hr_utility.trace('Tax Year End Date: '||p_tax_year_end_date);
719:
720: if mod(to_number(to_char(p_tax_year_end_date,'YYYY')),2) = 0

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

714: begin
715:
716: hr_utility.set_location('check_odd_even_year',1);
717:
718: hr_utility.trace('Tax Year End Date: '||p_tax_year_end_date);
719:
720: if mod(to_number(to_char(p_tax_year_end_date,'YYYY')),2) = 0
721: then
722:

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

727: l_odd_even_marker := 'ODD';
728:
729: end if;
730:
731: hr_utility.set_location('check_odd_even_year',99);
732: return l_odd_even_marker;
733:
734: end check_odd_even_year;
735: ---------------------------------------------------------------------------

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

755: and paf.assignment_id = p_assignment_id;
756:
757: begin
758:
759: hr_utility.set_location('ben_start_date',1);
760:
761: l_bus_group_id := get_bus_group_id(p_assignment_id);
762: l_tax_year_start := get_tax_year_start(l_bus_group_id);
763:

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

760:
761: l_bus_group_id := get_bus_group_id(p_assignment_id);
762: l_tax_year_start := get_tax_year_start(l_bus_group_id);
763:
764: hr_utility.set_location('ben_start_date',2);
765:
766: open csr_ben_start_date;
767: fetch csr_ben_start_date into l_ben_start_date;
768: close csr_ben_start_date;

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

766: open csr_ben_start_date;
767: fetch csr_ben_start_date into l_ben_start_date;
768: close csr_ben_start_date;
769:
770: hr_utility.trace('Benefit start date: '||to_char(l_ben_start_date,'DD-MON-YYYY'));
771: hr_utility.set_location('ben_start_date',99);
772:
773: return to_char(l_ben_start_date,'DD-MON-YYYY');
774:

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

767: fetch csr_ben_start_date into l_ben_start_date;
768: close csr_ben_start_date;
769:
770: hr_utility.trace('Benefit start date: '||to_char(l_ben_start_date,'DD-MON-YYYY'));
771: hr_utility.set_location('ben_start_date',99);
772:
773: return to_char(l_ben_start_date,'DD-MON-YYYY');
774:
775: exception

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

774:
775: exception
776:
777: when others then
778: hr_utility.set_location('ben_start_date',999);
779: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
780: raise;
781:
782: end ben_start_date;

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

775: exception
776:
777: when others then
778: hr_utility.set_location('ben_start_date',999);
779: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
780: raise;
781:
782: end ben_start_date;
783:

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

802: and paf.assignment_id = p_assignment_id;
803:
804: begin
805:
806: hr_utility.set_location('ben_end_date',1);
807:
808: l_bus_group_id := get_bus_group_id(p_assignment_id);
809: l_tax_year_end := get_tax_year_end(l_bus_group_id);
810:

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

807:
808: l_bus_group_id := get_bus_group_id(p_assignment_id);
809: l_tax_year_end := get_tax_year_end(l_bus_group_id);
810:
811: hr_utility.set_location('ben_end_date',2);
812:
813: open csr_ben_end_date;
814: fetch csr_ben_end_date into l_ben_end_date;
815: close csr_ben_end_date;

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

813: open csr_ben_end_date;
814: fetch csr_ben_end_date into l_ben_end_date;
815: close csr_ben_end_date;
816:
817: hr_utility.trace('Benefit end date: '||to_char(l_ben_end_date,'DD-MON-YYYY'));
818: hr_utility.set_location('ben_end_date',99);
819:
820: return to_char(l_ben_end_date,'DD-MON-YYYY');
821:

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

814: fetch csr_ben_end_date into l_ben_end_date;
815: close csr_ben_end_date;
816:
817: hr_utility.trace('Benefit end date: '||to_char(l_ben_end_date,'DD-MON-YYYY'));
818: hr_utility.set_location('ben_end_date',99);
819:
820: return to_char(l_ben_end_date,'DD-MON-YYYY');
821:
822: exception

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

821:
822: exception
823:
824: when others then
825: hr_utility.set_location('ben_end_date',999);
826: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
827: raise;
828:
829: end ben_end_date;

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

822: exception
823:
824: when others then
825: hr_utility.set_location('ben_end_date',999);
826: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
827: raise;
828:
829: end ben_end_date;
830:

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

845: where paf.assignment_id = p_assignment_id;
846:
847: begin
848:
849: hr_utility.set_location('asg_start_date',1);
850:
851: l_bus_group_id := get_bus_group_id(p_assignment_id);
852: l_tax_year_start := get_tax_year_start(l_bus_group_id);
853:

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

850:
851: l_bus_group_id := get_bus_group_id(p_assignment_id);
852: l_tax_year_start := get_tax_year_start(l_bus_group_id);
853:
854: hr_utility.set_location('asg_start_date',2);
855:
856: open csr_asg_start_date;
857: fetch csr_asg_start_date into l_asg_start_date;
858: close csr_asg_start_date;

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

856: open csr_asg_start_date;
857: fetch csr_asg_start_date into l_asg_start_date;
858: close csr_asg_start_date;
859:
860: hr_utility.trace('Asg start date: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
861: hr_utility.set_location('asg_start_date',99);
862:
863: return to_char(l_asg_start_date,'DD-MON-YYYY');
864:

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

857: fetch csr_asg_start_date into l_asg_start_date;
858: close csr_asg_start_date;
859:
860: hr_utility.trace('Asg start date: '||to_char(l_asg_start_date,'DD-MON-YYYY'));
861: hr_utility.set_location('asg_start_date',99);
862:
863: return to_char(l_asg_start_date,'DD-MON-YYYY');
864:
865: exception

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

864:
865: exception
866:
867: when others then
868: hr_utility.set_location('asg_start_date',999);
869: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
870: raise;
871:
872: end asg_start_date;

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

865: exception
866:
867: when others then
868: hr_utility.set_location('asg_start_date',999);
869: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
870: raise;
871:
872: end asg_start_date;
873:

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

892: and paf.assignment_status_type_id = past.assignment_status_type_id;
893:
894: begin
895:
896: hr_utility.set_location('asg_end_date',1);
897:
898: l_bus_group_id := get_bus_group_id(p_assignment_id);
899: l_tax_year_end := get_tax_year_end(l_bus_group_id);
900:

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

897:
898: l_bus_group_id := get_bus_group_id(p_assignment_id);
899: l_tax_year_end := get_tax_year_end(l_bus_group_id);
900:
901: hr_utility.set_location('asg_end_date',2);
902:
903: open csr_asg_end_date;
904: fetch csr_asg_end_date into l_asg_end_date;
905: close csr_asg_end_date;

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

903: open csr_asg_end_date;
904: fetch csr_asg_end_date into l_asg_end_date;
905: close csr_asg_end_date;
906:
907: hr_utility.trace('Asg end date: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
908: hr_utility.set_location('asg_end_date',99);
909:
910: return to_char(l_asg_end_date,'DD-MON-YYYY');
911:

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

904: fetch csr_asg_end_date into l_asg_end_date;
905: close csr_asg_end_date;
906:
907: hr_utility.trace('Asg end date: '||to_char(l_asg_end_date,'DD-MON-YYYY'));
908: hr_utility.set_location('asg_end_date',99);
909:
910: return to_char(l_asg_end_date,'DD-MON-YYYY');
911:
912: exception

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

911:
912: exception
913:
914: when others then
915: hr_utility.set_location('asg_end_date',999);
916: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
917: raise;
918:
919: end asg_end_date;

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

912: exception
913:
914: when others then
915: hr_utility.set_location('asg_end_date',999);
916: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
917: raise;
918:
919: end asg_end_date;
920:

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

966: l_balance_amt number;
967:
968: begin
969:
970: hr_utility.set_location('mileage_balance',1);
971:
972: -- get necessary data
973:
974: l_bus_group_id := get_bus_group_id(p_assignment_id);

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

972: -- get necessary data
973:
974: l_bus_group_id := get_bus_group_id(p_assignment_id);
975:
976: hr_utility.set_location('mileage_balance',2);
977:
978: l_tax_year_end := get_tax_year_end(l_bus_group_id);
979:
980: hr_utility.set_location('mileage_balance',3);

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

976: hr_utility.set_location('mileage_balance',2);
977:
978: l_tax_year_end := get_tax_year_end(l_bus_group_id);
979:
980: hr_utility.set_location('mileage_balance',3);
981:
982:
983: -- check whether year in which tax year end date falls is odd or even
984:

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

985: l_odd_even_marker := check_odd_even_year(l_tax_year_end);
986:
987: -- retrieve appropriate odd/even defined balance id for Mileage Taxable Amt
988: -- based on odd/even marker
989: hr_utility.set_location('mileage_balance',4);
990:
991: if l_odd_even_marker = 'ODD'
992: then
993:

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

1002: close csr_get_even_def_bal_id;
1003:
1004: end if;
1005:
1006: hr_utility.set_location('mileage_balance',5);
1007:
1008: -- get params to pass to get_latest_asg_act
1009:
1010: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);

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

1008: -- get params to pass to get_latest_asg_act
1009:
1010: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1011:
1012: hr_utility.set_location('mileage_balance',6);
1013:
1014: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1015:
1016: hr_utility.set_location('mileage_balance',7);

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

1012: hr_utility.set_location('mileage_balance',6);
1013:
1014: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1015:
1016: hr_utility.set_location('mileage_balance',7);
1017:
1018: -- fetch latest assignment action ids for that assignment as at TYE and
1019: -- extract end date (or closest asg action to either)
1020:

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

1027: p_ben_start_date => l_ben_start_date);
1028:
1029: -- now get ASG_YTD balances for that assignment, using defined balance id
1030: -- and latest assignment actions just obtained
1031: hr_utility.set_location('mileage_balance',8);
1032:
1033: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1034: p_assignment_action_id => l_asg_act_id_ext);
1035:

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

1035:
1036: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1037: p_assignment_action_id => l_asg_act_id_tye);
1038:
1039: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1040: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1041:
1042: if l_tye_balance <> l_ext_balance
1043: -- e.g. if user has processed back-dated mileage claims after TYE so balance

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

1036: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1037: p_assignment_action_id => l_asg_act_id_tye);
1038:
1039: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1040: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1041:
1042: if l_tye_balance <> l_ext_balance
1043: -- e.g. if user has processed back-dated mileage claims after TYE so balance
1044: -- as of extract end date is greater

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

1052: l_balance_amt := l_tye_balance;
1053:
1054: end if;
1055:
1056: hr_utility.set_location('mileage_balance',9);
1057: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1058: hr_utility.trace('Assignment id: '||p_assignment_id);
1059:
1060: hr_utility.set_location('mileage_balance',99);

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

1053:
1054: end if;
1055:
1056: hr_utility.set_location('mileage_balance',9);
1057: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1058: hr_utility.trace('Assignment id: '||p_assignment_id);
1059:
1060: hr_utility.set_location('mileage_balance',99);
1061:

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

1054: end if;
1055:
1056: hr_utility.set_location('mileage_balance',9);
1057: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1058: hr_utility.trace('Assignment id: '||p_assignment_id);
1059:
1060: hr_utility.set_location('mileage_balance',99);
1061:
1062: return to_char(l_balance_amt);

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

1056: hr_utility.set_location('mileage_balance',9);
1057: hr_utility.trace('Mileage Balance Amount: '||l_balance_amt);
1058: hr_utility.trace('Assignment id: '||p_assignment_id);
1059:
1060: hr_utility.set_location('mileage_balance',99);
1061:
1062: return to_char(l_balance_amt);
1063:
1064: exception

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

1063:
1064: exception
1065:
1066: when others then
1067: hr_utility.set_location('mileage_balance',999);
1068: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1069: raise;
1070:
1071: end mileage_balance;

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

1064: exception
1065:
1066: when others then
1067: hr_utility.set_location('mileage_balance',999);
1068: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1069: raise;
1070:
1071: end mileage_balance;
1072:

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

1118: l_balance_amt number;
1119:
1120: begin
1121:
1122: hr_utility.set_location('add_pass_balance',1);
1123:
1124: -- get necessary data
1125:
1126: l_bus_group_id := get_bus_group_id(p_assignment_id);

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

1124: -- get necessary data
1125:
1126: l_bus_group_id := get_bus_group_id(p_assignment_id);
1127:
1128: hr_utility.set_location('add_pass_balance',2);
1129:
1130: l_tax_year_end := get_tax_year_end(l_bus_group_id);
1131:
1132: hr_utility.set_location('add_pass_balance',3);

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

1128: hr_utility.set_location('add_pass_balance',2);
1129:
1130: l_tax_year_end := get_tax_year_end(l_bus_group_id);
1131:
1132: hr_utility.set_location('add_pass_balance',3);
1133:
1134: -- check whether year in which tax year end date falls is odd or even
1135:
1136: l_odd_even_marker := check_odd_even_year(l_tax_year_end);

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

1136: l_odd_even_marker := check_odd_even_year(l_tax_year_end);
1137:
1138: -- retrieve appropriate odd/even defined balance id for Mileage Taxable Amt
1139: -- based on odd/even marker
1140: hr_utility.set_location('add_pass_balance',4);
1141:
1142: if l_odd_even_marker = 'ODD'
1143: then
1144:

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

1153: close csr_get_even_def_bal_id;
1154:
1155: end if;
1156:
1157: hr_utility.set_location('add_pass_balance',5);
1158:
1159: -- get params to pass to get_latest_asg_act
1160:
1161: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);

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

1159: -- get params to pass to get_latest_asg_act
1160:
1161: l_ext_end_date := get_param_ext_end_date(l_bus_group_id);
1162:
1163: hr_utility.set_location('add_pass_balance',6);
1164:
1165: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1166:
1167: hr_utility.set_location('add_pass_balance',7);

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

1163: hr_utility.set_location('add_pass_balance',6);
1164:
1165: l_ben_start_date := fnd_date.displaydate_to_date(ben_start_date(p_assignment_id));
1166:
1167: hr_utility.set_location('add_pass_balance',7);
1168:
1169: -- fetch latest assignment action ids for that assignment as at TYE and
1170: -- extract end date (or closest asg act to either)
1171:

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

1178: p_ben_start_date => l_ben_start_date);
1179:
1180: -- now get ASG_YTD balances for that assignment, using defined balance id
1181: -- and latest assignment actions just obtained
1182: hr_utility.set_location('add_pass_balance',8);
1183:
1184: l_ext_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1185: p_assignment_action_id => l_asg_act_id_ext);
1186:

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

1186:
1187: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1188: p_assignment_action_id => l_asg_act_id_tye);
1189:
1190: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1191: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1192:
1193: if l_tye_balance <> l_ext_balance
1194: -- e.g. if user has processed back-dated mileage claims after TYE so balance

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

1187: l_tye_balance := pay_balance_pkg.get_value (p_defined_balance_id => l_def_bal_id,
1188: p_assignment_action_id => l_asg_act_id_tye);
1189:
1190: hr_utility.trace('l_ext_balance: '||l_ext_balance);
1191: hr_utility.trace('l_tye_balance: '||l_tye_balance);
1192:
1193: if l_tye_balance <> l_ext_balance
1194: -- e.g. if user has processed back-dated mileage claims after TYE so balance
1195: -- as of extract end date is greater

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

1203: l_balance_amt := l_tye_balance;
1204:
1205: end if;
1206:
1207: hr_utility.set_location('add_pass_balance',9);
1208: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1209: hr_utility.trace('Assignment id: '||p_assignment_id);
1210:
1211: hr_utility.set_location('add_pass_balance',99);

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

1204:
1205: end if;
1206:
1207: hr_utility.set_location('add_pass_balance',9);
1208: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1209: hr_utility.trace('Assignment id: '||p_assignment_id);
1210:
1211: hr_utility.set_location('add_pass_balance',99);
1212:

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

1205: end if;
1206:
1207: hr_utility.set_location('add_pass_balance',9);
1208: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1209: hr_utility.trace('Assignment id: '||p_assignment_id);
1210:
1211: hr_utility.set_location('add_pass_balance',99);
1212:
1213: return to_char(l_balance_amt);

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

1207: hr_utility.set_location('add_pass_balance',9);
1208: hr_utility.trace('Addl Passenger Balance Amount: '||l_balance_amt);
1209: hr_utility.trace('Assignment id: '||p_assignment_id);
1210:
1211: hr_utility.set_location('add_pass_balance',99);
1212:
1213: return to_char(l_balance_amt);
1214:
1215: exception

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

1214:
1215: exception
1216:
1217: when others then
1218: hr_utility.set_location('mileage_balance',999);
1219: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1220: raise;
1221:
1222: end add_pass_balance;

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

1215: exception
1216:
1217: when others then
1218: hr_utility.set_location('mileage_balance',999);
1219: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1220: raise;
1221:
1222: end add_pass_balance;
1223:

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

1292: l_bal_return varchar2(10);
1293:
1294: BEGIN
1295:
1296: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1297: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1298: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1299: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1300: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);

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

1293:
1294: BEGIN
1295:
1296: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1297: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1298: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1299: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1300: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1301: --

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

1294: BEGIN
1295:
1296: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1297: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1298: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1299: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1300: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1301: --
1302: l_bus_group_id := get_bus_group_id(p_asg_id);

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

1295:
1296: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1297: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1298: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1299: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1300: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1301: --
1302: l_bus_group_id := get_bus_group_id(p_asg_id);
1303:

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

1296: hr_utility.trace('Entering CREATE_EXT_RSLT_DTL: p_asg_id='|| p_asg_id);
1297: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_start_date='||p_benefit_start_date);
1298: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_benefit_end_date='||p_benefit_end_date);
1299: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_start_date='||p_asg_start_date);
1300: hr_utility.trace('CREATE_EXT_RSLT_DTL: p_asg_end_date='||p_asg_end_date);
1301: --
1302: l_bus_group_id := get_bus_group_id(p_asg_id);
1303:
1304: l_tax_year_end := get_tax_year_end(l_bus_group_id);

Line 1357: hr_utility.set_location('l_bal_return returned: '||l_bal_return,8);

1353: ,l_taxable_passenger_payments
1354: );
1355: null;
1356:
1357: hr_utility.set_location('l_bal_return returned: '||l_bal_return,8);
1358:
1359: ben_ext_rslt_dtl_api.create_ext_rslt_dtl( p_ext_rslt_dtl_id => l_ext_rslt_dtl_id
1360: ,p_ext_rslt_id => g_ext_rslt_id
1361: ,p_ext_rcd_id => g_veh_rcd_id

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

1382: ,p_val_19 => '~~'
1383: ,p_val_20 => '~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~'
1384: ,p_object_version_number => l_object_version_no);
1385:
1386: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);
1387:
1388: EXCEPTION WHEN others THEN
1389: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1390: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));

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

1385:
1386: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);
1387:
1388: EXCEPTION WHEN others THEN
1389: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1390: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1391: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1392: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1393: RAISE;

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

1386: hr_utility.trace('Wrote detail record: '||l_ext_rslt_dtl_id);
1387:
1388: EXCEPTION WHEN others THEN
1389: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1390: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1391: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1392: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1393: RAISE;
1394: END;

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

1387:
1388: EXCEPTION WHEN others THEN
1389: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1390: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1391: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1392: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1393: RAISE;
1394: END;
1395: END IF;

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

1388: EXCEPTION WHEN others THEN
1389: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 1, 100));
1390: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 101, 100));
1391: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 201, 100));
1392: hr_utility.trace('CREATE_EXT_RSLT_DTL: '||substr(sqlerrm, 301, 100));
1393: RAISE;
1394: END;
1395: END IF;
1396: --

Line 1433: hr_utility.trace('Entering PROCESS_CAR_04, p_asg_id='||p_asg_id);

1429: l_veh_id_rec get_veh_id%ROWTYPE;
1430: --
1431:
1432: BEGIN
1433: hr_utility.trace('Entering PROCESS_CAR_04, p_asg_id='||p_asg_id);
1434: -- Get extract date parameter values
1435: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1436: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1437: -- Get Assignment Start and End Dates

Line 1445: hr_utility.trace('PROCESS_CAR_04, After Fetch.');

1441: OPEN get_veh_id;
1442: -- Fetch vehicle record for Car vehicle type and create extract result detail
1443:
1444: FETCH get_veh_id INTO l_veh_id_rec;
1445: hr_utility.trace('PROCESS_CAR_04, After Fetch.');
1446: hr_utility.trace('PROCESS_CAR_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1447: hr_utility.trace('PROCESS_CAR_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1448:
1449: --

Line 1446: hr_utility.trace('PROCESS_CAR_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

1442: -- Fetch vehicle record for Car vehicle type and create extract result detail
1443:
1444: FETCH get_veh_id INTO l_veh_id_rec;
1445: hr_utility.trace('PROCESS_CAR_04, After Fetch.');
1446: hr_utility.trace('PROCESS_CAR_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1447: hr_utility.trace('PROCESS_CAR_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1448:
1449: --
1450: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN

Line 1447: hr_utility.trace('PROCESS_CAR_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

1443:
1444: FETCH get_veh_id INTO l_veh_id_rec;
1445: hr_utility.trace('PROCESS_CAR_04, After Fetch.');
1446: hr_utility.trace('PROCESS_CAR_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1447: hr_utility.trace('PROCESS_CAR_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1448:
1449: --
1450: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1451: hr_utility.trace('PROCESS_CAR_04: No Car present for this assignment.');

Line 1451: hr_utility.trace('PROCESS_CAR_04: No Car present for this assignment.');

1447: hr_utility.trace('PROCESS_CAR_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1448:
1449: --
1450: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1451: hr_utility.trace('PROCESS_CAR_04: No Car present for this assignment.');
1452: ELSE
1453: -- create reslt dtl record
1454: hr_utility.trace('PROCESS_CAR_04: Creating Car Vehicle Record for this assignment.');
1455: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,

Line 1454: hr_utility.trace('PROCESS_CAR_04: Creating Car Vehicle Record for this assignment.');

1450: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1451: hr_utility.trace('PROCESS_CAR_04: No Car present for this assignment.');
1452: ELSE
1453: -- create reslt dtl record
1454: hr_utility.trace('PROCESS_CAR_04: Creating Car Vehicle Record for this assignment.');
1455: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,
1456: l_veh_id_rec.effective_start_date,
1457: l_veh_id_rec.effective_end_date,'Car or Van'
1458: );

Line 1463: hr_utility.trace('Leaving PROCESS_CAR_04');

1459: --
1460: END IF;
1461: --
1462: close get_veh_id;
1463: hr_utility.trace('Leaving PROCESS_CAR_04');
1464: --
1465: END process_car_04;
1466: ---------------------------------------------------------------------------
1467:

Line 1501: hr_utility.trace('Entering process_motorcycle_04, p_asg_id='||p_asg_id);

1497: l_veh_id_rec get_veh_id%ROWTYPE;
1498: --
1499:
1500: BEGIN
1501: hr_utility.trace('Entering process_motorcycle_04, p_asg_id='||p_asg_id);
1502: -- Get extract date parameter values
1503: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1504: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1505: -- Get Assignment Start and End Dates

Line 1513: hr_utility.trace('process_motorcycle_04, After Fetch.');

1509: OPEN get_veh_id;
1510: -- Fetch vehicle record for Car vehicle type and create extract result detail
1511:
1512: FETCH get_veh_id INTO l_veh_id_rec;
1513: hr_utility.trace('process_motorcycle_04, After Fetch.');
1514: hr_utility.trace('process_motorcycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1515: hr_utility.trace('process_motorcycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1516:
1517: --

Line 1514: hr_utility.trace('process_motorcycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

1510: -- Fetch vehicle record for Car vehicle type and create extract result detail
1511:
1512: FETCH get_veh_id INTO l_veh_id_rec;
1513: hr_utility.trace('process_motorcycle_04, After Fetch.');
1514: hr_utility.trace('process_motorcycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1515: hr_utility.trace('process_motorcycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1516:
1517: --
1518: --

Line 1515: hr_utility.trace('process_motorcycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

1511:
1512: FETCH get_veh_id INTO l_veh_id_rec;
1513: hr_utility.trace('process_motorcycle_04, After Fetch.');
1514: hr_utility.trace('process_motorcycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1515: hr_utility.trace('process_motorcycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1516:
1517: --
1518: --
1519: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN

Line 1520: hr_utility.trace('PROCESS_MOTORCYCLE_04: No Motor Cycle present for this assignment.');

1516:
1517: --
1518: --
1519: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1520: hr_utility.trace('PROCESS_MOTORCYCLE_04: No Motor Cycle present for this assignment.');
1521: ELSE
1522: -- create reslt dtl record
1523: hr_utility.trace('process_motorcycle_04: Creating Motorcycle Record for this assignment.');
1524: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,

Line 1523: hr_utility.trace('process_motorcycle_04: Creating Motorcycle Record for this assignment.');

1519: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1520: hr_utility.trace('PROCESS_MOTORCYCLE_04: No Motor Cycle present for this assignment.');
1521: ELSE
1522: -- create reslt dtl record
1523: hr_utility.trace('process_motorcycle_04: Creating Motorcycle Record for this assignment.');
1524: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,
1525: l_veh_id_rec.effective_start_date,
1526: l_veh_id_rec.effective_end_date,'Motorcycle'
1527: );

Line 1532: hr_utility.trace('Leaving process_motorcycle_04');

1528: --
1529: END IF;
1530: --
1531: close get_veh_id;
1532: hr_utility.trace('Leaving process_motorcycle_04');
1533: --
1534: END process_motorcycle_04;
1535: ---------------------------------------------------------------------------
1536:

Line 1570: hr_utility.trace('Entering process_pedal_cycle_04, p_asg_id='||p_asg_id);

1566: l_veh_id_rec get_veh_id%ROWTYPE;
1567: --
1568:
1569: BEGIN
1570: hr_utility.trace('Entering process_pedal_cycle_04, p_asg_id='||p_asg_id);
1571: -- Get extract date parameter values
1572: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_asg_id));
1573: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_asg_id));
1574: -- Get Assignment Start and End Dates

Line 1582: hr_utility.trace('process_pedal_cycle_04, After Fetch.');

1578: OPEN get_veh_id;
1579: -- Fetch vehicle record for Car vehicle type and create extract result detail
1580:
1581: FETCH get_veh_id INTO l_veh_id_rec;
1582: hr_utility.trace('process_pedal_cycle_04, After Fetch.');
1583: hr_utility.trace('process_pedal_cycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1584: hr_utility.trace('process_pedal_cycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1585:
1586: --

Line 1583: hr_utility.trace('process_pedal_cycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));

1579: -- Fetch vehicle record for Car vehicle type and create extract result detail
1580:
1581: FETCH get_veh_id INTO l_veh_id_rec;
1582: hr_utility.trace('process_pedal_cycle_04, After Fetch.');
1583: hr_utility.trace('process_pedal_cycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1584: hr_utility.trace('process_pedal_cycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1585:
1586: --
1587: --

Line 1584: hr_utility.trace('process_pedal_cycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));

1580:
1581: FETCH get_veh_id INTO l_veh_id_rec;
1582: hr_utility.trace('process_pedal_cycle_04, After Fetch.');
1583: hr_utility.trace('process_pedal_cycle_04, effective_start_date='||to_char(l_veh_id_rec.effective_start_date, 'DD-MON-YYYY'));
1584: hr_utility.trace('process_pedal_cycle_04, effective_end_date='||to_char(l_veh_id_rec.effective_end_date, 'DD-MON-YYYY'));
1585:
1586: --
1587: --
1588: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN

Line 1589: hr_utility.trace('process_pedal_cycle_04: No Pedal Cycle present for this assignment.');

1585:
1586: --
1587: --
1588: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1589: hr_utility.trace('process_pedal_cycle_04: No Pedal Cycle present for this assignment.');
1590: ELSE
1591: -- create reslt dtl record
1592: hr_utility.trace('process_pedal_cycle_04: Creating Pedal cycle Record for this assignment.');
1593: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,

Line 1592: hr_utility.trace('process_pedal_cycle_04: Creating Pedal cycle Record for this assignment.');

1588: IF l_veh_id_rec.effective_start_date is null or l_veh_id_rec.effective_end_date is null THEN
1589: hr_utility.trace('process_pedal_cycle_04: No Pedal Cycle present for this assignment.');
1590: ELSE
1591: -- create reslt dtl record
1592: hr_utility.trace('process_pedal_cycle_04: Creating Pedal cycle Record for this assignment.');
1593: create_ext_rslt_dtl(p_asg_id, l_asg_start_date, l_asg_end_date,
1594: l_veh_id_rec.effective_start_date,
1595: --l_veh_id_rec.effective_end_date,'Pedalcycle'
1596: l_veh_id_rec.effective_end_date,'Bicycle'

Line 1602: hr_utility.trace('Leaving process_pedal_cycle_04');

1598: --
1599: END IF;
1600: --
1601: close get_veh_id;
1602: hr_utility.trace('Leaving process_pedal_cycle_04');
1603: --
1604: END process_pedal_cycle_04;
1605: ---------------------------------------------------------------------------
1606:

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

1631: l_asg_end_date varchar2(30);
1632: --
1633: --
1634: BEGIN
1635: hr_utility.set_location('process_sec_asg',1);
1636: hr_utility.trace('p_asg_id= '||p_asg_id);
1637: --
1638: -- Loop through all secondary assignments
1639: FOR sec_asg_rec IN csr_sec_asg LOOP

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

1632: --
1633: --
1634: BEGIN
1635: hr_utility.set_location('process_sec_asg',1);
1636: hr_utility.trace('p_asg_id= '||p_asg_id);
1637: --
1638: -- Loop through all secondary assignments
1639: FOR sec_asg_rec IN csr_sec_asg LOOP
1640: --

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

1637: --
1638: -- Loop through all secondary assignments
1639: FOR sec_asg_rec IN csr_sec_asg LOOP
1640: --
1641: hr_utility.set_location('process_sec_asg',2);
1642: l_asg_include := 'N';
1643: l_asg_include := check_asg_inclusion(sec_asg_rec.assignment_id);
1644: --
1645: -- if assignment is eligible for inclusion call program to create detail record

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

1645: -- if assignment is eligible for inclusion call program to create detail record
1646: --
1647: IF l_asg_include = 'Y' THEN
1648:
1649: hr_utility.set_location('process_sec_asg',3);
1650:
1651: process_car_04(sec_asg_rec.assignment_id);
1652: process_motorcycle_04(sec_asg_rec.assignment_id);
1653: process_pedal_cycle_04(sec_asg_rec.assignment_id);

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

1655: END IF;
1656:
1657: END LOOP;
1658: --
1659: hr_utility.set_location('process_sec_asg',99);
1660:
1661: exception
1662:
1663: when others then

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

1661: exception
1662:
1663: when others then
1664:
1665: hr_utility.set_location('process_sec_asg',999);
1666: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1667: raise;
1668:
1669: END process_sec_asg;

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

1662:
1663: when others then
1664:
1665: hr_utility.set_location('process_sec_asg',999);
1666: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1667: raise;
1668:
1669: END process_sec_asg;
1670:

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

1698: l_asg_start_date varchar2(30);
1699: l_asg_end_date varchar2(30);
1700: --
1701: BEGIN
1702: hr_utility.set_location('process_term_primary_asg',1);
1703: hr_utility.trace('p_asg_id= '||p_asg_id);
1704: --
1705: -- Loop through all terminated primary assignments
1706: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP

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

1699: l_asg_end_date varchar2(30);
1700: --
1701: BEGIN
1702: hr_utility.set_location('process_term_primary_asg',1);
1703: hr_utility.trace('p_asg_id= '||p_asg_id);
1704: --
1705: -- Loop through all terminated primary assignments
1706: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP
1707: --

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

1704: --
1705: -- Loop through all terminated primary assignments
1706: FOR term_prim_asg_rec IN csr_term_prim_asg LOOP
1707: --
1708: hr_utility.set_location('process_term_primary_asg',2);
1709: l_asg_include := 'N';
1710: l_asg_include := check_asg_inclusion(term_prim_asg_rec.assignment_id);
1711: --
1712: -- if assignment is eligible for inclusion call program to create detail record

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

1712: -- if assignment is eligible for inclusion call program to create detail record
1713:
1714: IF l_asg_include = 'Y' THEN
1715:
1716: hr_utility.set_location('process_term_primary_asg',3);
1717:
1718: process_car_04(term_prim_asg_rec.assignment_id);
1719: process_motorcycle_04(term_prim_asg_rec.assignment_id);
1720: process_pedal_cycle_04(term_prim_asg_rec.assignment_id);

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

1722: END IF;
1723:
1724: END LOOP;
1725: --
1726: hr_utility.set_location('process_term_primary_asg',99);
1727:
1728: exception
1729:
1730: when others then

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

1728: exception
1729:
1730: when others then
1731:
1732: hr_utility.set_location('process_term_primary_asg',999);
1733: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1734: raise;
1735:
1736: END process_term_primary_asg;

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

1729:
1730: when others then
1731:
1732: hr_utility.set_location('process_term_primary_asg',999);
1733: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1734: raise;
1735:
1736: END process_term_primary_asg;
1737:

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

1794: l_asg_include VARCHAR2(1);
1795: --
1796: BEGIN
1797:
1798: hr_utility.trace('Entering POST_PROCESS_RULE, p_ext_rslt_id='||p_ext_rslt_id);
1799:
1800: g_ext_rslt_id := p_ext_rslt_id;
1801:
1802: -- Get assignment details record id

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

1803: OPEN csr_asg_record_id;
1804: FETCH csr_asg_record_id INTO l_asg_rcd_id;
1805: CLOSE csr_asg_record_id;
1806: --
1807: hr_utility.trace('POST_PROCESS_RULE: l_asg_rcd_id='||l_asg_rcd_id);
1808:
1809: -- Get Balance Detail Record Id
1810: OPEN csr_detail_record_id;
1811: FETCH csr_detail_record_id INTO g_veh_rcd_id;

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

1810: OPEN csr_detail_record_id;
1811: FETCH csr_detail_record_id INTO g_veh_rcd_id;
1812: CLOSE csr_detail_record_id;
1813: --
1814: hr_utility.trace('POST_PROCESS_RULE: g_veh_rcd_id='||g_veh_rcd_id);
1815:
1816: -- Loop through all people extracted
1817: FOR ext_asg_rec IN csr_ext_asg LOOP
1818:

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

1821:
1822: g_person_id := ext_asg_rec.person_id;
1823: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1824: --
1825: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1826: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1827:
1828: -- Fetch in full detail record for primary assignment
1829: -- Delete balance detail record if mileage ASG_YTD balance is zero

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

1822: g_person_id := ext_asg_rec.person_id;
1823: g_bg_id := get_bus_group_id(ext_asg_rec.asg_id);
1824: --
1825: hr_utility.trace('POST_PROCESS_RULE: ext_asg_rec.asg_id='||ext_asg_rec.asg_id);
1826: hr_utility.trace('POST_PROCESS_RULE: g_person_id='||g_person_id);
1827:
1828: -- Fetch in full detail record for primary assignment
1829: -- Delete balance detail record if mileage ASG_YTD balance is zero
1830: OPEN csr_balance_detail(ext_asg_rec.person_id);

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

1830: OPEN csr_balance_detail(ext_asg_rec.person_id);
1831: FETCH csr_balance_detail INTO l_balance_detail;
1832: CLOSE csr_balance_detail;
1833: --
1834: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.ext_rslt_dtl_id= '||l_balance_detail.ext_rslt_dtl_id);
1835: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.val_12(mileage balance)= '||l_balance_detail.val_12);
1836:
1837: --
1838: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);

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

1831: FETCH csr_balance_detail INTO l_balance_detail;
1832: CLOSE csr_balance_detail;
1833: --
1834: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.ext_rslt_dtl_id= '||l_balance_detail.ext_rslt_dtl_id);
1835: hr_utility.trace('POST_PROCESS_RULE: l_balance_detail.val_12(mileage balance)= '||l_balance_detail.val_12);
1836:
1837: --
1838: l_asg_include := check_asg_inclusion(ext_asg_rec.asg_id);
1839:

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

1840: IF l_balance_detail.ext_rslt_dtl_id IS NOT NULL AND l_asg_include = 'N'
1841: THEN
1842: -- Primary assignment does not qualify for extract
1843: -- Delete this detail record
1844: hr_utility.trace('Primary asg does not qualify for extract - deleting detail record');
1845: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
1846: p_object_version_number => l_balance_detail.object_version_number);
1847:
1848:

Line 1854: hr_utility.trace('First l_balance_detail.ext_rslt_dtl_id: '||l_balance_detail.ext_rslt_dtl_id);

1850: -- Include this Assignment
1851: process_car_04(ext_asg_rec.asg_id);
1852: process_motorcycle_04(ext_asg_rec.asg_id);
1853: process_pedal_cycle_04(ext_asg_rec.asg_id);
1854: hr_utility.trace('First l_balance_detail.ext_rslt_dtl_id: '||l_balance_detail.ext_rslt_dtl_id);
1855:
1856: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => l_balance_detail.ext_rslt_dtl_id,
1857: p_object_version_number => l_balance_detail.object_version_number);
1858:

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

1865: --
1866: -- Process any secondary assignments which may qualify
1867: process_sec_asg(ext_asg_rec.asg_id);
1868: --
1869: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1870: l_obj_no := ext_asg_rec.object_version_number;
1871:
1872: -- Delete this assignment details record
1873: hr_utility.trace('This is not needed ext_asg_rec.ext_rslt_dtl_id: '||ext_asg_rec.ext_rslt_dtl_id);

Line 1873: hr_utility.trace('This is not needed ext_asg_rec.ext_rslt_dtl_id: '||ext_asg_rec.ext_rslt_dtl_id);

1869: hr_utility.trace('POST_PROCESS_RULE: Assignment processed, remove it from the extract details table.');
1870: l_obj_no := ext_asg_rec.object_version_number;
1871:
1872: -- Delete this assignment details record
1873: hr_utility.trace('This is not needed ext_asg_rec.ext_rslt_dtl_id: '||ext_asg_rec.ext_rslt_dtl_id);
1874: ben_ext_rslt_dtl_api.delete_ext_rslt_dtl(p_ext_rslt_dtl_id => ext_asg_rec.ext_rslt_dtl_id,
1875: p_object_version_number => l_obj_no);
1876:
1877: --

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

1876:
1877: --
1878: END LOOP;
1879: --
1880: hr_utility.trace('Leaving Post_process_rule.');
1881: RETURN 'Y';
1882: --
1883: exception
1884:

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

1883: exception
1884:
1885: when others then
1886:
1887: hr_utility.set_location('post_process_rule',999);
1888: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1889: raise;
1890:
1891: end post_process_rule;

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

1884:
1885: when others then
1886:
1887: hr_utility.set_location('post_process_rule',999);
1888: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1889: raise;
1890:
1891: end post_process_rule;
1892:

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

1911: l_asg_id NUMBER;
1912:
1913: BEGIN
1914:
1915: hr_utility.trace('Entering CHECK_PERSON_INCLUSION, p_assignment_id='||p_assignment_id);
1916:
1917: -- check whether any assignment qualifies
1918: OPEN get_all_asg;
1919: LOOP

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

1925: EXIT WHEN (get_all_asg%NOTFOUND OR l_person_include = 'Y');
1926:
1927: END LOOP;
1928: --
1929: hr_utility.trace('Leaving CHECK_PERSON_INCLUSION, l_person_include='||l_person_include);
1930:
1931: RETURN l_person_include;
1932: --
1933: END check_person_inclusion;

Line 1962: hr_utility.trace('Entering get_data_element_value');

1958: l_ext_start_date date;
1959: l_ext_end_date date;
1960: begin
1961:
1962: hr_utility.trace('Entering get_data_element_value');
1963: hr_utility.trace('p_assignment_id= '|| p_assignment_id);
1964: hr_utility.trace('p_rule_parameter= '|| p_rule_parameter);
1965:
1966: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));

Line 1963: hr_utility.trace('p_assignment_id= '|| p_assignment_id);

1959: l_ext_end_date date;
1960: begin
1961:
1962: hr_utility.trace('Entering get_data_element_value');
1963: hr_utility.trace('p_assignment_id= '|| p_assignment_id);
1964: hr_utility.trace('p_rule_parameter= '|| p_rule_parameter);
1965:
1966: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1967:

Line 1964: hr_utility.trace('p_rule_parameter= '|| p_rule_parameter);

1960: begin
1961:
1962: hr_utility.trace('Entering get_data_element_value');
1963: hr_utility.trace('p_assignment_id= '|| p_assignment_id);
1964: hr_utility.trace('p_rule_parameter= '|| p_rule_parameter);
1965:
1966: l_ext_end_date := get_param_ext_end_date(get_bus_group_id(p_assignment_id));
1967:
1968: l_ext_start_date := get_param_ext_start_date(get_bus_group_id(p_assignment_id));

Line 1985: hr_utility.set_location('get_data_element_value',999);

1981:
1982: exception
1983:
1984: when others then
1985: hr_utility.set_location('get_data_element_value',999);
1986: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1987: raise;
1988:
1989: end get_data_element_value;

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

1982: exception
1983:
1984: when others then
1985: hr_utility.set_location('get_data_element_value',999);
1986: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
1987: raise;
1988:
1989: end get_data_element_value;
1990:

Line 2040: hr_utility.set_location('Entering get_mil_claim_values',1);

2036:
2037: l_def_bal t_def_bal;
2038: begin
2039:
2040: hr_utility.set_location('Entering get_mil_claim_values',1);
2041:
2042: -- get necessary data
2043: l_bus_group_id := get_bus_group_id(p_assignment_id);
2044:

Line 2072: hr_utility.set_location('inside odd',8);

2068: -- and latest assignment actions just obtained
2069:
2070: if l_odd_even_marker = 'ODD'
2071: then
2072: hr_utility.set_location('inside odd',8);
2073:
2074: --if (p_vehicle_type = 'Car')then
2075: if (p_vehicle_type = 'Car or Van')then
2076: --car starts

Line 2148: hr_utility.set_location('inside Even',8);

2144: end if;
2145:
2146: -- l_odd_even_marker is EVEN
2147: else
2148: hr_utility.set_location('inside Even',8);
2149:
2150: --if (p_vehicle_type = 'Car')then
2151: if (p_vehicle_type = 'Car or Van')then
2152: --car starts

Line 2226: hr_utility.set_location('Before invoking get_bal_value',8);

2222:
2223: end if;
2224: ----------
2225:
2226: hr_utility.set_location('Before invoking get_bal_value',8);
2227: p_mileage_allowance_payments := get_bal_value (l_map_bal_string
2228: ,l_asg_act_id_ext
2229: ,l_asg_act_id_tye);
2230: hr_utility.set_location('p_mileage_allowance_payments: '||p_mileage_allowance_payments,8);

Line 2230: hr_utility.set_location('p_mileage_allowance_payments: '||p_mileage_allowance_payments,8);

2226: hr_utility.set_location('Before invoking get_bal_value',8);
2227: p_mileage_allowance_payments := get_bal_value (l_map_bal_string
2228: ,l_asg_act_id_ext
2229: ,l_asg_act_id_tye);
2230: hr_utility.set_location('p_mileage_allowance_payments: '||p_mileage_allowance_payments,8);
2231:
2232: ---
2233: hr_utility.set_location('Before invoking get_bal_value',8);
2234: p_tax_deducted_payments := get_bal_value (l_tdp_bal_string

Line 2233: hr_utility.set_location('Before invoking get_bal_value',8);

2229: ,l_asg_act_id_tye);
2230: hr_utility.set_location('p_mileage_allowance_payments: '||p_mileage_allowance_payments,8);
2231:
2232: ---
2233: hr_utility.set_location('Before invoking get_bal_value',8);
2234: p_tax_deducted_payments := get_bal_value (l_tdp_bal_string
2235: ,l_asg_act_id_ext
2236: ,l_asg_act_id_tye);
2237: hr_utility.set_location('p_tax_deducted_payments: '||p_tax_deducted_payments,8);

Line 2237: hr_utility.set_location('p_tax_deducted_payments: '||p_tax_deducted_payments,8);

2233: hr_utility.set_location('Before invoking get_bal_value',8);
2234: p_tax_deducted_payments := get_bal_value (l_tdp_bal_string
2235: ,l_asg_act_id_ext
2236: ,l_asg_act_id_tye);
2237: hr_utility.set_location('p_tax_deducted_payments: '||p_tax_deducted_payments,8);
2238:
2239: --
2240: hr_utility.set_location('Before invoking get_bal_value',8);
2241: p_business_miles := get_bal_value (l_bm_bal_string

Line 2240: hr_utility.set_location('Before invoking get_bal_value',8);

2236: ,l_asg_act_id_tye);
2237: hr_utility.set_location('p_tax_deducted_payments: '||p_tax_deducted_payments,8);
2238:
2239: --
2240: hr_utility.set_location('Before invoking get_bal_value',8);
2241: p_business_miles := get_bal_value (l_bm_bal_string
2242: ,l_asg_act_id_ext
2243: ,l_asg_act_id_tye);
2244: hr_utility.set_location('p_business_miles: '||p_business_miles,8);

Line 2244: hr_utility.set_location('p_business_miles: '||p_business_miles,8);

2240: hr_utility.set_location('Before invoking get_bal_value',8);
2241: p_business_miles := get_bal_value (l_bm_bal_string
2242: ,l_asg_act_id_ext
2243: ,l_asg_act_id_tye);
2244: hr_utility.set_location('p_business_miles: '||p_business_miles,8);
2245:
2246: --
2247: hr_utility.set_location('Before invoking get_bal_value',8);
2248: p_taxable_payments := get_bal_value (l_tp_bal_string

Line 2247: hr_utility.set_location('Before invoking get_bal_value',8);

2243: ,l_asg_act_id_tye);
2244: hr_utility.set_location('p_business_miles: '||p_business_miles,8);
2245:
2246: --
2247: hr_utility.set_location('Before invoking get_bal_value',8);
2248: p_taxable_payments := get_bal_value (l_tp_bal_string
2249: ,l_asg_act_id_ext
2250: ,l_asg_act_id_tye);
2251: hr_utility.set_location('p_taxable_payments: '||p_taxable_payments,8);

Line 2251: hr_utility.set_location('p_taxable_payments: '||p_taxable_payments,8);

2247: hr_utility.set_location('Before invoking get_bal_value',8);
2248: p_taxable_payments := get_bal_value (l_tp_bal_string
2249: ,l_asg_act_id_ext
2250: ,l_asg_act_id_tye);
2251: hr_utility.set_location('p_taxable_payments: '||p_taxable_payments,8);
2252:
2253: --
2254: hr_utility.set_location('Before invoking get_bal_value',8);
2255: p_passenger_payments := get_bal_value (l_pp_bal_string

Line 2254: hr_utility.set_location('Before invoking get_bal_value',8);

2250: ,l_asg_act_id_tye);
2251: hr_utility.set_location('p_taxable_payments: '||p_taxable_payments,8);
2252:
2253: --
2254: hr_utility.set_location('Before invoking get_bal_value',8);
2255: p_passenger_payments := get_bal_value (l_pp_bal_string
2256: ,l_asg_act_id_ext
2257: ,l_asg_act_id_tye);
2258: hr_utility.set_location('p_passenger_payments: '||p_passenger_payments,8);

Line 2258: hr_utility.set_location('p_passenger_payments: '||p_passenger_payments,8);

2254: hr_utility.set_location('Before invoking get_bal_value',8);
2255: p_passenger_payments := get_bal_value (l_pp_bal_string
2256: ,l_asg_act_id_ext
2257: ,l_asg_act_id_tye);
2258: hr_utility.set_location('p_passenger_payments: '||p_passenger_payments,8);
2259:
2260: --
2261: hr_utility.set_location('Before invoking get_bal_value',8);
2262: p_passenger_business_miles := get_bal_value (l_pbm_bal_string

Line 2261: hr_utility.set_location('Before invoking get_bal_value',8);

2257: ,l_asg_act_id_tye);
2258: hr_utility.set_location('p_passenger_payments: '||p_passenger_payments,8);
2259:
2260: --
2261: hr_utility.set_location('Before invoking get_bal_value',8);
2262: p_passenger_business_miles := get_bal_value (l_pbm_bal_string
2263: ,l_asg_act_id_ext
2264: ,l_asg_act_id_tye);
2265: hr_utility.set_location('p_passenger_business_miles: '||p_passenger_business_miles,8);

Line 2265: hr_utility.set_location('p_passenger_business_miles: '||p_passenger_business_miles,8);

2261: hr_utility.set_location('Before invoking get_bal_value',8);
2262: p_passenger_business_miles := get_bal_value (l_pbm_bal_string
2263: ,l_asg_act_id_ext
2264: ,l_asg_act_id_tye);
2265: hr_utility.set_location('p_passenger_business_miles: '||p_passenger_business_miles,8);
2266:
2267: --
2268: hr_utility.set_location('Before invoking get_bal_value',8);
2269: p_taxable_passenger_payments := get_bal_value (l_tpp_bal_string

Line 2268: hr_utility.set_location('Before invoking get_bal_value',8);

2264: ,l_asg_act_id_tye);
2265: hr_utility.set_location('p_passenger_business_miles: '||p_passenger_business_miles,8);
2266:
2267: --
2268: hr_utility.set_location('Before invoking get_bal_value',8);
2269: p_taxable_passenger_payments := get_bal_value (l_tpp_bal_string
2270: ,l_asg_act_id_ext
2271: ,l_asg_act_id_tye);
2272: hr_utility.set_location('p_taxable_passenger_payments: '||p_taxable_passenger_payments,8);

Line 2272: hr_utility.set_location('p_taxable_passenger_payments: '||p_taxable_passenger_payments,8);

2268: hr_utility.set_location('Before invoking get_bal_value',8);
2269: p_taxable_passenger_payments := get_bal_value (l_tpp_bal_string
2270: ,l_asg_act_id_ext
2271: ,l_asg_act_id_tye);
2272: hr_utility.set_location('p_taxable_passenger_payments: '||p_taxable_passenger_payments,8);
2273:
2274: return to_char(5000); -- This return value is just a dummy value
2275:
2276: exception

Line 2279: hr_utility.set_location('get_mil_claim_values',999);

2275:
2276: exception
2277:
2278: when others then
2279: hr_utility.set_location('get_mil_claim_values',999);
2280: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
2281: raise;
2282:
2283: end get_mil_claim_values;

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

2276: exception
2277:
2278: when others then
2279: hr_utility.set_location('get_mil_claim_values',999);
2280: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
2281: raise;
2282:
2283: end get_mil_claim_values;
2284:

Line 2314: hr_utility.trace('Entering get_bal_value');

2310: l_def_bal t_def_bal;
2311:
2312: begin
2313:
2314: hr_utility.trace('Entering get_bal_value');
2315: hr_utility.trace('p_bal_string = '|| p_bal_string);
2316: hr_utility.trace('p_asg_act_id_ext = '|| p_asg_act_id_ext);
2317: hr_utility.trace('p_asg_act_id_tye = '|| p_asg_act_id_tye);
2318:

Line 2315: hr_utility.trace('p_bal_string = '|| p_bal_string);

2311:
2312: begin
2313:
2314: hr_utility.trace('Entering get_bal_value');
2315: hr_utility.trace('p_bal_string = '|| p_bal_string);
2316: hr_utility.trace('p_asg_act_id_ext = '|| p_asg_act_id_ext);
2317: hr_utility.trace('p_asg_act_id_tye = '|| p_asg_act_id_tye);
2318:
2319: if p_bal_string is not null then

Line 2316: hr_utility.trace('p_asg_act_id_ext = '|| p_asg_act_id_ext);

2312: begin
2313:
2314: hr_utility.trace('Entering get_bal_value');
2315: hr_utility.trace('p_bal_string = '|| p_bal_string);
2316: hr_utility.trace('p_asg_act_id_ext = '|| p_asg_act_id_ext);
2317: hr_utility.trace('p_asg_act_id_tye = '|| p_asg_act_id_tye);
2318:
2319: if p_bal_string is not null then
2320: l_ext_balance_temp := 0;

Line 2317: hr_utility.trace('p_asg_act_id_tye = '|| p_asg_act_id_tye);

2313:
2314: hr_utility.trace('Entering get_bal_value');
2315: hr_utility.trace('p_bal_string = '|| p_bal_string);
2316: hr_utility.trace('p_asg_act_id_ext = '|| p_asg_act_id_ext);
2317: hr_utility.trace('p_asg_act_id_tye = '|| p_asg_act_id_tye);
2318:
2319: if p_bal_string is not null then
2320: l_ext_balance_temp := 0;
2321: l_ext_balance := 0;

Line 2337: hr_utility.set_location('after l_sql_stmt: ',8);

2333: and pdb.balance_dimension_id = pbd.balance_dimension_id
2334: and pbd.dimension_name = '||'''_ASG_TD_YTD'''||
2335: 'and pbt.balance_name in ' || p_bal_string ;
2336:
2337: hr_utility.set_location('after l_sql_stmt: ',8);
2338:
2339: EXECUTE IMMEDIATE l_sql_stmt bulk collect into l_def_bal;
2340:
2341: if l_def_bal.FIRST is not null then

Line 2359: hr_utility.trace('l_balance_amt: '||l_balance_amt );

2355:
2356: END LOOP;
2357: end if;
2358:
2359: hr_utility.trace('l_balance_amt: '||l_balance_amt );
2360: l_balance_amt := 0;
2361:
2362: if l_tye_balance <> l_ext_balance
2363: -- e.g. if user has processed back-dated mileage claims after TYE so balance

Line 2381: hr_utility.set_location('get_bal_value',999);

2377: return to_char(l_balance_amt);
2378: exception
2379:
2380: when others then
2381: hr_utility.set_location('get_bal_value',999);
2382: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
2383: raise;
2384:
2385: end get_bal_value;

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

2378: exception
2379:
2380: when others then
2381: hr_utility.set_location('get_bal_value',999);
2382: hr_utility.trace('SQLERRM: '||substr(sqlerrm,1,200));
2383: raise;
2384:
2385: end get_bal_value;
2386: