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.PQH_LENGTH_OF_SERVICE_PKG dependencies on HR_UTILITY

Line 29: hr_utility.set_location('Erroring out from '||l_proc,5);

25: When No_Data_Found Then
26: l_date := Sysdate;
27: RETURN l_date;
28: When Others THEN
29: hr_utility.set_location('Erroring out from '||l_proc,5);
30: RAISE_Application_Error(-20001,SQLERRM);
31: END get_effective_date;
32:
33:

Line 75: hr_utility.set_location('Erroring out from '||l_proc,5);

71: When Others THEN
72: p_bg_normal_day_hours := null;
73: p_bg_normal_hours := null;
74: p_bg_frequency := null;
75: hr_utility.set_location('Erroring out from '||l_proc,5);
76: RAISE_Application_Error(-20001,SQLERRM);
77: END;
78:
79:

Line 90: hr_utility.set_location('Entering '||l_proc,1);

86: l_proc varchar2(60) := g_package||'get_working_time_ratio';
87: l_working_time_ratio NUMBER(4,2) := 1;
88: l_asg_hours NUMBER(22,3) := 0;
89: BEGIN
90: hr_utility.set_location('Entering '||l_proc,1);
91: IF p_bg_frequency = 'D' THEN
92: IF p_asg_frequency = 'W' THEN
93: l_asg_hours := p_asg_hours/5; --(one week is taken as 5 days)
94: ELSIF p_asg_frequency = 'M' THEN

Line 130: hr_utility.set_location('Erroring out from '||l_proc,5);

126:
127: RETURN l_working_time_ratio;
128: EXCEPTION
129: When Others THEN
130: hr_utility.set_location('Erroring out from '||l_proc,5);
131: RAISE_Application_Error(-20001,SQLERRM);
132:
133: END get_working_time_ratio;
134:

Line 185: hr_utility.set_location ('emp_type is NULL',10);

181:
182: CLOSE csr_emp_type;
183:
184: IF l_emp_type IS NULL THEN
185: hr_utility.set_location ('emp_type is NULL',10);
186: RETURN TO_CHAR(NULL);
187: END IF;
188:
189: hr_utility.set_location ('emp_type is '||l_emp_type||' '||l_proc,10);

Line 189: hr_utility.set_location ('emp_type is '||l_emp_type||' '||l_proc,10);

185: hr_utility.set_location ('emp_type is NULL',10);
186: RETURN TO_CHAR(NULL);
187: END IF;
188:
189: hr_utility.set_location ('emp_type is '||l_emp_type||' '||l_proc,10);
190: RETURN l_emp_type;
191: EXCEPTION
192: When Others THEN
193: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 193: hr_utility.set_location('Erroring out from '||l_proc,5);

189: hr_utility.set_location ('emp_type is '||l_emp_type||' '||l_proc,10);
190: RETURN l_emp_type;
191: EXCEPTION
192: When Others THEN
193: hr_utility.set_location('Erroring out from '||l_proc,5);
194: RAISE_Application_Error(-20001,SQLERRM);
195: END get_employee_type;
196:
197: -- -----------------------------------------------------------------------*

Line 252: hr_utility.set_location('Entering '||l_proc,1);

248: AND employee_type = p_emp_type
249: AND g_determination_date BETWEEN effective_start_date AND NVL(effective_end_date,g_end_of_time)
250: AND entitlement_flag = 'Y';
251: BEGIN
252: hr_utility.set_location('Entering '||l_proc,1);
253: -- get the BG normal day hours for converting absence hours to days
254: bg_normal_hours(p_bg_id => p_bg_id,
255: p_bg_normal_day_hours => l_bg_normal_day_hours,
256: p_bg_normal_hours => l_bg_normal_hours,

Line 275: hr_utility.set_location(l_proc||' Net Absence Duration '||l_net_absence,2);

271: CLOSE Csr_absence_entitlements;
272: l_net_absence := l_net_absence + (l_absence_duration * (1-(NVL(l_entitlement,0)/100)) );
273: END LOOP;
274: END IF;
275: hr_utility.set_location(l_proc||' Net Absence Duration '||l_net_absence,2);
276: RETURN l_net_absence;
277: EXCEPTION
278: When Others THEN
279: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 279: hr_utility.set_location('Erroring out from '||l_proc,5);

275: hr_utility.set_location(l_proc||' Net Absence Duration '||l_net_absence,2);
276: RETURN l_net_absence;
277: EXCEPTION
278: When Others THEN
279: hr_utility.set_location('Erroring out from '||l_proc,5);
280: RAISE_Application_Error(-20001,SQLERRM);
281: END get_absent_period;
282:
283: -- -----------------------------------------------------------------------*

Line 334: hr_utility.set_location('Entering '||l_proc,1);

330: AND employee_type = l_emp_type
331: AND entitlement_flag = 'Y'
332: AND g_determination_date BETWEEN effective_start_date AND NVL(effective_end_date,g_end_of_time);
333: BEGIN
334: hr_utility.set_location('Entering '||l_proc,1);
335: bg_normal_hours(p_bg_id, l_bg_normal_day, l_bg_hours,l_bg_frequency);
336: hr_utility.set_location(l_proc||' BG Normal Hours '||l_bg_hours||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
338: l_emp_type := g_emp_type;

Line 336: hr_utility.set_location(l_proc||' BG Normal Hours '||l_bg_hours||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);

332: AND g_determination_date BETWEEN effective_start_date AND NVL(effective_end_date,g_end_of_time);
333: BEGIN
334: hr_utility.set_location('Entering '||l_proc,1);
335: bg_normal_hours(p_bg_id, l_bg_normal_day, l_bg_hours,l_bg_frequency);
336: hr_utility.set_location(l_proc||' BG Normal Hours '||l_bg_hours||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
338: l_emp_type := g_emp_type;
339:
340: hr_utility.set_location(l_proc||'Emp Type '||l_emp_type,2);

Line 337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);

333: BEGIN
334: hr_utility.set_location('Entering '||l_proc,1);
335: bg_normal_hours(p_bg_id, l_bg_normal_day, l_bg_hours,l_bg_frequency);
336: hr_utility.set_location(l_proc||' BG Normal Hours '||l_bg_hours||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
338: l_emp_type := g_emp_type;
339:
340: hr_utility.set_location(l_proc||'Emp Type '||l_emp_type,2);
341: hr_utility.set_location(l_proc||'Assignment ID '||p_assignment_id,2);

Line 340: hr_utility.set_location(l_proc||'Emp Type '||l_emp_type,2);

336: hr_utility.set_location(l_proc||' BG Normal Hours '||l_bg_hours||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
338: l_emp_type := g_emp_type;
339:
340: hr_utility.set_location(l_proc||'Emp Type '||l_emp_type,2);
341: hr_utility.set_location(l_proc||'Assignment ID '||p_assignment_id,2);
342: IF l_emp_type IS NOT NULL THEN
343: FOR lr_employment_catg IN Csr_employment_category
344: LOOP

Line 341: hr_utility.set_location(l_proc||'Assignment ID '||p_assignment_id,2);

337: hr_utility.set_location(l_proc||'Determination Date'||to_char(p_end_date,'dd-mm-RRRR')||l_bg_frequency,2);
338: l_emp_type := g_emp_type;
339:
340: hr_utility.set_location(l_proc||'Emp Type '||l_emp_type,2);
341: hr_utility.set_location(l_proc||'Assignment ID '||p_assignment_id,2);
342: IF l_emp_type IS NOT NULL THEN
343: FOR lr_employment_catg IN Csr_employment_category
344: LOOP
345: l_emp_catg := lr_employment_catg.employment_category;

Line 353: hr_utility.set_location(l_proc||' period '||to_char(lr_employment_catg.effective_start_date,'dd-mm-RRRR')||to_char(lr_employment_catg.effective_end_date,'dd-mm-RRRR'),3);

349: IF lr_employment_catg.effective_start_date < p_start_date THEN
350: lr_employment_catg.effective_start_date := p_start_date;
351: END IF;
352:
353: hr_utility.set_location(l_proc||' period '||to_char(lr_employment_catg.effective_start_date,'dd-mm-RRRR')||to_char(lr_employment_catg.effective_end_date,'dd-mm-RRRR'),3);
354: l_temp_duration := lr_employment_catg.effective_end_date - lr_employment_catg.effective_start_date+1;
355: hr_utility.set_location(l_proc||' temp duration'||l_temp_duration,3);
356: IF l_emp_catg IN ('PT','PR') THEN
357:

Line 355: hr_utility.set_location(l_proc||' temp duration'||l_temp_duration,3);

351: END IF;
352:
353: hr_utility.set_location(l_proc||' period '||to_char(lr_employment_catg.effective_start_date,'dd-mm-RRRR')||to_char(lr_employment_catg.effective_end_date,'dd-mm-RRRR'),3);
354: l_temp_duration := lr_employment_catg.effective_end_date - lr_employment_catg.effective_start_date+1;
355: hr_utility.set_location(l_proc||' temp duration'||l_temp_duration,3);
356: IF l_emp_catg IN ('PT','PR') THEN
357:
358: hr_utility.set_location(l_proc,3);
359: OPEN Csr_parttime_entitlements;

Line 358: hr_utility.set_location(l_proc,3);

354: l_temp_duration := lr_employment_catg.effective_end_date - lr_employment_catg.effective_start_date+1;
355: hr_utility.set_location(l_proc||' temp duration'||l_temp_duration,3);
356: IF l_emp_catg IN ('PT','PR') THEN
357:
358: hr_utility.set_location(l_proc,3);
359: OPEN Csr_parttime_entitlements;
360: FETCH Csr_parttime_entitlements INTO l_work_proportional,
361: l_parttime_entitlement;
362: IF csr_parttime_entitlements%FOUND THEN

Line 382: hr_utility.set_location(l_proc||' l_asg_duration in loop '||l_asg_duration,2);

378:
379: CLOSE Csr_parttime_entitlements;
380:
381: END IF;
382: hr_utility.set_location(l_proc||' l_asg_duration in loop '||l_asg_duration,2);
383: l_asg_duration := l_asg_duration + l_temp_duration;
384: END LOOP;
385: ELSE
386: l_asg_duration := p_end_date - p_start_date;

Line 388: hr_utility.set_location(l_proc||' returning duration '||l_asg_duration,2);

384: END LOOP;
385: ELSE
386: l_asg_duration := p_end_date - p_start_date;
387: END IF;
388: hr_utility.set_location(l_proc||' returning duration '||l_asg_duration,2);
389: RETURN l_asg_duration;
390: EXCEPTION
391: When Others THEN
392: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 392: hr_utility.set_location('Erroring out from '||l_proc,5);

388: hr_utility.set_location(l_proc||' returning duration '||l_asg_duration,2);
389: RETURN l_asg_duration;
390: EXCEPTION
391: When Others THEN
392: hr_utility.set_location('Erroring out from '||l_proc,5);
393: RAISE_Application_Error(-20001,SQLERRM);
394: END get_parttime_entitlement;
395:
396: -- -----------------------------------------------------------------------*

Line 410: hr_utility.set_location('Entering '||l_proc,1);

406: l_prev_emp_period NUMBER(22,3) := 0;
407: l_proc varchar2(60) := g_package||'get_previous_employment';
408:
409: BEGIN
410: hr_utility.set_location('Entering '||l_proc,1);
411: RETURN l_prev_emp_period;
412: EXCEPTION
413: When Others THEN
414: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 414: hr_utility.set_location('Erroring out from '||l_proc,5);

410: hr_utility.set_location('Entering '||l_proc,1);
411: RETURN l_prev_emp_period;
412: EXCEPTION
413: When Others THEN
414: hr_utility.set_location('Erroring out from '||l_proc,5);
415: RAISE_Application_Error(-20001,SQLERRM);
416: END;
417:
418: -- -----------------------------------------------------------------------*

Line 513: hr_utility.set_location('Entering '||l_proc,1);

509: primary_flag = 'Y'
510: and
511: sysdate between effective_start_date and effective_end_date;
512: BEGIN
513: hr_utility.set_location('Entering '||l_proc,1);
514: for prev_job in csr_prev_job loop
515: l_emp_type := prev_job.emp_type;
516: l_all_assignments := prev_job.all_assignments;
517: l_entitlement := 0;

Line 574: hr_utility.set_location('Leaving from '||l_proc,5);

570:
571: l_temp_duration := trunc(l_entitlement*l_temp_duration/100.0);
572: end if;
573: end loop;
574: hr_utility.set_location('Leaving from '||l_proc,5);
575: RETURN l_temp_duration;
576: EXCEPTION
577: When Others THEN
578: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 578: hr_utility.set_location('Erroring out from '||l_proc,5);

574: hr_utility.set_location('Leaving from '||l_proc,5);
575: RETURN l_temp_duration;
576: EXCEPTION
577: When Others THEN
578: hr_utility.set_location('Erroring out from '||l_proc,5);
579: RAISE_Application_Error(-20001,SQLERRM);
580: END;
581:
582: -- -----------------------------------------------------------------------*

Line 606: hr_utility.set_location('Entering '||l_proc,1);

602: AND peit.pei_information1 = p_los_type
603: AND p_effective_date between fnd_date.canonical_to_date(peit.pei_information2)
604: AND NVL(fnd_date.canonical_to_date(peit.pei_information3),g_end_of_time);
605: BEGIN
606: hr_utility.set_location('Entering '||l_proc,1);
607: OPEN Csr_correction;
608: FETCH Csr_correction INTO l_correct_days;
609: CLOSE Csr_correction;
610: hr_utility.set_location(l_proc||' Correction Factor '||l_correct_days,2);

Line 610: hr_utility.set_location(l_proc||' Correction Factor '||l_correct_days,2);

606: hr_utility.set_location('Entering '||l_proc,1);
607: OPEN Csr_correction;
608: FETCH Csr_correction INTO l_correct_days;
609: CLOSE Csr_correction;
610: hr_utility.set_location(l_proc||' Correction Factor '||l_correct_days,2);
611: RETURN l_correct_days;
612: EXCEPTION
613: When Others THEN
614: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 614: hr_utility.set_location('Erroring out from '||l_proc,5);

610: hr_utility.set_location(l_proc||' Correction Factor '||l_correct_days,2);
611: RETURN l_correct_days;
612: EXCEPTION
613: When Others THEN
614: hr_utility.set_location('Erroring out from '||l_proc,5);
615: RAISE_Application_Error(-20001,SQLERRM);
616: END get_correction_factor;
617:
618: -- -----------------------------------------------------------------------*

Line 655: hr_utility.set_location('Entering '||l_proc,1);

651: AND (NVL(fnd_date.canonical_to_date(pei_information3),g_end_of_time) BETWEEN p_start_date AND p_end_date
652: OR fnd_date.canonical_to_date(pei_information2) BETWEEN p_start_date AND p_end_date );
653:
654: BEGIN
655: hr_utility.set_location('Entering '||l_proc,1);
656: l_emp_type := get_employee_type(p_person_id => p_person_id,
657: p_determination_date => p_end_date);
658: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);
659: IF l_emp_type IS NOT NULL THEN

Line 658: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);

654: BEGIN
655: hr_utility.set_location('Entering '||l_proc,1);
656: l_emp_type := get_employee_type(p_person_id => p_person_id,
657: p_determination_date => p_end_date);
658: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);
659: IF l_emp_type IS NOT NULL THEN
660: OPEN csr_military_entitlement;
661: FETCH csr_military_entitlement INTO l_entitlement_value;
662: CLOSE csr_military_entitlement;

Line 663: hr_utility.set_location(l_proc||' military entitlement '||l_entitlement_value,1);

659: IF l_emp_type IS NOT NULL THEN
660: OPEN csr_military_entitlement;
661: FETCH csr_military_entitlement INTO l_entitlement_value;
662: CLOSE csr_military_entitlement;
663: hr_utility.set_location(l_proc||' military entitlement '||l_entitlement_value,1);
664: FOR lr_military IN csr_military_periods
665: LOOP
666: l_military_duration := l_military_duration + fnd_number.canonical_to_number(lr_military.length_of_service)*(NVL(l_entitlement_value,0)/100);
667: END LOOP;

Line 669: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);

665: LOOP
666: l_military_duration := l_military_duration + fnd_number.canonical_to_number(lr_military.length_of_service)*(NVL(l_entitlement_value,0)/100);
667: END LOOP;
668: END IF;
669: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);
670: RETURN l_military_duration;
671: EXCEPTION
672: When Others THEN
673: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 673: hr_utility.set_location('Erroring out from '||l_proc,5);

669: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);
670: RETURN l_military_duration;
671: EXCEPTION
672: When Others THEN
673: hr_utility.set_location('Erroring out from '||l_proc,5);
674: RAISE_Application_Error(-20001,SQLERRM);
675: END get_military_service_period;
676:
677: -- -----------------------------------------------------------------------*

Line 715: hr_utility.set_location('Entering '||l_proc,1);

711: l_parttime_duration NUMBER(22,3) := 0;
712: l_proc varchar2(60) := g_package||'get_gen_pub_LOS';
713:
714: BEGIN
715: hr_utility.set_location('Entering '||l_proc,1);
716: OPEN csr_service_start_date;
717: FETCH csr_service_start_date INTO l_start_date;
718: CLOSE csr_service_start_date;
719: hr_utility.set_location(l_proc,2);

Line 719: hr_utility.set_location(l_proc,2);

715: hr_utility.set_location('Entering '||l_proc,1);
716: OPEN csr_service_start_date;
717: FETCH csr_service_start_date INTO l_start_date;
718: CLOSE csr_service_start_date;
719: hr_utility.set_location(l_proc,2);
720: -- get the actual assignment period
721: hr_utility.set_location(l_proc||'person_id'||p_person_id||'assignment_id'||p_assignment_id||'start_date '||to_char(l_start_date,'dd-mm-RRRR'),3);
722: l_asg_duration := p_determination_date - l_start_date+1;
723: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);

Line 721: hr_utility.set_location(l_proc||'person_id'||p_person_id||'assignment_id'||p_assignment_id||'start_date '||to_char(l_start_date,'dd-mm-RRRR'),3);

717: FETCH csr_service_start_date INTO l_start_date;
718: CLOSE csr_service_start_date;
719: hr_utility.set_location(l_proc,2);
720: -- get the actual assignment period
721: hr_utility.set_location(l_proc||'person_id'||p_person_id||'assignment_id'||p_assignment_id||'start_date '||to_char(l_start_date,'dd-mm-RRRR'),3);
722: l_asg_duration := p_determination_date - l_start_date+1;
723: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);
724: -- findout any Impact because of Parttime entitlements defined for the LOS type
725: l_parttime_duration := get_parttime_entitlement(p_person_id => p_person_id,

Line 723: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);

719: hr_utility.set_location(l_proc,2);
720: -- get the actual assignment period
721: hr_utility.set_location(l_proc||'person_id'||p_person_id||'assignment_id'||p_assignment_id||'start_date '||to_char(l_start_date,'dd-mm-RRRR'),3);
722: l_asg_duration := p_determination_date - l_start_date+1;
723: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);
724: -- findout any Impact because of Parttime entitlements defined for the LOS type
725: l_parttime_duration := get_parttime_entitlement(p_person_id => p_person_id,
726: p_assignment_id => p_assignment_id,
727: p_bg_id => p_bg_id,

Line 731: hr_utility.set_location(l_proc||' Post Parttime Entitlement Duration '||l_parttime_duration,4);

727: p_bg_id => p_bg_id,
728: p_los_type => p_los_type,
729: p_start_date => l_start_date,
730: p_end_date => p_determination_date);
731: hr_utility.set_location(l_proc||' Post Parttime Entitlement Duration '||l_parttime_duration,4);
732: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
733: p_assignment_id => p_assignment_id,
734: p_start_date => l_start_date,
735: p_end_date => p_determination_date);

Line 736: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_prev_employment,5);

732: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
733: p_assignment_id => p_assignment_id,
734: p_start_date => l_start_date,
735: p_end_date => p_determination_date);
736: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_prev_employment,5);
737: -- findout the absence duration for the person during this period
738: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
739: p_person_id => p_person_id,
740: p_assignment_id =>p_assignment_id,

Line 748: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

744: --Approximately proportionating the Absence duration to consider the Parttime periods
745: -- l_absent_duration := l_absent_duration * l_parttime_duration/l_asg_duration;
746: --
747: l_asg_duration := l_parttime_duration;
748: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
749: -- collect the correction factor defined (if any) for the person
750: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
751: p_los_type => p_los_type,
752: p_effective_date => p_determination_date);

Line 753: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);

749: -- collect the correction factor defined (if any) for the person
750: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
751: p_los_type => p_los_type,
752: p_effective_date => p_determination_date);
753: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);
754: l_military_duration := get_military_service_period (p_bg_id => p_bg_id,
755: p_person_id => p_person_id,
756: p_assignment_id => p_assignment_id,
757: p_los_type => p_los_type,

Line 760: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);

756: p_assignment_id => p_assignment_id,
757: p_los_type => p_los_type,
758: p_start_date => l_start_date,
759: p_end_date => p_determination_date);
760: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
761:
762: l_general_los := l_asg_duration + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration;
763:
764: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);

Line 764: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);

760: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
761:
762: l_general_los := l_asg_duration + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration;
763:
764: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);
765:
766: RETURN l_general_los;
767:
768: EXCEPTION

Line 770: hr_utility.set_location('Erroring out from '||l_proc,5);

766: RETURN l_general_los;
767:
768: EXCEPTION
769: When Others THEN
770: hr_utility.set_location('Erroring out from '||l_proc,5);
771: RAISE_Application_Error(-20001,SQLERRM);
772: END get_gen_pub_length_of_service;
773:
774: -- -----------------------------------------------------------------------*

Line 820: hr_utility.set_location('Entering '||l_proc,1);

816: l_prev_employment NUMBER(22,3) := 0;
817: l_military_duration NUMBER(22,3) := 0;
818: l_net_grade_los NUMBER(22,3) := 0;
819: BEGIN
820: hr_utility.set_location('Entering '||l_proc,1);
821: OPEN csr_asg_grade;
822: FETCH csr_asg_grade INTO l_assignment_id, l_grade_id;
823: CLOSE csr_asg_grade;
824: IF l_grade_id IS NOT NULL THEN

Line 833: hr_utility.set_location(l_proc||' Grade Duration '||l_grade_los,2);

829: IF p_determination_date < l_end_date THEN
830: l_end_date := p_determination_date;
831: END IF;
832: l_grade_los := l_end_date - l_start_date+1;
833: hr_utility.set_location(l_proc||' Grade Duration '||l_grade_los,2);
834: -- findout any parttime entitlements defined for the LOS type
835: l_parttime_duration := get_parttime_entitlement( p_person_id => p_person_id,
836: p_assignment_id => p_assignment_id,
837: p_bg_id => p_bg_id,

Line 841: hr_utility.set_location(l_proc||'Parttime Grade Duration '||l_parttime_duration,4);

837: p_bg_id => p_bg_id,
838: p_los_type => '40',
839: p_start_date => l_start_date,
840: p_end_date => l_end_date);
841: hr_utility.set_location(l_proc||'Parttime Grade Duration '||l_parttime_duration,4);
842: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
843: p_assignment_id => l_assignment_id,
844: p_start_date => l_start_date,
845: p_end_date => l_end_date);

Line 846: hr_utility.set_location(l_proc||' Previous Employment '||l_prev_employment,5);

842: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
843: p_assignment_id => l_assignment_id,
844: p_start_date => l_start_date,
845: p_end_date => l_end_date);
846: hr_utility.set_location(l_proc||' Previous Employment '||l_prev_employment,5);
847: -- findout the absence duration for the person during this period
848: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
849: p_person_id => p_person_id,
850: p_assignment_id => l_assignment_id,

Line 858: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

854:
855: --Approximately proportionating the Absence duration to consider the Parttime periods
856: -- l_absent_duration := l_absent_duration * l_parttime_duration/l_grade_los;
857: l_grade_los := l_parttime_duration;
858: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
859: -- collect the correction factor defined (if any) for the person
860: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
861: p_los_type => '40',
862: p_effective_date => p_determination_date);

Line 863: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_factor,7);

859: -- collect the correction factor defined (if any) for the person
860: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
861: p_los_type => '40',
862: p_effective_date => p_determination_date);
863: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_factor,7);
864: l_military_duration := get_military_service_period (p_bg_id => p_bg_id,
865: p_person_id => p_person_id,
866: p_assignment_id => p_assignment_id,
867: p_los_type => '40',

Line 870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);

866: p_assignment_id => p_assignment_id,
867: p_los_type => '40',
868: p_start_date => l_start_date,
869: p_end_date => l_end_date);
870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);

Line 871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);

867: p_los_type => '40',
868: p_start_date => l_start_date,
869: p_end_date => l_end_date);
870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);
875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);

Line 872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);

868: p_start_date => l_start_date,
869: p_end_date => l_end_date);
870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);
875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);
876: l_net_grade_los := l_net_grade_los + (l_grade_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);

Line 873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);

869: p_end_date => l_end_date);
870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);
875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);
876: l_net_grade_los := l_net_grade_los + (l_grade_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
877: END LOOP;

Line 874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);

870: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);
875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);
876: l_net_grade_los := l_net_grade_los + (l_grade_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
877: END LOOP;
878: END IF;

Line 875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);

871: hr_utility.set_location(l_proc||'Calculation net_grade_los l_grade_los is '||l_grade_los,9);
872: hr_utility.set_location(l_proc||'Calculation net_grade_los l_prev_employment is '||l_prev_employment,10);
873: hr_utility.set_location(l_proc||'Calculation net_grade_los l_correction_factor is '||l_correction_factor,11);
874: hr_utility.set_location(l_proc||'Calculation net_grade_los l_military_duration is '||l_military_duration,12);
875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);
876: l_net_grade_los := l_net_grade_los + (l_grade_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
877: END LOOP;
878: END IF;
879: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);

Line 879: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);

875: hr_utility.set_location(l_proc||'Calculation net_grade_los l_absent_duration is '||l_absent_duration,13);
876: l_net_grade_los := l_net_grade_los + (l_grade_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
877: END LOOP;
878: END IF;
879: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);
880: RETURN l_net_grade_los;
881: EXCEPTION
882: When Others THEN
883: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 883: hr_utility.set_location('Erroring out from '||l_proc,5);

879: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);
880: RETURN l_net_grade_los;
881: EXCEPTION
882: When Others THEN
883: hr_utility.set_location('Erroring out from '||l_proc,5);
884: RAISE_Application_Error(-20001,SQLERRM);
885: END get_grade_length_of_service;
886:
887: -- -----------------------------------------------------------------------*

Line 932: hr_utility.set_location('Entering '||l_proc,1);

928: l_prev_employment NUMBER(22,3) := 0;
929: l_military_duration NUMBER(22,3) := 0;
930: l_net_position_los NUMBER(22,3) := 0;
931: BEGIN
932: hr_utility.set_location('Entering '||l_proc,1);
933: OPEN csr_asg_position;
934: FETCH csr_asg_position INTO l_assignment_id, l_position_id;
935: CLOSE csr_asg_position;
936: IF l_position_id IS NOT NULL THEN

Line 945: hr_utility.set_location(l_proc||' Position Duration '||l_position_los,2);

941: IF p_determination_date < l_end_date THEN
942: l_end_date := p_determination_date;
943: END IF;
944: l_position_los := l_end_date - l_start_date+1;
945: hr_utility.set_location(l_proc||' Position Duration '||l_position_los,2);
946: -- findout any parttime entitlements defined for the LOS type
947: l_parttime_duration := get_parttime_entitlement( p_person_id => p_person_id,
948: p_assignment_id => p_assignment_id,
949: p_bg_id => p_bg_id,

Line 954: hr_utility.set_location(l_proc||' Post Parttime Duration '||l_position_los,4);

950: p_los_type => '60',
951: p_start_date => l_start_date,
952: p_end_date => l_end_date);
953:
954: hr_utility.set_location(l_proc||' Post Parttime Duration '||l_position_los,4);
955: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
956: p_assignment_id => l_assignment_id,
957: p_start_date => l_start_date,
958: p_end_date => l_end_date);

Line 959: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_position_los,5);

955: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
956: p_assignment_id => l_assignment_id,
957: p_start_date => l_start_date,
958: p_end_date => l_end_date);
959: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_position_los,5);
960: -- findout the absence duration for the person during this period
961: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
962: p_person_id => p_person_id,
963: p_assignment_id => l_assignment_id,

Line 970: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

966: p_end_date => l_end_date);
967: --Approximately proportionating the Absence duration to consider the Parttime periods
968: -- l_absent_duration := l_absent_duration * l_parttime_duration/l_position_los;
969: l_position_los := l_parttime_duration;
970: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
971: -- collect the correction factor defined (if any) for the person
972: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
973: p_los_type => '60',
974: p_effective_date => p_determination_date);

Line 975: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);

971: -- collect the correction factor defined (if any) for the person
972: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
973: p_los_type => '60',
974: p_effective_date => p_determination_date);
975: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);
976: -- get the military service duration, if entitled for this LOS calculation
977: l_military_duration := get_military_service_period (p_bg_id => p_bg_id,
978: p_person_id => p_person_id,
979: p_assignment_id => p_assignment_id,

Line 983: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);

979: p_assignment_id => p_assignment_id,
980: p_los_type => '60',
981: p_start_date => l_start_date,
982: p_end_date => l_end_date);
983: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
984:
985: l_net_position_los := l_net_position_los + (l_position_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
986: END LOOP;
987: END IF;

Line 989: hr_utility.set_location(l_proc||' Net Position LOS '||l_net_position_los,8);

985: l_net_position_los := l_net_position_los + (l_position_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
986: END LOOP;
987: END IF;
988:
989: hr_utility.set_location(l_proc||' Net Position LOS '||l_net_position_los,8);
990:
991: RETURN l_net_position_los;
992: EXCEPTION
993: When Others THEN

Line 994: hr_utility.set_location('Erroring out from '||l_proc,5);

990:
991: RETURN l_net_position_los;
992: EXCEPTION
993: When Others THEN
994: hr_utility.set_location('Erroring out from '||l_proc,5);
995: RAISE_Application_Error(-20001,SQLERRM);
996: END get_position_length_of_service;
997:
998:

Line 1049: hr_utility.set_location('Entering '||l_proc,1);

1045: l_prev_employment NUMBER(22,3) := 0;
1046: l_military_duration NUMBER(22,3) := 0;
1047: l_net_corps_los NUMBER(22,3) := 0;
1048: BEGIN
1049: hr_utility.set_location('Entering '||l_proc,1);
1050: OPEN csr_asg_corps;
1051: FETCH csr_asg_corps INTO l_assignment_id, l_corps_id;
1052: CLOSE csr_asg_corps;
1053: IF l_corps_id IS NOT NULL THEN

Line 1062: hr_utility.set_location(l_proc||' Corps Duration '||l_corps_los,2);

1058: IF p_determination_date < l_end_date THEN
1059: l_end_date := p_determination_date;
1060: END IF;
1061: l_corps_los := l_end_date - l_start_date+1;
1062: hr_utility.set_location(l_proc||' Corps Duration '||l_corps_los,2);
1063: -- findout any parttime entitlements defined for the LOS type
1064: l_parttime_duration := get_parttime_entitlement( p_person_id => p_person_id,
1065: p_assignment_id => p_assignment_id,
1066: p_bg_id => p_bg_id,

Line 1071: hr_utility.set_location(l_proc||' Post Parttime Duration '||l_parttime_duration,4);

1067: p_los_type => '30',
1068: p_start_date => l_start_date,
1069: p_end_date => l_end_date);
1070:
1071: hr_utility.set_location(l_proc||' Post Parttime Duration '||l_parttime_duration,4);
1072: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
1073: p_assignment_id => l_assignment_id,
1074: p_start_date => l_start_date,
1075: p_end_date => l_end_date);

Line 1076: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_corps_los,5);

1072: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
1073: p_assignment_id => l_assignment_id,
1074: p_start_date => l_start_date,
1075: p_end_date => l_end_date);
1076: hr_utility.set_location(l_proc||' Previous Employment Duration '||l_corps_los,5);
1077: -- findout the absence duration for the person during this period
1078: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
1079: p_person_id => p_person_id,
1080: p_assignment_id => l_assignment_id,

Line 1087: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

1083: p_end_date => l_end_date);
1084: --Approximately proportionating the Absence duration to consider the Parttime periods
1085: -- l_absent_duration := l_absent_duration * l_parttime_duration/l_corps_los;
1086: l_corps_los := l_parttime_duration;
1087: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
1088: -- collect the correction factor defined (if any) for the person
1089: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1090: p_los_type => '60',
1091: p_effective_date => p_determination_date);

Line 1092: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);

1088: -- collect the correction factor defined (if any) for the person
1089: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1090: p_los_type => '60',
1091: p_effective_date => p_determination_date);
1092: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);
1093: -- get the military service duration, if entitled for this LOS calculation
1094: l_military_duration := get_military_service_period (p_bg_id => p_bg_id,
1095: p_person_id => p_person_id,
1096: p_assignment_id => p_assignment_id,

Line 1100: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);

1096: p_assignment_id => p_assignment_id,
1097: p_los_type => '60',
1098: p_start_date => l_start_date,
1099: p_end_date => l_end_date);
1100: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
1101:
1102: l_net_corps_los := l_net_corps_los + (l_corps_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
1103: END LOOP;
1104: END IF;

Line 1106: hr_utility.set_location(l_proc||' Net Corps LOS '||l_net_corps_los,8);

1102: l_net_corps_los := l_net_corps_los + (l_corps_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
1103: END LOOP;
1104: END IF;
1105:
1106: hr_utility.set_location(l_proc||' Net Corps LOS '||l_net_corps_los,8);
1107:
1108: RETURN l_net_corps_los;
1109: EXCEPTION
1110: When Others THEN

Line 1111: hr_utility.set_location('Erroring out from '||l_proc,5);

1107:
1108: RETURN l_net_corps_los;
1109: EXCEPTION
1110: When Others THEN
1111: hr_utility.set_location('Erroring out from '||l_proc,5);
1112: RAISE_Application_Error(-20001,SQLERRM);
1113: END get_corps_length_of_service;
1114:
1115: -- -----------------------------------------------------------------------*

Line 1154: hr_utility.set_location('Entering '||l_proc,1);

1150: l_proc varchar2(60) := g_package||'get_step_LOS';
1151:
1152:
1153: BEGIN
1154: hr_utility.set_location('Entering '||l_proc,1);
1155: OPEN csr_asg_step;
1156:
1157: FETCH csr_asg_step INTO l_assignment_id, l_step_id, l_start_date, l_end_date;
1158:

Line 1169: hr_utility.set_location(l_proc||' Step Duration '||l_step_los,2);

1165: l_end_date := p_determination_date;
1166: END IF;
1167: l_step_los := l_end_date - l_start_date;
1168:
1169: hr_utility.set_location(l_proc||' Step Duration '||l_step_los,2);
1170: -- findout any parttime entitlements defined for the LOS type
1171: l_parttime_duration := get_parttime_entitlement( p_person_id => p_person_id,
1172: p_assignment_id => p_assignment_id,
1173: p_bg_id => p_bg_id,

Line 1178: hr_utility.set_location(l_proc||' Post parttime Step Duration '||l_step_los,4);

1174: p_los_type => '50',
1175: p_start_date => l_start_date,
1176: p_end_date => l_end_date);
1177:
1178: hr_utility.set_location(l_proc||' Post parttime Step Duration '||l_step_los,4);
1179: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
1180: p_assignment_id => l_assignment_id,
1181: p_start_date => l_start_date,
1182: p_end_date => l_end_date);

Line 1183: hr_utility.set_location(l_proc||' Previous Emp Duration '||l_prev_employment,5);

1179: l_prev_employment := get_previous_employment(p_person_id => p_person_id,
1180: p_assignment_id => l_assignment_id,
1181: p_start_date => l_start_date,
1182: p_end_date => l_end_date);
1183: hr_utility.set_location(l_proc||' Previous Emp Duration '||l_prev_employment,5);
1184:
1185: -- findout the absence duration for the person during this period
1186: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
1187: p_person_id => p_person_id,

Line 1195: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

1191: p_end_date => l_end_date);
1192: --Approximately proportionating the Absence duration to consider the Parttime periods
1193: -- l_absent_duration := l_absent_duration * l_parttime_duration/l_step_los;
1194: l_step_los := l_parttime_duration;
1195: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
1196:
1197: -- collect the correction factor defined (if any) for the person
1198: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1199: p_los_type => '50',

Line 1201: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);

1197: -- collect the correction factor defined (if any) for the person
1198: l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1199: p_los_type => '50',
1200: p_effective_date => p_determination_date);
1201: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7);
1202:
1203: -- get the military service duration, if entitled for this LOS calculation
1204: l_military_duration := get_military_service_period (p_bg_id => p_bg_id,
1205: p_person_id => p_person_id,

Line 1210: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);

1206: p_assignment_id => p_assignment_id,
1207: p_los_type => '50',
1208: p_start_date => l_start_date,
1209: p_end_date => l_end_date);
1210: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
1211:
1212: l_net_step_los := l_net_step_los + (l_step_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
1213: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);
1214: RETURN l_net_step_los;

Line 1213: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);

1209: p_end_date => l_end_date);
1210: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8);
1211:
1212: l_net_step_los := l_net_step_los + (l_step_los + l_prev_employment + l_correction_factor + l_military_duration - l_absent_duration);
1213: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);
1214: RETURN l_net_step_los;
1215: EXCEPTION
1216: When Others THEN
1217: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 1217: hr_utility.set_location('Erroring out from '||l_proc,5);

1213: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);
1214: RETURN l_net_step_los;
1215: EXCEPTION
1216: When Others THEN
1217: hr_utility.set_location('Erroring out from '||l_proc,5);
1218: RAISE_Application_Error(-20001,SQLERRM);
1219:
1220: END get_step_length_of_service;
1221:

Line 1238: hr_utility.set_location(l_proc||' Entering',10);

1234: l_adj_service_date DATE;
1235: l_determination_date DATE := TRUNC(p_determination_date);
1236: l_proc varchar2(60) := g_package||'get_los_for_display';
1237: BEGIN
1238: hr_utility.set_location(l_proc||' Entering',10);
1239: l_los_days := get_length_of_service( p_bg_id => p_bg_id,
1240: p_person_id => p_person_id,
1241: p_assignment_id => p_assignment_id,
1242: p_los_type => p_los_type,

Line 1256: hr_utility.set_location(l_proc||l_display_los,15);

1252: l_dd := NVL(l_determination_date - TRUNC( ADD_MONTHS(l_adj_service_date,(l_mm+l_yy*12))),0);
1253:
1254: l_display_los := NVL(l_yy,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','Y')||' '||NVL(l_mm,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','M')||' '||l_dd||' '||hr_general.decode_lookup('QUALIFYING_UNITS','D');
1255:
1256: hr_utility.set_location(l_proc||l_display_los,15);
1257:
1258: hr_utility.set_location(l_proc||' Leaving',20);
1259:
1260: RETURN l_display_los;

Line 1258: hr_utility.set_location(l_proc||' Leaving',20);

1254: l_display_los := NVL(l_yy,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','Y')||' '||NVL(l_mm,0)||' '||hr_general.decode_lookup('QUALIFYING_UNITS','M')||' '||l_dd||' '||hr_general.decode_lookup('QUALIFYING_UNITS','D');
1255:
1256: hr_utility.set_location(l_proc||l_display_los,15);
1257:
1258: hr_utility.set_location(l_proc||' Leaving',20);
1259:
1260: RETURN l_display_los;
1261: END get_los_for_display;
1262: -- -----------------------------------------------------------------------*

Line 1312: hr_utility.set_location('Entering '||l_proc,1);

1308:
1309:
1310: BEGIN
1311:
1312: hr_utility.set_location('Entering '||l_proc,1);
1313:
1314: -- take session date as the determination date if determination date is not passed
1315: IF l_determination_date IS NULL THEN
1316: l_determination_date := get_effective_date;

Line 1319: hr_utility.set_location(l_proc||' Effective Date '||to_char(l_determination_date,'dd-mm-RRRR'),2);

1315: IF l_determination_date IS NULL THEN
1316: l_determination_date := get_effective_date;
1317: END IF;
1318: --
1319: hr_utility.set_location(l_proc||' Effective Date '||to_char(l_determination_date,'dd-mm-RRRR'),2);
1320:
1321: IF p_bg_id IS NULL THEN
1322: hr_api.mandatory_arg_error(p_api_name => l_proc,
1323: p_argument => 'p_bg_id',

Line 1328: hr_utility.set_location(l_proc||' BG ID Validated',2);

1324: p_argument_value => p_bg_id);
1325: ELSE
1326: hr_api.validate_bus_grp_id(p_business_group_id=>p_bg_id);
1327: END IF;
1328: hr_utility.set_location(l_proc||' BG ID Validated',2);
1329: IF p_person_id IS NULL AND p_assignment_id IS NULL THEN
1330: hr_api.mandatory_arg_error(p_api_name => l_proc,
1331: p_argument => 'p_person_id',
1332: p_argument_value => p_person_id);

Line 1334: hr_utility.set_location(l_proc||' Person ID Validated',2);

1330: hr_api.mandatory_arg_error(p_api_name => l_proc,
1331: p_argument => 'p_person_id',
1332: p_argument_value => p_person_id);
1333: END IF;
1334: hr_utility.set_location(l_proc||' Person ID Validated',2);
1335: IF p_person_id IS NOT NULL THEN
1336: OPEN Csr_validate_person;
1337: FETCH Csr_validate_person INTO l_exists;
1338: CLOSE Csr_validate_person;

Line 1366: hr_utility.set_location(l_proc||' Assignment iD Validated',2);

1362: END IF;
1363: CLOSE Csr_validate_assignment;
1364: END IF;
1365: l_person_id := NVL(p_person_id,l_person_id);
1366: hr_utility.set_location(l_proc||' Assignment iD Validated',2);
1367: IF p_los_type IS NULL THEN
1368: hr_api.mandatory_arg_error(p_api_name => l_proc,
1369: p_argument => 'p_los_type',
1370: p_argument_value => p_los_type);

Line 1380: hr_utility.set_location(l_proc||' LOS TYPE Validated',2);

1376: fnd_message.set_token('VALUE',p_los_type);
1377: fnd_message.set_token('PARAMETER','p_los_type');
1378: END IF;
1379: END IF;
1380: hr_utility.set_location(l_proc||' LOS TYPE Validated',2);
1381: IF p_return_units IS NULL THEN
1382: hr_api.mandatory_arg_error(p_api_name => l_proc,
1383: p_argument => 'p_return_units',
1384: p_argument_value => p_return_units);

Line 1398: hr_utility.set_location(l_proc||' Completed Validations ',2);

1394: END IF;
1395: g_emp_type := get_employee_type(p_person_id => p_person_id,
1396: p_determination_date => l_determination_date);
1397: g_determination_date := l_determination_date;
1398: hr_utility.set_location(l_proc||' Completed Validations ',2);
1399: hr_utility.set_location(l_proc||' Person Id '||to_char(L_person_id),2);
1400: hr_utility.set_location(l_proc||' Assignment Id '||to_char(L_Assignment_Id),2);
1401: IF p_los_type IN ('10','20') THEN -- General Length of service and Length of service in Public Service
1402: hr_utility.set_location(l_proc||' Calling get_gen_pub_length_of_service',3);

Line 1399: hr_utility.set_location(l_proc||' Person Id '||to_char(L_person_id),2);

1395: g_emp_type := get_employee_type(p_person_id => p_person_id,
1396: p_determination_date => l_determination_date);
1397: g_determination_date := l_determination_date;
1398: hr_utility.set_location(l_proc||' Completed Validations ',2);
1399: hr_utility.set_location(l_proc||' Person Id '||to_char(L_person_id),2);
1400: hr_utility.set_location(l_proc||' Assignment Id '||to_char(L_Assignment_Id),2);
1401: IF p_los_type IN ('10','20') THEN -- General Length of service and Length of service in Public Service
1402: hr_utility.set_location(l_proc||' Calling get_gen_pub_length_of_service',3);
1403: l_los_days := get_gen_pub_length_of_service( p_bg_id => l_bg_id,

Line 1400: hr_utility.set_location(l_proc||' Assignment Id '||to_char(L_Assignment_Id),2);

1396: p_determination_date => l_determination_date);
1397: g_determination_date := l_determination_date;
1398: hr_utility.set_location(l_proc||' Completed Validations ',2);
1399: hr_utility.set_location(l_proc||' Person Id '||to_char(L_person_id),2);
1400: hr_utility.set_location(l_proc||' Assignment Id '||to_char(L_Assignment_Id),2);
1401: IF p_los_type IN ('10','20') THEN -- General Length of service and Length of service in Public Service
1402: hr_utility.set_location(l_proc||' Calling get_gen_pub_length_of_service',3);
1403: l_los_days := get_gen_pub_length_of_service( p_bg_id => l_bg_id,
1404: p_person_id => l_person_id,

Line 1402: hr_utility.set_location(l_proc||' Calling get_gen_pub_length_of_service',3);

1398: hr_utility.set_location(l_proc||' Completed Validations ',2);
1399: hr_utility.set_location(l_proc||' Person Id '||to_char(L_person_id),2);
1400: hr_utility.set_location(l_proc||' Assignment Id '||to_char(L_Assignment_Id),2);
1401: IF p_los_type IN ('10','20') THEN -- General Length of service and Length of service in Public Service
1402: hr_utility.set_location(l_proc||' Calling get_gen_pub_length_of_service',3);
1403: l_los_days := get_gen_pub_length_of_service( p_bg_id => l_bg_id,
1404: p_person_id => l_person_id,
1405: p_assignment_id => l_assignment_id,
1406: p_los_type => p_los_type,

Line 1437: hr_utility.set_location(l_proc,2);

1433: p_determination_date => l_determination_date);
1434:
1435: END IF;
1436:
1437: hr_utility.set_location(l_proc,2);
1438:
1439: l_adj_service_date := l_determination_date - l_los_days;
1440:
1441: hr_utility.set_location(l_proc||' Adjusted Service Date '||To_Char(l_adj_service_date,'dd-Mm-RRRR'),3);

Line 1441: hr_utility.set_location(l_proc||' Adjusted Service Date '||To_Char(l_adj_service_date,'dd-Mm-RRRR'),3);

1437: hr_utility.set_location(l_proc,2);
1438:
1439: l_adj_service_date := l_determination_date - l_los_days;
1440:
1441: hr_utility.set_location(l_proc||' Adjusted Service Date '||To_Char(l_adj_service_date,'dd-Mm-RRRR'),3);
1442:
1443: IF p_return_units = 'D' THEN
1444: l_los_return := l_los_days;
1445: ELSIF p_return_units = 'W' THEN

Line 1453: hr_utility.set_location(l_proc||' LOS in '||p_return_units||' '||l_los_return,4);

1449: ELSIF p_return_units = 'Y' THEN
1450: l_los_return := Months_Between(l_determination_date,l_adj_service_date)/12;
1451: END IF;
1452:
1453: hr_utility.set_location(l_proc||' LOS in '||p_return_units||' '||l_los_return,4);
1454:
1455: return l_los_return;
1456: EXCEPTION
1457: When Others THEN

Line 1458: hr_utility.set_location('Erroring out from '||l_proc,5);

1454:
1455: return l_los_return;
1456: EXCEPTION
1457: When Others THEN
1458: hr_utility.set_location('Erroring out from '||l_proc,5);
1459: RAISE_Application_Error(-20001,SQLERRM);
1460:
1461: END get_length_of_service;
1462:

Line 1503: hr_utility.set_location('Entering '||l_proc,1);

1499: AND p_start_date = fnd_date.canonical_to_date(pei_information1)
1500: AND p_end_date = fnd_date.canonical_to_date(pei_information2);
1501:
1502: BEGIN
1503: hr_utility.set_location('Entering '||l_proc,1);
1504: l_emp_type := get_employee_type(p_person_id => p_person_id,
1505: p_determination_date => trunc(sysdate));
1506: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);
1507: OPEN csr_military_entitlement;

Line 1506: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);

1502: BEGIN
1503: hr_utility.set_location('Entering '||l_proc,1);
1504: l_emp_type := get_employee_type(p_person_id => p_person_id,
1505: p_determination_date => trunc(sysdate));
1506: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);
1507: OPEN csr_military_entitlement;
1508: FETCH csr_military_entitlement INTO l_military_entitlement;
1509: CLOSE csr_military_entitlement;
1510: hr_utility.set_location(l_proc||' military entitlement '||l_military_entitlement,1);

Line 1510: hr_utility.set_location(l_proc||' military entitlement '||l_military_entitlement,1);

1506: hr_utility.set_location(l_proc||' employee type '||l_emp_type||to_char(p_start_date,'dd-mm-RRRR')||to_char(p_end_date,'dd-mm-RRRR'),1);
1507: OPEN csr_military_entitlement;
1508: FETCH csr_military_entitlement INTO l_military_entitlement;
1509: CLOSE csr_military_entitlement;
1510: hr_utility.set_location(l_proc||' military entitlement '||l_military_entitlement,1);
1511: IF l_military_entitlement IS NOT NULL THEN
1512: OPEN csr_military_periods;
1513: FETCH csr_military_periods INTO l_military_duration;
1514: IF csr_military_periods%FOUND THEN

Line 1535: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);

1531: l_military_duration := round(substr(l_los_months,instr(l_los_months,'.',1)) * 31);
1532: l_los_return := trunc(l_los_years)||'/'||trunc(l_los_months)||'/'||l_military_duration;
1533: END IF;
1534:
1535: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);
1536: RETURN l_los_return;
1537: EXCEPTION
1538: When Others THEN
1539: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 1539: hr_utility.set_location('Erroring out from '||l_proc,5);

1535: hr_utility.set_location(l_proc||' Military Duration '||l_military_duration,1);
1536: RETURN l_los_return;
1537: EXCEPTION
1538: When Others THEN
1539: hr_utility.set_location('Erroring out from '||l_proc,5);
1540: RAISE_Application_Error(-20001,SQLERRM);
1541: END get_de_military_service_period;
1542:
1543:

Line 1585: hr_utility.set_location('Entering '||l_proc,1);

1581: l_assg_los_type varchar2(1);
1582:
1583:
1584: BEGIN
1585: hr_utility.set_location('Entering '||l_proc,1);
1586:
1587: OPEN c_assg_los_type;
1588: FETCH c_assg_los_type INTO l_assg_los_type;
1589: CLOSE c_assg_los_type;

Line 1604: hr_utility.set_location(' date of birth '||l_date_of_birth,2);

1600: OPEN c_person_dob;
1601: FETCH c_person_dob INTO l_date_of_birth;
1602: CLOSE c_person_dob;
1603:
1604: hr_utility.set_location(' date of birth '||l_date_of_birth,2);
1605: hr_utility.set_location(' assignment start date '||p_assg_start_date,2);
1606:
1607: IF l_date_of_birth IS NOT NULL THEN
1608: IF Months_between(p_assg_start_date,l_date_of_birth)/12 < 18 THEN

Line 1605: hr_utility.set_location(' assignment start date '||p_assg_start_date,2);

1601: FETCH c_person_dob INTO l_date_of_birth;
1602: CLOSE c_person_dob;
1603:
1604: hr_utility.set_location(' date of birth '||l_date_of_birth,2);
1605: hr_utility.set_location(' assignment start date '||p_assg_start_date,2);
1606:
1607: IF l_date_of_birth IS NOT NULL THEN
1608: IF Months_between(p_assg_start_date,l_date_of_birth)/12 < 18 THEN
1609: l_start_date := add_months(l_date_of_birth,18*12);

Line 1622: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);

1618: RETURN 0;
1619: END IF;
1620: l_asg_duration := trunc(p_assg_end_date - l_start_date);
1621:
1622: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);
1623:
1624: -- findout the absence duration for the person during this period
1625: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
1626: p_person_id => p_person_id,

Line 1632: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

1628: p_los_type => p_los_type,
1629: p_start_date => l_start_date,
1630: p_end_date => p_assg_end_date);
1631:
1632: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
1633:
1634: -- collect the correction factor defined (if any) for the person
1635: /* l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1636: p_los_type => p_los_type,

Line 1638: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);

1634: -- collect the correction factor defined (if any) for the person
1635: /* l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1636: p_los_type => p_los_type,
1637: p_effective_date => p_assg_end_date);
1638: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);
1639: l_military_duration := get_de_military_service_period (p_bg_id => p_bg_id,
1640: p_person_id => p_person_id,
1641: p_los_type => p_los_type,
1642: p_start_date => l_start_date,

Line 1645: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */

1641: p_los_type => p_los_type,
1642: p_start_date => l_start_date,
1643: p_end_date => p_assg_end_date);
1644:
1645: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
1646:
1647: l_general_los := (l_asg_duration + 1) - l_absent_duration;
1648: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);
1649:

Line 1648: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);

1644:
1645: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
1646:
1647: l_general_los := (l_asg_duration + 1) - l_absent_duration;
1648: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);
1649:
1650: RETURN l_general_los;
1651:
1652: EXCEPTION

Line 1654: hr_utility.set_location('Erroring out from '||l_proc,5);

1650: RETURN l_general_los;
1651:
1652: EXCEPTION
1653: When Others THEN
1654: hr_utility.set_location('Erroring out from '||l_proc,5);
1655: RAISE_Application_Error(-20001,SQLERRM);
1656: END get_de_pub_length_of_service;
1657:
1658:

Line 1715: hr_utility.set_location('Entering '||l_proc,1);

1711: AND entitlement_flag = 'Y';
1712:
1713:
1714: BEGIN
1715: hr_utility.set_location('Entering '||l_proc,1);
1716:
1717: OPEN c_assg_los_type;
1718: FETCH c_assg_los_type INTO l_assg_los_type;
1719: CLOSE c_assg_los_type;

Line 1761: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);

1757: RETURN 0;
1758: END IF;
1759: l_asg_duration := trunc(p_assg_end_date - l_start_date) * l_entitlement/100;
1760:
1761: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);
1762:
1763: -- findout the absence duration for the person during this period
1764: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
1765: p_person_id => p_person_id,

Line 1771: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

1767: p_los_type => p_los_type,
1768: p_start_date => l_start_date,
1769: p_end_date => p_assg_end_date);
1770:
1771: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
1772: -- collect the correction factor defined (if any) for the person
1773: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1774: p_los_type => p_los_type,
1775: p_effective_date => p_assg_end_date);

Line 1776: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);

1772: -- collect the correction factor defined (if any) for the person
1773: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
1774: p_los_type => p_los_type,
1775: p_effective_date => p_assg_end_date);
1776: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_Factor,7);
1777: l_military_duration := get_de_military_service_period (p_bg_id => p_bg_id,
1778: p_person_id => p_person_id,
1779: p_los_type => p_los_type,
1780: p_start_date => l_start_date,

Line 1782: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */

1778: p_person_id => p_person_id,
1779: p_los_type => p_los_type,
1780: p_start_date => l_start_date,
1781: p_end_date => p_assg_end_date);
1782: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
1783:
1784: l_general_los := (l_asg_duration + 1) - l_absent_duration;
1785: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);
1786:

Line 1785: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);

1781: p_end_date => p_assg_end_date);
1782: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
1783:
1784: l_general_los := (l_asg_duration + 1) - l_absent_duration;
1785: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_general_los,8);
1786:
1787: RETURN l_general_los;
1788:
1789: EXCEPTION

Line 1791: hr_utility.set_location('Erroring out from '||l_proc,5);

1787: RETURN l_general_los;
1788:
1789: EXCEPTION
1790: When Others THEN
1791: hr_utility.set_location('Erroring out from '||l_proc,5);
1792: RAISE_Application_Error(-20001,SQLERRM);
1793: END get_jub_mon_length_of_service;
1794:
1795: -- -----------------------------------------------------------------------*

Line 1860: hr_utility.set_location('Entering '||l_proc,1);

1856: l_assg_los_type VARCHAR2(1);
1857:
1858:
1859: BEGIN
1860: hr_utility.set_location('Entering '||l_proc,1);
1861:
1862: OPEN c_assg_los_type;
1863: FETCH c_assg_los_type INTO l_assg_los_type;
1864: CLOSE c_assg_los_type;

Line 1879: hr_utility.set_location('Position id '|| l_position_id,1);

1875: OPEN c_assg_emp_catg;
1876: FETCH c_assg_emp_catg INTO l_employee_category, l_position_id;
1877: CLOSE c_assg_emp_catg;
1878:
1879: hr_utility.set_location('Position id '|| l_position_id,1);
1880:
1881: /* OPEN c_tariff_contract(l_position_id);
1882: FETCH c_tariff_contract INTO l_tariff_contract_code;
1883: CLOSE c_tariff_contract; */

Line 1885: hr_utility.set_location('Employee catg '||l_employee_category,2);

1881: /* OPEN c_tariff_contract(l_position_id);
1882: FETCH c_tariff_contract INTO l_tariff_contract_code;
1883: CLOSE c_tariff_contract; */
1884:
1885: hr_utility.set_location('Employee catg '||l_employee_category,2);
1886:
1887: IF nvl(l_employee_category,'x') = 'BE' Then
1888: -- and nvl(l_tariff_contract_code,'x') = 'CS' THEN
1889: OPEN c_person_dob;

Line 1951: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);

1947: END IF;
1948:
1949: l_asg_duration := trunc(p_assg_end_date - l_bda_date);
1950:
1951: hr_utility.set_location(l_proc||' Assignment duration '||l_asg_duration,2);
1952:
1953: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
1954: p_person_id => p_person_id,
1955: p_assignment_id => p_assignment_id,

Line 1961: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_bda_los,8);

1957: p_start_date => l_bda_date,
1958: p_end_date => p_assg_end_date);
1959:
1960: l_bda_los := (l_asg_duration + 1) - l_absent_duration;
1961: hr_utility.set_location(l_proc||p_los_type||' Length of Service '||l_bda_los,8);
1962: RETURN l_bda_los;
1963:
1964: ELSIF (p_assg_start_date >= l_dob_21) and (p_assg_start_date <= l_dob_31) THEN
1965: RETURN 0;

Line 2048: hr_utility.set_location('Entering '||l_proc,1);

2044: l_military_duration NUMBER(22,3) := 0;
2045: l_net_grade_los NUMBER(22,3) := 0;
2046: l_assg_los_type VARCHAR2(1);
2047: BEGIN
2048: hr_utility.set_location('Entering '||l_proc,1);
2049: OPEN csr_asg_grade;
2050: FETCH csr_asg_grade INTO l_grade_id;
2051: CLOSE csr_asg_grade;
2052:

Line 2075: hr_utility.set_location(l_proc||' Grade Duration '||l_grade_los,2);

2071: IF l_grade_id <> nvl(l_curr_grade_id,-1) THEN
2072: RETURN l_grade_los;
2073: END IF;
2074: l_grade_los := p_assg_end_date - p_assg_start_date;
2075: hr_utility.set_location(l_proc||' Grade Duration '||l_grade_los,2);
2076:
2077:
2078: -- findout the absence duration for the person during this period
2079: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,

Line 2087: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

2083: p_start_date => p_assg_start_date,
2084: p_end_date => p_assg_end_date);
2085:
2086: --Approximately proportionating the Absence duration to consider the Parttime periods
2087: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
2088: -- collect the correction factor defined (if any) for the person
2089: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
2090: p_los_type => '40',
2091: p_effective_date => p_assg_end_date);

Line 2092: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_factor,7);

2088: -- collect the correction factor defined (if any) for the person
2089: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
2090: p_los_type => '40',
2091: p_effective_date => p_assg_end_date);
2092: hr_utility.set_location(l_proc||' Corrected Days '||l_correction_factor,7);
2093: l_military_duration := get_de_military_service_period (p_bg_id => p_bg_id,
2094: p_person_id => p_person_id,
2095: p_los_type => '40',
2096: p_start_date => p_assg_start_date,

Line 2098: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */

2094: p_person_id => p_person_id,
2095: p_los_type => '40',
2096: p_start_date => p_assg_start_date,
2097: p_end_date => p_assg_end_date);
2098: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
2099:
2100: l_net_grade_los := l_net_grade_los + (l_grade_los + 1 - l_absent_duration);
2101:
2102: END IF;

Line 2103: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);

2099:
2100: l_net_grade_los := l_net_grade_los + (l_grade_los + 1 - l_absent_duration);
2101:
2102: END IF;
2103: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);
2104: RETURN l_net_grade_los;
2105: EXCEPTION
2106: When Others THEN
2107: hr_utility.set_location('Erroring out from '||l_proc,5);

Line 2107: hr_utility.set_location('Erroring out from '||l_proc,5);

2103: hr_utility.set_location(l_proc||' Net Grade LOS '||l_net_grade_los,8);
2104: RETURN l_net_grade_los;
2105: EXCEPTION
2106: When Others THEN
2107: hr_utility.set_location('Erroring out from '||l_proc,5);
2108: RAISE_Application_Error(-20001,SQLERRM);
2109: END get_de_grade_length_of_service;
2110:
2111: --

Line 2180: hr_utility.set_location('Entering '||l_proc,1);

2176: l_proc varchar2(60) := g_package||'get_step_LOS';
2177:
2178:
2179: BEGIN
2180: hr_utility.set_location('Entering '||l_proc,1);
2181: OPEN csr_asg_step;
2182: FETCH csr_asg_step INTO l_step_id, l_start_date, l_end_date;
2183: CLOSE csr_asg_step;
2184:

Line 2207: hr_utility.set_location(l_proc||' Step Duration '||l_step_los,2);

2203: END IF;
2204:
2205: l_step_los := l_end_date - l_start_date;
2206:
2207: hr_utility.set_location(l_proc||' Step Duration '||l_step_los,2);
2208:
2209: -- findout the absence duration for the person during this period
2210: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
2211: p_person_id => p_person_id,

Line 2217: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

2213: p_los_type => '50',
2214: p_start_date => l_start_date,
2215: p_end_date => l_end_date);
2216:
2217: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
2218:
2219: -- collect the correction factor defined (if any) for the person
2220: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
2221: p_los_type => '50',

Line 2223: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7); /

2219: -- collect the correction factor defined (if any) for the person
2220: /*l_correction_factor := get_correction_factor(p_person_id => p_person_id,
2221: p_los_type => '50',
2222: p_effective_date => l_end_date);
2223: hr_utility.set_location(l_proc||' Correct Days '||l_correction_factor,7); /
2224:
2225: -- get the military service duration, if entitled for this LOS calculation
2226: l_military_duration := get_de_military_service_period (p_bg_id => p_bg_id,
2227: p_person_id => p_person_id,

Line 2231: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */

2227: p_person_id => p_person_id,
2228: p_los_type => '50',
2229: p_start_date => l_start_date,
2230: p_end_date => l_end_date);
2231: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
2232:
2233: l_net_step_los := l_net_step_los + (l_step_los + 1 - l_absent_duration);
2234: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);
2235: END IF;

Line 2234: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);

2230: p_end_date => l_end_date);
2231: hr_utility.set_location(l_proc||' Military service Period '||l_military_duration,8); */
2232:
2233: l_net_step_los := l_net_step_los + (l_step_los + 1 - l_absent_duration);
2234: hr_utility.set_location(l_proc||' LOS on Step '||l_net_step_los,8);
2235: END IF;
2236: RETURN l_net_step_los;
2237: EXCEPTION
2238: When Others THEN

Line 2239: hr_utility.set_location('Erroring out from '||l_proc,5);

2235: END IF;
2236: RETURN l_net_step_los;
2237: EXCEPTION
2238: When Others THEN
2239: hr_utility.set_location('Erroring out from '||l_proc,5);
2240: RAISE_Application_Error(-20001,SQLERRM);
2241:
2242: END get_de_step_length_of_service;
2243:

Line 2297: hr_utility.set_location('Entering '||l_proc,1);

2293: l_military_duration NUMBER(22,3) := 0;
2294: l_assg_los_type VARCHAR2(1);
2295:
2296: BEGIN
2297: hr_utility.set_location('Entering '||l_proc,1);
2298: -- OPEN csr_asg_position;
2299: -- FETCH csr_asg_position INTO l_assignment_id, l_position_id;
2300: -- CLOSE csr_asg_position;
2301:

Line 2316: hr_utility.set_location(l_proc||' Position Duration '||l_position_los,2);

2312: RETURN 0;
2313: END IF;
2314:
2315: l_position_los := trunc(p_assg_end_date - p_assg_start_date);
2316: hr_utility.set_location(l_proc||' Position Duration '||l_position_los,2);
2317:
2318: -- findout the absence duration for the person during this period
2319: l_absent_duration := get_absent_period( p_bg_id => p_bg_id,
2320: p_person_id => p_person_id,

Line 2325: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);

2321: p_assignment_id => l_assignment_id,
2322: p_los_type => p_los_type,
2323: p_start_date => p_assg_start_date,
2324: p_end_date => p_assg_start_date);
2325: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
2326:
2327: l_position_los := (l_position_los + 1)- l_absent_duration;
2328:
2329: hr_utility.set_location(l_proc||' Net Position LOS '||l_position_los,8);

Line 2329: hr_utility.set_location(l_proc||' Net Position LOS '||l_position_los,8);

2325: hr_utility.set_location(l_proc||' Absent Duration '||l_absent_duration,6);
2326:
2327: l_position_los := (l_position_los + 1)- l_absent_duration;
2328:
2329: hr_utility.set_location(l_proc||' Net Position LOS '||l_position_los,8);
2330:
2331: RETURN l_position_los;
2332: EXCEPTION
2333: When Others THEN

Line 2334: hr_utility.set_location('Erroring out from '||l_proc,5);

2330:
2331: RETURN l_position_los;
2332: EXCEPTION
2333: When Others THEN
2334: hr_utility.set_location('Erroring out from '||l_proc,5);
2335: RAISE_Application_Error(-20001,SQLERRM);
2336: END get_de_assg_length_of_service;
2337: --
2338: -- This function returns the length of service for a person

Line 2426: hr_utility.set_location('Entering '||l_proc,1);

2422: WHERE previous_job_id = p_prev_job_id;
2423:
2424: BEGIN
2425:
2426: hr_utility.set_location('Entering '||l_proc,1);
2427:
2428: IF p_assg_end_date = g_end_of_time THEN
2429: l_end_date := trunc(sysdate);
2430: END IF;

Line 2620: hr_utility.set_location(l_proc||' Adjusted Service Date '||To_Char(l_adj_service_date,'DD-MM-RRRR'),3);

2616: END IF;
2617:
2618: l_adj_service_date := l_end_date - l_los_days;
2619:
2620: hr_utility.set_location(l_proc||' Adjusted Service Date '||To_Char(l_adj_service_date,'DD-MM-RRRR'),3);
2621:
2622: /* IF nvl(l_los_days,0) < 365 THEN
2623: l_los_return := round(to_char(nvl(l_los_days,0)))|| ' Days ';
2624: ELSE

Line 2739: hr_utility.set_location (l_proc || ' Entering', 10);

2735: l_temp_los_mm NUMBER (22, 3);
2736: l_proc VARCHAR2 (60)
2737: := g_package || 'get_date_diff_for_display';
2738: BEGIN
2739: hr_utility.set_location (l_proc || ' Entering', 10);
2740:
2741: IF (p_start_date IS NOT NULL AND p_end_date IS NOT NULL)
2742: THEN
2743: l_temp_los_mm := MONTHS_BETWEEN (p_end_date, p_start_date);

Line 2766: hr_utility.set_location (l_proc || l_display_los, 15);

2762: || ' '
2763: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'D');
2764: END IF;
2765:
2766: hr_utility.set_location (l_proc || l_display_los, 15);
2767: hr_utility.set_location (l_proc || ' Leaving', 20);
2768: RETURN l_display_los;
2769: END get_date_diff_for_display;
2770:

Line 2767: hr_utility.set_location (l_proc || ' Leaving', 20);

2763: || hr_general.decode_lookup ('QUALIFYING_UNITS', 'D');
2764: END IF;
2765:
2766: hr_utility.set_location (l_proc || l_display_los, 15);
2767: hr_utility.set_location (l_proc || ' Leaving', 20);
2768: RETURN l_display_los;
2769: END get_date_diff_for_display;
2770:
2771: --