19: --
20: Begin
21: --
22: If (p_constraint_name = 'PER_ALLOCATED_TASKS_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 = 'PER_ALLOCATED_TASKS_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 = 'PER_ALLOCATED_TASKS_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 = 'PER_ALLOCATED_TASKS_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: --
141: Close C_Sel1;
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number
142: --
143: -- The primary key is invalid therefore we must error
144: --
145: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
146: fnd_message.raise_error;
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number
150: <> per_pat_shd.g_old_rec.object_version_number) Then
147: End If;
148: Close C_Sel1;
149: If (p_object_version_number
150: <> per_pat_shd.g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: l_fct_ret := true;
155: End If;
148: Close C_Sel1;
149: If (p_object_version_number
150: <> per_pat_shd.g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: l_fct_ret := true;
155: End If;
156: End If;
255: Close C_Sel1;
256: --
257: -- The primary key is invalid therefore we must error
258: --
259: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
260: fnd_message.raise_error;
261: End If;
262: Close C_Sel1;
263: If (p_object_version_number
256: --
257: -- The primary key is invalid therefore we must error
258: --
259: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
260: fnd_message.raise_error;
261: End If;
262: Close C_Sel1;
263: If (p_object_version_number
264: <> per_pat_shd.g_old_rec.object_version_number) Then
261: End If;
262: Close C_Sel1;
263: If (p_object_version_number
264: <> per_pat_shd.g_old_rec.object_version_number) Then
265: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
266: fnd_message.raise_error;
267: End If;
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
262: Close C_Sel1;
263: If (p_object_version_number
264: <> per_pat_shd.g_old_rec.object_version_number) Then
265: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
266: fnd_message.raise_error;
267: End If;
268: --
269: hr_utility.set_location(' Leaving:'||l_proc, 10);
270: --
275: --
276: -- The object is locked therefore we need to supply a meaningful
277: -- error message.
278: --
279: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
280: fnd_message.set_token('TABLE_NAME', 'per_allocated_tasks');
281: fnd_message.raise_error;
282: End lck;
283: --
276: -- The object is locked therefore we need to supply a meaningful
277: -- error message.
278: --
279: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
280: fnd_message.set_token('TABLE_NAME', 'per_allocated_tasks');
281: fnd_message.raise_error;
282: End lck;
283: --
284: -- ----------------------------------------------------------------------------
277: -- error message.
278: --
279: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
280: fnd_message.set_token('TABLE_NAME', 'per_allocated_tasks');
281: fnd_message.raise_error;
282: End lck;
283: --
284: -- ----------------------------------------------------------------------------
285: -- |-----------------------------< convert_args >-----------------------------|