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 329: hxt_util.gen_error (g_tim_id,

325: RETURN NUMBER
326: IS
327: -- calls error processing procedure --
328: BEGIN
329: hxt_util.gen_error (g_tim_id,
330: g_id,
331: NULL,
332: p_error_text,
333: p_location,

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

335: g_effective_start_date,
336: g_effective_end_date,
337: 'ERR'
338: );
339: hxt_util.DEBUG ('Return code is 2 from call gen error');
340: RETURN 2;
341: END;
342:
343: FUNCTION call_hxthxc_gen_error (

Line 355: hxt_util.gen_error (g_tim_id,

351: RETURN NUMBER
352: IS
353: -- calls error processing procedure --
354: BEGIN
355: hxt_util.gen_error (g_tim_id,
356: g_id,
357: NULL,
358: p_error_text,
359: p_location,

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

379: THEN
380: hr_utility.TRACE ('Adding to g_otm_messages' || p_msg_name);
381: END IF;
382:
383: hxt_util.DEBUG ('Return code is 2 from call gen error');
384: RETURN 2;
385: END;
386:
387: FUNCTION pay (

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

1402: END IF;
1403: ELSE
1404: CLOSE daily_earn_rules_cur2;
1405:
1406: hxt_util.DEBUG ('Return code is 2 from loc A');
1407: -- debug only --HXT115
1408: RETURN 2;
1409: END IF;
1410:

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

2052: END IF;
2053: ELSE
2054: CLOSE weekly_earn_rules_cur2;
2055:
2056: hxt_util.DEBUG ('Return code is 2 from loc C');
2057: -- debug only --HXT115
2058: RETURN 2;
2059: END IF;
2060:

Line 5464: hxt_util.get_policies (l_reg_hrs_cur.earn_pol_id,

5460:
5461: -- Get the Policies and Premiums for current day - on which
5462: -- the REG hrs were found - where the absence hrs
5463: -- will be adjusted.
5464: hxt_util.get_policies (l_reg_hrs_cur.earn_pol_id,
5465: l_reg_hrs_cur.assignment_id,
5466: l_reg_hrs_cur.date_worked,
5467: l_work_plan,
5468: l_rotation_plan,

Line 5515: hxt_util.get_shift_info (l_reg_hrs_cur.date_worked,

5511: hr_utility.set_location (l_proc, 84);
5512: END IF;
5513:
5514: --Get premiums for shift
5515: hxt_util.get_shift_info (l_reg_hrs_cur.date_worked,
5516: l_work_plan,
5517: l_rotation_plan,
5518: l_osp_id,
5519: l_sdf_id,

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

6810: END IF;
6811:
6812: CLOSE daily_earn_rules_cur2;
6813:
6814: hxt_util.DEBUG ('Return code is 2 from loc B');
6815: -- debug only --HXT115
6816: RETURN 2;
6817: END IF;
6818:

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

6898: END IF;
6899:
6900: CLOSE weekly_earn_rules_cur2;
6901:
6902: hxt_util.DEBUG ('Return code is 2 from loc B');
6903: -- debug only --HXT115
6904: RETURN 2;
6905: END IF;
6906:

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

6922: -- The total hours for the week on Thurs when entering 5 hrs reg is 32.
6923: -- Now when entering 6 hrs VAC on Thurs the total weekly hours should be
6924: -- calculated as 32(Mon + Tue + Wed) + 5 hrs REG on Thurs = 37 hrs.
6925:
6926: -- l_earning_category := hxt_util.element_cat(g_element_type_id
6927: -- ,g_date_worked);
6928: IF g_debug
6929: THEN
6930: hr_utility.set_location (l_proc, 81);

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

11878:
11879: ----------------------------Gen Special Main Section ---------------------------
11880: BEGIN -- Gen Special
11881: g_debug := hr_utility.debug_enabled;
11882: hxt_util.DEBUG ('Top of Gen_Special.'); -- debug only --HXT115
11883: hxt_util.DEBUG ('person id ' || TO_CHAR (g_person_id));
11884:
11885: -- debug only --HXT115
11886: IF g_debug

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

11879: ----------------------------Gen Special Main Section ---------------------------
11880: BEGIN -- Gen Special
11881: g_debug := hr_utility.debug_enabled;
11882: hxt_util.DEBUG ('Top of Gen_Special.'); -- debug only --HXT115
11883: hxt_util.DEBUG ('person id ' || TO_CHAR (g_person_id));
11884:
11885: -- debug only --HXT115
11886: IF g_debug
11887: THEN

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

11974: summary_earning_category := NULL;
11975: ELSE
11976: -- BEGIN ORACLE bug #712501
11977: summary_earning_category :=
11978: hxt_util.element_cat (g_element_type_id, g_date_worked);
11979: -- END ORACLE bug #712501
11980: END IF;
11981:
11982: IF g_debug

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

12138: THEN
12139: l_error_return := ERROR_CODE;
12140: END IF;
12141:
12142: hxt_util.DEBUG ( 'Loc D. Return code is '
12143: || TO_CHAR (l_error_return)
12144: );
12145:
12146: IF g_debug

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

12376: hr_utility.set_location ('hxt_time_detail.gen_special', 10);
12377: END IF;
12378:
12379: l_error_return := ERROR_CODE;
12380: hxt_util.DEBUG ( 'Loc F. Return code is '
12381: || TO_CHAR (l_error_return)
12382: ); -- debug only
12383:
12384: IF g_debug

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

12388: );
12389: END IF;
12390: END IF;
12391:
12392: hxt_util.DEBUG ('Hours left to pay is '
12393: || TO_CHAR (hours_left_to_pay)
12394: ); -- debug only --HXT115
12395:
12396: -- Open the daily earning rules cursor and fetch the special row.

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

12475: FETCH spc_earn_rules_cur
12476: INTO special_daily_cap, special_earning_type,
12477: consecutive_days_limit;
12478:
12479: hxt_util.DEBUG ( 'cap,earn_type,days'
12480: || TO_CHAR (special_daily_cap)
12481: || ',' -- debug only
12482: || TO_CHAR (special_earning_type)
12483: || ',' -- debug only

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

12563:
12564: five_day_cal_rule := TRUE;
12565: END IF;
12566:
12567: hxt_util.DEBUG ( '2nd cap,earn_type,days,reached'
12568: || TO_CHAR (special_daily_cap2)
12569: || ',' -- debug only
12570: || TO_CHAR (special_earning_type2)
12571: || ',' -- debug only

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

12655: --2278400 error_code := call_gen_error(location, '');
12656: IF ERROR_CODE > l_error_return
12657: THEN
12658: l_error_return := ERROR_CODE;
12659: hxt_util.DEBUG ( 'Loc G. Return code is '
12660: || TO_CHAR (l_error_return)
12661: );
12662:
12663: IF g_debug

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

12763: );
12764: END IF;
12765:
12766: l_error_return := ERROR_CODE;
12767: hxt_util.DEBUG ( 'Loc H. Return code is '
12768: || TO_CHAR (l_error_return)
12769: );
12770: END IF; --SIR014
12771: ELSE

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

12838: || hours_paid_weekly_rule
12839: );
12840: END IF;
12841:
12842: -- HXT_UTIL.DEBUG('get_weekly_total is '||to_char(hours_paid_weekly_rule));
12843: IF hours_paid_weekly_rule >= weekly_rule_cap
12844: THEN
12845: IF g_debug
12846: THEN

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

12904: );
12905: END IF;
12906:
12907: l_error_return := ERROR_CODE;
12908: hxt_util.DEBUG ( 'Loc I. Return code is'
12909: || TO_CHAR (l_error_return)
12910: );
12911: END IF;
12912: ELSIF g_ep_type IN ('WEEKLY', 'SPECIAL')

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

12940: );
12941: END IF;
12942:
12943: l_error_return := ERROR_CODE;
12944: hxt_util.DEBUG ( 'Loc I. Return code is'
12945: || TO_CHAR (l_error_return)
12946: );
12947: END IF;
12948: ELSE

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

13037: );
13038: END IF;
13039:
13040: l_error_return := ERROR_CODE;
13041: hxt_util.DEBUG ( 'Loc J. Return code is'
13042: || TO_CHAR (l_error_return)
13043: );
13044: END IF; --SIR014
13045: END IF;

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

13202:
13203: l_error_return := ERROR_CODE;
13204: END IF;
13205:
13206: hxt_util.DEBUG ( 'Loc K. Return code is '
13207: || TO_CHAR (l_error_return)
13208: );
13209: RETURN l_error_return;
13210: --return error_code;

Line 13221: hxt_util.DEBUG ( 'Ahrslefttopay is '

13217: || TO_CHAR (hours_left_to_pay)
13218: );
13219: END IF;
13220:
13221: hxt_util.DEBUG ( 'Ahrslefttopay is '
13222: || TO_CHAR (hours_left_to_pay)
13223: );
13224:
13225: IF g_debug

Line 13258: hxt_util.DEBUG ( 'Bhrslefttopay is '

13254: || TO_CHAR (hours_left_to_pay)
13255: );
13256: END IF;
13257:
13258: hxt_util.DEBUG ( 'Bhrslefttopay is '
13259: || TO_CHAR (hours_left_to_pay)
13260: );
13261: END IF;
13262:

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

13456: );
13457: END IF;
13458:
13459: l_error_return := ERROR_CODE;
13460: hxt_util.DEBUG ( 'Loc L. Return code is'
13461: || TO_CHAR (l_error_return)
13462: );
13463: END IF; --SIR014
13464: ELSE

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

13512:
13513: l_error_return := ERROR_CODE;
13514: END IF;
13515:
13516: hxt_util.DEBUG ( 'Loc M. Return code is'
13517: || TO_CHAR (l_error_return)
13518: );
13519: END IF;
13520:

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

13664: );
13665: END IF;
13666:
13667: l_error_return := ERROR_CODE;
13668: hxt_util.DEBUG ( 'Loc N. Return code is '
13669: || TO_CHAR (l_error_return)
13670: );
13671: END IF;
13672:

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

13702:
13703: IF ERROR_CODE > l_error_return
13704: THEN
13705: l_error_return := ERROR_CODE;
13706: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));
13707: END IF;
13708:
13709: /* MHANDA - Changed on 10/22/2001
13710: Commenting out this function call as it is updating all

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

13715: g_date_worked);
13716:
13717: IF error_code > l_error_return THEN
13718: l_error_return := error_code;
13719: HXT_UTIL.DEBUG('Loc P. Return code is '||to_char(l_error_return));
13720: End if;
13721: */
13722:
13723: -- Combine the exploded chunks if they are contiguous for an element

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

13725:
13726: IF ERROR_CODE > l_error_return
13727: THEN
13728: l_error_return := ERROR_CODE;
13729: hxt_util.DEBUG ('Loc O. Return code is ' || TO_CHAR (l_error_return));
13730: END IF;
13731:
13732: -- Bug 8600894
13733: IF fnd_profile.value('HXT_HOLIDAY_EXPLOSION') IN ('NO','OO')

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

13744: hr_utility.set_location ('hxt_time_detail.gen_special', 65);
13745: END IF;
13746:
13747: l_error_return := ERROR_CODE;
13748: hxt_util.DEBUG ('Loc F. Return code is ' || TO_CHAR (l_error_return));
13749:
13750: -- debug only
13751: IF g_debug
13752: THEN

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

13768: LOCATION,
13769: ''
13770: );
13771: --2278400 error_code := call_gen_error(location, '');
13772: hxt_util.DEBUG ('Loc Q. Return code is ' || TO_CHAR (ERROR_CODE));
13773: hxt_util.DEBUG ('code is ' || SQLERRM);
13774: RETURN (ERROR_CODE);
13775: END; -- gen special
13776:

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

13769: ''
13770: );
13771: --2278400 error_code := call_gen_error(location, '');
13772: hxt_util.DEBUG ('Loc Q. Return code is ' || TO_CHAR (ERROR_CODE));
13773: hxt_util.DEBUG ('code is ' || SQLERRM);
13774: RETURN (ERROR_CODE);
13775: END; -- gen special
13776:
13777: FUNCTION delete_zero_hour_details (

Line 14609: hxt_util.get_policies (a_earn_policy_id,

14605: THEN
14606: hr_utility.set_location (l_proc, 30);
14607: END IF;
14608:
14609: hxt_util.get_policies (a_earn_policy_id,
14610: a_assignment_id,
14611: a_date_worked,
14612: l_work_plan,
14613: l_rotation_plan,

Line 14667: hxt_util.get_shift_info (a_date_worked,

14663: hr_utility.set_location (l_proc, 80);
14664: END IF;
14665:
14666: -- Get premiums for shift
14667: hxt_util.get_shift_info (a_date_worked,
14668: l_work_plan,
14669: l_rotation_plan,
14670: l_osp_id,
14671: l_sdf_id,

Line 14734: hxt_util.check_for_holiday (a_date_worked,

14730: THEN
14731: hr_utility.set_location (l_proc, 130);
14732: END IF;
14733:
14734: hxt_util.check_for_holiday (a_date_worked,
14735: l_hcl_id,
14736: l_hol_id,
14737: l_hours,
14738: l_retcode