DBA Data[Home] [Help]

APPS.BEN_PSL_BUS dependencies on FND_MESSAGE

Line 157: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');

153: close c1;
154: --
155: -- raise error
156: --
157: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
158: fnd_message.raise_error;
159: --
160: end if;
161: --

Line 158: fnd_message.raise_error;

154: --
155: -- raise error
156: --
157: fnd_message.set_name('BEN','BEN_91007_INVALID_RULE');
158: fnd_message.raise_error;
159: --
160: end if;
161: --
162: close c1;

Line 245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');

241: --
242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: if p_source_table is null then
245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
246: fnd_message.raise_error;
247: elsif p_source_column is null then
248: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
249: fnd_message.raise_error;

Line 246: fnd_message.raise_error;

242: hr_utility.set_location('Entering:'||l_proc, 5);
243: --
244: if p_source_table is null then
245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
246: fnd_message.raise_error;
247: elsif p_source_column is null then
248: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
249: fnd_message.raise_error;
250: else

Line 248: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');

244: if p_source_table is null then
245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
246: fnd_message.raise_error;
247: elsif p_source_column is null then
248: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
249: fnd_message.raise_error;
250: else
251: -- check if table, column, new value, old value is unique
252: --

Line 249: fnd_message.raise_error;

245: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
246: fnd_message.raise_error;
247: elsif p_source_column is null then
248: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
249: fnd_message.raise_error;
250: else
251: -- check if table, column, new value, old value is unique
252: --
253: open c1

Line 264: fnd_message.set_name('BEN', 'BEN_91017_PERSON_CHANGE_UNIQUE');

260: ,p_business_group_id => p_business_group_id) ;
261: fetch c1 into l_dummy;
262: if c1%found then
263: close c1;
264: fnd_message.set_name('BEN', 'BEN_91017_PERSON_CHANGE_UNIQUE');
265: fnd_message.raise_error;
266: end if;
267: close c1;
268: end if;

Line 265: fnd_message.raise_error;

261: fetch c1 into l_dummy;
262: if c1%found then
263: close c1;
264: fnd_message.set_name('BEN', 'BEN_91017_PERSON_CHANGE_UNIQUE');
265: fnd_message.raise_error;
266: end if;
267: close c1;
268: end if;
269: --

Line 337: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');

333: ,p_business_group_id => p_business_group_id) ;
334: fetch c1 into l_dummy;
335: if c1%found then
336: close c1;
337: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
338: fnd_message.raise_error;
339: end if;
340: close c1;
341: --

Line 338: fnd_message.raise_error;

334: fetch c1 into l_dummy;
335: if c1%found then
336: close c1;
337: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
338: fnd_message.raise_error;
339: end if;
340: close c1;
341: --
342: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 406: fnd_message.set_name('BEN', 'BEN_94013_WHATIF_LBL_UNIQUE');

402: ,p_business_group_id => p_business_group_id) ;
403: fetch c1 into l_dummy;
404: if c1%found then
405: close c1;
406: fnd_message.set_name('BEN', 'BEN_94013_WHATIF_LBL_UNIQUE');
407: fnd_message.raise_error;
408: end if;
409: close c1;
410: --

Line 407: fnd_message.raise_error;

403: fetch c1 into l_dummy;
404: if c1%found then
405: close c1;
406: fnd_message.set_name('BEN', 'BEN_94013_WHATIF_LBL_UNIQUE');
407: fnd_message.raise_error;
408: end if;
409: close c1;
410: --
411: end if;

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

494: --
495: -- An unhandled or unexpected error has occurred which
496: -- we must report
497: --
498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
499: fnd_message.set_token('PROCEDURE', l_proc);
500: fnd_message.set_token('STEP','15');
501: fnd_message.raise_error;
502: End dt_update_validate;

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

495: -- An unhandled or unexpected error has occurred which
496: -- we must report
497: --
498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
499: fnd_message.set_token('PROCEDURE', l_proc);
500: fnd_message.set_token('STEP','15');
501: fnd_message.raise_error;
502: End dt_update_validate;
503: --

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

496: -- we must report
497: --
498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
499: fnd_message.set_token('PROCEDURE', l_proc);
500: fnd_message.set_token('STEP','15');
501: fnd_message.raise_error;
502: End dt_update_validate;
503: --
504: -- ----------------------------------------------------------------------------

Line 501: fnd_message.raise_error;

497: --
498: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
499: fnd_message.set_token('PROCEDURE', l_proc);
500: fnd_message.set_token('STEP','15');
501: fnd_message.raise_error;
502: End dt_update_validate;
503: --
504: -- ----------------------------------------------------------------------------
505: -- |--------------------------< dt_delete_validate >--------------------------|

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

604: --
605: -- An unhandled or unexpected error has occurred which
606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;

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

605: -- An unhandled or unexpected error has occurred which
606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --

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

606: -- we must report
607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --
614: -- ----------------------------------------------------------------------------

Line 611: fnd_message.raise_error;

607: --
608: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
609: fnd_message.set_token('PROCEDURE', l_proc);
610: fnd_message.set_token('STEP','15');
611: fnd_message.raise_error;
612: End dt_delete_validate;
613: --
614: -- ----------------------------------------------------------------------------
615: -- |---------------------------< insert_validate >----------------------------|

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

804: close csr_leg_code;
805: --
806: -- The primary key is invalid therefore we must error
807: --
808: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
809: fnd_message.raise_error;
810: --
811: end if;
812: --

Line 809: fnd_message.raise_error;

805: --
806: -- The primary key is invalid therefore we must error
807: --
808: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
809: fnd_message.raise_error;
810: --
811: end if;
812: --
813: close csr_leg_code;