eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OKL_SUBSIDY_POOL_APPROVAL_PVT dependencies on OKL_SUBSIDY_POOL_PVT

Line 119: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version

115:
116: -- check for pool expiration here. pool could be logically expired by the time user submits for approval.
117: -- in such a case, expire the pool and throw the error
118: IF(TRUNC(SYSDATE) > NVL(cv_pool_details_csr.effective_to_date,okl_accounting_util.g_final_date))THEN
119: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version
120: ,p_init_msg_list => p_init_msg_list
121: ,x_return_status => x_return_status
122: ,x_msg_count => x_msg_count
123: ,x_msg_data => x_msg_data

Line 180: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => p_api_version

176: END IF;
177:
178: -- now that all the required validations are passed, update the pool and line status to pending approval
179: l_pool_status := G_PENDING_STATUS_CODE;
180: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => p_api_version
181: ,p_init_msg_list => p_init_msg_list
182: ,x_return_status => x_return_status
183: ,x_msg_count => x_msg_count
184: ,x_msg_data => x_msg_data

Line 192: 'okl_subsidy_pool_pvt.set_decision_status_code to pending returned with status '||x_return_status|| ' x_msg_data '||x_msg_data

188: -- write to log
189: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
190: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
191: l_module,
192: 'okl_subsidy_pool_pvt.set_decision_status_code to pending returned with status '||x_return_status|| ' x_msg_data '||x_msg_data
193: );
194: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
195:
196: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 231: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => p_api_version

227:
228: IF(NVL(l_approval_process,'NONE')='NONE')THEN
229: -- since no approval process is selected in the profile, approve the pool by default
230: l_pool_status := G_ACTIVE_STATUS_CODE;
231: okl_subsidy_pool_pvt.set_decision_status_code(p_api_version => p_api_version
232: ,p_init_msg_list => p_init_msg_list
233: ,x_return_status => x_return_status
234: ,x_msg_count => x_msg_count
235: ,x_msg_data => x_msg_data

Line 243: 'okl_subsidy_pool_pvt.set_decision_status_code to active returned with status '||x_return_status||' x_msg_data '||x_msg_data

239: -- write to log
240: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
241: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
242: l_module,
243: 'okl_subsidy_pool_pvt.set_decision_status_code to active returned with status '||x_return_status||' x_msg_data '||x_msg_data
244: );
245: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
246:
247: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 276: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version

272: ELSIF (x_return_status = OKL_API.G_RET_STS_ERROR) THEN
273: RAISE OKL_API.G_EXCEPTION_ERROR;
274: END IF;
275: -- since this is the initial approval, the total budget amount equals the budget amount on the line
276: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version
277: ,p_init_msg_list => p_init_msg_list
278: ,x_return_status => x_return_status
279: ,x_msg_count => x_msg_count
280: ,x_msg_data => x_msg_data

Line 287: 'okl_subsidy_pool_pvt.update_total_budget returned with status '||x_return_status||' x_msg_data '||x_msg_data

283: -- write to log
284: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
285: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
286: l_module,
287: 'okl_subsidy_pool_pvt.update_total_budget returned with status '||x_return_status||' x_msg_data '||x_msg_data
288: );
289: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
290:
291: IF(x_return_status = OKL_API.G_RET_STS_UNEXP_ERROR) THEN

Line 446: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version

442:
443: -- check for pool expiration here. pool could be logically expired by the time user submits line for approval.
444: -- in such a case, expire the pool and throw the error
445: IF(TRUNC(SYSDATE) > NVL(cv_get_pool_info.pool_end_date,okl_accounting_util.g_final_date))THEN
446: okl_subsidy_pool_pvt.expire_sub_pool(p_api_version => p_api_version
447: ,p_init_msg_list => p_init_msg_list
448: ,x_return_status => x_return_status
449: ,x_msg_count => x_msg_count
450: ,x_msg_data => x_msg_data

Line 512: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version

508: IF(lv_calc_total_budget <= 0)THEN
509: OKL_API.set_message(G_APP_NAME, G_POOL_LINE_INVALID_AMT, 'AMOUNT', cv_get_pool_info.budget_amount);
510: RAISE OKL_API.G_EXCEPTION_ERROR;
511: ELSE
512: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version
513: ,p_init_msg_list => p_init_msg_list
514: ,x_return_status => x_return_status
515: ,x_msg_count => x_msg_count
516: ,x_msg_data => x_msg_data

Line 523: 'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' returned with '||x_return_status||

519: -- write to log
520: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
521: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
522: l_module,
523: 'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' returned with '||x_return_status||
524: ' x_msg_data '||x_msg_data
525: );
526: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
527:

Line 568: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version

564: IF(cv_get_pool_info.budget_type_code = 'ADDITION')THEN
565: lv_calc_total_budget := 0;
566: lv_calc_total_budget := cv_get_pool_info.total_budgets + cv_get_pool_info.budget_amount;
567:
568: okl_subsidy_pool_pvt.update_total_budget(p_api_version => p_api_version
569: ,p_init_msg_list => p_init_msg_list
570: ,x_return_status => x_return_status
571: ,x_msg_count => x_msg_count
572: ,x_msg_data => x_msg_data

Line 579: 'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' status '||x_return_status||

575: -- write to log
576: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
577: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
578: l_module,
579: 'okl_subsidy_pool_pvt.update_total_budget with lv_calc_total_budget '||lv_calc_total_budget||' status '||x_return_status||
580: ' x_msg_data '||x_msg_data
581: );
582: END IF; -- end of NVL(l_debug_enabled,'N')='Y'
583: