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.

[Home] [Help]

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

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

Line 453: RAISE FND_API.G_EXC_ERROR;

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

Line 710: WHEN FND_API.G_EXC_ERROR THEN

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

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

708: RETURN G_RET_STS_SUCCESS ;
709: EXCEPTION
710: WHEN FND_API.G_EXC_ERROR THEN
711: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
713: END IF;
714: RETURN G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

712: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
713: END IF;
714: RETURN G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
719: END IF;
720: RETURN G_RET_STS_UNEXP_ERROR;

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

714: RETURN G_RET_STS_ERROR;
715:
716: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
717: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
718: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
719: END IF;
720: RETURN G_RET_STS_UNEXP_ERROR;
721:
722: WHEN OTHERS THEN

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

736: ----------------------------------------------
737: -- Validate_Attributes for: OKC_TERMS_TEMPLATES_ALL --
738: ----------------------------------------------
739: FUNCTION Validate_Attributes (
740: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
741:
742: p_template_name IN VARCHAR2,
743: p_template_id IN NUMBER,
744: p_working_copy_flag IN VARCHAR2,

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

1100: ------------------------------------------
1101: -- Validate_Record for:OKC_TERMS_TEMPLATES_ALL --
1102: ------------------------------------------
1103: FUNCTION Validate_Record (
1104: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1105:
1106: p_template_name IN VARCHAR2,
1107: p_template_id IN NUMBER,
1108: p_working_copy_flag IN VARCHAR2,

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

1426: ---------------------------------------
1427: -- validate_row for:OKC_TERMS_TEMPLATES_ALL --
1428: ---------------------------------------
1429: PROCEDURE validate_row(
1430: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1431:
1432: x_return_status OUT NOCOPY VARCHAR2,
1433:
1434: p_template_name IN VARCHAR2,

Line 1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1618: x_translated_from_tmpl_id => l_translated_from_tmpl_id ,
1619: x_language => l_language
1620: );
1621: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:

Line 1624: RAISE FND_API.G_EXC_ERROR;

1620: );
1621: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1622: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1623: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1624: RAISE FND_API.G_EXC_ERROR;
1625: END IF;
1626:
1627: -- Validate all non-missing attributes (Item Level Validation)
1628: x_return_status := Validate_Record(

Line 1679: WHEN FND_API.G_EXC_ERROR THEN

1675: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'3200: Leaving validate_row');
1676: END IF;
1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1682: END IF;
1683: x_return_status := G_RET_STS_ERROR;

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

1677:
1678: EXCEPTION
1679: WHEN FND_API.G_EXC_ERROR THEN
1680: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1682: END IF;
1683: x_return_status := G_RET_STS_ERROR;
1684:
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1681: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1682: END IF;
1683: x_return_status := G_RET_STS_ERROR;
1684:
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1686: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1688: END IF;
1689: x_return_status := G_RET_STS_UNEXP_ERROR;

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

1683: x_return_status := G_RET_STS_ERROR;
1684:
1685: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1686: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
1687: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1688: END IF;
1689: x_return_status := G_RET_STS_UNEXP_ERROR;
1690:
1691: WHEN OTHERS THEN

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

1896: -------------------------------------
1897: -- Insert_Row for:OKC_TERMS_TEMPLATES_ALL --
1898: -------------------------------------
1899: PROCEDURE Insert_Row(
1900: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1901: x_return_status OUT NOCOPY VARCHAR2,
1902:
1903: p_template_name IN VARCHAR2,
1904: p_template_id IN NUMBER,

Line 1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1968: x_template_id => x_template_id
1969: );
1970: --- If any errors happen abort API
1971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1974: RAISE FND_API.G_EXC_ERROR;
1975: END IF;
1976: ELSE

Line 1974: RAISE FND_API.G_EXC_ERROR;

1970: --- If any errors happen abort API
1971: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1972: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1973: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1974: RAISE FND_API.G_EXC_ERROR;
1975: END IF;
1976: ELSE
1977: x_template_id := p_template_id;
1978: END IF;

Line 2036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2032: p_language => p_language
2033: );
2034: --- If any errors happen abort API
2035: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2037: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040:

Line 2038: RAISE FND_API.G_EXC_ERROR;

2034: --- If any errors happen abort API
2035: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2036: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2037: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2038: RAISE FND_API.G_EXC_ERROR;
2039: END IF;
2040:
2041: --------------------------------------------
2042: -- Call the internal Insert_Row for each child record

Line 2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2095: p_translated_from_tmpl_id => p_translated_from_tmpl_id,
2096: p_language => p_language
2097: );
2098: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:

Line 2101: RAISE FND_API.G_EXC_ERROR;

2097: );
2098: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2099: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2100: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2101: RAISE FND_API.G_EXC_ERROR;
2102: END IF;
2103:
2104:
2105:

Line 2111: WHEN FND_API.G_EXC_ERROR THEN

2107: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'4500: Leaving Insert_Row');
2108: END IF;
2109:
2110: EXCEPTION
2111: WHEN FND_API.G_EXC_ERROR THEN
2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2114: END IF;
2115: x_return_status := G_RET_STS_ERROR;

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

2109:
2110: EXCEPTION
2111: WHEN FND_API.G_EXC_ERROR THEN
2112: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2113: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2114: END IF;
2115: x_return_status := G_RET_STS_ERROR;
2116:
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2113: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception');
2114: END IF;
2115: x_return_status := G_RET_STS_ERROR;
2116:
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2120: END IF;
2121: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2115: x_return_status := G_RET_STS_ERROR;
2116:
2117: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2118: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2119: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2120: END IF;
2121: x_return_status := G_RET_STS_UNEXP_ERROR;
2122:
2123: WHEN OTHERS THEN

Line 2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2268: p_template_id => p_template_id,
2269: p_object_version_number => p_object_version_number
2270: );
2271: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2274: RAISE FND_API.G_EXC_ERROR;
2275: END IF;
2276:

Line 2274: RAISE FND_API.G_EXC_ERROR;

2270: );
2271: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2272: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2273: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2274: RAISE FND_API.G_EXC_ERROR;
2275: END IF;
2276:
2277:
2278:

Line 2284: WHEN FND_API.G_EXC_ERROR THEN

2280: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'6000: Leaving Lock_Row');
2281: END IF;
2282:
2283: EXCEPTION
2284: WHEN FND_API.G_EXC_ERROR THEN
2285: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2287: END IF;
2288: x_return_status := G_RET_STS_ERROR;

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

2282:
2283: EXCEPTION
2284: WHEN FND_API.G_EXC_ERROR THEN
2285: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2287: END IF;
2288: x_return_status := G_RET_STS_ERROR;
2289:
2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2286: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception');
2287: END IF;
2288: x_return_status := G_RET_STS_ERROR;
2289:
2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2291: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2292: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2293: END IF;
2294: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2288: x_return_status := G_RET_STS_ERROR;
2289:
2290: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2291: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2292: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2293: END IF;
2294: x_return_status := G_RET_STS_UNEXP_ERROR;
2295:
2296: WHEN OTHERS THEN

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

2446: -------------------------------------
2447: -- Update_Row for:OKC_TERMS_TEMPLATES_ALL --
2448: -------------------------------------
2449: PROCEDURE Update_Row(
2450: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
2451:
2452: x_return_status OUT NOCOPY VARCHAR2,
2453:
2454: p_template_name IN VARCHAR2,

Line 2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2566: p_template_id => p_template_id,
2567: p_object_version_number => p_object_version_number
2568: );
2569: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2571: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2572: RAISE FND_API.G_EXC_ERROR;
2573: END IF;
2574:

Line 2572: RAISE FND_API.G_EXC_ERROR;

2568: );
2569: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2570: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2571: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2572: RAISE FND_API.G_EXC_ERROR;
2573: END IF;
2574:
2575:
2576: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2663: x_translated_from_tmpl_id => l_translated_from_tmpl_id,
2664: x_language => l_language
2665: );
2666: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2669: RAISE FND_API.G_EXC_ERROR;
2670: END IF;
2671:

Line 2669: RAISE FND_API.G_EXC_ERROR;

2665: );
2666: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2667: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2668: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2669: RAISE FND_API.G_EXC_ERROR;
2670: END IF;
2671:
2672: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2673: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7400: Record Validation');

Line 2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2719: p_language => l_language
2720: );
2721: --- If any errors happen abort API
2722: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2724: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2725: RAISE FND_API.G_EXC_ERROR;
2726: END IF;
2727:

Line 2725: RAISE FND_API.G_EXC_ERROR;

2721: --- If any errors happen abort API
2722: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2723: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2724: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2725: RAISE FND_API.G_EXC_ERROR;
2726: END IF;
2727:
2728: --Bug 4106468
2729: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2742: p_init_msg_list => FND_API.G_FALSE,

2738: -- Setting expert flag to 'N' by user should remove template - rule associations
2739: OKC_XPRT_TMPL_RULE_ASSNS_PVT.delete_template_rule_assns
2740: (
2741: p_api_version => 1.0,
2742: p_init_msg_list => FND_API.G_FALSE,
2743: p_commit => FND_API.G_FALSE,
2744: p_template_id => p_template_id,
2745: x_return_status => x_return_status,
2746: x_msg_data => l_msg_data,

Line 2743: p_commit => FND_API.G_FALSE,

2739: OKC_XPRT_TMPL_RULE_ASSNS_PVT.delete_template_rule_assns
2740: (
2741: p_api_version => 1.0,
2742: p_init_msg_list => FND_API.G_FALSE,
2743: p_commit => FND_API.G_FALSE,
2744: p_template_id => p_template_id,
2745: x_return_status => x_return_status,
2746: x_msg_data => l_msg_data,
2747: x_msg_count => l_msg_count

Line 2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2751: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7450: Deleting expert Rule association return_status:'||x_return_status);
2752: END IF;
2753:
2754: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2756: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2757: RAISE FND_API.G_EXC_ERROR;
2758: END IF;
2759: END IF;

Line 2757: RAISE FND_API.G_EXC_ERROR;

2753:
2754: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2755: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2756: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2757: RAISE FND_API.G_EXC_ERROR;
2758: END IF;
2759: END IF;
2760:
2761:

Line 2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2830: p_translated_from_tmpl_id => l_translated_from_tmpl_id,
2831: p_language => l_language
2832: );
2833: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2835: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2836: RAISE FND_API.G_EXC_ERROR;
2837: END IF;
2838:

Line 2836: RAISE FND_API.G_EXC_ERROR;

2832: );
2833: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2834: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2835: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2836: RAISE FND_API.G_EXC_ERROR;
2837: END IF;
2838:
2839:
2840: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 2845: WHEN FND_API.G_EXC_ERROR THEN

2841: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'7800: Leaving Update_Row');
2842: END IF;
2843:
2844: EXCEPTION
2845: WHEN FND_API.G_EXC_ERROR THEN
2846: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2847: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2848: END IF;
2849: x_return_status := G_RET_STS_ERROR;

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

2843:
2844: EXCEPTION
2845: WHEN FND_API.G_EXC_ERROR THEN
2846: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2847: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2848: END IF;
2849: x_return_status := G_RET_STS_ERROR;
2850:
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2847: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception');
2848: END IF;
2849: x_return_status := G_RET_STS_ERROR;
2850:
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2853: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2854: END IF;
2855: x_return_status := G_RET_STS_UNEXP_ERROR;

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

2849: x_return_status := G_RET_STS_ERROR;
2850:
2851: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2852: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
2853: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
2854: END IF;
2855: x_return_status := G_RET_STS_UNEXP_ERROR;
2856:
2857: WHEN OTHERS THEN

Line 2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2989: p_template_id => p_template_id,
2990: p_object_version_number => p_object_version_number
2991: );
2992: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:

Line 2995: RAISE FND_API.G_EXC_ERROR;

2991: );
2992: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2993: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2994: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2995: RAISE FND_API.G_EXC_ERROR;
2996: END IF;
2997:
2998:
2999: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN

Line 3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

3001: END IF;
3002: x_return_status := Delete_Row( p_template_id => p_template_id );
3003:
3004: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009:

Line 3007: RAISE FND_API.G_EXC_ERROR;

3003:
3004: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3005: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
3006: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3007: RAISE FND_API.G_EXC_ERROR;
3008: END IF;
3009:
3010: --------------------------------------------
3011: -- if template was expert enabled then delete the model

Line 3031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN

3027: x_msg_count => l_msg_count,
3028: x_msg_data => l_msg_data); */
3029:
3030:
3031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF; -- delete model successful
3034:
3035: -- delete record from okc_exprt_import_refs

Line 3032: RAISE FND_API.G_EXC_ERROR;

3028: x_msg_data => l_msg_data); */
3029:
3030:
3031: IF x_return_status <> FND_API.G_RET_STS_SUCCESS THEN
3032: RAISE FND_API.G_EXC_ERROR;
3033: END IF; -- delete model successful
3034:
3035: -- delete record from okc_exprt_import_refs
3036: /* DELETE FROM okc_exprt_import_refs

Line 3050: WHEN FND_API.G_EXC_ERROR THEN

3046: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9300: Leaving Delete_Row');
3047: END IF;
3048:
3049: EXCEPTION
3050: WHEN FND_API.G_EXC_ERROR THEN
3051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3052: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3053: END IF;
3054: x_return_status := G_RET_STS_ERROR;

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

3048:
3049: EXCEPTION
3050: WHEN FND_API.G_EXC_ERROR THEN
3051: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3052: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3053: END IF;
3054: x_return_status := G_RET_STS_ERROR;
3055:
3056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 3056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3052: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception');
3053: END IF;
3054: x_return_status := G_RET_STS_ERROR;
3055:
3056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3057: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3059: END IF;
3060: x_return_status := G_RET_STS_UNEXP_ERROR;

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

3054: x_return_status := G_RET_STS_ERROR;
3055:
3056: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3057: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3058: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
3059: END IF;
3060: x_return_status := G_RET_STS_UNEXP_ERROR;
3061:
3062: WHEN OTHERS THEN

Line 3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;

3091: p_object_version_number => NULL
3092: );
3093: --------------------------------------------
3094: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3096: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3097: RAISE FND_API.G_EXC_ERROR ;
3098: END IF;
3099: --------------------------------------------

Line 3097: RAISE FND_API.G_EXC_ERROR ;

3093: --------------------------------------------
3094: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
3095: RAISE FND_API.G_EXC_UNEXPECTED_ERROR ;
3096: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
3097: RAISE FND_API.G_EXC_ERROR ;
3098: END IF;
3099: --------------------------------------------
3100: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3101: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9900: Updating Row');

Line 3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

3114: IF ( FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3115: FND_LOG.STRING( FND_LOG.LEVEL_PROCEDURE, G_MODULE||l_api_name,'9910: Leaving Update_Template_Id');
3116: END IF;
3117: EXCEPTION
3118: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
3119: IF ( FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
3120: FND_LOG.STRING( FND_LOG.LEVEL_EXCEPTION, G_MODULE||l_api_name,'9920: Leaving Update_Template_Id: G_EXCEPTION_UNEXPECTED_ERROR Exception');
3121:
3122: END IF;