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_BC_XLA_PVT dependencies on XLA_EVENTS_GT

Line 41: TYPE psa_events_table IS TABLE OF psa_bc_xla_events_gt.event_id%TYPE;

37: --==========================================================================
38: -- declaring private variables
39: --==========================================================================
40: TYPE psa_acctg_errors_table IS TABLE OF psa_bc_accounting_errors%ROWTYPE;
41: TYPE psa_events_table IS TABLE OF psa_bc_xla_events_gt.event_id%TYPE;
42:
43: --==========================================================================
44: -- Forward Declaration of PA/GMS API's
45: --==========================================================================

Line 91: psa_bc_xla_events_gt p

87: BEGIN
88: FOR entity_rec IN (SELECT t.*
89: FROM xla_events e,
90: xla_transaction_entities t,
91: psa_bc_xla_events_gt p
92: WHERE p.event_id = e.event_id
93: AND e.entity_id = t.entity_id) LOOP
94: psa_xla_error_cleanup (entity_rec);
95: END LOOP;

Line 204: psa_bc_xla_events_gt p

200: e.event_date,
201: t.ledger_id
202: FROM xla_events e,
203: xla_transaction_entities t,
204: psa_bc_xla_events_gt p
205: WHERE p.event_id = e.event_id
206: AND e.entity_id = t.entity_id
207: AND p.event_id = NVL(p_event_id, p.event_id)) LOOP
208:

Line 266: psa_bc_xla_events_gt p,

262: e.event_date,
263: er.ae_header_id,
264: er.ae_line_num
265: FROM xla_accounting_errors er,
266: psa_bc_xla_events_gt p,
267: xla_events e,
268: xla_transaction_entities t
269: WHERE er.event_id = p.event_id
270: AND e.event_id = p.event_id

Line 319: psa_bc_xla_events_gt p,

315: ru.product_rule_type_code product_rule_owner,
316: t.ledger_id
317: FROM xla_events e,
318: xla_transaction_entities t,
319: psa_bc_xla_events_gt p,
320: gl_ledgers g,
321: xla_acctg_methods_fvl m,
322: xla_acctg_method_rules_fvl r,
323: xla_product_rules_fvl ru

Line 394: -- Pre-reqs : Create events in psa_bc_xla_events_gt

390:
391: -- /*============================================================================
392: -- API name : Budgetary_Control
393: -- Type : private
394: -- Pre-reqs : Create events in psa_bc_xla_events_gt
395: -- Description : Call SLA engine for BCPSA
396: --
397: -- Parameters :
398: -- IN : p_api_version IN NUMBER Required

Line 453: FROM XLA_ENTITY_EVENTS_V XE,PSA_BC_XLA_EVENTS_GT BCE

449: --- and identify eligible events to be processed by SLA
450: ---
451: CURSOR C_entity_event_info ( p_application_id NUMBER) IS
452: SELECT XE.entity_id entity_id
453: FROM XLA_ENTITY_EVENTS_V XE,PSA_BC_XLA_EVENTS_GT BCE
454: WHERE XE.event_id = BCE.event_id
455: AND XE.event_status_code <> 'P'
456: AND XE.application_id = p_application_id
457: GROUP BY xe.entity_id;

Line 472: FROM PSA_BC_XLA_EVENTS_GT;

468: sum(decode(upper(result_code),'PARTIAL',1)) status_partial_count,
469: sum(decode(upper(result_code),'ADVISORY',1)) status_advisory_count,
470: nvl(sum(decode(upper(result_code),'SUCCESS',1)),0) status_success_count,
471: nvl(sum(decode(upper(result_code),'XLA_NO_JOURNAL',1)),0) status_nojournal_count
472: FROM PSA_BC_XLA_EVENTS_GT;
473:
474: CURSOR c_xla_errors IS
475: SELECT 'Y'
476: FROM PSA_BC_XLA_EVENTS_GT a

Line 476: FROM PSA_BC_XLA_EVENTS_GT a

472: FROM PSA_BC_XLA_EVENTS_GT;
473:
474: CURSOR c_xla_errors IS
475: SELECT 'Y'
476: FROM PSA_BC_XLA_EVENTS_GT a
477: WHERE not exists (SELECT 'x'
478: FROM xla_ae_headers b
479: WHERE b.event_id = a.event_id);
480:

Line 481: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt

477: WHERE not exists (SELECT 'x'
478: FROM xla_ae_headers b
479: WHERE b.event_id = a.event_id);
480:
481: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
482: -- as entered by product teams. This is useful for debugging.
483: CURSOR c_get_bc_xla_events_gt IS
484: SELECT *
485: FROM psa_bc_xla_events_gt;

Line 483: CURSOR c_get_bc_xla_events_gt IS

479: WHERE b.event_id = a.event_id);
480:
481: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
482: -- as entered by product teams. This is useful for debugging.
483: CURSOR c_get_bc_xla_events_gt IS
484: SELECT *
485: FROM psa_bc_xla_events_gt;
486:
487: CURSOR c_get_psa_events IS

Line 485: FROM psa_bc_xla_events_gt;

481: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
482: -- as entered by product teams. This is useful for debugging.
483: CURSOR c_get_bc_xla_events_gt IS
484: SELECT *
485: FROM psa_bc_xla_events_gt;
486:
487: CURSOR c_get_psa_events IS
488: SELECT event_id
489: FROM psa_bc_xla_events_gt;

Line 489: FROM psa_bc_xla_events_gt;

485: FROM psa_bc_xla_events_gt;
486:
487: CURSOR c_get_psa_events IS
488: SELECT event_id
489: FROM psa_bc_xla_events_gt;
490:
491: CURSOR c_get_xla_acctg_err IS
492: SELECT xla_evnt.EVENT_ID,
493: xla_evnt.ENTITY_ID,

Line 509: FROM psa_bc_xla_events_gt psa_evnt,

505: NULL BATCH_REFERENCE,
506: to_char(xla_evnt.event_id) LINE_REFERENCE,
507: SYSDATE CREATION_DATE,
508: 'Y' XLA_ERROR_FLAG
509: FROM psa_bc_xla_events_gt psa_evnt,
510: xla_events_gt xla_evnt,
511: xla_accounting_errors xla_err,
512: fnd_new_messages fnd_mesg
513: WHERE psa_evnt.event_id = xla_evnt.event_id

Line 510: xla_events_gt xla_evnt,

506: to_char(xla_evnt.event_id) LINE_REFERENCE,
507: SYSDATE CREATION_DATE,
508: 'Y' XLA_ERROR_FLAG
509: FROM psa_bc_xla_events_gt psa_evnt,
510: xla_events_gt xla_evnt,
511: xla_accounting_errors xla_err,
512: fnd_new_messages fnd_mesg
513: WHERE psa_evnt.event_id = xla_evnt.event_id
514: AND xla_evnt.event_id = xla_err.event_id

Line 549: l_status psa_bc_xla_events_gt%ROWTYPE;

545: l_event_num NUMBER;
546: l_overall_success BOOLEAN;
547: l_count NUMBER;
548: l_index BINARY_INTEGER := 1;
549: l_status psa_bc_xla_events_gt%ROWTYPE;
550: l_xla_error VARCHAR2(1);
551: l_psa_acctg_errors psa_acctg_errors_table;
552: l_psa_events psa_events_table;
553: l_failed_evnt_array PSA_FUNDS_CHECKER_PKG.num_rec;

Line 673: FROM psa_bc_xla_events_gt;

669: l_overall_success := TRUE;
670:
671:
672: SELECT count(*) INTO l_count
673: FROM psa_bc_xla_events_gt;
674:
675: IF l_count = 0 THEN
676: -- Bug 5474201
677: -- There are no events to be processed, returns success as such

Line 687: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );

683: END IF;
684: return;
685: END IF;
686:
687: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table Prior to PA/GMS API ' || l_count );
688: psa_xla_error_cleanup;
689:
690:
691: BEGIN

Line 731: FROM psa_bc_xla_events_gt;

727: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );
728: pa_gms_integration_api;
729:
730: SELECT count(*) INTO l_count
731: FROM psa_bc_xla_events_gt;
732:
733: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );
734:
735: IF l_count < 1 THEN

Line 733: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );

729:
730: SELECT count(*) INTO l_count
731: FROM psa_bc_xla_events_gt;
732:
733: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in psa_bc_xla_events_gt table after invoking PA/GMS API ' || l_count );
734:
735: IF l_count < 1 THEN
736:
737: x_status_code := 'FATAL';

Line 746: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status

742:
743: END IF;
744:
745: --
746: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
747: --
748: UPDATE psa_bc_xla_events_gt
749: SET result_code = 'XLA_UNPROCESSED';
750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

Line 748: UPDATE psa_bc_xla_events_gt

744:
745: --
746: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
747: --
748: UPDATE psa_bc_xla_events_gt
749: SET result_code = 'XLA_UNPROCESSED';
750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
751:
752:

Line 750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

746: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
747: --
748: UPDATE psa_bc_xla_events_gt
749: SET result_code = 'XLA_UNPROCESSED';
750: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
751:
752:
753:
754:

Line 780: -- Insert rows to XLA Events GT table and Call Accounting Engine

776: DELETE from psa_bc_alloc_gt;
777: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows deleted from psa_bc_alloc_gt table before insertion: ' || SQL%ROWCOUNT);
778: ------------------------------------------------------------------------------------- *
779:
780: -- Insert rows to XLA Events GT table and Call Accounting Engine
781: -----------------------------------------------------------------
782:
783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
784: SELECT event_id FROM psa_bc_xla_events_gt;

Line 784: SELECT event_id FROM psa_bc_xla_events_gt;

780: -- Insert rows to XLA Events GT table and Call Accounting Engine
781: -----------------------------------------------------------------
782:
783: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
784: SELECT event_id FROM psa_bc_xla_events_gt;
785: psa_utils.debug_other_string(g_state_level,l_path_name, 'Number of rows in inserted into XLA_ACCT_PROG_EVENTS_GT table: ' || SQL%ROWCOUNT );
786:
787: l_accounting_events := TRUE;
788: l_accounting_batch_id := NULL;

Line 793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');

789: l_errbuf := NULL;
790: l_retcode := NULL;
791: l_request_id := NULL;
792:
793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP

Line 796: FOR x in c_get_bc_xla_events_gt

792:
793: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
794: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
795:
796: FOR x in c_get_bc_xla_events_gt
797: LOOP
798: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
799: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
800: END LOOP;

Line 819: -- Get psa_bc_xla_events_gt events

815: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
816: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
817: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
818:
819: -- Get psa_bc_xla_events_gt events
820: OPEN c_get_psa_events;
821: FETCH c_get_psa_events BULK COLLECT INTO l_psa_events;
822: CLOSE c_get_psa_events;
823:

Line 838: -- update the psa_bc_xla_events_gt event records to

834: l_overall_success := FALSE;
835: --Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
837: --Fnd_Msg_Pub.ADD;
838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status
840: UPDATE psa_bc_xla_events_gt
841: SET result_code = 'XLA_ERROR';
842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

Line 840: UPDATE psa_bc_xla_events_gt

836: --Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
837: --Fnd_Msg_Pub.ADD;
838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status
840: UPDATE psa_bc_xla_events_gt
841: SET result_code = 'XLA_ERROR';
842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
843: -- set the status code
844: x_status_code := 'XLA_ERROR';

Line 842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

838: -- update the psa_bc_xla_events_gt event records to
839: -- XLA_ERROR status
840: UPDATE psa_bc_xla_events_gt
841: SET result_code = 'XLA_ERROR';
842: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
843: -- set the status code
844: x_status_code := 'XLA_ERROR';
845: copy_xla_error (l_error_found);
846: IF (l_error_found = 'N') THEN

Line 853: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_NO_JOURNAL' status

849: ELSE
850: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');
851:
852: --
853: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_NO_JOURNAL' status
854: -- for events that remain in XLA_UNPROCESSED status
855: --
856:
857: IF l_retcode = 0 THEN

Line 858: UPDATE psa_bc_xla_events_gt

854: -- for events that remain in XLA_UNPROCESSED status
855: --
856:
857: IF l_retcode = 0 THEN
858: UPDATE psa_bc_xla_events_gt
859: SET result_code = 'XLA_NO_JOURNAL'
860: WHERE result_code = 'XLA_UNPROCESSED';
861: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
862: END IF;

Line 861: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

857: IF l_retcode = 0 THEN
858: UPDATE psa_bc_xla_events_gt
859: SET result_code = 'XLA_NO_JOURNAL'
860: WHERE result_code = 'XLA_UNPROCESSED';
861: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
862: END IF;
863:
864: IF l_retcode = 1 THEN
865: copy_xla_error (l_error_found);

Line 873: UPDATE psa_bc_xla_events_gt

869:
870: IF (l_xla_error = 'Y') THEN
871: x_status_code := 'XLA_ERROR';
872:
873: UPDATE psa_bc_xla_events_gt
874: SET result_code = 'XLA_ERROR';
875: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
876: END IF;
877: END IF;

Line 875: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

871: x_status_code := 'XLA_ERROR';
872:
873: UPDATE psa_bc_xla_events_gt
874: SET result_code = 'XLA_ERROR';
875: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
876: END IF;
877: END IF;
878:
879: -- Intialize status code to Success

Line 882: --dumping the psa_bc_xla_events_gt eventid/result_code

878:
879: -- Intialize status code to Success
880: x_status_code := 'SUCCESS';
881:
882: --dumping the psa_bc_xla_events_gt eventid/result_code
883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');
884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP
885: psa_utils.debug_other_string(g_state_level,l_path_name,
886: 'PSA gt event_id'|| x.event_id || 'PSA gt result_code' || x.result_code);

Line 883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');

879: -- Intialize status code to Success
880: x_status_code := 'SUCCESS';
881:
882: --dumping the psa_bc_xla_events_gt eventid/result_code
883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');
884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP
885: psa_utils.debug_other_string(g_state_level,l_path_name,
886: 'PSA gt event_id'|| x.event_id || 'PSA gt result_code' || x.result_code);
887: END LOOP;

Line 884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP

880: x_status_code := 'SUCCESS';
881:
882: --dumping the psa_bc_xla_events_gt eventid/result_code
883: psa_utils.debug_other_string(g_state_level,l_path_name,'Dump of psa_bc_xla_events_gt');
884: FOR x IN (SELECT * FROM psa_bc_xla_events_gt) LOOP
885: psa_utils.debug_other_string(g_state_level,l_path_name,
886: 'PSA gt event_id'|| x.event_id || 'PSA gt result_code' || x.result_code);
887: END LOOP;
888:

Line 904: FROM PSA_BC_XLA_EVENTS_GT

900: x_status_code := 'PARTIAL';
901: END IF;
902:
903: FOR event_list_rec IN (SELECT *
904: FROM PSA_BC_XLA_EVENTS_GT
905: WHERE upper(result_code) = 'XLA_NO_JOURNAL') LOOP
906: fnd_message.set_name ('PSA','PSA_XLA_NO_JOURNAL');
907: psa_utils.debug_other_string(g_state_level,l_path_name, 'Calling psa_xla_error');
908: psa_xla_error

Line 1499: DELETE FROM XLA_EVENTS_GT;

1495: DELETE FROM XLA_BAL_STATUSES_GT;
1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;

Line 1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);

1496: psa_utils.debug_other_string(g_state_level,l_path_name, '11 XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1497: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1498: psa_utils.debug_other_string(g_state_level,l_path_name, '12 XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1499: DELETE FROM XLA_EVENTS_GT;
1500: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT : Deleted Row count :'||SQL%ROWCOUNT);
1501: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1502: psa_utils.debug_other_string(g_state_level,l_path_name, '14 XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1503: DELETE FROM XLA_EVT_CLASS_ORDERS_GT;
1504: psa_utils.debug_other_string(g_state_level,l_path_name, '15 XLA_EVT_CLASS_ORDERS_GT : Deleted Row count :'||SQL%ROWCOUNT);