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_CRE_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,'CERT_ENROLLMENT_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_cre_shd.api_updating
337: (p_cert_enrollment_id => p_rec.cert_enrollment_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_cert_enrollment_id => p_rec.cert_enrollment_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: -- Add checks to ensure non-updateable args have

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

Line 365: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');

361: Begin
362: hr_utility.set_location('Entering:'||l_proc, 5);
363: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
364: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
365: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
366: fnd_message.raise_error;
367: END IF;
368: hr_utility.set_location('Leaving:'||l_proc, 10);
369: End chk_person_contact;

Line 366: fnd_message.raise_error;

362: hr_utility.set_location('Entering:'||l_proc, 5);
363: IF ( p_person_id IS NULL AND p_contact_id IS NULL) OR
364: ( p_person_id IS NOT NULL AND p_contact_id IS NOT NULL) THEN
365: fnd_message.set_name('OTA', 'OTA_13077_TPE_PRSN_OR_CNTCT');
366: fnd_message.raise_error;
367: END IF;
368: hr_utility.set_location('Leaving:'||l_proc, 10);
369: End chk_person_contact;
370:

Line 397: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');

393: FETCH csr_person_id INTO l_exists;
394: IF csr_person_id%NOTFOUND THEN
395: CLOSE csr_person_id;
396: hr_utility.set_location(' Step:'|| l_proc, 40);
397: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
398: fnd_message.raise_error;
399: ELSE
400: CLOSE csr_person_id;
401: END IF;

Line 398: fnd_message.raise_error;

394: IF csr_person_id%NOTFOUND THEN
395: CLOSE csr_person_id;
396: hr_utility.set_location(' Step:'|| l_proc, 40);
397: fnd_message.set_name('OTA', 'OTA_13884_NHS_PERSON_INVALID');
398: fnd_message.raise_error;
399: ELSE
400: CLOSE csr_person_id;
401: END IF;
402: END IF;

Line 450: fnd_message.set_name('OTA', 'OTA_443665_CRE_STAT_INVALID');

446: ,p_lookup_type => 'OTA_CERT_ENROLL_STATUS'
447: ,p_lookup_code => p_certification_status_code
448: ) THEN
449: -- Error, lookup not available
450: fnd_message.set_name('OTA', 'OTA_443665_CRE_STAT_INVALID');
451: fnd_message.raise_error;
452: END IF;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 30);

Line 451: fnd_message.raise_error;

447: ,p_lookup_code => p_certification_status_code
448: ) THEN
449: -- Error, lookup not available
450: fnd_message.set_name('OTA', 'OTA_443665_CRE_STAT_INVALID');
451: fnd_message.raise_error;
452: END IF;
453: --
454: hr_utility.set_location(' Leaving:'||l_proc, 30);
455:

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

508: FETCH csr_cert_prd_enr_id INTO l_exists;
509: IF csr_cert_prd_enr_id%FOUND THEN
510: CLOSE csr_cert_prd_enr_id;
511: hr_utility.set_location(' Step:'|| l_proc, 20);
512: fnd_message.set_name('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
513: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Certification Period Enrollment');
514: fnd_message.raise_error;
515: ELSE
516: CLOSE csr_cert_prd_enr_id;

Line 513: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Certification Period Enrollment');

509: IF csr_cert_prd_enr_id%FOUND THEN
510: CLOSE csr_cert_prd_enr_id;
511: hr_utility.set_location(' Step:'|| l_proc, 20);
512: fnd_message.set_name('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
513: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Certification Period Enrollment');
514: fnd_message.raise_error;
515: ELSE
516: CLOSE csr_cert_prd_enr_id;
517: END IF;

Line 514: fnd_message.raise_error;

510: CLOSE csr_cert_prd_enr_id;
511: hr_utility.set_location(' Step:'|| l_proc, 20);
512: fnd_message.set_name('OTA', 'OTA_443818_NO_DEL_HAS_CHILD');
513: FND_MESSAGE.SET_TOKEN ('ENTITY_NAME', 'Certification Period Enrollment');
514: fnd_message.raise_error;
515: ELSE
516: CLOSE csr_cert_prd_enr_id;
517: END IF;
518:

Line 525: fnd_message.set_name('OTA', 'OTA_443920_CRT_NO_DEL_APV_WAIT');

521: IF csr_cert_enr_status%FOUND THEN
522: CLOSE csr_cert_enr_status;
523: IF l_cert_enroll_status= 'AWAITING_APPROVAL' then
524: hr_utility.set_location(' Step:'|| l_proc, 30);
525: fnd_message.set_name('OTA', 'OTA_443920_CRT_NO_DEL_APV_WAIT');
526: fnd_message.raise_error;
527: END IF;
528: ELSE
529: CLOSE csr_cert_enr_status;

Line 526: fnd_message.raise_error;

522: CLOSE csr_cert_enr_status;
523: IF l_cert_enroll_status= 'AWAITING_APPROVAL' then
524: hr_utility.set_location(' Step:'|| l_proc, 30);
525: fnd_message.set_name('OTA', 'OTA_443920_CRT_NO_DEL_APV_WAIT');
526: fnd_message.raise_error;
527: END IF;
528: ELSE
529: CLOSE csr_cert_enr_status;
530: END IF;

Line 598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');

594: ,p_customer_id => NULL
595: ,p_contact_id => p_contact_id);
596:
597: hr_utility.set_location(' Step:'|| l_proc, 10);
598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
599: fnd_message.set_token('LEARNER_NAME', l_person_name);
600: fnd_message.set_token('OBJECT_TYPE', l_object_type);
601: fnd_message.raise_error;
602: ELSE

Line 599: fnd_message.set_token('LEARNER_NAME', l_person_name);

595: ,p_contact_id => p_contact_id);
596:
597: hr_utility.set_location(' Step:'|| l_proc, 10);
598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
599: fnd_message.set_token('LEARNER_NAME', l_person_name);
600: fnd_message.set_token('OBJECT_TYPE', l_object_type);
601: fnd_message.raise_error;
602: ELSE
603: CLOSE csr_cert_enr_id;

Line 600: fnd_message.set_token('OBJECT_TYPE', l_object_type);

596:
597: hr_utility.set_location(' Step:'|| l_proc, 10);
598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
599: fnd_message.set_token('LEARNER_NAME', l_person_name);
600: fnd_message.set_token('OBJECT_TYPE', l_object_type);
601: fnd_message.raise_error;
602: ELSE
603: CLOSE csr_cert_enr_id;
604: END IF;

Line 601: fnd_message.raise_error;

597: hr_utility.set_location(' Step:'|| l_proc, 10);
598: fnd_message.set_name('OTA', 'OTA_443908_LRNR_DUPL_SUBSC_ERR');
599: fnd_message.set_token('LEARNER_NAME', l_person_name);
600: fnd_message.set_token('OBJECT_TYPE', l_object_type);
601: fnd_message.raise_error;
602: ELSE
603: CLOSE csr_cert_enr_id;
604: END IF;
605:

Line 655: fnd_message.set_name('OTA', 'OTA_443958_CRT_DUE_DATE_PASSED');

651:
652: if (rec_crt.initial_completion_date is not null and trunc(sysdate) > rec_crt.initial_completion_date) then
653: --throw error for subscriptions beyond the due date.
654: hr_utility.set_location(' Step:'|| l_proc, 20);
655: fnd_message.set_name('OTA', 'OTA_443958_CRT_DUE_DATE_PASSED');
656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);
657: fnd_message.raise_error;
658: end if;
659:

Line 656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);

652: if (rec_crt.initial_completion_date is not null and trunc(sysdate) > rec_crt.initial_completion_date) then
653: --throw error for subscriptions beyond the due date.
654: hr_utility.set_location(' Step:'|| l_proc, 20);
655: fnd_message.set_name('OTA', 'OTA_443958_CRT_DUE_DATE_PASSED');
656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);
657: fnd_message.raise_error;
658: end if;
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 657: fnd_message.raise_error;

653: --throw error for subscriptions beyond the due date.
654: hr_utility.set_location(' Step:'|| l_proc, 20);
655: fnd_message.set_name('OTA', 'OTA_443958_CRT_DUE_DATE_PASSED');
656: FND_MESSAGE.SET_TOKEN ('DUE_DATE', rec_crt.INITIAL_COMPLETION_DATE);
657: fnd_message.raise_error;
658: end if;
659:
660: hr_utility.set_location(' Leaving:'||l_proc, 20);
661: