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 HR_UTILITY

Line 5: g_debug boolean := hr_utility.debug_enabled;

1: PACKAGE BODY HXT_TIMECARD_API AS
2: /* $Header: hxttapi.pkb 120.6.12010000.1 2008/07/25 09:50:46 appldev ship $ */
3:
4: /* Begin ER180 - accrual balance*/
5: g_debug boolean := hr_utility.debug_enabled;
6: PROCEDURE obtain_accrual_balance
7: (--HXT11i1 i_employee_number IN VARCHAR2,
8: i_employee_id IN NUMBER, --HXT11i1
9: i_calculation_date IN DATE,

Line 58: g_debug :=hr_utility.debug_enabled;

54: accrual_not_found EXCEPTION;
55:
56: BEGIN
57:
58: g_debug :=hr_utility.debug_enabled;
59: if g_debug then
60: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',10);
61: end if;
62: OPEN assignment_cur;

Line 60: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',10);

56: BEGIN
57:
58: g_debug :=hr_utility.debug_enabled;
59: if g_debug then
60: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',10);
61: end if;
62: OPEN assignment_cur;
63: FETCH assignment_cur
64: INTO l_payroll_id,

Line 70: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',20);

66: l_assignment_id,
67: l_business_group_id;
68: IF assignment_cur%NOTFOUND THEN
69: if g_debug then
70: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',20);
71: end if;
72: CLOSE assignment_cur;
73: RAISE assignment_not_found;
74: END IF;

Line 83: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',30);

79: INTO l_accrual_category,
80: l_accrual_plan_id;
81: IF accrual_details_cur%NOTFOUND THEN
82: if g_debug then
83: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',30);
84: end if;
85: CLOSE accrual_details_cur;
86: RAISE accrual_not_found;
87: END IF;

Line 108: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',40);

104:
105: EXCEPTION
106: WHEN assignment_not_found THEN
107: if g_debug then
108: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',40);
109: end if;
110: FND_MESSAGE.SET_NAME('HXT','HXT_39306_ASSIGN_NF');
111: --HXT11iiFND_MESSAGE.SET_TOKEN('EMP_NUMBER',i_employee_number);
112: FND_MESSAGE.SET_TOKEN('EMP_NUMBER',l_assignment_number);

Line 122: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',50);

118: o_oracle_error := l_oracle_error;
119: RETURN;
120: WHEN accrual_not_found THEN
121: if g_debug then
122: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',50);
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;

Line 134: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',60);

130: o_oracle_error := l_oracle_error;
131: RETURN;
132: WHEN OTHERS THEN
133: if g_debug then
134: hr_utility.set_location('hxt_timecard_api.obtain_accrual_balance',60);
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;

Line 211: g_debug :=hr_utility.debug_enabled;

207: /*Note: for finding the accrual plan name.*/
208:
209: BEGIN
210:
211: g_debug :=hr_utility.debug_enabled;
212: if g_debug then
213: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',10);
214: end if;
215: o_return_code := 0;

Line 213: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',10);

209: BEGIN
210:
211: g_debug :=hr_utility.debug_enabled;
212: if g_debug then
213: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',10);
214: end if;
215: o_return_code := 0;
216: o_accrual_plan_name := NULL;
217:

Line 221: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',20);

217:
218: OPEN acc_plan_cur;
219: LOOP
220: if g_debug then
221: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',20);
222: end if;
223: FETCH acc_plan_cur INTO l_accrual_plan_name;
224: EXIT WHEN acc_plan_cur%NOTFOUND;
225: END LOOP;

Line 229: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',30);

225: END LOOP;
226:
227: IF acc_plan_cur%ROWCOUNT = 0 THEN
228: if g_debug then
229: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',30);
230: end if;
231: CLOSE acc_plan_cur;
232: o_return_code := 2; -- Element Not Tied to Accrual Plan
233: RETURN;

Line 240: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',40);

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);
241: end if;
242:
243: CLOSE acc_plan_cur;
244: o_return_code := 1; -- Too many Accrual Plans linked to the element type

Line 264: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',50);

260: RETURN; */
261:
262: WHEN others THEN
263: if g_debug then
264: hr_utility.set_location('hxt_timecard_api.accrual_plan_name',50);
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;

Line 511: g_debug :=hr_utility.debug_enabled;

507:
508: BEGIN
509:
510: l_flag_acc_exceeded := 0;
511: g_debug :=hr_utility.debug_enabled;
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;

Line 513: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',10);

509:
510: l_flag_acc_exceeded := 0;
511: g_debug :=hr_utility.debug_enabled;
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;

Line 521: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',20);

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;
523: close do_accrual_cur;
524: o_return_code := 0;
525: o_otm_error := NULL;

Line 536: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',30);

532: FOR tc_rec IN get_tc_dates(p_tim_id) LOOP
533: l_date_worked := tc_rec.date_worked;
534: FOR accrual_rec IN accrual_cur(l_date_worked) LOOP
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));

Line 547: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',40);

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;
549: close on_timecard_cur;
550: RAISE no_summary_rows;
551: end if;

Line 613: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',50);

609: close get_org_total;
610: end if;
611:
612: if g_debug then
613: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',50);
614: end if;
615: HXT_TIMECARD_API.obtain_accrual_balance
616: (--HXT11i1 p_empl_number,
617: p_empl_id --HXT11i1

Line 629: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',60);

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;
631: raise obtain_error;
632: end if;
633: if (nvl((l_hours-l_old_total),0) > l_net_accrual) then

Line 635: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70);

631: raise obtain_error;
632: end if;
633: if (nvl((l_hours-l_old_total),0) > l_net_accrual) then
634: if g_debug then
635: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70);
636: end if;
637:
638: if(l_display_error IS NULL) then
639: if g_debug then

Line 640: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.1);

636: end if;
637:
638: if(l_display_error IS NULL) then
639: if g_debug then
640: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.1);
641: end if;
642:
643: -- CREATE AND ADD THE MESSAGE
644: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');

Line 653: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.2);

649: else
650: -- IF A MESSAGE HAS BEEN ALREADY ADDED FOR AN ACCRUAL PLAN, DO NOT ADD IT
651: if(instr(l_display_error, l_accrual_plan_name) = 0) then
652: if g_debug then
653: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',70.2);
654: end if;
655: FND_MESSAGE.SET_NAME('HXT','HXT_39509_ACCRUAL_EXCEEDED');
656: FND_MESSAGE.SET_TOKEN('ACCPLAN', l_accrual_plan_name);
657: FND_MESSAGE.SET_TOKEN('ACCHRS', to_char(l_net_accrual));

Line 700: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',80);

696: -- RETURN;
697:
698: WHEN no_summary_rows THEN
699: if g_debug then
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);

Line 713: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',90);

709: RETURN;
710:
711: WHEN accrual_exceeded THEN
712: if g_debug then
713: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',90);
714: end if;
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));

Line 729: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',100);

725: RETURN;
726:
727: WHEN obtain_error THEN
728: if g_debug then
729: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',100);
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;

Line 744: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',110);

740: RETURN;
741:
742: WHEN others THEN
743: if g_debug then
744: hr_utility.set_location('hxt_timecard_api.total_accrual_for_week',110);
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;