116: -- b) During insert.
117: --
118: hr_dflex_utility.ins_or_upd_descflex_attribs
119: (p_appl_short_name => 'PER'
120: ,p_descflex_name => 'PER_OBJECTIVES_LIBRARY'
121: ,p_attribute_category => p_rec.attribute_category
122: ,p_attribute1_name => 'ATTRIBUTE1'
123: ,p_attribute1_value => p_rec.attribute1
124: ,p_attribute2_name => 'ATTRIBUTE2'
274: -- Declare the cursor
275:
276: cursor chk_objective_name(c_p_valid_from date, c_p_valid_to date) is
277: select 'Y', nvl(valid_from,to_date('01/01/0001','MM/DD/YYYY')),nvl(valid_to,to_date('12/31/4712','MM/DD/YYYY'))
278: from per_objectives_library pml
279: where pml.objective_id <> nvl(p_objective_id, hr_api.g_number)
280: and upper(trim(pml.objective_name)) = upper(trim(p_objective_name))
281: and
282: (
441:
442: exception
443: when app_exception.application_exception then
444: if hr_multi_message.exception_add
445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'
446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'
447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;
442: exception
443: when app_exception.application_exception then
444: if hr_multi_message.exception_add
445: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.VALID_FROM'
446: ,p_associated_column2 => 'PER_OBJECTIVES_LIBRARY.VALID_TO'
447: ) then
448: hr_utility.set_location(' Leaving:'||l_proc, 980);
449: raise;
450: end if;
530:
531: exception
532: when app_exception.application_exception then
533: if hr_multi_message.exception_add
534: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.GROUP_CODE'
535: ) then
536: hr_utility.set_location(' Leaving:'||l_proc, 980);
537: raise;
538: end if;
618:
619: exception
620: when app_exception.application_exception then
621: if hr_multi_message.exception_add
622: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.PRIORITY_CODE'
623: ) then
624: hr_utility.set_location(' Leaving:'||l_proc, 980);
625: raise;
626: end if;
711:
712: exception
713: when app_exception.application_exception then
714: if hr_multi_message.exception_add
715: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
716: ) then
717: hr_utility.set_location(' Leaving:'||l_proc, 980);
718: raise;
719: end if;
793: --
794: -- Warn if the objective is not marked for appraisal.
795: --
796: if hr_multi_message.no_exclusive_error
797: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
798: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
799: ) then
800: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
801: end if;
794: -- Warn if the objective is not marked for appraisal.
795: --
796: if hr_multi_message.no_exclusive_error
797: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
798: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.APPRAISE_FLAG'
799: ) then
800: p_weighting_appraisal_warning := (p_appraise_flag = 'N');
801: end if;
802:
821:
822: exception
823: when app_exception.application_exception then
824: if hr_multi_message.exception_add
825: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.WEIGHTING_PERCENT'
826: ) then
827: hr_utility.set_location(' Leaving:'||l_proc, 980);
828: raise;
829: end if;
914:
915: exception
916: when app_exception.application_exception then
917: if hr_multi_message.exception_add
918: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
919: ) then
920: hr_utility.set_location(' Leaving:'||l_proc, 980);
921: raise;
922: end if;
987:
988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
989:
990: if hr_multi_message.no_exclusive_error
991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
993: ) then
994:
995: if p_measurement_style_code <> 'N_M'
988: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
989:
990: if hr_multi_message.no_exclusive_error
991: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
992: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
993: ) then
994:
995: if p_measurement_style_code <> 'N_M'
996: then
1009:
1010: exception
1011: when app_exception.application_exception then
1012: if hr_multi_message.exception_add
1013: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_NAME'
1014: ) then
1015: hr_utility.set_location(' Leaving:'||l_proc, 980);
1016: raise;
1017: end if;
1082:
1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1084:
1085: if hr_multi_message.no_exclusive_error
1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1088: ) then
1089:
1090: if p_measurement_style_code = 'QUANT_M'
1083: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1084:
1085: if hr_multi_message.no_exclusive_error
1086: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1087: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1088: ) then
1089:
1090: if p_measurement_style_code = 'QUANT_M'
1091: then
1104:
1105: exception
1106: when app_exception.application_exception then
1107: if hr_multi_message.exception_add
1108: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.TARGET_VALUE'
1109: ) then
1110: hr_utility.set_location(' Leaving:'||l_proc, 980);
1111: raise;
1112: end if;
1176:
1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1178:
1179: if hr_multi_message.no_exclusive_error
1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1182: ) then
1183:
1184: if p_measurement_style_code = 'QUANT_M'
1177: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1178:
1179: if hr_multi_message.no_exclusive_error
1180: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1181: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1182: ) then
1183:
1184: if p_measurement_style_code = 'QUANT_M'
1185: then
1215:
1216: exception
1217: when app_exception.application_exception then
1218: if hr_multi_message.exception_add
1219: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.UOM_CODE'
1220: ) then
1221: hr_utility.set_location(' Leaving:'||l_proc, 980);
1222: raise;
1223: end if;
1287:
1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1289:
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1293: ) then
1294:
1295: if p_measurement_style_code = 'QUANT_M'
1288: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1289:
1290: if hr_multi_message.no_exclusive_error
1291: (p_check_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1292: ,p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASUREMENT_STYLE_CODE'
1293: ) then
1294:
1295: if p_measurement_style_code = 'QUANT_M'
1296: then
1326:
1327: exception
1328: when app_exception.application_exception then
1329: if hr_multi_message.exception_add
1330: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.MEASURE_TYPE_CODE'
1331: ) then
1332: hr_utility.set_location(' Leaving:'||l_proc, 980);
1333: raise;
1334: end if;
1419:
1420: exception
1421: when app_exception.application_exception then
1422: if hr_multi_message.exception_add
1423: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.ELIGIBILITY_TYPE_CODE'
1424: ) then
1425: hr_utility.set_location(' Leaving:'||l_proc, 980);
1426: raise;
1427: end if;
1457: -- Internal Development use only.
1458: --
1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1458: --
1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --
1459: -- ---------------------------------------------------------------------
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --
1467: l_proc varchar2(72) := g_package||'chk_next_review_date';
1460: procedure chk_next_review_date
1461: (p_objective_id in per_objectives_library.objective_id%TYPE
1462: ,p_valid_from in per_objectives_library.valid_from%TYPE
1463: ,p_next_review_date in per_objectives_library.next_review_date%TYPE
1464: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1465: ) is
1466: --
1467: l_proc varchar2(72) := g_package||'chk_next_review_date';
1468: --
1514: -- Internal Development use only.
1515: --
1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1515: --
1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --
1516: -- ---------------------------------------------------------------------
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --
1524: l_proc varchar2(72) := g_package||'chk_target_date';
1517: procedure chk_target_date
1518: (p_objective_id in per_objectives_library.objective_id%TYPE
1519: ,p_valid_from in per_objectives_library.valid_from%TYPE
1520: ,p_target_date in per_objectives_library.target_date%TYPE
1521: ,p_object_version_number in per_objectives_library.object_version_number%TYPE
1522: ) is
1523: --
1524: l_proc varchar2(72) := g_package||'chk_target_date';
1525: --
1616:
1617: exception
1618: when app_exception.application_exception then
1619: if hr_multi_message.exception_add
1620: (p_associated_column1 => 'PER_OBJECTIVES_LIBRARY.OBJECTIVE_ID'
1621: ) then
1622: hr_utility.set_location(' Leaving:'||l_proc, 980);
1623: raise;
1624: end if;