DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on FND_FILE

Line 419: fnd_file.put_line(fnd_file.log, p_cwb_person_type );

415: -- for the CWB Process.
416: IF p_mode_cd = 'W' THEN
417: --
418: hr_utility.set_location(' p_cwb_person_type '||p_cwb_person_type, 19);
419: fnd_file.put_line(fnd_file.log, p_cwb_person_type );
420: if nvl(p_cwb_person_type,'AEXE') = 'AEXE'
421: then
422: l_cwb_whclause := ' and exists ( select ''x'' from per_person_type_usages_f ptu, '||
423: ' per_person_types ppt '||

Line 468: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );

464: else
465: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
466: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
467: --
468: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
469: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
470:
471: if p_popl_enrt_typ_cycl_id is not null
472: and p_lf_evt_ocrd_dt is not null

Line 469: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );

465: hr_utility.set_location(' p_popl_enrt_typ_cycl_id '|| p_popl_enrt_typ_cycl_id, 19);
466: hr_utility.set_location(' p_lf_evt_ocrd_dt '|| p_lf_evt_ocrd_dt, 19);
467: --
468: fnd_file.put_line(fnd_file.log, p_popl_enrt_typ_cycl_id );
469: fnd_file.put_line(fnd_file.log, p_lf_evt_ocrd_dt );
470:
471: if p_popl_enrt_typ_cycl_id is not null
472: and p_lf_evt_ocrd_dt is not null
473: then

Line 479: fnd_file.put_line(fnd_file.log, l_wth_start_date );

475: fetch c_cwb_asg_date_chk into l_wth_start_date, l_wth_end_date ;
476: close c_cwb_asg_date_chk;
477: --
478: hr_utility.set_location(' l_wth_start_date '|| l_wth_start_date, 19);
479: fnd_file.put_line(fnd_file.log, l_wth_start_date );
480: --
481: if l_wth_start_date is not null
482: then
483: l_cwb_whclause := l_cwb_whclause

Line 859: -- fnd_file.put_line(fnd_file.log, l_query_str );

855: ' order by paf1.organization_id';
856: --
857: END IF;
858: --
859: -- fnd_file.put_line(fnd_file.log, l_query_str );
860: -- Open the query using business_group_id as the bind variable.
861: --
862: OPEN c_person FOR l_query_str
863: USING p_business_group_id