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

Line 21: fnd_message.set_name ( 'OTA','OTA_467063_MAND_LANGUAGE_CODE');

17: procedure check_lang_code(p_rec in ota_ocl_shd.g_rec_type)
18: is
19: begin
20: If p_rec.language_code IS NULL THEN
21: fnd_message.set_name ( 'OTA','OTA_467063_MAND_LANGUAGE_CODE');
22: fnd_message.raise_error;
23: END IF;
24:
25: end;

Line 22: fnd_message.raise_error;

18: is
19: begin
20: If p_rec.language_code IS NULL THEN
21: fnd_message.set_name ( 'OTA','OTA_467063_MAND_LANGUAGE_CODE');
22: fnd_message.raise_error;
23: END IF;
24:
25: end;
26: -- ---------------------------------------------------------------------------

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

65: close csr_sec_grp;
66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: fnd_message.raise_error;
71: --
72: end if;
73: close csr_sec_grp;

Line 70: fnd_message.raise_error;

66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: fnd_message.raise_error;
71: --
72: end if;
73: close csr_sec_grp;
74: --

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

138: --
139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --

Line 143: fnd_message.raise_error;

139: -- The primary key is invalid therefore we must error
140: --
141: close csr_leg_code;
142: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
143: fnd_message.raise_error;
144: end if;
145: hr_utility.set_location(l_proc,30);
146: --
147: -- Set the global variables so the values are

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

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

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

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

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

340: ,p_object_version_number => p_rec.object_version_number
341: ) THEN
342: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE ', l_proc);
344: fnd_message.set_token('STEP ', '5');
345: fnd_message.raise_error;
346: END IF;
347: --
348: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 345: fnd_message.raise_error;

341: ) THEN
342: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
343: fnd_message.set_token('PROCEDURE ', l_proc);
344: fnd_message.set_token('STEP ', '5');
345: fnd_message.raise_error;
346: END IF;
347: --
348: -- EDIT_HERE: Add checks to ensure non-updateable args have
349: -- not been updated.

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

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

Line 419: fnd_message.raise_error;

415: fetch csr_competence into l_exists;
416: if csr_competence%notfound then
417: close csr_competence;
418: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');
419: fnd_message.raise_error;
420: end if;
421: close csr_competence;
422: hr_utility.set_location('Entering:'||l_proc, 20);
423: elsif ( fnd_profile.value('OTA_HR_GLOBAL_BUSINESS_GROUP_ID') is not null and

Line 432: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');

428: open csr_competence_cross;
429: fetch csr_competence_cross into l_exists;
430: if csr_competence_cross%notfound then
431: close csr_competence_cross;
432: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');
433: fnd_message.raise_error;
434: end if;
435: close csr_competence_cross;
436: hr_utility.set_location('Entering:'||l_proc, 30);

Line 433: fnd_message.raise_error;

429: fetch csr_competence_cross into l_exists;
430: if csr_competence_cross%notfound then
431: close csr_competence_cross;
432: fnd_message.set_name('OTA','OTA_OCL_COMP_NOT_EXIST');
433: fnd_message.raise_error;
434: end if;
435: close csr_competence_cross;
436: hr_utility.set_location('Entering:'||l_proc, 30);
437:

Line 498: fnd_message.set_name('OTA','OTA_OCL_PROF_LEVEL_NOT_EXIST');

494: open csr_proficiency ;
495: fetch csr_proficiency into l_exists;
496: if csr_proficiency %notfound then
497: close csr_proficiency ;
498: fnd_message.set_name('OTA','OTA_OCL_PROF_LEVEL_NOT_EXIST');
499: fnd_message.raise_error;
500: end if;
501: close csr_proficiency;
502: hr_utility.set_location('Entering:'||l_proc, 20);

Line 499: fnd_message.raise_error;

495: fetch csr_proficiency into l_exists;
496: if csr_proficiency %notfound then
497: close csr_proficiency ;
498: fnd_message.set_name('OTA','OTA_OCL_PROF_LEVEL_NOT_EXIST');
499: fnd_message.raise_error;
500: end if;
501: close csr_proficiency;
502: hr_utility.set_location('Entering:'||l_proc, 20);
503: end if;

Line 549: fnd_message.set_name('OTA','OTA_OCL_LANG_NOT_EXIST');

545: open csr_language;
546: fetch csr_language into l_exists;
547: if csr_language%notfound then
548: close csr_language;
549: fnd_message.set_name('OTA','OTA_OCL_LANG_NOT_EXIST');
550: fnd_message.raise_error;
551: end if;
552: close csr_language;
553: hr_utility.set_location('Entering:'||l_proc, 20);

Line 550: fnd_message.raise_error;

546: fetch csr_language into l_exists;
547: if csr_language%notfound then
548: close csr_language;
549: fnd_message.set_name('OTA','OTA_OCL_LANG_NOT_EXIST');
550: fnd_message.raise_error;
551: end if;
552: close csr_language;
553: hr_utility.set_location('Entering:'||l_proc, 20);
554: end if;