DBA Data[Home] [Help]

APPS.BEN_CTY_BUS dependencies on FND_MESSAGE

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

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

Line 189: fnd_message.set_token('VAR1','Competency criteria');

185: --
186: -- raise error as this job already exists for this profile
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;

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

186: -- raise error as this job already exists for this profile
187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;
194: close c3;

Line 191: fnd_message.raise_error;

187: --
188: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
189: fnd_message.set_token('VAR1','Competency criteria');
190: fnd_message.set_token('VAR2','Variable Rate Profile');
191: fnd_message.raise_error;
192: --
193: end if;
194: close c3;
195: --

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

310: close c3;
311: --
312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --

Line 315: fnd_message.set_token('VAR1','Competency criteria');

311: --
312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;

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

312: -- raise error as this competnecy already exists for this profile
313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;
320: close c3;

Line 317: fnd_message.raise_error;

313: --
314: fnd_message.set_name('BEN', 'BEN_92992_DUPS_ROW');
315: fnd_message.set_token('VAR1','Competency criteria');
316: fnd_message.set_token('VAR2','Variable Rate Profile');
317: fnd_message.raise_error;
318: --
319: end if;
320: close c3;
321: --

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

385: p_effective_date => p_effective_date) then
386: --
387: -- raise error as does not exist as lookup
388: --
389: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
390: fnd_message.raise_error;
391: --
392: end if;
393: --

Line 390: fnd_message.raise_error;

386: --
387: -- raise error as does not exist as lookup
388: --
389: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
390: fnd_message.raise_error;
391: --
392: end if;
393: --
394: end if;

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

455: open c1;
456: fetch c1 into l_dummy;
457: --
458: if c1%found then
459: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
460: fnd_message.raise_error;
461: end if;
462: close c1;
463: --

Line 460: fnd_message.raise_error;

456: fetch c1 into l_dummy;
457: --
458: if c1%found then
459: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
460: fnd_message.raise_error;
461: end if;
462: close c1;
463: --
464: hr_utility.set_location('Leaving:'||l_proc, 15);

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

508: close csr_sec_grp;
509: --
510: -- The primary key is invalid therefore we must error
511: --
512: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
513: hr_multi_message.add
514: (p_associated_column1
515: => nvl(p_associated_column1,'comptncy_rt_ID')
516: );

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

585: --
586: -- The primary key is invalid therefore we must error
587: --
588: close csr_leg_code;
589: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
590: fnd_message.raise_error;
591: end if;
592: hr_utility.set_location(l_proc,30);
593: --

Line 590: fnd_message.raise_error;

586: -- The primary key is invalid therefore we must error
587: --
588: close csr_leg_code;
589: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
590: fnd_message.raise_error;
591: end if;
592: hr_utility.set_location(l_proc,30);
593: --
594: -- Set the global variables so the values are

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

822: (p_comptncy_rt_id => p_rec.comptncy_rt_id
823: ,p_effective_date => p_effective_date
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;

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

823: ,p_effective_date => p_effective_date
824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --

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

824: ,p_object_version_number => p_rec.object_version_number
825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --
832: -- EDIT_HERE: Add checks to ensure non-updateable args have

Line 829: fnd_message.raise_error;

825: ) THEN
826: fnd_message.set_name('PER', 'HR_6153_ALL_PROCEDURE_FAIL');
827: fnd_message.set_token('PROCEDURE ', l_proc);
828: fnd_message.set_token('STEP ', '5');
829: fnd_message.raise_error;
830: END IF;
831: --
832: -- EDIT_HERE: Add checks to ensure non-updateable args have
833: -- not been updated.

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

904: ,p_base_key_column => 'VRBL_RT_PRFL_ID'
905: ,p_base_key_value => p_vrbl_rt_prfl_id
906: ,p_from_date => p_validation_start_date
907: ,p_to_date => p_validation_end_date))) Then
908: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
909: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
910: hr_multi_message.add
911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
912: End If;

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

905: ,p_base_key_value => p_vrbl_rt_prfl_id
906: ,p_from_date => p_validation_start_date
907: ,p_to_date => p_validation_end_date))) Then
908: fnd_message.set_name('PAY', 'HR_7216_DT_UPD_INTEGRITY_ERR');
909: fnd_message.set_token('TABLE_NAME','vrbl rt prfl');
910: hr_multi_message.add
911: (p_associated_column1 => ben_cty_shd.g_tab_nam || '.VRBL_RT_PRFL_ID');
912: End If;
913: --

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

916: --
917: -- An unhandled or unexpected error has occurred which
918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;

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

917: -- An unhandled or unexpected error has occurred which
918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --

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

918: -- we must report
919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --
926: -- ----------------------------------------------------------------------------

Line 923: fnd_message.raise_error;

919: --
920: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
921: fnd_message.set_token('PROCEDURE', l_proc);
922: fnd_message.set_token('STEP','15');
923: fnd_message.raise_error;
924: End dt_update_validate;
925: --
926: -- ----------------------------------------------------------------------------
927: -- |--------------------------< dt_delete_validate >--------------------------|

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

1013: --
1014: -- An unhandled or unexpected error has occurred which
1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --

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

1014: -- An unhandled or unexpected error has occurred which
1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;

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

1015: -- we must report
1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;
1023: --

Line 1020: fnd_message.raise_error;

1016: --
1017: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
1018: fnd_message.set_token('PROCEDURE', l_proc);
1019: fnd_message.set_token('STEP','15');
1020: fnd_message.raise_error;
1021: --
1022: End dt_delete_validate;
1023: --
1024: -- ----------------------------------------------------------------------------