DBA Data[Home] [Help]

APPS.OTA_LP_CATEGORY_SWI dependencies on HR_UTILITY

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

50: l_learning_path_id number;
51: l_category_usage_id number;
52: l_proc varchar2(72) := g_package ||'create_lp_cat_inclusion';
53: Begin
54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_lp_cat_inclusion_swi;

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

122: -- messages of any type exist in the Multiple Message List.
123: -- Also disable Multiple Message Detection.
124: --
125: p_return_status := hr_multi_message.get_return_status_disable;
126: hr_utility.set_location(' Leaving:' || l_proc,20);
127: --
128: exception
129: when hr_multi_message.error_message_exist then
130: --

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

137: -- Reset IN OUT parameters and set OUT parameters
138: --
139: p_object_version_number := null;
140: p_return_status := hr_multi_message.get_return_status_disable;
141: hr_utility.set_location(' Leaving:' || l_proc, 30);
142: when others then
143: --
144: -- When Multiple Message Detection is enabled catch
145: -- any Application specific or other unexpected

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

148: -- error.
149: --
150: rollback to create_lp_cat_inclusion_swi;
151: if hr_multi_message.unexpected_error_add(l_proc) then
152: hr_utility.set_location(' Leaving:' || l_proc,40);
153: raise;
154: end if;
155: --
156: -- Reset IN OUT and set OUT parameters

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

156: -- Reset IN OUT and set OUT parameters
157: --
158: p_object_version_number := null;
159: p_return_status := hr_multi_message.get_return_status_disable;
160: hr_utility.set_location(' Leaving:' || l_proc,50);
161: end create_lp_cat_inclusion;
162: -- ----------------------------------------------------------------------------
163: -- |------------------------< delete_lp_cat_inclusion >-----------------------|
164: -- ----------------------------------------------------------------------------

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

177: --
178: -- Other variables
179: l_proc varchar2(72) := g_package ||'delete_lp_cat_inclusion';
180: Begin
181: hr_utility.set_location(' Entering:' || l_proc,10);
182: --
183: -- Issue a savepoint
184: --
185: savepoint delete_lp_cat_inclusion_swi;

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

220: -- messages of any type exist in the Multiple Message List.
221: -- Also disable Multiple Message Detection.
222: --
223: p_return_status := hr_multi_message.get_return_status_disable;
224: hr_utility.set_location(' Leaving:' || l_proc,20);
225: --
226: exception
227: when hr_multi_message.error_message_exist then
228: --

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

234: --
235: -- Reset IN OUT parameters and set OUT parameters
236: --
237: p_return_status := hr_multi_message.get_return_status_disable;
238: hr_utility.set_location(' Leaving:' || l_proc, 30);
239: when others then
240: --
241: -- When Multiple Message Detection is enabled catch
242: -- any Application specific or other unexpected

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

245: -- error.
246: --
247: rollback to delete_lp_cat_inclusion_swi;
248: if hr_multi_message.unexpected_error_add(l_proc) then
249: hr_utility.set_location(' Leaving:' || l_proc,40);
250: raise;
251: end if;
252: --
253: -- Reset IN OUT and set OUT parameters

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

252: --
253: -- Reset IN OUT and set OUT parameters
254: --
255: p_return_status := hr_multi_message.get_return_status_disable;
256: hr_utility.set_location(' Leaving:' || l_proc,50);
257: end delete_lp_cat_inclusion;
258: -- ----------------------------------------------------------------------------
259: -- |------------------------< update_lp_cat_inclusion >-----------------------|
260: -- ----------------------------------------------------------------------------

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

299: --
300: -- Other variables
301: l_proc varchar2(72) := g_package ||'update_lp_cat_inclusion';
302: Begin
303: hr_utility.set_location(' Entering:' || l_proc,10);
304: --
305: -- Issue a savepoint
306: --
307: savepoint update_lp_cat_inclusion_swi;

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

368: -- messages of any type exist in the Multiple Message List.
369: -- Also disable Multiple Message Detection.
370: --
371: p_return_status := hr_multi_message.get_return_status_disable;
372: hr_utility.set_location(' Leaving:' || l_proc,20);
373: --
374: exception
375: when hr_multi_message.error_message_exist then
376: --

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

383: -- Reset IN OUT parameters and set OUT parameters
384: --
385: p_object_version_number := l_object_version_number;
386: p_return_status := hr_multi_message.get_return_status_disable;
387: hr_utility.set_location(' Leaving:' || l_proc, 30);
388: when others then
389: --
390: -- When Multiple Message Detection is enabled catch
391: -- any Application specific or other unexpected

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

394: -- error.
395: --
396: rollback to update_lp_cat_inclusion_swi;
397: if hr_multi_message.unexpected_error_add(l_proc) then
398: hr_utility.set_location(' Leaving:' || l_proc,40);
399: raise;
400: end if;
401: --
402: -- Reset IN OUT and set OUT parameters

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

402: -- Reset IN OUT and set OUT parameters
403: --
404: p_object_version_number := l_object_version_number;
405: p_return_status := hr_multi_message.get_return_status_disable;
406: hr_utility.set_location(' Leaving:' || l_proc,50);
407: end update_lp_cat_inclusion;
408: end ota_lp_category_swi;