DBA Data[Home] [Help]

APPS.IRC_INTERVIEW_DETAILS_API dependencies on HR_UTILITY

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

54: l_end_date date;
55: l_swi_package_name varchar2(30) := 'IRC_INTERVIEW_DETAILS_SWI';
56: l_effective_date date;
57: begin
58: hr_utility.set_location('Entering:'|| l_proc, 10);
59: --
60: -- Issue a savepoint
61: --
62: savepoint create_irc_interview_details;

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

198: p_object_version_number := l_object_version_number;
199: p_start_date := l_start_date;
200: p_end_date := l_end_date;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: exception
204: when hr_api.validate_enabled then
205: --
206: -- As the Validate_Enabled exception has been raised

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

215: p_interview_details_id := null;
216: p_object_version_number := null;
217: p_start_date := null;
218: p_end_date := null;
219: hr_utility.set_location(' Leaving:'||l_proc, 80);
220: when others then
221: --
222: -- A validation or unexpected error has occured
223: --

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

229: p_interview_details_id := null;
230: p_object_version_number := null;
231: p_start_date := null;
232: p_end_date := null;
233: hr_utility.set_location(' Leaving:'||l_proc, 90);
234: raise;
235: end create_irc_interview_details;
236: --
237: --

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

282: l_end_date date;
283: l_effective_date date;
284: l_proc varchar2(72) := g_package||'update_irc_interview_details';
285: begin
286: hr_utility.set_location('Entering:'|| l_proc, 10);
287: --
288: -- Issue a savepoint
289: --
290: savepoint update_irc_interview_details;

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

430: p_object_version_number := l_object_version_number;
431: p_start_date := l_start_date;
432: p_end_date := l_end_date;
433: --
434: hr_utility.set_location(' Leaving:'||l_proc, 70);
435: exception
436: when hr_api.validate_enabled then
437: --
438: -- As the Validate_Enabled exception has been raised

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

445: -- when validation only mode is being used.)
446: --
447: p_start_date := null;
448: p_end_date := null;
449: hr_utility.set_location(' Leaving:'||l_proc, 80);
450: when others then
451: --
452: -- A validation or unexpected error has occured
453: --

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

457: -- OUT parameters, including warnings, to null
458: --
459: p_start_date := null;
460: p_end_date := null;
461: hr_utility.set_location(' Leaving:'||l_proc, 90);
462: raise;
463: end update_irc_interview_details;
464: --
465: --

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

498: from irc_interview_details
499: where event_id = p_event_id;
500: --
501: begin
502: hr_utility.set_location('Entering:'|| l_proc, 10);
503: --
504: -- Issue a savepoint
505: --
506: savepoint copy_interview_details;

Line 638: hr_utility.set_location(' Leaving:'||l_proc, 20);

634: --
635: END LOOP;
636: --
637: --
638: hr_utility.set_location(' Leaving:'||l_proc, 20);
639: exception
640: when hr_api.validate_enabled then
641: --
642: -- As the Validate_Enabled exception has been raised

Line 647: hr_utility.set_location(' Leaving:'||l_proc, 30);

643: -- we must rollback to the savepoint
644: --
645: rollback to copy_interview_details;
646: --
647: hr_utility.set_location(' Leaving:'||l_proc, 30);
648: when others then
649: --
650: -- A validation or unexpected error has occured
651: --

Line 654: hr_utility.set_location(' Leaving:'||l_proc, 40);

650: -- A validation or unexpected error has occured
651: --
652: rollback to copy_interview_details;
653: --
654: hr_utility.set_location(' Leaving:'||l_proc, 40);
655: raise;
656: end copy_interview_details;
657: --
658: end irc_interview_details_api;