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

Line 3: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY hxt_hxc_retrieval_process AS
2: /* $Header: hxthcrtp.pkb 120.12.12010000.2 2008/09/19 17:27:56 asrajago ship $ */
3: g_debug BOOLEAN := hr_utility.debug_enabled;
4:
5: TYPE t_time_recipient IS TABLE OF VARCHAR2 (1)
6: INDEX BY BINARY_INTEGER;
7:

Line 113: g_debug := hr_utility.debug_enabled;

109: l_session_id NUMBER;
110: l_tim_id NUMBER (15);
111: l_measure_count NUMBER;
112: BEGIN
113: g_debug := hr_utility.debug_enabled;
114: hr_kflex_utility.set_session_date (p_effective_date => SYSDATE,
115: p_session_id => l_session_id
116: );
117: -- Verify for each valid detail block if any of the detail blocks for the

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

135: --
136: IF g_debug
137: THEN
138: l_proc := 'hxt_hxc_retrieval_process.synchronize_deletes_in_otlr';
139: hr_utility.set_location (l_proc, 10);
140: hr_utility.TRACE
141: ('*********** NEW TIME BUILDING BLOCK ************');
142: END IF;
143:

Line 140: hr_utility.TRACE

136: IF g_debug
137: THEN
138: l_proc := 'hxt_hxc_retrieval_process.synchronize_deletes_in_otlr';
139: hr_utility.set_location (l_proc, 10);
140: hr_utility.TRACE
141: ('*********** NEW TIME BUILDING BLOCK ************');
142: END IF;
143:
144: --

Line 165: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));

161:
162: --
163: IF g_debug
164: THEN
165: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
166: hr_utility.TRACE ('Type is : ' || l_type);
167: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
168: hr_utility.TRACE ( 'l_start_time is '
169: || TO_CHAR (l_start_time,

Line 166: hr_utility.TRACE ('Type is : ' || l_type);

162: --
163: IF g_debug
164: THEN
165: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
166: hr_utility.TRACE ('Type is : ' || l_type);
167: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
168: hr_utility.TRACE ( 'l_start_time is '
169: || TO_CHAR (l_start_time,
170: 'DD-MON-YYYY HH:MI:SS')

Line 167: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));

163: IF g_debug
164: THEN
165: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
166: hr_utility.TRACE ('Type is : ' || l_type);
167: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
168: hr_utility.TRACE ( 'l_start_time is '
169: || TO_CHAR (l_start_time,
170: 'DD-MON-YYYY HH:MI:SS')
171: );

Line 168: hr_utility.TRACE ( 'l_start_time is '

164: THEN
165: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
166: hr_utility.TRACE ('Type is : ' || l_type);
167: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
168: hr_utility.TRACE ( 'l_start_time is '
169: || TO_CHAR (l_start_time,
170: 'DD-MON-YYYY HH:MI:SS')
171: );
172: hr_utility.TRACE ( 'l_stop_time is '

Line 172: hr_utility.TRACE ( 'l_stop_time is '

168: hr_utility.TRACE ( 'l_start_time is '
169: || TO_CHAR (l_start_time,
170: 'DD-MON-YYYY HH:MI:SS')
171: );
172: hr_utility.TRACE ( 'l_stop_time is '
173: || TO_CHAR (l_stop_time, 'DD-MON-YYYY HH:MI:SS')
174: );
175: hr_utility.TRACE ('l_scope is ' || l_scope);
176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));

Line 175: hr_utility.TRACE ('l_scope is ' || l_scope);

171: );
172: hr_utility.TRACE ( 'l_stop_time is '
173: || TO_CHAR (l_stop_time, 'DD-MON-YYYY HH:MI:SS')
174: );
175: hr_utility.TRACE ('l_scope is ' || l_scope);
176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));
177: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
178: --
179: hr_utility.TRACE ( 'UOM is : '

Line 176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));

172: hr_utility.TRACE ( 'l_stop_time is '
173: || TO_CHAR (l_stop_time, 'DD-MON-YYYY HH:MI:SS')
174: );
175: hr_utility.TRACE ('l_scope is ' || l_scope);
176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));
177: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
178: --
179: hr_utility.TRACE ( 'UOM is : '
180: || l_time_building_blocks (l_cnt).unit_of_measure

Line 177: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);

173: || TO_CHAR (l_stop_time, 'DD-MON-YYYY HH:MI:SS')
174: );
175: hr_utility.TRACE ('l_scope is ' || l_scope);
176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));
177: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
178: --
179: hr_utility.TRACE ( 'UOM is : '
180: || l_time_building_blocks (l_cnt).unit_of_measure
181: );

Line 179: hr_utility.TRACE ( 'UOM is : '

175: hr_utility.TRACE ('l_scope is ' || l_scope);
176: hr_utility.TRACE ('l_resource_id is ' || TO_CHAR (l_resource_id));
177: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
178: --
179: hr_utility.TRACE ( 'UOM is : '
180: || l_time_building_blocks (l_cnt).unit_of_measure
181: );
182: hr_utility.TRACE
183: ( 'Parent BB ID is : '

Line 182: hr_utility.TRACE

178: --
179: hr_utility.TRACE ( 'UOM is : '
180: || l_time_building_blocks (l_cnt).unit_of_measure
181: );
182: hr_utility.TRACE
183: ( 'Parent BB ID is : '
184: || TO_CHAR
185: (l_time_building_blocks (l_cnt).parent_building_block_id
186: )

Line 188: hr_utility.TRACE ( 'PARENT_IS_NEW is : '

184: || TO_CHAR
185: (l_time_building_blocks (l_cnt).parent_building_block_id
186: )
187: );
188: hr_utility.TRACE ( 'PARENT_IS_NEW is : '
189: || l_time_building_blocks (l_cnt).parent_is_new
190: );
191: hr_utility.TRACE
192: ( 'OVN is : '

Line 191: hr_utility.TRACE

187: );
188: hr_utility.TRACE ( 'PARENT_IS_NEW is : '
189: || l_time_building_blocks (l_cnt).parent_is_new
190: );
191: hr_utility.TRACE
192: ( 'OVN is : '
193: || TO_CHAR
194: (l_time_building_blocks (l_cnt).object_version_number
195: )

Line 197: hr_utility.TRACE ( 'APPROVAL_STATUS is : '

193: || TO_CHAR
194: (l_time_building_blocks (l_cnt).object_version_number
195: )
196: );
197: hr_utility.TRACE ( 'APPROVAL_STATUS is : '
198: || l_time_building_blocks (l_cnt).approval_status
199: );
200: hr_utility.TRACE
201: ( 'DATE_FROM is : '

Line 200: hr_utility.TRACE

196: );
197: hr_utility.TRACE ( 'APPROVAL_STATUS is : '
198: || l_time_building_blocks (l_cnt).approval_status
199: );
200: hr_utility.TRACE
201: ( 'DATE_FROM is : '
202: || TO_CHAR
203: (l_time_building_blocks (l_cnt).date_from,
204: 'DD-MON-YYYY'

Line 207: hr_utility.TRACE ( 'DATE_TO is : '

203: (l_time_building_blocks (l_cnt).date_from,
204: 'DD-MON-YYYY'
205: )
206: );
207: hr_utility.TRACE ( 'DATE_TO is : '
208: || TO_CHAR
209: (l_time_building_blocks (l_cnt).date_to,
210: 'DD-MON-YYYY'
211: )

Line 213: hr_utility.TRACE ('NEW is : '

209: (l_time_building_blocks (l_cnt).date_to,
210: 'DD-MON-YYYY'
211: )
212: );
213: hr_utility.TRACE ('NEW is : '
214: || l_time_building_blocks (l_cnt).NEW
215: );
216: --
217: hr_utility.set_location (l_proc, 20);

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

213: hr_utility.TRACE ('NEW is : '
214: || l_time_building_blocks (l_cnt).NEW
215: );
216: --
217: hr_utility.set_location (l_proc, 20);
218: END IF;
219:
220: --
221: IF ( ( (l_type = 'MEASURE' AND l_measure IS NOT NULL)

Line 265: hr_utility.set_location (l_proc, 50);

261: IF l_scope = 'DETAIL'
262: THEN
263: IF g_debug
264: THEN
265: hr_utility.set_location (l_proc, 50);
266: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);
267: hr_utility.TRACE ('l_parent_bb_ovn :' || l_parent_bb_ovn);
268: END IF;
269:

Line 266: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);

262: THEN
263: IF g_debug
264: THEN
265: hr_utility.set_location (l_proc, 50);
266: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);
267: hr_utility.TRACE ('l_parent_bb_ovn :' || l_parent_bb_ovn);
268: END IF;
269:
270: j := l_time_building_blocks.FIRST;

Line 267: hr_utility.TRACE ('l_parent_bb_ovn :' || l_parent_bb_ovn);

263: IF g_debug
264: THEN
265: hr_utility.set_location (l_proc, 50);
266: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);
267: hr_utility.TRACE ('l_parent_bb_ovn :' || l_parent_bb_ovn);
268: END IF;
269:
270: j := l_time_building_blocks.FIRST;
271:

Line 275: hr_utility.set_location (l_proc, 51);

271:
272: LOOP
273: IF g_debug
274: THEN
275: hr_utility.set_location (l_proc, 51);
276: END IF;
277:
278: EXIT WHEN NOT l_time_building_blocks.EXISTS (j);
279:

Line 282: hr_utility.set_location (l_proc, 52);

278: EXIT WHEN NOT l_time_building_blocks.EXISTS (j);
279:
280: IF g_debug
281: THEN
282: hr_utility.set_location (l_proc, 52);
283: END IF;
284:
285: --
286: l_check_bb_id :=

Line 293: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);

289: l_time_building_blocks (j).object_version_number;
290:
291: IF g_debug
292: THEN
293: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);
294: hr_utility.TRACE ('l_parent_bb_ovn:' || l_parent_bb_ovn);
295: END IF;
296:
297: IF l_check_bb_id = l_parent_bb_id

Line 294: hr_utility.TRACE ('l_parent_bb_ovn:' || l_parent_bb_ovn);

290:
291: IF g_debug
292: THEN
293: hr_utility.TRACE ('l_parent_bb_id :' || l_parent_bb_id);
294: hr_utility.TRACE ('l_parent_bb_ovn:' || l_parent_bb_ovn);
295: END IF;
296:
297: IF l_check_bb_id = l_parent_bb_id
298: AND l_check_bb_ovn = l_parent_bb_ovn

Line 302: hr_utility.set_location (l_proc, 53);

298: AND l_check_bb_ovn = l_parent_bb_ovn
299: THEN
300: IF g_debug
301: THEN
302: hr_utility.set_location (l_proc, 53);
303: END IF;
304:
305: l_parent_start_time :=
306: l_time_building_blocks (j).start_time;

Line 311: hr_utility.set_location (l_proc, 54);

307: EXIT;
308: ELSE
309: IF g_debug
310: THEN
311: hr_utility.set_location (l_proc, 54);
312: END IF;
313:
314: j := l_time_building_blocks.NEXT (j);
315: END IF;

Line 319: hr_utility.set_location (l_proc, 55);

315: END IF;
316:
317: IF g_debug
318: THEN
319: hr_utility.set_location (l_proc, 55);
320: END IF;
321: END LOOP;
322: ELSE
323: l_parent_start_time := l_start_time;

Line 332: hr_utility.TRACE ('l_parent_start_time:' || l_parent_start_time

328: where time_building_block_id = l_parent_bb_id
329: and object_version_number = l_parent_bb_ovn; */
330: IF g_debug
331: THEN
332: hr_utility.TRACE ('l_parent_start_time:' || l_parent_start_time
333: );
334: hr_utility.TRACE ('l_resource_id:' || l_resource_id);
335: END IF;
336:

Line 334: hr_utility.TRACE ('l_resource_id:' || l_resource_id);

330: IF g_debug
331: THEN
332: hr_utility.TRACE ('l_parent_start_time:' || l_parent_start_time
333: );
334: hr_utility.TRACE ('l_resource_id:' || l_resource_id);
335: END IF;
336:
337: -- Find out if any detail records(siblings) for this day
338: -- deleted or updated in OTL and not yet transferred to OTLR.

Line 349: hr_utility.TRACE ('l_day_bb_id:' || l_day_bb_id);

345: EXIT WHEN c_get_day_bb_id%NOTFOUND;
346:
347: IF g_debug
348: THEN
349: hr_utility.TRACE ('l_day_bb_id:' || l_day_bb_id);
350: END IF;
351:
352: -- If such records found in OTL, then find the corresponding
353: -- summary record in OTLR, so that the summary and detail rows in HXT

Line 357: hr_utility.set_location (l_proc, 60);

353: -- summary record in OTLR, so that the summary and detail rows in HXT
354: -- tables can also be deleted to reflect the latest changes in OTL.
355: IF g_debug
356: THEN
357: hr_utility.set_location (l_proc, 60);
358: END IF;
359:
360: l_tim_id := NULL;
361:

Line 369: hr_utility.set_location (l_proc, 70);

365: INTO l_time_summary_id, l_tim_id;
366:
367: IF g_debug
368: THEN
369: hr_utility.set_location (l_proc, 70);
370: hr_utility.TRACE ('l_time_summary_id:' || l_time_summary_id);
371: END IF;
372:
373: -- If corresponding summary record found then delete its details

Line 370: hr_utility.TRACE ('l_time_summary_id:' || l_time_summary_id);

366:
367: IF g_debug
368: THEN
369: hr_utility.set_location (l_proc, 70);
370: hr_utility.TRACE ('l_time_summary_id:' || l_time_summary_id);
371: END IF;
372:
373: -- If corresponding summary record found then delete its details
374: -- and the summary record itself from HXT tables.

Line 379: hr_utility.set_location (l_proc, 80);

375: IF c_get_sum_id%FOUND
376: THEN
377: IF g_debug
378: THEN
379: hr_utility.set_location (l_proc, 80);
380: END IF;
381:
382: hxt_td_util.retro_restrict_edit
383: (p_tim_id => l_tim_id,

Line 456: hr_utility.set_location (l_proc, 90);

452: WHERE parent_id = l_time_summary_id;
453:
454: IF g_debug
455: THEN
456: hr_utility.set_location (l_proc, 90);
457: END IF;
458:
459: --
460: -- Delete the summary row itself.

Line 467: hr_utility.set_location (l_proc, 100);

463: WHERE ID = l_time_summary_id;
464:
465: IF g_debug
466: THEN
467: hr_utility.set_location (l_proc, 100);
468: END IF;
469:
470: CLOSE c_get_sum_id;
471:

Line 480: hr_utility.set_location (l_proc, 110);

476: CLOSE c_get_sum_id;
477:
478: IF g_debug
479: THEN
480: hr_utility.set_location (l_proc, 110);
481: END IF;
482: END LOOP;
483:
484: IF g_debug

Line 486: hr_utility.set_location (l_proc, 110.5);

482: END LOOP;
483:
484: IF g_debug
485: THEN
486: hr_utility.set_location (l_proc, 110.5);
487: END IF;
488:
489: CLOSE c_get_day_bb_id;
490:

Line 493: hr_utility.set_location (l_proc, 120);

489: CLOSE c_get_day_bb_id;
490:
491: IF g_debug
492: THEN
493: hr_utility.set_location (l_proc, 120);
494: END IF;
495: END IF;
496:
497: IF g_debug

Line 499: hr_utility.set_location (l_proc, 130);

495: END IF;
496:
497: IF g_debug
498: THEN
499: hr_utility.set_location (l_proc, 130);
500: END IF;
501:
502: l_cnt := l_time_building_blocks.NEXT (l_cnt);
503: END LOOP;

Line 521: g_debug := hr_utility.debug_enabled;

517: l_attributes hxc_self_service_time_deposit.app_attributes_info;
518: l_messages hxc_self_service_time_deposit.message_table;
519: l_proc VARCHAR2 (100);
520: BEGIN
521: g_debug := hr_utility.debug_enabled;
522:
523: IF g_debug
524: THEN
525: l_proc := 'hxt_hxc_retrieval_process.OTM_VALIDATE_PROCESS';

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

522:
523: IF g_debug
524: THEN
525: l_proc := 'hxt_hxc_retrieval_process.OTM_VALIDATE_PROCESS';
526: hr_utility.set_location (l_proc, 10);
527: hr_utility.TRACE ( 'p_time_building_blocks is : '
528: || SUBSTR (p_time_building_blocks, 1, 2000)
529: );
530: END IF;

Line 527: hr_utility.TRACE ( 'p_time_building_blocks is : '

523: IF g_debug
524: THEN
525: l_proc := 'hxt_hxc_retrieval_process.OTM_VALIDATE_PROCESS';
526: hr_utility.set_location (l_proc, 10);
527: hr_utility.TRACE ( 'p_time_building_blocks is : '
528: || SUBSTR (p_time_building_blocks, 1, 2000)
529: );
530: END IF;
531:

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

534: (p_time_building_blocks);
535:
536: IF g_debug
537: THEN
538: hr_utility.set_location (l_proc, 30);
539: END IF;
540:
541: l_attributes :=
542: hxc_deposit_wrapper_utilities.string_to_attributes (p_time_attributes);

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

542: hxc_deposit_wrapper_utilities.string_to_attributes (p_time_attributes);
543:
544: IF g_debug
545: THEN
546: hr_utility.set_location (l_proc, 40);
547: END IF;
548:
549: l_messages :=
550: hxc_deposit_wrapper_utilities.string_to_messages (p_messages);

Line 656: g_debug := hr_utility.debug_enabled;

652: l_city_name hxt_sum_hours_worked_f.city_name%TYPE;
653: l_zip_code hxt_sum_hours_worked_f.zip_code%TYPE;
654: l_tim_id NUMBER;
655: BEGIN
656: g_debug := hr_utility.debug_enabled;
657:
658: IF g_debug
659: THEN
660: l_proc := 'hxt_hxc_retrieval_process.VALIDATE_TIMECARD';

Line 661: hr_utility.set_location (l_proc, 1);

657:
658: IF g_debug
659: THEN
660: l_proc := 'hxt_hxc_retrieval_process.VALIDATE_TIMECARD';
661: hr_utility.set_location (l_proc, 1);
662: END IF;
663:
664: OPEN get_debug;
665:

Line 673: hr_utility.set_location (l_proc, 3);

669: IF get_debug%FOUND
670: THEN
671: IF g_debug
672: THEN
673: hr_utility.set_location (l_proc, 3);
674: END IF;
675: END IF;
676:
677: CLOSE get_debug;

Line 686: hr_utility.set_location (l_proc, 4);

682: );
683:
684: IF g_debug
685: THEN
686: hr_utility.set_location (l_proc, 4);
687: END IF;
688:
689: SAVEPOINT otm_validate;
690:

Line 693: hr_utility.set_location (l_proc, 5);

689: SAVEPOINT otm_validate;
690:
691: IF g_debug
692: THEN
693: hr_utility.set_location (l_proc, 5);
694: END IF;
695:
696: -- Loop through all the building blocks and validate the details.
697: -------------------------------------------------------------------------------

Line 715: hr_utility.set_location (l_proc, 6);

711: FOR i IN 1 .. 3
712: LOOP
713: IF g_debug
714: THEN
715: hr_utility.set_location (l_proc, 6);
716: END IF;
717:
718: l_cnt := p_time_building_blocks.FIRST; --Added 2804510
719:

Line 722: hr_utility.TRACE ('l_cnt :' || l_cnt);

718: l_cnt := p_time_building_blocks.FIRST; --Added 2804510
719:
720: IF g_debug
721: THEN
722: hr_utility.TRACE ('l_cnt :' || l_cnt);
723: END IF;
724:
725: LOOP --Added 2804510
726: EXIT WHEN NOT p_time_building_blocks.EXISTS (l_cnt);

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

729:
730: --
731: IF g_debug
732: THEN
733: hr_utility.set_location (l_proc, 10);
734: hr_utility.TRACE
735: ('*********** NEW TIME BUILDING BLOCK ************');
736: END IF;
737:

Line 734: hr_utility.TRACE

730: --
731: IF g_debug
732: THEN
733: hr_utility.set_location (l_proc, 10);
734: hr_utility.TRACE
735: ('*********** NEW TIME BUILDING BLOCK ************');
736: END IF;
737:
738: --

Line 758: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));

754:
755: --
756: IF g_debug
757: THEN
758: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
759: hr_utility.TRACE ('Type is : ' || l_type);
760: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
761: hr_utility.TRACE ( 'l_start_time is '
762: || TO_CHAR (l_start_time,

Line 759: hr_utility.TRACE ('Type is : ' || l_type);

755: --
756: IF g_debug
757: THEN
758: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
759: hr_utility.TRACE ('Type is : ' || l_type);
760: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
761: hr_utility.TRACE ( 'l_start_time is '
762: || TO_CHAR (l_start_time,
763: 'DD-MON-YYYY HH:MI:SS'

Line 760: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));

756: IF g_debug
757: THEN
758: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
759: hr_utility.TRACE ('Type is : ' || l_type);
760: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
761: hr_utility.TRACE ( 'l_start_time is '
762: || TO_CHAR (l_start_time,
763: 'DD-MON-YYYY HH:MI:SS'
764: )

Line 761: hr_utility.TRACE ( 'l_start_time is '

757: THEN
758: hr_utility.TRACE ('Time BB ID is : ' || TO_CHAR (l_bb_id));
759: hr_utility.TRACE ('Type is : ' || l_type);
760: hr_utility.TRACE ('Measure is : ' || TO_CHAR (l_measure));
761: hr_utility.TRACE ( 'l_start_time is '
762: || TO_CHAR (l_start_time,
763: 'DD-MON-YYYY HH:MI:SS'
764: )
765: );

Line 766: hr_utility.TRACE ( 'l_stop_time is '

762: || TO_CHAR (l_start_time,
763: 'DD-MON-YYYY HH:MI:SS'
764: )
765: );
766: hr_utility.TRACE ( 'l_stop_time is '
767: || TO_CHAR (l_stop_time,
768: 'DD-MON-YYYY HH:MI:SS'
769: )
770: );

Line 771: hr_utility.TRACE ('l_scope is ' || l_scope);

767: || TO_CHAR (l_stop_time,
768: 'DD-MON-YYYY HH:MI:SS'
769: )
770: );
771: hr_utility.TRACE ('l_scope is ' || l_scope);
772: hr_utility.TRACE ('l_resource_id is '
773: || TO_CHAR (l_resource_id)
774: );
775: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);

Line 772: hr_utility.TRACE ('l_resource_id is '

768: 'DD-MON-YYYY HH:MI:SS'
769: )
770: );
771: hr_utility.TRACE ('l_scope is ' || l_scope);
772: hr_utility.TRACE ('l_resource_id is '
773: || TO_CHAR (l_resource_id)
774: );
775: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
776: --

Line 775: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);

771: hr_utility.TRACE ('l_scope is ' || l_scope);
772: hr_utility.TRACE ('l_resource_id is '
773: || TO_CHAR (l_resource_id)
774: );
775: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
776: --
777: hr_utility.TRACE ( 'UOM is : '
778: || p_time_building_blocks (l_cnt).unit_of_measure
779: );

Line 777: hr_utility.TRACE ( 'UOM is : '

773: || TO_CHAR (l_resource_id)
774: );
775: hr_utility.TRACE ('l_resource_type is ' || l_resource_type);
776: --
777: hr_utility.TRACE ( 'UOM is : '
778: || p_time_building_blocks (l_cnt).unit_of_measure
779: );
780: hr_utility.TRACE
781: ( 'Parent BB ID is : '

Line 780: hr_utility.TRACE

776: --
777: hr_utility.TRACE ( 'UOM is : '
778: || p_time_building_blocks (l_cnt).unit_of_measure
779: );
780: hr_utility.TRACE
781: ( 'Parent BB ID is : '
782: || TO_CHAR
783: (p_time_building_blocks (l_cnt).parent_building_block_id
784: )

Line 786: hr_utility.TRACE ( 'PARENT_IS_NEW is : '

782: || TO_CHAR
783: (p_time_building_blocks (l_cnt).parent_building_block_id
784: )
785: );
786: hr_utility.TRACE ( 'PARENT_IS_NEW is : '
787: || p_time_building_blocks (l_cnt).parent_is_new
788: );
789: hr_utility.TRACE
790: ( 'OVN is : '

Line 789: hr_utility.TRACE

785: );
786: hr_utility.TRACE ( 'PARENT_IS_NEW is : '
787: || p_time_building_blocks (l_cnt).parent_is_new
788: );
789: hr_utility.TRACE
790: ( 'OVN is : '
791: || TO_CHAR
792: (p_time_building_blocks (l_cnt).object_version_number
793: )

Line 795: hr_utility.TRACE ( 'APPROVAL_STATUS is : '

791: || TO_CHAR
792: (p_time_building_blocks (l_cnt).object_version_number
793: )
794: );
795: hr_utility.TRACE ( 'APPROVAL_STATUS is : '
796: || p_time_building_blocks (l_cnt).approval_status
797: );
798: hr_utility.TRACE
799: ( 'APPROVAL_STYLE_ID is : '

Line 798: hr_utility.TRACE

794: );
795: hr_utility.TRACE ( 'APPROVAL_STATUS is : '
796: || p_time_building_blocks (l_cnt).approval_status
797: );
798: hr_utility.TRACE
799: ( 'APPROVAL_STYLE_ID is : '
800: || TO_CHAR
801: (p_time_building_blocks (l_cnt).approval_style_id
802: )

Line 804: hr_utility.TRACE

800: || TO_CHAR
801: (p_time_building_blocks (l_cnt).approval_style_id
802: )
803: );
804: hr_utility.TRACE
805: ( 'DATE_FROM is : '
806: || TO_CHAR
807: (p_time_building_blocks (l_cnt).date_from,
808: 'DD-MON-YYYY'

Line 811: hr_utility.TRACE

807: (p_time_building_blocks (l_cnt).date_from,
808: 'DD-MON-YYYY'
809: )
810: );
811: hr_utility.TRACE
812: ( 'DATE_TO is : '
813: || TO_CHAR
814: (p_time_building_blocks (l_cnt).date_to,
815: 'DD-MON-YYYY'

Line 818: hr_utility.TRACE ( 'COMMENT_TEXT is : '

814: (p_time_building_blocks (l_cnt).date_to,
815: 'DD-MON-YYYY'
816: )
817: );
818: hr_utility.TRACE ( 'COMMENT_TEXT is : '
819: || p_time_building_blocks (l_cnt).comment_text
820: );
821: hr_utility.TRACE
822: ( 'Parent OVN is : '

Line 821: hr_utility.TRACE

817: );
818: hr_utility.TRACE ( 'COMMENT_TEXT is : '
819: || p_time_building_blocks (l_cnt).comment_text
820: );
821: hr_utility.TRACE
822: ( 'Parent OVN is : '
823: || TO_CHAR
824: (p_time_building_blocks (l_cnt).parent_building_block_ovn
825: )

Line 827: hr_utility.TRACE ( 'NEW is : '

823: || TO_CHAR
824: (p_time_building_blocks (l_cnt).parent_building_block_ovn
825: )
826: );
827: hr_utility.TRACE ( 'NEW is : '
828: || p_time_building_blocks (l_cnt).NEW
829: );
830: --
831: --

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

828: || p_time_building_blocks (l_cnt).NEW
829: );
830: --
831: --
832: hr_utility.set_location (l_proc, 20);
833: END IF;
834:
835: --Bug 2966729
836: --Description

Line 896: hr_utility.set_location (l_proc, 21);

892:
893: --
894: IF g_debug
895: THEN
896: hr_utility.set_location (l_proc, 21);
897: END IF;
898:
899: l_valid := 'Y';
900: ELSE

Line 903: hr_utility.set_location (l_proc, 22);

899: l_valid := 'Y';
900: ELSE
901: IF g_debug
902: THEN
903: hr_utility.set_location (l_proc, 22);
904: END IF;
905:
906: l_valid := 'N';
907: END IF;

Line 916: hr_utility.set_location (l_proc, 23);

912: IF l_valid = 'Y'
913: THEN
914: IF g_debug
915: THEN
916: hr_utility.set_location (l_proc, 23);
917: END IF;
918:
919: -- Get the start and stop times from the parent DAY block if DETAIL is
920: -- a measure.

Line 935: hr_utility.set_location (l_proc, 24);

931: ) -- end bug 3650967
932: THEN
933: IF g_debug
934: THEN
935: hr_utility.set_location (l_proc, 24);
936: END IF;
937:
938: l_day := p_time_building_blocks.FIRST; --Added 2804510
939:

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

942:
943: --Added 2804510
944: IF g_debug
945: THEN
946: hr_utility.set_location (l_proc, 30);
947: END IF;
948:
949: IF (p_time_building_blocks (l_day).time_building_block_id =
950: l_parent_bb_id

Line 956: hr_utility.set_location (l_proc, 31);

952: AND (p_time_building_blocks (l_day).SCOPE = 'DAY')
953: THEN
954: IF g_debug
955: THEN
956: hr_utility.set_location (l_proc, 31);
957: END IF;
958:
959: --
960: l_start_time :=

Line 969: hr_utility.TRACE ( 'l_start_time is '

965:
966: --
967: IF g_debug
968: THEN
969: hr_utility.TRACE ( 'l_start_time is '
970: || TO_CHAR
971: (l_start_time,
972: 'DD-MON-YYYY HH:MI:SS'
973: )

Line 975: hr_utility.TRACE ( 'l_stop_time is '

971: (l_start_time,
972: 'DD-MON-YYYY HH:MI:SS'
973: )
974: );
975: hr_utility.TRACE ( 'l_stop_time is '
976: || TO_CHAR
977: (l_stop_time,
978: 'DD-MON-YYYY HH:MI:SS'
979: )

Line 988: hr_utility.set_location (l_proc, 32);

984: END IF;
985:
986: IF g_debug
987: THEN
988: hr_utility.set_location (l_proc, 32);
989: END IF;
990:
991: l_day := p_time_building_blocks.NEXT (l_day);
992: --Added 2804510

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

993: END LOOP; --Added 2804510
994:
995: IF g_debug
996: THEN
997: hr_utility.set_location (l_proc, 33);
998: END IF;
999: END IF; -- l_type = MEASURE
1000:
1001: IF g_debug

Line 1003: hr_utility.set_location (l_proc, 34);

999: END IF; -- l_type = MEASURE
1000:
1001: IF g_debug
1002: THEN
1003: hr_utility.set_location (l_proc, 34);
1004: END IF;
1005:
1006: l_person_id := NULL;
1007:

Line 1012: hr_utility.set_location (l_proc, 35);

1008: IF l_resource_type = 'PERSON'
1009: THEN
1010: IF g_debug
1011: THEN
1012: hr_utility.set_location (l_proc, 35);
1013: END IF;
1014:
1015: l_person_id := l_resource_id;
1016:

Line 1019: hr_utility.TRACE ( 'l_person_id is '

1015: l_person_id := l_resource_id;
1016:
1017: IF g_debug
1018: THEN
1019: hr_utility.TRACE ( 'l_person_id is '
1020: || TO_CHAR (l_person_id)
1021: );
1022: END IF;
1023: END IF;

Line 1027: hr_utility.set_location (l_proc, 36);

1023: END IF;
1024:
1025: IF g_debug
1026: THEN
1027: hr_utility.set_location (l_proc, 36);
1028: END IF;
1029:
1030: l_effective_date := TRUNC (l_start_time);
1031:

Line 1034: hr_utility.TRACE ( 'l_effective_date is :'

1030: l_effective_date := TRUNC (l_start_time);
1031:
1032: IF g_debug
1033: THEN
1034: hr_utility.TRACE ( 'l_effective_date is :'
1035: || TO_CHAR (l_effective_date,
1036: 'DD-MON-YYYY'
1037: )
1038: );

Line 1044: hr_utility.set_location (l_proc, 37);

1040:
1041: BEGIN
1042: IF g_debug
1043: THEN
1044: hr_utility.set_location (l_proc, 37);
1045: END IF;
1046:
1047: SELECT full_name, business_group_id
1048: INTO hxt_otc_retrieval_interface.g_full_name, l_bg_id

Line 1058: hr_utility.set_location (l_proc, 38);

1054: WHEN NO_DATA_FOUND
1055: THEN
1056: IF g_debug
1057: THEN
1058: hr_utility.set_location (l_proc, 38);
1059: END IF;
1060:
1061: hxc_time_entry_rules_utils_pkg.add_error_to_table
1062: (p_message_table => p_messages,

Line 1083: hr_utility.set_location (l_proc, 39);

1079: -- l_person_id,
1080: -- l_effective_date);
1081: IF g_debug
1082: THEN
1083: hr_utility.set_location (l_proc, 39);
1084: END IF;
1085:
1086: hxt_otc_retrieval_interface.get_assignment_id
1087: (p_person_id => l_person_id,

Line 1096: hr_utility.set_location (l_proc, 50);

1092: );
1093:
1094: IF g_debug
1095: THEN
1096: hr_utility.set_location (l_proc, 50);
1097: END IF;
1098:
1099: l_field_name.DELETE;
1100: l_value.DELETE;

Line 1106: hr_utility.set_location (l_proc, 55);

1102: l_context.DELETE;
1103:
1104: IF g_debug
1105: THEN
1106: hr_utility.set_location (l_proc, 55);
1107: hr_utility.TRACE ( 'number of attr is : '
1108: || TO_CHAR (p_time_attributes.COUNT)
1109: );
1110: END IF;

Line 1107: hr_utility.TRACE ( 'number of attr is : '

1103:
1104: IF g_debug
1105: THEN
1106: hr_utility.set_location (l_proc, 55);
1107: hr_utility.TRACE ( 'number of attr is : '
1108: || TO_CHAR (p_time_attributes.COUNT)
1109: );
1110: END IF;
1111:

Line 1127: hr_utility.TRACE

1123: p_time_attributes (l_cnt_att).building_block_id
1124: THEN
1125: IF g_debug
1126: THEN
1127: hr_utility.TRACE
1128: ('------ In Attribute Loop ------');
1129: END IF;
1130:
1131: l_field_name (l_att) :=

Line 1136: hr_utility.TRACE ( 'l_field_name(l_att) is '

1132: p_time_attributes (l_cnt_att).attribute_name;
1133:
1134: IF g_debug
1135: THEN
1136: hr_utility.TRACE ( 'l_field_name(l_att) is '
1137: || l_field_name (l_att)
1138: );
1139: END IF;
1140:

Line 1146: hr_utility.TRACE ( 'l_value(l_att) is '

1142: p_time_attributes (l_cnt_att).attribute_value;
1143:
1144: IF g_debug
1145: THEN
1146: hr_utility.TRACE ( 'l_value(l_att) is '
1147: || l_value (l_att)
1148: );
1149: END IF;
1150:

Line 1156: hr_utility.TRACE ( 'l_context(l_att) is '

1152: p_time_attributes (l_cnt_att).bld_blk_info_type;
1153:
1154: IF g_debug
1155: THEN
1156: hr_utility.TRACE ( 'l_context(l_att) is '
1157: || l_context (l_att)
1158: );
1159: END IF;
1160:

Line 1166: hr_utility.TRACE ( 'l_category(l_att) is '

1162: p_time_attributes (l_cnt_att).CATEGORY;
1163:
1164: IF g_debug
1165: THEN
1166: hr_utility.TRACE ( 'l_category(l_att) is '
1167: || l_category (l_att)
1168: );
1169: END IF;
1170:

Line 1181: hr_utility.TRACE ('l_att is ' || TO_CHAR (l_att));

1177: END IF;
1178:
1179: IF g_debug
1180: THEN
1181: hr_utility.TRACE ('l_att is ' || TO_CHAR (l_att));
1182: hr_utility.set_location (l_proc, 60);
1183: END IF;
1184:
1185: hxt_otc_retrieval_interface.parse_attributes

Line 1182: hr_utility.set_location (l_proc, 60);

1178:
1179: IF g_debug
1180: THEN
1181: hr_utility.TRACE ('l_att is ' || TO_CHAR (l_att));
1182: hr_utility.set_location (l_proc, 60);
1183: END IF;
1184:
1185: hxt_otc_retrieval_interface.parse_attributes
1186: (p_category => l_category,

Line 1211: hr_utility.set_location (l_proc, 61);

1207: IF (l_no_times = 'Y')
1208: THEN
1209: IF g_debug
1210: THEN
1211: hr_utility.set_location (l_proc, 61);
1212: END IF;
1213:
1214: l_start_time := NULL;
1215: l_stop_time := NULL;

Line 1226: hr_utility.set_location (l_proc, 62);

1222: IF l_new = 'N'
1223: THEN
1224: IF g_debug
1225: THEN
1226: hr_utility.set_location (l_proc, 62);
1227: END IF;
1228:
1229: -- Bug 7415291
1230: -- Added new parameter l_tim_id

Line 1245: hr_utility.set_location (l_proc, 63);

1241: );
1242:
1243: IF g_debug
1244: THEN
1245: hr_utility.set_location (l_proc, 63);
1246: hr_utility.TRACE ('after find_existing_timecard');
1247: hr_utility.TRACE ( 'l_time_summary_id is: '
1248: || TO_CHAR (l_time_summary_id)
1249: );

Line 1246: hr_utility.TRACE ('after find_existing_timecard');

1242:
1243: IF g_debug
1244: THEN
1245: hr_utility.set_location (l_proc, 63);
1246: hr_utility.TRACE ('after find_existing_timecard');
1247: hr_utility.TRACE ( 'l_time_summary_id is: '
1248: || TO_CHAR (l_time_summary_id)
1249: );
1250: END IF;

Line 1247: hr_utility.TRACE ( 'l_time_summary_id is: '

1243: IF g_debug
1244: THEN
1245: hr_utility.set_location (l_proc, 63);
1246: hr_utility.TRACE ('after find_existing_timecard');
1247: hr_utility.TRACE ( 'l_time_summary_id is: '
1248: || TO_CHAR (l_time_summary_id)
1249: );
1250: END IF;
1251:

Line 1256: hr_utility.set_location (l_proc, 64);

1252: IF l_time_summary_id IS NOT NULL
1253: THEN
1254: IF g_debug
1255: THEN
1256: hr_utility.set_location (l_proc, 64);
1257: END IF;
1258:
1259: DELETE FROM hxt_det_hours_worked_f
1260: WHERE parent_id = l_time_summary_id;

Line 1279: hr_utility.set_location (l_proc, 65);

1275: --l_delete as a value to the parameter delete_yn of the record_time api.
1276: --Bug 2770487 Sonarasi Over
1277: IF g_debug
1278: THEN
1279: hr_utility.set_location (l_proc, 65);
1280: END IF;
1281:
1282: hxt_time_collection.record_time
1283: (timecard_source => 'Time Store',

Line 1359: hr_utility.set_location (l_proc, 66);

1355: );
1356:
1357: IF g_debug
1358: THEN
1359: hr_utility.set_location (l_proc, 66);
1360: END IF;
1361:
1362: IF g_otm_messages.COUNT > 0
1363: THEN

Line 1391: hr_utility.set_location (l_proc, 1000);

1387: IF l_otm_error IS NOT NULL
1388: THEN
1389: IF g_debug
1390: THEN
1391: hr_utility.set_location (l_proc, 1000);
1392: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1393: END IF;
1394:
1395: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 1392: hr_utility.TRACE ('l_otm_error :' || l_otm_error);

1388: THEN
1389: IF g_debug
1390: THEN
1391: hr_utility.set_location (l_proc, 1000);
1392: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1393: END IF;
1394:
1395: hxc_time_entry_rules_utils_pkg.add_error_to_table
1396: (p_message_table => p_messages,

Line 1419: hr_utility.set_location (l_proc, 1050);

1415: IF l_oracle_error IS NOT NULL
1416: THEN
1417: IF g_debug
1418: THEN
1419: hr_utility.set_location (l_proc, 1050);
1420: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
1421: );
1422: END IF;
1423:

Line 1420: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error

1416: THEN
1417: IF g_debug
1418: THEN
1419: hr_utility.set_location (l_proc, 1050);
1420: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
1421: );
1422: END IF;
1423:
1424: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 1477: hr_utility.TRACE ( 'TIM_SUM_ID IS : '

1473: IF (get_timecard_id%FOUND)
1474: THEN
1475: IF g_debug
1476: THEN
1477: hr_utility.TRACE ( 'TIM_SUM_ID IS : '
1478: || TO_CHAR (l_tim_sum_id_tab (l_tim_sum))
1479: );
1480: hr_utility.TRACE ( 'l_timecard_id is : '
1481: || TO_CHAR (l_timecard_id)

Line 1480: hr_utility.TRACE ( 'l_timecard_id is : '

1476: THEN
1477: hr_utility.TRACE ( 'TIM_SUM_ID IS : '
1478: || TO_CHAR (l_tim_sum_id_tab (l_tim_sum))
1479: );
1480: hr_utility.TRACE ( 'l_timecard_id is : '
1481: || TO_CHAR (l_timecard_id)
1482: );
1483: hr_utility.TRACE ( 'l_time_period_id is : '
1484: || TO_CHAR (l_time_period_id)

Line 1483: hr_utility.TRACE ( 'l_time_period_id is : '

1479: );
1480: hr_utility.TRACE ( 'l_timecard_id is : '
1481: || TO_CHAR (l_timecard_id)
1482: );
1483: hr_utility.TRACE ( 'l_time_period_id is : '
1484: || TO_CHAR (l_time_period_id)
1485: );
1486: END IF;
1487:

Line 1548: hr_utility.set_location (l_proc, 2000);

1544: IF l_otm_error IS NOT NULL
1545: THEN
1546: IF g_debug
1547: THEN
1548: hr_utility.set_location (l_proc, 2000);
1549: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1550: END IF;
1551:
1552: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 1549: hr_utility.TRACE ('l_otm_error :' || l_otm_error);

1545: THEN
1546: IF g_debug
1547: THEN
1548: hr_utility.set_location (l_proc, 2000);
1549: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
1550: END IF;
1551:
1552: hxc_time_entry_rules_utils_pkg.add_error_to_table
1553: (p_message_table => g_messages,

Line 1572: hr_utility.TRACE ( 'g_messages.message_name is : '

1568: );
1569:
1570: IF g_debug
1571: THEN
1572: hr_utility.TRACE ( 'g_messages.message_name is : '
1573: || g_messages (1).message_name
1574: );
1575: END IF;
1576:

Line 1584: hr_utility.set_location (l_proc, 2050);

1580: IF l_oracle_error IS NOT NULL
1581: THEN
1582: IF g_debug
1583: THEN
1584: hr_utility.set_location (l_proc, 2050);
1585: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
1586: END IF;
1587:
1588: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 1585: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);

1581: THEN
1582: IF g_debug
1583: THEN
1584: hr_utility.set_location (l_proc, 2050);
1585: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
1586: END IF;
1587:
1588: hxc_time_entry_rules_utils_pkg.add_error_to_table
1589: (p_message_table => g_messages,

Line 1604: hr_utility.TRACE ( 'g_messages.message_name is : '

1600: );
1601:
1602: IF g_debug
1603: THEN
1604: hr_utility.TRACE ( 'g_messages.message_name is : '
1605: || g_messages (1).message_name
1606: );
1607: END IF;
1608:

Line 1627: hr_utility.TRACE ('After RollBack');

1623: ROLLBACK TO otm_validate;
1624:
1625: IF g_debug
1626: THEN
1627: hr_utility.TRACE ('After RollBack');
1628: END IF;
1629: EXCEPTION
1630: WHEN e_error
1631: THEN

Line 1706: g_debug := hr_utility.debug_enabled;

1702: l_time_att_info hxc_self_service_time_deposit.app_attributes_info
1703: := p_time_att_info;
1704: l_proc VARCHAR2 (250);
1705: BEGIN
1706: g_debug := hr_utility.debug_enabled;
1707:
1708: IF (p_otm_explosion = 'Y')
1709: THEN
1710: -- Get the application set time recipients

Line 1778: hr_utility.TRACE ('p_operation:' || p_operation);

1774: -- skip this if we are SAVING
1775: IF g_debug
1776: THEN
1777: l_proc := 'hxt_hxc_retrieval_process.otlr_validation_required';
1778: hr_utility.TRACE ('p_operation:' || p_operation);
1779: END IF;
1780:
1781: SAVEPOINT rollback_validation;
1782: -- Bug 3321951 fix start.

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

1795:
1796: -- Bug 3321951 fix stop.
1797: IF g_debug
1798: THEN
1799: hr_utility.set_location (l_proc, 20);
1800: END IF;
1801:
1802: -- need to do OTM validation
1803: validate_timecard (p_operation => p_operation,

Line 1929: g_debug := hr_utility.debug_enabled;

1925: l_time_attributes hxc_self_service_time_deposit.app_attributes_info
1926: := p_time_attributes;
1927: l_tim_id NUMBER;
1928: BEGIN
1929: g_debug := hr_utility.debug_enabled;
1930:
1931: OPEN get_debug;
1932:
1933: FETCH get_debug

Line 1938: hr_utility.trace_on (NULL, 'OTLR');

1934: INTO l_debug;
1935:
1936: IF get_debug%FOUND
1937: THEN
1938: hr_utility.trace_on (NULL, 'OTLR');
1939: END IF;
1940:
1941: hxt_time_collection.set_cache (FALSE);
1942:

Line 1962: hr_utility.TRACE (' IN POPULATE DETAILS **');

1958:
1959: IF g_debug
1960: THEN
1961: l_proc := 'hxt_hxc_retrieval_process.otlr_review_details';
1962: hr_utility.TRACE ('******** IN POPULATE DETAILS **********');
1963: END IF;
1964:
1965: IF l_timecard_detail.COUNT > 0
1966: THEN

Line 2023: hr_utility.TRACE ('* FIND MIN BB ID **');

2019: l_min_bb_id := -1;
2020:
2021: IF g_debug
2022: THEN
2023: hr_utility.TRACE ('*********** FIND MIN BB ID ************');
2024: END IF;
2025:
2026: FOR l_cnt IN p_time_building_blocks.FIRST .. p_time_building_blocks.LAST
2027: LOOP

Line 2030: hr_utility.set_location (l_proc, 5);

2026: FOR l_cnt IN p_time_building_blocks.FIRST .. p_time_building_blocks.LAST
2027: LOOP
2028: IF g_debug
2029: THEN
2030: hr_utility.set_location (l_proc, 5);
2031: END IF;
2032:
2033: IF p_time_building_blocks (l_cnt).time_building_block_id <
2034: l_min_bb_id

Line 2043: hr_utility.TRACE ('MIN BB ID IS : ' || TO_CHAR (l_min_bb_id));

2039: END LOOP;
2040:
2041: IF g_debug
2042: THEN
2043: hr_utility.TRACE ('MIN BB ID IS : ' || TO_CHAR (l_min_bb_id));
2044: END IF;
2045:
2046: l_time_building_block_id := l_min_bb_id;
2047:

Line 2058: hr_utility.set_location (l_proc, 6);

2054: FOR i IN 1 .. 3
2055: LOOP
2056: IF g_debug
2057: THEN
2058: hr_utility.set_location (l_proc, 6);
2059: END IF;
2060:
2061: FOR l_cnt IN
2062: p_time_building_blocks.FIRST .. p_time_building_blocks.LAST

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

2062: p_time_building_blocks.FIRST .. p_time_building_blocks.LAST
2063: LOOP
2064: IF g_debug
2065: THEN
2066: hr_utility.set_location (l_proc, 10);
2067: hr_utility.TRACE
2068: ('*********** NEW TIME BUILDING BLOCK ************');
2069: END IF;
2070:

Line 2067: hr_utility.TRACE

2063: LOOP
2064: IF g_debug
2065: THEN
2066: hr_utility.set_location (l_proc, 10);
2067: hr_utility.TRACE
2068: ('*********** NEW TIME BUILDING BLOCK ************');
2069: END IF;
2070:
2071: l_bb_id := p_time_building_blocks (l_cnt).time_building_block_id;

Line 2097: hr_utility.TRACE ('Time Bld Blk ID is :' || TO_CHAR (l_bb_id)

2093: l_date_to := p_time_building_blocks (l_cnt).date_to;
2094:
2095: IF g_debug
2096: THEN
2097: hr_utility.TRACE ('Time Bld Blk ID is :' || TO_CHAR (l_bb_id)
2098: );
2099: hr_utility.TRACE ('Type is :' || l_type);
2100: hr_utility.TRACE ( 'Measure is :'
2101: || TO_CHAR (l_measure)

Line 2099: hr_utility.TRACE ('Type is :' || l_type);

2095: IF g_debug
2096: THEN
2097: hr_utility.TRACE ('Time Bld Blk ID is :' || TO_CHAR (l_bb_id)
2098: );
2099: hr_utility.TRACE ('Type is :' || l_type);
2100: hr_utility.TRACE ( 'Measure is :'
2101: || TO_CHAR (l_measure)
2102: );
2103: hr_utility.TRACE ( 'Start time is :'

Line 2100: hr_utility.TRACE ( 'Measure is :'

2096: THEN
2097: hr_utility.TRACE ('Time Bld Blk ID is :' || TO_CHAR (l_bb_id)
2098: );
2099: hr_utility.TRACE ('Type is :' || l_type);
2100: hr_utility.TRACE ( 'Measure is :'
2101: || TO_CHAR (l_measure)
2102: );
2103: hr_utility.TRACE ( 'Start time is :'
2104: || TO_CHAR (l_start_time,

Line 2103: hr_utility.TRACE ( 'Start time is :'

2099: hr_utility.TRACE ('Type is :' || l_type);
2100: hr_utility.TRACE ( 'Measure is :'
2101: || TO_CHAR (l_measure)
2102: );
2103: hr_utility.TRACE ( 'Start time is :'
2104: || TO_CHAR (l_start_time,
2105: 'DD-MON-YYYY HH:MI:SS'
2106: )
2107: );

Line 2108: hr_utility.TRACE ( 'Stop time is :'

2104: || TO_CHAR (l_start_time,
2105: 'DD-MON-YYYY HH:MI:SS'
2106: )
2107: );
2108: hr_utility.TRACE ( 'Stop time is :'
2109: || TO_CHAR (l_stop_time,
2110: 'DD-MON-YYYY HH:MI:SS'
2111: )
2112: );

Line 2113: hr_utility.TRACE ('Scope is :' || l_scope);

2109: || TO_CHAR (l_stop_time,
2110: 'DD-MON-YYYY HH:MI:SS'
2111: )
2112: );
2113: hr_utility.TRACE ('Scope is :' || l_scope);
2114: hr_utility.TRACE ( 'Resource id is :'
2115: || TO_CHAR (l_resource_id)
2116: );
2117: hr_utility.TRACE ('Resource type is :' || l_resource_type);

Line 2114: hr_utility.TRACE ( 'Resource id is :'

2110: 'DD-MON-YYYY HH:MI:SS'
2111: )
2112: );
2113: hr_utility.TRACE ('Scope is :' || l_scope);
2114: hr_utility.TRACE ( 'Resource id is :'
2115: || TO_CHAR (l_resource_id)
2116: );
2117: hr_utility.TRACE ('Resource type is :' || l_resource_type);
2118: --

Line 2117: hr_utility.TRACE ('Resource type is :' || l_resource_type);

2113: hr_utility.TRACE ('Scope is :' || l_scope);
2114: hr_utility.TRACE ( 'Resource id is :'
2115: || TO_CHAR (l_resource_id)
2116: );
2117: hr_utility.TRACE ('Resource type is :' || l_resource_type);
2118: --
2119: hr_utility.TRACE ( 'Unit of Measure is :'
2120: || p_time_building_blocks (l_cnt).unit_of_measure
2121: );

Line 2119: hr_utility.TRACE ( 'Unit of Measure is :'

2115: || TO_CHAR (l_resource_id)
2116: );
2117: hr_utility.TRACE ('Resource type is :' || l_resource_type);
2118: --
2119: hr_utility.TRACE ( 'Unit of Measure is :'
2120: || p_time_building_blocks (l_cnt).unit_of_measure
2121: );
2122: hr_utility.TRACE
2123: ( 'Parent Bld Blk ID is :'

Line 2122: hr_utility.TRACE

2118: --
2119: hr_utility.TRACE ( 'Unit of Measure is :'
2120: || p_time_building_blocks (l_cnt).unit_of_measure
2121: );
2122: hr_utility.TRACE
2123: ( 'Parent Bld Blk ID is :'
2124: || TO_CHAR
2125: (p_time_building_blocks (l_cnt).parent_building_block_id
2126: )

Line 2128: hr_utility.TRACE ( 'Parent is new ? :'

2124: || TO_CHAR
2125: (p_time_building_blocks (l_cnt).parent_building_block_id
2126: )
2127: );
2128: hr_utility.TRACE ( 'Parent is new ? :'
2129: || p_time_building_blocks (l_cnt).parent_is_new
2130: );
2131: hr_utility.TRACE
2132: ( 'OVN is :'

Line 2131: hr_utility.TRACE

2127: );
2128: hr_utility.TRACE ( 'Parent is new ? :'
2129: || p_time_building_blocks (l_cnt).parent_is_new
2130: );
2131: hr_utility.TRACE
2132: ( 'OVN is :'
2133: || TO_CHAR
2134: (p_time_building_blocks (l_cnt).object_version_number
2135: )

Line 2137: hr_utility.TRACE ( 'Approval Status is :'

2133: || TO_CHAR
2134: (p_time_building_blocks (l_cnt).object_version_number
2135: )
2136: );
2137: hr_utility.TRACE ( 'Approval Status is :'
2138: || p_time_building_blocks (l_cnt).approval_status
2139: );
2140: hr_utility.TRACE
2141: ( 'Approval Style ID is :'

Line 2140: hr_utility.TRACE

2136: );
2137: hr_utility.TRACE ( 'Approval Status is :'
2138: || p_time_building_blocks (l_cnt).approval_status
2139: );
2140: hr_utility.TRACE
2141: ( 'Approval Style ID is :'
2142: || TO_CHAR
2143: (p_time_building_blocks (l_cnt).approval_style_id
2144: )

Line 2146: hr_utility.TRACE

2142: || TO_CHAR
2143: (p_time_building_blocks (l_cnt).approval_style_id
2144: )
2145: );
2146: hr_utility.TRACE
2147: ( 'Date From is :'
2148: || TO_CHAR
2149: (p_time_building_blocks (l_cnt).date_from,
2150: 'DD-MON-YYYY'

Line 2153: hr_utility.TRACE

2149: (p_time_building_blocks (l_cnt).date_from,
2150: 'DD-MON-YYYY'
2151: )
2152: );
2153: hr_utility.TRACE
2154: ( 'Date To is :'
2155: || TO_CHAR
2156: (p_time_building_blocks (l_cnt).date_to,
2157: 'DD-MON-YYYY'

Line 2160: hr_utility.TRACE ( 'Comment Text is :'

2156: (p_time_building_blocks (l_cnt).date_to,
2157: 'DD-MON-YYYY'
2158: )
2159: );
2160: hr_utility.TRACE ( 'Comment Text is :'
2161: || p_time_building_blocks (l_cnt).comment_text
2162: );
2163: hr_utility.TRACE
2164: ( 'Parent OVN is :'

Line 2163: hr_utility.TRACE

2159: );
2160: hr_utility.TRACE ( 'Comment Text is :'
2161: || p_time_building_blocks (l_cnt).comment_text
2162: );
2163: hr_utility.TRACE
2164: ( 'Parent OVN is :'
2165: || TO_CHAR
2166: (p_time_building_blocks (l_cnt).parent_building_block_ovn
2167: )

Line 2169: hr_utility.TRACE ( 'NEW is :'

2165: || TO_CHAR
2166: (p_time_building_blocks (l_cnt).parent_building_block_ovn
2167: )
2168: );
2169: hr_utility.TRACE ( 'NEW is :'
2170: || p_time_building_blocks (l_cnt).NEW
2171: );
2172: --
2173: hr_utility.set_location (l_proc, 20);

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

2169: hr_utility.TRACE ( 'NEW is :'
2170: || p_time_building_blocks (l_cnt).NEW
2171: );
2172: --
2173: hr_utility.set_location (l_proc, 20);
2174: END IF;
2175:
2176: --Bug 2966729
2177: --Description

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

2255: p_time_building_blocks.FIRST .. p_time_building_blocks.LAST
2256: LOOP
2257: IF g_debug
2258: THEN
2259: hr_utility.set_location (l_proc, 30);
2260: END IF;
2261:
2262: IF (p_time_building_blocks (l_day).time_building_block_id =
2263: l_parent_bb_id

Line 2275: hr_utility.TRACE ( 'l_start_time is '

2271: l_no_times := 'Y';
2272:
2273: IF g_debug
2274: THEN
2275: hr_utility.TRACE ( 'l_start_time is '
2276: || TO_CHAR
2277: (l_start_time,
2278: 'DD-MON-YYYY HH:MI:SS'
2279: )

Line 2281: hr_utility.TRACE ( 'l_stop_time is '

2277: (l_start_time,
2278: 'DD-MON-YYYY HH:MI:SS'
2279: )
2280: );
2281: hr_utility.TRACE ( 'l_stop_time is '
2282: || TO_CHAR
2283: (l_stop_time,
2284: 'DD-MON-YYYY HH:MI:SS'
2285: )

Line 2302: hr_utility.TRACE ( 'l_person_id is '

2298: l_person_id := l_resource_id;
2299:
2300: IF g_debug
2301: THEN
2302: hr_utility.TRACE ( 'l_person_id is '
2303: || TO_CHAR (l_person_id)
2304: );
2305: END IF;
2306: END IF;

Line 2312: hr_utility.TRACE ( 'l_effective_date is :'

2308: l_effective_date := TRUNC (l_start_time);
2309:
2310: IF g_debug
2311: THEN
2312: hr_utility.TRACE ( 'l_effective_date is :'
2313: || TO_CHAR (l_effective_date,
2314: 'DD-MON-YYYY'
2315: )
2316: );

Line 2356: hr_utility.set_location (l_proc, 50);

2352: );
2353:
2354: IF g_debug
2355: THEN
2356: hr_utility.set_location (l_proc, 50);
2357: END IF;
2358:
2359: l_field_name.DELETE;
2360: l_value.DELETE;

Line 2366: hr_utility.set_location (l_proc, 55);

2362: l_context.DELETE;
2363:
2364: IF g_debug
2365: THEN
2366: hr_utility.set_location (l_proc, 55);
2367: hr_utility.TRACE ( 'number of attr is :'
2368: || TO_CHAR (p_time_attributes.COUNT)
2369: );
2370: hr_utility.set_location (l_proc, 56);

Line 2367: hr_utility.TRACE ( 'number of attr is :'

2363:
2364: IF g_debug
2365: THEN
2366: hr_utility.set_location (l_proc, 55);
2367: hr_utility.TRACE ( 'number of attr is :'
2368: || TO_CHAR (p_time_attributes.COUNT)
2369: );
2370: hr_utility.set_location (l_proc, 56);
2371: hr_utility.TRACE ('l_person_id :' || l_person_id);

Line 2370: hr_utility.set_location (l_proc, 56);

2366: hr_utility.set_location (l_proc, 55);
2367: hr_utility.TRACE ( 'number of attr is :'
2368: || TO_CHAR (p_time_attributes.COUNT)
2369: );
2370: hr_utility.set_location (l_proc, 56);
2371: hr_utility.TRACE ('l_person_id :' || l_person_id);
2372: END IF;
2373:
2374: --

Line 2371: hr_utility.TRACE ('l_person_id :' || l_person_id);

2367: hr_utility.TRACE ( 'number of attr is :'
2368: || TO_CHAR (p_time_attributes.COUNT)
2369: );
2370: hr_utility.set_location (l_proc, 56);
2371: hr_utility.TRACE ('l_person_id :' || l_person_id);
2372: END IF;
2373:
2374: --
2375: -- Get the attributes for this detail building block.

Line 2386: hr_utility.TRACE ('l_bb_id:' || l_bb_id);

2382: p_time_attributes.FIRST .. p_time_attributes.LAST
2383: LOOP
2384: IF g_debug
2385: THEN
2386: hr_utility.TRACE ('l_bb_id:' || l_bb_id);
2387: hr_utility.TRACE
2388: ( 'p_time_attributes'
2389: || (l_cnt_att)
2390: || '.building_block_id:'

Line 2387: hr_utility.TRACE

2383: LOOP
2384: IF g_debug
2385: THEN
2386: hr_utility.TRACE ('l_bb_id:' || l_bb_id);
2387: hr_utility.TRACE
2388: ( 'p_time_attributes'
2389: || (l_cnt_att)
2390: || '.building_block_id:'
2391: || p_time_attributes (l_cnt_att).building_block_id

Line 2400: hr_utility.TRACE

2396: p_time_attributes (l_cnt_att).building_block_id
2397: THEN
2398: IF g_debug
2399: THEN
2400: hr_utility.TRACE
2401: ('----------- In Attribute Loop ----------');
2402: END IF;
2403:
2404: l_field_name (l_att) :=

Line 2409: hr_utility.TRACE ( 'field name('

2405: p_time_attributes (l_cnt_att).attribute_name;
2406:
2407: IF g_debug
2408: THEN
2409: hr_utility.TRACE ( 'field name('
2410: || l_att
2411: || ') is :'
2412: || l_field_name (l_att)
2413: );

Line 2421: hr_utility.TRACE ( 'value('

2417: p_time_attributes (l_cnt_att).attribute_value;
2418:
2419: IF g_debug
2420: THEN
2421: hr_utility.TRACE ( 'value('
2422: || l_att
2423: || ') is : '
2424: || l_value (l_att)
2425: );

Line 2433: hr_utility.TRACE ( 'context('

2429: p_time_attributes (l_cnt_att).bld_blk_info_type;
2430:
2431: IF g_debug
2432: THEN
2433: hr_utility.TRACE ( 'context('
2434: || l_att
2435: || ') is :'
2436: || l_context (l_att)
2437: );

Line 2457: hr_utility.set_location (l_proc, 56.5);

2453: -- Start Bug 2930933
2454: --
2455: IF g_debug
2456: THEN
2457: hr_utility.set_location (l_proc, 56.5);
2458: END IF;
2459:
2460: IF l_field_name (l_att) = 'Dummy Element Context'
2461: AND l_context (l_att) = 'Dummy Element Context'

Line 2466: hr_utility.set_location (l_proc, 56.6);

2462: AND l_category (l_att) = 'ELEMENT'
2463: THEN
2464: IF g_debug
2465: THEN
2466: hr_utility.set_location (l_proc, 56.6);
2467: END IF;
2468:
2469: IF l_value (l_att) IS NOT NULL
2470: THEN

Line 2473: hr_utility.set_location (l_proc, 57);

2469: IF l_value (l_att) IS NOT NULL
2470: THEN
2471: IF g_debug
2472: THEN
2473: hr_utility.set_location (l_proc, 57);
2474: END IF;
2475:
2476: l_hrstype_entered := 'Y';
2477: ELSE

Line 2480: hr_utility.set_location (l_proc, 58);

2476: l_hrstype_entered := 'Y';
2477: ELSE
2478: IF g_debug
2479: THEN
2480: hr_utility.set_location (l_proc, 58);
2481: END IF;
2482:
2483: l_hrstype_entered := 'N';
2484: END IF;

Line 2488: hr_utility.set_location (l_proc, 58.5);

2484: END IF;
2485:
2486: IF g_debug
2487: THEN
2488: hr_utility.set_location (l_proc, 58.5);
2489: END IF;
2490: END IF;
2491:
2492: IF g_debug

Line 2494: hr_utility.set_location (l_proc, 59);

2490: END IF;
2491:
2492: IF g_debug
2493: THEN
2494: hr_utility.set_location (l_proc, 59);
2495: END IF;
2496:
2497: -- End Bug 2930933
2498: l_att := l_att + 1;

Line 2508: hr_utility.TRACE ('l_att is: ' || TO_CHAR (l_att));

2504: END IF;
2505:
2506: IF g_debug
2507: THEN
2508: hr_utility.TRACE ('l_att is: ' || TO_CHAR (l_att));
2509: END IF;
2510:
2511: -- Bug 2930933
2512: IF g_debug

Line 2514: hr_utility.TRACE ( 'l_hrstype_entered :'

2510:
2511: -- Bug 2930933
2512: IF g_debug
2513: THEN
2514: hr_utility.TRACE ( 'l_hrstype_entered :'
2515: || l_hrstype_entered
2516: );
2517: hr_utility.set_location (l_proc, 60);
2518: END IF;

Line 2517: hr_utility.set_location (l_proc, 60);

2513: THEN
2514: hr_utility.TRACE ( 'l_hrstype_entered :'
2515: || l_hrstype_entered
2516: );
2517: hr_utility.set_location (l_proc, 60);
2518: END IF;
2519:
2520: IF l_hrstype_entered = 'N' AND i <> 1 -- Check for Bug 4548871
2521: THEN

Line 2524: hr_utility.set_location (l_proc, 61);

2520: IF l_hrstype_entered = 'N' AND i <> 1 -- Check for Bug 4548871
2521: THEN
2522: IF g_debug
2523: THEN
2524: hr_utility.set_location (l_proc, 61);
2525: END IF;
2526:
2527: -- Raise an error
2528: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 2547: hr_utility.set_location (l_proc, 62);

2543: END IF;
2544:
2545: IF g_debug
2546: THEN
2547: hr_utility.set_location (l_proc, 62);
2548: END IF;
2549:
2550: hxt_otc_retrieval_interface.parse_attributes
2551: (p_category => l_category,

Line 2574: hr_utility.set_location (l_proc, 63);

2570: );
2571:
2572: IF g_debug
2573: THEN
2574: hr_utility.set_location (l_proc, 63);
2575: END IF;
2576:
2577: --
2578: -- Pass in Person ID for employee number - issue with going

Line 2586: hr_utility.set_location (l_proc, 64);

2582: IF (l_no_times = 'Y')
2583: THEN
2584: IF g_debug
2585: THEN
2586: hr_utility.set_location (l_proc, 64);
2587: END IF;
2588:
2589: l_start_time := NULL;
2590: l_stop_time := NULL;

Line 2595: hr_utility.set_location (l_proc, 65);

2591: END IF;
2592:
2593: IF g_debug
2594: THEN
2595: hr_utility.set_location (l_proc, 65);
2596: END IF;
2597:
2598: l_time_summary_id := NULL;
2599: l_time_sum_start_date := NULL;

Line 2606: hr_utility.set_location (l_proc, 66);

2602: IF l_new = 'N'
2603: THEN
2604: IF g_debug
2605: THEN
2606: hr_utility.set_location (l_proc, 66);
2607: END IF;
2608:
2609: -- Bug 7415291
2610: -- Added new parameter l_tim_id

Line 2625: hr_utility.TRACE ('after find_existing_timecard');

2621: );
2622:
2623: IF g_debug
2624: THEN
2625: hr_utility.TRACE ('after find_existing_timecard');
2626: hr_utility.TRACE ( 'l_time_summary_id is: '
2627: || TO_CHAR (l_time_summary_id)
2628: );
2629: END IF;

Line 2626: hr_utility.TRACE ( 'l_time_summary_id is: '

2622:
2623: IF g_debug
2624: THEN
2625: hr_utility.TRACE ('after find_existing_timecard');
2626: hr_utility.TRACE ( 'l_time_summary_id is: '
2627: || TO_CHAR (l_time_summary_id)
2628: );
2629: END IF;
2630:

Line 2635: hr_utility.set_location (l_proc, 67);

2631: IF l_time_summary_id IS NOT NULL
2632: THEN
2633: IF g_debug
2634: THEN
2635: hr_utility.set_location (l_proc, 67);
2636: END IF;
2637:
2638: DELETE FROM hxt_det_hours_worked_f
2639: WHERE parent_id = l_time_summary_id;

Line 2644: hr_utility.set_location (l_proc, 68);

2640: END IF;
2641:
2642: IF g_debug
2643: THEN
2644: hr_utility.set_location (l_proc, 68);
2645: END IF;
2646: END IF;
2647:
2648: IF g_debug

Line 2650: hr_utility.set_location (l_proc, 69);

2646: END IF;
2647:
2648: IF g_debug
2649: THEN
2650: hr_utility.set_location (l_proc, 69);
2651: END IF;
2652:
2653: --Bug 2770487 Sonarasi 04-Apr-2003
2654: IF (l_date_to = hr_general.end_of_time)

Line 2658: hr_utility.set_location (l_proc, 70);

2654: IF (l_date_to = hr_general.end_of_time)
2655: THEN
2656: IF g_debug
2657: THEN
2658: hr_utility.set_location (l_proc, 70);
2659: END IF;
2660:
2661: l_delete := 'N';
2662: ELSE

Line 2665: hr_utility.set_location (l_proc, 71);

2661: l_delete := 'N';
2662: ELSE
2663: IF g_debug
2664: THEN
2665: hr_utility.set_location (l_proc, 71);
2666: END IF;
2667:
2668: l_delete := 'Y';
2669: END IF;

Line 2673: hr_utility.set_location (l_proc, 72);

2669: END IF;
2670:
2671: IF g_debug
2672: THEN
2673: hr_utility.set_location (l_proc, 72);
2674: END IF;
2675:
2676: --Here We are setting the delete flag based on whether we would like to
2677: --delete the blocks or retail them.Therefore those blocks which are end

Line 2758: hr_utility.set_location (l_proc, 73);

2754: );
2755:
2756: IF g_debug
2757: THEN
2758: hr_utility.set_location (l_proc, 73);
2759: END IF;
2760:
2761: IF g_otm_messages.COUNT > 0
2762: THEN

Line 2790: hr_utility.set_location (l_proc, 74);

2786: IF l_otm_error IS NOT NULL
2787: THEN
2788: IF g_debug
2789: THEN
2790: hr_utility.set_location (l_proc, 74);
2791: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
2792: END IF;
2793:
2794: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 2791: hr_utility.TRACE ('l_otm_error :' || l_otm_error);

2787: THEN
2788: IF g_debug
2789: THEN
2790: hr_utility.set_location (l_proc, 74);
2791: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
2792: END IF;
2793:
2794: hxc_time_entry_rules_utils_pkg.add_error_to_table
2795: (p_message_table => g_messages,

Line 2814: hr_utility.TRACE ( 'g_messages.message_name is : '

2810: );
2811:
2812: IF g_debug
2813: THEN
2814: hr_utility.TRACE ( 'g_messages.message_name is : '
2815: || g_messages (1).message_name
2816: );
2817: hr_utility.set_location (l_proc, 75);
2818: END IF;

Line 2817: hr_utility.set_location (l_proc, 75);

2813: THEN
2814: hr_utility.TRACE ( 'g_messages.message_name is : '
2815: || g_messages (1).message_name
2816: );
2817: hr_utility.set_location (l_proc, 75);
2818: END IF;
2819:
2820: -- Bug 3012684
2821: l_error_flag := 'Y';

Line 2827: hr_utility.set_location (l_proc, 76);

2823: END IF;
2824:
2825: IF g_debug
2826: THEN
2827: hr_utility.set_location (l_proc, 76);
2828: END IF;
2829:
2830: IF l_oracle_error IS NOT NULL
2831: THEN

Line 2834: hr_utility.set_location (l_proc, 77);

2830: IF l_oracle_error IS NOT NULL
2831: THEN
2832: IF g_debug
2833: THEN
2834: hr_utility.set_location (l_proc, 77);
2835: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
2836: );
2837: END IF;
2838:

Line 2835: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error

2831: THEN
2832: IF g_debug
2833: THEN
2834: hr_utility.set_location (l_proc, 77);
2835: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error
2836: );
2837: END IF;
2838:
2839: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 2855: hr_utility.TRACE ( 'g_messages.message_name is : '

2851: );
2852:
2853: IF g_debug
2854: THEN
2855: hr_utility.TRACE ( 'g_messages.message_name is : '
2856: || g_messages (1).message_name
2857: );
2858: hr_utility.set_location (l_proc, 78);
2859: END IF;

Line 2858: hr_utility.set_location (l_proc, 78);

2854: THEN
2855: hr_utility.TRACE ( 'g_messages.message_name is : '
2856: || g_messages (1).message_name
2857: );
2858: hr_utility.set_location (l_proc, 78);
2859: END IF;
2860:
2861: -- Bug 3012684
2862: l_error_flag := 'Y';

Line 2869: hr_utility.set_location (l_proc, 79);

2865: END IF;
2866:
2867: IF g_debug
2868: THEN
2869: hr_utility.set_location (l_proc, 79);
2870: END IF;
2871:
2872: l_next_index := l_timecard_detail.COUNT + 1;
2873: l_time_building_block_id := l_time_building_block_id - 1;

Line 2916: hr_utility.set_location (l_proc, 80);

2912: --
2913: -- p_time_building_blocks.delete(l_cnt);
2914: IF g_debug
2915: THEN
2916: hr_utility.set_location (l_proc, 80);
2917: END IF;
2918: END IF; -- l_valid = Y
2919:
2920: IF g_debug

Line 2922: hr_utility.set_location (l_proc, 81);

2918: END IF; -- l_valid = Y
2919:
2920: IF g_debug
2921: THEN
2922: hr_utility.set_location (l_proc, 81);
2923: END IF;
2924:
2925: l_hrstype_entered := 'N';
2926:

Line 2929: hr_utility.TRACE ('l_hrstype_entered :' || l_hrstype_entered);

2925: l_hrstype_entered := 'N';
2926:
2927: IF g_debug
2928: THEN
2929: hr_utility.TRACE ('l_hrstype_entered :' || l_hrstype_entered);
2930: hr_utility.set_location (l_proc, 81);
2931: END IF;
2932: END LOOP;
2933: END LOOP;

Line 2930: hr_utility.set_location (l_proc, 81);

2926:
2927: IF g_debug
2928: THEN
2929: hr_utility.TRACE ('l_hrstype_entered :' || l_hrstype_entered);
2930: hr_utility.set_location (l_proc, 81);
2931: END IF;
2932: END LOOP;
2933: END LOOP;
2934:

Line 2969: hr_utility.TRACE ( 'TIM_SUM_ID IS : '

2965: IF (get_timecard_id%FOUND)
2966: THEN
2967: IF g_debug
2968: THEN
2969: hr_utility.TRACE ( 'TIM_SUM_ID IS : '
2970: || TO_CHAR (l_tim_sum_id_tab (l_tim_sum))
2971: );
2972: hr_utility.TRACE ( 'l_timecard_id is : '
2973: || TO_CHAR (l_timecard_id)

Line 2972: hr_utility.TRACE ( 'l_timecard_id is : '

2968: THEN
2969: hr_utility.TRACE ( 'TIM_SUM_ID IS : '
2970: || TO_CHAR (l_tim_sum_id_tab (l_tim_sum))
2971: );
2972: hr_utility.TRACE ( 'l_timecard_id is : '
2973: || TO_CHAR (l_timecard_id)
2974: );
2975: hr_utility.TRACE ( 'l_time_period_id is : '
2976: || TO_CHAR (l_time_period_id)

Line 2975: hr_utility.TRACE ( 'l_time_period_id is : '

2971: );
2972: hr_utility.TRACE ( 'l_timecard_id is : '
2973: || TO_CHAR (l_timecard_id)
2974: );
2975: hr_utility.TRACE ( 'l_time_period_id is : '
2976: || TO_CHAR (l_time_period_id)
2977: );
2978: END IF;
2979:

Line 3040: hr_utility.set_location (l_proc, 2000);

3036: IF l_otm_error IS NOT NULL
3037: THEN
3038: IF g_debug
3039: THEN
3040: hr_utility.set_location (l_proc, 2000);
3041: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
3042: END IF;
3043:
3044: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 3041: hr_utility.TRACE ('l_otm_error :' || l_otm_error);

3037: THEN
3038: IF g_debug
3039: THEN
3040: hr_utility.set_location (l_proc, 2000);
3041: hr_utility.TRACE ('l_otm_error :' || l_otm_error);
3042: END IF;
3043:
3044: hxc_time_entry_rules_utils_pkg.add_error_to_table
3045: (p_message_table => g_messages,

Line 3064: hr_utility.TRACE ( 'g_messages.message_name is : '

3060: );
3061:
3062: IF g_debug
3063: THEN
3064: hr_utility.TRACE ( 'g_messages.message_name is : '
3065: || g_messages (1).message_name
3066: );
3067: END IF;
3068:

Line 3076: hr_utility.set_location (l_proc, 2050);

3072: IF l_oracle_error IS NOT NULL
3073: THEN
3074: IF g_debug
3075: THEN
3076: hr_utility.set_location (l_proc, 2050);
3077: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
3078: END IF;
3079:
3080: hxc_time_entry_rules_utils_pkg.add_error_to_table

Line 3077: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);

3073: THEN
3074: IF g_debug
3075: THEN
3076: hr_utility.set_location (l_proc, 2050);
3077: hr_utility.TRACE ('l_oracle_error :' || l_oracle_error);
3078: END IF;
3079:
3080: hxc_time_entry_rules_utils_pkg.add_error_to_table
3081: (p_message_table => g_messages,

Line 3096: hr_utility.TRACE ( 'g_messages.message_name is : '

3092: );
3093:
3094: IF g_debug
3095: THEN
3096: hr_utility.TRACE ( 'g_messages.message_name is : '
3097: || g_messages (1).message_name
3098: );
3099: END IF;
3100:

Line 3107: hr_utility.set_location (l_proc, 2055);

3103: END IF;
3104:
3105: IF g_debug
3106: THEN
3107: hr_utility.set_location (l_proc, 2055);
3108: END IF;
3109:
3110: i := l_timecards.NEXT (i);
3111:

Line 3116: hr_utility.set_location (l_proc, 2060);

3112: IF i IS NULL
3113: THEN
3114: IF g_debug
3115: THEN
3116: hr_utility.set_location (l_proc, 2060);
3117: END IF;
3118:
3119: loop_ok := FALSE;
3120: END IF;

Line 3124: hr_utility.set_location (l_proc, 2065);

3120: END IF;
3121:
3122: IF g_debug
3123: THEN
3124: hr_utility.set_location (l_proc, 2065);
3125: END IF;
3126: END LOOP;
3127:
3128: IF g_debug

Line 3130: hr_utility.set_location (l_proc, 2070);

3126: END LOOP;
3127:
3128: IF g_debug
3129: THEN
3130: hr_utility.set_location (l_proc, 2070);
3131: END IF;
3132: END IF;
3133:
3134: IF g_debug

Line 3136: hr_utility.set_location (l_proc, 2075);

3132: END IF;
3133:
3134: IF g_debug
3135: THEN
3136: hr_utility.set_location (l_proc, 2075);
3137: END IF;
3138:
3139: l_next_index := 0;
3140: l_tim_sum := l_tim_sum_id_tab.FIRST;

Line 3155: hr_utility.set_location (l_proc, 2080);

3151: IF l_tim_sum_id_tab (l_tim_sum) IS NOT NULL
3152: THEN
3153: IF g_debug
3154: THEN
3155: hr_utility.set_location (l_proc, 2080);
3156: END IF;
3157:
3158: l_master_index := l_tim_sum;
3159: l_num_rec := 0;

Line 3163: hr_utility.TRACE ( 'TIM_SUM_ID IS : '

3159: l_num_rec := 0;
3160:
3161: IF g_debug
3162: THEN
3163: hr_utility.TRACE ( 'TIM_SUM_ID IS : '
3164: || TO_CHAR (l_tim_sum_id_tab (l_tim_sum))
3165: );
3166: END IF;
3167:

Line 3174: -- hr_utility.trace('l_det_cnt IS : ' || to_char(l_det_cnt));

3170: -- into l_det_cnt
3171: -- from hxt_det_hours_worked_f
3172: -- where parent_id = l_tim_sum_id_tab(l_tim_sum);
3173: --if g_debug then
3174: -- hr_utility.trace('l_det_cnt IS : ' || to_char(l_det_cnt));
3175: --end if;
3176: --
3177: OPEN get_otm_records (p_tim_sum_id => l_tim_sum_id_tab
3178: (l_tim_sum));

Line 3183: hr_utility.set_location (l_proc, 2085);

3179:
3180: LOOP
3181: IF g_debug
3182: THEN
3183: hr_utility.set_location (l_proc, 2085);
3184: END IF;
3185:
3186: FETCH get_otm_records
3187: INTO detail_date_worked, detail_hours, detail_time_in,

Line 3192: hr_utility.TRACE ( 'detail_date_worked :'

3188: detail_time_out, detail_hours_type;
3189:
3190: IF g_debug
3191: THEN
3192: hr_utility.TRACE ( 'detail_date_worked :'
3193: || detail_date_worked
3194: );
3195: hr_utility.TRACE ('detail_hours :' || detail_hours);
3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);

Line 3195: hr_utility.TRACE ('detail_hours :' || detail_hours);

3191: THEN
3192: hr_utility.TRACE ( 'detail_date_worked :'
3193: || detail_date_worked
3194: );
3195: hr_utility.TRACE ('detail_hours :' || detail_hours);
3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);
3197: hr_utility.TRACE ('detail_time_out :' || detail_time_out);
3198: hr_utility.TRACE ('detail_hours_type :'
3199: || detail_hours_type

Line 3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);

3192: hr_utility.TRACE ( 'detail_date_worked :'
3193: || detail_date_worked
3194: );
3195: hr_utility.TRACE ('detail_hours :' || detail_hours);
3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);
3197: hr_utility.TRACE ('detail_time_out :' || detail_time_out);
3198: hr_utility.TRACE ('detail_hours_type :'
3199: || detail_hours_type
3200: );

Line 3197: hr_utility.TRACE ('detail_time_out :' || detail_time_out);

3193: || detail_date_worked
3194: );
3195: hr_utility.TRACE ('detail_hours :' || detail_hours);
3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);
3197: hr_utility.TRACE ('detail_time_out :' || detail_time_out);
3198: hr_utility.TRACE ('detail_hours_type :'
3199: || detail_hours_type
3200: );
3201: END IF;

Line 3198: hr_utility.TRACE ('detail_hours_type :'

3194: );
3195: hr_utility.TRACE ('detail_hours :' || detail_hours);
3196: hr_utility.TRACE ('detail_time_in :' || detail_time_in);
3197: hr_utility.TRACE ('detail_time_out :' || detail_time_out);
3198: hr_utility.TRACE ('detail_hours_type :'
3199: || detail_hours_type
3200: );
3201: END IF;
3202:

Line 3208: hr_utility.set_location (l_proc, 2085);

3204:
3205: --
3206: IF g_debug
3207: THEN
3208: hr_utility.set_location (l_proc, 2085);
3209: END IF;
3210:
3211: l_num_rec := l_num_rec + 1;
3212:

Line 3215: hr_utility.TRACE ('l_num_rec :' || l_num_rec);

3211: l_num_rec := l_num_rec + 1;
3212:
3213: IF g_debug
3214: THEN
3215: hr_utility.TRACE ('l_num_rec :' || l_num_rec);
3216: hr_utility.TRACE ( 'detail_date_worked is : '
3217: || TO_CHAR (detail_date_worked,
3218: 'DD-MON-YYYY HH:MI:SS'
3219: )

Line 3216: hr_utility.TRACE ( 'detail_date_worked is : '

3212:
3213: IF g_debug
3214: THEN
3215: hr_utility.TRACE ('l_num_rec :' || l_num_rec);
3216: hr_utility.TRACE ( 'detail_date_worked is : '
3217: || TO_CHAR (detail_date_worked,
3218: 'DD-MON-YYYY HH:MI:SS'
3219: )
3220: );

Line 3221: hr_utility.TRACE ( 'detail_hours is : '

3217: || TO_CHAR (detail_date_worked,
3218: 'DD-MON-YYYY HH:MI:SS'
3219: )
3220: );
3221: hr_utility.TRACE ( 'detail_hours is : '
3222: || TO_CHAR (detail_hours)
3223: );
3224: hr_utility.TRACE ( 'detail_time_in is : '
3225: || TO_CHAR (detail_time_in,

Line 3224: hr_utility.TRACE ( 'detail_time_in is : '

3220: );
3221: hr_utility.TRACE ( 'detail_hours is : '
3222: || TO_CHAR (detail_hours)
3223: );
3224: hr_utility.TRACE ( 'detail_time_in is : '
3225: || TO_CHAR (detail_time_in,
3226: 'DD-MON-YYYY HH:MI:SS'
3227: )
3228: );

Line 3229: hr_utility.TRACE ( 'detail_time_out is : '

3225: || TO_CHAR (detail_time_in,
3226: 'DD-MON-YYYY HH:MI:SS'
3227: )
3228: );
3229: hr_utility.TRACE ( 'detail_time_out is : '
3230: || TO_CHAR (detail_time_out,
3231: 'DD-MON-YYYY HH:MI:SS'
3232: )
3233: );

Line 3234: hr_utility.TRACE ( 'detail_hours_type : '

3230: || TO_CHAR (detail_time_out,
3231: 'DD-MON-YYYY HH:MI:SS'
3232: )
3233: );
3234: hr_utility.TRACE ( 'detail_hours_type : '
3235: || TO_CHAR (detail_hours_type)
3236: );
3237: END IF;
3238:

Line 3244: hr_utility.set_location (l_proc, 2090);

3240: THEN
3241: --
3242: IF g_debug
3243: THEN
3244: hr_utility.set_location (l_proc, 2090);
3245: hr_utility.TRACE ('l_num_rec is 1');
3246: END IF;
3247:
3248: --

Line 3245: hr_utility.TRACE ('l_num_rec is 1');

3241: --
3242: IF g_debug
3243: THEN
3244: hr_utility.set_location (l_proc, 2090);
3245: hr_utility.TRACE ('l_num_rec is 1');
3246: END IF;
3247:
3248: --
3249: l_next_index := l_tim_sum;

Line 3253: hr_utility.TRACE ('l_next_index :' || l_next_index);

3249: l_next_index := l_tim_sum;
3250:
3251: IF g_debug
3252: THEN
3253: hr_utility.TRACE ('l_next_index :' || l_next_index);
3254: END IF;
3255: ELSE
3256: IF g_debug
3257: THEN

Line 3258: hr_utility.set_location (l_proc, 2095);

3254: END IF;
3255: ELSE
3256: IF g_debug
3257: THEN
3258: hr_utility.set_location (l_proc, 2095);
3259: hr_utility.TRACE ('l_num_rec is NOT 1');
3260: END IF;
3261:
3262: l_next_index := l_timecard_detail.COUNT + 1;

Line 3259: hr_utility.TRACE ('l_num_rec is NOT 1');

3255: ELSE
3256: IF g_debug
3257: THEN
3258: hr_utility.set_location (l_proc, 2095);
3259: hr_utility.TRACE ('l_num_rec is NOT 1');
3260: END IF;
3261:
3262: l_next_index := l_timecard_detail.COUNT + 1;
3263: l_time_building_block_id := l_time_building_block_id - 1;

Line 3309: hr_utility.set_location (l_proc, 3000);

3305: IF detail_hours IS NULL
3306: THEN
3307: IF g_debug
3308: THEN
3309: hr_utility.set_location (l_proc, 3000);
3310: END IF;
3311:
3312: detail_type := 'RANGE';
3313: ELSE

Line 3316: hr_utility.set_location (l_proc, 3005);

3312: detail_type := 'RANGE';
3313: ELSE
3314: IF g_debug
3315: THEN
3316: hr_utility.set_location (l_proc, 3005);
3317: END IF;
3318:
3319: detail_type := 'MEASURE';
3320: END IF;

Line 3325: hr_utility.set_location (l_proc, 3010);

3321:
3322: -- Populate the pl/sql tables before rolling back to the savepoint.
3323: IF g_debug
3324: THEN
3325: hr_utility.set_location (l_proc, 3010);
3326: hr_utility.TRACE ( 'l_next_index is : '
3327: || TO_CHAR (l_next_index)
3328: );
3329: END IF;

Line 3326: hr_utility.TRACE ( 'l_next_index is : '

3322: -- Populate the pl/sql tables before rolling back to the savepoint.
3323: IF g_debug
3324: THEN
3325: hr_utility.set_location (l_proc, 3010);
3326: hr_utility.TRACE ( 'l_next_index is : '
3327: || TO_CHAR (l_next_index)
3328: );
3329: END IF;
3330:

Line 3340: hr_utility.TRACE ('done');

3336: 'ELEMENT' || ' ' || '-' || ' ' || detail_hours_type;
3337:
3338: IF g_debug
3339: THEN
3340: hr_utility.TRACE ('done');
3341: hr_utility.set_location (l_proc, 3015);
3342: END IF;
3343: END LOOP;
3344:

Line 3341: hr_utility.set_location (l_proc, 3015);

3337:
3338: IF g_debug
3339: THEN
3340: hr_utility.TRACE ('done');
3341: hr_utility.set_location (l_proc, 3015);
3342: END IF;
3343: END LOOP;
3344:
3345: IF g_debug

Line 3347: hr_utility.set_location (l_proc, 3020);

3343: END LOOP;
3344:
3345: IF g_debug
3346: THEN
3347: hr_utility.set_location (l_proc, 3020);
3348: hr_utility.TRACE ('After End Loop');
3349: END IF;
3350:
3351: CLOSE get_otm_records;

Line 3348: hr_utility.TRACE ('After End Loop');

3344:
3345: IF g_debug
3346: THEN
3347: hr_utility.set_location (l_proc, 3020);
3348: hr_utility.TRACE ('After End Loop');
3349: END IF;
3350:
3351: CLOSE get_otm_records;
3352: END IF; --if l_tim_sum_id_tab(l_tim_sum) is not null then

Line 3356: hr_utility.set_location (l_proc, 3025);

3352: END IF; --if l_tim_sum_id_tab(l_tim_sum) is not null then
3353:
3354: IF g_debug
3355: THEN
3356: hr_utility.set_location (l_proc, 3025);
3357: END IF;
3358:
3359: l_tim_sum := l_tim_sum_id_tab.NEXT (l_tim_sum);
3360: END LOOP;

Line 3364: hr_utility.set_location (l_proc, 3030);

3360: END LOOP;
3361:
3362: IF g_debug
3363: THEN
3364: hr_utility.set_location (l_proc, 3030);
3365: hr_utility.set_location (l_proc, 3035);
3366: END IF;
3367:
3368: ROLLBACK TO review_details;

Line 3365: hr_utility.set_location (l_proc, 3035);

3361:
3362: IF g_debug
3363: THEN
3364: hr_utility.set_location (l_proc, 3030);
3365: hr_utility.set_location (l_proc, 3035);
3366: END IF;
3367:
3368: ROLLBACK TO review_details;
3369:

Line 3372: hr_utility.set_location (l_proc, 3040);

3368: ROLLBACK TO review_details;
3369:
3370: IF g_debug
3371: THEN
3372: hr_utility.set_location (l_proc, 3040);
3373: hr_utility.TRACE ('After RollBack');
3374: hr_utility.set_location (l_proc, 3045);
3375: END IF;
3376:

Line 3373: hr_utility.TRACE ('After RollBack');

3369:
3370: IF g_debug
3371: THEN
3372: hr_utility.set_location (l_proc, 3040);
3373: hr_utility.TRACE ('After RollBack');
3374: hr_utility.set_location (l_proc, 3045);
3375: END IF;
3376:
3377: IF l_timecard_detail.COUNT <> 0

Line 3374: hr_utility.set_location (l_proc, 3045);

3370: IF g_debug
3371: THEN
3372: hr_utility.set_location (l_proc, 3040);
3373: hr_utility.TRACE ('After RollBack');
3374: hr_utility.set_location (l_proc, 3045);
3375: END IF;
3376:
3377: IF l_timecard_detail.COUNT <> 0
3378: THEN

Line 3381: hr_utility.set_location (l_proc, 3050);

3377: IF l_timecard_detail.COUNT <> 0
3378: THEN
3379: IF g_debug
3380: THEN
3381: hr_utility.set_location (l_proc, 3050);
3382: END IF;
3383:
3384: FOR l_cnt IN l_timecard_detail.FIRST .. l_timecard_detail.LAST
3385: LOOP

Line 3388: hr_utility.TRACE

3384: FOR l_cnt IN l_timecard_detail.FIRST .. l_timecard_detail.LAST
3385: LOOP
3386: IF g_debug
3387: THEN
3388: hr_utility.TRACE
3389: ( 'l_timecard_detail BB ID is : '
3390: || TO_CHAR
3391: (l_timecard_detail (l_cnt).time_building_block_id
3392: )

Line 3401: hr_utility.TRACE

3397: FOR l_cnt IN l_detail_attributes.FIRST .. l_detail_attributes.LAST
3398: LOOP
3399: IF g_debug
3400: THEN
3401: hr_utility.TRACE
3402: ( 'l_detail_attributes BB ID is : '
3403: || TO_CHAR
3404: (l_detail_attributes (l_cnt).building_block_id
3405: )

Line 3412: hr_utility.set_location (l_proc, 3055);

3408: END LOOP;
3409:
3410: IF g_debug
3411: THEN
3412: hr_utility.set_location (l_proc, 3055);
3413: END IF;
3414: END IF;
3415:
3416: IF g_debug

Line 3418: hr_utility.set_location (l_proc, 3060);

3414: END IF;
3415:
3416: IF g_debug
3417: THEN
3418: hr_utility.set_location (l_proc, 3060);
3419: hr_utility.TRACE ('END FYI');
3420: END IF;
3421:
3422: p_messages := g_messages;

Line 3419: hr_utility.TRACE ('END FYI');

3415:
3416: IF g_debug
3417: THEN
3418: hr_utility.set_location (l_proc, 3060);
3419: hr_utility.TRACE ('END FYI');
3420: END IF;
3421:
3422: p_messages := g_messages;
3423: p_detail_build_blocks := l_timecard_detail;

Line 3430: hr_utility.set_location (l_proc, 3065);

3426: IF p_detail_build_blocks.COUNT <> 0
3427: THEN
3428: IF g_debug
3429: THEN
3430: hr_utility.set_location (l_proc, 3065);
3431: END IF;
3432:
3433: FOR l_cnt IN
3434: p_detail_build_blocks.FIRST .. p_detail_build_blocks.LAST

Line 3438: hr_utility.TRACE

3434: p_detail_build_blocks.FIRST .. p_detail_build_blocks.LAST
3435: LOOP
3436: IF g_debug
3437: THEN
3438: hr_utility.TRACE
3439: ( 'p_detail_build_blocks BB ID is : '
3440: || TO_CHAR
3441: (p_detail_build_blocks (l_cnt).time_building_block_id
3442: )

Line 3444: hr_utility.TRACE ( 'p_detail_build_blocks Hours is : '

3440: || TO_CHAR
3441: (p_detail_build_blocks (l_cnt).time_building_block_id
3442: )
3443: );
3444: hr_utility.TRACE ( 'p_detail_build_blocks Hours is : '
3445: || TO_CHAR
3446: (p_detail_build_blocks (l_cnt).measure
3447: )
3448: );

Line 3456: hr_utility.TRACE

3452: FOR l_cnt IN p_detail_attributes.FIRST .. p_detail_attributes.LAST
3453: LOOP
3454: IF g_debug
3455: THEN
3456: hr_utility.TRACE
3457: ( 'p_detail_attributes BB ID is : '
3458: || TO_CHAR
3459: (p_detail_attributes (l_cnt).building_block_id
3460: )

Line 3462: hr_utility.TRACE ( 'p_detail_attributes ATTR category is : '

3458: || TO_CHAR
3459: (p_detail_attributes (l_cnt).building_block_id
3460: )
3461: );
3462: hr_utility.TRACE ( 'p_detail_attributes ATTR category is : '
3463: || p_detail_attributes (l_cnt).attribute_category
3464: );
3465: END IF;
3466: END LOOP;

Line 3470: hr_utility.set_location (l_proc, 3070);

3466: END LOOP;
3467:
3468: IF g_debug
3469: THEN
3470: hr_utility.set_location (l_proc, 3070);
3471: END IF;
3472: END IF;
3473:
3474: hr_kflex_utility.unset_session_date (p_session_id => l_session_id);

Line 3480: hr_utility.set_location (l_proc, 3075);

3476: WHEN e_error
3477: THEN
3478: IF g_debug
3479: THEN
3480: hr_utility.set_location (l_proc, 3075);
3481: END IF;
3482:
3483: p_messages := g_messages;
3484: -- Rollback to the savepoint

Line 3490: hr_utility.set_location (l_proc, 3080);

3486: RETURN;
3487:
3488: IF g_debug
3489: THEN
3490: hr_utility.set_location (l_proc, 3080);
3491: hr_utility.TRACE ('THE END');
3492: END IF;
3493: WHEN OTHERS
3494: THEN

Line 3491: hr_utility.TRACE ('THE END');

3487:
3488: IF g_debug
3489: THEN
3490: hr_utility.set_location (l_proc, 3080);
3491: hr_utility.TRACE ('THE END');
3492: END IF;
3493: WHEN OTHERS
3494: THEN
3495: IF g_debug

Line 3497: hr_utility.set_location (l_proc, 4000);

3493: WHEN OTHERS
3494: THEN
3495: IF g_debug
3496: THEN
3497: hr_utility.set_location (l_proc, 4000);
3498: END IF;
3499:
3500: p_messages := g_messages;
3501: -- Rollback to the savepoint