87: -- Other variables
88: l_plan_id number;
89: l_proc varchar2(72) := g_package ||'create_perf_mgmt_plan';
90: Begin
91: hr_utility.set_location(' Entering:' || l_proc,10);
92: --
93: -- Issue a savepoint
94: --
95: savepoint create_perf_mgmt_plan_swi;
207: -- messages of any type exist in the Multiple Message List.
208: -- Also disable Multiple Message Detection.
209: --
210: p_return_status := hr_multi_message.get_return_status_disable;
211: hr_utility.set_location(' Leaving:' || l_proc,20);
212: --
213: exception
214: when hr_multi_message.error_message_exist then
215: --
223: --
224: p_object_version_number := null;
225: p_status_code := null;
226: p_return_status := hr_multi_message.get_return_status_disable;
227: hr_utility.set_location(' Leaving:' || l_proc, 30);
228: when others then
229: --
230: -- When Multiple Message Detection is enabled catch
231: -- any Application specific or other unexpected
234: -- error.
235: --
236: rollback to create_perf_mgmt_plan_swi;
237: if hr_multi_message.unexpected_error_add(l_proc) then
238: hr_utility.set_location(' Leaving:' || l_proc,40);
239: raise;
240: end if;
241: --
242: -- Reset IN OUT and set OUT parameters
243: --
244: p_object_version_number := null;
245: p_status_code := null;
246: p_return_status := hr_multi_message.get_return_status_disable;
247: hr_utility.set_location(' Leaving:' || l_proc,50);
248: end create_perf_mgmt_plan;
249: -- ----------------------------------------------------------------------------
250: -- |-------------------------< delete_perf_mgmt_plan >------------------------|
251: -- ----------------------------------------------------------------------------
263: --
264: -- Other variables
265: l_proc varchar2(72) := g_package ||'delete_perf_mgmt_plan';
266: Begin
267: hr_utility.set_location(' Entering:' || l_proc,10);
268: --
269: -- Issue a savepoint
270: --
271: savepoint delete_perf_mgmt_plan_swi;
305: -- messages of any type exist in the Multiple Message List.
306: -- Also disable Multiple Message Detection.
307: --
308: p_return_status := hr_multi_message.get_return_status_disable;
309: hr_utility.set_location(' Leaving:' || l_proc,20);
310: --
311: exception
312: when hr_multi_message.error_message_exist then
313: --
319: --
320: -- Reset IN OUT parameters and set OUT parameters
321: --
322: p_return_status := hr_multi_message.get_return_status_disable;
323: hr_utility.set_location(' Leaving:' || l_proc, 30);
324: when others then
325: --
326: -- When Multiple Message Detection is enabled catch
327: -- any Application specific or other unexpected
330: -- error.
331: --
332: rollback to delete_perf_mgmt_plan_swi;
333: if hr_multi_message.unexpected_error_add(l_proc) then
334: hr_utility.set_location(' Leaving:' || l_proc,40);
335: raise;
336: end if;
337: --
338: -- Reset IN OUT and set OUT parameters
337: --
338: -- Reset IN OUT and set OUT parameters
339: --
340: p_return_status := hr_multi_message.get_return_status_disable;
341: hr_utility.set_location(' Leaving:' || l_proc,50);
342: end delete_perf_mgmt_plan;
343: -- ----------------------------------------------------------------------------
344: -- |-------------------------< update_perf_mgmt_plan >------------------------|
345: -- ----------------------------------------------------------------------------
422: --
423: -- Other variables
424: l_proc varchar2(72) := g_package ||'update_perf_mgmt_plan';
425: Begin
426: hr_utility.set_location(' Entering:' || l_proc,10);
427: --
428: -- Issue a savepoint
429: --
430: savepoint update_perf_mgmt_plan_swi;
540: -- messages of any type exist in the Multiple Message List.
541: -- Also disable Multiple Message Detection.
542: --
543: p_return_status := hr_multi_message.get_return_status_disable;
544: hr_utility.set_location(' Leaving:' || l_proc,20);
545: --
546: exception
547: when hr_multi_message.error_message_exist then
548: --
556: --
557: p_object_version_number := l_object_version_number;
558: p_status_code := null;
559: p_return_status := hr_multi_message.get_return_status_disable;
560: hr_utility.set_location(' Leaving:' || l_proc, 30);
561: when others then
562: --
563: -- When Multiple Message Detection is enabled catch
564: -- any Application specific or other unexpected
567: -- error.
568: --
569: rollback to update_perf_mgmt_plan_swi;
570: if hr_multi_message.unexpected_error_add(l_proc) then
571: hr_utility.set_location(' Leaving:' || l_proc,40);
572: raise;
573: end if;
574: --
575: -- Reset IN OUT and set OUT parameters
576: --
577: p_object_version_number := l_object_version_number;
578: p_status_code := null;
579: p_return_status := hr_multi_message.get_return_status_disable;
580: hr_utility.set_location(' Leaving:' || l_proc,50);
581: end update_perf_mgmt_plan;
582: end hr_perf_mgmt_plan_swi;