33: Begin
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_F_FK2') Then
34: hr_utility.set_location('Entering:'||l_proc, 5);
35: --
36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
35: --
36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
36: If (p_constraint_name = 'BEN_DED_SCHED_PY_FREQ_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: ElsIf (p_constraint_name = 'BEN_ACTY_RT_DED_SCHED_F_FK2') Then
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
42: ben_utility.child_exists_error(p_table_name => 'BEN_ACTY_RT_DED_SCHED_F');
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
43: ElsIf (p_constraint_name = 'BEN_PERD_TO_PROC_FK2') Then
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --
44: ben_utility.child_exists_error(p_table_name => 'BEN_PERD_TO_PROC');
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --
52: hr_utility.set_location(' Leaving:'||l_proc, 10);
45: Else
46: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
47: fnd_message.set_token('PROCEDURE', l_proc);
48: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
49: fnd_message.raise_error;
50: End If;
51: --
52: hr_utility.set_location(' Leaving:'||l_proc, 10);
53: End constraint_error;
142: Close C_Sel1;
143: --
144: -- The primary key is invalid therefore we must error
145: --
146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
143: --
144: -- The primary key is invalid therefore we must error
145: --
146: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
147: fnd_message.raise_error;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: hr_utility.set_location(l_proc, 15);
155: l_fct_ret := true;
148: End If;
149: Close C_Sel1;
150: If (p_object_version_number <> g_old_rec.object_version_number) Then
151: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
152: fnd_message.raise_error;
153: End If;
154: hr_utility.set_location(l_proc, 15);
155: l_fct_ret := true;
156: End If;
231: Close C_Sel1;
232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
232: --
233: -- The primary key is invalid therefore we must error
234: --
235: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
236: fnd_message.raise_error;
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
237: End If;
238: Close C_Sel1;
239: If (p_object_version_number <> g_old_rec.object_version_number) Then
240: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
241: fnd_message.raise_error;
242: End If;
243: --
244: hr_utility.set_location(' Leaving:'||l_proc, 10);
245: --
250: --
251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --
251: -- The object is locked therefore we need to supply a meaningful
252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------
252: -- error message.
253: --
254: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
255: fnd_message.set_token('TABLE_NAME', 'ben_ded_sched_py_freq');
256: fnd_message.raise_error;
257: End lck;
258: --
259: -- ----------------------------------------------------------------------------
260: -- |-----------------------------< convert_args >-----------------------------|