35: --
36: If (p_constraint_name = 'BEN_EXT_CRIT_CMBN_FK1') Then
37: ben_utility.child_exists_error(p_table_name => 'BEN_EXT_CRIT_CMBN');
38: ElsIf (p_constraint_name = 'BEN_EXT_CRIT_CMBN_PK') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
36: If (p_constraint_name = 'BEN_EXT_CRIT_CMBN_FK1') Then
37: ben_utility.child_exists_error(p_table_name => 'BEN_EXT_CRIT_CMBN');
38: ElsIf (p_constraint_name = 'BEN_EXT_CRIT_CMBN_PK') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
37: ben_utility.child_exists_error(p_table_name => 'BEN_EXT_CRIT_CMBN');
38: ElsIf (p_constraint_name = 'BEN_EXT_CRIT_CMBN_PK') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
38: ElsIf (p_constraint_name = 'BEN_EXT_CRIT_CMBN_PK') Then
39: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
47: fnd_message.raise_error;
48: End If;
41: fnd_message.set_token('STEP','10');
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
47: fnd_message.raise_error;
48: End If;
49: --
42: fnd_message.raise_error;
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
47: fnd_message.raise_error;
48: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
43: Else
44: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
45: fnd_message.set_token('PROCEDURE', l_proc);
46: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
47: fnd_message.raise_error;
48: End If;
49: --
50: hr_utility.set_location(' Leaving:'||l_proc, 10);
51: End constraint_error;
117: Close C_Sel1;
118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number <> g_old_rec.object_version_number) Then
118: --
119: -- The primary key is invalid therefore we must error
120: --
121: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number <> g_old_rec.object_version_number) Then
126: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
122: fnd_message.raise_error;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number <> g_old_rec.object_version_number) Then
126: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
127: fnd_message.raise_error;
128: End If;
129: hr_utility.set_location(l_proc, 15);
130: l_fct_ret := true;
123: End If;
124: Close C_Sel1;
125: If (p_object_version_number <> g_old_rec.object_version_number) Then
126: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
127: fnd_message.raise_error;
128: End If;
129: hr_utility.set_location(l_proc, 15);
130: l_fct_ret := true;
131: End If;
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: If (p_object_version_number <> g_old_rec.object_version_number) Then
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: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
188: fnd_message.raise_error;
189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
193: fnd_message.raise_error;
194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
189: End If;
190: Close C_Sel1;
191: If (p_object_version_number <> g_old_rec.object_version_number) Then
192: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
193: fnd_message.raise_error;
194: End If;
195: --
196: hr_utility.set_location(' Leaving:'||l_proc, 10);
197: --
202: --
203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
207: fnd_message.set_token('TABLE_NAME', 'ben_ext_crit_cmbn');
208: fnd_message.raise_error;
209: End lck;
210: --
203: -- The object is locked therefore we need to supply a meaningful
204: -- error message.
205: --
206: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
207: fnd_message.set_token('TABLE_NAME', 'ben_ext_crit_cmbn');
208: fnd_message.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------
204: -- error message.
205: --
206: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
207: fnd_message.set_token('TABLE_NAME', 'ben_ext_crit_cmbn');
208: fnd_message.raise_error;
209: End lck;
210: --
211: -- ----------------------------------------------------------------------------
212: -- |-----------------------------< convert_args >-----------------------------|