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

Line 7524: DELETE from psa_xla_ae_headers_logs

7520: -- =========================== FND LOG ===========================
7521: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');
7522: -- ========================= FND LOG =============================
7523:
7524: DELETE from psa_xla_ae_headers_logs
7525: where (sysdate - creation_date) >= p_purge_days;
7526:
7527: -- =========================== FND LOG ===========================
7528: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_header_logs deleted ' || SQL%ROWCOUNT || ' rows');

Line 9379: FROM xla_ae_headers

9375: UPDATE gl_bc_packets
9376: SET group_id = p_grp_id,
9377: je_batch_name = p_je_batch_name
9378: WHERE ae_header_id IN (SELECT ae_header_id
9379: FROM xla_ae_headers
9380: WHERE group_id = p_grp_id
9381: and application_id = p_application_id);
9382:
9383: -- =========================== FND LOG ===========================

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 9407: xla_ae_headers IN xla_ae_headers_table ,

9403:
9404: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,
9405: xla_validation_lines IN xla_validation_lines_table ,
9406: xla_ae_lines IN xla_ae_lines_table ,
9407: xla_ae_headers IN xla_ae_headers_table ,
9408: xla_distribution_links IN xla_distribution_links_table) IS
9409:
9410: PRAGMA autonomous_transaction;
9411: i NUMBER;

Line 9427: FORALL i IN 1 .. xla_ae_headers.count

9423: FORALL i IN 1 .. xla_ae_lines.count
9424: INSERT INTO psa_xla_ae_lines_logs
9425: VALUES xla_ae_lines(i);
9426:
9427: FORALL i IN 1 .. xla_ae_headers.count
9428: INSERT INTO psa_xla_ae_headers_logs
9429: VALUES xla_ae_headers(i);
9430:
9431:

Line 9428: INSERT INTO psa_xla_ae_headers_logs

9424: INSERT INTO psa_xla_ae_lines_logs
9425: VALUES xla_ae_lines(i);
9426:
9427: FORALL i IN 1 .. xla_ae_headers.count
9428: INSERT INTO psa_xla_ae_headers_logs
9429: VALUES xla_ae_headers(i);
9430:
9431:
9432: FORALL i IN 1 .. xla_distribution_links.count

Line 9429: VALUES xla_ae_headers(i);

9425: VALUES xla_ae_lines(i);
9426:
9427: FORALL i IN 1 .. xla_ae_headers.count
9428: INSERT INTO psa_xla_ae_headers_logs
9429: VALUES xla_ae_headers(i);
9430:
9431:
9432: FORALL i IN 1 .. xla_distribution_links.count
9433: INSERT INTO psa_xla_dist_links_logs

Line 9453: l_xla_ae_headers xla_ae_headers_table;

9449:
9450: l_xla_events xla_events_table;
9451: l_xla_validation_lines xla_validation_lines_table;
9452: l_xla_ae_lines xla_ae_lines_table;
9453: l_xla_ae_headers xla_ae_headers_table;
9454: l_xla_distribution_links xla_distribution_links_table;
9455:
9456: BEGIN
9457:

Line 9556: BULK COLLECT INTO l_xla_ae_headers

9552: balance_type_code,
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,

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 9649: from xla_ae_headers h

9645: sysdate
9646: BULK COLLECT INTO l_xla_distribution_links
9647: FROM xla_distribution_links d
9648: where exists (select 1
9649: from xla_ae_headers h
9650: where h.event_id IN (SELECT event_id from psa_bc_xla_events_gt)
9651: and h.ae_header_id = d.ae_header_id)
9652: and application_id = psa_bc_xla_pvt.g_application_id;
9653:

Line 9656: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);

9652: and application_id = psa_bc_xla_pvt.g_application_id;
9653:
9654:
9655:
9656: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);
9657:
9658: ELSE
9659: return;
9660:

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 10789: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)

10785: 'of psa_bc_xla_events_gt');
10786: -- ====== FND LOG ======
10787:
10788: -- this update will ensure that only valid xla events
10789: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)
10790: -- are updated with appropiate status. Events NOT picked by funds checker will be updated with XLA_ERROR.
10791: UPDATE psa_bc_xla_events_gt eg
10792: SET result_code = (SELECT decode(min(funds_status_code),
10793: 'T', 'FATAL',

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||' , '||