DBA Data[Home] [Help]

APPS.OKL_COPY_CONTRACT_PVT dependencies on OKL_COPY_CONTRACT_PVT

Line 1: Package body okl_copy_contract_pvt as

1: Package body okl_copy_contract_pvt as
2: /* $Header: OKLRCOPB.pls 120.56.12020000.5 2013/03/14 09:35:08 racheruv ship $ */
3:
4: G_MODULE VARCHAR2(255) := 'okl.stream.esg.okl_esg_transport_pvt';
5: G_DEBUG_ENABLED CONSTANT VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;

Line 5233: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT_PVT';

5229: p_rbk_date IN DATE DEFAULT NULL) IS
5230:
5231: l_api_name CONSTANT VARCHAR2(30) := 'COPY_LEASE_CONTRACT_NEW';
5232: G_APP_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT';
5233: G_PKG_NAME CONSTANT VARCHAR2(200) := 'OKL_COPY_CONTRACT_PVT';
5234: G_UNEXPECTED_ERROR CONSTANT VARCHAR2(200) := 'OKL_CONTRACTS_UNEXP_ERROR';
5235: G_SQLCODE_TOKEN CONSTANT VARCHAR2(200) := 'SQLcode';
5236: G_SQLERRM_TOKEN CONSTANT VARCHAR2(200) := 'SQLerrm';
5237: --G_WF_ITM_CONTRACT_ID CONSTANT VARCHAR2(11) := 'CONTRACT_ID';

Line 17905: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',

17901: OKL_DEBUG_PUB.LOG_DEBUG(FND_LOG.LEVEL_STATEMENT, G_MODULE,'p_fa_cost='|| p_fa_cost || ' l_converted_cost='||l_converted_cost);
17902: END IF;
17903: IF (p_fa_cost >= 0) AND (l_converted_cost < 0) THEN
17904: --currency conversion rate was not found in Oracle GL
17905: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
17906: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
17907: p_token1 => 'FROM_CURRENCY',
17908: p_token1_value => x_contract_currency,
17909: p_token2 => 'TO_CURRENCY',

Line 18015: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',

18011: x_currency_conversion_date => x_currency_conversion_date,
18012: x_converted_amount => l_salvage_value);
18013: IF (p_salvage_value >= 0) AND (l_salvage_value < 0) THEN
18014: --currency conversion rate was not found in Oracle GL
18015: OKC_API.set_message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
18016: p_msg_name => 'OKL_LLA_CONV_RATE_NOT_FOUND',
18017: p_token1 => 'FROM_CURRENCY',
18018: p_token1_value => x_contract_currency,
18019: p_token2 => 'TO_CURRENCY',

Line 19587: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT',

19583: BEGIN
19584: --Logic
19585: IF NVL(p_install_location_type_code,OKL_API.G_MISS_CHAR) NOT IN ('HZ_PARTY_SITES','HZ_LOCATIONS') THEN
19586: --Raise Error
19587: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT',
19588: p_msg_name => 'OKL_INVALID_INSTALL_LOC_TYPE',
19589: p_token1 => 'LOCATION_TYPE',
19590: p_token1_value => p_install_location_type_code,
19591: p_token2 => 'LOCATION_TYPE1',

Line 19608: (p_app_name => 'OKL_COPY_CONTRACT_PVT',

19604: FETCH l_address_csr INTO l_address;
19605: CLOSE l_address_csr;
19606: --Raise Error : not defined as install_at
19607: OKL_API.Set_Message
19608: (p_app_name => 'OKL_COPY_CONTRACT_PVT',
19609: p_msg_name => 'OKL_INSTALL_LOC_MISSING_USAGE',
19610: p_token1 => 'USAGE_TYPE',
19611: p_token1_value => 'INSTALL_AT',
19612: p_token2 => 'ADDRESS',

Line 19630: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT2',

19626: OPEN l_address_csr2(loc_id => p_install_location_id);
19627: FETCH l_address_csr2 INTO l_address;
19628: CLOSE l_address_csr2;
19629: --Raise Error : not defined as install_at
19630: OKL_API.Set_Message(p_app_name => 'OKL_COPY_CONTRACT_PVT2',
19631: p_msg_name => 'OKL_INSTALL_LOC_MISSING_USAGE',
19632: p_token1 => 'USAGE_TYPE',
19633: p_token1_value => 'INSTALL_AT',
19634: p_token2 => 'ADDRESS',

Line 22843: End okl_copy_contract_Pvt;

22839: x_msg_data,
22840: '_PVT');
22841: END copy_lease_contract;
22842:
22843: End okl_copy_contract_Pvt;