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 69: || Return value: standard API outputs

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

Line 113: -- Standard Start of API savepoint

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

Line 203: -- Standard check for p_commit

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

Line 249: || Return value: standard API outputs

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

Line 571: || Return value: standard API outputs

567: ||
568: || Parameter: loan_id => loan id to customize
569: || p_custom_tbl => table of records about custom schedule
570: ||
571: || Return value: standard API outputs
572: ||
573: || Source Tables: NA
574: ||
575: || Target Tables: LNS_CUSTOM_PAYMENT_SCHEDULE

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

1457: ,t.CALCULATION_METHOD
1458: ,t.INTEREST_COMPOUNDING_FREQ
1459: ,nvl(t.CUSTOM_CALC_METHOD, 'NONE')
1460: -- ,nvl(t.CUSTOM_CALC_METHOD, decode(nvl(t.PAYMENT_CALC_METHOD, 'EQUAL_PAYMENT'), 'EQUAL_PAYMENT', 'EQUAL_PAYMENT',
1461: -- 'EQUAL_PAYMENT_STANDARD', 'EQUAL_PAYMENT', 'EQUAL_PRINCIPAL', 'EQUAL_PRINCIPAL', 'SEPARATE_SCHEDULES', 'EQUAL_PRINCIPAL'))
1462: ,t.ORIG_PAY_CALC_METHOD
1463: ,t.RATE_TYPE RATE_TYPE
1464: ,t.CEILING_RATE TERM_CEILING_RATE
1465: ,t.FLOOR_RATE TERM_FLOOR_RATE

Line 1685: -- Standard start of API savepoint

1681: BEGIN
1682:
1683: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
1684:
1685: -- Standard start of API savepoint
1686: SAVEPOINT loadCustomSchedule;
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
1688:
1689: -- Standard call to check for call compatibility

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

1685: -- Standard start of API savepoint
1686: SAVEPOINT loadCustomSchedule;
1687: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
1688:
1689: -- Standard call to check for call compatibility
1690: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1691: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1692: END IF;
1693:

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

1850:
1851: -- END OF BODY OF API
1852: x_return_status := FND_API.G_RET_STS_SUCCESS;
1853:
1854: -- Standard call to get message count and if count is 1, get message info
1855: FND_MSG_PUB.Count_And_Get(
1856: p_encoded => FND_API.G_FALSE,
1857: p_count => x_msg_count,
1858: p_data => x_msg_data);

Line 2007: -- Standard start of API savepoint

2003: BEGIN
2004:
2005: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
2006:
2007: -- Standard start of API savepoint
2008: SAVEPOINT recalcCustomSchedule;
2009: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2010:
2011: -- Standard call to check for call compatibility

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

2007: -- Standard start of API savepoint
2008: SAVEPOINT recalcCustomSchedule;
2009: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2010:
2011: -- Standard call to check for call compatibility
2012: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2013: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2014: END IF;
2015:

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

2770:
2771: -- END OF BODY OF API
2772: x_return_status := FND_API.G_RET_STS_SUCCESS;
2773:
2774: -- Standard call to get message count and if count is 1, get message info
2775: FND_MSG_PUB.Count_And_Get(
2776: p_encoded => FND_API.G_FALSE,
2777: p_count => x_msg_count,
2778: p_data => x_msg_data);

Line 2850: -- Standard start of API savepoint

2846: BEGIN
2847:
2848: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
2849:
2850: -- Standard start of API savepoint
2851: SAVEPOINT saveCustomSchedule;
2852: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2853:
2854: -- Standard call to check for call compatibility

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

2850: -- Standard start of API savepoint
2851: SAVEPOINT saveCustomSchedule;
2852: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
2853:
2854: -- Standard call to check for call compatibility
2855: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2856: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2857: END IF;
2858:

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

3065:
3066: -- END OF BODY OF API
3067: x_return_status := FND_API.G_RET_STS_SUCCESS;
3068:
3069: -- Standard call to get message count and if count is 1, get message info
3070: FND_MSG_PUB.Count_And_Get(
3071: p_encoded => FND_API.G_FALSE,
3072: p_count => x_msg_count,
3073: p_data => x_msg_data);

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

3096: END;
3097:
3098:
3099:
3100: -- This procedure switches back from custom schedule to standard schedule in one shot
3101: -- Conditions: loan status is INCOMPLETE and loan has been already customized
3102: procedure uncustomizeSchedule(
3103: P_API_VERSION IN NUMBER,
3104: P_INIT_MSG_LIST IN VARCHAR2,

Line 3141: -- Standard start of API savepoint

3137: BEGIN
3138:
3139: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3140:
3141: -- Standard start of API savepoint
3142: SAVEPOINT uncustomizeSchedule;
3143: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3144:
3145: -- Standard call to check for call compatibility

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

3141: -- Standard start of API savepoint
3142: SAVEPOINT uncustomizeSchedule;
3143: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3144:
3145: -- Standard call to check for call compatibility
3146: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3147: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3148: END IF;
3149:

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

3257:
3258: -- END OF BODY OF API
3259: x_return_status := FND_API.G_RET_STS_SUCCESS;
3260:
3261: -- Standard call to get message count and if count is 1, get message info
3262: FND_MSG_PUB.Count_And_Get(
3263: p_encoded => FND_API.G_FALSE,
3264: p_count => x_msg_count,
3265: p_data => x_msg_data);

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

3288: END;
3289:
3290:
3291:
3292: -- This procedure switches from standard schedule to custom schedule in one shot
3293: -- Conditions: loan status is INCOMPLETE and loan has not been customized yet
3294: procedure customizeSchedule(
3295: P_API_VERSION IN NUMBER,
3296: P_INIT_MSG_LIST IN VARCHAR2,

Line 3328: -- Standard start of API savepoint

3324: BEGIN
3325:
3326: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3327:
3328: -- Standard start of API savepoint
3329: SAVEPOINT customizeSchedule;
3330: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3331:
3332: -- Standard call to check for call compatibility

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

3328: -- Standard start of API savepoint
3329: SAVEPOINT customizeSchedule;
3330: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3331:
3332: -- Standard call to check for call compatibility
3333: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3334: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3335: END IF;
3336:

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

3407:
3408: -- END OF BODY OF API
3409: x_return_status := FND_API.G_RET_STS_SUCCESS;
3410:
3411: -- Standard call to get message count and if count is 1, get message info
3412: FND_MSG_PUB.Count_And_Get(
3413: p_encoded => FND_API.G_FALSE,
3414: p_count => x_msg_count,
3415: p_data => x_msg_data);

Line 3563: -- Standard start of API savepoint

3559: BEGIN
3560:
3561: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3562:
3563: -- Standard start of API savepoint
3564: SAVEPOINT shiftCustomSchedule;
3565: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3566:
3567: -- Standard call to check for call compatibility

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

3563: -- Standard start of API savepoint
3564: SAVEPOINT shiftCustomSchedule;
3565: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3566:
3567: -- Standard call to check for call compatibility
3568: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3570: END IF;
3571:

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

3663:
3664: -- END OF BODY OF API
3665: x_return_status := FND_API.G_RET_STS_SUCCESS;
3666:
3667: -- Standard call to get message count and if count is 1, get message info
3668: FND_MSG_PUB.Count_And_Get(
3669: p_encoded => FND_API.G_FALSE,
3670: p_count => x_msg_count,
3671: p_data => x_msg_data);

Line 3736: -- Standard start of API savepoint

3732: BEGIN
3733:
3734: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3735:
3736: -- Standard start of API savepoint
3737: SAVEPOINT reBuildCustomdSchedule;
3738: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3739:
3740: -- Standard call to check for call compatibility

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

3736: -- Standard start of API savepoint
3737: SAVEPOINT reBuildCustomdSchedule;
3738: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3739:
3740: -- Standard call to check for call compatibility
3741: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3742: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3743: END IF;
3744:

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

3790:
3791: -- END OF BODY OF API
3792: x_return_status := FND_API.G_RET_STS_SUCCESS;
3793:
3794: -- Standard call to get message count and if count is 1, get message info
3795: FND_MSG_PUB.Count_And_Get(
3796: p_encoded => FND_API.G_FALSE,
3797: p_count => x_msg_count,
3798: p_data => x_msg_data);

Line 3978: -- Standard start of API savepoint

3974: BEGIN
3975:
3976: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME, G_PKG_NAME || '.' || l_api_name || ' +');
3977:
3978: -- Standard start of API savepoint
3979: SAVEPOINT addMissingInstallment;
3980: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3981:
3982: -- Standard call to check for call compatibility

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

3978: -- Standard start of API savepoint
3979: SAVEPOINT addMissingInstallment;
3980: LogMessage(FND_LOG.LEVEL_STATEMENT, G_PKG_NAME, 'Savepoint is established');
3981:
3982: -- Standard call to check for call compatibility
3983: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3984: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3985: END IF;
3986:

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

4095:
4096: -- END OF BODY OF API
4097: x_return_status := FND_API.G_RET_STS_SUCCESS;
4098:
4099: -- Standard call to get message count and if count is 1, get message info
4100: FND_MSG_PUB.Count_And_Get(
4101: p_encoded => FND_API.G_FALSE,
4102: p_count => x_msg_count,
4103: p_data => x_msg_data);