DBA Data[Home] [Help]

APPS.PER_REQUISITIONS_API dependencies on HR_UTILITY

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

62: l_date_from date;
63: l_date_to date;
64:
65: begin
66: hr_utility.set_location('Entering:'|| l_proc, 10);
67: --
68: -- Issue a savepoint
69: --
70: savepoint create_requisition;

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

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

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

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

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

251: --
252: p_requisition_id := null;
253: p_object_version_number := null;
254: rollback to CREATE_REQUISITION;
255: hr_utility.set_location(' Leaving:'||l_proc, 90);
256: raise;
257: end CREATE_REQUISITION;
258: --
259: -- ----------------------------------------------------------------------------

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

310: l_date_from date;
311: l_date_to date;
312: l_temp_ovn number := p_object_version_number;
313: begin
314: hr_utility.set_location('Entering:'|| l_proc, 10);
315: --
316: -- Issue a savepoint
317: --
318: savepoint update_requisition;

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

474: -- Set all output arguments
475: --
476: p_object_version_number := l_object_version_number;
477: --
478: hr_utility.set_location(' Leaving:'||l_proc, 70);
479: exception
480: when hr_api.validate_enabled then
481: --
482: -- As the Validate_Enabled exception has been raised

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

487: -- Only set output warning arguments
488: -- (Any key or derived arguments must be set to null
489: -- when validation only mode is being used.)
490: --
491: hr_utility.set_location(' Leaving:'||l_proc, 80);
492: when others then
493: --
494: -- A validation or unexpected error has occured
495: --

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

494: -- A validation or unexpected error has occured
495: --
496: p_object_version_number := l_temp_ovn;
497: rollback to UPDATE_REQUISITION;
498: hr_utility.set_location(' Leaving:'||l_proc, 90);
499: raise;
500: end UPDATE_REQUISITION;
501: --
502: -- ----------------------------------------------------------------------------

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

513: --
514:
515: l_proc varchar2(72) := g_package||'delete_requisition';
516: begin
517: hr_utility.set_location('Entering:'|| l_proc, 10);
518: --
519: -- Issue a savepoint
520: --
521: savepoint delete_requisition;

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

573: --
574: -- Set all output arguments
575: --
576: --
577: hr_utility.set_location(' Leaving:'||l_proc, 70);
578: exception
579: when hr_api.validate_enabled then
580: --
581: -- As the Validate_Enabled exception has been raised

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

586: -- Only set output warning arguments
587: -- (Any key or derived arguments must be set to null
588: -- when validation only mode is being used.)
589: --
590: hr_utility.set_location(' Leaving:'||l_proc, 80);
591: when others then
592: --
593: -- A validation or unexpected error has occured
594: --

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

592: --
593: -- A validation or unexpected error has occured
594: --
595: rollback to DELETE_REQUISITION;
596: hr_utility.set_location(' Leaving:'||l_proc, 90);
597: raise;
598: end DELETE_REQUISITION;
599: --
600: end PER_REQUISITIONS_API;