DBA Data[Home] [Help]

APPS.OTA_CERT_CATEGORY_API dependencies on HR_UTILITY

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

50: l_object_version_number number;
51: l_effective_date date;
52:
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_cert_cat_inclusion;

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

192: --
193: --
194: p_object_version_number := l_object_version_number;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 70);
197: exception
198: when hr_api.validate_enabled then
199: --
200: -- As the Validate_Enabled exception has been raised

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

206: -- (Any key or derived arguments must be set to null
207: -- when validation only mode is being used.)
208: --
209: p_object_version_number := null;
210: hr_utility.set_location(' Leaving:'||l_proc, 80);
211: when others then
212: --
213: -- A validation or unexpected error has occured
214: --

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

213: -- A validation or unexpected error has occured
214: --
215: rollback to create_cert_cat_inclusion;
216: p_object_version_number := null;
217: hr_utility.set_location(' Leaving:'||l_proc, 90);
218: raise;
219: end create_cert_cat_inclusion ;
220: -- ----------------------------------------------------------------------------
221: -- |-------------------------< update_cert_cat_inclusion >-------------------|

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

259: l_object_version_number number := p_object_version_number;
260: l_effective_date date;
261:
262: begin
263: hr_utility.set_location('Entering:'|| l_proc, 10);
264: --
265: -- Issue a savepoint
266: --
267: savepoint update_cert_cat_inclusion ;

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

400: -- Set all output arguments
401: --
402: p_object_version_number := l_object_version_number;
403: --
404: hr_utility.set_location(' Leaving:'||l_proc, 70);
405: exception
406: when hr_api.validate_enabled then
407: --
408: -- As the Validate_Enabled exception has been raised

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

414: -- (Any key or derived arguments must be set to null
415: -- when validation only mode is being used.)
416: --
417: p_object_version_number := null;
418: hr_utility.set_location(' Leaving:'||l_proc, 80);
419: when others then
420: --
421: -- A validation or unexpected error has occured
422: --

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

420: --
421: -- A validation or unexpected error has occured
422: --
423: rollback to update_cert_cat_inclusion ;
424: hr_utility.set_location(' Leaving:'||l_proc, 90);
425: p_object_version_number := l_object_version_number;
426: raise;
427: end update_cert_cat_inclusion ;
428:

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

443: --
444: l_proc varchar2(72) := g_package||' delete_cert_cat_inclusion ';
445: --
446: begin
447: hr_utility.set_location('Entering:'|| l_proc, 10);
448: --
449: -- Issue a savepoint
450: --
451: savepoint delete_cert_cat_inclusion ;

Line 503: hr_utility.set_location(' Leaving:'||l_proc, 170);

499: --
500: -- Set all output arguments
501: --
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 170);
504: exception
505: when hr_api.validate_enabled then
506: --
507: -- As the Validate_Enabled exception has been raised

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

512: -- Only set output warning arguments
513: -- (Any key or derived arguments must be set to null
514: -- when validation only mode is being used.)
515: --
516: hr_utility.set_location(' Leaving:'||l_proc, 180);
517: when others then
518: --
519: -- A validation or unexpected error has occured
520: --

Line 522: hr_utility.set_location(' Leaving:'||l_proc, 190);

518: --
519: -- A validation or unexpected error has occured
520: --
521: rollback to delete_cert_cat_inclusion ;
522: hr_utility.set_location(' Leaving:'||l_proc, 190);
523: raise;
524: end delete_cert_cat_inclusion;
525: --
526: end ota_cert_category_api;