[Home] [Help]
PACKAGE: APPS.HR_ERRORS_API
Source
1 package hr_errors_api AUTHID CURRENT_USER as
2 /* $Header: hrerrapi.pkh 115.6 2002/12/05 11:07:36 hjonnala ship $ */
3 --
4 --
5 TYPE ErrorRecType is RECORD
6 (ErrorField varchar2 (30)
7 ,ErrorCode varchar2 (30)
8 ,ErrorMsg varchar2 (32000)
9 ,WarningFlag boolean
10 ,RowNumber number
11 ,EmailId varchar2 (500)
12 ,EmailMsg varchar2(32000)
13 );
14 --
15 TYPE ErrorRecTable is TABLE of ErrorRecType INDEX BY BINARY_INTEGER;
16 --
17 TYPE ErrorTextTable is TABLE of varchar2 (32000) INDEX BY BINARY_INTEGER;
18 --
19 --
20 -- Define global variables
21 --
22 -- error flag
23 g_error boolean := false;
24 --
25 -- pl/sql table containing the errors
26 g_errorTable ErrorRecTable;
27 --
28
29 g_count number := 0;
30 --
31 -- bug 1690449
32 TYPE ErrorRecLocTable is TABLE of NUMBER INDEX BY BINARY_INTEGER;
33 --
34
35 --
36 -- ----------------------------------------------------------------------------
37 -- |--< errorExists >---------------------------------------------------------|
38 -- ----------------------------------------------------------------------------
39 -- {Start Of Comments}
40 --
41 -- Description:
42 --
43 -- Prerequisites:
44 -- none
45 --
46 -- Post Success:
47 --
48 -- Post Failure:
49 -- n/a
50 --
51 -- Access Status:
52 -- Public
53 --
54 -- {End Of Comments}
55 -- ----------------------------------------------------------------------------
56 function errorExists return boolean;
57 --
58 -- ----------------------------------------------------------------------------
59 -- |--< warningExists >-------------------------------------------------------|
60 -- ----------------------------------------------------------------------------
61 -- {Start Of Comments}
62 --
63 -- Description:
64 --
65 -- Prerequisites:
66 -- none
67 --
68 -- Post Success:
69 --
70 -- Post Failure:
71 -- n/a
72 --
73 -- Access Status:
74 -- Public
75 --
76 -- {End Of Comments}
77 -- ----------------------------------------------------------------------------
78 function warningExists return boolean;
79 --
80 -- ----------------------------------------------------------------------------
81 -- |--< fieldLevelErrorsExist >-----------------------------------------------|
82 -- ----------------------------------------------------------------------------
83 -- {Start Of Comments}
84 --
85 -- Description:
86 --
87 -- Prerequisites:
88 -- none
89 --
90 -- Post Success:
91 --
92 -- Post Failure:
93 -- n/a
94 --
95 -- Access Status:
96 -- Public
97 --
98 -- {End Of Comments}
99 -- ---------------------------------------------------------------------------
100 function fieldLevelErrorsExist return boolean;
101 --
102 -- ----------------------------------------------------------------------------
103 -- |--< addErrorToTable >-----------------------------------------------------|
104 -- ----------------------------------------------------------------------------
105 -- {Start Of Comments}
106 --
107 -- Description:
108 --
109 -- Prerequisites:
110 -- none
111 --
112 -- Post Success:
113 --
114 -- Post Failure:
115 -- n/a
116 --
117 -- Access Status:
118 -- Public
119 --
120 -- {End Of Comments}
121 -- ----------------------------------------------------------------------------
122 procedure addErrorToTable(p_errorField varchar2 default null
123 ,p_errorCode varchar2 default null
124 ,p_errorMsg varchar2
125 ,p_warningFlag boolean default false
126 ,p_rowNumber number default null
127 ,p_email_id varchar2 default null
128 ,p_email_msg varchar2 default null
129 );
130 --
131 -- ----------------------------------------------------------------------------
132 -- |--< noOfErrorRecords >----------------------------------------------------|
133 -- ----------------------------------------------------------------------------
134 -- {Start Of Comments}
135 --
136 -- Description:
137 --
138 -- Prerequisites:
139 -- none
140 --
141 -- Post Success:
142 --
143 -- Post Failure:
144 -- n/a
145 --
146 -- Access Status:
147 -- Public
148 --
149 -- {End Of Comments}
150 -- ----------------------------------------------------------------------------
151 function noOfErrorRecords return number;
152 --
153 -- ----------------------------------------------------------------------------
154 -- |--< noOfWarnings >--------------------------------------------------------|
155 -- ----------------------------------------------------------------------------
156 -- {Start Of Comments}
157 --
158 -- Description:
159 --
160 -- Prerequisites:
161 -- none
162 --
163 -- Post Success:
164 --
165 -- Post Failure:
166 -- n/a
167 --
168 -- Access Status:
169 -- Public
170 --
171 -- {End Of Comments}
172 -- ----------------------------------------------------------------------------
173 function noOfWarnings return number;
174 --
175 -- ----------------------------------------------------------------------------
176 -- |--< getPageLevelErrors >--------------------------------------------------|
177 -- ----------------------------------------------------------------------------
178 -- {Start Of Comments}
179 --
180 -- Description:
181 --
182 -- Prerequisites:
183 -- none
184 --
185 -- Post Success:
186 --
187 -- Post Failure:
188 -- n/a
189 --
190 -- Access Status:
191 -- Public
192 --
193 -- {End Of Comments}
194 -- ----------------------------------------------------------------------------
195 function getPageLevelErrors return ErrorRecTable;
196 --
197 -- ----------------------------------------------------------------------------
198 -- |--< getRowLevelErrors >---------------------------------------------------|
199 -- ----------------------------------------------------------------------------
200 -- {Start Of Comments}
201 --
202 -- Description:
203 --
204 -- Prerequisites:
205 -- none
206 --
207 -- Post Success:
208 --
209 -- Post Failure:
210 -- n/a
211 --
212 -- Access Status:
213 -- Public
214 --
215 -- {End Of Comments}
216 -- ----------------------------------------------------------------------------
217 function getRowLevelErrors ( p_row_number varchar2
218 ,p_error_loc OUT NOCOPY ErrorRecLocTable
219 ) return ErrorTextTable;
220 --
221 -- ----------------------------------------------------------------------------
222 -- |--< getFieldLevelErrors >-------------------------------------------------|
223 -- ----------------------------------------------------------------------------
224 -- {Start Of Comments}
225 --
226 -- Description:
227 --
228 -- Prerequisites:
229 -- none
230 --
231 -- Post Success:
232 --
233 -- Post Failure:
234 -- n/a
235 --
236 -- Access Status:
237 -- Public
238 --
239 -- {End Of Comments}
240 -- ----------------------------------------------------------------------------
241 function getFieldLevelErrors(p_field_name varchar2
242 ,p_row_number varchar2 default null
243 ,p_error_loc OUT NOCOPY ErrorRecLocTable
244 ) return ErrorTextTable;
245 --
246 -- ----------------------------------------------------------------------------
247 -- |--< encryptErrorTable >---------------------------------------------------|
248 -- ----------------------------------------------------------------------------
249 -- {Start Of Comments}
250 --
251 -- Description:
252 --
253 -- Prerequisites:
254 -- none
255 --
256 -- Post Success:
257 --
258 -- Post Failure:
259 -- n/a
260 --
261 -- Access Status:
262 -- Public
263 --
264 -- {End Of Comments}
265 -- ----------------------------------------------------------------------------
266 function encryptErrorTable return varchar2;
267 --
268 -- ----------------------------------------------------------------------------
269 -- |--< decryptErrorTable >---------------------------------------------------|
270 -- ----------------------------------------------------------------------------
271 -- {Start Of Comments}
272 --
273 -- Description:
274 --
275 -- Prerequisites:
276 -- none
277 --
278 -- Post Success:
279 --
280 -- Post Failure:
281 -- n/a
282 --
283 -- Access Status:
284 -- Public
285 --
286 -- {End Of Comments}
287 -- ----------------------------------------------------------------------------
288 procedure decryptErrorTable(p_encrypt varchar2);
289 --
290 -- bug 1690449
291 -- ----------------------------------------------------------------------------
292 -- |--< deleteErrorRec >---------------------------------------------------|
293 -- ----------------------------------------------------------------------------
294 -- {Start Of Comments}
295 --
296 -- Description:
297 --
298 -- Prerequisites:
299 -- none
300 --
301 -- Post Success:
302 --
303 -- Post Failure:
304 -- n/a
305 --
306 -- Access Status:
307 -- Public
308 --
309 -- {End Of Comments}
310 -- ----------------------------------------------------------------------------
311 procedure deleteErrorRec(p_error_loc ErrorRecLocTable);
312 --
313 end hr_errors_api;