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

85:
86: FUNCTION Check_Profile RETURN BOOLEAN IS
87: l_False_Flag VARCHAR2(1) := 'N';
88: l_Error_Msg VARCHAR2(2000);
89: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
90: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
91: l_Proc_Name VARCHAR2(100) := 'Check_Profile';
92: BEGIN
93:

Line 90: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

86: FUNCTION Check_Profile RETURN BOOLEAN IS
87: l_False_Flag VARCHAR2(1) := 'N';
88: l_Error_Msg VARCHAR2(2000);
89: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
90: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
91: l_Proc_Name VARCHAR2(100) := 'Check_Profile';
92: BEGIN
93:
94: --log for debug

Line 97: Fnd_Log.STRING(l_Proc_Level,

93:
94: --log for debug
95: IF (l_Proc_Level >= l_Dbg_Level)
96: THEN
97: Fnd_Log.STRING(l_Proc_Level,
98: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
99: 'Enter procedure');
100: END IF; --(l_proc_level >= l_dbg_level)
101:

Line 137: Fnd_Log.STRING(l_Proc_Level,

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

Line 146: Fnd_Log.STRING(l_Proc_Level,

142: ELSE
143: --log for debug
144: IF (l_Proc_Level >= l_Dbg_Level)
145: THEN
146: Fnd_Log.STRING(l_Proc_Level,
147: l_Module_Prefix || '.' || l_Proc_Name || '.end',
148: 'Exit procedure');
149: END IF; --( l_proc_level >= l_dbg_level )
150: RETURN FALSE;

Line 157: Fnd_Log.STRING(l_Proc_Level,

153: EXCEPTION
154: WHEN OTHERS THEN
155: IF (l_Proc_Level >= l_Dbg_Level)
156: THEN
157: Fnd_Log.STRING(l_Proc_Level,
158: l_Module_Prefix || '.' || l_Proc_Name ||
159: '. Other_Exception ',
160: SQLCODE || ':' || SQLERRM);
161: END IF; --(l_proc_level >= l_dbg_level)

Line 201: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

197: x_Flag OUT NOCOPY NUMBER) IS
198:
199: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
200: '.Get_SOB_And_COA';
201: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
202: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);

Line 202: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

198:
199: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
200: '.Get_SOB_And_COA';
201: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
202: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);
206:

Line 203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

199: l_Module_Name CONSTANT VARCHAR2(100) := l_Module_Prefix ||
200: '.Get_SOB_And_COA';
201: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
202: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);
206:
207: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;

Line 204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

200: '.Get_SOB_And_COA';
201: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
202: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
203: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
204: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
205: l_Message VARCHAR2(300);
206:
207: l_Chart_Of_Accounts_Id Gl_Sets_Of_Books.Chart_Of_Accounts_Id%TYPE;
208: l_Ledger_Id Gl_Ledgers.Ledger_Id%TYPE;

Line 215: Fnd_Log.STRING(l_Procedure_Level,

211: --log the parameters
212: IF (l_Procedure_Level >= l_Runtime_Level)
213: THEN
214:
215: Fnd_Log.STRING(l_Procedure_Level,
216: l_Module_Name,
217: 'Start to run ' || l_Module_Name ||
218: 'with parameter: p_legal_entity_id=' ||
219: Nvl(To_Char(p_Legal_Entity_Id), 'null'));

Line 231: Fnd_Log.STRING(l_Statement_Level,

227: WHERE legal_entity_id = p_legal_entity_id;
228: */ --log the SOB
229: IF (l_Statement_Level >= l_Runtime_Level)
230: THEN
231: Fnd_Log.STRING(l_Statement_Level,
232: l_Module_Name,
233: 'Fetched: l_set_of_books_id=' ||
234: Nvl(To_Char(l_Ledger_Id), 'null'));
235: END IF; --l_statement_level >= l_runtime_level

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

240: l_Message := Fnd_Message.Get();
241: Fnd_File.Put_Line(Fnd_File.Output, l_Message);
242: IF (l_Exception_Level >= l_Runtime_Level)
243: THEN
244: Fnd_Log.STRING(l_Exception_Level, l_Module_Name, l_Message);
245: END IF; --l_exception_level >= l_runtime_level
246: x_Flag := -1;
247: RETURN;
248: END;

Line 256: Fnd_Log.STRING(l_Statement_Level,

252: FROM Gl_Sets_Of_Books
253: WHERE Set_Of_Books_Id = l_Ledger_Id;
254: IF (l_Statement_Level >= l_Runtime_Level)
255: THEN
256: Fnd_Log.STRING(l_Statement_Level,
257: l_Module_Name,
258: 'Fetched: l_chart_of_accounts_id=' ||
259: Nvl(To_Char(l_Chart_Of_Accounts_Id), 'null'));
260: END IF; --l_statement_level >= l_runtime_level

Line 266: Fnd_Log.STRING(l_Procedure_Level,

262: x_Coa_Id := l_Chart_Of_Accounts_Id;
263: x_Flag := 0;
264: IF (l_Procedure_Level >= l_Runtime_Level)
265: THEN
266: Fnd_Log.STRING(l_Procedure_Level,
267: l_Module_Name,
268: 'Stop running ' || l_Module_Name);
269: END IF; --l_procedure_level >= l_runtime_level
270:

Line 412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

408: FUNCTION Get_Lookup_Meaning(p_Lookup_Code IN VARCHAR2) RETURN VARCHAR2 IS
409:
410: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
411: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
416:

Line 413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

409:
410: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
411: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
416:
417: -- this cursor is to get looup_meaning under some lookup_code

Line 414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;

410: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Meaning';
411: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
416:
417: -- this cursor is to get looup_meaning under some lookup_code
418: CURSOR c_Lookup IS

Line 415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;

411: l_Lookup_Meaning Fnd_Lookup_Values.Meaning%TYPE := NULL;
412: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
413: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
414: l_Statement_Level NUMBER := Fnd_Log.Level_Statement;
415: l_Exception_Level NUMBER := Fnd_Log.Level_Exception;
416:
417: -- this cursor is to get looup_meaning under some lookup_code
418: CURSOR c_Lookup IS
419: SELECT Flv.Meaning

Line 431: Fnd_Log.STRING(l_Procedure_Level,

427: BEGIN
428: --log
429: IF (l_Procedure_Level >= l_Runtime_Level)
430: THEN
431: Fnd_Log.STRING(l_Procedure_Level,
432: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
433: 'begin procedure');
434: END IF; --l_procedure_level >= l_runtime_level
435:

Line 453: Fnd_Log.STRING(l_Procedure_Level,

449:
450: --log
451: IF (l_Procedure_Level >= l_Runtime_Level)
452: THEN
453: Fnd_Log.STRING(l_Procedure_Level,
454: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
455: 'end procedure');
456: END IF; --l_procedure_level >= l_runtime_level
457:

Line 658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

654: RETURN VARCHAR2 IS
655:
656: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
657: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
660: --l_statement_level NUMBER := fnd_log.level_statement;
661: --l_exception_level NUMBER := fnd_log.level_exception;
662:

Line 659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

655:
656: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
657: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
660: --l_statement_level NUMBER := fnd_log.level_statement;
661: --l_exception_level NUMBER := fnd_log.level_exception;
662:
663: -- this cursor is to get looup_meaning under some lookup_code

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

656: l_Procedure_Name VARCHAR2(30) := 'Get_Lookup_Code';
657: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
660: --l_statement_level NUMBER := fnd_log.level_statement;
661: --l_exception_level NUMBER := fnd_log.level_exception;
662:
663: -- this cursor is to get looup_meaning under some lookup_code
664: CURSOR c_Lookup IS

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

657: l_Lookup_Code Fnd_Lookup_Values.Lookup_Code%TYPE := NULL;
658: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
659: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
660: --l_statement_level NUMBER := fnd_log.level_statement;
661: --l_exception_level NUMBER := fnd_log.level_exception;
662:
663: -- this cursor is to get looup_meaning under some lookup_code
664: CURSOR c_Lookup IS
665: SELECT Flv.Lookup_Code

Line 677: Fnd_Log.STRING(l_Procedure_Level,

673: BEGIN
674: --log for debug
675: IF (l_Procedure_Level >= l_Runtime_Level)
676: THEN
677: Fnd_Log.STRING(l_Procedure_Level,
678: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
679: 'begin procedure');
680: END IF; --l_procedure_level >= l_runtime_level
681:

Line 699: Fnd_Log.STRING(l_Procedure_Level,

695:
696: --log for debug
697: IF (l_Procedure_Level >= l_Runtime_Level)
698: THEN
699: Fnd_Log.STRING(l_Procedure_Level,
700: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
701: 'end procedure');
702: END IF; --l_procedure_level >= l_runtime_level
703:

Line 736: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

732: x_Charset_Request_Id OUT NOCOPY NUMBER,
733: x_Result_Flag OUT NOCOPY VARCHAR2) IS
734:
735: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
736: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
737: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
738: --l_statement_level NUMBER := fnd_log.level_statement;
739: --l_exception_level NUMBER := fnd_log.level_exception;
740: l_Complete_Flag BOOLEAN;

Line 737: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

733: x_Result_Flag OUT NOCOPY VARCHAR2) IS
734:
735: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
736: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
737: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
738: --l_statement_level NUMBER := fnd_log.level_statement;
739: --l_exception_level NUMBER := fnd_log.level_exception;
740: l_Complete_Flag BOOLEAN;
741: l_Phase VARCHAR2(100);

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

734:
735: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
736: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
737: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
738: --l_statement_level NUMBER := fnd_log.level_statement;
739: --l_exception_level NUMBER := fnd_log.level_exception;
740: l_Complete_Flag BOOLEAN;
741: l_Phase VARCHAR2(100);
742: l_Status VARCHAR2(100);

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

735: l_Procedure_Name VARCHAR2(30) := 'Submit_Charset_Conversion ';
736: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
737: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
738: --l_statement_level NUMBER := fnd_log.level_statement;
739: --l_exception_level NUMBER := fnd_log.level_exception;
740: l_Complete_Flag BOOLEAN;
741: l_Phase VARCHAR2(100);
742: l_Status VARCHAR2(100);
743: l_Del_Phase VARCHAR2(100);

Line 751: Fnd_Log.STRING(l_Procedure_Level,

747: BEGIN
748: --log for debug
749: IF (l_Procedure_Level >= l_Runtime_Level)
750: THEN
751: Fnd_Log.STRING(l_Procedure_Level,
752: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
753: 'begin procedure');
754: END IF; --l_procedure_level >= l_runtime_level
755: -- submit charset conversion concurrent program

Line 793: Fnd_Log.STRING(l_Procedure_Level,

789:
790: --log for debug
791: IF (l_Procedure_Level >= l_Runtime_Level)
792: THEN
793: Fnd_Log.STRING(l_Procedure_Level,
794: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
795: 'end procedure');
796: END IF; --l_procedure_level >= l_runtime_level
797: EXCEPTION

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

796: END IF; --l_procedure_level >= l_runtime_level
797: EXCEPTION
798: WHEN OTHERS THEN
799: --log for debug
800: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
801: THEN
802: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
803: l_Module_Prefix || l_Procedure_Name ||
804: '. OTHER_EXCEPTION ',

Line 802: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,

798: WHEN OTHERS THEN
799: --log for debug
800: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
801: THEN
802: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
803: l_Module_Prefix || l_Procedure_Name ||
804: '. OTHER_EXCEPTION ',
805: SQLCODE || SQLERRM);
806: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

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

802: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
803: l_Module_Prefix || l_Procedure_Name ||
804: '. OTHER_EXCEPTION ',
805: SQLCODE || SQLERRM);
806: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
807: RAISE;
808: END Submit_Charset_Conversion;
809:
810: --==========================================================================

Line 840: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

836: x_Charset_Request_Id OUT NOCOPY NUMBER,
837: x_Result_Flag OUT NOCOPY VARCHAR2) IS
838:
839: l_Procedure_Name VARCHAR2(30) := 'Submit_XML_Charset_Conversion ';
840: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
841: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
842: --l_statement_level NUMBER := fnd_log.level_statement;
843: --l_exception_level NUMBER := fnd_log.level_exception;
844: l_Complete_Flag BOOLEAN;

Line 841: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

837: x_Result_Flag OUT NOCOPY VARCHAR2) IS
838:
839: l_Procedure_Name VARCHAR2(30) := 'Submit_XML_Charset_Conversion ';
840: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
841: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
842: --l_statement_level NUMBER := fnd_log.level_statement;
843: --l_exception_level NUMBER := fnd_log.level_exception;
844: l_Complete_Flag BOOLEAN;
845: l_Phase VARCHAR2(100);

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

838:
839: l_Procedure_Name VARCHAR2(30) := 'Submit_XML_Charset_Conversion ';
840: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
841: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
842: --l_statement_level NUMBER := fnd_log.level_statement;
843: --l_exception_level NUMBER := fnd_log.level_exception;
844: l_Complete_Flag BOOLEAN;
845: l_Phase VARCHAR2(100);
846: l_Status VARCHAR2(100);

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

839: l_Procedure_Name VARCHAR2(30) := 'Submit_XML_Charset_Conversion ';
840: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
841: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
842: --l_statement_level NUMBER := fnd_log.level_statement;
843: --l_exception_level NUMBER := fnd_log.level_exception;
844: l_Complete_Flag BOOLEAN;
845: l_Phase VARCHAR2(100);
846: l_Status VARCHAR2(100);
847: l_Del_Phase VARCHAR2(100);

Line 855: Fnd_Log.STRING(l_Procedure_Level,

851: BEGIN
852: --log for debug
853: IF (l_Procedure_Level >= l_Runtime_Level)
854: THEN
855: Fnd_Log.STRING(l_Procedure_Level,
856: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
857: 'begin procedure');
858: END IF; --l_procedure_level >= l_runtime_level
859: -- submit charset conversion concurrent program

Line 897: Fnd_Log.STRING(l_Procedure_Level,

893:
894: --log for debug
895: IF (l_Procedure_Level >= l_Runtime_Level)
896: THEN
897: Fnd_Log.STRING(l_Procedure_Level,
898: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
899: 'end procedure');
900: END IF; --l_procedure_level >= l_runtime_level
901: EXCEPTION

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

900: END IF; --l_procedure_level >= l_runtime_level
901: EXCEPTION
902: WHEN OTHERS THEN
903: --log for debug
904: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
905: THEN
906: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
907: l_Module_Prefix || l_Procedure_Name ||
908: '. OTHER_EXCEPTION ',

Line 906: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,

902: WHEN OTHERS THEN
903: --log for debug
904: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
905: THEN
906: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
907: l_Module_Prefix || l_Procedure_Name ||
908: '. OTHER_EXCEPTION ',
909: SQLCODE || SQLERRM);
910: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

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

906: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
907: l_Module_Prefix || l_Procedure_Name ||
908: '. OTHER_EXCEPTION ',
909: SQLCODE || SQLERRM);
910: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
911: RAISE;
912: END Submit_XML_Charset_Conversion;
913:
914:

Line 942: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

938: x_Filename_Request_Id OUT NOCOPY NUMBER,
939: x_Result_Flag OUT NOCOPY VARCHAR2) IS
940:
941: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
942: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
943: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
944: --l_statement_level NUMBER := fnd_log.level_statement;
945: --l_exception_level NUMBER := fnd_log.level_exception;
946: l_Complete_Flag BOOLEAN;

Line 943: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;

939: x_Result_Flag OUT NOCOPY VARCHAR2) IS
940:
941: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
942: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
943: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
944: --l_statement_level NUMBER := fnd_log.level_statement;
945: --l_exception_level NUMBER := fnd_log.level_exception;
946: l_Complete_Flag BOOLEAN;
947: l_Phase VARCHAR2(100);

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

940:
941: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
942: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
943: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
944: --l_statement_level NUMBER := fnd_log.level_statement;
945: --l_exception_level NUMBER := fnd_log.level_exception;
946: l_Complete_Flag BOOLEAN;
947: l_Phase VARCHAR2(100);
948: l_Status VARCHAR2(100);

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

941: l_Procedure_Name VARCHAR2(30) := 'Change_Output_Filename';
942: l_Runtime_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
943: l_Procedure_Level NUMBER := Fnd_Log.Level_Procedure;
944: --l_statement_level NUMBER := fnd_log.level_statement;
945: --l_exception_level NUMBER := fnd_log.level_exception;
946: l_Complete_Flag BOOLEAN;
947: l_Phase VARCHAR2(100);
948: l_Status VARCHAR2(100);
949: l_Del_Phase VARCHAR2(100);

Line 957: Fnd_Log.STRING(l_Procedure_Level,

953: BEGIN
954: --log for debug
955: IF (l_Procedure_Level >= l_Runtime_Level)
956: THEN
957: Fnd_Log.STRING(l_Procedure_Level,
958: l_Module_Prefix || '.' || l_Procedure_Name || '.begin',
959: 'begin procedure');
960: END IF; --l_procedure_level >= l_runtime_level
961: -- submit change file name concurrent program

Line 998: Fnd_Log.STRING(l_Procedure_Level,

994:
995: --log for debug
996: IF (l_Procedure_Level >= l_Runtime_Level)
997: THEN
998: Fnd_Log.STRING(l_Procedure_Level,
999: l_Module_Prefix || '.' || l_Procedure_Name || '.end',
1000: 'end procedure');
1001: END IF; --l_procedure_level >= l_runtime_level
1002: EXCEPTION

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

1001: END IF; --l_procedure_level >= l_runtime_level
1002: EXCEPTION
1003: WHEN OTHERS THEN
1004: --log for debug
1005: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
1006: THEN
1007: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
1008: l_Module_Prefix || l_Procedure_Name ||
1009: '. OTHER_EXCEPTION ',

Line 1007: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,

1003: WHEN OTHERS THEN
1004: --log for debug
1005: IF (Fnd_Log.Level_Unexpected >= Fnd_Log.g_Current_Runtime_Level)
1006: THEN
1007: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
1008: l_Module_Prefix || l_Procedure_Name ||
1009: '. OTHER_EXCEPTION ',
1010: SQLCODE || SQLERRM);
1011: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)

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

1007: Fnd_Log.STRING(Fnd_Log.Level_Unexpected,
1008: l_Module_Prefix || l_Procedure_Name ||
1009: '. OTHER_EXCEPTION ',
1010: SQLCODE || SQLERRM);
1011: END IF; -- fnd_log.level_unexpected >= fnd_log.g_current_runtime_level)
1012: RAISE;
1013: END Change_Output_Filename;
1014:
1015: --==========================================================================

Line 1070: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1066: AND Enabled_Flag = 'Y'
1067: AND Display_Flag = 'Y'
1068: ORDER BY Segment_Num;
1069:
1070: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1071: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1072: l_Proc_Name VARCHAR2(100) := 'Check_Cash_Related_Account';
1073:
1074: BEGIN

Line 1071: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1067: AND Display_Flag = 'Y'
1068: ORDER BY Segment_Num;
1069:
1070: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1071: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1072: l_Proc_Name VARCHAR2(100) := 'Check_Cash_Related_Account';
1073:
1074: BEGIN
1075: --log for debug

Line 1078: Fnd_Log.STRING(l_Proc_Level,

1074: BEGIN
1075: --log for debug
1076: IF (l_Proc_Level >= l_Dbg_Level)
1077: THEN
1078: Fnd_Log.STRING(l_Proc_Level,
1079: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1080: 'Enter procedure');
1081: Fnd_Log.STRING(l_Proc_Level,
1082: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 1081: Fnd_Log.STRING(l_Proc_Level,

1077: THEN
1078: Fnd_Log.STRING(l_Proc_Level,
1079: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1080: 'Enter procedure');
1081: Fnd_Log.STRING(l_Proc_Level,
1082: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
1083: 'p_set_of_bks_id ' || p_Set_Of_Bks_Id);
1084: Fnd_Log.STRING(l_Proc_Level,
1085: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',

Line 1084: Fnd_Log.STRING(l_Proc_Level,

1080: 'Enter procedure');
1081: Fnd_Log.STRING(l_Proc_Level,
1082: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
1083: 'p_set_of_bks_id ' || p_Set_Of_Bks_Id);
1084: Fnd_Log.STRING(l_Proc_Level,
1085: l_Module_Prefix || '.' || l_Proc_Name || '.parameter',
1086: 'p_acc_flex ' || p_Acc_Flex);
1087:
1088: END IF; --(l_proc_level >= l_dbg_level)

Line 1139: Fnd_Log.STRING(l_Proc_Level,

1135: END IF; --l_cash_acct_count>0
1136:
1137: IF (l_Proc_Level >= l_Dbg_Level)
1138: THEN
1139: Fnd_Log.STRING(l_Proc_Level,
1140: l_Module_Prefix || '.' || l_Proc_Name || '.end',
1141: 'Exit procedure');
1142: END IF; --( l_proc_level >= l_dbg_level )
1143:

Line 1150: Fnd_Log.STRING(l_Proc_Level,

1146: EXCEPTION
1147: WHEN OTHERS THEN
1148: IF (l_Proc_Level >= l_Dbg_Level)
1149: THEN
1150: Fnd_Log.STRING(l_Proc_Level,
1151: l_Module_Prefix || '.' || l_Proc_Name ||
1152: '. Other_Exception ',
1153: SQLCODE || ':' || SQLERRM);
1154: END IF; --(l_proc_level >= l_dbg_level)

Line 1199: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1195: l_All_Period_Number INTEGER;
1196: l_Closed_Period_Number INTEGER;
1197:
1198: l_Sob_Id NUMBER;
1199: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1200: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1201: l_Proc_Name VARCHAR2(100) := 'Check_Accounting_Period_Range';
1202: BEGIN
1203:

Line 1200: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1196: l_Closed_Period_Number INTEGER;
1197:
1198: l_Sob_Id NUMBER;
1199: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1200: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1201: l_Proc_Name VARCHAR2(100) := 'Check_Accounting_Period_Range';
1202: BEGIN
1203:
1204: -- l_Sob_Id := Ja_Cn_Utility.Get_Sob(p_Legal_Entity_Id);--updated by lyb

Line 1247: Fnd_Log.STRING(l_Proc_Level,

1243: EXCEPTION
1244: WHEN OTHERS THEN
1245: IF (l_Proc_Level >= l_Dbg_Level)
1246: THEN
1247: Fnd_Log.STRING(l_Proc_Level,
1248: l_Module_Prefix || '.' || l_Proc_Name ||
1249: '. Other_Exception ',
1250: SQLCODE || ':' || SQLERRM);
1251: END IF; --(l_proc_level >= l_dbg_level)

Line 1309: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

1305: l_Insertsql Dbms_Sql.Varchar2s;
1306: l_Line_No NUMBER := 0;
1307: l_Cursorid INTEGER;
1308: l_Return_No NUMBER;
1309: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1310: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1311: l_Proc_Name VARCHAR2(100) := 'Populate_Ledger_Le_Bsv_Gt';
1312:
1313: BEGIN

Line 1310: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

1306: l_Line_No NUMBER := 0;
1307: l_Cursorid INTEGER;
1308: l_Return_No NUMBER;
1309: l_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
1310: l_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
1311: l_Proc_Name VARCHAR2(100) := 'Populate_Ledger_Le_Bsv_Gt';
1312:
1313: BEGIN
1314: --log for debug

Line 1317: Fnd_Log.STRING(l_Proc_Level,

1313: BEGIN
1314: --log for debug
1315: IF (l_Proc_Level >= l_Dbg_Level)
1316: THEN
1317: Fnd_Log.STRING(l_Proc_Level,
1318: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1319: 'Enter procedure');
1320:
1321: Fnd_Log.STRING(l_Proc_Level,

Line 1321: Fnd_Log.STRING(l_Proc_Level,

1317: Fnd_Log.STRING(l_Proc_Level,
1318: l_Module_Prefix || '.' || l_Proc_Name || '.begin',
1319: 'Enter procedure');
1320:
1321: Fnd_Log.STRING(l_Proc_Level,
1322: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1323: 'p_ledger_id ' || p_ledger_Id);
1324:
1325: Fnd_Log.STRING(l_Proc_Level,

Line 1325: Fnd_Log.STRING(l_Proc_Level,

1321: Fnd_Log.STRING(l_Proc_Level,
1322: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1323: 'p_ledger_id ' || p_ledger_Id);
1324:
1325: Fnd_Log.STRING(l_Proc_Level,
1326: l_Module_Prefix || '.' || l_Proc_Name || '.parameters',
1327: 'p_legal_entity_id ' || p_legal_entity_id);
1328:
1329: END IF; --(l_proc_level >= l_dbg_level)

Line 1522: Fnd_Log.STRING(l_Proc_Level,

1518: EXCEPTION
1519: WHEN OTHERS THEN
1520: IF (l_Proc_Level >= l_Dbg_Level)
1521: THEN
1522: Fnd_Log.STRING(l_Proc_Level,
1523: l_Module_Prefix || '.' || l_Proc_Name ||
1524: '. Other_Exception ',
1525: SQLCODE || ':' || SQLERRM);
1526: END IF; --(l_proc_level >= l_dbg_level)

Line 1620: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1616: FUNCTION Get_XML_Encoding
1617: RETURN VARCHAR2
1618: IS
1619: lv_procedure_name VARCHAR2(40):='Get_XML_Encoding';
1620: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1621: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1622: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1623: ln_xml_encoding VARCHAR2(100);
1624: BEGIN

Line 1621: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1617: RETURN VARCHAR2
1618: IS
1619: lv_procedure_name VARCHAR2(40):='Get_XML_Encoding';
1620: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1621: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1622: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1623: ln_xml_encoding VARCHAR2(100);
1624: BEGIN
1625: --logging for debug

Line 1622: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;

1618: IS
1619: lv_procedure_name VARCHAR2(40):='Get_XML_Encoding';
1620: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1621: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1622: ln_statement_level NUMBER := FND_LOG.LEVEL_STATEMENT;
1623: ln_xml_encoding VARCHAR2(100);
1624: BEGIN
1625: --logging for debug
1626: IF (ln_proc_level>=ln_dbg_level)

Line 1628: FND_LOG.STRING( ln_proc_level

1624: BEGIN
1625: --logging for debug
1626: IF (ln_proc_level>=ln_dbg_level)
1627: THEN
1628: FND_LOG.STRING( ln_proc_level
1629: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
1630: , 'Enter procedure'
1631: );
1632: END IF; --l_proc_level>=l_dbg_level

Line 1651: FND_LOG.STRING(ln_statement_level,

1647:
1648: --logging the variables
1649: IF (ln_statement_level >= ln_dbg_level)
1650: THEN
1651: FND_LOG.STRING(ln_statement_level,
1652: lv_procedure_name,
1653: 'The encoding is:' || ln_xml_encoding);
1654: END IF; --(ln_statement_level >= ln_dbg_level)
1655:

Line 1659: FND_LOG.STRING( ln_proc_level

1655:
1656: --logging for debug
1657: IF (ln_proc_level>=ln_dbg_level)
1658: THEN
1659: FND_LOG.STRING( ln_proc_level
1660: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
1661: , 'Exit procedure'
1662: );
1663: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1707: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1703: )
1704: RETURN VARCHAR2
1705: IS
1706: lv_procedure_name VARCHAR2(40):='Get_XML_Tag';
1707: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1708: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1709: lv_xml_tag VARCHAR2(200);
1710: BEGIN
1711: --logging for debug

Line 1708: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1704: RETURN VARCHAR2
1705: IS
1706: lv_procedure_name VARCHAR2(40):='Get_XML_Tag';
1707: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1708: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1709: lv_xml_tag VARCHAR2(200);
1710: BEGIN
1711: --logging for debug
1712: IF (ln_proc_level>=ln_dbg_level)

Line 1714: FND_LOG.STRING( ln_proc_level

1710: BEGIN
1711: --logging for debug
1712: IF (ln_proc_level>=ln_dbg_level)
1713: THEN
1714: FND_LOG.STRING( ln_proc_level
1715: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
1716: , 'Enter procedure'
1717: );
1718: END IF; --(ln_proc_level>=ln_dbg_level)

Line 1764: FND_LOG.STRING( ln_proc_level

1760:
1761: --logging for debug
1762: IF (ln_proc_level>=ln_dbg_level)
1763: THEN
1764: FND_LOG.STRING( ln_proc_level
1765: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
1766: , 'Exit procedure'
1767: );
1768: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1804: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1800: ,pv_module_name VARCHAR2 DEFAULT 'GLSI'
1801: )
1802: IS
1803: lv_procedure_name VARCHAR2(40):='Add_Sub_Root_Node';
1804: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1805: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1806:
1807:
1808: BEGIN

Line 1805: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1801: )
1802: IS
1803: lv_procedure_name VARCHAR2(40):='Add_Sub_Root_Node';
1804: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1805: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1806:
1807:
1808: BEGIN
1809: --logging for debug

Line 1812: FND_LOG.STRING( ln_proc_level

1808: BEGIN
1809: --logging for debug
1810: IF (ln_proc_level>=ln_dbg_level)
1811: THEN
1812: FND_LOG.STRING( ln_proc_level
1813: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
1814: , 'Enter procedure'
1815: );
1816: END IF; --l_proc_level>=l_dbg_level

Line 1825: FND_LOG.STRING( ln_proc_level

1821:
1822: --logging for debug
1823: IF (ln_proc_level>=ln_dbg_level)
1824: THEN
1825: FND_LOG.STRING( ln_proc_level
1826: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
1827: , 'Exit procedure'
1828: );
1829: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1832: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1828: );
1829: END IF; -- (ln_proc_level>=ln_dbg_level)
1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1833: THEN
1834: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1835: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1836: , Sqlcode||Sqlerrm);

Line 1834: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1830: EXCEPTION
1831: WHEN OTHERS THEN
1832: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1833: THEN
1834: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1835: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1836: , Sqlcode||Sqlerrm);
1837: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1838: END Add_Sub_Root_Node;

Line 1837: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1833: THEN
1834: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1835: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1836: , Sqlcode||Sqlerrm);
1837: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1838: END Add_Sub_Root_Node;
1839:
1840: --==========================================================================
1841: -- PROCEDURE NAME:

Line 1876: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1872: ,pv_module_name VARCHAR2 DEFAULT 'GLSI'
1873: )
1874: IS
1875: lv_procedure_name VARCHAR2(40):='Add_Child_Node';
1876: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1877: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1878: BEGIN
1879: --logging for debug
1880: IF (ln_proc_level>=ln_dbg_level)

Line 1877: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1873: )
1874: IS
1875: lv_procedure_name VARCHAR2(40):='Add_Child_Node';
1876: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1877: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1878: BEGIN
1879: --logging for debug
1880: IF (ln_proc_level>=ln_dbg_level)
1881: THEN

Line 1882: FND_LOG.STRING( ln_proc_level

1878: BEGIN
1879: --logging for debug
1880: IF (ln_proc_level>=ln_dbg_level)
1881: THEN
1882: FND_LOG.STRING( ln_proc_level
1883: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
1884: , 'Enter procedure'
1885: );
1886: END IF; --l_proc_level>=l_dbg_level

Line 1910: FND_LOG.STRING( ln_proc_level

1906: END IF;
1907: --logging for debug
1908: IF (ln_proc_level>=ln_dbg_level)
1909: THEN
1910: FND_LOG.STRING( ln_proc_level
1911: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
1912: , 'Exit procedure'
1913: );
1914: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 1918: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1914: END IF; -- (ln_proc_level>=ln_dbg_level)
1915:
1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1919: THEN
1920: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1921: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1922: , Sqlcode||Sqlerrm);

Line 1920: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

1916: EXCEPTION
1917: WHEN OTHERS THEN
1918: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1919: THEN
1920: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1921: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1922: , Sqlcode||Sqlerrm);
1923: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1924: END Add_Child_Node;

Line 1923: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

1919: THEN
1920: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
1921: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
1922: , Sqlcode||Sqlerrm);
1923: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
1924: END Add_Child_Node;
1925:
1926: --==========================================================================
1927: -- PROCEDURE NAME:

Line 1960: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

1956: ,pv_module_name VARCHAR2 DEFAULT 'GLSI'
1957: )
1958: IS
1959: lv_procedure_name VARCHAR2(40):='Add_Fixed_Child_Node';
1960: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1961: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1962: lv_text_node_value VARCHAR2(10);
1963: LENGTH_IS_NOT_MATCHED EXCEPTION;
1964: BEGIN

Line 1961: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

1957: )
1958: IS
1959: lv_procedure_name VARCHAR2(40):='Add_Fixed_Child_Node';
1960: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
1961: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
1962: lv_text_node_value VARCHAR2(10);
1963: LENGTH_IS_NOT_MATCHED EXCEPTION;
1964: BEGIN
1965: --logging for debug

Line 1968: FND_LOG.STRING( ln_proc_level

1964: BEGIN
1965: --logging for debug
1966: IF (ln_proc_level>=ln_dbg_level)
1967: THEN
1968: FND_LOG.STRING( ln_proc_level
1969: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
1970: , 'Enter procedure'
1971: );
1972: END IF; --l_proc_level>=l_dbg_level

Line 1998: FND_LOG.STRING( ln_proc_level

1994:
1995: --logging for debug
1996: IF (ln_proc_level>=ln_dbg_level)
1997: THEN
1998: FND_LOG.STRING( ln_proc_level
1999: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2000: , 'Exit procedure'
2001: );
2002: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2009: FND_LOG.STRING(ln_proc_level,

2005: WHEN LENGTH_IS_NOT_MATCHED THEN
2006: --logging for debug
2007: IF (ln_proc_level >= ln_dbg_level)
2008: THEN
2009: FND_LOG.STRING(ln_proc_level,
2010: l_Module_Prefix || '.' || lv_procedure_name ||
2011: '.exception',
2012: 'The length of the element ' || pv_child_tag_name || ' should be ' || pn_fixed_length);
2013: END IF; --l_proc_level>=l_dbg_level

Line 2017: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2013: END IF; --l_proc_level>=l_dbg_level
2014: FND_FILE.put_line(FND_FILE.log, 'The length of the element ' || pv_child_tag_name || ' should be ' || pn_fixed_length);
2015: RAISE;
2016: WHEN OTHERS THEN
2017: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2018: THEN
2019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2020: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
2021: , Sqlcode||Sqlerrm);

Line 2019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED

2015: RAISE;
2016: WHEN OTHERS THEN
2017: IF(FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2018: THEN
2019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2020: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
2021: , Sqlcode||Sqlerrm);
2022: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2023: END Add_Fixed_Child_Node;

Line 2022: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)

2018: THEN
2019: FND_LOG.STRING( FND_LOG.LEVEL_UNEXPECTED
2020: , l_Module_Prefix ||'.' || lv_procedure_name || '.Other_Exception '
2021: , Sqlcode||Sqlerrm);
2022: END IF; -- (FND_LOG.LEVEL_UNEXPECTED >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)
2023: END Add_Fixed_Child_Node;
2024:
2025: --==========================================================================
2026: -- FUNCTION NAME:

Line 2139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2135: ln_accounting_year_len NUMBER;
2136: ln_from_month NUMBER;
2137: ln_to_month NUMBER;
2138: lv_procedure_name VARCHAR2(30) := 'Generate_File_Name';
2139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2141:
2142: -- this cursor is to get looup_meaning under some lookup_code
2143: CURSOR lookup_cur IS

Line 2140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2136: ln_from_month NUMBER;
2137: ln_to_month NUMBER;
2138: lv_procedure_name VARCHAR2(30) := 'Generate_File_Name';
2139: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2140: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2141:
2142: -- this cursor is to get looup_meaning under some lookup_code
2143: CURSOR lookup_cur IS
2144: SELECT

Line 2178: FND_LOG.STRING( ln_proc_level

2174: BEGIN
2175: --logging for debug
2176: IF (ln_proc_level>=ln_dbg_level)
2177: THEN
2178: FND_LOG.STRING( ln_proc_level
2179: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2180: , 'Enter procedure'
2181: );
2182: END IF;-- (ln_proc_level>=ln_dbg_level)

Line 2261: FND_LOG.STRING( ln_proc_level

2257: lv_filename := lv_filename || '.xml';
2258: --logging for debug
2259: IF (ln_proc_level>=ln_dbg_level)
2260: THEN
2261: FND_LOG.STRING( ln_proc_level
2262: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2263: , 'Exit procedure');
2264: END IF; -- (ln_proc_level>=ln_dbg_level)
2265:

Line 2272: Fnd_Log.STRING(ln_proc_level,

2268: EXCEPTION
2269: WHEN OTHERS THEN
2270: IF (ln_proc_level>=ln_dbg_level)
2271: THEN
2272: Fnd_Log.STRING(ln_proc_level,
2273: l_Module_Prefix || '.' || lv_procedure_name ||
2274: '. Other_Exception ',
2275: SQLCODE || ':' || SQLERRM);
2276: END IF;-- (ln_proc_level>=ln_dbg_level)

Line 2305: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;

2301: RETURN BOOLEAN
2302: IS
2303: lv_False_Flag VARCHAR2(1) := 'N';
2304: lv_Error_Msg VARCHAR2(2000);
2305: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
2306: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
2307: lv_Proc_Name VARCHAR2(100) := 'Check_System_Option';
2308: ln_row_count NUMBER := 0;
2309:

Line 2306: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;

2302: IS
2303: lv_False_Flag VARCHAR2(1) := 'N';
2304: lv_Error_Msg VARCHAR2(2000);
2305: ln_Dbg_Level NUMBER := Fnd_Log.g_Current_Runtime_Level;
2306: ln_Proc_Level NUMBER := Fnd_Log.Level_Procedure;
2307: lv_Proc_Name VARCHAR2(100) := 'Check_System_Option';
2308: ln_row_count NUMBER := 0;
2309:
2310: CURSOR system_option_cur(ln_legal_entity_id NUMBER) IS

Line 2325: Fnd_Log.STRING(ln_Proc_Level,

2321:
2322: --log for debug
2323: IF (ln_Proc_Level >= ln_Dbg_Level)
2324: THEN
2325: Fnd_Log.STRING(ln_Proc_Level,
2326: l_Module_Prefix || '.' || lv_Proc_Name || '.begin',
2327: 'Enter function');
2328: END IF; --(l_proc_level >= l_dbg_level)
2329:

Line 2368: Fnd_Log.STRING(ln_Proc_Level,

2364: IF lv_False_Flag = 'N'
2365: THEN
2366: --log for debug
2367: IF (ln_Proc_Level >= ln_Dbg_Level) THEN
2368: Fnd_Log.STRING(ln_Proc_Level,
2369: l_Module_Prefix || '.' || lv_Proc_Name || '.end',
2370: 'Exit function');
2371: END IF; --( ln_proc_level >= ln_dbg_level )
2372: RETURN TRUE;

Line 2377: Fnd_Log.STRING(ln_Proc_Level,

2373: ELSE
2374: --log for debug
2375: IF (ln_Proc_Level >= ln_Dbg_Level)
2376: THEN
2377: Fnd_Log.STRING(ln_Proc_Level,
2378: l_Module_Prefix || '.' || lv_Proc_Name || '.end',
2379: 'Exit function');
2380: END IF; --( ln_proc_level >= ln_dbg_level )
2381: RETURN FALSE;

Line 2390: Fnd_Log.STRING(ln_Proc_Level,

2386: WHEN OTHERS
2387: THEN
2388: IF (ln_Proc_Level >= ln_Dbg_Level)
2389: THEN
2390: Fnd_Log.STRING(ln_Proc_Level,
2391: l_Module_Prefix || '.' || lv_Proc_Name ||
2392: '. Other_Exception ',
2393: SQLCODE || ':' || SQLERRM);
2394: END IF; --(ln_proc_level >= ln_dbg_level)

Line 2428: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2424: ,pv_module_name VARCHAR2 DEFAULT 'GLSI'
2425: )
2426: IS
2427: lv_procedure_name VARCHAR2(40):='Print_Concurrent_Steps_For_Log';
2428: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2429: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2430: BEGIN
2431: --logging for debug
2432: IF (ln_proc_level>=ln_dbg_level)

Line 2429: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2425: )
2426: IS
2427: lv_procedure_name VARCHAR2(40):='Print_Concurrent_Steps_For_Log';
2428: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2429: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2430: BEGIN
2431: --logging for debug
2432: IF (ln_proc_level>=ln_dbg_level)
2433: THEN

Line 2434: FND_LOG.STRING( ln_proc_level

2430: BEGIN
2431: --logging for debug
2432: IF (ln_proc_level>=ln_dbg_level)
2433: THEN
2434: FND_LOG.STRING( ln_proc_level
2435: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2436: , 'Enter procedure'
2437: );
2438: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2450: FND_LOG.STRING( ln_proc_level

2446:
2447: --logging for debug
2448: IF (ln_proc_level>=ln_dbg_level)
2449: THEN
2450: FND_LOG.STRING( ln_proc_level
2451: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2452: , 'Exit procedure'
2453: );
2454: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2485: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2481: ,pv_module_name VARCHAR2 DEFAULT 'GLSI'
2482: )
2483: IS
2484: lv_procedure_name VARCHAR2(40):='Print_No_Data_Found_For_Log';
2485: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2486: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2487: BEGIN
2488: --logging for debug
2489: IF (ln_proc_level>=ln_dbg_level)

Line 2486: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2482: )
2483: IS
2484: lv_procedure_name VARCHAR2(40):='Print_No_Data_Found_For_Log';
2485: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2486: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2487: BEGIN
2488: --logging for debug
2489: IF (ln_proc_level>=ln_dbg_level)
2490: THEN

Line 2491: FND_LOG.STRING( ln_proc_level

2487: BEGIN
2488: --logging for debug
2489: IF (ln_proc_level>=ln_dbg_level)
2490: THEN
2491: FND_LOG.STRING( ln_proc_level
2492: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2493: , 'Enter procedure'
2494: );
2495: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2506: FND_LOG.STRING( ln_proc_level

2502:
2503: --logging for debug
2504: IF (ln_proc_level>=ln_dbg_level)
2505: THEN
2506: FND_LOG.STRING( ln_proc_level
2507: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2508: , 'Exit procedure'
2509: );
2510: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2548: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2544: IS
2545: lv_rounding_rule VARCHAR2(30);
2546: ln_rounding_value NUMBER(20,2) := 0;
2547: lv_procedure_name VARCHAR2(30) := 'Generate_File_Name';
2548: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2549: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2550:
2551: BEGIN
2552:

Line 2549: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;

2545: lv_rounding_rule VARCHAR2(30);
2546: ln_rounding_value NUMBER(20,2) := 0;
2547: lv_procedure_name VARCHAR2(30) := 'Generate_File_Name';
2548: ln_dbg_level NUMBER:=FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2549: ln_proc_level NUMBER:=FND_LOG.LEVEL_PROCEDURE;
2550:
2551: BEGIN
2552:
2553: --get the system rounding rule

Line 2576: Fnd_Log.STRING(ln_proc_level,

2572: EXCEPTION
2573: WHEN OTHERS THEN
2574: IF (ln_proc_level>=ln_dbg_level)
2575: THEN
2576: Fnd_Log.STRING(ln_proc_level,
2577: l_Module_Prefix || '.' || lv_procedure_name ||
2578: '. Other_Exception ',
2579: SQLCODE || ':' || SQLERRM);
2580: END IF;-- (ln_proc_level>=ln_dbg_level)

Line 2613: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2609: RETURN VARCHAR2
2610: IS
2611: lv_attribute_column VARCHAR2(30) := NULL;
2612: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Column';
2613: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2614: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2615:
2616:
2617: CURSOR attribute_column_cur

Line 2614: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2610: IS
2611: lv_attribute_column VARCHAR2(30) := NULL;
2612: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Column';
2613: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2614: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2615:
2616:
2617: CURSOR attribute_column_cur
2618: IS

Line 2629: FND_LOG.STRING( ln_proc_level

2625: BEGIN
2626: --logging for debug
2627: IF (ln_proc_level>=ln_dbg_level)
2628: THEN
2629: FND_LOG.STRING( ln_proc_level
2630: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2631: , 'Enter procedure'
2632: );
2633: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2646: FND_LOG.STRING( ln_proc_level

2642:
2643: --logging for debug
2644: IF (ln_proc_level>=ln_dbg_level)
2645: THEN
2646: FND_LOG.STRING( ln_proc_level
2647: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2648: , 'Exit procedure'
2649: );
2650: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2683: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2679: RETURN VARCHAR2
2680: IS
2681: lv_segment_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2682: lv_procedure_name VARCHAR2(40) := 'Get_Segment_Value_Desc';
2683: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2684: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2685:
2686:
2687: CURSOR segment_value_cur

Line 2684: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2680: IS
2681: lv_segment_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2682: lv_procedure_name VARCHAR2(40) := 'Get_Segment_Value_Desc';
2683: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2684: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2685:
2686:
2687: CURSOR segment_value_cur
2688: IS

Line 2709: FND_LOG.STRING( ln_proc_level

2705: BEGIN
2706: --logging for debug
2707: IF (ln_proc_level>=ln_dbg_level)
2708: THEN
2709: FND_LOG.STRING( ln_proc_level
2710: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2711: , 'Enter procedure'
2712: );
2713: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2726: FND_LOG.STRING( ln_proc_level

2722:
2723: --logging for debug
2724: IF (ln_proc_level>=ln_dbg_level)
2725: THEN
2726: FND_LOG.STRING( ln_proc_level
2727: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2728: , 'Exit procedure'
2729: );
2730: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2763: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2759: RETURN VARCHAR2
2760: IS
2761: lv_atrribute_value Fnd_Flex_Values.ATTRIBUTE1%TYPE := NULL;
2762: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
2763: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2764: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2765:
2766: lv_cursor_sql VARCHAR2(2000);
2767: TYPE ref_cursor IS REF CURSOR;

Line 2764: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2760: IS
2761: lv_atrribute_value Fnd_Flex_Values.ATTRIBUTE1%TYPE := NULL;
2762: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
2763: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2764: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2765:
2766: lv_cursor_sql VARCHAR2(2000);
2767: TYPE ref_cursor IS REF CURSOR;
2768: lc_attribute_value ref_cursor;

Line 2774: FND_LOG.STRING( ln_proc_level

2770: BEGIN
2771: --logging for debug
2772: IF (ln_proc_level>=ln_dbg_level)
2773: THEN
2774: FND_LOG.STRING( ln_proc_level
2775: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2776: , 'Enter procedure'
2777: );
2778: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2804: FND_LOG.STRING( ln_proc_level

2800:
2801: --logging for debug
2802: IF (ln_proc_level>=ln_dbg_level)
2803: THEN
2804: FND_LOG.STRING( ln_proc_level
2805: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2806: , 'Exit procedure'
2807: );
2808: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 2841: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

2837: RETURN VARCHAR2
2838: IS
2839: lv_attribute_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2840: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value_Desc';
2841: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2842: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2843:
2844: CURSOR attribute_value_cur
2845: IS

Line 2842: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

2838: IS
2839: lv_attribute_value_desc FND_FLEX_VALUES_TL.Description%TYPE := NULL;
2840: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value_Desc';
2841: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
2842: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
2843:
2844: CURSOR attribute_value_cur
2845: IS
2846: SELECT FFV.Flex_Value Attribute_Value

Line 2865: FND_LOG.STRING( ln_proc_level

2861: BEGIN
2862: --logging for debug
2863: IF (ln_proc_level>=ln_dbg_level)
2864: THEN
2865: FND_LOG.STRING( ln_proc_level
2866: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
2867: , 'Enter procedure'
2868: );
2869: END IF; --(ln_proc_level>=ln_dbg_level)

Line 2882: FND_LOG.STRING( ln_proc_level

2878:
2879: --logging for debug
2880: IF (ln_proc_level>=ln_dbg_level)
2881: THEN
2882: FND_LOG.STRING( ln_proc_level
2883: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
2884: , 'Exit procedure'
2885: );
2886: END IF; -- (ln_proc_level>=ln_dbg_level)

Line 3064: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;

3060: ,pv_flexfield_code IN VARCHAR2
3061: ) RETURN VARCHAR2 IS
3062: lv_budget_type_value Fnd_Flex_Values.Flex_Value%TYPE := NULL;
3063: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
3064: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3065: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
3066:
3067: lv_cursor_sql VARCHAR2(2000);
3068: TYPE ref_cursor IS REF CURSOR;

Line 3065: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;

3061: ) RETURN VARCHAR2 IS
3062: lv_budget_type_value Fnd_Flex_Values.Flex_Value%TYPE := NULL;
3063: lv_procedure_name VARCHAR2(40) := 'Get_Attribute_Value';
3064: ln_dbg_level NUMBER := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
3065: ln_proc_level NUMBER := FND_LOG.LEVEL_PROCEDURE;
3066:
3067: lv_cursor_sql VARCHAR2(2000);
3068: TYPE ref_cursor IS REF CURSOR;
3069: lc_budget_type_value ref_cursor;

Line 3075: FND_LOG.STRING( ln_proc_level

3071: BEGIN
3072: --logging for debug
3073: IF (ln_proc_level>=ln_dbg_level)
3074: THEN
3075: FND_LOG.STRING( ln_proc_level
3076: , l_Module_Prefix ||'.' || lv_procedure_name || '.begin'
3077: , 'Enter procedure'
3078: );
3079: END IF; --(ln_proc_level>=ln_dbg_level)

Line 3105: FND_LOG.STRING( ln_proc_level

3101:
3102: --logging for debug
3103: IF (ln_proc_level>=ln_dbg_level)
3104: THEN
3105: FND_LOG.STRING( ln_proc_level
3106: , l_Module_Prefix ||'.' || lv_procedure_name || '.end'
3107: , 'Exit procedure'
3108: );
3109: END IF; -- (ln_proc_level>=ln_dbg_level)