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_UTILITY dependencies on FND_LOG

Line 79: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

75:
76: FUNCTION Check_Profile RETURN BOOLEAN IS
77: l_False_Flag VARCHAR2(1) := 'N';
78: l_Error_Msg VARCHAR2(2000);
79: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
80: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
81: l_Proc_Name VARCHAR2(100) := 'Check_Profile';
82: BEGIN
83:

Line 80: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

76: FUNCTION Check_Profile RETURN BOOLEAN IS
77: l_False_Flag VARCHAR2(1) := 'N';
78: l_Error_Msg VARCHAR2(2000);
79: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
80: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
81: l_Proc_Name VARCHAR2(100) := 'Check_Profile';
82: BEGIN
83:
84: --log for debug

Line 87: Fnd_Log.STRING(l_Proc_Level,

83:
84: --log for debug
85: IF (l_Proc_Level >= l_Dbg_Level)
86: THEN
87: Fnd_Log.STRING(l_Proc_Level,
88: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
89: 'Enter procedure');
90: END IF; --(l_proc_level >= l_dbg_level)
91:

Line 127: Fnd_Log.STRING(l_Proc_Level,

123: THEN
124: --log for debug
125: IF (l_Proc_Level >= l_Dbg_Level)
126: THEN
127: Fnd_Log.STRING(l_Proc_Level,
128: l_Module_Prefix || '.' || l_Proc_Name || '.end',
129: 'Exit procedure');
130: END IF; --( l_proc_level >= l_dbg_level )
131: RETURN TRUE;

Line 136: Fnd_Log.STRING(l_Proc_Level,

132: ELSE
133: --log for debug
134: IF (l_Proc_Level >= l_Dbg_Level)
135: THEN
136: Fnd_Log.STRING(l_Proc_Level,
137: l_Module_Prefix || '.' || l_Proc_Name || '.end',
138: 'Exit procedure');
139: END IF; --( l_proc_level >= l_dbg_level )
140: RETURN FALSE;

Line 147: Fnd_Log.STRING(l_Proc_Level,

143: EXCEPTION
144: WHEN OTHERS THEN
145: IF (l_Proc_Level >= l_Dbg_Level)
146: THEN
147: Fnd_Log.STRING(l_Proc_Level,
148: l_Module_Prefix || '.' || l_Proc_Name ||
149: '. Other_Exception ',
150: SQLCODE || ':' || SQLERRM);
151: END IF; --(l_proc_level >= l_dbg_level)

Line 191: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

187: x_Flag OUT NOCOPY NUMBER) IS
188:
189: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
190: '.Get_SOB_And_COA';
191: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
192: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);

Line 192: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

188:
189: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
190: '.Get_SOB_And_COA';
191: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
192: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);
196:

Line 193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

189: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
190: '.Get_SOB_And_COA';
191: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
192: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);
196:
197: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;

Line 194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

190: '.Get_SOB_And_COA';
191: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
192: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
193: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
194: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
195: l_Message VARCHAR2(300);
196:
197: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
198: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;

Line 205: Fnd_Log.STRING(l_Procedure_Level,

201: --log the parameters
202: IF (l_Procedure_Level >= l_Runtime_Level)
203: THEN
204:
205: Fnd_Log.STRING(l_Procedure_Level,
206: l_Module_Name,
207: 'Start to run ' || l_Module_Name ||
208: 'with parameter: p_legal_entity_id=' ||
209: Nvl(To_Char(p_Legal_Entity_Id), 'null'));

Line 221: Fnd_Log.STRING(l_Statement_Level,

217: WHERE legal_entity_id = p_legal_entity_id;
218: */ --log the SOB
219: IF (l_Statement_Level >= l_Runtime_Level)
220: THEN
221: Fnd_Log.STRING(l_Statement_Level,
222: l_Module_Name,
223: 'Fetched: l_set_of_books_id=' ||
224: Nvl(To_Char(l_Ledger_Id), 'null'));
225: END IF; --l_statement_level >= l_runtime_level

Line 234: Fnd_Log.STRING(l_Exception_Level, l_Module_Name, l_Message);

230: l_Message := Fnd_Message.Get();
231: Fnd_File.Put_Line(Fnd_File.Output, l_Message);
232: IF (l_Exception_Level >= l_Runtime_Level)
233: THEN
234: Fnd_Log.STRING(l_Exception_Level, l_Module_Name, l_Message);
235: END IF; --l_exception_level >= l_runtime_level
236: x_Flag := -1;
237: RETURN;
238: END;

Line 246: Fnd_Log.STRING(l_Statement_Level,

242: FROM Gl_Sets_Of_Books
243: WHERE Set_Of_Books_Id = l_Ledger_Id;
244: IF (l_Statement_Level >= l_Runtime_Level)
245: THEN
246: Fnd_Log.STRING(l_Statement_Level,
247: l_Module_Name,
248: 'Fetched: l_chart_of_accounts_id=' ||
249: Nvl(To_Char(l_Chart_Of_Accounts_Id), 'null'));
250: END IF; --l_statement_level >= l_runtime_level

Line 256: Fnd_Log.STRING(l_Procedure_Level,

252: x_Coa_Id := l_Chart_Of_Accounts_Id;
253: x_Flag := 0;
254: IF (l_Procedure_Level >= l_Runtime_Level)
255: THEN
256: Fnd_Log.STRING(l_Procedure_Level,
257: l_Module_Name,
258: 'Stop running ' || l_Module_Name);
259: END IF; --l_procedure_level >= l_runtime_level
260:

Line 402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

398: FUNCTION Get_Lookup_Meaning(p_Lookup_Code IN VARCHAR2) RETURN VARCHAR2 IS
399:
400: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
406:

Line 403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

399:
400: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
406:
407: -- this cursor is to get looup_meaning under some lookup_code

Line 404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

400: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
406:
407: -- this cursor is to get looup_meaning under some lookup_code
408: CURSOR c_Lookup IS

Line 405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

401: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
402: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
403: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
404: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
405: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
406:
407: -- this cursor is to get looup_meaning under some lookup_code
408: CURSOR c_Lookup IS
409: SELECT Flv.Meaning

Line 421: Fnd_Log.STRING(l_Procedure_Level,

417: BEGIN
418: --log
419: IF (l_Procedure_Level >= l_Runtime_Level)
420: THEN
421: Fnd_Log.STRING(l_Procedure_Level,
422: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
423: 'begin procedure');
424: END IF; --l_procedure_level >= l_runtime_level
425:

Line 443: Fnd_Log.STRING(l_Procedure_Level,

439:
440: --log
441: IF (l_Procedure_Level >= l_Runtime_Level)
442: THEN
443: Fnd_Log.STRING(l_Procedure_Level,
444: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
445: 'end procedure');
446: END IF; --l_procedure_level >= l_runtime_level
447:

Line 642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

638: RETURN VARCHAR2 IS
639:
640: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
644: --l_statement_level NUMBER := fnd_log.level_statement;
645: --l_exception_level NUMBER := fnd_log.level_exception;
646:

Line 643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

639:
640: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
644: --l_statement_level NUMBER := fnd_log.level_statement;
645: --l_exception_level NUMBER := fnd_log.level_exception;
646:
647: -- this cursor is to get looup_meaning under some lookup_code

Line 644: --l_statement_level NUMBER := fnd_log.level_statement;

640: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
644: --l_statement_level NUMBER := fnd_log.level_statement;
645: --l_exception_level NUMBER := fnd_log.level_exception;
646:
647: -- this cursor is to get looup_meaning under some lookup_code
648: CURSOR c_Lookup IS

Line 645: --l_exception_level NUMBER := fnd_log.level_exception;

641: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
642: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
643: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
644: --l_statement_level NUMBER := fnd_log.level_statement;
645: --l_exception_level NUMBER := fnd_log.level_exception;
646:
647: -- this cursor is to get looup_meaning under some lookup_code
648: CURSOR c_Lookup IS
649: SELECT Flv.Lookup_Code

Line 661: Fnd_Log.STRING(l_Procedure_Level,

657: BEGIN
658: --log for debug
659: IF (l_Procedure_Level >= l_Runtime_Level)
660: THEN
661: Fnd_Log.STRING(l_Procedure_Level,
662: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
663: 'begin procedure');
664: END IF; --l_procedure_level >= l_runtime_level
665:

Line 683: Fnd_Log.STRING(l_Procedure_Level,

679:
680: --log for debug
681: IF (l_Procedure_Level >= l_Runtime_Level)
682: THEN
683: Fnd_Log.STRING(l_Procedure_Level,
684: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
685: 'end procedure');
686: END IF; --l_procedure_level >= l_runtime_level
687:

Line 720: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

716: x_Charset_Request_Id OUT NOCOPY NUMBER,
717: x_Result_Flag OUT NOCOPY VARCHAR2) IS
718:
719: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
720: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
721: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
722: --l_statement_level NUMBER := fnd_log.level_statement;
723: --l_exception_level NUMBER := fnd_log.level_exception;
724: l_Complete_Flag BOOLEAN;

Line 721: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

717: x_Result_Flag OUT NOCOPY VARCHAR2) IS
718:
719: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
720: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
721: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
722: --l_statement_level NUMBER := fnd_log.level_statement;
723: --l_exception_level NUMBER := fnd_log.level_exception;
724: l_Complete_Flag BOOLEAN;
725: l_Phase VARCHAR2(100);

Line 722: --l_statement_level NUMBER := fnd_log.level_statement;

718:
719: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
720: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
721: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
722: --l_statement_level NUMBER := fnd_log.level_statement;
723: --l_exception_level NUMBER := fnd_log.level_exception;
724: l_Complete_Flag BOOLEAN;
725: l_Phase VARCHAR2(100);
726: l_Status VARCHAR2(100);

Line 723: --l_exception_level NUMBER := fnd_log.level_exception;

719: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
720: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
721: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
722: --l_statement_level NUMBER := fnd_log.level_statement;
723: --l_exception_level NUMBER := fnd_log.level_exception;
724: l_Complete_Flag BOOLEAN;
725: l_Phase VARCHAR2(100);
726: l_Status VARCHAR2(100);
727: l_Del_Phase VARCHAR2(100);

Line 735: Fnd_Log.STRING(l_Procedure_Level,

731: BEGIN
732: --log for debug
733: IF (l_Procedure_Level >= l_Runtime_Level)
734: THEN
735: Fnd_Log.STRING(l_Procedure_Level,
736: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
737: 'begin procedure');
738: END IF; --l_procedure_level >= l_runtime_level
739: -- submit charset conversion concurrent program

Line 777: Fnd_Log.STRING(l_Procedure_Level,

773:
774: --log for debug
775: IF (l_Procedure_Level >= l_Runtime_Level)
776: THEN
777: Fnd_Log.STRING(l_Procedure_Level,
778: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
779: 'end procedure');
780: END IF; --l_procedure_level >= l_runtime_level
781: EXCEPTION

Line 784: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)

780: END IF; --l_procedure_level >= l_runtime_level
781: EXCEPTION
782: WHEN OTHERS THEN
783: --log for debug
784: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
785: THEN
786: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
787: l_Module_Prefix || l_Procedure_Name ||
788: '. OTHER_EXCEPTION ',

Line 786: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,

782: WHEN OTHERS THEN
783: --log for debug
784: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
785: THEN
786: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
787: l_Module_Prefix || l_Procedure_Name ||
788: '. OTHER_EXCEPTION ',
789: SQLCODE || SQLERRM);
790: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 790: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

786: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
787: l_Module_Prefix || l_Procedure_Name ||
788: '. OTHER_EXCEPTION ',
789: SQLCODE || SQLERRM);
790: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
791: RAISE;
792: END Submit_Charset_Conversion;
793: --==========================================================================
794: -- PROCEDURE NAME:

Line 820: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

816: x_Filename_Request_Id OUT NOCOPY NUMBER,
817: x_Result_Flag OUT NOCOPY VARCHAR2) IS
818:
819: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
820: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
821: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
822: --l_statement_level NUMBER := fnd_log.level_statement;
823: --l_exception_level NUMBER := fnd_log.level_exception;
824: l_Complete_Flag BOOLEAN;

Line 821: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

817: x_Result_Flag OUT NOCOPY VARCHAR2) IS
818:
819: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
820: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
821: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
822: --l_statement_level NUMBER := fnd_log.level_statement;
823: --l_exception_level NUMBER := fnd_log.level_exception;
824: l_Complete_Flag BOOLEAN;
825: l_Phase VARCHAR2(100);

Line 822: --l_statement_level NUMBER := fnd_log.level_statement;

818:
819: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
820: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
821: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
822: --l_statement_level NUMBER := fnd_log.level_statement;
823: --l_exception_level NUMBER := fnd_log.level_exception;
824: l_Complete_Flag BOOLEAN;
825: l_Phase VARCHAR2(100);
826: l_Status VARCHAR2(100);

Line 823: --l_exception_level NUMBER := fnd_log.level_exception;

819: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
820: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
821: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
822: --l_statement_level NUMBER := fnd_log.level_statement;
823: --l_exception_level NUMBER := fnd_log.level_exception;
824: l_Complete_Flag BOOLEAN;
825: l_Phase VARCHAR2(100);
826: l_Status VARCHAR2(100);
827: l_Del_Phase VARCHAR2(100);

Line 835: Fnd_Log.STRING(l_Procedure_Level,

831: BEGIN
832: --log for debug
833: IF (l_Procedure_Level >= l_Runtime_Level)
834: THEN
835: Fnd_Log.STRING(l_Procedure_Level,
836: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
837: 'begin procedure');
838: END IF; --l_procedure_level >= l_runtime_level
839: -- submit change file name concurrent program

Line 876: Fnd_Log.STRING(l_Procedure_Level,

872:
873: --log for debug
874: IF (l_Procedure_Level >= l_Runtime_Level)
875: THEN
876: Fnd_Log.STRING(l_Procedure_Level,
877: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
878: 'end procedure');
879: END IF; --l_procedure_level >= l_runtime_level
880: EXCEPTION

Line 883: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)

879: END IF; --l_procedure_level >= l_runtime_level
880: EXCEPTION
881: WHEN OTHERS THEN
882: --log for debug
883: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
884: THEN
885: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
886: l_Module_Prefix || l_Procedure_Name ||
887: '. OTHER_EXCEPTION ',

Line 885: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,

881: WHEN OTHERS THEN
882: --log for debug
883: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
884: THEN
885: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
886: l_Module_Prefix || l_Procedure_Name ||
887: '. OTHER_EXCEPTION ',
888: SQLCODE || SQLERRM);
889: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

Line 889: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

885: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
886: l_Module_Prefix || l_Procedure_Name ||
887: '. OTHER_EXCEPTION ',
888: SQLCODE || SQLERRM);
889: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
890: RAISE;
891: END Change_Output_Filename;
892:
893: --==========================================================================

Line 948: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

944: AND Enabled_Flag = 'Y'
945: AND Display_Flag = 'Y'
946: ORDER BY Segment_Num;
947:
948: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
949: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
950: l_Proc_Name VARCHAR2(100) := 'Check_Cash_Related_Account';
951:
952: BEGIN

Line 949: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

945: AND Display_Flag = 'Y'
946: ORDER BY Segment_Num;
947:
948: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
949: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
950: l_Proc_Name VARCHAR2(100) := 'Check_Cash_Related_Account';
951:
952: BEGIN
953: --log for debug

Line 956: Fnd_Log.STRING(l_Proc_Level,

952: BEGIN
953: --log for debug
954: IF (l_Proc_Level >= l_Dbg_Level)
955: THEN
956: Fnd_Log.STRING(l_Proc_Level,
957: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
958: 'Enter procedure');
959: Fnd_Log.STRING(l_Proc_Level,
960: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 959: Fnd_Log.STRING(l_Proc_Level,

955: THEN
956: Fnd_Log.STRING(l_Proc_Level,
957: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
958: 'Enter procedure');
959: Fnd_Log.STRING(l_Proc_Level,
960: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
961: 'p_set_of_bks_id ' || p_Set_Of_Bks_Id);
962: Fnd_Log.STRING(l_Proc_Level,
963: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 962: Fnd_Log.STRING(l_Proc_Level,

958: 'Enter procedure');
959: Fnd_Log.STRING(l_Proc_Level,
960: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
961: 'p_set_of_bks_id ' || p_Set_Of_Bks_Id);
962: Fnd_Log.STRING(l_Proc_Level,
963: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
964: 'p_acc_flex ' || p_Acc_Flex);
965:
966: END IF; --(l_proc_level >= l_dbg_level)

Line 1017: Fnd_Log.STRING(l_Proc_Level,

1013: END IF; --l_cash_acct_count>0
1014:
1015: IF (l_Proc_Level >= l_Dbg_Level)
1016: THEN
1017: Fnd_Log.STRING(l_Proc_Level,
1018: l_Module_Prefix || '.' || l_Proc_Name || '.end',
1019: 'Exit procedure');
1020: END IF; --( l_proc_level >= l_dbg_level )
1021:

Line 1028: Fnd_Log.STRING(l_Proc_Level,

1024: EXCEPTION
1025: WHEN OTHERS THEN
1026: IF (l_Proc_Level >= l_Dbg_Level)
1027: THEN
1028: Fnd_Log.STRING(l_Proc_Level,
1029: l_Module_Prefix || '.' || l_Proc_Name ||
1030: '. Other_Exception ',
1031: SQLCODE || ':' || SQLERRM);
1032: END IF; --(l_proc_level >= l_dbg_level)

Line 1077: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1073: l_All_Period_Number INTEGER;
1074: l_Closed_Period_Number INTEGER;
1075:
1076: l_Sob_Id NUMBER;
1077: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1078: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1079: l_Proc_Name VARCHAR2(100) := 'Check_Accounting_Period_Range';
1080: BEGIN
1081:

Line 1078: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1074: l_Closed_Period_Number INTEGER;
1075:
1076: l_Sob_Id NUMBER;
1077: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1078: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1079: l_Proc_Name VARCHAR2(100) := 'Check_Accounting_Period_Range';
1080: BEGIN
1081:
1082: -- l_Sob_Id := Ja_Cn_Utility.Get_Sob(p_Legal_Entity_Id);--updated by lyb

Line 1125: Fnd_Log.STRING(l_Proc_Level,

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

Line 1187: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1183: l_Insertsql Dbms_Sql.Varchar2s;
1184: l_Line_No NUMBER := 0;
1185: l_Cursorid INTEGER;
1186: l_Return_No NUMBER;
1187: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1188: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1189: l_Proc_Name VARCHAR2(100) := 'Populate_Ledger_Le_Bsv_Gt';
1190:
1191: BEGIN

Line 1188: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1184: l_Line_No NUMBER := 0;
1185: l_Cursorid INTEGER;
1186: l_Return_No NUMBER;
1187: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1188: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1189: l_Proc_Name VARCHAR2(100) := 'Populate_Ledger_Le_Bsv_Gt';
1190:
1191: BEGIN
1192: --log for debug

Line 1195: Fnd_Log.STRING(l_Proc_Level,

1191: BEGIN
1192: --log for debug
1193: IF (l_Proc_Level >= l_Dbg_Level)
1194: THEN
1195: Fnd_Log.STRING(l_Proc_Level,
1196: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1197: 'Enter procedure');
1198:
1199: Fnd_Log.STRING(l_Proc_Level,

Line 1199: Fnd_Log.STRING(l_Proc_Level,

1195: Fnd_Log.STRING(l_Proc_Level,
1196: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1197: 'Enter procedure');
1198:
1199: Fnd_Log.STRING(l_Proc_Level,
1200: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1201: 'p_ledger_id ' || p_ledger_Id);
1202:
1203: Fnd_Log.STRING(l_Proc_Level,

Line 1203: Fnd_Log.STRING(l_Proc_Level,

1199: Fnd_Log.STRING(l_Proc_Level,
1200: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1201: 'p_ledger_id ' || p_ledger_Id);
1202:
1203: Fnd_Log.STRING(l_Proc_Level,
1204: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1205: 'p_legal_entity_id ' || p_legal_entity_id);
1206:
1207: END IF; --(l_proc_level >= l_dbg_level)

Line 1400: Fnd_Log.STRING(l_Proc_Level,

1396: EXCEPTION
1397: WHEN OTHERS THEN
1398: IF (l_Proc_Level >= l_Dbg_Level)
1399: THEN
1400: Fnd_Log.STRING(l_Proc_Level,
1401: l_Module_Prefix || '.' || l_Proc_Name ||
1402: '. Other_Exception ',
1403: SQLCODE || ':' || SQLERRM);
1404: END IF; --(l_proc_level >= l_dbg_level)