[Home] [Help]
41: --Added by kthiruva for Bug 5161075 on 19-Apr-2006
42: G_FALSE CONSTANT VARCHAR2(10) := 'false';
43: -- GLOBAL COMPOSITE DATA TYPE
44: --Added for debug_logging
45: L_DEBUG_ENABLED VARCHAR2(10) := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
46:
47:
48: -----------------------------------------------------------------------------------
49: -- Start of Bug#2757289 modification bakuchib
260:
261:
262:
263: IF (l_product_id IS NOT NULL) AND (l_contract_start_date IS NOT NULL) THEN
264: --okl_debug_pub.logmessage('Product Id1'||l_product_id);
265: --okl_debug_pub.logmessage('Contract Strat Date1'||l_contract_start_date);
266: OPEN pry_prc_csr (l_product_id, l_contract_start_date);
267: FETCH pry_prc_csr INTO l_dependent_pricing_name;
268: IF pry_prc_csr%NOTFOUND THEN
261:
262:
263: IF (l_product_id IS NOT NULL) AND (l_contract_start_date IS NOT NULL) THEN
264: --okl_debug_pub.logmessage('Product Id1'||l_product_id);
265: --okl_debug_pub.logmessage('Contract Strat Date1'||l_contract_start_date);
266: OPEN pry_prc_csr (l_product_id, l_contract_start_date);
267: FETCH pry_prc_csr INTO l_dependent_pricing_name;
268: IF pry_prc_csr%NOTFOUND THEN
269:
317: IF pry_prc_csr%ISOPEN THEN
318: CLOSE pry_prc_csr;
319: END IF;
320: x_return_status := Okl_Api.G_RET_STS_UNEXP_ERROR;
321: --okl_debug_pub.logmessage(SQLERRM);
322:
323: END get_dependent_pricing_name;
324:
325: PROCEDURE get_primary_stream_type
23202: l_PROSPECTIVE_REBOOK_YN varchar2(1);
23203:
23204: BEGIN
23205: --Added by kthiruva for Debugging
23206: L_DEBUG_ENABLED := OKL_DEBUG_PUB.CHECK_LOG_ENABLED;
23207: write_to_log('Start of Debug Logging for ESG');
23208: write_to_log ('=============================');
23209: print( l_api_name, 'begin');
23210: x_return_status := OKL_API.START_ACTIVITY(