APPS.LNS_DISTRIBUTIONS_PUB dependencies on LNS_UTILITY_PUB

Line 122: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') then

118: fetch c_disbursements into l_disbursement_id;
119: close c_disbursements;
120: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_disbusement_id ' || l_disbursement_id);
121:
122: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') then
123:
124: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'federal enabled');
125: open c_budget_req(p_loan_id);
126: fetch c_budget_req into l_budget_req_approval, l_funds_reserved_flag, l_gl_date;

Line 480: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then

476: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
477: RAISE FND_API.G_EXC_ERROR;
478: END IF;
479:
480: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then
481:
482: -- check if budget event exists
483: -- find if budgetary event already exists, if not, create the event
484: open c_budget_event(p_loan_id, l_disbursement_id);

Line 630: end if; -- no budgetary control-- end if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then

626: THEN
627: COMMIT WORK;
628: END IF;
629:
630: end if; -- no budgetary control-- end if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then
631:
632: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
633:
634: EXCEPTION

Line 734: ,lns_utility_pub.creation_date

730: ,p_distributions_tbl(k).distribution_percent
731: ,p_distributions_tbl(k).distribution_amount
732: ,p_distributions_tbl(k).distribution_type
733: ,p_distributions_tbl(k).event_id
734: ,lns_utility_pub.creation_date
735: ,lns_utility_pub.created_by
736: ,lns_utility_pub.last_update_date
737: ,lns_utility_pub.last_updated_by
738: ,1

Line 735: ,lns_utility_pub.created_by

731: ,p_distributions_tbl(k).distribution_amount
732: ,p_distributions_tbl(k).distribution_type
733: ,p_distributions_tbl(k).event_id
734: ,lns_utility_pub.creation_date
735: ,lns_utility_pub.created_by
736: ,lns_utility_pub.last_update_date
737: ,lns_utility_pub.last_updated_by
738: ,1
739: ,p_distributions_tbl(k).disb_header_id);

Line 736: ,lns_utility_pub.last_update_date

732: ,p_distributions_tbl(k).distribution_type
733: ,p_distributions_tbl(k).event_id
734: ,lns_utility_pub.creation_date
735: ,lns_utility_pub.created_by
736: ,lns_utility_pub.last_update_date
737: ,lns_utility_pub.last_updated_by
738: ,1
739: ,p_distributions_tbl(k).disb_header_id);
740:

Line 737: ,lns_utility_pub.last_updated_by

733: ,p_distributions_tbl(k).event_id
734: ,lns_utility_pub.creation_date
735: ,lns_utility_pub.created_by
736: ,lns_utility_pub.last_update_date
737: ,lns_utility_pub.last_updated_by
738: ,1
739: ,p_distributions_tbl(k).disb_header_id);
740:
741: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, '****************************************** ');

Line 2210: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_utility_pub.convertAmount...');

2206: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency = ' || l_currency_code);
2207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency2 = ' || l_ledger_details.CURRENCY_CODE);
2208: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'amount = ' || l_distribution_rec.distribution_amount);
2209:
2210: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_utility_pub.convertAmount...');
2211: l_return := lns_utility_pub.convertAmount(p_from_amount => l_distribution_rec.distribution_amount
2212: ,p_from_currency => l_currency_code -- loan currency
2213: ,p_to_currency => l_ledger_details.CURRENCY_CODE -- set of books currency
2214: ,p_exchange_type => l_exchange_rate_type

Line 2211: l_return := lns_utility_pub.convertAmount(p_from_amount => l_distribution_rec.distribution_amount

2207: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency2 = ' || l_ledger_details.CURRENCY_CODE);
2208: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'amount = ' || l_distribution_rec.distribution_amount);
2209:
2210: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_utility_pub.convertAmount...');
2211: l_return := lns_utility_pub.convertAmount(p_from_amount => l_distribution_rec.distribution_amount
2212: ,p_from_currency => l_currency_code -- loan currency
2213: ,p_to_currency => l_ledger_details.CURRENCY_CODE -- set of books currency
2214: ,p_exchange_type => l_exchange_rate_type
2215: ,p_exchange_date => l_exchange_date

Line 3131: if lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' then

3127:
3128: l_distributions_count := l_distributions.count;
3129: i := l_distributions.count;
3130:
3131: if lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' then
3132:
3133: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking for existing subsidy rows');
3134: open c_subsidy_rows_exist(p_loan_id);
3135: fetch c_subsidy_rows_exist into l_subsidy_exists;