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 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_MEMBER_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_lpm_shd.api_updating
338: (p_learning_path_member_id => p_rec.learning_path_member_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_member_id => p_rec.learning_path_member_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: -- EDIT_HERE: Add checks to ensure non-updateable args have

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: -- EDIT_HERE: Add checks to ensure non-updateable args have
348: -- not been updated.

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

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
407: IF p_duration <= p_notify_days_before_target THEN
408: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
409: fnd_message.raise_error;
410: END IF;
411: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
412: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');

Line 409: fnd_message.raise_error;

405: IF p_duration IS NOT NULL AND p_notify_days_before_target IS NOT NULL THEN
406: --Modified for Bug#3861864
407: IF p_duration <= p_notify_days_before_target THEN
408: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
409: fnd_message.raise_error;
410: END IF;
411: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
412: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
413: fnd_message.raise_error;

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

408: fnd_message.set_name('OTA','OTA_13079_LPS_NOTIFY_TARGET');
409: fnd_message.raise_error;
410: END IF;
411: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
412: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
413: fnd_message.raise_error;
414: END IF;
415: END IF;
416:

Line 413: fnd_message.raise_error;

409: fnd_message.raise_error;
410: END IF;
411: ELSIF p_duration IS NULL and p_notify_days_before_target IS NOT NULL THEN
412: fnd_message.set_name('OTA','OTA_13083_LP_CT_NOT_ERR');
413: fnd_message.raise_error;
414: END IF;
415: END IF;
416:
417: IF p_notify_days_before_target < 0 THEN

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

414: END IF;
415: END IF;
416:
417: IF p_notify_days_before_target < 0 THEN
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);

Line 419: fnd_message.raise_error;

415: END IF;
416:
417: IF p_notify_days_before_target < 0 THEN
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:

Line 503: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');

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;
503: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
504: fnd_message.raise_error;
505: ELSE
506: IF l_business_group_id <> p_business_group_id THEN
507: CLOSE csr_activity_version_id;

Line 504: fnd_message.raise_error;

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;
503: fnd_message.set_name('OTA', 'OTA_13850_TPM_BAD_ACT_VER');
504: fnd_message.raise_error;
505: ELSE
506: IF l_business_group_id <> p_business_group_id THEN
507: CLOSE csr_activity_version_id;
508: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');

Line 508: fnd_message.set_name('OTA', 'OTA_13851_TPM_WRONG_ACT_VER');

504: fnd_message.raise_error;
505: ELSE
506: IF l_business_group_id <> p_business_group_id THEN
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;

Line 509: fnd_message.raise_error;

505: ELSE
506: IF l_business_group_id <> p_business_group_id THEN
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;

Line 582: fnd_message.set_name('OTA', 'OTA_13605_LPM_NO_LEARNING_PATH');

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);
586: CLOSE csr_learning_path_id;

Line 583: fnd_message.raise_error;

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);
586: CLOSE csr_learning_path_id;
587: END IF;

Line 668: fnd_message.set_name('OTA', 'OTA_13620_LPM_NOT_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;
672: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 669: fnd_message.raise_error;

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;
672: hr_utility.set_location(' Step:'|| l_proc, 70);
673: END IF;

Line 757: fnd_message.set_name('OTA', 'OTA_13844_TPM_NOT_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;
761: hr_utility.set_location(' Step:'|| l_proc, 70);

Line 758: fnd_message.raise_error;

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;
761: hr_utility.set_location(' Step:'|| l_proc, 70);
762: END IF;

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

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

Line 837: fnd_message.raise_error;

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

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

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

Line 842: 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;
845: END IF;
846: --

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

902: IF hr_api.not_exists_in_hr_lookups
903: (p_effective_date => p_effective_date
904: ,p_lookup_type => 'OTA_DURATION_UNITS'
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:

Line 907: fnd_message.raise_error;

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