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.OKC_K_ARTICLE_PUB dependencies on OKC_API

Line 5: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

1: package body OKC_K_ARTICLE_PUB as
2: /* $Header: OKCPCATB.pls 120.2.12020000.2 2012/07/10 09:37:46 harchand ship $ */
3: l_debug VARCHAR2(1) := NVL(FND_PROFILE.VALUE('AFLOG_ENABLED'),'N');
4:
5: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
6: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_K_ARTICLE_PUB';
7: G_API_VERSION CONSTANT NUMBER := 1;
8: G_SCOPE CONSTANT varchar2(4) := '_PUB';
9: ------------------------------------------------------------------------------

Line 43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,

39: variation_description OKC_K_ARTICLES_V.VARIATION_DESCRIPTION%TYPE,
40: name OKC_K_ARTICLES_V.NAME%TYPE,
41: -- text ... commented out to treat empty CLOB as an of empty content:
42: -- if need to nullify it then nullify contents, not the pointer
43: -- text OKC_K_ARTICLES_V.TEXT%TYPE := OKC_API.G_MISS_CHAR,
44: --+Hand code start
45: text OKC_K_ARTICLES_V.TEXT%TYPE,
46: --+Hand code end
47: attribute_category OKC_K_ARTICLES_V.ATTRIBUTE_CATEGORY%TYPE,

Line 753: OKC_API.SET_MESSAGE('OKC', 'OKC_NOTDEFINED_11510_UPG_TMPL','DOC_TYPE', p_doc_type);

749: IF (l_debug = 'Y') THEN
750: okc_debug.log('11400: Leaving Get_Unassign_Section_ID because there is no UPGRADE template for '||p_doc_type, 2);
751: okc_debug.Reset_Indentation;
752: END IF;
753: OKC_API.SET_MESSAGE('OKC', 'OKC_NOTDEFINED_11510_UPG_TMPL','DOC_TYPE', p_doc_type);
754: x_return_status := G_RET_STS_UNEXP_ERROR;
755: RETURN NULL;
756: END IF;
757: END IF;

Line 817: x_return_status := OKC_API.G_RET_STS_SUCCESS;

813: BEGIN
814: IF (l_debug = 'Y') THEN
815: okc_debug.log('11400: Entering Process_Non_Std_Article', 2);
816: END IF;
817: x_return_status := OKC_API.G_RET_STS_SUCCESS;
818: IF (p_catv_rec.id IS NOT NULL ) THEN
819: -- 1. Check current db state (is there std or nonstd)
820: OPEN art_id_crs(p_catv_rec.id);
821: FETCH art_id_crs INTO l_art_id, l_art_ver_id, l_std_yn;

Line 1050: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1046: x_msg_count OUT NOCOPY NUMBER,
1047: x_msg_data OUT NOCOPY VARCHAR2
1048: ) IS
1049: BEGIN
1050: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1051:
1052: IF (l_debug = 'Y') THEN
1053: okc_debug.Set_Indentation(G_PKG_NAME);
1054: okc_debug.log('11300: Entered Null_Out_Record', 2);

Line 1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1267: WHERE DOCUMENT_TYPE= p_doc_type
1268: AND DOCUMENT_ID = p_doc_id
1269: AND SCN_ID = p_scn_id;
1270: BEGIN
1271: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1272:
1273: IF (l_debug = 'Y') THEN
1274: okc_debug.Set_Indentation(G_PKG_NAME);
1275: okc_debug.log('11300: Entered Default_Record', 2);

Line 1291: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

1287: p_chr_id => gi_catv_rec.dnz_chr_id,
1288: x_doc_id => gi_catv_rec.document_id,
1289: x_doc_type => gi_catv_rec.document_type
1290: );
1291: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1292: IF (l_debug = 'Y') THEN
1293: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1294: okc_debug.Reset_Indentation;
1295: END IF;

Line 1319: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

1315: x_msg_count => x_msg_count,
1316: p_doc_id => gi_catv_rec.document_id,
1317: p_doc_type => gi_catv_rec.document_type
1318: );
1319: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1320: IF (l_debug = 'Y') THEN
1321: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1322: okc_debug.Reset_Indentation;
1323: END IF;

Line 1354: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then

1350: x_art_ver_id => gi_catv_rec.article_version_id,
1351: x_std_art_id => gi_catv_rec.ref_article_id,
1352: x_std_art_ver_id => gi_catv_rec.ref_article_version_id
1353: );
1354: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1355: IF (l_debug = 'Y') THEN
1356: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1357: okc_debug.Reset_Indentation;
1358: END IF;

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

1394: x_msg_data OUT NOCOPY VARCHAR2,
1395: p_catv_rec IN catv_rec_type,
1396: x_catv_rec OUT NOCOPY catv_rec_type) is
1397: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_ARTICLE';
1398: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1399: -- l_clob clob;
1400: BEGIN
1401: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1402: G_PKG_NAME,

Line 1401: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1397: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_ARTICLE';
1398: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1399: -- l_clob clob;
1400: BEGIN
1401: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1402: G_PKG_NAME,
1403: p_init_msg_list,
1404: G_API_VERSION,
1405: p_api_version,

Line 1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1404: G_API_VERSION,
1405: p_api_version,
1406: G_SCOPE,
1407: x_return_status);
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;

Line 1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1405: p_api_version,
1406: G_SCOPE,
1407: x_return_status);
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: --

Line 1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1406: G_SCOPE,
1407: x_return_status);
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: --
1414: -- code for temporary clob ... start

Line 1411: RAISE OKC_API.G_EXCEPTION_ERROR;

1407: x_return_status);
1408: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1409: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1410: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1411: RAISE OKC_API.G_EXCEPTION_ERROR;
1412: END IF;
1413: --
1414: -- code for temporary clob ... start
1415: --

Line 1449: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1445: x_return_status => l_return_status,
1446: x_msg_count => x_msg_count,
1447: x_msg_data => x_msg_data
1448: );
1449: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1452: RAISE OKC_API.G_EXCEPTION_ERROR;
1453: END IF;

Line 1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1446: x_msg_count => x_msg_count,
1447: x_msg_data => x_msg_data
1448: );
1449: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1452: RAISE OKC_API.G_EXCEPTION_ERROR;
1453: END IF;
1454:

Line 1451: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1447: x_msg_data => x_msg_data
1448: );
1449: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1452: RAISE OKC_API.G_EXCEPTION_ERROR;
1453: END IF;
1454:
1455: Default_Record(

Line 1452: RAISE OKC_API.G_EXCEPTION_ERROR;

1448: );
1449: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1450: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1451: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1452: RAISE OKC_API.G_EXCEPTION_ERROR;
1453: END IF;
1454:
1455: Default_Record(
1456: p_api_version => p_api_version,

Line 1461: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1457: x_return_status => l_return_status,
1458: x_msg_count => x_msg_count,
1459: x_msg_data => x_msg_data
1460: );
1461: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_ERROR;
1465: END IF;

Line 1462: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1458: x_msg_count => x_msg_count,
1459: x_msg_data => x_msg_data
1460: );
1461: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_ERROR;
1465: END IF;
1466:

Line 1463: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1459: x_msg_data => x_msg_data
1460: );
1461: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_ERROR;
1465: END IF;
1466:
1467: IF (l_debug = 'Y') THEN

Line 1464: RAISE OKC_API.G_EXCEPTION_ERROR;

1460: );
1461: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1462: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1463: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1464: RAISE OKC_API.G_EXCEPTION_ERROR;
1465: END IF;
1466:
1467: IF (l_debug = 'Y') THEN
1468: Dump_Rec( gi_catv_rec );

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

1515: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
1516: x_id => gi_catv_rec.id,
1517: p_mandatory_rwa => gi_catv_rec.mandatory_rwa
1518: );
1519: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1521: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1522: RAISE OKC_API.G_EXCEPTION_ERROR;
1523: END IF;

Line 1520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1516: x_id => gi_catv_rec.id,
1517: p_mandatory_rwa => gi_catv_rec.mandatory_rwa
1518: );
1519: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1521: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1522: RAISE OKC_API.G_EXCEPTION_ERROR;
1523: END IF;
1524:

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

1517: p_mandatory_rwa => gi_catv_rec.mandatory_rwa
1518: );
1519: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1521: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1522: RAISE OKC_API.G_EXCEPTION_ERROR;
1523: END IF;
1524:
1525: -- Set OUT values

Line 1522: RAISE OKC_API.G_EXCEPTION_ERROR;

1518: );
1519: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1520: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1521: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1522: RAISE OKC_API.G_EXCEPTION_ERROR;
1523: END IF;
1524:
1525: -- Set OUT values
1526: x_catv_rec := get_rec( gi_catv_rec.id );

Line 1534: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1530: okc_debug.log('1000: Leaving '||l_api_name, 2);
1531: Dump_Rec( x_catv_rec );
1532: END IF;
1533:
1534: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1535: EXCEPTION
1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1538: (substr(l_api_name,1,26),

Line 1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1532: END IF;
1533:
1534: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1535: EXCEPTION
1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1538: (substr(l_api_name,1,26),
1539: G_PKG_NAME,
1540: 'OKC_API.G_RET_STS_ERROR',

Line 1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1533:
1534: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1535: EXCEPTION
1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1538: (substr(l_api_name,1,26),
1539: G_PKG_NAME,
1540: 'OKC_API.G_RET_STS_ERROR',
1541: x_msg_count,

Line 1540: 'OKC_API.G_RET_STS_ERROR',

1536: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1538: (substr(l_api_name,1,26),
1539: G_PKG_NAME,
1540: 'OKC_API.G_RET_STS_ERROR',
1541: x_msg_count,
1542: x_msg_data,
1543: G_SCOPE);
1544: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1544: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1540: 'OKC_API.G_RET_STS_ERROR',
1541: x_msg_count,
1542: x_msg_data,
1543: G_SCOPE);
1544: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1545: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1546: (substr(l_api_name,1,26),
1547: G_PKG_NAME,
1548: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1545: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1541: x_msg_count,
1542: x_msg_data,
1543: G_SCOPE);
1544: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1545: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1546: (substr(l_api_name,1,26),
1547: G_PKG_NAME,
1548: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1549: x_msg_count,

Line 1548: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1544: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1545: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1546: (substr(l_api_name,1,26),
1547: G_PKG_NAME,
1548: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1549: x_msg_count,
1550: x_msg_data,
1551: G_SCOPE);
1552: WHEN OTHERS THEN

Line 1553: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1549: x_msg_count,
1550: x_msg_data,
1551: G_SCOPE);
1552: WHEN OTHERS THEN
1553: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1554: (substr(l_api_name,1,26),
1555: G_PKG_NAME,
1556: 'OTHERS',
1557: x_msg_count,

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

1575: p_catv_tbl IN catv_tbl_type,
1576: x_catv_tbl OUT NOCOPY catv_tbl_type) is
1577: c NUMBER;
1578: i NUMBER;
1579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1580: BEGIN
1581: OKC_API.init_msg_list(p_init_msg_list);
1582: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1583: c:=p_catv_tbl.COUNT;

Line 1581: OKC_API.init_msg_list(p_init_msg_list);

1577: c NUMBER;
1578: i NUMBER;
1579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1580: BEGIN
1581: OKC_API.init_msg_list(p_init_msg_list);
1582: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1583: c:=p_catv_tbl.COUNT;
1584: if (c>0) then
1585: i := p_catv_tbl.FIRST;

Line 1582: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1578: i NUMBER;
1579: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1580: BEGIN
1581: OKC_API.init_msg_list(p_init_msg_list);
1582: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1583: c:=p_catv_tbl.COUNT;
1584: if (c>0) then
1585: i := p_catv_tbl.FIRST;
1586: LOOP

Line 1590: p_init_msg_list => OKC_API.G_FALSE,

1586: LOOP
1587: create_k_article
1588: (
1589: p_api_version => p_api_version,
1590: p_init_msg_list => OKC_API.G_FALSE,
1591: x_return_status => l_return_status,
1592: x_msg_count => x_msg_count,
1593: x_msg_data => x_msg_data,
1594: p_catv_rec => p_catv_tbl(i),

Line 1597: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1593: x_msg_data => x_msg_data,
1594: p_catv_rec => p_catv_tbl(i),
1595: x_catv_rec => x_catv_tbl(i)
1596: );
1597: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1598: x_return_status := l_return_status;
1599: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1601: x_return_status := l_return_status;

Line 1599: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1595: x_catv_rec => x_catv_tbl(i)
1596: );
1597: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1598: x_return_status := l_return_status;
1599: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1601: x_return_status := l_return_status;
1602: end if;
1603: c:=c-1;

Line 1600: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1596: );
1597: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1598: x_return_status := l_return_status;
1599: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1600: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1601: x_return_status := l_return_status;
1602: end if;
1603: c:=c-1;
1604: EXIT WHEN (c=0);

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

1623: x_msg_count OUT NOCOPY NUMBER,
1624: x_msg_data OUT NOCOPY VARCHAR2,
1625: p_catv_rec IN catv_rec_type) is
1626: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_K_ARTICLE';
1627: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1628: BEGIN
1629: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1630: G_PKG_NAME,
1631: p_init_msg_list,

Line 1629: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

1625: p_catv_rec IN catv_rec_type) is
1626: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_K_ARTICLE';
1627: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1628: BEGIN
1629: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1630: G_PKG_NAME,
1631: p_init_msg_list,
1632: G_API_VERSION,
1633: p_api_version,

Line 1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1632: G_API_VERSION,
1633: p_api_version,
1634: G_SCOPE,
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;

Line 1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1633: p_api_version,
1634: G_SCOPE,
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641:

Line 1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1634: G_SCOPE,
1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641:
1642: OKC_K_ARTICLES_GRP.lock_row(

Line 1639: RAISE OKC_API.G_EXCEPTION_ERROR;

1635: x_return_status);
1636: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1637: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1638: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1639: RAISE OKC_API.G_EXCEPTION_ERROR;
1640: END IF;
1641:
1642: OKC_K_ARTICLES_GRP.lock_row(
1643: p_api_version => p_api_version,

Line 1644: p_init_msg_list => OKC_API.G_FALSE,

1640: END IF;
1641:
1642: OKC_K_ARTICLES_GRP.lock_row(
1643: p_api_version => p_api_version,
1644: p_init_msg_list => OKC_API.G_FALSE,
1645: x_return_status => x_return_status,
1646: x_msg_count => x_msg_count,
1647: x_msg_data => x_msg_data,
1648: p_id => p_catv_rec.id,

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

1647: x_msg_data => x_msg_data,
1648: p_id => p_catv_rec.id,
1649: p_object_version_number => p_catv_rec.object_version_number
1650: );
1651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;

Line 1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1648: p_id => p_catv_rec.id,
1649: p_object_version_number => p_catv_rec.object_version_number
1650: );
1651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1649: p_object_version_number => p_catv_rec.object_version_number
1650: );
1651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1657: EXCEPTION

Line 1654: RAISE OKC_API.G_EXCEPTION_ERROR;

1650: );
1651: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1657: EXCEPTION
1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1652: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1657: EXCEPTION
1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1660: (substr(l_api_name,1,26),

Line 1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1654: RAISE OKC_API.G_EXCEPTION_ERROR;
1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1657: EXCEPTION
1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1660: (substr(l_api_name,1,26),
1661: G_PKG_NAME,
1662: 'OKC_API.G_RET_STS_ERROR',

Line 1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1655: END IF;
1656: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1657: EXCEPTION
1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1660: (substr(l_api_name,1,26),
1661: G_PKG_NAME,
1662: 'OKC_API.G_RET_STS_ERROR',
1663: x_msg_count,

Line 1662: 'OKC_API.G_RET_STS_ERROR',

1658: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1660: (substr(l_api_name,1,26),
1661: G_PKG_NAME,
1662: 'OKC_API.G_RET_STS_ERROR',
1663: x_msg_count,
1664: x_msg_data,
1665: G_SCOPE);
1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1662: 'OKC_API.G_RET_STS_ERROR',
1663: x_msg_count,
1664: x_msg_data,
1665: G_SCOPE);
1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1668: (substr(l_api_name,1,26),
1669: G_PKG_NAME,
1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1663: x_msg_count,
1664: x_msg_data,
1665: G_SCOPE);
1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1668: (substr(l_api_name,1,26),
1669: G_PKG_NAME,
1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1671: x_msg_count,

Line 1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1666: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1668: (substr(l_api_name,1,26),
1669: G_PKG_NAME,
1670: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1671: x_msg_count,
1672: x_msg_data,
1673: G_SCOPE);
1674: WHEN OTHERS THEN

Line 1675: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1671: x_msg_count,
1672: x_msg_data,
1673: G_SCOPE);
1674: WHEN OTHERS THEN
1675: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1676: (substr(l_api_name,1,26),
1677: G_PKG_NAME,
1678: 'OTHERS',
1679: x_msg_count,

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

1695: x_msg_count OUT NOCOPY NUMBER,
1696: x_msg_data OUT NOCOPY VARCHAR2,
1697: p_catv_tbl IN catv_tbl_type) is
1698: i NUMBER;
1699: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1700: begin
1701: OKC_API.init_msg_list(p_init_msg_list);
1702: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1703: if (p_catv_tbl.COUNT>0) then

Line 1701: OKC_API.init_msg_list(p_init_msg_list);

1697: p_catv_tbl IN catv_tbl_type) is
1698: i NUMBER;
1699: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1700: begin
1701: OKC_API.init_msg_list(p_init_msg_list);
1702: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1703: if (p_catv_tbl.COUNT>0) then
1704: i := p_catv_tbl.FIRST;
1705: LOOP

Line 1702: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1698: i NUMBER;
1699: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1700: begin
1701: OKC_API.init_msg_list(p_init_msg_list);
1702: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1703: if (p_catv_tbl.COUNT>0) then
1704: i := p_catv_tbl.FIRST;
1705: LOOP
1706: lock_k_article(p_api_version=>p_api_version,

Line 1707: p_init_msg_list=>OKC_API.G_FALSE,

1703: if (p_catv_tbl.COUNT>0) then
1704: i := p_catv_tbl.FIRST;
1705: LOOP
1706: lock_k_article(p_api_version=>p_api_version,
1707: p_init_msg_list=>OKC_API.G_FALSE,
1708: x_return_status=>l_return_status,
1709: x_msg_count=>x_msg_count,
1710: x_msg_data=>x_msg_data,
1711: p_catv_rec=>p_catv_tbl(i));

Line 1712: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

1708: x_return_status=>l_return_status,
1709: x_msg_count=>x_msg_count,
1710: x_msg_data=>x_msg_data,
1711: p_catv_rec=>p_catv_tbl(i));
1712: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1713: x_return_status := l_return_status;
1714: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1716: x_return_status := l_return_status;

Line 1714: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1710: x_msg_data=>x_msg_data,
1711: p_catv_rec=>p_catv_tbl(i));
1712: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1713: x_return_status := l_return_status;
1714: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1716: x_return_status := l_return_status;
1717: end if;
1718: EXIT WHEN (i=p_catv_tbl.LAST);

Line 1715: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

1711: p_catv_rec=>p_catv_tbl(i));
1712: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1713: x_return_status := l_return_status;
1714: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1715: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1716: x_return_status := l_return_status;
1717: end if;
1718: EXIT WHEN (i=p_catv_tbl.LAST);
1719: i := p_catv_tbl.NEXT(i);

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

2054: x_msg_data OUT NOCOPY VARCHAR2,
2055: p_catv_rec IN catv_rec_type,
2056: x_catv_rec OUT NOCOPY catv_rec_type) is
2057: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
2058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2059: l_catv_rec catv_rec_type;
2060: begin
2061: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2062: G_PKG_NAME,

Line 2061: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

2057: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
2058: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2059: l_catv_rec catv_rec_type;
2060: begin
2061: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2062: G_PKG_NAME,
2063: p_init_msg_list,
2064: G_API_VERSION,
2065: p_api_version,

Line 2068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2064: G_API_VERSION,
2065: p_api_version,
2066: G_SCOPE,
2067: x_return_status);
2068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;

Line 2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2065: p_api_version,
2066: G_SCOPE,
2067: x_return_status);
2068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: --

Line 2070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2066: G_SCOPE,
2067: x_return_status);
2068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: --
2074: -- code for temporary clob ... start

Line 2071: RAISE OKC_API.G_EXCEPTION_ERROR;

2067: x_return_status);
2068: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2069: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2070: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2071: RAISE OKC_API.G_EXCEPTION_ERROR;
2072: END IF;
2073: --
2074: -- code for temporary clob ... start
2075: --

Line 2106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2102: x_return_status => l_return_status,
2103: x_msg_count => x_msg_count,
2104: x_msg_data => x_msg_data
2105: );
2106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2109: RAISE OKC_API.G_EXCEPTION_ERROR;
2110: END IF;

Line 2107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2103: x_msg_count => x_msg_count,
2104: x_msg_data => x_msg_data
2105: );
2106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2109: RAISE OKC_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:

Line 2108: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2104: x_msg_data => x_msg_data
2105: );
2106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2109: RAISE OKC_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: Flip_GMISS_Record;

Line 2109: RAISE OKC_API.G_EXCEPTION_ERROR;

2105: );
2106: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2107: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2108: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2109: RAISE OKC_API.G_EXCEPTION_ERROR;
2110: END IF;
2111:
2112: Flip_GMISS_Record;
2113:

Line 2121: p_init_msg_list => OKC_API.G_FALSE,

2117: END IF;
2118:
2119: OKC_K_ARTICLES_GRP.update_article(
2120: p_api_version => p_api_version,
2121: p_init_msg_list => OKC_API.G_FALSE,
2122: x_return_status => x_return_status,
2123: x_msg_count => x_msg_count,
2124: x_msg_data => x_msg_data,
2125: p_id => gi_catv_rec.id,

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

2159: p_object_version_number => gi_catv_rec.object_version_number,
2160: p_mandatory_rwa => gi_catv_rec.mandatory_rwa
2161:
2162: );
2163: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2166: RAISE OKC_API.G_EXCEPTION_ERROR;
2167: END IF;

Line 2164: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2160: p_mandatory_rwa => gi_catv_rec.mandatory_rwa
2161:
2162: );
2163: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2166: RAISE OKC_API.G_EXCEPTION_ERROR;
2167: END IF;
2168:

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

2161:
2162: );
2163: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2166: RAISE OKC_API.G_EXCEPTION_ERROR;
2167: END IF;
2168:
2169: -- Set OUT values

Line 2166: RAISE OKC_API.G_EXCEPTION_ERROR;

2162: );
2163: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2164: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2165: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2166: RAISE OKC_API.G_EXCEPTION_ERROR;
2167: END IF;
2168:
2169: -- Set OUT values
2170: x_catv_rec := get_rec( gi_catv_rec.id );

Line 2178: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2174: okc_debug.log('1000: Leaving '||l_api_name, 2);
2175: Dump_Rec( x_catv_rec );
2176: END IF;
2177:
2178: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2179: EXCEPTION
2180: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2181: IF (l_debug = 'Y') THEN
2182: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);

Line 2180: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2176: END IF;
2177:
2178: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2179: EXCEPTION
2180: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2181: IF (l_debug = 'Y') THEN
2182: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2183: END IF;
2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2180: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2181: IF (l_debug = 'Y') THEN
2182: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2183: END IF;
2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2185: (substr(l_api_name,1,26),
2186: G_PKG_NAME,
2187: 'OKC_API.G_RET_STS_ERROR',
2188: x_msg_count,

Line 2187: 'OKC_API.G_RET_STS_ERROR',

2183: END IF;
2184: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2185: (substr(l_api_name,1,26),
2186: G_PKG_NAME,
2187: 'OKC_API.G_RET_STS_ERROR',
2188: x_msg_count,
2189: x_msg_data,
2190: G_SCOPE);
2191: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2191: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2187: 'OKC_API.G_RET_STS_ERROR',
2188: x_msg_count,
2189: x_msg_data,
2190: G_SCOPE);
2191: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2192: IF (l_debug = 'Y') THEN
2193: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2194: END IF;
2195: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2195: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2191: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2192: IF (l_debug = 'Y') THEN
2193: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2194: END IF;
2195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2196: (substr(l_api_name,1,26),
2197: G_PKG_NAME,
2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2199: x_msg_count,

Line 2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2194: END IF;
2195: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2196: (substr(l_api_name,1,26),
2197: G_PKG_NAME,
2198: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2199: x_msg_count,
2200: x_msg_data,
2201: G_SCOPE);
2202: WHEN OTHERS THEN

Line 2206: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2202: WHEN OTHERS THEN
2203: IF (l_debug = 'Y') THEN
2204: okc_debug.log('500: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm, 2);
2205: END IF;
2206: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2207: (substr(l_api_name,1,26),
2208: G_PKG_NAME,
2209: 'OTHERS',
2210: x_msg_count,

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

2228: x_msg_data OUT NOCOPY VARCHAR2,
2229: p_catv_tbl IN catv_tbl_type,
2230: x_catv_tbl OUT NOCOPY catv_tbl_type) is
2231: i NUMBER;
2232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2233: begin
2234: OKC_API.init_msg_list(p_init_msg_list);
2235: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2236: if (p_catv_tbl.COUNT>0) then

Line 2234: OKC_API.init_msg_list(p_init_msg_list);

2230: x_catv_tbl OUT NOCOPY catv_tbl_type) is
2231: i NUMBER;
2232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2233: begin
2234: OKC_API.init_msg_list(p_init_msg_list);
2235: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2236: if (p_catv_tbl.COUNT>0) then
2237: i := p_catv_tbl.FIRST;
2238: LOOP

Line 2235: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2231: i NUMBER;
2232: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2233: begin
2234: OKC_API.init_msg_list(p_init_msg_list);
2235: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2236: if (p_catv_tbl.COUNT>0) then
2237: i := p_catv_tbl.FIRST;
2238: LOOP
2239:

Line 2241: p_init_msg_list=>OKC_API.G_FALSE,

2237: i := p_catv_tbl.FIRST;
2238: LOOP
2239:
2240: update_k_article(p_api_version=>p_api_version,
2241: p_init_msg_list=>OKC_API.G_FALSE,
2242: x_return_status=>l_return_status,
2243: x_msg_count=>x_msg_count,
2244: x_msg_data=>x_msg_data,
2245: p_catv_rec=> p_catv_tbl(i),

Line 2247: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

2243: x_msg_count=>x_msg_count,
2244: x_msg_data=>x_msg_data,
2245: p_catv_rec=> p_catv_tbl(i),
2246: x_catv_rec=>x_catv_tbl(i));
2247: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2248: x_return_status := l_return_status;
2249: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2250: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2251: x_return_status := l_return_status;

Line 2249: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2245: p_catv_rec=> p_catv_tbl(i),
2246: x_catv_rec=>x_catv_tbl(i));
2247: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2248: x_return_status := l_return_status;
2249: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2250: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2251: x_return_status := l_return_status;
2252: end if;
2253: EXIT WHEN (i=p_catv_tbl.LAST);

Line 2250: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

2246: x_catv_rec=>x_catv_tbl(i));
2247: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2248: x_return_status := l_return_status;
2249: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2250: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2251: x_return_status := l_return_status;
2252: end if;
2253: EXIT WHEN (i=p_catv_tbl.LAST);
2254: i := p_catv_tbl.NEXT(i);

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

2272: x_msg_count OUT NOCOPY NUMBER,
2273: x_msg_data OUT NOCOPY VARCHAR2,
2274: p_catv_rec IN catv_rec_type) is
2275: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
2276: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2277: begin
2278: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2279: G_PKG_NAME,
2280: p_init_msg_list,

Line 2278: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

2274: p_catv_rec IN catv_rec_type) is
2275: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
2276: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2277: begin
2278: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2279: G_PKG_NAME,
2280: p_init_msg_list,
2281: G_API_VERSION,
2282: p_api_version,

Line 2285: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2281: G_API_VERSION,
2282: p_api_version,
2283: G_SCOPE,
2284: x_return_status);
2285: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2287: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_ERROR;
2289: END IF;

Line 2286: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2282: p_api_version,
2283: G_SCOPE,
2284: x_return_status);
2285: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2287: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_ERROR;
2289: END IF;
2290: OKC_K_ARTICLES_GRP.delete_article(

Line 2287: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2283: G_SCOPE,
2284: x_return_status);
2285: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2287: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_ERROR;
2289: END IF;
2290: OKC_K_ARTICLES_GRP.delete_article(
2291: p_api_version => p_api_version,

Line 2288: RAISE OKC_API.G_EXCEPTION_ERROR;

2284: x_return_status);
2285: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2286: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2287: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2288: RAISE OKC_API.G_EXCEPTION_ERROR;
2289: END IF;
2290: OKC_K_ARTICLES_GRP.delete_article(
2291: p_api_version => p_api_version,
2292: p_init_msg_list => OKC_API.G_FALSE,

Line 2292: p_init_msg_list => OKC_API.G_FALSE,

2288: RAISE OKC_API.G_EXCEPTION_ERROR;
2289: END IF;
2290: OKC_K_ARTICLES_GRP.delete_article(
2291: p_api_version => p_api_version,
2292: p_init_msg_list => OKC_API.G_FALSE,
2293: x_return_status => x_return_status,
2294: x_msg_count => x_msg_count,
2295: x_msg_data => x_msg_data,
2296: p_validation_string => NULL,

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

2296: p_validation_string => NULL,
2297: p_id => p_catv_rec.id,
2298: p_object_version_number => p_catv_rec.object_version_number
2299: );
2300: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;

Line 2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2297: p_id => p_catv_rec.id,
2298: p_object_version_number => p_catv_rec.object_version_number
2299: );
2300: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2298: p_object_version_number => p_catv_rec.object_version_number
2299: );
2300: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2306: EXCEPTION

Line 2303: RAISE OKC_API.G_EXCEPTION_ERROR;

2299: );
2300: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2301: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2302: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (substr(l_api_name,1,26),

Line 2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2303: RAISE OKC_API.G_EXCEPTION_ERROR;
2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (substr(l_api_name,1,26),
2310: G_PKG_NAME,
2311: 'OKC_API.G_RET_STS_ERROR',

Line 2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2304: END IF;
2305: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2306: EXCEPTION
2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (substr(l_api_name,1,26),
2310: G_PKG_NAME,
2311: 'OKC_API.G_RET_STS_ERROR',
2312: x_msg_count,

Line 2311: 'OKC_API.G_RET_STS_ERROR',

2307: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (substr(l_api_name,1,26),
2310: G_PKG_NAME,
2311: 'OKC_API.G_RET_STS_ERROR',
2312: x_msg_count,
2313: x_msg_data,
2314: G_SCOPE);
2315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2311: 'OKC_API.G_RET_STS_ERROR',
2312: x_msg_count,
2313: x_msg_data,
2314: G_SCOPE);
2315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2316: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2317: (substr(l_api_name,1,26),
2318: G_PKG_NAME,
2319: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2316: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2312: x_msg_count,
2313: x_msg_data,
2314: G_SCOPE);
2315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2316: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2317: (substr(l_api_name,1,26),
2318: G_PKG_NAME,
2319: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2320: x_msg_count,

Line 2319: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2315: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2316: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2317: (substr(l_api_name,1,26),
2318: G_PKG_NAME,
2319: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2320: x_msg_count,
2321: x_msg_data,
2322: G_SCOPE);
2323: WHEN OTHERS THEN

Line 2324: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2320: x_msg_count,
2321: x_msg_data,
2322: G_SCOPE);
2323: WHEN OTHERS THEN
2324: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2325: (substr(l_api_name,1,26),
2326: G_PKG_NAME,
2327: 'OTHERS',
2328: x_msg_count,

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

2345: x_msg_count OUT NOCOPY NUMBER,
2346: x_msg_data OUT NOCOPY VARCHAR2,
2347: p_catv_tbl IN catv_tbl_type) is
2348: i NUMBER;
2349: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2350: begin
2351: OKC_API.init_msg_list(p_init_msg_list);
2352: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2353: if (p_catv_tbl.COUNT>0) then

Line 2351: OKC_API.init_msg_list(p_init_msg_list);

2347: p_catv_tbl IN catv_tbl_type) is
2348: i NUMBER;
2349: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2350: begin
2351: OKC_API.init_msg_list(p_init_msg_list);
2352: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2353: if (p_catv_tbl.COUNT>0) then
2354: i := p_catv_tbl.FIRST;
2355: LOOP

Line 2352: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2348: i NUMBER;
2349: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2350: begin
2351: OKC_API.init_msg_list(p_init_msg_list);
2352: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2353: if (p_catv_tbl.COUNT>0) then
2354: i := p_catv_tbl.FIRST;
2355: LOOP
2356: delete_k_article(p_api_version=>p_api_version,

Line 2357: p_init_msg_list=>OKC_API.G_FALSE,

2353: if (p_catv_tbl.COUNT>0) then
2354: i := p_catv_tbl.FIRST;
2355: LOOP
2356: delete_k_article(p_api_version=>p_api_version,
2357: p_init_msg_list=>OKC_API.G_FALSE,
2358: x_return_status=>l_return_status,
2359: x_msg_count=>x_msg_count,
2360: x_msg_data=>x_msg_data,
2361: p_catv_rec=>p_catv_tbl(i));

Line 2362: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

2358: x_return_status=>l_return_status,
2359: x_msg_count=>x_msg_count,
2360: x_msg_data=>x_msg_data,
2361: p_catv_rec=>p_catv_tbl(i));
2362: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2363: x_return_status := l_return_status;
2364: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2365: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2366: x_return_status := l_return_status;

Line 2364: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2360: x_msg_data=>x_msg_data,
2361: p_catv_rec=>p_catv_tbl(i));
2362: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2363: x_return_status := l_return_status;
2364: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2365: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2366: x_return_status := l_return_status;
2367: end if;
2368: EXIT WHEN (i=p_catv_tbl.LAST);

Line 2365: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

2361: p_catv_rec=>p_catv_tbl(i));
2362: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2363: x_return_status := l_return_status;
2364: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2365: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2366: x_return_status := l_return_status;
2367: end if;
2368: EXIT WHEN (i=p_catv_tbl.LAST);
2369: i := p_catv_tbl.NEXT(i);

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

2387: x_msg_count OUT NOCOPY NUMBER,
2388: x_msg_data OUT NOCOPY VARCHAR2,
2389: p_catv_rec IN catv_rec_type) is
2390: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_K_ARTICLE';
2391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2392: begin
2393: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2394: G_PKG_NAME,
2395: p_init_msg_list,

Line 2393: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),

2389: p_catv_rec IN catv_rec_type) is
2390: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_K_ARTICLE';
2391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2392: begin
2393: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2394: G_PKG_NAME,
2395: p_init_msg_list,
2396: G_API_VERSION,
2397: p_api_version,

Line 2400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

2396: G_API_VERSION,
2397: p_api_version,
2398: G_SCOPE,
2399: x_return_status);
2400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;

Line 2401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2397: p_api_version,
2398: G_SCOPE,
2399: x_return_status);
2400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;
2405:

Line 2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

2398: G_SCOPE,
2399: x_return_status);
2400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;
2405:
2406: gi_catv_rec := Migrate( p_catv_rec );

Line 2403: RAISE OKC_API.G_EXCEPTION_ERROR;

2399: x_return_status);
2400: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2401: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2402: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2403: RAISE OKC_API.G_EXCEPTION_ERROR;
2404: END IF;
2405:
2406: gi_catv_rec := Migrate( p_catv_rec );
2407:

Line 2410: p_init_msg_list => OKC_API.G_FALSE,

2406: gi_catv_rec := Migrate( p_catv_rec );
2407:
2408: OKC_K_ARTICLES_GRP.validate_row(
2409: p_api_version => p_api_version,
2410: p_init_msg_list => OKC_API.G_FALSE,
2411: x_return_status => x_return_status,
2412: x_msg_count => x_msg_count,
2413: x_msg_data => x_msg_data,
2414: p_id => gi_catv_rec.id,

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

2449: p_ref_article_id => gi_catv_rec.ref_article_id,
2450: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2451: p_object_version_number => gi_catv_rec.object_version_number
2452: );
2453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;

Line 2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2450: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2451: p_object_version_number => gi_catv_rec.object_version_number
2452: );
2453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2451: p_object_version_number => gi_catv_rec.object_version_number
2452: );
2453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2459: EXCEPTION

Line 2456: RAISE OKC_API.G_EXCEPTION_ERROR;

2452: );
2453: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2459: EXCEPTION
2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN

Line 2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

2454: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2455: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2459: EXCEPTION
2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2462: (substr(l_api_name,1,26),

Line 2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2456: RAISE OKC_API.G_EXCEPTION_ERROR;
2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2459: EXCEPTION
2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2462: (substr(l_api_name,1,26),
2463: G_PKG_NAME,
2464: 'OKC_API.G_RET_STS_ERROR',

Line 2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2457: END IF;
2458: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2459: EXCEPTION
2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2462: (substr(l_api_name,1,26),
2463: G_PKG_NAME,
2464: 'OKC_API.G_RET_STS_ERROR',
2465: x_msg_count,

Line 2464: 'OKC_API.G_RET_STS_ERROR',

2460: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2461: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2462: (substr(l_api_name,1,26),
2463: G_PKG_NAME,
2464: 'OKC_API.G_RET_STS_ERROR',
2465: x_msg_count,
2466: x_msg_data,
2467: G_SCOPE);
2468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2464: 'OKC_API.G_RET_STS_ERROR',
2465: x_msg_count,
2466: x_msg_data,
2467: G_SCOPE);
2468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2469: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2470: (substr(l_api_name,1,26),
2471: G_PKG_NAME,
2472: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2469: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2465: x_msg_count,
2466: x_msg_data,
2467: G_SCOPE);
2468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2469: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2470: (substr(l_api_name,1,26),
2471: G_PKG_NAME,
2472: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2473: x_msg_count,

Line 2472: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2468: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2469: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2470: (substr(l_api_name,1,26),
2471: G_PKG_NAME,
2472: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2473: x_msg_count,
2474: x_msg_data,
2475: G_SCOPE);
2476: WHEN OTHERS THEN

Line 2477: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2473: x_msg_count,
2474: x_msg_data,
2475: G_SCOPE);
2476: WHEN OTHERS THEN
2477: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2478: (substr(l_api_name,1,26),
2479: G_PKG_NAME,
2480: 'OTHERS',
2481: x_msg_count,

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

2498: x_msg_data OUT NOCOPY VARCHAR2,
2499: p_catv_tbl IN catv_tbl_type) is
2500: c NUMBER;
2501: i NUMBER;
2502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2503: BEGIN
2504: OKC_API.init_msg_list(p_init_msg_list);
2505: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2506: c:=p_catv_tbl.COUNT;

Line 2504: OKC_API.init_msg_list(p_init_msg_list);

2500: c NUMBER;
2501: i NUMBER;
2502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2503: BEGIN
2504: OKC_API.init_msg_list(p_init_msg_list);
2505: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2506: c:=p_catv_tbl.COUNT;
2507: if (c>0) then
2508: i := p_catv_tbl.FIRST;

Line 2505: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2501: i NUMBER;
2502: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2503: BEGIN
2504: OKC_API.init_msg_list(p_init_msg_list);
2505: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2506: c:=p_catv_tbl.COUNT;
2507: if (c>0) then
2508: i := p_catv_tbl.FIRST;
2509: LOOP

Line 2511: p_init_msg_list=>OKC_API.G_FALSE,

2507: if (c>0) then
2508: i := p_catv_tbl.FIRST;
2509: LOOP
2510: validate_k_article(p_api_version=>p_api_version,
2511: p_init_msg_list=>OKC_API.G_FALSE,
2512: x_return_status=>l_return_status,
2513: x_msg_count=>x_msg_count,
2514: x_msg_data=>x_msg_data,
2515: p_catv_rec=>p_catv_tbl(i));

Line 2516: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then

2512: x_return_status=>l_return_status,
2513: x_msg_count=>x_msg_count,
2514: x_msg_data=>x_msg_data,
2515: p_catv_rec=>p_catv_tbl(i));
2516: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2517: x_return_status := l_return_status;
2518: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2520: x_return_status := l_return_status;

Line 2518: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2514: x_msg_data=>x_msg_data,
2515: p_catv_rec=>p_catv_tbl(i));
2516: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2517: x_return_status := l_return_status;
2518: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2520: x_return_status := l_return_status;
2521: end if;
2522: c:=c-1;

Line 2519: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then

2515: p_catv_rec=>p_catv_tbl(i));
2516: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2517: x_return_status := l_return_status;
2518: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2519: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2520: x_return_status := l_return_status;
2521: end if;
2522: c:=c-1;
2523: EXIT WHEN (c=0);

Line 2545: OKC_API.init_msg_list(p_init_msg_list);

2541: x_msg_data OUT NOCOPY VARCHAR2,
2542: p_atnv_rec IN atnv_rec_type,
2543: x_atnv_rec OUT NOCOPY atnv_rec_type) is
2544: begin
2545: OKC_API.init_msg_list(p_init_msg_list);
2546: IF (l_debug = 'Y') THEN
2547: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2548: END IF;
2549: -- We won't create a record - keep g_atnv_rec empty

Line 2553: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2549: -- We won't create a record - keep g_atnv_rec empty
2550: -- g_atnv_rec := p_atnv_rec;
2551: -- x_atnv_rec := p_atnv_rec;
2552: x_msg_count := 0;
2553: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2554: end create_article_translation;
2555:
2556: -- Start of comments
2557: --

Line 2572: OKC_API.init_msg_list(p_init_msg_list);

2568: x_msg_data OUT NOCOPY VARCHAR2,
2569: p_atnv_tbl IN atnv_tbl_type,
2570: x_atnv_tbl OUT NOCOPY atnv_tbl_type) is
2571: begin
2572: OKC_API.init_msg_list(p_init_msg_list);
2573: IF (l_debug = 'Y') THEN
2574: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2575: END IF;
2576: -- We won't create a record - keep g_atnv_rec empty

Line 2580: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2576: -- We won't create a record - keep g_atnv_rec empty
2577: -- g_atnv_rec := p_atnv_rec;
2578: -- x_atnv_rec := p_atnv_rec;
2579: x_msg_count := 0;
2580: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2581: end create_article_translation;
2582:
2583: -- Start of comments
2584: --

Line 2598: OKC_API.init_msg_list(p_init_msg_list);

2594: x_msg_count OUT NOCOPY NUMBER,
2595: x_msg_data OUT NOCOPY VARCHAR2,
2596: p_atnv_rec IN atnv_rec_type) is
2597: begin
2598: OKC_API.init_msg_list(p_init_msg_list);
2599: IF (l_debug = 'Y') THEN
2600: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2601: END IF;
2602: x_msg_count := 0;

Line 2603: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2599: IF (l_debug = 'Y') THEN
2600: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2601: END IF;
2602: x_msg_count := 0;
2603: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2604: end lock_article_translation;
2605:
2606: -- Start of comments
2607: --

Line 2621: OKC_API.init_msg_list(p_init_msg_list);

2617: x_msg_count OUT NOCOPY NUMBER,
2618: x_msg_data OUT NOCOPY VARCHAR2,
2619: p_atnv_tbl IN atnv_tbl_type) is
2620: begin
2621: OKC_API.init_msg_list(p_init_msg_list);
2622: IF (l_debug = 'Y') THEN
2623: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2624: END IF;
2625: x_msg_count := 0;

Line 2626: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2622: IF (l_debug = 'Y') THEN
2623: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2624: END IF;
2625: x_msg_count := 0;
2626: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2627: end lock_article_translation;
2628:
2629: -- Start of comments
2630: --

Line 2644: OKC_API.init_msg_list(p_init_msg_list);

2640: x_msg_count OUT NOCOPY NUMBER,
2641: x_msg_data OUT NOCOPY VARCHAR2,
2642: p_atnv_rec IN atnv_rec_type) is
2643: begin
2644: OKC_API.init_msg_list(p_init_msg_list);
2645: IF (l_debug = 'Y') THEN
2646: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2647: END IF;
2648: x_msg_count := 0;

Line 2649: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2645: IF (l_debug = 'Y') THEN
2646: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2647: END IF;
2648: x_msg_count := 0;
2649: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2650: end delete_article_translation;
2651:
2652: -- Start of comments
2653: --

Line 2667: OKC_API.init_msg_list(p_init_msg_list);

2663: x_msg_count OUT NOCOPY NUMBER,
2664: x_msg_data OUT NOCOPY VARCHAR2,
2665: p_atnv_tbl IN atnv_tbl_type) is
2666: begin
2667: OKC_API.init_msg_list(p_init_msg_list);
2668: IF (l_debug = 'Y') THEN
2669: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2670: END IF;
2671: x_msg_count := 0;

Line 2672: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2668: IF (l_debug = 'Y') THEN
2669: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2670: END IF;
2671: x_msg_count := 0;
2672: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2673: end delete_article_translation;
2674:
2675: -- Start of comments
2676: --

Line 2690: OKC_API.init_msg_list(p_init_msg_list);

2686: x_msg_count OUT NOCOPY NUMBER,
2687: x_msg_data OUT NOCOPY VARCHAR2,
2688: p_atnv_rec IN atnv_rec_type) is
2689: begin
2690: OKC_API.init_msg_list(p_init_msg_list);
2691: IF (l_debug = 'Y') THEN
2692: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2693: END IF;
2694: x_msg_count := 0;

Line 2695: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2691: IF (l_debug = 'Y') THEN
2692: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2693: END IF;
2694: x_msg_count := 0;
2695: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2696: end validate_article_translation;
2697:
2698: -- Start of comments
2699: --

Line 2713: OKC_API.init_msg_list(p_init_msg_list);

2709: x_msg_count OUT NOCOPY NUMBER,
2710: x_msg_data OUT NOCOPY VARCHAR2,
2711: p_atnv_tbl IN atnv_tbl_type) is
2712: begin
2713: OKC_API.init_msg_list(p_init_msg_list);
2714: IF (l_debug = 'Y') THEN
2715: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2716: END IF;
2717: x_msg_count := 0;

Line 2718: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2714: IF (l_debug = 'Y') THEN
2715: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2716: END IF;
2717: x_msg_count := 0;
2718: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2719: end validate_article_translation;
2720:
2721: -- Start of comments
2722: --