APPS.FV_SLA_AR_PROCESSING_PKG dependencies on XLA_EVENTS

Line 377: FROM xla_events e,

373: SELECT t.source_id_int_1,
374: t.entity_code
375: INTO l_transcation_id,
376: l_entity_code
377: FROM xla_events e,
378: xla_transaction_entities t
379: WHERE e.entity_id = t.entity_id
380: AND e.event_id = p_event_id;
381:

Line 390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);

386: p_error_code := c_FAILURE;
387: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
388: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
389: p_error_desc := fnd_message.get;
390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);
391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);
392: END;
393:
394: p_rec_atrribute_id := NULL;

Line 391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);

387: fnd_message.set_name('FND', 'FND_GENERIC_MESSAGE');
388: fnd_message.set_token('MESSAGE' , 'System Error :'||SQLERRM);
389: p_error_desc := fnd_message.get;
390: stack_error (l_procedure_name, 'xla_events_tab', p_error_desc);
391: trace(C_STATE_LEVEL, l_procedure_name, 'ERROR:xla_events_tab:'||p_error_desc);
392: END;
393:
394: p_rec_atrribute_id := NULL;
395: IF (p_error_code = c_SUCCESS) THEN

Line 665: FROM xla_events_gt

661: END IF;
662:
663: l_index:=0;
664: FOR event_rec IN (SELECT *
665: FROM xla_events_gt
666: WHERE application_id = p_application_id) LOOP
667: fv_sla_utl_processing_pkg.get_ledger_info
668: (
669: p_ledger_id => event_rec.ledger_id,

Line 803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

799: -- Update process status code to E
800: IF (event_rec.event_id is not null) THEN
801:
802: BEGIN
803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
804: update xla_events_gt
805: set PROCESS_STATUS_CODE='E'
806: where event_id=event_rec.event_id
807: and application_id=p_application_id;

Line 804: update xla_events_gt

800: IF (event_rec.event_id is not null) THEN
801:
802: BEGIN
803: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
804: update xla_events_gt
805: set PROCESS_STATUS_CODE='E'
806: where event_id=event_rec.event_id
807: and application_id=p_application_id;
808: EXCEPTION

Line 916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

912: -- Update process status code to E
913: IF (event_rec.event_id is not null) THEN
914:
915: BEGIN
916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
917: update xla_events_gt
918: set PROCESS_STATUS_CODE='E'
919: where event_id=event_rec.event_id
920: and application_id=p_application_id;

Line 917: update xla_events_gt

913: IF (event_rec.event_id is not null) THEN
914:
915: BEGIN
916: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
917: update xla_events_gt
918: set PROCESS_STATUS_CODE='E'
919: where event_id=event_rec.event_id
920: and application_id=p_application_id;
921: EXCEPTION

Line 1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');

1019: -- Update process status code to E
1020: IF (event_rec.event_id is not null) THEN
1021:
1022: BEGIN
1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
1024: update xla_events_gt
1025: set PROCESS_STATUS_CODE='E'
1026: where event_id=event_rec.event_id
1027: and application_id=p_application_id;

Line 1024: update xla_events_gt

1020: IF (event_rec.event_id is not null) THEN
1021:
1022: BEGIN
1023: trace(C_STATE_LEVEL, l_procedure_name, ' Before updating xla_events_gt');
1024: update xla_events_gt
1025: set PROCESS_STATUS_CODE='E'
1026: where event_id=event_rec.event_id
1027: and application_id=p_application_id;
1028: EXCEPTION