2286:
2287: BEGIN
2288: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2289: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.before',
2290: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2291: l_k_details_rec.ID||')');
2292: END IF;
2293:
2294: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2290: 'oks_renew_util_pub.get_template_set_id(p_contract_id= '||
2291: l_k_details_rec.ID||')');
2292: END IF;
2293:
2294: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2295:
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||
2294: l_template_set_id := oks_renew_util_pub.get_template_set_id(l_k_details_rec.ID);
2295:
2296: IF FND_LOG.LEVEL_EVENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL THEN
2297: fnd_log.string(FND_LOG.LEVEL_EVENT,G_MODULE||l_api_name||'.external_call.after',
2298: 'oks_renew_util_pub.get_template_set_id(x_template_set_id= '||
2299: l_template_set_id||')');
2300: END IF;
2301: IF l_template_set_id IS NULL THEN
2302: x_is_eligible := 'N';