155: -- raise error as UK1 is violated
156: --
157: --Bug No 4999894 Message text has been edited
158:
159: fnd_message.set_name('BEN','BEN_91629_VALUE_NOT_UNIQUE');
160: fnd_message.set_token('PARMA',fnd_date.date_to_displaydate(l_effective_start_date));
161: fnd_message.raise_error;
162:
163: -- End of Bug 4999894
156: --
157: --Bug No 4999894 Message text has been edited
158:
159: fnd_message.set_name('BEN','BEN_91629_VALUE_NOT_UNIQUE');
160: fnd_message.set_token('PARMA',fnd_date.date_to_displaydate(l_effective_start_date));
161: fnd_message.raise_error;
162:
163: -- End of Bug 4999894
164: --
157: --Bug No 4999894 Message text has been edited
158:
159: fnd_message.set_name('BEN','BEN_91629_VALUE_NOT_UNIQUE');
160: fnd_message.set_token('PARMA',fnd_date.date_to_displaydate(l_effective_start_date));
161: fnd_message.raise_error;
162:
163: -- End of Bug 4999894
164: --
165: --
232: p_effective_date => p_effective_date) then
233: --
234: -- raise error as does not exist as lookup
235: --
236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
237: fnd_message.set_token('FIELD','p_mndtry_flag');
238: fnd_message.set_token('TYPE','YES_NO');
239: fnd_message.raise_error;
240: --
233: --
234: -- raise error as does not exist as lookup
235: --
236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
237: fnd_message.set_token('FIELD','p_mndtry_flag');
238: fnd_message.set_token('TYPE','YES_NO');
239: fnd_message.raise_error;
240: --
241: end if;
234: -- raise error as does not exist as lookup
235: --
236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
237: fnd_message.set_token('FIELD','p_mndtry_flag');
238: fnd_message.set_token('TYPE','YES_NO');
239: fnd_message.raise_error;
240: --
241: end if;
242: --
235: --
236: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
237: fnd_message.set_token('FIELD','p_mndtry_flag');
238: fnd_message.set_token('TYPE','YES_NO');
239: fnd_message.raise_error;
240: --
241: end if;
242: --
243: end if;
325: close c1;
326: --
327: -- raise error
328: --
329: fnd_message.set_name('BEN','BEN_91630_ELIG_RULE_NOT_VALID');
330: fnd_message.raise_error;
331: --
332: end if;
333: --
326: --
327: -- raise error
328: --
329: fnd_message.set_name('BEN','BEN_91630_ELIG_RULE_NOT_VALID');
330: fnd_message.raise_error;
331: --
332: end if;
333: --
334: close c1;
474: --
475: -- An unhandled or unexpected error has occurred which
476: -- we must report
477: --
478: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
479: fnd_message.set_token('PROCEDURE', l_proc);
480: fnd_message.set_token('STEP','15');
481: fnd_message.raise_error;
482: End dt_update_validate;
475: -- An unhandled or unexpected error has occurred which
476: -- we must report
477: --
478: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
479: fnd_message.set_token('PROCEDURE', l_proc);
480: fnd_message.set_token('STEP','15');
481: fnd_message.raise_error;
482: End dt_update_validate;
483: --
476: -- we must report
477: --
478: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
479: fnd_message.set_token('PROCEDURE', l_proc);
480: fnd_message.set_token('STEP','15');
481: fnd_message.raise_error;
482: End dt_update_validate;
483: --
484: -- ----------------------------------------------------------------------------
477: --
478: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
479: fnd_message.set_token('PROCEDURE', l_proc);
480: fnd_message.set_token('STEP','15');
481: fnd_message.raise_error;
482: End dt_update_validate;
483: --
484: -- ----------------------------------------------------------------------------
485: -- |--------------------------< dt_delete_validate >--------------------------|
576: --
577: -- An unhandled or unexpected error has occurred which
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
577: -- An unhandled or unexpected error has occurred which
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
578: -- we must report
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
586: -- ----------------------------------------------------------------------------
579: --
580: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
581: fnd_message.set_token('PROCEDURE', l_proc);
582: fnd_message.set_token('STEP','15');
583: fnd_message.raise_error;
584: End dt_delete_validate;
585: --
586: -- ----------------------------------------------------------------------------
587: -- |---------------------------< insert_validate >----------------------------|
768: close csr_leg_code;
769: --
770: -- The primary key is invalid therefore we must error
771: --
772: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
773: fnd_message.raise_error;
774: --
775: end if;
776: --
769: --
770: -- The primary key is invalid therefore we must error
771: --
772: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
773: fnd_message.raise_error;
774: --
775: end if;
776: --
777: close csr_leg_code;