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_HEADERS_GT

Line 9400: | xla_ae_headers_gt psa_xla_ae_headers_logs |

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:
9404: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,

Line 9557: FROM xla_ae_headers_gt ;

9553: funds_status_code,
9554: phase,
9555: sysdate
9556: BULK COLLECT INTO l_xla_ae_headers
9557: FROM xla_ae_headers_gt ;
9558:
9559: Select application_id ,
9560: event_id,
9561: ae_header_id,

Line 9798: CURSOR debug_xla_ae_headers_gt IS

9794: SELECT ledger_category_code
9795: FROM gl_ledgers
9796: WHERE ledger_id = p_ledgerid;
9797:
9798: CURSOR debug_xla_ae_headers_gt IS
9799: SELECT ae_header_id, ledger_id, entity_id, event_id,
9800: event_type_code, funds_status_code, accounting_entry_status_code,
9801: balance_type_code
9802: FROM xla_ae_headers_gt;

Line 9802: FROM xla_ae_headers_gt;

9798: CURSOR debug_xla_ae_headers_gt IS
9799: SELECT ae_header_id, ledger_id, entity_id, event_id,
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;

Line 10665: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT

10661:
10662: l_ret_code := 'T';
10663: END IF;
10664:
10665: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10666:
10667: -- ====== FND LOG ======
10668: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10669: 'of xla_ae_headers_gt ');

Line 10669: 'of xla_ae_headers_gt ');

10665: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10666:
10667: -- ====== FND LOG ======
10668: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10669: 'of xla_ae_headers_gt ');
10670: -- ====== FND LOG ======
10671:
10672: IF (PSA_BC_XLA_PVT.G_BC_MODE = 'P') AND (l_ret_code <> 'T') THEN
10673: FOR y IN get_status_per_header(l_packets(i))

Line 10703: UPDATE xla_ae_headers_gt

10699: -- ============================== FND LOG =========================
10700: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL l_xla_hdr_status -> '||l_xla_hdr_status);
10701: -- ============================== FND LOG =========================
10702:
10703: UPDATE xla_ae_headers_gt
10704: SET funds_status_code = l_xla_hdr_status
10705: WHERE ae_header_id = y.ae_header_id and
10706: ledger_id = p_ledgerid;
10707:

Line 10717: UPDATE xla_ae_headers_gt

10713: END IF;
10714:
10715: END LOOP;
10716: ELSE
10717: UPDATE xla_ae_headers_gt
10718: SET funds_status_code = l_ret_code
10719: WHERE ae_header_id IN (SELECT ae_header_id
10720: FROM gl_bc_packets
10721: WHERE packet_id = l_packets(i)) and

Line 10799: FROM xla_ae_headers_gt hg

10795: 'A', 'ADVISORY',
10796: 'F', 'FAIL',
10797: 'P', 'PARTIAL',
10798: 'XLA_ERROR')
10799: FROM xla_ae_headers_gt hg
10800: WHERE hg.event_id = eg.event_id)
10801: where eg.event_id in (select event_id from xla_ae_headers_gt);
10802:
10803: -- ====== FND LOG ======

Line 10801: where eg.event_id in (select event_id from xla_ae_headers_gt);

10797: 'P', 'PARTIAL',
10798: 'XLA_ERROR')
10799: FROM xla_ae_headers_gt hg
10800: WHERE hg.event_id = eg.event_id)
10801: where eg.event_id in (select event_id from xla_ae_headers_gt);
10802:
10803: -- ====== FND LOG ======
10804: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated valid funds check '||sql%rowcount||
10805: ' rows.');

Line 10831: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT

10827: e.g. PA BURDEN lines failed XLA validation but corresponding PO RAW passed XLA validation
10828: or PO RAW line failed XLA validation but corresponding PA BURDEN lines passed XLA validation.
10829: */
10830:
10831: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10832: UPDATE xla_ae_headers_gt
10833: SET funds_status_code = 'F'
10834: WHERE event_id IN (
10835: SELECT event_id

Line 10832: UPDATE xla_ae_headers_gt

10828: or PO RAW line failed XLA validation but corresponding PA BURDEN lines passed XLA validation.
10829: */
10830:
10831: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10832: UPDATE xla_ae_headers_gt
10833: SET funds_status_code = 'F'
10834: WHERE event_id IN (
10835: SELECT event_id
10836: FROM psa_bc_alloc_gt

Line 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.');

10837: WHERE status_code <> 'P');
10838:
10839: IF(SQL%ROWCOUNT<> 0) THEN
10840: -- ====== FND LOG ======
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

Line 10900: UPDATE xla_ae_headers_gt

10896: CLOSE c_chk_funds_hier;
10897: END IF;
10898: END LOOP;
10899:
10900: UPDATE xla_ae_headers_gt
10901: SET funds_status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
10902: 'M', 'F',
10903: 'R', 'F',
10904: 'P', 'F')

Line 10913: sql%rowcount||' rows successfully of XLA_AE_HEADERS_GT. ');

10909: AND serial_id = l_serial_id) and
10910: ledger_id = p_ledgerid;
10911: -- ====== FND LOG ======
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'

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

10986: EXCEPTION
10987: WHEN GL_BC_PACKETS_EMPTY THEN
10988: IF (NOT g_xla_debug) THEN
10989: -- ====== FND LOG ======
10990: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_HEADERS_GT DUMP');
10991: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10992:
10993: -- ====== FND LOG ======
10994: FOR h IN debug_xla_ae_headers_gt

Line 10994: FOR h IN debug_xla_ae_headers_gt

10990: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_HEADERS_GT DUMP');
10991: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10992:
10993: -- ====== FND LOG ======
10994: FOR h IN debug_xla_ae_headers_gt
10995: LOOP
10996: -- ====== FND LOG ======
10997: psa_utils.debug_other_string(g_error_level,l_full_path, ' EVENT_ID = '||h.event_id||' , '||
10998: ' AE_HEADER_ID = '||h.ae_header_id||' , '||