[Home] [Help]
25: l_object_version_number number;
26: l_security_organization_id number;
27: --
28: begin
29: hr_utility.set_location('Entering:'|| l_proc, 10);
30: --
31: -- Issue a savepoint
32: --
33: savepoint create_security_organization;
86: --
87: p_security_organization_id := l_security_organization_id;
88: p_object_version_number := l_object_version_number;
89: --
90: hr_utility.set_location(' Leaving:'||l_proc, 70);
91: exception
92: when hr_api.validate_enabled then
93: --
94: -- As the Validate_Enabled exception has been raised
101: -- when validation only mode is being used.)
102: --
103: p_security_organization_id := null;
104: p_object_version_number := null;
105: hr_utility.set_location(' Leaving:'||l_proc, 80);
106: when others then
107: --
108: -- A validation or unexpected error has occured
109: --
109: --
110: p_security_organization_id := null;
111: p_object_version_number := null;
112: rollback to create_security_organization;
113: hr_utility.set_location(' Leaving:'||l_proc, 90);
114: raise;
115: end create_security_organization;
116: --
117: -- ----------------------------------------------------------------------------
134: l_object_version_number number := p_object_version_number;
135: l_temp_ovn number := p_object_version_number;
136: --
137: begin
138: hr_utility.set_location('Entering:'|| l_proc, 10);
139: --
140: -- Issue a savepoint
141: --
142: savepoint update_security_organization;
198: -- Set all output arguments
199: --
200: p_object_version_number := l_object_version_number;
201: --
202: hr_utility.set_location(' Leaving:'||l_proc, 70);
203: --
204: exception
205: when hr_api.validate_enabled then
206: --
212: -- Only set output warning arguments
213: -- (Any key or derived arguments must be set to null
214: -- when validation only mode is being used.)
215: --
216: hr_utility.set_location(' Leaving:'||l_proc, 80);
217: when others then
218: --
219: -- A validation or unexpected error has occured
220: --
219: -- A validation or unexpected error has occured
220: --
221: p_object_version_number := l_temp_ovn;
222: rollback to update_irc_asg_status;
223: hr_utility.set_location(' Leaving:'||l_proc, 90);
224: raise;
225: end update_security_organization;
226: --
227: -- ----------------------------------------------------------------------------
238: --
239: l_proc varchar2(72) := g_package||'delete_security_organization';
240: --
241: begin
242: hr_utility.set_location('Entering:'|| l_proc, 10);
243: --
244: -- Issue a savepoint
245: --
246: savepoint delete_security_organization;
291: end if;
292: --
293: -- Set all output arguments
294: --
295: hr_utility.set_location(' Leaving:'||l_proc, 70);
296: exception
297: when hr_api.validate_enabled then
298: --
299: -- As the Validate_Enabled exception has been raised
304: -- Only set output warning arguments
305: -- (Any key or derived arguments must be set to null
306: -- when validation only mode is being used.)
307: --
308: hr_utility.set_location(' Leaving:'||l_proc, 80);
309: when others then
310: --
311: -- A validation or unexpected error has occured
312: --
310: --
311: -- A validation or unexpected error has occured
312: --
313: rollback to delete_security_organization;
314: hr_utility.set_location(' Leaving:'||l_proc, 90);
315: raise;
316: end delete_security_organization;
317: --
318: end HR_SECURITY_ORGANIZATION_API;