DBA Data[Home] [Help]

APPS.BEN_QIG_BUS dependencies on FND_MESSAGE

Line 186: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');

182: close c3;
183: --
184: -- raise error as this quartile in grade already exists for this profile
185: --
186: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
187: fnd_message.set_token('VAR1','Quartile in Grade criteria');
188: fnd_message.set_token('VAR2','Variable Rate Profile');
189: fnd_message.raise_error;
190: --

Line 187: fnd_message.set_token('VAR1','Quartile in Grade criteria');

183: --
184: -- raise error as this quartile in grade already exists for this profile
185: --
186: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
187: fnd_message.set_token('VAR1','Quartile in Grade criteria');
188: fnd_message.set_token('VAR2','Variable Rate Profile');
189: fnd_message.raise_error;
190: --
191: end if;

Line 188: fnd_message.set_token('VAR2','Variable Rate Profile');

184: -- raise error as this quartile in grade already exists for this profile
185: --
186: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
187: fnd_message.set_token('VAR1','Quartile in Grade criteria');
188: fnd_message.set_token('VAR2','Variable Rate Profile');
189: fnd_message.raise_error;
190: --
191: end if;
192: close c3;

Line 189: fnd_message.raise_error;

185: --
186: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
187: fnd_message.set_token('VAR1','Quartile in Grade criteria');
188: fnd_message.set_token('VAR2','Variable Rate Profile');
189: fnd_message.raise_error;
190: --
191: end if;
192: close c3;
193: --

Line 259: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');

255: p_effective_date => p_effective_date) then
256: --
257: -- raise error as does not exist as lookup
258: --
259: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
260: fnd_message.raise_error;
261: --
262: end if;
263: --

Line 260: fnd_message.raise_error;

256: --
257: -- raise error as does not exist as lookup
258: --
259: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
260: fnd_message.raise_error;
261: --
262: end if;
263: --
264: end if;

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

310: close csr_sec_grp;
311: --
312: -- The primary key is invalid therefore we must error
313: --
314: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
315: hr_multi_message.add
316: (p_associated_column1
317: => nvl(p_associated_column1,'QUA_IN_GR_RT_ID')
318: );

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

387: --
388: -- The primary key is invalid therefore we must error
389: --
390: close csr_leg_code;
391: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
392: fnd_message.raise_error;
393: end if;
394: hr_utility.set_location(l_proc,30);
395: --

Line 392: fnd_message.raise_error;

388: -- The primary key is invalid therefore we must error
389: --
390: close csr_leg_code;
391: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
392: fnd_message.raise_error;
393: end if;
394: hr_utility.set_location(l_proc,30);
395: --
396: -- Set the global variables so the values are

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

624: (p_qua_in_gr_rt_id => p_rec.qua_in_gr_rt_id
625: ,p_effective_date => p_effective_date
626: ,p_object_version_number => p_rec.object_version_number
627: ) THEN
628: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE ', l_proc);
630: fnd_message.set_token('STEP ', '5');
631: fnd_message.raise_error;
632: END IF;

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

625: ,p_effective_date => p_effective_date
626: ,p_object_version_number => p_rec.object_version_number
627: ) THEN
628: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE ', l_proc);
630: fnd_message.set_token('STEP ', '5');
631: fnd_message.raise_error;
632: END IF;
633: --

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

626: ,p_object_version_number => p_rec.object_version_number
627: ) THEN
628: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE ', l_proc);
630: fnd_message.set_token('STEP ', '5');
631: fnd_message.raise_error;
632: END IF;
633: --
634: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 631: fnd_message.raise_error;

627: ) THEN
628: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
629: fnd_message.set_token('PROCEDURE ', l_proc);
630: fnd_message.set_token('STEP ', '5');
631: fnd_message.raise_error;
632: END IF;
633: --
634: -- EDIT_HERE: Add checks to ensure non-updateable args have
635: -- not been updated.

Line 698: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');

694: open c1;
695: fetch c1 into l_dummy;
696: --
697: if c1%found then
698: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
699: fnd_message.raise_error;
700: end if;
701: close c1;
702: --

Line 699: fnd_message.raise_error;

695: fetch c1 into l_dummy;
696: --
697: if c1%found then
698: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
699: fnd_message.raise_error;
700: end if;
701: close c1;
702: --
703: hr_utility.set_location('Leaving:'||l_proc, 15);

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

777: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
778: ,p_base_key_value => p_vrbl_rt_prfl_id
779: ,p_from_date => p_validation_start_date
780: ,p_to_date => p_validation_end_date))) Then
781: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
782: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
783: hr_multi_message.add
784: (p_associated_column1 => ben_qig_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
785: End If;

Line 782: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');

778: ,p_base_key_value => p_vrbl_rt_prfl_id
779: ,p_from_date => p_validation_start_date
780: ,p_to_date => p_validation_end_date))) Then
781: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
782: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
783: hr_multi_message.add
784: (p_associated_column1 => ben_qig_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
785: End If;
786: --

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

789: --
790: -- An unhandled or unexpected error has occurred which
791: -- we must report
792: --
793: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
794: fnd_message.set_token('PROCEDURE', l_proc);
795: fnd_message.set_token('STEP','15');
796: fnd_message.raise_error;
797: End dt_update_validate;

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

790: -- An unhandled or unexpected error has occurred which
791: -- we must report
792: --
793: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
794: fnd_message.set_token('PROCEDURE', l_proc);
795: fnd_message.set_token('STEP','15');
796: fnd_message.raise_error;
797: End dt_update_validate;
798: --

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

791: -- we must report
792: --
793: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
794: fnd_message.set_token('PROCEDURE', l_proc);
795: fnd_message.set_token('STEP','15');
796: fnd_message.raise_error;
797: End dt_update_validate;
798: --
799: -- ----------------------------------------------------------------------------

Line 796: fnd_message.raise_error;

792: --
793: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
794: fnd_message.set_token('PROCEDURE', l_proc);
795: fnd_message.set_token('STEP','15');
796: fnd_message.raise_error;
797: End dt_update_validate;
798: --
799: -- ----------------------------------------------------------------------------
800: -- |--------------------------< dt_delete_validate >--------------------------|

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

886: --
887: -- An unhandled or unexpected error has occurred which
888: -- we must report
889: --
890: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
891: fnd_message.set_token('PROCEDURE', l_proc);
892: fnd_message.set_token('STEP','15');
893: fnd_message.raise_error;
894: --

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

887: -- An unhandled or unexpected error has occurred which
888: -- we must report
889: --
890: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
891: fnd_message.set_token('PROCEDURE', l_proc);
892: fnd_message.set_token('STEP','15');
893: fnd_message.raise_error;
894: --
895: End dt_delete_validate;

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

888: -- we must report
889: --
890: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
891: fnd_message.set_token('PROCEDURE', l_proc);
892: fnd_message.set_token('STEP','15');
893: fnd_message.raise_error;
894: --
895: End dt_delete_validate;
896: --

Line 893: fnd_message.raise_error;

889: --
890: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
891: fnd_message.set_token('PROCEDURE', l_proc);
892: fnd_message.set_token('STEP','15');
893: fnd_message.raise_error;
894: --
895: End dt_delete_validate;
896: --
897: -- ----------------------------------------------------------------------------