APPS.OKL_SUBSIDY_POOL_AUTH_TRX_PVT dependencies on OKL_SUBSIDY_POOL_TRX_PVT

Line 156: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => l_api_version

152: lv_six_tbl(idx).trx_reason_code := G_CONTRACT_REBOOK_CODE;
153: END LOOP;
154: -- now call the create pool transacation api
155: IF(x_return_status = OKL_API.G_RET_STS_SUCCESS)THEN
156: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => l_api_version
157: ,p_init_msg_list => OKL_API.G_TRUE
158: ,x_return_status => x_return_status
159: ,x_msg_count => x_msg_count
160: ,x_msg_data => x_msg_data

Line 284: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions

280: lv_six_tbl(idx).trx_amount := NVL(cv_susidy_rec.subsidy_override_amount,NVL(cv_susidy_rec.amount,0));
281: lv_six_tbl(idx).subsidy_pool_currency_code := lx_sub_pool_curr_code;
282: END IF;
283: END LOOP;
284: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions
285: IF(lv_six_tbl.COUNT > 0)THEN
286: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
287: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
288: l_module,

Line 293: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => l_api_version

289: lv_six_tbl.COUNT||' records found for reversing from the contract '||p_khr_id || ' p_source_trx_date '|| p_source_trx_date
290: );
291: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on
292:
293: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => l_api_version
294: ,p_init_msg_list => OKL_API.G_FALSE
295: ,x_return_status => x_return_status
296: ,x_msg_count => x_msg_count
297: ,x_msg_data => x_msg_data

Line 304: 'okl_subsidy_pool_trx_pvt.create_pool_transaction from reduce_pool_balance returned with status '||x_return_status

300: );
301: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
302: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
303: l_module,
304: 'okl_subsidy_pool_trx_pvt.create_pool_transaction from reduce_pool_balance returned with status '||x_return_status
305: ||' x_msg_data '||x_msg_data
306: );
307: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on
308:

Line 479: OKL_SUBSIDY_POOL_TRX_PVT.create_pool_transaction(p_api_version => p_api_version

475: -- end: cklee 07/12/2005
476:
477: lv_sixv_rec.trx_type_code := 'REDUCTION';
478: lv_sixv_rec.trx_reason_code := G_CONTRACT_BOOK_CODE;
479: OKL_SUBSIDY_POOL_TRX_PVT.create_pool_transaction(p_api_version => p_api_version
480: ,p_init_msg_list => p_init_msg_list
481: ,x_return_status => x_return_status
482: ,x_msg_count => x_msg_count
483: ,x_msg_data => x_msg_data

Line 491: 'OKL_SUBSIDY_POOL_TRX_PVT.create_pool_transaction with status '||x_return_status||' x_msg_data '||x_msg_data

487: -- write to log
488: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
489: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
490: l_module,
491: 'OKL_SUBSIDY_POOL_TRX_PVT.create_pool_transaction with status '||x_return_status||' x_msg_data '||x_msg_data
492: );
493: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on
494:
495: IF (x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 731: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions

727: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on
728: END IF; -- end of l_sub_pool_applicable = 'Y'
729: END LOOP; -- end of for c_subsidy_csr_rec IN c_subsidy_csr(cp_chr_id => p_chr_id) loop
730:
731: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions
732: IF(lv_sixv_tbl.COUNT > 0)THEN
733: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => p_api_version
734: ,p_init_msg_list => OKL_API.G_TRUE
735: ,x_return_status => x_return_status

Line 733: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => p_api_version

729: END LOOP; -- end of for c_subsidy_csr_rec IN c_subsidy_csr(cp_chr_id => p_chr_id) loop
730:
731: -- now check the length of the table lv_sixv_tbl and then call the okl_subsidy_pool_trx_pvt api to create ADDITION transactions
732: IF(lv_sixv_tbl.COUNT > 0)THEN
733: okl_subsidy_pool_trx_pvt.create_pool_transaction(p_api_version => p_api_version
734: ,p_init_msg_list => OKL_API.G_TRUE
735: ,x_return_status => x_return_status
736: ,x_msg_count => x_msg_count
737: ,x_msg_data => x_msg_data

Line 744: 'okl_subsidy_pool_trx_pvt.create_pool_transaction with status '||x_return_status || ' x_msg_data '||x_msg_data

740: );
741: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
742: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
743: l_module,
744: 'okl_subsidy_pool_trx_pvt.create_pool_transaction with status '||x_return_status || ' x_msg_data '||x_msg_data
745: );
746: END IF; -- end of NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on
747: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
748: RAISE OKL_API.G_EXCEPTION_UNEXPECTED_ERROR;

Line 1193: -- call local procedure that populates other parameters and then calls the okl_subsidy_pool_trx_pvt.create_pool_transaction

1189: -- derive the source transaction date
1190: lv_source_trx_date := NULL;
1191: OPEN l_chk_rbk_csr; FETCH l_chk_rbk_csr INTO lv_source_trx_date;
1192: CLOSE l_chk_rbk_csr;
1193: -- call local procedure that populates other parameters and then calls the okl_subsidy_pool_trx_pvt.create_pool_transaction
1194: pool_trx_khr_rbk(p_source_trx_date => lv_source_trx_date, p_six_tbl => lv_six_tbl, x_return_status => x_return_status);
1195: -- write to log
1196: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1197: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,