APPS.PSA_FUNDS_CHECKER_PKG dependencies on XLA_AE_LINES_GT

Line 9213: | xla_ae_lines_gt psa_xla_ae_lines_logs |

9209: | SLA Table PSA Table |
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:

Line 9358: FROM xla_ae_lines_gt ;

9354: bflow_dist_id_char_5,
9355: phase,
9356: sysdate
9357: BULK COLLECT INTO l_xla_ae_lines
9358: FROM xla_ae_lines_gt ;
9359:
9360:
9361: SELECT ae_header_id,
9362: ledger_id,

Line 9533: CURSOR debug_xla_ae_lines_gt IS

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;
9536:
9537: CURSOR debug_xla_val_lines_gt IS

Line 9535: FROM xla_ae_lines_gt;

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;
9536:
9537: CURSOR debug_xla_val_lines_gt IS
9538: SELECT event_id, ae_header_id, ae_line_num, period_name,
9539: accounting_entry_status_code, balancing_line_type

Line 9558: -- XLA_AE_LINES_GT.

9554: status_code
9555: FROM psa_bc_alloc_gt;
9556:
9557: -- Check whether all the events from XLA_EVENTS_GT have come to
9558: -- XLA_AE_LINES_GT.
9559: /* If any event is missed we will treat it as
9560: FATAL error because there was some setup problem in SLA. */
9561: CURSOR c_cnt_events IS
9562: SELECT (SELECT COUNT (*)

Line 9565: FROM xla_ae_lines_gt) ae_event_count

9561: CURSOR c_cnt_events IS
9562: SELECT (SELECT COUNT (*)
9563: FROM xla_events_gt) event_count,
9564: (SELECT COUNT (DISTINCT (event_id))
9565: FROM xla_ae_lines_gt) ae_event_count
9566: FROM DUAL;
9567:
9568: -- check whether allocation attributes are used or not
9569: /* This is to avoid additional processing for allocation attributes

Line 9886: -- are available in XLA_AE_LINES_GT.

9882:
9883: debug_xla ( 'BUDGETARY_CONTROL_START' );
9884:
9885: -- Check whether all the events in XLA_EVENTS_GT
9886: -- are available in XLA_AE_LINES_GT.
9887: /* If some events are missing that means that there is some issue in SLA
9888: setup for the event, that's why SLA didn't put that event to be
9889: considered for accounting. In this case Funds Checker API
9890: will treat this as an FATAL situation and will not process further. */

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

9895: -- ====== FND LOG ======
9896: psa_utils.debug_other_string(g_error_level,l_full_path,
9897: ' BCTRL -> Count of events in XLA_EVENTS_GT: '||l_event_cnt);
9898: psa_utils.debug_other_string(g_error_level,l_full_path,
9899: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
9900: -- ====== FND LOG ======
9901:
9902: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
9903: fnd_file.put_line(fnd_file.log,'=============================================== ');

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

9921: for missing_entity in
9922: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
9923: from xla_transaction_entities_upg e , xla_events_gt g
9924: where g.entity_id = e.entity_id
9925: and g.event_id not in (select event_id from xla_ae_lines_gt) )
9926: loop
9927: 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 );
9928: end loop;
9929:

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

10701: ' BALANCE_TYPE_CODE = '||h.balance_type_code);
10702: -- ====== FND LOG ======
10703: END LOOP;
10704: -- ====== FND LOG ======
10705: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_AE_LINES_GT DUMP');
10706: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10707:
10708:
10709: -- ====== FND LOG ======

Line 10710: FOR x IN debug_xla_ae_lines_gt

10706: psa_utils.debug_other_string(g_error_level,l_full_path, ' -------------------- ');
10707:
10708:
10709: -- ====== FND LOG ======
10710: FOR x IN debug_xla_ae_lines_gt
10711: LOOP
10712: -- ====== FND LOG ======
10713: psa_utils.debug_other_string(g_error_level,l_full_path, ' EVENT_ID = '||x.event_id||' , '||
10714: ' AE_HEADER_ID = '||x.ae_header_id||' , '||