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

Line 81: Name : HR_UTILITY_TRACE

77: WHERE business_group_id = p_business_group_id;
78:
79:
80: /****************************************************************************
81: Name : HR_UTILITY_TRACE
82: Description : This procedure prints debug messages.
83: *****************************************************************************/
84: PROCEDURE HR_UTILITY_TRACE
85: (

Line 84: PROCEDURE HR_UTILITY_TRACE

80: /****************************************************************************
81: Name : HR_UTILITY_TRACE
82: Description : This procedure prints debug messages.
83: *****************************************************************************/
84: PROCEDURE HR_UTILITY_TRACE
85: (
86: P_TRC_DATA varchar2
87: ) AS
88: BEGIN

Line 90: hr_utility.trace(p_trc_data);

86: P_TRC_DATA varchar2
87: ) AS
88: BEGIN
89: IF g_debug THEN
90: hr_utility.trace(p_trc_data);
91: END IF;
92: END HR_UTILITY_TRACE;
93:
94: /****************************************************************************

Line 92: END HR_UTILITY_TRACE;

88: BEGIN
89: IF g_debug THEN
90: hr_utility.trace(p_trc_data);
91: END IF;
92: END HR_UTILITY_TRACE;
93:
94: /****************************************************************************
95: Name : PRINT_BLOB
96: Description : This procedure prints contents of BLOB passed as parameter.

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

223:
224:
225: BEGIN
226: l_proc_name := g_proc_name || 'GENERATE_XML';
227: hr_utility_trace ('Entering '||l_proc_name);
228:
229: ln_chars := 2000;
230: ln_offset := 1;
231:

Line 384: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

380: dbms_lob.writeAppend(l_xml,
381: ln_amt,
382: lr_xml);
383:
384: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
385: END LOOP;
386: pay_payroll_xml_extract_pkg.g_xml_table.delete();
387:
388: END IF;

Line 393: hr_utility_trace ('BLOB contents for assignment action '||

389:
390: write_to_magtape_lob (l_xml);
391: dbms_lob.freeTemporary(l_xml);
392:
393: hr_utility_trace ('BLOB contents for assignment action '||
394: ln_assignment_action_id);
395: print_blob (pay_mag_tape.g_blob_value);
396:
397: hr_utility_trace ('Leaving '||l_proc_name);

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

393: hr_utility_trace ('BLOB contents for assignment action '||
394: ln_assignment_action_id);
395: print_blob (pay_mag_tape.g_blob_value);
396:
397: hr_utility_trace ('Leaving '||l_proc_name);
398: END GENERATE_XML;
399:
400:
401: /****************************************************************************

Line 411: --hr_utility.trace_on(null,'dd');

407: l_proc_name varchar2(100);
408: lv_buf varchar2(2000);
409: BEGIN
410: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
411: --hr_utility.trace_on(null,'dd');
412: hr_utility_trace ('Entering '||l_proc_name);
413:
414: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
415:

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

408: lv_buf varchar2(2000);
409: BEGIN
410: l_proc_name := g_proc_name || 'GEN_XML_HEADER';
411: --hr_utility.trace_on(null,'dd');
412: hr_utility_trace ('Entering '||l_proc_name);
413:
414: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
415:
416: hr_utility_trace ('Header = '||lv_buf);

Line 416: hr_utility_trace ('Header = '||lv_buf);

412: hr_utility_trace ('Entering '||l_proc_name);
413:
414: lv_buf := pay_magtape_generic.get_parameter_value('ROOT_XML_TAG');
415:
416: hr_utility_trace ('Header = '||lv_buf);
417:
418: write_to_magtape_lob (lv_buf);
419:
420: hr_utility_trace ('BLOB contents after appending header information');

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

416: hr_utility_trace ('Header = '||lv_buf);
417:
418: write_to_magtape_lob (lv_buf);
419:
420: hr_utility_trace ('BLOB contents after appending header information');
421: print_blob (pay_mag_tape.g_blob_value);
422:
423: hr_utility_trace ('Leaving '||l_proc_name);
424: END GET_HEADERS;

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

419:
420: hr_utility_trace ('BLOB contents after appending header information');
421: print_blob (pay_mag_tape.g_blob_value);
422:
423: hr_utility_trace ('Leaving '||l_proc_name);
424: END GET_HEADERS;
425:
426:
427:

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

477:
478:
479: BEGIN
480: l_proc_name := g_proc_name || 'GEN_EMPLOYER_LEVEL_XML';
481: hr_utility_trace ('Entering '||l_proc_name);
482: lv_pmeth_cat := NULL;
483:
484: ln_org_pay_method :=
485: pay_magtape_generic.get_parameter_value('TRANSFER_ORG_PAY_METHOD');

Line 500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);

496:
497: ln_business_group_id :=
498: pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID');
499:
500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);
501: hr_utility_trace ('ld_effective_date '||ld_effective_date);
502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);
503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);

Line 501: hr_utility_trace ('ld_effective_date '||ld_effective_date);

497: ln_business_group_id :=
498: pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID');
499:
500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);
501: hr_utility_trace ('ld_effective_date '||ld_effective_date);
502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);
503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);
505:

Line 502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);

498: pay_magtape_generic.get_parameter_value('TRANSFER_BUSINESS_GROUP_ID');
499:
500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);
501: hr_utility_trace ('ld_effective_date '||ld_effective_date);
502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);
503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);
505:
506:

Line 503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);

499:
500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);
501: hr_utility_trace ('ld_effective_date '||ld_effective_date);
502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);
503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);
505:
506:
507: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_HEADER','');

Line 504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);

500: hr_utility_trace ('ln_org_pay_method '||ln_org_pay_method);
501: hr_utility_trace ('ld_effective_date '||ld_effective_date);
502: hr_utility_trace ('Direct Deposit Date '||lv_dd_date);
503: hr_utility_trace ('ln_payroll_action_id '||ln_payroll_action_id);
504: hr_utility_trace ('ln_business_group_id '||ln_business_group_id);
505:
506:
507: pay_payroll_xml_extract_pkg.load_xml('CS','DEPOSIT_HEADER','');
508: /*Clear the details of previous assignmentId */

Line 520: hr_utility_trace ('Legislation Code '||lv_leg_code);

516:
517: IF pay_payroll_xml_extract_pkg.g_leg_code IS NULL THEN
518: OPEN c_get_leg_code(ln_business_group_id);
519: FETCH c_get_leg_code INTO lv_leg_code;
520: hr_utility_trace ('Legislation Code '||lv_leg_code);
521:
522: pay_payroll_xml_extract_pkg.g_leg_code :=lv_leg_code;
523: CLOSE c_get_leg_code;
524: END IF;

Line 526: hr_utility_trace ('Legislation Code '||pay_payroll_xml_extract_pkg.g_leg_code);

522: pay_payroll_xml_extract_pkg.g_leg_code :=lv_leg_code;
523: CLOSE c_get_leg_code;
524: END IF;
525:
526: hr_utility_trace ('Legislation Code '||pay_payroll_xml_extract_pkg.g_leg_code);
527:
528: OPEN get_org_bank_details(ln_org_pay_method,ld_effective_date);
529: FETCH get_org_bank_details INTO
530: g_org_flex(1),g_org_flex(2),g_org_flex(3),

Line 580: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));

576: dbms_lob.writeAppend(l_xml,
577: ln_amt,
578: lr_xml);
579:
580: hr_utility_trace (pay_payroll_xml_extract_pkg.g_xml_table(cntr));
581: END LOOP;
582: pay_payroll_xml_extract_pkg.g_xml_table.delete();
583:
584: END IF;

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

604: END IF;
605:
606:
607:
608: hr_utility_trace ('BLOB contents after appending header information');
609: print_blob (pay_mag_tape.g_blob_value);
610:
611: hr_utility_trace ('Leaving '||l_proc_name);
612: END get_deposit_header;

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

607:
608: hr_utility_trace ('BLOB contents after appending header information');
609: print_blob (pay_mag_tape.g_blob_value);
610:
611: hr_utility_trace ('Leaving '||l_proc_name);
612: END get_deposit_header;
613:
614: /****************************************************************************
615: Name : GEN_XML_FOOTER

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

621: lv_buf varchar2(2000);
622: l_proc_name varchar2(200);
623: BEGIN
624: l_proc_name := g_proc_name || 'GET_EMPLOYER_FOOTER';
625: hr_utility_trace ('Entering '||l_proc_name);
626:
627: lv_buf := '';
628:
629: write_to_magtape_lob (lv_buf);

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

627: lv_buf := '';
628:
629: write_to_magtape_lob (lv_buf);
630:
631: hr_utility_trace ('BLOB contents after appending footer information');
632: print_blob (pay_mag_tape.g_blob_value);
633:
634: hr_utility_trace ('Leaving '||l_proc_name);
635: END get_deposit_footer;

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

630:
631: hr_utility_trace ('BLOB contents after appending footer information');
632: print_blob (pay_mag_tape.g_blob_value);
633:
634: hr_utility_trace ('Leaving '||l_proc_name);
635: END get_deposit_footer;
636:
637: PROCEDURE GET_FOOTERS AS
638: lv_buf varchar2(2000);

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

638: lv_buf varchar2(2000);
639: l_proc_name varchar2(200);
640: BEGIN
641: l_proc_name := g_proc_name || 'GEN_XML_FOOTER';
642: hr_utility_trace ('Entering '||l_proc_name);
643:
644: lv_buf := '' ;
645:
646: write_to_magtape_lob (lv_buf);

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

644: lv_buf := '' ;
645:
646: write_to_magtape_lob (lv_buf);
647:
648: hr_utility_trace ('BLOB contents after appending footer information');
649: print_blob (pay_mag_tape.g_blob_value);
650:
651: hr_utility_trace ('Leaving '||l_proc_name);
652: END GET_FOOTERS;

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

647:
648: hr_utility_trace ('BLOB contents after appending footer information');
649: print_blob (pay_mag_tape.g_blob_value);
650:
651: hr_utility_trace ('Leaving '||l_proc_name);
652: END GET_FOOTERS;
653:
654: BEGIN
655: g_proc_name := 'pay_direct_deposit_xml.';

Line 656: g_debug := hr_utility.debug_enabled;

652: END GET_FOOTERS;
653:
654: BEGIN
655: g_proc_name := 'pay_direct_deposit_xml.';
656: g_debug := hr_utility.debug_enabled;
657: END pay_direct_deposit_xml;