APPS.HXT_TIME_CLOCK dependencies on HXT_ERRORS

Line 9: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;

5: g_user_name fnd_user.user_name%TYPE := 'TimeClock';
6: g_sysdate DATE := trunc(SYSDATE);
7: g_bus_group_id hr_organization_units.business_group_id%TYPE :=
8: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
9: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;
10: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;
11: g_hours_worked_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;
12: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;
13: g_error_log_error EXCEPTION;

Line 10: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;

6: g_sysdate DATE := trunc(SYSDATE);
7: g_bus_group_id hr_organization_units.business_group_id%TYPE :=
8: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
9: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;
10: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;
11: g_hours_worked_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;
12: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;
13: g_error_log_error EXCEPTION;
14:

Line 11: g_hours_worked_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;

7: g_bus_group_id hr_organization_units.business_group_id%TYPE :=
8: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
9: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;
10: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;
11: g_hours_worked_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;
12: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;
13: g_error_log_error EXCEPTION;
14:
15: -----------------------------< record_time >-------------------------------

Line 12: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;

8: FND_PROFILE.Value( 'PER_BUSINESS_GROUP_ID' );
9: g_batch_err_id hxt_errors.ppb_id%TYPE DEFAULT NULL;
10: g_timecard_err_id hxt_errors.tim_id%TYPE DEFAULT NULL;
11: g_hours_worked_err_id hxt_errors.hrw_id%TYPE DEFAULT NULL;
12: g_time_period_err_id hxt_errors.ptp_id%TYPE DEFAULT NULL;
13: g_error_log_error EXCEPTION;
14:
15: -----------------------------< record_time >-------------------------------
16: --

Line 78: -- failure circumstance. Errors will be logged in the table HXT_ERRORS_F

74: -- will be 0 to indicate success.
75: --
76: -- Post failure:
77: -- An OTM Timecard may or may not be created or updated depending on the
78: -- failure circumstance. Errors will be logged in the table HXT_ERRORS_F
79: -- and will be viewable on the OTM Timecard Errors form regardless of
80: -- whether the Timecard was created or previously existed. The following
81: -- OUT Parameters will be set to indicate the cause of the failure:
82: --