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