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_TERMS_TEMPLATES_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 449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

445: x_translated_from_tmpl_id => x_translated_from_tmpl_id,
446: x_language => x_language );
447: --- If any errors happen abort API
448: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453:

Line 451: RAISE FND_API.G_EXC_ERROR;

447: --- If any errors happen abort API
448: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
449: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
450: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
451: RAISE FND_API.G_EXC_ERROR;
452: END IF;
453:
454: --- Reversing G_MISS/NULL values logic
455:

Line 702: WHEN FND_API.G_EXC_ERROR THEN

698: END IF;
699:
700: RETURN G_RET_STS_SUCCESS ;
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
705: END IF;
706: RETURN G_RET_STS_ERROR;

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

700: RETURN G_RET_STS_SUCCESS ;
701: EXCEPTION
702: WHEN FND_API.G_EXC_ERROR THEN
703: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
704: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
705: END IF;
706: RETURN G_RET_STS_ERROR;
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

704: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
705: END IF;
706: RETURN G_RET_STS_ERROR;
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
711: END IF;
712: RETURN G_RET_STS_UNEXP_ERROR;

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

706: RETURN G_RET_STS_ERROR;
707:
708: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
709: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
710: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
711: END IF;
712: RETURN G_RET_STS_UNEXP_ERROR;
713:
714: WHEN OTHERS THEN

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

728: ----------------------------------------------
729: -- Validate_Attributes for: OKC_TERMS_TEMPLATES_ALL --
730: ----------------------------------------------
731: FUNCTION Validate_Attributes (
732: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
733:
734: p_template_name IN VARCHAR2,
735: p_template_id IN NUMBER,
736: p_working_copy_flag IN VARCHAR2,

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

1092: ------------------------------------------
1093: -- Validate_Record for:OKC_TERMS_TEMPLATES_ALL --
1094: ------------------------------------------
1095: FUNCTION Validate_Record (
1096: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1097:
1098: p_template_name IN VARCHAR2,
1099: p_template_id IN NUMBER,
1100: p_working_copy_flag IN VARCHAR2,

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

1418: ---------------------------------------
1419: -- validate_row for:OKC_TERMS_TEMPLATES_ALL --
1420: ---------------------------------------
1421: PROCEDURE validate_row(
1422: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1423:
1424: x_return_status OUT NOCOPY VARCHAR2,
1425:
1426: p_template_name IN VARCHAR2,

Line 1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1606: x_translated_from_tmpl_id => l_translated_from_tmpl_id ,
1607: x_language => l_language
1608: );
1609: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;
1614:

Line 1612: RAISE FND_API.G_EXC_ERROR;

1608: );
1609: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1610: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1611: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1612: RAISE FND_API.G_EXC_ERROR;
1613: END IF;
1614:
1615: -- Validate all non-missing attributes (Item Level Validation)
1616: x_return_status := Validate_Record(

Line 1667: WHEN FND_API.G_EXC_ERROR THEN

1663: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3200: Leaving validate_row');
1664: END IF;
1665:
1666: EXCEPTION
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1670: END IF;
1671: x_return_status := G_RET_STS_ERROR;

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

1665:
1666: EXCEPTION
1667: WHEN FND_API.G_EXC_ERROR THEN
1668: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1670: END IF;
1671: x_return_status := G_RET_STS_ERROR;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1669: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1670: END IF;
1671: x_return_status := G_RET_STS_ERROR;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1675: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1676: END IF;
1677: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1671: x_return_status := G_RET_STS_ERROR;
1672:
1673: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1674: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1675: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1676: END IF;
1677: x_return_status := G_RET_STS_UNEXP_ERROR;
1678:
1679: WHEN OTHERS THEN

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

1880: -------------------------------------
1881: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1882: -------------------------------------
1883: PROCEDURE Insert_Row(
1884: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1885: x_return_status OUT NOCOPY VARCHAR2,
1886:
1887: p_template_name IN VARCHAR2,
1888: p_template_id IN NUMBER,

Line 1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1952: x_template_id => x_template_id
1953: );
1954: --- If any errors happen abort API
1955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960: ELSE

Line 1958: RAISE FND_API.G_EXC_ERROR;

1954: --- If any errors happen abort API
1955: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1956: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1957: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1958: RAISE FND_API.G_EXC_ERROR;
1959: END IF;
1960: ELSE
1961: x_template_id := p_template_id;
1962: END IF;

Line 2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2016: p_language => p_language
2017: );
2018: --- If any errors happen abort API
2019: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2022: RAISE FND_API.G_EXC_ERROR;
2023: END IF;
2024:

Line 2022: RAISE FND_API.G_EXC_ERROR;

2018: --- If any errors happen abort API
2019: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2020: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2021: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2022: RAISE FND_API.G_EXC_ERROR;
2023: END IF;
2024:
2025: --------------------------------------------
2026: -- Call the internal Insert_Row for each child record

Line 2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2078: p_translated_from_tmpl_id => p_translated_from_tmpl_id,
2079: p_language => p_language
2080: );
2081: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2083: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2084: RAISE FND_API.G_EXC_ERROR;
2085: END IF;
2086:

Line 2084: RAISE FND_API.G_EXC_ERROR;

2080: );
2081: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2082: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2083: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2084: RAISE FND_API.G_EXC_ERROR;
2085: END IF;
2086:
2087:
2088:

Line 2094: WHEN FND_API.G_EXC_ERROR THEN

2090: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Insert_Row');
2091: END IF;
2092:
2093: EXCEPTION
2094: WHEN FND_API.G_EXC_ERROR THEN
2095: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2096: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2097: END IF;
2098: x_return_status := G_RET_STS_ERROR;

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

2092:
2093: EXCEPTION
2094: WHEN FND_API.G_EXC_ERROR THEN
2095: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2096: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2097: END IF;
2098: x_return_status := G_RET_STS_ERROR;
2099:
2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2096: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2097: END IF;
2098: x_return_status := G_RET_STS_ERROR;
2099:
2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2101: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2103: END IF;
2104: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2098: x_return_status := G_RET_STS_ERROR;
2099:
2100: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2101: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2102: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2103: END IF;
2104: x_return_status := G_RET_STS_UNEXP_ERROR;
2105:
2106: WHEN OTHERS THEN

Line 2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2251: p_template_id => p_template_id,
2252: p_object_version_number => p_object_version_number
2253: );
2254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:

Line 2257: RAISE FND_API.G_EXC_ERROR;

2253: );
2254: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2255: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2256: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2257: RAISE FND_API.G_EXC_ERROR;
2258: END IF;
2259:
2260:
2261:

Line 2267: WHEN FND_API.G_EXC_ERROR THEN

2263: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: Leaving Lock_Row');
2264: END IF;
2265:
2266: EXCEPTION
2267: WHEN FND_API.G_EXC_ERROR THEN
2268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2270: END IF;
2271: x_return_status := G_RET_STS_ERROR;

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

2265:
2266: EXCEPTION
2267: WHEN FND_API.G_EXC_ERROR THEN
2268: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2270: END IF;
2271: x_return_status := G_RET_STS_ERROR;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2269: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2270: END IF;
2271: x_return_status := G_RET_STS_ERROR;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2276: END IF;
2277: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2271: x_return_status := G_RET_STS_ERROR;
2272:
2273: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2274: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2275: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2276: END IF;
2277: x_return_status := G_RET_STS_UNEXP_ERROR;
2278:
2279: WHEN OTHERS THEN

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

2427: -------------------------------------
2428: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2429: -------------------------------------
2430: PROCEDURE Update_Row(
2431: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2432:
2433: x_return_status OUT NOCOPY VARCHAR2,
2434:
2435: p_template_name IN VARCHAR2,

Line 2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2546: p_template_id => p_template_id,
2547: p_object_version_number => p_object_version_number
2548: );
2549: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;
2554:

Line 2552: RAISE FND_API.G_EXC_ERROR;

2548: );
2549: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2550: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2551: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2552: RAISE FND_API.G_EXC_ERROR;
2553: END IF;
2554:
2555:
2556: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2641: x_translated_from_tmpl_id => l_translated_from_tmpl_id,
2642: x_language => l_language
2643: );
2644: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: END IF;
2649:

Line 2647: RAISE FND_API.G_EXC_ERROR;

2643: );
2644: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2645: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2646: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2647: RAISE FND_API.G_EXC_ERROR;
2648: END IF;
2649:
2650: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2651: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7400: Record Validation');

Line 2701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2697: p_language => l_language
2698: );
2699: --- If any errors happen abort API
2700: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2703: RAISE FND_API.G_EXC_ERROR;
2704: END IF;
2705:

Line 2703: RAISE FND_API.G_EXC_ERROR;

2699: --- If any errors happen abort API
2700: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2701: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2702: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2703: RAISE FND_API.G_EXC_ERROR;
2704: END IF;
2705:
2706: --Bug 4106468
2707: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2720: p_init_msg_list => FND_API.G_FALSE,

2716: -- Setting expert flag to 'N' by user should remove template - rule associations
2717: OKC_XPRT_TMPL_RULE_ASSNS_PVT.delete_template_rule_assns
2718: (
2719: p_api_version => 1.0,
2720: p_init_msg_list => FND_API.G_FALSE,
2721: p_commit => FND_API.G_FALSE,
2722: p_template_id => p_template_id,
2723: x_return_status => x_return_status,
2724: x_msg_data => l_msg_data,

Line 2721: p_commit => FND_API.G_FALSE,

2717: OKC_XPRT_TMPL_RULE_ASSNS_PVT.delete_template_rule_assns
2718: (
2719: p_api_version => 1.0,
2720: p_init_msg_list => FND_API.G_FALSE,
2721: p_commit => FND_API.G_FALSE,
2722: p_template_id => p_template_id,
2723: x_return_status => x_return_status,
2724: x_msg_data => l_msg_data,
2725: x_msg_count => l_msg_count

Line 2733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2729: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7450: Deleting expert Rule association return_status:'||x_return_status);
2730: END IF;
2731:
2732: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737: END IF;

Line 2735: RAISE FND_API.G_EXC_ERROR;

2731:
2732: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2733: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2734: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2735: RAISE FND_API.G_EXC_ERROR;
2736: END IF;
2737: END IF;
2738:
2739:

Line 2811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2807: p_translated_from_tmpl_id => l_translated_from_tmpl_id,
2808: p_language => l_language
2809: );
2810: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2812: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: END IF;
2815:

Line 2813: RAISE FND_API.G_EXC_ERROR;

2809: );
2810: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2811: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2812: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2813: RAISE FND_API.G_EXC_ERROR;
2814: END IF;
2815:
2816:
2817: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2822: WHEN FND_API.G_EXC_ERROR THEN

2818: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7800: Leaving Update_Row');
2819: END IF;
2820:
2821: EXCEPTION
2822: WHEN FND_API.G_EXC_ERROR THEN
2823: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2824: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2825: END IF;
2826: x_return_status := G_RET_STS_ERROR;

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

2820:
2821: EXCEPTION
2822: WHEN FND_API.G_EXC_ERROR THEN
2823: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2824: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2825: END IF;
2826: x_return_status := G_RET_STS_ERROR;
2827:
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2824: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2825: END IF;
2826: x_return_status := G_RET_STS_ERROR;
2827:
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2830: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2831: END IF;
2832: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2826: x_return_status := G_RET_STS_ERROR;
2827:
2828: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2829: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2830: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2831: END IF;
2832: x_return_status := G_RET_STS_UNEXP_ERROR;
2833:
2834: WHEN OTHERS THEN

Line 2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2966: p_template_id => p_template_id,
2967: p_object_version_number => p_object_version_number
2968: );
2969: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2972: RAISE FND_API.G_EXC_ERROR;
2973: END IF;
2974:

Line 2972: RAISE FND_API.G_EXC_ERROR;

2968: );
2969: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2970: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2971: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2972: RAISE FND_API.G_EXC_ERROR;
2973: END IF;
2974:
2975:
2976: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2978: END IF;
2979: x_return_status := Delete_Row( p_template_id => p_template_id );
2980:
2981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2984: RAISE FND_API.G_EXC_ERROR;
2985: END IF;
2986:

Line 2984: RAISE FND_API.G_EXC_ERROR;

2980:
2981: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2982: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2983: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2984: RAISE FND_API.G_EXC_ERROR;
2985: END IF;
2986:
2987: --------------------------------------------
2988: -- if template was expert enabled then delete the model

Line 3008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3004: x_msg_count => l_msg_count,
3005: x_msg_data => l_msg_data); */
3006:
3007:
3008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF; -- delete model successful
3011:
3012: -- delete record from okc_exprt_import_refs

Line 3009: RAISE FND_API.G_EXC_ERROR;

3005: x_msg_data => l_msg_data); */
3006:
3007:
3008: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3009: RAISE FND_API.G_EXC_ERROR;
3010: END IF; -- delete model successful
3011:
3012: -- delete record from okc_exprt_import_refs
3013: /* DELETE FROM okc_exprt_import_refs

Line 3027: WHEN FND_API.G_EXC_ERROR THEN

3023: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');
3024: END IF;
3025:
3026: EXCEPTION
3027: WHEN FND_API.G_EXC_ERROR THEN
3028: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3029: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3030: END IF;
3031: x_return_status := G_RET_STS_ERROR;

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

3025:
3026: EXCEPTION
3027: WHEN FND_API.G_EXC_ERROR THEN
3028: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3029: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3030: END IF;
3031: x_return_status := G_RET_STS_ERROR;
3032:
3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3029: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3030: END IF;
3031: x_return_status := G_RET_STS_ERROR;
3032:
3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3034: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3035: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3036: END IF;
3037: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3031: x_return_status := G_RET_STS_ERROR;
3032:
3033: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3034: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3035: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3036: END IF;
3037: x_return_status := G_RET_STS_UNEXP_ERROR;
3038:
3039: WHEN OTHERS THEN

Line 3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3068: p_object_version_number => NULL
3069: );
3070: --------------------------------------------
3071: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3073: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3074: RAISE FND_API.G_EXC_ERROR ;
3075: END IF;
3076: --------------------------------------------

Line 3074: RAISE FND_API.G_EXC_ERROR ;

3070: --------------------------------------------
3071: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3072: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3073: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3074: RAISE FND_API.G_EXC_ERROR ;
3075: END IF;
3076: --------------------------------------------
3077: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3078: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9900: Updating Row');

Line 3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3091: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3092: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9910: Leaving Update_Template_Id');
3093: END IF;
3094: EXCEPTION
3095: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3096: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3097: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9920: Leaving Update_Template_Id: G_EXCEPTION_UNEXPECTED_ERROR Exception');
3098:
3099: END IF;