74: ,p_solution_type_name => p_solution_type_name
75: ,p_name => p_name
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_SOLUTION_CMPT_NAME_b'
81: ,p_hook_type => 'BP'
82: );
75: ,p_name => p_name
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_SOLUTION_CMPT_NAME_b'
81: ,p_hook_type => 'BP'
82: );
83: end;
101: ,p_name => p_name
102: ,p_object_version_number => p_object_version_number
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_SOLUTION_CMPT_NAME_a'
108: ,p_hook_type => 'AP'
109: );
102: ,p_object_version_number => p_object_version_number
103: );
104: exception
105: when hr_api.cannot_find_prog_unit then
106: hr_api.cannot_find_prog_unit_error
107: (p_module_name => 'CREATE_SOLUTION_CMPT_NAME_a'
108: ,p_hook_type => 'AP'
109: );
110: end;
111: --
112: -- When in validation only mode raise the Validate_Enabled exception
113: --
114: if p_validate then
115: raise hr_api.validate_enabled;
116: end if;
117: --
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
127: -- we must rollback to the savepoint
128: --
154: (p_validate in boolean default false
155: ,p_solution_id in number
156: ,p_component_name in varchar2
157: ,p_solution_type_name in varchar2
158: ,p_name in varchar2 default hr_api.g_varchar2
159: ,p_template_file in varchar2
160: ,p_object_version_number in out nocopy number
161: ) is
162: --
187: ,p_solution_type_name => p_solution_type_name
188: ,p_name => p_name
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'UPDATE_SOLUTION_CMPT_NAME_b'
194: ,p_hook_type => 'BP'
195: );
188: ,p_name => p_name
189: );
190: exception
191: when hr_api.cannot_find_prog_unit then
192: hr_api.cannot_find_prog_unit_error
193: (p_module_name => 'UPDATE_SOLUTION_CMPT_NAME_b'
194: ,p_hook_type => 'BP'
195: );
196: end;
214: ,p_solution_type_name => p_solution_type_name
215: ,p_name => p_name
216: );
217: exception
218: when hr_api.cannot_find_prog_unit then
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'UPDATE_SOLUTION_CMPT_NAME_a'
221: ,p_hook_type => 'AP'
222: );
215: ,p_name => p_name
216: );
217: exception
218: when hr_api.cannot_find_prog_unit then
219: hr_api.cannot_find_prog_unit_error
220: (p_module_name => 'UPDATE_SOLUTION_CMPT_NAME_a'
221: ,p_hook_type => 'AP'
222: );
223: end;
224: --
225: -- When in validation only mode raise the Validate_Enabled exception
226: --
227: if p_validate then
228: raise hr_api.validate_enabled;
229: end if;
230: --
231: --
232: -- Set all output arguments
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
241: -- we must rollback to the savepoint
242: --
287: ,p_solution_type_name => p_solution_type_name
288: ,p_object_version_number => p_object_version_number
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'DELETE_SOLUTION_CMPT_NAME_b'
294: ,p_hook_type => 'BP'
295: );
288: ,p_object_version_number => p_object_version_number
289: );
290: exception
291: when hr_api.cannot_find_prog_unit then
292: hr_api.cannot_find_prog_unit_error
293: (p_module_name => 'DELETE_SOLUTION_CMPT_NAME_b'
294: ,p_hook_type => 'BP'
295: );
296: end;
309: ,p_solution_type_name => p_solution_type_name
310: ,p_object_version_number => p_object_version_number
311: );
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_SOLUTION_CMPT_NAME_a'
316: ,p_hook_type => 'AP'
317: );
310: ,p_object_version_number => p_object_version_number
311: );
312: exception
313: when hr_api.cannot_find_prog_unit then
314: hr_api.cannot_find_prog_unit_error
315: (p_module_name => 'DELETE_SOLUTION_CMPT_NAME_a'
316: ,p_hook_type => 'AP'
317: );
318: end;
319: --
320: -- When in validation only mode raise the Validate_Enabled exception
321: --
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
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: --