20: --
21: begin
22: --
23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then
24: fnd_message.set_name('HXC', 'HXC_NO_APPROVAL_STYLE');
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
21: begin
22: --
23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then
24: fnd_message.set_name('HXC', 'HXC_NO_APPROVAL_STYLE');
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
22: --
23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then
24: fnd_message.set_name('HXC', 'HXC_NO_APPROVAL_STYLE');
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
23: if (p_constraint_name = 'HXC_TIME_BUILDING_BLOCKS_FK1') Then
24: fnd_message.set_name('HXC', 'HXC_NO_APPROVAL_STYLE');
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
25: fnd_message.set_token('procedure', l_proc);
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: end if;
26: fnd_message.set_token('STEP','5');
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: end if;
34: --
27: fnd_message.raise_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: end if;
34: --
35: end constraint_error;
28: else
29: fnd_message.set_name('PAY', 'HR_7877_API_INVALID_CONSTRAINT');
30: fnd_message.set_token('procedure', l_proc);
31: fnd_message.set_token('CONSTRAINT_NAME', p_constraint_name);
32: fnd_message.raise_error;
33: end if;
34: --
35: end constraint_error;
36: --
108: close c_sel1;
109:
110: -- the primary key is invalid therefore we must error
111:
112: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114:
115: end if;
116:
109:
110: -- the primary key is invalid therefore we must error
111:
112: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
113: fnd_message.raise_error;
114:
115: end if;
116:
117: close c_sel1;
117: close c_sel1;
118:
119: if (p_object_version_number
120: <> hxc_tbb_shd.g_old_rec.object_version_number) Then
121: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
122: fnd_message.raise_error;
123: end if;
124:
125: l_fct_ret := true;
118:
119: if (p_object_version_number
120: <> hxc_tbb_shd.g_old_rec.object_version_number) Then
121: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
122: fnd_message.raise_error;
123: end if;
124:
125: l_fct_ret := true;
126:
195: close c_sel1;
196:
197: -- the primary key is invalid therefore we must error
198:
199: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
200: fnd_message.raise_error;
201: end if;
202:
203: close c_sel1;
196:
197: -- the primary key is invalid therefore we must error
198:
199: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
200: fnd_message.raise_error;
201: end if;
202:
203: close c_sel1;
204:
203: close c_sel1;
204:
205: if (p_object_version_number
206: <> hxc_tbb_shd.g_old_rec.object_version_number) then
207: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
208: fnd_message.raise_error;
209: end if;
210:
211: if g_debug then
204:
205: if (p_object_version_number
206: <> hxc_tbb_shd.g_old_rec.object_version_number) then
207: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
208: fnd_message.raise_error;
209: end if;
210:
211: if g_debug then
212: hr_utility.set_location(' Leaving:'||l_proc, 10);
217:
218: -- the object is locked therefore we need to supply a meaningful
219: -- error message.
220:
221: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
222: fnd_message.set_token('TABLE_NAME', 'hxc_time_building_blocks');
223: fnd_message.raise_error;
224:
225: end lck;
218: -- the object is locked therefore we need to supply a meaningful
219: -- error message.
220:
221: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
222: fnd_message.set_token('TABLE_NAME', 'hxc_time_building_blocks');
223: fnd_message.raise_error;
224:
225: end lck;
226:
219: -- error message.
220:
221: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
222: fnd_message.set_token('TABLE_NAME', 'hxc_time_building_blocks');
223: fnd_message.raise_error;
224:
225: end lck;
226:
227: -- --------------------------------------------------------------------------