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.

[Home] [Help]

APPS.PER_GB_ABSENCE_RULES dependencies on HR_UTILITY

Line 58: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');

54: open c_abs_overlap_another;
55: fetch c_abs_overlap_another INTO l_exists;
56: if c_abs_overlap_another%found then
57: close c_abs_overlap_another;
58: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
59: hr_utility.raise_error;
60: else
61: close c_abs_overlap_another;
62: end if ;

Line 59: hr_utility.raise_error;

55: fetch c_abs_overlap_another INTO l_exists;
56: if c_abs_overlap_another%found then
57: close c_abs_overlap_another;
58: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
59: hr_utility.raise_error;
60: else
61: close c_abs_overlap_another;
62: end if ;
63: END check_abs_overlap;

Line 87: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

83: BEGIN
84: --
85: -- Added for GSI Bug 5472781
86: --
87: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
88: --
89: l_proc := 'PER_GB_ABSENCE_RULES';
90:
91: hr_utility.set_location('Entering:'|| l_proc, 10);

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

87: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
88: --
89: l_proc := 'PER_GB_ABSENCE_RULES';
90:
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: hr_utility.trace(l_proc||': Opening get_abs_category'||
93: ', p_absence_attendance_id='||p_absence_attendance_id);
94: --
95: -- Get absence_category

Line 92: hr_utility.trace(l_proc||': Opening get_abs_category'||

88: --
89: l_proc := 'PER_GB_ABSENCE_RULES';
90:
91: hr_utility.set_location('Entering:'|| l_proc, 10);
92: hr_utility.trace(l_proc||': Opening get_abs_category'||
93: ', p_absence_attendance_id='||p_absence_attendance_id);
94: --
95: -- Get absence_category
96: --

Line 101: hr_utility.trace(l_proc||': Closed get_abs_category'||

97: OPEN get_abs_category;
98: FETCH get_abs_category INTO l_abs_category;
99: CLOSE get_abs_category;
100: --
101: hr_utility.trace(l_proc||': Closed get_abs_category'||
102: ', l_abs_category='||l_abs_category);
103: --
104: --7157943 when this procedure is called from after delete hook l_abs_category will be NULL
105: --IF l_abs_category = 'S' THEN

Line 115: hr_utility.set_location('Leaving:'|| l_proc, 200);

111: END IF;
112: --
113: END IF;
114: --
115: hr_utility.set_location('Leaving:'|| l_proc, 200);
116: --
117: END sickness_date_update;
118: --
119:

Line 157: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

153: BEGIN
154: --
155: -- Added for GSI Bug 5472781
156: --
157: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
158: --
159: -- Get absence_category
160: --
161: OPEN get_abs_category;

Line 172: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');

168: OPEN csr_absences;
169: FETCH csr_absences INTO l_absence;
170: if csr_absences%found then
171: close csr_absences;
172: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
173: hr_utility.raise_error;
174: else
175: close csr_absences;
176: end if;

Line 173: hr_utility.raise_error;

169: FETCH csr_absences INTO l_absence;
170: if csr_absences%found then
171: close csr_absences;
172: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
173: hr_utility.raise_error;
174: else
175: close csr_absences;
176: end if;
177: END IF;

Line 258: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

254: BEGIN
255: --
256: -- Added for GSI Bug 5472781
257: --
258: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
259: -- Get absence details
260: open csr_abs_details;
261: fetch csr_abs_details into l_abs_type_id,
262: l_business_group_id,

Line 307: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');

303: OPEN csr_absences(l_person_id, l_business_group_id,l_param_start);
304: FETCH csr_absences INTO l_absence;
305: if csr_absences%found then
306: close csr_absences;
307: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
308: hr_utility.raise_error;
309: else
310: close csr_absences;
311: end if;

Line 308: hr_utility.raise_error;

304: FETCH csr_absences INTO l_absence;
305: if csr_absences%found then
306: close csr_absences;
307: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
308: hr_utility.raise_error;
309: else
310: close csr_absences;
311: end if;
312: END IF;

Line 318: hr_utility.trace(' p_date_start value is defaulted '||p_date_start||' Repl by'||l_date_start);

314: end if;
315:
316: --7287548 begin
317: If (p_date_start = hr_api.g_date) then
318: hr_utility.trace(' p_date_start value is defaulted '||p_date_start||' Repl by'||l_date_start);
319: v_date_start := l_date_start;
320: else
321: v_date_start := p_date_start;
322: End If;

Line 325: hr_utility.trace(' p_date_end value is defaulted '||p_date_end||' Repl by'||l_date_end);

321: v_date_start := p_date_start;
322: End If;
323:
324: If (p_date_end = hr_api.g_date) then
325: hr_utility.trace(' p_date_end value is defaulted '||p_date_end||' Repl by'||l_date_end);
326: v_date_end := l_date_end;
327: else
328: v_date_end := p_date_end;
329: End If;

Line 332: hr_utility.trace(' p_time_start value is defaulted '||p_time_start||' Repl by'||l_time_start);

328: v_date_end := p_date_end;
329: End If;
330:
331: If (p_time_start = hr_api.g_varchar2) then
332: hr_utility.trace(' p_time_start value is defaulted '||p_time_start||' Repl by'||l_time_start);
333: v_time_start := l_time_start;
334: else
335: v_time_start := p_time_start;
336: End If;

Line 339: hr_utility.trace(' p_time_end value is defaulted '||p_time_end||' Repl by'||l_time_end);

335: v_time_start := p_time_start;
336: End If;
337:
338: If (p_time_end = hr_api.g_varchar2) then
339: hr_utility.trace(' p_time_end value is defaulted '||p_time_end||' Repl by'||l_time_end);
340: v_time_end := l_time_end;
341: else
342: v_time_end := p_time_end;
343: End If;

Line 397: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

393: BEGIN
394: --
395: -- Added for GSI Bug 5472781
396: --
397: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
398: --
399: -- Get absence_category
400: --
401: OPEN get_abs_category;

Line 412: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');

408: OPEN csr_absences;
409: FETCH csr_absences INTO l_absence;
410: if csr_absences%found then
411: close csr_absences;
412: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
413: hr_utility.raise_error;
414: else
415: close csr_absences;
416: end if;

Line 413: hr_utility.raise_error;

409: FETCH csr_absences INTO l_absence;
410: if csr_absences%found then
411: close csr_absences;
412: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
413: hr_utility.raise_error;
414: else
415: close csr_absences;
416: end if;
417: END IF;