eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OTA_LPS_BUS dependencies on HR_UTILITY

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

40: l_legislation_code varchar2(150);
41: --
42: begin
43: --
44: hr_utility.set_location('Entering:'|| l_proc, 10);
45: --
46: -- Ensure that all the mandatory parameter are not null
47: --
48: hr_api.mandatory_arg_error

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

80: --
81: hr_api.set_legislation_context(l_legislation_code);
82: end if;
83: --
84: hr_utility.set_location(' Leaving:'|| l_proc, 20);
85: --
86: end set_security_group_id;
87: --
88: -- ---------------------------------------------------------------------------

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

109: l_proc varchar2(72) := g_package||'return_legislation_code';
110: --
111: Begin
112: --
113: hr_utility.set_location('Entering:'|| l_proc, 10);
114: --
115: -- Ensure that all the mandatory parameter are not null
116: --
117: hr_api.mandatory_arg_error

Line 131: hr_utility.set_location(l_proc, 20);

127: -- call to this function. Just return the value in the global
128: -- variable.
129: --
130: l_legislation_code := ota_lps_bus.g_legislation_code;
131: hr_utility.set_location(l_proc, 20);
132: else
133: --
134: -- The ID is different to the last call to this function
135: -- or this is the first call to this function.

Line 148: hr_utility.set_location(l_proc,30);

144: close csr_leg_code;
145: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: end if;
148: hr_utility.set_location(l_proc,30);
149: --
150: -- Set the global variables so the values are
151: -- available for the next call to this function.
152: --

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

153: close csr_leg_code;
154: ota_lps_bus.g_learning_path_id := p_learning_path_id;
155: ota_lps_bus.g_legislation_code := l_legislation_code;
156: end if;
157: hr_utility.set_location(' Leaving:'|| l_proc, 40);
158: return l_legislation_code;
159: end return_legislation_code;
160: --
161: -- ----------------------------------------------------------------------------

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

192: --
193: l_proc varchar2(72) := g_package || 'chk_df';
194: --
195: begin
196: hr_utility.set_location('Entering:'||l_proc,10);
197: --
198: if ((p_rec.learning_path_id is not null) and (
199: nvl(ota_lps_shd.g_old_rec.attribute_category, hr_api.g_varchar2) <>
200: nvl(p_rec.attribute_category, hr_api.g_varchar2) or

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

291: ,p_attribute20_value => p_rec.attribute20
292: );
293: end if;
294: --
295: hr_utility.set_location(' Leaving:'||l_proc,20);
296: end chk_df;
297: --
298: -- ----------------------------------------------------------------------------
299: -- |-----------------------< chk_non_updateable_args >------------------------|

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

343: fnd_message.set_token('STEP ', '5');
344: fnd_message.raise_error;
345: END IF;
346: --
347: hr_utility.set_location(' Step:'|| l_proc, 10);
348: IF NVL(p_rec.business_group_id, hr_api.g_number) <>
349: NVL(ota_lps_shd.g_old_rec.business_group_id, hr_api.g_number) THEN
350: hr_api.argument_changed_error
351: (p_api_name => l_proc

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

352: ,p_argument => 'BUSINESS_GROUP_ID'
353: ,p_base_table => ota_lps_shd.g_tab_nam);
354: END IF;
355: --
356: hr_utility.set_location(' Step:'|| l_proc, 20);
357: IF NVL(p_rec.learning_path_id, hr_api.g_number) <>
358: NVL(ota_lps_shd.g_old_rec.learning_path_id, hr_api.g_number) THEN
359: hr_api.argument_changed_error
360: (p_api_name => l_proc

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

388: --
389: -- check mandatory parameters have been set
390: --
391: --
392: hr_utility.set_location(' Step:'|| l_proc, 30);
393:
394: IF hr_multi_message.no_exclusive_error
395: (p_check_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID'
396: ,p_associated_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID' ) THEN

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

395: (p_check_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID'
396: ,p_associated_column1 => 'OTA_LEARNING_PATHS.LEARNING_PATH_ID' ) THEN
397:
398:
399: hr_utility.set_location(' Step:'|| l_proc, 40);
400:
401: l_api_updating := ota_lps_shd.api_updating
402: (p_learning_path_id => p_learning_path_id
403: ,p_object_version_number => p_object_version_number);

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

412: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
413: --
414: -- check the duration is positive
415: --
416: hr_utility.set_location(' Step:'|| l_proc, 50);
417: IF (p_duration <= 0) THEN
418: hr_utility.set_location(' Step:'|| l_proc, 60);
419: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
420: fnd_message.raise_error;

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

414: -- check the duration is positive
415: --
416: hr_utility.set_location(' Step:'|| l_proc, 50);
417: IF (p_duration <= 0) THEN
418: hr_utility.set_location(' Step:'|| l_proc, 60);
419: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
420: fnd_message.raise_error;
421: ELSE IF((p_duration IS NOT NULL AND p_duration_units IS NULL)
422: OR (p_duration IS NULL AND p_duration_units IS NOT NULL)) THEN

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

419: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
420: fnd_message.raise_error;
421: ELSE IF((p_duration IS NOT NULL AND p_duration_units IS NULL)
422: OR (p_duration IS NULL AND p_duration_units IS NOT NULL)) THEN
423: hr_utility.set_location(' Step:'|| l_proc, 60);
424: fnd_message.set_name('OTA', 'OTA_13881_NHS_COMB_INVALID');
425: fnd_message.raise_error;
426: END IF;
427: END IF;

Line 431: hr_utility.set_location(' Leaving:'||l_proc, 90);

427: END IF;
428: END IF;
429: --
430: END IF;
431: hr_utility.set_location(' Leaving:'||l_proc, 90);
432:
433: EXCEPTION
434:
435: WHEN app_exception.application_exception THEN

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

436:
437: IF hr_multi_message.exception_add
438: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION') THEN
439:
440: hr_utility.set_location(' Leaving:'||l_proc, 92);
441: RAISE;
442:
443: END IF;
444:

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

441: RAISE;
442:
443: END IF;
444:
445: hr_utility.set_location(' Leaving:'||l_proc, 94);
446:
447: END chk_duration;
448: --
449: -- ----------------------------------------------------------------------------

Line 462: hr_utility.set_location(' Leaving:'||l_proc, 10);

458: l_proc VARCHAR2(72) := g_package||'chk_duration_units';
459: l_api_updating boolean;
460:
461: BEGIN
462: hr_utility.set_location(' Leaving:'||l_proc, 10);
463: --
464: -- check mandatory parameters has been set
465: --
466: hr_api.mandatory_arg_error

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

477: NVL(ota_lps_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
478: NVL(p_duration_units, hr_api.g_varchar2))
479: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
480:
481: hr_utility.set_location(' Leaving:'||l_proc, 20);
482: --
483:
484: IF p_duration_units IS NOT NULL THEN
485: IF hr_api.not_exists_in_hr_lookups

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

488: ,p_lookup_code => p_duration_units) THEN
489: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
490: fnd_message.raise_error;
491: END IF;
492: hr_utility.set_location(' Leaving:'||l_proc, 30);
493:
494: END IF;
495:
496: END IF;

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

493:
494: END IF;
495:
496: END IF;
497: hr_utility.set_location(' Leaving:'||l_proc, 40);
498:
499: EXCEPTION
500:
501: WHEN app_exception.application_exception THEN

Line 506: hr_utility.set_location(' Leaving:'||l_proc, 42);

502:
503: IF hr_multi_message.exception_add
504: (p_associated_column1 => 'OTA_LEARNING_PATHS.DURATION_UNITS') THEN
505:
506: hr_utility.set_location(' Leaving:'||l_proc, 42);
507: RAISE;
508: END IF;
509:
510: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 510: hr_utility.set_location(' Leaving:'||l_proc, 44);

506: hr_utility.set_location(' Leaving:'||l_proc, 42);
507: RAISE;
508: END IF;
509:
510: hr_utility.set_location(' Leaving:'||l_proc, 44);
511:
512: END chk_duration_units;
513: --
514: -- ----------------------------------------------------------------------------

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

522: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';
523: l_api_updating boolean;
524:
525: BEGIN
526: hr_utility.set_location(' Leaving:'||l_proc, 10);
527: --
528: IF p_path_source_code = 'CATALOG' THEN
529: IF p_duration IS NOT NULL AND p_notify_days_before_target IS NOT NULL THEN
530: -- Modified for Bug#3861864

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

542: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');
543: fnd_message.raise_error;
544: END IF;
545:
546: hr_utility.set_location(' Leaving:'||l_proc, 40);
547:
548: EXCEPTION
549:
550: WHEN app_exception.application_exception THEN

Line 555: hr_utility.set_location(' Leaving:'||l_proc, 42);

551:
552: IF hr_multi_message.exception_add
553: (p_associated_column1 => 'OTA_LEARNING_PATHS.NOTIFY_DAYS_BEFORE_TARGET') THEN
554:
555: hr_utility.set_location(' Leaving:'||l_proc, 42);
556: RAISE;
557: END IF;
558:
559: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 559: hr_utility.set_location(' Leaving:'||l_proc, 44);

555: hr_utility.set_location(' Leaving:'||l_proc, 42);
556: RAISE;
557: END IF;
558:
559: hr_utility.set_location(' Leaving:'||l_proc, 44);
560:
561: END chk_notify_days_before_target;
562: --
563: -- ----------------------------------------------------------------------------

Line 576: hr_utility.set_location(' Leaving:'||l_proc, 10);

572: l_proc VARCHAR2(72) := g_package||'chk_path_source_code';
573: l_api_updating boolean;
574:
575: BEGIN
576: hr_utility.set_location(' Leaving:'||l_proc, 10);
577: --
578: -- check mandatory parameters has been set
579: --
580: hr_api.mandatory_arg_error

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

590: NVL(ota_lps_shd.g_old_rec.path_source_code,hr_api.g_varchar2) <>
591: NVL(p_path_source_code, hr_api.g_varchar2))
592: OR NOT l_api_updating AND p_path_source_code IS NOT NULL) THEN
593:
594: hr_utility.set_location(' Leaving:'||l_proc, 20);
595: --
596:
597: IF p_path_source_code IS NOT NULL THEN
598: IF hr_api.not_exists_in_hr_lookups

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

601: ,p_lookup_code => p_path_source_code) THEN
602: fnd_message.set_name('OTA','OTA_13176_TPS_PLN_SRC_INVLD');
603: fnd_message.raise_error;
604: END IF;
605: hr_utility.set_location(' Leaving:'||l_proc, 30);
606:
607: END IF;
608:
609: END IF;

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

606:
607: END IF;
608:
609: END IF;
610: hr_utility.set_location(' Leaving:'||l_proc, 40);
611:
612: EXCEPTION
613:
614: WHEN app_exception.application_exception THEN

Line 619: hr_utility.set_location(' Leaving:'||l_proc, 42);

615:
616: IF hr_multi_message.exception_add
617: (p_associated_column1 => 'OTA_LEARNING_PATHS.PATH_SOURCE_CODE') THEN
618:
619: hr_utility.set_location(' Leaving:'||l_proc, 42);
620: RAISE;
621: END IF;
622:
623: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 623: hr_utility.set_location(' Leaving:'||l_proc, 44);

619: hr_utility.set_location(' Leaving:'||l_proc, 42);
620: RAISE;
621: END IF;
622:
623: hr_utility.set_location(' Leaving:'||l_proc, 44);
624:
625: END chk_path_source_code;
626: --
627: --

Line 641: hr_utility.set_location(' Leaving:'||l_proc, 10);

637: l_proc VARCHAR2(72) := g_package||'chk_source_function_code';
638: l_api_updating boolean;
639:
640: BEGIN
641: hr_utility.set_location(' Leaving:'||l_proc, 10);
642: --
643: -- check mandatory parameters has been set
644: --
645: hr_api.mandatory_arg_error

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

656: NVL(ota_lps_shd.g_old_rec.source_function_code,hr_api.g_varchar2) <>
657: NVL(p_source_function_code, hr_api.g_varchar2))
658: OR NOT l_api_updating AND p_source_function_code IS NOT NULL) THEN
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: --
662:
663: IF p_source_function_code IS NOT NULL THEN
664: IF hr_api.not_exists_in_hr_lookups

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

667: ,p_lookup_code => p_source_function_code) THEN
668: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');
669: fnd_message.raise_error;
670: END IF;
671: hr_utility.set_location(' Leaving:'||l_proc, 30);
672:
673: END IF;
674:
675: END IF;

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

672:
673: END IF;
674:
675: END IF;
676: hr_utility.set_location(' Leaving:'||l_proc, 40);
677:
678: EXCEPTION
679:
680: WHEN app_exception.application_exception THEN

Line 685: hr_utility.set_location(' Leaving:'||l_proc, 42);

681:
682: IF hr_multi_message.exception_add
683: (p_associated_column1 => 'OTA_LEARNING_PATHS.SOURCE_FUNCTION_CODE') THEN
684:
685: hr_utility.set_location(' Leaving:'||l_proc, 42);
686: RAISE;
687: END IF;
688:
689: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 689: hr_utility.set_location(' Leaving:'||l_proc, 44);

685: hr_utility.set_location(' Leaving:'||l_proc, 42);
686: RAISE;
687: END IF;
688:
689: hr_utility.set_location(' Leaving:'||l_proc, 44);
690:
691: END chk_source_function_code;
692: --
693: -- ----------------------------------------------------------------------------

Line 706: hr_utility.set_location(' Leaving:'||l_proc, 10);

702: l_proc VARCHAR2(72) := g_package||'chk_competency_update_level';
703: l_api_updating boolean;
704:
705: BEGIN
706: hr_utility.set_location(' Leaving:'||l_proc, 10);
707: --
708: -- check mandatory parameters has been set
709: --
710: hr_api.mandatory_arg_error

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

721: NVL(ota_lps_shd.g_old_rec.competency_update_level,hr_api.g_varchar2) <>
722: NVL(p_competency_update_level, hr_api.g_varchar2))
723: OR NOT l_api_updating AND p_competency_update_level IS NOT NULL) THEN
724:
725: hr_utility.set_location(' Leaving:'||l_proc, 20);
726: --
727:
728: IF p_competency_update_level IS NOT NULL THEN
729: IF hr_api.not_exists_in_hr_lookups

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

732: ,p_lookup_code => p_competency_update_level) THEN
733: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');
734: fnd_message.raise_error;
735: END IF;
736: hr_utility.set_location(' Leaving:'||l_proc, 30);
737:
738: END IF;
739:
740: END IF;

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

737:
738: END IF;
739:
740: END IF;
741: hr_utility.set_location(' Leaving:'||l_proc, 40);
742:
743: EXCEPTION
744:
745: WHEN app_exception.application_exception THEN

Line 750: hr_utility.set_location(' Leaving:'||l_proc, 42);

746:
747: IF hr_multi_message.exception_add
748: (p_associated_column1 => 'OTA_LEARNING_PATHS.competency_update_level') THEN
749:
750: hr_utility.set_location(' Leaving:'||l_proc, 42);
751: RAISE;
752: END IF;
753:
754: hr_utility.set_location(' Leaving:'||l_proc, 44);

Line 754: hr_utility.set_location(' Leaving:'||l_proc, 44);

750: hr_utility.set_location(' Leaving:'||l_proc, 42);
751: RAISE;
752: END IF;
753:
754: hr_utility.set_location(' Leaving:'||l_proc, 44);
755:
756: END chk_competency_update_level;
757:
758: --

Line 777: hr_utility.set_location('Entering:'|| v_proc, 5);

773: v_proc varchar2(72) := g_package||'check_start_end_dates';
774: --
775: Begin
776: --
777: hr_utility.set_location('Entering:'|| v_proc, 5);
778: --
779: ota_general.check_start_end_dates( p_start_date, p_end_date);
780: --
781: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 781: hr_utility.set_location(' Leaving:'|| v_proc, 10);

777: hr_utility.set_location('Entering:'|| v_proc, 5);
778: --
779: ota_general.check_start_end_dates( p_start_date, p_end_date);
780: --
781: hr_utility.set_location(' Leaving:'|| v_proc, 10);
782:
783: Exception
784: WHEN app_exception.application_exception THEN
785:

Line 791: hr_utility.set_location(' Leaving:'||v_proc, 22);

787: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')
788: -- ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')
789: THEN
790:
791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;
793:
794: END IF;
795: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 795: hr_utility.set_location(' Leaving:'||v_proc, 25);

791: hr_utility.set_location(' Leaving:'||v_proc, 22);
792: RAISE;
793:
794: END IF;
795: hr_utility.set_location(' Leaving:'||v_proc, 25);
796: --
797: End check_start_end_dates;
798: --
799:

Line 834: hr_utility.set_location('Entering:'|| v_proc, 5);

830: OR (l_end_date_active IS NOT NULL AND tav.start_date > l_end_date_active));
831: --
832: Begin
833: --
834: hr_utility.set_location('Entering:'|| v_proc, 5);
835: --
836: IF hr_multi_message.no_exclusive_error
837: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
838: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

Line 876: hr_utility.set_location(' Leaving:'|| v_proc, 10);

872: END IF;
873: END IF;
874:
875: --
876: hr_utility.set_location(' Leaving:'|| v_proc, 10);
877:
878: Exception
879: WHEN app_exception.application_exception THEN
880:

Line 886: hr_utility.set_location(' Leaving:'||v_proc, 22);

882: IF hr_multi_message.exception_add(
883: p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE')
884: THEN
885:
886: hr_utility.set_location(' Leaving:'||v_proc, 22);
887: RAISE;
888: END IF;
889: ELSIF l_upd_end_date THEN
890: IF hr_multi_message.exception_add(

Line 894: hr_utility.set_location(' Leaving:'||v_proc, 22);

890: IF hr_multi_message.exception_add(
891: p_associated_column1 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE')
892: THEN
893:
894: hr_utility.set_location(' Leaving:'||v_proc, 22);
895: RAISE;
896: END IF;
897: END IF;
898: hr_utility.set_location(' Leaving:'||v_proc, 25);

Line 898: hr_utility.set_location(' Leaving:'||v_proc, 25);

894: hr_utility.set_location(' Leaving:'||v_proc, 22);
895: RAISE;
896: END IF;
897: END IF;
898: hr_utility.set_location(' Leaving:'||v_proc, 25);
899: --
900: End check_lp_course_dates;
901: --
902: -- ----------------------------------------------------------------------------

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

938: l_start_date_active date;
939: l_end_date_active date;
940:
941: Begin
942: hr_utility.set_location(' Entering:' || l_proc,10);
943: --
944: IF hr_multi_message.no_exclusive_error
945: (p_check_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
946: ,p_check_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'

Line 983: hr_utility.set_location(' Leaving:' || l_proc,10);

979: CLOSE cur_cat_start_end_date;
980: End IF;
981: End IF;
982: --
983: hr_utility.set_location(' Leaving:' || l_proc,10);
984: Exception
985: when app_exception.application_exception then
986: IF hr_multi_message.exception_add
987: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'

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

986: IF hr_multi_message.exception_add
987: (p_associated_column1 => 'OTA_LEARNING_PATHS.START_DATE_ACTIVE'
988: ,p_associated_column2 => 'OTA_LEARNING_PATHS.END_DATE_ACTIVE'
989: ) THEN
990: hr_utility.set_location(' Leaving:'|| l_proc,20);
991: raise;
992: END IF;
993:
994: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

990: hr_utility.set_location(' Leaving:'|| l_proc,20);
991: raise;
992: END IF;
993:
994: hr_utility.set_location(' Leaving:'|| l_proc,30);
995: --
996: End check_category_dates;
997: --
998: --

Line 1020: hr_utility.set_location('Entering:'||l_proc, 5);

1016: BEGIN
1017: --
1018: -- check mandatory parameters have been set
1019: --
1020: hr_utility.set_location('Entering:'||l_proc, 5);
1021: hr_api.mandatory_arg_error
1022: (p_api_name => l_proc
1023: ,p_argument => 'p_learning_path_id'
1024: ,p_argument_value => p_learning_path_id

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

1026: --
1027: OPEN csr_get_path_source;
1028: FETCH csr_get_path_source INTO l_path_source_code;
1029: CLOSE csr_get_path_source;
1030: hr_utility.set_location(' Leaving:'||l_proc, 20);
1031: --
1032: RETURN l_path_source_code;
1033: END get_path_source_code;
1034: --

Line 1055: hr_utility.set_location('Entering:'||l_proc, 5);

1051: BEGIN
1052: --
1053: -- check mandatory parameters have been set
1054: --
1055: hr_utility.set_location('Entering:'||l_proc, 5);
1056: hr_api.mandatory_arg_error
1057: (p_api_name => l_proc
1058: ,p_argument => 'p_learning_path_id'
1059: ,p_argument_value => p_learning_path_id

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

1064: OPEN csr_del_lp_id;
1065: FETCH csr_del_lp_id INTO g_dummy;
1066: IF csr_del_lp_id%FOUND THEN
1067: l_exists := TRUE;
1068: hr_utility.set_location(' Step:'|| l_proc, 10);
1069: END IF;
1070: CLOSE csr_del_lp_id;
1071: hr_utility.set_location(' Leaving:'||l_proc, 20);
1072: --

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

1067: l_exists := TRUE;
1068: hr_utility.set_location(' Step:'|| l_proc, 10);
1069: END IF;
1070: CLOSE csr_del_lp_id;
1071: hr_utility.set_location(' Leaving:'||l_proc, 20);
1072: --
1073: RETURN l_exists;
1074: END chk_lp_enrollments_exist;
1075: --

Line 1088: hr_utility.set_location('Entering:'||l_proc, 5);

1084: --
1085: l_proc varchar2(72) := g_package||'insert_validate';
1086: --
1087: Begin
1088: hr_utility.set_location('Entering:'||l_proc, 5);
1089: --
1090: -- Call all supporting business operations
1091: --
1092: hr_api.validate_bus_grp_id

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

1102: --
1103: -- Validate Dependent Attributes
1104: --
1105: --
1106: hr_utility.set_location(' Step:'|| l_proc, 10);
1107: ota_lps_bus.chk_path_source_code(
1108: p_learning_path_id => p_rec.learning_path_id
1109: ,p_object_version_number => p_rec.object_version_number
1110: ,p_path_source_code => p_rec.path_source_code

Line 1157: hr_utility.set_location(' Leaving:'||l_proc, 10);

1153: --
1154: hr_multi_message.end_validation_set;
1155: --
1156: --
1157: hr_utility.set_location(' Leaving:'||l_proc, 10);
1158: End insert_validate;
1159: --
1160: -- ----------------------------------------------------------------------------
1161: -- |---------------------------< update_validate >----------------------------|

Line 1184: hr_utility.set_location('Entering:'||l_proc, 5);

1180:
1181:
1182: --
1183: Begin
1184: hr_utility.set_location('Entering:'||l_proc, 5);
1185: --
1186: -- Call all supporting business operations
1187: --
1188: hr_api.validate_bus_grp_id

Line 1270: hr_utility.set_location(' Leaving:'||l_proc, 10);

1266:
1267: END IF;
1268:
1269: --
1270: hr_utility.set_location(' Leaving:'||l_proc, 10);
1271: End update_validate;
1272: --
1273: -- ----------------------------------------------------------------------------
1274: -- |---------------------------< delete_validate >----------------------------|

Line 1283: hr_utility.set_location('Entering:'||l_proc, 5);

1279: --
1280: l_proc varchar2(72) := g_package||'delete_validate';
1281: --
1282: Begin
1283: hr_utility.set_location('Entering:'||l_proc, 5);
1284: --
1285: -- Call all supporting business operations
1286: IF get_path_source_code(ota_lps_shd.g_old_rec.learning_path_id) = 'CATALOG' THEN
1287:

Line 1296: hr_utility.set_location(' Leaving:'||l_proc, 10);

1292: END IF;
1293:
1294: END IF;
1295: --
1296: hr_utility.set_location(' Leaving:'||l_proc, 10);
1297: End delete_validate;
1298:
1299:
1300: --