50: where action_information_id = p_action_information_id
51: for update nowait;
52: --
53: if p_rec.object_version_number <> p_object_version_number then
54: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
55: fnd_message.raise_error;
56: end if;
57: --
58: if g_debug then
51: for update nowait;
52: --
53: if p_rec.object_version_number <> p_object_version_number then
54: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
55: fnd_message.raise_error;
56: end if;
57: --
58: if g_debug then
59: hr_utility.set_location(l_proc,1000);
60: end if;
61: --
62: exception
63: when hr_api.object_locked then
64: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
65: fnd_message.raise_error;
66: when no_data_found then
67: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
68: fnd_message.raise_error;
61: --
62: exception
63: when hr_api.object_locked then
64: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
65: fnd_message.raise_error;
66: when no_data_found then
67: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
68: fnd_message.raise_error;
69: --
63: when hr_api.object_locked then
64: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
65: fnd_message.raise_error;
66: when no_data_found then
67: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
68: fnd_message.raise_error;
69: --
70: end lock_pact;
71: --
64: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
65: fnd_message.raise_error;
66: when no_data_found then
67: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
68: fnd_message.raise_error;
69: --
70: end lock_pact;
71: --
72: -- -------------------------------------------------------------------------
90: where action_information_id = p_action_information_id
91: for update nowait;
92: --
93: if p_rec.object_version_number <> p_object_version_number then
94: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
95: fnd_message.raise_error;
96: end if;
97: --
98: if g_debug then
91: for update nowait;
92: --
93: if p_rec.object_version_number <> p_object_version_number then
94: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
95: fnd_message.raise_error;
96: end if;
97: --
98: if g_debug then
99: hr_utility.set_location(l_proc,1000);
100: end if;
101: --
102: exception
103: when hr_api.object_locked then
104: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
105: fnd_message.raise_error;
106: when no_data_found then
107: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
108: fnd_message.raise_error;
101: --
102: exception
103: when hr_api.object_locked then
104: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
105: fnd_message.raise_error;
106: when no_data_found then
107: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
108: fnd_message.raise_error;
109: --
103: when hr_api.object_locked then
104: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
105: fnd_message.raise_error;
106: when no_data_found then
107: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
108: fnd_message.raise_error;
109: --
110: end lock_assact;
111: --
104: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
105: fnd_message.raise_error;
106: when no_data_found then
107: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
108: fnd_message.raise_error;
109: --
110: end lock_assact;
111: --
112: -- -------------------------------------------------------------------------
130: where action_information_id = p_action_information_id
131: for update nowait;
132: --
133: if p_rec.object_version_number <> p_object_version_number then
134: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
135: fnd_message.raise_error;
136: end if;
137: --
138: if g_debug then
131: for update nowait;
132: --
133: if p_rec.object_version_number <> p_object_version_number then
134: fnd_message.set_name('FND', 'FND_RECORD_CHANGED_ERROR');
135: fnd_message.raise_error;
136: end if;
137: --
138: if g_debug then
139: hr_utility.set_location(l_proc,1000);
140: end if;
141: --
142: exception
143: when hr_api.object_locked then
144: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
145: fnd_message.raise_error;
146: when no_data_found then
147: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
148: fnd_message.raise_error;
141: --
142: exception
143: when hr_api.object_locked then
144: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
145: fnd_message.raise_error;
146: when no_data_found then
147: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
148: fnd_message.raise_error;
149: --
143: when hr_api.object_locked then
144: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
145: fnd_message.raise_error;
146: when no_data_found then
147: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
148: fnd_message.raise_error;
149: --
150: end lock_emp;
151: --
144: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
145: fnd_message.raise_error;
146: when no_data_found then
147: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
148: fnd_message.raise_error;
149: --
150: end lock_emp;
151: --
152: -- -------------------------------------------------------------------------
170: where action_information_id = p_action_information_id
171: for update nowait;
172: --
173: if p_rec.object_version_number <> p_object_version_number then
174: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
175: fnd_message.raise_error;
176: end if;
177: --
178: if g_debug then
171: for update nowait;
172: --
173: if p_rec.object_version_number <> p_object_version_number then
174: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
175: fnd_message.raise_error;
176: end if;
177: --
178: if g_debug then
179: hr_utility.set_location(l_proc,1000);
180: end if;
181: --
182: exception
183: when hr_api.object_locked then
184: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
185: fnd_message.raise_error;
186: when no_data_found then
187: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
188: fnd_message.raise_error;
181: --
182: exception
183: when hr_api.object_locked then
184: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
185: fnd_message.raise_error;
186: when no_data_found then
187: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
188: fnd_message.raise_error;
189: --
183: when hr_api.object_locked then
184: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
185: fnd_message.raise_error;
186: when no_data_found then
187: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
188: fnd_message.raise_error;
189: --
190: end lock_entry;
191: --
184: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
185: fnd_message.raise_error;
186: when no_data_found then
187: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
188: fnd_message.raise_error;
189: --
190: end lock_entry;
191: --
192: -- -------------------------------------------------------------------------
210: where action_information_id = p_action_information_id
211: for update nowait;
212: --
213: if p_rec.object_version_number <> p_object_version_number then
214: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
215: fnd_message.raise_error;
216: end if;
217: --
218: if g_debug then
211: for update nowait;
212: --
213: if p_rec.object_version_number <> p_object_version_number then
214: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
215: fnd_message.raise_error;
216: end if;
217: --
218: if g_debug then
219: hr_utility.set_location(l_proc,1000);
220: end if;
221: --
222: exception
223: when hr_api.object_locked then
224: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
225: fnd_message.raise_error;
226: when no_data_found then
227: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
228: fnd_message.raise_error;
221: --
222: exception
223: when hr_api.object_locked then
224: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
225: fnd_message.raise_error;
226: when no_data_found then
227: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
228: fnd_message.raise_error;
229: --
223: when hr_api.object_locked then
224: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
225: fnd_message.raise_error;
226: when no_data_found then
227: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
228: fnd_message.raise_error;
229: --
230: end lock_calc_dct;
231: --
224: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
225: fnd_message.raise_error;
226: when no_data_found then
227: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
228: fnd_message.raise_error;
229: --
230: end lock_calc_dct;
231: --
232: -- -------------------------------------------------------------------------
250: where action_information_id = p_action_information_id
251: for update nowait;
252: --
253: if p_rec.object_version_number <> p_object_version_number then
254: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
255: fnd_message.raise_error;
256: end if;
257: --
258: if g_debug then
251: for update nowait;
252: --
253: if p_rec.object_version_number <> p_object_version_number then
254: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
255: fnd_message.raise_error;
256: end if;
257: --
258: if g_debug then
259: hr_utility.set_location(l_proc,1000);
260: end if;
261: --
262: exception
263: when hr_api.object_locked then
264: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
265: fnd_message.raise_error;
266: when no_data_found then
267: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
268: fnd_message.raise_error;
261: --
262: exception
263: when hr_api.object_locked then
264: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
265: fnd_message.raise_error;
266: when no_data_found then
267: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
268: fnd_message.raise_error;
269: --
263: when hr_api.object_locked then
264: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
265: fnd_message.raise_error;
266: when no_data_found then
267: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
268: fnd_message.raise_error;
269: --
270: end lock_calc_dct2;
271: --
264: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
265: fnd_message.raise_error;
266: when no_data_found then
267: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
268: fnd_message.raise_error;
269: --
270: end lock_calc_dct2;
271: --
272: -- -------------------------------------------------------------------------
290: where action_information_id = p_action_information_id
291: for update nowait;
292: --
293: if p_rec.object_version_number <> p_object_version_number then
294: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
295: fnd_message.raise_error;
296: end if;
297: --
298: if g_debug then
291: for update nowait;
292: --
293: if p_rec.object_version_number <> p_object_version_number then
294: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
295: fnd_message.raise_error;
296: end if;
297: --
298: if g_debug then
299: hr_utility.set_location(l_proc,1000);
300: end if;
301: --
302: exception
303: when hr_api.object_locked then
304: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
305: fnd_message.raise_error;
306: when no_data_found then
307: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
308: fnd_message.raise_error;
301: --
302: exception
303: when hr_api.object_locked then
304: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
305: fnd_message.raise_error;
306: when no_data_found then
307: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
308: fnd_message.raise_error;
309: --
303: when hr_api.object_locked then
304: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
305: fnd_message.raise_error;
306: when no_data_found then
307: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
308: fnd_message.raise_error;
309: --
310: end lock_life_gen;
311:
304: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
305: fnd_message.raise_error;
306: when no_data_found then
307: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
308: fnd_message.raise_error;
309: --
310: end lock_life_gen;
311:
312: -- -------------------------------------------------------------------------
330: where action_information_id = p_action_information_id
331: for update nowait;
332: --
333: if p_rec.object_version_number <> p_object_version_number then
334: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
335: fnd_message.raise_error;
336: end if;
337: --
338: if g_debug then
331: for update nowait;
332: --
333: if p_rec.object_version_number <> p_object_version_number then
334: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
335: fnd_message.raise_error;
336: end if;
337: --
338: if g_debug then
339: hr_utility.set_location(l_proc,1000);
340: end if;
341: --
342: exception
343: when hr_api.object_locked then
344: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
345: fnd_message.raise_error;
346: when no_data_found then
347: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
348: fnd_message.raise_error;
341: --
342: exception
343: when hr_api.object_locked then
344: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
345: fnd_message.raise_error;
346: when no_data_found then
347: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
348: fnd_message.raise_error;
349: --
343: when hr_api.object_locked then
344: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
345: fnd_message.raise_error;
346: when no_data_found then
347: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
348: fnd_message.raise_error;
349: --
350: end lock_care_med;
351: --
344: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
345: fnd_message.raise_error;
346: when no_data_found then
347: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
348: fnd_message.raise_error;
349: --
350: end lock_care_med;
351: --
352: --
371: where action_information_id = p_action_information_id
372: for update nowait;
373: --
374: if p_rec.object_version_number <> p_object_version_number then
375: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
376: fnd_message.raise_error;
377: end if;
378: --
379: if g_debug then
372: for update nowait;
373: --
374: if p_rec.object_version_number <> p_object_version_number then
375: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
376: fnd_message.raise_error;
377: end if;
378: --
379: if g_debug then
380: hr_utility.set_location(l_proc,1000);
381: end if;
382: --
383: exception
384: when hr_api.object_locked then
385: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
386: fnd_message.raise_error;
387: when no_data_found then
388: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
389: fnd_message.raise_error;
382: --
383: exception
384: when hr_api.object_locked then
385: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
386: fnd_message.raise_error;
387: when no_data_found then
388: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
389: fnd_message.raise_error;
390: --
384: when hr_api.object_locked then
385: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
386: fnd_message.raise_error;
387: when no_data_found then
388: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
389: fnd_message.raise_error;
390: --
391: end lock_life_pens;
392: --
385: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
386: fnd_message.raise_error;
387: when no_data_found then
388: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
389: fnd_message.raise_error;
390: --
391: end lock_life_pens;
392: --
393: -- -------------------------------------------------------------------------
411: where action_information_id = p_action_information_id
412: for update nowait;
413: --
414: if p_rec.object_version_number <> p_object_version_number then
415: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
416: fnd_message.raise_error;
417: end if;
418: --
419: if g_debug then
412: for update nowait;
413: --
414: if p_rec.object_version_number <> p_object_version_number then
415: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
416: fnd_message.raise_error;
417: end if;
418: --
419: if g_debug then
420: hr_utility.set_location(l_proc,1000);
421: end if;
422: --
423: exception
424: when hr_api.object_locked then
425: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
426: fnd_message.raise_error;
427: when no_data_found then
428: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
429: fnd_message.raise_error;
422: --
423: exception
424: when hr_api.object_locked then
425: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
426: fnd_message.raise_error;
427: when no_data_found then
428: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
429: fnd_message.raise_error;
430: --
424: when hr_api.object_locked then
425: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
426: fnd_message.raise_error;
427: when no_data_found then
428: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
429: fnd_message.raise_error;
430: --
431: end lock_nonlife;
432: --
425: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
426: fnd_message.raise_error;
427: when no_data_found then
428: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
429: fnd_message.raise_error;
430: --
431: end lock_nonlife;
432: --
433: -- -------------------------------------------------------------------------
451: where action_information_id = p_action_information_id
452: for update nowait;
453: --
454: if p_rec.object_version_number <> p_object_version_number then
455: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
456: fnd_message.raise_error;
457: end if;
458: --
459: if g_debug then
452: for update nowait;
453: --
454: if p_rec.object_version_number <> p_object_version_number then
455: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
456: fnd_message.raise_error;
457: end if;
458: --
459: if g_debug then
460: hr_utility.set_location(l_proc,1000);
461: end if;
462: --
463: exception
464: when hr_api.object_locked then
465: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
466: fnd_message.raise_error;
467: when no_data_found then
468: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
469: fnd_message.raise_error;
462: --
463: exception
464: when hr_api.object_locked then
465: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
466: fnd_message.raise_error;
467: when no_data_found then
468: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
469: fnd_message.raise_error;
470: --
464: when hr_api.object_locked then
465: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
466: fnd_message.raise_error;
467: when no_data_found then
468: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
469: fnd_message.raise_error;
470: --
471: end lock_social;
472: --
465: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
466: fnd_message.raise_error;
467: when no_data_found then
468: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
469: fnd_message.raise_error;
470: --
471: end lock_social;
472: --
473: -- -------------------------------------------------------------------------
491: where action_information_id = p_action_information_id
492: for update nowait;
493: --
494: if p_rec.object_version_number <> p_object_version_number then
495: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
496: fnd_message.raise_error;
497: end if;
498: --
499: if g_debug then
492: for update nowait;
493: --
494: if p_rec.object_version_number <> p_object_version_number then
495: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
496: fnd_message.raise_error;
497: end if;
498: --
499: if g_debug then
500: hr_utility.set_location(l_proc,1000);
501: end if;
502: --
503: exception
504: when hr_api.object_locked then
505: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
506: fnd_message.raise_error;
507: when no_data_found then
508: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
509: fnd_message.raise_error;
502: --
503: exception
504: when hr_api.object_locked then
505: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
506: fnd_message.raise_error;
507: when no_data_found then
508: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
509: fnd_message.raise_error;
510: --
504: when hr_api.object_locked then
505: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
506: fnd_message.raise_error;
507: when no_data_found then
508: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
509: fnd_message.raise_error;
510: --
511: end lock_mutual_aid;
512: --
505: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
506: fnd_message.raise_error;
507: when no_data_found then
508: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
509: fnd_message.raise_error;
510: --
511: end lock_mutual_aid;
512: --
513: -- -------------------------------------------------------------------------
531: where action_information_id = p_action_information_id
532: for update nowait;
533: --
534: if p_rec.object_version_number <> p_object_version_number then
535: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
536: fnd_message.raise_error;
537: end if;
538: --
539: if g_debug then
532: for update nowait;
533: --
534: if p_rec.object_version_number <> p_object_version_number then
535: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
536: fnd_message.raise_error;
537: end if;
538: --
539: if g_debug then
540: hr_utility.set_location(l_proc,1000);
541: end if;
542: --
543: exception
544: when hr_api.object_locked then
545: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
546: fnd_message.raise_error;
547: when no_data_found then
548: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
549: fnd_message.raise_error;
542: --
543: exception
544: when hr_api.object_locked then
545: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
546: fnd_message.raise_error;
547: when no_data_found then
548: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
549: fnd_message.raise_error;
550: --
544: when hr_api.object_locked then
545: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
546: fnd_message.raise_error;
547: when no_data_found then
548: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
549: fnd_message.raise_error;
550: --
551: end lock_spouse;
552: --
545: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
546: fnd_message.raise_error;
547: when no_data_found then
548: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
549: fnd_message.raise_error;
550: --
551: end lock_spouse;
552: --
553: -- -------------------------------------------------------------------------
571: where action_information_id = p_action_information_id
572: for update nowait;
573: --
574: if p_rec.object_version_number <> p_object_version_number then
575: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
576: fnd_message.raise_error;
577: end if;
578: --
579: if g_debug then
572: for update nowait;
573: --
574: if p_rec.object_version_number <> p_object_version_number then
575: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
576: fnd_message.raise_error;
577: end if;
578: --
579: if g_debug then
580: hr_utility.set_location(l_proc,1000);
581: end if;
582: --
583: exception
584: when hr_api.object_locked then
585: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
586: fnd_message.raise_error;
587: when no_data_found then
588: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
589: fnd_message.raise_error;
582: --
583: exception
584: when hr_api.object_locked then
585: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
586: fnd_message.raise_error;
587: when no_data_found then
588: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
589: fnd_message.raise_error;
590: --
584: when hr_api.object_locked then
585: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
586: fnd_message.raise_error;
587: when no_data_found then
588: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
589: fnd_message.raise_error;
590: --
591: end lock_spouse_inc;
592: --
585: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
586: fnd_message.raise_error;
587: when no_data_found then
588: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
589: fnd_message.raise_error;
590: --
591: end lock_spouse_inc;
592: --
593: -- -------------------------------------------------------------------------