19: --
20: Begin
21: --
22: If (p_constraint_name = 'OTA_LP_ENROLLMENTS_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 = 'OTA_LP_ENROLLMENTS_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 = 'OTA_LP_ENROLLMENTS_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 = 'OTA_LP_ENROLLMENTS_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: --
128: Close C_Sel1;
129: --
130: -- The primary key is invalid therefore we must error
131: --
132: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: End If;
135: Close C_Sel1;
136: If (p_object_version_number
129: --
130: -- The primary key is invalid therefore we must error
131: --
132: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
133: fnd_message.raise_error;
134: End If;
135: Close C_Sel1;
136: If (p_object_version_number
137: <> ota_lpe_shd.g_old_rec.object_version_number) Then
134: End If;
135: Close C_Sel1;
136: If (p_object_version_number
137: <> ota_lpe_shd.g_old_rec.object_version_number) Then
138: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
139: fnd_message.raise_error;
140: End If;
141: l_fct_ret := true;
142: End If;
135: Close C_Sel1;
136: If (p_object_version_number
137: <> ota_lpe_shd.g_old_rec.object_version_number) Then
138: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
139: fnd_message.raise_error;
140: End If;
141: l_fct_ret := true;
142: End If;
143: End If;
229: Close C_Sel1;
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
230: --
231: -- The primary key is invalid therefore we must error
232: --
233: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
234: fnd_message.raise_error;
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> ota_lpe_shd.g_old_rec.object_version_number) Then
235: End If;
236: Close C_Sel1;
237: If (p_object_version_number
238: <> ota_lpe_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
236: Close C_Sel1;
237: If (p_object_version_number
238: <> ota_lpe_shd.g_old_rec.object_version_number) Then
239: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
240: fnd_message.raise_error;
241: End If;
242: --
243: hr_utility.set_location(' Leaving:'||l_proc, 10);
244: --
249: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'ota_lp_enrollments');
255: fnd_message.raise_error;
256: End lck;
257: --
250: -- The object is locked therefore we need to supply a meaningful
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'ota_lp_enrollments');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
251: -- error message.
252: --
253: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
254: fnd_message.set_token('TABLE_NAME', 'ota_lp_enrollments');
255: fnd_message.raise_error;
256: End lck;
257: --
258: -- ----------------------------------------------------------------------------
259: -- |-----------------------------< convert_args >-----------------------------|