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

Line 41: x_resultout := FND_API.G_RET_STS_SUCCESS;

37: l_loan_currency lns_loan_headers_all.loan_currency%TYPE ;
38:
39: BEGIN
40:
41: x_resultout := FND_API.G_RET_STS_SUCCESS;
42: BEGIN
43: SELECT requested_amount , loan_currency
44: INTO l_loan_req_amt , l_loan_currency
45: FROM lns_loan_headers_all

Line 57: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

53: EXCEPTION
54: WHEN NO_DATA_FOUND THEN
55: l_loan_req_amt := 0 ;
56: WHEN OTHERS THEN
57: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
58: x_errormsg := sqlerrm;
59: END;
60:
61:

Line 111: x_resultout := FND_API.G_RET_STS_SUCCESS;

107:
108:
109: BEGIN
110:
111: x_resultout := FND_API.G_RET_STS_SUCCESS;
112: BEGIN
113: SELECT loan_subtype
114: INTO l_loan_subtype
115: FROM lns_loan_headers_all

Line 129: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

125: EXCEPTION
126: WHEN NO_DATA_FOUND THEN
127: l_loan_secured := 'N' ;
128: WHEN OTHERS THEN
129: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
130: x_errormsg := sqlerrm;
131: END;
132:
133:

Line 178: x_resultout := FND_API.G_RET_STS_SUCCESS;

174:
175:
176: BEGIN
177:
178: x_resultout := FND_API.G_RET_STS_SUCCESS;
179: BEGIN
180: SELECT collateral_percent
181: INTO l_loan_collateral_perecent
182: FROM lns_loan_headers_all

Line 191: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

187: EXCEPTION
188: WHEN NO_DATA_FOUND THEN
189: l_loan_collateral_perecent := 0 ;
190: WHEN OTHERS THEN
191: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
192: x_errormsg := sqlerrm;
193: END;
194:
195:

Line 241: x_resultout := FND_API.G_RET_STS_SUCCESS;

237:
238:
239: BEGIN
240:
241: x_resultout := FND_API.G_RET_STS_SUCCESS;
242: BEGIN
243: SELECT lrs.current_interest_rate
244: INTO l_initial_interest_rate
245: FROM lns_rate_schedules lrs,

Line 260: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

256: EXCEPTION
257: WHEN NO_DATA_FOUND THEN
258: l_initial_interest_rate := 0 ;
259: WHEN OTHERS THEN
260: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
261: x_errormsg := sqlerrm;
262: END;
263:
264:

Line 311: x_resultout := FND_API.G_RET_STS_SUCCESS;

307:
308:
309: BEGIN
310:
311: x_resultout := FND_API.G_RET_STS_SUCCESS;
312: BEGIN
313: SELECT count(*)
314: INTO l_number_of_coborrowers
315: FROM LNS_PARTICIPANTS lp

Line 324: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

320: EXCEPTION
321: WHEN NO_DATA_FOUND THEN
322: l_number_of_coborrowers := 0;
323: WHEN OTHERS THEN
324: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
325: x_errormsg := sqlerrm;
326: END;
327:
328:

Line 377: x_resultout := FND_API.G_RET_STS_SUCCESS;

373:
374:
375: BEGIN
376:
377: x_resultout := FND_API.G_RET_STS_SUCCESS;
378: BEGIN
379: SELECT NVL ( (SELECT 'Y'
380: FROM DUAL
381: WHERE EXISTS ( SELECT null

Line 393: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

389: EXCEPTION
390: WHEN NO_DATA_FOUND THEN
391: l_is_having_coborrowers := 'N' ;
392: WHEN OTHERS THEN
393: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
394: x_errormsg := sqlerrm;
395: END;
396:
397:

Line 445: x_resultout := FND_API.G_RET_STS_SUCCESS;

441:
442:
443: BEGIN
444:
445: x_resultout := FND_API.G_RET_STS_SUCCESS;
446: BEGIN
447: SELECT count(*)
448: INTO l_number_of_guarantors
449: FROM LNS_PARTICIPANTS lp

Line 458: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

454: EXCEPTION
455: WHEN NO_DATA_FOUND THEN
456: l_number_of_guarantors := 0;
457: WHEN OTHERS THEN
458: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
459: x_errormsg := sqlerrm;
460: END;
461:
462:

Line 510: x_resultout := FND_API.G_RET_STS_SUCCESS;

506:
507:
508: BEGIN
509:
510: x_resultout := FND_API.G_RET_STS_SUCCESS;
511: BEGIN
512: SELECT NVL ( (SELECT 'Y'
513: FROM DUAL
514: WHERE EXISTS ( SELECT null

Line 526: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

522: EXCEPTION
523: WHEN NO_DATA_FOUND THEN
524: l_is_having_guarantors := 'N' ;
525: WHEN OTHERS THEN
526: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
527: x_errormsg := sqlerrm;
528: END;
529:
530:

Line 579: x_resultout := FND_API.G_RET_STS_SUCCESS;

575:
576:
577: BEGIN
578:
579: x_resultout := FND_API.G_RET_STS_SUCCESS;
580: BEGIN
581:
582: SELECT ( loan.requested_amount * nvl(loan.collateral_percent,0) / 100 ) ,
583: loan_currency

Line 597: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

593: EXCEPTION
594: WHEN NO_DATA_FOUND THEN
595: l_req_coll_amount := 0 ;
596: WHEN OTHERS THEN
597: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
598: x_errormsg := sqlerrm;
599: END;
600:
601:

Line 648: x_resultout := FND_API.G_RET_STS_SUCCESS;

644:
645:
646: BEGIN
647:
648: x_resultout := FND_API.G_RET_STS_SUCCESS;
649: BEGIN
650:
651: SELECT (select nvl(sum(laa.pledged_amount),0)
652: from lns_asset_assignments laa

Line 668: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

664: EXCEPTION
665: WHEN NO_DATA_FOUND THEN
666: l_total_coll_amount := 0 ;
667: WHEN OTHERS THEN
668: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
669: x_errormsg := sqlerrm;
670: END;
671:
672:

Line 721: x_resultout := FND_API.G_RET_STS_SUCCESS;

717:
718:
719: BEGIN
720:
721: x_resultout := FND_API.G_RET_STS_SUCCESS;
722: BEGIN
723: SELECT lt.delinquency_threshold_amount , llh.loan_currency
724: INTO l_deliquency_amount , l_loan_currency
725: FROM lns_terms lt , lns_loan_headers_all llh

Line 738: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

734: EXCEPTION
735: WHEN NO_DATA_FOUND THEN
736: l_deliquency_amount := 0 ;
737: WHEN OTHERS THEN
738: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
739: x_errormsg := sqlerrm;
740: END;
741:
742:

Line 822: x_resultout := FND_API.G_RET_STS_SUCCESS;

818:
819:
820: BEGIN
821:
822: x_resultout := FND_API.G_RET_STS_SUCCESS;
823: BEGIN
824:
825: l_total_assets_amount := 0 ;
826: OPEN party_total_assets(l_cr_loan_id , l_cr_party_id) ;

Line 847: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

843: EXCEPTION
844: WHEN NO_DATA_FOUND THEN
845: l_total_assets_amount := 0 ;
846: WHEN OTHERS THEN
847: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
848: x_errormsg := sqlerrm;
849: END;
850:
851:

Line 930: x_resultout := FND_API.G_RET_STS_SUCCESS;

926:
927:
928: BEGIN
929:
930: x_resultout := FND_API.G_RET_STS_SUCCESS;
931: BEGIN
932:
933: l_total_assets_pledged_amt := 0 ;
934: OPEN party_pledged_assets(l_cr_loan_id , l_cr_party_id) ;

Line 955: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

951: EXCEPTION
952: WHEN NO_DATA_FOUND THEN
953: l_total_assets_pledged_amt := 0 ;
954: WHEN OTHERS THEN
955: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
956: x_errormsg := sqlerrm;
957: END;
958:
959:

Line 1037: x_resultout := FND_API.G_RET_STS_SUCCESS;

1033:
1034:
1035: BEGIN
1036:
1037: x_resultout := FND_API.G_RET_STS_SUCCESS;
1038: BEGIN
1039:
1040: l_total_assets_available_amt := 0 ;
1041: OPEN party_available_assets(l_cr_loan_id , l_cr_party_id) ;

Line 1062: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1058: EXCEPTION
1059: WHEN NO_DATA_FOUND THEN
1060: l_total_assets_available_amt := 0 ;
1061: WHEN OTHERS THEN
1062: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1063: x_errormsg := sqlerrm;
1064: END;
1065:
1066:

Line 1114: x_resultout := FND_API.G_RET_STS_SUCCESS;

1110:
1111:
1112: BEGIN
1113:
1114: x_resultout := FND_API.G_RET_STS_SUCCESS;
1115: BEGIN
1116:
1117: SELECT count(*)
1118: INTO l_count_active_loans

Line 1133: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1129: EXCEPTION
1130: WHEN NO_DATA_FOUND THEN
1131: l_count_active_loans := 0 ;
1132: WHEN OTHERS THEN
1133: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1134: x_errormsg := sqlerrm;
1135: END;
1136:
1137:

Line 1202: x_resultout := FND_API.G_RET_STS_SUCCESS;

1198:
1199:
1200: BEGIN
1201:
1202: x_resultout := FND_API.G_RET_STS_SUCCESS;
1203: BEGIN
1204:
1205: l_total_balance_amt := 0 ;
1206: OPEN active_loans_balance(l_cr_party_id) ;

Line 1227: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1223: EXCEPTION
1224: WHEN NO_DATA_FOUND THEN
1225: l_total_balance_amt := 0 ;
1226: WHEN OTHERS THEN
1227: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1228: x_errormsg := sqlerrm;
1229: END;
1230:
1231:

Line 1279: x_resultout := FND_API.G_RET_STS_SUCCESS;

1275:
1276:
1277: BEGIN
1278:
1279: x_resultout := FND_API.G_RET_STS_SUCCESS;
1280: BEGIN
1281:
1282: SELECT count(*)
1283: INTO l_count_pending_loans

Line 1298: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1294: EXCEPTION
1295: WHEN NO_DATA_FOUND THEN
1296: l_count_pending_loans := 0 ;
1297: WHEN OTHERS THEN
1298: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1299: x_errormsg := sqlerrm;
1300: END;
1301:
1302:

Line 1367: x_resultout := FND_API.G_RET_STS_SUCCESS;

1363:
1364:
1365: BEGIN
1366:
1367: x_resultout := FND_API.G_RET_STS_SUCCESS;
1368: BEGIN
1369:
1370: l_total_balance_amt := 0 ;
1371: OPEN pending_loans_balance(l_cr_party_id) ;

Line 1392: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1388: EXCEPTION
1389: WHEN NO_DATA_FOUND THEN
1390: l_total_balance_amt := 0 ;
1391: WHEN OTHERS THEN
1392: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1393: x_errormsg := sqlerrm;
1394: END;
1395:
1396:

Line 1443: x_resultout := FND_API.G_RET_STS_SUCCESS;

1439:
1440:
1441: BEGIN
1442:
1443: x_resultout := FND_API.G_RET_STS_SUCCESS;
1444: BEGIN
1445:
1446: SELECT count(*)
1447: INTO l_count_delinquent_loans

Line 1462: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1458: EXCEPTION
1459: WHEN NO_DATA_FOUND THEN
1460: l_count_delinquent_loans := 0 ;
1461: WHEN OTHERS THEN
1462: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1463: x_errormsg := sqlerrm;
1464: END;
1465:
1466:

Line 1531: x_resultout := FND_API.G_RET_STS_SUCCESS;

1527:
1528:
1529: BEGIN
1530:
1531: x_resultout := FND_API.G_RET_STS_SUCCESS;
1532: BEGIN
1533:
1534: l_total_balance_amt := 0 ;
1535: OPEN delinquent_loans_balance(l_cr_party_id) ;

Line 1556: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1552: EXCEPTION
1553: WHEN NO_DATA_FOUND THEN
1554: l_total_balance_amt := 0 ;
1555: WHEN OTHERS THEN
1556: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1557: x_errormsg := sqlerrm;
1558: END;
1559:
1560:

Line 1608: x_resultout := FND_API.G_RET_STS_SUCCESS;

1604:
1605:
1606: BEGIN
1607:
1608: x_resultout := FND_API.G_RET_STS_SUCCESS;
1609: BEGIN
1610:
1611: SELECT count(*)
1612: INTO l_count_default_loans

Line 1627: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1623: EXCEPTION
1624: WHEN NO_DATA_FOUND THEN
1625: l_count_default_loans := 0 ;
1626: WHEN OTHERS THEN
1627: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1628: x_errormsg := sqlerrm;
1629: END;
1630:
1631:

Line 1695: x_resultout := FND_API.G_RET_STS_SUCCESS;

1691:
1692:
1693: BEGIN
1694:
1695: x_resultout := FND_API.G_RET_STS_SUCCESS;
1696: BEGIN
1697:
1698: l_total_balance_amt := 0 ;
1699: OPEN default_loans_balance(l_cr_party_id) ;

Line 1720: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1716: EXCEPTION
1717: WHEN NO_DATA_FOUND THEN
1718: l_total_balance_amt := 0 ;
1719: WHEN OTHERS THEN
1720: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1721: x_errormsg := sqlerrm;
1722: END;
1723:
1724:

Line 1771: x_resultout := FND_API.G_RET_STS_SUCCESS;

1767:
1768:
1769: BEGIN
1770:
1771: x_resultout := FND_API.G_RET_STS_SUCCESS;
1772: BEGIN
1773:
1774: SELECT count(*)
1775: INTO l_count_paidoff_loans

Line 1790: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1786: EXCEPTION
1787: WHEN NO_DATA_FOUND THEN
1788: l_count_paidoff_loans := 0 ;
1789: WHEN OTHERS THEN
1790: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1791: x_errormsg := sqlerrm;
1792: END;
1793:
1794:

Line 1858: x_resultout := FND_API.G_RET_STS_SUCCESS;

1854:
1855:
1856: BEGIN
1857:
1858: x_resultout := FND_API.G_RET_STS_SUCCESS;
1859: BEGIN
1860:
1861: l_total_balance_amt := 0 ;
1862: OPEN paidoff_loans_balance(l_cr_party_id) ;

Line 1883: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1879: EXCEPTION
1880: WHEN NO_DATA_FOUND THEN
1881: l_total_balance_amt := 0 ;
1882: WHEN OTHERS THEN
1883: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1884: x_errormsg := sqlerrm;
1885: END;
1886:
1887:

Line 1940: x_resultout := FND_API.G_RET_STS_SUCCESS;

1936:
1937:
1938: BEGIN
1939:
1940: x_resultout := FND_API.G_RET_STS_SUCCESS;
1941: BEGIN
1942:
1943: SELECT count(*)
1944: INTO l_total_active_loans

Line 1974: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

1970: EXCEPTION
1971: WHEN NO_DATA_FOUND THEN
1972: l_total_active_loans := 0 ;
1973: WHEN OTHERS THEN
1974: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
1975: x_errormsg := sqlerrm;
1976: END;
1977:
1978:

Line 2063: x_resultout := FND_API.G_RET_STS_SUCCESS;

2059:
2060:
2061: BEGIN
2062:
2063: x_resultout := FND_API.G_RET_STS_SUCCESS;
2064: BEGIN
2065:
2066: l_total_balance_amt := 0 ;
2067: OPEN total_active_loans_balance(l_cr_loan_id ,l_cr_party_id) ;

Line 2087: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2083: EXCEPTION
2084: WHEN NO_DATA_FOUND THEN
2085: l_total_balance_amt := 0 ;
2086: WHEN OTHERS THEN
2087: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2088: x_errormsg := sqlerrm;
2089: END;
2090:
2091:

Line 2143: x_resultout := FND_API.G_RET_STS_SUCCESS;

2139:
2140:
2141: BEGIN
2142:
2143: x_resultout := FND_API.G_RET_STS_SUCCESS;
2144: BEGIN
2145:
2146: SELECT count(*)
2147: INTO l_total_deliquent_loans

Line 2177: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2173: EXCEPTION
2174: WHEN NO_DATA_FOUND THEN
2175: l_total_deliquent_loans := 0 ;
2176: WHEN OTHERS THEN
2177: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2178: x_errormsg := sqlerrm;
2179: END;
2180:
2181:

Line 2264: x_resultout := FND_API.G_RET_STS_SUCCESS;

2260:
2261:
2262: BEGIN
2263:
2264: x_resultout := FND_API.G_RET_STS_SUCCESS;
2265: BEGIN
2266:
2267: l_total_overdue_amt := 0 ;
2268: OPEN total_active_loans_overdue(l_cr_loan_id ,l_cr_party_id) ;

Line 2288: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2284: EXCEPTION
2285: WHEN NO_DATA_FOUND THEN
2286: l_total_overdue_amt := 0 ;
2287: WHEN OTHERS THEN
2288: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2289: x_errormsg := sqlerrm;
2290: END;
2291:
2292:

Line 2345: x_resultout := FND_API.G_RET_STS_SUCCESS;

2341:
2342:
2343: BEGIN
2344:
2345: x_resultout := FND_API.G_RET_STS_SUCCESS;
2346: BEGIN
2347:
2348: SELECT count(*)
2349: INTO l_total_default_loans

Line 2379: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

2375: EXCEPTION
2376: WHEN NO_DATA_FOUND THEN
2377: l_total_default_loans := 0 ;
2378: WHEN OTHERS THEN
2379: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;
2380: x_errormsg := sqlerrm;
2381: END;
2382:
2383: