DBA Data[Home] [Help]

APPS.HR_DE_ORGANIZATION_LINKS_API dependencies on HR_UTILITY

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

94: l_business_group_id hr_de_organization_links.business_group_id%TYPE;
95: l_organization_link_id hr_de_organization_links.organization_link_id%TYPE;
96: l_object_version_number hr_de_organization_links.object_version_number%TYPE;
97: begin
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: --
100: -- Issue a savepoint
101: --
102: savepoint create_link;

Line 112: hr_utility.set_message(801,'XXX');

108: open csr_get_derived_details(p_parent_organization_id);
109: fetch csr_get_derived_details into l_business_group_id;
110: if csr_get_derived_details%NOTFOUND then
111: close csr_get_derived_details;
112: hr_utility.set_message(801,'XXX');
113: hr_utility.raise_error;
114: end if;
115: close csr_get_derived_details;
116: --

Line 113: hr_utility.raise_error;

109: fetch csr_get_derived_details into l_business_group_id;
110: if csr_get_derived_details%NOTFOUND then
111: close csr_get_derived_details;
112: hr_utility.set_message(801,'XXX');
113: hr_utility.raise_error;
114: end if;
115: close csr_get_derived_details;
116: --
117: -- Call Before Process User Hook

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

357: --
358: p_organization_link_id := l_organization_link_id;
359: p_object_version_number := l_object_version_number;
360: --
361: hr_utility.set_location(' Leaving:'||l_proc, 70);
362: exception
363: when hr_api.validate_enabled then
364: --
365: -- As the Validate_Enabled exception has been raised

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

372: -- when validation only mode is being used.)
373: --
374: p_organization_link_id := null;
375: p_object_version_number := null;
376: hr_utility.set_location(' Leaving:'||l_proc, 80);
377: when others then
378: --
379: -- A validation or unexpected error has occured
380: --

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

382: -- Set OUT parameters.
383: --
384: p_organization_link_id := null;
385: p_object_version_number := null;
386: hr_utility.set_location(' Leaving:'||l_proc, 90);
387: raise;
388: end create_link;
389: --
390: -- ----------------------------------------------------------------------------

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

465: l_proc varchar2(72) := g_package||'update_link';
466: l_object_version_number hr_de_organization_links.object_version_number%TYPE := p_object_version_number;
467: l_temp_ovn number := p_object_version_number;
468: begin
469: hr_utility.set_location('Entering:'|| l_proc, 10);
470: --
471: -- Issue a savepoint
472: --
473: savepoint update_link;

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

704: -- Set all output arguments
705: --
706: p_object_version_number := l_object_version_number;
707: --
708: hr_utility.set_location(' Leaving:'||l_proc, 70);
709: exception
710: when hr_api.validate_enabled then
711: --
712: -- As the Validate_Enabled exception has been raised

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

718: -- (Any key or derived arguments must be set to null
719: -- when validation only mode is being used.)
720: --
721: p_object_version_number := l_temp_ovn;
722: hr_utility.set_location(' Leaving:'||l_proc, 80);
723: when others then
724: --
725: -- A validation or unexpected error has occured
726: --

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

726: --
727: rollback to update_link;
728: -- Reset IN OUT parameters.
729: p_object_version_number := l_temp_ovn;
730: hr_utility.set_location(' Leaving:'||l_proc, 90);
731: raise;
732: end update_link;
733: --
734: -- ----------------------------------------------------------------------------

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

744: -- Declare local variables
745: --
746: l_proc varchar2(72) := g_package||'delete_link';
747: begin
748: hr_utility.set_location('Entering:'|| l_proc, 10);
749: --
750: -- Issue a savepoint
751: --
752: savepoint delete_link;

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

788: if p_validate then
789: raise hr_api.validate_enabled;
790: end if;
791: --
792: hr_utility.set_location(' Leaving:'||l_proc, 70);
793: exception
794: when hr_api.validate_enabled then
795: --
796: -- As the Validate_Enabled exception has been raised

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

801: -- Only set output warning arguments
802: -- (Any key or derived arguments must be set to null
803: -- when validation only mode is being used.)
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 80);
806: when others then
807: --
808: -- A validation or unexpected error has occured
809: --

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

807: --
808: -- A validation or unexpected error has occured
809: --
810: rollback to delete_link;
811: hr_utility.set_location(' Leaving:'||l_proc, 90);
812: raise;
813: end delete_link;
814: --
815: -- ----------------------------------------------------------------------------

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

824: -- Declare local variables
825: --
826: l_proc varchar2(72) := g_package||'lck';
827: begin
828: hr_utility.set_location('Entering:'|| l_proc, 10);
829: --
830: -- Lock the record.
831: --
832: hr_ord_shd.lck

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

832: hr_ord_shd.lck
833: (p_organization_link_id => p_organization_link_id
834: ,p_object_version_number => p_object_version_number);
835: --
836: hr_utility.set_location(' Leaving:'||l_proc, 70);
837: end lck;
838: --
839: end hr_de_organization_links_api;