[Home] [Help]
PACKAGE: APPS.BIS_VG_LOG
Source
1 PACKAGE bis_vg_log AUTHID CURRENT_USER AS
2 /* $Header: BISTLOGS.pls 115.7 2002/03/27 08:18:41 pkm ship $ */
3
4 -- Copyright (c) 1998 Oracle Corporation, Redwood Shores, CA, USA
5 -- All rights reserved.
6 --
7 -- FILENAME
8 --
9 -- BISTLOGB.pls
10 --
11 -- DESCRIPTION
12 --
13 -- body of package which writes the log for generated business views
14 --
15 -- NOTES
16 --
17 -- HISTORY
18 --
19 -- 21-Aug-1998 ANSINGHA created
20 -- 08-Jan-2001 Walid.Nasrallah Modified to add write_error_to_string
21 -- 10-DEC-01 Edited by DBOWLES Added db driver comment
22 --
23 -- ============================================================================
24 -- EXCEPTIONS
25 -- ============================================================================
26
27 numeric_or_value_error exception;
28 pragma exception_init(numeric_or_value_error, -6502);
29
30 -- ============================================================================
31 --PROCEDURE : Init_Log
32 --PARAMETERS
33 -- 1. x_return_status error or normal
34 -- 2. x_error_Tbl table of error messages
35
36 --COMMENT : Call this function to start logging the messages
37 --RETURN : None
38 --EXCEPTION : None
39 -- ============================================================================
40
41 PROCEDURE init_log
42 ( x_return_status OUT VARCHAR2
43 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
44 )
45 ;
46
47 -- ============================================================================
48 --PROCEDURE : Update_Success_Log
49 --PARAMETERS: 1. p_OrigBV - Original business view name
50 -- 2. p_GenBV - Generated Business View name
51 -- 3. x_return_status error or normal
52 -- 4. x_error_Tbl table of error messages
53 --COMMENT : Call this function to log a successful generation
54 --RETURN : None
55 --EXCEPTION : None
56 -- ============================================================================
57 PROCEDURE update_success_log
58 ( p_origbv IN bis_vg_types.view_name_type
59 , p_genbv IN bis_vg_types.view_name_type
60 , x_return_status OUT VARCHAR2
61 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
62 );
63
64 -- ============================================================================
65 --PROCEDURE : Update_Failure_Log
66 --PARAMETERS: 1. p_OrigBV - Original business view name
67 -- 2. p_code - code for the error message
68 -- 3. p_errm - error message
69 -- 4. x_return_status error or normal
70 -- 5. x_error_Tbl table of error messages
71 --COMMENT : Call this function to log failed generation
72 --RETURN : None
73 --EXCEPTION : None
74 -- ============================================================================
75 PROCEDURE update_failure_log
76 ( p_origbv IN bis_vg_types.view_name_type
77 , p_code IN NUMBER
78 , p_errm IN VARCHAR2
79 , x_return_status OUT VARCHAR2
80 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
81 );
82
83 -- ============================================================================
84 --PROCEDURE : Update_Failure_Log
85 --PARAMETERS: 1. p_error_Tbl - table containint one or more error messages
86 -- 2. x_return_status error or normal
87 -- 3. x_error_Tbl table of error messages
88 --COMMENT : This overloaded version of Update_Failure_Log generates
89 -- a partiual log of failure at teh point where it occurs.
90 --RETURN : None
91 --EXCEPTION : None
92 -- ============================================================================
93 PROCEDURE update_failure_log
94 ( p_error_Tbl IN BIS_VG_UTIL.Error_Tbl_Type
95 , x_return_status OUT VARCHAR2
96 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
97 );
98
99 -- ============================================================================
100 --PROCEDURE : backpatch_failure_log
101 --PARAMETERS: 1. p_OrigBV - Original business view name
102 -- 2. x_return_status error or normal
103 -- 3. x_error_Tbl table of error messages
104 --COMMENT : Function fills in view name where missing. Used in
105 -- conjunction with the short version of update_failure_log.
106 --RETURN : None
107 --EXCEPTION : None
108 -- ============================================================================
109 PROCEDURE backpatch_failure_log
110 ( p_origbv IN bis_vg_types.view_name_type
111 , x_return_status OUT VARCHAR2
112 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
113 );
114
115
116 -- ============================================================================
117 --PROCEDURE : Write_Log
118 --PARAMETERS 1. p_mode IN bis_vg_Types.view_generator_mode_type
119 -- 2. p_all_flag IN VARCHAR2
120 -- 3. p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
121 -- 4. p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
122 -- 5. p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
123 -- 6. p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
124 -- 7. p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
125 -- 8. p_Lookup_Table_Name IN VARCHAR2
126 -- 9. p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
127 -- 10. p_View_Name IN BIS_VG_TYPES.View_Name_Type
128 -- 11. x_return_status error or normal
129 -- 12. x_error_Tbl table of error messages
130 --COMMENT : Call this function to write the log to the out file in production
131 --RETURN : None
132 --EXCEPTION : None
133 -- ============================================================================
134 PROCEDURE write_log
135 ( p_mode IN bis_vg_types.View_Generator_Mode_Type
136 , p_all_flag IN VARCHAR2
137 , p_App_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
138 , p_KF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
139 , p_Key_Flex_Code IN BIS_VG_TYPES.Key_Flex_Code_Type
140 , p_DF_Appl_Short_Name IN BIS_VG_TYPES.App_Short_Name_Type
141 , p_Desc_Flex_Name IN BIS_VG_TYPES.Desc_Flex_Name_Type
142 , p_Lookup_Table_Name IN VARCHAR2
143 , p_Lookup_Type IN BIS_VG_TYPES.Lookup_Code_Type
144 , p_View_Name IN BIS_VG_TYPES.View_Name_Type
145 , x_return_status OUT VARCHAR2
146 , x_error_Tbl OUT BIS_VG_UTIL.Error_Tbl_Type
147 );
148 -- ============================================================================
149 -- PROCEDURE : Write_Error_to_String
150 -- PARAMETERS 1. x_error_string String to hold error messages
151 -- COMMENT : Call this function to access the list of errors in g_failure_log
152 -- RETURN : None
153 -- EXCEPTION : None
154 -- ============================================================================
155 PROCEDURE write_error_to_string
156 ( x_error_string OUT VARCHAR2
157 );
158
159 END BIS_VG_LOG;