DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_COMP_API dependencies on HR_UTILITY

Line 8: g_debug boolean := hr_utility.debug_enabled;

4: -- Package Variables
5: --
6: g_package varchar2(33) := ' hxc_time_category_comp_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_time_category_comp>----------------------|
12: -- ----------------------------------------------------------------------------

Line 38: g_debug := hr_utility.debug_enabled;

34:
35: l_validation_type varchar2(5) := NULL;
36:
37: begin
38: g_debug := hr_utility.debug_enabled;
39: --
40: if g_debug then
41: l_proc := g_package||' create_time_category_comp';
42: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 42: hr_utility.set_location('Entering:'|| l_proc, 10);

38: g_debug := hr_utility.debug_enabled;
39: --
40: if g_debug then
41: l_proc := g_package||' create_time_category_comp';
42: hr_utility.set_location('Entering:'|| l_proc, 10);
43: end if;
44: --
45: -- Issue a savepoint if operating in validation only mode
46: --

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

46: --
47: savepoint create_time_category_comp;
48: --
49: if g_debug then
50: hr_utility.set_location(l_proc, 20);
51: end if;
52:
53: --Changes for bug 14524515 start
54: /*

Line 56: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);

52:
53: --Changes for bug 14524515 start
54: /*
55: if g_debug then
56: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
57: end if;
58:
59: if (p_type = 'MC' and nvl(p_flex_value_set_id,0) > 0 )
60: then

Line 89: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);

85:
86: -- Bug 16002606 start
87:
88: if g_debug then
89: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
90: end if;
91:
92:
93: /* IF p_type = 'MC'

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

144: );
145: end;
146: --
147: if g_debug then
148: hr_utility.set_location(l_proc, 30);
149: end if;
150: --
151: -- Process Logic
152: --

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

151: -- Process Logic
152: --
153: --
154: if g_debug then
155: hr_utility.set_location(l_proc, 40);
156: end if;
157: --
158: -- call row handler
159: --

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

170: ,p_object_version_number => l_object_version_number
171: );
172: --
173: if g_debug then
174: hr_utility.set_location(l_proc, 50);
175: end if;
176:
177:
178: -- Bug 13817976

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

210: );
211: end;
212: --
213: if g_debug then
214: hr_utility.set_location(l_proc, 60);
215: end if;
216: --
217: -- When in validation only mode raise the Validate_Enabled exception
218: --

Line 224: hr_utility.set_location(' Leaving:'||l_proc, 70);

220: raise hr_api.validate_enabled;
221: end if;
222: --
223: if g_debug then
224: hr_utility.set_location(' Leaving:'||l_proc, 70);
225: end if;
226: --
227: -- Set all output arguments
228: --

Line 249: hr_utility.set_location(' Leaving:'||l_proc, 80);

245: p_time_category_comp_id := null;
246: p_object_version_number := null;
247: --
248: if g_debug then
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: end if;
251: --
252: when others then
253: --

Line 257: hr_utility.trace('In exeception');

253: --
254: -- A validation or unexpected error has occured
255: --
256: if g_debug then
257: hr_utility.trace('In exeception');
258: end if;
259: ROLLBACK TO create_time_category_comp;
260: raise;
261: --

Line 289: g_debug := hr_utility.debug_enabled;

285: l_object_version_number hxc_time_category_comps.object_version_number%TYPE := p_object_version_number;
286: --
287: l_validation_type varchar2(5) := NULL;
288: begin
289: g_debug := hr_utility.debug_enabled;
290:
291: if g_debug then
292: l_proc := g_package||' update_time_category_comp';
293: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 293: hr_utility.set_location('Entering:'|| l_proc, 10);

289: g_debug := hr_utility.debug_enabled;
290:
291: if g_debug then
292: l_proc := g_package||' update_time_category_comp';
293: hr_utility.set_location('Entering:'|| l_proc, 10);
294: end if;
295: --
296: -- Issue a savepoint if operating in validation only mode
297: --

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

297: --
298: savepoint update_time_category_comp;
299: --
300: if g_debug then
301: hr_utility.set_location(l_proc, 20);
302: end if;
303:
304: -- Bug 16002606 start
305:

Line 307: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);

303:
304: -- Bug 16002606 start
305:
306: if g_debug then
307: hr_utility.trace('p_type: '||p_type||' p_flex_value_set_id: '||p_flex_value_set_id);
308: end if;
309:
310:
311: /* IF p_type = 'MC'

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

363: );
364: end;
365: --
366: if g_debug then
367: hr_utility.set_location(l_proc, 30);
368: end if;
369: --
370: -- Process Logic
371: --

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

385: );
386: --
387: --
388: if g_debug then
389: hr_utility.set_location(l_proc, 40);
390: end if;
391:
392: -- Bug 13817976
393: IF p_type IN ('AN','MC')

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

425: );
426: end;
427: --
428: if g_debug then
429: hr_utility.set_location(l_proc, 50);
430: end if;
431: --
432: -- When in validation only mode raise the Validate_Enabled exception
433: --

Line 439: hr_utility.set_location(' Leaving:'||l_proc, 60);

435: raise hr_api.validate_enabled;
436: end if;
437: --
438: if g_debug then
439: hr_utility.set_location(' Leaving:'||l_proc, 60);
440: end if;
441: --
442: -- Set all output arguments
443: --

Line 462: hr_utility.set_location(' Leaving:'||l_proc, 60);

458: --
459: p_object_version_number := null;
460: --
461: if g_debug then
462: hr_utility.set_location(' Leaving:'||l_proc, 60);
463: end if;
464: --
465: when others then
466: --

Line 470: hr_utility.trace('In exeception');

466: --
467: -- A validation or unexpected error has occured
468: --
469: if g_debug then
470: hr_utility.trace('In exeception');
471: end if;
472: ROLLBACK TO update_time_category_comp;
473: raise;
474: --

Line 492: g_debug := hr_utility.debug_enabled;

488: --
489: l_proc varchar2(72);
490: --
491: begin
492: g_debug := hr_utility.debug_enabled;
493: --
494: if g_debug then
495: l_proc := g_package||'delete_time_category_comp';
496: hr_utility.set_location('Entering:'|| l_proc, 10);

Line 496: hr_utility.set_location('Entering:'|| l_proc, 10);

492: g_debug := hr_utility.debug_enabled;
493: --
494: if g_debug then
495: l_proc := g_package||'delete_time_category_comp';
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497: end if;
498: --
499: -- Issue a savepoint if operating in validation only mode
500: --

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

500: --
501: savepoint delete_time_category_comp;
502: --
503: if g_debug then
504: hr_utility.set_location(l_proc, 20);
505: end if;
506: --
507: -- Call Before Process User Hook
508: --

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

520: );
521: end;
522: --
523: if g_debug then
524: hr_utility.set_location(l_proc, 30);
525: end if;
526: --
527: -- Process Logic
528: --

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

532: ,p_object_version_number => p_object_version_number
533: );
534: --
535: if g_debug then
536: hr_utility.set_location(l_proc, 40);
537: end if;
538:
539: -- Bug 13817976
540: hxc_time_category_utils_pkg.delete_tc_comps2(p_time_category_comp_id);

Line 566: hr_utility.set_location(' Leaving:'||l_proc, 50);

562: raise hr_api.validate_enabled;
563: end if;
564: --
565: if g_debug then
566: hr_utility.set_location(' Leaving:'||l_proc, 50);
567: end if;
568: --
569: exception
570: --