APPS.HR_CNP_SHD dependencies on HR_CANVAS_PROPERTIES

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

17: l_proc varchar2(72) := g_package||'constraint_error';
18: --
19: Begin
20: --
21: If (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_PK') Then
22: -- Primary key constraint validated (canvas_property_id)
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');

Line 27: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_B_UK') 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 = 'HR_CANVAS_PROPERTIES_B_UK') Then
28: -- Unique key constraint violated (form_canvas_id, template_canvas_id)
29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');

Line 33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then

29: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
30: fnd_message.set_token('PROCEDURE', l_proc);
31: fnd_message.set_token('STEP','10');
32: fnd_message.raise_error;
33: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK1') Then
34: -- Foreign key (parent) constraint violated (form_canvas_id)
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');

Line 39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then

35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','15');
38: fnd_message.raise_error;
39: ElsIf (p_constraint_name = 'HR_CANVAS_PROPERTIES_FK2') Then
40: -- Foreign key (parent) constraint violated (template_canvas_id)
41: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
42: fnd_message.set_token('PROCEDURE', l_proc);
43: fnd_message.set_token('STEP','20');

Line 108: from hr_canvas_properties

104: ,information27
105: ,information28
106: ,information29
107: ,information30
108: from hr_canvas_properties
109: where canvas_property_id = p_canvas_property_id;
110: --
111: l_fct_ret boolean;
112: --

Line 214: from hr_canvas_properties

210: ,information27
211: ,information28
212: ,information29
213: ,information30
214: from hr_canvas_properties
215: where canvas_property_id = p_canvas_property_id
216: for update nowait;
217: --
218: l_proc varchar2(72) := g_package||'lck';

Line 263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');

259: -- The object is locked therefore we need to supply a meaningful
260: -- error message.
261: --
262: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
263: fnd_message.set_token('TABLE_NAME', 'hr_canvas_properties');
264: fnd_message.raise_error;
265: End lck;
266: --
267: -- ----------------------------------------------------------------------------