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

Line 150: hr_utility.set_location

146: AND UE.creator_type = 'B'
147: AND UE.legislation_code = 'US'; /* Bug:2296797 */
148: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
149: BEGIN
150: hr_utility.set_location
151: ('pay_us_mmref_reporting.bal_db_item - opening cursor', 10);
152: -- Open the cursor
153: OPEN csr_defined_balance;
154: -- Fetch the value

Line 159: hr_utility.set_location

155: FETCH csr_defined_balance
156: INTO l_defined_balance_id;
157: IF csr_defined_balance%NOTFOUND THEN
158: CLOSE csr_defined_balance;
159: hr_utility.set_location
160: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
161: hr_utility.raise_error;
162: ELSE
163: hr_utility.set_location

Line 161: hr_utility.raise_error;

157: IF csr_defined_balance%NOTFOUND THEN
158: CLOSE csr_defined_balance;
159: hr_utility.set_location
160: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
161: hr_utility.raise_error;
162: ELSE
163: hr_utility.set_location
164: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
165: CLOSE csr_defined_balance;

Line 163: hr_utility.set_location

159: hr_utility.set_location
160: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
161: hr_utility.raise_error;
162: ELSE
163: hr_utility.set_location
164: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
165: CLOSE csr_defined_balance;
166: END IF;
167: /* Return the value to the call */

Line 200: hr_utility.set_location

196: p_report_type IN OUT nocopy VARCHAR2,
197: p_business_group_id IN OUT nocopy NUMBER
198: ) IS
199: BEGIN
200: hr_utility.set_location
201: ('pay_us_mmref_reporting.get_report_parameters', 10);
202: SELECT ppa.start_date,
203: ppa.effective_date,
204: ppa.business_group_id,

Line 219: hr_utility.set_location

215: SELECT state_code
216: INTO p_state_code
217: FROM pay_us_states
218: WHERE state_abbrev = p_state_abbrev;
219: hr_utility.set_location
220: ('pay_us_mmref_reporting.get_report_parameters', 20);
221: ELSE
222: p_state_code := '';
223: hr_utility.set_location

Line 223: hr_utility.set_location

219: hr_utility.set_location
220: ('pay_us_mmref_reporting.get_report_parameters', 20);
221: ELSE
222: p_state_code := '';
223: hr_utility.set_location
224: ('pay_us_mmref_reporting.get_report_parameters', 30);
225: END IF;
226: IF p_state_abbrev = 'FED' AND p_report_type = 'W2' THEN
227: p_report_type := 'FEDW2';

Line 231: hr_utility.set_location

227: p_report_type := 'FEDW2';
228: ELSIF p_report_type = 'W2' THEN
229: p_report_type := 'STW2';
230: END IF;
231: hr_utility.set_location
232: ('pay_us_mmref_reporting.get_report_parameters', 40);
233: END get_report_parameters;
234: -------------------------------------------------------------------------
235: -- Name : get_balance_value

Line 259: hr_utility.set_location

255: p_effective_date DATE
256: ) RETURN NUMBER IS
257: l_jurisdiction_code VARCHAR2(20);
258: BEGIN
259: hr_utility.set_location
260: ('pay_us_mmref_reporting.get_balance_value', 10);
261: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
262: IF p_state_abbrev <> 'FED' THEN
263: SELECT jurisdiction_code

Line 267: hr_utility.set_location

263: SELECT jurisdiction_code
264: INTO l_jurisdiction_code
265: FROM pay_state_rules
266: WHERE state_code = p_state_abbrev;
267: hr_utility.set_location
268: ('pay_us_mmref_reporting.get_balance_value', 15);
269: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
270: END IF;
271: hr_utility.trace(p_balance_name);

Line 271: hr_utility.trace(p_balance_name);

267: hr_utility.set_location
268: ('pay_us_mmref_reporting.get_balance_value', 15);
269: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
270: END IF;
271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location

Line 272: hr_utility.trace('Context');

268: ('pay_us_mmref_reporting.get_balance_value', 15);
269: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
270: END IF;
271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location
276: ('pay_us_mmref_reporting.get_balance_value', 20);

Line 273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);

269: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
270: END IF;
271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location
276: ('pay_us_mmref_reporting.get_balance_value', 20);
277: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

Line 274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);

270: END IF;
271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location
276: ('pay_us_mmref_reporting.get_balance_value', 20);
277: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
278: p_assignment_id, p_effective_date);

Line 275: hr_utility.set_location

271: hr_utility.trace(p_balance_name);
272: hr_utility.trace('Context');
273: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
274: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
275: hr_utility.set_location
276: ('pay_us_mmref_reporting.get_balance_value', 20);
277: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
278: p_assignment_id, p_effective_date);
279: END get_balance_value;

Line 486: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');

482: FETCH c_tax_ein INTO l_ein;
483: IF c_tax_ein%NOTFOUND THEN
484: CLOSE c_tax_ein;
485: l_package_error_status := 'Y';
486: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
487: message_text := 'EIN ID missing ';
488: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
489: pay_core_utils.push_token('record_name',message_preprocess);
490: pay_core_utils.push_token('description',message_text);

Line 491: hr_utility.raise_error;

487: message_text := 'EIN ID missing ';
488: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
489: pay_core_utils.push_token('record_name',message_preprocess);
490: pay_core_utils.push_token('description',message_text);
491: hr_utility.raise_error;
492: ELSE
493: CLOSE c_tax_ein;
494: END IF;
495:

Line 504: hr_utility.trace('Database item for balacne missing ');

500: IF c_user_entity_id_of_bal%NOTFOUND THEN
501: CLOSE c_user_entity_id_of_bal;
502: l_package_error_status := 'Y';
503: /* message to user - Database item missing */
504: hr_utility.trace('Database item for balacne missing ');
505: message_text := '-Database item missing ';
506: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
507: pay_core_utils.push_token('record_name',message_preprocess);
508: pay_core_utils.push_token('description',message_text);

Line 509: hr_utility.raise_error;

505: message_text := '-Database item missing ';
506: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
507: pay_core_utils.push_token('record_name',message_preprocess);
508: pay_core_utils.push_token('description',message_text);
509: hr_utility.raise_error;
510: ELSE
511: CLOSE c_user_entity_id_of_bal;
512: END IF;
513:

Line 523: hr_utility.raise_error;

519: message_text := 'Context_id value for tax_unit_id missing';
520: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
521: pay_core_utils.push_token('record_name',message_preprocess);
522: pay_core_utils.push_token('description',message_text);
523: hr_utility.raise_error;
524: ELSE
525: CLOSE c_context_tax_unit_id;
526: END IF;
527:

Line 535: hr_utility.trace('Contxt_id value for jurisdction_id missing');

531: CLOSE c_context_jurisdiction;
532: /* message to User -- Unable to find to context_id for jurisdiction */
533:
534: message_text := 'Context_id value for jurisdiction missing';
535: hr_utility.trace('Contxt_id value for jurisdction_id missing');
536: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
537: pay_core_utils.push_token('record_name',message_preprocess);
538: pay_core_utils.push_token('description',message_text);
539: hr_utility.raise_error;

Line 539: hr_utility.raise_error;

535: hr_utility.trace('Contxt_id value for jurisdction_id missing');
536: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
537: pay_core_utils.push_token('record_name',message_preprocess);
538: pay_core_utils.push_token('description',message_text);
539: hr_utility.raise_error;
540: ELSE
541: CLOSE c_context_jurisdiction;
542: eND IF;
543: /* Get the Tranmitter id of the Current Mag. W2. and check if it has

Line 555: hr_utility.raise_error;

551: message_text := 'Transmitter Not denfined';
552: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
553: pay_core_utils.push_token('record_name',message_preprocess);
554: pay_core_utils.push_token('description',message_text);
555: hr_utility.raise_error;
556: ELSE
557: CLOSE c_transmitter;
558: END IF;
559:

Line 560: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));

556: ELSE
557: CLOSE c_transmitter;
558: END IF;
559:
560: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
561: hr_utility.trace('Start date ' || to_char(p_year_start));
562: hr_utility.trace('End date ' || to_char(p_year_end));
563: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
564:

Line 561: hr_utility.trace('Start date ' || to_char(p_year_start));

557: CLOSE c_transmitter;
558: END IF;
559:
560: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
561: hr_utility.trace('Start date ' || to_char(p_year_start));
562: hr_utility.trace('End date ' || to_char(p_year_end));
563: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
564:
565:

Line 562: hr_utility.trace('End date ' || to_char(p_year_end));

558: END IF;
559:
560: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
561: hr_utility.trace('Start date ' || to_char(p_year_start));
562: hr_utility.trace('End date ' || to_char(p_year_end));
563: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
564:
565:
566: /* Check if Archiver has been run for Transmitter */

Line 563: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));

559:
560: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
561: hr_utility.trace('Start date ' || to_char(p_year_start));
562: hr_utility.trace('End date ' || to_char(p_year_end));
563: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
564:
565:
566: /* Check if Archiver has been run for Transmitter */
567: OPEN c_gre_payroll_action (l_transmitter);

Line 571: hr_utility.trace('Transmitter not Archvied ');

567: OPEN c_gre_payroll_action (l_transmitter);
568: FETCH c_gre_payroll_action INTO l_payroll_action_id;
569:
570: IF c_gre_payroll_action%NOTFOUND THEN
571: hr_utility.trace('Transmitter not Archvied ');
572: CLOSE c_gre_payroll_action;
573: /* message to user -- Transmitter has not been archived */
574: message_text := 'Transmitter not Archived';
575: hr_utility.trace('Transmitter has not been archived');

Line 575: hr_utility.trace('Transmitter has not been archived');

571: hr_utility.trace('Transmitter not Archvied ');
572: CLOSE c_gre_payroll_action;
573: /* message to user -- Transmitter has not been archived */
574: message_text := 'Transmitter not Archived';
575: hr_utility.trace('Transmitter has not been archived');
576: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
577: pay_core_utils.push_token('record_name',message_preprocess);
578: pay_core_utils.push_token('description',message_text);
579: -- hr_utility.raise_error;

Line 579: -- hr_utility.raise_error;

575: hr_utility.trace('Transmitter has not been archived');
576: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
577: pay_core_utils.push_token('record_name',message_preprocess);
578: pay_core_utils.push_token('description',message_text);
579: -- hr_utility.raise_error;
580: END IF;
581: CLOSE c_gre_payroll_action;
582:
583: /* end of Transmitter Checking */

Line 585: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 10);

581: CLOSE c_gre_payroll_action;
582:
583: /* end of Transmitter Checking */
584:
585: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 10);
586:
587: FOR gre_rec IN c_get_gre LOOP
588: /* set l_gre to gre Fethched */
589:

Line 616: -- hr_utility.raise_error;

612: --Some of the assignments have Errored
613: l_package_error_status := 'Y';
614: /* message to user -- assignment has errored out */
615: --
616: -- hr_utility.raise_error;
617: END IF;
618: CLOSE c_arch_errored_asg;
619:
620: /* Checking for Retry */

Line 631: -- hr_utility.raise_error;

627: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
628: pay_core_utils.push_token('record_name',message_preprocess);
629: pay_core_utils.push_token('description',message_text);
630: l_package_error_status := 'Y';
631: -- hr_utility.raise_error;
632:
633: END IF;
634:
635: CLOSE c_arch_retry_pending;

Line 637: hr_utility.trace('GRE:' || TO_CHAR(l_gre));

633: END IF;
634:
635: CLOSE c_arch_retry_pending;
636:
637: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
638: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
639: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
640:
641: l_no_of_gres_picked := l_no_of_gres_picked + 1;

Line 638: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));

634:
635: CLOSE c_arch_retry_pending;
636:
637: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
638: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
639: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
640:
641: l_no_of_gres_picked := l_no_of_gres_picked + 1;
642: /* All the condition have been met so it is safe to make Arhive

Line 639: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));

635: CLOSE c_arch_retry_pending;
636:
637: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
638: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
639: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
640:
641: l_no_of_gres_picked := l_no_of_gres_picked + 1;
642: /* All the condition have been met so it is safe to make Arhive
643: Call

Line 649: hr_utility.trace('Federal smart archive call');

645:
646: IF p_report_type = 'FEDW2' THEN --federal W2
647: archive_eoy_data(l_payroll_action_id,l_gre);
648: ELSE
649: hr_utility.trace('Federal smart archive call');
650: archive_eoy_data(l_payroll_action_id,l_gre);
651: hr_utility.trace('State Code :- ' || p_state_code);
652: hr_utility.trace('GRE - ' || to_char(l_gre));
653: hr_utility.trace('Before calling Smart State Archive');

Line 651: hr_utility.trace('State Code :- ' || p_state_code);

647: archive_eoy_data(l_payroll_action_id,l_gre);
648: ELSE
649: hr_utility.trace('Federal smart archive call');
650: archive_eoy_data(l_payroll_action_id,l_gre);
651: hr_utility.trace('State Code :- ' || p_state_code);
652: hr_utility.trace('GRE - ' || to_char(l_gre));
653: hr_utility.trace('Before calling Smart State Archive');
654: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
655: hr_utility.trace('After call to state Archive');

Line 652: hr_utility.trace('GRE - ' || to_char(l_gre));

648: ELSE
649: hr_utility.trace('Federal smart archive call');
650: archive_eoy_data(l_payroll_action_id,l_gre);
651: hr_utility.trace('State Code :- ' || p_state_code);
652: hr_utility.trace('GRE - ' || to_char(l_gre));
653: hr_utility.trace('Before calling Smart State Archive');
654: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
655: hr_utility.trace('After call to state Archive');
656: END IF;

Line 653: hr_utility.trace('Before calling Smart State Archive');

649: hr_utility.trace('Federal smart archive call');
650: archive_eoy_data(l_payroll_action_id,l_gre);
651: hr_utility.trace('State Code :- ' || p_state_code);
652: hr_utility.trace('GRE - ' || to_char(l_gre));
653: hr_utility.trace('Before calling Smart State Archive');
654: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
655: hr_utility.trace('After call to state Archive');
656: END IF;
657:

Line 655: hr_utility.trace('After call to state Archive');

651: hr_utility.trace('State Code :- ' || p_state_code);
652: hr_utility.trace('GRE - ' || to_char(l_gre));
653: hr_utility.trace('Before calling Smart State Archive');
654: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
655: hr_utility.trace('After call to state Archive');
656: END IF;
657:
658: hr_utility.trace('After Call to smart Archive ');
659:

Line 658: hr_utility.trace('After Call to smart Archive ');

654: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
655: hr_utility.trace('After call to state Archive');
656: END IF;
657:
658: hr_utility.trace('After Call to smart Archive ');
659:
660: /* Check EIN for the Employee */
661:
662: IF p_report_type = 'FEDW2' THEN --federal W2

Line 679: -- hr_utility.trace('State Tax Rules not Found ');

675: /* Check for State */
676: -- OPEN c_chk_archive_state_code (l_gre,l_payroll_action_id);
677: -- FETCH c_chk_archive_state_code INTO l_state_tax_rules_exist;
678: -- IF c_chk_archive_state_code%NOTFOUND THEN
679: -- hr_utility.trace('State Tax Rules not Found ');
680: -- /* state Tax Rules have not been Defined */
681: -- message_text := 'State Tax Rules not Defind for GRE '
682: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
683: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 693: hr_utility.trace('Check the State ER data ');

689: -- close c_chk_archive_state_code;
690:
691: /* Do check_er_data only if Record exist */
692: /* Add those checks for current Year */
693: hr_utility.trace('Check the State ER data ');
694: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
695: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
696: /* EIN check Failed */
697: -- IF l_ein_result = 'N'THEN

Line 695: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );

691: /* Do check_er_data only if Record exist */
692: /* Add those checks for current Year */
693: hr_utility.trace('Check the State ER data ');
694: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
695: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
696: /* EIN check Failed */
697: -- IF l_ein_result = 'N'THEN
698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
699: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);

Line 698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));

694: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
695: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
696: /* EIN check Failed */
697: -- IF l_ein_result = 'N'THEN
698: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
699: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
700: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
701: -- pay_core_utils.push_token('record_name',message_preprocess);
702: -- pay_core_utils.push_token('description',message_text);

Line 722: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 99);

718:
719: /* Code commented to fix Bug # 3069840
720:
721: IF p_report_type = 'FEDW2' THEN --federal W2
722: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 99);
723: OPEN c_gre_fed(gre_rec.gre);
724: ELSIF p_report_type = 'STW2' THEN --state W2
725: OPEN c_gre_state(gre_rec.gre);
726: END IF;

Line 736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);

732: -- Start feching Persons for GRE
733: FETCH c_gre_fed INTO l_person
734: ,l_assignment
735: ,l_asg_effective_dt;
736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

Line 737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));

733: FETCH c_gre_fed INTO l_person
734: ,l_assignment
735: ,l_asg_effective_dt;
736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
741: IF c_gre_fed%NOTFOUND THEN

Line 738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));

734: ,l_assignment
735: ,l_asg_effective_dt;
736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
741: IF c_gre_fed%NOTFOUND THEN
742: -- get out of the Main Loop if You have reached No person Found

Line 739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));

735: ,l_asg_effective_dt;
736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
741: IF c_gre_fed%NOTFOUND THEN
742: -- get out of the Main Loop if You have reached No person Found
743: EXIT;

Line 740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

736: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
737: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
738: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
739: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
740: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
741: IF c_gre_fed%NOTFOUND THEN
742: -- get out of the Main Loop if You have reached No person Found
743: EXIT;
744: END IF;

Line 752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);

748: FETCH c_gre_state INTO l_person
749: ,l_assignment
750: ,l_asg_effective_dt;
751:
752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

Line 753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));

749: ,l_assignment
750: ,l_asg_effective_dt;
751:
752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
757: -- No Person Was found for the State So Exit

Line 754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));

750: ,l_asg_effective_dt;
751:
752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
757: -- No Person Was found for the State So Exit
758: IF c_gre_state%NOTFOUND THEN

Line 755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));

751:
752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
757: -- No Person Was found for the State So Exit
758: IF c_gre_state%NOTFOUND THEN
759: EXIT;

Line 756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

752: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
753: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
754: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
755: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
756: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
757: -- No Person Was found for the State So Exit
758: IF c_gre_state%NOTFOUND THEN
759: EXIT;
760: END IF;

Line 764: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');

760: END IF;
761: END IF; -- report type = 'STW2' and etc
762:
763:
764: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
765: hr_utility.trace('GRE - '||to_char(l_gre));
766:
767: -- get the balance for person
768:

Line 765: hr_utility.trace('GRE - '||to_char(l_gre));

761: END IF; -- report type = 'STW2' and etc
762:
763:
764: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
765: hr_utility.trace('GRE - '||to_char(l_gre));
766:
767: -- get the balance for person
768:
769: IF p_report_type = 'FEDW2' THEN

Line 799: hr_utility.trace('Archive_Gre ' || to_char(l_gre));

795: close c_gre_fed;
796: ELSE
797: close c_gre_state;
798: END IF; -- End Of Report_type 'FEDW2'
799: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
800: -- Person Found with Balance for given GRE
801: message_text := 'GRE_ID := ' || to_char(l_gre)
802: || ' has People with Balnace > 0';
803: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 841: hr_utility.trace('Error Condition Found');

837:
838: END LOOP; /* end of for statement */
839:
840: IF l_package_error_status = 'Y' THEN
841: hr_utility.trace('Error Condition Found');
842: message_text := 'Error Condition detected ' ;
843: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
844: pay_core_utils.push_token('record_name',message_preprocess);
845: pay_core_utils.push_token('description',message_text);

Line 851: hr_utility.raise_error;

847: message_text := 'Pay Message line and log have more Details' ;
848: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
849: pay_core_utils.push_token('record_name',message_preprocess);
850: pay_core_utils.push_token('description',message_text);
851: hr_utility.raise_error;
852: END IF;
853:
854: IF l_no_of_gres_picked = 0 THEN
855: --It means that no archived GRE was

Line 862: hr_utility.raise_error;

858: message_text := 'No GRE was picked for Magnetic Tape';
859: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
860: pay_core_utils.push_token('record_name',message_preprocess);
861: pay_core_utils.push_token('description',message_text);
862: hr_utility.raise_error;
863: END IF;
864:
865: RETURN TRUE;
866: hr_utility.trace('Succesful - Return True ');

Line 866: hr_utility.trace('Succesful - Return True ');

862: hr_utility.raise_error;
863: END IF;
864:
865: RETURN TRUE;
866: hr_utility.trace('Succesful - Return True ');
867: exception
868: when others then
869: -- add message for this
870: message_text := message_text || '+ Exception';

Line 871: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

867: exception
868: when others then
869: -- add message for this
870: message_text := message_text || '+ Exception';
871: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
872: hr_utility.set_message_token('MESSAGE', message_text);
873: hr_utility.raise_error;
874:
875: END preprocess_check;

Line 872: hr_utility.set_message_token('MESSAGE', message_text);

868: when others then
869: -- add message for this
870: message_text := message_text || '+ Exception';
871: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
872: hr_utility.set_message_token('MESSAGE', message_text);
873: hr_utility.raise_error;
874:
875: END preprocess_check;
876: --

Line 873: hr_utility.raise_error;

869: -- add message for this
870: message_text := message_text || '+ Exception';
871: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
872: hr_utility.set_message_token('MESSAGE', message_text);
873: hr_utility.raise_error;
874:
875: END preprocess_check;
876: --
877: ----------------------------------------------------------------------------

Line 902: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 10);

898: p_state_code VARCHAR2(2);
899: p_report_type VARCHAR2(30);
900: BEGIN
901:
902: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 10);
903: get_report_parameters(
904: p_pactid,
905: p_year_start,
906: p_year_end,

Line 912: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 20);

908: p_state_code,
909: p_report_type,
910: p_business_group_id
911: );
912: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 20);
913: IF preprocess_check(p_pactid,
914: p_year_start,
915: p_year_end,
916: p_business_group_id,

Line 947: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',

943: and hoi.org_information_context =
944: ''1099R Magnetic Report Rules'')
945: ORDER BY paf.person_id
946: ';
947: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
948: 30);
949: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'IN' THEN
950: p_sqlstr := 'SELECT DISTINCT '||
951: 'to_number(paa.serial_number) '||

Line 1015: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',

1011: 'and hoi.org_information_context = '||
1012: '''1099R Magnetic Report Rules'' '||
1013: ') '||
1014: 'order by to_number(paa.serial_number)';
1015: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1016: 40);
1017: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'OH' THEN
1018: p_sqlstr := 'SELECT DISTINCT '||
1019: 'to_number(paa.serial_number) '||

Line 1083: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',

1079: 'and hoi.org_information_context = '||
1080: '''1099R Magnetic Report Rules'' '||
1081: ') '||
1082: 'order by to_number(paa.serial_number)';
1083: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1084: 40);
1085:
1086: ELSIF p_report_type = 'STW2' THEN
1087: p_sqlstr := '

Line 1133: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',

1129: and hoi.org_information_context =
1130: ''1099R Magnetic Report Rules''
1131: )
1132: order by to_number(paa.serial_number)';
1133: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1134: 40);
1135: END IF;
1136: END IF;
1137: END range_cursor;

Line 1557: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',

1553: l_gre_id := -1;
1554: l_error_flag := 'N';
1555:
1556: -- Get the report parameters. These define the report being run.
1557: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1558: 10);
1559: get_report_parameters(
1560: p_pactid,
1561: l_year_start,

Line 1571: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',

1567: );
1568: --Currently all reports group by GRE
1569: l_group_by_gre := TRUE;
1570: --Open the appropriate cursor
1571: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1572: 20);
1573: IF l_report_type = 'FEDW2' THEN
1574: OPEN c_federal;
1575: --

Line 1596: hr_utility.set_location(

1592: l_assignment_id,
1593: l_tax_unit_id,
1594: l_effective_end_date,
1595: l_assignment_action_id;
1596: hr_utility.set_location(
1597: 'pay_us_mmref_reporting.create_assignement_act', 30);
1598: EXIT WHEN c_federal%NOTFOUND;
1599: ELSIF l_report_type = 'STW2' and l_state_abbrev = 'PR' THEN
1600: FETCH c_pr_state INTO l_person_id,

Line 1606: hr_utility.set_location(

1602: l_tax_unit_id,
1603: l_effective_end_date,
1604: l_assignment_action_id,
1605: l_w2_box17;
1606: hr_utility.set_location(
1607: 'pay_us_mmref_reporting.create_assignement_act', 40);
1608: EXIT WHEN c_pr_state%NOTFOUND;
1609: -- Check the state Tax rules if new gre
1610: -- Set the Error Flag to Y so that Action Creation will Error

Line 1614: hr_utility.trace('Same GRE ');

1610: -- Set the Error Flag to Y so that Action Creation will Error
1611: -- At the End
1612:
1613: IF l_gre_id = l_tax_unit_id THEN
1614: hr_utility.trace('Same GRE ');
1615: ELSE
1616: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1617: hr_utility.trace('State Tax Rules Missing in GRE');
1618: l_gre_id := l_tax_unit_id;

Line 1617: hr_utility.trace('State Tax Rules Missing in GRE');

1613: IF l_gre_id = l_tax_unit_id THEN
1614: hr_utility.trace('Same GRE ');
1615: ELSE
1616: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1617: hr_utility.trace('State Tax Rules Missing in GRE');
1618: l_gre_id := l_tax_unit_id;
1619: l_error_flag := 'Y';
1620: ELSE
1621: l_gre_id := l_tax_unit_id;

Line 1632: hr_utility.set_location(

1628: l_tax_unit_id,
1629: l_effective_end_date,
1630: l_assignment_action_id,
1631: l_w2_box17;
1632: hr_utility.set_location(
1633: 'pay_us_mmref_reporting.create_assignement_act', 40);
1634: EXIT WHEN c_state_indiana%NOTFOUND;
1635: -- Check the state Tax rules if new gre
1636: -- Set the Error Flag to Y so that Action Creation will Error

Line 1640: hr_utility.trace('Same GRE ');

1636: -- Set the Error Flag to Y so that Action Creation will Error
1637: -- At the End
1638:
1639: IF l_gre_id = l_tax_unit_id THEN
1640: hr_utility.trace('Same GRE ');
1641: ELSE
1642: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1643: hr_utility.trace('State Tax Rules Missing in GRE');
1644: l_gre_id := l_tax_unit_id;

Line 1643: hr_utility.trace('State Tax Rules Missing in GRE');

1639: IF l_gre_id = l_tax_unit_id THEN
1640: hr_utility.trace('Same GRE ');
1641: ELSE
1642: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1643: hr_utility.trace('State Tax Rules Missing in GRE');
1644: l_gre_id := l_tax_unit_id;
1645: l_error_flag := 'Y';
1646: ELSE
1647: l_gre_id := l_tax_unit_id;

Line 1659: hr_utility.set_location(

1655: l_tax_unit_id,
1656: l_effective_end_date,
1657: l_assignment_action_id,
1658: l_w2_box17;
1659: hr_utility.set_location(
1660: 'pay_us_mmref_reporting.create_assignement_act', 40);
1661: EXIT WHEN c_state_ohio%NOTFOUND;
1662: -- Check the state Tax rules if new gre
1663: -- Set the Error Flag to Y so that Action Creation will Error

Line 1667: hr_utility.trace('Same GRE ');

1663: -- Set the Error Flag to Y so that Action Creation will Error
1664: -- At the End
1665:
1666: IF l_gre_id = l_tax_unit_id THEN
1667: hr_utility.trace('Same GRE ');
1668: ELSE
1669: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1670: hr_utility.trace('State Tax Rules Missing in GRE');
1671: l_gre_id := l_tax_unit_id;

Line 1670: hr_utility.trace('State Tax Rules Missing in GRE');

1666: IF l_gre_id = l_tax_unit_id THEN
1667: hr_utility.trace('Same GRE ');
1668: ELSE
1669: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1670: hr_utility.trace('State Tax Rules Missing in GRE');
1671: l_gre_id := l_tax_unit_id;
1672: l_error_flag := 'Y';
1673: ELSE
1674: l_gre_id := l_tax_unit_id;

Line 1685: hr_utility.set_location(

1681: l_tax_unit_id,
1682: l_effective_end_date,
1683: l_assignment_action_id,
1684: l_w2_box17;
1685: hr_utility.set_location(
1686: 'pay_us_mmref_reporting.create_assignement_act', 40);
1687: EXIT WHEN c_state%NOTFOUND;
1688: -- Check the state Tax rules if new gre
1689: -- Set the Error Flag to Y so that Action Creation will Error

Line 1693: hr_utility.trace('Same GRE ');

1689: -- Set the Error Flag to Y so that Action Creation will Error
1690: -- At the End
1691:
1692: IF l_gre_id = l_tax_unit_id THEN
1693: hr_utility.trace('Same GRE ');
1694: ELSE
1695: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1696: hr_utility.trace('State Tax Rules Missing in GRE');
1697: l_gre_id := l_tax_unit_id;

Line 1696: hr_utility.trace('State Tax Rules Missing in GRE');

1692: IF l_gre_id = l_tax_unit_id THEN
1693: hr_utility.trace('Same GRE ');
1694: ELSE
1695: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1696: hr_utility.trace('State Tax Rules Missing in GRE');
1697: l_gre_id := l_tax_unit_id;
1698: l_error_flag := 'Y';
1699: ELSE
1700: l_gre_id := l_tax_unit_id;

Line 1716: hr_utility.set_location(

1712: l_tax_unit_id = l_prev_tax_unit_id) OR
1713: (NOT l_group_by_gre AND
1714: l_person_id = l_prev_person_id)) THEN
1715: --Do Nothing
1716: hr_utility.set_location(
1717: 'pay_us_mmref_reporting.create_assignement_act', 50);
1718: NULL;
1719: ELSE
1720: --Create the assignment action for the record

Line 1721: hr_utility.trace('Assignment Fetched - ');

1717: 'pay_us_mmref_reporting.create_assignement_act', 50);
1718: NULL;
1719: ELSE
1720: --Create the assignment action for the record
1721: hr_utility.trace('Assignment Fetched - ');
1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1725: hr_utility.trace('Effective End Date : '||

Line 1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));

1718: NULL;
1719: ELSE
1720: --Create the assignment action for the record
1721: hr_utility.trace('Assignment Fetched - ');
1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1725: hr_utility.trace('Effective End Date : '||
1726: to_char(l_effective_end_date));

Line 1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));

1719: ELSE
1720: --Create the assignment action for the record
1721: hr_utility.trace('Assignment Fetched - ');
1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1725: hr_utility.trace('Effective End Date : '||
1726: to_char(l_effective_end_date));
1727:

Line 1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));

1720: --Create the assignment action for the record
1721: hr_utility.trace('Assignment Fetched - ');
1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1725: hr_utility.trace('Effective End Date : '||
1726: to_char(l_effective_end_date));
1727:
1728: IF l_report_type = 'FEDW2' then

Line 1725: hr_utility.trace('Effective End Date : '||

1721: hr_utility.trace('Assignment Fetched - ');
1722: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1723: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1724: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1725: hr_utility.trace('Effective End Date : '||
1726: to_char(l_effective_end_date));
1727:
1728: IF l_report_type = 'FEDW2' then
1729:

Line 1791: hr_utility.set_location(

1787: (l_report_type = 'STW2') then
1788: SELECT pay_assignment_actions_s.nextval
1789: INTO lockingactid
1790: FROM dual;
1791: hr_utility.set_location(
1792: 'pay_us_mmref_reporting.create_assignement_act', 60);
1793: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1794: p_chunk, l_tax_unit_id);
1795: hr_utility.set_location(

Line 1795: hr_utility.set_location(

1791: hr_utility.set_location(
1792: 'pay_us_mmref_reporting.create_assignement_act', 60);
1793: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1794: p_chunk, l_tax_unit_id);
1795: hr_utility.set_location(
1796: 'pay_us_mmref_reporting.create_assignement_act', 70);
1797: --update serial number for highly compensated people for the
1798: --state W2.
1799: /*IF l_report_type = 'STW2' THEN

Line 1800: hr_utility.set_location(

1796: 'pay_us_mmref_reporting.create_assignement_act', 70);
1797: --update serial number for highly compensated people for the
1798: --state W2.
1799: /*IF l_report_type = 'STW2' THEN
1800: hr_utility.set_location(
1801: 'pay_us_mmref_reporting.create_assignement_act', 80);
1802: IF l_w2_box17 > 9999999.99 THEN
1803: UPDATE pay_assignment_actions
1804: SET serial_number = 999999

Line 1809: hr_utility.set_location(

1805: WHERE assignment_action_id = lockingactid;
1806: END IF;
1807: END IF;*/ -- 4490252
1808: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1809: hr_utility.set_location(
1810: 'pay_us_mmref_reporting.create_assignement_act', 90);
1811: hr_utility.trace('Interlock Created - ');
1812: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1813: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

Line 1811: hr_utility.trace('Interlock Created - ');

1807: END IF;*/ -- 4490252
1808: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1809: hr_utility.set_location(
1810: 'pay_us_mmref_reporting.create_assignement_act', 90);
1811: hr_utility.trace('Interlock Created - ');
1812: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1813: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1814: --Store the current person/GRE for comparision during the
1815: --next iteration.

Line 1812: hr_utility.trace('Locking Action : '|| to_char(lockingactid));

1808: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1809: hr_utility.set_location(
1810: 'pay_us_mmref_reporting.create_assignement_act', 90);
1811: hr_utility.trace('Interlock Created - ');
1812: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1813: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1814: --Store the current person/GRE for comparision during the
1815: --next iteration.
1816: l_prev_person_id := l_person_id;

Line 1813: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

1809: hr_utility.set_location(
1810: 'pay_us_mmref_reporting.create_assignement_act', 90);
1811: hr_utility.trace('Interlock Created - ');
1812: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1813: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1814: --Store the current person/GRE for comparision during the
1815: --next iteration.
1816: l_prev_person_id := l_person_id;
1817: l_prev_tax_unit_id := l_tax_unit_id;

Line 1835: hr_utility.trace('Error Flag was set to Y');

1831: CLOSE c_state;
1832: END IF;
1833:
1834: IF l_error_flag = 'Y' THEN
1835: hr_utility.trace('Error Flag was set to Y');
1836: hr_utility.raise_error;
1837: END IF;
1838:
1839: END create_assignment_act;

Line 1836: hr_utility.raise_error;

1832: END IF;
1833:
1834: IF l_error_flag = 'Y' THEN
1835: hr_utility.trace('Error Flag was set to Y');
1836: hr_utility.raise_error;
1837: END IF;
1838:
1839: END create_assignment_act;
1840:

Line 1986: hr_utility.trace('Calling the state archiving ');

1982: IS
1983: BEGIN
1984: /* get the Parameter Setting */
1985:
1986: hr_utility.trace('Calling the state archiving ');
1987: hr_utility.trace('Pactid ' || to_char(p_pactid));
1988: hr_utility.trace('tax id ' || to_char(p_tax_id));
1989: hr_utility.trace('Pactid ' || p_state_code);
1990:

Line 1987: hr_utility.trace('Pactid ' || to_char(p_pactid));

1983: BEGIN
1984: /* get the Parameter Setting */
1985:
1986: hr_utility.trace('Calling the state archiving ');
1987: hr_utility.trace('Pactid ' || to_char(p_pactid));
1988: hr_utility.trace('tax id ' || to_char(p_tax_id));
1989: hr_utility.trace('Pactid ' || p_state_code);
1990:
1991: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);

Line 1988: hr_utility.trace('tax id ' || to_char(p_tax_id));

1984: /* get the Parameter Setting */
1985:
1986: hr_utility.trace('Calling the state archiving ');
1987: hr_utility.trace('Pactid ' || to_char(p_pactid));
1988: hr_utility.trace('tax id ' || to_char(p_tax_id));
1989: hr_utility.trace('Pactid ' || p_state_code);
1990:
1991: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1992:

Line 1989: hr_utility.trace('Pactid ' || p_state_code);

1985:
1986: hr_utility.trace('Calling the state archiving ');
1987: hr_utility.trace('Pactid ' || to_char(p_pactid));
1988: hr_utility.trace('tax id ' || to_char(p_tax_id));
1989: hr_utility.trace('Pactid ' || p_state_code);
1990:
1991: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1992:
1993: END ARCHIVE_STATE_EOY_DATA;

Line 2084: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

2080: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2081: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2082: pay_core_utils.push_token('record_name',l_message_preprocess);
2083: pay_core_utils.push_token('description',l_message_text);
2084: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2085: l_control_num_flag := 'N';
2086: else
2087: if (l_control_number is NULL or l_control_number = 0) then
2088: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';

Line 2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

2085: l_control_num_flag := 'N';
2086: else
2087: if (l_control_number is NULL or l_control_number = 0) then
2088: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2090: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2091: pay_core_utils.push_token('record_name',l_message_preprocess);
2092: pay_core_utils.push_token('description',l_message_text);
2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

Line 2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

2089: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2090: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2091: pay_core_utils.push_token('record_name',l_message_preprocess);
2092: pay_core_utils.push_token('description',l_message_text);
2093: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2094: l_control_num_flag := 'N';
2095: end if;
2096: end if;
2097: close c_get_pr_control_num;

Line 2103: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;

2099: open c_sit_check(C1.payroll_action,c1.unit_id,l_w2_state);
2100: l_message_preprocess := 'GRE: ' ||c1.name || ' has ' ;
2101: fetch c_sit_check INTO l_info ;
2102: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
2103: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2104: if c_sit_check%notfound then
2105: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2106: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2107: pay_core_utils.push_token('record_name',l_message_preprocess);

Line 2109: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

2105: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2106: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2107: pay_core_utils.push_token('record_name',l_message_preprocess);
2108: pay_core_utils.push_token('description',l_message_text);
2109: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2110: l_flag := 'N';
2111: close c_sit_check;
2112: else
2113: if l_info IS NULL THEN

Line 2116: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

2112: else
2113: if l_info IS NULL THEN
2114: l_flag := 'N';
2115: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2116: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2117: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2118: pay_core_utils.push_token('record_name',l_message_preprocess);
2119: pay_core_utils.push_token('description',l_message_text);
2120: end if ;

Line 2129: hr_utility.raise_error;

2125: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2126: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2127: pay_core_utils.push_token('record_name',l_message_preprocess);
2128: pay_core_utils.push_token('description',l_message_text);
2129: hr_utility.raise_error;
2130: return 'N';
2131: END IF;
2132: return 'Y';
2133: EXCEPTION

Line 2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');

2137: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2138: pay_core_utils.push_token('record_name',l_message_preprocess);
2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2142: hr_utility.set_message_token('MESSAGE', u_message_text);
2143: hr_utility.raise_error;
2144: return 'Y';
2145: END check_state_data;

Line 2142: hr_utility.set_message_token('MESSAGE', u_message_text);

2138: pay_core_utils.push_token('record_name',l_message_preprocess);
2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2142: hr_utility.set_message_token('MESSAGE', u_message_text);
2143: hr_utility.raise_error;
2144: return 'Y';
2145: END check_state_data;
2146:

Line 2143: hr_utility.raise_error;

2139: pay_core_utils.push_token('description',l_message_text);
2140: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2141: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2142: hr_utility.set_message_token('MESSAGE', u_message_text);
2143: hr_utility.raise_error;
2144: return 'Y';
2145: END check_state_data;
2146:
2147: -- ----------------------------------------------------------------------------

Line 2205: hr_utility.set_location('Entering:'||l_proc, 10);

2201: );
2202:
2203: BEGIN
2204: --
2205: hr_utility.set_location('Entering:'||l_proc, 10);
2206: --
2207:
2208:
2209: -- Get the user entity id for A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER

Line 2290: hr_utility.set_location('Entering: ' || l_proc, 10);

2286: AND fai.value = 'Y'
2287: );
2288: BEGIN
2289: --
2290: hr_utility.set_location('Entering: ' || l_proc, 10);
2291: --
2292: -- Get the user entity id for A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER
2293:
2294: FOR c_rec IN c_get_user_entity_id

Line 2318: --raise hr_utility.hr_error;

2314: RETURN varchar2 IS
2315: BEGIN
2316: IF p_state = 'FED' and p_error = 'Y'
2317: THEN
2318: --raise hr_utility.hr_error;
2319: update pay_assignment_actions
2320: set SERIAL_NUMBER = 'E999999999'
2321: where assignment_action_id = p_assignment_action_id;
2322: return 'Y';

Line 2364: hr_utility.trace('In Procedure PAY_US_MMREF_REPORTING.GET_TAX_UNIT_INFO' );

2360: l_payroll_action_id NUMBER;
2361: l_tax_jurisdiction_code VARCHAR2(200);
2362:
2363: BEGIN
2364: hr_utility.trace('In Procedure PAY_US_MMREF_REPORTING.GET_TAX_UNIT_INFO' );
2365: OPEN c_get_tax_unit_info(tax_unit_id,
2366: p_tax_year);
2367: FETCH c_get_tax_unit_info INTO l_federal_EIN,
2368: l_tax_unit_name;

Line 2387: hr_utility.trace('Federal EIN '||l_federal_EIN );

2383: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2384: END IF;
2385: p_tax_jd_code := l_tax_jurisdiction_code;
2386: END;
2387: hr_utility.trace('Federal EIN '||l_federal_EIN );
2388: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2389: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2390: return l_tax_unit_name;
2391: EXCEPTION

Line 2388: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);

2384: END IF;
2385: p_tax_jd_code := l_tax_jurisdiction_code;
2386: END;
2387: hr_utility.trace('Federal EIN '||l_federal_EIN );
2388: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2389: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2390: return l_tax_unit_name;
2391: EXCEPTION
2392: WHEN OTHERS THEN

Line 2389: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);

2385: p_tax_jd_code := l_tax_jurisdiction_code;
2386: END;
2387: hr_utility.trace('Federal EIN '||l_federal_EIN );
2388: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2389: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2390: return l_tax_unit_name;
2391: EXCEPTION
2392: WHEN OTHERS THEN
2393: l_tax_unit_name := ' ';

Line 2714: -- hr_utility.trace_on(NULL,'FEDW2MT');

2710: l_a72 number := 0;
2711: l_a73 number := 0;
2712: l_a22 number := 0; /* 7109106 */
2713: BEGIN
2714: -- hr_utility.trace_on(NULL,'FEDW2MT');
2715: hr_utility.trace('In Procedure GET_W2_ER_ARCH_BAL' );
2716:
2717: a1 := '0';
2718: a2 := '0';

Line 2715: hr_utility.trace('In Procedure GET_W2_ER_ARCH_BAL' );

2711: l_a73 number := 0;
2712: l_a22 number := 0; /* 7109106 */
2713: BEGIN
2714: -- hr_utility.trace_on(NULL,'FEDW2MT');
2715: hr_utility.trace('In Procedure GET_W2_ER_ARCH_BAL' );
2716:
2717: a1 := '0';
2718: a2 := '0';
2719: a3 := '0';

Line 2886: hr_utility.trace('UE Name : '|| i.user_entity_name || ' SumValue '|| to_char( i.val));

2882: IF i.user_entity_name = 'A_W2_NONQUAL_457_PER_GRE_YTD' THEN
2883: l_a70 := i.val;
2884: END IF;
2885:
2886: hr_utility.trace('UE Name : '|| i.user_entity_name || ' SumValue '|| to_char( i.val));
2887: END LOOP;
2888: /*
2889: a2 := to_char(round(l_a2, 2) * 100);
2890: a20 := to_char(round(l_a20, 2) * 100);

Line 2935: hr_utility.trace('Value of a1 : '||a1 );

2931: a22 := a22 - l_a22 ; /* 7109106 */
2932: a39 := to_char(round(l_a39, 2) * 100 ) ;
2933: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
2934:
2935: hr_utility.trace('Value of a1 : '||a1 );
2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );

Line 2936: hr_utility.trace('Value of a2 : '||a2);

2932: a39 := to_char(round(l_a39, 2) * 100 ) ;
2933: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
2934:
2935: hr_utility.trace('Value of a1 : '||a1 );
2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );

Line 2937: hr_utility.trace('Value of a3 : '||a3 );

2933: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
2934:
2935: hr_utility.trace('Value of a1 : '||a1 );
2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );

Line 2938: hr_utility.trace('Value of a4 : '||a4 );

2934:
2935: hr_utility.trace('Value of a1 : '||a1 );
2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );

Line 2939: hr_utility.trace('Value of a5 : '||a5 );

2935: hr_utility.trace('Value of a1 : '||a1 );
2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );

Line 2940: hr_utility.trace('Value of a6 : '||a6 );

2936: hr_utility.trace('Value of a2 : '||a2);
2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );

Line 2941: hr_utility.trace('Value of a7 : '||a7 );

2937: hr_utility.trace('Value of a3 : '||a3 );
2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );

Line 2942: hr_utility.trace('Value of a8 : '||a8 );

2938: hr_utility.trace('Value of a4 : '||a4 );
2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );

Line 2943: hr_utility.trace('Value of a9 : '||a9 );

2939: hr_utility.trace('Value of a5 : '||a5 );
2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );

Line 2944: hr_utility.trace('Value of a10 : '||a10 );

2940: hr_utility.trace('Value of a6 : '||a6 );
2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );

Line 2945: hr_utility.trace('Value of a11 : '||a11 );

2941: hr_utility.trace('Value of a7 : '||a7 );
2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );

Line 2946: hr_utility.trace('Value of a12 : '||a12 );

2942: hr_utility.trace('Value of a8 : '||a8 );
2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );

Line 2947: hr_utility.trace('Value of a13 : '||a13 );

2943: hr_utility.trace('Value of a9 : '||a9 );
2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );

Line 2948: hr_utility.trace('Value of a14 : '||a14 );

2944: hr_utility.trace('Value of a10 : '||a10 );
2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );

Line 2949: hr_utility.trace('Value of a15 : '||a15 );

2945: hr_utility.trace('Value of a11 : '||a11 );
2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );

Line 2950: hr_utility.trace('Value of a16 : '||a16 );

2946: hr_utility.trace('Value of a12 : '||a12 );
2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );

Line 2951: hr_utility.trace('Value of a17 : '||a17 );

2947: hr_utility.trace('Value of a13 : '||a13 );
2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );

Line 2952: hr_utility.trace('Value of a18 : '||a18 );

2948: hr_utility.trace('Value of a14 : '||a14 );
2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );

Line 2953: hr_utility.trace('Value of a19 : '||a19 );

2949: hr_utility.trace('Value of a15 : '||a15 );
2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );

Line 2954: hr_utility.trace('Value of a20 : '||a20 );

2950: hr_utility.trace('Value of a16 : '||a16 );
2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );

Line 2955: hr_utility.trace('Value of a21 : '||a21 );

2951: hr_utility.trace('Value of a17 : '||a17 );
2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );

Line 2956: hr_utility.trace('Value of a22 : '||a22 );

2952: hr_utility.trace('Value of a18 : '||a18 );
2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );

Line 2957: hr_utility.trace('Value of a23 : '||a23 );

2953: hr_utility.trace('Value of a19 : '||a19 );
2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );

Line 2958: hr_utility.trace('Value of a24 : '||a24 );

2954: hr_utility.trace('Value of a20 : '||a20 );
2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );

Line 2959: hr_utility.trace('Value of a25 : '||a25 );

2955: hr_utility.trace('Value of a21 : '||a21 );
2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );

Line 2960: hr_utility.trace('Value of a26 : '||a26 );

2956: hr_utility.trace('Value of a22 : '||a22 );
2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );

Line 2961: hr_utility.trace('Value of a27 : '||a27 );

2957: hr_utility.trace('Value of a23 : '||a23 );
2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );

Line 2962: hr_utility.trace('Value of a28 : '||a28 );

2958: hr_utility.trace('Value of a24 : '||a24 );
2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );

Line 2963: hr_utility.trace('Value of a29 : '||a29 );

2959: hr_utility.trace('Value of a25 : '||a25 );
2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );

Line 2964: hr_utility.trace('Value of a30 : '||a30 );

2960: hr_utility.trace('Value of a26 : '||a26 );
2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );

Line 2965: hr_utility.trace('Value of a31 : '||a31 );

2961: hr_utility.trace('Value of a27 : '||a27 );
2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );

Line 2966: hr_utility.trace('Value of a32 : '||a32 );

2962: hr_utility.trace('Value of a28 : '||a28 );
2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );

Line 2967: hr_utility.trace('Value of a33 : '||a33 );

2963: hr_utility.trace('Value of a29 : '||a29 );
2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );

Line 2968: hr_utility.trace('Value of a34 : '||a34 );

2964: hr_utility.trace('Value of a30 : '||a30 );
2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );

Line 2969: hr_utility.trace('Value of a35 : '||a35 );

2965: hr_utility.trace('Value of a31 : '||a31 );
2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );

Line 2970: hr_utility.trace('Value of a36 : '||a36 );

2966: hr_utility.trace('Value of a32 : '||a32 );
2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );

Line 2971: hr_utility.trace('Value of a37 : '||a37 );

2967: hr_utility.trace('Value of a33 : '||a33 );
2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );

Line 2972: hr_utility.trace('Value of a38 : '||a38 );

2968: hr_utility.trace('Value of a34 : '||a34 );
2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );

Line 2973: hr_utility.trace('Value of a39 : '||a39 );

2969: hr_utility.trace('Value of a35 : '||a35 );
2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );

Line 2974: hr_utility.trace('Value of a40 : '||a40 );

2970: hr_utility.trace('Value of a36 : '||a36 );
2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );

Line 2975: hr_utility.trace('Value of a41 : '||a41 );

2971: hr_utility.trace('Value of a37 : '||a37 );
2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );

Line 2976: hr_utility.trace('Value of a42 : '||a42 );

2972: hr_utility.trace('Value of a38 : '||a38 );
2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );

Line 2977: hr_utility.trace('Value of a43 : '||a43 );

2973: hr_utility.trace('Value of a39 : '||a39 );
2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );

Line 2978: hr_utility.trace('Value of a44 : '||a44 );

2974: hr_utility.trace('Value of a40 : '||a40 );
2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));

Line 2979: hr_utility.trace('Value of a45 : '||a45 );

2975: hr_utility.trace('Value of a41 : '||a41 );
2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));

Line 2980: hr_utility.trace('Value of a46 : '||a46 );

2976: hr_utility.trace('Value of a42 : '||a42 );
2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));
2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));

Line 2981: hr_utility.trace('Value of a47 : '||a47 );

2977: hr_utility.trace('Value of a43 : '||a43 );
2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));
2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));
2985:

Line 2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));

2978: hr_utility.trace('Value of a44 : '||a44 );
2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));
2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));
2985:
2986: return '0' ;

Line 2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));

2979: hr_utility.trace('Value of a45 : '||a45 );
2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));
2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));
2985:
2986: return '0' ;
2987: END get_w2_er_arch_bal;

Line 2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));

2980: hr_utility.trace('Value of a46 : '||a46 );
2981: hr_utility.trace('Value of a47 : '||a47 );
2982: hr_utility.trace('Value of a71 : '||to_char(l_a71));
2983: hr_utility.trace('Value of a72 : '||to_char(l_a72));
2984: hr_utility.trace('Value of a73 : '||to_char(l_a73));
2985:
2986: return '0' ;
2987: END get_w2_er_arch_bal;
2988:

Line 2990: -- hr_utility.trace_on(NULL,'FEDW2MT');

2986: return '0' ;
2987: END get_w2_er_arch_bal;
2988:
2989: --BEGIN
2990: -- hr_utility.trace_on(NULL,'FEDW2MT');
2991: END pay_us_mmref_reporting;