19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') Then
20: Begin
21: --
22: If (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_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;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') 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');
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_COMPONENTS_FK2') 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_COMPONENTS_PK') Then
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') 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_COMPONENTS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') 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_COMPONENTS_PK') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
34: fnd_message.set_token('PROCEDURE', l_proc);
27: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_FK2') 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_COMPONENTS_PK') 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');
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_COMPONENTS_PK') 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;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_PK') 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;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_PK') 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;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_PK') 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;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
37: ElsIf (p_constraint_name = 'HXC_LAYOUT_COMPONENTS_UK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
40: fnd_message.set_token('STEP','20');
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
41: fnd_message.raise_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
49: End constraint_error;
42: Else
43: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
44: fnd_message.set_token('PROCEDURE', l_proc);
45: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
46: fnd_message.raise_error;
47: End If;
48: --
49: End constraint_error;
50: --
118: Close C_Sel1;
119: --
120: -- The primary key is invalid therefore we must error
121: --
122: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
123: fnd_message.raise_error;
124: End If;
125: Close C_Sel1;
126: If (p_object_version_number
119: --
120: -- The primary key is invalid therefore we must error
121: --
122: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
123: fnd_message.raise_error;
124: End If;
125: Close C_Sel1;
126: If (p_object_version_number
127: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
124: End If;
125: Close C_Sel1;
126: If (p_object_version_number
127: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
128: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
129: fnd_message.raise_error;
130: End If;
131: l_fct_ret := true;
132: End If;
125: Close C_Sel1;
126: If (p_object_version_number
127: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
128: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
129: fnd_message.raise_error;
130: End If;
131: l_fct_ret := true;
132: End If;
133: End If;
192: Close C_Sel1;
193: --
194: -- The primary key is invalid therefore we must error
195: --
196: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number
193: --
194: -- The primary key is invalid therefore we must error
195: --
196: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
197: fnd_message.raise_error;
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number
201: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
198: End If;
199: Close C_Sel1;
200: If (p_object_version_number
201: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
202: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
203: fnd_message.raise_error;
204: End If;
205: --
206: if g_debug then
199: Close C_Sel1;
200: If (p_object_version_number
201: <> hxc_ulc_shd.g_old_rec.object_version_number) Then
202: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
203: fnd_message.raise_error;
204: End If;
205: --
206: if g_debug then
207: hr_utility.set_location(' Leaving:'||l_proc, 10);
214: --
215: -- The object is locked therefore we need to supply a meaningful
216: -- error message.
217: --
218: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
219: fnd_message.set_token('TABLE_NAME', 'hxc_layout_components');
220: fnd_message.raise_error;
221: End lck;
222: --
215: -- The object is locked therefore we need to supply a meaningful
216: -- error message.
217: --
218: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
219: fnd_message.set_token('TABLE_NAME', 'hxc_layout_components');
220: fnd_message.raise_error;
221: End lck;
222: --
223: -- ----------------------------------------------------------------------------
216: -- error message.
217: --
218: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
219: fnd_message.set_token('TABLE_NAME', 'hxc_layout_components');
220: fnd_message.raise_error;
221: End lck;
222: --
223: -- ----------------------------------------------------------------------------
224: -- |-----------------------------< convert_args >-----------------------------|