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

Line 10: Name : HR_UTILITY_TRACE

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

Line 13: PROCEDURE HR_UTILITY_TRACE

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

Line 19: hr_utility.trace(p_trc_data);

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

Line 21: END HR_UTILITY_TRACE;

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

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

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

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

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

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

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

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

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

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: PROCEDURE add_custom_xml

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

310: LOOP
311: IF pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name
312: = p_param_name
313: THEN
314: hr_utility_trace('Custom Params : '||
315: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
316:
317: hr_utility_trace('Custom Params Value : '||
318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).

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

313: THEN
314: hr_utility_trace('Custom Params : '||
315: pay_payroll_xml_extract_pkg.g_custom_params(cntr).parameter_name);
316:
317: hr_utility_trace('Custom Params Value : '||
318: pay_payroll_xml_extract_pkg.g_custom_params(cntr).
319: parameter_value);
320:
321: RETURN pay_payroll_xml_extract_pkg.g_custom_params(cntr).

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

328: END;
329:
330: BEGIN
331: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
332: hr_utility_trace('Entering '||l_proc_name);
333: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
334: hr_utility_trace('p_action_information_category '||
335: p_action_information_category);
336: hr_utility_trace('p_document_type '|| p_document_type);

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

329:
330: BEGIN
331: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
332: hr_utility_trace('Entering '||l_proc_name);
333: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
334: hr_utility_trace('p_action_information_category '||
335: p_action_information_category);
336: hr_utility_trace('p_document_type '|| p_document_type);
337:

Line 334: hr_utility_trace('p_action_information_category '||

330: BEGIN
331: l_proc_name := g_proc_name || 'ADD_CUSTOM_XML';
332: hr_utility_trace('Entering '||l_proc_name);
333: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
334: hr_utility_trace('p_action_information_category '||
335: p_action_information_category);
336: hr_utility_trace('p_document_type '|| p_document_type);
337:
338: /* For Direct Deposit */

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

332: hr_utility_trace('Entering '||l_proc_name);
333: hr_utility_trace('p_assignment_action_id '|| p_assignment_action_id);
334: hr_utility_trace('p_action_information_category '||
335: p_action_information_category);
336: hr_utility_trace('p_document_type '|| p_document_type);
337:
338: /* For Direct Deposit */
339:
340: IF (p_document_type = 'DEPOSIT_XML') AND

Line 344: hr_utility.trace('Entered pay_ip_rules.add_custom _xml Employer section');

340: IF (p_document_type = 'DEPOSIT_XML') AND
341: (p_assignment_action_id IS NOT NULL) AND
342: (get_param_val('p_xml_level') = 'ER') THEN
343:
344: hr_utility.trace('Entered pay_ip_rules.add_custom _xml Employer section');
345:
346: OPEN c_get_employer_info(p_assignment_action_id);
347: FETCH c_get_employer_info INTO ln_bus_grp_id, lv_legislation_code;
348: CLOSE c_get_employer_info;

Line 354: hr_utility.trace('lv_userdefined_proc_er '|| lv_userdefined_proc_er);

350: OPEN c_get_userdefined_proc(ln_bus_grp_id, lv_legislation_code);
351: FETCH c_get_userdefined_proc INTO lv_userdefined_proc_er;
352: CLOSE c_get_userdefined_proc;
353:
354: hr_utility.trace('lv_userdefined_proc_er '|| lv_userdefined_proc_er);
355:
356: IF lv_userdefined_proc_er IS NOT NULL THEN
357: EXECUTE IMMEDIATE 'BEGIN '||lv_userdefined_proc_er||'(:1,:2,:3); END;'
358: USING IN p_assignment_action_id,'DIRECT_DEPOSIT','DEPOSIT_HEADER';

Line 372: hr_utility.trace('Entered pay_ip_rules.add_custom _xml Employee section');

368: IF (p_document_type = 'DEPOSIT_XML') AND
369: (p_assignment_action_id IS NOT NULL) AND
370: (get_param_val('p_xml_level') = 'EE') THEN
371:
372: hr_utility.trace('Entered pay_ip_rules.add_custom _xml Employee section');
373:
374: OPEN get_tax_unit_id(p_assignment_action_id);
375: FETCH get_tax_unit_id INTO ln_tax_unit_id;
376: CLOSE get_tax_unit_id;

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

374: OPEN get_tax_unit_id(p_assignment_action_id);
375: FETCH get_tax_unit_id INTO ln_tax_unit_id;
376: CLOSE get_tax_unit_id;
377:
378: hr_utility_trace('ln_tax_unit_id '|| ln_tax_unit_id);
379:
380: IF ln_tax_unit_id IS NOT NULL THEN
381: OPEN c_get_bus_grp_id(ln_tax_unit_id);
382: FETCH c_get_bus_grp_id INTO ln_bus_grp_id;

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

386: FETCH c_get_bus_group_id INTO ln_bus_grp_id;
387: CLOSE c_get_bus_group_id;
388: END IF;
389:
390: hr_utility_trace('ln_bus_grp_id '|| ln_bus_grp_id);
391:
392: OPEN c_get_legislation_code(ln_bus_grp_id);
393: FETCH c_get_legislation_code INTO lv_legislation_code;
394: CLOSE c_get_legislation_code;

Line 396: hr_utility.trace('lv_legislation_code '|| lv_legislation_code);

392: OPEN c_get_legislation_code(ln_bus_grp_id);
393: FETCH c_get_legislation_code INTO lv_legislation_code;
394: CLOSE c_get_legislation_code;
395:
396: hr_utility.trace('lv_legislation_code '|| lv_legislation_code);
397:
398: OPEN c_get_userdefined_proc(ln_bus_grp_id, lv_legislation_code);
399: FETCH c_get_userdefined_proc INTO lv_userdefined_proc_ee;
400: CLOSE c_get_userdefined_proc;

Line 402: hr_utility.trace('lv_userdefined_proc_ee '|| lv_userdefined_proc_ee);

398: OPEN c_get_userdefined_proc(ln_bus_grp_id, lv_legislation_code);
399: FETCH c_get_userdefined_proc INTO lv_userdefined_proc_ee;
400: CLOSE c_get_userdefined_proc;
401:
402: hr_utility.trace('lv_userdefined_proc_ee '|| lv_userdefined_proc_ee);
403:
404: IF ln_tax_unit_id IS NOT NULL THEN
405: OPEN c_get_employer_information(ln_tax_unit_id);
406: FETCH c_get_employer_information INTO lv_org_name, ln_location_id;

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

443: ld_effective_date :=
444: fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value(
445: 'TRANSFER_EFFECTIVE_DATE'));
446:
447: hr_utility_trace('lv_org_name '|| lv_org_name);
448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);

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

444: fnd_date.canonical_to_date(pay_magtape_generic.get_parameter_value(
445: 'TRANSFER_EFFECTIVE_DATE'));
446:
447: hr_utility_trace('lv_org_name '|| lv_org_name);
448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);

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

445: 'TRANSFER_EFFECTIVE_DATE'));
446:
447: hr_utility_trace('lv_org_name '|| lv_org_name);
448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);

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

446:
447: hr_utility_trace('lv_org_name '|| lv_org_name);
448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);

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

447: hr_utility_trace('lv_org_name '|| lv_org_name);
448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:

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

448: hr_utility_trace('lv_address_line1 '|| lv_address_line1);
449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');

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

449: hr_utility_trace('lv_address_line2 '|| lv_address_line2);
450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);

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

450: hr_utility_trace('lv_address_line3 '|| lv_address_line3);
451: hr_utility_trace('lv_town_or_city '|| lv_town_or_city);
452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);

Line 456: hr_utility.trace('Employee Information');

452: hr_utility_trace('lv_postal_code '|| lv_postal_code);
453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);

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

453: hr_utility_trace('lv_country '|| lv_country);
454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);

Line 458: hr_utility_trace('lv_first_name '|| lv_first_name);

454: hr_utility_trace('lv_state '|| lv_state);
455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);

Line 459: hr_utility_trace('lv_last_name '|| lv_last_name);

455:
456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);

Line 460: hr_utility_trace('lv_middle_names '|| lv_middle_names);

456: hr_utility.trace('***Employee Information***');
457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);

Line 461: hr_utility_trace('lv_order_name '|| lv_order_name);

457: hr_utility_trace('lv_maternal_last_name '|| lv_maternal_last_name);
458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:

Line 462: hr_utility_trace('lv_full_name '|| lv_full_name);

458: hr_utility_trace('lv_first_name '|| lv_first_name);
459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:
466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',

Line 463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);

459: hr_utility_trace('lv_last_name '|| lv_last_name);
460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:
466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
467: lv_org_name);

Line 464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);

460: hr_utility_trace('lv_middle_names '|| lv_middle_names);
461: hr_utility_trace('lv_order_name '|| lv_order_name);
462: hr_utility_trace('lv_full_name '|| lv_full_name);
463: hr_utility_trace('lv_payroll_id '|| lv_payroll_id);
464: hr_utility_trace('lv_payroll_name '|| lv_payroll_name);
465:
466: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME',
467: lv_org_name);
468: pay_payroll_xml_extract_pkg.load_xml_data('D','EMPLOYER_NAME_REPORTING',

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

492: USING IN p_assignment_action_id,'DIRECT_DEPOSIT','';
493: END IF;
494: END IF;
495:
496: hr_utility_trace('Leaving '||l_proc_name);
497: EXCEPTION
498: WHEN OTHERS THEN
499: hr_utility_trace (SQLERRM);
500: RAISE;

Line 499: hr_utility_trace (SQLERRM);

495:
496: hr_utility_trace('Leaving '||l_proc_name);
497: EXCEPTION
498: WHEN OTHERS THEN
499: hr_utility_trace (SQLERRM);
500: RAISE;
501: end;
502:
503: BEGIN

Line 505: g_debug := hr_utility.debug_enabled;

501: end;
502:
503: BEGIN
504: g_proc_name := 'PAY_IP_RULES.';
505: g_debug := hr_utility.debug_enabled;
506: END pay_ip_rules;