DBA Data[Home] [Help]

APPS.HXC_ALIAS_VALUES_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_values_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |--------------------------< create_alias_value >--------------------------|
11: -- ----------------------------------------------------------------------------

Line 65: g_debug:=hr_utility.debug_enabled;

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;

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

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: --

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

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: --

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

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: --

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

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

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

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: --

Line 350: g_debug:=hr_utility.debug_enabled;

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;
348:
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;

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

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: --

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

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: --

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

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: --

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

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

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

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: --

Line 597: g_debug:=hr_utility.debug_enabled;

593:
594: l_proc varchar2(72);
595:
596: begin
597: g_debug:=hr_utility.debug_enabled;
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;

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

596: begin
597: g_debug:=hr_utility.debug_enabled;
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: --

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

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

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

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: --

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

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: --

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

659: --
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

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

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: --

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

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

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

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: --