DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_API

Line 1929: (p_assn_tbl(i).p_asset_id = OKC_API.G_MISS_NUM)) THEN

1925: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'p_assn_tbl('||i||').'||'p_quote_qty :'|| p_assn_tbl(i).p_quote_qty );
1926: OKL_DEBUG_PUB.LOG_DEBUG(G_LEVEL_PROCEDURE,L_MODULE_NAME,'p_assn_tbl('||i||').'||'p_split_asset_number :'|| p_assn_tbl(i).p_split_asset_number);
1927: END IF;
1928: IF ((p_assn_tbl(i).p_asset_id IS NULL) OR
1929: (p_assn_tbl(i).p_asset_id = OKC_API.G_MISS_NUM)) THEN
1930: x_return_status := OKL_API.G_RET_STS_ERROR;
1931: --Quotes are not allowed for contracts without assets.
1932: OKC_API.SET_MESSAGE (
1933: p_app_name => 'OKL'

Line 1932: OKC_API.SET_MESSAGE (

1928: IF ((p_assn_tbl(i).p_asset_id IS NULL) OR
1929: (p_assn_tbl(i).p_asset_id = OKC_API.G_MISS_NUM)) THEN
1930: x_return_status := OKL_API.G_RET_STS_ERROR;
1931: --Quotes are not allowed for contracts without assets.
1932: OKC_API.SET_MESSAGE (
1933: p_app_name => 'OKL'
1934: ,p_msg_name => 'OKL_AM_NO_ASSETS_FOR_QUOTE');
1935: RAISE G_EXCEPTION_HALT_VALIDATION;
1936: END IF;

Line 1947: OKC_API.SET_MESSAGE (

1943: FETCH l_clines_csr INTO l_chr_id, l_l_start_date; -- rmunjulu EDAT
1944: IF l_clines_csr%NOTFOUND THEN
1945: x_return_status := OKL_API.G_RET_STS_ERROR;
1946: -- invalid asset id
1947: OKC_API.SET_MESSAGE (
1948: p_app_name => 'OKC'
1949: ,p_msg_name => G_INVALID_VALUE
1950: ,p_token1 => G_COL_NAME_TOKEN
1951: ,p_token1_value => 'asset_id');

Line 1956: OKC_API.SET_MESSAGE (

1952: RAISE G_EXCEPTION_HALT_VALIDATION;
1953: ELSIF (l_chr_id <> p_quot_rec.khr_id) OR (l_chr_id = 1) THEN
1954: x_return_status := OKL_API.G_RET_STS_ERROR;
1955: --Asset ASSET_NUMBER does not belong to the contract CONTRACT_NUMBER.
1956: OKC_API.SET_MESSAGE (
1957: p_app_name => 'OKL'
1958: ,p_msg_name => 'OKL_AM_CONTRACT_MISMATCH'
1959: ,p_token1 => 'ASSET_NUMBER'
1960: ,p_token1_value => p_assn_tbl(i).p_asset_number,

Line 1969: OR p_assn_tbl(i).p_asset_number = OKC_API.G_MISS_CHAR THEN

1965: CLOSE l_clines_csr;
1966:
1967: -- SECHAWLA Bug #2680542 : Added code to populate asset number if it is null
1968: IF p_assn_tbl(i).p_asset_number IS NULL
1969: OR p_assn_tbl(i).p_asset_number = OKC_API.G_MISS_CHAR THEN
1970: OPEN l_linesfull_csr(p_assn_tbl(i).p_asset_id);
1971: FETCH l_linesfull_csr INTO l_name;
1972: CLOSE l_linesfull_csr;
1973:

Line 1979: (p_assn_tbl(i).p_asset_qty = OKC_API.G_MISS_NUM)) THEN

1975: END IF;
1976:
1977: -- SECHAWLA Bug #2680542 : Added code to populate asset qty and quote qty, if null
1978: IF ((p_assn_tbl(i).p_asset_qty IS NULL) OR
1979: (p_assn_tbl(i).p_asset_qty = OKC_API.G_MISS_NUM)) THEN
1980: l_asset_qty := okl_am_util_pvt.get_asset_quantity(p_assn_tbl(i).p_asset_id);
1981: IF l_asset_qty IS NULL THEN
1982: x_return_status := OKL_API.G_RET_STS_ERROR;
1983: -- Can not create quote because the asset quantity is missing.

Line 1984: OKC_API.SET_MESSAGE (

1980: l_asset_qty := okl_am_util_pvt.get_asset_quantity(p_assn_tbl(i).p_asset_id);
1981: IF l_asset_qty IS NULL THEN
1982: x_return_status := OKL_API.G_RET_STS_ERROR;
1983: -- Can not create quote because the asset quantity is missing.
1984: OKC_API.SET_MESSAGE (
1985: p_app_name => 'OKL'
1986: ,p_msg_name => 'OKL_AM_NO_ASSET_QTY',
1987: p_token1 => 'ASSET_NUMBER',
1988: p_token1_value => p_assn_tbl(i).p_asset_number);

Line 1997: (p_assn_tbl(i).p_quote_qty = OKC_API.G_MISS_NUM)) THEN

1993: END IF;
1994:
1995:
1996: IF ((p_assn_tbl(i).p_quote_qty IS NULL) OR
1997: (p_assn_tbl(i).p_quote_qty = OKC_API.G_MISS_NUM)) THEN
1998: p_assn_tbl(i).p_quote_qty := p_assn_tbl(i).p_asset_qty;
1999: END IF;
2000:
2001:

Line 2022: OKC_API.SET_MESSAGE (

2018: -- SECHAWLA Bug #2680542 : Added code to validate quote quantity
2019: IF p_assn_tbl(i).p_quote_qty > p_assn_tbl(i).p_asset_qty THEN
2020: x_return_status := OKL_API.G_RET_STS_ERROR;
2021: -- Asset ASSET_NUMBER quantity is less than the specified quote quantity.
2022: OKC_API.SET_MESSAGE (
2023: p_app_name => 'OKL'
2024: ,p_msg_name => 'OKL_AM_INVALID_QUOTE_QTY',
2025: p_token1 => 'ASSET_NUMBER',
2026: p_token1_value => p_assn_tbl(i).p_asset_number);

Line 2499: OKC_API.SET_MESSAGE (

2495: END LOOP;
2496: ELSE
2497: x_return_status := OKL_API.G_RET_STS_ERROR;
2498: --Quotes are not allowed for contracts without assets.
2499: OKC_API.SET_MESSAGE (
2500: p_app_name => 'OKL'
2501: ,p_msg_name => 'OKL_AM_NO_ASSETS_FOR_QUOTE');
2502: RAISE G_EXCEPTION_HALT_VALIDATION;
2503: END IF;

Line 2512: OKC_API.SET_MESSAGE (

2508: --SECHAWLA 17-FEB-03 Bug 2804703 : Added the following validation
2509: IF l_sts_code = 'EVERGREEN' AND (l_partial_asset_line) THEN
2510: x_return_status := OKL_API.G_RET_STS_ERROR;
2511: -- Unable to create quote with partial asset quantities for Evergreen contract CONTRACT_NUMBER.
2512: OKC_API.SET_MESSAGE (
2513: p_app_name => 'OKL'
2514: ,p_msg_name => 'OKL_AM_PARTIAL_LINE_EVERGREEN',
2515: p_token1 => 'CONTRACT_NUMBER',
2516: p_token1_value => l_contract_number);

Line 3346: OKC_API.set_message( p_app_name => 'OKL',

3342: x_return_status := OKL_API.G_RET_STS_ERROR;
3343: -- SECHAWLA 14-APR-03 2902588 : Use the following message instead of the standard REQUIRED message
3344:
3345: --Unable to create quote because the contract CONTRACT_NUMBER does not have an associated vendor program.
3346: OKC_API.set_message( p_app_name => 'OKL',
3347: p_msg_name => 'OKL_AM_NO_VENDOR_PROGRAM',
3348: p_token1 => 'CONTRACT_NUMBER',
3349: p_token1_value => l_contract_number);
3350: RAISE OKL_API.G_EXCEPTION_ERROR;