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_FUNDING_PUB dependencies on LNS_DISTRIBUTIONS

Line 1024: delete from lns_distributions where disb_header_id = P_DISB_HEADER_ID;

1020: -- deteting conditions assignments and fees
1021: LNS_FEE_ASSIGNMENT_PUB.delete_DISB_FEE_ASSIGNMENT(P_DISB_HEADER_ID);
1022: LNS_COND_ASSIGNMENT_PUB.delete_DISB_COND_ASSIGNMENT(P_DISB_HEADER_ID);
1023:
1024: delete from lns_distributions where disb_header_id = P_DISB_HEADER_ID;
1025:
1026: -- calling table handler api
1027: LNS_DISB_HEADERS_PKG.Delete_Row(P_DISB_HEADER_ID);
1028:

Line 3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;

3812: l_precision_queried number;
3813: l_phase varchar2(30);
3814:
3815: l_rejections AP_IMPORT_INVOICES_PKG.rejection_tab_type;
3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;
3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;
3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;
3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;
3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;

Line 3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;

3813: l_phase varchar2(30);
3814:
3815: l_rejections AP_IMPORT_INVOICES_PKG.rejection_tab_type;
3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;
3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;
3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;
3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;
3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;
3821: l_budgetary_control varchar2(1);

Line 3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;

3814:
3815: l_rejections AP_IMPORT_INVOICES_PKG.rejection_tab_type;
3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;
3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;
3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;
3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;
3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;
3821: l_budgetary_control varchar2(1);
3822: l_expenditure_organization_id number;

Line 3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;

3815: l_rejections AP_IMPORT_INVOICES_PKG.rejection_tab_type;
3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;
3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;
3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;
3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;
3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;
3821: l_budgetary_control varchar2(1);
3822: l_expenditure_organization_id number;
3823: l_project_accounting_context varchar2(1);

Line 3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;

3816: l_project_id LNS_DISTRIBUTIONS.project_id%TYPE;
3817: l_task_id LNS_DISTRIBUTIONS.task_id%TYPE;
3818: l_award_id LNS_DISTRIBUTIONS.award_id%TYPE;
3819: l_expenditure_type LNS_DISTRIBUTIONS.expenditure_type%TYPE;
3820: l_expenditure_item_date LNS_DISTRIBUTIONS.expenditure_item_date%TYPE;
3821: l_budgetary_control varchar2(1);
3822: l_expenditure_organization_id number;
3823: l_project_accounting_context varchar2(1);
3824:

Line 3885: from lns_distributions

3881: -- query liability distribution info - invoice header
3882: CURSOR liability_distr_cur(P_LOAN_ID number) IS
3883: select CODE_COMBINATION_ID,
3884: DISTRIBUTION_PERCENT
3885: from lns_distributions
3886: where LOAN_ID = P_LOAN_ID and
3887: account_type = 'CR' and
3888: account_name = 'LOAN_LIABILITY' and
3889: line_type = 'PRIN';

Line 3895: from lns_distributions

3891: -- query clearing distribution info - invoice lines
3892: CURSOR clearing_distr_cur(P_LOAN_ID number, P_DISB_HEADER_ID number) IS
3893: select CODE_COMBINATION_ID,
3894: DISTRIBUTION_PERCENT
3895: from lns_distributions
3896: where LOAN_ID = P_LOAN_ID and
3897: account_name = 'LOAN_PAYABLE' and
3898: line_type = 'CLEAR' and
3899: disb_header_id = P_DISB_HEADER_ID;

Line 3941: -- get projects details from LNS_DISTRIBUTIONS

3937: from ap_invoices_all
3938: where invoice_num = P_INVOICE_NUM and
3939: party_id = P_PARTY_ID;
3940:
3941: -- get projects details from LNS_DISTRIBUTIONS
3942: CURSOR get_project_details(P_LOAN_ID NUMBER) IS
3943: select project_id, task_id, award_id, expenditure_type, expenditure_item_date
3944: from LNS_DISTRIBUTIONS dist
3945: where dist.loan_id = P_LOAN_ID

Line 3944: from LNS_DISTRIBUTIONS dist

3940:
3941: -- get projects details from LNS_DISTRIBUTIONS
3942: CURSOR get_project_details(P_LOAN_ID NUMBER) IS
3943: select project_id, task_id, award_id, expenditure_type, expenditure_item_date
3944: from LNS_DISTRIBUTIONS dist
3945: where dist.loan_id = P_LOAN_ID
3946: and line_type = 'CLEAR'
3947: and account_name = 'LOAN_PAYABLE'
3948: and account_type = 'CR'

Line 4070: -- create disbursement distribution records in lns_distributions

4066: l_invoice_number := l_loan_number || '-' || l_phase || '-' ||
4067: l_DISB_HEADER_REC.DISBURSEMENT_NUMBER || '-' ||
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,

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 6867: from lns_distributions

6863: where DISB_LINE_ID = P_DISB_LINE_ID;
6864:
6865: CURSOR submitDisb_exist_cur(c_disb_header_id NUMBER) IS
6866: select count(1)
6867: from lns_distributions
6868: where disb_header_id = c_disb_header_id
6869: and activity = 'LNS_SUBMIT_DISBURSEMENT';
6870: /*
6871: and NOT EXISTS (select 'X' from lns_distributions

Line 6871: and NOT EXISTS (select 'X' from lns_distributions

6867: from lns_distributions
6868: where disb_header_id = c_disb_header_id
6869: and activity = 'LNS_SUBMIT_DISBURSEMENT';
6870: /*
6871: and NOT EXISTS (select 'X' from lns_distributions
6872: where disb_header_id = c_disb_header_id
6873: and activity = 'LNS_SUBMITTED_DISB_CANCEL'
6874: );
6875: */

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