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.OKL_SID_PVT dependencies on OKC_API

Line 1421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1417: -- insert_row for: OKL_SUPP_INVOICE_DTLS_H --
1418: --------------------------------------------------
1419: PROCEDURE insert_row(
1420: p_api_version IN NUMBER,
1421: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1422: x_return_status OUT NOCOPY VARCHAR2,
1423: x_msg_count OUT NOCOPY NUMBER,
1424: x_msg_data OUT NOCOPY VARCHAR2,
1425: p_sidh_rec IN okl_sidh_rec_type,

Line 1430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1426: x_sidh_rec OUT NOCOPY okl_sidh_rec_type) IS
1427:
1428: l_api_version CONSTANT NUMBER := 1;
1429: l_api_name CONSTANT VARCHAR2(30) := 'rec_insert_row';
1430: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1431: l_sidh_rec okl_sidh_rec_type := p_sidh_rec;
1432: l_def_sidh_rec okl_sidh_rec_type;
1433: --------------------------------------------------
1434: -- Set_Attributes for: OKL_SUPP_INVOICE_DTLS_H ---

Line 1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;

1436: FUNCTION Set_Attributes (
1437: p_sidh_rec IN okl_sidh_rec_type,
1438: x_sidh_rec OUT NOCOPY okl_sidh_rec_type
1439: ) RETURN VARCHAR2 IS
1440: l_return_status VARCHAR2(1) := OKC_API.G_RET_STS_SUCCESS;
1441: BEGIN
1442: x_sidh_rec := p_sidh_rec;
1443: RETURN(l_return_status);
1444: END Set_Attributes;

Line 1447: l_return_status := OKC_API.START_ACTIVITY(l_api_name,

1443: RETURN(l_return_status);
1444: END Set_Attributes;
1445: BEGIN
1446:
1447: l_return_status := OKC_API.START_ACTIVITY(l_api_name,
1448: p_init_msg_list,
1449: '_PVT',
1450: x_return_status);
1451:

Line 1452: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1448: p_init_msg_list,
1449: '_PVT',
1450: x_return_status);
1451:
1452: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1454: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_ERROR;
1456: END IF;

Line 1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1449: '_PVT',
1450: x_return_status);
1451:
1452: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1454: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_ERROR;
1456: END IF;
1457: --- Setting item attributes

Line 1454: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1450: x_return_status);
1451:
1452: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1454: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_ERROR;
1456: END IF;
1457: --- Setting item attributes
1458: l_return_status := Set_Attributes(

Line 1455: RAISE OKC_API.G_EXCEPTION_ERROR;

1451:
1452: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1453: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1454: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1455: RAISE OKC_API.G_EXCEPTION_ERROR;
1456: END IF;
1457: --- Setting item attributes
1458: l_return_status := Set_Attributes(
1459: p_sidh_rec, -- IN

Line 1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

1458: l_return_status := Set_Attributes(
1459: p_sidh_rec, -- IN
1460: l_sidh_rec); -- OUT
1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;

Line 1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;

1459: p_sidh_rec, -- IN
1460: l_sidh_rec); -- OUT
1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(

Line 1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

1460: l_sidh_rec); -- OUT
1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
1468: id,

Line 1465: RAISE OKC_API.G_EXCEPTION_ERROR;

1461: --- If any errors happen abort API
1462: IF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
1463: RAISE OKC_API.G_EXCEPTION_UNEXPECTED_ERROR;
1464: ELSIF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
1465: RAISE OKC_API.G_EXCEPTION_ERROR;
1466: END IF;
1467: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
1468: id,
1469: object_version_number,

Line 1535: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);

1531: l_sidh_rec.last_update_date,
1532: l_sidh_rec.last_update_login);
1533: -- Set OUT values
1534: x_sidh_rec := l_sidh_rec;
1535: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1536: EXCEPTION
1537: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1538: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1539: (

Line 1537: WHEN OKC_API.G_EXCEPTION_ERROR THEN

1533: -- Set OUT values
1534: x_sidh_rec := l_sidh_rec;
1535: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1536: EXCEPTION
1537: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1538: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1539: (
1540: l_api_name,
1541: G_PKG_NAME,

Line 1538: x_return_status := OKC_API.HANDLE_EXCEPTIONS

1534: x_sidh_rec := l_sidh_rec;
1535: OKC_API.END_ACTIVITY(x_msg_count, x_msg_data);
1536: EXCEPTION
1537: WHEN OKC_API.G_EXCEPTION_ERROR THEN
1538: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1539: (
1540: l_api_name,
1541: G_PKG_NAME,
1542: 'OKC_API.G_RET_STS_ERROR',

Line 1542: 'OKC_API.G_RET_STS_ERROR',

1538: x_return_status := OKC_API.HANDLE_EXCEPTIONS
1539: (
1540: l_api_name,
1541: G_PKG_NAME,
1542: 'OKC_API.G_RET_STS_ERROR',
1543: x_msg_count,
1544: x_msg_data,
1545: '_PVT'
1546: );

Line 1547: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN

1543: x_msg_count,
1544: x_msg_data,
1545: '_PVT'
1546: );
1547: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1548: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1549: (
1550: l_api_name,
1551: G_PKG_NAME,

Line 1548: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1544: x_msg_data,
1545: '_PVT'
1546: );
1547: WHEN OKC_API.G_EXCEPTION_UNEXPECTED_ERROR THEN
1548: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1549: (
1550: l_api_name,
1551: G_PKG_NAME,
1552: 'OKC_API.G_RET_STS_UNEXP_ERROR',

Line 1552: 'OKC_API.G_RET_STS_UNEXP_ERROR',

1548: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1549: (
1550: l_api_name,
1551: G_PKG_NAME,
1552: 'OKC_API.G_RET_STS_UNEXP_ERROR',
1553: x_msg_count,
1554: x_msg_data,
1555: '_PVT'
1556: );

Line 1558: x_return_status :=OKC_API.HANDLE_EXCEPTIONS

1554: x_msg_data,
1555: '_PVT'
1556: );
1557: WHEN OTHERS THEN
1558: x_return_status :=OKC_API.HANDLE_EXCEPTIONS
1559: (
1560: l_api_name,
1561: G_PKG_NAME,
1562: 'OTHERS',

Line 3035: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;

3031: FUNCTION create_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3032: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3033: RETURN VARCHAR2
3034: IS
3035: l_return_status VARCHAR2(1):= OKC_API.G_RET_STS_SUCCESS;
3036: BEGIN
3037: INSERT INTO OKL_SUPP_INVOICE_DTLS_H(
3038: id,
3039: object_version_number,

Line 3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

3106: EXCEPTION
3107: -- other appropriate handlers
3108: WHEN OTHERS THEN
3109: -- store SQL error message on message stack
3110: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3111: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3112: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3113: p_token1_value => sqlcode,
3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3118: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3114: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3115: p_token2_value => sqlerrm);
3116:
3117: -- notify UNEXPECTED error
3118: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3119: return l_return_status;
3120: END create_version;
3121: -----------------------------------------------------------------------------------------------------
3122:

Line 3127: l_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;

3123: FUNCTION restore_version(p_chr_id IN OKC_K_LINES_B.ID%TYPE,
3124: p_major_version IN OKL_SUPP_INVOICE_DTLS_H.MAJOR_VERSION%TYPE)
3125: RETURN VARCHAR2
3126: IS
3127: l_return_status VARCHAR2(3) := OKC_API.G_RET_STS_SUCCESS;
3128: BEGIN
3129: INSERT INTO OKL_SUPP_INVOICE_DTLS(
3130: id,
3131: object_version_number,

Line 3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,

3196: EXCEPTION
3197: -- other appropriate handlers
3198: WHEN OTHERS THEN
3199: -- store SQL error message on message stack
3200: OKC_API.SET_MESSAGE(p_app_name => okc_version_pvt.G_APP_NAME,
3201: p_msg_name => okc_version_pvt.G_UNEXPECTED_ERROR,
3202: p_token1 => okc_version_pvt.G_SQLCODE_TOKEN,
3203: p_token1_value => sqlcode,
3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,

Line 3208: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;

3204: p_token2 => okc_version_pvt.G_SQLERRM_TOKEN,
3205: p_token2_value => sqlerrm);
3206:
3207: -- notify UNEXPECTED error
3208: l_return_status := OKC_API.G_RET_STS_UNEXP_ERROR;
3209: return l_return_status;
3210: END restore_version;
3211: END OKL_SID_PVT;