DBA Data[Home] [Help]

APPS.OTA_CATEGORY_USAGE_SWI dependencies on HR_UTILITY

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

56: -- Other variables
57: l_category_usage_id number;
58: l_proc varchar2(72) := g_package ||'create_category';
59: Begin
60: hr_utility.set_location(' Entering:' || l_proc,10);
61: --
62: -- Issue a savepoint
63: --
64: savepoint create_category_swi;

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

134: -- messages of any type exist in the Multiple Message List.
135: -- Also disable Multiple Message Detection.
136: --
137: p_return_status := hr_multi_message.get_return_status_disable;
138: hr_utility.set_location(' Leaving:' || l_proc,20);
139: --
140: exception
141: when hr_multi_message.error_message_exist then
142: --

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

149: -- Reset IN OUT parameters and set OUT parameters
150: --
151: p_object_version_number := null;
152: p_return_status := hr_multi_message.get_return_status_disable;
153: hr_utility.set_location(' Leaving:' || l_proc, 30);
154: when others then
155: --
156: -- When Multiple Message Detection is enabled catch
157: -- any Application specific or other unexpected

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

160: -- error.
161: --
162: rollback to create_category_swi;
163: if hr_multi_message.unexpected_error_add(l_proc) then
164: hr_utility.set_location(' Leaving:' || l_proc,40);
165: raise;
166: end if;
167: --
168: -- Reset IN OUT and set OUT parameters

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

168: -- Reset IN OUT and set OUT parameters
169: --
170: p_object_version_number := null;
171: p_return_status := hr_multi_message.get_return_status_disable;
172: hr_utility.set_location(' Leaving:' || l_proc,50);
173: end create_category;
174: -- ----------------------------------------------------------------------------
175: -- |----------------------------< delete_category >---------------------------|
176: -- ----------------------------------------------------------------------------

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

188: --
189: -- Other variables
190: l_proc varchar2(72) := g_package ||'delete_category';
191: Begin
192: hr_utility.set_location(' Entering:' || l_proc,10);
193: --
194: -- Issue a savepoint
195: --
196: savepoint delete_category_swi;

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

230: -- messages of any type exist in the Multiple Message List.
231: -- Also disable Multiple Message Detection.
232: --
233: p_return_status := hr_multi_message.get_return_status_disable;
234: hr_utility.set_location(' Leaving:' || l_proc,20);
235: --
236: exception
237: when hr_multi_message.error_message_exist then
238: --

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

244: --
245: -- Reset IN OUT parameters and set OUT parameters
246: --
247: p_return_status := hr_multi_message.get_return_status_disable;
248: hr_utility.set_location(' Leaving:' || l_proc, 30);
249: when others then
250: --
251: -- When Multiple Message Detection is enabled catch
252: -- any Application specific or other unexpected

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

255: -- error.
256: --
257: rollback to delete_category_swi;
258: if hr_multi_message.unexpected_error_add(l_proc) then
259: hr_utility.set_location(' Leaving:' || l_proc,40);
260: raise;
261: end if;
262: --
263: -- Reset IN OUT and set OUT parameters

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

262: --
263: -- Reset IN OUT and set OUT parameters
264: --
265: p_return_status := hr_multi_message.get_return_status_disable;
266: hr_utility.set_location(' Leaving:' || l_proc,50);
267: end delete_category;
268: -- ----------------------------------------------------------------------------
269: -- |----------------------------< update_category >---------------------------|
270: -- ----------------------------------------------------------------------------

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

315: --
316: -- Other variables
317: l_proc varchar2(72) := g_package ||'update_category';
318: Begin
319: hr_utility.set_location(' Entering:' || l_proc,10);
320: --
321: -- Issue a savepoint
322: --
323: savepoint update_category_swi;

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

390: -- messages of any type exist in the Multiple Message List.
391: -- Also disable Multiple Message Detection.
392: --
393: p_return_status := hr_multi_message.get_return_status_disable;
394: hr_utility.set_location(' Leaving:' || l_proc,20);
395: --
396: exception
397: when hr_multi_message.error_message_exist then
398: --

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

405: -- Reset IN OUT parameters and set OUT parameters
406: --
407: p_object_version_number := l_object_version_number;
408: p_return_status := hr_multi_message.get_return_status_disable;
409: hr_utility.set_location(' Leaving:' || l_proc, 30);
410: when others then
411: --
412: -- When Multiple Message Detection is enabled catch
413: -- any Application specific or other unexpected

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

416: -- error.
417: --
418: rollback to update_category_swi;
419: if hr_multi_message.unexpected_error_add(l_proc) then
420: hr_utility.set_location(' Leaving:' || l_proc,40);
421: raise;
422: end if;
423: --
424: -- Reset IN OUT and set OUT parameters

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

424: -- Reset IN OUT and set OUT parameters
425: --
426: p_object_version_number := l_object_version_number;
427: p_return_status := hr_multi_message.get_return_status_disable;
428: hr_utility.set_location(' Leaving:' || l_proc,50);
429: end update_category;
430: --
431: end ota_category_usage_swi;