29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_SP_PLAN_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','5');
36: fnd_message.raise_error;
37: Else
30: Begin
31: --
32: If (p_constraint_name = 'PER_SP_PLAN_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','5');
36: fnd_message.raise_error;
37: Else
38: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
31: --
32: If (p_constraint_name = 'PER_SP_PLAN_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','5');
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: If (p_constraint_name = 'PER_SP_PLAN_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','5');
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','5');
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','5');
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: --
130: Close C_Sel1;
131: --
132: -- The primary key is invalid therefore we must error
133: --
134: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
135: fnd_message.raise_error;
136: End If;
137: Close C_Sel1;
138: If (p_object_version_number
131: --
132: -- The primary key is invalid therefore we must error
133: --
134: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
135: fnd_message.raise_error;
136: End If;
137: Close C_Sel1;
138: If (p_object_version_number
139: <> per_sph_shd.g_old_rec.object_version_number) Then
136: End If;
137: Close C_Sel1;
138: If (p_object_version_number
139: <> per_sph_shd.g_old_rec.object_version_number) Then
140: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
141: fnd_message.raise_error;
142: End If;
143: l_fct_ret := true;
144: End If;
137: Close C_Sel1;
138: If (p_object_version_number
139: <> per_sph_shd.g_old_rec.object_version_number) Then
140: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
141: fnd_message.raise_error;
142: End If;
143: l_fct_ret := true;
144: End If;
145: End If;
223: Close C_Sel1;
224: --
225: -- The primary key is invalid therefore we must error
226: --
227: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
228: fnd_message.raise_error;
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number
224: --
225: -- The primary key is invalid therefore we must error
226: --
227: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
228: fnd_message.raise_error;
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number
232: <> per_sph_shd.g_old_rec.object_version_number) Then
229: End If;
230: Close C_Sel1;
231: If (p_object_version_number
232: <> per_sph_shd.g_old_rec.object_version_number) Then
233: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
234: fnd_message.raise_error;
235: End If;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
230: Close C_Sel1;
231: If (p_object_version_number
232: <> per_sph_shd.g_old_rec.object_version_number) Then
233: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
234: fnd_message.raise_error;
235: End If;
236: --
237: hr_utility.set_location(' Leaving:'||l_proc, 10);
238: --
243: --
244: -- The object is locked therefore we need to supply a meaningful
245: -- error message.
246: --
247: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
248: fnd_message.set_token('TABLE_NAME', 'per_sp_plan');
249: fnd_message.raise_error;
250: End lck;
251: --
244: -- The object is locked therefore we need to supply a meaningful
245: -- error message.
246: --
247: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
248: fnd_message.set_token('TABLE_NAME', 'per_sp_plan');
249: fnd_message.raise_error;
250: End lck;
251: --
252: -- ----------------------------------------------------------------------------
245: -- error message.
246: --
247: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
248: fnd_message.set_token('TABLE_NAME', 'per_sp_plan');
249: fnd_message.raise_error;
250: End lck;
251: --
252: -- ----------------------------------------------------------------------------
253: -- |-----------------------------< convert_args >-----------------------------|