APPS.HXC_ULP_SHD dependencies on HXC_LAYOUT_COMP_PROMPTS

Line 22: If (p_constraint_name = 'HXC_LAYOUT_COMP_PROMPTS_FK1') Then

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

Line 27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMP_PROMPTS_PK') Then

23: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMP_PROMPTS_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;

Line 32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMP_PROMPTS_UK1') Then

28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMP_PROMPTS_UK1') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;

Line 69: from hxc_layout_comp_prompts

65: ,region_application_id
66: ,attribute_code
67: ,attribute_application_id
68: ,object_version_number
69: from hxc_layout_comp_prompts
70: where layout_comp_prompt_id = p_layout_comp_prompt_id;
71: --
72: l_fct_ret boolean;
73: --

Line 143: from hxc_layout_comp_prompts

139: ,region_application_id
140: ,attribute_code
141: ,attribute_application_id
142: ,object_version_number
143: from hxc_layout_comp_prompts
144: where layout_comp_prompt_id = p_layout_comp_prompt_id
145: for update nowait;
146: --
147: l_proc varchar2(72) ;

Line 192: fnd_message.set_token('TABLE_NAME', 'hxc_layout_comp_prompts');

188: -- The object is locked therefore we need to supply a meaningful
189: -- error message.
190: --
191: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
192: fnd_message.set_token('TABLE_NAME', 'hxc_layout_comp_prompts');
193: fnd_message.raise_error;
194: End lck;
195: --
196: -- ----------------------------------------------------------------------------