147: close c1;
148: --
149: -- raise error
150: --
151: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
152: fnd_message.raise_error;
153: --
154: end if;
155: --
148: --
149: -- raise error
150: --
151: fnd_message.set_name('PAY','FORMULA_DOES_NOT_EXIST');
152: fnd_message.raise_error;
153: --
154: end if;
155: --
156: close c1;
218: p_effective_date => p_effective_date) then
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
223: fnd_message.set_token('FIELD','p_sgmt_cstg_mthd_cd');
224: fnd_message.set_token('TYPE','BEN_SGMT_CSTG_MTHD');
225: fnd_message.raise_error;
226: --
219: --
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
223: fnd_message.set_token('FIELD','p_sgmt_cstg_mthd_cd');
224: fnd_message.set_token('TYPE','BEN_SGMT_CSTG_MTHD');
225: fnd_message.raise_error;
226: --
227: end if;
220: -- raise error as does not exist as lookup
221: --
222: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
223: fnd_message.set_token('FIELD','p_sgmt_cstg_mthd_cd');
224: fnd_message.set_token('TYPE','BEN_SGMT_CSTG_MTHD');
225: fnd_message.raise_error;
226: --
227: end if;
228: --
221: --
222: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
223: fnd_message.set_token('FIELD','p_sgmt_cstg_mthd_cd');
224: fnd_message.set_token('TYPE','BEN_SGMT_CSTG_MTHD');
225: fnd_message.raise_error;
226: --
227: end if;
228: --
229: end if;
266: hr_utility.set_location('Entering:'||l_proc, 5);
267: --
268: if p_code <> 'RL' and p_rule is not null then
269: --
270: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
271: fnd_message.raise_error;
272: --
273: elsif p_code = 'RL' and p_rule is null then
274: --
267: --
268: if p_code <> 'RL' and p_rule is not null then
269: --
270: fnd_message.set_name('BEN','BEN_91624_CD_RL_2');
271: fnd_message.raise_error;
272: --
273: elsif p_code = 'RL' and p_rule is null then
274: --
275: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
271: fnd_message.raise_error;
272: --
273: elsif p_code = 'RL' and p_rule is null then
274: --
275: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
276: fnd_message.raise_error;
277: end if;
278: -- --
279: hr_utility.set_location('Leaving:'||l_proc,10);
272: --
273: elsif p_code = 'RL' and p_rule is null then
274: --
275: fnd_message.set_name('BEN','BEN_91623_CD_RL_1');
276: fnd_message.raise_error;
277: end if;
278: -- --
279: hr_utility.set_location('Leaving:'||l_proc,10);
280: --
326: open c1;
327: fetch c1 into l_dummy;
328: if c1%found then
329: close c1;
330: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
331: fnd_message.raise_error;
332: end if;
333: --
334: hr_utility.set_location('Leaving:'||l_proc, 15);
327: fetch c1 into l_dummy;
328: if c1%found then
329: close c1;
330: fnd_message.set_name('BEN','BEN_91001_SEQ_NOT_UNIQUE');
331: fnd_message.raise_error;
332: end if;
333: --
334: hr_utility.set_location('Leaving:'||l_proc, 15);
335: End chk_sgmt_num_unique;
393: close c1;
394: --
395: -- raise an error as this p_sgmt_cstg_mthd_cd can't = 'VFA'
396: --
397: fnd_message.set_name('BEN','BEN_92257_SGMT_CSTG_ASNMT_LVL');
398: fnd_message.raise_error;
399: --
400: end if;
401: --
394: --
395: -- raise an error as this p_sgmt_cstg_mthd_cd can't = 'VFA'
396: --
397: fnd_message.set_name('BEN','BEN_92257_SGMT_CSTG_ASNMT_LVL');
398: fnd_message.raise_error;
399: --
400: end if;
401: --
402: close c1;
466: close c1;
467: --
468: -- raise an error
469: --
470: fnd_message.set_name('BEN','BEN_92529_NO_COST');
471: fnd_message.raise_error;
472: --
473: end if;
474: --
467: --
468: -- raise an error
469: --
470: fnd_message.set_name('BEN','BEN_92529_NO_COST');
471: fnd_message.raise_error;
472: --
473: end if;
474: --
475: if c1%found and l_cost_alloc_cd is null then
477: close c1;
478: --
479: -- raise an error
480: --
481: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
482: fnd_message.raise_error;
483: --
484: end if;
485:
478: --
479: -- raise an error
480: --
481: fnd_message.set_name('BEN','BEN_92530_DFLT_RQD');
482: fnd_message.raise_error;
483: --
484: end if;
485:
486: close c1;
579: --
580: -- An unhandled or unexpected error has occurred which
581: -- we must report
582: --
583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
584: fnd_message.set_token('PROCEDURE', l_proc);
585: fnd_message.set_token('STEP','15');
586: fnd_message.raise_error;
587: End dt_update_validate;
580: -- An unhandled or unexpected error has occurred which
581: -- we must report
582: --
583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
584: fnd_message.set_token('PROCEDURE', l_proc);
585: fnd_message.set_token('STEP','15');
586: fnd_message.raise_error;
587: End dt_update_validate;
588: --
581: -- we must report
582: --
583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
584: fnd_message.set_token('PROCEDURE', l_proc);
585: fnd_message.set_token('STEP','15');
586: fnd_message.raise_error;
587: End dt_update_validate;
588: --
589: -- ----------------------------------------------------------------------------
582: --
583: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
584: fnd_message.set_token('PROCEDURE', l_proc);
585: fnd_message.set_token('STEP','15');
586: fnd_message.raise_error;
587: End dt_update_validate;
588: --
589: -- ----------------------------------------------------------------------------
590: -- |--------------------------< dt_delete_validate >--------------------------|
675: --
676: -- A referential integrity check was violated therefore
677: -- we must error
678: --
679: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
680: fnd_message.set_token('TABLE_NAME', l_table_name);
681: fnd_message.raise_error;
682: When Others Then
683: --
676: -- A referential integrity check was violated therefore
677: -- we must error
678: --
679: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
680: fnd_message.set_token('TABLE_NAME', l_table_name);
681: fnd_message.raise_error;
682: When Others Then
683: --
684: -- An unhandled or unexpected error has occurred which
677: -- we must error
678: --
679: fnd_message.set_name('PAY', 'HR_7215_DT_CHILD_EXISTS');
680: fnd_message.set_token('TABLE_NAME', l_table_name);
681: fnd_message.raise_error;
682: When Others Then
683: --
684: -- An unhandled or unexpected error has occurred which
685: -- we must report
683: --
684: -- An unhandled or unexpected error has occurred which
685: -- we must report
686: --
687: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
688: fnd_message.set_token('PROCEDURE', l_proc);
689: fnd_message.set_token('STEP','15');
690: fnd_message.raise_error;
691: End dt_delete_validate;
684: -- An unhandled or unexpected error has occurred which
685: -- we must report
686: --
687: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
688: fnd_message.set_token('PROCEDURE', l_proc);
689: fnd_message.set_token('STEP','15');
690: fnd_message.raise_error;
691: End dt_delete_validate;
692: --
685: -- we must report
686: --
687: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
688: fnd_message.set_token('PROCEDURE', l_proc);
689: fnd_message.set_token('STEP','15');
690: fnd_message.raise_error;
691: End dt_delete_validate;
692: --
693: -- ----------------------------------------------------------------------------
686: --
687: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
688: fnd_message.set_token('PROCEDURE', l_proc);
689: fnd_message.set_token('STEP','15');
690: fnd_message.raise_error;
691: End dt_delete_validate;
692: --
693: -- ----------------------------------------------------------------------------
694: -- |---------------------------< insert_validate >----------------------------|
888: close csr_leg_code;
889: --
890: -- The primary key is invalid therefore we must error
891: --
892: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
893: fnd_message.raise_error;
894: --
895: end if;
896: --
889: --
890: -- The primary key is invalid therefore we must error
891: --
892: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
893: fnd_message.raise_error;
894: --
895: end if;
896: --
897: close csr_leg_code;