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 FND_API

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

15:
16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
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;

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

16: ------------------------------------------------------------------------------
17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
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;

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

17: -- GLOBAL CONSTANTS
18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
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;

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

18: ------------------------------------------------------------------------------
19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
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:

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

19: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
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;

Line 27: G_RET_STS_SUCCESS CONSTANT varchar2(1) := FND_API.G_RET_STS_SUCCESS;

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;
30:
31: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';

Line 28: G_RET_STS_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_ERROR;

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;
30:
31: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
32: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';

Line 29: G_RET_STS_UNEXP_ERROR CONSTANT varchar2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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;
30:
31: G_UNEXPECTED_ERROR CONSTANT varchar2(200) := 'OKC_UNEXPECTED_ERROR';
32: G_SQLERRM_TOKEN CONSTANT varchar2(200) := 'ERROR_MESSAGE';
33: G_SQLCODE_TOKEN CONSTANT varchar2(200) := 'ERROR_CODE';

Line 75: x_return_status := FND_API.G_RET_STS_SUCCESS;

71: BEGIN
72: IF (l_debug = 'Y') THEN
73: okc_debug.log('500: Entering update adoption if exists ', 2);
74: END IF;
75: x_return_status := FND_API.G_RET_STS_SUCCESS;
76:
77: OPEN l_article_adoption_csr(p_article_version_id,
78: p_org_id) ;
79: FETCH l_article_adoption_csr INTO l_rowid;

Line 184: x_return_status := FND_API.G_RET_STS_SUCCESS;

180: BEGIN
181: IF (l_debug = 'Y') THEN
182: okc_debug.log('500: Entering update prev vers end date ', 2);
183: END IF;
184: x_return_status := FND_API.G_RET_STS_SUCCESS;
185: OPEN l_earlier_version_csr(p_article_id, p_article_version_id);
186: FETCH l_earlier_version_csr INTO l_earlier_version_rec ;
187: IF l_earlier_version_csr%FOUND THEN
188: OKC_ARTICLE_VERSIONS_PVT.Update_Row(

Line 189: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

185: OPEN l_earlier_version_csr(p_article_id, p_article_version_id);
186: FETCH l_earlier_version_csr INTO l_earlier_version_rec ;
187: IF l_earlier_version_csr%FOUND THEN
188: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
189: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
190: x_return_status => x_return_status,
191: p_article_version_id => l_earlier_version_rec.article_version_id,
192: p_article_id => NULL,
193: p_article_version_number => NULL,

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

272:
273: PROCEDURE hold_unhold(
274: p_api_version IN NUMBER,
275: p_init_msg_list IN VARCHAR2 ,
276: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
277:
278: x_return_status OUT NOCOPY VARCHAR2,
279: x_msg_count OUT NOCOPY NUMBER,
280: x_msg_data OUT NOCOPY VARCHAR2,

Line 306: IF FND_API.to_Boolean( p_init_msg_list ) THEN

302: IF (l_debug = 'Y') THEN
303: okc_debug.log('100: Entered hold_unhold with '||p_hold_yn||'*'||p_article_version_id, 2);
304: END IF;
305:
306: IF FND_API.to_Boolean( p_init_msg_list ) THEN
307: FND_MSG_PUB.initialize;
308: END IF;
309: -- MOAC
310: G_CURRENT_ORG_ID := mo_global.get_current_org_id();

Line 325: RAISE FND_API.G_EXC_ERROR ;

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:
328: OPEN l_article_version_csr (p_article_version_id);
329: FETCH l_article_version_csr INTO l_article_version_rec;

Line 427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

423: END IF;
424: CLOSE l_article_version_csr;
425: --------------------------------------------
426: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
428: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
429: RAISE FND_API.G_EXC_ERROR ;
430: END IF;
431: --------------------------------------------

Line 429: RAISE FND_API.G_EXC_ERROR ;

425: --------------------------------------------
426: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
427: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
428: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
429: RAISE FND_API.G_EXC_ERROR ;
430: END IF;
431: --------------------------------------------
432: COMMIT;
433: IF (l_debug = 'Y') THEN

Line 439: WHEN FND_API.G_EXC_ERROR THEN

435: END IF;
436: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_encoded=> 'F', p_data => x_msg_data );
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 ;

Line 446: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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:
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 ;

Line 609: x_return_status := FND_API.G_RET_STS_SUCCESS;

605: IF (l_debug = 'Y') THEN
606: okc_debug.log('100: Entered pending approval with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
607: END IF;
608: -- Initialize API return status to success
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:
611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
612: FND_MSG_PUB.initialize;
613: END IF;

Line 611: IF FND_API.to_Boolean( p_init_msg_list ) THEN

607: END IF;
608: -- Initialize API return status to success
609: x_return_status := FND_API.G_RET_STS_SUCCESS;
610:
611: IF FND_API.to_Boolean( p_init_msg_list ) THEN
612: FND_MSG_PUB.initialize;
613: END IF;
614:
615:

Line 633: RAISE FND_API.G_EXC_ERROR ;

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
633: RAISE FND_API.G_EXC_ERROR ;
634: end if;
635:
636: -- Check for Default Section Effectivity
637: IF l_default_section IS NOT NULL THEN

Line 652: RAISE FND_API.G_EXC_ERROR ;

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 ;
653: end if;
654:
655: -- Above Added for Bug 3737158
656:

Line 747: RAISE FND_API.G_EXC_ERROR ;

743:
744: END LOOP;
745: l_variable_tbl.DELETE;
746: if x_return_status = G_RET_STS_ERROR then
747: RAISE FND_API.G_EXC_ERROR ;
748: end if;
749:
750: END IF;
751: END IF;

Line 762: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

758: IF (l_debug = 'Y') THEN
759: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
760: END IF;
761: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
762: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
763: x_return_status => x_return_status,
764: p_article_version_id => p_article_version_id,
765: p_article_id => NULL,
766: p_article_version_number => NULL,

Line 827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

823:
824: OKC_ADOPTIONS_GRP.check_adoption_details(
825: p_api_version => p_api_version,
826: p_init_msg_list => p_init_msg_list,
827: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
828: x_return_status => x_return_status,
829: x_msg_count => x_msg_count,
830: x_msg_data => x_msg_data,
831: x_earlier_local_version_id => l_earlier_local_version_id,

Line 837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

833: p_adoption_type => 'ADOPTED',
834: p_local_org_id => p_current_org_id);
835:
836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
839: RAISE FND_API.G_EXC_ERROR ;
840: END IF;
841:

Line 839: RAISE FND_API.G_EXC_ERROR ;

835:
836: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
837: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
838: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
839: RAISE FND_API.G_EXC_ERROR ;
840: END IF;
841:
842: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
843: x_return_status => x_return_status,

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

849: p_adoption_status => 'PENDING_APPROVAL',
850: p_object_version_number => NULL
851: );
852: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
854: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
855: RAISE FND_API.G_EXC_ERROR ;
856: END IF;
857:

Line 855: RAISE FND_API.G_EXC_ERROR ;

851: );
852: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
854: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
855: RAISE FND_API.G_EXC_ERROR ;
856: END IF;
857:
858: INSERT INTO OKC_ARTICLE_RELATNS_ALL
859: (

Line 950: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

946: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
947: END IF;
948:
949: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
950: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
951: x_return_status => x_return_status,
952: p_article_version_id => p_article_version_id,
953: p_article_id => NULL,
954: p_article_version_number => NULL,

Line 1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

998: x_earlier_version_id => l_earlier_version_id
999: );
1000: --------------------------------------------
1001: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1003: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1004: RAISE FND_API.G_EXC_ERROR ;
1005: END IF;
1006: --------------------------------------------

Line 1004: RAISE FND_API.G_EXC_ERROR ;

1000: --------------------------------------------
1001: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1002: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1003: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1004: RAISE FND_API.G_EXC_ERROR ;
1005: END IF;
1006: --------------------------------------------
1007: -- check if the local article being approved is created as a localizaion from
1008: -- a global article. In that case update the adoption row.

Line 1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1015:
1016: END IF;
1017: END IF;
1018: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1020: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR ;
1022: END IF;
1023:

Line 1021: RAISE FND_API.G_EXC_ERROR ;

1017: END IF;
1018: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1019: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1020: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1021: RAISE FND_API.G_EXC_ERROR ;
1022: END IF;
1023:
1024: IF (l_debug = 'Y') THEN
1025: okc_debug.log('200: Leaving pending approval successfully', 2);

Line 1029: WHEN FND_API.G_EXC_ERROR THEN

1025: okc_debug.log('200: Leaving pending approval successfully', 2);
1026: END IF;
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 ;

Line 1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1083: okc_debug.log('100: Entered approved with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1084: END IF;
1085: x_return_status := G_RET_STS_SUCCESS;
1086:
1087: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1088: FND_MSG_PUB.initialize;
1089: END IF;
1090: OPEN l_article_version_csr (p_article_version_id);
1091: FETCH l_article_version_csr INTO l_article_version_rec;

Line 1109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1105: okc_debug.log('100: Entered approve of global article at a global org', 2);
1106: END IF;
1107:
1108: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1109: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1110: x_return_status => x_return_status,
1111: p_article_version_id => p_article_version_id,
1112: p_article_id => NULL,
1113: p_article_version_number => NULL,

Line 1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1157: x_earlier_version_id => l_earlier_version_id
1158: );
1159: --------------------------------------------
1160: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1162: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1163: RAISE FND_API.G_EXC_ERROR ;
1164: END IF;
1165: --------------------------------------------

Line 1163: RAISE FND_API.G_EXC_ERROR ;

1159: --------------------------------------------
1160: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1161: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1162: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1163: RAISE FND_API.G_EXC_ERROR ;
1164: END IF;
1165: --------------------------------------------
1166: -- Update the end date of the previous version as a second less than the current
1167: -- version unless there is an existing end date

Line 1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1172: p_current_org_id,
1173: x_return_status );
1174: --------------------------------------------
1175: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1177: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1178: RAISE FND_API.G_EXC_ERROR ;
1179: END IF;
1180: --------------------------------------------

Line 1178: RAISE FND_API.G_EXC_ERROR ;

1174: --------------------------------------------
1175: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1176: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1177: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1178: RAISE FND_API.G_EXC_ERROR ;
1179: END IF;
1180: --------------------------------------------
1181:
1182: -- If a global article is approved at a global org it will trigger

Line 1195: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1191: OKC_ADOPTIONS_GRP.AUTO_ADOPT_ARTICLES
1192: (
1193: p_api_version => 1.0,
1194: p_init_msg_list => p_init_msg_list,
1195: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1196: p_commit => FND_API.G_FALSE,
1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,
1199: x_msg_data => x_msg_data,

Line 1196: p_commit => FND_API.G_FALSE,

1192: (
1193: p_api_version => 1.0,
1194: p_init_msg_list => p_init_msg_list,
1195: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1196: p_commit => FND_API.G_FALSE,
1197: x_return_status => x_return_status,
1198: x_msg_count => x_msg_count,
1199: x_msg_data => x_msg_data,
1200: p_relationship_yn => 'Y',

Line 1236: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1232: okc_debug.log('100: Entered approve of local article at a local org', 2);
1233: END IF;
1234:
1235: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1236: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1237: x_return_status => x_return_status,
1238: p_article_version_id => p_article_version_id,
1239: p_article_id => NULL,
1240: p_article_version_number => NULL,

Line 1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1284: x_earlier_version_id => l_earlier_version_id
1285: );
1286: --------------------------------------------
1287: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1289: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: END IF;
1292: --------------------------------------------

Line 1290: RAISE FND_API.G_EXC_ERROR ;

1286: --------------------------------------------
1287: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1288: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1289: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1290: RAISE FND_API.G_EXC_ERROR ;
1291: END IF;
1292: --------------------------------------------
1293:
1294: -- Update the end date of the previous version as a second less than the current

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1300: p_current_org_id,
1301: x_return_status );
1302: --------------------------------------------
1303: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1305: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR ;
1307: END IF;
1308: --------------------------------------------

Line 1306: RAISE FND_API.G_EXC_ERROR ;

1302: --------------------------------------------
1303: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1305: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR ;
1307: END IF;
1308: --------------------------------------------
1309: -- check if the local article being approved is created as a localizaion from
1310: -- a global article. In that case update the adoption row.

Line 1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1315: 'APPROVED',
1316: x_return_status );
1317: --------------------------------------------
1318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1321: RAISE FND_API.G_EXC_ERROR ;
1322: END IF;
1323: --------------------------------------------

Line 1321: RAISE FND_API.G_EXC_ERROR ;

1317: --------------------------------------------
1318: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1319: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1320: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1321: RAISE FND_API.G_EXC_ERROR ;
1322: END IF;
1323: --------------------------------------------
1324:
1325: END IF;

Line 1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1323: --------------------------------------------
1324:
1325: END IF;
1326: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1328: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1329: RAISE FND_API.G_EXC_ERROR ;
1330: END IF;
1331:

Line 1329: RAISE FND_API.G_EXC_ERROR ;

1325: END IF;
1326: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1327: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1328: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1329: RAISE FND_API.G_EXC_ERROR ;
1330: END IF;
1331:
1332: IF (l_debug = 'Y') THEN
1333: okc_debug.log('200: Leaving approve successfully', 2);

Line 1337: WHEN FND_API.G_EXC_ERROR THEN

1333: okc_debug.log('200: Leaving approve successfully', 2);
1334: END IF;
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 ;

Line 1397: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1393: okc_debug.log('100: Entered reject with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1394: END IF;
1395: x_return_status := G_RET_STS_SUCCESS;
1396:
1397: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1398: FND_MSG_PUB.initialize;
1399: END IF;
1400: OPEN l_article_version_csr (p_article_version_id);
1401: FETCH l_article_version_csr INTO l_article_version_rec;

Line 1419: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1415: IF (l_debug = 'Y') THEN
1416: okc_debug.log('100: Entered reject of global article at a global org', 2);
1417: END IF;
1418: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1419: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1420: x_return_status => x_return_status,
1421: p_article_version_id => p_article_version_id,
1422: p_article_id => NULL,
1423: p_article_version_number => NULL,

Line 1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1467: x_earlier_version_id => l_earlier_version_id
1468: );
1469: --------------------------------------------
1470: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1472: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1473: RAISE FND_API.G_EXC_ERROR ;
1474: END IF;
1475: --------------------------------------------

Line 1473: RAISE FND_API.G_EXC_ERROR ;

1469: --------------------------------------------
1470: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1471: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1472: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1473: RAISE FND_API.G_EXC_ERROR ;
1474: END IF;
1475: --------------------------------------------
1476: ELSIF (l_article_version_rec.org_id = G_GLOBAL_ORG_ID ) THEN
1477:

Line 1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1494: p_object_version_number => NULL
1495: );
1496: --------------------------------------------
1497: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1499: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1500: RAISE FND_API.G_EXC_ERROR ;
1501: END IF;
1502: --------------------------------------------

Line 1500: RAISE FND_API.G_EXC_ERROR ;

1496: --------------------------------------------
1497: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1498: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1499: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1500: RAISE FND_API.G_EXC_ERROR ;
1501: END IF;
1502: --------------------------------------------
1503: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1504: WHERE source_article_id = l_article_version_rec.article_id

Line 1534: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1530: okc_debug.log('100: Entered reject of local article at a local org', 2);
1531: END IF;
1532:
1533: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1534: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1535: x_return_status => x_return_status,
1536: p_article_version_id => p_article_version_id,
1537: p_article_id => NULL,
1538: p_article_version_number => NULL,

Line 1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1582: x_earlier_version_id => l_earlier_version_id
1583: );
1584: --------------------------------------------
1585: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1587: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1588: RAISE FND_API.G_EXC_ERROR ;
1589: END IF;
1590: --------------------------------------------

Line 1588: RAISE FND_API.G_EXC_ERROR ;

1584: --------------------------------------------
1585: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1586: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1587: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1588: RAISE FND_API.G_EXC_ERROR ;
1589: END IF;
1590: --------------------------------------------
1591:
1592: -- check if the local article being rejected is created as a localizaion from

Line 1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1598: 'REJECTED',
1599: x_return_status );
1600: --------------------------------------------
1601: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1603: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1604: RAISE FND_API.G_EXC_ERROR ;
1605: END IF;
1606:

Line 1604: RAISE FND_API.G_EXC_ERROR ;

1600: --------------------------------------------
1601: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1602: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1603: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1604: RAISE FND_API.G_EXC_ERROR ;
1605: END IF;
1606:
1607: END IF;
1608: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1605: END IF;
1606:
1607: END IF;
1608: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1610: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1611: RAISE FND_API.G_EXC_ERROR ;
1612: END IF;
1613:

Line 1611: RAISE FND_API.G_EXC_ERROR ;

1607: END IF;
1608: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1609: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1610: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1611: RAISE FND_API.G_EXC_ERROR ;
1612: END IF;
1613:
1614: IF (l_debug = 'Y') THEN
1615: okc_debug.log('200: Leaving check adoption', 2);

Line 1619: WHEN FND_API.G_EXC_ERROR THEN

1615: okc_debug.log('200: Leaving check adoption', 2);
1616: END IF;
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 ;