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_PUB_PKG

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 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 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 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);