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 255: Okc_Api.Set_Message(p_app_name => G_APP_NAME,

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

624:
625: OPEN l_article_lkup_csr (p_article_version_id);
626: FETCH l_article_lkup_csr INTO l_default_section, l_article_type;
627: IF l_article_lkup_csr%NOTFOUND THEN
628: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE,G_COL_NAME_TOKEN,'STD_ARTICLE_VERSION_ID');
629: x_return_status := G_RET_STS_ERROR;
630: END IF;
631: CLOSE l_article_lkup_csr;
632: if x_return_status = G_RET_STS_ERROR then

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

636: -- Check for Default Section Effectivity
637: IF l_default_section IS NOT NULL THEN
638: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_ARTICLE_SECTION',l_default_section);
639: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
640: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_SECTION');
641: x_return_status := G_RET_STS_ERROR;
642: END IF;
643: END IF;
644:

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

644:
645: -- Check for Article Type Effectivity
646: l_tmp_return_status := Okc_Util.Check_Lookup_Code('OKC_SUBJECT',l_article_type);
647: IF (l_tmp_return_status <> G_RET_STS_SUCCESS) THEN
648: Okc_Api.Set_Message(G_APP_NAME, 'OKC_ART_INVALID_TYPE');
649: x_return_status := G_RET_STS_ERROR;
650: END IF;
651: if x_return_status = G_RET_STS_ERROR then
652: RAISE FND_API.G_EXC_ERROR ;

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

671: CLOSE l_check_valid_var_csr;
672: IF l_variable_tbl.COUNT > 0 THEN
673: FOR i in l_variable_tbl.FIRST..l_variable_tbl.LAST LOOP
674: if l_disabled_yn_tbl(i) = 'Y' then
675: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
676: p_msg_name => 'OKC_ART_INACTV_VARBL',
677: p_token1 => 'VARIABLE_NAME',
678: p_token1_value => l_variable_tbl(i),
679: p_token2 => 'ARTICLE_TITLE',

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

687: FETCH l_check_valid_valueset_csr INTO l_dummy_char;
688: l_rownotfound := l_check_valid_valueset_csr%NOTFOUND;
689: CLOSE l_check_valid_valueset_csr;
690: if l_rownotfound then
691: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
692: p_msg_name => 'OKC_ART_INV_VALUESET',
693: p_token1 => 'VARIABLE_NAME',
694: p_token1_value => l_variable_tbl(i),
695: p_token2 => 'ARTICLE_TITLE',

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

712: FETCH csr_check_proc_exists INTO l_dummy;
713:
714: -- If Procedure Spec/Body status is INVALID then return error
715: IF l_procedure_spec_status = 'INVALID' OR l_procedure_body_status = 'INVALID' THEN
716: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
717: p_msg_name => 'OKC_XPRT_INV_PROCEDURE_VAR',
718: p_token1 => 'VARIABLE',
719: p_token1_value => l_variable_tbl(i),
720: p_token2 => 'PROCEDURE',

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

724:
725: -- If Procedure Spec/Body/API not found in DB then return error
726: IF csr_check_proc_spec_status%NOTFOUND OR csr_check_proc_body_status%NOTFOUND
727: OR csr_check_proc_exists%NOTFOUND THEN
728: Okc_Api.Set_Message(p_app_name => G_APP_NAME,
729: p_msg_name => 'OKC_XPRT_NO_PROCEDURE_VAR',
730: p_token1 => 'VARIABLE',
731: p_token1_value => l_variable_tbl(i),
732: p_token2 => 'PROCEDURE',

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

1027:
1028: EXCEPTION
1029: WHEN FND_API.G_EXC_ERROR THEN
1030: IF (l_debug = 'Y') THEN
1031: okc_debug.log('300: Leaving pending approval OKC_API.G_EXCEPTION_ERROR Exception', 2);
1032: END IF;
1033: x_return_status := G_RET_STS_ERROR ;
1034:
1035: WHEN OTHERS THEN

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

1091: FETCH l_article_version_csr INTO l_article_version_rec;
1092: l_rownotfound := l_article_version_csr%NOTFOUND;
1093: CLOSE l_article_version_csr;
1094: IF l_rownotfound THEN
1095: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1096: x_return_status := G_RET_STS_ERROR;
1097: return;
1098: END IF;
1099: -- Initialize API return status to success

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

1335:
1336: EXCEPTION
1337: WHEN FND_API.G_EXC_ERROR THEN
1338: IF (l_debug = 'Y') THEN
1339: okc_debug.log('300: Leaving approve because of OKC_API.G_EXCEPTION_ERROR Exception', 2);
1340: END IF;
1341: x_return_status := G_RET_STS_ERROR ;
1342:
1343: WHEN OTHERS THEN

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

1401: FETCH l_article_version_csr INTO l_article_version_rec;
1402: l_rownotfound := l_article_version_csr%NOTFOUND;
1403: CLOSE l_article_version_csr;
1404: IF l_rownotfound THEN
1405: Okc_Api.Set_Message(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'ARTICLE_VERSION_ID');
1406: x_return_status := G_RET_STS_ERROR;
1407: return;
1408: END IF;
1409: -- Initialize API return status to success

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

1617:
1618: EXCEPTION
1619: WHEN FND_API.G_EXC_ERROR THEN
1620: IF (l_debug = 'Y') THEN
1621: okc_debug.log('300: Leaving delete_Adoption: OKC_API.G_EXCEPTION_ERROR Exception', 2);
1622: END IF;
1623: x_return_status := G_RET_STS_ERROR ;
1624:
1625: WHEN OTHERS THEN