19: --
20: Begin
21: --
22: If (p_constraint_name = 'HXC_RECURRING_PERIODS_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_RECURRING_PERIODS_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_RECURRING_PERIODS_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_RECURRING_PERIODS_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: --
90: Close C_Sel1;
91: --
92: -- The primary key is invalid therefore we must error
93: --
94: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
95: fnd_message.raise_error;
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
91: --
92: -- The primary key is invalid therefore we must error
93: --
94: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
95: fnd_message.raise_error;
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
96: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
100: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
101: fnd_message.raise_error;
102: End If;
103: l_fct_ret := true;
104: End If;
97: Close C_Sel1;
98: If (p_object_version_number
99: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
100: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
101: fnd_message.raise_error;
102: End If;
103: l_fct_ret := true;
104: End If;
105: End If;
151: Close C_Sel1;
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
152: --
153: -- The primary key is invalid therefore we must error
154: --
155: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
156: fnd_message.raise_error;
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
157: End If;
158: Close C_Sel1;
159: If (p_object_version_number
160: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: --
165: if g_debug then
158: Close C_Sel1;
159: If (p_object_version_number
160: <> hxc_hrp_shd.g_old_rec.object_version_number) Then
161: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
162: fnd_message.raise_error;
163: End If;
164: --
165: if g_debug then
166: hr_utility.set_location(' Leaving:'||l_proc, 10);
173: --
174: -- The object is locked therefore we need to supply a meaningful
175: -- error message.
176: --
177: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
178: fnd_message.set_token('TABLE_NAME', 'hxc_recurring_periods');
179: fnd_message.raise_error;
180: End lck;
181: --
174: -- The object is locked therefore we need to supply a meaningful
175: -- error message.
176: --
177: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
178: fnd_message.set_token('TABLE_NAME', 'hxc_recurring_periods');
179: fnd_message.raise_error;
180: End lck;
181: --
182: -- ----------------------------------------------------------------------------
175: -- error message.
176: --
177: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
178: fnd_message.set_token('TABLE_NAME', 'hxc_recurring_periods');
179: fnd_message.raise_error;
180: End lck;
181: --
182: -- ----------------------------------------------------------------------------
183: -- |-----------------------------< convert_args >-----------------------------|