29: --
30: Begin
31: --
32: If (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_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: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') Then
30: Begin
31: --
32: If (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_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: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
31: --
32: If (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_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: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') Then
38: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
39: fnd_message.set_token('PROCEDURE', l_proc);
32: If (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_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: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') 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','10');
34: fnd_message.set_token('PROCEDURE', l_proc);
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') 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','10');
41: fnd_message.raise_error;
42: Else
35: fnd_message.set_token('STEP','5');
36: fnd_message.raise_error;
37: ElsIf (p_constraint_name = 'PER_COMPETENCE_OUTCOMES_FK1') 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','10');
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 = 'PER_COMPETENCE_OUTCOMES_FK1') 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','10');
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 = 'PER_COMPETENCE_OUTCOMES_FK1') 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','10');
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','10');
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','10');
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: --
148: Close C_Sel1;
149: --
150: -- The primary key is invalid therefore we must error
151: --
152: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
149: --
150: -- The primary key is invalid therefore we must error
151: --
152: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
153: fnd_message.raise_error;
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> per_cpo_shd.g_old_rec.object_version_number) Then
154: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> per_cpo_shd.g_old_rec.object_version_number) Then
158: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
159: fnd_message.raise_error;
160: End If;
161: l_fct_ret := true;
162: End If;
155: Close C_Sel1;
156: If (p_object_version_number
157: <> per_cpo_shd.g_old_rec.object_version_number) Then
158: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
159: fnd_message.raise_error;
160: End If;
161: l_fct_ret := true;
162: End If;
163: End If;
254: Close C_Sel1;
255: --
256: -- The primary key is invalid therefore we must error
257: --
258: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
259: fnd_message.raise_error;
260: End If;
261: Close C_Sel1;
262: If (p_object_version_number
255: --
256: -- The primary key is invalid therefore we must error
257: --
258: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
259: fnd_message.raise_error;
260: End If;
261: Close C_Sel1;
262: If (p_object_version_number
263: <> per_cpo_shd.g_old_rec.object_version_number) Then
260: End If;
261: Close C_Sel1;
262: If (p_object_version_number
263: <> per_cpo_shd.g_old_rec.object_version_number) Then
264: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
265: fnd_message.raise_error;
266: End If;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
261: Close C_Sel1;
262: If (p_object_version_number
263: <> per_cpo_shd.g_old_rec.object_version_number) Then
264: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
265: fnd_message.raise_error;
266: End If;
267: --
268: hr_utility.set_location(' Leaving:'||l_proc, 10);
269: --
274: --
275: -- The object is locked therefore we need to supply a meaningful
276: -- error message.
277: --
278: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
279: fnd_message.set_token('TABLE_NAME', 'per_competence_outcomes');
280: fnd_message.raise_error;
281: End lck;
282: --
275: -- The object is locked therefore we need to supply a meaningful
276: -- error message.
277: --
278: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
279: fnd_message.set_token('TABLE_NAME', 'per_competence_outcomes');
280: fnd_message.raise_error;
281: End lck;
282: --
283: -- ----------------------------------------------------------------------------
276: -- error message.
277: --
278: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
279: fnd_message.set_token('TABLE_NAME', 'per_competence_outcomes');
280: fnd_message.raise_error;
281: End lck;
282: --
283: -- ----------------------------------------------------------------------------
284: -- |-----------------------------< convert_args >-----------------------------|