DBA Data[Home] [Help]

APPS.PQH_DE_LEVEL_CODES_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_codes';
25: Begin
26: hr_utility.set_location(' Entering:' || l_proc,10);
27: --
28: -- Issue a savepoint
29: --
30: savepoint delete_level_codes_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_codes_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_codes;
102: -- ----------------------------------------------------------------------------
103: -- |--------------------------< insert_level_codes >--------------------------|
104: -- ----------------------------------------------------------------------------

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

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

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

172: -- messages of any type exist in the Multiple Message List.
173: -- Also disable Multiple Message Detection.
174: --
175: p_return_status := hr_multi_message.get_return_status_disable;
176: hr_utility.set_location(' Leaving:' || l_proc,20);
177: --
178: exception
179: when hr_multi_message.error_message_exist then
180: --

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

188: --
189: p_level_code_id := null;
190: p_object_version_number := null;
191: p_return_status := hr_multi_message.get_return_status_disable;
192: hr_utility.set_location(' Leaving:' || l_proc, 30);
193: when others then
194: --
195: -- When Multiple Message Detection is enabled catch
196: -- any Application specific or other unexpected

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

199: -- error.
200: --
201: rollback to insert_level_codes_swi;
202: if hr_multi_message.unexpected_error_add(l_proc) then
203: hr_utility.set_location(' Leaving:' || l_proc,40);
204: raise;
205: end if;
206: --
207: -- Reset IN OUT and set OUT parameters

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

208: --
209: p_level_code_id := null;
210: p_object_version_number := null;
211: p_return_status := hr_multi_message.get_return_status_disable;
212: hr_utility.set_location(' Leaving:' || l_proc,50);
213: end insert_level_codes;
214: -- ----------------------------------------------------------------------------
215: -- |--------------------------< update_level_codes >--------------------------|
216: -- ----------------------------------------------------------------------------

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

234: --
235: -- Other variables
236: l_proc varchar2(72) := g_package ||'update_level_codes';
237: Begin
238: hr_utility.set_location(' Entering:' || l_proc,10);
239: --
240: -- Issue a savepoint
241: --
242: savepoint update_level_codes_swi;

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

282: -- messages of any type exist in the Multiple Message List.
283: -- Also disable Multiple Message Detection.
284: --
285: p_return_status := hr_multi_message.get_return_status_disable;
286: hr_utility.set_location(' Leaving:' || l_proc,20);
287: --
288: exception
289: when hr_multi_message.error_message_exist then
290: --

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

297: -- Reset IN OUT parameters and set OUT parameters
298: --
299: p_object_version_number := l_object_version_number;
300: p_return_status := hr_multi_message.get_return_status_disable;
301: hr_utility.set_location(' Leaving:' || l_proc, 30);
302: when others then
303: --
304: -- When Multiple Message Detection is enabled catch
305: -- any Application specific or other unexpected

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

308: -- error.
309: --
310: rollback to update_level_codes_swi;
311: if hr_multi_message.unexpected_error_add(l_proc) then
312: hr_utility.set_location(' Leaving:' || l_proc,40);
313: raise;
314: end if;
315: --
316: -- Reset IN OUT and set OUT parameters

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

316: -- Reset IN OUT and set OUT parameters
317: --
318: p_object_version_number := l_object_version_number;
319: p_return_status := hr_multi_message.get_return_status_disable;
320: hr_utility.set_location(' Leaving:' || l_proc,50);
321: end update_level_codes;
322: end pqh_de_level_codes_swi;