DBA Data[Home] [Help]

APPS.PER_VACANCY_API dependencies on HR_UTILITY

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

82: l_effective_date date;
83: l_inv_pos_grade_warning boolean;
84: l_inv_job_grade_warning boolean;
85: begin
86: hr_utility.set_location('Entering:'|| l_proc, 10);
87: --
88: -- Issue a savepoint
89: --
90: savepoint create_vacancy;

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

303: P_OBJECT_VERSION_NUMBER := l_object_version_number;
304: p_inv_pos_grade_warning := l_inv_pos_grade_warning;
305: p_inv_job_grade_warning := l_inv_job_grade_warning;
306: --
307: hr_utility.set_location(' Leaving:'||l_proc, 70);
308: exception
309: when hr_api.validate_enabled then
310: --
311: -- As the Validate_Enabled exception has been raised

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

320: P_VACANCY_ID := null;
321: P_OBJECT_VERSION_NUMBER := null;
322: p_inv_pos_grade_warning := l_inv_pos_grade_warning;
323: p_inv_job_grade_warning := l_inv_job_grade_warning;
324: hr_utility.set_location(' Leaving:'||l_proc, 80);
325: when others then
326: --
327: -- A validation or unexpected error has occured
328: --

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

331: p_inv_pos_grade_warning :=null;
332: p_inv_job_grade_warning := null;
333:
334: rollback to create_vacancy;
335: hr_utility.set_location(' Leaving:'||l_proc, 90);
336: raise;
337: end create_vacancy;
338: --
339: -- ----------------------------------------------------------------------------

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

432: where paf.vacancy_id = p_vacancy_id
433: and paf.vacancy_id = pav.vacancy_id
434: and paf.assignment_type = 'A';
435: begin
436: hr_utility.set_location('Entering:'|| l_proc, 10);
437: --
438: -- Issue a savepoint
439: --
440: savepoint update_vacancy;

Line 516: hr_utility.set_location(l_proc, 20);

512: ,p_hook_type => 'BP'
513: );
514: end;
515: --
516: hr_utility.set_location(l_proc, 20);
517: --
518: -- Validation in addition to Row Handlers
519: --
520: per_vac_upd.upd

Line 568: hr_utility.set_location(l_proc, 30);

564: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
565: ,p_inv_job_grade_warning => l_inv_job_grade_warning
566: );
567: --
568: hr_utility.set_location(l_proc, 30);
569: --
570: -- look to see if the assignment needs updating
571: --
572: l_ASSIGNMENT_CHANGED := FALSE;

Line 636: hr_utility.set_location(l_proc, 40);

632: if l_ASSIGNMENT_CHANGED = TRUE then
633: --
634: -- fix for the bug 5719667
635: l_position_id := p_position_id;
636: hr_utility.set_location(l_proc, 40);
637: --
638: update per_all_assignments_f asg
639: set asg.organization_id = nvl(l_organization_id, asg.organization_id)
640: ,asg.job_id = nvl(l_job_id, asg.job_id)

Line 664: hr_utility.set_location(l_proc, 50);

660: or nvl(asg.supervisor_id, -1) <> nvl(l_manager_id, nvl(asg.supervisor_id, -1))
661: );
662: end if;
663: --
664: hr_utility.set_location(l_proc, 50);
665: --
666: -- Call After Process User Hook
667: --
668: begin

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

746: P_OBJECT_VERSION_NUMBER := l_object_version_number;
747: p_inv_pos_grade_warning := l_inv_pos_grade_warning;
748: p_inv_job_grade_warning := l_inv_job_grade_warning;
749: --
750: hr_utility.set_location(' Leaving:'||l_proc, 70);
751: exception
752: when hr_api.validate_enabled then
753: --
754: -- As the Validate_Enabled exception has been raised

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

761: -- Only set output warning arguments
762: -- (Any key or derived arguments must be set to null
763: -- when validation only mode is being used.)
764: --
765: hr_utility.set_location(' Leaving:'||l_proc, 80);
766: when others then
767: --
768: -- A validation or unexpected error has occured
769: --

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

772: p_inv_pos_grade_warning := null;
773: p_inv_job_grade_warning := null;
774:
775: rollback to update_vacancy;
776: hr_utility.set_location(' Leaving:'||l_proc, 90);
777: raise;
778: end update_vacancy;
779: --
780: -- ----------------------------------------------------------------------------

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

793: --
794:
795: l_proc varchar2(72) := g_package||'delete_vacancy';
796: begin
797: hr_utility.set_location('Entering:'|| l_proc, 10);
798: --
799: -- Issue a savepoint
800: --
801: savepoint delete_vacancy;

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

854: --
855: -- Set all output arguments
856: --
857: --
858: hr_utility.set_location(' Leaving:'||l_proc, 70);
859: exception
860: when hr_api.validate_enabled then
861: --
862: -- As the Validate_Enabled exception has been raised

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

867: -- Only set output warning arguments
868: -- (Any key or derived arguments must be set to null
869: -- when validation only mode is being used.)
870: --
871: hr_utility.set_location(' Leaving:'||l_proc, 80);
872: when others then
873: --
874: -- A validation or unexpected error has occured
875: --

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

873: --
874: -- A validation or unexpected error has occured
875: --
876: rollback to delete_vacancy;
877: hr_utility.set_location(' Leaving:'||l_proc, 90);
878: raise;
879: end delete_vacancy;
880: --
881: end PER_VACANCY_API;