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_VALIDATION_LINES_GT

Line 9398: | xla_validation_lines_gt psa_xla_validation_lines_logs |

9394: | |
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: +===========================================================================================*/

Line 9504: FROM xla_validation_lines_gt ;

9500: period_name,
9501: phase,
9502: sysdate
9503: BULK COLLECT INTO l_xla_validation_lines
9504: FROM xla_validation_lines_gt ;
9505:
9506:
9507: SELECT ae_header_id,
9508: ae_line_num,

Line 9811: FROM xla_validation_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
9811: FROM xla_validation_lines_gt;
9812:
9813: CURSOR debug_xla_events_gt IS
9814: SELECT application_id, event_id, event_date, event_type_code,
9815: reference_num_1

Line 10744: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT

10740: END IF;
10741:
10742: END LOOP;
10743:
10744: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT
10745:
10746: -- ====== FND LOG ======
10747: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10748: 'of xla_validation_lines_gt');

Line 10748: 'of xla_validation_lines_gt');

10744: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT
10745:
10746: -- ====== FND LOG ======
10747: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10748: 'of xla_validation_lines_gt');
10749: -- ====== FND LOG ======
10750:
10751: -- Bug 5397349 .. Start
10752:

Line 10762: UPDATE xla_validation_lines_gt vl

10758: LOOP
10759: FETCH c_get_result_codes bulk collect into l_result_code_tbl, l_xla_hdr_tbl, l_xla_line_tbl LIMIT 5000;
10760:
10761: FORALL x IN 1..l_result_code_tbl.count
10762: UPDATE xla_validation_lines_gt vl
10763: SET vl.funds_status_code = l_result_code_tbl(x)
10764: WHERE vl.ae_header_id = l_xla_hdr_tbl(x) AND
10765: vl.ae_line_num = l_xla_line_tbl(x) AND
10766: vl.ledger_id = p_ledgerid;

Line 10845: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT

10841: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Updated '||sql%rowcount||' rows of XLA_AE_HEADERS_GT with fail status.');
10842: -- ====== FND LOG ======
10843: END IF;
10844:
10845: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT
10846: UPDATE xla_validation_lines_gt vl
10847: SET vl.funds_status_code = 'F76'
10848: WHERE event_id IN (
10849: SELECT event_id

Line 10846: UPDATE xla_validation_lines_gt vl

10842: -- ====== FND LOG ======
10843: END IF;
10844:
10845: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT
10846: UPDATE xla_validation_lines_gt vl
10847: SET vl.funds_status_code = 'F76'
10848: WHERE event_id IN (
10849: SELECT event_id
10850: FROM psa_bc_alloc_gt

Line 10855: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated ' ||sql%rowcount||' rows of XLA_VALIDATION_LINES_GT with F76 status code.');

10851: WHERE status_code <> 'P');
10852:
10853: IF(SQL%ROWCOUNT<> 0) THEN
10854: -- ====== FND LOG ======
10855: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated ' ||sql%rowcount||' rows of XLA_VALIDATION_LINES_GT with F76 status code.');
10856: -- ====== FND LOG ======
10857: END IF;
10858:
10859: --================== Allocation Attributes second level of validation Logic start =================

Line 10916: UPDATE xla_validation_lines_gt vl

10912: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated funds_status_code of '||
10913: sql%rowcount||' rows successfully of XLA_AE_HEADERS_GT. ');
10914: -- ====== FND LOG ======
10915:
10916: UPDATE xla_validation_lines_gt vl
10917: SET vl.funds_status_code = 'F77'
10918: WHERE vl.ae_header_id IN (SELECT ae_header_id
10919: FROM gl_bc_packets
10920: WHERE result_code = 'F77'

Line 10926: ' rows of XLA_VALIDATION_LINES_GT with F77 status.');

10922: AND serial_id = l_serial_id) and
10923: vl.ledger_id = p_ledgerid;
10924: -- ====== FND LOG ======
10925: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated '||sql%rowcount||
10926: ' rows of XLA_VALIDATION_LINES_GT with F77 status.');
10927: -- ====== FND LOG ======
10928:
10929: -- Reinitialize all the count variables
10930: l_s_status_cnt := 0;

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

11018: -- ====== FND LOG ======
11019: END LOOP;
11020:
11021: -- ====== FND LOG ======
11022: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_VALIDATION_LINES_GT DUMP');
11023: psa_utils.debug_other_string(g_error_level,l_full_path, ' ---------------------------- ');
11024: -- ====== FND LOG ======
11025: FOR y IN debug_xla_val_lines_gt
11026: LOOP