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

Line 49: hr_utility.trace

45: 29/07/97 mfender 110.2 Corected untranslatable date formats
46: 08-APR-99 DJOSHI Verfied and converted for Canonical
47: Complience of Date
48: 18-jun-1999 achauhan 115.2 replaced dbms_output with
49: hr_utility.trace
50: 17-aug-1999 rthakur 115.3 Added function get_parameter.
51: 07-jan-2000 vmehta 115.4 Modified function get_parameter
52: to take care of the condition
53: where the second parameter is

Line 213: hr_utility.set_location('pay_mag_utils.lookup_formula',1);

209: BEGIN
210: --
211: OPEN csr_formula;
212: --
213: hr_utility.set_location('pay_mag_utils.lookup_formula',1);
214: --
215: FETCH csr_formula INTO l_formula_id;
216: --
217: hr_utility.set_location('pay_mag_utils.lookup_formula',2);

Line 217: hr_utility.set_location('pay_mag_utils.lookup_formula',2);

213: hr_utility.set_location('pay_mag_utils.lookup_formula',1);
214: --
215: FETCH csr_formula INTO l_formula_id;
216: --
217: hr_utility.set_location('pay_mag_utils.lookup_formula',2);
218: --
219: -- If formula not found, then raise exception in calling package.
220: --
221: IF csr_formula%NOTFOUND THEN

Line 225: hr_utility.set_message(801,'PAY_50030_1099R_NO_FF');

221: IF csr_formula%NOTFOUND THEN
222: --
223: CLOSE csr_formula;
224: --
225: hr_utility.set_message(801,'PAY_50030_1099R_NO_FF');
226: RAISE hr_utility.hr_error;
227: --
228: ELSE
229: --

Line 226: RAISE hr_utility.hr_error;

222: --
223: CLOSE csr_formula;
224: --
225: hr_utility.set_message(801,'PAY_50030_1099R_NO_FF');
226: RAISE hr_utility.hr_error;
227: --
228: ELSE
229: --
230: CLOSE csr_formula;

Line 265: hr_utility.set_location('pay_mag_utils.lookup_format',1);

261: l_format varchar2(30);
262: --
263: BEGIN
264: --
265: hr_utility.set_location('pay_mag_utils.lookup_format',1);
266: --
267: -- In the case of a yearly report, period end will be the same as year end.
268: --
269: OPEN csr_format;

Line 275: hr_utility.set_message(801,'PAY_50031_1099R_REP_FMT');

271: --
272: IF csr_format%NOTFOUND THEN
273: --
274: CLOSE csr_format;
275: hr_utility.set_message(801,'PAY_50031_1099R_REP_FMT');
276: RAISE hr_utility.hr_error;
277: --
278: ELSE
279: --

Line 276: RAISE hr_utility.hr_error;

272: IF csr_format%NOTFOUND THEN
273: --
274: CLOSE csr_format;
275: hr_utility.set_message(801,'PAY_50031_1099R_REP_FMT');
276: RAISE hr_utility.hr_error;
277: --
278: ELSE
279: --
280: CLOSE csr_format;

Line 325: hr_utility.set_message(801,'PAY_50032_1099R_BAL_DB');

321: --
322: IF csr_defined_balance%notfound THEN
323: --
324: CLOSE csr_defined_balance;
325: hr_utility.set_message(801,'PAY_50032_1099R_BAL_DB');
326: RAISE hr_utility.hr_error;
327: --
328: ELSE
329: CLOSE csr_defined_balance;

Line 326: RAISE hr_utility.hr_error;

322: IF csr_defined_balance%notfound THEN
323: --
324: CLOSE csr_defined_balance;
325: hr_utility.set_message(801,'PAY_50032_1099R_BAL_DB');
326: RAISE hr_utility.hr_error;
327: --
328: ELSE
329: CLOSE csr_defined_balance;
330: END IF;

Line 368: hr_utility.set_message(801,'PAY_50033_1099R_JU_CODE');

364: --
365: IF csr_jurisdiction_code%NOTFOUND THEN
366: --
367: CLOSE csr_jurisdiction_code;
368: hr_utility.set_message(801,'PAY_50033_1099R_JU_CODE');
369: RAISE hr_utility.hr_error;
370: ELSE
371: --
372: CLOSE csr_jurisdiction_code;

Line 369: RAISE hr_utility.hr_error;

365: IF csr_jurisdiction_code%NOTFOUND THEN
366: --
367: CLOSE csr_jurisdiction_code;
368: hr_utility.set_message(801,'PAY_50033_1099R_JU_CODE');
369: RAISE hr_utility.hr_error;
370: ELSE
371: --
372: CLOSE csr_jurisdiction_code;
373: --

Line 417: hr_utility.set_location('pay_mag_utils.check_report_unique',1);

413: l_payroll_action_id NUMBER;
414: --
415: BEGIN
416: --
417: hr_utility.set_location('pay_mag_utils.check_report_unique',1);
418: --
419: OPEN csr_payroll_action;
420: --
421: FETCH csr_payroll_action INTO l_payroll_action_id;

Line 426: hr_utility.set_message(801,'PAY_50034_1099R_REP_RUN');

422: --
423: IF csr_payroll_action%found THEN
424: --
425: CLOSE csr_payroll_action;
426: hr_utility.set_message(801,'PAY_50034_1099R_REP_RUN');
427: RAISE hr_utility.hr_error;
428: --
429: ELSE
430: CLOSE csr_payroll_action;

Line 427: RAISE hr_utility.hr_error;

423: IF csr_payroll_action%found THEN
424: --
425: CLOSE csr_payroll_action;
426: hr_utility.set_message(801,'PAY_50034_1099R_REP_RUN');
427: RAISE hr_utility.hr_error;
428: --
429: ELSE
430: CLOSE csr_payroll_action;
431: END IF;

Line 454: hr_utility.set_location('pay_mag_utils.error_payroll_action',1);

450: BEGIN
451: --
452: -- Set the payroll action status to Error if report has failed.
453: --
454: hr_utility.set_location('pay_mag_utils.error_payroll_action',1);
455: --
456: UPDATE pay_payroll_actions pa
457: SET pa.action_status = 'E'
458: WHERE pa.payroll_action_id = p_payroll_action_id;

Line 488: hr_utility.set_location('pay_mag_utils.update_action_status',1);

484: BEGIN
485: --
486: -- Sets the payroll action to a status of 'C'omplete.
487: --
488: hr_utility.set_location('pay_mag_utils.update_action_status',1);
489: --
490: UPDATE pay_payroll_actions pa
491: SET pa.action_status = 'C'
492: WHERE pa.payroll_action_id = p_payroll_action_id;

Line 496: hr_utility.set_location('pay_mag_utils.update_action_status',2);

492: WHERE pa.payroll_action_id = p_payroll_action_id;
493: --
494: -- Sets all successfully processed assignment actions to 'C'omplete.
495: --
496: hr_utility.set_location('pay_mag_utils.update_action_status',2);
497: --
498: UPDATE pay_assignment_actions aa
499: SET aa.action_status = 'C'
500: WHERE aa.payroll_action_id = p_payroll_action_id

Line 539: hr_utility.set_location('pay_mag_utils.create_payroll_action',1);

535: BEGIN
536: --
537: -- Get the next payroll_action_id value from the sequence.
538: --
539: hr_utility.set_location('pay_mag_utils.create_payroll_action',1);
540: --
541: select pay_payroll_actions_s.nextval
542: into l_payroll_action_id
543: from sys.dual;

Line 548: hr_utility.set_location('pay_mag_utils.create_payroll_action',2);

544: --
545: -- Create a payroll action dated as of the end of the period being reported
546: -- on. Populate the legislative parameter to identify the report being run.
547: --
548: hr_utility.set_location('pay_mag_utils.create_payroll_action',2);
549: --
550: if p_report_type = '1099R' then
551: l_legislative_parms := 'USMAGTAPE'|| '-' ||
552: lpad(p_report_type,5) || '-' ||

Line 584: hr_utility.set_location('pay_mag_utils.create_payroll_action',3);

580: p_period_end,
581: l_legislative_parms,
582: 1);
583: --
584: hr_utility.set_location('pay_mag_utils.create_payroll_action',3);
585: --
586: -- Return payroll action id of new row.
587: --
588: RETURN (l_payroll_action_id);

Line 627: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);

623: l_assignment_action_id pay_assignment_actions.assignment_action_id%type;
624: --
625: BEGIN
626: --
627: hr_utility.set_location('pay_mag_utils.create_assignment_action',1);
628: --
629: -- Create assignment action to identify a specific person's inclusion in the
630: -- magnetic tape report identified by the parent payroll action. The
631: -- assignment action has to be sequenced within the other assignment actions

Line 639: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);

635: hrassact.inassact(p_payroll_action_id, p_assignment_id);
636: --
637: -- Get the assignment_action_id of the newly created assignment action.
638: --
639: hr_utility.set_location('pay_mag_utils.create_assignment_action',2);
640: --
641: OPEN csr_assignment_action;
642: FETCH csr_assignment_action INTO l_assignment_action_id;
643: CLOSE csr_assignment_action;

Line 649: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);

645: UPDATE pay_assignment_actions aa
646: SET aa.tax_unit_id = p_tax_unit_id
647: WHERE aa.assignment_action_id = l_assignment_action_id;
648: --
649: hr_utility.set_location('pay_mag_utils.create_assignment_action',3);
650: --
651: -- Return id of new row.
652: --
653: RETURN (l_assignment_action_id);

Line 755: hr_utility.set_location('pay_mag_utils.get_dates',1);

751: -- p_year_start 01-JAN-1995
752: -- p_year_end 31-DEC-1995
753: -- p_reporting_year 1995
754: --
755: hr_utility.set_location('pay_mag_utils.get_dates',1);
756: --
757: IF p_report_type = '1099R' THEN
758: --
759: hr_utility.set_location('pay_mag_utils.get_dates',2);

Line 759: hr_utility.set_location('pay_mag_utils.get_dates',2);

755: hr_utility.set_location('pay_mag_utils.get_dates',1);
756: --
757: IF p_report_type = '1099R' THEN
758: --
759: hr_utility.set_location('pay_mag_utils.get_dates',2);
760: --
761: p_rep_year := p_year;
762: --
763: END IF;

Line 765: hr_utility.set_location('pay_mag_utils.get_dates',3);

761: p_rep_year := p_year;
762: --
763: END IF;
764: --
765: hr_utility.set_location('pay_mag_utils.get_dates',3);
766: --
767: p_year_start := to_date('01-01-'||p_rep_year, 'DD-MM-YYYY');
768: p_year_end := to_date('31-12-'||p_rep_year, 'DD-MM-YYYY');
769: --

Line 789: hr_utility.trace('****************************************************');

785: BEGIN
786: --
787: -- Put report title on screen
788: --
789: hr_utility.trace('****************************************************');
790: hr_utility.trace('Report Format '||p_report_format);
791: hr_utility.trace('****************************************************');
792: --
793: -- Put headings on screen

Line 790: hr_utility.trace('Report Format '||p_report_format);

786: --
787: -- Put report title on screen
788: --
789: hr_utility.trace('****************************************************');
790: hr_utility.trace('Report Format '||p_report_format);
791: hr_utility.trace('****************************************************');
792: --
793: -- Put headings on screen
794: --

Line 791: hr_utility.trace('****************************************************');

787: -- Put report title on screen
788: --
789: hr_utility.trace('****************************************************');
790: hr_utility.trace('Report Format '||p_report_format);
791: hr_utility.trace('****************************************************');
792: --
793: -- Put headings on screen
794: --
795:

Line 803: hr_utility.trace(l_string);

799: ' '||
800: 'Next Block'||
801: ' '||
802: 'Formula';
803: hr_utility.trace(l_string);
804: --
805: l_string := '----------'||
806: ' '||
807: '----'||

Line 812: hr_utility.trace(l_string);

808: ' '||
809: '----------'||
810: ' '||
811: '-------';
812: hr_utility.trace(l_string);
813: --
814: END Set_Titles;
815: --
816: /*^L*/

Line 845: hr_utility.trace('Inserting format for '||p_block_name);

841: -- we get a very tabular look to the output.
842: --
843: g_message := 'Inserting format for '||p_block_name;
844: --
845: hr_utility.trace('Inserting format for '||p_block_name);
846: --
847: l_formula := substr(p_formula,1,25);
848: l_string := concat(l_string,p_block_name);
849: l_string := concat(l_string,lpad(p_main_block,26-length(p_block_name),' '));

Line 854: hr_utility.trace(l_string);

850: l_string := concat(l_string,lpad(p_next_block,5-length(p_main_block)
851: +length(p_next_block),' '));
852: l_string := concat(l_string,lpad(l_formula,25-length(p_next_block)
853: +length(l_formula),' '));
854: hr_utility.trace(l_string);
855: --
856: END Format_Output;
857:
858: /*^L*/

Line 895: hr_utility.trace(ee.block_name);

891: FOR ee IN c_structure LOOP
892: --
893: EXIT WHEN c_structure%notfound;
894: --
895: hr_utility.trace(ee.block_name);
896: --
897: -- We have to ensure that the next_block_name does not have a null
898: -- value as otherwise our formatting which uses lengths of items to
899: -- ensure correct padding will not work correctly. To get around this

Line 1035: hr_utility.trace('Attempting to see if '||p_report_format||' exists');

1031: --
1032: -- This procedure checks if the format for the report we want to view
1033: -- actually exists.
1034: --
1035: hr_utility.trace('Attempting to see if '||p_report_format||' exists');
1036: --
1037: g_message := 'Attempting to see if '||p_report_format||' exists';
1038: --
1039: Report_Exists(p_report_format);

Line 1048: hr_utility.trace('Setting Titles');

1044: --
1045: -- This procedure displays titles and headings for the report for which we are
1046: -- displaying the format.
1047: --
1048: hr_utility.trace('Setting Titles');
1049: --
1050: g_message := 'Setting Titles';
1051: --
1052: Set_Titles(p_report_format);

Line 1066: hr_utility.trace('Attempting to get main block for '||p_report_format);

1062: -- 2) Pass this ID to Recurse_Block_Structure procedure
1063: -- 3) The procedure will then recursively go down its hierarchy and print
1064: -- out the report format.
1065: --
1066: hr_utility.trace('Attempting to get main block for '||p_report_format);
1067: --
1068: g_message := 'Attempting to get main block for '||p_report_format;
1069: --
1070: OPEN c_magnetic_block_id;

Line 1087: hr_utility.trace('Starting recursive call to produce format of '||p_report_format);

1083: END IF;
1084: --
1085: CLOSE c_magnetic_block_id;
1086: --
1087: hr_utility.trace('Starting recursive call to produce format of '||p_report_format);
1088: --
1089: g_message := 'Starting recursive call to produce format of '||p_report_format;
1090: --
1091: Recurse_Block_Structure(l_magnetic_block_id);

Line 1101: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));

1097: EXCEPTION
1098: --
1099: WHEN NO_DATA_FOUND THEN
1100: --
1101: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1102: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1103: --
1104: WHEN OTHERS THEN
1105: --

Line 1102: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));

1098: --
1099: WHEN NO_DATA_FOUND THEN
1100: --
1101: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1102: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1103: --
1104: WHEN OTHERS THEN
1105: --
1106: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));

Line 1106: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));

1102: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1103: --
1104: WHEN OTHERS THEN
1105: --
1106: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1107: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1108: --
1109: END Main;
1110: --

Line 1107: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));

1103: --
1104: WHEN OTHERS THEN
1105: --
1106: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1107: hr_utility.trace(g_message||' - ORA '||to_char(SQLCODE));
1108: --
1109: END Main;
1110: --
1111: ----------------------------------------------------------------------------------------