1: PACKAGE hxt_batch_val AS
2: /* $Header: hxtbtval.pkh 120.3.12010000.1 2008/07/25 09:48:09 appldev ship $ */
3: c_39315_max_hrs_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
4: := '24_HOUR_EDIT';
5: c_39260_abs_not_asg_to_acrl CONSTANT fnd_lookup_values.lookup_code%TYPE
6: := 'ABS_NOT_ASG_TO_ACRL';
7: c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
1: PACKAGE hxt_batch_val AS
2: /* $Header: hxtbtval.pkh 120.3.12010000.1 2008/07/25 09:48:09 appldev ship $ */
3: c_39315_max_hrs_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
4: := '24_HOUR_EDIT';
5: c_39260_abs_not_asg_to_acrl CONSTANT fnd_lookup_values.lookup_code%TYPE
6: := 'ABS_NOT_ASG_TO_ACRL';
7: c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
8: := 'ACCRUAL_EXCEEDED';
9: c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
3: c_39315_max_hrs_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
4: := '24_HOUR_EDIT';
5: c_39260_abs_not_asg_to_acrl CONSTANT fnd_lookup_values.lookup_code%TYPE
6: := 'ABS_NOT_ASG_TO_ACRL';
7: c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
8: := 'ACCRUAL_EXCEEDED';
9: c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
10: := 'DAY_IS_HOLIDAY';
11: c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
5: c_39260_abs_not_asg_to_acrl CONSTANT fnd_lookup_values.lookup_code%TYPE
6: := 'ABS_NOT_ASG_TO_ACRL';
7: c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
8: := 'ACCRUAL_EXCEEDED';
9: c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
10: := 'DAY_IS_HOLIDAY';
11: c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
12: := 'HOLIDAY_NOT_VAL';
13: c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
7: c_39509_accrual_exceeded CONSTANT fnd_lookup_values.lookup_code%TYPE
8: := 'ACCRUAL_EXCEEDED';
9: c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
10: := 'DAY_IS_HOLIDAY';
11: c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
12: := 'HOLIDAY_NOT_VAL';
13: c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
14: := 'HOURS_NOT_EQUAL';
15: c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
9: c_39332_day_on_hol_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
10: := 'DAY_IS_HOLIDAY';
11: c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
12: := 'HOLIDAY_NOT_VAL';
13: c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
14: := 'HOURS_NOT_EQUAL';
15: c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
16: := 'INSERT_ERRORS';
17: c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
11: c_39333_hol_not_valid_on_cal CONSTANT fnd_lookup_values.lookup_code%TYPE
12: := 'HOLIDAY_NOT_VAL';
13: c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
14: := 'HOURS_NOT_EQUAL';
15: c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
16: := 'INSERT_ERRORS';
17: c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
18: := 'PERSON_NOT_IN_DB';
19: c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
13: c_39334_hrs_chged_ne_cal_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
14: := 'HOURS_NOT_EQUAL';
15: c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
16: := 'INSERT_ERRORS';
17: c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
18: := 'PERSON_NOT_IN_DB';
19: c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
20: := 'PTO_CHG_ACCRUED';
21: c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
15: c_39338_ins_error_occ CONSTANT fnd_lookup_values.lookup_code%TYPE
16: := 'INSERT_ERRORS';
17: c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
18: := 'PERSON_NOT_IN_DB';
19: c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
20: := 'PTO_CHG_ACCRUED';
21: c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
22: := 'TIMECARD_ERRORS';
23: c_39317_empl_inactive CONSTANT fnd_lookup_values.lookup_code%TYPE
17: c_39316_person_nf CONSTANT fnd_lookup_values.lookup_code%TYPE
18: := 'PERSON_NOT_IN_DB';
19: c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
20: := 'PTO_CHG_ACCRUED';
21: c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
22: := 'TIMECARD_ERRORS';
23: c_39317_empl_inactive CONSTANT fnd_lookup_values.lookup_code%TYPE
24: := 'TIMECARD_INACTIVE';
25: c_39337_timecard_not_apprved CONSTANT fnd_lookup_values.lookup_code%TYPE
19: c_39335_exceeded_accrued_hrs CONSTANT fnd_lookup_values.lookup_code%TYPE
20: := 'PTO_CHG_ACCRUED';
21: c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
22: := 'TIMECARD_ERRORS';
23: c_39317_empl_inactive CONSTANT fnd_lookup_values.lookup_code%TYPE
24: := 'TIMECARD_INACTIVE';
25: c_39337_timecard_not_apprved CONSTANT fnd_lookup_values.lookup_code%TYPE
26: := 'TIMECARD_NOT_APPROVED';
27:
21: c_39336_errs_in_batch CONSTANT fnd_lookup_values.lookup_code%TYPE
22: := 'TIMECARD_ERRORS';
23: c_39317_empl_inactive CONSTANT fnd_lookup_values.lookup_code%TYPE
24: := 'TIMECARD_INACTIVE';
25: c_39337_timecard_not_apprved CONSTANT fnd_lookup_values.lookup_code%TYPE
26: := 'TIMECARD_NOT_APPROVED';
27:
28: FUNCTION error_level
29: RETURN NUMBER;