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 113: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 131: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 180: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 193: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 243: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 262: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 313: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 326: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 379: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 395: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 447: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 460: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 512: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 528: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 581: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 599: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 650: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 670: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 723: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 740: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 824: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 849: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 932: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 957: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1039: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1064: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1116: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1135: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1204: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1229: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1281: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1300: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1369: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1394: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1445: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1464: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1533: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1558: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1610: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1629: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1697: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1722: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1773: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1792: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1860: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1885: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 1942: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 1976: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2065: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2089: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2145: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2179: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2266: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2290: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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

Line 2347: x_resultout := FND_API.G_RET_STS_SUCCESS;

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

Line 2381: x_resultout := FND_API.G_RET_STS_UNEXP_ERROR;

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