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 STANDARD

Line 72: || Return value: standard API outputs

68: || Overview: resets a customized payment schedule for a loan
69: ||
70: || Parameter: loan_id => loan id to reset
71: ||
72: || Return value: standard API outputs
73: ||
74: || Source Tables: NA
75: ||
76: || Target Tables: LNS_CUSTOM_PAYMENT_SCHEDULE, LNS_LOAN_HEADER

Line 116: -- Standard Start of API savepoint

112: WHERE loan_id = p_loan_id;
113:
114: begin
115:
116: -- Standard Start of API savepoint
117: SAVEPOINT resetCustomSchedule;
118: l_api_name := 'resetCustomSchedule';
119:
120: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, l_api_name || ' - BEGIN');

Line 206: -- Standard check for p_commit

202: -- --------------------------------------------------------------------
203: -- End of API body
204: -- --------------------------------------------------------------------
205:
206: -- Standard check for p_commit
207: IF FND_API.to_Boolean(p_commit) THEN
208: COMMIT WORK;
209: END IF;
210:

Line 252: || Return value: standard API outputs

248: ||
249: || Parameter: loan_id => loan id to customize
250: || p_custom_tbl => table of records about custom schedule
251: ||
252: || Return value: standard API outputs
253: ||
254: || Source Tables: NA
255: ||
256: || Target Tables: LNS_CUSTOM_PAYMENT_SCHEDULE

Line 576: || Return value: standard API outputs

572: ||
573: || Parameter: loan_id => loan id to customize
574: || p_custom_tbl => table of records about custom schedule
575: ||
576: || Return value: standard API outputs
577: ||
578: || Source Tables: NA
579: ||
580: || Target Tables: LNS_CUSTOM_PAYMENT_SCHEDULE

Line 1621: -- 'EQUAL_PAYMENT_STANDARD', 'EQUAL_PAYMENT', 'EQUAL_PRINCIPAL', 'EQUAL_PRINCIPAL', 'SEPARATE_SCHEDULES', 'EQUAL_PRINCIPAL'))

1617: ,t.CALCULATION_METHOD
1618: ,t.INTEREST_COMPOUNDING_FREQ
1619: ,nvl(t.CUSTOM_CALC_METHOD, 'NONE')
1620: -- ,nvl(t.CUSTOM_CALC_METHOD, decode(nvl(t.PAYMENT_CALC_METHOD, 'EQUAL_PAYMENT'), 'EQUAL_PAYMENT', 'EQUAL_PAYMENT',
1621: -- 'EQUAL_PAYMENT_STANDARD', 'EQUAL_PAYMENT', 'EQUAL_PRINCIPAL', 'EQUAL_PRINCIPAL', 'SEPARATE_SCHEDULES', 'EQUAL_PRINCIPAL'))
1622: ,t.ORIG_PAY_CALC_METHOD
1623: ,t.RATE_TYPE RATE_TYPE
1624: ,t.CEILING_RATE TERM_CEILING_RATE
1625: ,t.FLOOR_RATE TERM_FLOOR_RATE

Line 1858: -- Standard start of API savepoint

1854: BEGIN
1855:
1856: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
1857:
1858: -- Standard start of API savepoint
1859: SAVEPOINT loadCustomSchedule;
1860: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
1861:
1862: -- Standard call to check for call compatibility

Line 1862: -- Standard call to check for call compatibility

1858: -- Standard start of API savepoint
1859: SAVEPOINT loadCustomSchedule;
1860: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
1861:
1862: -- Standard call to check for call compatibility
1863: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: END IF;
1866:

Line 2053: -- Standard call to get message count and if count is 1, get message info

2049:
2050: -- END OF BODY OF API
2051: x_return_status := FND_API.G_RET_STS_SUCCESS;
2052:
2053: -- Standard call to get message count and if count is 1, get message info
2054: FND_MSG_PUB.Count_And_Get(
2055: p_encoded => FND_API.G_FALSE,
2056: p_count => x_msg_count,
2057: p_data => x_msg_data);

Line 2248: -- Standard start of API savepoint

2244: BEGIN
2245:
2246: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
2247:
2248: -- Standard start of API savepoint
2249: SAVEPOINT recalcCustomSchedule;
2250: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2251:
2252: -- Standard call to check for call compatibility

Line 2252: -- Standard call to check for call compatibility

2248: -- Standard start of API savepoint
2249: SAVEPOINT recalcCustomSchedule;
2250: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2251:
2252: -- Standard call to check for call compatibility
2253: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2254: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2255: END IF;
2256:

Line 3452: -- Standard call to get message count and if count is 1, get message info

3448:
3449: -- END OF BODY OF API
3450: x_return_status := FND_API.G_RET_STS_SUCCESS;
3451:
3452: -- Standard call to get message count and if count is 1, get message info
3453: FND_MSG_PUB.Count_And_Get(
3454: p_encoded => FND_API.G_FALSE,
3455: p_count => x_msg_count,
3456: p_data => x_msg_data);

Line 3544: -- Standard start of API savepoint

3540: BEGIN
3541:
3542: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3543:
3544: -- Standard start of API savepoint
3545: SAVEPOINT saveCustomSchedule;
3546: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3547:
3548: -- Standard call to check for call compatibility

Line 3548: -- Standard call to check for call compatibility

3544: -- Standard start of API savepoint
3545: SAVEPOINT saveCustomSchedule;
3546: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3547:
3548: -- Standard call to check for call compatibility
3549: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3551: END IF;
3552:

Line 3825: -- Standard call to get message count and if count is 1, get message info

3821:
3822: -- END OF BODY OF API
3823: x_return_status := FND_API.G_RET_STS_SUCCESS;
3824:
3825: -- Standard call to get message count and if count is 1, get message info
3826: FND_MSG_PUB.Count_And_Get(
3827: p_encoded => FND_API.G_FALSE,
3828: p_count => x_msg_count,
3829: p_data => x_msg_data);

Line 3853: -- This procedure switches back from custom schedule to standard schedule in one shot

3849: END;
3850:
3851:
3852:
3853: -- This procedure switches back from custom schedule to standard schedule in one shot
3854: -- Conditions: loan status is INCOMPLETE and loan has been already customized
3855: procedure uncustomizeSchedule(
3856: P_API_VERSION IN NUMBER,
3857: P_INIT_MSG_LIST IN VARCHAR2,

Line 3894: -- Standard start of API savepoint

3890: BEGIN
3891:
3892: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3893:
3894: -- Standard start of API savepoint
3895: SAVEPOINT uncustomizeSchedule;
3896: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3897:
3898: -- Standard call to check for call compatibility

Line 3898: -- Standard call to check for call compatibility

3894: -- Standard start of API savepoint
3895: SAVEPOINT uncustomizeSchedule;
3896: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3897:
3898: -- Standard call to check for call compatibility
3899: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3900: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3901: END IF;
3902:

Line 4014: -- Standard call to get message count and if count is 1, get message info

4010:
4011: -- END OF BODY OF API
4012: x_return_status := FND_API.G_RET_STS_SUCCESS;
4013:
4014: -- Standard call to get message count and if count is 1, get message info
4015: FND_MSG_PUB.Count_And_Get(
4016: p_encoded => FND_API.G_FALSE,
4017: p_count => x_msg_count,
4018: p_data => x_msg_data);

Line 4124: -- Standard start of API savepoint

4120: BEGIN
4121:
4122: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
4123:
4124: -- Standard start of API savepoint
4125: SAVEPOINT customizeSchedule;
4126: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4127:
4128: -- Standard call to check for call compatibility

Line 4128: -- Standard call to check for call compatibility

4124: -- Standard start of API savepoint
4125: SAVEPOINT customizeSchedule;
4126: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4127:
4128: -- Standard call to check for call compatibility
4129: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4130: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4131: END IF;
4132:

Line 4228: -- Standard call to get message count and if count is 1, get message info

4224:
4225: -- END OF BODY OF API
4226: x_return_status := FND_API.G_RET_STS_SUCCESS;
4227:
4228: -- Standard call to get message count and if count is 1, get message info
4229: FND_MSG_PUB.Count_And_Get(
4230: p_encoded => FND_API.G_FALSE,
4231: p_count => x_msg_count,
4232: p_data => x_msg_data);

Line 4378: -- Standard start of API savepoint

4374: BEGIN
4375:
4376: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
4377:
4378: -- Standard start of API savepoint
4379: SAVEPOINT shiftCustomSchedule;
4380: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4381:
4382: -- Standard call to check for call compatibility

Line 4382: -- Standard call to check for call compatibility

4378: -- Standard start of API savepoint
4379: SAVEPOINT shiftCustomSchedule;
4380: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4381:
4382: -- Standard call to check for call compatibility
4383: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4384: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4385: END IF;
4386:

Line 4485: -- Standard call to get message count and if count is 1, get message info

4481:
4482: -- END OF BODY OF API
4483: x_return_status := FND_API.G_RET_STS_SUCCESS;
4484:
4485: -- Standard call to get message count and if count is 1, get message info
4486: FND_MSG_PUB.Count_And_Get(
4487: p_encoded => FND_API.G_FALSE,
4488: p_count => x_msg_count,
4489: p_data => x_msg_data);

Line 4551: -- Standard start of API savepoint

4547: BEGIN
4548:
4549: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
4550:
4551: -- Standard start of API savepoint
4552: SAVEPOINT reBuildCustomdSchedule;
4553: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4554:
4555: -- Standard call to check for call compatibility

Line 4555: -- Standard call to check for call compatibility

4551: -- Standard start of API savepoint
4552: SAVEPOINT reBuildCustomdSchedule;
4553: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4554:
4555: -- Standard call to check for call compatibility
4556: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4557: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4558: END IF;
4559:

Line 4609: -- Standard call to get message count and if count is 1, get message info

4605:
4606: -- END OF BODY OF API
4607: x_return_status := FND_API.G_RET_STS_SUCCESS;
4608:
4609: -- Standard call to get message count and if count is 1, get message info
4610: FND_MSG_PUB.Count_And_Get(
4611: p_encoded => FND_API.G_FALSE,
4612: p_count => x_msg_count,
4613: p_data => x_msg_data);

Line 4790: -- Standard start of API savepoint

4786: BEGIN
4787:
4788: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
4789:
4790: -- Standard start of API savepoint
4791: SAVEPOINT addMissingInstallment;
4792: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4793:
4794: -- Standard call to check for call compatibility

Line 4794: -- Standard call to check for call compatibility

4790: -- Standard start of API savepoint
4791: SAVEPOINT addMissingInstallment;
4792: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
4793:
4794: -- Standard call to check for call compatibility
4795: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4796: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4797: END IF;
4798:

Line 4911: -- Standard call to get message count and if count is 1, get message info

4907:
4908: -- END OF BODY OF API
4909: x_return_status := FND_API.G_RET_STS_SUCCESS;
4910:
4911: -- Standard call to get message count and if count is 1, get message info
4912: FND_MSG_PUB.Count_And_Get(
4913: p_encoded => FND_API.G_FALSE,
4914: p_count => x_msg_count,
4915: p_data => x_msg_data);

Line 5060: -- Standard start of API savepoint

5056: BEGIN
5057:
5058: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
5059:
5060: -- Standard start of API savepoint
5061: SAVEPOINT parseClob;
5062: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
5063:
5064: -- Standard call to check for call compatibility

Line 5064: -- Standard call to check for call compatibility

5060: -- Standard start of API savepoint
5061: SAVEPOINT parseClob;
5062: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
5063:
5064: -- Standard call to check for call compatibility
5065: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
5066: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
5067: END IF;
5068:

Line 5404: -- Standard call to get message count and if count is 1, get message info

5400:
5401: -- END OF BODY OF API
5402: x_return_status := FND_API.G_RET_STS_SUCCESS;
5403:
5404: -- Standard call to get message count and if count is 1, get message info
5405: FND_MSG_PUB.Count_And_Get(
5406: p_encoded => FND_API.G_FALSE,
5407: p_count => x_msg_count,
5408: p_data => x_msg_data);