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

Line 229: hxt_util.gen_error (g_tim_id,

225: RETURN NUMBER
226: IS
227: -- calls error processing procedure --
228: BEGIN
229: hxt_util.gen_error (g_tim_id,
230: g_id,
231: NULL,
232: p_error_text,
233: p_location,

Line 239: hxt_util.DEBUG ('Return code is 2 from call gen error');

235: g_effective_start_date,
236: g_effective_end_date,
237: 'ERR'
238: );
239: hxt_util.DEBUG ('Return code is 2 from call gen error');
240: RETURN 2;
241: END;
242:
243: FUNCTION call_hxthxc_gen_error (

Line 255: hxt_util.gen_error (g_tim_id,

251: RETURN NUMBER
252: IS
253: -- calls error processing procedure --
254: BEGIN
255: hxt_util.gen_error (g_tim_id,
256: g_id,
257: NULL,
258: p_error_text,
259: p_location,

Line 283: hxt_util.DEBUG ('Return code is 2 from call gen error');

279: THEN
280: hr_utility.TRACE ('Adding to g_otm_messages' || p_msg_name);
281: END IF;
282:
283: hxt_util.DEBUG ('Return code is 2 from call gen error');
284: RETURN 2;
285: END;
286:
287: FUNCTION pay (

Line 1026: hxt_util.DEBUG ('Return code is 2 from loc A');

1022: END IF;
1023: ELSE
1024: CLOSE daily_earn_rules_cur2;
1025:
1026: hxt_util.DEBUG ('Return code is 2 from loc A');
1027: -- debug only --HXT115
1028: RETURN 2;
1029: END IF;
1030:

Line 1513: hxt_util.DEBUG ('Return code is 2 from loc C');

1509: END IF;
1510: ELSE
1511: CLOSE weekly_earn_rules_cur2;
1512:
1513: hxt_util.DEBUG ('Return code is 2 from loc C');
1514: -- debug only --HXT115
1515: RETURN 2;
1516: END IF;
1517:

Line 3993: hxt_util.get_policies (l_reg_hrs_cur.earn_pol_id,

3989:
3990: -- Get the Policies and Premiums for current day - on which
3991: -- the REG hrs were found - where the absence hrs
3992: -- will be adjusted.
3993: hxt_util.get_policies (l_reg_hrs_cur.earn_pol_id,
3994: l_reg_hrs_cur.assignment_id,
3995: l_reg_hrs_cur.date_worked,
3996: l_work_plan,
3997: l_rotation_plan,

Line 4044: hxt_util.get_shift_info (l_reg_hrs_cur.date_worked,

4040: hr_utility.set_location (l_proc, 84);
4041: END IF;
4042:
4043: --Get premiums for shift
4044: hxt_util.get_shift_info (l_reg_hrs_cur.date_worked,
4045: l_work_plan,
4046: l_rotation_plan,
4047: l_osp_id,
4048: l_sdf_id,

Line 5239: hxt_util.DEBUG ('Return code is 2 from loc B');

5235: END IF;
5236:
5237: CLOSE daily_earn_rules_cur2;
5238:
5239: hxt_util.DEBUG ('Return code is 2 from loc B');
5240: -- debug only --HXT115
5241: RETURN 2;
5242: END IF;
5243:

Line 5327: hxt_util.DEBUG ('Return code is 2 from loc B');

5323: END IF;
5324:
5325: CLOSE weekly_earn_rules_cur2;
5326:
5327: hxt_util.DEBUG ('Return code is 2 from loc B');
5328: -- debug only --HXT115
5329: RETURN 2;
5330: END IF;
5331:

Line 5351: -- l_earning_category := hxt_util.element_cat(g_element_type_id

5347: -- The total hours for the week on Thurs when entering 5 hrs reg is 32.
5348: -- Now when entering 6 hrs VAC on Thurs the total weekly hours should be
5349: -- calculated as 32(Mon + Tue + Wed) + 5 hrs REG on Thurs = 37 hrs.
5350:
5351: -- l_earning_category := hxt_util.element_cat(g_element_type_id
5352: -- ,g_date_worked);
5353: IF g_debug
5354: THEN
5355: hr_utility.set_location (l_proc, 81);

Line 10218: hxt_util.DEBUG ('Top of Gen_Special.'); -- debug only --HXT115

10214: END;
10215: ----------------------------Gen Special Main Section ---------------------------
10216: BEGIN -- Gen Special
10217: g_debug := hr_utility.debug_enabled;
10218: hxt_util.DEBUG ('Top of Gen_Special.'); -- debug only --HXT115
10219: hxt_util.DEBUG ('person id ' || TO_CHAR (g_person_id));
10220:
10221: -- debug only --HXT115
10222: IF g_debug

Line 10219: hxt_util.DEBUG ('person id ' || TO_CHAR (g_person_id));

10215: ----------------------------Gen Special Main Section ---------------------------
10216: BEGIN -- Gen Special
10217: g_debug := hr_utility.debug_enabled;
10218: hxt_util.DEBUG ('Top of Gen_Special.'); -- debug only --HXT115
10219: hxt_util.DEBUG ('person id ' || TO_CHAR (g_person_id));
10220:
10221: -- debug only --HXT115
10222: IF g_debug
10223: THEN

Line 10352: hxt_util.element_cat (g_element_type_id, g_date_worked);

10348: summary_earning_category := NULL;
10349: ELSE
10350: -- BEGIN ORACLE bug #712501
10351: summary_earning_category :=
10352: hxt_util.element_cat (g_element_type_id, g_date_worked);
10353: -- END ORACLE bug #712501
10354: END IF;
10355:
10356: IF g_debug

Line 10470: hxt_util.DEBUG ( 'Loc D. Return code is '

10466: THEN
10467: l_error_return := ERROR_CODE;
10468: END IF;
10469:
10470: hxt_util.DEBUG ( 'Loc D. Return code is '
10471: || TO_CHAR (l_error_return)
10472: );
10473:
10474: IF g_debug

Line 10708: hxt_util.DEBUG ( 'Loc F. Return code is '

10704: hr_utility.set_location ('hxt_time_detail.gen_special', 10);
10705: END IF;
10706:
10707: l_error_return := ERROR_CODE;
10708: hxt_util.DEBUG ( 'Loc F. Return code is '
10709: || TO_CHAR (l_error_return)
10710: ); -- debug only
10711:
10712: IF g_debug

Line 10720: hxt_util.DEBUG ('Hours left to pay is '

10716: );
10717: END IF;
10718: END IF;
10719:
10720: hxt_util.DEBUG ('Hours left to pay is '
10721: || TO_CHAR (hours_left_to_pay)
10722: ); -- debug only --HXT115
10723:
10724: -- Open the daily earning rules cursor and fetch the special row.

Line 10807: hxt_util.DEBUG ( 'cap,earn_type,days'

10803: FETCH spc_earn_rules_cur
10804: INTO special_daily_cap, special_earning_type,
10805: consecutive_days_limit;
10806:
10807: hxt_util.DEBUG ( 'cap,earn_type,days'
10808: || TO_CHAR (special_daily_cap)
10809: || ',' -- debug only
10810: || TO_CHAR (special_earning_type)
10811: || ',' -- debug only

Line 10895: hxt_util.DEBUG ( '2nd cap,earn_type,days,reached'

10891:
10892: five_day_cal_rule := TRUE;
10893: END IF;
10894:
10895: hxt_util.DEBUG ( '2nd cap,earn_type,days,reached'
10896: || TO_CHAR (special_daily_cap2)
10897: || ',' -- debug only
10898: || TO_CHAR (special_earning_type2)
10899: || ',' -- debug only

Line 10987: hxt_util.DEBUG ( 'Loc G. Return code is '

10983: --2278400 error_code := call_gen_error(location, '');
10984: IF ERROR_CODE > l_error_return
10985: THEN
10986: l_error_return := ERROR_CODE;
10987: hxt_util.DEBUG ( 'Loc G. Return code is '
10988: || TO_CHAR (l_error_return)
10989: );
10990:
10991: IF g_debug

Line 11095: hxt_util.DEBUG ( 'Loc H. Return code is '

11091: );
11092: END IF;
11093:
11094: l_error_return := ERROR_CODE;
11095: hxt_util.DEBUG ( 'Loc H. Return code is '
11096: || TO_CHAR (l_error_return)
11097: );
11098: END IF; --SIR014
11099: ELSE

Line 11138: -- HXT_UTIL.DEBUG('get_weekly_total is '||to_char(hours_paid_weekly_rule));

11134: || hours_paid_weekly_rule
11135: );
11136: END IF;
11137:
11138: -- HXT_UTIL.DEBUG('get_weekly_total is '||to_char(hours_paid_weekly_rule));
11139: IF hours_paid_weekly_rule >= weekly_rule_cap
11140: THEN
11141: IF g_debug
11142: THEN

Line 11204: hxt_util.DEBUG ( 'Loc I. Return code is'

11200: );
11201: END IF;
11202:
11203: l_error_return := ERROR_CODE;
11204: hxt_util.DEBUG ( 'Loc I. Return code is'
11205: || TO_CHAR (l_error_return)
11206: );
11207: END IF;
11208: ELSIF g_ep_type IN ('WEEKLY', 'SPECIAL')

Line 11233: hxt_util.DEBUG ( 'Loc I. Return code is'

11229: );
11230: END IF;
11231:
11232: l_error_return := ERROR_CODE;
11233: hxt_util.DEBUG ( 'Loc I. Return code is'
11234: || TO_CHAR (l_error_return)
11235: );
11236: END IF;
11237: ELSE

Line 11304: hxt_util.DEBUG ( 'Loc J. Return code is'

11300: );
11301: END IF;
11302:
11303: l_error_return := ERROR_CODE;
11304: hxt_util.DEBUG ( 'Loc J. Return code is'
11305: || TO_CHAR (l_error_return)
11306: );
11307: END IF; --SIR014
11308: END IF;

Line 11450: hxt_util.DEBUG ( 'Loc K. Return code is '

11446:
11447: l_error_return := ERROR_CODE;
11448: END IF;
11449:
11450: hxt_util.DEBUG ( 'Loc K. Return code is '
11451: || TO_CHAR (l_error_return)
11452: );
11453: RETURN l_error_return;
11454: --return error_code;

Line 11465: hxt_util.DEBUG ( 'Ahrslefttopay is '

11461: || TO_CHAR (hours_left_to_pay)
11462: );
11463: END IF;
11464:
11465: hxt_util.DEBUG ( 'Ahrslefttopay is '
11466: || TO_CHAR (hours_left_to_pay)
11467: );
11468:
11469: IF g_debug

Line 11502: hxt_util.DEBUG ( 'Bhrslefttopay is '

11498: || TO_CHAR (hours_left_to_pay)
11499: );
11500: END IF;
11501:
11502: hxt_util.DEBUG ( 'Bhrslefttopay is '
11503: || TO_CHAR (hours_left_to_pay)
11504: );
11505: END IF;
11506:

Line 11704: hxt_util.DEBUG ( 'Loc L. Return code is'

11700: );
11701: END IF;
11702:
11703: l_error_return := ERROR_CODE;
11704: hxt_util.DEBUG ( 'Loc L. Return code is'
11705: || TO_CHAR (l_error_return)
11706: );
11707: END IF; --SIR014
11708: ELSE

Line 11760: hxt_util.DEBUG ( 'Loc M. Return code is'

11756:
11757: l_error_return := ERROR_CODE;
11758: END IF;
11759:
11760: hxt_util.DEBUG ( 'Loc M. Return code is'
11761: || TO_CHAR (l_error_return)
11762: );
11763: END IF;
11764:

Line 11912: hxt_util.DEBUG ( 'Loc N. Return code is '

11908: );
11909: END IF;
11910:
11911: l_error_return := ERROR_CODE;
11912: hxt_util.DEBUG ( 'Loc N. Return code is '
11913: || TO_CHAR (l_error_return)
11914: );
11915: END IF;
11916:

Line 11950: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));

11946:
11947: IF ERROR_CODE > l_error_return
11948: THEN
11949: l_error_return := ERROR_CODE;
11950: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));
11951: END IF;
11952:
11953: /* MHANDA - Changed on 10/22/2001
11954: Commenting out this function call as it is updating all

Line 11963: HXT_UTIL.DEBUG('Loc P. Return code is '||to_char(l_error_return));

11959: g_date_worked);
11960:
11961: IF error_code > l_error_return THEN
11962: l_error_return := error_code;
11963: HXT_UTIL.DEBUG('Loc P. Return code is '||to_char(l_error_return));
11964: End if;
11965: */
11966:
11967: -- Combine the exploded chunks if they are contiguous for an element

Line 11973: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));

11969:
11970: IF ERROR_CODE > l_error_return
11971: THEN
11972: l_error_return := ERROR_CODE;
11973: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));
11974: END IF;
11975:
11976: ERROR_CODE := adjust_hours_for_hdp;
11977:

Line 11986: hxt_util.DEBUG ('Loc F. Return code is ' || TO_CHAR (l_error_return));

11982: hr_utility.set_location ('hxt_time_detail.gen_special', 65);
11983: END IF;
11984:
11985: l_error_return := ERROR_CODE;
11986: hxt_util.DEBUG ('Loc F. Return code is ' || TO_CHAR (l_error_return));
11987:
11988: -- debug only
11989: IF g_debug
11990: THEN

Line 12010: hxt_util.DEBUG ('Loc Q. Return code is ' || TO_CHAR (ERROR_CODE));

12006: LOCATION,
12007: ''
12008: );
12009: --2278400 error_code := call_gen_error(location, '');
12010: hxt_util.DEBUG ('Loc Q. Return code is ' || TO_CHAR (ERROR_CODE));
12011: hxt_util.DEBUG ('code is ' || SQLERRM);
12012: RETURN (ERROR_CODE);
12013: END; -- gen special
12014:

Line 12011: hxt_util.DEBUG ('code is ' || SQLERRM);

12007: ''
12008: );
12009: --2278400 error_code := call_gen_error(location, '');
12010: hxt_util.DEBUG ('Loc Q. Return code is ' || TO_CHAR (ERROR_CODE));
12011: hxt_util.DEBUG ('code is ' || SQLERRM);
12012: RETURN (ERROR_CODE);
12013: END; -- gen special
12014:
12015: FUNCTION delete_zero_hour_details (

Line 12734: hxt_util.get_policies (a_earn_policy_id,

12730: THEN
12731: hr_utility.set_location (l_proc, 30);
12732: END IF;
12733:
12734: hxt_util.get_policies (a_earn_policy_id,
12735: a_assignment_id,
12736: a_date_worked,
12737: l_work_plan,
12738: l_rotation_plan,

Line 12792: hxt_util.get_shift_info (a_date_worked,

12788: hr_utility.set_location (l_proc, 80);
12789: END IF;
12790:
12791: -- Get premiums for shift
12792: hxt_util.get_shift_info (a_date_worked,
12793: l_work_plan,
12794: l_rotation_plan,
12795: l_osp_id,
12796: l_sdf_id,

Line 12859: hxt_util.check_for_holiday (a_date_worked,

12855: THEN
12856: hr_utility.set_location (l_proc, 130);
12857: END IF;
12858:
12859: hxt_util.check_for_holiday (a_date_worked,
12860: l_hcl_id,
12861: l_hol_id,
12862: l_hours,
12863: l_retcode