DBA Data[Home] [Help]

APPS.BEN_CLF_SHD dependencies on BEN_UTILITY

Line 47: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_RT_F');

43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','10');
45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_COMP_LVL_RT_F_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_RT_F');
48: ElsIf (p_constraint_name = 'BEN_ELIG_COMP_LVL_PRTE_F_FK2') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F');
50: ElsIf (p_constraint_name = 'BEN_CVG_AMT_CALC_MTHD_F_FK2') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');

Line 49: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F');

45: fnd_message.raise_error;
46: ElsIf (p_constraint_name = 'BEN_COMP_LVL_RT_F_FK1') Then
47: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_RT_F');
48: ElsIf (p_constraint_name = 'BEN_ELIG_COMP_LVL_PRTE_F_FK2') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F');
50: ElsIf (p_constraint_name = 'BEN_CVG_AMT_CALC_MTHD_F_FK2') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');
52: ElsIf (p_constraint_name = 'BEN_ACTL_PREM_F_FK2') Then
53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');

Line 51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');

47: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_RT_F');
48: ElsIf (p_constraint_name = 'BEN_ELIG_COMP_LVL_PRTE_F_FK2') Then
49: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F');
50: ElsIf (p_constraint_name = 'BEN_CVG_AMT_CALC_MTHD_F_FK2') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');
52: ElsIf (p_constraint_name = 'BEN_ACTL_PREM_F_FK2') Then
53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');
54: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_FK2') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');

Line 53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');

49: ben_utility.child_exists_error(p_table_name => 'BEN_ELIG_COMP_LVL_PRTE_F');
50: ElsIf (p_constraint_name = 'BEN_CVG_AMT_CALC_MTHD_F_FK2') Then
51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');
52: ElsIf (p_constraint_name = 'BEN_ACTL_PREM_F_FK2') Then
53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');
54: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_FK2') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');
56: ElsIf (p_constraint_name = 'BEN_COMP_LVL_ACTY_RT_F_FK2') Then
57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');

Line 55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');

51: ben_utility.child_exists_error(p_table_name => 'BEN_CVG_AMT_CALC_MTHD_F');
52: ElsIf (p_constraint_name = 'BEN_ACTL_PREM_F_FK2') Then
53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');
54: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_FK2') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');
56: ElsIf (p_constraint_name = 'BEN_COMP_LVL_ACTY_RT_F_FK2') Then
57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');
58: ElsIf (p_constraint_name = 'BEN_ENRT_BNFT_FK3') Then
59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');

Line 57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');

53: ben_utility.child_exists_error (p_table_name => 'BEN_ACTL_PREM_F');
54: ElsIf (p_constraint_name = 'BEN_ACTY_BASE_RT_F_FK2') Then
55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');
56: ElsIf (p_constraint_name = 'BEN_COMP_LVL_ACTY_RT_F_FK2') Then
57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');
58: ElsIf (p_constraint_name = 'BEN_ENRT_BNFT_FK3') Then
59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');
60: ElsIf (p_constraint_name = 'BEN_MTCHG_RT_F_FK2') Then
61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');

Line 59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');

55: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_BASE_RT_F');
56: ElsIf (p_constraint_name = 'BEN_COMP_LVL_ACTY_RT_F_FK2') Then
57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');
58: ElsIf (p_constraint_name = 'BEN_ENRT_BNFT_FK3') Then
59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');
60: ElsIf (p_constraint_name = 'BEN_MTCHG_RT_F_FK2') Then
61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');
62: ElsIf (p_constraint_name = 'BEN_PTD_BAL_TYP_F_FK2') Then
63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');

Line 61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');

57: ben_utility.child_exists_error(p_table_name => 'BEN_COMP_LVL_ACTY_RT_F');
58: ElsIf (p_constraint_name = 'BEN_ENRT_BNFT_FK3') Then
59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');
60: ElsIf (p_constraint_name = 'BEN_MTCHG_RT_F_FK2') Then
61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');
62: ElsIf (p_constraint_name = 'BEN_PTD_BAL_TYP_F_FK2') Then
63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');
64: ElsIf (p_constraint_name = 'BEN_PTD_LMT_F_FK2') Then
65: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_LMT_F');

Line 63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');

59: ben_utility.child_exists_error(p_table_name => 'BEN_ENRT_BNFT');
60: ElsIf (p_constraint_name = 'BEN_MTCHG_RT_F_FK2') Then
61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');
62: ElsIf (p_constraint_name = 'BEN_PTD_BAL_TYP_F_FK2') Then
63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');
64: ElsIf (p_constraint_name = 'BEN_PTD_LMT_F_FK2') Then
65: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_LMT_F');
66: ElsIf (p_constraint_name = 'BEN_VRBL_RT_PRFL_F_FK5') Then
67: ben_utility.child_exists_error(p_table_name => 'BEN_VRBL_RT_PRFL_F');

Line 65: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_LMT_F');

61: ben_utility.child_exists_error(p_table_name => 'BEN_MTCHG_RT_F');
62: ElsIf (p_constraint_name = 'BEN_PTD_BAL_TYP_F_FK2') Then
63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');
64: ElsIf (p_constraint_name = 'BEN_PTD_LMT_F_FK2') Then
65: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_LMT_F');
66: ElsIf (p_constraint_name = 'BEN_VRBL_RT_PRFL_F_FK5') Then
67: ben_utility.child_exists_error(p_table_name => 'BEN_VRBL_RT_PRFL_F');
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');

Line 67: ben_utility.child_exists_error(p_table_name => 'BEN_VRBL_RT_PRFL_F');

63: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_BAL_TYP_F_FK2');
64: ElsIf (p_constraint_name = 'BEN_PTD_LMT_F_FK2') Then
65: ben_utility.child_exists_error(p_table_name => 'BEN_PTD_LMT_F');
66: ElsIf (p_constraint_name = 'BEN_VRBL_RT_PRFL_F_FK5') Then
67: ben_utility.child_exists_error(p_table_name => 'BEN_VRBL_RT_PRFL_F');
68: Else
69: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: fnd_message.set_token('PROCEDURE', l_proc);
71: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);