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

Line 90: HXT_UTIL.DEBUG('l_calcuation_datet is '|| (l_calculation_date));

86: RAISE accrual_not_found;
87: END IF;
88: CLOSE accrual_details_cur;
89:
90: HXT_UTIL.DEBUG('l_calcuation_datet is '|| (l_calculation_date));
91:
92: l_net_accrual_amt := pay_us_pto_accrual.get_net_accrual(
93: P_assignment_id => l_assignment_id,
94: P_calculation_date => l_calculation_date,

Line 100: HXT_UTIL.DEBUG('The net accrual amount is '|| TO_CHAR(l_net_accrual_amt));

96: P_plan_category => NULL); -- Do not pass Acc Category (ER180)
97:
98: o_net_accrual := l_net_accrual_amt;
99:
100: HXT_UTIL.DEBUG('The net accrual amount is '|| TO_CHAR(l_net_accrual_amt));
101: HXT_UTIL.DEBUG('sysdate '|| (sysdate));
102:
103: RETURN;
104:

Line 101: HXT_UTIL.DEBUG('sysdate '|| (sysdate));

97:
98: o_net_accrual := l_net_accrual_amt;
99:
100: HXT_UTIL.DEBUG('The net accrual amount is '|| TO_CHAR(l_net_accrual_amt));
101: HXT_UTIL.DEBUG('sysdate '|| (sysdate));
102:
103: RETURN;
104:
105: EXCEPTION

Line 115: HXT_UTIL.DEBUG(l_display_error);

111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;
115: HXT_UTIL.DEBUG(l_display_error);
116: HXT_UTIL.DEBUG(l_oracle_error);
117: o_otm_error := l_display_error;
118: o_oracle_error := l_oracle_error;
119: RETURN;

Line 116: HXT_UTIL.DEBUG(l_oracle_error);

112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);
113: l_display_error := FND_MESSAGE.GET;
114: l_oracle_error := SQLERRM;
115: HXT_UTIL.DEBUG(l_display_error);
116: HXT_UTIL.DEBUG(l_oracle_error);
117: o_otm_error := l_display_error;
118: o_oracle_error := l_oracle_error;
119: RETURN;
120: WHEN accrual_not_found THEN

Line 127: HXT_UTIL.DEBUG(l_display_error);

123: end if;
124: FND_MESSAGE.SET_NAME('HXT','HXT_39511_ACCRUAL_PLAN_NF');
125: l_display_error := FND_MESSAGE.GET;
126: l_oracle_error := SQLERRM;
127: HXT_UTIL.DEBUG(l_display_error);
128: HXT_UTIL.DEBUG(l_oracle_error);
129: o_otm_error := l_display_error;
130: o_oracle_error := l_oracle_error;
131: RETURN;

Line 128: HXT_UTIL.DEBUG(l_oracle_error);

124: FND_MESSAGE.SET_NAME('HXT','HXT_39511_ACCRUAL_PLAN_NF');
125: l_display_error := FND_MESSAGE.GET;
126: l_oracle_error := SQLERRM;
127: HXT_UTIL.DEBUG(l_display_error);
128: HXT_UTIL.DEBUG(l_oracle_error);
129: o_otm_error := l_display_error;
130: o_oracle_error := l_oracle_error;
131: RETURN;
132: WHEN OTHERS THEN

Line 139: HXT_UTIL.DEBUG(l_display_error);

135: end if;
136: FND_MESSAGE.SET_NAME('HXT','HXT_39512_OTH_OAB_ERROR');
137: l_display_error := FND_MESSAGE.GET;
138: l_oracle_error := SQLERRM;
139: HXT_UTIL.DEBUG(l_display_error);
140: HXT_UTIL.DEBUG(l_oracle_error);
141: o_otm_error := l_display_error;
142: o_oracle_error := l_oracle_error;
143: RETURN;

Line 140: HXT_UTIL.DEBUG(l_oracle_error);

136: FND_MESSAGE.SET_NAME('HXT','HXT_39512_OTH_OAB_ERROR');
137: l_display_error := FND_MESSAGE.GET;
138: l_oracle_error := SQLERRM;
139: HXT_UTIL.DEBUG(l_display_error);
140: HXT_UTIL.DEBUG(l_oracle_error);
141: o_otm_error := l_display_error;
142: o_oracle_error := l_oracle_error;
143: RETURN;
144: END obtain_accrual_balance;

Line 236: HXT_UTIL.DEBUG('rowcount is:'|| to_char(acc_plan_cur%ROWCOUNT)); --DEBUG

232: o_return_code := 2; -- Element Not Tied to Accrual Plan
233: RETURN;
234: END IF;
235:
236: HXT_UTIL.DEBUG('rowcount is:'|| to_char(acc_plan_cur%ROWCOUNT)); --DEBUG
237:
238: IF acc_plan_cur%ROWCOUNT > 1 THEN
239: if g_debug then
240: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',40);

Line 269: HXT_UTIL.DEBUG(l_display_error);

265: end if;
266: FND_MESSAGE.SET_NAME('HXT','HXT_39513_OTH_APN_ERROR');
267: l_display_error := FND_MESSAGE.GET;
268: l_oracle_error := SQLERRM;
269: HXT_UTIL.DEBUG(l_display_error);
270: HXT_UTIL.DEBUG(l_oracle_error);
271: o_otm_error := l_display_error;
272: o_oracle_error := l_oracle_error;
273: o_return_code := 3;

Line 270: HXT_UTIL.DEBUG(l_oracle_error);

266: FND_MESSAGE.SET_NAME('HXT','HXT_39513_OTH_APN_ERROR');
267: l_display_error := FND_MESSAGE.GET;
268: l_oracle_error := SQLERRM;
269: HXT_UTIL.DEBUG(l_display_error);
270: HXT_UTIL.DEBUG(l_oracle_error);
271: o_otm_error := l_display_error;
272: o_oracle_error := l_oracle_error;
273: o_return_code := 3;
274: RETURN;

Line 516: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));

512: if g_debug then
513: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',10);
514: end if;
515: open do_accrual_cur;
516: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));
517: fetch do_accrual_cur into l_hours;
518: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));
519: if do_accrual_cur%NOTFOUND then
520: if g_debug then

Line 518: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));

514: end if;
515: open do_accrual_cur;
516: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));
517: fetch do_accrual_cur into l_hours;
518: -- HXT_UTIL.DEBUG('do acc cur :'||to_char(l_hours));
519: if do_accrual_cur%NOTFOUND then
520: if g_debug then
521: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',20);
522: end if;

Line 539: HXT_UTIL.DEBUG('Acc plan is:'||l_accrual_plan_name);

535: if g_debug then
536: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',30);
537: end if;
538: l_accrual_plan_name := accrual_rec.accrual_plan_name;
539: HXT_UTIL.DEBUG('Acc plan is:'||l_accrual_plan_name);
540: --HXT_UTIL.DEBUG('accrual_rec.element_type_id is '||to_char(accrual_rec.element_type_id));
541:
542: open on_timecard_cur(l_accrual_plan_name);
543: fetch on_timecard_cur into l_hours;

Line 540: --HXT_UTIL.DEBUG('accrual_rec.element_type_id is '||to_char(accrual_rec.element_type_id));

536: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',30);
537: end if;
538: l_accrual_plan_name := accrual_rec.accrual_plan_name;
539: HXT_UTIL.DEBUG('Acc plan is:'||l_accrual_plan_name);
540: --HXT_UTIL.DEBUG('accrual_rec.element_type_id is '||to_char(accrual_rec.element_type_id));
541:
542: open on_timecard_cur(l_accrual_plan_name);
543: fetch on_timecard_cur into l_hours;
544: --HXT_UTIL.DEBUG('timecard cur:'||to_char(l_hours));

Line 544: --HXT_UTIL.DEBUG('timecard cur:'||to_char(l_hours));

540: --HXT_UTIL.DEBUG('accrual_rec.element_type_id is '||to_char(accrual_rec.element_type_id));
541:
542: open on_timecard_cur(l_accrual_plan_name);
543: fetch on_timecard_cur into l_hours;
544: --HXT_UTIL.DEBUG('timecard cur:'||to_char(l_hours));
545: if on_timecard_cur%NOTFOUND then
546: if g_debug then
547: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',40);
548: end if;

Line 624: HXT_UTIL.DEBUG('params for o a b is:'||p_empl_id||

620: ,l_net_accrual
621: ,v_otm_error
622: ,v_oracle_error);
623:
624: HXT_UTIL.DEBUG('params for o a b is:'||p_empl_id||
625: ':'||fnd_date.date_to_chardate(l_date_worked)||'Net acc is:'||to_char(l_net_accrual));
626: HXT_UTIL.DEBUG('Erros from ob acc bal :'||v_otm_error||v_oracle_error);
627: if v_otm_error is not null then
628: if g_debug then

Line 626: HXT_UTIL.DEBUG('Erros from ob acc bal :'||v_otm_error||v_oracle_error);

622: ,v_oracle_error);
623:
624: HXT_UTIL.DEBUG('params for o a b is:'||p_empl_id||
625: ':'||fnd_date.date_to_chardate(l_date_worked)||'Net acc is:'||to_char(l_net_accrual));
626: HXT_UTIL.DEBUG('Erros from ob acc bal :'||v_otm_error||v_oracle_error);
627: if v_otm_error is not null then
628: if g_debug then
629: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',60);
630: end if;

Line 681: -- HXT_UTIL.DEBUG('l_accrual_plan_name is '|| (l_accrual_plan_name));

677: o_return_code := 0;
678: o_otm_error := NULL;
679: o_oracle_error := NULL;
680: o_lookup_code := NULL;
681: -- HXT_UTIL.DEBUG('l_accrual_plan_name is '|| (l_accrual_plan_name));
682: -- HXT_UTIL.DEBUG('l_tot_hours is '||to_char(l_tot_hours));
683:
684: RETURN;
685:

Line 682: -- HXT_UTIL.DEBUG('l_tot_hours is '||to_char(l_tot_hours));

678: o_otm_error := NULL;
679: o_oracle_error := NULL;
680: o_lookup_code := NULL;
681: -- HXT_UTIL.DEBUG('l_accrual_plan_name is '|| (l_accrual_plan_name));
682: -- HXT_UTIL.DEBUG('l_tot_hours is '||to_char(l_tot_hours));
683:
684: RETURN;
685:
686: EXCEPTION

Line 691: -- HXT_UTIL.DEBUG(l_display_error);

687: -- WHEN no_accrual_plan THEN
688: -- o_return_code := 1;
689: -- l_display_error := 'Other error from total_accrual_for_week procedure';
690: -- l_oracle_error := SQLERRM;
691: -- HXT_UTIL.DEBUG(l_display_error);
692: -- HXT_UTIL.DEBUG(l_oracle_error);
693: -- o_otm_error := l_display_error;
694: -- o_oracle_error := l_oracle_error;
695: -- o_return_code := 3;

Line 692: -- HXT_UTIL.DEBUG(l_oracle_error);

688: -- o_return_code := 1;
689: -- l_display_error := 'Other error from total_accrual_for_week procedure';
690: -- l_oracle_error := SQLERRM;
691: -- HXT_UTIL.DEBUG(l_display_error);
692: -- HXT_UTIL.DEBUG(l_oracle_error);
693: -- o_otm_error := l_display_error;
694: -- o_oracle_error := l_oracle_error;
695: -- o_return_code := 3;
696: -- RETURN;

Line 704: HXT_UTIL.DEBUG(l_display_error);

700: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',80);
701: end if;
702: FND_MESSAGE.SET_NAME('HXT','HXT_39514_NO_TIMECARD_ROWS');
703: l_display_error := FND_MESSAGE.GET;
704: HXT_UTIL.DEBUG(l_display_error);
705: o_otm_error := l_display_error;
706: o_oracle_error := NULL;
707: o_return_code := 1;
708: o_lookup_code := NULL;

Line 719: HXT_UTIL.DEBUG(l_display_error);

715: -- FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
716: -- FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
717: -- FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));
718: -- l_display_error := FND_MESSAGE.GET;
719: HXT_UTIL.DEBUG(l_display_error);
720: o_otm_error := l_display_error;
721: o_oracle_error := NULL;
722: o_accrual_plan_name := l_accrual_plan_name;
723: o_return_code := 1;

Line 734: HXT_UTIL.DEBUG(l_display_error);

730: end if;
731: FND_MESSAGE.SET_NAME('HXT','HXT_39515_TAFW_OAB_ERROR');
732: l_display_error := FND_MESSAGE.GET || ' ' || v_otm_error;
733: l_oracle_error := v_oracle_error;
734: HXT_UTIL.DEBUG(l_display_error);
735: HXT_UTIL.DEBUG(l_oracle_error);
736: o_otm_error := l_display_error;
737: o_oracle_error := l_oracle_error;
738: o_return_code := 1;

Line 735: HXT_UTIL.DEBUG(l_oracle_error);

731: FND_MESSAGE.SET_NAME('HXT','HXT_39515_TAFW_OAB_ERROR');
732: l_display_error := FND_MESSAGE.GET || ' ' || v_otm_error;
733: l_oracle_error := v_oracle_error;
734: HXT_UTIL.DEBUG(l_display_error);
735: HXT_UTIL.DEBUG(l_oracle_error);
736: o_otm_error := l_display_error;
737: o_oracle_error := l_oracle_error;
738: o_return_code := 1;
739: o_lookup_code := NULL;

Line 749: HXT_UTIL.DEBUG(l_display_error);

745: end if;
746: FND_MESSAGE.SET_NAME('HXT','HXT_39516_OTH_TAFW_ERROR');
747: l_display_error := FND_MESSAGE.GET;
748: l_oracle_error := SQLERRM;
749: HXT_UTIL.DEBUG(l_display_error);
750: HXT_UTIL.DEBUG(l_oracle_error);
751: o_otm_error := l_display_error;
752: o_oracle_error := l_oracle_error;
753: o_return_code := 1;

Line 750: HXT_UTIL.DEBUG(l_oracle_error);

746: FND_MESSAGE.SET_NAME('HXT','HXT_39516_OTH_TAFW_ERROR');
747: l_display_error := FND_MESSAGE.GET;
748: l_oracle_error := SQLERRM;
749: HXT_UTIL.DEBUG(l_display_error);
750: HXT_UTIL.DEBUG(l_oracle_error);
751: o_otm_error := l_display_error;
752: o_oracle_error := l_oracle_error;
753: o_return_code := 1;
754: o_lookup_code := NULL;