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_SA_HIJRAH_FUNCTIONS dependencies on HR_UTILITY

Line 27: -- hr_utility.trace_on(null,'SADTCNV');

23: l_hij_day number := 0;
24: l_date varchar2(10);
25: l_input_date varchar2(10);
26: begin
27: -- hr_utility.trace_on(null,'SADTCNV');
28: hr_utility.set_location('In side hijrah_to_gregorian',1);
29: hr_utility.set_location('p_input_date '|| p_input_date,1);
30: if p_input_date is not null then
31: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);

Line 28: hr_utility.set_location('In side hijrah_to_gregorian',1);

24: l_date varchar2(10);
25: l_input_date varchar2(10);
26: begin
27: -- hr_utility.trace_on(null,'SADTCNV');
28: hr_utility.set_location('In side hijrah_to_gregorian',1);
29: hr_utility.set_location('p_input_date '|| p_input_date,1);
30: if p_input_date is not null then
31: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
32: /*l_hij_year := to_number(substr(l_input_date,1,4)) - 1;

Line 29: hr_utility.set_location('p_input_date '|| p_input_date,1);

25: l_input_date varchar2(10);
26: begin
27: -- hr_utility.trace_on(null,'SADTCNV');
28: hr_utility.set_location('In side hijrah_to_gregorian',1);
29: hr_utility.set_location('p_input_date '|| p_input_date,1);
30: if p_input_date is not null then
31: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
32: /*l_hij_year := to_number(substr(l_input_date,1,4)) - 1;
33: l_hij_month := to_number(substr(l_input_date,6,2)) - 1;

Line 39: hr_utility.set_location('l_input_date '|| l_input_date,2);

35: l_hij_year := to_number(substr(l_input_date,1,4)) ;
36: l_hij_month := to_number(substr(l_input_date,6,2)) ;
37: l_hij_day := to_number(substr(l_input_date,9,2)) ;
38: l_input_date := l_hij_year ||'/'||l_hij_month||'/'||l_hij_day;
39: hr_utility.set_location('l_input_date '|| l_input_date,2);
40: select to_char /* Bug No : 6823109 */
41: (
42: to_date
43: ( l_input_date,'YYYY/MM/DD','NLS_CALENDAR=''ENGLISH HIJRAH'''

Line 49: hr_utility.set_location('l_date '|| l_date,3);

45: ,'YYYY/MM/DD'
46: )
47: into l_date
48: from dual;
49: hr_utility.set_location('l_date '|| l_date,3);
50: -- hr_utility.trace_off;
51: /*
52: l_cnt1 := floor(l_hij_year * 354.36887);
53: l_cnt2 := floor(l_hij_month * 29.5305);

Line 50: -- hr_utility.trace_off;

46: )
47: into l_date
48: from dual;
49: hr_utility.set_location('l_date '|| l_date,3);
50: -- hr_utility.trace_off;
51: /*
52: l_cnt1 := floor(l_hij_year * 354.36887);
53: l_cnt2 := floor(l_hij_month * 29.5305);
54: l_days_elapsed := 227011 + l_cnt1 + l_cnt2 + l_hij_day;

Line 101: -- hr_utility.trace_on(null,'SADTCNV');

97: l_input_date varchar2(10);
98: begin
99: if p_input_date is not null then
100: l_input_date := to_char (p_input_date,'RRRR-MM-DD');
101: -- hr_utility.trace_on(null,'SADTCNV');
102: hr_utility.set_location('In side gregorian_to_hijrah',1);
103: hr_utility.set_location('p_input_date '|| p_input_date,1);
104: /* l_year := to_number(substr(l_input_date,1,4)) - 1;
105: l_month := to_number(substr(l_input_date,6,2)) - 1;

Line 102: hr_utility.set_location('In side gregorian_to_hijrah',1);

98: begin
99: if p_input_date is not null then
100: l_input_date := to_char (p_input_date,'RRRR-MM-DD');
101: -- hr_utility.trace_on(null,'SADTCNV');
102: hr_utility.set_location('In side gregorian_to_hijrah',1);
103: hr_utility.set_location('p_input_date '|| p_input_date,1);
104: /* l_year := to_number(substr(l_input_date,1,4)) - 1;
105: l_month := to_number(substr(l_input_date,6,2)) - 1;
106: l_day := to_number(substr(l_input_date,9,2));

Line 103: hr_utility.set_location('p_input_date '|| p_input_date,1);

99: if p_input_date is not null then
100: l_input_date := to_char (p_input_date,'RRRR-MM-DD');
101: -- hr_utility.trace_on(null,'SADTCNV');
102: hr_utility.set_location('In side gregorian_to_hijrah',1);
103: hr_utility.set_location('p_input_date '|| p_input_date,1);
104: /* l_year := to_number(substr(l_input_date,1,4)) - 1;
105: l_month := to_number(substr(l_input_date,6,2)) - 1;
106: l_day := to_number(substr(l_input_date,9,2));
107: l_fourtons := floor(l_year/400);

Line 142: hr_utility.set_location('l_hij_date '|| l_hij_date,2);

138: ,'YYYY/MM/DD','NLS_CALENDAR=''ENGLISH HIJRAH'''
139: )
140: into l_hij_date
141: from dual ;
142: hr_utility.set_location('l_hij_date '|| l_hij_date,2);
143: -- hr_utility.trace_off;
144: return (l_hij_date);
145: else
146: return null;

Line 143: -- hr_utility.trace_off;

139: )
140: into l_hij_date
141: from dual ;
142: hr_utility.set_location('l_hij_date '|| l_hij_date,2);
143: -- hr_utility.trace_off;
144: return (l_hij_date);
145: else
146: return null;
147: end if;

Line 270: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

266: end if;
267: if(l_error = 1) then
268: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
269: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
270: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
271: hr_utility.set_message_token('FIELD',l_field);
272: hr_utility.set_message_token('RANGE',l_range);
273: hr_utility.raise_error;
274: end if;

Line 271: hr_utility.set_message_token('FIELD',l_field);

267: if(l_error = 1) then
268: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
269: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
270: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
271: hr_utility.set_message_token('FIELD',l_field);
272: hr_utility.set_message_token('RANGE',l_range);
273: hr_utility.raise_error;
274: end if;
275: l_year := to_number(substr(l_date_in,0,l_position1-1));

Line 272: hr_utility.set_message_token('RANGE',l_range);

268: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
269: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
270: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
271: hr_utility.set_message_token('FIELD',l_field);
272: hr_utility.set_message_token('RANGE',l_range);
273: hr_utility.raise_error;
274: end if;
275: l_year := to_number(substr(l_date_in,0,l_position1-1));
276: l_month := to_number(substr(l_date_in,l_position1+1,l_position2-l_position1-1));

Line 273: hr_utility.raise_error;

269: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
270: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
271: hr_utility.set_message_token('FIELD',l_field);
272: hr_utility.set_message_token('RANGE',l_range);
273: hr_utility.raise_error;
274: end if;
275: l_year := to_number(substr(l_date_in,0,l_position1-1));
276: l_month := to_number(substr(l_date_in,l_position1+1,l_position2-l_position1-1));
277: l_day := to_number(substr(l_date_in,l_position2+1,l_length-l_position2));

Line 283: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

279: if(l_year<=0 or l_year >4089) then --check if year/month/day is negative
280: l_flag := 1;
281: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
282: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
283: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
284: hr_utility.set_message_token('FIELD',l_field);
285: hr_utility.set_message_token('RANGE',l_range);
286: hr_utility.raise_error;
287: end if;

Line 284: hr_utility.set_message_token('FIELD',l_field);

280: l_flag := 1;
281: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
282: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
283: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
284: hr_utility.set_message_token('FIELD',l_field);
285: hr_utility.set_message_token('RANGE',l_range);
286: hr_utility.raise_error;
287: end if;
288: if(l_month <= 0 or l_month> 12)then

Line 285: hr_utility.set_message_token('RANGE',l_range);

281: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
282: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
283: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
284: hr_utility.set_message_token('FIELD',l_field);
285: hr_utility.set_message_token('RANGE',l_range);
286: hr_utility.raise_error;
287: end if;
288: if(l_month <= 0 or l_month> 12)then
289: l_flag := 2;

Line 286: hr_utility.raise_error;

282: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
283: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
284: hr_utility.set_message_token('FIELD',l_field);
285: hr_utility.set_message_token('RANGE',l_range);
286: hr_utility.raise_error;
287: end if;
288: if(l_month <= 0 or l_month> 12)then
289: l_flag := 2;
290: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');

Line 292: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

288: if(l_month <= 0 or l_month> 12)then
289: l_flag := 2;
290: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
291: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
292: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
293: hr_utility.set_message_token('FIELD',l_field);
294: hr_utility.set_message_token('RANGE',l_range);
295: hr_utility.raise_error;
296: end if;

Line 293: hr_utility.set_message_token('FIELD',l_field);

289: l_flag := 2;
290: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
291: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
292: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
293: hr_utility.set_message_token('FIELD',l_field);
294: hr_utility.set_message_token('RANGE',l_range);
295: hr_utility.raise_error;
296: end if;
297: if(l_day <= 0 or l_day >30)then

Line 294: hr_utility.set_message_token('RANGE',l_range);

290: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
291: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
292: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
293: hr_utility.set_message_token('FIELD',l_field);
294: hr_utility.set_message_token('RANGE',l_range);
295: hr_utility.raise_error;
296: end if;
297: if(l_day <= 0 or l_day >30)then
298: l_flag := 3;

Line 295: hr_utility.raise_error;

291: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
292: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
293: hr_utility.set_message_token('FIELD',l_field);
294: hr_utility.set_message_token('RANGE',l_range);
295: hr_utility.raise_error;
296: end if;
297: if(l_day <= 0 or l_day >30)then
298: l_flag := 3;
299: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');

Line 301: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

297: if(l_day <= 0 or l_day >30)then
298: l_flag := 3;
299: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
300: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
301: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
302: hr_utility.set_message_token('FIELD',l_field);
303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: end if;

Line 302: hr_utility.set_message_token('FIELD',l_field);

298: l_flag := 3;
299: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
300: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
301: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
302: hr_utility.set_message_token('FIELD',l_field);
303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: end if;
306: if(l_year < 1000) then

Line 303: hr_utility.set_message_token('RANGE',l_range);

299: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
300: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
301: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
302: hr_utility.set_message_token('FIELD',l_field);
303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: end if;
306: if(l_year < 1000) then
307: l_year_date := lpad(to_char(l_year),4,'0');

Line 304: hr_utility.raise_error;

300: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
301: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
302: hr_utility.set_message_token('FIELD',l_field);
303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: end if;
306: if(l_year < 1000) then
307: l_year_date := lpad(to_char(l_year),4,'0');
308: else

Line 330: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

326: then
327: if l_flag = 0 then
328: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
329: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
330: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
331: hr_utility.set_message_token('FIELD',l_field);
332: hr_utility.set_message_token('RANGE',l_range);
333: hr_utility.raise_error;
334: elsif l_flag = 1 then

Line 331: hr_utility.set_message_token('FIELD',l_field);

327: if l_flag = 0 then
328: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
329: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
330: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
331: hr_utility.set_message_token('FIELD',l_field);
332: hr_utility.set_message_token('RANGE',l_range);
333: hr_utility.raise_error;
334: elsif l_flag = 1 then
335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');

Line 332: hr_utility.set_message_token('RANGE',l_range);

328: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
329: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
330: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
331: hr_utility.set_message_token('FIELD',l_field);
332: hr_utility.set_message_token('RANGE',l_range);
333: hr_utility.raise_error;
334: elsif l_flag = 1 then
335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');

Line 333: hr_utility.raise_error;

329: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');
330: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
331: hr_utility.set_message_token('FIELD',l_field);
332: hr_utility.set_message_token('RANGE',l_range);
333: hr_utility.raise_error;
334: elsif l_flag = 1 then
335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

Line 337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

333: hr_utility.raise_error;
334: elsif l_flag = 1 then
335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);
340: hr_utility.raise_error;
341: elsif l_flag = 2 then

Line 338: hr_utility.set_message_token('FIELD',l_field);

334: elsif l_flag = 1 then
335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);
340: hr_utility.raise_error;
341: elsif l_flag = 2 then
342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');

Line 339: hr_utility.set_message_token('RANGE',l_range);

335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');
336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);
340: hr_utility.raise_error;
341: elsif l_flag = 2 then
342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');

Line 340: hr_utility.raise_error;

336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');
337: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);
340: hr_utility.raise_error;
341: elsif l_flag = 2 then
342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

Line 344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

340: hr_utility.raise_error;
341: elsif l_flag = 2 then
342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);
347: hr_utility.raise_error;
348: elsif l_flag = 3 then

Line 345: hr_utility.set_message_token('FIELD',l_field);

341: elsif l_flag = 2 then
342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);
347: hr_utility.raise_error;
348: elsif l_flag = 3 then
349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');

Line 346: hr_utility.set_message_token('RANGE',l_range);

342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');
343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);
347: hr_utility.raise_error;
348: elsif l_flag = 3 then
349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');

Line 347: hr_utility.raise_error;

343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');
344: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);
347: hr_utility.raise_error;
348: elsif l_flag = 3 then
349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

Line 351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');

347: hr_utility.raise_error;
348: elsif l_flag = 3 then
349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);
354: hr_utility.raise_error;
355: end if;

Line 352: hr_utility.set_message_token('FIELD',l_field);

348: elsif l_flag = 3 then
349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);
354: hr_utility.raise_error;
355: end if;
356:

Line 353: hr_utility.set_message_token('RANGE',l_range);

349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');
350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);
354: hr_utility.raise_error;
355: end if;
356:
357: end validate_date;

Line 354: hr_utility.raise_error;

350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');
351: hr_utility.set_message(800, 'HR_374809_SA_INVALID_DATE');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);
354: hr_utility.raise_error;
355: end if;
356:
357: end validate_date;
358: