DBA Data[Home] [Help]

APPS.PQH_RSS_BUS dependencies on FND_MESSAGE

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

62: close csr_sec_grp;
63: --
64: -- The primary key is invalid therefore we must error
65: --
66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add
68: (p_associated_column1
69: => nvl(p_associated_column1,'RESULT_SET_ID')
70: );

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

145: --
146: -- The primary key is invalid therefore we must error
147: --
148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --

Line 150: fnd_message.raise_error;

146: -- The primary key is invalid therefore we must error
147: --
148: close csr_leg_code;
149: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
150: fnd_message.raise_error;
151: end if;
152: hr_utility.set_location(l_proc,30);
153: --
154: -- Set the global variables so the values are

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

205: IF NOT pqh_rss_shd.api_updating
206: (p_result_set_id => p_rec.result_set_id
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;

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

206: (p_result_set_id => p_rec.result_set_id
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --

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

207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --
215: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 212: fnd_message.raise_error;

208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214: --
215: -- EDIT_HERE: Add checks to ensure non-updateable args have
216: -- not been updated.

Line 221: fnd_message.raise_error;

217: --
218: IF nvl(p_rec.Grade_id, hr_api.g_number) <>
219: nvl(pqh_RSS_shd.g_old_rec.Grade_id, hr_api.g_number) THEN
220: hr_utility.set_message(8302, 'PQH_DE_NONUPD_GRADE_ID');
221: fnd_message.raise_error;
222:
223: END IF;
224:
225: End chk_non_updateable_args;

Line 247: fnd_message.raise_error;

243: Fetch c_Grade_id into l_Grade_id;
244: If c_Grade_id%notfound Then
245: hr_utility.set_message(8302, 'PQH_DE_Check_Grade_id');
246: Close c_Grade_id;
247: fnd_message.raise_error;
248: End If;
249: Close c_Grade_id;
250: Exception
251: when app_exception.application_exception then

Line 335: fnd_message.raise_error;

331: Fetch c_CIVIL_SERVANTS_Grade_id into l_CIVIL_SERVANTS_Grade_id;
332: If c_CIVIL_SERVANTS_Grade_id%notfound Then
333: hr_utility.set_message(8302, 'PQH_DE_CIVIL_SERVANTS_Grade_id');
334: Close c_CIVIL_SERVANTS_Grade_id;
335: fnd_message.raise_error;
336: End If;
337: Close c_CIVIL_SERVANTS_Grade_id;
338: Exception
339: when app_exception.application_exception then

Line 375: fnd_message.raise_error;

371: hr_utility.set_location(l_proc, 10);
372:
373: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) < 0 or to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) < 0 then
374: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_NUM_NEG');
375: fnd_message.raise_error;
376: End If;
377:
378: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) > to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) then
379: hr_utility.set_message(8302, 'PQH_DE_Gradual_value');

Line 380: fnd_message.raise_error;

376: End If;
377:
378: if to_number(p_rec.GRADUAL_VALUE_NUMBER_FROM) > to_number(p_rec.GRADUAL_VALUE_NUMBER_TO) then
379: hr_utility.set_message(8302, 'PQH_DE_Gradual_value');
380: fnd_message.raise_error;
381: End If;
382:
383:
384:

Line 390: fnd_message.raise_error;

386: Fetch c_gradual_value_numbers into l_gradual_value_numbers;
387: If c_gradual_value_numbers%found Then
388: hr_utility.set_message(8302, 'PQH_DE_GRADUAL_EXIST');
389: Close c_gradual_value_numbers;
390: fnd_message.raise_error;
391: End If;
392: Close c_gradual_value_numbers;
393: Exception
394: