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_CRT_BUS dependencies on HR_UTILITY

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

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

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

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

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

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

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

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

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

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

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

152: close csr_leg_code;
153: ota_crt_bus.g_certification_id := p_certification_id;
154: ota_crt_bus.g_legislation_code := l_legislation_code;
155: end if;
156: hr_utility.set_location(' Leaving:'|| l_proc, 40);
157: return l_legislation_code;
158: end return_legislation_code;
159: --
160: -- ----------------------------------------------------------------------------

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

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

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

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

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

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

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

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

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

409: l_renew_flag_changed BOOLEAN;
410:
411: --
412: Begin
413: hr_utility.set_location('Entering:'||l_proc, 5);
414: --
415:
416: OPEN csr_old_cert;
417: FETCH csr_old_cert into l_old_init_compl_date, l_old_init_compl_duration,

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

447: then
448: p_return_status := 'E';
449: end if;
450:
451: hr_utility.set_location(' Leaving:'||l_proc, 10);
452:
453: End chk_should_warn;
454: --
455: --

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

468: BEGIN
469:
470: IF p_renewable_flag = 'Y' AND p_validity_duration is null
471: THEN
472: hr_utility.set_location(' Step:'|| l_proc, 60);
473: fnd_message.set_name('OTA', 'OTA_443778_CERT_VALIDITY_NULL');
474: fnd_message.raise_error;
475: END IF;
476:

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

473: fnd_message.set_name('OTA', 'OTA_443778_CERT_VALIDITY_NULL');
474: fnd_message.raise_error;
475: END IF;
476:
477: hr_utility.set_location(' Leaving:'||l_proc, 90);
478:
479: EXCEPTION
480:
481: WHEN app_exception.application_exception THEN

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

482:
483: IF hr_multi_message.exception_add
484: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.VALIDITY_DURATION') THEN
485:
486: hr_utility.set_location(' Leaving:'||l_proc, 92);
487: RAISE;
488:
489: END IF;
490:

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

487: RAISE;
488:
489: END IF;
490:
491: hr_utility.set_location(' Leaving:'||l_proc, 94);
492:
493: END chk_renewable_cert;
494:
495: -- ----------------------------------------------------------------------------

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

507:
508: IF p_validity_duration is not null AND p_renewal_duration is not null
509: AND p_validity_duration < p_renewal_duration
510: THEN
511: hr_utility.set_location(' Step:'|| l_proc, 60);
512: fnd_message.set_name('OTA', 'OTA_443777_CERT_RENEW');
513: fnd_message.raise_error;
514: END IF;
515:

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

512: fnd_message.set_name('OTA', 'OTA_443777_CERT_RENEW');
513: fnd_message.raise_error;
514: END IF;
515:
516: hr_utility.set_location(' Leaving:'||l_proc, 90);
517:
518: EXCEPTION
519:
520: WHEN app_exception.application_exception THEN

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

521:
522: IF hr_multi_message.exception_add
523: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.VALIDITY_DURATION') THEN
524:
525: hr_utility.set_location(' Leaving:'||l_proc, 92);
526: RAISE;
527:
528: END IF;
529:

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

526: RAISE;
527:
528: END IF;
529:
530: hr_utility.set_location(' Leaving:'||l_proc, 94);
531:
532: END chk_renew_duration;
533:
534: -- ----------------------------------------------------------------------------

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

550: BEGIN
551:
552: IF p_init_compl_date is null AND p_init_compl_duration is null
553: THEN
554: hr_utility.set_location(' Step:'|| l_proc, 60);
555: fnd_message.set_name('OTA', 'OTA_443775_CERT_INIT_COMPL_NUL');
556: fnd_message.raise_error;
557: END IF;
558:

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

557: END IF;
558:
559: IF p_init_compl_date is not null AND p_init_compl_duration is not null
560: THEN
561: hr_utility.set_location(' Step:'|| l_proc, 60);
562: fnd_message.set_name('OTA', 'OTA_443774_CERT_INIT_COMPL');
563: fnd_message.raise_error;
564: END IF;
565:

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

566: if p_init_compl_date is not null
567: then
568: if p_start_date_active > p_init_compl_date
569: then
570: hr_utility.set_location(' Step:'|| l_proc, 60);
571: fnd_message.set_name('OTA', 'OTA_443953_CRT_INIT_COMP_ERROR');
572: fnd_message.raise_error;
573: Elsif p_end_date_active is not null and p_end_date_active < p_init_compl_date
574: then

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

571: fnd_message.set_name('OTA', 'OTA_443953_CRT_INIT_COMP_ERROR');
572: fnd_message.raise_error;
573: Elsif p_end_date_active is not null and p_end_date_active < p_init_compl_date
574: then
575: hr_utility.set_location(' Step:'|| l_proc, 60);
576: fnd_message.set_name('OTA', 'OTA_443953_CRT_INIT_COMP_ERROR');
577: fnd_message.raise_error;
578: end if;
579: end if;

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

584: l_current_year := EXTRACT(YEAR FROM p_effective_date);
585: --l_max_value := (4712 - l_current_year) * 365;
586: if p_init_compl_duration > 9999
587: then
588: hr_utility.set_location(' Step:'|| l_proc, 60);
589: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');
590: fnd_message.set_token('MAX_VALUE', 9999);
591: fnd_message.raise_error;
592: end if;

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

593: end if;
594:
595:
596:
597: hr_utility.set_location(' Leaving:'||l_proc, 90);
598:
599: EXCEPTION
600:
601: WHEN app_exception.application_exception THEN

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

603: IF hr_multi_message.exception_add
604: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_duration'
605: ,p_associated_column2 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN
606:
607: hr_utility.set_location(' Leaving:'||l_proc, 92);
608: RAISE;
609:
610: END IF;
611:

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

608: RAISE;
609:
610: END IF;
611:
612: hr_utility.set_location(' Leaving:'||l_proc, 94);
613:
614: END chk_init_completion;
615:
616: -- ----------------------------------------------------------------------------

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

628: BEGIN
629:
630: IF p_start_date is not null and p_end_date is not null and p_start_date > p_end_date
631: THEN
632: hr_utility.set_location(' Step:'|| l_proc, 60);
633: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');
634: fnd_message.raise_error;
635: END IF;
636:

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

635: END IF;
636:
637: IF p_start_date is not null and p_init_compl_date is not null and p_start_date > p_init_compl_date
638: THEN
639: hr_utility.set_location(' Step:'|| l_proc, 60);
640: fnd_message.set_name('OTA', 'OTA_443771_CERT_INIT_CMPL_DATE');
641: fnd_message.raise_error;
642: END IF;
643:

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

641: fnd_message.raise_error;
642: END IF;
643:
644:
645: hr_utility.set_location(' Leaving:'||l_proc, 90);
646:
647: EXCEPTION
648:
649: WHEN app_exception.application_exception THEN

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

650:
651: IF hr_multi_message.exception_add
652: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.start_date_active') THEN
653:
654: hr_utility.set_location(' Leaving:'||l_proc, 92);
655: RAISE;
656:
657: END IF;
658:

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

655: RAISE;
656:
657: END IF;
658:
659: hr_utility.set_location(' Leaving:'||l_proc, 94);
660:
661: END chk_date_range;
662: -- ----------------------------------------------------------------------------
663: -- |---------------------------< chk_notify_days >-------------------------|

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

680: IF p_notify_days is not null
681: then
682: if p_initial_completion_duration is not null and p_notify_days > p_initial_completion_duration
683: then
684: hr_utility.set_location(' Step:'|| l_proc, 60);
685: fnd_message.set_name('OTA', 'OTA_443957_CRT_NTF_DAY_EXCEEDS');
686: fnd_message.raise_error;
687: elsif p_initial_completion_date is not null
688: then

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

702: end if;
703:
704: if p_notify_days > l_max_value
705: then
706: hr_utility.set_location(' Step:'|| l_proc, 60);
707: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');
708: fnd_message.set_token('MAX_VALUE', l_max_value);
709: fnd_message.raise_error;
710: end if;

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

711: end if;
712:
713: end if;
714:
715: hr_utility.set_location(' Leaving:'||l_proc, 90);
716:
717: EXCEPTION
718:
719: WHEN app_exception.application_exception THEN

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

720:
721: IF hr_multi_message.exception_add
722: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.notify_days_before_expire') THEN
723:
724: hr_utility.set_location(' Leaving:'||l_proc, 92);
725: RAISE;
726:
727: END IF;
728:

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

725: RAISE;
726:
727: END IF;
728:
729: hr_utility.set_location(' Leaving:'||l_proc, 94);
730:
731: END chk_notify_days;
732:
733: -- ----------------------------------------------------------------------------

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

748: -- IF p_init_compl_date is not null and p_init_compl_date < sysdate
749: -- IF p_init_compl_date is not null and p_init_compl_date < trunc(sysdate)
750: IF p_init_compl_date is not null and p_init_compl_date < trunc(p_effective_date)
751: THEN
752: hr_utility.set_location(' Step:'|| l_proc, 60);
753: fnd_message.set_name('OTA', 'OTA_443771_CERT_INIT_CMPL_DATE');
754: fnd_message.raise_error;
755: END IF;
756:

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

753: fnd_message.set_name('OTA', 'OTA_443771_CERT_INIT_CMPL_DATE');
754: fnd_message.raise_error;
755: END IF;
756:
757: hr_utility.set_location(' Leaving:'||l_proc, 90);
758:
759: EXCEPTION
760:
761: WHEN app_exception.application_exception THEN

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

762:
763: IF hr_multi_message.exception_add
764: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.initial_completion_date') THEN
765:
766: hr_utility.set_location(' Leaving:'||l_proc, 92);
767: RAISE;
768:
769: END IF;
770:

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

767: RAISE;
768:
769: END IF;
770:
771: hr_utility.set_location(' Leaving:'||l_proc, 94);
772:
773: END chk_init_compl_date;
774:
775: -- ----------------------------------------------------------------------------

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

785: BEGIN
786:
787: IF p_validity_duration is not null and p_validity_duration > 9999
788: THEN
789: hr_utility.set_location(' Step:'|| l_proc, 60);
790: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');
791: fnd_message.set_token('MAX_VALUE', 9999);
792: fnd_message.raise_error;
793: END IF;

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

791: fnd_message.set_token('MAX_VALUE', 9999);
792: fnd_message.raise_error;
793: END IF;
794:
795: hr_utility.set_location(' Leaving:'||l_proc, 90);
796:
797: EXCEPTION
798:
799: WHEN app_exception.application_exception THEN

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

800:
801: IF hr_multi_message.exception_add
802: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_duration') THEN
803:
804: hr_utility.set_location(' Leaving:'||l_proc, 92);
805: RAISE;
806:
807: END IF;
808:

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

805: RAISE;
806:
807: END IF;
808:
809: hr_utility.set_location(' Leaving:'||l_proc, 94);
810:
811: END chk_validity_duration;
812: -- ----------------------------------------------------------------------------
813: -- |---------------------------< chk_date_based_cert >-------------------------|

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

826:
827: IF p_init_compl_date is not null and p_renewable_flag = 'Y'
828: and p_renewal_duration is null
829: THEN
830: hr_utility.set_location(' Step:'|| l_proc, 60);
831: fnd_message.set_name('OTA', 'OTA_443772_CERT_DATE_BASED');
832: fnd_message.raise_error;
833: END IF;
834:

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

834:
835: IF p_init_compl_date is not null AND p_renewable_flag = 'Y'
836: and p_validity_start_type = 'A'
837: THEN
838: hr_utility.set_location(' Step:'|| l_proc, 60);
839: fnd_message.set_name('OTA', 'OTA_443773_CERT_VALIDITY_START');
840: fnd_message.raise_error;
841: END IF;
842: hr_utility.set_location(' Leaving:'||l_proc, 90);

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

838: hr_utility.set_location(' Step:'|| l_proc, 60);
839: fnd_message.set_name('OTA', 'OTA_443773_CERT_VALIDITY_START');
840: fnd_message.raise_error;
841: END IF;
842: hr_utility.set_location(' Leaving:'||l_proc, 90);
843:
844: EXCEPTION
845:
846: WHEN app_exception.application_exception THEN

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

847:
848: IF hr_multi_message.exception_add
849: (p_associated_column1 => 'OTA_CERTIFICATIONS_B.validity_start_type') THEN
850:
851: hr_utility.set_location(' Leaving:'||l_proc, 92);
852: RAISE;
853:
854: END IF;
855:

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

852: RAISE;
853:
854: END IF;
855:
856: hr_utility.set_location(' Leaving:'||l_proc, 94);
857:
858: END chk_date_based_cert;
859: --
860: -- ----------------------------------------------------------------------------

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

881: where cre.certification_id = p_certification_id;
882: --
883: Begin
884:
885: hr_utility.set_location('Entering:'|| l_proc, 10);
886:
887: Open sel_enr_exists;
888: fetch sel_enr_exists into l_exists;
889:

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

888: fetch sel_enr_exists into l_exists;
889:
890: if sel_enr_exists%found then
891: close sel_enr_exists;
892: hr_utility.set_location(' Step:'|| l_proc, 20);
893: fnd_message.set_name('OTA', 'OTA_443762_CERT_ENROLL_EXISTS');
894: fnd_message.raise_error;
895: else
896: close sel_enr_exists;

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

895: else
896: close sel_enr_exists;
897: end if;
898:
899: hr_utility.set_location(' Leaving:'|| l_proc, 30);
900: --
901: End chk_enr_exists;
902:
903: -- ----------------------------------------------------------------------------

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

922: --
923: --
924: Begin
925:
926: hr_utility.set_location('Entering:'|| l_proc, 10);
927:
928: select min(cre.enrollment_date), max(cre.enrollment_date)
929: into l_min_date, l_max_date
930: from ota_cert_enrollments cre

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

932:
933: if ((l_min_date is not null and l_min_date < p_start_date_active)
934: or (l_max_date is not null and p_end_date_active is not null and l_max_date > p_end_date_active))
935: then
936: hr_utility.set_location(' Step:'|| l_proc, 20);
937: fnd_message.set_name('OTA', 'OTA_443960_CRT_ENRL_DATE_INVAL');
938: fnd_message.raise_error;
939: end if;
940:

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

937: fnd_message.set_name('OTA', 'OTA_443960_CRT_ENRL_DATE_INVAL');
938: fnd_message.raise_error;
939: end if;
940:
941: hr_utility.set_location(' Leaving:'|| l_proc, 30);
942:
943: Exception
944: when app_exception.application_exception then
945: IF hr_multi_message.exception_add

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

1018: fnd_message.raise_error;
1019: end if;
1020: end if;
1021: --
1022: hr_utility.set_location(' Leaving:' || l_proc,10);
1023:
1024: Exception
1025: when app_exception.application_exception then
1026: IF hr_multi_message.exception_add

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

1059: l_renew_flag_changed BOOLEAN;
1060: l_notify_days_changed BOOLEAN;
1061:
1062: Begin
1063: hr_utility.set_location('Entering:'||l_proc, 5);
1064: --
1065: --Bug 4637071 chk for exist subscr and process
1066: OPEN csr_exis_subscr;
1067: FETCH csr_exis_subscr into l_subscr_exists;

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

1087: fnd_message.raise_error;
1088: end if;
1089: end if;
1090:
1091: hr_utility.set_location(' Leaving:'||l_proc, 10);
1092:
1093: EXCEPTION
1094: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1095:

Line 1098: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 15);

1094: WHEN APP_EXCEPTION.APPLICATION_EXCEPTION THEN
1095:
1096: IF HR_MULTI_MESSAGE.EXCEPTION_ADD
1097: (P_ASSOCIATED_COLUMN1 => null) THEN
1098: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 15);
1099: RAISE;
1100: END IF;
1101:
1102: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 20);

Line 1102: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 20);

1098: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 15);
1099: RAISE;
1100: END IF;
1101:
1102: HR_UTILITY.SET_LOCATION(' LEAVING:'||L_PROC, 20);
1103:
1104: End chk_upd_exis_subscr;
1105:
1106: --

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

1143: l_cat_end_date date;
1144:
1145:
1146: Begin
1147: hr_utility.set_location(' Entering:' || l_proc,10);
1148: --
1149: IF hr_multi_message.no_exclusive_error
1150: (p_check_column1 => 'OTA_CERTIFICATIONS.START_DATE_ACTIVE'
1151: ,p_check_column2 => 'OTA_CERTIFICATIONS.END_DATE_ACTIVE'

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

1172:
1173: End IF;
1174: End IF;
1175: --
1176: hr_utility.set_location(' Leaving:' || l_proc,10);
1177: Exception
1178: when app_exception.application_exception then
1179: IF hr_multi_message.exception_add
1180: (p_associated_column1 => 'OTA_CERTIFICATIONS.START_DATE_ACTIVE'

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

1179: IF hr_multi_message.exception_add
1180: (p_associated_column1 => 'OTA_CERTIFICATIONS.START_DATE_ACTIVE'
1181: ,p_associated_column2 => 'OTA_CERTIFICATIONS.END_DATE_ACTIVE'
1182: ) THEN
1183: hr_utility.set_location(' Leaving:'|| l_proc,20);
1184: raise;
1185: END IF;
1186:
1187: hr_utility.set_location(' Leaving:'|| l_proc,30);

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

1183: hr_utility.set_location(' Leaving:'|| l_proc,20);
1184: raise;
1185: END IF;
1186:
1187: hr_utility.set_location(' Leaving:'|| l_proc,30);
1188: --
1189: End chk_category_start_end_dates;
1190:
1191: --

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

1200: --
1201: l_proc varchar2(72) := g_package||'insert_validate';
1202: --
1203: Begin
1204: hr_utility.set_location('Entering:'||l_proc, 5);
1205: --
1206: -- Call all supporting business operations
1207: --
1208: hr_api.validate_bus_grp_id

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

1275: --
1276: hr_multi_message.end_validation_set;
1277: --
1278: --
1279: hr_utility.set_location(' Leaving:'||l_proc, 10);
1280: End insert_validate;
1281: --
1282: -- ----------------------------------------------------------------------------
1283: -- |---------------------------< update_validate >----------------------------|

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

1289: --
1290: l_proc varchar2(72) := g_package||'update_validate';
1291: --
1292: Begin
1293: hr_utility.set_location('Entering:'||l_proc, 5);
1294: --
1295: -- Call all supporting business operations
1296: --
1297: hr_api.validate_bus_grp_id

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

1384: ota_crt_bus.chk_df(p_rec);
1385: --
1386: hr_multi_message.end_validation_set;
1387: --
1388: hr_utility.set_location(' Leaving:'||l_proc, 10);
1389: End update_validate;
1390: --
1391: -- ----------------------------------------------------------------------------
1392: -- |---------------------------< delete_validate >----------------------------|

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

1397: --
1398: l_proc varchar2(72) := g_package||'delete_validate';
1399: --
1400: Begin
1401: hr_utility.set_location('Entering:'||l_proc, 5);
1402: --
1403: -- Call all supporting business operations
1404: chk_enr_exists(p_certification_id => p_rec.certification_id);
1405: --

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

1402: --
1403: -- Call all supporting business operations
1404: chk_enr_exists(p_certification_id => p_rec.certification_id);
1405: --
1406: hr_utility.set_location(' Leaving:'||l_proc, 10);
1407: End delete_validate;
1408: --
1409: end ota_crt_bus;