eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.XLA_DATAFIXES_PUB dependencies on XLA_EVENTS

Line 195: trace(p_msg => 'Update xla_events event_id'||p_event_id||' to Unprocessed.',

191: --------------------------------------------------------
192: -- mark event as un-processed so can be re-processed
193: --------------------------------------------------------
194: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
195: trace(p_msg => 'Update xla_events event_id'||p_event_id||' to Unprocessed.',
196: p_module => l_log_module,
197: p_level => C_LEVEL_STATEMENT);
198: END IF;
199: UPDATE XLA_EVENTS

Line 199: UPDATE XLA_EVENTS

195: trace(p_msg => 'Update xla_events event_id'||p_event_id||' to Unprocessed.',
196: p_module => l_log_module,
197: p_level => C_LEVEL_STATEMENT);
198: END IF;
199: UPDATE XLA_EVENTS
200: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
201: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
202: WHERE application_id = p_application_id
203: AND event_id = p_event_id;

Line 200: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED

196: p_module => l_log_module,
197: p_level => C_LEVEL_STATEMENT);
198: END IF;
199: UPDATE XLA_EVENTS
200: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
201: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
202: WHERE application_id = p_application_id
203: AND event_id = p_event_id;
204:

Line 201: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED

197: p_level => C_LEVEL_STATEMENT);
198: END IF;
199: UPDATE XLA_EVENTS
200: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
201: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
202: WHERE application_id = p_application_id
203: AND event_id = p_event_id;
204:
205:

Line 295: , xla_events xe

291: FROM xla_gl_ledgers_v xgl
292: , xla_ae_headers xah
293: , xla_subledgers xsu
294: , xla_transaction_entities e
295: , xla_events xe
296: WHERE xgl.ledger_id = xah.ledger_id
297: AND xsu.application_id = xah.application_id
298: AND xah.event_id = p_event_id
299: AND xah.application_id = p_application_id

Line 325: l_event_source_info xla_events_pub_pkg.t_event_source_info;

321: l_mpa_acc_rev_flag VARCHAR2(1);
322: l_bc_flag VARCHAR2(1);
323: l_transfer_request_id INTEGER;
324:
325: l_event_source_info xla_events_pub_pkg.t_event_source_info;
326: l_array_ae_header_id t_array_integer;
327:
328: /* Bug 7011889 - Array to hold ae_header_ids from BULK COLLECT in case of Encumbarance events */
329: l_array_je_header_id xla_je_validation_pkg.t_array_int;

Line 394: , xla_events xe

390: FROM xla_gl_ledgers_v xgl
391: , xla_ae_headers xah
392: , xla_subledgers xsu
393: , xla_transaction_entities e
394: , xla_events xe
395: WHERE xgl.ledger_id = xah.ledger_id
396: AND xsu.application_id = xah.application_id
397: AND xah.event_id = p_event_id
398: AND xah.application_id = p_application_id

Line 572: FROM xla_events

568: END IF;
569:
570: SELECT entity_id
571: INTO x_rev_entity_id
572: FROM xla_events
573: WHERE application_id = p_application_id
574: AND event_id = x_rev_event_id
575: AND rownum = 1;
576:

Line 652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type

648: l_event_source_info.ledger_id := l_ledger_id;
649: l_event_source_info.entity_type_code := 'MANUAL';
650:
651: ---------------------------------------------------------------------------------------------
652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',

Line 654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type

650:
651: ---------------------------------------------------------------------------------------------
652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);

Line 656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',

652: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
653: ---------------------------------------------------------------------------------------------
654: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
655: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);
659: END IF;
660: x_new_event_id := xla_events_pkg.create_manual_event

Line 660: x_new_event_id := xla_events_pkg.create_manual_event

656: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
657: p_module => l_log_module,
658: p_level => C_LEVEL_STATEMENT);
659: END IF;
660: x_new_event_id := xla_events_pkg.create_manual_event
661: (p_event_source_info => l_event_source_info
662: ,p_event_type_code => 'MANUAL'
663: ,p_event_date => l_pri_gl_date
664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

Line 664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

660: x_new_event_id := xla_events_pkg.create_manual_event
661: (p_event_source_info => l_event_source_info
662: ,p_event_type_code => 'MANUAL'
663: ,p_event_date => l_pri_gl_date
664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
666: ,p_event_number => 1
667: ,p_budgetary_control_flag => l_bc_flag);
668: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED

661: (p_event_source_info => l_event_source_info
662: ,p_event_type_code => 'MANUAL'
663: ,p_event_date => l_pri_gl_date
664: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
666: ,p_event_number => 1
667: ,p_budgetary_control_flag => l_bc_flag);
668: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
669: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,

Line 669: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,

665: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
666: ,p_event_number => 1
667: ,p_budgetary_control_flag => l_bc_flag);
668: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
669: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,
670: p_module => l_log_module,
671: p_level => C_LEVEL_STATEMENT);
672: END IF;
673:

Line 677: UPDATE xla_events

673:
674: -----------------------------------------------------
675: -- update new EVENT_ID and ENTITY_ID
676: -----------------------------------------------------
677: UPDATE xla_events
678: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
679: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
680: ,(event_type_code
681: , event_date

Line 678: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED

674: -----------------------------------------------------
675: -- update new EVENT_ID and ENTITY_ID
676: -----------------------------------------------------
677: UPDATE xla_events
678: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
679: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
680: ,(event_type_code
681: , event_date
682: , reference_num_1

Line 679: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED

675: -- update new EVENT_ID and ENTITY_ID
676: -----------------------------------------------------
677: UPDATE xla_events
678: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
679: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
680: ,(event_type_code
681: , event_date
682: , reference_num_1
683: , reference_num_2

Line 741: FROM xla_events

737: , sysdate
738: , -1
739: , -1
740: , -1
741: FROM xla_events
742: WHERE application_id = p_application_id
743: AND event_id = p_event_id)
744: WHERE application_id = p_application_id
745: AND event_id = x_new_event_id

Line 866: trace(p_msg => 'Update xla_events',

862: AND ae_header_id = l_array_ae_header_id(i);
863:
864:
865: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
866: trace(p_msg => 'Update xla_events',
867: p_module => l_log_module,
868: p_level => C_LEVEL_STATEMENT);
869: END IF;
870: ---------------------------------------------------------

Line 873: UPDATE XLA_EVENTS

869: END IF;
870: ---------------------------------------------------------
871: -- set original event to Unprocessed
872: ---------------------------------------------------------
873: UPDATE XLA_EVENTS
874: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
875: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
876: WHERE application_id = p_application_id
877: AND event_id = p_event_id;

Line 874: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED

870: ---------------------------------------------------------
871: -- set original event to Unprocessed
872: ---------------------------------------------------------
873: UPDATE XLA_EVENTS
874: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
875: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
876: WHERE application_id = p_application_id
877: AND event_id = p_event_id;
878:

Line 875: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED

871: -- set original event to Unprocessed
872: ---------------------------------------------------------
873: UPDATE XLA_EVENTS
874: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
875: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
876: WHERE application_id = p_application_id
877: AND event_id = p_event_id;
878:
879: -------------------------------------------------------------------------------

Line 998: FROM xla_events

994:
995: -- Validation ------------------------------------------------------------------------------------------
996: SELECT DECODE(NVL(budgetary_control_flag,'N'),'Y', C_STATUS_FUNDS_RESERVE, C_STATUS_FINAL),process_status_code
997: INTO l_accounting_mode, l_process_status
998: FROM xla_events
999: WHERE application_id = p_application_id
1000: AND event_id = p_event_id;
1001:
1002: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1047: FROM xla_events

1043: -- when BC event failed, l_retcode is still 0, do this check to make sure vent is procesed.
1044: ----------------------------------------------------------------------------------------------
1045: SELECT process_status_code
1046: INTO l_process_status
1047: FROM xla_events
1048: WHERE application_id = p_application_id
1049: AND event_id = p_event_id;
1050:
1051: IF l_retcode = 0 AND l_process_status = 'P' THEN

Line 1385: -- audit xla_events and all related entries

1381: AND ae_line_num = p_ae_line_num;
1382: END IF;
1383:
1384: -----------------------------------------------------
1385: -- audit xla_events and all related entries
1386: -----------------------------------------------------
1387: IF p_event_id IS NOT NULL THEN
1388: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1389: trace(p_msg => 'Audit xla_events.',

Line 1389: trace(p_msg => 'Audit xla_events.',

1385: -- audit xla_events and all related entries
1386: -----------------------------------------------------
1387: IF p_event_id IS NOT NULL THEN
1388: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1389: trace(p_msg => 'Audit xla_events.',
1390: p_module => l_log_module,
1391: p_level => C_LEVEL_STATEMENT);
1392: END IF;
1393: UPDATE XLA_EVENTS

Line 1393: UPDATE XLA_EVENTS

1389: trace(p_msg => 'Audit xla_events.',
1390: p_module => l_log_module,
1391: p_level => C_LEVEL_STATEMENT);
1392: END IF;
1393: UPDATE XLA_EVENTS
1394: SET LAST_UPDATE_DATE = sysdate
1395: ,UPG_BATCH_ID = -9999
1396: WHERE application_id = p_application_id
1397: AND event_id = p_event_id;

Line 1401: trace(p_msg => 'Audit all details of xla_events.',

1397: AND event_id = p_event_id;
1398:
1399: IF p_audit_all = 'Y' THEN
1400: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1401: trace(p_msg => 'Audit all details of xla_events.',
1402: p_module => l_log_module,
1403: p_level => C_LEVEL_STATEMENT);
1404: END IF;
1405: UPDATE XLA_AE_HEADERS