DBA Data[Home] [Help]

APPS.HXC_ALIAS_DEFINITIONS_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_alias_definitions_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |------------------------< create_alias_definition >------------------------|
11: -- ----------------------------------------------------------------------------

Line 37: g_debug:=hr_utility.debug_enabled;

33: l_alias_definition_id hxc_alias_definitions.alias_definition_id%TYPE;
34: l_language_code hxc_alias_definitions_tl.language%TYPE;
35:
36: begin
37: g_debug:=hr_utility.debug_enabled;
38: if g_debug then
39: l_proc := g_package||'create_alias_definition';
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: end if;

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

36: begin
37: g_debug:=hr_utility.debug_enabled;
38: if g_debug then
39: l_proc := g_package||'create_alias_definition';
40: hr_utility.set_location('Entering:'|| l_proc, 10);
41: end if;
42: --
43: -- Issue a savepoint
44: --

Line 61: hr_utility.set_location('Entering:'|| l_proc, 20);

57: --
58: -- Call Before Process User Hook
59: --
60: if g_debug then
61: hr_utility.set_location('Entering:'|| l_proc, 20);
62: end if;
63: --
64: begin
65: hxc_alias_definitions_bk_1.create_alias_definition_b

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

81: );
82: end;
83: --
84: if g_debug then
85: hr_utility.set_location(l_proc, 30);
86: end if;
87: --
88: -- Validation in addition to Row Handlers
89: --

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

93: --
94: -- Process Logic
95: --
96: if g_debug then
97: hr_utility.set_location(l_proc, 40);
98: end if;
99: --
100: -- call row handler to insert record.
101: --

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

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

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

162: p_alias_definition_id := l_alias_definition_id;
163: p_object_version_number := l_object_version_number;
164: --
165: if g_debug then
166: hr_utility.set_location(' Leaving:'||l_proc, 70);
167: end if;
168: exception
169: when hr_api.validate_enabled then
170: --

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

180: p_alias_definition_id := null;
181: p_object_version_number := null;
182: -- p_some_warning := ;
183: if g_debug then
184: hr_utility.set_location(' Leaving:'||l_proc, 80);
185: end if;
186: when others then
187: --
188: -- A validation or unexpected error has occured

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

188: -- A validation or unexpected error has occured
189: --
190: rollback to create_alias_definition;
191: if g_debug then
192: hr_utility.set_location(' Leaving:'||l_proc, 90);
193: end if;
194: raise;
195: end create_alias_definition;
196: --

Line 224: g_debug:=hr_utility.debug_enabled;

220: l_object_version_number hxc_alias_definitions.object_version_number%TYPE := p_object_version_number;
221: l_language_code hxc_alias_definitions_tl.language%TYPE;
222:
223: begin
224: g_debug:=hr_utility.debug_enabled;
225: if g_debug then
226: l_proc := g_package||'update_alias_definition';
227: hr_utility.set_location('Entering:'|| l_proc, 10);
228: end if;

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

223: begin
224: g_debug:=hr_utility.debug_enabled;
225: if g_debug then
226: l_proc := g_package||'update_alias_definition';
227: hr_utility.set_location('Entering:'|| l_proc, 10);
228: end if;
229: --
230: -- Issue a savepoint
231: --

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

245: --
246: -- Call Before Process User Hook
247: --
248: if g_debug then
249: hr_utility.set_location('Entering:'|| l_proc, 20);
250: end if;
251: --
252: begin
253: hxc_alias_definitions_bk_1.update_alias_definition_b

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

271: );
272: end;
273: --
274: if g_debug then
275: hr_utility.set_location(l_proc, 30);
276: end if;
277: --
278: -- Validation in addition to Row Handlers
279: --

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

283: --
284: -- Process Logic
285: --
286: if g_debug then
287: hr_utility.set_location(l_proc, 40);
288: end if;
289: --
290: -- call row handler to update record.
291: --

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

315: --
316: -- Call After Process User Hook
317: --
318: if g_debug then
319: hr_utility.set_location(l_proc, 50);
320: end if;
321: --
322: begin
323: hxc_alias_definitions_bk_1.update_alias_definition_a

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

352: p_object_version_number := l_object_version_number;
353: -- p_some_warning := ;
354: --
355: if g_debug then
356: hr_utility.set_location(' Leaving:'||l_proc, 70);
357: end if;
358: exception
359: when hr_api.validate_enabled then
360: --

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

369: --
370: p_object_version_number := null;
371: -- p_some_warning := ;
372: if g_debug then
373: hr_utility.set_location(' Leaving:'||l_proc, 80);
374: end if;
375: when others then
376: --
377: -- A validation or unexpected error has occured

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

377: -- A validation or unexpected error has occured
378: --
379: rollback to update_alias_definition;
380: if g_debug then
381: hr_utility.set_location(' Leaving:'||l_proc, 90);
382: end if;
383: raise;
384: end update_alias_definition;
385: --

Line 402: g_debug:=hr_utility.debug_enabled;

398:
399: l_proc varchar2(72);
400:
401: begin
402: g_debug:=hr_utility.debug_enabled;
403: if g_debug then
404: l_proc := g_package||'delete_alias_definition';
405: hr_utility.set_location('Entering:'|| l_proc, 10);
406: end if;

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

401: begin
402: g_debug:=hr_utility.debug_enabled;
403: if g_debug then
404: l_proc := g_package||'delete_alias_definition';
405: hr_utility.set_location('Entering:'|| l_proc, 10);
406: end if;
407: --
408: -- Issue a savepoint
409: --

Line 419: hr_utility.set_location('Entering:'|| l_proc, 20);

415: --
416: -- Call Before Process User Hook
417: --
418: if g_debug then
419: hr_utility.set_location('Entering:'|| l_proc, 20);
420: end if;
421: --
422: begin
423: hxc_alias_definitions_bk_1.delete_alias_definition_b

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

432: );
433: end;
434: --
435: if g_debug then
436: hr_utility.set_location(l_proc, 30);
437: end if;
438: --
439: -- Validation in addition to Row Handlers
440: --

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

442: --
443: -- Process Logic
444: --
445: if g_debug then
446: hr_utility.set_location(l_proc, 40);
447: end if;
448: --
449: -- call row handler to delete record.
450: --

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

461: */ --
462: -- Call After Process User Hook
463: --
464: if g_debug then
465: hr_utility.set_location(l_proc, 50);
466: end if;
467: --
468: begin
469: hxc_alias_definitions_bk_1.delete_alias_definition_a

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

487: -- Set all output arguments
488: --
489: --
490: if g_debug then
491: hr_utility.set_location(' Leaving:'||l_proc, 70);
492: end if;
493: exception
494: when hr_api.validate_enabled then
495: --

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

502: -- (Any key or derived arguments must be set to null
503: -- when validation only mode is being used.)
504: --
505: if g_debug then
506: hr_utility.set_location(' Leaving:'||l_proc, 80);
507: end if;
508: when others then
509: --
510: -- A validation or unexpected error has occured

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

510: -- A validation or unexpected error has occured
511: --
512: rollback to delete_alias_definition;
513: if g_debug then
514: hr_utility.set_location(' Leaving:'||l_proc, 90);
515: end if;
516: raise;
517: end delete_alias_definition;
518: --