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_life_gen;
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_life_gen;
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_pens;
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_pens;
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_nonlife;
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_nonlife;
351: --
352: -- -------------------------------------------------------------------------
370: where action_information_id = p_action_information_id
371: for update nowait;
372: --
373: if p_rec.object_version_number <> p_object_version_number then
374: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
375: fnd_message.raise_error;
376: end if;
377: --
378: if g_debug then
371: for update nowait;
372: --
373: if p_rec.object_version_number <> p_object_version_number then
374: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
375: fnd_message.raise_error;
376: end if;
377: --
378: if g_debug then
379: hr_utility.set_location(l_proc,1000);
380: end if;
381: --
382: exception
383: when hr_api.object_locked then
384: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
385: fnd_message.raise_error;
386: when no_data_found then
387: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
388: fnd_message.raise_error;
381: --
382: exception
383: when hr_api.object_locked then
384: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
385: fnd_message.raise_error;
386: when no_data_found then
387: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
388: fnd_message.raise_error;
389: --
383: when hr_api.object_locked then
384: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
385: fnd_message.raise_error;
386: when no_data_found then
387: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
388: fnd_message.raise_error;
389: --
390: end lock_social;
391: --
384: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
385: fnd_message.raise_error;
386: when no_data_found then
387: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
388: fnd_message.raise_error;
389: --
390: end lock_social;
391: --
392: -- -------------------------------------------------------------------------
410: where action_information_id = p_action_information_id
411: for update nowait;
412: --
413: if p_rec.object_version_number <> p_object_version_number then
414: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
415: fnd_message.raise_error;
416: end if;
417: --
418: if g_debug then
411: for update nowait;
412: --
413: if p_rec.object_version_number <> p_object_version_number then
414: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
415: fnd_message.raise_error;
416: end if;
417: --
418: if g_debug then
419: hr_utility.set_location(l_proc,1000);
420: end if;
421: --
422: exception
423: when hr_api.object_locked then
424: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
425: fnd_message.raise_error;
426: when no_data_found then
427: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
428: fnd_message.raise_error;
421: --
422: exception
423: when hr_api.object_locked then
424: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
425: fnd_message.raise_error;
426: when no_data_found then
427: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
428: fnd_message.raise_error;
429: --
423: when hr_api.object_locked then
424: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
425: fnd_message.raise_error;
426: when no_data_found then
427: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
428: fnd_message.raise_error;
429: --
430: end lock_mutual_aid;
431: --
424: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
425: fnd_message.raise_error;
426: when no_data_found then
427: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
428: fnd_message.raise_error;
429: --
430: end lock_mutual_aid;
431: --
432: -- -------------------------------------------------------------------------
450: where action_information_id = p_action_information_id
451: for update nowait;
452: --
453: if p_rec.object_version_number <> p_object_version_number then
454: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
455: fnd_message.raise_error;
456: end if;
457: --
458: if g_debug then
451: for update nowait;
452: --
453: if p_rec.object_version_number <> p_object_version_number then
454: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
455: fnd_message.raise_error;
456: end if;
457: --
458: if g_debug then
459: hr_utility.set_location(l_proc,1000);
460: end if;
461: --
462: exception
463: when hr_api.object_locked then
464: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
465: fnd_message.raise_error;
466: when no_data_found then
467: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
468: fnd_message.raise_error;
461: --
462: exception
463: when hr_api.object_locked then
464: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
465: fnd_message.raise_error;
466: when no_data_found then
467: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
468: fnd_message.raise_error;
469: --
463: when hr_api.object_locked then
464: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
465: fnd_message.raise_error;
466: when no_data_found then
467: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
468: fnd_message.raise_error;
469: --
470: end lock_spouse;
471: --
464: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
465: fnd_message.raise_error;
466: when no_data_found then
467: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
468: fnd_message.raise_error;
469: --
470: end lock_spouse;
471: --
472: -- -------------------------------------------------------------------------
490: where action_information_id = p_action_information_id
491: for update nowait;
492: --
493: if p_rec.object_version_number <> p_object_version_number then
494: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
495: fnd_message.raise_error;
496: end if;
497: --
498: if g_debug then
491: for update nowait;
492: --
493: if p_rec.object_version_number <> p_object_version_number then
494: fnd_message.set_name('FND','FND_RECORD_CHANGED_ERROR');
495: fnd_message.raise_error;
496: end if;
497: --
498: if g_debug then
499: hr_utility.set_location(l_proc,1000);
500: end if;
501: --
502: exception
503: when hr_api.object_locked then
504: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
505: fnd_message.raise_error;
506: when no_data_found then
507: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
508: fnd_message.raise_error;
501: --
502: exception
503: when hr_api.object_locked then
504: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
505: fnd_message.raise_error;
506: when no_data_found then
507: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
508: fnd_message.raise_error;
509: --
503: when hr_api.object_locked then
504: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
505: fnd_message.raise_error;
506: when no_data_found then
507: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
508: fnd_message.raise_error;
509: --
510: end lock_spouse_inc;
511: --
504: fnd_message.set_name('FND','FND_LOCK_RECORD_ERROR');
505: fnd_message.raise_error;
506: when no_data_found then
507: fnd_message.set_name('FND','FND_RECORD_DELETED_ERROR');
508: fnd_message.raise_error;
509: --
510: end lock_spouse_inc;
511: --
512: -- -------------------------------------------------------------------------