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

Line 1: PACKAGE BODY LNS_XLA_EVENTS AS

1: PACKAGE BODY LNS_XLA_EVENTS AS
2: /* $Header: LNS_XLA_EVENTS_B.pls 120.17 2010/12/28 11:39:37 mbolli ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types

Line 2: /* $Header: LNS_XLA_EVENTS_B.pls 120.17 2010/12/28 11:39:37 mbolli ship $ */

1: PACKAGE BODY LNS_XLA_EVENTS AS
2: /* $Header: LNS_XLA_EVENTS_B.pls 120.17 2010/12/28 11:39:37 mbolli ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types
6: --------------------------------------------

Line 9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS_B.pls';

5: -- declaration of global variables and types
6: --------------------------------------------
7: G_DEBUG_COUNT NUMBER := 0;
8: G_DEBUG BOOLEAN := FALSE;
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS_B.pls';
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS';
12: G_DAYS_COUNT NUMBER;
13: G_DAYS_IN_YEAR NUMBER;

Line 11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS';

7: G_DEBUG_COUNT NUMBER := 0;
8: G_DEBUG BOOLEAN := FALSE;
9: G_FILE_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS_B.pls';
10:
11: G_PKG_NAME CONSTANT VARCHAR2(30) := 'LNS_XLA_EVENTS';
12: G_DAYS_COUNT NUMBER;
13: G_DAYS_IN_YEAR NUMBER;
14:
15: --------------------------------------------

Line 40: || Overview: will write to xla_events table

36: /*=========================================================================
37: || PUBLIC PROCEDURE create_event
38: ||
39: || DESCRIPTION
40: || Overview: will write to xla_events table
41: ||
42: || PSEUDO CODE/LOGIC
43: ||
44: || PARAMETERS

Line 90: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

86: l_msg_count NUMBER;
87: l_msg_data VARCHAR2(32767);
88:
89: l_event_id integer;
90: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
91: l_security_context XLA_EVENTS_PUB_PKG.t_security;
92: l_legal_entity_id number;
93: l_sob_id number;
94: l_loan_number varchar2(60);

Line 91: l_security_context XLA_EVENTS_PUB_PKG.t_security;

87: l_msg_data VARCHAR2(32767);
88:
89: l_event_id integer;
90: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
91: l_security_context XLA_EVENTS_PUB_PKG.t_security;
92: l_legal_entity_id number;
93: l_sob_id number;
94: l_loan_number varchar2(60);
95: l_disb_header_id number;

Line 99: l_event_info xla_events_pub_pkg.t_event_info;

95: l_disb_header_id number;
96: l_loan_amount_adj_id number;
97: l_loan_line_id number;
98: l_event_exists boolean;
99: l_event_info xla_events_pub_pkg.t_event_info;
100:
101: l_old_event_id NUMBER;
102: l_array_event_info xla_events_pub_pkg.t_array_event_info ;
103: l_delete_event NUMBER;

Line 102: l_array_event_info xla_events_pub_pkg.t_array_event_info ;

98: l_event_exists boolean;
99: l_event_info xla_events_pub_pkg.t_event_info;
100:
101: l_old_event_id NUMBER;
102: l_array_event_info xla_events_pub_pkg.t_array_event_info ;
103: l_delete_event NUMBER;
104: l_entity_count NUMBER;
105:
106:

Line 116: FROM xla_events

112: WHERE LOAN_ID = X_Loan_Id;
113:
114: CURSOR c_entity_count(c_old_event_id NUMBER) IS
115: SELECT count(event_id)
116: FROM xla_events
117: WHERE entity_id = (select entity_id from xla_events where event_id = c_old_event_id);
118:
119: cursor c_sob_id(c_loan_id NUMBER) is
120: select so.ledger_id

Line 117: WHERE entity_id = (select entity_id from xla_events where event_id = c_old_event_id);

113:
114: CURSOR c_entity_count(c_old_event_id NUMBER) IS
115: SELECT count(event_id)
116: FROM xla_events
117: WHERE entity_id = (select entity_id from xla_events where event_id = c_old_event_id);
118:
119: cursor c_sob_id(c_loan_id NUMBER) is
120: select so.ledger_id
121: from lns_system_options sb,

Line 138: ,xla_events xe

134: p_source_id_int_4 NUMBER,
135: p_valuation_method VARCHAR2) IS
136: SELECT xe.event_id
137: FROM xla_transaction_entities xte
138: ,xla_events xe
139: ,xla_entity_types_b xet
140: WHERE xte.application_id = p_application_id
141: AND xte.ledger_id = p_ledger_id
142: AND xte.entity_code = p_entity_type_code

Line 224: IF NOT XLA_EVENTS_PUB_PKG.event_exists

220: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
221:
222: BEGIN
223: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');
224: IF NOT XLA_EVENTS_PUB_PKG.event_exists
225: (p_event_source_info => l_loan_details
226: ,p_event_type_code => p_event_type_code
227: ,p_valuation_method => null
228: ,p_security_context => l_security_context)

Line 233: x_event_id := XLA_EVENTS_PUB_PKG.create_event

229: THEN
230: -- Call the XLA create_event API
231: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event doesnt exist');
232:
233: x_event_id := XLA_EVENTS_PUB_PKG.create_event
234: (
235: p_event_source_info => l_loan_details
236: ,p_event_type_code => p_event_type_code -- event type code
237: ,p_event_date => p_event_date -- gl date

Line 261: l_array_event_info := xla_events_pub_pkg.get_array_event_info

257: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event already exists');
258:
259: IF (p_event_type_code <> 'LOAN_ACCRUAL') THEN
260:
261: l_array_event_info := xla_events_pub_pkg.get_array_event_info
262: ( p_event_source_info => l_loan_details,
263: p_event_type_code => p_event_type_code,
264: p_valuation_method => null,
265: p_security_context => l_security_context

Line 278: xla_events_pub_pkg.DELETE_EVENT

274: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Count is '||l_entity_count);
275:
276:
277: -- Cleanup XLA tables for this event
278: xla_events_pub_pkg.DELETE_EVENT
279: (
280: p_event_source_info => l_loan_details,
281: p_event_id => l_old_event_id,
282: p_valuation_method => null,

Line 291: l_delete_event := xla_events_pub_pkg.DELETE_ENTITY( p_source_info => l_loan_details,

287: -- Need to delete the entities from the XLA tables if the entity_id is matched to only one event
288:
289: IF (l_entity_count <= 1) THEN
290:
291: l_delete_event := xla_events_pub_pkg.DELETE_ENTITY( p_source_info => l_loan_details,
292: p_valuation_method => null,
293: p_security_context => l_security_context);
294: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Entity Id of the event is deleted '||l_delete_event);
295:

Line 302: x_event_id := XLA_EVENTS_PUB_PKG.create_event

298: END IF;
299:
300: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'After deletion, create new event');
301: -- Call the XLA create_event API
302: x_event_id := XLA_EVENTS_PUB_PKG.create_event
303: (
304: p_event_source_info => l_loan_details
305: ,p_event_type_code => p_event_type_code -- event type code
306: ,p_event_date => p_event_date -- gl date

Line 324: END IF; -- END of IF NOT XLA_EVENTS_PUB_PKG.event_exists

320: logMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
321: RAISE FND_API.G_EXC_ERROR;
322: end if;
323: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully created Loans XLA event ' || p_event_type_code);
324: END IF; -- END of IF NOT XLA_EVENTS_PUB_PKG.event_exists
325: END; -- END of event Creation code
326:
327: -- ---------------------------------------------------------------------
328: -- End of API body

Line 365: || Overview: will write to xla_events table

361: /*=========================================================================
362: || PUBLIC PROCEDURE update_event
363: ||
364: || DESCRIPTION
365: || Overview: will write to xla_events table
366: ||
367: || PSEUDO CODE/LOGIC
368: ||
369: || PARAMETERS

Line 409: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

405: l_msg_count NUMBER;
406: l_msg_data VARCHAR2(32767);
407:
408: --l_event_id integer;
409: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
410: l_security_context XLA_EVENTS_PUB_PKG.t_security;
411: l_legal_entity_id number;
412: l_sob_id number;
413:

Line 410: l_security_context XLA_EVENTS_PUB_PKG.t_security;

406: l_msg_data VARCHAR2(32767);
407:
408: --l_event_id integer;
409: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
410: l_security_context XLA_EVENTS_PUB_PKG.t_security;
411: l_legal_entity_id number;
412: l_sob_id number;
413:
414: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS

Line 482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');

478: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_3 = ' || l_loan_details.source_id_int_3);
479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
484: ,p_event_id => p_event_id
485: ,p_event_type_code => p_event_type_code
486: ,p_event_date => p_event_date

Line 483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details

479: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
480: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
481:
482: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
483: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
484: ,p_event_id => p_event_id
485: ,p_event_type_code => p_event_type_code
486: ,p_event_date => p_event_date
487: ,p_event_status_code => p_event_status

Line 529: || Overview: will delete events from xla_events table

525: /*=========================================================================
526: || PUBLIC PROCEDURE delete_event
527: ||
528: || DESCRIPTION
529: || Overview: will delete events from xla_events table
530: ||
531: || PSEUDO CODE/LOGIC
532: ||
533: || PARAMETERS

Line 577: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

573: where sb.set_of_books_id = so.ledger_id
574: and lhdr.loan_id = c_loan_id
575: and lhdr.org_id = sb.org_id;
576:
577: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
578: l_security_context XLA_EVENTS_PUB_PKG.t_security;
579: l_legal_entity_id number;
580: l_sob_id number;
581:

Line 578: l_security_context XLA_EVENTS_PUB_PKG.t_security;

574: and lhdr.loan_id = c_loan_id
575: and lhdr.org_id = sb.org_id;
576:
577: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
578: l_security_context XLA_EVENTS_PUB_PKG.t_security;
579: l_legal_entity_id number;
580: l_sob_id number;
581:
582: begin

Line 635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');

631: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_4 = ' || l_loan_details.source_id_int_4);
632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:
635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
636: XLA_EVENTS_PUB_PKG.delete_event
637: (p_event_source_info => l_loan_details
638: ,p_event_id => p_event_id
639: ,p_valuation_method => null

Line 636: XLA_EVENTS_PUB_PKG.delete_event

632: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
633:
634:
635: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
636: XLA_EVENTS_PUB_PKG.delete_event
637: (p_event_source_info => l_loan_details
638: ,p_event_id => p_event_id
639: ,p_valuation_method => null
640: ,p_security_context => l_security_context);

Line 678: end lns_xla_events;

674: ROLLBACK TO delete_event;
675:
676: end delete_event;
677:
678: end lns_xla_events;