APPS.HXC_APC_SHD dependencies on HXC_APPROVAL_PERIOD_COMPS

Line 33: If (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK1') Then

29: l_proc varchar2(72) := g_package||'constraint_error';
30: --
31: Begin
32: --
33: If (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK1') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;

Line 38: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK2') Then

34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK2') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;

Line 43: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK3') Then

39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_FK3') Then
44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;

Line 48: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_PK') Then

44: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('STEP','15');
47: fnd_message.raise_error;
48: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_PK') Then
49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;

Line 53: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_U1') Then

49: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
50: fnd_message.set_token('PROCEDURE', l_proc);
51: fnd_message.set_token('STEP','20');
52: fnd_message.raise_error;
53: ElsIf (p_constraint_name = 'HXC_APPROVAL_PERIOD_COMPS_U1') Then
54: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
55: fnd_message.set_token('PROCEDURE', l_proc);
56: fnd_message.set_token('STEP','25');
57: fnd_message.raise_error;

Line 86: from hxc_approval_period_comps

82: ,time_recipient_id
83: ,recurring_period_id
84: ,approval_period_set_id
85: ,object_version_number
86: from hxc_approval_period_comps
87: where approval_period_comp_id = p_approval_period_comp_id;
88: --
89: l_fct_ret boolean;
90: --

Line 156: from hxc_approval_period_comps

152: ,time_recipient_id
153: ,recurring_period_id
154: ,approval_period_set_id
155: ,object_version_number
156: from hxc_approval_period_comps
157: where approval_period_comp_id = p_approval_period_comp_id
158: for update nowait;
159: --
160: l_proc varchar2(72);

Line 205: fnd_message.set_token('TABLE_NAME', 'hxc_approval_period_comps');

201: -- The object is locked therefore we need to supply a meaningful
202: -- error message.
203: --
204: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
205: fnd_message.set_token('TABLE_NAME', 'hxc_approval_period_comps');
206: fnd_message.raise_error;
207: End lck;
208: --
209: -- ----------------------------------------------------------------------------