[Home] [Help]
101: --
102: -- Other variables
103: l_proc varchar2(72) := g_package ||'create_assign_accommodation';
104: Begin
105: hr_utility.set_location(' Entering:' || l_proc,10);
106: --
107: -- Issue a savepoint
108: --
109: savepoint create_assign_accommodation;
222: -- messages of any type exist in the Multiple Message List.
223: -- Also disable Multiple Message Detection.
224: --
225: p_return_status := hr_multi_message.get_return_status_disable;
226: hr_utility.set_location(' Leaving:' || l_proc,20);
227: --
228: exception
229: when hr_multi_message.error_message_exist then
230: --
240: p_object_version_number := null;
241: p_effective_start_date := null;
242: p_effective_end_date := null;
243: p_return_status := hr_multi_message.get_return_status_disable;
244: hr_utility.set_location(' Leaving:' || l_proc, 30);
245: when others then
246: --
247: -- When Multiple Message Detection is enabled catch
248: -- any Application specific or other unexpected
251: -- error.
252: --
253: rollback to create_assign_accommodation;
254: if hr_multi_message.unexpected_error_add(l_proc) then
255: hr_utility.set_location(' Leaving:' || l_proc,40);
256: raise;
257: end if;
258: --
259: -- Reset IN OUT and set OUT parameters
262: p_object_version_number := null;
263: p_effective_start_date := null;
264: p_effective_end_date := null;
265: p_return_status := hr_multi_message.get_return_status_disable;
266: hr_utility.set_location(' Leaving:' || l_proc,50);
267: end create_assign_accommodation;
268: -- ----------------------------------------------------------------------------
269: -- |----------------------< delete_assign_accommodation >---------------------|
270: -- ----------------------------------------------------------------------------
287: --
288: -- Other variables
289: l_proc varchar2(72) := g_package ||'delete_assign_accommodation';
290: Begin
291: hr_utility.set_location(' Entering:' || l_proc,10);
292: --
293: -- Issue a savepoint
294: --
295: savepoint delete_assign_accommodation;
334: -- messages of any type exist in the Multiple Message List.
335: -- Also disable Multiple Message Detection.
336: --
337: p_return_status := hr_multi_message.get_return_status_disable;
338: hr_utility.set_location(' Leaving:' || l_proc,20);
339: --
340: exception
341: when hr_multi_message.error_message_exist then
342: --
351: p_object_version_number := l_object_version_number;
352: p_effective_start_date := null;
353: p_effective_end_date := null;
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_assign_accommodation;
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
372: p_object_version_number := l_object_version_number;
373: p_effective_start_date := null;
374: p_effective_end_date := null;
375: p_return_status := hr_multi_message.get_return_status_disable;
376: hr_utility.set_location(' Leaving:' || l_proc,50);
377: end delete_assign_accommodation;
378: -- ----------------------------------------------------------------------------
379: -- |----------------------< update_assign_accommodation >---------------------|
380: -- ----------------------------------------------------------------------------
473: --
474: -- Other variables
475: l_proc varchar2(72) := g_package ||'update_assign_accommodation';
476: Begin
477: hr_utility.set_location(' Entering:' || l_proc,10);
478: --
479: -- Issue a savepoint
480: --
481: savepoint update_assign_accommodation;
596: -- messages of any type exist in the Multiple Message List.
597: -- Also disable Multiple Message Detection.
598: --
599: p_return_status := hr_multi_message.get_return_status_disable;
600: hr_utility.set_location(' Leaving:' || l_proc,20);
601: --
602: exception
603: when hr_multi_message.error_message_exist then
604: --
613: p_object_version_number := l_object_version_number;
614: p_effective_start_date := null;
615: p_effective_end_date := null;
616: p_return_status := hr_multi_message.get_return_status_disable;
617: hr_utility.set_location(' Leaving:' || l_proc, 30);
618: when others then
619: --
620: -- When Multiple Message Detection is enabled catch
621: -- any Application specific or other unexpected
624: -- error.
625: --
626: rollback to update_assign_accommodation;
627: if hr_multi_message.unexpected_error_add(l_proc) then
628: hr_utility.set_location(' Leaving:' || l_proc,40);
629: raise;
630: end if;
631: --
632: -- Reset IN OUT and set OUT parameters
634: p_object_version_number := l_object_version_number;
635: p_effective_start_date := null;
636: p_effective_end_date := null;
637: p_return_status := hr_multi_message.get_return_status_disable;
638: hr_utility.set_location(' Leaving:' || l_proc,50);
639: end update_assign_accommodation;
640: end pqh_assign_accommodations_swi;