49: ,p_solution_set_name => p_solution_set_name
50: ,p_user_id => p_user_id
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'CREATE_SOLUTIONS_SELECTED_b'
56: ,p_hook_type => 'BP'
57: );
50: ,p_user_id => p_user_id
51: );
52: exception
53: when hr_api.cannot_find_prog_unit then
54: hr_api.cannot_find_prog_unit_error
55: (p_module_name => 'CREATE_SOLUTIONS_SELECTED_b'
56: ,p_hook_type => 'BP'
57: );
58: end;
74: ,p_user_id => p_user_id
75: ,p_object_version_number => p_object_version_number
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'CREATE_SOLUTIONS_SELECTED_a'
81: ,p_hook_type => 'AP'
82: );
75: ,p_object_version_number => p_object_version_number
76: );
77: exception
78: when hr_api.cannot_find_prog_unit then
79: hr_api.cannot_find_prog_unit_error
80: (p_module_name => 'CREATE_SOLUTIONS_SELECTED_a'
81: ,p_hook_type => 'AP'
82: );
83: end;
84: --
85: -- When in validation only mode raise the Validate_Enabled exception
86: --
87: if p_validate then
88: raise hr_api.validate_enabled;
89: end if;
90: --
91: -- Set all output arguments
92: --
93: p_object_version_number := l_object_version_number;
94: --
95: hr_utility.set_location(' Leaving:'||l_proc, 70);
96: exception
97: when hr_api.validate_enabled then
98: --
99: -- As the Validate_Enabled exception has been raised
100: -- we must rollback to the savepoint
101: --
157: ,p_solution_set_name => p_solution_set_name
158: ,p_user_id => p_user_id
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'UPDATE_SOLUTIONS_SELECTED_b'
164: ,p_hook_type => 'BP'
165: );
158: ,p_user_id => p_user_id
159: );
160: exception
161: when hr_api.cannot_find_prog_unit then
162: hr_api.cannot_find_prog_unit_error
163: (p_module_name => 'UPDATE_SOLUTIONS_SELECTED_b'
164: ,p_hook_type => 'BP'
165: );
166: end;
182: ,p_solution_set_name => p_solution_set_name
183: ,p_user_id => p_user_id
184: );
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'UPDATE_SOLUTIONS_SELECTED_a'
189: ,p_hook_type => 'AP'
190: );
183: ,p_user_id => p_user_id
184: );
185: exception
186: when hr_api.cannot_find_prog_unit then
187: hr_api.cannot_find_prog_unit_error
188: (p_module_name => 'UPDATE_SOLUTIONS_SELECTED_a'
189: ,p_hook_type => 'AP'
190: );
191: end;
192: --
193: -- When in validation only mode raise the Validate_Enabled exception
194: --
195: if p_validate then
196: raise hr_api.validate_enabled;
197: end if;
198: --
199: --
200: -- Set all output arguments
202: p_object_version_number := l_object_version_number;
203: --
204: hr_utility.set_location(' Leaving:'||l_proc, 70);
205: exception
206: when hr_api.validate_enabled then
207: --
208: -- As the Validate_Enabled exception has been raised
209: -- we must rollback to the savepoint
210: --
255: ,p_user_id => p_user_id
256: ,p_object_version_number => p_object_version_number
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'DELETE_SOLUTIONS_SELECTED_b'
262: ,p_hook_type => 'BP'
263: );
256: ,p_object_version_number => p_object_version_number
257: );
258: exception
259: when hr_api.cannot_find_prog_unit then
260: hr_api.cannot_find_prog_unit_error
261: (p_module_name => 'DELETE_SOLUTIONS_SELECTED_b'
262: ,p_hook_type => 'BP'
263: );
264: end;
277: ,p_user_id => p_user_id
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_SOLUTIONS_SELECTED_a'
284: ,p_hook_type => 'AP'
285: );
278: ,p_object_version_number => p_object_version_number
279: );
280: exception
281: when hr_api.cannot_find_prog_unit then
282: hr_api.cannot_find_prog_unit_error
283: (p_module_name => 'DELETE_SOLUTIONS_SELECTED_a'
284: ,p_hook_type => 'AP'
285: );
286: end;
287: --
288: -- When in validation only mode raise the Validate_Enabled exception
289: --
290: if p_validate then
291: raise hr_api.validate_enabled;
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: exception
292: end if;
293: --
294: hr_utility.set_location(' Leaving:'||l_proc, 70);
295: exception
296: when hr_api.validate_enabled then
297: --
298: -- As the Validate_Enabled exception has been raised
299: -- we must rollback to the savepoint
300: --