eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.BEN_DETERMINE_COMMUNICATIONS dependencies on BENUTILS

Line 32: 115.13 20-JUL-99 Gperry genutils -> benutils package rename.

28: 115.9 10-May-99 jcarpent Check ('VOIDD', 'BCKDT') for pil stat cd
29: 115.10 13-May-99 jcarpent Fixed ben_prtt_enrt_actn query to handle arc.
30: 115.11 14-May-99 maagrawa Changed chr() with fnd_global.local_chr()
31: 115.12 09-Jul-99 jcarpent Added checks for backed out pil
32: 115.13 20-JUL-99 Gperry genutils -> benutils package rename.
33: 115.14 27-JUL-1999 mhoyes - Changed g_report_rec to ref ben_type.
34: 115.15 30-JUL-1999 mhoyes - Changed g_batch_proc_rec to ref ben_type.
35: 115.16 10-SEP-1999 maagrawa -For emerging event, trap the date the life
36: event occurs.

Line 50: 115.21 19-Oct-1999 maagrawa Moved function get_message_name to benutils.

46: 115.19 13-Oct-1999 stee Change elig_enrol_cd to not be required for
47: mss mailing unless a comp object is specified.
48: 115.20 13-Oct-1999 maagrawa Ordered the parameter list in procedure process
49: as in seeded concurrent procedure.
50: 115.21 19-Oct-1999 maagrawa Moved function get_message_name to benutils.
51: 115.22 09-Feb-2000 maagrawa Generate enrollment reminder letter when the
52: effective date is within the enrollment
53: window (1187184, 1183934).
54: Pass the ler_id of the active life event to

Line 242: benutils.g_report_table_object.delete;

238: begin
239: --
240: g_processes_rec.delete;
241: --
242: benutils.g_report_table_object.delete;
243: benutils.g_batch_action_table_object.delete;
244: benutils.g_batch_proc_table_object.delete;
245: benutils.g_batch_commu_table_object.delete;
246: --

Line 243: benutils.g_batch_action_table_object.delete;

239: --
240: g_processes_rec.delete;
241: --
242: benutils.g_report_table_object.delete;
243: benutils.g_batch_action_table_object.delete;
244: benutils.g_batch_proc_table_object.delete;
245: benutils.g_batch_commu_table_object.delete;
246: --
247: g_num_processes := 0;

Line 244: benutils.g_batch_proc_table_object.delete;

240: g_processes_rec.delete;
241: --
242: benutils.g_report_table_object.delete;
243: benutils.g_batch_action_table_object.delete;
244: benutils.g_batch_proc_table_object.delete;
245: benutils.g_batch_commu_table_object.delete;
246: --
247: g_num_processes := 0;
248: g_threads := 0;

Line 245: benutils.g_batch_commu_table_object.delete;

241: --
242: benutils.g_report_table_object.delete;
243: benutils.g_batch_action_table_object.delete;
244: benutils.g_batch_proc_table_object.delete;
245: benutils.g_batch_commu_table_object.delete;
246: --
247: g_num_processes := 0;
248: g_threads := 0;
249: g_chunk_size := 0;

Line 416: benutils.write(p_rec => g_proc_rec);

412: --
413: g_proc_rec.per_proc := nvl(g_proc_rec.per_proc_succ,0)+
414: nvl(g_proc_rec.per_err,0);
415: --
416: benutils.write(p_rec => g_proc_rec);
417: --
418: end if;
419: --
420: benutils.write_table_and_file(p_table => true

Line 420: benutils.write_table_and_file(p_table => true

416: benutils.write(p_rec => g_proc_rec);
417: --
418: end if;
419: --
420: benutils.write_table_and_file(p_table => true
421: ,p_file => false);
422: commit;
423: --
424: if l_master = 'Y' then

Line 466: benutils.write(p_text => fnd_message.get);

462: --
463: when error_limit then
464: fnd_message.set_name('BEN', 'BEN_92163_BENTMPCM_ERR_LMT');
465: fnd_message.set_token('PROC',l_proc);
466: benutils.write(p_text => fnd_message.get);
467: raise;
468: --
469: end person_error_cnt;
470: --

Line 483: benutils.write(p_text => benutils.g_banner_minus);

479: begin
480: --
481: hr_utility.set_location('Entering : ' || l_proc, 10);
482: --
483: benutils.write(p_text => benutils.g_banner_minus);
484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);

Line 484: benutils.write(p_text => 'Batch Process Statistical Information');

480: --
481: hr_utility.set_location('Entering : ' || l_proc, 10);
482: --
483: benutils.write(p_text => benutils.g_banner_minus);
484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);

Line 485: benutils.write(p_text => benutils.g_banner_minus);

481: hr_utility.set_location('Entering : ' || l_proc, 10);
482: --
483: benutils.write(p_text => benutils.g_banner_minus);
484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);
489: --

Line 486: benutils.write(p_text => 'People processed : ' || g_person_cnt);

482: --
483: benutils.write(p_text => benutils.g_banner_minus);
484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);
489: --
490: benutils.write_table_and_file(p_table => false

Line 487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);

483: benutils.write(p_text => benutils.g_banner_minus);
484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);
489: --
490: benutils.write_table_and_file(p_table => false
491: ,p_file => true);

Line 488: benutils.write(p_text => benutils.g_banner_minus);

484: benutils.write(p_text => 'Batch Process Statistical Information');
485: benutils.write(p_text => benutils.g_banner_minus);
486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);
489: --
490: benutils.write_table_and_file(p_table => false
491: ,p_file => true);
492: commit;

Line 490: benutils.write_table_and_file(p_table => false

486: benutils.write(p_text => 'People processed : ' || g_person_cnt);
487: benutils.write(p_text => 'People errored : ' || g_error_person_cnt);
488: benutils.write(p_text => benutils.g_banner_minus);
489: --
490: benutils.write_table_and_file(p_table => false
491: ,p_file => true);
492: commit;
493: --
494: hr_utility.set_location('Leaving : ' || l_proc, 10);

Line 500: benutils.write(p_text => sqlerrm);

496: exception
497: --
498: when others then
499: --
500: benutils.write(p_text => sqlerrm);
501: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
502: fnd_message.set_token('PROC',l_proc);
503: benutils.write(p_text => fnd_message.get);
504: fnd_message.raise_error;

Line 503: benutils.write(p_text => fnd_message.get);

499: --
500: benutils.write(p_text => sqlerrm);
501: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
502: fnd_message.set_token('PROC',l_proc);
503: benutils.write(p_text => fnd_message.get);
504: fnd_message.raise_error;
505: --
506: end write_logfile;
507: --

Line 516: l_rec benutils.g_batch_param_rec;

512: procedure print_parameters is
513: --
514: l_proc varchar2(80) := g_package || '.print_parameters';
515: --
516: l_rec benutils.g_batch_param_rec;
517: begin
518: --
519: hr_utility.set_location('Entering : ' || l_proc, 10);
520: --

Line 527: benutils.get_batch_parameters

523: end if;
524: --
525: -- added to prevent logging
526: --
527: benutils.get_batch_parameters
528: (p_benefit_action_id => g_parm.benefit_action_id,
529: p_rec => l_rec);
530: --
531: fnd_file.put_line(which => fnd_file.log

Line 539: benutils.iftrue

535: ,buff => '------------------');
536: --
537: fnd_file.put_line(which => fnd_file.log
538: ,buff => 'Benefit Action ID : '||
539: benutils.iftrue
540: (p_expression => g_parm.benefit_action_id is null
541: ,p_true => 'NONE'
542: ,p_false => g_parm.benefit_action_id));
543: --

Line 562: benutils.iftrue

558: hr_general.decode_lookup('BEN_BENTMPCM_MD',g_parm.mode_cd));
559: --
560: fnd_file.put_line(which => fnd_file.log
561: ,buff => 'Comm Trigger Type Code : ' ||
562: benutils.iftrue
563: (p_expression => g_parm.cm_trgr_typ_cd is null
564: ,p_true => 'All'
565: ,p_false => g_parm.cm_trgr_typ_cd));
566: --

Line 569: benutils.iftrue

565: ,p_false => g_parm.cm_trgr_typ_cd));
566: --
567: fnd_file.put_line(which => fnd_file.log
568: ,buff => 'Communication Type ID : ' ||
569: benutils.iftrue
570: (p_expression => g_parm.cm_typ_id is null
571: ,p_true => 'All'
572: ,p_false => g_parm.cm_typ_id));
573: --

Line 576: benutils.iftrue

572: ,p_false => g_parm.cm_typ_id));
573: --
574: fnd_file.put_line(which => fnd_file.log
575: ,buff => 'Person ID : ' ||
576: benutils.iftrue
577: (p_expression => g_parm.person_id is null
578: ,p_true => 'All'
579: ,p_false => g_parm.person_id));
580: --

Line 583: benutils.iftrue

579: ,p_false => g_parm.person_id));
580: --
581: fnd_file.put_line(which => fnd_file.log
582: ,buff => 'Person Type ID : ' ||
583: benutils.iftrue
584: (p_expression => g_parm.person_type_id is null
585: ,p_true => 'All'
586: ,p_false => g_parm.person_type_id));
587: --

Line 590: benutils.iftrue

586: ,p_false => g_parm.person_type_id));
587: --
588: fnd_file.put_line(which => fnd_file.log
589: ,buff => 'Person Selection Rule : ' ||
590: benutils.iftrue
591: (p_expression => g_parm.person_sel_rl is null
592: ,p_true => 'All'
593: ,p_false => g_parm.person_sel_rl));
594: --

Line 597: benutils.iftrue

593: ,p_false => g_parm.person_sel_rl));
594: --
595: fnd_file.put_line(which => fnd_file.log
596: ,buff => 'Organization ID : ' ||
597: benutils.iftrue
598: (p_expression => g_parm.organization_id is null
599: ,p_true => 'All'
600: ,p_false => g_parm.organization_id));
601: --

Line 604: benutils.iftrue

600: ,p_false => g_parm.organization_id));
601: --
602: fnd_file.put_line(which => fnd_file.log
603: ,buff => 'Location ID : ' ||
604: benutils.iftrue
605: (p_expression => g_parm.location_id is null
606: ,p_true => 'All'
607: ,p_false => g_parm.location_id));
608: --

Line 611: benutils.iftrue

607: ,p_false => g_parm.location_id));
608: --
609: fnd_file.put_line(which => fnd_file.log
610: ,buff => 'Life Event Reason ID : ' ||
611: benutils.iftrue
612: (p_expression => g_parm.ler_id is null
613: ,p_true => 'All'
614: ,p_false => g_parm.ler_id));
615: --

Line 618: benutils.iftrue

614: ,p_false => g_parm.ler_id));
615: --
616: fnd_file.put_line(which => fnd_file.log
617: ,buff => 'Program ID : '||
618: benutils.iftrue
619: (p_expression => g_parm.pgm_id is null
620: ,p_true => 'All'
621: ,p_false => g_parm.pgm_id));
622: --

Line 625: benutils.iftrue

621: ,p_false => g_parm.pgm_id));
622: --
623: fnd_file.put_line(which => fnd_file.log,
624: buff => 'Plan ID : '||
625: benutils.iftrue
626: (p_expression => g_parm.pl_nip_id is null
627: ,p_true => 'All'
628: ,p_false => g_parm.pl_nip_id));
629: --

Line 636: benutils.iftrue

632: g_parm.plan_in_pgm_flag);
633: --
634: fnd_file.put_line(which => fnd_file.log
635: ,buff => 'Action Type ID : ' ||
636: benutils.iftrue
637: (p_expression => g_parm.actn_typ_id is null
638: ,p_true => 'All'
639: ,p_false => g_parm.actn_typ_id));
640: --

Line 643: benutils.iftrue

639: ,p_false => g_parm.actn_typ_id));
640: --
641: fnd_file.put_line(which => fnd_file.log
642: ,buff => 'Elig Enrol Code : ' ||
643: benutils.iftrue
644: (p_expression => g_parm.elig_enrol_cd is null
645: ,p_true => 'NONE'
646: ,p_false => g_parm.elig_enrol_cd));
647: --

Line 650: benutils.iftrue

646: ,p_false => g_parm.elig_enrol_cd));
647: --
648: fnd_file.put_line(which => fnd_file.log
649: ,buff => 'Age Factor ID : ' ||
650: benutils.iftrue
651: (p_expression => g_parm.age_fctr_id is null
652: ,p_true => 'NONE'
653: ,p_false => g_parm.age_fctr_id));
654: --

Line 657: benutils.iftrue

653: ,p_false => g_parm.age_fctr_id));
654: --
655: fnd_file.put_line(which => fnd_file.log
656: ,buff => 'Minimum Age : ' ||
657: benutils.iftrue
658: (p_expression => g_parm.min_age is null
659: ,p_true => 'NONE'
660: ,p_false => g_parm.min_age));
661: --

Line 664: benutils.iftrue

660: ,p_false => g_parm.min_age));
661: --
662: fnd_file.put_line(which => fnd_file.log
663: ,buff => 'Maximum Age : ' ||
664: benutils.iftrue
665: (p_expression => g_parm.max_age is null
666: ,p_true => 'NONE'
667: ,p_false => g_parm.max_age));
668: --

Line 671: benutils.iftrue

667: ,p_false => g_parm.max_age));
668: --
669: fnd_file.put_line(which => fnd_file.log
670: ,buff => 'Length of Srvce Factor Id : ' ||
671: benutils.iftrue
672: (p_expression => g_parm.los_fctr_id is null
673: ,p_true => 'NONE'
674: ,p_false => g_parm.los_fctr_id));
675: --

Line 678: benutils.iftrue

674: ,p_false => g_parm.los_fctr_id));
675: --
676: fnd_file.put_line(which => fnd_file.log
677: ,buff => 'Minimum LOS : ' ||
678: benutils.iftrue
679: (p_expression => g_parm.min_los is null
680: ,p_true => 'NONE'
681: ,p_false => g_parm.min_los));
682: --

Line 685: benutils.iftrue

681: ,p_false => g_parm.min_los));
682: --
683: fnd_file.put_line(which => fnd_file.log
684: ,buff => 'Maximum LOS : ' ||
685: benutils.iftrue
686: (p_expression => g_parm.max_los is null
687: ,p_true => 'NONE'
688: ,p_false => g_parm.max_los));
689: --

Line 692: benutils.iftrue

688: ,p_false => g_parm.max_los));
689: --
690: fnd_file.put_line(which => fnd_file.log
691: ,buff => 'Cmbn Age and LOS Factor Id : ' ||
692: benutils.iftrue
693: (p_expression => g_parm.cmbn_age_los_fctr_id is null
694: ,p_true => 'NONE'
695: ,p_false => g_parm.cmbn_age_los_fctr_id));
696: --

Line 699: benutils.iftrue

695: ,p_false => g_parm.cmbn_age_los_fctr_id));
696: --
697: fnd_file.put_line(which => fnd_file.log
698: ,buff => 'Date From : ' ||
699: benutils.iftrue
700: (p_expression => g_parm.date_from is null
701: ,p_true => 'NONE'
702: ,p_false => g_parm.date_from));
703: --

Line 707: benutils.iftrue

703: --
704: /*
705: fnd_file.put_line(which => fnd_file.log,
706: buff => 'Enrollment Period : '||
707: benutils.iftrue
708: (p_expression => g_parm.popl_enrt_typ_cycl_id is null
709: ,p_true => 'All'
710: ,p_false => g_parm.popl_enrt_typ_cycl_id));
711: */

Line 1341: benutils.write(p_rec => g_rec);

1337: g_rec.text := fnd_message.get;
1338: --
1339: end if;
1340: --
1341: benutils.write(p_rec => g_rec);
1342: --
1343: hr_utility.set_location('Leaving : ' || l_proc, 10);
1344: --
1345: end chk_per_cm;

Line 2012: if benutils.min_max_breach(

2008: --
2009: -- Check if a breach occures.
2010: --
2011: --
2012: if benutils.min_max_breach(
2013: p_min_value => l_min_value,
2014: p_max_value => l_max_value,
2015: p_old_value => l_age_before,
2016: p_new_value => l_age_after,

Line 2019: p_lf_evt_ocrd_dt := benutils.derive_date(

2015: p_old_value => l_age_before,
2016: p_new_value => l_age_after,
2017: p_break => l_break) then
2018: --
2019: p_lf_evt_ocrd_dt := benutils.derive_date(
2020: p_date => l_dob,
2021: p_uom => l_uom,
2022: p_min => l_min_value,
2023: p_max => l_max_value,

Line 2201: if benutils.min_max_breach(

2197: end if; -- g_parm.los_fctr_id
2198: --
2199: -- Check if a breach occures.
2200: --
2201: if benutils.min_max_breach(
2202: p_min_value => l_min_value,
2203: p_max_value => l_max_value,
2204: p_old_value => l_los_before,
2205: p_new_value => l_los_after,

Line 2208: p_lf_evt_ocrd_dt := benutils.derive_date(

2204: p_old_value => l_los_before,
2205: p_new_value => l_los_after,
2206: p_break => l_break) then
2207: --
2208: p_lf_evt_ocrd_dt := benutils.derive_date(
2209: p_date => l_start_date,
2210: p_uom => l_uom,
2211: p_min => l_min_value,
2212: p_max => l_max_value,

Line 2384: if benutils.min_max_breach(

2380: l_cmbn.mn_age_num+l_cmbn.mn_los_num);
2381: l_max_value := nvl(l_cmbn.cmbnd_max_val,
2382: l_cmbn.mx_age_num+l_cmbn.mx_los_num);
2383: --
2384: if benutils.min_max_breach(
2385: p_min_value => l_min_value,
2386: p_max_value => l_max_value,
2387: p_old_value => l_cmbn_before,
2388: p_new_value => l_cmbn_after,

Line 2565: benutils.write(p_rec => g_action_rec);

2561: g_action_rec.object_version_number := l_per_rec.object_version_number;
2562: g_action_rec.effective_date := g_parm.effective_date;
2563: --
2564: hr_utility.set_location('Nearly Leaving Now',10);
2565: benutils.write(p_rec => g_action_rec);
2566: --
2567: hr_utility.set_location('Leaving Now',10);
2568: exception
2569: --

Line 2578: g_rec.error_message_code := benutils.get_message_name;

2574: rollback to before_communications;
2575: --
2576: g_rec.person_id := l_per_rec.person_id;
2577: g_rec.rep_typ_cd := 'ERRCM';
2578: g_rec.error_message_code := benutils.get_message_name;
2579: g_rec.text := fnd_message.get;
2580: --
2581: benutils.write(p_rec => g_rec);
2582: --

Line 2581: benutils.write(p_rec => g_rec);

2577: g_rec.rep_typ_cd := 'ERRCM';
2578: g_rec.error_message_code := benutils.get_message_name;
2579: g_rec.text := fnd_message.get;
2580: --
2581: benutils.write(p_rec => g_rec);
2582: --
2583: -- Update person action to errored as record has an error
2584: --
2585: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2590: benutils.write(p_rec => g_action_rec);

2586: g_action_rec.action_status_cd := 'E';
2587: g_action_rec.object_version_number := l_per_rec.object_version_number;
2588: g_action_rec.effective_date := g_parm.effective_date;
2589: --
2590: benutils.write(p_rec => g_action_rec);
2591: --
2592: -- Increment the person error count.
2593: --
2594: person_error_cnt;

Line 2607: benutils.write(p_rec => g_rec);

2603: g_rec.rep_typ_cd := 'FATAL';
2604: g_rec.error_message_code := sqlcode;
2605: g_rec.text := sqlerrm;
2606: --
2607: benutils.write(p_rec => g_rec);
2608: --
2609: -- Update person action to errored as record has an error
2610: --
2611: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2616: benutils.write(p_rec => g_action_rec);

2612: g_action_rec.action_status_cd := 'E';
2613: g_action_rec.object_version_number := l_per_rec.object_version_number;
2614: g_action_rec.effective_date := g_parm.effective_date;
2615: --
2616: benutils.write(p_rec => g_action_rec);
2617: --
2618: -- Increment the person error count.
2619: --
2620: person_error_cnt;

Line 2630: benutils.write_table_and_file(p_table => true

2626: if g_parm.validate_flag = 'Y' then
2627: rollback;
2628: end if;
2629: --
2630: benutils.write_table_and_file(p_table => true
2631: ,p_file => true);
2632: --
2633: commit;
2634: --

Line 2698: benutils.write(p_rec => g_action_rec);

2694: g_action_rec.action_status_cd := 'P';
2695: g_action_rec.object_version_number := l_per_rec.object_version_number;
2696: g_action_rec.effective_date := g_parm.effective_date;
2697: --
2698: benutils.write(p_rec => g_action_rec);
2699: --
2700: exception
2701: --
2702: when ben_manage_life_events.g_record_error then

Line 2709: g_rec.error_message_code := benutils.get_message_name;

2705: --
2706: rollback to before_communications;
2707: --
2708: g_rec.rep_typ_cd := 'ERRCM';
2709: g_rec.error_message_code := benutils.get_message_name;
2710: g_rec.text := fnd_message.get;
2711: g_rec.person_id := l_per_rec.person_id;
2712: --
2713: benutils.write(p_rec => g_rec);

Line 2713: benutils.write(p_rec => g_rec);

2709: g_rec.error_message_code := benutils.get_message_name;
2710: g_rec.text := fnd_message.get;
2711: g_rec.person_id := l_per_rec.person_id;
2712: --
2713: benutils.write(p_rec => g_rec);
2714: --
2715: -- Update person action to errored as record has an error
2716: --
2717: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2722: benutils.write(p_rec => g_action_rec);

2718: g_action_rec.action_status_cd := 'E';
2719: g_action_rec.object_version_number := l_per_rec.object_version_number;
2720: g_action_rec.effective_date := g_parm.effective_date;
2721: --
2722: benutils.write(p_rec => g_action_rec);
2723: --
2724: -- Increment the person error count.
2725: --
2726: person_error_cnt;

Line 2739: benutils.write(p_rec => g_rec);

2735: g_rec.error_message_code := sqlcode;
2736: g_rec.text := sqlerrm;
2737: g_rec.person_id := l_per_rec.person_id;
2738: --
2739: benutils.write(p_rec => g_rec);
2740: --
2741: -- Update person action to errored as record has an error
2742: --
2743: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2748: benutils.write(p_rec => g_action_rec);

2744: g_action_rec.action_status_cd := 'E';
2745: g_action_rec.object_version_number := l_per_rec.object_version_number;
2746: g_action_rec.effective_date := g_parm.effective_date;
2747: --
2748: benutils.write(p_rec => g_action_rec);
2749: --
2750: -- Increment the person error count.
2751: --
2752: person_error_cnt;

Line 2762: benutils.write_table_and_file(p_table => true

2758: if g_parm.validate_flag = 'Y' then
2759: rollback;
2760: end if;
2761: --
2762: benutils.write_table_and_file(p_table => true
2763: ,p_file => true);
2764: --
2765: commit;
2766: --

Line 2834: benutils.write(p_rec => g_action_rec);

2830: g_action_rec.action_status_cd := 'P';
2831: g_action_rec.object_version_number := l_per_rec.object_version_number;
2832: g_action_rec.effective_date := g_parm.effective_date;
2833: --
2834: benutils.write(p_rec => g_action_rec);
2835: --
2836: exception
2837: --
2838: when ben_manage_life_events.g_record_error then

Line 2845: g_rec.error_message_code := benutils.get_message_name;

2841: --
2842: rollback to before_communications;
2843: --
2844: g_rec.rep_typ_cd := 'ERRCM';
2845: g_rec.error_message_code := benutils.get_message_name;
2846: g_rec.text := fnd_message.get;
2847: g_rec.person_id := l_per_rec.person_id;
2848: --
2849: benutils.write(p_rec => g_rec);

Line 2849: benutils.write(p_rec => g_rec);

2845: g_rec.error_message_code := benutils.get_message_name;
2846: g_rec.text := fnd_message.get;
2847: g_rec.person_id := l_per_rec.person_id;
2848: --
2849: benutils.write(p_rec => g_rec);
2850: --
2851: -- Update the g_action_rec to record an error
2852: --
2853: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2858: benutils.write(p_rec => g_action_rec);

2854: g_action_rec.action_status_cd := 'E';
2855: g_action_rec.object_version_number := l_per_rec.object_version_number;
2856: g_action_rec.effective_date := g_parm.effective_date;
2857: --
2858: benutils.write(p_rec => g_action_rec);
2859: --
2860: -- Increment the person error count.
2861: --
2862: person_error_cnt;

Line 2875: benutils.write(p_rec => g_rec);

2871: g_rec.error_message_code := sqlcode;
2872: g_rec.text := sqlerrm;
2873: g_rec.person_id := l_per_rec.person_id;
2874: --
2875: benutils.write(p_rec => g_rec);
2876: --
2877: -- Update person action to errored as record has an error
2878: --
2879: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2884: benutils.write(p_rec => g_action_rec);

2880: g_action_rec.action_status_cd := 'E';
2881: g_action_rec.object_version_number := l_per_rec.object_version_number;
2882: g_action_rec.effective_date := g_parm.effective_date;
2883: --
2884: benutils.write(p_rec => g_action_rec);
2885: --
2886: -- Increment the person error count.
2887: --
2888: person_error_cnt;

Line 2898: benutils.write_table_and_file(p_table => true

2894: if g_parm.validate_flag = 'Y' then
2895: rollback;
2896: end if;
2897: --
2898: benutils.write_table_and_file(p_table => true
2899: ,p_file => true);
2900: --
2901: commit;
2902: --

Line 2973: benutils.write(p_rec => g_action_rec);

2969: g_action_rec.action_status_cd := 'P';
2970: g_action_rec.object_version_number := l_per_rec.object_version_number;
2971: g_action_rec.effective_date := g_parm.effective_date;
2972: --
2973: benutils.write(p_rec => g_action_rec);
2974: --
2975: exception
2976: --
2977: when ben_manage_life_events.g_record_error then

Line 2983: benutils.write(p_text => fnd_message.get);

2979: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
2980: --
2981: rollback to before_communications;
2982: --
2983: benutils.write(p_text => fnd_message.get);
2984: --
2985: g_rec.rep_typ_cd := 'ERRCM';
2986: g_rec.error_message_code := benutils.get_message_name;
2987: g_rec.text := fnd_message.get;

Line 2986: g_rec.error_message_code := benutils.get_message_name;

2982: --
2983: benutils.write(p_text => fnd_message.get);
2984: --
2985: g_rec.rep_typ_cd := 'ERRCM';
2986: g_rec.error_message_code := benutils.get_message_name;
2987: g_rec.text := fnd_message.get;
2988: g_rec.person_id := l_per_rec.person_id;
2989: --
2990: benutils.write(p_rec => g_rec);

Line 2990: benutils.write(p_rec => g_rec);

2986: g_rec.error_message_code := benutils.get_message_name;
2987: g_rec.text := fnd_message.get;
2988: g_rec.person_id := l_per_rec.person_id;
2989: --
2990: benutils.write(p_rec => g_rec);
2991: --
2992: -- Update person action to errored as record has an error
2993: --
2994: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 2999: benutils.write(p_rec => g_action_rec);

2995: g_action_rec.action_status_cd := 'E';
2996: g_action_rec.object_version_number := l_per_rec.object_version_number;
2997: g_action_rec.effective_date := g_parm.effective_date;
2998: --
2999: benutils.write(p_rec => g_action_rec);
3000: --
3001: -- Increment the person error count.
3002: --
3003: person_error_cnt;

Line 3016: benutils.write(p_rec => g_rec);

3012: g_rec.error_message_code := sqlcode;
3013: g_rec.text := sqlerrm;
3014: g_rec.person_id := l_per_rec.person_id;
3015: --
3016: benutils.write(p_rec => g_rec);
3017: --
3018: -- Update person action to errored as record has an error
3019: --
3020: g_action_rec.person_action_id := l_per_rec.person_action_id;

Line 3025: benutils.write(p_rec => g_action_rec);

3021: g_action_rec.action_status_cd := 'E';
3022: g_action_rec.object_version_number := l_per_rec.object_version_number;
3023: g_action_rec.effective_date := g_parm.effective_date;
3024: --
3025: benutils.write(p_rec => g_action_rec);
3026: --
3027: -- Increment the person error count.
3028: --
3029: person_error_cnt;

Line 3039: benutils.write_table_and_file(p_table => true

3035: if g_parm.validate_flag = 'Y' then
3036: rollback;
3037: end if;
3038: --
3039: benutils.write_table_and_file(p_table => true
3040: ,p_file => true);
3041: --
3042: commit;
3043: --

Line 3220: benutils.get_parameter

3216: -- be empty. Get all the parameters just in case
3217: --
3218: -- Get the chunk size and threads for the batch process.
3219: --
3220: benutils.get_parameter
3221: (p_business_group_id => p_business_group_id
3222: ,p_batch_exe_cd => 'BENTMPCM'
3223: ,p_threads => g_threads
3224: ,p_chunk_size => g_chunk_size

Line 3247: benutils.g_benefit_action_id := p_benefit_action_id;

3243: --
3244: -- Set the global for the current thread being processed.
3245: --
3246: g_current_thread := p_thread_id;
3247: benutils.g_benefit_action_id := p_benefit_action_id;
3248: benutils.g_thread_id := p_thread_id;
3249: --
3250: -- Print parameters
3251: --

Line 3248: benutils.g_thread_id := p_thread_id;

3244: -- Set the global for the current thread being processed.
3245: --
3246: g_current_thread := p_thread_id;
3247: benutils.g_benefit_action_id := p_benefit_action_id;
3248: benutils.g_thread_id := p_thread_id;
3249: --
3250: -- Print parameters
3251: --
3252: print_parameters;

Line 3320: benutils.write(p_text => sqlerrm);

3316: --
3317: when others then
3318: --
3319: rollback;
3320: benutils.write(p_text => sqlerrm);
3321: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3322: g_rec.rep_typ_cd := 'FATAL';
3323: g_rec.error_message_code := sqlcode;
3324: g_rec.text := fnd_message.get;

Line 3325: benutils.write(p_rec => g_rec);

3321: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3322: g_rec.rep_typ_cd := 'FATAL';
3323: g_rec.error_message_code := sqlcode;
3324: g_rec.text := fnd_message.get;
3325: benutils.write(p_rec => g_rec);
3326: --
3327: -- Output log information to log file
3328: --
3329: write_logfile;

Line 3335: benutils.write(p_text => fnd_message.get);

3331: check_all_slaves_finished;
3332: --
3333: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3334: fnd_message.set_token('PROC',l_proc);
3335: benutils.write(p_text => fnd_message.get);
3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);
3338: commit;
3339: --

Line 3336: benutils.write_table_and_file(p_table => true,

3332: --
3333: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3334: fnd_message.set_token('PROC',l_proc);
3335: benutils.write(p_text => fnd_message.get);
3336: benutils.write_table_and_file(p_table => true,
3337: p_file => true);
3338: commit;
3339: --
3340: fnd_message.raise_error;

Line 4688: benutils.get_parameter

4684: --
4685: -- Get the parameters for the batch process so we know how many slaves to
4686: -- start and what size the chunk size is. Store them in globals.
4687: --
4688: benutils.get_parameter
4689: (p_business_group_id => p_business_group_id
4690: ,p_batch_exe_cd => 'BENTMPCM'
4691: ,p_threads => g_threads
4692: ,p_chunk_size => g_chunk_size