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_GENERAL

Line 196: return(hr_general.decode_lookup('SA_HIJRAH_DAYS',l_day));

192: l_greg_date := to_date(hr_sa_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
193: select ltrim(rtrim(to_char(l_greg_date,'D')))
194: into l_day
195: from dual;
196: return(hr_general.decode_lookup('SA_HIJRAH_DAYS',l_day));
197: end get_day;
198:
199: function get_month
200: (p_input_date in varchar2)

Line 208: return(hr_general.decode_lookup('SA_HIJRAH_MONTHS',l_month));

204: l_input_date varchar2(10);
205: begin
206: hr_sa_hijrah_functions.validate_date(p_input_date,l_input_date);
207: l_month := to_number(substr(l_input_date,6,2));
208: return(hr_general.decode_lookup('SA_HIJRAH_MONTHS',l_month));
209: end get_month;
210:
211: function get_weekday
212: (p_input_date in varchar2)

Line 268: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');

264: if( (instr(l_date_in,'/',1,3) <> 0) or (l_position1 = 0) )then
265: l_error :=1;
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);

Line 269: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');

265: l_error :=1;
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;

Line 281: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');

277: l_day := to_number(substr(l_date_in,l_position2+1,l_length-l_position2));
278:
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);

Line 282: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');

278:
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;

Line 290: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');

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');
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);

Line 291: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');

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');
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;

Line 299: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');

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');
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);

Line 300: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');

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');
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;

Line 328: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_DATE');

324: EXCEPTION
325: WHEN OTHERS
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);

Line 329: l_range := hr_general.decode_lookup('SA_FORM_LABELS','INVALID_FORMAT');

325: WHEN OTHERS
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;

Line 335: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_YEAR');

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');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);

Line 336: l_range := hr_general.decode_lookup('SA_FORM_LABELS','YEAR_RANGE');

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');
338: hr_utility.set_message_token('FIELD',l_field);
339: hr_utility.set_message_token('RANGE',l_range);
340: hr_utility.raise_error;

Line 342: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_MONTH');

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');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);

Line 343: l_range := hr_general.decode_lookup('SA_FORM_LABELS','MONTH_RANGE');

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');
345: hr_utility.set_message_token('FIELD',l_field);
346: hr_utility.set_message_token('RANGE',l_range);
347: hr_utility.raise_error;

Line 349: l_field := hr_general.decode_lookup('SA_FORM_LABELS','HIJRAH_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');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);

Line 350: l_range := hr_general.decode_lookup('SA_FORM_LABELS','DATE_RANGE');

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');
352: hr_utility.set_message_token('FIELD',l_field);
353: hr_utility.set_message_token('RANGE',l_range);
354: hr_utility.raise_error;