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

Line 5: g_debug BOOLEAN := hr_utility.debug_enabled;

1: PACKAGE BODY hxc_absence_type_alias AS
2: /* $Header: hxcabstypealias.pkb 120.0.12010000.9 2010/01/07 13:55:51 amakrish noship $ */
3:
4: g_package varchar2(30) := 'hxc_absence_type_alias.';
5: g_debug BOOLEAN := hr_utility.debug_enabled;
6:
7: PROCEDURE ins_otl_abs_type_elements_temp(p_tc_abs_type_alias_def_id IN hxc_alias_definitions_tl.alias_definition_id%TYPE,
8: p_tc_abs_payroll_id IN pay_payrolls_f.payroll_id%TYPE,
9: p_tc_abs_element_set_id IN pay_element_sets_tl.element_set_id%TYPE,

Line 22: g_debug := hr_utility.debug_enabled;

18: l_proc VARCHAR2(100);
19:
20: BEGIN
21:
22: g_debug := hr_utility.debug_enabled;
23:
24: IF g_debug THEN
25: l_proc := g_package||'ins_otl_abs_type_elements_temp';
26: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 26: hr_utility.set_location('ABS:Processing '||l_proc, 10);

22: g_debug := hr_utility.debug_enabled;
23:
24: IF g_debug THEN
25: l_proc := g_package||'ins_otl_abs_type_elements_temp';
26: hr_utility.set_location('ABS:Processing '||l_proc, 10);
27: END IF;
28:
29: l_tc_abs_type_alias_def_id := p_tc_abs_type_alias_def_id;
30: l_tc_abs_payroll_id := p_tc_abs_payroll_id;

Line 36: hr_utility.trace('ABS:l_tc_abs_type_alias_def_id ::'||l_tc_abs_type_alias_def_id);

32: l_tc_abs_absence_type_id := p_tc_abs_absence_type_id;
33:
34:
35: IF g_debug THEN
36: hr_utility.trace('ABS:l_tc_abs_type_alias_def_id ::'||l_tc_abs_type_alias_def_id);
37: hr_utility.trace('ABS:l_tc_abs_payroll_id ::'||l_tc_abs_payroll_id);
38: hr_utility.trace('ABS:l_tc_abs_element_set_id ::'||l_tc_abs_element_set_id);
39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);
40: END IF;

Line 37: hr_utility.trace('ABS:l_tc_abs_payroll_id ::'||l_tc_abs_payroll_id);

33:
34:
35: IF g_debug THEN
36: hr_utility.trace('ABS:l_tc_abs_type_alias_def_id ::'||l_tc_abs_type_alias_def_id);
37: hr_utility.trace('ABS:l_tc_abs_payroll_id ::'||l_tc_abs_payroll_id);
38: hr_utility.trace('ABS:l_tc_abs_element_set_id ::'||l_tc_abs_element_set_id);
39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);
40: END IF;
41:

Line 38: hr_utility.trace('ABS:l_tc_abs_element_set_id ::'||l_tc_abs_element_set_id);

34:
35: IF g_debug THEN
36: hr_utility.trace('ABS:l_tc_abs_type_alias_def_id ::'||l_tc_abs_type_alias_def_id);
37: hr_utility.trace('ABS:l_tc_abs_payroll_id ::'||l_tc_abs_payroll_id);
38: hr_utility.trace('ABS:l_tc_abs_element_set_id ::'||l_tc_abs_element_set_id);
39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);
40: END IF;
41:
42:

Line 39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);

35: IF g_debug THEN
36: hr_utility.trace('ABS:l_tc_abs_type_alias_def_id ::'||l_tc_abs_type_alias_def_id);
37: hr_utility.trace('ABS:l_tc_abs_payroll_id ::'||l_tc_abs_payroll_id);
38: hr_utility.trace('ABS:l_tc_abs_element_set_id ::'||l_tc_abs_element_set_id);
39: hr_utility.trace('ABS:l_tc_abs_absence_type_id ::'||l_tc_abs_absence_type_id);
40: END IF;
41:
42:
43: DELETE FROM hxc_absence_type_elements_temp;

Line 85: hr_utility.set_location('ABS:Processing '||l_proc, 20);

81: AND paat.business_group_id = petf.business_group_id
82: AND paat.business_group_id = fnd_profile.value('PER_BUSINESS_GROUP_ID'));
83:
84: IF g_debug THEN
85: hr_utility.set_location('ABS:Processing '||l_proc, 20);
86: END IF;
87:
88:
89: IF l_tc_abs_type_alias_def_id IS NOT NULL THEN

Line 106: hr_utility.set_location('ABS:Processing '||l_proc, 30);

102:
103: END IF;
104:
105: IF g_debug THEN
106: hr_utility.set_location('ABS:Processing '||l_proc, 30);
107: END IF;
108:
109: IF l_tc_abs_payroll_id IS NOT NULL THEN
110:

Line 138: hr_utility.set_location('ABS:Processing '||l_proc, 40);

134:
135: END IF;
136:
137: IF g_debug THEN
138: hr_utility.set_location('ABS:Processing '||l_proc, 40);
139: END IF;
140:
141: IF l_tc_abs_absence_type_id IS NOT NULL THEN
142:

Line 157: hr_utility.set_location('ABS:Processing '||l_proc, 50);

153:
154: END IF;
155:
156: IF g_debug THEN
157: hr_utility.set_location('ABS:Processing '||l_proc, 50);
158: END IF;
159:
160:
161: COMMIT;

Line 182: g_debug := hr_utility.debug_enabled;

178: l_proc VARCHAR2(100);
179:
180: BEGIN
181:
182: g_debug := hr_utility.debug_enabled;
183:
184: IF g_debug THEN
185: l_proc := g_package||'create_alias_definition';
186: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 186: hr_utility.set_location('ABS:Processing '||l_proc, 10);

182: g_debug := hr_utility.debug_enabled;
183:
184: IF g_debug THEN
185: l_proc := g_package||'create_alias_definition';
186: hr_utility.set_location('ABS:Processing '||l_proc, 10);
187: END IF;
188:
189: l_alias_definition_name := p_alias_definition_name;
190:

Line 192: hr_utility.trace('ABS:l_alias_definition_name ::'||l_alias_definition_name);

188:
189: l_alias_definition_name := p_alias_definition_name;
190:
191: IF g_debug THEN
192: hr_utility.trace('ABS:l_alias_definition_name ::'||l_alias_definition_name);
193: END IF;
194:
195: SELECT alias_type_id
196: INTO l_alias_type_id

Line 202: hr_utility.set_location('ABS:Processing '||l_proc, 20);

198: WHERE alias_type = 'OTL_ALT_DDF'
199: AND reference_object = 'PAYROLL_ELEMENTS';
200:
201: IF g_debug THEN
202: hr_utility.set_location('ABS:Processing '||l_proc, 20);
203: hr_utility.trace('ABS:l_alias_type_id ::'||l_alias_type_id);
204: END IF;
205:
206: BEGIN

Line 203: hr_utility.trace('ABS:l_alias_type_id ::'||l_alias_type_id);

199: AND reference_object = 'PAYROLL_ELEMENTS';
200:
201: IF g_debug THEN
202: hr_utility.set_location('ABS:Processing '||l_proc, 20);
203: hr_utility.trace('ABS:l_alias_type_id ::'||l_alias_type_id);
204: END IF;
205:
206: BEGIN
207:

Line 215: hr_utility.set_location('ABS:Processing '||l_proc, 30);

211: WHERE alias_definition_name = l_alias_definition_name
212: AND LANGUAGE = userenv('LANG');
213:
214: IF g_debug THEN
215: hr_utility.set_location('ABS:Processing '||l_proc, 30);
216: END IF;
217:
218:
219: EXCEPTION

Line 224: hr_utility.set_location('ABS:Processing '||l_proc, 40);

220:
221: WHEN NO_DATA_FOUND THEN
222:
223: IF g_debug THEN
224: hr_utility.set_location('ABS:Processing '||l_proc, 40);
225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');
226: END IF;
227:
228: l_exists := 'N';

Line 225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');

221: WHEN NO_DATA_FOUND THEN
222:
223: IF g_debug THEN
224: hr_utility.set_location('ABS:Processing '||l_proc, 40);
225: hr_utility.trace('ABS:Calling hxc_alias_definitions_api.create_alias_definition procedure.');
226: END IF;
227:
228: l_exists := 'N';
229: hxc_alias_definitions_api.create_alias_definition(p_alias_definition_id => p_alias_definition_id,

Line 240: hr_utility.trace('ABS:End of hxc_alias_definitions_api.create_alias_definition procedure.');

236: p_prompt => 'Hours Type'
237: );
238:
239: IF g_debug THEN
240: hr_utility.trace('ABS:End of hxc_alias_definitions_api.create_alias_definition procedure.');
241: hr_utility.set_location('ABS:Processing '||l_proc, 50);
242: END IF;
243:
244: END;

Line 241: hr_utility.set_location('ABS:Processing '||l_proc, 50);

237: );
238:
239: IF g_debug THEN
240: hr_utility.trace('ABS:End of hxc_alias_definitions_api.create_alias_definition procedure.');
241: hr_utility.set_location('ABS:Processing '||l_proc, 50);
242: END IF;
243:
244: END;
245:

Line 249: hr_utility.trace('ABS:p_alias_definition_name_exists ::'||p_alias_definition_name_exists);

245:
246: p_alias_definition_name_exists := l_exists;
247:
248: IF g_debug THEN
249: hr_utility.trace('ABS:p_alias_definition_name_exists ::'||p_alias_definition_name_exists);
250: hr_utility.set_location('ABS:Processing '||l_proc, 60);
251: END IF;
252:
253: END create_alias_definition;

Line 250: hr_utility.set_location('ABS:Processing '||l_proc, 60);

246: p_alias_definition_name_exists := l_exists;
247:
248: IF g_debug THEN
249: hr_utility.trace('ABS:p_alias_definition_name_exists ::'||p_alias_definition_name_exists);
250: hr_utility.set_location('ABS:Processing '||l_proc, 60);
251: END IF;
252:
253: END create_alias_definition;
254:

Line 270: g_debug := hr_utility.debug_enabled;

266: l_proc VARCHAR2(100);
267:
268: BEGIN
269:
270: g_debug := hr_utility.debug_enabled;
271:
272: IF g_debug THEN
273: l_proc := g_package||'create_alias_value';
274: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 274: hr_utility.set_location('ABS:Processing '||l_proc, 10);

270: g_debug := hr_utility.debug_enabled;
271:
272: IF g_debug THEN
273: l_proc := g_package||'create_alias_value';
274: hr_utility.set_location('ABS:Processing '||l_proc, 10);
275: END IF;
276:
277: l_alias_value_name := p_alias_value_name;
278: p_alias_value_name_exists := 'N';

Line 281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);

277: l_alias_value_name := p_alias_value_name;
278: p_alias_value_name_exists := 'N';
279:
280: IF g_debug THEN
281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);
282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);
283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);
284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);
285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);

Line 282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);

278: p_alias_value_name_exists := 'N';
279:
280: IF g_debug THEN
281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);
282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);
283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);
284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);
285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);
286: END IF;

Line 283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);

279:
280: IF g_debug THEN
281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);
282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);
283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);
284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);
285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);
286: END IF;
287:

Line 284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);

280: IF g_debug THEN
281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);
282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);
283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);
284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);
285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);
286: END IF;
287:
288: BEGIN

Line 285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);

281: hr_utility.trace('ABS:l_alias_value_name ::'||l_alias_value_name);
282: hr_utility.trace('ABS:p_alias_definition_id ::'||p_alias_definition_id);
283: hr_utility.trace('ABS:p_attribute1 ::'||p_attribute1);
284: hr_utility.trace('ABS:p_date_from ::'||p_date_from);
285: hr_utility.trace('ABS:p_date_to ::'||p_date_to);
286: END IF;
287:
288: BEGIN
289:

Line 301: hr_utility.set_location('ABS:Processing '||l_proc, 20);

297: AND hav.alias_definition_id = p_alias_definition_id
298: AND havt.LANGUAGE = userenv('LANG');
299:
300: IF g_debug THEN
301: hr_utility.set_location('ABS:Processing '||l_proc, 20);
302: hr_utility.trace('ABS:p_alias_value_name_exists ::'||p_alias_value_name_exists);
303: END IF;
304:
305: IF p_alias_value_name_exists = 'Y' THEN

Line 302: hr_utility.trace('ABS:p_alias_value_name_exists ::'||p_alias_value_name_exists);

298: AND havt.LANGUAGE = userenv('LANG');
299:
300: IF g_debug THEN
301: hr_utility.set_location('ABS:Processing '||l_proc, 20);
302: hr_utility.trace('ABS:p_alias_value_name_exists ::'||p_alias_value_name_exists);
303: END IF;
304:
305: IF p_alias_value_name_exists = 'Y' THEN
306:

Line 320: hr_utility.set_location('ABS:Processing '||l_proc, 30);

316: AND hav.alias_definition_id = p_alias_definition_id
317: AND havt.LANGUAGE = userenv('LANG');
318:
319: IF g_debug THEN
320: hr_utility.set_location('ABS:Processing '||l_proc, 30);
321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;

Line 321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);

317: AND havt.LANGUAGE = userenv('LANG');
318:
319: IF g_debug THEN
320: hr_utility.set_location('ABS:Processing '||l_proc, 30);
321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;
325:

Line 322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);

318:
319: IF g_debug THEN
320: hr_utility.set_location('ABS:Processing '||l_proc, 30);
321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;
325:
326: hxc_alias_values_api.update_alias_value(p_alias_value_id => l_alias_value_id,

Line 323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');

319: IF g_debug THEN
320: hr_utility.set_location('ABS:Processing '||l_proc, 30);
321: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
322: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
323: hr_utility.trace('ABS:Calling hxc_alias_values_api.update_alias_value procedure.');
324: END IF;
325:
326: hxc_alias_values_api.update_alias_value(p_alias_value_id => l_alias_value_id,
327: p_alias_value_name => l_alias_value_name,

Line 337: hr_utility.trace('ABS:End of hxc_alias_values_api.update_alias_value procedure.');

333: p_date_to => to_date(p_date_to,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
334: p_object_version_number => l_alias_value_id_ovn);
335:
336: IF g_debug THEN
337: hr_utility.trace('ABS:End of hxc_alias_values_api.update_alias_value procedure.');
338: hr_utility.set_location('ABS:Processing '||l_proc, 40);
339: END IF;
340:
341:

Line 338: hr_utility.set_location('ABS:Processing '||l_proc, 40);

334: p_object_version_number => l_alias_value_id_ovn);
335:
336: IF g_debug THEN
337: hr_utility.trace('ABS:End of hxc_alias_values_api.update_alias_value procedure.');
338: hr_utility.set_location('ABS:Processing '||l_proc, 40);
339: END IF;
340:
341:
342: END IF;

Line 349: hr_utility.set_location('ABS:Processing '||l_proc, 50);

345:
346: WHEN NO_DATA_FOUND THEN
347:
348: IF g_debug THEN
349: hr_utility.set_location('ABS:Processing '||l_proc, 50);
350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;

Line 350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);

346: WHEN NO_DATA_FOUND THEN
347:
348: IF g_debug THEN
349: hr_utility.set_location('ABS:Processing '||l_proc, 50);
350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;
354:

Line 351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);

347:
348: IF g_debug THEN
349: hr_utility.set_location('ABS:Processing '||l_proc, 50);
350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;
354:
355: hxc_alias_values_api.create_alias_value(p_alias_value_id => l_alias_value_id,

Line 352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');

348: IF g_debug THEN
349: hr_utility.set_location('ABS:Processing '||l_proc, 50);
350: hr_utility.trace('ABS:l_alias_value_id ::'||l_alias_value_id);
351: hr_utility.trace('ABS:l_alias_value_id_ovn ::'||l_alias_value_id_ovn);
352: hr_utility.trace('ABS:Calling hxc_alias_values_api.create_alias_value procedure.');
353: END IF;
354:
355: hxc_alias_values_api.create_alias_value(p_alias_value_id => l_alias_value_id,
356: p_alias_value_name => l_alias_value_name,

Line 366: hr_utility.trace('ABS:End of hxc_alias_values_api.create_alias_value procedure.');

362: p_date_to => to_date(p_date_to,FND_PROFILE.VALUE('ICX_DATE_FORMAT_MASK')),
363: p_object_version_number => l_alias_value_id_ovn);
364:
365: IF g_debug THEN
366: hr_utility.trace('ABS:End of hxc_alias_values_api.create_alias_value procedure.');
367: hr_utility.set_location('ABS:Processing '||l_proc, 60);
368: END IF;
369:
370: END;

Line 367: hr_utility.set_location('ABS:Processing '||l_proc, 60);

363: p_object_version_number => l_alias_value_id_ovn);
364:
365: IF g_debug THEN
366: hr_utility.trace('ABS:End of hxc_alias_values_api.create_alias_value procedure.');
367: hr_utility.set_location('ABS:Processing '||l_proc, 60);
368: END IF;
369:
370: END;
371:

Line 408: g_debug := hr_utility.debug_enabled;

404: l_proc VARCHAR2(100);
405:
406: BEGIN
407:
408: g_debug := hr_utility.debug_enabled;
409:
410: IF g_debug THEN
411: l_proc := g_package||'create_time_category';
412: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 412: hr_utility.set_location('ABS:Processing '||l_proc, 10);

408: g_debug := hr_utility.debug_enabled;
409:
410: IF g_debug THEN
411: l_proc := g_package||'create_time_category';
412: hr_utility.set_location('ABS:Processing '||l_proc, 10);
413: END IF;
414:
415: IF g_debug THEN
416: hr_utility.trace('ABS:p_time_category_name ::'||p_time_category_name);

Line 416: hr_utility.trace('ABS:p_time_category_name ::'||p_time_category_name);

412: hr_utility.set_location('ABS:Processing '||l_proc, 10);
413: END IF;
414:
415: IF g_debug THEN
416: hr_utility.trace('ABS:p_time_category_name ::'||p_time_category_name);
417: hr_utility.trace('ABS:p_description ::'||p_description);
418: END IF;
419:
420: BEGIN

Line 417: hr_utility.trace('ABS:p_description ::'||p_description);

413: END IF;
414:
415: IF g_debug THEN
416: hr_utility.trace('ABS:p_time_category_name ::'||p_time_category_name);
417: hr_utility.trace('ABS:p_description ::'||p_description);
418: END IF;
419:
420: BEGIN
421:

Line 428: hr_utility.set_location('ABS:Processing '||l_proc, 20);

424: FROM hxc_time_categories
425: WHERE time_category_name = p_time_category_name;
426:
427: IF g_debug THEN
428: hr_utility.set_location('ABS:Processing '||l_proc, 20);
429: END IF;
430:
431:
432: EXCEPTION

Line 437: hr_utility.set_location('ABS:Processing '||l_proc, 30);

433:
434: WHEN NO_DATA_FOUND THEN
435:
436: IF g_debug THEN
437: hr_utility.set_location('ABS:Processing '||l_proc, 30);
438: hr_utility.trace('ABS:Calling hxc_time_category_api.create_time_category procedure.');
439: END IF;
440:
441: l_exists := 'N';

Line 438: hr_utility.trace('ABS:Calling hxc_time_category_api.create_time_category procedure.');

434: WHEN NO_DATA_FOUND THEN
435:
436: IF g_debug THEN
437: hr_utility.set_location('ABS:Processing '||l_proc, 30);
438: hr_utility.trace('ABS:Calling hxc_time_category_api.create_time_category procedure.');
439: END IF;
440:
441: l_exists := 'N';
442: hxc_time_category_api.create_time_category

Line 451: hr_utility.trace('ABS:Completed hxc_time_category_api.create_time_category procedure.');

447: ,p_description => p_description
448: ,p_display => 'Y');
449:
450: IF g_debug THEN
451: hr_utility.trace('ABS:Completed hxc_time_category_api.create_time_category procedure.');
452: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
453: hr_utility.trace('ABS:p_object_version_number ::'||p_object_version_number);
454: hr_utility.set_location('ABS:Processing '||l_proc, 40);
455: END IF;

Line 452: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);

448: ,p_display => 'Y');
449:
450: IF g_debug THEN
451: hr_utility.trace('ABS:Completed hxc_time_category_api.create_time_category procedure.');
452: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
453: hr_utility.trace('ABS:p_object_version_number ::'||p_object_version_number);
454: hr_utility.set_location('ABS:Processing '||l_proc, 40);
455: END IF;
456:

Line 453: hr_utility.trace('ABS:p_object_version_number ::'||p_object_version_number);

449:
450: IF g_debug THEN
451: hr_utility.trace('ABS:Completed hxc_time_category_api.create_time_category procedure.');
452: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
453: hr_utility.trace('ABS:p_object_version_number ::'||p_object_version_number);
454: hr_utility.set_location('ABS:Processing '||l_proc, 40);
455: END IF;
456:
457: END;

Line 454: hr_utility.set_location('ABS:Processing '||l_proc, 40);

450: IF g_debug THEN
451: hr_utility.trace('ABS:Completed hxc_time_category_api.create_time_category procedure.');
452: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
453: hr_utility.trace('ABS:p_object_version_number ::'||p_object_version_number);
454: hr_utility.set_location('ABS:Processing '||l_proc, 40);
455: END IF;
456:
457: END;
458:

Line 468: hr_utility.trace('ABS:p_time_category_exists ::'||p_time_category_exists);

464: where field_name = 'Dummy Element Context';
465:
466:
467: IF g_debug THEN
468: hr_utility.trace('ABS:p_time_category_exists ::'||p_time_category_exists);
469: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
470: hr_utility.set_location('ABS:Processing '||l_proc, 50);
471: END IF;
472:

Line 469: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);

465:
466:
467: IF g_debug THEN
468: hr_utility.trace('ABS:p_time_category_exists ::'||p_time_category_exists);
469: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
470: hr_utility.set_location('ABS:Processing '||l_proc, 50);
471: END IF;
472:
473: END create_time_category;

Line 470: hr_utility.set_location('ABS:Processing '||l_proc, 50);

466:
467: IF g_debug THEN
468: hr_utility.trace('ABS:p_time_category_exists ::'||p_time_category_exists);
469: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
470: hr_utility.set_location('ABS:Processing '||l_proc, 50);
471: END IF;
472:
473: END create_time_category;
474:

Line 489: g_debug := hr_utility.debug_enabled;

485: l_proc VARCHAR2(100);
486:
487: BEGIN
488:
489: g_debug := hr_utility.debug_enabled;
490:
491: IF g_debug THEN
492: l_proc := g_package||'create_time_category_comp';
493: hr_utility.set_location('ABS:Processing '||l_proc, 10);

Line 493: hr_utility.set_location('ABS:Processing '||l_proc, 10);

489: g_debug := hr_utility.debug_enabled;
490:
491: IF g_debug THEN
492: l_proc := g_package||'create_time_category_comp';
493: hr_utility.set_location('ABS:Processing '||l_proc, 10);
494: END IF;
495:
496: IF g_debug THEN
497: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);

Line 497: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);

493: hr_utility.set_location('ABS:Processing '||l_proc, 10);
494: END IF;
495:
496: IF g_debug THEN
497: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
498: hr_utility.trace('ABS:p_value_id ::'||p_value_id);
499: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
500: END IF;
501:

Line 498: hr_utility.trace('ABS:p_value_id ::'||p_value_id);

494: END IF;
495:
496: IF g_debug THEN
497: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
498: hr_utility.trace('ABS:p_value_id ::'||p_value_id);
499: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
500: END IF;
501:
502: BEGIN

Line 499: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);

495:
496: IF g_debug THEN
497: hr_utility.trace('ABS:p_time_category_id ::'||p_time_category_id);
498: hr_utility.trace('ABS:p_value_id ::'||p_value_id);
499: hr_utility.trace('ABS:p_component_type_id ::'||p_component_type_id);
500: END IF;
501:
502: BEGIN
503:

Line 521: hr_utility.set_location('ABS:Processing '||l_proc, 20);

517: WHERE time_category_id = p_time_category_id
518: AND value_id = p_value_id;
519:
520: IF g_debug THEN
521: hr_utility.set_location('ABS:Processing '||l_proc, 20);
522: hr_utility.trace('ABS:p_time_category_comp_exists ::'||p_time_category_comp_exists);
523: END IF;
524:
525: IF p_time_category_comp_exists = 'Y' THEN

Line 522: hr_utility.trace('ABS:p_time_category_comp_exists ::'||p_time_category_comp_exists);

518: AND value_id = p_value_id;
519:
520: IF g_debug THEN
521: hr_utility.set_location('ABS:Processing '||l_proc, 20);
522: hr_utility.trace('ABS:p_time_category_comp_exists ::'||p_time_category_comp_exists);
523: END IF;
524:
525: IF p_time_category_comp_exists = 'Y' THEN
526:

Line 536: hr_utility.set_location('ABS:Processing '||l_proc, 30);

532: WHERE time_category_id = p_time_category_id
533: AND value_id = p_value_id;
534:
535: IF g_debug THEN
536: hr_utility.set_location('ABS:Processing '||l_proc, 30);
537: hr_utility.trace('ABS:l_time_category_comp_id ::'||l_time_category_comp_id);
538: hr_utility.trace('ABS:l_time_category_comp_ovn ::'||l_time_category_comp_ovn);
539: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.update_time_category_comp procedure.');
540: END IF;

Line 537: hr_utility.trace('ABS:l_time_category_comp_id ::'||l_time_category_comp_id);

533: AND value_id = p_value_id;
534:
535: IF g_debug THEN
536: hr_utility.set_location('ABS:Processing '||l_proc, 30);
537: hr_utility.trace('ABS:l_time_category_comp_id ::'||l_time_category_comp_id);
538: hr_utility.trace('ABS:l_time_category_comp_ovn ::'||l_time_category_comp_ovn);
539: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.update_time_category_comp procedure.');
540: END IF;
541:

Line 538: hr_utility.trace('ABS:l_time_category_comp_ovn ::'||l_time_category_comp_ovn);

534:
535: IF g_debug THEN
536: hr_utility.set_location('ABS:Processing '||l_proc, 30);
537: hr_utility.trace('ABS:l_time_category_comp_id ::'||l_time_category_comp_id);
538: hr_utility.trace('ABS:l_time_category_comp_ovn ::'||l_time_category_comp_ovn);
539: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.update_time_category_comp procedure.');
540: END IF;
541:
542: hxc_time_category_comp_api.update_time_category_comp

Line 539: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.update_time_category_comp procedure.');

535: IF g_debug THEN
536: hr_utility.set_location('ABS:Processing '||l_proc, 30);
537: hr_utility.trace('ABS:l_time_category_comp_id ::'||l_time_category_comp_id);
538: hr_utility.trace('ABS:l_time_category_comp_ovn ::'||l_time_category_comp_ovn);
539: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.update_time_category_comp procedure.');
540: END IF;
541:
542: hxc_time_category_comp_api.update_time_category_comp
543: (p_time_category_comp_id => l_time_category_comp_id

Line 555: hr_utility.trace('ABS:Completed hxc_time_category_comp_api.update_time_category_comp procedure.');

551: ,p_equal_to => 'Y'
552: ,p_type => 'MC' );
553:
554: IF g_debug THEN
555: hr_utility.trace('ABS:Completed hxc_time_category_comp_api.update_time_category_comp procedure.');
556: hr_utility.set_location('ABS:Processing '||l_proc, 40);
557: END IF;
558:
559:

Line 556: hr_utility.set_location('ABS:Processing '||l_proc, 40);

552: ,p_type => 'MC' );
553:
554: IF g_debug THEN
555: hr_utility.trace('ABS:Completed hxc_time_category_comp_api.update_time_category_comp procedure.');
556: hr_utility.set_location('ABS:Processing '||l_proc, 40);
557: END IF;
558:
559:
560: END IF;

Line 568: hr_utility.set_location('ABS:Processing '||l_proc, 30);

564:
565: WHEN NO_DATA_FOUND THEN
566:
567: IF g_debug THEN
568: hr_utility.set_location('ABS:Processing '||l_proc, 30);
569: hr_utility.trace('ABS:When NO_DATA_FOUND exception');
570: END IF;
571:
572: IF g_debug THEN

Line 569: hr_utility.trace('ABS:When NO_DATA_FOUND exception');

565: WHEN NO_DATA_FOUND THEN
566:
567: IF g_debug THEN
568: hr_utility.set_location('ABS:Processing '||l_proc, 30);
569: hr_utility.trace('ABS:When NO_DATA_FOUND exception');
570: END IF;
571:
572: IF g_debug THEN
573: hr_utility.set_location('ABS:Processing '||l_proc, 40);

Line 573: hr_utility.set_location('ABS:Processing '||l_proc, 40);

569: hr_utility.trace('ABS:When NO_DATA_FOUND exception');
570: END IF;
571:
572: IF g_debug THEN
573: hr_utility.set_location('ABS:Processing '||l_proc, 40);
574: hr_utility.trace('ABS:l_component_type_id = '||l_component_type_id);
575: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.create_time_category_comp procedure.');
576: END IF;
577:

Line 574: hr_utility.trace('ABS:l_component_type_id = '||l_component_type_id);

570: END IF;
571:
572: IF g_debug THEN
573: hr_utility.set_location('ABS:Processing '||l_proc, 40);
574: hr_utility.trace('ABS:l_component_type_id = '||l_component_type_id);
575: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.create_time_category_comp procedure.');
576: END IF;
577:
578: hxc_time_category_comp_api.create_time_category_comp

Line 575: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.create_time_category_comp procedure.');

571:
572: IF g_debug THEN
573: hr_utility.set_location('ABS:Processing '||l_proc, 40);
574: hr_utility.trace('ABS:l_component_type_id = '||l_component_type_id);
575: hr_utility.trace('ABS:Calling hxc_time_category_comp_api.create_time_category_comp procedure.');
576: END IF;
577:
578: hxc_time_category_comp_api.create_time_category_comp
579: (p_time_category_comp_id => l_time_category_comp_id

Line 591: hr_utility.trace('ABS:Completed of hxc_time_category_comp_api.create_time_category_comp procedure.');

587: ,p_equal_to => 'Y'
588: ,p_type => 'MC' );
589:
590: IF g_debug THEN
591: hr_utility.trace('ABS:Completed of hxc_time_category_comp_api.create_time_category_comp procedure.');
592: hr_utility.set_location('ABS:Processing '||l_proc, 50);
593: END IF;
594:
595: p_time_category_comp_exists := 'N';

Line 592: hr_utility.set_location('ABS:Processing '||l_proc, 50);

588: ,p_type => 'MC' );
589:
590: IF g_debug THEN
591: hr_utility.trace('ABS:Completed of hxc_time_category_comp_api.create_time_category_comp procedure.');
592: hr_utility.set_location('ABS:Processing '||l_proc, 50);
593: END IF;
594:
595: p_time_category_comp_exists := 'N';
596: