DBA Data[Home] [Help]

APPS.BEN_PPL_BUS dependencies on FND_MESSAGE

Line 153: fnd_message.set_name('BEN','BEN_94161_CHKLST_IN_PTNL_LE');

149: else
150: --
151: if l_typ_cd = 'CHECKLIST' then
152: --
153: fnd_message.set_name('BEN','BEN_94161_CHKLST_IN_PTNL_LE');
154: fnd_message.raise_error;
155: end if ;
156: null;
157: /*

Line 154: fnd_message.raise_error;

150: --
151: if l_typ_cd = 'CHECKLIST' then
152: --
153: fnd_message.set_name('BEN','BEN_94161_CHKLST_IN_PTNL_LE');
154: fnd_message.raise_error;
155: end if ;
156: null;
157: /*
158: -- PB : 5422 :

Line 169: fnd_message.set_name('BEN','BEN_91249_ENRT_PERD_ID_NULL');

165: --
166: -- if enrt_perd_id value supplied then life event must
167: -- be of schedule type
168: --
169: fnd_message.set_name('BEN','BEN_91249_ENRT_PERD_ID_NULL');
170: fnd_message.raise_error;
171: --
172: end if;
173: */

Line 170: fnd_message.raise_error;

166: -- if enrt_perd_id value supplied then life event must
167: -- be of schedule type
168: --
169: fnd_message.set_name('BEN','BEN_91249_ENRT_PERD_ID_NULL');
170: fnd_message.raise_error;
171: --
172: end if;
173: */
174: --

Line 253: fnd_message.set_name('BEN', 'BEN_92495_NOT_UNQ_PER_PTNL_LER');

249: --
250: open c1;
251: fetch c1 into l_dummy;
252: if (c1%found) then
253: fnd_message.set_name('BEN', 'BEN_92495_NOT_UNQ_PER_PTNL_LER');
254: fnd_message.raise_error;
255: end if;
256: --
257: end if;

Line 254: fnd_message.raise_error;

250: open c1;
251: fetch c1 into l_dummy;
252: if (c1%found) then
253: fnd_message.set_name('BEN', 'BEN_92495_NOT_UNQ_PER_PTNL_LER');
254: fnd_message.raise_error;
255: end if;
256: --
257: end if;
258: hr_utility.set_location('Leaving' || l_proc,15);

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

626: p_effective_date => p_effective_date) then
627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_src_cd');
632: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_SRC');
633: fnd_message.raise_error;
634: --

Line 631: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_src_cd');

627: --
628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_src_cd');
632: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_SRC');
633: fnd_message.raise_error;
634: --
635: end if;

Line 632: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_SRC');

628: -- raise error as does not exist as lookup
629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_src_cd');
632: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_SRC');
633: fnd_message.raise_error;
634: --
635: end if;
636: --

Line 633: fnd_message.raise_error;

629: --
630: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
631: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_src_cd');
632: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_SRC');
633: fnd_message.raise_error;
634: --
635: end if;
636: --
637: end if;

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

695: p_effective_date => p_effective_date) then
696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_stat_cd');
701: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_STAT');
702: fnd_message.raise_error;
703: --

Line 700: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_stat_cd');

696: --
697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_stat_cd');
701: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_STAT');
702: fnd_message.raise_error;
703: --
704: end if;

Line 701: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_STAT');

697: -- raise error as does not exist as lookup
698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_stat_cd');
701: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_STAT');
702: fnd_message.raise_error;
703: --
704: end if;
705: --

Line 702: fnd_message.raise_error;

698: --
699: fnd_message.set_name('BEN','BEN_91628_LOOKUP_TYPE_GENERIC');
700: fnd_message.set_token('FIELD','p_ptnl_ler_for_per_stat_cd');
701: fnd_message.set_token('TYPE','BEN_PTNL_LER_FOR_PER_STAT');
702: fnd_message.raise_error;
703: --
704: end if;
705: --
706: -- Check the PPL status code transitions

Line 712: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

708: if not l_api_updating
709: and p_ptnl_ler_for_per_stat_cd not in ('DTCTD', 'UNPROCD') then
710: --
711: hr_utility.set_location('Creation: '||l_proc, 10);
712: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
713: fnd_message.raise_error;
714: --
715: elsif l_api_updating
716: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'DTCTD'

Line 713: fnd_message.raise_error;

709: and p_ptnl_ler_for_per_stat_cd not in ('DTCTD', 'UNPROCD') then
710: --
711: hr_utility.set_location('Creation: '||l_proc, 10);
712: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
713: fnd_message.raise_error;
714: --
715: elsif l_api_updating
716: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'DTCTD'
717: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then

Line 720: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

716: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'DTCTD'
717: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
718: --
719: hr_utility.set_location('DTCTD: '||l_proc, 10);
720: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
721: fnd_message.raise_error;
722: --
723: elsif l_api_updating
724: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'UNPROCD'

Line 721: fnd_message.raise_error;

717: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
718: --
719: hr_utility.set_location('DTCTD: '||l_proc, 10);
720: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
721: fnd_message.raise_error;
722: --
723: elsif l_api_updating
724: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'UNPROCD'
725: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then

Line 728: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

724: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'UNPROCD'
725: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
726: --
727: hr_utility.set_location('UNPROCD: '||l_proc, 10);
728: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
729: fnd_message.raise_error;
730: --
731: elsif l_api_updating
732: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'VOIDD'

Line 729: fnd_message.raise_error;

725: and p_ptnl_ler_for_per_stat_cd not in ('PROCD', 'VOIDD','MNL') then
726: --
727: hr_utility.set_location('UNPROCD: '||l_proc, 10);
728: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
729: fnd_message.raise_error;
730: --
731: elsif l_api_updating
732: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'VOIDD'
733: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL') then

Line 736: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

732: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'VOIDD'
733: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL') then
734: --
735: hr_utility.set_location('VOIDD: '||l_proc, 10);
736: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
737: fnd_message.raise_error;
738: --
739: elsif l_api_updating
740: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'PROCD'

Line 737: fnd_message.raise_error;

733: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL') then
734: --
735: hr_utility.set_location('VOIDD: '||l_proc, 10);
736: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
737: fnd_message.raise_error;
738: --
739: elsif l_api_updating
740: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'PROCD'
741: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL','VOIDD') then

Line 744: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

740: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'PROCD'
741: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL','VOIDD') then
742: --
743: hr_utility.set_location('PROCD: '||l_proc, 10);
744: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
745: fnd_message.raise_error;
746: --
747: elsif l_api_updating
748: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'MNL'

Line 745: fnd_message.raise_error;

741: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','MNL','VOIDD') then
742: --
743: hr_utility.set_location('PROCD: '||l_proc, 10);
744: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
745: fnd_message.raise_error;
746: --
747: elsif l_api_updating
748: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'MNL'
749: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','VOIDD','MNLO') then

Line 752: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');

748: and ben_ppl_shd.g_old_rec.ptnl_ler_for_per_stat_cd = 'MNL'
749: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','VOIDD','MNLO') then
750: --
751: hr_utility.set_location('MNL: '||l_proc, 10);
752: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
753: fnd_message.raise_error;
754: --
755: end if;
756: --

Line 753: fnd_message.raise_error;

749: and p_ptnl_ler_for_per_stat_cd not in ('UNPROCD','VOIDD','MNLO') then
750: --
751: hr_utility.set_location('MNL: '||l_proc, 10);
752: fnd_message.set_name('BEN','BEN_92162_INV_PPL_STCD_TRANS');
753: fnd_message.raise_error;
754: --
755: end if;
756: --
757: end if;

Line 892: fnd_message.set_name('BEN','BEN_92329_PROCD_DATE_NULL');

888: --
889: if p_ptnl_ler_for_per_stat_cd = 'PROCD' and
890: p_procd_dt is null then
891: --
892: fnd_message.set_name('BEN','BEN_92329_PROCD_DATE_NULL');
893: fnd_message.raise_error;
894: --
895: elsif p_ptnl_ler_for_per_stat_cd = 'VOIDD' and
896: p_voidd_dt is null then

Line 893: fnd_message.raise_error;

889: if p_ptnl_ler_for_per_stat_cd = 'PROCD' and
890: p_procd_dt is null then
891: --
892: fnd_message.set_name('BEN','BEN_92329_PROCD_DATE_NULL');
893: fnd_message.raise_error;
894: --
895: elsif p_ptnl_ler_for_per_stat_cd = 'VOIDD' and
896: p_voidd_dt is null then
897: --

Line 898: fnd_message.set_name('BEN','BEN_92330_VOIDD_DATE_NULL');

894: --
895: elsif p_ptnl_ler_for_per_stat_cd = 'VOIDD' and
896: p_voidd_dt is null then
897: --
898: fnd_message.set_name('BEN','BEN_92330_VOIDD_DATE_NULL');
899: fnd_message.raise_error;
900: --
901: elsif p_ptnl_ler_for_per_stat_cd = 'UNPROCD' and
902: p_unprocd_dt is null then

Line 899: fnd_message.raise_error;

895: elsif p_ptnl_ler_for_per_stat_cd = 'VOIDD' and
896: p_voidd_dt is null then
897: --
898: fnd_message.set_name('BEN','BEN_92330_VOIDD_DATE_NULL');
899: fnd_message.raise_error;
900: --
901: elsif p_ptnl_ler_for_per_stat_cd = 'UNPROCD' and
902: p_unprocd_dt is null then
903: --

Line 904: fnd_message.set_name('BEN','BEN_92331_UNPROCD_DATE_NULL');

900: --
901: elsif p_ptnl_ler_for_per_stat_cd = 'UNPROCD' and
902: p_unprocd_dt is null then
903: --
904: fnd_message.set_name('BEN','BEN_92331_UNPROCD_DATE_NULL');
905: fnd_message.raise_error;
906: --
907: elsif p_ptnl_ler_for_per_stat_cd = 'DTCTD' and
908: p_dtctd_dt is null then

Line 905: fnd_message.raise_error;

901: elsif p_ptnl_ler_for_per_stat_cd = 'UNPROCD' and
902: p_unprocd_dt is null then
903: --
904: fnd_message.set_name('BEN','BEN_92331_UNPROCD_DATE_NULL');
905: fnd_message.raise_error;
906: --
907: elsif p_ptnl_ler_for_per_stat_cd = 'DTCTD' and
908: p_dtctd_dt is null then
909: --

Line 910: fnd_message.set_name('BEN','BEN_92332_DTCTD_DATE_NULL');

906: --
907: elsif p_ptnl_ler_for_per_stat_cd = 'DTCTD' and
908: p_dtctd_dt is null then
909: --
910: fnd_message.set_name('BEN','BEN_92332_DTCTD_DATE_NULL');
911: fnd_message.raise_error;
912: --
913: elsif p_ptnl_ler_for_per_stat_cd = 'MNL' and
914: p_mnl_dt is null then

Line 911: fnd_message.raise_error;

907: elsif p_ptnl_ler_for_per_stat_cd = 'DTCTD' and
908: p_dtctd_dt is null then
909: --
910: fnd_message.set_name('BEN','BEN_92332_DTCTD_DATE_NULL');
911: fnd_message.raise_error;
912: --
913: elsif p_ptnl_ler_for_per_stat_cd = 'MNL' and
914: p_mnl_dt is null then
915: --

Line 916: fnd_message.set_name('BEN','BEN_92333_MNL_DATE_NULL');

912: --
913: elsif p_ptnl_ler_for_per_stat_cd = 'MNL' and
914: p_mnl_dt is null then
915: --
916: fnd_message.set_name('BEN','BEN_92333_MNL_DATE_NULL');
917: fnd_message.raise_error;
918: --
919: elsif p_ptnl_ler_for_per_stat_cd = 'MNLO' and
920: p_mnlo_dt is null then

Line 917: fnd_message.raise_error;

913: elsif p_ptnl_ler_for_per_stat_cd = 'MNL' and
914: p_mnl_dt is null then
915: --
916: fnd_message.set_name('BEN','BEN_92333_MNL_DATE_NULL');
917: fnd_message.raise_error;
918: --
919: elsif p_ptnl_ler_for_per_stat_cd = 'MNLO' and
920: p_mnlo_dt is null then
921: --

Line 922: fnd_message.set_name('BEN','BEN_92334_MNLO_DATE_NULL');

918: --
919: elsif p_ptnl_ler_for_per_stat_cd = 'MNLO' and
920: p_mnlo_dt is null then
921: --
922: fnd_message.set_name('BEN','BEN_92334_MNLO_DATE_NULL');
923: fnd_message.raise_error;
924: --
925: end if;
926: --

Line 923: fnd_message.raise_error;

919: elsif p_ptnl_ler_for_per_stat_cd = 'MNLO' and
920: p_mnlo_dt is null then
921: --
922: fnd_message.set_name('BEN','BEN_92334_MNLO_DATE_NULL');
923: fnd_message.raise_error;
924: --
925: end if;
926: --
927: hr_utility.set_location('Leaving:'||l_proc,10);