[Home] [Help]
54:
55: -- The primary key is invalid therefore we must error
56:
57: hr_utility.set_message(801, 'HR_7220_INVALID_PRIMARY_KEY');
58: hr_multi_message.add(p_associated_column1 =>
59: nvl(p_associated_column1,'PER_APPRAISALS.PERSON_ID'));
60: else
61: close csr_sec_grp;
62: --
228: hr_utility.set_location('Leaving: '||l_proc,20);
229:
230: EXCEPTION
231: when app_exception.application_exception then
232: if hr_multi_message.exception_add
233: (p_associated_column1 => 'PER_APPRAISALS.OPEN'
234: ) then
235: raise;
236: end if;
579: hr_utility.set_location('Leaving: '||l_proc,20);
580:
581: EXCEPTION
582: when app_exception.application_exception then
583: if hr_multi_message.exception_add
584: (p_associated_column1 => 'PER_APPRAISALS.APPRAISER_PERSON_ID'
585: ) then
586: raise;
587: end if;
717:
718: hr_utility.set_location('Leaving: '|| l_proc, 10);
719: EXCEPTION
720: when app_exception.application_exception then
721: if hr_multi_message.exception_add
722: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_TEMPLATE_ID'
723: ) then
724: raise;
725: end if;
1018: hr_utility.set_location('Leaving:'|| l_proc, 10);
1019:
1020: EXCEPTION
1021: when app_exception.application_exception then
1022: if hr_multi_message.exception_add
1023: (p_associated_column1 => 'PER_APPRAISALS.MAIN_APPRAISER_ID'
1024: ) then
1025: raise;
1026: end if;
1115: end if;
1116: hr_utility.set_location('Leaving: '|| l_proc, 10);
1117: EXCEPTION
1118: when app_exception.application_exception then
1119: if hr_multi_message.exception_add
1120: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_TYPE'
1121: ) then
1122: raise;
1123: end if;
1215: hr_utility.set_location('Leaving: '|| l_proc, 10);
1216:
1217: EXCEPTION
1218: when app_exception.application_exception then
1219: if hr_multi_message.exception_add
1220: (p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_STATUS'
1221: ) then
1222: raise;
1223: end if;
1282:
1283: hr_utility.set_location('Leaving:'|| l_proc, 2);
1284: EXCEPTION
1285: when app_exception.application_exception then
1286: if hr_multi_message.exception_add
1287: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_DATE'
1288: ) then
1289: raise;
1290: end if;
1394: hr_utility.set_location('Leaving:'|| l_proc, 1);
1395:
1396: EXCEPTION
1397: when app_exception.application_exception then
1398: if hr_multi_message.exception_add
1399: (p_associated_column1 => 'PER_ASSESSMENTS.GROUP_INITIATOR_ID'
1400: ) then
1401: raise;
1402: end if;
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:
1600: hr_utility.set_location(l_proc,20);
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:
1610: hr_utility.set_location(l_proc,30);
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:
1620: hr_utility.set_location(l_proc,40);
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;
1638:
1644:
1645: if (p_appraisal_period_start_date > p_appraisal_date) then
1646:
1647: hr_utility.set_message(800, 'HR_52792_INVALID_APPR_DATE'); -- Fix 3061934.
1648: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.APPRAISAL_DATE'
1649: ,p_associated_column2 => 'PER_APPRAISALS.APPRAISAL_PERIOD_START_DATE'
1650: );
1651: --hr_utility.raise_error;
1652: end if;
1656: -- Fix 3061901
1657:
1658: if ( nvl(p_next_appraisal_date,hr_api.g_eot ) < p_appraisal_date) then
1659: hr_utility.set_message(800, 'HR_449014_INV_NEXT_APPR_DATE');
1660: hr_multi_message.add(p_associated_column1 => 'PER_APPRAISALS.NEXT_APPRAISAL_DATE'
1661: ,p_associated_column2 => 'PER_APPRAISALS.APPRAISAL_DATE'
1662: );
1663: --hr_utility.raise_error;
1664:
1797: hr_utility.set_location('Leaving: '|| l_proc, 10);
1798:
1799: EXCEPTION
1800: when app_exception.application_exception then
1801: if hr_multi_message.exception_add
1802: (p_associated_column1 => 'PER_APPRAISALS.OVERALL_PERFORMANCE_LEVEL_ID'
1803: ) then
1804: raise;
1805: end if;
2075:
2076: EXCEPTION
2077:
2078: WHEN app_exception.application_exception THEN
2079: IF hr_multi_message.exception_add
2080: (p_associated_column1 => 'PER_APPRAISALS.PLAN_ID')
2081: THEN
2082: hr_utility.set_location(' Leaving:'|| l_proc, 980);
2083: RAISE;
2163: hr_utility.set_location('Leaving:'|| l_proc, 970);
2164: EXCEPTION
2165:
2166: WHEN app_exception.application_exception THEN
2167: IF hr_multi_message.exception_add
2168: (p_associated_column1 => 'PER_APPRAISALS.OFFLINE_STATUS')
2169: THEN
2170: hr_utility.set_location(' Leaving:'|| l_proc, 980);
2171: RAISE;