39: savepoint create_template_assoc_swi;
40: --
41: -- Initialise Multiple Message Detection
42: --
43: hr_multi_message.enable_message_list;
44: --
45: -- Remember IN OUT parameter IN values
46: --
47: --
84: -- Derive the API return status value based on whether
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
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: --
94: -- Catch the Multiple Message List exception which
95: -- indicates API processing has been aborted because
96: -- at least one message exists in the list.
99: --
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
110: -- Multiple Message List. Otherwise re-raise the
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: --
118: --
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 >---------------------|
156: savepoint update_template_assoc_swi;
157: --
158: -- Initialise Multiple Message Detection
159: --
160: hr_multi_message.enable_message_list;
161: --
162: -- Remember IN OUT parameter IN values
163: --
164: l_object_version_number := p_object_version_number;
198: -- Derive the API return status value based on whether
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
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: --
208: -- Catch the Multiple Message List exception which
209: -- indicates API processing has been aborted because
210: -- at least one message exists in the list.
213: --
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
224: -- Multiple Message List. Otherwise re-raise the
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: --
232: --
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 >---------------------|
261: savepoint delete_template_assoc_swi;
262: --
263: -- Initialise Multiple Message Detection
264: --
265: hr_multi_message.enable_message_list;
266: --
267: -- Remember IN OUT parameter IN values
268: --
269: --
294: -- Derive the API return status value based on whether
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
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: --
304: -- Catch the Multiple Message List exception which
305: -- indicates API processing has been aborted because
306: -- at least one message exists in the list.
308: rollback to delete_template_assoc_swi;
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
319: -- Multiple Message List. Otherwise re-raise the
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: --
326: end if;
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;