APPS.HXT_TIME_GEN dependencies on HXT_UTIL

Line 461: WHERE wsh.week_day = hxt_util.get_week_day(a_date)

457: sht.late_stop, sht.hours
458: FROM hxt_shifts sht,
459: hxt_weekly_work_schedules wws,
460: hxt_work_shifts wsh
461: WHERE wsh.week_day = hxt_util.get_week_day(a_date)
462: AND wws.id = wsh.tws_id
463: AND a_date BETWEEN wws.date_from AND NVL (wws.date_to, a_date)
464: AND wws.id = a_work_id
465: AND sht.id = wsh.sht_id;

Line 564: hxt_util.DEBUG (g_autogen_error);

560: THEN
561: fnd_message.set_name ('HXT', 'HXT_39368_GEN_WRK_PLAN_ERR');
562: fnd_message.set_token ('SQLERR', SQLERRM);
563: g_autogen_error := '';
564: hxt_util.DEBUG (g_autogen_error);
565: g_sqlerrm := SQLERRM;
566: call_gen_error (NULL, g_autogen_error, g_sqlerrm);
567: g_errors := TRUE; --SPR C389
568: END gen_work_plan;

Line 914: g_sub_loc := 'HXT_UTIL.Get_Next_Seqno';

910: RAISE l_seq_exceptn;
911: END IF;
912:
913: -- Get next available line seqno
914: g_sub_loc := 'HXT_UTIL.Get_Next_Seqno';
915:
916: IF g_sub_loc IS NULL
917: THEN -- C257 C261 by BC
918: RAISE l_seq_exceptn;

Line 921: l_seqno := hxt_util.get_next_seqno (a_tim_id, a_date_worked);

917: THEN -- C257 C261 by BC
918: RAISE l_seq_exceptn;
919: END IF;
920:
921: l_seqno := hxt_util.get_next_seqno (a_tim_id, a_date_worked);
922:
923: IF l_seqno IS NULL
924: THEN -- C257 C261 by BC
925: RAISE l_seq_exceptn;

Line 1149: hxt_util.gen_error (

1145: -- PRIVATE procedure to create error table entries for this package
1146: -- Parameters for call to Gen_Error:
1147: BEGIN
1148: -- Insert into error table
1149: hxt_util.gen_error (
1150: g_asm_rec.batch_id,
1151: g_asm_rec.tim_id,
1152: NULL,
1153: g_time_period_id,