APPS.OKL_SUBSIDY_POOL_TRX_PVT dependencies on FND_LOG

Line 67: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_TRX_PVT.CREATE_POOL_TRANSACTION';

63: lv_subsidy_pool_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
64: lv_subsidy_pool_round_amt okl_trx_subsidy_pools.SUBSIDY_POOL_AMOUNT%TYPE;
65: lv_total_subsidy_amt okl_subsidy_pools_b.total_subsidy_amount%TYPE;
66:
67: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_TRX_PVT.CREATE_POOL_TRANSACTION';
68: l_debug_enabled VARCHAR2(10);
69: is_debug_procedure_on BOOLEAN;
70: is_debug_statement_on BOOLEAN;
71: BEGIN

Line 75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);

71: BEGIN
72: x_return_status := OKL_API.G_RET_STS_SUCCESS;
73:
74: l_debug_enabled := okl_debug_pub.check_log_enabled;
75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
76:
77: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
78: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIXB.pls call create_pool_transaction');
79: END IF;

Line 78: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIXB.pls call create_pool_transaction');

74: l_debug_enabled := okl_debug_pub.check_log_enabled;
75: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
76:
77: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
78: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIXB.pls call create_pool_transaction');
79: END IF;
80: -- check for logging on STATEMENT level
81: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
82:

Line 81: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

77: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
78: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSIXB.pls call create_pool_transaction');
79: END IF;
80: -- check for logging on STATEMENT level
81: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
82:
83: lv_pool_expired := OKL_API.G_FALSE;
84: l_sixv_rec := p_sixv_rec;
85:

Line 137: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

133: ,p_subsidy_pool_id => cv_pool_details.id
134: );
135: -- write to log
136: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
137: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
138: l_module,
139: 'l_sixv_rec.subsidy_pool_id '||to_char(l_sixv_rec.subsidy_pool_id) || ' p_sixv_rec.source_trx_date '||p_sixv_rec.source_trx_date ||
140: ' expiring subsidy pool with ret status '||x_return_status||' x_msg_data '||x_msg_data
141: );

Line 167: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

163: ,p_sixv_rec => l_sixv_rec
164: );
165: -- write to log
166: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
167: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
168: l_module,
169: 'OKL_SIX_PVT.validate_row returned with status '||x_return_status||' x_msg_data '||x_msg_data
170: );
171: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 231: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

227: RAISE OKL_API.G_EXCEPTION_ERROR;
228: END IF;
229: -- write to log
230: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
231: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
232: l_module,
233: 'lv_conv_rate '||lv_conv_rate||' l_sixv_rec.trx_amount '||l_sixv_rec.trx_amount||' lv_subsidy_pool_round_amt '||lv_subsidy_pool_round_amt
234: );
235: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 266: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

262: ,x_sixv_rec => x_sixv_rec
263: );
264: -- write to log
265: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
266: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
267: l_module,
268: 'created pool transaction record with status '||x_return_status || ' x_msg_data '||x_msg_data
269: );
270: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 296: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

292: ,p_total_subsidy_amt => lv_total_subsidy_amt
293: );
294: -- write to log
295: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
296: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
297: l_module,
298: 'updated total_subsisy_amount '||lv_total_subsidy_amt||' with status '||x_return_status || ' x_msg_data '||x_msg_data
299: );
300: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 312: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIXB.pls call create_pool_transaction');

308:
309: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
310:
311: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
312: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSIXB.pls call create_pool_transaction');
313: END IF;
314:
315: EXCEPTION
316: WHEN OKL_API.G_EXCEPTION_ERROR THEN