eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_XRF_BUS dependencies on FND_MESSAGE

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

98: close csr_sec_grp;
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;

Line 103: fnd_message.raise_error;

99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: --
105: end if;
106: close csr_sec_grp;
107: --

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

392: p_effective_date => p_effective_date) then
393: --
394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD','p_sprs_cd');
398: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
399: fnd_message.raise_error;
400: --

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

393: --
394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD','p_sprs_cd');
398: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
399: fnd_message.raise_error;
400: --
401: end if;

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

394: -- raise error as does not exist as lookup
395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD','p_sprs_cd');
398: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
399: fnd_message.raise_error;
400: --
401: end if;
402: else

Line 399: fnd_message.raise_error;

395: --
396: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
397: fnd_message.set_token('FIELD','p_sprs_cd');
398: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
399: fnd_message.raise_error;
400: --
401: end if;
402: else
403: /* BG is null, so alternative call is required */

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

407: p_effective_date => p_effective_date) then
408: --
409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_sprs_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
414: fnd_message.raise_error;
415: --

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

408: --
409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_sprs_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
414: fnd_message.raise_error;
415: --
416: end if;

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

409: -- raise error as does not exist as lookup
410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_sprs_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
414: fnd_message.raise_error;
415: --
416: end if;
417: end if;

Line 414: fnd_message.raise_error;

410: --
411: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
412: fnd_message.set_token('FIELD','p_sprs_cd');
413: fnd_message.set_token('TYPE','BEN_EXT_SPRS');
414: fnd_message.raise_error;
415: --
416: end if;
417: end if;
418: --

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

484: p_effective_date => p_effective_date) then
485: --
486: -- raise error as does not exist as lookup
487: --
488: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
489: fnd_message.set_token('FIELD','p_any_or_all_cd');
490: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
491: fnd_message.raise_error;
492: --

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

485: --
486: -- raise error as does not exist as lookup
487: --
488: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
489: fnd_message.set_token('FIELD','p_any_or_all_cd');
490: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
491: fnd_message.raise_error;
492: --
493: end if;

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

486: -- raise error as does not exist as lookup
487: --
488: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
489: fnd_message.set_token('FIELD','p_any_or_all_cd');
490: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
491: fnd_message.raise_error;
492: --
493: end if;
494: else

Line 491: fnd_message.raise_error;

487: --
488: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
489: fnd_message.set_token('FIELD','p_any_or_all_cd');
490: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
491: fnd_message.raise_error;
492: --
493: end if;
494: else
495: /* BG is null, so alternative call is required */

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

499: p_effective_date => p_effective_date) then
500: --
501: -- raise error as does not exist as lookup
502: --
503: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
504: fnd_message.set_token('FIELD','p_any_or_all_cd');
505: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
506: fnd_message.raise_error;
507: --

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

500: --
501: -- raise error as does not exist as lookup
502: --
503: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
504: fnd_message.set_token('FIELD','p_any_or_all_cd');
505: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
506: fnd_message.raise_error;
507: --
508: end if;

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

501: -- raise error as does not exist as lookup
502: --
503: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
504: fnd_message.set_token('FIELD','p_any_or_all_cd');
505: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
506: fnd_message.raise_error;
507: --
508: end if;
509: end if;

Line 506: fnd_message.raise_error;

502: --
503: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
504: fnd_message.set_token('FIELD','p_any_or_all_cd');
505: fnd_message.set_token('TYPE','BEN_EXT_ANY_OR_ALL');
506: fnd_message.raise_error;
507: --
508: end if;
509: end if;
510: --

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

573: --
574: -- raise error as does not exist as lookup
575: --
576: --
577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
578: fnd_message.set_token('FIELD','p_rqd_flag');
579: fnd_message.set_token('TYPE','YES_NO');
580: fnd_message.raise_error;
581: --

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

574: -- raise error as does not exist as lookup
575: --
576: --
577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
578: fnd_message.set_token('FIELD','p_rqd_flag');
579: fnd_message.set_token('TYPE','YES_NO');
580: fnd_message.raise_error;
581: --
582: end if;

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

575: --
576: --
577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
578: fnd_message.set_token('FIELD','p_rqd_flag');
579: fnd_message.set_token('TYPE','YES_NO');
580: fnd_message.raise_error;
581: --
582: end if;
583: else

Line 580: fnd_message.raise_error;

576: --
577: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
578: fnd_message.set_token('FIELD','p_rqd_flag');
579: fnd_message.set_token('TYPE','YES_NO');
580: fnd_message.raise_error;
581: --
582: end if;
583: else
584: /* BG is null, so alternative call is required */

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

589: --
590: -- raise error as does not exist as lookup
591: --
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('FIELD','p_rqd_flag');
595: fnd_message.set_token('TYPE','YES_NO');
596: fnd_message.raise_error;
597: --

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

590: -- raise error as does not exist as lookup
591: --
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('FIELD','p_rqd_flag');
595: fnd_message.set_token('TYPE','YES_NO');
596: fnd_message.raise_error;
597: --
598: end if;

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

591: --
592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('FIELD','p_rqd_flag');
595: fnd_message.set_token('TYPE','YES_NO');
596: fnd_message.raise_error;
597: --
598: end if;
599: end if;

Line 596: fnd_message.raise_error;

592: --
593: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
594: fnd_message.set_token('FIELD','p_rqd_flag');
595: fnd_message.set_token('TYPE','YES_NO');
596: fnd_message.raise_error;
597: --
598: end if;
599: end if;
600: --

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

666: --
667: -- raise error as does not exist as lookup
668: --
669: --
670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
671: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');
672: fnd_message.set_token('TYPE','YES_NO');
673: fnd_message.raise_error;
674: --

Line 671: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');

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

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

668: --
669: --
670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
671: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');
672: fnd_message.set_token('TYPE','YES_NO');
673: fnd_message.raise_error;
674: --
675: end if;
676: else

Line 673: fnd_message.raise_error;

669: --
670: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
671: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');
672: fnd_message.set_token('TYPE','YES_NO');
673: fnd_message.raise_error;
674: --
675: end if;
676: else
677: /* BG is null, so alternative call is required */

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

682: --
683: -- raise error as does not exist as lookup
684: --
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --

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

683: -- raise error as does not exist as lookup
684: --
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_chg_rcd_upd_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: --
685: --
686: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
687: fnd_message.set_token('FIELD','p_chg_rcd_upd_flag');
688: fnd_message.set_token('TYPE','YES_NO');
689: fnd_message.raise_error;
690: --
691: end if;
692: end if;

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

Line 697: fnd_message.set_name('BEN','BEN_94267_EXT_DUPS_MERGE_EXCLS');

693: --
694: end if;
695: --- prevent duplicate ane merge changes are mutually exclusive
696: if p_chg_rcd_upd_flag = 'Y' and p_any_or_all_cd = 'Y' then
697: fnd_message.set_name('BEN','BEN_94267_EXT_DUPS_MERGE_EXCLS');
698: fnd_message.raise_error;
699: end if ;
700: --
701: hr_utility.set_location('Leaving:'||l_proc,10);

Line 698: fnd_message.raise_error;

694: end if;
695: --- prevent duplicate ane merge changes are mutually exclusive
696: if p_chg_rcd_upd_flag = 'Y' and p_any_or_all_cd = 'Y' then
697: fnd_message.set_name('BEN','BEN_94267_EXT_DUPS_MERGE_EXCLS');
698: fnd_message.raise_error;
699: end if ;
700: --
701: hr_utility.set_location('Leaving:'||l_proc,10);
702: --

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

761: p_effective_date => p_effective_date) then
762: --
763: -- raise error as does not exist as lookup
764: --
765: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
766: fnd_message.set_token('FIELD','p_hide_flag');
767: fnd_message.set_token('TYPE','YES_NO');
768: fnd_message.raise_error;
769: --

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

762: --
763: -- raise error as does not exist as lookup
764: --
765: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
766: fnd_message.set_token('FIELD','p_hide_flag');
767: fnd_message.set_token('TYPE','YES_NO');
768: fnd_message.raise_error;
769: --
770: end if;

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

763: -- raise error as does not exist as lookup
764: --
765: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
766: fnd_message.set_token('FIELD','p_hide_flag');
767: fnd_message.set_token('TYPE','YES_NO');
768: fnd_message.raise_error;
769: --
770: end if;
771: else

Line 768: fnd_message.raise_error;

764: --
765: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
766: fnd_message.set_token('FIELD','p_hide_flag');
767: fnd_message.set_token('TYPE','YES_NO');
768: fnd_message.raise_error;
769: --
770: end if;
771: else
772: /* BG is null, so alternative call is required */

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: end if;

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: end if;
787: --

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

824: hr_utility.set_location('Entering:'||l_proc, 5);
825: --
826: --
827: if p_seq_num is null or p_seq_num =0 or p_seq_num <0 then
828: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
829: fnd_message.raise_error;
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);

Line 829: fnd_message.raise_error;

825: --
826: --
827: if p_seq_num is null or p_seq_num =0 or p_seq_num <0 then
828: fnd_message.set_name('BEN','BEN_91863_INVLD_SEQ_NUM');
829: fnd_message.raise_error;
830: end if;
831: --
832: hr_utility.set_location('Leaving:'||l_proc,10);
833: --

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

883: open c1;
884: fetch c1 into l_dummy;
885: if c1%found then
886: close c1;
887: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
888: fnd_message.raise_error;
889: end if;
890: hr_utility.set_location('Leaving:'||l_proc,10);
891: --

Line 888: fnd_message.raise_error;

884: fetch c1 into l_dummy;
885: if c1%found then
886: close c1;
887: fnd_message.set_name('BEN','BEN_91954_SEQ_NOT_UNIQUE');
888: fnd_message.raise_error;
889: end if;
890: hr_utility.set_location('Leaving:'||l_proc,10);
891: --
892: end chk_seq_num_unq;

Line 952: fnd_message.set_name('BEN','BEN_92193_EXT_SORT_ORDR_ERR');

948: if p_sort1_data_elmt_in_rcd_id is null
949: and (p_sort2_data_elmt_in_rcd_id is not null or
950: p_sort3_data_elmt_in_rcd_id is not null or
951: p_sort4_data_elmt_in_rcd_id is not null) then
952: fnd_message.set_name('BEN','BEN_92193_EXT_SORT_ORDR_ERR');
953: fnd_message.raise_error;
954: end if;
955: if p_sort2_data_elmt_in_rcd_id is null
956: and (p_sort3_data_elmt_in_rcd_id is not null or

Line 953: fnd_message.raise_error;

949: and (p_sort2_data_elmt_in_rcd_id is not null or
950: p_sort3_data_elmt_in_rcd_id is not null or
951: p_sort4_data_elmt_in_rcd_id is not null) then
952: fnd_message.set_name('BEN','BEN_92193_EXT_SORT_ORDR_ERR');
953: fnd_message.raise_error;
954: end if;
955: if p_sort2_data_elmt_in_rcd_id is null
956: and (p_sort3_data_elmt_in_rcd_id is not null or
957: p_sort4_data_elmt_in_rcd_id is not null) then

Line 958: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');

954: end if;
955: if p_sort2_data_elmt_in_rcd_id is null
956: and (p_sort3_data_elmt_in_rcd_id is not null or
957: p_sort4_data_elmt_in_rcd_id is not null) then
958: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');
959: fnd_message.raise_error;
960: end if;
961: if p_sort3_data_elmt_in_rcd_id is null
962: and (p_sort4_data_elmt_in_rcd_id is not null) then

Line 959: fnd_message.raise_error;

955: if p_sort2_data_elmt_in_rcd_id is null
956: and (p_sort3_data_elmt_in_rcd_id is not null or
957: p_sort4_data_elmt_in_rcd_id is not null) then
958: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');
959: fnd_message.raise_error;
960: end if;
961: if p_sort3_data_elmt_in_rcd_id is null
962: and (p_sort4_data_elmt_in_rcd_id is not null) then
963: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');

Line 963: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');

959: fnd_message.raise_error;
960: end if;
961: if p_sort3_data_elmt_in_rcd_id is null
962: and (p_sort4_data_elmt_in_rcd_id is not null) then
963: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');
964: fnd_message.raise_error;
965: end if;
966: --
967: end if;

Line 964: fnd_message.raise_error;

960: end if;
961: if p_sort3_data_elmt_in_rcd_id is null
962: and (p_sort4_data_elmt_in_rcd_id is not null) then
963: fnd_message.set_name('BEN','BEN_92469_EXT_INVLD_SORT');
964: fnd_message.raise_error;
965: end if;
966: --
967: end if;
968: --

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

1033: fetch c_ext_where_clause into l_ext_where_clause_id;
1034: close c_ext_where_clause;
1035:
1036: if l_ext_where_clause_id is not null then
1037: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1038: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1039: fnd_message.raise_error;
1040:
1041: end if;

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

1034: close c_ext_where_clause;
1035:
1036: if l_ext_where_clause_id is not null then
1037: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1038: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1039: fnd_message.raise_error;
1040:
1041: end if;
1042:

Line 1039: fnd_message.raise_error;

1035:
1036: if l_ext_where_clause_id is not null then
1037: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1038: fnd_message.set_token('TABLE_NAME','ben_ext_where_clause');
1039: fnd_message.raise_error;
1040:
1041: end if;
1042:
1043:

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

1045: fetch c_ext_incl_chg_id into l_ext_incl_chg_id;
1046: close c_ext_incl_chg_id;
1047:
1048: if l_ext_incl_chg_id is not null then
1049: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1050: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1051: fnd_message.raise_error;
1052: end if;
1053:

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

1046: close c_ext_incl_chg_id;
1047:
1048: if l_ext_incl_chg_id is not null then
1049: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1050: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1051: fnd_message.raise_error;
1052: end if;
1053:
1054:

Line 1051: fnd_message.raise_error;

1047:
1048: if l_ext_incl_chg_id is not null then
1049: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1050: fnd_message.set_token('TABLE_NAME','ben_ext_incl_chg');
1051: fnd_message.raise_error;
1052: end if;
1053:
1054:
1055: open c_ext_file_group ;

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

1055: open c_ext_file_group ;
1056: fetch c_ext_file_group into l_dummy ;
1057: if c_ext_file_group%found then
1058: close c_ext_file_group ;
1059: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');
1061: fnd_message.raise_error;
1062: end if ;
1063: close c_ext_file_group ;

Line 1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');

1056: fetch c_ext_file_group into l_dummy ;
1057: if c_ext_file_group%found then
1058: close c_ext_file_group ;
1059: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');
1061: fnd_message.raise_error;
1062: end if ;
1063: close c_ext_file_group ;
1064:

Line 1061: fnd_message.raise_error;

1057: if c_ext_file_group%found then
1058: close c_ext_file_group ;
1059: fnd_message.set_name('PER','HR_7215_DT_CHILD_EXISTS');
1060: fnd_message.set_token('TABLE_NAME','Ben_Ext_file.Grouping');
1061: fnd_message.raise_error;
1062: end if ;
1063: close c_ext_file_group ;
1064:
1065: --

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

1325: close csr_leg_code;
1326: --
1327: -- The primary key is invalid therefore we must error
1328: --
1329: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1330: fnd_message.raise_error;
1331: --
1332: end if;
1333: --

Line 1330: fnd_message.raise_error;

1326: --
1327: -- The primary key is invalid therefore we must error
1328: --
1329: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
1330: fnd_message.raise_error;
1331: --
1332: end if;
1333: --
1334: close csr_leg_code;