30: --
31: Begin
32: --
33: If (p_constraint_name = 'HXC_APPROVAL_STYLES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
31: Begin
32: --
33: If (p_constraint_name = 'HXC_APPROVAL_STYLES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
32: --
33: If (p_constraint_name = 'HXC_APPROVAL_STYLES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
33: If (p_constraint_name = 'HXC_APPROVAL_STYLES_PK') Then
34: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
35: fnd_message.set_token('PROCEDURE', l_proc);
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
36: fnd_message.set_token('STEP','5');
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
37: fnd_message.raise_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
45: End constraint_error;
38: Else
39: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
40: fnd_message.set_token('PROCEDURE', l_proc);
41: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
42: fnd_message.raise_error;
43: End If;
44: --
45: End constraint_error;
46: --
103: Close C_Sel1;
104: --
105: -- The primary key is invalid therefore we must error
106: --
107: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
108: fnd_message.raise_error;
109: End If;
110: Close C_Sel1;
111: If (p_object_version_number
104: --
105: -- The primary key is invalid therefore we must error
106: --
107: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
108: fnd_message.raise_error;
109: End If;
110: Close C_Sel1;
111: If (p_object_version_number
112: <> hxc_has_shd.g_old_rec.object_version_number) Then
109: End If;
110: Close C_Sel1;
111: If (p_object_version_number
112: <> hxc_has_shd.g_old_rec.object_version_number) Then
113: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
114: fnd_message.raise_error;
115: End If;
116: l_fct_ret := true;
117: End If;
110: Close C_Sel1;
111: If (p_object_version_number
112: <> hxc_has_shd.g_old_rec.object_version_number) Then
113: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
114: fnd_message.raise_error;
115: End If;
116: l_fct_ret := true;
117: End If;
118: End If;
166: Close C_Sel1;
167: --
168: -- The primary key is invalid therefore we must error
169: --
170: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
171: fnd_message.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
167: --
168: -- The primary key is invalid therefore we must error
169: --
170: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
171: fnd_message.raise_error;
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_has_shd.g_old_rec.object_version_number) Then
172: End If;
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_has_shd.g_old_rec.object_version_number) Then
176: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
177: fnd_message.raise_error;
178: End If;
179: --
180: if g_debug then
173: Close C_Sel1;
174: If (p_object_version_number
175: <> hxc_has_shd.g_old_rec.object_version_number) Then
176: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
177: fnd_message.raise_error;
178: End If;
179: --
180: if g_debug then
181: hr_utility.set_location(' Leaving:'||l_proc, 10);
188: --
189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_approval_styles');
194: fnd_message.raise_error;
195: End lck;
196: --
189: -- The object is locked therefore we need to supply a meaningful
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_approval_styles');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------
190: -- error message.
191: --
192: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
193: fnd_message.set_token('TABLE_NAME', 'hxc_approval_styles');
194: fnd_message.raise_error;
195: End lck;
196: --
197: -- ----------------------------------------------------------------------------
198: -- |-----------------------------< convert_args >-----------------------------|