DBA Data[Home] [Help]

APPS.IRC_AGENCY_VACANCIES_API dependencies on HR_UTILITY

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

60: l_end_date irc_agency_vacancies.end_date%type;
61: l_proc varchar2(72) := g_package||'.CREATE_AGENCY_VACANCY';
62: --
63: begin
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint
67: --
68: savepoint CREATE_AGENCY_VACANCY;

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

230: --
231: p_object_version_number := l_object_version_number;
232: p_agency_vacancy_id := l_agency_vacancy_id;
233: --
234: hr_utility.set_location(' Leaving:'||l_proc, 70);
235: exception
236: when hr_api.validate_enabled then
237: --
238: -- As the Validate_Enabled exception has been raised

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

245: -- when validation only mode is being used.)
246: --
247: p_object_version_number := null;
248: p_agency_vacancy_id := null;
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: when others then
251: --
252: -- A validation or unexpected error has occured
253: --

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

257: -- OUT parameters, including warnings, to null
258: --
259: p_object_version_number := null;
260: p_agency_vacancy_id := null;
261: hr_utility.set_location(' Leaving:'||l_proc, 90);
262: raise;
263: end create_agency_vacancy;
264: --
265: -- ----------------------------------------------------------------------------

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

317: l_end_date irc_agency_vacancies.end_date%type;
318: l_proc varchar2(72) := g_package||'UPDATE_AGENCY_VACANCY';
319: --
320: begin
321: hr_utility.set_location('Entering:'|| l_proc, 10);
322: --
323: -- Issue a savepoint
324: --
325: savepoint UPDATE_AGENCY_VACANCY;

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

491: -- Set all IN OUT and OUT parameters with out values
492: --
493: p_object_version_number := l_object_version_number;
494: --
495: hr_utility.set_location(' Leaving:'||l_proc, 70);
496: exception
497: when hr_api.validate_enabled then
498: --
499: -- As the Validate_Enabled exception has been raised

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

505: -- (Any key or derived arguments must be set to null
506: -- when validation only mode is being used.)
507: --
508: p_object_version_number := l_object_version_number;
509: hr_utility.set_location(' Leaving:'||l_proc, 80);
510: when others then
511: --
512: -- A validation or unexpected error has occured
513: --

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

516: -- Reset IN OUT parameters and set all
517: -- OUT parameters, including warnings, to null
518: --
519: p_object_version_number := l_object_version_number;
520: hr_utility.set_location(' Leaving:'||l_proc, 90);
521: raise;
522: end update_agency_vacancy;
523: --
524: -- ----------------------------------------------------------------------------

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

535: --
536: l_proc varchar2(72) := g_package||'DELETE_AGENCY_VACANCY';
537: --
538: begin
539: hr_utility.set_location('Entering:'|| l_proc, 10);
540: --
541: -- Issue a savepoint
542: --
543: savepoint DELETE_AGENCY_VACANCY;

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

585: if p_validate then
586: raise hr_api.validate_enabled;
587: end if;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 70);
590: exception
591: when hr_api.validate_enabled then
592: --
593: -- As the Validate_Enabled exception has been raised

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

594: -- we must rollback to the savepoint
595: --
596: rollback to DELETE_AGENCY_VACANCY;
597: --
598: hr_utility.set_location(' Leaving:'||l_proc, 80);
599: when others then
600: --
601: -- A validation or unexpected error has occured
602: --

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

601: -- A validation or unexpected error has occured
602: --
603: rollback to DELETE_AGENCY_VACANCY;
604: --
605: hr_utility.set_location(' Leaving:'||l_proc, 90);
606: raise;
607: end delete_agency_vacancy;
608: --
609: end IRC_AGENCY_VACANCIES_API;