68: --
69: BEGIN
70: --
71: If (p_constraint_name = 'SYS_C00118392') THEN
72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
69: BEGIN
70: --
71: If (p_constraint_name = 'SYS_C00118392') THEN
72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
70: --
71: If (p_constraint_name = 'SYS_C00118392') THEN
72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
71: If (p_constraint_name = 'SYS_C00118392') THEN
72: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
73: fnd_message.set_token('PROCEDURE', l_proc);
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
80: fnd_message.raise_error;
81: END If;
74: fnd_message.set_token('STEP','5');
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
80: fnd_message.raise_error;
81: END If;
82: --
75: fnd_message.raise_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
80: fnd_message.raise_error;
81: END If;
82: --
83: END constraint_error;
76: Else
77: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
78: fnd_message.set_token('PROCEDURE', l_proc);
79: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
80: fnd_message.raise_error;
81: END If;
82: --
83: END constraint_error;
84: --
143: Close C_Sel1;
144: --
145: -- The primary key IS invalid therefore we must error
146: --
147: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: END If;
150: Close C_Sel1;
151: If (p_object_version_number
144: --
145: -- The primary key IS invalid therefore we must error
146: --
147: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
148: fnd_message.raise_error;
149: END If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_pce_shd.g_old_rec.object_version_number) THEN
149: END If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_pce_shd.g_old_rec.object_version_number) THEN
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: END If;
156: l_fct_ret := true;
157: END If;
150: Close C_Sel1;
151: If (p_object_version_number
152: <> per_pce_shd.g_old_rec.object_version_number) THEN
153: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
154: fnd_message.raise_error;
155: END If;
156: l_fct_ret := true;
157: END If;
158: END If;
211: Close C_Sel1;
212: --
213: -- The primary key IS invalid therefore we must error
214: --
215: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
216: fnd_message.raise_error;
217: END If;
218: Close C_Sel1;
219: If (p_object_version_number
212: --
213: -- The primary key IS invalid therefore we must error
214: --
215: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
216: fnd_message.raise_error;
217: END If;
218: Close C_Sel1;
219: If (p_object_version_number
220: <> per_pce_shd.g_old_rec.object_version_number) THEN
217: END If;
218: Close C_Sel1;
219: If (p_object_version_number
220: <> per_pce_shd.g_old_rec.object_version_number) THEN
221: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
222: fnd_message.raise_error;
223: END If;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
218: Close C_Sel1;
219: If (p_object_version_number
220: <> per_pce_shd.g_old_rec.object_version_number) THEN
221: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
222: fnd_message.raise_error;
223: END If;
224: --
225: hr_utility.set_location(' Leaving:'||l_proc, 10);
226: --
231: --
232: -- The object IS locked therefore we need to supply a meaningful
233: -- error message.
234: --
235: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
236: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlements');
237: fnd_message.raise_error;
238: END lck;
239: --
232: -- The object IS locked therefore we need to supply a meaningful
233: -- error message.
234: --
235: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
236: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlements');
237: fnd_message.raise_error;
238: END lck;
239: --
240: -- ----------------------------------------------------------------------------
233: -- error message.
234: --
235: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
236: fnd_message.set_token('TABLE_NAME', 'per_cagr_entitlements');
237: fnd_message.raise_error;
238: END lck;
239: --
240: -- ----------------------------------------------------------------------------
241: -- |-----------------------------< convert_args >-----------------------------|