DBA Data[Home] [Help]

APPS.HXC_TIME_CATEGORY_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_api.';
7:
8: g_debug boolean := hr_utility.debug_enabled;
9: --
10: -- ----------------------------------------------------------------------------
11: -- |------------------------< create_time_category >---------------------------|
12: -- ----------------------------------------------------------------------------

Line 31: g_debug := hr_utility.debug_enabled;

27: l_object_version_number hxc_time_categories.object_version_number%TYPE;
28: l_time_category_id hxc_time_categories.time_category_id%TYPE;
29:
30: begin
31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||' create_time_category';
35: hr_utility.set_location('Entering:'|| l_proc, 10);

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

31: g_debug := hr_utility.debug_enabled;
32: --
33: if g_debug then
34: l_proc := g_package||' create_time_category';
35: hr_utility.set_location('Entering:'|| l_proc, 10);
36: end if;
37: --
38: -- Issue a savepoint if operating in validation only mode
39: --

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

39: --
40: savepoint create_time_category;
41: --
42: if g_debug then
43: hr_utility.set_location(l_proc, 20);
44: end if;
45: --
46: -- Call Before Process User Hook
47: --

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

62: );
63: end;
64: --
65: if g_debug then
66: hr_utility.set_location(l_proc, 30);
67: end if;
68: --
69: -- Process Logic
70: --

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

69: -- Process Logic
70: --
71: --
72: if g_debug then
73: hr_utility.set_location(l_proc, 40);
74: end if;
75: --
76: -- call row handler
77: --

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

83: ,p_time_category_id => l_time_category_id
84: ,p_object_version_number => l_object_version_number );
85: --
86: if g_debug then
87: hr_utility.set_location(l_proc, 50);
88: end if;
89: --
90: -- Call After Process User Hook
91: --

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

106: );
107: end;
108: --
109: if g_debug then
110: hr_utility.set_location(l_proc, 60);
111: end if;
112: --
113: -- When in validation only mode raise the Validate_Enabled exception
114: --

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

116: raise hr_api.validate_enabled;
117: end if;
118: --
119: if g_debug then
120: hr_utility.set_location(' Leaving:'||l_proc, 70);
121: end if;
122: --
123: -- Set all output arguments
124: --

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

141: p_time_category_id := null;
142: p_object_version_number := null;
143: --
144: if g_debug then
145: hr_utility.set_location(' Leaving:'||l_proc, 80);
146: end if;
147: --
148: when others then
149: --

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

149: --
150: -- A validation or unexpected error has occured
151: --
152: if g_debug then
153: hr_utility.trace('In exeception');
154: end if;
155: ROLLBACK TO create_time_category;
156: raise;
157: --

Line 181: g_debug := hr_utility.debug_enabled;

177: l_proc varchar2(72) ;
178: l_object_version_number hxc_time_categories.object_version_number%TYPE := p_object_version_number;
179:
180: begin
181: g_debug := hr_utility.debug_enabled;
182: --
183: if g_debug then
184: l_proc := g_package||' update_time_category';
185: hr_utility.set_location('Entering:'|| l_proc, 10);

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

181: g_debug := hr_utility.debug_enabled;
182: --
183: if g_debug then
184: l_proc := g_package||' update_time_category';
185: hr_utility.set_location('Entering:'|| l_proc, 10);
186: end if;
187: --
188: -- Issue a savepoint if operating in validation only mode
189: --

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

189: --
190: savepoint update_time_category;
191: --
192: if g_debug then
193: hr_utility.set_location(l_proc, 20);
194: end if;
195: --
196: -- Call Before Process User Hook
197: --

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

212: );
213: end;
214: --
215: if g_debug then
216: hr_utility.set_location(l_proc, 30);
217: end if;
218: --
219: -- Process Logic
220: --

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

229: ,p_object_version_number => l_object_version_number );
230: --
231: --
232: if g_debug then
233: hr_utility.set_location(l_proc, 40);
234: end if;
235: --
236: -- Call After Process User Hook
237: --

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

251: );
252: end;
253: --
254: if g_debug then
255: hr_utility.set_location(l_proc, 50);
256: end if;
257: --
258: -- When in validation only mode raise the Validate_Enabled exception
259: --

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

261: raise hr_api.validate_enabled;
262: end if;
263: --
264: if g_debug then
265: hr_utility.set_location(' Leaving:'||l_proc, 60);
266: end if;
267: --
268: -- Set all output arguments
269: --

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

284: --
285: p_object_version_number := null;
286: --
287: if g_debug then
288: hr_utility.set_location(' Leaving:'||l_proc, 60);
289: end if;
290: --
291: when others then
292: --

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

292: --
293: -- A validation or unexpected error has occured
294: --
295: if g_debug then
296: hr_utility.trace('In exeception');
297: end if;
298: ROLLBACK TO update_time_category;
299: raise;
300: --

Line 319: g_debug := hr_utility.debug_enabled;

315: --
316: l_proc varchar2(72) ;
317: --
318: begin
319: g_debug := hr_utility.debug_enabled;
320: --
321: if g_debug then
322: l_proc := g_package||'delete_time_category';
323: hr_utility.set_location('Entering:'|| l_proc, 10);

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

319: g_debug := hr_utility.debug_enabled;
320: --
321: if g_debug then
322: l_proc := g_package||'delete_time_category';
323: hr_utility.set_location('Entering:'|| l_proc, 10);
324: end if;
325: --
326: -- Issue a savepoint if operating in validation only mode
327: --

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

327: --
328: savepoint delete_time_category;
329: --
330: if g_debug then
331: hr_utility.set_location(l_proc, 20);
332: end if;
333: --
334: -- Call Before Process User Hook
335: --

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

348: );
349: end;
350: --
351: if g_debug then
352: hr_utility.set_location(l_proc, 30);
353: end if;
354: --
355: -- Process Logic
356: --

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

361: ,p_object_version_number => p_object_version_number
362: );
363: --
364: if g_debug then
365: hr_utility.set_location(l_proc, 40);
366: end if;
367: --
368: -- Call After Process User Hook
369: --

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

388: raise hr_api.validate_enabled;
389: end if;
390: --
391: if g_debug then
392: hr_utility.set_location(' Leaving:'||l_proc, 50);
393: end if;
394: --
395: exception
396: --

Line 421: g_debug := hr_utility.debug_enabled;

417: l_operator hxc_time_categories.operator%TYPE;
418:
419: BEGIN
420:
421: g_debug := hr_utility.debug_enabled;
422:
423: hxc_time_category_utils_pkg.mapping_component_string (
424: p_time_category_id => p_time_category_id
425: , p_time_sql => l_time_sql );

Line 428: hr_utility.trace('set dyn sql string string is '||l_time_sql);

424: p_time_category_id => p_time_category_id
425: , p_time_sql => l_time_sql );
426:
427: if g_debug then
428: hr_utility.trace('set dyn sql string string is '||l_time_sql);
429: end if;
430:
431: UPDATE hxc_time_categories
432: SET time_sql = l_time_sql

Line 438: hr_utility.trace('exception is '||SQLERRM);

434:
435: exception when others then
436:
437: if g_debug then
438: hr_utility.trace('exception is '||SQLERRM);
439: end if;
440:
441: raise;
442: