DBA Data[Home] [Help]

APPS.OTA_CATEGORY_USAGE_SWI dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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