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_NHS_BUS dependencies on FND_MESSAGE

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

50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;

Line 55: fnd_message.raise_error;

51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --

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

124: --
125: -- The primary key is invalid therefore we must error
126: --
127: close csr_leg_code;
128: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
129: fnd_message.raise_error;
130: end if;
131: hr_utility.set_location(l_proc,30);
132: --

Line 129: fnd_message.raise_error;

125: -- The primary key is invalid therefore we must error
126: --
127: close csr_leg_code;
128: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
129: fnd_message.raise_error;
130: end if;
131: hr_utility.set_location(l_proc,30);
132: --
133: -- Set the global variables so the values are

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

324: IF NOT ota_nhs_shd.api_updating
325: (p_nota_history_id => p_rec.nota_history_id
326: ,p_object_version_number => p_rec.object_version_number
327: ) THEN
328: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
329: fnd_message.set_token('PROCEDURE ', l_proc);
330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;

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

325: (p_nota_history_id => p_rec.nota_history_id
326: ,p_object_version_number => p_rec.object_version_number
327: ) THEN
328: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
329: fnd_message.set_token('PROCEDURE ', l_proc);
330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;
333:

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

326: ,p_object_version_number => p_rec.object_version_number
327: ) THEN
328: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
329: fnd_message.set_token('PROCEDURE ', l_proc);
330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>

Line 331: fnd_message.raise_error;

327: ) THEN
328: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
329: fnd_message.set_token('PROCEDURE ', l_proc);
330: fnd_message.set_token('STEP ', '5');
331: fnd_message.raise_error;
332: END IF;
333:
334: if nvl(p_rec.business_group_id,hr_api.g_number) <>
335: nvl(ota_nhs_shd.g_old_rec.business_group_id,hr_api.g_number)

Line 417: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');

413: open csr_organization_cross;
414: fetch csr_organization_cross into l_exists;
415: if csr_organization_cross%notfound then
416: close csr_organization_cross;
417: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
418: fnd_message.raise_error;
419: end if;
420: close csr_organization_cross;
421: hr_utility.set_location('Entering:'||l_proc, 20);

Line 418: fnd_message.raise_error;

414: fetch csr_organization_cross into l_exists;
415: if csr_organization_cross%notfound then
416: close csr_organization_cross;
417: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
418: fnd_message.raise_error;
419: end if;
420: close csr_organization_cross;
421: hr_utility.set_location('Entering:'||l_proc, 20);
422:

Line 428: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');

424: open csr_organization;
425: fetch csr_organization into l_exists;
426: if csr_organization%notfound then
427: close csr_organization;
428: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
429: fnd_message.raise_error;
430: end if;
431: close csr_organization;
432: hr_utility.set_location('Entering:'||l_proc, 25);

Line 429: fnd_message.raise_error;

425: fetch csr_organization into l_exists;
426: if csr_organization%notfound then
427: close csr_organization;
428: fnd_message.set_name('OTA','OTA_13268_TFH_INVALID_ORG');
429: fnd_message.raise_error;
430: end if;
431: close csr_organization;
432: hr_utility.set_location('Entering:'||l_proc, 25);
433: end if;

Line 477: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');

473: open csr_customer;
474: fetch csr_customer into l_exists;
475: if csr_customer%notfound then
476: close csr_customer;
477: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');
478: fnd_message.raise_error;
479: end if;
480: close csr_customer;
481: hr_utility.set_location('Entering:'||l_proc, 20);

Line 478: fnd_message.raise_error;

474: fetch csr_customer into l_exists;
475: if csr_customer%notfound then
476: close csr_customer;
477: fnd_message.set_name('OTA','OTA_13321_TFH_CUSTOMER_NAME');
478: fnd_message.raise_error;
479: end if;
480: close csr_customer;
481: hr_utility.set_location('Entering:'||l_proc, 20);
482: end if;

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

557: --
558: hr_utility.set_location('Entering:'||l_proc, 10);
559: if p_person_id is not null then
560: if p_customer_id is null and p_organization_id is null then
561: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
562: fnd_message.raise_error;
563: end if;
564: end if;
565: if (p_customer_id is not null) then

Line 562: fnd_message.raise_error;

558: hr_utility.set_location('Entering:'||l_proc, 10);
559: if p_person_id is not null then
560: if p_customer_id is null and p_organization_id is null then
561: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
562: fnd_message.raise_error;
563: end if;
564: end if;
565: if (p_customer_id is not null) then
566: if p_person_id is not null then

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

568: open cus_contact;
569: fetch cus_contact into l_exists;
570: if cus_contact%notfound then
571: close cus_contact;
572: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
573: fnd_message.raise_error;
574: end if;
575: close cus_contact;
576: hr_utility.set_location('Entering:'||l_proc, 20);

Line 573: fnd_message.raise_error;

569: fetch cus_contact into l_exists;
570: if cus_contact%notfound then
571: close cus_contact;
572: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
573: fnd_message.raise_error;
574: end if;
575: close cus_contact;
576: hr_utility.set_location('Entering:'||l_proc, 20);
577: end if;

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

582: open org_person_cross;
583: fetch org_person_cross into l_exists;
584: if org_person_cross%notfound then
585: close org_person_cross;
586: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
587: fnd_message.raise_error;
588: end if;
589: close org_person_cross;
590:

Line 587: fnd_message.raise_error;

583: fetch org_person_cross into l_exists;
584: if org_person_cross%notfound then
585: close org_person_cross;
586: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
587: fnd_message.raise_error;
588: end if;
589: close org_person_cross;
590:
591: else

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

592: open org_person;
593: fetch org_person into l_exists;
594: if org_person%notfound then
595: close org_person;
596: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
597: fnd_message.raise_error;
598: end if;
599: close org_person;
600: end if;

Line 597: fnd_message.raise_error;

593: fetch org_person into l_exists;
594: if org_person%notfound then
595: close org_person;
596: fnd_message.set_name('OTA','OTA_13884_NHS_PERSON_INVALID');
597: fnd_message.raise_error;
598: end if;
599: close org_person;
600: end if;
601: hr_utility.set_location('Entering:'||l_proc, 40);

Line 667: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');

663: open cus_contact;
664: fetch cus_contact into l_exists;
665: if cus_contact%notfound then
666: close cus_contact;
667: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
668: fnd_message.raise_error;
669: end if;
670: close cus_contact;
671: hr_utility.set_location('Entering:'||l_proc, 20);

Line 668: fnd_message.raise_error;

664: fetch cus_contact into l_exists;
665: if cus_contact%notfound then
666: close cus_contact;
667: fnd_message.set_name('OTA','OTA_13283_TFH_CUSTOMER_CONTACT');
668: fnd_message.raise_error;
669: end if;
670: close cus_contact;
671: hr_utility.set_location('Entering:'||l_proc, 20);
672: end if;

Line 680: fnd_message.set_name('HR','HR_51889_APR_PERSON_NOT_EXIST');

676: open org_person;
677: fetch org_person into l_exists;
678: if org_person%notfound then
679: close org_person;
680: fnd_message.set_name('HR','HR_51889_APR_PERSON_NOT_EXIST');
681: fnd_message.raise_error;
682: end if;
683: close org_person;
684: hr_utility.set_location('Entering:'||l_proc, 40);

Line 681: fnd_message.raise_error;

677: fetch org_person into l_exists;
678: if org_person%notfound then
679: close org_person;
680: fnd_message.set_name('HR','HR_51889_APR_PERSON_NOT_EXIST');
681: fnd_message.raise_error;
682: end if;
683: close org_person;
684: hr_utility.set_location('Entering:'||l_proc, 40);
685: end if;

Line 732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');

728: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
729: (p_effective_date => p_effective_date
730: ,p_lookup_type => 'OTA_TRAINING_STATUSES'
731: ,p_lookup_code => p_status) then
732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');
733: fnd_message.raise_error;
734: end if;
735: hr_utility.set_location(' Leaving:'||l_proc, 30);
736:

Line 733: fnd_message.raise_error;

729: (p_effective_date => p_effective_date
730: ,p_lookup_type => 'OTA_TRAINING_STATUSES'
731: ,p_lookup_code => p_status) then
732: fnd_message.set_name('OTA','OTA_13880_NHS_STATUS_INVALID');
733: fnd_message.raise_error;
734: end if;
735: hr_utility.set_location(' Leaving:'||l_proc, 30);
736:
737: end if;

Line 782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');

778: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
779: (p_effective_date => p_effective_date
780: ,p_lookup_type => 'OTA_TRAINING_TYPES'
781: ,p_lookup_code => p_type) then
782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');
783: fnd_message.raise_error;
784: end if;
785: hr_utility.set_location(' Leaving:'||l_proc, 30);
786:

Line 783: fnd_message.raise_error;

779: (p_effective_date => p_effective_date
780: ,p_lookup_type => 'OTA_TRAINING_TYPES'
781: ,p_lookup_code => p_type) then
782: fnd_message.set_name('OTA','OTA_13879_NHS_TYPE_INVALID');
783: fnd_message.raise_error;
784: end if;
785: hr_utility.set_location(' Leaving:'||l_proc, 30);
786:
787: end if;

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

831: if hr_api.not_exists_in_hr_lookups -- Bug 2478551
832: (p_effective_date => p_effective_date
833: ,p_lookup_type => 'OTA_DURATION_UNITS'
834: ,p_lookup_code => p_duration_units) then
835: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
836: fnd_message.raise_error;
837: end if;
838: hr_utility.set_location(' Leaving:'||l_proc, 30);
839:

Line 836: fnd_message.raise_error;

832: (p_effective_date => p_effective_date
833: ,p_lookup_type => 'OTA_DURATION_UNITS'
834: ,p_lookup_code => p_duration_units) then
835: fnd_message.set_name('OTA','OTA_13882_NHS_DURATION_INVALID');
836: fnd_message.raise_error;
837: end if;
838: hr_utility.set_location(' Leaving:'||l_proc, 30);
839:
840: end if;

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

862: if (p_duration is not null and
863: p_duration_units is null ) or
864: (p_duration is null and
865: p_duration_units is not null ) then
866: fnd_message.set_name('OTA','OTA_13881_NHS_COMB_INVALID');
867: fnd_message.raise_error;
868:
869: end if;
870: hr_utility.set_location(' Leaving:'||l_proc, 20);

Line 867: fnd_message.raise_error;

863: p_duration_units is null ) or
864: (p_duration is null and
865: p_duration_units is not null ) then
866: fnd_message.set_name('OTA','OTA_13881_NHS_COMB_INVALID');
867: fnd_message.raise_error;
868:
869: end if;
870: hr_utility.set_location(' Leaving:'||l_proc, 20);
871: