18: --
19: Begin
20: --
21: If (p_constraint_name = 'PER_TASKS_IN_CHECKLIST_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
19: Begin
20: --
21: If (p_constraint_name = 'PER_TASKS_IN_CHECKLIST_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
20: --
21: If (p_constraint_name = 'PER_TASKS_IN_CHECKLIST_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
21: If (p_constraint_name = 'PER_TASKS_IN_CHECKLIST_PK') Then
22: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
23: fnd_message.set_token('PROCEDURE', l_proc);
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
24: fnd_message.set_token('STEP','5');
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
25: fnd_message.raise_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
26: Else
27: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
28: fnd_message.set_token('PROCEDURE', l_proc);
29: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
30: fnd_message.raise_error;
31: End If;
32: --
33: End constraint_error;
34: --
137: Close C_Sel1;
138: --
139: -- The primary key is invalid therefore we must error
140: --
141: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: End If;
144: Close C_Sel1;
145: If (p_object_version_number
138: --
139: -- The primary key is invalid therefore we must error
140: --
141: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
142: fnd_message.raise_error;
143: End If;
144: Close C_Sel1;
145: If (p_object_version_number
146: <> per_ctk_shd.g_old_rec.object_version_number) Then
143: End If;
144: Close C_Sel1;
145: If (p_object_version_number
146: <> per_ctk_shd.g_old_rec.object_version_number) Then
147: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
148: fnd_message.raise_error;
149: End If;
150: l_fct_ret := true;
151: End If;
144: Close C_Sel1;
145: If (p_object_version_number
146: <> per_ctk_shd.g_old_rec.object_version_number) Then
147: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
148: fnd_message.raise_error;
149: End If;
150: l_fct_ret := true;
151: End If;
152: End If;
248: Close C_Sel1;
249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
249: --
250: -- The primary key is invalid therefore we must error
251: --
252: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
253: fnd_message.raise_error;
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> per_ctk_shd.g_old_rec.object_version_number) Then
254: End If;
255: Close C_Sel1;
256: If (p_object_version_number
257: <> per_ctk_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
255: Close C_Sel1;
256: If (p_object_version_number
257: <> per_ctk_shd.g_old_rec.object_version_number) Then
258: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
259: fnd_message.raise_error;
260: End If;
261: --
262: hr_utility.set_location(' Leaving:'||l_proc, 10);
263: --
268: --
269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'per_tasks_in_checklist');
274: fnd_message.raise_error;
275: End lck;
276: --
269: -- The object is locked therefore we need to supply a meaningful
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'per_tasks_in_checklist');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------
270: -- error message.
271: --
272: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
273: fnd_message.set_token('TABLE_NAME', 'per_tasks_in_checklist');
274: fnd_message.raise_error;
275: End lck;
276: --
277: -- ----------------------------------------------------------------------------
278: -- |-----------------------------< convert_args >-----------------------------|