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

Line 51: Name : HR_UTILITY_TRACE

47: g_end_date varchar2(25);
48:
49:
50: /****************************************************************************
51: Name : HR_UTILITY_TRACE
52: Description : This procedure prints debug messages.
53: *****************************************************************************/
54: PROCEDURE HR_UTILITY_TRACE
55: (

Line 54: PROCEDURE HR_UTILITY_TRACE

50: /****************************************************************************
51: Name : HR_UTILITY_TRACE
52: Description : This procedure prints debug messages.
53: *****************************************************************************/
54: PROCEDURE HR_UTILITY_TRACE
55: (
56: P_TRC_DATA varchar2
57: ) AS
58: BEGIN

Line 60: hr_utility.trace(p_trc_data);

56: P_TRC_DATA varchar2
57: ) AS
58: BEGIN
59: IF g_debug THEN
60: hr_utility.trace(p_trc_data);
61: END IF;
62: END HR_UTILITY_TRACE;
63:
64:

Line 62: END HR_UTILITY_TRACE;

58: BEGIN
59: IF g_debug THEN
60: hr_utility.trace(p_trc_data);
61: END IF;
62: END HR_UTILITY_TRACE;
63:
64:
65: /****************************************************************************
66: Name : PRINT_BLOB

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

122:
123: l_proc_name varchar2(100);
124: BEGIN
125: l_proc_name := g_proc_name || 'GET_PACT_INFO';
126: hr_utility_trace ('Entering '||l_proc_name);
127:
128: OPEN csr_get_mag_pact_info;
129: FETCH csr_get_mag_pact_info INTO p_gre_id,
130: p_start_date,

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

130: p_start_date,
131: p_end_date;
132: CLOSE csr_get_mag_pact_info;
133:
134: hr_utility_trace ('Leaving '||l_proc_name);
135: END GET_PACT_INFO;
136:
137:
138: /****************************************************************************

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

149:
150: BEGIN
151: l_proc_name := g_proc_name || 'RANGE_CURSOR';
152:
153: hr_utility_trace ('Entering '||l_proc_name);
154: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
155:
156: get_pact_info (p_payroll_action_id,
157: g_gre_id,

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

150: BEGIN
151: l_proc_name := g_proc_name || 'RANGE_CURSOR';
152:
153: hr_utility_trace ('Entering '||l_proc_name);
154: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| p_payroll_action_id);
155:
156: get_pact_info (p_payroll_action_id,
157: g_gre_id,
158: g_start_date,

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

183: AND ppa_sua.report_category = ''RT''
184: AND ppa_sua.action_status = ''C''
185: AND :p_payroll_action_id > 0';
186:
187: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
188: hr_utility_trace ('Leaving '||l_proc_name);
189:
190: END RANGE_CURSOR;
191:

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

184: AND ppa_sua.action_status = ''C''
185: AND :p_payroll_action_id > 0';
186:
187: hr_utility_trace ('Range cursor query : ' || p_sqlstr);
188: hr_utility_trace ('Leaving '||l_proc_name);
189:
190: END RANGE_CURSOR;
191:
192:

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

301: lv_primary_flag per_assignments_f.primary_flag%type;
302:
303: BEGIN
304: l_proc_name := g_proc_name || 'ACTION_CREATION';
305: hr_utility_trace ('Entering '||l_proc_name);
306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);

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

302:
303: BEGIN
304: l_proc_name := g_proc_name || 'ACTION_CREATION';
305: hr_utility_trace ('Entering '||l_proc_name);
306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
310: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);

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

303: BEGIN
304: l_proc_name := g_proc_name || 'ACTION_CREATION';
305: hr_utility_trace ('Entering '||l_proc_name);
306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
310: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
311:

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

304: l_proc_name := g_proc_name || 'ACTION_CREATION';
305: hr_utility_trace ('Entering '||l_proc_name);
306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
310: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
311:
312: ln_prev_person_id := -1;

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

305: hr_utility_trace ('Entering '||l_proc_name);
306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
310: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
311:
312: ln_prev_person_id := -1;
313:

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

306: hr_utility_trace ('Parameters ....');
307: hr_utility_trace ('P_PAYROLL_ACTION_ID = '|| P_PAYROLL_ACTION_ID);
308: hr_utility_trace ('P_START_PERSON_ID = '|| P_START_PERSON_ID);
309: hr_utility_trace ('P_END_PERSON_ID = '|| P_END_PERSON_ID);
310: hr_utility_trace ('P_CHUNK = '|| P_CHUNK);
311:
312: ln_prev_person_id := -1;
313:
314: IF g_gre_id IS NULL THEN

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

324: ,p_report_qualifier => 'MX_ANN_WRI'
325: ,p_report_category => 'RT');
326:
327: IF lb_range_person_on THEN
328: hr_utility_trace ('Person ranges are ON');
329: OPEN c_sua_asg_act_range;
330: ELSE
331: hr_utility_trace ('Person ranges are OFF');
332: OPEN c_sua_asg_act;

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

327: IF lb_range_person_on THEN
328: hr_utility_trace ('Person ranges are ON');
329: OPEN c_sua_asg_act_range;
330: ELSE
331: hr_utility_trace ('Person ranges are OFF');
332: OPEN c_sua_asg_act;
333: END IF;
334:
335: LOOP

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

348: ld_asg_end_date;
349: EXIT WHEN c_sua_asg_act%NOTFOUND;
350: END IF;
351:
352: hr_utility_trace ('-------------');
353: hr_utility_trace('Current person = '||ln_person_id);
354: hr_utility_trace('Previous person = '||ln_prev_person_id);
355:
356: IF (ln_person_id <> ln_prev_person_id) THEN

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

349: EXIT WHEN c_sua_asg_act%NOTFOUND;
350: END IF;
351:
352: hr_utility_trace ('-------------');
353: hr_utility_trace('Current person = '||ln_person_id);
354: hr_utility_trace('Previous person = '||ln_prev_person_id);
355:
356: IF (ln_person_id <> ln_prev_person_id) THEN
357: SELECT pay_assignment_actions_s.nextval

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

350: END IF;
351:
352: hr_utility_trace ('-------------');
353: hr_utility_trace('Current person = '||ln_person_id);
354: hr_utility_trace('Previous person = '||ln_prev_person_id);
355:
356: IF (ln_person_id <> ln_prev_person_id) THEN
357: SELECT pay_assignment_actions_s.nextval
358: INTO ln_wri_asg_act

Line 361: hr_utility_trace('Creating WRI assignment action '||

357: SELECT pay_assignment_actions_s.nextval
358: INTO ln_wri_asg_act
359: FROM dual;
360:
361: hr_utility_trace('Creating WRI assignment action '||
362: ln_wri_asg_act);
363: hr_nonrun_asact.insact(ln_wri_asg_act,
364: ln_asg_id,
365: p_payroll_action_id,

Line 373: hr_utility_trace('WRI assignment action not created');

369: 'U',
370: null);
371: ln_prev_person_id := ln_person_id;
372: ELSE
373: hr_utility_trace('WRI assignment action not created');
374: END IF;
375:
376: hr_nonrun_asact.insint (ln_wri_asg_act,
377: ln_sua_asg_act);

Line 378: hr_utility_trace('SUA asg action '||ln_sua_asg_act||

374: END IF;
375:
376: hr_nonrun_asact.insint (ln_wri_asg_act,
377: ln_sua_asg_act);
378: hr_utility_trace('SUA asg action '||ln_sua_asg_act||
379: ' locked by WRI asg action '||ln_wri_asg_act);
380: END LOOP;
381:
382: IF lb_range_person_on THEN

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

384: ELSE
385: CLOSE c_sua_asg_act;
386: END IF;
387:
388: hr_utility_trace ('Leaving '||l_proc_name);
389: END ACTION_CREATION;
390:
391:
392: /****************************************************************************

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

399: ) AS
400: l_proc_name VARCHAR2(100);
401: BEGIN
402: l_proc_name := g_proc_name || 'INIT';
403: hr_utility_trace ('Entering '||l_proc_name);
404:
405: get_pact_info (p_payroll_action_id,
406: g_gre_id,
407: g_start_date,

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

406: g_gre_id,
407: g_start_date,
408: g_end_date);
409:
410: hr_utility_trace ('Leaving '||l_proc_name);
411: END INIT;
412:
413:
414: /****************************************************************************

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

502: lt_act_info_id_exc pay_payroll_xml_extract_pkg.int_tab_type;
503:
504: BEGIN
505: l_proc_name := g_proc_name || 'GENERATE_XML';
506: hr_utility_trace ('Entering '||l_proc_name);
507:
508: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
509: ('TRANSFER_ACT_ID');
510:

Line 511: hr_utility_trace ('Processing WRI asg action '|| ln_assignment_action_id);

507:
508: ln_assignment_action_id := pay_magtape_generic.get_parameter_value
509: ('TRANSFER_ACT_ID');
510:
511: hr_utility_trace ('Processing WRI asg action '|| ln_assignment_action_id);
512:
513: OPEN csr_transactions (ln_assignment_action_id);
514: LOOP
515: FETCH csr_transactions INTO ln_act_info_id,

Line 531: hr_utility_trace ('WRI asg action '|| ln_assignment_action_id ||

527: OPEN csr_person (ln_assignment_action_id);
528: FETCH csr_person INTO ln_person_id;
529: CLOSE csr_person;
530:
531: hr_utility_trace ('WRI asg action '|| ln_assignment_action_id ||
532: ' belongs to person '||ln_person_id);
533:
534: OPEN csr_person_info (ln_person_id);
535: FETCH csr_person_info INTO lt_act_info_id(lt_act_info_id.count());

Line 540: hr_utility_trace ('No data to write to BLOB.');

536: CLOSE csr_person_info;
537:
538: IF lt_act_info_id.count() = 0 AND
539: lt_act_info_id_exc.count() = 0 THEN
540: hr_utility_trace ('No data to write to BLOB.');
541: ELSE
542: pay_payroll_xml_extract_pkg.generate(lt_act_info_id,
543: NULL,
544: g_document_type,

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

553: END IF;
554:
555: print_blob (pay_mag_tape.g_blob_value);
556:
557: hr_utility_trace ('Leaving '||l_proc_name);
558: EXCEPTION
559: WHEN OTHERS THEN
560: hr_utility_trace (SQLERRM);
561: RAISE;

Line 560: hr_utility_trace (SQLERRM);

556:
557: hr_utility_trace ('Leaving '||l_proc_name);
558: EXCEPTION
559: WHEN OTHERS THEN
560: hr_utility_trace (SQLERRM);
561: RAISE;
562: END GENERATE_XML;
563:
564:

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

570: l_proc_name varchar2(100);
571: lv_buf varchar2(2000);
572: BEGIN
573: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
574: hr_utility_trace ('Entering '||l_proc_name);
575:
576: hr_utility_trace ('Root XML tag = '||
577: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
578:

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

572: BEGIN
573: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
574: hr_utility_trace ('Entering '||l_proc_name);
575:
576: hr_utility_trace ('Root XML tag = '||
577: pay_magtape_generic.get_parameter_value('ROOT_XML_TAG'));
578:
579: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
580:

Line 583: hr_utility_trace ('BLOB contents after appending header information');

579: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
580:
581: write_to_magtape_lob (lv_buf);
582:
583: hr_utility_trace ('BLOB contents after appending header information');
584: print_blob (pay_mag_tape.g_blob_value);
585:
586: hr_utility_trace ('Leaving '||l_proc_name);
587: END GEN_XML_HEADER;

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

582:
583: hr_utility_trace ('BLOB contents after appending header information');
584: print_blob (pay_mag_tape.g_blob_value);
585:
586: hr_utility_trace ('Leaving '||l_proc_name);
587: END GEN_XML_HEADER;
588:
589:
590: /****************************************************************************

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

642: l_xml BLOB;
643: lt_act_info_id pay_payroll_xml_extract_pkg.int_tab_type;
644: BEGIN
645: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
646: hr_utility_trace ('Entering '||l_proc_name);
647:
648: OPEN csr_employer;
649: FETCH csr_employer INTO lt_act_info_id(lt_act_info_id.count());
650: CLOSE csr_employer;

Line 688: hr_utility_trace ('BLOB contents after appending footer information');

684: 2);
685:
686: write_to_magtape_lob (lv_buf);
687:
688: hr_utility_trace ('BLOB contents after appending footer information');
689: print_blob (pay_mag_tape.g_blob_value);
690:
691: hr_utility_trace ('Leaving '||l_proc_name);
692: END GEN_XML_FOOTER;

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

687:
688: hr_utility_trace ('BLOB contents after appending footer information');
689: print_blob (pay_mag_tape.g_blob_value);
690:
691: hr_utility_trace ('Leaving '||l_proc_name);
692: END GEN_XML_FOOTER;
693:
694: BEGIN
695: --hr_utility.trace_on(null, 'MX_IDC');

Line 695: --hr_utility.trace_on(null, 'MX_IDC');

691: hr_utility_trace ('Leaving '||l_proc_name);
692: END GEN_XML_FOOTER;
693:
694: BEGIN
695: --hr_utility.trace_on(null, 'MX_IDC');
696: g_proc_name := 'PAY_MX_ANNUAL_WRI.';
697: g_debug := hr_utility.debug_enabled;
698: g_document_type := 'MX_ANN_WRI';
699: END PAY_MX_ANNUAL_WRI;

Line 697: g_debug := hr_utility.debug_enabled;

693:
694: BEGIN
695: --hr_utility.trace_on(null, 'MX_IDC');
696: g_proc_name := 'PAY_MX_ANNUAL_WRI.';
697: g_debug := hr_utility.debug_enabled;
698: g_document_type := 'MX_ANN_WRI';
699: END PAY_MX_ANNUAL_WRI;