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_STATUS_CHANGE_PVT dependencies on OKC_API

Line 9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;

5:
6: ---------------------------------------------------------------------------
7: -- GLOBAL MESSAGE CONSTANTS
8: ---------------------------------------------------------------------------
9: G_FND_APP CONSTANT VARCHAR2(200) := OKC_API.G_FND_APP;
10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_STATUS_CHANGE_PVT';

Line 14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;

10: ---------------------------------------------------------------------------
11: -- GLOBAL VARIABLES
12: ---------------------------------------------------------------------------
13: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKC_ARTICLE_STATUS_CHANGE_PVT';
14: G_APP_NAME CONSTANT VARCHAR2(3) := OKC_API.G_APP_NAME;
15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------

Line 24: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;

20: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
25: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
26:
27: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
28: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

Line 25: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;

21: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
22: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
23: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
24: G_INVALID_VALUE CONSTANT VARCHAR2(200) := OKC_API.G_INVALID_VALUE;
25: G_COL_NAME_TOKEN CONSTANT VARCHAR2(200) := OKC_API.G_COL_NAME_TOKEN;
26:
27: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;
28: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;
29: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 102: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

98: IF l_article_adoption_csr%ISOPEN THEN
99: CLOSE l_article_adoption_csr;
100: END IF;
101: x_return_status := G_RET_STS_UNEXP_ERROR ;
102: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
103: p_msg_name => G_UNEXPECTED_ERROR,
104: p_token1 => G_SQLCODE_TOKEN,
105: p_token1_value => sqlcode,
106: p_token2 => G_SQLERRM_TOKEN,

Line 257: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

253: IF l_earlier_version_csr%ISOPEN THEN
254: CLOSE l_earlier_version_csr;
255: END IF;
256: x_return_status := G_RET_STS_UNEXP_ERROR ;
257: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
258: p_msg_name => G_UNEXPECTED_ERROR,
259: p_token1 => G_SQLCODE_TOKEN,
260: p_token1_value => sqlcode,
261: p_token2 => G_SQLERRM_TOKEN,

Line 325: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');

321: if G_CURRENT_ORG_ID IS NULL Then
322: IF (l_debug = 'Y') THEN
323: Okc_Debug.Log('130: - attribute G_CURRENT_ORG_ID is invalid', 2);
324: END IF;
325: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_NULL_ORG_ID');
326: x_return_status := G_RET_STS_ERROR;
327: RAISE FND_API.G_EXC_ERROR ;
328: end if;
329:

Line 334: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');

330: OPEN l_article_version_csr (p_article_version_id);
331: FETCH l_article_version_csr INTO l_article_version_rec;
332: l_rownotfound := l_article_version_csr%NOTFOUND;
333: IF l_rownotfound THEN
334: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
335: x_return_status := G_RET_STS_ERROR;
336: ELSIF p_hold_yn = 'Y' THEN
337: IF l_article_version_rec.article_status <> 'APPROVED' Then
338: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_APPROVD');

Line 338: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_APPROVD');

334: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
335: x_return_status := G_RET_STS_ERROR;
336: ELSIF p_hold_yn = 'Y' THEN
337: IF l_article_version_rec.article_status <> 'APPROVED' Then
338: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_APPROVD');
339: x_return_status := G_RET_STS_ERROR;
340: ELSIF l_article_version_rec.org_id <> G_CURRENT_ORG_ID Then
341: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');
342: x_return_status := G_RET_STS_ERROR;

Line 341: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');

337: IF l_article_version_rec.article_status <> 'APPROVED' Then
338: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_APPROVD');
339: x_return_status := G_RET_STS_ERROR;
340: ELSIF l_article_version_rec.org_id <> G_CURRENT_ORG_ID Then
341: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');
342: x_return_status := G_RET_STS_ERROR;
343: ELSE
344: l_new_article_status := 'ON_HOLD';
345: END IF;

Line 348: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_HOLD');

344: l_new_article_status := 'ON_HOLD';
345: END IF;
346: ELSE
347: IF l_article_version_rec.article_status <> 'ON_HOLD' Then
348: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_HOLD');
349: x_return_status := G_RET_STS_ERROR;
350: ELSIF l_article_version_rec.org_id <> G_CURRENT_ORG_ID Then
351: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');
352: x_return_status := G_RET_STS_ERROR;

Line 351: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');

347: IF l_article_version_rec.article_status <> 'ON_HOLD' Then
348: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_NOT_HOLD');
349: x_return_status := G_RET_STS_ERROR;
350: ELSIF l_article_version_rec.org_id <> G_CURRENT_ORG_ID Then
351: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_DIFF_ORG');
352: x_return_status := G_RET_STS_ERROR;
353: ELSE
354: l_new_article_status := 'APPROVED';
355: END IF;

Line 443: okc_debug.log('300: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_ERROR Exception', 2);

439:
440: EXCEPTION
441: WHEN FND_API.G_EXC_ERROR THEN
442: IF (l_debug = 'Y') THEN
443: okc_debug.log('300: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_ERROR Exception', 2);
444: END IF;
445: x_return_status := G_RET_STS_ERROR ;
446: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
447:

Line 450: okc_debug.log('400: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);

446: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
447:
448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
449: IF (l_debug = 'Y') THEN
450: okc_debug.log('400: Leaving Hold_Unhold: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception', 2);
451: END IF;
452: x_return_status := G_RET_STS_UNEXP_ERROR ;
453: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count,p_encoded=> 'F', p_data => x_msg_data );
454:

Line 640: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');

636:
637: OPEN l_article_lkup_csr (p_article_version_id);
638: FETCH l_article_lkup_csr INTO l_default_section, l_article_type;
639: IF l_article_lkup_csr%NOTFOUND THEN
640: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');
641: x_return_status := G_RET_STS_ERROR;
642: END IF;
643: CLOSE l_article_lkup_csr;
644: if x_return_status = G_RET_STS_ERROR then

Line 652: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');

648: -- Check for Default Section Effectivity
649: IF l_default_section IS NOT NULL THEN
650: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_SECTION',l_default_section);
651: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
652: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');
653: x_return_status := G_RET_STS_ERROR;
654: END IF;
655: END IF;
656:

Line 660: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');

656:
657: -- Check for Article Type Effectivity
658: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_SUBJECT',l_article_type);
659: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
660: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');
661: x_return_status := G_RET_STS_ERROR;
662: END IF;
663: if x_return_status = G_RET_STS_ERROR then
664: RAISE FND_API.G_EXC_ERROR ;

Line 689: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

685: CLOSE l_check_valid_var_csr;
686: IF l_variable_tbl.COUNT > 0 THEN
687: FOR i in l_variable_tbl.FIRST..l_variable_tbl.LAST LOOP
688: if l_disabled_yn_tbl(i) = 'Y' then
689: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
690: p_msg_name => 'OKC_ART_INACTV_VARBL',
691: p_token1 => 'VARIABLE_NAME',
692: p_token1_value => l_variable_tbl(i),
693: p_token2 => 'ARTICLE_TITLE',

Line 705: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

701: FETCH l_check_valid_valueset_csr INTO l_dummy_char;
702: l_rownotfound := l_check_valid_valueset_csr%NOTFOUND;
703: CLOSE l_check_valid_valueset_csr;
704: if l_rownotfound then
705: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
706: p_msg_name => 'OKC_ART_INV_VALUESET',
707: p_token1 => 'VARIABLE_NAME',
708: p_token1_value => l_variable_tbl(i),
709: p_token2 => 'ARTICLE_TITLE',

Line 730: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

726: FETCH csr_check_proc_exists INTO l_dummy;
727:
728: -- If Procedure Spec/Body status is INVALID then return error
729: IF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
730: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
731: p_msg_name => 'OKC_XPRT_INV_PROCEDURE_VAR',
732: p_token1 => 'VARIABLE',
733: p_token1_value => l_variable_tbl(i),
734: p_token2 => 'PROCEDURE',

Line 742: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

738:
739: -- If Procedure Spec/Body/API not found in DB then return error
740: IF csr_check_proc_spec_status%NOTFOUND OR csr_check_proc_body_status%NOTFOUND
741: OR csr_check_proc_exists%NOTFOUND THEN
742: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
743: p_msg_name => 'OKC_XPRT_NO_PROCEDURE_VAR',
744: p_token1 => 'VARIABLE',
745: p_token1_value => l_variable_tbl(i),
746: p_token2 => 'PROCEDURE',

Line 1049: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);

1045:
1046: EXCEPTION
1047: WHEN FND_API.G_EXC_ERROR THEN
1048: IF (l_debug = 'Y') THEN
1049: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);
1050: END IF;
1051: x_return_status := G_RET_STS_ERROR ;
1052:
1053: WHEN OTHERS THEN

Line 1113: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');

1109: FETCH l_article_version_csr INTO l_article_version_rec;
1110: l_rownotfound := l_article_version_csr%NOTFOUND;
1111: CLOSE l_article_version_csr;
1112: IF l_rownotfound THEN
1113: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1114: x_return_status := G_RET_STS_ERROR;
1115: return;
1116: END IF;
1117: -- Initialize API return status to success

Line 1361: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);

1357:
1358: EXCEPTION
1359: WHEN FND_API.G_EXC_ERROR THEN
1360: IF (l_debug = 'Y') THEN
1361: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);
1362: END IF;
1363: x_return_status := G_RET_STS_ERROR ;
1364:
1365: WHEN OTHERS THEN

Line 1427: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');

1423: FETCH l_article_version_csr INTO l_article_version_rec;
1424: l_rownotfound := l_article_version_csr%NOTFOUND;
1425: CLOSE l_article_version_csr;
1426: IF l_rownotfound THEN
1427: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1428: x_return_status := G_RET_STS_ERROR;
1429: return;
1430: END IF;
1431: -- Initialize API return status to success

Line 1647: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);

1643:
1644: EXCEPTION
1645: WHEN FND_API.G_EXC_ERROR THEN
1646: IF (l_debug = 'Y') THEN
1647: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1648: END IF;
1649: x_return_status := G_RET_STS_ERROR ;
1650:
1651: WHEN OTHERS THEN