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

Line 120: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.CREATE_SUB_POOL';

116:
117: ---------------------------
118: -- DECLARE Local Variables
119: ---------------------------
120: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.CREATE_SUB_POOL';
121: L_DEBUG_ENABLED VARCHAR2(10);
122: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
123: IS_DEBUG_PROCEDURE_ON BOOLEAN;
124: l_sub_pool_rec subsidy_pool_rec ;

Line 122: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

118: -- DECLARE Local Variables
119: ---------------------------
120: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.CREATE_SUB_POOL';
121: L_DEBUG_ENABLED VARCHAR2(10);
122: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
123: IS_DEBUG_PROCEDURE_ON BOOLEAN;
124: l_sub_pool_rec subsidy_pool_rec ;
125: l_effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE ;
126: l_total_budgets OKL_SUBSIDY_POOLS_B.TOTAL_BUDGETS%TYPE ;

Line 143: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

139:
140: BEGIN
141: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
142: IF(L_DEBUG_ENABLED='Y') THEN
143: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
144: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
145: END IF;
146: IF(IS_DEBUG_PROCEDURE_ON) THEN
147: BEGIN

Line 279: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';

275: ) IS
276: ---------------------------
277: -- DECLARE Local Variables
278: ---------------------------
279: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';
280: L_DEBUG_ENABLED VARCHAR2(10);
281: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
282: IS_DEBUG_PROCEDURE_ON BOOLEAN;
283: l_sub_pool_rec subsidy_pool_rec ;

Line 281: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

277: -- DECLARE Local Variables
278: ---------------------------
279: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUB_POOL';
280: L_DEBUG_ENABLED VARCHAR2(10);
281: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
282: IS_DEBUG_PROCEDURE_ON BOOLEAN;
283: l_sub_pool_rec subsidy_pool_rec ;
284: l_effective_to_date OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE ;
285: l_db_effective_to OKL_SUBSIDY_POOLS_B.EFFECTIVE_TO_DATE%TYPE ;

Line 328: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

324:
325: BEGIN
326: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
327: IF(L_DEBUG_ENABLED='Y') THEN
328: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
329: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
330: END IF;
331: IF(IS_DEBUG_PROCEDURE_ON) THEN
332: BEGIN

Line 514: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.EXPIRE_SUB_POOL';

510: p_subsidy_pool_id IN okl_subsidy_pools_b.id%TYPE) IS
511: ---------------------------
512: -- DECLARE Local Variables
513: ---------------------------
514: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.EXPIRE_SUB_POOL';
515: L_DEBUG_ENABLED VARCHAR2(10);
516: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
517: IS_DEBUG_PROCEDURE_ON BOOLEAN;
518: l_sub_pool_rec subsidy_pool_rec;

Line 516: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

512: -- DECLARE Local Variables
513: ---------------------------
514: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.EXPIRE_SUB_POOL';
515: L_DEBUG_ENABLED VARCHAR2(10);
516: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
517: IS_DEBUG_PROCEDURE_ON BOOLEAN;
518: l_sub_pool_rec subsidy_pool_rec;
519: l_subsidy_pool_id OKL_SUBSIDY_POOLS_B.ID%TYPE ;
520: x_sub_pool_rec subsidy_pool_rec;

Line 540: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

536: PRAGMA AUTONOMOUS_TRANSACTION;
537: BEGIN
538: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
539: IF(L_DEBUG_ENABLED='Y') THEN
540: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
541: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
542: END IF;
543: IF(IS_DEBUG_PROCEDURE_ON) THEN
544: BEGIN

Line 665: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';

661: p_total_budget_amt IN okl_subsidy_pools_b.total_budgets%TYPE ) IS
662: ---------------------------
663: -- DECLARE Local Variables
664: ---------------------------
665: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';
666: L_DEBUG_ENABLED VARCHAR2(10);
667: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
668: IS_DEBUG_PROCEDURE_ON BOOLEAN;
669: l_sub_pool_rec subsidy_pool_rec;

Line 667: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

663: -- DECLARE Local Variables
664: ---------------------------
665: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_TOTAL_BUDGET';
666: L_DEBUG_ENABLED VARCHAR2(10);
667: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
668: IS_DEBUG_PROCEDURE_ON BOOLEAN;
669: l_sub_pool_rec subsidy_pool_rec;
670: l_subsidy_pool_id OKL_SUBSIDY_POOLS_B.ID%TYPE ;
671: x_sub_pool_rec subsidy_pool_rec;

Line 687: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

683:
684: BEGIN
685: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
686: IF(L_DEBUG_ENABLED='Y') THEN
687: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
688: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
689: END IF;
690: IF(IS_DEBUG_PROCEDURE_ON) THEN
691: BEGIN

Line 811: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';

807:
808: ---------------------------
809: -- DECLARE Local Variables
810: ---------------------------
811: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';
812: L_DEBUG_ENABLED VARCHAR2(10);
813: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
814: IS_DEBUG_PROCEDURE_ON BOOLEAN;
815: l_sub_pool_rec subsidy_pool_rec;

Line 813: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

809: -- DECLARE Local Variables
810: ---------------------------
811: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.UPDATE_SUBSIDY_AMOUNT';
812: L_DEBUG_ENABLED VARCHAR2(10);
813: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
814: IS_DEBUG_PROCEDURE_ON BOOLEAN;
815: l_sub_pool_rec subsidy_pool_rec;
816: l_subsidy_pool_id OKL_SUBSIDY_POOLS_B.ID%TYPE ;
817: x_sub_pool_rec subsidy_pool_rec;

Line 833: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

829:
830: BEGIN
831: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
832: IF(L_DEBUG_ENABLED='Y') THEN
833: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
834: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
835: END IF;
836: IF(IS_DEBUG_PROCEDURE_ON) THEN
837: BEGIN

Line 956: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.SET_DECISION_STATUS_CODE';

952:
953: ---------------------------
954: -- DECLARE Local Variables
955: ---------------------------
956: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.SET_DECISION_STATUS_CODE';
957: L_DEBUG_ENABLED VARCHAR2(10);
958: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
959: IS_DEBUG_PROCEDURE_ON BOOLEAN;
960: l_sub_pool_rec subsidy_pool_rec;

Line 958: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

954: -- DECLARE Local Variables
955: ---------------------------
956: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.SET_DECISION_STATUS_CODE';
957: L_DEBUG_ENABLED VARCHAR2(10);
958: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
959: IS_DEBUG_PROCEDURE_ON BOOLEAN;
960: l_sub_pool_rec subsidy_pool_rec;
961: l_subsidy_pool_id OKL_SUBSIDY_POOLS_B.ID%TYPE ;
962: x_sub_pool_rec subsidy_pool_rec;

Line 980: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

976:
977: BEGIN
978: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
979: IF(L_DEBUG_ENABLED='Y') THEN
980: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
981: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
982: END IF;
983: IF(IS_DEBUG_PROCEDURE_ON) THEN
984: BEGIN

Line 1126: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.VALIDATE_SUB_POOL';

1122:
1123: ---------------------------
1124: -- DECLARE Local Variables
1125: ---------------------------
1126: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.VALIDATE_SUB_POOL';
1127: L_DEBUG_ENABLED VARCHAR2(10);
1128: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
1129: IS_DEBUG_PROCEDURE_ON BOOLEAN;
1130: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_POOL';

Line 1128: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

1124: -- DECLARE Local Variables
1125: ---------------------------
1126: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_SUBSIDY_POOL_PVT.VALIDATE_SUB_POOL';
1127: L_DEBUG_ENABLED VARCHAR2(10);
1128: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
1129: IS_DEBUG_PROCEDURE_ON BOOLEAN;
1130: l_api_name CONSTANT VARCHAR2(30) := 'VALIDATE_SUBSIDY_POOL';
1131: l_api_version NUMBER ;
1132: l_return_status VARCHAR2(1) ;

Line 1138: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

1134:
1135: BEGIN
1136: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
1137: IF(L_DEBUG_ENABLED='Y') THEN
1138: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
1139: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
1140: END IF;
1141: IF(IS_DEBUG_PROCEDURE_ON) THEN
1142: BEGIN