31: --
32: Begin
33: --
34: If (p_constraint_name = 'HXC_MAPPING_COMPS_PK') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
32: Begin
33: --
34: If (p_constraint_name = 'HXC_MAPPING_COMPS_PK') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
33: --
34: If (p_constraint_name = 'HXC_MAPPING_COMPS_PK') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
34: If (p_constraint_name = 'HXC_MAPPING_COMPS_PK') Then
35: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
36: fnd_message.set_token('PROCEDURE', l_proc);
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
37: fnd_message.set_token('STEP','5');
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
38: fnd_message.raise_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
39: Else
40: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
41: fnd_message.set_token('PROCEDURE', l_proc);
42: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
43: fnd_message.raise_error;
44: End If;
45: --
46: End constraint_error;
47: --
105: Close C_Sel1;
106: --
107: -- The primary key is invalid therefore we must error
108: --
109: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
110: fnd_message.raise_error;
111: End If;
112: Close C_Sel1;
113: If (p_object_version_number
106: --
107: -- The primary key is invalid therefore we must error
108: --
109: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
110: fnd_message.raise_error;
111: End If;
112: Close C_Sel1;
113: If (p_object_version_number
114: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
111: End If;
112: Close C_Sel1;
113: If (p_object_version_number
114: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
115: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
116: fnd_message.raise_error;
117: End If;
118: l_fct_ret := true;
119: End If;
112: Close C_Sel1;
113: If (p_object_version_number
114: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
115: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
116: fnd_message.raise_error;
117: End If;
118: l_fct_ret := true;
119: End If;
120: End If;
171: Close C_Sel1;
172: --
173: -- The primary key is invalid therefore we must error
174: --
175: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
176: fnd_message.raise_error;
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
172: --
173: -- The primary key is invalid therefore we must error
174: --
175: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
176: fnd_message.raise_error;
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
180: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
180: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
181: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
182: fnd_message.raise_error;
183: End If;
184: --
185: if g_debug then
178: Close C_Sel1;
179: If (p_object_version_number
180: <> hxc_tcc_shd.g_old_rec.object_version_number) Then
181: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
182: fnd_message.raise_error;
183: End If;
184: --
185: if g_debug then
186: hr_utility.set_location(' Leaving:'||l_proc, 10);
193: --
194: -- The object is locked therefore we need to supply a meaningful
195: -- error message.
196: --
197: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
198: fnd_message.set_token('TABLE_NAME', 'hxc_time_category_comps');
199: fnd_message.raise_error;
200: End lck;
201: --
194: -- The object is locked therefore we need to supply a meaningful
195: -- error message.
196: --
197: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
198: fnd_message.set_token('TABLE_NAME', 'hxc_time_category_comps');
199: fnd_message.raise_error;
200: End lck;
201: --
202: -- ----------------------------------------------------------------------------
195: -- error message.
196: --
197: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
198: fnd_message.set_token('TABLE_NAME', 'hxc_time_category_comps');
199: fnd_message.raise_error;
200: End lck;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |-----------------------------< convert_args >-----------------------------|