60: l_object_version_number pqh_roles.object_version_number%TYPE;
61: --
62: begin
63: --
64: hr_utility.set_location('Entering:'|| l_proc, 10);
65: --
66: -- Issue a savepoint if operating in validation only mode
67: --
68: savepoint create_role;
66: -- Issue a savepoint if operating in validation only mode
67: --
68: savepoint create_role;
69: --
70: hr_utility.set_location(l_proc, 20);
71: --
72: -- Process Logic
73: --
74: begin
226: -- End of API User Hook for the after hook of create_role
227: --
228: end;
229: --
230: hr_utility.set_location(l_proc, 60);
231: --
232: -- When in validation only mode raise the Validate_Enabled exception
233: --
234: if p_validate then
239: --
240: p_role_id := l_role_id;
241: p_object_version_number := l_object_version_number;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 70);
244: --
245: exception
246: --
247: when hr_api.validate_enabled then
256: -- when validation only mode is being used.)
257: --
258: p_role_id := null;
259: p_object_version_number := null;
260: hr_utility.set_location(' Leaving:'||l_proc, 80);
261: --
262: when others then
263: p_role_id := null;
264: p_object_version_number := null;
321: l_object_version_number pqh_roles.object_version_number%TYPE;
322: --
323: begin
324: --
325: hr_utility.set_location('Entering:'|| l_proc, 10);
326: --
327: -- Issue a savepoint if operating in validation only mode
328: --
329: savepoint update_role;
327: -- Issue a savepoint if operating in validation only mode
328: --
329: savepoint update_role;
330: --
331: hr_utility.set_location(l_proc, 20);
332: --
333: -- Process Logic
334: --
335: l_object_version_number := p_object_version_number;
487: -- End of API User Hook for the after hook of update_role
488: --
489: end;
490: --
491: hr_utility.set_location(l_proc, 60);
492: --
493: -- When in validation only mode raise the Validate_Enabled exception
494: --
495: if p_validate then
499: -- Set all output arguments
500: --
501: p_object_version_number := l_object_version_number;
502: --
503: hr_utility.set_location(' Leaving:'||l_proc, 70);
504: --
505: exception
506: --
507: when hr_api.validate_enabled then
514: -- Only set output warning arguments
515: -- (Any key or derived arguments must be set to null
516: -- when validation only mode is being used.)
517: --
518: hr_utility.set_location(' Leaving:'||l_proc, 80);
519: --
520: when others then
521: p_object_version_number := l_object_version_number;
522: --
543: l_object_version_number pqh_roles.object_version_number%TYPE;
544: --
545: begin
546: --
547: hr_utility.set_location('Entering:'|| l_proc, 10);
548: --
549: -- Issue a savepoint if operating in validation only mode
550: --
551: savepoint delete_role;
549: -- Issue a savepoint if operating in validation only mode
550: --
551: savepoint delete_role;
552: --
553: hr_utility.set_location(l_proc, 20);
554: --
555: -- Process Logic
556: --
557: l_object_version_number := p_object_version_number;
605: -- End of API User Hook for the after hook of delete_role
606: --
607: end;
608: --
609: hr_utility.set_location(l_proc, 60);
610: --
611: -- When in validation only mode raise the Validate_Enabled exception
612: --
613: if p_validate then
613: if p_validate then
614: raise hr_api.validate_enabled;
615: end if;
616: --
617: hr_utility.set_location(' Leaving:'||l_proc, 70);
618: --
619: exception
620: --
621: when hr_api.validate_enabled then