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 3630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');

3626:
3627: BEGIN
3628:
3629:
3630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3632: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3633:
3634: select count(1) into l_fee_records1

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

3627: BEGIN
3628:
3629:
3630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3632: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3633:
3634: select count(1) into l_fee_records1
3635: from lns_fee_schedules

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

3628:
3629:
3630: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Beginning Loans Late Fee Assessment');
3631: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_LOAN_ID ' || p_loan_id);
3632: FND_FILE.PUT_LINE(FND_FILE.LOG, 'P_BORROWER_ID ' || p_borrower_id);
3633:
3634: select count(1) into l_fee_records1
3635: from lns_fee_schedules
3636: where active_flag = 'Y'

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

3636: where active_flag = 'Y'
3637: and billed_flag = 'N';
3638:
3639: if p_loan_id is not null then
3640: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing single loan ' || p_loan_id);
3641: OPEN c_loan_det(p_loan_id);
3642: FETCH c_loan_det INTO l_phase;
3643: CLOSE c_loan_det;
3644: lns_fee_engine.processLateFees(p_init_msg_list => FND_API.G_TRUE

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

3657: into l_loan_id, l_phase;
3658:
3659: exit when c_borrower_loans%notfound;
3660:
3661: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);
3662: lns_fee_engine.processLateFees(p_init_msg_list => FND_API.G_TRUE
3663: ,p_commit => FND_API.G_TRUE
3664: ,p_loan_id => l_loan_id
3665: ,p_phase => l_phase

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

3665: ,p_phase => l_phase
3666: ,x_return_status => l_return_status
3667: ,x_msg_count => l_msg_count
3668: ,x_msg_data => l_msg_data);
3669: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);
3670:
3671: end loop;
3672:
3673: else

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

3677: into l_loan_id, l_phase;
3678:
3679: exit when c_all_active_loans%notfound;
3680:
3681: FND_FILE.PUT_LINE(FND_FILE.LOG, 'processing loan ' || l_loan_id);
3682: lns_fee_engine.processLateFees(p_init_msg_list => FND_API.G_TRUE
3683: ,p_commit => FND_API.G_TRUE
3684: ,p_loan_id => l_loan_id
3685: ,p_phase => l_phase

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

3685: ,p_phase => l_phase
3686: ,x_return_status => l_return_status
3687: ,x_msg_count => l_msg_count
3688: ,x_msg_data => l_msg_data);
3689: FND_FILE.PUT_LINE(FND_FILE.LOG, 'FAP status ' || l_return_status);
3690:
3691: end loop;
3692:
3693: end if;

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

3697: where active_flag = 'Y'
3698: and billed_flag = 'N';
3699:
3700: l_processed_fees := l_fee_records2 - l_fee_records1;
3701: FND_FILE.PUT_LINE(FND_FILE.LOG, 'added ' || l_processed_fees || ' into fee schedule');
3702:
3703: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3704: RAISE FND_API.G_EXC_ERROR;
3705: else

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

3702:
3703: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
3704: RAISE FND_API.G_EXC_ERROR;
3705: else
3706: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Late Fee Assessment: PROCESS COMPLETED SUCCESFULLY.');
3707: end if;
3708:
3709: EXCEPTION
3710: -- note do not set retcode when error is expected

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

3710: -- note do not set retcode when error is expected
3711: WHEN FND_API.G_EXC_ERROR THEN
3712: RETCODE := -1;
3713: ERRBUF := l_msg_data;
3714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3715: if l_msg_count > 0 then
3716: FOR l_index IN 1..l_msg_count LOOP
3717: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3718: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

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

3714: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3715: if l_msg_count > 0 then
3716: FOR l_index IN 1..l_msg_count LOOP
3717: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3718: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);
3719: END LOOP;
3720: end if;
3721:
3722: WHEN OTHERS THEN

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

3721:
3722: WHEN OTHERS THEN
3723: RETCODE := -1;
3724: ERRBUF := l_msg_data;
3725: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3726: if l_msg_count > 0 then
3727: FOR l_index IN 1..l_msg_count LOOP
3728: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3729: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);

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

3725: FND_FILE.PUT_LINE(FND_FILE.LOG, 'ERROR IN FAP: ' || sqlerrm || ERRBUF);
3726: if l_msg_count > 0 then
3727: FOR l_index IN 1..l_msg_count LOOP
3728: my_message := FND_MSG_PUB.Get(p_msg_index => l_index, p_encoded => 'F');
3729: FND_FILE.PUT_LINE(FND_FILE.LOG, my_message);
3730: END LOOP;
3731: end if;
3732:
3733: END LOAN_LATE_FEES_CONCUR;