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_EVENTS_GT

Line 9397: | xla_events_gt psa_xla_events_logs |

9393: | to PSA tables as shown below: |
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: | |

Line 9479: FROM xla_events_gt ;

9475: budgetary_control_flag,
9476: phase,
9477: sysdate
9478: BULK COLLECT INTO l_xla_events
9479: FROM xla_events_gt ;
9480:
9481:
9482: SELECT event_id,
9483: entity_id,

Line 9650: where h.event_id IN (SELECT event_id from psa_bc_xla_events_gt)

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:
9654:

Line 9683: xla_events_gt e

9679: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for BFLOW Errors');
9680: FOR bflow_rec IN (SELECT l.*,
9681: e.entity_id event_entiity_id
9682: FROM xla_ae_lines_gt l,
9683: xla_events_gt e
9684: WHERE l.event_id = e.event_id
9685: AND business_method_code = 'PRIOR_ENTRY'
9686: AND code_combination_status_code = 'INVALID'
9687: AND NVL(bflow_prior_entry_status_code, 'N') <> 'F') LOOP

Line 9710: FROM xla_events_gt e

9706: END LOOP;
9707: ELSIF (p_error_type = 'EVENTS_NOT_PROCESSED') THEN
9708: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for Events Not Processed');
9709: FOR events_rec IN (SELECT *
9710: FROM xla_events_gt e
9711: WHERE NOT EXISTS (SELECT 1
9712: FROM xla_ae_lines_gt l
9713: WHERE l.event_id = e.event_id)) LOOP
9714: l_message := 'Event '||events_rec.event_id||' is not processed.';

Line 9727: FROM xla_events_gt e

9723: END LOOP;
9724: ELSIF (p_error_type = 'GL_BC_PACKETS_EMPTY') THEN
9725: psa_utils.debug_other_string(g_state_level,l_full_path, 'Checking for Events Not Processed');
9726: FOR events_rec IN (SELECT *
9727: FROM xla_events_gt e
9728: WHERE NOT EXISTS (SELECT 1
9729: FROM xla_psa_bc_lines_v l
9730: WHERE l.event_id = e.event_id)) LOOP
9731: l_message := 'Event '||events_rec.event_id||' is not processed.';

Line 9813: CURSOR debug_xla_events_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
9816: FROM xla_events_gt;
9817:

Line 9816: FROM xla_events_gt;

9812:
9813: CURSOR debug_xla_events_gt IS
9814: SELECT application_id, event_id, event_date, event_type_code,
9815: reference_num_1
9816: FROM xla_events_gt;
9817:
9818: CURSOR debug_xla_psa_bc_v IS
9819: SELECT event_id, ae_header_id, ae_line_num, entity_id, ledger_id,
9820: period_name

Line 9828: -- Check whether all the events from XLA_EVENTS_GT have come to

9824: SELECT hierarchy_id, ae_header_id, ae_line_num, event_id,
9825: status_code
9826: FROM psa_bc_alloc_gt;
9827:
9828: -- Check whether all the events from XLA_EVENTS_GT have come to
9829: -- XLA_AE_LINES_GT.
9830: /* If any event is missed we will treat it as
9831: FATAL error because there was some setup problem in SLA. */
9832: CURSOR c_cnt_events IS

Line 9834: FROM xla_events_gt) event_count,

9830: /* If any event is missed we will treat it as
9831: FATAL error because there was some setup problem in SLA. */
9832: CURSOR c_cnt_events IS
9833: SELECT (SELECT COUNT (*)
9834: FROM xla_events_gt) event_count,
9835: (SELECT COUNT (DISTINCT (event_id))
9836: FROM xla_ae_lines_gt) ae_event_count
9837: FROM DUAL;
9838:

Line 10171: -- Check whether all the events in XLA_EVENTS_GT

10167: -- PSA regular tables.
10168:
10169: debug_xla ( 'BUDGETARY_CONTROL_START' );
10170:
10171: -- Check whether all the events in XLA_EVENTS_GT
10172: -- are available in XLA_AE_LINES_GT.
10173: /* If some events are missing that means that there is some issue in SLA
10174: setup for the event, that's why SLA didn't put that event to be
10175: considered for accounting. In this case Funds Checker API

Line 10183: ' BCTRL -> Count of events in XLA_EVENTS_GT: '||l_event_cnt);

10179: CLOSE c_cnt_events;
10180:
10181: -- ====== FND LOG ======
10182: psa_utils.debug_other_string(g_error_level,l_full_path,
10183: ' BCTRL -> Count of events in XLA_EVENTS_GT: '||l_event_cnt);
10184: psa_utils.debug_other_string(g_error_level,l_full_path,
10185: ' BCTRL -> Count of events in XLA_AE_LINES_GT: '||l_ae_event_cnt);
10186: -- ====== FND LOG ======
10187:

Line 10192: where event_id in (select event_id from xla_events_gt))

10188: fnd_file.put_line(fnd_file.log,'The following are the invalid accounting errrors');
10189: fnd_file.put_line(fnd_file.log,'=============================================== ');
10190: for acc_error in ( select document_reference , encoded_message
10191: from psa_bc_accounting_errors b
10192: where event_id in (select event_id from xla_events_gt))
10193: loop
10194: fnd_file.put_line(fnd_file.log , ' document_referece ' || acc_error.document_reference);
10195: fnd_file.put_line(fnd_file.log , acc_error.encoded_message);
10196: End loop;

Line 10211: from xla_transaction_entities_upg e , xla_events_gt g

10207: fnd_file.put_line(fnd_file.log,'The following entities have not been processed');
10208: fnd_file.put_line(fnd_file.log,'======================================= ');
10209: for missing_entity in
10210: ( select e.entity_id,g.event_id,g.source_id_int_2,e.transaction_number
10211: from xla_transaction_entities_upg e , xla_events_gt g
10212: where g.entity_id = e.entity_id
10213: and g.event_id not in (select event_id from xla_ae_lines_gt) )
10214: loop
10215: 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 );

Line 10290: FROM xla_events_gt

10286: --Resetting allocatons flag in case of prepay app
10287: --Bug#9840059
10288: IF (l_alloc_used = 'Y') THEN
10289: FOR check_prepay_rec IN (SELECT event_class_code
10290: FROM xla_events_gt
10291: WHERE event_class_code = 'PREPAYMENT APPLICATIONS') LOOP
10292: psa_utils.debug_other_string(g_state_level,l_full_path, 'Resetting l_alloc_used from Y to N');
10293: l_alloc_used := 'N';
10294: EXIT;

Line 10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code

10777: END LOOP;
10778:
10779: -- Bug 5397349 .. End
10780:
10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10782:
10783: -- ====== FND LOG ======
10784: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_code '||
10785: 'of psa_bc_xla_events_gt');

Line 10785: 'of psa_bc_xla_events_gt');

10781: -- Update PSA_BC_XLA_EVENTS_GT table with result_code
10782:
10783: -- ====== FND LOG ======
10784: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Update result_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)

Line 10791: UPDATE psa_bc_xla_events_gt eg

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',
10794: 'S', 'SUCCESS',
10795: 'A', 'ADVISORY',

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

11033: -- ====== FND LOG ======
11034: END LOOP;
11035:
11036: -- ====== FND LOG ======
11037: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_EVENTS_GT DUMP');
11038: psa_utils.debug_other_string(g_error_level,l_full_path, ' ---------------------------- ');
11039: -- ====== FND LOG ======
11040: FOR z in debug_xla_events_gt
11041: LOOP

Line 11040: FOR z in debug_xla_events_gt

11036: -- ====== FND LOG ======
11037: psa_utils.debug_other_string(g_error_level,l_full_path, ' BCTRL -> XLA_EVENTS_GT DUMP');
11038: psa_utils.debug_other_string(g_error_level,l_full_path, ' ---------------------------- ');
11039: -- ====== FND LOG ======
11040: FOR z in debug_xla_events_gt
11041: LOOP
11042: -- ====== FND LOG ======
11043: psa_utils.debug_other_string(g_error_level,l_full_path, ' APPLICATION_ID = '||z.application_id||' , '||
11044: ' EVENT_ID = '||z.event_id||' , '||

Line 11118: FROM psa_bc_xla_events_gt

11114: CURSOR c_success_evt_exists IS
11115: SELECT 'Successful event exists in the current packet'
11116: FROM gl_bc_packets
11117: WHERE event_id IN (SELECT event_id
11118: FROM psa_bc_xla_events_gt
11119: )
11120: AND application_id = PSA_BC_XLA_PVT.g_application_id
11121: AND status_code = 'A';
11122:

Line 11189: UPDATE psa_bc_xla_events_gt

11185: -- back to the calling transaction.
11186:
11187: IF (l_f81_cnt <> 0 OR l_f82_cnt <> 0) THEN
11188: FORALL k IN 1..p_failed_evnt_array.COUNT
11189: UPDATE psa_bc_xla_events_gt
11190: SET result_code = 'XLA_ERROR'
11191: WHERE event_id = p_failed_evnt_array(k)
11192: AND result_code <> 'XLA_ERROR';
11193:

Line 11195: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated PSA_BC_XLA_EVENTS_GT '||sql%rowcount||

11191: WHERE event_id = p_failed_evnt_array(k)
11192: AND result_code <> 'XLA_ERROR';
11193:
11194: -- ====== FND LOG ======
11195: psa_utils.debug_other_string(g_state_level, l_full_path, ' BCTRL -> Updated PSA_BC_XLA_EVENTS_GT '||sql%rowcount||
11196: ' rows to XLA_ERROR status.');
11197: -- ====== FND LOG ======
11198:
11199: END IF;

Line 11219: FROM psa_bc_xla_events_gt

11215: WHERE affect_funds_flag = 'Y'
11216: AND packet_id IN ( SELECT packet_id
11217: FROM gl_bc_packets bc
11218: WHERE event_id IN ( SELECT event_id
11219: FROM psa_bc_xla_events_gt
11220: )
11221: AND application_id = PSA_BC_XLA_PVT.g_application_id
11222: AND result_code IN ('F81', 'F82')
11223: ) ;