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 40: TYPE psa_events_table IS TABLE OF psa_bc_xla_events_gt.event_id%TYPE;

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

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

79:
80: -- /*============================================================================
81: -- API name : Budgetary_Control
82: -- Type : private
83: -- Pre-reqs : Create events in psa_bc_xla_events_gt
84: -- Description : Call SLA engine for BCPSA
85: --
86: -- Parameters :
87: -- IN : p_api_version IN NUMBER Required

Line 142: FROM XLA_ENTITY_EVENTS_V XE,PSA_BC_XLA_EVENTS_GT BCE

138: --- and identify eligible events to be processed by SLA
139: ---
140: CURSOR C_entity_event_info ( p_application_id NUMBER) IS
141: SELECT XE.entity_id entity_id
142: FROM XLA_ENTITY_EVENTS_V XE,PSA_BC_XLA_EVENTS_GT BCE
143: WHERE XE.event_id = BCE.event_id
144: AND XE.event_status_code <> 'P'
145: AND XE.application_id = p_application_id
146: GROUP BY xe.entity_id;

Line 161: FROM PSA_BC_XLA_EVENTS_GT;

157: sum(decode(upper(result_code),'PARTIAL',1)) status_partial_count,
158: sum(decode(upper(result_code),'ADVISORY',1)) status_advisory_count,
159: nvl(sum(decode(upper(result_code),'SUCCESS',1)),0) status_success_count,
160: nvl(sum(decode(upper(result_code),'XLA_NO_JOURNAL',1)),0) status_nojournal_count
161: FROM PSA_BC_XLA_EVENTS_GT;
162:
163: CURSOR c_xla_errors IS
164: SELECT 'Y'
165: FROM PSA_BC_XLA_EVENTS_GT a

Line 165: FROM PSA_BC_XLA_EVENTS_GT a

161: FROM PSA_BC_XLA_EVENTS_GT;
162:
163: CURSOR c_xla_errors IS
164: SELECT 'Y'
165: FROM PSA_BC_XLA_EVENTS_GT a
166: WHERE not exists (SELECT 'x'
167: FROM xla_ae_headers b
168: WHERE b.event_id = a.event_id);
169:

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

166: WHERE not exists (SELECT 'x'
167: FROM xla_ae_headers b
168: WHERE b.event_id = a.event_id);
169:
170: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
171: -- as entered by product teams. This is useful for debugging.
172: CURSOR c_get_bc_xla_events_gt IS
173: SELECT *
174: FROM psa_bc_xla_events_gt;

Line 172: CURSOR c_get_bc_xla_events_gt IS

168: WHERE b.event_id = a.event_id);
169:
170: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
171: -- as entered by product teams. This is useful for debugging.
172: CURSOR c_get_bc_xla_events_gt IS
173: SELECT *
174: FROM psa_bc_xla_events_gt;
175:
176: CURSOR c_get_psa_events IS

Line 174: FROM psa_bc_xla_events_gt;

170: -- Cursor c_get_bc_xla_events_gt is used to print data from psa_bc_xla_Events_gt
171: -- as entered by product teams. This is useful for debugging.
172: CURSOR c_get_bc_xla_events_gt IS
173: SELECT *
174: FROM psa_bc_xla_events_gt;
175:
176: CURSOR c_get_psa_events IS
177: SELECT event_id
178: FROM psa_bc_xla_events_gt;

Line 178: FROM psa_bc_xla_events_gt;

174: FROM psa_bc_xla_events_gt;
175:
176: CURSOR c_get_psa_events IS
177: SELECT event_id
178: FROM psa_bc_xla_events_gt;
179:
180: CURSOR c_get_xla_acctg_err IS
181: SELECT xla_evnt.EVENT_ID,
182: xla_evnt.ENTITY_ID,

Line 198: FROM psa_bc_xla_events_gt psa_evnt,

194: NULL BATCH_REFERENCE,
195: to_char(xla_evnt.event_id) LINE_REFERENCE,
196: SYSDATE CREATION_DATE,
197: 'Y' XLA_ERROR_FLAG
198: FROM psa_bc_xla_events_gt psa_evnt,
199: xla_events_gt xla_evnt,
200: xla_accounting_errors xla_err,
201: fnd_new_messages fnd_mesg
202: WHERE psa_evnt.event_id = xla_evnt.event_id

Line 199: xla_events_gt xla_evnt,

195: to_char(xla_evnt.event_id) LINE_REFERENCE,
196: SYSDATE CREATION_DATE,
197: 'Y' XLA_ERROR_FLAG
198: FROM psa_bc_xla_events_gt psa_evnt,
199: xla_events_gt xla_evnt,
200: xla_accounting_errors xla_err,
201: fnd_new_messages fnd_mesg
202: WHERE psa_evnt.event_id = xla_evnt.event_id
203: AND xla_evnt.event_id = xla_err.event_id

Line 238: l_status psa_bc_xla_events_gt%ROWTYPE;

234: l_event_num NUMBER;
235: l_overall_success BOOLEAN;
236: l_count NUMBER;
237: l_index BINARY_INTEGER := 1;
238: l_status psa_bc_xla_events_gt%ROWTYPE;
239: l_xla_error VARCHAR2(1);
240: l_psa_acctg_errors psa_acctg_errors_table;
241: l_psa_events psa_events_table;
242: l_failed_evnt_array PSA_FUNDS_CHECKER_PKG.num_rec;

Line 358: FROM psa_bc_xla_events_gt;

354: l_overall_success := TRUE;
355:
356:
357: SELECT count(*) INTO l_count
358: FROM psa_bc_xla_events_gt;
359:
360: IF l_count = 0 THEN
361: -- Bug 5474201
362: -- There are no events to be processed, returns success as such

Line 372: 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 );

368: END IF;
369: return;
370: END IF;
371:
372: 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 );
373:
374: ---------------------------------------------------------------
375: -- Calling PA/GMS INTEGRATION API PRIOR TO SLA ONLINE
376: ---------------------------------------------------------------

Line 382: FROM psa_bc_xla_events_gt;

378: psa_utils.debug_other_string(g_state_level,l_path_name, 'Now invoking the PA_GMS_INTEGRATION_API' );
379: pa_gms_integration_api;
380:
381: SELECT count(*) INTO l_count
382: FROM psa_bc_xla_events_gt;
383:
384: 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 );
385:
386: IF l_count < 1 THEN

Line 384: 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 );

380:
381: SELECT count(*) INTO l_count
382: FROM psa_bc_xla_events_gt;
383:
384: 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 );
385:
386: IF l_count < 1 THEN
387:
388: x_status_code := 'FATAL';

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

393:
394: END IF;
395:
396: --
397: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
398: --
399: UPDATE psa_bc_xla_events_gt
400: SET result_code = 'XLA_UNPROCESSED';
401: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

Line 399: UPDATE psa_bc_xla_events_gt

395:
396: --
397: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
398: --
399: UPDATE psa_bc_xla_events_gt
400: SET result_code = 'XLA_UNPROCESSED';
401: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
402:
403:

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

397: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_UNPROCESSED' status
398: --
399: UPDATE psa_bc_xla_events_gt
400: SET result_code = 'XLA_UNPROCESSED';
401: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
402:
403:
404:
405:

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

427: DELETE from psa_bc_alloc_gt;
428: 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);
429: ------------------------------------------------------------------------------------- *
430:
431: -- Insert rows to XLA Events GT table and Call Accounting Engine
432: -----------------------------------------------------------------
433:
434: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
435: SELECT event_id FROM psa_bc_xla_events_gt;

Line 435: SELECT event_id FROM psa_bc_xla_events_gt;

431: -- Insert rows to XLA Events GT table and Call Accounting Engine
432: -----------------------------------------------------------------
433:
434: INSERT into XLA_ACCT_PROG_EVENTS_GT (Event_Id)
435: SELECT event_id FROM psa_bc_xla_events_gt;
436: 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 );
437:
438: l_accounting_events := TRUE;
439: l_accounting_batch_id := NULL;

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

440: l_errbuf := NULL;
441: l_retcode := NULL;
442: l_request_id := NULL;
443:
444: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP

Line 447: FOR x in c_get_bc_xla_events_gt

443:
444: psa_utils.debug_other_string(g_state_level,l_path_name, 'PSA_BC_XLA_EVENTS_GT');
445: psa_utils.debug_other_string(g_state_level,l_path_name, '=====================');
446:
447: FOR x in c_get_bc_xla_events_gt
448: LOOP
449: psa_utils.debug_other_string(g_state_level,l_path_name, 'EVENT_ID = '||x.event_id);
450: psa_utils.debug_other_string(g_state_level,l_path_name, 'RESULT_CODE = '||x.result_code);
451: END LOOP;

Line 470: -- Get psa_bc_xla_events_gt events

466: psa_utils.debug_other_string(g_state_level,l_path_name, 'Return Code = ' || l_retcode);
467: psa_utils.debug_other_string(g_state_level,l_path_name, 'l_errbuf = ' ||l_errbuf );
468: psa_utils.debug_other_string(g_state_level,l_path_name, 'Accounting Batch id = ' ||l_accounting_batch_id );
469:
470: -- Get psa_bc_xla_events_gt events
471: OPEN c_get_psa_events;
472: FETCH c_get_psa_events BULK COLLECT INTO l_psa_events;
473: CLOSE c_get_psa_events;
474:

Line 489: -- update the psa_bc_xla_events_gt event records to

485: l_overall_success := FALSE;
486: Fnd_message.set_name('PSA','PSA_BC_XLA_ERROR');
487: Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
488: Fnd_Msg_Pub.ADD;
489: -- update the psa_bc_xla_events_gt event records to
490: -- XLA_ERROR status
491: UPDATE psa_bc_xla_events_gt
492: SET result_code = 'XLA_ERROR';
493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);

Line 491: UPDATE psa_bc_xla_events_gt

487: Fnd_Message.Set_Token('PARAM_NAME',l_errbuf);
488: Fnd_Msg_Pub.ADD;
489: -- update the psa_bc_xla_events_gt event records to
490: -- XLA_ERROR status
491: UPDATE psa_bc_xla_events_gt
492: SET result_code = 'XLA_ERROR';
493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
494: -- set the status code
495: x_status_code := 'XLA_ERROR';

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

489: -- update the psa_bc_xla_events_gt event records to
490: -- XLA_ERROR status
491: UPDATE psa_bc_xla_events_gt
492: SET result_code = 'XLA_ERROR';
493: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
494: -- set the status code
495: x_status_code := 'XLA_ERROR';
496: ELSE
497: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');

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

496: ELSE
497: psa_utils.debug_other_string(g_state_level,l_path_name,'Events processed by SLA Accounting Engine');
498:
499: --
500: -- Update the PSA_BC_XLA_EVENTS_GT event records to be in 'XLA_NO_JOURNAL' status
501: -- for events that remain in XLA_UNPROCESSED status
502: --
503:
504: IF l_retcode = 0 THEN

Line 505: UPDATE psa_bc_xla_events_gt

501: -- for events that remain in XLA_UNPROCESSED status
502: --
503:
504: IF l_retcode = 0 THEN
505: UPDATE psa_bc_xla_events_gt
506: SET result_code = 'XLA_NO_JOURNAL'
507: WHERE result_code = 'XLA_UNPROCESSED';
508: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
509: END IF;

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

504: IF l_retcode = 0 THEN
505: UPDATE psa_bc_xla_events_gt
506: SET result_code = 'XLA_NO_JOURNAL'
507: WHERE result_code = 'XLA_UNPROCESSED';
508: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
509: END IF;
510:
511: IF l_retcode = 1 THEN
512: OPEN c_xla_errors;

Line 519: UPDATE psa_bc_xla_events_gt

515:
516: IF (l_xla_error = 'Y') THEN
517: x_status_code := 'XLA_ERROR';
518:
519: UPDATE psa_bc_xla_events_gt
520: SET result_code = 'XLA_ERROR';
521: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
522: END IF;
523: END IF;

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

517: x_status_code := 'XLA_ERROR';
518:
519: UPDATE psa_bc_xla_events_gt
520: SET result_code = 'XLA_ERROR';
521: psa_utils.debug_other_string(g_state_level,l_path_name,'Number of rows updated of psa_bc_xla_events_gt: ' || SQL%ROWCOUNT);
522: END IF;
523: END IF;
524:
525: -- Intialize status code to Success

Line 1103: DELETE FROM XLA_EVENTS_GT;

1099: XLA_BAL_STATUSES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1100: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12
1102: XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_EVENTS_GT;
1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT
1105: : Deleted Row count :'||SQL%ROWCOUNT);
1106: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14

Line 1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT

1100: DELETE FROM XLA_BAL_CTRL_LINES_GT;
1101: psa_utils.debug_other_string(g_state_level,l_path_name, '12
1102: XLA_BAL_CTRL_LINES_GT : Deleted Row count :'||SQL%ROWCOUNT);
1103: DELETE FROM XLA_EVENTS_GT;
1104: psa_utils.debug_other_string(g_state_level,l_path_name, '13 XLA_EVENTS_GT
1105: : Deleted Row count :'||SQL%ROWCOUNT);
1106: DELETE FROM XLA_EVT_CLASS_SOURCES_GT;
1107: psa_utils.debug_other_string(g_state_level,l_path_name, '14
1108: XLA_EVT_CLASS_SOURCES_GT : Deleted Row count :'||SQL%ROWCOUNT);