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_LEASE_QUOTE_WORKFLOW_PVT dependencies on OKL_API

Line 248: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

244: ,x_msg_data => lx_msg_data
245: ,p_lsqv_rec => l_lease_qte_rec
246: ,x_lsqv_rec => x_lease_qte_rec );
247:
248: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
250: ELSIF lx_return_status = G_RET_STS_ERROR THEN
251: RAISE OKL_API.G_EXCEPTION_ERROR;
252: END IF;

Line 249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

245: ,p_lsqv_rec => l_lease_qte_rec
246: ,x_lsqv_rec => x_lease_qte_rec );
247:
248: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
250: ELSIF lx_return_status = G_RET_STS_ERROR THEN
251: RAISE OKL_API.G_EXCEPTION_ERROR;
252: END IF;
253:

Line 251: RAISE OKL_API.G_EXCEPTION_ERROR;

247:
248: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
249: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
250: ELSIF lx_return_status = G_RET_STS_ERROR THEN
251: RAISE OKL_API.G_EXCEPTION_ERROR;
252: END IF;
253:
254: x_return_status := lx_return_status;
255:

Line 258: WHEN OKL_API.G_EXCEPTION_ERROR THEN

254: x_return_status := lx_return_status;
255:
256: EXCEPTION
257:
258: WHEN OKL_API.G_EXCEPTION_ERROR THEN
259:
260: x_return_status := G_RET_STS_ERROR;
261:
262: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 262: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

258: WHEN OKL_API.G_EXCEPTION_ERROR THEN
259:
260: x_return_status := G_RET_STS_ERROR;
261:
262: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
263:
264: x_return_status := G_RET_STS_UNEXP_ERROR;
265:
266: WHEN OTHERS THEN

Line 268: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

264: x_return_status := G_RET_STS_UNEXP_ERROR;
265:
266: WHEN OTHERS THEN
267:
268: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
269: p_msg_name => G_UNEXPECTED_ERROR,
270: p_token1 => G_SQLCODE_TOKEN,
271: p_token1_value => sqlcode,
272: p_token2 => G_SQLERRM_TOKEN,

Line 320: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

316: change_quote_status(p_quote_id => p_quote_id,
317: p_qte_status => 'CT-ACCEPTED',
318: x_return_status => lx_return_status);
319:
320: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF lx_return_status = G_RET_STS_ERROR THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;

Line 321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

317: p_qte_status => 'CT-ACCEPTED',
318: x_return_status => lx_return_status);
319:
320: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF lx_return_status = G_RET_STS_ERROR THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:

Line 323: RAISE OKL_API.G_EXCEPTION_ERROR;

319:
320: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
321: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
322: ELSIF lx_return_status = G_RET_STS_ERROR THEN
323: RAISE OKL_API.G_EXCEPTION_ERROR;
324: END IF;
325:
326: x_return_status := lx_return_status;
327:

Line 332: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

328: EXCEPTION
329:
330: WHEN OTHERS THEN
331:
332: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
333: p_msg_name => G_UNEXPECTED_ERROR,
334: p_token1 => G_SQLCODE_TOKEN,
335: p_token1_value => sqlcode,
336: p_token2 => G_SQLERRM_TOKEN,

Line 386: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

382: change_quote_status(p_quote_id => l_quote_id,
383: p_qte_status => 'CT-ACCEPTED',
384: x_return_status => lx_return_status);
385:
386: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
388: ELSIF lx_return_status = G_RET_STS_ERROR THEN
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;

Line 387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

383: p_qte_status => 'CT-ACCEPTED',
384: x_return_status => lx_return_status);
385:
386: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
388: ELSIF lx_return_status = G_RET_STS_ERROR THEN
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391:

Line 389: RAISE OKL_API.G_EXCEPTION_ERROR;

385:
386: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
387: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
388: ELSIF lx_return_status = G_RET_STS_ERROR THEN
389: RAISE OKL_API.G_EXCEPTION_ERROR;
390: END IF;
391:
392: resultout := 'COMPLETE:';
393: RETURN;

Line 410: WHEN OKL_API.G_EXCEPTION_ERROR THEN

406: END IF;
407:
408: EXCEPTION
409:
410: WHEN OKL_API.G_EXCEPTION_ERROR THEN
411:
412: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
413: RAISE;
414:

Line 415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

411:
412: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
413: RAISE;
414:
415: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
416:
417: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
418: RAISE;
419:

Line 422: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

418: RAISE;
419:
420: WHEN OTHERS THEN
421:
422: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
423: p_msg_name => G_UNEXPECTED_ERROR,
424: p_token1 => G_SQLCODE_TOKEN,
425: p_token1_value => sqlcode,
426: p_token2 => G_SQLERRM_TOKEN,

Line 478: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

474: OPEN get_parent_object(p_quote_id);
475: FETCH get_parent_object INTO l_parent_object, l_parent_id;
476: CLOSE get_parent_object;
477:
478: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF l_return_status = G_RET_STS_ERROR THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;

Line 479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

475: FETCH get_parent_object INTO l_parent_object, l_parent_id;
476: CLOSE get_parent_object;
477:
478: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF l_return_status = G_RET_STS_ERROR THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:

Line 481: RAISE OKL_API.G_EXCEPTION_ERROR;

477:
478: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
479: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
480: ELSIF l_return_status = G_RET_STS_ERROR THEN
481: RAISE OKL_API.G_EXCEPTION_ERROR;
482: END IF;
483:
484: IF (l_parent_object = 'LEASEAPP') THEN
485: l_lapv_rec.application_status := 'PR-APPROVED';

Line 498: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

494: ,x_msg_data => x_msg_data
495: ,p_lapv_rec => l_lapv_rec
496: ,x_lapv_rec => x_lapv_rec);
497:
498: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF l_return_status = G_RET_STS_ERROR THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;

Line 499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

495: ,p_lapv_rec => l_lapv_rec
496: ,x_lapv_rec => x_lapv_rec);
497:
498: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF l_return_status = G_RET_STS_ERROR THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503: END IF;

Line 501: RAISE OKL_API.G_EXCEPTION_ERROR;

497:
498: IF l_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
499: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
500: ELSIF l_return_status = G_RET_STS_ERROR THEN
501: RAISE OKL_API.G_EXCEPTION_ERROR;
502: END IF;
503: END IF;
504: ELSE
505:

Line 530: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

526: EXCEPTION
527:
528: WHEN OTHERS THEN
529:
530: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
531: p_msg_name => G_UNEXPECTED_ERROR,
532: p_token1 => G_SQLCODE_TOKEN,
533: p_token1_value => sqlcode,
534: p_token2 => G_SQLERRM_TOKEN,

Line 586: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

582: change_quote_status(p_quote_id => l_quote_id,
583: p_qte_status => 'PR-APPROVED',
584: x_return_status => lx_return_status);
585:
586: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF lx_return_status = G_RET_STS_ERROR THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;

Line 587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

583: p_qte_status => 'PR-APPROVED',
584: x_return_status => lx_return_status);
585:
586: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF lx_return_status = G_RET_STS_ERROR THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591:

Line 589: RAISE OKL_API.G_EXCEPTION_ERROR;

585:
586: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
587: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
588: ELSIF lx_return_status = G_RET_STS_ERROR THEN
589: RAISE OKL_API.G_EXCEPTION_ERROR;
590: END IF;
591:
592: resultout := 'COMPLETE:';
593: RETURN;

Line 611: WHEN OKL_API.G_EXCEPTION_ERROR THEN

607: END IF;
608:
609: EXCEPTION
610:
611: WHEN OKL_API.G_EXCEPTION_ERROR THEN
612:
613: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
614: RAISE;
615:

Line 616: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

612:
613: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
614: RAISE;
615:
616: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
617:
618: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
619: RAISE;
620:

Line 623: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

619: RAISE;
620:
621: WHEN OTHERS THEN
622:
623: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
624: p_msg_name => G_UNEXPECTED_ERROR,
625: p_token1 => G_SQLCODE_TOKEN,
626: p_token1_value => sqlcode,
627: p_token2 => G_SQLERRM_TOKEN,

Line 1075: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1071: p_qte_status => 'PR-APPROVED',
1072: x_return_status => lx_return_status);
1073: END IF;
1074:
1075: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;

Line 1076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1072: x_return_status => lx_return_status);
1073: END IF;
1074:
1075: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:

Line 1078: RAISE OKL_API.G_EXCEPTION_ERROR;

1074:
1075: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1076: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1077: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1078: RAISE OKL_API.G_EXCEPTION_ERROR;
1079: END IF;
1080:
1081: --BUG 4951955 PAGARG Update Lease App status only if current status is
1082: --Pricing Submitted

Line 1089: ,p_init_msg_list => OKL_API.G_FALSE

1085: THEN
1086: -- update the status of the lease application to Pricing approved
1087: OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS(
1088: p_api_version => 1.0
1089: ,p_init_msg_list => OKL_API.G_FALSE
1090: ,p_lap_id => l_parent_id
1091: ,p_lap_status => 'PR-APPROVED'
1092: ,x_return_status => lx_return_status
1093: ,x_msg_count => x_msg_count

Line 1096: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

1092: ,x_return_status => lx_return_status
1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data);
1095:
1096: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1098: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1099: RAISE OKL_API.G_EXCEPTION_ERROR;
1100: END IF;

Line 1097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1093: ,x_msg_count => x_msg_count
1094: ,x_msg_data => x_msg_data);
1095:
1096: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1098: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1099: RAISE OKL_API.G_EXCEPTION_ERROR;
1100: END IF;
1101: END IF;

Line 1098: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN

1094: ,x_msg_data => x_msg_data);
1095:
1096: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1098: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1099: RAISE OKL_API.G_EXCEPTION_ERROR;
1100: END IF;
1101: END IF;
1102: ELSE

Line 1099: RAISE OKL_API.G_EXCEPTION_ERROR;

1095:
1096: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1097: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1098: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1099: RAISE OKL_API.G_EXCEPTION_ERROR;
1100: END IF;
1101: END IF;
1102: ELSE
1103: IF(l_flag = 1)

Line 1110: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1106: p_qte_status => 'PR-REJECTED',
1107: x_return_status => lx_return_status);
1108: END IF;
1109:
1110: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;

Line 1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1107: x_return_status => lx_return_status);
1108: END IF;
1109:
1110: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;
1115:

Line 1113: RAISE OKL_API.G_EXCEPTION_ERROR;

1109:
1110: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1111: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1112: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1113: RAISE OKL_API.G_EXCEPTION_ERROR;
1114: END IF;
1115:
1116: --BUG 4951955 PAGARG Update Lease App status only if current status is
1117: --Pricing Submitted

Line 1124: ,p_init_msg_list => OKL_API.G_FALSE

1120: THEN
1121: -- update the status of the lease application to Pricing Rejected
1122: OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS(
1123: p_api_version => 1.0
1124: ,p_init_msg_list => OKL_API.G_FALSE
1125: ,p_lap_id => l_parent_id
1126: ,p_lap_status => 'PR-REJECTED'
1127: ,x_return_status => lx_return_status
1128: ,x_msg_count => x_msg_count

Line 1131: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN

1127: ,x_return_status => lx_return_status
1128: ,x_msg_count => x_msg_count
1129: ,x_msg_data => x_msg_data);
1130:
1131: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1134: RAISE OKL_API.G_EXCEPTION_ERROR;
1135: END IF;

Line 1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1128: ,x_msg_count => x_msg_count
1129: ,x_msg_data => x_msg_data);
1130:
1131: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1134: RAISE OKL_API.G_EXCEPTION_ERROR;
1135: END IF;
1136: END IF;

Line 1133: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN

1129: ,x_msg_data => x_msg_data);
1130:
1131: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1134: RAISE OKL_API.G_EXCEPTION_ERROR;
1135: END IF;
1136: END IF;
1137: END IF;

Line 1134: RAISE OKL_API.G_EXCEPTION_ERROR;

1130:
1131: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1132: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1133: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1134: RAISE OKL_API.G_EXCEPTION_ERROR;
1135: END IF;
1136: END IF;
1137: END IF;
1138:

Line 1156: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1152: RETURN;
1153: END IF;
1154:
1155: EXCEPTION
1156: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1157: --Lease Quote Parent Object Cursor
1158: IF get_parent_object%ISOPEN
1159: THEN
1160: CLOSE get_parent_object;

Line 1170: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1166: END IF;
1167: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
1168: RAISE;
1169:
1170: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1171: --Lease Quote Parent Object Cursor
1172: IF get_parent_object%ISOPEN
1173: THEN
1174: CLOSE get_parent_object;

Line 1195: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

1191: IF lse_app_dtls_csr%ISOPEN
1192: THEN
1193: CLOSE lse_app_dtls_csr;
1194: END IF;
1195: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1196: p_msg_name => G_UNEXPECTED_ERROR,
1197: p_token1 => G_SQLCODE_TOKEN,
1198: p_token1_value => sqlcode,
1199: p_token2 => G_SQLERRM_TOKEN,