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

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

58: open c_abs_overlap_another;
59: fetch c_abs_overlap_another INTO l_exists;
60: if c_abs_overlap_another%found then
61: close c_abs_overlap_another;
62: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
63: hr_utility.raise_error;
64: else
65: close c_abs_overlap_another;
66: end if ;

Line 63: hr_utility.raise_error;

59: fetch c_abs_overlap_another INTO l_exists;
60: if c_abs_overlap_another%found then
61: close c_abs_overlap_another;
62: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
63: hr_utility.raise_error;
64: else
65: close c_abs_overlap_another;
66: end if ;
67: END check_abs_overlap;

Line 96: hr_utility.trace('Entering check_abs_overlap ');

92:
93: b_over_lap boolean := false;
94:
95: begin
96: hr_utility.trace('Entering check_abs_overlap ');
97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));

Line 97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);

93: b_over_lap boolean := false;
94:
95: begin
96: hr_utility.trace('Entering check_abs_overlap ');
97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));

Line 98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);

94:
95: begin
96: hr_utility.trace('Entering check_abs_overlap ');
97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);

Line 99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);

95: begin
96: hr_utility.trace('Entering check_abs_overlap ');
97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);

Line 100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));

96: hr_utility.trace('Entering check_abs_overlap ');
97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:

Line 101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));

97: hr_utility.trace('check_abs_overlap p_person_id:'||p_person_id);
98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:
105: for i in c_abs_overlap_another

Line 102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);

98: hr_utility.trace('check_abs_overlap p_date_start:'||p_date_start);
99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:
105: for i in c_abs_overlap_another
106: loop

Line 103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);

99: hr_utility.trace('check_abs_overlap p_date_end:'||p_date_end);
100: hr_utility.trace('check_abs_overlap p_time_start:'||nvl(p_time_start,'NULL'));
101: hr_utility.trace('check_abs_overlap p_time_end:'||nvl(p_time_end,'NULL'));
102: hr_utility.trace('check_abs_overlap p_absence_attendance_id:'||p_absence_attendance_id);
103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:
105: for i in c_abs_overlap_another
106: loop
107: hr_utility.trace('check_abs_overlap i.end_time:'||i.end_time);

Line 107: hr_utility.trace('check_abs_overlap i.end_time:'||i.end_time);

103: hr_utility.trace('check_abs_overlap hr_api.g_eot:'||hr_api.g_eot);
104:
105: for i in c_abs_overlap_another
106: loop
107: hr_utility.trace('check_abs_overlap i.end_time:'||i.end_time);
108: if nvl(p_time_start,'00:00') <= i.end_time then
109: b_over_lap := true;
110: exit;
111: end if;

Line 115: hr_utility.trace('check_abs_overlap Overlapping Exists');

111: end if;
112: end loop;
113:
114: if b_over_lap then
115: hr_utility.trace('check_abs_overlap Overlapping Exists');
116: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
117: hr_utility.raise_error;
118: else
119: hr_utility.trace('check_abs_overlap No Overlap');

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

112: end loop;
113:
114: if b_over_lap then
115: hr_utility.trace('check_abs_overlap Overlapping Exists');
116: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
117: hr_utility.raise_error;
118: else
119: hr_utility.trace('check_abs_overlap No Overlap');
120: end if;

Line 117: hr_utility.raise_error;

113:
114: if b_over_lap then
115: hr_utility.trace('check_abs_overlap Overlapping Exists');
116: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
117: hr_utility.raise_error;
118: else
119: hr_utility.trace('check_abs_overlap No Overlap');
120: end if;
121: hr_utility.trace('check_abs_overlap Completed.');

Line 119: hr_utility.trace('check_abs_overlap No Overlap');

115: hr_utility.trace('check_abs_overlap Overlapping Exists');
116: hr_utility.set_message(804,'SSP_35084_SIMILAR_ABS_OVERLAP');
117: hr_utility.raise_error;
118: else
119: hr_utility.trace('check_abs_overlap No Overlap');
120: end if;
121: hr_utility.trace('check_abs_overlap Completed.');
122: exception
123: when others then

Line 121: hr_utility.trace('check_abs_overlap Completed.');

117: hr_utility.raise_error;
118: else
119: hr_utility.trace('check_abs_overlap No Overlap');
120: end if;
121: hr_utility.trace('check_abs_overlap Completed.');
122: exception
123: when others then
124: hr_utility.trace('check_abs_overlap Exception:'||sqlerrm);
125: raise;

Line 124: hr_utility.trace('check_abs_overlap Exception:'||sqlerrm);

120: end if;
121: hr_utility.trace('check_abs_overlap Completed.');
122: exception
123: when others then
124: hr_utility.trace('check_abs_overlap Exception:'||sqlerrm);
125: raise;
126: end check_abs_overlap;
127: --
128: --

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

145: BEGIN
146: --
147: -- Added for GSI Bug 5472781
148: --
149: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
150: --
151: l_proc := 'PER_GB_ABSENCE_RULES';
152:
153: hr_utility.set_location('Entering:'|| l_proc, 10);

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

149: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
150: --
151: l_proc := 'PER_GB_ABSENCE_RULES';
152:
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: hr_utility.trace(l_proc||': Opening get_abs_category'||
155: ', p_absence_attendance_id='||p_absence_attendance_id);
156: --
157: -- Get absence_category

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

150: --
151: l_proc := 'PER_GB_ABSENCE_RULES';
152:
153: hr_utility.set_location('Entering:'|| l_proc, 10);
154: hr_utility.trace(l_proc||': Opening get_abs_category'||
155: ', p_absence_attendance_id='||p_absence_attendance_id);
156: --
157: -- Get absence_category
158: --

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

159: OPEN get_abs_category;
160: FETCH get_abs_category INTO l_abs_category;
161: CLOSE get_abs_category;
162: --
163: hr_utility.trace(l_proc||': Closed get_abs_category'||
164: ', l_abs_category='||l_abs_category);
165: --
166: --7157943 when this procedure is called from after delete hook l_abs_category will be NULL
167: --IF l_abs_category = 'S' THEN

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

173: END IF;
174: --
175: END IF;
176: --
177: hr_utility.set_location('Leaving:'|| l_proc, 200);
178: --
179: END sickness_date_update;
180: --
181:

Line 219: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');

215: BEGIN
216: --
217: -- Added for GSI Bug 5472781
218: --
219: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');
220: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
221: --
222: -- Get absence_category
223: --

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

216: --
217: -- Added for GSI Bug 5472781
218: --
219: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');
220: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
221: --
222: -- Get absence_category
223: --
224: OPEN get_abs_category;

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

231: OPEN csr_absences;
232: FETCH csr_absences INTO l_absence;
233: if csr_absences%found then
234: close csr_absences;
235: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
236: hr_utility.raise_error;
237: else
238: close csr_absences;
239: end if;

Line 236: hr_utility.raise_error;

232: FETCH csr_absences INTO l_absence;
233: if csr_absences%found then
234: close csr_absences;
235: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
236: hr_utility.raise_error;
237: else
238: close csr_absences;
239: end if;
240: END IF;

Line 256: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');

252: end if;
253: -- Bug 6888892 begin
254:
255: END IF;
256: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_CREATE ');
257: END validate_abs_create;
258:
259: -------------------------------------------------------------------------------
260: -- VALIDATE_ABS_UPDATE

Line 321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');

317: --7287548 End
318:
319: BEGIN
320: --
321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);

Line 322: hr_utility.trace(' p_date_start '||p_date_start );

318:
319: BEGIN
320: --
321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);

Line 323: hr_utility.trace(' p_date_end '|| p_date_end );

319: BEGIN
320: --
321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.

Line 324: hr_utility.trace(' p_time_start '||p_time_start);

320: --
321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));

Line 325: hr_utility.trace(' p_time_end '|| p_time_end);

321: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_UPDATE ');
322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));
329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));

Line 326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);

322: hr_utility.trace(' p_date_start '||p_date_start );
323: hr_utility.trace(' p_date_end '|| p_date_end );
324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));
329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));
330: */

Line 328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));

324: hr_utility.trace(' p_time_start '||p_time_start);
325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));
329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));
330: */
331: -- Added for GSI Bug 5472781
332: --

Line 329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));

325: hr_utility.trace(' p_time_end '|| p_time_end);
326: hr_utility.trace(' p_absence_attendance_id '||p_absence_attendance_id);
327: /* Commented the debugging message with to_date function.
328: hr_utility.trace(' From date '|| to_date(to_char(p_date_start,'YYYY-MM-DD')|| ' ' ||nvl(p_time_start,'00:00'),'YYYY-MM-DD HH24:MI:SS'));
329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));
330: */
331: -- Added for GSI Bug 5472781
332: --
333: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN

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

329: hr_utility.trace(' to date ' || to_date(to_char(nvl(p_date_end,hr_api.g_eot),'YYYY-MM-DD')|| ' ' ||nvl(p_time_end,'23:59'),'YYYY-MM-DD HH24:MI:SS'));
330: */
331: -- Added for GSI Bug 5472781
332: --
333: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
334: -- Get absence details
335: hr_utility.trace(' before opening cursor csr_abs_details');
336: open csr_abs_details;
337: fetch csr_abs_details into l_abs_type_id,

Line 335: hr_utility.trace(' before opening cursor csr_abs_details');

331: -- Added for GSI Bug 5472781
332: --
333: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
334: -- Get absence details
335: hr_utility.trace(' before opening cursor csr_abs_details');
336: open csr_abs_details;
337: fetch csr_abs_details into l_abs_type_id,
338: l_business_group_id,
339: l_person_id,

Line 350: hr_utility.trace(' after closing cursor csr_abs_details');

346: ,l_time_end;
347: --7287548 End
348: close csr_abs_details;
349: --
350: hr_utility.trace(' after closing cursor csr_abs_details');
351:
352: -- Check if default date is passed in for start/end date
353: -- logic
354: -- if not updating start or end date then skip

Line 360: hr_utility.trace('Satisified IF');

356: -- if updating start/end and exists a future absence then error
357: if trunc(p_date_start) = trunc(hr_api.g_date) and
358: trunc(p_date_end) = trunc(hr_api.g_date) then
359: -- not updating sickness start/end date so skip
360: hr_utility.trace('Satisified IF');
361: null;
362: else
363: hr_utility.trace('Satisfied ELSE');
364: /* Bug Fix 9864927 Start

Line 363: hr_utility.trace('Satisfied ELSE');

359: -- not updating sickness start/end date so skip
360: hr_utility.trace('Satisified IF');
361: null;
362: else
363: hr_utility.trace('Satisfied ELSE');
364: /* Bug Fix 9864927 Start
365: Scenario: Absence Start/End date need not be same as Sickness Start/End Date.
366: For ex., Absence End date can be one day more than the Sickness End Date.
367: So below condition modified.

Line 381: hr_utility.trace(' not updating sickness start/end date so skip ');

377: trunc(l_date_end) = trunc(p_date_end))
378: ) then
379: -- not updating sickness start/end date so skip
380: /* Bug Fix 9864927 End */
381: hr_utility.trace(' not updating sickness start/end date so skip ');
382: null;
383: else
384: -- going to update start or end date, check for future absence
385: -- Get absence_category

Line 387: hr_utility.trace(' going to update start or end date, check for future absence ');

383: else
384: -- going to update start or end date, check for future absence
385: -- Get absence_category
386: --
387: hr_utility.trace(' going to update start or end date, check for future absence ');
388:
389: OPEN get_abs_category(l_abs_type_id, l_business_group_id);
390: FETCH get_abs_category INTO l_abs_category;
391: CLOSE get_abs_category;

Line 394: hr_utility.trace(' after fetching abs category '||l_abs_category);

390: FETCH get_abs_category INTO l_abs_category;
391: CLOSE get_abs_category;
392: --
393: --
394: hr_utility.trace(' after fetching abs category '||l_abs_category);
395:
396: IF l_abs_category = 'S' THEN
397: hr_utility.trace(' for sickness S');
398: if trunc(p_date_start) = trunc(hr_api.g_date) then

Line 397: hr_utility.trace(' for sickness S');

393: --
394: hr_utility.trace(' after fetching abs category '||l_abs_category);
395:
396: IF l_abs_category = 'S' THEN
397: hr_utility.trace(' for sickness S');
398: if trunc(p_date_start) = trunc(hr_api.g_date) then
399: l_param_start := trunc(l_current_start);
400: else
401: l_param_start := trunc(p_date_start);

Line 403: hr_utility.trace(' before csr_absences open');

399: l_param_start := trunc(l_current_start);
400: else
401: l_param_start := trunc(p_date_start);
402: end if;
403: hr_utility.trace(' before csr_absences open');
404: OPEN csr_absences(l_person_id, l_business_group_id,l_param_start);
405: FETCH csr_absences INTO l_absence;
406: if csr_absences%found then
407: close csr_absences;

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

404: OPEN csr_absences(l_person_id, l_business_group_id,l_param_start);
405: FETCH csr_absences INTO l_absence;
406: if csr_absences%found then
407: close csr_absences;
408: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
409: hr_utility.raise_error;
410: else
411: hr_utility.trace('csr_absences not found');
412: close csr_absences;

Line 409: hr_utility.raise_error;

405: FETCH csr_absences INTO l_absence;
406: if csr_absences%found then
407: close csr_absences;
408: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
409: hr_utility.raise_error;
410: else
411: hr_utility.trace('csr_absences not found');
412: close csr_absences;
413: end if;

Line 411: hr_utility.trace('csr_absences not found');

407: close csr_absences;
408: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
409: hr_utility.raise_error;
410: else
411: hr_utility.trace('csr_absences not found');
412: close csr_absences;
413: end if;
414: END IF;
415: end if;

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

416: end if;
417:
418: --7287548 begin
419: If (p_date_start = hr_api.g_date) then
420: hr_utility.trace(' p_date_start value is defaulted '||p_date_start||' Repl by'||l_date_start);
421: v_date_start := l_date_start;
422: else
423: v_date_start := p_date_start;
424: End If;

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

423: v_date_start := p_date_start;
424: End If;
425:
426: If (p_date_end = hr_api.g_date) then
427: hr_utility.trace(' p_date_end value is defaulted '||p_date_end||' Repl by'||l_date_end);
428: v_date_end := l_date_end;
429: else
430: v_date_end := p_date_end;
431: End If;

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

430: v_date_end := p_date_end;
431: End If;
432:
433: If (p_time_start = hr_api.g_varchar2) then
434: hr_utility.trace(' p_time_start value is defaulted '||p_time_start||' Repl by'||l_time_start);
435: v_time_start := l_time_start;
436: else
437: v_time_start := p_time_start;
438: End If;

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

437: v_time_start := p_time_start;
438: End If;
439:
440: If (p_time_end = hr_api.g_varchar2) then
441: hr_utility.trace(' p_time_end value is defaulted '||p_time_end||' Repl by'||l_time_end);
442: v_time_end := l_time_end;
443: else
444: v_time_end := p_time_end;
445: End If;

Line 456: hr_utility.trace(' calling check_abs_overlap');

452: -- Bug 6888892 begin
453: -- To check only in case below mentioned absence categories also
454: -- changed the check to be based on Absence Category
455: if l_abs_category in ('S','M','GB_ADO','GB_PAT_BIRTH','GB_PAT_ADO') then
456: hr_utility.trace(' calling check_abs_overlap');
457: check_abs_overlap( l_person_id, v_date_start, v_date_end
458: ,v_time_start, v_time_end, p_absence_attendance_id
459: -- ,l_abs_type_id) ;
460: ,l_abs_category);

Line 461: hr_utility.trace(' After check_abs_overlap ');

457: check_abs_overlap( l_person_id, v_date_start, v_date_end
458: ,v_time_start, v_time_end, p_absence_attendance_id
459: -- ,l_abs_type_id) ;
460: ,l_abs_category);
461: hr_utility.trace(' After check_abs_overlap ');
462: end if;
463: -- Bug 6888892 begin
464:
465: END IF;

Line 466: hr_utility.trace('Leaving validate_abs_update ');

462: end if;
463: -- Bug 6888892 begin
464:
465: END IF;
466: hr_utility.trace('Leaving validate_abs_update ');
467: END validate_abs_update;
468:
469: -------------------------------------------------------------------------------
470: -- VALIDATE_ABS_DELETE

Line 502: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');

498: BEGIN
499: --
500: -- Added for GSI Bug 5472781
501: --
502: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
503: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
504: --
505: -- Get absence_category
506: --

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

499: --
500: -- Added for GSI Bug 5472781
501: --
502: hr_utility.trace(' Entering PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
503: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
504: --
505: -- Get absence_category
506: --
507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');

Line 507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');

503: IF hr_utility.chk_product_install('Oracle Human Resources', 'GB') THEN
504: --
505: -- Get absence_category
506: --
507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');
508: OPEN get_abs_category;
509: FETCH get_abs_category INTO l_abs_category;
510: CLOSE get_abs_category;
511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);

Line 511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);

507: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : Fetching absence category');
508: OPEN get_abs_category;
509: FETCH get_abs_category INTO l_abs_category;
510: CLOSE get_abs_category;
511: hr_utility.trace('PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE : absence category :'||l_abs_category);
512:
513: IF l_abs_category = 'S' THEN
514: OPEN csr_absences;
515: FETCH csr_absences INTO l_absence;

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

514: OPEN csr_absences;
515: FETCH csr_absences INTO l_absence;
516: if csr_absences%found then
517: close csr_absences;
518: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
519: hr_utility.raise_error;
520: else
521: close csr_absences;
522: end if;

Line 519: hr_utility.raise_error;

515: FETCH csr_absences INTO l_absence;
516: if csr_absences%found then
517: close csr_absences;
518: hr_utility.set_message(804,'SSP_35037_PIW_BROKEN');
519: hr_utility.raise_error;
520: else
521: close csr_absences;
522: end if;
523: END IF;

Line 525: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');

521: close csr_absences;
522: end if;
523: END IF;
524: END IF;
525: hr_utility.trace(' Leaving PER_GB_ABSENCE_RULES.VALIDATE_ABS_DELETE ');
526: END validate_abs_delete;
527: --
528: END per_gb_absence_rules;