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 63: ,xla_events xle

59:
60: cursor c_events(p_loan_id number) is
61: select event_id
62: from xla_transaction_entities xlee
63: ,xla_events xle
64: where xle.application_id = 206
65: and xle.entity_id = xlee.entity_id
66: and xlee.source_id_int_1 = p_loan_id
67: and xle.budgetary_control_flag = 'Y'

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

151: close c_budget_req;
152: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_budget_req_approval ' || l_budget_req_approval);
153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag ' || l_funds_reserved_flag);
154:
155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
156:
157: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
158: ,p_disb_header_id => -1
159: ,p_loan_amount_adj_id => -1

Line 157: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

153: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag ' || l_funds_reserved_flag);
154:
155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
156:
157: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
158: ,p_disb_header_id => -1
159: ,p_loan_amount_adj_id => -1
160: ,p_event_type_code => 'FUTURE_DISBURSEMENT_CANCELLED'
161: ,p_event_date => l_gl_date

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

189: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id '||l_event_id||' succesfully for '||SQL%ROWCOUNT||' rows');
190:
191: if (l_funds_reserved_flag = 'Y') then
192:
193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
195: values (l_event_id, 'FAIL');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

190:
191: if (l_funds_reserved_flag = 'Y') then
192:
193: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
194: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
195: values (l_event_id, 'FAIL');
196:
197: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
198: -- always pass P_BC_MODE = reserve as per shaniqua williams

Line 315: ,xla_events xle

311:
312: cursor c_event (c_loan_id number, c_loan_amount_adj_id number) is
313: select xle.event_id, xll.source_distribution_id_num_1, ledger_id
314: from xla_transaction_entities xlee
315: ,xla_events xle
316: ,xla_distribution_links xll
317: where xle.application_id = 206
318: and xle.entity_id = xlee.entity_id
319: and xlee.source_id_int_1 = c_loan_id

Line 329: ,xla_events xle

325: cursor c_loan_adj(c_loan_id number) is
326: select max(ladj.loan_amount_adj_id)
327: from lns_loan_amount_adjs ladj
328: ,xla_transaction_entities xlee
329: ,xla_events xle
330: where ladj.loan_id = c_loan_id
331: and xlee.entity_id = xle.entity_id
332: and xle.event_type_code in ('DIRECT_LOAN_ADJ_APPROVED', 'DIRECT_LOAN_ADJ_REVERSED')
333: and xlee.source_id_int_1 = ladj.loan_id

Line 532: ,xla_events xle

528: -- get budgetary control events only
529: cursor c_events(p_loan_id number) is
530: select event_id
531: from xla_transaction_entities xlee
532: ,xla_events xle
533: where xle.application_id = 206
534: and xle.entity_id = xlee.entity_id
535: and xlee.source_id_int_1 = p_loan_id
536: and xle.budgetary_control_flag = 'Y'

Line 555: ,xla_events xle

551:
552: cursor c_budget_event(p_loan_id number) is
553: select count(1)
554: from xla_transaction_entities xlee
555: ,xla_events xle
556: where xle.application_id = 206
557: and xle.entity_id = xlee.entity_id
558: and xlee.source_id_int_1 = p_loan_id
559: -- and xlee.source_id_int_2 = p_disb_header_id

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

607: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_budget_req_approval = ' || l_budget_req_approval);
608: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag = ' || l_funds_reserved_flag);
609:
610: if l_budget_event_exists = 0 then
611: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
612:
613: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
614: ,p_disb_header_id => -1
615: ,p_loan_amount_adj_id => -1

Line 613: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

609:
610: if l_budget_event_exists = 0 then
611: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
612:
613: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
614: ,p_disb_header_id => -1
615: ,p_loan_amount_adj_id => -1
616: ,p_event_type_code => 'DIRECT_LOAN_APPROVED'
617: ,p_event_date => l_gl_date

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

672: and event_id IS NULL
673: and loan_id = p_loan_id;
674:
675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id succesfully for '||SQL%ROWCOUNT||' rows');
676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
677: insert
678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
679: values (l_event_id, 'FAIL');
680:

Line 678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

674:
675: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id succesfully for '||SQL%ROWCOUNT||' rows');
676: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
677: insert
678: into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
679: values (l_event_id, 'FAIL');
680:
681: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
682: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0

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

1376: /*=========================================================================
1377: || PUBLIC PROCEDURE create_event
1378: ||
1379: || DESCRIPTION
1380: || Overview: will write to xla_events table and update lns_distributions
1381: || this can handle a set of accounting event records
1382: ||
1383: || PSEUDO CODE/LOGIC
1384: ||

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

1459: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_event_status = ' || p_acc_event_tbl(k).event_status);
1460: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_acc_event_tbl(k).budgetary_control_flag);
1461:
1462:
1463: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
1464: LNS_XLA_EVENTS.create_event(p_loan_id => p_acc_event_tbl(k).loan_id
1465: ,p_disb_header_id => p_acc_event_tbl(k).disb_header_id
1466: ,p_loan_amount_adj_id => p_acc_event_tbl(k).loan_amount_adj_id
1467: ,p_loan_line_id => p_acc_event_tbl(k).loan_line_id

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

1460: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'p_bc_flag = ' || p_acc_event_tbl(k).budgetary_control_flag);
1461:
1462:
1463: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
1464: LNS_XLA_EVENTS.create_event(p_loan_id => p_acc_event_tbl(k).loan_id
1465: ,p_disb_header_id => p_acc_event_tbl(k).disb_header_id
1466: ,p_loan_amount_adj_id => p_acc_event_tbl(k).loan_amount_adj_id
1467: ,p_loan_line_id => p_acc_event_tbl(k).loan_line_id
1468: ,p_event_type_code => p_acc_event_tbl(k).event_type_code

Line 4123: adj_info xla_events_pub_pkg.t_event_source_info;

4119: l_subsidy_rate number;
4120: l_loan_class varchar2(30);
4121: l_loan_type_id number;
4122: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4123: adj_info xla_events_pub_pkg.t_event_source_info;
4124: inv_info xla_events_pub_pkg.t_event_source_info;
4125: l_adjustment_id number;
4126: l_customer_trx_id number;
4127: l_accounting_batch_id NUMBER;

Line 4124: inv_info xla_events_pub_pkg.t_event_source_info;

4120: l_loan_class varchar2(30);
4121: l_loan_type_id number;
4122: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
4123: adj_info xla_events_pub_pkg.t_event_source_info;
4124: inv_info xla_events_pub_pkg.t_event_source_info;
4125: l_adjustment_id number;
4126: l_customer_trx_id number;
4127: l_accounting_batch_id NUMBER;
4128: l_errbuf VARCHAR2(10000);

Line 4134: l_event_array xla_events_pub_pkg.t_array_event_info;

4130: l_request_id NUMBER;
4131: l_legal_entity_id number;
4132: l_version number;
4133: l_error_counter number;
4134: l_event_array xla_events_pub_pkg.t_array_event_info;
4135: l_error_message varchar2(2000);
4136: l_invoice_number varchar2(100);
4137: l_entity_code varchar2(30);
4138: l_transactions_count number;

Line 4147: l_EVENT_SOURCE_INFO xla_events_pub_pkg.t_event_source_info;

4143: l_clearing_total_amount_due number;
4144: l_receivable_total_amount_due number;
4145: l_transaction_number VARCHAR2(240);
4146: l_sob_id number;
4147: l_EVENT_SOURCE_INFO xla_events_pub_pkg.t_event_source_info;
4148: l_new_ccid_already_exists VARCHAR2(1);
4149: l_loan_status varchar2(30);
4150: l_bill_dist_cnt NUMBER;
4151: l_is_natural_acct_exists VARCHAR2(1);

Line 5114: from xla_events xle

5110: and disb.account_name = 'LOAN_RECEIVABLE'
5111: and dh.status = 'FULLY_FUNDED'
5112: and not exists
5113: (select 'X'
5114: from xla_events xle
5115: ,XLA_TRANSACTION_ENTITIES XLEE
5116: ,xla_ae_headers aeh
5117: where XLE.application_id = 206
5118: and XLE.event_id = disb.event_id

Line 5138: from xla_events xle

5134: and disb.account_name = 'LOAN_RECEIVABLE'
5135: and ladj.status = 'APPROVED'
5136: and not exists
5137: (select 'X'
5138: from xla_events xle
5139: ,XLA_TRANSACTION_ENTITIES XLEE
5140: ,xla_ae_headers aeh
5141: where XLE.application_id = 206
5142: and XLE.event_id = disb.event_id

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

5406: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || ' - Only works for ERS loans.');
5407: return;
5408: END IF;
5409:
5410: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
5411: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
5412: ,p_disb_header_id => -1
5413: ,p_loan_amount_adj_id => -1
5414: ,p_event_type_code => 'APPROVED'

Line 5411: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID

5407: return;
5408: END IF;
5409:
5410: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
5411: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
5412: ,p_disb_header_id => -1
5413: ,p_loan_amount_adj_id => -1
5414: ,p_event_type_code => 'APPROVED'
5415: ,p_event_date => l_gl_date

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

5426:
5427: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5428: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
5429: FND_MSG_PUB.ADD;
5430: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
5431: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
5432: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5433: END IF;
5434:

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

5634: fetch c_loan_info into l_gl_date;
5635: close c_loan_info;
5636: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_gl_date = ' || l_gl_date);
5637:
5638: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
5639: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
5640: ,p_disb_header_id => -1
5641: ,p_loan_amount_adj_id => -1
5642: ,p_event_type_code => 'APPROVED'

Line 5639: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID

5635: close c_loan_info;
5636: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_gl_date = ' || l_gl_date);
5637:
5638: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
5639: LNS_XLA_EVENTS.create_event(p_loan_id => P_LOAN_ID
5640: ,p_disb_header_id => -1
5641: ,p_loan_amount_adj_id => -1
5642: ,p_event_type_code => 'APPROVED'
5643: ,p_event_date => l_gl_date

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

5654:
5655: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
5656: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
5657: FND_MSG_PUB.ADD;
5658: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
5659: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
5660: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5661: END IF;
5662:

Line 5988: ,xla_events xle

5984: -- get budgetary control events only
5985: cursor c_events(c_loan_amount_adj_id number, c_event_type varchar2) is
5986: select event_id
5987: from xla_transaction_entities xlee
5988: ,xla_events xle
5989: where xle.application_id = 206
5990: and xle.entity_id = xlee.entity_id
5991: and xlee.source_id_int_3 = c_loan_amount_adj_id
5992: and xle.event_type_code = c_event_type

Line 6024: ,xla_events xle

6020:
6021: cursor c_budget_event(c_loan_adj_id number, c_event_type varchar2) is
6022: select count(1)
6023: from xla_transaction_entities xlee
6024: ,xla_events xle
6025: where xle.application_id = 206
6026: and xle.entity_id = xlee.entity_id
6027: and xlee.source_id_int_3 = c_loan_adj_id
6028: and xle.event_type_code = c_event_type

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

6154:
6155: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_budget_req_approval = ' || l_budget_req_approval);
6156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag = ' || l_funds_reserved_flag);
6157:
6158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
6159:
6160: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
6161: ,p_disb_header_id => -1
6162: ,p_loan_amount_adj_id => l_loan_amount_adj_id

Line 6160: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

6156: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_funds_reserved_flag = ' || l_funds_reserved_flag);
6157:
6158: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
6159:
6160: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
6161: ,p_disb_header_id => -1
6162: ,p_loan_amount_adj_id => l_loan_amount_adj_id
6163: ,p_event_type_code => l_event_type
6164: ,p_event_date => l_gl_date

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

6203: IF l_event_id IS NOT NULL THEN
6204:
6205: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
6206:
6207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)
6209: values (l_event_id, 'FAIL');
6210:
6211: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)

6204:
6205: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_event_id = ' || l_event_id);
6206:
6207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT ');
6208: INSERT INTO PSA_BC_XLA_EVENTS_GT (event_id, result_code)
6209: values (l_event_id, 'FAIL');
6210:
6211: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
6212: PSA_BC_XLA_PUB.Budgetary_Control(p_api_version => 1.0

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

7197: end if;
7198:
7199: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_gl_date = ' || l_gl_date);
7200:
7201: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
7202: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
7203: ,p_disb_header_id => -1
7204: ,p_loan_amount_adj_id => -1
7205: ,p_loan_line_id => p_loan_line_id

Line 7202: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

7198:
7199: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'l_gl_date = ' || l_gl_date);
7200:
7201: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
7202: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
7203: ,p_disb_header_id => -1
7204: ,p_loan_amount_adj_id => -1
7205: ,p_loan_line_id => p_loan_line_id
7206: ,p_event_type_code => 'ERS_LOAN_ADD_REC_APPROVED'

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

7218:
7219: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
7220: FND_MESSAGE.SET_NAME('LNS', 'LNS_ACCOUNTING_EVENT_ERROR');
7221: FND_MSG_PUB.ADD;
7222: --l_last_api_called := 'LNS_XLA_EVENTS.create_event';
7223: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
7224: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
7225: END IF;
7226:

Line 7646: ,xla_events xle

7642:
7643: cursor c_events(p_loan_id number) is
7644: select event_id
7645: from xla_transaction_entities xlee
7646: ,xla_events xle
7647: where xle.application_id = 206
7648: and xle.entity_id = xlee.entity_id
7649: and xlee.source_id_int_1 = p_loan_id
7650: and xle.budgetary_control_flag = 'Y'

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

7760: ELSIF p_activity = 'LNS_SUBMITTED_DISB_CANCEL' THEN
7761: l_event_type_code := 'SUBMITTED_DISB_CANCELLED';
7762: END IF;
7763:
7764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
7765:
7766: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
7767: ,p_disb_header_id => p_disb_header_id
7768: ,p_loan_amount_adj_id => -1

Line 7766: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

7762: END IF;
7763:
7764: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
7765:
7766: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
7767: ,p_disb_header_id => p_disb_header_id
7768: ,p_loan_amount_adj_id => -1
7769: ,p_event_type_code => l_event_type_code
7770: ,p_event_date => l_PAYMENT_REQUEST_DATE

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

7800: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updated event_id '||l_event_id||' succesfully for '||SQL%ROWCOUNT||' rows');
7801:
7802: if l_funds_reserved_flag = 'Y' then
7803:
7804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
7806: values (l_event_id, 'FAIL');
7807:
7808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);

Line 7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)

7801:
7802: if l_funds_reserved_flag = 'Y' then
7803:
7804: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'inserting into PSA_BC_XLA_EVENTS_GT - event => ' || l_event_id);
7805: insert into PSA_BC_XLA_EVENTS_GT (event_id, result_code)
7806: values (l_event_id, 'FAIL');
7807:
7808: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling PSA_BC_XLA_PUB.Budgetary_Control ' || l_event_id);
7809: -- always pass P_BC_MODE = reserve as per shaniqua williams

Line 9113: FROM lns_distributions ldist, xla_events evnt

9109:
9110: -- Retrieve the loans's sla event and its status of drafted accruals
9111: CURSOR cur_get_draft_events(c_loan_id NUMBER) IS
9112: SELECT distinct ldist.event_id, evnt.event_status_code
9113: FROM lns_distributions ldist, xla_events evnt
9114: WHERE ldist.event_id = evnt.event_id
9115: AND ldist.loan_id = C_LOAN_ID
9116: AND ldist.activity = 'INTEREST_ACCRUAL'
9117: AND ldist.distribution_type = 'ACCRUAL'

Line 9254: LNS_XLA_EVENTS.delete_event(p_loan_id => P_loan_id

9250:
9251: RAISE FND_API.G_EXC_ERROR;
9252: ELSE
9253: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Deleting the event_id '||l_exist_event_id);
9254: LNS_XLA_EVENTS.delete_event(p_loan_id => P_loan_id
9255: ,p_disb_header_id => -1
9256: ,p_loan_amount_adj_id => -1
9257: ,p_loan_line_id => -1
9258: ,p_event_id => l_exist_event_id

Line 9285: (SELECT 'X' FROM xla_events evnt

9281: AND ldist.activity = 'INTEREST_ACCRUAL'
9282: AND ldist.distribution_type = 'ACCRUAL'
9283: AND ldist.accrual_completed_flag <> 'Y'
9284: AND NOT EXISTS
9285: (SELECT 'X' FROM xla_events evnt
9286: WHERE evnt.event_id = ldist.event_id
9287: AND evnt.event_status_code in ('P', 'R'));
9288:
9289:

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

9316:
9317: IF (p_accounting_mode = 'FINAL') THEN
9318:
9319: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Generating Accrual Event');
9320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
9321:
9322: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
9323: ,p_disb_header_id => -1
9324: ,p_loan_amount_adj_id => -1

Line 9322: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id

9318:
9319: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Generating Accrual Event');
9320: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling LNS_XLA_EVENTS.create_event...');
9321:
9322: LNS_XLA_EVENTS.create_event(p_loan_id => p_loan_id
9323: ,p_disb_header_id => -1
9324: ,p_loan_amount_adj_id => -1
9325: ,p_event_type_code => 'LOAN_ACCRUAL'
9326: ,p_event_date => p_accrual_date