19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_TYPES_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: Else
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ALIAS_TYPES_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: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
21: --
22: If (p_constraint_name = 'HXC_ALIAS_TYPES_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: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
22: If (p_constraint_name = 'HXC_ALIAS_TYPES_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: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
24: fnd_message.set_token('PROCEDURE', l_proc);
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
25: fnd_message.set_token('STEP','5');
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
26: fnd_message.raise_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
34: End constraint_error;
27: Else
28: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
29: fnd_message.set_token('PROCEDURE', l_proc);
30: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
31: fnd_message.raise_error;
32: End If;
33: --
34: End constraint_error;
35: --
87: Close C_Sel1;
88: --
89: -- The primary key is invalid therefore we must error
90: --
91: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
92: fnd_message.raise_error;
93: End If;
94: Close C_Sel1;
95: If (p_object_version_number
88: --
89: -- The primary key is invalid therefore we must error
90: --
91: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
92: fnd_message.raise_error;
93: End If;
94: Close C_Sel1;
95: If (p_object_version_number
96: <> hxc_hat_shd.g_old_rec.object_version_number) Then
93: End If;
94: Close C_Sel1;
95: If (p_object_version_number
96: <> hxc_hat_shd.g_old_rec.object_version_number) Then
97: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
98: fnd_message.raise_error;
99: End If;
100: l_fct_ret := true;
101: End If;
94: Close C_Sel1;
95: If (p_object_version_number
96: <> hxc_hat_shd.g_old_rec.object_version_number) Then
97: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
98: fnd_message.raise_error;
99: End If;
100: l_fct_ret := true;
101: End If;
102: End If;
153: Close C_Sel1;
154: --
155: -- The primary key is invalid therefore we must error
156: --
157: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: End If;
160: Close C_Sel1;
161: If (p_object_version_number
154: --
155: -- The primary key is invalid therefore we must error
156: --
157: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
158: fnd_message.raise_error;
159: End If;
160: Close C_Sel1;
161: If (p_object_version_number
162: <> hxc_hat_shd.g_old_rec.object_version_number) Then
159: End If;
160: Close C_Sel1;
161: If (p_object_version_number
162: <> hxc_hat_shd.g_old_rec.object_version_number) Then
163: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
164: fnd_message.raise_error;
165: End If;
166: --
167: if g_debug then
160: Close C_Sel1;
161: If (p_object_version_number
162: <> hxc_hat_shd.g_old_rec.object_version_number) Then
163: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
164: fnd_message.raise_error;
165: End If;
166: --
167: if g_debug then
168: hr_utility.set_location(' Leaving:'||l_proc, 10);
175: --
176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
180: fnd_message.set_token('TABLE_NAME', 'hxc_alias_types');
181: fnd_message.raise_error;
182: End lck;
183: --
176: -- The object is locked therefore we need to supply a meaningful
177: -- error message.
178: --
179: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
180: fnd_message.set_token('TABLE_NAME', 'hxc_alias_types');
181: fnd_message.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------
177: -- error message.
178: --
179: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
180: fnd_message.set_token('TABLE_NAME', 'hxc_alias_types');
181: fnd_message.raise_error;
182: End lck;
183: --
184: -- ----------------------------------------------------------------------------
185: -- |-----------------------------< convert_args >-----------------------------|