DBA Data[Home] [Help]

APPS.HXC_PREF_HIERARCHIES_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_pref_hierarchies_api.';
7: g_debug boolean :=hr_utility.debug_enabled;
8: --
9: -- ----------------------------------------------------------------------------
10: -- |-----------------------------< get_node_data >----------------------------|
11: -- ----------------------------------------------------------------------------

Line 75: g_debug:=hr_utility.debug_enabled;

71:
72: --
73: begin
74: --
75: g_debug:=hr_utility.debug_enabled;
76: if g_debug then
77: l_proc := g_package||'get_node_data';
78: end if;
79: if p_preference_full_name is not null then

Line 82: hr_utility.set_location('Entering:'||l_proc, 5);

78: end if;
79: if p_preference_full_name is not null then
80:
81: if g_debug then
82: hr_utility.set_location('Entering:'||l_proc, 5);
83: end if;
84:
85: -- Consider preference_full_name A.B.C being passed.In this case the ID of node
86: -- C needs to be calculated.

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

169: p_object_version_number := l_object_version_number;
170: p_parent_pref_hierarchy_id := l_parent_pref_hierarchy_id;
171:
172: if g_debug then
173: hr_utility.set_location('Leaving :'||l_proc, 10);
174: end if;
175:
176: end get_node_data;
177: --

Line 239: g_debug:=hr_utility.debug_enabled;

235: l_proc varchar2(72);
236: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE;
237: l_pref_hierarchy_id hxc_pref_hierarchies.pref_hierarchy_id%TYPE;
238: begin
239: g_debug:=hr_utility.debug_enabled;
240: if g_debug then
241: l_proc := g_package||'create_pref_hierarchies';
242: hr_utility.set_location('Entering:'|| l_proc, 10);
243: end if;

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

238: begin
239: g_debug:=hr_utility.debug_enabled;
240: if g_debug then
241: l_proc := g_package||'create_pref_hierarchies';
242: hr_utility.set_location('Entering:'|| l_proc, 10);
243: end if;
244: --
245: -- Issue a savepoint
246: --

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

246: --
247: savepoint create_pref_hierarchies;
248: --
249: if g_debug then
250: hr_utility.set_location(l_proc, 20);
251: end if;
252: --
253: --
254: -- Truncate the time portion from all IN date parameters

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

314: );
315: end;
316: --
317: if g_debug then
318: hr_utility.set_location(l_proc, 30);
319: end if;
320: --
321: --
322: -- Validation in addition to Row Handlers

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

327: --
328: -- Process Logic
329: --
330: if g_debug then
331: hr_utility.set_location(l_proc, 40);
332: end if;
333: --
334: -- call row handler
335: --

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

382: ,p_code => p_code
383: );
384: --
385: if g_debug then
386: hr_utility.set_location(l_proc, 50);
387: end if;
388: --
389: -- Call After Process User Hook
390: --

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

445: );
446: end;
447: --
448: if g_debug then
449: hr_utility.set_location(l_proc, 60);
450: end if;
451: --
452: -- When in validation only mode raise the Validate_Enabled exception
453: --

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

455: raise hr_api.validate_enabled;
456: end if;
457: --
458: --if g_debug then
459: --hr_utility.set_location(' Leaving:'||l_proc, 70);
460: --end if;
461: --
462: --
463: -- Set all output arguments

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

465: p_pref_hierarchy_id := l_pref_hierarchy_id;
466: p_object_version_number := l_object_version_number;
467: --
468: if g_debug then
469: hr_utility.set_location(' Leaving:'||l_proc, 70);
470: end if;
471: exception
472: when hr_api.validate_enabled then
473: --

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

482: --
483: p_pref_hierarchy_id := null;
484: p_object_version_number := null;
485: if g_debug then
486: hr_utility.set_location(' Leaving:'||l_proc, 80);
487: end if;
488: when others then
489: --
490: -- A validation or unexpected error has occured

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

490: -- A validation or unexpected error has occured
491: --
492: rollback to create_pref_hierarchies;
493: if g_debug then
494: hr_utility.set_location(' Leaving:'||l_proc, 90);
495: end if;
496: raise;
497: --
498: end create_pref_hierarchies;

Line 562: g_debug:=hr_utility.debug_enabled;

558: l_object_version_number hxc_pref_hierarchies.object_version_number%TYPE := p_object_version_number;
559: --
560: Begin
561: --
562: g_debug:=hr_utility.debug_enabled;
563: if g_debug then
564: l_proc := g_package||' update_pref_hierarchies';
565: hr_utility.set_location('Entering:'|| l_proc, 10);
566: end if;

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

561: --
562: g_debug:=hr_utility.debug_enabled;
563: if g_debug then
564: l_proc := g_package||' update_pref_hierarchies';
565: hr_utility.set_location('Entering:'|| l_proc, 10);
566: end if;
567: --
568: -- Issue a savepoint if operating in validation only mode
569: --

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

569: --
570: savepoint update_pref_hierarchies;
571: --
572: if g_debug then
573: hr_utility.set_location(l_proc, 20);
574: end if;
575: --
576: -- Call Before Process User Hook
577: --

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

635: --
636: --insert into mtemp values('out of comp_b');
637: --commit;
638: --if g_debug then
639: --hr_utility.set_location(l_proc, 30);
640: --end if;
641: --
642: -- Process Logic
643: --

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

698: --insert into mtemp values('out of hax_hac_upd');
699: --commit;
700:
701: if g_debug then
702: hr_utility.set_location(l_proc, 40);
703: end if;
704: --
705: -- Call After Process User Hook
706: --

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

764: --insert into mtemp values('out of comp_a');
765: --commit;
766:
767: if g_debug then
768: hr_utility.set_location(l_proc, 50);
769: end if;
770: --
771: -- When in validation only mode raise the Validate_Enabled exception
772: --

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

774: raise hr_api.validate_enabled;
775: end if;
776: --
777: if g_debug then
778: hr_utility.set_location(' Leaving:'||l_proc, 60);
779: end if;
780: --
781: -- Set all output arguments
782: --

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

807: --insert into mtemp values('OVN set to null');
808: --commit;
809:
810: if g_debug then
811: hr_utility.set_location(' Leaving:'||l_proc, 60);
812: end if;
813: --
814: when others then
815: --

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

816: -- A validation or unexpected error has occured
817: --
818: ROLLBACK TO update_pref_hierarchies;
819: if g_debug then
820: hr_utility.set_location(' Leaving:'||l_proc, 70);
821: end if;
822: raise;
823: --
824: END update_pref_hierarchies;

Line 843: g_debug:=hr_utility.debug_enabled;

839: --
840: begin
841: --
842: --
843: g_debug:=hr_utility.debug_enabled;
844: if g_debug then
845: l_proc := g_package||'delete_pref_hierarchies';
846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: end if;

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

842: --
843: g_debug:=hr_utility.debug_enabled;
844: if g_debug then
845: l_proc := g_package||'delete_pref_hierarchies';
846: hr_utility.set_location('Entering:'|| l_proc, 10);
847: end if;
848: --
849: -- Issue a savepoint if operating in validation only mode
850: --

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

850: --
851: savepoint delete_pref_hierarchies;
852: --
853: if g_debug then
854: hr_utility.set_location(l_proc, 20);
855: end if;
856: --
857: -- Call Before Process User Hook
858: --

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

870: );
871: end;
872: --
873: if g_debug then
874: hr_utility.set_location(l_proc, 30);
875: end if;
876: --
877: -- Process Logic
878: --

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

882: ,p_object_version_number => p_object_version_number
883: );
884: --
885: if g_debug then
886: hr_utility.set_location(l_proc, 40);
887: end if;
888: --
889: -- Call After Process User Hook
890: --

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

908: raise hr_api.validate_enabled;
909: end if;
910: --
911: if g_debug then
912: hr_utility.set_location(' Leaving:'||l_proc, 50);
913: end if;
914: --
915: exception
916: --