19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_ERRORS_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 = 'HXC_ERRORS_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 = 'HXC_ERRORS_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 = 'HXC_ERRORS_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: --
96: Close C_Sel1;
97: --
98: -- The primary key is invalid therefore we must error
99: --
100: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
101: fnd_message.raise_error;
102: End If;
103: Close C_Sel1;
104: -- If (p_object_version_number
97: --
98: -- The primary key is invalid therefore we must error
99: --
100: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
101: fnd_message.raise_error;
102: End If;
103: Close C_Sel1;
104: -- If (p_object_version_number
105: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
102: End If;
103: Close C_Sel1;
104: -- If (p_object_version_number
105: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
106: -- fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
107: -- fnd_message.raise_error;
108: -- End If;
109: l_fct_ret := true;
110: End If;
103: Close C_Sel1;
104: -- If (p_object_version_number
105: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
106: -- fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
107: -- fnd_message.raise_error;
108: -- End If;
109: l_fct_ret := true;
110: End If;
111: End If;
172: Close C_Sel1;
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: -- If (p_object_version_number
173: --
174: -- The primary key is invalid therefore we must error
175: --
176: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
177: fnd_message.raise_error;
178: End If;
179: Close C_Sel1;
180: -- If (p_object_version_number
181: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
178: End If;
179: Close C_Sel1;
180: -- If (p_object_version_number
181: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
182: -- fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: -- fnd_message.raise_error;
184: -- End If;
185: --
186: if g_debug then
179: Close C_Sel1;
180: -- If (p_object_version_number
181: -- <> hxc_err_shd.g_old_rec.object_version_number) Then
182: -- fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
183: -- fnd_message.raise_error;
184: -- End If;
185: --
186: if g_debug then
187: hr_utility.set_location(' Leaving:'||l_proc, 10);
194: --
195: -- The object is locked therefore we need to supply a meaningful
196: -- error message.
197: --
198: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
199: fnd_message.set_token('TABLE_NAME', 'hxc_errors');
200: fnd_message.raise_error;
201: End lck;
202: --
195: -- The object is locked therefore we need to supply a meaningful
196: -- error message.
197: --
198: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
199: fnd_message.set_token('TABLE_NAME', 'hxc_errors');
200: fnd_message.raise_error;
201: End lck;
202: --
203: -- ----------------------------------------------------------------------------
196: -- error message.
197: --
198: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
199: fnd_message.set_token('TABLE_NAME', 'hxc_errors');
200: fnd_message.raise_error;
201: End lck;
202: --
203: -- ----------------------------------------------------------------------------
204: -- |-----------------------------< convert_args >-----------------------------|