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 93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

89: l_Approval_Status VARCHAR2(1);
90: l_Approver_Name VARCHAR2(100);
91: l_Step VARCHAR2(100);
92: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
97: CURSOR c_Journal IS

Line 94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

90: l_Approver_Name VARCHAR2(100);
91: l_Step VARCHAR2(100);
92: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
97: CURSOR c_Journal IS
98: SELECT DISTINCT Jop.Je_Header_Id

Line 95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

91: l_Step VARCHAR2(100);
92: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
97: CURSOR c_Journal IS
98: SELECT DISTINCT Jop.Je_Header_Id
99: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs

Line 96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

92: l_Proc_Name VARCHAR2(30) := 'get_journal_approver';
93: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
94: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
95: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
96: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
97: CURSOR c_Journal IS
98: SELECT DISTINCT Jop.Je_Header_Id
99: FROM Ja_Cn_Journals_Of_Period Jop, Gl_Je_Sources_Tl Gjs
100: WHERE Jop.Request_Id = l_Request_Id

Line 143: Fnd_Log.STRING(l_Proc_Level,

139:
140: BEGIN
141: --log
142: IF (l_Proc_Level >= l_Dbg_Level) THEN
143: Fnd_Log.STRING(l_Proc_Level,
144: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
145: 'begin procedure');
146:
147: END IF; --l_procedure_level >= l_runtime_level

Line 191: Fnd_Log.STRING(l_Proc_Level,

187:
188: CLOSE c_Journal;
189: -- log for debug
190: IF (l_Proc_Level >= l_Dbg_Level) THEN
191: Fnd_Log.STRING(l_Proc_Level,
192: l_Module_Prefix || '.' || l_Proc_Name || '.end',
193: 'Enter procedure');
194: END IF; --(l_proc_level >= l_dbg_level)
195: EXCEPTION

Line 200: Fnd_Log.STRING(l_Proc_Level,

196: WHEN OTHERS THEN
197: Fnd_File.Put_Line(Fnd_File.Log, 'l_step:' || l_Step);
198: --log for debug
199: IF (l_Proc_Level >= l_Dbg_Level) THEN
200: Fnd_Log.STRING(l_Proc_Level,
201: l_Module_Prefix || '.' || l_Proc_Name ||
202: '. Other_Exception ',
203: SQLCODE || ':' || SQLERRM);
204: END IF; --(l_proc_level >= l_dbg_level)

Line 234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

230: RETURN VARCHAR2 IS
231:
232: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
233: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
238:

Line 235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

231:
232: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
233: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
238:
239: -- this cursor is to get looup_meaning under some lookup_code

Line 236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

232: l_Procedure_Name VARCHAR2(30) := 'get_lookup_code';
233: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
238:
239: -- this cursor is to get looup_meaning under some lookup_code
240: CURSOR c_Lookup IS

Line 237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

233: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
234: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
235: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
236: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
237: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
238:
239: -- this cursor is to get looup_meaning under some lookup_code
240: CURSOR c_Lookup IS
241: SELECT Flv.Lookup_Code

Line 252: Fnd_Log.STRING(l_Procedure_Level,

248:
249: BEGIN
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 || '.begin',
254: 'begin procedure');
255: END IF; --l_procedure_level >= l_runtime_level
256:

Line 271: Fnd_Log.STRING(l_Procedure_Level,

267: END IF; --IF p_lookup_code IS NULL
268:
269: --log
270: IF (l_Procedure_Level >= l_Runtime_Level) THEN
271: Fnd_Log.STRING(l_Procedure_Level,
272: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
273: 'end procedure');
274: END IF; --l_procedure_level >= l_runtime_level
275:

Line 316: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

312: l_ledger_id number;
313: l_legal_entity_id number;
314: -- l_Populate_Bsv_Flag number;
315: -- l_Populate_Bsv_F varchar2(1);
316: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
317: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
318: l_Proc_Name VARCHAR2(100) := 'populate_journal_of_period';
319: l_Populate_Bsv_Flag VARCHAR2(1);
320: BEGIN

Line 317: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

313: l_legal_entity_id number;
314: -- l_Populate_Bsv_Flag number;
315: -- l_Populate_Bsv_F varchar2(1);
316: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
317: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
318: l_Proc_Name VARCHAR2(100) := 'populate_journal_of_period';
319: l_Populate_Bsv_Flag VARCHAR2(1);
320: BEGIN
321:

Line 324: Fnd_Log.STRING(l_Proc_Level,

320: BEGIN
321:
322: --log for debug
323: IF (l_Proc_Level >= l_Dbg_Level) THEN
324: Fnd_Log.STRING(l_Proc_Level,
325: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
326: 'Enter procedure');
327: Fnd_Log.STRING(l_Proc_Level,
328: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 327: Fnd_Log.STRING(l_Proc_Level,

323: IF (l_Proc_Level >= l_Dbg_Level) THEN
324: Fnd_Log.STRING(l_Proc_Level,
325: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
326: 'Enter procedure');
327: Fnd_Log.STRING(l_Proc_Level,
328: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
329: 'p_start_period: ' || p_Start_Period);
330: Fnd_Log.STRING(l_Proc_Level,
331: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 330: Fnd_Log.STRING(l_Proc_Level,

326: 'Enter procedure');
327: Fnd_Log.STRING(l_Proc_Level,
328: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
329: 'p_start_period: ' || p_Start_Period);
330: Fnd_Log.STRING(l_Proc_Level,
331: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
332: 'p_end_period: ' || p_End_Period);
333: Fnd_Log.STRING(l_Proc_Level,
334: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 333: Fnd_Log.STRING(l_Proc_Level,

329: 'p_start_period: ' || p_Start_Period);
330: Fnd_Log.STRING(l_Proc_Level,
331: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
332: 'p_end_period: ' || p_End_Period);
333: Fnd_Log.STRING(l_Proc_Level,
334: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
335: 'p_request_id: ' || p_Request_Id);
336: END IF; --(l_proc_level >= l_dbg_level)
337:

Line 348: Fnd_Log.STRING(l_Proc_Level,

344: l_Populate_Bsv_Flag := Ja_Cn_Utility.Populate_Ledger_Le_Bsv_Gt(l_Ledger_Id,
345: l_Legal_Entity_Id);
346: IF l_Populate_Bsv_Flag = 'F' THEN
347: IF (l_Proc_Level >= l_Dbg_Level) THEN
348: Fnd_Log.STRING(l_Proc_Level,
349: l_Module_Prefix || '.' || l_Proc_Name,
350: 'fail to populate BSV');
351: END IF; --(l_proc_level >= l_dbg_level)
352: END IF;

Line 422: Fnd_Log.STRING(l_Proc_Level,

418: ' AND jeh.ACTUAL_FLAG <> ''B''' || --Added for fixing bug#10316599 01-December-2010
419: ' AND jeh.ACTUAL_FLAG <> ''E'''; --Added for fixing bug#8670470 by Chaoqun on 09-JUL-2009
420: --log for debug
421: IF (l_Proc_Level >= l_Dbg_Level) THEN
422: Fnd_Log.STRING(l_Proc_Level,
423: l_Module_Prefix || '.' || l_Proc_Name,
424: 'l_populate_journal_sql:' || l_Populate_Journal_Sql);
425: END IF; --(l_proc_level >= l_dbg_level)
426:

Line 431: Fnd_Log.STRING(l_Proc_Level,

427: EXECUTE IMMEDIATE l_Populate_Journal_Sql;
428: COMMIT;
429: -- log for debug
430: IF (l_Proc_Level >= l_Dbg_Level) THEN
431: Fnd_Log.STRING(l_Proc_Level,
432: l_Module_Prefix || '.' || l_Proc_Name || '.end',
433: 'Enter procedure');
434: END IF; --(l_proc_level >= l_dbg_level)
435: EXCEPTION

Line 440: Fnd_Log.STRING(l_Proc_Level,

436: WHEN OTHERS THEN
437:
438: --log for debug
439: IF (l_Proc_Level >= l_Dbg_Level) THEN
440: Fnd_Log.STRING(l_Proc_Level,
441: l_Module_Prefix || '.' || l_Proc_Name ||
442: '. Other_Exception ',
443: SQLCODE || ':' || SQLERRM);
444: END IF; --(l_proc_level >= l_dbg_level)

Line 478: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

474: l_Company_Column_Name VARCHAR2(30);
475: l_Account_Column_Name VARCHAR2(30);
476: l_Cost_Column_Name VARCHAR2(30);
477: l_Project_Column_Name VARCHAR2(30);
478: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
479: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
480: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
481: l_Second_Track_Col_Name VARCHAR2(30);
482: l_Other_Cols_Name VARCHAR2(200);

Line 479: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

475: l_Account_Column_Name VARCHAR2(30);
476: l_Cost_Column_Name VARCHAR2(30);
477: l_Project_Column_Name VARCHAR2(30);
478: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
479: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
480: l_Proc_Name VARCHAR2(100) := 'generate_code_combination_view';
481: l_Second_Track_Col_Name VARCHAR2(30);
482: l_Other_Cols_Name VARCHAR2(200);
483: l_ledger_id number;

Line 557: Fnd_Log.STRING(l_Proc_Level,

553: BEGIN
554:
555: --log for debug
556: IF (l_Proc_Level >= l_Dbg_Level) THEN
557: Fnd_Log.STRING(l_Proc_Level,
558: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
559: 'Enter procedure');
560: END IF; --(l_proc_level >= l_dbg_level)
561: l_ledger_id := p_ledger_id;

Line 705: Fnd_Log.STRING(l_Proc_Level,

701:
702: --log for debug*/
703:
704: IF (l_Proc_Level >= l_Dbg_Level) THEN
705: Fnd_Log.STRING(l_Proc_Level,
706: l_Module_Prefix || '.' || l_Proc_Name,
707: 'l_create_view_sql:' || l_Create_View_Sql);
708: END IF; --(l_proc_level >= l_dbg_level)
709:

Line 714: Fnd_Log.STRING(l_Proc_Level,

710: --EXECUTE IMMEDIATE l_Create_View_Sql; --Chaoqun deleted for CNAOV2 on 01-19-2010
711:
712: --log for dubug
713: IF (l_Proc_Level >= l_Dbg_Level) THEN
714: Fnd_Log.STRING(l_Proc_Level,
715: l_Module_Prefix || '.' || l_Proc_Name || '.end',
716: 'Enter procedure');
717: END IF; --(l_proc_level >= l_dbg_level)
718:

Line 726: Fnd_Log.STRING(l_Proc_Level,

722: WHEN OTHERS THEN
723: FND_FILE.put_line(FND_FILE.OUTPUT,SQLCODE || ':' || SQLERRM);
724: --log for debug
725: IF (l_Proc_Level >= l_Dbg_Level) THEN
726: Fnd_Log.STRING(l_Proc_Level,
727: l_Module_Prefix || '.' || l_Proc_Name ||
728: '. Other_Exception ',
729: SQLCODE || ':' || SQLERRM);
730: END IF; --(l_proc_level >= l_dbg_level)

Line 757: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

753: p_Start_Period_Name OUT NOCOPY VARCHAR2,
754: p_End_Period_Name OUT NOCOPY VARCHAR2) IS
755:
756: l_Period_Name VARCHAR2(15);
757: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
758: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
759: l_Proc_Name VARCHAR2(100) := 'get_period_range';
760: l_ledger_id number;
761: BEGIN

Line 758: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

754: p_End_Period_Name OUT NOCOPY VARCHAR2) IS
755:
756: l_Period_Name VARCHAR2(15);
757: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
758: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
759: l_Proc_Name VARCHAR2(100) := 'get_period_range';
760: l_ledger_id number;
761: BEGIN
762:

Line 765: Fnd_Log.STRING(l_Proc_Level,

761: BEGIN
762:
763: --log for debug
764: IF (l_Proc_Level >= l_Dbg_Level) THEN
765: Fnd_Log.STRING(l_Proc_Level,
766: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
767: 'Enter procedure');
768: Fnd_Log.STRING(l_Proc_Level,
769: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 768: Fnd_Log.STRING(l_Proc_Level,

764: IF (l_Proc_Level >= l_Dbg_Level) THEN
765: Fnd_Log.STRING(l_Proc_Level,
766: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
767: 'Enter procedure');
768: Fnd_Log.STRING(l_Proc_Level,
769: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
770: 'P_period_name:' || p_Period_Name);
771: END IF; --(l_proc_level >= l_dbg_level)
772:

Line 807: Fnd_Log.STRING(l_Proc_Level,

803: END IF; --l_period_name IS NULL
804:
805: --log for debug
806: IF (l_Proc_Level >= l_Dbg_Level) THEN
807: Fnd_Log.STRING(l_Proc_Level,
808: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
809: 'p_start_period_name: ' || p_Start_Period_Name);
810: Fnd_Log.STRING(l_Proc_Level,
811: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 810: Fnd_Log.STRING(l_Proc_Level,

806: IF (l_Proc_Level >= l_Dbg_Level) THEN
807: Fnd_Log.STRING(l_Proc_Level,
808: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
809: 'p_start_period_name: ' || p_Start_Period_Name);
810: Fnd_Log.STRING(l_Proc_Level,
811: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
812: 'p_end_period_name: ' || p_End_Period_Name);
813: Fnd_Log.STRING(l_Proc_Level,
814: l_Module_Prefix || '.' || l_Proc_Name || '.end',

Line 813: Fnd_Log.STRING(l_Proc_Level,

809: 'p_start_period_name: ' || p_Start_Period_Name);
810: Fnd_Log.STRING(l_Proc_Level,
811: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
812: 'p_end_period_name: ' || p_End_Period_Name);
813: Fnd_Log.STRING(l_Proc_Level,
814: l_Module_Prefix || '.' || l_Proc_Name || '.end',
815: 'Exit procedure');
816: END IF; --( l_proc_level >= l_dbg_level )
817:

Line 823: Fnd_Log.STRING(l_Proc_Level,

819: WHEN OTHERS THEN
820:
821: --log for debug
822: IF (l_Proc_Level >= l_Dbg_Level) THEN
823: Fnd_Log.STRING(l_Proc_Level,
824: l_Module_Prefix || '.' || l_Proc_Name ||
825: '. Other_Exception ',
826: SQLCODE || ':' || SQLERRM);
827: END IF; --(l_proc_level >= l_dbg_level)

Line 853: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

849: l_Request_Id NUMBER;
850: l_Je_Line_Num NUMBER;
851: l_Je_Header_Id NUMBER;
852: l_Error_Msg VARCHAR2(2000);
853: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
854: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
855: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
856: CURSOR c_Unmatch_Lines IS
857: SELECT /*+ index(jel,gl_je_lines_u1)*/

Line 854: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

850: l_Je_Line_Num NUMBER;
851: l_Je_Header_Id NUMBER;
852: l_Error_Msg VARCHAR2(2000);
853: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
854: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
855: l_Proc_Name VARCHAR2(100) := 'purge_unmatch_lines';
856: CURSOR c_Unmatch_Lines IS
857: SELECT /*+ index(jel,gl_je_lines_u1)*/
858: Req.Je_Header_Id, Req.Je_Line_Num

Line 876: Fnd_Log.STRING(l_Proc_Level,

872: AND Jel.Je_Header_Id = Req.Je_Header_Id;
873: BEGIN
874: --log for debug
875: IF (l_Proc_Level >= l_Dbg_Level) THEN
876: Fnd_Log.STRING(l_Proc_Level,
877: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
878: 'Enter procedure');
879: Fnd_Log.STRING(l_Proc_Level,
880: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 879: Fnd_Log.STRING(l_Proc_Level,

875: IF (l_Proc_Level >= l_Dbg_Level) THEN
876: Fnd_Log.STRING(l_Proc_Level,
877: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
878: 'Enter procedure');
879: Fnd_Log.STRING(l_Proc_Level,
880: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
881: 'P_request_id:' || p_Request_Id);
882: END IF; --(l_proc_level >= l_dbg_level)
883:

Line 902: Fnd_Log.STRING(l_Proc_Level,

898: Fnd_File.Put_Line(Fnd_File.Log, l_Error_Msg);
899:
900: -- log for debug
901: IF (l_Proc_Level >= l_Dbg_Level) THEN
902: Fnd_Log.STRING(l_Proc_Level,
903: l_Module_Prefix || '.' || l_Proc_Name,
904: l_Error_Msg);
905: END IF; --(l_proc_level >= l_dbg_level)
906:

Line 917: Fnd_Log.STRING(l_Proc_Level,

913: CLOSE c_Unmatch_Lines;
914:
915: -- log for debug
916: IF (l_Proc_Level >= l_Dbg_Level) THEN
917: Fnd_Log.STRING(l_Proc_Level,
918: l_Module_Prefix || '.' || l_Proc_Name || '.end',
919: 'Enter procedure');
920: END IF; --(l_proc_level >= l_dbg_level)
921: EXCEPTION

Line 926: Fnd_Log.STRING(l_Proc_Level,

922: WHEN OTHERS THEN
923:
924: --log for debug
925: IF (l_Proc_Level >= l_Dbg_Level) THEN
926: Fnd_Log.STRING(l_Proc_Level,
927: l_Module_Prefix || '.' || l_Proc_Name ||
928: '. Other_Exception ',
929: SQLCODE || ':' || SQLERRM);
930: END IF; --(l_proc_level >= l_dbg_level)

Line 961: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

957: p_Request_Id IN NUMBER) IS
958:
959: l_Request_Id NUMBER;
960: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
961: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
962: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
963: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
964:
965: --Begin: Chaoqun updated for CNAOV2 on 01-20-2010

Line 962: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

958:
959: l_Request_Id NUMBER;
960: l_Project_Option Ja_Cn_Sub_Acc_Sources_All.Project_Source_Flag%TYPE;
961: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
962: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
963: l_Proc_Name VARCHAR2(100) := 'unitemize_journal_lines';
964:
965: --Begin: Chaoqun updated for CNAOV2 on 01-20-2010
966:

Line 986: Fnd_Log.STRING(l_Proc_Level,

982: BEGIN
983:
984: --log for debug
985: IF (l_Proc_Level >= l_Dbg_Level) THEN
986: Fnd_Log.STRING(l_Proc_Level,
987: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
988: 'Enter procedure');
989: Fnd_Log.STRING(l_Proc_Level,
990: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 989: Fnd_Log.STRING(l_Proc_Level,

985: IF (l_Proc_Level >= l_Dbg_Level) THEN
986: Fnd_Log.STRING(l_Proc_Level,
987: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
988: 'Enter procedure');
989: Fnd_Log.STRING(l_Proc_Level,
990: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
991: 'P_request_id:' || p_Request_Id);
992: Fnd_Log.STRING(l_Proc_Level, --Updated by Chaoqun for CNAOV2
993: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',

Line 992: Fnd_Log.STRING(l_Proc_Level, --Updated by Chaoqun for CNAOV2

988: 'Enter procedure');
989: Fnd_Log.STRING(l_Proc_Level,
990: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
991: 'P_request_id:' || p_Request_Id);
992: Fnd_Log.STRING(l_Proc_Level, --Updated by Chaoqun for CNAOV2
993: l_Module_Prefix || '.' || l_Proc_Name || '.prameter',
994: 'p_chart_of_accounts_id:' || p_chart_of_accounts_id);
995:
996: END IF; --(l_proc_level >= l_dbg_level)

Line 1260: Fnd_Log.STRING(l_Proc_Level,

1256: --End: Chaoqun updated for CNAOV2 on 01-20-2010
1257:
1258: -- log for debug
1259: IF (l_Proc_Level >= l_Dbg_Level) THEN
1260: Fnd_Log.STRING(l_Proc_Level,
1261: l_Module_Prefix || '.' || l_Proc_Name || '.end',
1262: 'Enter procedure');
1263: END IF; --(l_proc_level >= l_dbg_level)
1264: EXCEPTION

Line 1270: Fnd_Log.STRING(l_Proc_Level,

1266: ROLLBACK;
1267:
1268: --log for debug
1269: IF (l_Proc_Level >= l_Dbg_Level) THEN
1270: Fnd_Log.STRING(l_Proc_Level,
1271: l_Module_Prefix || '.' || l_Proc_Name ||
1272: '. Other_Exception ',
1273: SQLCODE || ':' || SQLERRM);
1274: END IF; --(l_proc_level >= l_dbg_level)

Line 1308: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1304: l_Je_Appending_Id NUMBER;
1305: l_Line_Num_m NUMBER;
1306: l_ledger_id number;
1307: l_legal_entity_id number;
1308: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1309: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1310: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1311:
1312: CURSOR c_Journal IS

Line 1309: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1305: l_Line_Num_m NUMBER;
1306: l_ledger_id number;
1307: l_legal_entity_id number;
1308: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1309: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1310: l_Proc_Name VARCHAR2(100) := 'generate_journal_num';
1311:
1312: CURSOR c_Journal IS
1313: SELECT Je_Header_Id

Line 1334: Fnd_Log.STRING(l_Proc_Level,

1330:
1331: BEGIN
1332: --log for debug
1333: IF (l_Proc_Level >= l_Dbg_Level) THEN
1334: Fnd_Log.STRING(l_Proc_Level,
1335: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1336: 'Enter procedure');
1337: END IF; --(l_proc_level >= l_dbg_level)
1338:

Line 1391: Fnd_Log.STRING(l_Proc_Level,

1387: CLOSE c_Journal;
1388: EXCEPTION
1389: WHEN OTHERS THEN
1390: IF (l_Proc_Level >= l_Dbg_Level) THEN
1391: Fnd_Log.STRING(l_Proc_Level,
1392: l_Module_Prefix || '.' || l_Proc_Name ||
1393: '. Other_Exception ',
1394: SQLCODE || ':' || SQLERRM);
1395: END IF; --(l_proc_level >= l_dbg_level)

Line 1425: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1421:
1422: PROCEDURE Itemize_Journals_Sla(p_chart_of_accounts_id in number,
1423: p_Request_Id IN NUMBER) IS
1424: l_Request_Id NUMBER;
1425: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1426: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1427: l_Proc_Name VARCHAR2(100) := 'ITEMIZE_JOURNALS_SLA';
1428: l_Project_Source_Flag VARCHAR2(15);
1429: l_Project_Ac_Code VARCHAR2(30);

Line 1426: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1422: PROCEDURE Itemize_Journals_Sla(p_chart_of_accounts_id in number,
1423: p_Request_Id IN NUMBER) IS
1424: l_Request_Id NUMBER;
1425: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1426: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1427: l_Proc_Name VARCHAR2(100) := 'ITEMIZE_JOURNALS_SLA';
1428: l_Project_Source_Flag VARCHAR2(15);
1429: l_Project_Ac_Code VARCHAR2(30);
1430: l_Project_Ac_Detail_Code VARCHAR2(30);

Line 1480: Fnd_Log.STRING(l_Proc_Level,

1476:
1477: BEGIN
1478: --log for debug
1479: IF (l_Proc_Level >= l_Dbg_Level) THEN
1480: Fnd_Log.STRING(l_Proc_Level,
1481: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1482: 'Enter procedure');
1483: END IF; --(l_proc_level >= l_dbg_level)
1484: l_Chart_Of_Accounts_Id := p_chart_of_accounts_id;

Line 1895: Fnd_Log.STRING(l_Proc_Level,

1891:
1892: EXCEPTION
1893: WHEN OTHERS THEN
1894: IF (l_Proc_Level >= l_Dbg_Level) THEN
1895: Fnd_Log.STRING(l_Proc_Level,
1896: l_Module_Prefix || '.' || l_Proc_Name ||
1897: '. Other_Exception ',
1898: SQLCODE || ':' || SQLERRM);
1899: END IF; --(l_proc_level >= l_dbg_level)

Line 1935: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1931: p_Legal_Entity_Id IN NUMBER,
1932: p_Period_Name IN VARCHAR2) IS
1933:
1934: l_Error_Msg VARCHAR2(2000);
1935: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1936: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1937: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
1938: l_Phase VARCHAR2(100);
1939: l_Status VARCHAR2(100);

Line 1936: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1932: p_Period_Name IN VARCHAR2) IS
1933:
1934: l_Error_Msg VARCHAR2(2000);
1935: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1936: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1937: l_Proc_Name VARCHAR2(100) := 'transfer_gl_sla_to_cnao';
1938: l_Phase VARCHAR2(100);
1939: l_Status VARCHAR2(100);
1940: l_Dev_Phase VARCHAR2(100);

Line 2004: Fnd_Log.STRING(l_Proc_Level,

2000: BEGIN
2001:
2002: --log for debug
2003: IF (l_Proc_Level >= l_Dbg_Level) THEN
2004: Fnd_Log.STRING(l_Proc_Level,
2005: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
2006: 'Enter procedure');
2007: Fnd_Log.STRING(l_Proc_Level,
2008: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 2007: Fnd_Log.STRING(l_Proc_Level,

2003: IF (l_Proc_Level >= l_Dbg_Level) THEN
2004: Fnd_Log.STRING(l_Proc_Level,
2005: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
2006: 'Enter procedure');
2007: Fnd_Log.STRING(l_Proc_Level,
2008: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
2009: 'p_period_name:' || p_Period_Name);
2010: Fnd_Log.STRING(l_Proc_Level,
2011: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',

Line 2010: Fnd_Log.STRING(l_Proc_Level,

2006: 'Enter procedure');
2007: Fnd_Log.STRING(l_Proc_Level,
2008: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
2009: 'p_period_name:' || p_Period_Name);
2010: Fnd_Log.STRING(l_Proc_Level,
2011: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
2012: 'p_legal_entity_id:' || p_Legal_Entity_Id);
2013: END IF; --(l_proc_level >= l_dbg_level)
2014:

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

2016: /* IF Ja_Cn_Utility.Check_Profile() <> TRUE THEN
2017:
2018: --log for debug
2019: IF (l_Proc_Level >= l_Dbg_Level) THEN
2020: Fnd_Log.STRING(l_Proc_Level, l_Dbg_Level, 'Check profile failed!');
2021: END IF; --(l_proc_level >= l_dbg_level)
2022: l_Conc_Succ := Fnd_Concurrent.Set_Completion_Status(Status => 'WARNING',
2023: Message => '');
2024: RETURN;

Line 2033: Fnd_Log.STRING(l_Proc_Level,

2029: l_ledger_id := p_Ledger_Id;
2030:
2031: --log for debug
2032: IF (l_Proc_Level >= l_Dbg_Level) THEN
2033: Fnd_Log.STRING(l_Proc_Level,
2034: l_Module_Prefix || '.' || l_Proc_Name ||
2035: '.current set of books id',
2036: 'set of book id is ' || l_Ledger_Id);
2037: END IF; --l_exception_level >= l_runtime_level

Line 2056: Fnd_Log.STRING(l_Proc_Level,

2052: END IF; --(c_project_option%NOTFOUND)
2053:
2054: --log for debug
2055: IF (l_Proc_Level >= l_Dbg_Level) THEN
2056: Fnd_Log.STRING(l_Proc_Level,
2057: l_Module_Prefix || '.' || l_Proc_Name ||
2058: '.setup information',
2059: 'project option is ' || l_Project_Option);
2060: END IF; --l_exception_level >= l_runtime_level

Line 2398: Fnd_Log.STRING(l_Proc_Level,

2394: l_Execution_Fail_Module := 'Post';
2395:
2396: --log for debug
2397: IF (l_Proc_Level >= l_Dbg_Level) THEN
2398: Fnd_Log.STRING(l_Proc_Level,
2399: l_Module_Prefix || '.' || l_Proc_Name ||
2400: '.JACNGLJT.EXECUTION',
2401: 'l_status.' || l_Status || '--' || 'l_phase.' ||
2402: l_Phase);

Line 2411: Fnd_Log.STRING(l_Proc_Level,

2407: END IF; --l_post_con_req_id <> 0
2408:
2409: --log for debug
2410: IF (l_Proc_Level >= l_Dbg_Level) THEN
2411: Fnd_Log.STRING(l_Proc_Level,
2412: l_Module_Prefix || '.' || l_Proc_Name || '.end',
2413: 'Exit procedure');
2414: END IF; --( l_proc_level >= l_dbg_level )
2415:

Line 2421: Fnd_Log.STRING(l_Proc_Level,

2417: WHEN l_Post_Fail THEN
2418: -- dbms_output.put_line('Post Program fails,please connect your system ');
2419: --log for debug
2420: IF (l_Proc_Level >= l_Dbg_Level) THEN
2421: Fnd_Log.STRING(l_Proc_Level,
2422: l_Module_Prefix || '.' || l_Proc_Name ||
2423: '. Other_Exception ',
2424: SQLCODE || ':' || SQLERRM);
2425: END IF; --(l_proc_level >= l_dbg_level)

Line 2445: Fnd_Log.STRING(l_Proc_Level,

2441: Message => SQLCODE || ':' ||
2442: SQLERRM);
2443: --log for debug
2444: IF (l_Proc_Level >= l_Dbg_Level) THEN
2445: Fnd_Log.STRING(l_Proc_Level,
2446: l_Module_Prefix || '.' || l_Proc_Name ||
2447: '. Other_Exception ',
2448: SQLCODE || ':' || SQLERRM);
2449: END IF; --(l_proc_level >= l_dbg_level)