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_ENROLLMENT_PROCESS dependencies on FND_FILE

Line 794: fnd_file.put_line

790: begin
791: --
792: hr_utility.set_location('Entering:'||l_proc, 20);
793: --
794: fnd_file.put_line
795: (which => fnd_file.log,
796: buff => 'Entering - BEN_ENROLLMENT_PROCESS.ENROLLMENT_INFORMATION_DETAIL' );
797: fnd_file.put_line
798: (which => fnd_file.log,

Line 795: (which => fnd_file.log,

791: --
792: hr_utility.set_location('Entering:'||l_proc, 20);
793: --
794: fnd_file.put_line
795: (which => fnd_file.log,
796: buff => 'Entering - BEN_ENROLLMENT_PROCESS.ENROLLMENT_INFORMATION_DETAIL' );
797: fnd_file.put_line
798: (which => fnd_file.log,
799: buff => 'l_person_id '||p_person_id||' l_pgm_id '||p_pgm_id||' l_pl_id '||p_pl_id);

Line 797: fnd_file.put_line

793: --
794: fnd_file.put_line
795: (which => fnd_file.log,
796: buff => 'Entering - BEN_ENROLLMENT_PROCESS.ENROLLMENT_INFORMATION_DETAIL' );
797: fnd_file.put_line
798: (which => fnd_file.log,
799: buff => 'l_person_id '||p_person_id||' l_pgm_id '||p_pgm_id||' l_pl_id '||p_pl_id);
800: --
801: fnd_file.put_line

Line 798: (which => fnd_file.log,

794: fnd_file.put_line
795: (which => fnd_file.log,
796: buff => 'Entering - BEN_ENROLLMENT_PROCESS.ENROLLMENT_INFORMATION_DETAIL' );
797: fnd_file.put_line
798: (which => fnd_file.log,
799: buff => 'l_person_id '||p_person_id||' l_pgm_id '||p_pgm_id||' l_pl_id '||p_pl_id);
800: --
801: fnd_file.put_line
802: (which => fnd_file.log,

Line 801: fnd_file.put_line

797: fnd_file.put_line
798: (which => fnd_file.log,
799: buff => 'l_person_id '||p_person_id||' l_pgm_id '||p_pgm_id||' l_pl_id '||p_pl_id);
800: --
801: fnd_file.put_line
802: (which => fnd_file.log,
803: buff => 'l_opt_id '||p_opt_id||' l_ler_id '||p_ler_id);
804: fnd_file.put_line
805: (which => fnd_file.log,

Line 802: (which => fnd_file.log,

798: (which => fnd_file.log,
799: buff => 'l_person_id '||p_person_id||' l_pgm_id '||p_pgm_id||' l_pl_id '||p_pl_id);
800: --
801: fnd_file.put_line
802: (which => fnd_file.log,
803: buff => 'l_opt_id '||p_opt_id||' l_ler_id '||p_ler_id);
804: fnd_file.put_line
805: (which => fnd_file.log,
806: buff => 'p_bnft_val '||p_bnft_val);

Line 804: fnd_file.put_line

800: --
801: fnd_file.put_line
802: (which => fnd_file.log,
803: buff => 'l_opt_id '||p_opt_id||' l_ler_id '||p_ler_id);
804: fnd_file.put_line
805: (which => fnd_file.log,
806: buff => 'p_bnft_val '||p_bnft_val);
807: fnd_file.put_line
808: (which => fnd_file.log,

Line 805: (which => fnd_file.log,

801: fnd_file.put_line
802: (which => fnd_file.log,
803: buff => 'l_opt_id '||p_opt_id||' l_ler_id '||p_ler_id);
804: fnd_file.put_line
805: (which => fnd_file.log,
806: buff => 'p_bnft_val '||p_bnft_val);
807: fnd_file.put_line
808: (which => fnd_file.log,
809: buff => 'l_life_event_date '||p_life_event_date);

Line 807: fnd_file.put_line

803: buff => 'l_opt_id '||p_opt_id||' l_ler_id '||p_ler_id);
804: fnd_file.put_line
805: (which => fnd_file.log,
806: buff => 'p_bnft_val '||p_bnft_val);
807: fnd_file.put_line
808: (which => fnd_file.log,
809: buff => 'l_life_event_date '||p_life_event_date);
810: --
811: fnd_file.put_line

Line 808: (which => fnd_file.log,

804: fnd_file.put_line
805: (which => fnd_file.log,
806: buff => 'p_bnft_val '||p_bnft_val);
807: fnd_file.put_line
808: (which => fnd_file.log,
809: buff => 'l_life_event_date '||p_life_event_date);
810: --
811: fnd_file.put_line
812: (which => fnd_file.log,

Line 811: fnd_file.put_line

807: fnd_file.put_line
808: (which => fnd_file.log,
809: buff => 'l_life_event_date '||p_life_event_date);
810: --
811: fnd_file.put_line
812: (which => fnd_file.log,
813: buff => 'p_ended_pl_id '||p_ended_pl_id||' p_ended_opt_id '||p_ended_opt_id);
814: --
815: get_pil

Line 812: (which => fnd_file.log,

808: (which => fnd_file.log,
809: buff => 'l_life_event_date '||p_life_event_date);
810: --
811: fnd_file.put_line
812: (which => fnd_file.log,
813: buff => 'p_ended_pl_id '||p_ended_pl_id||' p_ended_opt_id '||p_ended_opt_id);
814: --
815: get_pil
816: (p_person_id => p_person_id,

Line 1792: fnd_file.put_line

1788: end if;
1789: --
1790: --Proceed with de-enrolling from the specified plan
1791: --
1792: fnd_file.put_line
1793: (which => fnd_file.log,
1794: buff => 'l_prtt_enrt_rslt_id '||l_prtt_enrt_rslt_id);
1795: --
1796: ben_prtt_enrt_result_api.delete_enrollment

Line 1793: (which => fnd_file.log,

1789: --
1790: --Proceed with de-enrolling from the specified plan
1791: --
1792: fnd_file.put_line
1793: (which => fnd_file.log,
1794: buff => 'l_prtt_enrt_rslt_id '||l_prtt_enrt_rslt_id);
1795: --
1796: ben_prtt_enrt_result_api.delete_enrollment
1797: (p_validate => p_validate

Line 2211: fnd_file.put_line

2207: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2208: l_record_typ_cd := 'ENROLL' ;
2209: END IF;
2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2214: fnd_file.put_line
2215: (which => fnd_file.log,

Line 2212: (which => fnd_file.log,

2208: l_record_typ_cd := 'ENROLL' ;
2209: END IF;
2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);

Line 2214: fnd_file.put_line

2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2217: --
2218: fnd_file.put_line

Line 2215: (which => fnd_file.log,

2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2217: --
2218: fnd_file.put_line
2219: (which => fnd_file.log,

Line 2218: fnd_file.put_line

2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2217: --
2218: fnd_file.put_line
2219: (which => fnd_file.log,
2220: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2221: fnd_file.put_line
2222: (which => fnd_file.log,

Line 2219: (which => fnd_file.log,

2215: (which => fnd_file.log,
2216: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2217: --
2218: fnd_file.put_line
2219: (which => fnd_file.log,
2220: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2221: fnd_file.put_line
2222: (which => fnd_file.log,
2223: buff => 'l_record_typ_cd '||l_record_typ_cd);

Line 2221: fnd_file.put_line

2217: --
2218: fnd_file.put_line
2219: (which => fnd_file.log,
2220: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2221: fnd_file.put_line
2222: (which => fnd_file.log,
2223: buff => 'l_record_typ_cd '||l_record_typ_cd);
2224: fnd_file.put_line
2225: (which => fnd_file.log,

Line 2222: (which => fnd_file.log,

2218: fnd_file.put_line
2219: (which => fnd_file.log,
2220: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2221: fnd_file.put_line
2222: (which => fnd_file.log,
2223: buff => 'l_record_typ_cd '||l_record_typ_cd);
2224: fnd_file.put_line
2225: (which => fnd_file.log,
2226: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);

Line 2224: fnd_file.put_line

2220: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2221: fnd_file.put_line
2222: (which => fnd_file.log,
2223: buff => 'l_record_typ_cd '||l_record_typ_cd);
2224: fnd_file.put_line
2225: (which => fnd_file.log,
2226: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2227: fnd_file.put_line
2228: (which => fnd_file.log,

Line 2225: (which => fnd_file.log,

2221: fnd_file.put_line
2222: (which => fnd_file.log,
2223: buff => 'l_record_typ_cd '||l_record_typ_cd);
2224: fnd_file.put_line
2225: (which => fnd_file.log,
2226: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2227: fnd_file.put_line
2228: (which => fnd_file.log,
2229: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);

Line 2227: fnd_file.put_line

2223: buff => 'l_record_typ_cd '||l_record_typ_cd);
2224: fnd_file.put_line
2225: (which => fnd_file.log,
2226: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2227: fnd_file.put_line
2228: (which => fnd_file.log,
2229: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);
2230: --
2231: get_pil

Line 2228: (which => fnd_file.log,

2224: fnd_file.put_line
2225: (which => fnd_file.log,
2226: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2227: fnd_file.put_line
2228: (which => fnd_file.log,
2229: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);
2230: --
2231: get_pil
2232: (p_person_id => l_person_id,

Line 2238: fnd_file.put_line

2234: p_life_event_date => l_life_event_date,
2235: p_pil => l_pil
2236: );
2237: --
2238: fnd_file.put_line
2239: (which => fnd_file.log,
2240: buff => 'l_pil.per_in_ler_id '||l_pil.per_in_ler_id);
2241: --Get EPE
2242: IF l_pil.per_in_ler_id IS NOT NULL THEN

Line 2239: (which => fnd_file.log,

2235: p_pil => l_pil
2236: );
2237: --
2238: fnd_file.put_line
2239: (which => fnd_file.log,
2240: buff => 'l_pil.per_in_ler_id '||l_pil.per_in_ler_id);
2241: --Get EPE
2242: IF l_pil.per_in_ler_id IS NOT NULL THEN
2243: get_epe

Line 2252: fnd_file.put_line

2248: p_pl_id => l_pl_id,
2249: p_pgm_id => l_pgm_id,
2250: p_epe => l_epe
2251: ) ;
2252: fnd_file.put_line
2253: (which => fnd_file.log,
2254: buff => 'l_epe.elig_per_elctbl_chc_id '||l_epe.elig_per_elctbl_chc_id);
2255: --
2256: --Find if there is a valid enrollment result exists for this epe and pil

Line 2253: (which => fnd_file.log,

2249: p_pgm_id => l_pgm_id,
2250: p_epe => l_epe
2251: ) ;
2252: fnd_file.put_line
2253: (which => fnd_file.log,
2254: buff => 'l_epe.elig_per_elctbl_chc_id '||l_epe.elig_per_elctbl_chc_id);
2255: --
2256: --Find if there is a valid enrollment result exists for this epe and pil
2257: --If not throw error.

Line 2326: fnd_file.put_line

2322: IF l_cvg_thru_dt IS NULL THEN
2323: l_returned_end_dt := NULL;
2324: ELSIF l_cvg_thru_dt <> l_returned_end_dt THEN
2325: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Through Date.
2326: fnd_file.put_line
2327: (which => fnd_file.log,
2328: buff => 'Mismatch found between supplied and plan design Dependant Coverage Through Date. Using the date in Plan Design: '||l_returned_end_dt);
2329: NULL;
2330: end if;

Line 2327: (which => fnd_file.log,

2323: l_returned_end_dt := NULL;
2324: ELSIF l_cvg_thru_dt <> l_returned_end_dt THEN
2325: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Through Date.
2326: fnd_file.put_line
2327: (which => fnd_file.log,
2328: buff => 'Mismatch found between supplied and plan design Dependant Coverage Through Date. Using the date in Plan Design: '||l_returned_end_dt);
2329: NULL;
2330: end if;
2331: --

Line 2337: fnd_file.put_line

2333: NULL;
2334: ELSIF l_cvg_strt_dt <> l_returned_strt_dt THEN
2335: IF l_cvg_thru_dt IS NULL THEN --Check for thru date null again,so that start date warning is printed only when enrolling dependants.
2336: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Start Date.
2337: fnd_file.put_line
2338: (which => fnd_file.log,
2339: buff => 'Mismatch found between supplied and plan design Dependant Coverage Start Date. Using the date in Plan Design: '||l_returned_strt_dt);
2340: END IF;
2341: END IF;

Line 2338: (which => fnd_file.log,

2334: ELSIF l_cvg_strt_dt <> l_returned_strt_dt THEN
2335: IF l_cvg_thru_dt IS NULL THEN --Check for thru date null again,so that start date warning is printed only when enrolling dependants.
2336: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Start Date.
2337: fnd_file.put_line
2338: (which => fnd_file.log,
2339: buff => 'Mismatch found between supplied and plan design Dependant Coverage Start Date. Using the date in Plan Design: '||l_returned_strt_dt);
2340: END IF;
2341: END IF;
2342: */

Line 2384: fnd_file.put_line

2380: p_elig_per_elctbl_chc_id => l_epe.elig_per_elctbl_chc_id,
2381: p_egd => l_egd
2382: );
2383: --
2384: fnd_file.put_line
2385: (which => fnd_file.log,
2386: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2387: --
2388: IF l_egd.elig_dpnt_id IS NOT NULL THEN

Line 2385: (which => fnd_file.log,

2381: p_egd => l_egd
2382: );
2383: --
2384: fnd_file.put_line
2385: (which => fnd_file.log,
2386: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2387: --
2388: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2389: --

Line 2419: fnd_file.put_line

2415: p_elig_per_elctbl_chc_id => l_epe.elig_per_elctbl_chc_id,
2416: p_egd => l_egd
2417: );
2418: --
2419: fnd_file.put_line
2420: (which => fnd_file.log,
2421: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2422: --
2423: IF l_egd.elig_dpnt_id IS NOT NULL THEN

Line 2420: (which => fnd_file.log,

2416: p_egd => l_egd
2417: );
2418: --
2419: fnd_file.put_line
2420: (which => fnd_file.log,
2421: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2422: --
2423: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2424: --

Line 2610: fnd_file.put_line

2606: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2607: l_record_typ_cd := 'ENROLL';
2608: END IF;
2609: --
2610: fnd_file.put_line
2611: (which => fnd_file.log,
2612: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2613: --
2614: fnd_file.put_line

Line 2611: (which => fnd_file.log,

2607: l_record_typ_cd := 'ENROLL';
2608: END IF;
2609: --
2610: fnd_file.put_line
2611: (which => fnd_file.log,
2612: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2613: --
2614: fnd_file.put_line
2615: (which => fnd_file.log,

Line 2614: fnd_file.put_line

2610: fnd_file.put_line
2611: (which => fnd_file.log,
2612: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2613: --
2614: fnd_file.put_line
2615: (which => fnd_file.log,
2616: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2617: --
2618: fnd_file.put_line

Line 2615: (which => fnd_file.log,

2611: (which => fnd_file.log,
2612: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2613: --
2614: fnd_file.put_line
2615: (which => fnd_file.log,
2616: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2617: --
2618: fnd_file.put_line
2619: (which => fnd_file.log,

Line 2618: fnd_file.put_line

2614: fnd_file.put_line
2615: (which => fnd_file.log,
2616: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2617: --
2618: fnd_file.put_line
2619: (which => fnd_file.log,
2620: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2621: fnd_file.put_line
2622: (which => fnd_file.log,

Line 2619: (which => fnd_file.log,

2615: (which => fnd_file.log,
2616: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2617: --
2618: fnd_file.put_line
2619: (which => fnd_file.log,
2620: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2621: fnd_file.put_line
2622: (which => fnd_file.log,
2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);

Line 2621: fnd_file.put_line

2617: --
2618: fnd_file.put_line
2619: (which => fnd_file.log,
2620: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2621: fnd_file.put_line
2622: (which => fnd_file.log,
2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2624: fnd_file.put_line
2625: (which => fnd_file.log,

Line 2622: (which => fnd_file.log,

2618: fnd_file.put_line
2619: (which => fnd_file.log,
2620: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2621: fnd_file.put_line
2622: (which => fnd_file.log,
2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2624: fnd_file.put_line
2625: (which => fnd_file.log,
2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);

Line 2624: fnd_file.put_line

2620: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2621: fnd_file.put_line
2622: (which => fnd_file.log,
2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2624: fnd_file.put_line
2625: (which => fnd_file.log,
2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2627: fnd_file.put_line
2628: (which => fnd_file.log,

Line 2625: (which => fnd_file.log,

2621: fnd_file.put_line
2622: (which => fnd_file.log,
2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2624: fnd_file.put_line
2625: (which => fnd_file.log,
2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2627: fnd_file.put_line
2628: (which => fnd_file.log,
2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);

Line 2627: fnd_file.put_line

2623: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2624: fnd_file.put_line
2625: (which => fnd_file.log,
2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2627: fnd_file.put_line
2628: (which => fnd_file.log,
2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2630: fnd_file.put_line
2631: (which => fnd_file.log,

Line 2628: (which => fnd_file.log,

2624: fnd_file.put_line
2625: (which => fnd_file.log,
2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2627: fnd_file.put_line
2628: (which => fnd_file.log,
2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2630: fnd_file.put_line
2631: (which => fnd_file.log,
2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);

Line 2630: fnd_file.put_line

2626: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2627: fnd_file.put_line
2628: (which => fnd_file.log,
2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2630: fnd_file.put_line
2631: (which => fnd_file.log,
2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2633: fnd_file.put_line
2634: (which => fnd_file.log,

Line 2631: (which => fnd_file.log,

2627: fnd_file.put_line
2628: (which => fnd_file.log,
2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2630: fnd_file.put_line
2631: (which => fnd_file.log,
2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2633: fnd_file.put_line
2634: (which => fnd_file.log,
2635: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);

Line 2633: fnd_file.put_line

2629: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2630: fnd_file.put_line
2631: (which => fnd_file.log,
2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2633: fnd_file.put_line
2634: (which => fnd_file.log,
2635: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2636: fnd_file.put_line
2637: (which => fnd_file.log,

Line 2634: (which => fnd_file.log,

2630: fnd_file.put_line
2631: (which => fnd_file.log,
2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2633: fnd_file.put_line
2634: (which => fnd_file.log,
2635: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2636: fnd_file.put_line
2637: (which => fnd_file.log,
2638: buff => 'l_record_typ_cd '||l_record_typ_cd);

Line 2636: fnd_file.put_line

2632: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2633: fnd_file.put_line
2634: (which => fnd_file.log,
2635: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2636: fnd_file.put_line
2637: (which => fnd_file.log,
2638: buff => 'l_record_typ_cd '||l_record_typ_cd);
2639: --
2640: get_pil

Line 2637: (which => fnd_file.log,

2633: fnd_file.put_line
2634: (which => fnd_file.log,
2635: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2636: fnd_file.put_line
2637: (which => fnd_file.log,
2638: buff => 'l_record_typ_cd '||l_record_typ_cd);
2639: --
2640: get_pil
2641: (p_person_id => l_person_id,

Line 2799: fnd_file.put_line

2795: END IF;
2796: --
2797: ELSE
2798: --Bad case why are we here ???
2799: fnd_file.put_line
2800: (which => fnd_file.log,
2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);

Line 2800: (which => fnd_file.log,

2796: --
2797: ELSE
2798: --Bad case why are we here ???
2799: fnd_file.put_line
2800: (which => fnd_file.log,
2801: buff => 'Nothing happended... something wrong...');
2802: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2803: fnd_message.set_token('PROC',l_proc);
2804: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2817: fnd_file.put_line

2813: --
2814: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN
2815: IF l_record_typ_cd = 'POST' THEN
2816: --
2817: fnd_file.put_line
2818: (which => fnd_file.log,
2819: buff => 'Calling ben_plan_beneficiary_api.bnf_actn_items');
2820: --
2821: ben_plan_beneficiary_api.bnf_actn_items(

Line 2818: (which => fnd_file.log,

2814: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN
2815: IF l_record_typ_cd = 'POST' THEN
2816: --
2817: fnd_file.put_line
2818: (which => fnd_file.log,
2819: buff => 'Calling ben_plan_beneficiary_api.bnf_actn_items');
2820: --
2821: ben_plan_beneficiary_api.bnf_actn_items(
2822: p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id