DBA Data[Home] [Help]

APPS.BEN_CWG_SHD dependencies on BEN_CWB_WKSHT_GRP

Line 21: If (p_constraint_name = 'BEN_CWB_WKSHT_GRP_PK') Then

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'BEN_CWB_WKSHT_GRP_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;

Line 89: from ben_cwb_wksht_grp

85: ,cwg_attribute30
86: ,status_Cd
87: ,hidden_cd
88: ,object_version_number
89: from ben_cwb_wksht_grp
90: where cwb_wksht_grp_id = p_cwb_wksht_grp_id;
91: --
92: l_fct_ret boolean;
93: --

Line 194: from ben_cwb_wksht_grp

190: ,cwg_attribute30
191: ,status_Cd
192: ,hidden_cd
193: ,object_version_number
194: from ben_cwb_wksht_grp
195: where cwb_wksht_grp_id = p_cwb_wksht_grp_id
196: for update nowait;
197: --
198: l_proc varchar2(72) := g_package||'lck';

Line 243: fnd_message.set_token('TABLE_NAME', 'ben_cwb_wksht_grp');

239: -- The object is locked therefore we need to supply a meaningful
240: -- error message.
241: --
242: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
243: fnd_message.set_token('TABLE_NAME', 'ben_cwb_wksht_grp');
244: fnd_message.raise_error;
245: End lck;
246: --
247: -- ----------------------------------------------------------------------------