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