31: --
32: Begin
33: --
34: If (p_constraint_name = 'HXC_MAPPINGS_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_MAPPINGS_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_MAPPINGS_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_MAPPINGS_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: --
98: Close C_Sel1;
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: End If;
105: Close C_Sel1;
106: If (p_object_version_number
99: --
100: -- The primary key is invalid therefore we must error
101: --
102: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
103: fnd_message.raise_error;
104: End If;
105: Close C_Sel1;
106: If (p_object_version_number
107: <> hxc_map_shd.g_old_rec.object_version_number) Then
104: End If;
105: Close C_Sel1;
106: If (p_object_version_number
107: <> hxc_map_shd.g_old_rec.object_version_number) Then
108: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
109: fnd_message.raise_error;
110: End If;
111: l_fct_ret := true;
112: End If;
105: Close C_Sel1;
106: If (p_object_version_number
107: <> hxc_map_shd.g_old_rec.object_version_number) Then
108: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
109: fnd_message.raise_error;
110: End If;
111: l_fct_ret := true;
112: End If;
113: End If;
156: Close C_Sel1;
157: --
158: -- The primary key is invalid therefore we must error
159: --
160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: End If;
163: Close C_Sel1;
164: If (p_object_version_number
157: --
158: -- The primary key is invalid therefore we must error
159: --
160: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
161: fnd_message.raise_error;
162: End If;
163: Close C_Sel1;
164: If (p_object_version_number
165: <> hxc_map_shd.g_old_rec.object_version_number) Then
162: End If;
163: Close C_Sel1;
164: If (p_object_version_number
165: <> hxc_map_shd.g_old_rec.object_version_number) Then
166: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
167: fnd_message.raise_error;
168: End If;
169: --
170: if g_debug then
163: Close C_Sel1;
164: If (p_object_version_number
165: <> hxc_map_shd.g_old_rec.object_version_number) Then
166: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
167: fnd_message.raise_error;
168: End If;
169: --
170: if g_debug then
171: hr_utility.set_location(' Leaving:'||l_proc, 10);
178: --
179: -- The object is locked therefore we need to supply a meaningful
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'hxc_mappings');
184: fnd_message.raise_error;
185: End lck;
186: --
179: -- The object is locked therefore we need to supply a meaningful
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'hxc_mappings');
184: fnd_message.raise_error;
185: End lck;
186: --
187: -- ----------------------------------------------------------------------------
180: -- error message.
181: --
182: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
183: fnd_message.set_token('TABLE_NAME', 'hxc_mappings');
184: fnd_message.raise_error;
185: End lck;
186: --
187: -- ----------------------------------------------------------------------------
188: -- |-----------------------------< convert_args >-----------------------------|