DBA Data[Home] [Help]

APPS.PQH_DE_RESULT_SETS_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_result_sets';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_result_sets_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_result_sets_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_result_sets;
102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_result_sets >--------------------------|
104: -- ----------------------------------------------------------------------------

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

120: --
121: -- Other variables
122: l_proc varchar2(72) := g_package ||'insert_result_sets';
123: Begin
124: hr_utility.set_location(' Entering:' || l_proc,10);
125: --
126: -- Issue a savepoint
127: --
128: savepoint insert_result_sets_swi;

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

166: -- messages of any type exist in the Multiple Message List.
167: -- Also disable Multiple Message Detection.
168: --
169: p_return_status := hr_multi_message.get_return_status_disable;
170: hr_utility.set_location(' Leaving:' || l_proc,20);
171: --
172: exception
173: when hr_multi_message.error_message_exist then
174: --

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

182: --
183: p_result_set_id := null;
184: p_object_version_number := null;
185: p_return_status := hr_multi_message.get_return_status_disable;
186: hr_utility.set_location(' Leaving:' || l_proc, 30);
187: when others then
188: --
189: -- When Multiple Message Detection is enabled catch
190: -- any Application specific or other unexpected

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

193: -- error.
194: --
195: rollback to insert_result_sets_swi;
196: if hr_multi_message.unexpected_error_add(l_proc) then
197: hr_utility.set_location(' Leaving:' || l_proc,40);
198: raise;
199: end if;
200: --
201: -- Reset IN OUT and set OUT parameters

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

202: --
203: p_result_set_id := null;
204: p_object_version_number := null;
205: p_return_status := hr_multi_message.get_return_status_disable;
206: hr_utility.set_location(' Leaving:' || l_proc,50);
207: end insert_result_sets;
208: -- ----------------------------------------------------------------------------
209: -- |--------------------------< update_result_sets >--------------------------|
210: -- ----------------------------------------------------------------------------

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

227: --
228: -- Other variables
229: l_proc varchar2(72) := g_package ||'update_result_sets';
230: Begin
231: hr_utility.set_location(' Entering:' || l_proc,10);
232: --
233: -- Issue a savepoint
234: --
235: savepoint update_result_sets_swi;

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

274: -- messages of any type exist in the Multiple Message List.
275: -- Also disable Multiple Message Detection.
276: --
277: p_return_status := hr_multi_message.get_return_status_disable;
278: hr_utility.set_location(' Leaving:' || l_proc,20);
279: --
280: exception
281: when hr_multi_message.error_message_exist then
282: --

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

289: -- Reset IN OUT parameters and set OUT parameters
290: --
291: p_object_version_number := l_object_version_number;
292: p_return_status := hr_multi_message.get_return_status_disable;
293: hr_utility.set_location(' Leaving:' || l_proc, 30);
294: when others then
295: --
296: -- When Multiple Message Detection is enabled catch
297: -- any Application specific or other unexpected

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

300: -- error.
301: --
302: rollback to update_result_sets_swi;
303: if hr_multi_message.unexpected_error_add(l_proc) then
304: hr_utility.set_location(' Leaving:' || l_proc,40);
305: raise;
306: end if;
307: --
308: -- Reset IN OUT and set OUT parameters

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

308: -- Reset IN OUT and set OUT parameters
309: --
310: p_object_version_number := l_object_version_number;
311: p_return_status := hr_multi_message.get_return_status_disable;
312: hr_utility.set_location(' Leaving:' || l_proc,50);
313: end update_result_sets;
314: end pqh_de_result_sets_swi;