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 791: fnd_file.put_line

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

Line 792: (which => fnd_file.log,

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

Line 794: fnd_file.put_line

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

Line 795: (which => fnd_file.log,

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

Line 798: fnd_file.put_line

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

Line 799: (which => fnd_file.log,

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

Line 801: fnd_file.put_line

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

Line 802: (which => fnd_file.log,

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

Line 804: fnd_file.put_line

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

Line 805: (which => fnd_file.log,

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

Line 808: fnd_file.put_line

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

Line 809: (which => fnd_file.log,

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

Line 1789: fnd_file.put_line

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

Line 1790: (which => fnd_file.log,

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

Line 2204: fnd_file.put_line

2200: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2201: l_record_typ_cd := 'ENROLL' ;
2202: END IF;
2203: --
2204: fnd_file.put_line
2205: (which => fnd_file.log,
2206: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2207: fnd_file.put_line
2208: (which => fnd_file.log,

Line 2205: (which => fnd_file.log,

2201: l_record_typ_cd := 'ENROLL' ;
2202: END IF;
2203: --
2204: fnd_file.put_line
2205: (which => fnd_file.log,
2206: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2207: fnd_file.put_line
2208: (which => fnd_file.log,
2209: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);

Line 2207: fnd_file.put_line

2203: --
2204: fnd_file.put_line
2205: (which => fnd_file.log,
2206: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2207: fnd_file.put_line
2208: (which => fnd_file.log,
2209: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2210: --
2211: fnd_file.put_line

Line 2208: (which => fnd_file.log,

2204: fnd_file.put_line
2205: (which => fnd_file.log,
2206: buff => 'Entering - BEN_ENROLLMENT_PROCESS.PROCESS_DEPENDENT' );
2207: fnd_file.put_line
2208: (which => fnd_file.log,
2209: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,

Line 2211: fnd_file.put_line

2207: fnd_file.put_line
2208: (which => fnd_file.log,
2209: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2214: fnd_file.put_line
2215: (which => fnd_file.log,

Line 2212: (which => fnd_file.log,

2208: (which => fnd_file.log,
2209: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_record_typ_cd '||l_record_typ_cd);

Line 2214: fnd_file.put_line

2210: --
2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_record_typ_cd '||l_record_typ_cd);
2217: fnd_file.put_line
2218: (which => fnd_file.log,

Line 2215: (which => fnd_file.log,

2211: fnd_file.put_line
2212: (which => fnd_file.log,
2213: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_record_typ_cd '||l_record_typ_cd);
2217: fnd_file.put_line
2218: (which => fnd_file.log,
2219: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);

Line 2217: fnd_file.put_line

2213: buff => 'l_opt_id '||l_opt_id||' l_ler_id '||l_ler_id);
2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_record_typ_cd '||l_record_typ_cd);
2217: fnd_file.put_line
2218: (which => fnd_file.log,
2219: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2220: fnd_file.put_line
2221: (which => fnd_file.log,

Line 2218: (which => fnd_file.log,

2214: fnd_file.put_line
2215: (which => fnd_file.log,
2216: buff => 'l_record_typ_cd '||l_record_typ_cd);
2217: fnd_file.put_line
2218: (which => fnd_file.log,
2219: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2220: fnd_file.put_line
2221: (which => fnd_file.log,
2222: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);

Line 2220: fnd_file.put_line

2216: buff => 'l_record_typ_cd '||l_record_typ_cd);
2217: fnd_file.put_line
2218: (which => fnd_file.log,
2219: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2220: fnd_file.put_line
2221: (which => fnd_file.log,
2222: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);
2223: --
2224: get_pil

Line 2221: (which => fnd_file.log,

2217: fnd_file.put_line
2218: (which => fnd_file.log,
2219: buff => 'l_life_event_date '||l_life_event_date||' l_contact_person_id '||l_contact_person_id);
2220: fnd_file.put_line
2221: (which => fnd_file.log,
2222: buff => 'l_cvg_strt_dt '||l_cvg_strt_dt||' l_cvg_thru_dt '||l_cvg_thru_dt);
2223: --
2224: get_pil
2225: (p_person_id => l_person_id,

Line 2231: fnd_file.put_line

2227: p_life_event_date => l_life_event_date,
2228: p_pil => l_pil
2229: );
2230: --
2231: fnd_file.put_line
2232: (which => fnd_file.log,
2233: buff => 'l_pil.per_in_ler_id '||l_pil.per_in_ler_id);
2234: --Get EPE
2235: IF l_pil.per_in_ler_id IS NOT NULL THEN

Line 2232: (which => fnd_file.log,

2228: p_pil => l_pil
2229: );
2230: --
2231: fnd_file.put_line
2232: (which => fnd_file.log,
2233: buff => 'l_pil.per_in_ler_id '||l_pil.per_in_ler_id);
2234: --Get EPE
2235: IF l_pil.per_in_ler_id IS NOT NULL THEN
2236: get_epe

Line 2245: fnd_file.put_line

2241: p_pl_id => l_pl_id,
2242: p_pgm_id => l_pgm_id,
2243: p_epe => l_epe
2244: ) ;
2245: fnd_file.put_line
2246: (which => fnd_file.log,
2247: buff => 'l_epe.elig_per_elctbl_chc_id '||l_epe.elig_per_elctbl_chc_id);
2248: --
2249: --Find if there is a valid enrollment result exists for this epe and pil

Line 2246: (which => fnd_file.log,

2242: p_pgm_id => l_pgm_id,
2243: p_epe => l_epe
2244: ) ;
2245: fnd_file.put_line
2246: (which => fnd_file.log,
2247: buff => 'l_epe.elig_per_elctbl_chc_id '||l_epe.elig_per_elctbl_chc_id);
2248: --
2249: --Find if there is a valid enrollment result exists for this epe and pil
2250: --If not throw error.

Line 2317: fnd_file.put_line

2313: IF l_cvg_thru_dt IS NULL THEN
2314: l_returned_end_dt := NULL;
2315: ELSIF l_cvg_thru_dt <> l_returned_end_dt THEN
2316: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Through Date.
2317: fnd_file.put_line
2318: (which => fnd_file.log,
2319: buff => 'Mismatch found between supplied and plan design Dependant Coverage Through Date. Using the date in Plan Design: '||l_returned_end_dt);
2320: NULL;
2321: end if;

Line 2318: (which => fnd_file.log,

2314: l_returned_end_dt := NULL;
2315: ELSIF l_cvg_thru_dt <> l_returned_end_dt THEN
2316: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Through Date.
2317: fnd_file.put_line
2318: (which => fnd_file.log,
2319: buff => 'Mismatch found between supplied and plan design Dependant Coverage Through Date. Using the date in Plan Design: '||l_returned_end_dt);
2320: NULL;
2321: end if;
2322: --

Line 2328: fnd_file.put_line

2324: NULL;
2325: ELSIF l_cvg_strt_dt <> l_returned_strt_dt THEN
2326: 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.
2327: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Start Date.
2328: fnd_file.put_line
2329: (which => fnd_file.log,
2330: buff => 'Mismatch found between supplied and plan design Dependant Coverage Start Date. Using the date in Plan Design: '||l_returned_strt_dt);
2331: END IF;
2332: END IF;

Line 2329: (which => fnd_file.log,

2325: ELSIF l_cvg_strt_dt <> l_returned_strt_dt THEN
2326: 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.
2327: --Make entry in log file indicating mismatch between the supplied and plan design Coverge Start Date.
2328: fnd_file.put_line
2329: (which => fnd_file.log,
2330: buff => 'Mismatch found between supplied and plan design Dependant Coverage Start Date. Using the date in Plan Design: '||l_returned_strt_dt);
2331: END IF;
2332: END IF;
2333: --

Line 2351: fnd_file.put_line

2347: p_elig_per_elctbl_chc_id => l_epe.elig_per_elctbl_chc_id,
2348: p_egd => l_egd
2349: );
2350: --
2351: fnd_file.put_line
2352: (which => fnd_file.log,
2353: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2354: --
2355: IF l_egd.elig_dpnt_id IS NOT NULL THEN

Line 2352: (which => fnd_file.log,

2348: p_egd => l_egd
2349: );
2350: --
2351: fnd_file.put_line
2352: (which => fnd_file.log,
2353: buff => ' l_egd.elig_dpnt_id '||l_egd.elig_dpnt_id);
2354: --
2355: IF l_egd.elig_dpnt_id IS NOT NULL THEN
2356: --

Line 2386: fnd_file.put_line

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

Line 2387: (which => fnd_file.log,

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

Line 2577: fnd_file.put_line

2573: IF l_record_typ_cd = hr_api.g_varchar2 THEN
2574: l_record_typ_cd := 'ENROLL';
2575: END IF;
2576: --
2577: fnd_file.put_line
2578: (which => fnd_file.log,
2579: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2580: --
2581: fnd_file.put_line

Line 2578: (which => fnd_file.log,

2574: l_record_typ_cd := 'ENROLL';
2575: END IF;
2576: --
2577: fnd_file.put_line
2578: (which => fnd_file.log,
2579: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2580: --
2581: fnd_file.put_line
2582: (which => fnd_file.log,

Line 2581: fnd_file.put_line

2577: fnd_file.put_line
2578: (which => fnd_file.log,
2579: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2580: --
2581: fnd_file.put_line
2582: (which => fnd_file.log,
2583: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2584: --
2585: fnd_file.put_line

Line 2582: (which => fnd_file.log,

2578: (which => fnd_file.log,
2579: buff => 'Entering - ben_enrollment_process.process_beneficiary' );
2580: --
2581: fnd_file.put_line
2582: (which => fnd_file.log,
2583: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2584: --
2585: fnd_file.put_line
2586: (which => fnd_file.log,

Line 2585: fnd_file.put_line

2581: fnd_file.put_line
2582: (which => fnd_file.log,
2583: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2584: --
2585: fnd_file.put_line
2586: (which => fnd_file.log,
2587: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2588: fnd_file.put_line
2589: (which => fnd_file.log,

Line 2586: (which => fnd_file.log,

2582: (which => fnd_file.log,
2583: buff => 'l_person_id '||l_person_id||' l_pgm_id '||l_pgm_id||' l_pl_id '||l_pl_id);
2584: --
2585: fnd_file.put_line
2586: (which => fnd_file.log,
2587: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2588: fnd_file.put_line
2589: (which => fnd_file.log,
2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);

Line 2588: fnd_file.put_line

2584: --
2585: fnd_file.put_line
2586: (which => fnd_file.log,
2587: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2588: fnd_file.put_line
2589: (which => fnd_file.log,
2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2591: fnd_file.put_line
2592: (which => fnd_file.log,

Line 2589: (which => fnd_file.log,

2585: fnd_file.put_line
2586: (which => fnd_file.log,
2587: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2588: fnd_file.put_line
2589: (which => fnd_file.log,
2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2591: fnd_file.put_line
2592: (which => fnd_file.log,
2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);

Line 2591: fnd_file.put_line

2587: buff => 'l_opt_id '||l_opt_id||' l_bnft_val '||l_bnft_val||' l_ler_id '||l_ler_id);
2588: fnd_file.put_line
2589: (which => fnd_file.log,
2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2591: fnd_file.put_line
2592: (which => fnd_file.log,
2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2594: fnd_file.put_line
2595: (which => fnd_file.log,

Line 2592: (which => fnd_file.log,

2588: fnd_file.put_line
2589: (which => fnd_file.log,
2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2591: fnd_file.put_line
2592: (which => fnd_file.log,
2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2594: fnd_file.put_line
2595: (which => fnd_file.log,
2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);

Line 2594: fnd_file.put_line

2590: buff => 'l_pct_dsgd_num '||l_pct_dsgd_num||' l_amt_dsgd_val '||l_amt_dsgd_val);
2591: fnd_file.put_line
2592: (which => fnd_file.log,
2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2594: fnd_file.put_line
2595: (which => fnd_file.log,
2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2597: fnd_file.put_line
2598: (which => fnd_file.log,

Line 2595: (which => fnd_file.log,

2591: fnd_file.put_line
2592: (which => fnd_file.log,
2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2594: fnd_file.put_line
2595: (which => fnd_file.log,
2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2597: fnd_file.put_line
2598: (which => fnd_file.log,
2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);

Line 2597: fnd_file.put_line

2593: buff => 'l_addl_instrn_txt '||l_addl_instrn_txt);
2594: fnd_file.put_line
2595: (which => fnd_file.log,
2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2597: fnd_file.put_line
2598: (which => fnd_file.log,
2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2600: fnd_file.put_line
2601: (which => fnd_file.log,

Line 2598: (which => fnd_file.log,

2594: fnd_file.put_line
2595: (which => fnd_file.log,
2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2597: fnd_file.put_line
2598: (which => fnd_file.log,
2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2600: fnd_file.put_line
2601: (which => fnd_file.log,
2602: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);

Line 2600: fnd_file.put_line

2596: buff => 'l_organization_id '||l_organization_id||' l_ttee_person_id '||l_ttee_person_id);
2597: fnd_file.put_line
2598: (which => fnd_file.log,
2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2600: fnd_file.put_line
2601: (which => fnd_file.log,
2602: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2603: fnd_file.put_line
2604: (which => fnd_file.log,

Line 2601: (which => fnd_file.log,

2597: fnd_file.put_line
2598: (which => fnd_file.log,
2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2600: fnd_file.put_line
2601: (which => fnd_file.log,
2602: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2603: fnd_file.put_line
2604: (which => fnd_file.log,
2605: buff => 'l_record_typ_cd '||l_record_typ_cd);

Line 2603: fnd_file.put_line

2599: buff => 'l_life_event_date '||l_life_event_date||' l_bnf_person_id '||l_bnf_person_id);
2600: fnd_file.put_line
2601: (which => fnd_file.log,
2602: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2603: fnd_file.put_line
2604: (which => fnd_file.log,
2605: buff => 'l_record_typ_cd '||l_record_typ_cd);
2606: --
2607: get_pil

Line 2604: (which => fnd_file.log,

2600: fnd_file.put_line
2601: (which => fnd_file.log,
2602: buff => 'l_dsgn_strt_dt '||l_dsgn_strt_dt||' l_dsgn_thru_dt '||l_dsgn_thru_dt);
2603: fnd_file.put_line
2604: (which => fnd_file.log,
2605: buff => 'l_record_typ_cd '||l_record_typ_cd);
2606: --
2607: get_pil
2608: (p_person_id => l_person_id,

Line 2766: fnd_file.put_line

2762: END IF;
2763: --
2764: ELSE
2765: --Bad case why are we here ???
2766: fnd_file.put_line
2767: (which => fnd_file.log,
2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);

Line 2767: (which => fnd_file.log,

2763: --
2764: ELSE
2765: --Bad case why are we here ???
2766: fnd_file.put_line
2767: (which => fnd_file.log,
2768: buff => 'Nothing happended... something wrong...');
2769: fnd_message.set_name('BEN','BEN_94615_BNF_WRONG_IF');
2770: fnd_message.set_token('PROC',l_proc);
2771: fnd_message.set_token('PERSON_ID',to_char(p_person_id));

Line 2784: fnd_file.put_line

2780: --
2781: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN
2782: IF l_record_typ_cd = 'POST' THEN
2783: --
2784: fnd_file.put_line
2785: (which => fnd_file.log,
2786: buff => 'Calling ben_plan_beneficiary_api.bnf_actn_items');
2787: --
2788: ben_plan_beneficiary_api.bnf_actn_items(

Line 2785: (which => fnd_file.log,

2781: -- IF l_prtt_enrt_rslt_id IS NOT NULL THEN
2782: IF l_record_typ_cd = 'POST' THEN
2783: --
2784: fnd_file.put_line
2785: (which => fnd_file.log,
2786: buff => 'Calling ben_plan_beneficiary_api.bnf_actn_items');
2787: --
2788: ben_plan_beneficiary_api.bnf_actn_items(
2789: p_prtt_enrt_rslt_id => l_prtt_enrt_rslt_id