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_FSAH_INT_PVT dependencies on XLA_EVENTS

Line 205: xla_events xe,

201: xah.attribute7, xah.attribute8, xah.attribute9,
202: xah.attribute10, xah.attribute11, xah.attribute12,
203: xah.attribute13, xah.attribute14, xah.attribute15
204: FROM xla_ae_headers xah,
205: xla_events xe,
206: xla_transaction_entities xte
207: WHERE xte.entity_id = xah.entity_id
208: AND xte.application_id = xah.application_id
209: AND xe.event_id = xah.event_id

Line 513: l_event_source_info xla_events_pub_pkg.t_event_source_info;

509: )
510: IS
511: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;
512:
513: l_event_source_info xla_events_pub_pkg.t_event_source_info;
514: l_entity_id INTEGER;
515: l_period_name VARCHAR2 (30);
516: l_closing_status VARCHAR2 (30);
517: l_validate_period INTEGER;

Line 594: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,

590: );
591: END IF;
592:
593: p_rev_event_id :=
594: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
595: p_event_type_code => c_event_type_code_manual,
596: p_event_date => p_gl_date,
597: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
598: p_process_status_code => xla_events_pkg.c_internal_unprocessed,

Line 597: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,

593: p_rev_event_id :=
594: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
595: p_event_type_code => c_event_type_code_manual,
596: p_event_date => p_gl_date,
597: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
598: p_process_status_code => xla_events_pkg.c_internal_unprocessed,
599: p_event_number => 1,
600: p_budgetary_control_flag => p_info.budgetary_control_flag
601: );

Line 598: p_process_status_code => xla_events_pkg.c_internal_unprocessed,

594: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
595: p_event_type_code => c_event_type_code_manual,
596: p_event_date => p_gl_date,
597: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
598: p_process_status_code => xla_events_pkg.c_internal_unprocessed,
599: p_event_number => 1,
600: p_budgetary_control_flag => p_info.budgetary_control_flag
601: );
602: --DBMS_OUTPUT.put_line ('After Creating the Event for the reversal entry ');

Line 615: FROM xla_events

611:
612: BEGIN
613: SELECT entity_id
614: INTO l_entity_id
615: FROM xla_events
616: WHERE event_id = p_rev_event_id;
617: EXCEPTION
618: WHEN OTHERS
619: THEN

Line 880: xla_events xe

876: FROM xla_gl_ledgers_v xgl,
877: xla_ae_headers xah,
878: xla_subledgers xsu,
879: xla_transaction_entities e,
880: xla_events xe
881: WHERE xgl.ledger_id = xah.ledger_id
882: AND xsu.application_id = xah.application_id
883: AND xah.event_id = p_event_id
884: AND xah.application_id = p_application_id

Line 917: l_event_source_info xla_events_pub_pkg.t_event_source_info;

913:
914: TYPE t_ae_header_id IS TABLE OF xla_ae_headers.ae_header_id%TYPE;
915:
916: l_ae_header_id INTEGER;
917: l_event_source_info xla_events_pub_pkg.t_event_source_info;
918: l_array_ae_header_id t_array_integer;
919: l_retcode INTEGER;
920: l_log_module VARCHAR2 (240);
921: l_completion_option VARCHAR2 (1);

Line 1043: -- CURRENTLY, XLA_EVENTS_PKG.VALIDATE_EVENT_TYPE_CODE FAILES IF NOT MANUAL EVENT TYPE

1039: l_event_source_info.legal_entity_id := l_legal_entity_id;
1040: l_event_source_info.ledger_id := l_ledger_id;
1041: l_event_source_info.entity_type_code := 'MANUAL';
1042: ---------------------------------------------------------------------------------------------
1043: -- CURRENTLY, XLA_EVENTS_PKG.VALIDATE_EVENT_TYPE_CODE FAILES IF NOT MANUAL EVENT TYPE
1044: ---------------------------------------------------------------------------------------------
1045:
1046: --DBMS_OUTPUT.put_line ('Creating the Reversal Event');
1047:

Line 1057: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,

1053: );
1054: END IF;
1055:
1056: x_new_event_id :=
1057: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
1058: p_event_type_code => 'MANUAL',
1059: p_event_date => l_pri_gl_date,
1060: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
1061: p_process_status_code => xla_events_pkg.c_internal_unprocessed,

Line 1060: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,

1056: x_new_event_id :=
1057: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
1058: p_event_type_code => 'MANUAL',
1059: p_event_date => l_pri_gl_date,
1060: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
1061: p_process_status_code => xla_events_pkg.c_internal_unprocessed,
1062: p_event_number => 1,
1063: p_budgetary_control_flag => l_bc_flag
1064: );

Line 1061: p_process_status_code => xla_events_pkg.c_internal_unprocessed,

1057: xla_events_pkg.create_manual_event (p_event_source_info => l_event_source_info,
1058: p_event_type_code => 'MANUAL',
1059: p_event_date => l_pri_gl_date,
1060: p_event_status_code => xla_events_pub_pkg.c_event_unprocessed,
1061: p_process_status_code => xla_events_pkg.c_internal_unprocessed,
1062: p_event_number => 1,
1063: p_budgetary_control_flag => l_bc_flag
1064: );
1065: /*DBMS_OUTPUT.put_line ( 'RETURNED FROM XLA_EVENTS_PKG.CREATE_MANUAL_EVENT = EVENT ID '

Line 1065: /*DBMS_OUTPUT.put_line ( 'RETURNED FROM XLA_EVENTS_PKG.CREATE_MANUAL_EVENT = EVENT ID '

1061: p_process_status_code => xla_events_pkg.c_internal_unprocessed,
1062: p_event_number => 1,
1063: p_budgetary_control_flag => l_bc_flag
1064: );
1065: /*DBMS_OUTPUT.put_line ( 'RETURNED FROM XLA_EVENTS_PKG.CREATE_MANUAL_EVENT = EVENT ID '
1066: || x_new_event_id
1067: );*/
1068:
1069: IF (c_level_procedure >= g_log_level)

Line 1071: TRACE (p_msg => 'RETURNED FROM XLA_EVENTS_PKG.CREATE_MANUAL_EVENT = EVENT ID '

1067: );*/
1068:
1069: IF (c_level_procedure >= g_log_level)
1070: THEN
1071: TRACE (p_msg => 'RETURNED FROM XLA_EVENTS_PKG.CREATE_MANUAL_EVENT = EVENT ID '
1072: || x_new_event_id,
1073: p_level => c_level_procedure,
1074: p_module => l_log_module
1075: );

Line 1081: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');

1077:
1078: -----------------------------------------------------
1079: -- UPDATE NEW EVENT_ID AND ENTITY_ID
1080: -----------------------------------------------------
1081: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');
1082:
1083: IF (c_level_procedure >= g_log_level)
1084: THEN
1085: TRACE (p_msg => 'Before Updating the xla_events',

Line 1085: TRACE (p_msg => 'Before Updating the xla_events',

1081: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');
1082:
1083: IF (c_level_procedure >= g_log_level)
1084: THEN
1085: TRACE (p_msg => 'Before Updating the xla_events',
1086: p_level => c_level_procedure,
1087: p_module => l_log_module
1088: );
1089: END IF;

Line 1093: UPDATE xla_events

1089: END IF;
1090:
1091: xla_security_pkg.set_security_context (602);
1092:
1093: UPDATE xla_events
1094: SET event_status_code = xla_events_pub_pkg.c_event_processed,
1095: process_status_code = xla_events_pub_pkg.c_event_processed,
1096: (event_type_code, event_date, reference_num_1,
1097: reference_num_2, reference_num_3, reference_num_4,

Line 1094: SET event_status_code = xla_events_pub_pkg.c_event_processed,

1090:
1091: xla_security_pkg.set_security_context (602);
1092:
1093: UPDATE xla_events
1094: SET event_status_code = xla_events_pub_pkg.c_event_processed,
1095: process_status_code = xla_events_pub_pkg.c_event_processed,
1096: (event_type_code, event_date, reference_num_1,
1097: reference_num_2, reference_num_3, reference_num_4,
1098: reference_char_1, reference_char_2, reference_char_3,

Line 1095: process_status_code = xla_events_pub_pkg.c_event_processed,

1091: xla_security_pkg.set_security_context (602);
1092:
1093: UPDATE xla_events
1094: SET event_status_code = xla_events_pub_pkg.c_event_processed,
1095: process_status_code = xla_events_pub_pkg.c_event_processed,
1096: (event_type_code, event_date, reference_num_1,
1097: reference_num_2, reference_num_3, reference_num_4,
1098: reference_char_1, reference_char_2, reference_char_3,
1099: reference_char_4, reference_date_1, reference_date_2,

Line 1122: FROM xla_events

1118: merge_event_set_id -- EVENT_NUMBER
1119: , SYSDATE, fnd_global.user_id,
1120: SYSDATE, fnd_global.user_id, fnd_global.user_id,
1121: SYSDATE, -1, -1, -1
1122: FROM xla_events
1123: WHERE application_id = p_application_id
1124: AND event_id = p_event_id)
1125: WHERE application_id = p_application_id
1126: AND event_id = x_new_event_id

Line 1130: --DBMS_OUTPUT.put_line ('After Updating the xla_events');

1126: AND event_id = x_new_event_id
1127: RETURNING entity_id
1128: INTO x_new_entity_id;
1129:
1130: --DBMS_OUTPUT.put_line ('After Updating the xla_events');
1131:
1132: IF (c_level_procedure >= g_log_level)
1133: THEN
1134: TRACE (p_msg => 'After Updating the xla_events',

Line 1134: TRACE (p_msg => 'After Updating the xla_events',

1130: --DBMS_OUTPUT.put_line ('After Updating the xla_events');
1131:
1132: IF (c_level_procedure >= g_log_level)
1133: THEN
1134: TRACE (p_msg => 'After Updating the xla_events',
1135: p_level => c_level_procedure,
1136: p_module => l_log_module
1137: );
1138: END IF;

Line 1264: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');

1260: AND ae_header_id = l_array_ae_header_id (i);
1261: ---------------------------------------------------------
1262: -- SET ORIGINAL EVENT TO UNPROCESSED
1263: ---------------------------------------------------------
1264: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');
1265:
1266: IF (c_level_procedure >= g_log_level)
1267: THEN
1268: TRACE (p_msg => 'Before Updating Updating the xla_events',

Line 1268: TRACE (p_msg => 'Before Updating Updating the xla_events',

1264: --DBMS_OUTPUT.put_line ('Before Updating the xla_events');
1265:
1266: IF (c_level_procedure >= g_log_level)
1267: THEN
1268: TRACE (p_msg => 'Before Updating Updating the xla_events',
1269: p_level => c_level_procedure,
1270: p_module => l_log_module
1271: );
1272: END IF;

Line 1274: UPDATE xla_events

1270: p_module => l_log_module
1271: );
1272: END IF;
1273:
1274: UPDATE xla_events
1275: SET event_status_code = xla_events_pub_pkg.C_EVENT_INCOMPLETE,
1276: process_status_code = xla_events_pkg.c_internal_unprocessed
1277: WHERE application_id = p_application_id AND event_id = p_event_id;
1278:

Line 1275: SET event_status_code = xla_events_pub_pkg.C_EVENT_INCOMPLETE,

1271: );
1272: END IF;
1273:
1274: UPDATE xla_events
1275: SET event_status_code = xla_events_pub_pkg.C_EVENT_INCOMPLETE,
1276: process_status_code = xla_events_pkg.c_internal_unprocessed
1277: WHERE application_id = p_application_id AND event_id = p_event_id;
1278:
1279: IF (c_level_procedure >= g_log_level)

Line 1276: process_status_code = xla_events_pkg.c_internal_unprocessed

1272: END IF;
1273:
1274: UPDATE xla_events
1275: SET event_status_code = xla_events_pub_pkg.C_EVENT_INCOMPLETE,
1276: process_status_code = xla_events_pkg.c_internal_unprocessed
1277: WHERE application_id = p_application_id AND event_id = p_event_id;
1278:
1279: IF (c_level_procedure >= g_log_level)
1280: THEN

Line 1281: TRACE (p_msg => 'After Updating Updating the xla_events',

1277: WHERE application_id = p_application_id AND event_id = p_event_id;
1278:
1279: IF (c_level_procedure >= g_log_level)
1280: THEN
1281: TRACE (p_msg => 'After Updating Updating the xla_events',
1282: p_level => c_level_procedure,
1283: p_module => l_log_module
1284: );
1285: END IF;

Line 1287: --DBMS_OUTPUT.put_line ('after Updating the xla_events');

1283: p_module => l_log_module
1284: );
1285: END IF;
1286:
1287: --DBMS_OUTPUT.put_line ('after Updating the xla_events');
1288: -----------------------------------------------------------------------------------
1289: -- CURRENTLY, XLA_JOURNAL_ENTRIES_PKG.REVERSE_JOURNAL_ENTRY ONLY PROCESS REVERSAL ENTRY
1290: -----------------------------------------------------------------------------------
1291:

Line 1410: UPDATE xla_events

1406: p_level => c_level_statement
1407: );
1408: END IF;
1409:
1410: UPDATE xla_events
1411: SET event_type_code = 'REVERSAL',
1412: event_status_code = 'P',
1413: process_status_code = 'P'
1414: WHERE event_id = x_rev_event_id;

Line 1578: xla_events xe,

1574: /* BEGIN
1575: SELECT xte.security_id_int_1
1576: INTO l_security_id_int_1
1577: FROM xla_ae_headers xah,
1578: xla_events xe,
1579: xla_transaction_entities xte
1580: WHERE xah.ae_header_id = p_ae_header_id
1581: AND xah.event_id = xe.event_id
1582: AND xah.application_id = xe.application_id