[Home] [Help]
198: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
199: RAISE OKL_API.G_EXCEPTION_ERROR;
200: END IF;
201: l_pool_status := G_PENDING_STATUS_CODE;
202: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => p_api_version
203: ,p_init_msg_list => p_init_msg_list
204: ,x_return_status => x_return_status
205: ,x_msg_count => x_msg_count
206: ,x_msg_data => x_msg_data
210: -- write to log
211: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
212: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
213: l_module,
214: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to pending returned with status '||x_return_status|| ' x_msg_data '||x_msg_data
215: );
216: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
217:
218: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
250: RAISE OKL_API.G_EXCEPTION_ERROR;
251: END IF;
252: -- since no approval process is selected, approve the line by default
253: l_pool_status := G_ACTIVE_STATUS_CODE;
254: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => p_api_version
255: ,p_init_msg_list => p_init_msg_list
256: ,x_return_status => x_return_status
257: ,x_msg_count => x_msg_count
258: ,x_msg_data => x_msg_data
262: -- write to log
263: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
264: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
265: l_module,
266: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to active returned with status '||x_return_status||' x_msg_data ' ||x_msg_data
267: );
268: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
269:
270: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
477: END IF;
478:
479: -- now that the validations have been passed, set the budget line to pending for approval
480: l_budget_status := G_PENDING_STATUS_CODE;
481: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => p_api_version
482: ,p_init_msg_list => p_init_msg_list
483: ,x_return_status => x_return_status
484: ,x_msg_count => x_msg_count
485: ,x_msg_data => x_msg_data
489: -- write to log
490: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
491: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
492: l_module,
493: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to pending returned with status '||x_return_status||' x_msg_data '||x_msg_data
494: );
495: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
496:
497: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN
539:
540: IF(NVL(l_approval_process,'NONE')='NONE')THEN
541: -- since no approval process is selected in the profile, approve the pool budget line by default
542: l_budget_status := G_ACTIVE_STATUS_CODE;
543: okl_subsidy_pool_budget_pvt.set_decision_status_code(p_api_version => p_api_version
544: ,p_init_msg_list => p_init_msg_list
545: ,x_return_status => x_return_status
546: ,x_msg_count => x_msg_count
547: ,x_msg_data => x_msg_data
551: -- write to log
552: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
553: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
554: l_module,
555: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to active returned with status '||x_return_status||' x_msg_data '||x_msg_data
556: );
557: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
558:
559: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN