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_BILLING_BATCH_PUB dependencies on LNS_BILLING_UTIL_PUB

Line 1317: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_REC.LOAN_ID,

1313: l_exit_loop := 'N';
1314: l_end_pos := instr(P_LOAN_REC.PAYMENT_APPLICATION_ORDER, l_search_str, l_start_pos, 1);
1315: l_inv_comment := substr(P_LOAN_REC.LOAN_DESCRIPTION, 1, 240);
1316:
1317: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_REC.LOAN_ID,
1318: P_DUE_DATE => P_LOAN_REC.NEXT_PAYMENT_DUE_DATE,
1319: X_TRX_DATE => l_trx_date,
1320: X_RA_TERM_ID => l_term_id);
1321:

Line 2042: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');

2038: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_trx_header_tbl(' || l_Count3 || ').org_id: ' || l_trx_header_tbl(l_Count3).org_id);
2039: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_trx_header_tbl(' || l_Count3 || ').legal_entity_id: ' || l_trx_header_tbl(l_Count3).legal_entity_id);
2040:
2041: -- fix for bug 8859462
2042: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');
2043: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
2044: p_gl_date => l_trx_header_tbl(l_Count3).gl_date,
2045: p_trx_date => l_trx_header_tbl(l_Count3).trx_date,
2046: p_set_of_books_id => g_set_of_books_id,

Line 2043: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

2039: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_trx_header_tbl(' || l_Count3 || ').legal_entity_id: ' || l_trx_header_tbl(l_Count3).legal_entity_id);
2040:
2041: -- fix for bug 8859462
2042: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');
2043: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
2044: p_gl_date => l_trx_header_tbl(l_Count3).gl_date,
2045: p_trx_date => l_trx_header_tbl(l_Count3).trx_date,
2046: p_set_of_books_id => g_set_of_books_id,
2047: x_default_gl_date => l_trx_header_tbl(l_Count3).gl_date);

Line 2940: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');

2936: l_adj_rec.reason_code := P_REASON_CODE;
2937: l_adj_rec.comments := P_COMMENTS;
2938: l_adj_rec.org_id := P_ORG_ID;
2939:
2940: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');
2941: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
2942: p_gl_date => P_GL_DATE,
2943: p_trx_date => P_APPLY_DATE,
2944: p_set_of_books_id => g_set_of_books_id,

Line 2941: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

2937: l_adj_rec.comments := P_COMMENTS;
2938: l_adj_rec.org_id := P_ORG_ID;
2939:
2940: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE...');
2941: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
2942: p_gl_date => P_GL_DATE,
2943: p_trx_date => P_APPLY_DATE,
2944: p_set_of_books_id => g_set_of_books_id,
2945: x_default_gl_date => l_adj_rec.gl_date);

Line 3972: P_LOAN_REC.NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_2(P_LOAN_REC.LOAN_ID);

3968:
3969: end if;
3970:
3971: /* getting current payment number */
3972: P_LOAN_REC.NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_2(P_LOAN_REC.LOAN_ID);
3973:
3974: if P_LOAN_REC.NEXT_PAYMENT_NUMBER = -1 then
3975:
3976: P_LOAN_REC.NEXT_PAYMENT_NUMBER := 0;

Line 5354: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

5350: from LNS_LOAN_HEADERS_VL head,
5351: LNS_TERMS term
5352: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5353: and head.loan_id = term.loan_id
5354: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5355: and (head.BILLED_FLAG is null or head.BILLED_FLAG = 'N')
5356: and head.LOAN_TYPE_ID = nvl(P_TYPE_ID, head.LOAN_TYPE_ID)
5357: and nvl(head.PRODUCT_ID, -1) = nvl(P_PRODUCT_ID, nvl(head.PRODUCT_ID, -1)) -- fix for bug 14153250
5358: and head.PRIMARY_BORROWER_ID = nvl(P_BORROWER_ID, head.PRIMARY_BORROWER_ID)

Line 5736: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,

5732: select
5733: head.LOAN_ID,
5734: head.LOAN_NUMBER,
5735: head.OBJECT_VERSION_NUMBER,
5736: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
5737: head.CUSTOM_PAYMENTS_FLAG
5738: from LNS_LOAN_HEADERS head,
5739: LNS_TERMS term
5740: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')

Line 5743: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))

5739: LNS_TERMS term
5740: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')
5741: and head.loan_id = term.loan_id
5742: and (head.BILLED_FLAG = 'Y' or head.BILLED_FLAG is null) -- scherkas; fix for bug 5687852
5743: and LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) < LNS_FIN_UTILS.getNumberInstallments(head.LOAN_ID, nvl(head.current_phase, 'TERM'))
5744: and trunc(decode(head.CURRENT_PHASE, 'OPEN', term.OPEN_NEXT_PAYMENT_DATE, term.NEXT_PAYMENT_DUE_DATE) + nvl(term.NUMBER_GRACE_DAYS, 0)) < trunc(sysdate)
5745: ORDER BY head.LOAN_ID;
5746:
5747: BEGIN

Line 5951: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);

5947: AMORTIZATION_SCHEDULE_ID,
5948: RATE_ID
5949: from LNS_AMORTIZATION_SCHEDS
5950: where LOAN_ID = P_LOAN_ID
5951: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
5952:
5953: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number) IS
5954: select
5955: trx.trx_number,

Line 6378: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);

6374: DUE_DATE,
6375: AMORTIZATION_SCHEDULE_ID
6376: from LNS_AMORTIZATION_SCHEDS
6377: where LOAN_ID = P_LOAN_ID
6378: and AMORTIZATION_SCHEDULE_ID = LNS_BILLING_UTIL_PUB.LAST_AMORTIZATION_SCHED(LOAN_ID);
6379:
6380: CURSOR trx_to_reverse_cur(P_LOAN_ID number, P_AMORTIZATION_ID number, p_line_type varchar2) IS
6381: select
6382: trx.trx_number,

Line 8745: l_NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_1(P_LOAN_ID) + 1;

8741: end if;
8742:
8743: -- Bug#6830765 - Added new procedure ..EXT_1, which returns '0' if 0th installment is scheduled and it solves
8744: -- the case if there is no '0th installment' and wants '1st 'installment
8745: l_NEXT_PAYMENT_NUMBER := LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER_EXT_1(P_LOAN_ID) + 1;
8746:
8747: open c_loanInfo(P_LOAN_ID);
8748: fetch c_loanInfo into l_invoice_number, l_currency, l_exchange_rate, l_current_phase;
8749: close c_loanInfo;

Line 8840: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_ID,

8836:
8837: end if;
8838:
8839: -- get trx date
8840: LNS_BILLING_UTIL_PUB.GET_TRX_DATE(P_LOAN_ID => P_LOAN_ID,
8841: P_DUE_DATE => l_amortization_rec.due_date,
8842: X_TRX_DATE => l_trx_date,
8843: X_RA_TERM_ID => l_term_id);
8844:

Line 8878: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

8874: close trx_type_cur;
8875:
8876: l_invoices_tbl(i).GL_DATE := l_trx_date + nvl(g_day_togl_after_dd, 0);
8877: --l_invoices_tbl(i).GL_DATE := l_invoices_tbl(i).DUE_DATE + nvl(g_day_togl_after_dd, 0);
8878: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
8879: p_gl_date => l_invoices_tbl(i).GL_DATE,
8880: p_trx_date => l_trx_date, --l_invoices_tbl(i).DUE_DATE,
8881: p_set_of_books_id => g_set_of_books_id,
8882: x_default_gl_date => l_invoices_tbl(i).GL_DATE);

Line 8912: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

8908: l_invoices_tbl(i).EXCHANGE_RATE := l_exchange_rate;
8909: --l_invoices_tbl(i).GL_DATE := l_invoices_tbl(i).DUE_DATE + nvl(g_day_togl_after_dd, 0);
8910:
8911: l_invoices_tbl(i).GL_DATE := l_trx_date + nvl(g_day_togl_after_dd, 0);
8912: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
8913: p_gl_date => l_invoices_tbl(i).GL_DATE,
8914: p_trx_date => l_trx_date, --l_invoices_tbl(i).DUE_DATE,
8915: p_set_of_books_id => g_set_of_books_id,
8916: x_default_gl_date => l_invoices_tbl(i).GL_DATE);

Line 8940: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(

8936: l_invoices_tbl(i).EXCHANGE_RATE := l_exchange_rate;
8937: --l_invoices_tbl(i).GL_DATE := l_invoices_tbl(i).DUE_DATE + nvl(g_day_togl_after_dd, 0);
8938:
8939: l_invoices_tbl(i).GL_DATE := l_trx_date + nvl(g_day_togl_after_dd, 0);
8940: LNS_BILLING_UTIL_PUB.VALIDATE_AND_DEFAULT_GL_DATE(
8941: p_gl_date => l_invoices_tbl(i).GL_DATE,
8942: p_trx_date => l_trx_date, --l_invoices_tbl(i).DUE_DATE,
8943: p_set_of_books_id => g_set_of_books_id,
8944: x_default_gl_date => l_invoices_tbl(i).GL_DATE);

Line 9818: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,

9814: select
9815: head.LOAN_ID,
9816: head.LOAN_NUMBER,
9817: head.OBJECT_VERSION_NUMBER,
9818: LNS_BILLING_UTIL_PUB.LAST_PAYMENT_NUMBER(head.LOAN_ID) + 1,
9819: head.CUSTOM_PAYMENTS_FLAG
9820: from LNS_LOAN_HEADERS head,
9821: LNS_TERMS term
9822: where head.LOAN_STATUS in ('ACTIVE', 'DEFAULT', 'DELINQUENT')