APPS.PER_APR_BUS dependencies on FND_MESSAGE

Line 139: fnd_message.set_name ('PER', 'HR_34297_FUTURE_TERM_EXIST');

135: CLOSE csr_is_future_term_exist;
136:
137: IF (NVL (l_future_term_exist, 'N') = 'Y')
138: THEN
139: fnd_message.set_name ('PER', 'HR_34297_FUTURE_TERM_EXIST');
140: fnd_message.raise_error;
141: END IF;
142: END IF;
143:

Line 140: fnd_message.raise_error;

136:
137: IF (NVL (l_future_term_exist, 'N') = 'Y')
138: THEN
139: fnd_message.set_name ('PER', 'HR_34297_FUTURE_TERM_EXIST');
140: fnd_message.raise_error;
141: END IF;
142: END IF;
143:
144: hr_utility.set_location ('Leaving:' || l_proc, 970);

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

306: ,p_lookup_type => 'YES_NO'
307: ,p_lookup_code => p_open
308: )) then
309: -- p_open does not exist in lookup, thus error.
310: fnd_message.set_name('PER','PER_52459_APR_INVALID_OPEN_TYPE');
311: fnd_message.raise_error;
312: end if;
313:
314: hr_utility.set_location('Leaving: '||l_proc,20);

Line 311: fnd_message.raise_error;

307: ,p_lookup_code => p_open
308: )) then
309: -- p_open does not exist in lookup, thus error.
310: fnd_message.set_name('PER','PER_52459_APR_INVALID_OPEN_TYPE');
311: fnd_message.raise_error;
312: end if;
313:
314: hr_utility.set_location('Leaving: '||l_proc,20);
315:

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

411: END IF;
412:
413: -- Update not allowed
414: IF NOT l_allow_appraisal AND l_allow_term_emp ='N' THEN
415: fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');
416: fnd_message.raise_error;
417: END IF;
418: hr_utility.set_location('l_allow_term_emp: '||l_allow_term_emp,10);
419: --ExEmpEnhancements

Line 416: fnd_message.raise_error;

412:
413: -- Update not allowed
414: IF NOT l_allow_appraisal AND l_allow_term_emp ='N' THEN
415: fnd_message.set_name('PER','PER_52456_APR_UPD_EX_EMP_APR');
416: fnd_message.raise_error;
417: END IF;
418: hr_utility.set_location('l_allow_term_emp: '||l_allow_term_emp,10);
419: --ExEmpEnhancements
420: per_apr_bus.chk_future_termination_exist (

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

430: -- Check that columns arent being updated (except OPEN column)
431:
432: if p_rec.appraiser_person_id
433: <> per_apr_shd.g_old_rec.appraiser_person_id then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 435: fnd_message.raise_error;

431:
432: if p_rec.appraiser_person_id
433: <> per_apr_shd.g_old_rec.appraiser_person_id then
434: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
435: fnd_message.raise_error;
436: elsif p_rec.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date 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.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date 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.appraisal_date
437: <> per_apr_shd.g_old_rec.appraisal_date then
438: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
439: fnd_message.raise_error;
440: elsif p_rec.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date 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.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date 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.appraisal_period_end_date
441: <> per_apr_shd.g_old_rec.appraisal_period_end_date then
442: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
443: fnd_message.raise_error;
444: elsif p_rec.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date 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.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.type
449: <> per_apr_shd.g_old_rec.type 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.appraisal_period_start_date
445: <> per_apr_shd.g_old_rec.appraisal_period_start_date then
446: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
447: fnd_message.raise_error;
448: elsif p_rec.type
449: <> per_apr_shd.g_old_rec.type 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.type
449: <> per_apr_shd.g_old_rec.type then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date 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.type
449: <> per_apr_shd.g_old_rec.type then
450: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
451: fnd_message.raise_error;
452: elsif p_rec.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date 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.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.status
457: <> per_apr_shd.g_old_rec.status 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.next_appraisal_date
453: <> per_apr_shd.g_old_rec.next_appraisal_date then
454: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
455: fnd_message.raise_error;
456: elsif p_rec.status
457: <> per_apr_shd.g_old_rec.status 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.status
457: <> per_apr_shd.g_old_rec.status then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.comments
461: <> per_apr_shd.g_old_rec.comments 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.status
457: <> per_apr_shd.g_old_rec.status then
458: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
459: fnd_message.raise_error;
460: elsif p_rec.comments
461: <> per_apr_shd.g_old_rec.comments 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.comments
461: <> per_apr_shd.g_old_rec.comments then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_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.comments
461: <> per_apr_shd.g_old_rec.comments then
462: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
463: fnd_message.raise_error;
464: elsif p_rec.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_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.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category 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.overall_performance_level_id
465: <> per_apr_shd.g_old_rec.overall_performance_level_id then
466: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
467: fnd_message.raise_error;
468: elsif p_rec.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category 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.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 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.attribute_category
469: <> per_apr_shd.g_old_rec.attribute_category then
470: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
471: fnd_message.raise_error;
472: elsif p_rec.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 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.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 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.attribute1
473: <> per_apr_shd.g_old_rec.attribute1 then
474: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
475: fnd_message.raise_error;
476: elsif p_rec.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 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.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 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.attribute2
477: <> per_apr_shd.g_old_rec.attribute2 then
478: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
479: fnd_message.raise_error;
480: elsif p_rec.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 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.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 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.attribute3
481: <> per_apr_shd.g_old_rec.attribute3 then
482: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
483: fnd_message.raise_error;
484: elsif p_rec.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 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.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 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.attribute4
485: <> per_apr_shd.g_old_rec.attribute4 then
486: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
487: fnd_message.raise_error;
488: elsif p_rec.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 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.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 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.attribute5
489: <> per_apr_shd.g_old_rec.attribute5 then
490: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
491: fnd_message.raise_error;
492: elsif p_rec.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 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.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.attribute7
497: <> per_apr_shd.g_old_rec.attribute7 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.attribute6
493: <> per_apr_shd.g_old_rec.attribute6 then
494: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
495: fnd_message.raise_error;
496: elsif p_rec.attribute7
497: <> per_apr_shd.g_old_rec.attribute7 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.attribute7
497: <> per_apr_shd.g_old_rec.attribute7 then
498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500: elsif p_rec.attribute8
501: <> per_apr_shd.g_old_rec.attribute8 then
502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 499: fnd_message.raise_error;

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

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

498: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
499: fnd_message.raise_error;
500: elsif p_rec.attribute8
501: <> per_apr_shd.g_old_rec.attribute8 then
502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 503: fnd_message.raise_error;

499: fnd_message.raise_error;
500: elsif p_rec.attribute8
501: <> per_apr_shd.g_old_rec.attribute8 then
502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;

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

502: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 507: fnd_message.raise_error;

503: fnd_message.raise_error;
504: elsif p_rec.attribute9
505: <> per_apr_shd.g_old_rec.attribute9 then
506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;

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

506: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 511: fnd_message.raise_error;

507: fnd_message.raise_error;
508: elsif p_rec.attribute10
509: <> per_apr_shd.g_old_rec.attribute10 then
510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;

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

510: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 515: fnd_message.raise_error;

511: fnd_message.raise_error;
512: elsif p_rec.attribute11
513: <> per_apr_shd.g_old_rec.attribute11 then
514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;

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

514: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 519: fnd_message.raise_error;

515: fnd_message.raise_error;
516: elsif p_rec.attribute12
517: <> per_apr_shd.g_old_rec.attribute12 then
518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;

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

518: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 523: fnd_message.raise_error;

519: fnd_message.raise_error;
520: elsif p_rec.attribute13
521: <> per_apr_shd.g_old_rec.attribute13 then
522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;

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

522: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 527: fnd_message.raise_error;

523: fnd_message.raise_error;
524: elsif p_rec.attribute14
525: <> per_apr_shd.g_old_rec.attribute14 then
526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;

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

526: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 531: fnd_message.raise_error;

527: fnd_message.raise_error;
528: elsif p_rec.attribute15
529: <> per_apr_shd.g_old_rec.attribute15 then
530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;

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

530: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 535: fnd_message.raise_error;

531: fnd_message.raise_error;
532: elsif p_rec.attribute16
533: <> per_apr_shd.g_old_rec.attribute16 then
534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;

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

534: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 539: fnd_message.raise_error;

535: fnd_message.raise_error;
536: elsif p_rec.attribute17
537: <> per_apr_shd.g_old_rec.attribute17 then
538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;

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

538: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 543: fnd_message.raise_error;

539: fnd_message.raise_error;
540: elsif p_rec.attribute18
541: <> per_apr_shd.g_old_rec.attribute18 then
542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;

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

542: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 547: fnd_message.raise_error;

543: fnd_message.raise_error;
544: elsif p_rec.attribute19
545: <> per_apr_shd.g_old_rec.attribute19 then
546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;

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

546: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 551: fnd_message.raise_error;

547: fnd_message.raise_error;
548: elsif p_rec.attribute20
549: <> per_apr_shd.g_old_rec.attribute20 then
550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;

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

550: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 555: fnd_message.raise_error;

551: fnd_message.raise_error;
552: elsif p_rec.system_type
553: <> per_apr_shd.g_old_rec.system_type then
554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;

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

554: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 559: fnd_message.raise_error;

555: fnd_message.raise_error;
556: elsif p_rec.system_params
557: <> per_apr_shd.g_old_rec.system_params then
558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;

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

558: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 563: fnd_message.raise_error;

559: fnd_message.raise_error;
560: elsif p_rec.appraisee_access
561: <> per_apr_shd.g_old_rec.appraisee_access then
562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;

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

562: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 567: fnd_message.raise_error;

563: fnd_message.raise_error;
564: elsif p_rec.main_appraiser_id
565: <> per_apr_shd.g_old_rec.main_appraiser_id then
566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;

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

566: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 571: fnd_message.raise_error;

567: fnd_message.raise_error;
568: elsif p_rec.assignment_id
569: <> per_apr_shd.g_old_rec.assignment_id then
570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;

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

570: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 575: fnd_message.raise_error;

571: fnd_message.raise_error;
572: elsif p_rec.assignment_start_date
573: <> per_apr_shd.g_old_rec.assignment_start_date then
574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;

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

574: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 579: fnd_message.raise_error;

575: fnd_message.raise_error;
576: elsif p_rec.assignment_business_group_id
577: <> per_apr_shd.g_old_rec.assignment_business_group_id then
578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;

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

578: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 583: fnd_message.raise_error;

579: fnd_message.raise_error;
580: elsif p_rec.assignment_organization_id
581: <> per_apr_shd.g_old_rec.assignment_organization_id then
582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;

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

582: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 587: fnd_message.raise_error;

583: fnd_message.raise_error;
584: elsif p_rec.assignment_job_id
585: <> per_apr_shd.g_old_rec.assignment_job_id then
586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;

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

586: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 591: fnd_message.raise_error;

587: fnd_message.raise_error;
588: elsif p_rec.assignment_position_id
589: <> per_apr_shd.g_old_rec.assignment_position_id then
590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;

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

590: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 595: fnd_message.raise_error;

591: fnd_message.raise_error;
592: elsif p_rec.assignment_grade_id
593: <> per_apr_shd.g_old_rec.assignment_grade_id then
594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;

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

594: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 599: fnd_message.raise_error;

595: fnd_message.raise_error;
596: elsif p_rec.potential_readiness_level
597: <> per_apr_shd.g_old_rec.potential_readiness_level then
598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;

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

598: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 603: fnd_message.raise_error;

599: fnd_message.raise_error;
600: elsif p_rec.potential_short_term_workopp
601: <> per_apr_shd.g_old_rec.potential_short_term_workopp then
602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;

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

602: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 607: fnd_message.raise_error;

603: fnd_message.raise_error;
604: elsif p_rec.potential_long_term_workopp
605: <> per_apr_shd.g_old_rec.potential_long_term_workopp then
606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;

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

606: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then
614: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');

Line 611: fnd_message.raise_error;

607: fnd_message.raise_error;
608: elsif p_rec.potential_details
609: <> per_apr_shd.g_old_rec.potential_details then
610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then
614: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
615: fnd_message.raise_error;

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

610: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then
614: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
615: fnd_message.raise_error;
616:
617: end if;
618:

Line 615: fnd_message.raise_error;

611: fnd_message.raise_error;
612: elsif p_rec.event_id
613: <> per_apr_shd.g_old_rec.event_id then
614: fnd_message.set_name('PER','PER_52458_APR_UPD_PUBLSHD_APR');
615: fnd_message.raise_error;
616:
617: end if;
618:
619:

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

683:
684: if csr_answer_set_exists%found then
685: -- answer set does exists, thus cannot update => error!
686: close csr_answer_set_exists;
687: fnd_message.set_name('PER','PER_52457_APR_UPD_COMPLTD_APR');
688: fnd_message.raise_error;
689: end if;
690: close csr_answer_set_exists;
691: else

Line 688: fnd_message.raise_error;

684: if csr_answer_set_exists%found then
685: -- answer set does exists, thus cannot update => error!
686: close csr_answer_set_exists;
687: fnd_message.set_name('PER','PER_52457_APR_UPD_COMPLTD_APR');
688: fnd_message.raise_error;
689: end if;
690: close csr_answer_set_exists;
691: else
692: null;

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

1759: -- Determine whether each of the dates are valid
1760: l_valid :=
1761: validate_date(p_appraisal_period_start_date, p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1762: if not l_valid then
1763: fnd_message.set_name('PER','PER_52452_APR_INVALID_START'); -- Fix 2516903
1764: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE');
1765: --fnd_message.raise_error;
1766: end if;
1767:

Line 1765: --fnd_message.raise_error;

1761: validate_date(p_appraisal_period_start_date, p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1762: if not l_valid then
1763: fnd_message.set_name('PER','PER_52452_APR_INVALID_START'); -- Fix 2516903
1764: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE');
1765: --fnd_message.raise_error;
1766: end if;
1767:
1768: hr_utility.set_location(l_proc,20);
1769:

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

1769:
1770: l_valid :=
1771: validate_date(p_appraisal_date,p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1772: if not l_valid then
1773: fnd_message.set_name('PER','PER_52453_APR_INVALID_APR_DATE');
1774: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1775: --fnd_message.raise_error;
1776: end if;
1777:

Line 1775: --fnd_message.raise_error;

1771: validate_date(p_appraisal_date,p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1772: if not l_valid then
1773: fnd_message.set_name('PER','PER_52453_APR_INVALID_APR_DATE');
1774: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1775: --fnd_message.raise_error;
1776: end if;
1777:
1778: hr_utility.set_location(l_proc,30);
1779:

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

1779:
1780: l_valid :=
1781: validate_date(p_appraisal_period_end_date, p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1782: if not l_valid then
1783: fnd_message.set_name('PER','PER_52454_APR_INVALID_END'); -- Fix 2485178
1784: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_END_DATE');
1785: --fnd_message.raise_error;
1786: end if;
1787:

Line 1785: --fnd_message.raise_error;

1781: validate_date(p_appraisal_period_end_date, p_appraisee_person_id,l_term_emp,l_term_cwk,l_future_term);
1782: if not l_valid then
1783: fnd_message.set_name('PER','PER_52454_APR_INVALID_END'); -- Fix 2485178
1784: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_PERIOD_END_DATE');
1785: --fnd_message.raise_error;
1786: end if;
1787:
1788: hr_utility.set_location(l_proc,40);
1789:

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

1797: else
1798: l_valid :=
1799: validate_date(p_appraisal_date, p_appraiser_person_id,l_term_emp,l_term_cwk,l_future_term);
1800: if not l_valid then
1801: fnd_message.set_name('PER','PER_52455_APR_INVALID_APR_DATE');
1802: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1803: -- fnd_message.raise_error;
1804: end if;
1805: end if;

Line 1803: -- fnd_message.raise_error;

1799: validate_date(p_appraisal_date, p_appraiser_person_id,l_term_emp,l_term_cwk,l_future_term);
1800: if not l_valid then
1801: fnd_message.set_name('PER','PER_52455_APR_INVALID_APR_DATE');
1802: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE');
1803: -- fnd_message.raise_error;
1804: end if;
1805: end if;
1806:
1807:

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

2142: open csr_apr_exists_in_per_part;
2143: fetch csr_apr_exists_in_per_part into l_exists;
2144: if csr_apr_exists_in_per_part%found then
2145: close csr_apr_exists_in_per_part;
2146: fnd_message.set_name('PER','PER_52450_APR_ANSWERS_EXIST');
2147: fnd_message.raise_error;
2148: end if;
2149: close csr_apr_exists_in_per_part;
2150:

Line 2147: fnd_message.raise_error;

2143: fetch csr_apr_exists_in_per_part into l_exists;
2144: if csr_apr_exists_in_per_part%found then
2145: close csr_apr_exists_in_per_part;
2146: fnd_message.set_name('PER','PER_52450_APR_ANSWERS_EXIST');
2147: fnd_message.raise_error;
2148: end if;
2149: close csr_apr_exists_in_per_part;
2150:
2151: hr_utility.set_location(l_proc,7);

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

2153: open csr_apr_exists_in_hr_qsa;
2154: fetch csr_apr_exists_in_hr_qsa into l_exists;
2155: if csr_apr_exists_in_hr_qsa%found then
2156: close csr_apr_exists_in_hr_qsa;
2157: fnd_message.set_name('PER','PER_52451_APR_PARTICIP_EXIST');
2158: fnd_message.raise_error;
2159: end if;
2160: close csr_apr_exists_in_hr_qsa;
2161:

Line 2158: fnd_message.raise_error;

2154: fetch csr_apr_exists_in_hr_qsa into l_exists;
2155: if csr_apr_exists_in_hr_qsa%found then
2156: close csr_apr_exists_in_hr_qsa;
2157: fnd_message.set_name('PER','PER_52451_APR_PARTICIP_EXIST');
2158: fnd_message.raise_error;
2159: end if;
2160: close csr_apr_exists_in_hr_qsa;
2161:
2162: hr_utility.set_location('Leaving: '|| l_proc, 10);

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

2232: FETCH csr_chk_plan_id INTO l_plan_id;
2233: CLOSE csr_chk_plan_id;
2234:
2235: IF l_plan_id IS null THEN
2236: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
2237: fnd_message.raise_error;
2238: END IF;
2239:
2240: END IF;

Line 2237: fnd_message.raise_error;

2233: CLOSE csr_chk_plan_id;
2234:
2235: IF l_plan_id IS null THEN
2236: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
2237: fnd_message.raise_error;
2238: END IF;
2239:
2240: END IF;
2241:

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

2323: p_effective_date => p_effective_date
2324: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2325: ,p_lookup_code => upper(p_offline_status)
2326: ) THEN
2327: fnd_message.set_name('PER', 'HR_34568_INV_OFFLINE_STATUS');
2328: fnd_message.raise_error;
2329: END IF;
2330:
2331: END IF;

Line 2328: fnd_message.raise_error;

2324: ,p_lookup_type => 'APPRAISAL_OFFLINE_STATUS'
2325: ,p_lookup_code => upper(p_offline_status)
2326: ) THEN
2327: fnd_message.set_name('PER', 'HR_34568_INV_OFFLINE_STATUS');
2328: fnd_message.raise_error;
2329: END IF;
2330:
2331: END IF;
2332: