DBA Data[Home] [Help]

APPS.OTA_CERT_MBR_ENROLLMENT_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

450: -- Set all output arguments
451: --
452: p_object_version_number := l_object_version_number;
453:
454: hr_utility.set_location(' Leaving:'||l_proc, 70);
455: exception
456: when hr_api.validate_enabled then
457: --
458: -- As the Validate_Enabled exception has been raised

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

464: -- (Any key or derived arguments must be set to null
465: -- when validation only mode is being used.)
466: --
467: p_object_version_number := null;
468: hr_utility.set_location(' Leaving:'||l_proc, 80);
469: when others then
470: --
471: -- A validation or unexpected error has occured
472: --

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

471: -- A validation or unexpected error has occured
472: --
473: rollback to UPDATE_cert_mbr_enrollment;
474: p_object_version_number := l_object_version_number;
475: hr_utility.set_location(' Leaving:'||l_proc, 90);
476: raise;
477: end update_cert_mbr_enrollment;
478: --
479: -- ----------------------------------------------------------------------------

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

492: l_proc varchar2(72) := g_package||'DELETE_cert_mbr_enrollment';
493: --
494: --
495: begin
496: hr_utility.set_location('Entering:'|| l_proc, 10);
497: --
498: -- Issue a savepoint
499: --
500: savepoint DELETE_cert_mbr_enrollment;

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

549: --
550: -- Set all output arguments
551: --
552: --
553: hr_utility.set_location(' Leaving:'||l_proc, 170);
554: exception
555: when hr_api.validate_enabled then
556: --
557: -- As the Validate_Enabled exception has been raised

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

562: -- Only set output warning arguments
563: -- (Any key or derived arguments must be set to null
564: -- when validation only mode is being used.)
565: --
566: hr_utility.set_location(' Leaving:'||l_proc, 180);
567: when others then
568: --
569: -- A validation or unexpected error has occured
570: --

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

568: --
569: -- A validation or unexpected error has occured
570: --
571: rollback to DELETE_cert_mbr_enrollment;
572: hr_utility.set_location(' Leaving:'||l_proc, 190);
573: raise;
574: end delete_cert_mbr_enrollment;
575: --
576: end OTA_CERT_MBR_ENROLLMENT_api;