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.8.12010000.3 2008/09/11 21:56:49 scherkas ship $ */
3:
4: --------------------------------------------
5: -- declaration of global variables and types

Line 2: /* $Header: LNS_XLA_EVENTS_B.pls 120.8.12010000.3 2008/09/11 21:56:49 scherkas ship $ */

1: PACKAGE BODY LNS_XLA_EVENTS AS
2: /* $Header: LNS_XLA_EVENTS_B.pls 120.8.12010000.3 2008/09/11 21:56:49 scherkas 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 84: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

80: l_msg_count NUMBER;
81: l_msg_data VARCHAR2(32767);
82:
83: l_event_id integer;
84: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
85: l_security_context XLA_EVENTS_PUB_PKG.t_security;
86: l_legal_entity_id number;
87: l_sob_id number;
88: l_loan_number varchar2(60);

Line 85: l_security_context XLA_EVENTS_PUB_PKG.t_security;

81: l_msg_data VARCHAR2(32767);
82:
83: l_event_id integer;
84: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
85: l_security_context XLA_EVENTS_PUB_PKG.t_security;
86: l_legal_entity_id number;
87: l_sob_id number;
88: l_loan_number varchar2(60);
89: l_disb_header_id number;

Line 91: l_event_info xla_events_pub_pkg.t_event_info;

87: l_sob_id number;
88: l_loan_number varchar2(60);
89: l_disb_header_id number;
90: l_event_exists boolean;
91: l_event_info xla_events_pub_pkg.t_event_info;
92:
93: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS
94: SELECT LEGAL_ENTITY_ID
95: ,LOAN_NUMBER

Line 113: ,xla_events xe

109: p_source_id_int_2 NUMBER,
110: p_valuation_method VARCHAR2) IS
111: SELECT xe.event_id
112: FROM xla_transaction_entities xte
113: ,xla_events xe
114: ,xla_entity_types_b xet
115: WHERE xte.application_id = p_application_id
116: AND xte.ledger_id = p_ledger_id
117: AND xte.entity_code = p_entity_type_code

Line 191: l_event_exists := xla_events_pub_pkg.event_exists (p_event_source_info => l_loan_details

187: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
188:
189:
190: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Checking if event already exists...');
191: l_event_exists := xla_events_pub_pkg.event_exists (p_event_source_info => l_loan_details
192: ,p_event_type_code => p_event_type_code
193: ,p_valuation_method => null
194: ,p_security_context => l_security_context);
195: if not l_event_exists then

Line 197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.create_event...');

193: ,p_valuation_method => null
194: ,p_security_context => l_security_context);
195: if not l_event_exists then
196: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event doesnt exist');
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.create_event...');
198: x_event_id := XLA_EVENTS_PUB_PKG.create_event(p_event_source_info => l_loan_details
199: ,p_event_type_code => p_event_type_code -- event type code
200: ,p_event_date => p_event_date -- gl date
201: ,p_event_status_code => p_event_status -- event status

Line 198: x_event_id := XLA_EVENTS_PUB_PKG.create_event(p_event_source_info => l_loan_details

194: ,p_security_context => l_security_context);
195: if not l_event_exists then
196: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Event doesnt exist');
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.create_event...');
198: x_event_id := XLA_EVENTS_PUB_PKG.create_event(p_event_source_info => l_loan_details
199: ,p_event_type_code => p_event_type_code -- event type code
200: ,p_event_date => p_event_date -- gl date
201: ,p_event_status_code => p_event_status -- event status
202: ,p_event_number => NULL

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

273: /*=========================================================================
274: || PUBLIC PROCEDURE update_event
275: ||
276: || DESCRIPTION
277: || Overview: will write to xla_events table
278: ||
279: || PSEUDO CODE/LOGIC
280: ||
281: || PARAMETERS

Line 319: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

315: l_msg_count NUMBER;
316: l_msg_data VARCHAR2(32767);
317:
318: --l_event_id integer;
319: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
320: l_security_context XLA_EVENTS_PUB_PKG.t_security;
321: l_legal_entity_id number;
322: l_sob_id number;
323:

Line 320: l_security_context XLA_EVENTS_PUB_PKG.t_security;

316: l_msg_data VARCHAR2(32767);
317:
318: --l_event_id integer;
319: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
320: l_security_context XLA_EVENTS_PUB_PKG.t_security;
321: l_legal_entity_id number;
322: l_sob_id number;
323:
324: CURSOR C_Get_Loan_Info (X_Loan_Id NUMBER) IS

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

377: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
380:
381: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
382: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
383: ,p_event_id => p_event_id
384: ,p_event_type_code => p_event_type_code
385: ,p_event_date => p_event_date

Line 382: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details

378: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
379: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
380:
381: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.Update_event...');
382: XLA_EVENTS_PUB_PKG.Update_event(p_event_source_info => l_loan_details
383: ,p_event_id => p_event_id
384: ,p_event_type_code => p_event_type_code
385: ,p_event_date => p_event_date
386: ,p_event_status_code => p_event_status

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

424: /*=========================================================================
425: || PUBLIC PROCEDURE delete_event
426: ||
427: || DESCRIPTION
428: || Overview: will delete events from xla_events table
429: ||
430: || PSEUDO CODE/LOGIC
431: ||
432: || PARAMETERS

Line 471: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;

467: from lns_system_options sb,
468: gl_sets_of_books so
469: where sb.set_of_books_id = so.set_of_books_id;
470:
471: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
472: l_security_context XLA_EVENTS_PUB_PKG.t_security;
473: l_legal_entity_id number;
474: l_sob_id number;
475:

Line 472: l_security_context XLA_EVENTS_PUB_PKG.t_security;

468: gl_sets_of_books so
469: where sb.set_of_books_id = so.set_of_books_id;
470:
471: l_loan_details XLA_EVENTS_PUB_PKG.t_event_source_info;
472: l_security_context XLA_EVENTS_PUB_PKG.t_security;
473: l_legal_entity_id number;
474: l_sob_id number;
475:
476: begin

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

515: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_1 = ' || l_loan_details.source_id_int_1);
516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
518:
519: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
520: XLA_EVENTS_PUB_PKG.delete_event
521: (p_event_source_info => l_loan_details
522: ,p_event_id => p_event_id
523: ,p_valuation_method => null

Line 520: XLA_EVENTS_PUB_PKG.delete_event

516: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.source_id_int_2 = ' || l_loan_details.source_id_int_2);
517: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_loan_details.entity_type_code = ' || l_loan_details.entity_type_code);
518:
519: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling XLA_EVENTS_PUB_PKG.delete_event...');
520: XLA_EVENTS_PUB_PKG.delete_event
521: (p_event_source_info => l_loan_details
522: ,p_event_id => p_event_id
523: ,p_valuation_method => null
524: ,p_security_context => l_security_context);

Line 560: end lns_xla_events;

556: ROLLBACK TO delete_event;
557:
558: end delete_event;
559:
560: end lns_xla_events;