DBA Data[Home] [Help]

APPS.BEN_PERSON_DELETE dependencies on FND_MESSAGE

Line 286: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 311: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 336: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 361: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 386: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 411: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 436: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 461: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 486: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 511: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 536: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 561: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 586: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 611: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 636: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 661: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 686: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 711: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 736: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 761: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 786: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 811: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 836: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 861: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 886: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 911: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 936: fnd_message.set_name (

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 (

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

Line 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;

Line 961: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 985: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1009: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1033: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1057: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1081: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1105: fnd_message.set_name (

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 (

Line 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;

Line 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;

Line 1127: fnd_message.set_name (

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;

Line 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

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

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;

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

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 ;

Line 3274: fnd_message.raise_error;

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

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

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;

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

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 ;

Line 3288: fnd_message.raise_error;

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

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

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;

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

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 ;

Line 3302: fnd_message.raise_error;

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

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

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;

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

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 ;

Line 3316: fnd_message.raise_error;

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: --

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

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 ;

Line 3330: fnd_message.raise_error;

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:

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

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 ;

Line 3344: fnd_message.raise_error;

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:

Line 3550: fnd_message.raise_error;

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

Line 3584: fnd_message.raise_error;

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

Line 3616: fnd_message.raise_error;

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;