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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

308: x_last_update_date => l_last_update_date
309: );
310: --- If any errors happen abort API
311: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:

Line 314: RAISE FND_API.G_EXC_ERROR;

310: --- If any errors happen abort API
311: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
312: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
313: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
314: RAISE FND_API.G_EXC_ERROR;
315: END IF;
316:
317: --- Reversing G_MISS/NULL values logic
318:

Line 431: WHEN FND_API.G_EXC_ERROR THEN

427: END IF;
428:
429: RETURN G_RET_STS_SUCCESS ;
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: IF (l_debug = 'Y') THEN
433: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
434: END IF;
435: RETURN G_RET_STS_ERROR;

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

429: RETURN G_RET_STS_SUCCESS ;
430: EXCEPTION
431: WHEN FND_API.G_EXC_ERROR THEN
432: IF (l_debug = 'Y') THEN
433: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
434: END IF;
435: RETURN G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

433: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
434: END IF;
435: RETURN G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: IF (l_debug = 'Y') THEN
439: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
440: END IF;
441: RETURN G_RET_STS_UNEXP_ERROR;

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

435: RETURN G_RET_STS_ERROR;
436:
437: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
438: IF (l_debug = 'Y') THEN
439: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
440: END IF;
441: RETURN G_RET_STS_UNEXP_ERROR;
442:
443: WHEN OTHERS THEN

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

457: ----------------------------------------------
458: -- Validate_Attributes for: OKC_REVIEW_UPLD_TERMS --
459: ----------------------------------------------
460: FUNCTION Validate_Attributes (
461: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
462:
463: p_REVIEW_UPLD_TERMS_id IN NUMBER,
464: p_document_id IN NUMBER,
465: p_document_type IN VARCHAR2,

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

711: ------------------------------------------
712: -- Validate_Record for:OKC_REVIEW_UPLD_TERMS --
713: ------------------------------------------
714: FUNCTION Validate_Record (
715: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
716:
717: p_REVIEW_UPLD_TERMS_id IN NUMBER,
718: p_document_id IN NUMBER,
719: p_document_type IN VARCHAR2,

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

809: ---------------------------------------
810: -- validate_row for:OKC_REVIEW_UPLD_TERMS --
811: ---------------------------------------
812: PROCEDURE validate_row(
813: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
814:
815: x_return_status OUT NOCOPY VARCHAR2,
816:
817: p_REVIEW_UPLD_TERMS_id IN NUMBER,

Line 908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

904: x_new_parent_id => l_new_parent_id,
905: x_upload_level => l_upload_level
906: );
907: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:

Line 910: RAISE FND_API.G_EXC_ERROR;

906: );
907: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
908: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
909: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
910: RAISE FND_API.G_EXC_ERROR;
911: END IF;
912:
913: -- Validate all non-missing attributes (Item Level Validation)
914: l_object_version_number := p_object_version_number ;

Line 942: WHEN FND_API.G_EXC_ERROR THEN

938: Okc_Debug.Log('3200: Leaving validate_row', 2);
939: END IF;
940:
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: IF (l_debug = 'Y') THEN
944: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
945: END IF;
946: x_return_status := G_RET_STS_ERROR;

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

940:
941: EXCEPTION
942: WHEN FND_API.G_EXC_ERROR THEN
943: IF (l_debug = 'Y') THEN
944: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
945: END IF;
946: x_return_status := G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

944: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
945: END IF;
946: x_return_status := G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: IF (l_debug = 'Y') THEN
950: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
951: END IF;
952: x_return_status := G_RET_STS_UNEXP_ERROR;

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

946: x_return_status := G_RET_STS_ERROR;
947:
948: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
949: IF (l_debug = 'Y') THEN
950: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
951: END IF;
952: x_return_status := G_RET_STS_UNEXP_ERROR;
953:
954: WHEN OTHERS THEN

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

1084: -------------------------------------
1085: -- Insert_Row for:OKC_REVIEW_UPLD_TERMS --
1086: -------------------------------------
1087: PROCEDURE Insert_Row(
1088: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1089: x_return_status OUT NOCOPY VARCHAR2,
1090:
1091: p_REVIEW_UPLD_TERMS_id IN NUMBER,
1092: p_document_id IN NUMBER,

Line 1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1133: x_REVIEW_UPLD_TERMS_id => x_REVIEW_UPLD_TERMS_id
1134: );
1135: --- If any errors happen abort API
1136: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141: ELSE

Line 1139: RAISE FND_API.G_EXC_ERROR;

1135: --- If any errors happen abort API
1136: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1137: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1138: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1139: RAISE FND_API.G_EXC_ERROR;
1140: END IF;
1141: ELSE
1142: x_REVIEW_UPLD_TERMS_id := p_REVIEW_UPLD_TERMS_id;
1143: END IF;

Line 1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1173: p_upload_level => p_upload_level
1174: );
1175: --- If any errors happen abort API
1176: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:

Line 1179: RAISE FND_API.G_EXC_ERROR;

1175: --- If any errors happen abort API
1176: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1177: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1178: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1179: RAISE FND_API.G_EXC_ERROR;
1180: END IF;
1181:
1182: --------------------------------------------
1183: -- Call the internal Insert_Row for each child record

Line 1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1212: p_last_update_login => l_last_update_login,
1213: p_last_update_date => l_last_update_date
1214: );
1215: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220:

Line 1218: RAISE FND_API.G_EXC_ERROR;

1214: );
1215: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1216: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1217: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1218: RAISE FND_API.G_EXC_ERROR;
1219: END IF;
1220:
1221:
1222:

Line 1228: WHEN FND_API.G_EXC_ERROR THEN

1224: Okc_Debug.Log('4500: Leaving Insert_Row', 2);
1225: END IF;
1226:
1227: EXCEPTION
1228: WHEN FND_API.G_EXC_ERROR THEN
1229: IF (l_debug = 'Y') THEN
1230: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1231: END IF;
1232: x_return_status := G_RET_STS_ERROR;

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

1226:
1227: EXCEPTION
1228: WHEN FND_API.G_EXC_ERROR THEN
1229: IF (l_debug = 'Y') THEN
1230: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1231: END IF;
1232: x_return_status := G_RET_STS_ERROR;
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1230: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1231: END IF;
1232: x_return_status := G_RET_STS_ERROR;
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: IF (l_debug = 'Y') THEN
1236: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1237: END IF;
1238: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1232: x_return_status := G_RET_STS_ERROR;
1233:
1234: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1235: IF (l_debug = 'Y') THEN
1236: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1237: END IF;
1238: x_return_status := G_RET_STS_UNEXP_ERROR;
1239:
1240: WHEN OTHERS THEN

Line 1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1378: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,
1379: p_object_version_number => p_object_version_number
1380: );
1381: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:

Line 1384: RAISE FND_API.G_EXC_ERROR;

1380: );
1381: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1382: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1383: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1384: RAISE FND_API.G_EXC_ERROR;
1385: END IF;
1386:
1387:
1388:

Line 1394: WHEN FND_API.G_EXC_ERROR THEN

1390: Okc_Debug.Log('6000: Leaving Lock_Row', 2);
1391: END IF;
1392:
1393: EXCEPTION
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: IF (l_debug = 'Y') THEN
1396: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1397: END IF;
1398: x_return_status := G_RET_STS_ERROR;

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

1392:
1393: EXCEPTION
1394: WHEN FND_API.G_EXC_ERROR THEN
1395: IF (l_debug = 'Y') THEN
1396: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1397: END IF;
1398: x_return_status := G_RET_STS_ERROR;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1396: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1397: END IF;
1398: x_return_status := G_RET_STS_ERROR;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: IF (l_debug = 'Y') THEN
1402: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1403: END IF;
1404: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1398: x_return_status := G_RET_STS_ERROR;
1399:
1400: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1401: IF (l_debug = 'Y') THEN
1402: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1403: END IF;
1404: x_return_status := G_RET_STS_UNEXP_ERROR;
1405:
1406: WHEN OTHERS THEN

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

1504: -------------------------------------
1505: -- Update_Row for:OKC_REVIEW_UPLD_TERMS --
1506: -------------------------------------
1507: PROCEDURE Update_Row(
1508: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1509:
1510: x_return_status OUT NOCOPY VARCHAR2,
1511:
1512: p_REVIEW_UPLD_TERMS_id IN NUMBER,

Line 1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1565: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,
1566: p_object_version_number => p_object_version_number
1567: );
1568: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:

Line 1571: RAISE FND_API.G_EXC_ERROR;

1567: );
1568: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1569: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1570: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1571: RAISE FND_API.G_EXC_ERROR;
1572: END IF;
1573:
1574:
1575: IF (l_debug = 'Y') THEN

Line 1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1615: x_new_parent_id => l_new_parent_id,
1616: x_upload_level => l_upload_level
1617: );
1618: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:

Line 1621: RAISE FND_API.G_EXC_ERROR;

1617: );
1618: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1619: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1620: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1621: RAISE FND_API.G_EXC_ERROR;
1622: END IF;
1623:
1624: IF (l_debug = 'Y') THEN
1625: Okc_Debug.Log('7400: Record Validation', 2);

Line 1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1648: p_upload_level => l_upload_level
1649: );
1650: --- If any errors happen abort API
1651: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:

Line 1654: RAISE FND_API.G_EXC_ERROR;

1650: --- If any errors happen abort API
1651: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1652: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1653: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1654: RAISE FND_API.G_EXC_ERROR;
1655: END IF;
1656:
1657: IF (l_debug = 'Y') THEN
1658: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1700: p_last_update_login => l_last_update_login,
1701: p_last_update_date => l_last_update_date
1702: );
1703: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: END IF;
1708:

Line 1706: RAISE FND_API.G_EXC_ERROR;

1702: );
1703: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1704: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1705: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1706: RAISE FND_API.G_EXC_ERROR;
1707: END IF;
1708:
1709:
1710: IF (l_debug = 'Y') THEN

Line 1715: WHEN FND_API.G_EXC_ERROR THEN

1711: Okc_Debug.Log('7800: Leaving Update_Row', 2);
1712: END IF;
1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: IF (l_debug = 'Y') THEN
1717: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1718: END IF;
1719: x_return_status := G_RET_STS_ERROR;

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

1713:
1714: EXCEPTION
1715: WHEN FND_API.G_EXC_ERROR THEN
1716: IF (l_debug = 'Y') THEN
1717: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1718: END IF;
1719: x_return_status := G_RET_STS_ERROR;
1720:
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1717: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1718: END IF;
1719: x_return_status := G_RET_STS_ERROR;
1720:
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1722: IF (l_debug = 'Y') THEN
1723: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1724: END IF;
1725: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1719: x_return_status := G_RET_STS_ERROR;
1720:
1721: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1722: IF (l_debug = 'Y') THEN
1723: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1724: END IF;
1725: x_return_status := G_RET_STS_UNEXP_ERROR;
1726:
1727: WHEN OTHERS THEN

Line 1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1801: p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id,
1802: p_object_version_number => p_object_version_number
1803: );
1804: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:

Line 1807: RAISE FND_API.G_EXC_ERROR;

1803: );
1804: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1806: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1807: RAISE FND_API.G_EXC_ERROR;
1808: END IF;
1809:
1810:
1811: IF (l_debug = 'Y') THEN

Line 1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1812: Okc_Debug.Log('9100: Removing _B row', 2);
1813: END IF;
1814: x_return_status := Delete_Row( p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id );
1815: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:

Line 1818: RAISE FND_API.G_EXC_ERROR;

1814: x_return_status := Delete_Row( p_REVIEW_UPLD_TERMS_id => p_REVIEW_UPLD_TERMS_id );
1815: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1816: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1817: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1818: RAISE FND_API.G_EXC_ERROR;
1819: END IF;
1820:
1821:
1822: IF (l_debug = 'Y') THEN

Line 1827: WHEN FND_API.G_EXC_ERROR THEN

1823: Okc_Debug.Log('9300: Leaving Delete_Row', 2);
1824: END IF;
1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: IF (l_debug = 'Y') THEN
1829: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1830: END IF;
1831: x_return_status := G_RET_STS_ERROR;

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

1825:
1826: EXCEPTION
1827: WHEN FND_API.G_EXC_ERROR THEN
1828: IF (l_debug = 'Y') THEN
1829: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1830: END IF;
1831: x_return_status := G_RET_STS_ERROR;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1829: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1830: END IF;
1831: x_return_status := G_RET_STS_ERROR;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (l_debug = 'Y') THEN
1835: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1836: END IF;
1837: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1831: x_return_status := G_RET_STS_ERROR;
1832:
1833: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1834: IF (l_debug = 'Y') THEN
1835: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1836: END IF;
1837: x_return_status := G_RET_STS_UNEXP_ERROR;
1838:
1839: WHEN OTHERS THEN

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

1852:
1853:
1854: PROCEDURE Accept_Changes (
1855: p_api_version IN NUMBER,
1856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1859: p_mode IN VARCHAR2 := 'NORMAL',
1860:

Line 1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

1853:
1854: PROCEDURE Accept_Changes (
1855: p_api_version IN NUMBER,
1856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1859: p_mode IN VARCHAR2 := 'NORMAL',
1860:
1861: p_document_type IN VARCHAR2,

Line 1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,

1854: PROCEDURE Accept_Changes (
1855: p_api_version IN NUMBER,
1856: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1857: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
1858: p_commit IN VARCHAR2 := FND_API.G_FALSE,
1859: p_mode IN VARCHAR2 := 'NORMAL',
1860:
1861: p_document_type IN VARCHAR2,
1862: p_document_id IN NUMBER,

Line 1863: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,

1859: p_mode IN VARCHAR2 := 'NORMAL',
1860:
1861: p_document_type IN VARCHAR2,
1862: p_document_id IN NUMBER,
1863: p_validate_commit IN VARCHAR2 := FND_API.G_FALSE,
1864: p_validation_string IN VARCHAR2 := NULL,
1865:
1866: x_return_status OUT NOCOPY VARCHAR2,
1867: x_msg_data OUT NOCOPY VARCHAR2,

Line 2047: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2043: -- Standard Start of API savepoint
2044: SAVEPOINT g_accept_changes;
2045:
2046: -- Standard call to check for call compatibility.
2047: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:
2051: -- Initialize message list if p_init_msg_list is set to TRUE.

Line 2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2044: SAVEPOINT g_accept_changes;
2045:
2046: -- Standard call to check for call compatibility.
2047: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:
2051: -- Initialize message list if p_init_msg_list is set to TRUE.
2052: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2052: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2048: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2049: END IF;
2050:
2051: -- Initialize message list if p_init_msg_list is set to TRUE.
2052: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2053: FND_MSG_PUB.initialize;
2054: END IF;
2055:
2056: -- Initialize API return status to success

Line 2057: x_return_status := FND_API.G_RET_STS_SUCCESS;

2053: FND_MSG_PUB.initialize;
2054: END IF;
2055:
2056: -- Initialize API return status to success
2057: x_return_status := FND_API.G_RET_STS_SUCCESS;
2058:
2059: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_STD','N') THEN
2060: l_user_access := 'STD_AUTHOR';
2061: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_NON_STD','N') THEN

Line 2341: p_scn_code => FND_API.G_MISS_CHAR,

2337: p_label => NULL,
2338: p_scn_id => l_ref_id,
2339: p_heading => substr(to_char(obj_titles(i)),1,80),
2340: p_description => NULL,
2341: p_scn_code => FND_API.G_MISS_CHAR,
2342: p_object_version_number => NULL);
2343:
2344: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2345: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'12100: After OKC_TERMS_SECTIONS_GRP.update_section');

Line 2626: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2622:
2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2624: p_api_version => l_api_version,
2625: p_init_msg_list => p_init_msg_list ,
2626: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2627: p_commit => FND_API.G_FALSE,
2628: x_return_status => x_return_status,
2629: x_msg_count => x_msg_count,
2630: x_msg_data => x_msg_data,

Line 2627: p_commit => FND_API.G_FALSE,

2623: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
2624: p_api_version => l_api_version,
2625: p_init_msg_list => p_init_msg_list ,
2626: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2627: p_commit => FND_API.G_FALSE,
2628: x_return_status => x_return_status,
2629: x_msg_count => x_msg_count,
2630: x_msg_data => x_msg_data,
2631: p_document_type => p_document_type,

Line 2691: IF FND_API.To_Boolean( p_commit ) THEN

2687: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2688: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2689:
2690: -- Standard check of p_commit
2691: IF FND_API.To_Boolean( p_commit ) THEN
2692: COMMIT WORK;
2693: END IF;
2694:
2695: EXCEPTION

Line 2696: WHEN FND_API.G_EXC_ERROR THEN

2692: COMMIT WORK;
2693: END IF;
2694:
2695: EXCEPTION
2696: WHEN FND_API.G_EXC_ERROR THEN
2697: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2698: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15200: Leaving accept_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2699: END IF;
2700: ROLLBACK TO g_accept_changes;

Line 2704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2700: ROLLBACK TO g_accept_changes;
2701: x_return_status := G_RET_STS_ERROR ;
2702: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2703:
2704: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2705: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2706: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'15300: Leaving accept_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2707: END IF;
2708: ROLLBACK TO g_accept_Changes;

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

2723: END Accept_Changes;
2724:
2725: PROCEDURE Reject_Changes (
2726: p_api_version IN NUMBER,
2727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2730:
2731: p_document_type IN VARCHAR2,

Line 2728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2724:
2725: PROCEDURE Reject_Changes (
2726: p_api_version IN NUMBER,
2727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2730:
2731: p_document_type IN VARCHAR2,
2732: p_document_id IN NUMBER,

Line 2729: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2725: PROCEDURE Reject_Changes (
2726: p_api_version IN NUMBER,
2727: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2728: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2729: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2730:
2731: p_document_type IN VARCHAR2,
2732: p_document_id IN NUMBER,
2733:

Line 2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2745:
2746: -- Standard Start of API savepoint
2747: SAVEPOINT g_reject_changes;
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2746: -- Standard Start of API savepoint
2747: SAVEPOINT g_reject_changes;
2748: -- Standard call to check for call compatibility.
2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2754: FND_MSG_PUB.initialize;

Line 2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2749: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2750: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2751: END IF;
2752: -- Initialize message list if p_init_msg_list is set to TRUE.
2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756: -- Initialize API return status to success
2757: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2757: x_return_status := FND_API.G_RET_STS_SUCCESS;

2753: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2754: FND_MSG_PUB.initialize;
2755: END IF;
2756: -- Initialize API return status to success
2757: x_return_status := FND_API.G_RET_STS_SUCCESS;
2758:
2759: OKC_REVIEW_UPLD_TERMS_PVT.delete_uploaded_terms(
2760: p_api_version => l_api_version,
2761: p_init_msg_list => p_init_msg_list ,

Line 2762: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

2758:
2759: OKC_REVIEW_UPLD_TERMS_PVT.delete_uploaded_terms(
2760: p_api_version => l_api_version,
2761: p_init_msg_list => p_init_msg_list ,
2762: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2763: p_commit => FND_API.G_FALSE,
2764: x_return_status => x_return_status,
2765: x_msg_count => x_msg_count,
2766: x_msg_data => x_msg_data,

Line 2763: p_commit => FND_API.G_FALSE,

2759: OKC_REVIEW_UPLD_TERMS_PVT.delete_uploaded_terms(
2760: p_api_version => l_api_version,
2761: p_init_msg_list => p_init_msg_list ,
2762: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
2763: p_commit => FND_API.G_FALSE,
2764: x_return_status => x_return_status,
2765: x_msg_count => x_msg_count,
2766: x_msg_data => x_msg_data,
2767: p_document_type => p_document_type,

Line 2779: IF FND_API.To_Boolean( p_commit ) THEN

2775: -- Added for Performance after accepting the changes no longer required to retain data in this table.
2776: DELETE FROM okc_word_sync_t WHERE doc_id=p_document_id AND doc_type=p_document_type;
2777:
2778: -- Standard check of p_commit
2779: IF FND_API.To_Boolean( p_commit ) THEN
2780: COMMIT WORK;
2781: END IF;
2782:
2783: EXCEPTION

Line 2784: WHEN FND_API.G_EXC_ERROR THEN

2780: COMMIT WORK;
2781: END IF;
2782:
2783: EXCEPTION
2784: WHEN FND_API.G_EXC_ERROR THEN
2785: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2786: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
2787: END IF;
2788: ROLLBACK TO g_reject_changes;

Line 2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2788: ROLLBACK TO g_reject_changes;
2789: x_return_status := G_RET_STS_ERROR ;
2790: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2791:
2792: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2793: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2794: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2795: END IF;
2796: ROLLBACK TO g_reject_Changes;

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

2813:
2814:
2815: PROCEDURE Delete_Uploaded_Terms (
2816: p_api_version IN NUMBER,
2817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2818: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2820:
2821: p_document_type IN VARCHAR2,

Line 2818: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2814:
2815: PROCEDURE Delete_Uploaded_Terms (
2816: p_api_version IN NUMBER,
2817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2818: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2820:
2821: p_document_type IN VARCHAR2,
2822: p_document_id IN NUMBER,

Line 2819: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2815: PROCEDURE Delete_Uploaded_Terms (
2816: p_api_version IN NUMBER,
2817: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2818: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2819: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2820:
2821: p_document_type IN VARCHAR2,
2822: p_document_id IN NUMBER,
2823:

Line 2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

2835:
2836: -- Standard Start of API savepoint
2837: SAVEPOINT g_delete_uploaded_terms;
2838: -- Standard call to check for call compatibility.
2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842: -- Initialize message list if p_init_msg_list is set to TRUE.
2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2836: -- Standard Start of API savepoint
2837: SAVEPOINT g_delete_uploaded_terms;
2838: -- Standard call to check for call compatibility.
2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842: -- Initialize message list if p_init_msg_list is set to TRUE.
2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2844: FND_MSG_PUB.initialize;

Line 2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN

2839: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
2840: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2841: END IF;
2842: -- Initialize message list if p_init_msg_list is set to TRUE.
2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2844: FND_MSG_PUB.initialize;
2845: END IF;
2846: -- Initialize API return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 2847: x_return_status := FND_API.G_RET_STS_SUCCESS;

2843: IF FND_API.to_Boolean( p_init_msg_list ) THEN
2844: FND_MSG_PUB.initialize;
2845: END IF;
2846: -- Initialize API return status to success
2847: x_return_status := FND_API.G_RET_STS_SUCCESS;
2848:
2849: DELETE
2850: FROM OKC_REVIEW_MESSAGES m
2851: WHERE m.REVIEW_UPLD_TERMS_id IN

Line 2888: IF FND_API.To_Boolean( p_commit ) THEN

2884: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'400: After delete review terms');
2885: END IF;
2886:
2887: -- Standard check of p_commit
2888: IF FND_API.To_Boolean( p_commit ) THEN
2889: COMMIT WORK;
2890: END IF;
2891:
2892: EXCEPTION

Line 2893: WHEN FND_API.G_EXC_ERROR THEN

2889: COMMIT WORK;
2890: END IF;
2891:
2892: EXCEPTION
2893: WHEN FND_API.G_EXC_ERROR THEN
2894: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2895: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Delete_Uploaded_Terms: OKC_API.G_EXCEPTION_ERROR Exception');
2896: END IF;
2897: ROLLBACK TO g_delete_uploaded_terms;

Line 2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2897: ROLLBACK TO g_delete_uploaded_terms;
2898: x_return_status := G_RET_STS_ERROR ;
2899: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
2900:
2901: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2902: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2903: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Delete_Uploaded_terms: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
2904: END IF;
2905: ROLLBACK TO g_delete_uploaded_terms;

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

2922:
2923:
2924: PROCEDURE Sync_Review_Tables (
2925: p_api_version IN NUMBER,
2926: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_string IN VARCHAR2 := NULL,
2930: p_document_type IN VARCHAR2,

Line 2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

2923:
2924: PROCEDURE Sync_Review_Tables (
2925: p_api_version IN NUMBER,
2926: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_string IN VARCHAR2 := NULL,
2930: p_document_type IN VARCHAR2,
2931: p_document_id IN NUMBER,

Line 2928: p_commit IN VARCHAR2 := FND_API.G_FALSE,

2924: PROCEDURE Sync_Review_Tables (
2925: p_api_version IN NUMBER,
2926: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2927: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
2928: p_commit IN VARCHAR2 := FND_API.G_FALSE,
2929: p_validation_string IN VARCHAR2 := NULL,
2930: p_document_type IN VARCHAR2,
2931: p_document_id IN NUMBER,
2932:

Line 3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

3295:
3296: -- Standard Start of API savepoint
3297: SAVEPOINT g_reject_changes;
3298: -- Standard call to check for call compatibility.
3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: -- Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3296: -- Standard Start of API savepoint
3297: SAVEPOINT g_reject_changes;
3298: -- Standard call to check for call compatibility.
3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: -- Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3304: FND_MSG_PUB.initialize;

Line 3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN

3299: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
3300: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3301: END IF;
3302: -- Initialize message list if p_init_msg_list is set to TRUE.
3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306: -- Initialize API return status to success
3307: x_return_status := FND_API.G_RET_STS_SUCCESS;

Line 3307: x_return_status := FND_API.G_RET_STS_SUCCESS;

3303: IF FND_API.to_Boolean( p_init_msg_list ) THEN
3304: FND_MSG_PUB.initialize;
3305: END IF;
3306: -- Initialize API return status to success
3307: x_return_status := FND_API.G_RET_STS_SUCCESS;
3308: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_STD','N') THEN
3309: l_user_access := 'STD_AUTHOR';
3310: IF FND_FUNCTION.TEST('OKC_TERMS_AUTHOR_NON_STD','N') THEN
3311: l_user_access := 'NON_STD_AUTHOR';

Line 3771: p_commit => FND_API.G_FALSE,

3767: open unassigned_section_exists;
3768: fetch unassigned_section_exists into l_unassigned_scn_id;
3769: if(unassigned_section_exists%NOTFOUND)THEN
3770: create_unassigned_section(p_api_version => 1,
3771: p_commit => FND_API.G_FALSE,
3772: p_document_type => p_document_type,
3773: p_document_id => p_document_id,
3774: p_new_parent_id => l_rev_id_for_doc,
3775: x_scn_id => l_unassigned_scn_id,

Line 3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3782: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'130: Cannot Create Unassgined Section : '||x_msg_data||' Status '||x_return_status);
3783: END IF;
3784:
3785: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3787: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3788: RAISE FND_API.G_EXC_ERROR ;
3789: END IF;
3790: end if;

Line 3788: RAISE FND_API.G_EXC_ERROR ;

3784:
3785: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3786: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3787: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3788: RAISE FND_API.G_EXC_ERROR ;
3789: END IF;
3790: end if;
3791: close unassigned_section_exists;
3792: end if;

Line 4143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,

4139: end loop;
4140: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4141: p_api_version => l_api_version,
4142: p_init_msg_list => p_init_msg_list ,
4143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4144: p_commit => FND_API.G_FALSE,
4145: x_return_status => x_return_status,
4146: x_msg_count => x_msg_count,
4147: x_msg_data => x_msg_data,

Line 4144: p_commit => FND_API.G_FALSE,

4140: OKC_TEMPLATE_USAGES_GRP.update_template_usages(
4141: p_api_version => l_api_version,
4142: p_init_msg_list => p_init_msg_list ,
4143: p_validation_level => FND_API.G_VALID_LEVEL_FULL,
4144: p_commit => FND_API.G_FALSE,
4145: x_return_status => x_return_status,
4146: x_msg_count => x_msg_count,
4147: x_msg_data => x_msg_data,
4148: p_document_type => p_document_type,

Line 4224: IF FND_API.To_Boolean( p_commit ) THEN

4220: p_doc_id => p_document_id,
4221: p_num_scheme_id => l_doc_num_scheme);
4222: end if;
4223: -- Standard check of p_commit
4224: IF FND_API.To_Boolean( p_commit ) THEN
4225: COMMIT WORK;
4226: END IF;
4227:
4228: EXCEPTION

Line 4229: WHEN FND_API.G_EXC_ERROR THEN

4225: COMMIT WORK;
4226: END IF;
4227:
4228: EXCEPTION
4229: WHEN FND_API.G_EXC_ERROR THEN
4230: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4231: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'500: Leaving Reject_Changes: OKC_API.G_EXCEPTION_ERROR Exception');
4232: END IF;
4233: ROLLBACK TO g_reject_changes;

Line 4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4233: ROLLBACK TO g_reject_changes;
4234: x_return_status := G_RET_STS_ERROR ;
4235: FND_MSG_PUB.Count_And_Get( p_count => x_msg_count, p_data => x_msg_data );
4236:
4237: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4238: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4239: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'600: Leaving Reject_Changes: OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4240: END IF;
4241: ROLLBACK TO g_reject_Changes;

Line 4264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,

4260: -- creating un-assigned sections in a document in okc_REVIEW_UPLD_TERMS table
4261: */
4262: PROCEDURE Create_Unassigned_Section (
4263: p_api_version IN NUMBER,
4264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4265: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4266:
4267: x_return_status OUT NOCOPY VARCHAR2,
4268: x_msg_data OUT NOCOPY VARCHAR2,

Line 4265: p_commit IN VARCHAR2 := FND_API.G_FALSE,

4261: */
4262: PROCEDURE Create_Unassigned_Section (
4263: p_api_version IN NUMBER,
4264: p_init_msg_list IN VARCHAR2 := FND_API.G_FALSE,
4265: p_commit IN VARCHAR2 := FND_API.G_FALSE,
4266:
4267: x_return_status OUT NOCOPY VARCHAR2,
4268: x_msg_data OUT NOCOPY VARCHAR2,
4269: x_msg_count OUT NOCOPY NUMBER,

Line 4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN

4293: END IF;
4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;
4296: -- Standard call to check for call compatibility.
4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN

Line 4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4294: -- Standard Start of API savepoint
4295: SAVEPOINT g_Create_Unassigned_Section;
4296: -- Standard call to check for call compatibility.
4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;

Line 4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN

4297: IF NOT FND_API.Compatible_API_Call( l_api_version, p_api_version, l_api_name, G_PKG_NAME) THEN
4298: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4299: END IF;
4300: -- Initialize message list if p_init_msg_list is set to TRUE.
4301: IF FND_API.to_Boolean( p_init_msg_list ) THEN
4302: FND_MSG_PUB.initialize;
4303: END IF;
4304: -- Initialize API return status to success
4305: x_return_status := G_RET_STS_SUCCESS;

Line 4332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

4328: x_REVIEW_UPLD_TERMS_id => l_scn_id
4329: );
4330: --- If any errors happen abort API
4331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4334: RAISE FND_API.G_EXC_ERROR;
4335: END IF;
4336: x_scn_id := l_scn_id;

Line 4334: RAISE FND_API.G_EXC_ERROR;

4330: --- If any errors happen abort API
4331: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4332: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
4333: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4334: RAISE FND_API.G_EXC_ERROR;
4335: END IF;
4336: x_scn_id := l_scn_id;
4337: INSERT INTO OKC_REVIEW_UPLD_TERMS(
4338: REVIEW_UPLD_TERMS_ID,

Line 4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

4384: FROM dual);
4385:
4386: --------------------------------------------
4387: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4389: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4390: RAISE FND_API.G_EXC_ERROR ;
4391: END IF;
4392: --------------------------------------------

Line 4390: RAISE FND_API.G_EXC_ERROR ;

4386: --------------------------------------------
4387: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
4388: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
4389: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
4390: RAISE FND_API.G_EXC_ERROR ;
4391: END IF;
4392: --------------------------------------------
4393:
4394: IF FND_API.To_Boolean( p_commit ) THEN

Line 4394: IF FND_API.To_Boolean( p_commit ) THEN

4390: RAISE FND_API.G_EXC_ERROR ;
4391: END IF;
4392: --------------------------------------------
4393:
4394: IF FND_API.To_Boolean( p_commit ) THEN
4395: COMMIT WORK;
4396: END IF;
4397: -- Standard call to get message count and if count is 1, get message info.
4398: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );

Line 4403: WHEN FND_API.G_EXC_ERROR THEN

4399: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4400: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7700: Leaving Create_Unassigned_Section');
4401: END IF;
4402: EXCEPTION
4403: WHEN FND_API.G_EXC_ERROR THEN
4404: ROLLBACK TO g_Create_Unassigned_Section;
4405: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4406: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7800: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_ERROR Exception');
4407: END IF;

Line 4416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

4412:
4413: x_return_status := G_RET_STS_ERROR ;
4414: FND_MSG_PUB.Count_And_Get(p_encoded=>'F', p_count => x_msg_count, p_data => x_msg_data );
4415:
4416: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
4417: ROLLBACK TO g_Create_Unassigned_Section;
4418: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
4419: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Create_Unassigned_Section : OKC_API.G_EXCEPTION_UNEXPECTED_ERROR Exception');
4420: END IF;