58: close csr_sec_grp;
59: --
60: -- The primary key is invalid therefore we must error
61: --
62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
63: hr_multi_message.add
64: (p_associated_column1
65: => nvl(p_associated_column1,'LINK_INPUT_VALUE_ID')
66: );
137: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
138: -- The primary key is invalid therefore we must error
139: --
140: close csr_leg_code;
141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: end if;
144: hr_utility.set_location(l_proc,30);
145: --
146: -- Set the global variables so the values are
200: (p_link_input_value_id => p_rec.link_input_value_id
201: ,p_effective_date => p_effective_date
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
201: ,p_effective_date => p_effective_date
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
202: ,p_object_version_number => p_rec.object_version_number
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: IF nvl(p_rec.element_link_id, hr_api.g_number) <>
203: ) THEN
204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
205: fnd_message.set_token('PROCEDURE ', l_proc);
206: fnd_message.set_token('STEP ', '5');
207: fnd_message.raise_error;
208: END IF;
209: --
210: IF nvl(p_rec.element_link_id, hr_api.g_number) <>
211: nvl(pay_liv_shd.g_old_rec.element_link_id, hr_api.g_number)
305: ,p_base_key_column => 'INPUT_VALUE_ID'
306: ,p_base_key_value => p_input_value_id
307: ,p_from_date => p_validation_start_date
308: ,p_to_date => p_validation_end_date))) Then
309: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
310: fnd_message.set_token('TABLE_NAME','input values');
311: hr_multi_message.add
312: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.INPUT_VALUE_ID');
313: End If;
306: ,p_base_key_value => p_input_value_id
307: ,p_from_date => p_validation_start_date
308: ,p_to_date => p_validation_end_date))) Then
309: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
310: fnd_message.set_token('TABLE_NAME','input values');
311: hr_multi_message.add
312: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.INPUT_VALUE_ID');
313: End If;
314: If ((nvl(p_element_link_id, hr_api.g_number) <> hr_api.g_number) and
317: ,p_base_key_column => 'ELEMENT_LINK_ID'
318: ,p_base_key_value => p_element_link_id
319: ,p_from_date => p_validation_start_date
320: ,p_to_date => p_validation_end_date))) Then
321: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
322: fnd_message.set_token('TABLE_NAME','element links');
323: hr_multi_message.add
324: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.ELEMENT_LINK_ID');
325: End If;
318: ,p_base_key_value => p_element_link_id
319: ,p_from_date => p_validation_start_date
320: ,p_to_date => p_validation_end_date))) Then
321: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
322: fnd_message.set_token('TABLE_NAME','element links');
323: hr_multi_message.add
324: (p_associated_column1 => pay_liv_shd.g_tab_nam || '.ELEMENT_LINK_ID');
325: End If;
326: --
329: --
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
330: -- An unhandled or unexpected error has occurred which
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
331: -- we must report
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
332: --
333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
334: fnd_message.set_token('PROCEDURE', l_proc);
335: fnd_message.set_token('STEP','15');
336: fnd_message.raise_error;
337: End dt_update_validate;
338: --
339: -- ----------------------------------------------------------------------------
340: -- |--------------------------< dt_delete_validate >--------------------------|
426: --
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
427: -- An unhandled or unexpected error has occurred which
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
428: -- we must report
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
436:
429: --
430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
431: fnd_message.set_token('PROCEDURE', l_proc);
432: fnd_message.set_token('STEP','15');
433: fnd_message.raise_error;
434: --
435: End dt_delete_validate;
436:
437: --
455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: If (p_max_value is not null or p_min_value is not null) then
458: If p_warning_or_error is null Then
459: fnd_message.set_name('PAY', 'PAY_33084_LK_INP_VAL_WARN_ERR');
460: fnd_message.raise_error;
461: End If;
462: End if;
463: --
456: --
457: If (p_max_value is not null or p_min_value is not null) then
458: If p_warning_or_error is null Then
459: fnd_message.set_name('PAY', 'PAY_33084_LK_INP_VAL_WARN_ERR');
460: fnd_message.raise_error;
461: End If;
462: End if;
463: --
464: hr_utility.set_location(' Leaving:'||l_proc, 10);
562: and lookup_code = l_uom;
563: --
564: exception
565: when no_data_found then
566: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
567: fnd_message.set_token('PROCEDURE', 'PAY_LIV_BUS.CHK_FORMAT');
568: fnd_message.set_token('STEP', '2');
569: fnd_message.raise_error;
570: end;
563: --
564: exception
565: when no_data_found then
566: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
567: fnd_message.set_token('PROCEDURE', 'PAY_LIV_BUS.CHK_FORMAT');
568: fnd_message.set_token('STEP', '2');
569: fnd_message.raise_error;
570: end;
571: --
564: exception
565: when no_data_found then
566: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
567: fnd_message.set_token('PROCEDURE', 'PAY_LIV_BUS.CHK_FORMAT');
568: fnd_message.set_token('STEP', '2');
569: fnd_message.raise_error;
570: end;
571: --
572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
565: when no_data_found then
566: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
567: fnd_message.set_token('PROCEDURE', 'PAY_LIV_BUS.CHK_FORMAT');
568: fnd_message.set_token('STEP', '2');
569: fnd_message.raise_error;
570: end;
571: --
572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
573: fnd_message.set_token('UNIT_OF_MEASURE', l_message_text);
568: fnd_message.set_token('STEP', '2');
569: fnd_message.raise_error;
570: end;
571: --
572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
573: fnd_message.set_token('UNIT_OF_MEASURE', l_message_text);
574: fnd_message.raise_error;
575: --
576: end if;
569: fnd_message.raise_error;
570: end;
571: --
572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
573: fnd_message.set_token('UNIT_OF_MEASURE', l_message_text);
574: fnd_message.raise_error;
575: --
576: end if;
577: --
570: end;
571: --
572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_FORMAT');
573: fnd_message.set_token('UNIT_OF_MEASURE', l_message_text);
574: fnd_message.raise_error;
575: --
576: end if;
577: --
578: End chk_format;
632: );
633:
634: exception
635: When Others then
636: fnd_message.set_name('PAY', 'HR_51976_ALL_MIN_LESS_MAX');
637: fnd_message.raise_error;
638: end;
639: End If;
640:
633:
634: exception
635: When Others then
636: fnd_message.set_name('PAY', 'HR_51976_ALL_MIN_LESS_MAX');
637: fnd_message.raise_error;
638: end;
639: End If;
640:
641: hr_utility.set_location('l_min_max_failure '||l_min_max_failure,30);
646: then
647: p_default_range_warning := True;
648: Elsif nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'E'
649: then
650: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');
651: fnd_message.raise_error;
652: End if;
653: --
654: End If;
647: p_default_range_warning := True;
648: Elsif nvl(p_warning_or_error,pay_liv_shd.g_old_rec.warning_or_error) = 'E'
649: then
650: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');
651: fnd_message.raise_error;
652: End if;
653: --
654: End If;
655:
661: (p_min_value is not null
662: or p_max_value is not null
663: or p_warning_or_error is null) Then
664: --
665: fnd_message.set_name('PAY', 'PAY_6905_INPVAL_FORMULA_VAL');
666: fnd_message.raise_error;
667: --
668: End If;
669: --
662: or p_max_value is not null
663: or p_warning_or_error is null) Then
664: --
665: fnd_message.set_name('PAY', 'PAY_6905_INPVAL_FORMULA_VAL');
666: fnd_message.raise_error;
667: --
668: End If;
669: --
670: hr_utility.set_location(' Leaving:'||l_proc, 10);
721: Fetch C_element_link into l_costable_type;
722: Close C_element_link;
723:
724: If l_costable_type = 'N' and p_costed_flag <> 'N' Then
725: fnd_message.set_name('PAY', 'PAY_33080_LK_INP_VAL_NO_COST');
726: fnd_message.raise_error;
727: End if;
728:
729: Open C_input_values;
722: Close C_element_link;
723:
724: If l_costable_type = 'N' and p_costed_flag <> 'N' Then
725: fnd_message.set_name('PAY', 'PAY_33080_LK_INP_VAL_NO_COST');
726: fnd_message.raise_error;
727: End if;
728:
729: Open C_input_values;
730: Fetch C_input_values into l_name, l_uom;
731: Close C_input_values;
732:
733: If (l_uom <> 'M' and l_uom not like 'H%'
734: and p_costed_flag = 'Y') Then
735: fnd_message.set_name('PAY', 'PAY_33081_LK_INP_VAL_UOM_COST');
736: fnd_message.raise_error;
737: End If;
738:
739: If l_name <> 'Pay Value' Then
732:
733: If (l_uom <> 'M' and l_uom not like 'H%'
734: and p_costed_flag = 'Y') Then
735: fnd_message.set_name('PAY', 'PAY_33081_LK_INP_VAL_UOM_COST');
736: fnd_message.raise_error;
737: End If;
738:
739: If l_name <> 'Pay Value' Then
740: If l_costable_type = 'D' and p_costed_flag = 'Y' Then
737: End If;
738:
739: If l_name <> 'Pay Value' Then
740: If l_costable_type = 'D' and p_costed_flag = 'Y' Then
741: fnd_message.set_name('PAY', 'PAY_33082_LK_INP_VAL_DIST_COST');
742: fnd_message.raise_error;
743: End If;
744: End if;
745:
738:
739: If l_name <> 'Pay Value' Then
740: If l_costable_type = 'D' and p_costed_flag = 'Y' Then
741: fnd_message.set_name('PAY', 'PAY_33082_LK_INP_VAL_DIST_COST');
742: fnd_message.raise_error;
743: End If;
744: End if;
745:
746: hr_utility.set_location(' Leaving:'||l_proc, 10);
797: If nvl(l_contributions_used,'N') = 'Y'
798: and (l_name in ('Coverage',
799: 'EE Contr',
800: 'ER Contr')) Then
801: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
802: fnd_message.raise_error;
803: End If;
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
798: and (l_name in ('Coverage',
799: 'EE Contr',
800: 'ER Contr')) Then
801: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
802: fnd_message.raise_error;
803: End If;
804: --
805: hr_utility.set_location(' Leaving:'||l_proc, 10);
806: End chk_benefit_plan;
856: Open c_element_entry(l_element_type_id);
857: Loop
858: Fetch c_element_entry into l_exists;
859: If c_element_entry%found Then
860: fnd_message.set_name('PAY', 'PAY_33079_LK_INP_VAL_NO_UPD');
861: fnd_message.raise_error;
862: Else
863: exit;
864: End if;
857: Loop
858: Fetch c_element_entry into l_exists;
859: If c_element_entry%found Then
860: fnd_message.set_name('PAY', 'PAY_33079_LK_INP_VAL_NO_UPD');
861: fnd_message.raise_error;
862: Else
863: exit;
864: End if;
865: End Loop;