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

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

70: close csr_sec_grp;
71: --
72: -- The primary key is invalid therefore we must error
73: --
74: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
75: hr_multi_message.add
76: (p_associated_column1
77: => nvl(p_associated_column1,'CATEGORY_USAGE_ID')
78: ,p_associated_column2

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

164: --
165: -- The primary key is invalid therefore we must error
166: --
167: close csr_leg_code;
168: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location(l_proc,30);
172: --

Line 169: fnd_message.raise_error;

165: -- The primary key is invalid therefore we must error
166: --
167: close csr_leg_code;
168: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
169: fnd_message.raise_error;
170: end if;
171: hr_utility.set_location(l_proc,30);
172: --
173: -- Set the global variables so the values are

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

364: (p_category_usage_id => p_rec.category_usage_id
365: ,p_certification_id => p_rec.certification_id
366: ,p_object_version_number => p_rec.object_version_number
367: ) THEN
368: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
369: fnd_message.set_token('PROCEDURE ', l_proc);
370: fnd_message.set_token('STEP ', '5');
371: fnd_message.raise_error;
372: END IF;

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

365: ,p_certification_id => p_rec.certification_id
366: ,p_object_version_number => p_rec.object_version_number
367: ) THEN
368: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
369: fnd_message.set_token('PROCEDURE ', l_proc);
370: fnd_message.set_token('STEP ', '5');
371: fnd_message.raise_error;
372: END IF;
373: --

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

366: ,p_object_version_number => p_rec.object_version_number
367: ) THEN
368: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
369: fnd_message.set_token('PROCEDURE ', l_proc);
370: fnd_message.set_token('STEP ', '5');
371: fnd_message.raise_error;
372: END IF;
373: --
374: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 371: fnd_message.raise_error;

367: ) THEN
368: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
369: fnd_message.set_token('PROCEDURE ', l_proc);
370: fnd_message.set_token('STEP ', '5');
371: fnd_message.raise_error;
372: END IF;
373: --
374: -- EDIT_HERE: Add checks to ensure non-updateable args have
375: -- not been updated.

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

438: IF ( l_cat_start_date > l_cert_start_date
439: or l_cat_end_date < l_cert_end_date
440: ) THEN
441: --
442: fnd_message.set_name ( 'OTA','OTA_443896_CRT_OUT_OF_CAT_DATE');
443: fnd_message.raise_error;
444: --
445: End IF;
446: ELSE

Line 443: fnd_message.raise_error;

439: or l_cat_end_date < l_cert_end_date
440: ) THEN
441: --
442: fnd_message.set_name ( 'OTA','OTA_443896_CRT_OUT_OF_CAT_DATE');
443: fnd_message.raise_error;
444: --
445: End IF;
446: ELSE
447: CLOSE csr_cat_start_end_date;

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

617: --
618: if sel_multiple_primary%found then
619: close sel_multiple_primary;
620:
621: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
622: fnd_message.raise_error;
623: end if;
624: close sel_multiple_primary;
625: --

Line 622: fnd_message.raise_error;

618: if sel_multiple_primary%found then
619: close sel_multiple_primary;
620:
621: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
622: fnd_message.raise_error;
623: end if;
624: close sel_multiple_primary;
625: --
626: hr_utility.set_location(' Leaving:'|| v_proc, 10);

Line 675: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');

671: --
672: if sel_primary_category%found then
673: close sel_primary_category;
674:
675: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
676: fnd_message.raise_error;
677: end if;
678: close sel_primary_category;
679: --

Line 676: fnd_message.raise_error;

672: if sel_primary_category%found then
673: close sel_primary_category;
674:
675: fnd_message.set_name('OTA', 'OTA_443266_DCI_DEL_PRIMARY');
676: fnd_message.raise_error;
677: end if;
678: close sel_primary_category;
679: --
680: hr_utility.set_location(' Leaving:'|| v_proc, 10);

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

768: --
769: if sel_unique_key%found then
770: close sel_unique_key;
771:
772: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
773: fnd_message.raise_error;
774: end if;
775: close sel_unique_key;
776: --

Line 773: fnd_message.raise_error;

769: if sel_unique_key%found then
770: close sel_unique_key;
771:
772: fnd_message.set_name('OTA', 'OTA_13676_DCI_DUPLICATE');
773: fnd_message.raise_error;
774: end if;
775: close sel_unique_key;
776: --
777: hr_utility.set_location(' Leaving:'|| v_proc, 10);