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: --
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;
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;
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
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: --
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
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;
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: --
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: --
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);
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: --
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;
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >--------------------------|
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >----------------------------|
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: --
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;