APPS.HXC_ABS_INTG_PKG dependencies on HR_UTILITY

Line 4: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXC_ABS_INTG_PKG as
2: /* $Header: hxcabsint.pkb 120.1.12010000.8 2009/10/15 06:23:37 sabvenug noship $ */
3:
4: g_debug boolean := hr_utility.debug_enabled;
5:
6: PROCEDURE HXC_TC_CHECK (p_resource_id IN VARCHAR2,
7: p_start_time IN DATE,
8: p_stop_time IN DATE,

Line 49: hr_utility.trace('Entered HXC_TC_CHECK');

45: BEGIN
46:
47: -- Timecard Summary check
48: if g_debug then
49: hr_utility.trace('Entered HXC_TC_CHECK');
50: end if;
51:
52:
53: open tc_sum_check(p_resource_id,

Line 64: hr_utility.trace('p_tc_sum_exists is TRUE');

60:
61: p_tc_sum_exists := TRUE;
62:
63: if g_debug then
64: hr_utility.trace('p_tc_sum_exists is TRUE');
65: end if;
66:
67: ELSE
68:

Line 72: hr_utility.trace('p_tc_sum_exists is FALSE');

68:
69: p_tc_sum_exists := FALSE;
70:
71: if g_debug then
72: hr_utility.trace('p_tc_sum_exists is FALSE');
73: end if;
74:
75: END IF;
76:

Line 95: hr_utility.trace('p_tc_sum_exists is TRUE');

91:
92: p_tc_lock_exists := TRUE;
93:
94: if g_debug then
95: hr_utility.trace('p_tc_sum_exists is TRUE');
96: end if;
97:
98: ELSE
99:

Line 103: hr_utility.trace('p_tc_sum_exists is FALSE');

99:
100: p_tc_lock_exists := FALSE;
101:
102: if g_debug then
103: hr_utility.trace('p_tc_sum_exists is FALSE');
104: end if;
105:
106: END IF;
107:

Line 111: hr_utility.trace('Leaving HXC_TC_CHECK');

107:
108: CLOSE tc_lock_check;
109:
110: if g_debug then
111: hr_utility.trace('Leaving HXC_TC_CHECK');
112: end if;
113:
114: END; -- hxc_tc_check
115:

Line 157: hr_utility.trace('Entered otl_timecard_chk');

153:
154: BEGIN
155:
156: if g_debug then
157: hr_utility.trace('Entered otl_timecard_chk');
158: end if;
159:
160: OPEN abs_att_id_check(p_abs_att_id);
161: FETCH abs_att_id_check into l_abs_att_id_count;

Line 168: hr_utility.trace('Profile Value = '|| l_profile_set );

164:
165: l_profile_set:= NVL(fnd_profile.value('HR_ABS_OTL_INTEGRATION'),'N');
166:
167: if g_debug then
168: hr_utility.trace('Profile Value = '|| l_profile_set );
169: end if;
170:
171:
172: IF l_profile_set<>'Y' then

Line 179: hr_utility.trace(' No OTL Intg Profile Set');

175: p_error_code:= 'HR OTL Integration Profile Not set';
176:
177:
178: if g_debug then
179: hr_utility.trace(' No OTL Intg Profile Set');
180: end if;
181:
182:
183: ELSE

Line 186: hr_utility.trace('Going to call OTL Pref');

182:
183: ELSE
184:
185: if g_debug then
186: hr_utility.trace('Going to call OTL Pref');
187: end if;
188:
189: hxc_preference_evaluation.resource_preferences
190: (p_person_id,

Line 196: hr_utility.trace('Came out of OTL Pref');

192: p_start_time,
193: l_pref_table);
194:
195: if g_debug then
196: hr_utility.trace('Came out of OTL Pref');
197: end if;
198:
199: l_pref_index := l_pref_table.FIRST;
200: LOOP

Line 212: hr_utility.trace('OTL Pref Setting for this resource = '||l_pref_set);

208: EXIT WHEN NOT l_pref_table.EXISTS(l_pref_index);
209: END LOOP;
210:
211: if g_debug then
212: hr_utility.trace('OTL Pref Setting for this resource = '||l_pref_set);
213: end if;
214:
215: IF l_pref_set <>'Y' then
216:

Line 221: hr_utility.trace('No OTL Pref');

217: p_error_level:=0;
218: p_error_code:= 'No OTL Absence Preferences';
219:
220: if g_debug then
221: hr_utility.trace('No OTL Pref');
222: end if;
223:
224: ELSE
225:

Line 233: hr_utility.trace('Came out of hxc_tc_check');

229: p_tc_sum_exists => l_tc_sum_exists,
230: p_tc_lock_exists => l_tc_lock_exists);
231:
232: if g_debug then
233: hr_utility.trace('Came out of hxc_tc_check');
234: end if;
235:
236:
237: if p_start_time > p_stop_time then

Line 243: hr_utility.trace('p_error_level1 = '||p_error_level);

239: p_error_level:=-1;
240: p_error_code:='Error: Start Date Greater than End Date';
241:
242: if g_debug then
243: hr_utility.trace('p_error_level1 = '||p_error_level);
244: end if;
245:
246: elsif (l_tc_lock_exists) then
247:

Line 252: hr_utility.trace('p_error_level2 = '||p_error_level);

248: p_error_level:=2;
249: p_error_code:= 'OTL Timecard is locked';
250:
251: if g_debug then
252: hr_utility.trace('p_error_level2 = '||p_error_level);
253: end if;
254:
255: ELSIF (l_tc_sum_exists) then
256:

Line 261: hr_utility.trace('p_error_level3 = '||p_error_level);

257: p_error_level:=1;
258: p_error_code:= 'OTL Timecard Exists';
259:
260: if g_debug then
261: hr_utility.trace('p_error_level3 = '||p_error_level);
262: end if;
263:
264: ELSE
265:

Line 270: hr_utility.trace('p_error_level4 = '||p_error_level);

266: p_error_level:=0;
267: p_error_code:='No OTL Timecard Exists';
268:
269: if g_debug then
270: hr_utility.trace('p_error_level4 = '||p_error_level);
271: end if;
272:
273: END IF; -- l_tc_lock_exists and l_tc_sum_exists
274:

Line 292: hr_utility.trace('Leaving otl_timecard_chk');

288:
289:
290:
291: if g_debug then
292: hr_utility.trace('Leaving otl_timecard_chk');
293: end if;
294:
295: END; --otl_timecard_chk ;
296: