DBA Data[Home] [Help]

APPS.OTA_LP_ENROLLMENT_SWI dependencies on HR_UTILITY

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

67: -- Other variables
68: l_lp_enrollment_id number;
69: l_proc varchar2(72) := g_package ||'create_lp_enrollment';
70: Begin
71: hr_utility.set_location(' Entering:' || l_proc,10);
72: --
73: -- Issue a savepoint
74: --
75: savepoint create_lp_enrollment_swi;

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

156: -- messages of any type exist in the Multiple Message List.
157: -- Also disable Multiple Message Detection.
158: --
159: p_return_status := hr_multi_message.get_return_status_disable;
160: hr_utility.set_location(' Leaving:' || l_proc,20);
161: --
162: exception
163: when hr_multi_message.error_message_exist then
164: --

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

171: -- Reset IN OUT parameters and set OUT parameters
172: --
173: p_object_version_number := null;
174: p_return_status := hr_multi_message.get_return_status_disable;
175: hr_utility.set_location(' Leaving:' || l_proc, 30);
176: when others then
177: --
178: -- When Multiple Message Detection is enabled catch
179: -- any Application specific or other unexpected

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

182: -- error.
183: --
184: rollback to create_lp_enrollment_swi;
185: if hr_multi_message.unexpected_error_add(l_proc) then
186: hr_utility.set_location(' Leaving:' || l_proc,40);
187: raise;
188: end if;
189: --
190: -- Reset IN OUT and set OUT parameters

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

190: -- Reset IN OUT and set OUT parameters
191: --
192: p_object_version_number := null;
193: p_return_status := hr_multi_message.get_return_status_disable;
194: hr_utility.set_location(' Leaving:' || l_proc,50);
195: end create_lp_enrollment;
196: -- ----------------------------------------------------------------------------
197: -- |-------------------------< update_lp_enrollment >-------------------------|
198: -- ----------------------------------------------------------------------------

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

254: --
255: -- Other variables
256: l_proc varchar2(72) := g_package ||'update_lp_enrollment';
257: Begin
258: hr_utility.set_location(' Entering:' || l_proc,10);
259: --
260: -- Issue a savepoint
261: --
262: savepoint update_lp_enrollment_swi;

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

340: -- messages of any type exist in the Multiple Message List.
341: -- Also disable Multiple Message Detection.
342: --
343: p_return_status := hr_multi_message.get_return_status_disable;
344: hr_utility.set_location(' Leaving:' || l_proc,20);
345: --
346: exception
347: when hr_multi_message.error_message_exist then
348: --

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

355: -- Reset IN OUT parameters and set OUT parameters
356: --
357: p_object_version_number := l_object_version_number;
358: p_return_status := hr_multi_message.get_return_status_disable;
359: hr_utility.set_location(' Leaving:' || l_proc, 30);
360: when others then
361: --
362: -- When Multiple Message Detection is enabled catch
363: -- any Application specific or other unexpected

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

366: -- error.
367: --
368: rollback to update_lp_enrollment_swi;
369: if hr_multi_message.unexpected_error_add(l_proc) then
370: hr_utility.set_location(' Leaving:' || l_proc,40);
371: raise;
372: end if;
373: --
374: -- Reset IN OUT and set OUT parameters

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

374: -- Reset IN OUT and set OUT parameters
375: --
376: p_object_version_number := l_object_version_number;
377: p_return_status := hr_multi_message.get_return_status_disable;
378: hr_utility.set_location(' Leaving:' || l_proc,50);
379: end update_lp_enrollment;
380: -- ----------------------------------------------------------------------------
381: -- |-------------------------< delete_lp_enrollment >-------------------------|
382: -- ----------------------------------------------------------------------------

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

394: --
395: -- Other variables
396: l_proc varchar2(72) := g_package ||'delete_lp_enrollment';
397: Begin
398: hr_utility.set_location(' Entering:' || l_proc,10);
399: --
400: -- Issue a savepoint
401: --
402: savepoint delete_lp_enrollment_swi;

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

436: -- messages of any type exist in the Multiple Message List.
437: -- Also disable Multiple Message Detection.
438: --
439: p_return_status := hr_multi_message.get_return_status_disable;
440: hr_utility.set_location(' Leaving:' || l_proc,20);
441: --
442: exception
443: when hr_multi_message.error_message_exist then
444: --

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

450: --
451: -- Reset IN OUT parameters and set OUT parameters
452: --
453: p_return_status := hr_multi_message.get_return_status_disable;
454: hr_utility.set_location(' Leaving:' || l_proc, 30);
455: when others then
456: --
457: -- When Multiple Message Detection is enabled catch
458: -- any Application specific or other unexpected

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

461: -- error.
462: --
463: rollback to delete_lp_enrollment_swi;
464: if hr_multi_message.unexpected_error_add(l_proc) then
465: hr_utility.set_location(' Leaving:' || l_proc,40);
466: raise;
467: end if;
468: --
469: -- Reset IN OUT and set OUT parameters

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

468: --
469: -- Reset IN OUT and set OUT parameters
470: --
471: p_return_status := hr_multi_message.get_return_status_disable;
472: hr_utility.set_location(' Leaving:' || l_proc,50);
473: end delete_lp_enrollment;
474: -- ----------------------------------------------------------------------------
475: -- |--------------------------< SUBSCRIBE_TO_LEARNING_PATH>-------------------------|
476: -- ----------------------------------------------------------------------------

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

522: -- messages of any type exist in the Multiple Message List.
523: -- Also disable Multiple Message Detection.
524: --
525: p_return_status := hr_multi_message.get_return_status_disable;
526: hr_utility.set_location(' Leaving:' || l_proc,20);
527:
528: exception
529: when hr_multi_message.error_message_exist then
530: --

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

538: --
539: p_lp_enrollment_id := null;
540: p_path_status_code := null;
541: p_return_status := hr_multi_message.get_return_status_disable;
542: hr_utility.set_location(' Leaving:' || l_proc, 30);
543:
544: when hr_api.validate_enabled then
545: --
546: -- As the Validate_Enabled exception has been raised

Line 557: hr_utility.set_location(' Leaving:'||l_proc, 80);

553: -- when validation only mode is being used.)
554: --
555: p_lp_enrollment_id := null;
556: p_path_status_code := null;
557: hr_utility.set_location(' Leaving:'||l_proc, 80);
558: when others then
559: --
560: -- When Multiple Message Detection is enabled catch
561: -- any Application specific or other unexpected

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

564: -- error.
565: --
566: rollback to create_lp_subscription_swi;
567: if hr_multi_message.unexpected_error_add(l_proc) then
568: hr_utility.set_location(' Leaving:' || l_proc,40);
569: raise;
570: end if;
571: --
572: -- Reset IN OUT and set OUT parameters

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

573: --
574: p_lp_enrollment_id := null;
575: p_path_status_code := null;
576: p_return_status := hr_multi_message.get_return_status_disable;
577: hr_utility.set_location(' Leaving:' || l_proc,50);
578: END subscribe_to_learning_path;
579: end ota_lp_enrollment_swi;