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_CUSTOM_PUB dependencies on LNS_LOAN_HEADERS

Line 108: FROM lns_loan_headers_all h

104: l_skip_update boolean;
105:
106: cursor c_customized (p_loan_id number) is
107: SELECT nvl(h.custom_payments_flag, 'N')
108: FROM lns_loan_headers_all h
109: WHERE loan_id = p_loan_id;
110:
111: begin
112:

Line 138: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');

134: ,x_msg_data => l_msg_data
135: ,x_return_status => l_return_status
136: ,p_col_id => p_loan_id
137: ,p_col_name => 'LOAN_ID'
138: ,p_table_name => 'LNS_LOAN_HEADERS_ALL');
139:
140: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
141: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');
142: FND_MESSAGE.SET_TOKEN('PARAMETER', 'LOAN_ID');

Line 185: from lns_loan_headers_all

181:
182: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - resetting header');
183: if p_update_header and not l_skip_update then
184: select object_version_number into l_object_version
185: from lns_loan_headers_all
186: where loan_id = p_loan_id;
187: l_loan_header_rec.loan_id := p_loan_id;
188: l_loan_header_rec.custom_payments_flag := 'N';
189: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_FALSE

Line 312: from lns_loan_headers

308: and active_flag = 'Y';
309:
310: cursor c_loan_details(p_loan_id number) is
311: select loan_start_date, funded_amount
312: from lns_loan_headers
313: where loan_id = p_loan_id;
314:
315: begin
316: l_api_name := 'createCustomSchedule';

Line 501: from lns_loan_headers_all

497:
498: -- if we get this far now we update the header table flag for custom payments
499: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - attempting to update header set custom = Y');
500: select object_version_number into l_object_version
501: from lns_loan_headers_all
502: where loan_id = p_loan_id;
503: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - l_object_version ' || l_object_version);
504:
505: l_loan_header_rec.loan_id := p_loan_id;

Line 1478: FROM lns_loan_headers_all h

1474: ,t.TERM_PROJECTED_RATE TERM_PROJECTED_RATE
1475: ,nvl(t.PENAL_INT_RATE, 0)
1476: ,nvl(t.PENAL_INT_GRACE_DAYS, 0)
1477:
1478: FROM lns_loan_headers_all h
1479: ,lns_terms t
1480: ,fnd_currencies curr
1481: WHERE h.loan_id = p_loan_id
1482: AND h.loan_id = t.loan_id

Line 2933: -- getting info from lns_loan_headers_all

2929: l_custom_rec := l_custom_tbl(i);
2930:
2931: if l_custom_tbl(i).ACTION is null or l_custom_tbl(i).ACTION = 'U' then
2932:
2933: -- getting info from lns_loan_headers_all
2934: select object_version_number
2935: into l_custom_rec.OBJECT_VERSION_NUMBER
2936: from LNS_CUSTOM_PAYMNT_SCHEDS
2937: where loan_id = p_loan_id and

Line 2984: -- getting info from lns_loan_headers_all

2980: for i in 1..l_custom_tbl.count loop
2981: l_custom_tbl(i).ACTION := null;
2982: end loop;
2983:
2984: -- getting info from lns_loan_headers_all
2985: select object_version_number
2986: into l_object_version
2987: from lns_loan_headers_all
2988: where loan_id = p_loan_id;

Line 2987: from lns_loan_headers_all

2983:
2984: -- getting info from lns_loan_headers_all
2985: select object_version_number
2986: into l_object_version
2987: from lns_loan_headers_all
2988: where loan_id = p_loan_id;
2989:
2990: -- update lns_loan_headers_all only if loan is not custom yet
2991: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then

Line 2990: -- update lns_loan_headers_all only if loan is not custom yet

2986: into l_object_version
2987: from lns_loan_headers_all
2988: where loan_id = p_loan_id;
2989:
2990: -- update lns_loan_headers_all only if loan is not custom yet
2991: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then
2992: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all');
2993: l_loan_header_rec.loan_id := P_LOAN_ID;
2994: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'Y';

Line 2992: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all');

2988: where loan_id = p_loan_id;
2989:
2990: -- update lns_loan_headers_all only if loan is not custom yet
2991: if l_loan_details.CUSTOM_SCHEDULE = 'N' or l_loan_header_rec.BILLED_FLAG is not null then
2992: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all');
2993: l_loan_header_rec.loan_id := P_LOAN_ID;
2994: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'Y';
2995:
2996: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_TRUE

Line 3006: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');

3002:
3003: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3004:
3005: IF l_return_status = 'S' THEN
3006: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3007: ELSE
3008: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3009: FND_MSG_PUB.Add;
3010: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));

Line 3183: -- getting info from lns_loan_headers_all

3179:
3180: delete from LNS_CUSTOM_PAYMNT_SCHEDS
3181: where loan_id = p_loan_id;
3182: /*
3183: -- getting info from lns_loan_headers_all
3184: select object_version_number
3185: into l_object_version
3186: from lns_loan_headers_all
3187: where loan_id = p_loan_id;

Line 3186: from lns_loan_headers_all

3182: /*
3183: -- getting info from lns_loan_headers_all
3184: select object_version_number
3185: into l_object_version
3186: from lns_loan_headers_all
3187: where loan_id = p_loan_id;
3188:
3189: -- update lns_loan_headers_all only if loan is not custom yet
3190: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');

Line 3189: -- update lns_loan_headers_all only if loan is not custom yet

3185: into l_object_version
3186: from lns_loan_headers_all
3187: where loan_id = p_loan_id;
3188:
3189: -- update lns_loan_headers_all only if loan is not custom yet
3190: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');
3191: l_loan_header_rec.loan_id := P_LOAN_ID;
3192: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'N';
3193:

Line 3190: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');

3186: from lns_loan_headers_all
3187: where loan_id = p_loan_id;
3188:
3189: -- update lns_loan_headers_all only if loan is not custom yet
3190: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Updating lns_loan_headers_all set custom = N');
3191: l_loan_header_rec.loan_id := P_LOAN_ID;
3192: l_loan_header_rec.CUSTOM_PAYMENTS_FLAG := 'N';
3193:
3194: lns_loan_header_pub.update_loan(p_init_msg_list => FND_API.G_TRUE

Line 3204: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');

3200:
3201: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, 'l_return_status: ' || l_return_status);
3202:
3203: IF l_return_status = 'S' THEN
3204: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Successfully updated lns_loan_headers_all');
3205: ELSE
3206: FND_MESSAGE.SET_NAME('LNS', 'LNS_UPD_LOAN_FAIL');
3207: FND_MSG_PUB.Add;
3208: LogMessage(FND_LOG.LEVEL_UNEXPECTED, G_PKG_NAME, FND_MSG_PUB.Get(p_encoded => 'F'));