227: IF NOT per_pml_shd.api_updating
228: (p_objective_id => p_rec.objective_id
229: ,p_object_version_number => p_rec.object_version_number
230: ) THEN
231: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
232: fnd_message.set_token('PROCEDURE ', l_proc);
233: fnd_message.set_token('STEP ', '5');
234: fnd_message.raise_error;
235: END IF;
228: (p_objective_id => p_rec.objective_id
229: ,p_object_version_number => p_rec.object_version_number
230: ) THEN
231: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
232: fnd_message.set_token('PROCEDURE ', l_proc);
233: fnd_message.set_token('STEP ', '5');
234: fnd_message.raise_error;
235: END IF;
236:
229: ,p_object_version_number => p_rec.object_version_number
230: ) THEN
231: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
232: fnd_message.set_token('PROCEDURE ', l_proc);
233: fnd_message.set_token('STEP ', '5');
234: fnd_message.raise_error;
235: END IF;
236:
237: End chk_non_updateable_args;
230: ) THEN
231: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
232: fnd_message.set_token('PROCEDURE ', l_proc);
233: fnd_message.set_token('STEP ', '5');
234: fnd_message.raise_error;
235: END IF;
236:
237: End chk_non_updateable_args;
238: --
338: open chk_objective_name(nvl(p_valid_from,to_date('01/01/0001','MM/DD/YYYY')), nvl(p_valid_to,to_date('12/31/4712','MM/DD/YYYY')));
339: fetch chk_objective_name into l_dup,l_st_date,l_end_date;
340: loop
341: exit when chk_objective_name%NOTFOUND;
342: fnd_message.set_name('PER','HR_50181_WPM_OBJ_EXIST_WARN');
343: fnd_message.set_token('START_DATE',l_st_date);
344: fnd_message.set_token('END_DATE',l_end_date);
345: if(hr_multi_message.is_message_list_enabled) then
346: hr_multi_message.add
339: fetch chk_objective_name into l_dup,l_st_date,l_end_date;
340: loop
341: exit when chk_objective_name%NOTFOUND;
342: fnd_message.set_name('PER','HR_50181_WPM_OBJ_EXIST_WARN');
343: fnd_message.set_token('START_DATE',l_st_date);
344: fnd_message.set_token('END_DATE',l_end_date);
345: if(hr_multi_message.is_message_list_enabled) then
346: hr_multi_message.add
347: (
340: loop
341: exit when chk_objective_name%NOTFOUND;
342: fnd_message.set_name('PER','HR_50181_WPM_OBJ_EXIST_WARN');
343: fnd_message.set_token('START_DATE',l_st_date);
344: fnd_message.set_token('END_DATE',l_end_date);
345: if(hr_multi_message.is_message_list_enabled) then
346: hr_multi_message.add
347: (
348: p_message_type => hr_multi_message.G_ERROR_MSG
353: end loop;
354: close chk_objective_name;
355: p_duplicate_name_warning := false;
356: if (l_dup ='Y') then
357: fnd_message.raise_error;
358: end if;
359:
360: IF g_debug THEN hr_utility.trace('p_duplicate_name_warning: '||l_dup); END IF;
361: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
430: --
431: -- Checks that the valid from date is not greater than the valid to date.
432: --
433: if (p_valid_from > p_valid_to) then
434: fnd_message.set_name('PER','HR_50187_WPM_INV_DATE_FROM_TO');
435: fnd_message.raise_error;
436: end if;
437:
438: END IF;
431: -- Checks that the valid from date is not greater than the valid to date.
432: --
433: if (p_valid_from > p_valid_to) then
434: fnd_message.set_name('PER','HR_50187_WPM_INV_DATE_FROM_TO');
435: fnd_message.raise_error;
436: end if;
437:
438: END IF;
439:
520: ,p_lookup_type => 'HR_WPM_GROUP'
521: ,p_lookup_code => p_group_code
522: ) then
523: -- Error: Invalid Group
524: fnd_message.set_name('PER', 'HR_50188_WPM_INV_GROUP');
525: fnd_message.raise_error;
526: end if;
527: end if;
528:
521: ,p_lookup_code => p_group_code
522: ) then
523: -- Error: Invalid Group
524: fnd_message.set_name('PER', 'HR_50188_WPM_INV_GROUP');
525: fnd_message.raise_error;
526: end if;
527: end if;
528:
529: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
608: ,p_lookup_type => 'HR_WPM_PRIORITY'
609: ,p_lookup_code => p_priority_code
610: ) then
611: -- Error: Invalid Group
612: fnd_message.set_name('PER', 'HR_50189_WPM_INV_PRIORITY');
613: fnd_message.raise_error;
614: end if;
615: end if;
616:
609: ,p_lookup_code => p_priority_code
610: ) then
611: -- Error: Invalid Group
612: fnd_message.set_name('PER', 'HR_50189_WPM_INV_PRIORITY');
613: fnd_message.raise_error;
614: end if;
615: end if;
616:
617: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
702: ,p_lookup_type => 'YES_NO'
703: ,p_lookup_code => p_appraise_flag
704: ) then
705: -- Error: Invalid Group
706: fnd_message.set_name('PER', 'HR_50199_WPM_APPRAISE_FLAG');
707: fnd_message.raise_error;
708: end if;
709:
710: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
703: ,p_lookup_code => p_appraise_flag
704: ) then
705: -- Error: Invalid Group
706: fnd_message.set_name('PER', 'HR_50199_WPM_APPRAISE_FLAG');
707: fnd_message.raise_error;
708: end if;
709:
710: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
711:
804: --
805: -- Checks that the weighting_percent is not a negative number
806: --
807: if (p_weighting_percent < 0) then
808: fnd_message.set_name('PER','HR_50193_WPM_WEIGHT_VALUE');
809: fnd_message.raise_error;
810: end if;
811:
812: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
805: -- Checks that the weighting_percent is not a negative number
806: --
807: if (p_weighting_percent < 0) then
808: fnd_message.set_name('PER','HR_50193_WPM_WEIGHT_VALUE');
809: fnd_message.raise_error;
810: end if;
811:
812: IF g_debug THEN hr_utility.set_location(l_proc, 50); END IF;
813: --
905: ,p_lookup_type => 'HR_WPM_MEASURE'
906: ,p_lookup_code => p_measurement_style_code
907: ) then
908: -- Error: Invalid Group
909: fnd_message.set_name('PER', 'HR_50194_WPM_INV_MEASR_STYL');
910: fnd_message.raise_error;
911: end if;
912:
913: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
906: ,p_lookup_code => p_measurement_style_code
907: ) then
908: -- Error: Invalid Group
909: fnd_message.set_name('PER', 'HR_50194_WPM_INV_MEASR_STYL');
910: fnd_message.raise_error;
911: end if;
912:
913: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
914:
1205: ,p_lookup_type => 'HR_WPM_MEASURE_UOM'
1206: ,p_lookup_code => p_uom_code
1207: ) then
1208: -- Error: Invalid Group
1209: fnd_message.set_name('PER', 'HR_50195_WPM_INV_UOM');
1210: fnd_message.raise_error;
1211: end if;
1212: end if;
1213:
1206: ,p_lookup_code => p_uom_code
1207: ) then
1208: -- Error: Invalid Group
1209: fnd_message.set_name('PER', 'HR_50195_WPM_INV_UOM');
1210: fnd_message.raise_error;
1211: end if;
1212: end if;
1213:
1214: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1316: ,p_lookup_type => 'HR_WPM_MEASURE_TYPE'
1317: ,p_lookup_code => p_measure_type_code
1318: ) then
1319: -- Error: Invalid Group
1320: fnd_message.set_name('PER', 'HR_50196_WPM_INV_MEASR_TYPE');
1321: fnd_message.raise_error;
1322: end if;
1323: end if;
1324:
1317: ,p_lookup_code => p_measure_type_code
1318: ) then
1319: -- Error: Invalid Group
1320: fnd_message.set_name('PER', 'HR_50196_WPM_INV_MEASR_TYPE');
1321: fnd_message.raise_error;
1322: end if;
1323: end if;
1324:
1325: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1410: ,p_lookup_type => 'HR_WPM_ELIGIBILITY'
1411: ,p_lookup_code => p_eligibility_type_code
1412: ) then
1413: -- Error: Invalid Group
1414: fnd_message.set_name('PER', 'HR_50197_WPM_INV_ELIGY_TYPE');
1415: fnd_message.raise_error;
1416: end if;
1417:
1418: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1411: ,p_lookup_code => p_eligibility_type_code
1412: ) then
1413: -- Error: Invalid Group
1414: fnd_message.set_name('PER', 'HR_50197_WPM_INV_ELIGY_TYPE');
1415: fnd_message.raise_error;
1416: end if;
1417:
1418: IF g_debug THEN hr_utility.set_location(' Leaving:'|| l_proc, 970); END IF;
1419: