DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_NUMBERS_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_level_numbers';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_level_numbers_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_level_numbers_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_level_numbers;
102: -- ----------------------------------------------------------------------------
103: -- |-------------------------< insert_level_numbers >-------------------------|
104: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

203: --
204: p_level_number_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,50);
208: end insert_level_numbers;
209: -- ----------------------------------------------------------------------------
210: -- |-------------------------< update_level_numbers >-------------------------|
211: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

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