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_XMLP_PARAMS_PVT dependencies on OKL_DEBUG_PUB

Line 48: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

44: -- DECLARE Cursors
45: -------------------
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;

Line 51: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
55: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line 55: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

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
55: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
56: END;
57: END IF;
58:
59: l_xmp_rec := p_xmp_rec;

Line 101: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

97: x_msg_count := l_msg_count;
98:
99: IF(IS_DEBUG_PROCEDURE_ON) THEN
100: BEGIN
101: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
102: END;
103: END IF;
104:
105: EXCEPTION

Line 186: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

182: -- DECLARE Cursors
183: -------------------
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;

Line 189: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
193: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

Line 193: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

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
193: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
194: END;
195: END IF;
196:
197: l_xmp_tbl := p_xmp_tbl;

Line 239: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');

235: x_msg_count := l_msg_count;
236:
237: IF(IS_DEBUG_PROCEDURE_ON) THEN
238: BEGIN
239: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.insert_row ');
240: END;
241: END IF;
242:
243: EXCEPTION

Line 321: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

317: -- DECLARE Cursors
318: -------------------
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;

Line 324: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
328: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line 328: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

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
328: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
329: END;
330: END IF;
331: l_xmp_rec := p_xmp_rec;
332: l_api_version := 1.0;

Line 373: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

369: x_msg_count := l_msg_count;
370:
371: IF(IS_DEBUG_PROCEDURE_ON) THEN
372: BEGIN
373: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
374: END;
375: END IF;
376:
377: EXCEPTION

Line 454: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

450: -- DECLARE Cursors
451: -------------------
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;

Line 457: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
461: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

Line 461: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

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
461: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
462: END;
463: END IF;
464: l_xmp_tbl := p_xmp_tbl;
465: l_api_version := 1.0;

Line 506: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');

502: x_msg_count := l_msg_count;
503:
504: IF(IS_DEBUG_PROCEDURE_ON) THEN
505: BEGIN
506: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.update_row ');
507: END;
508: END IF;
509:
510: EXCEPTION

Line 595: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

591: FROM OKL_XMLP_PARAMS
592: WHERE BATCH_ID = p_batch_id;
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;

Line 598: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
602: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

Line 602: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

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
602: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');
603: END;
604: END IF;
605: l_batch_id := p_batch_id;
606: l_api_version := 1.0;

Line 650: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');

646: x_msg_count := l_msg_count;
647:
648: IF(IS_DEBUG_PROCEDURE_ON) THEN
649: BEGIN
650: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.delete_row ');
651: END;
652: END IF;
653:
654: EXCEPTION

Line 730: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

726: -- DECLARE Cursors
727: -------------------
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;

Line 733: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
737: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

Line 737: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

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
737: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
738: END;
739: END IF;
740: l_api_version := 1.0;
741: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 783: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

779: x_msg_data => x_msg_data);
780:
781: IF(IS_DEBUG_PROCEDURE_ON) THEN
782: BEGIN
783: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
784: END;
785: END IF;
786:
787: EXCEPTION

Line 855: L_DEBUG_ENABLED := Okl_Debug_Pub.CHECK_LOG_ENABLED;

851: l_api_name CONSTANT VARCHAR2(30) := 'validate_xmlp_params_tbl';
852:
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;

Line 858: IS_DEBUG_PROCEDURE_ON := Okl_Debug_Pub.Check_Log_On(L_MODULE, L_LEVEL_PROCEDURE);

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
862: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

Line 862: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

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
862: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'Begin Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
863: END;
864: END IF;
865: l_api_version := 1.0;
866: l_return_status := OKL_API.G_RET_STS_SUCCESS;

Line 909: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');

905: x_msg_data => x_msg_data);
906:
907: IF(IS_DEBUG_PROCEDURE_ON) THEN
908: BEGIN
909: Okl_Debug_Pub.LOG_DEBUG(L_LEVEL_PROCEDURE,L_MODULE,'End Debug OKLRXMPB.pls call okl_xmp_pvt.validate_row ');
910: END;
911: END IF;
912:
913: EXCEPTION