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 HXT_UTIL

Line 136: HXT_UTIL.DEBUG('Inserted a row in fnd session '); --HXT115

132: if C_session_exists%notfound then
133: insert into fnd_sessions
134: (effective_date, session_id)
135: values (sysdate, userenv('sessionid'));
136: HXT_UTIL.DEBUG('Inserted a row in fnd session '); --HXT115
137: end if;
138: close C_session_exists;
139: --
140: -- End of fix for bug 756293

Line 147: HXT_UTIL.DEBUG('determine_pay_date returns: '|| fnd_date.date_to_chardate(l_date_worked));--DEBUG ONLY --FORMS60 --HXT115

143: l_retcode := hxt_clock_user_edits.determine_pay_date( start_time,
144: end_time,
145: l_person_id,
146: l_date_worked);
147: HXT_UTIL.DEBUG('determine_pay_date returns: '|| fnd_date.date_to_chardate(l_date_worked));--DEBUG ONLY --FORMS60 --HXT115
148: IF l_retcode = 1 THEN
149: RAISE l_pay_date_data_err;
150: ELSIF l_retcode = 2 THEN
151: RAISE l_pay_date_sys_err;

Line 176: HXT_UTIL.DEBUG('get_person_id returns: '|| TO_CHAR(l_retcode));--DEBUG ONLY --HXT115

172: l_date_worked,
173: l_person_id,
174: l_last_name,
175: l_first_name);
176: HXT_UTIL.DEBUG('get_person_id returns: '|| TO_CHAR(l_retcode));--DEBUG ONLY --HXT115
177: IF l_retcode = 1 THEN
178: RAISE l_person_id_data_err;
179: ELSIF l_retcode = 2 THEN
180: RAISE l_person_id_sys_err;

Line 185: HXT_UTIL.DEBUG('Opening Cursor');--DEBUG ONLY --HXT115

181: END IF;
182: --
183: /* Obtain vital employee information*/
184: BEGIN
185: HXT_UTIL.DEBUG('Opening Cursor');--DEBUG ONLY --HXT115
186: OPEN l_employee_cur(l_person_id);
187: HXT_UTIL.DEBUG('Fetching Cursor');--DEBUG ONLY --HXT115
188: FETCH l_employee_cur
189: INTO l_emp_rec;

Line 187: HXT_UTIL.DEBUG('Fetching Cursor');--DEBUG ONLY --HXT115

183: /* Obtain vital employee information*/
184: BEGIN
185: HXT_UTIL.DEBUG('Opening Cursor');--DEBUG ONLY --HXT115
186: OPEN l_employee_cur(l_person_id);
187: HXT_UTIL.DEBUG('Fetching Cursor');--DEBUG ONLY --HXT115
188: FETCH l_employee_cur
189: INTO l_emp_rec;
190: HXT_UTIL.DEBUG('Closing Cursor');--DEBUG ONLY --HXT115
191: CLOSE l_employee_cur;

Line 190: HXT_UTIL.DEBUG('Closing Cursor');--DEBUG ONLY --HXT115

186: OPEN l_employee_cur(l_person_id);
187: HXT_UTIL.DEBUG('Fetching Cursor');--DEBUG ONLY --HXT115
188: FETCH l_employee_cur
189: INTO l_emp_rec;
190: HXT_UTIL.DEBUG('Closing Cursor');--DEBUG ONLY --HXT115
191: CLOSE l_employee_cur;
192: g_bus_group_id := l_emp_rec.business_group_id; --GLOBAL
193: EXCEPTION
194: WHEN NO_DATA_FOUND THEN

Line 202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115

198: l_retcode := 2;
199: RAISE l_assign_id_sys_err;
200: END;
201: --DEBUG ONLY BEGIN
202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115

Line 203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115

199: RAISE l_assign_id_sys_err;
200: END;
201: --DEBUG ONLY BEGIN
202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115

Line 204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL

200: END;
201: --DEBUG ONLY BEGIN
202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115

Line 205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115

201: --DEBUG ONLY BEGIN
202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END

Line 206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115

202: HXT_UTIL.DEBUG('Payroll id : '||TO_CHAR(l_emp_rec.payroll_id)); --HXT115
203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END
210: --

Line 207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115

203: HXT_UTIL.DEBUG('Assignment id: '||TO_CHAR(l_emp_rec.assignment_id)); --HXT115
204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END
210: --
211: /*Obtain the current time period id for this payroll and date*/

Line 208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115

204: HXT_UTIL.DEBUG('Business Group id: '||TO_CHAR(l_emp_rec.business_group_id)); --GLOBAL
205: HXT_UTIL.DEBUG('Effective Start Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_start_date)); --FORMS60 --HXT115
206: HXT_UTIL.DEBUG('Effective End Date: '||fnd_date.date_to_chardate(l_emp_rec.effective_end_date)); --FORMS60 --HXT115
207: HXT_UTIL.DEBUG('hcl_id: '||TO_CHAR(l_emp_rec.hcl_id)); --HXT115
208: HXT_UTIL.DEBUG('hxt_rotation_plan: '||l_emp_rec.hxt_rotation_plan); --SIR344 --HXT115
209: --DEBUG ONLY END
210: --
211: /*Obtain the current time period id for this payroll and date*/
212: l_retcode := get_time_period( l_emp_rec.payroll_id,

Line 217: HXT_UTIL.DEBUG('get_time_period returns period: '|| --HXT115

213: l_date_worked,
214: l_time_period_id,
215: l_start_date,
216: l_end_date);
217: HXT_UTIL.DEBUG('get_time_period returns period: '|| --HXT115
218: TO_CHAR(l_time_period_id)|| ' start date: '||
219: fnd_date.date_to_chardate(l_start_date)|| ' end date: '|| -- FORMS60
220: fnd_date.date_to_chardate(l_end_date));--DEBUG ONLY --FORMS60
221: IF l_retcode = 1 THEN

Line 238: HXT_UTIL.DEBUG('check_for_timecard returns timecard id: '|| TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115

234: END IF;
235: --
236: /*Check for an existing timecard */
237: l_retcode := check_for_timecard(l_person_id, l_time_period_id, l_timecard_id, l_auto_gen_flag);
238: HXT_UTIL.DEBUG('check_for_timecard returns timecard id: '|| TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
239: --
240: IF l_retcode = 0 THEN
241: g_timecard_err_id := l_timecard_id;
242: ELSIF l_retcode = 1 THEN

Line 256: HXT_UTIL.DEBUG('Now generating holidays'); --HXT115

252: RAISE l_make_card_sys_err;
253: END IF;
254: g_timecard_err_id := l_timecard_id;
255: /*Create holiday hours on the new timecard*/
256: HXT_UTIL.DEBUG('Now generating holidays'); --HXT115
257: l_retcode := create_holiday_hours(l_person_id,
258: l_emp_rec.hcl_id,
259: l_emp_rec.hxt_rotation_plan, --SIR344
260: l_start_date,

Line 272: HXT_UTIL.DEBUG('Hours will be charged to Timecard id: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115

268: END IF;
269: ELSIF l_retcode = 2 THEN
270: RAISE l_istimecard_sys_err;
271: END IF;
272: HXT_UTIL.DEBUG('Hours will be charged to Timecard id: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
273: --
274: /*Check to see if pre-existing timecards were autogened*/
275: IF l_auto_gen_flag = 'A' THEN
276: RAISE l_autogen_error;

Line 281: HXT_UTIL.DEBUG('Hours worked: '||TO_CHAR(l_hours));--DEBUG ONLY --HXT115

277: END IF;
278: --
279: /*Calculate the hours worked*/
280: l_hours := 24 * (TRUNC(end_time,'MI') - TRUNC(start_time,'MI'));
281: HXT_UTIL.DEBUG('Hours worked: '||TO_CHAR(l_hours));--DEBUG ONLY --HXT115
282: /*Insert hours to the hxt_hours_worked table and call generate details*/
283: l_retcode := record_hours_worked( FALSE,
284: l_timecard_id,
285: l_emp_rec.assignment_id,

Line 542: HXT_UTIL.DEBUG('Error in hxt_time_clock.log_clock_errors'); --DEBUG ONLY --HXT115

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;
545:
546: WHEN OTHERS THEN

Line 642: HXT_UTIL.DEBUG('Creating new batch'); --DEBUG ONLY --HXT115

638: --END SIR343
639: /* If Not Found */
640: IF l_retcode = 1 THEN
641: /* Create a batch id for the new timecard */
642: HXT_UTIL.DEBUG('Creating new batch'); --DEBUG ONLY --HXT115
643: l_retcode := create_batch( 'C', --source is timeclock
644: i_payroll_id,
645: i_time_period_id,
646: i_assignment_id,

Line 656: HXT_UTIL.DEBUG('Batch id is: '||TO_CHAR(l_batch_id));--DEBUG ONLY --HXT115

652: ELSIF l_retcode = 2 THEN
653: RAISE l_batch_location_error;
654: END IF;
655: g_batch_err_id := l_batch_id;
656: HXT_UTIL.DEBUG('Batch id is: '||TO_CHAR(l_batch_id));--DEBUG ONLY --HXT115
657: /* Generate a unique timecard id for the new timecard */
658: l_timecard_id := hxt_time_gen.Get_HXT_Seqno;
659: IF l_timecard_id = NULL THEN
660: RAISE l_tim_id_creation_error;

Line 662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115

658: l_timecard_id := hxt_time_gen.Get_HXT_Seqno;
659: IF l_timecard_id = NULL THEN
660: RAISE l_tim_id_creation_error;
661: END IF;
662: HXT_UTIL.DEBUG('Timecard id is: '||TO_CHAR(l_timecard_id));--DEBUG ONLY --HXT115
663: /* Insert new timecard info to hxt_timecards */
664: --SIR012 INSERT into hxt_timecards
665: INSERT into hxt_timecards_f --SIR012
666: ( id,

Line 920: HXT_UTIL.get_shift_info(l_hol_rec.holiday_date,

916: l_time_out := NULL;
917: l_time_in := NULL;
918: ELSE
919: IF i_hxt_rotation_plan IS NOT NULL THEN
920: HXT_UTIL.get_shift_info(l_hol_rec.holiday_date,
921: l_work_id,
922: i_hxt_rotation_plan,
923: l_osp_id,
924: l_sdf_id,

Line 951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115

947: END IF;
948: END IF;
949: END IF;
950: --END SIR344
951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115
952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115

Line 952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115

948: END IF;
949: END IF;
950: --END SIR344
951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115
952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115

Line 953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115

949: END IF;
950: --END SIR344
951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115
952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
957: HXT_UTIL.DEBUG(TO_CHAR(l_time_out,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115

Line 955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115

951: HXT_UTIL.DEBUG('The following holiday information was obtained');--DEBUG ONLY --HXT115
952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
957: HXT_UTIL.DEBUG(TO_CHAR(l_time_out,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
958: --END SIR344
959: IF l_hours >= 0 THEN --SIR344

Line 956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115

952: HXT_UTIL.DEBUG(fnd_date.date_to_chardate(l_hol_rec.holiday_date)); --DEBUG ONLY --FORMS60 --HXT115
953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
957: HXT_UTIL.DEBUG(TO_CHAR(l_time_out,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
958: --END SIR344
959: IF l_hours >= 0 THEN --SIR344
960: l_retcode := record_hours_worked( TRUE,

Line 957: HXT_UTIL.DEBUG(TO_CHAR(l_time_out,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115

953: HXT_UTIL.DEBUG(TO_CHAR(l_hol_rec.element_type_id)); --DEBUG ONLY --HXT115
954: --BEGIN SIR344
955: HXT_UTIL.DEBUG(TO_CHAR(l_hours)); --DEBUG ONLY --HXT115
956: HXT_UTIL.DEBUG(TO_CHAR(l_time_in,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
957: HXT_UTIL.DEBUG(TO_CHAR(l_time_out,'MM-DD-YYYY HH24:MI')); --DEBUG ONLY --HXT115
958: --END SIR344
959: IF l_hours >= 0 THEN --SIR344
960: l_retcode := record_hours_worked( TRUE,
961: i_timecard_id,

Line 1105: AND hws.week_day = hxt_util.get_week_day(c_date_worked);

1101: AND hwws.id = hrs.tws_id
1102: AND c_date_worked BETWEEN hwws.date_from
1103: AND NVL (hwws.date_to, c_date_worked)
1104: AND hws.tws_id = hwws.id
1105: AND hws.week_day = hxt_util.get_week_day(c_date_worked);
1106:
1107: l_wsh_det_rec l_wsh_details_cur%ROWTYPE;
1108:
1109: -- ***** End new code Bug 2669059 **************

Line 1114: HXT_UTIL.DEBUG('Opening details Cursor');--DEBUG ONLY --HXT115

1110:
1111: BEGIN
1112: /*Fetch additional assignment details about this employee*/
1113: BEGIN
1114: HXT_UTIL.DEBUG('Opening details Cursor');--DEBUG ONLY --HXT115
1115: OPEN l_details_cur(i_assignment_id, i_date_worked);
1116: HXT_UTIL.DEBUG('Fetching details Cursor');--DEBUG ONLY --HXT115
1117: FETCH l_details_cur
1118: INTO l_det_rec;

Line 1116: HXT_UTIL.DEBUG('Fetching details Cursor');--DEBUG ONLY --HXT115

1112: /*Fetch additional assignment details about this employee*/
1113: BEGIN
1114: HXT_UTIL.DEBUG('Opening details Cursor');--DEBUG ONLY --HXT115
1115: OPEN l_details_cur(i_assignment_id, i_date_worked);
1116: HXT_UTIL.DEBUG('Fetching details Cursor');--DEBUG ONLY --HXT115
1117: FETCH l_details_cur
1118: INTO l_det_rec;
1119: HXT_UTIL.DEBUG('Closing details Cursor');--DEBUG ONLY --HXT115
1120: CLOSE l_details_cur;

Line 1119: HXT_UTIL.DEBUG('Closing details Cursor');--DEBUG ONLY --HXT115

1115: OPEN l_details_cur(i_assignment_id, i_date_worked);
1116: HXT_UTIL.DEBUG('Fetching details Cursor');--DEBUG ONLY --HXT115
1117: FETCH l_details_cur
1118: INTO l_det_rec;
1119: HXT_UTIL.DEBUG('Closing details Cursor');--DEBUG ONLY --HXT115
1120: CLOSE l_details_cur;
1121: --DEBUG ONLY BEGIN
1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115

Line 1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115

1118: INTO l_det_rec;
1119: HXT_UTIL.DEBUG('Closing details Cursor');--DEBUG ONLY --HXT115
1120: CLOSE l_details_cur;
1121: --DEBUG ONLY BEGIN
1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115

Line 1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115

1119: HXT_UTIL.DEBUG('Closing details Cursor');--DEBUG ONLY --HXT115
1120: CLOSE l_details_cur;
1121: --DEBUG ONLY BEGIN
1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115

Line 1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115

1120: CLOSE l_details_cur;
1121: --DEBUG ONLY BEGIN
1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115

Line 1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115

1121: --DEBUG ONLY BEGIN
1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:

Line 1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115

1122: HXT_UTIL.DEBUG('earning policy : '||l_det_rec.hxt_earning_policy);--HXT115
1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:
1130: -- ***** Start commented code for Bug 2669059 **************

Line 1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115

1123: HXT_UTIL.DEBUG('shift differential policy: '||l_det_rec.hxt_shift_differential_policy); --HXT115
1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:
1130: -- ***** Start commented code for Bug 2669059 **************
1131: -- HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_det_rec.off_shift_prem_id)); --HXT115

Line 1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115

1124: HXT_UTIL.DEBUG('hour deduction policy: '||l_det_rec.hxt_hour_deduction_policy); --HXT115
1125: HXT_UTIL.DEBUG('fcl earn type: '||l_det_rec.fcl_earn_type); --HXT115
1126: HXT_UTIL.DEBUG('egt id: '||TO_CHAR(l_det_rec.egt_id)); --HXT115
1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:
1130: -- ***** Start commented code for Bug 2669059 **************
1131: -- HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_det_rec.off_shift_prem_id)); --HXT115
1132: -- HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_det_rec.shift_diff_ovrrd_id)); --HXT115

Line 1131: -- HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_det_rec.off_shift_prem_id)); --HXT115

1127: HXT_UTIL.DEBUG('pep id: '||TO_CHAR(l_det_rec.pep_id)); --HXT115
1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:
1130: -- ***** Start commented code for Bug 2669059 **************
1131: -- HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_det_rec.off_shift_prem_id)); --HXT115
1132: -- HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_det_rec.shift_diff_ovrrd_id)); --HXT115
1133: -- ***** End commented code for Bug 2669059 **************
1134:
1135: --DEBUG ONLY END

Line 1132: -- HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_det_rec.shift_diff_ovrrd_id)); --HXT115

1128: HXT_UTIL.DEBUG('pip id: '||TO_CHAR(l_det_rec.pip_id)); --HXT115
1129:
1130: -- ***** Start commented code for Bug 2669059 **************
1131: -- HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_det_rec.off_shift_prem_id)); --HXT115
1132: -- HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_det_rec.shift_diff_ovrrd_id)); --HXT115
1133: -- ***** End commented code for Bug 2669059 **************
1134:
1135: --DEBUG ONLY END
1136: EXCEPTION

Line 1146: HXT_UTIL.DEBUG('Opening wsh details Cursor');--DEBUG ONLY --HXT115

1142:
1143: -- ***** Start new code for Bug 2669059 **************
1144:
1145: IF l_det_rec.hxt_rotation_plan is not null THEN
1146: HXT_UTIL.DEBUG('Opening wsh details Cursor');--DEBUG ONLY --HXT115
1147: OPEN l_wsh_details_cur(l_det_rec.hxt_rotation_plan,i_date_worked);
1148: HXT_UTIL.DEBUG('Fetching wsh details Cursor');--DEBUG ONLY --HXT115
1149: FETCH l_wsh_details_cur
1150: INTO l_wsh_det_rec;

Line 1148: HXT_UTIL.DEBUG('Fetching wsh details Cursor');--DEBUG ONLY --HXT115

1144:
1145: IF l_det_rec.hxt_rotation_plan is not null THEN
1146: HXT_UTIL.DEBUG('Opening wsh details Cursor');--DEBUG ONLY --HXT115
1147: OPEN l_wsh_details_cur(l_det_rec.hxt_rotation_plan,i_date_worked);
1148: HXT_UTIL.DEBUG('Fetching wsh details Cursor');--DEBUG ONLY --HXT115
1149: FETCH l_wsh_details_cur
1150: INTO l_wsh_det_rec;
1151: HXT_UTIL.DEBUG('Closing wsh details Cursor');--DEBUG ONLY --HXT115
1152: CLOSE l_wsh_details_cur;

Line 1151: HXT_UTIL.DEBUG('Closing wsh details Cursor');--DEBUG ONLY --HXT115

1147: OPEN l_wsh_details_cur(l_det_rec.hxt_rotation_plan,i_date_worked);
1148: HXT_UTIL.DEBUG('Fetching wsh details Cursor');--DEBUG ONLY --HXT115
1149: FETCH l_wsh_details_cur
1150: INTO l_wsh_det_rec;
1151: HXT_UTIL.DEBUG('Closing wsh details Cursor');--DEBUG ONLY --HXT115
1152: CLOSE l_wsh_details_cur;
1153: END IF;
1154:
1155:

Line 1156: HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_wsh_det_rec.off_shift_prem_id)); --HXT115

1152: CLOSE l_wsh_details_cur;
1153: END IF;
1154:
1155:
1156: HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_wsh_det_rec.off_shift_prem_id)); --HXT115
1157: HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_wsh_det_rec.shift_diff_ovrrd_id)); --HXT115
1158:
1159: -- ***** End new code for Bug 2669059 **************
1160:

Line 1157: HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_wsh_det_rec.shift_diff_ovrrd_id)); --HXT115

1153: END IF;
1154:
1155:
1156: HXT_UTIL.DEBUG('off_shift_prem_id: '||TO_CHAR(l_wsh_det_rec.off_shift_prem_id)); --HXT115
1157: HXT_UTIL.DEBUG('shift_diff_ovrrd_id: '||TO_CHAR(l_wsh_det_rec.shift_diff_ovrrd_id)); --HXT115
1158:
1159: -- ***** End new code for Bug 2669059 **************
1160:
1161: /*Flag holidays being generated*/

Line 1172: l_sequence_number := hxt_util.Get_Next_Seqno( i_timecard_id, i_date_worked);

1168: RAISE l_hours_worked_id_error;
1169: END IF;
1170: g_hours_worked_err_id := l_hours_worked_id;
1171: /*Obtain the next sequence number for hours worked on this day*/
1172: l_sequence_number := hxt_util.Get_Next_Seqno( i_timecard_id, i_date_worked);
1173: IF l_sequence_number = NULL THEN
1174: RAISE l_seq_num_error;
1175: END IF;
1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115

Line 1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115

1172: l_sequence_number := hxt_util.Get_Next_Seqno( i_timecard_id, i_date_worked);
1173: IF l_sequence_number = NULL THEN
1174: RAISE l_seq_num_error;
1175: END IF;
1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115
1177: HXT_UTIL.DEBUG('Hours Worked Sequence Number is: '||TO_CHAR(l_sequence_number));--DEBUG ONLY --HXT115
1178: --SIR012 INSERT INTO hxt_sum_hours_worked --C421
1179: INSERT INTO hxt_sum_hours_worked_f --SIR012
1180: ( id,

Line 1177: HXT_UTIL.DEBUG('Hours Worked Sequence Number is: '||TO_CHAR(l_sequence_number));--DEBUG ONLY --HXT115

1173: IF l_sequence_number = NULL THEN
1174: RAISE l_seq_num_error;
1175: END IF;
1176: HXT_UTIL.DEBUG('Hours Worked Id is: '||TO_CHAR(l_hours_worked_id));--DEBUG ONLY --HXT115
1177: HXT_UTIL.DEBUG('Hours Worked Sequence Number is: '||TO_CHAR(l_sequence_number));--DEBUG ONLY --HXT115
1178: --SIR012 INSERT INTO hxt_sum_hours_worked --C421
1179: INSERT INTO hxt_sum_hours_worked_f --SIR012
1180: ( id,
1181: tim_id,

Line 1212: HXT_UTIL.DEBUG('Hours Worked Successfully inserted');--DEBUG ONLY --HXT115

1208: , l_det_rec.hxt_earning_policy --SIR012
1209: , g_sysdate --SIR012
1210: , hr_general.end_of_time); --SIR149 --FORMS60
1211: COMMIT;
1212: HXT_UTIL.DEBUG('Hours Worked Successfully inserted');--DEBUG ONLY --HXT115
1213:
1214: select rowid --SIR012
1215: into l_rowid --SIR012
1216: from HXT_SUM_HOURS_WORKED --SIR012

Line 1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115

1338: i_sql_message IN VARCHAR2)RETURN NUMBER IS
1339: l_error_seqno NUMBER DEFAULT NULL;
1340: l_err_buf VARCHAR2(240); -- HXT11
1341: BEGIN
1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115
1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115
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

Line 1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115

1339: l_error_seqno NUMBER DEFAULT NULL;
1340: l_err_buf VARCHAR2(240); -- HXT11
1341: BEGIN
1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115
1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115
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

Line 1344: HXT_UTIL.DEBUG('g_hours_worked_err_id = ' || TO_CHAR(g_hours_worked_err_id)); --DEBUG ONLY --HXT115

1340: l_err_buf VARCHAR2(240); -- HXT11
1341: BEGIN
1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115
1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115
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;

Line 1345: HXT_UTIL.DEBUG('g_time_period_err_id = ' || g_time_period_err_id); --DEBUG ONLY --HXT115

1341: BEGIN
1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115
1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115
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;

Line 1346: HXT_UTIL.DEBUG(i_error_text || i_sql_message); --DEBUG ONLY --HXT115

1342: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY --HXT115
1343: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY --HXT115
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

Line 1352: HXT_UTIL.DEBUG('TC available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115

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,
1354: g_timecard_err_id,
1355: g_hours_worked_err_id,
1356: g_time_period_err_id,

Line 1353: hxt_util.Gen_Error( g_batch_err_id,

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,
1354: g_timecard_err_id,
1355: g_hours_worked_err_id,
1356: g_time_period_err_id,
1357: i_error_text,

Line 1363: HXT_UTIL.DEBUG('Back from calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115

1359: i_sql_message,
1360: trunc(sysdate), --SIR012
1361: hr_general.end_of_time, --SIR149 --FORMS60
1362: 'ERR'); --HXT11i1
1363: HXT_UTIL.DEBUG('Back from calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115
1364: ELSE
1365: SELECT hxt_seqno.nextval
1366: INTO l_error_seqno
1367: FROM DUAL;

Line 1391: HXT_UTIL.DEBUG('TC not available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115

1387: --SIR12 g_hours_worked_err_id,
1388: --SIR12 g_time_period_err_id,
1389: --SIR12 i_sql_message);
1390:
1391: HXT_UTIL.DEBUG('TC not available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115
1392: HXT_util.Gen_Error( 0, --SIR12
1393: 0, --SIR12
1394: 0, --SIR12
1395: 0, --SIR12

Line 1392: HXT_util.Gen_Error( 0, --SIR12

1388: --SIR12 g_time_period_err_id,
1389: --SIR12 i_sql_message);
1390:
1391: HXT_UTIL.DEBUG('TC not available. Calling hxt_util.Gen_error'); --DEBUG ONLY --HXT115
1392: HXT_util.Gen_Error( 0, --SIR12
1393: 0, --SIR12
1394: 0, --SIR12
1395: 0, --SIR12
1396: i_error_text, --SIR12