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.IEX_IEA_PVT dependencies on OKL_API

Line 9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,

5: ---------------------------------------------------------------------------
6: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7:
8: PROCEDURE load_error_tbl (
9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
11:
12: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
13: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;

Line 10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

6: PG_DEBUG NUMBER(2) := TO_NUMBER(NVL(FND_PROFILE.value('IEX_DEBUG_LEVEL'), '20'));
7:
8: PROCEDURE load_error_tbl (
9: px_error_rec IN OUT NOCOPY OKL_API.ERROR_REC_TYPE,
10: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
11:
12: j INTEGER := NVL(px_error_tbl.LAST, 0) + 1;
13: last_msg_idx INTEGER := FND_MSG_PUB.COUNT_MSG;
14: l_msg_idx INTEGER := FND_MSG_PUB.G_NEXT;

Line 42: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.

38: ---------------------------------------------------------------------------
39: -- FUNCTION find_highest_exception
40: ---------------------------------------------------------------------------
41: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
42: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
43: FUNCTION find_highest_exception(
44: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
45: ) RETURN VARCHAR2 AS
46: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

Line 44: p_error_tbl IN OKL_API.ERROR_TBL_TYPE

40: ---------------------------------------------------------------------------
41: -- Finds the highest exception (G_RET_STS_UNEXP_ERROR)
42: -- in a OKL_API.ERROR_TBL_TYPE, and returns it.
43: FUNCTION find_highest_exception(
44: p_error_tbl IN OKL_API.ERROR_TBL_TYPE
45: ) RETURN VARCHAR2 AS
46: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
47: i INTEGER := 1;
48: BEGIN

Line 1012: OKL_API.set_message('IEX', G_INVALID_DATE_RANGE);

1008: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1009: BEGIN
1010: IF(p_ieav_rec.effective_end_date IS NOT NULL AND p_ieav_rec.effective_end_date <> OKC_API.G_MISS_DATE) THEN
1011: IF(p_ieav_rec.effective_start_date > p_ieav_rec.effective_end_date) THEN
1012: OKL_API.set_message('IEX', G_INVALID_DATE_RANGE);
1013: l_return_status := OKC_API.G_RET_STS_ERROR;
1014: END IF;
1015: END IF;
1016:

Line 1227: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

1223: x_return_status OUT NOCOPY VARCHAR2,
1224: x_msg_count OUT NOCOPY NUMBER,
1225: x_msg_data OUT NOCOPY VARCHAR2,
1226: p_ieav_tbl IN ieav_tbl_type,
1227: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1228:
1229: l_api_version CONSTANT NUMBER := 1;
1230: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_validate_row';
1231: i NUMBER := 0;

Line 1239: l_error_rec OKL_API.ERROR_REC_TYPE;

1235: IF (p_ieav_tbl.COUNT > 0) THEN
1236: i := p_ieav_tbl.FIRST;
1237: LOOP
1238: DECLARE
1239: l_error_rec OKL_API.ERROR_REC_TYPE;
1240: BEGIN
1241: l_error_rec.api_name := l_api_name;
1242: l_error_rec.api_package := G_PKG_NAME;
1243: l_error_rec.idx := i;

Line 1327: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1323:
1324: l_api_version CONSTANT NUMBER := 1;
1325: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_validate_row';
1326: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1327: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1328: BEGIN
1329: OKC_API.init_msg_list(p_init_msg_list);
1330: -- Make sure PL/SQL table has records in it before passing
1331: IF (p_ieav_tbl.COUNT > 0) THEN

Line 1813: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

1809: x_msg_count OUT NOCOPY NUMBER,
1810: x_msg_data OUT NOCOPY VARCHAR2,
1811: p_ieav_tbl IN ieav_tbl_type,
1812: x_ieav_tbl OUT NOCOPY ieav_tbl_type,
1813: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
1814:
1815: l_api_version CONSTANT NUMBER := 1;
1816: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_insert_row';
1817: i NUMBER := 0;

Line 1825: l_error_rec OKL_API.ERROR_REC_TYPE;

1821: IF (p_ieav_tbl.COUNT > 0) THEN
1822: i := p_ieav_tbl.FIRST;
1823: LOOP
1824: DECLARE
1825: l_error_rec OKL_API.ERROR_REC_TYPE;
1826: BEGIN
1827: l_error_rec.api_name := l_api_name;
1828: l_error_rec.api_package := G_PKG_NAME;
1829: l_error_rec.idx := i;

Line 1915: l_error_tbl OKL_API.ERROR_TBL_TYPE;

1911:
1912: l_api_version CONSTANT NUMBER := 1;
1913: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_insert_row';
1914: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1915: l_error_tbl OKL_API.ERROR_TBL_TYPE;
1916: BEGIN
1917: OKC_API.init_msg_list(p_init_msg_list);
1918: -- Make sure PL/SQL table has records in it before passing
1919: IF (p_ieav_tbl.COUNT > 0) THEN

Line 2265: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

2261: x_return_status OUT NOCOPY VARCHAR2,
2262: x_msg_count OUT NOCOPY NUMBER,
2263: x_msg_data OUT NOCOPY VARCHAR2,
2264: p_ieav_tbl IN ieav_tbl_type,
2265: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
2266:
2267: l_api_version CONSTANT NUMBER := 1;
2268: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_lock_row';
2269: i NUMBER := 0;

Line 2277: l_error_rec OKL_API.ERROR_REC_TYPE;

2273: IF (p_ieav_tbl.COUNT > 0) THEN
2274: i := p_ieav_tbl.FIRST;
2275: LOOP
2276: DECLARE
2277: l_error_rec OKL_API.ERROR_REC_TYPE;
2278: BEGIN
2279: l_error_rec.api_name := l_api_name;
2280: l_error_rec.api_package := G_PKG_NAME;
2281: l_error_rec.idx := i;

Line 2364: l_error_tbl OKL_API.ERROR_TBL_TYPE;

2360:
2361: l_api_version CONSTANT NUMBER := 1;
2362: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_lock_row';
2363: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
2364: l_error_tbl OKL_API.ERROR_TBL_TYPE;
2365: BEGIN
2366: OKC_API.init_msg_list(p_init_msg_list);
2367: -- Make sure PL/SQL table has recrods in it before passing
2368: IF (p_ieav_tbl.COUNT > 0) THEN

Line 3179: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

3175: x_msg_count OUT NOCOPY NUMBER,
3176: x_msg_data OUT NOCOPY VARCHAR2,
3177: p_ieav_tbl IN ieav_tbl_type,
3178: x_ieav_tbl OUT NOCOPY ieav_tbl_type,
3179: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3180:
3181: l_api_version CONSTANT NUMBER := 1;
3182: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_update_row';
3183: i NUMBER := 0;

Line 3191: l_error_rec OKL_API.ERROR_REC_TYPE;

3187: IF (p_ieav_tbl.COUNT > 0) THEN
3188: i := p_ieav_tbl.FIRST;
3189: LOOP
3190: DECLARE
3191: l_error_rec OKL_API.ERROR_REC_TYPE;
3192: BEGIN
3193: l_error_rec.api_name := l_api_name;
3194: l_error_rec.api_package := G_PKG_NAME;
3195: l_error_rec.idx := i;

Line 3281: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3277:
3278: l_api_version CONSTANT NUMBER := 1;
3279: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_update_row';
3280: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3281: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3282: BEGIN
3283: OKC_API.init_msg_list(p_init_msg_list);
3284: -- Make sure PL/SQL table has records in it before passing
3285: IF (p_ieav_tbl.COUNT > 0) THEN

Line 3565: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS

3561: x_return_status OUT NOCOPY VARCHAR2,
3562: x_msg_count OUT NOCOPY NUMBER,
3563: x_msg_data OUT NOCOPY VARCHAR2,
3564: p_ieav_tbl IN ieav_tbl_type,
3565: px_error_tbl IN OUT NOCOPY OKL_API.ERROR_TBL_TYPE) AS
3566:
3567: l_api_version CONSTANT NUMBER := 1;
3568: l_api_name CONSTANT VARCHAR2(30) := 'V_error_tbl_delete_row';
3569: i NUMBER := 0;

Line 3577: l_error_rec OKL_API.ERROR_REC_TYPE;

3573: IF (p_ieav_tbl.COUNT > 0) THEN
3574: i := p_ieav_tbl.FIRST;
3575: LOOP
3576: DECLARE
3577: l_error_rec OKL_API.ERROR_REC_TYPE;
3578: BEGIN
3579: l_error_rec.api_name := l_api_name;
3580: l_error_rec.api_package := G_PKG_NAME;
3581: l_error_rec.idx := i;

Line 3665: l_error_tbl OKL_API.ERROR_TBL_TYPE;

3661:
3662: l_api_version CONSTANT NUMBER := 1;
3663: l_api_name CONSTANT VARCHAR2(30) := 'V_tbl_delete_row';
3664: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
3665: l_error_tbl OKL_API.ERROR_TBL_TYPE;
3666: BEGIN
3667: OKC_API.init_msg_list(p_init_msg_list);
3668: -- Make sure PL/SQL table has records in it before passing
3669: IF (p_ieav_tbl.COUNT > 0) THEN