380: fetch c1 into p_rec;
381: if c1%notfound then
382: --
383: close c1;
384: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
381: if c1%notfound then
382: --
383: close c1;
384: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
382: --
383: close c1;
384: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
383: close c1;
384: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
384: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
385: fnd_message.set_token('PROC',l_proc);
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
386: fnd_message.set_token('PGM',null);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
387: fnd_message.set_token('PLN',p_pl_id);
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
395: fnd_message.raise_error;
388: fnd_message.set_token('OIPL',null);
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
395: fnd_message.raise_error;
396: --
389: fnd_message.set_token('PLIP',null);
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
395: fnd_message.raise_error;
396: --
397: end if;
390: fnd_message.set_token('PTIP',null);
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
395: fnd_message.raise_error;
396: --
397: end if;
398: --
391: fnd_message.set_token('OPT',null);
392: fnd_message.set_token('OIPLIP',null);
393: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
394: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
395: fnd_message.raise_error;
396: --
397: end if;
398: --
399: close c1;
437: fetch c1 into p_rec;
438: if c1%notfound then
439: --
440: close c1;
441: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
438: if c1%notfound then
439: --
440: close c1;
441: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
439: --
440: close c1;
441: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
440: close c1;
441: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
441: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
442: fnd_message.set_token('PROC',l_proc);
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
443: fnd_message.set_token('PGM',p_pgm_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
444: fnd_message.set_token('PLN',null);
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
452: fnd_message.raise_error;
445: fnd_message.set_token('OIPL',null);
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
452: fnd_message.raise_error;
453: --
446: fnd_message.set_token('PLIP',null);
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
452: fnd_message.raise_error;
453: --
454: end if;
447: fnd_message.set_token('PTIP',null);
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
452: fnd_message.raise_error;
453: --
454: end if;
455: --
448: fnd_message.set_token('OPT',null);
449: fnd_message.set_token('OIPLIP',null);
450: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
451: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
452: fnd_message.raise_error;
453: --
454: end if;
455: --
456: close c1;
494: fetch c1 into p_rec;
495: if c1%notfound then
496: --
497: close c1;
498: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
495: if c1%notfound then
496: --
497: close c1;
498: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
496: --
497: close c1;
498: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
497: close c1;
498: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
498: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
499: fnd_message.set_token('PROC',l_proc);
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
500: fnd_message.set_token('PGM',null);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
501: fnd_message.set_token('PLN',null);
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
509: fnd_message.raise_error;
502: fnd_message.set_token('OIPL',p_oipl_id);
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
509: fnd_message.raise_error;
510: --
503: fnd_message.set_token('PLIP',null);
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
509: fnd_message.raise_error;
510: --
511: end if;
504: fnd_message.set_token('PTIP',null);
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
509: fnd_message.raise_error;
510: --
511: end if;
512: --
505: fnd_message.set_token('OPT',null);
506: fnd_message.set_token('OIPLIP',null);
507: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
508: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
509: fnd_message.raise_error;
510: --
511: end if;
512: --
513: close c1;
551: fetch c1 into p_rec;
552: if c1%notfound then
553: --
554: close c1;
555: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
552: if c1%notfound then
553: --
554: close c1;
555: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
553: --
554: close c1;
555: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
554: close c1;
555: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
555: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
556: fnd_message.set_token('PROC',l_proc);
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
557: fnd_message.set_token('PGM',null);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
558: fnd_message.set_token('PLN',null);
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
566: fnd_message.raise_error;
559: fnd_message.set_token('OIPL',null);
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
566: fnd_message.raise_error;
567: --
560: fnd_message.set_token('PLIP',p_plip_id);
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
566: fnd_message.raise_error;
567: --
568: end if;
561: fnd_message.set_token('PTIP',null);
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
566: fnd_message.raise_error;
567: --
568: end if;
569: --
562: fnd_message.set_token('OPT',null);
563: fnd_message.set_token('OIPLIP',null);
564: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
565: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
566: fnd_message.raise_error;
567: --
568: end if;
569: --
570: close c1;
608: fetch c1 into p_rec;
609: if c1%notfound then
610: --
611: close c1;
612: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
609: if c1%notfound then
610: --
611: close c1;
612: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
610: --
611: close c1;
612: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
611: close c1;
612: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
612: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
613: fnd_message.set_token('PROC',l_proc);
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
614: fnd_message.set_token('PGM',null);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
615: fnd_message.set_token('PLN',null);
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
623: fnd_message.raise_error;
616: fnd_message.set_token('OIPL',null);
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
623: fnd_message.raise_error;
624: --
617: fnd_message.set_token('PLIP',null);
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
623: fnd_message.raise_error;
624: --
625: end if;
618: fnd_message.set_token('PTIP',p_ptip_id);
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
623: fnd_message.raise_error;
624: --
625: end if;
626: --
619: fnd_message.set_token('OPT',null);
620: fnd_message.set_token('OIPLIP',null);
621: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
622: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
623: fnd_message.raise_error;
624: --
625: end if;
626: --
627: close c1;
663: fetch c1 into p_rec;
664: if c1%notfound then
665: --
666: close c1;
667: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
664: if c1%notfound then
665: --
666: close c1;
667: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
665: --
666: close c1;
667: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
666: close c1;
667: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
667: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
668: fnd_message.set_token('PROC',l_proc);
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
669: fnd_message.set_token('PGM',null);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
670: fnd_message.set_token('PLN',null);
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
678: fnd_message.raise_error;
671: fnd_message.set_token('OIPL',null);
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
678: fnd_message.raise_error;
679: --
672: fnd_message.set_token('PLIP',null);
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
678: fnd_message.raise_error;
679: --
680: end if;
673: fnd_message.set_token('PTIP',null);
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
678: fnd_message.raise_error;
679: --
680: end if;
681: --
674: fnd_message.set_token('OPT',p_opt_id);
675: fnd_message.set_token('OIPLIP',null);
676: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
677: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
678: fnd_message.raise_error;
679: --
680: end if;
681: --
682: close c1;
716: fetch c1 into p_rec;
717: if c1%notfound then
718: --
719: close c1;
720: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
717: if c1%notfound then
718: --
719: close c1;
720: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
718: --
719: close c1;
720: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
719: close c1;
720: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
720: fnd_message.set_name('BEN','BEN_92204_OBJECT_NOT_FOUND');
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
721: fnd_message.set_token('PROC',l_proc);
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
722: fnd_message.set_token('PGM',null);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
723: fnd_message.set_token('PLN',null);
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
731: fnd_message.raise_error;
724: fnd_message.set_token('OIPL',null);
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
731: fnd_message.raise_error;
732: --
725: fnd_message.set_token('PLIP',null);
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
731: fnd_message.raise_error;
732: --
733: end if;
726: fnd_message.set_token('PTIP',null);
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
731: fnd_message.raise_error;
732: --
733: end if;
734: --
727: fnd_message.set_token('OPT',null);
728: fnd_message.set_token('OIPLIP',p_oiplip_id);
729: fnd_message.set_token('EFFECTIVE_DATE',to_char(p_effective_date));
730: fnd_message.set_token('BUSINESS_GROUP',p_business_group_id);
731: fnd_message.raise_error;
732: --
733: end if;
734: --
735: close c1;