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

Line 10: g_debug BOOLEAN:= hr_utility.debug_enabled;

6: g_package_name VARCHAR2(31):= 'pqp_absval_pkg.';
7:
8: g_plan_information rec_plan_information;
9: g_pl_id ben_pl_f.pl_typ_id%TYPE;
10: g_debug BOOLEAN:= hr_utility.debug_enabled;
11: -- Person Absence Aggregation globals
12: g_deduct_absence_for pqp_configuration_values.PCV_INFORMATION9%TYPE;
13:
14: -- Cache for rounding of factors

Line 419: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

415:
416: RETURN l_scheme_start_date;
417: EXCEPTION
418: WHEN OTHERS THEN
419: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
420: debug_others(l_proc_name,l_proc_step);
421: IF g_debug THEN
422: debug('Leaving: '||l_proc_name,-999);
423: END IF;

Line 635: g_debug := hr_utility.debug_enabled;

631: l_proc_step NUMBER(20,10) ;
632: i BINARY_INTEGER;
633:
634: BEGIN
635: g_debug := hr_utility.debug_enabled;
636:
637: IF g_debug THEN
638: debug_enter(l_proc_name);
639: END IF;

Line 702: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

698: END IF ;
699: EXCEPTION
700: WHEN OTHERS THEN
701:
702: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
703: pqp_utilities.debug_others
704: (l_proc_name
705: ,l_proc_step
706: );

Line 732: g_debug := hr_utility.debug_enabled;

728: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
729: l_duration_summary pqp_absval_pkg.t_duration_summary ;
730:
731: BEGIN
732: g_debug := hr_utility.debug_enabled;
733:
734: IF g_debug THEN
735: debug_enter(l_proc_name);
736: debug('p_gap_absence_plan_id:',p_gap_absence_plan_id);

Line 806: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

802:
803: EXCEPTION
804: WHEN OTHERS THEN
805:
806: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
807: pqp_utilities.debug_others
808: (l_proc_name
809: ,l_proc_step
810: );

Line 837: g_debug := hr_utility.debug_enabled;

833: l_pay_summary_existing_rows pqp_absval_pkg.t_gap_level ;
834: l_duration_summary pqp_absval_pkg.t_duration_summary ;
835:
836: BEGIN
837: g_debug := hr_utility.debug_enabled;
838:
839: IF g_debug THEN
840: debug_enter(l_proc_name);
841: debug('p_gap_absence_plan_id:',p_gap_absence_plan_id);

Line 999: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

995:
996: EXCEPTION
997: WHEN OTHERS THEN
998:
999: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1000: pqp_utilities.debug_others
1001: (l_proc_name
1002: ,l_proc_step
1003: );

Line 1031: g_debug := hr_utility.debug_enabled;

1027: l_proc_name VARCHAR2(61) := g_package_name||'write_absence_summary';
1028: l_proc_step NUMBER(20,10) ;
1029:
1030: BEGIN
1031: g_debug := hr_utility.debug_enabled;
1032:
1033: IF g_debug THEN
1034: debug_enter(l_proc_name);
1035: debug('p_gap_absence_plan_id:',p_gap_absence_plan_id);

Line 1061: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1057:
1058: EXCEPTION
1059: WHEN OTHERS THEN
1060:
1061: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1062: pqp_utilities.debug_others
1063: (l_proc_name
1064: ,l_proc_step
1065: );

Line 1110: g_debug := hr_utility.debug_enabled;

1106: l_gap_dur_sum_rows csr_gap_dur_sum_rows%ROWTYPE;
1107:
1108: BEGIN
1109:
1110: g_debug := hr_utility.debug_enabled;
1111:
1112: IF g_debug THEN
1113: debug_enter(l_proc_name);
1114: debug(p_assignment_id);

Line 1293: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

1289: END IF;
1290:
1291: --end changes by Vaibhav Gupta
1292:
1293: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
1294: debug_others(l_proc_name,l_proc_step);
1295: IF g_debug THEN
1296: debug('Leaving: '||l_proc_name,-999);
1297: END IF;

Line 1641: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');

1637: END IF;
1638:
1639: IF p_plan_information.default_work_pattern_name IS NULL
1640: THEN
1641: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
1642: hr_utility.raise_error ;
1643: END IF;
1644:
1645: END IF;

Line 1642: hr_utility.raise_error ;

1638:
1639: IF p_plan_information.default_work_pattern_name IS NULL
1640: THEN
1641: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
1642: hr_utility.raise_error ;
1643: END IF;
1644:
1645: END IF;
1646:

Line 1957: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');

1953: END IF;
1954:
1955: IF p_plan_information.default_work_pattern_name IS NULL
1956: THEN
1957: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
1958: hr_utility.raise_error ;
1959: END IF;
1960:
1961:

Line 1958: hr_utility.raise_error ;

1954:
1955: IF p_plan_information.default_work_pattern_name IS NULL
1956: THEN
1957: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
1958: hr_utility.raise_error ;
1959: END IF;
1960:
1961:
1962: END IF;

Line 2033: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2029: END IF;
2030:
2031: EXCEPTION
2032: WHEN OTHERS THEN
2033: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2034: debug_others
2035: (l_proc_name
2036: ,l_proc_step
2037: );

Line 2082: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2078: END LOOP;
2079:
2080: EXCEPTION
2081: WHEN OTHERS THEN
2082: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2083: debug_others
2084: (l_proc_name
2085: ,l_proc_step
2086: );

Line 2176: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2172: WHEN OTHERS THEN
2173: p_part_start_day := NULL;
2174: p_part_end_day := NULL;
2175: p_part_day_UOM := NULL;
2176: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2177: debug_others
2178: (l_proc_name
2179: ,l_proc_step
2180: );

Line 2410: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2406: --RETURN l_error_code;
2407:
2408: EXCEPTION
2409: WHEN OTHERS THEN
2410: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2411: debug_others
2412: (l_proc_name
2413: ,l_proc_step
2414: );

Line 2533: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

2529: -- if the rule is FC...return date start
2530:
2531: EXCEPTION
2532: WHEN OTHERS THEN
2533: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
2534: debug_others
2535: (l_proc_name
2536: ,l_proc_step
2537: );

Line 3081: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3077: --RETURN l_error_code;
3078:
3079: EXCEPTION
3080: WHEN OTHERS THEN
3081: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3082: debug_others
3083: (l_proc_name
3084: ,l_proc_step
3085: );

Line 3350: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3346: --RETURN l_error_code;
3347:
3348: EXCEPTION
3349: WHEN OTHERS THEN
3350: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3351: debug_others
3352: (l_proc_name
3353: ,l_proc_step
3354: );

Line 3437: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

3433: END IF;
3434:
3435: EXCEPTION
3436: WHEN OTHERS THEN
3437: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
3438: debug_others
3439: (l_proc_name
3440: ,l_proc_step
3441: );

Line 3564: g_debug := hr_utility.debug_enabled;

3560: l_override_wp pay_user_columns.user_column_name%TYPE;
3561: l_is_assignment_wp BOOLEAN ;
3562: l_assignment_wp NUMBER := 0; -- Added for the Bug : 13563548
3563: BEGIN
3564: g_debug := hr_utility.debug_enabled;
3565: l_is_assignment_wp := p_is_assignment_wp ;
3566:
3567: IF g_debug THEN
3568: debug_enter(l_proc_name);

Line 4883: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

4879:
4880: EXCEPTION
4881: WHEN OTHERS THEN
4882: p_entitlements_remaining := l_entitlements_remaining_nc;
4883: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
4884: debug_others
4885: (l_proc_name
4886: ,l_proc_step
4887: );

Line 4938: g_debug := hr_utility.debug_enabled;

4934: l_part_day_UOM per_absence_attendances.abs_information3%TYPE;
4935: BEGIN
4936:
4937:
4938: g_debug := hr_utility.debug_enabled;
4939:
4940: IF g_debug THEN
4941: debug_enter(l_proc_name);
4942: debug(p_assignment_id);

Line 5290: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

5286: --END IF; -- IF p_absence_date_start IS NOT NULL THEN -- ie absence not deleted
5287:
5288: EXCEPTION
5289: WHEN OTHERS THEN
5290: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
5291: debug_others
5292: (l_proc_name
5293: ,l_proc_step
5294: );

Line 5386: g_debug := hr_utility.debug_enabled;

5382: l_is_assignment_wp BOOLEAN;
5383:
5384: BEGIN
5385:
5386: g_debug := hr_utility.debug_enabled;
5387:
5388: IF g_debug THEN
5389: debug_enter(l_proc_name);
5390: debug(p_assignment_id);

Line 6023: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6019:
6020:
6021: EXCEPTION
6022: WHEN OTHERS THEN
6023: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6024: debug_others
6025: (l_proc_name
6026: ,l_proc_step
6027: );

Line 6065: g_debug := hr_utility.debug_enabled;

6061:
6062:
6063: BEGIN
6064:
6065: g_debug := hr_utility.debug_enabled;
6066:
6067: l_proc_Step := 10 ;
6068: IF g_debug THEN
6069: debug_enter(l_proc_name);

Line 6113: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6109:
6110: RETURN l_contract_level_wp ;
6111: EXCEPTION
6112: WHEN OTHERS THEN
6113: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6114: debug_others
6115: (l_proc_name
6116: ,l_proc_step
6117: );

Line 6144: g_debug := hr_utility.debug_enabled;

6140: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6141:
6142: BEGIN
6143:
6144: g_debug := hr_utility.debug_enabled;
6145:
6146: l_proc_step := 10 ;
6147: IF g_debug THEN
6148: debug_enter(l_proc_name);

Line 6179: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');

6175: IF p_entitlement_uom <> 'H' THEN
6176: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6177: ELSE
6178: -- Raise Error.
6179: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
6180: hr_utility.raise_error ;
6181: END IF ;
6182: END IF ;
6183:

Line 6180: hr_utility.raise_error ;

6176: l_standard_ft_work_pattern := 'PQP_MON_FRI_8_HOURS';
6177: ELSE
6178: -- Raise Error.
6179: hr_utility.set_message(8303, 'PQP_230000_INVALID_WORK_PAT');
6180: hr_utility.raise_error ;
6181: END IF ;
6182: END IF ;
6183:
6184: l_proc_step := 50 ;

Line 6195: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6191:
6192: EXCEPTION
6193: WHEN OTHERS THEN
6194: p_contract_wp := NULL ;
6195: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6196: debug_others
6197: (l_proc_name
6198: ,l_proc_step
6199: );

Line 6222: g_debug := hr_utility.debug_enabled;

6218: l_standard_ft_work_pattern pqp_assignment_attributes_f.work_pattern%TYPE ;
6219: l_average_days_per_week NUMBER ;
6220: BEGIN
6221:
6222: g_debug := hr_utility.debug_enabled;
6223:
6224: l_proc_step := 10 ;
6225: IF g_debug THEN
6226: debug_enter(l_proc_name);

Line 6261: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6257:
6258:
6259: EXCEPTION
6260: WHEN OTHERS THEN
6261: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6262: debug_others
6263: (l_proc_name
6264: ,l_proc_step
6265: );

Line 6292: g_debug := hr_utility.debug_enabled;

6288:
6289:
6290: BEGIN
6291:
6292: g_debug := hr_utility.debug_enabled;
6293:
6294: l_proc_step := 10 ;
6295: IF g_debug THEN
6296: debug_enter(l_proc_name);

Line 6327: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6323: RETURN l_assignment_work_pattern ;
6324:
6325: EXCEPTION
6326: WHEN OTHERS THEN
6327: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6328: debug_others
6329: (l_proc_name
6330: ,l_proc_step
6331: );

Line 6465: g_debug := hr_utility.debug_enabled;

6461:
6462: l_pl_typ_id ben_pl_f.pl_typ_id%TYPE ;
6463: BEGIN
6464:
6465: g_debug := hr_utility.debug_enabled;
6466:
6467: IF g_debug THEN
6468: debug_enter(l_proc_name);
6469: debug('p_period_start_date:'||p_period_start_date);

Line 6565: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6561: RETURN NVL(l_tot_no_pay_days,0) ;
6562:
6563: EXCEPTION
6564: WHEN OTHERS THEN
6565: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6566: pqp_utilities.debug_others
6567: (l_proc_name
6568: ,l_proc_step
6569: );

Line 6615: g_debug := hr_utility.debug_enabled;

6611: l_current_factor NUMBER ;
6612: l_ft_factor NUMBER ;
6613: BEGIN
6614:
6615: g_debug := hr_utility.debug_enabled;
6616:
6617: IF g_debug THEN
6618: debug_enter(l_proc_name);
6619: debug('p_assignment_id:'||p_assignment_id);

Line 6742: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6738: END IF ;
6739:
6740: EXCEPTION
6741: WHEN OTHERS THEN
6742: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6743: pqp_utilities.debug_others
6744: (l_proc_name
6745: ,l_proc_step
6746: );

Line 6767: g_debug := hr_utility.debug_enabled;

6763: l_entitlements_nc pqp_absval_pkg.t_entitlements ;
6764: i NUMBER ;
6765:
6766: BEGIN
6767: g_debug := hr_utility.debug_enabled;
6768:
6769: IF g_debug THEN
6770: debug_enter(l_proc_name);
6771: debug('p_current_factor:'||p_current_factor);

Line 6811: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN

6807:
6808: EXCEPTION
6809: WHEN OTHERS THEN
6810: p_entitlements := l_entitlements_nc ;
6811: IF SQLCODE <> hr_utility.HR_ERROR_NUMBER THEN
6812: pqp_utilities.debug_others
6813: (l_proc_name
6814: ,l_proc_step
6815: );