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_RULES dependencies on HR_UTILITY

Line 9: Name : HR_UTILITY_TRACE

5: g_proc_name varchar2(100);
6: g_debug BOOLEAN;
7:
8: /****************************************************************************
9: Name : HR_UTILITY_TRACE
10: Description : This procedure prints debug messages.
11: *****************************************************************************/
12: PROCEDURE HR_UTILITY_TRACE
13: (

Line 12: PROCEDURE HR_UTILITY_TRACE

8: /****************************************************************************
9: Name : HR_UTILITY_TRACE
10: Description : This procedure prints debug messages.
11: *****************************************************************************/
12: PROCEDURE HR_UTILITY_TRACE
13: (
14: P_TRC_DATA varchar2
15: ) AS
16: BEGIN

Line 18: hr_utility.trace(p_trc_data);

14: P_TRC_DATA varchar2
15: ) AS
16: BEGIN
17: IF g_debug THEN
18: hr_utility.trace(p_trc_data);
19: END IF;
20: END HR_UTILITY_TRACE;
21:
22:

Line 20: END HR_UTILITY_TRACE;

16: BEGIN
17: IF g_debug THEN
18: hr_utility.trace(p_trc_data);
19: END IF;
20: END HR_UTILITY_TRACE;
21:
22:
23: /****************************************************************************
24: Name : LOAD_XML

Line 35: hr_utility_trace ('Entering '||l_proc_name);

31: l_data pay_action_information.action_information1%type;
32:
33: BEGIN
34: l_proc_name := g_proc_name || 'LOAD_XML';
35: hr_utility_trace ('Entering '||l_proc_name);
36: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()):=
37: p_xml;
38: hr_utility_trace ('Leaving '||l_proc_name);
39: END LOAD_XML;

Line 38: hr_utility_trace ('Leaving '||l_proc_name);

34: l_proc_name := g_proc_name || 'LOAD_XML';
35: hr_utility_trace ('Entering '||l_proc_name);
36: pay_payroll_xml_extract_pkg.g_custom_xml(pay_payroll_xml_extract_pkg.g_custom_xml.count()):=
37: p_xml;
38: hr_utility_trace ('Leaving '||l_proc_name);
39: END LOAD_XML;
40:
41:
42: /****************************************************************************

Line 56: hr_utility_trace ('Entering '||l_proc_name);

52: l_data pay_action_information.action_information1%type;
53:
54: BEGIN
55: l_proc_name := g_proc_name || 'PREPARE_XML';
56: hr_utility_trace ('Entering '||l_proc_name);
57:
58: IF p_node_type = 'CS' THEN
59: load_xml ('<'||p_node||'>');
60: ELSIF p_node_type = 'CE' THEN

Line 72: hr_utility_trace ('Leaving '||l_proc_name);

68: l_data := REPLACE (l_data, '"', '"');
69: load_xml ('<'||p_node||'>'||l_data||'');
70: END IF;
71:
72: hr_utility_trace ('Leaving '||l_proc_name);
73: END PREPARE_XML;
74:
75:
76: /****************************************************************************

Line 101: hr_utility_trace ('Entering '||l_proc_name);

97:
98:
99: BEGIN
100: l_proc_name := g_proc_name || 'STRIP_SPL_CHARS';
101: hr_utility_trace ('Entering '||l_proc_name);
102: hr_utility_trace ('p_in_string = '||p_in_string);
103:
104: lv_db_charset := SUBSTR(USERENV('LANGUAGE'),
105: INSTR(USERENV('LANGUAGE'), '.') + 1);

Line 102: hr_utility_trace ('p_in_string = '||p_in_string);

98:
99: BEGIN
100: l_proc_name := g_proc_name || 'STRIP_SPL_CHARS';
101: hr_utility_trace ('Entering '||l_proc_name);
102: hr_utility_trace ('p_in_string = '||p_in_string);
103:
104: lv_db_charset := SUBSTR(USERENV('LANGUAGE'),
105: INSTR(USERENV('LANGUAGE'), '.') + 1);
106:

Line 107: hr_utility_trace ('lv_db_charset = '||lv_db_charset);

103:
104: lv_db_charset := SUBSTR(USERENV('LANGUAGE'),
105: INSTR(USERENV('LANGUAGE'), '.') + 1);
106:
107: hr_utility_trace ('lv_db_charset = '||lv_db_charset);
108:
109: IF lv_db_charset = 'WE8ISO8859P1' THEN
110: lv_conv_string := upper(p_in_string);
111: ELSE

Line 119: hr_utility_trace ('Current char = "'|| lv_curr_char ||'"');

115: FOR cntr IN 1..NVL(length (lv_conv_string),0) LOOP
116: lv_repl_char := 'NONE';
117:
118: lv_curr_char := SUBSTR(lv_conv_string, cntr, 1);
119: hr_utility_trace ('Current char = "'|| lv_curr_char ||'"');
120:
121: IF lv_db_charset <> 'WE8ISO8859P1' THEN
122: lv_hex_code := RAWTOHEX (UTL_RAW.cast_to_RAW(lv_curr_char));
123: hr_utility_trace ('Hex Code = '|| lv_hex_code);

Line 123: hr_utility_trace ('Hex Code = '|| lv_hex_code);

119: hr_utility_trace ('Current char = "'|| lv_curr_char ||'"');
120:
121: IF lv_db_charset <> 'WE8ISO8859P1' THEN
122: lv_hex_code := RAWTOHEX (UTL_RAW.cast_to_RAW(lv_curr_char));
123: hr_utility_trace ('Hex Code = '|| lv_hex_code);
124:
125: OPEN get_repl_char (lv_hex_code);
126: FETCH get_repl_char INTO lv_repl_char;
127: CLOSE get_repl_char;

Line 130: hr_utility_trace('lv_repl_char '||lv_repl_char);

126: FETCH get_repl_char INTO lv_repl_char;
127: CLOSE get_repl_char;
128: ELSE
129: lv_repl_char := ASCII(lv_curr_char);
130: hr_utility_trace('lv_repl_char '||lv_repl_char);
131:
132: IF lv_repl_char = 193 THEN
133: lv_repl_char := 'A';
134: ELSIF lv_repl_char = 201 THEN

Line 151: hr_utility_trace ('Character "' || lv_curr_char ||'" not replaced');

147:
148: END IF;
149:
150: IF lv_repl_char = 'NONE' THEN
151: hr_utility_trace ('Character "' || lv_curr_char ||'" not replaced');
152: lv_return := lv_return || lv_curr_char;
153: ELSE
154: hr_utility_trace ('Character "' ||lv_curr_char ||'" replaced by ' ||
155: lv_repl_char);

Line 154: hr_utility_trace ('Character "' ||lv_curr_char ||'" replaced by ' ||

150: IF lv_repl_char = 'NONE' THEN
151: hr_utility_trace ('Character "' || lv_curr_char ||'" not replaced');
152: lv_return := lv_return || lv_curr_char;
153: ELSE
154: hr_utility_trace ('Character "' ||lv_curr_char ||'" replaced by ' ||
155: lv_repl_char);
156: lv_return := lv_return || lv_repl_char;
157: END IF;
158: hr_utility_trace ('-------------');

Line 158: hr_utility_trace ('-------------');

154: hr_utility_trace ('Character "' ||lv_curr_char ||'" replaced by ' ||
155: lv_repl_char);
156: lv_return := lv_return || lv_repl_char;
157: END IF;
158: hr_utility_trace ('-------------');
159: END LOOP;
160:
161: lv_return := UPPER(CONVERT(lv_return, lv_db_charset, 'UTF8'));
162:

Line 163: hr_utility_trace ('lv_return = '||lv_return);

159: END LOOP;
160:
161: lv_return := UPPER(CONVERT(lv_return, lv_db_charset, 'UTF8'));
162:
163: hr_utility_trace ('lv_return = '||lv_return);
164: hr_utility_trace ('Leaving '||l_proc_name);
165: RETURN (lv_return);
166: END STRIP_SPL_CHARS;
167:

Line 164: hr_utility_trace ('Leaving '||l_proc_name);

160:
161: lv_return := UPPER(CONVERT(lv_return, lv_db_charset, 'UTF8'));
162:
163: hr_utility_trace ('lv_return = '||lv_return);
164: hr_utility_trace ('Leaving '||l_proc_name);
165: RETURN (lv_return);
166: END STRIP_SPL_CHARS;
167:
168:

Line 266: hr_utility_trace('Entering pay_mx_rules.element_template_pre_process');

262: l_rec PAY_ELE_TMPLT_OBJ;
263: BEGIN
264: l_rec := p_rec;
265:
266: hr_utility_trace('Entering pay_mx_rules.element_template_pre_process');
267:
268: hr_utility_trace('Legislation Code '||l_rec.legislation_code);
269:
270: IF ( instr( p_rec.element_classification, 'Earnings' ) > 0 OR

Line 268: hr_utility_trace('Legislation Code '||l_rec.legislation_code);

264: l_rec := p_rec;
265:
266: hr_utility_trace('Entering pay_mx_rules.element_template_pre_process');
267:
268: hr_utility_trace('Legislation Code '||l_rec.legislation_code);
269:
270: IF ( instr( p_rec.element_classification, 'Earnings' ) > 0 OR
271: p_rec.element_classification = 'Amends' ) THEN
272:

Line 302: hr_utility_trace('Leaving pay_mx_rules.element_template_pre_process');

298: END IF;
299:
300: END IF;
301:
302: hr_utility_trace('Leaving pay_mx_rules.element_template_pre_process');
303:
304: RETURN l_rec;
305:
306: END element_template_pre_process;

Line 377: hr_utility_trace('Entering pay_mx_rules.element_template_post_process');

373: lv_eei_info13 VARCHAR2(240);
374:
375: BEGIN
376:
377: hr_utility_trace('Entering pay_mx_rules.element_template_post_process');
378:
379: hr_utility_trace('p_element_template_id '|| p_element_template_id );
380:
381: OPEN c_tmplt_info( p_element_template_id );

Line 379: hr_utility_trace('p_element_template_id '|| p_element_template_id );

375: BEGIN
376:
377: hr_utility_trace('Entering pay_mx_rules.element_template_post_process');
378:
379: hr_utility_trace('p_element_template_id '|| p_element_template_id );
380:
381: OPEN c_tmplt_info( p_element_template_id );
382: FETCH c_tmplt_info INTO l_tmplt;
383: CLOSE c_tmplt_info;

Line 513: hr_utility_trace('Created PQP_UK_RATE_TYPE:'||l_rate_type(i));

509: ,p_eei_information2 => l_rate_desc(i)
510: ,p_element_type_extra_info_id => l_element_type_extra_info_id
511: ,p_object_version_number => l_object_version_number
512: );
513: hr_utility_trace('Created PQP_UK_RATE_TYPE:'||l_rate_type(i));
514: END LOOP;
515: END IF;
516:
517: /* If the created element belongs to social foresight or Employer

Line 550: hr_utility_trace('Leaving pay_mx_rules.element_template_post_process');

546: END LOOP;
547: CLOSE get_sub_classifications;
548: END IF;
549:
550: hr_utility_trace('Leaving pay_mx_rules.element_template_post_process');
551:
552: END element_template_post_process;
553:
554: PROCEDURE add_custom_xml

Line 688: hr_utility_trace('Custom Params : '||

684: LOOP
685: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
686: = p_param_name
687: THEN
688: hr_utility_trace('Custom Params : '||
689: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
690:
691: hr_utility_trace('Custom Params Value : '||
692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).

Line 691: hr_utility_trace('Custom Params Value : '||

687: THEN
688: hr_utility_trace('Custom Params : '||
689: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
690:
691: hr_utility_trace('Custom Params Value : '||
692: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
693: parameter_value);
694:
695: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).

Line 706: hr_utility_trace('Entering '||l_proc_name);

702: END;
703:
704: BEGIN
705: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
706: hr_utility_trace('Entering '||l_proc_name);
707: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
708: hr_utility_trace('p_action_information_category '||
709: p_action_information_category);
710: hr_utility_trace('p_document_type '|| p_document_type);

Line 707: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);

703:
704: BEGIN
705: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
706: hr_utility_trace('Entering '||l_proc_name);
707: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
708: hr_utility_trace('p_action_information_category '||
709: p_action_information_category);
710: hr_utility_trace('p_document_type '|| p_document_type);
711:

Line 708: hr_utility_trace('p_action_information_category '||

704: BEGIN
705: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
706: hr_utility_trace('Entering '||l_proc_name);
707: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
708: hr_utility_trace('p_action_information_category '||
709: p_action_information_category);
710: hr_utility_trace('p_document_type '|| p_document_type);
711:
712: /* For Direct Deposit */

Line 710: hr_utility_trace('p_document_type '|| p_document_type);

706: hr_utility_trace('Entering '||l_proc_name);
707: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
708: hr_utility_trace('p_action_information_category '||
709: p_action_information_category);
710: hr_utility_trace('p_document_type '|| p_document_type);
711:
712: /* For Direct Deposit */
713:
714: IF (p_document_type = 'DEPOSIT_XML') AND

Line 730: hr_utility_trace('ln_tax_unit_id '|| ln_tax_unit_id);

726: OPEN get_tax_unit_id(p_assignment_action_id);
727: FETCH get_tax_unit_id INTO ln_tax_unit_id;
728: CLOSE get_tax_unit_id;
729:
730: hr_utility_trace('ln_tax_unit_id '|| ln_tax_unit_id);
731:
732: OPEN c_get_bus_grp_id(ln_tax_unit_id);
733: FETCH c_get_bus_grp_id INTO ln_bus_grp_id;
734: CLOSE c_get_bus_grp_id;

Line 736: hr_utility_trace('ln_bus_grp_id '|| ln_bus_grp_id);

732: OPEN c_get_bus_grp_id(ln_tax_unit_id);
733: FETCH c_get_bus_grp_id INTO ln_bus_grp_id;
734: CLOSE c_get_bus_grp_id;
735:
736: hr_utility_trace('ln_bus_grp_id '|| ln_bus_grp_id);
737:
738: ln_legal_employer_id :=
739: hr_mx_utility.get_legal_employer(ln_bus_grp_id, ln_tax_unit_id);
740: hr_utility_trace('ln_legal_employer_id '|| ln_legal_employer_id);

Line 740: hr_utility_trace('ln_legal_employer_id '|| ln_legal_employer_id);

736: hr_utility_trace('ln_bus_grp_id '|| ln_bus_grp_id);
737:
738: ln_legal_employer_id :=
739: hr_mx_utility.get_legal_employer(ln_bus_grp_id, ln_tax_unit_id);
740: hr_utility_trace('ln_legal_employer_id '|| ln_legal_employer_id);
741:
742:
743: OPEN c_get_employer_information(ln_legal_employer_id);
744: FETCH c_get_employer_information INTO lv_org_name

Line 786: hr_utility_trace('lv_org_name '|| lv_org_name);

782: FETCH get_account_type INTO lv_account_type
783: ,l_org_payment_method_id;
784: CLOSE get_account_type;
785:
786: hr_utility_trace('lv_org_name '|| lv_org_name);
787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);

Line 787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);

783: ,l_org_payment_method_id;
784: CLOSE get_account_type;
785:
786: hr_utility_trace('lv_org_name '|| lv_org_name);
787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);

Line 788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);

784: CLOSE get_account_type;
785:
786: hr_utility_trace('lv_org_name '|| lv_org_name);
787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);

Line 789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);

785:
786: hr_utility_trace('lv_org_name '|| lv_org_name);
787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);

Line 790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);

786: hr_utility_trace('lv_org_name '|| lv_org_name);
787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);

Line 791: hr_utility_trace('lv_postal_code '|| lv_postal_code);

787: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:

Line 792: hr_utility_trace('lv_country '|| lv_country);

788: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:
796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',

Line 793: hr_utility_trace('lv_state '|| lv_state);

789: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:
796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
797: lv_org_name);

Line 794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);

790: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
791: hr_utility_trace('lv_postal_code '|| lv_postal_code);
792: hr_utility_trace('lv_country '|| lv_country);
793: hr_utility_trace('lv_state '|| lv_state);
794: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
795:
796: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
797: lv_org_name);
798: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',

Line 868: hr_utility_trace ('Translating location_id ...');

864: prepare_xml('D',
865: 'EMPLOYEE_NAME_REPORTING',
866: strip_spl_chars (lv_employee_name ));
867:
868: hr_utility_trace ('Translating location_id ...');
869: prepare_xml('D',
870: 'LOCATION_ID_REPORTING',
871: strip_spl_chars (lv_location_id ));
872:

Line 877: hr_utility_trace('Leaving '||l_proc_name);

873: END IF;
874: END IF;
875: END IF;
876:
877: hr_utility_trace('Leaving '||l_proc_name);
878: EXCEPTION
879: WHEN OTHERS THEN
880: hr_utility_trace (SQLERRM);
881: RAISE;

Line 880: hr_utility_trace (SQLERRM);

876:
877: hr_utility_trace('Leaving '||l_proc_name);
878: EXCEPTION
879: WHEN OTHERS THEN
880: hr_utility_trace (SQLERRM);
881: RAISE;
882: end;
883: BEGIN
884: g_proc_name := 'PAY_MX_RULES.';

Line 885: g_debug := hr_utility.debug_enabled;

881: RAISE;
882: end;
883: BEGIN
884: g_proc_name := 'PAY_MX_RULES.';
885: g_debug := hr_utility.debug_enabled;
886: END pay_mx_rules;
887: