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 FND_MESSAGE

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

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

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

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

Line 146: fnd_message.raise_error;

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

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

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

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

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

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

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

Line 344: fnd_message.raise_error;

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

Line 419: fnd_message.set_name('OTA', 'OTA_13443_EVT_DURATION_NOT_0');

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

Line 420: fnd_message.raise_error;

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
423: hr_utility.set_location(' Step:'|| l_proc, 60);
424: fnd_message.set_name('OTA', 'OTA_13881_NHS_COMB_INVALID');

Line 424: fnd_message.set_name('OTA', 'OTA_13881_NHS_COMB_INVALID');

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;
428: END IF;

Line 425: 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;
428: END IF;
429: --

Line 489: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');

485: IF hr_api.not_exists_in_hr_lookups
486: (p_effective_date => p_effective_date
487: ,p_lookup_type => 'OTA_DURATION_UNITS'
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:

Line 490: fnd_message.raise_error;

486: (p_effective_date => p_effective_date
487: ,p_lookup_type => 'OTA_DURATION_UNITS'
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;

Line 532: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');

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
531: IF p_duration <= p_notify_days_before_target THEN
532: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
533: fnd_message.raise_error;
534: END IF;
535: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
536: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');

Line 533: fnd_message.raise_error;

529: IF p_duration IS NOT NULL AND p_notify_days_before_target IS NOT NULL THEN
530: -- Modified for Bug#3861864
531: IF p_duration <= p_notify_days_before_target THEN
532: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
533: fnd_message.raise_error;
534: END IF;
535: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
536: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
537: fnd_message.raise_error;

Line 536: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');

532: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
533: fnd_message.raise_error;
534: END IF;
535: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
536: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
537: fnd_message.raise_error;
538: END IF;
539: END IF;
540:

Line 537: fnd_message.raise_error;

533: fnd_message.raise_error;
534: END IF;
535: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
536: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
537: fnd_message.raise_error;
538: END IF;
539: END IF;
540:
541: IF p_notify_days_before_target < 0 THEN

Line 542: fnd_message.set_name('OTA','OTA_443368_POSITIVE_NUMBER');

538: END IF;
539: END IF;
540:
541: IF p_notify_days_before_target < 0 THEN
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);

Line 543: fnd_message.raise_error;

539: END IF;
540:
541: IF p_notify_days_before_target < 0 THEN
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:

Line 602: fnd_message.set_name('OTA','OTA_13176_TPS_PLN_SRC_INVLD');

598: IF hr_api.not_exists_in_hr_lookups
599: (p_effective_date => p_effective_date
600: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
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:

Line 603: fnd_message.raise_error;

599: (p_effective_date => p_effective_date
600: ,p_lookup_type => 'OTA_TRAINING_PLAN_SOURCE'
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;

Line 668: fnd_message.set_name('OTA','OTA_13178_TPM_SRC_FUNC_INVLD');

664: IF hr_api.not_exists_in_hr_lookups
665: (p_effective_date => p_effective_date
666: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
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:

Line 669: fnd_message.raise_error;

665: (p_effective_date => p_effective_date
666: ,p_lookup_type => 'OTA_PLAN_COMPONENT_SOURCE'
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;

Line 733: fnd_message.set_name('OTA','OTA_443411_COMP_UPD_LEV_INVLD');

729: IF hr_api.not_exists_in_hr_lookups
730: (p_effective_date => p_effective_date
731: ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
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:

Line 734: fnd_message.raise_error;

730: (p_effective_date => p_effective_date
731: ,p_lookup_type => 'OTA_COMPETENCY_UPDATE_LEVEL'
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;

Line 866: fnd_message.set_name('OTA', 'OTA_443062_LP_CRS_DTS_INVALID');

862: OPEN csr_lp_course_dates(l_start_date_active, l_end_date_active);
863: FETCH csr_lp_course_dates INTO l_course_id;
864:
865: IF csr_lp_course_dates%FOUND THEN
866: fnd_message.set_name('OTA', 'OTA_443062_LP_CRS_DTS_INVALID');
867: fnd_message.raise_error;
868: CLOSE csr_lp_course_dates;
869: ELSE
870: CLOSE csr_lp_course_dates;

Line 867: fnd_message.raise_error;

863: FETCH csr_lp_course_dates INTO l_course_id;
864:
865: IF csr_lp_course_dates%FOUND THEN
866: fnd_message.set_name('OTA', 'OTA_443062_LP_CRS_DTS_INVALID');
867: fnd_message.raise_error;
868: CLOSE csr_lp_course_dates;
869: ELSE
870: CLOSE csr_lp_course_dates;
871: END IF;

Line 974: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');

970: IF ( l_cat_start_date > l_start_date_active
971: or l_cat_end_date < nvl(l_end_date_active, to_date ('31-12-4712', 'DD-MM-YYYY'))
972: ) THEN
973: --
974: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');
975: fnd_message.raise_error;
976: --
977: End IF;
978: ELSE

Line 975: fnd_message.raise_error;

971: or l_cat_end_date < nvl(l_end_date_active, to_date ('31-12-4712', 'DD-MM-YYYY'))
972: ) THEN
973: --
974: fnd_message.set_name ( 'OTA','OTA_443382_LP_OUT_OF_CAT_DATES');
975: fnd_message.raise_error;
976: --
977: End IF;
978: ELSE
979: CLOSE cur_cat_start_end_date;

Line 1251: fnd_message.set_name('OTA','OTA_13063_LPM_UPD_ERR');

1247: IF l_duration_changed OR
1248: l_duration_units_changed OR
1249: l_start_date_active_changed THEN
1250: IF chk_lp_enrollments_exist(p_learning_path_id => p_rec.learning_path_id) THEN
1251: fnd_message.set_name('OTA','OTA_13063_LPM_UPD_ERR');
1252: fnd_message.raise_error;
1253: END IF;
1254: END IF;
1255: --

Line 1252: fnd_message.raise_error;

1248: l_duration_units_changed OR
1249: l_start_date_active_changed THEN
1250: IF chk_lp_enrollments_exist(p_learning_path_id => p_rec.learning_path_id) THEN
1251: fnd_message.set_name('OTA','OTA_13063_LPM_UPD_ERR');
1252: fnd_message.raise_error;
1253: END IF;
1254: END IF;
1255: --
1256: -- enable dff validation for only Catalog Learning Paths

Line 1290: fnd_message.set_name('OTA','OTA_443383_LP_TP_EXISTS');

1286: IF get_path_source_code(ota_lps_shd.g_old_rec.learning_path_id) = 'CATALOG' THEN
1287:
1288: IF chk_lp_enrollments_exist(
1289: p_learning_path_id => ota_lps_shd.g_old_rec.learning_path_id) THEN
1290: fnd_message.set_name('OTA','OTA_443383_LP_TP_EXISTS');
1291: fnd_message.raise_error;
1292: END IF;
1293:
1294: END IF;

Line 1291: fnd_message.raise_error;

1287:
1288: IF chk_lp_enrollments_exist(
1289: p_learning_path_id => ota_lps_shd.g_old_rec.learning_path_id) THEN
1290: fnd_message.set_name('OTA','OTA_443383_LP_TP_EXISTS');
1291: fnd_message.raise_error;
1292: END IF;
1293:
1294: END IF;
1295: --