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_DEAL_ASSET_PVT dependencies on OKC_API

Line 1172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1168: x_msg_data => x_msg_data,
1169: p_rgpv_rec => lp_labill_rgpv_rec,
1170: x_rgpv_rec => lx_labill_rgpv_rec);
1171:
1172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1175: RAISE OKC_API.G_EXCEPTION_ERROR;
1176: END IF;

Line 1173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1169: p_rgpv_rec => lp_labill_rgpv_rec,
1170: x_rgpv_rec => lx_labill_rgpv_rec);
1171:
1172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1175: RAISE OKC_API.G_EXCEPTION_ERROR;
1176: END IF;
1177:

Line 1174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1170: x_rgpv_rec => lx_labill_rgpv_rec);
1171:
1172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1175: RAISE OKC_API.G_EXCEPTION_ERROR;
1176: END IF;
1177:
1178: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;

Line 1175: RAISE OKC_API.G_EXCEPTION_ERROR;

1171:
1172: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1173: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1174: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1175: RAISE OKC_API.G_EXCEPTION_ERROR;
1176: END IF;
1177:
1178: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;
1179: x_rgpv_rec.rgp_labill_lapmth_id := lx_labill_rgpv_rec.id;

Line 1199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1195: x_msg_data => x_msg_data,
1196: p_rgpv_rec => lp_labill_rgpv_rec,
1197: x_rgpv_rec => lx_labill_rgpv_rec);
1198:
1199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1202: RAISE OKC_API.G_EXCEPTION_ERROR;
1203: END IF;

Line 1200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1196: p_rgpv_rec => lp_labill_rgpv_rec,
1197: x_rgpv_rec => lx_labill_rgpv_rec);
1198:
1199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1202: RAISE OKC_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;

Line 1201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1197: x_rgpv_rec => lx_labill_rgpv_rec);
1198:
1199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1202: RAISE OKC_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
1205: END IF;

Line 1202: RAISE OKC_API.G_EXCEPTION_ERROR;

1198:
1199: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1200: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1201: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1202: RAISE OKC_API.G_EXCEPTION_ERROR;
1203: END IF;
1204: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
1205: END IF;
1206:

Line 1225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1221: p_edit_mode => 'N',
1222: x_clev_rec => lx_clev_rec,
1223: x_klev_rec => lx_klev_rec);
1224:
1225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;

Line 1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1222: x_clev_rec => lx_clev_rec,
1223: x_klev_rec => lx_klev_rec);
1224:
1225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:

Line 1227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1223: x_klev_rec => lx_klev_rec);
1224:
1225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:
1231: IF (p_rgpv_rec.rul_lapmth_id IS NULL) THEN

Line 1228: RAISE OKC_API.G_EXCEPTION_ERROR;

1224:
1225: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1226: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1227: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1228: RAISE OKC_API.G_EXCEPTION_ERROR;
1229: END IF;
1230:
1231: IF (p_rgpv_rec.rul_lapmth_id IS NULL) THEN
1232: -- Create LAPMTH rule

Line 1254: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1250: x_msg_data => x_msg_data,
1251: p_rulv_rec => lp_lapmth_rulv_rec,
1252: x_rulv_rec => lx_lapmth_rulv_rec);
1253:
1254: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;

Line 1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1251: p_rulv_rec => lp_lapmth_rulv_rec,
1252: x_rulv_rec => lx_lapmth_rulv_rec);
1253:
1254: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259:

Line 1256: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1252: x_rulv_rec => lx_lapmth_rulv_rec);
1253:
1254: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259:
1260: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;

Line 1257: RAISE OKC_API.G_EXCEPTION_ERROR;

1253:
1254: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1255: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1256: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1257: RAISE OKC_API.G_EXCEPTION_ERROR;
1258: END IF;
1259:
1260: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;
1261: ELSE

Line 1289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1285: x_msg_data => x_msg_data,
1286: p_rulv_rec => lp_lapmth_rulv_rec,
1287: x_rulv_rec => lx_lapmth_rulv_rec);
1288:
1289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;

Line 1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1286: p_rulv_rec => lp_lapmth_rulv_rec,
1287: x_rulv_rec => lx_lapmth_rulv_rec);
1288:
1289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294:

Line 1291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1287: x_rulv_rec => lx_lapmth_rulv_rec);
1288:
1289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294:
1295: END IF;

Line 1292: RAISE OKC_API.G_EXCEPTION_ERROR;

1288:
1289: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1290: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1291: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1292: RAISE OKC_API.G_EXCEPTION_ERROR;
1293: END IF;
1294:
1295: END IF;
1296:

Line 1320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1316: x_msg_data => x_msg_data,
1317: p_rulv_rec => lp_labacc_rulv_rec,
1318: x_rulv_rec => lx_labacc_rulv_rec);
1319:
1320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1323: RAISE OKC_API.G_EXCEPTION_ERROR;
1324: END IF;

Line 1321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1317: p_rulv_rec => lp_labacc_rulv_rec,
1318: x_rulv_rec => lx_labacc_rulv_rec);
1319:
1320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1323: RAISE OKC_API.G_EXCEPTION_ERROR;
1324: END IF;
1325:

Line 1322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1318: x_rulv_rec => lx_labacc_rulv_rec);
1319:
1320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1323: RAISE OKC_API.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;

Line 1323: RAISE OKC_API.G_EXCEPTION_ERROR;

1319:
1320: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1321: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1322: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1323: RAISE OKC_API.G_EXCEPTION_ERROR;
1324: END IF;
1325:
1326: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;
1327:

Line 1356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1352: x_msg_data => x_msg_data,
1353: p_rulv_rec => lp_labacc_rulv_rec,
1354: x_rulv_rec => lx_labacc_rulv_rec);
1355:
1356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;

Line 1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1353: p_rulv_rec => lp_labacc_rulv_rec,
1354: x_rulv_rec => lx_labacc_rulv_rec);
1355:
1356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:

Line 1358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

1354: x_rulv_rec => lx_labacc_rulv_rec);
1355:
1356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:
1362: END IF;

Line 1359: RAISE OKC_API.G_EXCEPTION_ERROR;

1355:
1356: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1357: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1358: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1359: RAISE OKC_API.G_EXCEPTION_ERROR;
1360: END IF;
1361:
1362: END IF;
1363:

Line 1365: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1361:
1362: END IF;
1363:
1364:
1365: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1366:
1367: EXCEPTION
1368: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1368: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1364:
1365: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1366:
1367: EXCEPTION
1368: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1370: p_api_name => l_api_name,
1371: p_pkg_name => g_pkg_name,
1372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1369: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1365: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1366:
1367: EXCEPTION
1368: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1370: p_api_name => l_api_name,
1371: p_pkg_name => g_pkg_name,
1372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1373: x_msg_count => x_msg_count,

Line 1372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1368: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1369: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1370: p_api_name => l_api_name,
1371: p_pkg_name => g_pkg_name,
1372: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1373: x_msg_count => x_msg_count,
1374: x_msg_data => x_msg_data,
1375: p_api_type => g_api_type);
1376:

Line 1377: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1373: x_msg_count => x_msg_count,
1374: x_msg_data => x_msg_data,
1375: p_api_type => g_api_type);
1376:
1377: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1378: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1379: p_api_name => l_api_name,
1380: p_pkg_name => g_pkg_name,
1381: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1378: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1374: x_msg_data => x_msg_data,
1375: p_api_type => g_api_type);
1376:
1377: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1378: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1379: p_api_name => l_api_name,
1380: p_pkg_name => g_pkg_name,
1381: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1382: x_msg_count => x_msg_count,

Line 1381: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1377: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1378: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1379: p_api_name => l_api_name,
1380: p_pkg_name => g_pkg_name,
1381: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1382: x_msg_count => x_msg_count,
1383: x_msg_data => x_msg_data,
1384: p_api_type => g_api_type);
1385:

Line 1387: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1383: x_msg_data => x_msg_data,
1384: p_api_type => g_api_type);
1385:
1386: WHEN OTHERS THEN
1387: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1388: p_api_name => l_api_name,
1389: p_pkg_name => g_pkg_name,
1390: p_exc_name => 'OTHERS',
1391: x_msg_count => x_msg_count,

Line 1662: x_return_status := OKC_API.START_ACTIVITY(

1658: BEGIN
1659:
1660: -- call START_ACTIVITY to create savepoint, check compatibility
1661: -- and initialize message list
1662: x_return_status := OKC_API.START_ACTIVITY(
1663: p_api_name => l_api_name,
1664: p_pkg_name => g_pkg_name,
1665: p_init_msg_list => p_init_msg_list,
1666: l_api_version => l_api_version,

Line 1672: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1668: p_api_type => g_api_type,
1669: x_return_status => x_return_status);
1670:
1671: -- check if activity started successfully
1672: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1673: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1675: raise OKC_API.G_EXCEPTION_ERROR;
1676: End If;

Line 1673: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1669: x_return_status => x_return_status);
1670:
1671: -- check if activity started successfully
1672: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1673: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1675: raise OKC_API.G_EXCEPTION_ERROR;
1676: End If;
1677:

Line 1674: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1670:
1671: -- check if activity started successfully
1672: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1673: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1675: raise OKC_API.G_EXCEPTION_ERROR;
1676: End If;
1677:
1678: l_chr_id := p_chr_id;

Line 1675: raise OKC_API.G_EXCEPTION_ERROR;

1671: -- check if activity started successfully
1672: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1673: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1674: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1675: raise OKC_API.G_EXCEPTION_ERROR;
1676: End If;
1677:
1678: l_chr_id := p_chr_id;
1679: If okl_context.get_okc_org_id is null then

Line 1793: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

1789: END IF;
1790:
1791: x_tradein_tbl := l_tradein_tbl;
1792:
1793: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1794:
1795: EXCEPTION
1796:
1797: when OKC_API.G_EXCEPTION_ERROR then

Line 1797: when OKC_API.G_EXCEPTION_ERROR then

1793: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1794:
1795: EXCEPTION
1796:
1797: when OKC_API.G_EXCEPTION_ERROR then
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1799: p_api_name => l_api_name,
1800: p_pkg_name => g_pkg_name,
1801: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1794:
1795: EXCEPTION
1796:
1797: when OKC_API.G_EXCEPTION_ERROR then
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1799: p_api_name => l_api_name,
1800: p_pkg_name => g_pkg_name,
1801: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1802: x_msg_count => x_msg_count,

Line 1801: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

1797: when OKC_API.G_EXCEPTION_ERROR then
1798: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1799: p_api_name => l_api_name,
1800: p_pkg_name => g_pkg_name,
1801: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1802: x_msg_count => x_msg_count,
1803: x_msg_data => x_msg_data,
1804: p_api_type => g_api_type);
1805:

Line 1806: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1802: x_msg_count => x_msg_count,
1803: x_msg_data => x_msg_data,
1804: p_api_type => g_api_type);
1805:
1806: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1808: p_api_name => l_api_name,
1809: p_pkg_name => g_pkg_name,
1810: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1803: x_msg_data => x_msg_data,
1804: p_api_type => g_api_type);
1805:
1806: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1808: p_api_name => l_api_name,
1809: p_pkg_name => g_pkg_name,
1810: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1811: x_msg_count => x_msg_count,

Line 1810: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

1806: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1807: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1808: p_api_name => l_api_name,
1809: p_pkg_name => g_pkg_name,
1810: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1811: x_msg_count => x_msg_count,
1812: x_msg_data => x_msg_data,
1813: p_api_type => g_api_type);
1814:

Line 1816: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1812: x_msg_data => x_msg_data,
1813: p_api_type => g_api_type);
1814:
1815: when OTHERS then
1816: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1817: p_api_name => l_api_name,
1818: p_pkg_name => g_pkg_name,
1819: p_exc_name => 'OTHERS',
1820: x_msg_count => x_msg_count,

Line 1919: x_return_status := OKC_API.START_ACTIVITY(

1915: BEGIN
1916:
1917: -- call START_ACTIVITY to create savepoint, check compatibility
1918: -- and initialize message list
1919: x_return_status := OKC_API.START_ACTIVITY(
1920: p_api_name => l_api_name,
1921: p_pkg_name => g_pkg_name,
1922: p_init_msg_list => p_init_msg_list,
1923: l_api_version => l_api_version,

Line 1929: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1925: p_api_type => g_api_type,
1926: x_return_status => x_return_status);
1927:
1928: -- check if activity started successfully
1929: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1930: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1931: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1932: raise OKC_API.G_EXCEPTION_ERROR;
1933: End If;

Line 1930: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1926: x_return_status => x_return_status);
1927:
1928: -- check if activity started successfully
1929: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1930: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1931: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1932: raise OKC_API.G_EXCEPTION_ERROR;
1933: End If;
1934:

Line 1931: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then

1927:
1928: -- check if activity started successfully
1929: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1930: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1931: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1932: raise OKC_API.G_EXCEPTION_ERROR;
1933: End If;
1934:
1935: l_chr_id := p_chr_id;

Line 1932: raise OKC_API.G_EXCEPTION_ERROR;

1928: -- check if activity started successfully
1929: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1930: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1931: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1932: raise OKC_API.G_EXCEPTION_ERROR;
1933: End If;
1934:
1935: l_chr_id := p_chr_id;
1936: If okl_context.get_okc_org_id is null then

Line 2065: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);

2061: END IF;
2062:
2063: x_down_payment_tbl := l_down_payment_tbl;
2064:
2065: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2066:
2067: EXCEPTION
2068:
2069: when OKC_API.G_EXCEPTION_ERROR then

Line 2069: when OKC_API.G_EXCEPTION_ERROR then

2065: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2066:
2067: EXCEPTION
2068:
2069: when OKC_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => g_pkg_name,
2073: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 2070: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2066:
2067: EXCEPTION
2068:
2069: when OKC_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => g_pkg_name,
2073: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2074: x_msg_count => x_msg_count,

Line 2073: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

2069: when OKC_API.G_EXCEPTION_ERROR then
2070: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2071: p_api_name => l_api_name,
2072: p_pkg_name => g_pkg_name,
2073: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2074: x_msg_count => x_msg_count,
2075: x_msg_data => x_msg_data,
2076: p_api_type => g_api_type);
2077:

Line 2078: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

2074: x_msg_count => x_msg_count,
2075: x_msg_data => x_msg_data,
2076: p_api_type => g_api_type);
2077:
2078: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => g_pkg_name,
2082: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2075: x_msg_data => x_msg_data,
2076: p_api_type => g_api_type);
2077:
2078: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => g_pkg_name,
2082: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count => x_msg_count,

Line 2082: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

2078: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2079: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2080: p_api_name => l_api_name,
2081: p_pkg_name => g_pkg_name,
2082: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2083: x_msg_count => x_msg_count,
2084: x_msg_data => x_msg_data,
2085: p_api_type => g_api_type);
2086:

Line 2088: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2084: x_msg_data => x_msg_data,
2085: p_api_type => g_api_type);
2086:
2087: when OTHERS then
2088: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2089: p_api_name => l_api_name,
2090: p_pkg_name => g_pkg_name,
2091: p_exc_name => 'OTHERS',
2092: x_msg_count => x_msg_count,