DBA Data[Home] [Help]

APPS.HXC_APPROVAL_COMPS_API dependencies on HR_UTILITY

Line 7: g_debug boolean :=hr_utility.debug_enabled;

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

Line 42: g_debug:=hr_utility.debug_enabled;

38: l_approval_comp_id hxc_approval_comps.approval_comp_id%TYPE;
39: --
40: Begin
41: --
42: g_debug:=hr_utility.debug_enabled;
43: if g_debug then
44: l_proc := g_package||'create_approval_comps';
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: end if;

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

41: --
42: g_debug:=hr_utility.debug_enabled;
43: if g_debug then
44: l_proc := g_package||'create_approval_comps';
45: hr_utility.set_location('Entering:'|| l_proc, 10);
46: end if;
47: --
48: -- Issue a savepoint
49: --

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

49: --
50: savepoint create_approval_comps;
51: --
52: if g_debug then
53: hr_utility.set_location(l_proc, 20);
54: end if;
55: --
56: -- Truncate the time portion from all IN date parameters
57: --

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

86: );
87: end;
88: --
89: if g_debug then
90: hr_utility.set_location(l_proc, 30);
91: end if;
92: --
93:
94: --

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

100: --
101: -- Process Logic
102: --
103: if g_debug then
104: hr_utility.set_location(l_proc, 40);
105: end if;
106: --
107: -- call row handler
108: --

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

125: ,p_run_recipient_extensions => p_run_recipient_extensions
126: );
127: --
128: if g_debug then
129: hr_utility.set_location(l_proc, 50);
130: end if;
131: --
132: -- Call After Process User Hook
133: --

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

158: );
159: end;
160: --
161: if g_debug then
162: hr_utility.set_location(l_proc, 60);
163: end if;
164: --
165: --
166: -- When in validation only mode raise the Validate_Enabled exception

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

169: raise hr_api.validate_enabled;
170: end if;
171: --
172: --if g_debug then
173: --hr_utility.set_location(' Leaving:'||l_proc, 70);
174: --end if;
175: --
176: --
177: -- Set all output arguments

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

179: p_approval_comp_id := l_approval_comp_id;
180: p_object_version_number := l_object_version_number;
181: --
182: if g_debug then
183: hr_utility.set_location(' Leaving:'||l_proc, 70);
184: end if;
185: exception
186: when hr_api.validate_enabled then
187: --

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

196: --
197: p_approval_comp_id := null;
198: p_object_version_number := null;
199: if g_debug then
200: hr_utility.set_location(' Leaving:'||l_proc, 80);
201: end if;
202: when others then
203: --
204: -- A validation or unexpected error has occured

Line 208: hr_utility.set_location(' Leaving:'||l_proc, 90);

204: -- A validation or unexpected error has occured
205: --
206: rollback to create_approval_comps;
207: if g_debug then
208: hr_utility.set_location(' Leaving:'||l_proc, 90);
209: end if;
210: raise;
211: --
212: end create_approval_comps;

Line 246: g_debug:=hr_utility.debug_enabled;

242: l_object_version_number hxc_approval_comps.object_version_number%TYPE := p_object_version_number;
243: --
244: Begin
245: --
246: g_debug:=hr_utility.debug_enabled;
247: if g_debug then
248: l_proc := g_package||' update_approval_comps';
249: hr_utility.set_location('Entering:'|| l_proc, 10);
250: end if;

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

245: --
246: g_debug:=hr_utility.debug_enabled;
247: if g_debug then
248: l_proc := g_package||' update_approval_comps';
249: hr_utility.set_location('Entering:'|| l_proc, 10);
250: end if;
251: --
252: -- Issue a savepoint if operating in validation only mode
253: --

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

253: --
254: savepoint update_approval_comps;
255: --
256: if g_debug then
257: hr_utility.set_location(l_proc, 20);
258: end if;
259: --
260: -- Call Before Process User Hook
261: --

Line 290: --hr_utility.set_location(l_proc, 30);

286: );
287: end;
288: --
289: --if g_debug then
290: --hr_utility.set_location(l_proc, 30);
291: --end if;
292: --
293: -- Process Logic
294: --

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

314: );
315: --
316: --
317: if g_debug then
318: hr_utility.set_location(l_proc, 40);
319: end if;
320: --
321: -- Call After Process User Hook
322: --

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

347: );
348: end;
349: --
350: if g_debug then
351: hr_utility.set_location(l_proc, 50);
352: end if;
353: --
354: -- When in validation only mode raise the Validate_Enabled exception
355: --

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

357: raise hr_api.validate_enabled;
358: end if;
359: --
360: if g_debug then
361: hr_utility.set_location(' Leaving:'||l_proc, 60);
362: end if;
363: --
364: -- Set all output arguments
365: --

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

380: --
381: p_object_version_number := null;
382: --
383: if g_debug then
384: hr_utility.set_location(' Leaving:'||l_proc, 60);
385: end if;
386: --
387: when others then
388: --

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

389: -- A validation or unexpected error has occured
390: --
391: ROLLBACK TO update_approval_comps;
392: if g_debug then
393: hr_utility.set_location(' Leaving:'||l_proc, 70);
394: end if;
395: raise;
396: --
397: END update_approval_comps;

Line 415: g_debug:=hr_utility.debug_enabled;

411: l_proc varchar2(72);
412: --
413: begin
414: --
415: g_debug:=hr_utility.debug_enabled;
416: if g_debug then
417: l_proc := g_package||'delete_approval_comps';
418: hr_utility.set_location('Entering:'|| l_proc, 10);
419: end if;

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

414: --
415: g_debug:=hr_utility.debug_enabled;
416: if g_debug then
417: l_proc := g_package||'delete_approval_comps';
418: hr_utility.set_location('Entering:'|| l_proc, 10);
419: end if;
420: --
421: -- Issue a savepoint if operating in validation only mode
422: --

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

422: --
423: savepoint delete_approval_comps;
424: --
425: if g_debug then
426: hr_utility.set_location(l_proc, 20);
427: end if;
428: --
429: -- Call Before Process User Hook
430: --

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

442: );
443: end;
444: --
445: if g_debug then
446: hr_utility.set_location(l_proc, 30);
447: end if;
448: --
449: -- Process Logic
450: --

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

454: ,p_object_version_number => p_object_version_number
455: );
456: --
457: if g_debug then
458: hr_utility.set_location(l_proc, 40);
459: end if;
460: --
461: -- Call After Process User Hook
462: --

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

480: raise hr_api.validate_enabled;
481: end if;
482: --
483: if g_debug then
484: hr_utility.set_location(' Leaving:'||l_proc, 50);
485: end if;
486: --
487: exception
488: --