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_APPL_ENGINE_PUB dependencies on FND_API

Line 435: RAISE FND_API.G_EXC_ERROR;

431:
432: EXCEPTION
433: WHEN OTHERS THEN
434: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to add loan to all statement');
435: RAISE FND_API.G_EXC_ERROR;
436: END;
437:
438:
439:

Line 525: RAISE FND_API.G_EXC_ERROR;

521:
522: EXCEPTION
523: WHEN OTHERS THEN
524: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to add apply/unapply group tags loan to all statement');
525: RAISE FND_API.G_EXC_ERROR;
526: END;
527:
528:
529:

Line 702: RAISE FND_API.G_EXC_ERROR;

698:
699: EXCEPTION
700: WHEN OTHERS THEN
701: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Failed to generate application statement');
702: RAISE FND_API.G_EXC_ERROR;
703: END;
704:
705:
706:

Line 875: p_init_msg_list => FND_API.G_TRUE,

871: l_error := null;
872: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling ar_receipt_api_pub.unapply...');
873: ar_receipt_api_pub.unapply(
874: p_api_version => 1.0,
875: p_init_msg_list => FND_API.G_TRUE,
876: p_commit => FND_API.G_FALSE,
877: p_receivable_application_id => l_receivable_application_id,
878: x_return_status => l_return_status,
879: x_msg_count => l_msg_count,

Line 876: p_commit => FND_API.G_FALSE,

872: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling ar_receipt_api_pub.unapply...');
873: ar_receipt_api_pub.unapply(
874: p_api_version => 1.0,
875: p_init_msg_list => FND_API.G_TRUE,
876: p_commit => FND_API.G_FALSE,
877: p_receivable_application_id => l_receivable_application_id,
878: x_return_status => l_return_status,
879: x_msg_count => l_msg_count,
880: x_msg_data => l_msg_data);

Line 885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

881:
882: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
883: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);
884:
885: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
886: l_error := FND_MSG_PUB.Get(p_encoded => 'F');
887: end if;
888:
889: EXCEPTION

Line 891: l_return_status := FND_API.G_RET_STS_ERROR;

887: end if;
888:
889: EXCEPTION
890: WHEN OTHERS THEN
891: l_return_status := FND_API.G_RET_STS_ERROR;
892: l_error := SQLERRM;
893: END;
894:
895: LNS_APPL_ENGINE_PUB.BUILD_STMT(

Line 904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

900: P_RC_APPLY_AMOUNT => l_amount_applied_from,
901: P_ERROR => l_error,
902: P_ACTION => 'UNAPPLY');
903:
904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ar_receipt_api_pub.unapply failed');
906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Reported error: ' || l_error);
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;

Line 907: RAISE FND_API.G_EXC_ERROR;

903:
904: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
905: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'ar_receipt_api_pub.unapply failed');
906: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Reported error: ' || l_error);
907: RAISE FND_API.G_EXC_ERROR;
908: END IF;
909:
910: l_inv_count := l_inv_count + 1;
911: l_next_inv_appl_ok := 'N';

Line 937: RAISE FND_API.G_EXC_ERROR;

933: LNS_APPL_ENGINE_PUB.ADD_APPL_UNAPPL_TAGS(
934: P_ACTION_FLAG => 'UNAPPLY',
935: P_OPEN_CLOSE_FLAG => 'CLOSE');
936:
937: RAISE FND_API.G_EXC_ERROR;
938: END;
939:
940:
941:

Line 1151: ,P_INIT_MSG_LIST => FND_API.G_TRUE

1147:
1148: l_error := null;
1149: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling AR_RECEIPT_API_PUB.APPLY...');
1150: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1151: ,P_INIT_MSG_LIST => FND_API.G_TRUE
1152: ,P_COMMIT => FND_API.G_FALSE
1153: ,X_RETURN_STATUS => l_return_status
1154: ,X_MSG_COUNT => l_msg_count
1155: ,X_MSG_DATA => l_msg_data

Line 1152: ,P_COMMIT => FND_API.G_FALSE

1148: l_error := null;
1149: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Calling AR_RECEIPT_API_PUB.APPLY...');
1150: AR_RECEIPT_API_PUB.APPLY(P_API_VERSION => 1.0
1151: ,P_INIT_MSG_LIST => FND_API.G_TRUE
1152: ,P_COMMIT => FND_API.G_FALSE
1153: ,X_RETURN_STATUS => l_return_status
1154: ,X_MSG_COUNT => l_msg_count
1155: ,X_MSG_DATA => l_msg_data
1156: ,p_cash_receipt_id => P_RECEIPTS_TBL(l_Count1).RECEIPT_ID

Line 1167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1163:
1164: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_return_status: ' || l_return_status);
1165: LogMessage(FND_LOG.LEVEL_STATEMENT, 'l_msg_data: ' || l_msg_data);
1166:
1167: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1168: l_error := 'Failed to apply receipt ' || P_RECEIPTS_TBL(l_Count1).RECEIPT_NUMBER ||
1169: ' to invoice ' || P_LOAN_INVOICES_TBL(l_Count).TRX_NUMBER || ' (' ||
1170: P_LOAN_INVOICES_TBL(l_Count).INVOICE_TYPE_DESC || ') with error: ' || l_msg_data;
1171: END IF;

Line 1175: l_return_status := FND_API.G_RET_STS_ERROR;

1171: END IF;
1172:
1173: EXCEPTION
1174: WHEN OTHERS THEN
1175: l_return_status := FND_API.G_RET_STS_ERROR;
1176: l_error := 'Failed to apply receipt ' || P_RECEIPTS_TBL(l_Count1).RECEIPT_NUMBER ||
1177: ' to invoice ' || P_LOAN_INVOICES_TBL(l_Count).TRX_NUMBER || ' (' ||
1178: P_LOAN_INVOICES_TBL(l_Count).INVOICE_TYPE_DESC || ') with error: ' || SQLERRM;
1179: END;

Line 1196: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN

1192: P_RC_APPLY_AMOUNT => l_receipt_amount_from,
1193: P_ERROR => l_error,
1194: P_ACTION => 'APPLY');
1195:
1196: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_error);
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:

Line 1198: RAISE FND_API.G_EXC_ERROR;

1194: P_ACTION => 'APPLY');
1195:
1196: IF l_return_status <> FND_API.G_RET_STS_SUCCESS THEN
1197: LogMessage(FND_LOG.LEVEL_UNEXPECTED, l_error);
1198: RAISE FND_API.G_EXC_ERROR;
1199: END IF;
1200:
1201: P_LOAN_INVOICES_TBL(l_Count).REMAINING_AMOUNT := P_LOAN_INVOICES_TBL(l_Count).REMAINING_AMOUNT - l_apply_amount;
1202: P_RECEIPTS_TBL(l_Count1).REMAINING_AMOUNT := P_RECEIPTS_TBL(l_Count1).REMAINING_AMOUNT - l_receipt_amount_from;

Line 1225: RAISE FND_API.G_EXC_ERROR;

1221: end if;
1222:
1223: EXCEPTION
1224: WHEN OTHERS THEN
1225: RAISE FND_API.G_EXC_ERROR;
1226: END;
1227:
1228: END LOOP;
1229:

Line 1255: RAISE FND_API.G_EXC_ERROR;

1251: LNS_APPL_ENGINE_PUB.ADD_APPL_UNAPPL_TAGS(
1252: P_ACTION_FLAG => 'APPLY',
1253: P_OPEN_CLOSE_FLAG => 'CLOSE');
1254:
1255: RAISE FND_API.G_EXC_ERROR;
1256: END;
1257:
1258:
1259:

Line 1389: RAISE FND_API.G_EXC_ERROR;

1385:
1386: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
1387: FND_MSG_PUB.Add;
1388: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1389: RAISE FND_API.G_EXC_ERROR;
1390:
1391: end if;
1392:
1393: -- search for receipts

Line 1435: RAISE FND_API.G_EXC_ERROR;

1431:
1432: EXCEPTION
1433: WHEN OTHERS THEN
1434: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In ' || l_api_name || ' exception handling');
1435: RAISE FND_API.G_EXC_ERROR;
1436: END;
1437:
1438:
1439:

Line 1609: RAISE FND_API.G_EXC_ERROR;

1605:
1606: FND_MESSAGE.SET_NAME('LNS', 'LNS_NO_LOAN');
1607: FND_MSG_PUB.Add;
1608: LogMessage(FND_LOG.LEVEL_UNEXPECTED, FND_MSG_PUB.Get(p_encoded => 'F'));
1609: RAISE FND_API.G_EXC_ERROR;
1610:
1611: end if;
1612:
1613: -- get payment application order

Line 1788: RAISE FND_API.G_EXC_ERROR;

1784:
1785: EXCEPTION
1786: WHEN OTHERS THEN
1787: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'In ' || l_api_name || ' exception handling');
1788: RAISE FND_API.G_EXC_ERROR;
1789: END;
1790:
1791:
1792:

Line 1896: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

1892: SAVEPOINT SEARCH_AND_APPLY;
1893: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
1894:
1895: -- Standard call to check for call compatibility
1896: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:
1900: -- Initialize message list if p_init_msg_list is set to TRUE

Line 1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1893: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Savepoint is established');
1894:
1895: -- Standard call to check for call compatibility
1896: IF NOT FND_API.Compatible_API_Call(l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:
1900: -- Initialize message list if p_init_msg_list is set to TRUE
1901: IF FND_API.To_Boolean(p_init_msg_list) THEN

Line 1901: IF FND_API.To_Boolean(p_init_msg_list) THEN

1897: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1898: END IF;
1899:
1900: -- Initialize message list if p_init_msg_list is set to TRUE
1901: IF FND_API.To_Boolean(p_init_msg_list) THEN
1902: FND_MSG_PUB.initialize;
1903: END IF;
1904:
1905: -- Initialize API return status to success

Line 1906: l_return_status := FND_API.G_RET_STS_SUCCESS;

1902: FND_MSG_PUB.initialize;
1903: END IF;
1904:
1905: -- Initialize API return status to success
1906: l_return_status := FND_API.G_RET_STS_SUCCESS;
1907:
1908: -- START OF BODY OF API
1909:
1910: init;

Line 2006: if P_COMMIT = FND_API.G_TRUE then

2002: else
2003: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'No invoices found.');
2004: end if;
2005:
2006: if P_COMMIT = FND_API.G_TRUE then
2007: COMMIT WORK;
2008: LogMessage(FND_LOG.LEVEL_STATEMENT, 'Commited loan ' || l_LOAN_REC.LOAN_NUMBER);
2009: end if;
2010:

Line 2034: x_return_status := FND_API.G_RET_STS_SUCCESS;

2030: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Total processed ' || l_Count || ' loans');
2031: end if;
2032:
2033: -- END OF BODY OF API
2034: x_return_status := FND_API.G_RET_STS_SUCCESS;
2035:
2036: -- Standard call to get message count and if count is 1, get message info
2037: FND_MSG_PUB.Count_And_Get(
2038: p_encoded => FND_API.G_FALSE,

Line 2038: p_encoded => FND_API.G_FALSE,

2034: x_return_status := FND_API.G_RET_STS_SUCCESS;
2035:
2036: -- Standard call to get message count and if count is 1, get message info
2037: FND_MSG_PUB.Count_And_Get(
2038: p_encoded => FND_API.G_FALSE,
2039: p_count => x_msg_count,
2040: p_data => x_msg_data);
2041:
2042: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');

Line 2045: WHEN FND_API.G_EXC_ERROR THEN

2041:
2042: LogMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME || '.' || l_api_name || ' -');
2043:
2044: EXCEPTION
2045: WHEN FND_API.G_EXC_ERROR THEN
2046: ROLLBACK TO SEARCH_AND_APPLY;
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2049: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');

Line 2047: x_return_status := FND_API.G_RET_STS_ERROR;

2043:
2044: EXCEPTION
2045: WHEN FND_API.G_EXC_ERROR THEN
2046: ROLLBACK TO SEARCH_AND_APPLY;
2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2049: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
2050: g_cr_return_status := 'ERROR';
2051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2047: x_return_status := FND_API.G_RET_STS_ERROR;
2048: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2049: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
2050: g_cr_return_status := 'ERROR';
2051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2052: ROLLBACK TO SEARCH_AND_APPLY;
2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2055: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');

Line 2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2049: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
2050: g_cr_return_status := 'ERROR';
2051: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2052: ROLLBACK TO SEARCH_AND_APPLY;
2053: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2054: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);
2055: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
2056: g_cr_return_status := 'ERROR';
2057: WHEN OTHERS THEN

Line 2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;

2055: LogMessage(FND_LOG.LEVEL_UNEXPECTED, 'Rollbacked loans');
2056: g_cr_return_status := 'ERROR';
2057: WHEN OTHERS THEN
2058: ROLLBACK TO SEARCH_AND_APPLY;
2059: x_return_status := FND_API.G_RET_STS_UNEXP_ERROR;
2060: IF FND_MSG_PUB.Check_Msg_Level(FND_MSG_PUB.G_MSG_LVL_UNEXP_ERROR)THEN
2061: FND_MSG_PUB.Add_Exc_Msg(G_PKG_NAME, l_api_name);
2062: END IF;
2063: FND_MSG_PUB.Count_And_Get(p_count => x_msg_count, p_data => x_msg_data);

Line 2144: P_INIT_MSG_LIST => FND_API.G_TRUE,

2140: l_SEARCH_REC.UNAPPLY_FLAG := 'N'; --Hard coding the incorrect application to No always.
2141:
2142: LNS_APPL_ENGINE_PUB.SEARCH_AND_APPLY(
2143: P_API_VERSION => 1.0,
2144: P_INIT_MSG_LIST => FND_API.G_TRUE,
2145: P_COMMIT => FND_API.G_TRUE,
2146: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2147: P_SEARCH_REC => l_SEARCH_REC,
2148: X_RETURN_STATUS => RETCODE,

Line 2145: P_COMMIT => FND_API.G_TRUE,

2141:
2142: LNS_APPL_ENGINE_PUB.SEARCH_AND_APPLY(
2143: P_API_VERSION => 1.0,
2144: P_INIT_MSG_LIST => FND_API.G_TRUE,
2145: P_COMMIT => FND_API.G_TRUE,
2146: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2147: P_SEARCH_REC => l_SEARCH_REC,
2148: X_RETURN_STATUS => RETCODE,
2149: X_MSG_COUNT => l_msg_count,

Line 2146: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,

2142: LNS_APPL_ENGINE_PUB.SEARCH_AND_APPLY(
2143: P_API_VERSION => 1.0,
2144: P_INIT_MSG_LIST => FND_API.G_TRUE,
2145: P_COMMIT => FND_API.G_TRUE,
2146: P_VALIDATION_LEVEL => FND_API.G_VALID_LEVEL_FULL,
2147: P_SEARCH_REC => l_SEARCH_REC,
2148: X_RETURN_STATUS => RETCODE,
2149: X_MSG_COUNT => l_msg_count,
2150: X_MSG_DATA => ERRBUF);