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_GCC_HIJRAH_FUNCTIONS dependencies on HR_GENERAL

Line 160: return(hr_general.decode_lookup('GCC_HIJRAH_DAYS',l_day));

156: l_greg_date := to_date(hr_gcc_hijrah_functions.hijrah_to_gregorian(l_input_date),'YYYY/MM/DD');
157: select ltrim(rtrim(to_char(l_greg_date,'D')))
158: into l_day
159: from dual;
160: return(hr_general.decode_lookup('GCC_HIJRAH_DAYS',l_day));
161: end get_day;
162:
163: function get_month
164: (p_input_date in varchar2)

Line 172: return(hr_general.decode_lookup('GCC_HIJRAH_MONTHS',l_month));

168: l_input_date varchar2(10);
169: begin
170: hr_gcc_hijrah_functions.validate_date(p_input_date,l_input_date);
171: l_month := to_number(substr(l_input_date,6,2));
172: return(hr_general.decode_lookup('GCC_HIJRAH_MONTHS',l_month));
173: end get_month;
174:
175: function get_weekday
176: (p_input_date in varchar2)

Line 232: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');

228: if( (instr(l_date_in,'/',1,3) <> 0) or (l_position1 = 0) )then
229: l_error :=1;
230: end if;
231: if(l_error = 1) then
232: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
233: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');
234: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
235: hr_utility.set_message_token('FIELD',l_field);
236: hr_utility.set_message_token('RANGE',l_range);

Line 233: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');

229: l_error :=1;
230: end if;
231: if(l_error = 1) then
232: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
233: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');
234: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
235: hr_utility.set_message_token('FIELD',l_field);
236: hr_utility.set_message_token('RANGE',l_range);
237: hr_utility.raise_error;

Line 245: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');

241: l_day := to_number(substr(l_date_in,l_position2+1,l_length-l_position2));
242:
243: if(l_year<=0 or l_year >4089) then --check if year/month/day is negative
244: l_flag := 1;
245: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');
246: l_range := hr_general.decode_lookup('KW_FORM_LABELS','YEAR_RANGE');
247: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
248: hr_utility.set_message_token('FIELD',l_field);
249: hr_utility.set_message_token('RANGE',l_range);

Line 246: l_range := hr_general.decode_lookup('KW_FORM_LABELS','YEAR_RANGE');

242:
243: if(l_year<=0 or l_year >4089) then --check if year/month/day is negative
244: l_flag := 1;
245: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');
246: l_range := hr_general.decode_lookup('KW_FORM_LABELS','YEAR_RANGE');
247: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
248: hr_utility.set_message_token('FIELD',l_field);
249: hr_utility.set_message_token('RANGE',l_range);
250: hr_utility.raise_error;

Line 254: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');

250: hr_utility.raise_error;
251: end if;
252: if(l_month <= 0 or l_month> 12)then
253: l_flag := 2;
254: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');
255: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');
256: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
257: hr_utility.set_message_token('FIELD',l_field);
258: hr_utility.set_message_token('RANGE',l_range);

Line 255: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');

251: end if;
252: if(l_month <= 0 or l_month> 12)then
253: l_flag := 2;
254: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');
255: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');
256: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
257: hr_utility.set_message_token('FIELD',l_field);
258: hr_utility.set_message_token('RANGE',l_range);
259: hr_utility.raise_error;

Line 263: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');

259: hr_utility.raise_error;
260: end if;
261: if(l_day <= 0 or l_day >30)then
262: l_flag := 3;
263: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
264: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');
265: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
266: hr_utility.set_message_token('FIELD',l_field);
267: hr_utility.set_message_token('RANGE',l_range);

Line 264: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');

260: end if;
261: if(l_day <= 0 or l_day >30)then
262: l_flag := 3;
263: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
264: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');
265: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
266: hr_utility.set_message_token('FIELD',l_field);
267: hr_utility.set_message_token('RANGE',l_range);
268: hr_utility.raise_error;

Line 292: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');

288: EXCEPTION
289: WHEN OTHERS
290: then
291: if l_flag = 0 then
292: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
293: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');
294: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
295: hr_utility.set_message_token('FIELD',l_field);
296: hr_utility.set_message_token('RANGE',l_range);

Line 293: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');

289: WHEN OTHERS
290: then
291: if l_flag = 0 then
292: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
293: l_range := hr_general.decode_lookup('KW_FORM_LABELS','INVALID_FORMAT');
294: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
295: hr_utility.set_message_token('FIELD',l_field);
296: hr_utility.set_message_token('RANGE',l_range);
297: hr_utility.raise_error;

Line 299: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');

295: hr_utility.set_message_token('FIELD',l_field);
296: hr_utility.set_message_token('RANGE',l_range);
297: hr_utility.raise_error;
298: elsif l_flag = 1 then
299: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');
300: l_range := hr_general.decode_lookup('KW_FORM_LABELS','YEAR_RANGE');
301: hr_utility.set_message(800, 'HR_375412_KW_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('KW_FORM_LABELS','YEAR_RANGE');

296: hr_utility.set_message_token('RANGE',l_range);
297: hr_utility.raise_error;
298: elsif l_flag = 1 then
299: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');
300: l_range := hr_general.decode_lookup('KW_FORM_LABELS','YEAR_RANGE');
301: hr_utility.set_message(800, 'HR_375412_KW_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 306: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');

302: hr_utility.set_message_token('FIELD',l_field);
303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: elsif l_flag = 2 then
306: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');
307: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');
308: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
309: hr_utility.set_message_token('FIELD',l_field);
310: hr_utility.set_message_token('RANGE',l_range);

Line 307: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');

303: hr_utility.set_message_token('RANGE',l_range);
304: hr_utility.raise_error;
305: elsif l_flag = 2 then
306: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');
307: l_range := hr_general.decode_lookup('KW_FORM_LABELS','MONTH_RANGE');
308: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
309: hr_utility.set_message_token('FIELD',l_field);
310: hr_utility.set_message_token('RANGE',l_range);
311: hr_utility.raise_error;

Line 313: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');

309: hr_utility.set_message_token('FIELD',l_field);
310: hr_utility.set_message_token('RANGE',l_range);
311: hr_utility.raise_error;
312: elsif l_flag = 3 then
313: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
314: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');
315: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
316: hr_utility.set_message_token('FIELD',l_field);
317: hr_utility.set_message_token('RANGE',l_range);

Line 314: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');

310: hr_utility.set_message_token('RANGE',l_range);
311: hr_utility.raise_error;
312: elsif l_flag = 3 then
313: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');
314: l_range := hr_general.decode_lookup('KW_FORM_LABELS','DATE_RANGE');
315: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');
316: hr_utility.set_message_token('FIELD',l_field);
317: hr_utility.set_message_token('RANGE',l_range);
318: hr_utility.raise_error;