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_ADOPTIONS_PVT dependencies on FND_API

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

32:
33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

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

33: ------------------------------------------------------------------------------
34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:

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

34: -- GLOBAL CONSTANTS
35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

35: ------------------------------------------------------------------------------
36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

36: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
37: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

Line 42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

38: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

Line 43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

39: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

Line 44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

40: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
41:
42: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
43: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
44: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
45:
46: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
47: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
48: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

271: x_last_update_date => l_last_update_date
272: );
273: ELSE
274: OKC_API.SET_MESSAGE(G_APP_NAME,'OKC_ART_ADP_NOT_FOUND');
275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: --- If any errors happen abort API
278: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

Line 279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

275: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
276: END IF;
277: --- If any errors happen abort API
278: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:

Line 281: RAISE FND_API.G_EXC_ERROR;

277: --- If any errors happen abort API
278: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
279: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
280: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
281: RAISE FND_API.G_EXC_ERROR;
282: END IF;
283:
284: --- Reversing G_MISS/NULL values logic
285:

Line 304: WHEN FND_API.G_EXC_ERROR THEN

300: END IF;
301:
302: RETURN G_RET_STS_SUCCESS ;
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: IF (l_debug = 'Y') THEN
306: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
307: END IF;
308: RETURN G_RET_STS_ERROR;

Line 306: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);

302: RETURN G_RET_STS_SUCCESS ;
303: EXCEPTION
304: WHEN FND_API.G_EXC_ERROR THEN
305: IF (l_debug = 'Y') THEN
306: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
307: END IF;
308: RETURN G_RET_STS_ERROR;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

306: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
307: END IF;
308: RETURN G_RET_STS_ERROR;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: IF (l_debug = 'Y') THEN
312: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
313: END IF;
314: RETURN G_RET_STS_UNEXP_ERROR;

Line 312: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

308: RETURN G_RET_STS_ERROR;
309:
310: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
311: IF (l_debug = 'Y') THEN
312: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
313: END IF;
314: RETURN G_RET_STS_UNEXP_ERROR;
315:
316: WHEN OTHERS THEN

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

330: ----------------------------------------------
331: -- Validate_Attributes for: OKC_ARTICLE_ADOPTIONS --
332: ----------------------------------------------
333: FUNCTION Validate_Attributes (
334: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
335:
336: p_global_article_version_id IN NUMBER,
337: p_adoption_type IN VARCHAR2,
338: p_local_org_id IN NUMBER,

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

545: ------------------------------------------
546: -- Validate_Record for:OKC_ARTICLE_ADOPTIONS --
547: ------------------------------------------
548: FUNCTION Validate_Record (
549: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
550:
551: p_global_article_version_id IN NUMBER,
552: p_adoption_type IN VARCHAR2,
553: p_local_org_id IN NUMBER,

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

616: ---------------------------------------
617: -- validate_row for:OKC_ARTICLE_ADOPTIONS --
618: ---------------------------------------
619: PROCEDURE validate_row(
620: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
621:
622: x_return_status OUT NOCOPY VARCHAR2,
623:
624: p_global_article_version_id IN NUMBER,

Line 662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

658: x_adoption_type => l_adoption_type,
659: x_adoption_status => l_adoption_status
660: );
661: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:

Line 664: RAISE FND_API.G_EXC_ERROR;

660: );
661: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
662: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
663: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
664: RAISE FND_API.G_EXC_ERROR;
665: END IF;
666:
667: -- Validate all non-missing attributes (Item Level Validation)
668: x_return_status := Validate_Record(

Line 682: WHEN FND_API.G_EXC_ERROR THEN

678: Okc_Debug.Log('3200: Leaving validate_row', 2);
679: END IF;
680:
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN
683: IF (l_debug = 'Y') THEN
684: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
685: END IF;
686: x_return_status := G_RET_STS_ERROR;

Line 684: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);

680:
681: EXCEPTION
682: WHEN FND_API.G_EXC_ERROR THEN
683: IF (l_debug = 'Y') THEN
684: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
685: END IF;
686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

684: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
685: END IF;
686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: IF (l_debug = 'Y') THEN
690: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
691: END IF;
692: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 690: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

686: x_return_status := G_RET_STS_ERROR;
687:
688: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
689: IF (l_debug = 'Y') THEN
690: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
691: END IF;
692: x_return_status := G_RET_STS_UNEXP_ERROR;
693:
694: WHEN OTHERS THEN

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

785: -------------------------------------
786: -- Insert_Row for:OKC_ARTICLE_ADOPTIONS --
787: -------------------------------------
788: PROCEDURE Insert_Row(
789: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
790: x_return_status OUT NOCOPY VARCHAR2,
791:
792: p_global_article_version_id IN NUMBER,
793: p_adoption_type IN VARCHAR2,

Line 824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

820: --- Setting item attributes
821: -- Set primary key value
822: IF( p_global_article_version_id IS NULL OR p_local_org_id IS NULL) THEN
823: x_return_status := G_RET_STS_UNEXP_ERROR;
824: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
825: ELSE
826: x_global_article_version_id := p_global_article_version_id;
827: x_local_org_id := p_local_org_id;
828: x_local_article_version_id := p_local_article_version_id;

Line 850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

846: p_adoption_status => p_adoption_status
847: );
848: --- If any errors happen abort API
849: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:

Line 852: RAISE FND_API.G_EXC_ERROR;

848: --- If any errors happen abort API
849: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
850: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
851: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
852: RAISE FND_API.G_EXC_ERROR;
853: END IF;
854:
855: --------------------------------------------
856: -- Call the internal Insert_Row for each child record

Line 876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

872: p_last_update_login => l_last_update_login,
873: p_last_update_date => l_last_update_date
874: );
875: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:

Line 878: RAISE FND_API.G_EXC_ERROR;

874: );
875: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
876: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
877: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
878: RAISE FND_API.G_EXC_ERROR;
879: END IF;
880:
881:
882:

Line 888: WHEN FND_API.G_EXC_ERROR THEN

884: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
885: END IF;
886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: IF (l_debug = 'Y') THEN
890: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
891: END IF;
892: x_return_status := G_RET_STS_ERROR;

Line 890: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);

886:
887: EXCEPTION
888: WHEN FND_API.G_EXC_ERROR THEN
889: IF (l_debug = 'Y') THEN
890: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
891: END IF;
892: x_return_status := G_RET_STS_ERROR;
893:
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

890: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
891: END IF;
892: x_return_status := G_RET_STS_ERROR;
893:
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF (l_debug = 'Y') THEN
896: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
897: END IF;
898: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 896: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

892: x_return_status := G_RET_STS_ERROR;
893:
894: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
895: IF (l_debug = 'Y') THEN
896: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
897: END IF;
898: x_return_status := G_RET_STS_UNEXP_ERROR;
899:
900: WHEN OTHERS THEN

Line 1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1111: p_local_article_version_id => p_local_article_version_id,
1112: p_object_version_number => p_object_version_number
1113: );
1114: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119:

Line 1117: RAISE FND_API.G_EXC_ERROR;

1113: );
1114: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1115: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1116: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1117: RAISE FND_API.G_EXC_ERROR;
1118: END IF;
1119:
1120:
1121:

Line 1127: WHEN FND_API.G_EXC_ERROR THEN

1123: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1124: END IF;
1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: IF (l_debug = 'Y') THEN
1129: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1130: END IF;
1131: x_return_status := G_RET_STS_ERROR;

Line 1129: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);

1125:
1126: EXCEPTION
1127: WHEN FND_API.G_EXC_ERROR THEN
1128: IF (l_debug = 'Y') THEN
1129: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1130: END IF;
1131: x_return_status := G_RET_STS_ERROR;
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1129: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1130: END IF;
1131: x_return_status := G_RET_STS_ERROR;
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: IF (l_debug = 'Y') THEN
1135: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1136: END IF;
1137: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1135: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1131: x_return_status := G_RET_STS_ERROR;
1132:
1133: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1134: IF (l_debug = 'Y') THEN
1135: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1136: END IF;
1137: x_return_status := G_RET_STS_UNEXP_ERROR;
1138:
1139: WHEN OTHERS THEN

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

1229: -------------------------------------
1230: -- Update_Row for:OKC_ARTICLE_ADOPTIONS --
1231: -------------------------------------
1232: PROCEDURE Update_Row(
1233: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1234:
1235: x_return_status OUT NOCOPY VARCHAR2,
1236:
1237: p_global_article_version_id IN NUMBER,

Line 1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1270: p_local_article_version_id => p_orig_local_version_id,
1271: p_object_version_number => p_object_version_number
1272: );
1273: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:

Line 1276: RAISE FND_API.G_EXC_ERROR;

1272: );
1273: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1274: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1275: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1276: RAISE FND_API.G_EXC_ERROR;
1277: END IF;
1278:
1279: IF (l_debug = 'Y') THEN
1280: Okc_Debug.Log('7300: Setting attributes', 2);

Line 1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1290: x_adoption_type => l_adoption_type,
1291: x_adoption_status => l_adoption_status
1292: );
1293: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:

Line 1296: RAISE FND_API.G_EXC_ERROR;

1292: );
1293: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1294: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1295: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1296: RAISE FND_API.G_EXC_ERROR;
1297: END IF;
1298:
1299:
1300: IF (l_debug = 'Y') THEN

Line 1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1311: p_adoption_status => l_adoption_status
1312: );
1313: --- If any errors happen abort API
1314: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:

Line 1317: RAISE FND_API.G_EXC_ERROR;

1313: --- If any errors happen abort API
1314: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1315: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1316: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1317: RAISE FND_API.G_EXC_ERROR;
1318: END IF;
1319:
1320: IF (l_debug = 'Y') THEN
1321: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1352: p_last_update_login => l_last_update_login,
1353: p_last_update_date => l_last_update_date
1354: );
1355: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;
1360:

Line 1358: RAISE FND_API.G_EXC_ERROR;

1354: );
1355: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1356: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1357: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1358: RAISE FND_API.G_EXC_ERROR;
1359: END IF;
1360:
1361:
1362: IF (l_debug = 'Y') THEN

Line 1367: WHEN FND_API.G_EXC_ERROR THEN

1363: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: IF (l_debug = 'Y') THEN
1369: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;
1371: x_return_status := G_RET_STS_ERROR;

Line 1369: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);

1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: IF (l_debug = 'Y') THEN
1369: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;
1371: x_return_status := G_RET_STS_ERROR;
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1369: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;
1371: x_return_status := G_RET_STS_ERROR;
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: IF (l_debug = 'Y') THEN
1375: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1376: END IF;
1377: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1375: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1371: x_return_status := G_RET_STS_ERROR;
1372:
1373: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1374: IF (l_debug = 'Y') THEN
1375: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1376: END IF;
1377: x_return_status := G_RET_STS_UNEXP_ERROR;
1378:
1379: WHEN OTHERS THEN

Line 1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1459: p_local_article_version_id => p_local_article_version_id,
1460: p_object_version_number => p_object_version_number
1461: );
1462: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:

Line 1465: RAISE FND_API.G_EXC_ERROR;

1461: );
1462: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1464: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1465: RAISE FND_API.G_EXC_ERROR;
1466: END IF;
1467:
1468:
1469: IF (l_debug = 'Y') THEN

Line 1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1470: Okc_Debug.Log('9100: Removing _B row', 2);
1471: END IF;
1472: x_return_status := Delete_Row( p_global_article_version_id => p_global_article_version_id,p_local_org_id => p_local_org_id,p_local_article_version_id => p_local_article_version_id );
1473: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:

Line 1476: RAISE FND_API.G_EXC_ERROR;

1472: x_return_status := Delete_Row( p_global_article_version_id => p_global_article_version_id,p_local_org_id => p_local_org_id,p_local_article_version_id => p_local_article_version_id );
1473: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479:
1480: IF (l_debug = 'Y') THEN

Line 1485: WHEN FND_API.G_EXC_ERROR THEN

1481: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1482: END IF;
1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: IF (l_debug = 'Y') THEN
1487: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1488: END IF;
1489: x_return_status := G_RET_STS_ERROR;

Line 1487: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);

1483:
1484: EXCEPTION
1485: WHEN FND_API.G_EXC_ERROR THEN
1486: IF (l_debug = 'Y') THEN
1487: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1488: END IF;
1489: x_return_status := G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1487: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1488: END IF;
1489: x_return_status := G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: IF (l_debug = 'Y') THEN
1493: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1494: END IF;
1495: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1493: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1489: x_return_status := G_RET_STS_ERROR;
1490:
1491: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1492: IF (l_debug = 'Y') THEN
1493: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1494: END IF;
1495: x_return_status := G_RET_STS_UNEXP_ERROR;
1496:
1497: WHEN OTHERS THEN