DBA Data[Home] [Help]

APPS.OTA_CATEGORY_USAGE_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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