[Home] [Help]
PACKAGE BODY: APPS.HXC_ALIAS_VALUES_API
Source
1 Package Body hxc_alias_values_api as
2 /* $Header: hxchavapi.pkb 120.2 2005/09/23 10:41:26 sechandr noship $ */
3 --
4 -- Package Variables
5 --
6 g_package varchar2(33) := ' hxc_alias_values_api.';
7 g_debug boolean :=hr_utility.debug_enabled;
8 --
9 -- ----------------------------------------------------------------------------
10 -- |--------------------------< create_alias_value >--------------------------|
11 -- ----------------------------------------------------------------------------
12 --
13 procedure create_alias_value
14 (p_validate in boolean default false
15 ,p_alias_value_id out nocopy number
16 ,p_alias_value_name in varchar2
17 ,p_date_from in date
18 ,p_date_to in date default null
19 ,p_alias_definition_id in number
20 ,p_enabled_flag in varchar2
21 ,p_attribute_category in varchar2 default null
22 ,p_attribute1 in varchar2 default null
23 ,p_attribute2 in varchar2 default null
24 ,p_attribute3 in varchar2 default null
25 ,p_attribute4 in varchar2 default null
26 ,p_attribute5 in varchar2 default null
27 ,p_attribute6 in varchar2 default null
28 ,p_attribute7 in varchar2 default null
29 ,p_attribute8 in varchar2 default null
30 ,p_attribute9 in varchar2 default null
31 ,p_attribute10 in varchar2 default null
32 ,p_attribute11 in varchar2 default null
33 ,p_attribute12 in varchar2 default null
34 ,p_attribute13 in varchar2 default null
35 ,p_attribute14 in varchar2 default null
36 ,p_attribute15 in varchar2 default null
37 ,p_attribute16 in varchar2 default null
38 ,p_attribute17 in varchar2 default null
39 ,p_attribute18 in varchar2 default null
40 ,p_attribute19 in varchar2 default null
41 ,p_attribute20 in varchar2 default null
42 ,p_attribute21 in varchar2 default null
43 ,p_attribute22 in varchar2 default null
44 ,p_attribute23 in varchar2 default null
45 ,p_attribute24 in varchar2 default null
46 ,p_attribute25 in varchar2 default null
47 ,p_attribute26 in varchar2 default null
48 ,p_attribute27 in varchar2 default null
49 ,p_attribute28 in varchar2 default null
50 ,p_attribute29 in varchar2 default null
51 ,p_attribute30 in varchar2 default null
52 ,p_object_version_number out nocopy number
53 ,p_language_code in varchar2 default hr_api.userenv_lang
54 ) is
55 --
56 -- Declare cursors and local variables
57 --
58
59 l_proc varchar2(72);
60 l_object_version_number hxc_alias_values.object_version_number%TYPE;
61 l_alias_value_id hxc_alias_values.alias_value_id%TYPE;
62 l_language_code hxc_alias_definitions_tl.language%TYPE;
63
64 begin
65 g_debug:=hr_utility.debug_enabled;
66 if g_debug then
67 l_proc := g_package||'create_alias_value';
68 hr_utility.set_location('Entering:'|| l_proc, 10);
69 end if;
70 --
71 -- Issue a savepoint
72 --
73 savepoint create_alias_value;
74 --
75 -- Truncate the time portion from all IN date parameters
76 --
77
78 -- Validate the language parameter. l_language_code should be passed
79 -- to functions instead of p_language_code from now on, to allow
80 -- an IN OUT parameter to be passed through.
81 --
82 l_language_code := p_language_code;
83 hr_api.validate_language_code(p_language_code => l_language_code);
84 --
85 --
86 -- Call Before Process User Hook
87 --
88 begin
89 hxc_alias_values_bk_1.create_alias_value_b
90 (p_alias_value_name => p_alias_value_name
91 ,p_date_from => p_date_from
92 ,p_date_to => p_date_to
93 ,p_alias_definition_id => p_alias_definition_id
94 ,p_enabled_flag => p_enabled_flag
95 ,p_attribute_category => p_attribute_category
96 ,p_attribute1 => p_attribute1
97 ,p_attribute2 => p_attribute2
98 ,p_attribute3 => p_attribute3
99 ,p_attribute4 => p_attribute4
100 ,p_attribute5 => p_attribute5
101 ,p_attribute6 => p_attribute6
102 ,p_attribute7 => p_attribute7
103 ,p_attribute8 => p_attribute8
104 ,p_attribute9 => p_attribute9
105 ,p_attribute10 => p_attribute10
106 ,p_attribute11 => p_attribute11
107 ,p_attribute12 => p_attribute12
108 ,p_attribute13 => p_attribute13
109 ,p_attribute14 => p_attribute14
110 ,p_attribute15 => p_attribute15
111 ,p_attribute16 => p_attribute16
112 ,p_attribute17 => p_attribute17
113 ,p_attribute18 => p_attribute18
114 ,p_attribute19 => p_attribute19
115 ,p_attribute20 => p_attribute20
116 ,p_attribute21 => p_attribute21
117 ,p_attribute22 => p_attribute22
118 ,p_attribute23 => p_attribute23
119 ,p_attribute24 => p_attribute24
120 ,p_attribute25 => p_attribute25
121 ,p_attribute26 => p_attribute26
122 ,p_attribute27 => p_attribute27
123 ,p_attribute28 => p_attribute28
124 ,p_attribute29 => p_attribute29
125 ,p_attribute30 => p_attribute30
126 ,p_language_code => l_language_code
127 );
128 exception
129 when hr_api.cannot_find_prog_unit then
130 hr_api.cannot_find_prog_unit_error
131 (p_module_name => 'create_alias_value'
132 ,p_hook_type => 'BP'
133 );
134 end;
135 --
136 -- Validation in addition to Row Handlers
137 --
138
139
140
141 --
142 -- Process Logic
143 --
144 if g_debug then
145 hr_utility.set_location(l_proc, 40);
146 end if;
147 --
148 -- call row handler to insert record.
149 --
150 hxc_hav_ins.ins
151 (p_alias_value_name => p_alias_value_name
152 ,p_date_from => p_date_from
153 ,p_alias_definition_id => p_alias_definition_id
154 ,p_enabled_flag => p_enabled_flag
155 ,p_date_to => p_date_to
156 ,p_attribute_category => p_attribute_category
157 ,p_attribute1 => p_attribute1
158 ,p_attribute2 => p_attribute2
159 ,p_attribute3 => p_attribute3
160 ,p_attribute4 => p_attribute4
161 ,p_attribute5 => p_attribute5
162 ,p_attribute6 => p_attribute6
163 ,p_attribute7 => p_attribute7
164 ,p_attribute8 => p_attribute8
165 ,p_attribute9 => p_attribute9
166 ,p_attribute10 => p_attribute10
167 ,p_attribute11 => p_attribute11
168 ,p_attribute12 => p_attribute12
169 ,p_attribute13 => p_attribute13
170 ,p_attribute14 => p_attribute14
171 ,p_attribute15 => p_attribute15
172 ,p_attribute16 => p_attribute16
173 ,p_attribute17 => p_attribute17
174 ,p_attribute18 => p_attribute18
175 ,p_attribute19 => p_attribute19
176 ,p_attribute20 => p_attribute20
177 ,p_attribute21 => p_attribute21
178 ,p_attribute22 => p_attribute22
179 ,p_attribute23 => p_attribute23
180 ,p_attribute24 => p_attribute24
181 ,p_attribute25 => p_attribute25
182 ,p_attribute26 => p_attribute26
183 ,p_attribute27 => p_attribute27
184 ,p_attribute28 => p_attribute28
185 ,p_attribute29 => p_attribute29
186 ,p_attribute30 => p_attribute30
187 ,p_alias_value_id => l_alias_value_id
188 ,p_object_version_number => l_object_version_number
189 );
190
191 -- Call row handler to insert into translated tables
192 --
193 /*
194 hxc_vtl_ins.ins_tl
195 (p_language_code => l_language_code
196 ,p_alias_value_id => l_alias_value_id
197 ,p_alias_value_name => p_alias_value_name
198 );
199 */
200 --
201 -- Call After Process User Hook
202 --
203 begin
204 hxc_alias_values_bk_1.create_alias_value_a
205 (p_alias_value_id => l_alias_value_id
206 ,p_alias_value_name => p_alias_value_name
207 ,p_date_from => p_date_from
208 ,p_date_to => p_date_to
209 ,p_alias_definition_id => p_alias_definition_id
210 ,p_enabled_flag => p_enabled_flag
211 ,p_attribute_category => p_attribute_category
212 ,p_attribute1 => p_attribute1
213 ,p_attribute2 => p_attribute2
214 ,p_attribute3 => p_attribute3
215 ,p_attribute4 => p_attribute4
216 ,p_attribute5 => p_attribute5
217 ,p_attribute6 => p_attribute6
218 ,p_attribute7 => p_attribute7
219 ,p_attribute8 => p_attribute8
220 ,p_attribute9 => p_attribute9
221 ,p_attribute10 => p_attribute10
222 ,p_attribute11 => p_attribute11
223 ,p_attribute12 => p_attribute12
224 ,p_attribute13 => p_attribute13
225 ,p_attribute14 => p_attribute14
226 ,p_attribute15 => p_attribute15
227 ,p_attribute16 => p_attribute16
228 ,p_attribute17 => p_attribute17
229 ,p_attribute18 => p_attribute18
230 ,p_attribute19 => p_attribute19
231 ,p_attribute20 => p_attribute20
232 ,p_attribute21 => p_attribute21
233 ,p_attribute22 => p_attribute22
234 ,p_attribute23 => p_attribute23
235 ,p_attribute24 => p_attribute24
236 ,p_attribute25 => p_attribute25
237 ,p_attribute26 => p_attribute26
238 ,p_attribute27 => p_attribute27
239 ,p_attribute28 => p_attribute28
240 ,p_attribute29 => p_attribute29
241 ,p_attribute30 => p_attribute30
242 ,p_object_version_number => l_object_version_number
243 ,p_language_code => l_language_code
244 );
245 exception
246 when hr_api.cannot_find_prog_unit then
247 hr_api.cannot_find_prog_unit_error
248 (p_module_name => 'create_alias_value'
249 ,p_hook_type => 'AP'
250 );
251 end;
252 --
253 -- When in validation only mode raise the Validate_Enabled exception
254 --
255 if p_validate then
256 raise hr_api.validate_enabled;
257 end if;
258 --
259 -- Set all output arguments
260 --
261 p_alias_value_id := l_alias_value_id;
262 p_object_version_number := l_object_version_number;
263 --
264 if g_debug then
265 hr_utility.set_location(' Leaving:'||l_proc, 70);
266 end if;
267 exception
268 when hr_api.validate_enabled then
269 --
270 -- As the Validate_Enabled exception has been raised
271 -- we must rollback to the savepoint
272 --
273 rollback to create_alias_value;
274 --
275 -- Only set output warning arguments
276 -- (Any key or derived arguments must be set to null
277 -- when validation only mode is being used.)
278 --
279 p_alias_value_id := null;
280 p_object_version_number := null;
281 if g_debug then
282 hr_utility.set_location(' Leaving:'||l_proc, 80);
283 end if;
284 when others then
285 --
286 -- A validation or unexpected error has occured
287 --
288 rollback to create_alias_value;
289 if g_debug then
290 hr_utility.set_location(' Leaving:'||l_proc, 90);
291 end if;
292 raise;
293 end create_alias_value;
294 --
295 -- ----------------------------------------------------------------------------
296 -- |--------------------------< update_alias_value >--------------------------|
297 -- ----------------------------------------------------------------------------
298 --
299 procedure update_alias_value
300 (p_validate in boolean default false
301 ,p_alias_value_id in number
302 ,p_alias_value_name in varchar2
303 ,p_date_from in date
304 ,p_date_to in date default null
305 ,p_alias_definition_id in number
306 ,p_enabled_flag in varchar2
307 ,p_attribute_category in varchar2 default null
308 ,p_attribute1 in varchar2 default null
309 ,p_attribute2 in varchar2 default null
310 ,p_attribute3 in varchar2 default null
311 ,p_attribute4 in varchar2 default null
312 ,p_attribute5 in varchar2 default null
313 ,p_attribute6 in varchar2 default null
314 ,p_attribute7 in varchar2 default null
315 ,p_attribute8 in varchar2 default null
316 ,p_attribute9 in varchar2 default null
317 ,p_attribute10 in varchar2 default null
318 ,p_attribute11 in varchar2 default null
319 ,p_attribute12 in varchar2 default null
320 ,p_attribute13 in varchar2 default null
321 ,p_attribute14 in varchar2 default null
322 ,p_attribute15 in varchar2 default null
323 ,p_attribute16 in varchar2 default null
324 ,p_attribute17 in varchar2 default null
325 ,p_attribute18 in varchar2 default null
326 ,p_attribute19 in varchar2 default null
327 ,p_attribute20 in varchar2 default null
328 ,p_attribute21 in varchar2 default null
329 ,p_attribute22 in varchar2 default null
330 ,p_attribute23 in varchar2 default null
331 ,p_attribute24 in varchar2 default null
332 ,p_attribute25 in varchar2 default null
333 ,p_attribute26 in varchar2 default null
334 ,p_attribute27 in varchar2 default null
335 ,p_attribute28 in varchar2 default null
336 ,p_attribute29 in varchar2 default null
337 ,p_attribute30 in varchar2 default null
338 ,p_object_version_number in out nocopy number
339 ,p_language_code in varchar2 default hr_api.userenv_lang
340 ) is
341 --
342 -- Declare cursors and local variables
343 --
344
348
345 l_proc varchar2(72);
346 l_object_version_number hxc_alias_values.object_version_number%TYPE := p_object_version_number;
347 l_language_code hxc_alias_definitions_tl.language%TYPE;
349 begin
350 g_debug:=hr_utility.debug_enabled;
351 if g_debug then
352 l_proc := g_package||'update_alias_value';
353 hr_utility.set_location('Entering:'|| l_proc, 10);
354 end if;
355 --
356 -- Issue a savepoint
357 --
358 savepoint update_alias_value;
359 --
360 -- Truncate the time portion from all IN date parameters
361 --
362
363 -- Validate the language parameter. l_language_code should be passed
364 -- to functions instead of p_language_code from now on, to allow
365 -- an IN OUT parameter to be passed through.
366 --
367 l_language_code := p_language_code;
368 hr_api.validate_language_code(p_language_code => l_language_code);
369 --
370
371 --
372 -- Call Before Process User Hook
373 --
374 begin
375 hxc_alias_values_bk_1.update_alias_value_b
376 (p_alias_value_id => p_alias_value_id
377 ,p_alias_value_name => p_alias_value_name
378 ,p_date_from => p_date_from
379 ,p_date_to => p_date_to
380 ,p_alias_definition_id => p_alias_definition_id
381 ,p_enabled_flag => p_enabled_flag
382 ,p_attribute_category => p_attribute_category
383 ,p_attribute1 => p_attribute1
384 ,p_attribute2 => p_attribute2
385 ,p_attribute3 => p_attribute3
386 ,p_attribute4 => p_attribute4
387 ,p_attribute5 => p_attribute5
388 ,p_attribute6 => p_attribute6
389 ,p_attribute7 => p_attribute7
390 ,p_attribute8 => p_attribute8
391 ,p_attribute9 => p_attribute9
392 ,p_attribute10 => p_attribute10
393 ,p_attribute11 => p_attribute11
394 ,p_attribute12 => p_attribute12
395 ,p_attribute13 => p_attribute13
396 ,p_attribute14 => p_attribute14
397 ,p_attribute15 => p_attribute15
398 ,p_attribute16 => p_attribute16
399 ,p_attribute17 => p_attribute17
400 ,p_attribute18 => p_attribute18
401 ,p_attribute19 => p_attribute19
402 ,p_attribute20 => p_attribute20
403 ,p_attribute21 => p_attribute21
404 ,p_attribute22 => p_attribute22
405 ,p_attribute23 => p_attribute23
406 ,p_attribute24 => p_attribute24
407 ,p_attribute25 => p_attribute25
408 ,p_attribute26 => p_attribute26
409 ,p_attribute27 => p_attribute27
410 ,p_attribute28 => p_attribute28
411 ,p_attribute29 => p_attribute29
412 ,p_attribute30 => p_attribute30
413 ,p_object_version_number => p_object_version_number
414 ,p_language_code => l_language_code
415 );
416 exception
417 when hr_api.cannot_find_prog_unit then
418 hr_api.cannot_find_prog_unit_error
419 (p_module_name => 'update_alias_value'
420 ,p_hook_type => 'BP'
421 );
422 end;
423 --
424 -- Validation in addition to Row Handlers
425 --
426
427
428
429 --
430 -- Process Logic
431 --
432 if g_debug then
433 hr_utility.set_location(l_proc, 40);
434 end if;
435 --
436 -- call row handler to update record.
437 --
438 hxc_hav_upd.upd
439 (p_alias_value_id => p_alias_value_id
440 ,p_object_version_number => l_object_version_number
441 ,p_alias_value_name => p_alias_value_name
442 ,p_date_from => p_date_from
443 ,p_alias_definition_id => p_alias_definition_id
444 ,p_enabled_flag => p_enabled_flag
445 ,p_date_to => p_date_to
446 ,p_attribute_category => p_attribute_category
447 ,p_attribute1 => p_attribute1
448 ,p_attribute2 => p_attribute2
449 ,p_attribute3 => p_attribute3
450 ,p_attribute4 => p_attribute4
451 ,p_attribute5 => p_attribute5
452 ,p_attribute6 => p_attribute6
453 ,p_attribute7 => p_attribute7
454 ,p_attribute8 => p_attribute8
455 ,p_attribute9 => p_attribute9
456 ,p_attribute10 => p_attribute10
457 ,p_attribute11 => p_attribute11
458 ,p_attribute12 => p_attribute12
459 ,p_attribute13 => p_attribute13
460 ,p_attribute14 => p_attribute14
461 ,p_attribute15 => p_attribute15
462 ,p_attribute16 => p_attribute16
463 ,p_attribute17 => p_attribute17
464 ,p_attribute18 => p_attribute18
465 ,p_attribute19 => p_attribute19
469 ,p_attribute23 => p_attribute23
466 ,p_attribute20 => p_attribute20
467 ,p_attribute21 => p_attribute21
468 ,p_attribute22 => p_attribute22
470 ,p_attribute24 => p_attribute24
471 ,p_attribute25 => p_attribute25
472 ,p_attribute26 => p_attribute26
473 ,p_attribute27 => p_attribute27
474 ,p_attribute28 => p_attribute28
475 ,p_attribute29 => p_attribute29
476 ,p_attribute30 => p_attribute30
477 );
478
479 /*
480 -- Call row handler to update translated tables
481 --
482 hxc_vtl_upd.upd_tl
483 (p_language_code => l_language_code
484 ,p_alias_value_id => p_alias_value_id
485 ,p_alias_value_name => p_alias_value_name
486 );
487 */
488 --
489 -- Call After Process User Hook
490 --
491 begin
492 hxc_alias_values_bk_1.update_alias_value_a
493 (p_alias_value_id => p_alias_value_id
494 ,p_alias_value_name => p_alias_value_name
495 ,p_date_from => p_date_from
496 ,p_date_to => p_date_to
497 ,p_alias_definition_id => p_alias_definition_id
498 ,p_enabled_flag => p_enabled_flag
499 ,p_attribute_category => p_attribute_category
500 ,p_attribute1 => p_attribute1
501 ,p_attribute2 => p_attribute2
502 ,p_attribute3 => p_attribute3
503 ,p_attribute4 => p_attribute4
504 ,p_attribute5 => p_attribute5
505 ,p_attribute6 => p_attribute6
506 ,p_attribute7 => p_attribute7
507 ,p_attribute8 => p_attribute8
508 ,p_attribute9 => p_attribute9
509 ,p_attribute10 => p_attribute10
510 ,p_attribute11 => p_attribute11
511 ,p_attribute12 => p_attribute12
512 ,p_attribute13 => p_attribute13
513 ,p_attribute14 => p_attribute14
514 ,p_attribute15 => p_attribute15
515 ,p_attribute16 => p_attribute16
516 ,p_attribute17 => p_attribute17
517 ,p_attribute18 => p_attribute18
518 ,p_attribute19 => p_attribute19
519 ,p_attribute20 => p_attribute20
520 ,p_attribute21 => p_attribute21
521 ,p_attribute22 => p_attribute22
522 ,p_attribute23 => p_attribute23
523 ,p_attribute24 => p_attribute24
524 ,p_attribute25 => p_attribute25
525 ,p_attribute26 => p_attribute26
526 ,p_attribute27 => p_attribute27
527 ,p_attribute28 => p_attribute28
528 ,p_attribute29 => p_attribute29
529 ,p_attribute30 => p_attribute30
530 ,p_object_version_number => l_object_version_number
531 ,p_language_code => l_language_code
532 );
533 exception
534 when hr_api.cannot_find_prog_unit then
535 hr_api.cannot_find_prog_unit_error
536 (p_module_name => 'update_alias_value'
537 ,p_hook_type => 'AP'
538 );
539 end;
540 --
541 -- When in validation only mode raise the Validate_Enabled exception
542 --
543 if p_validate then
544 raise hr_api.validate_enabled;
545 end if;
546 --
547 -- Set all output arguments
548 --
549 p_object_version_number := l_object_version_number;
550 --
551 if g_debug then
552 hr_utility.set_location(' Leaving:'||l_proc, 70);
553 end if;
554 exception
555 when hr_api.validate_enabled then
556 --
557 -- As the Validate_Enabled exception has been raised
558 -- we must rollback to the savepoint
559 --
560 rollback to update_alias_value;
561 --
562 -- Only set output warning arguments
563 -- (Any key or derived arguments must be set to null
564 -- when validation only mode is being used.)
565 --
566 p_object_version_number := null;
567 if g_debug then
568 hr_utility.set_location(' Leaving:'||l_proc, 80);
569 end if;
570 when others then
571 --
572 -- A validation or unexpected error has occured
573 --
574 rollback to update_alias_value;
575 if g_debug then
576 hr_utility.set_location(' Leaving:'||l_proc, 90);
577 end if;
578 raise;
579 end update_alias_value;
580 --
581 -- ----------------------------------------------------------------------------
582 -- |------------------------< delete_alias_value >----------------------------|
583 -- ----------------------------------------------------------------------------
584 --
585 procedure delete_alias_value
586 (p_validate in boolean default false
587 ,p_alias_value_id in number
588 ,p_object_version_number in number
589 ) is
590 --
591 -- Declare cursors and local variables
592 --
593
597 g_debug:=hr_utility.debug_enabled;
594 l_proc varchar2(72);
595
596 begin
598 if g_debug then
599 l_proc := g_package||'delete_alias_value';
600 hr_utility.set_location('Entering:'|| l_proc, 10);
601 end if;
602 --
603 -- Issue a savepoint
604 --
605 savepoint delete_alias_value;
606 --
607 -- Truncate the time portion from all IN date parameters
608 --
609
610 --
611 -- Call Before Process User Hook
612 --
613 if g_debug then
614 hr_utility.set_location('Entering:'|| l_proc, 20);
615 end if;
616 --
617 begin
618 hxc_alias_values_bk_1.delete_alias_value_b
619 (p_alias_value_id => p_alias_value_id
620 ,p_object_version_number => p_object_version_number
621 );
622 exception
623 when hr_api.cannot_find_prog_unit then
624 hr_api.cannot_find_prog_unit_error
625 (p_module_name => 'delete_alias_value'
626 ,p_hook_type => 'BP'
627 );
628 end;
629 --
630 if g_debug then
631 hr_utility.set_location(l_proc, 30);
632 end if;
633 --
634 -- Validation in addition to Row Handlers
635 --
636
637
638
639 --
640 -- Process Logic
641 --
642 if g_debug then
643 hr_utility.set_location(l_proc, 40);
644 end if;
645 --
646 -- call row handler to delete record.
647 --
648 hxc_hav_del.del
649 (p_alias_value_id => p_alias_value_id
650 ,p_object_version_number => p_object_version_number
651 );
652 /*
653 --
654 -- Remove all matching translation rows
655 hxc_vtl_del.del_tl
659 --
656 (p_alias_value_id => p_alias_value_id
657 );
658 */
660 -- Call After Process User Hook
661 --
662 if g_debug then
663 hr_utility.set_location(l_proc, 50);
664 end if;
665 --
666 begin
667 hxc_alias_values_bk_1.delete_alias_value_a
668 (p_alias_value_id => p_alias_value_id
669 ,p_object_version_number => p_object_version_number
670 );
671 exception
672 when hr_api.cannot_find_prog_unit then
673 hr_api.cannot_find_prog_unit_error
674 (p_module_name => 'delete_alias_value'
675 ,p_hook_type => 'AP'
676 );
677 end;
678 --
679 -- When in validation only mode raise the Validate_Enabled exception
680 --
681 if p_validate then
682 raise hr_api.validate_enabled;
683 end if;
684 --
685 -- Set all output arguments
686 --
687 --
688 if g_debug then
689 hr_utility.set_location(' Leaving:'||l_proc, 70);
690 end if;
691 exception
692 when hr_api.validate_enabled then
693 --
694 -- As the Validate_Enabled exception has been raised
695 -- we must rollback to the savepoint
696 --
697 rollback to delete_alias_value;
698 --
699 -- Only set output warning arguments
700 -- (Any key or derived arguments must be set to null
701 -- when validation only mode is being used.)
702 --
703 if g_debug then
704 hr_utility.set_location(' Leaving:'||l_proc, 80);
705 end if;
706 when others then
707 --
708 -- A validation or unexpected error has occured
709 --
710 rollback to delete_alias_value;
711 if g_debug then
712 hr_utility.set_location(' Leaving:'||l_proc, 90);
713 end if;
714 raise;
715 end delete_alias_value;
716 --
717 end hxc_alias_values_api;