33: --
34:
35:
36: If (p_constraint_name = 'HXC_TK_GROUP_QUERY_CRITERIA_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
34:
35:
36: If (p_constraint_name = 'HXC_TK_GROUP_QUERY_CRITERIA_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
35:
36: If (p_constraint_name = 'HXC_TK_GROUP_QUERY_CRITERIA_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
36: If (p_constraint_name = 'HXC_TK_GROUP_QUERY_CRITERIA_PK') Then
37: fnd_message.set_name('PAY', 'HR_6153_ALL_PROCEDURE_FAIL');
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
38: fnd_message.set_token('PROCEDURE', l_proc);
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
39: fnd_message.set_token('STEP','5');
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
40: fnd_message.raise_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: End constraint_error;
41: Else
42: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
43: fnd_message.set_token('PROCEDURE', l_proc);
44: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
45: fnd_message.raise_error;
46: End If;
47: --
48: End constraint_error;
49: --
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_tkgqc_shd.g_old_rec.object_version_number) Then
109: End If;
110: Close C_Sel1;
111: If (p_object_version_number
112: <> hxc_tkgqc_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_tkgqc_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;
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_tkgqc_shd.g_old_rec.object_version_number) Then
177: End If;
178: Close C_Sel1;
179: If (p_object_version_number
180: <> hxc_tkgqc_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_tkgqc_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_tk_group_query_criteria');
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_tk_group_query_criteria');
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_tk_group_query_criteria');
199: fnd_message.raise_error;
200: End lck;
201: --
202: -- ----------------------------------------------------------------------------
203: -- |-----------------------------< convert_args >-----------------------------|