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

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

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

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

39: ------------------------------------------------------------------------------
40: -- GLOBAL CONSTANTS
41: ------------------------------------------------------------------------------
42: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:

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

40: -- GLOBAL CONSTANTS
41: ------------------------------------------------------------------------------
42: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;

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

41: ------------------------------------------------------------------------------
42: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;

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

42: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
43: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
44: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
50: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;

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

44: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
50: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
51:
52: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

45: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
50: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
51:
52: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

46: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
47:
48: G_RET_STS_SUCCESS CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_SUCCESS;
49: G_RET_STS_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_ERROR;
50: G_RET_STS_UNEXP_ERROR CONSTANT VARCHAR2(1) := FND_API.G_RET_STS_UNEXP_ERROR;
51:
52: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
53: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
54: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

Line 267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

263: x_mergeable_doc_flag => x_mergeable_doc_flag
264: );
265: --- If any errors happen abort API
266: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:

Line 269: RAISE FND_API.G_EXC_ERROR;

265: --- If any errors happen abort API
266: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
267: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
268: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
269: RAISE FND_API.G_EXC_ERROR;
270: END IF;
271:
272: --- Reversing G_MISS/NULL values logic
273:

Line 372: WHEN FND_API.G_EXC_ERROR THEN

368: END IF;
369:
370: RETURN G_RET_STS_SUCCESS ;
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
375: END IF;
376: RETURN G_RET_STS_ERROR;

Line 374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');

370: RETURN G_RET_STS_SUCCESS ;
371: EXCEPTION
372: WHEN FND_API.G_EXC_ERROR THEN
373: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
375: END IF;
376: RETURN G_RET_STS_ERROR;
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

374: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
375: END IF;
376: RETURN G_RET_STS_ERROR;
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
381: END IF;
382: RETURN G_RET_STS_UNEXP_ERROR;

Line 380: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

376: RETURN G_RET_STS_ERROR;
377:
378: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
379: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
380: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
381: END IF;
382: RETURN G_RET_STS_UNEXP_ERROR;
383:
384: WHEN OTHERS THEN

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

398: ----------------------------------------------
399: -- Validate_Attributes for: OKC_CONTRACT_DOCS --
400: ----------------------------------------------
401: FUNCTION Validate_Attributes (
402: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
403:
404: p_business_document_type IN VARCHAR2,
405: p_business_document_id IN NUMBER,
406: p_business_document_version IN NUMBER,

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

609: ------------------------------------------
610: -- Validate_Record for:OKC_CONTRACT_DOCS --
611: ------------------------------------------
612: FUNCTION Validate_Record (
613: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
614:
615: p_business_document_type IN VARCHAR2,
616: p_business_document_id IN NUMBER,
617: p_business_document_version IN NUMBER,

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

706: ---------------------------------------
707: -- validate_row for:OKC_CONTRACT_DOCS --
708: ---------------------------------------
709: PROCEDURE validate_row(
710: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
711:
712: x_return_status OUT NOCOPY VARCHAR2,
713:
714: p_business_document_type IN VARCHAR2,

Line 801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

797: x_primary_contract_doc_flag => l_primary_contract_doc_flag,
798: x_mergeable_doc_flag => l_mergeable_doc_flag
799: );
800: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
803: RAISE FND_API.G_EXC_ERROR;
804: END IF;
805:

Line 803: RAISE FND_API.G_EXC_ERROR;

799: );
800: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
801: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
802: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
803: RAISE FND_API.G_EXC_ERROR;
804: END IF;
805:
806: -- Validate all non-missing attributes (Item Level Validation)
807: l_object_version_number := p_object_version_number ;

Line 835: WHEN FND_API.G_EXC_ERROR THEN

831: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3200: Leaving validate_row');
832: END IF;
833:
834: EXCEPTION
835: WHEN FND_API.G_EXC_ERROR THEN
836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
838: END IF;
839: x_return_status := G_RET_STS_ERROR;

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

833:
834: EXCEPTION
835: WHEN FND_API.G_EXC_ERROR THEN
836: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
838: END IF;
839: x_return_status := G_RET_STS_ERROR;
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

837: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
838: END IF;
839: x_return_status := G_RET_STS_ERROR;
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
844: END IF;
845: x_return_status := G_RET_STS_UNEXP_ERROR;

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

839: x_return_status := G_RET_STS_ERROR;
840:
841: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
842: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
843: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
844: END IF;
845: x_return_status := G_RET_STS_UNEXP_ERROR;
846:
847: WHEN OTHERS THEN

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

977: -------------------------------------
978: -- Insert_Row for:OKC_CONTRACT_DOCS --
979: -------------------------------------
980: PROCEDURE Insert_Row(
981: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
982: x_return_status OUT NOCOPY VARCHAR2,
983:
984: p_business_document_type IN VARCHAR2,
985: p_business_document_id IN NUMBER,

Line 1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1057: p_mergeable_doc_flag => p_mergeable_doc_flag
1058: );
1059: --- If any errors happen abort API
1060: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:

Line 1063: RAISE FND_API.G_EXC_ERROR;

1059: --- If any errors happen abort API
1060: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1061: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1062: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1063: RAISE FND_API.G_EXC_ERROR;
1064: END IF;
1065:
1066: --------------------------------------------
1067: -- Call the internal Insert_Row for each child record

Line 1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1096: p_primary_contract_doc_flag => p_primary_contract_doc_flag,
1097: p_mergeable_doc_flag => p_mergeable_doc_flag
1098: );
1099: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:

Line 1102: RAISE FND_API.G_EXC_ERROR;

1098: );
1099: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1100: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1101: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1102: RAISE FND_API.G_EXC_ERROR;
1103: END IF;
1104:
1105:
1106:

Line 1112: WHEN FND_API.G_EXC_ERROR THEN

1108: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Insert_Row');
1109: END IF;
1110:
1111: EXCEPTION
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1115: END IF;
1116: x_return_status := G_RET_STS_ERROR;

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

1110:
1111: EXCEPTION
1112: WHEN FND_API.G_EXC_ERROR THEN
1113: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1115: END IF;
1116: x_return_status := G_RET_STS_ERROR;
1117:
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1114: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
1115: END IF;
1116: x_return_status := G_RET_STS_ERROR;
1117:
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1120: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1121: END IF;
1122: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1116: x_return_status := G_RET_STS_ERROR;
1117:
1118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1119: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1120: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1121: END IF;
1122: x_return_status := G_RET_STS_UNEXP_ERROR;
1123:
1124: WHEN OTHERS THEN

Line 1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1283: p_attached_document_id => p_attached_document_id,
1284: p_object_version_number => p_object_version_number
1285: );
1286: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291:

Line 1289: RAISE FND_API.G_EXC_ERROR;

1285: );
1286: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1287: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1288: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1289: RAISE FND_API.G_EXC_ERROR;
1290: END IF;
1291:
1292:
1293:

Line 1299: WHEN FND_API.G_EXC_ERROR THEN

1295: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: Leaving Lock_Row');
1296: END IF;
1297:
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1302: END IF;
1303: x_return_status := G_RET_STS_ERROR;

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

1297:
1298: EXCEPTION
1299: WHEN FND_API.G_EXC_ERROR THEN
1300: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1301: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1302: END IF;
1303: x_return_status := G_RET_STS_ERROR;
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1301: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
1302: END IF;
1303: x_return_status := G_RET_STS_ERROR;
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1307: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1308: END IF;
1309: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1303: x_return_status := G_RET_STS_ERROR;
1304:
1305: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1306: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1307: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1308: END IF;
1309: x_return_status := G_RET_STS_UNEXP_ERROR;
1310:
1311: WHEN OTHERS THEN

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

1407: -------------------------------------
1408: -- Update_Row for:OKC_CONTRACT_DOCS --
1409: -------------------------------------
1410: PROCEDURE Update_Row(
1411: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1412:
1413: x_return_status OUT NOCOPY VARCHAR2,
1414:
1415: p_business_document_type IN VARCHAR2,

Line 1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1470: p_attached_document_id => p_attached_document_id,
1471: p_object_version_number => p_object_version_number
1472: );
1473: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:

Line 1476: RAISE FND_API.G_EXC_ERROR;

1472: );
1473: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1474: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1475: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1476: RAISE FND_API.G_EXC_ERROR;
1477: END IF;
1478:
1479:
1480: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1518: x_primary_contract_doc_flag => l_primary_contract_doc_flag,
1519: x_mergeable_doc_flag => l_mergeable_doc_flag
1520: );
1521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:

Line 1524: RAISE FND_API.G_EXC_ERROR;

1520: );
1521: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1522: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1523: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1524: RAISE FND_API.G_EXC_ERROR;
1525: END IF;
1526:
1527: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1528: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7400: Record Validation');

Line 1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1551: p_mergeable_doc_flag => l_mergeable_doc_flag
1552: );
1553: --- If any errors happen abort API
1554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1557: RAISE FND_API.G_EXC_ERROR;
1558: END IF;
1559:

Line 1557: RAISE FND_API.G_EXC_ERROR;

1553: --- If any errors happen abort API
1554: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1555: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1556: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1557: RAISE FND_API.G_EXC_ERROR;
1558: END IF;
1559:
1560: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1561: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7500: Filling WHO columns');

Line 1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1603: p_primary_contract_doc_flag => l_primary_contract_doc_flag,
1604: p_mergeable_doc_flag => l_mergeable_doc_flag
1605: );
1606: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611:

Line 1609: RAISE FND_API.G_EXC_ERROR;

1605: );
1606: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1607: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1608: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1609: RAISE FND_API.G_EXC_ERROR;
1610: END IF;
1611:
1612:
1613: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1618: WHEN FND_API.G_EXC_ERROR THEN

1614: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7800: Leaving Update_Row');
1615: END IF;
1616:
1617: EXCEPTION
1618: WHEN FND_API.G_EXC_ERROR THEN
1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1621: END IF;
1622: x_return_status := G_RET_STS_ERROR;

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

1616:
1617: EXCEPTION
1618: WHEN FND_API.G_EXC_ERROR THEN
1619: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1621: END IF;
1622: x_return_status := G_RET_STS_ERROR;
1623:
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1620: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
1621: END IF;
1622: x_return_status := G_RET_STS_ERROR;
1623:
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1626: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1627: END IF;
1628: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1622: x_return_status := G_RET_STS_ERROR;
1623:
1624: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1625: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1626: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1627: END IF;
1628: x_return_status := G_RET_STS_UNEXP_ERROR;
1629:
1630: WHEN OTHERS THEN

Line 1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1713: p_attached_document_id => p_attached_document_id,
1714: p_object_version_number => p_object_version_number
1715: );
1716: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721:

Line 1719: RAISE FND_API.G_EXC_ERROR;

1715: );
1716: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1717: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1718: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1719: RAISE FND_API.G_EXC_ERROR;
1720: END IF;
1721:
1722:
1723: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1724: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9100: Removing _B row');
1725: END IF;
1726: x_return_status := Delete_Row( p_business_document_type => p_business_document_type,p_business_document_id => p_business_document_id,p_business_document_version => p_business_document_version,p_attached_document_id => p_attached_document_id );
1727: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1730: RAISE FND_API.G_EXC_ERROR;
1731: END IF;
1732:

Line 1730: RAISE FND_API.G_EXC_ERROR;

1726: x_return_status := Delete_Row( p_business_document_type => p_business_document_type,p_business_document_id => p_business_document_id,p_business_document_version => p_business_document_version,p_attached_document_id => p_attached_document_id );
1727: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1728: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1729: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1730: RAISE FND_API.G_EXC_ERROR;
1731: END IF;
1732:
1733:
1734: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 1739: WHEN FND_API.G_EXC_ERROR THEN

1735: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');
1736: END IF;
1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1742: END IF;
1743: x_return_status := G_RET_STS_ERROR;

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

1737:
1738: EXCEPTION
1739: WHEN FND_API.G_EXC_ERROR THEN
1740: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1742: END IF;
1743: x_return_status := G_RET_STS_ERROR;
1744:
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1741: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
1742: END IF;
1743: x_return_status := G_RET_STS_ERROR;
1744:
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1748: END IF;
1749: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1743: x_return_status := G_RET_STS_ERROR;
1744:
1745: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1746: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1747: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1748: END IF;
1749: x_return_status := G_RET_STS_UNEXP_ERROR;
1750:
1751: WHEN OTHERS THEN