63: close csr_sec_grp;
64: --
65: -- The primary key is invalid therefore we must error
66: --
67: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
68: hr_multi_message.add
69: (p_associated_column1
70: => nvl(p_associated_column1,'SCORECARD_ID')
71: );
147: --
148: -- The primary key is invalid therefore we must error
149: --
150: close csr_leg_code;
151: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
152: fnd_message.raise_error;
153: end if;
154: hr_utility.set_location(l_proc,30);
155: --
148: -- The primary key is invalid therefore we must error
149: --
150: close csr_leg_code;
151: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
152: fnd_message.raise_error;
153: end if;
154: hr_utility.set_location(l_proc,30);
155: --
156: -- Set the global variables so the values are
385: IF NOT per_pms_shd.api_updating
386: (p_scorecard_id => p_rec.scorecard_id
387: ,p_object_version_number => p_rec.object_version_number
388: ) THEN
389: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE ', l_proc);
391: fnd_message.set_token('STEP ', '5');
392: fnd_message.raise_error;
393: END IF;
386: (p_scorecard_id => p_rec.scorecard_id
387: ,p_object_version_number => p_rec.object_version_number
388: ) THEN
389: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE ', l_proc);
391: fnd_message.set_token('STEP ', '5');
392: fnd_message.raise_error;
393: END IF;
394: --
387: ,p_object_version_number => p_rec.object_version_number
388: ) THEN
389: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE ', l_proc);
391: fnd_message.set_token('STEP ', '5');
392: fnd_message.raise_error;
393: END IF;
394: --
395: hr_utility.set_location(l_proc, 10);
388: ) THEN
389: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
390: fnd_message.set_token('PROCEDURE ', l_proc);
391: fnd_message.set_token('STEP ', '5');
392: fnd_message.raise_error;
393: END IF;
394: --
395: hr_utility.set_location(l_proc, 10);
396: if nvl(p_rec.person_id,hr_api.g_number) <>
511: ,p_person_id;
512: CLOSE csr_chk_assignment_id;
513:
514: IF l_assignment_id IS null THEN
515: fnd_message.set_name('PER', 'HR_50263_PMS_INVALID_ASG');
516: fnd_message.raise_error;
517: END IF;
518:
519: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
512: CLOSE csr_chk_assignment_id;
513:
514: IF l_assignment_id IS null THEN
515: fnd_message.set_name('PER', 'HR_50263_PMS_INVALID_ASG');
516: fnd_message.raise_error;
517: END IF;
518:
519: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
520:
600: FETCH csr_chk_plan_id INTO l_plan_id;
601: CLOSE csr_chk_plan_id;
602:
603: IF l_plan_id IS null THEN
604: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
605: fnd_message.raise_error;
606: END IF;
607:
608: END IF;
601: CLOSE csr_chk_plan_id;
602:
603: IF l_plan_id IS null THEN
604: fnd_message.set_name('PER', 'HR_50264_PMS_INVALID_PLAN');
605: fnd_message.raise_error;
606: END IF;
607:
608: END IF;
609:
704: FETCH csr_chk_duplicate INTO l_dup;
705: CLOSE csr_chk_duplicate;
706:
707: IF l_dup = 'TRUE' THEN
708: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
709: fnd_message.raise_error;
710: END IF;
711:
712: END IF;
705: CLOSE csr_chk_duplicate;
706:
707: IF l_dup = 'TRUE' THEN
708: fnd_message.set_name('PER', 'HR_50265_PMS_DUP_SCORECARD');
709: fnd_message.raise_error;
710: END IF;
711:
712: END IF;
713:
826: --
827: -- Check that the scorecard's start date is not later than the end date.
828: --
829: IF p_start_date > p_end_date THEN
830: fnd_message.set_name('PER', 'HR_50266_PMS_START_END');
831: fnd_message.raise_error;
832: END IF;
833:
834: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
827: -- Check that the scorecard's start date is not later than the end date.
828: --
829: IF p_start_date > p_end_date THEN
830: fnd_message.set_name('PER', 'HR_50266_PMS_START_END');
831: fnd_message.raise_error;
832: END IF;
833:
834: IF g_debug THEN hr_utility.set_location(l_proc, 30); END IF;
835:
845:
846: IF p_start_date < l_pmp_start_date
847: OR p_end_date > l_pmp_end_date
848: THEN
849: fnd_message.set_name('PER', 'HR_50267_PMS_DATES_OUT_PLAN');
850: fnd_message.raise_error;
851: END IF;
852:
853: END IF;
846: IF p_start_date < l_pmp_start_date
847: OR p_end_date > l_pmp_end_date
848: THEN
849: fnd_message.set_name('PER', 'HR_50267_PMS_DATES_OUT_PLAN');
850: fnd_message.raise_error;
851: END IF;
852:
853: END IF;
854:
865: -- CLOSE csr_objs_outside_scorecard;
866: --
867: -- IF l_row_found = 'Y'
868: -- THEN
869: -- fnd_message.set_name('PER', 'HR_50296_PMS_OBJ_DATES');
870: -- fnd_message.raise_error;
871: -- END IF;
872: --
873: -- END IF;
866: --
867: -- IF l_row_found = 'Y'
868: -- THEN
869: -- fnd_message.set_name('PER', 'HR_50296_PMS_OBJ_DATES');
870: -- fnd_message.raise_error;
871: -- END IF;
872: --
873: -- END IF;
874:
1032: -- Check that p_creator_type is valid.
1033: --
1034: IF NOT (p_creator_type = 'MANUAL' OR p_creator_type = 'AUTO')
1035: THEN
1036: fnd_message.set_name('PER', 'HR_50269_PMS_CREATOR_TYPE');
1037: fnd_message.raise_error;
1038: END IF;
1039:
1040: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1033: --
1034: IF NOT (p_creator_type = 'MANUAL' OR p_creator_type = 'AUTO')
1035: THEN
1036: fnd_message.set_name('PER', 'HR_50269_PMS_CREATOR_TYPE');
1037: fnd_message.raise_error;
1038: END IF;
1039:
1040: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1041:
1120: (p_effective_date => p_effective_date
1121: ,p_lookup_type => 'HR_WPM_SCORECARD_STATUS'
1122: ,p_lookup_code => p_status_code)
1123: THEN
1124: fnd_message.set_name('PER', 'HR_50271_PMS_STATUS_CODE');
1125: fnd_message.raise_error;
1126: END IF;
1127:
1128: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1121: ,p_lookup_type => 'HR_WPM_SCORECARD_STATUS'
1122: ,p_lookup_code => p_status_code)
1123: THEN
1124: fnd_message.set_name('PER', 'HR_50271_PMS_STATUS_CODE');
1125: fnd_message.raise_error;
1126: END IF;
1127:
1128: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1129:
1191: CLOSE csr_appr_exists;
1192:
1193: IF(l_appr_exists = 'Y')
1194: THEN
1195: fnd_message.set_name('PER', 'HR_OBJ_END_DT_BEFR_TASK_ST');
1196: fnd_message.raise_error;
1197: END IF;
1198:
1199: hr_utility.set_location(' Leaving:'||l_proc, 980);
1192:
1193: IF(l_appr_exists = 'Y')
1194: THEN
1195: fnd_message.set_name('PER', 'HR_OBJ_END_DT_BEFR_TASK_ST');
1196: fnd_message.raise_error;
1197: END IF;
1198:
1199: hr_utility.set_location(' Leaving:'||l_proc, 980);
1200: END chk_obj_setting_deadline;
1293: CLOSE csr_has_objectives;
1294:
1295: IF l_exists = 'Y' THEN
1296: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1297: fnd_message.set_name('PER', 'HR_50229_PMS_DEL_NO_OBJ');
1298: fnd_message.raise_error;
1299: END IF;
1300:
1301: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1294:
1295: IF l_exists = 'Y' THEN
1296: IF g_debug THEN hr_utility.set_location(l_proc, 20); END IF;
1297: fnd_message.set_name('PER', 'HR_50229_PMS_DEL_NO_OBJ');
1298: fnd_message.raise_error;
1299: END IF;
1300:
1301: IF g_debug THEN hr_utility.set_location('Leaving:'|| l_proc, 970); END IF;
1302: