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 560: HXT_UTIL.DEBUG('l_non_rec.hours ::'||l_non_rec.hours);

556: ELSE -- FIXED amount per day
557:
558: -- Added for Bug 14028853
559:
560: HXT_UTIL.DEBUG('l_non_rec.hours ::'||l_non_rec.hours);
561: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_type ::'||l_non_rec.hxt_premium_type);
562: HXT_UTIL.DEBUG('l_rate ::'||l_rate);
563: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_amount ::'||l_non_rec.hxt_premium_amount);
564:

Line 561: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_type ::'||l_non_rec.hxt_premium_type);

557:
558: -- Added for Bug 14028853
559:
560: HXT_UTIL.DEBUG('l_non_rec.hours ::'||l_non_rec.hours);
561: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_type ::'||l_non_rec.hxt_premium_type);
562: HXT_UTIL.DEBUG('l_rate ::'||l_rate);
563: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_amount ::'||l_non_rec.hxt_premium_amount);
564:
565: IF l_non_rec.hours = 0 THEN

Line 562: HXT_UTIL.DEBUG('l_rate ::'||l_rate);

558: -- Added for Bug 14028853
559:
560: HXT_UTIL.DEBUG('l_non_rec.hours ::'||l_non_rec.hours);
561: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_type ::'||l_non_rec.hxt_premium_type);
562: HXT_UTIL.DEBUG('l_rate ::'||l_rate);
563: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_amount ::'||l_non_rec.hxt_premium_amount);
564:
565: IF l_non_rec.hours = 0 THEN
566: l_rate := 0;

Line 563: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_amount ::'||l_non_rec.hxt_premium_amount);

559:
560: HXT_UTIL.DEBUG('l_non_rec.hours ::'||l_non_rec.hours);
561: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_type ::'||l_non_rec.hxt_premium_type);
562: HXT_UTIL.DEBUG('l_rate ::'||l_rate);
563: HXT_UTIL.DEBUG('l_non_rec.hxt_premium_amount ::'||l_non_rec.hxt_premium_amount);
564:
565: IF l_non_rec.hours = 0 THEN
566: l_rate := 0;
567: ELSE

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

567: ELSE
568: l_rate := l_non_rec.hxt_premium_amount / l_non_rec.hours;
569: END IF;
570:
571: HXT_UTIL.DEBUG('Sending Overtime Flat/element premium rate:'
572: ||TO_CHAR(l_rate)||
573: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
574: END IF;
575: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN

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

572: ||TO_CHAR(l_rate)||
573: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
574: END IF;
575: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
576: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
577: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
578: ELSE
579: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
580: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));

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

575: ELSIF l_non_rec.hxt_earning_category = 'ABS' THEN
576: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
577: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
578: ELSE
579: HXT_UTIL.DEBUG('Sending Time at: rate:'||TO_CHAR(l_rate)||
580: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
581: END IF; -- ABS,OVT,REG
582: END IF; -- IS amount NULL ?
583:

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

597: -- Send adjusting enties to Project Accounting when only the hours have changed
598: IF l_expired_cur%FOUND THEN
599: -- Ignore identical entries, set these to 'D' for dead
600: IF l_non_rec.hours <> l_expired_rec.hours THEN
601: HXT_UTIL.DEBUG('This transaction is an adjustment for '
602: ||TO_CHAR(l_non_rec.hours - l_expired_rec.hours)||' hours');
603: l_retcode := hxt_pa_user_exits.p_a_interface
604: (l_non_rec.hours - l_expired_rec.hours,
605: l_rate,

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

661:
662: CLOSE l_expired_cur;
663: -- Pass a normal entry to Project Accounting for the retro rows
664:
665: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours'); --HXT115
666: l_retcode := hxt_pa_user_exits.p_a_interface
667: (l_non_rec.hours,
668: l_rate,
669: l_premium_amount, --SIR#5

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

705: -- Use the manually entered multiple when one exists
706: -- else, use the multiple from the element descriptive flex
707: IF l_non_rec.rate_multiple IS NOT NULL THEN
708: l_rate := l_rate * l_non_rec.rate_multiple;
709: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.rate_multiple)
710: ||'Sending Premium FACTOR/manual multiple rate:'||
711: TO_CHAR(l_rate)||' '||l_non_rec.element_name
712: ||','||' hours:'||TO_CHAR(l_non_rec.hours));
713: ELSE

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

713: ELSE
714: -- When the element flex value is used,
715: -- Factor premiums are calculated by multiplying the (rate x (premium - 1) x hours)
716: l_rate := l_rate * (l_non_rec.hxt_premium_amount - 1);
717: HXT_UTIL.DEBUG(TO_CHAR(l_non_rec.hxt_premium_amount)
718: ||'Sending Premium FACTOR/element premium rate:'||
719: TO_CHAR(l_rate)||' '||l_non_rec.element_name||','
720: ||' hours:'||TO_CHAR(l_non_rec.hours));
721: END IF;

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

726: -- Use the Hourly Rate(override rate) entered by the user,
727: -- if one has been entered
728: IF l_non_rec.hourly_rate IS NOT NULL THEN
729: l_rate := l_non_rec.hourly_rate;
730: HXT_UTIL.DEBUG('Sending Premium RATE/element premium rate:'
731: ||TO_CHAR(l_rate)||
732: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
733: -- Use the rate entered on the Pay Element flex segment
734: ELSE

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

732: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
733: -- Use the rate entered on the Pay Element flex segment
734: ELSE
735: l_rate := l_non_rec.hxt_premium_amount;
736: HXT_UTIL.DEBUG('Sending Premium /element premium rate:'||TO_CHAR(l_rate)||
737: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
738: END IF;
739: l_premium_hours := l_non_rec.hours;
740: l_premium_amount := NULL;

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

742: ELSE
743: -- If no amount was entered, Assign the premium attached to the Pay Element
744: IF l_non_rec.amount IS NULL THEN
745: l_premium_amount := l_non_rec.hxt_premium_amount;
746: HXT_UTIL.DEBUG('Sending Premium Flat/element premium amount:'
747: ||TO_CHAR(l_premium_amount)||
748: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
749:
750: --Else, take the override premium amount entered on the timecard

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

749:
750: --Else, take the override premium amount entered on the timecard
751: ELSE
752: l_premium_amount := l_non_rec.amount;
753: HXT_UTIL.DEBUG('Sending Premium Flat amount entered on timecard, amount:'
754: ||TO_CHAR(l_premium_amount)||
755: ' '||l_non_rec.element_name||','||' hours:'||TO_CHAR(l_non_rec.hours));
756:
757: END IF;

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

775: IF l_expired_cur%FOUND THEN
776: -- pickup changed hours entries
777: IF NVL(l_non_rec.hours,-1) <> NVL(l_expired_rec.hours,-1) THEN
778:
779: HXT_UTIL.DEBUG('This is an adjusting entry for '
780: ||to_char(l_non_rec.hours - l_expired_rec.hours)||' hours');
781: l_retcode := hxt_pa_user_exits.p_a_interface
782: (l_non_rec.hours - l_expired_rec.hours,
783: l_rate,

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

836: --Send a new retro transaction to Project Accounting because vital data has changed
837: ELSE
838:
839: CLOSE l_expired_cur;
840: HXT_UTIL.DEBUG('New transaction '||TO_CHAR(l_non_rec.hours)||' hours');
841: l_retcode := hxt_pa_user_exits.p_a_interface
842: (l_premium_hours,
843: l_rate,
844: l_premium_amount,

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

909: -- BEGIN SIR#5
910: -- Handle Flat Amounts on Base Hours Types
911: IF l_backout_rec.amount IS NOT NULL THEN
912: l_backout_amount := l_backout_rec.amount * -1;
913: HXT_UTIL.DEBUG('Sending backout for amount entered on timecard, amount:'
914: ||TO_CHAR(l_backout_amount)||
915: ' '||l_backout_rec.element_name||','||' hours:'||TO_CHAR(l_backout_rec.hours));
916: ELSE
917: l_backout_amount := NULL;

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

930: ELSE -- FIXED amount per day
931: l_rate := l_backout_rec.hxt_premium_amount / l_backout_rec.hours;
932: END IF;
933: END IF;
934: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_rec.hours)||' hours');
935: END IF; -- IS AMOUNT NULL? SIR#5
936:
937: l_retcode := hxt_pa_user_exits.p_a_interface
938: (l_backout_rec.hours * -1,

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

1006: l_backout_hours := NULL;
1007: l_rate := NULL;
1008: END IF; -- premium calculations
1009:
1010: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_hours)||' hours');
1011: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_amount)||' amount');
1012: l_retcode := hxt_pa_user_exits.p_a_interface
1013: (l_backout_hours,
1014: l_rate,

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

1007: l_rate := NULL;
1008: END IF; -- premium calculations
1009:
1010: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_hours)||' hours');
1011: HXT_UTIL.DEBUG('Sending backout for '||TO_CHAR(l_backout_amount)||' amount');
1012: l_retcode := hxt_pa_user_exits.p_a_interface
1013: (l_backout_hours,
1014: l_rate,
1015: l_backout_amount,

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

1090: i_error_text IN VARCHAR2,
1091: i_system_text IN VARCHAR2)RETURN NUMBER IS
1092: BEGIN
1093:
1094: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);

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

1091: i_system_text IN VARCHAR2)RETURN NUMBER IS
1092: BEGIN
1093:
1094: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);

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

1092: BEGIN
1093:
1094: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);

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

1093:
1094: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1101:

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

1094: HXT_UTIL.DEBUG('g_batch_err_id = ' || TO_CHAR(g_batch_err_id));
1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1101:
1102: hxt_util.Gen_Error(g_batch_err_id,

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

1095: HXT_UTIL.DEBUG('g_timecard_err_id = ' || TO_CHAR(g_timecard_err_id));
1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1101:
1102: hxt_util.Gen_Error(g_batch_err_id,
1103: g_timecard_err_id,

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

1096: HXT_UTIL.DEBUG('g_sum_hours_err_id = ' || g_sum_hours_err_id);
1097: HXT_UTIL.DEBUG('g_time_period_err_id = ' || TO_CHAR(g_time_period_err_id));
1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1101:
1102: hxt_util.Gen_Error(g_batch_err_id,
1103: g_timecard_err_id,
1104: g_sum_hours_err_id,

Line 1102: hxt_util.Gen_Error(g_batch_err_id,

1098: HXT_UTIL.DEBUG('i_location = ' || i_location);
1099: HXT_UTIL.DEBUG('i_error_text = ' || i_error_text);
1100: HXT_UTIL.DEBUG('i_system_text = ' || i_system_text);
1101:
1102: hxt_util.Gen_Error(g_batch_err_id,
1103: g_timecard_err_id,
1104: g_sum_hours_err_id,
1105: g_time_period_err_id,
1106: i_error_text,