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.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_LOG

Line 74: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

70: l_Approval_Status VARCHAR2(1);
71: l_Approver_Name VARCHAR2(100);
72: l_Step VARCHAR2(100);
73: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
74: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
75: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
78: CURSOR c_Journal IS

Line 75: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

71: l_Approver_Name VARCHAR2(100);
72: l_Step VARCHAR2(100);
73: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
74: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
75: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
78: CURSOR c_Journal IS
79: SELECT DISTINCT Jop.Je_Header_Id

Line 76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

72: l_Step VARCHAR2(100);
73: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
74: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
75: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
78: CURSOR c_Journal IS
79: SELECT DISTINCT Jop.Je_Header_Id
80: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs

Line 77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

73: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
74: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
75: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
76: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
77: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
78: CURSOR c_Journal IS
79: SELECT DISTINCT Jop.Je_Header_Id
80: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs
81: WHERE Jop.Request_Id = l_Request_Id

Line 124: Fnd_Log.STRING(l_Proc_Level,

120:
121: BEGIN
122: --log
123: IF (l_Proc_Level >= l_Dbg_Level) THEN
124: Fnd_Log.STRING(l_Proc_Level,
125: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
126: 'begin procedure');
127:
128: END IF; --l_procedure_level >= l_runtime_level

Line 172: Fnd_Log.STRING(l_Proc_Level,

168:
169: CLOSE c_Journal;
170: -- log for debug
171: IF (l_Proc_Level >= l_Dbg_Level) THEN
172: Fnd_Log.STRING(l_Proc_Level,
173: l_Module_Prefix || '.' || l_Proc_Name || '.end',
174: 'Enter procedure');
175: END IF; --(l_proc_level >= l_dbg_level)
176: EXCEPTION

Line 181: Fnd_Log.STRING(l_Proc_Level,

177: WHEN OTHERS THEN
178: Fnd_File.Put_Line(Fnd_File.Log, 'l_step:' || l_Step);
179: --log for debug
180: IF (l_Proc_Level >= l_Dbg_Level) THEN
181: Fnd_Log.STRING(l_Proc_Level,
182: l_Module_Prefix || '.' || l_Proc_Name ||
183: '. Other_Exception ',
184: SQLCODE || ':' || SQLERRM);
185: END IF; --(l_proc_level >= l_dbg_level)

Line 215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

211: RETURN VARCHAR2 IS
212:
213: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
214: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
219:

Line 216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

212:
213: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
214: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
219:
220: -- this cursor is to get looup_meaning under some lookup_code

Line 217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

213: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
214: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
219:
220: -- this cursor is to get looup_meaning under some lookup_code
221: CURSOR c_Lookup IS

Line 218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

214: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
215: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
216: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
217: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
218: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
219:
220: -- this cursor is to get looup_meaning under some lookup_code
221: CURSOR c_Lookup IS
222: SELECT Flv.Lookup_Code

Line 233: Fnd_Log.STRING(l_Procedure_Level,

229:
230: BEGIN
231: --log
232: IF (l_Procedure_Level >= l_Runtime_Level) THEN
233: Fnd_Log.STRING(l_Procedure_Level,
234: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
235: 'begin procedure');
236: END IF; --l_procedure_level >= l_runtime_level
237:

Line 252: Fnd_Log.STRING(l_Procedure_Level,

248: END IF; --IF p_lookup_code IS NULL
249:
250: --log
251: IF (l_Procedure_Level >= l_Runtime_Level) THEN
252: Fnd_Log.STRING(l_Procedure_Level,
253: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
254: 'end procedure');
255: END IF; --l_procedure_level >= l_runtime_level
256:

Line 296: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

292: l_ledger_id number;
293: l_legal_entity_id number;
294: -- l_Populate_Bsv_Flag number;
295: -- l_Populate_Bsv_F varchar2(1);
296: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
297: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
298: l_Proc_Name VARCHAR2(100) := 'populate_journal_of_period';
299: l_Populate_Bsv_Flag VARCHAR2(1);
300: BEGIN

Line 297: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

293: l_legal_entity_id number;
294: -- l_Populate_Bsv_Flag number;
295: -- l_Populate_Bsv_F varchar2(1);
296: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
297: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
298: l_Proc_Name VARCHAR2(100) := 'populate_journal_of_period';
299: l_Populate_Bsv_Flag VARCHAR2(1);
300: BEGIN
301:

Line 304: Fnd_Log.STRING(l_Proc_Level,

300: BEGIN
301:
302: --log for debug
303: IF (l_Proc_Level >= l_Dbg_Level) THEN
304: Fnd_Log.STRING(l_Proc_Level,
305: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
306: 'Enter procedure');
307: Fnd_Log.STRING(l_Proc_Level,
308: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 307: Fnd_Log.STRING(l_Proc_Level,

303: IF (l_Proc_Level >= l_Dbg_Level) THEN
304: Fnd_Log.STRING(l_Proc_Level,
305: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
306: 'Enter procedure');
307: Fnd_Log.STRING(l_Proc_Level,
308: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
309: 'p_start_period: ' || p_Start_Period);
310: Fnd_Log.STRING(l_Proc_Level,
311: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 310: Fnd_Log.STRING(l_Proc_Level,

306: 'Enter procedure');
307: Fnd_Log.STRING(l_Proc_Level,
308: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
309: 'p_start_period: ' || p_Start_Period);
310: Fnd_Log.STRING(l_Proc_Level,
311: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
312: 'p_end_period: ' || p_End_Period);
313: Fnd_Log.STRING(l_Proc_Level,
314: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 313: Fnd_Log.STRING(l_Proc_Level,

309: 'p_start_period: ' || p_Start_Period);
310: Fnd_Log.STRING(l_Proc_Level,
311: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
312: 'p_end_period: ' || p_End_Period);
313: Fnd_Log.STRING(l_Proc_Level,
314: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
315: 'p_request_id: ' || p_Request_Id);
316: END IF; --(l_proc_level >= l_dbg_level)
317:

Line 328: Fnd_Log.STRING(l_Proc_Level,

324: l_Populate_Bsv_Flag := Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(l_Ledger_Id,
325: l_Legal_Entity_Id);
326: IF l_Populate_Bsv_Flag = 'F' THEN
327: IF (l_Proc_Level >= l_Dbg_Level) THEN
328: Fnd_Log.STRING(l_Proc_Level,
329: l_Module_Prefix || '.' || l_Proc_Name,
330: 'fail to populate BSV');
331: END IF; --(l_proc_level >= l_dbg_level)
332: END IF;

Line 401: Fnd_Log.STRING(l_Proc_Level,

397: ' ,''U'') <> ''P''';
398:
399: --log for debug
400: IF (l_Proc_Level >= l_Dbg_Level) THEN
401: Fnd_Log.STRING(l_Proc_Level,
402: l_Module_Prefix || '.' || l_Proc_Name,
403: 'l_populate_journal_sql:' || l_Populate_Journal_Sql);
404: END IF; --(l_proc_level >= l_dbg_level)
405:

Line 410: Fnd_Log.STRING(l_Proc_Level,

406: EXECUTE IMMEDIATE l_Populate_Journal_Sql;
407: COMMIT;
408: -- log for debug
409: IF (l_Proc_Level >= l_Dbg_Level) THEN
410: Fnd_Log.STRING(l_Proc_Level,
411: l_Module_Prefix || '.' || l_Proc_Name || '.end',
412: 'Enter procedure');
413: END IF; --(l_proc_level >= l_dbg_level)
414: EXCEPTION

Line 419: Fnd_Log.STRING(l_Proc_Level,

415: WHEN OTHERS THEN
416:
417: --log for debug
418: IF (l_Proc_Level >= l_Dbg_Level) THEN
419: Fnd_Log.STRING(l_Proc_Level,
420: l_Module_Prefix || '.' || l_Proc_Name ||
421: '. Other_Exception ',
422: SQLCODE || ':' || SQLERRM);
423: END IF; --(l_proc_level >= l_dbg_level)

Line 455: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

451: l_Company_Column_Name VARCHAR2(30);
452: l_Account_Column_Name VARCHAR2(30);
453: l_Cost_Column_Name VARCHAR2(30);
454: l_Project_Column_Name VARCHAR2(30);
455: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
456: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
457: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
458: l_Second_Track_Col_Name VARCHAR2(30);
459: l_Other_Cols_Name VARCHAR2(200);

Line 456: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

452: l_Account_Column_Name VARCHAR2(30);
453: l_Cost_Column_Name VARCHAR2(30);
454: l_Project_Column_Name VARCHAR2(30);
455: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
456: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
457: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
458: l_Second_Track_Col_Name VARCHAR2(30);
459: l_Other_Cols_Name VARCHAR2(200);
460: l_ledger_id number;

Line 505: Fnd_Log.STRING(l_Proc_Level,

501: BEGIN
502:
503: --log for debug
504: IF (l_Proc_Level >= l_Dbg_Level) THEN
505: Fnd_Log.STRING(l_Proc_Level,
506: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
507: 'Enter procedure');
508: END IF; --(l_proc_level >= l_dbg_level)
509: l_ledger_id := p_ledger_id;

Line 621: Fnd_Log.STRING(l_Proc_Level,

617: l_Create_View_Sql;
618:
619: --log for debug
620: IF (l_Proc_Level >= l_Dbg_Level) THEN
621: Fnd_Log.STRING(l_Proc_Level,
622: l_Module_Prefix || '.' || l_Proc_Name,
623: 'l_create_view_sql:' || l_Create_View_Sql);
624: END IF; --(l_proc_level >= l_dbg_level)
625:

Line 630: Fnd_Log.STRING(l_Proc_Level,

626: EXECUTE IMMEDIATE l_Create_View_Sql;
627:
628: --log for dubug
629: IF (l_Proc_Level >= l_Dbg_Level) THEN
630: Fnd_Log.STRING(l_Proc_Level,
631: l_Module_Prefix || '.' || l_Proc_Name || '.end',
632: 'Enter procedure');
633: END IF; --(l_proc_level >= l_dbg_level)
634:

Line 640: Fnd_Log.STRING(l_Proc_Level,

636: WHEN OTHERS THEN
637: FND_FILE.put_line(FND_FILE.OUTPUT,SQLCODE || ':' || SQLERRM);
638: --log for debug
639: IF (l_Proc_Level >= l_Dbg_Level) THEN
640: Fnd_Log.STRING(l_Proc_Level,
641: l_Module_Prefix || '.' || l_Proc_Name ||
642: '. Other_Exception ',
643: SQLCODE || ':' || SQLERRM);
644: END IF; --(l_proc_level >= l_dbg_level)

Line 671: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

667: p_Start_Period_Name OUT NOCOPY VARCHAR2,
668: p_End_Period_Name OUT NOCOPY VARCHAR2) IS
669:
670: l_Period_Name VARCHAR2(15);
671: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
672: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
673: l_Proc_Name VARCHAR2(100) := 'get_period_range';
674: l_ledger_id number;
675: BEGIN

Line 672: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

668: p_End_Period_Name OUT NOCOPY VARCHAR2) IS
669:
670: l_Period_Name VARCHAR2(15);
671: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
672: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
673: l_Proc_Name VARCHAR2(100) := 'get_period_range';
674: l_ledger_id number;
675: BEGIN
676:

Line 679: Fnd_Log.STRING(l_Proc_Level,

675: BEGIN
676:
677: --log for debug
678: IF (l_Proc_Level >= l_Dbg_Level) THEN
679: Fnd_Log.STRING(l_Proc_Level,
680: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
681: 'Enter procedure');
682: Fnd_Log.STRING(l_Proc_Level,
683: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 682: Fnd_Log.STRING(l_Proc_Level,

678: IF (l_Proc_Level >= l_Dbg_Level) THEN
679: Fnd_Log.STRING(l_Proc_Level,
680: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
681: 'Enter procedure');
682: Fnd_Log.STRING(l_Proc_Level,
683: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
684: 'P_period_name:' || p_Period_Name);
685: END IF; --(l_proc_level >= l_dbg_level)
686:

Line 721: Fnd_Log.STRING(l_Proc_Level,

717: END IF; --l_period_name IS NULL
718:
719: --log for debug
720: IF (l_Proc_Level >= l_Dbg_Level) THEN
721: Fnd_Log.STRING(l_Proc_Level,
722: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
723: 'p_start_period_name: ' || p_Start_Period_Name);
724: Fnd_Log.STRING(l_Proc_Level,
725: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 724: Fnd_Log.STRING(l_Proc_Level,

720: IF (l_Proc_Level >= l_Dbg_Level) THEN
721: Fnd_Log.STRING(l_Proc_Level,
722: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
723: 'p_start_period_name: ' || p_Start_Period_Name);
724: Fnd_Log.STRING(l_Proc_Level,
725: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
726: 'p_end_period_name: ' || p_End_Period_Name);
727: Fnd_Log.STRING(l_Proc_Level,
728: l_Module_Prefix || '.' || l_Proc_Name || '.end',

Line 727: Fnd_Log.STRING(l_Proc_Level,

723: 'p_start_period_name: ' || p_Start_Period_Name);
724: Fnd_Log.STRING(l_Proc_Level,
725: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
726: 'p_end_period_name: ' || p_End_Period_Name);
727: Fnd_Log.STRING(l_Proc_Level,
728: l_Module_Prefix || '.' || l_Proc_Name || '.end',
729: 'Exit procedure');
730: END IF; --( l_proc_level >= l_dbg_level )
731:

Line 737: Fnd_Log.STRING(l_Proc_Level,

733: WHEN OTHERS THEN
734:
735: --log for debug
736: IF (l_Proc_Level >= l_Dbg_Level) THEN
737: Fnd_Log.STRING(l_Proc_Level,
738: l_Module_Prefix || '.' || l_Proc_Name ||
739: '. Other_Exception ',
740: SQLCODE || ':' || SQLERRM);
741: END IF; --(l_proc_level >= l_dbg_level)

Line 767: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

763: l_Request_Id NUMBER;
764: l_Je_Line_Num NUMBER;
765: l_Je_Header_Id NUMBER;
766: l_Error_Msg VARCHAR2(2000);
767: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
768: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
769: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
770: CURSOR c_Unmatch_Lines IS
771: SELECT /*+ index(jel,gl_je_lines_u1)*/

Line 768: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

764: l_Je_Line_Num NUMBER;
765: l_Je_Header_Id NUMBER;
766: l_Error_Msg VARCHAR2(2000);
767: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
768: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
769: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
770: CURSOR c_Unmatch_Lines IS
771: SELECT /*+ index(jel,gl_je_lines_u1)*/
772: Req.Je_Header_Id, Req.Je_Line_Num

Line 790: Fnd_Log.STRING(l_Proc_Level,

786: AND Jel.Je_Header_Id = Req.Je_Header_Id;
787: BEGIN
788: --log for debug
789: IF (l_Proc_Level >= l_Dbg_Level) THEN
790: Fnd_Log.STRING(l_Proc_Level,
791: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
792: 'Enter procedure');
793: Fnd_Log.STRING(l_Proc_Level,
794: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 793: Fnd_Log.STRING(l_Proc_Level,

789: IF (l_Proc_Level >= l_Dbg_Level) THEN
790: Fnd_Log.STRING(l_Proc_Level,
791: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
792: 'Enter procedure');
793: Fnd_Log.STRING(l_Proc_Level,
794: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
795: 'P_request_id:' || p_Request_Id);
796: END IF; --(l_proc_level >= l_dbg_level)
797:

Line 816: Fnd_Log.STRING(l_Proc_Level,

812: Fnd_File.Put_Line(Fnd_File.Log, l_Error_Msg);
813:
814: -- log for debug
815: IF (l_Proc_Level >= l_Dbg_Level) THEN
816: Fnd_Log.STRING(l_Proc_Level,
817: l_Module_Prefix || '.' || l_Proc_Name,
818: l_Error_Msg);
819: END IF; --(l_proc_level >= l_dbg_level)
820:

Line 831: Fnd_Log.STRING(l_Proc_Level,

827: CLOSE c_Unmatch_Lines;
828:
829: -- log for debug
830: IF (l_Proc_Level >= l_Dbg_Level) THEN
831: Fnd_Log.STRING(l_Proc_Level,
832: l_Module_Prefix || '.' || l_Proc_Name || '.end',
833: 'Enter procedure');
834: END IF; --(l_proc_level >= l_dbg_level)
835: EXCEPTION

Line 840: Fnd_Log.STRING(l_Proc_Level,

836: WHEN OTHERS THEN
837:
838: --log for debug
839: IF (l_Proc_Level >= l_Dbg_Level) THEN
840: Fnd_Log.STRING(l_Proc_Level,
841: l_Module_Prefix || '.' || l_Proc_Name ||
842: '. Other_Exception ',
843: SQLCODE || ':' || SQLERRM);
844: END IF; --(l_proc_level >= l_dbg_level)

Line 872: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

868: p_Request_Id IN NUMBER) IS
869:
870: l_Request_Id NUMBER;
871: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
872: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
873: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
874: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
875:
876: BEGIN

Line 873: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

869:
870: l_Request_Id NUMBER;
871: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
872: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
873: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
874: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
875:
876: BEGIN
877:

Line 880: Fnd_Log.STRING(l_Proc_Level,

876: BEGIN
877:
878: --log for debug
879: IF (l_Proc_Level >= l_Dbg_Level) THEN
880: Fnd_Log.STRING(l_Proc_Level,
881: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
882: 'Enter procedure');
883: Fnd_Log.STRING(l_Proc_Level,
884: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 883: Fnd_Log.STRING(l_Proc_Level,

879: IF (l_Proc_Level >= l_Dbg_Level) THEN
880: Fnd_Log.STRING(l_Proc_Level,
881: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
882: 'Enter procedure');
883: Fnd_Log.STRING(l_Proc_Level,
884: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
885: 'P_request_id:' || p_Request_Id);
886: Fnd_Log.STRING(l_Proc_Level,
887: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 886: Fnd_Log.STRING(l_Proc_Level,

882: 'Enter procedure');
883: Fnd_Log.STRING(l_Proc_Level,
884: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
885: 'P_request_id:' || p_Request_Id);
886: Fnd_Log.STRING(l_Proc_Level,
887: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
888: 'p_project_option:' || p_Project_Option);
889:
890: END IF; --(l_proc_level >= l_dbg_level)

Line 995: Fnd_Log.STRING(l_Proc_Level,

991: AND Jeb.Je_Batch_Id=Jeh.Je_Batch_Id;--added by lyb, for bug 6654734
992:
993: -- log for debug
994: IF (l_Proc_Level >= l_Dbg_Level) THEN
995: Fnd_Log.STRING(l_Proc_Level,
996: l_Module_Prefix || '.' || l_Proc_Name || '.end',
997: 'Enter procedure');
998: END IF; --(l_proc_level >= l_dbg_level)
999: EXCEPTION

Line 1005: Fnd_Log.STRING(l_Proc_Level,

1001: ROLLBACK;
1002:
1003: --log for debug
1004: IF (l_Proc_Level >= l_Dbg_Level) THEN
1005: Fnd_Log.STRING(l_Proc_Level,
1006: l_Module_Prefix || '.' || l_Proc_Name ||
1007: '. Other_Exception ',
1008: SQLCODE || ':' || SQLERRM);
1009: END IF; --(l_proc_level >= l_dbg_level)

Line 1043: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1039: l_Je_Appending_Id NUMBER;
1040: l_Line_Num_m NUMBER;
1041: l_ledger_id number;
1042: l_legal_entity_id number;
1043: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1044: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1045: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1046:
1047: CURSOR c_Journal IS

Line 1044: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1040: l_Line_Num_m NUMBER;
1041: l_ledger_id number;
1042: l_legal_entity_id number;
1043: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1044: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1045: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1046:
1047: CURSOR c_Journal IS
1048: SELECT Je_Header_Id

Line 1069: Fnd_Log.STRING(l_Proc_Level,

1065:
1066: BEGIN
1067: --log for debug
1068: IF (l_Proc_Level >= l_Dbg_Level) THEN
1069: Fnd_Log.STRING(l_Proc_Level,
1070: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1071: 'Enter procedure');
1072: END IF; --(l_proc_level >= l_dbg_level)
1073:

Line 1126: Fnd_Log.STRING(l_Proc_Level,

1122: CLOSE c_Journal;
1123: EXCEPTION
1124: WHEN OTHERS THEN
1125: IF (l_Proc_Level >= l_Dbg_Level) THEN
1126: Fnd_Log.STRING(l_Proc_Level,
1127: l_Module_Prefix || '.' || l_Proc_Name ||
1128: '. Other_Exception ',
1129: SQLCODE || ':' || SQLERRM);
1130: END IF; --(l_proc_level >= l_dbg_level)

Line 1155: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1151:
1152: PROCEDURE Itemize_Journals_Sla(p_chart_of_accounts_id in number,
1153: p_Request_Id IN NUMBER) IS
1154: l_Request_Id NUMBER;
1155: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1156: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1157: l_Proc_Name VARCHAR2(100) := 'ITEMIZE_JOURNALS_SLA';
1158: l_Project_Source_Flag VARCHAR2(15);
1159: l_Project_Ac_Code VARCHAR2(30);

Line 1156: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1152: PROCEDURE Itemize_Journals_Sla(p_chart_of_accounts_id in number,
1153: p_Request_Id IN NUMBER) IS
1154: l_Request_Id NUMBER;
1155: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1156: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1157: l_Proc_Name VARCHAR2(100) := 'ITEMIZE_JOURNALS_SLA';
1158: l_Project_Source_Flag VARCHAR2(15);
1159: l_Project_Ac_Code VARCHAR2(30);
1160: l_Project_Ac_Detail_Code VARCHAR2(30);

Line 1177: Fnd_Log.STRING(l_Proc_Level,

1173:
1174: BEGIN
1175: --log for debug
1176: IF (l_Proc_Level >= l_Dbg_Level) THEN
1177: Fnd_Log.STRING(l_Proc_Level,
1178: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1179: 'Enter procedure');
1180: END IF; --(l_proc_level >= l_dbg_level)
1181: l_Chart_Of_Accounts_Id := p_chart_of_accounts_id;

Line 1478: Fnd_Log.STRING(l_Proc_Level,

1474:
1475: EXCEPTION
1476: WHEN OTHERS THEN
1477: IF (l_Proc_Level >= l_Dbg_Level) THEN
1478: Fnd_Log.STRING(l_Proc_Level,
1479: l_Module_Prefix || '.' || l_Proc_Name ||
1480: '. Other_Exception ',
1481: SQLCODE || ':' || SQLERRM);
1482: END IF; --(l_proc_level >= l_dbg_level)

Line 1516: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1512: p_Legal_Entity_Id IN NUMBER,
1513: p_Period_Name IN VARCHAR2) IS
1514:
1515: l_Error_Msg VARCHAR2(2000);
1516: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1517: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1518: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
1519: l_Phase VARCHAR2(100);
1520: l_Status VARCHAR2(100);

Line 1517: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1513: p_Period_Name IN VARCHAR2) IS
1514:
1515: l_Error_Msg VARCHAR2(2000);
1516: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1517: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1518: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
1519: l_Phase VARCHAR2(100);
1520: l_Status VARCHAR2(100);
1521: l_Dev_Phase VARCHAR2(100);

Line 1569: Fnd_Log.STRING(l_Proc_Level,

1565: BEGIN
1566:
1567: --log for debug
1568: IF (l_Proc_Level >= l_Dbg_Level) THEN
1569: Fnd_Log.STRING(l_Proc_Level,
1570: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1571: 'Enter procedure');
1572: Fnd_Log.STRING(l_Proc_Level,
1573: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 1572: Fnd_Log.STRING(l_Proc_Level,

1568: IF (l_Proc_Level >= l_Dbg_Level) THEN
1569: Fnd_Log.STRING(l_Proc_Level,
1570: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1571: 'Enter procedure');
1572: Fnd_Log.STRING(l_Proc_Level,
1573: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1574: 'p_period_name:' || p_Period_Name);
1575: Fnd_Log.STRING(l_Proc_Level,
1576: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 1575: Fnd_Log.STRING(l_Proc_Level,

1571: 'Enter procedure');
1572: Fnd_Log.STRING(l_Proc_Level,
1573: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1574: 'p_period_name:' || p_Period_Name);
1575: Fnd_Log.STRING(l_Proc_Level,
1576: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1577: 'p_legal_entity_id:' || p_Legal_Entity_Id);
1578: END IF; --(l_proc_level >= l_dbg_level)
1579:

Line 1585: Fnd_Log.STRING(l_Proc_Level, l_Dbg_Level, 'Check profile failed!');

1581: /* IF Ja_Cn_Utility.Check_Profile() <> TRUE THEN
1582:
1583: --log for debug
1584: IF (l_Proc_Level >= l_Dbg_Level) THEN
1585: Fnd_Log.STRING(l_Proc_Level, l_Dbg_Level, 'Check profile failed!');
1586: END IF; --(l_proc_level >= l_dbg_level)
1587: l_Conc_Succ := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
1588: Message => '');
1589: RETURN;

Line 1598: Fnd_Log.STRING(l_Proc_Level,

1594: l_ledger_id := p_Ledger_Id;
1595:
1596: --log for debug
1597: IF (l_Proc_Level >= l_Dbg_Level) THEN
1598: Fnd_Log.STRING(l_Proc_Level,
1599: l_Module_Prefix || '.' || l_Proc_Name ||
1600: '.current set of books id',
1601: 'set of book id is ' || l_Ledger_Id);
1602: END IF; --l_exception_level >= l_runtime_level

Line 1618: Fnd_Log.STRING(l_Proc_Level,

1614: END IF; --(c_project_option%NOTFOUND)
1615:
1616: --log for debug
1617: IF (l_Proc_Level >= l_Dbg_Level) THEN
1618: Fnd_Log.STRING(l_Proc_Level,
1619: l_Module_Prefix || '.' || l_Proc_Name ||
1620: '.setup information',
1621: 'project option is ' || l_Project_Option);
1622: END IF; --l_exception_level >= l_runtime_level

Line 1851: Fnd_Log.STRING(l_Proc_Level,

1847: l_Execution_Fail_Module := 'Post';
1848:
1849: --log for debug
1850: IF (l_Proc_Level >= l_Dbg_Level) THEN
1851: Fnd_Log.STRING(l_Proc_Level,
1852: l_Module_Prefix || '.' || l_Proc_Name ||
1853: '.JACNGLJT.EXECUTION',
1854: 'l_status.' || l_Status || '--' || 'l_phase.' ||
1855: l_Phase);

Line 1864: Fnd_Log.STRING(l_Proc_Level,

1860: END IF; --l_post_con_req_id <> 0
1861:
1862: --log for debug
1863: IF (l_Proc_Level >= l_Dbg_Level) THEN
1864: Fnd_Log.STRING(l_Proc_Level,
1865: l_Module_Prefix || '.' || l_Proc_Name || '.end',
1866: 'Exit procedure');
1867: END IF; --( l_proc_level >= l_dbg_level )
1868:

Line 1874: Fnd_Log.STRING(l_Proc_Level,

1870: WHEN l_Post_Fail THEN
1871: -- dbms_output.put_line('Post Program fails,please connect your system ');
1872: --log for debug
1873: IF (l_Proc_Level >= l_Dbg_Level) THEN
1874: Fnd_Log.STRING(l_Proc_Level,
1875: l_Module_Prefix || '.' || l_Proc_Name ||
1876: '. Other_Exception ',
1877: SQLCODE || ':' || SQLERRM);
1878: END IF; --(l_proc_level >= l_dbg_level)

Line 1898: Fnd_Log.STRING(l_Proc_Level,

1894: Message => SQLCODE || ':' ||
1895: SQLERRM);
1896: --log for debug
1897: IF (l_Proc_Level >= l_Dbg_Level) THEN
1898: Fnd_Log.STRING(l_Proc_Level,
1899: l_Module_Prefix || '.' || l_Proc_Name ||
1900: '. Other_Exception ',
1901: SQLCODE || ':' || SQLERRM);
1902: END IF; --(l_proc_level >= l_dbg_level)