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

Line 1: package body ben_ext_thread as

1: package body ben_ext_thread as
2: /* $Header: benxthrd.pkb 120.40.12010000.7 2008/10/01 13:20:17 vkodedal ship $ */
3:
4: /*
5: +==============================================================================+

Line 425: ben_ext_thread.g_err_num := 91873;

421: p_cm_display_flag
422: ;
423: --
424: if ext_dfn_c%notfound then
425: ben_ext_thread.g_err_num := 91873;
426: ben_ext_thread.g_err_name := 'BEN_91873_EXT_NOT_FOUND';
427: close ext_dfn_c;
428: raise g_job_failure_error;
429: end if;

Line 426: ben_ext_thread.g_err_name := 'BEN_91873_EXT_NOT_FOUND';

422: ;
423: --
424: if ext_dfn_c%notfound then
425: ben_ext_thread.g_err_num := 91873;
426: ben_ext_thread.g_err_name := 'BEN_91873_EXT_NOT_FOUND';
427: close ext_dfn_c;
428: raise g_job_failure_error;
429: end if;
430: --

Line 976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);

972: close c_rule_type;
973:
974: if g_debug then
975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);
976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);
977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);
978: end if;
979: if l_rule_type.formula_type_id = -546 then
980: l_outputs := benutils.formula

Line 977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);

973:
974: if g_debug then
975: hr_utility.set_location(' rule type :'||l_rule_type.formula_type_id, 39);
976: hr_utility.set_location(' ext_dfn_id :'||ben_ext_thread.g_ext_dfn_id, 39);
977: hr_utility.set_location(' rslt id :'||ben_ext_thread.g_ext_rslt_id, 39);
978: end if;
979: if l_rule_type.formula_type_id = -546 then
980: l_outputs := benutils.formula
981: (p_formula_id => p_data_elmt_rl,

Line 985: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))

981: (p_formula_id => p_data_elmt_rl,
982: p_effective_date => p_effective_date ,
983: p_business_group_id => nvl(p_ext_per_bg_id, p_business_group_id)
984: ,p_param1 => 'EXT_DFN_ID'
985: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
986: ,p_param2 => 'EXT_RSLT_ID'
987: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
988: ,p_param3 => 'EXT_USER_VALUE'
989: ,p_param3_value => p_string_val

Line 987: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))

983: p_business_group_id => nvl(p_ext_per_bg_id, p_business_group_id)
984: ,p_param1 => 'EXT_DFN_ID'
985: ,p_param1_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1))
986: ,p_param2 => 'EXT_RSLT_ID'
987: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_rslt_id, -1))
988: ,p_param3 => 'EXT_USER_VALUE'
989: ,p_param3_value => p_string_val
990: ,p_param4 => 'EXT_PROCESS_BUSINESS_GROUP'
991: ,p_param4_value => to_char(p_business_group_id)

Line 1309: ben_ext_thread.g_ext_group_elmt1 is not null then

1305:
1306: END IF;
1307:
1308: if p_rcd_typ_cd <> 'L' and g_subtrl_cnt = 0 and
1309: ben_ext_thread.g_ext_group_elmt1 is not null then
1310: open get_subtrl_cnt ;
1311: fetch get_subtrl_cnt into g_subtrl_cnt ;
1312: close get_subtrl_cnt ;
1313: end if ;

Line 1887: raise ben_ext_thread.g_job_failure_error;

1883: p_request_id => fnd_global.conc_request_id,
1884: p_ext_rslt_id => p_ext_rslt_id,
1885: p_business_group_id => p_business_group_id
1886: );
1887: raise ben_ext_thread.g_job_failure_error;
1888: --
1889: when others then
1890:
1891: rollback to head_trail;

Line 2306: -- MH moved call to thread level (ben_ext_thread.do_multithread)

2302: ,p_chunk_size => l_chunk_size
2303: ,p_max_errors => g_max_errors_allowed);
2304: --
2305: --
2306: -- MH moved call to thread level (ben_ext_thread.do_multithread)
2307: -- rather than chunk level to minimize
2308: -- memory consumption
2309: --
2310: -- Determine extract Levels

Line 2408: ben_ext_thread.g_err_num := 92184;

2404: l_line := 6;
2405: --
2406: -- halt all other threads when job failure.
2407: if l_failure_in_other_thread then
2408: ben_ext_thread.g_err_num := 92184;
2409: ben_ext_thread.g_err_name := 'BEN_92184_THREAD_HALTED';
2410: raise g_job_failure_error;
2411: end if;
2412: --

Line 2409: ben_ext_thread.g_err_name := 'BEN_92184_THREAD_HALTED';

2405: --
2406: -- halt all other threads when job failure.
2407: if l_failure_in_other_thread then
2408: ben_ext_thread.g_err_num := 92184;
2409: ben_ext_thread.g_err_name := 'BEN_92184_THREAD_HALTED';
2410: raise g_job_failure_error;
2411: end if;
2412: --
2413: l_line := 7;

Line 2441: if ben_ext_thread.g_err_num <> 92184 then --don't write if halt warning.

2437: where range_id = l_range_id;
2438: --
2439: -- write to the extract error table, so error will be reported
2440: -- on the error report and viewed on the extract result form.
2441: if ben_ext_thread.g_err_num <> 92184 then --don't write if halt warning.
2442: write_error(p_err_num => ben_ext_thread.g_err_num,
2443: p_err_name => null , --ben_ext_thread.g_err_name,
2444: p_typ_cd => 'F',
2445: p_person_id => null,

Line 2442: write_error(p_err_num => ben_ext_thread.g_err_num,

2438: --
2439: -- write to the extract error table, so error will be reported
2440: -- on the error report and viewed on the extract result form.
2441: if ben_ext_thread.g_err_num <> 92184 then --don't write if halt warning.
2442: write_error(p_err_num => ben_ext_thread.g_err_num,
2443: p_err_name => null , --ben_ext_thread.g_err_name,
2444: p_typ_cd => 'F',
2445: p_person_id => null,
2446: p_request_id => p_request_id,

Line 2443: p_err_name => null , --ben_ext_thread.g_err_name,

2439: -- write to the extract error table, so error will be reported
2440: -- on the error report and viewed on the extract result form.
2441: if ben_ext_thread.g_err_num <> 92184 then --don't write if halt warning.
2442: write_error(p_err_num => ben_ext_thread.g_err_num,
2443: p_err_name => null , --ben_ext_thread.g_err_name,
2444: p_typ_cd => 'F',
2445: p_person_id => null,
2446: p_request_id => p_request_id,
2447: p_ext_rslt_id => p_ext_rslt_id,

Line 2462: if ben_ext_thread.g_err_num <> 92184 then

2458: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2459: --
2460: -- write the error message to the log file.
2461: --
2462: if ben_ext_thread.g_err_num <> 92184 then
2463: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2464: fnd_file.put_line(fnd_file.log, fnd_message.get);
2465: fnd_file.put_line(fnd_file.log, ' ');
2466: end if;

Line 2467: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);

2463: fnd_message.set_name('BEN', 'BEN_92186_THREAD_FAILURE');
2464: fnd_file.put_line(fnd_file.log, fnd_message.get);
2465: fnd_file.put_line(fnd_file.log, ' ');
2466: end if;
2467: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);
2468: fnd_file.put_line(fnd_file.log, fnd_message.get);
2469: --
2470: -- if slave process, we are done. If master process, raise job failure in
2471: -- calling program (ben_ext_thread.process)

Line 2471: -- calling program (ben_ext_thread.process)

2467: fnd_message.set_name('BEN', ben_ext_thread.g_err_name);
2468: fnd_file.put_line(fnd_file.log, fnd_message.get);
2469: --
2470: -- if slave process, we are done. If master process, raise job failure in
2471: -- calling program (ben_ext_thread.process)
2472: --
2473: end if;
2474: --
2475: if p_master_process_flag = 'Y' then

Line 2493: -- calling program (ben_ext_thread.process)

2489: --
2490: fnd_message.set_name('BEN', 'BEN_92190_THREAD_LABEL');
2491: fnd_file.put_line(fnd_file.log, fnd_message.get || ' ' ||to_char(p_thread_id));
2492: -- if slave process, we are done. If master process, raise job failure in
2493: -- calling program (ben_ext_thread.process)
2494: --
2495: if p_master_process_flag = 'Y' then
2496: raise;
2497: else -- slave

Line 3536: ben_ext_thread.g_err_num := 94264;

3532:
3533: if g_chg_ext_from_pay = 'Y' and ( l_cpe_exclude = 'Y' or l_cad_exclude = 'Y' or l_ced_exclude = 'Y' ) then
3534: -- with payroll cahnge event exclude criteria on Event groups or Effective date or Actaul date is not allowed
3535:
3536: ben_ext_thread.g_err_num := 94264;
3537: ben_ext_thread.g_err_name := 'BEN_94264_EXT_PAY_CHG_EXCLD';
3538: raise g_job_failure_error;
3539: end if ;
3540:

Line 3537: ben_ext_thread.g_err_name := 'BEN_94264_EXT_PAY_CHG_EXCLD';

3533: if g_chg_ext_from_pay = 'Y' and ( l_cpe_exclude = 'Y' or l_cad_exclude = 'Y' or l_ced_exclude = 'Y' ) then
3534: -- with payroll cahnge event exclude criteria on Event groups or Effective date or Actaul date is not allowed
3535:
3536: ben_ext_thread.g_err_num := 94264;
3537: ben_ext_thread.g_err_name := 'BEN_94264_EXT_PAY_CHG_EXCLD';
3538: raise g_job_failure_error;
3539: end if ;
3540:
3541:

Line 5621: ben_ext_thread.g_err_num := 91919;

5617: -- if customer pass one parameter errro
5618: if ( p_eff_start_date is not null and p_eff_end_date is null )
5619: or ( p_act_start_date is not null and p_act_end_date is null )
5620: then
5621: ben_ext_thread.g_err_num := 91919;
5622: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';
5623: raise g_job_failure_error;
5624:
5625: end if ;

Line 5622: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';

5618: if ( p_eff_start_date is not null and p_eff_end_date is null )
5619: or ( p_act_start_date is not null and p_act_end_date is null )
5620: then
5621: ben_ext_thread.g_err_num := 91919;
5622: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';
5623: raise g_job_failure_error;
5624:
5625: end if ;
5626:

Line 5683: ben_ext_thread.g_err_num := 91917;

5679: );
5680: --
5681: if l_ext_file_id is null then
5682: --
5683: ben_ext_thread.g_err_num := 91917;
5684: ben_ext_thread.g_err_name := 'BEN_91917_EXT_FILE_NULL';
5685: raise g_job_failure_error;
5686: --
5687: end if;

Line 5684: ben_ext_thread.g_err_name := 'BEN_91917_EXT_FILE_NULL';

5680: --
5681: if l_ext_file_id is null then
5682: --
5683: ben_ext_thread.g_err_num := 91917;
5684: ben_ext_thread.g_err_name := 'BEN_91917_EXT_FILE_NULL';
5685: raise g_job_failure_error;
5686: --
5687: end if;
5688:

Line 5741: ben_ext_thread.g_err_num := 92080;

5737: --
5738: END IF;
5739: --
5740: if l_ext_end_dt < l_ext_strt_dt then
5741: ben_ext_thread.g_err_num := 92080;
5742: ben_ext_thread.g_err_name := 'BEN_92080_EXT_STRT_END_DT';
5743: raise g_job_failure_error;
5744: end if;
5745: --

Line 5742: ben_ext_thread.g_err_name := 'BEN_92080_EXT_STRT_END_DT';

5738: END IF;
5739: --
5740: if l_ext_end_dt < l_ext_strt_dt then
5741: ben_ext_thread.g_err_num := 92080;
5742: ben_ext_thread.g_err_name := 'BEN_92080_EXT_STRT_END_DT';
5743: raise g_job_failure_error;
5744: end if;
5745: --
5746: g_ext_end_dt := l_ext_end_dt;

Line 5749: ben_ext_thread.g_err_num := 91918;

5745: --
5746: g_ext_end_dt := l_ext_end_dt;
5747: --
5748: if l_ext_strt_dt is null then
5749: ben_ext_thread.g_err_num := 91918;
5750: ben_ext_thread.g_err_name := 'BEN_91918_EXT_STRT_DT_NULL';
5751: raise g_job_failure_error;
5752: end if;
5753: --

Line 5750: ben_ext_thread.g_err_name := 'BEN_91918_EXT_STRT_DT_NULL';

5746: g_ext_end_dt := l_ext_end_dt;
5747: --
5748: if l_ext_strt_dt is null then
5749: ben_ext_thread.g_err_num := 91918;
5750: ben_ext_thread.g_err_name := 'BEN_91918_EXT_STRT_DT_NULL';
5751: raise g_job_failure_error;
5752: end if;
5753: --
5754: if l_ext_end_dt is null then

Line 5755: ben_ext_thread.g_err_num := 91919;

5751: raise g_job_failure_error;
5752: end if;
5753: --
5754: if l_ext_end_dt is null then
5755: ben_ext_thread.g_err_num := 91919;
5756: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';
5757: raise g_job_failure_error;
5758: end if;
5759: --

Line 5756: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';

5752: end if;
5753: --
5754: if l_ext_end_dt is null then
5755: ben_ext_thread.g_err_num := 91919;
5756: ben_ext_thread.g_err_name := 'BEN_91919_EXT_END_DT_NULL';
5757: raise g_job_failure_error;
5758: end if;
5759: --
5760: */

Line 6240: p_ext_group_elmt1 => ben_ext_thread.g_ext_group_elmt1,

6236: p_rcd_typ_cd => 'L',
6237: p_business_group_id => p_business_group_id,
6238: p_effective_date => l_effective_date,
6239: p_request_id => l_conc_request_id,
6240: p_ext_group_elmt1 => ben_ext_thread.g_ext_group_elmt1,
6241: p_ext_group_elmt2 => ben_ext_thread.g_ext_group_elmt2,
6242: p_ext_crit_prfl_id => l_ext_crit_prfl_id);
6243: --
6244: -- Process Footer Records

Line 6241: p_ext_group_elmt2 => ben_ext_thread.g_ext_group_elmt2,

6237: p_business_group_id => p_business_group_id,
6238: p_effective_date => l_effective_date,
6239: p_request_id => l_conc_request_id,
6240: p_ext_group_elmt1 => ben_ext_thread.g_ext_group_elmt1,
6241: p_ext_group_elmt2 => ben_ext_thread.g_ext_group_elmt2,
6242: p_ext_crit_prfl_id => l_ext_crit_prfl_id);
6243: --
6244: -- Process Footer Records
6245:

Line 6289: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1)));

6285: p_param1 => 'EXT_RSLT_ID',
6286: p_param1_value => to_char(l_ext_rslt_id)
6287: --RChase pass extract definition id as input value
6288: ,p_param2 => 'EXT_DFN_ID'
6289: ,p_param2_value => to_char(nvl(ben_ext_thread.g_ext_dfn_id, -1)));
6290: --
6291: end if;
6292: --
6293: commit; -- anything that the formula did.

Line 7296: End ben_ext_thread;

7292: end Load_extract;
7293:
7294:
7295: --
7296: End ben_ext_thread;