DBA Data[Home] [Help]

APPS.OKL_ICP_PVT dependencies on OKC_API

Line 605: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN

601: END IF;
602: l_return_status := OKL_UTIL.check_lookup_code(
603: p_lookup_type => 'OKL_PRC_STATUS',
604: p_lookup_code => p_sts_code);
605: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
607: p_msg_name => g_invalid_value,
608: p_token1 => g_col_name_token,
609: p_token1_value => 'sts_code');

Line 606: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

602: l_return_status := OKL_UTIL.check_lookup_code(
603: p_lookup_type => 'OKL_PRC_STATUS',
604: p_lookup_code => p_sts_code);
605: IF (l_return_status = OKC_API.G_RET_STS_ERROR) THEN
606: OKC_API.SET_MESSAGE(p_app_name => g_app_name,
607: p_msg_name => g_invalid_value,
608: p_token1 => g_col_name_token,
609: p_token1_value => 'sts_code');
610: -- notify caller of an error

Line 612: ELSIF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN

608: p_token1 => g_col_name_token,
609: p_token1_value => 'sts_code');
610: -- notify caller of an error
611: raise OKL_API.G_EXCEPTION_ERROR;
612: ELSIF (l_return_status = OKC_API.G_RET_STS_UNEXP_ERROR) THEN
613: -- notify caller of an error
614: raise OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;
615: END IF;
616:

Line 1003: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

999: -- validate_row (REC)
1000: ---------------------
1001: PROCEDURE validate_row(
1002: p_api_version IN NUMBER,
1003: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1004: x_return_status OUT NOCOPY VARCHAR2,
1005: x_msg_count OUT NOCOPY NUMBER,
1006: x_msg_data OUT NOCOPY VARCHAR2,
1007: p_icpv_rec IN icpv_rec_type) IS

Line 1061: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1057: -- validate_row (TBL)
1058: ---------------------
1059: PROCEDURE validate_row(
1060: p_api_version IN NUMBER,
1061: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1062: x_return_status OUT NOCOPY VARCHAR2,
1063: x_msg_count OUT NOCOPY NUMBER,
1064: x_msg_data OUT NOCOPY VARCHAR2,
1065: p_icpv_tbl IN icpv_tbl_type) IS

Line 1137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1133: -- insert_row (REC)
1134: -------------------
1135: PROCEDURE insert_row(
1136: p_api_version IN NUMBER,
1137: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1138: x_return_status OUT NOCOPY VARCHAR2,
1139: x_msg_count OUT NOCOPY NUMBER,
1140: x_msg_data OUT NOCOPY VARCHAR2,
1141: p_icpv_rec IN icpv_rec_type,

Line 1275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1271: -- insert_row (TBL)
1272: -------------------
1273: PROCEDURE insert_row(
1274: p_api_version IN NUMBER,
1275: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1276: x_return_status OUT NOCOPY VARCHAR2,
1277: x_msg_count OUT NOCOPY NUMBER,
1278: x_msg_data OUT NOCOPY VARCHAR2,
1279: p_icpv_tbl IN icpv_tbl_type,

Line 1349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1345: -- lock_row (REC)
1346: -----------------
1347: PROCEDURE lock_row(
1348: p_api_version IN NUMBER,
1349: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1350: x_return_status OUT NOCOPY VARCHAR2,
1351: x_msg_count OUT NOCOPY NUMBER,
1352: x_msg_data OUT NOCOPY VARCHAR2,
1353: p_icpv_rec IN icpv_rec_type) IS

Line 1391: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);

1387: WHEN E_Resource_Busy THEN
1388: IF (lock_csr%ISOPEN) THEN
1389: CLOSE lock_csr;
1390: END IF;
1391: OKC_API.set_message(G_FND_APP,G_FORM_UNABLE_TO_RESERVE_REC);
1392: RAISE APP_EXCEPTIONS.RECORD_LOCK_EXCEPTION;
1393: END;
1394:
1395: IF ( l_row_notfound ) THEN

Line 1402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);

1398: lc_row_notfound := lchk_csr%NOTFOUND;
1399: CLOSE lchk_csr;
1400: END IF;
1401: IF (lc_row_notfound) THEN
1402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: ELSIF lc_object_version_number > p_icpv_rec.object_version_number THEN
1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1403: RAISE OKC_API.G_EXCEPTION_ERROR;

1399: CLOSE lchk_csr;
1400: END IF;
1401: IF (lc_row_notfound) THEN
1402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: ELSIF lc_object_version_number > p_icpv_rec.object_version_number THEN
1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN

Line 1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1401: IF (lc_row_notfound) THEN
1402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: ELSIF lc_object_version_number > p_icpv_rec.object_version_number THEN
1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN
1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1406: RAISE OKC_API.G_EXCEPTION_ERROR;

1402: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_DELETED);
1403: RAISE OKC_API.G_EXCEPTION_ERROR;
1404: ELSIF lc_object_version_number > p_icpv_rec.object_version_number THEN
1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN
1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;
1410: ELSIF lc_object_version_number = -1 THEN

Line 1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);

1404: ELSIF lc_object_version_number > p_icpv_rec.object_version_number THEN
1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN
1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;
1410: ELSIF lc_object_version_number = -1 THEN
1411: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1412: RAISE OKC_API.G_EXCEPTION_ERROR;

Line 1409: RAISE OKC_API.G_EXCEPTION_ERROR;

1405: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1406: RAISE OKC_API.G_EXCEPTION_ERROR;
1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN
1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;
1410: ELSIF lc_object_version_number = -1 THEN
1411: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;

Line 1411: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);

1407: ELSIF lc_object_version_number <> p_icpv_rec.object_version_number THEN
1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;
1410: ELSIF lc_object_version_number = -1 THEN
1411: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414:
1415: x_return_status := l_return_status;

Line 1412: RAISE OKC_API.G_EXCEPTION_ERROR;

1408: OKC_API.set_message(G_FND_APP,G_FORM_RECORD_CHANGED);
1409: RAISE OKC_API.G_EXCEPTION_ERROR;
1410: ELSIF lc_object_version_number = -1 THEN
1411: OKC_API.set_message(G_APP_NAME,G_RECORD_LOGICALLY_DELETED);
1412: RAISE OKC_API.G_EXCEPTION_ERROR;
1413: END IF;
1414:
1415: x_return_status := l_return_status;
1416:

Line 1448: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1444: -- lock_row (TBL)
1445: -----------------
1446: PROCEDURE lock_row(
1447: p_api_version IN NUMBER,
1448: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1449: x_return_status OUT NOCOPY VARCHAR2,
1450: x_msg_count OUT NOCOPY NUMBER,
1451: x_msg_data OUT NOCOPY VARCHAR2,
1452: p_icpv_tbl IN icpv_tbl_type) IS

Line 1523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1519: -- update_row for:OKL_ITM_CAT_RV_PRCS_V --
1520: ------------------------------------------
1521: PROCEDURE update_row(
1522: p_api_version IN NUMBER,
1523: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1524: x_return_status OUT NOCOPY VARCHAR2,
1525: x_msg_count OUT NOCOPY NUMBER,
1526: x_msg_data OUT NOCOPY VARCHAR2,
1527: p_icpv_rec IN icpv_rec_type,

Line 1786: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1782: -- update_row (TBL)
1783: -------------------
1784: PROCEDURE update_row(
1785: p_api_version IN NUMBER,
1786: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1787: x_return_status OUT NOCOPY VARCHAR2,
1788: x_msg_count OUT NOCOPY NUMBER,
1789: x_msg_data OUT NOCOPY VARCHAR2,
1790: p_icpv_tbl IN icpv_tbl_type,

Line 1862: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1858: -- delete_row (REC)
1859: -------------------
1860: PROCEDURE delete_row(
1861: p_api_version IN NUMBER,
1862: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1863: x_return_status OUT NOCOPY VARCHAR2,
1864: x_msg_count OUT NOCOPY NUMBER,
1865: x_msg_data OUT NOCOPY VARCHAR2,
1866: p_icpv_rec IN icpv_rec_type) IS

Line 1906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,

1902: -- delete_row (TBL)
1903: -------------------
1904: PROCEDURE delete_row(
1905: p_api_version IN NUMBER,
1906: p_init_msg_list IN VARCHAR2 DEFAULT OKC_API.G_FALSE,
1907: x_return_status OUT NOCOPY VARCHAR2,
1908: x_msg_count OUT NOCOPY NUMBER,
1909: x_msg_data OUT NOCOPY VARCHAR2,
1910: p_icpv_tbl IN icpv_tbl_type) IS