689: CLOSE c_pil;
690:
691: IF l_pil.per_in_ler_stat_cd = 'PROCD'
692: THEN
693: fnd_message.set_name ('BEN', 'BEN_94597_IRC_OFFER_PROCESSED');
694: fnd_message.raise_error;
695: END IF;
696:
697: -- Step 2
690:
691: IF l_pil.per_in_ler_stat_cd = 'PROCD'
692: THEN
693: fnd_message.set_name ('BEN', 'BEN_94597_IRC_OFFER_PROCESSED');
694: fnd_message.raise_error;
695: END IF;
696:
697: -- Step 2
698: OPEN c_latest_ler;
702: THEN
703: IF l_latest_ler.per_in_ler_id <> p_void_per_in_ler_id
704: THEN
705: CLOSE c_latest_ler;
706: fnd_message.set_name ('BEN', 'BEN_92216_NOT_LATST_PER_IN_LER');
707: fnd_message.raise_error;
708: END IF;
709: END IF;
710:
703: IF l_latest_ler.per_in_ler_id <> p_void_per_in_ler_id
704: THEN
705: CLOSE c_latest_ler;
706: fnd_message.set_name ('BEN', 'BEN_92216_NOT_LATST_PER_IN_LER');
707: fnd_message.raise_error;
708: END IF;
709: END IF;
710:
711: CLOSE c_latest_ler;
783: CLOSE c_pil;
784:
785: IF l_pil.per_in_ler_stat_cd = 'PROCD'
786: THEN
787: fnd_message.set_name ('BEN', 'BEN_94597_IRC_OFFER_PROCESSED');
788: fnd_message.raise_error;
789: END IF;
790:
791: -- Step 2
784:
785: IF l_pil.per_in_ler_stat_cd = 'PROCD'
786: THEN
787: fnd_message.set_name ('BEN', 'BEN_94597_IRC_OFFER_PROCESSED');
788: fnd_message.raise_error;
789: END IF;
790:
791: -- Step 2
792: OPEN c_latest_bckdt_ler;
796: THEN
797: IF l_latest_ler.per_in_ler_id <> p_restore_per_in_ler_id
798: THEN
799: CLOSE c_latest_bckdt_ler;
800: fnd_message.set_name ('BEN', 'BEN_94599_NOT_LATST_BCKDT');
801: fnd_message.raise_error;
802: END IF;
803: END IF;
804:
797: IF l_latest_ler.per_in_ler_id <> p_restore_per_in_ler_id
798: THEN
799: CLOSE c_latest_bckdt_ler;
800: fnd_message.set_name ('BEN', 'BEN_94599_NOT_LATST_BCKDT');
801: fnd_message.raise_error;
802: END IF;
803: END IF;
804:
805: CLOSE c_latest_bckdt_ler;
809:
810: IF c_pil_strt%FOUND
811: THEN
812: CLOSE c_pil_strt;
813: fnd_message.set_name ('BEN', 'BEN_94598_ALREADY_ACTIVE');
814: fnd_message.raise_error;
815: END IF;
816:
817: CLOSE c_pil_strt;
810: IF c_pil_strt%FOUND
811: THEN
812: CLOSE c_pil_strt;
813: fnd_message.set_name ('BEN', 'BEN_94598_ALREADY_ACTIVE');
814: fnd_message.raise_error;
815: END IF;
816:
817: CLOSE c_pil_strt;
818: