1 PACKAGE BSC_UPDATE_LOG AUTHID CURRENT_USER AS
2 /* $Header: BSCDLOGS.pls 115.5 2003/01/14 19:47:49 meastmon ship $ */
3
4
5 LOG NUMBER := 0; -- Log file
6 OUTPUT NUMBER := 1; -- Output file. Only make sense in APPS environment
7 -- In Personal, Loader always write in the log file.
8
9 --
10 -- Procedures and Fuctions
11 --
12
13 /*===========================================================================+
14 |
15 | Name: Init_Log_File
16 |
17 | Description: This function creates the log file. Additionally,
18 | write the standard header to the log file.
19 |
20 | The log file directory must be in the variable
21 | UTL_FILE_DIR of INIT table.
22 |
23 | Initialize package variables:
24 | g_log_file_name - Log file name
25 | g_log_file_dir - Lof file directory.
26 |
27 | Returns: If any error ocurrs, this function add the error message
28 | to the error stack and return FALSE. Otherwise return
29 | TRUE.
30 |
31 | Notes:
32 |
33 +============================================================================*/
34 FUNCTION Init_Log_File (
35 x_Log_File_Name IN VARCHAR2
36 ) RETURN BOOLEAN;
37
38
39 /*===========================================================================+
40 |
41 | Name: Log_File_Dir
42 |
43 | Description: This function returns the log file directory
44 |
45 | Notes:
46 |
47 +============================================================================*/
48 FUNCTION Log_File_Dir RETURN VARCHAR2;
49
50
51 /*===========================================================================+
52 |
53 | Name: Log_File_Name
54 |
55 | Description: This function returns the log file name
56 |
57 | Notes:
58 |
59 +============================================================================*/
60 FUNCTION Log_File_Name RETURN VARCHAR2;
61
62
63 /*===========================================================================+
64 |
65 | Name: Write_Line_Log
66 |
67 | Description: This procedure write the given string into the log file
68 |
69 | If the log file is not initialized then this procedure
70 | doesn't do anything. This is not an error.
71 |
72 | Notes:
73 |
74 +============================================================================*/
75 PROCEDURE Write_Line_Log (
76 x_line IN VARCHAR2,
77 x_which IN NUMBER
78 );
79
80
81 /*===========================================================================+
82 |
83 | Name: Write_Errors_To_Log
84 |
85 | Description: This procedure writes the messages that are in
86 | BSC_MESSAGE_LOGS table corresponding to the current session
87 | id, into the log file.
88 |
89 | If the log file is not initialized then this procedure
90 | doesn't do anything. This is not an error.
91 |
92 | Notes:
93 |
94 +============================================================================*/
95 PROCEDURE Write_Errors_To_Log;
96
97
98 END BSC_UPDATE_LOG;