120: open c1;
121: fetch c1 into l_dummy;
122: if c1%found then
123: close c1;
124: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
125: fnd_message.raise_error;
126: end if;
127: --
128: hr_utility.set_location('Leaving:'||l_proc, 15);
121: fetch c1 into l_dummy;
122: if c1%found then
123: close c1;
124: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
125: fnd_message.raise_error;
126: end if;
127: --
128: hr_utility.set_location('Leaving:'||l_proc, 15);
129: End chk_name_unique;
185: p_effective_date => p_effective_date) then
186: --
187: -- raise error as does not exist as lookup
188: --
189: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
190: fnd_message.set_token('FIELD','p_rcpent_cd');
191: fnd_message.set_token('TYPE','BEN_RCPENT');
192: fnd_message.raise_error;
193: --
186: --
187: -- raise error as does not exist as lookup
188: --
189: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
190: fnd_message.set_token('FIELD','p_rcpent_cd');
191: fnd_message.set_token('TYPE','BEN_RCPENT');
192: fnd_message.raise_error;
193: --
194: end if;
187: -- raise error as does not exist as lookup
188: --
189: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
190: fnd_message.set_token('FIELD','p_rcpent_cd');
191: fnd_message.set_token('TYPE','BEN_RCPENT');
192: fnd_message.raise_error;
193: --
194: end if;
195: --
188: --
189: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
190: fnd_message.set_token('FIELD','p_rcpent_cd');
191: fnd_message.set_token('TYPE','BEN_RCPENT');
192: fnd_message.raise_error;
193: --
194: end if;
195: --
196: end if;
256: p_formula_type_id => -313,
257: p_business_group_id => p_business_group_id,
258: p_effective_date => p_effective_date) then
259: --
260: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
261: fnd_message.set_token('ID',p_inspn_rqd_rl);
262: fnd_message.set_token('TYPE_ID',-313);
263: fnd_message.raise_error;
264: --
257: p_business_group_id => p_business_group_id,
258: p_effective_date => p_effective_date) then
259: --
260: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
261: fnd_message.set_token('ID',p_inspn_rqd_rl);
262: fnd_message.set_token('TYPE_ID',-313);
263: fnd_message.raise_error;
264: --
265: end if;
258: p_effective_date => p_effective_date) then
259: --
260: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
261: fnd_message.set_token('ID',p_inspn_rqd_rl);
262: fnd_message.set_token('TYPE_ID',-313);
263: fnd_message.raise_error;
264: --
265: end if;
266: --
259: --
260: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
261: fnd_message.set_token('ID',p_inspn_rqd_rl);
262: fnd_message.set_token('TYPE_ID',-313);
263: fnd_message.raise_error;
264: --
265: end if;
266: --
267: end if;
326: p_effective_date => p_effective_date) then
327: --
328: -- raise error as does not exist as lookup
329: --
330: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
331: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
332: fnd_message.set_token('TYPE','YES_NO');
333: fnd_message.raise_error;
334: --
327: --
328: -- raise error as does not exist as lookup
329: --
330: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
331: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
332: fnd_message.set_token('TYPE','YES_NO');
333: fnd_message.raise_error;
334: --
335: end if;
328: -- raise error as does not exist as lookup
329: --
330: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
331: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
332: fnd_message.set_token('TYPE','YES_NO');
333: fnd_message.raise_error;
334: --
335: end if;
336: --
329: --
330: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
331: fnd_message.set_token('FIELD','p_inspn_rqd_flag');
332: fnd_message.set_token('TYPE','YES_NO');
333: fnd_message.raise_error;
334: --
335: end if;
336: --
337: end if;
397: p_formula_type_id => -45,
398: p_business_group_id => p_business_group_id,
399: p_effective_date => p_effective_date) then
400: --
401: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
402: fnd_message.set_token('ID',p_to_be_sent_dt_rl);
403: fnd_message.set_token('TYPE_ID',-45);
404: fnd_message.raise_error;
405: --
398: p_business_group_id => p_business_group_id,
399: p_effective_date => p_effective_date) then
400: --
401: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
402: fnd_message.set_token('ID',p_to_be_sent_dt_rl);
403: fnd_message.set_token('TYPE_ID',-45);
404: fnd_message.raise_error;
405: --
406: end if;
399: p_effective_date => p_effective_date) then
400: --
401: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
402: fnd_message.set_token('ID',p_to_be_sent_dt_rl);
403: fnd_message.set_token('TYPE_ID',-45);
404: fnd_message.raise_error;
405: --
406: end if;
407: --
400: --
401: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
402: fnd_message.set_token('ID',p_to_be_sent_dt_rl);
403: fnd_message.set_token('TYPE_ID',-45);
404: fnd_message.raise_error;
405: --
406: end if;
407: --
408: end if;
469: then
470: --
471: -- raise error as does not exist as lookup
472: --
473: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
474: fnd_message.set_token('FIELD',p_to_be_sent_dt_cd);
475: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
476: fnd_message.raise_error;
477: --
470: --
471: -- raise error as does not exist as lookup
472: --
473: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
474: fnd_message.set_token('FIELD',p_to_be_sent_dt_cd);
475: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
476: fnd_message.raise_error;
477: --
478: end if;
471: -- raise error as does not exist as lookup
472: --
473: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
474: fnd_message.set_token('FIELD',p_to_be_sent_dt_cd);
475: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
476: fnd_message.raise_error;
477: --
478: end if;
479: --
472: --
473: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
474: fnd_message.set_token('FIELD',p_to_be_sent_dt_cd);
475: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
476: fnd_message.raise_error;
477: --
478: end if;
479: --
480: end if;
540: p_effective_date => p_effective_date) then
541: --
542: -- raise error as does not exist as lookup
543: --
544: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
545: fnd_message.set_token('FIELD',p_trk_mlg_flag);
546: fnd_message.set_token('TYPE','YES_NO');
547: fnd_message.raise_error;
548: --
541: --
542: -- raise error as does not exist as lookup
543: --
544: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
545: fnd_message.set_token('FIELD',p_trk_mlg_flag);
546: fnd_message.set_token('TYPE','YES_NO');
547: fnd_message.raise_error;
548: --
549: end if;
542: -- raise error as does not exist as lookup
543: --
544: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
545: fnd_message.set_token('FIELD',p_trk_mlg_flag);
546: fnd_message.set_token('TYPE','YES_NO');
547: fnd_message.raise_error;
548: --
549: end if;
550: --
543: --
544: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
545: fnd_message.set_token('FIELD',p_trk_mlg_flag);
546: fnd_message.set_token('TYPE','YES_NO');
547: fnd_message.raise_error;
548: --
549: end if;
550: --
551: end if;
611: p_effective_date => p_effective_date) then
612: --
613: -- raise error as does not exist as lookup
614: --
615: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
616: fnd_message.set_token('FIELD',p_pc_kit_cd);
617: fnd_message.set_token('TYPE','BEN_PC_KIT');
618: fnd_message.raise_error;
619: --
612: --
613: -- raise error as does not exist as lookup
614: --
615: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
616: fnd_message.set_token('FIELD',p_pc_kit_cd);
617: fnd_message.set_token('TYPE','BEN_PC_KIT');
618: fnd_message.raise_error;
619: --
620: end if;
613: -- raise error as does not exist as lookup
614: --
615: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
616: fnd_message.set_token('FIELD',p_pc_kit_cd);
617: fnd_message.set_token('TYPE','BEN_PC_KIT');
618: fnd_message.raise_error;
619: --
620: end if;
621: --
614: --
615: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
616: fnd_message.set_token('FIELD',p_pc_kit_cd);
617: fnd_message.set_token('TYPE','BEN_PC_KIT');
618: fnd_message.raise_error;
619: --
620: end if;
621: --
622: end if;
682: p_effective_date => p_effective_date) then
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_whnvr_trgrd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --
683: --
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_whnvr_trgrd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --
691: end if;
684: -- raise error as does not exist as lookup
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_whnvr_trgrd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --
691: end if;
692: --
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_whnvr_trgrd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --
691: end if;
692: --
693: end if;
754: p_effective_date => p_effective_date) then
755: --
756: -- raise error as does not exist as lookup
757: --
758: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
759: fnd_message.set_token('FIELD','p_cm_usg_cd');
760: fnd_message.set_token('TYPE','BEN_USG');
761: fnd_message.raise_error;
762: --
755: --
756: -- raise error as does not exist as lookup
757: --
758: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
759: fnd_message.set_token('FIELD','p_cm_usg_cd');
760: fnd_message.set_token('TYPE','BEN_USG');
761: fnd_message.raise_error;
762: --
763: end if;
756: -- raise error as does not exist as lookup
757: --
758: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
759: fnd_message.set_token('FIELD','p_cm_usg_cd');
760: fnd_message.set_token('TYPE','BEN_USG');
761: fnd_message.raise_error;
762: --
763: end if;
764: --
757: --
758: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
759: fnd_message.set_token('FIELD','p_cm_usg_cd');
760: fnd_message.set_token('TYPE','BEN_USG');
761: fnd_message.raise_error;
762: --
763: end if;
764: --
765: end if;
766: --
767: -- bug 1384583 when the cm_usg_cod is 'SSIT' then validate p_to_be_sent dt for 'NA'
768: if (p_cm_usg_cd = 'SSIT' and p_to_be_sent_dt_cd <> 'NA') or
769: (p_to_be_sent_dt_cd='NA' and nvl(p_cm_usg_cd,' ') <> 'SSIT') then
770: fnd_message.set_name('BEN','BEN_92654_SENT_DATE_FOR_USAGE');
771: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
772: fnd_message.raise_error;
773: End if ;
774:
767: -- bug 1384583 when the cm_usg_cod is 'SSIT' then validate p_to_be_sent dt for 'NA'
768: if (p_cm_usg_cd = 'SSIT' and p_to_be_sent_dt_cd <> 'NA') or
769: (p_to_be_sent_dt_cd='NA' and nvl(p_cm_usg_cd,' ') <> 'SSIT') then
770: fnd_message.set_name('BEN','BEN_92654_SENT_DATE_FOR_USAGE');
771: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
772: fnd_message.raise_error;
773: End if ;
774:
775:
768: if (p_cm_usg_cd = 'SSIT' and p_to_be_sent_dt_cd <> 'NA') or
769: (p_to_be_sent_dt_cd='NA' and nvl(p_cm_usg_cd,' ') <> 'SSIT') then
770: fnd_message.set_name('BEN','BEN_92654_SENT_DATE_FOR_USAGE');
771: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');
772: fnd_message.raise_error;
773: End if ;
774:
775:
776: hr_utility.set_location('Leaving:'||l_proc,10);
834: p_formula_type_id => -332,
835: p_business_group_id => p_business_group_id,
836: p_effective_date => p_effective_date) then
837: --
838: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
839: fnd_message.set_token('ID',p_cm_typ_rl);
840: fnd_message.set_token('TYPE_ID',-332);
841: fnd_message.raise_error;
842: --
835: p_business_group_id => p_business_group_id,
836: p_effective_date => p_effective_date) then
837: --
838: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
839: fnd_message.set_token('ID',p_cm_typ_rl);
840: fnd_message.set_token('TYPE_ID',-332);
841: fnd_message.raise_error;
842: --
843: end if;
836: p_effective_date => p_effective_date) then
837: --
838: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
839: fnd_message.set_token('ID',p_cm_typ_rl);
840: fnd_message.set_token('TYPE_ID',-332);
841: fnd_message.raise_error;
842: --
843: end if;
844: --
837: --
838: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
839: fnd_message.set_token('ID',p_cm_typ_rl);
840: fnd_message.set_token('TYPE_ID',-332);
841: fnd_message.raise_error;
842: --
843: end if;
844: --
845: end if;