231: p_effective_date => p_effective_date) then
232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
236: fnd_message.raise_error;
237: --
238: end if;
239: --
232: --
233: -- raise error as does not exist as lookup
234: --
235: fnd_message.set_name('PAY','HR_LOOKUP_DOES_NOT_EXIST');
236: fnd_message.raise_error;
237: --
238: end if;
239: --
240: end if;
293: open c1;
294: fetch c1 into l_dummy;
295: if c1%found then
296: close c1;
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
294: fetch c1 into l_dummy;
295: if c1%found then
296: close c1;
297: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
298: fnd_message.raise_error;
299: end if;
300: close c1;
301: --
302: hr_utility.set_location('Leaving:'||l_proc, 15);
393: --
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
394: -- An unhandled or unexpected error has occurred which
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
395: -- we must report
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
396: --
397: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
398: fnd_message.set_token('PROCEDURE', l_proc);
399: fnd_message.set_token('STEP','15');
400: fnd_message.raise_error;
401: End dt_update_validate;
402: --
403: -- ----------------------------------------------------------------------------
404: -- |--------------------------< dt_delete_validate >--------------------------|
496: --
497: -- An unhandled or unexpected error has occurred which
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
497: -- An unhandled or unexpected error has occurred which
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
498: -- we must report
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
506: -- ----------------------------------------------------------------------------
499: --
500: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
501: fnd_message.set_token('PROCEDURE', l_proc);
502: fnd_message.set_token('STEP','15');
503: fnd_message.raise_error;
504: End dt_delete_validate;
505: --
506: -- ----------------------------------------------------------------------------
507: -- |---------------------------< insert_validate >----------------------------|
678: close csr_leg_code;
679: --
680: -- The primary key is invalid therefore we must error
681: --
682: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
679: --
680: -- The primary key is invalid therefore we must error
681: --
682: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
683: fnd_message.raise_error;
684: --
685: end if;
686: --
687: close csr_leg_code;