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_K_ART_VARIABLES_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 228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

224: x_last_update_date => l_last_update_date
225: );
226: --- If any errors happen abort API
227: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:

Line 230: RAISE FND_API.G_EXC_ERROR;

226: --- If any errors happen abort API
227: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
228: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
229: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
230: RAISE FND_API.G_EXC_ERROR;
231: END IF;
232:
233: --- Reversing G_MISS/NULL values logic
234:

Line 286: WHEN FND_API.G_EXC_ERROR THEN

282: END IF;
283:
284: RETURN G_RET_STS_SUCCESS ;
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: /*IF (l_debug = 'Y') THEN
288: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
289: END IF;*/
290:

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

284: RETURN G_RET_STS_SUCCESS ;
285: EXCEPTION
286: WHEN FND_API.G_EXC_ERROR THEN
287: /*IF (l_debug = 'Y') THEN
288: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
289: END IF;*/
290:
291: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
292: FND_LOG.STRING(G_PROC_LEVEL,

Line 293: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );

289: END IF;*/
290:
291: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
292: FND_LOG.STRING(G_PROC_LEVEL,
293: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );
294: END IF;
295: RETURN G_RET_STS_ERROR;
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

293: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception' );
294: END IF;
295: RETURN G_RET_STS_ERROR;
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: /*IF (l_debug = 'Y') THEN
299: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
300: END IF;*/
301:

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

295: RETURN G_RET_STS_ERROR;
296:
297: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
298: /*IF (l_debug = 'Y') THEN
299: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
300: END IF;*/
301:
302: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
303: FND_LOG.STRING(G_PROC_LEVEL,

Line 304: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

300: END IF;*/
301:
302: IF ( G_PROC_LEVEL >= G_DBG_LEVEL ) THEN
303: FND_LOG.STRING(G_PROC_LEVEL,
304: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
305: END IF;
306: RETURN G_RET_STS_UNEXP_ERROR;
307:
308: WHEN OTHERS THEN

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

327: ----------------------------------------------
328: -- Validate_Attributes for: OKC_K_ART_VARIABLES --
329: ----------------------------------------------
330: FUNCTION Validate_Attributes (
331: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
332:
333: p_cat_id IN NUMBER,
334: p_variable_code IN VARCHAR2,
335: p_variable_type IN VARCHAR2,

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

692: ------------------------------------------
693: -- Validate_Record for:OKC_K_ART_VARIABLES --
694: ------------------------------------------
695: FUNCTION Validate_Record (
696: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
697:
698: p_cat_id IN NUMBER,
699: p_variable_code IN VARCHAR2,
700: p_variable_type IN VARCHAR2,

Line 858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

854: x_attribute_value_set_id => l_attribute_value_set_id,
855: x_override_global_yn => l_override_global_yn
856: );
857: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:

Line 860: RAISE FND_API.G_EXC_ERROR;

856: );
857: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
858: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
859: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
860: RAISE FND_API.G_EXC_ERROR;
861: END IF;
862:
863: -- Validate all non-missing attributes (Item Level Validation)
864: x_return_status := Validate_Record(

Line 886: WHEN FND_API.G_EXC_ERROR THEN

882: G_PKG_NAME, '3200: Leaving validate_row' );
883: END IF;
884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
887: /*IF (l_debug = 'Y') THEN
888: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
889: END IF;*/
890:

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

884:
885: EXCEPTION
886: WHEN FND_API.G_EXC_ERROR THEN
887: /*IF (l_debug = 'Y') THEN
888: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
889: END IF;*/
890:
891: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
892: FND_LOG.STRING(G_EXCP_LEVEL,

Line 893: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );

889: END IF;*/
890:
891: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
892: FND_LOG.STRING(G_EXCP_LEVEL,
893: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );
894: END IF;
895: x_return_status := G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

893: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception' );
894: END IF;
895: x_return_status := G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: /*IF (l_debug = 'Y') THEN
899: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
900: END IF;*/
901:

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

895: x_return_status := G_RET_STS_ERROR;
896:
897: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
898: /*IF (l_debug = 'Y') THEN
899: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
900: END IF;*/
901:
902: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
903: FND_LOG.STRING(G_EXCP_LEVEL,

Line 904: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

900: END IF;*/
901:
902: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
903: FND_LOG.STRING(G_EXCP_LEVEL,
904: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
905: END IF;
906: x_return_status := G_RET_STS_UNEXP_ERROR;
907:
908: WHEN OTHERS THEN

Line 1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1092: p_override_global_yn => p_override_global_yn
1093: );
1094: --- If any errors happen abort API
1095: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100:

Line 1098: RAISE FND_API.G_EXC_ERROR;

1094: --- If any errors happen abort API
1095: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1096: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1097: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1098: RAISE FND_API.G_EXC_ERROR;
1099: END IF;
1100:
1101: --------------------------------------------
1102: -- Call the internal Insert_Row for each child record

Line 1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1128: p_global_variable_value => p_global_variable_value,
1129: p_global_var_value_id => p_global_var_value_id
1130: );
1131: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1133: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:

Line 1134: RAISE FND_API.G_EXC_ERROR;

1130: );
1131: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1132: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1133: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1134: RAISE FND_API.G_EXC_ERROR;
1135: END IF;
1136:
1137:
1138:

Line 1149: WHEN FND_API.G_EXC_ERROR THEN

1145: G_PKG_NAME, '4500: Leaving Insert_Row' );
1146: END IF;
1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: /*IF (l_debug = 'Y') THEN
1151: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1152: END IF;*/
1153:

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

1147:
1148: EXCEPTION
1149: WHEN FND_API.G_EXC_ERROR THEN
1150: /*IF (l_debug = 'Y') THEN
1151: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1152: END IF;*/
1153:
1154: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1155: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1156: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );

1152: END IF;*/
1153:
1154: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1155: FND_LOG.STRING(G_EXCP_LEVEL,
1156: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1157: END IF;
1158: x_return_status := G_RET_STS_ERROR;
1159:
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1156: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1157: END IF;
1158: x_return_status := G_RET_STS_ERROR;
1159:
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161: /*IF (l_debug = 'Y') THEN
1162: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1163: END IF;*/
1164:

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

1158: x_return_status := G_RET_STS_ERROR;
1159:
1160: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1161: /*IF (l_debug = 'Y') THEN
1162: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1163: END IF;*/
1164:
1165: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1166: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1167: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1163: END IF;*/
1164:
1165: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1166: FND_LOG.STRING(G_EXCP_LEVEL,
1167: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1168: END IF;
1169: x_return_status := G_RET_STS_UNEXP_ERROR;
1170:
1171: WHEN OTHERS THEN

Line 1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1346: p_variable_code => p_variable_code,
1347: p_object_version_number => p_object_version_number
1348: );
1349: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:

Line 1352: RAISE FND_API.G_EXC_ERROR;

1348: );
1349: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1350: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1351: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1352: RAISE FND_API.G_EXC_ERROR;
1353: END IF;
1354:
1355:
1356:

Line 1367: WHEN FND_API.G_EXC_ERROR THEN

1363: G_PKG_NAME, '6000: Leaving Lock_Row' );
1364: END IF;
1365:
1366: EXCEPTION
1367: WHEN FND_API.G_EXC_ERROR THEN
1368: /*IF (l_debug = 'Y') THEN
1369: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;*/
1371:

Line 1369: Okc_Debug.Log('6100: Leaving Lock_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('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
1370: END IF;*/
1371:
1372: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1373: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1374: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );

1370: END IF;*/
1371:
1372: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1373: FND_LOG.STRING(G_EXCP_LEVEL,
1374: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
1375: END IF;
1376: x_return_status := G_RET_STS_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1374: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
1375: END IF;
1376: x_return_status := G_RET_STS_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379: /*IF (l_debug = 'Y') THEN
1380: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1381: END IF;*/
1382:

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

1376: x_return_status := G_RET_STS_ERROR;
1377:
1378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1379: /*IF (l_debug = 'Y') THEN
1380: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1381: END IF;*/
1382:
1383: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1384: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1385: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1381: END IF;*/
1382:
1383: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1384: FND_LOG.STRING(G_EXCP_LEVEL,
1385: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1386: END IF;
1387: x_return_status := G_RET_STS_UNEXP_ERROR;
1388:
1389: WHEN OTHERS THEN

Line 1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1538: p_variable_code => p_variable_code,
1539: p_object_version_number => p_object_version_number
1540: );
1541: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:

Line 1544: RAISE FND_API.G_EXC_ERROR;

1540: );
1541: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1542: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1543: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1544: RAISE FND_API.G_EXC_ERROR;
1545: END IF;
1546:
1547: /*IF (l_debug = 'Y') THEN
1548: Okc_Debug.Log('7300: Setting attributes', 2);

Line 1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1571: x_attribute_value_set_id => l_attribute_value_set_id,
1572: x_override_global_yn => l_override_global_yn
1573: );
1574: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:

Line 1577: RAISE FND_API.G_EXC_ERROR;

1573: );
1574: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1575: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1576: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1577: RAISE FND_API.G_EXC_ERROR;
1578: END IF;
1579:
1580: /*IF (l_debug = 'Y') THEN
1581: Okc_Debug.Log('7400: Record Validation', 2);

Line 1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1599: p_override_global_yn => l_override_global_yn
1600: );
1601: --- If any errors happen abort API
1602: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: END IF;
1607:

Line 1605: RAISE FND_API.G_EXC_ERROR;

1601: --- If any errors happen abort API
1602: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1603: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1604: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1605: RAISE FND_API.G_EXC_ERROR;
1606: END IF;
1607:
1608: /*IF (l_debug = 'Y') THEN
1609: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1652: p_last_update_login => l_last_update_login,
1653: p_last_update_date => l_last_update_date
1654: );
1655: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:

Line 1658: RAISE FND_API.G_EXC_ERROR;

1654: );
1655: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1656: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1657: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1658: RAISE FND_API.G_EXC_ERROR;
1659: END IF;
1660:
1661:
1662: /*IF (l_debug = 'Y') THEN

Line 1672: WHEN FND_API.G_EXC_ERROR THEN

1668: G_PKG_NAME, '7800: Leaving Update_Row' );
1669: END IF;
1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: /*IF (l_debug = 'Y') THEN
1674: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1675: END IF;*/
1676:

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

1670:
1671: EXCEPTION
1672: WHEN FND_API.G_EXC_ERROR THEN
1673: /*IF (l_debug = 'Y') THEN
1674: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
1675: END IF;*/
1676:
1677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1678: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1679: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );

1675: END IF;*/
1676:
1677: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1678: FND_LOG.STRING(G_EXCP_LEVEL,
1679: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
1680: END IF;
1681:
1682: x_return_status := G_RET_STS_ERROR;
1683:

Line 1684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1680: END IF;
1681:
1682: x_return_status := G_RET_STS_ERROR;
1683:
1684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1685: /*IF (l_debug = 'Y') THEN
1686: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1687: END IF;*/
1688:

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

1682: x_return_status := G_RET_STS_ERROR;
1683:
1684: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1685: /*IF (l_debug = 'Y') THEN
1686: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1687: END IF;*/
1688:
1689: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1690: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1691: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1687: END IF;*/
1688:
1689: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1690: FND_LOG.STRING(G_EXCP_LEVEL,
1691: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1692: END IF;
1693:
1694: x_return_status := G_RET_STS_UNEXP_ERROR;
1695:

Line 1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1804: p_variable_code => p_variable_code,
1805: p_object_version_number => p_object_version_number
1806: );
1807: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812:

Line 1810: RAISE FND_API.G_EXC_ERROR;

1806: );
1807: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1808: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1809: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1810: RAISE FND_API.G_EXC_ERROR;
1811: END IF;
1812:
1813: /*IF (l_debug = 'Y') THEN
1814: Okc_Debug.Log('9100: Removing _B row', 2);

Line 1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1819: G_PKG_NAME, '9100: Removing _B row' );
1820: END IF;
1821: x_return_status := Delete_Row( p_cat_id => p_cat_id,p_variable_code => p_variable_code );
1822: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:

Line 1825: RAISE FND_API.G_EXC_ERROR;

1821: x_return_status := Delete_Row( p_cat_id => p_cat_id,p_variable_code => p_variable_code );
1822: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1823: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1824: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1825: RAISE FND_API.G_EXC_ERROR;
1826: END IF;
1827:
1828:
1829: /*IF (l_debug = 'Y') THEN

Line 1839: WHEN FND_API.G_EXC_ERROR THEN

1835: G_PKG_NAME, '9300: Leaving Delete_Row' );
1836: END IF;
1837:
1838: EXCEPTION
1839: WHEN FND_API.G_EXC_ERROR THEN
1840: /*IF (l_debug = 'Y') THEN
1841: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1842: END IF;*/
1843:

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

1837:
1838: EXCEPTION
1839: WHEN FND_API.G_EXC_ERROR THEN
1840: /*IF (l_debug = 'Y') THEN
1841: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
1842: END IF;*/
1843:
1844: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1845: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1846: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );

1842: END IF;*/
1843:
1844: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1845: FND_LOG.STRING(G_EXCP_LEVEL,
1846: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
1847: END IF;
1848: x_return_status := G_RET_STS_ERROR;
1849:
1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1846: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
1847: END IF;
1848: x_return_status := G_RET_STS_ERROR;
1849:
1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1851: /*IF (l_debug = 'Y') THEN
1852: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1853: END IF;*/
1854:

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

1848: x_return_status := G_RET_STS_ERROR;
1849:
1850: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1851: /*IF (l_debug = 'Y') THEN
1852: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1853: END IF;*/
1854:
1855: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1856: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1857: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1853: END IF;*/
1854:
1855: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1856: FND_LOG.STRING(G_EXCP_LEVEL,
1857: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1858: END IF;
1859: x_return_status := G_RET_STS_UNEXP_ERROR;
1860:
1861: WHEN OTHERS THEN

Line 1942: WHEN FND_API.G_EXC_ERROR THEN

1938: END IF;
1939: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
1940: x_return_status := G_RET_STS_ERROR ;
1941:
1942: WHEN FND_API.G_EXC_ERROR THEN
1943: /*IF (l_debug = 'Y') THEN
1944: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
1945: END IF;*/
1946:

Line 1944: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

1940: x_return_status := G_RET_STS_ERROR ;
1941:
1942: WHEN FND_API.G_EXC_ERROR THEN
1943: /*IF (l_debug = 'Y') THEN
1944: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
1945: END IF;*/
1946:
1947: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1948: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1949: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );

1945: END IF;*/
1946:
1947: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1948: FND_LOG.STRING(G_EXCP_LEVEL,
1949: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
1950: END IF;
1951:
1952: IF (lock_csr%ISOPEN) THEN
1953: CLOSE lock_csr;

Line 1958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1954: END IF;
1955:
1956: x_return_status := G_RET_STS_ERROR;
1957:
1958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1959: /*IF (l_debug = 'Y') THEN
1960: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1961: END IF;*/
1962:

Line 1960: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1956: x_return_status := G_RET_STS_ERROR;
1957:
1958: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1959: /*IF (l_debug = 'Y') THEN
1960: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1961: END IF;*/
1962:
1963: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1964: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1965: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1961: END IF;*/
1962:
1963: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1964: FND_LOG.STRING(G_EXCP_LEVEL,
1965: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1966: END IF;
1967:
1968: IF (lock_csr%ISOPEN) THEN
1969: CLOSE lock_csr;

Line 2072: WHEN FND_API.G_EXC_ERROR THEN

2068: END IF;
2069: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2070: x_return_status := G_RET_STS_ERROR ;
2071:
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: /*IF (l_debug = 'Y') THEN
2074: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2075: END IF;*/
2076:

Line 2074: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

2070: x_return_status := G_RET_STS_ERROR ;
2071:
2072: WHEN FND_API.G_EXC_ERROR THEN
2073: /*IF (l_debug = 'Y') THEN
2074: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2075: END IF;*/
2076:
2077: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2078: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2079: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );

2075: END IF;*/
2076:
2077: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2078: FND_LOG.STRING(G_EXCP_LEVEL,
2079: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2080: END IF;
2081:
2082: IF (lock_csr%ISOPEN) THEN
2083: CLOSE lock_csr;

Line 2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2083: CLOSE lock_csr;
2084: END IF;
2085: x_return_status := G_RET_STS_ERROR;
2086:
2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2088: /*IF (l_debug = 'Y') THEN
2089: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2090: END IF;*/
2091:

Line 2089: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2085: x_return_status := G_RET_STS_ERROR;
2086:
2087: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2088: /*IF (l_debug = 'Y') THEN
2089: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2090: END IF;*/
2091:
2092: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2093: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2094: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2090: END IF;*/
2091:
2092: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2093: FND_LOG.STRING(G_EXCP_LEVEL,
2094: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2095: END IF;
2096:
2097: IF (lock_csr%ISOPEN) THEN
2098: CLOSE lock_csr;

Line 2223: WHEN FND_API.G_EXC_ERROR THEN

2219: END IF;
2220: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2221:
2222: x_return_status := G_RET_STS_ERROR ;
2223: WHEN FND_API.G_EXC_ERROR THEN
2224: /*IF (l_debug = 'Y') THEN
2225: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2226: END IF;*/
2227:

Line 2225: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

2221:
2222: x_return_status := G_RET_STS_ERROR ;
2223: WHEN FND_API.G_EXC_ERROR THEN
2224: /*IF (l_debug = 'Y') THEN
2225: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2226: END IF;*/
2227:
2228: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2229: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2230: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );

2226: END IF;*/
2227:
2228: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2229: FND_LOG.STRING(G_EXCP_LEVEL,
2230: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2231: END IF;
2232:
2233: IF (lock_csr%ISOPEN) THEN
2234: CLOSE lock_csr;

Line 2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2235: END IF;
2236: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2237: x_return_status := G_RET_STS_ERROR;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: /*IF (l_debug = 'Y') THEN
2241: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2242: END IF;*/
2243:

Line 2241: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2237: x_return_status := G_RET_STS_ERROR;
2238:
2239: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2240: /*IF (l_debug = 'Y') THEN
2241: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2242: END IF;*/
2243:
2244: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2245: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2246: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2242: END IF;*/
2243:
2244: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2245: FND_LOG.STRING(G_EXCP_LEVEL,
2246: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2247: END IF;
2248:
2249: IF (lock_csr%ISOPEN) THEN
2250: CLOSE lock_csr;