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

Line 52: IF(p_szr_rec.kle_sty_id IS NULL OR p_szr_rec.kle_sty_id = OKC_API.G_MISS_NUM) THEN

48: BEGIN
49: -- mvasudev, 10/12/2004, Bug#3909240
50: /*
51: -- check for stream type
52: IF(p_szr_rec.kle_sty_id IS NULL OR p_szr_rec.kle_sty_id = OKC_API.G_MISS_NUM) THEN
53: x_return_status := G_RET_STS_ERROR;
54: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
55: p_region_code => G_AK_REGION_NAME,
56: p_attribute_code => 'OKL_STREAM_TYPE');

Line 61: RAISE OKC_API.G_EXCEPTION_ERROR;

57: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
58: p_msg_name => 'OKL_REQUIRED_VALUE',
59: p_token1 => 'COL_NAME',
60: p_token1_value => l_ak_prompt);
61: RAISE OKC_API.G_EXCEPTION_ERROR;
62: END IF;
63: */
64: -- check for stream type subclass
65: IF(p_szr_rec.kle_sty_subclass IS NULL OR p_szr_rec.kle_sty_subclass = OKC_API.G_MISS_CHAR) THEN

Line 65: IF(p_szr_rec.kle_sty_subclass IS NULL OR p_szr_rec.kle_sty_subclass = OKC_API.G_MISS_CHAR) THEN

61: RAISE OKC_API.G_EXCEPTION_ERROR;
62: END IF;
63: */
64: -- check for stream type subclass
65: IF(p_szr_rec.kle_sty_subclass IS NULL OR p_szr_rec.kle_sty_subclass = OKC_API.G_MISS_CHAR) THEN
66: x_return_status := G_RET_STS_ERROR;
67: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
68: p_region_code => G_AK_REGION_NAME,
69: p_attribute_code => 'OKL_STREAM_TYPE_SUBCLASS');

Line 74: RAISE OKC_API.G_EXCEPTION_ERROR;

70: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
71: p_msg_name => 'OKL_REQUIRED_VALUE',
72: p_token1 => 'COL_NAME',
73: p_token1_value => l_ak_prompt);
74: RAISE OKC_API.G_EXCEPTION_ERROR;
75: END IF;
76: -- end,mvasudev, 10/12/2004, Bug#3909240
77:
78: -- check for top line id

Line 79: IF(p_szr_rec.top_line_id IS NULL OR p_szr_rec.top_line_id = OKC_API.G_MISS_NUM) THEN

75: END IF;
76: -- end,mvasudev, 10/12/2004, Bug#3909240
77:
78: -- check for top line id
79: IF(p_szr_rec.top_line_id IS NULL OR p_szr_rec.top_line_id = OKC_API.G_MISS_NUM) THEN
80: x_return_status := G_RET_STS_ERROR;
81: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
82: p_region_code => G_AK_REGION_NAME,
83: p_attribute_code => 'OKL_LA_SEC_INVESTOR');

Line 88: RAISE OKC_API.G_EXCEPTION_ERROR;

84: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
85: p_msg_name => 'OKL_REQUIRED_VALUE',
86: p_token1 => 'COL_NAME',
87: p_token1_value => l_ak_prompt);
88: RAISE OKC_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91: -- check for percent_stake
92: IF(p_szr_rec.kle_percent_stake IS NULL OR p_szr_rec.kle_percent_stake = OKC_API.G_MISS_NUM) THEN

Line 92: IF(p_szr_rec.kle_percent_stake IS NULL OR p_szr_rec.kle_percent_stake = OKC_API.G_MISS_NUM) THEN

88: RAISE OKC_API.G_EXCEPTION_ERROR;
89: END IF;
90:
91: -- check for percent_stake
92: IF(p_szr_rec.kle_percent_stake IS NULL OR p_szr_rec.kle_percent_stake = OKC_API.G_MISS_NUM) THEN
93: x_return_status := G_RET_STS_ERROR;
94: l_ak_prompt := Okl_Accounting_Util.Get_Message_Token(
95: p_region_code => G_AK_REGION_NAME,
96: p_attribute_code => 'OKL_SHARE_PERCENT');

Line 101: RAISE OKC_API.G_EXCEPTION_ERROR;

97: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
98: p_msg_name => 'OKL_REQUIRED_VALUE',
99: p_token1 => 'COL_NAME',
100: p_token1_value => l_ak_prompt);
101: RAISE OKC_API.G_EXCEPTION_ERROR;
102: ELSIF p_szr_rec.kle_percent_stake > 100 THEN
103: x_return_status := G_RET_STS_ERROR;
104: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
105: p_msg_name => 'OKL_LLA_PERCENT');

Line 106: RAISE OKC_API.G_EXCEPTION_ERROR;

102: ELSIF p_szr_rec.kle_percent_stake > 100 THEN
103: x_return_status := G_RET_STS_ERROR;
104: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
105: p_msg_name => 'OKL_LLA_PERCENT');
106: RAISE OKC_API.G_EXCEPTION_ERROR;
107: END IF;
108:
109: -- mvasudev, 10/12/2004, Bug#3909240
110: -- Check for unique Subclass for an Investor

Line 121: RAISE OKC_API.G_EXCEPTION_ERROR;

117: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
118: p_msg_name => 'OKL_INV_STY_UNIQUE',
119: p_token1 => 'STY_SUBCLASS',
120: p_token1_value => l_ak_prompt);
121: RAISE OKC_API.G_EXCEPTION_ERROR;
122: END LOOP;
123:
124:
125: -- mvasudev, v115.5

Line 143: RAISE OKC_API.G_EXCEPTION_ERROR;

139: OKL_API.SET_MESSAGE(p_app_name => G_APP_NAME,
140: p_msg_name => 'OKL_REV_SHARE_PERCENT',
141: p_token1 => 'TITLE',
142: p_token1_value => l_ak_prompt);
143: RAISE OKC_API.G_EXCEPTION_ERROR;
144: END IF;
145: END VALIDATE;
146:
147: PROCEDURE migrate_records(p_szr_rec IN szr_rec_type,

Line 255: x_return_status := OKC_API.G_RET_STS_SUCCESS;

251: l_found BOOLEAN := FALSE;
252: l_dummy VARCHAR2(1) := '?';
253: BEGIN
254:
255: x_return_status := OKC_API.G_RET_STS_SUCCESS;
256: -- call START_ACTIVITY to create savepoint, check compatibility
257: -- and initialize message list
258: x_return_status := OKC_API.START_ACTIVITY(
259: p_api_name => l_api_name,

Line 258: x_return_status := OKC_API.START_ACTIVITY(

254:
255: x_return_status := OKC_API.G_RET_STS_SUCCESS;
256: -- call START_ACTIVITY to create savepoint, check compatibility
257: -- and initialize message list
258: x_return_status := OKC_API.START_ACTIVITY(
259: p_api_name => l_api_name,
260: p_pkg_name => G_PKG_NAME,
261: p_init_msg_list => p_init_msg_list,
262: l_api_version => l_api_version,

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

264: p_api_type => G_API_TYPE,
265: x_return_status => x_return_status);
266:
267: -- check if activity started successfully
268: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
271: RAISE OKC_API.G_EXCEPTION_ERROR;
272: END IF;

Line 269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

265: x_return_status => x_return_status);
266:
267: -- check if activity started successfully
268: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
271: RAISE OKC_API.G_EXCEPTION_ERROR;
272: END IF;
273:

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

266:
267: -- check if activity started successfully
268: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
271: RAISE OKC_API.G_EXCEPTION_ERROR;
272: END IF;
273:
274: VALIDATE(p_szr_rec => p_szr_rec,

Line 271: RAISE OKC_API.G_EXCEPTION_ERROR;

267: -- check if activity started successfully
268: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
269: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
270: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
271: RAISE OKC_API.G_EXCEPTION_ERROR;
272: END IF;
273:
274: VALIDATE(p_szr_rec => p_szr_rec,
275: x_return_status => x_return_status);

Line 276: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

272: END IF;
273:
274: VALIDATE(p_szr_rec => p_szr_rec,
275: x_return_status => x_return_status);
276: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;
279:
280: OPEN l_okl_cle_sty_csr(p_szr_rec.top_line_id,p_szr_rec.kle_sty_subclass);

Line 277: RAISE OKC_API.G_EXCEPTION_ERROR;

273:
274: VALIDATE(p_szr_rec => p_szr_rec,
275: x_return_status => x_return_status);
276: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
277: RAISE OKC_API.G_EXCEPTION_ERROR;
278: END IF;
279:
280: OPEN l_okl_cle_sty_csr(p_szr_rec.top_line_id,p_szr_rec.kle_sty_subclass);
281: FETCH l_okl_cle_sty_csr INTO l_dummy;

Line 288: RAISE OKC_API.G_EXCEPTION_ERROR;

284:
285: IF(l_found) THEN
286: OKL_API.set_message(G_APP_NAME,'OKL_STY_NOT_UNIQUE');
287: x_return_status := G_RET_STS_ERROR;
288: RAISE OKC_API.G_EXCEPTION_ERROR;
289: END IF;
290:
291: migrate_records(p_szr_rec => p_szr_rec,
292: x_clev_rec => l_clev_rec,

Line 332: WHEN OKC_API.G_EXCEPTION_ERROR THEN

328: x_msg_data => x_msg_data);
329:
330:
331: EXCEPTION
332: WHEN OKC_API.G_EXCEPTION_ERROR THEN
333: IF l_okl_lse_csr%ISOPEN
334: THEN
335: CLOSE l_okl_lse_csr;
336: END IF;

Line 341: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

337: IF l_okl_cle_sty_csr%ISOPEN
338: THEN
339: CLOSE l_okl_cle_sty_csr;
340: END IF;
341: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
342: p_api_name => l_api_name,
343: p_pkg_name => G_PKG_NAME,
344: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
345: x_msg_count => x_msg_count,

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

340: END IF;
341: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
342: p_api_name => l_api_name,
343: p_pkg_name => G_PKG_NAME,
344: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,
347: p_api_type => G_API_TYPE);
348:

Line 349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

345: x_msg_count => x_msg_count,
346: x_msg_data => x_msg_data,
347: p_api_type => G_API_TYPE);
348:
349: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
350: IF l_okl_lse_csr%ISOPEN
351: THEN
352: CLOSE l_okl_lse_csr;
353: END IF;

Line 358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

354: IF l_okl_cle_sty_csr%ISOPEN
355: THEN
356: CLOSE l_okl_cle_sty_csr;
357: END IF;
358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
359: p_api_name => l_api_name,
360: p_pkg_name => G_PKG_NAME,
361: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
362: x_msg_count => x_msg_count,

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

357: END IF;
358: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
359: p_api_name => l_api_name,
360: p_pkg_name => G_PKG_NAME,
361: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
362: x_msg_count => x_msg_count,
363: x_msg_data => x_msg_data,
364: p_api_type => G_API_TYPE);
365:

Line 375: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

371: IF l_okl_cle_sty_csr%ISOPEN
372: THEN
373: CLOSE l_okl_cle_sty_csr;
374: END IF;
375: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
376: p_api_name => l_api_name,
377: p_pkg_name => G_PKG_NAME,
378: p_exc_name => 'OTHERS',
379: x_msg_count => x_msg_count,

Line 402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

398:
399:
400: l_szr_rec szr_rec_type;
401:
402: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
403: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INVESTOR_REVENUE';
404: l_api_version CONSTANT NUMBER := 1.0;
405:
406: BEGIN

Line 407: x_return_status := OKC_API.G_RET_STS_SUCCESS;

403: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_INVESTOR_REVENUE';
404: l_api_version CONSTANT NUMBER := 1.0;
405:
406: BEGIN
407: x_return_status := OKC_API.G_RET_STS_SUCCESS;
408: -- call START_ACTIVITY to create savepoint, check compatibility
409: -- and initialize message list
410: x_return_status := OKC_API.START_ACTIVITY(
411: p_api_name => l_api_name,

Line 410: x_return_status := OKC_API.START_ACTIVITY(

406: BEGIN
407: x_return_status := OKC_API.G_RET_STS_SUCCESS;
408: -- call START_ACTIVITY to create savepoint, check compatibility
409: -- and initialize message list
410: x_return_status := OKC_API.START_ACTIVITY(
411: p_api_name => l_api_name,
412: p_pkg_name => G_PKG_NAME,
413: p_init_msg_list => p_init_msg_list,
414: l_api_version => l_api_version,

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

416: p_api_type => G_API_TYPE,
417: x_return_status => x_return_status);
418:
419: -- check if activity started successfully
420: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
423: RAISE OKC_API.G_EXCEPTION_ERROR;
424: END IF;

Line 421: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

417: x_return_status => x_return_status);
418:
419: -- check if activity started successfully
420: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
423: RAISE OKC_API.G_EXCEPTION_ERROR;
424: END IF;
425:

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

418:
419: -- check if activity started successfully
420: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
423: RAISE OKC_API.G_EXCEPTION_ERROR;
424: END IF;
425:
426: VALIDATE(p_szr_rec => p_szr_rec,

Line 423: RAISE OKC_API.G_EXCEPTION_ERROR;

419: -- check if activity started successfully
420: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
421: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
422: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
423: RAISE OKC_API.G_EXCEPTION_ERROR;
424: END IF;
425:
426: VALIDATE(p_szr_rec => p_szr_rec,
427: x_return_status => x_return_status);

Line 428: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN

424: END IF;
425:
426: VALIDATE(p_szr_rec => p_szr_rec,
427: x_return_status => x_return_status);
428: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
429: RAISE OKC_API.G_EXCEPTION_ERROR;
430: END IF;
431:
432: migrate_records(p_szr_rec => p_szr_rec,

Line 429: RAISE OKC_API.G_EXCEPTION_ERROR;

425:
426: VALIDATE(p_szr_rec => p_szr_rec,
427: x_return_status => x_return_status);
428: IF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
429: RAISE OKC_API.G_EXCEPTION_ERROR;
430: END IF;
431:
432: migrate_records(p_szr_rec => p_szr_rec,
433: x_clev_rec => l_clev_rec,

Line 459: WHEN OKC_API.G_EXCEPTION_ERROR THEN

455: x_msg_data => x_msg_data);
456:
457:
458: EXCEPTION
459: WHEN OKC_API.G_EXCEPTION_ERROR THEN
460: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
461: p_api_name => l_api_name,
462: p_pkg_name => G_PKG_NAME,
463: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 460: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

456:
457:
458: EXCEPTION
459: WHEN OKC_API.G_EXCEPTION_ERROR THEN
460: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
461: p_api_name => l_api_name,
462: p_pkg_name => G_PKG_NAME,
463: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
464: x_msg_count => x_msg_count,

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

459: WHEN OKC_API.G_EXCEPTION_ERROR THEN
460: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
461: p_api_name => l_api_name,
462: p_pkg_name => G_PKG_NAME,
463: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
464: x_msg_count => x_msg_count,
465: x_msg_data => x_msg_data,
466: p_api_type => G_API_TYPE);
467:

Line 468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

464: x_msg_count => x_msg_count,
465: x_msg_data => x_msg_data,
466: p_api_type => G_API_TYPE);
467:
468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

465: x_msg_data => x_msg_data,
466: p_api_type => G_API_TYPE);
467:
468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
473: x_msg_count => x_msg_count,

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

468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
469: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
470: p_api_name => l_api_name,
471: p_pkg_name => G_PKG_NAME,
472: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
473: x_msg_count => x_msg_count,
474: x_msg_data => x_msg_data,
475: p_api_type => G_API_TYPE);
476:

Line 478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

474: x_msg_data => x_msg_data,
475: p_api_type => G_API_TYPE);
476:
477: WHEN OTHERS THEN
478: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
479: p_api_name => l_api_name,
480: p_pkg_name => G_PKG_NAME,
481: p_exc_name => 'OTHERS',
482: x_msg_count => x_msg_count,

Line 500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

496: IS
497: l_clev_rec clev_rec_type;
498: l_klev_rec klev_rec_type;
499:
500: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
501: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_INVESTOR_REVENUE';
502: l_api_version CONSTANT NUMBER := 1.0;
503:
504: BEGIN

Line 505: x_return_status := OKC_API.G_RET_STS_SUCCESS;

501: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_INVESTOR_REVENUE';
502: l_api_version CONSTANT NUMBER := 1.0;
503:
504: BEGIN
505: x_return_status := OKC_API.G_RET_STS_SUCCESS;
506: -- call START_ACTIVITY to create savepoint, check compatibility
507: -- and initialize message list
508: x_return_status := OKC_API.START_ACTIVITY(
509: p_api_name => l_api_name,

Line 508: x_return_status := OKC_API.START_ACTIVITY(

504: BEGIN
505: x_return_status := OKC_API.G_RET_STS_SUCCESS;
506: -- call START_ACTIVITY to create savepoint, check compatibility
507: -- and initialize message list
508: x_return_status := OKC_API.START_ACTIVITY(
509: p_api_name => l_api_name,
510: p_pkg_name => G_PKG_NAME,
511: p_init_msg_list => p_init_msg_list,
512: l_api_version => l_api_version,

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

514: p_api_type => G_API_TYPE,
515: x_return_status => x_return_status);
516:
517: -- check if activity started successfully
518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;

Line 519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

515: x_return_status => x_return_status);
516:
517: -- check if activity started successfully
518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523:

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

516:
517: -- check if activity started successfully
518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523:
524: migrate_records(p_szr_rec => p_szr_rec,

Line 521: RAISE OKC_API.G_EXCEPTION_ERROR;

517: -- check if activity started successfully
518: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
519: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
520: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
521: RAISE OKC_API.G_EXCEPTION_ERROR;
522: END IF;
523:
524: migrate_records(p_szr_rec => p_szr_rec,
525: x_clev_rec => l_clev_rec,

Line 547: WHEN OKC_API.G_EXCEPTION_ERROR THEN

543: --Call End Activity
544: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
545: x_msg_data => x_msg_data);
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
549: p_api_name => l_api_name,
550: p_pkg_name => G_PKG_NAME,
551: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 548: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

544: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
545: x_msg_data => x_msg_data);
546: EXCEPTION
547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
549: p_api_name => l_api_name,
550: p_pkg_name => G_PKG_NAME,
551: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
552: x_msg_count => x_msg_count,

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

547: WHEN OKC_API.G_EXCEPTION_ERROR THEN
548: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
549: p_api_name => l_api_name,
550: p_pkg_name => G_PKG_NAME,
551: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
552: x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data,
554: p_api_type => G_API_TYPE);
555:

Line 556: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

552: x_msg_count => x_msg_count,
553: x_msg_data => x_msg_data,
554: p_api_type => G_API_TYPE);
555:
556: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
558: p_api_name => l_api_name,
559: p_pkg_name => G_PKG_NAME,
560: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

553: x_msg_data => x_msg_data,
554: p_api_type => G_API_TYPE);
555:
556: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
558: p_api_name => l_api_name,
559: p_pkg_name => G_PKG_NAME,
560: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
561: x_msg_count => x_msg_count,

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

556: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
557: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
558: p_api_name => l_api_name,
559: p_pkg_name => G_PKG_NAME,
560: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
561: x_msg_count => x_msg_count,
562: x_msg_data => x_msg_data,
563: p_api_type => G_API_TYPE);
564:

Line 566: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

562: x_msg_data => x_msg_data,
563: p_api_type => G_API_TYPE);
564:
565: WHEN OTHERS THEN
566: x_return_status := OKC_API.HANDLE_EXCEPTIONS(
567: p_api_name => l_api_name,
568: p_pkg_name => G_PKG_NAME,
569: p_exc_name => 'OTHERS',
570: x_msg_count => x_msg_count,