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

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

Line 1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1259: p_locked_by_user_id => p_locked_by_user_id
1260: );
1261: --- If any errors happen abort API
1262: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1263: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1264: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1265: RAISE FND_API.G_EXC_ERROR;
1266: END IF;
1267:

Line 1265: RAISE FND_API.G_EXC_ERROR;

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

Line 1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1305: p_locked_by_user_id => p_locked_by_user_id,
1306: p_contract_expert_finish_flag => p_contract_expert_finish_flag
1307: );
1308: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1309: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1310: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1311: RAISE FND_API.G_EXC_ERROR;
1312: END IF;
1313:

Line 1311: RAISE FND_API.G_EXC_ERROR;

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

Line 1321: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1323: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1324: END IF;
1325: x_return_status := G_RET_STS_ERROR;
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1330: END IF;
1331: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1325: x_return_status := G_RET_STS_ERROR;
1326:
1327: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1328: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1329: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1330: END IF;
1331: x_return_status := G_RET_STS_UNEXP_ERROR;
1332:
1333: WHEN OTHERS THEN

Line 1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1484: p_document_id => p_document_id,
1485: p_object_version_number => p_object_version_number
1486: );
1487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:

Line 1490: RAISE FND_API.G_EXC_ERROR;

1486: );
1487: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1488: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1489: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1490: RAISE FND_API.G_EXC_ERROR;
1491: END IF;
1492:
1493:
1494:

Line 1500: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1502: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1503: END IF;
1504: x_return_status := G_RET_STS_ERROR;
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1509: END IF;
1510: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1504: x_return_status := G_RET_STS_ERROR;
1505:
1506: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1507: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1508: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1509: END IF;
1510: x_return_status := G_RET_STS_UNEXP_ERROR;
1511:
1512: WHEN OTHERS THEN

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

1626: -------------------------------------
1627: -- Update_Row for:OKC_TEMPLATE_USAGES --
1628: -------------------------------------
1629: PROCEDURE Update_Row(
1630: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1631:
1632: x_return_status OUT NOCOPY VARCHAR2,
1633:
1634: p_document_type IN VARCHAR2,

Line 1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1703: p_document_id => p_document_id,
1704: p_object_version_number => p_object_version_number
1705: );
1706: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1709: RAISE FND_API.G_EXC_ERROR;
1710: END IF;
1711:

Line 1709: RAISE FND_API.G_EXC_ERROR;

1705: );
1706: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1707: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1708: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1709: RAISE FND_API.G_EXC_ERROR;
1710: END IF;
1711:
1712:
1713: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1763: x_legal_contact_id => l_legal_contact_id,
1764: x_locked_by_user_id => l_locked_by_user_id
1765: );
1766: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1769: RAISE FND_API.G_EXC_ERROR;
1770: END IF;
1771:

Line 1769: RAISE FND_API.G_EXC_ERROR;

1765: );
1766: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1767: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1768: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1769: RAISE FND_API.G_EXC_ERROR;
1770: END IF;
1771:
1772: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1773: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7400: Record Validation');

Line 1805: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1801: p_locked_by_user_id => l_locked_by_user_id
1802: );
1803: --- If any errors happen abort API
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: --- If any errors happen abort API
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: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1811: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Filling WHO columns');

Line 1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1860: p_legal_contact_id => l_legal_contact_id,
1861: p_locked_by_user_id => l_locked_by_user_id
1862: );
1863: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:

Line 1866: RAISE FND_API.G_EXC_ERROR;

1862: );
1863: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1864: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1865: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1866: RAISE FND_API.G_EXC_ERROR;
1867: END IF;
1868:
1869:
1870: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1875: WHEN FND_API.G_EXC_ERROR THEN

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

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

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

Line 1881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1877: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1878: END IF;
1879: x_return_status := G_RET_STS_ERROR;
1880:
1881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1882: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1883: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1884: END IF;
1885: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1879: x_return_status := G_RET_STS_ERROR;
1880:
1881: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1882: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1883: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1884: END IF;
1885: x_return_status := G_RET_STS_UNEXP_ERROR;
1886:
1887: WHEN OTHERS THEN

Line 1988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1984: p_document_id => p_document_id,
1985: p_object_version_number => p_object_version_number
1986: );
1987: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1989: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: END IF;
1992:

Line 1990: RAISE FND_API.G_EXC_ERROR;

1986: );
1987: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1988: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1989: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1990: RAISE FND_API.G_EXC_ERROR;
1991: END IF;
1992:
1993:
1994: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1995: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9100: Removing _B row');
1996: END IF;
1997: x_return_status := Delete_Row( p_document_type => p_document_type,p_document_id => p_document_id );
1998: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2001: RAISE FND_API.G_EXC_ERROR;
2002: END IF;
2003: END IF;

Line 2001: RAISE FND_API.G_EXC_ERROR;

1997: x_return_status := Delete_Row( p_document_type => p_document_type,p_document_id => p_document_id );
1998: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1999: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2000: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2001: RAISE FND_API.G_EXC_ERROR;
2002: END IF;
2003: END IF;
2004:
2005: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2010: WHEN FND_API.G_EXC_ERROR THEN

2006: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');
2007: END IF;
2008:
2009: EXCEPTION
2010: WHEN FND_API.G_EXC_ERROR THEN
2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
2013: END IF;
2014: x_return_status := G_RET_STS_ERROR;

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

2008:
2009: EXCEPTION
2010: WHEN FND_API.G_EXC_ERROR THEN
2011: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
2013: END IF;
2014: x_return_status := G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2012: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
2013: END IF;
2014: x_return_status := G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2018: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2019: END IF;
2020: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2014: x_return_status := G_RET_STS_ERROR;
2015:
2016: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2017: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2018: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2019: END IF;
2020: x_return_status := G_RET_STS_UNEXP_ERROR;
2021:
2022: WHEN OTHERS THEN