DBA Data[Home] [Help]

APPS.PAY_LIV_BUS dependencies on FND_MESSAGE

Line 62: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: );

Line 141: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

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: --

Line 142: fnd_message.raise_error;

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

Line 204: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 205: fnd_message.set_token('PROCEDURE ', l_proc);

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: --

Line 206: fnd_message.set_token('STEP ', '5');

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) <>

Line 207: fnd_message.raise_error;

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)

Line 309: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

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;

Line 310: fnd_message.set_token('TABLE_NAME','input values');

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

Line 321: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');

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;

Line 322: fnd_message.set_token('TABLE_NAME','element links');

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: --

Line 333: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 334: fnd_message.set_token('PROCEDURE', l_proc);

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: --

Line 335: fnd_message.set_token('STEP','15');

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: -- ----------------------------------------------------------------------------

Line 336: fnd_message.raise_error;

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 >--------------------------|

Line 430: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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: --

Line 431: fnd_message.set_token('PROCEDURE', l_proc);

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;

Line 432: fnd_message.set_token('STEP','15');

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:

Line 433: fnd_message.raise_error;

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: --

Line 459: fnd_message.set_name('PAY', 'PAY_33084_LK_INP_VAL_WARN_ERR');

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: --

Line 460: fnd_message.raise_error;

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);

Line 566: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

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;

Line 567: fnd_message.set_token('PROCEDURE', 'PAY_LIV_BUS.CHK_FORMAT');

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: --

Line 568: fnd_message.set_token('STEP', '2');

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');

Line 569: fnd_message.raise_error;

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);

Line 572: fnd_message.set_name('PAY', 'PAY_6306_INPUT_VALUE_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);
574: fnd_message.raise_error;
575: --
576: end if;

Line 573: fnd_message.set_token('UNIT_OF_MEASURE', l_message_text);

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: --

Line 574: 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: --
578: End chk_format;

Line 636: fnd_message.set_name('PAY', 'HR_51976_ALL_MIN_LESS_MAX');

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:

Line 637: fnd_message.raise_error;

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);

Line 650: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');

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;

Line 651: fnd_message.raise_error;

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:

Line 665: fnd_message.set_name('PAY', 'PAY_6905_INPVAL_FORMULA_VAL');

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: --

Line 666: fnd_message.raise_error;

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);

Line 725: fnd_message.set_name('PAY', 'PAY_33080_LK_INP_VAL_NO_COST');

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;

Line 726: fnd_message.raise_error;

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;

Line 735: fnd_message.set_name('PAY', 'PAY_33081_LK_INP_VAL_UOM_COST');

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

Line 736: fnd_message.raise_error;

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

Line 741: fnd_message.set_name('PAY', 'PAY_33082_LK_INP_VAL_DIST_COST');

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:

Line 742: fnd_message.raise_error;

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);

Line 801: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');

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);

Line 802: fnd_message.raise_error;

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;

Line 860: fnd_message.set_name('PAY', 'PAY_33079_LK_INP_VAL_NO_UPD');

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;

Line 861: fnd_message.raise_error;

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;