DBA Data[Home] [Help]

APPS.BEN_XEL_BUS dependencies on FND_MESSAGE

Line 53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

49: close csr_sec_grp;
50: --
51: -- The primary key is invalid therefore we must error
52: --
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: --
56: end if;
57: close csr_sec_grp;

Line 54: fnd_message.raise_error;

50: --
51: -- The primary key is invalid therefore we must error
52: --
53: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
54: fnd_message.raise_error;
55: --
56: end if;
57: close csr_sec_grp;
58: --

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

199: p_effective_date => p_effective_date) then
200: --
201: -- raise error as does not exist as lookup
202: --
203: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
204: fnd_message.set_token('FIELD','p_frmt_mask_cd');
205: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
206: fnd_message.raise_error;
207: --

Line 204: fnd_message.set_token('FIELD','p_frmt_mask_cd');

200: --
201: -- raise error as does not exist as lookup
202: --
203: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
204: fnd_message.set_token('FIELD','p_frmt_mask_cd');
205: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
206: fnd_message.raise_error;
207: --
208: end if;

Line 205: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');

201: -- raise error as does not exist as lookup
202: --
203: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
204: fnd_message.set_token('FIELD','p_frmt_mask_cd');
205: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
206: fnd_message.raise_error;
207: --
208: end if;
209: --

Line 206: fnd_message.raise_error;

202: --
203: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
204: fnd_message.set_token('FIELD','p_frmt_mask_cd');
205: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
206: fnd_message.raise_error;
207: --
208: end if;
209: --
210: else

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

214: p_effective_date => p_effective_date) then
215: --
216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_frmt_mask_cd');
220: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
221: fnd_message.raise_error;
222: --

Line 219: fnd_message.set_token('FIELD','p_frmt_mask_cd');

215: --
216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_frmt_mask_cd');
220: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
221: fnd_message.raise_error;
222: --
223: end if;

Line 220: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');

216: -- raise error as does not exist as lookup
217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_frmt_mask_cd');
220: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
221: fnd_message.raise_error;
222: --
223: end if;
224: --

Line 221: fnd_message.raise_error;

217: --
218: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
219: fnd_message.set_token('FIELD','p_frmt_mask_cd');
220: fnd_message.set_token('TYPE','BEN_EXT_FRMT_MASK');
221: fnd_message.raise_error;
222: --
223: end if;
224: --
225: end if;

Line 242: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');

238: elsif substr(p_frmt_mask_cd,1,1) = 'D' then
239: select to_char(sysdate,p_meaning) into frmt_val from dual;
240: elsif substr(p_frmt_mask_cd,1,1) = 'S' then
241: if p_frmt_mask_cd not in ('S1','S2') then
242: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');
243: fnd_message.raise_error;
244: end if;
245: elsif substr(p_frmt_mask_cd,1,1) = 'P' then
246: if p_frmt_mask_cd not in ('P1','P2','P3','P4','P5') then

Line 243: fnd_message.raise_error;

239: select to_char(sysdate,p_meaning) into frmt_val from dual;
240: elsif substr(p_frmt_mask_cd,1,1) = 'S' then
241: if p_frmt_mask_cd not in ('S1','S2') then
242: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');
243: fnd_message.raise_error;
244: end if;
245: elsif substr(p_frmt_mask_cd,1,1) = 'P' then
246: if p_frmt_mask_cd not in ('P1','P2','P3','P4','P5') then
247: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');

Line 247: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');

243: fnd_message.raise_error;
244: end if;
245: elsif substr(p_frmt_mask_cd,1,1) = 'P' then
246: if p_frmt_mask_cd not in ('P1','P2','P3','P4','P5') then
247: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');
248: fnd_message.raise_error;
249: end if;
250: end if;
251: end if;

Line 248: fnd_message.raise_error;

244: end if;
245: elsif substr(p_frmt_mask_cd,1,1) = 'P' then
246: if p_frmt_mask_cd not in ('P1','P2','P3','P4','P5') then
247: fnd_message.set_name('BEN','BEN_91960_FRMT_MSK_UNSPRTD');
248: fnd_message.raise_error;
249: end if;
250: end if;
251: end if;
252: --

Line 257: fnd_message.set_name('BEN','BEN_91959_INVLD_FRMT_MSK');

253: hr_utility.set_location('Leaving:'||l_proc,10);
254: --
255: Exception
256: When invalid_frmt1 or invalid_frmt2 then
257: fnd_message.set_name('BEN','BEN_91959_INVLD_FRMT_MSK');
258: fnd_message.raise_error;
259: end chk_frmt_mask_cd;
260: --
261: -- ----------------------------------------------------------------------------

Line 258: fnd_message.raise_error;

254: --
255: Exception
256: When invalid_frmt1 or invalid_frmt2 then
257: fnd_message.set_name('BEN','BEN_91959_INVLD_FRMT_MSK');
258: fnd_message.raise_error;
259: end chk_frmt_mask_cd;
260: --
261: -- ----------------------------------------------------------------------------
262: -- |------< chk_data_elmt_rl >------|

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

351: close c1;
352: --
353: -- raise error
354: --
355: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
356: fnd_message.set_token('ID',p_data_elmt_rl);
357: fnd_message.set_token('TYPE_ID',-413);
358: fnd_message.raise_error;
359: --

Line 356: fnd_message.set_token('ID',p_data_elmt_rl);

352: --
353: -- raise error
354: --
355: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
356: fnd_message.set_token('ID',p_data_elmt_rl);
357: fnd_message.set_token('TYPE_ID',-413);
358: fnd_message.raise_error;
359: --
360: end if;

Line 357: fnd_message.set_token('TYPE_ID',-413);

353: -- raise error
354: --
355: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
356: fnd_message.set_token('ID',p_data_elmt_rl);
357: fnd_message.set_token('TYPE_ID',-413);
358: fnd_message.raise_error;
359: --
360: end if;
361: --

Line 358: fnd_message.raise_error;

354: --
355: fnd_message.set_name('BEN','BEN_91471_FORMULA_NOT_FOUND');
356: fnd_message.set_token('ID',p_data_elmt_rl);
357: fnd_message.set_token('TYPE_ID',-413);
358: fnd_message.raise_error;
359: --
360: end if;
361: --
362: close c1;

Line 417: fnd_message.set_name('BEN','BEN_92616_XER_RECS_EXIST');

413: close c1;
414: --
415: -- raise error
416: --
417: fnd_message.set_name('BEN','BEN_92616_XER_RECS_EXIST');
418: fnd_message.raise_error;
419: --
420: end if;
421: --

Line 418: fnd_message.raise_error;

414: --
415: -- raise error
416: --
417: fnd_message.set_name('BEN','BEN_92616_XER_RECS_EXIST');
418: fnd_message.raise_error;
419: --
420: end if;
421: --
422: close c1;

Line 459: fnd_message.set_name('BEN','BEN_91865_INVLD_MAX_NUM');

455: hr_utility.set_location('Entering:'||l_proc, 5);
456: --
457: --
458: if p_max_length_num =0 or p_max_length_num <0 then
459: fnd_message.set_name('BEN','BEN_91865_INVLD_MAX_NUM');
460: fnd_message.raise_error;
461: end if;
462: --
463: if p_max_length_num >0 then

Line 460: fnd_message.raise_error;

456: --
457: --
458: if p_max_length_num =0 or p_max_length_num <0 then
459: fnd_message.set_name('BEN','BEN_91865_INVLD_MAX_NUM');
460: fnd_message.raise_error;
461: end if;
462: --
463: if p_max_length_num >0 then
464: if p_dflt_val is not null then

Line 466: fnd_message.set_name('BEN','BEN_91866_INVLD_DFLT_VAL');

462: --
463: if p_max_length_num >0 then
464: if p_dflt_val is not null then
465: if length(p_dflt_val) > p_max_length_num then
466: fnd_message.set_name('BEN','BEN_91866_INVLD_DFLT_VAL');
467: fnd_message.raise_error;
468: end if;
469: end if;
470: end if;

Line 467: fnd_message.raise_error;

463: if p_max_length_num >0 then
464: if p_dflt_val is not null then
465: if length(p_dflt_val) > p_max_length_num then
466: fnd_message.set_name('BEN','BEN_91866_INVLD_DFLT_VAL');
467: fnd_message.raise_error;
468: end if;
469: end if;
470: end if;
471: hr_utility.set_location('Leaving:'||l_proc,10);

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

541: p_effective_date => p_effective_date) then
542: --
543: -- raise error as does not exist as lookup
544: --
545: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
548: fnd_message.raise_error;
549: --

Line 546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');

542: --
543: -- raise error as does not exist as lookup
544: --
545: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
548: fnd_message.raise_error;
549: --
550: end if;

Line 547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');

543: -- raise error as does not exist as lookup
544: --
545: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
548: fnd_message.raise_error;
549: --
550: end if;
551: --

Line 548: fnd_message.raise_error;

544: --
545: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
546: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
547: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
548: fnd_message.raise_error;
549: --
550: end if;
551: --
552: else

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

556: p_effective_date => p_effective_date) then
557: --
558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
563: fnd_message.raise_error;
564: --

Line 561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');

557: --
558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
563: fnd_message.raise_error;
564: --
565: end if;

Line 562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');

558: -- raise error as does not exist as lookup
559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
563: fnd_message.raise_error;
564: --
565: end if;
566: --

Line 563: fnd_message.raise_error;

559: --
560: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
561: fnd_message.set_token('FIELD','p_data_elmt_typ_cd');
562: fnd_message.set_token('TYPE','BEN_EXT_DATA_ELMT_TYP');
563: fnd_message.raise_error;
564: --
565: end if;
566: --
567: end if;

Line 573: fnd_message.set_name('BEN','BEN_91867_STR_VAL_NULL');

569: -- Need to report fix number of space if the data not avaialble
570: -- this may be need for ANSI
571: if p_data_elmt_typ_cd = 'S' then
572: if p_string_val is null and p_max_length_num is null then
573: fnd_message.set_name('BEN','BEN_91867_STR_VAL_NULL');
574: fnd_message.raise_error;
575: end if;
576: end if;
577:

Line 574: fnd_message.raise_error;

570: -- this may be need for ANSI
571: if p_data_elmt_typ_cd = 'S' then
572: if p_string_val is null and p_max_length_num is null then
573: fnd_message.set_name('BEN','BEN_91867_STR_VAL_NULL');
574: fnd_message.raise_error;
575: end if;
576: end if;
577:
578: if p_data_elmt_typ_cd = 'R' then

Line 580: fnd_message.set_name('BEN','BEN_91868_RL_VAL_NULL');

576: end if;
577:
578: if p_data_elmt_typ_cd = 'R' then
579: if p_data_elmt_rl is null then
580: fnd_message.set_name('BEN','BEN_91868_RL_VAL_NULL');
581: fnd_message.raise_error;
582: end if;
583: end if;
584:

Line 581: fnd_message.raise_error;

577:
578: if p_data_elmt_typ_cd = 'R' then
579: if p_data_elmt_rl is null then
580: fnd_message.set_name('BEN','BEN_91868_RL_VAL_NULL');
581: fnd_message.raise_error;
582: end if;
583: end if;
584:
585: if p_data_elmt_typ_cd = 'T' then

Line 587: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');

583: end if;
584:
585: if p_data_elmt_typ_cd = 'T' then
586: if p_ttl_fnctn_cd is null then
587: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
588: fnd_message.raise_error;
589: end if;
590: end if;
591: if p_data_elmt_typ_cd = 'C' then

Line 588: fnd_message.raise_error;

584:
585: if p_data_elmt_typ_cd = 'T' then
586: if p_ttl_fnctn_cd is null then
587: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
588: fnd_message.raise_error;
589: end if;
590: end if;
591: if p_data_elmt_typ_cd = 'C' then
592: if p_ttl_fnctn_cd is null then

Line 593: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');

589: end if;
590: end if;
591: if p_data_elmt_typ_cd = 'C' then
592: if p_ttl_fnctn_cd is null then
593: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
594: fnd_message.raise_error;
595: end if;
596: end if;
597:

Line 594: fnd_message.raise_error;

590: end if;
591: if p_data_elmt_typ_cd = 'C' then
592: if p_ttl_fnctn_cd is null then
593: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
594: fnd_message.raise_error;
595: end if;
596: end if;
597:
598: if p_data_elmt_typ_cd = 'P' then

Line 600: fnd_message.set_name('BEN','BEN_94248_DEFINE_BAL_NULL');

596: end if;
597:
598: if p_data_elmt_typ_cd = 'P' then
599: if p_defined_balance_id is null then
600: fnd_message.set_name('BEN','BEN_94248_DEFINE_BAL_NULL');
601: fnd_message.raise_error;
602: end if;
603: end if;
604:

Line 601: fnd_message.raise_error;

597:
598: if p_data_elmt_typ_cd = 'P' then
599: if p_defined_balance_id is null then
600: fnd_message.set_name('BEN','BEN_94248_DEFINE_BAL_NULL');
601: fnd_message.raise_error;
602: end if;
603: end if;
604:
605:

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

667: p_effective_date => p_effective_date) then
668: --
669: -- raise error as does not exist as lookup
670: --
671: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
672: fnd_message.set_token('FIELD','p_just_cd');
673: fnd_message.set_token('TYPE','BEN_EXT_JUST');
674: fnd_message.raise_error;
675: --

Line 672: fnd_message.set_token('FIELD','p_just_cd');

668: --
669: -- raise error as does not exist as lookup
670: --
671: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
672: fnd_message.set_token('FIELD','p_just_cd');
673: fnd_message.set_token('TYPE','BEN_EXT_JUST');
674: fnd_message.raise_error;
675: --
676: end if;

Line 673: fnd_message.set_token('TYPE','BEN_EXT_JUST');

669: -- raise error as does not exist as lookup
670: --
671: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
672: fnd_message.set_token('FIELD','p_just_cd');
673: fnd_message.set_token('TYPE','BEN_EXT_JUST');
674: fnd_message.raise_error;
675: --
676: end if;
677: --

Line 674: fnd_message.raise_error;

670: --
671: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
672: fnd_message.set_token('FIELD','p_just_cd');
673: fnd_message.set_token('TYPE','BEN_EXT_JUST');
674: fnd_message.raise_error;
675: --
676: end if;
677: --
678: else

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_just_cd');
688: fnd_message.set_token('TYPE','BEN_EXT_JUST');
689: fnd_message.raise_error;
690: --

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

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_just_cd');
688: fnd_message.set_token('TYPE','BEN_EXT_JUST');
689: fnd_message.raise_error;
690: --
691: end if;

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

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_just_cd');
688: fnd_message.set_token('TYPE','BEN_EXT_JUST');
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_just_cd');
688: fnd_message.set_token('TYPE','BEN_EXT_JUST');
689: fnd_message.raise_error;
690: --
691: end if;
692: --
693: end if;

Line 764: fnd_message.set_name('BEN','BEN_94249_DEFINE_BAL_NOTFOUND');

760: open c ;
761: fetch c into l_dummy ;
762: if c%notfound then
763: close c ;
764: fnd_message.set_name('BEN','BEN_94249_DEFINE_BAL_NOTFOUND');
765: fnd_message.raise_error;
766:
767: end if ;
768: close c ;

Line 765: fnd_message.raise_error;

761: fetch c into l_dummy ;
762: if c%notfound then
763: close c ;
764: fnd_message.set_name('BEN','BEN_94249_DEFINE_BAL_NOTFOUND');
765: fnd_message.raise_error;
766:
767: end if ;
768: close c ;
769: --

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

862: open c1;
863: fetch c1 into l_dummy;
864: if c1%found then
865: close c1;
866: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
867: fnd_message.raise_error;
868: end if;
869:
870: --

Line 867: fnd_message.raise_error;

863: fetch c1 into l_dummy;
864: if c1%found then
865: close c1;
866: fnd_message.set_name('BEN','BEN_91009_NAME_NOT_UNIQUE');
867: fnd_message.raise_error;
868: end if;
869:
870: --
871: hr_utility.set_location('Leaving:'||l_proc, 15);

Line 931: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');

927: or not l_api_updating) then
928: --
929: if p_ttl_fnctn_cd = 'CNT' then
930: if p_ttl_sum_ext_data_elmt_id is not null then
931: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
932: fnd_message.raise_error;
933: end if;
934: elsif p_ttl_fnctn_cd = 'SUM' then
935: if p_ttl_sum_ext_data_elmt_id is null then

Line 932: fnd_message.raise_error;

928: --
929: if p_ttl_fnctn_cd = 'CNT' then
930: if p_ttl_sum_ext_data_elmt_id is not null then
931: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
932: fnd_message.raise_error;
933: end if;
934: elsif p_ttl_fnctn_cd = 'SUM' then
935: if p_ttl_sum_ext_data_elmt_id is null then
936: fnd_message.set_name('BEN','BEN_92418_CHK_FNCTN_CD2');

Line 936: fnd_message.set_name('BEN','BEN_92418_CHK_FNCTN_CD2');

932: fnd_message.raise_error;
933: end if;
934: elsif p_ttl_fnctn_cd = 'SUM' then
935: if p_ttl_sum_ext_data_elmt_id is null then
936: fnd_message.set_name('BEN','BEN_92418_CHK_FNCTN_CD2');
937: fnd_message.raise_error;
938: end if;
939: if p_ttl_cond_ext_data_elmt_id is null then
940: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');

Line 937: fnd_message.raise_error;

933: end if;
934: elsif p_ttl_fnctn_cd = 'SUM' then
935: if p_ttl_sum_ext_data_elmt_id is null then
936: fnd_message.set_name('BEN','BEN_92418_CHK_FNCTN_CD2');
937: fnd_message.raise_error;
938: end if;
939: if p_ttl_cond_ext_data_elmt_id is null then
940: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');
941: -- if function is 'Sum' then a record must be specified.

Line 940: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');

936: fnd_message.set_name('BEN','BEN_92418_CHK_FNCTN_CD2');
937: fnd_message.raise_error;
938: end if;
939: if p_ttl_cond_ext_data_elmt_id is null then
940: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');
941: -- if function is 'Sum' then a record must be specified.
942: fnd_message.raise_error;
943: end if;
944:

Line 942: fnd_message.raise_error;

938: end if;
939: if p_ttl_cond_ext_data_elmt_id is null then
940: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');
941: -- if function is 'Sum' then a record must be specified.
942: fnd_message.raise_error;
943: end if;
944:
945: elsif p_ttl_fnctn_cd in ( 'ADD','SUB','MLT','DIV' ) then
946: if p_ttl_cond_ext_data_elmt_id is nulL then

Line 947: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');

943: end if;
944:
945: elsif p_ttl_fnctn_cd in ( 'ADD','SUB','MLT','DIV' ) then
946: if p_ttl_cond_ext_data_elmt_id is nulL then
947: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');
948: -- if function is 'Sum' then a record must be specified.
949: fnd_message.raise_error;
950: end if;
951:

Line 949: fnd_message.raise_error;

945: elsif p_ttl_fnctn_cd in ( 'ADD','SUB','MLT','DIV' ) then
946: if p_ttl_cond_ext_data_elmt_id is nulL then
947: fnd_message.set_name('BEN','BEN_92419_CHK_FNCTN_CD3');
948: -- if function is 'Sum' then a record must be specified.
949: fnd_message.raise_error;
950: end if;
951:
952: elsif p_ttl_fnctn_cd is null then
953: if p_ttl_sum_ext_data_elmt_id is not null then

Line 954: fnd_message.set_name('BEN','BEN_92200_CHK_COND_DATA_ELMT');

950: end if;
951:
952: elsif p_ttl_fnctn_cd is null then
953: if p_ttl_sum_ext_data_elmt_id is not null then
954: fnd_message.set_name('BEN','BEN_92200_CHK_COND_DATA_ELMT');
955: fnd_message.raise_error;
956: elsif p_ttl_cond_ext_data_elmt_id is not null then
957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
958: fnd_message.raise_error;

Line 955: fnd_message.raise_error;

951:
952: elsif p_ttl_fnctn_cd is null then
953: if p_ttl_sum_ext_data_elmt_id is not null then
954: fnd_message.set_name('BEN','BEN_92200_CHK_COND_DATA_ELMT');
955: fnd_message.raise_error;
956: elsif p_ttl_cond_ext_data_elmt_id is not null then
957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
958: fnd_message.raise_error;
959: /* these fields no longer used

Line 957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');

953: if p_ttl_sum_ext_data_elmt_id is not null then
954: fnd_message.set_name('BEN','BEN_92200_CHK_COND_DATA_ELMT');
955: fnd_message.raise_error;
956: elsif p_ttl_cond_ext_data_elmt_id is not null then
957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
958: fnd_message.raise_error;
959: /* these fields no longer used
960: elsif p_ttl_cond_operation_cd is not null then
961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');

Line 958: fnd_message.raise_error;

954: fnd_message.set_name('BEN','BEN_92200_CHK_COND_DATA_ELMT');
955: fnd_message.raise_error;
956: elsif p_ttl_cond_ext_data_elmt_id is not null then
957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
958: fnd_message.raise_error;
959: /* these fields no longer used
960: elsif p_ttl_cond_operation_cd is not null then
961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');
962: fnd_message.raise_error;

Line 961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');

957: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
958: fnd_message.raise_error;
959: /* these fields no longer used
960: elsif p_ttl_cond_operation_cd is not null then
961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');
962: fnd_message.raise_error;
963: elsif p_ttl_cond_val is not null then
964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */

Line 962: fnd_message.raise_error;

958: fnd_message.raise_error;
959: /* these fields no longer used
960: elsif p_ttl_cond_operation_cd is not null then
961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');
962: fnd_message.raise_error;
963: elsif p_ttl_cond_val is not null then
964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */
966: elsif p_data_elmt_typ_cd = 'T' then

Line 964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');

960: elsif p_ttl_cond_operation_cd is not null then
961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');
962: fnd_message.raise_error;
963: elsif p_ttl_cond_val is not null then
964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */
966: elsif p_data_elmt_typ_cd = 'T' then
967: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
968: fnd_message.raise_error;

Line 965: fnd_message.raise_error; */

961: fnd_message.set_name('BEN','BEN_92202_CHK_COND_DATA_ELMT');
962: fnd_message.raise_error;
963: elsif p_ttl_cond_val is not null then
964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */
966: elsif p_data_elmt_typ_cd = 'T' then
967: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
968: fnd_message.raise_error;
969: end if;

Line 967: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');

963: elsif p_ttl_cond_val is not null then
964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */
966: elsif p_data_elmt_typ_cd = 'T' then
967: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
968: fnd_message.raise_error;
969: end if;
970: end if;
971: end if;

Line 968: fnd_message.raise_error;

964: fnd_message.set_name('BEN','BEN_92203_CHK_COND_DATA_ELMT');
965: fnd_message.raise_error; */
966: elsif p_data_elmt_typ_cd = 'T' then
967: fnd_message.set_name('BEN','BEN_92138_FNCTN_CD_NULL');
968: fnd_message.raise_error;
969: end if;
970: end if;
971: end if;
972: --

Line 978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');

974: and nvl(p_ttl_sum_ext_data_elmt_id,hr_api.g_number)
975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)
976: or not l_api_updating) then
977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;
980: elsif p_ttl_sum_ext_data_elmt_id is null and p_ttl_fnctn_cd = 'SUM' then
981: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
982: fnd_message.raise_error;

Line 979: fnd_message.raise_error;

975: <> nvl(ben_xel_shd.g_old_rec.ttl_sum_ext_data_elmt_id,hr_api.g_number)
976: or not l_api_updating) then
977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;
980: elsif p_ttl_sum_ext_data_elmt_id is null and p_ttl_fnctn_cd = 'SUM' then
981: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
982: fnd_message.raise_error;
983: end if;

Line 981: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');

977: if p_ttl_sum_ext_data_elmt_id is not null and p_ttl_fnctn_cd <> 'SUM' then
978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;
980: elsif p_ttl_sum_ext_data_elmt_id is null and p_ttl_fnctn_cd = 'SUM' then
981: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
982: fnd_message.raise_error;
983: end if;
984:
985: end if;

Line 982: fnd_message.raise_error;

978: fnd_message.set_name('BEN','BEN_92200_CHK_SUM_DATA_ELMT');
979: fnd_message.raise_error;
980: elsif p_ttl_sum_ext_data_elmt_id is null and p_ttl_fnctn_cd = 'SUM' then
981: fnd_message.set_name('BEN','BEN_92199_CHK_FNCTN_CD');
982: fnd_message.raise_error;
983: end if;
984:
985: end if;
986: hr_utility.set_location('p_ttl_fnctn_cd:'||p_ttl_fnctn_cd, 15);

Line 995: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');

991: or not l_api_updating) then
992: --
993: if p_ttl_cond_ext_data_elmt_id is not null then
994: if p_ttl_fnctn_cd is null then
995: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
996: fnd_message.raise_error;
997: end if;
998: end if;
999: end if;

Line 996: fnd_message.raise_error;

992: --
993: if p_ttl_cond_ext_data_elmt_id is not null then
994: if p_ttl_fnctn_cd is null then
995: fnd_message.set_name('BEN','BEN_92201_CHK_COND_DATA_ELMT');
996: fnd_message.raise_error;
997: end if;
998: end if;
999: end if;
1000: --

Line 1354: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');

1350: close csr_leg_code;
1351: --
1352: -- The primary key is invalid therefore we must error
1353: --
1354: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1355: fnd_message.raise_error;
1356: --
1357: end if;
1358: --

Line 1355: fnd_message.raise_error;

1351: --
1352: -- The primary key is invalid therefore we must error
1353: --
1354: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1355: fnd_message.raise_error;
1356: --
1357: end if;
1358: --
1359: close csr_leg_code;