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.PAY_MX_UTILITY dependencies on HR_UTILITY

Line 44: --hr_utility.trace_on( NULL, 'BAL');

40: ln_found NUMBER;
41: ln_index NUMBER;
42: BEGIN
43:
44: --hr_utility.trace_on( NULL, 'BAL');
45:
46: ln_found := 0;
47:
48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);

Line 48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);

44: --hr_utility.trace_on( NULL, 'BAL');
45:
46: ln_found := 0;
47:
48: hr_utility.trace( 'COUNT '|| pay_mx_utility.days_bal_tbl.count);
49:
50: if pay_mx_utility.days_bal_tbl.count > 0 then
51:
52: for i in pay_mx_utility.days_bal_tbl.first ..

Line 65: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);

61: ln_found := 1;
62:
63: end if;
64:
65: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
66: hr_utility.trace( 'BAL TYPE ID '||
67: pay_mx_utility.days_bal_tbl(i).days_bal_type_id);
68:
69: end loop;

Line 66: hr_utility.trace( 'BAL TYPE ID '||

62:
63: end if;
64:
65: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
66: hr_utility.trace( 'BAL TYPE ID '||
67: pay_mx_utility.days_bal_tbl(i).days_bal_type_id);
68:
69: end loop;
70:

Line 86: hr_utility.trace( 'DAYS BAL TYPE ID '||ln_days_bal_type_id);

82: pay_mx_utility.days_bal_tbl(ln_index).days_bal_type_id :=
83: ln_days_bal_type_id;
84: pay_mx_utility.days_bal_tbl(ln_index).days_bal_uom := lv_balance_uom;
85:
86: hr_utility.trace( 'DAYS BAL TYPE ID '||ln_days_bal_type_id);
87: end if;
88:
89: return ln_days_bal_type_id;
90:

Line 126: --hr_utility.trace_on( NULL, 'BAL');

122: ln_found NUMBER;
123: ln_index NUMBER;
124: BEGIN
125:
126: --hr_utility.trace_on( NULL, 'BAL');
127:
128: ln_found := 0;
129:
130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);

Line 130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);

126: --hr_utility.trace_on( NULL, 'BAL');
127:
128: ln_found := 0;
129:
130: hr_utility.trace( 'COUNT '|| pay_mx_utility.hours_bal_tbl.count);
131:
132: /*
133: if pay_mx_utility.hours_bal_tbl.count > 0 then
134:

Line 149: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);

145: ln_found := 1;
146:
147: end if;
148:
149: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
150: hr_utility.trace( 'BAL TYPE ID '||
151: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id);
152:
153: end loop;

Line 150: hr_utility.trace( 'BAL TYPE ID '||

146:
147: end if;
148:
149: hr_utility.trace( 'p_balance_type_id '||p_balance_type_id);
150: hr_utility.trace( 'BAL TYPE ID '||
151: pay_mx_utility.hours_bal_tbl(i).hours_bal_type_id);
152:
153: end loop;
154:

Line 174: hr_utility.trace( 'HOURS BAL TYPE ID '||ln_hours_bal_type_id);

170: ln_hours_bal_type_id;
171: pay_mx_utility.hours_bal_tbl(p_balance_type_id).hours_bal_uom :=
172: lv_balance_uom;
173:
174: hr_utility.trace( 'HOURS BAL TYPE ID '||ln_hours_bal_type_id);
175:
176: END IF;
177:
178: ln_hours_bal_type_id :=

Line 235: hr_utility.trace('Entering '||lv_proc);

231:
232: lv_proc := g_package_name || 'get_days_yr_for_pay_period';
233:
234: IF (g_debug) THEN
235: hr_utility.trace('Entering '||lv_proc);
236: END IF;
237:
238: IF py_prd_tp.count = 0 THEN
239:

Line 283: hr_utility.trace('Leaving '||lv_proc);

279:
280: END IF;
281:
282: IF (g_debug) THEN
283: hr_utility.trace('Leaving '||lv_proc);
284: END IF;
285:
286: END get_days_yr_for_pay_period;
287:

Line 342: hr_utility.trace('Entering '||lv_proc);

338:
339: lv_proc := g_package_name || 'get_no_of_days_for_org';
340:
341: IF (g_debug) THEN
342: hr_utility.trace('Entering '||lv_proc);
343: END IF;
344:
345: IF (p_gre_or_le = 'GRE') THEN
346:

Line 403: hr_utility.trace('Leaving '||lv_proc);

399:
400: END IF;
401:
402: IF (g_debug) THEN
403: hr_utility.trace('Leaving '||lv_proc);
404: END IF;
405:
406: EXCEPTION
407: WHEN OTHERS THEN

Line 456: hr_utility.trace('Entering '||lv_proc);

452:
453: lv_proc := g_package_name || 'get_days_month_year';
454:
455: IF (g_debug) THEN
456: hr_utility.trace('Entering '||lv_proc);
457: END IF;
458:
459:
460: get_no_of_days_for_org( p_business_group_id => p_business_group_id

Line 516: hr_utility.trace('Leaving '||lv_proc);

512:
513: END IF;
514:
515: IF (g_debug) THEN
516: hr_utility.trace('Leaving '||lv_proc);
517: END IF;
518:
519: RETURN ln_days_month_year;
520:

Line 551: hr_utility.trace('Entering '||lv_proc);

547:
548: lv_proc := g_package_name || 'get_days_in_year';
549:
550: IF (g_debug) THEN
551: hr_utility.trace('Entering '||lv_proc);
552: END IF;
553:
554: ln_days := get_days_month_year(
555: p_business_group_id => p_business_group_id

Line 561: hr_utility.trace('Leaving '||lv_proc);

557: ,p_payroll_id => p_payroll_id
558: ,p_mode => 'YEAR' );
559:
560: IF (g_debug) THEN
561: hr_utility.trace('Leaving '||lv_proc);
562: END IF;
563:
564: RETURN ln_days;
565:

Line 596: hr_utility.trace('Entering '||lv_proc);

592:
593: lv_proc := g_package_name || 'get_days_in_month';
594:
595: IF (g_debug) THEN
596: hr_utility.trace('Entering '||lv_proc);
597: END IF;
598:
599: ln_days := get_days_month_year(
600: p_business_group_id => p_business_group_id

Line 606: hr_utility.trace('Leaving '||lv_proc);

602: ,p_payroll_id => p_payroll_id
603: ,p_mode => 'MONTH' );
604:
605: IF (g_debug) THEN
606: hr_utility.trace('Leaving '||lv_proc);
607: END IF;
608:
609: RETURN ln_days;
610:

Line 663: hr_utility.trace('Entering '||lv_proc);

659:
660: lv_proc := g_package_name || 'get_days_in_pay_period';
661:
662: IF (g_debug) THEN
663: hr_utility.trace('Entering '||lv_proc);
664: END IF;
665:
666: OPEN c_pay_prd_type(p_payroll_id);
667: FETCH c_pay_prd_type INTO lv_prd_type;

Line 723: hr_utility.trace('Leaving '||lv_proc);

719:
720: END IF;
721:
722: IF (g_debug) THEN
723: hr_utility.trace('Leaving '||lv_proc);
724: END IF;
725:
726: RETURN ln_days;
727:

Line 757: hr_utility.trace('Entering '||lv_proc);

753:
754: lv_proc := g_package_name || 'get_days_in_bimonth';
755:
756: IF (g_debug) THEN
757: hr_utility.trace('Entering '||lv_proc);
758: END IF;
759:
760: open c_get_days_in_bimonth ;
761: fetch c_get_days_in_bimonth into ln_days ;

Line 765: hr_utility.trace('Leaving '||lv_proc);

761: fetch c_get_days_in_bimonth into ln_days ;
762: close c_get_days_in_bimonth ;
763:
764: IF (g_debug) THEN
765: hr_utility.trace('Leaving '||lv_proc);
766: END IF;
767:
768: RETURN ln_days;
769:

Line 834: hr_utility.trace('ln_exists ' ||ln_exists);

830: FROM pay_ele_tmplt_class_usages
831: WHERE classification_id = p_classification_id
832: AND template_id = p_template_id;
833:
834: hr_utility.trace('ln_exists ' ||ln_exists);
835:
836: IF ln_exists = 0 THEN
837:
838: SELECT pay_ele_tmplt_class_usg_s.nextval

Line 842: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);

838: SELECT pay_ele_tmplt_class_usg_s.nextval
839: INTO ln_ele_tmplt_class_id
840: FROM dual;
841:
842: hr_utility.trace('ln_ele_tmplt_class_id ' ||ln_ele_tmplt_class_id);
843:
844: INSERT INTO pay_ele_tmplt_class_usages
845: ( ele_template_classification_id
846: ,classification_id

Line 924: --hr_utility.trace_on(null,'ETCU');

920: l_display_arrearage(3) := 'Y';
921:
922: END IF;
923:
924: --hr_utility.trace_on(null,'ETCU');
925:
926: FOR i IN l_classification_name.FIRST..l_classification_name.LAST
927: LOOP
928:

Line 931: hr_utility.trace('------------------------------------------------');

927: LOOP
928:
929: l_classification_id := get_classification_id( l_classification_name(i) );
930:
931: hr_utility.trace('------------------------------------------------');
932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);

Line 932: hr_utility.trace('i '|| i );

928:
929: l_classification_id := get_classification_id( l_classification_name(i) );
930:
931: hr_utility.trace('------------------------------------------------');
932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));

Line 933: hr_utility.trace('l_classification_name '|| l_classification_name(i));

929: l_classification_id := get_classification_id( l_classification_name(i) );
930:
931: hr_utility.trace('------------------------------------------------');
932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));
937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));

Line 934: hr_utility.trace('l_classification_id '|| l_classification_id);

930:
931: hr_utility.trace('------------------------------------------------');
932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));
937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));
938:

Line 935: hr_utility.trace('p_template_id '|| p_template_id);

931: hr_utility.trace('------------------------------------------------');
932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));
937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));
938:
939:

Line 936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));

932: hr_utility.trace('i '|| i );
933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));
937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));
938:
939:
940: create_ele_tmplt_class_usg(

Line 937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));

933: hr_utility.trace('l_classification_name '|| l_classification_name(i));
934: hr_utility.trace('l_classification_id '|| l_classification_id);
935: hr_utility.trace('p_template_id '|| p_template_id);
936: hr_utility.trace('l_display_proc_mode '|| l_display_proc_mode(i));
937: hr_utility.trace('l_display_arrearage '|| l_display_arrearage(i));
938:
939:
940: create_ele_tmplt_class_usg(
941: p_classification_id => l_classification_id

Line 1107: hr_utility.trace('Entering ..get_process_parameters');

1103: WHERE payroll_action_id = p_cntx_payroll_action_id;
1104:
1105: BEGIN
1106:
1107: hr_utility.trace('Entering ..get_process_parameters');
1108: OPEN c_get_parameter_value;
1109: FETCH c_get_parameter_value INTO l_legislation_parameters;
1110: CLOSE c_get_parameter_value;
1111:

Line 1114: hr_utility.trace('Parameter Name : '||p_parameter_name||' Value : '||par_value);

1110: CLOSE c_get_parameter_value;
1111:
1112: par_value := get_legi_param_val(p_parameter_name,l_legislation_parameters);
1113:
1114: hr_utility.trace('Parameter Name : '||p_parameter_name||' Value : '||par_value);
1115: hr_utility.trace('Leaving ..get_process_parameters');
1116: RETURN par_value;
1117:
1118: END get_process_parameters;

Line 1115: hr_utility.trace('Leaving ..get_process_parameters');

1111:
1112: par_value := get_legi_param_val(p_parameter_name,l_legislation_parameters);
1113:
1114: hr_utility.trace('Parameter Name : '||p_parameter_name||' Value : '||par_value);
1115: hr_utility.trace('Leaving ..get_process_parameters');
1116: RETURN par_value;
1117:
1118: END get_process_parameters;
1119:

Line 1183: hr_utility.trace('Economy Zone '||P_ECON_ZONE);

1179: l_min_wage number;
1180:
1181: BEGIN
1182:
1183: hr_utility.trace('Economy Zone '||P_ECON_ZONE);
1184: OPEN get_min_wage;
1185: FETCH get_min_wage INTO l_min_wage;
1186: CLOSE get_min_wage;
1187:

Line 1198: g_debug := hr_utility.debug_enabled;

1194:
1195: BEGIN
1196:
1197: g_package_name := 'pay_mx_utility.';
1198: g_debug := hr_utility.debug_enabled;
1199:
1200: END pay_mx_utility;