DBA Data[Home] [Help]

APPS.BEN_XER_BUS dependencies on FND_MESSAGE

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

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;

Line 55: fnd_message.raise_error;

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

Line 340: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');

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

Line 341: fnd_message.raise_error;

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

Line 405: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');

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

Line 406: fnd_message.raise_error;

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;

Line 442: fnd_message.set_name('BEN','BEN_91864_INVLD_STRT_POS');

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

Line 443: fnd_message.raise_error;

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

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

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

Line 513: fnd_message.set_token('FIELD','p_sprs_cd');

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;

Line 514: fnd_message.set_token('TYPE','BEN_EXT_SPRS');

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

Line 515: fnd_message.raise_error;

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

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

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

Line 528: fnd_message.set_token('FIELD','p_sprs_cd');

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;

Line 529: fnd_message.set_token('TYPE','BEN_EXT_SPRS');

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

Line 530: fnd_message.raise_error;

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;

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

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

Line 604: fnd_message.set_token('FIELD','p_rqd_flag');

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;

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

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

Line 606: fnd_message.raise_error;

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

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

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

Line 619: fnd_message.set_token('FIELD','p_rqd_flag');

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;

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

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

Line 621: fnd_message.raise_error;

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;

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

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

Line 693: fnd_message.set_token('FIELD','p_any_or_all_cd');

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;

Line 694: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');

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

Line 695: fnd_message.raise_error;

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

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

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

Line 707: fnd_message.set_token('FIELD','p_any_or_all_cd');

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;

Line 708: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');

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

Line 709: fnd_message.raise_error;

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;

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

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

Line 781: fnd_message.set_token('FIELD','p_hide_flag');

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;

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

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

Line 783: fnd_message.raise_error;

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

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

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

Line 795: fnd_message.set_token('FIELD','p_hide_flag');

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;

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

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

Line 797: fnd_message.raise_error;

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;

Line 841: fnd_message.set_name('BEN','BEN_92116_DATA_ELMT_NULL');

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

Line 842: fnd_message.raise_error;

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

Line 918: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

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

Line 919: fnd_message.raise_error;

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

Line 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

Line 924: 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
928: if typ_cd <> 'D' then

Line 929: fnd_message.set_name('BEN','BEN_92198_CHK_RCD_TYP');

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

Line 930: fnd_message.raise_error;

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

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

Line 935: 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:
939: close c2;

Line 1066: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');

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:

Line 1067: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');

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:

Line 1068: fnd_message.raise_error;

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:

Line 1078: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');

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;

Line 1079: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');

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:

Line 1080: fnd_message.raise_error;

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:

Line 1089: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');

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 ;

Line 1090: fnd_message.set_token('TABLE_NAME','ben_ext_file.grouping');

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 ;

Line 1091: fnd_message.raise_error;

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:

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

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

Line 1349: fnd_message.raise_error;

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;