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_K_ARTICLES_PVT dependencies on FND_API

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

839: ----------------------------------------------
840: -- Validate_Attributes for: OKC_K_ARTICLES_B --
841: ----------------------------------------------
842: FUNCTION Validate_Attributes (
843: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
844:
845: p_id IN NUMBER,
846: p_sav_sae_id IN NUMBER,
847: p_document_type IN VARCHAR2,

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

2380: -------------------------------------
2381: -- Update_Row for:OKC_K_ARTICLES_B --
2382: -------------------------------------
2383: PROCEDURE Update_Row(
2384: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2385: x_return_status OUT NOCOPY VARCHAR2,
2386: p_id IN NUMBER,
2387: p_sav_sae_id IN NUMBER,
2388: p_document_type IN VARCHAR2,

Line 2860: p_init_msg_list => FND_API.G_FALSE,

2856: FETCH l_non_std_exists_csr INTO l_non_std_exists;
2857: IF l_non_std_exists_csr%NOTFOUND THEN
2858: OKC_ARTICLES_GRP.delete_article(
2859: p_api_version => 1,
2860: p_init_msg_list => FND_API.G_FALSE,
2861:
2862: x_return_status => l_return_status,
2863: x_msg_count => l_msg_count,
2864: x_msg_data => l_msg_data,

Line 2956: WHEN FND_API.G_EXC_ERROR THEN

2952: END IF;
2953: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2954: x_return_status := G_RET_STS_ERROR ;
2955:
2956: WHEN FND_API.G_EXC_ERROR THEN
2957: IF (l_debug = 'Y') THEN
2958: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2959: END IF;
2960:

Line 2958: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

2954: x_return_status := G_RET_STS_ERROR ;
2955:
2956: WHEN FND_API.G_EXC_ERROR THEN
2957: IF (l_debug = 'Y') THEN
2958: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2959: END IF;
2960:
2961: IF (lock_csr%ISOPEN) THEN
2962: CLOSE lock_csr;

Line 2966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2962: CLOSE lock_csr;
2963: END IF;
2964: x_return_status := G_RET_STS_ERROR;
2965:
2966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2967: IF (l_debug = 'Y') THEN
2968: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2969: END IF;
2970:

Line 2968: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2964: x_return_status := G_RET_STS_ERROR;
2965:
2966: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2967: IF (l_debug = 'Y') THEN
2968: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2969: END IF;
2970:
2971: IF (lock_csr%ISOPEN) THEN
2972: CLOSE lock_csr;

Line 3047: WHEN FND_API.G_EXC_ERROR THEN

3043: END IF;
3044: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
3045: x_return_status := G_RET_STS_ERROR ;
3046:
3047: WHEN FND_API.G_EXC_ERROR THEN
3048: IF (l_debug = 'Y') THEN
3049: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3050: END IF;
3051:

Line 3049: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

3045: x_return_status := G_RET_STS_ERROR ;
3046:
3047: WHEN FND_API.G_EXC_ERROR THEN
3048: IF (l_debug = 'Y') THEN
3049: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3050: END IF;
3051:
3052: IF (lock_csr%ISOPEN) THEN
3053: CLOSE lock_csr;

Line 3057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3053: CLOSE lock_csr;
3054: END IF;
3055: x_return_status := G_RET_STS_ERROR;
3056:
3057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3058: IF (l_debug = 'Y') THEN
3059: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3060: END IF;
3061:

Line 3059: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

3055: x_return_status := G_RET_STS_ERROR;
3056:
3057: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3058: IF (l_debug = 'Y') THEN
3059: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3060: END IF;
3061:
3062: IF (lock_csr%ISOPEN) THEN
3063: CLOSE lock_csr;

Line 3246: p_init_msg_list => FND_API.G_FALSE,

3242: IF (l_debug = 'Y') THEN
3243: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3244: END IF;
3245: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3246: p_init_msg_list => FND_API.G_FALSE,
3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3248: p_commit => FND_API.G_FALSE,
3249: p_article_version_id => rec.article_version_id,
3250: p_new_article_title => NULL,

Line 3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3243: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3244: END IF;
3245: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3246: p_init_msg_list => FND_API.G_FALSE,
3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3248: p_commit => FND_API.G_FALSE,
3249: p_article_version_id => rec.article_version_id,
3250: p_new_article_title => NULL,
3251: p_create_standard_yn => 'N',

Line 3248: p_commit => FND_API.G_FALSE,

3244: END IF;
3245: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3246: p_init_msg_list => FND_API.G_FALSE,
3247: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3248: p_commit => FND_API.G_FALSE,
3249: p_article_version_id => rec.article_version_id,
3250: p_new_article_title => NULL,
3251: p_create_standard_yn => 'N',
3252: x_article_version_id => l_article_version_id,

Line 3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3256: x_msg_count => l_msg_count,
3257: x_msg_data => l_msg_data);
3258:
3259: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:

Line 3262: RAISE FND_API.G_EXC_ERROR;

3258:
3259: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3260: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3261: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3262: RAISE FND_API.G_EXC_ERROR;
3263: END IF;
3264:
3265: IF (l_debug = 'Y') THEN
3266: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);

Line 3292: WHEN FND_API.G_EXC_ERROR THEN

3288: RETURN( G_RET_STS_SUCCESS );
3289:
3290: EXCEPTION
3291:
3292: WHEN FND_API.G_EXC_ERROR THEN
3293: IF (l_debug = 'Y') THEN
3294: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3295: END IF;
3296:

Line 3294: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);

3290: EXCEPTION
3291:
3292: WHEN FND_API.G_EXC_ERROR THEN
3293: IF (l_debug = 'Y') THEN
3294: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3295: END IF;
3296:
3297: IF (non_std_csr%ISOPEN) THEN
3298: CLOSE non_std_csr;

Line 3302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3298: CLOSE non_std_csr;
3299: END IF;
3300: RETURN G_RET_STS_ERROR;
3301:
3302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3303: IF (l_debug = 'Y') THEN
3304: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3305: END IF;
3306:

Line 3304: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

3300: RETURN G_RET_STS_ERROR;
3301:
3302: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3303: IF (l_debug = 'Y') THEN
3304: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3305: END IF;
3306:
3307: IF (non_std_csr%ISOPEN) THEN
3308: CLOSE non_std_csr;