DBA Data[Home] [Help]

APPS.OTA_CHA_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,'CHAT_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 203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

199: IF NOT ota_cha_shd.api_updating
200: (p_chat_id => p_rec.chat_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;

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

200: (p_chat_id => p_rec.chat_id
201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --

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

201: ,p_object_version_number => p_rec.object_version_number
202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 206: fnd_message.raise_error;

202: ) THEN
203: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
204: fnd_message.set_token('PROCEDURE ', l_proc);
205: fnd_message.set_token('STEP ', '5');
206: fnd_message.raise_error;
207: END IF;
208: --
209: -- EDIT_HERE: Add checks to ensure non-updateable args have
210: -- not been updated.

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

268: IF ( l_cat_start_date > p_start_date
269: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
270: ) THEN
271: --
272: fnd_message.set_name ( 'OTA','OTA_443833_CHT_OUT_OF_CAT_DATE');
273: fnd_message.raise_error;
274: --
275: End IF;
276: ELSE

Line 273: fnd_message.raise_error;

269: or nvl(l_cat_end_date,hr_api.g_eot) < nvl(p_end_date,hr_api.g_eot)
270: ) THEN
271: --
272: fnd_message.set_name ( 'OTA','OTA_443833_CHT_OUT_OF_CAT_DATE');
273: fnd_message.raise_error;
274: --
275: End IF;
276: ELSE
277: CLOSE csr_cat_start_end_date;

Line 309: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');

305: IS
306: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
307: BEGIN
308: IF l_timezone_id IS NULL THEN
309: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
310: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810));
311: fnd_message.raise_error;
312: END IF;
313: END check_timezone;

Line 310: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810));

306: l_timezone_id NUMBER := ota_timezone_util.get_timezone_id(p_timezone);
307: BEGIN
308: IF l_timezone_id IS NULL THEN
309: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
310: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810));
311: fnd_message.raise_error;
312: END IF;
313: END check_timezone;
314: --

Line 311: fnd_message.raise_error;

307: BEGIN
308: IF l_timezone_id IS NULL THEN
309: fnd_message.set_name('OTA','OTA_443982_TIMEZONE_ERROR');
310: fnd_message.set_token('OBJECT_TYPE',ota_utility.get_lookup_meaning('OTA_OBJECT_TYPE','CHT',810));
311: fnd_message.raise_error;
312: END IF;
313: END check_timezone;
314: --
315: --