DBA Data[Home] [Help]

APPS.XLA_EVENT_CLASSES_PKG dependencies on XLA_UTILITY_PKG

Line 98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);

94: AND entity_code = p_entity_code
95: AND event_class_code = p_event_class_code;
96:
97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

Line 100: xla_utility_pkg.trace('event = '||p_event, 20);

96:
97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:

Line 101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

97: BEGIN
98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN

Line 102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

98: xla_utility_pkg.trace('> xla_event_classes_pkg.class_details_exist' , 10);
99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN
106:

Line 103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);

99:
100: xla_utility_pkg.trace('event = '||p_event, 20);
101: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
102: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
103: xla_utility_pkg.trace('entity_code = '||p_event_class_code , 20);
104:
105: IF p_event = 'DELETE' THEN
106:
107: OPEN check_event_types;

Line 203: xla_utility_pkg.trace('< xla_event_classes_pkg.class_details_exist' , 10);

199: END IF;
200:
201: END IF;
202:
203: xla_utility_pkg.trace('< xla_event_classes_pkg.class_details_exist' , 10);
204: RETURN l_return;
205:
206: EXCEPTION
207: WHEN xla_exceptions_pkg.application_exception THEN

Line 244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);

240: AND entity_code = p_entity_code
241: AND event_class_code = p_event_class_code;
242: BEGIN
243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

Line 246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

242: BEGIN
243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;

Line 247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

243:
244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;
251: l_event_class_code := p_event_class_code;

Line 248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

244: xla_utility_pkg.trace('> xla_event_classes_pkg.delete_class_details' , 10);
245:
246: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
247: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
248: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
249:
250: l_application_id := p_application_id;
251: l_event_class_code := p_event_class_code;
252:

Line 298: xla_utility_pkg.trace('< xla_event_classes_pkg.delete_class_details' , 10);

294: ,x_entity_code => p_entity_code
295: ,x_event_class_code => p_event_class_code
296: ,x_event_type_code => p_event_class_code||'_ALL');
297:
298: xla_utility_pkg.trace('< xla_event_classes_pkg.delete_class_details' , 10);
299:
300: EXCEPTION
301: WHEN xla_exceptions_pkg.application_exception THEN
302: RAISE;

Line 327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);

323: IS
324:
325: BEGIN
326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:

Line 329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

325: BEGIN
326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:

Line 330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);

326:
327: xla_utility_pkg.trace('> xla_event_classes_pkg.create_default_event_type' , 10);
328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:
334: EXCEPTION

Line 332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);

328:
329: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
330: xla_utility_pkg.trace('entity_code = '||p_entity_code , 20);
331:
332: xla_utility_pkg.trace('< xla_event_classes_pkg.create_default_event_type' , 10);
333:
334: EXCEPTION
335: WHEN xla_exceptions_pkg.application_exception THEN
336: RAISE;

Line 391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);

387: l_locked_aad c_locked_aads%rowtype;
388:
389: BEGIN
390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:

Line 393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

389: BEGIN
390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:
396: OPEN c_locked_aads;
397: FETCH c_locked_aads INTO l_locked_aad;

Line 394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

390:
391: xla_utility_pkg.trace('> xla_event_classes_pkg.uncompile_definitions' , 10);
392:
393: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
394: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
395:
396: OPEN c_locked_aads;
397: FETCH c_locked_aads INTO l_locked_aad;
398: IF (c_locked_aads%FOUND) THEN

Line 463: xla_utility_pkg.trace('< xla_event_classes_pkg.uncompile_definitions' , 10);

459: x_event_class_name := l_event_class_name;
460: x_event_type_name := l_event_type_name;
461: x_locking_status_flag := l_locking_status_flag;
462:
463: xla_utility_pkg.trace('< xla_event_classes_pkg.uncompile_definitions' , 10);
464:
465: return l_return;
466:
467: EXCEPTION

Line 512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);

508: AND event_class_code = p_event_class_code
509: AND locking_status_flag = 'Y';
510: BEGIN
511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:

Line 514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);

510: BEGIN
511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:
517: OPEN c_frozen_assignment_exist;
518: FETCH c_frozen_assignment_exist

Line 515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);

511:
512: xla_utility_pkg.trace('> xla_event_classes_pkg.event_class_is_locked' , 10);
513:
514: xla_utility_pkg.trace('application_id = '||p_application_id , 20);
515: xla_utility_pkg.trace('event_class_code = '||p_event_class_code , 20);
516:
517: OPEN c_frozen_assignment_exist;
518: FETCH c_frozen_assignment_exist
519: INTO l_exist;

Line 527: xla_utility_pkg.trace('< xla_event_classes_pkg.event_class_is_locked' , 10);

523: l_return := FALSE;
524: END IF;
525: CLOSE c_frozen_assignment_exist;
526:
527: xla_utility_pkg.trace('< xla_event_classes_pkg.event_class_is_locked' , 10);
528:
529: return l_return;
530:
531: EXCEPTION