DBA Data[Home] [Help]

APPS.HXT_TRAN_PA dependencies on HXT_UTIL

Line 79: HXT_UTIL.DEBUG('Selecting Cursor'); --DEBUG ONLY --HXT115

75: if g_debug then
76: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',10);
77: end if;
78:
79: HXT_UTIL.DEBUG('Selecting Cursor'); --DEBUG ONLY --HXT115
80:
81: -- select each timecard within the payroll/time-period
82:
83: FOR l_timecard_rec IN l_timecard_cur( i_payroll_id, i_time_period_id) LOOP

Line 112: HXT_UTIL.DEBUG('.'); --DEBUG ONLY

108: hr_utility.trace('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
109: hr_utility.trace('l_timecard_rec.end_date = ' || TO_CHAR(l_timecard_rec.end_date));
110: end if;
111:
112: HXT_UTIL.DEBUG('.'); --DEBUG ONLY
113: HXT_UTIL.DEBUG('l_timecard_rec.id = ' ||
114: TO_CHAR(l_timecard_rec.id)); --DEBUG ONLY
115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '
116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY

Line 113: HXT_UTIL.DEBUG('l_timecard_rec.id = ' ||

109: hr_utility.trace('l_timecard_rec.end_date = ' || TO_CHAR(l_timecard_rec.end_date));
110: end if;
111:
112: HXT_UTIL.DEBUG('.'); --DEBUG ONLY
113: HXT_UTIL.DEBUG('l_timecard_rec.id = ' ||
114: TO_CHAR(l_timecard_rec.id)); --DEBUG ONLY
115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '
116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY
117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '

Line 115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '

111:
112: HXT_UTIL.DEBUG('.'); --DEBUG ONLY
113: HXT_UTIL.DEBUG('l_timecard_rec.id = ' ||
114: TO_CHAR(l_timecard_rec.id)); --DEBUG ONLY
115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '
116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY
117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '
118: || TO_CHAR(l_timecard_rec.time_period_id)); --DEBUG ONLY
119: HXT_UTIL.DEBUG('l_timecard_rec.end_date = '

Line 117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '

113: HXT_UTIL.DEBUG('l_timecard_rec.id = ' ||
114: TO_CHAR(l_timecard_rec.id)); --DEBUG ONLY
115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '
116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY
117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '
118: || TO_CHAR(l_timecard_rec.time_period_id)); --DEBUG ONLY
119: HXT_UTIL.DEBUG('l_timecard_rec.end_date = '
120: || fnd_date.date_to_chardate(l_timecard_rec.end_date)); --DEBUG ONLY
121:

Line 119: HXT_UTIL.DEBUG('l_timecard_rec.end_date = '

115: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = '
116: || TO_CHAR(l_timecard_rec.batch_id)); --DEBUG ONLY
117: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = '
118: || TO_CHAR(l_timecard_rec.time_period_id)); --DEBUG ONLY
119: HXT_UTIL.DEBUG('l_timecard_rec.end_date = '
120: || fnd_date.date_to_chardate(l_timecard_rec.end_date)); --DEBUG ONLY
121:
122: -- Clean up existing transfer to PA errors for this payroll/period
123: DELETE

Line 242: HXT_UTIL.DEBUG('Time details successfully transferred!');

238: o_ret_code := 0;
239: FND_MESSAGE.SET_NAME('HXT','HXT_39455_DET_XFER_SUCCESS');
240: o_err_buf := FND_MESSAGE.GET;
241: FND_MESSAGE.CLEAR;
242: HXT_UTIL.DEBUG('Time details successfully transferred!');
243: EXCEPTION
244: WHEN l_conc_error THEN
245: if g_debug then
246: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',130);

Line 252: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');

248: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
249: o_err_buf := FND_MESSAGE.GET;
250: FND_MESSAGE.CLEAR;
251: o_ret_code := 2;
252: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
253: RETURN;
254: WHEN l_no_timecards THEN
255: if g_debug then
256: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',140);

Line 263: HXT_UTIL.DEBUG('No timecards located for this payroll');

259: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
260: o_err_buf := FND_MESSAGE.GET;
261: FND_MESSAGE.CLEAR;
262: o_ret_code := 2;
263: HXT_UTIL.DEBUG('No timecards located for this payroll');
264: RETURN;
265: WHEN l_no_details THEN
266: if g_debug then
267: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',150);

Line 274: HXT_UTIL.DEBUG('No timecard details transferable');

270: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
271: o_err_buf := FND_MESSAGE.GET;
272: FND_MESSAGE.CLEAR;
273: o_ret_code := 0;
274: HXT_UTIL.DEBUG('No timecard details transferable');
275: RETURN;
276: WHEN g_error_log_error THEN
277: if g_debug then
278: hr_utility.set_location('HXT_TRAN_PA.transfer_timecards',160);

Line 283: HXT_UTIL.DEBUG('Error in hxt_tran_pa.log_transfer_errors.');

279: end if;
280: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
281: o_err_buf := FND_MESSAGE.GET;
282: FND_MESSAGE.CLEAR;
283: HXT_UTIL.DEBUG('Error in hxt_tran_pa.log_transfer_errors.');
284: o_ret_code := 2;
285: RETURN;
286: WHEN OTHERS THEN
287: if g_debug then

Line 300: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');

296: o_ret_code := 2;
297: FND_MESSAGE.SET_NAME('HXT','HXT_39459_HXTPA_ERR');
298: o_err_buf := FND_MESSAGE.GET;
299: FND_MESSAGE.CLEAR;
300: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
301: RETURN;
302: END transfer_timecards;
303:
304: /***********************************************************************************

Line 410: HXT_UTIL.DEBUG('Processing NON-EWR time');

406: g_debug :=hr_utility.debug_enabled;
407: if g_debug then
408: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',10);
409: end if;
410: HXT_UTIL.DEBUG('Processing NON-EWR time');
411:
412: --Process all eligible time detail rows for this timecard
413: FOR l_non_rec IN l_non_cur(i_timecard_id) LOOP
414: if g_debug then

Line 417: HXT_UTIL.DEBUG(' in the loop');

413: FOR l_non_rec IN l_non_cur(i_timecard_id) LOOP
414: if g_debug then
415: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',20);
416: end if;
417: HXT_UTIL.DEBUG(' in the loop');
418: g_err_effective_start := l_non_rec.effective_start_date;
419: g_err_effective_end := l_non_rec.effective_end_date;
420: g_sum_hours_err_id := l_non_rec.sum_id;
421:

Line 451: HXT_UTIL.DEBUG('Employee '||i_employee_number|| --HXT115

447: l_rate := l_non_rec.proposed_salary;
448: END IF;
449: l_standard_rate := l_rate;
450:
451: HXT_UTIL.DEBUG('Employee '||i_employee_number|| --HXT115
452: ' timecard '||TO_CHAR(i_timecard_id) ||' assignment id of '||
453: TO_CHAR(l_non_rec.assignment_id));
454: HXT_UTIL.DEBUG('Normal Hourly Rate for '||i_employee_number||' is: '
455: ||TO_CHAR(l_rate));

Line 454: HXT_UTIL.DEBUG('Normal Hourly Rate for '||i_employee_number||' is: '

450:
451: HXT_UTIL.DEBUG('Employee '||i_employee_number|| --HXT115
452: ' timecard '||TO_CHAR(i_timecard_id) ||' assignment id of '||
453: TO_CHAR(l_non_rec.assignment_id));
454: HXT_UTIL.DEBUG('Normal Hourly Rate for '||i_employee_number||' is: '
455: ||TO_CHAR(l_rate));
456: -- Take the override rate when one exists
457: IF l_non_rec.hourly_rate IS NOT NULL THEN
458: if g_debug then

Line 462: HXT_UTIL.DEBUG('Using Override Hourly Rate of '||TO_CHAR(l_rate));

458: if g_debug then
459: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',70);
460: end if;
461: l_rate := l_non_rec.hourly_rate;
462: HXT_UTIL.DEBUG('Using Override Hourly Rate of '||TO_CHAR(l_rate));
463: END IF;
464:
465: -- Process Base Hours
466: IF l_non_rec.hxt_earning_category IN ('ABS','OVT','REG') THEN

Line 476: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'

472: if g_debug then
473: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',90);
474: end if;
475: l_premium_amount := l_non_rec.amount;
476: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'
477: ||TO_CHAR(l_premium_amount)||
478: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
479: ELSE
480: if g_debug then

Line 500: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)

496: if g_debug then
497: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',130);
498: end if;
499: l_rate := l_rate * l_non_rec.rate_multiple;
500: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)
501: ||'Sending Overtime FACTOR/manual multiple rate:'|| TO_CHAR(l_rate)
502: ||' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
503: ELSE
504: if g_debug then

Line 508: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)

504: if g_debug then
505: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',140);
506: end if;
507: l_rate := l_rate * l_non_rec.hxt_premium_amount;
508: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)
509: ||'Sending Overtime FACTOR/element premium rate:'||
510: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','||' hours:'
511: ||TO_CHAR(l_non_rec.hours));
512: END IF;

Line 518: HXT_UTIL.DEBUG('Sending Overtime RATE/element premium rate:'||TO_CHAR(l_rate)||

514: if g_debug then
515: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',150);
516: end if;
517: l_rate := l_non_rec.hxt_premium_amount;
518: HXT_UTIL.DEBUG('Sending Overtime RATE/element premium rate:'||TO_CHAR(l_rate)||
519: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
520: ELSE -- FIXED amount per day
521: if g_debug then
522: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',160);

Line 525: HXT_UTIL.DEBUG('Sending Overtime Flat/element premium rate:'||TO_CHAR(l_rate)||

521: if g_debug then
522: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',160);
523: end if;
524: l_rate := l_non_rec.hxt_premium_amount / l_non_rec.hours;
525: HXT_UTIL.DEBUG('Sending Overtime Flat/element premium rate:'||TO_CHAR(l_rate)||
526: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
527: END IF;
528: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
529: if g_debug then

Line 532: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||

528: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
529: if g_debug then
530: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',170);
531: end if;
532: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
533: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
534: ELSE
535: if g_debug then
536: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',180);

Line 538: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)|| --HXT115

534: ELSE
535: if g_debug then
536: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',180);
537: end if;
538: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)|| --HXT115
539: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
540: END IF;
541: END IF; --End Amount NULL? SIR#5
542:

Line 600: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)

596: if g_debug then
597: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',230);
598: end if;
599: l_rate := l_rate * l_non_rec.rate_multiple;
600: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)
601: ||'Sending Premium FACTOR/manual multiple rate:'||
602: TO_CHAR(l_rate)||' '||l_non_rec.element_name
603: ||','||' hours:'||TO_CHAR(l_non_rec.hours));
604: ELSE

Line 611: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)||

607: end if;
608: -- When the element flex value is used,
609: -- Factor premiums are calculated by multiplying the (rate x (premium - 1) x hours)
610: l_rate := l_rate * (l_non_rec.hxt_premium_amount - 1);
611: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)||
612: 'Sending Premium FACTOR/element premium rate:'||
613: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','||' hours:'
614: ||TO_CHAR(l_non_rec.hours));
615: END IF;

Line 627: HXT_UTIL.DEBUG('Sending Premium RATE/element premium rate:'||TO_CHAR(l_rate)||

623: if g_debug then
624: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',260);
625: end if;
626: l_rate := l_non_rec.hourly_rate;
627: HXT_UTIL.DEBUG('Sending Premium RATE/element premium rate:'||TO_CHAR(l_rate)||
628: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
629: -- Use the rate entered on the Pay Element flex segment
630: ELSE
631: if g_debug then

Line 635: HXT_UTIL.DEBUG('Sending Premium Flat/element premium rate:'||TO_CHAR(l_rate)||

631: if g_debug then
632: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',270);
633: end if;
634: l_rate := l_non_rec.hxt_premium_amount;
635: HXT_UTIL.DEBUG('Sending Premium Flat/element premium rate:'||TO_CHAR(l_rate)||
636: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
637: END IF;
638: -- FIXED amount premium
639: ELSE

Line 649: HXT_UTIL.DEBUG('Sending Premium Flat/element premium amount:'||TO_CHAR(l_premium_amount)

645: if g_debug then
646: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',290);
647: end if;
648: l_premium_amount := l_non_rec.hxt_premium_amount;
649: HXT_UTIL.DEBUG('Sending Premium Flat/element premium amount:'||TO_CHAR(l_premium_amount)
650: || ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
651: -- Else, take the override premium amount entered on the timecard
652: ELSE
653: if g_debug then

Line 657: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'

653: if g_debug then
654: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',300);
655: end if;
656: l_premium_amount := l_non_rec.amount;
657: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'
658: ||TO_CHAR(l_premium_amount)||
659: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
660: END IF;
661: if g_debug then

Line 734: HXT_UTIL.DEBUG('exception in non_eff_wage: '||SQLERRM);

730: WHEN OTHERS THEN
731: if g_debug then
732: hr_utility.set_location('HXT_TRAN_PA.non_eff_wage_rate_transfer',370);
733: end if;
734: HXT_UTIL.DEBUG('exception in non_eff_wage: '||SQLERRM);
735: o_location := 'hxt_tran_pa.non_eff_wage_rate_transfer';
736: o_error_text := NULL;
737: o_system_text := SQLERRM;
738: RETURN 1;

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

748: g_debug :=hr_utility.debug_enabled;
749: if g_debug then
750: hr_utility.set_location('HXT_TRAN_PA.log_transfer_errors',10);
751: end if;
752: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY
753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY

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

749: if g_debug then
750: hr_utility.set_location('HXT_TRAN_PA.log_transfer_errors',10);
751: end if;
752: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY
753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY

Line 754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY

750: hr_utility.set_location('HXT_TRAN_PA.log_transfer_errors',10);
751: end if;
752: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY
753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY

Line 755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY

751: end if;
752: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY
753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY
759: hxt_util.Gen_Error(g_batch_err_id,

Line 756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY

752: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id)); --DEBUG ONLY
753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY
759: hxt_util.Gen_Error(g_batch_err_id,
760: g_timecard_err_id,

Line 757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY

753: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id)); --DEBUG ONLY
754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY
759: hxt_util.Gen_Error(g_batch_err_id,
760: g_timecard_err_id,
761: g_sum_hours_err_id,

Line 758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY

754: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id); --DEBUG ONLY
755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY
759: hxt_util.Gen_Error(g_batch_err_id,
760: g_timecard_err_id,
761: g_sum_hours_err_id,
762: g_time_period_err_id,

Line 759: hxt_util.Gen_Error(g_batch_err_id,

755: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id)); --DEBUG ONLY
756: HXT_UTIL.DEBUG('i_location = ' || i_location); --DEBUG ONLY
757: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text); --DEBUG ONLY
758: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text); --DEBUG ONLY
759: hxt_util.Gen_Error(g_batch_err_id,
760: g_timecard_err_id,
761: g_sum_hours_err_id,
762: g_time_period_err_id,
763: i_error_text,