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_WF dependencies on FND_LOG

Line 288: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.PROCESS_POOL_AME';

284: ,actid IN NUMBER
285: ,funcmode IN VARCHAR2
286: ,resultout OUT NOCOPY VARCHAR2) IS
287: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'process_pool_ame';
288: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.PROCESS_POOL_AME';
289: l_debug_enabled VARCHAR2(10);
290: is_debug_procedure_on BOOLEAN;
291:
292: BEGIN

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

290: is_debug_procedure_on BOOLEAN;
291:
292: BEGIN
293: l_debug_enabled := okl_debug_pub.check_log_enabled;
294: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
295: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
296: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_ame');
297: END IF;
298:

Line 296: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_ame');

292: BEGIN
293: l_debug_enabled := okl_debug_pub.check_log_enabled;
294: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
295: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
296: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_ame');
297: END IF;
298:
299: -- RUN mode
300: IF(funcmode = 'RUN')THEN

Line 338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call process_pool_ame');

334: RETURN;
335: END IF;
336:
337: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call process_pool_ame');
339: END IF;
340: EXCEPTION
341: WHEN OTHERS THEN
342: wf_core.context(G_PKG_NAME , l_api_name, itemtype, itemkey, actid, funcmode);

Line 352: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.PROCESS_POOL_LINE_AME';

348: ,actid IN NUMBER
349: ,funcmode IN VARCHAR2
350: ,resultout OUT NOCOPY VARCHAR2) IS
351: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'process_pool_line_ame';
352: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.PROCESS_POOL_LINE_AME';
353: l_debug_enabled VARCHAR2(10);
354: is_debug_procedure_on BOOLEAN;
355: BEGIN
356: l_debug_enabled := okl_debug_pub.check_log_enabled;

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

353: l_debug_enabled VARCHAR2(10);
354: is_debug_procedure_on BOOLEAN;
355: BEGIN
356: l_debug_enabled := okl_debug_pub.check_log_enabled;
357: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
358: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
359: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_line_ame');
360: END IF;
361:

Line 359: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_line_ame');

355: BEGIN
356: l_debug_enabled := okl_debug_pub.check_log_enabled;
357: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
358: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
359: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call process_pool_line_ame');
360: END IF;
361:
362: -- RUN mode
363: IF(funcmode = 'RUN')THEN

Line 399: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call process_pool_line_ame');

395: resultout := 'COMPLETE:';
396: RETURN;
397: END IF;
398: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
399: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call process_pool_line_ame');
400: END IF;
401:
402: EXCEPTION
403: WHEN OTHERS THEN

Line 466: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_POOL_APPROVAL_STATUS';

462: x_msg_data VARCHAR2(1000);
463: x_msg_count NUMBER;
464: lv_decision_status_code fnd_lookups.lookup_code%TYPE;
465: l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_pool_status';
466: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_POOL_APPROVAL_STATUS';
467: l_debug_enabled VARCHAR2(10);
468: is_debug_procedure_on BOOLEAN;
469: is_debug_statement_on BOOLEAN;
470:

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

469: is_debug_statement_on BOOLEAN;
470:
471: BEGIN
472: l_debug_enabled := okl_debug_pub.check_log_enabled;
473: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
474: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_pool_approval_status');
476: END IF;
477:

Line 475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_pool_approval_status');

471: BEGIN
472: l_debug_enabled := okl_debug_pub.check_log_enabled;
473: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
474: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_pool_approval_status');
476: END IF;
477:
478: -- check for logging on STATEMENT level
479: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);

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

475: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_pool_approval_status');
476: END IF;
477:
478: -- check for logging on STATEMENT level
479: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
480:
481: IF(funcmode = 'RUN')THEN
482: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
483: itemkey => itemkey,

Line 512: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

508: ,p_total_budget_amt => lv_total_budget
509: );
510: -- write to log
511: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
512: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
513: l_module,
514: 'okl_subsidy_pool_pvt.update_total_budget with total budget amount '||lv_total_budget||
515: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
516: );

Line 535: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

531: ,p_decision_status_code => lv_decision_status_code
532: );
533: -- write to log
534: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
535: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
536: l_module,
537: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to '||lv_decision_status_code||' lv_budget_line_id '||lv_budget_line_id ||
538: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
539: );

Line 557: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

553: ,p_subsidy_pool_id => lv_subsidy_pool_id
554: ,p_decision_status_code => lv_decision_status_code);
555: -- write to log
556: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
557: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
558: l_module,
559: 'okl_subsidy_pool_pvt.set_decision_status_code to '||lv_decision_status_code||' lv_subsidy_pool_id '||lv_subsidy_pool_id ||
560: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
561: );

Line 582: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

578: ,p_decision_status_code => lv_decision_status_code
579: );
580: -- write to log
581: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
582: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
583: l_module,
584: 'okl_subsidy_pool_budget_pvt.set_decision_status_code to '||lv_decision_status_code||' lv_budget_line_id '||lv_budget_line_id ||
585: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
586: );

Line 603: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

599: ,p_subsidy_pool_id => lv_subsidy_pool_id
600: ,p_decision_status_code => lv_decision_status_code);
601: -- write to log
602: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
603: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
604: l_module,
605: 'okl_subsidy_pool_pvt.set_decision_status_code to '||lv_decision_status_code||' lv_subsidy_pool_id '||lv_subsidy_pool_id ||
606: ' returned with status '||x_return_status ||' x_msg_data '||x_msg_data
607: );

Line 632: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call update_pool_approval_status');

628: resultout := 'COMPLETE:';
629: RETURN;
630: END IF;
631: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
632: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call update_pool_approval_status');
633: END IF;
634:
635: EXCEPTION
636: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 684: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_LINE_APPROVAL_STATUS';

680: x_return_status VARCHAR2(10);
681: x_msg_data VARCHAR2(1000);
682: x_msg_count NUMBER;
683: l_api_name CONSTANT VARCHAR2(60) DEFAULT 'update_line_status';
684: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.UPDATE_LINE_APPROVAL_STATUS';
685: l_debug_enabled VARCHAR2(10);
686: is_debug_procedure_on BOOLEAN;
687: is_debug_statement_on BOOLEAN;
688: BEGIN

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

686: is_debug_procedure_on BOOLEAN;
687: is_debug_statement_on BOOLEAN;
688: BEGIN
689: l_debug_enabled := okl_debug_pub.check_log_enabled;
690: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
691: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
692: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');
693: END IF;
694:

Line 692: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');

688: BEGIN
689: l_debug_enabled := okl_debug_pub.check_log_enabled;
690: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
691: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
692: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');
693: END IF;
694:
695: -- RUN mode
696: IF(funcmode = 'RUN')THEN

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

694:
695: -- RUN mode
696: IF(funcmode = 'RUN')THEN
697: -- check for logging on STATEMENT level
698: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
699:
700: lv_approval_status := wf_engine.GetItemAttrText(itemtype => itemtype,
701: itemkey => itemkey,
702: aname => G_WF_ITM_RESULT);

Line 742: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

738: ,p_total_budget_amt => lv_total_budget
739: );
740: -- write to log
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_pvt.update_total_budget of budget amount '||lv_total_budget||' returned with status '||x_return_status||
745: ' x_msg_data '||x_msg_data
746: );

Line 766: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

762: ,p_decision_status_code => lv_decision_status_code
763: );
764: -- write to log
765: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
766: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
767: l_module,
768: 'okl_subsidy_pool_budget_pvt.set_decision_status_code code '||lv_decision_status_code||' returned with status '||x_return_status||
769: ' x_msg_data '||x_msg_data
770: );

Line 792: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

788: ,p_total_budget_amt => lv_total_budget
789: );
790: -- write to log
791: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
792: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
793: l_module,
794: 'okl_subsidy_pool_pvt.update_total_budget budget '||lv_total_budget||' returned with status '||x_return_status||
795: ' x_msg_data '||x_msg_data
796: );

Line 816: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

812: ,p_decision_status_code => lv_decision_status_code
813: );
814: -- write to log
815: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
816: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
817: l_module,
818: 'okl_subsidy_pool_budget_pvt.set_decision_status_code code '||lv_decision_status_code||' returned with status '||x_return_status||
819: ' x_msg_data '||x_msg_data
820: );

Line 847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');

843: RETURN;
844: END IF;
845:
846: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
847: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call update_line_approval_status');
848: END IF;
849:
850: EXCEPTION
851: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 901: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.GET_SUBSIDY_POOL_APPROVER';

897: lv_pool_description okl_subsidy_pools_v.short_description%TYPE;
898: lv_requestor VARCHAR2(100);
899: lv_budget_type fnd_lookups.meaning%TYPE;
900:
901: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.GET_SUBSIDY_POOL_APPROVER';
902: l_debug_enabled VARCHAR2(10);
903: is_debug_procedure_on BOOLEAN;
904: is_debug_statement_on BOOLEAN; -- not using this as of now
905:

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

904: is_debug_statement_on BOOLEAN; -- not using this as of now
905:
906: BEGIN
907: l_debug_enabled := okl_debug_pub.check_log_enabled;
908: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
909: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call get_subsidy_pool_approver');
911: END IF;
912:

Line 910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call get_subsidy_pool_approver');

906: BEGIN
907: l_debug_enabled := okl_debug_pub.check_log_enabled;
908: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
909: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
910: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call get_subsidy_pool_approver');
911: END IF;
912:
913: IF(funcmode = 'RUN')THEN
914: l_user_id := wf_engine.GetItemAttrText(itemtype => itemtype,

Line 1013: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call get_subsidy_pool_approver');

1009: RETURN;
1010: END IF; -- funcmode
1011:
1012: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1013: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call get_subsidy_pool_approver');
1014: END IF;
1015:
1016: EXCEPTION
1017: WHEN OTHERS THEN

Line 1039: l_module CONSTANT fnd_log_messages.module%TYPE DEFAULT'okl.plsql.OKL_SUBSIDY_POOL_WF.SET_MSG_ATTRIBUTES';

1035: lv_approver VARCHAR2(100);
1036: lv_budget_type fnd_lookups.meaning%TYPE;
1037: l_api_name CONSTANT VARCHAR2(30) DEFAULT 'set_msg_attributes';
1038:
1039: l_module CONSTANT fnd_log_messages.module%TYPE DEFAULT'okl.plsql.OKL_SUBSIDY_POOL_WF.SET_MSG_ATTRIBUTES';
1040: l_debug_enabled VARCHAR2(10);
1041: is_debug_procedure_on BOOLEAN;
1042:
1043: BEGIN

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

1042:
1043: BEGIN
1044:
1045: l_debug_enabled := okl_debug_pub.check_log_enabled;
1046: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1047: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1048: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call set_msg_attributes');
1049: END IF;
1050:

Line 1048: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call set_msg_attributes');

1044:
1045: l_debug_enabled := okl_debug_pub.check_log_enabled;
1046: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1047: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1048: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call set_msg_attributes');
1049: END IF;
1050:
1051: -- RUN mode
1052: IF(funcmode = 'RUN')THEN

Line 1266: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call set_msg_attributes');

1262: RETURN;
1263: END IF;
1264:
1265: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1266: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call set_msg_attributes');
1267: END IF;
1268:
1269: EXCEPTION
1270: WHEN OTHERS THEN

Line 1329: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_POOL_EVENT_APPROVAL';

1325: l_application_id fnd_application.application_id%TYPE;
1326: l_trans_appl_id ame_calling_apps.application_id%TYPE;
1327: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
1328:
1329: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_POOL_EVENT_APPROVAL';
1330: l_debug_enabled VARCHAR2(10);
1331: is_debug_procedure_on BOOLEAN;
1332: is_debug_statement_on BOOLEAN;
1333:

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

1332: is_debug_statement_on BOOLEAN;
1333:
1334: BEGIN
1335: l_debug_enabled := okl_debug_pub.check_log_enabled;
1336: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1337: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_pool_event_approval');
1339: END IF;
1340:

Line 1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_pool_event_approval');

1334: BEGIN
1335: l_debug_enabled := okl_debug_pub.check_log_enabled;
1336: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1337: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1338: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_pool_event_approval');
1339: END IF;
1340:
1341: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1342: -- Call start_activity to create savepoint, check compatibility and initialize message list

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

1351: RAISE OKL_API.G_EXCEPTION_ERROR;
1352: END IF;
1353:
1354: -- check for logging on STATEMENT level
1355: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1356:
1357: l_get_agent(p_user_id => fnd_global.user_id
1358: ,x_return_status => x_return_status
1359: ,x_name => l_requester

Line 1363: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1359: ,x_name => l_requester
1360: ,x_description => l_name);
1361: -- write to log
1362: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1363: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1364: l_module,
1365: 'l_get_agent return staus '||x_return_status||' l_requester '||l_requester||' l_name '||l_name
1366: );
1367: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1407: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1403: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1404: END IF;
1405: -- write to log
1406: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1407: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1408: l_module,
1409: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1410: );
1411: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1416: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1412:
1413: ELSIF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_WF)THEN
1414: -- write to log
1415: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1416: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1417: l_module,
1418: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1419: );
1420: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_pool_event_approval');

1449:
1450: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);
1451:
1452: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1453: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_pool_event_approval');
1454: END IF;
1455:
1456: EXCEPTION
1457: WHEN OKL_API.G_EXCEPTION_ERROR THEN

Line 1539: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_BUDGET_EVENT_APPROVAL';

1535: l_application_id fnd_application.application_id%TYPE;
1536: l_trans_appl_id ame_calling_apps.application_id%TYPE;
1537: l_trans_type_id ame_calling_apps.transaction_type_id%TYPE;
1538:
1539: l_module CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_WF.RAISE_BUDGET_EVENT_APPROVAL';
1540: l_debug_enabled VARCHAR2(10);
1541: is_debug_procedure_on BOOLEAN;
1542: is_debug_statement_on BOOLEAN;
1543: BEGIN

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

1541: is_debug_procedure_on BOOLEAN;
1542: is_debug_statement_on BOOLEAN;
1543: BEGIN
1544: l_debug_enabled := okl_debug_pub.check_log_enabled;
1545: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1546: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1547: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_budget_event_approval');
1548: END IF;
1549: x_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 1547: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_budget_event_approval');

1543: BEGIN
1544: l_debug_enabled := okl_debug_pub.check_log_enabled;
1545: is_debug_procedure_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_PROCEDURE);
1546: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1547: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'begin debug OKLRBWFB.pls call raise_budget_event_approval');
1548: END IF;
1549: x_return_status := OKL_API.G_RET_STS_SUCCESS;
1550: -- Call start_activity to create savepoint, check compatibility and initialize message list
1551: x_return_status := OKL_API.START_ACTIVITY(l_api_name,

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

1559: RAISE OKL_API.G_EXCEPTION_ERROR;
1560: END IF;
1561:
1562: -- check for logging on STATEMENT level
1563: is_debug_statement_on := okl_debug_pub.check_log_on(l_module,FND_LOG.LEVEL_STATEMENT);
1564:
1565: l_get_agent(p_user_id => fnd_global.user_id
1566: ,x_return_status => x_return_status
1567: ,x_name => l_requester

Line 1571: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1567: ,x_name => l_requester
1568: ,x_description => l_name);
1569: -- write to log
1570: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1571: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1572: l_module,
1573: 'l_get_agent return staus '||x_return_status||' l_requester '||l_requester||' l_name '||l_name
1574: );
1575: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1615: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1611: wf_event.AddParameterToList(G_WF_ITM_TRANSACTION_TYPE_ID,l_trans_type_id,l_parameter_list);
1612: END IF;
1613: -- write to log
1614: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1615: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1616: l_module,
1617: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1618: );
1619: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1624: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,

1620:
1621: ELSIF(l_approval_option = G_SUBSIDY_POOL_APPROVAL_WF)THEN
1622: -- write to log
1623: IF(NVL(l_debug_enabled,'N')='Y' AND is_debug_statement_on) THEN
1624: okl_debug_pub.log_debug(FND_LOG.LEVEL_STATEMENT,
1625: l_module,
1626: 'l_approval_option '||l_approval_option||' raising budget line approval event '
1627: );
1628: END IF; -- end of NVL(l_debug_enabled,'N')='Y'

Line 1664: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_budget_event_approval');

1660: END IF;
1661:
1662: OKL_API.END_ACTIVITY(x_msg_count => x_msg_count,x_msg_data => x_msg_data);
1663: IF(l_debug_enabled='Y' AND is_debug_procedure_on) THEN
1664: okl_debug_pub.log_debug(FND_LOG.LEVEL_PROCEDURE,l_module,'end debug OKLRBWFB.pls call raise_budget_event_approval');
1665: END IF;
1666:
1667: EXCEPTION
1668: WHEN OKL_API.G_EXCEPTION_ERROR THEN