DBA Data[Home] [Help]

APPS.LNS_FUNDING_PUB dependencies on LNS_DISTRIBUTIONS_PUB

Line 4072: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(

4068: l_DISB_LINE_REC.DISB_LINE_NUMBER;
4069:
4070: -- create disbursement distribution records in lns_distributions
4071: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling create_DisbursementDistribs...');
4072: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(
4073: p_api_version => 1.0,
4074: p_init_msg_list => FND_API.G_FALSE,
4075: p_commit => FND_API.G_FALSE,
4076: p_loan_id => l_DISB_HEADER_REC.LOAN_ID,

Line 4085: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs failed');

4081: x_msg_data => l_msg_data);
4082:
4083: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Return status: ' || l_return_status);
4084: IF l_return_status <> 'S' THEN
4085: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs failed');
4086: RAISE FND_API.G_EXC_ERROR;
4087: END IF;
4088:
4089: -- query liability distribution info

Line 5207: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Calling lns_distributions_pub.budgetary_control...');

5203: -- After introducing Term Disbursment, we can cancel 1st disbursement and we can
5204: -- submit any disbursement(Not only 1st disb) at first time
5205: --and l_disb_number = 1
5206:
5207: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Calling lns_distributions_pub.budgetary_control...');
5208:
5209: BEGIN
5210: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE
5211: ,p_commit => FND_API.G_FALSE

Line 5210: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE

5206:
5207: LogMessage(FND_LOG.LEVEL_PROCEDURE, 'Calling lns_distributions_pub.budgetary_control...');
5208:
5209: BEGIN
5210: lns_distributions_pub.budgetary_control(p_init_msg_list => FND_API.G_FALSE
5211: ,p_commit => FND_API.G_FALSE
5212: ,p_loan_id => l_loan_id
5213: ,p_budgetary_control_mode => 'R'
5214: ,x_budgetary_status_code => l_status_code

Line 5220: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_distributions_pub.budgetary_control throws exception');

5216: ,x_msg_count => l_msg_count
5217: ,x_msg_data => l_msg_data);
5218: EXCEPTION
5219: WHEN OTHERS THEN
5220: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'lns_distributions_pub.budgetary_control throws exception');
5221: RAISE FND_API.G_EXC_ERROR;
5222: END;
5223:
5224: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'The l_status_code is '||l_status_code);

Line 5226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to lns_distributions_pub.budgetary_control failed');

5222: END;
5223:
5224: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'The l_status_code is '||l_status_code);
5225: IF l_return_status <> 'S' THEN
5226: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to lns_distributions_pub.budgetary_control failed');
5227: RAISE FND_API.G_EXC_ERROR;
5228: ELSE
5229: -- Bug#9964875
5230: IF (l_status_code = 'FAIL' or l_status_code = 'PARTIAL' or l_status_code = 'XLA_ERROR') THEN

Line 5376: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');

5372:
5373: -- Only for Federal Direct Loans whose budget is reserved
5374: -- Dont submit_disbursement_bc if the disbursement is failed
5375: IF ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') AND (l_funds_reserved_flag = 'Y') AND (l_DISB_HEADER_REC.STATUS <> 'FUNDING_ERROR')) THEN
5376: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');
5377: -- Submit budgetary disbursement distributions if needed
5378: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE
5379: ,p_commit => FND_API.G_FALSE
5380: ,p_loan_id => l_loan_header_rec.LOAN_ID

Line 5378: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE

5374: -- Dont submit_disbursement_bc if the disbursement is failed
5375: IF ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') AND (l_funds_reserved_flag = 'Y') AND (l_DISB_HEADER_REC.STATUS <> 'FUNDING_ERROR')) THEN
5376: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');
5377: -- Submit budgetary disbursement distributions if needed
5378: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE
5379: ,p_commit => FND_API.G_FALSE
5380: ,p_loan_id => l_loan_header_rec.LOAN_ID
5381: ,p_disb_header_id => l_DISB_HEADER_REC.DISB_HEADER_ID
5382: ,p_activity => 'LNS_SUBMIT_DISBURSEMENT'

Line 5390: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMIT_DISBURSEMENT');

5386:
5387: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
5388: IF l_return_status <> 'S' THEN
5389: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
5390: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMIT_DISBURSEMENT');
5391: FND_MSG_PUB.ADD;
5392: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
5393: RAISE FND_API.G_EXC_ERROR;
5394: END IF;

Line 5507: l_event_table lns_distributions_pub.acc_event_tbl;

5503: l_DISB_HEADER_REC LNS_FUNDING_PUB.LNS_DISB_HEADERS_REC;
5504: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
5505: l_term_rec LNS_TERMS_PUB.loan_term_rec_type;
5506: l_loan_details LNS_FINANCIALS.LOAN_DETAILS_REC;
5507: l_event_table lns_distributions_pub.acc_event_tbl;
5508: l_funded_lines_count number;
5509: l_dates_shifted_flag varchar2(1) := 'N';
5510: isDisbDateChange varchar2(1) := 'N';
5511: hdrIdCnt NUMBER;

Line 5825: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling to LNS_DISTRIBUTIONS_PUB.create_event...');

5821: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to lns_fee_engine.processDisbursementFees failed');
5822: -- RAISE FND_API.G_EXC_ERROR;
5823: END IF;
5824: */
5825: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling to LNS_DISTRIBUTIONS_PUB.create_event...');
5826: -- creating accounting event
5827: l_event_table(1).loan_id := l_loan_header_rec.loan_id;
5828: l_event_table(1).EVENT_TYPE_CODE := 'DISBURSEMENT_FUNDED';
5829: l_event_table(1).EVENT_DATE := l_DISB_LINE_REC.DISBURSEMENT_DATE;

Line 5833: LNS_DISTRIBUTIONS_PUB.create_event(

5829: l_event_table(1).EVENT_DATE := l_DISB_LINE_REC.DISBURSEMENT_DATE;
5830: l_event_table(1).EVENT_STATUS := 'U';
5831: l_event_table(1).DISB_HEADER_ID := l_DISB_HEADER_REC.DISB_HEADER_ID;
5832:
5833: LNS_DISTRIBUTIONS_PUB.create_event(
5834: p_acc_event_tbl => l_event_table,
5835: p_init_msg_list => FND_API.G_TRUE,
5836: p_commit => FND_API.G_FALSE,
5837: x_return_status => l_return_status,

Line 5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'return of LNS_DISTRIBUTIONS_PUB.create_event: ' || l_return_status);

5837: x_return_status => l_return_status,
5838: x_msg_count => l_msg_count,
5839: x_msg_data => l_msg_data);
5840:
5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'return of LNS_DISTRIBUTIONS_PUB.create_event: ' || l_return_status);
5842: IF l_return_status <> 'S' THEN
5843: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_DISTRIBUTIONS_PUB.create_event failed');
5844: -- RAISE FND_API.G_EXC_ERROR;
5845: END IF;

Line 5843: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_DISTRIBUTIONS_PUB.create_event failed');

5839: x_msg_data => l_msg_data);
5840:
5841: LogMessage(FND_LOG.LEVEL_STATEMENT, 'return of LNS_DISTRIBUTIONS_PUB.create_event: ' || l_return_status);
5842: IF l_return_status <> 'S' THEN
5843: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Call to LNS_DISTRIBUTIONS_PUB.create_event failed');
5844: -- RAISE FND_API.G_EXC_ERROR;
5845: END IF;
5846:
5847: end if;

Line 7067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');

7063:
7064: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_dist_count is '||l_dist_count);
7065:
7066: IF l_dist_count > 0 THEN
7067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');
7068: -- Submit budgetary disbursement distributions if needed
7069: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE
7070: ,p_commit => FND_API.G_FALSE
7071: ,p_loan_id => l_DISB_HEADER_REC.LOAN_ID

Line 7069: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE

7065:
7066: IF l_dist_count > 0 THEN
7067: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.submit_disbursement_bc');
7068: -- Submit budgetary disbursement distributions if needed
7069: lns_distributions_pub.submit_disbursement_bc(p_init_msg_list => FND_API.G_FALSE
7070: ,p_commit => FND_API.G_FALSE
7071: ,p_loan_id => l_DISB_HEADER_REC.LOAN_ID
7072: ,p_disb_header_id => l_DISB_HEADER_REC.DISB_HEADER_ID
7073: ,p_activity => 'LNS_SUBMITTED_DISB_CANCEL'

Line 7081: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMITTED_DISB_CANCEL');

7077:
7078: logMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
7079: IF l_return_status <> 'S' THEN
7080: FND_MESSAGE.SET_NAME('LNS', 'LNS_API_OTHERS_EXCEP');
7081: FND_MESSAGE.SET_TOKEN('ERROR' ,'Call to lns_distributions_pub.submit_disbursement_bc failed for acitivity = LNS_SUBMITTED_DISB_CANCEL');
7082: FND_MSG_PUB.ADD;
7083: logMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
7084: RAISE FND_API.G_EXC_ERROR;
7085: END IF;

Line 7194: l_event_table lns_distributions_pub.acc_event_tbl;

7190: l_submitted_disb_count number;
7191: l_current_phase varchar2(30);
7192:
7193: l_loan_header_rec LNS_LOAN_HEADER_PUB.loan_header_rec_type;
7194: l_event_table lns_distributions_pub.acc_event_tbl;
7195:
7196: /*-----------------------------------------------------------------------+
7197: | Cursor Declarations |
7198: +-----------------------------------------------------------------------*/

Line 7333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.cancel_disbursements');

7329: END IF;
7330:
7331: end if;
7332:
7333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.cancel_disbursements');
7334: -- Cancel budgetary disbursements if needed
7335: lns_distributions_pub.cancel_disbursements(p_init_msg_list => FND_API.G_FALSE
7336: ,p_commit => FND_API.G_FALSE
7337: ,p_loan_id => P_LOAN_ID

Line 7335: lns_distributions_pub.cancel_disbursements(p_init_msg_list => FND_API.G_FALSE

7331: end if;
7332:
7333: LogMessage(FND_LOG.LEVEL_STATEMENT, 'calling lns_distributions_pub.cancel_disbursements');
7334: -- Cancel budgetary disbursements if needed
7335: lns_distributions_pub.cancel_disbursements(p_init_msg_list => FND_API.G_FALSE
7336: ,p_commit => FND_API.G_FALSE
7337: ,p_loan_id => P_LOAN_ID
7338: ,X_RETURN_STATUS => l_return_status
7339: ,X_MSG_COUNT => l_msg_count