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 FND_FILE

Line 2898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing last installment ' || l_last_installment);

2894: if l_last_installment > 0 then
2895:
2896: -- first part is for TERM PHASE
2897: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - last installment ' || l_last_installment);
2898: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing last installment ' || l_last_installment);
2899: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - loan_id ' || p_loan_id);
2900: l_late_fee_structures := lns_fee_engine.getFeeStructures(p_loan_id => p_loan_id
2901: ,p_fee_category => 'EVENT'
2902: ,p_fee_type => 'EVENT_LATE_CHARGE'

Line 2908: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fee structures ' || l_late_fee_structures.count);

2904: ,p_fee_id => null);
2905: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - after api');
2906:
2907: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - late fee structures ' || l_late_fee_structures.count);
2908: FND_FILE.PUT_LINE(FND_FILE.LOG, 'fee structures ' || l_late_fee_structures.count);
2909: for x in 1..l_late_fee_structures.count loop
2910:
2911: -- get the amount overdue for the last installment (P or P+I depends on fee structure)
2912: vPlSql := 'select ' ||

Line 2986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'calculated fees count is ' || l_fee_calc_tbl_full.count);

2982:
2983: end loop;
2984:
2985: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - calculated fees count is ' || l_fee_calc_tbl_full.count);
2986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'calculated fees count is ' || l_fee_calc_tbl_full.count);
2987: lns_fee_engine.writeFeeSchedule(p_init_msg_list => p_init_msg_list
2988: ,p_commit => p_commit
2989: ,p_loan_id => p_loan_id
2990: ,p_fees_tbl => l_fee_calc_tbl_full

Line 3071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');

3067:
3068: BEGIN
3069:
3070:
3071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3074:
3075: select count(1) into l_fee_records1

Line 3072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);

3068: BEGIN
3069:
3070:
3071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3074:
3075: select count(1) into l_fee_records1
3076: from lns_fee_schedules

Line 3073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);

3069:
3070:
3071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3072: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3074:
3075: select count(1) into l_fee_records1
3076: from lns_fee_schedules
3077: where active_flag = 'Y'

Line 3081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing single loan ' || p_loan_id);

3077: where active_flag = 'Y'
3078: and billed_flag = 'N';
3079:
3080: if p_loan_id is not null then
3081: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing single loan ' || p_loan_id);
3082: lns_fee_engine.processLateFees(p_loan_id => p_loan_id
3083: ,p_init_msg_list => FND_API.G_TRUE
3084: ,p_commit => FND_API.G_TRUE
3085: ,x_return_status => l_return_status

Line 3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);

3094: into l_loan_id;
3095:
3096: exit when c_borrower_loans%notfound;
3097:
3098: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);
3099: lns_fee_engine.processLateFees(p_loan_id => l_loan_id
3100: ,p_init_msg_list => FND_API.G_TRUE
3101: ,p_commit => FND_API.G_TRUE
3102: ,x_return_status => l_return_status

Line 3105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);

3101: ,p_commit => FND_API.G_TRUE
3102: ,x_return_status => l_return_status
3103: ,x_msg_count => l_msg_count
3104: ,x_msg_data => l_msg_data);
3105: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);
3106:
3107: end loop;
3108:
3109: else

Line 3117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);

3113: into l_loan_id;
3114:
3115: exit when c_all_active_loans%notfound;
3116:
3117: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);
3118: lns_fee_engine.processLateFees(p_loan_id => l_loan_id
3119: ,p_init_msg_list => FND_API.G_TRUE
3120: ,p_commit => FND_API.G_TRUE
3121: ,x_return_status => l_return_status

Line 3124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);

3120: ,p_commit => FND_API.G_TRUE
3121: ,x_return_status => l_return_status
3122: ,x_msg_count => l_msg_count
3123: ,x_msg_data => l_msg_data);
3124: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);
3125:
3126: end loop;
3127:
3128: end if;

Line 3136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'added ' || l_processed_fees || ' into fee schedule');

3132: where active_flag = 'Y'
3133: and billed_flag = 'N';
3134:
3135: l_processed_fees := l_fee_records2 - l_fee_records1;
3136: FND_FILE.PUT_LINE(FND_FILE.LOG, 'added ' || l_processed_fees || ' into fee schedule');
3137:
3138: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3139: RAISE FND_API.G_EXC_ERROR;
3140: else

Line 3141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Late Fee Assessment: PROCESS COMPLETED SUCCESFULLY.');

3137:
3138: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3139: RAISE FND_API.G_EXC_ERROR;
3140: else
3141: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Late Fee Assessment: PROCESS COMPLETED SUCCESFULLY.');
3142: end if;
3143:
3144: EXCEPTION
3145: -- note do not set retcode when error is expected

Line 3149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);

3145: -- note do not set retcode when error is expected
3146: WHEN FND_API.G_EXC_ERROR THEN
3147: RETCODE := -1;
3148: ERRBUF := l_msg_data;
3149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3150: if l_msg_count > 0 then
3151: FOR l_index IN 1..l_msg_count LOOP
3152: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3153: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

Line 3153: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

3149: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3150: if l_msg_count > 0 then
3151: FOR l_index IN 1..l_msg_count LOOP
3152: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3153: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);
3154: END LOOP;
3155: end if;
3156:
3157: WHEN OTHERS THEN

Line 3160: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);

3156:
3157: WHEN OTHERS THEN
3158: RETCODE := -1;
3159: ERRBUF := l_msg_data;
3160: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3161: if l_msg_count > 0 then
3162: FOR l_index IN 1..l_msg_count LOOP
3163: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3164: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

Line 3164: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

3160: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3161: if l_msg_count > 0 then
3162: FOR l_index IN 1..l_msg_count LOOP
3163: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3164: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);
3165: END LOOP;
3166: end if;
3167:
3168: END LOAN_LATE_FEES_CONCUR;