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_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 829: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,

825: ----------------------------------------------
826: -- Validate_Attributes for: OKC_K_ARTICLES_B --
827: ----------------------------------------------
828: FUNCTION Validate_Attributes (
829: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
830:
831: p_id IN NUMBER,
832: p_sav_sae_id IN NUMBER,
833: p_document_type IN VARCHAR2,

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

2352: -------------------------------------
2353: -- Update_Row for:OKC_K_ARTICLES_B --
2354: -------------------------------------
2355: PROCEDURE Update_Row(
2356: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2357: x_return_status OUT NOCOPY VARCHAR2,
2358: p_id IN NUMBER,
2359: p_sav_sae_id IN NUMBER,
2360: p_document_type IN VARCHAR2,

Line 2826: p_init_msg_list => FND_API.G_FALSE,

2822: FETCH l_non_std_exists_csr INTO l_non_std_exists;
2823: IF l_non_std_exists_csr%NOTFOUND THEN
2824: OKC_ARTICLES_GRP.delete_article(
2825: p_api_version => 1,
2826: p_init_msg_list => FND_API.G_FALSE,
2827:
2828: x_return_status => l_return_status,
2829: x_msg_count => l_msg_count,
2830: x_msg_data => l_msg_data,

Line 2922: WHEN FND_API.G_EXC_ERROR THEN

2918: END IF;
2919: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2920: x_return_status := G_RET_STS_ERROR ;
2921:
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: IF (l_debug = 'Y') THEN
2924: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2925: END IF;
2926:

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

2920: x_return_status := G_RET_STS_ERROR ;
2921:
2922: WHEN FND_API.G_EXC_ERROR THEN
2923: IF (l_debug = 'Y') THEN
2924: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2925: END IF;
2926:
2927: IF (lock_csr%ISOPEN) THEN
2928: CLOSE lock_csr;

Line 2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2928: CLOSE lock_csr;
2929: END IF;
2930: x_return_status := G_RET_STS_ERROR;
2931:
2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2933: IF (l_debug = 'Y') THEN
2934: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2935: END IF;
2936:

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

2930: x_return_status := G_RET_STS_ERROR;
2931:
2932: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2933: IF (l_debug = 'Y') THEN
2934: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2935: END IF;
2936:
2937: IF (lock_csr%ISOPEN) THEN
2938: CLOSE lock_csr;

Line 3003: WHEN FND_API.G_EXC_ERROR THEN

2999: END IF;
3000: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
3001: x_return_status := G_RET_STS_ERROR ;
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: IF (l_debug = 'Y') THEN
3005: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3006: END IF;
3007:

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

3001: x_return_status := G_RET_STS_ERROR ;
3002:
3003: WHEN FND_API.G_EXC_ERROR THEN
3004: IF (l_debug = 'Y') THEN
3005: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
3006: END IF;
3007:
3008: IF (lock_csr%ISOPEN) THEN
3009: CLOSE lock_csr;

Line 3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3009: CLOSE lock_csr;
3010: END IF;
3011: x_return_status := G_RET_STS_ERROR;
3012:
3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: IF (l_debug = 'Y') THEN
3015: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3016: END IF;
3017:

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

3011: x_return_status := G_RET_STS_ERROR;
3012:
3013: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3014: IF (l_debug = 'Y') THEN
3015: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3016: END IF;
3017:
3018: IF (lock_csr%ISOPEN) THEN
3019: CLOSE lock_csr;

Line 3200: p_init_msg_list => FND_API.G_FALSE,

3196: IF (l_debug = 'Y') THEN
3197: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3198: END IF;
3199: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3202: p_commit => FND_API.G_FALSE,
3203: p_article_version_id => rec.article_version_id,
3204: p_new_article_title => NULL,

Line 3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

3197: Okc_Debug.Log('6920: Before calling OKC_ARTICLES_GRP.copy_article()', 2);
3198: END IF;
3199: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3202: p_commit => FND_API.G_FALSE,
3203: p_article_version_id => rec.article_version_id,
3204: p_new_article_title => NULL,
3205: p_create_standard_yn => 'N',

Line 3202: p_commit => FND_API.G_FALSE,

3198: END IF;
3199: OKC_ARTICLES_GRP.copy_article( p_api_version => 1,
3200: p_init_msg_list => FND_API.G_FALSE,
3201: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
3202: p_commit => FND_API.G_FALSE,
3203: p_article_version_id => rec.article_version_id,
3204: p_new_article_title => NULL,
3205: p_create_standard_yn => 'N',
3206: x_article_version_id => l_article_version_id,

Line 3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3210: x_msg_count => l_msg_count,
3211: x_msg_data => l_msg_data);
3212:
3213: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218:

Line 3216: RAISE FND_API.G_EXC_ERROR;

3212:
3213: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
3214: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3215: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
3216: RAISE FND_API.G_EXC_ERROR;
3217: END IF;
3218:
3219: IF (l_debug = 'Y') THEN
3220: Okc_Debug.Log('6920: Before updating new Non-Std in the OKC_K_ARTICLES_B', 2);

Line 3246: WHEN FND_API.G_EXC_ERROR THEN

3242: RETURN( G_RET_STS_SUCCESS );
3243:
3244: EXCEPTION
3245:
3246: WHEN FND_API.G_EXC_ERROR THEN
3247: IF (l_debug = 'Y') THEN
3248: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3249: END IF;
3250:

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

3244: EXCEPTION
3245:
3246: WHEN FND_API.G_EXC_ERROR THEN
3247: IF (l_debug = 'Y') THEN
3248: Okc_Debug.Log('7100: Leaving Create_Version:FND_API.G_EXC_ERROR Exception', 2);
3249: END IF;
3250:
3251: IF (non_std_csr%ISOPEN) THEN
3252: CLOSE non_std_csr;

Line 3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3252: CLOSE non_std_csr;
3253: END IF;
3254: RETURN G_RET_STS_ERROR;
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF (l_debug = 'Y') THEN
3258: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3259: END IF;
3260:

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

3254: RETURN G_RET_STS_ERROR;
3255:
3256: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3257: IF (l_debug = 'Y') THEN
3258: Okc_Debug.Log('7200: Leaving Create_Version:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
3259: END IF;
3260:
3261: IF (non_std_csr%ISOPEN) THEN
3262: CLOSE non_std_csr;