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.HXT_TIME_CLOCK dependencies on FND_MESSAGE

Line 300: FND_MESSAGE.SET_NAME('HXT','HXT_39400_TIME_POSTED'); -- HXT11

296: RAISE l_rec_hours_sys_err;
297: END IF;
298: ret_code := 0;
299: --HXT11err_buf := 'Successful Completion. Time has posted.';
300: FND_MESSAGE.SET_NAME('HXT','HXT_39400_TIME_POSTED'); -- HXT11
301: err_buf := FND_MESSAGE.GET; -- HXT11
302: FND_MESSAGE.CLEAR; -- HXT11
303:
304: RETURN;

Line 301: err_buf := FND_MESSAGE.GET; -- HXT11

297: END IF;
298: ret_code := 0;
299: --HXT11err_buf := 'Successful Completion. Time has posted.';
300: FND_MESSAGE.SET_NAME('HXT','HXT_39400_TIME_POSTED'); -- HXT11
301: err_buf := FND_MESSAGE.GET; -- HXT11
302: FND_MESSAGE.CLEAR; -- HXT11
303:
304: RETURN;
305: EXCEPTION

Line 302: FND_MESSAGE.CLEAR; -- HXT11

298: ret_code := 0;
299: --HXT11err_buf := 'Successful Completion. Time has posted.';
300: FND_MESSAGE.SET_NAME('HXT','HXT_39400_TIME_POSTED'); -- HXT11
301: err_buf := FND_MESSAGE.GET; -- HXT11
302: FND_MESSAGE.CLEAR; -- HXT11
303:
304: RETURN;
305: EXCEPTION
306: WHEN l_person_id_data_err THEN

Line 309: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

305: EXCEPTION
306: WHEN l_person_id_data_err THEN
307: ret_code := l_retcode;
308: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
309: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
310: err_buf := FND_MESSAGE.GET; -- HXT11
311: FND_MESSAGE.CLEAR; -- HXT11
312:
313: --HXT11l_error_text := 'No Employee was located for Employee Number ' || employee_number;

Line 310: err_buf := FND_MESSAGE.GET; -- HXT11

306: WHEN l_person_id_data_err THEN
307: ret_code := l_retcode;
308: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
309: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
310: err_buf := FND_MESSAGE.GET; -- HXT11
311: FND_MESSAGE.CLEAR; -- HXT11
312:
313: --HXT11l_error_text := 'No Employee was located for Employee Number ' || employee_number;
314: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11

Line 311: FND_MESSAGE.CLEAR; -- HXT11

307: ret_code := l_retcode;
308: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
309: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
310: err_buf := FND_MESSAGE.GET; -- HXT11
311: FND_MESSAGE.CLEAR; -- HXT11
312:
313: --HXT11l_error_text := 'No Employee was located for Employee Number ' || employee_number;
314: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11
315: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

Line 314: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11

310: err_buf := FND_MESSAGE.GET; -- HXT11
311: FND_MESSAGE.CLEAR; -- HXT11
312:
313: --HXT11l_error_text := 'No Employee was located for Employee Number ' || employee_number;
314: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11
315: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
316: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
317: RETURN;
318:

Line 315: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

311: FND_MESSAGE.CLEAR; -- HXT11
312:
313: --HXT11l_error_text := 'No Employee was located for Employee Number ' || employee_number;
314: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11
315: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
316: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
317: RETURN;
318:
319: WHEN l_person_id_sys_err THEN

Line 322: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

318:
319: WHEN l_person_id_sys_err THEN
320: ret_code := l_retcode;
321: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
322: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
323: err_buf := FND_MESSAGE.GET; -- HXT11
324: FND_MESSAGE.CLEAR; -- HXT11
325:
326: --HXT11l_error_text := 'System Error occurred while attempting to access Employee Data.' ||

Line 323: err_buf := FND_MESSAGE.GET; -- HXT11

319: WHEN l_person_id_sys_err THEN
320: ret_code := l_retcode;
321: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
322: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
323: err_buf := FND_MESSAGE.GET; -- HXT11
324: FND_MESSAGE.CLEAR; -- HXT11
325:
326: --HXT11l_error_text := 'System Error occurred while attempting to access Employee Data.' ||
327: --HXT11'Employee Number ' || employee_number ||

Line 324: FND_MESSAGE.CLEAR; -- HXT11

320: ret_code := l_retcode;
321: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
322: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
323: err_buf := FND_MESSAGE.GET; -- HXT11
324: FND_MESSAGE.CLEAR; -- HXT11
325:
326: --HXT11l_error_text := 'System Error occurred while attempting to access Employee Data.' ||
327: --HXT11'Employee Number ' || employee_number ||
328: --HXT11'Function hxt_clock_user_edits.get_person_id';

Line 329: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11

325:
326: --HXT11l_error_text := 'System Error occurred while attempting to access Employee Data.' ||
327: --HXT11'Employee Number ' || employee_number ||
328: --HXT11'Function hxt_clock_user_edits.get_person_id';
329: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11
330: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
331: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);
332: RETURN;
333:

Line 330: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

326: --HXT11l_error_text := 'System Error occurred while attempting to access Employee Data.' ||
327: --HXT11'Employee Number ' || employee_number ||
328: --HXT11'Function hxt_clock_user_edits.get_person_id';
329: FND_MESSAGE.SET_NAME('HXT','HXT_39308_EMPLYEE_NF'); -- HXT11
330: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
331: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);
332: RETURN;
333:
334: WHEN l_assign_id_data_err THEN

Line 337: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

333:
334: WHEN l_assign_id_data_err THEN
335: ret_code := l_retcode;
336: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
337: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
338: err_buf := FND_MESSAGE.GET; -- HXT11
339: FND_MESSAGE.CLEAR; -- HXT11
340:
341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||

Line 338: err_buf := FND_MESSAGE.GET; -- HXT11

334: WHEN l_assign_id_data_err THEN
335: ret_code := l_retcode;
336: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
337: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
338: err_buf := FND_MESSAGE.GET; -- HXT11
339: FND_MESSAGE.CLEAR; -- HXT11
340:
341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||
342: --HXT11 '(Employee Number: '|| employee_number ||').';

Line 339: FND_MESSAGE.CLEAR; -- HXT11

335: ret_code := l_retcode;
336: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
337: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
338: err_buf := FND_MESSAGE.GET; -- HXT11
339: FND_MESSAGE.CLEAR; -- HXT11
340:
341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||
342: --HXT11 '(Employee Number: '|| employee_number ||').';
343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11

Line 343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11

339: FND_MESSAGE.CLEAR; -- HXT11
340:
341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||
342: --HXT11 '(Employee Number: '|| employee_number ||').';
343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11
344: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
345: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
346: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
347: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);

Line 344: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

340:
341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||
342: --HXT11 '(Employee Number: '|| employee_number ||').';
343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11
344: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
345: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
346: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
347: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
348: RETURN;

Line 345: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

341: --HXT11l_error_text := 'No Assignment was located for '||l_first_name||' '||l_last_name||
342: --HXT11 '(Employee Number: '|| employee_number ||').';
343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11
344: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
345: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
346: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
347: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
348: RETURN;
349:

Line 346: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

342: --HXT11 '(Employee Number: '|| employee_number ||').';
343: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF'); -- HXT11
344: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
345: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
346: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
347: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
348: RETURN;
349:
350: WHEN l_assign_id_sys_err THEN

Line 353: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

349:
350: WHEN l_assign_id_sys_err THEN
351: ret_code := l_retcode;
352: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
353: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
354: err_buf := FND_MESSAGE.GET; -- HXT11
355: FND_MESSAGE.CLEAR; -- HXT11
356:
357: --HXT11l_error_text := 'System Error occurred atempting to Fetch Assignment.';

Line 354: err_buf := FND_MESSAGE.GET; -- HXT11

350: WHEN l_assign_id_sys_err THEN
351: ret_code := l_retcode;
352: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
353: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
354: err_buf := FND_MESSAGE.GET; -- HXT11
355: FND_MESSAGE.CLEAR; -- HXT11
356:
357: --HXT11l_error_text := 'System Error occurred atempting to Fetch Assignment.';
358: FND_MESSAGE.SET_NAME('HXT','HXT_39319_ERR_GET_ASSIGN'); -- HXT11

Line 355: FND_MESSAGE.CLEAR; -- HXT11

351: ret_code := l_retcode;
352: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
353: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
354: err_buf := FND_MESSAGE.GET; -- HXT11
355: FND_MESSAGE.CLEAR; -- HXT11
356:
357: --HXT11l_error_text := 'System Error occurred atempting to Fetch Assignment.';
358: FND_MESSAGE.SET_NAME('HXT','HXT_39319_ERR_GET_ASSIGN'); -- HXT11
359: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);

Line 358: FND_MESSAGE.SET_NAME('HXT','HXT_39319_ERR_GET_ASSIGN'); -- HXT11

354: err_buf := FND_MESSAGE.GET; -- HXT11
355: FND_MESSAGE.CLEAR; -- HXT11
356:
357: --HXT11l_error_text := 'System Error occurred atempting to Fetch Assignment.';
358: FND_MESSAGE.SET_NAME('HXT','HXT_39319_ERR_GET_ASSIGN'); -- HXT11
359: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);
360: RETURN;
361:
362: WHEN l_pay_date_data_err THEN

Line 365: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

361:
362: WHEN l_pay_date_data_err THEN
363: ret_code := l_retcode;
364: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
365: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
366: err_buf := FND_MESSAGE.GET; -- HXT11
367: FND_MESSAGE.CLEAR; -- HXT11
368:
369: --HXT11l_error_text := 'Unable to determine date worked from user exit. Start time: ' || TO_CHAR(start_time);

Line 366: err_buf := FND_MESSAGE.GET; -- HXT11

362: WHEN l_pay_date_data_err THEN
363: ret_code := l_retcode;
364: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
365: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
366: err_buf := FND_MESSAGE.GET; -- HXT11
367: FND_MESSAGE.CLEAR; -- HXT11
368:
369: --HXT11l_error_text := 'Unable to determine date worked from user exit. Start time: ' || TO_CHAR(start_time);
370: FND_MESSAGE.SET_NAME('HXT','HXT_39331_CANT_CALC_DAT_WRKED'); -- HXT11

Line 367: FND_MESSAGE.CLEAR; -- HXT11

363: ret_code := l_retcode;
364: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
365: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
366: err_buf := FND_MESSAGE.GET; -- HXT11
367: FND_MESSAGE.CLEAR; -- HXT11
368:
369: --HXT11l_error_text := 'Unable to determine date worked from user exit. Start time: ' || TO_CHAR(start_time);
370: FND_MESSAGE.SET_NAME('HXT','HXT_39331_CANT_CALC_DAT_WRKED'); -- HXT11
371: FND_MESSAGE.SET_TOKEN('START_TIME', TO_CHAR(start_time)); --HXT11

Line 370: FND_MESSAGE.SET_NAME('HXT','HXT_39331_CANT_CALC_DAT_WRKED'); -- HXT11

366: err_buf := FND_MESSAGE.GET; -- HXT11
367: FND_MESSAGE.CLEAR; -- HXT11
368:
369: --HXT11l_error_text := 'Unable to determine date worked from user exit. Start time: ' || TO_CHAR(start_time);
370: FND_MESSAGE.SET_NAME('HXT','HXT_39331_CANT_CALC_DAT_WRKED'); -- HXT11
371: FND_MESSAGE.SET_TOKEN('START_TIME', TO_CHAR(start_time)); --HXT11
372: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
373: RETURN;
374:

Line 371: FND_MESSAGE.SET_TOKEN('START_TIME', TO_CHAR(start_time)); --HXT11

367: FND_MESSAGE.CLEAR; -- HXT11
368:
369: --HXT11l_error_text := 'Unable to determine date worked from user exit. Start time: ' || TO_CHAR(start_time);
370: FND_MESSAGE.SET_NAME('HXT','HXT_39331_CANT_CALC_DAT_WRKED'); -- HXT11
371: FND_MESSAGE.SET_TOKEN('START_TIME', TO_CHAR(start_time)); --HXT11
372: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
373: RETURN;
374:
375: WHEN l_pay_date_sys_err THEN

Line 378: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

374:
375: WHEN l_pay_date_sys_err THEN
376: ret_code := l_retcode;
377: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
378: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
379: err_buf := FND_MESSAGE.GET; -- HXT11
380: FND_MESSAGE.CLEAR; -- HXT11
381:
382: --HXT11l_error_text := 'System error occurred while attempting to determine date worked.';

Line 379: err_buf := FND_MESSAGE.GET; -- HXT11

375: WHEN l_pay_date_sys_err THEN
376: ret_code := l_retcode;
377: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
378: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
379: err_buf := FND_MESSAGE.GET; -- HXT11
380: FND_MESSAGE.CLEAR; -- HXT11
381:
382: --HXT11l_error_text := 'System error occurred while attempting to determine date worked.';
383: FND_MESSAGE.SET_NAME('HXT','HXT_39323_ERR_DATE_WRKED'); -- HXT11

Line 380: FND_MESSAGE.CLEAR; -- HXT11

376: ret_code := l_retcode;
377: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
378: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
379: err_buf := FND_MESSAGE.GET; -- HXT11
380: FND_MESSAGE.CLEAR; -- HXT11
381:
382: --HXT11l_error_text := 'System error occurred while attempting to determine date worked.';
383: FND_MESSAGE.SET_NAME('HXT','HXT_39323_ERR_DATE_WRKED'); -- HXT11
384: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);

Line 383: FND_MESSAGE.SET_NAME('HXT','HXT_39323_ERR_DATE_WRKED'); -- HXT11

379: err_buf := FND_MESSAGE.GET; -- HXT11
380: FND_MESSAGE.CLEAR; -- HXT11
381:
382: --HXT11l_error_text := 'System error occurred while attempting to determine date worked.';
383: FND_MESSAGE.SET_NAME('HXT','HXT_39323_ERR_DATE_WRKED'); -- HXT11
384: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', SQLERRM);
385: RETURN;
386:
387: WHEN l_time_per_data_err THEN

Line 390: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

386:
387: WHEN l_time_per_data_err THEN
388: ret_code := l_retcode;
389: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
390: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
391: err_buf := FND_MESSAGE.GET; -- HXT11
392: FND_MESSAGE.CLEAR; -- HXT11
393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||

Line 391: err_buf := FND_MESSAGE.GET; -- HXT11

387: WHEN l_time_per_data_err THEN
388: ret_code := l_retcode;
389: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
390: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
391: err_buf := FND_MESSAGE.GET; -- HXT11
392: FND_MESSAGE.CLEAR; -- HXT11
393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);

Line 392: FND_MESSAGE.CLEAR; -- HXT11

388: ret_code := l_retcode;
389: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
390: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
391: err_buf := FND_MESSAGE.GET; -- HXT11
392: FND_MESSAGE.CLEAR; -- HXT11
393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);
396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11

Line 396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11

392: FND_MESSAGE.CLEAR; -- HXT11
393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);
396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11
397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --FORMS60
398: FND_MESSAGE.SET_TOKEN('PAYROLL', TO_CHAR(l_emp_rec.payroll_id)); --HXT11
399: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
400: RETURN;

Line 397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --FORMS60

393:
394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);
396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11
397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --FORMS60
398: FND_MESSAGE.SET_TOKEN('PAYROLL', TO_CHAR(l_emp_rec.payroll_id)); --HXT11
399: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
400: RETURN;
401:

Line 398: FND_MESSAGE.SET_TOKEN('PAYROLL', TO_CHAR(l_emp_rec.payroll_id)); --HXT11

394: --HXT11l_error_text := 'Unable to determine a time period for date worked of: '||TO_CHAR(l_date_worked)||
395: --HXT11' Payroll: '|| TO_CHAR(l_emp_rec.payroll_id);
396: FND_MESSAGE.SET_NAME('HXT','HXT_39330_CANT_CALC_TIM_PER'); -- HXT11
397: FND_MESSAGE.SET_TOKEN('DATE_WORKED', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --FORMS60
398: FND_MESSAGE.SET_TOKEN('PAYROLL', TO_CHAR(l_emp_rec.payroll_id)); --HXT11
399: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
400: RETURN;
401:
402: WHEN l_time_per_sys_err THEN

Line 405: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

401:
402: WHEN l_time_per_sys_err THEN
403: ret_code := l_retcode;
404: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
405: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
406: err_buf := FND_MESSAGE.GET; -- HXT11
407: FND_MESSAGE.CLEAR; -- HXT11
408:
409: --HXT11l_error_text := 'System error occurred while attempting to obtain time period. ' || SQLERRM;

Line 406: err_buf := FND_MESSAGE.GET; -- HXT11

402: WHEN l_time_per_sys_err THEN
403: ret_code := l_retcode;
404: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
405: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
406: err_buf := FND_MESSAGE.GET; -- HXT11
407: FND_MESSAGE.CLEAR; -- HXT11
408:
409: --HXT11l_error_text := 'System error occurred while attempting to obtain time period. ' || SQLERRM;
410: FND_MESSAGE.SET_NAME('HXT','HXT_39324_ERR_TIME_PERIOD'); -- HXT11

Line 407: FND_MESSAGE.CLEAR; -- HXT11

403: ret_code := l_retcode;
404: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
405: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
406: err_buf := FND_MESSAGE.GET; -- HXT11
407: FND_MESSAGE.CLEAR; -- HXT11
408:
409: --HXT11l_error_text := 'System error occurred while attempting to obtain time period. ' || SQLERRM;
410: FND_MESSAGE.SET_NAME('HXT','HXT_39324_ERR_TIME_PERIOD'); -- HXT11
411: FND_MESSAGE.SET_TOKEN('SQLERR', SQLERRM); --HXT11

Line 410: FND_MESSAGE.SET_NAME('HXT','HXT_39324_ERR_TIME_PERIOD'); -- HXT11

406: err_buf := FND_MESSAGE.GET; -- HXT11
407: FND_MESSAGE.CLEAR; -- HXT11
408:
409: --HXT11l_error_text := 'System error occurred while attempting to obtain time period. ' || SQLERRM;
410: FND_MESSAGE.SET_NAME('HXT','HXT_39324_ERR_TIME_PERIOD'); -- HXT11
411: FND_MESSAGE.SET_TOKEN('SQLERR', SQLERRM); --HXT11
412: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
413: RETURN;
414:

Line 411: FND_MESSAGE.SET_TOKEN('SQLERR', SQLERRM); --HXT11

407: FND_MESSAGE.CLEAR; -- HXT11
408:
409: --HXT11l_error_text := 'System error occurred while attempting to obtain time period. ' || SQLERRM;
410: FND_MESSAGE.SET_NAME('HXT','HXT_39324_ERR_TIME_PERIOD'); -- HXT11
411: FND_MESSAGE.SET_TOKEN('SQLERR', SQLERRM); --HXT11
412: l_retcode := log_clock_errors(FALSE, NULL,'EMPL', NULL);
413: RETURN;
414:
415: WHEN l_istimecard_sys_err THEN

Line 418: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

414:
415: WHEN l_istimecard_sys_err THEN
416: ret_code := l_retcode;
417: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
418: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
419: err_buf := FND_MESSAGE.GET; -- HXT11
420: FND_MESSAGE.CLEAR; -- HXT11
421:
422: --HXT11l_error_text := 'Error occurred while checking for an existing timecard. ';

Line 419: err_buf := FND_MESSAGE.GET; -- HXT11

415: WHEN l_istimecard_sys_err THEN
416: ret_code := l_retcode;
417: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
418: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
419: err_buf := FND_MESSAGE.GET; -- HXT11
420: FND_MESSAGE.CLEAR; -- HXT11
421:
422: --HXT11l_error_text := 'Error occurred while checking for an existing timecard. ';
423: FND_MESSAGE.SET_NAME('HXT','HXT_39298_ERR_GET_TIMCARD'); -- HXT11

Line 420: FND_MESSAGE.CLEAR; -- HXT11

416: ret_code := l_retcode;
417: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
418: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
419: err_buf := FND_MESSAGE.GET; -- HXT11
420: FND_MESSAGE.CLEAR; -- HXT11
421:
422: --HXT11l_error_text := 'Error occurred while checking for an existing timecard. ';
423: FND_MESSAGE.SET_NAME('HXT','HXT_39298_ERR_GET_TIMCARD'); -- HXT11
424: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);

Line 423: FND_MESSAGE.SET_NAME('HXT','HXT_39298_ERR_GET_TIMCARD'); -- HXT11

419: err_buf := FND_MESSAGE.GET; -- HXT11
420: FND_MESSAGE.CLEAR; -- HXT11
421:
422: --HXT11l_error_text := 'Error occurred while checking for an existing timecard. ';
423: FND_MESSAGE.SET_NAME('HXT','HXT_39298_ERR_GET_TIMCARD'); -- HXT11
424: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);
425: RETURN;
426:
427: WHEN l_autogen_error THEN

Line 430: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

426:
427: WHEN l_autogen_error THEN
428: ret_code := l_retcode;
429: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
430: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
431: err_buf := FND_MESSAGE.GET; -- HXT11
432: FND_MESSAGE.CLEAR; -- HXT11
433:
434: --HXT11l_error_text := 'An autogen timecard exists for '||l_first_name||' '||l_last_name||

Line 431: err_buf := FND_MESSAGE.GET; -- HXT11

427: WHEN l_autogen_error THEN
428: ret_code := l_retcode;
429: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
430: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
431: err_buf := FND_MESSAGE.GET; -- HXT11
432: FND_MESSAGE.CLEAR; -- HXT11
433:
434: --HXT11l_error_text := 'An autogen timecard exists for '||l_first_name||' '||l_last_name||
435: --HXT11' (Employee: '|| employee_number ||').'||

Line 432: FND_MESSAGE.CLEAR; -- HXT11

428: ret_code := l_retcode;
429: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
430: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
431: err_buf := FND_MESSAGE.GET; -- HXT11
432: FND_MESSAGE.CLEAR; -- HXT11
433:
434: --HXT11l_error_text := 'An autogen timecard exists for '||l_first_name||' '||l_last_name||
435: --HXT11' (Employee: '|| employee_number ||').'||
436: --HXT11' Autogen timecards may not accept time from a timeclock.';

Line 437: FND_MESSAGE.SET_NAME('HXT','HXT_39267_AG_TCARD_EXISTS'); -- HXT11

433:
434: --HXT11l_error_text := 'An autogen timecard exists for '||l_first_name||' '||l_last_name||
435: --HXT11' (Employee: '|| employee_number ||').'||
436: --HXT11' Autogen timecards may not accept time from a timeclock.';
437: FND_MESSAGE.SET_NAME('HXT','HXT_39267_AG_TCARD_EXISTS'); -- HXT11
438: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
439: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
440: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
441: l_retcode := log_clock_errors(TRUE, NULL,'TIM', NULL);

Line 438: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

434: --HXT11l_error_text := 'An autogen timecard exists for '||l_first_name||' '||l_last_name||
435: --HXT11' (Employee: '|| employee_number ||').'||
436: --HXT11' Autogen timecards may not accept time from a timeclock.';
437: FND_MESSAGE.SET_NAME('HXT','HXT_39267_AG_TCARD_EXISTS'); -- HXT11
438: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
439: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
440: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
441: l_retcode := log_clock_errors(TRUE, NULL,'TIM', NULL);
442: RETURN;

Line 439: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

435: --HXT11' (Employee: '|| employee_number ||').'||
436: --HXT11' Autogen timecards may not accept time from a timeclock.';
437: FND_MESSAGE.SET_NAME('HXT','HXT_39267_AG_TCARD_EXISTS'); -- HXT11
438: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
439: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
440: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
441: l_retcode := log_clock_errors(TRUE, NULL,'TIM', NULL);
442: RETURN;
443:

Line 440: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

436: --HXT11' Autogen timecards may not accept time from a timeclock.';
437: FND_MESSAGE.SET_NAME('HXT','HXT_39267_AG_TCARD_EXISTS'); -- HXT11
438: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
439: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
440: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
441: l_retcode := log_clock_errors(TRUE, NULL,'TIM', NULL);
442: RETURN;
443:
444: WHEN l_make_card_data_err THEN

Line 447: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11

443:
444: WHEN l_make_card_data_err THEN
445: ret_code := l_retcode;
446: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
447: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
448: err_buf := FND_MESSAGE.GET; -- HXT11
449: FND_MESSAGE.CLEAR; -- HXT11
450:
451: --HXT11l_error_text := 'Data Error during create timecard processing for '||

Line 448: err_buf := FND_MESSAGE.GET; -- HXT11

444: WHEN l_make_card_data_err THEN
445: ret_code := l_retcode;
446: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
447: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
448: err_buf := FND_MESSAGE.GET; -- HXT11
449: FND_MESSAGE.CLEAR; -- HXT11
450:
451: --HXT11l_error_text := 'Data Error during create timecard processing for '||
452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';

Line 449: FND_MESSAGE.CLEAR; -- HXT11

445: ret_code := l_retcode;
446: --HXT11err_buf := 'Data Error: Query Error Form for ACLOCK';
447: FND_MESSAGE.SET_NAME('HXT','HXT_39401_QRY_ERR_DATA'); -- HXT11
448: err_buf := FND_MESSAGE.GET; -- HXT11
449: FND_MESSAGE.CLEAR; -- HXT11
450:
451: --HXT11l_error_text := 'Data Error during create timecard processing for '||
452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11

Line 453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11

449: FND_MESSAGE.CLEAR; -- HXT11
450:
451: --HXT11l_error_text := 'Data Error during create timecard processing for '||
452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11
454: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
455: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
456: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
457: l_retcode := log_clock_errors(FALSE, NULL,'TIM', NULL);

Line 454: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

450:
451: --HXT11l_error_text := 'Data Error during create timecard processing for '||
452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11
454: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
455: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
456: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
457: l_retcode := log_clock_errors(FALSE, NULL,'TIM', NULL);
458: RETURN;

Line 455: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

451: --HXT11l_error_text := 'Data Error during create timecard processing for '||
452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11
454: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
455: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
456: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
457: l_retcode := log_clock_errors(FALSE, NULL,'TIM', NULL);
458: RETURN;
459:

Line 456: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

452: --HXT11l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
453: FND_MESSAGE.SET_NAME('HXT','HXT_39291_CRT_TCARD_ERR'); -- HXT11
454: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
455: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
456: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
457: l_retcode := log_clock_errors(FALSE, NULL,'TIM', NULL);
458: RETURN;
459:
460: WHEN l_make_card_sys_err THEN

Line 463: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11

459:
460: WHEN l_make_card_sys_err THEN
461: ret_code := l_retcode;
462: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
463: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
464: err_buf := FND_MESSAGE.GET; -- HXT11
465: FND_MESSAGE.CLEAR; -- HXT11
466:
467: --HXT11l_error_text := 'System error during create timecard processing for '||

Line 464: err_buf := FND_MESSAGE.GET; -- HXT11

460: WHEN l_make_card_sys_err THEN
461: ret_code := l_retcode;
462: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
463: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
464: err_buf := FND_MESSAGE.GET; -- HXT11
465: FND_MESSAGE.CLEAR; -- HXT11
466:
467: --HXT11l_error_text := 'System error during create timecard processing for '||
468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';

Line 465: FND_MESSAGE.CLEAR; -- HXT11

461: ret_code := l_retcode;
462: --HXT11err_buf := 'Sys. Error: Query Error Form for ACLOCK';
463: FND_MESSAGE.SET_NAME('HXT','HXT_39402_QRY_ERR_SYS'); -- HXT11
464: err_buf := FND_MESSAGE.GET; -- HXT11
465: FND_MESSAGE.CLEAR; -- HXT11
466:
467: --HXT11l_error_text := 'System error during create timecard processing for '||
468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11

Line 469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11

465: FND_MESSAGE.CLEAR; -- HXT11
466:
467: --HXT11l_error_text := 'System error during create timecard processing for '||
468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11
470: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
471: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
472: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
473: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);

Line 470: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

466:
467: --HXT11l_error_text := 'System error during create timecard processing for '||
468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11
470: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
471: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
472: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
473: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);
474: RETURN;

Line 471: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

467: --HXT11l_error_text := 'System error during create timecard processing for '||
468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11
470: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
471: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
472: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
473: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);
474: RETURN;
475:

Line 472: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

468: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
469: FND_MESSAGE.SET_NAME('HXT','HXT_39318_ERR_CREAT_TCARD'); -- HXT11
470: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
471: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
472: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
473: l_retcode := log_clock_errors(FALSE, NULL,'TIM', SQLERRM);
474: RETURN;
475:
476: WHEN l_make_hol_data_err THEN

Line 479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11

475:
476: WHEN l_make_hol_data_err THEN
477: ret_code := l_retcode;
478: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
481: err_buf := FND_MESSAGE.GET; -- HXT11
482: FND_MESSAGE.CLEAR; -- HXT11
483:

Line 480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60

476: WHEN l_make_hol_data_err THEN
477: ret_code := l_retcode;
478: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
481: err_buf := FND_MESSAGE.GET; -- HXT11
482: FND_MESSAGE.CLEAR; -- HXT11
483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||

Line 481: err_buf := FND_MESSAGE.GET; -- HXT11

477: ret_code := l_retcode;
478: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
481: err_buf := FND_MESSAGE.GET; -- HXT11
482: FND_MESSAGE.CLEAR; -- HXT11
483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||
485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';

Line 482: FND_MESSAGE.CLEAR; -- HXT11

478: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
479: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
480: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
481: err_buf := FND_MESSAGE.GET; -- HXT11
482: FND_MESSAGE.CLEAR; -- HXT11
483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||
485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11

Line 486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11

482: FND_MESSAGE.CLEAR; -- HXT11
483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||
485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11
487: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
488: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
489: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
490: l_retcode := log_clock_errors(TRUE, NULL,'HOL', NULL);

Line 487: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

483:
484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||
485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11
487: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
488: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
489: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
490: l_retcode := log_clock_errors(TRUE, NULL,'HOL', NULL);
491: RETURN;

Line 488: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

484: --HXT11l_error_text := 'Data error occurred during create holiday hours processing for '||
485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11
487: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
488: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
489: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
490: l_retcode := log_clock_errors(TRUE, NULL,'HOL', NULL);
491: RETURN;
492:

Line 489: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

485: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
486: FND_MESSAGE.SET_NAME('HXT','HXT_39292_CRT_HOL_HRS'); -- HXT11
487: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
488: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
489: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
490: l_retcode := log_clock_errors(TRUE, NULL,'HOL', NULL);
491: RETURN;
492:
493: WHEN l_make_hol_sys_err THEN

Line 496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11

492:
493: WHEN l_make_hol_sys_err THEN
494: ret_code := l_retcode;
495: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
498: err_buf := FND_MESSAGE.GET; -- HXT11
499: FND_MESSAGE.CLEAR; -- HXT11
500:

Line 497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60

493: WHEN l_make_hol_sys_err THEN
494: ret_code := l_retcode;
495: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
498: err_buf := FND_MESSAGE.GET; -- HXT11
499: FND_MESSAGE.CLEAR; -- HXT11
500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||

Line 498: err_buf := FND_MESSAGE.GET; -- HXT11

494: ret_code := l_retcode;
495: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
498: err_buf := FND_MESSAGE.GET; -- HXT11
499: FND_MESSAGE.CLEAR; -- HXT11
500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||
502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';

Line 499: FND_MESSAGE.CLEAR; -- HXT11

495: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
496: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
497: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
498: err_buf := FND_MESSAGE.GET; -- HXT11
499: FND_MESSAGE.CLEAR; -- HXT11
500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||
502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11

Line 503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11

499: FND_MESSAGE.CLEAR; -- HXT11
500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||
502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11
504: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
505: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
506: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
507: l_retcode := log_clock_errors(TRUE, NULL,'HOL', SQLERRM);

Line 504: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11

500:
501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||
502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11
504: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
505: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
506: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
507: l_retcode := log_clock_errors(TRUE, NULL,'HOL', SQLERRM);
508: RETURN;

Line 505: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11

501: --HXT11l_error_text := 'System error occurred during create holiday hours processing for '||
502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11
504: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
505: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
506: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
507: l_retcode := log_clock_errors(TRUE, NULL,'HOL', SQLERRM);
508: RETURN;
509:

Line 506: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11

502: --HXT11 l_first_name||' '||l_last_name||' (Employee: '|| employee_number ||').';
503: FND_MESSAGE.SET_NAME('HXT','HXT_39320_ERR_CREAT_HOL'); -- HXT11
504: FND_MESSAGE.SET_TOKEN('FIRST_NAME', l_first_name); --HXT11
505: FND_MESSAGE.SET_TOKEN('LAST_NAME', l_last_name); --HXT11
506: FND_MESSAGE.SET_TOKEN('EMP_NUMBER', employee_number); --HXT11
507: l_retcode := log_clock_errors(TRUE, NULL,'HOL', SQLERRM);
508: RETURN;
509:
510: WHEN l_rec_hours_data_err THEN

Line 513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11

509:
510: WHEN l_rec_hours_data_err THEN
511: ret_code := l_retcode;
512: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:

Line 514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60

510: WHEN l_rec_hours_data_err THEN
511: ret_code := l_retcode;
512: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:
518: --HXT11l_error_text := 'Data Error occurred in the record hours functionality';

Line 515: err_buf := FND_MESSAGE.GET; -- HXT11

511: ret_code := l_retcode;
512: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:
518: --HXT11l_error_text := 'Data Error occurred in the record hours functionality';
519: FND_MESSAGE.SET_NAME('HXT','HXT_39293_REC_HRS_ERR'); -- HXT11

Line 516: FND_MESSAGE.CLEAR; -- HXT11

512: --HXT11err_buf := 'Data Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
513: FND_MESSAGE.SET_NAME('HXT','HXT_39404_QRY_DAT_TOK'); -- HXT11
514: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:
518: --HXT11l_error_text := 'Data Error occurred in the record hours functionality';
519: FND_MESSAGE.SET_NAME('HXT','HXT_39293_REC_HRS_ERR'); -- HXT11
520: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', NULL);

Line 519: FND_MESSAGE.SET_NAME('HXT','HXT_39293_REC_HRS_ERR'); -- HXT11

515: err_buf := FND_MESSAGE.GET; -- HXT11
516: FND_MESSAGE.CLEAR; -- HXT11
517:
518: --HXT11l_error_text := 'Data Error occurred in the record hours functionality';
519: FND_MESSAGE.SET_NAME('HXT','HXT_39293_REC_HRS_ERR'); -- HXT11
520: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', NULL);
521: RETURN;
522:
523: WHEN l_rec_hours_sys_err THEN

Line 526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11

522:
523: WHEN l_rec_hours_sys_err THEN
524: ret_code := l_retcode;
525: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:

Line 527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60

523: WHEN l_rec_hours_sys_err THEN
524: ret_code := l_retcode;
525: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:
531: --HXT11l_error_text := 'System error occurred in the record hours functionality';

Line 528: err_buf := FND_MESSAGE.GET; -- HXT11

524: ret_code := l_retcode;
525: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:
531: --HXT11l_error_text := 'System error occurred in the record hours functionality';
532: FND_MESSAGE.SET_NAME('HXT','HXT_39321_ERR_REC_HRS'); -- HXT11

Line 529: FND_MESSAGE.CLEAR; -- HXT11

525: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
526: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
527: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:
531: --HXT11l_error_text := 'System error occurred in the record hours functionality';
532: FND_MESSAGE.SET_NAME('HXT','HXT_39321_ERR_REC_HRS'); -- HXT11
533: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);

Line 532: FND_MESSAGE.SET_NAME('HXT','HXT_39321_ERR_REC_HRS'); -- HXT11

528: err_buf := FND_MESSAGE.GET; -- HXT11
529: FND_MESSAGE.CLEAR; -- HXT11
530:
531: --HXT11l_error_text := 'System error occurred in the record hours functionality';
532: FND_MESSAGE.SET_NAME('HXT','HXT_39321_ERR_REC_HRS'); -- HXT11
533: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
534: RETURN;
535:
536: WHEN g_error_log_error THEN

Line 538: FND_MESSAGE.SET_NAME('HXT','HXT_39403_LOG_ERR_ERR'); -- HXT11

534: RETURN;
535:
536: WHEN g_error_log_error THEN
537: --HXT11err_buf := 'Error in hxt_time_clock.log_clock_errors';
538: FND_MESSAGE.SET_NAME('HXT','HXT_39403_LOG_ERR_ERR'); -- HXT11
539: err_buf := FND_MESSAGE.GET; -- HXT11
540: FND_MESSAGE.CLEAR; -- HXT11
541:
542: HXT_UTIL.DEBUG('Error in hxt_time_clock.log_clock_errors'); --DEBUG ONLY --HXT115

Line 539: err_buf := FND_MESSAGE.GET; -- HXT11

535:
536: WHEN g_error_log_error THEN
537: --HXT11err_buf := 'Error in hxt_time_clock.log_clock_errors';
538: FND_MESSAGE.SET_NAME('HXT','HXT_39403_LOG_ERR_ERR'); -- HXT11
539: err_buf := FND_MESSAGE.GET; -- HXT11
540: FND_MESSAGE.CLEAR; -- HXT11
541:
542: HXT_UTIL.DEBUG('Error in hxt_time_clock.log_clock_errors'); --DEBUG ONLY --HXT115
543: ret_code := 2;

Line 540: FND_MESSAGE.CLEAR; -- HXT11

536: WHEN g_error_log_error THEN
537: --HXT11err_buf := 'Error in hxt_time_clock.log_clock_errors';
538: FND_MESSAGE.SET_NAME('HXT','HXT_39403_LOG_ERR_ERR'); -- HXT11
539: err_buf := FND_MESSAGE.GET; -- HXT11
540: FND_MESSAGE.CLEAR; -- HXT11
541:
542: HXT_UTIL.DEBUG('Error in hxt_time_clock.log_clock_errors'); --DEBUG ONLY --HXT115
543: ret_code := 2;
544: RETURN;

Line 548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11

544: RETURN;
545:
546: WHEN OTHERS THEN
547: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:

Line 549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60

545:
546: WHEN OTHERS THEN
547: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:
553: ret_code := 2;

Line 550: err_buf := FND_MESSAGE.GET; -- HXT11

546: WHEN OTHERS THEN
547: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:
553: ret_code := 2;
554: FND_MESSAGE.SET_NAME('HXT','HXT_39406_EXCP_REC_TIME'); -- HXT11

Line 551: FND_MESSAGE.CLEAR; -- HXT11

547: --HXT11err_buf := 'Sys. Error: Query timecard for'|| TO_CHAR(l_date_worked); --SIR149
548: FND_MESSAGE.SET_NAME('HXT','HXT_39405_QRY_SYS_TOK'); -- HXT11
549: FND_MESSAGE.SET_TOKEN('1', fnd_date.date_to_chardate(l_date_worked)); --HXT11 --SIR149 --FORMS60
550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:
553: ret_code := 2;
554: FND_MESSAGE.SET_NAME('HXT','HXT_39406_EXCP_REC_TIME'); -- HXT11
555: l_retcode := log_clock_errors(FALSE, NULL,'TIMEXCP', SQLERRM);

Line 554: FND_MESSAGE.SET_NAME('HXT','HXT_39406_EXCP_REC_TIME'); -- HXT11

550: err_buf := FND_MESSAGE.GET; -- HXT11
551: FND_MESSAGE.CLEAR; -- HXT11
552:
553: ret_code := 2;
554: FND_MESSAGE.SET_NAME('HXT','HXT_39406_EXCP_REC_TIME'); -- HXT11
555: l_retcode := log_clock_errors(FALSE, NULL,'TIMEXCP', SQLERRM);
556: RETURN;
557: END record_time;
558: /***********************************

Line 696: FND_MESSAGE.SET_NAME('HXT','HXT_39407_CREATE_TIM'); -- HXT11

692: RETURN l_retcode;
693: WHEN l_batch_location_error THEN
694: RETURN l_retcode;
695: WHEN l_tim_id_creation_error THEN
696: FND_MESSAGE.SET_NAME('HXT','HXT_39407_CREATE_TIM'); -- HXT11
697: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', NULL);
698: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating timecard id in hxt_time_gen.Get_HXT_Seqno','Timecard Creation', NULL);
699: RETURN 2;
700: WHEN OTHERS THEN

Line 701: FND_MESSAGE.SET_NAME('HXT','HXT_39408_CREATE_TIM_FUNC'); -- HXT11

697: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', NULL);
698: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating timecard id in hxt_time_gen.Get_HXT_Seqno','Timecard Creation', NULL);
699: RETURN 2;
700: WHEN OTHERS THEN
701: FND_MESSAGE.SET_NAME('HXT','HXT_39408_CREATE_TIM_FUNC'); -- HXT11
702: l_retcode := log_clock_errors(FALSE, NULL,'Timecard Creation', SQLERRM);
703: --HXT11l_retcode := log_clock_errors(FALSE, 'Error in function create_timecard','Timecard Creation', SQLERRM);
704: RETURN 2;
705: END create_timecard;

Line 785: FND_MESSAGE.SET_NAME('HXT','HXT_39409_CREATE_BATCH'); -- HXT11

781: o_batch_id := l_batch_id;
782: return 0;
783: EXCEPTION
784: WHEN l_batch_id_error THEN
785: FND_MESSAGE.SET_NAME('HXT','HXT_39409_CREATE_BATCH'); -- HXT11
786: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', SQLERRM);
787: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating batch id in hxt_time_gen.Get_Next_Batch_Id','Timecard Creation', SQLERRM);
788: RETURN 2;
789:

Line 791: FND_MESSAGE.SET_NAME('HXT','HXT_39410_CREATE_REF_FUNC'); -- HXT11

787: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating batch id in hxt_time_gen.Get_Next_Batch_Id','Timecard Creation', SQLERRM);
788: RETURN 2;
789:
790: WHEN l_reference_num_error THEN
791: FND_MESSAGE.SET_NAME('HXT','HXT_39410_CREATE_REF_FUNC'); -- HXT11
792: l_retcode := log_clock_errors(FALSE, NULL,'Timecard Creation', SQLERRM);
793: --HXT11l_retcode := log_clock_errors(FALSE, 'Error creating reference number in hxt_user_exits.Define_Reference_Number','Timecard Creation', SQLERRM);
794: RETURN l_retcode;
795:

Line 798: FND_MESSAGE.SET_NAME('HXT','HXT_39484_CREATE_BATCH_NAME');

794: RETURN l_retcode;
795:
796: --BEGIN GLOBAL
797: WHEN l_batch_name_error THEN
798: FND_MESSAGE.SET_NAME('HXT','HXT_39484_CREATE_BATCH_NAME');
799: l_retcode := log_clock_errors(FALSE, NULL,'Timecard Creation', SQLERRM);
800: RETURN l_retcode;
801: --END GLOBAL
802:

Line 804: FND_MESSAGE.SET_NAME('HXT','HXT_39411_CREATE_BATCH_FUNC'); -- HXT11

800: RETURN l_retcode;
801: --END GLOBAL
802:
803: WHEN OTHERS THEN
804: FND_MESSAGE.SET_NAME('HXT','HXT_39411_CREATE_BATCH_FUNC'); -- HXT11
805: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', SQLERRM);
806: --HXT11l_retcode := log_clock_errors(FALSE, 'Error in function create_batch','Timecard Creation', SQLERRM);
807: RETURN 2;
808: END create_batch;

Line 867: FND_MESSAGE.SET_NAME('HXT','HXT_39412_FIND_BATCH_FUNC'); -- HXT11

863: EXCEPTION
864: WHEN NO_DATA_FOUND THEN
865: RETURN 1;
866: WHEN OTHERS THEN
867: FND_MESSAGE.SET_NAME('HXT','HXT_39412_FIND_BATCH_FUNC'); -- HXT11
868: l_retcode := log_clock_errors(FALSE, NULL,'TIMCRT', SQLERRM);
869: --HXT11l_retcode := log_clock_errors(FALSE, 'Error in function find_existing_batch','Timecard Creation', SQLERRM);
870: RETURN 2;
871: END find_existing_batch;

Line 982: FND_MESSAGE.SET_NAME('HXT','HXT_39413_LOC_HOL'); -- HXT11

978: RETURN 0;
979: WHEN l_hours_worked_error THEN
980: RETURN 1;
981: WHEN OTHERS THEN
982: FND_MESSAGE.SET_NAME('HXT','HXT_39413_LOC_HOL'); -- HXT11
983: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
984: l_retcode := log_clock_errors(TRUE,NULL, 'TIMCRT', SQLERRM);
985: --HXT11l_retcode := log_clock_errors(TRUE,'Error attempting to locate holiday information'||
986: --HXT11 'while creating a timecard for Assignment: '||

Line 983: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11

979: WHEN l_hours_worked_error THEN
980: RETURN 1;
981: WHEN OTHERS THEN
982: FND_MESSAGE.SET_NAME('HXT','HXT_39413_LOC_HOL'); -- HXT11
983: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
984: l_retcode := log_clock_errors(TRUE,NULL, 'TIMCRT', SQLERRM);
985: --HXT11l_retcode := log_clock_errors(TRUE,'Error attempting to locate holiday information'||
986: --HXT11 'while creating a timecard for Assignment: '||
987: --HXT11 TO_CHAR(i_assignment_id)||' in function create_holiday_hours',

Line 1285: FND_MESSAGE.SET_NAME('HXT','HXT_39414_LOC_ADDL_ASG'); -- HXT11

1281: RETURN 0;
1282:
1283: EXCEPTION
1284: WHEN l_details_error THEN
1285: FND_MESSAGE.SET_NAME('HXT','HXT_39414_LOC_ADDL_ASG'); -- HXT11
1286: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
1287: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', NULL);
1288: --HXT11l_retcode := log_clock_errors(TRUE, 'Additional Assignment details not located for Assignment '||TO_CHAR(i_assignment_id),'Record Hours', NULL);
1289: RETURN 1;

Line 1286: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11

1282:
1283: EXCEPTION
1284: WHEN l_details_error THEN
1285: FND_MESSAGE.SET_NAME('HXT','HXT_39414_LOC_ADDL_ASG'); -- HXT11
1286: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
1287: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', NULL);
1288: --HXT11l_retcode := log_clock_errors(TRUE, 'Additional Assignment details not located for Assignment '||TO_CHAR(i_assignment_id),'Record Hours', NULL);
1289: RETURN 1;
1290:

Line 1292: FND_MESSAGE.SET_NAME('HXT','HXT_39415_FETCH_ASG_DET'); -- HXT11

1288: --HXT11l_retcode := log_clock_errors(TRUE, 'Additional Assignment details not located for Assignment '||TO_CHAR(i_assignment_id),'Record Hours', NULL);
1289: RETURN 1;
1290:
1291: WHEN l_details_system_error THEN
1292: FND_MESSAGE.SET_NAME('HXT','HXT_39415_FETCH_ASG_DET'); -- HXT11
1293: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
1294: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1295: --HXT11l_retcode := log_clock_errors(TRUE,
1296: --HXT11 'System Error occurred atempting to Fetch Assignment details'||

Line 1293: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11

1289: RETURN 1;
1290:
1291: WHEN l_details_system_error THEN
1292: FND_MESSAGE.SET_NAME('HXT','HXT_39415_FETCH_ASG_DET'); -- HXT11
1293: FND_MESSAGE.SET_TOKEN('ASG_ID',TO_CHAR(i_assignment_id)); -- HXT11
1294: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1295: --HXT11l_retcode := log_clock_errors(TRUE,
1296: --HXT11 'System Error occurred atempting to Fetch Assignment details'||
1297: --HXT11 'for Assignment '||TO_CHAR(i_assignment_id)||

Line 1303: FND_MESSAGE.SET_NAME('HXT','HXT_39416_GET_HRW_ID'); -- HXT11

1299: --HXT11 'Record Hours',SQLERRM);
1300: RETURN 2;
1301:
1302: WHEN l_hours_worked_id_error THEN
1303: FND_MESSAGE.SET_NAME('HXT','HXT_39416_GET_HRW_ID'); -- HXT11
1304: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1305: --HXT11l_retcode := log_clock_errors(TRUE, 'Error while attempting to obtain hours worked id from hxt_time_gen.Get_HXT_Seqno.','Record Hours', SQLERRM);
1306: RETURN 2;
1307:

Line 1309: FND_MESSAGE.SET_NAME('HXT','HXT_39417_PROB_GEN_DET'); -- HXT11

1305: --HXT11l_retcode := log_clock_errors(TRUE, 'Error while attempting to obtain hours worked id from hxt_time_gen.Get_HXT_Seqno.','Record Hours', SQLERRM);
1306: RETURN 2;
1307:
1308: WHEN l_generate_details_error THEN
1309: FND_MESSAGE.SET_NAME('HXT','HXT_39417_PROB_GEN_DET'); -- HXT11
1310: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1311: --HXT11l_retcode := log_clock_errors(TRUE,'A problem occurred in the function hxt_time_summary.Generate_Details.','Record Hours', SQLERRM);
1312: RETURN 2;
1313:

Line 1315: FND_MESSAGE.SET_NAME('HXT','HXT_39418_GET_HRW_SEQ'); -- HXT11

1311: --HXT11l_retcode := log_clock_errors(TRUE,'A problem occurred in the function hxt_time_summary.Generate_Details.','Record Hours', SQLERRM);
1312: RETURN 2;
1313:
1314: WHEN l_seq_num_error THEN
1315: FND_MESSAGE.SET_NAME('HXT','HXT_39418_GET_HRW_SEQ'); -- HXT11
1316: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1317: --HXT11l_retcode := log_clock_errors(TRUE,'Error while attempting to obtain hours worked sequence number in function record_hours_worked.','Record Hours', SQLERRM);
1318: RETURN 2;
1319:

Line 1321: FND_MESSAGE.SET_NAME('HXT','HXT_39419_SYSERR_RECFUNC'); -- HXT11

1317: --HXT11l_retcode := log_clock_errors(TRUE,'Error while attempting to obtain hours worked sequence number in function record_hours_worked.','Record Hours', SQLERRM);
1318: RETURN 2;
1319:
1320: WHEN OTHERS THEN
1321: FND_MESSAGE.SET_NAME('HXT','HXT_39419_SYSERR_RECFUNC'); -- HXT11
1322: l_retcode := log_clock_errors(TRUE, NULL,'RECHRS', SQLERRM);
1323: --HXT11l_retcode := log_clock_errors(TRUE,'System Error occurred in Function record_hours_worked','Record Hours',SQLERRM);
1324: RETURN 2;
1325: END record_hours_worked;

Line 1348: l_err_buf := FND_MESSAGE.GET;

1344: HXT_UTIL.DEBUG('g_hours_worked_err_id = ' || TO_CHAR(g_hours_worked_err_id)); --DEBUG ONLY --HXT115
1345: HXT_UTIL.DEBUG('g_time_period_err_id = ' || g_time_period_err_id); --DEBUG ONLY --HXT115
1346: HXT_UTIL.DEBUG(i_error_text || i_sql_message); --DEBUG ONLY --HXT115
1347: --begin HXT11
1348: l_err_buf := FND_MESSAGE.GET;
1349: FND_MESSAGE.CLEAR;
1350: --end HXT11
1351: IF i_timecard_available THEN
1352: HXT_UTIL.DEBUG('TC available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115

Line 1349: FND_MESSAGE.CLEAR;

1345: HXT_UTIL.DEBUG('g_time_period_err_id = ' || g_time_period_err_id); --DEBUG ONLY --HXT115
1346: HXT_UTIL.DEBUG(i_error_text || i_sql_message); --DEBUG ONLY --HXT115
1347: --begin HXT11
1348: l_err_buf := FND_MESSAGE.GET;
1349: FND_MESSAGE.CLEAR;
1350: --end HXT11
1351: IF i_timecard_available THEN
1352: HXT_UTIL.DEBUG('TC available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115
1353: hxt_util.Gen_Error( g_batch_err_id,