DBA Data[Home] [Help]

APPS.BEN_OTP_BUS dependencies on FND_MESSAGE

Line 140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');

136: if c_uniq_optip%found then
137: --
138: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
139: close c_uniq_optip ;
140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
141: fnd_message.raise_error;
142: --
143: end if;
144: close c_uniq_optip ;

Line 141: fnd_message.raise_error;

137: --
138: hr_utility.set_location('Future record exists.Cannot insert ', 8 ) ;
139: close c_uniq_optip ;
140: fnd_message.set_name('PER','HR_7211_DT_UPD_ROWS_IN_FUTURE');
141: fnd_message.raise_error;
142: --
143: end if;
144: close c_uniq_optip ;
145: --

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

189: close csr_sec_grp;
190: --
191: -- The primary key is invalid therefore we must error
192: --
193: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
194: fnd_message.raise_error;
195: --
196: end if;
197: close csr_sec_grp;

Line 194: fnd_message.raise_error;

190: --
191: -- The primary key is invalid therefore we must error
192: --
193: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
194: fnd_message.raise_error;
195: --
196: end if;
197: close csr_sec_grp;
198: --

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

266: --
267: -- The primary key is invalid therefore we must error
268: --
269: close csr_leg_code;
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: end if;
273: hr_utility.set_location(l_proc,30);
274: --

Line 271: fnd_message.raise_error;

267: -- The primary key is invalid therefore we must error
268: --
269: close csr_leg_code;
270: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
271: fnd_message.raise_error;
272: end if;
273: hr_utility.set_location(l_proc,30);
274: --
275: -- Set the global variables so the values are

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

517: (p_optip_id => p_rec.optip_id
518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;

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

518: ,p_effective_date => p_effective_date
519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --

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

519: ,p_object_version_number => p_rec.object_version_number
520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --
527: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 524: fnd_message.raise_error;

520: ) THEN
521: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
522: fnd_message.set_token('PROCEDURE ', l_proc);
523: fnd_message.set_token('STEP ', '5');
524: fnd_message.raise_error;
525: END IF;
526: --
527: -- EDIT_HERE: Add checks to ensure non-updateable args have
528: -- not been updated.

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

641: --
642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --

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

642: -- A referential integrity check was violated therefore
643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which

Line 647: fnd_message.raise_error;

643: -- we must error
644: --
645: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
646: fnd_message.set_token('TABLE_NAME', l_table_name);
647: fnd_message.raise_error;
648: When Others Then
649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report

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

649: --
650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;

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

650: -- An unhandled or unexpected error has occurred which
651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --

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

651: -- we must report
652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------

Line 656: fnd_message.raise_error;

652: --
653: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
654: fnd_message.set_token('PROCEDURE', l_proc);
655: fnd_message.set_token('STEP','15');
656: fnd_message.raise_error;
657: End dt_update_validate;
658: --
659: -- ----------------------------------------------------------------------------
660: -- |--------------------------< dt_delete_validate >--------------------------|

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

748: --
749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --

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

749: -- A referential integrity check was violated therefore
750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which

Line 754: fnd_message.raise_error;

750: -- we must error
751: --
752: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
753: fnd_message.set_token('TABLE_NAME', l_table_name);
754: fnd_message.raise_error;
755: When Others Then
756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report

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

756: --
757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --

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

757: -- An unhandled or unexpected error has occurred which
758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;

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

758: -- we must report
759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;
766: --

Line 763: fnd_message.raise_error;

759: --
760: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
761: fnd_message.set_token('PROCEDURE', l_proc);
762: fnd_message.set_token('STEP','15');
763: fnd_message.raise_error;
764: --
765: End dt_delete_validate;
766: --
767: -- ----------------------------------------------------------------------------