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 299: from xla_events xe

295:
296: --Bug : 8752657 - Check MO security setting
297: select count(1)
298: into l_count
299: from xla_events xe
300: ,xla_transaction_entities xte
301: where xe.application_id=p_application_id
302: and xe.event_id=p_event_id
303: and xe.entity_id=xte.entity_id

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

373: --------------------------------------------------------
374: -- mark event as un-processed so can be re-processed
375: --------------------------------------------------------
376: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
377: trace(p_msg => 'Update xla_events event_id'||p_event_id||' to Unprocessed.',
378: p_module => l_log_module,
379: p_level => C_LEVEL_STATEMENT);
380: END IF;
381: UPDATE XLA_EVENTS

Line 381: UPDATE XLA_EVENTS

377: trace(p_msg => 'Update xla_events event_id'||p_event_id||' to Unprocessed.',
378: p_module => l_log_module,
379: p_level => C_LEVEL_STATEMENT);
380: END IF;
381: UPDATE XLA_EVENTS
382: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
383: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
384: WHERE application_id = p_application_id
385: AND event_id = p_event_id;

Line 382: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED

378: p_module => l_log_module,
379: p_level => C_LEVEL_STATEMENT);
380: END IF;
381: UPDATE XLA_EVENTS
382: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
383: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
384: WHERE application_id = p_application_id
385: AND event_id = p_event_id;
386:

Line 383: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED

379: p_level => C_LEVEL_STATEMENT);
380: END IF;
381: UPDATE XLA_EVENTS
382: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
383: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
384: WHERE application_id = p_application_id
385: AND event_id = p_event_id;
386:
387:

Line 485: xla_events xle,

481: XLA_LEDGER_RELATIONSHIPS_V rs,
482: xla_gl_ledgers_v gl,
483: xla_ae_headers xah,
484: xla_subledgers xsu,
485: xla_events xle,
486: xla_transaction_entities xte
487: WHERE opt.LEDGER_ID = xah.ledger_id
488: AND opt.APPLICATION_ID = xah.application_id
489: AND xsu.application_id = xah.application_id

Line 544: l_event_source_info xla_events_pub_pkg.t_event_source_info;

540: l_mpa_acc_rev_flag VARCHAR2(1);
541: l_bc_flag VARCHAR2(1);
542: l_transfer_request_id INTEGER;
543:
544: l_event_source_info xla_events_pub_pkg.t_event_source_info;
545: l_array_ae_header_id t_array_integer;
546:
547: /* Bug 7011889 - Array to hold ae_header_ids from BULK COLLECT in case of Encumbarance events */
548: l_array_je_header_id xla_je_validation_pkg.t_array_int;

Line 587: from xla_events xe

583:
584: -- Bug :8752657 Check MO security setting
585: select count(1)
586: into l_count
587: from xla_events xe
588: ,xla_transaction_entities xte
589: where xe.application_id=p_application_id
590: and xe.event_id=p_event_id
591: and xe.entity_id=xte.entity_id

Line 665: xla_events xle,

661: XLA_LEDGER_RELATIONSHIPS_V rs,
662: xla_gl_ledgers_v gl,
663: xla_ae_headers xah,
664: xla_subledgers xsu,
665: xla_events xle,
666: xla_transaction_entities xte
667: WHERE opt.LEDGER_ID = xah.ledger_id
668: AND opt.APPLICATION_ID = xah.application_id
669: AND xsu.application_id = xah.application_id

Line 863: FROM xla_events

859: END IF;
860:
861: SELECT entity_id
862: INTO x_rev_entity_id
863: FROM xla_events
864: WHERE application_id = p_application_id
865: AND event_id = x_rev_event_id
866: AND rownum = 1;
867:

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

939: l_event_source_info.ledger_id := l_ledger_id;
940: l_event_source_info.entity_type_code := 'MANUAL';
941:
942: ---------------------------------------------------------------------------------------------
943: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
944: ---------------------------------------------------------------------------------------------
945: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
946: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
947: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',

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

941:
942: ---------------------------------------------------------------------------------------------
943: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
944: ---------------------------------------------------------------------------------------------
945: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
946: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
947: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
948: p_module => l_log_module,
949: p_level => C_LEVEL_STATEMENT);

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

943: -- Currently, xla_events_pkg.validate_event_type_code failes if not MANUAL event type
944: ---------------------------------------------------------------------------------------------
945: -- Currently, xla_events_pkg.validate_event_type_code can only process MANUAL event type
946: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
947: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
948: p_module => l_log_module,
949: p_level => C_LEVEL_STATEMENT);
950: END IF;
951: x_new_event_id := xla_events_pkg.create_manual_event

Line 951: x_new_event_id := xla_events_pkg.create_manual_event

947: trace(p_msg => 'Calling xla_events_pkg.create_manual_event.',
948: p_module => l_log_module,
949: p_level => C_LEVEL_STATEMENT);
950: END IF;
951: x_new_event_id := xla_events_pkg.create_manual_event
952: (p_event_source_info => l_event_source_info
953: ,p_event_type_code => 'MANUAL'
954: ,p_event_date => l_pri_gl_date
955: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

Line 955: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED

951: x_new_event_id := xla_events_pkg.create_manual_event
952: (p_event_source_info => l_event_source_info
953: ,p_event_type_code => 'MANUAL'
954: ,p_event_date => l_pri_gl_date
955: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
956: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
957: ,p_event_number => 1
958: ,p_budgetary_control_flag => l_bc_flag);
959: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 956: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED

952: (p_event_source_info => l_event_source_info
953: ,p_event_type_code => 'MANUAL'
954: ,p_event_date => l_pri_gl_date
955: ,p_event_status_code => xla_events_pub_pkg.C_EVENT_UNPROCESSED
956: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
957: ,p_event_number => 1
958: ,p_budgetary_control_flag => l_bc_flag);
959: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
960: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,

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

956: ,p_process_status_code => xla_events_pkg.C_INTERNAL_UNPROCESSED
957: ,p_event_number => 1
958: ,p_budgetary_control_flag => l_bc_flag);
959: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
960: trace(p_msg => 'Returned from xla_events_pkg.create_manual_event = event id '||x_new_event_id,
961: p_module => l_log_module,
962: p_level => C_LEVEL_STATEMENT);
963: END IF;
964:

Line 968: UPDATE xla_events

964:
965: -----------------------------------------------------
966: -- update new EVENT_ID and ENTITY_ID
967: -----------------------------------------------------
968: UPDATE xla_events
969: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
970: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
971: ,(event_type_code
972: , event_date

Line 969: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED

965: -----------------------------------------------------
966: -- update new EVENT_ID and ENTITY_ID
967: -----------------------------------------------------
968: UPDATE xla_events
969: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
970: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
971: ,(event_type_code
972: , event_date
973: , reference_num_1

Line 970: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED

966: -- update new EVENT_ID and ENTITY_ID
967: -----------------------------------------------------
968: UPDATE xla_events
969: SET event_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
970: , process_status_code = xla_events_pub_pkg.C_EVENT_PROCESSED
971: ,(event_type_code
972: , event_date
973: , reference_num_1
974: , reference_num_2

Line 1032: FROM xla_events

1028: , sysdate
1029: , -1
1030: , -1
1031: , -1
1032: FROM xla_events
1033: WHERE application_id = p_application_id
1034: AND event_id = p_event_id)
1035: WHERE application_id = p_application_id
1036: AND event_id = x_new_event_id

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

1178: using abs(temp_line_num).
1179: */
1180:
1181: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1182: trace(p_msg => 'Update xla_events',
1183: p_module => l_log_module,
1184: p_level => C_LEVEL_STATEMENT);
1185: END IF;
1186: ---------------------------------------------------------

Line 1189: UPDATE XLA_EVENTS

1185: END IF;
1186: ---------------------------------------------------------
1187: -- set original event to Unprocessed
1188: ---------------------------------------------------------
1189: UPDATE XLA_EVENTS
1190: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
1191: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
1192: WHERE application_id = p_application_id
1193: AND event_id = p_event_id;

Line 1190: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED

1186: ---------------------------------------------------------
1187: -- set original event to Unprocessed
1188: ---------------------------------------------------------
1189: UPDATE XLA_EVENTS
1190: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
1191: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
1192: WHERE application_id = p_application_id
1193: AND event_id = p_event_id;
1194:

Line 1191: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED

1187: -- set original event to Unprocessed
1188: ---------------------------------------------------------
1189: UPDATE XLA_EVENTS
1190: SET EVENT_STATUS_CODE = xla_events_pub_pkg.C_EVENT_UNPROCESSED
1191: ,PROCESS_STATUS_CODE = xla_events_pkg.C_INTERNAL_UNPROCESSED
1192: WHERE application_id = p_application_id
1193: AND event_id = p_event_id;
1194:
1195: -------------------------------------------------------------------------------

Line 1331: FROM xla_events

1327:
1328: -- Validation ------------------------------------------------------------------------------------------
1329: SELECT DECODE(NVL(budgetary_control_flag,'N'),'Y', C_STATUS_FUNDS_RESERVE, C_STATUS_FINAL),process_status_code
1330: INTO l_accounting_mode, l_process_status
1331: FROM xla_events
1332: WHERE application_id = p_application_id
1333: AND event_id = p_event_id;
1334:
1335: IF (C_LEVEL_STATEMENT >= g_log_level) THEN

Line 1380: FROM xla_events

1376: -- when BC event failed, l_retcode is still 0, do this check to make sure vent is procesed.
1377: ----------------------------------------------------------------------------------------------
1378: SELECT process_status_code
1379: INTO l_process_status
1380: FROM xla_events
1381: WHERE application_id = p_application_id
1382: AND event_id = p_event_id;
1383:
1384: IF l_retcode = 0 AND l_process_status = 'P' THEN

Line 1832: -- audit xla_events and all related entries

1828: AND ae_line_num = p_ae_line_num;
1829: END IF;
1830:
1831: -----------------------------------------------------
1832: -- audit xla_events and all related entries
1833: -----------------------------------------------------
1834: IF p_event_id IS NOT NULL THEN
1835: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1836: trace(p_msg => 'Audit xla_events.',

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

1832: -- audit xla_events and all related entries
1833: -----------------------------------------------------
1834: IF p_event_id IS NOT NULL THEN
1835: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1836: trace(p_msg => 'Audit xla_events.',
1837: p_module => l_log_module,
1838: p_level => C_LEVEL_STATEMENT);
1839: END IF;
1840: UPDATE XLA_EVENTS

Line 1840: UPDATE XLA_EVENTS

1836: trace(p_msg => 'Audit xla_events.',
1837: p_module => l_log_module,
1838: p_level => C_LEVEL_STATEMENT);
1839: END IF;
1840: UPDATE XLA_EVENTS
1841: SET LAST_UPDATE_DATE = sysdate
1842: ,UPG_BATCH_ID = -9999
1843: WHERE application_id = p_application_id
1844: AND event_id = p_event_id;

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

1844: AND event_id = p_event_id;
1845:
1846: IF p_audit_all = 'Y' THEN
1847: IF (C_LEVEL_STATEMENT >= g_log_level) THEN
1848: trace(p_msg => 'Audit all details of xla_events.',
1849: p_module => l_log_module,
1850: p_level => C_LEVEL_STATEMENT);
1851: END IF;
1852: UPDATE XLA_AE_HEADERS