DBA Data[Home] [Help]

APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on HR_UTILITY

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

62:
63: l_mode varchar2(1);
64:
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint
69: --
70: savepoint CREATE_cert_mbr_enrollment;

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

210: if p_validate then
211: raise hr_api.validate_enabled;
212: end if;
213:
214: hr_utility.set_location(' Leaving:'||l_proc, 70);
215: exception
216: when hr_api.validate_enabled then
217: --
218: -- As the Validate_Enabled exception has been raised

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

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

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

233: --
234: rollback to CREATE_cert_mbr_enrollment;
235: p_cert_mbr_enrollment_id := null;
236: p_object_version_number := null;
237: hr_utility.set_location(' Leaving:'||l_proc, 90);
238: raise;
239: end create_cert_mbr_enrollment;
240: -- ----------------------------------------------------------------------------
241: -- |-------------------------< UPDATE_cert_mbr_enrollment >-------------------------|

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

297:
298: l_mode varchar2(1);
299:
300: begin
301: hr_utility.set_location('Entering:'|| l_proc, 10);
302: --
303: -- Issue a savepoint
304: --
305: savepoint UPDATE_cert_mbr_enrollment;

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

461: -- Set all output arguments
462: --
463: p_object_version_number := l_object_version_number;
464:
465: hr_utility.set_location(' Leaving:'||l_proc, 70);
466: exception
467: when hr_api.validate_enabled then
468: --
469: -- As the Validate_Enabled exception has been raised

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

475: -- (Any key or derived arguments must be set to null
476: -- when validation only mode is being used.)
477: --
478: p_object_version_number := null;
479: hr_utility.set_location(' Leaving:'||l_proc, 80);
480: when others then
481: --
482: -- A validation or unexpected error has occured
483: --

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

482: -- A validation or unexpected error has occured
483: --
484: rollback to UPDATE_cert_mbr_enrollment;
485: p_object_version_number := l_object_version_number;
486: hr_utility.set_location(' Leaving:'||l_proc, 90);
487: raise;
488: end update_cert_mbr_enrollment;
489: --
490: -- ----------------------------------------------------------------------------

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

503: l_proc varchar2(72) := g_package||'DELETE_cert_mbr_enrollment';
504: --
505: --
506: begin
507: hr_utility.set_location('Entering:'|| l_proc, 10);
508: --
509: -- Issue a savepoint
510: --
511: savepoint DELETE_cert_mbr_enrollment;

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

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

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

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

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

579: --
580: -- A validation or unexpected error has occured
581: --
582: rollback to DELETE_cert_mbr_enrollment;
583: hr_utility.set_location(' Leaving:'||l_proc, 190);
584: raise;
585: end delete_cert_mbr_enrollment;
586: --
587: end OTA_CERT_MBR_ENROLLMENT_api;