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_EXT_PERSON dependencies on BEN_EXT_THREAD

Line 3270: if ben_ext_thread.g_effective_start_date is not null then

3266: p_chg_eff_strt_dt => l_chg_eff_strt_dt, --out
3267: p_chg_eff_end_dt => l_chg_eff_end_dt); --out
3268:
3269: -- if the parameter passed from extract , then overide the criteria dates
3270: if ben_ext_thread.g_effective_start_date is not null then
3271: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3273: end if ;
3274:

Line 3271: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;

3267: p_chg_eff_end_dt => l_chg_eff_end_dt); --out
3268:
3269: -- if the parameter passed from extract , then overide the criteria dates
3270: if ben_ext_thread.g_effective_start_date is not null then
3271: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3273: end if ;
3274:
3275: if ben_ext_thread.g_actual_start_date is not null then

Line 3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;

3268:
3269: -- if the parameter passed from extract , then overide the criteria dates
3270: if ben_ext_thread.g_effective_start_date is not null then
3271: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3273: end if ;
3274:
3275: if ben_ext_thread.g_actual_start_date is not null then
3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;

Line 3275: if ben_ext_thread.g_actual_start_date is not null then

3271: l_chg_eff_strt_dt := ben_ext_thread.g_effective_start_date ;
3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3273: end if ;
3274:
3275: if ben_ext_thread.g_actual_start_date is not null then
3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3278: end if ;
3279:

Line 3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;

3272: l_chg_eff_end_dt := ben_ext_thread.g_effective_end_date ;
3273: end if ;
3274:
3275: if ben_ext_thread.g_actual_start_date is not null then
3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3278: end if ;
3279:
3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );

Line 3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;

3273: end if ;
3274:
3275: if ben_ext_thread.g_actual_start_date is not null then
3276: l_chg_actl_strt_dt := ben_ext_thread.g_actual_start_date ;
3277: l_chg_actl_end_dt := ben_ext_thread.g_actual_end_date ;
3278: end if ;
3279:
3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );

Line 3283: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then

3279:
3280: hr_utility.set_location( 'chg actl date ' || l_chg_actl_strt_dt || ' / ' || l_chg_actl_end_dt, 99 );
3281: hr_utility.set_location( 'chg eff date ' || l_chg_eff_strt_dt || ' / ' || l_chg_eff_end_dt , 99 );
3282: --
3283: if ben_ext_thread.g_chg_ext_from_ben = 'Y' then
3284: hr_utility.set_location( ' extract chg evt log included ' , 99 );
3285: open c_changes_only_extract (l_chg_actl_strt_dt,
3286: l_chg_actl_end_dt,
3287: l_chg_eff_strt_dt,

Line 3503: if ben_ext_thread.g_chg_ext_from_pay = 'Y' then

3499: --
3500: end if ; --- for extract chg logs
3501:
3502:
3503: if ben_ext_thread.g_chg_ext_from_pay = 'Y' then
3504: hr_utility.set_location( ' PAY event log included ' , 99 );
3505: -- Loop thorough all the assignment id for a person
3506: -- within the extract period
3507: --- get the primary assg as of effective date

Line 5570: if l_err_num >= ben_ext_thread.g_max_errors_allowed then

5566: fetch err_cnt_c into l_err_num;
5567: close err_cnt_c;
5568: --
5569:
5570: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5571: --
5572: ben_ext_thread.g_err_num := 91947;
5573: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5574: raise ben_ext_thread.g_job_failure_error;

Line 5572: ben_ext_thread.g_err_num := 91947;

5568: --
5569:
5570: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5571: --
5572: ben_ext_thread.g_err_num := 91947;
5573: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5574: raise ben_ext_thread.g_job_failure_error;
5575: --
5576: end if;

Line 5573: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';

5569:
5570: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5571: --
5572: ben_ext_thread.g_err_num := 91947;
5573: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5574: raise ben_ext_thread.g_job_failure_error;
5575: --
5576: end if;
5577: --

Line 5574: raise ben_ext_thread.g_job_failure_error;

5570: if l_err_num >= ben_ext_thread.g_max_errors_allowed then
5571: --
5572: ben_ext_thread.g_err_num := 91947;
5573: ben_ext_thread.g_err_name := 'BEN_91947_EXT_MX_ERR_NUM';
5574: raise ben_ext_thread.g_job_failure_error;
5575: --
5576: end if;
5577: --
5578: if g_business_group_id is not null then