DBA Data[Home] [Help]

APPS.PAY_ITR_BUS dependencies on FND_MESSAGE

Line 59: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');

55: close csr_sec_grp;
56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;

Line 60: fnd_message.raise_error;

56: --
57: -- The primary key is invalid therefore we must error
58: --
59: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');
60: fnd_message.raise_error;
61: --
62: end if;
63: close csr_sec_grp;
64: --

Line 132: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');

128: --
129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --

Line 133: fnd_message.raise_error;

129: -- The primary key is invalid therefore we must error
130: --
131: close csr_leg_code;
132: fnd_message.set_name(801,'HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: end if;
135: hr_utility.set_location(l_proc,30);
136: --
137: -- Set the global variables so the values are

Line 194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');

190: (p_iterative_rule_id => p_rec.iterative_rule_id
191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;

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

191: ,p_effective_date => p_effective_date
192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --

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

192: ,p_object_version_number => p_rec.object_version_number
193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 197: fnd_message.raise_error;

193: ) THEN
194: fnd_message.set_name(800, 'HR_6153_ALL_PROCEDURE_FAIL');
195: fnd_message.set_token('PROCEDURE ', l_proc);
196: fnd_message.set_token('STEP ', '5');
197: fnd_message.raise_error;
198: END IF;
199: --
200: -- EDIT_HERE: Add checks to ensure non-updateable args have
201: -- not been updated.

Line 517: fnd_message.set_name('PAY', 'PAY_52906_ITR_MESSAGE_ERRROR');

513: pay_itr_shd.constraint_error('PAY_ITR_SEV_LEVEL_CHK');
514: end if;
515: --
516: if (p_input_value_id is not null) then
517: fnd_message.set_name('PAY', 'PAY_52906_ITR_MESSAGE_ERRROR');
518: fnd_message.raise_error;
519: end if;
520: --
521: elsif (p_iterative_rule_type = 'A') then

Line 518: fnd_message.raise_error;

514: end if;
515: --
516: if (p_input_value_id is not null) then
517: fnd_message.set_name('PAY', 'PAY_52906_ITR_MESSAGE_ERRROR');
518: fnd_message.raise_error;
519: end if;
520: --
521: elsif (p_iterative_rule_type = 'A') then
522: --

Line 533: fnd_message.set_name('PAY', 'PAY_52904_ITR_INPVAL_ERROR');

529: open C1;
530: fetch C1 into l_exists;
531: if ( C1%notfound ) then
532: close C1;
533: fnd_message.set_name('PAY', 'PAY_52904_ITR_INPVAL_ERROR');
534: fnd_message.raise_error;
535: else Close c1;
536: end if;
537: --

Line 534: fnd_message.raise_error;

530: fetch C1 into l_exists;
531: if ( C1%notfound ) then
532: close C1;
533: fnd_message.set_name('PAY', 'PAY_52904_ITR_INPVAL_ERROR');
534: fnd_message.raise_error;
535: else Close c1;
536: end if;
537: --
538: if (p_severity_level is not null) then

Line 539: fnd_message.set_name('PAY', 'PAY_52907_ITR_ADJUST_ERROR');

535: else Close c1;
536: end if;
537: --
538: if (p_severity_level is not null) then
539: fnd_message.set_name('PAY', 'PAY_52907_ITR_ADJUST_ERROR');
540: fnd_message.raise_error;
541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then

Line 540: fnd_message.raise_error;

536: end if;
537: --
538: if (p_severity_level is not null) then
539: fnd_message.set_name('PAY', 'PAY_52907_ITR_ADJUST_ERROR');
540: fnd_message.raise_error;
541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then

Line 545: fnd_message.set_name('PAY', 'PAY_52905_ITR_STOP_ERROR');

541: end if;
542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then
545: fnd_message.set_name('PAY', 'PAY_52905_ITR_STOP_ERROR');
546: fnd_message.raise_error;
547: end if;
548: end if;
549: end chk_iterative_rule_cond;

Line 546: fnd_message.raise_error;

542: --
543: elsif (p_iterative_rule_type = 'S') then
544: if (p_input_value_id is not null or p_severity_level is not null) then
545: fnd_message.set_name('PAY', 'PAY_52905_ITR_STOP_ERROR');
546: fnd_message.raise_error;
547: end if;
548: end if;
549: end chk_iterative_rule_cond;
550: --

Line 624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');

620: --
621: -- A referential integrity check was violated therefore
622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --

Line 625: fnd_message.set_token('TABLE_NAME', l_table_name);

621: -- A referential integrity check was violated therefore
622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which

Line 626: fnd_message.raise_error;

622: -- we must error
623: --
624: fnd_message.set_name(801, 'HR_7216_DT_UPD_INTEGRITY_ERR');
625: fnd_message.set_token('TABLE_NAME', l_table_name);
626: fnd_message.raise_error;
627: When Others Then
628: --
629: -- An unhandled or unexpected error has occurred which
630: -- we must report

Line 632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');

628: --
629: -- An unhandled or unexpected error has occurred which
630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;

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

629: -- An unhandled or unexpected error has occurred which
630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --

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

630: -- we must report
631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --
638: -- ----------------------------------------------------------------------------

Line 635: fnd_message.raise_error;

631: --
632: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
633: fnd_message.set_token('PROCEDURE', l_proc);
634: fnd_message.set_token('STEP','15');
635: fnd_message.raise_error;
636: End dt_update_validate;
637: --
638: -- ----------------------------------------------------------------------------
639: -- |--------------------------< dt_delete_validate >--------------------------|

Line 731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');

727: --
728: -- A referential integrity check was violated therefore
729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --

Line 732: fnd_message.set_token('TABLE_NAME', l_table_name);

728: -- A referential integrity check was violated therefore
729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --
736: -- An unhandled or unexpected error has occurred which

Line 733: fnd_message.raise_error;

729: -- we must error
730: --
731: fnd_message.set_name(801, 'HR_7215_DT_CHILD_EXISTS');
732: fnd_message.set_token('TABLE_NAME', l_table_name);
733: fnd_message.raise_error;
734: When Others Then
735: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report

Line 739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');

735: --
736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --

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

736: -- An unhandled or unexpected error has occurred which
737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;

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

737: -- we must report
738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;
745: --

Line 742: fnd_message.raise_error;

738: --
739: fnd_message.set_name(801, 'HR_6153_ALL_PROCEDURE_FAIL');
740: fnd_message.set_token('PROCEDURE', l_proc);
741: fnd_message.set_token('STEP','15');
742: fnd_message.raise_error;
743: --
744: End dt_delete_validate;
745: --
746: -- ----------------------------------------------------------------------------