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.

[Home] [Help]

APPS.OKC_ARTICLES_ALL_PVT dependencies on FND_API

Line 36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;

32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

Line 37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;

33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:

Line 38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;

34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

Line 39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

Line 40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

388: x_last_update_date => l_last_update_date
389: );
390: --- If any errors happen abort API
391: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:

Line 394: RAISE FND_API.G_EXC_ERROR;

390: --- If any errors happen abort API
391: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
392: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
393: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
394: RAISE FND_API.G_EXC_ERROR;
395: END IF;
396:
397: --- Reversing G_MISS/NULL values logic
398: pending := false; -- reset pending flag

Line 636: WHEN FND_API.G_EXC_ERROR THEN

632: END IF;
633:
634: RETURN G_RET_STS_SUCCESS ;
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: IF (l_debug = 'Y') THEN
638: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
639: END IF;
640: RETURN G_RET_STS_ERROR;

Line 638: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);

634: RETURN G_RET_STS_SUCCESS ;
635: EXCEPTION
636: WHEN FND_API.G_EXC_ERROR THEN
637: IF (l_debug = 'Y') THEN
638: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
639: END IF;
640: RETURN G_RET_STS_ERROR;
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

638: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
639: END IF;
640: RETURN G_RET_STS_ERROR;
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: IF (l_debug = 'Y') THEN
644: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
645: END IF;
646: RETURN G_RET_STS_UNEXP_ERROR;

Line 644: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

640: RETURN G_RET_STS_ERROR;
641:
642: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
643: IF (l_debug = 'Y') THEN
644: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
645: END IF;
646: RETURN G_RET_STS_UNEXP_ERROR;
647:
648: WHEN OTHERS THEN

Line 666: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

662: ----------------------------------------------
663: -- Validate_Attributes for: OKC_ARTICLES_ALL --
664: ----------------------------------------------
665: FUNCTION Validate_Attributes (
666: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
667: p_import_action IN VARCHAR2 := NULL,
668:
669: p_article_id IN NUMBER,
670: p_article_title IN VARCHAR2,

Line 997: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

993: ------------------------------------------
994: -- Validate_Record for:OKC_ARTICLES_ALL --
995: ------------------------------------------
996: FUNCTION Validate_Record (
997: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
998: p_import_action IN VARCHAR2 := NULL,
999:
1000: p_article_id IN NUMBER,
1001: p_article_title IN VARCHAR2,

Line 1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1177: ---------------------------------------
1178: -- validate_row for:OKC_ARTICLES_ALL --
1179: ---------------------------------------
1180: PROCEDURE validate_row(
1181: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1182: p_import_action IN VARCHAR2 := NULL,
1183:
1184:
1185: x_return_status OUT NOCOPY VARCHAR2,

Line 1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1362: x_attribute14 => l_attribute14,
1363: x_attribute15 => l_attribute15
1364: );
1365: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370: END IF;

Line 1368: RAISE FND_API.G_EXC_ERROR;

1364: );
1365: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1366: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1367: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1368: RAISE FND_API.G_EXC_ERROR;
1369: END IF;
1370: END IF;
1371:
1372: -- Validate all non-missing attributes (Item Level Validation)

Line 1415: WHEN FND_API.G_EXC_ERROR THEN

1411: Okc_Debug.Log('3200: Leaving validate_row', 2);
1412: END IF;
1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: IF (l_debug = 'Y') THEN
1417: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1418: END IF;
1419: x_return_status := G_RET_STS_ERROR;

Line 1417: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);

1413:
1414: EXCEPTION
1415: WHEN FND_API.G_EXC_ERROR THEN
1416: IF (l_debug = 'Y') THEN
1417: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1418: END IF;
1419: x_return_status := G_RET_STS_ERROR;
1420:
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1417: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1418: END IF;
1419: x_return_status := G_RET_STS_ERROR;
1420:
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: IF (l_debug = 'Y') THEN
1423: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1424: END IF;
1425: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1423: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1419: x_return_status := G_RET_STS_ERROR;
1420:
1421: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1422: IF (l_debug = 'Y') THEN
1423: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1424: END IF;
1425: x_return_status := G_RET_STS_UNEXP_ERROR;
1426:
1427: WHEN OTHERS THEN

Line 1629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

1625: -------------------------------------
1626: -- Insert_Row for:OKC_ARTICLES_ALL --
1627: -------------------------------------
1628: PROCEDURE Insert_Row(
1629: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1630: x_return_status OUT NOCOPY VARCHAR2,
1631:
1632: p_article_id IN NUMBER := NULL,
1633: p_article_title IN VARCHAR2,

Line 1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1692: x_article_id => x_article_id
1693: );
1694: --- If any errors happen abort API
1695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700: ELSE

Line 1698: RAISE FND_API.G_EXC_ERROR;

1694: --- If any errors happen abort API
1695: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1696: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1697: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1698: RAISE FND_API.G_EXC_ERROR;
1699: END IF;
1700: ELSE
1701: x_article_id := p_article_id;
1702: END IF;

Line 1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1746: p_attribute15 => p_attribute15
1747: );
1748: --- If any errors happen abort API
1749: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1752: RAISE FND_API.G_EXC_ERROR;
1753: END IF;
1754:

Line 1752: RAISE FND_API.G_EXC_ERROR;

1748: --- If any errors happen abort API
1749: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1751: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1752: RAISE FND_API.G_EXC_ERROR;
1753: END IF;
1754:
1755: --------------------------------------------
1756: -- Call the internal Insert_Row for each child record

Line 1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1799: p_last_update_login => l_last_update_login,
1800: p_last_update_date => l_last_update_date
1801: );
1802: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807:

Line 1805: RAISE FND_API.G_EXC_ERROR;

1801: );
1802: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1803: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1804: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1805: RAISE FND_API.G_EXC_ERROR;
1806: END IF;
1807:
1808:
1809:

Line 1815: WHEN FND_API.G_EXC_ERROR THEN

1811: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1812: END IF;
1813:
1814: EXCEPTION
1815: WHEN FND_API.G_EXC_ERROR THEN
1816: IF (l_debug = 'Y') THEN
1817: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1818: END IF;
1819: x_return_status := G_RET_STS_ERROR;

Line 1817: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);

1813:
1814: EXCEPTION
1815: WHEN FND_API.G_EXC_ERROR THEN
1816: IF (l_debug = 'Y') THEN
1817: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1818: END IF;
1819: x_return_status := G_RET_STS_ERROR;
1820:
1821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1817: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1818: END IF;
1819: x_return_status := G_RET_STS_ERROR;
1820:
1821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1822: IF (l_debug = 'Y') THEN
1823: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1824: END IF;
1825: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1823: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1819: x_return_status := G_RET_STS_ERROR;
1820:
1821: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1822: IF (l_debug = 'Y') THEN
1823: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1824: END IF;
1825: x_return_status := G_RET_STS_UNEXP_ERROR;
1826:
1827: WHEN OTHERS THEN

Line 1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1970: p_article_id => p_article_id,
1971: p_object_version_number => p_object_version_number
1972: );
1973: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978:

Line 1976: RAISE FND_API.G_EXC_ERROR;

1972: );
1973: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1974: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1975: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1976: RAISE FND_API.G_EXC_ERROR;
1977: END IF;
1978:
1979:
1980:

Line 1986: WHEN FND_API.G_EXC_ERROR THEN

1982: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1983: END IF;
1984:
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: IF (l_debug = 'Y') THEN
1988: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1989: END IF;
1990: x_return_status := G_RET_STS_ERROR;

Line 1988: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);

1984:
1985: EXCEPTION
1986: WHEN FND_API.G_EXC_ERROR THEN
1987: IF (l_debug = 'Y') THEN
1988: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1989: END IF;
1990: x_return_status := G_RET_STS_ERROR;
1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1988: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1989: END IF;
1990: x_return_status := G_RET_STS_ERROR;
1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: IF (l_debug = 'Y') THEN
1994: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1995: END IF;
1996: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1994: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1990: x_return_status := G_RET_STS_ERROR;
1991:
1992: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1993: IF (l_debug = 'Y') THEN
1994: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1995: END IF;
1996: x_return_status := G_RET_STS_UNEXP_ERROR;
1997:
1998: WHEN OTHERS THEN

Line 2162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

2158: -------------------------------------
2159: -- Update_Row for:OKC_ARTICLES_ALL --
2160: -------------------------------------
2161: PROCEDURE Update_Row(
2162: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2163:
2164: x_return_status OUT NOCOPY VARCHAR2,
2165: x_article_intent OUT NOCOPY VARCHAR2,
2166:

Line 2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2251: p_article_id => p_article_id,
2252: p_object_version_number => p_object_version_number
2253: );
2254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:

Line 2257: RAISE FND_API.G_EXC_ERROR;

2253: );
2254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:
2260:
2261: IF (l_debug = 'Y') THEN

Line 2332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2328: x_attribute14 => l_attribute14,
2329: x_attribute15 => l_attribute15
2330: );
2331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336:

Line 2334: RAISE FND_API.G_EXC_ERROR;

2330: );
2331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2334: RAISE FND_API.G_EXC_ERROR;
2335: END IF;
2336:
2337: IF (l_debug = 'Y') THEN
2338: Okc_Debug.Log('7400: Record Validation', 2);

Line 2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2375: p_attribute15 => l_attribute15
2376: );
2377: --- If any errors happen abort API
2378: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383:

Line 2381: RAISE FND_API.G_EXC_ERROR;

2377: --- If any errors happen abort API
2378: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2379: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2380: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2381: RAISE FND_API.G_EXC_ERROR;
2382: END IF;
2383:
2384: IF (l_debug = 'Y') THEN
2385: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2442: p_last_update_login => l_last_update_login,
2443: p_last_update_date => l_last_update_date
2444: );
2445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2448: RAISE FND_API.G_EXC_ERROR;
2449: END IF;
2450: x_article_intent := l_article_intent;

Line 2448: RAISE FND_API.G_EXC_ERROR;

2444: );
2445: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2446: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2447: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2448: RAISE FND_API.G_EXC_ERROR;
2449: END IF;
2450: x_article_intent := l_article_intent;
2451:
2452:

Line 2458: WHEN FND_API.G_EXC_ERROR THEN

2454: Okc_Debug.Log('7800: Leaving Update_Row', 2);
2455: END IF;
2456:
2457: EXCEPTION
2458: WHEN FND_API.G_EXC_ERROR THEN
2459: IF (l_debug = 'Y') THEN
2460: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2461: END IF;
2462: x_return_status := G_RET_STS_ERROR;

Line 2460: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);

2456:
2457: EXCEPTION
2458: WHEN FND_API.G_EXC_ERROR THEN
2459: IF (l_debug = 'Y') THEN
2460: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2461: END IF;
2462: x_return_status := G_RET_STS_ERROR;
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2460: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2461: END IF;
2462: x_return_status := G_RET_STS_ERROR;
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: IF (l_debug = 'Y') THEN
2466: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2467: END IF;
2468: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 2466: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2462: x_return_status := G_RET_STS_ERROR;
2463:
2464: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2465: IF (l_debug = 'Y') THEN
2466: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2467: END IF;
2468: x_return_status := G_RET_STS_UNEXP_ERROR;
2469:
2470: WHEN OTHERS THEN

Line 2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2543: p_article_id => p_article_id,
2544: p_object_version_number => p_object_version_number
2545: );
2546: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2549: RAISE FND_API.G_EXC_ERROR;
2550: END IF;
2551:

Line 2549: RAISE FND_API.G_EXC_ERROR;

2545: );
2546: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2547: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2548: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2549: RAISE FND_API.G_EXC_ERROR;
2550: END IF;
2551:
2552:
2553: IF (l_debug = 'Y') THEN

Line 2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2554: Okc_Debug.Log('9100: Removing _B row', 2);
2555: END IF;
2556: x_return_status := Delete_Row( p_article_id => p_article_id );
2557: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2560: RAISE FND_API.G_EXC_ERROR;
2561: END IF;
2562:

Line 2560: RAISE FND_API.G_EXC_ERROR;

2556: x_return_status := Delete_Row( p_article_id => p_article_id );
2557: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2558: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2559: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2560: RAISE FND_API.G_EXC_ERROR;
2561: END IF;
2562:
2563:
2564: IF (l_debug = 'Y') THEN

Line 2569: WHEN FND_API.G_EXC_ERROR THEN

2565: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
2566: END IF;
2567:
2568: EXCEPTION
2569: WHEN FND_API.G_EXC_ERROR THEN
2570: IF (l_debug = 'Y') THEN
2571: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2572: END IF;
2573: x_return_status := G_RET_STS_ERROR;

Line 2571: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);

2567:
2568: EXCEPTION
2569: WHEN FND_API.G_EXC_ERROR THEN
2570: IF (l_debug = 'Y') THEN
2571: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2572: END IF;
2573: x_return_status := G_RET_STS_ERROR;
2574:
2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2571: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2572: END IF;
2573: x_return_status := G_RET_STS_ERROR;
2574:
2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2576: IF (l_debug = 'Y') THEN
2577: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2578: END IF;
2579: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 2577: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2573: x_return_status := G_RET_STS_ERROR;
2574:
2575: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2576: IF (l_debug = 'Y') THEN
2577: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2578: END IF;
2579: x_return_status := G_RET_STS_UNEXP_ERROR;
2580:
2581: WHEN OTHERS THEN