DBA Data[Home] [Help]

APPS.PER_APR_BUS dependencies on FND_MESSAGE

Line 224: fnd_message.set_name('PER','PER_52459_APR_INVALID_OPEN_TYPE');

220: ,p_lookup_type => 'YES_NO'
221: ,p_lookup_code => p_open
222: )) then
223: -- p_open does not exist in lookup, thus error.
224: fnd_message.set_name('PER','PER_52459_APR_INVALID_OPEN_TYPE');
225: fnd_message.raise_error;
226: end if;
227:
228: hr_utility.set_location('Leaving: '||l_proc,20);

Line 225: fnd_message.raise_error;

221: ,p_lookup_code => p_open
222: )) then
223: -- p_open does not exist in lookup, thus error.
224: fnd_message.set_name('PER','PER_52459_APR_INVALID_OPEN_TYPE');
225: fnd_message.raise_error;
226: end if;
227:
228: hr_utility.set_location('Leaving: '||l_proc,20);
229:

Line 307: fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');

303: END IF;
304: END LOOP;
305: -- Update not allowed
306: IF NOT l_allow_appraisal THEN
307: fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');
308: fnd_message.raise_error;
309: END IF;
310:
311: -- Check also that the appraisal is OPEN.

Line 308: fnd_message.raise_error;

304: END LOOP;
305: -- Update not allowed
306: IF NOT l_allow_appraisal THEN
307: fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');
308: fnd_message.raise_error;
309: END IF;
310:
311: -- Check also that the appraisal is OPEN.
312:

Line 318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

314: -- Check that columns arent being updated (except OPEN column)
315:
316: if p_rec.appraiser_person_id
317: <> per_apr_shd.g_old_rec.appraiser_person_id then
318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 319: fnd_message.raise_error;

315:
316: if p_rec.appraiser_person_id
317: <> per_apr_shd.g_old_rec.appraiser_person_id then
318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;

Line 322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

318: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 323: fnd_message.raise_error;

319: fnd_message.raise_error;
320: elsif p_rec.appraisal_date
321: <> per_apr_shd.g_old_rec.appraisal_date then
322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;

Line 326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

322: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 327: fnd_message.raise_error;

323: fnd_message.raise_error;
324: elsif p_rec.appraisal_period_end_date
325: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;

Line 330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

326: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 331: fnd_message.raise_error;

327: fnd_message.raise_error;
328: elsif p_rec.appraisal_period_start_date
329: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;

Line 334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

330: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 335: fnd_message.raise_error;

331: fnd_message.raise_error;
332: elsif p_rec.type
333: <> per_apr_shd.g_old_rec.type then
334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;

Line 338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

334: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 339: fnd_message.raise_error;

335: fnd_message.raise_error;
336: elsif p_rec.next_appraisal_date
337: <> per_apr_shd.g_old_rec.next_appraisal_date then
338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;

Line 342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

338: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 343: fnd_message.raise_error;

339: fnd_message.raise_error;
340: elsif p_rec.status
341: <> per_apr_shd.g_old_rec.status then
342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;

Line 346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

342: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 347: fnd_message.raise_error;

343: fnd_message.raise_error;
344: elsif p_rec.comments
345: <> per_apr_shd.g_old_rec.comments then
346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;

Line 350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

346: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 351: fnd_message.raise_error;

347: fnd_message.raise_error;
348: elsif p_rec.overall_performance_level_id
349: <> per_apr_shd.g_old_rec.overall_performance_level_id then
350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;

Line 354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

350: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 355: fnd_message.raise_error;

351: fnd_message.raise_error;
352: elsif p_rec.attribute_category
353: <> per_apr_shd.g_old_rec.attribute_category then
354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;

Line 358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

354: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 359: fnd_message.raise_error;

355: fnd_message.raise_error;
356: elsif p_rec.attribute1
357: <> per_apr_shd.g_old_rec.attribute1 then
358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;

Line 362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

358: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 363: fnd_message.raise_error;

359: fnd_message.raise_error;
360: elsif p_rec.attribute2
361: <> per_apr_shd.g_old_rec.attribute2 then
362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;

Line 366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

362: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 367: fnd_message.raise_error;

363: fnd_message.raise_error;
364: elsif p_rec.attribute3
365: <> per_apr_shd.g_old_rec.attribute3 then
366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;

Line 370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

366: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 371: fnd_message.raise_error;

367: fnd_message.raise_error;
368: elsif p_rec.attribute4
369: <> per_apr_shd.g_old_rec.attribute4 then
370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;

Line 374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

370: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 375: fnd_message.raise_error;

371: fnd_message.raise_error;
372: elsif p_rec.attribute5
373: <> per_apr_shd.g_old_rec.attribute5 then
374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;

Line 378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

374: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 379: fnd_message.raise_error;

375: fnd_message.raise_error;
376: elsif p_rec.attribute6
377: <> per_apr_shd.g_old_rec.attribute6 then
378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;

Line 382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

378: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 383: fnd_message.raise_error;

379: fnd_message.raise_error;
380: elsif p_rec.attribute7
381: <> per_apr_shd.g_old_rec.attribute7 then
382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;

Line 386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

382: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 387: fnd_message.raise_error;

383: fnd_message.raise_error;
384: elsif p_rec.attribute8
385: <> per_apr_shd.g_old_rec.attribute8 then
386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;

Line 390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

386: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 391: fnd_message.raise_error;

387: fnd_message.raise_error;
388: elsif p_rec.attribute9
389: <> per_apr_shd.g_old_rec.attribute9 then
390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;

Line 394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

390: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 395: fnd_message.raise_error;

391: fnd_message.raise_error;
392: elsif p_rec.attribute10
393: <> per_apr_shd.g_old_rec.attribute10 then
394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;

Line 398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

394: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 399: fnd_message.raise_error;

395: fnd_message.raise_error;
396: elsif p_rec.attribute11
397: <> per_apr_shd.g_old_rec.attribute11 then
398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;

Line 402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

398: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 403: fnd_message.raise_error;

399: fnd_message.raise_error;
400: elsif p_rec.attribute12
401: <> per_apr_shd.g_old_rec.attribute12 then
402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;

Line 406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

402: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 407: fnd_message.raise_error;

403: fnd_message.raise_error;
404: elsif p_rec.attribute13
405: <> per_apr_shd.g_old_rec.attribute13 then
406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;

Line 410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

406: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 411: fnd_message.raise_error;

407: fnd_message.raise_error;
408: elsif p_rec.attribute14
409: <> per_apr_shd.g_old_rec.attribute14 then
410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;

Line 414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

410: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 415: fnd_message.raise_error;

411: fnd_message.raise_error;
412: elsif p_rec.attribute15
413: <> per_apr_shd.g_old_rec.attribute15 then
414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;

Line 418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

414: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 419: fnd_message.raise_error;

415: fnd_message.raise_error;
416: elsif p_rec.attribute16
417: <> per_apr_shd.g_old_rec.attribute16 then
418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;

Line 422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

418: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 423: fnd_message.raise_error;

419: fnd_message.raise_error;
420: elsif p_rec.attribute17
421: <> per_apr_shd.g_old_rec.attribute17 then
422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;

Line 426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

422: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 427: fnd_message.raise_error;

423: fnd_message.raise_error;
424: elsif p_rec.attribute18
425: <> per_apr_shd.g_old_rec.attribute18 then
426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;

Line 430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

426: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 431: fnd_message.raise_error;

427: fnd_message.raise_error;
428: elsif p_rec.attribute19
429: <> per_apr_shd.g_old_rec.attribute19 then
430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;

Line 434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

430: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 435: fnd_message.raise_error;

431: fnd_message.raise_error;
432: elsif p_rec.attribute20
433: <> per_apr_shd.g_old_rec.attribute20 then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;

Line 438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 439: fnd_message.raise_error;

435: fnd_message.raise_error;
436: elsif p_rec.system_type
437: <> per_apr_shd.g_old_rec.system_type then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;

Line 442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 443: fnd_message.raise_error;

439: fnd_message.raise_error;
440: elsif p_rec.system_params
441: <> per_apr_shd.g_old_rec.system_params then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;

Line 446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 447: fnd_message.raise_error;

443: fnd_message.raise_error;
444: elsif p_rec.appraisee_access
445: <> per_apr_shd.g_old_rec.appraisee_access then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;

Line 450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 451: fnd_message.raise_error;

447: fnd_message.raise_error;
448: elsif p_rec.main_appraiser_id
449: <> per_apr_shd.g_old_rec.main_appraiser_id then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;

Line 454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 455: fnd_message.raise_error;

451: fnd_message.raise_error;
452: elsif p_rec.assignment_id
453: <> per_apr_shd.g_old_rec.assignment_id then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;

Line 458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 459: fnd_message.raise_error;

455: fnd_message.raise_error;
456: elsif p_rec.assignment_start_date
457: <> per_apr_shd.g_old_rec.assignment_start_date then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;

Line 462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 463: fnd_message.raise_error;

459: fnd_message.raise_error;
460: elsif p_rec.assignment_business_group_id
461: <> per_apr_shd.g_old_rec.assignment_business_group_id then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;

Line 466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 467: fnd_message.raise_error;

463: fnd_message.raise_error;
464: elsif p_rec.assignment_organization_id
465: <> per_apr_shd.g_old_rec.assignment_organization_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;

Line 470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 471: fnd_message.raise_error;

467: fnd_message.raise_error;
468: elsif p_rec.assignment_job_id
469: <> per_apr_shd.g_old_rec.assignment_job_id then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;

Line 474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 475: fnd_message.raise_error;

471: fnd_message.raise_error;
472: elsif p_rec.assignment_position_id
473: <> per_apr_shd.g_old_rec.assignment_position_id then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;

Line 478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 479: fnd_message.raise_error;

475: fnd_message.raise_error;
476: elsif p_rec.assignment_grade_id
477: <> per_apr_shd.g_old_rec.assignment_grade_id then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;

Line 482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 483: fnd_message.raise_error;

479: fnd_message.raise_error;
480: elsif p_rec.potential_readiness_level
481: <> per_apr_shd.g_old_rec.potential_readiness_level then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;

Line 486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 487: fnd_message.raise_error;

483: fnd_message.raise_error;
484: elsif p_rec.potential_short_term_workopp
485: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;

Line 490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 491: fnd_message.raise_error;

487: fnd_message.raise_error;
488: elsif p_rec.potential_long_term_workopp
489: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;

Line 494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 495: fnd_message.raise_error;

491: fnd_message.raise_error;
492: elsif p_rec.potential_details
493: <> per_apr_shd.g_old_rec.potential_details then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;

Line 498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500:
501: end if;
502:

Line 499: fnd_message.raise_error;

495: fnd_message.raise_error;
496: elsif p_rec.event_id
497: <> per_apr_shd.g_old_rec.event_id then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500:
501: end if;
502:
503:

Line 571: fnd_message.set_name('PER','PER_52457_APR_UPD_COMPLTD_APR');

567:
568: if csr_answer_set_exists%found then
569: -- answer set does exists, thus cannot update => error!
570: close csr_answer_set_exists;
571: fnd_message.set_name('PER','PER_52457_APR_UPD_COMPLTD_APR');
572: fnd_message.raise_error;
573: end if;
574: close csr_answer_set_exists;
575: else

Line 572: fnd_message.raise_error;

568: if csr_answer_set_exists%found then
569: -- answer set does exists, thus cannot update => error!
570: close csr_answer_set_exists;
571: fnd_message.set_name('PER','PER_52457_APR_UPD_COMPLTD_APR');
572: fnd_message.raise_error;
573: end if;
574: close csr_answer_set_exists;
575: else
576: null;

Line 1595: fnd_message.set_name('PER','PER_52452_APR_INVALID_START'); -- Fix 2516903

1591: -- Determine whether each of the dates are valid
1592: l_valid :=
1593: validate_date(p_appraisal_period_start_date, p_appraisee_person_id);
1594: if not l_valid then
1595: fnd_message.set_name('PER','PER_52452_APR_INVALID_START'); -- Fix 2516903
1596: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE');
1597: --fnd_message.raise_error;
1598: end if;
1599:

Line 1597: --fnd_message.raise_error;

1593: validate_date(p_appraisal_period_start_date, p_appraisee_person_id);
1594: if not l_valid then
1595: fnd_message.set_name('PER','PER_52452_APR_INVALID_START'); -- Fix 2516903
1596: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE');
1597: --fnd_message.raise_error;
1598: end if;
1599:
1600: hr_utility.set_location(l_proc,20);
1601:

Line 1605: fnd_message.set_name('PER','PER_52453_APR_INVALID_APR_DATE');

1601:
1602: l_valid :=
1603: validate_date(p_appraisal_date,p_appraisee_person_id);
1604: if not l_valid then
1605: fnd_message.set_name('PER','PER_52453_APR_INVALID_APR_DATE');
1606: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1607: --fnd_message.raise_error;
1608: end if;
1609:

Line 1607: --fnd_message.raise_error;

1603: validate_date(p_appraisal_date,p_appraisee_person_id);
1604: if not l_valid then
1605: fnd_message.set_name('PER','PER_52453_APR_INVALID_APR_DATE');
1606: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1607: --fnd_message.raise_error;
1608: end if;
1609:
1610: hr_utility.set_location(l_proc,30);
1611:

Line 1615: fnd_message.set_name('PER','PER_52454_APR_INVALID_END'); -- Fix 2485178

1611:
1612: l_valid :=
1613: validate_date(p_appraisal_period_end_date, p_appraisee_person_id);
1614: if not l_valid then
1615: fnd_message.set_name('PER','PER_52454_APR_INVALID_END'); -- Fix 2485178
1616: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_END_DATE');
1617: --fnd_message.raise_error;
1618: end if;
1619:

Line 1617: --fnd_message.raise_error;

1613: validate_date(p_appraisal_period_end_date, p_appraisee_person_id);
1614: if not l_valid then
1615: fnd_message.set_name('PER','PER_52454_APR_INVALID_END'); -- Fix 2485178
1616: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_END_DATE');
1617: --fnd_message.raise_error;
1618: end if;
1619:
1620: hr_utility.set_location(l_proc,40);
1621:

Line 1633: fnd_message.set_name('PER','PER_52455_APR_INVALID_APR_DATE');

1629: else
1630: l_valid :=
1631: validate_date(p_appraisal_date, p_appraiser_person_id);
1632: if not l_valid then
1633: fnd_message.set_name('PER','PER_52455_APR_INVALID_APR_DATE');
1634: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1635: -- fnd_message.raise_error;
1636: end if;
1637: end if;

Line 1635: -- fnd_message.raise_error;

1631: validate_date(p_appraisal_date, p_appraiser_person_id);
1632: if not l_valid then
1633: fnd_message.set_name('PER','PER_52455_APR_INVALID_APR_DATE');
1634: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1635: -- fnd_message.raise_error;
1636: end if;
1637: end if;
1638:
1639:

Line 1978: fnd_message.set_name('PER','PER_52450_APR_ANSWERS_EXIST');

1974: open csr_apr_exists_in_per_part;
1975: fetch csr_apr_exists_in_per_part into l_exists;
1976: if csr_apr_exists_in_per_part%found then
1977: close csr_apr_exists_in_per_part;
1978: fnd_message.set_name('PER','PER_52450_APR_ANSWERS_EXIST');
1979: fnd_message.raise_error;
1980: end if;
1981: close csr_apr_exists_in_per_part;
1982:

Line 1979: fnd_message.raise_error;

1975: fetch csr_apr_exists_in_per_part into l_exists;
1976: if csr_apr_exists_in_per_part%found then
1977: close csr_apr_exists_in_per_part;
1978: fnd_message.set_name('PER','PER_52450_APR_ANSWERS_EXIST');
1979: fnd_message.raise_error;
1980: end if;
1981: close csr_apr_exists_in_per_part;
1982:
1983: hr_utility.set_location(l_proc,7);

Line 1989: fnd_message.set_name('PER','PER_52451_APR_PARTICIP_EXIST');

1985: open csr_apr_exists_in_hr_qsa;
1986: fetch csr_apr_exists_in_hr_qsa into l_exists;
1987: if csr_apr_exists_in_hr_qsa%found then
1988: close csr_apr_exists_in_hr_qsa;
1989: fnd_message.set_name('PER','PER_52451_APR_PARTICIP_EXIST');
1990: fnd_message.raise_error;
1991: end if;
1992: close csr_apr_exists_in_hr_qsa;
1993:

Line 1990: fnd_message.raise_error;

1986: fetch csr_apr_exists_in_hr_qsa into l_exists;
1987: if csr_apr_exists_in_hr_qsa%found then
1988: close csr_apr_exists_in_hr_qsa;
1989: fnd_message.set_name('PER','PER_52451_APR_PARTICIP_EXIST');
1990: fnd_message.raise_error;
1991: end if;
1992: close csr_apr_exists_in_hr_qsa;
1993:
1994: hr_utility.set_location('Leaving: '|| l_proc, 10);

Line 2068: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');

2064: FETCH csr_chk_plan_id INTO l_plan_id;
2065: CLOSE csr_chk_plan_id;
2066:
2067: IF l_plan_id IS null THEN
2068: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
2069: fnd_message.raise_error;
2070: END IF;
2071:
2072: END IF;

Line 2069: fnd_message.raise_error;

2065: CLOSE csr_chk_plan_id;
2066:
2067: IF l_plan_id IS null THEN
2068: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
2069: fnd_message.raise_error;
2070: END IF;
2071:
2072: END IF;
2073:

Line 2157: fnd_message.set_name('PER', 'HR_34568_INV_OFFLINE_STATUS');

2153: p_effective_date => p_effective_date
2154: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2155: ,p_lookup_code => upper(p_offline_status)
2156: ) THEN
2157: fnd_message.set_name('PER', 'HR_34568_INV_OFFLINE_STATUS');
2158: fnd_message.raise_error;
2159: END IF;
2160:
2161: END IF;

Line 2158: fnd_message.raise_error;

2154: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2155: ,p_lookup_code => upper(p_offline_status)
2156: ) THEN
2157: fnd_message.set_name('PER', 'HR_34568_INV_OFFLINE_STATUS');
2158: fnd_message.raise_error;
2159: END IF;
2160:
2161: END IF;
2162: