23:
24:
25: PROCEDURE read_debug_profiles IS
26: BEGIN
27: g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
28: g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
29: g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
30: g_stop_on_debug_error := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR');
31: END read_debug_profiles;
24:
25: PROCEDURE read_debug_profiles IS
26: BEGIN
27: g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
28: g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
29: g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
30: g_stop_on_debug_error := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR');
31: END read_debug_profiles;
32:
25: PROCEDURE read_debug_profiles IS
26: BEGIN
27: g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
28: g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
29: g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
30: g_stop_on_debug_error := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR');
31: END read_debug_profiles;
32:
33: PROCEDURE put_line(p_message IN VARCHAR2)
26: BEGIN
27: g_debug_level := fnd_profile.value('CSI_DEBUG_LEVEL');
28: g_debug_file := fnd_profile.value('CSI_LOGFILE_NAME');
29: g_debug_file_path := fnd_profile.value('CSI_LOGFILE_PATH');
30: g_stop_on_debug_error := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR');
31: END read_debug_profiles;
32:
33: PROCEDURE put_line(p_message IN VARCHAR2)
34: IS
36: l_sid NUMBER;
37: l_os_user VARCHAR2(30);
38: l_file_handle utl_file.file_type;
39:
40: -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41: -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42: -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402
43:
44: -- l_debug_level NUMBER := fnd_profile.value('CSI_DEBUG_LEVEL'); -- Bug 7197402
37: l_os_user VARCHAR2(30);
38: l_file_handle utl_file.file_type;
39:
40: -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41: -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42: -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402
43:
44: -- l_debug_level NUMBER := fnd_profile.value('CSI_DEBUG_LEVEL'); -- Bug 7197402
45: l_log_file VARCHAR2(30);
38: l_file_handle utl_file.file_type;
39:
40: -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41: -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42: -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402
43:
44: -- l_debug_level NUMBER := fnd_profile.value('CSI_DEBUG_LEVEL'); -- Bug 7197402
45: l_log_file VARCHAR2(30);
46: l_instr NUMBER;
40: -- l_log_file VARCHAR2(30) := fnd_profile.value('CSI_LOGFILE_NAME'); -- Bug 7197402
41: -- l_log_file_path VARCHAR2(240) := fnd_profile.value('CSI_LOGFILE_PATH'); -- Bug 7197402
42: -- l_stop_on_debug_error VARCHAR2(10) := fnd_profile.value('CSI_STOP_AT_DEBUG_ERROR'); -- Bug 7197402
43:
44: -- l_debug_level NUMBER := fnd_profile.value('CSI_DEBUG_LEVEL'); -- Bug 7197402
45: l_log_file VARCHAR2(30);
46: l_instr NUMBER;
47: BEGIN
48: -- Added for the bug 7197402