DBA Data[Home] [Help]

APPS.OTA_LEARNING_PATH_SWI dependencies on HR_UTILITY

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

68:
69: l_proc varchar2(72) := g_package ||'create_learning_path';
70:
71: Begin
72: hr_utility.set_location(' Entering:' || l_proc,10);
73: --
74: -- Issue a savepoint
75: --
76: savepoint create_learning_path_swi;

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

179: -- messages of any type exist in the Multiple Message List.
180: -- Also disable Multiple Message Detection.
181: --
182: p_return_status := hr_multi_message.get_return_status_disable;
183: hr_utility.set_location(' Leaving:' || l_proc,20);
184: --
185: exception
186: when hr_multi_message.error_message_exist then
187: --

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

194: -- Reset IN OUT parameters and set OUT parameters
195: --
196: p_object_version_number := null;
197: p_return_status := hr_multi_message.get_return_status_disable;
198: hr_utility.set_location(' Leaving:' || l_proc, 30);
199: when others then
200: --
201: -- When Multiple Message Detection is enabled catch
202: -- any Application specific or other unexpected

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

205: -- error.
206: --
207: rollback to create_learning_path_swi;
208: if hr_multi_message.unexpected_error_add(l_proc) then
209: hr_utility.set_location(' Leaving:' || l_proc,40);
210: raise;
211: end if;
212: --
213: -- Reset IN OUT and set OUT parameters

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

213: -- Reset IN OUT and set OUT parameters
214: --
215: p_object_version_number := null;
216: p_return_status := hr_multi_message.get_return_status_disable;
217: hr_utility.set_location(' Leaving:' || l_proc,50);
218: end create_learning_path;
219: -- ----------------------------------------------------------------------------
220: -- |-------------------------< delete_learning_path >-------------------------|
221: -- ----------------------------------------------------------------------------

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

233: --
234: -- Other variables
235: l_proc varchar2(72) := g_package ||'delete_learning_path';
236: Begin
237: hr_utility.set_location(' Entering:' || l_proc,10);
238: --
239: -- Issue a savepoint
240: --
241: savepoint delete_learning_path_swi;

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

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

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

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

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

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

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

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

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

370: --
371: -- Other variables
372: l_proc varchar2(72) := g_package ||'update_learning_path';
373: Begin
374: hr_utility.set_location(' Entering:' || l_proc,10);
375: --
376: -- Issue a savepoint
377: --
378: savepoint update_learning_path_swi;

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

466: -- messages of any type exist in the Multiple Message List.
467: -- Also disable Multiple Message Detection.
468: --
469: p_return_status := hr_multi_message.get_return_status_disable;
470: hr_utility.set_location(' Leaving:' || l_proc,20);
471: --
472: exception
473: when hr_multi_message.error_message_exist then
474: --

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

481: -- Reset IN OUT parameters and set OUT parameters
482: --
483: p_object_version_number := l_object_version_number;
484: p_return_status := hr_multi_message.get_return_status_disable;
485: hr_utility.set_location(' Leaving:' || l_proc, 30);
486: when others then
487: --
488: -- When Multiple Message Detection is enabled catch
489: -- any Application specific or other unexpected

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

492: -- error.
493: --
494: rollback to update_learning_path_swi;
495: if hr_multi_message.unexpected_error_add(l_proc) then
496: hr_utility.set_location(' Leaving:' || l_proc,40);
497: raise;
498: end if;
499: --
500: -- Reset IN OUT and set OUT parameters

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

500: -- Reset IN OUT and set OUT parameters
501: --
502: p_object_version_number := l_object_version_number;
503: p_return_status := hr_multi_message.get_return_status_disable;
504: hr_utility.set_location(' Leaving:' || l_proc,50);
505: end update_learning_path;
506:
507: -- ----------------------------------------------------------------------------
508: -- |-------------------------< check_lp_enrollments_exist >------------------------|

Line 623: hr_utility.set_location(' Step:'|| l_proc, 10);

619: OPEN csr_ctg_name;
620: FETCH csr_ctg_name INTO l_exists;
621: IF csr_ctg_name%FOUND THEN
622: CLOSE csr_ctg_name;
623: hr_utility.set_location(' Step:'|| l_proc, 10);
624: fnd_message.set_name('OTA', 'OTA_13100_LPS_CTG_UNIQUE_NAME');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_ctg_name;

Line 628: hr_utility.set_location(' Step:'|| l_proc, 20);

624: fnd_message.set_name('OTA', 'OTA_13100_LPS_CTG_UNIQUE_NAME');
625: fnd_message.raise_error;
626: ELSE
627: CLOSE csr_ctg_name;
628: hr_utility.set_location(' Step:'|| l_proc, 20);
629: END IF;
630: ELSE
631: IF p_person_id IS NOT NULL THEN
632:

Line 637: hr_utility.set_location(' Step:'|| l_proc, 30);

633: OPEN csr_emp_name;
634: FETCH csr_emp_name INTO l_exists;
635: IF csr_emp_name%FOUND THEN
636: CLOSE csr_emp_name;
637: hr_utility.set_location(' Step:'|| l_proc, 30);
638: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
639: fnd_message.raise_error;
640: ELSE
641: CLOSE csr_emp_name;

Line 642: hr_utility.set_location(' Step:'|| l_proc, 40);

638: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
639: fnd_message.raise_error;
640: ELSE
641: CLOSE csr_emp_name;
642: hr_utility.set_location(' Step:'|| l_proc, 40);
643: END IF;
644:
645: ELSIF p_contact_id IS NOT NULL THEN
646:

Line 651: hr_utility.set_location(' Step:'|| l_proc, 50);

647: OPEN csr_ct_name;
648: FETCH csr_ct_name INTO l_exists;
649: IF csr_ct_name%FOUND THEN
650: CLOSE csr_ct_name;
651: hr_utility.set_location(' Step:'|| l_proc, 50);
652: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
653: fnd_message.raise_error;
654: ELSE
655: CLOSE csr_ct_name;

Line 656: hr_utility.set_location(' Step:'|| l_proc, 60);

652: fnd_message.set_name('OTA', 'OTA_443386_LPS_UNIQUE_NAME');
653: fnd_message.raise_error;
654: ELSE
655: CLOSE csr_ct_name;
656: hr_utility.set_location(' Step:'|| l_proc, 60);
657: END IF;
658:
659: END IF;
660: END IF;

Line 670: hr_utility.set_location(' Leaving:'||l_proc, 92);

666:
667: IF hr_multi_message.exception_add
668: (p_associated_column1 => 'OTA_LEARNING_PATHS.NAME') THEN
669:
670: hr_utility.set_location(' Leaving:'||l_proc, 92);
671: RAISE;
672:
673: END IF;
674:

Line 675: hr_utility.set_location(' Leaving:'||l_proc, 94);

671: RAISE;
672:
673: END IF;
674:
675: hr_utility.set_location(' Leaving:'||l_proc, 94);
676:
677: END check_duplicate_name;
678:
679: