107: close c_sel1;
108:
109: -- the primary key is invalid therefore we must error
110:
111: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
112: fnd_message.raise_error;
113: end if;
114:
115: close c_sel1;
108:
109: -- the primary key is invalid therefore we must error
110:
111: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
112: fnd_message.raise_error;
113: end if;
114:
115: close c_sel1;
116:
115: close c_sel1;
116:
117: if (p_object_version_number
118: <> hxc_tat_shd.g_old_rec.object_version_number) then
119: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
120: fnd_message.raise_error;
121: end if;
122:
123: l_fct_ret := true;
116:
117: if (p_object_version_number
118: <> hxc_tat_shd.g_old_rec.object_version_number) then
119: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
120: fnd_message.raise_error;
121: end if;
122:
123: l_fct_ret := true;
124:
203: close c_sel1;
204:
205: -- the primary key is invalid therefore we must error
206:
207: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
208: fnd_message.raise_error;
209: end if;
210:
211: close c_sel1;
204:
205: -- the primary key is invalid therefore we must error
206:
207: fnd_message.set_name('PAY', 'HR_7220_INVALID_PRIMARY_KEY');
208: fnd_message.raise_error;
209: end if;
210:
211: close c_sel1;
212:
211: close c_sel1;
212:
213: if (p_object_version_number
214: <> hxc_tat_shd.g_old_rec.object_version_number) then
215: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
216: fnd_message.raise_error;
217: end if;
218:
219: if g_debug then
212:
213: if (p_object_version_number
214: <> hxc_tat_shd.g_old_rec.object_version_number) then
215: fnd_message.set_name('PAY', 'HR_7155_OBJECT_INVALID');
216: fnd_message.raise_error;
217: end if;
218:
219: if g_debug then
220: hr_utility.set_location(' Leaving:'||l_proc, 10);
221: end if;
222:
223: exception
224: when hr_api.object_locked then
225: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
226: fnd_message.set_token('TABLE_NAME', 'hxc_time_attributes');
227: fnd_message.raise_error;
228: end lck;
229:
222:
223: exception
224: when hr_api.object_locked then
225: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
226: fnd_message.set_token('TABLE_NAME', 'hxc_time_attributes');
227: fnd_message.raise_error;
228: end lck;
229:
230: -- --------------------------------------------------------------------------
223: exception
224: when hr_api.object_locked then
225: fnd_message.set_name('PAY', 'HR_7165_OBJECT_LOCKED');
226: fnd_message.set_token('TABLE_NAME', 'hxc_time_attributes');
227: fnd_message.raise_error;
228: end lck;
229:
230: -- --------------------------------------------------------------------------
231: -- |-----------------------------< convert_args >---------------------------|