APPS.OKL_ART_PVT dependencies on OKL_API

Line 231: IF (p_artv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND

227: l_return_status VARCHAR2(3) := OKC_API.G_TRUE;
228: BEGIN
229: -- initialize return status
230: x_return_status := OKC_API.G_RET_STS_SUCCESS;
231: IF (p_artv_rec.currency_conversion_type <> OKL_API.G_MISS_CHAR AND
232: p_artv_rec.currency_conversion_type IS NOT NULL) THEN
233: -- check from currency values using the generic okl_util.validate_currency_code
234: l_return_status := OKL_ACCOUNTING_UTIL.validate_currency_con_type(p_artv_rec.currency_conversion_type);
235: IF (l_return_status <> OKC_API.G_TRUE) THEN

Line 515: OKL_API.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');

511: RAISE G_EXCEPTION_HALT_VALIDATION;
512: ELSE
513: l_dummy_var := OKL_LEGAL_ENTITY_UTIL.check_le_id_exists(p_artv_rec.legal_entity_id);
514: IF (l_dummy_var <> 1) THEN
515: OKL_API.SET_MESSAGE(G_APP_NAME, G_INVALID_VALUE, G_COL_NAME_TOKEN, 'LEGAL_ENTITY_ID');
516: RAISE G_EXCEPTION_HALT_VALIDATION;
517: END IF;
518: END IF;
519:

Line 524: x_return_status := OKL_API.G_RET_STS_ERROR;

520: EXCEPTION
521: WHEN G_EXCEPTION_HALT_VALIDATION then
522: -- no processing necessary; validation can continue
523: -- with the next column
524: x_return_status := OKL_API.G_RET_STS_ERROR;
525:
526: WHEN OTHERS then
527: -- store SQL error message on message stack for caller
528: OKC_API.SET_MESSAGE(p_app_name => g_app_name,

Line 1504: OKL_API.SET_MESSAGE( p_app_name => 'OKL'

1500: FETCH okl_get_meaning_csr INTO l_meaning;
1501: CLOSE okl_get_meaning_csr;
1502:
1503: -- Cannot update a cancelled Asset Return.
1504: OKL_API.SET_MESSAGE( p_app_name => 'OKL'
1505: ,p_msg_name => 'OKL_AM_ASS_RET_UPD_ERR'
1506: ,p_token1 => 'STATUS'
1507: ,p_token1_value => l_meaning);
1508: -- notify caller of an error

Line 1526: OKL_API.SET_MESSAGE( p_app_name => 'OKL'

1522: FETCH okl_get_asset_name_csr INTO l_asset_name;
1523: CLOSE okl_get_asset_name_csr;
1524:
1525: -- Asset Return already exists for this asset NAME with the status STATUS so cannot create a new asset return now.
1526: OKL_API.SET_MESSAGE( p_app_name => 'OKL'
1527: ,p_msg_name => 'OKL_AM_ASS_RET_ARS_ERR'
1528: ,p_token1 => 'NAME'
1529: ,p_token1_value => l_asset_name
1530: ,p_token2 => 'STATUS'

Line 1553: OKL_API.SET_MESSAGE( p_app_name => 'OKL'

1549: FETCH okl_get_asset_name_csr INTO l_asset_name;
1550: CLOSE okl_get_asset_name_csr;
1551:
1552: -- Asset Return already exists for this asset NAME with the status STATUS so cannot create a new asset return now.
1553: OKL_API.SET_MESSAGE( p_app_name => 'OKL'
1554: ,p_msg_name => 'OKL_AM_ASS_RET_ARS_ERR'
1555: ,p_token1 => 'NAME'
1556: ,p_token1_value => l_asset_name
1557: ,p_token2 => 'STATUS'

Line 2574: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2570: -- End of comments
2571: FUNCTION Validate_Record (
2572: p_artv_rec IN artv_rec_type
2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2575: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2576: BEGIN
2577:
2578: -- check uniqueness

Line 2575: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;

2571: FUNCTION Validate_Record (
2572: p_artv_rec IN artv_rec_type
2573: ) RETURN VARCHAR2 IS
2574: l_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2575: x_return_status VARCHAR2(1) := OKL_API.G_RET_STS_SUCCESS;
2576: BEGIN
2577:
2578: -- check uniqueness
2579: is_unique(p_artv_rec,l_return_status);

Line 2582: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN

2578: -- check uniqueness
2579: is_unique(p_artv_rec,l_return_status);
2580:
2581: -- store the highest degree of error
2582: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2583: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2584: x_return_status := l_return_status;
2585: END IF;
2586: END IF;

Line 2583: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN

2579: is_unique(p_artv_rec,l_return_status);
2580:
2581: -- store the highest degree of error
2582: IF (l_return_status <> OKL_API.G_RET_STS_SUCCESS) THEN
2583: IF (x_return_status <> OKL_API.G_RET_STS_UNEXP_ERROR) THEN
2584: x_return_status := l_return_status;
2585: END IF;
2586: END IF;
2587:

Line 2604: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME

2600: RETURN (x_return_status);
2601: EXCEPTION
2602: WHEN OTHERS THEN
2603: -- store SQL error message on message stack for caller
2604: OKL_API.SET_MESSAGE( p_app_name => G_APP_NAME
2605: ,p_msg_name => G_UNEXPECTED_ERROR
2606: ,p_token1 => G_SQLCODE_TOKEN
2607: ,p_token1_value => sqlcode
2608: ,p_token2 => G_SQLERRM_TOKEN

Line 2612: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;

2608: ,p_token2 => G_SQLERRM_TOKEN
2609: ,p_token2_value => sqlerrm);
2610:
2611: --notify caller of an UNEXPECTED error
2612: x_return_status := OKL_API.G_RET_STS_UNEXP_ERROR;
2613:
2614: --return status to caller
2615: RETURN x_return_status;
2616: END Validate_Record;