DBA Data[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;