1 package fii_message AUTHID CURRENT_USER as
2 /*$Header: FIIUMSGS.pls 115.1 2003/12/26 22:01:42 juding noship $*/
3 FUNCTION Get_Message ( msg_name VARCHAR2,
4 show_num VARCHAR2 ) RETURN VARCHAR2;
5
6 -- **************************************************************
7
8 FUNCTION Msg_Tkn_Expand(msg VARCHAR2,
9 t1 VARCHAR2,
10 v1 VARCHAR2) RETURN VARCHAR2;
11
12 -- *************************************************************
13
14 FUNCTION Get_Message(msg_name VARCHAR2,
15 show_num VARCHAR2,
16 t1 VARCHAR2,
17 v1 VARCHAR2) RETURN VARCHAR2;
18
19 -- **************************************************************
20
21 FUNCTION Get_Message(msg_name VARCHAR2,
22 show_num VARCHAR2,
23 t1 VARCHAR2,
24 v1 VARCHAR2,
25 t2 VARCHAR2,
26 v2 VARCHAR2) RETURN VARCHAR2;
27
28 -- **************************************************************
29
30 FUNCTION Get_Message(msg_name VARCHAR2,
31 show_num VARCHAR2,
32 t1 VARCHAR2,
33 v1 VARCHAR2,
34 t2 VARCHAR2,
35 v2 VARCHAR2,
36 t3 VARCHAR2,
37 v3 VARCHAR2) RETURN VARCHAR2;
38
39 -- ***************************************************************
40
41 FUNCTION Get_Message(msg_name VARCHAR2,
42 show_num VARCHAR2,
43 t1 VARCHAR2,
44 v1 VARCHAR2,
45 t2 VARCHAR2,
46 v2 VARCHAR2,
47 t3 VARCHAR2,
48 v3 VARCHAR2,
49 t4 VARCHAR2,
50 v4 VARCHAR2) RETURN VARCHAR2;
51
52 -- *****************************************************************
53 -- FUNCTION
54 -- Write_Buffer
55 -- Purpose
56 -- This Function used to write message name and actual message
57 -- (with token values) to buffer.
58 -- History
59 -- 10-04-2001 Srini Pala Created
60 -- Arguments
61 -- msg_name Name of the message
62 -- token_num Number of tokens exist in the message
63 -- t1 Name of the first token
64 -- v1 Value of the first token
65 -- t2 Name of the second token
66 -- v2 Value of the second token
67 -- t3 Name of the third token
68 -- v3 Value of the third token
69 -- t4 Name of the fourth token
70 -- v4 Value of the fourth token
71 -- t5 Name of the fifth token
72 -- v5 Value of the fifth token
73
74 -- Example
75 -- FII_MESSAGE.Write_Buffer('SHRD0117',2,''NUM','10','TABLE','GL_BALANCES')
76 --
77
78 FUNCTION Write_Buffer(msg_name VARCHAR2,
79 token_num NUMBER DEFAULT 0,
80 t1 VARCHAR2 DEFAULT NULL,
81 v1 VARCHAR2 DEFAULT NULL,
82 t2 VARCHAR2 DEFAULT NULL,
83 v2 VARCHAR2 DEFAULT NULL,
84 t3 VARCHAR2 DEFAULT NULL,
85 v3 VARCHAR2 DEFAULT NULL,
86 t4 VARCHAR2 DEFAULT NULL,
87 v4 VARCHAR2 DEFAULT NULL,
88 t5 VARCHAR2 DEFAULT NULL,
89 v5 VARCHAR2 DEFAULT NULL) RETURN VARCHAR2;
90
91 -- *******************************************************************
92
93 PROCEDURE Set_Language ( lang_id NUMBER ) ;
94
95 -- ********************************************************************
96 -- Procedure
97 -- Write_Log
98 -- Purpose
99 -- This prodcedure is similar to Write_Buffer () but used to write
100 -- meesage name and actual message (with token values) to a Log file.
101 -- History
102 -- 10-04-2001 Srini Pala Created
103 -- 02-27-2002 Srini Pala Name changed to Write_Log
104 -- Arguments
105 -- msg_name Name of the message
106 -- token_num Number of tokens exist in the message
107 -- t1 Name of the first token
108 -- v1 Value of the first token
109 -- t2 Name of the second token
110 -- v2 Value of the second token
111 -- t3 Name of the third token
112 -- v3 Value of the third token
113 -- t4 Name of the fourth token
114 -- v4 Value of the fourth token
115 -- t5 Name of the fifth token
116 -- v5 Value of the fifth token
117
118 -- Example
119 -- FII_MESSAGE.Write_Log('SHRD0117',2,''NUM','10','TABLE','GL_BALANCES')
120 --
121
122
123 PROCEDURE Write_Log (msg_name VARCHAR2,
124 token_num NUMBER DEFAULT 0,
125 t1 VARCHAR2 DEFAULT NULL,
126 v1 VARCHAR2 DEFAULT NULL,
127 t2 VARCHAR2 DEFAULT NULL,
128 v2 VARCHAR2 DEFAULT NULL,
129 t3 VARCHAR2 DEFAULT NULL,
130 v3 VARCHAR2 DEFAULT NULL,
131 t4 VARCHAR2 DEFAULT NULL,
132 v4 VARCHAR2 DEFAULT NULL,
133 t5 VARCHAR2 DEFAULT NULL,
134 v5 VARCHAR2 DEFAULT NULL);
135
136 -- ******************************************************************
137 -- Procedure
138 -- Func_Succ
139 -- Purpose
140 -- This prodcedure is used to write
141 -- the symbol '<< ' to indicate leaving function with successful completion
142 -- func_name (passed as parameter to the procedure)
143 -- system date and time ('HH24:MI:SS') to the Log file.
144 -- History
145 -- 10-04-2001 Srini Pala Created
146 -- Arguments
147 -- func_name Name of the leaving function
148 -- Example
149 -- FII_MESSAGE.Func_succ('Fii_Message')
150 --
151
152 PROCEDURE Func_Succ(func_name VARCHAR2);
153
154 -- ******************************************************************
155
156 -- Procedure
157 -- Func_Fail
158 -- Purpose
159 -- This prodcedure is used to write
160 -- the symbol '<x ' to indicate leaving function wnen it fails
161 -- func_name ( passed as parameter to the procedure)
162 -- system date and time ('HH24:MI:SS') to the Log file.
163 -- History
164 -- 10-04-2001 Srini Pala Created
165 -- Arguments
166 -- func_name Name of the leaving function
167 -- Example
168 -- FII_MESSAGE.Func_Fail('Fii_Message')
169
170
171 PROCEDURE Func_Fail(func_name VARCHAR2);
172
173 -- ******************************************************************
174
175 -- Procedure
176 -- Func_Ent
177 -- Purpose
178 -- This prodcedure is used to writes
179 -- the symbol '>> ' to indicate entering a function
180 -- func_name, passed as parameter to the procedure
181 -- system date and time ('HH24:MI:SS' ) to the Log file.
182 -- History
183 -- 10-04-2001 Srini Pala Created
184 -- Arguments
185 -- func_name Name of the leaving function
186 -- Example
187 -- FII_MESSAGE.Func_Ent('Fii_Message')
188 --
189
190 PROCEDURE Func_Ent(func_name VARCHAR2);
191
192 -- ******************************************************************
193
194
195 -- Procedure
196 -- Write_Output
197 -- Purpose
198 -- This prodcedure is similar to Write_Log () but used to write
199 -- meesage name and actual message (with token values) to a Output file.
200 -- History
201 -- 02-27-2002 Srini Pala Created
202 -- Arguments
203 -- msg_name Name of the message
204 -- token_num Number of tokens exist in the message
205 -- t1 Name of the first token
206 -- v1 Value of the first token
207 -- t2 Name of the second token
208 -- v2 Value of the second token
209 -- t3 Name of the third token
210 -- v3 Value of the third token
211 -- t4 Name of the fourth token
212 -- v4 Value of the fourth token
213 -- t5 Name of the fifth token
214 -- v5 Value of the fifth token
215
216 -- Example
217 -- FII_MESSAGE.Write_Output('SHRD0117',2,''NUM','10','TABLE','GL_BALANCES')
218 --
219
220
221 PROCEDURE Write_Output(msg_name VARCHAR2,
222 token_num NUMBER DEFAULT 0,
223 t1 VARCHAR2 DEFAULT NULL,
224 v1 VARCHAR2 DEFAULT NULL,
225 t2 VARCHAR2 DEFAULT NULL,
226 v2 VARCHAR2 DEFAULT NULL,
227 t3 VARCHAR2 DEFAULT NULL,
228 v3 VARCHAR2 DEFAULT NULL,
229 t4 VARCHAR2 DEFAULT NULL,
230 v4 VARCHAR2 DEFAULT NULL,
231 t5 VARCHAR2 DEFAULT NULL,
232 v5 VARCHAR2 DEFAULT NULL);
233
234 -- ******************************************************************
235
236 END Fii_Message;
237