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_ARTICLE_VERSIONS_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 511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

507: x_variable_code => x_variable_code --clm
508: );
509: --- If any errors happen abort API
510: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:

Line 513: RAISE FND_API.G_EXC_ERROR;

509: --- If any errors happen abort API
510: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
511: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
512: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
513: RAISE FND_API.G_EXC_ERROR;
514: END IF;
515:
516: --- Reversing G_MISS/NULL values logic
517:

Line 881: WHEN FND_API.G_EXC_ERROR THEN

877: END IF;
878:
879: RETURN G_RET_STS_SUCCESS ;
880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: IF (l_debug = 'Y') THEN
883: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
884: END IF;
885: RETURN G_RET_STS_ERROR;

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

879: RETURN G_RET_STS_SUCCESS ;
880: EXCEPTION
881: WHEN FND_API.G_EXC_ERROR THEN
882: IF (l_debug = 'Y') THEN
883: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
884: END IF;
885: RETURN G_RET_STS_ERROR;
886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

883: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
884: END IF;
885: RETURN G_RET_STS_ERROR;
886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888: IF (l_debug = 'Y') THEN
889: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
890: END IF;
891: RETURN G_RET_STS_UNEXP_ERROR;

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

885: RETURN G_RET_STS_ERROR;
886:
887: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
888: IF (l_debug = 'Y') THEN
889: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
890: END IF;
891: RETURN G_RET_STS_UNEXP_ERROR;
892:
893: WHEN OTHERS THEN

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

907: ----------------------------------------------
908: -- Validate_Attributes for: OKC_ARTICLE_VERSIONS --
909: ----------------------------------------------
910: FUNCTION Validate_Attributes (
911: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
912: p_import_action IN VARCHAR2 := NULL,
913: p_standard_yn IN VARCHAR2,
914:
915: p_article_version_id IN NUMBER,

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

1381: ------------------------------------------
1382: -- Validate_Record for:OKC_ARTICLE_VERSIONS --
1383: ------------------------------------------
1384: FUNCTION Validate_Record (
1385: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1386: p_import_action IN VARCHAR2 := NULL,
1387:
1388: p_article_version_id IN NUMBER,
1389: p_article_id IN NUMBER,

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

1930: ---------------------------------------
1931: -- validate_row for:OKC_ARTICLE_VERSIONS --
1932: ---------------------------------------
1933: PROCEDURE validate_row(
1934: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1935: p_import_action IN VARCHAR2 := NULL,
1936:
1937: x_return_status OUT NOCOPY VARCHAR2,
1938: x_earlier_adoption_type OUT NOCOPY VARCHAR2,

Line 2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2213: x_article_text_in_word => l_article_text_in_word,
2214: x_variable_code => l_variable_code --clm
2215: );
2216: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221: END IF;

Line 2219: RAISE FND_API.G_EXC_ERROR;

2215: );
2216: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2217: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2218: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2219: RAISE FND_API.G_EXC_ERROR;
2220: END IF;
2221: END IF;
2222: -- MOAC
2223: G_CURRENT_ORG_ID := mo_global.get_current_org_id();

Line 2233: RAISE FND_API.G_EXC_ERROR;

2229: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2230: END IF;
2231: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2232: x_return_status := G_RET_STS_ERROR;
2233: RAISE FND_API.G_EXC_ERROR;
2234: end if;
2235:
2236: end if;
2237: /*

Line 2312: WHEN FND_API.G_EXC_ERROR THEN

2308: Okc_Debug.Log('3200: Leaving validate_row', 2);
2309: END IF;
2310:
2311: EXCEPTION
2312: WHEN FND_API.G_EXC_ERROR THEN
2313: IF (l_debug = 'Y') THEN
2314: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
2315: END IF;
2316: x_return_status := G_RET_STS_ERROR;

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

2310:
2311: EXCEPTION
2312: WHEN FND_API.G_EXC_ERROR THEN
2313: IF (l_debug = 'Y') THEN
2314: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
2315: END IF;
2316: x_return_status := G_RET_STS_ERROR;
2317:
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2314: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
2315: END IF;
2316: x_return_status := G_RET_STS_ERROR;
2317:
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2319: IF (l_debug = 'Y') THEN
2320: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2321: END IF;
2322: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2316: x_return_status := G_RET_STS_ERROR;
2317:
2318: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2319: IF (l_debug = 'Y') THEN
2320: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2321: END IF;
2322: x_return_status := G_RET_STS_UNEXP_ERROR;
2323:
2324: WHEN OTHERS THEN

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

2579: -------------------------------------
2580: -- Insert_Row for:OKC_ARTICLE_VERSIONS --
2581: -------------------------------------
2582: PROCEDURE Insert_Row(
2583: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2584: x_return_status OUT NOCOPY VARCHAR2,
2585:
2586: p_article_version_id IN NUMBER,
2587: p_article_id IN NUMBER,

Line 2670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2666: x_article_version_id => x_article_version_id
2667: );
2668: --- If any errors happen abort API
2669: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2671: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: ELSE

Line 2672: RAISE FND_API.G_EXC_ERROR;

2668: --- If any errors happen abort API
2669: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2670: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2671: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2672: RAISE FND_API.G_EXC_ERROR;
2673: END IF;
2674: ELSE
2675: x_article_version_id := p_article_version_id;
2676: END IF;

Line 2697: RAISE FND_API.G_EXC_ERROR;

2693: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
2694: END IF;
2695: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
2696: x_return_status := G_RET_STS_ERROR;
2697: RAISE FND_API.G_EXC_ERROR;
2698: end if;
2699:
2700: end if;
2701: /*

Line 2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2767: x_earlier_version_number => l_article_version_number
2768: );
2769: --- If any errors happen abort API
2770: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:

Line 2773: RAISE FND_API.G_EXC_ERROR;

2769: --- If any errors happen abort API
2770: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2771: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2772: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2773: RAISE FND_API.G_EXC_ERROR;
2774: END IF;
2775:
2776: --------------------------------------------
2777: -- Call the internal Insert_Row for each child record

Line 2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2847: p_last_update_date => l_last_update_date,
2848: p_variable_code => p_variable_code --clm
2849: );
2850: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2853: RAISE FND_API.G_EXC_ERROR;
2854: END IF;
2855:

Line 2853: RAISE FND_API.G_EXC_ERROR;

2849: );
2850: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2851: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2852: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2853: RAISE FND_API.G_EXC_ERROR;
2854: END IF;
2855:
2856:
2857:

Line 2863: WHEN FND_API.G_EXC_ERROR THEN

2859: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
2860: END IF;
2861:
2862: EXCEPTION
2863: WHEN FND_API.G_EXC_ERROR THEN
2864: IF (l_debug = 'Y') THEN
2865: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
2866: END IF;
2867: x_return_status := G_RET_STS_ERROR;

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

2861:
2862: EXCEPTION
2863: WHEN FND_API.G_EXC_ERROR THEN
2864: IF (l_debug = 'Y') THEN
2865: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
2866: END IF;
2867: x_return_status := G_RET_STS_ERROR;
2868:
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2865: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
2866: END IF;
2867: x_return_status := G_RET_STS_ERROR;
2868:
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: IF (l_debug = 'Y') THEN
2871: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2872: END IF;
2873: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2867: x_return_status := G_RET_STS_ERROR;
2868:
2869: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2870: IF (l_debug = 'Y') THEN
2871: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2872: END IF;
2873: x_return_status := G_RET_STS_UNEXP_ERROR;
2874:
2875: WHEN OTHERS THEN

Line 3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3017: p_article_version_id => p_article_version_id,
3018: p_object_version_number => p_object_version_number
3019: );
3020: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025:

Line 3023: RAISE FND_API.G_EXC_ERROR;

3019: );
3020: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3021: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3022: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3023: RAISE FND_API.G_EXC_ERROR;
3024: END IF;
3025:
3026:
3027:

Line 3033: WHEN FND_API.G_EXC_ERROR THEN

3029: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
3030: END IF;
3031:
3032: EXCEPTION
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: IF (l_debug = 'Y') THEN
3035: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
3036: END IF;
3037: x_return_status := G_RET_STS_ERROR;

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

3031:
3032: EXCEPTION
3033: WHEN FND_API.G_EXC_ERROR THEN
3034: IF (l_debug = 'Y') THEN
3035: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
3036: END IF;
3037: x_return_status := G_RET_STS_ERROR;
3038:
3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3035: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
3036: END IF;
3037: x_return_status := G_RET_STS_ERROR;
3038:
3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3040: IF (l_debug = 'Y') THEN
3041: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3042: END IF;
3043: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3037: x_return_status := G_RET_STS_ERROR;
3038:
3039: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3040: IF (l_debug = 'Y') THEN
3041: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3042: END IF;
3043: x_return_status := G_RET_STS_UNEXP_ERROR;
3044:
3045: WHEN OTHERS THEN

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

3236: -------------------------------------
3237: -- Update_Row for:OKC_ARTICLE_VERSIONS --
3238: -------------------------------------
3239: PROCEDURE Update_Row(
3240: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
3241:
3242: x_return_status OUT NOCOPY VARCHAR2,
3243:
3244: p_article_version_id IN NUMBER,

Line 3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3369: p_article_version_id => p_article_version_id,
3370: p_object_version_number => p_object_version_number
3371: );
3372: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3375: RAISE FND_API.G_EXC_ERROR;
3376: END IF;
3377:

Line 3375: RAISE FND_API.G_EXC_ERROR;

3371: );
3372: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3373: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3374: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3375: RAISE FND_API.G_EXC_ERROR;
3376: END IF;
3377:
3378:
3379: IF (l_debug = 'Y') THEN

Line 3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3482: x_article_text_in_word => l_article_text_in_word,
3483: x_variable_code => l_variable_code --clm
3484: );
3485: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3487: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;
3490:

Line 3488: RAISE FND_API.G_EXC_ERROR;

3484: );
3485: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3486: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3487: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3488: RAISE FND_API.G_EXC_ERROR;
3489: END IF;
3490:
3491: IF (l_debug = 'Y') THEN
3492: Okc_Debug.Log('7400: Record Validation', 2);

Line 3506: RAISE FND_API.G_EXC_ERROR;

3502: Okc_Debug.Log('2300: - attribute G_CURRENT_ORG_ID is invalid', 2);
3503: END IF;
3504: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
3505: x_return_status := G_RET_STS_ERROR;
3506: RAISE FND_API.G_EXC_ERROR;
3507: end if;
3508:
3509: end if;
3510: /*

Line 3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3576: x_earlier_version_number => l_earlier_version_number
3577: );
3578: --- If any errors happen abort API
3579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: END IF;
3584:

Line 3582: RAISE FND_API.G_EXC_ERROR;

3578: --- If any errors happen abort API
3579: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3580: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3581: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3582: RAISE FND_API.G_EXC_ERROR;
3583: END IF;
3584:
3585: IF (l_debug = 'Y') THEN
3586: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3661: p_last_update_date => l_last_update_date,
3662: p_variable_code => l_variable_code --clm
3663: );
3664: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: END IF;
3669:

Line 3667: RAISE FND_API.G_EXC_ERROR;

3663: );
3664: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3665: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3666: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3667: RAISE FND_API.G_EXC_ERROR;
3668: END IF;
3669:
3670:
3671: IF (l_debug = 'Y') THEN

Line 3676: WHEN FND_API.G_EXC_ERROR THEN

3672: Okc_Debug.Log('7800: Leaving Update_Row', 2);
3673: END IF;
3674:
3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: IF (l_debug = 'Y') THEN
3678: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
3679: END IF;
3680: x_return_status := G_RET_STS_ERROR;

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

3674:
3675: EXCEPTION
3676: WHEN FND_API.G_EXC_ERROR THEN
3677: IF (l_debug = 'Y') THEN
3678: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
3679: END IF;
3680: x_return_status := G_RET_STS_ERROR;
3681:
3682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3678: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
3679: END IF;
3680: x_return_status := G_RET_STS_ERROR;
3681:
3682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3683: IF (l_debug = 'Y') THEN
3684: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3685: END IF;
3686: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3680: x_return_status := G_RET_STS_ERROR;
3681:
3682: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3683: IF (l_debug = 'Y') THEN
3684: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3685: END IF;
3686: x_return_status := G_RET_STS_UNEXP_ERROR;
3687:
3688: WHEN OTHERS THEN

Line 3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3761: p_article_version_id => p_article_version_id,
3762: p_object_version_number => p_object_version_number
3763: );
3764: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3767: RAISE FND_API.G_EXC_ERROR;
3768: END IF;
3769:

Line 3767: RAISE FND_API.G_EXC_ERROR;

3763: );
3764: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3765: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3766: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3767: RAISE FND_API.G_EXC_ERROR;
3768: END IF;
3769:
3770:
3771: IF (l_debug = 'Y') THEN

Line 3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3772: Okc_Debug.Log('9100: Removing _B row', 2);
3773: END IF;
3774: x_return_status := Delete_Row( p_article_version_id => p_article_version_id );
3775: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3777: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3778: RAISE FND_API.G_EXC_ERROR;
3779: END IF;
3780:

Line 3778: RAISE FND_API.G_EXC_ERROR;

3774: x_return_status := Delete_Row( p_article_version_id => p_article_version_id );
3775: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3776: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3777: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3778: RAISE FND_API.G_EXC_ERROR;
3779: END IF;
3780:
3781:
3782: IF (l_debug = 'Y') THEN

Line 3787: WHEN FND_API.G_EXC_ERROR THEN

3783: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
3784: END IF;
3785:
3786: EXCEPTION
3787: WHEN FND_API.G_EXC_ERROR THEN
3788: IF (l_debug = 'Y') THEN
3789: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
3790: END IF;
3791: x_return_status := G_RET_STS_ERROR;

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

3785:
3786: EXCEPTION
3787: WHEN FND_API.G_EXC_ERROR THEN
3788: IF (l_debug = 'Y') THEN
3789: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
3790: END IF;
3791: x_return_status := G_RET_STS_ERROR;
3792:
3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3789: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
3790: END IF;
3791: x_return_status := G_RET_STS_ERROR;
3792:
3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3794: IF (l_debug = 'Y') THEN
3795: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3796: END IF;
3797: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3791: x_return_status := G_RET_STS_ERROR;
3792:
3793: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3794: IF (l_debug = 'Y') THEN
3795: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3796: END IF;
3797: x_return_status := G_RET_STS_UNEXP_ERROR;
3798:
3799: WHEN OTHERS THEN