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_FEE_ENGINE dependencies on LNS_UTILITY_PUB

Line 2322: lns_utility_pub.validate_any_id(p_api_version => 1.0

2318: open c_precision(p_loan_id);
2319: fetch c_precision into l_precision;
2320: close c_precision;
2321:
2322: lns_utility_pub.validate_any_id(p_api_version => 1.0
2323: ,p_init_msg_list => p_init_msg_list
2324: ,x_msg_count => l_msg_count
2325: ,x_msg_data => l_msg_data
2326: ,x_return_status => l_return_status

Line 2381: lns_utility_pub.validate_any_id(p_api_version => 1.0

2377: RAISE FND_API.G_EXC_ERROR;
2378: end if;
2379:
2380: if p_fees_tbl(k).FEE_ID is not null then
2381: lns_utility_pub.validate_any_id(p_api_version => 1.0
2382: ,p_init_msg_list => p_init_msg_list
2383: ,x_msg_count => l_msg_count
2384: ,x_msg_data => l_msg_data
2385: ,x_return_status => l_return_status

Line 2427: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by

2423: ,P_ACTIVE_FLAG => p_fees_tbl(k).ACTIVE_FLAG --'Y'
2424: ,P_BILLED_FLAG => p_fees_tbl(k).BILLED_FLAG --'N'
2425: ,P_FEE_WAIVABLE_FLAG => p_fees_tbl(k).FEE_WAIVABLE_FLAG
2426: ,P_WAIVED_AMOUNT => null
2427: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2428: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2429: ,P_LAST_UPDATE_LOGIN => null
2430: ,P_PROGRAM_ID => null
2431: ,P_REQUEST_ID => null

Line 2428: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date

2424: ,P_BILLED_FLAG => p_fees_tbl(k).BILLED_FLAG --'N'
2425: ,P_FEE_WAIVABLE_FLAG => p_fees_tbl(k).FEE_WAIVABLE_FLAG
2426: ,P_WAIVED_AMOUNT => null
2427: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2428: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2429: ,P_LAST_UPDATE_LOGIN => null
2430: ,P_PROGRAM_ID => null
2431: ,P_REQUEST_ID => null
2432: ,P_OBJECT_VERSION_NUMBER => 1

Line 2543: lns_utility_pub.validate_any_id(p_api_version => 1.0

2539: -- ---------------------------------------------------------------------
2540: -- Api body
2541: -- ---------------------------------------------------------------------
2542: -- initialize any variables here
2543: lns_utility_pub.validate_any_id(p_api_version => 1.0
2544: ,p_init_msg_list => p_init_msg_list
2545: ,x_msg_count => l_msg_count
2546: ,x_msg_data => l_msg_data
2547: ,x_return_status => l_return_status

Line 2604: lns_utility_pub.validate_any_id(p_api_version => 1.0

2600: RAISE FND_API.G_EXC_ERROR;
2601: end if;
2602:
2603: if p_fees_tbl(k).FEE_ID is not null then
2604: lns_utility_pub.validate_any_id(p_api_version => 1.0
2605: ,p_init_msg_list => p_init_msg_list
2606: ,x_msg_count => l_msg_count
2607: ,x_msg_data => l_msg_data
2608: ,x_return_status => l_return_status

Line 2641: ,P_CREATED_BY => lns_utility_pub.created_by

2637: ,P_ACTIVE_FLAG => 'Y'
2638: ,P_BILLED_FLAG => 'N'
2639: ,P_FEE_WAIVABLE_FLAG => p_fees_tbl(k).FEE_WAIVABLE_FLAG
2640: ,P_WAIVED_AMOUNT => null
2641: ,P_CREATED_BY => lns_utility_pub.created_by
2642: ,P_CREATION_DATE => lns_utility_pub.creation_date
2643: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2644: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2645: ,P_LAST_UPDATE_LOGIN => null

Line 2642: ,P_CREATION_DATE => lns_utility_pub.creation_date

2638: ,P_BILLED_FLAG => 'N'
2639: ,P_FEE_WAIVABLE_FLAG => p_fees_tbl(k).FEE_WAIVABLE_FLAG
2640: ,P_WAIVED_AMOUNT => null
2641: ,P_CREATED_BY => lns_utility_pub.created_by
2642: ,P_CREATION_DATE => lns_utility_pub.creation_date
2643: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2644: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2645: ,P_LAST_UPDATE_LOGIN => null
2646: ,P_PROGRAM_ID => null

Line 2643: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by

2639: ,P_FEE_WAIVABLE_FLAG => p_fees_tbl(k).FEE_WAIVABLE_FLAG
2640: ,P_WAIVED_AMOUNT => null
2641: ,P_CREATED_BY => lns_utility_pub.created_by
2642: ,P_CREATION_DATE => lns_utility_pub.creation_date
2643: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2644: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2645: ,P_LAST_UPDATE_LOGIN => null
2646: ,P_PROGRAM_ID => null
2647: ,P_REQUEST_ID => null

Line 2644: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date

2640: ,P_WAIVED_AMOUNT => null
2641: ,P_CREATED_BY => lns_utility_pub.created_by
2642: ,P_CREATION_DATE => lns_utility_pub.creation_date
2643: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
2644: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
2645: ,P_LAST_UPDATE_LOGIN => null
2646: ,P_PROGRAM_ID => null
2647: ,P_REQUEST_ID => null
2648: ,P_OBJECT_VERSION_NUMBER => 1

Line 3069: lns_utility_pub.validate_any_id(p_api_version => 1.0

3065:
3066: -- ---------------------------------------------------------------------
3067: -- Api body
3068: -- ---------------------------------------------------------------------
3069: lns_utility_pub.validate_any_id(p_api_version => 1.0
3070: ,p_init_msg_list => 'T'
3071: ,x_msg_count => l_msg_count
3072: ,x_msg_data => l_msg_data
3073: ,x_return_status => l_return_status

Line 3086: lns_utility_pub.validate_any_id(p_api_version => 1.0

3082: FND_MSG_PUB.ADD;
3083: RAISE FND_API.G_EXC_ERROR;
3084: end if;
3085:
3086: lns_utility_pub.validate_any_id(p_api_version => 1.0
3087: ,p_init_msg_list => 'T'
3088: ,x_msg_count => l_msg_count
3089: ,x_msg_data => l_msg_data
3090: ,x_return_status => l_return_status

Line 3133: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by

3129: ,P_ACTIVE_FLAG => null
3130: ,P_BILLED_FLAG => null
3131: ,P_FEE_WAIVABLE_FLAG => null
3132: ,P_WAIVED_AMOUNT => p_waive_amount + l_waived_amount
3133: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
3134: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
3135: ,P_LAST_UPDATE_LOGIN => lns_utility_pub.last_update_login
3136: ,P_PROGRAM_ID => null
3137: ,P_REQUEST_ID => null

Line 3134: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date

3130: ,P_BILLED_FLAG => null
3131: ,P_FEE_WAIVABLE_FLAG => null
3132: ,P_WAIVED_AMOUNT => p_waive_amount + l_waived_amount
3133: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
3134: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
3135: ,P_LAST_UPDATE_LOGIN => lns_utility_pub.last_update_login
3136: ,P_PROGRAM_ID => null
3137: ,P_REQUEST_ID => null
3138: ,P_OBJECT_VERSION_NUMBER => null

Line 3135: ,P_LAST_UPDATE_LOGIN => lns_utility_pub.last_update_login

3131: ,P_FEE_WAIVABLE_FLAG => null
3132: ,P_WAIVED_AMOUNT => p_waive_amount + l_waived_amount
3133: ,P_LAST_UPDATED_BY => lns_utility_pub.last_updated_by
3134: ,P_LAST_UPDATE_DATE => lns_utility_pub.last_update_date
3135: ,P_LAST_UPDATE_LOGIN => lns_utility_pub.last_update_login
3136: ,P_PROGRAM_ID => null
3137: ,P_REQUEST_ID => null
3138: ,P_OBJECT_VERSION_NUMBER => null
3139: ,P_DISB_HEADER_ID => null

Line 4013: ,last_updated_by = LNS_UTILITY_PUB.last_updated_by

4009: UPDATE lns_fee_assignments
4010: SET begin_installment_number = l_inst_no
4011: ,end_installment_number = l_inst_no
4012: ,object_version_number = object_version_number + 1
4013: ,last_updated_by = LNS_UTILITY_PUB.last_updated_by
4014: ,last_update_date = LNS_UTILITY_PUB.last_update_date
4015: ,last_update_login = LNS_UTILITY_PUB.last_update_login
4016: WHERE disb_header_id =p_disb_header_id;
4017:

Line 4014: ,last_update_date = LNS_UTILITY_PUB.last_update_date

4010: SET begin_installment_number = l_inst_no
4011: ,end_installment_number = l_inst_no
4012: ,object_version_number = object_version_number + 1
4013: ,last_updated_by = LNS_UTILITY_PUB.last_updated_by
4014: ,last_update_date = LNS_UTILITY_PUB.last_update_date
4015: ,last_update_login = LNS_UTILITY_PUB.last_update_login
4016: WHERE disb_header_id =p_disb_header_id;
4017:
4018: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updated feeAssignments '||SQL%ROWCOUNT);

Line 4015: ,last_update_login = LNS_UTILITY_PUB.last_update_login

4011: ,end_installment_number = l_inst_no
4012: ,object_version_number = object_version_number + 1
4013: ,last_updated_by = LNS_UTILITY_PUB.last_updated_by
4014: ,last_update_date = LNS_UTILITY_PUB.last_update_date
4015: ,last_update_login = LNS_UTILITY_PUB.last_update_login
4016: WHERE disb_header_id =p_disb_header_id;
4017:
4018: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'Updated feeAssignments '||SQL%ROWCOUNT);
4019: