DBA Data[Home] [Help]

APPS.OTA_LP_ENROLLMENT_API dependencies on HR_UTILITY

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

84:
85: l_type ota_learning_paths.path_source_code%type;
86:
87: begin
88: hr_utility.set_location('Entering:'|| l_proc, 10);
89: --
90: -- Issue a savepoint
91: --
92: savepoint CREATE_LP_ENROLLMENT;

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

312:
313: end if;
314:
315:
316: hr_utility.set_location(' Leaving:'||l_proc, 70);
317: exception
318: when hr_api.validate_enabled then
319: --
320: -- As the Validate_Enabled exception has been raised

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

327: -- when validation only mode is being used.)
328: --
329: p_lp_enrollment_id := null;
330: p_object_version_number := null;
331: hr_utility.set_location(' Leaving:'||l_proc, 80);
332: when others then
333: --
334: -- A validation or unexpected error has occured
335: --

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

335: --
336: rollback to CREATE_LP_ENROLLMENT;
337: p_lp_enrollment_id := null;
338: p_object_version_number := null;
339: hr_utility.set_location(' Leaving:'||l_proc, 90);
340: raise;
341: end create_lp_enrollment;
342: -- ----------------------------------------------------------------------------
343: -- |-------------------------< UPDATE_LP_ENROLLMENT >-------------------------|

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

434: l_type ota_learning_paths.path_source_code%type;
435:
436:
437: begin
438: hr_utility.set_location('Entering:'|| l_proc, 10);
439: --
440: -- Issue a savepoint
441: --
442: savepoint UPDATE_LP_ENROLLMENT;

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

680: p_lp_enrollment_id => p_lp_enrollment_id,
681: p_event_fired => 'LP_UNSUBSCRIBE');
682: end if;
683:
684: hr_utility.set_location(' Leaving:'||l_proc, 70);
685: exception
686: when hr_api.validate_enabled then
687: --
688: -- As the Validate_Enabled exception has been raised

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

694: -- (Any key or derived arguments must be set to null
695: -- when validation only mode is being used.)
696: --
697: p_object_version_number := null;
698: hr_utility.set_location(' Leaving:'||l_proc, 80);
699: when others then
700: --
701: -- A validation or unexpected error has occured
702: --

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

701: -- A validation or unexpected error has occured
702: --
703: rollback to UPDATE_LP_ENROLLMENT;
704: p_object_version_number := l_object_version_number;
705: hr_utility.set_location(' Leaving:'||l_proc, 90);
706: raise;
707: end update_lp_enrollment;
708: --
709: -- ----------------------------------------------------------------------------

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

722: l_proc varchar2(72) := g_package||'DELETE_LP_ENROLLMENT';
723: --
724: --
725: begin
726: hr_utility.set_location('Entering:'|| l_proc, 10);
727: --
728: -- Issue a savepoint
729: --
730: savepoint DELETE_LP_ENROLLMENT;

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

779: --
780: -- Set all output arguments
781: --
782: --
783: hr_utility.set_location(' Leaving:'||l_proc, 170);
784: exception
785: when hr_api.validate_enabled then
786: --
787: -- As the Validate_Enabled exception has been raised

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

792: -- Only set output warning arguments
793: -- (Any key or derived arguments must be set to null
794: -- when validation only mode is being used.)
795: --
796: hr_utility.set_location(' Leaving:'||l_proc, 180);
797: when others then
798: --
799: -- A validation or unexpected error has occured
800: --

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

798: --
799: -- A validation or unexpected error has occured
800: --
801: rollback to DELETE_LP_ENROLLMENT;
802: hr_utility.set_location(' Leaving:'||l_proc, 190);
803: raise;
804: end delete_lp_enrollment;
805: --
806: -- ----------------------------------------------------------------------------

Line 1174: hr_utility.set_location(' Leaving:' || l_proc, 30);

1170: -- Reset IN OUT parameters and set OUT parameters
1171: --
1172: p_lp_enrollment_id := null;
1173: p_path_status_code := null;
1174: hr_utility.set_location(' Leaving:' || l_proc, 30);
1175:
1176: when others then
1177: --
1178: -- A validation or unexpected error has occured

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

1183: --
1184: p_lp_enrollment_id := null;
1185: p_path_status_code := null;
1186:
1187: hr_utility.set_location(' Leaving:' || l_proc,50);
1188: raise;
1189: END subscribe_to_learning_path;
1190: end ota_lp_enrollment_api;
1191: