DBA Data[Home] [Help]

APPS.BEN_BENBATCH_PERSONS dependencies on FND_FILE

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

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

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

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

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

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

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

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

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

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