57: -- Other variables
58: l_category_usage_id number;
59: l_proc varchar2(72) := g_package ||'create_category';
60: Begin
61: hr_utility.set_location(' Entering:' || l_proc,10);
62: --
63: -- Issue a savepoint
64: --
65: savepoint create_category_swi;
136: -- messages of any type exist in the Multiple Message List.
137: -- Also disable Multiple Message Detection.
138: --
139: p_return_status := hr_multi_message.get_return_status_disable;
140: hr_utility.set_location(' Leaving:' || l_proc,20);
141: --
142: exception
143: when hr_multi_message.error_message_exist then
144: --
151: -- Reset IN OUT parameters and set OUT parameters
152: --
153: p_object_version_number := null;
154: p_return_status := hr_multi_message.get_return_status_disable;
155: hr_utility.set_location(' Leaving:' || l_proc, 30);
156: when others then
157: --
158: -- When Multiple Message Detection is enabled catch
159: -- any Application specific or other unexpected
162: -- error.
163: --
164: rollback to create_category_swi;
165: if hr_multi_message.unexpected_error_add(l_proc) then
166: hr_utility.set_location(' Leaving:' || l_proc,40);
167: raise;
168: end if;
169: --
170: -- Reset IN OUT and set OUT parameters
170: -- Reset IN OUT and set OUT parameters
171: --
172: p_object_version_number := null;
173: p_return_status := hr_multi_message.get_return_status_disable;
174: hr_utility.set_location(' Leaving:' || l_proc,50);
175: end create_category;
176: -- ----------------------------------------------------------------------------
177: -- |----------------------------< delete_category >---------------------------|
178: -- ----------------------------------------------------------------------------
190: --
191: -- Other variables
192: l_proc varchar2(72) := g_package ||'delete_category';
193: Begin
194: hr_utility.set_location(' Entering:' || l_proc,10);
195: --
196: -- Issue a savepoint
197: --
198: savepoint delete_category_swi;
232: -- messages of any type exist in the Multiple Message List.
233: -- Also disable Multiple Message Detection.
234: --
235: p_return_status := hr_multi_message.get_return_status_disable;
236: hr_utility.set_location(' Leaving:' || l_proc,20);
237: --
238: exception
239: when hr_multi_message.error_message_exist then
240: --
246: --
247: -- Reset IN OUT parameters and set OUT parameters
248: --
249: p_return_status := hr_multi_message.get_return_status_disable;
250: hr_utility.set_location(' Leaving:' || l_proc, 30);
251: when others then
252: --
253: -- When Multiple Message Detection is enabled catch
254: -- any Application specific or other unexpected
257: -- error.
258: --
259: rollback to delete_category_swi;
260: if hr_multi_message.unexpected_error_add(l_proc) then
261: hr_utility.set_location(' Leaving:' || l_proc,40);
262: raise;
263: end if;
264: --
265: -- Reset IN OUT and set OUT parameters
264: --
265: -- Reset IN OUT and set OUT parameters
266: --
267: p_return_status := hr_multi_message.get_return_status_disable;
268: hr_utility.set_location(' Leaving:' || l_proc,50);
269: end delete_category;
270: -- ----------------------------------------------------------------------------
271: -- |----------------------------< update_category >---------------------------|
272: -- ----------------------------------------------------------------------------
317: --
318: -- Other variables
319: l_proc varchar2(72) := g_package ||'update_category';
320: Begin
321: hr_utility.set_location(' Entering:' || l_proc,10);
322: --
323: -- Issue a savepoint
324: --
325: savepoint update_category_swi;
392: -- messages of any type exist in the Multiple Message List.
393: -- Also disable Multiple Message Detection.
394: --
395: p_return_status := hr_multi_message.get_return_status_disable;
396: hr_utility.set_location(' Leaving:' || l_proc,20);
397: --
398: exception
399: when hr_multi_message.error_message_exist then
400: --
407: -- Reset IN OUT parameters and set OUT parameters
408: --
409: p_object_version_number := l_object_version_number;
410: p_return_status := hr_multi_message.get_return_status_disable;
411: hr_utility.set_location(' Leaving:' || l_proc, 30);
412: when others then
413: --
414: -- When Multiple Message Detection is enabled catch
415: -- any Application specific or other unexpected
418: -- error.
419: --
420: rollback to update_category_swi;
421: if hr_multi_message.unexpected_error_add(l_proc) then
422: hr_utility.set_location(' Leaving:' || l_proc,40);
423: raise;
424: end if;
425: --
426: -- Reset IN OUT and set OUT parameters
426: -- Reset IN OUT and set OUT parameters
427: --
428: p_object_version_number := l_object_version_number;
429: p_return_status := hr_multi_message.get_return_status_disable;
430: hr_utility.set_location(' Leaving:' || l_proc,50);
431: end update_category;
432: --
433: end ota_category_usage_swi;