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_RETRO_PA dependencies on HXT_UTIL

Line 71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115

67: FOR l_timecard_rec IN l_timecard_cur( i_payroll_id, i_time_period_id) LOOP
68: g_batch_err_id := l_timecard_rec.batch_id;
69: g_err_effective_start := l_timecard_rec.effective_start_date;
70: g_err_effective_end := l_timecard_rec.effective_end_date;
71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115
72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));
74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||

Line 72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));

68: g_batch_err_id := l_timecard_rec.batch_id;
69: g_err_effective_start := l_timecard_rec.effective_start_date;
70: g_err_effective_end := l_timecard_rec.effective_end_date;
71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115
72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));
74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||
76: fnd_date.date_to_chardate(l_timecard_rec.end_date));

Line 73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));

69: g_err_effective_start := l_timecard_rec.effective_start_date;
70: g_err_effective_end := l_timecard_rec.effective_end_date;
71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115
72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));
74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||
76: fnd_date.date_to_chardate(l_timecard_rec.end_date));
77:

Line 74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));

70: g_err_effective_end := l_timecard_rec.effective_end_date;
71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115
72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));
74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||
76: fnd_date.date_to_chardate(l_timecard_rec.end_date));
77:
78: BEGIN --timecard error block

Line 75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||

71: HXT_UTIL.DEBUG('.'); --DEBUG ONLY --HXT115
72: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
73: HXT_UTIL.DEBUG('l_timecard_rec.batch_id = ' || TO_CHAR(l_timecard_rec.batch_id));
74: HXT_UTIL.DEBUG('l_timecard_rec.time_period_id = ' || TO_CHAR(l_timecard_rec.time_period_id));
75: HXT_UTIL.DEBUG('l_timecard_rec.end_date = ' ||
76: fnd_date.date_to_chardate(l_timecard_rec.end_date));
77:
78: BEGIN --timecard error block
79:

Line 85: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));

81: -- set id's related to each timecard for error messaging
82: g_timecard_err_id := l_timecard_rec.id;
83: g_time_period_err_id := l_timecard_rec.time_period_id;
84:
85: HXT_UTIL.DEBUG('l_timecard_rec.id = ' || TO_CHAR(l_timecard_rec.id));
86:
87: -- Clean up existing transfer to PA errors for this payroll/period
88: DELETE
89: FROM hxt_errors_f errf

Line 190: HXT_UTIL.DEBUG('Retro details successfully transferred!');

186: RAISE l_no_timecards;
187: END IF;
188:
189: o_ret_code := 0;
190: HXT_UTIL.DEBUG('Retro details successfully transferred!');
191:
192: EXCEPTION
193: WHEN l_conc_error THEN
194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');

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

194: FND_MESSAGE.SET_NAME('HXT','HXT_39456_CHK_TCARD_ERRS');
195: o_err_buf := FND_MESSAGE.GET;
196: FND_MESSAGE.CLEAR;
197: o_ret_code := 2;
198: HXT_UTIL.DEBUG('Check timecards for errors or run timecard report.');
199: RETURN;
200: WHEN l_no_timecards THEN
201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
202: o_err_buf := FND_MESSAGE.GET;

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

201: FND_MESSAGE.SET_NAME('HXT','HXT_39457_NO_TCARD_4_PAY_PRD');
202: o_err_buf := FND_MESSAGE.GET;
203: FND_MESSAGE.CLEAR;
204: o_ret_code := 2;
205: HXT_UTIL.DEBUG('No timecards located for this payroll');
206: RETURN;
207: WHEN l_no_details THEN
208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
209: o_err_buf := FND_MESSAGE.GET;

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

208: FND_MESSAGE.SET_NAME('HXT','HXT_39458_NO_TCARD_DET_XFER');
209: o_err_buf := FND_MESSAGE.GET;
210: FND_MESSAGE.CLEAR;
211: o_ret_code := 0;
212: HXT_UTIL.DEBUG('No timecard details transferable');
213: RETURN;
214: WHEN g_error_log_error THEN
215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
216: o_err_buf := FND_MESSAGE.GET;

Line 218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');

214: WHEN g_error_log_error THEN
215: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
216: o_err_buf := FND_MESSAGE.GET;
217: FND_MESSAGE.CLEAR;
218: HXT_UTIL.DEBUG('Error in hxt_retro_pa.log_transfer_errors.');
219: o_ret_code := 2;
220: RETURN;
221: WHEN OTHERS THEN
222: l_location := 'hxt_retro_pa';

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

228: o_ret_code := 2;
229: FND_MESSAGE.SET_NAME('HXT','HXT_39460_HXTRPA_ERR');
230: o_err_buf := FND_MESSAGE.GET;
231: FND_MESSAGE.CLEAR;
232: HXT_UTIL.DEBUG('Error processing timecard for PA Transfer');
233: RETURN;
234: END retro_pa_process;
235: /************************************************************************************************
236: non_eff_wage_rate_transfer()

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

483:
484: BEGIN
485:
486: -- Loop to process all summary records for this assignment
487: HXT_UTIL.DEBUG('Processing NON-EWR time'); --HXT115
488: FOR l_sum_rec IN l_sum_cur(i_timecard_id) LOOP
489:
490: g_err_effective_start := l_sum_rec.effective_start_date;
491: g_err_effective_end := l_sum_rec.effective_end_date;

Line 509: HXT_UTIL.DEBUG('Employee '||i_employee_number||

505: l_rate := l_non_rec.proposed_salary;
506: END IF;
507: l_standard_rate := l_rate;
508:
509: HXT_UTIL.DEBUG('Employee '||i_employee_number||
510: ' timecard '||TO_CHAR(i_timecard_id) ||' assignment id of '||
511: TO_CHAR(l_non_rec.assignment_id));
512: HXT_UTIL.DEBUG('Normal Hourly Rate for '||i_employee_number||' is: '
513: ||TO_CHAR(l_rate));

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

508:
509: HXT_UTIL.DEBUG('Employee '||i_employee_number||
510: ' timecard '||TO_CHAR(i_timecard_id) ||' assignment id of '||
511: TO_CHAR(l_non_rec.assignment_id));
512: HXT_UTIL.DEBUG('Normal Hourly Rate for '||i_employee_number||' is: '
513: ||TO_CHAR(l_rate));
514:
515: -- Take the override rate when one exists
516: IF l_non_rec.hourly_rate IS NOT NULL THEN

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

514:
515: -- Take the override rate when one exists
516: IF l_non_rec.hourly_rate IS NOT NULL THEN
517: l_rate := l_non_rec.hourly_rate;
518: HXT_UTIL.DEBUG('Using Override Hourly Rate of '||TO_CHAR(l_rate));
519: END IF;
520:
521: -- Process Base Hours
522: IF l_non_rec.hxt_earning_category IN ('ABS','OVT','REG') THEN

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

523: -- BEGIN SIR#5
524: -- Handle Flat Amounts on Base Hours Types
525: IF l_non_rec.amount IS NOT NULL THEN
526: l_premium_amount := l_non_rec.amount;
527: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'
528: ||TO_CHAR(l_premium_amount)||
529: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
530: ELSE
531: l_premium_amount := NULL;

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

535: -- Use the manually entered multiple when one exists
536: -- else, use the multiple from the element descriptive flex
537: IF l_non_rec.rate_multiple IS NOT NULL THEN
538: l_rate := l_rate * l_non_rec.rate_multiple;
539: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)
540: ||'Sending Overtime FACTOR/manual multiple rate:'||
541: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','
542: ||' hours:'||TO_CHAR(l_non_rec.hours));
543: ELSE

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

541: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','
542: ||' hours:'||TO_CHAR(l_non_rec.hours));
543: ELSE
544: l_rate := l_rate * l_non_rec.hxt_premium_amount;
545: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)
546: ||'Sending Overtime FACTOR/element premium rate:'||
547: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','||' hours:'
548: ||TO_CHAR(l_non_rec.hours));
549: END IF;

Line 552: HXT_UTIL.DEBUG('Sending Overtime RATE/element premium rate:'

548: ||TO_CHAR(l_non_rec.hours));
549: END IF;
550: ELSIF l_non_rec.hxt_premium_type = 'RATE' THEN
551: l_rate := l_non_rec.hxt_premium_amount;
552: HXT_UTIL.DEBUG('Sending Overtime RATE/element premium rate:'
553: ||TO_CHAR(l_rate)||
554: ' '||l_non_rec.element_name||','||' hours:'
555: ||TO_CHAR(l_non_rec.hours));
556: ELSE -- FIXED amount per day

Line 558: HXT_UTIL.DEBUG('Sending Overtime Flat/element premium rate:'

554: ' '||l_non_rec.element_name||','||' hours:'
555: ||TO_CHAR(l_non_rec.hours));
556: ELSE -- FIXED amount per day
557: l_rate := l_non_rec.hxt_premium_amount / l_non_rec.hours;
558: HXT_UTIL.DEBUG('Sending Overtime Flat/element premium rate:'
559: ||TO_CHAR(l_rate)||
560: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
561: END IF;
562: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN

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

559: ||TO_CHAR(l_rate)||
560: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
561: END IF;
562: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
563: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
564: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
565: ELSE
566: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
567: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));

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

562: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
563: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
564: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
565: ELSE
566: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
567: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
568: END IF; -- ABS,OVT,REG
569: END IF; -- IS amount NULL ?
570:

Line 588: HXT_UTIL.DEBUG('This transaction is an adjustment for '

584: -- Send adjusting enties to Project Accounting when only the hours have changed
585: IF l_expired_cur%FOUND THEN
586: -- Ignore identical entries, set these to 'D' for dead
587: IF l_non_rec.hours <> l_expired_rec.hours THEN
588: HXT_UTIL.DEBUG('This transaction is an adjustment for '
589: ||TO_CHAR(l_non_rec.hours - l_expired_rec.hours)||' hours');
590: l_retcode := hxt_pa_user_exits.p_a_interface
591: (l_non_rec.hours - l_expired_rec.hours,
592: l_rate,

Line 652: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours'); --HXT115

648:
649: CLOSE l_expired_cur;
650: -- Pass a normal entry to Project Accounting for the retro rows
651:
652: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours'); --HXT115
653: l_retcode := hxt_pa_user_exits.p_a_interface
654: (l_non_rec.hours,
655: l_rate,
656: l_premium_amount, --SIR#5

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

692: -- Use the manually entered multiple when one exists
693: -- else, use the multiple from the element descriptive flex
694: IF l_non_rec.rate_multiple IS NOT NULL THEN
695: l_rate := l_rate * l_non_rec.rate_multiple;
696: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)
697: ||'Sending Premium FACTOR/manual multiple rate:'||
698: TO_CHAR(l_rate)||' '||l_non_rec.element_name
699: ||','||' hours:'||TO_CHAR(l_non_rec.hours));
700: ELSE

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

700: ELSE
701: -- When the element flex value is used,
702: -- Factor premiums are calculated by multiplying the (rate x (premium - 1) x hours)
703: l_rate := l_rate * (l_non_rec.hxt_premium_amount - 1);
704: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)
705: ||'Sending Premium FACTOR/element premium rate:'||
706: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','
707: ||' hours:'||TO_CHAR(l_non_rec.hours));
708: END IF;

Line 717: HXT_UTIL.DEBUG('Sending Premium RATE/element premium rate:'

713: -- Use the Hourly Rate(override rate) entered by the user,
714: -- if one has been entered
715: IF l_non_rec.hourly_rate IS NOT NULL THEN
716: l_rate := l_non_rec.hourly_rate;
717: HXT_UTIL.DEBUG('Sending Premium RATE/element premium rate:'
718: ||TO_CHAR(l_rate)||
719: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
720: -- Use the rate entered on the Pay Element flex segment
721: ELSE

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

719: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
720: -- Use the rate entered on the Pay Element flex segment
721: ELSE
722: l_rate := l_non_rec.hxt_premium_amount;
723: HXT_UTIL.DEBUG('Sending Premium /element premium rate:'||TO_CHAR(l_rate)||
724: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
725: END IF;
726: l_premium_hours := l_non_rec.hours;
727: l_premium_amount := NULL;

Line 733: HXT_UTIL.DEBUG('Sending Premium Flat/element premium amount:'

729: ELSE
730: -- If no amount was entered, Assign the premium attached to the Pay Element
731: IF l_non_rec.amount IS NULL THEN
732: l_premium_amount := l_non_rec.hxt_premium_amount;
733: HXT_UTIL.DEBUG('Sending Premium Flat/element premium amount:'
734: ||TO_CHAR(l_premium_amount)||
735: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
736:
737: --Else, take the override premium amount entered on the timecard

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

736:
737: --Else, take the override premium amount entered on the timecard
738: ELSE
739: l_premium_amount := l_non_rec.amount;
740: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'
741: ||TO_CHAR(l_premium_amount)||
742: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
743:
744: END IF;

Line 766: HXT_UTIL.DEBUG('This is an adjusting entry for '

762: IF l_expired_cur%FOUND THEN
763: -- pickup changed hours entries
764: IF NVL(l_non_rec.hours,-1) <> NVL(l_expired_rec.hours,-1) THEN
765:
766: HXT_UTIL.DEBUG('This is an adjusting entry for '
767: ||to_char(l_non_rec.hours - l_expired_rec.hours)||' hours');
768: l_retcode := hxt_pa_user_exits.p_a_interface
769: (l_non_rec.hours - l_expired_rec.hours,
770: l_rate,

Line 827: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours');

823: --Send a new retro transaction to Project Accounting because vital data has changed
824: ELSE
825:
826: CLOSE l_expired_cur;
827: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours');
828: l_retcode := hxt_pa_user_exits.p_a_interface
829: (l_premium_hours,
830: l_rate,
831: l_premium_amount,

Line 900: HXT_UTIL.DEBUG('Sending backout for amount entered on timecard, amount:'

896: -- BEGIN SIR#5
897: -- Handle Flat Amounts on Base Hours Types
898: IF l_backout_rec.amount IS NOT NULL THEN
899: l_backout_amount := l_backout_rec.amount * -1;
900: HXT_UTIL.DEBUG('Sending backout for amount entered on timecard, amount:'
901: ||TO_CHAR(l_backout_amount)||
902: ' '||l_backout_rec.element_name||','||' hours:'||TO_CHAR(l_backout_rec.hours));
903: ELSE
904: l_backout_amount := NULL;

Line 921: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_rec.hours)||' hours');

917: ELSE -- FIXED amount per day
918: l_rate := l_backout_rec.hxt_premium_amount / l_backout_rec.hours;
919: END IF;
920: END IF;
921: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_rec.hours)||' hours');
922: END IF; -- IS AMOUNT NULL? SIR#5
923:
924: l_retcode := hxt_pa_user_exits.p_a_interface
925: (l_backout_rec.hours * -1,

Line 997: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_hours)||' hours');

993: l_backout_hours := NULL;
994: l_rate := NULL;
995: END IF; -- premium calculations
996:
997: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_hours)||' hours');
998: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_amount)||' amount');
999: l_retcode := hxt_pa_user_exits.p_a_interface
1000: (l_backout_hours,
1001: l_rate,

Line 998: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_amount)||' amount');

994: l_rate := NULL;
995: END IF; -- premium calculations
996:
997: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_hours)||' hours');
998: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_amount)||' amount');
999: l_retcode := hxt_pa_user_exits.p_a_interface
1000: (l_backout_hours,
1001: l_rate,
1002: l_backout_amount,

Line 1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));

1077: i_error_text IN VARCHAR2,
1078: i_system_text IN VARCHAR2)RETURN NUMBER IS
1079: BEGIN
1080:
1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);

Line 1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));

1078: i_system_text IN VARCHAR2)RETURN NUMBER IS
1079: BEGIN
1080:
1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);

Line 1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);

1079: BEGIN
1080:
1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);

Line 1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));

1080:
1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1088:

Line 1085: HXT_UTIL.DEBUG('i_location = ' || i_location);

1081: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1088:
1089: hxt_util.Gen_Error(g_batch_err_id,

Line 1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);

1082: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1088:
1089: hxt_util.Gen_Error(g_batch_err_id,
1090: g_timecard_err_id,

Line 1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);

1083: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1084: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1088:
1089: hxt_util.Gen_Error(g_batch_err_id,
1090: g_timecard_err_id,
1091: g_sum_hours_err_id,

Line 1089: hxt_util.Gen_Error(g_batch_err_id,

1085: HXT_UTIL.DEBUG('i_location = ' || i_location);
1086: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1087: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1088:
1089: hxt_util.Gen_Error(g_batch_err_id,
1090: g_timecard_err_id,
1091: g_sum_hours_err_id,
1092: g_time_period_err_id,
1093: i_error_text,