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 209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');

205: (p_input_value_id => p_rec.input_value_id
206: ,p_effective_date => p_effective_date
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;

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

206: ,p_effective_date => p_effective_date
207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214:

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

207: ,p_object_version_number => p_rec.object_version_number
208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214:
215: End chk_non_updateable_args;

Line 212: fnd_message.raise_error;

208: ) THEN
209: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
210: fnd_message.set_token('PROCEDURE ', l_proc);
211: fnd_message.set_token('STEP ', '5');
212: fnd_message.raise_error;
213: END IF;
214:
215: End chk_non_updateable_args;
216: --

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

288: ,p_base_key_value => p_element_type_id
289:
290: ,p_from_date => p_validation_start_date
291: ,p_to_date => p_validation_end_date))) Then
292: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
293: fnd_message.set_token('TABLE_NAME','element types');
294: hr_multi_message.add
295: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
296: End If;

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

289:
290: ,p_from_date => p_validation_start_date
291: ,p_to_date => p_validation_end_date))) Then
292: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
293: fnd_message.set_token('TABLE_NAME','element types');
294: hr_multi_message.add
295: (p_associated_column1 => pay_ivl_shd.g_tab_nam || '.ELEMENT_TYPE_ID');
296: End If;
297: --

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

300: --
301: -- An unhandled or unexpected error has occurred which
302: -- we must report
303: --
304: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
305: fnd_message.set_token('PROCEDURE', l_proc);
306: fnd_message.set_token('STEP','15');
307: fnd_message.raise_error;
308: End dt_update_validate;

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

301: -- An unhandled or unexpected error has occurred which
302: -- we must report
303: --
304: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
305: fnd_message.set_token('PROCEDURE', l_proc);
306: fnd_message.set_token('STEP','15');
307: fnd_message.raise_error;
308: End dt_update_validate;
309: --

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

302: -- we must report
303: --
304: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
305: fnd_message.set_token('PROCEDURE', l_proc);
306: fnd_message.set_token('STEP','15');
307: fnd_message.raise_error;
308: End dt_update_validate;
309: --
310: -- ----------------------------------------------------------------------------

Line 307: fnd_message.raise_error;

303: --
304: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
305: fnd_message.set_token('PROCEDURE', l_proc);
306: fnd_message.set_token('STEP','15');
307: fnd_message.raise_error;
308: End dt_update_validate;
309: --
310: -- ----------------------------------------------------------------------------
311: -- |--------------------------< dt_delete_validate >--------------------------|

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

398: ,p_base_key_value => p_input_value_id
399: ,p_from_date => p_validation_start_date
400: ,p_to_date => p_validation_end_date
401: )) Then
402: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
403: fnd_message.set_token('TABLE_NAME','acty base rt');
404: hr_multi_message.add;
405: End If;
406: If (dt_api.rows_exist

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

399: ,p_from_date => p_validation_start_date
400: ,p_to_date => p_validation_end_date
401: )) Then
402: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
403: fnd_message.set_token('TABLE_NAME','acty base rt');
404: hr_multi_message.add;
405: End If;
406: If (dt_api.rows_exist
407: (p_base_table_name => 'pay_link_input_values_f'

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

410: ,p_base_key_value => p_input_value_id
411: ,p_from_date => p_validation_start_date
412: ,p_to_date => p_validation_end_date
413: )) Then
414: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
415: fnd_message.set_token('TABLE_NAME','link input values');
416: hr_multi_message.add;
417: End If;
418: --

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

411: ,p_from_date => p_validation_start_date
412: ,p_to_date => p_validation_end_date
413: )) Then
414: fnd_message.set_name('PAY','HR_7215_DT_CHILD_EXISTS');
415: fnd_message.set_token('TABLE_NAME','link input values');
416: hr_multi_message.add;
417: End If;
418: --
419: End If;

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

423: --
424: -- An unhandled or unexpected error has occurred which
425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --

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

424: -- An unhandled or unexpected error has occurred which
425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;

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

425: -- we must report
426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;
433:

Line 430: fnd_message.raise_error;

426: --
427: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
428: fnd_message.set_token('PROCEDURE', l_proc);
429: fnd_message.set_token('STEP','15');
430: fnd_message.raise_error;
431: --
432: End dt_delete_validate;
433:
434: --

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

504:
505: hr_utility.set_location(' Entering:'|| l_proc, 10);
506:
507: if p_lookup_type is not null and upper(p_uom) <> 'C' then
508: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
509: fnd_message.raise_error;
510: else
511: open csr_lookup;
512: fetch csr_lookup into l_dummy;

Line 509: fnd_message.raise_error;

505: hr_utility.set_location(' Entering:'|| l_proc, 10);
506:
507: if p_lookup_type is not null and upper(p_uom) <> 'C' then
508: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
509: fnd_message.raise_error;
510: else
511: open csr_lookup;
512: fetch csr_lookup into l_dummy;
513: if csr_lookup%notfound then

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

511: open csr_lookup;
512: fetch csr_lookup into l_dummy;
513: if csr_lookup%notfound then
514: close csr_lookup;
515: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
516: fnd_message.raise_error;
517: end if;
518: close csr_lookup;
519: end if;

Line 516: fnd_message.raise_error;

512: fetch csr_lookup into l_dummy;
513: if csr_lookup%notfound then
514: close csr_lookup;
515: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
516: fnd_message.raise_error;
517: end if;
518: close csr_lookup;
519: end if;
520:

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

563: open csr_formula;
564: fetch csr_formula into l_dummy;
565: if csr_formula%notfound then
566: close csr_formula;
567: fnd_message.set_name('PAY','PAY_34116_INVALID_FORMULA');
568: fnd_message.raise_error;
569: end if;
570: close csr_formula;
571: end if;

Line 568: fnd_message.raise_error;

564: fetch csr_formula into l_dummy;
565: if csr_formula%notfound then
566: close csr_formula;
567: fnd_message.set_name('PAY','PAY_34116_INVALID_FORMULA');
568: fnd_message.raise_error;
569: end if;
570: close csr_formula;
571: end if;
572:

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

655: -- Note - need to pass database format to formula.
656: l_inputs(i).value := p_default_value;
657: Else
658: -- No context recognised.
659: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
660: fnd_message.set_token('PROCEDURE', l_proc);
661: fnd_message.set_token('STEP','10');
662: fnd_message.raise_error;
663: End if;

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

656: l_inputs(i).value := p_default_value;
657: Else
658: -- No context recognised.
659: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
660: fnd_message.set_token('PROCEDURE', l_proc);
661: fnd_message.set_token('STEP','10');
662: fnd_message.raise_error;
663: End if;
664: End loop;

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

657: Else
658: -- No context recognised.
659: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
660: fnd_message.set_token('PROCEDURE', l_proc);
661: fnd_message.set_token('STEP','10');
662: fnd_message.raise_error;
663: End if;
664: End loop;
665: End if;

Line 662: fnd_message.raise_error;

658: -- No context recognised.
659: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
660: fnd_message.set_token('PROCEDURE', l_proc);
661: fnd_message.set_token('STEP','10');
662: fnd_message.raise_error;
663: End if;
664: End loop;
665: End if;
666: --

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

673: --
674: -- Now obtain the return values. There should be
675: -- exactly two outputs.
676: If l_outputs.count <> 2 then
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','20');
680: fnd_message.raise_error;
681: End if;

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

674: -- Now obtain the return values. There should be
675: -- exactly two outputs.
676: If l_outputs.count <> 2 then
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','20');
680: fnd_message.raise_error;
681: End if;
682: --

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

675: -- exactly two outputs.
676: If l_outputs.count <> 2 then
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','20');
680: fnd_message.raise_error;
681: End if;
682: --
683: For i in l_outputs.first..l_outputs.last loop

Line 680: fnd_message.raise_error;

676: If l_outputs.count <> 2 then
677: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
678: fnd_message.set_token('PROCEDURE', l_proc);
679: fnd_message.set_token('STEP','20');
680: fnd_message.raise_error;
681: End if;
682: --
683: For i in l_outputs.first..l_outputs.last loop
684: If l_outputs(i).name = 'FORMULA_MESSAGE' then

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

690: hr_utility.set_location(' Step 6:'||l_proc, 11);
691: l_formula_status := upper(l_outputs(i).value);
692: Else
693: --
694: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
695: fnd_message.set_token('PROCEDURE', l_proc);
696: fnd_message.set_token('STEP','30');
697: fnd_message.raise_error;
698: --

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

691: l_formula_status := upper(l_outputs(i).value);
692: Else
693: --
694: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
695: fnd_message.set_token('PROCEDURE', l_proc);
696: fnd_message.set_token('STEP','30');
697: fnd_message.raise_error;
698: --
699: End if;

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

692: Else
693: --
694: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
695: fnd_message.set_token('PROCEDURE', l_proc);
696: fnd_message.set_token('STEP','30');
697: fnd_message.raise_error;
698: --
699: End if;
700: End loop;

Line 697: fnd_message.raise_error;

693: --
694: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
695: fnd_message.set_token('PROCEDURE', l_proc);
696: fnd_message.set_token('STEP','30');
697: fnd_message.raise_error;
698: --
699: End if;
700: End loop;
701: --

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

706: -- I.e. the formula validation failed and we need to raise an error.
707: If l_formula_message is null then
708: -- User not defined an error message.
709: --
710: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
711: fnd_message.raise_error;
712: Else
713: -- User has defined message and so we can raise it.
714: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');

Line 711: fnd_message.raise_error;

707: If l_formula_message is null then
708: -- User not defined an error message.
709: --
710: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
711: fnd_message.raise_error;
712: Else
713: -- User has defined message and so we can raise it.
714: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
715: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);

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

710: fnd_message.set_name('PAY','PAY_33083_LK_INP_VAL_FORML_ERR');
711: fnd_message.raise_error;
712: Else
713: -- User has defined message and so we can raise it.
714: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
715: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
716: fnd_message.raise_error;
717: End if;
718: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then

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

711: fnd_message.raise_error;
712: Else
713: -- User has defined message and so we can raise it.
714: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
715: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
716: fnd_message.raise_error;
717: End if;
718: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then
719: -- We have failed validation, but only want to warn.

Line 716: fnd_message.raise_error;

712: Else
713: -- User has defined message and so we can raise it.
714: fnd_message.set_name('PAY','HR_ELE_ENTRY_FORMULA_HINT');
715: fnd_message.set_token('FORMULA_TEXT', l_formula_message, false);
716: fnd_message.raise_error;
717: End if;
718: Elsif l_formula_status <> 'S' and p_warning_or_error = 'W' then
719: -- We have failed validation, but only want to warn.
720: p_default_formula_warning := true;

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

754: if p_value_set_id is not null then
755: -- Check uom is 'C'
756: if upper(p_uom) <> 'C' then
757: hr_utility.set_location(l_proc, 20);
758: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
759: fnd_message.raise_error;
760: else
761: -- Check value set id is valid, i.e. that it exists and that the value
762: -- set is table-validated, i.e. validation_type is 'F'

Line 759: fnd_message.raise_error;

755: -- Check uom is 'C'
756: if upper(p_uom) <> 'C' then
757: hr_utility.set_location(l_proc, 20);
758: fnd_message.set_name('PAY','PAY_34117_INVALID_UOM');
759: fnd_message.raise_error;
760: else
761: -- Check value set id is valid, i.e. that it exists and that the value
762: -- set is table-validated, i.e. validation_type is 'F'
763: open csr_value_set;

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

764: fetch csr_value_set into l_validation_type;
765: if csr_value_set%notfound or l_validation_type <> 'F' then
766: close csr_value_set;
767: hr_utility.set_location(l_proc, 30);
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','30');
771: fnd_message.raise_error;
772: end if;

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

765: if csr_value_set%notfound or l_validation_type <> 'F' then
766: close csr_value_set;
767: hr_utility.set_location(l_proc, 30);
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','30');
771: fnd_message.raise_error;
772: end if;
773: close csr_value_set;

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

766: close csr_value_set;
767: hr_utility.set_location(l_proc, 30);
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','30');
771: fnd_message.raise_error;
772: end if;
773: close csr_value_set;
774: end if;

Line 771: fnd_message.raise_error;

767: hr_utility.set_location(l_proc, 30);
768: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
769: fnd_message.set_token('PROCEDURE', l_proc);
770: fnd_message.set_token('STEP','30');
771: fnd_message.raise_error;
772: end if;
773: close csr_value_set;
774: end if;
775: end if;

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

839: open csr_row_count;
840: fetch csr_row_count into l_count;
841: close csr_row_count;
842: if l_count > 1 then
843: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
844: fnd_message.raise_error;
845: else
846: p_datetrack_mode := 'CORRECTION';
847: end if;

Line 844: fnd_message.raise_error;

840: fetch csr_row_count into l_count;
841: close csr_row_count;
842: if l_count > 1 then
843: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
844: fnd_message.raise_error;
845: else
846: p_datetrack_mode := 'CORRECTION';
847: end if;
848: end if;

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

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

Line 908: fnd_message.raise_error;

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

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

931: null);
932:
933: -- Check that PAY VALUE name is not updated
934: if upper(p_name) = 'PAY VALUE' then
935: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
936: fnd_message.raise_error;
937: end if;
938:
939: -- Check for the new name

Line 936: fnd_message.raise_error;

932:
933: -- Check that PAY VALUE name is not updated
934: if upper(p_name) = 'PAY VALUE' then
935: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
936: fnd_message.raise_error;
937: end if;
938:
939: -- Check for the new name
940: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then

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

937: end if;
938:
939: -- Check for the new name
940: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
941: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
942: fnd_message.raise_error;
943: end if;
944:
945: -- Name is not updated if contributions used for element type is Yes

Line 942: fnd_message.raise_error;

938:
939: -- Check for the new name
940: if upper(pay_ivl_shd.g_old_rec.name) = 'PAY VALUE' then
941: fnd_message.set_name('PAY', 'PAY_34126_NAME_PAY_VAL_UPD');
942: fnd_message.raise_error;
943: end if;
944:
945: -- Name is not updated if contributions used for element type is Yes
946: -- and the name is one of these 'Coverage','EE Contr' and 'ER Contr'

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

950: if l_dummy = 'Y' and upper(pay_ivl_shd.g_old_rec.name)
951: in ('COVERAGE','EE CONTR','ER CONTR')
952: then
953: close csr_ben_contri;
954: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
955: fnd_message.raise_error;
956: end if;
957: close csr_ben_contri;
958:

Line 955: fnd_message.raise_error;

951: in ('COVERAGE','EE CONTR','ER CONTR')
952: then
953: close csr_ben_contri;
954: fnd_message.set_name('PAY', 'PAY_33078_LK_INP_VAL_NO_UPD');
955: fnd_message.raise_error;
956: end if;
957: close csr_ben_contri;
958:
959: end if;

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

1006: open csr_row_count;
1007: fetch csr_row_count into l_count;
1008: close csr_row_count;
1009: if l_count > 1 then
1010: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1011: fnd_message.raise_error;
1012: else
1013: p_datetrack_mode := 'CORRECTION';
1014: end if;

Line 1011: fnd_message.raise_error;

1007: fetch csr_row_count into l_count;
1008: close csr_row_count;
1009: if l_count > 1 then
1010: fnd_message.set_name('PAY', 'PAY_34151_ELE_NO_DATE_UPD');
1011: fnd_message.raise_error;
1012: else
1013: p_datetrack_mode := 'CORRECTION';
1014: end if;
1015: end if;

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

1016: if pay_ivl_shd.g_old_rec.uom is not null then
1017: for rec in csr_uom
1018: loop
1019: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1020: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');
1021: fnd_message.raise_error;
1022: end if;
1023: end loop;
1024: end if;

Line 1021: fnd_message.raise_error;

1017: for rec in csr_uom
1018: loop
1019: if substr(rec.lookup_code,1,2) <> substr(p_uom,1,2) then
1020: fnd_message.set_name('PAY', 'PAY_34127_UOM_UPD_CLASS');
1021: fnd_message.raise_error;
1022: end if;
1023: end loop;
1024: end if;
1025: end if;

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

1086: open csr_entries;
1087: fetch csr_entries into l_dummy;
1088: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1089: close csr_entries;
1090: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1091: fnd_message.raise_error;
1092: end if;
1093: close csr_entries;
1094: end if;

Line 1091: fnd_message.raise_error;

1087: fetch csr_entries into l_dummy;
1088: if csr_entries%found and pay_ivl_shd.g_old_rec.hot_default_flag = 'Y' then
1089: close csr_entries;
1090: fnd_message.set_name('PAY', 'PAY_34128_DEF_VAL_HOT_DEF');
1091: fnd_message.raise_error;
1092: end if;
1093: close csr_entries;
1094: end if;
1095:

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

1118: hr_utility.set_location(' Entering:'|| l_proc, 10);
1119:
1120:
1121: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1122: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1123: fnd_message.raise_error;
1124: end if;
1125:
1126: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1123: fnd_message.raise_error;

1119:
1120:
1121: if pay_ivl_shd.g_old_rec.mandatory_flag = 'N' and p_mandatory_flag = 'Y' then
1122: fnd_message.set_name('PAY', 'PAY_34125_MAN_FLAG_UPD');
1123: fnd_message.raise_error;
1124: end if;
1125:
1126: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1127:

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

1147:
1148: hr_utility.set_location(' Entering:'|| l_proc, 10);
1149:
1150: if p_hot_default_flag = 'Y' and p_mandatory_flag <> 'Y' then
1151: fnd_message.set_name('PAY','PAY_34119_HOT_DEFAULT_FLAG');
1152: fnd_message.raise_error;
1153: end if;
1154:
1155: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1152: fnd_message.raise_error;

1148: hr_utility.set_location(' Entering:'|| l_proc, 10);
1149:
1150: if p_hot_default_flag = 'Y' and p_mandatory_flag <> 'Y' then
1151: fnd_message.set_name('PAY','PAY_34119_HOT_DEFAULT_FLAG');
1152: fnd_message.raise_error;
1153: end if;
1154:
1155: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1156:

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

1218: close csr_classification;
1219:
1220:
1221: if upper(l_name) = 'PAY VALUE' and upper(p_uom) <> 'M' and l_dummy = 'N' then
1222: fnd_message.set_name('PAY', 'PAY_34122_UOM_MONEY_PAYMENTS');
1223: fnd_message.raise_error;
1224: end if;
1225:
1226: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1223: fnd_message.raise_error;

1219:
1220:
1221: if upper(l_name) = 'PAY VALUE' and upper(p_uom) <> 'M' and l_dummy = 'N' then
1222: fnd_message.set_name('PAY', 'PAY_34122_UOM_MONEY_PAYMENTS');
1223: fnd_message.raise_error;
1224: end if;
1225:
1226: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1227:

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

1270:
1271: for rec in csr_currency
1272: loop
1273: if rec.input_currency_code is null and upper(p_uom) = 'M' then
1274: fnd_message.set_name('PAY', 'PAY_6626_INPVAL_NO_MONEY_UOM');
1275: fnd_message.raise_error;
1276: end if;
1277: end loop;
1278:

Line 1275: fnd_message.raise_error;

1271: for rec in csr_currency
1272: loop
1273: if rec.input_currency_code is null and upper(p_uom) = 'M' then
1274: fnd_message.set_name('PAY', 'PAY_6626_INPVAL_NO_MONEY_UOM');
1275: fnd_message.raise_error;
1276: end if;
1277: end loop;
1278:
1279: open csr_lookup;

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

1279: open csr_lookup;
1280:
1281: fetch csr_lookup into l_dummy;
1282: if csr_lookup%notfound then
1283: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1284: fnd_message.raise_error;
1285: end if;
1286:
1287: hr_utility.set_location(' Leaving:'|| l_proc, 10);

Line 1284: fnd_message.raise_error;

1280:
1281: fetch csr_lookup into l_dummy;
1282: if csr_lookup%notfound then
1283: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1284: fnd_message.raise_error;
1285: end if;
1286:
1287: hr_utility.set_location(' Leaving:'|| l_proc, 10);
1288:

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

1344: hr_utility.set_location(l_proc, 30);
1345: --
1346: close csr_lookup;
1347: --
1348: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1349: fnd_message.raise_error;
1350: --
1351: end if;
1352: --

Line 1349: fnd_message.raise_error;

1345: --
1346: close csr_lookup;
1347: --
1348: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1349: fnd_message.raise_error;
1350: --
1351: end if;
1352: --
1353: close csr_lookup;

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

1358: if pay_input_values_pkg.decode_vset_value (
1359: p_value_set_id,
1360: p_default_value ) is null then
1361: --
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', l_proc);
1364: fnd_message.set_token('STEP','40');
1365: fnd_message.raise_error;
1366: --

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

1359: p_value_set_id,
1360: p_default_value ) is null then
1361: --
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', l_proc);
1364: fnd_message.set_token('STEP','40');
1365: fnd_message.raise_error;
1366: --
1367: end if;

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

1360: p_default_value ) is null then
1361: --
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', l_proc);
1364: fnd_message.set_token('STEP','40');
1365: fnd_message.raise_error;
1366: --
1367: end if;
1368: --

Line 1365: fnd_message.raise_error;

1361: --
1362: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1363: fnd_message.set_token('PROCEDURE', l_proc);
1364: fnd_message.set_token('STEP','40');
1365: fnd_message.raise_error;
1366: --
1367: end if;
1368: --
1369: elsif (p_min_value is not null or p_max_value is not null) and

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

1373: if p_warning_or_error = 'E' then
1374: --
1375: hr_utility.set_location(l_proc,50);
1376: --
1377: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1378: fnd_message.raise_error;
1379: --
1380: elsif p_warning_or_error = 'W' then
1381: --

Line 1378: fnd_message.raise_error;

1374: --
1375: hr_utility.set_location(l_proc,50);
1376: --
1377: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1378: fnd_message.raise_error;
1379: --
1380: elsif p_warning_or_error = 'W' then
1381: --
1382: hr_utility.set_location(l_proc,60);

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

1450: if csr_lookup%notfound then
1451: --
1452: close csr_lookup;
1453: --
1454: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1455: fnd_message.raise_error;
1456: --
1457: end if;
1458: --

Line 1455: fnd_message.raise_error;

1451: --
1452: close csr_lookup;
1453: --
1454: fnd_message.set_name('PAY', 'PAY_6171_INPVAL_NO_LOOKUP');
1455: fnd_message.raise_error;
1456: --
1457: end if;
1458: --
1459: close csr_lookup;

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

1487: if pay_input_values_pkg.decode_vset_value (
1488: l_value_set_id,
1489: p_default_value ) is null then
1490: --
1491: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1492: fnd_message.set_token('PROCEDURE', l_proc);
1493: fnd_message.set_token('STEP','20');
1494: fnd_message.raise_error;
1495: --

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

1488: l_value_set_id,
1489: p_default_value ) is null then
1490: --
1491: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1492: fnd_message.set_token('PROCEDURE', l_proc);
1493: fnd_message.set_token('STEP','20');
1494: fnd_message.raise_error;
1495: --
1496: end if;

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

1489: p_default_value ) is null then
1490: --
1491: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1492: fnd_message.set_token('PROCEDURE', l_proc);
1493: fnd_message.set_token('STEP','20');
1494: fnd_message.raise_error;
1495: --
1496: end if;
1497: --

Line 1494: fnd_message.raise_error;

1490: --
1491: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1492: fnd_message.set_token('PROCEDURE', l_proc);
1493: fnd_message.set_token('STEP','20');
1494: fnd_message.raise_error;
1495: --
1496: end if;
1497: --
1498: elsif pay_ivl_shd.g_old_rec.min_value is not null

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

1504: p_default_value >= p_max_value) then
1505: --
1506: if p_warning_or_error = 'E' then
1507: --
1508: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1509: fnd_message.raise_error;
1510: --
1511: elsif p_warning_or_error = 'W' then
1512: --

Line 1509: fnd_message.raise_error;

1505: --
1506: if p_warning_or_error = 'E' then
1507: --
1508: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1509: fnd_message.raise_error;
1510: --
1511: elsif p_warning_or_error = 'W' then
1512: --
1513: p_default_val_warning := TRUE ;

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

1522: p_default_value >= pay_ivl_shd.g_old_rec.max_value) then
1523: --
1524: if p_warning_or_error = 'E' then
1525: --
1526: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1527: fnd_message.raise_error;
1528: --
1529: elsif p_warning_or_error = 'W' then
1530: --

Line 1527: fnd_message.raise_error;

1523: --
1524: if p_warning_or_error = 'E' then
1525: --
1526: fnd_message.set_name('PAY', 'PAY_6303_INPUT_VALUE_OUT_RANGE');
1527: fnd_message.raise_error;
1528: --
1529: elsif p_warning_or_error = 'W' then
1530: --
1531: p_default_val_warning := TRUE ;

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

1564: BEGIN
1565: hr_utility.set_location(' Entering:'|| l_proc, 10);
1566: if p_min_value > p_max_value then
1567: if p_warning_or_error = 'E' then
1568: fnd_message.set_name('PAY', 'HR_51975_ALL_MAX_MORE_MIN');
1569: fnd_message.raise_error;
1570: elsif p_warning_or_error = 'W' then
1571: p_min_max_warning := TRUE;
1572: end if;

Line 1569: fnd_message.raise_error;

1565: hr_utility.set_location(' Entering:'|| l_proc, 10);
1566: if p_min_value > p_max_value then
1567: if p_warning_or_error = 'E' then
1568: fnd_message.set_name('PAY', 'HR_51975_ALL_MAX_MORE_MIN');
1569: fnd_message.raise_error;
1570: elsif p_warning_or_error = 'W' then
1571: p_min_max_warning := TRUE;
1572: end if;
1573: end if;

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

1610:
1611: if (p_min_value is not null or p_max_value is not null or p_formula_id
1612: is not null)
1613: and p_warning_or_error is null then
1614: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');
1615: fnd_message.raise_error;
1616: elsif (p_min_value is null and p_max_value is null) and p_formula_id is null
1617: and p_warning_or_error is not null then
1618: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');

Line 1615: fnd_message.raise_error;

1611: if (p_min_value is not null or p_max_value is not null or p_formula_id
1612: is not null)
1613: and p_warning_or_error is null then
1614: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');
1615: fnd_message.raise_error;
1616: elsif (p_min_value is null and p_max_value is null) and p_formula_id is null
1617: and p_warning_or_error is not null then
1618: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');
1619: fnd_message.raise_error;

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

1614: fnd_message.set_name('PAY','PAY_34121_WARN_ERROR_MAND');
1615: fnd_message.raise_error;
1616: elsif (p_min_value is null and p_max_value is null) and p_formula_id is null
1617: and p_warning_or_error is not null then
1618: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');
1619: fnd_message.raise_error;
1620: end if;
1621:
1622: open csr_lookup;

Line 1619: fnd_message.raise_error;

1615: fnd_message.raise_error;
1616: elsif (p_min_value is null and p_max_value is null) and p_formula_id is null
1617: and p_warning_or_error is not null then
1618: fnd_message.set_name('PAY','PAY_6908_INPVAL_ERROR_VAL');
1619: fnd_message.raise_error;
1620: end if;
1621:
1622: open csr_lookup;
1623: fetch csr_lookup into l_dummy;

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

1622: open csr_lookup;
1623: fetch csr_lookup into l_dummy;
1624: if csr_lookup%notfound then
1625: close csr_lookup;
1626: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1627: fnd_message.raise_error;
1628: end if;
1629: close csr_lookup;
1630:

Line 1627: fnd_message.raise_error;

1623: fetch csr_lookup into l_dummy;
1624: if csr_lookup%notfound then
1625: close csr_lookup;
1626: fnd_message.set_name('PAY','HR_52966_INVALID_LOOKUP');
1627: fnd_message.raise_error;
1628: end if;
1629: close csr_lookup;
1630:
1631: hr_utility.set_location(' Leaving:'|| l_proc, 10);

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

1688: BEGIN
1689:
1690: hr_utility.set_location(' Entering:'|| l_proc, 10);
1691: if pay_input_values_pkg.no_of_input_values(p_element_type_id) >= 15 then
1692: fnd_message.set_name('PAY','HR_7124_INPVAL_MAX_ENTRIES');
1693: fnd_message.raise_error;
1694: end if;
1695:
1696: open csr_run_results;

Line 1693: fnd_message.raise_error;

1689:
1690: hr_utility.set_location(' Entering:'|| l_proc, 10);
1691: if pay_input_values_pkg.no_of_input_values(p_element_type_id) >= 15 then
1692: fnd_message.set_name('PAY','HR_7124_INPVAL_MAX_ENTRIES');
1693: fnd_message.raise_error;
1694: end if;
1695:
1696: open csr_run_results;
1697: fetch csr_run_results into l_dummy;

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

1699: or pay_element_types_pkg.element_entries_exist (
1700: p_element_type_id,
1701: p_error_if_true => TRUE
1702: ) then
1703: fnd_message.set_name('PAY','PAY_34123_CANNOT_CR_INP_VAL');
1704: fnd_message.raise_error;
1705: end if;
1706: close csr_run_results;
1707: if p_formula_id is not null and (

Line 1704: fnd_message.raise_error;

1700: p_element_type_id,
1701: p_error_if_true => TRUE
1702: ) then
1703: fnd_message.set_name('PAY','PAY_34123_CANNOT_CR_INP_VAL');
1704: fnd_message.raise_error;
1705: end if;
1706: close csr_run_results;
1707: if p_formula_id is not null and (
1708: p_lookup_type is not null or

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

1709: p_value_set_id is not null or
1710: p_min_value is not null or
1711: p_max_value is not null
1712: ) then
1713: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1714: fnd_message.raise_error;
1715: elsif p_lookup_type is not null and (
1716: p_formula_id is not null or
1717: p_value_set_id is not null or

Line 1714: fnd_message.raise_error;

1710: p_min_value is not null or
1711: p_max_value is not null
1712: ) then
1713: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1714: fnd_message.raise_error;
1715: elsif p_lookup_type is not null and (
1716: p_formula_id is not null or
1717: p_value_set_id is not null or
1718: p_min_value is not null or

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

1717: p_value_set_id is not null or
1718: p_min_value is not null or
1719: p_max_value is not null
1720: ) then
1721: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1722: fnd_message.raise_error;
1723: elsif p_value_set_id is not null and (
1724: p_formula_id is not null or
1725: p_lookup_type is not null or

Line 1722: fnd_message.raise_error;

1718: p_min_value is not null or
1719: p_max_value is not null
1720: ) then
1721: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1722: fnd_message.raise_error;
1723: elsif p_value_set_id is not null and (
1724: p_formula_id is not null or
1725: p_lookup_type is not null or
1726: p_min_value is not null or

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

1725: p_lookup_type is not null or
1726: p_min_value is not null or
1727: p_max_value is not null
1728: ) then
1729: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1730: fnd_message.raise_error;
1731: elsif (p_min_value is not null or p_max_value is not null) and (
1732: p_formula_id is not null or
1733: p_lookup_type is not null or

Line 1730: fnd_message.raise_error;

1726: p_min_value is not null or
1727: p_max_value is not null
1728: ) then
1729: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1730: fnd_message.raise_error;
1731: elsif (p_min_value is not null or p_max_value is not null) and (
1732: p_formula_id is not null or
1733: p_lookup_type is not null or
1734: p_value_set_id is not null

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

1732: p_formula_id is not null or
1733: p_lookup_type is not null or
1734: p_value_set_id is not null
1735: ) then
1736: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1737: fnd_message.raise_error;
1738: end if;
1739:
1740: for rec in csr_pay_basis

Line 1737: fnd_message.raise_error;

1733: p_lookup_type is not null or
1734: p_value_set_id is not null
1735: ) then
1736: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1737: fnd_message.raise_error;
1738: end if;
1739:
1740: for rec in csr_pay_basis
1741: loop

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

1779: p_min_value is not null or
1780: p_max_value is not null
1781: ) then
1782:
1783: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1784: fnd_message.raise_error;
1785:
1786: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1787: p_lookup_type is not null and (

Line 1784: fnd_message.raise_error;

1780: p_max_value is not null
1781: ) then
1782:
1783: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1784: fnd_message.raise_error;
1785:
1786: elsif pay_ivl_shd.g_old_rec.lookup_type is not null and
1787: p_lookup_type is not null and (
1788: p_formula_id is not null or

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

1790: p_min_value is not null or
1791: p_max_value is not null
1792: ) then
1793:
1794: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1795: fnd_message.raise_error;
1796:
1797: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1798: p_value_set_id is not null and (

Line 1795: fnd_message.raise_error;

1791: p_max_value is not null
1792: ) then
1793:
1794: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1795: fnd_message.raise_error;
1796:
1797: elsif pay_ivl_shd.g_old_rec.value_set_id is not null and
1798: p_value_set_id is not null and (
1799: p_formula_id is not null or

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

1801: p_min_value is not null or
1802: p_max_value is not null
1803: ) then
1804:
1805: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1806: fnd_message.raise_error;
1807:
1808: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1809: p_min_value is not null or

Line 1806: fnd_message.raise_error;

1802: p_max_value is not null
1803: ) then
1804:
1805: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1806: fnd_message.raise_error;
1807:
1808: elsif (pay_ivl_shd.g_old_rec.min_value is not null and
1809: p_min_value is not null or
1810: pay_ivl_shd.g_old_rec.max_value is not null and

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

1813: p_lookup_type is not null or
1814: p_value_set_id is not null
1815: ) then
1816:
1817: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1818: fnd_message.raise_error;
1819:
1820: end if;
1821:

Line 1818: fnd_message.raise_error;

1814: p_value_set_id is not null
1815: ) then
1816:
1817: fnd_message.set_name('PAY','PAY_6170_INPVAL_VAL_COMB');
1818: fnd_message.raise_error;
1819:
1820: end if;
1821:
1822: END chk_other_upd_val;

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

1933: fetch csr_name into l_name;
1934:
1935: if csr_name%found and l_dummy = 'Y' then
1936: close csr_name;
1937: fnd_message.set_name('PAY','PAY_34129_INPVAL_NAME_DEL');
1938: fnd_message.raise_error;
1939: end if;
1940: close csr_name;
1941:

Line 1938: fnd_message.raise_error;

1934:
1935: if csr_name%found and l_dummy = 'Y' then
1936: close csr_name;
1937: fnd_message.set_name('PAY','PAY_34129_INPVAL_NAME_DEL');
1938: fnd_message.raise_error;
1939: end if;
1940: close csr_name;
1941:
1942: if pay_input_values_pkg.deletion_allowed (