DBA Data[Home] [Help]

APPS.OTA_LP_SECTION_API dependencies on HR_UTILITY

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

51: l_object_version_number number;
52: l_effective_date date;
53:
54: begin
55: hr_utility.set_location('Entering:'|| l_proc, 10);
56: --
57: -- Issue a savepoint
58: --
59: savepoint create_lp_section;

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

211: --
212: p_learning_path_section_id := l_learning_path_section_id;
213: p_object_version_number := l_object_version_number;
214: --
215: hr_utility.set_location(' Leaving:'||l_proc, 70);
216: exception
217: when hr_api.validate_enabled then
218: --
219: -- As the Validate_Enabled exception has been raised

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

226: -- when validation only mode is being used.)
227: --
228: p_learning_path_section_id := null;
229: p_object_version_number := null;
230: hr_utility.set_location(' Leaving:'||l_proc, 80);
231: when others then
232: --
233: -- A validation or unexpected error has occured
234: --

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

234: --
235: rollback to create_lp_section;
236: p_learning_path_section_id := null;
237: p_object_version_number := null;
238: hr_utility.set_location(' Leaving:'||l_proc, 90);
239: raise;
240: end create_lp_section;
241: -- ----------------------------------------------------------------------------
242: -- |-------------------------< update_lp_section >-------------------|

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

301: duration_units is not null OR
302: notify_days_before_target IS NOT NULL);
303:
304: begin
305: hr_utility.set_location('Entering:'|| l_proc, 10);
306: --
307: -- Issue a savepoint
308: --
309: savepoint update_lp_section;

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

481: -- Set all output arguments
482: --
483: p_object_version_number := l_object_version_number;
484: --
485: hr_utility.set_location(' Leaving:'||l_proc, 70);
486: exception
487: when hr_api.validate_enabled then
488: --
489: -- As the Validate_Enabled exception has been raised

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

495: -- (Any key or derived arguments must be set to null
496: -- when validation only mode is being used.)
497: --
498: p_object_version_number := null;
499: hr_utility.set_location(' Leaving:'||l_proc, 80);
500: when others then
501: --
502: -- A validation or unexpected error has occured
503: --

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

501: --
502: -- A validation or unexpected error has occured
503: --
504: rollback to update_lp_section;
505: hr_utility.set_location(' Leaving:'||l_proc, 90);
506: p_object_version_number := l_object_version_number;
507: raise;
508: end update_lp_section;
509:

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

522: --
523: l_proc varchar2(72) := g_package||' Delete Learning Path Section';
524: --
525: begin
526: hr_utility.set_location('Entering:'|| l_proc, 10);
527: --
528: -- Issue a savepoint
529: --
530: savepoint delete_lp_section;

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

577: --
578: -- Set all output arguments
579: --
580: --
581: hr_utility.set_location(' Leaving:'||l_proc, 170);
582: exception
583: when hr_api.validate_enabled then
584: --
585: -- As the Validate_Enabled exception has been raised

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

590: -- Only set output warning arguments
591: -- (Any key or derived arguments must be set to null
592: -- when validation only mode is being used.)
593: --
594: hr_utility.set_location(' Leaving:'||l_proc, 180);
595: when others then
596: --
597: -- A validation or unexpected error has occured
598: --

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

596: --
597: -- A validation or unexpected error has occured
598: --
599: rollback to delete_lp_section;
600: hr_utility.set_location(' Leaving:'||l_proc, 190);
601: raise;
602: end delete_lp_section;
603: --
604: end ota_lp_section_api;