DBA Data[Home] [Help]

APPS.PQH_DE_CASE_GROUPS_SWI dependencies on HR_UTILITY

Line 26: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 68: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 82: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 93: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 100: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 135: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 191: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 207: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 218: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 227: hr_utility.set_location(' Leaving:' || l_proc,50);

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: -- ----------------------------------------------------------------------------

Line 264: hr_utility.set_location(' Entering:' || l_proc,10);

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;

Line 322: hr_utility.set_location(' Leaving:' || l_proc,20);

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: --

Line 337: hr_utility.set_location(' Leaving:' || l_proc, 30);

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

Line 348: hr_utility.set_location(' Leaving:' || l_proc,40);

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

Line 356: hr_utility.set_location(' Leaving:' || l_proc,50);

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;