DBA Data[Home] [Help]

APPS.BEN_CCT_BUS dependencies on FND_MESSAGE

Line 124: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');

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);

Line 125: fnd_message.raise_error;

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;

Line 189: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 190: fnd_message.set_token('FIELD','p_rcpent_cd');

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;

Line 191: fnd_message.set_token('TYPE','BEN_RCPENT');

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: --

Line 192: fnd_message.raise_error;

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;

Line 260: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

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: --

Line 261: fnd_message.set_token('ID',p_inspn_rqd_rl);

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;

Line 262: fnd_message.set_token('TYPE_ID',-313);

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: --

Line 263: fnd_message.raise_error;

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;

Line 330: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 331: fnd_message.set_token('FIELD','p_inspn_rqd_flag');

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;

Line 332: fnd_message.set_token('TYPE','YES_NO');

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: --

Line 333: fnd_message.raise_error;

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;

Line 401: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

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: --

Line 402: fnd_message.set_token('ID',p_to_be_sent_dt_rl);

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;

Line 403: fnd_message.set_token('TYPE_ID',-45);

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: --

Line 404: fnd_message.raise_error;

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;

Line 473: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 474: fnd_message.set_token('FIELD',p_to_be_sent_dt_cd);

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;

Line 475: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');

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: --

Line 476: fnd_message.raise_error;

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;

Line 544: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 545: fnd_message.set_token('FIELD',p_trk_mlg_flag);

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;

Line 546: fnd_message.set_token('TYPE','YES_NO');

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: --

Line 547: fnd_message.raise_error;

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;

Line 615: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 616: fnd_message.set_token('FIELD',p_pc_kit_cd);

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;

Line 617: fnd_message.set_token('TYPE','BEN_PC_KIT');

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: --

Line 618: fnd_message.raise_error;

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;

Line 686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 687: fnd_message.set_token('FIELD','p_whnvr_trgrd_flag');

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;

Line 688: fnd_message.set_token('TYPE','YES_NO');

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: --

Line 689: fnd_message.raise_error;

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;

Line 758: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');

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: --

Line 759: fnd_message.set_token('FIELD','p_cm_usg_cd');

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;

Line 760: fnd_message.set_token('TYPE','BEN_USG');

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: --

Line 761: fnd_message.raise_error;

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;

Line 770: fnd_message.set_name('BEN','BEN_92654_SENT_DATE_FOR_USAGE');

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:

Line 771: fnd_message.set_token('TYPE','BEN_TO_BE_SENT_DT');

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:

Line 772: fnd_message.raise_error;

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);

Line 838: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');

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: --

Line 839: fnd_message.set_token('ID',p_cm_typ_rl);

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;

Line 840: fnd_message.set_token('TYPE_ID',-332);

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: --

Line 841: fnd_message.raise_error;

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;