DBA Data[Home] [Help]

APPS.OKL_AM_CREATE_QUOTE_PVT dependencies on OKC_API

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

1921: 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 );
1922: 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);
1923: END IF;
1924: IF ((p_assn_tbl(i).p_asset_id IS NULL) OR
1925: (p_assn_tbl(i).p_asset_id = OKC_API.G_MISS_NUM)) THEN
1926: x_return_status := OKL_API.G_RET_STS_ERROR;
1927: --Quotes are not allowed for contracts without assets.
1928: OKC_API.SET_MESSAGE (
1929: p_app_name => 'OKL'

Line 1928: OKC_API.SET_MESSAGE (

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

Line 1943: OKC_API.SET_MESSAGE (

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

Line 1952: OKC_API.SET_MESSAGE (

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

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

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

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

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

Line 1980: OKC_API.SET_MESSAGE (

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

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

1989: END IF;
1990:
1991:
1992: IF ((p_assn_tbl(i).p_quote_qty IS NULL) OR
1993: (p_assn_tbl(i).p_quote_qty = OKC_API.G_MISS_NUM)) THEN
1994: p_assn_tbl(i).p_quote_qty := p_assn_tbl(i).p_asset_qty;
1995: END IF;
1996:
1997:

Line 2018: OKC_API.SET_MESSAGE (

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

Line 2445: OKC_API.SET_MESSAGE (

2441: END LOOP;
2442: ELSE
2443: x_return_status := OKL_API.G_RET_STS_ERROR;
2444: --Quotes are not allowed for contracts without assets.
2445: OKC_API.SET_MESSAGE (
2446: p_app_name => 'OKL'
2447: ,p_msg_name => 'OKL_AM_NO_ASSETS_FOR_QUOTE');
2448: RAISE G_EXCEPTION_HALT_VALIDATION;
2449: END IF;

Line 2458: OKC_API.SET_MESSAGE (

2454: --SECHAWLA 17-FEB-03 Bug 2804703 : Added the following validation
2455: IF l_sts_code = 'EVERGREEN' AND (l_partial_asset_line) THEN
2456: x_return_status := OKL_API.G_RET_STS_ERROR;
2457: -- Unable to create quote with partial asset quantities for Evergreen contract CONTRACT_NUMBER.
2458: OKC_API.SET_MESSAGE (
2459: p_app_name => 'OKL'
2460: ,p_msg_name => 'OKL_AM_PARTIAL_LINE_EVERGREEN',
2461: p_token1 => 'CONTRACT_NUMBER',
2462: p_token1_value => l_contract_number);

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

3286: x_return_status := OKL_API.G_RET_STS_ERROR;
3287: -- SECHAWLA 14-APR-03 2902588 : Use the following message instead of the standard REQUIRED message
3288:
3289: --Unable to create quote because the contract CONTRACT_NUMBER does not have an associated vendor program.
3290: OKC_API.set_message( p_app_name => 'OKL',
3291: p_msg_name => 'OKL_AM_NO_VENDOR_PROGRAM',
3292: p_token1 => 'CONTRACT_NUMBER',
3293: p_token1_value => l_contract_number);
3294: RAISE OKL_API.G_EXCEPTION_ERROR;