DBA Data[Home] [Help]

APPS.OKL_XMLP_PARAMS_PVT dependencies on FND_LOG

Line 31: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec';

27:
28: ---------------------------
29: -- DECLARE Local Variables
30: ---------------------------
31: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec';
32: L_DEBUG_ENABLED VARCHAR2(10);
33: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
34: IS_DEBUG_PROCEDURE_ON BOOLEAN;
35: l_xmp_rec xmp_rec_type ;

Line 33: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

29: -- DECLARE Local Variables
30: ---------------------------
31: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_rec';
32: L_DEBUG_ENABLED VARCHAR2(10);
33: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
34: IS_DEBUG_PROCEDURE_ON BOOLEAN;
35: l_xmp_rec xmp_rec_type ;
36: l_api_version NUMBER ;
37: l_init_msg_list VARCHAR2(1) ;

Line 50: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

46:
47: BEGIN
48: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
49: IF(L_DEBUG_ENABLED='Y') THEN
50: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
51: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
52: END IF;
53: IF(IS_DEBUG_PROCEDURE_ON) THEN
54: BEGIN

Line 169: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_tbl';

165:
166: ---------------------------
167: -- DECLARE Local Variables
168: ---------------------------
169: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_tbl';
170: L_DEBUG_ENABLED VARCHAR2(10);
171: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
172: IS_DEBUG_PROCEDURE_ON BOOLEAN;
173: l_xmp_tbl xmp_tbl_type ;

Line 171: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

167: -- DECLARE Local Variables
168: ---------------------------
169: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.create_xmlp_params_tbl';
170: L_DEBUG_ENABLED VARCHAR2(10);
171: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
172: IS_DEBUG_PROCEDURE_ON BOOLEAN;
173: l_xmp_tbl xmp_tbl_type ;
174: l_api_version NUMBER ;
175: l_init_msg_list VARCHAR2(1) ;

Line 188: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

184:
185: BEGIN
186: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
187: IF(L_DEBUG_ENABLED='Y') THEN
188: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
189: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
190: END IF;
191: IF(IS_DEBUG_PROCEDURE_ON) THEN
192: BEGIN

Line 305: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';

301: ) IS
302: ---------------------------
303: -- DECLARE Local Variables
304: ---------------------------
305: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';
306: L_DEBUG_ENABLED VARCHAR2(10);
307: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
308: IS_DEBUG_PROCEDURE_ON BOOLEAN;
309: l_xmp_rec xmp_rec_type ;

Line 307: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

303: -- DECLARE Local Variables
304: ---------------------------
305: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_rec';
306: L_DEBUG_ENABLED VARCHAR2(10);
307: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
308: IS_DEBUG_PROCEDURE_ON BOOLEAN;
309: l_xmp_rec xmp_rec_type ;
310: l_api_version NUMBER ;
311: l_init_msg_list VARCHAR2(1) ;

Line 323: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

319:
320: BEGIN
321: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
322: IF(L_DEBUG_ENABLED='Y') THEN
323: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
324: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
325: END IF;
326: IF(IS_DEBUG_PROCEDURE_ON) THEN
327: BEGIN

Line 438: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';

434: ) IS
435: ---------------------------
436: -- DECLARE Local Variables
437: ---------------------------
438: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';
439: L_DEBUG_ENABLED VARCHAR2(10);
440: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
441: IS_DEBUG_PROCEDURE_ON BOOLEAN;
442: l_xmp_tbl xmp_tbl_type ;

Line 440: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

436: -- DECLARE Local Variables
437: ---------------------------
438: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.update_xmlp_params_tbl';
439: L_DEBUG_ENABLED VARCHAR2(10);
440: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
441: IS_DEBUG_PROCEDURE_ON BOOLEAN;
442: l_xmp_tbl xmp_tbl_type ;
443: l_api_version NUMBER ;
444: l_init_msg_list VARCHAR2(1) ;

Line 456: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

452:
453: BEGIN
454: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
455: IF(L_DEBUG_ENABLED='Y') THEN
456: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
457: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
458: END IF;
459: IF(IS_DEBUG_PROCEDURE_ON) THEN
460: BEGIN

Line 570: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';

566: ) IS
567: ---------------------------
568: -- DECLARE Local Variables
569: ---------------------------
570: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';
571: L_DEBUG_ENABLED VARCHAR2(10);
572: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
573: IS_DEBUG_PROCEDURE_ON BOOLEAN;
574: l_batch_id OKL_XMLP_PARAMS.Batch_Id%TYPE ;

Line 572: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

568: -- DECLARE Local Variables
569: ---------------------------
570: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.delete_xmlp_params';
571: L_DEBUG_ENABLED VARCHAR2(10);
572: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
573: IS_DEBUG_PROCEDURE_ON BOOLEAN;
574: l_batch_id OKL_XMLP_PARAMS.Batch_Id%TYPE ;
575: l_id OKL_XMLP_PARAMS.Id%TYPE ;
576: l_xmp_rec xmp_rec_type ;

Line 597: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

593:
594: BEGIN
595: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
596: IF(L_DEBUG_ENABLED='Y') THEN
597: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
598: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
599: END IF;
600: IF(IS_DEBUG_PROCEDURE_ON) THEN
601: BEGIN

Line 713: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_rec';

709: p_xmp_rec IN xmp_rec_type) IS
710: ---------------------------
711: -- DECLARE Local Variables
712: ---------------------------
713: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_rec';
714: L_DEBUG_ENABLED VARCHAR2(10);
715: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
716: IS_DEBUG_PROCEDURE_ON BOOLEAN;
717: l_xmp_rec xmp_rec_type := p_xmp_rec;

Line 715: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

711: -- DECLARE Local Variables
712: ---------------------------
713: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_rec';
714: L_DEBUG_ENABLED VARCHAR2(10);
715: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
716: IS_DEBUG_PROCEDURE_ON BOOLEAN;
717: l_xmp_rec xmp_rec_type := p_xmp_rec;
718: l_api_version NUMBER ;
719: l_init_msg_list VARCHAR2(1) ;

Line 732: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

728:
729: BEGIN
730: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
731: IF(L_DEBUG_ENABLED='Y') THEN
732: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
733: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
734: END IF;
735: IF(IS_DEBUG_PROCEDURE_ON) THEN
736: BEGIN

Line 841: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_tbl';

837:
838: ---------------------------
839: -- DECLARE Local Variables
840: ---------------------------
841: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_tbl';
842: L_DEBUG_ENABLED VARCHAR2(10);
843: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
844: IS_DEBUG_PROCEDURE_ON BOOLEAN;
845: l_xmp_tbl xmp_tbl_type := p_xmp_tbl;

Line 843: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;

839: -- DECLARE Local Variables
840: ---------------------------
841: L_MODULE CONSTANT fnd_log_messages.module%TYPE := 'okl.plsql.OKL_XMLP_PARAMS_PVT.validate_xmlp_params_tbl';
842: L_DEBUG_ENABLED VARCHAR2(10);
843: L_LEVEL_PROCEDURE fnd_log_messages.log_level%TYPE;
844: IS_DEBUG_PROCEDURE_ON BOOLEAN;
845: l_xmp_tbl xmp_tbl_type := p_xmp_tbl;
846: l_api_version NUMBER ;
847: l_init_msg_list VARCHAR2(1) ;

Line 857: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;

853:
854: BEGIN
855: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;
856: IF(L_DEBUG_ENABLED='Y') THEN
857: L_LEVEL_PROCEDURE :=Fnd_Log.LEVEL_PROCEDURE;
858: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);
859: END IF;
860: IF(IS_DEBUG_PROCEDURE_ON) THEN
861: BEGIN