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

Line 3: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;

1: Package Body OKL_VP_K_ARTICLE_PVT AS
2: /* $Header: OKLRCARB.pls 120.1 2005/08/04 01:31:11 manumanu noship $ */
3: G_APP_NAME CONSTANT VARCHAR2(3) := OKL_API.G_APP_NAME;
4: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_VP_K_ARTICLE_PVT';
5: G_CHILD_RECORD_FOUND CONSTANT varchar2(200) := 'OKC_CHILD_RECORD_FOUND';
6: G_PARENT_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_PARENT_TABLE_TOKEN;
7: G_CHILD_TABLE_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_CHILD_TABLE_TOKEN;

Line 229: x_return_status := OKL_API.START_ACTIVITY(

225: l_api_version CONSTANT NUMBER := 1.0;
226: l_catv_rec catv_rec_type;
227: x_catv_rec catv_rec_type;
228: BEGIN
229: x_return_status := OKL_API.START_ACTIVITY(
230: p_api_name => l_api_name,
231: p_pkg_name => g_pkg_name,
232: p_init_msg_list => p_init_msg_list,
233: l_api_version => l_api_version,

Line 239: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

235: p_api_type => g_api_type,
236: x_return_status => x_return_status);
237: -- check if activity started successfully
238: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
239: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
240: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
241: raise OKL_API.G_EXCEPTION_ERROR;
242: End If;
243:

Line 241: raise OKL_API.G_EXCEPTION_ERROR;

237: -- check if activity started successfully
238: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
239: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
240: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
241: raise OKL_API.G_EXCEPTION_ERROR;
242: End If;
243:
244: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
245: p_sav_release => p_sae_release,

Line 286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

282: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
283: raise OKC_API.G_EXCEPTION_ERROR;
284: End If;
285: -- x_cat_id := x_catv_rec.id;
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);
288: EXCEPTION
289: when OKL_API.G_EXCEPTION_ERROR then
290: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 289: when OKL_API.G_EXCEPTION_ERROR then

285: -- x_cat_id := x_catv_rec.id;
286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);
288: EXCEPTION
289: when OKL_API.G_EXCEPTION_ERROR then
290: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
291: p_api_name => l_api_name,
292: p_pkg_name => g_pkg_name,
293: p_exc_name => 'OKC_API.G_RET_STS_ERROR',

Line 290: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

286: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
287: x_msg_data => x_msg_data);
288: EXCEPTION
289: when OKL_API.G_EXCEPTION_ERROR then
290: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
291: p_api_name => l_api_name,
292: p_pkg_name => g_pkg_name,
293: p_exc_name => 'OKC_API.G_RET_STS_ERROR',
294: x_msg_count => x_msg_count,

Line 298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

294: x_msg_count => x_msg_count,
295: x_msg_data => x_msg_data,
296: p_api_type => g_api_type);
297: when OKC_API.G_EXCEPTION_UNEXPECTED_ERROR then
298: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
299: p_api_name => l_api_name,
300: p_pkg_name => g_pkg_name,
301: p_exc_name => 'OKC_API.G_RET_STS_UNEXP_ERROR',
302: x_msg_count => x_msg_count,

Line 306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

302: x_msg_count => x_msg_count,
303: x_msg_data => x_msg_data,
304: p_api_type => g_api_type);
305: when OTHERS then
306: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
307: p_api_name => l_api_name,
308: p_pkg_name => g_pkg_name,
309: p_exc_name => 'OTHERS',
310: x_msg_count => x_msg_count,

Line 350: x_return_status := OKL_API.START_ACTIVITY(

346:
347: l_clob_text CLOB;
348:
349: BEGIN
350: x_return_status := OKL_API.START_ACTIVITY(
351: p_api_name => l_api_name,
352: p_pkg_name => g_pkg_name,
353: p_init_msg_list => p_init_msg_list,
354: l_api_version => l_api_version,

Line 360: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

356: p_api_type => g_api_type,
357: x_return_status => x_return_status);
358: -- check if activity started successfully
359: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
360: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
362: raise OKL_API.G_EXCEPTION_ERROR;
363: End If;
364: x_return_status := get_catv_rec(p_sae_id => p_sae_id,

Line 362: raise OKL_API.G_EXCEPTION_ERROR;

358: -- check if activity started successfully
359: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
360: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
361: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
362: raise OKL_API.G_EXCEPTION_ERROR;
363: End If;
364: x_return_status := get_catv_rec(p_sae_id => p_sae_id,
365: p_sav_release => p_sae_release,
366: x_catv_rec => l_catv_rec);

Line 410: --OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'article text cannot copy');

406: NULL;
407: CLOSE cur_text;
408: ELSE
409: CLOSE cur_text;
410: --OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'article text cannot copy');
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413:
414: -- Fix for bug 3254597. OKC 11.5.10 COMPATIBLE FIXES

Line 411: RAISE OKL_API.G_EXCEPTION_ERROR;

407: CLOSE cur_text;
408: ELSE
409: CLOSE cur_text;
410: --OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'article text cannot copy');
411: RAISE OKL_API.G_EXCEPTION_ERROR;
412: END IF;
413:
414: -- Fix for bug 3254597. OKC 11.5.10 COMPATIBLE FIXES
415:

Line 432: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

428:
429: -- END FIX 3254597 --
430:
431: -- x_cat_id := x_catv_rec.id;
432: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
433: x_msg_data => x_msg_data);
434: EXCEPTION
435: when OKC_API.G_EXCEPTION_ERROR then
436: x_return_status := OKC_API.HANDLE_EXCEPTIONS(

Line 496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

492: l_catv_rec catv_rec_type := p_catv_rec;
493: l_cvmv_rec OKC_CVM_PVT.cvmv_rec_type;
494: x_out_rec OKC_CVM_PVT.cvmv_rec_type;
495: l_api_name VARCHAR2(30) := 'create_k_article';
496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
497: begin
498:
499: x_return_status := OKL_API.G_RET_STS_SUCCESS;
500: x_return_status := OKL_API.START_ACTIVITY(

Line 499: x_return_status := OKL_API.G_RET_STS_SUCCESS;

495: l_api_name VARCHAR2(30) := 'create_k_article';
496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
497: begin
498:
499: x_return_status := OKL_API.G_RET_STS_SUCCESS;
500: x_return_status := OKL_API.START_ACTIVITY(
501: p_api_name => l_api_name,
502: p_pkg_name => g_pkg_name,
503: p_init_msg_list => p_init_msg_list,

Line 500: x_return_status := OKL_API.START_ACTIVITY(

496: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
497: begin
498:
499: x_return_status := OKL_API.G_RET_STS_SUCCESS;
500: x_return_status := OKL_API.START_ACTIVITY(
501: p_api_name => l_api_name,
502: p_pkg_name => g_pkg_name,
503: p_init_msg_list => p_init_msg_list,
504: l_api_version => p_api_version,

Line 510: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

506: p_api_type => g_api_type,
507: x_return_status => x_return_status);
508: -- check if activity started successfully
509: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
510: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
512: raise OKL_API.G_EXCEPTION_ERROR;
513: End If;
514:

Line 512: raise OKL_API.G_EXCEPTION_ERROR;

508: -- check if activity started successfully
509: If (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
510: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
511: Elsif (x_return_status = OKC_API.G_RET_STS_ERROR) then
512: raise OKL_API.G_EXCEPTION_ERROR;
513: End If;
514:
515: -- Not null Validation for Article Name
516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN

Line 516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN

512: raise OKL_API.G_EXCEPTION_ERROR;
513: End If;
514:
515: -- Not null Validation for Article Name
516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN
517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_ARTICLE_NAME_REQUIRED');
518: x_return_status :=okl_api.g_ret_sts_error;
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;

Line 517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_ARTICLE_NAME_REQUIRED');

513: End If;
514:
515: -- Not null Validation for Article Name
516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN
517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_ARTICLE_NAME_REQUIRED');
518: x_return_status :=okl_api.g_ret_sts_error;
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:

Line 518: x_return_status :=okl_api.g_ret_sts_error;

514:
515: -- Not null Validation for Article Name
516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN
517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_ARTICLE_NAME_REQUIRED');
518: x_return_status :=okl_api.g_ret_sts_error;
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:
522: IF (p_catv_rec.cat_type = 'STA') THEN

Line 519: RAISE OKL_API.G_EXCEPTION_ERROR;

515: -- Not null Validation for Article Name
516: IF ((l_catv_rec.name = OKL_API.G_MISS_CHAR) OR (l_catv_rec.name IS NULL)) THEN
517: OKL_API.SET_MESSAGE(p_app_name => g_app_name,p_msg_name => 'OKL_ARTICLE_NAME_REQUIRED');
518: x_return_status :=okl_api.g_ret_sts_error;
519: RAISE OKL_API.G_EXCEPTION_ERROR;
520: END IF;
521:
522: IF (p_catv_rec.cat_type = 'STA') THEN
523: create_article_by_reference(

Line 550: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cat_type values in (STA,NSD)');

546: p_catv_rec.comments
547: );
548: ELSE
549: -- raise an error saying that the parameter cat_type can only have values in ('STA','NSD')
550: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cat_type values in (STA,NSD)');
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: /* Manu 29-Jun-2005 Begin */

Line 551: RAISE OKL_API.G_EXCEPTION_ERROR;

547: );
548: ELSE
549: -- raise an error saying that the parameter cat_type can only have values in ('STA','NSD')
550: OKL_API.set_message(G_APP_NAME, G_REQUIRED_VALUE,G_COL_NAME_TOKEN,'cat_type values in (STA,NSD)');
551: RAISE OKL_API.G_EXCEPTION_ERROR;
552: END IF;
553:
554: /* Manu 29-Jun-2005 Begin */
555: IF (x_return_status = FND_API.G_RET_STS_SUCCESS) THEN

Line 567: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,

563: END IF;
564: /* Manu 29-Jun-2005 END */
565:
566:
567: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data);
569: EXCEPTION
570: when OKL_API.G_EXCEPTION_ERROR then
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

Line 570: when OKL_API.G_EXCEPTION_ERROR then

566:
567: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data);
569: EXCEPTION
570: when OKL_API.G_EXCEPTION_ERROR then
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
572: p_api_name => l_api_name,
573: p_pkg_name => g_pkg_name,
574: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

Line 571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

567: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,
568: x_msg_data => x_msg_data);
569: EXCEPTION
570: when OKL_API.G_EXCEPTION_ERROR then
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
572: p_api_name => l_api_name,
573: p_pkg_name => g_pkg_name,
574: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
575: x_msg_count => x_msg_count,

Line 574: p_exc_name => 'OKL_API.G_RET_STS_ERROR',

570: when OKL_API.G_EXCEPTION_ERROR then
571: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
572: p_api_name => l_api_name,
573: p_pkg_name => g_pkg_name,
574: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
575: x_msg_count => x_msg_count,
576: x_msg_data => x_msg_data,
577: p_api_type => g_api_type);
578: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

Line 578: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then

574: p_exc_name => 'OKL_API.G_RET_STS_ERROR',
575: x_msg_count => x_msg_count,
576: x_msg_data => x_msg_data,
577: p_api_type => g_api_type);
578: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
579: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,
582: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

Line 579: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

575: x_msg_count => x_msg_count,
576: x_msg_data => x_msg_data,
577: p_api_type => g_api_type);
578: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
579: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,
582: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
583: x_msg_count => x_msg_count,

Line 582: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',

578: when OKL_API.G_EXCEPTION_UNEXPECTED_ERROR then
579: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
580: p_api_name => l_api_name,
581: p_pkg_name => g_pkg_name,
582: p_exc_name => 'OKL_API.G_RET_STS_UNEXP_ERROR',
583: x_msg_count => x_msg_count,
584: x_msg_data => x_msg_data,
585: p_api_type => g_api_type);
586: when OTHERS then

Line 587: x_return_status := OKL_API.HANDLE_EXCEPTIONS(

583: x_msg_count => x_msg_count,
584: x_msg_data => x_msg_data,
585: p_api_type => g_api_type);
586: when OTHERS then
587: x_return_status := OKL_API.HANDLE_EXCEPTIONS(
588: p_api_name => l_api_name,
589: p_pkg_name => g_pkg_name,
590: p_exc_name => 'OTHERS',
591: x_msg_count => x_msg_count,