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.FV_BE_XLA_PKG dependencies on XLA_EVENTS

Line 73: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

69:
70: -- Definition of get_event_source_info function (private)
71:
72: FUNCTION get_event_source_info
73: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
74:
75: -- Defintion of stamping the event_id of the transaction
76: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);
77:

Line 76: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);

72: FUNCTION get_event_source_info
73: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
74:
75: -- Defintion of stamping the event_id of the transaction
76: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);
77:
78: -- Definition of reset event_id of the transaction
79: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);
80:

Line 79: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);

75: -- Defintion of stamping the event_id of the transaction
76: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);
77:
78: -- Definition of reset event_id of the transaction
79: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE);
80:
81: -- Definition of populate_bc_events_tab (private)
82: PROCEDURE populate_bc_events_tab;
83:

Line 135: l_event_id XLA_EVENTS.EVENT_ID%TYPE;

131:
132: l_calling_sequence VARCHAR2(2000);
133: l_module_name VARCHAR2(1000);
134:
135: l_event_id XLA_EVENTS.EVENT_ID%TYPE;
136:
137: l_msg_data VARCHAR2(1000);
138: l_msg_count NUMBER;
139: l_api_version VARCHAR2(100);

Line 237: -- Insert into psa_bc_xla_events_gt

233: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
234: 'call populate_bc_events_tab');
235: END IF;
236:
237: -- Insert into psa_bc_xla_events_gt
238: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Invoke populate_bc_events() ');
239: populate_bc_events_tab;
240:
241:

Line 325: FROM fv_be_trx_dtls FVBE, xla_events XLAE

321:
322: -- Cursor to pull Event_Id for Delete_Events API for accounting_date change
323: Cursor fv_be_event_id IS
324: SELECT distinct fvbe.event_id,xlae.event_date
325: FROM fv_be_trx_dtls FVBE, xla_events XLAE
326: WHERE FVBE.doc_id = g_doc_id
327: AND FVBE.event_id = XLAE.event_id
328: AND FVBE.gl_date <> XLAE.event_date
329: AND FVBE.transaction_status <> 'AR'

Line 333: FROM fv_be_rpr_transactions FVBE, xla_events XLAE

329: AND FVBE.transaction_status <> 'AR'
330: AND fvbe.approval_date is null
331: UNION
332: SELECT distinct fvbe.event_id,xlae.event_date
333: FROM fv_be_rpr_transactions FVBE, xla_events XLAE
334: WHERE FVBE.transaction_id = g_doc_id
335: AND FVBE.event_id = XLAE.event_id
336: AND FVBE.gl_date <> XLAE.event_date
337: AND FVBE.transaction_status <> 'AR';

Line 357: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;

353: l_event_id INTEGER;
354:
355: -- XLA event source plsql table definition
356:
357: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
358: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
359:
360: l_entity_deleted INTEGER;
361:

Line 358: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

354:
355: -- XLA event source plsql table definition
356:
357: l_event_security_context XLA_EVENTS_PUB_PKG.T_SECURITY;
358: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
359:
360: l_entity_deleted INTEGER;
361:
362: BEGIN

Line 398: IF XLA_EVENTS_PUB_PKG.EVENT_EXISTS

394: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
395: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,
396: 'Check if event exists before deleteion for event:'||l_event_id);
397: END IF;
398: IF XLA_EVENTS_PUB_PKG.EVENT_EXISTS
399: (p_event_source_info => l_event_source_info
400: ,p_event_class_code => g_event_class
401: ,p_event_type_code => g_event_type
402: ,p_event_date => fv_be_event_id_Rec.event_date

Line 410: XLA_EVENTS_PUB_PKG.DELETE_EVENT

406: ,p_security_context => l_event_security_context) THEN
407: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
408: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Event API:'||l_event_id);
409: END IF;
410: XLA_EVENTS_PUB_PKG.DELETE_EVENT
411: (p_event_source_info => l_event_source_info
412: ,p_event_id => l_event_id
413: ,p_valuation_method => NULL
414: ,p_security_context => l_event_security_context);

Line 419: l_entity_deleted := XLA_EVENTS_PUB_PKG.delete_entity

415: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
416: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call Delete_Entity API:'||l_event_id);
417: END IF;
418:
419: l_entity_deleted := XLA_EVENTS_PUB_PKG.delete_entity
420: (p_source_info => l_event_source_info
421: ,p_valuation_method => NULL
422: ,p_security_context => l_event_security_context);
423:

Line 445: IF NOT XLA_EVENTS_PUB_PKG.EVENT_EXISTS

441: FOR fv_be_gl_date_Rec in fv_be_gl_date
442: LOOP
443: g_accounting_date := fv_be_gl_date_Rec.gl_date;
444:
445: IF NOT XLA_EVENTS_PUB_PKG.EVENT_EXISTS
446: (p_event_source_info => l_event_source_info
447: ,p_event_class_code => g_event_class
448: ,p_event_type_code => g_event_type
449: ,p_event_date => g_accounting_date

Line 457: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');

453: ,p_security_context => l_event_security_context) OR
454: fv_be_gl_date_Rec.event_id IS NULL THEN
455: -- Create Event
456: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
457: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');
458: END IF;
459: l_event_id := XLA_EVENTS_PUB_PKG.CREATE_EVENT
460: (p_event_source_info => l_event_source_info
461: ,p_event_type_code => g_event_type

Line 459: l_event_id := XLA_EVENTS_PUB_PKG.CREATE_EVENT

455: -- Create Event
456: IF (G_LEVEL_PROCEDURE >= G_CURRENT_RUNTIME_LEVEL) THEN
457: FV_UTILITY.DEBUG_MESG(G_LEVEL_PROCEDURE,l_module_name,'Call xla_events_pub_pkg.create_event');
458: END IF;
459: l_event_id := XLA_EVENTS_PUB_PKG.CREATE_EVENT
460: (p_event_source_info => l_event_source_info
461: ,p_event_type_code => g_event_type
462: ,p_event_date => g_accounting_date
463: ,p_event_status_code => 'U'

Line 502: | RETURN: XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO

Line 509: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO

505: |
506: | NOTES:
507: *===========================================================================*/
508: FUNCTION get_event_source_info
509: RETURN XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO
510: IS
511:
512: l_doc_num VARCHAR2(50);
513: l_prepare_stmt VARCHAR2(1000);

Line 514: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;

510: IS
511:
512: l_doc_num VARCHAR2(50);
513: l_prepare_stmt VARCHAR2(1000);
514: l_event_source_info XLA_EVENTS_PUB_PKG.T_EVENT_SOURCE_INFO;
515: l_module_name VARCHAR2(1000);
516:
517: BEGIN
518: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Get_Event_Source_Info');

Line 564: | This procedure is used to insert event into psa_bc_xla_events_gt table

560: /*============================================================================
561: | PROCEDURE - POPULATE_BC_EVENTS_TAB(PRIVATE)
562: |
563: | DESCRIPTION
564: | This procedure is used to insert event into psa_bc_xla_events_gt table
565: |
566: | PRAMETERS:
567: | NULL
568: |

Line 585: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

581: IF g_doc_id is null THEN
582: RETURN;
583: ELSE
584: IF g_doc_type = BE_ENTITY THEN
585: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
586: SELECT distinct event_id,'XLA_ERROR'
587: FROM FV_BE_TRX_DTLS
588: WHERE doc_id = g_doc_id
589: AND transaction_status <> 'AR'

Line 592: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)

588: WHERE doc_id = g_doc_id
589: AND transaction_status <> 'AR'
590: AND approval_date IS NULL;
591: ELSIF g_doc_type = BE_RPR_ENTITY THEN
592: INSERT INTO psa_bc_xla_events_gt(event_id,result_code)
593: SELECT distinct event_id,'XLA_ERROR' FROM FV_BE_RPR_TRANSACTIONS WHERE transaction_id = g_doc_id;
594: END IF;
595: END IF;
596: FND_FILE.PUT_LINE(FND_FILE.LOG,'End Populate_BC_Events_Tab');

Line 615: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)

611: |
612: | NOTES:
613: *===========================================================================*/
614:
615: PROCEDURE stamp_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)
616: IS
617: BEGIN
618: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Stamp_Event');
619:

Line 655: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)

651: | NOTES:
652: *===========================================================================*/
653:
654:
655: PROCEDURE reset_event(p_event_id XLA_EVENTS.EVENT_ID%TYPE)
656: IS
657: BEGIN
658: FND_FILE.PUT_LINE(FND_FILE.LOG,'Begin Reset_Event');
659: