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 LNS_UTILITY_PUB

Line 130: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR LNS_UTILITY_PUB.IS_ENCUM_FIN_ENABLED = 'Y') then

126: fetch c_disbursements into l_disbursement_id;
127: close c_disbursements;
128: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_disbusement_id ' || l_disbursement_id);
129:
130: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR LNS_UTILITY_PUB.IS_ENCUM_FIN_ENABLED = 'Y') then
131:
132: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Invoking LNS_DISTRIBUTIONS_PUB.generateCancelDistributions...');
133: LNS_DISTRIBUTIONS_PUB.generateCancelDistributions(p_api_version => 1
134: ,p_init_msg_list => 'F'

Line 362: lns_utility_pub.validate_any_id(p_api_version => 1.0

358: IF p_loan_amount_adj_id IS NULL THEN
359: -- Retrieve the Pending Loan Amount Adjustment Id of the loan
360: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Retrieve the pending loan_amount_adj_id based on the input loan_id');
361:
362: lns_utility_pub.validate_any_id(p_api_version => 1.0
363: ,p_init_msg_list => 'F'
364: ,x_msg_count => l_msg_count
365: ,x_msg_data => l_msg_data
366: ,x_return_status => l_return_status

Line 392: lns_utility_pub.validate_any_id(p_api_version => 1.0

388:
389: ELSE -- ELSE IF p_loan_amount_adj_id IS NOT NULL
390: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Validating input p_loan_amount_adj_id');
391:
392: lns_utility_pub.validate_any_id(p_api_version => 1.0
393: ,p_init_msg_list => 'F'
394: ,x_msg_count => l_msg_count
395: ,x_msg_data => l_msg_data
396: ,x_return_status => l_return_status

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

591: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));
592: RAISE FND_API.G_EXC_ERROR;
593: END IF;
594:
595: if ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' OR lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') AND l_disbursement_id IS NOT NULL) then
596:
597: -- check if budget event exists
598: -- find if budgetary event already exists, if not, create the event
599: open c_budget_event(p_loan_id);

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

789: THEN
790: COMMIT WORK;
791: END IF;
792:
793: end if; -- no budgetary control-- end if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then
794:
795: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
796:
797: EXCEPTION

Line 921: ,lns_utility_pub.creation_date

917: ,p_distributions_tbl(k).distribution_percent
918: ,p_distributions_tbl(k).distribution_amount
919: ,p_distributions_tbl(k).distribution_type
920: ,p_distributions_tbl(k).event_id
921: ,lns_utility_pub.creation_date
922: ,lns_utility_pub.created_by
923: ,lns_utility_pub.last_update_date
924: ,lns_utility_pub.last_updated_by
925: ,1

Line 922: ,lns_utility_pub.created_by

918: ,p_distributions_tbl(k).distribution_amount
919: ,p_distributions_tbl(k).distribution_type
920: ,p_distributions_tbl(k).event_id
921: ,lns_utility_pub.creation_date
922: ,lns_utility_pub.created_by
923: ,lns_utility_pub.last_update_date
924: ,lns_utility_pub.last_updated_by
925: ,1
926: ,p_distributions_tbl(k).disb_header_id

Line 923: ,lns_utility_pub.last_update_date

919: ,p_distributions_tbl(k).distribution_type
920: ,p_distributions_tbl(k).event_id
921: ,lns_utility_pub.creation_date
922: ,lns_utility_pub.created_by
923: ,lns_utility_pub.last_update_date
924: ,lns_utility_pub.last_updated_by
925: ,1
926: ,p_distributions_tbl(k).disb_header_id
927: ,p_distributions_tbl(k).loan_amount_adj_id

Line 924: ,lns_utility_pub.last_updated_by

920: ,p_distributions_tbl(k).event_id
921: ,lns_utility_pub.creation_date
922: ,lns_utility_pub.created_by
923: ,lns_utility_pub.last_update_date
924: ,lns_utility_pub.last_updated_by
925: ,1
926: ,p_distributions_tbl(k).disb_header_id
927: ,p_distributions_tbl(k).loan_amount_adj_id
928: ,p_distributions_tbl(k).loan_line_id

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

2812: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency = ' || l_currency_code);
2813: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency2 = ' || l_ledger_details.CURRENCY_CODE);
2814: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'amount = ' || l_distribution_rec.distribution_amount);
2815:
2816: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_utility_pub.convertAmount...');
2817: l_return := lns_utility_pub.convertAmount(p_from_amount => l_distribution_rec.distribution_amount
2818: ,p_from_currency => l_currency_code -- loan currency
2819: ,p_to_currency => l_ledger_details.CURRENCY_CODE -- set of books currency
2820: ,p_exchange_type => l_exchange_rate_type

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

2813: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'currency2 = ' || l_ledger_details.CURRENCY_CODE);
2814: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'amount = ' || l_distribution_rec.distribution_amount);
2815:
2816: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling lns_utility_pub.convertAmount...');
2817: l_return := lns_utility_pub.convertAmount(p_from_amount => l_distribution_rec.distribution_amount
2818: ,p_from_currency => l_currency_code -- loan currency
2819: ,p_to_currency => l_ledger_details.CURRENCY_CODE -- set of books currency
2820: ,p_exchange_type => l_exchange_rate_type
2821: ,p_exchange_date => l_exchange_date

Line 3947: if ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') and (lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'N')) then

3943:
3944: l_distributions_count := l_distributions.count;
3945: i := l_distributions.count;
3946:
3947: if ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') and (lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'N')) then
3948:
3949: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'checking for existing subsidy rows');
3950: open c_subsidy_rows_exist(p_loan_id);
3951: fetch c_subsidy_rows_exist into l_subsidy_exists;

Line 5779: lns_utility_pub.validate_any_id(p_api_version => 1.0

5775: IF p_loan_amount_adj_id IS NULL THEN
5776: -- Retrieve the Pending Loan Amount Adjustment Id of the loan
5777: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Retrieve the pending loan_amount_adj_id based on the input loan_id');
5778:
5779: lns_utility_pub.validate_any_id(p_api_version => 1.0
5780: ,p_init_msg_list => p_init_msg_list
5781: ,x_msg_count => l_msg_count
5782: ,x_msg_data => l_msg_data
5783: ,x_return_status => l_return_status

Line 5821: lns_utility_pub.validate_any_id(p_api_version => 1.0

5817:
5818: ELSE -- ELSE OF p_loan_amount_adj_id IS NULL
5819: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Validating input p_loan_amount_adj_id');
5820:
5821: lns_utility_pub.validate_any_id(p_api_version => 1.0
5822: ,p_init_msg_list => p_init_msg_list
5823: ,x_msg_count => l_msg_count
5824: ,x_msg_data => l_msg_data
5825: ,x_return_status => l_return_status

Line 6054: lns_utility_pub.validate_any_id(p_api_version => 1.0

6050: IF p_loan_amount_adj_id IS NULL THEN
6051: -- Retrieve the Pending Loan Amount Adjustment Id of the loan
6052: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Retrieve the pending loan_amount_adj_id based on the input loan_id');
6053:
6054: lns_utility_pub.validate_any_id(p_api_version => 1.0
6055: ,p_init_msg_list => p_init_msg_list
6056: ,x_msg_count => l_msg_count
6057: ,x_msg_data => l_msg_data
6058: ,x_return_status => l_return_status

Line 6093: lns_utility_pub.validate_any_id(p_api_version => 1.0

6089:
6090: ELSE -- ELSE OF p_loan_amount_adj_id IS NULL
6091: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Validating input p_loan_amount_adj_id');
6092:
6093: lns_utility_pub.validate_any_id(p_api_version => 1.0
6094: ,p_init_msg_list => p_init_msg_list
6095: ,x_msg_count => l_msg_count
6096: ,x_msg_data => l_msg_data
6097: ,x_return_status => l_return_status

Line 6142: if ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' or lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') AND l_loan_amount_adj_id IS NOT NULL) then

6138: END IF;
6139:
6140: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_event_type = ' || l_event_type);
6141:
6142: if ((lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' or lns_utility_pub.IS_ENCUM_FIN_ENABLED = 'Y') AND l_loan_amount_adj_id IS NOT NULL) then
6143:
6144: -- check if budget event exists
6145: -- find if budgetary event already exists, if not, create the event
6146: open c_budget_event(l_loan_amount_adj_id, l_event_type);

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

6306: THEN
6307: COMMIT WORK;
6308: END IF;
6309:
6310: end if; -- no budgetary control-- end if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y' AND l_disbursement_id IS NOT NULL) then
6311:
6312: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - END');
6313:
6314: EXCEPTION

Line 7426: lns_utility_pub.validate_any_id(p_api_version => 1.0

7422: l_run_clear_org_amt:= 0;
7423: l_run_clear_sub_amt:= 0;
7424: l_ledger_details := lns_distributions_pub.getLedgerDetails;
7425:
7426: lns_utility_pub.validate_any_id(p_api_version => 1.0
7427: ,p_init_msg_list => p_init_msg_list
7428: ,x_msg_count => l_msg_count
7429: ,x_msg_data => l_msg_data
7430: ,x_return_status => l_return_status

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

7719: close c_disbursements;
7720: logMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, l_api_name || 'l_disbusement_id ' || l_disbursement_id);
7721: */
7722:
7723: if (lns_utility_pub.IS_FED_FIN_ENABLED = 'Y') then
7724:
7725: -- create disbursement distribution records in lns_distributions for Disbursement Submission
7726: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Calling create_DisbursementDistribs...');
7727: LNS_DISTRIBUTIONS_PUB.create_DisbursementDistribs(