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_LPM_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_lpm_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_lpm_bus.g_learning_path_member_id := p_learning_path_member_id;
155: ota_lpm_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_member_id is not null) and (
199: nvl(ota_lpm_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 375: hr_utility.set_location('Entering:'|| v_proc, 5);

371: where lps.learning_path_id = p_learning_path_id;
372: --
373: Begin
374: --
375: hr_utility.set_location('Entering:'|| v_proc, 5);
376: --
377: Open csr_is_catalog_lp;
378: fetch csr_is_catalog_lp into v_path_source_code;
379: close csr_is_catalog_lp;

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

380: --
381: IF v_path_source_code = 'CATALOG' THEN
382: l_return := TRUE;
383: END IF;
384: hr_utility.set_location(' Leaving:'|| v_proc, 10);
385: --
386: RETURN l_return;
387:
388: End is_catalog_lp;

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

398: l_proc VARCHAR2(72) := g_package||'chk_notify_days_before_target';
399: l_api_updating boolean;
400:
401: BEGIN
402: hr_utility.set_location(' Leaving:'||l_proc, 10);
403: --
404: IF is_catalog_lp(p_learning_path_id) THEN
405: IF p_duration IS NOT NULL AND p_notify_days_before_target IS NOT NULL THEN
406: --Modified for Bug#3861864

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

418: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');
419: fnd_message.raise_error;
420: END IF;
421:
422: hr_utility.set_location(' Leaving:'||l_proc, 40);
423:
424: EXCEPTION
425:
426: WHEN app_exception.application_exception THEN

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

427:
428: IF hr_multi_message.exception_add
429: (p_associated_column1 => 'OTA_LEARNING_PATHS.NOTIFY_DAYS_BEFORE_TARGET') THEN
430:
431: hr_utility.set_location(' Leaving:'||l_proc, 42);
432: RAISE;
433: END IF;
434:
435: hr_utility.set_location(' Leaving:'||l_proc, 44);

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

431: hr_utility.set_location(' Leaving:'||l_proc, 42);
432: RAISE;
433: END IF;
434:
435: hr_utility.set_location(' Leaving:'||l_proc, 44);
436:
437: END chk_notify_days_before_target;
438: --
439: -- ----------------------------------------------------------------------------

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

467: BEGIN
468: --
469: -- check mandatory parameters have been set.
470: --
471: hr_utility.set_location(' Step:'|| l_proc, 10);
472:
473: IF hr_multi_message.no_exclusive_error
474: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
475: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN

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

494: OR (NOT l_api_updating)
495: THEN
496: -- Check that the definition exists
497: --
498: hr_utility.set_location(' Step:'|| l_proc, 20);
499: OPEN csr_activity_version_id;
500: FETCH csr_activity_version_id INTO l_business_group_id;
501: IF csr_activity_version_id%NOTFOUND THEN
502: CLOSE csr_activity_version_id;

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

507: CLOSE csr_activity_version_id;
508: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');
509: fnd_message.raise_error;
510: ELSE
511: hr_utility.set_location(' Step:'|| l_proc, 30);
512: CLOSE csr_activity_version_id;
513: END IF;
514: END IF;
515: --

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

517: END IF;
518: --
519:
520: END IF;
521: hr_utility.set_location(' Leaving:'||l_proc, 40);
522:
523: EXCEPTION
524:
525: WHEN app_exception.application_exception THEN

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

526:
527: IF hr_multi_message.exception_add
528: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN
529:
530: hr_utility.set_location(' Leaving:'||l_proc, 42);
531: RAISE;
532:
533: END IF;
534:

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

531: RAISE;
532:
533: END IF;
534:
535: hr_utility.set_location(' Leaving:'||l_proc, 44);
536:
537:
538: END chk_activity_version_id;
539:

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

557: BEGIN
558: --
559: -- check mandatory parameters have been set
560: --
561: hr_utility.set_location(' Step:'|| l_proc, 20);
562: hr_api.mandatory_arg_error
563: (p_api_name => l_proc
564: ,p_argument => 'p_learning_path_id'
565: ,p_argument_value => p_learning_path_id

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

564: ,p_argument => 'p_learning_path_id'
565: ,p_argument_value => p_learning_path_id
566: );
567: --
568: hr_utility.set_location(' Step:'|| l_proc, 30);
569: hr_api.mandatory_arg_error
570: (p_api_name => l_proc
571: ,p_argument => 'p_business_group_id'
572: ,p_argument_value => p_business_group_id

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

572: ,p_argument_value => p_business_group_id
573: );
574: --
575: --
576: hr_utility.set_location(' Step:'|| l_proc, 50);
577: OPEN csr_learning_path_id;
578: FETCH csr_learning_path_id INTO l_exists;
579: IF csr_learning_path_id%NOTFOUND THEN
580: CLOSE csr_learning_path_id;

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

577: OPEN csr_learning_path_id;
578: FETCH csr_learning_path_id INTO l_exists;
579: IF csr_learning_path_id%NOTFOUND THEN
580: CLOSE csr_learning_path_id;
581: hr_utility.set_location(' Step:'|| l_proc, 60);
582: fnd_message.set_name('OTA', 'OTA_13605_LPM_NO_LEARNING_PATH');
583: fnd_message.raise_error;
584: ELSE
585: hr_utility.set_location(' Step:'|| l_proc, 80);

Line 585: hr_utility.set_location(' Step:'|| l_proc, 80);

581: hr_utility.set_location(' Step:'|| l_proc, 60);
582: fnd_message.set_name('OTA', 'OTA_13605_LPM_NO_LEARNING_PATH');
583: fnd_message.raise_error;
584: ELSE
585: hr_utility.set_location(' Step:'|| l_proc, 80);
586: CLOSE csr_learning_path_id;
587: END IF;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 90);

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

585: hr_utility.set_location(' Step:'|| l_proc, 80);
586: CLOSE csr_learning_path_id;
587: END IF;
588: --
589: hr_utility.set_location(' Leaving:'||l_proc, 90);
590:
591: EXCEPTION
592:
593: WHEN app_exception.application_exception THEN

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

594:
595: IF hr_multi_message.exception_add
596: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID') THEN
597:
598: hr_utility.set_location(' Leaving:'||l_proc, 92);
599: RAISE;
600: END IF;
601:
602: hr_utility.set_location(' Leaving:'||l_proc, 94);

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

598: hr_utility.set_location(' Leaving:'||l_proc, 92);
599: RAISE;
600: END IF;
601:
602: hr_utility.set_location(' Leaving:'||l_proc, 94);
603:
604: END chk_learning_path_id;
605: --
606: -- ----------------------------------------------------------------------------

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

630: --
631: -- check mandatory parameters have been set
632: --
633: --
634: hr_utility.set_location(' Step:'|| l_proc, 30);
635:
636: IF hr_multi_message.no_exclusive_error
637: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
638: ,p_check_column2 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'

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

658: OR (NOT l_api_updating) THEN
659: --
660: -- check the combination is unique
661: --
662: hr_utility.set_location(' Step:'|| l_proc, 50);
663: OPEN csr_unique;
664: FETCH csr_unique INTO l_exists;
665: IF csr_unique%FOUND THEN
666: CLOSE csr_unique;

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

663: OPEN csr_unique;
664: FETCH csr_unique INTO l_exists;
665: IF csr_unique%FOUND THEN
666: CLOSE csr_unique;
667: hr_utility.set_location(' Step:'|| l_proc, 60);
668: fnd_message.set_name('OTA', 'OTA_13620_LPM_NOT_UNIQUE');
669: fnd_message.raise_error;
670: ELSE
671: CLOSE csr_unique;

Line 672: hr_utility.set_location(' Step:'|| l_proc, 70);

668: fnd_message.set_name('OTA', 'OTA_13620_LPM_NOT_UNIQUE');
669: fnd_message.raise_error;
670: ELSE
671: CLOSE csr_unique;
672: hr_utility.set_location(' Step:'|| l_proc, 70);
673: END IF;
674: END IF;
675: --
676: END IF;

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

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

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

682:
683: IF hr_multi_message.exception_add
684: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID') THEN
685:
686: hr_utility.set_location(' Leaving:'||l_proc, 92);
687: RAISE;
688:
689: END IF;
690:

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

687: RAISE;
688:
689: END IF;
690:
691: hr_utility.set_location(' Leaving:'||l_proc, 94);
692:
693: END chk_unique_course;
694: --
695:

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

721: --
722: -- check mandatory parameters have been set
723: --
724: --
725: hr_utility.set_location(' Step:'|| l_proc, 30);
726:
727: IF hr_multi_message.no_exclusive_error
728: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID'
729: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.ACTIVITY_VERSION_ID' ) THEN

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

747: OR (NOT l_api_updating) THEN
748: --
749: -- check the sequence is unique
750: --
751: hr_utility.set_location(' Step:'|| l_proc, 50);
752: OPEN csr_unique;
753: FETCH csr_unique INTO l_exists;
754: IF csr_unique%FOUND THEN
755: CLOSE csr_unique;

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

752: OPEN csr_unique;
753: FETCH csr_unique INTO l_exists;
754: IF csr_unique%FOUND THEN
755: CLOSE csr_unique;
756: hr_utility.set_location(' Step:'|| l_proc, 60);
757: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
758: fnd_message.raise_error;
759: ELSE
760: CLOSE csr_unique;

Line 761: hr_utility.set_location(' Step:'|| l_proc, 70);

757: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_UNIQUE');
758: fnd_message.raise_error;
759: ELSE
760: CLOSE csr_unique;
761: hr_utility.set_location(' Step:'|| l_proc, 70);
762: END IF;
763: END IF;
764: --
765: END IF;

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

762: END IF;
763: END IF;
764: --
765: END IF;
766: hr_utility.set_location(' Leaving:'||l_proc, 90);
767:
768: EXCEPTION
769:
770: WHEN app_exception.application_exception THEN

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

771:
772: IF hr_multi_message.exception_add
773: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.COURSE_SEQUENCE') THEN
774:
775: hr_utility.set_location(' Leaving:'||l_proc, 92);
776: RAISE;
777:
778: END IF;
779:

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

776: RAISE;
777:
778: END IF;
779:
780: hr_utility.set_location(' Leaving:'||l_proc, 94);
781:
782: END chk_unique_sequence;
783: --
784:

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

805: --
806: -- check mandatory parameters have been set
807: --
808: --
809: hr_utility.set_location(' Step:'|| l_proc, 30);
810:
811: IF hr_multi_message.no_exclusive_error
812: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
813: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID' ) THEN

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

812: (p_check_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID'
813: ,p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.LEARNING_PATH_ID' ) THEN
814:
815:
816: hr_utility.set_location(' Step:'|| l_proc, 40);
817:
818: l_api_updating := ota_lpm_shd.api_updating
819: (p_learning_path_member_id => p_learning_path_member_id
820: ,p_object_version_number => p_object_version_number);

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

829: OR (NOT l_api_updating AND (p_duration IS NOT NULL OR p_duration_units IS NOT NULL)) THEN
830: --
831: -- check the duration is positive
832: --
833: hr_utility.set_location(' Step:'|| l_proc, 50);
834: IF (p_duration <= 0) THEN
835: hr_utility.set_location(' Step:'|| l_proc, 60);
836: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
837: fnd_message.raise_error;

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

831: -- check the duration is positive
832: --
833: hr_utility.set_location(' Step:'|| l_proc, 50);
834: IF (p_duration <= 0) THEN
835: hr_utility.set_location(' Step:'|| l_proc, 60);
836: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
837: fnd_message.raise_error;
838: ELSE IF((p_duration IS NOT NULL AND p_duration_units IS NULL)
839: OR (p_duration IS NULL AND p_duration_units IS NOT NULL)) THEN

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

836: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');
837: fnd_message.raise_error;
838: ELSE IF((p_duration IS NOT NULL AND p_duration_units IS NULL)
839: OR (p_duration IS NULL AND p_duration_units IS NOT NULL)) THEN
840: hr_utility.set_location(' Step:'|| l_proc, 60);
841: fnd_message.set_name('OTA', 'OTA_13881_NHS_COMB_INVALID');
842: fnd_message.raise_error;
843: END IF;
844: END IF;

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

844: END IF;
845: END IF;
846: --
847: END IF;
848: hr_utility.set_location(' Leaving:'||l_proc, 90);
849:
850: EXCEPTION
851:
852: WHEN app_exception.application_exception THEN

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

853:
854: IF hr_multi_message.exception_add
855: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION') THEN
856:
857: hr_utility.set_location(' Leaving:'||l_proc, 92);
858: RAISE;
859:
860: END IF;
861:

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

858: RAISE;
859:
860: END IF;
861:
862: hr_utility.set_location(' Leaving:'||l_proc, 94);
863:
864: END chk_duration;
865: --
866: -- ----------------------------------------------------------------------------

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

875: l_proc VARCHAR2(72) := g_package||'chk_duration_units';
876: l_api_updating boolean;
877:
878: BEGIN
879: hr_utility.set_location(' Leaving:'||l_proc, 10);
880: --
881: -- check mandatory parameters has been set
882: --
883: hr_api.mandatory_arg_error

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

894: NVL(ota_lpm_shd.g_old_rec.duration_units,hr_api.g_varchar2) <>
895: NVL(p_duration_units, hr_api.g_varchar2))
896: OR NOT l_api_updating AND p_duration_units IS NOT NULL) THEN
897:
898: hr_utility.set_location(' Leaving:'||l_proc, 20);
899: --
900:
901: IF p_duration_units IS NOT NULL THEN
902: IF hr_api.not_exists_in_hr_lookups

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

905: ,p_lookup_code => p_duration_units) THEN
906: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
907: fnd_message.raise_error;
908: END IF;
909: hr_utility.set_location(' Leaving:'||l_proc, 30);
910:
911: END IF;
912:
913: END IF;

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

910:
911: END IF;
912:
913: END IF;
914: hr_utility.set_location(' Leaving:'||l_proc, 40);
915:
916: EXCEPTION
917:
918: WHEN app_exception.application_exception THEN

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

919:
920: IF hr_multi_message.exception_add
921: (p_associated_column1 => 'OTA_LEARNING_PATH_MEMBERS.DURATION_UNITS') THEN
922:
923: hr_utility.set_location(' Leaving:'||l_proc, 42);
924: RAISE;
925: END IF;
926:
927: hr_utility.set_location(' Leaving:'||l_proc, 44);

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

923: hr_utility.set_location(' Leaving:'||l_proc, 42);
924: RAISE;
925: END IF;
926:
927: hr_utility.set_location(' Leaving:'||l_proc, 44);
928:
929: END chk_duration_units;
930: --
931:

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

940: --
941: l_proc varchar2(72) := g_package||'insert_validate';
942: --
943: Begin
944: hr_utility.set_location('Entering:'||l_proc, 5);
945: --
946: -- Call all supporting business operations
947: --
948: hr_api.validate_bus_grp_id

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

954: -- if Multiple Message detection is enabled and at least
955: -- one error has been found then abort further validation.
956: --
957: hr_multi_message.end_validation_set;
958: hr_utility.set_location(' Step:'|| l_proc, 10);
959: --
960: -- Validate Dependent Attributes
961: --
962: --

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

965: p_learning_path_id => p_rec.learning_path_id
966: ,p_business_group_id => p_rec.business_group_id);
967: */
968:
969: hr_utility.set_location(' Step:'|| l_proc, 20);
970:
971: ota_lpm_bus.chk_notify_days_before_target(
972: p_learning_path_id => p_rec.learning_path_id
973: ,p_duration => p_rec.duration

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

1004: ota_lpm_bus.chk_df(p_rec);
1005: END IF;
1006:
1007: --
1008: hr_utility.set_location(' Leaving:'||l_proc, 10);
1009: End insert_validate;
1010: --
1011: -- ----------------------------------------------------------------------------
1012: -- |---------------------------< update_validate >----------------------------|

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

1018: --
1019: l_proc varchar2(72) := g_package||'update_validate';
1020: --
1021: Begin
1022: hr_utility.set_location('Entering:'||l_proc, 5);
1023: --
1024: -- Call all supporting business operations
1025: --
1026: hr_api.validate_bus_grp_id

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

1065: ota_lpm_bus.chk_df(p_rec);
1066: END IF;
1067:
1068: --
1069: hr_utility.set_location(' Leaving:'||l_proc, 10);
1070: End update_validate;
1071: --
1072: -- ----------------------------------------------------------------------------
1073: -- |---------------------------< delete_validate >----------------------------|

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

1078: --
1079: l_proc varchar2(72) := g_package||'delete_validate';
1080: --
1081: Begin
1082: hr_utility.set_location('Entering:'||l_proc, 5);
1083: --
1084: -- Call all supporting business operations
1085: --
1086: hr_utility.set_location(' Leaving:'||l_proc, 10);

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

1082: hr_utility.set_location('Entering:'||l_proc, 5);
1083: --
1084: -- Call all supporting business operations
1085: --
1086: hr_utility.set_location(' Leaving:'||l_proc, 10);
1087: End delete_validate;
1088:
1089:
1090: --