22: --
23: -- Other variables
24: l_proc varchar2(72) := g_package ||'delete_case_groups';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_case_groups_swi;
64: -- messages of any type exist in the Multiple Message List.
65: -- Also disable Multiple Message Detection.
66: --
67: p_return_status := hr_multi_message.get_return_status_disable;
68: hr_utility.set_location(' Leaving:' || l_proc,20);
69: --
70: exception
71: when hr_multi_message.error_message_exist then
72: --
78: --
79: -- Reset IN OUT parameters and set OUT parameters
80: --
81: p_return_status := hr_multi_message.get_return_status_disable;
82: hr_utility.set_location(' Leaving:' || l_proc, 30);
83: when others then
84: --
85: -- When Multiple Message Detection is enabled catch
86: -- any Application specific or other unexpected
89: -- error.
90: --
91: rollback to delete_case_groups_swi;
92: if hr_multi_message.unexpected_error_add(l_proc) then
93: hr_utility.set_location(' Leaving:' || l_proc,40);
94: raise;
95: end if;
96: --
97: -- Reset IN OUT and set OUT parameters
96: --
97: -- Reset IN OUT and set OUT parameters
98: --
99: p_return_status := hr_multi_message.get_return_status_disable;
100: hr_utility.set_location(' Leaving:' || l_proc,50);
101: end delete_case_groups;
102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_case_groups >--------------------------|
104: -- ----------------------------------------------------------------------------
131: --
132: -- Other variables
133: l_proc varchar2(72) := g_package ||'insert_case_groups';
134: Begin
135: hr_utility.set_location(' Entering:' || l_proc,10);
136: --
137: -- Issue a savepoint
138: --
139: savepoint insert_case_groups_swi;
187: -- messages of any type exist in the Multiple Message List.
188: -- Also disable Multiple Message Detection.
189: --
190: p_return_status := hr_multi_message.get_return_status_disable;
191: hr_utility.set_location(' Leaving:' || l_proc,20);
192: --
193: exception
194: when hr_multi_message.error_message_exist then
195: --
203: --
204: p_case_group_id := null;
205: p_object_version_number := null;
206: p_return_status := hr_multi_message.get_return_status_disable;
207: hr_utility.set_location(' Leaving:' || l_proc, 30);
208: when others then
209: --
210: -- When Multiple Message Detection is enabled catch
211: -- any Application specific or other unexpected
214: -- error.
215: --
216: rollback to insert_case_groups_swi;
217: if hr_multi_message.unexpected_error_add(l_proc) then
218: hr_utility.set_location(' Leaving:' || l_proc,40);
219: raise;
220: end if;
221: --
222: -- Reset IN OUT and set OUT parameters
223: --
224: p_case_group_id := null;
225: p_object_version_number := null;
226: p_return_status := hr_multi_message.get_return_status_disable;
227: hr_utility.set_location(' Leaving:' || l_proc,50);
228: end insert_case_groups;
229: -- ----------------------------------------------------------------------------
230: -- |--------------------------< update_case_groups >--------------------------|
231: -- ----------------------------------------------------------------------------
260: -- Other variables
261: l_proc varchar2(72) := g_package ||'update_case_groups';
262: Begin
263:
264: hr_utility.set_location(' Entering:' || l_proc,10);
265: --
266: -- Issue a savepoint
267: --
268: savepoint update_case_groups_swi;
318: -- messages of any type exist in the Multiple Message List.
319: -- Also disable Multiple Message Detection.
320: --
321: p_return_status := hr_multi_message.get_return_status_disable;
322: hr_utility.set_location(' Leaving:' || l_proc,20);
323: --
324: exception
325: when hr_multi_message.error_message_exist then
326: --
333: -- Reset IN OUT parameters and set OUT parameters
334: --
335: p_object_version_number := l_object_version_number;
336: p_return_status := hr_multi_message.get_return_status_disable;
337: hr_utility.set_location(' Leaving:' || l_proc, 30);
338: when others then
339: --
340: -- When Multiple Message Detection is enabled catch
341: -- any Application specific or other unexpected
344: -- error.
345: --
346: rollback to update_case_groups_swi;
347: if hr_multi_message.unexpected_error_add(l_proc) then
348: hr_utility.set_location(' Leaving:' || l_proc,40);
349: raise;
350: end if;
351: --
352: -- Reset IN OUT and set OUT parameters
352: -- Reset IN OUT and set OUT parameters
353: --
354: p_object_version_number := l_object_version_number;
355: p_return_status := hr_multi_message.get_return_status_disable;
356: hr_utility.set_location(' Leaving:' || l_proc,50);
357: end update_case_groups;
358: end pqh_de_case_groups_swi;