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 FND_LOG

Line 64: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_APPROVAL_PVT.SUBMIT_POOL_FOR_APPROVAL';

60:
61: l_api_version CONSTANT NUMBER DEFAULT 1.0;
62: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_POOL_FOR_APPROVAL';
63:
64: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_APPROVAL_PVT.SUBMIT_POOL_FOR_APPROVAL';
65: l_debug_enabled VARCHAR2(10);
66: is_debug_procedure_on BOOLEAN;
67: is_debug_statement_on BOOLEAN;
68:

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

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

Line 75: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSICB.pls call submit_pool_for_approval');

71:
72: l_debug_enabled := okl_debug_pub.check_log_enabled;
73: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
74: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
75: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSICB.pls call submit_pool_for_approval');
76: END IF;
77:
78: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
79: x_return_status := OKL_API.START_ACTIVITY(

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

92: RAISE OKL_API.G_EXCEPTION_ERROR;
93: END IF;
94:
95: -- check for logging on STATEMENT level
96: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
97:
98: x_total_budgets := 0;
99: -- validate if subsidy pool id passed is valid
100: IF(p_subsidy_pool_id IS NULL OR p_subsidy_pool_id = OKL_API.G_MISS_NUM)THEN

Line 128: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

124: ,p_subsidy_pool_id => cv_pool_details_csr.id
125: );
126: -- write to log
127: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
128: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
129: l_module,
130: 'expiring subsidy pool '||cv_pool_details_csr.subsidy_pool_name||' with effective end date '||cv_pool_details_csr.effective_to_date
131: );
132: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 190: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

186: ,p_decision_status_code => l_pool_status
187: );
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'

Line 212: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

208: ,p_decision_status_code => l_pool_status
209: );
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'

Line 241: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

237: ,p_decision_status_code => l_pool_status
238: );
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'

Line 264: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

260: ,p_decision_status_code => l_pool_status
261: );
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'

Line 285: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

281: ,p_subsidy_pool_id => p_subsidy_pool_id
282: ,p_total_budget_amt => cv_get_pool_line_details_csr.budget_amount);
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'

Line 310: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

306: ,x_msg_data => x_msg_data
307: ,p_subsidy_pool_id => p_subsidy_pool_id);
308: -- write to log
309: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
310: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
311: l_module,
312: 'okl_subsidy_pool_wf.raise_pool_event_approval returned with status '||x_return_status||' x_msg_data '||x_msg_data
313: );
314: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 324: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSICB.pls call submit_pool_for_approval');

320: END IF;
321: END IF;
322:
323: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
324: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSICB.pls call submit_pool_for_approval');
325: END IF;
326:
327: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
328:

Line 390: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_APPROVAL_PVT.SUBMIT_BUDGET_FOR_APPROVAL';

386:
387: l_api_version CONSTANT NUMBER DEFAULT 1.0;
388: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_BUDGET_APPROVAL';
389:
390: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_APPROVAL_PVT.SUBMIT_BUDGET_FOR_APPROVAL';
391: l_debug_enabled VARCHAR2(10);
392: l_level_procedure fnd_log_messages.log_level%TYPE;
393: is_debug_procedure_on BOOLEAN;
394: is_debug_statement_on BOOLEAN;

Line 392: l_level_procedure fnd_log_messages.log_level%TYPE;

388: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'SUBMIT_BUDGET_APPROVAL';
389:
390: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_APPROVAL_PVT.SUBMIT_BUDGET_FOR_APPROVAL';
391: l_debug_enabled VARCHAR2(10);
392: l_level_procedure fnd_log_messages.log_level%TYPE;
393: is_debug_procedure_on BOOLEAN;
394: is_debug_statement_on BOOLEAN;
395:
396: BEGIN

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

396: BEGIN
397: x_return_status := OKL_API.G_RET_STS_SUCCESS;
398:
399: l_debug_enabled := okl_debug_pub.check_log_enabled;
400: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
401: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
402: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSICB.pls call submit_budget_for_approval');
403: END IF;
404:

Line 402: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSICB.pls call submit_budget_for_approval');

398:
399: l_debug_enabled := okl_debug_pub.check_log_enabled;
400: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
401: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
402: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRSICB.pls call submit_budget_for_approval');
403: END IF;
404:
405: -- call START_ACTIVITY to create savepoint, check compatibility and initialize message list
406: x_return_status := OKL_API.START_ACTIVITY(

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

419: RAISE OKL_API.G_EXCEPTION_ERROR;
420: END IF;
421:
422: -- check for logging on STATEMENT level
423: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
424:
425: -- validate if subsidy pool budget id passed is valid
426: IF(p_subsidy_pool_budget_id IS NULL OR p_subsidy_pool_budget_id = OKL_API.G_MISS_NUM)THEN
427: OKC_API.set_message(G_APP_NAME, G_REQUIRED_VALUE, G_COL_NAME_TOKEN, 'p_subsidy_pool_budget_id');

Line 455: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

451: ,p_subsidy_pool_id => cv_get_pool_info.pool_id
452: );
453: -- write to log
454: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
455: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
456: l_module,
457: 'expiring subsidy pool '||cv_get_pool_info.subsidy_pool_name||' with effective end date '||cv_get_pool_info.pool_end_date
458: );
459: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 491: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

487: ,p_decision_status_code => l_budget_status
488: );
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'

Line 521: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

517: ,p_subsidy_pool_id => cv_get_pool_info.pool_id
518: ,p_total_budget_amt => lv_calc_total_budget);
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: );

Line 553: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

549: ,p_decision_status_code => l_budget_status
550: );
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'

Line 577: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

573: ,p_subsidy_pool_id => cv_get_pool_info.pool_id
574: ,p_total_budget_amt => lv_calc_total_budget);
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: );

Line 601: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

597: ,x_msg_data => x_msg_data
598: ,p_subsidy_pool_budget_id => p_subsidy_pool_budget_id);
599: -- write to log
600: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
601: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
602: l_module,
603: 'okl_subsidy_pool_wf.raise_budget_event_approval returned with status '||x_return_status||' x_msg_data '||x_msg_data
604: );
605: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 615: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSICB.pls call submit_budget_for_approval');

611: END IF;
612: END IF;
613:
614: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
615: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRSICB.pls call submit_budget_for_approval');
616: END IF;
617:
618: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count, x_msg_data => x_msg_data);
619: