DBA Data[Home] [Help]

APPS.HR_GCC_HIJRAH_FUNCTIONS dependencies on HR_UTILITY

Line 234: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
238: end if;

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

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;
238: end if;
239: l_year := to_number(substr(l_date_in,0,l_position1-1));

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

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;
238: end if;
239: l_year := to_number(substr(l_date_in,0,l_position1-1));
240: l_month := to_number(substr(l_date_in,l_position1+1,l_position2-l_position1-1));

Line 237: hr_utility.raise_error;

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;
238: end if;
239: l_year := to_number(substr(l_date_in,0,l_position1-1));
240: l_month := to_number(substr(l_date_in,l_position1+1,l_position2-l_position1-1));
241: l_day := to_number(substr(l_date_in,l_position2+1,l_length-l_position2));

Line 247: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
251: end if;

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

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;
251: end if;
252: if(l_month <= 0 or l_month> 12)then

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

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;
251: end if;
252: if(l_month <= 0 or l_month> 12)then
253: l_flag := 2;

Line 250: hr_utility.raise_error;

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

Line 256: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
260: end if;

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

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;
260: end if;
261: if(l_day <= 0 or l_day >30)then

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

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;
260: end if;
261: if(l_day <= 0 or l_day >30)then
262: l_flag := 3;

Line 259: hr_utility.raise_error;

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

Line 265: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
269: end if;

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

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;
269: end if;
270: if(l_year < 1000) then

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

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;
269: end if;
270: if(l_year < 1000) then
271: l_year_date := lpad(to_char(l_year),4,'0');

Line 268: hr_utility.raise_error;

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;
269: end if;
270: if(l_year < 1000) then
271: l_year_date := lpad(to_char(l_year),4,'0');
272: else

Line 294: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
298: elsif l_flag = 1 then

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

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;
298: elsif l_flag = 1 then
299: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_YEAR');

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

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

Line 297: hr_utility.raise_error;

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

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

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;
305: elsif l_flag = 2 then

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

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;
305: elsif l_flag = 2 then
306: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_MONTH');

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

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

Line 304: hr_utility.raise_error;

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

Line 308: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
312: elsif l_flag = 3 then

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

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;
312: elsif l_flag = 3 then
313: l_field := hr_general.decode_lookup('KW_FORM_LABELS','HIJRAH_DATE');

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

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

Line 311: hr_utility.raise_error;

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

Line 315: hr_utility.set_message(800, 'HR_375412_KW_INVALID_DATE');

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;
319: end if;

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

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;
319: end if;
320:

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

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;
319: end if;
320:
321: end validate_date;

Line 318: hr_utility.raise_error;

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;
319: end if;
320:
321: end validate_date;
322: