DBA Data[Home] [Help]

APPS.OTA_CATEGORY_USAGE_API dependencies on HR_UTILITY

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

94: l_effective_date date;
95: l_category varchar2(240);
96:
97: begin
98: hr_utility.set_location('Entering:'|| l_proc, 10);
99: --
100: -- Issue a savepoint
101: --
102: savepoint CREATE_CATEGORY;

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

282: --
283: p_category_usage_id := l_category_usage_id;
284: p_object_version_number := l_object_version_number;
285: --
286: hr_utility.set_location(' Leaving:'||l_proc, 70);
287: exception
288: when hr_api.validate_enabled then
289: --
290: -- As the Validate_Enabled exception has been raised

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

297: -- when validation only mode is being used.)
298: --
299: p_category_usage_id := null;
300: p_object_version_number := null;
301: hr_utility.set_location(' Leaving:'||l_proc, 80);
302: when others then
303: --
304: -- A validation or unexpected error has occured
305: --

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

305: --
306: rollback to CREATE_CATEGORY;
307: p_category_usage_id := null;
308: p_object_version_number := null;
309: hr_utility.set_location(' Leaving:'||l_proc, 90);
310: raise;
311: end create_category;
312: -- ----------------------------------------------------------------------------
313: -- |--------------------------< UPDATE_CATEGORY >-----------------------------|

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

369: l_activity_id ota_activity_definitions.activity_id%TYPE;
370: l_category varchar2(240);
371:
372: begin
373: hr_utility.set_location('Entering:'|| l_proc, 10);
374: --
375: -- Issue a savepoint
376: --
377: savepoint UPDATE_CATEGORY;

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

563: end if;
564: --
565: -- Set all output arguments
566: --
567: hr_utility.set_location(' Leaving:'||l_proc, 70);
568: exception
569: when hr_api.validate_enabled then
570: --
571: -- As the Validate_Enabled exception has been raised

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

577: -- (Any key or derived arguments must be set to null
578: -- when validation only mode is being used.)
579: --
580: p_object_version_number := null;
581: hr_utility.set_location(' Leaving:'||l_proc, 80);
582: when others then
583: --
584: -- A validation or unexpected error has occured
585: --

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

584: -- A validation or unexpected error has occured
585: --
586: rollback to UPDATE_CATEGORY;
587: p_object_version_number := l_object_version_number;
588: hr_utility.set_location(' Leaving:'||l_proc, 90);
589: raise;
590: end update_category;
591: --
592: -- ----------------------------------------------------------------------------

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

619:
620: --
621: --
622: begin
623: hr_utility.set_location('Entering:'|| l_proc, 10);
624: --
625: -- Issue a savepoint
626: --
627: savepoint DELETE_CATEGORY;

Line 701: hr_utility.set_location(' Leaving:'||l_proc, 170);

697: --
698: -- Set all output arguments
699: --
700: --
701: hr_utility.set_location(' Leaving:'||l_proc, 170);
702: exception
703: when hr_api.validate_enabled then
704: --
705: -- As the Validate_Enabled exception has been raised

Line 714: hr_utility.set_location(' Leaving:'||l_proc, 180);

710: -- Only set output warning arguments
711: -- (Any key or derived arguments must be set to null
712: -- when validation only mode is being used.)
713: --
714: hr_utility.set_location(' Leaving:'||l_proc, 180);
715: when others then
716: --
717: -- A validation or unexpected error has occured
718: --

Line 720: hr_utility.set_location(' Leaving:'||l_proc, 190);

716: --
717: -- A validation or unexpected error has occured
718: --
719: rollback to DELETE_CATEGORY;
720: hr_utility.set_location(' Leaving:'||l_proc, 190);
721: raise;
722: end delete_category;
723: --
724: end OTA_CATEGORY_USAGE_API;