DBA Data[Home] [Help]

APPS.OTA_CERT_MEMBER_API dependencies on HR_UTILITY

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

74: l_object_version_number number;
75: l_effective_date date;
76:
77: begin
78: hr_utility.set_location('Entering:'|| l_proc, 10);
79: --
80: -- Issue a savepoint
81: --
82: savepoint create_certification_member;

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

219: --
220: p_certification_member_id := l_certification_member_id;
221: p_object_version_number := l_object_version_number;
222: --
223: hr_utility.set_location(' Leaving:'||l_proc, 70);
224: exception
225: when hr_api.validate_enabled then
226: --
227: -- As the Validate_Enabled exception has been raised

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

234: -- when validation only mode is being used.)
235: --
236: p_certification_member_id := null;
237: p_object_version_number := null;
238: hr_utility.set_location(' Leaving:'||l_proc, 80);
239: raise;
240: end create_certification_member;
241:
242: --

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

305: l_object_version_number number := p_object_version_number;
306: l_effective_date date;
307:
308: begin
309: hr_utility.set_location('Entering:'|| l_proc, 10);
310: --
311: -- Issue a savepoint
312: --
313: savepoint update_certification_member;

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

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

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

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

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

468: --
469: -- A validation or unexpected error has occured
470: --
471: rollback to update_certification_member;
472: hr_utility.set_location(' Leaving:'||l_proc, 90);
473: p_object_version_number := l_object_version_number;
474: raise;
475: end update_certification_member;
476: --

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

509: --
510: l_proc varchar2(72) := g_package||' Delete Certification Member';
511: --
512: begin
513: hr_utility.set_location('Entering:'|| l_proc, 10);
514: --
515: -- Issue a savepoint
516: --
517: savepoint delete_certification_member;

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

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

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

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

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

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