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 23: g_debug :=hr_utility.debug_enabled;

19: RETURN NUMBER
20: IS
21: l_proc VARCHAR2 (72) ;
22: BEGIN
23: g_debug :=hr_utility.debug_enabled;
24: if g_debug then
25: l_proc := g_package
26: || 'error_level';
27: hr_utility.set_location ( 'Entering:'

Line 27: hr_utility.set_location ( 'Entering:'

23: g_debug :=hr_utility.debug_enabled;
24: if g_debug then
25: l_proc := g_package
26: || 'error_level';
27: hr_utility.set_location ( 'Entering:'
28: || l_proc, 10);
29: hr_utility.set_location (
30: ' returning error level '
31: || g_error_level,

Line 29: hr_utility.set_location (

25: l_proc := g_package
26: || 'error_level';
27: hr_utility.set_location ( 'Entering:'
28: || l_proc, 10);
29: hr_utility.set_location (
30: ' returning error level '
31: || g_error_level,
32: 20
33: );

Line 34: hr_utility.set_location ( 'Leaving:'

30: ' returning error level '
31: || g_error_level,
32: 20
33: );
34: hr_utility.set_location ( 'Leaving:'
35: || l_proc, 30);
36: end if;
37: RETURN g_error_level;
38: END error_level;

Line 45: g_debug :=hr_utility.debug_enabled;

41: RETURN NUMBER
42: IS
43: l_proc VARCHAR2 (72) ;
44: BEGIN
45: g_debug :=hr_utility.debug_enabled;
46: if g_debug then
47: l_proc := g_package
48: || 'tc_error_level';
49: hr_utility.set_location ( 'Entering:'

Line 49: hr_utility.set_location ( 'Entering:'

45: g_debug :=hr_utility.debug_enabled;
46: if g_debug then
47: l_proc := g_package
48: || 'tc_error_level';
49: hr_utility.set_location ( 'Entering:'
50: || l_proc, 10);
51: hr_utility.set_location (
52: ' returning timecard error level '
53: || g_tc_error_level,

Line 51: hr_utility.set_location (

47: l_proc := g_package
48: || 'tc_error_level';
49: hr_utility.set_location ( 'Entering:'
50: || l_proc, 10);
51: hr_utility.set_location (
52: ' returning timecard error level '
53: || g_tc_error_level,
54: 20
55: );

Line 56: hr_utility.set_location ( 'Leaving:'

52: ' returning timecard error level '
53: || g_tc_error_level,
54: 20
55: );
56: hr_utility.set_location ( 'Leaving:'
57: || l_proc, 30);
58: end if;
59: RETURN g_tc_error_level;
60: END tc_error_level;

Line 66: g_debug :=hr_utility.debug_enabled;

62: PROCEDURE set_tc_error_level (p_tc_error_level IN NUMBER)
63: IS
64: l_proc VARCHAR2 (72) ;
65: BEGIN
66: g_debug :=hr_utility.debug_enabled;
67: if g_debug then
68: l_proc := g_package
69: || 'set_tc_error_level';
70: hr_utility.set_location ( 'Entering:'

Line 70: hr_utility.set_location ( 'Entering:'

66: g_debug :=hr_utility.debug_enabled;
67: if g_debug then
68: l_proc := g_package
69: || 'set_tc_error_level';
70: hr_utility.set_location ( 'Entering:'
71: || l_proc, 10);
72: end if;
73: g_tc_error_level := p_tc_error_level;
74: if g_debug then

Line 75: hr_utility.set_location ( 'Leaving:'

71: || l_proc, 10);
72: end if;
73: g_tc_error_level := p_tc_error_level;
74: if g_debug then
75: hr_utility.set_location ( 'Leaving:'
76: || l_proc, 30);
77: end if;
78: END set_tc_error_level;
79:

Line 84: g_debug :=hr_utility.debug_enabled;

80: PROCEDURE set_tc_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2)
81: IS
82: l_proc VARCHAR2 (72) ;
83: BEGIN
84: g_debug :=hr_utility.debug_enabled;
85: if g_debug then
86: l_proc := g_package
87: || 'set_tc_error_level';
88: hr_utility.set_location ( 'Entering:'

Line 88: hr_utility.set_location ( 'Entering:'

84: g_debug :=hr_utility.debug_enabled;
85: if g_debug then
86: l_proc := g_package
87: || 'set_tc_error_level';
88: hr_utility.set_location ( 'Entering:'
89: || l_proc, 10);
90: end if;
91: IF p_valid = 'N' THEN
92: IF (p_msg_level = 'S') THEN

Line 102: hr_utility.set_location ( 'Leaving:'

98: END IF;
99: END IF;
100:
101: if g_debug then
102: hr_utility.set_location ( 'Leaving:'
103: || l_proc, 30);
104: end if;
105: END set_tc_error_level;
106:

Line 111: g_debug :=hr_utility.debug_enabled;

107: PROCEDURE set_error_level (p_error_level IN NUMBER)
108: IS
109: l_proc VARCHAR2 (72) ;
110: BEGIN
111: g_debug :=hr_utility.debug_enabled;
112: if g_debug then
113: l_proc := g_package
114: || 'set_error_level';
115: hr_utility.set_location ( 'Entering:'

Line 115: hr_utility.set_location ( 'Entering:'

111: g_debug :=hr_utility.debug_enabled;
112: if g_debug then
113: l_proc := g_package
114: || 'set_error_level';
115: hr_utility.set_location ( 'Entering:'
116: || l_proc, 10);
117: end if;
118: g_error_level := p_error_level;
119: if g_debug then

Line 120: hr_utility.set_location ( 'Leaving:'

116: || l_proc, 10);
117: end if;
118: g_error_level := p_error_level;
119: if g_debug then
120: hr_utility.set_location ( 'Leaving:'
121: || l_proc, 30);
122: end if;
123: END set_error_level;
124:

Line 129: g_debug :=hr_utility.debug_enabled;

125: PROCEDURE reset_error_level
126: IS
127: l_proc VARCHAR2 (72) ;
128: BEGIN
129: g_debug :=hr_utility.debug_enabled;
130: if g_debug then
131: l_proc := g_package
132: || 'reset_error_level';
133: hr_utility.set_location ( 'Entering:'

Line 133: hr_utility.set_location ( 'Entering:'

129: g_debug :=hr_utility.debug_enabled;
130: if g_debug then
131: l_proc := g_package
132: || 'reset_error_level';
133: hr_utility.set_location ( 'Entering:'
134: || l_proc, 10);
135: end if;
136: g_error_level := 0;
137: if g_debug then

Line 138: hr_utility.set_location ( 'Leaving:'

134: || l_proc, 10);
135: end if;
136: g_error_level := 0;
137: if g_debug then
138: hr_utility.set_location ( 'Leaving:'
139: || l_proc, 30);
140: end if;
141: END reset_error_level;
142:

Line 147: g_debug :=hr_utility.debug_enabled;

143: PROCEDURE set_error_level (p_valid IN VARCHAR, p_msg_level IN VARCHAR2)
144: IS
145: l_proc VARCHAR2 (72) ;
146: BEGIN
147: g_debug :=hr_utility.debug_enabled;
148: if g_debug then
149: l_proc := g_package
150: || 'set_error_level';
151: hr_utility.set_location ( 'Entering:'

Line 151: hr_utility.set_location ( 'Entering:'

147: g_debug :=hr_utility.debug_enabled;
148: if g_debug then
149: l_proc := g_package
150: || 'set_error_level';
151: hr_utility.set_location ( 'Entering:'
152: || l_proc, 10);
153: end if;
154: IF p_valid = 'N'
155: THEN

Line 169: hr_utility.set_location ( 'Leaving:'

165: END IF;
166: END IF;
167:
168: if g_debug then
169: hr_utility.set_location ( 'Leaving:'
170: || l_proc, 30);
171: end if;
172: END set_error_level;
173:

Line 180: g_debug :=hr_utility.debug_enabled;

176: )
177: AS
178: l_proc VARCHAR2 (72) ;
179: BEGIN
180: g_debug :=hr_utility.debug_enabled;
181: if g_debug then
182: l_proc := g_package
183: || 'delete_prev_val_errors';
184: hr_utility.set_location ( 'Entering:'

Line 184: hr_utility.set_location ( 'Entering:'

180: g_debug :=hr_utility.debug_enabled;
181: if g_debug then
182: l_proc := g_package
183: || 'delete_prev_val_errors';
184: hr_utility.set_location ( 'Entering:'
185: || l_proc, 10);
186: end if;
187: DELETE FROM hxt_errors_x
188: WHERE ppb_id = p_batch_id AND location LIKE 'Validate%';

Line 191: hr_utility.set_location ( 'Leaving:'

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

Line 200: g_debug :=hr_utility.debug_enabled;

196: PROCEDURE delete_prev_val_errors (p_tim_id IN hxt_timecards_f.id%TYPE)
197: AS
198: l_proc VARCHAR2 (72) ;
199: BEGIN
200: g_debug :=hr_utility.debug_enabled;
201: if g_debug then
202: l_proc := g_package
203: || 'delete_prev_val_errors';
204: hr_utility.set_location ( 'Entering:'

Line 204: hr_utility.set_location ( 'Entering:'

200: g_debug :=hr_utility.debug_enabled;
201: if g_debug then
202: l_proc := g_package
203: || 'delete_prev_val_errors';
204: hr_utility.set_location ( 'Entering:'
205: || l_proc, 10);
206: end if;
207: DELETE FROM hxt_errors_x
208: WHERE tim_id = p_tim_id AND location LIKE 'Validate%';

Line 211: hr_utility.set_location ( 'Leaving:'

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

Line 230: g_debug :=hr_utility.debug_enabled;

226:
227: l_find_error NUMBER;
228: l_error_exist BOOLEAN;
229: BEGIN
230: g_debug :=hr_utility.debug_enabled;
231: if g_debug then
232: l_proc := g_package
233: || 'errors_exist';
234: hr_utility.set_location ( 'Entering:'

Line 234: hr_utility.set_location ( 'Entering:'

230: g_debug :=hr_utility.debug_enabled;
231: if g_debug then
232: l_proc := g_package
233: || 'errors_exist';
234: hr_utility.set_location ( 'Entering:'
235: || l_proc, 10);
236: end if;
237: OPEN find_errors (p_tim_id);
238: FETCH find_errors INTO l_find_error;

Line 243: hr_utility.set_location (

239:
240: IF find_errors%FOUND
241: THEN
242: if g_debug then
243: hr_utility.set_location (
244: ' Errors exist for TC '
245: || p_tim_id,
246: 20
247: );

Line 256: hr_utility.set_location ( 'Leaving:'

252: END IF;
253:
254: CLOSE find_errors;
255: if g_debug then
256: hr_utility.set_location ( 'Leaving:'
257: || l_proc, 100);
258: end if;
259: RETURN l_error_exist;
260: END errors_exist;

Line 275: g_debug :=hr_utility.debug_enabled;

271: WHERE ptp.time_period_id = htx.time_period_id AND htx.id = p_tim_id;
272:
273: l_tc_end_dt per_time_periods.end_date%TYPE;
274: BEGIN
275: g_debug :=hr_utility.debug_enabled;
276: if g_debug then
277: l_proc := g_package
278: || 'timecard_end_date';
279: hr_utility.set_location ( 'Entering:'

Line 279: hr_utility.set_location ( 'Entering:'

275: g_debug :=hr_utility.debug_enabled;
276: if g_debug then
277: l_proc := g_package
278: || 'timecard_end_date';
279: hr_utility.set_location ( 'Entering:'
280: || l_proc, 10);
281: end if;
282: OPEN csr_timecard_end_date (p_tim_id);
283: FETCH csr_timecard_end_date INTO l_tc_end_dt;

Line 286: hr_utility.set_location ( ' returning '

282: OPEN csr_timecard_end_date (p_tim_id);
283: FETCH csr_timecard_end_date INTO l_tc_end_dt;
284: CLOSE csr_timecard_end_date;
285: if g_debug then
286: hr_utility.set_location ( ' returning '
287: || l_tc_end_dt, 30);
288: hr_utility.set_location ( 'Leaving:'
289: || l_proc, 20);
290: end if;

Line 288: hr_utility.set_location ( 'Leaving:'

284: CLOSE csr_timecard_end_date;
285: if g_debug then
286: hr_utility.set_location ( ' returning '
287: || l_tc_end_dt, 30);
288: hr_utility.set_location ( 'Leaving:'
289: || l_proc, 20);
290: end if;
291: RETURN l_tc_end_dt;
292: END timecard_end_date;

Line 318: g_debug :=hr_utility.debug_enabled;

314: l_person_effective BOOLEAN;
315: l_found_person NUMBER;
316: l_eff_dt per_people_f.effective_end_date%TYPE;
317: BEGIN
318: g_debug :=hr_utility.debug_enabled;
319: if g_debug then
320: l_proc := g_package
321: || 'person_effective_at_tc_end';
322: hr_utility.set_location ( 'Entering:'

Line 322: hr_utility.set_location ( 'Entering:'

318: g_debug :=hr_utility.debug_enabled;
319: if g_debug then
320: l_proc := g_package
321: || 'person_effective_at_tc_end';
322: hr_utility.set_location ( 'Entering:'
323: || l_proc, 10);
324: end if;
325: l_eff_dt := timecard_end_date (p_tim_id => p_tim_id);
326: OPEN csr_person_effective (l_eff_dt, p_person_id);

Line 332: hr_utility.set_location (

328:
329: IF (csr_person_effective%FOUND)
330: THEN
331: if g_debug then
332: hr_utility.set_location (
333: ' Person '
334: || p_person_id
335: || ' is effective on '
336: || l_eff_dt

Line 348: hr_utility.set_location ( 'Leaving:'

344: END IF;
345:
346: CLOSE csr_person_effective;
347: if g_debug then
348: hr_utility.set_location ( 'Leaving:'
349: || l_proc, 20);
350: end if;
351: RETURN l_person_effective;
352: END person_effective_at_tc_end;

Line 367: g_debug :=hr_utility.debug_enabled;

363: l_error_msg VARCHAR2 (255);
364: l_valid VARCHAR2 (1);
365: l_msg_level VARCHAR2 (1);
366: BEGIN
367: g_debug :=hr_utility.debug_enabled;
368: if g_debug then
369: l_proc := g_package
370: || 'record_error';
371: hr_utility.set_location ( 'Entering:'

Line 371: hr_utility.set_location ( 'Entering:'

367: g_debug :=hr_utility.debug_enabled;
368: if g_debug then
369: l_proc := g_package
370: || 'record_error';
371: hr_utility.set_location ( 'Entering:'
372: || l_proc, 10);
373: end if;
374: hxt_util.set_timecard_error (
375: p_batch_id,

Line 389: hr_utility.set_location ( 'Leaving:'

385: );
386: set_error_level (p_valid => l_valid, p_msg_level => l_msg_level);
387: set_tc_error_level (p_valid => l_valid, p_msg_level => l_msg_level);
388: if g_debug then
389: hr_utility.set_location ( 'Leaving:'
390: || l_proc, 100);
391: end if;
392: END record_error;
393:

Line 406: g_debug :=hr_utility.debug_enabled;

402: l_error_msg VARCHAR2 (255);
403: l_valid VARCHAR2 (1);
404: l_msg_level VARCHAR2 (1);
405: BEGIN
406: g_debug :=hr_utility.debug_enabled;
407: if g_debug then
408: l_proc := g_package
409: || 'person_validation';
410: hr_utility.set_location ( 'Entering:'

Line 410: hr_utility.set_location ( 'Entering:'

406: g_debug :=hr_utility.debug_enabled;
407: if g_debug then
408: l_proc := g_package
409: || 'person_validation';
410: hr_utility.set_location ( 'Entering:'
411: || l_proc, 10);
412: end if;
413: IF NOT (person_effective_at_tc_end (
414: p_person_id=> p_person_id,

Line 428: hr_utility.set_location ( 'Leaving:'

424: );
425: END IF;
426:
427: if g_debug then
428: hr_utility.set_location ( 'Leaving:'
429: || l_proc, 100);
430: end if;
431: END person_validation;
432:

Line 446: g_debug :=hr_utility.debug_enabled;

442: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
443: l_charged_hrs NUMBER;
444: l_accrued_hrs NUMBER;
445: BEGIN
446: g_debug :=hr_utility.debug_enabled;
447: if g_debug then
448: l_proc := g_package
449: || 'excess_pto';
450: hr_utility.set_location ( 'Entering:'

Line 450: hr_utility.set_location ( 'Entering:'

446: g_debug :=hr_utility.debug_enabled;
447: if g_debug then
448: l_proc := g_package
449: || 'excess_pto';
450: hr_utility.set_location ( 'Entering:'
451: || l_proc, 10);
452: end if;
453:
454: -- M.Bhammar - Bug:5107665

Line 479: hr_utility.set_location ( 'Leaving:'

475: END IF;
476:
477: -- hr_session_utilities.remove_session_row; /* Bug 6024976 */
478: if g_debug then
479: hr_utility.set_location ( 'Leaving:'
480: || l_proc, 100);
481: end if;
482: END excess_pto;
483:

Line 517: g_debug :=hr_utility.debug_enabled;

513: past.per_system_status = 'ACTIVE_ASSIGN';
514:
515: l_prim_asg_id per_all_assignments_f.assignment_id%TYPE;
516: BEGIN
517: g_debug :=hr_utility.debug_enabled;
518: if g_debug then
519: l_proc := g_package
520: || 'primary_assignment_id';
521: hr_utility.set_location ( 'Entering:'

Line 521: hr_utility.set_location ( 'Entering:'

517: g_debug :=hr_utility.debug_enabled;
518: if g_debug then
519: l_proc := g_package
520: || 'primary_assignment_id';
521: hr_utility.set_location ( 'Entering:'
522: || l_proc, 10);
523: end if;
524: OPEN csr_prim_asg_id (p_person_id, p_effective_date);
525: FETCH csr_prim_asg_id INTO l_prim_asg_id;

Line 528: hr_utility.set_location ( ' returning '

524: OPEN csr_prim_asg_id (p_person_id, p_effective_date);
525: FETCH csr_prim_asg_id INTO l_prim_asg_id;
526: CLOSE csr_prim_asg_id;
527: if g_debug then
528: hr_utility.set_location ( ' returning '
529: || l_prim_asg_id, 20);
530: hr_utility.set_location ( 'Leaving:'
531: || l_proc, 30);
532: end if;

Line 530: hr_utility.set_location ( 'Leaving:'

526: CLOSE csr_prim_asg_id;
527: if g_debug then
528: hr_utility.set_location ( ' returning '
529: || l_prim_asg_id, 20);
530: hr_utility.set_location ( 'Leaving:'
531: || l_proc, 30);
532: end if;
533: RETURN l_prim_asg_id;
534: END primary_assignment_id;

Line 545: g_debug :=hr_utility.debug_enabled;

541: IS
542: l_proc VARCHAR2 (72) ;
543: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
544: BEGIN
545: g_debug :=hr_utility.debug_enabled;
546: if g_debug then
547: l_proc := g_package
548: || 'holiday_calendar_id';
549: hr_utility.set_location ( 'Entering:'

Line 549: hr_utility.set_location ( 'Entering:'

545: g_debug :=hr_utility.debug_enabled;
546: if g_debug then
547: l_proc := g_package
548: || 'holiday_calendar_id';
549: hr_utility.set_location ( 'Entering:'
550: || l_proc, 10);
551: end if;
552: l_holiday_calendar_id :=
553: holiday_calendar_id (

Line 561: hr_utility.set_location (

557: ),
558: p_effective_date=> p_effective_date
559: );
560: if g_debug then
561: hr_utility.set_location (
562: ' returning '
563: || l_holiday_calendar_id,
564: 20
565: );

Line 566: hr_utility.set_location ( 'Leaving:'

562: ' returning '
563: || l_holiday_calendar_id,
564: 20
565: );
566: hr_utility.set_location ( 'Leaving:'
567: || l_proc, 30);
568: end if;
569: RETURN l_holiday_calendar_id;
570: END holiday_calendar_id;

Line 601: g_debug :=hr_utility.debug_enabled;

597: AND haaif.assignment_id = p_assignment_id;
598:
599: l_holiday_calendar_id hxt_holiday_calendars.id%TYPE;
600: BEGIN
601: g_debug :=hr_utility.debug_enabled;
602: if g_debug then
603: l_proc := g_package
604: || 'holiday_calendar_id';
605: hr_utility.set_location ( 'Entering:'

Line 605: hr_utility.set_location ( 'Entering:'

601: g_debug :=hr_utility.debug_enabled;
602: if g_debug then
603: l_proc := g_package
604: || 'holiday_calendar_id';
605: hr_utility.set_location ( 'Entering:'
606: || l_proc, 10);
607: end if;
608: OPEN csr_holiday_calendar_id (p_assignment_id, p_effective_date);
609: FETCH csr_holiday_calendar_id INTO l_holiday_calendar_id;

Line 612: hr_utility.set_location (

608: OPEN csr_holiday_calendar_id (p_assignment_id, p_effective_date);
609: FETCH csr_holiday_calendar_id INTO l_holiday_calendar_id;
610: CLOSE csr_holiday_calendar_id;
611: if g_debug then
612: hr_utility.set_location (
613: ' returning '
614: || l_holiday_calendar_id,
615: 20
616: );

Line 617: hr_utility.set_location ( 'Leaving:'

613: ' returning '
614: || l_holiday_calendar_id,
615: 20
616: );
617: hr_utility.set_location ( 'Leaving:'
618: || l_proc, 30);
619: end if;
620: RETURN l_holiday_calendar_id;
621: END holiday_calendar_id;

Line 638: g_debug :=hr_utility.debug_enabled;

634: WHERE hhc.id = p_hol_cal_id;
635:
636: l_holiday_element_id hxt_holiday_calendars.element_type_id%TYPE;
637: BEGIN
638: g_debug :=hr_utility.debug_enabled;
639: if g_debug then
640: l_proc := g_package
641: || 'holiday_element_id';
642: hr_utility.set_location ( 'Entering:'

Line 642: hr_utility.set_location ( 'Entering:'

638: g_debug :=hr_utility.debug_enabled;
639: if g_debug then
640: l_proc := g_package
641: || 'holiday_element_id';
642: hr_utility.set_location ( 'Entering:'
643: || l_proc, 10);
644: hr_utility.set_location ( ' p_hol_cal_id IN = '
645: || p_hol_cal_id, 20);
646: end if;

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

640: l_proc := g_package
641: || 'holiday_element_id';
642: hr_utility.set_location ( 'Entering:'
643: || l_proc, 10);
644: hr_utility.set_location ( ' p_hol_cal_id IN = '
645: || p_hol_cal_id, 20);
646: end if;
647: OPEN csr_holiday_element_id (p_hol_cal_id);
648: FETCH csr_holiday_element_id INTO l_holiday_element_id;

Line 651: hr_utility.set_location ( ' returning '

647: OPEN csr_holiday_element_id (p_hol_cal_id);
648: FETCH csr_holiday_element_id INTO l_holiday_element_id;
649: CLOSE csr_holiday_element_id;
650: if g_debug then
651: hr_utility.set_location ( ' returning '
652: || l_holiday_element_id, 30);
653: hr_utility.set_location ( 'Leaving:'
654: || l_proc, 40);
655: end if;

Line 653: hr_utility.set_location ( 'Leaving:'

649: CLOSE csr_holiday_element_id;
650: if g_debug then
651: hr_utility.set_location ( ' returning '
652: || l_holiday_element_id, 30);
653: hr_utility.set_location ( 'Leaving:'
654: || l_proc, 40);
655: end if;
656: RETURN l_holiday_element_id;
657: END holiday_element_id;

Line 682: g_debug :=hr_utility.debug_enabled;

678:
679: l_rec_holiday_today csr_holiday_today%ROWTYPE;
680: l_holiday_today BOOLEAN;
681: BEGIN
682: g_debug :=hr_utility.debug_enabled;
683: if g_debug then
684: l_proc := g_package
685: || 'day_is_holiday';
686: hr_utility.set_location ( 'Entering:'

Line 686: hr_utility.set_location ( 'Entering:'

682: g_debug :=hr_utility.debug_enabled;
683: if g_debug then
684: l_proc := g_package
685: || 'day_is_holiday';
686: hr_utility.set_location ( 'Entering:'
687: || l_proc, 10);
688: end if;
689: OPEN csr_holiday_today (p_hol_cal_id, p_day);
690: FETCH csr_holiday_today INTO l_rec_holiday_today;

Line 695: hr_utility.set_location ( ' '

691:
692: IF csr_holiday_today%FOUND
693: THEN
694: if g_debug then
695: hr_utility.set_location ( ' '
696: || p_day
697: || ' is a holiday', 20);
698: end if;
699: l_holiday_today := TRUE;

Line 706: hr_utility.set_location ( 'Leaving:'

702: END IF;
703:
704: CLOSE csr_holiday_today;
705: if g_debug then
706: hr_utility.set_location ( 'Leaving:'
707: || l_proc, 30);
708: end if;
709: RETURN l_holiday_today;
710: END day_is_holiday;

Line 722: g_debug :=hr_utility.debug_enabled;

718: IS
719: l_proc VARCHAR2 (72) ;
720: l_approved BOOLEAN;
721: BEGIN
722: g_debug :=hr_utility.debug_enabled;
723: if g_debug then
724: l_proc := g_package
725: || 'timecard_approved';
726: hr_utility.set_location ( 'Entering:'

Line 726: hr_utility.set_location ( 'Entering:'

722: g_debug :=hr_utility.debug_enabled;
723: if g_debug then
724: l_proc := g_package
725: || 'timecard_approved';
726: hr_utility.set_location ( 'Entering:'
727: || l_proc, 10);
728: end if;
729: IF (NVL (p_source_flag, 'NOT S') = 'S')
730: THEN

Line 732: hr_utility.set_location ( ' '

728: end if;
729: IF (NVL (p_source_flag, 'NOT S') = 'S')
730: THEN
731: if g_debug then
732: hr_utility.set_location ( ' '
733: || p_tim_id
734: || ' is approved', 20);
735: end if;
736: l_approved := TRUE;

Line 741: hr_utility.set_location ( ' '

737: ELSE
738: IF (p_approver_id IS NOT NULL)
739: THEN
740: if g_debug then
741: hr_utility.set_location ( ' '
742: || p_tim_id
743: || ' is approved', 30);
744: end if;
745: l_approved := TRUE;

Line 752: hr_utility.set_location ( 'Leaving:'

748: END IF;
749: END IF;
750:
751: if g_debug then
752: hr_utility.set_location ( 'Leaving:'
753: || l_proc, 100);
754: end if;
755: RETURN l_approved;
756: END timecard_approved;

Line 772: g_debug :=hr_utility.debug_enabled;

768: l_accrual_plan_name pay_accrual_plans.accrual_plan_name%TYPE;
769: l_charged_hrs NUMBER;
770: l_accrued_hrs NUMBER;
771: BEGIN
772: g_debug :=hr_utility.debug_enabled;
773: if g_debug then
774: l_proc := g_package
775: || 'tcard_approved';
776: hr_utility.set_location ( 'Entering:'

Line 776: hr_utility.set_location ( 'Entering:'

772: g_debug :=hr_utility.debug_enabled;
773: if g_debug then
774: l_proc := g_package
775: || 'tcard_approved';
776: hr_utility.set_location ( 'Entering:'
777: || l_proc, 10);
778: end if;
779: IF NOT (timecard_approved (
780: p_tim_id=> p_tim_id,

Line 795: hr_utility.set_location ( 'Leaving:'

791: );
792: END IF;
793:
794: if g_debug then
795: hr_utility.set_location ( 'Leaving:'
796: || l_proc, 100);
797: end if;
798: END tcard_approved;
799:

Line 817: g_debug :=hr_utility.debug_enabled;

813: WHERE pbg.business_group_id = p_bg_id;
814:
815: l_legislation_code per_business_groups.legislation_code%TYPE;
816: BEGIN
817: g_debug :=hr_utility.debug_enabled;
818: if g_debug then
819: l_proc := g_package
820: || 'legislation_code';
821: hr_utility.set_location ( 'Entering:'

Line 821: hr_utility.set_location ( 'Entering:'

817: g_debug :=hr_utility.debug_enabled;
818: if g_debug then
819: l_proc := g_package
820: || 'legislation_code';
821: hr_utility.set_location ( 'Entering:'
822: || l_proc, 10);
823: end if;
824: OPEN csr_legislation_code (p_bg_id);
825: FETCH csr_legislation_code INTO l_legislation_code;

Line 828: hr_utility.set_location ( ' returning '

824: OPEN csr_legislation_code (p_bg_id);
825: FETCH csr_legislation_code INTO l_legislation_code;
826: CLOSE csr_legislation_code;
827: if g_debug then
828: hr_utility.set_location ( ' returning '
829: || l_legislation_code, 20);
830: hr_utility.set_location ( 'Leaving:'
831: || l_proc, 30);
832: end if;

Line 830: hr_utility.set_location ( 'Leaving:'

826: CLOSE csr_legislation_code;
827: if g_debug then
828: hr_utility.set_location ( ' returning '
829: || l_legislation_code, 20);
830: hr_utility.set_location ( 'Leaving:'
831: || l_proc, 30);
832: end if;
833: RETURN l_legislation_code;
834: END legislation_code;

Line 858: g_debug :=hr_utility.debug_enabled;

854:
855: l_business_group_id per_assignments_f.business_group_id%TYPE;
856: l_legislation_code per_business_groups.legislation_code%TYPE;
857: BEGIN
858: g_debug :=hr_utility.debug_enabled;
859: if g_debug then
860: l_proc := g_package
861: || 'legislation_code';
862: hr_utility.set_location ( 'Entering:'

Line 862: hr_utility.set_location ( 'Entering:'

858: g_debug :=hr_utility.debug_enabled;
859: if g_debug then
860: l_proc := g_package
861: || 'legislation_code';
862: hr_utility.set_location ( 'Entering:'
863: || l_proc, 10);
864: end if;
865: OPEN csr_business_group (p_asg_id, p_effective_date);
866: FETCH csr_business_group INTO l_business_group_id;

Line 870: hr_utility.set_location ( ' returning '

866: FETCH csr_business_group INTO l_business_group_id;
867: CLOSE csr_business_group;
868: l_legislation_code := legislation_code (p_bg_id => l_business_group_id);
869: if g_debug then
870: hr_utility.set_location ( ' returning '
871: || l_legislation_code, 20);
872: hr_utility.set_location ( 'Leaving:'
873: || l_proc, 30);
874: end if;

Line 872: hr_utility.set_location ( 'Leaving:'

868: l_legislation_code := legislation_code (p_bg_id => l_business_group_id);
869: if g_debug then
870: hr_utility.set_location ( ' returning '
871: || l_legislation_code, 20);
872: hr_utility.set_location ( 'Leaving:'
873: || l_proc, 30);
874: end if;
875: RETURN l_legislation_code;
876: END legislation_code;

Line 914: g_debug :=hr_utility.debug_enabled;

910:
911: l_rec_active_assignment csr_active_assignment%ROWTYPE;
912: l_active_assignment BOOLEAN;
913: BEGIN
914: g_debug :=hr_utility.debug_enabled;
915: if g_debug then
916: l_proc := g_package
917: || 'assignment_is_active';
918: hr_utility.set_location ( 'Entering:'

Line 918: hr_utility.set_location ( 'Entering:'

914: g_debug :=hr_utility.debug_enabled;
915: if g_debug then
916: l_proc := g_package
917: || 'assignment_is_active';
918: hr_utility.set_location ( 'Entering:'
919: || l_proc, 10);
920: end if;
921: OPEN csr_active_assignment (p_asg_id, p_effective_date);
922: FETCH csr_active_assignment INTO l_rec_active_assignment;

Line 927: hr_utility.set_location (

923:
924: IF csr_active_assignment%FOUND
925: THEN
926: if g_debug then
927: hr_utility.set_location (
928: ' assignment '
929: || p_asg_id
930: || ' is active on '
931: || p_effective_date,

Line 942: hr_utility.set_location ( 'Leaving:'

938: END IF;
939:
940: CLOSE csr_active_assignment;
941: if g_debug then
942: hr_utility.set_location ( 'Leaving:'
943: || l_proc, 30);
944: end if;
945: RETURN l_active_assignment;
946: END assignment_is_active;

Line 959: g_debug :=hr_utility.debug_enabled;

955: )
956: IS
957: l_proc VARCHAR2 (72) ;
958: BEGIN
959: g_debug :=hr_utility.debug_enabled;
960: if g_debug then
961: l_proc := g_package
962: || 'inactive_emp_tcard';
963: hr_utility.set_location ( 'Entering:'

Line 963: hr_utility.set_location ( 'Entering:'

959: g_debug :=hr_utility.debug_enabled;
960: if g_debug then
961: l_proc := g_package
962: || 'inactive_emp_tcard';
963: hr_utility.set_location ( 'Entering:'
964: || l_proc, 10);
965: end if;
966: IF NOT (assignment_is_active (
967: p_asg_id=> p_assignment_id,

Line 981: hr_utility.set_location ( 'Leaving:'

977: );
978: END IF;
979:
980: if g_debug then
981: hr_utility.set_location ( 'Leaving:'
982: || l_proc, 100);
983: end if;
984: END inactive_emp_tcard;
985:

Line 1007: g_debug :=hr_utility.debug_enabled;

1003: WHERE hhd.holiday_date = p_day
1004: AND hhc.id = p_hol_cal_id
1005: AND hhd.hcl_id = hhc.id;
1006: BEGIN
1007: g_debug :=hr_utility.debug_enabled;
1008: if g_debug then
1009: hr_utility.set_location ( 'Entering:'
1010: || l_proc, 10);
1011: hr_utility.set_location ( ' p_hol_cal_id = '

Line 1009: hr_utility.set_location ( 'Entering:'

1005: AND hhd.hcl_id = hhc.id;
1006: BEGIN
1007: g_debug :=hr_utility.debug_enabled;
1008: if g_debug then
1009: hr_utility.set_location ( 'Entering:'
1010: || l_proc, 10);
1011: hr_utility.set_location ( ' p_hol_cal_id = '
1012: || p_hol_cal_id, 20);
1013: hr_utility.set_location ( ' p_day = '

Line 1011: hr_utility.set_location ( ' p_hol_cal_id = '

1007: g_debug :=hr_utility.debug_enabled;
1008: if g_debug then
1009: hr_utility.set_location ( 'Entering:'
1010: || l_proc, 10);
1011: hr_utility.set_location ( ' p_hol_cal_id = '
1012: || p_hol_cal_id, 20);
1013: hr_utility.set_location ( ' p_day = '
1014: || p_day, 30);
1015: end if;

Line 1013: hr_utility.set_location ( ' p_day = '

1009: hr_utility.set_location ( 'Entering:'
1010: || l_proc, 10);
1011: hr_utility.set_location ( ' p_hol_cal_id = '
1012: || p_hol_cal_id, 20);
1013: hr_utility.set_location ( ' p_day = '
1014: || p_day, 30);
1015: end if;
1016: OPEN csr_holiday_info (p_hol_cal_id, p_day);
1017: FETCH csr_holiday_info INTO p_hol_hours, p_hol_element_type_id;

Line 1020: hr_utility.set_location (

1016: OPEN csr_holiday_info (p_hol_cal_id, p_day);
1017: FETCH csr_holiday_info INTO p_hol_hours, p_hol_element_type_id;
1018: CLOSE csr_holiday_info;
1019: if g_debug then
1020: hr_utility.set_location (
1021: ' Found p_hol_hours = '
1022: || p_hol_hours,
1023: 40
1024: );

Line 1025: hr_utility.set_location (

1021: ' Found p_hol_hours = '
1022: || p_hol_hours,
1023: 40
1024: );
1025: hr_utility.set_location (
1026: ' p_hol_element_type_id = '
1027: || p_hol_element_type_id,
1028: 50
1029: );

Line 1030: hr_utility.set_location ( 'Leaving:'

1026: ' p_hol_element_type_id = '
1027: || p_hol_element_type_id,
1028: 50
1029: );
1030: hr_utility.set_location ( 'Leaving:'
1031: || l_proc, 100);
1032: end if;
1033: END get_holiday_info;
1034:

Line 1045: g_debug :=hr_utility.debug_enabled;

1041: )
1042: IS
1043: l_proc VARCHAR2 (72) ;
1044: BEGIN
1045: g_debug :=hr_utility.debug_enabled;
1046: if g_debug then
1047: l_proc := g_package
1048: || 'get_holiday_info';
1049: hr_utility.set_location ( 'Entering:'

Line 1049: hr_utility.set_location ( 'Entering:'

1045: g_debug :=hr_utility.debug_enabled;
1046: if g_debug then
1047: l_proc := g_package
1048: || 'get_holiday_info';
1049: hr_utility.set_location ( 'Entering:'
1050: || l_proc, 10);
1051: end if;
1052: get_holiday_info (
1053: p_day => p_day,

Line 1062: hr_utility.set_location ( 'Leaving:'

1058: p_hol_hours=> p_hol_hours,
1059: p_hol_element_type_id=> p_hol_element_type_id
1060: );
1061: if g_debug then
1062: hr_utility.set_location ( 'Leaving:'
1063: || l_proc, 20);
1064: end if;
1065: END get_holiday_info;
1066:

Line 1098: g_debug :=hr_utility.debug_enabled;

1094: );
1095:
1096: l_sum_hours NUMBER;
1097: BEGIN
1098: g_debug :=hr_utility.debug_enabled;
1099: if g_debug then
1100: l_proc := g_package
1101: || 'sum_unexploded_hours';
1102: hr_utility.set_location ( 'Entering:'

Line 1102: hr_utility.set_location ( 'Entering:'

1098: g_debug :=hr_utility.debug_enabled;
1099: if g_debug then
1100: l_proc := g_package
1101: || 'sum_unexploded_hours';
1102: hr_utility.set_location ( 'Entering:'
1103: || l_proc, 10);
1104: end if;
1105: OPEN csr_sum_hours (p_tim_id, p_day, p_hours_type);
1106: FETCH csr_sum_hours INTO l_sum_hours;

Line 1109: hr_utility.set_location ( ' returning '

1105: OPEN csr_sum_hours (p_tim_id, p_day, p_hours_type);
1106: FETCH csr_sum_hours INTO l_sum_hours;
1107: CLOSE csr_sum_hours;
1108: if g_debug then
1109: hr_utility.set_location ( ' returning '
1110: || NVL (l_sum_hours, 0), 30);
1111: hr_utility.set_location ( 'Leaving:'
1112: || l_proc, 20);
1113: end if;

Line 1111: hr_utility.set_location ( 'Leaving:'

1107: CLOSE csr_sum_hours;
1108: if g_debug then
1109: hr_utility.set_location ( ' returning '
1110: || NVL (l_sum_hours, 0), 30);
1111: hr_utility.set_location ( 'Leaving:'
1112: || l_proc, 20);
1113: end if;
1114: RETURN NVL (l_sum_hours, 0);
1115: END sum_unexploded_hours;

Line 1131: g_debug :=hr_utility.debug_enabled;

1127: l_proc VARCHAR2 (72) ;
1128: l_hol_hours hxt_holiday_days.hours%TYPE;
1129: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1130: BEGIN
1131: g_debug :=hr_utility.debug_enabled;
1132: if g_debug then
1133: l_proc := g_package
1134: || 'holiday_mismatch';
1135: hr_utility.set_location ( 'Entering:'

Line 1135: hr_utility.set_location ( 'Entering:'

1131: g_debug :=hr_utility.debug_enabled;
1132: if g_debug then
1133: l_proc := g_package
1134: || 'holiday_mismatch';
1135: hr_utility.set_location ( 'Entering:'
1136: || l_proc, 10);
1137: end if;
1138: get_holiday_info (
1139: p_day => p_day,

Line 1164: hr_utility.set_location ( 'Leaving:'

1160: );
1161: END IF;
1162:
1163: if g_debug then
1164: hr_utility.set_location ( 'Leaving:'
1165: || l_proc, 100);
1166: end if;
1167: END holiday_mismatch;
1168:

Line 1181: g_debug :=hr_utility.debug_enabled;

1177: )
1178: IS
1179: l_proc VARCHAR2 (72) ;
1180: BEGIN
1181: g_debug :=hr_utility.debug_enabled;
1182: if g_debug then
1183: l_proc := g_package
1184: || 'holiday_valid';
1185: hr_utility.set_location ( 'Entering:'

Line 1185: hr_utility.set_location ( 'Entering:'

1181: g_debug :=hr_utility.debug_enabled;
1182: if g_debug then
1183: l_proc := g_package
1184: || 'holiday_valid';
1185: hr_utility.set_location ( 'Entering:'
1186: || l_proc, 10);
1187: end if;
1188: IF (NVL (p_hours_type, -1) =
1189: holiday_element_id (p_hol_cal_id => p_hol_cal_id)

Line 1206: hr_utility.set_location ( 'Leaving:'

1202: );
1203: END IF;
1204:
1205: if g_debug then
1206: hr_utility.set_location ( 'Leaving:'
1207: || l_proc, 20);
1208: end if;
1209: END holiday_valid;
1210:

Line 1221: g_debug :=hr_utility.debug_enabled;

1217: IS
1218: l_proc VARCHAR2 (72) ;
1219: l_element_link_id NUMBER;
1220: BEGIN
1221: g_debug :=hr_utility.debug_enabled;
1222: if g_debug then
1223: l_proc := g_package
1224: || 'element_link';
1225: hr_utility.set_location ( 'Entering:'

Line 1225: hr_utility.set_location ( 'Entering:'

1221: g_debug :=hr_utility.debug_enabled;
1222: if g_debug then
1223: l_proc := g_package
1224: || 'element_link';
1225: hr_utility.set_location ( 'Entering:'
1226: || l_proc, 10);
1227: end if;
1228: BEGIN
1229: SELECT el.element_link_id

Line 1284: hr_utility.set_location ( 'Leaving:'

1280: AND alu.effective_end_date)
1281: );
1282:
1283: if g_debug then
1284: hr_utility.set_location ( 'Leaving:'
1285: || l_proc, 20);
1286: end if;
1287: EXCEPTION
1288: WHEN NO_DATA_FOUND

Line 1294: hr_utility.set_location (

1290: l_element_link_id := NULL;
1291: END;
1292:
1293: if g_debug then
1294: hr_utility.set_location (
1295: ' returning l_element_link_id = '
1296: || l_element_link_id,
1297: 20
1298: );

Line 1299: hr_utility.set_location ( 'Leaving:'

1295: ' returning l_element_link_id = '
1296: || l_element_link_id,
1297: 20
1298: );
1299: hr_utility.set_location ( 'Leaving:'
1300: || l_proc, 30);
1301: end if;
1302: RETURN l_element_link_id;
1303: END element_link;

Line 1316: g_debug :=hr_utility.debug_enabled;

1312: l_proc VARCHAR2 (72);
1313: l_element_linked BOOLEAN;
1314: l_element_link_id pay_element_links_f.element_link_id%TYPE;
1315: BEGIN
1316: g_debug :=hr_utility.debug_enabled;
1317: if g_debug then
1318: l_proc := g_package
1319: || 'element_linked';
1320: hr_utility.set_location ( 'Entering:'

Line 1320: hr_utility.set_location ( 'Entering:'

1316: g_debug :=hr_utility.debug_enabled;
1317: if g_debug then
1318: l_proc := g_package
1319: || 'element_linked';
1320: hr_utility.set_location ( 'Entering:'
1321: || l_proc, 10);
1322: end if;
1323: l_element_link_id :=
1324: element_link (

Line 1333: hr_utility.set_location (

1329:
1330: IF (l_element_link_id IS NOT NULL)
1331: THEN
1332: if g_debug then
1333: hr_utility.set_location (
1334: ' '
1335: || p_element_type_id
1336: || ' is a valid element for asg '
1337: || p_assignment_id

Line 1349: hr_utility.set_location ( 'Leaving:'

1345: l_element_linked := FALSE;
1346: END IF;
1347:
1348: if g_debug then
1349: hr_utility.set_location ( 'Leaving:'
1350: || l_proc, 30);
1351: end if;
1352: RETURN l_element_linked;
1353: END element_linked;

Line 1381: g_debug :=hr_utility.debug_enabled;

1377: IS
1378: l_proc VARCHAR2 (72) ;
1379: l_valid_for_summing BOOLEAN;
1380: BEGIN
1381: g_debug :=hr_utility.debug_enabled;
1382: if g_debug then
1383: l_proc := g_package
1384: || 'valid_for_summing';
1385: hr_utility.set_location ( 'Entering:'

Line 1385: hr_utility.set_location ( 'Entering:'

1381: g_debug :=hr_utility.debug_enabled;
1382: if g_debug then
1383: l_proc := g_package
1384: || 'valid_for_summing';
1385: hr_utility.set_location ( 'Entering:'
1386: || l_proc, 10);
1387: end if;
1388: IF ( (element_linked (
1389: p_element_type_id=> p_element_id,

Line 1409: hr_utility.set_location (

1405: )
1406: )
1407: THEN
1408: if g_debug then
1409: hr_utility.set_location (
1410: ' element '
1411: || p_element_id
1412: || ' is valid for summing',
1413: 20

Line 1422: hr_utility.set_location ( 'Leaving:'

1418: l_valid_for_summing := FALSE;
1419: END IF;
1420:
1421: if g_debug then
1422: hr_utility.set_location ( 'Leaving:'
1423: || l_proc, 30);
1424: end if;
1425: RETURN l_valid_for_summing;
1426: END valid_for_summing;

Line 1457: g_debug :=hr_utility.debug_enabled;

1453: haeif.earning_category;
1454:
1455: l_summed_hours NUMBER := 0;
1456: BEGIN
1457: g_debug :=hr_utility.debug_enabled;
1458: if g_debug then
1459: l_proc := g_package
1460: || 'sum_valid_det_hours';
1461: hr_utility.set_location ( 'Entering:'

Line 1461: hr_utility.set_location ( 'Entering:'

1457: g_debug :=hr_utility.debug_enabled;
1458: if g_debug then
1459: l_proc := g_package
1460: || 'sum_valid_det_hours';
1461: hr_utility.set_location ( 'Entering:'
1462: || l_proc, 10);
1463: end if;
1464: FOR rec_det_hours IN csr_det_hours (p_tim_id, p_day)
1465: LOOP

Line 1483: hr_utility.set_location (

1479: + rec_det_hours.hours;
1480: END IF;
1481: END LOOP;
1482: if g_debug then
1483: hr_utility.set_location (
1484: ' returning l_summed_hours = '
1485: || l_summed_hours,
1486: 20
1487: );

Line 1488: hr_utility.set_location ( 'Leaving:'

1484: ' returning l_summed_hours = '
1485: || l_summed_hours,
1486: 20
1487: );
1488: hr_utility.set_location ( 'Leaving:'
1489: || l_proc, 30);
1490: end if;
1491: RETURN NVL (l_summed_hours, 0);
1492: END sum_valid_det_hours;

Line 1508: g_debug :=hr_utility.debug_enabled;

1504: l_proc VARCHAR2 (72) ;
1505: l_hol_hours hxt_holiday_days.hours%TYPE;
1506: l_hol_element hxt_holiday_calendars.element_type_id%TYPE;
1507: BEGIN
1508: g_debug :=hr_utility.debug_enabled;
1509: if g_debug then
1510: l_proc := g_package
1511: || 'day_over_24';
1512: hr_utility.set_location ( 'Entering:'

Line 1512: hr_utility.set_location ( 'Entering:'

1508: g_debug :=hr_utility.debug_enabled;
1509: if g_debug then
1510: l_proc := g_package
1511: || 'day_over_24';
1512: hr_utility.set_location ( 'Entering:'
1513: || l_proc, 10);
1514: end if;
1515: IF (sum_valid_det_hours (
1516: p_tim_id=> p_tim_id,

Line 1532: hr_utility.set_location ( 'Leaving:'

1528: );
1529: END IF;
1530:
1531: if g_debug then
1532: hr_utility.set_location ( 'Leaving:'
1533: || l_proc, 100);
1534: end if;
1535: END day_over_24;
1536:

Line 1549: g_debug :=hr_utility.debug_enabled;

1545: )
1546: IS
1547: l_proc VARCHAR2 (72) ;
1548: BEGIN
1549: g_debug :=hr_utility.debug_enabled;
1550: if g_debug then
1551: l_proc := g_package
1552: || 'holiday_as_reg';
1553: hr_utility.set_location ( 'Entering:'

Line 1553: hr_utility.set_location ( 'Entering:'

1549: g_debug :=hr_utility.debug_enabled;
1550: if g_debug then
1551: l_proc := g_package
1552: || 'holiday_as_reg';
1553: hr_utility.set_location ( 'Entering:'
1554: || l_proc, 10);
1555: hr_utility.set_location ( ' p_hours_type = '
1556: || p_hours_type, 20);
1557: end if;

Line 1555: hr_utility.set_location ( ' p_hours_type = '

1551: l_proc := g_package
1552: || 'holiday_as_reg';
1553: hr_utility.set_location ( 'Entering:'
1554: || l_proc, 10);
1555: hr_utility.set_location ( ' p_hours_type = '
1556: || p_hours_type, 20);
1557: end if;
1558: IF ( (day_is_holiday (p_day => p_day, p_hol_cal_id => p_hol_cal_id))
1559: AND (NVL (p_hours_type, -1) <>

Line 1573: hr_utility.set_location ( 'Leaving:'

1569: );
1570: END IF;
1571:
1572: if g_debug then
1573: hr_utility.set_location ( 'Leaving:'
1574: || l_proc, 100);
1575: end if;
1576: END holiday_as_reg;
1577:

Line 1596: hr_utility.set_location ( 'Entering:'

1592:
1593: if g_debug then
1594: l_proc := g_package
1595: || 'perform_holiday_validations';
1596: hr_utility.set_location ( 'Entering:'
1597: || l_proc, 10);
1598: end if;
1599: l_hol_cal_id := holiday_calendar_id (
1600: p_person_id=> p_person_id,

Line 1632: hr_utility.set_location ( 'Leaving:'

1628: p_hol_cal_id=> l_hol_cal_id
1629: );
1630: p_hol_cal_id := l_hol_cal_id;
1631: if g_debug then
1632: hr_utility.set_location ( 'Leaving:'
1633: || l_proc, 100);
1634: end if;
1635: END perform_holiday_validations;
1636:

Line 1674: hr_utility.set_location ( 'Entering:'

1670:
1671: if g_debug then
1672: l_proc := g_package
1673: || 'perform_day_validations';
1674: hr_utility.set_location ( 'Entering:'
1675: || l_proc, 10);
1676: end if;
1677:
1678: open c_no_mid_period_change(p_person_id );

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

1684:
1685: close c_no_mid_period_change;
1686:
1687: if g_debug then
1688: hr_utility.trace ('l_no_mid_period_change - '||l_no_mid_period_change);
1689: end if;
1690:
1691: FOR rec_days IN csr_days (p_tim_id)
1692: LOOP

Line 1742: hr_utility.set_location ( 'Leaving:'

1738: );
1739: end if;
1740:
1741: if g_debug then
1742: hr_utility.set_location ( 'Leaving:'
1743: || l_proc, 100);
1744: end if;
1745: END perform_day_validations;
1746:

Line 1759: g_debug :=hr_utility.debug_enabled;

1755: )
1756: AS
1757: l_proc VARCHAR2 (72) ;
1758: BEGIN
1759: g_debug :=hr_utility.debug_enabled;
1760: if g_debug then
1761: l_proc := g_package
1762: || 'validate_tc';
1763: hr_utility.set_location ( 'Entering:'

Line 1763: hr_utility.set_location ( 'Entering:'

1759: g_debug :=hr_utility.debug_enabled;
1760: if g_debug then
1761: l_proc := g_package
1762: || 'validate_tc';
1763: hr_utility.set_location ( 'Entering:'
1764: || l_proc, 10);
1765: end if;
1766:
1767:

Line 1815: hr_utility.set_location ( 'Leaving:'

1811: p_tim_id=> p_tim_id
1812: );
1813: p_error_level := error_level;
1814: if g_debug then
1815: hr_utility.set_location ( 'Leaving:'
1816: || l_proc, 100);
1817: end if;
1818: END validate_tc;
1819:

Line 1851: g_debug :=hr_utility.debug_enabled;

1847: tim.object_version_number, tim.rowid
1848: FROM hxt_timecards_x tim
1849: WHERE tim.batch_id = p_batch_id;
1850: BEGIN
1851: g_debug :=hr_utility.debug_enabled;
1852: if g_debug then
1853: l_proc := g_package
1854: || 'val_batch';
1855: hr_utility.set_location ( 'Entering:'

Line 1855: hr_utility.set_location ( 'Entering:'

1851: g_debug :=hr_utility.debug_enabled;
1852: if g_debug then
1853: l_proc := g_package
1854: || 'val_batch';
1855: hr_utility.set_location ( 'Entering:'
1856: || l_proc, 10);
1857: end if;
1858: reset_error_level;
1859: delete_prev_val_errors (p_batch_id => p_batch_id);

Line 1879: hr_utility.set_location (

1875:
1876: /********Bug: 5037996 **********/
1877:
1878: if g_debug then
1879: hr_utility.set_location (
1880: ' process timecard '
1881: || rec_tcs_in_batch.tim_id,
1882: 20
1883: );

Line 1884: hr_utility.set_location (

1880: ' process timecard '
1881: || rec_tcs_in_batch.tim_id,
1882: 20
1883: );
1884: hr_utility.set_location (
1885: ' Error Level at start = '
1886: || error_level,
1887: 30
1888: );

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

1911:
1912: IF p_merge_flag = '1' THEN
1913:
1914: if g_debug then
1915: hr_utility.trace('Populating merge_batches record'||
1916: ' batch_id: '||p_batch_id||' tc_id '||rec_tcs_in_batch.tim_id);
1917: end if;
1918:
1919: l_cnt := NVL(p_merge_batches.LAST,0) +1;

Line 1952: hr_utility.set_location ( 'Leaving:'

1948:
1949: hr_session_utilities.remove_session_row;
1950:
1951: if g_debug then
1952: hr_utility.set_location ( 'Leaving:'
1953: || l_proc, 100);
1954: end if;
1955: END val_batch;
1956: END hxt_batch_val;