103: --
104: Begin
105: --
106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then
107: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
104: Begin
105: --
106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then
107: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
105: --
106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then
107: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
106: If (p_constraint_name = 'PER_CAGR_ENTITLEMENT_ITEMS_PK') Then
107: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
114: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
108: fnd_message.set_token('PROCEDURE', l_proc);
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
114: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
115: fnd_message.raise_error;
116: End If;
109: fnd_message.set_token('STEP','5');
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
114: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
115: fnd_message.raise_error;
116: End If;
117: --
110: fnd_message.raise_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
114: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
115: fnd_message.raise_error;
116: End If;
117: --
118: End constraint_error;
111: Else
112: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
113: fnd_message.set_token('PROCEDURE', l_proc);
114: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
115: fnd_message.raise_error;
116: End If;
117: --
118: End constraint_error;
119: --
183: Close C_Sel1;
184: --
185: -- The primary key is invalid therefore we must error
186: --
187: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
188: fnd_message.raise_error;
189: End If;
190: Close C_Sel1;
191: --
184: --
185: -- The primary key is invalid therefore we must error
186: --
187: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
188: fnd_message.raise_error;
189: End If;
190: Close C_Sel1;
191: --
192: l_fct_ret := true;
250: Close C_Sel1;
251: --
252: -- The primary key is invalid therefore we must error
253: --
254: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
255: fnd_message.raise_error;
256: End If;
257: Close C_Sel1;
258: --
251: --
252: -- The primary key is invalid therefore we must error
253: --
254: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
255: fnd_message.raise_error;
256: End If;
257: Close C_Sel1;
258: --
259: If (p_object_version_number <> g_old_rec.object_version_number) Then
270: --
271: -- The object is locked therefore we need to supply a meaningful
272: -- error message.
273: --
274: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
275: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items');
276: fnd_message.raise_error;
277: End lck;
278: --
271: -- The object is locked therefore we need to supply a meaningful
272: -- error message.
273: --
274: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
275: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items');
276: fnd_message.raise_error;
277: End lck;
278: --
279: -- ----------------------------------------------------------------------------
272: -- error message.
273: --
274: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
275: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlement_items');
276: fnd_message.raise_error;
277: End lck;
278: --
279: -- ----------------------------------------------------------------------------
280: -- |-----------------------------< convert_args >-----------------------------|