[Home] [Help]
PACKAGE: APPS.PO_DEBUG
Source
1 PACKAGE PO_DEBUG AUTHID CURRENT_USER AS
2 -- $Header: POXDBUGS.pls 120.1 2005/07/07 11:20:36 sbull noship $
3
4 /***************************************************************
5 ***************************************************************
6
7 The logging routines in this package are obsolete.
8 They are replaced by routines in the PO_LOG package.
9
10 For more details on the PO logging strategy, see the document at
11 /podev/po/internal/standards/logging/logging.xml
12
13 ***************************************************************
14 ***************************************************************
15 */
16
17 g_all_rows CONSTANT PO_TBL_VARCHAR2000 := PO_LOG.c_all_rows;
18
19 -----------------------------------------------------------------------------
20 -- Public variables.
21 -----------------------------------------------------------------------------
22
23 -- provided for convenience to callers of debug_table
24 g_rowid_tbl po_tbl_varchar2000;
25 g_column_tbl po_tbl_varchar30;
26
27
28 -----------------------------------------------------------------------------
29 -- Public procedures.
30 -----------------------------------------------------------------------------
31
32 FUNCTION is_debug_stmt_on
33 RETURN BOOLEAN
34 ;
35
36 FUNCTION is_debug_unexp_on
37 RETURN BOOLEAN
38 ;
39
40 PROCEDURE debug_stmt(
41 p_log_head IN VARCHAR2
42 , p_token IN VARCHAR2
43 , p_message IN VARCHAR2
44 );
45
46 PROCEDURE debug_begin(
47 p_log_head IN VARCHAR2
48 );
49
50 PROCEDURE debug_end(
51 p_log_head IN VARCHAR2
52 );
53
54 PROCEDURE debug_var(
55 p_log_head IN VARCHAR2
56 , p_progress IN VARCHAR2
57 , p_name IN VARCHAR2
58 , p_value IN VARCHAR2
59 );
60
61 PROCEDURE debug_var(
62 p_log_head IN VARCHAR2
63 , p_progress IN VARCHAR2
64 , p_name IN VARCHAR2
65 , p_value IN NUMBER
66 );
67
68 PROCEDURE debug_var(
69 p_log_head IN VARCHAR2
70 , p_progress IN VARCHAR2
71 , p_name IN VARCHAR2
72 , p_value IN DATE
73 );
74
75 PROCEDURE debug_var(
76 p_log_head IN VARCHAR2
77 , p_progress IN VARCHAR2
78 , p_name IN VARCHAR2
79 , p_value IN BOOLEAN
80 );
81
82 PROCEDURE debug_var(
83 p_log_head IN VARCHAR2
84 , p_progress IN VARCHAR2
85 , p_name IN VARCHAR2
86 , p_value IN po_tbl_number
87 );
88
89 PROCEDURE debug_var(
90 p_log_head IN VARCHAR2
91 , p_progress IN VARCHAR2
92 , p_name IN VARCHAR2
93 , p_value IN po_tbl_date
94 );
95
96 PROCEDURE debug_var(
97 p_log_head IN VARCHAR2
98 , p_progress IN VARCHAR2
99 , p_name IN VARCHAR2
100 , p_value IN po_tbl_varchar1
101 );
102
103 PROCEDURE debug_var(
104 p_log_head IN VARCHAR2
105 , p_progress IN VARCHAR2
106 , p_name IN VARCHAR2
107 , p_value IN po_tbl_varchar5
108 );
109
110 PROCEDURE debug_var(
111 p_log_head IN VARCHAR2
112 , p_progress IN VARCHAR2
113 , p_name IN VARCHAR2
114 , p_value IN po_tbl_varchar30
115 );
116
117 PROCEDURE debug_var(
118 p_log_head IN VARCHAR2
119 , p_progress IN VARCHAR2
120 , p_name IN VARCHAR2
121 , p_value IN po_tbl_varchar100
122 );
123
124 PROCEDURE debug_var(
125 p_log_head IN VARCHAR2
126 , p_progress IN VARCHAR2
127 , p_name IN VARCHAR2
128 , p_value IN po_tbl_varchar2000
129 );
130
131 PROCEDURE debug_exc(
132 p_log_head IN VARCHAR2
133 , p_progress IN VARCHAR2
134 );
135
136 PROCEDURE debug_err(
137 p_log_head IN VARCHAR2
138 , p_progress IN VARCHAR2
139 );
140
141 PROCEDURE debug_unexp(
142 p_log_head IN VARCHAR2
143 , p_progress IN VARCHAR2
144 , p_message IN VARCHAR2
145 DEFAULT NULL
146 );
147
148 PROCEDURE debug_table(
149 p_log_head IN VARCHAR2
150 , p_progress IN VARCHAR2
151 , p_table_name IN VARCHAR2
152 , p_rowid_tbl IN po_tbl_varchar2000
153 , p_column_name_tbl IN po_tbl_varchar30
154 DEFAULT NULL
155 , p_table_owner IN VARCHAR2
156 DEFAULT NULL
157 );
158
159 PROCEDURE debug_session_gt(
160 p_log_head IN VARCHAR2
161 , p_progress IN VARCHAR2
162 , p_key IN NUMBER
163 , p_column_name_tbl IN po_tbl_varchar30
164 DEFAULT NULL
165 );
166
167 PROCEDURE handle_unexp_error
168 ( p_pkg_name IN VARCHAR2,
169 p_proc_name IN VARCHAR2,
170 p_progress IN VARCHAR2 DEFAULT NULL,
171 p_add_to_msg_list IN BOOLEAN DEFAULT NULL
172 );
173
174 PROCEDURE write_msg_list_to_file (
175 p_log_head IN VARCHAR2
176 , p_progress IN VARCHAR2
177 );
178
179 -------------------------------------------------------------------------------
180 -------------------------------------------------------------------------------
181 -- 8/20/03: The following variables and procedures are non-standard comformant,
182 -- and should not be used.
183 -- They exist for legacy code.
184 -------------------------------------------------------------------------------
185 -------------------------------------------------------------------------------
186
187 --
188 -- Exposed package variables
189 --
190
191 write_to_file BOOLEAN := FALSE;
192
193
194
195 -- Write debug messages to file or standard out based on the value of package
196 -- variable PO_DEBUG.write_to_file.
197 --
198 -- Use PO_DEBUG.set_file_io( TRUE / FALSE ) to set this variable.
199
200 PROCEDURE PUT_LINE (v_line in varchar2);
201
202
203
204 -- Set flag for writing to file or standard out
205
206 PROCEDURE set_file_io(flag BOOLEAN);
207
208
209 END PO_DEBUG;