50: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
51: --
52: -- The primary key is invalid therefore we must error
53: --
54: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
55: fnd_message.raise_error;
56: --
57: end if;
58: close csr_sec_grp;
59: --
336: --
337: --
338: if p_seq_num is null or p_seq_num < 1 or p_seq_num > 300
339: then
340: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
337: --
338: if p_seq_num is null or p_seq_num < 1 or p_seq_num > 300
339: then
340: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
341: fnd_message.raise_error;
342: end if;
343: --
344: hr_utility.set_location('Leaving:'||l_proc,10);
345: --
401: open c1;
402: fetch c1 into l_dummy;
403: if c1%found then
404: close c1;
405: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
406: fnd_message.raise_error;
407: end if;
408: hr_utility.set_location('Leaving:'||l_proc,10);
409: --
402: fetch c1 into l_dummy;
403: if c1%found then
404: close c1;
405: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
406: fnd_message.raise_error;
407: end if;
408: hr_utility.set_location('Leaving:'||l_proc,10);
409: --
410: end chk_seq_num_unq;
438: hr_utility.set_location('Entering:'||l_proc, 5);
439: --
440: --
441: if p_strt_pos =0 or p_strt_pos <0 then
442: fnd_message.set_name('BEN','BEN_91864_INVLD_STRT_POS');
443: fnd_message.raise_error;
444: end if;
445: --
446: hr_utility.set_location('Leaving:'||l_proc,10);
439: --
440: --
441: if p_strt_pos =0 or p_strt_pos <0 then
442: fnd_message.set_name('BEN','BEN_91864_INVLD_STRT_POS');
443: fnd_message.raise_error;
444: end if;
445: --
446: hr_utility.set_location('Leaving:'||l_proc,10);
447: --
508: --
509: -- raise error as does not exist as lookup
510: --
511: --
512: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
513: fnd_message.set_token('FIELD','p_sprs_cd');
514: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
515: fnd_message.raise_error;
516: --
509: -- raise error as does not exist as lookup
510: --
511: --
512: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
513: fnd_message.set_token('FIELD','p_sprs_cd');
514: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
515: fnd_message.raise_error;
516: --
517: end if;
510: --
511: --
512: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
513: fnd_message.set_token('FIELD','p_sprs_cd');
514: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
515: fnd_message.raise_error;
516: --
517: end if;
518: else
511: --
512: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
513: fnd_message.set_token('FIELD','p_sprs_cd');
514: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
515: fnd_message.raise_error;
516: --
517: end if;
518: else
519: if hr_api.not_exists_in_hrstanlookups
523: --
524: -- raise error as does not exist as lookup
525: --
526: --
527: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
528: fnd_message.set_token('FIELD','p_sprs_cd');
529: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
530: fnd_message.raise_error;
531: --
524: -- raise error as does not exist as lookup
525: --
526: --
527: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
528: fnd_message.set_token('FIELD','p_sprs_cd');
529: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
530: fnd_message.raise_error;
531: --
532: end if;
525: --
526: --
527: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
528: fnd_message.set_token('FIELD','p_sprs_cd');
529: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
530: fnd_message.raise_error;
531: --
532: end if;
533: --
526: --
527: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
528: fnd_message.set_token('FIELD','p_sprs_cd');
529: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
530: fnd_message.raise_error;
531: --
532: end if;
533: --
534: end if;
599: --
600: -- raise error as does not exist as lookup
601: --
602: --
603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
604: fnd_message.set_token('FIELD','p_rqd_flag');
605: fnd_message.set_token('TYPE','YES_NO');
606: fnd_message.raise_error;
607: --
600: -- raise error as does not exist as lookup
601: --
602: --
603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
604: fnd_message.set_token('FIELD','p_rqd_flag');
605: fnd_message.set_token('TYPE','YES_NO');
606: fnd_message.raise_error;
607: --
608: end if;
601: --
602: --
603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
604: fnd_message.set_token('FIELD','p_rqd_flag');
605: fnd_message.set_token('TYPE','YES_NO');
606: fnd_message.raise_error;
607: --
608: end if;
609: else
602: --
603: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
604: fnd_message.set_token('FIELD','p_rqd_flag');
605: fnd_message.set_token('TYPE','YES_NO');
606: fnd_message.raise_error;
607: --
608: end if;
609: else
610: if hr_api.not_exists_in_hrstanlookups
614: --
615: -- raise error as does not exist as lookup
616: --
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_rqd_flag');
620: fnd_message.set_token('TYPE','YES_NO');
621: fnd_message.raise_error;
622: --
615: -- raise error as does not exist as lookup
616: --
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_rqd_flag');
620: fnd_message.set_token('TYPE','YES_NO');
621: fnd_message.raise_error;
622: --
623: end if;
616: --
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_rqd_flag');
620: fnd_message.set_token('TYPE','YES_NO');
621: fnd_message.raise_error;
622: --
623: end if;
624: --
617: --
618: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
619: fnd_message.set_token('FIELD','p_rqd_flag');
620: fnd_message.set_token('TYPE','YES_NO');
621: fnd_message.raise_error;
622: --
623: end if;
624: --
625: end if;
688: p_effective_date => p_effective_date) then
689: --
690: -- raise error as does not exist as lookup
691: --
692: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
693: fnd_message.set_token('FIELD','p_any_or_all_cd');
694: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
695: fnd_message.raise_error;
696: --
689: --
690: -- raise error as does not exist as lookup
691: --
692: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
693: fnd_message.set_token('FIELD','p_any_or_all_cd');
694: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
695: fnd_message.raise_error;
696: --
697: end if;
690: -- raise error as does not exist as lookup
691: --
692: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
693: fnd_message.set_token('FIELD','p_any_or_all_cd');
694: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
695: fnd_message.raise_error;
696: --
697: end if;
698: else
691: --
692: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
693: fnd_message.set_token('FIELD','p_any_or_all_cd');
694: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
695: fnd_message.raise_error;
696: --
697: end if;
698: else
699: if hr_api.not_exists_in_hrstanlookups
702: p_effective_date => p_effective_date) then
703: --
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_any_or_all_cd');
708: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
709: fnd_message.raise_error;
710: --
703: --
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_any_or_all_cd');
708: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
709: fnd_message.raise_error;
710: --
711: end if;
704: -- raise error as does not exist as lookup
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_any_or_all_cd');
708: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
705: --
706: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
707: fnd_message.set_token('FIELD','p_any_or_all_cd');
708: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
709: fnd_message.raise_error;
710: --
711: end if;
712: --
713: end if;
776: p_effective_date => p_effective_date) then
777: --
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_hide_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
777: --
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_hide_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
778: -- raise error as does not exist as lookup
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_hide_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
786: else
779: --
780: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
781: fnd_message.set_token('FIELD','p_hide_flag');
782: fnd_message.set_token('TYPE','YES_NO');
783: fnd_message.raise_error;
784: --
785: end if;
786: else
787: if hr_api.not_exists_in_hrstanlookups
790: p_effective_date => p_effective_date) then
791: --
792: -- raise error as does not exist as lookup
793: --
794: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
795: fnd_message.set_token('FIELD','p_hide_flag');
796: fnd_message.set_token('TYPE','YES_NO');
797: fnd_message.raise_error;
798: --
791: --
792: -- raise error as does not exist as lookup
793: --
794: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
795: fnd_message.set_token('FIELD','p_hide_flag');
796: fnd_message.set_token('TYPE','YES_NO');
797: fnd_message.raise_error;
798: --
799: end if;
792: -- raise error as does not exist as lookup
793: --
794: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
795: fnd_message.set_token('FIELD','p_hide_flag');
796: fnd_message.set_token('TYPE','YES_NO');
797: fnd_message.raise_error;
798: --
799: end if;
800: --
793: --
794: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
795: fnd_message.set_token('FIELD','p_hide_flag');
796: fnd_message.set_token('TYPE','YES_NO');
797: fnd_message.raise_error;
798: --
799: end if;
800: --
801: end if;
837: --
838: --
839: if p_ext_data_elmt_id is null
840: then
841: fnd_message.set_name('BEN','BEN_92116_DATA_ELMT_NULL');
842: fnd_message.raise_error;
843: end if;
844: --
845: hr_utility.set_location('Leaving:'||l_proc,10);
838: --
839: if p_ext_data_elmt_id is null
840: then
841: fnd_message.set_name('BEN','BEN_92116_DATA_ELMT_NULL');
842: fnd_message.raise_error;
843: end if;
844: --
845: hr_utility.set_location('Leaving:'||l_proc,10);
846: --
914: fetch c2 into data_typ_cd, alwd_cd;
915: if data_typ_cd in ('D','F') then
916: if alwd_cd in ('D','H','T') then
917: if not ( alwd_cd = typ_cd or typ_cd in ('S','L') ) then
918: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
919: fnd_message.raise_error;
920: end if;
921: elsif alwd_cd = 'B' then
922: if typ_cd not in ('H','T' ,'L') then
915: if data_typ_cd in ('D','F') then
916: if alwd_cd in ('D','H','T') then
917: if not ( alwd_cd = typ_cd or typ_cd in ('S','L') ) then
918: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
919: fnd_message.raise_error;
920: end if;
921: elsif alwd_cd = 'B' then
922: if typ_cd not in ('H','T' ,'L') then
923: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
919: fnd_message.raise_error;
920: end if;
921: elsif alwd_cd = 'B' then
922: if typ_cd not in ('H','T' ,'L') then
923: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
924: fnd_message.raise_error;
925: end if;
926: end if;
927: elsif data_typ_cd = 'R' then
920: end if;
921: elsif alwd_cd = 'B' then
922: if typ_cd not in ('H','T' ,'L') then
923: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
924: fnd_message.raise_error;
925: end if;
926: end if;
927: elsif data_typ_cd = 'R' then
928: if typ_cd <> 'D' then
925: end if;
926: end if;
927: elsif data_typ_cd = 'R' then
928: if typ_cd <> 'D' then
929: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
930: fnd_message.raise_error;
931: end if;
932: elsif data_typ_cd = 'T' then
933: if typ_cd not in ('H','T','L') then
926: end if;
927: elsif data_typ_cd = 'R' then
928: if typ_cd <> 'D' then
929: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
930: fnd_message.raise_error;
931: end if;
932: elsif data_typ_cd = 'T' then
933: if typ_cd not in ('H','T','L') then
934: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
930: fnd_message.raise_error;
931: end if;
932: elsif data_typ_cd = 'T' then
933: if typ_cd not in ('H','T','L') then
934: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
935: fnd_message.raise_error;
936: end if;
937: end if;
938:
931: end if;
932: elsif data_typ_cd = 'T' then
933: if typ_cd not in ('H','T','L') then
934: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');
935: fnd_message.raise_error;
936: end if;
937: end if;
938:
939: close c2;
1062: fetch c_ext_where_clause into l_ext_where_clause_id;
1063: close c_ext_where_clause;
1064:
1065: if l_ext_where_clause_id is not null then
1066: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1067: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1068: fnd_message.raise_error;
1069: end if;
1070:
1063: close c_ext_where_clause;
1064:
1065: if l_ext_where_clause_id is not null then
1066: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1067: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1068: fnd_message.raise_error;
1069: end if;
1070:
1071:
1064:
1065: if l_ext_where_clause_id is not null then
1066: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1067: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1068: fnd_message.raise_error;
1069: end if;
1070:
1071:
1072:
1074: fetch c_ext_incl_chg_id into l_ext_incl_chg_id;
1075: close c_ext_incl_chg_id;
1076:
1077: if l_ext_incl_chg_id is not null then
1078: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1079: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1080: fnd_message.raise_error;
1081:
1082: end if;
1075: close c_ext_incl_chg_id;
1076:
1077: if l_ext_incl_chg_id is not null then
1078: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1079: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1080: fnd_message.raise_error;
1081:
1082: end if;
1083:
1076:
1077: if l_ext_incl_chg_id is not null then
1078: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1079: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1080: fnd_message.raise_error;
1081:
1082: end if;
1083:
1084:
1085: open c_ext_file_group ;
1086: fetch c_ext_file_group into l_dummy ;
1087: if c_ext_file_group%found then
1088: close c_ext_file_group ;
1089: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1090: fnd_message.set_token('TABLE_NAME','ben_ext_file.grouping');
1091: fnd_message.raise_error;
1092:
1093: end if ;
1086: fetch c_ext_file_group into l_dummy ;
1087: if c_ext_file_group%found then
1088: close c_ext_file_group ;
1089: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1090: fnd_message.set_token('TABLE_NAME','ben_ext_file.grouping');
1091: fnd_message.raise_error;
1092:
1093: end if ;
1094: close c_ext_file_group ;
1087: if c_ext_file_group%found then
1088: close c_ext_file_group ;
1089: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1090: fnd_message.set_token('TABLE_NAME','ben_ext_file.grouping');
1091: fnd_message.raise_error;
1092:
1093: end if ;
1094: close c_ext_file_group ;
1095:
1344: close csr_leg_code;
1345: --
1346: -- The primary key is invalid therefore we must error
1347: --
1348: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1349: fnd_message.raise_error;
1350: --
1351: end if;
1352: --
1345: --
1346: -- The primary key is invalid therefore we must error
1347: --
1348: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1349: fnd_message.raise_error;
1350: --
1351: end if;
1352: --
1353: close csr_leg_code;