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

Line 745: P_Loan_Details_Rec.exchange_rate := LNS_UTILITY_PUB.CONVERTRATE(l_functional_currency

741: IF P_Loan_Details_Rec.exchange_rate IS NULL THEN
742: LogErrors(p_message_name => 'LNS_LCREATE_NULL_VALUE', p_token1 => 'P_Loan_Details_Rec.exchange_rate');
743: END IF;
744: ELSE
745: P_Loan_Details_Rec.exchange_rate := LNS_UTILITY_PUB.CONVERTRATE(l_functional_currency
746: ,l_product_rec.loan_currency
747: ,P_Loan_Details_Rec.exchange_date
748: ,P_Loan_Details_Rec.exchange_rate_type
749: );

Line 2690: ,lns_utility_pub.creation_date

2686: ,l_account_type
2687: ,l_distribution_percent
2688: ,l_distribution_type
2689: ,l_fee_assignment_rec.fee_id
2690: ,lns_utility_pub.creation_date
2691: ,lns_utility_pub.created_by
2692: ,lns_utility_pub.last_update_date
2693: ,lns_utility_pub.last_updated_by
2694: ,1) ;

Line 2691: ,lns_utility_pub.created_by

2687: ,l_distribution_percent
2688: ,l_distribution_type
2689: ,l_fee_assignment_rec.fee_id
2690: ,lns_utility_pub.creation_date
2691: ,lns_utility_pub.created_by
2692: ,lns_utility_pub.last_update_date
2693: ,lns_utility_pub.last_updated_by
2694: ,1) ;
2695: logmessage(fnd_log.level_statement, 'Done');

Line 2692: ,lns_utility_pub.last_update_date

2688: ,l_distribution_type
2689: ,l_fee_assignment_rec.fee_id
2690: ,lns_utility_pub.creation_date
2691: ,lns_utility_pub.created_by
2692: ,lns_utility_pub.last_update_date
2693: ,lns_utility_pub.last_updated_by
2694: ,1) ;
2695: logmessage(fnd_log.level_statement, 'Done');
2696:

Line 2693: ,lns_utility_pub.last_updated_by

2689: ,l_fee_assignment_rec.fee_id
2690: ,lns_utility_pub.creation_date
2691: ,lns_utility_pub.created_by
2692: ,lns_utility_pub.last_update_date
2693: ,lns_utility_pub.last_updated_by
2694: ,1) ;
2695: logmessage(fnd_log.level_statement, 'Done');
2696:
2697: END LOOP ;

Line 3724: lns_utility_pub.created_by,

3720: l_open_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,
3721: l_open_freq_schedule_tbl(1).FREQUENCY,
3722: 1,
3723: sysdate,
3724: lns_utility_pub.created_by,
3725: sysdate,
3726: lns_utility_pub.last_updated_by,
3727: lns_utility_pub.LAST_UPDATE_LOGIN);
3728: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted Open phase record');

Line 3726: lns_utility_pub.last_updated_by,

3722: 1,
3723: sysdate,
3724: lns_utility_pub.created_by,
3725: sysdate,
3726: lns_utility_pub.last_updated_by,
3727: lns_utility_pub.LAST_UPDATE_LOGIN);
3728: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted Open phase record');
3729: end if;
3730:

Line 3727: lns_utility_pub.LAST_UPDATE_LOGIN);

3723: sysdate,
3724: lns_utility_pub.created_by,
3725: sysdate,
3726: lns_utility_pub.last_updated_by,
3727: lns_utility_pub.LAST_UPDATE_LOGIN);
3728: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted Open phase record');
3729: end if;
3730:
3731: -- insert term phase record(s)

Line 3756: lns_utility_pub.created_by,

3752: l_int_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,
3753: l_int_freq_schedule_tbl(1).FREQUENCY,
3754: 1,
3755: sysdate,
3756: lns_utility_pub.created_by,
3757: sysdate,
3758: lns_utility_pub.last_updated_by,
3759: lns_utility_pub.LAST_UPDATE_LOGIN);
3760: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted INT record');

Line 3758: lns_utility_pub.last_updated_by,

3754: 1,
3755: sysdate,
3756: lns_utility_pub.created_by,
3757: sysdate,
3758: lns_utility_pub.last_updated_by,
3759: lns_utility_pub.LAST_UPDATE_LOGIN);
3760: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted INT record');
3761:
3762: insert into LNS_FREQ_SCHEDULES

Line 3759: lns_utility_pub.LAST_UPDATE_LOGIN);

3755: sysdate,
3756: lns_utility_pub.created_by,
3757: sysdate,
3758: lns_utility_pub.last_updated_by,
3759: lns_utility_pub.LAST_UPDATE_LOGIN);
3760: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted INT record');
3761:
3762: insert into LNS_FREQ_SCHEDULES
3763: (FREQ_SCHEDULE_ID,

Line 3784: lns_utility_pub.created_by,

3780: l_prin_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,
3781: l_prin_freq_schedule_tbl(1).FREQUENCY,
3782: 1,
3783: sysdate,
3784: lns_utility_pub.created_by,
3785: sysdate,
3786: lns_utility_pub.last_updated_by,
3787: lns_utility_pub.LAST_UPDATE_LOGIN);
3788: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN record');

Line 3786: lns_utility_pub.last_updated_by,

3782: 1,
3783: sysdate,
3784: lns_utility_pub.created_by,
3785: sysdate,
3786: lns_utility_pub.last_updated_by,
3787: lns_utility_pub.LAST_UPDATE_LOGIN);
3788: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN record');
3789: else
3790: -- insert 1 record if its others

Line 3787: lns_utility_pub.LAST_UPDATE_LOGIN);

3783: sysdate,
3784: lns_utility_pub.created_by,
3785: sysdate,
3786: lns_utility_pub.last_updated_by,
3787: lns_utility_pub.LAST_UPDATE_LOGIN);
3788: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN record');
3789: else
3790: -- insert 1 record if its others
3791: insert into LNS_FREQ_SCHEDULES

Line 3813: lns_utility_pub.created_by,

3809: l_freq_schedule_tbl(1).PERIOD_BEGIN_DATE,
3810: l_freq_schedule_tbl(1).FREQUENCY,
3811: 1,
3812: sysdate,
3813: lns_utility_pub.created_by,
3814: sysdate,
3815: lns_utility_pub.last_updated_by,
3816: lns_utility_pub.LAST_UPDATE_LOGIN);
3817: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN_INT record');

Line 3815: lns_utility_pub.last_updated_by,

3811: 1,
3812: sysdate,
3813: lns_utility_pub.created_by,
3814: sysdate,
3815: lns_utility_pub.last_updated_by,
3816: lns_utility_pub.LAST_UPDATE_LOGIN);
3817: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN_INT record');
3818: end if;
3819: EXCEPTION

Line 3816: lns_utility_pub.LAST_UPDATE_LOGIN);

3812: sysdate,
3813: lns_utility_pub.created_by,
3814: sysdate,
3815: lns_utility_pub.last_updated_by,
3816: lns_utility_pub.LAST_UPDATE_LOGIN);
3817: logmessage(fnd_log.LEVEL_UNEXPECTED, 'Inserted PRIN_INT record');
3818: end if;
3819: EXCEPTION
3820: WHEN OTHERS THEN

Line 3864: ,lns_utility_pub.created_by

3860: ,nvl(P_TERM_RATES_TBL(l_Count).SPREAD, 0)
3861: ,(P_TERM_RATES_TBL(l_Count).INDEX_RATE + nvl(P_TERM_RATES_TBL(l_Count).SPREAD, 0))
3862: ,sysdate
3863: ,null
3864: ,lns_utility_pub.created_by
3865: ,sysdate
3866: ,lns_utility_pub.last_updated_by
3867: ,sysdate
3868: ,lns_utility_pub.LAST_UPDATE_LOGIN

Line 3866: ,lns_utility_pub.last_updated_by

3862: ,sysdate
3863: ,null
3864: ,lns_utility_pub.created_by
3865: ,sysdate
3866: ,lns_utility_pub.last_updated_by
3867: ,sysdate
3868: ,lns_utility_pub.LAST_UPDATE_LOGIN
3869: ,1
3870: ,P_TERM_RATES_TBL(l_Count).INDEX_DATE

Line 3868: ,lns_utility_pub.LAST_UPDATE_LOGIN

3864: ,lns_utility_pub.created_by
3865: ,sysdate
3866: ,lns_utility_pub.last_updated_by
3867: ,sysdate
3868: ,lns_utility_pub.LAST_UPDATE_LOGIN
3869: ,1
3870: ,P_TERM_RATES_TBL(l_Count).INDEX_DATE
3871: ,P_TERM_RATES_TBL(l_Count).BEGIN_INSTALLMENT_NUMBER
3872: ,P_TERM_RATES_TBL(l_Count).END_INSTALLMENT_NUMBER

Line 3923: ,lns_utility_pub.created_by

3919: ,nvl(P_OPEN_RATES_TBL(l_Count).SPREAD, 0)
3920: ,(P_OPEN_RATES_TBL(l_Count).INDEX_RATE + nvl(P_OPEN_RATES_TBL(l_Count).SPREAD, 0))
3921: ,sysdate
3922: ,null
3923: ,lns_utility_pub.created_by
3924: ,sysdate
3925: ,lns_utility_pub.last_updated_by
3926: ,sysdate
3927: ,lns_utility_pub.LAST_UPDATE_LOGIN

Line 3925: ,lns_utility_pub.last_updated_by

3921: ,sysdate
3922: ,null
3923: ,lns_utility_pub.created_by
3924: ,sysdate
3925: ,lns_utility_pub.last_updated_by
3926: ,sysdate
3927: ,lns_utility_pub.LAST_UPDATE_LOGIN
3928: ,1
3929: ,P_OPEN_RATES_TBL(l_Count).INDEX_DATE

Line 3927: ,lns_utility_pub.LAST_UPDATE_LOGIN

3923: ,lns_utility_pub.created_by
3924: ,sysdate
3925: ,lns_utility_pub.last_updated_by
3926: ,sysdate
3927: ,lns_utility_pub.LAST_UPDATE_LOGIN
3928: ,1
3929: ,P_OPEN_RATES_TBL(l_Count).INDEX_DATE
3930: ,P_OPEN_RATES_TBL(l_Count).BEGIN_INSTALLMENT_NUMBER
3931: ,P_OPEN_RATES_TBL(l_Count).END_INSTALLMENT_NUMBER

Line 4005: ,lns_utility_pub.created_by

4001: (
4002: LNS_LOAN_LINE_S.nextval
4003: ,l_loan_rec.loan_id
4004: ,sysdate
4005: ,lns_utility_pub.created_by
4006: ,sysdate
4007: ,lns_utility_pub.created_by
4008: ,1
4009: ,'RECEIVABLE'

Line 4007: ,lns_utility_pub.created_by

4003: ,l_loan_rec.loan_id
4004: ,sysdate
4005: ,lns_utility_pub.created_by
4006: ,sysdate
4007: ,lns_utility_pub.created_by
4008: ,1
4009: ,'RECEIVABLE'
4010: ,p_loan_lines_tbl(l_count).customer_trx_id --v_customer_trx_id(i)
4011: ,p_loan_lines_tbl(l_count).REFERENCE_NUMBER --v_reference_number(i)