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_DISTRIBUTIONS_PUB dependencies on XLA_EVENTS

Line 57: ,xla_events xle

53:
54: cursor c_events(p_loan_id number) is
55: select event_id
56: from xla_transaction_entities xlee
57: ,xla_events xle
58: where xle.application_id = 206
59: and xle.entity_id = xlee.entity_id
60: and xlee.source_id_int_1 = p_loan_id
61: and xle.budgetary_control_flag = 'Y'

Line 131: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');

127: close c_budget_req;
128: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_budget_req_approval ' || l_budget_req_approval);
129: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag ' || l_funds_reserved_flag);
130:
131: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
132:
133: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
134: ,p_disb_header_id => l_disbursement_id
135: ,p_event_type_code => 'FUTURE_DISBURSEMENT_CANCELLED'

Line 133: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

129: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag ' || l_funds_reserved_flag);
130:
131: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
132:
133: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
134: ,p_disb_header_id => l_disbursement_id
135: ,p_event_type_code => 'FUTURE_DISBURSEMENT_CANCELLED'
136: ,p_event_date => l_gl_date
137: ,p_event_status => 'U'

Line 167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);

163: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Done');
164:
165: if l_funds_reserved_flag = 'Y' then
166:
167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
168: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
169: values (l_event_id, 'FAIL');
170:
171: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 168: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

164:
165: if l_funds_reserved_flag = 'Y' then
166:
167: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
168: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
169: values (l_event_id, 'FAIL');
170:
171: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
172: -- always pass P_BC_MODE = reserve as per shaniqua williams

Line 279: ,xla_events xle

275:
276: cursor c_event (p_loan_id number) is
277: select xle.event_id, xll.source_distribution_id_num_1, ledger_id
278: from xla_transaction_entities xlee
279: ,xla_events xle
280: ,xla_distribution_links xll
281: where xle.application_id = 206
282: and xle.entity_id = xlee.entity_id
283: and xlee.source_id_int_1 = p_loan_id

Line 418: ,xla_events xle

414: -- get budgetary control events only
415: cursor c_events(p_loan_id number) is
416: select event_id
417: from xla_transaction_entities xlee
418: ,xla_events xle
419: where xle.application_id = 206
420: and xle.entity_id = xlee.entity_id
421: and xlee.source_id_int_1 = p_loan_id
422: and xle.budgetary_control_flag = 'Y'

Line 440: ,xla_events xle

436:
437: cursor c_budget_event(p_loan_id number, p_disb_header_id number) is
438: select count(1)
439: from xla_transaction_entities xlee
440: ,xla_events xle
441: where xle.application_id = 206
442: and xle.entity_id = xlee.entity_id
443: and xlee.source_id_int_1 = p_loan_id
444: and xlee.source_id_int_2 = p_disb_header_id

Line 496: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');

492: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_budget_req_approval = ' || l_budget_req_approval);
493: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag = ' || l_funds_reserved_flag);
494:
495: if l_budget_event_exists = 0 then
496: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
497:
498: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
499: ,p_disb_header_id => l_disbursement_id
500: ,p_event_type_code => 'DIRECT_LOAN_APPROVED'

Line 498: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

494:
495: if l_budget_event_exists = 0 then
496: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
497:
498: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
499: ,p_disb_header_id => l_disbursement_id
500: ,p_event_type_code => 'DIRECT_LOAN_APPROVED'
501: ,p_event_date => l_gl_date
502: ,p_event_status => 'U'

Line 542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');

538: fetch c_events into l_event_id;
539: EXIT WHEN c_events%NOTFOUND;
540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
543: insert
544: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
545: values (l_event_id, 'FAIL');
546:

Line 544: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

540:
541: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
542: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
543: insert
544: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
545: values (l_event_id, 'FAIL');
546:
547: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
548: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0

Line 1081: || Overview: will write to xla_events table and update lns_distributions

1077: /*=========================================================================
1078: || PUBLIC PROCEDURE create_event
1079: ||
1080: || DESCRIPTION
1081: || Overview: will write to xla_events table and update lns_distributions
1082: || this can handle a set of accounting event records
1083: ||
1084: || PSEUDO CODE/LOGIC
1085: ||

Line 1156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');

1152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_date = ' || p_acc_event_tbl(k).event_date);
1153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_acc_event_tbl(k).event_status);
1154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_acc_event_tbl(k).budgetary_control_flag);
1155:
1156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
1157: LNS_XLA_EVENTS.create_event(p_loan_id => p_acc_event_tbl(k).loan_id
1158: ,p_disb_header_id => p_acc_event_tbl(k).disb_header_id
1159: ,p_event_type_code => p_acc_event_tbl(k).event_type_code
1160: ,p_event_date => p_acc_event_tbl(k).event_date

Line 1157: LNS_XLA_EVENTS.create_event(p_loan_id => p_acc_event_tbl(k).loan_id

1153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_acc_event_tbl(k).event_status);
1154: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_acc_event_tbl(k).budgetary_control_flag);
1155:
1156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
1157: LNS_XLA_EVENTS.create_event(p_loan_id => p_acc_event_tbl(k).loan_id
1158: ,p_disb_header_id => p_acc_event_tbl(k).disb_header_id
1159: ,p_event_type_code => p_acc_event_tbl(k).event_type_code
1160: ,p_event_date => p_acc_event_tbl(k).event_date
1161: ,p_event_status => p_acc_event_tbl(k).event_status

Line 3298: adj_info xla_events_pub_pkg.t_event_source_info;

3294: l_subsidy_rate number;
3295: l_loan_class varchar2(30);
3296: l_loan_type_id number;
3297: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3298: adj_info xla_events_pub_pkg.t_event_source_info;
3299: inv_info xla_events_pub_pkg.t_event_source_info;
3300: l_adjustment_id number;
3301: l_customer_trx_id number;
3302: l_accounting_batch_id NUMBER;

Line 3299: inv_info xla_events_pub_pkg.t_event_source_info;

3295: l_loan_class varchar2(30);
3296: l_loan_type_id number;
3297: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
3298: adj_info xla_events_pub_pkg.t_event_source_info;
3299: inv_info xla_events_pub_pkg.t_event_source_info;
3300: l_adjustment_id number;
3301: l_customer_trx_id number;
3302: l_accounting_batch_id NUMBER;
3303: l_errbuf VARCHAR2(10000);

Line 3309: l_event_array xla_events_pub_pkg.t_array_event_info;

3305: l_request_id NUMBER;
3306: l_legal_entity_id number;
3307: l_version number;
3308: l_error_counter number;
3309: l_event_array xla_events_pub_pkg.t_array_event_info;
3310: l_error_message varchar2(2000);
3311: l_invoice_number varchar2(100);
3312: l_entity_code varchar2(30);
3313: l_transactions_count number;

Line 3322: l_EVENT_SOURCE_INFO xla_events_pub_pkg.t_event_source_info;

3318: l_clearing_total_amount_due number;
3319: l_receivable_total_amount_due number;
3320: l_transaction_number VARCHAR2(240);
3321: l_sob_id number;
3322: l_EVENT_SOURCE_INFO xla_events_pub_pkg.t_event_source_info;
3323:
3324: /*------------------------------------------------------------------------+
3325: | Cursor Declarations |
3326: +-----------------------------------------------------------------------*/

Line 4153: from xla_events xle

4149: and disb.account_name = 'LOAN_RECEIVABLE'
4150: and dh.status = 'FULLY_FUNDED'
4151: and not exists
4152: (select 'X'
4153: from xla_events xle
4154: ,XLA_TRANSACTION_ENTITIES XLEE
4155: ,xla_ae_headers aeh
4156: where XLE.application_id = 206
4157: and XLE.event_id = disb.event_id

Line 4222: -- from xla_events xle

4218: and disb.account_name = 'LOAN_RECEIVABLE'
4219: and dh.status = 'FULLY_FUNDED');
4220: -- and not exists
4221: -- (select 'X'
4222: -- from xla_events xle
4223: -- ,XLA_TRANSACTION_ENTITIES XLEE
4224: -- ,xla_ae_headers aeh
4225: -- where XLE.application_id = 206
4226: -- and XLE.event_id = disb.event_id

Line 4424: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');

4420: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Only works for ERS loans.');
4421: return;
4422: END IF;
4423:
4424: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
4425: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
4426: ,p_disb_header_id => -1
4427: ,p_event_type_code => 'APPROVED'
4428: ,p_event_date => l_gl_date

Line 4425: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID

4421: return;
4422: END IF;
4423:
4424: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
4425: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
4426: ,p_disb_header_id => -1
4427: ,p_event_type_code => 'APPROVED'
4428: ,p_event_date => l_gl_date
4429: ,p_event_status => 'U'

Line 4443: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';

4439:
4440: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
4441: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
4442: FND_MSG_PUB.ADD;
4443: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
4444: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
4445: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4446: END IF;
4447: