DBA Data[Home] [Help]

APPS.PQP_VEHICLE_DETAILS_API dependencies on HR_UTILITY

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

80: -- Declare cursors and local variables
81: --
82: l_proc varchar2(72) := g_package||'create_vehicle_details>';
83: begin
84: hr_utility.set_location('Entering:'|| l_proc, 10);
85: --
86: -- Issue a savepoint
87: --
88: savepoint create_vehicle_details;

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

176: --p_vehicle_details_id := NULL;
177: --p_object_version_number := NULL;
178: --p_some_warning := ;
179: --
180: hr_utility.set_location(' Leaving:'||l_proc, 70);
181: exception
182: when hr_api.validate_enabled then
183: --
184: -- As the Validate_Enabled exception has been raised

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

192: --
193: --p_id := null;
194: --p_object_version_number := null;
195: --p_some_warning := ;
196: hr_utility.set_location(' Leaving:'||l_proc, 80);
197: when others then
198: --
199: -- A validation or unexpected error has occured
200: --

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

200: --
201: rollback to create_vehicle_details;
202: p_vehicle_details_id := null;
203: p_object_version_number := null;
204: hr_utility.set_location(' Leaving:'||l_proc, 90);
205: raise;
206: end create_vehicle_details;
207:
208: -- ----------------------------------------------------------------------------

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

281: --
282: l_object_version_number pqp_vehicle_details.object_version_number%TYPE;
283: l_proc varchar2(72) := g_package||'update_vehicle_details>';
284: begin
285: hr_utility.set_location('Entering:'|| l_proc, 10);
286: --
287: -- Issue a savepoint
288: --
289: savepoint update_vehicle_details;

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

379: --
380: --p_object_version_number := NULL;
381: --p_some_warning := ;
382: --
383: hr_utility.set_location(' Leaving:'||l_proc, 70);
384: exception
385: when hr_api.validate_enabled then
386: --
387: -- As the Validate_Enabled exception has been raised

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

394: -- when validation only mode is being used.)
395: --
396: --p_object_version_number := null;
397: -- p_some_warning := ;
398: hr_utility.set_location(' Leaving:'||l_proc, 80);
399: when others then
400: --
401: -- A validation or unexpected error has occured
402: --

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

401: -- A validation or unexpected error has occured
402: --
403: rollback to update_vehicle_details;
404: p_object_version_number := l_object_version_number;
405: hr_utility.set_location(' Leaving:'||l_proc, 90);
406: raise;
407: end update_vehicle_details;
408:
409: -- ----------------------------------------------------------------------------

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

420: --
421: l_object_version_number pqp_vehicle_details.object_version_number%TYPE;
422: l_proc varchar2(72) := g_package||'delete_vehicle_details>';
423: begin
424: hr_utility.set_location('Entering:'|| l_proc, 10);
425: --
426: -- Issue a savepoint
427: --
428: savepoint delete_vehicle_details;

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

452: --
453: --p_object_version_number := NULL;
454: --p_some_warning := ;
455: --
456: hr_utility.set_location(' Leaving:'||l_proc, 70);
457: exception
458: when hr_api.validate_enabled then
459: --
460: -- As the Validate_Enabled exception has been raised

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

467: -- when validation only mode is being used.)
468: --
469: -- p_object_version_number := null;
470: -- p_some_warning := ;
471: hr_utility.set_location(' Leaving:'||l_proc, 80);
472: when others then
473: --
474: -- A validation or unexpected error has occured
475: --

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

473: --
474: -- A validation or unexpected error has occured
475: --
476: rollback to delete_vehicle_details;
477: hr_utility.set_location(' Leaving:'||l_proc, 90);
478: raise;
479: end delete_vehicle_details;
480: --
481: end PQP_VEHICLE_DETAILS_API;