DBA Data[Home] [Help]

APPS.HR_GENERIC_UTIL dependencies on HR_UTILITY

Line 21: hr_utility.set_location(l_proc, 10);

17: l_proc VARCHAR2(100) := 'hr_generic_util.GET_PERIOD_DETAILS';
18: --
19: BEGIN
20: --
21: hr_utility.set_location(l_proc, 10);
22: --
23: SELECT number_per_fiscal_year
24: INTO l_no_periods
25: FROM per_time_period_types

Line 28: hr_utility.set_location(l_proc, 20);

24: INTO l_no_periods
25: FROM per_time_period_types
26: WHERE period_type = p_proc_period_type;
27: --
28: hr_utility.set_location(l_proc, 20);
29: --
30: -- Use the number of periods in a fiscal year to deduce the base
31: -- period and multiple.
32: --

Line 62: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');

58: p_base_period_type := WEEKLY;
59: p_multiple := 1;
60: ELSE
61: -- Unknown period type.
62: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');
63: hr_utility.raise_error;
64: END IF;
65: --
66: hr_utility.set_location(l_proc, 30);

Line 63: hr_utility.raise_error;

59: p_multiple := 1;
60: ELSE
61: -- Unknown period type.
62: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');
63: hr_utility.raise_error;
64: END IF;
65: --
66: hr_utility.set_location(l_proc, 30);
67: --

Line 66: hr_utility.set_location(l_proc, 30);

62: hr_utility.set_message(801, 'PAY_6601_PAYROLL_INV_PERIOD_TP');
63: hr_utility.raise_error;
64: END IF;
65: --
66: hr_utility.set_location(l_proc, 30);
67: --
68: END get_period_details;
69: --
70: --

Line 88: hr_utility.set_location(l_proc, 1);

84: l_proc VARCHAR2(100) := 'hr_generic_util.next_semi_month';
85: --
86: BEGIN
87: --
88: hr_utility.set_location(l_proc, 1);
89: --
90: day_of_month := substr(to_char(p_fpe_date, 'DD-MM-YYYY'), 1, 2);
91: --
92: IF (day_of_month = '15') OR (last_day(p_fpe_date) = p_fpe_date) THEN

Line 148: -- hr_utility.set_location(l_proc, 10);

144: -- Errors can occur when performing date manipulation.
145: --
146: IF p_base_period_type = WEEKLY THEN
147: --
148: -- hr_utility.set_location(l_proc, 10);
149: --
150: return (p_target_date + (7 * p_multiple));
151: --
152: ELSIF p_base_period_type = MONTHLY THEN

Line 154: -- hr_utility.set_location(l_proc, 20);

150: return (p_target_date + (7 * p_multiple));
151: --
152: ELSIF p_base_period_type = MONTHLY THEN
153: --
154: -- hr_utility.set_location(l_proc, 20);
155: --
156: return (add_months(p_target_date, p_multiple));
157: --
158: ELSE

Line 207: hr_utility.set_location(l_proc, 10);

203:
204:
205: return;
206:
207: hr_utility.set_location(l_proc, 10);
208: --
209: IF p_rec_period_start_date > p_current_date THEN
210: hr_utility.set_message(809, 'HXC_APR_REC_DATE_LATER');
211: hr_utility.raise_error;

Line 210: hr_utility.set_message(809, 'HXC_APR_REC_DATE_LATER');

206:
207: hr_utility.set_location(l_proc, 10);
208: --
209: IF p_rec_period_start_date > p_current_date THEN
210: hr_utility.set_message(809, 'HXC_APR_REC_DATE_LATER');
211: hr_utility.raise_error;
212: END IF;
213: --
214: get_period_details(p_period_type,

Line 211: hr_utility.raise_error;

207: hr_utility.set_location(l_proc, 10);
208: --
209: IF p_rec_period_start_date > p_current_date THEN
210: hr_utility.set_message(809, 'HXC_APR_REC_DATE_LATER');
211: hr_utility.raise_error;
212: END IF;
213: --
214: get_period_details(p_period_type,
215: l_base_period_type,

Line 218: hr_utility.set_location(l_proc, 20);

214: get_period_details(p_period_type,
215: l_base_period_type,
216: l_multiple);
217: --
218: hr_utility.set_location(l_proc, 20);
219: --
220: l_period_start_date := p_rec_period_start_date;
221: l_period_end_date := add_multiple_of_base(l_period_start_date - 1,
222: l_base_period_type,

Line 241: hr_utility.set_location(l_proc, 70);

237: l_period_start_date - 1);
238: END LOOP;
239:
240: --
241: hr_utility.set_location(l_proc, 70);
242: --
243: p_period_start_date := l_period_start_date;
244: p_period_end_date := l_period_end_date;
245: --

Line 246: hr_utility.set_location(l_proc, 110);

242: --
243: p_period_start_date := l_period_start_date;
244: p_period_end_date := l_period_end_date;
245: --
246: hr_utility.set_location(l_proc, 110);
247: --
248: END get_period_dates;
249: --
250: END hr_generic_util;