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

Line 4: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY HXC_RETRIEVE_ABSENCES AS
2: /* $Header: hxcretabs.pkb 120.43.12020000.2 2012/10/09 14:59:12 asrajago ship $ */
3:
4: g_debug BOOLEAN := hr_utility.debug_enabled;
5:
6:
7: TYPE ALIAS_TAB IS TABLE OF VARCHAR2(400) INDEX BY BINARY_INTEGER;
8: TYPE NUMTABLE IS TABLE OF NUMBER;

Line 74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);

70: LOOP
71:
72: IF g_debug
73: THEN
74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);
75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);

Line 75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);

71:
72: IF g_debug
73: THEN
74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);
75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);

Line 76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);

72: IF g_debug
73: THEN
74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);
75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;

Line 77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);

73: THEN
74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);
75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;
81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)

Line 78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);

74: hr_utility.trace('ABS : l_abs_org_tab(i).absence_type_id '||l_abs_org_tab(i).absence_type_id);
75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;
81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)
82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)

Line 79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);

75: hr_utility.trace('ABS : l_abs_org_tab(i).abs_startdate '||l_abs_org_tab(i).abs_startdate);
76: hr_utility.trace('ABS : l_abs_org_tab(i).abs_enddate '||l_abs_org_tab(i).abs_enddate);
77: hr_utility.trace('ABS : l_abs_org_tab(i).rec_start_date '||l_abs_org_tab(i).rec_start_date);
78: hr_utility.trace('ABS : l_abs_org_tab(i).rec_end_date '||l_abs_org_tab(i).rec_end_date);
79: hr_utility.trace('ABS : l_abs_org_tab(i).confirmed_flag '||l_abs_org_tab(i).confirmed_flag);
80: END IF;
81: IF TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) > TRUNC(p_end_date)
82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)
83: THEN

Line 86: hr_utility.trace('ABS : Spans outside the timecard ');

82: OR TRUNC(fnd_date.canonical_to_date(l_abs_org_tab(i).abs_startdate)) < TRUNC(p_start_date)
83: THEN
84: IF g_debug
85: THEN
86: hr_utility.trace('ABS : Spans outside the timecard ');
87: END IF;
88: EXIT CONTINUE_TO_NEXT;
89: END IF;
90:

Line 134: hr_utility.trace('ABS : This is an SSHR transaction ');

130: IF l_abs_org_tab(i).transactionid IS NOT NULL
131: THEN
132: IF g_debug
133: THEN
134: hr_utility.trace('ABS : This is an SSHR transaction ');
135: END IF;
136: p_abs_tab(l_ind).transaction_id := l_abs_org_tab(i).transactionid;
137: p_abs_tab(l_ind).modetype := l_abs_org_tab(i).modetype;
138: IF p_abs_tab(l_ind).modetype = 'DeleteMode'

Line 172: hr_utility.trace('ABS : This is a DELETE pending in SSHR ');

168: ,NULL
169: ,NULL
170: ,NULL
171: );
172: hr_utility.trace('ABS : This is a DELETE pending in SSHR ');
173: g_message_string := 'HXC_ABS_PEND_APPR_DELETE';
174: EXIT;
175: END IF; -- Pending Delete = TRUE
176:

Line 179: hr_utility.trace('ABS : This is pending APPROVAL in SSHR -- ERROR');

175: END IF; -- Pending Delete = TRUE
176:
177: IF g_pref_table(i).attribute3 = 'ERROR'
178: THEN
179: hr_utility.trace('ABS : This is pending APPROVAL in SSHR -- ERROR');
180: hxc_timecard_message_helper.addErrorToCollection
181: (g_messages
182: ,'HXC_ABS_PEND_APPR_ERROR'
183: ,hxc_timecard.c_error

Line 192: hr_utility.trace('ABS : A pending approval error added ');

188: ,NULL
189: ,NULL
190: ,NULL
191: );
192: hr_utility.trace('ABS : A pending approval error added ');
193: g_message_string := 'HXC_ABS_PEND_APPR_ERROR';
194: END IF; -- Attribute3 = ERROR
195: EXIT;
196:

Line 207: hr_utility.trace('ABS : This is pending Confirmation in SSHR -- ERROR');

203: IF g_pending_conf = TRUE
204: THEN
205: IF g_pref_table(i).attribute7 = 'ERROR'
206: THEN
207: hr_utility.trace('ABS : This is pending Confirmation in SSHR -- ERROR');
208: hxc_timecard_message_helper.addErrorToCollection
209: (g_messages
210: ,'HXC_ABS_PEND_CONF_ERROR'
211: ,hxc_timecard.c_error

Line 220: hr_utility.trace('ABS : A pending Confirmation error added ');

216: ,NULL
217: ,NULL
218: ,NULL
219: );
220: hr_utility.trace('ABS : A pending Confirmation error added ');
221: g_message_string := 'HXC_ABS_PEND_CONF_ERROR';
222: END IF;
223: END IF; -- PENDING CONF = TRUE
224: EXIT;

Line 310: hr_utility.trace('Getting alt name identifier s');

306:
307: BEGIN
308: IF g_debug
309: THEN
310: hr_utility.trace('Getting alt name identifier s');
311: END IF;
312:
313: hxc_preference_evaluation.resource_preferences(p_person_id,
314: p_start_time,

Line 376: hr_utility.trace(l_alias_sql);

372: THEN
373: l_alias_sql := REPLACE(l_alias_sql,'ALIASLIST',l_alias_list);
374: IF g_debug
375: THEN
376: hr_utility.trace(l_alias_sql);
377: END IF;
378: OPEN l_ref_cursor FOR l_alias_sql;
379: FETCH l_ref_cursor BULK COLLECT INTO l_element_tab,
380: l_id_tab;

Line 390: hr_utility.trace('Element Id is'||g_alias_tab(l_element_tab(i)));

386: LOOP
387: g_alias_tab(l_element_tab(i)) := l_id_tab(i);
388: IF g_debug
389: THEN
390: hr_utility.trace('Element Id is'||g_alias_tab(l_element_tab(i)));
391: hr_utility.trace('Alt Id is '||l_id_tab(i));
392: END IF;
393: END LOOP;
394: END IF;

Line 391: hr_utility.trace('Alt Id is '||l_id_tab(i));

387: g_alias_tab(l_element_tab(i)) := l_id_tab(i);
388: IF g_debug
389: THEN
390: hr_utility.trace('Element Id is'||g_alias_tab(l_element_tab(i)));
391: hr_utility.trace('Alt Id is '||l_id_tab(i));
392: END IF;
393: END LOOP;
394: END IF;
395:

Line 755: hr_utility.trace('ABS: Created timecard and layout attribute ');

751: l_att_id);
752:
753: IF g_debug
754: THEN
755: hr_utility.trace('ABS: Created timecard and layout attribute ');
756: END IF;
757:
758: l_block_ind := l_block_ind + 1;
759: l_day_id := -2;

Line 787: hr_utility.trace('ABS : i'||i);

783: FOR i IN l_abs_tab.FIRST..l_abs_tab.LAST
784: LOOP
785: << CONTINUE_TO_NEXT>>
786: LOOP
787: hr_utility.trace('ABS : i'||i);
788: IF NOT l_abs_tab.EXISTS(i)
789: THEN
790: EXIT CONTINUE_TO_NEXT;
791: END IF;

Line 802: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);

798: END IF;
799: p_block_array.EXTEND(1);
800: IF g_debug
801: THEN
802: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);
804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));

Line 803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);

799: p_block_array.EXTEND(1);
800: IF g_debug
801: THEN
802: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);
804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));
807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);

Line 804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);

800: IF g_debug
801: THEN
802: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);
804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));
807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
808: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);

Line 805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||

801: THEN
802: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);
804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));
807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
808: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
809: END IF;

Line 807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);

803: hr_utility.trace('ABS: l_abs_tab(i).abs_end'||l_abs_tab(i).abs_end);
804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));
807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
808: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
809: END IF;
810: p_block_array(l_block_ind) := get_detail_block(l_abs_tab(i).abs_start,
811: l_abs_tab(i).abs_end,

Line 808: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);

804: hr_utility.trace('ABS: l_abs_tab(i).duration'||l_abs_tab(i).duration);
805: hr_utility.trace('ABS: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,YYYYMMDD))'||
806: g_day_tab(TO_CHAR(l_abs_tab(i).abs_date,'YYYYMMDD')));
807: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
808: hr_utility.trace('ABS: l_abs_tab(i).abs_start'||l_abs_tab(i).abs_start);
809: END IF;
810: p_block_array(l_block_ind) := get_detail_block(l_abs_tab(i).abs_start,
811: l_abs_tab(i).abs_end,
812: l_abs_tab(i).duration,

Line 903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);

899: IF g_debug
900: THEN
901: i := p_block_array.FIRST;
902: LOOP
903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);
904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);

Line 904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);

900: THEN
901: i := p_block_array.FIRST;
902: LOOP
903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);
904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);

Line 905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);

901: i := p_block_array.FIRST;
902: LOOP
903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);
904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);
909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);

Line 906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);

902: LOOP
903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);
904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);
909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);
910: i:= p_block_array.NEXT(i);

Line 907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);

903: hr_utility.trace('p_block_array(i).time_building_block_id '||p_block_array(i).time_building_block_id);
904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);
909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);
910: i:= p_block_array.NEXT(i);
911: EXIT WHEN NOT p_block_array.EXISTS(i);

Line 908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);

904: hr_utility.trace('p_block_array(i).object_version_number '||p_block_array(i).object_version_number);
905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);
909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);
910: i:= p_block_array.NEXT(i);
911: EXIT WHEN NOT p_block_array.EXISTS(i);
912: END LOOP;

Line 909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);

905: hr_utility.trace('p_block_array(i).scope '||p_block_array(i).scope);
906: hr_utility.trace('p_block_array(i).start_time '||p_block_array(i).start_time);
907: hr_utility.trace('p_block_array(i).stop_time '||p_block_array(i).stop_time);
908: hr_utility.trace('p_block_array(i).measure '||p_block_array(i).measure);
909: hr_utility.trace('p_block_array(i).date_to '||p_block_array(i).date_to);
910: i:= p_block_array.NEXT(i);
911: EXIT WHEN NOT p_block_array.EXISTS(i);
912: END LOOP;
913:

Line 916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);

912: END LOOP;
913:
914: i:= p_attribute_array.FIRST;
915: LOOP
916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);
917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);

Line 917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);

913:
914: i:= p_attribute_array.FIRST;
915: LOOP
916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);
917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);

Line 918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);

914: i:= p_attribute_array.FIRST;
915: LOOP
916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);
917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);
922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);

Line 919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);

915: LOOP
916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);
917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);
922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);
923: i:= p_attribute_array.NEXT(i);

Line 920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);

916: hr_utility.trace('p_attribute_array(i).building_block_id '||p_attribute_array(i).building_block_id);
917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);
922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);
923: i:= p_attribute_array.NEXT(i);
924: EXIT WHEN NOT p_block_array.EXISTS(i);

Line 921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);

917: hr_utility.trace('p_attribute_array(i).building_block_ovn '||p_attribute_array(i).building_block_ovn);
918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);
922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);
923: i:= p_attribute_array.NEXT(i);
924: EXIT WHEN NOT p_block_array.EXISTS(i);
925: END LOOP;

Line 922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);

918: hr_utility.trace('p_attribute_array(i).attribute_category '||p_attribute_array(i).attribute_category);
919: hr_utility.trace('p_attribute_array(i).bld_blk_info_type '||p_attribute_array(i).bld_blk_info_type);
920: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute1);
921: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute2);
922: hr_utility.trace('p_attribute_array(i).attribute1 '||p_attribute_array(i).attribute3);
923: i:= p_attribute_array.NEXT(i);
924: EXIT WHEN NOT p_block_array.EXISTS(i);
925: END LOOP;
926:

Line 1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);

1289: IF l_abs_status_tab.COUNT >0
1290: THEN
1291: FOR i IN l_abs_status_tab.FIRST..l_abs_status_tab.LAST
1292: LOOP
1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);
1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);

Line 1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);

1290: THEN
1291: FOR i IN l_abs_status_tab.FIRST..l_abs_status_tab.LAST
1292: LOOP
1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);
1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);

Line 1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);

1291: FOR i IN l_abs_status_tab.FIRST..l_abs_status_tab.LAST
1292: LOOP
1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);
1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);
1299: -- Bug 8859597

Line 1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);

1292: LOOP
1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);
1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);
1299: -- Bug 8859597
1300: -- Removing Duration.

Line 1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);

1293: hr_utility.trace('ABS: l_abs_status_tab(i).abs_type '||l_abs_status_tab(i).abs_type);
1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);
1299: -- Bug 8859597
1300: -- Removing Duration.
1301: --hr_utility.trace('ABS: l_abs_status_tab(i).measure '||l_abs_status_tab(i).measure);

Line 1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);

1294: hr_utility.trace('ABS: l_abs_status_tab(i).status '||l_abs_status_tab(i).status);
1295: hr_utility.trace('ABS: l_abs_status_tab(i).uom '||l_abs_status_tab(i).uom);
1296: hr_utility.trace('ABS: l_abs_status_tab(i).source '||l_abs_status_tab(i).source);
1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);
1299: -- Bug 8859597
1300: -- Removing Duration.
1301: --hr_utility.trace('ABS: l_abs_status_tab(i).measure '||l_abs_status_tab(i).measure);
1302: END LOOP;

Line 1301: --hr_utility.trace('ABS: l_abs_status_tab(i).measure '||l_abs_status_tab(i).measure);

1297: hr_utility.trace('ABS: l_abs_status_tab(i).abs_start '||l_abs_status_tab(i).abs_start);
1298: hr_utility.trace('ABS: l_abs_status_tab(i).abs_end '||l_abs_status_tab(i).abs_end);
1299: -- Bug 8859597
1300: -- Removing Duration.
1301: --hr_utility.trace('ABS: l_abs_status_tab(i).measure '||l_abs_status_tab(i).measure);
1302: END LOOP;
1303: END IF;
1304: END IF;
1305: p_abs_status_rec := l_abs_status_tab;

Line 1392: hr_utility.trace('Entered add_absence_types');

1388: END IF;
1389:
1390: if g_debug then
1391:
1392: hr_utility.trace('Entered add_absence_types');
1393: hr_utility.trace('Before clear_prev_sessions');
1394:
1395: end if;
1396:

Line 1393: hr_utility.trace('Before clear_prev_sessions');

1389:
1390: if g_debug then
1391:
1392: hr_utility.trace('Entered add_absence_types');
1393: hr_utility.trace('Before clear_prev_sessions');
1394:
1395: end if;
1396:
1397:

Line 1411: hr_utility.trace('After clear_prev_sessions');

1407: p_lock_rowid);
1408:
1409: if g_debug then
1410:
1411: hr_utility.trace('After clear_prev_sessions');
1412:
1413: end if;
1414:
1415:

Line 1423: hr_utility.trace('After gen_alt_ids');

1419: 'TK');
1420:
1421: if g_debug then
1422:
1423: hr_utility.trace('After gen_alt_ids');
1424:
1425: end if;
1426:
1427:

Line 1438: hr_utility.trace('ABS : Integration not enabled for this employee ');

1434: IF g_pref_table(l_index).attribute1 <> 'Y'
1435: THEN
1436: IF g_debug
1437: THEN
1438: hr_utility.trace('ABS : Integration not enabled for this employee ');
1439: END IF;
1440: RETURN;
1441: ELSE
1442: EXIT;

Line 1544: hr_utility.trace('ABS : Integration not enabled for this employee ');

1540: IF g_pref_table(l_index).attribute1 <> 'Y'
1541: THEN
1542: IF g_debug
1543: THEN
1544: hr_utility.trace('ABS : Integration not enabled for this employee ');
1545: END IF;
1546: RETURN;
1547: ELSE
1548: EXIT;

Line 2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);

2204: BEGIN
2205:
2206: IF g_debug
2207: THEN
2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2209: hr_utility.trace('g_person_id '||g_person_id);
2210: hr_utility.trace('g_start_time '||g_start_time);
2211: hr_utility.trace('g_stop_time '||g_stop_time);
2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);

Line 2209: hr_utility.trace('g_person_id '||g_person_id);

2205:
2206: IF g_debug
2207: THEN
2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2209: hr_utility.trace('g_person_id '||g_person_id);
2210: hr_utility.trace('g_start_time '||g_start_time);
2211: hr_utility.trace('g_stop_time '||g_stop_time);
2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2213: END IF;

Line 2210: hr_utility.trace('g_start_time '||g_start_time);

2206: IF g_debug
2207: THEN
2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2209: hr_utility.trace('g_person_id '||g_person_id);
2210: hr_utility.trace('g_start_time '||g_start_time);
2211: hr_utility.trace('g_stop_time '||g_stop_time);
2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2213: END IF;
2214:

Line 2211: hr_utility.trace('g_stop_time '||g_stop_time);

2207: THEN
2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2209: hr_utility.trace('g_person_id '||g_person_id);
2210: hr_utility.trace('g_start_time '||g_start_time);
2211: hr_utility.trace('g_stop_time '||g_stop_time);
2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2213: END IF;
2214:
2215: -- Bug 8859290

Line 2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);

2208: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2209: hr_utility.trace('g_person_id '||g_person_id);
2210: hr_utility.trace('g_start_time '||g_start_time);
2211: hr_utility.trace('g_stop_time '||g_stop_time);
2212: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2213: END IF;
2214:
2215: -- Bug 8859290
2216: -- Removed lock_rowid condition.

Line 2250: hr_utility.trace('ABS : l_start '||l_start);

2246: OR l_stop <> TO_CHAR(p_stop_time,'hh24miss')
2247: THEN
2248: IF g_debug
2249: THEN
2250: hr_utility.trace('ABS : l_start '||l_start);
2251: hr_utility.trace('ABS : l_stop '||l_stop);
2252: END IF;
2253: RETURN;
2254: END IF;

Line 2251: hr_utility.trace('ABS : l_stop '||l_stop);

2247: THEN
2248: IF g_debug
2249: THEN
2250: hr_utility.trace('ABS : l_start '||l_start);
2251: hr_utility.trace('ABS : l_stop '||l_stop);
2252: END IF;
2253: RETURN;
2254: END IF;
2255: END IF;

Line 2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);

2290: BEGIN
2291:
2292: IF g_debug
2293: THEN
2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2295: hr_utility.trace('g_person_id '||g_person_id);
2296: hr_utility.trace('g_start_time '||g_start_time);
2297: hr_utility.trace('g_stop_time '||g_stop_time);
2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);

Line 2295: hr_utility.trace('g_person_id '||g_person_id);

2291:
2292: IF g_debug
2293: THEN
2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2295: hr_utility.trace('g_person_id '||g_person_id);
2296: hr_utility.trace('g_start_time '||g_start_time);
2297: hr_utility.trace('g_stop_time '||g_stop_time);
2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2299: END IF;

Line 2296: hr_utility.trace('g_start_time '||g_start_time);

2292: IF g_debug
2293: THEN
2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2295: hr_utility.trace('g_person_id '||g_person_id);
2296: hr_utility.trace('g_start_time '||g_start_time);
2297: hr_utility.trace('g_stop_time '||g_stop_time);
2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2299: END IF;
2300:

Line 2297: hr_utility.trace('g_stop_time '||g_stop_time);

2293: THEN
2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2295: hr_utility.trace('g_person_id '||g_person_id);
2296: hr_utility.trace('g_start_time '||g_start_time);
2297: hr_utility.trace('g_stop_time '||g_stop_time);
2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2299: END IF;
2300:
2301: SELECT ROWIDTOCHAR(ROWID),

Line 2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);

2294: hr_utility.trace('g_lock_rowid '||g_lock_row_id);
2295: hr_utility.trace('g_person_id '||g_person_id);
2296: hr_utility.trace('g_start_time '||g_start_time);
2297: hr_utility.trace('g_stop_time '||g_stop_time);
2298: hr_utility.trace('p_old_bb_id '||p_old_bb_id);
2299: END IF;
2300:
2301: SELECT ROWIDTOCHAR(ROWID),
2302: TO_CHAR(start_date,'hh24miss'),

Line 2537: hr_utility.trace('ABS : Calling delete_absences_in_tt ');

2533: LOOP
2534: BEGIN
2535: IF g_debug
2536: THEN
2537: hr_utility.trace('ABS : Calling delete_absences_in_tt ');
2538: hr_utility.trace('ABS: Deleting trans '||l_trans_tab(i));
2539: END IF;
2540:
2541: hr_person_absence_swi.delete_absences_in_tt(l_trans_tab(i));

Line 2538: hr_utility.trace('ABS: Deleting trans '||l_trans_tab(i));

2534: BEGIN
2535: IF g_debug
2536: THEN
2537: hr_utility.trace('ABS : Calling delete_absences_in_tt ');
2538: hr_utility.trace('ABS: Deleting trans '||l_trans_tab(i));
2539: END IF;
2540:
2541: hr_person_absence_swi.delete_absences_in_tt(l_trans_tab(i));
2542:

Line 2960: hr_utility.trace('User bbid is '||i);

2956: IF g_debug
2957: THEN
2958: i := p_usertab.FIRST;
2959: LOOP
2960: hr_utility.trace('User bbid is '||i);
2961: hr_utility.trace('User Element '||p_usertab(i).element_type_id);
2962: hr_utility.trace('User measure '||p_usertab(i).measure);
2963: hr_utility.trace('User Start_time '||p_usertab(i).start_time);
2964: i := p_usertab.NEXT(i);

Line 2961: hr_utility.trace('User Element '||p_usertab(i).element_type_id);

2957: THEN
2958: i := p_usertab.FIRST;
2959: LOOP
2960: hr_utility.trace('User bbid is '||i);
2961: hr_utility.trace('User Element '||p_usertab(i).element_type_id);
2962: hr_utility.trace('User measure '||p_usertab(i).measure);
2963: hr_utility.trace('User Start_time '||p_usertab(i).start_time);
2964: i := p_usertab.NEXT(i);
2965: EXIT WHEN NOT p_usertab.EXISTS(i);

Line 2962: hr_utility.trace('User measure '||p_usertab(i).measure);

2958: i := p_usertab.FIRST;
2959: LOOP
2960: hr_utility.trace('User bbid is '||i);
2961: hr_utility.trace('User Element '||p_usertab(i).element_type_id);
2962: hr_utility.trace('User measure '||p_usertab(i).measure);
2963: hr_utility.trace('User Start_time '||p_usertab(i).start_time);
2964: i := p_usertab.NEXT(i);
2965: EXIT WHEN NOT p_usertab.EXISTS(i);
2966: END LOOP;

Line 2963: hr_utility.trace('User Start_time '||p_usertab(i).start_time);

2959: LOOP
2960: hr_utility.trace('User bbid is '||i);
2961: hr_utility.trace('User Element '||p_usertab(i).element_type_id);
2962: hr_utility.trace('User measure '||p_usertab(i).measure);
2963: hr_utility.trace('User Start_time '||p_usertab(i).start_time);
2964: i := p_usertab.NEXT(i);
2965: EXIT WHEN NOT p_usertab.EXISTS(i);
2966: END LOOP;
2967: END IF;

Line 2989: hr_utility.trace('ABS:Its not equal -- there is a detail overlap ');

2985: END IF;
2986:
2987: IF abs_datetab IS NOT A SET
2988: THEN
2989: hr_utility.trace('ABS:Its not equal -- there is a detail overlap ');
2990: add_error_to_tc(p_messages,
2991: 'HXC_ABS_DET_OVERLAP',
2992: NULL,
2993: p_val_level);

Line 3002: hr_utility.trace('ABS:orig -'||abs_datetab(j));

2998: IF g_debug
2999: THEN
3000: FOR j IN abs_datetab.FIRST..abs_datetab.LAST
3001: LOOP
3002: hr_utility.trace('ABS:orig -'||abs_datetab(j));
3003: END LOOP;
3004: END IF;
3005: abs_datetab := SET(abs_datetab);
3006:

Line 3011: hr_utility.trace('ABS:Changed -'||abs_datetab(j));

3007: IF g_debug
3008: THEN
3009: FOR j IN abs_datetab.FIRST..abs_datetab.LAST
3010: LOOP
3011: hr_utility.trace('ABS:Changed -'||abs_datetab(j));
3012: END LOOP;
3013: END IF;
3014:
3015:

Line 3030: hr_utility.trace('ABS:There is a problem -- Overlap with HR');

3026: LOOP
3027: IF abs_datetab(j) BETWEEN l_starttab(i)
3028: AND l_endtab(i)
3029: THEN
3030: hr_utility.trace('ABS:There is a problem -- Overlap with HR');
3031: add_error_to_tc(p_messages,
3032: 'HXC_ABS_HR_OVERLAP',
3033: NULL,
3034: p_val_level);

Line 3076: hr_utility.trace('ABS:l_asg '||l_asg);

3072:
3073: l_asg := get_assignment_id(p_resource_id,
3074: p_start_time);
3075:
3076: hr_utility.trace('ABS:l_asg '||l_asg);
3077:
3078: IF TO_CHAR(p_start_time,'yyyy') = TO_CHAR(p_stop_time,'yyyy')
3079: THEN
3080:

Line 3151: hr_utility.trace(' l_total for '||i);

3147: LOOP
3148: EXIT WHEN NOT l_tottab.EXISTS(i);
3149: IF g_debug
3150: THEN
3151: hr_utility.trace(' l_total for '||i);
3152: END IF;
3153: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,
3154: i,
3155: l_asg);

Line 3158: hr_utility.trace(' l_balance '||l_bal);

3154: i,
3155: l_asg);
3156: IF g_debug
3157: THEN
3158: hr_utility.trace(' l_balance '||l_bal);
3159: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3160: END IF;
3161: IF l_bal < l_tottab(i)
3162: AND l_runtab(i) = 'D' -- Bug 9359368

Line 3159: hr_utility.trace(' l_tottab(i) '||l_tottab(i));

3155: l_asg);
3156: IF g_debug
3157: THEN
3158: hr_utility.trace(' l_balance '||l_bal);
3159: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3160: END IF;
3161: IF l_bal < l_tottab(i)
3162: AND l_runtab(i) = 'D' -- Bug 9359368
3163: THEN

Line 3164: hr_utility.trace('ABS:There is a problem with running total ');

3160: END IF;
3161: IF l_bal < l_tottab(i)
3162: AND l_runtab(i) = 'D' -- Bug 9359368
3163: THEN
3164: hr_utility.trace('ABS:There is a problem with running total ');
3165: add_error_to_tc(p_messages,
3166: 'HXC_ABS_RUN_TOTAL',
3167: NULL,
3168: p_val_level,

Line 3179: hr_utility.trace('There is a problem with pto ');

3175: p_start_time,
3176: l_tottab(i),
3177: l_tottab(i))
3178: THEN
3179: hr_utility.trace('There is a problem with pto ');
3180: add_error_to_tc(p_messages,
3181: 'HXC_ABS_PTO_NOT_ENTITLED',
3182: NULL,
3183: p_val_level,

Line 3194: hr_utility.trace('ABS : Year crossing over in the timecard period ');

3190:
3191:
3192:
3193: ELSE
3194: hr_utility.trace('ABS : Year crossing over in the timecard period ');
3195:
3196: i := p_usertab.FIRST;
3197: LOOP
3198: EXIT WHEN NOT p_usertab.EXISTS(i);

Line 3252: hr_utility.trace(' l_total for '||i);

3248: LOOP
3249: EXIT WHEN NOT l_tottab.EXISTS(i);
3250: IF g_debug
3251: THEN
3252: hr_utility.trace(' l_total for '||i);
3253: END IF;
3254: l_bal := per_absence_attendances_pkg.get_annual_balance(p_start_time,
3255: i,
3256: l_asg);

Line 3259: hr_utility.trace(' l_balance '||l_bal);

3255: i,
3256: l_asg);
3257: IF g_debug
3258: THEN
3259: hr_utility.trace(' l_balance '||l_bal);
3260: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3261: END IF;
3262: IF l_bal < l_tottab(i)
3263: AND l_runtab(i) = 'D' -- Bug 9359368

Line 3260: hr_utility.trace(' l_tottab(i) '||l_tottab(i));

3256: l_asg);
3257: IF g_debug
3258: THEN
3259: hr_utility.trace(' l_balance '||l_bal);
3260: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3261: END IF;
3262: IF l_bal < l_tottab(i)
3263: AND l_runtab(i) = 'D' -- Bug 9359368
3264: THEN

Line 3265: hr_utility.trace('ABS:There is a problem with running total ');

3261: END IF;
3262: IF l_bal < l_tottab(i)
3263: AND l_runtab(i) = 'D' -- Bug 9359368
3264: THEN
3265: hr_utility.trace('ABS:There is a problem with running total ');
3266: add_error_to_tc(p_messages,
3267: 'HXC_ABS_RUN_TOTAL',
3268: NULL,
3269: p_val_level,

Line 3280: hr_utility.trace('There is a problem with pto ');

3276: p_start_time,
3277: l_tottab(i),
3278: l_tottab(i))
3279: THEN
3280: hr_utility.trace('There is a problem with pto ');
3281: add_error_to_tc(p_messages,
3282: 'HXC_ABS_PTO_NOT_ENTITLED',
3283: NULL,
3284: p_val_level,

Line 3350: hr_utility.trace(' l_total for '||i);

3346: LOOP
3347: EXIT WHEN NOT l_tottab.EXISTS(i);
3348: IF g_debug
3349: THEN
3350: hr_utility.trace(' l_total for '||i);
3351: END IF;
3352: l_bal := per_absence_attendances_pkg.get_annual_balance(p_stop_time,
3353: i,
3354: l_asg);

Line 3357: hr_utility.trace(' l_balance '||l_bal);

3353: i,
3354: l_asg);
3355: IF g_debug
3356: THEN
3357: hr_utility.trace(' l_balance '||l_bal);
3358: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3359: END IF;
3360: IF l_bal < l_tottab(i)
3361: AND l_runtab(i) = 'D' -- Bug 9359368

Line 3358: hr_utility.trace(' l_tottab(i) '||l_tottab(i));

3354: l_asg);
3355: IF g_debug
3356: THEN
3357: hr_utility.trace(' l_balance '||l_bal);
3358: hr_utility.trace(' l_tottab(i) '||l_tottab(i));
3359: END IF;
3360: IF l_bal < l_tottab(i)
3361: AND l_runtab(i) = 'D' -- Bug 9359368
3362: THEN

Line 3363: hr_utility.trace('ABS:There is a problem with running total ');

3359: END IF;
3360: IF l_bal < l_tottab(i)
3361: AND l_runtab(i) = 'D' -- Bug 9359368
3362: THEN
3363: hr_utility.trace('ABS:There is a problem with running total ');
3364: add_error_to_tc(p_messages,
3365: 'HXC_ABS_RUN_TOTAL',
3366: NULL,
3367: p_val_level,

Line 3378: hr_utility.trace('There is a problem with pto ');

3374: p_stop_time,
3375: l_tottab(i),
3376: l_tottab(i))
3377: THEN
3378: hr_utility.trace('There is a problem with pto ');
3379: add_error_to_tc(p_messages,
3380: 'HXC_ABS_PTO_NOT_ENTITLED',
3381: NULL,
3382: p_val_level,

Line 3417: hr_utility.trace('p_lock_rowid '||p_lock_rowid);

3413:
3414:
3415: IF g_debug
3416: THEN
3417: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3418: i := p_blocks.FIRST;
3419: LOOP
3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);

Line 3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);

3416: THEN
3417: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3418: i := p_blocks.FIRST;
3419: LOOP
3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);

Line 3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);

3417: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3418: i := p_blocks.FIRST;
3419: LOOP
3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);

Line 3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);

3418: i := p_blocks.FIRST;
3419: LOOP
3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);
3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);

Line 3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);

3419: LOOP
3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);
3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3427: i:= p_blocks.NEXT(i);

Line 3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);

3420: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);
3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3427: i:= p_blocks.NEXT(i);
3428: EXIT WHEN NOT p_blocks.EXISTS(i);

Line 3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);

3421: hr_utility.trace('p_blocks(i).object_version_number '||p_blocks(i).object_version_number);
3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);
3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3427: i:= p_blocks.NEXT(i);
3428: EXIT WHEN NOT p_blocks.EXISTS(i);
3429: END LOOP;

Line 3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);

3422: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3423: hr_utility.trace('p_blocks(i).start_time '||p_blocks(i).start_time);
3424: hr_utility.trace('p_blocks(i).stop_time '||p_blocks(i).stop_time);
3425: hr_utility.trace('p_blocks(i).measure '||p_blocks(i).measure);
3426: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3427: i:= p_blocks.NEXT(i);
3428: EXIT WHEN NOT p_blocks.EXISTS(i);
3429: END LOOP;
3430:

Line 3433: hr_utility.trace('p_attributes(i).building_block_id '||p_attributes(i).building_block_id);

3429: END LOOP;
3430:
3431: i:= p_attributes.FIRST;
3432: LOOP
3433: hr_utility.trace('p_attributes(i).building_block_id '||p_attributes(i).building_block_id);
3434: hr_utility.trace('p_attributes(i).building_block_ovn '||p_attributes(i).building_block_ovn);
3435: hr_utility.trace('p_attributes(i).attribute_category '||p_attributes(i).attribute_category);
3436: hr_utility.trace('p_attributes(i).bld_blk_info_type '||p_attributes(i).bld_blk_info_type);
3437: i:= p_attributes.NEXT(i);

Line 3434: hr_utility.trace('p_attributes(i).building_block_ovn '||p_attributes(i).building_block_ovn);

3430:
3431: i:= p_attributes.FIRST;
3432: LOOP
3433: hr_utility.trace('p_attributes(i).building_block_id '||p_attributes(i).building_block_id);
3434: hr_utility.trace('p_attributes(i).building_block_ovn '||p_attributes(i).building_block_ovn);
3435: hr_utility.trace('p_attributes(i).attribute_category '||p_attributes(i).attribute_category);
3436: hr_utility.trace('p_attributes(i).bld_blk_info_type '||p_attributes(i).bld_blk_info_type);
3437: i:= p_attributes.NEXT(i);
3438: EXIT WHEN NOT p_blocks.EXISTS(i);

Line 3435: hr_utility.trace('p_attributes(i).attribute_category '||p_attributes(i).attribute_category);

3431: i:= p_attributes.FIRST;
3432: LOOP
3433: hr_utility.trace('p_attributes(i).building_block_id '||p_attributes(i).building_block_id);
3434: hr_utility.trace('p_attributes(i).building_block_ovn '||p_attributes(i).building_block_ovn);
3435: hr_utility.trace('p_attributes(i).attribute_category '||p_attributes(i).attribute_category);
3436: hr_utility.trace('p_attributes(i).bld_blk_info_type '||p_attributes(i).bld_blk_info_type);
3437: i:= p_attributes.NEXT(i);
3438: EXIT WHEN NOT p_blocks.EXISTS(i);
3439: END LOOP;

Line 3436: hr_utility.trace('p_attributes(i).bld_blk_info_type '||p_attributes(i).bld_blk_info_type);

3432: LOOP
3433: hr_utility.trace('p_attributes(i).building_block_id '||p_attributes(i).building_block_id);
3434: hr_utility.trace('p_attributes(i).building_block_ovn '||p_attributes(i).building_block_ovn);
3435: hr_utility.trace('p_attributes(i).attribute_category '||p_attributes(i).attribute_category);
3436: hr_utility.trace('p_attributes(i).bld_blk_info_type '||p_attributes(i).bld_blk_info_type);
3437: i:= p_attributes.NEXT(i);
3438: EXIT WHEN NOT p_blocks.EXISTS(i);
3439: END LOOP;
3440:

Line 3471: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);

3467: EXIT TO_CONTINUE_TO_NEXT_BLOCK;
3468: END IF;
3469: IF g_debug
3470: THEN
3471: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3472: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3473: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3474: END IF;
3475:

Line 3472: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);

3468: END IF;
3469: IF g_debug
3470: THEN
3471: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3472: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3473: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3474: END IF;
3475:
3476: IF p_blocks(i).scope = 'DAY'

Line 3473: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);

3469: IF g_debug
3470: THEN
3471: hr_utility.trace('p_blocks(i).time_building_block_id '||p_blocks(i).time_building_block_id);
3472: hr_utility.trace('p_blocks(i).date_to '||p_blocks(i).date_to);
3473: hr_utility.trace('p_blocks(i).scope '||p_blocks(i).scope);
3474: END IF;
3475:
3476: IF p_blocks(i).scope = 'DAY'
3477: THEN

Line 3505: hr_utility.trace('ABS Either no preferences or this is a template. Return');

3501:
3502:
3503: IF l_pref_table.COUNT = 0
3504: THEN
3505: hr_utility.trace('ABS Either no preferences or this is a template. Return');
3506: RETURN;
3507: END IF;
3508:
3509: i := l_pref_table.FIRST;

Line 3521: hr_utility.trace('Abs Integration disabled for this employee ');

3517: IF l_pref_table(i).attribute1 <> 'Y'
3518: THEN
3519: IF g_debug
3520: THEN
3521: hr_utility.trace('Abs Integration disabled for this employee ');
3522: END IF;
3523: -- Bug 8886949
3524: -- Need to return when integration preference is set to NO.
3525: RETURN;

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

3643:
3644:
3645: IF g_debug
3646: THEN
3647: hr_utility.trace('l_start_time '||l_start_time);
3648: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3649: hr_utility.trace('l_stop_time '||TO_CHAR(l_stop_time,'dd-mon-yyyy hh:mi:ss'));
3650: END IF;
3651:

Line 3648: hr_utility.trace('p_lock_rowid '||p_lock_rowid);

3644:
3645: IF g_debug
3646: THEN
3647: hr_utility.trace('l_start_time '||l_start_time);
3648: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3649: hr_utility.trace('l_stop_time '||TO_CHAR(l_stop_time,'dd-mon-yyyy hh:mi:ss'));
3650: END IF;
3651:
3652: IF l_cotab.COUNT >0

Line 3649: hr_utility.trace('l_stop_time '||TO_CHAR(l_stop_time,'dd-mon-yyyy hh:mi:ss'));

3645: IF g_debug
3646: THEN
3647: hr_utility.trace('l_start_time '||l_start_time);
3648: hr_utility.trace('p_lock_rowid '||p_lock_rowid);
3649: hr_utility.trace('l_stop_time '||TO_CHAR(l_stop_time,'dd-mon-yyyy hh:mi:ss'));
3650: END IF;
3651:
3652: IF l_cotab.COUNT >0
3653: THEN

Line 3674: hr_utility.trace('ABS: There is a validation prob');

3670: AND l_edit_prep = 'Y'
3671: THEN
3672: IF g_debug
3673: THEN
3674: hr_utility.trace('ABS: There is a validation prob');
3675: END IF;
3676: j := l_cotab.FIRST;
3677: LOOP
3678: IF NOT l_edit_tab.EXISTS(l_cotab(j).element_type_id)

Line 3690: hr_utility.trace('ABS: There is an error added');

3686: IF l_element = 'N'
3687: THEN
3688: IF g_debug
3689: THEN
3690: hr_utility.trace('ABS: There is an error added');
3691: END IF;
3692: add_error_to_tc(p_messages,
3693: 'HXC_ABS_VIEW_ONLY_NO_DELETE',
3694: l_cotab(j).time_building_block_id);

Line 3718: hr_utility.trace('No active details in this timecard, Return ');

3714: END IF;
3715:
3716: IF g_debug
3717: THEN
3718: hr_utility.trace('No active details in this timecard, Return ');
3719: END IF;
3720: RETURN;
3721: END IF;
3722:

Line 3727: hr_utility.trace('No abs elements in this timecard, Return ');

3723: IF l_edit_tab.COUNT = 0
3724: THEN
3725: IF g_debug
3726: THEN
3727: hr_utility.trace('No abs elements in this timecard, Return ');
3728: END IF;
3729: RETURN ;
3730: END IF;
3731:

Line 3739: hr_utility.trace('Element is '||i);

3735: i := l_edit_tab.FIRST;
3736: LOOP
3737: IF g_debug
3738: THEN
3739: hr_utility.trace('Element is '||i);
3740: hr_utility.trace('Edit is '||l_edit_tab(i));
3741: END IF;
3742: i := l_edit_tab.NEXT(i);
3743: EXIT WHEN NOT l_edit_tab.EXISTS(i);

Line 3740: hr_utility.trace('Edit is '||l_edit_tab(i));

3736: LOOP
3737: IF g_debug
3738: THEN
3739: hr_utility.trace('Element is '||i);
3740: hr_utility.trace('Edit is '||l_edit_tab(i));
3741: END IF;
3742: i := l_edit_tab.NEXT(i);
3743: EXIT WHEN NOT l_edit_tab.EXISTS(i);
3744: END LOOP;

Line 3750: hr_utility.trace('User bbid is '||i);

3746: i := l_usertab.FIRST;
3747: LOOP
3748: IF g_debug
3749: THEN
3750: hr_utility.trace('User bbid is '||i);
3751: hr_utility.trace('User Element '||l_usertab(i).element_type_id);
3752: hr_utility.trace('User measure '||l_usertab(i).measure);
3753: hr_utility.trace('User Start_time '||l_usertab(i).start_time);
3754: END IF;

Line 3751: hr_utility.trace('User Element '||l_usertab(i).element_type_id);

3747: LOOP
3748: IF g_debug
3749: THEN
3750: hr_utility.trace('User bbid is '||i);
3751: hr_utility.trace('User Element '||l_usertab(i).element_type_id);
3752: hr_utility.trace('User measure '||l_usertab(i).measure);
3753: hr_utility.trace('User Start_time '||l_usertab(i).start_time);
3754: END IF;
3755:

Line 3752: hr_utility.trace('User measure '||l_usertab(i).measure);

3748: IF g_debug
3749: THEN
3750: hr_utility.trace('User bbid is '||i);
3751: hr_utility.trace('User Element '||l_usertab(i).element_type_id);
3752: hr_utility.trace('User measure '||l_usertab(i).measure);
3753: hr_utility.trace('User Start_time '||l_usertab(i).start_time);
3754: END IF;
3755:
3756: i := l_usertab.NEXT(i);

Line 3753: hr_utility.trace('User Start_time '||l_usertab(i).start_time);

3749: THEN
3750: hr_utility.trace('User bbid is '||i);
3751: hr_utility.trace('User Element '||l_usertab(i).element_type_id);
3752: hr_utility.trace('User measure '||l_usertab(i).measure);
3753: hr_utility.trace('User Start_time '||l_usertab(i).start_time);
3754: END IF;
3755:
3756: i := l_usertab.NEXT(i);
3757: EXIT WHEN NOT l_usertab.EXISTS(i);

Line 3765: hr_utility.trace('Co bbid is '||i);

3761: IF l_cotab.COUNT > 0
3762: THEN
3763: i := l_cotab.FIRST;
3764: LOOP
3765: hr_utility.trace('Co bbid is '||i);
3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);

Line 3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);

3762: THEN
3763: i := l_cotab.FIRST;
3764: LOOP
3765: hr_utility.trace('Co bbid is '||i);
3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);
3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);

Line 3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);

3763: i := l_cotab.FIRST;
3764: LOOP
3765: hr_utility.trace('Co bbid is '||i);
3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);
3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);
3771: i := l_cotab.NEXT(i);

Line 3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);

3764: LOOP
3765: hr_utility.trace('Co bbid is '||i);
3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);
3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);
3771: i := l_cotab.NEXT(i);
3772: EXIT WHEN NOT l_cotab.EXISTS(i);

Line 3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);

3765: hr_utility.trace('Co bbid is '||i);
3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);
3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);
3771: i := l_cotab.NEXT(i);
3772: EXIT WHEN NOT l_cotab.EXISTS(i);
3773: END LOOP;

Line 3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);

3766: hr_utility.trace('CoElement '||l_cotab(i).element_type_id);
3767: hr_utility.trace('Comeasure '||l_cotab(i).measure);
3768: hr_utility.trace('CoStart_time '||l_cotab(i).start_time);
3769: hr_utility.trace('Co time bb id '||l_cotab(i).time_building_block_id);
3770: hr_utility.trace('Co Start_time '||l_cotab(i).start_time);
3771: i := l_cotab.NEXT(i);
3772: EXIT WHEN NOT l_cotab.EXISTS(i);
3773: END LOOP;
3774: END IF;

Line 3809: hr_utility.trace('l_edit_prep is set to '||l_edit_prep);

3805:
3806:
3807: IF g_debug
3808: THEN
3809: hr_utility.trace('l_edit_prep is set to '||l_edit_prep);
3810: END IF;
3811:
3812: IF l_cotab.COUNT > 0
3813: THEN

Line 3820: hr_utility.trace('CoElement '||l_cotab(j).element_type_id);

3816: << CONTINUE_TO_NEXT >>
3817: LOOP
3818: IF g_debug
3819: THEN
3820: hr_utility.trace('CoElement '||l_cotab(j).element_type_id);
3821: hr_utility.trace('Comeasure '||l_cotab(j).measure);
3822: hr_utility.trace('CoStart_time '||l_cotab(j).start_time);
3823: hr_utility.trace('Co time bb id '||l_cotab(j).time_building_block_id);
3824: END IF;

Line 3821: hr_utility.trace('Comeasure '||l_cotab(j).measure);

3817: LOOP
3818: IF g_debug
3819: THEN
3820: hr_utility.trace('CoElement '||l_cotab(j).element_type_id);
3821: hr_utility.trace('Comeasure '||l_cotab(j).measure);
3822: hr_utility.trace('CoStart_time '||l_cotab(j).start_time);
3823: hr_utility.trace('Co time bb id '||l_cotab(j).time_building_block_id);
3824: END IF;
3825:

Line 3822: hr_utility.trace('CoStart_time '||l_cotab(j).start_time);

3818: IF g_debug
3819: THEN
3820: hr_utility.trace('CoElement '||l_cotab(j).element_type_id);
3821: hr_utility.trace('Comeasure '||l_cotab(j).measure);
3822: hr_utility.trace('CoStart_time '||l_cotab(j).start_time);
3823: hr_utility.trace('Co time bb id '||l_cotab(j).time_building_block_id);
3824: END IF;
3825:
3826: IF NOT l_edit_tab.EXISTS(l_cotab(j).element_type_id)

Line 3823: hr_utility.trace('Co time bb id '||l_cotab(j).time_building_block_id);

3819: THEN
3820: hr_utility.trace('CoElement '||l_cotab(j).element_type_id);
3821: hr_utility.trace('Comeasure '||l_cotab(j).measure);
3822: hr_utility.trace('CoStart_time '||l_cotab(j).start_time);
3823: hr_utility.trace('Co time bb id '||l_cotab(j).time_building_block_id);
3824: END IF;
3825:
3826: IF NOT l_edit_tab.EXISTS(l_cotab(j).element_type_id)
3827: THEN

Line 3869: hr_utility.trace( 'There is a mismatch in prepopulated ');

3865: OR NVL(l_cotab(j).element_type_id,0) <> NVL(l_usertab(l_cotab(j).time_building_block_id).element_type_id,0)
3866: THEN
3867: IF g_debug
3868: THEN
3869: hr_utility.trace( 'There is a mismatch in prepopulated ');
3870: END IF;
3871: IF l_edit_prep = 'N'
3872: THEN
3873: l_message := 'HXC_ABS_NO_EDIT_PREP';

Line 3885: hr_utility.trace( 'There is no mismatch, this is just like prepopulated ');

3881: EXIT CONTINUE_TO_NEXT;
3882: ELSE
3883: IF g_debug
3884: THEN
3885: hr_utility.trace( 'There is no mismatch, this is just like prepopulated ');
3886: END IF;
3887: l_usertab.DELETE(l_cotab(j).time_building_block_id);
3888: EXIT CONTINUE_TO_NEXT;
3889: END IF;

Line 4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');

4012: l_rounding_rule := 'ROUND_TO_NEAREST';
4013: END IF;
4014:
4015: IF g_debug THEN
4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);

Line 4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');

4013: END IF;
4014:
4015: IF g_debug THEN
4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);

Line 4018: hr_utility.trace('ABS> l_precision ::'||l_precision);

4014:
4015: IF g_debug THEN
4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);

Line 4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);

4015: IF g_debug THEN
4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);
4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);

Line 4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);

4016: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);
4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);
4024: END IF;

Line 4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);

4017: hr_utility.trace('ABS> invoke logic to calculate absence hours and absence days');
4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);
4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);
4024: END IF;
4025:

Line 4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);

4018: hr_utility.trace('ABS> l_precision ::'||l_precision);
4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);
4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);
4024: END IF;
4025:
4026: l_abs_days := 0;

Line 4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);

4019: hr_utility.trace('ABS> l_rounding_rule ::'||l_rounding_rule);
4020: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4021: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4022: hr_utility.trace('ABS> l_abs_tot_tab.COUNT ::'||l_abs_tot_tab.COUNT);
4023: hr_utility.trace('ABS> p_messages.COUNT ::'||p_messages.COUNT);
4024: END IF;
4025:
4026: l_abs_days := 0;
4027: l_abs_hours := 0;

Line 4035: hr_utility.trace('ABS> In LOOP OF l_abs_tot_tab INDEX ::'||j);

4031: j := l_abs_tot_tab.FIRST;
4032: LOOP
4033:
4034: IF g_debug THEN
4035: hr_utility.trace('ABS> In LOOP OF l_abs_tot_tab INDEX ::'||j);
4036: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4037: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4038: END IF;
4039:

Line 4036: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'

4032: LOOP
4033:
4034: IF g_debug THEN
4035: hr_utility.trace('ABS> In LOOP OF l_abs_tot_tab INDEX ::'||j);
4036: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4037: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4038: END IF;
4039:
4040: IF l_uom_tab(l_abs_tot_tab(j).element_type_id) = 'DAYS'

Line 4044: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'

4040: IF l_uom_tab(l_abs_tot_tab(j).element_type_id) = 'DAYS'
4041: THEN
4042:
4043: IF g_debug THEN
4044: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4045: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4046: hr_utility.trace('ABS> l_abs_tot_tab(j).measure ::'||l_abs_tot_tab(j).measure);
4047: END IF;
4048:

Line 4046: hr_utility.trace('ABS> l_abs_tot_tab(j).measure ::'||l_abs_tot_tab(j).measure);

4042:
4043: IF g_debug THEN
4044: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4045: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4046: hr_utility.trace('ABS> l_abs_tot_tab(j).measure ::'||l_abs_tot_tab(j).measure);
4047: END IF;
4048:
4049: l_abs_days := l_abs_days +
4050: hxc_find_notify_aprs_pkg.apply_round_rule(

Line 4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'

4054: );
4055: ELSIF l_uom_tab(l_abs_tot_tab(j).element_type_id) = 'HOURS'
4056: THEN
4057: IF g_debug THEN
4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'

Line 4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);

4056: THEN
4057: IF g_debug THEN
4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'

Line 4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);

4057: IF g_debug THEN
4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));

Line 4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'

4058: hr_utility.trace('ABS> l_uom_tab(l_abs_tot_tab(j).element_type_id) ::'
4059: ||l_uom_tab(l_abs_tot_tab(j).element_type_id));
4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;

Line 4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'

4060: hr_utility.trace('ABS> l_abs_tot_tab(j).stop_time ::'||l_abs_tot_tab(j).stop_time);
4061: hr_utility.trace('ABS> l_abs_tot_tab(j).start_time ::'||l_abs_tot_tab(j).start_time);
4062: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time) ::'
4063: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).stop_time));
4064: hr_utility.trace('ABS> FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time ::'
4065: ||FND_DATE.CANONICAL_TO_DATE(l_abs_tot_tab(j).start_time));
4066: END IF;
4067:
4068: l_abs_hours := l_abs_hours +

Line 4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');

4080: END LOOP;
4081: END IF;
4082:
4083: IF g_debug THEN
4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);

Line 4085: hr_utility.trace('ABS> final values of absence hours and absence days');

4081: END IF;
4082:
4083: IF g_debug THEN
4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);

Line 4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);

4082:
4083: IF g_debug THEN
4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);

Line 4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);

4083: IF g_debug THEN
4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');

Line 4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);

4084: hr_utility.trace('ABS> In hxc_retrieve_absences.verify_view_only_absences');
4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');
4092: END IF;

Line 4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);

4085: hr_utility.trace('ABS> final values of absence hours and absence days');
4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');
4092: END IF;
4093:

Line 4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);

4086: hr_utility.trace('ABS> l_resource_id ::'||l_resource_id);
4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');
4092: END IF;
4093:
4094: update_absence_summary_row(l_resource_id,

Line 4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');

4087: hr_utility.trace('ABS> l_start_time ::'||l_start_time);
4088: hr_utility.trace('ABS> l_stop_time ::'||l_stop_time);
4089: hr_utility.trace('ABS> l_abs_days ::'||l_abs_days);
4090: hr_utility.trace('ABS> l_abs_hours ::'||l_abs_hours);
4091: hr_utility.trace('ABS> now invoke update_absence_summary_row');
4092: END IF;
4093:
4094: update_absence_summary_row(l_resource_id,
4095: l_start_time,

Line 4276: hr_utility.trace('ABS : Time entry layout '||l_attribute1);

4272: l_attribute2 := g_pref_table(i).attribute2;
4273: l_attribute3 := g_pref_table(i).attribute3;
4274: IF g_debug
4275: THEN
4276: hr_utility.trace('ABS : Time entry layout '||l_attribute1);
4277: hr_utility.trace('ABS : Review layout '||l_attribute2);
4278: hr_utility.trace('ABS : Confirmation layout '||l_attribute3);
4279: END IF;
4280: EXIT;

Line 4277: hr_utility.trace('ABS : Review layout '||l_attribute2);

4273: l_attribute3 := g_pref_table(i).attribute3;
4274: IF g_debug
4275: THEN
4276: hr_utility.trace('ABS : Time entry layout '||l_attribute1);
4277: hr_utility.trace('ABS : Review layout '||l_attribute2);
4278: hr_utility.trace('ABS : Confirmation layout '||l_attribute3);
4279: END IF;
4280: EXIT;
4281: END IF;

Line 4278: hr_utility.trace('ABS : Confirmation layout '||l_attribute3);

4274: IF g_debug
4275: THEN
4276: hr_utility.trace('ABS : Time entry layout '||l_attribute1);
4277: hr_utility.trace('ABS : Review layout '||l_attribute2);
4278: hr_utility.trace('ABS : Confirmation layout '||l_attribute3);
4279: END IF;
4280: EXIT;
4281: END IF;
4282: END LOOP;

Line 4474: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element');

4470: IS
4471:
4472: BEGIN
4473: IF g_debug THEN
4474: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element');
4475: hr_utility.trace('ABS> p_alias_value_id ::'||p_alias_value_id);
4476: END IF;
4477:
4478: SELECT 'Y'

Line 4475: hr_utility.trace('ABS> p_alias_value_id ::'||p_alias_value_id);

4471:
4472: BEGIN
4473: IF g_debug THEN
4474: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element');
4475: hr_utility.trace('ABS> p_alias_value_id ::'||p_alias_value_id);
4476: END IF;
4477:
4478: SELECT 'Y'
4479: INTO p_absence_element_flag

Line 4485: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);

4481: WHERE element_type_id in ( SELECT attribute1
4482: FROM hxc_alias_values
4483: WHERE alias_value_id = p_alias_value_id);
4484: IF g_debug THEN
4485: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4486: END IF;
4487:
4488: EXCEPTION
4489: WHEN NO_DATA_FOUND THEN

Line 4492: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception NO_DATA_FOUND');

4488: EXCEPTION
4489: WHEN NO_DATA_FOUND THEN
4490: p_absence_element_flag := 'N';
4491: IF g_debug THEN
4492: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception NO_DATA_FOUND');
4493: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4494: END IF;
4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';

Line 4493: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);

4489: WHEN NO_DATA_FOUND THEN
4490: p_absence_element_flag := 'N';
4491: IF g_debug THEN
4492: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception NO_DATA_FOUND');
4493: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4494: END IF;
4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';
4497: IF g_debug THEN

Line 4498: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception TOO_MANY_ROWS');

4494: END IF;
4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';
4497: IF g_debug THEN
4498: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception TOO_MANY_ROWS');
4499: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4500: END IF;
4501:
4502: END is_absence_element;

Line 4499: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);

4495: WHEN TOO_MANY_ROWS THEN
4496: p_absence_element_flag := 'Y';
4497: IF g_debug THEN
4498: hr_utility.trace('ABS> In hxc_retrieve_absences.is_absence_element -- exception TOO_MANY_ROWS');
4499: hr_utility.trace('ABS> p_absence_element_flag ::'||p_absence_element_flag);
4500: END IF;
4501:
4502: END is_absence_element;
4503: