eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.PAY_IVL_BUS dependencies on FND_MESSAGE

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

62: close csr_sec_grp;
63: --
64: -- The primary key is invalid therefore we must error
65: --
66: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
67: hr_multi_message.add
68: (p_associated_column1
69: => nvl(p_associated_column1,'INPUT_VALUE_ID')
70: );

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

142: --
143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148:
149: end if;
150: hr_utility.set_location(l_proc,30);

Line 147: fnd_message.raise_error;

143: -- The primary key is invalid therefore we must error
144: --
145: close csr_leg_code;
146: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148:
149: end if;
150: hr_utility.set_location(l_proc,30);
151: --

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

206: if p_warning_or_error = 'E' then
207: --
208: hr_utility.set_location(l_proc,30);
209: --
210: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');
211: fnd_message.raise_error;
212: --
213: elsif p_warning_or_error = 'W' then
214: --

Line 211: fnd_message.raise_error;

207: --
208: hr_utility.set_location(l_proc,30);
209: --
210: fnd_message.set_name('PAY', 'HR_INPVAL_DEFAULT_INVALID');
211: fnd_message.raise_error;
212: --
213: elsif p_warning_or_error = 'W' then
214: --
215: hr_utility.set_location(l_proc,40);

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

273: (p_input_value_id => p_rec.input_value_id
274: ,p_effective_date => p_effective_date
275: ,p_object_version_number => p_rec.object_version_number
276: ) THEN
277: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE ', l_proc);
279: fnd_message.set_token('STEP ', '5');
280: fnd_message.raise_error;
281: END IF;

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

274: ,p_effective_date => p_effective_date
275: ,p_object_version_number => p_rec.object_version_number
276: ) THEN
277: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE ', l_proc);
279: fnd_message.set_token('STEP ', '5');
280: fnd_message.raise_error;
281: END IF;
282:

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

275: ,p_object_version_number => p_rec.object_version_number
276: ) THEN
277: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE ', l_proc);
279: fnd_message.set_token('STEP ', '5');
280: fnd_message.raise_error;
281: END IF;
282:
283: End chk_non_updateable_args;

Line 280: fnd_message.raise_error;

276: ) THEN
277: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
278: fnd_message.set_token('PROCEDURE ', l_proc);
279: fnd_message.set_token('STEP ', '5');
280: fnd_message.raise_error;
281: END IF;
282:
283: End chk_non_updateable_args;
284: --

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

356: ,p_base_key_value => p_element_type_id
357:
358: ,p_from_date => p_validation_start_date
359: ,p_to_date => p_validation_end_date))) Then
360: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
361: fnd_message.set_token('TABLE_NAME','element types');
362: hr_multi_message.add
363: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
364: End If;

Line 361: fnd_message.set_token('TABLE_NAME','element types');

357:
358: ,p_from_date => p_validation_start_date
359: ,p_to_date => p_validation_end_date))) Then
360: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
361: fnd_message.set_token('TABLE_NAME','element types');
362: hr_multi_message.add
363: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
364: End If;
365: --

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

368: --
369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_update_validate;

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

369: -- An unhandled or unexpected error has occurred which
370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_update_validate;
377: --

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

370: -- we must report
371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_update_validate;
377: --
378: -- ----------------------------------------------------------------------------

Line 375: fnd_message.raise_error;

371: --
372: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
373: fnd_message.set_token('PROCEDURE', l_proc);
374: fnd_message.set_token('STEP','15');
375: fnd_message.raise_error;
376: End dt_update_validate;
377: --
378: -- ----------------------------------------------------------------------------
379: -- |--------------------------< dt_delete_validate >--------------------------|

Line 470: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

466: ,p_base_key_value => p_input_value_id
467: ,p_from_date => p_validation_start_date
468: ,p_to_date => p_validation_end_date
469: )) Then
470: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
471: fnd_message.set_token('TABLE_NAME','acty base rt');
472: hr_multi_message.add;
473: End If;
474: If (dt_api.rows_exist

Line 471: fnd_message.set_token('TABLE_NAME','acty base rt');

467: ,p_from_date => p_validation_start_date
468: ,p_to_date => p_validation_end_date
469: )) Then
470: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
471: fnd_message.set_token('TABLE_NAME','acty base rt');
472: hr_multi_message.add;
473: End If;
474: If (dt_api.rows_exist
475: (p_base_table_name => 'pay_link_input_values_f'

Line 482: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');

478: ,p_base_key_value => p_input_value_id
479: ,p_from_date => p_validation_start_date
480: ,p_to_date => p_validation_end_date
481: )) Then
482: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
483: fnd_message.set_token('TABLE_NAME','link input values');
484: hr_multi_message.add;
485: End If;
486: --

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

479: ,p_from_date => p_validation_start_date
480: ,p_to_date => p_validation_end_date
481: )) Then
482: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
483: fnd_message.set_token('TABLE_NAME','link input values');
484: hr_multi_message.add;
485: End If;
486: --
487: End If;

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

491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --

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

492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;

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

493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;
501:

Line 498: fnd_message.raise_error;

494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: --
500: End dt_delete_validate;
501:
502: --

Line 576: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');

572:
573: hr_utility.set_location(' Entering:'|| l_proc, 10);
574:
575: if p_lookup_type is not null and upper(p_uom) <> 'C' then
576: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
577: fnd_message.raise_error;
578: else
579: open csr_lookup;
580: fetch csr_lookup into l_dummy;

Line 577: fnd_message.raise_error;

573: hr_utility.set_location(' Entering:'|| l_proc, 10);
574:
575: if p_lookup_type is not null and upper(p_uom) <> 'C' then
576: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
577: fnd_message.raise_error;
578: else
579: open csr_lookup;
580: fetch csr_lookup into l_dummy;
581: if csr_lookup%notfound then

Line 583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

579: open csr_lookup;
580: fetch csr_lookup into l_dummy;
581: if csr_lookup%notfound then
582: close csr_lookup;
583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
584: fnd_message.raise_error;
585: end if;
586: close csr_lookup;
587: end if;

Line 584: fnd_message.raise_error;

580: fetch csr_lookup into l_dummy;
581: if csr_lookup%notfound then
582: close csr_lookup;
583: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
584: fnd_message.raise_error;
585: end if;
586: close csr_lookup;
587: end if;
588:

Line 635: fnd_message.set_name('PAY','PAY_34116_INVALID_FORMULA');

631: open csr_formula;
632: fetch csr_formula into l_dummy;
633: if csr_formula%notfound then
634: close csr_formula;
635: fnd_message.set_name('PAY','PAY_34116_INVALID_FORMULA');
636: fnd_message.raise_error;
637: end if;
638: close csr_formula;
639: end if;

Line 636: fnd_message.raise_error;

632: fetch csr_formula into l_dummy;
633: if csr_formula%notfound then
634: close csr_formula;
635: fnd_message.set_name('PAY','PAY_34116_INVALID_FORMULA');
636: fnd_message.raise_error;
637: end if;
638: close csr_formula;
639: end if;
640:

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

723: -- Note - need to pass database format to formula.
724: l_inputs(i).value := p_default_value;
725: Else
726: -- No context recognised.
727: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
728: fnd_message.set_token('PROCEDURE', l_proc);
729: fnd_message.set_token('STEP','10');
730: fnd_message.raise_error;
731: End if;

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

724: l_inputs(i).value := p_default_value;
725: Else
726: -- No context recognised.
727: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
728: fnd_message.set_token('PROCEDURE', l_proc);
729: fnd_message.set_token('STEP','10');
730: fnd_message.raise_error;
731: End if;
732: End loop;

Line 729: fnd_message.set_token('STEP','10');

725: Else
726: -- No context recognised.
727: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
728: fnd_message.set_token('PROCEDURE', l_proc);
729: fnd_message.set_token('STEP','10');
730: fnd_message.raise_error;
731: End if;
732: End loop;
733: End if;

Line 730: fnd_message.raise_error;

726: -- No context recognised.
727: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
728: fnd_message.set_token('PROCEDURE', l_proc);
729: fnd_message.set_token('STEP','10');
730: fnd_message.raise_error;
731: End if;
732: End loop;
733: End if;
734: --

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

741: --
742: -- Now obtain the return values. There should be
743: -- exactly two outputs.
744: If l_outputs.count <> 2 then
745: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
746: fnd_message.set_token('PROCEDURE', l_proc);
747: fnd_message.set_token('STEP','20');
748: fnd_message.raise_error;
749: End if;

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

742: -- Now obtain the return values. There should be
743: -- exactly two outputs.
744: If l_outputs.count <> 2 then
745: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
746: fnd_message.set_token('PROCEDURE', l_proc);
747: fnd_message.set_token('STEP','20');
748: fnd_message.raise_error;
749: End if;
750: --

Line 747: fnd_message.set_token('STEP','20');

743: -- exactly two outputs.
744: If l_outputs.count <> 2 then
745: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
746: fnd_message.set_token('PROCEDURE', l_proc);
747: fnd_message.set_token('STEP','20');
748: fnd_message.raise_error;
749: End if;
750: --
751: For i in l_outputs.first..l_outputs.last loop

Line 748: fnd_message.raise_error;

744: If l_outputs.count <> 2 then
745: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
746: fnd_message.set_token('PROCEDURE', l_proc);
747: fnd_message.set_token('STEP','20');
748: fnd_message.raise_error;
749: End if;
750: --
751: For i in l_outputs.first..l_outputs.last loop
752: If l_outputs(i).name = 'FORMULA_MESSAGE' then

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

758: hr_utility.set_location(' Step 6:'||l_proc, 11);
759: l_formula_status := upper(l_outputs(i).value);
760: Else
761: --
762: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
763: fnd_message.set_token('PROCEDURE', l_proc);
764: fnd_message.set_token('STEP','30');
765: fnd_message.raise_error;
766: --

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

759: l_formula_status := upper(l_outputs(i).value);
760: Else
761: --
762: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
763: fnd_message.set_token('PROCEDURE', l_proc);
764: fnd_message.set_token('STEP','30');
765: fnd_message.raise_error;
766: --
767: End if;

Line 764: fnd_message.set_token('STEP','30');

760: Else
761: --
762: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
763: fnd_message.set_token('PROCEDURE', l_proc);
764: fnd_message.set_token('STEP','30');
765: fnd_message.raise_error;
766: --
767: End if;
768: End loop;

Line 765: fnd_message.raise_error;

761: --
762: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
763: fnd_message.set_token('PROCEDURE', l_proc);
764: fnd_message.set_token('STEP','30');
765: fnd_message.raise_error;
766: --
767: End if;
768: End loop;
769: --

Line 778: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');

774: -- I.e. the formula validation failed and we need to raise an error.
775: If l_formula_message is null then
776: -- User not defined an error message.
777: --
778: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
779: fnd_message.raise_error;
780: Else
781: -- User has defined message and so we can raise it.
782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');

Line 779: fnd_message.raise_error;

775: If l_formula_message is null then
776: -- User not defined an error message.
777: --
778: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
779: fnd_message.raise_error;
780: Else
781: -- User has defined message and so we can raise it.
782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
783: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);

Line 782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');

778: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
779: fnd_message.raise_error;
780: Else
781: -- User has defined message and so we can raise it.
782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
783: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
784: fnd_message.raise_error;
785: End if;
786: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then

Line 783: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);

779: fnd_message.raise_error;
780: Else
781: -- User has defined message and so we can raise it.
782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
783: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
784: fnd_message.raise_error;
785: End if;
786: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then
787: -- We have failed validation, but only want to warn.

Line 784: fnd_message.raise_error;

780: Else
781: -- User has defined message and so we can raise it.
782: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
783: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
784: fnd_message.raise_error;
785: End if;
786: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then
787: -- We have failed validation, but only want to warn.
788: p_default_formula_warning := true;

Line 826: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');

822: if p_value_set_id is not null then
823: -- Check uom is 'C'
824: if upper(p_uom) <> 'C' then
825: hr_utility.set_location(l_proc, 20);
826: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
827: fnd_message.raise_error;
828: else
829: -- Check value set id is valid, i.e. that it exists and that the value
830: -- set is table-validated, i.e. validation_type is 'F'

Line 827: fnd_message.raise_error;

823: -- Check uom is 'C'
824: if upper(p_uom) <> 'C' then
825: hr_utility.set_location(l_proc, 20);
826: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
827: fnd_message.raise_error;
828: else
829: -- Check value set id is valid, i.e. that it exists and that the value
830: -- set is table-validated, i.e. validation_type is 'F'
831: open csr_value_set;

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

832: fetch csr_value_set into l_validation_type;
833: if csr_value_set%notfound or l_validation_type <> 'F' then
834: close csr_value_set;
835: hr_utility.set_location(l_proc, 30);
836: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE', l_proc);
838: fnd_message.set_token('STEP','30');
839: fnd_message.raise_error;
840: end if;

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

833: if csr_value_set%notfound or l_validation_type <> 'F' then
834: close csr_value_set;
835: hr_utility.set_location(l_proc, 30);
836: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE', l_proc);
838: fnd_message.set_token('STEP','30');
839: fnd_message.raise_error;
840: end if;
841: close csr_value_set;

Line 838: fnd_message.set_token('STEP','30');

834: close csr_value_set;
835: hr_utility.set_location(l_proc, 30);
836: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE', l_proc);
838: fnd_message.set_token('STEP','30');
839: fnd_message.raise_error;
840: end if;
841: close csr_value_set;
842: end if;

Line 839: fnd_message.raise_error;

835: hr_utility.set_location(l_proc, 30);
836: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
837: fnd_message.set_token('PROCEDURE', l_proc);
838: fnd_message.set_token('STEP','30');
839: fnd_message.raise_error;
840: end if;
841: close csr_value_set;
842: end if;
843: end if;

Line 911: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');

907: open csr_row_count;
908: fetch csr_row_count into l_count;
909: close csr_row_count;
910: if l_count > 1 then
911: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
912: fnd_message.raise_error;
913: else
914: p_datetrack_mode := 'CORRECTION';
915: end if;

Line 912: fnd_message.raise_error;

908: fetch csr_row_count into l_count;
909: close csr_row_count;
910: if l_count > 1 then
911: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
912: fnd_message.raise_error;
913: else
914: p_datetrack_mode := 'CORRECTION';
915: end if;
916: end if;

Line 975: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');

971: open csr_row_count;
972: fetch csr_row_count into l_count;
973: close csr_row_count;
974: if l_count > 1 then
975: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
976: fnd_message.raise_error;
977: else
978: p_datetrack_mode := 'CORRECTION';
979: end if;

Line 976: fnd_message.raise_error;

972: fetch csr_row_count into l_count;
973: close csr_row_count;
974: if l_count > 1 then
975: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
976: fnd_message.raise_error;
977: else
978: p_datetrack_mode := 'CORRECTION';
979: end if;
980: end if;

Line 1003: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');

999: null);
1000:
1001: -- Check that PAY VALUE name is not updated
1002: if upper(p_name) = 'PAY VALUE' then
1003: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
1004: fnd_message.raise_error;
1005: end if;
1006:
1007: -- Check for the new name

Line 1004: fnd_message.raise_error;

1000:
1001: -- Check that PAY VALUE name is not updated
1002: if upper(p_name) = 'PAY VALUE' then
1003: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
1004: fnd_message.raise_error;
1005: end if;
1006:
1007: -- Check for the new name
1008: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then

Line 1009: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');

1005: end if;
1006:
1007: -- Check for the new name
1008: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
1009: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
1010: fnd_message.raise_error;
1011: end if;
1012:
1013: -- Name is not updated if contributions used for element type is Yes

Line 1010: fnd_message.raise_error;

1006:
1007: -- Check for the new name
1008: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
1009: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
1010: fnd_message.raise_error;
1011: end if;
1012:
1013: -- Name is not updated if contributions used for element type is Yes
1014: -- and the name is one of these 'Coverage','EE Contr' and 'ER Contr'

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

1018: if l_dummy = 'Y' and upper(pay_ivl_shd.g_old_rec.name)
1019: in ('COVERAGE','EE CONTR','ER CONTR')
1020: then
1021: close csr_ben_contri;
1022: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
1023: fnd_message.raise_error;
1024: end if;
1025: close csr_ben_contri;
1026:

Line 1023: fnd_message.raise_error;

1019: in ('COVERAGE','EE CONTR','ER CONTR')
1020: then
1021: close csr_ben_contri;
1022: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
1023: fnd_message.raise_error;
1024: end if;
1025: close csr_ben_contri;
1026:
1027: end if;

Line 1078: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');

1074: open csr_row_count;
1075: fetch csr_row_count into l_count;
1076: close csr_row_count;
1077: if l_count > 1 then
1078: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1079: fnd_message.raise_error;
1080: else
1081: p_datetrack_mode := 'CORRECTION';
1082: end if;

Line 1079: fnd_message.raise_error;

1075: fetch csr_row_count into l_count;
1076: close csr_row_count;
1077: if l_count > 1 then
1078: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1079: fnd_message.raise_error;
1080: else
1081: p_datetrack_mode := 'CORRECTION';
1082: end if;
1083: end if;

Line 1088: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');

1084: if pay_ivl_shd.g_old_rec.uom is not null then
1085: for rec in csr_uom
1086: loop
1087: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1088: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');
1089: fnd_message.raise_error;
1090: end if;
1091: end loop;
1092: end if;

Line 1089: fnd_message.raise_error;

1085: for rec in csr_uom
1086: loop
1087: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1088: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');
1089: fnd_message.raise_error;
1090: end if;
1091: end loop;
1092: end if;
1093: end if;

Line 1158: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');

1154: open csr_entries;
1155: fetch csr_entries into l_dummy;
1156: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1157: close csr_entries;
1158: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1159: fnd_message.raise_error;
1160: end if;
1161: close csr_entries;
1162: end if;

Line 1159: fnd_message.raise_error;

1155: fetch csr_entries into l_dummy;
1156: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1157: close csr_entries;
1158: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1159: fnd_message.raise_error;
1160: end if;
1161: close csr_entries;
1162: end if;
1163:

Line 1190: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');

1186: hr_utility.set_location(' Entering:'|| l_proc, 10);
1187:
1188:
1189: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1190: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1191: fnd_message.raise_error;
1192: end if;
1193:
1194: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1191: fnd_message.raise_error;

1187:
1188:
1189: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1190: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1191: fnd_message.raise_error;
1192: end if;
1193:
1194: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1195:

Line 1219: fnd_message.set_name('PAY','PAY_34119_HOT_DEFAULT_FLAG');

1215:
1216: hr_utility.set_location(' Entering:'|| l_proc, 10);
1217:
1218: if p_hot_default_flag = 'Y' and p_mandatory_flag <> 'Y' then
1219: fnd_message.set_name('PAY','PAY_34119_HOT_DEFAULT_FLAG');
1220: fnd_message.raise_error;
1221: end if;
1222:
1223: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1220: fnd_message.raise_error;

1216: hr_utility.set_location(' Entering:'|| l_proc, 10);
1217:
1218: if p_hot_default_flag = 'Y' and p_mandatory_flag <> 'Y' then
1219: fnd_message.set_name('PAY','PAY_34119_HOT_DEFAULT_FLAG');
1220: fnd_message.raise_error;
1221: end if;
1222:
1223: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1224:

Line 1290: fnd_message.set_name('PAY', 'PAY_34122_UOM_MONEY_PAYMENTS');

1286: close csr_classification;
1287:
1288:
1289: if upper(l_name) = 'PAY VALUE' and upper(p_uom) <> 'M' and l_dummy = 'N' then
1290: fnd_message.set_name('PAY', 'PAY_34122_UOM_MONEY_PAYMENTS');
1291: fnd_message.raise_error;
1292: end if;
1293:
1294: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1291: fnd_message.raise_error;

1287:
1288:
1289: if upper(l_name) = 'PAY VALUE' and upper(p_uom) <> 'M' and l_dummy = 'N' then
1290: fnd_message.set_name('PAY', 'PAY_34122_UOM_MONEY_PAYMENTS');
1291: fnd_message.raise_error;
1292: end if;
1293:
1294: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1295:

Line 1342: fnd_message.set_name('PAY', 'PAY_6626_INPVAL_NO_MONEY_UOM');

1338:
1339: for rec in csr_currency
1340: loop
1341: if rec.input_currency_code is null and upper(p_uom) = 'M' then
1342: fnd_message.set_name('PAY', 'PAY_6626_INPVAL_NO_MONEY_UOM');
1343: fnd_message.raise_error;
1344: end if;
1345: end loop;
1346:

Line 1343: fnd_message.raise_error;

1339: for rec in csr_currency
1340: loop
1341: if rec.input_currency_code is null and upper(p_uom) = 'M' then
1342: fnd_message.set_name('PAY', 'PAY_6626_INPVAL_NO_MONEY_UOM');
1343: fnd_message.raise_error;
1344: end if;
1345: end loop;
1346:
1347: open csr_lookup;

Line 1351: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');

1347: open csr_lookup;
1348:
1349: fetch csr_lookup into l_dummy;
1350: if csr_lookup%notfound then
1351: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1352: fnd_message.raise_error;
1353: end if;
1354:
1355: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1352: fnd_message.raise_error;

1348:
1349: fetch csr_lookup into l_dummy;
1350: if csr_lookup%notfound then
1351: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1352: fnd_message.raise_error;
1353: end if;
1354:
1355: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1356:

Line 1425: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');

1421: hr_utility.set_location(l_proc, 30);
1422: --
1423: close csr_lookup;
1424: --
1425: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1426: fnd_message.raise_error;
1427: --
1428: end if;
1429: --

Line 1426: fnd_message.raise_error;

1422: --
1423: close csr_lookup;
1424: --
1425: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1426: fnd_message.raise_error;
1427: --
1428: end if;
1429: --
1430: close csr_lookup;

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

1435: if pay_input_values_pkg.decode_vset_value (
1436: p_value_set_id,
1437: p_default_value ) is null then
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','40');
1442: fnd_message.raise_error;
1443: --

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

1436: p_value_set_id,
1437: p_default_value ) is null then
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','40');
1442: fnd_message.raise_error;
1443: --
1444: end if;

Line 1441: fnd_message.set_token('STEP','40');

1437: p_default_value ) is null then
1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','40');
1442: fnd_message.raise_error;
1443: --
1444: end if;
1445: --

Line 1442: fnd_message.raise_error;

1438: --
1439: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1440: fnd_message.set_token('PROCEDURE', l_proc);
1441: fnd_message.set_token('STEP','40');
1442: fnd_message.raise_error;
1443: --
1444: end if;
1445: --
1446:

Line 1537: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');

1533: if csr_lookup%notfound then
1534: --
1535: close csr_lookup;
1536: --
1537: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --

Line 1538: fnd_message.raise_error;

1534: --
1535: close csr_lookup;
1536: --
1537: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1538: fnd_message.raise_error;
1539: --
1540: end if;
1541: --
1542: close csr_lookup;

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

1570: if pay_input_values_pkg.decode_vset_value (
1571: l_value_set_id,
1572: p_default_value ) is null then
1573: --
1574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1575: fnd_message.set_token('PROCEDURE', l_proc);
1576: fnd_message.set_token('STEP','20');
1577: fnd_message.raise_error;
1578: --

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

1571: l_value_set_id,
1572: p_default_value ) is null then
1573: --
1574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1575: fnd_message.set_token('PROCEDURE', l_proc);
1576: fnd_message.set_token('STEP','20');
1577: fnd_message.raise_error;
1578: --
1579: end if;

Line 1576: fnd_message.set_token('STEP','20');

1572: p_default_value ) is null then
1573: --
1574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1575: fnd_message.set_token('PROCEDURE', l_proc);
1576: fnd_message.set_token('STEP','20');
1577: fnd_message.raise_error;
1578: --
1579: end if;
1580: --

Line 1577: fnd_message.raise_error;

1573: --
1574: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1575: fnd_message.set_token('PROCEDURE', l_proc);
1576: fnd_message.set_token('STEP','20');
1577: fnd_message.raise_error;
1578: --
1579: end if;
1580: --
1581: elsif pay_ivl_shd.g_old_rec.min_value is not null

Line 1591: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');

1587: p_default_value >= p_max_value) then
1588: --
1589: if p_warning_or_error = 'E' then
1590: --
1591: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1592: fnd_message.raise_error;
1593: --
1594: elsif p_warning_or_error = 'W' then
1595: --

Line 1592: fnd_message.raise_error;

1588: --
1589: if p_warning_or_error = 'E' then
1590: --
1591: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1592: fnd_message.raise_error;
1593: --
1594: elsif p_warning_or_error = 'W' then
1595: --
1596: p_default_val_warning := TRUE ;

Line 1609: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');

1605: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1606: --
1607: if p_warning_or_error = 'E' then
1608: --
1609: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1610: fnd_message.raise_error;
1611: --
1612: elsif p_warning_or_error = 'W' then
1613: --

Line 1610: fnd_message.raise_error;

1606: --
1607: if p_warning_or_error = 'E' then
1608: --
1609: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1610: fnd_message.raise_error;
1611: --
1612: elsif p_warning_or_error = 'W' then
1613: --
1614: p_default_val_warning := TRUE ;

Line 1687: fnd_message.set_name('PAY', 'HR_51975_ALL_MAX_MORE_MIN');

1683: if l_range_check = 'F' then
1684: --
1685: if p_warning_or_error = 'E' then
1686: --
1687: fnd_message.set_name('PAY', 'HR_51975_ALL_MAX_MORE_MIN');
1688: fnd_message.raise_error;
1689: --
1690: elsif p_warning_or_error = 'W' then
1691: --

Line 1688: fnd_message.raise_error;

1684: --
1685: if p_warning_or_error = 'E' then
1686: --
1687: fnd_message.set_name('PAY', 'HR_51975_ALL_MAX_MORE_MIN');
1688: fnd_message.raise_error;
1689: --
1690: elsif p_warning_or_error = 'W' then
1691: --
1692: p_min_max_warning := TRUE;

Line 1743: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');

1739: if (p_min_value is not null or p_max_value is not null or p_formula_id
1740: is not NULL)
1741: -- or p_lookup_type is not null) -- bug 8675578
1742: and p_warning_or_error is null then
1743: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');
1744: fnd_message.raise_error;
1745: elsif (p_min_value is null and p_max_value is null)
1746: and p_formula_id is null
1747: and p_lookup_type is null -- 6164772

Line 1744: fnd_message.raise_error;

1740: is not NULL)
1741: -- or p_lookup_type is not null) -- bug 8675578
1742: and p_warning_or_error is null then
1743: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');
1744: fnd_message.raise_error;
1745: elsif (p_min_value is null and p_max_value is null)
1746: and p_formula_id is null
1747: and p_lookup_type is null -- 6164772
1748: and p_warning_or_error is not null then

Line 1749: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');

1745: elsif (p_min_value is null and p_max_value is null)
1746: and p_formula_id is null
1747: and p_lookup_type is null -- 6164772
1748: and p_warning_or_error is not null then
1749: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');
1750: fnd_message.raise_error;
1751: end if;
1752:
1753: open csr_lookup;

Line 1750: fnd_message.raise_error;

1746: and p_formula_id is null
1747: and p_lookup_type is null -- 6164772
1748: and p_warning_or_error is not null then
1749: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');
1750: fnd_message.raise_error;
1751: end if;
1752:
1753: open csr_lookup;
1754: fetch csr_lookup into l_dummy;

Line 1757: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');

1753: open csr_lookup;
1754: fetch csr_lookup into l_dummy;
1755: if csr_lookup%notfound then
1756: close csr_lookup;
1757: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1758: fnd_message.raise_error;
1759: end if;
1760: close csr_lookup;
1761:

Line 1758: fnd_message.raise_error;

1754: fetch csr_lookup into l_dummy;
1755: if csr_lookup%notfound then
1756: close csr_lookup;
1757: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1758: fnd_message.raise_error;
1759: end if;
1760: close csr_lookup;
1761:
1762: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1823: fnd_message.set_name('PAY','HR_7124_INPVAL_MAX_ENTRIES');

1819: BEGIN
1820:
1821: hr_utility.set_location(' Entering:'|| l_proc, 10);
1822: if pay_input_values_pkg.no_of_input_values(p_element_type_id) >= 15 then
1823: fnd_message.set_name('PAY','HR_7124_INPVAL_MAX_ENTRIES');
1824: fnd_message.raise_error;
1825: end if;
1826:
1827: open csr_run_results;

Line 1824: fnd_message.raise_error;

1820:
1821: hr_utility.set_location(' Entering:'|| l_proc, 10);
1822: if pay_input_values_pkg.no_of_input_values(p_element_type_id) >= 15 then
1823: fnd_message.set_name('PAY','HR_7124_INPVAL_MAX_ENTRIES');
1824: fnd_message.raise_error;
1825: end if;
1826:
1827: open csr_run_results;
1828: fetch csr_run_results into l_dummy;

Line 1834: fnd_message.set_name('PAY','PAY_34123_CANNOT_CR_INP_VAL');

1830: or pay_element_types_pkg.element_entries_exist (
1831: p_element_type_id,
1832: p_error_if_true => TRUE
1833: ) then
1834: fnd_message.set_name('PAY','PAY_34123_CANNOT_CR_INP_VAL');
1835: fnd_message.raise_error;
1836: end if;
1837: close csr_run_results;
1838: if p_formula_id is not null and (

Line 1835: fnd_message.raise_error;

1831: p_element_type_id,
1832: p_error_if_true => TRUE
1833: ) then
1834: fnd_message.set_name('PAY','PAY_34123_CANNOT_CR_INP_VAL');
1835: fnd_message.raise_error;
1836: end if;
1837: close csr_run_results;
1838: if p_formula_id is not null and (
1839: p_lookup_type is not null or

Line 1844: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1840: p_value_set_id is not null or
1841: p_min_value is not null or
1842: p_max_value is not null
1843: ) then
1844: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1845: fnd_message.raise_error;
1846: elsif p_lookup_type is not null and (
1847: p_formula_id is not null or
1848: p_value_set_id is not null or

Line 1845: fnd_message.raise_error;

1841: p_min_value is not null or
1842: p_max_value is not null
1843: ) then
1844: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1845: fnd_message.raise_error;
1846: elsif p_lookup_type is not null and (
1847: p_formula_id is not null or
1848: p_value_set_id is not null or
1849: p_min_value is not null or

Line 1852: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1848: p_value_set_id is not null or
1849: p_min_value is not null or
1850: p_max_value is not null
1851: ) then
1852: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1853: fnd_message.raise_error;
1854: elsif p_value_set_id is not null and (
1855: p_formula_id is not null or
1856: p_lookup_type is not null or

Line 1853: fnd_message.raise_error;

1849: p_min_value is not null or
1850: p_max_value is not null
1851: ) then
1852: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1853: fnd_message.raise_error;
1854: elsif p_value_set_id is not null and (
1855: p_formula_id is not null or
1856: p_lookup_type is not null or
1857: p_min_value is not null or

Line 1860: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1856: p_lookup_type is not null or
1857: p_min_value is not null or
1858: p_max_value is not null
1859: ) then
1860: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1861: fnd_message.raise_error;
1862: elsif (p_min_value is not null or p_max_value is not null) and (
1863: p_formula_id is not null or
1864: p_lookup_type is not null or

Line 1861: fnd_message.raise_error;

1857: p_min_value is not null or
1858: p_max_value is not null
1859: ) then
1860: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1861: fnd_message.raise_error;
1862: elsif (p_min_value is not null or p_max_value is not null) and (
1863: p_formula_id is not null or
1864: p_lookup_type is not null or
1865: p_value_set_id is not null

Line 1867: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1863: p_formula_id is not null or
1864: p_lookup_type is not null or
1865: p_value_set_id is not null
1866: ) then
1867: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1868: fnd_message.raise_error;
1869: end if;
1870:
1871: for rec in csr_pay_basis

Line 1868: fnd_message.raise_error;

1864: p_lookup_type is not null or
1865: p_value_set_id is not null
1866: ) then
1867: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1868: fnd_message.raise_error;
1869: end if;
1870:
1871: for rec in csr_pay_basis
1872: loop

Line 1914: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1910: p_min_value is not null or
1911: p_max_value is not null
1912: ) then
1913:
1914: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1915: fnd_message.raise_error;
1916:
1917: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1918: p_lookup_type is not null and (

Line 1915: fnd_message.raise_error;

1911: p_max_value is not null
1912: ) then
1913:
1914: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1915: fnd_message.raise_error;
1916:
1917: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1918: p_lookup_type is not null and (
1919: p_formula_id is not null or

Line 1925: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1921: p_min_value is not null or
1922: p_max_value is not null
1923: ) then
1924:
1925: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1926: fnd_message.raise_error;
1927:
1928: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1929: p_value_set_id is not null and (

Line 1926: fnd_message.raise_error;

1922: p_max_value is not null
1923: ) then
1924:
1925: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1926: fnd_message.raise_error;
1927:
1928: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1929: p_value_set_id is not null and (
1930: p_formula_id is not null or

Line 1936: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1932: p_min_value is not null or
1933: p_max_value is not null
1934: ) then
1935:
1936: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1937: fnd_message.raise_error;
1938:
1939: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1940: p_min_value is not null or

Line 1937: fnd_message.raise_error;

1933: p_max_value is not null
1934: ) then
1935:
1936: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1937: fnd_message.raise_error;
1938:
1939: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1940: p_min_value is not null or
1941: pay_ivl_shd.g_old_rec.max_value is not null and

Line 1948: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');

1944: p_lookup_type is not null or
1945: p_value_set_id is not null
1946: ) then
1947:
1948: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1949: fnd_message.raise_error;
1950:
1951: end if;
1952:

Line 1949: fnd_message.raise_error;

1945: p_value_set_id is not null
1946: ) then
1947:
1948: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1949: fnd_message.raise_error;
1950:
1951: end if;
1952:
1953: END chk_other_upd_val;

Line 2068: fnd_message.set_name('PAY','PAY_34129_INPVAL_NAME_DEL');

2064: fetch csr_name into l_name;
2065:
2066: if csr_name%found and l_dummy = 'Y' then
2067: close csr_name;
2068: fnd_message.set_name('PAY','PAY_34129_INPVAL_NAME_DEL');
2069: fnd_message.raise_error;
2070: end if;
2071: close csr_name;
2072:

Line 2069: fnd_message.raise_error;

2065:
2066: if csr_name%found and l_dummy = 'Y' then
2067: close csr_name;
2068: fnd_message.set_name('PAY','PAY_34129_INPVAL_NAME_DEL');
2069: fnd_message.raise_error;
2070: end if;
2071: close csr_name;
2072:
2073: if pay_input_values_pkg.deletion_allowed (