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;
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: --
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: --
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;
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: --
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
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: --
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;
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: --
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;
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
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');
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;
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: --
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: -- ----------------------------------------------------------------------------
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 >------|
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: --
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;
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: --
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;
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: --
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;
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
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
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;
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);
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: --
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;
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: --
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
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: --
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;
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: --
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;
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:
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
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:
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
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
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
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:
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
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:
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:
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: --
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;
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: --
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
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: --
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;
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: --
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;
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 ;
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: --
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: --
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);
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
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');
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');
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.
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:
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
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:
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
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;
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
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');
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;
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; */
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
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;
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;
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;
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: --
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;
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;
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;
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);
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;
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: --
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: --
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;