133: p_effective_date => p_effective_date) then
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_pl_regy_prps_cd');
139: fnd_message.set_token('TYPE', 'BEN_REGY_PRPS');
140: fnd_message.raise_error;
141: --
134: --
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_pl_regy_prps_cd');
139: fnd_message.set_token('TYPE', 'BEN_REGY_PRPS');
140: fnd_message.raise_error;
141: --
142: end if;
135: -- raise error as does not exist as lookup
136: --
137: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_pl_regy_prps_cd');
139: fnd_message.set_token('TYPE', 'BEN_REGY_PRPS');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
136: --
137: fnd_message.set_name('BEN', 'BEN_91628_LOOKUP_TYPE_GENERIC');
138: fnd_message.set_token('FIELD', 'p_pl_regy_prps_cd');
139: fnd_message.set_token('TYPE', 'BEN_REGY_PRPS');
140: fnd_message.raise_error;
141: --
142: end if;
143: --
144: end if;
239: --
240: -- An unhandled or unexpected error has occurred which
241: -- we must report
242: --
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','15');
246: fnd_message.raise_error;
247: End dt_update_validate;
240: -- An unhandled or unexpected error has occurred which
241: -- we must report
242: --
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','15');
246: fnd_message.raise_error;
247: End dt_update_validate;
248: --
241: -- we must report
242: --
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','15');
246: fnd_message.raise_error;
247: End dt_update_validate;
248: --
249: -- ----------------------------------------------------------------------------
242: --
243: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
244: fnd_message.set_token('PROCEDURE', l_proc);
245: fnd_message.set_token('STEP','15');
246: fnd_message.raise_error;
247: End dt_update_validate;
248: --
249: -- ----------------------------------------------------------------------------
250: -- |--------------------------< dt_delete_validate >--------------------------|
342: --
343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
347: fnd_message.set_token('PROCEDURE', l_proc);
348: fnd_message.set_token('STEP','15');
349: fnd_message.raise_error;
350: End dt_delete_validate;
343: -- An unhandled or unexpected error has occurred which
344: -- we must report
345: --
346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
347: fnd_message.set_token('PROCEDURE', l_proc);
348: fnd_message.set_token('STEP','15');
349: fnd_message.raise_error;
350: End dt_delete_validate;
351: --
344: -- we must report
345: --
346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
347: fnd_message.set_token('PROCEDURE', l_proc);
348: fnd_message.set_token('STEP','15');
349: fnd_message.raise_error;
350: End dt_delete_validate;
351: --
352: -- ----------------------------------------------------------------------------
345: --
346: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
347: fnd_message.set_token('PROCEDURE', l_proc);
348: fnd_message.set_token('STEP','15');
349: fnd_message.raise_error;
350: End dt_delete_validate;
351: --
352: -- ----------------------------------------------------------------------------
353: -- |---------------------------< insert_validate >----------------------------|
492: close csr_leg_code;
493: --
494: -- The primary key is invalid therefore we must error
495: --
496: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
497: fnd_message.raise_error;
498: --
499: end if;
500: --
493: --
494: -- The primary key is invalid therefore we must error
495: --
496: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
497: fnd_message.raise_error;
498: --
499: end if;
500: --
501: close csr_leg_code;