31: --
32: Begin
33: --
34: If (p_constraint_name = 'HXC_TIME_APPLICATIONS_PK') 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','5');
38: fnd_message.raise_error;
39: Else
32: Begin
33: --
34: If (p_constraint_name = 'HXC_TIME_APPLICATIONS_PK') 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','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: --
34: If (p_constraint_name = 'HXC_TIME_APPLICATIONS_PK') 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','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
34: If (p_constraint_name = 'HXC_TIME_APPLICATIONS_PK') 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','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
47: --
106: Close C_Sel1;
107: --
108: -- The primary key is invalid therefore we must error
109: --
110: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: End If;
113: Close C_Sel1;
114: If (p_object_version_number
107: --
108: -- The primary key is invalid therefore we must error
109: --
110: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
111: fnd_message.raise_error;
112: End If;
113: Close C_Sel1;
114: If (p_object_version_number
115: <> hxc_htr_shd.g_old_rec.object_version_number) Then
112: End If;
113: Close C_Sel1;
114: If (p_object_version_number
115: <> hxc_htr_shd.g_old_rec.object_version_number) Then
116: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
117: fnd_message.raise_error;
118: End If;
119: l_fct_ret := true;
120: End If;
113: Close C_Sel1;
114: If (p_object_version_number
115: <> hxc_htr_shd.g_old_rec.object_version_number) Then
116: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
117: fnd_message.raise_error;
118: End If;
119: l_fct_ret := true;
120: End If;
121: End If;
178: Close C_Sel1;
179: --
180: -- The primary key is invalid therefore we must error
181: --
182: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
183: fnd_message.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number
179: --
180: -- The primary key is invalid therefore we must error
181: --
182: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
183: fnd_message.raise_error;
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number
187: <> hxc_htr_shd.g_old_rec.object_version_number) Then
184: End If;
185: Close C_Sel1;
186: If (p_object_version_number
187: <> hxc_htr_shd.g_old_rec.object_version_number) Then
188: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
189: fnd_message.raise_error;
190: End If;
191: --
192: if g_debug then
185: Close C_Sel1;
186: If (p_object_version_number
187: <> hxc_htr_shd.g_old_rec.object_version_number) Then
188: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
189: fnd_message.raise_error;
190: End If;
191: --
192: if g_debug then
193: hr_utility.set_location(' Leaving:'||l_proc, 10);
200: --
201: -- The object is locked therefore we need to supply a meaningful
202: -- error message.
203: --
204: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
205: fnd_message.set_token('TABLE_NAME', 'hxc_time_recipients');
206: fnd_message.raise_error;
207: End lck;
208: --
201: -- The object is locked therefore we need to supply a meaningful
202: -- error message.
203: --
204: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
205: fnd_message.set_token('TABLE_NAME', 'hxc_time_recipients');
206: fnd_message.raise_error;
207: End lck;
208: --
209: -- ----------------------------------------------------------------------------
202: -- error message.
203: --
204: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
205: fnd_message.set_token('TABLE_NAME', 'hxc_time_recipients');
206: fnd_message.raise_error;
207: End lck;
208: --
209: -- ----------------------------------------------------------------------------
210: -- |-----------------------------< convert_args >-----------------------------|