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_TIMECARD_INFO dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxt_timecard_info AS
2: /* $Header: hxctimotm.pkb 120.2 2005/09/23 09:37:04 nissharm noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: PROCEDURE get_holiday_info (
7: p_date IN DATE,
8: p_hcl_id IN NUMBER,

Line 79: g_debug := hr_utility.debug_enabled;

75: l_rtp_err EXCEPTION;
76: l_egp_err EXCEPTION;
77:
78: BEGIN
79: g_debug := hr_utility.debug_enabled;
80:
81: if g_debug then
82: hr_utility.set_location ('Generate_Time', 10);
83: end if;

Line 82: hr_utility.set_location ('Generate_Time', 10);

78: BEGIN
79: g_debug := hr_utility.debug_enabled;
80:
81: if g_debug then
82: hr_utility.set_location ('Generate_Time', 10);
83: end if;
84: IF p_app_attributes.COUNT > 0
85: THEN
86: if g_debug then

Line 87: hr_utility.set_location ('Generate_Time', 20);

83: end if;
84: IF p_app_attributes.COUNT > 0
85: THEN
86: if g_debug then
87: hr_utility.set_location ('Generate_Time', 20);
88: end if;
89: FOR l IN p_app_attributes.FIRST .. p_app_attributes.LAST
90: LOOP
91: p_app_attributes (l).time_attribute_id := NULL;

Line 105: hr_utility.set_location ('Generate_Time', 30);

101: END IF;
102: IF p_timecard.COUNT > 0
103: THEN
104: if g_debug then
105: hr_utility.set_location ('Generate_Time', 30);
106: end if;
107: FOR l IN p_timecard.FIRST .. p_timecard.LAST
108: LOOP
109: p_timecard (l).time_building_block_id := NULL;

Line 135: hr_utility.trace('l_person_id :'||l_person_id);

131: END IF;
132: /* Start of Main Cursor */
133:
134: if g_debug then
135: hr_utility.trace('l_person_id :'||l_person_id);
136: hr_utility.trace('l_start_time:'||l_start_time);
137: hr_utility.trace('l_stop_time :'||l_stop_time);
138: end if;
139:

Line 136: hr_utility.trace('l_start_time:'||l_start_time);

132: /* Start of Main Cursor */
133:
134: if g_debug then
135: hr_utility.trace('l_person_id :'||l_person_id);
136: hr_utility.trace('l_start_time:'||l_start_time);
137: hr_utility.trace('l_stop_time :'||l_stop_time);
138: end if;
139:
140: FOR asg_rec IN g_asg_cur (l_person_id, l_start_time, l_stop_time)

Line 137: hr_utility.trace('l_stop_time :'||l_stop_time);

133:
134: if g_debug then
135: hr_utility.trace('l_person_id :'||l_person_id);
136: hr_utility.trace('l_start_time:'||l_start_time);
137: hr_utility.trace('l_stop_time :'||l_stop_time);
138: end if;
139:
140: FOR asg_rec IN g_asg_cur (l_person_id, l_start_time, l_stop_time)
141: LOOP

Line 143: hr_utility.set_location ('Generate_Time', 40);

139:
140: FOR asg_rec IN g_asg_cur (l_person_id, l_start_time, l_stop_time)
141: LOOP
142: if g_debug then
143: hr_utility.set_location ('Generate_Time', 40);
144: end if;
145: g_asg_rec := asg_rec;
146: l_row_num := l_row_num
147: + 1;

Line 149: hr_utility.TRACE ( 'l_row_num :'

145: g_asg_rec := asg_rec;
146: l_row_num := l_row_num
147: + 1;
148: if g_debug then
149: hr_utility.TRACE ( 'l_row_num :'
150: || l_row_num);
151: end if;
152: IF g_asg_rec.egp_id IS NULL
153: THEN

Line 155: hr_utility.set_location ('Generate_Time', 50);

151: end if;
152: IF g_asg_rec.egp_id IS NULL
153: THEN
154: if g_debug then
155: hr_utility.set_location ('Generate_Time', 50);
156: end if;
157: RAISE l_egp_err;
158: END IF;
159: IF g_asg_rec.rtp_id IS NULL

Line 162: hr_utility.set_location ('Generate_Time', 60);

158: END IF;
159: IF g_asg_rec.rtp_id IS NULL
160: THEN
161: if g_debug then
162: hr_utility.set_location ('Generate_Time', 60);
163: end if;
164: RAISE l_rtp_err;
165: END IF;
166: if g_debug then

Line 167: hr_utility.set_location ('Generate_Time', 70);

163: end if;
164: RAISE l_rtp_err;
165: END IF;
166: if g_debug then
167: hr_utility.set_location ('Generate_Time', 70);
168:
169: hr_utility.trace('l_start_time :'||l_start_time);
170: hr_utility.trace('l_stop_time :'||l_stop_time);
171: hr_utility.trace('g_asg_rec.rtp_id :'||g_asg_rec.rtp_id);

Line 169: hr_utility.trace('l_start_time :'||l_start_time);

165: END IF;
166: if g_debug then
167: hr_utility.set_location ('Generate_Time', 70);
168:
169: hr_utility.trace('l_start_time :'||l_start_time);
170: hr_utility.trace('l_stop_time :'||l_stop_time);
171: hr_utility.trace('g_asg_rec.rtp_id :'||g_asg_rec.rtp_id);
172: end if;
173:

Line 170: hr_utility.trace('l_stop_time :'||l_stop_time);

166: if g_debug then
167: hr_utility.set_location ('Generate_Time', 70);
168:
169: hr_utility.trace('l_start_time :'||l_start_time);
170: hr_utility.trace('l_stop_time :'||l_stop_time);
171: hr_utility.trace('g_asg_rec.rtp_id :'||g_asg_rec.rtp_id);
172: end if;
173:
174: gen_rot_plan (

Line 171: hr_utility.trace('g_asg_rec.rtp_id :'||g_asg_rec.rtp_id);

167: hr_utility.set_location ('Generate_Time', 70);
168:
169: hr_utility.trace('l_start_time :'||l_start_time);
170: hr_utility.trace('l_stop_time :'||l_stop_time);
171: hr_utility.trace('g_asg_rec.rtp_id :'||g_asg_rec.rtp_id);
172: end if;
173:
174: gen_rot_plan (
175: l_start_time,

Line 183: hr_utility.set_location ('Generate_Time', 80);

179: p_timecard
180: );
181:
182: if g_debug then
183: hr_utility.set_location ('Generate_Time', 80);
184: end if;
185: FOR l_cnt IN
186: p_timecard.FIRST .. p_timecard.LAST
187: LOOP

Line 189: hr_utility.TRACE (

185: FOR l_cnt IN
186: p_timecard.FIRST .. p_timecard.LAST
187: LOOP
188: if g_debug then
189: hr_utility.TRACE (
190: 'p_timecard BB ID is : '
191: || TO_CHAR (
192: p_timecard (l_cnt).time_building_block_id
193: )

Line 195: hr_utility.TRACE (

191: || TO_CHAR (
192: p_timecard (l_cnt).time_building_block_id
193: )
194: );
195: hr_utility.TRACE (
196: 'p_timecard Scope is : '
197: || (
198: p_timecard (l_cnt).scope
199: )

Line 201: hr_utility.TRACE (

197: || (
198: p_timecard (l_cnt).scope
199: )
200: );
201: hr_utility.TRACE (
202: 'p_timecard start_time is : '
203: || TO_CHAR (p_timecard (l_cnt).start_time,
204: 'dd-mon-yyyy hh24:mi:ss')
205: );

Line 206: hr_utility.TRACE (

202: 'p_timecard start_time is : '
203: || TO_CHAR (p_timecard (l_cnt).start_time,
204: 'dd-mon-yyyy hh24:mi:ss')
205: );
206: hr_utility.TRACE (
207: 'p_timecard stop_time is : '
208: || TO_CHAR (p_timecard (l_cnt).stop_time,
209: 'dd-mon-yyyy hh24:mi:ss')
210: );

Line 215: hr_utility.set_location ('Generate_Time', 90);

211: end if;
212: END LOOP;
213:
214: if g_debug then
215: hr_utility.set_location ('Generate_Time', 90);
216: end if;
217:
218: END LOOP;
219:

Line 221: hr_utility.set_location ('Generate_Time', 100);

217:
218: END LOOP;
219:
220: if g_debug then
221: hr_utility.set_location ('Generate_Time', 100);
222: end if;
223:
224: IF l_row_num = 0
225: THEN

Line 227: hr_utility.set_location ('Generate_Time', 110);

223:
224: IF l_row_num = 0
225: THEN
226: if g_debug then
227: hr_utility.set_location ('Generate_Time', 110);
228: end if;
229: RAISE l_error;
230: END IF;
231:

Line 237: hr_utility.set_location ('Generate_Time', 100);

233: EXCEPTION
234: WHEN l_error
235: THEN
236: if g_debug then
237: hr_utility.set_location ('Generate_Time', 100);
238: end if;
239: --if g_debug then
240: --hr_utility.TRACE ( 'l_row_num:'
241: -- || l_row_num);

Line 240: --hr_utility.TRACE ( 'l_row_num:'

236: if g_debug then
237: hr_utility.set_location ('Generate_Time', 100);
238: end if;
239: --if g_debug then
240: --hr_utility.TRACE ( 'l_row_num:'
241: -- || l_row_num);
242: --end if;
243: --fnd_message.set_name ('HXC', 'HXC_366279_NO_WRKPLAN_ERR');
244: --fnd_message.raise_error;

Line 246: hr_utility.trace('Adding Up message NoWorkplan');

242: --end if;
243: --fnd_message.set_name ('HXC', 'HXC_366279_NO_WRKPLAN_ERR');
244: --fnd_message.raise_error;
245: if g_debug then
246: hr_utility.trace('Adding Up message NoWorkplan');
247: end if;
248: hxc_timecard_message_helper.adderrortocollection (
249: p_messages => p_messages
250: , p_message_name => 'HXC_366279_NO_WRKPLAN_ERR'

Line 260: hr_utility.trace('The count of p_messages is: ' || p_messages.count);

256: , p_time_building_block_ovn => NULL
257: , p_time_attribute_id => NULL
258: , p_time_attribute_ovn => NULL );
259: if g_debug then
260: hr_utility.trace('The count of p_messages is: ' || p_messages.count);
261: end if;
262: WHEN l_egp_err
263: THEN
264: if g_debug then

Line 265: hr_utility.set_location ('Generate_Time', 110);

261: end if;
262: WHEN l_egp_err
263: THEN
264: if g_debug then
265: hr_utility.set_location ('Generate_Time', 110);
266: end if;
267: --fnd_message.set_name ('HXC', 'HXC_366280_ERR_NO_ERN_POL');
268: --fnd_message.raise_error;
269: hxc_timecard_message_helper.adderrortocollection (

Line 281: hr_utility.trace('The count of p_messages is: ' || p_messages.count);

277: , p_time_building_block_ovn => NULL
278: , p_time_attribute_id => NULL
279: , p_time_attribute_ovn => NULL );
280: if g_debug then
281: hr_utility.trace('The count of p_messages is: ' || p_messages.count);
282: end if;
283: WHEN l_rtp_err
284: THEN
285: if g_debug then

Line 286: hr_utility.set_location ('Generate_Time', 120);

282: end if;
283: WHEN l_rtp_err
284: THEN
285: if g_debug then
286: hr_utility.set_location ('Generate_Time', 120);
287: end if;
288: --if g_debug then
289: --hr_utility.TRACE ( 'ROT_PLAN_ERR:'
290: --|| g_asg_rec.rtp_id);

Line 289: --hr_utility.TRACE ( 'ROT_PLAN_ERR:'

285: if g_debug then
286: hr_utility.set_location ('Generate_Time', 120);
287: end if;
288: --if g_debug then
289: --hr_utility.TRACE ( 'ROT_PLAN_ERR:'
290: --|| g_asg_rec.rtp_id);
291: --end if;
292: --fnd_message.set_name ('HXC', 'HXC_366281_ERR_NO_ROT_PLAN');
293: --fnd_message.raise_error;

Line 306: hr_utility.trace('The count of p_messages is: ' || p_messages.count);

302: , p_time_building_block_ovn => NULL
303: , p_time_attribute_id => NULL
304: , p_time_attribute_ovn => NULL );
305: if g_debug then
306: hr_utility.trace('The count of p_messages is: ' || p_messages.count);
307: end if;
308:
309: WHEN OTHERS
310: THEN

Line 312: hr_utility.set_location ('Generate_Time', 130);

308:
309: WHEN OTHERS
310: THEN
311: if g_debug then
312: hr_utility.set_location ('Generate_Time', 130);
313: end if;
314: --fnd_message.set_name ('HXC', 'HXC_366282_AUTOGEN_ERR');
315: --fnd_message.raise_error;
316: hxc_timecard_message_helper.adderrortocollection (

Line 328: hr_utility.trace('The count of p_messages is: ' || p_messages.count);

324: , p_time_building_block_ovn => NULL
325: , p_time_attribute_id => NULL
326: , p_time_attribute_ovn => NULL );
327: if g_debug then
328: hr_utility.trace('The count of p_messages is: ' || p_messages.count);
329: end if;
330: END;
331: --------------------------------------------------------------------------------
332: PROCEDURE get_work_day (

Line 359: g_debug := hr_utility.debug_enabled;

355: AND sht.id = wsh.sht_id;
356:
357: --l_lookup_code VARCHAR2 (30);
358: BEGIN
359: g_debug := hr_utility.debug_enabled;
360:
361: if g_debug then
362: hr_utility.set_location ('Get_Work_Day', 10);
363: end if;

Line 362: hr_utility.set_location ('Get_Work_Day', 10);

358: BEGIN
359: g_debug := hr_utility.debug_enabled;
360:
361: if g_debug then
362: hr_utility.set_location ('Get_Work_Day', 10);
363: end if;
364:
365: -- Select the lookup cod efo rthe weekday from hr_lookups in order to
366: -- avoid translation issues

Line 375: hr_utility.TRACE ( 'l_lookup_code :'

371: WHERE lookup_type = 'HXT_DAY_OF_WEEK'
372: AND UPPER (RTRIM (meaning)) = UPPER (RTRIM (TO_CHAR (p_date, 'DAY')));
373:
374: if g_debug then
375: hr_utility.TRACE ( 'l_lookup_code :'
376: || l_lookup_code);
377: hr_utility.TRACE ( 'p_work_id :'
378: || p_work_id);
379: hr_utility.TRACE ( 'p_date :'

Line 377: hr_utility.TRACE ( 'p_work_id :'

373:
374: if g_debug then
375: hr_utility.TRACE ( 'l_lookup_code :'
376: || l_lookup_code);
377: hr_utility.TRACE ( 'p_work_id :'
378: || p_work_id);
379: hr_utility.TRACE ( 'p_date :'
380: || p_date);
381: hr_utility.set_location ('Get_Work_Day', 20);

Line 379: hr_utility.TRACE ( 'p_date :'

375: hr_utility.TRACE ( 'l_lookup_code :'
376: || l_lookup_code);
377: hr_utility.TRACE ( 'p_work_id :'
378: || p_work_id);
379: hr_utility.TRACE ( 'p_date :'
380: || p_date);
381: hr_utility.set_location ('Get_Work_Day', 20);
382: end if;
383: */

Line 381: hr_utility.set_location ('Get_Work_Day', 20);

377: hr_utility.TRACE ( 'p_work_id :'
378: || p_work_id);
379: hr_utility.TRACE ( 'p_date :'
380: || p_date);
381: hr_utility.set_location ('Get_Work_Day', 20);
382: end if;
383: */
384: OPEN work_day (p_work_id, p_date); --, l_lookup_code);
385: FETCH work_day INTO p_standard_start, p_standard_stop, p_hours;

Line 388: hr_utility.TRACE ( 'p_standard_start :'

384: OPEN work_day (p_work_id, p_date); --, l_lookup_code);
385: FETCH work_day INTO p_standard_start, p_standard_stop, p_hours;
386: CLOSE work_day;
387: if g_debug then
388: hr_utility.TRACE ( 'p_standard_start :'
389: || p_standard_start);
390: hr_utility.TRACE ( 'p_standard_stop :'
391: || p_standard_stop);
392: end if;

Line 390: hr_utility.TRACE ( 'p_standard_stop :'

386: CLOSE work_day;
387: if g_debug then
388: hr_utility.TRACE ( 'p_standard_start :'
389: || p_standard_start);
390: hr_utility.TRACE ( 'p_standard_stop :'
391: || p_standard_stop);
392: end if;
393: EXCEPTION
394: WHEN OTHERS

Line 397: hr_utility.set_location ('Get_Work_Day', 30);

393: EXCEPTION
394: WHEN OTHERS
395: THEN
396: if g_debug then
397: hr_utility.set_location ('Get_Work_Day', 30);
398: end if;
399: fnd_message.set_name ('HXC', 'HXC_366283_GET_WRK_DAY_ERR');
400: END get_work_day;
401:

Line 445: g_debug := hr_utility.debug_enabled;

441: AND aei.earning_category = 'REG';
442: l_update_flag varchar2(1) := 'N';
443:
444: BEGIN
445: g_debug := hr_utility.debug_enabled;
446:
447: if g_debug then
448: hr_utility.set_location ('Gen_Work_Plan', 10);
449: end if;

Line 448: hr_utility.set_location ('Gen_Work_Plan', 10);

444: BEGIN
445: g_debug := hr_utility.debug_enabled;
446:
447: if g_debug then
448: hr_utility.set_location ('Gen_Work_Plan', 10);
449: end if;
450: l_update_flag := 'N';
451:
452: -- Get number of days to be generated

Line 457: hr_utility.TRACE ( 'l_days :'

453: l_days := p_end
454: - p_start;
455:
456: if g_debug then
457: hr_utility.TRACE ( 'l_days :'
458: || l_days);
459: end if;
460: IF l_days < 0
461: THEN

Line 463: hr_utility.set_location ('Gen_Work_Plan', 20);

459: end if;
460: IF l_days < 0
461: THEN
462: if g_debug then
463: hr_utility.set_location ('Gen_Work_Plan', 20);
464: end if;
465: fnd_message.set_name ('HXC', 'HXC_366284_NUM_DAYS_ERR');
466: fnd_message.raise_error;
467: END IF;

Line 470: hr_utility.TRACE ( 'l_days:'

466: fnd_message.raise_error;
467: END IF;
468:
469: if g_debug then
470: hr_utility.TRACE ( 'l_days:'
471: || l_days);
472: end if;
473: --Loop through number of days passed
474: FOR i IN 0 .. l_days

Line 488: hr_utility.trace('l_time_in_timecard:'||l_time_in_timecard);

484: --Calculate Start Date and End Date for TIMECARD and DAY Scope
485: l_time_in_timecard := convert_timecard_time (p_start, 000000);
486:
487: if g_debug then
488: hr_utility.trace('l_time_in_timecard:'||l_time_in_timecard);
489: hr_utility.set_location ('Gen_Work_Plan', 21);
490: end if;
491:
492: l_time_out_timecard := convert_timecard_time (p_end, 000000, 000000);

Line 489: hr_utility.set_location ('Gen_Work_Plan', 21);

485: l_time_in_timecard := convert_timecard_time (p_start, 000000);
486:
487: if g_debug then
488: hr_utility.trace('l_time_in_timecard:'||l_time_in_timecard);
489: hr_utility.set_location ('Gen_Work_Plan', 21);
490: end if;
491:
492: l_time_out_timecard := convert_timecard_time (p_end, 000000, 000000);
493: if g_debug then

Line 494: hr_utility.trace('l_time_out_timecard:'||l_time_out_timecard);

490: end if;
491:
492: l_time_out_timecard := convert_timecard_time (p_end, 000000, 000000);
493: if g_debug then
494: hr_utility.trace('l_time_out_timecard:'||l_time_out_timecard);
495: hr_utility.trace('FYI...........');
496: end if;
497:
498: IF p_timecard.count > 0 THEN

Line 495: hr_utility.trace('FYI...........');

491:
492: l_time_out_timecard := convert_timecard_time (p_end, 000000, 000000);
493: if g_debug then
494: hr_utility.trace('l_time_out_timecard:'||l_time_out_timecard);
495: hr_utility.trace('FYI...........');
496: end if;
497:
498: IF p_timecard.count > 0 THEN
499: if g_debug then

Line 500: hr_utility.set_location ('Gen_Work_Plan', 22);

496: end if;
497:
498: IF p_timecard.count > 0 THEN
499: if g_debug then
500: hr_utility.set_location ('Gen_Work_Plan', 22);
501: end if;
502: FOR l_cnt IN
503: p_timecard.FIRST .. p_timecard.LAST
504: LOOP

Line 506: hr_utility.TRACE (

502: FOR l_cnt IN
503: p_timecard.FIRST .. p_timecard.LAST
504: LOOP
505: if g_debug then
506: hr_utility.TRACE (
507: 'p_timecard BB ID is : '
508: || TO_CHAR (
509: p_timecard (l_cnt).time_building_block_id
510: )

Line 512: hr_utility.TRACE (

508: || TO_CHAR (
509: p_timecard (l_cnt).time_building_block_id
510: )
511: );
512: hr_utility.TRACE (
513: 'p_timecard Scope is : '
514: || (
515: p_timecard (l_cnt).scope
516: )

Line 518: hr_utility.TRACE (

514: || (
515: p_timecard (l_cnt).scope
516: )
517: );
518: hr_utility.TRACE (
519: 'p_timecard start_time is : '
520: || TO_CHAR (p_timecard (l_cnt).start_time,
521: 'dd-mon-yyyy hh24:mi:ss')
522: );

Line 523: hr_utility.TRACE (

519: 'p_timecard start_time is : '
520: || TO_CHAR (p_timecard (l_cnt).start_time,
521: 'dd-mon-yyyy hh24:mi:ss')
522: );
523: hr_utility.TRACE (
524: 'p_timecard stop_time is : '
525: || TO_CHAR (p_timecard (l_cnt).stop_time,
526: 'dd-mon-yyyy hh24:mi:ss')
527: );

Line 532: hr_utility.trace('END FYI..............');

528: end if;
529: END LOOP;
530: END IF;
531: if g_debug then
532: hr_utility.trace('END FYI..............');
533: end if;
534:
535: -- Check if a row with the TIMECARD Scope has already been populated in
536: -- the pl/sql building block table. If so, then we do not need to create

Line 542: hr_utility.set_location ('Gen_Work_Plan', 23);

538: -- scope block if you come accross another one with the end date of the
539: -- later Timecard.
540: IF p_timecard.count > 0 THEN
541: if g_debug then
542: hr_utility.set_location ('Gen_Work_Plan', 23);
543: end if;
544: FOR l_timecard IN
545: p_timecard.FIRST .. p_timecard.LAST
546: LOOP

Line 548: hr_utility.set_location ('Gen_Work_Plan', 25);

544: FOR l_timecard IN
545: p_timecard.FIRST .. p_timecard.LAST
546: LOOP
547: if g_debug then
548: hr_utility.set_location ('Gen_Work_Plan', 25);
549: end if;
550:
551: IF (p_timecard (l_timecard).SCOPE = 'TIMECARD')
552: THEN

Line 555: hr_utility.set_location ('Gen_Work_Plan', 26);

551: IF (p_timecard (l_timecard).SCOPE = 'TIMECARD')
552: THEN
553: l_parent_id := p_timecard (l_timecard).time_building_block_id;
554: if g_debug then
555: hr_utility.set_location ('Gen_Work_Plan', 26);
556: hr_utility.trace('p_timecard(l_timecard).stop_time:'
557: ||p_timecard(l_timecard).stop_time);
558: hr_utility.trace('l_time_out_timecard:'
559: ||l_time_out_timecard);

Line 556: hr_utility.trace('p_timecard(l_timecard).stop_time:'

552: THEN
553: l_parent_id := p_timecard (l_timecard).time_building_block_id;
554: if g_debug then
555: hr_utility.set_location ('Gen_Work_Plan', 26);
556: hr_utility.trace('p_timecard(l_timecard).stop_time:'
557: ||p_timecard(l_timecard).stop_time);
558: hr_utility.trace('l_time_out_timecard:'
559: ||l_time_out_timecard);
560: end if;

Line 558: hr_utility.trace('l_time_out_timecard:'

554: if g_debug then
555: hr_utility.set_location ('Gen_Work_Plan', 26);
556: hr_utility.trace('p_timecard(l_timecard).stop_time:'
557: ||p_timecard(l_timecard).stop_time);
558: hr_utility.trace('l_time_out_timecard:'
559: ||l_time_out_timecard);
560: end if;
561:
562: IF p_timecard(l_timecard).stop_time < l_time_out_timecard

Line 565: hr_utility.set_location ('Gen_Work_Plan', 26.5);

561:
562: IF p_timecard(l_timecard).stop_time < l_time_out_timecard
563: THEN
564: if g_debug then
565: hr_utility.set_location ('Gen_Work_Plan', 26.5);
566: end if;
567: p_timecard(l_timecard).stop_time := l_time_out_timecard;
568: l_update_flag := 'Y';
569: END IF;

Line 572: hr_utility.set_location ('Gen_Work_Plan', 27);

568: l_update_flag := 'Y';
569: END IF;
570:
571: if g_debug then
572: hr_utility.set_location ('Gen_Work_Plan', 27);
573: end if;
574: EXIT;
575: if g_debug then
576: hr_utility.set_location ('Gen_Work_Plan', 28);

Line 576: hr_utility.set_location ('Gen_Work_Plan', 28);

572: hr_utility.set_location ('Gen_Work_Plan', 27);
573: end if;
574: EXIT;
575: if g_debug then
576: hr_utility.set_location ('Gen_Work_Plan', 28);
577: end if;
578: END IF;
579: END LOOP;
580: END IF;

Line 588: hr_utility.TRACE ( 'hours from get_work_day:'

584: l_time_out_day :=
585: convert_timecard_time ( p_start
586: + i, 000000, 235959);
587: if g_debug then
588: hr_utility.TRACE ( 'hours from get_work_day:'
589: || l_hours);
590: end if;
591: -- Create summary record
592: IF (l_hours IS NULL)

Line 612: hr_utility.TRACE ( 'p_hours:'

608: END IF;
609: l_elt_id := NULL;
610: p_hours := l_hours;
611: if g_debug then
612: hr_utility.TRACE ( 'p_hours:'
613: || p_hours);
614: end if;
615: get_holiday_info (
616: p_start

Line 641: hr_utility.TRACE ( 'p_hours after getting holday info:'

637: CLOSE c_get_base_hours_type;
638: END IF;
639:
640: if g_debug then
641: hr_utility.TRACE ( 'p_hours after getting holday info:'
642: || p_hours);
643: end if;
644:
645: IF i = 0 and l_update_flag = 'N'

Line 648: hr_utility.TRACE (

644:
645: IF i = 0 and l_update_flag = 'N'
646: THEN
647: if g_debug then
648: hr_utility.TRACE (
649: '---------- Entering TIMECARD Scope -------------------'
650: );
651: end if;
652: -- Enter the TIMECARD Scope in the pl/sql table

Line 681: hr_utility.TRACE (

677: p_timecard (l_next_index).parent_building_block_ovn := NULL;
678: p_timecard (l_next_index).NEW := 'Y';
679: p_timecard (l_next_index).changed := NULL;
680: if g_debug then
681: hr_utility.TRACE (
682: 'TIME_BUILDING_BLOCK_ID:'
683: || p_timecard (l_next_index).time_building_block_id
684: );
685: hr_utility.TRACE (

Line 685: hr_utility.TRACE (

681: hr_utility.TRACE (
682: 'TIME_BUILDING_BLOCK_ID:'
683: || p_timecard (l_next_index).time_building_block_id
684: );
685: hr_utility.TRACE (
686: 'MEASURE :'
687: || p_timecard (l_next_index).measure
688: );
689: hr_utility.TRACE (

Line 689: hr_utility.TRACE (

685: hr_utility.TRACE (
686: 'MEASURE :'
687: || p_timecard (l_next_index).measure
688: );
689: hr_utility.TRACE (
690: 'START_TIME :'
691: || p_timecard (l_next_index).start_time
692: );
693: hr_utility.TRACE (

Line 693: hr_utility.TRACE (

689: hr_utility.TRACE (
690: 'START_TIME :'
691: || p_timecard (l_next_index).start_time
692: );
693: hr_utility.TRACE (
694: 'STOP_TIME :'
695: || p_timecard (l_next_index).stop_time
696: );
697: hr_utility.TRACE (

Line 697: hr_utility.TRACE (

693: hr_utility.TRACE (
694: 'STOP_TIME :'
695: || p_timecard (l_next_index).stop_time
696: );
697: hr_utility.TRACE (
698: 'PARENT_BUILDING_BLOCK_ID :'
699: || p_timecard (l_next_index).parent_building_block_id
700: );
701: hr_utility.TRACE ( 'SCOPE :'

Line 701: hr_utility.TRACE ( 'SCOPE :'

697: hr_utility.TRACE (
698: 'PARENT_BUILDING_BLOCK_ID :'
699: || p_timecard (l_next_index).parent_building_block_id
700: );
701: hr_utility.TRACE ( 'SCOPE :'
702: || p_timecard (l_next_index).SCOPE);
703: hr_utility.TRACE (
704: 'RESOURCE_ID :'
705: || p_timecard (l_next_index).resource_id

Line 703: hr_utility.TRACE (

699: || p_timecard (l_next_index).parent_building_block_id
700: );
701: hr_utility.TRACE ( 'SCOPE :'
702: || p_timecard (l_next_index).SCOPE);
703: hr_utility.TRACE (
704: 'RESOURCE_ID :'
705: || p_timecard (l_next_index).resource_id
706: );
707: hr_utility.TRACE ( 'NEW:'

Line 707: hr_utility.TRACE ( 'NEW:'

703: hr_utility.TRACE (
704: 'RESOURCE_ID :'
705: || p_timecard (l_next_index).resource_id
706: );
707: hr_utility.TRACE ( 'NEW:'
708: || p_timecard (l_next_index).NEW);
709: end if;
710: END IF;
711:

Line 714: hr_utility.TRACE (

710: END IF;
711:
712:
713: if g_debug then
714: hr_utility.TRACE (
715: '---------- Entering DAY Scope -------------------'
716: );
717: end if;
718: l_next_index := p_timecard.COUNT

Line 721: hr_utility.trace('l_next_index:'||l_next_index);

717: end if;
718: l_next_index := p_timecard.COUNT
719: + 1;
720: if g_debug then
721: hr_utility.trace('l_next_index:'||l_next_index);
722: end if;
723: l_time_building_block_id := p_timecard.COUNT-- l_time_building_block_id
724: + 1;
725: if g_debug then

Line 726: hr_utility.trace('l_time_building_block_id:'

722: end if;
723: l_time_building_block_id := p_timecard.COUNT-- l_time_building_block_id
724: + 1;
725: if g_debug then
726: hr_utility.trace('l_time_building_block_id:'
727: ||l_time_building_block_id);
728: end if;
729: l_parent_building_block_id := l_time_building_block_id;
730: p_timecard (l_next_index).time_building_block_id :=

Line 752: hr_utility.TRACE (

748: p_timecard (l_next_index).parent_building_block_ovn := NULL;
749: p_timecard (l_next_index).NEW := 'Y';
750: p_timecard (l_next_index).changed := NULL;
751: if g_debug then
752: hr_utility.TRACE (
753: 'TIME_BUILDING_BLOCK_ID:'
754: || p_timecard (l_next_index).time_building_block_id
755: );
756: hr_utility.TRACE ( 'MEASURE :'

Line 756: hr_utility.TRACE ( 'MEASURE :'

752: hr_utility.TRACE (
753: 'TIME_BUILDING_BLOCK_ID:'
754: || p_timecard (l_next_index).time_building_block_id
755: );
756: hr_utility.TRACE ( 'MEASURE :'
757: || p_timecard (l_next_index).measure);
758: hr_utility.TRACE (
759: 'START_TIME :'
760: || p_timecard (l_next_index).start_time

Line 758: hr_utility.TRACE (

754: || p_timecard (l_next_index).time_building_block_id
755: );
756: hr_utility.TRACE ( 'MEASURE :'
757: || p_timecard (l_next_index).measure);
758: hr_utility.TRACE (
759: 'START_TIME :'
760: || p_timecard (l_next_index).start_time
761: );
762: hr_utility.TRACE (

Line 762: hr_utility.TRACE (

758: hr_utility.TRACE (
759: 'START_TIME :'
760: || p_timecard (l_next_index).start_time
761: );
762: hr_utility.TRACE (
763: 'STOP_TIME :'
764: || p_timecard (l_next_index).stop_time
765: );
766: hr_utility.TRACE (

Line 766: hr_utility.TRACE (

762: hr_utility.TRACE (
763: 'STOP_TIME :'
764: || p_timecard (l_next_index).stop_time
765: );
766: hr_utility.TRACE (
767: 'PARENT_BUILDING_BLOCK_ID :'
768: || p_timecard (l_next_index).parent_building_block_id
769: );
770: hr_utility.TRACE ( 'SCOPE :'

Line 770: hr_utility.TRACE ( 'SCOPE :'

766: hr_utility.TRACE (
767: 'PARENT_BUILDING_BLOCK_ID :'
768: || p_timecard (l_next_index).parent_building_block_id
769: );
770: hr_utility.TRACE ( 'SCOPE :'
771: || p_timecard (l_next_index).SCOPE);
772: hr_utility.TRACE (
773: 'RESOURCE_ID :'
774: || p_timecard (l_next_index).resource_id

Line 772: hr_utility.TRACE (

768: || p_timecard (l_next_index).parent_building_block_id
769: );
770: hr_utility.TRACE ( 'SCOPE :'
771: || p_timecard (l_next_index).SCOPE);
772: hr_utility.TRACE (
773: 'RESOURCE_ID :'
774: || p_timecard (l_next_index).resource_id
775: );
776: hr_utility.TRACE ( 'NEW:'

Line 776: hr_utility.TRACE ( 'NEW:'

772: hr_utility.TRACE (
773: 'RESOURCE_ID :'
774: || p_timecard (l_next_index).resource_id
775: );
776: hr_utility.TRACE ( 'NEW:'
777: || p_timecard (l_next_index).NEW);
778: end if;
779: IF ( (NVL (l_standard_start, 0) <> 0)
780: OR (NVL (l_standard_stop, 0) <> 0)

Line 793: hr_utility.TRACE (

789: /*l_time_attribute_id := l_time_attribute_id + 1;*/
790: l_time_attribute_id := p_app_attributes.COUNT
791: + 1;
792: if g_debug then
793: hr_utility.TRACE (
794: '---------- Entering DETAIL Scope -------------------'
795: );
796: end if;
797: p_timecard (l_next_index).time_building_block_id :=

Line 837: hr_utility.TRACE (

833: p_app_attributes (l_next_index).CATEGORY := 'ELEMENT';
834: p_app_attributes (l_next_index).updated := NULL;
835: p_app_attributes (l_next_index).changed := NULL;
836: if g_debug then
837: hr_utility.TRACE (
838: '---------- DETAIL Scope timecard info-------------------'
839: );
840: hr_utility.TRACE (
841: 'TIME_BUILDING_BLOCK_ID:'

Line 840: hr_utility.TRACE (

836: if g_debug then
837: hr_utility.TRACE (
838: '---------- DETAIL Scope timecard info-------------------'
839: );
840: hr_utility.TRACE (
841: 'TIME_BUILDING_BLOCK_ID:'
842: || p_timecard (l_next_index).time_building_block_id
843: );
844: hr_utility.TRACE ( 'TYPE:'

Line 844: hr_utility.TRACE ( 'TYPE:'

840: hr_utility.TRACE (
841: 'TIME_BUILDING_BLOCK_ID:'
842: || p_timecard (l_next_index).time_building_block_id
843: );
844: hr_utility.TRACE ( 'TYPE:'
845: || p_timecard (l_next_index).TYPE);
846: hr_utility.TRACE (
847: 'MEASURE :'
848: || p_timecard (l_next_index).measure

Line 846: hr_utility.TRACE (

842: || p_timecard (l_next_index).time_building_block_id
843: );
844: hr_utility.TRACE ( 'TYPE:'
845: || p_timecard (l_next_index).TYPE);
846: hr_utility.TRACE (
847: 'MEASURE :'
848: || p_timecard (l_next_index).measure
849: );
850: hr_utility.TRACE (

Line 850: hr_utility.TRACE (

846: hr_utility.TRACE (
847: 'MEASURE :'
848: || p_timecard (l_next_index).measure
849: );
850: hr_utility.TRACE (
851: 'START_TIME :'
852: || p_timecard (l_next_index).start_time
853: );
854: hr_utility.TRACE (

Line 854: hr_utility.TRACE (

850: hr_utility.TRACE (
851: 'START_TIME :'
852: || p_timecard (l_next_index).start_time
853: );
854: hr_utility.TRACE (
855: 'STOP_TIME :'
856: || p_timecard (l_next_index).stop_time
857: );
858: hr_utility.TRACE (

Line 858: hr_utility.TRACE (

854: hr_utility.TRACE (
855: 'STOP_TIME :'
856: || p_timecard (l_next_index).stop_time
857: );
858: hr_utility.TRACE (
859: 'PARENT_BUILDING_BLOCK_ID :'
860: || p_timecard (l_next_index).parent_building_block_id
861: );
862: hr_utility.TRACE ( 'SCOPE :'

Line 862: hr_utility.TRACE ( 'SCOPE :'

858: hr_utility.TRACE (
859: 'PARENT_BUILDING_BLOCK_ID :'
860: || p_timecard (l_next_index).parent_building_block_id
861: );
862: hr_utility.TRACE ( 'SCOPE :'
863: || p_timecard (l_next_index).SCOPE);
864: hr_utility.TRACE (
865: 'RESOURCE_ID :'
866: || p_timecard (l_next_index).resource_id

Line 864: hr_utility.TRACE (

860: || p_timecard (l_next_index).parent_building_block_id
861: );
862: hr_utility.TRACE ( 'SCOPE :'
863: || p_timecard (l_next_index).SCOPE);
864: hr_utility.TRACE (
865: 'RESOURCE_ID :'
866: || p_timecard (l_next_index).resource_id
867: );
868: hr_utility.TRACE ( 'NEW:'

Line 868: hr_utility.TRACE ( 'NEW:'

864: hr_utility.TRACE (
865: 'RESOURCE_ID :'
866: || p_timecard (l_next_index).resource_id
867: );
868: hr_utility.TRACE ( 'NEW:'
869: || p_timecard (l_next_index).NEW);
870: hr_utility.TRACE (
871: '---------- DETAIL Scope attributes info-------------------'
872: );

Line 870: hr_utility.TRACE (

866: || p_timecard (l_next_index).resource_id
867: );
868: hr_utility.TRACE ( 'NEW:'
869: || p_timecard (l_next_index).NEW);
870: hr_utility.TRACE (
871: '---------- DETAIL Scope attributes info-------------------'
872: );
873: hr_utility.TRACE (
874: 'TIME_ATTRIBUTE_ID:'

Line 873: hr_utility.TRACE (

869: || p_timecard (l_next_index).NEW);
870: hr_utility.TRACE (
871: '---------- DETAIL Scope attributes info-------------------'
872: );
873: hr_utility.TRACE (
874: 'TIME_ATTRIBUTE_ID:'
875: || p_app_attributes (l_next_index).time_attribute_id
876: );
877: hr_utility.TRACE (

Line 877: hr_utility.TRACE (

873: hr_utility.TRACE (
874: 'TIME_ATTRIBUTE_ID:'
875: || p_app_attributes (l_next_index).time_attribute_id
876: );
877: hr_utility.TRACE (
878: 'BUILDING_BLOCK_ID :'
879: || p_app_attributes (l_next_index).building_block_id
880: );
881: hr_utility.TRACE (

Line 881: hr_utility.TRACE (

877: hr_utility.TRACE (
878: 'BUILDING_BLOCK_ID :'
879: || p_app_attributes (l_next_index).building_block_id
880: );
881: hr_utility.TRACE (
882: 'ATTRIBUTE_NAME :'
883: || p_app_attributes (l_next_index).attribute_name
884: );
885: hr_utility.TRACE (

Line 885: hr_utility.TRACE (

881: hr_utility.TRACE (
882: 'ATTRIBUTE_NAME :'
883: || p_app_attributes (l_next_index).attribute_name
884: );
885: hr_utility.TRACE (
886: 'ATTRIBUTE_VALUE :'
887: || p_app_attributes (l_next_index).attribute_value
888: );
889: hr_utility.TRACE (

Line 889: hr_utility.TRACE (

885: hr_utility.TRACE (
886: 'ATTRIBUTE_VALUE :'
887: || p_app_attributes (l_next_index).attribute_value
888: );
889: hr_utility.TRACE (
890: 'BLD_BLK_INFO_TYPE:'
891: || p_app_attributes (l_next_index).bld_blk_info_type
892: );
893: hr_utility.TRACE (

Line 893: hr_utility.TRACE (

889: hr_utility.TRACE (
890: 'BLD_BLK_INFO_TYPE:'
891: || p_app_attributes (l_next_index).bld_blk_info_type
892: );
893: hr_utility.TRACE (
894: 'CATEGORY :'
895: || p_app_attributes (l_next_index).CATEGORY
896: );
897: end if;

Line 971: g_debug := hr_utility.debug_enabled;

967: l_next_index BINARY_INTEGER;
968: l_proc varchar2(100);
969:
970: BEGIN
971: g_debug := hr_utility.debug_enabled;
972:
973: if g_debug then
974: l_proc := 'HXT_TIMECARD_INFO.gen_rot_plan';
975: hr_utility.set_location(l_proc,10);

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

971: g_debug := hr_utility.debug_enabled;
972:
973: if g_debug then
974: l_proc := 'HXT_TIMECARD_INFO.gen_rot_plan';
975: hr_utility.set_location(l_proc,10);
976:
977: hr_utility.trace('p_start :'||p_start);
978: hr_utility.trace('p_end :'||p_end);
979: hr_utility.trace('p_rtp_id :'||p_rtp_id);

Line 977: hr_utility.trace('p_start :'||p_start);

973: if g_debug then
974: l_proc := 'HXT_TIMECARD_INFO.gen_rot_plan';
975: hr_utility.set_location(l_proc,10);
976:
977: hr_utility.trace('p_start :'||p_start);
978: hr_utility.trace('p_end :'||p_end);
979: hr_utility.trace('p_rtp_id :'||p_rtp_id);
980: end if;
981:

Line 978: hr_utility.trace('p_end :'||p_end);

974: l_proc := 'HXT_TIMECARD_INFO.gen_rot_plan';
975: hr_utility.set_location(l_proc,10);
976:
977: hr_utility.trace('p_start :'||p_start);
978: hr_utility.trace('p_end :'||p_end);
979: hr_utility.trace('p_rtp_id :'||p_rtp_id);
980: end if;
981:
982: FOR hrs_rec IN cur_hrs (p_start, p_end, p_rtp_id)

Line 979: hr_utility.trace('p_rtp_id :'||p_rtp_id);

975: hr_utility.set_location(l_proc,10);
976:
977: hr_utility.trace('p_start :'||p_start);
978: hr_utility.trace('p_end :'||p_end);
979: hr_utility.trace('p_rtp_id :'||p_rtp_id);
980: end if;
981:
982: FOR hrs_rec IN cur_hrs (p_start, p_end, p_rtp_id)
983: LOOP

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

981:
982: FOR hrs_rec IN cur_hrs (p_start, p_end, p_rtp_id)
983: LOOP
984: if g_debug then
985: hr_utility.set_location(l_proc,20);
986: end if;
987:
988: gen_work_plan (
989: hrs_rec.start_date,

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

993: p_timecard
994: );
995:
996: if g_debug then
997: hr_utility.set_location(l_proc,30);
998: end if;
999:
1000: END LOOP;
1001: if g_debug then

Line 1002: hr_utility.set_location(l_proc,40);

998: end if;
999:
1000: END LOOP;
1001: if g_debug then
1002: hr_utility.set_location(l_proc,40);
1003: end if;
1004:
1005: EXCEPTION
1006: WHEN OTHERS