DBA Data[Home] [Help]

APPS.HXT_TIME_GEN dependencies on HXT_ERRORS

Line 15: g_err_loc hxt_errors.location%TYPE;

11: g_batch_size NUMBER := FND_PROFILE.Value( 'HXT_BATCH_SIZE' );
12: g_sysdate DATE := trunc(SYSDATE);
13: g_sysdatetime DATE := SYSDATE;
14: g_login_id fnd_user.last_update_login%TYPE := FND_GLOBAL.login_id;
15: g_err_loc hxt_errors.location%TYPE;
16: g_sub_loc hxt_errors.location%TYPE;
17: g_errors BOOLEAN := FALSE;
18: g_sqlerrm hxt_errors.ora_message%TYPE;
19: g_autogen_error hxt_errors.error_msg%TYPE;

Line 16: g_sub_loc hxt_errors.location%TYPE;

12: g_sysdate DATE := trunc(SYSDATE);
13: g_sysdatetime DATE := SYSDATE;
14: g_login_id fnd_user.last_update_login%TYPE := FND_GLOBAL.login_id;
15: g_err_loc hxt_errors.location%TYPE;
16: g_sub_loc hxt_errors.location%TYPE;
17: g_errors BOOLEAN := FALSE;
18: g_sqlerrm hxt_errors.ora_message%TYPE;
19: g_autogen_error hxt_errors.error_msg%TYPE;
20: g_date_worked_error EXCEPTION;

Line 18: g_sqlerrm hxt_errors.ora_message%TYPE;

14: g_login_id fnd_user.last_update_login%TYPE := FND_GLOBAL.login_id;
15: g_err_loc hxt_errors.location%TYPE;
16: g_sub_loc hxt_errors.location%TYPE;
17: g_errors BOOLEAN := FALSE;
18: g_sqlerrm hxt_errors.ora_message%TYPE;
19: g_autogen_error hxt_errors.error_msg%TYPE;
20: g_date_worked_error EXCEPTION;
21: g_form_level_error EXCEPTION;
22: g_del_obs_tim_error EXCEPTION; --SIR216

Line 19: g_autogen_error hxt_errors.error_msg%TYPE;

15: g_err_loc hxt_errors.location%TYPE;
16: g_sub_loc hxt_errors.location%TYPE;
17: g_errors BOOLEAN := FALSE;
18: g_sqlerrm hxt_errors.ora_message%TYPE;
19: g_autogen_error hxt_errors.error_msg%TYPE;
20: g_date_worked_error EXCEPTION;
21: g_form_level_error EXCEPTION;
22: g_del_obs_tim_error EXCEPTION; --SIR216
23: g_osp_id hxt_work_shifts.off_shift_prem_id%TYPE;