50: l_solution_type_name PER_SOLUTION_CMPT_NAMES.SOLUTION_TYPE_NAME%TYPE;
51: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
52: --
53: begin
54: hr_utility.set_location('Entering:'|| l_proc, 10);
55: --
56: savepoint CREATE_SOLUTION_CMPT_NAME;
57: --
58: -- Register user key values
118: -- Set all output arguments
119: --
120: p_object_version_number := l_object_version_number;
121: --
122: hr_utility.set_location(' Leaving:'||l_proc, 70);
123: exception
124: when hr_api.validate_enabled then
125: --
126: -- As the Validate_Enabled exception has been raised
133: -- when validation only mode is being used.)
134: --
135: p_object_version_number := null;
136: --
137: hr_utility.set_location(' Leaving:'||l_proc, 80);
138: when others then
139: --
140: -- A validation or unexpected error has occured
141: --
139: --
140: -- A validation or unexpected error has occured
141: --
142: rollback to CREATE_SOLUTION_CMPT_NAME;
143: hr_utility.set_location(' Leaving:'||l_proc, 90);
144: raise;
145: end CREATE_SOLUTION_CMPT_NAME;
146: --
147:
166: l_effective_date date;
167: l_object_version_number PER_SOLUTION_CMPT_NAMES.OBJECT_VERSION_NUMBER%TYPE;
168: --
169: begin
170: hr_utility.set_location('Entering:'|| l_proc, 10);
171: --
172: savepoint UPDATE_SOLUTION_CMPT_NAME;
173: --
174: -- Store initial value for OVN in out parameter.
232: -- Set all output arguments
233: --
234: p_object_version_number := l_object_version_number;
235: --
236: hr_utility.set_location(' Leaving:'||l_proc, 70);
237: exception
238: when hr_api.validate_enabled then
239: --
240: -- As the Validate_Enabled exception has been raised
245: -- Only set output warning arguments
246: -- (Any key or derived arguments must be set to null
247: -- when validation only mode is being used.)
248: --
249: hr_utility.set_location(' Leaving:'||l_proc, 80);
250: when others then
251: --
252: -- A validation or unexpected error has occured
253: --
251: --
252: -- A validation or unexpected error has occured
253: --
254: rollback to UPDATE_SOLUTION_CMPT_NAME;
255: hr_utility.set_location(' Leaving:'||l_proc, 90);
256: raise;
257: end UPDATE_SOLUTION_CMPT_NAME;
258:
259:
273: --
274: l_proc varchar2(72) := g_package||'DELETE_SOLUTION_CMPT_NAME';
275: --
276: begin
277: hr_utility.set_location('Entering:'|| l_proc, 10);
278: --
279: savepoint DELETE_SOLUTION_CMPT_NAME;
280: --
281: -- Call Before Process User Hook
322: if p_validate then
323: raise hr_api.validate_enabled;
324: end if;
325: --
326: hr_utility.set_location(' Leaving:'||l_proc, 70);
327: exception
328: when hr_api.validate_enabled then
329: --
330: -- As the Validate_Enabled exception has been raised
331: -- we must rollback to the savepoint
332: --
333: rollback to DELETE_SOLUTION_CMPT_NAME;
334: --
335: hr_utility.set_location(' Leaving:'||l_proc, 80);
336: when others then
337: --
338: rollback to DELETE_SOLUTION_CMPT_NAME;
339: --
336: when others then
337: --
338: rollback to DELETE_SOLUTION_CMPT_NAME;
339: --
340: hr_utility.set_location(' Leaving:'||l_proc, 90);
341: --
342: raise;
343: --
344: end DELETE_SOLUTION_CMPT_NAME;