DBA Data[Home] [Help]

APPS.OTA_CERT_CATEGORY_SWI dependencies on HR_UTILITY

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

50: l_certification_id number;
51: l_category_usage_id number;
52: l_proc varchar2(72) := g_package ||'create_cert_cat_inclusion';
53: Begin
54: hr_utility.set_location(' Entering:' || l_proc,10);
55: --
56: -- Issue a savepoint
57: --
58: savepoint create_cert_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_cert_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_cert_cat_inclusion;
162: -- ----------------------------------------------------------------------------
163: -- |-----------------------< update_cert_cat_inclusion >----------------------|
164: -- ----------------------------------------------------------------------------

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

203: --
204: -- Other variables
205: l_proc varchar2(72) := g_package ||'update_cert_cat_inclusion';
206: Begin
207: hr_utility.set_location(' Entering:' || l_proc,10);
208: --
209: -- Issue a savepoint
210: --
211: savepoint update_cert_cat_inclusion_swi;

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

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

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

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

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

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

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

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

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

327: --
328: -- Other variables
329: l_proc varchar2(72) := g_package ||'delete_cert_cat_inclusion';
330: Begin
331: hr_utility.set_location(' Entering:' || l_proc,10);
332: --
333: -- Issue a savepoint
334: --
335: savepoint delete_cert_cat_inclusion_swi;

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

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

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

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

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

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

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

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