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 1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1116: x_msg_data => x_msg_data,
1117: p_rgpv_rec => lp_labill_rgpv_rec,
1118: x_rgpv_rec => lx_labill_rgpv_rec);
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;

Line 1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1117: p_rgpv_rec => lp_labill_rgpv_rec,
1118: x_rgpv_rec => lx_labill_rgpv_rec);
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125:

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

1118: x_rgpv_rec => lx_labill_rgpv_rec);
1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125:
1126: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;

Line 1123: RAISE OKC_API.G_EXCEPTION_ERROR;

1119:
1120: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1121: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1122: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1123: RAISE OKC_API.G_EXCEPTION_ERROR;
1124: END IF;
1125:
1126: x_rgpv_rec.rgp_id := lx_labill_rgpv_rec.id;
1127: x_rgpv_rec.rgp_labill_lapmth_id := lx_labill_rgpv_rec.id;

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

1143: x_msg_data => x_msg_data,
1144: p_rgpv_rec => lp_labill_rgpv_rec,
1145: x_rgpv_rec => lx_labill_rgpv_rec);
1146:
1147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1150: RAISE OKC_API.G_EXCEPTION_ERROR;
1151: END IF;

Line 1148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1144: p_rgpv_rec => lp_labill_rgpv_rec,
1145: x_rgpv_rec => lx_labill_rgpv_rec);
1146:
1147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1150: RAISE OKC_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;

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

1145: x_rgpv_rec => lx_labill_rgpv_rec);
1146:
1147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1150: RAISE OKC_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
1153: END IF;

Line 1150: RAISE OKC_API.G_EXCEPTION_ERROR;

1146:
1147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1150: RAISE OKC_API.G_EXCEPTION_ERROR;
1151: END IF;
1152: x_rgpv_rec.rgp_id := p_rgpv_rec.rgp_id;
1153: END IF;
1154:

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

1169: p_edit_mode => 'N',
1170: x_clev_rec => lx_clev_rec,
1171: x_klev_rec => lx_klev_rec);
1172:
1173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;

Line 1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1170: x_clev_rec => lx_clev_rec,
1171: x_klev_rec => lx_klev_rec);
1172:
1173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:

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

1171: x_klev_rec => lx_klev_rec);
1172:
1173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: IF (p_rgpv_rec.rul_lapmth_id IS NULL) THEN

Line 1176: RAISE OKC_API.G_EXCEPTION_ERROR;

1172:
1173: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1174: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1175: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1176: RAISE OKC_API.G_EXCEPTION_ERROR;
1177: END IF;
1178:
1179: IF (p_rgpv_rec.rul_lapmth_id IS NULL) THEN
1180: -- Create LAPMTH rule

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

1198: x_msg_data => x_msg_data,
1199: p_rulv_rec => lp_lapmth_rulv_rec,
1200: x_rulv_rec => lx_lapmth_rulv_rec);
1201:
1202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1205: RAISE OKC_API.G_EXCEPTION_ERROR;
1206: END IF;

Line 1203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1199: p_rulv_rec => lp_lapmth_rulv_rec,
1200: x_rulv_rec => lx_lapmth_rulv_rec);
1201:
1202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1205: RAISE OKC_API.G_EXCEPTION_ERROR;
1206: END IF;
1207:

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

1200: x_rulv_rec => lx_lapmth_rulv_rec);
1201:
1202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1205: RAISE OKC_API.G_EXCEPTION_ERROR;
1206: END IF;
1207:
1208: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;

Line 1205: RAISE OKC_API.G_EXCEPTION_ERROR;

1201:
1202: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1203: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1204: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1205: RAISE OKC_API.G_EXCEPTION_ERROR;
1206: END IF;
1207:
1208: x_rgpv_rec.rul_lapmth_id := lx_lapmth_rulv_rec.id;
1209: ELSE

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

1228: x_msg_data => x_msg_data,
1229: p_rulv_rec => lp_lapmth_rulv_rec,
1230: x_rulv_rec => lx_lapmth_rulv_rec);
1231:
1232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;

Line 1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1229: p_rulv_rec => lp_lapmth_rulv_rec,
1230: x_rulv_rec => lx_lapmth_rulv_rec);
1231:
1232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:

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

1230: x_rulv_rec => lx_lapmth_rulv_rec);
1231:
1232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:
1238: END IF;

Line 1235: RAISE OKC_API.G_EXCEPTION_ERROR;

1231:
1232: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1233: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1234: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1235: RAISE OKC_API.G_EXCEPTION_ERROR;
1236: END IF;
1237:
1238: END IF;
1239:

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

1259: x_msg_data => x_msg_data,
1260: p_rulv_rec => lp_labacc_rulv_rec,
1261: x_rulv_rec => lx_labacc_rulv_rec);
1262:
1263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1264: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_ERROR;
1267: END IF;

Line 1264: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1260: p_rulv_rec => lp_labacc_rulv_rec,
1261: x_rulv_rec => lx_labacc_rulv_rec);
1262:
1263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1264: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_ERROR;
1267: END IF;
1268:

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

1261: x_rulv_rec => lx_labacc_rulv_rec);
1262:
1263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1264: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_ERROR;
1267: END IF;
1268:
1269: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;

Line 1266: RAISE OKC_API.G_EXCEPTION_ERROR;

1262:
1263: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1264: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1265: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1266: RAISE OKC_API.G_EXCEPTION_ERROR;
1267: END IF;
1268:
1269: x_rgpv_rec.rul_labacc_id := lx_labacc_rulv_rec.id;
1270:

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

1290: x_msg_data => x_msg_data,
1291: p_rulv_rec => lp_labacc_rulv_rec,
1292: x_rulv_rec => lx_labacc_rulv_rec);
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;

Line 1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1291: p_rulv_rec => lp_labacc_rulv_rec,
1292: x_rulv_rec => lx_labacc_rulv_rec);
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299:

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

1292: x_rulv_rec => lx_labacc_rulv_rec);
1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299:
1300: END IF;

Line 1297: RAISE OKC_API.G_EXCEPTION_ERROR;

1293:
1294: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1295: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1296: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1297: RAISE OKC_API.G_EXCEPTION_ERROR;
1298: END IF;
1299:
1300: END IF;
1301:

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

1299:
1300: END IF;
1301:
1302:
1303: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1304:
1305: EXCEPTION
1306: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 1306: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1302:
1303: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1304:
1305: EXCEPTION
1306: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1308: p_api_name => l_api_name,
1309: p_pkg_name => g_pkg_name,
1310: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1303: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1304:
1305: EXCEPTION
1306: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1308: p_api_name => l_api_name,
1309: p_pkg_name => g_pkg_name,
1310: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1311: x_msg_count => x_msg_count,

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

1306: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1307: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1308: p_api_name => l_api_name,
1309: p_pkg_name => g_pkg_name,
1310: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1311: x_msg_count => x_msg_count,
1312: x_msg_data => x_msg_data,
1313: p_api_type => g_api_type);
1314:

Line 1315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1311: x_msg_count => x_msg_count,
1312: x_msg_data => x_msg_data,
1313: p_api_type => g_api_type);
1314:
1315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1317: p_api_name => l_api_name,
1318: p_pkg_name => g_pkg_name,
1319: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1312: x_msg_data => x_msg_data,
1313: p_api_type => g_api_type);
1314:
1315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1317: p_api_name => l_api_name,
1318: p_pkg_name => g_pkg_name,
1319: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1320: x_msg_count => x_msg_count,

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

1315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1316: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1317: p_api_name => l_api_name,
1318: p_pkg_name => g_pkg_name,
1319: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1320: x_msg_count => x_msg_count,
1321: x_msg_data => x_msg_data,
1322: p_api_type => g_api_type);
1323:

Line 1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1321: x_msg_data => x_msg_data,
1322: p_api_type => g_api_type);
1323:
1324: WHEN OTHERS THEN
1325: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1326: p_api_name => l_api_name,
1327: p_pkg_name => g_pkg_name,
1328: p_exc_name => 'OTHERS',
1329: x_msg_count => x_msg_count,

Line 1598: x_return_status := OKC_API.START_ACTIVITY(

1594: BEGIN
1595:
1596: -- call START_ACTIVITY to create savepoint, check compatibility
1597: -- and initialize message list
1598: x_return_status := OKC_API.START_ACTIVITY(
1599: p_api_name => l_api_name,
1600: p_pkg_name => g_pkg_name,
1601: p_init_msg_list => p_init_msg_list,
1602: l_api_version => l_api_version,

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

1604: p_api_type => g_api_type,
1605: x_return_status => x_return_status);
1606:
1607: -- check if activity started successfully
1608: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1609: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1611: raise OKC_API.G_EXCEPTION_ERROR;
1612: End If;

Line 1609: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1605: x_return_status => x_return_status);
1606:
1607: -- check if activity started successfully
1608: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1609: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1611: raise OKC_API.G_EXCEPTION_ERROR;
1612: End If;
1613:

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

1606:
1607: -- check if activity started successfully
1608: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1609: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1611: raise OKC_API.G_EXCEPTION_ERROR;
1612: End If;
1613:
1614: l_chr_id := p_chr_id;

Line 1611: raise OKC_API.G_EXCEPTION_ERROR;

1607: -- check if activity started successfully
1608: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1609: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1610: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1611: raise OKC_API.G_EXCEPTION_ERROR;
1612: End If;
1613:
1614: l_chr_id := p_chr_id;
1615: If okl_context.get_okc_org_id is null then

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

1725: END IF;
1726:
1727: x_tradein_tbl := l_tradein_tbl;
1728:
1729: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1730:
1731: EXCEPTION
1732:
1733: when OKC_API.G_EXCEPTION_ERROR then

Line 1733: when OKC_API.G_EXCEPTION_ERROR then

1729: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
1730:
1731: EXCEPTION
1732:
1733: when OKC_API.G_EXCEPTION_ERROR then
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1735: p_api_name => l_api_name,
1736: p_pkg_name => g_pkg_name,
1737: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1730:
1731: EXCEPTION
1732:
1733: when OKC_API.G_EXCEPTION_ERROR then
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1735: p_api_name => l_api_name,
1736: p_pkg_name => g_pkg_name,
1737: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1738: x_msg_count => x_msg_count,

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

1733: when OKC_API.G_EXCEPTION_ERROR then
1734: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1735: p_api_name => l_api_name,
1736: p_pkg_name => g_pkg_name,
1737: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
1738: x_msg_count => x_msg_count,
1739: x_msg_data => x_msg_data,
1740: p_api_type => g_api_type);
1741:

Line 1742: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

1738: x_msg_count => x_msg_count,
1739: x_msg_data => x_msg_data,
1740: p_api_type => g_api_type);
1741:
1742: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1743: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1744: p_api_name => l_api_name,
1745: p_pkg_name => g_pkg_name,
1746: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1743: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1739: x_msg_data => x_msg_data,
1740: p_api_type => g_api_type);
1741:
1742: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1743: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1744: p_api_name => l_api_name,
1745: p_pkg_name => g_pkg_name,
1746: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1747: x_msg_count => x_msg_count,

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

1742: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
1743: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1744: p_api_name => l_api_name,
1745: p_pkg_name => g_pkg_name,
1746: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
1747: x_msg_count => x_msg_count,
1748: x_msg_data => x_msg_data,
1749: p_api_type => g_api_type);
1750:

Line 1752: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

1748: x_msg_data => x_msg_data,
1749: p_api_type => g_api_type);
1750:
1751: when OTHERS then
1752: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
1753: p_api_name => l_api_name,
1754: p_pkg_name => g_pkg_name,
1755: p_exc_name => 'OTHERS',
1756: x_msg_count => x_msg_count,

Line 1853: x_return_status := OKC_API.START_ACTIVITY(

1849: BEGIN
1850:
1851: -- call START_ACTIVITY to create savepoint, check compatibility
1852: -- and initialize message list
1853: x_return_status := OKC_API.START_ACTIVITY(
1854: p_api_name => l_api_name,
1855: p_pkg_name => g_pkg_name,
1856: p_init_msg_list => p_init_msg_list,
1857: l_api_version => l_api_version,

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

1859: p_api_type => g_api_type,
1860: x_return_status => x_return_status);
1861:
1862: -- check if activity started successfully
1863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1866: raise OKC_API.G_EXCEPTION_ERROR;
1867: End If;

Line 1864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1860: x_return_status => x_return_status);
1861:
1862: -- check if activity started successfully
1863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1866: raise OKC_API.G_EXCEPTION_ERROR;
1867: End If;
1868:

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

1861:
1862: -- check if activity started successfully
1863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1866: raise OKC_API.G_EXCEPTION_ERROR;
1867: End If;
1868:
1869: l_chr_id := p_chr_id;

Line 1866: raise OKC_API.G_EXCEPTION_ERROR;

1862: -- check if activity started successfully
1863: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1864: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1865: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
1866: raise OKC_API.G_EXCEPTION_ERROR;
1867: End If;
1868:
1869: l_chr_id := p_chr_id;
1870: If okl_context.get_okc_org_id is null then

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

1995: END IF;
1996:
1997: x_down_payment_tbl := l_down_payment_tbl;
1998:
1999: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2000:
2001: EXCEPTION
2002:
2003: when OKC_API.G_EXCEPTION_ERROR then

Line 2003: when OKC_API.G_EXCEPTION_ERROR then

1999: OKC_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
2000:
2001: EXCEPTION
2002:
2003: when OKC_API.G_EXCEPTION_ERROR then
2004: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2005: p_api_name => l_api_name,
2006: p_pkg_name => g_pkg_name,
2007: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 2004: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2000:
2001: EXCEPTION
2002:
2003: when OKC_API.G_EXCEPTION_ERROR then
2004: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2005: p_api_name => l_api_name,
2006: p_pkg_name => g_pkg_name,
2007: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2008: x_msg_count => x_msg_count,

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

2003: when OKC_API.G_EXCEPTION_ERROR then
2004: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2005: p_api_name => l_api_name,
2006: p_pkg_name => g_pkg_name,
2007: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,
2010: p_api_type => g_api_type);
2011:

Line 2012: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then

2008: x_msg_count => x_msg_count,
2009: x_msg_data => x_msg_data,
2010: p_api_type => g_api_type);
2011:
2012: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2013: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2014: p_api_name => l_api_name,
2015: p_pkg_name => g_pkg_name,
2016: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2013: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2009: x_msg_data => x_msg_data,
2010: p_api_type => g_api_type);
2011:
2012: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2013: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2014: p_api_name => l_api_name,
2015: p_pkg_name => g_pkg_name,
2016: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2017: x_msg_count => x_msg_count,

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

2012: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
2013: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2014: p_api_name => l_api_name,
2015: p_pkg_name => g_pkg_name,
2016: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
2017: x_msg_count => x_msg_count,
2018: x_msg_data => x_msg_data,
2019: p_api_type => g_api_type);
2020:

Line 2022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

2018: x_msg_data => x_msg_data,
2019: p_api_type => g_api_type);
2020:
2021: when OTHERS then
2022: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
2023: p_api_name => l_api_name,
2024: p_pkg_name => g_pkg_name,
2025: p_exc_name => 'OTHERS',
2026: x_msg_count => x_msg_count,