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

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: g_package CONSTANT VARCHAR2 (33) := 'hxt_batch_val.';
5: -- Global Error Level - used to store worst error that occured
6: g_error_level NUMBER (1) := 0;
7: g_tc_error_level NUMBER (1) := 0;
8: g_debug boolean := hr_utility.debug_enabled;
9:
10: -- Bug 6785744
11: -- Global variable to record the date inserted into fnd_sessions when
12: -- the process starts. In case the process crosses over a midnight, a new

Line 29: g_debug :=hr_utility.debug_enabled;

25: RETURN NUMBER
26: IS
27: l_proc VARCHAR2 (72) ;
28: BEGIN
29: g_debug :=hr_utility.debug_enabled;
30: if g_debug then
31: l_proc := g_package
32: || 'error_level';
33: hr_utility.set_location ( 'Entering:'

Line 33: hr_utility.set_location ( 'Entering:'

29: g_debug :=hr_utility.debug_enabled;
30: if g_debug then
31: l_proc := g_package
32: || 'error_level';
33: hr_utility.set_location ( 'Entering:'
34: || l_proc, 10);
35: hr_utility.set_location (
36: ' returning error level '
37: || g_error_level,

Line 35: hr_utility.set_location (

31: l_proc := g_package
32: || 'error_level';
33: hr_utility.set_location ( 'Entering:'
34: || l_proc, 10);
35: hr_utility.set_location (
36: ' returning error level '
37: || g_error_level,
38: 20
39: );

Line 40: hr_utility.set_location ( 'Leaving:'

36: ' returning error level '
37: || g_error_level,
38: 20
39: );
40: hr_utility.set_location ( 'Leaving:'
41: || l_proc, 30);
42: end if;
43: RETURN g_error_level;
44: END error_level;

Line 51: g_debug :=hr_utility.debug_enabled;

47: RETURN NUMBER
48: IS
49: l_proc VARCHAR2 (72) ;
50: BEGIN
51: g_debug :=hr_utility.debug_enabled;
52: if g_debug then
53: l_proc := g_package
54: || 'tc_error_level';
55: hr_utility.set_location ( 'Entering:'

Line 55: hr_utility.set_location ( 'Entering:'

51: g_debug :=hr_utility.debug_enabled;
52: if g_debug then
53: l_proc := g_package
54: || 'tc_error_level';
55: hr_utility.set_location ( 'Entering:'
56: || l_proc, 10);
57: hr_utility.set_location (
58: ' returning timecard error level '
59: || g_tc_error_level,

Line 57: hr_utility.set_location (

53: l_proc := g_package
54: || 'tc_error_level';
55: hr_utility.set_location ( 'Entering:'
56: || l_proc, 10);
57: hr_utility.set_location (
58: ' returning timecard error level '
59: || g_tc_error_level,
60: 20
61: );

Line 62: hr_utility.set_location ( 'Leaving:'

58: ' returning timecard error level '
59: || g_tc_error_level,
60: 20
61: );
62: hr_utility.set_location ( 'Leaving:'
63: || l_proc, 30);
64: end if;
65: RETURN g_tc_error_level;
66: END tc_error_level;

Line 72: g_debug :=hr_utility.debug_enabled;

68: PROCEDURE set_tc_error_level (p_tc_error_level IN NUMBER)
69: IS
70: l_proc VARCHAR2 (72) ;
71: BEGIN
72: g_debug :=hr_utility.debug_enabled;
73: if g_debug then
74: l_proc := g_package
75: || 'set_tc_error_level';
76: hr_utility.set_location ( 'Entering:'

Line 76: hr_utility.set_location ( 'Entering:'

72: g_debug :=hr_utility.debug_enabled;
73: if g_debug then
74: l_proc := g_package
75: || 'set_tc_error_level';
76: hr_utility.set_location ( 'Entering:'
77: || l_proc, 10);
78: end if;
79: g_tc_error_level := p_tc_error_level;
80: if g_debug then

Line 81: hr_utility.set_location ( 'Leaving:'

77: || l_proc, 10);
78: end if;
79: g_tc_error_level := p_tc_error_level;
80: if g_debug then
81: hr_utility.set_location ( 'Leaving:'
82: || l_proc, 30);
83: end if;
84: END set_tc_error_level;
85:

Line 90: g_debug :=hr_utility.debug_enabled;

86: PROCEDURE set_tc_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2)
87: IS
88: l_proc VARCHAR2 (72) ;
89: BEGIN
90: g_debug :=hr_utility.debug_enabled;
91: if g_debug then
92: l_proc := g_package
93: || 'set_tc_error_level';
94: hr_utility.set_location ( 'Entering:'

Line 94: hr_utility.set_location ( 'Entering:'

90: g_debug :=hr_utility.debug_enabled;
91: if g_debug then
92: l_proc := g_package
93: || 'set_tc_error_level';
94: hr_utility.set_location ( 'Entering:'
95: || l_proc, 10);
96: end if;
97: IF p_valid = 'N' THEN
98: IF (p_msg_level = 'S') THEN

Line 108: hr_utility.set_location ( 'Leaving:'

104: END IF;
105: END IF;
106:
107: if g_debug then
108: hr_utility.set_location ( 'Leaving:'
109: || l_proc, 30);
110: end if;
111: END set_tc_error_level;
112:

Line 117: g_debug :=hr_utility.debug_enabled;

113: PROCEDURE set_error_level (p_error_level IN NUMBER)
114: IS
115: l_proc VARCHAR2 (72) ;
116: BEGIN
117: g_debug :=hr_utility.debug_enabled;
118: if g_debug then
119: l_proc := g_package
120: || 'set_error_level';
121: hr_utility.set_location ( 'Entering:'

Line 121: hr_utility.set_location ( 'Entering:'

117: g_debug :=hr_utility.debug_enabled;
118: if g_debug then
119: l_proc := g_package
120: || 'set_error_level';
121: hr_utility.set_location ( 'Entering:'
122: || l_proc, 10);
123: end if;
124: g_error_level := p_error_level;
125: if g_debug then

Line 126: hr_utility.set_location ( 'Leaving:'

122: || l_proc, 10);
123: end if;
124: g_error_level := p_error_level;
125: if g_debug then
126: hr_utility.set_location ( 'Leaving:'
127: || l_proc, 30);
128: end if;
129: END set_error_level;
130:

Line 135: g_debug :=hr_utility.debug_enabled;

131: PROCEDURE reset_error_level
132: IS
133: l_proc VARCHAR2 (72) ;
134: BEGIN
135: g_debug :=hr_utility.debug_enabled;
136: if g_debug then
137: l_proc := g_package
138: || 'reset_error_level';
139: hr_utility.set_location ( 'Entering:'

Line 139: hr_utility.set_location ( 'Entering:'

135: g_debug :=hr_utility.debug_enabled;
136: if g_debug then
137: l_proc := g_package
138: || 'reset_error_level';
139: hr_utility.set_location ( 'Entering:'
140: || l_proc, 10);
141: end if;
142: g_error_level := 0;
143: if g_debug then

Line 144: hr_utility.set_location ( 'Leaving:'

140: || l_proc, 10);
141: end if;
142: g_error_level := 0;
143: if g_debug then
144: hr_utility.set_location ( 'Leaving:'
145: || l_proc, 30);
146: end if;
147: END reset_error_level;
148:

Line 153: g_debug :=hr_utility.debug_enabled;

149: PROCEDURE set_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2)
150: IS
151: l_proc VARCHAR2 (72) ;
152: BEGIN
153: g_debug :=hr_utility.debug_enabled;
154: if g_debug then
155: l_proc := g_package
156: || 'set_error_level';
157: hr_utility.set_location ( 'Entering:'

Line 157: hr_utility.set_location ( 'Entering:'

153: g_debug :=hr_utility.debug_enabled;
154: if g_debug then
155: l_proc := g_package
156: || 'set_error_level';
157: hr_utility.set_location ( 'Entering:'
158: || l_proc, 10);
159: end if;
160: IF p_valid = 'N'
161: THEN

Line 175: hr_utility.set_location ( 'Leaving:'

171: END IF;
172: END IF;
173:
174: if g_debug then
175: hr_utility.set_location ( 'Leaving:'
176: || l_proc, 30);
177: end if;
178: END set_error_level;
179:

Line 186: g_debug :=hr_utility.debug_enabled;

182: )
183: AS
184: l_proc VARCHAR2 (72) ;
185: BEGIN
186: g_debug :=hr_utility.debug_enabled;
187: if g_debug then
188: l_proc := g_package
189: || 'delete_prev_val_errors';
190: hr_utility.set_location ( 'Entering:'

Line 190: hr_utility.set_location ( 'Entering:'

186: g_debug :=hr_utility.debug_enabled;
187: if g_debug then
188: l_proc := g_package
189: || 'delete_prev_val_errors';
190: hr_utility.set_location ( 'Entering:'
191: || l_proc, 10);
192: end if;
193: DELETE FROM hxt_errors_x
194: WHERE ppb_id = p_batch_id AND location LIKE 'Validate%';

Line 197: hr_utility.set_location ( 'Leaving:'

193: DELETE FROM hxt_errors_x
194: WHERE ppb_id = p_batch_id AND location LIKE 'Validate%';
195:
196: if g_debug then
197: hr_utility.set_location ( 'Leaving:'
198: || l_proc, 20);
199: end if;
200: END delete_prev_val_errors;
201:

Line 206: g_debug :=hr_utility.debug_enabled;

202: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE)
203: AS
204: l_proc VARCHAR2 (72) ;
205: BEGIN
206: g_debug :=hr_utility.debug_enabled;
207: if g_debug then
208: l_proc := g_package
209: || 'delete_prev_val_errors';
210: hr_utility.set_location ( 'Entering:'

Line 210: hr_utility.set_location ( 'Entering:'

206: g_debug :=hr_utility.debug_enabled;
207: if g_debug then
208: l_proc := g_package
209: || 'delete_prev_val_errors';
210: hr_utility.set_location ( 'Entering:'
211: || l_proc, 10);
212: end if;
213: DELETE FROM hxt_errors_x
214: WHERE tim_id = p_tim_id AND location LIKE 'Validate%';

Line 217: hr_utility.set_location ( 'Leaving:'

213: DELETE FROM hxt_errors_x
214: WHERE tim_id = p_tim_id AND location LIKE 'Validate%';
215:
216: if g_debug then
217: hr_utility.set_location ( 'Leaving:'
218: || l_proc, 20);
219: end if;
220: END delete_prev_val_errors;
221:

Line 236: g_debug :=hr_utility.debug_enabled;

232:
233: l_find_error NUMBER;
234: l_error_exist BOOLEAN;
235: BEGIN
236: g_debug :=hr_utility.debug_enabled;
237: if g_debug then
238: l_proc := g_package
239: || 'errors_exist';
240: hr_utility.set_location ( 'Entering:'

Line 240: hr_utility.set_location ( 'Entering:'

236: g_debug :=hr_utility.debug_enabled;
237: if g_debug then
238: l_proc := g_package
239: || 'errors_exist';
240: hr_utility.set_location ( 'Entering:'
241: || l_proc, 10);
242: end if;
243: OPEN find_errors (p_tim_id);
244: FETCH find_errors INTO l_find_error;

Line 249: hr_utility.set_location (

245:
246: IF find_errors%FOUND
247: THEN
248: if g_debug then
249: hr_utility.set_location (
250: ' Errors exist for TC '
251: || p_tim_id,
252: 20
253: );

Line 262: hr_utility.set_location ( 'Leaving:'

258: END IF;
259:
260: CLOSE find_errors;
261: if g_debug then
262: hr_utility.set_location ( 'Leaving:'
263: || l_proc, 100);
264: end if;
265: RETURN l_error_exist;
266: END errors_exist;

Line 281: g_debug :=hr_utility.debug_enabled;

277: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
278:
279: l_tc_end_dt per_time_periods.end_date%TYPE;
280: BEGIN
281: g_debug :=hr_utility.debug_enabled;
282: if g_debug then
283: l_proc := g_package
284: || 'timecard_end_date';
285: hr_utility.set_location ( 'Entering:'

Line 285: hr_utility.set_location ( 'Entering:'

281: g_debug :=hr_utility.debug_enabled;
282: if g_debug then
283: l_proc := g_package
284: || 'timecard_end_date';
285: hr_utility.set_location ( 'Entering:'
286: || l_proc, 10);
287: end if;
288: OPEN csr_timecard_end_date (p_tim_id);
289: FETCH csr_timecard_end_date INTO l_tc_end_dt;

Line 292: hr_utility.set_location ( ' returning '

288: OPEN csr_timecard_end_date (p_tim_id);
289: FETCH csr_timecard_end_date INTO l_tc_end_dt;
290: CLOSE csr_timecard_end_date;
291: if g_debug then
292: hr_utility.set_location ( ' returning '
293: || l_tc_end_dt, 30);
294: hr_utility.set_location ( 'Leaving:'
295: || l_proc, 20);
296: end if;

Line 294: hr_utility.set_location ( 'Leaving:'

290: CLOSE csr_timecard_end_date;
291: if g_debug then
292: hr_utility.set_location ( ' returning '
293: || l_tc_end_dt, 30);
294: hr_utility.set_location ( 'Leaving:'
295: || l_proc, 20);
296: end if;
297: RETURN l_tc_end_dt;
298: END timecard_end_date;

Line 324: g_debug :=hr_utility.debug_enabled;

320: l_person_effective BOOLEAN;
321: l_found_person NUMBER;
322: l_eff_dt per_people_f.effective_end_date%TYPE;
323: BEGIN
324: g_debug :=hr_utility.debug_enabled;
325: if g_debug then
326: l_proc := g_package
327: || 'person_effective_at_tc_end';
328: hr_utility.set_location ( 'Entering:'

Line 328: hr_utility.set_location ( 'Entering:'

324: g_debug :=hr_utility.debug_enabled;
325: if g_debug then
326: l_proc := g_package
327: || 'person_effective_at_tc_end';
328: hr_utility.set_location ( 'Entering:'
329: || l_proc, 10);
330: end if;
331: l_eff_dt := timecard_end_date (p_tim_id => p_tim_id);
332: OPEN csr_person_effective (l_eff_dt, p_person_id);

Line 338: hr_utility.set_location (

334:
335: IF (csr_person_effective%FOUND)
336: THEN
337: if g_debug then
338: hr_utility.set_location (
339: ' Person '
340: || p_person_id
341: || ' is effective on '
342: || l_eff_dt

Line 354: hr_utility.set_location ( 'Leaving:'

350: END IF;
351:
352: CLOSE csr_person_effective;
353: if g_debug then
354: hr_utility.set_location ( 'Leaving:'
355: || l_proc, 20);
356: end if;
357: RETURN l_person_effective;
358: END person_effective_at_tc_end;

Line 373: g_debug :=hr_utility.debug_enabled;

369: l_error_msg VARCHAR2 (255);
370: l_valid VARCHAR2 (1);
371: l_msg_level VARCHAR2 (1);
372: BEGIN
373: g_debug :=hr_utility.debug_enabled;
374: if g_debug then
375: l_proc := g_package
376: || 'record_error';
377: hr_utility.set_location ( 'Entering:'

Line 377: hr_utility.set_location ( 'Entering:'

373: g_debug :=hr_utility.debug_enabled;
374: if g_debug then
375: l_proc := g_package
376: || 'record_error';
377: hr_utility.set_location ( 'Entering:'
378: || l_proc, 10);
379: end if;
380: hxt_util.set_timecard_error (
381: p_batch_id,

Line 395: hr_utility.set_location ( 'Leaving:'

391: );
392: set_error_level (p_valid => l_valid, p_msg_level => l_msg_level);
393: set_tc_error_level (p_valid => l_valid, p_msg_level => l_msg_level);
394: if g_debug then
395: hr_utility.set_location ( 'Leaving:'
396: || l_proc, 100);
397: end if;
398: END record_error;
399:

Line 412: g_debug :=hr_utility.debug_enabled;

408: l_error_msg VARCHAR2 (255);
409: l_valid VARCHAR2 (1);
410: l_msg_level VARCHAR2 (1);
411: BEGIN
412: g_debug :=hr_utility.debug_enabled;
413: if g_debug then
414: l_proc := g_package
415: || 'person_validation';
416: hr_utility.set_location ( 'Entering:'

Line 416: hr_utility.set_location ( 'Entering:'

412: g_debug :=hr_utility.debug_enabled;
413: if g_debug then
414: l_proc := g_package
415: || 'person_validation';
416: hr_utility.set_location ( 'Entering:'
417: || l_proc, 10);
418: end if;
419: IF NOT (person_effective_at_tc_end (
420: p_person_id=> p_person_id,

Line 462: hr_utility.set_location ( 'Leaving:'

458: g_errtab.DELETE(c_39316_person_nf);
459: END IF;
460:
461: if g_debug then
462: hr_utility.set_location ( 'Leaving:'
463: || l_proc, 100);
464: end if;
465: END person_validation;
466:

Line 480: g_debug :=hr_utility.debug_enabled;

476: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
477: l_charged_hrs NUMBER;
478: l_accrued_hrs NUMBER;
479: BEGIN
480: g_debug :=hr_utility.debug_enabled;
481: if g_debug then
482: l_proc := g_package
483: || 'excess_pto';
484: hr_utility.set_location ( 'Entering:'

Line 484: hr_utility.set_location ( 'Entering:'

480: g_debug :=hr_utility.debug_enabled;
481: if g_debug then
482: l_proc := g_package
483: || 'excess_pto';
484: hr_utility.set_location ( 'Entering:'
485: || l_proc, 10);
486: end if;
487:
488: -- M.Bhammar - Bug:5107665

Line 541: hr_utility.set_location ( 'Leaving:'

537: END IF;
538:
539: -- hr_session_utilities.remove_session_row; /* Bug 6024976 */
540: if g_debug then
541: hr_utility.set_location ( 'Leaving:'
542: || l_proc, 100);
543: end if;
544: END excess_pto;
545:

Line 579: g_debug :=hr_utility.debug_enabled;

575: past.per_system_status = 'ACTIVE_ASSIGN';
576:
577: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;
578: BEGIN
579: g_debug :=hr_utility.debug_enabled;
580: if g_debug then
581: l_proc := g_package
582: || 'primary_assignment_id';
583: hr_utility.set_location ( 'Entering:'

Line 583: hr_utility.set_location ( 'Entering:'

579: g_debug :=hr_utility.debug_enabled;
580: if g_debug then
581: l_proc := g_package
582: || 'primary_assignment_id';
583: hr_utility.set_location ( 'Entering:'
584: || l_proc, 10);
585: end if;
586: OPEN csr_prim_asg_id (p_person_id, p_effective_date);
587: FETCH csr_prim_asg_id INTO l_prim_asg_id;

Line 590: hr_utility.set_location ( ' returning '

586: OPEN csr_prim_asg_id (p_person_id, p_effective_date);
587: FETCH csr_prim_asg_id INTO l_prim_asg_id;
588: CLOSE csr_prim_asg_id;
589: if g_debug then
590: hr_utility.set_location ( ' returning '
591: || l_prim_asg_id, 20);
592: hr_utility.set_location ( 'Leaving:'
593: || l_proc, 30);
594: end if;

Line 592: hr_utility.set_location ( 'Leaving:'

588: CLOSE csr_prim_asg_id;
589: if g_debug then
590: hr_utility.set_location ( ' returning '
591: || l_prim_asg_id, 20);
592: hr_utility.set_location ( 'Leaving:'
593: || l_proc, 30);
594: end if;
595: RETURN l_prim_asg_id;
596: END primary_assignment_id;

Line 607: g_debug :=hr_utility.debug_enabled;

603: IS
604: l_proc VARCHAR2 (72) ;
605: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
606: BEGIN
607: g_debug :=hr_utility.debug_enabled;
608: if g_debug then
609: l_proc := g_package
610: || 'holiday_calendar_id';
611: hr_utility.set_location ( 'Entering:'

Line 611: hr_utility.set_location ( 'Entering:'

607: g_debug :=hr_utility.debug_enabled;
608: if g_debug then
609: l_proc := g_package
610: || 'holiday_calendar_id';
611: hr_utility.set_location ( 'Entering:'
612: || l_proc, 10);
613: end if;
614: l_holiday_calendar_id :=
615: holiday_calendar_id (

Line 623: hr_utility.set_location (

619: ),
620: p_effective_date=> p_effective_date
621: );
622: if g_debug then
623: hr_utility.set_location (
624: ' returning '
625: || l_holiday_calendar_id,
626: 20
627: );

Line 628: hr_utility.set_location ( 'Leaving:'

624: ' returning '
625: || l_holiday_calendar_id,
626: 20
627: );
628: hr_utility.set_location ( 'Leaving:'
629: || l_proc, 30);
630: end if;
631: RETURN l_holiday_calendar_id;
632: END holiday_calendar_id;

Line 663: g_debug :=hr_utility.debug_enabled;

659: AND haaif.assignment_id = p_assignment_id;
660:
661: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
662: BEGIN
663: g_debug :=hr_utility.debug_enabled;
664: if g_debug then
665: l_proc := g_package
666: || 'holiday_calendar_id';
667: hr_utility.set_location ( 'Entering:'

Line 667: hr_utility.set_location ( 'Entering:'

663: g_debug :=hr_utility.debug_enabled;
664: if g_debug then
665: l_proc := g_package
666: || 'holiday_calendar_id';
667: hr_utility.set_location ( 'Entering:'
668: || l_proc, 10);
669: end if;
670: OPEN csr_holiday_calendar_id (p_assignment_id, p_effective_date);
671: FETCH csr_holiday_calendar_id INTO l_holiday_calendar_id;

Line 674: hr_utility.set_location (

670: OPEN csr_holiday_calendar_id (p_assignment_id, p_effective_date);
671: FETCH csr_holiday_calendar_id INTO l_holiday_calendar_id;
672: CLOSE csr_holiday_calendar_id;
673: if g_debug then
674: hr_utility.set_location (
675: ' returning '
676: || l_holiday_calendar_id,
677: 20
678: );

Line 679: hr_utility.set_location ( 'Leaving:'

675: ' returning '
676: || l_holiday_calendar_id,
677: 20
678: );
679: hr_utility.set_location ( 'Leaving:'
680: || l_proc, 30);
681: end if;
682: RETURN l_holiday_calendar_id;
683: END holiday_calendar_id;

Line 700: g_debug :=hr_utility.debug_enabled;

696: WHERE hhc.id = p_hol_cal_id;
697:
698: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
699: BEGIN
700: g_debug :=hr_utility.debug_enabled;
701: if g_debug then
702: l_proc := g_package
703: || 'holiday_element_id';
704: hr_utility.set_location ( 'Entering:'

Line 704: hr_utility.set_location ( 'Entering:'

700: g_debug :=hr_utility.debug_enabled;
701: if g_debug then
702: l_proc := g_package
703: || 'holiday_element_id';
704: hr_utility.set_location ( 'Entering:'
705: || l_proc, 10);
706: hr_utility.set_location ( ' p_hol_cal_id IN = '
707: || p_hol_cal_id, 20);
708: end if;

Line 706: hr_utility.set_location ( ' p_hol_cal_id IN = '

702: l_proc := g_package
703: || 'holiday_element_id';
704: hr_utility.set_location ( 'Entering:'
705: || l_proc, 10);
706: hr_utility.set_location ( ' p_hol_cal_id IN = '
707: || p_hol_cal_id, 20);
708: end if;
709: OPEN csr_holiday_element_id (p_hol_cal_id);
710: FETCH csr_holiday_element_id INTO l_holiday_element_id;

Line 713: hr_utility.set_location ( ' returning '

709: OPEN csr_holiday_element_id (p_hol_cal_id);
710: FETCH csr_holiday_element_id INTO l_holiday_element_id;
711: CLOSE csr_holiday_element_id;
712: if g_debug then
713: hr_utility.set_location ( ' returning '
714: || l_holiday_element_id, 30);
715: hr_utility.set_location ( 'Leaving:'
716: || l_proc, 40);
717: end if;

Line 715: hr_utility.set_location ( 'Leaving:'

711: CLOSE csr_holiday_element_id;
712: if g_debug then
713: hr_utility.set_location ( ' returning '
714: || l_holiday_element_id, 30);
715: hr_utility.set_location ( 'Leaving:'
716: || l_proc, 40);
717: end if;
718: RETURN l_holiday_element_id;
719: END holiday_element_id;

Line 744: g_debug :=hr_utility.debug_enabled;

740:
741: l_rec_holiday_today csr_holiday_today%ROWTYPE;
742: l_holiday_today BOOLEAN;
743: BEGIN
744: g_debug :=hr_utility.debug_enabled;
745: if g_debug then
746: l_proc := g_package
747: || 'day_is_holiday';
748: hr_utility.set_location ( 'Entering:'

Line 748: hr_utility.set_location ( 'Entering:'

744: g_debug :=hr_utility.debug_enabled;
745: if g_debug then
746: l_proc := g_package
747: || 'day_is_holiday';
748: hr_utility.set_location ( 'Entering:'
749: || l_proc, 10);
750: end if;
751: OPEN csr_holiday_today (p_hol_cal_id, p_day);
752: FETCH csr_holiday_today INTO l_rec_holiday_today;

Line 757: hr_utility.set_location ( ' '

753:
754: IF csr_holiday_today%FOUND
755: THEN
756: if g_debug then
757: hr_utility.set_location ( ' '
758: || p_day
759: || ' is a holiday', 20);
760: end if;
761: l_holiday_today := TRUE;

Line 768: hr_utility.set_location ( 'Leaving:'

764: END IF;
765:
766: CLOSE csr_holiday_today;
767: if g_debug then
768: hr_utility.set_location ( 'Leaving:'
769: || l_proc, 30);
770: end if;
771: RETURN l_holiday_today;
772: END day_is_holiday;

Line 784: g_debug :=hr_utility.debug_enabled;

780: IS
781: l_proc VARCHAR2 (72) ;
782: l_approved BOOLEAN;
783: BEGIN
784: g_debug :=hr_utility.debug_enabled;
785: if g_debug then
786: l_proc := g_package
787: || 'timecard_approved';
788: hr_utility.set_location ( 'Entering:'

Line 788: hr_utility.set_location ( 'Entering:'

784: g_debug :=hr_utility.debug_enabled;
785: if g_debug then
786: l_proc := g_package
787: || 'timecard_approved';
788: hr_utility.set_location ( 'Entering:'
789: || l_proc, 10);
790: end if;
791: IF (NVL (p_source_flag, 'NOT S') = 'S')
792: THEN

Line 794: hr_utility.set_location ( ' '

790: end if;
791: IF (NVL (p_source_flag, 'NOT S') = 'S')
792: THEN
793: if g_debug then
794: hr_utility.set_location ( ' '
795: || p_tim_id
796: || ' is approved', 20);
797: end if;
798: l_approved := TRUE;

Line 803: hr_utility.set_location ( ' '

799: ELSE
800: IF (p_approver_id IS NOT NULL)
801: THEN
802: if g_debug then
803: hr_utility.set_location ( ' '
804: || p_tim_id
805: || ' is approved', 30);
806: end if;
807: l_approved := TRUE;

Line 814: hr_utility.set_location ( 'Leaving:'

810: END IF;
811: END IF;
812:
813: if g_debug then
814: hr_utility.set_location ( 'Leaving:'
815: || l_proc, 100);
816: end if;
817: RETURN l_approved;
818: END timecard_approved;

Line 834: g_debug :=hr_utility.debug_enabled;

830: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
831: l_charged_hrs NUMBER;
832: l_accrued_hrs NUMBER;
833: BEGIN
834: g_debug :=hr_utility.debug_enabled;
835: if g_debug then
836: l_proc := g_package
837: || 'tcard_approved';
838: hr_utility.set_location ( 'Entering:'

Line 838: hr_utility.set_location ( 'Entering:'

834: g_debug :=hr_utility.debug_enabled;
835: if g_debug then
836: l_proc := g_package
837: || 'tcard_approved';
838: hr_utility.set_location ( 'Entering:'
839: || l_proc, 10);
840: end if;
841: IF NOT (timecard_approved (
842: p_tim_id=> p_tim_id,

Line 886: hr_utility.set_location ( 'Leaving:'

882: g_errtab.DELETE( c_39337_timecard_not_apprved);
883: END IF;
884:
885: if g_debug then
886: hr_utility.set_location ( 'Leaving:'
887: || l_proc, 100);
888: end if;
889: END tcard_approved;
890:

Line 908: g_debug :=hr_utility.debug_enabled;

904: WHERE pbg.business_group_id = p_bg_id;
905:
906: l_legislation_code per_business_groups.legislation_code%TYPE;
907: BEGIN
908: g_debug :=hr_utility.debug_enabled;
909: if g_debug then
910: l_proc := g_package
911: || 'legislation_code';
912: hr_utility.set_location ( 'Entering:'

Line 912: hr_utility.set_location ( 'Entering:'

908: g_debug :=hr_utility.debug_enabled;
909: if g_debug then
910: l_proc := g_package
911: || 'legislation_code';
912: hr_utility.set_location ( 'Entering:'
913: || l_proc, 10);
914: end if;
915: OPEN csr_legislation_code (p_bg_id);
916: FETCH csr_legislation_code INTO l_legislation_code;

Line 919: hr_utility.set_location ( ' returning '

915: OPEN csr_legislation_code (p_bg_id);
916: FETCH csr_legislation_code INTO l_legislation_code;
917: CLOSE csr_legislation_code;
918: if g_debug then
919: hr_utility.set_location ( ' returning '
920: || l_legislation_code, 20);
921: hr_utility.set_location ( 'Leaving:'
922: || l_proc, 30);
923: end if;

Line 921: hr_utility.set_location ( 'Leaving:'

917: CLOSE csr_legislation_code;
918: if g_debug then
919: hr_utility.set_location ( ' returning '
920: || l_legislation_code, 20);
921: hr_utility.set_location ( 'Leaving:'
922: || l_proc, 30);
923: end if;
924: RETURN l_legislation_code;
925: END legislation_code;

Line 949: g_debug :=hr_utility.debug_enabled;

945:
946: l_business_group_id per_assignments_f.business_group_id%TYPE;
947: l_legislation_code per_business_groups.legislation_code%TYPE;
948: BEGIN
949: g_debug :=hr_utility.debug_enabled;
950: if g_debug then
951: l_proc := g_package
952: || 'legislation_code';
953: hr_utility.set_location ( 'Entering:'

Line 953: hr_utility.set_location ( 'Entering:'

949: g_debug :=hr_utility.debug_enabled;
950: if g_debug then
951: l_proc := g_package
952: || 'legislation_code';
953: hr_utility.set_location ( 'Entering:'
954: || l_proc, 10);
955: end if;
956: OPEN csr_business_group (p_asg_id, p_effective_date);
957: FETCH csr_business_group INTO l_business_group_id;

Line 961: hr_utility.set_location ( ' returning '

957: FETCH csr_business_group INTO l_business_group_id;
958: CLOSE csr_business_group;
959: l_legislation_code := legislation_code (p_bg_id => l_business_group_id);
960: if g_debug then
961: hr_utility.set_location ( ' returning '
962: || l_legislation_code, 20);
963: hr_utility.set_location ( 'Leaving:'
964: || l_proc, 30);
965: end if;

Line 963: hr_utility.set_location ( 'Leaving:'

959: l_legislation_code := legislation_code (p_bg_id => l_business_group_id);
960: if g_debug then
961: hr_utility.set_location ( ' returning '
962: || l_legislation_code, 20);
963: hr_utility.set_location ( 'Leaving:'
964: || l_proc, 30);
965: end if;
966: RETURN l_legislation_code;
967: END legislation_code;

Line 1005: g_debug :=hr_utility.debug_enabled;

1001:
1002: l_rec_active_assignment csr_active_assignment%ROWTYPE;
1003: l_active_assignment BOOLEAN;
1004: BEGIN
1005: g_debug :=hr_utility.debug_enabled;
1006: if g_debug then
1007: l_proc := g_package
1008: || 'assignment_is_active';
1009: hr_utility.set_location ( 'Entering:'

Line 1009: hr_utility.set_location ( 'Entering:'

1005: g_debug :=hr_utility.debug_enabled;
1006: if g_debug then
1007: l_proc := g_package
1008: || 'assignment_is_active';
1009: hr_utility.set_location ( 'Entering:'
1010: || l_proc, 10);
1011: end if;
1012: OPEN csr_active_assignment (p_asg_id, p_effective_date);
1013: FETCH csr_active_assignment INTO l_rec_active_assignment;

Line 1018: hr_utility.set_location (

1014:
1015: IF csr_active_assignment%FOUND
1016: THEN
1017: if g_debug then
1018: hr_utility.set_location (
1019: ' assignment '
1020: || p_asg_id
1021: || ' is active on '
1022: || p_effective_date,

Line 1033: hr_utility.set_location ( 'Leaving:'

1029: END IF;
1030:
1031: CLOSE csr_active_assignment;
1032: if g_debug then
1033: hr_utility.set_location ( 'Leaving:'
1034: || l_proc, 30);
1035: end if;
1036: RETURN l_active_assignment;
1037: END assignment_is_active;

Line 1050: g_debug :=hr_utility.debug_enabled;

1046: )
1047: IS
1048: l_proc VARCHAR2 (72) ;
1049: BEGIN
1050: g_debug :=hr_utility.debug_enabled;
1051: if g_debug then
1052: l_proc := g_package
1053: || 'inactive_emp_tcard';
1054: hr_utility.set_location ( 'Entering:'

Line 1054: hr_utility.set_location ( 'Entering:'

1050: g_debug :=hr_utility.debug_enabled;
1051: if g_debug then
1052: l_proc := g_package
1053: || 'inactive_emp_tcard';
1054: hr_utility.set_location ( 'Entering:'
1055: || l_proc, 10);
1056: end if;
1057: IF NOT (assignment_is_active (
1058: p_asg_id=> p_assignment_id,

Line 1102: hr_utility.set_location ( 'Leaving:'

1098: g_errtab.DELETE(c_39317_empl_inactive);
1099: END IF;
1100:
1101: if g_debug then
1102: hr_utility.set_location ( 'Leaving:'
1103: || l_proc, 100);
1104: end if;
1105: END inactive_emp_tcard;
1106:

Line 1128: g_debug :=hr_utility.debug_enabled;

1124: WHERE hhd.holiday_date = p_day
1125: AND hhc.id = p_hol_cal_id
1126: AND hhd.hcl_id = hhc.id;
1127: BEGIN
1128: g_debug :=hr_utility.debug_enabled;
1129: if g_debug then
1130: hr_utility.set_location ( 'Entering:'
1131: || l_proc, 10);
1132: hr_utility.set_location ( ' p_hol_cal_id = '

Line 1130: hr_utility.set_location ( 'Entering:'

1126: AND hhd.hcl_id = hhc.id;
1127: BEGIN
1128: g_debug :=hr_utility.debug_enabled;
1129: if g_debug then
1130: hr_utility.set_location ( 'Entering:'
1131: || l_proc, 10);
1132: hr_utility.set_location ( ' p_hol_cal_id = '
1133: || p_hol_cal_id, 20);
1134: hr_utility.set_location ( ' p_day = '

Line 1132: hr_utility.set_location ( ' p_hol_cal_id = '

1128: g_debug :=hr_utility.debug_enabled;
1129: if g_debug then
1130: hr_utility.set_location ( 'Entering:'
1131: || l_proc, 10);
1132: hr_utility.set_location ( ' p_hol_cal_id = '
1133: || p_hol_cal_id, 20);
1134: hr_utility.set_location ( ' p_day = '
1135: || p_day, 30);
1136: end if;

Line 1134: hr_utility.set_location ( ' p_day = '

1130: hr_utility.set_location ( 'Entering:'
1131: || l_proc, 10);
1132: hr_utility.set_location ( ' p_hol_cal_id = '
1133: || p_hol_cal_id, 20);
1134: hr_utility.set_location ( ' p_day = '
1135: || p_day, 30);
1136: end if;
1137: OPEN csr_holiday_info (p_hol_cal_id, p_day);
1138: FETCH csr_holiday_info INTO p_hol_hours, p_hol_element_type_id;

Line 1141: hr_utility.set_location (

1137: OPEN csr_holiday_info (p_hol_cal_id, p_day);
1138: FETCH csr_holiday_info INTO p_hol_hours, p_hol_element_type_id;
1139: CLOSE csr_holiday_info;
1140: if g_debug then
1141: hr_utility.set_location (
1142: ' Found p_hol_hours = '
1143: || p_hol_hours,
1144: 40
1145: );

Line 1146: hr_utility.set_location (

1142: ' Found p_hol_hours = '
1143: || p_hol_hours,
1144: 40
1145: );
1146: hr_utility.set_location (
1147: ' p_hol_element_type_id = '
1148: || p_hol_element_type_id,
1149: 50
1150: );

Line 1151: hr_utility.set_location ( 'Leaving:'

1147: ' p_hol_element_type_id = '
1148: || p_hol_element_type_id,
1149: 50
1150: );
1151: hr_utility.set_location ( 'Leaving:'
1152: || l_proc, 100);
1153: end if;
1154: END get_holiday_info;
1155:

Line 1166: g_debug :=hr_utility.debug_enabled;

1162: )
1163: IS
1164: l_proc VARCHAR2 (72) ;
1165: BEGIN
1166: g_debug :=hr_utility.debug_enabled;
1167: if g_debug then
1168: l_proc := g_package
1169: || 'get_holiday_info';
1170: hr_utility.set_location ( 'Entering:'

Line 1170: hr_utility.set_location ( 'Entering:'

1166: g_debug :=hr_utility.debug_enabled;
1167: if g_debug then
1168: l_proc := g_package
1169: || 'get_holiday_info';
1170: hr_utility.set_location ( 'Entering:'
1171: || l_proc, 10);
1172: end if;
1173: get_holiday_info (
1174: p_day => p_day,

Line 1183: hr_utility.set_location ( 'Leaving:'

1179: p_hol_hours=> p_hol_hours,
1180: p_hol_element_type_id=> p_hol_element_type_id
1181: );
1182: if g_debug then
1183: hr_utility.set_location ( 'Leaving:'
1184: || l_proc, 20);
1185: end if;
1186: END get_holiday_info;
1187:

Line 1219: g_debug :=hr_utility.debug_enabled;

1215: );
1216:
1217: l_sum_hours NUMBER;
1218: BEGIN
1219: g_debug :=hr_utility.debug_enabled;
1220: if g_debug then
1221: l_proc := g_package
1222: || 'sum_unexploded_hours';
1223: hr_utility.set_location ( 'Entering:'

Line 1223: hr_utility.set_location ( 'Entering:'

1219: g_debug :=hr_utility.debug_enabled;
1220: if g_debug then
1221: l_proc := g_package
1222: || 'sum_unexploded_hours';
1223: hr_utility.set_location ( 'Entering:'
1224: || l_proc, 10);
1225: end if;
1226: OPEN csr_sum_hours (p_tim_id, p_day, p_hours_type);
1227: FETCH csr_sum_hours INTO l_sum_hours;

Line 1230: hr_utility.set_location ( ' returning '

1226: OPEN csr_sum_hours (p_tim_id, p_day, p_hours_type);
1227: FETCH csr_sum_hours INTO l_sum_hours;
1228: CLOSE csr_sum_hours;
1229: if g_debug then
1230: hr_utility.set_location ( ' returning '
1231: || NVL (l_sum_hours, 0), 30);
1232: hr_utility.set_location ( 'Leaving:'
1233: || l_proc, 20);
1234: end if;

Line 1232: hr_utility.set_location ( 'Leaving:'

1228: CLOSE csr_sum_hours;
1229: if g_debug then
1230: hr_utility.set_location ( ' returning '
1231: || NVL (l_sum_hours, 0), 30);
1232: hr_utility.set_location ( 'Leaving:'
1233: || l_proc, 20);
1234: end if;
1235: RETURN NVL (l_sum_hours, 0);
1236: END sum_unexploded_hours;

Line 1252: g_debug :=hr_utility.debug_enabled;

1248: l_proc VARCHAR2 (72) ;
1249: l_hol_hours hxt_holiday_days.hours%TYPE;
1250: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1251: BEGIN
1252: g_debug :=hr_utility.debug_enabled;
1253: if g_debug then
1254: l_proc := g_package
1255: || 'holiday_mismatch';
1256: hr_utility.set_location ( 'Entering:'

Line 1256: hr_utility.set_location ( 'Entering:'

1252: g_debug :=hr_utility.debug_enabled;
1253: if g_debug then
1254: l_proc := g_package
1255: || 'holiday_mismatch';
1256: hr_utility.set_location ( 'Entering:'
1257: || l_proc, 10);
1258: end if;
1259: get_holiday_info (
1260: p_day => p_day,

Line 1315: hr_utility.set_location ( 'Leaving:'

1311: g_errtab.DELETE(c_39334_hrs_chged_ne_cal_hrs);
1312: END IF;
1313:
1314: if g_debug then
1315: hr_utility.set_location ( 'Leaving:'
1316: || l_proc, 100);
1317: end if;
1318: END holiday_mismatch;
1319:

Line 1332: g_debug :=hr_utility.debug_enabled;

1328: )
1329: IS
1330: l_proc VARCHAR2 (72) ;
1331: BEGIN
1332: g_debug :=hr_utility.debug_enabled;
1333: if g_debug then
1334: l_proc := g_package
1335: || 'holiday_valid';
1336: hr_utility.set_location ( 'Entering:'

Line 1336: hr_utility.set_location ( 'Entering:'

1332: g_debug :=hr_utility.debug_enabled;
1333: if g_debug then
1334: l_proc := g_package
1335: || 'holiday_valid';
1336: hr_utility.set_location ( 'Entering:'
1337: || l_proc, 10);
1338: end if;
1339: IF (NVL (p_hours_type, -1) =
1340: holiday_element_id (p_hol_cal_id => p_hol_cal_id)

Line 1386: hr_utility.set_location ( 'Leaving:'

1382: g_errtab.DELETE(c_39333_hol_not_valid_on_cal);
1383: END IF;
1384:
1385: if g_debug then
1386: hr_utility.set_location ( 'Leaving:'
1387: || l_proc, 20);
1388: end if;
1389: END holiday_valid;
1390:

Line 1401: g_debug :=hr_utility.debug_enabled;

1397: IS
1398: l_proc VARCHAR2 (72) ;
1399: l_element_link_id NUMBER;
1400: BEGIN
1401: g_debug :=hr_utility.debug_enabled;
1402: if g_debug then
1403: l_proc := g_package
1404: || 'element_link';
1405: hr_utility.set_location ( 'Entering:'

Line 1405: hr_utility.set_location ( 'Entering:'

1401: g_debug :=hr_utility.debug_enabled;
1402: if g_debug then
1403: l_proc := g_package
1404: || 'element_link';
1405: hr_utility.set_location ( 'Entering:'
1406: || l_proc, 10);
1407: end if;
1408: BEGIN
1409: SELECT el.element_link_id

Line 1464: hr_utility.set_location ( 'Leaving:'

1460: AND alu.effective_end_date)
1461: );
1462:
1463: if g_debug then
1464: hr_utility.set_location ( 'Leaving:'
1465: || l_proc, 20);
1466: end if;
1467: EXCEPTION
1468: WHEN NO_DATA_FOUND

Line 1474: hr_utility.set_location (

1470: l_element_link_id := NULL;
1471: END;
1472:
1473: if g_debug then
1474: hr_utility.set_location (
1475: ' returning l_element_link_id = '
1476: || l_element_link_id,
1477: 20
1478: );

Line 1479: hr_utility.set_location ( 'Leaving:'

1475: ' returning l_element_link_id = '
1476: || l_element_link_id,
1477: 20
1478: );
1479: hr_utility.set_location ( 'Leaving:'
1480: || l_proc, 30);
1481: end if;
1482: RETURN l_element_link_id;
1483: END element_link;

Line 1496: g_debug :=hr_utility.debug_enabled;

1492: l_proc VARCHAR2 (72);
1493: l_element_linked BOOLEAN;
1494: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1495: BEGIN
1496: g_debug :=hr_utility.debug_enabled;
1497: if g_debug then
1498: l_proc := g_package
1499: || 'element_linked';
1500: hr_utility.set_location ( 'Entering:'

Line 1500: hr_utility.set_location ( 'Entering:'

1496: g_debug :=hr_utility.debug_enabled;
1497: if g_debug then
1498: l_proc := g_package
1499: || 'element_linked';
1500: hr_utility.set_location ( 'Entering:'
1501: || l_proc, 10);
1502: end if;
1503: l_element_link_id :=
1504: element_link (

Line 1513: hr_utility.set_location (

1509:
1510: IF (l_element_link_id IS NOT NULL)
1511: THEN
1512: if g_debug then
1513: hr_utility.set_location (
1514: ' '
1515: || p_element_type_id
1516: || ' is a valid element for asg '
1517: || p_assignment_id

Line 1529: hr_utility.set_location ( 'Leaving:'

1525: l_element_linked := FALSE;
1526: END IF;
1527:
1528: if g_debug then
1529: hr_utility.set_location ( 'Leaving:'
1530: || l_proc, 30);
1531: end if;
1532: RETURN l_element_linked;
1533: END element_linked;

Line 1561: g_debug :=hr_utility.debug_enabled;

1557: IS
1558: l_proc VARCHAR2 (72) ;
1559: l_valid_for_summing BOOLEAN;
1560: BEGIN
1561: g_debug :=hr_utility.debug_enabled;
1562: if g_debug then
1563: l_proc := g_package
1564: || 'valid_for_summing';
1565: hr_utility.set_location ( 'Entering:'

Line 1565: hr_utility.set_location ( 'Entering:'

1561: g_debug :=hr_utility.debug_enabled;
1562: if g_debug then
1563: l_proc := g_package
1564: || 'valid_for_summing';
1565: hr_utility.set_location ( 'Entering:'
1566: || l_proc, 10);
1567: end if;
1568: IF ( (element_linked (
1569: p_element_type_id=> p_element_id,

Line 1589: hr_utility.set_location (

1585: )
1586: )
1587: THEN
1588: if g_debug then
1589: hr_utility.set_location (
1590: ' element '
1591: || p_element_id
1592: || ' is valid for summing',
1593: 20

Line 1602: hr_utility.set_location ( 'Leaving:'

1598: l_valid_for_summing := FALSE;
1599: END IF;
1600:
1601: if g_debug then
1602: hr_utility.set_location ( 'Leaving:'
1603: || l_proc, 30);
1604: end if;
1605: RETURN l_valid_for_summing;
1606: END valid_for_summing;

Line 1637: g_debug :=hr_utility.debug_enabled;

1633: haeif.earning_category;
1634:
1635: l_summed_hours NUMBER := 0;
1636: BEGIN
1637: g_debug :=hr_utility.debug_enabled;
1638: if g_debug then
1639: l_proc := g_package
1640: || 'sum_valid_det_hours';
1641: hr_utility.set_location ( 'Entering:'

Line 1641: hr_utility.set_location ( 'Entering:'

1637: g_debug :=hr_utility.debug_enabled;
1638: if g_debug then
1639: l_proc := g_package
1640: || 'sum_valid_det_hours';
1641: hr_utility.set_location ( 'Entering:'
1642: || l_proc, 10);
1643: end if;
1644: FOR rec_det_hours IN csr_det_hours (p_tim_id, p_day)
1645: LOOP

Line 1663: hr_utility.set_location (

1659: + rec_det_hours.hours;
1660: END IF;
1661: END LOOP;
1662: if g_debug then
1663: hr_utility.set_location (
1664: ' returning l_summed_hours = '
1665: || l_summed_hours,
1666: 20
1667: );

Line 1668: hr_utility.set_location ( 'Leaving:'

1664: ' returning l_summed_hours = '
1665: || l_summed_hours,
1666: 20
1667: );
1668: hr_utility.set_location ( 'Leaving:'
1669: || l_proc, 30);
1670: end if;
1671: RETURN NVL (l_summed_hours, 0);
1672: END sum_valid_det_hours;

Line 1688: g_debug :=hr_utility.debug_enabled;

1684: l_proc VARCHAR2 (72) ;
1685: l_hol_hours hxt_holiday_days.hours%TYPE;
1686: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1687: BEGIN
1688: g_debug :=hr_utility.debug_enabled;
1689: if g_debug then
1690: l_proc := g_package
1691: || 'day_over_24';
1692: hr_utility.set_location ( 'Entering:'

Line 1692: hr_utility.set_location ( 'Entering:'

1688: g_debug :=hr_utility.debug_enabled;
1689: if g_debug then
1690: l_proc := g_package
1691: || 'day_over_24';
1692: hr_utility.set_location ( 'Entering:'
1693: || l_proc, 10);
1694: end if;
1695: IF (sum_valid_det_hours (
1696: p_tim_id=> p_tim_id,

Line 1739: hr_utility.set_location ( 'Leaving:'

1735: g_errtab.DELETE(c_39315_max_hrs_exceeded);
1736: END IF;
1737:
1738: if g_debug then
1739: hr_utility.set_location ( 'Leaving:'
1740: || l_proc, 100);
1741: end if;
1742: END day_over_24;
1743:

Line 1756: g_debug :=hr_utility.debug_enabled;

1752: )
1753: IS
1754: l_proc VARCHAR2 (72) ;
1755: BEGIN
1756: g_debug :=hr_utility.debug_enabled;
1757: if g_debug then
1758: l_proc := g_package
1759: || 'holiday_as_reg';
1760: hr_utility.set_location ( 'Entering:'

Line 1760: hr_utility.set_location ( 'Entering:'

1756: g_debug :=hr_utility.debug_enabled;
1757: if g_debug then
1758: l_proc := g_package
1759: || 'holiday_as_reg';
1760: hr_utility.set_location ( 'Entering:'
1761: || l_proc, 10);
1762: hr_utility.set_location ( ' p_hours_type = '
1763: || p_hours_type, 20);
1764: end if;

Line 1762: hr_utility.set_location ( ' p_hours_type = '

1758: l_proc := g_package
1759: || 'holiday_as_reg';
1760: hr_utility.set_location ( 'Entering:'
1761: || l_proc, 10);
1762: hr_utility.set_location ( ' p_hours_type = '
1763: || p_hours_type, 20);
1764: end if;
1765: IF ( (day_is_holiday (p_day => p_day, p_hol_cal_id => p_hol_cal_id))
1766: AND (NVL (p_hours_type, -1) <>

Line 1808: hr_utility.set_location ( 'Leaving:'

1804: g_errtab.DELETE(c_39332_day_on_hol_cal);
1805: END IF;
1806:
1807: if g_debug then
1808: hr_utility.set_location ( 'Leaving:'
1809: || l_proc, 100);
1810: end if;
1811: END holiday_as_reg;
1812:

Line 1831: hr_utility.set_location ( 'Entering:'

1827:
1828: if g_debug then
1829: l_proc := g_package
1830: || 'perform_holiday_validations';
1831: hr_utility.set_location ( 'Entering:'
1832: || l_proc, 10);
1833: end if;
1834: l_hol_cal_id := holiday_calendar_id (
1835: p_person_id=> p_person_id,

Line 1867: hr_utility.set_location ( 'Leaving:'

1863: p_hol_cal_id=> l_hol_cal_id
1864: );
1865: p_hol_cal_id := l_hol_cal_id;
1866: if g_debug then
1867: hr_utility.set_location ( 'Leaving:'
1868: || l_proc, 100);
1869: end if;
1870: END perform_holiday_validations;
1871:

Line 1909: hr_utility.set_location ( 'Entering:'

1905:
1906: if g_debug then
1907: l_proc := g_package
1908: || 'perform_day_validations';
1909: hr_utility.set_location ( 'Entering:'
1910: || l_proc, 10);
1911: end if;
1912:
1913: open c_no_mid_period_change(p_person_id );

Line 1923: hr_utility.trace ('l_no_mid_period_change - '||l_no_mid_period_change);

1919:
1920: close c_no_mid_period_change;
1921:
1922: if g_debug then
1923: hr_utility.trace ('l_no_mid_period_change - '||l_no_mid_period_change);
1924: end if;
1925:
1926: FOR rec_days IN csr_days (p_tim_id)
1927: LOOP

Line 1977: hr_utility.set_location ( 'Leaving:'

1973: );
1974: end if;
1975:
1976: if g_debug then
1977: hr_utility.set_location ( 'Leaving:'
1978: || l_proc, 100);
1979: end if;
1980: END perform_day_validations;
1981:

Line 1994: g_debug :=hr_utility.debug_enabled;

1990: )
1991: AS
1992: l_proc VARCHAR2 (72) ;
1993: BEGIN
1994: g_debug :=hr_utility.debug_enabled;
1995: if g_debug then
1996: l_proc := g_package
1997: || 'validate_tc';
1998: hr_utility.set_location ( 'Entering:'

Line 1998: hr_utility.set_location ( 'Entering:'

1994: g_debug :=hr_utility.debug_enabled;
1995: if g_debug then
1996: l_proc := g_package
1997: || 'validate_tc';
1998: hr_utility.set_location ( 'Entering:'
1999: || l_proc, 10);
2000: end if;
2001:
2002:

Line 2050: hr_utility.set_location ( 'Leaving:'

2046: p_tim_id=> p_tim_id
2047: );
2048: p_error_level := error_level;
2049: if g_debug then
2050: hr_utility.set_location ( 'Leaving:'
2051: || l_proc, 100);
2052: end if;
2053: END validate_tc;
2054:

Line 2086: g_debug :=hr_utility.debug_enabled;

2082: tim.object_version_number, tim.rowid
2083: FROM hxt_timecards_x tim
2084: WHERE tim.batch_id = p_batch_id;
2085: BEGIN
2086: g_debug :=hr_utility.debug_enabled;
2087: if g_debug then
2088: l_proc := g_package
2089: || 'val_batch';
2090: hr_utility.set_location ( 'Entering:'

Line 2090: hr_utility.set_location ( 'Entering:'

2086: g_debug :=hr_utility.debug_enabled;
2087: if g_debug then
2088: l_proc := g_package
2089: || 'val_batch';
2090: hr_utility.set_location ( 'Entering:'
2091: || l_proc, 10);
2092: end if;
2093: reset_error_level;
2094: delete_prev_val_errors (p_batch_id => p_batch_id);

Line 2114: hr_utility.set_location (

2110:
2111: /********Bug: 5037996 **********/
2112:
2113: if g_debug then
2114: hr_utility.set_location (
2115: ' process timecard '
2116: || rec_tcs_in_batch.tim_id,
2117: 20
2118: );

Line 2119: hr_utility.set_location (

2115: ' process timecard '
2116: || rec_tcs_in_batch.tim_id,
2117: 20
2118: );
2119: hr_utility.set_location (
2120: ' Error Level at start = '
2121: || error_level,
2122: 30
2123: );

Line 2150: hr_utility.trace('Populating merge_batches record'||

2146:
2147: IF p_merge_flag = '1' THEN
2148:
2149: if g_debug then
2150: hr_utility.trace('Populating merge_batches record'||
2151: ' batch_id: '||p_batch_id||' tc_id '||rec_tcs_in_batch.tim_id);
2152: end if;
2153:
2154: l_cnt := NVL(p_merge_batches.LAST,0) +1;

Line 2187: hr_utility.set_location ( 'Leaving:'

2183:
2184: hr_session_utilities.remove_session_row;
2185:
2186: if g_debug then
2187: hr_utility.set_location ( 'Leaving:'
2188: || l_proc, 100);
2189: end if;
2190: END val_batch;
2191: