DBA Data[Home] [Help]

APPS.PER_VACANCY_API dependencies on HR_UTILITY

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

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

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

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

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

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

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

335: p_inv_pos_grade_warning :=null;
336: p_inv_job_grade_warning := null;
337:
338: rollback to create_vacancy;
339: hr_utility.set_location(' Leaving:'||l_proc, 90);
340: raise;
341: end create_vacancy;
342: --
343: -- ----------------------------------------------------------------------------

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

437: where paf.vacancy_id = p_vacancy_id
438: and paf.vacancy_id = pav.vacancy_id
439: and paf.assignment_type = 'A';
440: begin
441: hr_utility.set_location('Entering:'|| l_proc, 10);
442: --
443: -- Issue a savepoint
444: --
445: savepoint update_vacancy;

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

518: ,p_hook_type => 'BP'
519: );
520: end;
521: --
522: hr_utility.set_location(l_proc, 20);
523: --
524: -- Validation in addition to Row Handlers
525: --
526: per_vac_upd.upd

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

571: ,p_inv_pos_grade_warning => l_inv_pos_grade_warning
572: ,p_inv_job_grade_warning => l_inv_job_grade_warning
573: );
574: --
575: hr_utility.set_location(l_proc, 30);
576: --
577: -- look to see if the assignment needs updating
578: --
579: l_ASSIGNMENT_CHANGED := FALSE;

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

640: if l_ASSIGNMENT_CHANGED = TRUE then
641: --
642: -- fix for the bug 5719667
643: --l_position_id := p_position_id;
644: hr_utility.set_location(l_proc, 40);
645:
646: l_job_id := case
647: when nvl(p_job_id,0) = hr_api.g_number then per_vac_shd.g_old_rec.job_id
648: else p_job_id

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

731: --end changes for bug 8518955
732:
733: end if;
734: --
735: hr_utility.set_location(l_proc, 50);
736: --
737: -- Call After Process User Hook
738: --
739: begin

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

818: P_OBJECT_VERSION_NUMBER := l_object_version_number;
819: p_inv_pos_grade_warning := l_inv_pos_grade_warning;
820: p_inv_job_grade_warning := l_inv_job_grade_warning;
821: --
822: hr_utility.set_location(' Leaving:'||l_proc, 70);
823: exception
824: when hr_api.validate_enabled then
825: --
826: -- As the Validate_Enabled exception has been raised

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

833: -- Only set output warning arguments
834: -- (Any key or derived arguments must be set to null
835: -- when validation only mode is being used.)
836: --
837: hr_utility.set_location(' Leaving:'||l_proc, 80);
838: when others then
839: --
840: -- A validation or unexpected error has occured
841: --

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

844: p_inv_pos_grade_warning := null;
845: p_inv_job_grade_warning := null;
846:
847: rollback to update_vacancy;
848: hr_utility.set_location(' Leaving:'||l_proc, 90);
849: raise;
850: end update_vacancy;
851: --
852: -- ----------------------------------------------------------------------------

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

865: --
866:
867: l_proc varchar2(72) := g_package||'delete_vacancy';
868: begin
869: hr_utility.set_location('Entering:'|| l_proc, 10);
870: --
871: -- Issue a savepoint
872: --
873: savepoint delete_vacancy;

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

926: --
927: -- Set all output arguments
928: --
929: --
930: hr_utility.set_location(' Leaving:'||l_proc, 70);
931: exception
932: when hr_api.validate_enabled then
933: --
934: -- As the Validate_Enabled exception has been raised

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

939: -- Only set output warning arguments
940: -- (Any key or derived arguments must be set to null
941: -- when validation only mode is being used.)
942: --
943: hr_utility.set_location(' Leaving:'||l_proc, 80);
944: when others then
945: --
946: -- A validation or unexpected error has occured
947: --

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

945: --
946: -- A validation or unexpected error has occured
947: --
948: rollback to delete_vacancy;
949: hr_utility.set_location(' Leaving:'||l_proc, 90);
950: raise;
951: end delete_vacancy;
952: --
953: end PER_VACANCY_API;