19: --
20: Begin
21: --
22: If (p_constraint_name = 'PER_ALLOCATED_CHECKLISTS_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_CHECKLISTS_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_CHECKLISTS_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_CHECKLISTS_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: --
133: Close C_Sel1;
134: --
135: -- The primary key is invalid therefore we must error
136: --
137: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
134: --
135: -- The primary key is invalid therefore we must error
136: --
137: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
138: fnd_message.raise_error;
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> per_pac_shd.g_old_rec.object_version_number) Then
139: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> per_pac_shd.g_old_rec.object_version_number) Then
143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
144: fnd_message.raise_error;
145: End If;
146: l_fct_ret := true;
147: End If;
140: Close C_Sel1;
141: If (p_object_version_number
142: <> per_pac_shd.g_old_rec.object_version_number) Then
143: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
144: fnd_message.raise_error;
145: End If;
146: l_fct_ret := true;
147: End If;
148: End If;
239: Close C_Sel1;
240: --
241: -- The primary key is invalid therefore we must error
242: --
243: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel1;
247: If (p_object_version_number
240: --
241: -- The primary key is invalid therefore we must error
242: --
243: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
244: fnd_message.raise_error;
245: End If;
246: Close C_Sel1;
247: If (p_object_version_number
248: <> per_pac_shd.g_old_rec.object_version_number) Then
245: End If;
246: Close C_Sel1;
247: If (p_object_version_number
248: <> per_pac_shd.g_old_rec.object_version_number) Then
249: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
250: fnd_message.raise_error;
251: End If;
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
246: Close C_Sel1;
247: If (p_object_version_number
248: <> per_pac_shd.g_old_rec.object_version_number) Then
249: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
250: fnd_message.raise_error;
251: End If;
252: --
253: hr_utility.set_location(' Leaving:'||l_proc, 10);
254: --
259: --
260: -- The object is locked therefore we need to supply a meaningful
261: -- error message.
262: --
263: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
264: fnd_message.set_token('TABLE_NAME', 'per_allocated_checklists');
265: fnd_message.raise_error;
266: End lck;
267: --
260: -- The object is locked therefore we need to supply a meaningful
261: -- error message.
262: --
263: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
264: fnd_message.set_token('TABLE_NAME', 'per_allocated_checklists');
265: fnd_message.raise_error;
266: End lck;
267: --
268: -- ----------------------------------------------------------------------------
261: -- error message.
262: --
263: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
264: fnd_message.set_token('TABLE_NAME', 'per_allocated_checklists');
265: fnd_message.raise_error;
266: End lck;
267: --
268: -- ----------------------------------------------------------------------------
269: -- |-----------------------------< convert_args >-----------------------------|