APPS.PQP_GB_CSS_DAILY_ABSENCES dependencies on HR_UTILITY

Line 115: g_debug := hr_utility.debug_enabled ;

111: l_fulltime BOOLEAN ;
112:
113: BEGIN
114:
115: g_debug := hr_utility.debug_enabled ;
116:
117: IF g_debug THEN
118: debug_enter(l_proc_name) ;
119: debug('p_assignment_id:'||p_assignment_id);

Line 366: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

362: p_entitlements_remaining := l_entitlements_remaining_nc ;
363: p_entitlement_UOM := l_entitlement_UOM_nc ;
364: p_working_days_per_week := l_working_days_per_week_nc ;
365:
366: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
367: pqp_utilities.debug_others
368: (l_proc_name
369: ,l_proc_step
370: );

Line 452: g_debug := hr_utility.debug_enabled ;

448: l_decimal_part NUMBER ;
449:
450: BEGIN
451:
452: g_debug := hr_utility.debug_enabled ;
453:
454: IF g_debug THEN
455: debug_enter(l_proc_name);
456: debug('p_absence_start_date:'||p_absence_start_date);

Line 574: --hr_utility.set_location('vaibhav I am here : '||fnd_profile.value('BEN_COUNT_UNPAID_ABSENCE'),419);

570: -- Made changes according to Profile option (Newly added)
571: --'Count Unpaid Absence' Whose value if No then doesn't calculate
572: -- OSP NOBAND absences in the count of total absences
573: -- as it was originally required in the bug 7585452.
574: --hr_utility.set_location('vaibhav I am here : '||fnd_profile.value('BEN_COUNT_UNPAID_ABSENCE'),419);
575: IF (fnd_profile.value('BEN_COUNT_UNPAID_ABSENCE')='N') THEN
576: --hr_utility.set_location('vaibhav I am here in N: ',420);
577: IF l_absences_taken(i).band like 'BAND%' --OR
578: --l_absences_taken(i).band like 'NOBAND%' --bug 7585452, changed by vaibgupt

Line 576: --hr_utility.set_location('vaibhav I am here in N: ',420);

572: -- OSP NOBAND absences in the count of total absences
573: -- as it was originally required in the bug 7585452.
574: --hr_utility.set_location('vaibhav I am here : '||fnd_profile.value('BEN_COUNT_UNPAID_ABSENCE'),419);
575: IF (fnd_profile.value('BEN_COUNT_UNPAID_ABSENCE')='N') THEN
576: --hr_utility.set_location('vaibhav I am here in N: ',420);
577: IF l_absences_taken(i).band like 'BAND%' --OR
578: --l_absences_taken(i).band like 'NOBAND%' --bug 7585452, changed by vaibgupt
579: -- NOBAND should not be counted in absences taken
580:

Line 586: --hr_utility.set_location('vaibhav I am here in Y: ',421);

582: l_total_absences_taken:=l_total_absences_taken +
583: l_absences_taken(i).duration_per_week;
584: END IF ;
585: ELSE
586: --hr_utility.set_location('vaibhav I am here in Y: ',421);
587: IF l_absences_taken(i).band like 'BAND%' OR
588: l_absences_taken(i).band like 'NOBAND%' THEN
589: l_total_absences_taken:=l_total_absences_taken +
590: l_absences_taken(i).duration_per_week;

Line 768: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

764:
765: EXCEPTION
766: WHEN OTHERS THEN
767: p_total_remaining := l_total_remaining_nc;
768: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
769: pqp_utilities.debug_others
770: (l_proc_name
771: ,l_proc_step
772: );

Line 805: g_debug := hr_utility.debug_enabled ;

801: l_no_pay_days number ;
802: l_proc_name VARCHAR2(61) := g_package_name||'get_rolling_start_date';
803: l_proc_step NUMBER(20,10) ;
804: BEGIN
805: g_debug := hr_utility.debug_enabled ;
806: IF g_debug THEN
807: debug_enter(l_proc_name);
808: debug('p_rolling_end_date:'||p_rolling_end_date);
809: debug('p_scheme_period_duration:'||p_scheme_period_duration);

Line 880: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

876: RETURN l_period_start_date ;
877:
878: EXCEPTION
879: WHEN OTHERS THEN
880: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
881: pqp_utilities.debug_others
882: (l_proc_name
883: ,l_proc_step
884: );

Line 991: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

987: RETURN NVL(l_tot_no_pay_days,0) ;
988:
989: EXCEPTION
990: WHEN OTHERS THEN
991: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
992: pqp_utilities.debug_others
993: (l_proc_name
994: ,l_proc_step
995: );