282: --
283: FETCH c1 INTO l_temp;
284: IF c1%FOUND THEN
285: CLOSE c1;
286: fnd_message.set_name (
287: 'BEN',
288: 'BEN_94121_DT_CHILD_EXISTS'
289: );
290: fnd_message.set_token (
286: fnd_message.set_name (
287: 'BEN',
288: 'BEN_94121_DT_CHILD_EXISTS'
289: );
290: fnd_message.set_token (
291: 'TABLE_NAME',
292: 'BEN_BATCH_ACTN_ITEM_INFO'
293: );
294: fnd_message.raise_error;
290: fnd_message.set_token (
291: 'TABLE_NAME',
292: 'BEN_BATCH_ACTN_ITEM_INFO'
293: );
294: fnd_message.raise_error;
295: END IF;
296:
297: --
298: CLOSE c1;
307: --
308: FETCH c2 INTO l_temp;
309: IF c2%FOUND THEN
310: CLOSE c2;
311: fnd_message.set_name (
312: 'BEN',
313: 'BEN_94121_DT_CHILD_EXISTS'
314: );
315: fnd_message.set_token (
311: fnd_message.set_name (
312: 'BEN',
313: 'BEN_94121_DT_CHILD_EXISTS'
314: );
315: fnd_message.set_token (
316: 'TABLE_NAME',
317: 'BEN_BATCH_BNFT_CERT_INFO'
318: );
319: fnd_message.raise_error;
315: fnd_message.set_token (
316: 'TABLE_NAME',
317: 'BEN_BATCH_BNFT_CERT_INFO'
318: );
319: fnd_message.raise_error;
320: END IF;
321:
322: --
323: CLOSE c2;
332: --
333: FETCH c20 INTO l_temp;
334: IF c20%FOUND THEN
335: CLOSE c20;
336: fnd_message.set_name (
337: 'BEN',
338: 'BEN_94121_DT_CHILD_EXISTS'
339: );
340: fnd_message.set_token (
336: fnd_message.set_name (
337: 'BEN',
338: 'BEN_94121_DT_CHILD_EXISTS'
339: );
340: fnd_message.set_token (
341: 'TABLE_NAME',
342: 'BEN_BATCH_COMMU_INFO'
343: );
344: fnd_message.raise_error;
340: fnd_message.set_token (
341: 'TABLE_NAME',
342: 'BEN_BATCH_COMMU_INFO'
343: );
344: fnd_message.raise_error;
345: END IF;
346:
347: --
348: CLOSE c20;
357: --
358: FETCH c21 INTO l_temp;
359: IF c21%FOUND THEN
360: CLOSE c21;
361: fnd_message.set_name (
362: 'BEN',
363: 'BEN_94121_DT_CHILD_EXISTS'
364: );
365: fnd_message.set_token (
361: fnd_message.set_name (
362: 'BEN',
363: 'BEN_94121_DT_CHILD_EXISTS'
364: );
365: fnd_message.set_token (
366: 'TABLE_NAME',
367: 'BEN_BATCH_DPNT_INFO'
368: );
369: fnd_message.raise_error;
365: fnd_message.set_token (
366: 'TABLE_NAME',
367: 'BEN_BATCH_DPNT_INFO'
368: );
369: fnd_message.raise_error;
370: END IF;
371:
372: --
373: CLOSE c21;
382: --
383: FETCH c22 INTO l_temp;
384: IF c22%FOUND THEN
385: CLOSE c22;
386: fnd_message.set_name (
387: 'BEN',
388: 'BEN_94121_DT_CHILD_EXISTS'
389: );
390: fnd_message.set_token (
386: fnd_message.set_name (
387: 'BEN',
388: 'BEN_94121_DT_CHILD_EXISTS'
389: );
390: fnd_message.set_token (
391: 'TABLE_NAME',
392: 'BEN_BATCH_ELCTBL_CHC_INFO'
393: );
394: fnd_message.raise_error;
390: fnd_message.set_token (
391: 'TABLE_NAME',
392: 'BEN_BATCH_ELCTBL_CHC_INFO'
393: );
394: fnd_message.raise_error;
395: END IF;
396:
397: --
398: CLOSE c22;
407: --
408: FETCH c23 INTO l_temp;
409: IF c23%FOUND THEN
410: CLOSE c23;
411: fnd_message.set_name (
412: 'BEN',
413: 'BEN_94121_DT_CHILD_EXISTS'
414: );
415: fnd_message.set_token (
411: fnd_message.set_name (
412: 'BEN',
413: 'BEN_94121_DT_CHILD_EXISTS'
414: );
415: fnd_message.set_token (
416: 'TABLE_NAME',
417: 'BEN_BATCH_ELIG_INFO'
418: );
419: fnd_message.raise_error;
415: fnd_message.set_token (
416: 'TABLE_NAME',
417: 'BEN_BATCH_ELIG_INFO'
418: );
419: fnd_message.raise_error;
420: END IF;
421:
422: --
423: CLOSE c23;
432: --
433: FETCH c24 INTO l_temp;
434: IF c24%FOUND THEN
435: CLOSE c24;
436: fnd_message.set_name (
437: 'BEN',
438: 'BEN_94121_DT_CHILD_EXISTS'
439: );
440: fnd_message.set_token (
436: fnd_message.set_name (
437: 'BEN',
438: 'BEN_94121_DT_CHILD_EXISTS'
439: );
440: fnd_message.set_token (
441: 'TABLE_NAME',
442: 'BEN_BATCH_LER_INFO'
443: );
444: fnd_message.raise_error;
440: fnd_message.set_token (
441: 'TABLE_NAME',
442: 'BEN_BATCH_LER_INFO'
443: );
444: fnd_message.raise_error;
445: END IF;
446:
447: --
448: CLOSE c24;
457: --
458: FETCH c25 INTO l_temp;
459: IF c25%FOUND THEN
460: CLOSE c25;
461: fnd_message.set_name (
462: 'BEN',
463: 'BEN_94121_DT_CHILD_EXISTS'
464: );
465: fnd_message.set_token (
461: fnd_message.set_name (
462: 'BEN',
463: 'BEN_94121_DT_CHILD_EXISTS'
464: );
465: fnd_message.set_token (
466: 'TABLE_NAME',
467: 'BEN_BATCH_RATE_INFO'
468: );
469: fnd_message.raise_error;
465: fnd_message.set_token (
466: 'TABLE_NAME',
467: 'BEN_BATCH_RATE_INFO'
468: );
469: fnd_message.raise_error;
470: END IF;
471:
472: --
473: CLOSE c25;
482: --
483: FETCH c26 INTO l_temp;
484: IF c26%FOUND THEN
485: CLOSE c26;
486: fnd_message.set_name (
487: 'BEN',
488: 'BEN_94121_DT_CHILD_EXISTS'
489: );
490: fnd_message.set_token (
486: fnd_message.set_name (
487: 'BEN',
488: 'BEN_94121_DT_CHILD_EXISTS'
489: );
490: fnd_message.set_token (
491: 'TABLE_NAME',
492: 'BEN_BENEFIT_ACTIONS'
493: );
494: fnd_message.raise_error;
490: fnd_message.set_token (
491: 'TABLE_NAME',
492: 'BEN_BENEFIT_ACTIONS'
493: );
494: fnd_message.raise_error;
495: END IF;
496:
497: --
498: CLOSE c26;
507: --
508: FETCH c15 INTO l_temp;
509: IF c15%FOUND THEN
510: CLOSE c15;
511: fnd_message.set_name (
512: 'BEN',
513: 'BEN_94121_DT_CHILD_EXISTS'
514: );
515: fnd_message.set_token (
511: fnd_message.set_name (
512: 'BEN',
513: 'BEN_94121_DT_CHILD_EXISTS'
514: );
515: fnd_message.set_token (
516: 'TABLE_NAME',
517: 'BEN_CRT_ORDR'
518: );
519: fnd_message.raise_error;
515: fnd_message.set_token (
516: 'TABLE_NAME',
517: 'BEN_CRT_ORDR'
518: );
519: fnd_message.raise_error;
520: END IF;
521:
522: --
523: CLOSE c15;
532: --
533: FETCH c16 INTO l_temp;
534: IF c16%FOUND THEN
535: CLOSE c16;
536: fnd_message.set_name (
537: 'BEN',
538: 'BEN_94121_DT_CHILD_EXISTS'
539: );
540: fnd_message.set_token (
536: fnd_message.set_name (
537: 'BEN',
538: 'BEN_94121_DT_CHILD_EXISTS'
539: );
540: fnd_message.set_token (
541: 'TABLE_NAME',
542: 'BEN_CRT_ORDR_CVRD_PER'
543: );
544: fnd_message.raise_error;
540: fnd_message.set_token (
541: 'TABLE_NAME',
542: 'BEN_CRT_ORDR_CVRD_PER'
543: );
544: fnd_message.raise_error;
545: END IF;
546:
547: --
548: CLOSE c16;
557: --
558: FETCH c17 INTO l_temp;
559: IF c17%FOUND THEN
560: CLOSE c17;
561: fnd_message.set_name (
562: 'BEN',
563: 'BEN_94121_DT_CHILD_EXISTS'
564: );
565: fnd_message.set_token (
561: fnd_message.set_name (
562: 'BEN',
563: 'BEN_94121_DT_CHILD_EXISTS'
564: );
565: fnd_message.set_token (
566: 'TABLE_NAME',
567: 'BEN_ELIG_PER_F'
568: );
569: fnd_message.raise_error;
565: fnd_message.set_token (
566: 'TABLE_NAME',
567: 'BEN_ELIG_PER_F'
568: );
569: fnd_message.raise_error;
570: END IF;
571:
572: --
573: CLOSE c17;
582: --
583: FETCH c3 INTO l_temp;
584: IF c3%FOUND THEN
585: CLOSE c3;
586: fnd_message.set_name (
587: 'BEN',
588: 'BEN_94121_DT_CHILD_EXISTS'
589: );
590: fnd_message.set_token (
586: fnd_message.set_name (
587: 'BEN',
588: 'BEN_94121_DT_CHILD_EXISTS'
589: );
590: fnd_message.set_token (
591: 'TABLE_NAME',
592: 'BEN_EXT_CHG_EVT_LOG'
593: );
594: fnd_message.raise_error;
590: fnd_message.set_token (
591: 'TABLE_NAME',
592: 'BEN_EXT_CHG_EVT_LOG'
593: );
594: fnd_message.raise_error;
595: END IF;
596:
597: --
598: CLOSE c3;
607: --
608: FETCH c6 INTO l_temp;
609: IF c6%FOUND THEN
610: CLOSE c6;
611: fnd_message.set_name (
612: 'BEN',
613: 'BEN_94121_DT_CHILD_EXISTS'
614: );
615: fnd_message.set_token (
611: fnd_message.set_name (
612: 'BEN',
613: 'BEN_94121_DT_CHILD_EXISTS'
614: );
615: fnd_message.set_token (
616: 'TABLE_NAME',
617: 'BEN_EXT_RSLT_DTL'
618: );
619: fnd_message.raise_error;
615: fnd_message.set_token (
616: 'TABLE_NAME',
617: 'BEN_EXT_RSLT_DTL'
618: );
619: fnd_message.raise_error;
620: END IF;
621:
622: --
623: CLOSE c6;
632: --
633: FETCH c7 INTO l_temp;
634: IF c7%FOUND THEN
635: CLOSE c7;
636: fnd_message.set_name (
637: 'BEN',
638: 'BEN_94121_DT_CHILD_EXISTS'
639: );
640: fnd_message.set_token (
636: fnd_message.set_name (
637: 'BEN',
638: 'BEN_94121_DT_CHILD_EXISTS'
639: );
640: fnd_message.set_token (
641: 'TABLE_NAME',
642: 'BEN_EXT_RSLT_ERR'
643: );
644: fnd_message.raise_error;
640: fnd_message.set_token (
641: 'TABLE_NAME',
642: 'BEN_EXT_RSLT_ERR'
643: );
644: fnd_message.raise_error;
645: END IF;
646:
647: --
648: CLOSE c7;
657: --
658: FETCH c11 INTO l_temp;
659: IF c11%FOUND THEN
660: CLOSE c11;
661: fnd_message.set_name (
662: 'BEN',
663: 'BEN_94121_DT_CHILD_EXISTS'
664: );
665: fnd_message.set_token (
661: fnd_message.set_name (
662: 'BEN',
663: 'BEN_94121_DT_CHILD_EXISTS'
664: );
665: fnd_message.set_token (
666: 'TABLE_NAME',
667: 'BEN_LE_CLSN_N_RSTR'
668: );
669: fnd_message.raise_error;
665: fnd_message.set_token (
666: 'TABLE_NAME',
667: 'BEN_LE_CLSN_N_RSTR'
668: );
669: fnd_message.raise_error;
670: END IF;
671:
672: --
673: CLOSE c11;
682: --
683: FETCH c27 INTO l_temp;
684: IF c27%FOUND THEN
685: CLOSE c27;
686: fnd_message.set_name (
687: 'BEN',
688: 'BEN_94121_DT_CHILD_EXISTS'
689: );
690: fnd_message.set_token (
686: fnd_message.set_name (
687: 'BEN',
688: 'BEN_94121_DT_CHILD_EXISTS'
689: );
690: fnd_message.set_token (
691: 'TABLE_NAME',
692: 'BEN_PERSON_ACTIONS'
693: );
694: fnd_message.raise_error;
690: fnd_message.set_token (
691: 'TABLE_NAME',
692: 'BEN_PERSON_ACTIONS'
693: );
694: fnd_message.raise_error;
695: END IF;
696:
697: --
698: CLOSE c27;
707: --
708: FETCH c4 INTO l_temp;
709: IF c4%FOUND THEN
710: CLOSE c4;
711: fnd_message.set_name (
712: 'BEN',
713: 'BEN_94121_DT_CHILD_EXISTS'
714: );
715: fnd_message.set_token (
711: fnd_message.set_name (
712: 'BEN',
713: 'BEN_94121_DT_CHILD_EXISTS'
714: );
715: fnd_message.set_token (
716: 'TABLE_NAME',
717: 'BEN_PER_BNFTS_BAL_F'
718: );
719: fnd_message.raise_error;
715: fnd_message.set_token (
716: 'TABLE_NAME',
717: 'BEN_PER_BNFTS_BAL_F'
718: );
719: fnd_message.raise_error;
720: END IF;
721:
722: --
723: CLOSE c4;
732: --
733: FETCH c19 INTO l_temp;
734: IF c19%FOUND THEN
735: CLOSE c19;
736: fnd_message.set_name (
737: 'BEN',
738: 'BEN_94121_DT_CHILD_EXISTS'
739: );
740: fnd_message.set_token (
736: fnd_message.set_name (
737: 'BEN',
738: 'BEN_94121_DT_CHILD_EXISTS'
739: );
740: fnd_message.set_token (
741: 'TABLE_NAME',
742: 'BEN_PER_CM_F'
743: );
744: fnd_message.raise_error;
740: fnd_message.set_token (
741: 'TABLE_NAME',
742: 'BEN_PER_CM_F'
743: );
744: fnd_message.raise_error;
745: END IF;
746:
747: --
748: CLOSE c19;
757: --
758: FETCH c8 INTO l_temp;
759: IF c8%FOUND THEN
760: CLOSE c8;
761: fnd_message.set_name (
762: 'BEN',
763: 'BEN_94121_DT_CHILD_EXISTS'
764: );
765: fnd_message.set_token (
761: fnd_message.set_name (
762: 'BEN',
763: 'BEN_94121_DT_CHILD_EXISTS'
764: );
765: fnd_message.set_token (
766: 'TABLE_NAME',
767: 'BEN_PER_DLVRY_MTHD_F'
768: );
769: fnd_message.raise_error;
765: fnd_message.set_token (
766: 'TABLE_NAME',
767: 'BEN_PER_DLVRY_MTHD_F'
768: );
769: fnd_message.raise_error;
770: END IF;
771:
772: --
773: CLOSE c8;
782: --
783: FETCH c12 INTO l_temp;
784: IF c12%FOUND THEN
785: CLOSE c12;
786: fnd_message.set_name (
787: 'BEN',
788: 'BEN_94121_DT_CHILD_EXISTS'
789: );
790: fnd_message.set_token (
786: fnd_message.set_name (
787: 'BEN',
788: 'BEN_94121_DT_CHILD_EXISTS'
789: );
790: fnd_message.set_token (
791: 'TABLE_NAME',
792: 'BEN_PER_IN_LER'
793: );
794: fnd_message.raise_error;
790: fnd_message.set_token (
791: 'TABLE_NAME',
792: 'BEN_PER_IN_LER'
793: );
794: fnd_message.raise_error;
795: END IF;
796:
797: --
798: CLOSE c12;
807: --
808: FETCH c9 INTO l_temp;
809: IF c9%FOUND THEN
810: CLOSE c9;
811: fnd_message.set_name (
812: 'BEN',
813: 'BEN_94121_DT_CHILD_EXISTS'
814: );
815: fnd_message.set_token (
811: fnd_message.set_name (
812: 'BEN',
813: 'BEN_94121_DT_CHILD_EXISTS'
814: );
815: fnd_message.set_token (
816: 'TABLE_NAME',
817: 'BEN_PER_IN_LGL_ENTY_F'
818: );
819: fnd_message.raise_error;
815: fnd_message.set_token (
816: 'TABLE_NAME',
817: 'BEN_PER_IN_LGL_ENTY_F'
818: );
819: fnd_message.raise_error;
820: END IF;
821:
822: --
823: CLOSE c9;
832: --
833: FETCH c10 INTO l_temp;
834: IF c10%FOUND THEN
835: CLOSE c10;
836: fnd_message.set_name (
837: 'BEN',
838: 'BEN_94121_DT_CHILD_EXISTS'
839: );
840: fnd_message.set_token (
836: fnd_message.set_name (
837: 'BEN',
838: 'BEN_94121_DT_CHILD_EXISTS'
839: );
840: fnd_message.set_token (
841: 'TABLE_NAME',
842: 'BEN_PER_IN_ORG_UNIT_F'
843: );
844: fnd_message.raise_error;
840: fnd_message.set_token (
841: 'TABLE_NAME',
842: 'BEN_PER_IN_ORG_UNIT_F'
843: );
844: fnd_message.raise_error;
845: END IF;
846:
847: --
848: CLOSE c10;
857: --
858: FETCH c5 INTO l_temp;
859: IF c5%FOUND THEN
860: CLOSE c5;
861: fnd_message.set_name (
862: 'BEN',
863: 'BEN_94121_DT_CHILD_EXISTS'
864: );
865: fnd_message.set_token (
861: fnd_message.set_name (
862: 'BEN',
863: 'BEN_94121_DT_CHILD_EXISTS'
864: );
865: fnd_message.set_token (
866: 'TABLE_NAME',
867: 'BEN_PER_PIN_F'
868: );
869: fnd_message.raise_error;
865: fnd_message.set_token (
866: 'TABLE_NAME',
867: 'BEN_PER_PIN_F'
868: );
869: fnd_message.raise_error;
870: END IF;
871:
872: --
873: CLOSE c5;
882: --
883: FETCH c14 INTO l_temp;
884: IF c14%FOUND THEN
885: CLOSE c14;
886: fnd_message.set_name (
887: 'BEN',
888: 'BEN_94121_DT_CHILD_EXISTS'
889: );
890: fnd_message.set_token (
886: fnd_message.set_name (
887: 'BEN',
888: 'BEN_94121_DT_CHILD_EXISTS'
889: );
890: fnd_message.set_token (
891: 'TABLE_NAME',
892: 'BEN_POPL_ORG_F'
893: );
894: fnd_message.raise_error;
890: fnd_message.set_token (
891: 'TABLE_NAME',
892: 'BEN_POPL_ORG_F'
893: );
894: fnd_message.raise_error;
895: END IF;
896:
897: --
898: CLOSE c14;
907: --
908: FETCH c18 INTO l_temp;
909: IF c18%FOUND THEN
910: CLOSE c18;
911: fnd_message.set_name (
912: 'BEN',
913: 'BEN_94121_DT_CHILD_EXISTS'
914: );
915: fnd_message.set_token (
911: fnd_message.set_name (
912: 'BEN',
913: 'BEN_94121_DT_CHILD_EXISTS'
914: );
915: fnd_message.set_token (
916: 'TABLE_NAME',
917: 'BEN_PRTT_ENRT_RSLT_F'
918: );
919: fnd_message.raise_error;
915: fnd_message.set_token (
916: 'TABLE_NAME',
917: 'BEN_PRTT_ENRT_RSLT_F'
918: );
919: fnd_message.raise_error;
920: END IF;
921:
922: --
923: CLOSE c18;
932: --
933: FETCH c13 INTO l_temp;
934: IF c13%FOUND THEN
935: CLOSE c13;
936: fnd_message.set_name (
937: 'BEN',
938: 'BEN_94121_DT_CHILD_EXISTS'
939: );
940: fnd_message.set_token (
936: fnd_message.set_name (
937: 'BEN',
938: 'BEN_94121_DT_CHILD_EXISTS'
939: );
940: fnd_message.set_token (
941: 'TABLE_NAME',
942: 'BEN_PTNL_LER_FOR_PER'
943: );
944: fnd_message.raise_error;
940: fnd_message.set_token (
941: 'TABLE_NAME',
942: 'BEN_PTNL_LER_FOR_PER'
943: );
944: fnd_message.raise_error;
945: END IF;
946:
947: --
948: CLOSE c13;
957: --
958: FETCH c28 INTO l_temp;
959: IF c28%FOUND THEN
960: CLOSE c28;
961: fnd_message.set_name (
962: 'BEN',
963: 'BEN_94121_DT_CHILD_EXISTS'
964: );
965: fnd_message.set_token (
961: fnd_message.set_name (
962: 'BEN',
963: 'BEN_94121_DT_CHILD_EXISTS'
964: );
965: fnd_message.set_token (
966: 'TABLE_NAME',
967: 'BEN_REPORTING'
968: );
969: fnd_message.raise_error;
965: fnd_message.set_token (
966: 'TABLE_NAME',
967: 'BEN_REPORTING'
968: );
969: fnd_message.raise_error;
970: END IF;
971:
972: --
973: CLOSE c28;
981: --
982: FETCH c29 INTO l_temp;
983: IF c29%FOUND THEN
984: CLOSE c29;
985: fnd_message.set_name (
986: 'BEN',
987: 'BEN_94121_DT_CHILD_EXISTS'
988: );
989: fnd_message.set_token (
985: fnd_message.set_name (
986: 'BEN',
987: 'BEN_94121_DT_CHILD_EXISTS'
988: );
989: fnd_message.set_token (
990: 'TABLE_NAME',
991: 'BEN_ELIG_CVRD_DPNT_F'
992: );
993: fnd_message.raise_error;
989: fnd_message.set_token (
990: 'TABLE_NAME',
991: 'BEN_ELIG_CVRD_DPNT_F'
992: );
993: fnd_message.raise_error;
994: END IF;
995:
996: --
997: CLOSE c29;
1005: --
1006: FETCH c30 INTO l_temp;
1007: IF c30%FOUND THEN
1008: CLOSE c30;
1009: fnd_message.set_name (
1010: 'BEN',
1011: 'BEN_94121_DT_CHILD_EXISTS'
1012: );
1013: fnd_message.set_token (
1009: fnd_message.set_name (
1010: 'BEN',
1011: 'BEN_94121_DT_CHILD_EXISTS'
1012: );
1013: fnd_message.set_token (
1014: 'TABLE_NAME',
1015: 'BEN_PRTT_REIBMT_RQST_F'
1016: );
1017: fnd_message.raise_error;
1013: fnd_message.set_token (
1014: 'TABLE_NAME',
1015: 'BEN_PRTT_REIBMT_RQST_F'
1016: );
1017: fnd_message.raise_error;
1018: END IF;
1019:
1020: --
1021: CLOSE c30;
1029: --
1030: FETCH c31 INTO l_temp;
1031: IF c31%FOUND THEN
1032: CLOSE c31;
1033: fnd_message.set_name (
1034: 'BEN',
1035: 'BEN_94121_DT_CHILD_EXISTS'
1036: );
1037: fnd_message.set_token (
1033: fnd_message.set_name (
1034: 'BEN',
1035: 'BEN_94121_DT_CHILD_EXISTS'
1036: );
1037: fnd_message.set_token (
1038: 'TABLE_NAME',
1039: 'BEN_PRTT_REIBMT_RQST_F'
1040: );
1041: fnd_message.raise_error;
1037: fnd_message.set_token (
1038: 'TABLE_NAME',
1039: 'BEN_PRTT_REIBMT_RQST_F'
1040: );
1041: fnd_message.raise_error;
1042: END IF;
1043:
1044: --
1045: CLOSE c31;
1053: --
1054: FETCH c32 INTO l_temp;
1055: IF c32%FOUND THEN
1056: CLOSE c32;
1057: fnd_message.set_name (
1058: 'BEN',
1059: 'BEN_94121_DT_CHILD_EXISTS'
1060: );
1061: fnd_message.set_token (
1057: fnd_message.set_name (
1058: 'BEN',
1059: 'BEN_94121_DT_CHILD_EXISTS'
1060: );
1061: fnd_message.set_token (
1062: 'TABLE_NAME',
1063: 'BEN_PRTT_REIBMT_RQST_F'
1064: );
1065: fnd_message.raise_error;
1061: fnd_message.set_token (
1062: 'TABLE_NAME',
1063: 'BEN_PRTT_REIBMT_RQST_F'
1064: );
1065: fnd_message.raise_error;
1066: END IF;
1067:
1068: --
1069: CLOSE c32;
1077: --
1078: FETCH c33 INTO l_temp;
1079: IF c33%FOUND THEN
1080: CLOSE c33;
1081: fnd_message.set_name (
1082: 'BEN',
1083: 'BEN_94121_DT_CHILD_EXISTS'
1084: );
1085: fnd_message.set_token (
1081: fnd_message.set_name (
1082: 'BEN',
1083: 'BEN_94121_DT_CHILD_EXISTS'
1084: );
1085: fnd_message.set_token (
1086: 'TABLE_NAME',
1087: 'BEN_PRTT_REIBMT_RQST_F'
1088: );
1089: fnd_message.raise_error;
1085: fnd_message.set_token (
1086: 'TABLE_NAME',
1087: 'BEN_PRTT_REIBMT_RQST_F'
1088: );
1089: fnd_message.raise_error;
1090: END IF;
1091:
1092: --
1093: CLOSE c33;
1101: --
1102: FETCH c34 INTO l_temp;
1103: IF c34%FOUND THEN
1104: CLOSE c34;
1105: fnd_message.set_name (
1106: 'BEN',
1107: 'BEN_94121_DT_CHILD_EXISTS'
1108: );
1109: fnd_message.set_token (
1105: fnd_message.set_name (
1106: 'BEN',
1107: 'BEN_94121_DT_CHILD_EXISTS'
1108: );
1109: fnd_message.set_token (
1110: 'TABLE_NAME',
1111: 'BEN_CBR_QUALD_BNF'
1112: );
1113: fnd_message.raise_error;
1109: fnd_message.set_token (
1110: 'TABLE_NAME',
1111: 'BEN_CBR_QUALD_BNF'
1112: );
1113: fnd_message.raise_error;
1114: END IF;
1115:
1116: --
1117: CLOSE c34;
1123: );
1124: FETCH c35 INTO l_temp;
1125: IF c35%FOUND THEN
1126: CLOSE c35;
1127: fnd_message.set_name (
1128: 'BEN',
1129: 'BEN_93911_DPT_DESIG_BNF'
1130: );
1131: fnd_message.raise_error;
1127: fnd_message.set_name (
1128: 'BEN',
1129: 'BEN_93911_DPT_DESIG_BNF'
1130: );
1131: fnd_message.raise_error;
1132: END IF;
1133: --
1134: CLOSE c35;
1135: -- 3511450 end
3268: if c_pil%found then
3269: --
3270: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3271: close c_pil ;
3272: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3273: fnd_message.set_token('BEN_ITEM','Life Event');
3274: fnd_message.raise_error;
3275: --
3276: end if;
3269: --
3270: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3271: close c_pil ;
3272: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3273: fnd_message.set_token('BEN_ITEM','Life Event');
3274: fnd_message.raise_error;
3275: --
3276: end if;
3277: close c_pil ;
3270: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3271: close c_pil ;
3272: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3273: fnd_message.set_token('BEN_ITEM','Life Event');
3274: fnd_message.raise_error;
3275: --
3276: end if;
3277: close c_pil ;
3278: --check for active enrollment result records
3282: if c_pen%found then
3283: --
3284: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3285: close c_pen ;
3286: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3287: fnd_message.set_token('BEN_ITEM','Enrollment');
3288: fnd_message.raise_error;
3289: --
3290: end if;
3283: --
3284: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3285: close c_pen ;
3286: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3287: fnd_message.set_token('BEN_ITEM','Enrollment');
3288: fnd_message.raise_error;
3289: --
3290: end if;
3291: close c_pen ;
3284: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3285: close c_pen ;
3286: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3287: fnd_message.set_token('BEN_ITEM','Enrollment');
3288: fnd_message.raise_error;
3289: --
3290: end if;
3291: close c_pen ;
3292: --check for active rate records
3296: if c_prv%found then
3297: --
3298: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3299: close c_prv ;
3300: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3301: fnd_message.set_token('BEN_ITEM','Rate');
3302: fnd_message.raise_error;
3303: --
3304: end if;
3297: --
3298: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3299: close c_prv ;
3300: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3301: fnd_message.set_token('BEN_ITEM','Rate');
3302: fnd_message.raise_error;
3303: --
3304: end if;
3305: close c_prv ;
3298: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3299: close c_prv ;
3300: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3301: fnd_message.set_token('BEN_ITEM','Rate');
3302: fnd_message.raise_error;
3303: --
3304: end if;
3305: close c_prv ;
3306: --check for active dependents
3310: if c_ecd%found then
3311: --
3312: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3313: close c_ecd ;
3314: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3315: fnd_message.set_token('BEN_ITEM','Dependents');
3316: fnd_message.raise_error;
3317: --
3318: end if;
3311: --
3312: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3313: close c_ecd ;
3314: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3315: fnd_message.set_token('BEN_ITEM','Dependents');
3316: fnd_message.raise_error;
3317: --
3318: end if;
3319: close c_ecd ;
3312: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3313: close c_ecd ;
3314: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3315: fnd_message.set_token('BEN_ITEM','Dependents');
3316: fnd_message.raise_error;
3317: --
3318: end if;
3319: close c_ecd ;
3320: --
3325: if c_ecdpn%found then
3326: --
3327: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3328: close c_ecdpn ;
3329: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3330: fnd_message.raise_error;
3331: --
3332: end if;
3333: close c_ecdpn ;
3326: --
3327: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3328: close c_ecdpn ;
3329: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3330: fnd_message.raise_error;
3331: --
3332: end if;
3333: close c_ecdpn ;
3334:
3339: if c_plbnf%found then
3340: --
3341: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3342: close c_plbnf ;
3343: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3344: fnd_message.raise_error;
3345: --
3346: end if;
3347: close c_plbnf ;
3340: --
3341: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3342: close c_plbnf ;
3343: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3344: fnd_message.raise_error;
3345: --
3346: end if;
3347: close c_plbnf ;
3348:
3546: fetch c_chk_payroll_run into l_exists;
3547: if(c_chk_payroll_run%found) then
3548: close c_chk_payroll_run;
3549: ben_batch_utils.write(p_text => 'Payroll is run for the employee. Error the process');
3550: fnd_message.raise_error;
3551: else
3552: close c_chk_payroll_run;
3553: ben_batch_utils.write(p_text => ' Deleting Element Entries ');
3554: for l_ele_rec in c_element_entries loop
3580: else
3581: close c_get_pil;
3582: ben_batch_utils.write(p_text => 'No Unrestricted LE exists for the employee. Error the process');
3583: hr_utility.set_location('No Unrestricted LE exists for the employee',80);
3584: fnd_message.raise_error;
3585: end if;
3586:
3587: l_thread_id := 99;
3588: ben_batch_utils.print_parameters
3612: set action_status_cd = 'E'
3613: where person_action_id = l_person_action_id;
3614: commit;
3615: hr_utility.set_location('Unhandled exception',100);
3616: fnd_message.raise_error;
3617: end delete_unrestricted_le_enrts;
3618:
3619: --
3620: END ben_person_delete;