DBA Data[Home] [Help]

APPS.BEN_EXT_ADV_CONDITIONS dependencies on BEN_EXT_PERSON

Line 105: if ben_ext_person.g_business_group_id is not null then

101: if p_err_no is not null and p_element is not null then
102: l_err_name := ben_ext_fmt.get_error_msg(p_err_no,p_err_name,p_element ) ;
103: end if ;
104:
105: if ben_ext_person.g_business_group_id is not null then
106: ben_ext_util.write_err
107: (p_err_num => l_err_no, -- to_number(substr(p_err_name,5,5)),
108: p_err_name => l_err_name, --p_err_name,
109: p_typ_cd => 'W',

Line 110: p_person_id => ben_ext_person.g_person_id,

106: ben_ext_util.write_err
107: (p_err_num => l_err_no, -- to_number(substr(p_err_name,5,5)),
108: p_err_name => l_err_name, --p_err_name,
109: p_typ_cd => 'W',
110: p_person_id => ben_ext_person.g_person_id,
111: p_business_group_id => ben_ext_person.g_business_group_id,
112: p_ext_rslt_id => ben_extract.g_ext_rslt_id);
113: end if;
114: --

Line 111: p_business_group_id => ben_ext_person.g_business_group_id,

107: (p_err_num => l_err_no, -- to_number(substr(p_err_name,5,5)),
108: p_err_name => l_err_name, --p_err_name,
109: p_typ_cd => 'W',
110: p_person_id => ben_ext_person.g_person_id,
111: p_business_group_id => ben_ext_person.g_business_group_id,
112: p_ext_rslt_id => ben_extract.g_ext_rslt_id);
113: end if;
114: --
115: hr_utility.set_location('Exiting'||l_proc, 15);

Line 444: raise ben_ext_person.required_error;

440: if p_sprs_cd = 'A' then -- rollback record
441: p_exclude_this_rcd_flag := true;
442: elsif p_sprs_cd = 'B' then -- rollback person
443: p_exclude_this_rcd_flag := true;
444: raise ben_ext_person.required_error;
445: elsif p_sprs_cd = 'C' then -- rollback person and error
446: p_exclude_this_rcd_flag := true;
447: ben_ext_person.g_elmt_name := l_rcd_name ;
448: ben_ext_person.g_err_num := 92679;

Line 447: ben_ext_person.g_elmt_name := l_rcd_name ;

443: p_exclude_this_rcd_flag := true;
444: raise ben_ext_person.required_error;
445: elsif p_sprs_cd = 'C' then -- rollback person and error
446: p_exclude_this_rcd_flag := true;
447: ben_ext_person.g_elmt_name := l_rcd_name ;
448: ben_ext_person.g_err_num := 92679;
449: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
450: raise ben_ext_person.detail_restart_error;
451: elsif p_sprs_cd = 'H' then -- signal warning

Line 448: ben_ext_person.g_err_num := 92679;

444: raise ben_ext_person.required_error;
445: elsif p_sprs_cd = 'C' then -- rollback person and error
446: p_exclude_this_rcd_flag := true;
447: ben_ext_person.g_elmt_name := l_rcd_name ;
448: ben_ext_person.g_err_num := 92679;
449: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
450: raise ben_ext_person.detail_restart_error;
451: elsif p_sprs_cd = 'H' then -- signal warning
452: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);

Line 449: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';

445: elsif p_sprs_cd = 'C' then -- rollback person and error
446: p_exclude_this_rcd_flag := true;
447: ben_ext_person.g_elmt_name := l_rcd_name ;
448: ben_ext_person.g_err_num := 92679;
449: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
450: raise ben_ext_person.detail_restart_error;
451: elsif p_sprs_cd = 'H' then -- signal warning
452: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);
453:

Line 450: raise ben_ext_person.detail_restart_error;

446: p_exclude_this_rcd_flag := true;
447: ben_ext_person.g_elmt_name := l_rcd_name ;
448: ben_ext_person.g_err_num := 92679;
449: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
450: raise ben_ext_person.detail_restart_error;
451: elsif p_sprs_cd = 'H' then -- signal warning
452: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);
453:
454: end if;

Line 462: raise ben_ext_person.required_error;

458: if p_sprs_cd = 'D' then -- rollback record
459: p_exclude_this_rcd_flag := true;
460: elsif p_sprs_cd = 'E' then -- rollback person
461: p_exclude_this_rcd_flag := true;
462: raise ben_ext_person.required_error;
463: elsif p_sprs_cd = 'F' then -- rollback person and error
464: p_exclude_this_rcd_flag := true;
465: ben_ext_person.g_elmt_name := l_rcd_name ;
466: ben_ext_person.g_err_num := 92679;

Line 465: ben_ext_person.g_elmt_name := l_rcd_name ;

461: p_exclude_this_rcd_flag := true;
462: raise ben_ext_person.required_error;
463: elsif p_sprs_cd = 'F' then -- rollback person and error
464: p_exclude_this_rcd_flag := true;
465: ben_ext_person.g_elmt_name := l_rcd_name ;
466: ben_ext_person.g_err_num := 92679;
467: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
468: raise ben_ext_person.detail_restart_error;
469: elsif p_sprs_cd = 'K' then -- signal warning

Line 466: ben_ext_person.g_err_num := 92679;

462: raise ben_ext_person.required_error;
463: elsif p_sprs_cd = 'F' then -- rollback person and error
464: p_exclude_this_rcd_flag := true;
465: ben_ext_person.g_elmt_name := l_rcd_name ;
466: ben_ext_person.g_err_num := 92679;
467: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
468: raise ben_ext_person.detail_restart_error;
469: elsif p_sprs_cd = 'K' then -- signal warning
470: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);

Line 467: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';

463: elsif p_sprs_cd = 'F' then -- rollback person and error
464: p_exclude_this_rcd_flag := true;
465: ben_ext_person.g_elmt_name := l_rcd_name ;
466: ben_ext_person.g_err_num := 92679;
467: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
468: raise ben_ext_person.detail_restart_error;
469: elsif p_sprs_cd = 'K' then -- signal warning
470: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);
471:

Line 468: raise ben_ext_person.detail_restart_error;

464: p_exclude_this_rcd_flag := true;
465: ben_ext_person.g_elmt_name := l_rcd_name ;
466: ben_ext_person.g_err_num := 92679;
467: ben_ext_person.g_err_name := 'BEN_92679_EXT_USER_DEFINED_ERR';
468: raise ben_ext_person.detail_restart_error;
469: elsif p_sprs_cd = 'K' then -- signal warning
470: write_warning ('BEN_92678_EXT_USER_DEFINED_WRN',92678,l_rcd_name);
471:
472: end if;

Line 769: raise ben_ext_person.required_error;

765: p_exclude_this_rcd_flag := true;
766: exit;
767: elsif xer.sprs_cd = 'B' then -- rollback person
768: p_exclude_this_rcd_flag := true;
769: raise ben_ext_person.required_error;
770: elsif xer.sprs_cd = 'C' then -- rollback person and error
771: p_exclude_this_rcd_flag := true;
772: ben_ext_person.g_elmt_name := xer.name ;
773: ben_ext_person.g_err_num := 92312;

Line 772: ben_ext_person.g_elmt_name := xer.name ;

768: p_exclude_this_rcd_flag := true;
769: raise ben_ext_person.required_error;
770: elsif xer.sprs_cd = 'C' then -- rollback person and error
771: p_exclude_this_rcd_flag := true;
772: ben_ext_person.g_elmt_name := xer.name ;
773: ben_ext_person.g_err_num := 92312;
774: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
775: raise ben_ext_person.detail_error;
776: elsif xer.sprs_cd = 'G' then -- nullify data element

Line 773: ben_ext_person.g_err_num := 92312;

769: raise ben_ext_person.required_error;
770: elsif xer.sprs_cd = 'C' then -- rollback person and error
771: p_exclude_this_rcd_flag := true;
772: ben_ext_person.g_elmt_name := xer.name ;
773: ben_ext_person.g_err_num := 92312;
774: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
775: raise ben_ext_person.detail_error;
776: elsif xer.sprs_cd = 'G' then -- nullify data element
777: ben_ext_fmt.g_val_tab(xer.seq_num) := null;

Line 774: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';

770: elsif xer.sprs_cd = 'C' then -- rollback person and error
771: p_exclude_this_rcd_flag := true;
772: ben_ext_person.g_elmt_name := xer.name ;
773: ben_ext_person.g_err_num := 92312;
774: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
775: raise ben_ext_person.detail_error;
776: elsif xer.sprs_cd = 'G' then -- nullify data element
777: ben_ext_fmt.g_val_tab(xer.seq_num) := null;
778: elsif xer.sprs_cd = 'H' then -- signal warning

Line 775: raise ben_ext_person.detail_error;

771: p_exclude_this_rcd_flag := true;
772: ben_ext_person.g_elmt_name := xer.name ;
773: ben_ext_person.g_err_num := 92312;
774: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
775: raise ben_ext_person.detail_error;
776: elsif xer.sprs_cd = 'G' then -- nullify data element
777: ben_ext_fmt.g_val_tab(xer.seq_num) := null;
778: elsif xer.sprs_cd = 'H' then -- signal warning
779: write_warning ('BEN_92313_EXT_USER_DEFINED_WRN',92313,xer.name);

Line 792: raise ben_ext_person.required_error;

788: p_exclude_this_rcd_flag := true;
789: exit;
790: elsif xer.sprs_cd = 'E' then -- rollback person
791: p_exclude_this_rcd_flag := true;
792: raise ben_ext_person.required_error;
793: elsif xer.sprs_cd = 'F' then -- rollback person and error
794: p_exclude_this_rcd_flag := true;
795: ben_ext_person.g_err_num := 92312;
796: ben_ext_person.g_elmt_name := xer.name ;

Line 795: ben_ext_person.g_err_num := 92312;

791: p_exclude_this_rcd_flag := true;
792: raise ben_ext_person.required_error;
793: elsif xer.sprs_cd = 'F' then -- rollback person and error
794: p_exclude_this_rcd_flag := true;
795: ben_ext_person.g_err_num := 92312;
796: ben_ext_person.g_elmt_name := xer.name ;
797: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
798: raise ben_ext_person.detail_error;
799: elsif xer.sprs_cd = 'J' then -- nullify data element

Line 796: ben_ext_person.g_elmt_name := xer.name ;

792: raise ben_ext_person.required_error;
793: elsif xer.sprs_cd = 'F' then -- rollback person and error
794: p_exclude_this_rcd_flag := true;
795: ben_ext_person.g_err_num := 92312;
796: ben_ext_person.g_elmt_name := xer.name ;
797: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
798: raise ben_ext_person.detail_error;
799: elsif xer.sprs_cd = 'J' then -- nullify data element
800: ben_ext_fmt.g_val_tab(xer.seq_num) := null;

Line 797: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';

793: elsif xer.sprs_cd = 'F' then -- rollback person and error
794: p_exclude_this_rcd_flag := true;
795: ben_ext_person.g_err_num := 92312;
796: ben_ext_person.g_elmt_name := xer.name ;
797: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
798: raise ben_ext_person.detail_error;
799: elsif xer.sprs_cd = 'J' then -- nullify data element
800: ben_ext_fmt.g_val_tab(xer.seq_num) := null;
801: elsif xer.sprs_cd = 'K' then -- signal warning

Line 798: raise ben_ext_person.detail_error;

794: p_exclude_this_rcd_flag := true;
795: ben_ext_person.g_err_num := 92312;
796: ben_ext_person.g_elmt_name := xer.name ;
797: ben_ext_person.g_err_name := 'BEN_92312_EXT_USER_DEFINED_ERR';
798: raise ben_ext_person.detail_error;
799: elsif xer.sprs_cd = 'J' then -- nullify data element
800: ben_ext_fmt.g_val_tab(xer.seq_num) := null;
801: elsif xer.sprs_cd = 'K' then -- signal warning
802: write_warning ('BEN_92313_EXT_USER_DEFINED_WRN',92313,xer.name);