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 FND_MESSAGE

Line 63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

59: close csr_sec_grp;
60: --
61: -- The primary key is invalid therefore we must error
62: --
63: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
64: hr_multi_message.add
65: (p_associated_column1
66: => nvl(p_associated_column1,'CERTIFICATION_ID')
67: );

Line 144: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

140: --
141: -- The primary key is invalid therefore we must error
142: --
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: --

Line 145: fnd_message.raise_error;

141: -- The primary key is invalid therefore we must error
142: --
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

Line 340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

336: IF NOT ota_crt_shd.api_updating
337: (p_certification_id => p_rec.certification_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;

Line 341: fnd_message.set_token('PROCEDURE ', l_proc);

337: (p_certification_id => p_rec.certification_id
338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
342: fnd_message.set_token('STEP ', '5');
343: fnd_message.raise_error;
344: END IF;
345: --

Line 342: fnd_message.set_token('STEP ', '5');

338: ,p_object_version_number => p_rec.object_version_number
339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
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);

Line 343: fnd_message.raise_error;

339: ) THEN
340: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
341: fnd_message.set_token('PROCEDURE ', l_proc);
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) <>

Line 473: fnd_message.set_name('OTA', 'OTA_443778_CERT_VALIDITY_NULL');

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:
477: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 474: fnd_message.raise_error;

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:
477: hr_utility.set_location(' Leaving:'||l_proc, 90);
478:

Line 512: fnd_message.set_name('OTA', 'OTA_443777_CERT_RENEW');

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:
516: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 513: fnd_message.raise_error;

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:
516: hr_utility.set_location(' Leaving:'||l_proc, 90);
517:

Line 555: fnd_message.set_name('OTA', 'OTA_443775_CERT_INIT_COMPL_NUL');

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:
559: IF p_init_compl_date is not null AND p_init_compl_duration is not null

Line 556: fnd_message.raise_error;

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:
559: IF p_init_compl_date is not null AND p_init_compl_duration is not null
560: THEN

Line 562: fnd_message.set_name('OTA', 'OTA_443774_CERT_INIT_COMPL');

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:
566: if p_init_compl_date is not null

Line 563: fnd_message.raise_error;

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:
566: if p_init_compl_date is not null
567: then

Line 571: fnd_message.set_name('OTA', 'OTA_443953_CRT_INIT_COMP_ERROR');

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
575: hr_utility.set_location(' Step:'|| l_proc, 60);

Line 572: fnd_message.raise_error;

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
575: hr_utility.set_location(' Step:'|| l_proc, 60);
576: fnd_message.set_name('OTA', 'OTA_443953_CRT_INIT_COMP_ERROR');

Line 576: 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;
580:

Line 577: 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;
580:
581: if p_init_compl_duration is not null

Line 589: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');

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;
593: end if;

Line 590: fnd_message.set_token('MAX_VALUE', 9999);

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;
593: end if;
594:

Line 591: fnd_message.raise_error;

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;
593: end if;
594:
595:

Line 633: fnd_message.set_name('OTA', 'OTA_13312_GEN_DATE_ORDER');

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:
637: IF p_start_date is not null and p_init_compl_date is not null and p_start_date > p_init_compl_date

Line 634: fnd_message.raise_error;

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:
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

Line 640: fnd_message.set_name('OTA', 'OTA_443771_CERT_INIT_CMPL_DATE');

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:
644:

Line 641: fnd_message.raise_error;

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:
644:
645: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 685: fnd_message.set_name('OTA', 'OTA_443957_CRT_NTF_DAY_EXCEEDS');

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
689: if p_initial_completion_date >= trunc(p_effective_date) then

Line 686: fnd_message.raise_error;

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
689: if p_initial_completion_date >= trunc(p_effective_date) then
690: l_max_value := trunc(p_initial_completion_date - p_effective_date);

Line 707: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');

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;
711: end if;

Line 708: fnd_message.set_token('MAX_VALUE', l_max_value);

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;
711: end if;
712:

Line 709: fnd_message.raise_error;

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;
711: end if;
712:
713: end if;

Line 753: fnd_message.set_name('OTA', 'OTA_443771_CERT_INIT_CMPL_DATE');

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:
757: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 754: fnd_message.raise_error;

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:
757: hr_utility.set_location(' Leaving:'||l_proc, 90);
758:

Line 790: fnd_message.set_name('OTA', 'OTA_443956_EXCEED_MAX_VALUE');

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;
794:

Line 791: fnd_message.set_token('MAX_VALUE', 9999);

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;
794:
795: hr_utility.set_location(' Leaving:'||l_proc, 90);

Line 792: fnd_message.raise_error;

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;
794:
795: hr_utility.set_location(' Leaving:'||l_proc, 90);
796:

Line 831: fnd_message.set_name('OTA', 'OTA_443772_CERT_DATE_BASED');

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:
835: IF p_init_compl_date is not null AND p_renewable_flag = 'Y'

Line 832: fnd_message.raise_error;

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:
835: IF p_init_compl_date is not null AND p_renewable_flag = 'Y'
836: and p_validity_start_type = 'A'

Line 839: fnd_message.set_name('OTA', 'OTA_443773_CERT_VALIDITY_START');

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);
843:

Line 840: fnd_message.raise_error;

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);
843:
844: EXCEPTION

Line 893: fnd_message.set_name('OTA', 'OTA_443762_CERT_ENROLL_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;
897: end if;

Line 894: fnd_message.raise_error;

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;
897: end if;
898:

Line 937: fnd_message.set_name('OTA', 'OTA_443960_CRT_ENRL_DATE_INVAL');

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:
941: hr_utility.set_location(' Leaving:'|| l_proc, 30);

Line 938: fnd_message.raise_error;

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:
941: hr_utility.set_location(' Leaving:'|| l_proc, 30);
942:

Line 1017: fnd_message.set_name('OTA','OTA_443936_CRT_DATE_OUT_OF_CMB');

1013: l_earliest_start_date > l_cert_end_date or
1014: l_latest_end_date > l_cert_end_date or
1015: l_latest_end_date < l_cert_start_date then
1016:
1017: fnd_message.set_name('OTA','OTA_443936_CRT_DATE_OUT_OF_CMB');
1018: fnd_message.raise_error;
1019: end if;
1020: end if;
1021: --

Line 1018: fnd_message.raise_error;

1014: l_latest_end_date > l_cert_end_date or
1015: l_latest_end_date < l_cert_start_date then
1016:
1017: fnd_message.set_name('OTA','OTA_443936_CRT_DATE_OUT_OF_CMB');
1018: fnd_message.raise_error;
1019: end if;
1020: end if;
1021: --
1022: hr_utility.set_location(' Leaving:' || l_proc,10);

Line 1086: fnd_message.set_name('OTA', 'OTA_443962_CRT_NO_UPD_EXIS_SUB');

1082:
1083: if l_init_compl_date_changed OR l_init_compl_dur_changed
1084: OR l_renew_flag_changed OR l_notify_days_changed
1085: then
1086: fnd_message.set_name('OTA', 'OTA_443962_CRT_NO_UPD_EXIS_SUB');
1087: fnd_message.raise_error;
1088: end if;
1089: end if;
1090:

Line 1087: fnd_message.raise_error;

1083: if l_init_compl_date_changed OR l_init_compl_dur_changed
1084: OR l_renew_flag_changed OR l_notify_days_changed
1085: then
1086: fnd_message.set_name('OTA', 'OTA_443962_CRT_NO_UPD_EXIS_SUB');
1087: fnd_message.raise_error;
1088: end if;
1089: end if;
1090:
1091: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 1166: fnd_message.set_name ( 'OTA','OTA_443896_CRT_OUT_OF_CAT_DATE');

1162: IF ( l_cat_start_date > p_start_date
1163: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
1164: ) THEN
1165: --
1166: fnd_message.set_name ( 'OTA','OTA_443896_CRT_OUT_OF_CAT_DATE');
1167: fnd_message.raise_error;
1168: --
1169: End IF;
1170: ELSE

Line 1167: fnd_message.raise_error;

1163: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
1164: ) THEN
1165: --
1166: fnd_message.set_name ( 'OTA','OTA_443896_CRT_OUT_OF_CAT_DATE');
1167: fnd_message.raise_error;
1168: --
1169: End IF;
1170: ELSE
1171: CLOSE csr_cat_start_end_date;