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

Line 3: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY hxt_td_util AS
2: /* $Header: hxttdutl.pkb 120.14.12020000.2 2012/07/04 07:15:23 amnaraya ship $ */
3: g_debug boolean := hr_utility.debug_enabled;
4:
5:
6: -- Bug 12379517
7: -- New types.

Line 45: hr_utility.trace('Verify_proj_pay');

41: CLOSE get_period;
42:
43: IF g_debug
44: THEN
45: hr_utility.trace('Verify_proj_pay');
46: hr_utility.trace('p_timecard_id '||p_timecard_id);
47: hr_utility.trace('p_resource_id '||l_resource_id);
48: hr_utility.trace('l_start '||l_start);
49: hr_utility.trace('l_end '||l_end);

Line 46: hr_utility.trace('p_timecard_id '||p_timecard_id);

42:
43: IF g_debug
44: THEN
45: hr_utility.trace('Verify_proj_pay');
46: hr_utility.trace('p_timecard_id '||p_timecard_id);
47: hr_utility.trace('p_resource_id '||l_resource_id);
48: hr_utility.trace('l_start '||l_start);
49: hr_utility.trace('l_end '||l_end);
50: END IF;

Line 47: hr_utility.trace('p_resource_id '||l_resource_id);

43: IF g_debug
44: THEN
45: hr_utility.trace('Verify_proj_pay');
46: hr_utility.trace('p_timecard_id '||p_timecard_id);
47: hr_utility.trace('p_resource_id '||l_resource_id);
48: hr_utility.trace('l_start '||l_start);
49: hr_utility.trace('l_end '||l_end);
50: END IF;
51:

Line 48: hr_utility.trace('l_start '||l_start);

44: THEN
45: hr_utility.trace('Verify_proj_pay');
46: hr_utility.trace('p_timecard_id '||p_timecard_id);
47: hr_utility.trace('p_resource_id '||l_resource_id);
48: hr_utility.trace('l_start '||l_start);
49: hr_utility.trace('l_end '||l_end);
50: END IF;
51:
52: -- Call preference evaluation.

Line 49: hr_utility.trace('l_end '||l_end);

45: hr_utility.trace('Verify_proj_pay');
46: hr_utility.trace('p_timecard_id '||p_timecard_id);
47: hr_utility.trace('p_resource_id '||l_resource_id);
48: hr_utility.trace('l_start '||l_start);
49: hr_utility.trace('l_end '||l_end);
50: END IF;
51:
52: -- Call preference evaluation.
53: hxc_preference_evaluation.resource_preferences(l_resource_id,

Line 66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);

62: LOOP
63:
64: IF g_debug
65: THEN
66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);
67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);

Line 67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);

63:
64: IF g_debug
65: THEN
66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);
67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);
71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);

Line 68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);

64: IF g_debug
65: THEN
66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);
67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);
71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);
72: END IF;

Line 69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);

65: THEN
66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);
67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);
71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);
72: END IF;
73:

Line 70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);

66: hr_utility.trace(' Preference - '||l_pref_tab(i).preference_code);
67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);
71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);
72: END IF;
73:
74: -- If this is our preference, check if it is set.

Line 71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);

67: hr_utility.trace(' Attribute1 - '||l_pref_tab(i).attribute1);
68: hr_utility.trace(' Attribute2 - '||l_pref_tab(i).attribute2);
69: hr_utility.trace(' Attribute3 - '||l_pref_tab(i).attribute3);
70: hr_utility.trace(' Attribute4 - '||l_pref_tab(i).attribute4);
71: hr_utility.trace(' Attribute5 - '||l_pref_tab(i).attribute5);
72: END IF;
73:
74: -- If this is our preference, check if it is set.
75: -- If yes, return TRUE, and set the global variable.

Line 83: hr_utility.trace(' Integration is enabled ');

79: THEN
80: g_proj_pay_intg(p_timecard_id) := 'Y';
81: IF g_debug
82: THEN
83: hr_utility.trace(' Integration is enabled ');
84: END IF;
85: RETURN TRUE;
86: END IF;
87: --There is no ELSE and EXIT loop here because there could be multiple

Line 95: hr_utility.trace('Integration not enabled ');

91: END IF;
92:
93: IF g_debug
94: THEN
95: hr_utility.trace('Integration not enabled ');
96: END IF;
97: RETURN FALSE;
98:
99: END verify_proj_pay;

Line 284: hr_utility.TRACE (

280: LOOP
281: l_details := TRUE;
282: if g_debug then
283:
284: hr_utility.TRACE (
285: LPAD (rec_debug.id, 10)
286: || ' '
287: || LPAD (rec_debug.parent_id, 10)
288: || ' '

Line 320: hr_utility.trace('Integration enabled; verified earlier ');

316: AND g_proj_pay_intg(p_tim_id) = 'Y'
317: THEN
318: IF g_debug
319: THEN
320: hr_utility.trace('Integration enabled; verified earlier ');
321: END IF;
322: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
323: o_error_message := fnd_message.get;
324: o_return_code := 1;

Line 331: hr_utility.trace('Integration disabled; verified earlier ');

327: AND g_proj_pay_intg(p_tim_id) = 'N'
328: THEN
329: IF g_debug
330: THEN
331: hr_utility.trace('Integration disabled; verified earlier ');
332: END IF;
333: ELSIF verify_proj_pay(p_tim_id)
334: THEN
335: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');

Line 344: g_debug :=hr_utility.debug_enabled;

340: END IF;
341:
342:
343:
344: g_debug :=hr_utility.debug_enabled;
345: o_return_code := 0; -- indicates all is OK
346: if g_debug then
347: l_proc := 'retro_restrict_edit';
348: hr_utility.set_location ( 'Entering '

Line 348: hr_utility.set_location ( 'Entering '

344: g_debug :=hr_utility.debug_enabled;
345: o_return_code := 0; -- indicates all is OK
346: if g_debug then
347: l_proc := 'retro_restrict_edit';
348: hr_utility.set_location ( 'Entering '
349: || l_proc, 10);
350: hr_utility.set_location ('Parameters In: ', 20);
351: hr_utility.set_location ( ' p_tim_id = '
352: || p_tim_id, 30);

Line 350: hr_utility.set_location ('Parameters In: ', 20);

346: if g_debug then
347: l_proc := 'retro_restrict_edit';
348: hr_utility.set_location ( 'Entering '
349: || l_proc, 10);
350: hr_utility.set_location ('Parameters In: ', 20);
351: hr_utility.set_location ( ' p_tim_id = '
352: || p_tim_id, 30);
353: hr_utility.set_location (
354: ' p_session_date = '

Line 351: hr_utility.set_location ( ' p_tim_id = '

347: l_proc := 'retro_restrict_edit';
348: hr_utility.set_location ( 'Entering '
349: || l_proc, 10);
350: hr_utility.set_location ('Parameters In: ', 20);
351: hr_utility.set_location ( ' p_tim_id = '
352: || p_tim_id, 30);
353: hr_utility.set_location (
354: ' p_session_date = '
355: || p_session_date,

Line 353: hr_utility.set_location (

349: || l_proc, 10);
350: hr_utility.set_location ('Parameters In: ', 20);
351: hr_utility.set_location ( ' p_tim_id = '
352: || p_tim_id, 30);
353: hr_utility.set_location (
354: ' p_session_date = '
355: || p_session_date,
356: 40
357: );

Line 358: hr_utility.set_location ( ' p_parent_id = '

354: ' p_session_date = '
355: || p_session_date,
356: 40
357: );
358: hr_utility.set_location ( ' p_parent_id = '
359: || p_parent_id, 50);
360: end if;
361:
362: -- Bug 7359347

Line 391: hr_utility.set_location ('Do CORRECTION', 60);

387:
388: IF csr_not_transferred%FOUND
389: THEN -- we can do a correction
390: if g_debug then
391: hr_utility.set_location ('Do CORRECTION', 60);
392: end if;
393:
394: o_dt_update_mod := 'CORRECTION';
395:

Line 407: hr_utility.set_location ('Do UPDATE', 70);

403: IF csr_transferred_retro%FOUND
404: THEN -- TC undergoing RETRO now, only UPDATE allowed.
405:
406: if g_debug then
407: hr_utility.set_location ('Do UPDATE', 70);
408: end if;
409: o_dt_update_mod := 'UPDATE';
410: -- Bug 6067007
411:

Line 429: hr_utility.set_location ('Do UPDATE', 70);

425: o_return_code := 1; -- this means that an error should be raised
426: o_dt_update_mod := NULL;
427: ELSE -- We can allow an DT UPDATE because that will keep the history
428: if g_debug then
429: hr_utility.set_location ('Do UPDATE', 70);
430: end if;
431: o_dt_update_mod := 'UPDATE';
432: END IF; -- IF csr_changed_today%FOUND
433:

Line 437: hr_utility.set_location ('Do UPDATE', 80);

433:
434: CLOSE csr_changed_today;
435: ELSE -- We can allow an DT UPDATE because that will keep the history
436: if g_debug then
437: hr_utility.set_location ('Do UPDATE', 80);
438: end if;
439: o_dt_update_mod := 'UPDATE';
440: END IF; -- IF csr_transferred%FOUND
441: CLOSE csr_transferred;

Line 451: hr_utility.set_location ('Do CORRECTION', 90);

447: CLOSE csr_not_transferred;
448:
449: ELSE -- if details
450: if g_debug then
451: hr_utility.set_location ('Do CORRECTION', 90);
452: end if;
453: o_dt_update_mod := 'CORRECTION';
454: END IF;
455:

Line 612: hr_utility.TRACE (

608: LOOP
609: l_details := TRUE;
610: if g_debug then
611:
612: hr_utility.TRACE (
613: LPAD (rec_debug.id, 10)
614: || ' '
615: || LPAD (rec_debug.parent_id, 10)
616: || ' '

Line 647: hr_utility.trace('Integration enabled; verified earlier ');

643: AND g_proj_pay_intg(p_tim_id) = 'Y'
644: THEN
645: IF g_debug
646: THEN
647: hr_utility.trace('Integration enabled; verified earlier ');
648: END IF;
649: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');
650: o_error_message := fnd_message.get;
651: o_return_code := 1;

Line 658: hr_utility.trace('Integration disabled; verified earlier ');

654: AND g_proj_pay_intg(p_tim_id) = 'N'
655: THEN
656: IF g_debug
657: THEN
658: hr_utility.trace('Integration disabled; verified earlier ');
659: END IF;
660: ELSIF verify_proj_pay(p_tim_id)
661: THEN
662: fnd_message.set_name ('HXC','HXC_PROJ_PAY_NO_OTLR');

Line 671: g_debug :=hr_utility.debug_enabled;

667: END IF;
668:
669:
670:
671: g_debug :=hr_utility.debug_enabled;
672: o_return_code := 0; -- indicates all is OK
673: if g_debug then
674: l_proc := 'retro_restrict_edit';
675: hr_utility.set_location ( 'Entering '

Line 675: hr_utility.set_location ( 'Entering '

671: g_debug :=hr_utility.debug_enabled;
672: o_return_code := 0; -- indicates all is OK
673: if g_debug then
674: l_proc := 'retro_restrict_edit';
675: hr_utility.set_location ( 'Entering '
676: || l_proc, 10);
677: hr_utility.set_location ('Parameters In: ', 20);
678: hr_utility.set_location ( ' p_tim_id = '
679: || p_tim_id, 30);

Line 677: hr_utility.set_location ('Parameters In: ', 20);

673: if g_debug then
674: l_proc := 'retro_restrict_edit';
675: hr_utility.set_location ( 'Entering '
676: || l_proc, 10);
677: hr_utility.set_location ('Parameters In: ', 20);
678: hr_utility.set_location ( ' p_tim_id = '
679: || p_tim_id, 30);
680: hr_utility.set_location (
681: ' p_session_date = '

Line 678: hr_utility.set_location ( ' p_tim_id = '

674: l_proc := 'retro_restrict_edit';
675: hr_utility.set_location ( 'Entering '
676: || l_proc, 10);
677: hr_utility.set_location ('Parameters In: ', 20);
678: hr_utility.set_location ( ' p_tim_id = '
679: || p_tim_id, 30);
680: hr_utility.set_location (
681: ' p_session_date = '
682: || p_session_date,

Line 680: hr_utility.set_location (

676: || l_proc, 10);
677: hr_utility.set_location ('Parameters In: ', 20);
678: hr_utility.set_location ( ' p_tim_id = '
679: || p_tim_id, 30);
680: hr_utility.set_location (
681: ' p_session_date = '
682: || p_session_date,
683: 40
684: );

Line 685: hr_utility.set_location ( ' p_parent_id = '

681: ' p_session_date = '
682: || p_session_date,
683: 40
684: );
685: hr_utility.set_location ( ' p_parent_id = '
686: || p_parent_id, 50);
687: end if;
688:
689: -- Bug 7359347

Line 723: hr_utility.set_location ('Do CORRECTION', 60);

719:
720: IF csr_not_transferred%FOUND
721: THEN -- we can do a correction
722: if g_debug then
723: hr_utility.set_location ('Do CORRECTION', 60);
724: end if;
725:
726: o_dt_update_mod := 'CORRECTION';
727:

Line 739: hr_utility.set_location ('Do UPDATE', 70);

735: IF csr_transferred_retro%FOUND
736: THEN -- TC undergoing RETRO now, only UPDATE allowed.
737:
738: if g_debug then
739: hr_utility.set_location ('Do UPDATE', 70);
740: end if;
741: o_dt_update_mod := 'UPDATE';
742: -- Bug 6067007
743:

Line 761: hr_utility.set_location ('Do UPDATE', 70);

757: o_return_code := 1; -- this means that an error should be raised
758: o_dt_update_mod := NULL;
759: ELSE -- We can allow an DT UPDATE because that will keep the history
760: if g_debug then
761: hr_utility.set_location ('Do UPDATE', 70);
762: end if;
763: o_dt_update_mod := 'UPDATE';
764: END IF; -- IF csr_changed_today%FOUND
765:

Line 769: hr_utility.set_location ('Do UPDATE', 80);

765:
766: CLOSE csr_changed_today;
767: ELSE -- We can allow an DT UPDATE because that will keep the history
768: if g_debug then
769: hr_utility.set_location ('Do UPDATE', 80);
770: end if;
771: o_dt_update_mod := 'UPDATE';
772: END IF; -- IF csr_transferred%FOUND
773: CLOSE csr_transferred;

Line 783: hr_utility.set_location ('Do CORRECTION', 90);

779: CLOSE csr_not_transferred;
780:
781: ELSE -- if details
782: if g_debug then
783: hr_utility.set_location ('Do CORRECTION', 90);
784: end if;
785: o_dt_update_mod := 'CORRECTION';
786: END IF;
787:

Line 947: g_debug :=hr_utility.debug_enabled;

943: l_proc VARCHAR2 (200) ;
944: l_prev_id NUMBER;
945:
946: BEGIN
947: g_debug :=hr_utility.debug_enabled;
948: if g_debug then
949: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
950: hr_utility.set_location (l_proc, 10);
951: hr_utility.TRACE (

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

946: BEGIN
947: g_debug :=hr_utility.debug_enabled;
948: if g_debug then
949: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
950: hr_utility.set_location (l_proc, 10);
951: hr_utility.TRACE (
952: 'a_date_worked :'
953: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
954: );

Line 951: hr_utility.TRACE (

947: g_debug :=hr_utility.debug_enabled;
948: if g_debug then
949: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
950: hr_utility.set_location (l_proc, 10);
951: hr_utility.TRACE (
952: 'a_date_worked :'
953: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
954: );
955: hr_utility.TRACE ( 'a_start_day_of_week :'

Line 955: hr_utility.TRACE ( 'a_start_day_of_week :'

951: hr_utility.TRACE (
952: 'a_date_worked :'
953: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
954: );
955: hr_utility.TRACE ( 'a_start_day_of_week :'
956: || a_start_day_of_week);
957: hr_utility.TRACE ( 'a_tim_id :'
958: || a_tim_id);
959: hr_utility.TRACE (

Line 957: hr_utility.TRACE ( 'a_tim_id :'

953: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
954: );
955: hr_utility.TRACE ( 'a_start_day_of_week :'
956: || a_start_day_of_week);
957: hr_utility.TRACE ( 'a_tim_id :'
958: || a_tim_id);
959: hr_utility.TRACE (
960: 'a_base_element_type_id :'
961: || a_base_element_type_id

Line 959: hr_utility.TRACE (

955: hr_utility.TRACE ( 'a_start_day_of_week :'
956: || a_start_day_of_week);
957: hr_utility.TRACE ( 'a_tim_id :'
958: || a_tim_id);
959: hr_utility.TRACE (
960: 'a_base_element_type_id :'
961: || a_base_element_type_id
962: );
963: hr_utility.TRACE ( 'a_ep_id :'

Line 963: hr_utility.TRACE ( 'a_ep_id :'

959: hr_utility.TRACE (
960: 'a_base_element_type_id :'
961: || a_base_element_type_id
962: );
963: hr_utility.TRACE ( 'a_ep_id :'
964: || a_ep_id);
965: hr_utility.TRACE ( 'a_for_person_id :'
966: || a_for_person_id);
967: end if;

Line 965: hr_utility.TRACE ( 'a_for_person_id :'

961: || a_base_element_type_id
962: );
963: hr_utility.TRACE ( 'a_ep_id :'
964: || a_ep_id);
965: hr_utility.TRACE ( 'a_for_person_id :'
966: || a_for_person_id);
967: end if;
968: -- Bug 7359347
969: -- Pass session date to the cursor.

Line 990: hr_utility.TRACE ( 'l_weekly_total :'

986: l_prev_id);
987:
988: FETCH weekly_total2 INTO l_weekly_total;
989: if g_debug then
990: hr_utility.TRACE ( 'l_weekly_total :'
991: || l_weekly_total);
992: end if;
993: CLOSE weekly_total2;
994: if g_debug then

Line 995: hr_utility.set_location (l_proc, 20.1);

991: || l_weekly_total);
992: end if;
993: CLOSE weekly_total2;
994: if g_debug then
995: hr_utility.set_location (l_proc, 20.1);
996: end if;
997:
998:
999: -- Bug 11837942

Line 1008: hr_utility.TRACE ( 'l_weekly_total :'

1004: OPEN weekly_total(g_td_session_date);
1005:
1006: FETCH weekly_total INTO l_weekly_total;
1007: if g_debug then
1008: hr_utility.TRACE ( 'l_weekly_total :'
1009: || l_weekly_total);
1010: end if;
1011: CLOSE weekly_total;
1012: if g_debug then

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

1009: || l_weekly_total);
1010: end if;
1011: CLOSE weekly_total;
1012: if g_debug then
1013: hr_utility.set_location (l_proc, 20);
1014: end if;
1015: */
1016:
1017:

Line 1156: g_debug :=hr_utility.debug_enabled;

1152:
1153: l_proc VARCHAR2 (200) ;
1154: l_prev_id NUMBER;
1155: BEGIN
1156: g_debug :=hr_utility.debug_enabled;
1157: if g_debug then
1158: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
1159: hr_utility.set_location (l_proc, 10);
1160: hr_utility.TRACE (

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

1155: BEGIN
1156: g_debug :=hr_utility.debug_enabled;
1157: if g_debug then
1158: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
1159: hr_utility.set_location (l_proc, 10);
1160: hr_utility.TRACE (
1161: 'a_date_worked :'
1162: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
1163: );

Line 1160: hr_utility.TRACE (

1156: g_debug :=hr_utility.debug_enabled;
1157: if g_debug then
1158: l_proc := 'hxt_td_util.GET_WEEKLY_TOTAL';
1159: hr_utility.set_location (l_proc, 10);
1160: hr_utility.TRACE (
1161: 'a_date_worked :'
1162: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
1163: );
1164: hr_utility.TRACE ( 'a_start_day_of_week :'

Line 1164: hr_utility.TRACE ( 'a_start_day_of_week :'

1160: hr_utility.TRACE (
1161: 'a_date_worked :'
1162: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
1163: );
1164: hr_utility.TRACE ( 'a_start_day_of_week :'
1165: || a_start_day_of_week);
1166: hr_utility.TRACE ( 'a_tim_id :'
1167: || a_tim_id);
1168: hr_utility.TRACE (

Line 1166: hr_utility.TRACE ( 'a_tim_id :'

1162: || TO_CHAR (a_date_worked, 'dd-mon-yyyy hh24:mi:ss')
1163: );
1164: hr_utility.TRACE ( 'a_start_day_of_week :'
1165: || a_start_day_of_week);
1166: hr_utility.TRACE ( 'a_tim_id :'
1167: || a_tim_id);
1168: hr_utility.TRACE (
1169: 'a_base_element_type_id :'
1170: || a_base_element_type_id

Line 1168: hr_utility.TRACE (

1164: hr_utility.TRACE ( 'a_start_day_of_week :'
1165: || a_start_day_of_week);
1166: hr_utility.TRACE ( 'a_tim_id :'
1167: || a_tim_id);
1168: hr_utility.TRACE (
1169: 'a_base_element_type_id :'
1170: || a_base_element_type_id
1171: );
1172: hr_utility.TRACE ( 'a_ep_id :'

Line 1172: hr_utility.TRACE ( 'a_ep_id :'

1168: hr_utility.TRACE (
1169: 'a_base_element_type_id :'
1170: || a_base_element_type_id
1171: );
1172: hr_utility.TRACE ( 'a_ep_id :'
1173: || a_ep_id);
1174: hr_utility.TRACE ( 'a_for_person_id :'
1175: || a_for_person_id);
1176: end if;

Line 1174: hr_utility.TRACE ( 'a_for_person_id :'

1170: || a_base_element_type_id
1171: );
1172: hr_utility.TRACE ( 'a_ep_id :'
1173: || a_ep_id);
1174: hr_utility.TRACE ( 'a_for_person_id :'
1175: || a_for_person_id);
1176: end if;
1177:
1178: -- Bug 7359347

Line 1198: hr_utility.TRACE ( 'l_weekly_total :'

1194: l_prev_id);
1195:
1196: FETCH weekly_total2 INTO l_weekly_total;
1197: if g_debug then
1198: hr_utility.TRACE ( 'l_weekly_total :'
1199: || l_weekly_total);
1200: end if;
1201: CLOSE weekly_total2;
1202: if g_debug then

Line 1203: hr_utility.set_location (l_proc, 20.1);

1199: || l_weekly_total);
1200: end if;
1201: CLOSE weekly_total2;
1202: if g_debug then
1203: hr_utility.set_location (l_proc, 20.1);
1204: end if;
1205:
1206: -- Bug 11837942
1207: -- This part is commented out now so that

Line 1214: hr_utility.TRACE ( 'l_weekly_total :'

1210:
1211: OPEN weekly_total(g_td_session_date);
1212: FETCH weekly_total INTO l_weekly_total;
1213: if g_debug then
1214: hr_utility.TRACE ( 'l_weekly_total :'
1215: || l_weekly_total);
1216: end if;
1217: CLOSE weekly_total;
1218: if g_debug then

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

1215: || l_weekly_total);
1216: end if;
1217: CLOSE weekly_total;
1218: if g_debug then
1219: hr_utility.set_location (l_proc, 20);
1220: end if;
1221:
1222: */
1223: