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;
239: --
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: if p_source_table is null then
243: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
244: fnd_message.raise_error;
245: elsif p_source_column is null then
246: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
247: fnd_message.raise_error;
240: hr_utility.set_location('Entering:'||l_proc, 5);
241: --
242: if p_source_table is null then
243: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
244: fnd_message.raise_error;
245: elsif p_source_column is null then
246: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
247: fnd_message.raise_error;
248: else
242: if p_source_table is null then
243: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
244: fnd_message.raise_error;
245: elsif p_source_column is null then
246: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
247: fnd_message.raise_error;
248: else
249: -- check if table, column, new value, old value is unique
250: --
243: fnd_message.set_name('BEN', 'BEN_91020_TABLE_REQUIRED');
244: fnd_message.raise_error;
245: elsif p_source_column is null then
246: fnd_message.set_name('BEN', 'BEN_91021_COLUMN_REQUIRED');
247: fnd_message.raise_error;
248: else
249: -- check if table, column, new value, old value is unique
250: --
251: open c1
257: ,p_business_group_id => p_business_group_id) ;
258: fetch c1 into l_dummy;
259: if c1%found then
260: close c1;
261: fnd_message.set_name('BEN', 'BEN_91017_PERSON_CHANGE_UNIQUE');
262: fnd_message.raise_error;
263: end if;
264: close c1;
265: end if;
258: fetch c1 into l_dummy;
259: if c1%found then
260: close c1;
261: fnd_message.set_name('BEN', 'BEN_91017_PERSON_CHANGE_UNIQUE');
262: fnd_message.raise_error;
263: end if;
264: close c1;
265: end if;
266: --
327: ,p_business_group_id => p_business_group_id) ;
328: fetch c1 into l_dummy;
329: if c1%found then
330: close c1;
331: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
332: fnd_message.raise_error;
333: end if;
334: close c1;
335: --
328: fetch c1 into l_dummy;
329: if c1%found then
330: close c1;
331: fnd_message.set_name('BEN', 'BEN_91009_NAME_NOT_UNIQUE');
332: fnd_message.raise_error;
333: end if;
334: close c1;
335: --
336: hr_utility.set_location('Leaving:'||l_proc, 10);
398: ,p_business_group_id => p_business_group_id) ;
399: fetch c1 into l_dummy;
400: if c1%found then
401: close c1;
402: fnd_message.set_name('BEN', 'BEN_94013_WHATIF_LBL_UNIQUE');
403: fnd_message.raise_error;
404: end if;
405: close c1;
406: --
399: fetch c1 into l_dummy;
400: if c1%found then
401: close c1;
402: fnd_message.set_name('BEN', 'BEN_94013_WHATIF_LBL_UNIQUE');
403: fnd_message.raise_error;
404: end if;
405: close c1;
406: --
407: end if;
491: --
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_update_validate;
492: -- An unhandled or unexpected error has occurred which
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_update_validate;
500: --
493: -- we must report
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_update_validate;
500: --
501: -- ----------------------------------------------------------------------------
494: --
495: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
496: fnd_message.set_token('PROCEDURE', l_proc);
497: fnd_message.set_token('STEP','15');
498: fnd_message.raise_error;
499: End dt_update_validate;
500: --
501: -- ----------------------------------------------------------------------------
502: -- |--------------------------< dt_delete_validate >--------------------------|
601: --
602: -- An unhandled or unexpected error has occurred which
603: -- we must report
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','15');
608: fnd_message.raise_error;
609: End dt_delete_validate;
602: -- An unhandled or unexpected error has occurred which
603: -- we must report
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','15');
608: fnd_message.raise_error;
609: End dt_delete_validate;
610: --
603: -- we must report
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','15');
608: fnd_message.raise_error;
609: End dt_delete_validate;
610: --
611: -- ----------------------------------------------------------------------------
604: --
605: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
606: fnd_message.set_token('PROCEDURE', l_proc);
607: fnd_message.set_token('STEP','15');
608: fnd_message.raise_error;
609: End dt_delete_validate;
610: --
611: -- ----------------------------------------------------------------------------
612: -- |---------------------------< insert_validate >----------------------------|
800: close csr_leg_code;
801: --
802: -- The primary key is invalid therefore we must error
803: --
804: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
805: fnd_message.raise_error;
806: --
807: end if;
808: --
801: --
802: -- The primary key is invalid therefore we must error
803: --
804: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
805: fnd_message.raise_error;
806: --
807: end if;
808: --
809: close csr_leg_code;