472: ,l_pl_id
473: ,l_pl_typ_id;
474: if c_prtt_enrt_rslt%notfound then
475: close c_prtt_enrt_rslt;
476: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
477: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
478: fnd_message.raise_error;
479: end if;
480: close c_prtt_enrt_rslt;
473: ,l_pl_typ_id;
474: if c_prtt_enrt_rslt%notfound then
475: close c_prtt_enrt_rslt;
476: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
477: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
478: fnd_message.raise_error;
479: end if;
480: close c_prtt_enrt_rslt;
481: --
474: if c_prtt_enrt_rslt%notfound then
475: close c_prtt_enrt_rslt;
476: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
477: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
478: fnd_message.raise_error;
479: end if;
480: close c_prtt_enrt_rslt;
481: --
482: -- Generate Communications
643: ,l_pl_typ_id
644: ,l_per_in_ler_id;
645: if c_prtt_enrt_rslt%notfound then
646: close c_prtt_enrt_rslt;
647: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
648: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
649: fnd_message.raise_error;
650: end if;
651: close c_prtt_enrt_rslt;
644: ,l_per_in_ler_id;
645: if c_prtt_enrt_rslt%notfound then
646: close c_prtt_enrt_rslt;
647: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
648: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
649: fnd_message.raise_error;
650: end if;
651: close c_prtt_enrt_rslt;
652: --
645: if c_prtt_enrt_rslt%notfound then
646: close c_prtt_enrt_rslt;
647: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
648: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
649: fnd_message.raise_error;
650: end if;
651: close c_prtt_enrt_rslt;
652: --
653: -- Start of API User Hook for the before hook of create_PRTT_ENRT_ACTN
1292: ,l_pl_id
1293: ,l_pl_typ_id;
1294: if c_prtt_enrt_rslt%notfound then
1295: close c_prtt_enrt_rslt;
1296: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1297: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1298: fnd_message.raise_error;
1299: end if;
1300: close c_prtt_enrt_rslt;
1293: ,l_pl_typ_id;
1294: if c_prtt_enrt_rslt%notfound then
1295: close c_prtt_enrt_rslt;
1296: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1297: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1298: fnd_message.raise_error;
1299: end if;
1300: close c_prtt_enrt_rslt;
1301: --
1294: if c_prtt_enrt_rslt%notfound then
1295: close c_prtt_enrt_rslt;
1296: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1297: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1298: fnd_message.raise_error;
1299: end if;
1300: close c_prtt_enrt_rslt;
1301: --
1302: -- Generate Communications
1497: ,l_pl_typ_id
1498: ,l_per_in_ler_id;
1499: if c_prtt_enrt_rslt%notfound then
1500: close c_prtt_enrt_rslt;
1501: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1502: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1503: fnd_message.raise_error;
1504: end if;
1505: close c_prtt_enrt_rslt;
1498: ,l_per_in_ler_id;
1499: if c_prtt_enrt_rslt%notfound then
1500: close c_prtt_enrt_rslt;
1501: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1502: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1503: fnd_message.raise_error;
1504: end if;
1505: close c_prtt_enrt_rslt;
1506: --
1499: if c_prtt_enrt_rslt%notfound then
1500: close c_prtt_enrt_rslt;
1501: fnd_message.set_name('BEN','BEN_91916_ENRT_TABLE_NOT_FOUND');
1502: fnd_message.set_token('TABLE','BEN_PRTT_ENRT_RSLT_F');
1503: fnd_message.raise_error;
1504: end if;
1505: close c_prtt_enrt_rslt;
1506: --
1507: -- Start of API User Hook for the before hook of update_PRTT_ENRT_ACTN