DBA Data[Home] [Help]

APPS.OKL_SUBSIDY_POOL_PVT dependencies on FND_LOG_MESSAGES

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 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 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 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 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 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 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) ;