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.PSA_FUNDS_CHECKER_PKG dependencies on XLA_AE_LINES_GT

Line 9399: | xla_ae_lines_gt psa_xla_ae_lines_logs |

9395: | SLA Table PSA Table |
9396: | ======== ======== |
9397: | xla_events_gt psa_xla_events_logs |
9398: | xla_validation_lines_gt psa_xla_validation_lines_logs |
9399: | xla_ae_lines_gt psa_xla_ae_lines_logs |
9400: | xla_ae_headers_gt psa_xla_ae_headers_logs |
9401: | |
9402: +===========================================================================================*/
9403:

Line 9544: FROM xla_ae_lines_gt ;

9540: bflow_dist_id_char_5,
9541: phase,
9542: sysdate
9543: BULK COLLECT INTO l_xla_ae_lines
9544: FROM xla_ae_lines_gt ;
9545:
9546:
9547: SELECT ae_header_id,
9548: ledger_id,

Line 9682: FROM xla_ae_lines_gt l,

9678: IF (p_error_type = 'BFLOW') THEN
9679: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for BFLOW Errors');
9680: FOR bflow_rec IN (SELECT l.*,
9681: e.entity_id event_entiity_id
9682: FROM xla_ae_lines_gt l,
9683: xla_events_gt e
9684: WHERE l.event_id = e.event_id
9685: AND business_method_code = 'PRIOR_ENTRY'
9686: AND code_combination_status_code = 'INVALID'

Line 9712: FROM xla_ae_lines_gt l

9708: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for Events Not Processed');
9709: FOR events_rec IN (SELECT *
9710: FROM xla_events_gt e
9711: WHERE NOT EXISTS (SELECT 1
9712: FROM xla_ae_lines_gt l
9713: WHERE l.event_id = e.event_id)) LOOP
9714: l_message := 'Event '||events_rec.event_id||' is not processed.';
9715: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
9716: Fnd_Message.Set_Token('PARAM_NAME',l_message);

Line 9804: CURSOR debug_xla_ae_lines_gt IS

9800: event_type_code, funds_status_code, accounting_entry_status_code,
9801: balance_type_code
9802: FROM xla_ae_headers_gt;
9803:
9804: CURSOR debug_xla_ae_lines_gt IS
9805: SELECT event_id, ae_header_id, ae_line_num
9806: FROM xla_ae_lines_gt;
9807:
9808: CURSOR debug_xla_val_lines_gt IS

Line 9806: FROM xla_ae_lines_gt;

9802: FROM xla_ae_headers_gt;
9803:
9804: CURSOR debug_xla_ae_lines_gt IS
9805: SELECT event_id, ae_header_id, ae_line_num
9806: FROM xla_ae_lines_gt;
9807:
9808: CURSOR debug_xla_val_lines_gt IS
9809: SELECT event_id, ae_header_id, ae_line_num, period_name,
9810: accounting_entry_status_code, balancing_line_type

Line 9829: -- XLA_AE_LINES_GT.

9825: status_code
9826: FROM psa_bc_alloc_gt;
9827:
9828: -- Check whether all the events from XLA_EVENTS_GT have come to
9829: -- XLA_AE_LINES_GT.
9830: /* If any event is missed we will treat it as
9831: FATAL error because there was some setup problem in SLA. */
9832: CURSOR c_cnt_events IS
9833: SELECT (SELECT COUNT (*)

Line 9836: FROM xla_ae_lines_gt) ae_event_count

9832: CURSOR c_cnt_events IS
9833: SELECT (SELECT COUNT (*)
9834: FROM xla_events_gt) event_count,
9835: (SELECT COUNT (DISTINCT (event_id))
9836: FROM xla_ae_lines_gt) ae_event_count
9837: FROM DUAL;
9838:
9839: -- check whether allocation attributes are used or not
9840: /* This is to avoid additional processing for allocation attributes

Line 10172: -- are available in XLA_AE_LINES_GT.

10168:
10169: debug_xla ( 'BUDGETARY_CONTROL_START' );
10170:
10171: -- Check whether all the events in XLA_EVENTS_GT
10172: -- are available in XLA_AE_LINES_GT.
10173: /* If some events are missing that means that there is some issue in SLA
10174: setup for the event, that's why SLA didn't put that event to be
10175: considered for accounting. In this case Funds Checker API
10176: will treat this as an FATAL situation and will not process further. */

Line 10185: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);

10181: -- ====== FND LOG ======
10182: psa_utils.debug_other_string(g_error_level,l_full_path,
10183: ' BCTRL -> Count of events in XLA_EVENTS_GT: '||l_event_cnt);
10184: psa_utils.debug_other_string(g_error_level,l_full_path,
10185: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
10186: -- ====== FND LOG ======
10187:
10188: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
10189: fnd_file.put_line(fnd_file.log,'=============================================== ');

Line 10213: and g.event_id not in (select event_id from xla_ae_lines_gt) )

10209: for missing_entity in
10210: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
10211: from xla_transaction_entities_upg e , xla_events_gt g
10212: where g.entity_id = e.entity_id
10213: and g.event_id not in (select event_id from xla_ae_lines_gt) )
10214: loop
10215: fnd_file.put_line(fnd_file.log , ' BC_Event_id ' || missing_entity.event_id || ' Transaction Number ' || missing_entity.transaction_number || ' Distribution id ' || missing_entity.source_id_int_2 );
10216: end loop;
10217:

Line 11007: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_LINES_GT DUMP');

11003: ' BALANCE_TYPE_CODE = '||h.balance_type_code);
11004: -- ====== FND LOG ======
11005: END LOOP;
11006: -- ====== FND LOG ======
11007: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_LINES_GT DUMP');
11008: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
11009:
11010:
11011: -- ====== FND LOG ======

Line 11012: FOR x IN debug_xla_ae_lines_gt

11008: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
11009:
11010:
11011: -- ====== FND LOG ======
11012: FOR x IN debug_xla_ae_lines_gt
11013: LOOP
11014: -- ====== FND LOG ======
11015: psa_utils.debug_other_string(g_error_level,l_full_path, ' EVENT_ID = '||x.event_id||' , '||
11016: ' AE_HEADER_ID = '||x.ae_header_id||' , '||