eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.HR_DBCHKFMT dependencies on HR_UTILITY

Line 20: hr_utility.set_location ('Entering:'||l_proc,5);

16: p_result out nocopy boolean) is
17: l_upper_str varchar2(60) := upper(p_str);
18: l_proc varchar2(72) := g_package || 'is_upper';
19: begin
20: hr_utility.set_location ('Entering:'||l_proc,5);
21: if (l_upper_str = p_str) then
22: hr_utility.set_location (l_proc,10);
23: p_result:= TRUE;
24: else

Line 22: hr_utility.set_location (l_proc,10);

18: l_proc varchar2(72) := g_package || 'is_upper';
19: begin
20: hr_utility.set_location ('Entering:'||l_proc,5);
21: if (l_upper_str = p_str) then
22: hr_utility.set_location (l_proc,10);
23: p_result:= TRUE;
24: else
25: hr_utility.set_location(l_proc,15);
26: p_result := FALSE;

Line 25: hr_utility.set_location(l_proc,15);

21: if (l_upper_str = p_str) then
22: hr_utility.set_location (l_proc,10);
23: p_result:= TRUE;
24: else
25: hr_utility.set_location(l_proc,15);
26: p_result := FALSE;
27: end if;
28: end is_upper;
29: ----------------------- is _lower -------------------------------------

Line 38: hr_utility.set_location ('Entering:'||l_proc,5);

34: p_result out nocopy boolean) is
35: l_lower_str varchar2(80) ;
36: l_proc varchar2(72) := g_package ||'is_lower';
37: begin
38: hr_utility.set_location ('Entering:'||l_proc,5);
39: l_lower_str := lower(p_str);
40: if (l_lower_str = p_str) then
41: hr_utility.set_location (l_proc,10);
42: p_result := TRUE;

Line 41: hr_utility.set_location (l_proc,10);

37: begin
38: hr_utility.set_location ('Entering:'||l_proc,5);
39: l_lower_str := lower(p_str);
40: if (l_lower_str = p_str) then
41: hr_utility.set_location (l_proc,10);
42: p_result := TRUE;
43: else
44: hr_utility.set_location (l_proc,15);
45: p_result := FALSE;

Line 44: hr_utility.set_location (l_proc,15);

40: if (l_lower_str = p_str) then
41: hr_utility.set_location (l_proc,10);
42: p_result := TRUE;
43: else
44: hr_utility.set_location (l_proc,15);
45: p_result := FALSE;
46: end if;
47: end is_lower;
48: -------------------------- is_initcap ----------------------------------

Line 57: hr_utility.set_location ('Entering:'||l_proc,5);

53: p_result out nocopy boolean) is
54: l_initcap_str varchar2(50) ;
55: l_proc varchar2(72) := g_package || 'is_initcap';
56: begin
57: hr_utility.set_location ('Entering:'||l_proc,5);
58: l_initcap_str := initcap(p_str);
59: if (l_initcap_str = p_str) then
60: hr_utility.set_location (l_proc,10);
61: p_result:= TRUE;

Line 60: hr_utility.set_location (l_proc,10);

56: begin
57: hr_utility.set_location ('Entering:'||l_proc,5);
58: l_initcap_str := initcap(p_str);
59: if (l_initcap_str = p_str) then
60: hr_utility.set_location (l_proc,10);
61: p_result:= TRUE;
62: else
63: hr_utility.set_location (l_proc,15);
64: p_result:= FALSE;

Line 63: hr_utility.set_location (l_proc,15);

59: if (l_initcap_str = p_str) then
60: hr_utility.set_location (l_proc,10);
61: p_result:= TRUE;
62: else
63: hr_utility.set_location (l_proc,15);
64: p_result:= FALSE;
65: end if;
66: end is_initcap;
67: --

Line 145: hr_utility.set_location ('Entering:'||l_proc,5);

141: l_NUMERIC constant varchar2(10) := '0123456789';
142: l_SPECIAL constant varchar2(2) := '_';
143: l_LEGCHAR constant varchar2(1) := 'A'; -- the legal character.
144: begin
145: hr_utility.set_location ('Entering:'||l_proc,5);
146: -- build up list of legal characters for first character.
147: l_legal := l_ALPHA;
148: -- now do a translate on the first character of value.
149: l_result := translate(substr(p_value,1,1),l_legal,l_LEGCHAR);

Line 151: hr_utility.set_location (l_proc,10);

147: l_legal := l_ALPHA;
148: -- now do a translate on the first character of value.
149: l_result := translate(substr(p_value,1,1),l_legal,l_LEGCHAR);
150: if(nvl(l_result,l_LEGCHAR) <> l_LEGCHAR) then
151: hr_utility.set_location (l_proc,10);
152: p_result :=FALSE;
153: end if;
154: -- if string is longer than one character,
155: -- check the full legal list.

Line 163: hr_utility.set_location (l_proc,15);

159: l_result := translate(substr(p_value,2),l_legal,l_match);
160: l_result := replace(l_result,l_LEGCHAR,'');
161: -- if all characters were legal, expect result to be null.
162: if(l_result is not null) then
163: hr_utility.set_location (l_proc,15);
164: p_result := FALSE;
165: end if;
166: end if;
167: hr_utility.set_location ('Leaving'||l_proc,20);

Line 167: hr_utility.set_location ('Leaving'||l_proc,20);

163: hr_utility.set_location (l_proc,15);
164: p_result := FALSE;
165: end if;
166: end if;
167: hr_utility.set_location ('Leaving'||l_proc,20);
168: p_result := TRUE;
169: exception
170: when others then
171: p_result := FALSE;

Line 199: hr_utility.set_location ('Entering:'||l_proc,5);

195: l_NUMERIC constant varchar(10) := '0123456789';
196: l_SPECIAL constant varchar(8) := '*&,-.$_ ';
197: l_LEGCHAR constant varchar(1) := '*';
198: begin
199: hr_utility.set_location ('Entering:'||l_proc,5);
200: -- convert any alpha characters to upper case.
201: l_value:=p_value;
202: l_value := nls_upper(l_value);
203: -- build up list of legal characters for first character.

Line 209: hr_utility.set_location (l_proc,10);

205: -- now do a translate on the first character of value.
206: l_trres := translate(substr(l_value,1,1),l_legal,l_LEGCHAR);
207: if(nvl(l_trres,l_LEGCHAR) <> l_LEGCHAR) then
208: p_result := FALSE;
209: hr_utility.set_location (l_proc,10);
210: return;
211: end if;
212: -- if string is longer than one character,
213: -- check the full legal list.

Line 222: hr_utility.set_location (l_proc,15);

218: l_trres := replace(l_trres,l_LEGCHAR,'');
219: -- if all characters in value are legal, trres should be null.
220: if(l_trres is not null) then
221: p_result := FALSE;
222: hr_utility.set_location (l_proc,15);
223: return;
224: end if;
225: end if;
226: hr_utility.set_location ('LEAVING ' || l_proc, 20);

Line 226: hr_utility.set_location ('LEAVING ' || l_proc, 20);

222: hr_utility.set_location (l_proc,15);
223: return;
224: end if;
225: end if;
226: hr_utility.set_location ('LEAVING ' || l_proc, 20);
227: exception
228: when others then
229: p_result := FALSE;
230: end dbchknacha;

Line 256: hr_utility.set_location ('Entering:'||l_proc,5);

252: l_NUMERIC constant varchar(10) := '0123456789';
253: l_SPECIAL constant varchar(2) := ' _';
254: l_LEGCHAR constant varchar(1) := 'A';
255: begin
256: hr_utility.set_location ('Entering:'||l_proc,5);
257: -- build up list of legal characters for first character.
258: l_legal := l_ALPHA;
259: -- now do a translate on the first character of value.
260: l_result := translate(substr(p_value,1,1),l_legal,l_LEGCHAR);

Line 262: hr_utility.set_location (l_proc,10);

258: l_legal := l_ALPHA;
259: -- now do a translate on the first character of value.
260: l_result := translate(substr(p_value,1,1),l_legal,l_LEGCHAR);
261: if(nvl(l_result,l_LEGCHAR) <> l_LEGCHAR) then
262: hr_utility.set_location (l_proc,10);
263: p_result := FALSE;
264: end if;
265: -- if string is longer than one character,
266: -- check the full legal list.

Line 275: hr_utility.set_location (l_proc,15);

271: l_result := translate(substr(p_value,2),l_legal,l_LEGCHAR);
272: l_result := replace(l_result,l_LEGCHAR,'');
273: -- if string contains legal characters, result should be null.
274: if(l_result is not null) then
275: hr_utility.set_location (l_proc,15);
276: p_result := FALSE;
277: end if;
278: end if;
279: hr_utility.set_location ('Leaving:'||l_proc,20);

Line 279: hr_utility.set_location ('Leaving:'||l_proc,20);

275: hr_utility.set_location (l_proc,15);
276: p_result := FALSE;
277: end if;
278: end if;
279: hr_utility.set_location ('Leaving:'||l_proc,20);
280: p_result:= TRUE;
281: exception
282: when others then
283: p_result := FALSE;

Line 291: hr_utility.set_location ('Entering:'||l_proc,5);

287: -- This is the main body of the is_db_format
288: --
289: ------------------------------------------------------------------------
290: begin
291: hr_utility.set_location ('Entering:'||l_proc,5);
292: hr_api.mandatory_arg_error(l_proc,p_arg_name,p_value);
293: l_result:= TRUE;
294: l_value := p_value;
295: -- Choose correct action for format specifier.

Line 299: hr_utility.set_message (801, 'HR_7909_CHECK_FMT_UPPER');

295: -- Choose correct action for format specifier.
296: if(p_format = 'UPPER') then
297: is_upper(p_value,l_result);
298: if(l_result = FALSE) then
299: hr_utility.set_message (801, 'HR_7909_CHECK_FMT_UPPER');
300: hr_utility.set_message_token('ARG_NAME', p_arg_name);
301: hr_utility.set_message_token('ARG_VALUE', p_value);
302: hr_utility.raise_error;
303: end if;

Line 300: hr_utility.set_message_token('ARG_NAME', p_arg_name);

296: if(p_format = 'UPPER') then
297: is_upper(p_value,l_result);
298: if(l_result = FALSE) then
299: hr_utility.set_message (801, 'HR_7909_CHECK_FMT_UPPER');
300: hr_utility.set_message_token('ARG_NAME', p_arg_name);
301: hr_utility.set_message_token('ARG_VALUE', p_value);
302: hr_utility.raise_error;
303: end if;
304: elsif(p_format = 'LOWER' ) then

Line 301: hr_utility.set_message_token('ARG_VALUE', p_value);

297: is_upper(p_value,l_result);
298: if(l_result = FALSE) then
299: hr_utility.set_message (801, 'HR_7909_CHECK_FMT_UPPER');
300: hr_utility.set_message_token('ARG_NAME', p_arg_name);
301: hr_utility.set_message_token('ARG_VALUE', p_value);
302: hr_utility.raise_error;
303: end if;
304: elsif(p_format = 'LOWER' ) then
305: is_lower(p_value,l_result);

Line 302: hr_utility.raise_error;

298: if(l_result = FALSE) then
299: hr_utility.set_message (801, 'HR_7909_CHECK_FMT_UPPER');
300: hr_utility.set_message_token('ARG_NAME', p_arg_name);
301: hr_utility.set_message_token('ARG_VALUE', p_value);
302: hr_utility.raise_error;
303: end if;
304: elsif(p_format = 'LOWER' ) then
305: is_lower(p_value,l_result);
306: if(l_result = FALSE ) then

Line 307: hr_utility.set_message (801, 'HR_7910_CHECK_FMT_LOWER');

303: end if;
304: elsif(p_format = 'LOWER' ) then
305: is_lower(p_value,l_result);
306: if(l_result = FALSE ) then
307: hr_utility.set_message (801, 'HR_7910_CHECK_FMT_LOWER');
308: hr_utility.set_message_token('ARG_NAME', p_arg_name);
309: hr_utility.set_message_token('ARG_VALUE', p_value);
310: hr_utility.raise_error;
311: end if;

Line 308: hr_utility.set_message_token('ARG_NAME', p_arg_name);

304: elsif(p_format = 'LOWER' ) then
305: is_lower(p_value,l_result);
306: if(l_result = FALSE ) then
307: hr_utility.set_message (801, 'HR_7910_CHECK_FMT_LOWER');
308: hr_utility.set_message_token('ARG_NAME', p_arg_name);
309: hr_utility.set_message_token('ARG_VALUE', p_value);
310: hr_utility.raise_error;
311: end if;
312: elsif(p_format = 'INITCAP' ) then

Line 309: hr_utility.set_message_token('ARG_VALUE', p_value);

305: is_lower(p_value,l_result);
306: if(l_result = FALSE ) then
307: hr_utility.set_message (801, 'HR_7910_CHECK_FMT_LOWER');
308: hr_utility.set_message_token('ARG_NAME', p_arg_name);
309: hr_utility.set_message_token('ARG_VALUE', p_value);
310: hr_utility.raise_error;
311: end if;
312: elsif(p_format = 'INITCAP' ) then
313: is_initcap(p_value,l_result);

Line 310: hr_utility.raise_error;

306: if(l_result = FALSE ) then
307: hr_utility.set_message (801, 'HR_7910_CHECK_FMT_LOWER');
308: hr_utility.set_message_token('ARG_NAME', p_arg_name);
309: hr_utility.set_message_token('ARG_VALUE', p_value);
310: hr_utility.raise_error;
311: end if;
312: elsif(p_format = 'INITCAP' ) then
313: is_initcap(p_value,l_result);
314: if(l_result = FALSE) then

Line 315: hr_utility.set_message (801, 'HR_7911_CHECK_FMT_INITCAP');

311: end if;
312: elsif(p_format = 'INITCAP' ) then
313: is_initcap(p_value,l_result);
314: if(l_result = FALSE) then
315: hr_utility.set_message (801, 'HR_7911_CHECK_FMT_INITCAP');
316: hr_utility.set_message_token('ARG_NAME', p_arg_name);
317: hr_utility.set_message_token('ARG_VALUE', p_value);
318: hr_utility.raise_error;
319: end if;

Line 316: hr_utility.set_message_token('ARG_NAME', p_arg_name);

312: elsif(p_format = 'INITCAP' ) then
313: is_initcap(p_value,l_result);
314: if(l_result = FALSE) then
315: hr_utility.set_message (801, 'HR_7911_CHECK_FMT_INITCAP');
316: hr_utility.set_message_token('ARG_NAME', p_arg_name);
317: hr_utility.set_message_token('ARG_VALUE', p_value);
318: hr_utility.raise_error;
319: end if;
320: elsif(p_format = 'M' or p_format = 'MONEY') then

Line 317: hr_utility.set_message_token('ARG_VALUE', p_value);

313: is_initcap(p_value,l_result);
314: if(l_result = FALSE) then
315: hr_utility.set_message (801, 'HR_7911_CHECK_FMT_INITCAP');
316: hr_utility.set_message_token('ARG_NAME', p_arg_name);
317: hr_utility.set_message_token('ARG_VALUE', p_value);
318: hr_utility.raise_error;
319: end if;
320: elsif(p_format = 'M' or p_format = 'MONEY') then
321: begin

Line 318: hr_utility.raise_error;

314: if(l_result = FALSE) then
315: hr_utility.set_message (801, 'HR_7911_CHECK_FMT_INITCAP');
316: hr_utility.set_message_token('ARG_NAME', p_arg_name);
317: hr_utility.set_message_token('ARG_VALUE', p_value);
318: hr_utility.raise_error;
319: end if;
320: elsif(p_format = 'M' or p_format = 'MONEY') then
321: begin
322: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);

Line 325: hr_utility.set_message(801,'HR_7912_CHECK_FMT_MONEY');

321: begin
322: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
323: exception
324: when others then
325: hr_utility.set_message(801,'HR_7912_CHECK_FMT_MONEY');
326: hr_utility.set_message_token('ARG_NAME', p_arg_name);
327: hr_utility.set_message_token('ARG_VALUE', p_value);
328: hr_utility.raise_error;
329: end;

Line 326: hr_utility.set_message_token('ARG_NAME', p_arg_name);

322: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
323: exception
324: when others then
325: hr_utility.set_message(801,'HR_7912_CHECK_FMT_MONEY');
326: hr_utility.set_message_token('ARG_NAME', p_arg_name);
327: hr_utility.set_message_token('ARG_VALUE', p_value);
328: hr_utility.raise_error;
329: end;
330: elsif(p_format = 'I' or p_format = 'INTEGER' or p_format = 'H_HH'

Line 327: hr_utility.set_message_token('ARG_VALUE', p_value);

323: exception
324: when others then
325: hr_utility.set_message(801,'HR_7912_CHECK_FMT_MONEY');
326: hr_utility.set_message_token('ARG_NAME', p_arg_name);
327: hr_utility.set_message_token('ARG_VALUE', p_value);
328: hr_utility.raise_error;
329: end;
330: elsif(p_format = 'I' or p_format = 'INTEGER' or p_format = 'H_HH'
331: or p_format = 'NUMBER' or p_format = 'ND' or p_format = 'N') then

Line 328: hr_utility.raise_error;

324: when others then
325: hr_utility.set_message(801,'HR_7912_CHECK_FMT_MONEY');
326: hr_utility.set_message_token('ARG_NAME', p_arg_name);
327: hr_utility.set_message_token('ARG_VALUE', p_value);
328: hr_utility.raise_error;
329: end;
330: elsif(p_format = 'I' or p_format = 'INTEGER' or p_format = 'H_HH'
331: or p_format = 'NUMBER' or p_format = 'ND' or p_format = 'N') then
332: begin

Line 336: hr_utility.set_message(801,'HR_7914_CHECK_FMT_NUMBER');

332: begin
333: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
334: exception
335: when others then
336: hr_utility.set_message(801,'HR_7914_CHECK_FMT_NUMBER');
337: hr_utility.set_message_token('ARG_NAME', p_arg_name);
338: hr_utility.set_message_token('ARG_VALUE', p_value);
339: hr_utility.raise_error;
340: end;

Line 337: hr_utility.set_message_token('ARG_NAME', p_arg_name);

333: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
334: exception
335: when others then
336: hr_utility.set_message(801,'HR_7914_CHECK_FMT_NUMBER');
337: hr_utility.set_message_token('ARG_NAME', p_arg_name);
338: hr_utility.set_message_token('ARG_VALUE', p_value);
339: hr_utility.raise_error;
340: end;
341: elsif(p_format = 'TIMES' or p_format = 'T') then

Line 338: hr_utility.set_message_token('ARG_VALUE', p_value);

334: exception
335: when others then
336: hr_utility.set_message(801,'HR_7914_CHECK_FMT_NUMBER');
337: hr_utility.set_message_token('ARG_NAME', p_arg_name);
338: hr_utility.set_message_token('ARG_VALUE', p_value);
339: hr_utility.raise_error;
340: end;
341: elsif(p_format = 'TIMES' or p_format = 'T') then
342: begin

Line 339: hr_utility.raise_error;

335: when others then
336: hr_utility.set_message(801,'HR_7914_CHECK_FMT_NUMBER');
337: hr_utility.set_message_token('ARG_NAME', p_arg_name);
338: hr_utility.set_message_token('ARG_VALUE', p_value);
339: hr_utility.raise_error;
340: end;
341: elsif(p_format = 'TIMES' or p_format = 'T') then
342: begin
343: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);

Line 346: hr_utility.set_message(801,'HR_7916_CHECK_FMT_HHMM');

342: begin
343: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
344: exception
345: when others then
346: hr_utility.set_message(801,'HR_7916_CHECK_FMT_HHMM');
347: hr_utility.set_message_token('ARG_NAME', p_arg_name);
348: hr_utility.set_message_token('ARG_VALUE', p_value);
349: hr_utility.raise_error;
350: end;

Line 347: hr_utility.set_message_token('ARG_NAME', p_arg_name);

343: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
344: exception
345: when others then
346: hr_utility.set_message(801,'HR_7916_CHECK_FMT_HHMM');
347: hr_utility.set_message_token('ARG_NAME', p_arg_name);
348: hr_utility.set_message_token('ARG_VALUE', p_value);
349: hr_utility.raise_error;
350: end;
351: elsif(p_format = 'H_DECIMAL1' or p_format = 'H_DECIMAL2' or p_format = 'H_HHMM' or p_format = 'H_HHMMSS'

Line 348: hr_utility.set_message_token('ARG_VALUE', p_value);

344: exception
345: when others then
346: hr_utility.set_message(801,'HR_7916_CHECK_FMT_HHMM');
347: hr_utility.set_message_token('ARG_NAME', p_arg_name);
348: hr_utility.set_message_token('ARG_VALUE', p_value);
349: hr_utility.raise_error;
350: end;
351: elsif(p_format = 'H_DECIMAL1' or p_format = 'H_DECIMAL2' or p_format = 'H_HHMM' or p_format = 'H_HHMMSS'
352: or p_format = 'H_DECIMAL2' or p_format = 'H_DECIMAL3' or p_format = 'HOURS') then

Line 349: hr_utility.raise_error;

345: when others then
346: hr_utility.set_message(801,'HR_7916_CHECK_FMT_HHMM');
347: hr_utility.set_message_token('ARG_NAME', p_arg_name);
348: hr_utility.set_message_token('ARG_VALUE', p_value);
349: hr_utility.raise_error;
350: end;
351: elsif(p_format = 'H_DECIMAL1' or p_format = 'H_DECIMAL2' or p_format = 'H_HHMM' or p_format = 'H_HHMMSS'
352: or p_format = 'H_DECIMAL2' or p_format = 'H_DECIMAL3' or p_format = 'HOURS') then
353: begin

Line 357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');

353: begin
354: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
355: exception
356: when others then
357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');
358: hr_utility.set_message_token('ARG_NAME', p_arg_name);
359: hr_utility.set_message_token('ARG_VALUE', p_value);
360: hr_utility.set_message_token('DECIMAL_POINT', '1');
361: hr_utility.raise_error;

Line 358: hr_utility.set_message_token('ARG_NAME', p_arg_name);

354: hr_chkfmt.checkformat(l_value, p_format, l_output, NULL, NULL, 'Y', l_rgeflg, p_curcode);
355: exception
356: when others then
357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');
358: hr_utility.set_message_token('ARG_NAME', p_arg_name);
359: hr_utility.set_message_token('ARG_VALUE', p_value);
360: hr_utility.set_message_token('DECIMAL_POINT', '1');
361: hr_utility.raise_error;
362: end;

Line 359: hr_utility.set_message_token('ARG_VALUE', p_value);

355: exception
356: when others then
357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');
358: hr_utility.set_message_token('ARG_NAME', p_arg_name);
359: hr_utility.set_message_token('ARG_VALUE', p_value);
360: hr_utility.set_message_token('DECIMAL_POINT', '1');
361: hr_utility.raise_error;
362: end;
363: elsif(p_format = 'DB_ITEM_NAME') then

Line 360: hr_utility.set_message_token('DECIMAL_POINT', '1');

356: when others then
357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');
358: hr_utility.set_message_token('ARG_NAME', p_arg_name);
359: hr_utility.set_message_token('ARG_VALUE', p_value);
360: hr_utility.set_message_token('DECIMAL_POINT', '1');
361: hr_utility.raise_error;
362: end;
363: elsif(p_format = 'DB_ITEM_NAME') then
364: dbchkdbi(p_value,l_result);

Line 361: hr_utility.raise_error;

357: hr_utility.set_message(801,'HR_7918_CHECK_FMT_HDECIMAL');
358: hr_utility.set_message_token('ARG_NAME', p_arg_name);
359: hr_utility.set_message_token('ARG_VALUE', p_value);
360: hr_utility.set_message_token('DECIMAL_POINT', '1');
361: hr_utility.raise_error;
362: end;
363: elsif(p_format = 'DB_ITEM_NAME') then
364: dbchkdbi(p_value,l_result);
365: if(l_result = FALSE) then

Line 366: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');

362: end;
363: elsif(p_format = 'DB_ITEM_NAME') then
364: dbchkdbi(p_value,l_result);
365: if(l_result = FALSE) then
366: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
367: hr_utility.set_message_token('ARG_NAME', p_arg_name);
368: hr_utility.set_message_token('ARG_VALUE', p_value);
369: hr_utility.raise_error;
370: end if;

Line 367: hr_utility.set_message_token('ARG_NAME', p_arg_name);

363: elsif(p_format = 'DB_ITEM_NAME') then
364: dbchkdbi(p_value,l_result);
365: if(l_result = FALSE) then
366: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
367: hr_utility.set_message_token('ARG_NAME', p_arg_name);
368: hr_utility.set_message_token('ARG_VALUE', p_value);
369: hr_utility.raise_error;
370: end if;
371: elsif(p_format = 'PAY_NAME') then

Line 368: hr_utility.set_message_token('ARG_VALUE', p_value);

364: dbchkdbi(p_value,l_result);
365: if(l_result = FALSE) then
366: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
367: hr_utility.set_message_token('ARG_NAME', p_arg_name);
368: hr_utility.set_message_token('ARG_VALUE', p_value);
369: hr_utility.raise_error;
370: end if;
371: elsif(p_format = 'PAY_NAME') then
372: dbchkpay(p_value,l_result);

Line 369: hr_utility.raise_error;

365: if(l_result = FALSE) then
366: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
367: hr_utility.set_message_token('ARG_NAME', p_arg_name);
368: hr_utility.set_message_token('ARG_VALUE', p_value);
369: hr_utility.raise_error;
370: end if;
371: elsif(p_format = 'PAY_NAME') then
372: dbchkpay(p_value,l_result);
373: if(l_result = FALSE) then

Line 374: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');

370: end if;
371: elsif(p_format = 'PAY_NAME') then
372: dbchkpay(p_value,l_result);
373: if(l_result = FALSE) then
374: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
375: hr_utility.set_message_token('ARG_NAME', p_arg_name);
376: hr_utility.set_message_token('ARG_VALUE', p_value);
377: hr_utility.raise_error;
378: end if;

Line 375: hr_utility.set_message_token('ARG_NAME', p_arg_name);

371: elsif(p_format = 'PAY_NAME') then
372: dbchkpay(p_value,l_result);
373: if(l_result = FALSE) then
374: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
375: hr_utility.set_message_token('ARG_NAME', p_arg_name);
376: hr_utility.set_message_token('ARG_VALUE', p_value);
377: hr_utility.raise_error;
378: end if;
379: elsif(p_format = 'NACHA') then

Line 376: hr_utility.set_message_token('ARG_VALUE', p_value);

372: dbchkpay(p_value,l_result);
373: if(l_result = FALSE) then
374: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
375: hr_utility.set_message_token('ARG_NAME', p_arg_name);
376: hr_utility.set_message_token('ARG_VALUE', p_value);
377: hr_utility.raise_error;
378: end if;
379: elsif(p_format = 'NACHA') then
380: dbchknacha(p_value,l_result); -- check for legal NACHA characters

Line 377: hr_utility.raise_error;

373: if(l_result = FALSE) then
374: hr_utility.set_message(801,'HR_7919_CHECK_FMT_HR_NAME');
375: hr_utility.set_message_token('ARG_NAME', p_arg_name);
376: hr_utility.set_message_token('ARG_VALUE', p_value);
377: hr_utility.raise_error;
378: end if;
379: elsif(p_format = 'NACHA') then
380: dbchknacha(p_value,l_result); -- check for legal NACHA characters
381: if(l_result = FALSE) then

Line 382: hr_utility.set_message(801,'HR_7930_CHECK_FMT_NACHA');

378: end if;
379: elsif(p_format = 'NACHA') then
380: dbchknacha(p_value,l_result); -- check for legal NACHA characters
381: if(l_result = FALSE) then
382: hr_utility.set_message(801,'HR_7930_CHECK_FMT_NACHA');
383: hr_utility.set_message_token('ARG_NAME', p_arg_name);
384: hr_utility.set_message_token('ARG_VALUE', p_value);
385: hr_utility.raise_error;
386: end if;

Line 383: hr_utility.set_message_token('ARG_NAME', p_arg_name);

379: elsif(p_format = 'NACHA') then
380: dbchknacha(p_value,l_result); -- check for legal NACHA characters
381: if(l_result = FALSE) then
382: hr_utility.set_message(801,'HR_7930_CHECK_FMT_NACHA');
383: hr_utility.set_message_token('ARG_NAME', p_arg_name);
384: hr_utility.set_message_token('ARG_VALUE', p_value);
385: hr_utility.raise_error;
386: end if;
387: else

Line 384: hr_utility.set_message_token('ARG_VALUE', p_value);

380: dbchknacha(p_value,l_result); -- check for legal NACHA characters
381: if(l_result = FALSE) then
382: hr_utility.set_message(801,'HR_7930_CHECK_FMT_NACHA');
383: hr_utility.set_message_token('ARG_NAME', p_arg_name);
384: hr_utility.set_message_token('ARG_VALUE', p_value);
385: hr_utility.raise_error;
386: end if;
387: else
388: -- invalid format.

Line 385: hr_utility.raise_error;

381: if(l_result = FALSE) then
382: hr_utility.set_message(801,'HR_7930_CHECK_FMT_NACHA');
383: hr_utility.set_message_token('ARG_NAME', p_arg_name);
384: hr_utility.set_message_token('ARG_VALUE', p_value);
385: hr_utility.raise_error;
386: end if;
387: else
388: -- invalid format.
389: hr_utility.set_message(801,'HR_7944_CHECK_FMT_BAD_FORMAT');

Line 389: hr_utility.set_message(801,'HR_7944_CHECK_FMT_BAD_FORMAT');

385: hr_utility.raise_error;
386: end if;
387: else
388: -- invalid format.
389: hr_utility.set_message(801,'HR_7944_CHECK_FMT_BAD_FORMAT');
390: hr_utility.raise_error;
391: end if;
392: --
393: p_formatted_output := l_output; -- #2734822

Line 390: hr_utility.raise_error;

386: end if;
387: else
388: -- invalid format.
389: hr_utility.set_message(801,'HR_7944_CHECK_FMT_BAD_FORMAT');
390: hr_utility.raise_error;
391: end if;
392: --
393: p_formatted_output := l_output; -- #2734822
394: --

Line 395: hr_utility.set_location ('Leaving:'||l_proc,10);

391: end if;
392: --
393: p_formatted_output := l_output; -- #2734822
394: --
395: hr_utility.set_location ('Leaving:'||l_proc,10);
396: end is_db_format;
397: end hr_dbchkfmt;