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

Line 58: Name : HR_UTILITY_TRACE

54:
55: EOL VARCHAR2(5);
56:
57: /****************************************************************************
58: Name : HR_UTILITY_TRACE
59: Description : This procedure prints debug messages.
60: *****************************************************************************/
61: PROCEDURE hr_utility_trace ( P_TRC_DATA VARCHAR2) AS
62: BEGIN

Line 61: PROCEDURE hr_utility_trace ( P_TRC_DATA VARCHAR2) AS

57: /****************************************************************************
58: Name : HR_UTILITY_TRACE
59: Description : This procedure prints debug messages.
60: *****************************************************************************/
61: PROCEDURE hr_utility_trace ( P_TRC_DATA VARCHAR2) AS
62: BEGIN
63: IF g_debug THEN
64: hr_utility.trace(p_trc_data);
65: END IF;

Line 64: hr_utility.trace(p_trc_data);

60: *****************************************************************************/
61: PROCEDURE hr_utility_trace ( P_TRC_DATA VARCHAR2) AS
62: BEGIN
63: IF g_debug THEN
64: hr_utility.trace(p_trc_data);
65: END IF;
66: END hr_utility_trace;
67:
68:

Line 66: END hr_utility_trace;

62: BEGIN
63: IF g_debug THEN
64: hr_utility.trace(p_trc_data);
65: END IF;
66: END hr_utility_trace;
67:
68:
69: /****************************************************************************
70: Name : PRINT_BLOB

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

189: l_xml VARCHAR2(240);
190:
191: BEGIN
192: l_proc_name := g_proc_name || 'LOAD_XML_INTERNAL';
193: hr_utility_trace ('Entering '||l_proc_name);
194:
195: IF p_node_type = 'CS' THEN
196:
197: l_xml := '<'||p_node||'>'||EOL;

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

213: END IF;
214:
215: write_to_magtape_lob (l_xml);
216:
217: hr_utility_trace ('Leaving '||l_proc_name);
218:
219: END load_xml_internal;
220:
221: /****************************************************************************

Line 252: hr_utility.set_location(lv_procedure_name, 10);

248: BEGIN
249:
250: lv_procedure_name := g_proc_name ||'.get_payroll_action_info';
251:
252: hr_utility.set_location(lv_procedure_name, 10);
253:
254: ln_step := 1;
255:
256: OPEN c_payroll_action_info(p_payroll_action_id);

Line 263: hr_utility.set_location(lv_procedure_name, 30);

259: ,ln_legal_er_id;
260: CLOSE c_payroll_action_info;
261:
262: ln_step := 2;
263: hr_utility.set_location(lv_procedure_name, 30);
264:
265: p_end_date := TRUNC(ld_end_date,'Y');
266: p_business_group_id := ln_business_group_id;
267: p_legal_employer_id := ln_legal_er_id;

Line 269: hr_utility.set_location(lv_procedure_name, 50);

265: p_end_date := TRUNC(ld_end_date,'Y');
266: p_business_group_id := ln_business_group_id;
267: p_legal_employer_id := ln_legal_er_id;
268:
269: hr_utility.set_location(lv_procedure_name, 50);
270:
271: EXCEPTION
272: WHEN OTHERS THEN
273: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||

Line 276: hr_utility.trace(lv_error_message || '-' || SQLERRM);

272: WHEN OTHERS THEN
273: lv_error_message := 'Error at step ' || ln_step || ' IN ' ||
274: lv_procedure_name;
275:
276: hr_utility.trace(lv_error_message || '-' || SQLERRM);
277:
278: lv_error_message :=
279: pay_emp_action_arch.set_error_message(lv_error_message);
280:

Line 281: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');

277:
278: lv_error_message :=
279: pay_emp_action_arch.set_error_message(lv_error_message);
280:
281: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
282: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
283: hr_utility.raise_error;
284:
285: END get_payroll_action_info;

Line 282: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);

278: lv_error_message :=
279: pay_emp_action_arch.set_error_message(lv_error_message);
280:
281: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
282: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
283: hr_utility.raise_error;
284:
285: END get_payroll_action_info;
286:

Line 283: hr_utility.raise_error;

279: pay_emp_action_arch.set_error_message(lv_error_message);
280:
281: hr_utility.set_message(801,'HR_ELE_ENTRY_FORMULA_HINT');
282: hr_utility.set_message_token('FORMULA_TEXT', lv_error_message);
283: hr_utility.raise_error;
284:
285: END get_payroll_action_info;
286:
287: /****************************************************************************

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

295:
296: BEGIN
297: l_proc_name := g_proc_name || 'RANGE_CURSOR';
298:
299: hr_utility_trace ('Entering '||l_proc_name);
300:
301: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
302:
303: get_payroll_action_info (p_payroll_action_id

Line 301: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);

297: l_proc_name := g_proc_name || 'RANGE_CURSOR';
298:
299: hr_utility_trace ('Entering '||l_proc_name);
300:
301: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
302:
303: get_payroll_action_info (p_payroll_action_id
304: ,gd_effective_date
305: ,gn_business_group_id

Line 308: hr_utility_trace ('gd_effective_date = '|| gd_effective_date);

304: ,gd_effective_date
305: ,gn_business_group_id
306: ,gn_legal_er_id);
307:
308: hr_utility_trace ('gd_effective_date = '|| gd_effective_date);
309: hr_utility_trace ('gn_business_group_id = '|| gn_business_group_id);
310: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
311:
312: p_sqlstr := '

Line 309: hr_utility_trace ('gn_business_group_id = '|| gn_business_group_id);

305: ,gn_business_group_id
306: ,gn_legal_er_id);
307:
308: hr_utility_trace ('gd_effective_date = '|| gd_effective_date);
309: hr_utility_trace ('gn_business_group_id = '|| gn_business_group_id);
310: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
311:
312: p_sqlstr := '
313: SELECT DISTINCT paa_arch.serial_number

Line 310: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);

306: ,gn_legal_er_id);
307:
308: hr_utility_trace ('gd_effective_date = '|| gd_effective_date);
309: hr_utility_trace ('gn_business_group_id = '|| gn_business_group_id);
310: hr_utility_trace ('gn_legal_er_id = '|| gn_legal_er_id);
311:
312: p_sqlstr := '
313: SELECT DISTINCT paa_arch.serial_number
314: FROM pay_assignment_actions paa_arch

Line 330: hr_utility_trace ('Range cursor query : ' || p_sqlstr);

326: AND paa_arch.action_status = ''C''
327: AND :p_payroll_action_id = '||p_payroll_action_id||'
328: ORDER BY serial_number';
329:
330: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
331: hr_utility_trace ('Leaving '||l_proc_name);
332:
333: END range_cursor;
334:

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

327: AND :p_payroll_action_id = '||p_payroll_action_id||'
328: ORDER BY serial_number';
329:
330: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
331: hr_utility_trace ('Leaving '||l_proc_name);
332:
333: END range_cursor;
334:
335:

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

409: ln_asg_count number;
410: BEGIN
411: l_proc_name := g_proc_name || 'ACTION_CREATION';
412:
413: hr_utility_trace ('Entering '||l_proc_name);
414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

Line 414: hr_utility_trace ('Parameters ....');

410: BEGIN
411: l_proc_name := g_proc_name || 'ACTION_CREATION';
412:
413: hr_utility_trace ('Entering '||l_proc_name);
414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

Line 415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);

411: l_proc_name := g_proc_name || 'ACTION_CREATION';
412:
413: hr_utility_trace ('Entering '||l_proc_name);
414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
419:

Line 416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);

412:
413: hr_utility_trace ('Entering '||l_proc_name);
414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
419:
420: ln_prev_person_id := -1;

Line 417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

413: hr_utility_trace ('Entering '||l_proc_name);
414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
419:
420: ln_prev_person_id := -1;
421: ln_prev_asg_id := -1;

Line 418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

414: hr_utility_trace ('Parameters ....');
415: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
416: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
417: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
418: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
419:
420: ln_prev_person_id := -1;
421: ln_prev_asg_id := -1;
422: ln_prev_arch_pact_id := -1;

Line 443: hr_utility_trace ('Person ranges are ON');

439: ,p_report_category => 'RT');
440:
441: IF lb_range_person_on THEN
442:
443: hr_utility_trace ('Person ranges are ON');
444:
445: OPEN c_arch_asg_range( gn_business_group_id
446: ,gn_legal_er_id
447: ,gd_effective_date

Line 453: hr_utility_trace ('Person ranges are OFF');

449: ,p_payroll_action_id);
450:
451: ELSE
452:
453: hr_utility_trace ('Person ranges are OFF');
454:
455: OPEN c_arch_asg( gn_business_group_id
456: ,gn_legal_er_id
457: ,gd_effective_date

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

476: END IF;
477:
478: ln_asg_count := ln_asg_count + 1;
479:
480: hr_utility_trace ('-------------');
481: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
482: hr_utility_trace('Current person = '||ln_person_id);
483: hr_utility_trace('Previous person = '||ln_prev_person_id);
484:

Line 481: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);

477:
478: ln_asg_count := ln_asg_count + 1;
479:
480: hr_utility_trace ('-------------');
481: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
482: hr_utility_trace('Current person = '||ln_person_id);
483: hr_utility_trace('Previous person = '||ln_prev_person_id);
484:
485: IF (ln_person_id <> ln_prev_person_id) THEN

Line 482: hr_utility_trace('Current person = '||ln_person_id);

478: ln_asg_count := ln_asg_count + 1;
479:
480: hr_utility_trace ('-------------');
481: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
482: hr_utility_trace('Current person = '||ln_person_id);
483: hr_utility_trace('Previous person = '||ln_prev_person_id);
484:
485: IF (ln_person_id <> ln_prev_person_id) THEN
486:

Line 483: hr_utility_trace('Previous person = '||ln_prev_person_id);

479:
480: hr_utility_trace ('-------------');
481: hr_utility_trace('Current archiver asg action = '||ln_arch_act_id);
482: hr_utility_trace('Current person = '||ln_person_id);
483: hr_utility_trace('Previous person = '||ln_prev_person_id);
484:
485: IF (ln_person_id <> ln_prev_person_id) THEN
486:
487: SELECT pay_assignment_actions_s.nextval

Line 491: hr_utility_trace('Creating magtape assignment action '||

487: SELECT pay_assignment_actions_s.nextval
488: INTO ln_mag_asg_act_id
489: FROM dual;
490:
491: hr_utility_trace('Creating magtape assignment action '||
492: ln_mag_asg_act_id);
493:
494: hr_nonrun_asact.insact(ln_mag_asg_act_id
495: ,ln_assignment_id

Line 504: hr_utility.trace('Locking Action in IF = ' || ln_mag_asg_act_id);

500: ,'U'
501: ,null);
502:
503: -- insert an interlock to this action
504: hr_utility.trace('Locking Action in IF = ' || ln_mag_asg_act_id);
505: hr_utility.trace('Locked Action in IF = ' || ln_arch_act_id);
506:
507: hr_nonrun_asact.insint(ln_mag_asg_act_id,
508: ln_arch_act_id);

Line 505: hr_utility.trace('Locked Action in IF = ' || ln_arch_act_id);

501: ,null);
502:
503: -- insert an interlock to this action
504: hr_utility.trace('Locking Action in IF = ' || ln_mag_asg_act_id);
505: hr_utility.trace('Locked Action in IF = ' || ln_arch_act_id);
506:
507: hr_nonrun_asact.insint(ln_mag_asg_act_id,
508: ln_arch_act_id);
509:

Line 513: hr_utility.trace('Locking Action in ELSE = ' || ln_mag_asg_act_id);

509:
510: ELSE
511:
512: -- insert an interlock to this action
513: hr_utility.trace('Locking Action in ELSE = ' || ln_mag_asg_act_id);
514: hr_utility.trace('Locked Action in ELSE = ' || ln_arch_act_id);
515:
516: hr_nonrun_asact.insint(ln_mag_asg_act_id,
517: ln_arch_act_id);

Line 514: hr_utility.trace('Locked Action in ELSE = ' || ln_arch_act_id);

510: ELSE
511:
512: -- insert an interlock to this action
513: hr_utility.trace('Locking Action in ELSE = ' || ln_mag_asg_act_id);
514: hr_utility.trace('Locked Action in ELSE = ' || ln_arch_act_id);
515:
516: hr_nonrun_asact.insint(ln_mag_asg_act_id,
517: ln_arch_act_id);
518:

Line 525: hr_utility_trace(ln_asg_count || ' archiver actions processed in chunk '||

521: ln_prev_person_id := ln_person_id;
522:
523: END LOOP;
524:
525: hr_utility_trace(ln_asg_count || ' archiver actions processed in chunk '||
526: p_chunk);
527:
528: IF lb_range_person_on THEN
529: CLOSE c_arch_asg_range;

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

530: ELSE
531: CLOSE c_arch_asg;
532: END IF;
533:
534: hr_utility_trace ('Leaving '||l_proc_name);
535:
536: END action_creation;
537:
538: /****************************************************************************

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

614: ln_session_id NUMBER;
615:
616: BEGIN
617: l_proc_name := g_proc_name || 'GENERATE_XML';
618: hr_utility_trace ('Entering '||l_proc_name);
619:
620: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
621: ('TRANSFER_ACT_ID');
622:

Line 623: hr_utility_trace ('Fetching transactions for magtape asg action '||

619:
620: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
621: ('TRANSFER_ACT_ID');
622:
623: hr_utility_trace ('Fetching transactions for magtape asg action '||
624: ln_assignment_action_id);
625:
626: format2d_xml_tbl.DELETE;
627:

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

903:
904:
905: END IF;
906:
907: hr_utility_trace ('Leaving '||l_proc_name);
908:
909: /*EXCEPTION
910: WHEN OTHERS THEN
911: hr_utility_trace (SQLERRM);

Line 911: hr_utility_trace (SQLERRM);

907: hr_utility_trace ('Leaving '||l_proc_name);
908:
909: /*EXCEPTION
910: WHEN OTHERS THEN
911: hr_utility_trace (SQLERRM);
912: RAISE; */
913: END GENERATE_XML;
914:
915:

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

922: l_proc_name varchar2(100);
923: lv_buf varchar2(2000);
924: BEGIN
925: l_proc_name := g_proc_name || 'GENERATE_XML_HEADER';
926: hr_utility_trace ('Entering '||l_proc_name);
927:
928: hr_utility_trace ('Root XML tag = '||
929: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
930:

Line 928: hr_utility_trace ('Root XML tag = '||

924: BEGIN
925: l_proc_name := g_proc_name || 'GENERATE_XML_HEADER';
926: hr_utility_trace ('Entering '||l_proc_name);
927:
928: hr_utility_trace ('Root XML tag = '||
929: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
930:
931: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
932:

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

931: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
932:
933: write_to_magtape_lob (lv_buf);
934:
935: hr_utility_trace ('Leaving '||l_proc_name);
936: END generate_xml_header;
937:
938:
939: /****************************************************************************

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

1020: BEGIN
1021:
1022: l_proc_name := g_proc_name || 'GENERATE_XML_FOOTER';
1023:
1024: hr_utility_trace ('Entering '||l_proc_name);
1025:
1026: format2d_xml_tbl.DELETE;
1027:
1028: ln_payroll_action_id := pay_magtape_generic.get_parameter_value(

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

1155: DELETE FROM pay_us_rpt_totals
1156: WHERE tax_unit_id = ln_payroll_action_id;
1157:
1158:
1159: hr_utility_trace ('Leaving '||l_proc_name);
1160: END generate_xml_footer;
1161:
1162: BEGIN
1163: --hr_utility.trace_on(null, 'PAYMX2D');

Line 1163: --hr_utility.trace_on(null, 'PAYMX2D');

1159: hr_utility_trace ('Leaving '||l_proc_name);
1160: END generate_xml_footer;
1161:
1162: BEGIN
1163: --hr_utility.trace_on(null, 'PAYMX2D');
1164: g_proc_name := 'PAY_MX_FORMAT_2D.';
1165: g_debug := hr_utility.debug_enabled;
1166: g_document_type := 'MX_FORMAT2D_MAG';
1167: END PAY_MX_FORMAT_2D;

Line 1165: g_debug := hr_utility.debug_enabled;

1161:
1162: BEGIN
1163: --hr_utility.trace_on(null, 'PAYMX2D');
1164: g_proc_name := 'PAY_MX_FORMAT_2D.';
1165: g_debug := hr_utility.debug_enabled;
1166: g_document_type := 'MX_FORMAT2D_MAG';
1167: END PAY_MX_FORMAT_2D;