APPS.HR_FIM_SHD dependencies on HR_FORM_ITEMS_B

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_FORM_ITEMS_B_FK2') 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 26: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_FK3') 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;
26: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_FK3') Then
27: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('STEP','10');
30: fnd_message.raise_error;

Line 31: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_FK4') Then

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

Line 36: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_PK') Then

32: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
33: fnd_message.set_token('PROCEDURE', l_proc);
34: fnd_message.set_token('STEP','15');
35: fnd_message.raise_error;
36: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;

Line 41: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_UK') Then

37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','20');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'HR_FORM_ITEMS_B_UK') Then
42: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('STEP','25');
45: fnd_message.raise_error;

Line 81: from hr_form_items_b

77: ,radio_button_name
78: ,required_override
79: ,form_tab_page_id_override
80: ,visible_override
81: from hr_form_items_b
82: where form_item_id = p_form_item_id;
83: --
84: l_fct_ret boolean;
85: --

Line 158: from hr_form_items_b

154: ,radio_button_name
155: ,required_override
156: ,form_tab_page_id_override
157: ,visible_override
158: from hr_form_items_b
159: where form_item_id = p_form_item_id
160: for update nowait;
161: --
162: l_proc varchar2(72) := g_package||'lck';

Line 207: fnd_message.set_token('TABLE_NAME', 'hr_form_items_b');

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