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.OKL_CONTRACT_INFO dependencies on OKC_API

Line 53: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

49:
50: RETURN l_return_status;
51: EXCEPTION
52: WHEN okl_api.G_EXCEPTION_ERROR THEN
53: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
54: ,p_msg_name => G_ERROR
55: ,p_token1 => G_SQLCODE_TOKEN
56: ,p_token1_value => SQLCODE
57: ,p_token2 => G_SQLERRM_TOKEN

Line 59: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

55: ,p_token1 => G_SQLCODE_TOKEN
56: ,p_token1_value => SQLCODE
57: ,p_token2 => G_SQLERRM_TOKEN
58: ,p_token2_value => SQLERRM);
59: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
60: RETURN(l_return_status);
61:
62: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
63: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 63: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

59: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
60: RETURN(l_return_status);
61:
62: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
63: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
64: ,p_msg_name => G_UNEXPECTED_ERROR
65: ,p_token1 => G_SQLCODE_TOKEN
66: ,p_token1_value => SQLCODE
67: ,p_token2 => G_SQLERRM_TOKEN

Line 69: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

65: ,p_token1 => G_SQLCODE_TOKEN
66: ,p_token1_value => SQLCODE
67: ,p_token2 => G_SQLERRM_TOKEN
68: ,p_token2_value => SQLERRM);
69: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
70: RETURN(l_return_status);
71:
72: WHEN OTHERS THEN
73: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 73: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

69: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
70: RETURN(l_return_status);
71:
72: WHEN OTHERS THEN
73: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
74: ,p_msg_name => G_UNEXPECTED_ERROR
75: ,p_token1 => G_SQLCODE_TOKEN
76: ,p_token1_value => SQLCODE
77: ,p_token2 => G_SQLERRM_TOKEN

Line 79: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

75: ,p_token1 => G_SQLCODE_TOKEN
76: ,p_token1_value => SQLCODE
77: ,p_token2 => G_SQLERRM_TOKEN
78: ,p_token2_value => SQLERRM);
79: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
80: RETURN(l_return_status);
81:
82: END get_customer;
83:

Line 117: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

113:
114: RETURN l_return_status;
115: EXCEPTION
116: WHEN OTHERS THEN
117: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
118: ,p_msg_name => G_UNEXPECTED_ERROR
119: ,p_token1 => G_SQLCODE_TOKEN
120: ,p_token1_value => SQLCODE
121: ,p_token2 => G_SQLERRM_TOKEN

Line 123: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

119: ,p_token1 => G_SQLCODE_TOKEN
120: ,p_token1_value => SQLCODE
121: ,p_token2 => G_SQLERRM_TOKEN
122: ,p_token2_value => SQLERRM);
123: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
124: RETURN(l_return_status);
125:
126: END get_vendor_program;
127:

Line 160: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

156:
157: RETURN l_return_status;
158: EXCEPTION
159: WHEN OTHERS THEN
160: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
161: ,p_msg_name => G_UNEXPECTED_ERROR
162: ,p_token1 => G_SQLCODE_TOKEN
163: ,p_token1_value => SQLCODE
164: ,p_token2 => G_SQLERRM_TOKEN

Line 166: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

162: ,p_token1 => G_SQLCODE_TOKEN
163: ,p_token1_value => SQLCODE
164: ,p_token2 => G_SQLERRM_TOKEN
165: ,p_token2_value => SQLERRM);
166: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
167: RETURN(l_return_status);
168:
169: END get_bill_to_address;
170:

Line 221: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

217:
218: RETURN l_return_status;
219: EXCEPTION
220: WHEN okl_api.G_EXCEPTION_ERROR THEN
221: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
222: ,p_msg_name => G_ERROR
223: ,p_token1 => G_SQLCODE_TOKEN
224: ,p_token1_value => SQLCODE
225: ,p_token2 => G_SQLERRM_TOKEN

Line 227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

223: ,p_token1 => G_SQLCODE_TOKEN
224: ,p_token1_value => SQLCODE
225: ,p_token2 => G_SQLERRM_TOKEN
226: ,p_token2_value => SQLERRM);
227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: RETURN(l_return_status);
229:
230: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
231: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 231: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

227: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
228: RETURN(l_return_status);
229:
230: WHEN okl_api.G_EXCEPTION_UNEXPECTED_ERROR THEN
231: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
232: ,p_msg_name => G_UNEXPECTED_ERROR
233: ,p_token1 => G_SQLCODE_TOKEN
234: ,p_token1_value => SQLCODE
235: ,p_token2 => G_SQLERRM_TOKEN

Line 237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

233: ,p_token1 => G_SQLCODE_TOKEN
234: ,p_token1_value => SQLCODE
235: ,p_token2 => G_SQLERRM_TOKEN
236: ,p_token2_value => SQLERRM);
237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
238: RETURN(l_return_status);
239:
240: WHEN OTHERS THEN
241: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

Line 241: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

237: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
238: RETURN(l_return_status);
239:
240: WHEN OTHERS THEN
241: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
242: ,p_msg_name => G_UNEXPECTED_ERROR
243: ,p_token1 => G_SQLCODE_TOKEN
244: ,p_token1_value => SQLCODE
245: ,p_token2 => G_SQLERRM_TOKEN

Line 247: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

243: ,p_token1 => G_SQLCODE_TOKEN
244: ,p_token1_value => SQLCODE
245: ,p_token2 => G_SQLERRM_TOKEN
246: ,p_token2_value => SQLERRM);
247: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
248: RETURN(l_return_status);
249:
250: END get_private_label;
251:

Line 298: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

294:
295: RETURN l_return_status;
296: EXCEPTION
297: WHEN OTHERS THEN
298: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
299: ,p_msg_name => G_UNEXPECTED_ERROR
300: ,p_token1 => G_SQLCODE_TOKEN
301: ,p_token1_value => SQLCODE
302: ,p_token2 => G_SQLERRM_TOKEN

Line 304: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

300: ,p_token1 => G_SQLCODE_TOKEN
301: ,p_token1_value => SQLCODE
302: ,p_token2 => G_SQLERRM_TOKEN
303: ,p_token2_value => SQLERRM);
304: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
305: RETURN(l_return_status);
306:
307: END get_non_notify_flag;
308:

Line 339: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

335:
336: RETURN l_return_status;
337: EXCEPTION
338: WHEN OTHERS THEN
339: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
340: ,p_msg_name => G_UNEXPECTED_ERROR
341: ,p_token1 => G_SQLCODE_TOKEN
342: ,p_token1_value => SQLCODE
343: ,p_token2 => G_SQLERRM_TOKEN

Line 345: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

341: ,p_token1 => G_SQLCODE_TOKEN
342: ,p_token1_value => SQLCODE
343: ,p_token2 => G_SQLERRM_TOKEN
344: ,p_token2_value => SQLERRM);
345: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
346: RETURN(l_return_status);
347:
348: END get_currency;
349:

Line 400: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

396:
397: RETURN l_return_status;
398: EXCEPTION
399: WHEN OTHERS THEN
400: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
401: ,p_msg_name => G_UNEXPECTED_ERROR
402: ,p_token1 => G_SQLCODE_TOKEN
403: ,p_token1_value => SQLCODE
404: ,p_token2 => G_SQLERRM_TOKEN

Line 406: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

402: ,p_token1 => G_SQLCODE_TOKEN
403: ,p_token1_value => SQLCODE
404: ,p_token2 => G_SQLERRM_TOKEN
405: ,p_token2_value => SQLERRM);
406: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
407: RETURN(l_return_status);
408:
409: END get_syndicate_flag;
410:

Line 440: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

436: RETURN l_return_status;
437:
438: EXCEPTION
439: WHEN OTHERS THEN
440: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
441: ,p_msg_name => G_UNEXPECTED_ERROR
442: ,p_token1 => G_SQLCODE_TOKEN
443: ,p_token1_value => SQLCODE
444: ,p_token2 => G_SQLERRM_TOKEN

Line 446: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

442: ,p_token1 => G_SQLCODE_TOKEN
443: ,p_token1_value => SQLCODE
444: ,p_token2 => G_SQLERRM_TOKEN
445: ,p_token2_value => SQLERRM);
446: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
447: RETURN(l_return_status);
448:
449: END GET_ORG_ID;
450:

Line 495: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

491: RETURN l_return_status;
492:
493: EXCEPTION
494: WHEN OTHERS THEN
495: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
496: ,p_msg_name => G_UNEXPECTED_ERROR
497: ,p_token1 => G_SQLCODE_TOKEN
498: ,p_token1_value => SQLCODE
499: ,p_token2 => G_SQLERRM_TOKEN

Line 501: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

497: ,p_token1 => G_SQLCODE_TOKEN
498: ,p_token1_value => SQLCODE
499: ,p_token2 => G_SQLERRM_TOKEN
500: ,p_token2_value => SQLERRM);
501: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
502: RETURN(l_return_status);
503:
504: END get_remaining_payments;
505:

Line 571: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

567: RETURN l_return_status;
568:
569: EXCEPTION
570: WHEN OTHERS THEN
571: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
572: ,p_msg_name => G_UNEXPECTED_ERROR
573: ,p_token1 => G_SQLCODE_TOKEN
574: ,p_token1_value => SQLCODE
575: ,p_token2 => G_SQLERRM_TOKEN

Line 577: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

573: ,p_token1 => G_SQLCODE_TOKEN
574: ,p_token1_value => SQLCODE
575: ,p_token2 => G_SQLERRM_TOKEN
576: ,p_token2_value => SQLERRM);
577: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
578: RETURN(l_return_status);
579:
580: END get_rule_value;
581:

Line 647: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

643: RETURN l_return_status;
644:
645: EXCEPTION
646: WHEN OTHERS THEN
647: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
648: ,p_msg_name => G_UNEXPECTED_ERROR
649: ,p_token1 => G_SQLCODE_TOKEN
650: ,p_token1_value => SQLCODE
651: ,p_token2 => G_SQLERRM_TOKEN

Line 653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

649: ,p_token1 => G_SQLCODE_TOKEN
650: ,p_token1_value => SQLCODE
651: ,p_token2 => G_SQLERRM_TOKEN
652: ,p_token2_value => SQLERRM);
653: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
654: RETURN(l_return_status);
655:
656: END get_rule_value;
657:

Line 716: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

712: RETURN l_return_status;
713:
714: EXCEPTION
715: WHEN OTHERS THEN
716: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
717: ,p_msg_name => G_UNEXPECTED_ERROR
718: ,p_token1 => G_SQLCODE_TOKEN
719: ,p_token1_value => SQLCODE
720: ,p_token2 => G_SQLERRM_TOKEN

Line 722: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

718: ,p_token1 => G_SQLCODE_TOKEN
719: ,p_token1_value => SQLCODE
720: ,p_token2 => G_SQLERRM_TOKEN
721: ,p_token2_value => SQLERRM);
722: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
723: RETURN(l_return_status);
724:
725: END get_days_past_due;
726:

Line 804: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

800: RETURN l_return_status;
801:
802: EXCEPTION
803: WHEN OTHERS THEN
804: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
805: ,p_msg_name => G_UNEXPECTED_ERROR
806: ,p_token1 => G_SQLCODE_TOKEN
807: ,p_token1_value => SQLCODE
808: ,p_token2 => G_SQLERRM_TOKEN

Line 810: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

806: ,p_token1 => G_SQLCODE_TOKEN
807: ,p_token1_value => SQLCODE
808: ,p_token2 => G_SQLERRM_TOKEN
809: ,p_token2_value => SQLERRM);
810: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
811: RETURN(l_return_status);
812:
813: END get_amount_past_due;
814:

Line 898: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

894: CLOSE next_due_csr;
895: RETURN l_return_status;
896: EXCEPTION
897: WHEN OTHERS THEN
898: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
899: ,p_msg_name => G_UNEXPECTED_ERROR
900: ,p_token1 => G_SQLCODE_TOKEN
901: ,p_token1_value => SQLCODE
902: ,p_token2 => G_SQLERRM_TOKEN

Line 904: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

900: ,p_token1 => G_SQLCODE_TOKEN
901: ,p_token1_value => SQLCODE
902: ,p_token2 => G_SQLERRM_TOKEN
903: ,p_token2_value => SQLERRM);
904: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
905: END;
906:
907: ---------------------------------------------------------------------------
908: -- FUNCTION get last due amount,dates

Line 989: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

985: CLOSE last_due_csr;
986: RETURN l_return_status;
987: EXCEPTION
988: WHEN OTHERS THEN
989: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
990: ,p_msg_name => G_UNEXPECTED_ERROR
991: ,p_token1 => G_SQLCODE_TOKEN
992: ,p_token1_value => SQLCODE
993: ,p_token2 => G_SQLERRM_TOKEN

Line 995: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

991: ,p_token1 => G_SQLCODE_TOKEN
992: ,p_token1_value => SQLCODE
993: ,p_token2 => G_SQLERRM_TOKEN
994: ,p_token2_value => SQLERRM);
995: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
996: END;
997:
998: ---------------------------------------------------------------------------
999: -- FUNCTION Total asset cost for contract

Line 1033: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1029: CLOSE asset_cost_csr;
1030: RETURN l_return_status;
1031: EXCEPTION
1032: WHEN OTHERS THEN
1033: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1034: ,p_msg_name => G_UNEXPECTED_ERROR
1035: ,p_token1 => G_SQLCODE_TOKEN
1036: ,p_token1_value => SQLCODE
1037: ,p_token2 => G_SQLERRM_TOKEN

Line 1039: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1035: ,p_token1 => G_SQLCODE_TOKEN
1036: ,p_token1_value => SQLCODE
1037: ,p_token2 => G_SQLERRM_TOKEN
1038: ,p_token2_value => SQLERRM);
1039: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1040: END;
1041:
1042: ---------------------------------------------------------------------------
1043: -- FUNCTION Total out standing receivables for contract

Line 1124: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1120:
1121: RETURN l_return_status;
1122: EXCEPTION
1123: WHEN OTHERS THEN
1124: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1125: ,p_msg_name => G_UNEXPECTED_ERROR
1126: ,p_token1 => G_SQLCODE_TOKEN
1127: ,p_token1_value => SQLCODE
1128: ,p_token2 => G_SQLERRM_TOKEN

Line 1130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1126: ,p_token1 => G_SQLCODE_TOKEN
1127: ,p_token1_value => SQLCODE
1128: ,p_token2 => G_SQLERRM_TOKEN
1129: ,p_token2_value => SQLERRM);
1130: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1131: END;
1132:
1133: ---------------------------------------------------------------------------
1134: -- FUNCTION Term of contract in months,start date ,end date

Line 1160: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1156: CLOSE contract_dates_csr ;
1157: RETURN l_return_status;
1158: EXCEPTION
1159: WHEN OTHERS THEN
1160: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1161: ,p_msg_name => G_UNEXPECTED_ERROR
1162: ,p_token1 => G_SQLCODE_TOKEN
1163: ,p_token1_value => SQLCODE
1164: ,p_token2 => G_SQLERRM_TOKEN

Line 1166: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1162: ,p_token1 => G_SQLCODE_TOKEN
1163: ,p_token1_value => SQLCODE
1164: ,p_token2 => G_SQLERRM_TOKEN
1165: ,p_token2_value => SQLERRM);
1166: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1167: END;
1168:
1169: ---------------------------------------------------------------------------
1170: -- FUNCTION Net investment for contract

Line 1223: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1219: x_net_investment := l_return_rent + l_return_residual - l_return_unearned;
1220: RETURN l_return_status;
1221: EXCEPTION
1222: WHEN OTHERS THEN
1223: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1224: ,p_msg_name => G_UNEXPECTED_ERROR
1225: ,p_token1 => G_SQLCODE_TOKEN
1226: ,p_token1_value => SQLCODE
1227: ,p_token2 => G_SQLERRM_TOKEN

Line 1229: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1225: ,p_token1 => G_SQLCODE_TOKEN
1226: ,p_token1_value => SQLCODE
1227: ,p_token2 => G_SQLERRM_TOKEN
1228: ,p_token2_value => SQLERRM);
1229: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1230: END;
1231:
1232: ---------------------------------------------------------------------------
1233: -- FUNCTION Advance rent,Security deposit,interest type for contract

Line 1301: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1297: CLOSE Interest_type_csr;
1298: RETURN l_return_status;
1299: EXCEPTION
1300: WHEN OTHERS THEN
1301: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1302: ,p_msg_name => G_UNEXPECTED_ERROR
1303: ,p_token1 => G_SQLCODE_TOKEN
1304: ,p_token1_value => SQLCODE
1305: ,p_token2 => G_SQLERRM_TOKEN

Line 1307: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1303: ,p_token1 => G_SQLCODE_TOKEN
1304: ,p_token1_value => SQLCODE
1305: ,p_token2 => G_SQLERRM_TOKEN
1306: ,p_token2_value => SQLERRM);
1307: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1308: END;
1309:
1310: ---------------------------------------------------------------------------
1311: -- FUNCTION get_insurance_lapse

Line 1345: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1341:
1342: RETURN l_return_status;
1343: EXCEPTION
1344: WHEN OTHERS THEN
1345: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1346: ,p_msg_name => G_UNEXPECTED_ERROR
1347: ,p_token1 => G_SQLCODE_TOKEN
1348: ,p_token1_value => SQLCODE
1349: ,p_token2 => G_SQLERRM_TOKEN

Line 1351: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1347: ,p_token1 => G_SQLCODE_TOKEN
1348: ,p_token1_value => SQLCODE
1349: ,p_token2 => G_SQLERRM_TOKEN
1350: ,p_token2_value => SQLERRM);
1351: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1352: RETURN(l_return_status);
1353:
1354: END get_insurance_lapse;
1355:

Line 1390: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1386:
1387: RETURN l_return_status;
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1391: ,p_msg_name => G_UNEXPECTED_ERROR
1392: ,p_token1 => G_SQLCODE_TOKEN
1393: ,p_token1_value => SQLCODE
1394: ,p_token2 => G_SQLERRM_TOKEN

Line 1396: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1392: ,p_token1 => G_SQLCODE_TOKEN
1393: ,p_token1_value => SQLCODE
1394: ,p_token2 => G_SQLERRM_TOKEN
1395: ,p_token2_value => SQLERRM);
1396: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1397: RETURN(l_return_status);
1398:
1399: END get_unrefunded_cures;*/
1400:

Line 1424: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1420:
1421: RETURN l_return_status;
1422: EXCEPTION
1423: WHEN OTHERS THEN
1424: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1425: ,p_msg_name => G_UNEXPECTED_ERROR
1426: ,p_token1 => G_SQLCODE_TOKEN
1427: ,p_token1_value => SQLCODE
1428: ,p_token2 => G_SQLERRM_TOKEN

Line 1430: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1426: ,p_token1 => G_SQLCODE_TOKEN
1427: ,p_token1_value => SQLCODE
1428: ,p_token2 => G_SQLERRM_TOKEN
1429: ,p_token2_value => SQLERRM);
1430: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1431: RETURN(l_return_status);
1432:
1433: END get_fair_market_value;
1434:

Line 1493: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1489:
1490: EXCEPTION
1491: WHEN OTHERS THEN
1492: CLOSE deal_type;
1493: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1494: ,p_msg_name => G_UNEXPECTED_ERROR
1495: ,p_token1 => G_SQLCODE_TOKEN
1496: ,p_token1_value => SQLCODE
1497: ,p_token2 => G_SQLERRM_TOKEN

Line 1499: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1495: ,p_token1 => G_SQLCODE_TOKEN
1496: ,p_token1_value => SQLCODE
1497: ,p_token2 => G_SQLERRM_TOKEN
1498: ,p_token2_value => SQLERRM);
1499: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1500: x_net_book_value :=0;
1501: RETURN(l_return_status);
1502:
1503: END get_net_book_value;

Line 1530: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1526:
1527: RETURN l_return_status;
1528: EXCEPTION
1529: WHEN OTHERS THEN
1530: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1531: ,p_msg_name => G_UNEXPECTED_ERROR
1532: ,p_token1 => G_SQLCODE_TOKEN
1533: ,p_token1_value => SQLCODE
1534: ,p_token2 => G_SQLERRM_TOKEN

Line 1536: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1532: ,p_token1 => G_SQLCODE_TOKEN
1533: ,p_token1_value => SQLCODE
1534: ,p_token2 => G_SQLERRM_TOKEN
1535: ,p_token2_value => SQLERRM);
1536: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1537: RETURN(l_return_status);
1538:
1539: END get_interest;
1540:

Line 1567: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1563:
1564: RETURN l_return_status;
1565: EXCEPTION
1566: WHEN OTHERS THEN
1567: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1568: ,p_msg_name => G_UNEXPECTED_ERROR
1569: ,p_token1 => G_SQLCODE_TOKEN
1570: ,p_token1_value => SQLCODE
1571: ,p_token2 => G_SQLERRM_TOKEN

Line 1573: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1569: ,p_token1 => G_SQLCODE_TOKEN
1570: ,p_token1_value => SQLCODE
1571: ,p_token2 => G_SQLERRM_TOKEN
1572: ,p_token2_value => SQLERRM);
1573: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1574: RETURN(l_return_status);
1575:
1576: END get_immediate_repurchase_yn;
1577:

Line 1612: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1608: RETURN l_asset_value;
1609:
1610: EXCEPTION
1611: WHEN OTHERS THEN
1612: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1613: ,p_msg_name => G_UNEXPECTED_ERROR
1614: ,p_token1 => G_SQLCODE_TOKEN
1615: ,p_token1_value => SQLCODE
1616: ,p_token2 => G_SQLERRM_TOKEN

Line 1648: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME

1644:
1645: RETURN l_return_status;
1646: EXCEPTION
1647: WHEN OTHERS THEN
1648: OKC_API.SET_MESSAGE( p_app_name => G_APP_NAME
1649: ,p_msg_name => G_UNEXPECTED_ERROR
1650: ,p_token1 => G_SQLCODE_TOKEN
1651: ,p_token1_value => SQLCODE
1652: ,p_token2 => G_SQLERRM_TOKEN

Line 1654: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

1650: ,p_token1 => G_SQLCODE_TOKEN
1651: ,p_token1_value => SQLCODE
1652: ,p_token2 => G_SQLERRM_TOKEN
1653: ,p_token2_value => SQLERRM);
1654: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
1655: RETURN(l_return_status);
1656:
1657: END get_notice_of_assignment_yn;
1658: