33: -- Other variables
34: l_template_detail_id number;
35: l_proc varchar2(72) := g_package ||'create_template_details';
36: Begin
37: hr_utility.set_location(' Entering:' || l_proc,10);
38: --
39: -- Issue a savepoint
40: --
41: savepoint create_template_details_swi;
99: -- messages of any type exist in the Multiple Message List.
100: -- Also disable Multiple Message Detection.
101: --
102: p_return_status := hr_multi_message.get_return_status_disable;
103: hr_utility.set_location(' Leaving:' || l_proc,20);
104: --
105: exception
106: when hr_multi_message.error_message_exist then
107: --
115: --
116: p_object_version_number := null;
117: p_return_status := null;
118: p_return_status := hr_multi_message.get_return_status_disable;
119: hr_utility.set_location(' Leaving:' || l_proc, 30);
120: when others then
121: --
122: -- When Multiple Message Detection is enabled catch
123: -- any Application specific or other unexpected
126: -- error.
127: --
128: rollback to create_template_details_swi;
129: if hr_multi_message.unexpected_error_add(l_proc) then
130: hr_utility.set_location(' Leaving:' || l_proc,40);
131: raise;
132: end if;
133: --
134: -- Reset IN OUT and set OUT parameters
135: --
136: p_object_version_number := null;
137: p_return_status := null;
138: p_return_status := hr_multi_message.get_return_status_disable;
139: hr_utility.set_location(' Leaving:' || l_proc,50);
140: end create_template_details;
141: -- ----------------------------------------------------------------------------
142: -- |------------------------< update_template_details >-----------------------|
143: -- ----------------------------------------------------------------------------
167: --
168: -- Other variables
169: l_proc varchar2(72) := g_package ||'update_template_details';
170: Begin
171: hr_utility.set_location(' Entering:' || l_proc,10);
172: --
173: -- Issue a savepoint
174: --
175: savepoint update_template_details_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: --
249: p_template_detail_id := l_template_detail_id;
250: p_object_version_number := l_object_version_number;
251: p_return_status := null;
252: p_return_status := hr_multi_message.get_return_status_disable;
253: hr_utility.set_location(' Leaving:' || l_proc, 30);
254: when others then
255: --
256: -- When Multiple Message Detection is enabled catch
257: -- any Application specific or other unexpected
260: -- error.
261: --
262: rollback to update_template_details_swi;
263: if hr_multi_message.unexpected_error_add(l_proc) then
264: hr_utility.set_location(' Leaving:' || l_proc,40);
265: raise;
266: end if;
267: --
268: -- Reset IN OUT and set OUT parameters
270: p_template_detail_id := l_template_detail_id;
271: p_object_version_number := l_object_version_number;
272: p_return_status := null;
273: p_return_status := hr_multi_message.get_return_status_disable;
274: hr_utility.set_location(' Leaving:' || l_proc,50);
275: end update_template_details;
276: -- ----------------------------------------------------------------------------
277: -- |------------------------< delete_template_details >-----------------------|
278: -- ----------------------------------------------------------------------------
292: --
293: -- Other variables
294: l_proc varchar2(72) := g_package ||'delete_template_details';
295: Begin
296: hr_utility.set_location(' Entering:' || l_proc,10);
297: --
298: -- Issue a savepoint
299: --
300: savepoint delete_template_details_swi;
336: -- messages of any type exist in the Multiple Message List.
337: -- Also disable Multiple Message Detection.
338: --
339: p_return_status := hr_multi_message.get_return_status_disable;
340: hr_utility.set_location(' Leaving:' || l_proc,20);
341: --
342: exception
343: when hr_multi_message.error_message_exist then
344: --
351: -- Reset IN OUT parameters and set OUT parameters
352: --
353: p_object_version_number := l_object_version_number;
354: p_return_status := hr_multi_message.get_return_status_disable;
355: hr_utility.set_location(' Leaving:' || l_proc, 30);
356: when others then
357: --
358: -- When Multiple Message Detection is enabled catch
359: -- any Application specific or other unexpected
362: -- error.
363: --
364: rollback to delete_template_details_swi;
365: if hr_multi_message.unexpected_error_add(l_proc) then
366: hr_utility.set_location(' Leaving:' || l_proc,40);
367: raise;
368: end if;
369: --
370: -- Reset IN OUT and set OUT parameters
370: -- Reset IN OUT and set OUT parameters
371: --
372: p_object_version_number := l_object_version_number;
373: p_return_status := hr_multi_message.get_return_status_disable;
374: hr_utility.set_location(' Leaving:' || l_proc,50);
375: end delete_template_details;
376: end psp_template_details_swi;