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_PRC_BUS dependencies on FND_MESSAGE

Line 298: fnd_message.set_name('BEN', 'BEN_92668_CONTR_BAL_NOT_EXIST');

294: close c_bnft_bal;
295: end if;
296: --
297: else
298: fnd_message.set_name('BEN', 'BEN_92668_CONTR_BAL_NOT_EXIST');
299: fnd_message.set_token('STD_RATE_NAME ', l_abr_prv.name);
300: fnd_message.raise_error;
301:
302: end if;

Line 299: fnd_message.set_token('STD_RATE_NAME ', l_abr_prv.name);

295: end if;
296: --
297: else
298: fnd_message.set_name('BEN', 'BEN_92668_CONTR_BAL_NOT_EXIST');
299: fnd_message.set_token('STD_RATE_NAME ', l_abr_prv.name);
300: fnd_message.raise_error;
301:
302: end if;
303: hr_utility.set_location('Leaving:'||l_proc, 10);

Line 300: fnd_message.raise_error;

296: --
297: else
298: fnd_message.set_name('BEN', 'BEN_92668_CONTR_BAL_NOT_EXIST');
299: fnd_message.set_token('STD_RATE_NAME ', l_abr_prv.name);
300: fnd_message.raise_error;
301:
302: end if;
303: hr_utility.set_location('Leaving:'||l_proc, 10);
304: hr_utility.set_location('ptd_balance '||l_ptd_balance , 293);

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

656: p_effective_date => p_effective_date) then
657: --
658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD','p_rcrrg_cd');
662: fnd_message.set_token('VALUE', p_rcrrg_cd);
663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');
664: fnd_message.raise_error;

Line 661: fnd_message.set_token('FIELD','p_rcrrg_cd');

657: --
658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD','p_rcrrg_cd');
662: fnd_message.set_token('VALUE', p_rcrrg_cd);
663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');
664: fnd_message.raise_error;
665: --

Line 662: fnd_message.set_token('VALUE', p_rcrrg_cd);

658: -- raise error as does not exist as lookup
659: --
660: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD','p_rcrrg_cd');
662: fnd_message.set_token('VALUE', p_rcrrg_cd);
663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');
664: fnd_message.raise_error;
665: --
666: end if;

Line 663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');

659: --
660: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD','p_rcrrg_cd');
662: fnd_message.set_token('VALUE', p_rcrrg_cd);
663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');
664: fnd_message.raise_error;
665: --
666: end if;
667: --

Line 664: fnd_message.raise_error;

660: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
661: fnd_message.set_token('FIELD','p_rcrrg_cd');
662: fnd_message.set_token('VALUE', p_rcrrg_cd);
663: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_RCRG');
664: fnd_message.raise_error;
665: --
666: end if;
667: --
668: end if;

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

729: p_effective_date => p_effective_date) then
730: --
731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');
735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);
736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');
737: fnd_message.raise_error;

Line 734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');

730: --
731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');
735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);
736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');
737: fnd_message.raise_error;
738: --

Line 735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);

731: -- raise error as does not exist as lookup
732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');
735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);
736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');
737: fnd_message.raise_error;
738: --
739: end if;

Line 736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');

732: --
733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');
735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);
736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');
737: fnd_message.raise_error;
738: --
739: end if;
740: --

Line 737: fnd_message.raise_error;

733: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
734: fnd_message.set_token('FIELD','p_reimbmt_ctfn_typ_prvdd_cd');
735: fnd_message.set_token('VALUE', p_reimbmt_ctfn_typ_prvdd_cd);
736: fnd_message.set_token('TYPE','BEN_RMBMT_CTFN_TYP');
737: fnd_message.raise_error;
738: --
739: end if;
740: --
741: end if;

Line 779: fnd_message.set_name('BEN','BEN_92715_APRVD_AMT_IS_NULL');

775: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
776:
777: -- Check the approved amount is entered
778: if nvl(p_aprvd_for_pymt_amt,0) = 0 then
779: fnd_message.set_name('BEN','BEN_92715_APRVD_AMT_IS_NULL');
780: fnd_message.raise_error ;
781: end if ;
782:
783: -- Check the goods/service are defiend if not

Line 780: fnd_message.raise_error ;

776:
777: -- Check the approved amount is entered
778: if nvl(p_aprvd_for_pymt_amt,0) = 0 then
779: fnd_message.set_name('BEN','BEN_92715_APRVD_AMT_IS_NULL');
780: fnd_message.raise_error ;
781: end if ;
782:
783: -- Check the goods/service are defiend if not
784: -- changes the status to pending

Line 801: --fnd_message.set_name('BEN','BEN_92706_REIMB_CTFN_NOT_PRVDD');

797: ,p_effective_date => p_effective_date
798: ,p_ctfn_pending_flag => l_ctfn_pending_flag ) ;
799:
800: if l_ctfn_pending_flag = 'Y' then
801: --fnd_message.set_name('BEN','BEN_92706_REIMB_CTFN_NOT_PRVDD');
802: --fnd_message.show ;
803: p_prtt_reimbmt_rqst_stat_cd := 'PNDNG' ;
804: p_stat_rsn_cd := 'RMBCTFNRQD' ;
805: end if ;

Line 802: --fnd_message.show ;

798: ,p_ctfn_pending_flag => l_ctfn_pending_flag ) ;
799:
800: if l_ctfn_pending_flag = 'Y' then
801: --fnd_message.set_name('BEN','BEN_92706_REIMB_CTFN_NOT_PRVDD');
802: --fnd_message.show ;
803: p_prtt_reimbmt_rqst_stat_cd := 'PNDNG' ;
804: p_stat_rsn_cd := 'RMBCTFNRQD' ;
805: end if ;
806: end if ;

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

853: p_effective_date => p_effective_date) then
854: --
855: -- raise error as does not exist as lookup
856: --
857: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
858: fnd_message.set_token('FIELD','p_stat_rsn_cd');
859: fnd_message.set_token('VALUE', p_stat_rsn_cd);
860: fnd_message.set_token('TYPE','BEN_STAT_RSN');
861: fnd_message.raise_error;

Line 858: fnd_message.set_token('FIELD','p_stat_rsn_cd');

854: --
855: -- raise error as does not exist as lookup
856: --
857: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
858: fnd_message.set_token('FIELD','p_stat_rsn_cd');
859: fnd_message.set_token('VALUE', p_stat_rsn_cd);
860: fnd_message.set_token('TYPE','BEN_STAT_RSN');
861: fnd_message.raise_error;
862: --

Line 859: fnd_message.set_token('VALUE', p_stat_rsn_cd);

855: -- raise error as does not exist as lookup
856: --
857: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
858: fnd_message.set_token('FIELD','p_stat_rsn_cd');
859: fnd_message.set_token('VALUE', p_stat_rsn_cd);
860: fnd_message.set_token('TYPE','BEN_STAT_RSN');
861: fnd_message.raise_error;
862: --
863: end if;

Line 860: fnd_message.set_token('TYPE','BEN_STAT_RSN');

856: --
857: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
858: fnd_message.set_token('FIELD','p_stat_rsn_cd');
859: fnd_message.set_token('VALUE', p_stat_rsn_cd);
860: fnd_message.set_token('TYPE','BEN_STAT_RSN');
861: fnd_message.raise_error;
862: --
863: end if;
864:

Line 861: fnd_message.raise_error;

857: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
858: fnd_message.set_token('FIELD','p_stat_rsn_cd');
859: fnd_message.set_token('VALUE', p_stat_rsn_cd);
860: fnd_message.set_token('TYPE','BEN_STAT_RSN');
861: fnd_message.raise_error;
862: --
863: end if;
864:
865: --

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

908: p_effective_date => p_effective_date) then
909: --
910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');
914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);
915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');
916: fnd_message.raise_error;

Line 913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');

909: --
910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');
914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);
915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');
916: fnd_message.raise_error;
917: --

Line 914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);

910: -- raise error as does not exist as lookup
911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');
914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);
915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');
916: fnd_message.raise_error;
917: --
918: end if;

Line 915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');

911: --
912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');
914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);
915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');
916: fnd_message.raise_error;
917: --
918: end if;
919:

Line 916: fnd_message.raise_error;

912: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
913: fnd_message.set_token('FIELD','p_pymt_stat_rsn_cd');
914: fnd_message.set_token('VALUE', p_pymt_stat_rsn_cd);
915: fnd_message.set_token('TYPE','BEN_PYMT_STAT_RSN');
916: fnd_message.raise_error;
917: --
918: end if;
919:
920: --

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

962: p_effective_date => p_effective_date) then
963: --
964: -- raise error as does not exist as lookup
965: --
966: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
967: fnd_message.set_token('FIELD','p_pymt_stat_cd');
968: fnd_message.set_token('VALUE', p_pymt_stat_cd);
969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');
970: fnd_message.raise_error;

Line 967: fnd_message.set_token('FIELD','p_pymt_stat_cd');

963: --
964: -- raise error as does not exist as lookup
965: --
966: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
967: fnd_message.set_token('FIELD','p_pymt_stat_cd');
968: fnd_message.set_token('VALUE', p_pymt_stat_cd);
969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');
970: fnd_message.raise_error;
971: --

Line 968: fnd_message.set_token('VALUE', p_pymt_stat_cd);

964: -- raise error as does not exist as lookup
965: --
966: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
967: fnd_message.set_token('FIELD','p_pymt_stat_cd');
968: fnd_message.set_token('VALUE', p_pymt_stat_cd);
969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');
970: fnd_message.raise_error;
971: --
972: end if;

Line 969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');

965: --
966: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
967: fnd_message.set_token('FIELD','p_pymt_stat_cd');
968: fnd_message.set_token('VALUE', p_pymt_stat_cd);
969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');
970: fnd_message.raise_error;
971: --
972: end if;
973:

Line 970: fnd_message.raise_error;

966: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
967: fnd_message.set_token('FIELD','p_pymt_stat_cd');
968: fnd_message.set_token('VALUE', p_pymt_stat_cd);
969: fnd_message.set_token('TYPE','BEN_PYMT_STAT');
970: fnd_message.raise_error;
971: --
972: end if;
973:
974: --

Line 1045: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');

1041: if l_api_updating -- added l_api_updating to perform the check only when updating
1042: and ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD')
1043: and p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
1044: --
1045: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1046: fnd_message.raise_error;
1047: --
1048: end if ;
1049:

Line 1046: fnd_message.raise_error;

1042: and ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD')
1043: and p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
1044: --
1045: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1046: fnd_message.raise_error;
1047: --
1048: end if ;
1049:
1050: -- hnarayan -- bug fix 2223214

Line 1059: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');

1055: -- presence of voided claims shud not prevent back-out of a life event.
1056: --
1057: ----Once voiced rquest is not allowd to be cahnged
1058: if l_api_updating and ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1059: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1060: fnd_message.raise_error;
1061: end if ;
1062:
1063: if (l_api_updating

Line 1060: fnd_message.raise_error;

1056: --
1057: ----Once voiced rquest is not allowd to be cahnged
1058: if l_api_updating and ben_prc_shd.g_old_rec.prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1059: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1060: fnd_message.raise_error;
1061: end if ;
1062:
1063: if (l_api_updating
1064: and p_prtt_reimbmt_rqst_stat_cd

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

1074: p_effective_date => p_effective_date) then
1075: --
1076: -- raise error as does not exist as lookup
1077: --
1078: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');
1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);
1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');
1082: fnd_message.raise_error;

Line 1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');

1075: --
1076: -- raise error as does not exist as lookup
1077: --
1078: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');
1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);
1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');
1082: fnd_message.raise_error;
1083: --

Line 1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);

1076: -- raise error as does not exist as lookup
1077: --
1078: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');
1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);
1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');
1082: fnd_message.raise_error;
1083: --
1084: end if;

Line 1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');

1077: --
1078: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');
1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);
1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');
1082: fnd_message.raise_error;
1083: --
1084: end if;
1085: --

Line 1082: fnd_message.raise_error;

1078: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1079: fnd_message.set_token('FIELD','p_prtt_reimbmt_rqst_stat_cd');
1080: fnd_message.set_token('VALUE', p_prtt_reimbmt_rqst_stat_cd);
1081: fnd_message.set_token('TYPE','BEN_REIMBMT_RQST_STAT');
1082: fnd_message.raise_error;
1083: --
1084: end if;
1085: --
1086: end if;

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

1226: if l_test is null then
1227: --
1228: -- raise error as does not exist as lookup
1229: --
1230: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');
1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);
1233: fnd_message.set_token('TYPE','fnd_currencies');
1234: fnd_message.raise_error;

Line 1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');

1227: --
1228: -- raise error as does not exist as lookup
1229: --
1230: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');
1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);
1233: fnd_message.set_token('TYPE','fnd_currencies');
1234: fnd_message.raise_error;
1235: --

Line 1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);

1228: -- raise error as does not exist as lookup
1229: --
1230: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');
1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);
1233: fnd_message.set_token('TYPE','fnd_currencies');
1234: fnd_message.raise_error;
1235: --
1236: end if;

Line 1233: fnd_message.set_token('TYPE','fnd_currencies');

1229: --
1230: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');
1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);
1233: fnd_message.set_token('TYPE','fnd_currencies');
1234: fnd_message.raise_error;
1235: --
1236: end if;
1237: end if;

Line 1234: fnd_message.raise_error;

1230: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
1231: fnd_message.set_token('FIELD','p_rqst_amt_uom');
1232: fnd_message.set_token('VALUE', p_rqst_amt_uom);
1233: fnd_message.set_token('TYPE','fnd_currencies');
1234: fnd_message.raise_error;
1235: --
1236: end if;
1237: end if;
1238:

Line 1244: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');

1240: open c2 (p_popl_yr_perd_id_1);
1241: fetch c2 into l_c2_rec;
1242: if c2%notfound and p_popl_yr_perd_id_2 is null then
1243: close c2;
1244: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1245: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1246: fnd_message.set_token('PLAN_ID', p_pl_id);
1247: fnd_message.raise_error;
1248: end if;

Line 1245: fnd_message.set_token('PERSON_ID', p_submitter_person_id);

1241: fetch c2 into l_c2_rec;
1242: if c2%notfound and p_popl_yr_perd_id_2 is null then
1243: close c2;
1244: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1245: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1246: fnd_message.set_token('PLAN_ID', p_pl_id);
1247: fnd_message.raise_error;
1248: end if;
1249: close c2;

Line 1246: fnd_message.set_token('PLAN_ID', p_pl_id);

1242: if c2%notfound and p_popl_yr_perd_id_2 is null then
1243: close c2;
1244: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1245: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1246: fnd_message.set_token('PLAN_ID', p_pl_id);
1247: fnd_message.raise_error;
1248: end if;
1249: close c2;
1250: --

Line 1247: fnd_message.raise_error;

1243: close c2;
1244: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1245: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1246: fnd_message.set_token('PLAN_ID', p_pl_id);
1247: fnd_message.raise_error;
1248: end if;
1249: close c2;
1250: --
1251: if l_c2_rec.cmpr_clms_to_cvg_or_bal_cd is null then

Line 1266: fnd_message.set_name('BEN','BEN_92714_APRVD_MORE_THAN_RMT');

1262:
1263:
1264: ---if the aproved amount is more than the requested amount then error
1265: if nvl(p_rqst_amt,0) < nvl(p_aprvd_for_pymt_amt,0) then
1266: fnd_message.set_name('BEN','BEN_92714_APRVD_MORE_THAN_RMT');
1267: fnd_message.raise_error;
1268: end if ;
1269:
1270: -- check the rqst_amt

Line 1267: fnd_message.raise_error;

1263:
1264: ---if the aproved amount is more than the requested amount then error
1265: if nvl(p_rqst_amt,0) < nvl(p_aprvd_for_pymt_amt,0) then
1266: fnd_message.set_name('BEN','BEN_92714_APRVD_MORE_THAN_RMT');
1267: fnd_message.raise_error;
1268: end if ;
1269:
1270: -- check the rqst_amt
1271: ---tilak : this check removed ,approved amount is no stored

Line 1337: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');

1333: open c2 (p_popl_yr_perd_id_2);
1334: fetch c2 into l_c2_rec;
1335: if c2%notfound then
1336: close c2;
1337: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1338: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1339: fnd_message.set_token('PLAN_ID', p_pl_id);
1340: fnd_message.raise_error;
1341: end if;

Line 1338: fnd_message.set_token('PERSON_ID', p_submitter_person_id);

1334: fetch c2 into l_c2_rec;
1335: if c2%notfound then
1336: close c2;
1337: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1338: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1339: fnd_message.set_token('PLAN_ID', p_pl_id);
1340: fnd_message.raise_error;
1341: end if;
1342: close c2;

Line 1339: fnd_message.set_token('PLAN_ID', p_pl_id);

1335: if c2%notfound then
1336: close c2;
1337: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1338: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1339: fnd_message.set_token('PLAN_ID', p_pl_id);
1340: fnd_message.raise_error;
1341: end if;
1342: close c2;
1343: --

Line 1340: fnd_message.raise_error;

1336: close c2;
1337: fnd_message.set_name('BEN','BEN_91452_PL_ENRT_MISSING');
1338: fnd_message.set_token('PERSON_ID', p_submitter_person_id);
1339: fnd_message.set_token('PLAN_ID', p_pl_id);
1340: fnd_message.raise_error;
1341: end if;
1342: close c2;
1343: --
1344: if prev_yr_cvg <= l_amt_1 or prev_yr_cvg = 0 then

Line 1484: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');

1480: begin
1481: hr_utility.set_location('Entering:'||l_proc, 5);
1482:
1483: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
1484: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1485: fnd_message.raise_error;
1486: end if ;
1487: if p_prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');

Line 1485: fnd_message.raise_error;

1481: hr_utility.set_location('Entering:'||l_proc, 5);
1482:
1483: if p_prtt_reimbmt_rqst_stat_cd in ('APPRVD','PDINFL','PRTLYPD') then
1484: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1485: fnd_message.raise_error;
1486: end if ;
1487: if p_prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1489: fnd_message.raise_error;

Line 1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');

1484: fnd_message.set_name('BEN','BEN_92705_REIMB_RQST_APPROVD');
1485: fnd_message.raise_error;
1486: end if ;
1487: if p_prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1489: fnd_message.raise_error;
1490: end if ;
1491:
1492: hr_utility.set_location('Leaving:'||l_proc,10);

Line 1489: fnd_message.raise_error;

1485: fnd_message.raise_error;
1486: end if ;
1487: if p_prtt_reimbmt_rqst_stat_cd = 'VOIDED' then
1488: fnd_message.set_name('BEN','BEN_92708_REIMB_RQST_VOIDED');
1489: fnd_message.raise_error;
1490: end if ;
1491:
1492: hr_utility.set_location('Leaving:'||l_proc,10);
1493: end chk_remb_status;

Line 1600: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_REIMB_REQ');

1596: open c_prc ;
1597: fetch c_prc into l_dummy_var ;
1598: if c_prc%found then
1599: close c_prc ;
1600: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_REIMB_REQ');
1601: fnd_message.raise_error;
1602: end if ;
1603: close c_prc ;
1604: */

Line 1601: fnd_message.raise_error;

1597: fetch c_prc into l_dummy_var ;
1598: if c_prc%found then
1599: close c_prc ;
1600: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_REIMB_REQ');
1601: fnd_message.raise_error;
1602: end if ;
1603: close c_prc ;
1604: */
1605: -- when the future date tracked election is avaialble

Line 1612: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_ELE_EXIST');

1608: open c_per ;
1609: fetch c_per into l_dummy_var ;
1610: if c_per%found then
1611: close c_per ;
1612: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_ELE_EXIST');
1613: fnd_message.raise_error;
1614: end if ;
1615: close c_per ;
1616: */

Line 1613: fnd_message.raise_error;

1609: fetch c_per into l_dummy_var ;
1610: if c_per%found then
1611: close c_per ;
1612: fnd_message.set_name('BEN', 'BEN_92663_FUTURE_DTD_ELE_EXIST');
1613: fnd_message.raise_error;
1614: end if ;
1615: close c_per ;
1616: */
1617: --

Line 1639: fnd_message.set_name('BEN', 'BEN_92455_STRT_RUN_RESULTS');

1635: fetch c_get_end_dt into g_max_end_date;
1636: close c_get_end_dt;
1637: if g_max_end_date is not null and (g_max_end_date +1) > l_rt_strt_dt then
1638: -- Issue a warning to the user. These will display on the enrt forms.
1639: fnd_message.set_name('BEN', 'BEN_92455_STRT_RUN_RESULTS');
1640: fnd_message.set_token('PARMA', l_rt_strt_dt);
1641: fnd_message.set_token('PARMB',g_max_end_date);
1642: fnd_message.raise_error;
1643:

Line 1640: fnd_message.set_token('PARMA', l_rt_strt_dt);

1636: close c_get_end_dt;
1637: if g_max_end_date is not null and (g_max_end_date +1) > l_rt_strt_dt then
1638: -- Issue a warning to the user. These will display on the enrt forms.
1639: fnd_message.set_name('BEN', 'BEN_92455_STRT_RUN_RESULTS');
1640: fnd_message.set_token('PARMA', l_rt_strt_dt);
1641: fnd_message.set_token('PARMB',g_max_end_date);
1642: fnd_message.raise_error;
1643:
1644: end if;

Line 1641: fnd_message.set_token('PARMB',g_max_end_date);

1637: if g_max_end_date is not null and (g_max_end_date +1) > l_rt_strt_dt then
1638: -- Issue a warning to the user. These will display on the enrt forms.
1639: fnd_message.set_name('BEN', 'BEN_92455_STRT_RUN_RESULTS');
1640: fnd_message.set_token('PARMA', l_rt_strt_dt);
1641: fnd_message.set_token('PARMB',g_max_end_date);
1642: fnd_message.raise_error;
1643:
1644: end if;
1645: hr_utility.set_location('Leaving:' ||l_proc,5);

Line 1642: fnd_message.raise_error;

1638: -- Issue a warning to the user. These will display on the enrt forms.
1639: fnd_message.set_name('BEN', 'BEN_92455_STRT_RUN_RESULTS');
1640: fnd_message.set_token('PARMA', l_rt_strt_dt);
1641: fnd_message.set_token('PARMB',g_max_end_date);
1642: fnd_message.raise_error;
1643:
1644: end if;
1645: hr_utility.set_location('Leaving:' ||l_proc,5);
1646: end chk_future_dated ;

Line 1887: --fnd_message.set_name('BEN', 'BEN_92689_TO_DATE_EFF_DATE');

1883: --
1884: -- check incrd_to_dt is not greater than effective date
1885: if p_incrd_to_dt > p_effective_date then
1886: --
1887: --fnd_message.set_name('BEN', 'BEN_92689_TO_DATE_EFF_DATE');
1888: --fnd_message.raise_error;
1889:
1890: p_prtt_reimbmt_rqst_stat_cd := 'PNDNG' ;
1891: p_stat_rsn_cd := 'RMBFUTRDT' ;

Line 1888: --fnd_message.raise_error;

1884: -- check incrd_to_dt is not greater than effective date
1885: if p_incrd_to_dt > p_effective_date then
1886: --
1887: --fnd_message.set_name('BEN', 'BEN_92689_TO_DATE_EFF_DATE');
1888: --fnd_message.raise_error;
1889:
1890: p_prtt_reimbmt_rqst_stat_cd := 'PNDNG' ;
1891: p_stat_rsn_cd := 'RMBFUTRDT' ;
1892:

Line 1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');

1919: end Loop ;
1920:
1921: if l_enrt_cvg_strt_dt is null or l_enrt_cvg_thru_dt is null then
1922: --
1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);
1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);
1927: fnd_message.raise_error;

Line 1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);

1920:
1921: if l_enrt_cvg_strt_dt is null or l_enrt_cvg_thru_dt is null then
1922: --
1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);
1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);
1927: fnd_message.raise_error;
1928: --

Line 1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);

1921: if l_enrt_cvg_strt_dt is null or l_enrt_cvg_thru_dt is null then
1922: --
1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);
1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);
1927: fnd_message.raise_error;
1928: --
1929: else

Line 1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);

1922: --
1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);
1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);
1927: fnd_message.raise_error;
1928: --
1929: else
1930: --

Line 1927: fnd_message.raise_error;

1923: fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1924: fnd_message.set_token('COLUMN','Expense Incurred Date', TRUE);
1925: fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1926: fnd_message.set_token('MAXIMUM','Expense Must Be Incurred On Or Before Date', TRUE);
1927: fnd_message.raise_error;
1928: --
1929: else
1930: --
1931: --

Line 1936: -- fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');

1932: if p_effective_date < l_yrp_start_date then
1933: --
1934: -- bug fix 2509297 - message change
1935: --
1936: -- fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);
1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);
1940: --

Line 1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);

1933: --
1934: -- bug fix 2509297 - message change
1935: --
1936: -- fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);
1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);
1940: --
1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');

Line 1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);

1934: -- bug fix 2509297 - message change
1935: --
1936: -- fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);
1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);
1940: --
1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');
1942: --

Line 1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);

1935: --
1936: -- fnd_message.set_name('PAY', 'HR_52965_COL_RANGE');
1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);
1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);
1940: --
1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');
1942: --
1943: -- end fix 2509297

Line 1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');

1937: -- fnd_message.set_token('COLUMN','Effective Date', TRUE);
1938: -- fnd_message.set_token('MINIMUM','Plan Year Start Date', TRUE);
1939: -- fnd_message.set_token('MAXIMUM','Request Must Be Received On Or Before Date', TRUE);
1940: --
1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');
1942: --
1943: -- end fix 2509297
1944: --
1945: fnd_message.raise_error;

Line 1945: fnd_message.raise_error;

1941: fnd_message.set_name('BEN', 'BEN_93189_EFFDT_NB_PLYR_RQRCV');
1942: --
1943: -- end fix 2509297
1944: --
1945: fnd_message.raise_error;
1946: --
1947: end if;
1948: --
1949: hr_utility.set_location(' p_effective_date ' || p_effective_date , 98 );

Line 1957: fnd_message.set_name('BEN', 'BEN_92499_CLM_AFTR_ALWD_DT');

1953: -- No claim to be accepted beyond acpt_clm_rqsts_thru_dt.
1954: -- If acpt_clm_rqsts_thru_dt not specified, use enrt_cvg_thru_dt
1955: -- Effective beyond the date, so raise error.
1956: --
1957: fnd_message.set_name('BEN', 'BEN_92499_CLM_AFTR_ALWD_DT');
1958: fnd_message.set_token('RQST_THRU_DT', to_char(l_acpt_clm_rqsts_thru_dt,'DD-MON-RRRR'));
1959: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date,'DD-MON-RRRR'));
1960: fnd_message.raise_error;
1961: --

Line 1958: fnd_message.set_token('RQST_THRU_DT', to_char(l_acpt_clm_rqsts_thru_dt,'DD-MON-RRRR'));

1954: -- If acpt_clm_rqsts_thru_dt not specified, use enrt_cvg_thru_dt
1955: -- Effective beyond the date, so raise error.
1956: --
1957: fnd_message.set_name('BEN', 'BEN_92499_CLM_AFTR_ALWD_DT');
1958: fnd_message.set_token('RQST_THRU_DT', to_char(l_acpt_clm_rqsts_thru_dt,'DD-MON-RRRR'));
1959: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date,'DD-MON-RRRR'));
1960: fnd_message.raise_error;
1961: --
1962: end if;

Line 1959: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date,'DD-MON-RRRR'));

1955: -- Effective beyond the date, so raise error.
1956: --
1957: fnd_message.set_name('BEN', 'BEN_92499_CLM_AFTR_ALWD_DT');
1958: fnd_message.set_token('RQST_THRU_DT', to_char(l_acpt_clm_rqsts_thru_dt,'DD-MON-RRRR'));
1959: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date,'DD-MON-RRRR'));
1960: fnd_message.raise_error;
1961: --
1962: end if;
1963: --

Line 1960: fnd_message.raise_error;

1956: --
1957: fnd_message.set_name('BEN', 'BEN_92499_CLM_AFTR_ALWD_DT');
1958: fnd_message.set_token('RQST_THRU_DT', to_char(l_acpt_clm_rqsts_thru_dt,'DD-MON-RRRR'));
1959: fnd_message.set_token('EFFECTIVE_DATE', to_char(p_effective_date,'DD-MON-RRRR'));
1960: fnd_message.raise_error;
1961: --
1962: end if;
1963: --
1964: hr_utility.set_location(' p_incrd_from_dt ' || p_incrd_from_dt , 98 );

Line 1979: fnd_message.set_name('BEN', 'BEN_92498_RQST_BYND_CVG_DT');

1975: --
1976: -- The service "from" and "to" date is beyond the coverage range.
1977: -- So, raise error.
1978: --
1979: fnd_message.set_name('BEN', 'BEN_92498_RQST_BYND_CVG_DT');
1980: fnd_message.raise_error;
1981: --
1982: end if;
1983: --

Line 1980: fnd_message.raise_error;

1976: -- The service "from" and "to" date is beyond the coverage range.
1977: -- So, raise error.
1978: --
1979: fnd_message.set_name('BEN', 'BEN_92498_RQST_BYND_CVG_DT');
1980: fnd_message.raise_error;
1981: --
1982: end if;
1983: --
1984: end if;

Line 2016: fnd_message.set_name('BEN', 'BEN_93106_CLM_GD_SBMTDT_XCEED');

2012: --
2013: /*
2014: if l_over_dated_gds_exists then
2015: --
2016: fnd_message.set_name('BEN', 'BEN_93106_CLM_GD_SBMTDT_XCEED');
2017: fnd_message.set_token('GDS_DATE', l_gds_date_str);
2018: fnd_message.raise_error;
2019: --
2020: end if;

Line 2017: fnd_message.set_token('GDS_DATE', l_gds_date_str);

2013: /*
2014: if l_over_dated_gds_exists then
2015: --
2016: fnd_message.set_name('BEN', 'BEN_93106_CLM_GD_SBMTDT_XCEED');
2017: fnd_message.set_token('GDS_DATE', l_gds_date_str);
2018: fnd_message.raise_error;
2019: --
2020: end if;
2021: --

Line 2018: fnd_message.raise_error;

2014: if l_over_dated_gds_exists then
2015: --
2016: fnd_message.set_name('BEN', 'BEN_93106_CLM_GD_SBMTDT_XCEED');
2017: fnd_message.set_token('GDS_DATE', l_gds_date_str);
2018: fnd_message.raise_error;
2019: --
2020: end if;
2021: --
2022: */

Line 2123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2119: --
2120: -- An unhandled or unexpected error has occurred which
2121: -- we must report
2122: --
2123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2124: fnd_message.set_token('PROCEDURE', l_proc);
2125: fnd_message.set_token('STEP','15');
2126: fnd_message.raise_error;
2127: End dt_update_validate;

Line 2124: fnd_message.set_token('PROCEDURE', l_proc);

2120: -- An unhandled or unexpected error has occurred which
2121: -- we must report
2122: --
2123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2124: fnd_message.set_token('PROCEDURE', l_proc);
2125: fnd_message.set_token('STEP','15');
2126: fnd_message.raise_error;
2127: End dt_update_validate;
2128: -- ----------------------------------------------------------------------------

Line 2125: fnd_message.set_token('STEP','15');

2121: -- we must report
2122: --
2123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2124: fnd_message.set_token('PROCEDURE', l_proc);
2125: fnd_message.set_token('STEP','15');
2126: fnd_message.raise_error;
2127: End dt_update_validate;
2128: -- ----------------------------------------------------------------------------
2129: -- |--------------------------< prv_rows_exists >--------------------------|

Line 2126: fnd_message.raise_error;

2122: --
2123: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2124: fnd_message.set_token('PROCEDURE', l_proc);
2125: fnd_message.set_token('STEP','15');
2126: fnd_message.raise_error;
2127: End dt_update_validate;
2128: -- ----------------------------------------------------------------------------
2129: -- |--------------------------< prv_rows_exists >--------------------------|
2130: -- ----------------------------------------------------------------------------

Line 2260: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');

2256: --
2257: -- An unhandled or unexpected error has occurred which
2258: -- we must report
2259: --
2260: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2261: fnd_message.set_token('PROCEDURE', l_proc);
2262: fnd_message.set_token('STEP','15');
2263: fnd_message.raise_error;
2264: End dt_delete_validate;

Line 2261: fnd_message.set_token('PROCEDURE', l_proc);

2257: -- An unhandled or unexpected error has occurred which
2258: -- we must report
2259: --
2260: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2261: fnd_message.set_token('PROCEDURE', l_proc);
2262: fnd_message.set_token('STEP','15');
2263: fnd_message.raise_error;
2264: End dt_delete_validate;
2265: --

Line 2262: fnd_message.set_token('STEP','15');

2258: -- we must report
2259: --
2260: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2261: fnd_message.set_token('PROCEDURE', l_proc);
2262: fnd_message.set_token('STEP','15');
2263: fnd_message.raise_error;
2264: End dt_delete_validate;
2265: --
2266: -- ----------------------------------------------------------------------------

Line 2263: fnd_message.raise_error;

2259: --
2260: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
2261: fnd_message.set_token('PROCEDURE', l_proc);
2262: fnd_message.set_token('STEP','15');
2263: fnd_message.raise_error;
2264: End dt_delete_validate;
2265: --
2266: -- ----------------------------------------------------------------------------
2267: -- |---------------------------< insert_validate >----------------------------|

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

2624: close csr_leg_code;
2625: --
2626: -- The primary key is invalid therefore we must error
2627: --
2628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2629: fnd_message.raise_error;
2630: --
2631: end if;
2632: --

Line 2629: fnd_message.raise_error;

2625: --
2626: -- The primary key is invalid therefore we must error
2627: --
2628: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
2629: fnd_message.raise_error;
2630: --
2631: end if;
2632: --
2633: close csr_leg_code;