31: -- Other variables
32: l_template_association_id number;
33: l_proc varchar2(72) := g_package ||'create_template_association';
34: Begin
35: hr_utility.set_location(' Entering:' || l_proc,10);
36: --
37: -- Issue a savepoint
38: --
39: savepoint create_template_assoc_swi;
85: -- messages of any type exist in the Multiple Message List.
86: -- Also disable Multiple Message Detection.
87: --
88: p_return_status := hr_multi_message.get_return_status_disable;
89: hr_utility.set_location(' Leaving:' || l_proc,20);
90: --
91: exception
92: when hr_multi_message.error_message_exist then
93: --
100: -- Reset IN OUT parameters and set OUT parameters
101: --
102: p_object_version_number := null;
103: p_return_status := hr_multi_message.get_return_status_disable;
104: hr_utility.set_location(' Leaving:' || l_proc, 30);
105: when others then
106: --
107: -- When Multiple Message Detection is enabled catch
108: -- any Application specific or other unexpected
111: -- error.
112: --
113: rollback to create_template_assoc_swi;
114: if hr_multi_message.unexpected_error_add(l_proc) then
115: hr_utility.set_location(' Leaving:' || l_proc,40);
116: raise;
117: end if;
118: --
119: -- Reset IN OUT and set OUT parameters
119: -- Reset IN OUT and set OUT parameters
120: --
121: p_object_version_number := null;
122: p_return_status := hr_multi_message.get_return_status_disable;
123: hr_utility.set_location(' Leaving:' || l_proc,50);
124: end create_template_association;
125: -- ----------------------------------------------------------------------------
126: -- |----------------------< update_template_association >---------------------|
127: -- ----------------------------------------------------------------------------
148: --
149: -- Other variables
150: l_proc varchar2(72) := g_package ||'update_template_association';
151: Begin
152: hr_utility.set_location(' Entering:' || l_proc,10);
153: --
154: -- Issue a savepoint
155: --
156: savepoint update_template_assoc_swi;
199: -- messages of any type exist in the Multiple Message List.
200: -- Also disable Multiple Message Detection.
201: --
202: p_return_status := hr_multi_message.get_return_status_disable;
203: hr_utility.set_location(' Leaving:' || l_proc,20);
204: --
205: exception
206: when hr_multi_message.error_message_exist then
207: --
214: -- Reset IN OUT parameters and set OUT parameters
215: --
216: p_object_version_number := l_object_version_number;
217: p_return_status := hr_multi_message.get_return_status_disable;
218: hr_utility.set_location(' Leaving:' || l_proc, 30);
219: when others then
220: --
221: -- When Multiple Message Detection is enabled catch
222: -- any Application specific or other unexpected
225: -- error.
226: --
227: rollback to update_template_assoc_swi;
228: if hr_multi_message.unexpected_error_add(l_proc) then
229: hr_utility.set_location(' Leaving:' || l_proc,40);
230: raise;
231: end if;
232: --
233: -- Reset IN OUT and set OUT parameters
233: -- Reset IN OUT and set OUT parameters
234: --
235: p_object_version_number := l_object_version_number;
236: p_return_status := hr_multi_message.get_return_status_disable;
237: hr_utility.set_location(' Leaving:' || l_proc,50);
238: end update_template_association;
239: -- ----------------------------------------------------------------------------
240: -- |----------------------< delete_template_association >---------------------|
241: -- ----------------------------------------------------------------------------
253: --
254: -- Other variables
255: l_proc varchar2(72) := g_package ||'delete_template_association';
256: Begin
257: hr_utility.set_location(' Entering:' || l_proc,10);
258: --
259: -- Issue a savepoint
260: --
261: savepoint delete_template_assoc_swi;
295: -- messages of any type exist in the Multiple Message List.
296: -- Also disable Multiple Message Detection.
297: --
298: p_return_status := hr_multi_message.get_return_status_disable;
299: hr_utility.set_location(' Leaving:' || l_proc,20);
300: --
301: exception
302: when hr_multi_message.error_message_exist then
303: --
309: --
310: -- Reset IN OUT parameters and set OUT parameters
311: --
312: p_return_status := hr_multi_message.get_return_status_disable;
313: hr_utility.set_location(' Leaving:' || l_proc, 30);
314: when others then
315: --
316: -- When Multiple Message Detection is enabled catch
317: -- any Application specific or other unexpected
320: -- error.
321: --
322: rollback to delete_template_assoc_swi;
323: if hr_multi_message.unexpected_error_add(l_proc) then
324: hr_utility.set_location(' Leaving:' || l_proc,40);
325: raise;
326: end if;
327: --
328: -- Reset IN OUT and set OUT parameters
327: --
328: -- Reset IN OUT and set OUT parameters
329: --
330: p_return_status := hr_multi_message.get_return_status_disable;
331: hr_utility.set_location(' Leaving:' || l_proc,50);
332: end delete_template_association;
333: end irc_template_association_swi;