DBA Data[Home] [Help]

APPS.PQH_VLP_BUS dependencies on FND_MESSAGE

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

58: close csr_sec_grp;
59: --
60: -- The primary key is invalid therefore we must error
61: --
62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
63: hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'VALIDATION_PERIOD_ID')
66: );

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

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

Line 142: fnd_message.raise_error;

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

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

196: IF NOT pqh_vlp_shd.api_updating
197: (p_validation_period_id => p_rec.validation_period_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;

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

197: (p_validation_period_id => p_rec.validation_period_id
198: ,p_object_version_number => p_rec.object_version_number
199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --

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

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

Line 203: fnd_message.raise_error;

199: ) THEN
200: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
201: fnd_message.set_token('PROCEDURE ', l_proc);
202: fnd_message.set_token('STEP ', '5');
203: fnd_message.raise_error;
204: END IF;
205: --
206: End chk_non_updateable_args;
207: --

Line 244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

240: and
241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then
244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;
246: end if;
247: -- for p_rec.end_date
248: select count(*) into cnt from pqh_fr_validation_periods

Line 245: fnd_message.raise_error;

241: nvl(end_date, hr_general.end_of_time);
242:
243: if cnt > 0 then
244: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
245: fnd_message.raise_error;
246: end if;
247: -- for p_rec.end_date
248: select count(*) into cnt from pqh_fr_validation_periods
249: where previous_employer_id = p_rec.previous_employer_id

Line 258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

254: and
255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then
258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;
260: end if;
261: --for start_date
262: select count(*) into cnt from pqh_fr_validation_periods

Line 259: fnd_message.raise_error;

255: nvl(end_date, hr_general.end_of_time);
256:
257: if cnt > 0 then
258: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
259: fnd_message.raise_error;
260: end if;
261: --for start_date
262: select count(*) into cnt from pqh_fr_validation_periods
263: where previous_employer_id = p_rec.previous_employer_id

Line 272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

268: and
269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then
272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;
274: end if;
275: -- for end_date
276: select count(*) into cnt from pqh_fr_validation_periods

Line 273: fnd_message.raise_error;

269: nvl(p_rec.end_date, hr_general.end_of_time);
270:
271: if cnt > 0 then
272: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
273: fnd_message.raise_error;
274: end if;
275: -- for end_date
276: select count(*) into cnt from pqh_fr_validation_periods
277: where previous_employer_id = p_rec.previous_employer_id

Line 286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

282: and
283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then
286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
287: fnd_message.raise_error;
288: end if;
289: end if;
290: hr_utility.set_location(' Leaving:'||l_proc, 10);

Line 287: fnd_message.raise_error;

283: nvl(p_rec.end_date, hr_general.end_of_time);
284:
285: if cnt > 0 then
286: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
287: fnd_message.raise_error;
288: end if;
289: end if;
290: hr_utility.set_location(' Leaving:'||l_proc, 10);
291: End insert_validate;

Line 335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

331: and
332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then
335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;
337: end if;
338: -- for p_rec.end_date
339: select count(*) into cnt from pqh_fr_validation_periods

Line 336: fnd_message.raise_error;

332: nvl(end_date, hr_general.end_of_time);
333:
334: if cnt > 0 then
335: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
336: fnd_message.raise_error;
337: end if;
338: -- for p_rec.end_date
339: select count(*) into cnt from pqh_fr_validation_periods
340: where previous_employer_id = p_rec.previous_employer_id

Line 350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

346: and
347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then
350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;
352: end if;
353: --for start_date
354: select count(*) into cnt from pqh_fr_validation_periods

Line 351: fnd_message.raise_error;

347: nvl(end_date, hr_general.end_of_time);
348:
349: if cnt > 0 then
350: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
351: fnd_message.raise_error;
352: end if;
353: --for start_date
354: select count(*) into cnt from pqh_fr_validation_periods
355: where previous_employer_id = p_rec.previous_employer_id

Line 365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

361: and
362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then
365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;
367: end if;
368: -- for end_date
369: select count(*) into cnt from pqh_fr_validation_periods

Line 366: fnd_message.raise_error;

362: nvl(p_rec.end_date, hr_general.end_of_time);
363:
364: if cnt > 0 then
365: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
366: fnd_message.raise_error;
367: end if;
368: -- for end_date
369: select count(*) into cnt from pqh_fr_validation_periods
370: where previous_employer_id = p_rec.previous_employer_id

Line 380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');

376: and
377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then
380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
381: fnd_message.raise_error;
382: end if;
383: end if;
384: --

Line 381: fnd_message.raise_error;

377: nvl(p_rec.end_date, hr_general.end_of_time);
378:
379: if cnt > 0 then
380: fnd_message.set_name('PQH', 'FR_PQH_VALIDATION_OVERLAP');
381: fnd_message.raise_error;
382: end if;
383: end if;
384: --
385: hr_utility.set_location(' Leaving:'||l_proc, 10);