77: fnd_log.string(p_level, p_module, p_msg);
78: END IF;
79:
80: EXCEPTION
81: WHEN xla_exceptions_pkg.application_exception THEN
82: RAISE;
83: WHEN OTHERS THEN
84: xla_exceptions_pkg.raise_message
85: (p_location => 'xla_cmp_lock_pkg.trace');
80: EXCEPTION
81: WHEN xla_exceptions_pkg.application_exception THEN
82: RAISE;
83: WHEN OTHERS THEN
84: xla_exceptions_pkg.raise_message
85: (p_location => 'xla_cmp_lock_pkg.trace');
86: END trace;
87:
88:
157: ,p_msg => 'Unable to lock the records'
158: ,p_level => C_LEVEL_EXCEPTION);
159: END IF;
160: RETURN FALSE;
161: WHEN xla_exceptions_pkg.application_exception THEN
162: RAISE;
163: WHEN OTHERS THEN
164: xla_exceptions_pkg.raise_message
165: (p_location => 'xla_cmp_lock_pkg.lock_tats_and_sources');
160: RETURN FALSE;
161: WHEN xla_exceptions_pkg.application_exception THEN
162: RAISE;
163: WHEN OTHERS THEN
164: xla_exceptions_pkg.raise_message
165: (p_location => 'xla_cmp_lock_pkg.lock_tats_and_sources');
166:
167: END lock_tats_and_sources;
168:
209: EXCEPTION
210: WHEN le_resource_busy
211: THEN
212: RETURN FALSE;
213: WHEN xla_exceptions_pkg.application_exception THEN
214: RAISE;
215: WHEN OTHERS THEN
216: xla_exceptions_pkg.raise_message
217: (p_location => 'xla_cmp_lock_pkg.lock_tad');
212: RETURN FALSE;
213: WHEN xla_exceptions_pkg.application_exception THEN
214: RAISE;
215: WHEN OTHERS THEN
216: xla_exceptions_pkg.raise_message
217: (p_location => 'xla_cmp_lock_pkg.lock_tad');
218:
219:
220: END lock_tad;
256: EXCEPTION
257: WHEN le_resource_busy
258: THEN
259: RETURN FALSE;
260: WHEN xla_exceptions_pkg.application_exception THEN
261: RAISE;
262: WHEN OTHERS THEN
263: xla_exceptions_pkg.raise_message
264: (p_location => 'xla_cmp_lock_pkg.lock_tad_details');
259: RETURN FALSE;
260: WHEN xla_exceptions_pkg.application_exception THEN
261: RAISE;
262: WHEN OTHERS THEN
263: xla_exceptions_pkg.raise_message
264: (p_location => 'xla_cmp_lock_pkg.lock_tad_details');
265:
266: END lock_tad_details;
267:
302: EXCEPTION
303: WHEN le_resource_busy
304: THEN
305: RETURN FALSE;
306: WHEN xla_exceptions_pkg.application_exception THEN
307: RAISE;
308: WHEN OTHERS THEN
309: xla_exceptions_pkg.raise_message
310: (p_location => 'xla_cmp_lock_pkg.lock_adr');
305: RETURN FALSE;
306: WHEN xla_exceptions_pkg.application_exception THEN
307: RAISE;
308: WHEN OTHERS THEN
309: xla_exceptions_pkg.raise_message
310: (p_location => 'xla_cmp_lock_pkg.lock_adr');
311:
312: END lock_adr;
313:
347: EXCEPTION
348: WHEN le_resource_busy
349: THEN
350: RETURN FALSE;
351: WHEN xla_exceptions_pkg.application_exception THEN
352: RAISE;
353: WHEN OTHERS THEN
354: xla_exceptions_pkg.raise_message
355: (p_location => 'xla_cmp_lock_pkg.lock_source');
350: RETURN FALSE;
351: WHEN xla_exceptions_pkg.application_exception THEN
352: RAISE;
353: WHEN OTHERS THEN
354: xla_exceptions_pkg.raise_message
355: (p_location => 'xla_cmp_lock_pkg.lock_source');
356:
357: END lock_source;
358:
392: EXCEPTION
393: WHEN le_resource_busy
394: THEN
395: RETURN FALSE;
396: WHEN xla_exceptions_pkg.application_exception THEN
397: RAISE;
398: WHEN OTHERS THEN
399: xla_exceptions_pkg.raise_message
400: (p_location => 'xla_cmp_lock_pkg.lock_adr_detail_conditions');
395: RETURN FALSE;
396: WHEN xla_exceptions_pkg.application_exception THEN
397: RAISE;
398: WHEN OTHERS THEN
399: xla_exceptions_pkg.raise_message
400: (p_location => 'xla_cmp_lock_pkg.lock_adr_detail_conditions');
401:
402: END lock_adr_detail_conditions;
403:
437: EXCEPTION
438: WHEN le_resource_busy
439: THEN
440: RETURN FALSE;
441: WHEN xla_exceptions_pkg.application_exception THEN
442: RAISE;
443: WHEN OTHERS THEN
444: xla_exceptions_pkg.raise_message
445: (p_location => 'xla_cmp_lock_pkg.lock_mapping_set');
440: RETURN FALSE;
441: WHEN xla_exceptions_pkg.application_exception THEN
442: RAISE;
443: WHEN OTHERS THEN
444: xla_exceptions_pkg.raise_message
445: (p_location => 'xla_cmp_lock_pkg.lock_mapping_set');
446:
447: END lock_mapping_set;
448: