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 524: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,

520: EXCEPTION
521:
522: WHEN OTHERS THEN
523:
524: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
525: p_msg_name => G_UNEXPECTED_ERROR,
526: p_token1 => G_SQLCODE_TOKEN,
527: p_token1_value => sqlcode,
528: p_token2 => G_SQLERRM_TOKEN,

Line 580: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

576: change_quote_status(p_quote_id => l_quote_id,
577: p_qte_status => 'PR-APPROVED',
578: x_return_status => lx_return_status);
579:
580: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
582: ELSIF lx_return_status = G_RET_STS_ERROR THEN
583: RAISE OKL_API.G_EXCEPTION_ERROR;
584: END IF;

Line 581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

577: p_qte_status => 'PR-APPROVED',
578: x_return_status => lx_return_status);
579:
580: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
582: ELSIF lx_return_status = G_RET_STS_ERROR THEN
583: RAISE OKL_API.G_EXCEPTION_ERROR;
584: END IF;
585:

Line 583: RAISE OKL_API.G_EXCEPTION_ERROR;

579:
580: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
581: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
582: ELSIF lx_return_status = G_RET_STS_ERROR THEN
583: RAISE OKL_API.G_EXCEPTION_ERROR;
584: END IF;
585:
586: resultout := 'COMPLETE:';
587: RETURN;

Line 605: WHEN OKL_API.G_EXCEPTION_ERROR THEN

601: END IF;
602:
603: EXCEPTION
604:
605: WHEN OKL_API.G_EXCEPTION_ERROR THEN
606:
607: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
608: RAISE;
609:

Line 610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

606:
607: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
608: RAISE;
609:
610: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
611:
612: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
613: RAISE;
614:

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

613: RAISE;
614:
615: WHEN OTHERS THEN
616:
617: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
618: p_msg_name => G_UNEXPECTED_ERROR,
619: p_token1 => G_SQLCODE_TOKEN,
620: p_token1_value => sqlcode,
621: p_token2 => G_SQLERRM_TOKEN,

Line 1003: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

999: p_qte_status => 'PR-APPROVED',
1000: x_return_status => lx_return_status);
1001: END IF;
1002:
1003: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;

Line 1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1000: x_return_status => lx_return_status);
1001: END IF;
1002:
1003: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:

Line 1006: RAISE OKL_API.G_EXCEPTION_ERROR;

1002:
1003: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1004: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1005: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1006: RAISE OKL_API.G_EXCEPTION_ERROR;
1007: END IF;
1008:
1009: --BUG 4951955 PAGARG Update Lease App status only if current status is
1010: --Pricing Submitted

Line 1017: ,p_init_msg_list => OKL_API.G_FALSE

1013: THEN
1014: -- update the status of the lease application to Pricing approved
1015: OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS(
1016: p_api_version => 1.0
1017: ,p_init_msg_list => OKL_API.G_FALSE
1018: ,p_lap_id => l_parent_id
1019: ,p_lap_status => 'PR-APPROVED'
1020: ,x_return_status => lx_return_status
1021: ,x_msg_count => x_msg_count

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

1020: ,x_return_status => lx_return_status
1021: ,x_msg_count => x_msg_count
1022: ,x_msg_data => x_msg_data);
1023:
1024: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;

Line 1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1021: ,x_msg_count => x_msg_count
1022: ,x_msg_data => x_msg_data);
1023:
1024: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: END IF;

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

1022: ,x_msg_data => x_msg_data);
1023:
1024: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: END IF;
1030: ELSE

Line 1027: RAISE OKL_API.G_EXCEPTION_ERROR;

1023:
1024: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1025: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1026: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1027: RAISE OKL_API.G_EXCEPTION_ERROR;
1028: END IF;
1029: END IF;
1030: ELSE
1031: IF(l_flag = 1)

Line 1038: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN

1034: p_qte_status => 'PR-REJECTED',
1035: x_return_status => lx_return_status);
1036: END IF;
1037:
1038: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1040: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1041: RAISE OKL_API.G_EXCEPTION_ERROR;
1042: END IF;

Line 1039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1035: x_return_status => lx_return_status);
1036: END IF;
1037:
1038: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1040: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1041: RAISE OKL_API.G_EXCEPTION_ERROR;
1042: END IF;
1043:

Line 1041: RAISE OKL_API.G_EXCEPTION_ERROR;

1037:
1038: IF lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR THEN
1039: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1040: ELSIF lx_return_status = G_RET_STS_ERROR THEN
1041: RAISE OKL_API.G_EXCEPTION_ERROR;
1042: END IF;
1043:
1044: --BUG 4951955 PAGARG Update Lease App status only if current status is
1045: --Pricing Submitted

Line 1052: ,p_init_msg_list => OKL_API.G_FALSE

1048: THEN
1049: -- update the status of the lease application to Pricing Rejected
1050: OKL_LEASE_APP_PVT.SET_LEASE_APP_STATUS(
1051: p_api_version => 1.0
1052: ,p_init_msg_list => OKL_API.G_FALSE
1053: ,p_lap_id => l_parent_id
1054: ,p_lap_status => 'PR-REJECTED'
1055: ,x_return_status => lx_return_status
1056: ,x_msg_count => x_msg_count

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

1055: ,x_return_status => lx_return_status
1056: ,x_msg_count => x_msg_count
1057: ,x_msg_data => x_msg_data);
1058:
1059: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1060: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1062: RAISE OKL_API.G_EXCEPTION_ERROR;
1063: END IF;

Line 1060: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

1056: ,x_msg_count => x_msg_count
1057: ,x_msg_data => x_msg_data);
1058:
1059: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1060: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1062: RAISE OKL_API.G_EXCEPTION_ERROR;
1063: END IF;
1064: END IF;

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

1057: ,x_msg_data => x_msg_data);
1058:
1059: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1060: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1062: RAISE OKL_API.G_EXCEPTION_ERROR;
1063: END IF;
1064: END IF;
1065: END IF;

Line 1062: RAISE OKL_API.G_EXCEPTION_ERROR;

1058:
1059: IF(lx_return_status = OKL_API.G_RET_STS_UNEXP_ERROR)THEN
1060: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
1061: ELSIF (lx_return_status = OKL_API.G_RET_STS_ERROR)THEN
1062: RAISE OKL_API.G_EXCEPTION_ERROR;
1063: END IF;
1064: END IF;
1065: END IF;
1066:

Line 1084: WHEN OKL_API.G_EXCEPTION_ERROR THEN

1080: RETURN;
1081: END IF;
1082:
1083: EXCEPTION
1084: WHEN OKL_API.G_EXCEPTION_ERROR THEN
1085: --Lease Quote Parent Object Cursor
1086: IF get_parent_object%ISOPEN
1087: THEN
1088: CLOSE get_parent_object;

Line 1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1094: END IF;
1095: wf_core.context(G_PKG_NAME, l_api_name, itemtype, itemkey, actid, funcmode);
1096: RAISE;
1097:
1098: WHEN OKL_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1099: --Lease Quote Parent Object Cursor
1100: IF get_parent_object%ISOPEN
1101: THEN
1102: CLOSE get_parent_object;

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

1119: IF lse_app_dtls_csr%ISOPEN
1120: THEN
1121: CLOSE lse_app_dtls_csr;
1122: END IF;
1123: OKL_API.SET_MESSAGE (p_app_name => G_APP_NAME,
1124: p_msg_name => G_UNEXPECTED_ERROR,
1125: p_token1 => G_SQLCODE_TOKEN,
1126: p_token1_value => sqlcode,
1127: p_token2 => G_SQLERRM_TOKEN,