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

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

83: close csr_sec_grp;
84: --
85: -- The primary key is invalid therefore we must error
86: --
87: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
88: hr_multi_message.add
89: (p_associated_column1
90: => nvl(p_associated_column1,'CHAT_ID')
91: ,p_associated_column2

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

192: --
193: -- The primary key is invalid therefore we must error
194: --
195: close csr_leg_code;
196: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: end if;
199: hr_utility.set_location(l_proc,30);
200: --

Line 197: fnd_message.raise_error;

193: -- The primary key is invalid therefore we must error
194: --
195: close csr_leg_code;
196: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: end if;
199: hr_utility.set_location(l_proc,30);
200: --
201: -- Set the global variables so the values are

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

255: ,p_object_id => p_rec.object_id
256: ,p_object_type => p_rec.object_type
257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;

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

256: ,p_object_type => p_rec.object_type
257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --

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

257: ,p_object_version_number => p_rec.object_version_number
258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --
265: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 262: fnd_message.raise_error;

258: ) THEN
259: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
260: fnd_message.set_token('PROCEDURE ', l_proc);
261: fnd_message.set_token('STEP ', '5');
262: fnd_message.raise_error;
263: END IF;
264: --
265: -- EDIT_HERE: Add checks to ensure non-updateable args have
266: -- not been updated.

Line 304: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');

300: --
301: if sel_unique_key%found then
302: close sel_unique_key;
303:
304: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
305: fnd_message.raise_error;
306: end if;
307: close sel_unique_key;
308: --

Line 305: fnd_message.raise_error;

301: if sel_unique_key%found then
302: close sel_unique_key;
303:
304: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
305: fnd_message.raise_error;
306: end if;
307: close sel_unique_key;
308: --
309: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 387: fnd_message.set_name ( 'OTA','OTA_443833_CHT_OUT_OF_CAT_DATE');

383: IF ( l_cat_start_date > l_chat_start_date
384: or l_cat_end_date < l_chat_end_date
385: ) THEN
386: --
387: fnd_message.set_name ( 'OTA','OTA_443833_CHT_OUT_OF_CAT_DATE');
388: fnd_message.raise_error;
389: --
390: End IF;
391: ELSE

Line 388: fnd_message.raise_error;

384: or l_cat_end_date < l_chat_end_date
385: ) THEN
386: --
387: fnd_message.set_name ( 'OTA','OTA_443833_CHT_OUT_OF_CAT_DATE');
388: fnd_message.raise_error;
389: --
390: End IF;
391: ELSE
392: CLOSE csr_cat_start_end_date;

Line 442: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');

438: --
439: if sel_multiple_primary%found then
440: close sel_multiple_primary;
441:
442: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
443: fnd_message.raise_error;
444: end if;
445: close sel_multiple_primary;
446: --

Line 443: fnd_message.raise_error;

439: if sel_multiple_primary%found then
440: close sel_multiple_primary;
441:
442: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
443: fnd_message.raise_error;
444: end if;
445: close sel_multiple_primary;
446: --
447: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 497: fnd_message.set_name('OTA', 'OTA_443941_CHT_DEL_PRIMARY');

493: --
494: if sel_primary_category%found then
495: close sel_primary_category;
496:
497: fnd_message.set_name('OTA', 'OTA_443941_CHT_DEL_PRIMARY');
498: fnd_message.raise_error;
499: end if;
500: close sel_primary_category;
501: --

Line 498: fnd_message.raise_error;

494: if sel_primary_category%found then
495: close sel_primary_category;
496:
497: fnd_message.set_name('OTA', 'OTA_443941_CHT_DEL_PRIMARY');
498: fnd_message.raise_error;
499: end if;
500: close sel_primary_category;
501: --
502: hr_utility.set_location(' Leaving:'|| v_proc, 10);