60: savepoint create_lpm_swi;
61: --
62: -- Initialise Multiple Message Detection
63: --
64: hr_multi_message.enable_message_list;
65: --
66: -- Remember IN OUT parameter IN values
67: --
68: --
139: -- Derive the API return status value based on whether
140: -- messages of any type exist in the Multiple Message List.
141: -- Also disable Multiple Message Detection.
142: --
143: p_return_status := hr_multi_message.get_return_status_disable;
144: hr_utility.set_location(' Leaving:' || l_proc,20);
145: --
146: exception
147: when hr_multi_message.error_message_exist then
143: p_return_status := hr_multi_message.get_return_status_disable;
144: hr_utility.set_location(' Leaving:' || l_proc,20);
145: --
146: exception
147: when hr_multi_message.error_message_exist then
148: --
149: -- Catch the Multiple Message List exception which
150: -- indicates API processing has been aborted because
151: -- at least one message exists in the list.
154: --
155: -- Reset IN OUT parameters and set OUT parameters
156: --
157: p_object_version_number := null;
158: p_return_status := hr_multi_message.get_return_status_disable;
159: hr_utility.set_location(' Leaving:' || l_proc, 30);
160: when others then
161: --
162: -- When Multiple Message Detection is enabled catch
165: -- Multiple Message List. Otherwise re-raise the
166: -- error.
167: --
168: rollback to create_lpm_swi;
169: if hr_multi_message.unexpected_error_add(l_proc) then
170: hr_utility.set_location(' Leaving:' || l_proc,40);
171: raise;
172: end if;
173: --
173: --
174: -- Reset IN OUT and set OUT parameters
175: --
176: p_object_version_number := null;
177: p_return_status := hr_multi_message.get_return_status_disable;
178: hr_utility.set_location(' Leaving:' || l_proc,50);
179: end create_learning_path_member;
180: -- ----------------------------------------------------------------------------
181: -- |----------------------< delete_learning_path_member >---------------------|
202: savepoint delete_lpm_swi;
203: --
204: -- Initialise Multiple Message Detection
205: --
206: hr_multi_message.enable_message_list;
207: --
208: -- Remember IN OUT parameter IN values
209: --
210: --
235: -- Derive the API return status value based on whether
236: -- messages of any type exist in the Multiple Message List.
237: -- Also disable Multiple Message Detection.
238: --
239: p_return_status := hr_multi_message.get_return_status_disable;
240: hr_utility.set_location(' Leaving:' || l_proc,20);
241: --
242: exception
243: when hr_multi_message.error_message_exist then
239: p_return_status := hr_multi_message.get_return_status_disable;
240: hr_utility.set_location(' Leaving:' || l_proc,20);
241: --
242: exception
243: when hr_multi_message.error_message_exist then
244: --
245: -- Catch the Multiple Message List exception which
246: -- indicates API processing has been aborted because
247: -- at least one message exists in the list.
249: rollback to delete_lpm_swi;
250: --
251: -- Reset IN OUT parameters and set OUT parameters
252: --
253: p_return_status := hr_multi_message.get_return_status_disable;
254: hr_utility.set_location(' Leaving:' || l_proc, 30);
255: when others then
256: --
257: -- When Multiple Message Detection is enabled catch
260: -- Multiple Message List. Otherwise re-raise the
261: -- error.
262: --
263: rollback to delete_lpm_swi;
264: if hr_multi_message.unexpected_error_add(l_proc) then
265: hr_utility.set_location(' Leaving:' || l_proc,40);
266: raise;
267: end if;
268: --
267: end if;
268: --
269: -- Reset IN OUT and set OUT parameters
270: --
271: p_return_status := hr_multi_message.get_return_status_disable;
272: hr_utility.set_location(' Leaving:' || l_proc,50);
273: end delete_learning_path_member;
274: -- ----------------------------------------------------------------------------
275: -- |----------------------< update_learning_path_member >---------------------|
324: savepoint update_lpm_swi;
325: --
326: -- Initialise Multiple Message Detection
327: --
328: hr_multi_message.enable_message_list;
329: --
330: -- Remember IN OUT parameter IN values
331: --
332: l_object_version_number := p_object_version_number;
385: -- Derive the API return status value based on whether
386: -- messages of any type exist in the Multiple Message List.
387: -- Also disable Multiple Message Detection.
388: --
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
389: p_return_status := hr_multi_message.get_return_status_disable;
390: hr_utility.set_location(' Leaving:' || l_proc,20);
391: --
392: exception
393: when hr_multi_message.error_message_exist then
394: --
395: -- Catch the Multiple Message List exception which
396: -- indicates API processing has been aborted because
397: -- at least one message exists in the list.
400: --
401: -- Reset IN OUT parameters and set OUT parameters
402: --
403: p_object_version_number := l_object_version_number;
404: p_return_status := hr_multi_message.get_return_status_disable;
405: hr_utility.set_location(' Leaving:' || l_proc, 30);
406: when others then
407: --
408: -- When Multiple Message Detection is enabled catch
411: -- Multiple Message List. Otherwise re-raise the
412: -- error.
413: --
414: rollback to update_lpm_swi;
415: if hr_multi_message.unexpected_error_add(l_proc) then
416: hr_utility.set_location(' Leaving:' || l_proc,40);
417: raise;
418: end if;
419: --
419: --
420: -- Reset IN OUT and set OUT parameters
421: --
422: p_object_version_number := l_object_version_number;
423: p_return_status := hr_multi_message.get_return_status_disable;
424: hr_utility.set_location(' Leaving:' || l_proc,50);
425: end update_learning_path_member;
426:
427:
511: EXCEPTION
512:
513: WHEN app_exception.application_exception THEN
514:
515: IF hr_multi_message.exception_add
516: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN
517:
518: hr_utility.set_location(' Leaving:'||l_proc, 42);
519: RAISE;