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.0 2005/05/25 19:11:14 appldev noship $ */
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 750: OKC_API.SET_MESSAGE('OKC', 'OKC_NOTDEFINED_11510_UPG_TMPL','DOC_TYPE', p_doc_type);

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

Line 814: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

Line 1047: x_return_status := OKC_API.G_RET_STS_SUCCESS;

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

Line 1264: x_return_status := OKC_API.G_RET_STS_SUCCESS;

1260: WHERE DOCUMENT_TYPE= p_doc_type
1261: AND DOCUMENT_ID = p_doc_id
1262: AND SCN_ID = p_scn_id;
1263: BEGIN
1264: x_return_status := OKC_API.G_RET_STS_SUCCESS;
1265:
1266: IF (l_debug = 'Y') THEN
1267: okc_debug.Set_Indentation(G_PKG_NAME);
1268: okc_debug.log('11300: Entered Default_Record', 2);

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

1280: p_chr_id => gi_catv_rec.dnz_chr_id,
1281: x_doc_id => gi_catv_rec.document_id,
1282: x_doc_type => gi_catv_rec.document_type
1283: );
1284: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1285: IF (l_debug = 'Y') THEN
1286: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Contract_Document_Type', 2);
1287: okc_debug.Reset_Indentation;
1288: END IF;

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

1308: x_msg_count => x_msg_count,
1309: p_doc_id => gi_catv_rec.document_id,
1310: p_doc_type => gi_catv_rec.document_type
1311: );
1312: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1313: IF (l_debug = 'Y') THEN
1314: okc_debug.log('11400: Leaving Default_Record because of an exception in Get_Unassign_Section_ID', 2);
1315: okc_debug.Reset_Indentation;
1316: END IF;

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

1343: x_art_ver_id => gi_catv_rec.article_version_id,
1344: x_std_art_id => gi_catv_rec.ref_article_id,
1345: x_std_art_ver_id => gi_catv_rec.ref_article_version_id
1346: );
1347: IF (x_return_status <> OKC_API.G_RET_STS_SUCCESS) then
1348: IF (l_debug = 'Y') THEN
1349: okc_debug.log('11400: Leaving Default_Record because of an exception in Process_Non_Std_Article', 2);
1350: okc_debug.Reset_Indentation;
1351: END IF;

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

1387: x_msg_data OUT NOCOPY VARCHAR2,
1388: p_catv_rec IN catv_rec_type,
1389: x_catv_rec OUT NOCOPY catv_rec_type) is
1390: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_ARTICLE';
1391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1392: -- l_clob clob;
1393: BEGIN
1394: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1395: G_PKG_NAME,

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

1390: l_api_name CONSTANT VARCHAR2(30) := 'CREATE_K_ARTICLE';
1391: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1392: -- l_clob clob;
1393: BEGIN
1394: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1395: G_PKG_NAME,
1396: p_init_msg_list,
1397: G_API_VERSION,
1398: p_api_version,

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

1397: G_API_VERSION,
1398: p_api_version,
1399: G_SCOPE,
1400: x_return_status);
1401: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;

Line 1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1398: p_api_version,
1399: G_SCOPE,
1400: x_return_status);
1401: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --

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

1399: G_SCOPE,
1400: x_return_status);
1401: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --
1407: -- code for temporary clob ... start

Line 1404: RAISE OKC_API.G_EXCEPTION_ERROR;

1400: x_return_status);
1401: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1402: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1403: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1404: RAISE OKC_API.G_EXCEPTION_ERROR;
1405: END IF;
1406: --
1407: -- code for temporary clob ... start
1408: --

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

1438: x_return_status => l_return_status,
1439: x_msg_count => x_msg_count,
1440: x_msg_data => x_msg_data
1441: );
1442: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1445: RAISE OKC_API.G_EXCEPTION_ERROR;
1446: END IF;

Line 1443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1439: x_msg_count => x_msg_count,
1440: x_msg_data => x_msg_data
1441: );
1442: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1445: RAISE OKC_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:

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

1440: x_msg_data => x_msg_data
1441: );
1442: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1445: RAISE OKC_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:
1448: Default_Record(

Line 1445: RAISE OKC_API.G_EXCEPTION_ERROR;

1441: );
1442: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1443: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1444: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1445: RAISE OKC_API.G_EXCEPTION_ERROR;
1446: END IF;
1447:
1448: Default_Record(
1449: p_api_version => p_api_version,

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

1450: x_return_status => l_return_status,
1451: x_msg_count => x_msg_count,
1452: x_msg_data => x_msg_data
1453: );
1454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;

Line 1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1451: x_msg_count => x_msg_count,
1452: x_msg_data => x_msg_data
1453: );
1454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:

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

1452: x_msg_data => x_msg_data
1453: );
1454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:
1460: IF (l_debug = 'Y') THEN

Line 1457: RAISE OKC_API.G_EXCEPTION_ERROR;

1453: );
1454: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1456: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1457: RAISE OKC_API.G_EXCEPTION_ERROR;
1458: END IF;
1459:
1460: IF (l_debug = 'Y') THEN
1461: Dump_Rec( gi_catv_rec );

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

1507: p_ref_article_id => gi_catv_rec.ref_article_id,
1508: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
1509: x_id => gi_catv_rec.id
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;

Line 1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1508: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
1509: x_id => gi_catv_rec.id
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516:

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

1509: x_id => gi_catv_rec.id
1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516:
1517: -- Set OUT values

Line 1514: RAISE OKC_API.G_EXCEPTION_ERROR;

1510: );
1511: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1512: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1513: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1514: RAISE OKC_API.G_EXCEPTION_ERROR;
1515: END IF;
1516:
1517: -- Set OUT values
1518: x_catv_rec := get_rec( gi_catv_rec.id );

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

1522: okc_debug.log('1000: Leaving '||l_api_name, 2);
1523: Dump_Rec( x_catv_rec );
1524: END IF;
1525:
1526: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1527: EXCEPTION
1528: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1529: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1530: (substr(l_api_name,1,26),

Line 1528: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1524: END IF;
1525:
1526: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1527: EXCEPTION
1528: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1529: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1530: (substr(l_api_name,1,26),
1531: G_PKG_NAME,
1532: 'OKC_API.G_RET_STS_ERROR',

Line 1529: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1525:
1526: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1527: EXCEPTION
1528: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1529: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1530: (substr(l_api_name,1,26),
1531: G_PKG_NAME,
1532: 'OKC_API.G_RET_STS_ERROR',
1533: x_msg_count,

Line 1532: 'OKC_API.G_RET_STS_ERROR',

1528: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1529: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1530: (substr(l_api_name,1,26),
1531: G_PKG_NAME,
1532: 'OKC_API.G_RET_STS_ERROR',
1533: x_msg_count,
1534: x_msg_data,
1535: G_SCOPE);
1536: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1536: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1532: 'OKC_API.G_RET_STS_ERROR',
1533: x_msg_count,
1534: x_msg_data,
1535: G_SCOPE);
1536: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',

Line 1537: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1533: x_msg_count,
1534: x_msg_data,
1535: G_SCOPE);
1536: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',
1541: x_msg_count,

Line 1540: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1536: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',
1541: x_msg_count,
1542: x_msg_data,
1543: G_SCOPE);
1544: WHEN OTHERS THEN

Line 1545: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

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

1567: p_catv_tbl IN catv_tbl_type,
1568: x_catv_tbl OUT NOCOPY catv_tbl_type) is
1569: c NUMBER;
1570: i NUMBER;
1571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1572: BEGIN
1573: OKC_API.init_msg_list(p_init_msg_list);
1574: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1575: c:=p_catv_tbl.COUNT;

Line 1573: OKC_API.init_msg_list(p_init_msg_list);

1569: c NUMBER;
1570: i NUMBER;
1571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1572: BEGIN
1573: OKC_API.init_msg_list(p_init_msg_list);
1574: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1575: c:=p_catv_tbl.COUNT;
1576: if (c>0) then
1577: i := p_catv_tbl.FIRST;

Line 1574: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1570: i NUMBER;
1571: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1572: BEGIN
1573: OKC_API.init_msg_list(p_init_msg_list);
1574: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1575: c:=p_catv_tbl.COUNT;
1576: if (c>0) then
1577: i := p_catv_tbl.FIRST;
1578: LOOP

Line 1582: p_init_msg_list => OKC_API.G_FALSE,

1578: LOOP
1579: create_k_article
1580: (
1581: p_api_version => p_api_version,
1582: p_init_msg_list => OKC_API.G_FALSE,
1583: x_return_status => l_return_status,
1584: x_msg_count => x_msg_count,
1585: x_msg_data => x_msg_data,
1586: p_catv_rec => p_catv_tbl(i),

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

1585: x_msg_data => x_msg_data,
1586: p_catv_rec => p_catv_tbl(i),
1587: x_catv_rec => x_catv_tbl(i)
1588: );
1589: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1590: x_return_status := l_return_status;
1591: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1593: x_return_status := l_return_status;

Line 1591: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1587: x_catv_rec => x_catv_tbl(i)
1588: );
1589: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1590: x_return_status := l_return_status;
1591: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1593: x_return_status := l_return_status;
1594: end if;
1595: c:=c-1;

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

1588: );
1589: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1590: x_return_status := l_return_status;
1591: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1592: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1593: x_return_status := l_return_status;
1594: end if;
1595: c:=c-1;
1596: EXIT WHEN (c=0);

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

1615: x_msg_count OUT NOCOPY NUMBER,
1616: x_msg_data OUT NOCOPY VARCHAR2,
1617: p_catv_rec IN catv_rec_type) is
1618: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_K_ARTICLE';
1619: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1620: BEGIN
1621: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1622: G_PKG_NAME,
1623: p_init_msg_list,

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

1617: p_catv_rec IN catv_rec_type) is
1618: l_api_name CONSTANT VARCHAR2(30) := 'LOCK_K_ARTICLE';
1619: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1620: BEGIN
1621: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
1622: G_PKG_NAME,
1623: p_init_msg_list,
1624: G_API_VERSION,
1625: p_api_version,

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

1624: G_API_VERSION,
1625: p_api_version,
1626: G_SCOPE,
1627: x_return_status);
1628: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_ERROR;
1632: END IF;

Line 1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1625: p_api_version,
1626: G_SCOPE,
1627: x_return_status);
1628: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_ERROR;
1632: END IF;
1633:

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

1626: G_SCOPE,
1627: x_return_status);
1628: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_ERROR;
1632: END IF;
1633:
1634: OKC_K_ARTICLES_GRP.lock_row(

Line 1631: RAISE OKC_API.G_EXCEPTION_ERROR;

1627: x_return_status);
1628: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1629: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1630: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1631: RAISE OKC_API.G_EXCEPTION_ERROR;
1632: END IF;
1633:
1634: OKC_K_ARTICLES_GRP.lock_row(
1635: p_api_version => p_api_version,

Line 1636: p_init_msg_list => OKC_API.G_FALSE,

1632: END IF;
1633:
1634: OKC_K_ARTICLES_GRP.lock_row(
1635: p_api_version => p_api_version,
1636: p_init_msg_list => OKC_API.G_FALSE,
1637: x_return_status => x_return_status,
1638: x_msg_count => x_msg_count,
1639: x_msg_data => x_msg_data,
1640: p_id => p_catv_rec.id,

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

1639: x_msg_data => x_msg_data,
1640: p_id => p_catv_rec.id,
1641: p_object_version_number => p_catv_rec.object_version_number
1642: );
1643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;

Line 1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1640: p_id => p_catv_rec.id,
1641: p_object_version_number => p_catv_rec.object_version_number
1642: );
1643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

1641: p_object_version_number => p_catv_rec.object_version_number
1642: );
1643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1649: EXCEPTION

Line 1646: RAISE OKC_API.G_EXCEPTION_ERROR;

1642: );
1643: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1649: EXCEPTION
1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

1644: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1645: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1649: EXCEPTION
1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1651: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1652: (substr(l_api_name,1,26),

Line 1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1646: RAISE OKC_API.G_EXCEPTION_ERROR;
1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1649: EXCEPTION
1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1651: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1652: (substr(l_api_name,1,26),
1653: G_PKG_NAME,
1654: 'OKC_API.G_RET_STS_ERROR',

Line 1651: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1647: END IF;
1648: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1649: EXCEPTION
1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1651: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1652: (substr(l_api_name,1,26),
1653: G_PKG_NAME,
1654: 'OKC_API.G_RET_STS_ERROR',
1655: x_msg_count,

Line 1654: 'OKC_API.G_RET_STS_ERROR',

1650: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1651: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1652: (substr(l_api_name,1,26),
1653: G_PKG_NAME,
1654: 'OKC_API.G_RET_STS_ERROR',
1655: x_msg_count,
1656: x_msg_data,
1657: G_SCOPE);
1658: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 1658: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1654: 'OKC_API.G_RET_STS_ERROR',
1655: x_msg_count,
1656: x_msg_data,
1657: G_SCOPE);
1658: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',

Line 1659: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1655: x_msg_count,
1656: x_msg_data,
1657: G_SCOPE);
1658: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',
1663: x_msg_count,

Line 1662: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1658: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_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_UNEXP_ERROR',
1663: x_msg_count,
1664: x_msg_data,
1665: G_SCOPE);
1666: WHEN OTHERS THEN

Line 1667: x_return_status := OKC_API.HANDLE_EXCEPTIONS

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

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

1687: x_msg_count OUT NOCOPY NUMBER,
1688: x_msg_data OUT NOCOPY VARCHAR2,
1689: p_catv_tbl IN catv_tbl_type) is
1690: i NUMBER;
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1692: begin
1693: OKC_API.init_msg_list(p_init_msg_list);
1694: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1695: if (p_catv_tbl.COUNT>0) then

Line 1693: OKC_API.init_msg_list(p_init_msg_list);

1689: p_catv_tbl IN catv_tbl_type) is
1690: i NUMBER;
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1692: begin
1693: OKC_API.init_msg_list(p_init_msg_list);
1694: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1695: if (p_catv_tbl.COUNT>0) then
1696: i := p_catv_tbl.FIRST;
1697: LOOP

Line 1694: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

1690: i NUMBER;
1691: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1692: begin
1693: OKC_API.init_msg_list(p_init_msg_list);
1694: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
1695: if (p_catv_tbl.COUNT>0) then
1696: i := p_catv_tbl.FIRST;
1697: LOOP
1698: lock_k_article(p_api_version=>p_api_version,

Line 1699: p_init_msg_list=>OKC_API.G_FALSE,

1695: if (p_catv_tbl.COUNT>0) then
1696: i := p_catv_tbl.FIRST;
1697: LOOP
1698: lock_k_article(p_api_version=>p_api_version,
1699: p_init_msg_list=>OKC_API.G_FALSE,
1700: x_return_status=>l_return_status,
1701: x_msg_count=>x_msg_count,
1702: x_msg_data=>x_msg_data,
1703: p_catv_rec=>p_catv_tbl(i));

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

1700: x_return_status=>l_return_status,
1701: x_msg_count=>x_msg_count,
1702: x_msg_data=>x_msg_data,
1703: p_catv_rec=>p_catv_tbl(i));
1704: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1705: x_return_status := l_return_status;
1706: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1707: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1708: x_return_status := l_return_status;

Line 1706: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1702: x_msg_data=>x_msg_data,
1703: p_catv_rec=>p_catv_tbl(i));
1704: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1705: x_return_status := l_return_status;
1706: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1707: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1708: x_return_status := l_return_status;
1709: end if;
1710: EXIT WHEN (i=p_catv_tbl.LAST);

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

1703: p_catv_rec=>p_catv_tbl(i));
1704: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
1705: x_return_status := l_return_status;
1706: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1707: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
1708: x_return_status := l_return_status;
1709: end if;
1710: EXIT WHEN (i=p_catv_tbl.LAST);
1711: i := p_catv_tbl.NEXT(i);

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

2040: x_msg_data OUT NOCOPY VARCHAR2,
2041: p_catv_rec IN catv_rec_type,
2042: x_catv_rec OUT NOCOPY catv_rec_type) is
2043: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
2044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2045: l_catv_rec catv_rec_type;
2046: begin
2047: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2048: G_PKG_NAME,

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

2043: l_api_name CONSTANT VARCHAR2(30) := 'UPDATE_K_ARTICLE';
2044: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2045: l_catv_rec catv_rec_type;
2046: begin
2047: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2048: G_PKG_NAME,
2049: p_init_msg_list,
2050: G_API_VERSION,
2051: p_api_version,

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

2050: G_API_VERSION,
2051: p_api_version,
2052: G_SCOPE,
2053: x_return_status);
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;

Line 2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2051: p_api_version,
2052: G_SCOPE,
2053: x_return_status);
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --

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

2052: G_SCOPE,
2053: x_return_status);
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --
2060: -- code for temporary clob ... start

Line 2057: RAISE OKC_API.G_EXCEPTION_ERROR;

2053: x_return_status);
2054: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2055: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2056: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2057: RAISE OKC_API.G_EXCEPTION_ERROR;
2058: END IF;
2059: --
2060: -- code for temporary clob ... start
2061: --

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

2088: x_return_status => l_return_status,
2089: x_msg_count => x_msg_count,
2090: x_msg_data => x_msg_data
2091: );
2092: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2095: RAISE OKC_API.G_EXCEPTION_ERROR;
2096: END IF;

Line 2093: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2089: x_msg_count => x_msg_count,
2090: x_msg_data => x_msg_data
2091: );
2092: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2095: RAISE OKC_API.G_EXCEPTION_ERROR;
2096: END IF;
2097:

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

2090: x_msg_data => x_msg_data
2091: );
2092: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2095: RAISE OKC_API.G_EXCEPTION_ERROR;
2096: END IF;
2097:
2098: Flip_GMISS_Record;

Line 2095: RAISE OKC_API.G_EXCEPTION_ERROR;

2091: );
2092: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2093: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2094: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2095: RAISE OKC_API.G_EXCEPTION_ERROR;
2096: END IF;
2097:
2098: Flip_GMISS_Record;
2099:

Line 2107: p_init_msg_list => OKC_API.G_FALSE,

2103: END IF;
2104:
2105: OKC_K_ARTICLES_GRP.update_article(
2106: p_api_version => p_api_version,
2107: p_init_msg_list => OKC_API.G_FALSE,
2108: x_return_status => x_return_status,
2109: x_msg_count => x_msg_count,
2110: x_msg_data => x_msg_data,
2111: p_id => gi_catv_rec.id,

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

2143: p_ref_article_id => gi_catv_rec.ref_article_id,
2144: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2145: p_object_version_number => gi_catv_rec.object_version_number
2146: );
2147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2150: RAISE OKC_API.G_EXCEPTION_ERROR;
2151: END IF;

Line 2148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2144: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2145: p_object_version_number => gi_catv_rec.object_version_number
2146: );
2147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2150: RAISE OKC_API.G_EXCEPTION_ERROR;
2151: END IF;
2152:

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

2145: p_object_version_number => gi_catv_rec.object_version_number
2146: );
2147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2150: RAISE OKC_API.G_EXCEPTION_ERROR;
2151: END IF;
2152:
2153: -- Set OUT values

Line 2150: RAISE OKC_API.G_EXCEPTION_ERROR;

2146: );
2147: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2148: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2149: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2150: RAISE OKC_API.G_EXCEPTION_ERROR;
2151: END IF;
2152:
2153: -- Set OUT values
2154: x_catv_rec := get_rec( gi_catv_rec.id );

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

2158: okc_debug.log('1000: Leaving '||l_api_name, 2);
2159: Dump_Rec( x_catv_rec );
2160: END IF;
2161:
2162: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2163: EXCEPTION
2164: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);

Line 2164: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2160: END IF;
2161:
2162: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2163: EXCEPTION
2164: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2167: END IF;
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2164: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2165: IF (l_debug = 'Y') THEN
2166: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_ERROR ', 2);
2167: END IF;
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (substr(l_api_name,1,26),
2170: G_PKG_NAME,
2171: 'OKC_API.G_RET_STS_ERROR',
2172: x_msg_count,

Line 2171: 'OKC_API.G_RET_STS_ERROR',

2167: END IF;
2168: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2169: (substr(l_api_name,1,26),
2170: G_PKG_NAME,
2171: 'OKC_API.G_RET_STS_ERROR',
2172: x_msg_count,
2173: x_msg_data,
2174: G_SCOPE);
2175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2171: 'OKC_API.G_RET_STS_ERROR',
2172: x_msg_count,
2173: x_msg_data,
2174: G_SCOPE);
2175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2176: IF (l_debug = 'Y') THEN
2177: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2178: END IF;
2179: x_return_status := OKC_API.HANDLE_EXCEPTIONS

Line 2179: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2175: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2176: IF (l_debug = 'Y') THEN
2177: okc_debug.log('1000: Leaving '||l_api_name||' because of G_EXCEPTION_UNEXPECTED_ERROR ', 2);
2178: END IF;
2179: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2180: (substr(l_api_name,1,26),
2181: G_PKG_NAME,
2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2183: x_msg_count,

Line 2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2178: END IF;
2179: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2180: (substr(l_api_name,1,26),
2181: G_PKG_NAME,
2182: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2183: x_msg_count,
2184: x_msg_data,
2185: G_SCOPE);
2186: WHEN OTHERS THEN

Line 2190: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2186: WHEN OTHERS THEN
2187: IF (l_debug = 'Y') THEN
2188: okc_debug.log('500: Leaving '||l_api_name||' because of EXCEPTION: '||sqlerrm, 2);
2189: END IF;
2190: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2191: (substr(l_api_name,1,26),
2192: G_PKG_NAME,
2193: 'OTHERS',
2194: x_msg_count,

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

2212: x_msg_data OUT NOCOPY VARCHAR2,
2213: p_catv_tbl IN catv_tbl_type,
2214: x_catv_tbl OUT NOCOPY catv_tbl_type) is
2215: i NUMBER;
2216: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2217: begin
2218: OKC_API.init_msg_list(p_init_msg_list);
2219: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2220: if (p_catv_tbl.COUNT>0) then

Line 2218: OKC_API.init_msg_list(p_init_msg_list);

2214: x_catv_tbl OUT NOCOPY catv_tbl_type) is
2215: i NUMBER;
2216: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2217: begin
2218: OKC_API.init_msg_list(p_init_msg_list);
2219: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2220: if (p_catv_tbl.COUNT>0) then
2221: i := p_catv_tbl.FIRST;
2222: LOOP

Line 2219: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2215: i NUMBER;
2216: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2217: begin
2218: OKC_API.init_msg_list(p_init_msg_list);
2219: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2220: if (p_catv_tbl.COUNT>0) then
2221: i := p_catv_tbl.FIRST;
2222: LOOP
2223:

Line 2225: p_init_msg_list=>OKC_API.G_FALSE,

2221: i := p_catv_tbl.FIRST;
2222: LOOP
2223:
2224: update_k_article(p_api_version=>p_api_version,
2225: p_init_msg_list=>OKC_API.G_FALSE,
2226: x_return_status=>l_return_status,
2227: x_msg_count=>x_msg_count,
2228: x_msg_data=>x_msg_data,
2229: p_catv_rec=> p_catv_tbl(i),

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

2227: x_msg_count=>x_msg_count,
2228: x_msg_data=>x_msg_data,
2229: p_catv_rec=> p_catv_tbl(i),
2230: x_catv_rec=>x_catv_tbl(i));
2231: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2232: x_return_status := l_return_status;
2233: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2234: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2235: x_return_status := l_return_status;

Line 2233: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2229: p_catv_rec=> p_catv_tbl(i),
2230: x_catv_rec=>x_catv_tbl(i));
2231: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2232: x_return_status := l_return_status;
2233: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2234: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2235: x_return_status := l_return_status;
2236: end if;
2237: EXIT WHEN (i=p_catv_tbl.LAST);

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

2230: x_catv_rec=>x_catv_tbl(i));
2231: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2232: x_return_status := l_return_status;
2233: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2234: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2235: x_return_status := l_return_status;
2236: end if;
2237: EXIT WHEN (i=p_catv_tbl.LAST);
2238: i := p_catv_tbl.NEXT(i);

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

2256: x_msg_count OUT NOCOPY NUMBER,
2257: x_msg_data OUT NOCOPY VARCHAR2,
2258: p_catv_rec IN catv_rec_type) is
2259: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
2260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2261: begin
2262: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2263: G_PKG_NAME,
2264: p_init_msg_list,

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

2258: p_catv_rec IN catv_rec_type) is
2259: l_api_name CONSTANT VARCHAR2(30) := 'DELETE_K_ARTICLE';
2260: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2261: begin
2262: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2263: G_PKG_NAME,
2264: p_init_msg_list,
2265: G_API_VERSION,
2266: p_api_version,

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

2265: G_API_VERSION,
2266: p_api_version,
2267: G_SCOPE,
2268: x_return_status);
2269: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;

Line 2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2266: p_api_version,
2267: G_SCOPE,
2268: x_return_status);
2269: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;
2274: OKC_K_ARTICLES_GRP.delete_article(

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

2267: G_SCOPE,
2268: x_return_status);
2269: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;
2274: OKC_K_ARTICLES_GRP.delete_article(
2275: p_api_version => p_api_version,

Line 2272: RAISE OKC_API.G_EXCEPTION_ERROR;

2268: x_return_status);
2269: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2270: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2271: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;
2274: OKC_K_ARTICLES_GRP.delete_article(
2275: p_api_version => p_api_version,
2276: p_init_msg_list => OKC_API.G_FALSE,

Line 2276: p_init_msg_list => OKC_API.G_FALSE,

2272: RAISE OKC_API.G_EXCEPTION_ERROR;
2273: END IF;
2274: OKC_K_ARTICLES_GRP.delete_article(
2275: p_api_version => p_api_version,
2276: p_init_msg_list => OKC_API.G_FALSE,
2277: x_return_status => x_return_status,
2278: x_msg_count => x_msg_count,
2279: x_msg_data => x_msg_data,
2280: p_validation_string => NULL,

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

2280: p_validation_string => NULL,
2281: p_id => p_catv_rec.id,
2282: p_object_version_number => p_catv_rec.object_version_number
2283: );
2284: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;

Line 2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2281: p_id => p_catv_rec.id,
2282: p_object_version_number => p_catv_rec.object_version_number
2283: );
2284: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2282: p_object_version_number => p_catv_rec.object_version_number
2283: );
2284: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION

Line 2287: RAISE OKC_API.G_EXCEPTION_ERROR;

2283: );
2284: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION
2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2285: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2286: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION
2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2293: (substr(l_api_name,1,26),

Line 2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2287: RAISE OKC_API.G_EXCEPTION_ERROR;
2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION
2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2293: (substr(l_api_name,1,26),
2294: G_PKG_NAME,
2295: 'OKC_API.G_RET_STS_ERROR',

Line 2292: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2288: END IF;
2289: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2290: EXCEPTION
2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2293: (substr(l_api_name,1,26),
2294: G_PKG_NAME,
2295: 'OKC_API.G_RET_STS_ERROR',
2296: x_msg_count,

Line 2295: 'OKC_API.G_RET_STS_ERROR',

2291: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2292: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2293: (substr(l_api_name,1,26),
2294: G_PKG_NAME,
2295: 'OKC_API.G_RET_STS_ERROR',
2296: x_msg_count,
2297: x_msg_data,
2298: G_SCOPE);
2299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2295: 'OKC_API.G_RET_STS_ERROR',
2296: x_msg_count,
2297: x_msg_data,
2298: G_SCOPE);
2299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2301: (substr(l_api_name,1,26),
2302: G_PKG_NAME,
2303: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2300: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2296: x_msg_count,
2297: x_msg_data,
2298: G_SCOPE);
2299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2301: (substr(l_api_name,1,26),
2302: G_PKG_NAME,
2303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2304: x_msg_count,

Line 2303: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2299: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2300: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2301: (substr(l_api_name,1,26),
2302: G_PKG_NAME,
2303: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2304: x_msg_count,
2305: x_msg_data,
2306: G_SCOPE);
2307: WHEN OTHERS THEN

Line 2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2304: x_msg_count,
2305: x_msg_data,
2306: G_SCOPE);
2307: WHEN OTHERS THEN
2308: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2309: (substr(l_api_name,1,26),
2310: G_PKG_NAME,
2311: 'OTHERS',
2312: x_msg_count,

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

2329: x_msg_count OUT NOCOPY NUMBER,
2330: x_msg_data OUT NOCOPY VARCHAR2,
2331: p_catv_tbl IN catv_tbl_type) is
2332: i NUMBER;
2333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2334: begin
2335: OKC_API.init_msg_list(p_init_msg_list);
2336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2337: if (p_catv_tbl.COUNT>0) then

Line 2335: OKC_API.init_msg_list(p_init_msg_list);

2331: p_catv_tbl IN catv_tbl_type) is
2332: i NUMBER;
2333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2334: begin
2335: OKC_API.init_msg_list(p_init_msg_list);
2336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2337: if (p_catv_tbl.COUNT>0) then
2338: i := p_catv_tbl.FIRST;
2339: LOOP

Line 2336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2332: i NUMBER;
2333: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2334: begin
2335: OKC_API.init_msg_list(p_init_msg_list);
2336: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2337: if (p_catv_tbl.COUNT>0) then
2338: i := p_catv_tbl.FIRST;
2339: LOOP
2340: delete_k_article(p_api_version=>p_api_version,

Line 2341: p_init_msg_list=>OKC_API.G_FALSE,

2337: if (p_catv_tbl.COUNT>0) then
2338: i := p_catv_tbl.FIRST;
2339: LOOP
2340: delete_k_article(p_api_version=>p_api_version,
2341: p_init_msg_list=>OKC_API.G_FALSE,
2342: x_return_status=>l_return_status,
2343: x_msg_count=>x_msg_count,
2344: x_msg_data=>x_msg_data,
2345: p_catv_rec=>p_catv_tbl(i));

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

2342: x_return_status=>l_return_status,
2343: x_msg_count=>x_msg_count,
2344: x_msg_data=>x_msg_data,
2345: p_catv_rec=>p_catv_tbl(i));
2346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2347: x_return_status := l_return_status;
2348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2350: x_return_status := l_return_status;

Line 2348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2344: x_msg_data=>x_msg_data,
2345: p_catv_rec=>p_catv_tbl(i));
2346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2347: x_return_status := l_return_status;
2348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2350: x_return_status := l_return_status;
2351: end if;
2352: EXIT WHEN (i=p_catv_tbl.LAST);

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

2345: p_catv_rec=>p_catv_tbl(i));
2346: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2347: x_return_status := l_return_status;
2348: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2349: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2350: x_return_status := l_return_status;
2351: end if;
2352: EXIT WHEN (i=p_catv_tbl.LAST);
2353: i := p_catv_tbl.NEXT(i);

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

2371: x_msg_count OUT NOCOPY NUMBER,
2372: x_msg_data OUT NOCOPY VARCHAR2,
2373: p_catv_rec IN catv_rec_type) is
2374: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_K_ARTICLE';
2375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2376: begin
2377: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2378: G_PKG_NAME,
2379: p_init_msg_list,

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

2373: p_catv_rec IN catv_rec_type) is
2374: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_K_ARTICLE';
2375: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2376: begin
2377: l_return_status := OKC_API.START_ACTIVITY(substr(l_api_name,1,26),
2378: G_PKG_NAME,
2379: p_init_msg_list,
2380: G_API_VERSION,
2381: p_api_version,

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

2380: G_API_VERSION,
2381: p_api_version,
2382: G_SCOPE,
2383: x_return_status);
2384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2387: RAISE OKC_API.G_EXCEPTION_ERROR;
2388: END IF;

Line 2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2381: p_api_version,
2382: G_SCOPE,
2383: x_return_status);
2384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2387: RAISE OKC_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:

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

2382: G_SCOPE,
2383: x_return_status);
2384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2387: RAISE OKC_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:
2390: gi_catv_rec := Migrate( p_catv_rec );

Line 2387: RAISE OKC_API.G_EXCEPTION_ERROR;

2383: x_return_status);
2384: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2385: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2386: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
2387: RAISE OKC_API.G_EXCEPTION_ERROR;
2388: END IF;
2389:
2390: gi_catv_rec := Migrate( p_catv_rec );
2391:

Line 2394: p_init_msg_list => OKC_API.G_FALSE,

2390: gi_catv_rec := Migrate( p_catv_rec );
2391:
2392: OKC_K_ARTICLES_GRP.validate_row(
2393: p_api_version => p_api_version,
2394: p_init_msg_list => OKC_API.G_FALSE,
2395: x_return_status => x_return_status,
2396: x_msg_count => x_msg_count,
2397: x_msg_data => x_msg_data,
2398: p_id => gi_catv_rec.id,

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

2432: p_ref_article_id => gi_catv_rec.ref_article_id,
2433: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2434: p_object_version_number => gi_catv_rec.object_version_number
2435: );
2436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;

Line 2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2433: p_ref_article_version_id => gi_catv_rec.ref_article_version_id,
2434: p_object_version_number => gi_catv_rec.object_version_number
2435: );
2436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

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

2434: p_object_version_number => gi_catv_rec.object_version_number
2435: );
2436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION

Line 2439: RAISE OKC_API.G_EXCEPTION_ERROR;

2435: );
2436: IF (x_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN

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

2437: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2438: ELSIF (x_return_status = OKC_API.G_RET_STS_ERROR) THEN
2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (substr(l_api_name,1,26),

Line 2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN

2439: RAISE OKC_API.G_EXCEPTION_ERROR;
2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (substr(l_api_name,1,26),
2446: G_PKG_NAME,
2447: 'OKC_API.G_RET_STS_ERROR',

Line 2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2440: END IF;
2441: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
2442: EXCEPTION
2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (substr(l_api_name,1,26),
2446: G_PKG_NAME,
2447: 'OKC_API.G_RET_STS_ERROR',
2448: x_msg_count,

Line 2447: 'OKC_API.G_RET_STS_ERROR',

2443: WHEN OKC_API.G_EXCEPTION_ERROR THEN
2444: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2445: (substr(l_api_name,1,26),
2446: G_PKG_NAME,
2447: 'OKC_API.G_RET_STS_ERROR',
2448: x_msg_count,
2449: x_msg_data,
2450: G_SCOPE);
2451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

Line 2451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

2447: 'OKC_API.G_RET_STS_ERROR',
2448: x_msg_count,
2449: x_msg_data,
2450: G_SCOPE);
2451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2452: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2453: (substr(l_api_name,1,26),
2454: G_PKG_NAME,
2455: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 2452: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2448: x_msg_count,
2449: x_msg_data,
2450: G_SCOPE);
2451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2452: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2453: (substr(l_api_name,1,26),
2454: G_PKG_NAME,
2455: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2456: x_msg_count,

Line 2455: 'OKC_API.G_RET_STS_UNEXP_ERROR',

2451: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
2452: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2453: (substr(l_api_name,1,26),
2454: G_PKG_NAME,
2455: 'OKC_API.G_RET_STS_UNEXP_ERROR',
2456: x_msg_count,
2457: x_msg_data,
2458: G_SCOPE);
2459: WHEN OTHERS THEN

Line 2460: x_return_status := OKC_API.HANDLE_EXCEPTIONS

2456: x_msg_count,
2457: x_msg_data,
2458: G_SCOPE);
2459: WHEN OTHERS THEN
2460: x_return_status := OKC_API.HANDLE_EXCEPTIONS
2461: (substr(l_api_name,1,26),
2462: G_PKG_NAME,
2463: 'OTHERS',
2464: x_msg_count,

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

2481: x_msg_data OUT NOCOPY VARCHAR2,
2482: p_catv_tbl IN catv_tbl_type) is
2483: c NUMBER;
2484: i NUMBER;
2485: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2486: BEGIN
2487: OKC_API.init_msg_list(p_init_msg_list);
2488: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2489: c:=p_catv_tbl.COUNT;

Line 2487: OKC_API.init_msg_list(p_init_msg_list);

2483: c NUMBER;
2484: i NUMBER;
2485: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2486: BEGIN
2487: OKC_API.init_msg_list(p_init_msg_list);
2488: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2489: c:=p_catv_tbl.COUNT;
2490: if (c>0) then
2491: i := p_catv_tbl.FIRST;

Line 2488: x_return_status:= OKC_API.G_RET_STS_SUCCESS;

2484: i NUMBER;
2485: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2486: BEGIN
2487: OKC_API.init_msg_list(p_init_msg_list);
2488: x_return_status:= OKC_API.G_RET_STS_SUCCESS;
2489: c:=p_catv_tbl.COUNT;
2490: if (c>0) then
2491: i := p_catv_tbl.FIRST;
2492: LOOP

Line 2494: p_init_msg_list=>OKC_API.G_FALSE,

2490: if (c>0) then
2491: i := p_catv_tbl.FIRST;
2492: LOOP
2493: validate_k_article(p_api_version=>p_api_version,
2494: p_init_msg_list=>OKC_API.G_FALSE,
2495: x_return_status=>l_return_status,
2496: x_msg_count=>x_msg_count,
2497: x_msg_data=>x_msg_data,
2498: p_catv_rec=>p_catv_tbl(i));

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

2495: x_return_status=>l_return_status,
2496: x_msg_count=>x_msg_count,
2497: x_msg_data=>x_msg_data,
2498: p_catv_rec=>p_catv_tbl(i));
2499: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2500: x_return_status := l_return_status;
2501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2502: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2503: x_return_status := l_return_status;

Line 2501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

2497: x_msg_data=>x_msg_data,
2498: p_catv_rec=>p_catv_tbl(i));
2499: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2500: x_return_status := l_return_status;
2501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2502: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2503: x_return_status := l_return_status;
2504: end if;
2505: c:=c-1;

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

2498: p_catv_rec=>p_catv_tbl(i));
2499: if (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) then
2500: x_return_status := l_return_status;
2501: raise OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
2502: elsif (l_return_status = OKC_API.G_RET_STS_ERROR) then
2503: x_return_status := l_return_status;
2504: end if;
2505: c:=c-1;
2506: EXIT WHEN (c=0);

Line 2528: OKC_API.init_msg_list(p_init_msg_list);

2524: x_msg_data OUT NOCOPY VARCHAR2,
2525: p_atnv_rec IN atnv_rec_type,
2526: x_atnv_rec OUT NOCOPY atnv_rec_type) is
2527: begin
2528: OKC_API.init_msg_list(p_init_msg_list);
2529: IF (l_debug = 'Y') THEN
2530: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2531: END IF;
2532: -- We won't create a record - keep g_atnv_rec empty

Line 2536: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2532: -- We won't create a record - keep g_atnv_rec empty
2533: -- g_atnv_rec := p_atnv_rec;
2534: -- x_atnv_rec := p_atnv_rec;
2535: x_msg_count := 0;
2536: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2537: end create_article_translation;
2538:
2539: -- Start of comments
2540: --

Line 2555: OKC_API.init_msg_list(p_init_msg_list);

2551: x_msg_data OUT NOCOPY VARCHAR2,
2552: p_atnv_tbl IN atnv_tbl_type,
2553: x_atnv_tbl OUT NOCOPY atnv_tbl_type) is
2554: begin
2555: OKC_API.init_msg_list(p_init_msg_list);
2556: IF (l_debug = 'Y') THEN
2557: Okc_Debug.Log('400: Entered create_article_translation - DUMMY procedure', 2);
2558: END IF;
2559: -- We won't create a record - keep g_atnv_rec empty

Line 2563: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2559: -- We won't create a record - keep g_atnv_rec empty
2560: -- g_atnv_rec := p_atnv_rec;
2561: -- x_atnv_rec := p_atnv_rec;
2562: x_msg_count := 0;
2563: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2564: end create_article_translation;
2565:
2566: -- Start of comments
2567: --

Line 2581: OKC_API.init_msg_list(p_init_msg_list);

2577: x_msg_count OUT NOCOPY NUMBER,
2578: x_msg_data OUT NOCOPY VARCHAR2,
2579: p_atnv_rec IN atnv_rec_type) is
2580: begin
2581: OKC_API.init_msg_list(p_init_msg_list);
2582: IF (l_debug = 'Y') THEN
2583: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2584: END IF;
2585: x_msg_count := 0;

Line 2586: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2582: IF (l_debug = 'Y') THEN
2583: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2584: END IF;
2585: x_msg_count := 0;
2586: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2587: end lock_article_translation;
2588:
2589: -- Start of comments
2590: --

Line 2604: OKC_API.init_msg_list(p_init_msg_list);

2600: x_msg_count OUT NOCOPY NUMBER,
2601: x_msg_data OUT NOCOPY VARCHAR2,
2602: p_atnv_tbl IN atnv_tbl_type) is
2603: begin
2604: OKC_API.init_msg_list(p_init_msg_list);
2605: IF (l_debug = 'Y') THEN
2606: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2607: END IF;
2608: x_msg_count := 0;

Line 2609: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2605: IF (l_debug = 'Y') THEN
2606: Okc_Debug.Log('400: Entered lock_article_translation - DUMMY procedure', 2);
2607: END IF;
2608: x_msg_count := 0;
2609: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2610: end lock_article_translation;
2611:
2612: -- Start of comments
2613: --

Line 2627: OKC_API.init_msg_list(p_init_msg_list);

2623: x_msg_count OUT NOCOPY NUMBER,
2624: x_msg_data OUT NOCOPY VARCHAR2,
2625: p_atnv_rec IN atnv_rec_type) is
2626: begin
2627: OKC_API.init_msg_list(p_init_msg_list);
2628: IF (l_debug = 'Y') THEN
2629: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2630: END IF;
2631: x_msg_count := 0;

Line 2632: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2628: IF (l_debug = 'Y') THEN
2629: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2630: END IF;
2631: x_msg_count := 0;
2632: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2633: end delete_article_translation;
2634:
2635: -- Start of comments
2636: --

Line 2650: OKC_API.init_msg_list(p_init_msg_list);

2646: x_msg_count OUT NOCOPY NUMBER,
2647: x_msg_data OUT NOCOPY VARCHAR2,
2648: p_atnv_tbl IN atnv_tbl_type) is
2649: begin
2650: OKC_API.init_msg_list(p_init_msg_list);
2651: IF (l_debug = 'Y') THEN
2652: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2653: END IF;
2654: x_msg_count := 0;

Line 2655: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2651: IF (l_debug = 'Y') THEN
2652: Okc_Debug.Log('400: Entered delete_article_translation - DUMMY procedure', 2);
2653: END IF;
2654: x_msg_count := 0;
2655: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2656: end delete_article_translation;
2657:
2658: -- Start of comments
2659: --

Line 2673: OKC_API.init_msg_list(p_init_msg_list);

2669: x_msg_count OUT NOCOPY NUMBER,
2670: x_msg_data OUT NOCOPY VARCHAR2,
2671: p_atnv_rec IN atnv_rec_type) is
2672: begin
2673: OKC_API.init_msg_list(p_init_msg_list);
2674: IF (l_debug = 'Y') THEN
2675: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2676: END IF;
2677: x_msg_count := 0;

Line 2678: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2674: IF (l_debug = 'Y') THEN
2675: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2676: END IF;
2677: x_msg_count := 0;
2678: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2679: end validate_article_translation;
2680:
2681: -- Start of comments
2682: --

Line 2696: OKC_API.init_msg_list(p_init_msg_list);

2692: x_msg_count OUT NOCOPY NUMBER,
2693: x_msg_data OUT NOCOPY VARCHAR2,
2694: p_atnv_tbl IN atnv_tbl_type) is
2695: begin
2696: OKC_API.init_msg_list(p_init_msg_list);
2697: IF (l_debug = 'Y') THEN
2698: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2699: END IF;
2700: x_msg_count := 0;

Line 2701: x_return_status := OKC_API.G_RET_STS_SUCCESS;

2697: IF (l_debug = 'Y') THEN
2698: Okc_Debug.Log('400: Entered validate_article_translation - DUMMY procedure', 2);
2699: END IF;
2700: x_msg_count := 0;
2701: x_return_status := OKC_API.G_RET_STS_SUCCESS;
2702: end validate_article_translation;
2703:
2704: -- Start of comments
2705: --