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.

[Home] [Help]

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 246: benutils.g_report_table_object.delete;

242: begin
243: --
244: g_processes_rec.delete;
245: --
246: benutils.g_report_table_object.delete;
247: benutils.g_batch_action_table_object.delete;
248: benutils.g_batch_proc_table_object.delete;
249: benutils.g_batch_commu_table_object.delete;
250: --

Line 247: benutils.g_batch_action_table_object.delete;

243: --
244: g_processes_rec.delete;
245: --
246: benutils.g_report_table_object.delete;
247: benutils.g_batch_action_table_object.delete;
248: benutils.g_batch_proc_table_object.delete;
249: benutils.g_batch_commu_table_object.delete;
250: --
251: g_num_processes := 0;

Line 248: benutils.g_batch_proc_table_object.delete;

244: g_processes_rec.delete;
245: --
246: benutils.g_report_table_object.delete;
247: benutils.g_batch_action_table_object.delete;
248: benutils.g_batch_proc_table_object.delete;
249: benutils.g_batch_commu_table_object.delete;
250: --
251: g_num_processes := 0;
252: g_threads := 0;

Line 249: benutils.g_batch_commu_table_object.delete;

245: --
246: benutils.g_report_table_object.delete;
247: benutils.g_batch_action_table_object.delete;
248: benutils.g_batch_proc_table_object.delete;
249: benutils.g_batch_commu_table_object.delete;
250: --
251: g_num_processes := 0;
252: g_threads := 0;
253: g_chunk_size := 0;

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

416: --
417: g_proc_rec.per_proc := nvl(g_proc_rec.per_proc_succ,0)+
418: nvl(g_proc_rec.per_err,0);
419: --
420: benutils.write(p_rec => g_proc_rec);
421: --
422: end if;
423: --
424: benutils.write_table_and_file(p_table => true

Line 424: benutils.write_table_and_file(p_table => true

420: benutils.write(p_rec => g_proc_rec);
421: --
422: end if;
423: --
424: benutils.write_table_and_file(p_table => true
425: ,p_file => false);
426: commit;
427: --
428: if l_master = 'Y' then

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 494: benutils.write_table_and_file(p_table => false

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

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

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

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

503: --
504: benutils.write(p_text => sqlerrm);
505: fnd_message.set_name('BEN','BEN_91663_BENMNGLE_LOGGING');
506: fnd_message.set_token('PROC',l_proc);
507: benutils.write(p_text => fnd_message.get);
508: fnd_message.raise_error;
509: --
510: end write_logfile;
511: --

Line 520: l_rec benutils.g_batch_param_rec;

516: procedure print_parameters is
517: --
518: l_proc varchar2(80) := g_package || '.print_parameters';
519: --
520: l_rec benutils.g_batch_param_rec;
521: begin
522: --
523: hr_utility.set_location('Entering : ' || l_proc, 10);
524: --

Line 531: benutils.get_batch_parameters

527: end if;
528: --
529: -- added to prevent logging
530: --
531: benutils.get_batch_parameters
532: (p_benefit_action_id => g_parm.benefit_action_id,
533: p_rec => l_rec);
534: --
535: fnd_file.put_line(which => fnd_file.log

Line 543: benutils.iftrue

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

Line 566: benutils.iftrue

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

Line 573: benutils.iftrue

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

Line 580: benutils.iftrue

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

Line 587: benutils.iftrue

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

Line 594: benutils.iftrue

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

Line 601: benutils.iftrue

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

Line 608: benutils.iftrue

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

Line 615: benutils.iftrue

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

Line 622: benutils.iftrue

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

Line 629: benutils.iftrue

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

Line 640: benutils.iftrue

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

Line 647: benutils.iftrue

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

Line 654: benutils.iftrue

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

Line 661: benutils.iftrue

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

Line 668: benutils.iftrue

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

Line 675: benutils.iftrue

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

Line 682: benutils.iftrue

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

Line 689: benutils.iftrue

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

Line 696: benutils.iftrue

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

Line 703: benutils.iftrue

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

Line 711: benutils.iftrue

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

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

1341: g_rec.text := fnd_message.get;
1342: --
1343: end if;
1344: --
1345: benutils.write(p_rec => g_rec);
1346: --
1347: hr_utility.set_location('Leaving : ' || l_proc, 10);
1348: --
1349: end chk_per_cm;

Line 2066: if benutils.min_max_breach(

2062: --
2063: -- Check if a breach occures.
2064: --
2065: --
2066: if benutils.min_max_breach(
2067: p_min_value => l_min_value,
2068: p_max_value => l_max_value,
2069: p_old_value => l_age_before,
2070: p_new_value => l_age_after,

Line 2073: p_lf_evt_ocrd_dt := benutils.derive_date(

2069: p_old_value => l_age_before,
2070: p_new_value => l_age_after,
2071: p_break => l_break) then
2072: --
2073: p_lf_evt_ocrd_dt := benutils.derive_date(
2074: p_date => l_dob,
2075: p_uom => l_uom,
2076: p_min => l_min_value,
2077: p_max => l_max_value,

Line 2255: if benutils.min_max_breach(

2251: end if; -- g_parm.los_fctr_id
2252: --
2253: -- Check if a breach occures.
2254: --
2255: if benutils.min_max_breach(
2256: p_min_value => l_min_value,
2257: p_max_value => l_max_value,
2258: p_old_value => l_los_before,
2259: p_new_value => l_los_after,

Line 2262: p_lf_evt_ocrd_dt := benutils.derive_date(

2258: p_old_value => l_los_before,
2259: p_new_value => l_los_after,
2260: p_break => l_break) then
2261: --
2262: p_lf_evt_ocrd_dt := benutils.derive_date(
2263: p_date => l_start_date,
2264: p_uom => l_uom,
2265: p_min => l_min_value,
2266: p_max => l_max_value,

Line 2438: if benutils.min_max_breach(

2434: l_cmbn.mn_age_num+l_cmbn.mn_los_num);
2435: l_max_value := nvl(l_cmbn.cmbnd_max_val,
2436: l_cmbn.mx_age_num+l_cmbn.mx_los_num);
2437: --
2438: if benutils.min_max_breach(
2439: p_min_value => l_min_value,
2440: p_max_value => l_max_value,
2441: p_old_value => l_cmbn_before,
2442: p_new_value => l_cmbn_after,

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

2619: g_action_rec.object_version_number := l_per_rec.object_version_number;
2620: g_action_rec.effective_date := g_parm.effective_date;
2621: --
2622: hr_utility.set_location('Nearly Leaving Now',10);
2623: benutils.write(p_rec => g_action_rec);
2624: --
2625: hr_utility.set_location('Leaving Now',10);
2626: exception
2627: --

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

2632: rollback to before_communications;
2633: --
2634: g_rec.person_id := l_per_rec.person_id;
2635: g_rec.rep_typ_cd := 'ERRCM';
2636: g_rec.error_message_code := benutils.get_message_name;
2637: g_rec.text := fnd_message.get;
2638: --
2639: benutils.write(p_rec => g_rec);
2640: --

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

2635: g_rec.rep_typ_cd := 'ERRCM';
2636: g_rec.error_message_code := benutils.get_message_name;
2637: g_rec.text := fnd_message.get;
2638: --
2639: benutils.write(p_rec => g_rec);
2640: --
2641: -- Update person action to errored as record has an error
2642: --
2643: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2644: g_action_rec.action_status_cd := 'E';
2645: g_action_rec.object_version_number := l_per_rec.object_version_number;
2646: g_action_rec.effective_date := g_parm.effective_date;
2647: --
2648: benutils.write(p_rec => g_action_rec);
2649: --
2650: -- Increment the person error count.
2651: --
2652: person_error_cnt;

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

2661: g_rec.rep_typ_cd := 'FATAL';
2662: g_rec.error_message_code := sqlcode;
2663: g_rec.text := sqlerrm;
2664: --
2665: benutils.write(p_rec => g_rec);
2666: --
2667: -- Update person action to errored as record has an error
2668: --
2669: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2670: g_action_rec.action_status_cd := 'E';
2671: g_action_rec.object_version_number := l_per_rec.object_version_number;
2672: g_action_rec.effective_date := g_parm.effective_date;
2673: --
2674: benutils.write(p_rec => g_action_rec);
2675: --
2676: -- Increment the person error count.
2677: --
2678: person_error_cnt;

Line 2688: benutils.write_table_and_file(p_table => true

2684: if g_parm.validate_flag = 'Y' then
2685: rollback;
2686: end if;
2687: --
2688: benutils.write_table_and_file(p_table => true
2689: ,p_file => true);
2690: --
2691: commit;
2692: --

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

2752: g_action_rec.action_status_cd := 'P';
2753: g_action_rec.object_version_number := l_per_rec.object_version_number;
2754: g_action_rec.effective_date := g_parm.effective_date;
2755: --
2756: benutils.write(p_rec => g_action_rec);
2757: --
2758: exception
2759: --
2760: when ben_manage_life_events.g_record_error then

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

2763: --
2764: rollback to before_communications;
2765: --
2766: g_rec.rep_typ_cd := 'ERRCM';
2767: g_rec.error_message_code := benutils.get_message_name;
2768: g_rec.text := fnd_message.get;
2769: g_rec.person_id := l_per_rec.person_id;
2770: --
2771: benutils.write(p_rec => g_rec);

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

2767: g_rec.error_message_code := benutils.get_message_name;
2768: g_rec.text := fnd_message.get;
2769: g_rec.person_id := l_per_rec.person_id;
2770: --
2771: benutils.write(p_rec => g_rec);
2772: --
2773: -- Update person action to errored as record has an error
2774: --
2775: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2776: g_action_rec.action_status_cd := 'E';
2777: g_action_rec.object_version_number := l_per_rec.object_version_number;
2778: g_action_rec.effective_date := g_parm.effective_date;
2779: --
2780: benutils.write(p_rec => g_action_rec);
2781: --
2782: -- Increment the person error count.
2783: --
2784: person_error_cnt;

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

2793: g_rec.error_message_code := sqlcode;
2794: g_rec.text := sqlerrm;
2795: g_rec.person_id := l_per_rec.person_id;
2796: --
2797: benutils.write(p_rec => g_rec);
2798: --
2799: -- Update person action to errored as record has an error
2800: --
2801: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2802: g_action_rec.action_status_cd := 'E';
2803: g_action_rec.object_version_number := l_per_rec.object_version_number;
2804: g_action_rec.effective_date := g_parm.effective_date;
2805: --
2806: benutils.write(p_rec => g_action_rec);
2807: --
2808: -- Increment the person error count.
2809: --
2810: person_error_cnt;

Line 2820: benutils.write_table_and_file(p_table => true

2816: if g_parm.validate_flag = 'Y' then
2817: rollback;
2818: end if;
2819: --
2820: benutils.write_table_and_file(p_table => true
2821: ,p_file => true);
2822: --
2823: commit;
2824: --

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

2888: g_action_rec.action_status_cd := 'P';
2889: g_action_rec.object_version_number := l_per_rec.object_version_number;
2890: g_action_rec.effective_date := g_parm.effective_date;
2891: --
2892: benutils.write(p_rec => g_action_rec);
2893: --
2894: exception
2895: --
2896: when ben_manage_life_events.g_record_error then

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

2899: --
2900: rollback to before_communications;
2901: --
2902: g_rec.rep_typ_cd := 'ERRCM';
2903: g_rec.error_message_code := benutils.get_message_name;
2904: g_rec.text := fnd_message.get;
2905: g_rec.person_id := l_per_rec.person_id;
2906: --
2907: benutils.write(p_rec => g_rec);

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

2903: g_rec.error_message_code := benutils.get_message_name;
2904: g_rec.text := fnd_message.get;
2905: g_rec.person_id := l_per_rec.person_id;
2906: --
2907: benutils.write(p_rec => g_rec);
2908: --
2909: -- Update the g_action_rec to record an error
2910: --
2911: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2912: g_action_rec.action_status_cd := 'E';
2913: g_action_rec.object_version_number := l_per_rec.object_version_number;
2914: g_action_rec.effective_date := g_parm.effective_date;
2915: --
2916: benutils.write(p_rec => g_action_rec);
2917: --
2918: -- Increment the person error count.
2919: --
2920: person_error_cnt;

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

2929: g_rec.error_message_code := sqlcode;
2930: g_rec.text := sqlerrm;
2931: g_rec.person_id := l_per_rec.person_id;
2932: --
2933: benutils.write(p_rec => g_rec);
2934: --
2935: -- Update person action to errored as record has an error
2936: --
2937: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

2938: g_action_rec.action_status_cd := 'E';
2939: g_action_rec.object_version_number := l_per_rec.object_version_number;
2940: g_action_rec.effective_date := g_parm.effective_date;
2941: --
2942: benutils.write(p_rec => g_action_rec);
2943: --
2944: -- Increment the person error count.
2945: --
2946: person_error_cnt;

Line 2956: benutils.write_table_and_file(p_table => true

2952: if g_parm.validate_flag = 'Y' then
2953: rollback;
2954: end if;
2955: --
2956: benutils.write_table_and_file(p_table => true
2957: ,p_file => true);
2958: --
2959: commit;
2960: --

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

3027: g_action_rec.action_status_cd := 'P';
3028: g_action_rec.object_version_number := l_per_rec.object_version_number;
3029: g_action_rec.effective_date := g_parm.effective_date;
3030: --
3031: benutils.write(p_rec => g_action_rec);
3032: --
3033: exception
3034: --
3035: when ben_manage_life_events.g_record_error then

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

3037: hr_utility.set_location ('PERSON ERROR '|| l_proc,10);
3038: --
3039: rollback to before_communications;
3040: --
3041: benutils.write(p_text => fnd_message.get);
3042: --
3043: g_rec.rep_typ_cd := 'ERRCM';
3044: g_rec.error_message_code := benutils.get_message_name;
3045: g_rec.text := fnd_message.get;

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

3040: --
3041: benutils.write(p_text => fnd_message.get);
3042: --
3043: g_rec.rep_typ_cd := 'ERRCM';
3044: g_rec.error_message_code := benutils.get_message_name;
3045: g_rec.text := fnd_message.get;
3046: g_rec.person_id := l_per_rec.person_id;
3047: --
3048: benutils.write(p_rec => g_rec);

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

3044: g_rec.error_message_code := benutils.get_message_name;
3045: g_rec.text := fnd_message.get;
3046: g_rec.person_id := l_per_rec.person_id;
3047: --
3048: benutils.write(p_rec => g_rec);
3049: --
3050: -- Update person action to errored as record has an error
3051: --
3052: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

3053: g_action_rec.action_status_cd := 'E';
3054: g_action_rec.object_version_number := l_per_rec.object_version_number;
3055: g_action_rec.effective_date := g_parm.effective_date;
3056: --
3057: benutils.write(p_rec => g_action_rec);
3058: --
3059: -- Increment the person error count.
3060: --
3061: person_error_cnt;

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

3070: g_rec.error_message_code := sqlcode;
3071: g_rec.text := sqlerrm;
3072: g_rec.person_id := l_per_rec.person_id;
3073: --
3074: benutils.write(p_rec => g_rec);
3075: --
3076: -- Update person action to errored as record has an error
3077: --
3078: g_action_rec.person_action_id := l_per_rec.person_action_id;

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

3079: g_action_rec.action_status_cd := 'E';
3080: g_action_rec.object_version_number := l_per_rec.object_version_number;
3081: g_action_rec.effective_date := g_parm.effective_date;
3082: --
3083: benutils.write(p_rec => g_action_rec);
3084: --
3085: -- Increment the person error count.
3086: --
3087: person_error_cnt;

Line 3097: benutils.write_table_and_file(p_table => true

3093: if g_parm.validate_flag = 'Y' then
3094: rollback;
3095: end if;
3096: --
3097: benutils.write_table_and_file(p_table => true
3098: ,p_file => true);
3099: --
3100: commit;
3101: --

Line 3278: benutils.get_parameter

3274: -- be empty. Get all the parameters just in case
3275: --
3276: -- Get the chunk size and threads for the batch process.
3277: --
3278: benutils.get_parameter
3279: (p_business_group_id => p_business_group_id
3280: ,p_batch_exe_cd => 'BENTMPCM'
3281: ,p_threads => g_threads
3282: ,p_chunk_size => g_chunk_size

Line 3305: benutils.g_benefit_action_id := p_benefit_action_id;

3301: --
3302: -- Set the global for the current thread being processed.
3303: --
3304: g_current_thread := p_thread_id;
3305: benutils.g_benefit_action_id := p_benefit_action_id;
3306: benutils.g_thread_id := p_thread_id;
3307: --
3308: -- Print parameters
3309: --

Line 3306: benutils.g_thread_id := p_thread_id;

3302: -- Set the global for the current thread being processed.
3303: --
3304: g_current_thread := p_thread_id;
3305: benutils.g_benefit_action_id := p_benefit_action_id;
3306: benutils.g_thread_id := p_thread_id;
3307: --
3308: -- Print parameters
3309: --
3310: print_parameters;

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

3374: --
3375: when others then
3376: --
3377: rollback;
3378: benutils.write(p_text => sqlerrm);
3379: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3380: g_rec.rep_typ_cd := 'FATAL';
3381: g_rec.error_message_code := sqlcode;
3382: g_rec.text := fnd_message.get;

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

3379: hr_utility.set_location ('BENTMPCM Error '|| l_proc,10);
3380: g_rec.rep_typ_cd := 'FATAL';
3381: g_rec.error_message_code := sqlcode;
3382: g_rec.text := fnd_message.get;
3383: benutils.write(p_rec => g_rec);
3384: --
3385: -- Output log information to log file
3386: --
3387: write_logfile;

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

3389: check_all_slaves_finished;
3390: --
3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3392: fnd_message.set_token('PROC',l_proc);
3393: benutils.write(p_text => fnd_message.get);
3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);
3396: commit;
3397: --

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

3390: --
3391: fnd_message.set_name('BEN','BEN_92172_BENTMPCM_ERRORED');
3392: fnd_message.set_token('PROC',l_proc);
3393: benutils.write(p_text => fnd_message.get);
3394: benutils.write_table_and_file(p_table => true,
3395: p_file => true);
3396: commit;
3397: --
3398: fnd_message.raise_error;

Line 4753: benutils.get_parameter

4749: --
4750: -- Get the parameters for the batch process so we know how many slaves to
4751: -- start and what size the chunk size is. Store them in globals.
4752: --
4753: benutils.get_parameter
4754: (p_business_group_id => p_business_group_id
4755: ,p_batch_exe_cd => 'BENTMPCM'
4756: ,p_threads => g_threads
4757: ,p_chunk_size => g_chunk_size