APPS.BEN_PERSON_DELETE dependencies on FND_MESSAGE

Line 237: fnd_message.set_name (

233: --
234: FETCH c1 INTO l_temp;
235: IF c1%FOUND THEN
236: CLOSE c1;
237: fnd_message.set_name (
238: 'BEN',
239: 'BEN_94121_DT_CHILD_EXISTS'
240: );
241: fnd_message.set_token (

Line 241: fnd_message.set_token (

237: fnd_message.set_name (
238: 'BEN',
239: 'BEN_94121_DT_CHILD_EXISTS'
240: );
241: fnd_message.set_token (
242: 'TABLE_NAME',
243: 'BEN_BATCH_ACTN_ITEM_INFO'
244: );
245: fnd_message.raise_error;

Line 245: fnd_message.raise_error;

241: fnd_message.set_token (
242: 'TABLE_NAME',
243: 'BEN_BATCH_ACTN_ITEM_INFO'
244: );
245: fnd_message.raise_error;
246: END IF;
247:
248: --
249: CLOSE c1;

Line 262: fnd_message.set_name (

258: --
259: FETCH c2 INTO l_temp;
260: IF c2%FOUND THEN
261: CLOSE c2;
262: fnd_message.set_name (
263: 'BEN',
264: 'BEN_94121_DT_CHILD_EXISTS'
265: );
266: fnd_message.set_token (

Line 266: fnd_message.set_token (

262: fnd_message.set_name (
263: 'BEN',
264: 'BEN_94121_DT_CHILD_EXISTS'
265: );
266: fnd_message.set_token (
267: 'TABLE_NAME',
268: 'BEN_BATCH_BNFT_CERT_INFO'
269: );
270: fnd_message.raise_error;

Line 270: fnd_message.raise_error;

266: fnd_message.set_token (
267: 'TABLE_NAME',
268: 'BEN_BATCH_BNFT_CERT_INFO'
269: );
270: fnd_message.raise_error;
271: END IF;
272:
273: --
274: CLOSE c2;

Line 287: fnd_message.set_name (

283: --
284: FETCH c20 INTO l_temp;
285: IF c20%FOUND THEN
286: CLOSE c20;
287: fnd_message.set_name (
288: 'BEN',
289: 'BEN_94121_DT_CHILD_EXISTS'
290: );
291: fnd_message.set_token (

Line 291: fnd_message.set_token (

287: fnd_message.set_name (
288: 'BEN',
289: 'BEN_94121_DT_CHILD_EXISTS'
290: );
291: fnd_message.set_token (
292: 'TABLE_NAME',
293: 'BEN_BATCH_COMMU_INFO'
294: );
295: fnd_message.raise_error;

Line 295: fnd_message.raise_error;

291: fnd_message.set_token (
292: 'TABLE_NAME',
293: 'BEN_BATCH_COMMU_INFO'
294: );
295: fnd_message.raise_error;
296: END IF;
297:
298: --
299: CLOSE c20;

Line 312: fnd_message.set_name (

308: --
309: FETCH c21 INTO l_temp;
310: IF c21%FOUND THEN
311: CLOSE c21;
312: fnd_message.set_name (
313: 'BEN',
314: 'BEN_94121_DT_CHILD_EXISTS'
315: );
316: fnd_message.set_token (

Line 316: fnd_message.set_token (

312: fnd_message.set_name (
313: 'BEN',
314: 'BEN_94121_DT_CHILD_EXISTS'
315: );
316: fnd_message.set_token (
317: 'TABLE_NAME',
318: 'BEN_BATCH_DPNT_INFO'
319: );
320: fnd_message.raise_error;

Line 320: fnd_message.raise_error;

316: fnd_message.set_token (
317: 'TABLE_NAME',
318: 'BEN_BATCH_DPNT_INFO'
319: );
320: fnd_message.raise_error;
321: END IF;
322:
323: --
324: CLOSE c21;

Line 337: fnd_message.set_name (

333: --
334: FETCH c22 INTO l_temp;
335: IF c22%FOUND THEN
336: CLOSE c22;
337: fnd_message.set_name (
338: 'BEN',
339: 'BEN_94121_DT_CHILD_EXISTS'
340: );
341: fnd_message.set_token (

Line 341: fnd_message.set_token (

337: fnd_message.set_name (
338: 'BEN',
339: 'BEN_94121_DT_CHILD_EXISTS'
340: );
341: fnd_message.set_token (
342: 'TABLE_NAME',
343: 'BEN_BATCH_ELCTBL_CHC_INFO'
344: );
345: fnd_message.raise_error;

Line 345: fnd_message.raise_error;

341: fnd_message.set_token (
342: 'TABLE_NAME',
343: 'BEN_BATCH_ELCTBL_CHC_INFO'
344: );
345: fnd_message.raise_error;
346: END IF;
347:
348: --
349: CLOSE c22;

Line 362: fnd_message.set_name (

358: --
359: FETCH c23 INTO l_temp;
360: IF c23%FOUND THEN
361: CLOSE c23;
362: fnd_message.set_name (
363: 'BEN',
364: 'BEN_94121_DT_CHILD_EXISTS'
365: );
366: fnd_message.set_token (

Line 366: fnd_message.set_token (

362: fnd_message.set_name (
363: 'BEN',
364: 'BEN_94121_DT_CHILD_EXISTS'
365: );
366: fnd_message.set_token (
367: 'TABLE_NAME',
368: 'BEN_BATCH_ELIG_INFO'
369: );
370: fnd_message.raise_error;

Line 370: fnd_message.raise_error;

366: fnd_message.set_token (
367: 'TABLE_NAME',
368: 'BEN_BATCH_ELIG_INFO'
369: );
370: fnd_message.raise_error;
371: END IF;
372:
373: --
374: CLOSE c23;

Line 387: fnd_message.set_name (

383: --
384: FETCH c24 INTO l_temp;
385: IF c24%FOUND THEN
386: CLOSE c24;
387: fnd_message.set_name (
388: 'BEN',
389: 'BEN_94121_DT_CHILD_EXISTS'
390: );
391: fnd_message.set_token (

Line 391: fnd_message.set_token (

387: fnd_message.set_name (
388: 'BEN',
389: 'BEN_94121_DT_CHILD_EXISTS'
390: );
391: fnd_message.set_token (
392: 'TABLE_NAME',
393: 'BEN_BATCH_LER_INFO'
394: );
395: fnd_message.raise_error;

Line 395: fnd_message.raise_error;

391: fnd_message.set_token (
392: 'TABLE_NAME',
393: 'BEN_BATCH_LER_INFO'
394: );
395: fnd_message.raise_error;
396: END IF;
397:
398: --
399: CLOSE c24;

Line 412: fnd_message.set_name (

408: --
409: FETCH c25 INTO l_temp;
410: IF c25%FOUND THEN
411: CLOSE c25;
412: fnd_message.set_name (
413: 'BEN',
414: 'BEN_94121_DT_CHILD_EXISTS'
415: );
416: fnd_message.set_token (

Line 416: fnd_message.set_token (

412: fnd_message.set_name (
413: 'BEN',
414: 'BEN_94121_DT_CHILD_EXISTS'
415: );
416: fnd_message.set_token (
417: 'TABLE_NAME',
418: 'BEN_BATCH_RATE_INFO'
419: );
420: fnd_message.raise_error;

Line 420: fnd_message.raise_error;

416: fnd_message.set_token (
417: 'TABLE_NAME',
418: 'BEN_BATCH_RATE_INFO'
419: );
420: fnd_message.raise_error;
421: END IF;
422:
423: --
424: CLOSE c25;

Line 437: fnd_message.set_name (

433: --
434: FETCH c26 INTO l_temp;
435: IF c26%FOUND THEN
436: CLOSE c26;
437: fnd_message.set_name (
438: 'BEN',
439: 'BEN_94121_DT_CHILD_EXISTS'
440: );
441: fnd_message.set_token (

Line 441: fnd_message.set_token (

437: fnd_message.set_name (
438: 'BEN',
439: 'BEN_94121_DT_CHILD_EXISTS'
440: );
441: fnd_message.set_token (
442: 'TABLE_NAME',
443: 'BEN_BENEFIT_ACTIONS'
444: );
445: fnd_message.raise_error;

Line 445: fnd_message.raise_error;

441: fnd_message.set_token (
442: 'TABLE_NAME',
443: 'BEN_BENEFIT_ACTIONS'
444: );
445: fnd_message.raise_error;
446: END IF;
447:
448: --
449: CLOSE c26;

Line 462: fnd_message.set_name (

458: --
459: FETCH c15 INTO l_temp;
460: IF c15%FOUND THEN
461: CLOSE c15;
462: fnd_message.set_name (
463: 'BEN',
464: 'BEN_94121_DT_CHILD_EXISTS'
465: );
466: fnd_message.set_token (

Line 466: fnd_message.set_token (

462: fnd_message.set_name (
463: 'BEN',
464: 'BEN_94121_DT_CHILD_EXISTS'
465: );
466: fnd_message.set_token (
467: 'TABLE_NAME',
468: 'BEN_CRT_ORDR'
469: );
470: fnd_message.raise_error;

Line 470: fnd_message.raise_error;

466: fnd_message.set_token (
467: 'TABLE_NAME',
468: 'BEN_CRT_ORDR'
469: );
470: fnd_message.raise_error;
471: END IF;
472:
473: --
474: CLOSE c15;

Line 487: fnd_message.set_name (

483: --
484: FETCH c16 INTO l_temp;
485: IF c16%FOUND THEN
486: CLOSE c16;
487: fnd_message.set_name (
488: 'BEN',
489: 'BEN_94121_DT_CHILD_EXISTS'
490: );
491: fnd_message.set_token (

Line 491: fnd_message.set_token (

487: fnd_message.set_name (
488: 'BEN',
489: 'BEN_94121_DT_CHILD_EXISTS'
490: );
491: fnd_message.set_token (
492: 'TABLE_NAME',
493: 'BEN_CRT_ORDR_CVRD_PER'
494: );
495: fnd_message.raise_error;

Line 495: fnd_message.raise_error;

491: fnd_message.set_token (
492: 'TABLE_NAME',
493: 'BEN_CRT_ORDR_CVRD_PER'
494: );
495: fnd_message.raise_error;
496: END IF;
497:
498: --
499: CLOSE c16;

Line 512: fnd_message.set_name (

508: --
509: FETCH c17 INTO l_temp;
510: IF c17%FOUND THEN
511: CLOSE c17;
512: fnd_message.set_name (
513: 'BEN',
514: 'BEN_94121_DT_CHILD_EXISTS'
515: );
516: fnd_message.set_token (

Line 516: fnd_message.set_token (

512: fnd_message.set_name (
513: 'BEN',
514: 'BEN_94121_DT_CHILD_EXISTS'
515: );
516: fnd_message.set_token (
517: 'TABLE_NAME',
518: 'BEN_ELIG_PER_F'
519: );
520: fnd_message.raise_error;

Line 520: fnd_message.raise_error;

516: fnd_message.set_token (
517: 'TABLE_NAME',
518: 'BEN_ELIG_PER_F'
519: );
520: fnd_message.raise_error;
521: END IF;
522:
523: --
524: CLOSE c17;

Line 537: fnd_message.set_name (

533: --
534: FETCH c3 INTO l_temp;
535: IF c3%FOUND THEN
536: CLOSE c3;
537: fnd_message.set_name (
538: 'BEN',
539: 'BEN_94121_DT_CHILD_EXISTS'
540: );
541: fnd_message.set_token (

Line 541: fnd_message.set_token (

537: fnd_message.set_name (
538: 'BEN',
539: 'BEN_94121_DT_CHILD_EXISTS'
540: );
541: fnd_message.set_token (
542: 'TABLE_NAME',
543: 'BEN_EXT_CHG_EVT_LOG'
544: );
545: fnd_message.raise_error;

Line 545: fnd_message.raise_error;

541: fnd_message.set_token (
542: 'TABLE_NAME',
543: 'BEN_EXT_CHG_EVT_LOG'
544: );
545: fnd_message.raise_error;
546: END IF;
547:
548: --
549: CLOSE c3;

Line 562: fnd_message.set_name (

558: --
559: FETCH c6 INTO l_temp;
560: IF c6%FOUND THEN
561: CLOSE c6;
562: fnd_message.set_name (
563: 'BEN',
564: 'BEN_94121_DT_CHILD_EXISTS'
565: );
566: fnd_message.set_token (

Line 566: fnd_message.set_token (

562: fnd_message.set_name (
563: 'BEN',
564: 'BEN_94121_DT_CHILD_EXISTS'
565: );
566: fnd_message.set_token (
567: 'TABLE_NAME',
568: 'BEN_EXT_RSLT_DTL'
569: );
570: fnd_message.raise_error;

Line 570: fnd_message.raise_error;

566: fnd_message.set_token (
567: 'TABLE_NAME',
568: 'BEN_EXT_RSLT_DTL'
569: );
570: fnd_message.raise_error;
571: END IF;
572:
573: --
574: CLOSE c6;

Line 587: fnd_message.set_name (

583: --
584: FETCH c7 INTO l_temp;
585: IF c7%FOUND THEN
586: CLOSE c7;
587: fnd_message.set_name (
588: 'BEN',
589: 'BEN_94121_DT_CHILD_EXISTS'
590: );
591: fnd_message.set_token (

Line 591: fnd_message.set_token (

587: fnd_message.set_name (
588: 'BEN',
589: 'BEN_94121_DT_CHILD_EXISTS'
590: );
591: fnd_message.set_token (
592: 'TABLE_NAME',
593: 'BEN_EXT_RSLT_ERR'
594: );
595: fnd_message.raise_error;

Line 595: fnd_message.raise_error;

591: fnd_message.set_token (
592: 'TABLE_NAME',
593: 'BEN_EXT_RSLT_ERR'
594: );
595: fnd_message.raise_error;
596: END IF;
597:
598: --
599: CLOSE c7;

Line 612: fnd_message.set_name (

608: --
609: FETCH c11 INTO l_temp;
610: IF c11%FOUND THEN
611: CLOSE c11;
612: fnd_message.set_name (
613: 'BEN',
614: 'BEN_94121_DT_CHILD_EXISTS'
615: );
616: fnd_message.set_token (

Line 616: fnd_message.set_token (

612: fnd_message.set_name (
613: 'BEN',
614: 'BEN_94121_DT_CHILD_EXISTS'
615: );
616: fnd_message.set_token (
617: 'TABLE_NAME',
618: 'BEN_LE_CLSN_N_RSTR'
619: );
620: fnd_message.raise_error;

Line 620: fnd_message.raise_error;

616: fnd_message.set_token (
617: 'TABLE_NAME',
618: 'BEN_LE_CLSN_N_RSTR'
619: );
620: fnd_message.raise_error;
621: END IF;
622:
623: --
624: CLOSE c11;

Line 637: fnd_message.set_name (

633: --
634: FETCH c27 INTO l_temp;
635: IF c27%FOUND THEN
636: CLOSE c27;
637: fnd_message.set_name (
638: 'BEN',
639: 'BEN_94121_DT_CHILD_EXISTS'
640: );
641: fnd_message.set_token (

Line 641: fnd_message.set_token (

637: fnd_message.set_name (
638: 'BEN',
639: 'BEN_94121_DT_CHILD_EXISTS'
640: );
641: fnd_message.set_token (
642: 'TABLE_NAME',
643: 'BEN_PERSON_ACTIONS'
644: );
645: fnd_message.raise_error;

Line 645: fnd_message.raise_error;

641: fnd_message.set_token (
642: 'TABLE_NAME',
643: 'BEN_PERSON_ACTIONS'
644: );
645: fnd_message.raise_error;
646: END IF;
647:
648: --
649: CLOSE c27;

Line 662: fnd_message.set_name (

658: --
659: FETCH c4 INTO l_temp;
660: IF c4%FOUND THEN
661: CLOSE c4;
662: fnd_message.set_name (
663: 'BEN',
664: 'BEN_94121_DT_CHILD_EXISTS'
665: );
666: fnd_message.set_token (

Line 666: fnd_message.set_token (

662: fnd_message.set_name (
663: 'BEN',
664: 'BEN_94121_DT_CHILD_EXISTS'
665: );
666: fnd_message.set_token (
667: 'TABLE_NAME',
668: 'BEN_PER_BNFTS_BAL_F'
669: );
670: fnd_message.raise_error;

Line 670: fnd_message.raise_error;

666: fnd_message.set_token (
667: 'TABLE_NAME',
668: 'BEN_PER_BNFTS_BAL_F'
669: );
670: fnd_message.raise_error;
671: END IF;
672:
673: --
674: CLOSE c4;

Line 687: fnd_message.set_name (

683: --
684: FETCH c19 INTO l_temp;
685: IF c19%FOUND THEN
686: CLOSE c19;
687: fnd_message.set_name (
688: 'BEN',
689: 'BEN_94121_DT_CHILD_EXISTS'
690: );
691: fnd_message.set_token (

Line 691: fnd_message.set_token (

687: fnd_message.set_name (
688: 'BEN',
689: 'BEN_94121_DT_CHILD_EXISTS'
690: );
691: fnd_message.set_token (
692: 'TABLE_NAME',
693: 'BEN_PER_CM_F'
694: );
695: fnd_message.raise_error;

Line 695: fnd_message.raise_error;

691: fnd_message.set_token (
692: 'TABLE_NAME',
693: 'BEN_PER_CM_F'
694: );
695: fnd_message.raise_error;
696: END IF;
697:
698: --
699: CLOSE c19;

Line 712: fnd_message.set_name (

708: --
709: FETCH c8 INTO l_temp;
710: IF c8%FOUND THEN
711: CLOSE c8;
712: fnd_message.set_name (
713: 'BEN',
714: 'BEN_94121_DT_CHILD_EXISTS'
715: );
716: fnd_message.set_token (

Line 716: fnd_message.set_token (

712: fnd_message.set_name (
713: 'BEN',
714: 'BEN_94121_DT_CHILD_EXISTS'
715: );
716: fnd_message.set_token (
717: 'TABLE_NAME',
718: 'BEN_PER_DLVRY_MTHD_F'
719: );
720: fnd_message.raise_error;

Line 720: fnd_message.raise_error;

716: fnd_message.set_token (
717: 'TABLE_NAME',
718: 'BEN_PER_DLVRY_MTHD_F'
719: );
720: fnd_message.raise_error;
721: END IF;
722:
723: --
724: CLOSE c8;

Line 737: fnd_message.set_name (

733: --
734: FETCH c12 INTO l_temp;
735: IF c12%FOUND THEN
736: CLOSE c12;
737: fnd_message.set_name (
738: 'BEN',
739: 'BEN_94121_DT_CHILD_EXISTS'
740: );
741: fnd_message.set_token (

Line 741: fnd_message.set_token (

737: fnd_message.set_name (
738: 'BEN',
739: 'BEN_94121_DT_CHILD_EXISTS'
740: );
741: fnd_message.set_token (
742: 'TABLE_NAME',
743: 'BEN_PER_IN_LER'
744: );
745: fnd_message.raise_error;

Line 745: fnd_message.raise_error;

741: fnd_message.set_token (
742: 'TABLE_NAME',
743: 'BEN_PER_IN_LER'
744: );
745: fnd_message.raise_error;
746: END IF;
747:
748: --
749: CLOSE c12;

Line 762: fnd_message.set_name (

758: --
759: FETCH c9 INTO l_temp;
760: IF c9%FOUND THEN
761: CLOSE c9;
762: fnd_message.set_name (
763: 'BEN',
764: 'BEN_94121_DT_CHILD_EXISTS'
765: );
766: fnd_message.set_token (

Line 766: fnd_message.set_token (

762: fnd_message.set_name (
763: 'BEN',
764: 'BEN_94121_DT_CHILD_EXISTS'
765: );
766: fnd_message.set_token (
767: 'TABLE_NAME',
768: 'BEN_PER_IN_LGL_ENTY_F'
769: );
770: fnd_message.raise_error;

Line 770: fnd_message.raise_error;

766: fnd_message.set_token (
767: 'TABLE_NAME',
768: 'BEN_PER_IN_LGL_ENTY_F'
769: );
770: fnd_message.raise_error;
771: END IF;
772:
773: --
774: CLOSE c9;

Line 787: fnd_message.set_name (

783: --
784: FETCH c10 INTO l_temp;
785: IF c10%FOUND THEN
786: CLOSE c10;
787: fnd_message.set_name (
788: 'BEN',
789: 'BEN_94121_DT_CHILD_EXISTS'
790: );
791: fnd_message.set_token (

Line 791: fnd_message.set_token (

787: fnd_message.set_name (
788: 'BEN',
789: 'BEN_94121_DT_CHILD_EXISTS'
790: );
791: fnd_message.set_token (
792: 'TABLE_NAME',
793: 'BEN_PER_IN_ORG_UNIT_F'
794: );
795: fnd_message.raise_error;

Line 795: fnd_message.raise_error;

791: fnd_message.set_token (
792: 'TABLE_NAME',
793: 'BEN_PER_IN_ORG_UNIT_F'
794: );
795: fnd_message.raise_error;
796: END IF;
797:
798: --
799: CLOSE c10;

Line 812: fnd_message.set_name (

808: --
809: FETCH c5 INTO l_temp;
810: IF c5%FOUND THEN
811: CLOSE c5;
812: fnd_message.set_name (
813: 'BEN',
814: 'BEN_94121_DT_CHILD_EXISTS'
815: );
816: fnd_message.set_token (

Line 816: fnd_message.set_token (

812: fnd_message.set_name (
813: 'BEN',
814: 'BEN_94121_DT_CHILD_EXISTS'
815: );
816: fnd_message.set_token (
817: 'TABLE_NAME',
818: 'BEN_PER_PIN_F'
819: );
820: fnd_message.raise_error;

Line 820: fnd_message.raise_error;

816: fnd_message.set_token (
817: 'TABLE_NAME',
818: 'BEN_PER_PIN_F'
819: );
820: fnd_message.raise_error;
821: END IF;
822:
823: --
824: CLOSE c5;

Line 837: fnd_message.set_name (

833: --
834: FETCH c14 INTO l_temp;
835: IF c14%FOUND THEN
836: CLOSE c14;
837: fnd_message.set_name (
838: 'BEN',
839: 'BEN_94121_DT_CHILD_EXISTS'
840: );
841: fnd_message.set_token (

Line 841: fnd_message.set_token (

837: fnd_message.set_name (
838: 'BEN',
839: 'BEN_94121_DT_CHILD_EXISTS'
840: );
841: fnd_message.set_token (
842: 'TABLE_NAME',
843: 'BEN_POPL_ORG_F'
844: );
845: fnd_message.raise_error;

Line 845: fnd_message.raise_error;

841: fnd_message.set_token (
842: 'TABLE_NAME',
843: 'BEN_POPL_ORG_F'
844: );
845: fnd_message.raise_error;
846: END IF;
847:
848: --
849: CLOSE c14;

Line 862: fnd_message.set_name (

858: --
859: FETCH c18 INTO l_temp;
860: IF c18%FOUND THEN
861: CLOSE c18;
862: fnd_message.set_name (
863: 'BEN',
864: 'BEN_94121_DT_CHILD_EXISTS'
865: );
866: fnd_message.set_token (

Line 866: fnd_message.set_token (

862: fnd_message.set_name (
863: 'BEN',
864: 'BEN_94121_DT_CHILD_EXISTS'
865: );
866: fnd_message.set_token (
867: 'TABLE_NAME',
868: 'BEN_PRTT_ENRT_RSLT_F'
869: );
870: fnd_message.raise_error;

Line 870: fnd_message.raise_error;

866: fnd_message.set_token (
867: 'TABLE_NAME',
868: 'BEN_PRTT_ENRT_RSLT_F'
869: );
870: fnd_message.raise_error;
871: END IF;
872:
873: --
874: CLOSE c18;

Line 887: fnd_message.set_name (

883: --
884: FETCH c13 INTO l_temp;
885: IF c13%FOUND THEN
886: CLOSE c13;
887: fnd_message.set_name (
888: 'BEN',
889: 'BEN_94121_DT_CHILD_EXISTS'
890: );
891: fnd_message.set_token (

Line 891: fnd_message.set_token (

887: fnd_message.set_name (
888: 'BEN',
889: 'BEN_94121_DT_CHILD_EXISTS'
890: );
891: fnd_message.set_token (
892: 'TABLE_NAME',
893: 'BEN_PTNL_LER_FOR_PER'
894: );
895: fnd_message.raise_error;

Line 895: fnd_message.raise_error;

891: fnd_message.set_token (
892: 'TABLE_NAME',
893: 'BEN_PTNL_LER_FOR_PER'
894: );
895: fnd_message.raise_error;
896: END IF;
897:
898: --
899: CLOSE c13;

Line 912: fnd_message.set_name (

908: --
909: FETCH c28 INTO l_temp;
910: IF c28%FOUND THEN
911: CLOSE c28;
912: fnd_message.set_name (
913: 'BEN',
914: 'BEN_94121_DT_CHILD_EXISTS'
915: );
916: fnd_message.set_token (

Line 916: fnd_message.set_token (

912: fnd_message.set_name (
913: 'BEN',
914: 'BEN_94121_DT_CHILD_EXISTS'
915: );
916: fnd_message.set_token (
917: 'TABLE_NAME',
918: 'BEN_REPORTING'
919: );
920: fnd_message.raise_error;

Line 920: fnd_message.raise_error;

916: fnd_message.set_token (
917: 'TABLE_NAME',
918: 'BEN_REPORTING'
919: );
920: fnd_message.raise_error;
921: END IF;
922:
923: --
924: CLOSE c28;

Line 936: fnd_message.set_name (

932: --
933: FETCH c29 INTO l_temp;
934: IF c29%FOUND THEN
935: CLOSE c29;
936: fnd_message.set_name (
937: 'BEN',
938: 'BEN_94121_DT_CHILD_EXISTS'
939: );
940: fnd_message.set_token (

Line 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_ELIG_CVRD_DPNT_F'
943: );
944: fnd_message.raise_error;

Line 944: fnd_message.raise_error;

940: fnd_message.set_token (
941: 'TABLE_NAME',
942: 'BEN_ELIG_CVRD_DPNT_F'
943: );
944: fnd_message.raise_error;
945: END IF;
946:
947: --
948: CLOSE c29;

Line 960: fnd_message.set_name (

956: --
957: FETCH c30 INTO l_temp;
958: IF c30%FOUND THEN
959: CLOSE c30;
960: fnd_message.set_name (
961: 'BEN',
962: 'BEN_94121_DT_CHILD_EXISTS'
963: );
964: fnd_message.set_token (

Line 964: fnd_message.set_token (

960: fnd_message.set_name (
961: 'BEN',
962: 'BEN_94121_DT_CHILD_EXISTS'
963: );
964: fnd_message.set_token (
965: 'TABLE_NAME',
966: 'BEN_PRTT_REIBMT_RQST_F'
967: );
968: fnd_message.raise_error;

Line 968: fnd_message.raise_error;

964: fnd_message.set_token (
965: 'TABLE_NAME',
966: 'BEN_PRTT_REIBMT_RQST_F'
967: );
968: fnd_message.raise_error;
969: END IF;
970:
971: --
972: CLOSE c30;

Line 984: fnd_message.set_name (

980: --
981: FETCH c31 INTO l_temp;
982: IF c31%FOUND THEN
983: CLOSE c31;
984: fnd_message.set_name (
985: 'BEN',
986: 'BEN_94121_DT_CHILD_EXISTS'
987: );
988: fnd_message.set_token (

Line 988: fnd_message.set_token (

984: fnd_message.set_name (
985: 'BEN',
986: 'BEN_94121_DT_CHILD_EXISTS'
987: );
988: fnd_message.set_token (
989: 'TABLE_NAME',
990: 'BEN_PRTT_REIBMT_RQST_F'
991: );
992: fnd_message.raise_error;

Line 992: fnd_message.raise_error;

988: fnd_message.set_token (
989: 'TABLE_NAME',
990: 'BEN_PRTT_REIBMT_RQST_F'
991: );
992: fnd_message.raise_error;
993: END IF;
994:
995: --
996: CLOSE c31;

Line 1008: fnd_message.set_name (

1004: --
1005: FETCH c32 INTO l_temp;
1006: IF c32%FOUND THEN
1007: CLOSE c32;
1008: fnd_message.set_name (
1009: 'BEN',
1010: 'BEN_94121_DT_CHILD_EXISTS'
1011: );
1012: fnd_message.set_token (

Line 1012: fnd_message.set_token (

1008: fnd_message.set_name (
1009: 'BEN',
1010: 'BEN_94121_DT_CHILD_EXISTS'
1011: );
1012: fnd_message.set_token (
1013: 'TABLE_NAME',
1014: 'BEN_PRTT_REIBMT_RQST_F'
1015: );
1016: fnd_message.raise_error;

Line 1016: fnd_message.raise_error;

1012: fnd_message.set_token (
1013: 'TABLE_NAME',
1014: 'BEN_PRTT_REIBMT_RQST_F'
1015: );
1016: fnd_message.raise_error;
1017: END IF;
1018:
1019: --
1020: CLOSE c32;

Line 1032: fnd_message.set_name (

1028: --
1029: FETCH c33 INTO l_temp;
1030: IF c33%FOUND THEN
1031: CLOSE c33;
1032: fnd_message.set_name (
1033: 'BEN',
1034: 'BEN_94121_DT_CHILD_EXISTS'
1035: );
1036: fnd_message.set_token (

Line 1036: fnd_message.set_token (

1032: fnd_message.set_name (
1033: 'BEN',
1034: 'BEN_94121_DT_CHILD_EXISTS'
1035: );
1036: fnd_message.set_token (
1037: 'TABLE_NAME',
1038: 'BEN_PRTT_REIBMT_RQST_F'
1039: );
1040: fnd_message.raise_error;

Line 1040: fnd_message.raise_error;

1036: fnd_message.set_token (
1037: 'TABLE_NAME',
1038: 'BEN_PRTT_REIBMT_RQST_F'
1039: );
1040: fnd_message.raise_error;
1041: END IF;
1042:
1043: --
1044: CLOSE c33;

Line 1056: fnd_message.set_name (

1052: --
1053: FETCH c34 INTO l_temp;
1054: IF c34%FOUND THEN
1055: CLOSE c34;
1056: fnd_message.set_name (
1057: 'BEN',
1058: 'BEN_94121_DT_CHILD_EXISTS'
1059: );
1060: fnd_message.set_token (

Line 1060: fnd_message.set_token (

1056: fnd_message.set_name (
1057: 'BEN',
1058: 'BEN_94121_DT_CHILD_EXISTS'
1059: );
1060: fnd_message.set_token (
1061: 'TABLE_NAME',
1062: 'BEN_CBR_QUALD_BNF'
1063: );
1064: fnd_message.raise_error;

Line 1064: fnd_message.raise_error;

1060: fnd_message.set_token (
1061: 'TABLE_NAME',
1062: 'BEN_CBR_QUALD_BNF'
1063: );
1064: fnd_message.raise_error;
1065: END IF;
1066:
1067: --
1068: CLOSE c34;

Line 1078: fnd_message.set_name (

1074: );
1075: FETCH c35 INTO l_temp;
1076: IF c35%FOUND THEN
1077: CLOSE c35;
1078: fnd_message.set_name (
1079: 'BEN',
1080: 'BEN_93911_DPT_DESIG_BNF'
1081: );
1082: fnd_message.raise_error;

Line 1082: fnd_message.raise_error;

1078: fnd_message.set_name (
1079: 'BEN',
1080: 'BEN_93911_DPT_DESIG_BNF'
1081: );
1082: fnd_message.raise_error;
1083: END IF;
1084: --
1085: CLOSE c35;
1086: -- 3511450 end

Line 3134: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');

3130: if c_pil%found then
3131: --
3132: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3133: close c_pil ;
3134: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3135: fnd_message.set_token('BEN_ITEM','Life Event');
3136: fnd_message.raise_error;
3137: --
3138: end if;

Line 3135: fnd_message.set_token('BEN_ITEM','Life Event');

3131: --
3132: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3133: close c_pil ;
3134: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3135: fnd_message.set_token('BEN_ITEM','Life Event');
3136: fnd_message.raise_error;
3137: --
3138: end if;
3139: close c_pil ;

Line 3136: fnd_message.raise_error;

3132: hr_utility.set_location('Started Pil exist for person '||p_person_id , 20);
3133: close c_pil ;
3134: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3135: fnd_message.set_token('BEN_ITEM','Life Event');
3136: fnd_message.raise_error;
3137: --
3138: end if;
3139: close c_pil ;
3140: --check for active enrollment result records

Line 3148: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');

3144: if c_pen%found then
3145: --
3146: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3147: close c_pen ;
3148: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3149: fnd_message.set_token('BEN_ITEM','Enrollment');
3150: fnd_message.raise_error;
3151: --
3152: end if;

Line 3149: fnd_message.set_token('BEN_ITEM','Enrollment');

3145: --
3146: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3147: close c_pen ;
3148: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3149: fnd_message.set_token('BEN_ITEM','Enrollment');
3150: fnd_message.raise_error;
3151: --
3152: end if;
3153: close c_pen ;

Line 3150: fnd_message.raise_error;

3146: hr_utility.set_location('Started pen exist for person '||p_person_id , 30);
3147: close c_pen ;
3148: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3149: fnd_message.set_token('BEN_ITEM','Enrollment');
3150: fnd_message.raise_error;
3151: --
3152: end if;
3153: close c_pen ;
3154: --check for active rate records

Line 3162: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');

3158: if c_prv%found then
3159: --
3160: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3161: close c_prv ;
3162: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3163: fnd_message.set_token('BEN_ITEM','Rate');
3164: fnd_message.raise_error;
3165: --
3166: end if;

Line 3163: fnd_message.set_token('BEN_ITEM','Rate');

3159: --
3160: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3161: close c_prv ;
3162: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3163: fnd_message.set_token('BEN_ITEM','Rate');
3164: fnd_message.raise_error;
3165: --
3166: end if;
3167: close c_prv ;

Line 3164: fnd_message.raise_error;

3160: hr_utility.set_location('Started prv exist for person '||p_person_id , 40);
3161: close c_prv ;
3162: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3163: fnd_message.set_token('BEN_ITEM','Rate');
3164: fnd_message.raise_error;
3165: --
3166: end if;
3167: close c_prv ;
3168: --check for active dependents

Line 3176: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');

3172: if c_ecd%found then
3173: --
3174: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3175: close c_ecd ;
3176: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3177: fnd_message.set_token('BEN_ITEM','Dependents');
3178: fnd_message.raise_error;
3179: --
3180: end if;

Line 3177: fnd_message.set_token('BEN_ITEM','Dependents');

3173: --
3174: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3175: close c_ecd ;
3176: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3177: fnd_message.set_token('BEN_ITEM','Dependents');
3178: fnd_message.raise_error;
3179: --
3180: end if;
3181: close c_ecd ;

Line 3178: fnd_message.raise_error;

3174: hr_utility.set_location('Started ecd exist for person '||p_person_id , 50);
3175: close c_ecd ;
3176: fnd_message.set_name('BEN', 'BEN_92720_BEN_DATA_EXISTS');
3177: fnd_message.set_token('BEN_ITEM','Dependents');
3178: fnd_message.raise_error;
3179: --
3180: end if;
3181: close c_ecd ;
3182: --

Line 3191: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');

3187: if c_ecdpn%found then
3188: --
3189: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3190: close c_ecdpn ;
3191: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3192: fnd_message.raise_error;
3193: --
3194: end if;
3195: close c_ecdpn ;

Line 3192: fnd_message.raise_error;

3188: --
3189: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3190: close c_ecdpn ;
3191: fnd_message.set_name('BEN', 'BEN_93910_DPTN_CVRD');
3192: fnd_message.raise_error;
3193: --
3194: end if;
3195: close c_ecdpn ;
3196:

Line 3205: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');

3201: if c_plbnf%found then
3202: --
3203: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3204: close c_plbnf ;
3205: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3206: fnd_message.raise_error;
3207: --
3208: end if;
3209: close c_plbnf ;

Line 3206: fnd_message.raise_error;

3202: --
3203: hr_utility.set_location('Started ecdpn exist for person '||p_person_id , 50);
3204: close c_plbnf ;
3205: fnd_message.set_name('BEN', 'BEN_93911_DPT_DESIG_BNF');
3206: fnd_message.raise_error;
3207: --
3208: end if;
3209: close c_plbnf ;
3210: