19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_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_ALIAS_VALUES_PK') Then
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_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_ALIAS_VALUES_PK') Then
28: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
21: --
22: If (p_constraint_name = 'HXC_ALIAS_VALUES_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_ALIAS_VALUES_PK') 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_ALIAS_VALUES_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_ALIAS_VALUES_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');
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_ALIAS_VALUES_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;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') Then
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_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;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') Then
33: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
26: fnd_message.raise_error;
27: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_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;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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_ALIAS_VALUES_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;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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_ALIAS_VALUES_UK2') 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: Else
30: fnd_message.set_token('STEP','10');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
31: fnd_message.raise_error;
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: ElsIf (p_constraint_name = 'HXC_ALIAS_VALUES_UK2') 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: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
35: fnd_message.set_token('STEP','15');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
39: fnd_message.set_token('PROCEDURE', l_proc);
40: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
41: fnd_message.raise_error;
42: End If;
43: --
44: End constraint_error;
45: --
134: Close C_Sel1;
135: --
136: -- The primary key is invalid therefore we must error
137: --
138: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
139: fnd_message.raise_error;
140: End If;
141: Close C_Sel1;
142: If (p_object_version_number
135: --
136: -- The primary key is invalid therefore we must error
137: --
138: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
139: fnd_message.raise_error;
140: End If;
141: Close C_Sel1;
142: If (p_object_version_number
143: <> hxc_hav_shd.g_old_rec.object_version_number) Then
140: End If;
141: Close C_Sel1;
142: If (p_object_version_number
143: <> hxc_hav_shd.g_old_rec.object_version_number) Then
144: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
145: fnd_message.raise_error;
146: End If;
147: l_fct_ret := true;
148: End If;
141: Close C_Sel1;
142: If (p_object_version_number
143: <> hxc_hav_shd.g_old_rec.object_version_number) Then
144: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
145: fnd_message.raise_error;
146: End If;
147: l_fct_ret := true;
148: End If;
149: End If;
229: Close C_Sel1;
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> hxc_hav_shd.g_old_rec.object_version_number) Then
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> hxc_hav_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: if g_debug then
236: Close C_Sel1;
237: If (p_object_version_number
238: <> hxc_hav_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: if g_debug then
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
251: --
252: -- The object is locked therefore we need to supply a meaningful
253: -- error message.
254: --
255: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
256: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values');
257: fnd_message.raise_error;
258: End lck;
259: --
252: -- The object is locked therefore we need to supply a meaningful
253: -- error message.
254: --
255: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
256: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values');
257: fnd_message.raise_error;
258: End lck;
259: --
260: -- ----------------------------------------------------------------------------
253: -- error message.
254: --
255: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
256: fnd_message.set_token('TABLE_NAME', 'hxc_alias_values');
257: fnd_message.raise_error;
258: End lck;
259: --
260: -- ----------------------------------------------------------------------------
261: -- |-----------------------------< convert_args >-----------------------------|