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

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

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

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

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

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

35: -- GLOBAL CONSTANTS
36: ------------------------------------------------------------------------------
37: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
38: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
39: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;

36: ------------------------------------------------------------------------------
37: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
38: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
39: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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 41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;

37: G_FALSE CONSTANT VARCHAR2(1) := FND_API.G_FALSE;
38: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
39: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';

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

38: G_TRUE CONSTANT VARCHAR2(1) := FND_API.G_TRUE;
39: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
46: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';

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

39: G_MISS_NUM CONSTANT NUMBER := FND_API.G_MISS_NUM;
40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
46: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
47: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';

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

40: G_MISS_CHAR CONSTANT VARCHAR2(1) := FND_API.G_MISS_CHAR;
41: G_MISS_DATE CONSTANT DATE := FND_API.G_MISS_DATE;
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: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKC_UNEXPECTED_ERROR';
46: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_MESSAGE';
47: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'ERROR_CODE';
48:

Line 443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

439: x_last_amendment_date => x_last_amendment_date
440: );
441: --- If any errors happen abort API
442: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:

Line 445: RAISE FND_API.G_EXC_ERROR;

441: --- If any errors happen abort API
442: IF (l_return_status = G_RET_STS_UNEXP_ERROR) THEN
443: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
444: ELSIF (l_return_status = G_RET_STS_ERROR) THEN
445: RAISE FND_API.G_EXC_ERROR;
446: END IF;
447:
448: --- Reversing G_MISS/NULL values logic
449:

Line 664: WHEN FND_API.G_EXC_ERROR THEN

660: END IF;
661:
662: RETURN G_RET_STS_SUCCESS ;
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: /*IF (l_debug = 'Y') THEN
666: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
667: END IF;*/
668:

Line 666: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);

662: RETURN G_RET_STS_SUCCESS ;
663: EXCEPTION
664: WHEN FND_API.G_EXC_ERROR THEN
665: /*IF (l_debug = 'Y') THEN
666: Okc_Debug.Log('900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception', 2);
667: END IF;*/
668:
669: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
670: FND_LOG.STRING(G_EXCP_LEVEL,

Line 671: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');

667: END IF;*/
668:
669: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
670: FND_LOG.STRING(G_EXCP_LEVEL,
671: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
672: END IF;
673: RETURN G_RET_STS_ERROR;
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

671: G_PKG_NAME, '900: Leaving Set_Attributes:FND_API.G_EXC_ERROR Exception');
672: END IF;
673: RETURN G_RET_STS_ERROR;
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: /*IF (l_debug = 'Y') THEN
677: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
678: END IF;*/
679:

Line 677: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

673: RETURN G_RET_STS_ERROR;
674:
675: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
676: /*IF (l_debug = 'Y') THEN
677: Okc_Debug.Log('1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
678: END IF;*/
679:
680: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
681: FND_LOG.STRING(G_EXCP_LEVEL,

Line 682: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

678: END IF;*/
679:
680: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
681: FND_LOG.STRING(G_EXCP_LEVEL,
682: G_PKG_NAME, '1000: Leaving Set_Attributes:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
683: END IF;
684: RETURN G_RET_STS_UNEXP_ERROR;
685:
686: WHEN OTHERS THEN

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

705: ----------------------------------------------
706: -- Validate_Attributes for: OKC_SECTIONS_B --
707: ----------------------------------------------
708: FUNCTION Validate_Attributes (
709: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
710:
711: p_id IN NUMBER,
712: p_section_sequence IN NUMBER,
713: p_label IN VARCHAR2,

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

1061: ------------------------------------------
1062: -- Validate_Record for:OKC_SECTIONS_B --
1063: ------------------------------------------
1064: FUNCTION Validate_Record (
1065: p_validation_level IN NUMBER := FND_API.G_VALID_LEVEL_FULL,
1066: p_id IN NUMBER,
1067: p_section_sequence IN NUMBER,
1068: p_label IN VARCHAR2,
1069: p_scn_id IN NUMBER,

Line 1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1368: x_last_amended_by => l_last_amended_by,
1369: x_last_amendment_date => l_last_amendment_date
1370: );
1371: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:

Line 1374: RAISE FND_API.G_EXC_ERROR;

1370: );
1371: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1372: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1373: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1374: RAISE FND_API.G_EXC_ERROR;
1375: END IF;
1376:
1377: -- Validate all non-missing attributes (Item Level Validation)
1378: x_return_status := Validate_Record(

Line 1424: WHEN FND_API.G_EXC_ERROR THEN

1420: G_PKG_NAME, '3200: Leaving validate_row' );
1421: END IF;
1422:
1423: EXCEPTION
1424: WHEN FND_API.G_EXC_ERROR THEN
1425: /*IF (l_debug = 'Y') THEN
1426: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1427: END IF;*/
1428:

Line 1426: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);

1422:
1423: EXCEPTION
1424: WHEN FND_API.G_EXC_ERROR THEN
1425: /*IF (l_debug = 'Y') THEN
1426: Okc_Debug.Log('3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception', 2);
1427: END IF;*/
1428:
1429: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1430: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1431: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');

1427: END IF;*/
1428:
1429: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1430: FND_LOG.STRING(G_EXCP_LEVEL,
1431: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1432: END IF;
1433: x_return_status := G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1431: G_PKG_NAME, '3300: Leaving Validate_Row:FND_API.G_EXC_ERROR Exception');
1432: END IF;
1433: x_return_status := G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: /*IF (l_debug = 'Y') THEN
1437: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1438: END IF;*/
1439:

Line 1437: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1433: x_return_status := G_RET_STS_ERROR;
1434:
1435: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1436: /*IF (l_debug = 'Y') THEN
1437: Okc_Debug.Log('3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1438: END IF;*/
1439:
1440: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1441: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1442: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');

1438: END IF;*/
1439:
1440: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1441: FND_LOG.STRING(G_EXCP_LEVEL,
1442: G_PKG_NAME, '3400: Leaving Validate_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception');
1443: END IF;
1444: x_return_status := G_RET_STS_UNEXP_ERROR;
1445:
1446: WHEN OTHERS THEN

Line 1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1722: x_id => x_id
1723: );
1724: --- If any errors happen abort API
1725: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1727: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730: ELSE

Line 1728: RAISE FND_API.G_EXC_ERROR;

1724: --- If any errors happen abort API
1725: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1726: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1727: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1728: RAISE FND_API.G_EXC_ERROR;
1729: END IF;
1730: ELSE
1731: x_id := p_id;
1732: END IF;

Line 1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1780: p_summary_amend_operation_code => p_summary_amend_operation_code
1781: );
1782: --- If any errors happen abort API
1783: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:

Line 1786: RAISE FND_API.G_EXC_ERROR;

1782: --- If any errors happen abort API
1783: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1784: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1785: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1786: RAISE FND_API.G_EXC_ERROR;
1787: END IF;
1788:
1789: --------------------------------------------
1790: -- Call the internal Insert_Row for each child record

Line 1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

1840: p_last_amended_by => l_last_amended_by,
1841: p_last_amendment_date => l_last_amendment_date
1842: );
1843: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: END IF;
1848:

Line 1846: RAISE FND_API.G_EXC_ERROR;

1842: );
1843: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
1844: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
1845: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
1846: RAISE FND_API.G_EXC_ERROR;
1847: END IF;
1848:
1849:
1850:

Line 1861: WHEN FND_API.G_EXC_ERROR THEN

1857: G_PKG_NAME, '4500: Leaving Insert_Row');
1858: END IF;
1859:
1860: EXCEPTION
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: /*IF (l_debug = 'Y') THEN
1863: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1864: END IF;*/
1865:

Line 1863: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);

1859:
1860: EXCEPTION
1861: WHEN FND_API.G_EXC_ERROR THEN
1862: /*IF (l_debug = 'Y') THEN
1863: Okc_Debug.Log('4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception', 2);
1864: END IF;*/
1865:
1866: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1867: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1868: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );

1864: END IF;*/
1865:
1866: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1867: FND_LOG.STRING(G_EXCP_LEVEL,
1868: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1869: END IF;
1870: x_return_status := G_RET_STS_ERROR;
1871:
1872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 1872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

1868: G_PKG_NAME, '4600: Leaving Insert_Row:FND_API.G_EXC_ERROR Exception' );
1869: END IF;
1870: x_return_status := G_RET_STS_ERROR;
1871:
1872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1873: /*IF (l_debug = 'Y') THEN
1874: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1875: END IF;*/
1876:

Line 1874: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

1870: x_return_status := G_RET_STS_ERROR;
1871:
1872: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
1873: /*IF (l_debug = 'Y') THEN
1874: Okc_Debug.Log('4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
1875: END IF;*/
1876:
1877: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1878: FND_LOG.STRING(G_EXCP_LEVEL,

Line 1879: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

1875: END IF;*/
1876:
1877: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
1878: FND_LOG.STRING(G_EXCP_LEVEL,
1879: G_PKG_NAME, '4700: Leaving Insert_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
1880: END IF;
1881: x_return_status := G_RET_STS_UNEXP_ERROR;
1882:
1883: WHEN OTHERS THEN

Line 2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2058: p_id => p_id,
2059: p_object_version_number => p_object_version_number
2060: );
2061: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:

Line 2064: RAISE FND_API.G_EXC_ERROR;

2060: );
2061: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2062: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2063: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2064: RAISE FND_API.G_EXC_ERROR;
2065: END IF;
2066:
2067: /*IF (l_debug = 'Y') THEN
2068: Okc_Debug.Log('6000: Leaving Lock_Row', 2);

Line 2077: WHEN FND_API.G_EXC_ERROR THEN

2073: G_PKG_NAME, '6000: Leaving Lock_Row');
2074: END IF;
2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: /*IF (l_debug = 'Y') THEN
2079: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
2080: END IF;*/
2081:

Line 2079: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);

2075:
2076: EXCEPTION
2077: WHEN FND_API.G_EXC_ERROR THEN
2078: /*IF (l_debug = 'Y') THEN
2079: Okc_Debug.Log('6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception', 2);
2080: END IF;*/
2081:
2082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2083: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2084: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );

2080: END IF;*/
2081:
2082: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2083: FND_LOG.STRING(G_EXCP_LEVEL,
2084: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
2085: END IF;
2086: x_return_status := G_RET_STS_ERROR;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2084: G_PKG_NAME, '6100: Leaving Lock_Row:FND_API.G_EXC_ERROR Exception' );
2085: END IF;
2086: x_return_status := G_RET_STS_ERROR;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: /*IF (l_debug = 'Y') THEN
2090: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2091: END IF;*/
2092:

Line 2090: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2086: x_return_status := G_RET_STS_ERROR;
2087:
2088: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2089: /*IF (l_debug = 'Y') THEN
2090: Okc_Debug.Log('6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2091: END IF;*/
2092:
2093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2094: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2095: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2091: END IF;*/
2092:
2093: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2094: FND_LOG.STRING(G_EXCP_LEVEL,
2095: G_PKG_NAME, '6200: Leaving Lock_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2096: END IF;
2097: x_return_status := G_RET_STS_UNEXP_ERROR;
2098:
2099: WHEN OTHERS THEN

Line 2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2356: p_id => p_id,
2357: p_object_version_number => p_object_version_number
2358: );
2359: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2361: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;
2364:

Line 2362: RAISE FND_API.G_EXC_ERROR;

2358: );
2359: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2360: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2361: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2362: RAISE FND_API.G_EXC_ERROR;
2363: END IF;
2364:
2365:
2366: /*IF (l_debug = 'Y') THEN

Line 2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2443: x_last_amended_by => l_last_amended_by,
2444: x_last_amendment_date => l_last_amendment_date
2445: );
2446: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451:

Line 2449: RAISE FND_API.G_EXC_ERROR;

2445: );
2446: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2447: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2448: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2449: RAISE FND_API.G_EXC_ERROR;
2450: END IF;
2451:
2452: /*IF (l_debug = 'Y') THEN
2453: Okc_Debug.Log('7400: Record Validation', 2);

Line 2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2495: p_summary_amend_operation_code => l_summary_amend_operation_code
2496: );
2497: --- If any errors happen abort API
2498: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: END IF;
2503:

Line 2501: RAISE FND_API.G_EXC_ERROR;

2497: --- If any errors happen abort API
2498: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2499: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2500: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2501: RAISE FND_API.G_EXC_ERROR;
2502: END IF;
2503:
2504: /*IF (l_debug = 'Y') THEN
2505: Okc_Debug.Log('7500: Filling WHO columns', 2);

Line 2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2574: p_last_amended_by => l_last_amended_by,
2575: p_last_amendment_date => l_last_amendment_date
2576: );
2577: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2580: RAISE FND_API.G_EXC_ERROR;
2581: END IF;
2582:

Line 2580: RAISE FND_API.G_EXC_ERROR;

2576: );
2577: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2578: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2579: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2580: RAISE FND_API.G_EXC_ERROR;
2581: END IF;
2582:
2583:
2584: /*IF (l_debug = 'Y') THEN

Line 2594: WHEN FND_API.G_EXC_ERROR THEN

2590: G_PKG_NAME, '7800: Leaving Update_Row');
2591: END IF;
2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: /*IF (l_debug = 'Y') THEN
2596: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2597: END IF;*/
2598:

Line 2596: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);

2592:
2593: EXCEPTION
2594: WHEN FND_API.G_EXC_ERROR THEN
2595: /*IF (l_debug = 'Y') THEN
2596: Okc_Debug.Log('7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception', 2);
2597: END IF;*/
2598:
2599: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2600: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2601: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );

2597: END IF;*/
2598:
2599: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2600: FND_LOG.STRING(G_EXCP_LEVEL,
2601: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
2602: END IF;
2603: x_return_status := G_RET_STS_ERROR;
2604:
2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2601: G_PKG_NAME, '7900: Leaving Update_Row:FND_API.G_EXC_ERROR Exception' );
2602: END IF;
2603: x_return_status := G_RET_STS_ERROR;
2604:
2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2606: /*IF (l_debug = 'Y') THEN
2607: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2608: END IF;*/
2609:

Line 2607: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2603: x_return_status := G_RET_STS_ERROR;
2604:
2605: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2606: /*IF (l_debug = 'Y') THEN
2607: Okc_Debug.Log('8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2608: END IF;*/
2609:
2610: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2611: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2612: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2608: END IF;*/
2609:
2610: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2611: FND_LOG.STRING(G_EXCP_LEVEL,
2612: G_PKG_NAME, '8000: Leaving Update_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2613: END IF;
2614: x_return_status := G_RET_STS_UNEXP_ERROR;
2615:
2616: WHEN OTHERS THEN

Line 2720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2716: p_id => p_id,
2717: p_object_version_number => p_object_version_number
2718: );
2719: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:

Line 2722: RAISE FND_API.G_EXC_ERROR;

2718: );
2719: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2720: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2721: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2722: RAISE FND_API.G_EXC_ERROR;
2723: END IF;
2724:
2725: /*IF (l_debug = 'Y') THEN
2726: Okc_Debug.Log('9100: Removing _B row', 2);

Line 2735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;

2731: G_PKG_NAME, '9100: Removing _B row');
2732: END IF;
2733: x_return_status := Delete_Row( p_id => p_id );
2734: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2736: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739:

Line 2737: RAISE FND_API.G_EXC_ERROR;

2733: x_return_status := Delete_Row( p_id => p_id );
2734: IF (x_return_status = G_RET_STS_UNEXP_ERROR) THEN
2735: RAISE FND_API.G_EXC_UNEXPECTED_ERROR;
2736: ELSIF (x_return_status = G_RET_STS_ERROR) THEN
2737: RAISE FND_API.G_EXC_ERROR;
2738: END IF;
2739:
2740: /*IF (l_debug = 'Y') THEN
2741: Okc_Debug.Log('9300: Leaving Delete_Row', 2);

Line 2750: WHEN FND_API.G_EXC_ERROR THEN

2746: G_PKG_NAME, '9300: Leaving Delete_Row');
2747: END IF;
2748:
2749: EXCEPTION
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: /*IF (l_debug = 'Y') THEN
2752: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2753: END IF;*/
2754:

Line 2752: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);

2748:
2749: EXCEPTION
2750: WHEN FND_API.G_EXC_ERROR THEN
2751: /*IF (l_debug = 'Y') THEN
2752: Okc_Debug.Log('9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception', 2);
2753: END IF;*/
2754:
2755: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2756: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2757: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );

2753: END IF;*/
2754:
2755: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2756: FND_LOG.STRING(G_EXCP_LEVEL,
2757: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
2758: END IF;
2759: x_return_status := G_RET_STS_ERROR;
2760:
2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

Line 2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2757: G_PKG_NAME, '9400: Leaving Delete_Row:FND_API.G_EXC_ERROR Exception' );
2758: END IF;
2759: x_return_status := G_RET_STS_ERROR;
2760:
2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2762: /*IF (l_debug = 'Y') THEN
2763: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2764: END IF;*/
2765: x_return_status := G_RET_STS_UNEXP_ERROR;

Line 2763: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2759: x_return_status := G_RET_STS_ERROR;
2760:
2761: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2762: /*IF (l_debug = 'Y') THEN
2763: Okc_Debug.Log('9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2764: END IF;*/
2765: x_return_status := G_RET_STS_UNEXP_ERROR;
2766:
2767: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN

Line 2769: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2765: x_return_status := G_RET_STS_UNEXP_ERROR;
2766:
2767: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2768: FND_LOG.STRING(G_EXCP_LEVEL,
2769: G_PKG_NAME, '9500: Leaving Delete_Row:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2770: END IF;
2771:
2772: WHEN OTHERS THEN
2773: /*IF (l_debug = 'Y') THEN

Line 2845: WHEN FND_API.G_EXC_ERROR THEN

2841: END IF;
2842: Okc_Api.Set_Message( G_FND_APP, G_UNABLE_TO_RESERVE_REC);
2843: x_return_status := G_RET_STS_ERROR ;
2844:
2845: WHEN FND_API.G_EXC_ERROR THEN
2846: /*IF (l_debug = 'Y') THEN
2847: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2848: END IF;*/
2849:

Line 2847: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);

2843: x_return_status := G_RET_STS_ERROR ;
2844:
2845: WHEN FND_API.G_EXC_ERROR THEN
2846: /*IF (l_debug = 'Y') THEN
2847: Okc_Debug.Log('11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception', 2);
2848: END IF;*/
2849:
2850: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2851: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2852: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );

2848: END IF;*/
2849:
2850: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2851: FND_LOG.STRING(G_EXCP_LEVEL,
2852: G_PKG_NAME, '11100: Leaving Delete_Set:FND_API.G_EXC_ERROR Exception' );
2853: END IF;
2854:
2855: IF (lock_csr%ISOPEN) THEN
2856: CLOSE lock_csr;

Line 2860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN

2856: CLOSE lock_csr;
2857: END IF;
2858: x_return_status := G_RET_STS_ERROR;
2859:
2860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2861: /*IF (l_debug = 'Y') THEN
2862: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2863: END IF;*/
2864:

Line 2862: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);

2858: x_return_status := G_RET_STS_ERROR;
2859:
2860: WHEN FND_API.G_EXC_UNEXPECTED_ERROR THEN
2861: /*IF (l_debug = 'Y') THEN
2862: Okc_Debug.Log('11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception', 2);
2863: END IF;*/
2864:
2865: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2866: FND_LOG.STRING(G_EXCP_LEVEL,

Line 2867: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );

2863: END IF;*/
2864:
2865: IF ( G_EXCP_LEVEL >= G_DBG_LEVEL ) THEN
2866: FND_LOG.STRING(G_EXCP_LEVEL,
2867: G_PKG_NAME, '11200: Leaving Delete_Set:FND_API.G_EXC_UNEXPECTED_ERROR Exception' );
2868: END IF;
2869:
2870: IF (lock_csr%ISOPEN) THEN
2871: CLOSE lock_csr;