206:
207: IF c_sel1%NOTFOUND THEN
208: CLOSE c_sel1;
209:
210: fnd_message.set_name ('PAY'
211: ,'HR_7220_INVALID_PRIMARY_KEY');
212:
213: fnd_message.raise_error;
214: END IF;
209:
210: fnd_message.set_name ('PAY'
211: ,'HR_7220_INVALID_PRIMARY_KEY');
212:
213: fnd_message.raise_error;
214: END IF;
215:
216: CLOSE c_sel1;
217:
216: CLOSE c_sel1;
217:
218:
219: IF (p_object_version_number <> g_old_rec.object_version_number) THEN
220: fnd_message.set_name ('PAY'
221: ,'HR_7155_OBJECT_INVALID');
222:
223: fnd_message.raise_error;
224: END IF;
219: IF (p_object_version_number <> g_old_rec.object_version_number) THEN
220: fnd_message.set_name ('PAY'
221: ,'HR_7155_OBJECT_INVALID');
222:
223: fnd_message.raise_error;
224: END IF;
225:
226: hr_utility.set_location (l_proc
227: ,15);
301:
302: IF c_sel1%NOTFOUND THEN
303: CLOSE c_sel1;
304:
305: fnd_message.set_name ('PAY'
306: ,'HR_7220_INVALID_PRIMARY_KEY');
307:
308: fnd_message.raise_error;
309: END IF;
304:
305: fnd_message.set_name ('PAY'
306: ,'HR_7220_INVALID_PRIMARY_KEY');
307:
308: fnd_message.raise_error;
309: END IF;
310:
311: CLOSE c_sel1;
312:
310:
311: CLOSE c_sel1;
312:
313: IF (p_object_version_number <> g_old_rec.object_version_number) THEN
314: fnd_message.set_name ('PAY'
315: ,'HR_7155_OBJECT_INVALID');
316:
317: fnd_message.raise_error;
318: END IF;
313: IF (p_object_version_number <> g_old_rec.object_version_number) THEN
314: fnd_message.set_name ('PAY'
315: ,'HR_7155_OBJECT_INVALID');
316:
317: fnd_message.raise_error;
318: END IF;
319:
320: hr_utility.set_location (' Leaving:'
321: || l_proc
321: || l_proc
322: ,10);
323: EXCEPTION
324: WHEN hr_api.object_locked THEN
325: fnd_message.set_name ('PAY'
326: ,'HR_7165_OBJECT_LOCKED');
327:
328: fnd_message.set_token ('TABLE_NAME'
329: ,'pay_no_altinn_transfers');
324: WHEN hr_api.object_locked THEN
325: fnd_message.set_name ('PAY'
326: ,'HR_7165_OBJECT_LOCKED');
327:
328: fnd_message.set_token ('TABLE_NAME'
329: ,'pay_no_altinn_transfers');
330:
331: fnd_message.raise_error;
332: END lck;
327:
328: fnd_message.set_token ('TABLE_NAME'
329: ,'pay_no_altinn_transfers');
330:
331: fnd_message.raise_error;
332: END lck;
333:
334: FUNCTION return_api_dml_status RETURN boolean IS
335: BEGIN