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 7437: DELETE from psa_xla_ae_headers_logs

7433: -- =========================== FND LOG ===========================
7434: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_lines_logs deleted ' || SQL%ROWCOUNT || ' rows');
7435: -- ========================= FND LOG =============================
7436:
7437: DELETE from psa_xla_ae_headers_logs
7438: where (sysdate - creation_date) >= p_purge_days;
7439:
7440: -- =========================== FND LOG ===========================
7441: psa_utils.debug_other_string(g_state_level,l_full_path, ' Delete psa_xla_ae_header_logs deleted ' || SQL%ROWCOUNT || ' rows');

Line 9193: FROM xla_ae_headers

9189: UPDATE gl_bc_packets
9190: SET group_id = p_grp_id,
9191: je_batch_name = p_je_batch_name
9192: WHERE ae_header_id IN (SELECT ae_header_id
9193: FROM xla_ae_headers
9194: WHERE group_id = p_grp_id
9195: and application_id = p_application_id);
9196:
9197: -- =========================== FND LOG ===========================

Line 9214: | xla_ae_headers_gt psa_xla_ae_headers_logs |

9210: | ======== ======== |
9211: | xla_events_gt psa_xla_events_logs |
9212: | xla_validation_lines_gt psa_xla_validation_lines_logs |
9213: | xla_ae_lines_gt psa_xla_ae_lines_logs |
9214: | xla_ae_headers_gt psa_xla_ae_headers_logs |
9215: | |
9216: +===========================================================================================*/
9217:
9218: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,

Line 9221: xla_ae_headers IN xla_ae_headers_table ,

9217:
9218: PROCEDURE debug_xla_insert ( xla_events IN xla_events_table ,
9219: xla_validation_lines IN xla_validation_lines_table ,
9220: xla_ae_lines IN xla_ae_lines_table ,
9221: xla_ae_headers IN xla_ae_headers_table ,
9222: xla_distribution_links IN xla_distribution_links_table) IS
9223:
9224: PRAGMA autonomous_transaction;
9225: i NUMBER;

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

9237: FORALL i IN 1 .. xla_ae_lines.count
9238: INSERT INTO psa_xla_ae_lines_logs
9239: VALUES xla_ae_lines(i);
9240:
9241: FORALL i IN 1 .. xla_ae_headers.count
9242: INSERT INTO psa_xla_ae_headers_logs
9243: VALUES xla_ae_headers(i);
9244:
9245:

Line 9242: INSERT INTO psa_xla_ae_headers_logs

9238: INSERT INTO psa_xla_ae_lines_logs
9239: VALUES xla_ae_lines(i);
9240:
9241: FORALL i IN 1 .. xla_ae_headers.count
9242: INSERT INTO psa_xla_ae_headers_logs
9243: VALUES xla_ae_headers(i);
9244:
9245:
9246: FORALL i IN 1 .. xla_distribution_links.count

Line 9243: VALUES xla_ae_headers(i);

9239: VALUES xla_ae_lines(i);
9240:
9241: FORALL i IN 1 .. xla_ae_headers.count
9242: INSERT INTO psa_xla_ae_headers_logs
9243: VALUES xla_ae_headers(i);
9244:
9245:
9246: FORALL i IN 1 .. xla_distribution_links.count
9247: INSERT INTO psa_xla_dist_links_logs

Line 9267: l_xla_ae_headers xla_ae_headers_table;

9263:
9264: l_xla_events xla_events_table;
9265: l_xla_validation_lines xla_validation_lines_table;
9266: l_xla_ae_lines xla_ae_lines_table;
9267: l_xla_ae_headers xla_ae_headers_table;
9268: l_xla_distribution_links xla_distribution_links_table;
9269:
9270: BEGIN
9271:

Line 9370: BULK COLLECT INTO l_xla_ae_headers

9366: balance_type_code,
9367: funds_status_code,
9368: phase,
9369: sysdate
9370: BULK COLLECT INTO l_xla_ae_headers
9371: FROM xla_ae_headers_gt ;
9372:
9373: Select application_id ,
9374: event_id,

Line 9371: FROM xla_ae_headers_gt ;

9367: funds_status_code,
9368: phase,
9369: sysdate
9370: BULK COLLECT INTO l_xla_ae_headers
9371: FROM xla_ae_headers_gt ;
9372:
9373: Select application_id ,
9374: event_id,
9375: ae_header_id,

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

9463: and application_id = psa_bc_xla_pvt.g_application_id;
9464:
9465:
9466:
9467: DEBUG_XLA_INSERT ( l_xla_events, l_xla_validation_lines, l_xla_ae_lines, l_xla_ae_headers , l_xla_distribution_links);
9468:
9469: ELSE
9470: return;
9471:

Line 9527: CURSOR debug_xla_ae_headers_gt IS

9523: SELECT ledger_category_code
9524: FROM gl_ledgers
9525: WHERE ledger_id = p_ledgerid;
9526:
9527: CURSOR debug_xla_ae_headers_gt IS
9528: SELECT ae_header_id, ledger_id, entity_id, event_id,
9529: event_type_code, funds_status_code, accounting_entry_status_code,
9530: balance_type_code
9531: FROM xla_ae_headers_gt;

Line 9531: FROM xla_ae_headers_gt;

9527: CURSOR debug_xla_ae_headers_gt IS
9528: SELECT ae_header_id, ledger_id, entity_id, event_id,
9529: event_type_code, funds_status_code, accounting_entry_status_code,
9530: balance_type_code
9531: FROM xla_ae_headers_gt;
9532:
9533: CURSOR debug_xla_ae_lines_gt IS
9534: SELECT event_id, ae_header_id, ae_line_num
9535: FROM xla_ae_lines_gt;

Line 10363: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT

10359:
10360: l_ret_code := 'T';
10361: END IF;
10362:
10363: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10364:
10365: -- ====== FND LOG ======
10366: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10367: 'of xla_ae_headers_gt ');

Line 10367: 'of xla_ae_headers_gt ');

10363: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10364:
10365: -- ====== FND LOG ======
10366: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update funds_status_code '||
10367: 'of xla_ae_headers_gt ');
10368: -- ====== FND LOG ======
10369:
10370: IF (PSA_BC_XLA_PVT.G_BC_MODE = 'P') AND (l_ret_code <> 'T') THEN
10371: FOR y IN get_status_per_header(l_packets(i))

Line 10401: UPDATE xla_ae_headers_gt

10397: -- ============================== FND LOG =========================
10398: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL l_xla_hdr_status -> '||l_xla_hdr_status);
10399: -- ============================== FND LOG =========================
10400:
10401: UPDATE xla_ae_headers_gt
10402: SET funds_status_code = l_xla_hdr_status
10403: WHERE ae_header_id = y.ae_header_id and
10404: ledger_id = p_ledgerid;
10405:

Line 10415: UPDATE xla_ae_headers_gt

10411: END IF;
10412:
10413: END LOOP;
10414: ELSE
10415: UPDATE xla_ae_headers_gt
10416: SET funds_status_code = l_ret_code
10417: WHERE ae_header_id IN (SELECT ae_header_id
10418: FROM gl_bc_packets
10419: WHERE packet_id = l_packets(i)) and

Line 10487: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)

10483: 'of psa_bc_xla_events_gt');
10484: -- ====== FND LOG ======
10485:
10486: -- this update will ensure that only valid xla events
10487: -- provided for FUNDS CHECK (meant xla_ae_headers rows updated with funds_status_code)
10488: -- are updated with appropiate status. Events NOT picked by funds checker will be updated with XLA_ERROR.
10489: UPDATE psa_bc_xla_events_gt eg
10490: SET result_code = (SELECT decode(min(funds_status_code),
10491: 'T', 'FATAL',

Line 10497: FROM xla_ae_headers_gt hg

10493: 'A', 'ADVISORY',
10494: 'F', 'FAIL',
10495: 'P', 'PARTIAL',
10496: 'XLA_ERROR')
10497: FROM xla_ae_headers_gt hg
10498: WHERE hg.event_id = eg.event_id)
10499: where eg.event_id in (select event_id from xla_ae_headers_gt);
10500:
10501: -- ====== FND LOG ======

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

10495: 'P', 'PARTIAL',
10496: 'XLA_ERROR')
10497: FROM xla_ae_headers_gt hg
10498: WHERE hg.event_id = eg.event_id)
10499: where eg.event_id in (select event_id from xla_ae_headers_gt);
10500:
10501: -- ====== FND LOG ======
10502: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated valid funds check '||sql%rowcount||
10503: ' rows.');

Line 10529: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT

10525: e.g. PA BURDEN lines failed XLA validation but corresponding PO RAW passed XLA validation
10526: or PO RAW line failed XLA validation but corresponding PA BURDEN lines passed XLA validation.
10527: */
10528:
10529: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10530: UPDATE xla_ae_headers_gt
10531: SET funds_status_code = 'F'
10532: WHERE event_id IN (
10533: SELECT event_id

Line 10530: UPDATE xla_ae_headers_gt

10526: or PO RAW line failed XLA validation but corresponding PA BURDEN lines passed XLA validation.
10527: */
10528:
10529: -- Update Funds_Status_Code column in XLA_AE_HEADERS_GT
10530: UPDATE xla_ae_headers_gt
10531: SET funds_status_code = 'F'
10532: WHERE event_id IN (
10533: SELECT event_id
10534: FROM psa_bc_alloc_gt

Line 10539: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Updated '||sql%rowcount||' rows of XLA_AE_HEADERS_GT with fail status.');

10535: WHERE status_code <> 'P');
10536:
10537: IF(SQL%ROWCOUNT<> 0) THEN
10538: -- ====== FND LOG ======
10539: psa_utils.debug_other_string(g_state_level,l_full_path, ' BCTRL -> Updated '||sql%rowcount||' rows of XLA_AE_HEADERS_GT with fail status.');
10540: -- ====== FND LOG ======
10541: END IF;
10542:
10543: -- Update Funds_Status_Code column in XLA_VALIDATION_LINES_GT

Line 10598: UPDATE xla_ae_headers_gt

10594: CLOSE c_chk_funds_hier;
10595: END IF;
10596: END LOOP;
10597:
10598: UPDATE xla_ae_headers_gt
10599: SET funds_status_code = decode(PSA_BC_XLA_PVT.G_BC_MODE, 'C', 'F',
10600: 'M', 'F',
10601: 'R', 'F',
10602: 'P', 'F')

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

10607: AND serial_id = l_serial_id) and
10608: ledger_id = p_ledgerid;
10609: -- ====== FND LOG ======
10610: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated funds_status_code of '||
10611: sql%rowcount||' rows successfully of XLA_AE_HEADERS_GT. ');
10612: -- ====== FND LOG ======
10613:
10614: UPDATE xla_validation_lines_gt vl
10615: SET vl.funds_status_code = 'F77'

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

10684: EXCEPTION
10685: WHEN GL_BC_PACKETS_EMPTY THEN
10686: IF (NOT g_xla_debug) THEN
10687: -- ====== FND LOG ======
10688: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_HEADERS_GT DUMP');
10689: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10690:
10691: -- ====== FND LOG ======
10692: FOR h IN debug_xla_ae_headers_gt

Line 10692: FOR h IN debug_xla_ae_headers_gt

10688: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_HEADERS_GT DUMP');
10689: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10690:
10691: -- ====== FND LOG ======
10692: FOR h IN debug_xla_ae_headers_gt
10693: LOOP
10694: -- ====== FND LOG ======
10695: psa_utils.debug_other_string(g_error_level,l_full_path, ' EVENT_ID = '||h.event_id||' , '||
10696: ' AE_HEADER_ID = '||h.ae_header_id||' , '||