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

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

Line 308: IF FND_API.to_Boolean( p_init_msg_list ) THEN

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

Line 327: RAISE FND_API.G_EXC_ERROR ;

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

Line 429: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 431: RAISE FND_API.G_EXC_ERROR ;

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

Line 441: WHEN FND_API.G_EXC_ERROR THEN

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

Line 448: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

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

Line 621: x_return_status := FND_API.G_RET_STS_SUCCESS;

617: IF (l_debug = 'Y') THEN
618: okc_debug.log('100: Entered pending approval with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
619: END IF;
620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: IF FND_API.to_Boolean( p_init_msg_list ) THEN
624: FND_MSG_PUB.initialize;
625: END IF;

Line 623: IF FND_API.to_Boolean( p_init_msg_list ) THEN

619: END IF;
620: -- Initialize API return status to success
621: x_return_status := FND_API.G_RET_STS_SUCCESS;
622:
623: IF FND_API.to_Boolean( p_init_msg_list ) THEN
624: FND_MSG_PUB.initialize;
625: END IF;
626:
627:

Line 645: RAISE FND_API.G_EXC_ERROR ;

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
645: RAISE FND_API.G_EXC_ERROR ;
646: end if;
647:
648: -- Check for Default Section Effectivity
649: IF l_default_section IS NOT NULL THEN

Line 664: RAISE FND_API.G_EXC_ERROR ;

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 ;
665: end if;
666:
667: -- Above Added for Bug 3737158
668:

Line 761: RAISE FND_API.G_EXC_ERROR ;

757:
758: END LOOP;
759: l_variable_tbl.DELETE;
760: if x_return_status = G_RET_STS_ERROR then
761: RAISE FND_API.G_EXC_ERROR ;
762: end if;
763:
764: END IF;
765: END IF;

Line 776: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

772: IF (l_debug = 'Y') THEN
773: okc_debug.log('100: Entered pending approval for global article at a global org', 2);
774: END IF;
775: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
776: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
777: x_return_status => x_return_status,
778: p_article_version_id => p_article_version_id,
779: p_article_id => NULL,
780: p_article_version_number => NULL,

Line 843: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

839:
840: OKC_ADOPTIONS_GRP.check_adoption_details(
841: p_api_version => p_api_version,
842: p_init_msg_list => p_init_msg_list,
843: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
844: x_return_status => x_return_status,
845: x_msg_count => x_msg_count,
846: x_msg_data => x_msg_data,
847: x_earlier_local_version_id => l_earlier_local_version_id,

Line 853: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

849: p_adoption_type => 'ADOPTED',
850: p_local_org_id => p_current_org_id);
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: OKC_ARTICLE_ADOPTIONS_PVT.update_row(
859: x_return_status => x_return_status,

Line 869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

865: p_adoption_status => 'PENDING_APPROVAL',
866: p_object_version_number => NULL
867: );
868: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
870: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
871: RAISE FND_API.G_EXC_ERROR ;
872: END IF;
873:

Line 871: RAISE FND_API.G_EXC_ERROR ;

867: );
868: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
869: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
870: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
871: RAISE FND_API.G_EXC_ERROR ;
872: END IF;
873:
874: INSERT INTO OKC_ARTICLE_RELATNS_ALL
875: (

Line 966: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

962: okc_debug.log('100: Entered pending approval for local article at a local org ', 2);
963: END IF;
964:
965: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
966: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
967: x_return_status => x_return_status,
968: p_article_version_id => p_article_version_id,
969: p_article_id => NULL,
970: p_article_version_number => NULL,

Line 1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 1022: RAISE FND_API.G_EXC_ERROR ;

1018: --------------------------------------------
1019: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1021: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1022: RAISE FND_API.G_EXC_ERROR ;
1023: END IF;
1024: --------------------------------------------
1025: -- check if the local article being approved is created as a localizaion from
1026: -- a global article. In that case update the adoption row.

Line 1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1033:
1034: END IF;
1035: END IF;
1036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1038: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1039: RAISE FND_API.G_EXC_ERROR ;
1040: END IF;
1041:

Line 1039: RAISE FND_API.G_EXC_ERROR ;

1035: END IF;
1036: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1037: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1038: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1039: RAISE FND_API.G_EXC_ERROR ;
1040: END IF;
1041:
1042: IF (l_debug = 'Y') THEN
1043: okc_debug.log('200: Leaving pending approval successfully', 2);

Line 1047: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1105: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1101: okc_debug.log('100: Entered approved with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1102: END IF;
1103: x_return_status := G_RET_STS_SUCCESS;
1104:
1105: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1106: FND_MSG_PUB.initialize;
1107: END IF;
1108: OPEN l_article_version_csr (p_article_version_id);
1109: FETCH l_article_version_csr INTO l_article_version_rec;

Line 1127: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1123: okc_debug.log('100: Entered approve of global article at a global org', 2);
1124: END IF;
1125:
1126: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1127: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1128: x_return_status => x_return_status,
1129: p_article_version_id => p_article_version_id,
1130: p_article_id => NULL,
1131: p_article_version_number => NULL,

Line 1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1177: x_earlier_version_id => l_earlier_version_id
1178: );
1179: --------------------------------------------
1180: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1182: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: END IF;
1185: --------------------------------------------

Line 1183: RAISE FND_API.G_EXC_ERROR ;

1179: --------------------------------------------
1180: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1181: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1182: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1183: RAISE FND_API.G_EXC_ERROR ;
1184: END IF;
1185: --------------------------------------------
1186: -- Update the end date of the previous version as a second less than the current
1187: -- version unless there is an existing end date

Line 1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1192: p_current_org_id,
1193: x_return_status );
1194: --------------------------------------------
1195: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1197: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1198: RAISE FND_API.G_EXC_ERROR ;
1199: END IF;
1200: --------------------------------------------

Line 1198: RAISE FND_API.G_EXC_ERROR ;

1194: --------------------------------------------
1195: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1196: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1197: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1198: RAISE FND_API.G_EXC_ERROR ;
1199: END IF;
1200: --------------------------------------------
1201:
1202: -- If a global article is approved at a global org it will trigger

Line 1215: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1211: OKC_ADOPTIONS_GRP.AUTO_ADOPT_ARTICLES
1212: (
1213: p_api_version => 1.0,
1214: p_init_msg_list => p_init_msg_list,
1215: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1216: p_commit => FND_API.G_FALSE,
1217: x_return_status => x_return_status,
1218: x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data,

Line 1216: p_commit => FND_API.G_FALSE,

1212: (
1213: p_api_version => 1.0,
1214: p_init_msg_list => p_init_msg_list,
1215: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1216: p_commit => FND_API.G_FALSE,
1217: x_return_status => x_return_status,
1218: x_msg_count => x_msg_count,
1219: x_msg_data => x_msg_data,
1220: p_relationship_yn => 'Y',

Line 1256: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1252: okc_debug.log('100: Entered approve of local article at a local org', 2);
1253: END IF;
1254:
1255: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1256: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1257: x_return_status => x_return_status,
1258: p_article_version_id => p_article_version_id,
1259: p_article_id => NULL,
1260: p_article_version_number => NULL,

Line 1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1306: x_earlier_version_id => l_earlier_version_id
1307: );
1308: --------------------------------------------
1309: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1311: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1312: RAISE FND_API.G_EXC_ERROR ;
1313: END IF;
1314: --------------------------------------------

Line 1312: RAISE FND_API.G_EXC_ERROR ;

1308: --------------------------------------------
1309: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1310: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1311: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1312: RAISE FND_API.G_EXC_ERROR ;
1313: END IF;
1314: --------------------------------------------
1315:
1316: -- Update the end date of the previous version as a second less than the current

Line 1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

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

Line 1328: RAISE FND_API.G_EXC_ERROR ;

1324: --------------------------------------------
1325: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1326: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1327: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1328: RAISE FND_API.G_EXC_ERROR ;
1329: END IF;
1330: --------------------------------------------
1331: -- check if the local article being approved is created as a localizaion from
1332: -- a global article. In that case update the adoption row.

Line 1341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1337: 'APPROVED',
1338: x_return_status );
1339: --------------------------------------------
1340: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1342: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1343: RAISE FND_API.G_EXC_ERROR ;
1344: END IF;
1345: --------------------------------------------

Line 1343: RAISE FND_API.G_EXC_ERROR ;

1339: --------------------------------------------
1340: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1341: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1342: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1343: RAISE FND_API.G_EXC_ERROR ;
1344: END IF;
1345: --------------------------------------------
1346:
1347: END IF;

Line 1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1345: --------------------------------------------
1346:
1347: END IF;
1348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:

Line 1351: RAISE FND_API.G_EXC_ERROR ;

1347: END IF;
1348: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1349: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1350: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1351: RAISE FND_API.G_EXC_ERROR ;
1352: END IF;
1353:
1354: IF (l_debug = 'Y') THEN
1355: okc_debug.log('200: Leaving approve successfully', 2);

Line 1359: WHEN FND_API.G_EXC_ERROR THEN

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

Line 1419: IF FND_API.to_Boolean( p_init_msg_list ) THEN

1415: okc_debug.log('100: Entered reject with '||p_current_org_id ||'*'||p_adopt_as_is_yn||'*'||p_article_version_id, 2);
1416: END IF;
1417: x_return_status := G_RET_STS_SUCCESS;
1418:
1419: IF FND_API.to_Boolean( p_init_msg_list ) THEN
1420: FND_MSG_PUB.initialize;
1421: END IF;
1422: OPEN l_article_version_csr (p_article_version_id);
1423: FETCH l_article_version_csr INTO l_article_version_rec;

Line 1441: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1437: IF (l_debug = 'Y') THEN
1438: okc_debug.log('100: Entered reject of global article at a global org', 2);
1439: END IF;
1440: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1441: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1442: x_return_status => x_return_status,
1443: p_article_version_id => p_article_version_id,
1444: p_article_id => NULL,
1445: p_article_version_number => NULL,

Line 1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1491: x_earlier_version_id => l_earlier_version_id
1492: );
1493: --------------------------------------------
1494: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1496: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1497: RAISE FND_API.G_EXC_ERROR ;
1498: END IF;
1499: --------------------------------------------

Line 1497: RAISE FND_API.G_EXC_ERROR ;

1493: --------------------------------------------
1494: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1495: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1496: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1497: RAISE FND_API.G_EXC_ERROR ;
1498: END IF;
1499: --------------------------------------------
1500: ELSIF (l_article_version_rec.org_id = G_GLOBAL_ORG_ID ) THEN
1501:

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1518: p_object_version_number => NULL
1519: );
1520: --------------------------------------------
1521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1524: RAISE FND_API.G_EXC_ERROR ;
1525: END IF;
1526: --------------------------------------------

Line 1524: RAISE FND_API.G_EXC_ERROR ;

1520: --------------------------------------------
1521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1524: RAISE FND_API.G_EXC_ERROR ;
1525: END IF;
1526: --------------------------------------------
1527: DELETE FROM OKC_ARTICLE_RELATNS_ALL
1528: WHERE source_article_id = l_article_version_rec.article_id

Line 1558: p_validation_level => FND_API.G_VALID_LEVEL_NONE,

1554: okc_debug.log('100: Entered reject of local article at a local org', 2);
1555: END IF;
1556:
1557: OKC_ARTICLE_VERSIONS_PVT.Update_Row(
1558: p_validation_level => FND_API.G_VALID_LEVEL_NONE,
1559: x_return_status => x_return_status,
1560: p_article_version_id => p_article_version_id,
1561: p_article_id => NULL,
1562: p_article_version_number => NULL,

Line 1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1608: x_earlier_version_id => l_earlier_version_id
1609: );
1610: --------------------------------------------
1611: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1613: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1614: RAISE FND_API.G_EXC_ERROR ;
1615: END IF;
1616: --------------------------------------------

Line 1614: RAISE FND_API.G_EXC_ERROR ;

1610: --------------------------------------------
1611: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1612: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1613: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1614: RAISE FND_API.G_EXC_ERROR ;
1615: END IF;
1616: --------------------------------------------
1617:
1618: -- check if the local article being rejected is created as a localizaion from

Line 1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1624: 'REJECTED',
1625: x_return_status );
1626: --------------------------------------------
1627: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1629: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1630: RAISE FND_API.G_EXC_ERROR ;
1631: END IF;
1632:

Line 1630: RAISE FND_API.G_EXC_ERROR ;

1626: --------------------------------------------
1627: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1628: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1629: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1630: RAISE FND_API.G_EXC_ERROR ;
1631: END IF;
1632:
1633: END IF;
1634: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN

Line 1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

1631: END IF;
1632:
1633: END IF;
1634: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1636: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1637: RAISE FND_API.G_EXC_ERROR ;
1638: END IF;
1639:

Line 1637: RAISE FND_API.G_EXC_ERROR ;

1633: END IF;
1634: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1635: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
1636: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1637: RAISE FND_API.G_EXC_ERROR ;
1638: END IF;
1639:
1640: IF (l_debug = 'Y') THEN
1641: okc_debug.log('200: Leaving check adoption', 2);

Line 1645: WHEN FND_API.G_EXC_ERROR THEN

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