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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Line 299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

295: x_locked_by_user_id => x_locked_by_user_id
296: );
297: --- If any errors happen abort API
298: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:

Line 301: RAISE FND_API.G_EXC_ERROR;

297: --- If any errors happen abort API
298: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
299: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
300: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
301: RAISE FND_API.G_EXC_ERROR;
302: END IF;
303:
304: --- Reversing G_MISS/NULL values logic
305:

Line 450: WHEN FND_API.G_EXC_ERROR THEN

446: END IF;
447:
448: RETURN G_RET_STS_SUCCESS ;
449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN
451: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
453: '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
454: END IF;

Line 453: '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');

449: EXCEPTION
450: WHEN FND_API.G_EXC_ERROR THEN
451: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
452: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
453: '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
454: END IF;
455: RETURN G_RET_STS_ERROR;
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

453: '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
454: END IF;
455: RETURN G_RET_STS_ERROR;
456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
460: '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
461: END IF;

Line 460: '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

456:
457: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
458: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
459: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,
460: '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
461: END IF;
462: RETURN G_RET_STS_UNEXP_ERROR;
463:
464: WHEN OTHERS THEN

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

479: ----------------------------------------------
480: -- Validate_Attributes for: OKC_TEMPLATE_USAGES --
481: ----------------------------------------------
482: FUNCTION Validate_Attributes (
483: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
484:
485: p_document_type IN VARCHAR2,
486: p_document_id IN NUMBER,
487: p_template_id IN NUMBER,

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

722: ------------------------------------------
723: -- Validate_Record for:OKC_TEMPLATE_USAGES --
724: ------------------------------------------
725: FUNCTION Validate_Record (
726: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
727:
728: p_document_type IN VARCHAR2,
729: p_document_id IN NUMBER,
730: p_template_id IN NUMBER,

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

833: ---------------------------------------
834: -- validate_row for:OKC_TEMPLATE_USAGES --
835: ---------------------------------------
836: PROCEDURE validate_row(
837: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
838:
839: x_return_status OUT NOCOPY VARCHAR2,
840:
841: p_document_type IN VARCHAR2,

Line 956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

952: p_legal_contact_id => p_legal_contact_id,
953: p_locked_by_user_id => p_locked_by_user_id
954: );
955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:

Line 958: RAISE FND_API.G_EXC_ERROR;

954: );
955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
958: RAISE FND_API.G_EXC_ERROR;
959: END IF;
960:
961: -- Validate all non-missing attributes (Item Level Validation)
962: x_return_status := Validate_Record(

Line 995: WHEN FND_API.G_EXC_ERROR THEN

991: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3200: Leaving validate_row');
992: END IF;
993:
994: EXCEPTION
995: WHEN FND_API.G_EXC_ERROR THEN
996: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
998: END IF;
999: x_return_status := G_RET_STS_ERROR;

Line 997: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');

993:
994: EXCEPTION
995: WHEN FND_API.G_EXC_ERROR THEN
996: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
997: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
998: END IF;
999: x_return_status := G_RET_STS_ERROR;
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

997: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
998: END IF;
999: x_return_status := G_RET_STS_ERROR;
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1004: END IF;
1005: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

999: x_return_status := G_RET_STS_ERROR;
1000:
1001: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1002: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1003: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1004: END IF;
1005: x_return_status := G_RET_STS_UNEXP_ERROR;
1006:
1007: WHEN OTHERS THEN

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

1157: -------------------------------------
1158: -- Insert_Row for:OKC_TEMPLATE_USAGES --
1159: -------------------------------------
1160: PROCEDURE Insert_Row(
1161: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1162: x_return_status OUT NOCOPY VARCHAR2,
1163:
1164: p_document_type IN VARCHAR2,
1165: p_document_id IN NUMBER,

Line 1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1255: p_locked_by_user_id => p_locked_by_user_id
1256: );
1257: --- If any errors happen abort API
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1261: RAISE FND_API.G_EXC_ERROR;
1262: END IF;
1263:

Line 1261: RAISE FND_API.G_EXC_ERROR;

1257: --- If any errors happen abort API
1258: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1259: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1260: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1261: RAISE FND_API.G_EXC_ERROR;
1262: END IF;
1263:
1264: --------------------------------------------
1265: -- Call the internal Insert_Row for each child record

Line 1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

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

Line 1306: RAISE FND_API.G_EXC_ERROR;

1302: );
1303: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1304: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1305: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1306: RAISE FND_API.G_EXC_ERROR;
1307: END IF;
1308:
1309:
1310:

Line 1316: WHEN FND_API.G_EXC_ERROR THEN

1312: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Insert_Row');
1313: END IF;
1314:
1315: EXCEPTION
1316: WHEN FND_API.G_EXC_ERROR THEN
1317: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1319: END IF;
1320: x_return_status := G_RET_STS_ERROR;

Line 1318: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');

1314:
1315: EXCEPTION
1316: WHEN FND_API.G_EXC_ERROR THEN
1317: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1318: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1319: END IF;
1320: x_return_status := G_RET_STS_ERROR;
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1318: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1319: END IF;
1320: x_return_status := G_RET_STS_ERROR;
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1325: END IF;
1326: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1324: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1320: x_return_status := G_RET_STS_ERROR;
1321:
1322: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1323: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1324: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1325: END IF;
1326: x_return_status := G_RET_STS_UNEXP_ERROR;
1327:
1328: WHEN OTHERS THEN

Line 1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1479: p_document_id => p_document_id,
1480: p_object_version_number => p_object_version_number
1481: );
1482: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:

Line 1485: RAISE FND_API.G_EXC_ERROR;

1481: );
1482: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1483: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1484: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1485: RAISE FND_API.G_EXC_ERROR;
1486: END IF;
1487:
1488:
1489:

Line 1495: WHEN FND_API.G_EXC_ERROR THEN

1491: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: Leaving Lock_Row');
1492: END IF;
1493:
1494: EXCEPTION
1495: WHEN FND_API.G_EXC_ERROR THEN
1496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1498: END IF;
1499: x_return_status := G_RET_STS_ERROR;

Line 1497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');

1493:
1494: EXCEPTION
1495: WHEN FND_API.G_EXC_ERROR THEN
1496: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1498: END IF;
1499: x_return_status := G_RET_STS_ERROR;
1500:
1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1497: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1498: END IF;
1499: x_return_status := G_RET_STS_ERROR;
1500:
1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1502: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1504: END IF;
1505: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1499: x_return_status := G_RET_STS_ERROR;
1500:
1501: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1502: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1503: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1504: END IF;
1505: x_return_status := G_RET_STS_UNEXP_ERROR;
1506:
1507: WHEN OTHERS THEN

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

1621: -------------------------------------
1622: -- Update_Row for:OKC_TEMPLATE_USAGES --
1623: -------------------------------------
1624: PROCEDURE Update_Row(
1625: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1626:
1627: x_return_status OUT NOCOPY VARCHAR2,
1628:
1629: p_document_type IN VARCHAR2,

Line 1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1698: p_document_id => p_document_id,
1699: p_object_version_number => p_object_version_number
1700: );
1701: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:

Line 1704: RAISE FND_API.G_EXC_ERROR;

1700: );
1701: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1702: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1703: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1704: RAISE FND_API.G_EXC_ERROR;
1705: END IF;
1706:
1707:
1708: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1758: x_legal_contact_id => l_legal_contact_id,
1759: x_locked_by_user_id => l_locked_by_user_id
1760: );
1761: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1764: RAISE FND_API.G_EXC_ERROR;
1765: END IF;
1766:

Line 1764: RAISE FND_API.G_EXC_ERROR;

1760: );
1761: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1762: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1763: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1764: RAISE FND_API.G_EXC_ERROR;
1765: END IF;
1766:
1767: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1768: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7400: Record Validation');

Line 1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1796: p_locked_by_user_id => l_locked_by_user_id
1797: );
1798: --- If any errors happen abort API
1799: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF;
1804:

Line 1802: RAISE FND_API.G_EXC_ERROR;

1798: --- If any errors happen abort API
1799: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1800: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1801: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1802: RAISE FND_API.G_EXC_ERROR;
1803: END IF;
1804:
1805: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1806: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Filling WHO columns');

Line 1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1855: p_legal_contact_id => l_legal_contact_id,
1856: p_locked_by_user_id => l_locked_by_user_id
1857: );
1858: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1860: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:

Line 1861: RAISE FND_API.G_EXC_ERROR;

1857: );
1858: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1859: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1860: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1861: RAISE FND_API.G_EXC_ERROR;
1862: END IF;
1863:
1864:
1865: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1870: WHEN FND_API.G_EXC_ERROR THEN

1866: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7800: Leaving Update_Row');
1867: END IF;
1868:
1869: EXCEPTION
1870: WHEN FND_API.G_EXC_ERROR THEN
1871: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1872: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1873: END IF;
1874: x_return_status := G_RET_STS_ERROR;

Line 1872: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');

1868:
1869: EXCEPTION
1870: WHEN FND_API.G_EXC_ERROR THEN
1871: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1872: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1873: END IF;
1874: x_return_status := G_RET_STS_ERROR;
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1872: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1873: END IF;
1874: x_return_status := G_RET_STS_ERROR;
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1879: END IF;
1880: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1878: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1874: x_return_status := G_RET_STS_ERROR;
1875:
1876: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1877: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1878: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1879: END IF;
1880: x_return_status := G_RET_STS_UNEXP_ERROR;
1881:
1882: WHEN OTHERS THEN

Line 1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1958: p_document_id => p_document_id,
1959: p_object_version_number => p_object_version_number
1960: );
1961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966:

Line 1964: RAISE FND_API.G_EXC_ERROR;

1960: );
1961: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1962: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1963: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1964: RAISE FND_API.G_EXC_ERROR;
1965: END IF;
1966:
1967:
1968: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1969: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9100: Removing _B row');
1970: END IF;
1971: x_return_status := Delete_Row( p_document_type => p_document_type,p_document_id => p_document_id );
1972: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:

Line 1975: RAISE FND_API.G_EXC_ERROR;

1971: x_return_status := Delete_Row( p_document_type => p_document_type,p_document_id => p_document_id );
1972: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1973: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1974: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1975: RAISE FND_API.G_EXC_ERROR;
1976: END IF;
1977:
1978:
1979: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1984: WHEN FND_API.G_EXC_ERROR THEN

1980: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');
1981: END IF;
1982:
1983: EXCEPTION
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1986: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1987: END IF;
1988: x_return_status := G_RET_STS_ERROR;

Line 1986: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');

1982:
1983: EXCEPTION
1984: WHEN FND_API.G_EXC_ERROR THEN
1985: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1986: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1987: END IF;
1988: x_return_status := G_RET_STS_ERROR;
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1986: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1987: END IF;
1988: x_return_status := G_RET_STS_ERROR;
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1992: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1993: END IF;
1994: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 1992: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1988: x_return_status := G_RET_STS_ERROR;
1989:
1990: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1991: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1992: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1993: END IF;
1994: x_return_status := G_RET_STS_UNEXP_ERROR;
1995:
1996: WHEN OTHERS THEN