APPS.BEN_EXTRACT dependencies on BEN_EXT_PERSON

Line 37: -- since they never get proccessed in xtrct_skltn. Also, ben_ext_person.process_ext_recs

33: where a.ext_rcd_id = b.ext_rcd_id
34: and b.ext_file_id = p_ext_file_id
35: and b.rqd_flag = 'Y'
36: -- Bug fix 1702733 - header/trailer type records should not be checked for required flag = 'Y' here
37: -- since they never get proccessed in xtrct_skltn. Also, ben_ext_person.process_ext_recs
38: -- processes only Detail Type records.
39: -- Hence the gtt_rcd_rqd_vals.rcd_found flag for 'H'/'T' type records, if retreived,
40: -- remains unchanged as FALSE, and this leads to raising of required_error exception
41: -- in ben_ext_person.process_ext_levels.

Line 41: -- in ben_ext_person.process_ext_levels.

37: -- since they never get proccessed in xtrct_skltn. Also, ben_ext_person.process_ext_recs
38: -- processes only Detail Type records.
39: -- Hence the gtt_rcd_rqd_vals.rcd_found flag for 'H'/'T' type records, if retreived,
40: -- remains unchanged as FALSE, and this leads to raising of required_error exception
41: -- in ben_ext_person.process_ext_levels.
42: and a.rcd_type_cd = 'D'
43: -- end fix 1702733
44: and a.low_lvl_cd <> 'P';
45:

Line 288: ben_ext_person.g_err_num := null;

284: then
285: --
286: -- Initialize globals
287: --
288: ben_ext_person.g_err_num := null;
289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;

Line 289: ben_ext_person.g_err_name := null;

285: --
286: -- Initialize globals
287: --
288: ben_ext_person.g_err_num := null;
289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;
293: ben_ext_person.g_pay_last_end_date := null;

Line 290: ben_ext_person.g_chg_enrt_rslt_id := null;

286: -- Initialize globals
287: --
288: ben_ext_person.g_err_num := null;
289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;
293: ben_ext_person.g_pay_last_end_date := null;
294:

Line 291: ben_ext_person.g_chg_input_value_id := null;

287: --
288: ben_ext_person.g_err_num := null;
289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;
293: ben_ext_person.g_pay_last_end_date := null;
294:
295: --

Line 292: ben_ext_person.g_pay_last_start_date:= null;

288: ben_ext_person.g_err_num := null;
289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;
293: ben_ext_person.g_pay_last_end_date := null;
294:
295: --
296: g_ext_dfn_id := p_ext_dfn_id;

Line 293: ben_ext_person.g_pay_last_end_date := null;

289: ben_ext_person.g_err_name := null;
290: ben_ext_person.g_chg_enrt_rslt_id := null;
291: ben_ext_person.g_chg_input_value_id := null;
292: ben_ext_person.g_pay_last_start_date:= null;
293: ben_ext_person.g_pay_last_end_date := null;
294:
295: --
296: g_ext_dfn_id := p_ext_dfn_id;
297: g_request_id := p_request_id;

Line 307: ben_ext_person.g_upd_cm_sent_dt_flag ,

303: g_run_date := sysdate;
304: --
305: open c_ext_dfn;
306: fetch c_ext_dfn into g_spcl_hndl_flag,
307: ben_ext_person.g_upd_cm_sent_dt_flag ,
308: ben_ext_person.g_ext_global_flag ;
309: close c_ext_dfn;
310: hr_utility.set_location( 'GLOBAL Flag ' || ben_ext_person.g_ext_global_flag , 99 ) ;
311: /*

Line 308: ben_ext_person.g_ext_global_flag ;

304: --
305: open c_ext_dfn;
306: fetch c_ext_dfn into g_spcl_hndl_flag,
307: ben_ext_person.g_upd_cm_sent_dt_flag ,
308: ben_ext_person.g_ext_global_flag ;
309: close c_ext_dfn;
310: hr_utility.set_location( 'GLOBAL Flag ' || ben_ext_person.g_ext_global_flag , 99 ) ;
311: /*
312: --

Line 310: hr_utility.set_location( 'GLOBAL Flag ' || ben_ext_person.g_ext_global_flag , 99 ) ;

306: fetch c_ext_dfn into g_spcl_hndl_flag,
307: ben_ext_person.g_upd_cm_sent_dt_flag ,
308: ben_ext_person.g_ext_global_flag ;
309: close c_ext_dfn;
310: hr_utility.set_location( 'GLOBAL Flag ' || ben_ext_person.g_ext_global_flag , 99 ) ;
311: /*
312: --
313: -- MH moved call to thread level (ben_ext_thread.do_multithread)
314: -- rather than chunk level to minimize

Line 401: ben_ext_person.process_ext_person

397: hr_utility.set_location(' Person ID '||l_personid_va(vaen), 00 );
398: end if;
399: Begin
400: --
401: ben_ext_person.process_ext_person
402: (p_person_id => l_personid_va(vaen)
403: ,p_ext_dfn_id => p_ext_dfn_id
404: ,p_ext_rslt_id => p_ext_rslt_id
405: ,p_ext_file_id => p_ext_file_id

Line 427: when ben_ext_person.detail_restart_error then

423: ,p_object_version_number =>l_pactovn_va(vaen)
424: ,p_effective_date => p_effective_date);
425: --
426: Exception
427: when ben_ext_person.detail_restart_error then
428:
429: --- update the range to warning
430: --- the warning will be later converted to erro because
431: --- if error the range the subseqent range may not be executed , every time spawn the thread

Line 437: l_err_message := ben_ext_fmt.get_error_msg(ben_Ext_person.g_err_num,

433:
434: update ben_batch_ranges set range_status_cd = 'W'
435: where range_id = p_range_id and range_status_cd = 'P';
436:
437: l_err_message := ben_ext_fmt.get_error_msg(ben_Ext_person.g_err_num,
438: ben_Ext_person.g_err_name,ben_Ext_person.g_elmt_name ) ;
439: if g_debug then
440: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
441: end if;

Line 438: ben_Ext_person.g_err_name,ben_Ext_person.g_elmt_name ) ;

434: update ben_batch_ranges set range_status_cd = 'W'
435: where range_id = p_range_id and range_status_cd = 'P';
436:
437: l_err_message := ben_ext_fmt.get_error_msg(ben_Ext_person.g_err_num,
438: ben_Ext_person.g_err_name,ben_Ext_person.g_elmt_name ) ;
439: if g_debug then
440: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
441: end if;
442: ben_ext_person.write_error(

Line 442: ben_ext_person.write_error(

438: ben_Ext_person.g_err_name,ben_Ext_person.g_elmt_name ) ;
439: if g_debug then
440: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
441: end if;
442: ben_ext_person.write_error(
443: p_err_num => ben_Ext_person.g_err_num,
444: p_err_name => l_err_message,
445: p_typ_cd => 'E',
446: p_request_id => ben_extract.g_request_id,

Line 443: p_err_num => ben_Ext_person.g_err_num,

439: if g_debug then
440: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
441: end if;
442: ben_ext_person.write_error(
443: p_err_num => ben_Ext_person.g_err_num,
444: p_err_name => l_err_message,
445: p_typ_cd => 'E',
446: p_request_id => ben_extract.g_request_id,
447: p_ext_rslt_id => p_ext_rslt_id

Line 460: if nvl(ben_ext_person.g_err_num,-1) <> 94102 then

456: --- the process validated for the errored thread so we set the range status to 'W'
457:
458: update ben_batch_ranges set range_status_cd = 'W'
459: where range_id = p_range_id and range_status_cd = 'P';
460: if nvl(ben_ext_person.g_err_num,-1) <> 94102 then
461: l_err_message := substr(sqlerrm,1,2000) ;
462: if g_debug then
463: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
464: end if;

Line 465: ben_ext_person.write_error(

461: l_err_message := substr(sqlerrm,1,2000) ;
462: if g_debug then
463: hr_utility.set_location('err msg ' || l_err_message, 99.98 );
464: end if;
465: ben_ext_person.write_error(
466: p_err_num => 94701,
467: p_err_name => l_err_message,
468: p_typ_cd => 'E',
469: p_request_id => ben_extract.g_request_id,

Line 474: ben_ext_person.g_err_num := null ;

470: p_ext_rslt_id => p_ext_rslt_id
471: );
472: --- the changes are commited along with the error message in thge write error process
473: end if ;
474: ben_ext_person.g_err_num := null ;
475:
476: End ;
477: end loop;
478: --

Line 489: ben_ext_person.process_ext_person

485: --
486: if g_debug then
487: hr_utility.set_location(' Person ID ' || person.person_id, 00 );
488: end if;
489: ben_ext_person.process_ext_person
490: ( p_person_id => person.person_id
491: , p_ext_dfn_id => p_ext_dfn_id
492: , p_ext_rslt_id => p_ext_rslt_id
493: , p_ext_file_id => p_ext_file_id