APPS.PAY_US_MMREF_REPORTING dependencies on HR_UTILITY

Line 165: hr_utility.set_location

161: AND UE.creator_type = 'B'
162: AND UE.legislation_code = 'US'; /* Bug:2296797 */
163: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
164: BEGIN
165: hr_utility.set_location
166: ('pay_us_mmref_reporting.bal_db_item - opening cursor', 10);
167: -- Open the cursor
168: OPEN csr_defined_balance;
169: -- Fetch the value

Line 174: hr_utility.set_location

170: FETCH csr_defined_balance
171: INTO l_defined_balance_id;
172: IF csr_defined_balance%NOTFOUND THEN
173: CLOSE csr_defined_balance;
174: hr_utility.set_location
175: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location

Line 176: hr_utility.raise_error;

172: IF csr_defined_balance%NOTFOUND THEN
173: CLOSE csr_defined_balance;
174: hr_utility.set_location
175: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location
179: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
180: CLOSE csr_defined_balance;

Line 178: hr_utility.set_location

174: hr_utility.set_location
175: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
176: hr_utility.raise_error;
177: ELSE
178: hr_utility.set_location
179: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
180: CLOSE csr_defined_balance;
181: END IF;
182: /* Return the value to the call */

Line 215: hr_utility.set_location

211: p_report_type IN OUT nocopy VARCHAR2,
212: p_business_group_id IN OUT nocopy NUMBER
213: ) IS
214: BEGIN
215: hr_utility.set_location
216: ('pay_us_mmref_reporting.get_report_parameters', 10);
217: SELECT ppa.start_date,
218: ppa.effective_date,
219: ppa.business_group_id,

Line 234: hr_utility.set_location

230: SELECT state_code
231: INTO p_state_code
232: FROM pay_us_states
233: WHERE state_abbrev = p_state_abbrev;
234: hr_utility.set_location
235: ('pay_us_mmref_reporting.get_report_parameters', 20);
236: ELSE
237: p_state_code := '';
238: hr_utility.set_location

Line 238: hr_utility.set_location

234: hr_utility.set_location
235: ('pay_us_mmref_reporting.get_report_parameters', 20);
236: ELSE
237: p_state_code := '';
238: hr_utility.set_location
239: ('pay_us_mmref_reporting.get_report_parameters', 30);
240: END IF;
241: IF p_state_abbrev = 'FED' AND p_report_type = 'W2' THEN
242: p_report_type := 'FEDW2';

Line 246: hr_utility.set_location

242: p_report_type := 'FEDW2';
243: ELSIF p_report_type = 'W2' THEN
244: p_report_type := 'STW2';
245: END IF;
246: hr_utility.set_location
247: ('pay_us_mmref_reporting.get_report_parameters', 40);
248: END get_report_parameters;
249: -------------------------------------------------------------------------
250: -- Name : get_balance_value

Line 274: hr_utility.set_location

270: p_effective_date DATE
271: ) RETURN NUMBER IS
272: l_jurisdiction_code VARCHAR2(20);
273: BEGIN
274: hr_utility.set_location
275: ('pay_us_mmref_reporting.get_balance_value', 10);
276: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
277: IF p_state_abbrev <> 'FED' THEN
278: SELECT jurisdiction_code

Line 282: hr_utility.set_location

278: SELECT jurisdiction_code
279: INTO l_jurisdiction_code
280: FROM pay_state_rules
281: WHERE state_code = p_state_abbrev;
282: hr_utility.set_location
283: ('pay_us_mmref_reporting.get_balance_value', 15);
284: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
285: END IF;
286: hr_utility.trace(p_balance_name);

Line 286: hr_utility.trace(p_balance_name);

282: hr_utility.set_location
283: ('pay_us_mmref_reporting.get_balance_value', 15);
284: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
285: END IF;
286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location

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

283: ('pay_us_mmref_reporting.get_balance_value', 15);
284: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
285: END IF;
286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location
291: ('pay_us_mmref_reporting.get_balance_value', 20);

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

284: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
285: END IF;
286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location
291: ('pay_us_mmref_reporting.get_balance_value', 20);
292: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

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

285: END IF;
286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location
291: ('pay_us_mmref_reporting.get_balance_value', 20);
292: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
293: p_assignment_id, p_effective_date);

Line 290: hr_utility.set_location

286: hr_utility.trace(p_balance_name);
287: hr_utility.trace('Context');
288: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
289: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
290: hr_utility.set_location
291: ('pay_us_mmref_reporting.get_balance_value', 20);
292: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
293: p_assignment_id, p_effective_date);
294: END get_balance_value;

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

497: FETCH c_tax_ein INTO l_ein;
498: IF c_tax_ein%NOTFOUND THEN
499: CLOSE c_tax_ein;
500: l_package_error_status := 'Y';
501: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
502: message_text := 'EIN ID missing ';
503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
504: pay_core_utils.push_token('record_name',message_preprocess);
505: pay_core_utils.push_token('description',message_text);

Line 506: hr_utility.raise_error;

502: message_text := 'EIN ID missing ';
503: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
504: pay_core_utils.push_token('record_name',message_preprocess);
505: pay_core_utils.push_token('description',message_text);
506: hr_utility.raise_error;
507: ELSE
508: CLOSE c_tax_ein;
509: END IF;
510:

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

515: IF c_user_entity_id_of_bal%NOTFOUND THEN
516: CLOSE c_user_entity_id_of_bal;
517: l_package_error_status := 'Y';
518: /* message to user - Database item missing */
519: hr_utility.trace('Database item for balacne missing ');
520: message_text := '-Database item missing ';
521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
522: pay_core_utils.push_token('record_name',message_preprocess);
523: pay_core_utils.push_token('description',message_text);

Line 524: hr_utility.raise_error;

520: message_text := '-Database item missing ';
521: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
522: pay_core_utils.push_token('record_name',message_preprocess);
523: pay_core_utils.push_token('description',message_text);
524: hr_utility.raise_error;
525: ELSE
526: CLOSE c_user_entity_id_of_bal;
527: END IF;
528:

Line 538: hr_utility.raise_error;

534: message_text := 'Context_id value for tax_unit_id missing';
535: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
536: pay_core_utils.push_token('record_name',message_preprocess);
537: pay_core_utils.push_token('description',message_text);
538: hr_utility.raise_error;
539: ELSE
540: CLOSE c_context_tax_unit_id;
541: END IF;
542:

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

546: CLOSE c_context_jurisdiction;
547: /* message to User -- Unable to find to context_id for jurisdiction */
548:
549: message_text := 'Context_id value for jurisdiction missing';
550: hr_utility.trace('Contxt_id value for jurisdction_id missing');
551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
552: pay_core_utils.push_token('record_name',message_preprocess);
553: pay_core_utils.push_token('description',message_text);
554: hr_utility.raise_error;

Line 554: hr_utility.raise_error;

550: hr_utility.trace('Contxt_id value for jurisdction_id missing');
551: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
552: pay_core_utils.push_token('record_name',message_preprocess);
553: pay_core_utils.push_token('description',message_text);
554: hr_utility.raise_error;
555: ELSE
556: CLOSE c_context_jurisdiction;
557: eND IF;
558: /* Get the Tranmitter id of the Current Mag. W2. and check if it has

Line 570: hr_utility.raise_error;

566: message_text := 'Transmitter Not denfined';
567: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
568: pay_core_utils.push_token('record_name',message_preprocess);
569: pay_core_utils.push_token('description',message_text);
570: hr_utility.raise_error;
571: ELSE
572: CLOSE c_transmitter;
573: END IF;
574:

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

571: ELSE
572: CLOSE c_transmitter;
573: END IF;
574:
575: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
576: hr_utility.trace('Start date ' || to_char(p_year_start));
577: hr_utility.trace('End date ' || to_char(p_year_end));
578: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
579:

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

572: CLOSE c_transmitter;
573: END IF;
574:
575: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
576: hr_utility.trace('Start date ' || to_char(p_year_start));
577: hr_utility.trace('End date ' || to_char(p_year_end));
578: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
579:
580:

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

573: END IF;
574:
575: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
576: hr_utility.trace('Start date ' || to_char(p_year_start));
577: hr_utility.trace('End date ' || to_char(p_year_end));
578: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
579:
580:
581: /* Check if Archiver has been run for Transmitter */

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

574:
575: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
576: hr_utility.trace('Start date ' || to_char(p_year_start));
577: hr_utility.trace('End date ' || to_char(p_year_end));
578: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
579:
580:
581: /* Check if Archiver has been run for Transmitter */
582: OPEN c_gre_payroll_action (l_transmitter);

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

582: OPEN c_gre_payroll_action (l_transmitter);
583: FETCH c_gre_payroll_action INTO l_payroll_action_id;
584:
585: IF c_gre_payroll_action%NOTFOUND THEN
586: hr_utility.trace('Transmitter not Archvied ');
587: CLOSE c_gre_payroll_action;
588: /* message to user -- Transmitter has not been archived */
589: message_text := 'Transmitter not Archived';
590: hr_utility.trace('Transmitter has not been archived');

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

586: hr_utility.trace('Transmitter not Archvied ');
587: CLOSE c_gre_payroll_action;
588: /* message to user -- Transmitter has not been archived */
589: message_text := 'Transmitter not Archived';
590: hr_utility.trace('Transmitter has not been archived');
591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
592: pay_core_utils.push_token('record_name',message_preprocess);
593: pay_core_utils.push_token('description',message_text);
594: -- hr_utility.raise_error;

Line 594: -- hr_utility.raise_error;

590: hr_utility.trace('Transmitter has not been archived');
591: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
592: pay_core_utils.push_token('record_name',message_preprocess);
593: pay_core_utils.push_token('description',message_text);
594: -- hr_utility.raise_error;
595: END IF;
596: CLOSE c_gre_payroll_action;
597:
598: /* end of Transmitter Checking */

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

596: CLOSE c_gre_payroll_action;
597:
598: /* end of Transmitter Checking */
599:
600: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 10);
601:
602: FOR gre_rec IN c_get_gre LOOP
603: /* set l_gre to gre Fethched */
604:

Line 631: -- hr_utility.raise_error;

627: --Some of the assignments have Errored
628: l_package_error_status := 'Y';
629: /* message to user -- assignment has errored out */
630: --
631: -- hr_utility.raise_error;
632: END IF;
633: CLOSE c_arch_errored_asg;
634:
635: /* Checking for Retry */

Line 646: -- hr_utility.raise_error;

642: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
643: pay_core_utils.push_token('record_name',message_preprocess);
644: pay_core_utils.push_token('description',message_text);
645: l_package_error_status := 'Y';
646: -- hr_utility.raise_error;
647:
648: END IF;
649:
650: CLOSE c_arch_retry_pending;

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

648: END IF;
649:
650: CLOSE c_arch_retry_pending;
651:
652: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
653: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
654: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
655:
656: l_no_of_gres_picked := l_no_of_gres_picked + 1;

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

649:
650: CLOSE c_arch_retry_pending;
651:
652: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
653: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
654: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
655:
656: l_no_of_gres_picked := l_no_of_gres_picked + 1;
657: /* All the condition have been met so it is safe to make Arhive

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

650: CLOSE c_arch_retry_pending;
651:
652: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
653: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
654: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
655:
656: l_no_of_gres_picked := l_no_of_gres_picked + 1;
657: /* All the condition have been met so it is safe to make Arhive
658: Call

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

660:
661: IF p_report_type = 'FEDW2' THEN --federal W2
662: archive_eoy_data(l_payroll_action_id,l_gre);
663: ELSE
664: hr_utility.trace('Federal smart archive call');
665: archive_eoy_data(l_payroll_action_id,l_gre);
666: hr_utility.trace('State Code :- ' || p_state_code);
667: hr_utility.trace('GRE - ' || to_char(l_gre));
668: hr_utility.trace('Before calling Smart State Archive');

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

662: archive_eoy_data(l_payroll_action_id,l_gre);
663: ELSE
664: hr_utility.trace('Federal smart archive call');
665: archive_eoy_data(l_payroll_action_id,l_gre);
666: hr_utility.trace('State Code :- ' || p_state_code);
667: hr_utility.trace('GRE - ' || to_char(l_gre));
668: hr_utility.trace('Before calling Smart State Archive');
669: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
670: hr_utility.trace('After call to state Archive');

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

663: ELSE
664: hr_utility.trace('Federal smart archive call');
665: archive_eoy_data(l_payroll_action_id,l_gre);
666: hr_utility.trace('State Code :- ' || p_state_code);
667: hr_utility.trace('GRE - ' || to_char(l_gre));
668: hr_utility.trace('Before calling Smart State Archive');
669: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
670: hr_utility.trace('After call to state Archive');
671: END IF;

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

664: hr_utility.trace('Federal smart archive call');
665: archive_eoy_data(l_payroll_action_id,l_gre);
666: hr_utility.trace('State Code :- ' || p_state_code);
667: hr_utility.trace('GRE - ' || to_char(l_gre));
668: hr_utility.trace('Before calling Smart State Archive');
669: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
670: hr_utility.trace('After call to state Archive');
671: END IF;
672:

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

666: hr_utility.trace('State Code :- ' || p_state_code);
667: hr_utility.trace('GRE - ' || to_char(l_gre));
668: hr_utility.trace('Before calling Smart State Archive');
669: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
670: hr_utility.trace('After call to state Archive');
671: END IF;
672:
673: hr_utility.trace('After Call to smart Archive ');
674:

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

669: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
670: hr_utility.trace('After call to state Archive');
671: END IF;
672:
673: hr_utility.trace('After Call to smart Archive ');
674:
675: /* Check EIN for the Employee */
676:
677: IF p_report_type = 'FEDW2' THEN --federal W2

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

690: /* Check for State */
691: -- OPEN c_chk_archive_state_code (l_gre,l_payroll_action_id);
692: -- FETCH c_chk_archive_state_code INTO l_state_tax_rules_exist;
693: -- IF c_chk_archive_state_code%NOTFOUND THEN
694: -- hr_utility.trace('State Tax Rules not Found ');
695: -- /* state Tax Rules have not been Defined */
696: -- message_text := 'State Tax Rules not Defind for GRE '
697: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
698: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

704: -- close c_chk_archive_state_code;
705:
706: /* Do check_er_data only if Record exist */
707: /* Add those checks for current Year */
708: hr_utility.trace('Check the State ER data ');
709: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
710: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
711: /* EIN check Failed */
712: -- IF l_ein_result = 'N'THEN

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

706: /* Do check_er_data only if Record exist */
707: /* Add those checks for current Year */
708: hr_utility.trace('Check the State ER data ');
709: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
710: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
711: /* EIN check Failed */
712: -- IF l_ein_result = 'N'THEN
713: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
714: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);

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

709: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
710: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
711: /* EIN check Failed */
712: -- IF l_ein_result = 'N'THEN
713: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
714: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
715: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
716: -- pay_core_utils.push_token('record_name',message_preprocess);
717: -- pay_core_utils.push_token('description',message_text);

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

733:
734: /* Code commented to fix Bug # 3069840
735:
736: IF p_report_type = 'FEDW2' THEN --federal W2
737: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 99);
738: OPEN c_gre_fed(gre_rec.gre);
739: ELSIF p_report_type = 'STW2' THEN --state W2
740: OPEN c_gre_state(gre_rec.gre);
741: END IF;

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

747: -- Start feching Persons for GRE
748: FETCH c_gre_fed INTO l_person
749: ,l_assignment
750: ,l_asg_effective_dt;
751: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
752: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
753: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
754: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
755: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

748: FETCH c_gre_fed INTO l_person
749: ,l_assignment
750: ,l_asg_effective_dt;
751: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
752: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
753: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
754: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
755: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
756: IF c_gre_fed%NOTFOUND THEN

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

749: ,l_assignment
750: ,l_asg_effective_dt;
751: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
752: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
753: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
754: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
755: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
756: IF c_gre_fed%NOTFOUND THEN
757: -- get out of the Main Loop if You have reached No person Found

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

750: ,l_asg_effective_dt;
751: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
752: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
753: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
754: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
755: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
756: IF c_gre_fed%NOTFOUND THEN
757: -- get out of the Main Loop if You have reached No person Found
758: EXIT;

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

751: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
752: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
753: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
754: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
755: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
756: IF c_gre_fed%NOTFOUND THEN
757: -- get out of the Main Loop if You have reached No person Found
758: EXIT;
759: END IF;

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

763: FETCH c_gre_state INTO l_person
764: ,l_assignment
765: ,l_asg_effective_dt;
766:
767: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
768: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
769: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
770: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
771: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

764: ,l_assignment
765: ,l_asg_effective_dt;
766:
767: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
768: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
769: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
770: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
771: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
772: -- No Person Was found for the State So Exit

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

765: ,l_asg_effective_dt;
766:
767: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
768: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
769: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
770: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
771: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
772: -- No Person Was found for the State So Exit
773: IF c_gre_state%NOTFOUND THEN

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

766:
767: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
768: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
769: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
770: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
771: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
772: -- No Person Was found for the State So Exit
773: IF c_gre_state%NOTFOUND THEN
774: EXIT;

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

767: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
768: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
769: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
770: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
771: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
772: -- No Person Was found for the State So Exit
773: IF c_gre_state%NOTFOUND THEN
774: EXIT;
775: END IF;

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

775: END IF;
776: END IF; -- report type = 'STW2' and etc
777:
778:
779: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
780: hr_utility.trace('GRE - '||to_char(l_gre));
781:
782: -- get the balance for person
783:

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

776: END IF; -- report type = 'STW2' and etc
777:
778:
779: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
780: hr_utility.trace('GRE - '||to_char(l_gre));
781:
782: -- get the balance for person
783:
784: IF p_report_type = 'FEDW2' THEN

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

810: close c_gre_fed;
811: ELSE
812: close c_gre_state;
813: END IF; -- End Of Report_type 'FEDW2'
814: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
815: -- Person Found with Balance for given GRE
816: message_text := 'GRE_ID := ' || to_char(l_gre)
817: || ' has People with Balnace > 0';
818: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

852:
853: END LOOP; /* end of for statement */
854:
855: IF l_package_error_status = 'Y' THEN
856: hr_utility.trace('Error Condition Found');
857: message_text := 'Error Condition detected ' ;
858: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
859: pay_core_utils.push_token('record_name',message_preprocess);
860: pay_core_utils.push_token('description',message_text);

Line 866: hr_utility.raise_error;

862: message_text := 'Pay Message line and log have more Details' ;
863: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
864: pay_core_utils.push_token('record_name',message_preprocess);
865: pay_core_utils.push_token('description',message_text);
866: hr_utility.raise_error;
867: END IF;
868:
869: IF l_no_of_gres_picked = 0 THEN
870: --It means that no archived GRE was

Line 877: hr_utility.raise_error;

873: message_text := 'No GRE was picked for Magnetic Tape';
874: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
875: pay_core_utils.push_token('record_name',message_preprocess);
876: pay_core_utils.push_token('description',message_text);
877: hr_utility.raise_error;
878: END IF;
879:
880: RETURN TRUE;
881: hr_utility.trace('Succesful - Return True ');

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

877: hr_utility.raise_error;
878: END IF;
879:
880: RETURN TRUE;
881: hr_utility.trace('Succesful - Return True ');
882: exception
883: when others then
884: -- add message for this
885: message_text := message_text || '+ Exception';

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

882: exception
883: when others then
884: -- add message for this
885: message_text := message_text || '+ Exception';
886: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
887: hr_utility.set_message_token('MESSAGE', message_text);
888: hr_utility.raise_error;
889:
890: END preprocess_check;

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

883: when others then
884: -- add message for this
885: message_text := message_text || '+ Exception';
886: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
887: hr_utility.set_message_token('MESSAGE', message_text);
888: hr_utility.raise_error;
889:
890: END preprocess_check;
891: --

Line 888: hr_utility.raise_error;

884: -- add message for this
885: message_text := message_text || '+ Exception';
886: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
887: hr_utility.set_message_token('MESSAGE', message_text);
888: hr_utility.raise_error;
889:
890: END preprocess_check;
891: --
892: ----------------------------------------------------------------------------

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

919: p_state_code VARCHAR2(2);
920: p_report_type VARCHAR2(30);
921: BEGIN
922:
923: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 10);
924: get_report_parameters(
925: p_pactid,
926: p_year_start,
927: p_year_end,

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

929: p_state_code,
930: p_report_type,
931: p_business_group_id
932: );
933: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 20);
934: IF preprocess_check(p_pactid,
935: p_year_start,
936: p_year_end,
937: p_business_group_id,

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

968: and hoi.org_information_context =
969: ''1099R Magnetic Report Rules'')
970: ORDER BY paf.person_id
971: ';
972: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
973: 30);
974: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'IN' THEN
975: p_sqlstr := 'SELECT DISTINCT '||
976: 'to_number(paa.serial_number) '||

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

1036: 'and hoi.org_information_context = '||
1037: '''1099R Magnetic Report Rules'' '||
1038: ') '||
1039: 'order by to_number(paa.serial_number)';
1040: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1041: 40);
1042: ELSIF p_report_type = 'STW2' and p_state_abbrev = 'OH' THEN
1043: p_sqlstr := 'SELECT DISTINCT '||
1044: 'to_number(paa.serial_number) '||

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

1104: 'and hoi.org_information_context = '||
1105: '''1099R Magnetic Report Rules'' '||
1106: ') '||
1107: 'order by to_number(paa.serial_number)';
1108: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1109: 40);
1110:
1111: ELSIF p_report_type = 'STW2' THEN
1112: p_sqlstr := '

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

1154: and hoi.org_information_context =
1155: ''1099R Magnetic Report Rules''
1156: )
1157: order by to_number(paa.serial_number)';
1158: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
1159: 40);
1160: END IF;
1161: END IF;
1162: END range_cursor;

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

1917: l_gre_id := -1;
1918: l_error_flag := 'N';
1919:
1920: -- Get the report parameters. These define the report being run.
1921: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1922: 10);
1923: get_report_parameters(
1924: p_pactid,
1925: l_year_start,

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

1934: close csr_action_parameter;
1935: --Currently all reports group by GRE
1936: l_group_by_gre := TRUE;
1937: --Open the appropriate cursor
1938: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1939: 20);
1940: IF l_report_type = 'FEDW2' THEN
1941: if g_action_param_val='Y' then
1942: OPEN c_federal_range;

Line 1991: hr_utility.set_location(

1987: l_tax_unit_id,
1988: l_effective_end_date,
1989: l_assignment_action_id;
1990: end if;
1991: hr_utility.set_location(
1992: 'pay_us_mmref_reporting.create_assignement_act', 30);
1993: if g_action_param_val='Y' then
1994: EXIT WHEN c_federal_range%NOTFOUND;
1995: else

Line 2014: hr_utility.set_location(

2010: l_effective_end_date,
2011: l_assignment_action_id,
2012: l_w2_box17;
2013: end if;
2014: hr_utility.set_location(
2015: 'pay_us_mmref_reporting.create_assignement_act', 40);
2016: if g_action_param_val='Y' then
2017: EXIT WHEN c_pr_state_range%NOTFOUND;
2018: else

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

2022: -- Set the Error Flag to Y so that Action Creation will Error
2023: -- At the End
2024:
2025: IF l_gre_id = l_tax_unit_id THEN
2026: hr_utility.trace('Same GRE ');
2027: ELSE
2028: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2029: hr_utility.trace('State Tax Rules Missing in GRE');
2030: l_gre_id := l_tax_unit_id;

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

2025: IF l_gre_id = l_tax_unit_id THEN
2026: hr_utility.trace('Same GRE ');
2027: ELSE
2028: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2029: hr_utility.trace('State Tax Rules Missing in GRE');
2030: l_gre_id := l_tax_unit_id;
2031: l_error_flag := 'Y';
2032: ELSE
2033: l_gre_id := l_tax_unit_id;

Line 2053: hr_utility.set_location(

2049: l_effective_end_date,
2050: l_assignment_action_id,
2051: l_w2_box17;
2052: end if;
2053: hr_utility.set_location(
2054: 'pay_us_mmref_reporting.create_assignement_act', 40);
2055: if g_action_param_val='Y' then
2056: EXIT WHEN c_state_indiana_range%NOTFOUND;
2057: else

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

2061: -- Set the Error Flag to Y so that Action Creation will Error
2062: -- At the End
2063:
2064: IF l_gre_id = l_tax_unit_id THEN
2065: hr_utility.trace('Same GRE ');
2066: ELSE
2067: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2068: hr_utility.trace('State Tax Rules Missing in GRE');
2069: l_gre_id := l_tax_unit_id;

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

2064: IF l_gre_id = l_tax_unit_id THEN
2065: hr_utility.trace('Same GRE ');
2066: ELSE
2067: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2068: hr_utility.trace('State Tax Rules Missing in GRE');
2069: l_gre_id := l_tax_unit_id;
2070: l_error_flag := 'Y';
2071: ELSE
2072: l_gre_id := l_tax_unit_id;

Line 2093: hr_utility.set_location(

2089: l_effective_end_date,
2090: l_assignment_action_id,
2091: l_w2_box17;
2092: end if;
2093: hr_utility.set_location(
2094: 'pay_us_mmref_reporting.create_assignement_act', 40);
2095: if g_action_param_val='Y' then
2096: EXIT WHEN c_state_ohio_range%NOTFOUND;
2097: else

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

2101: -- Set the Error Flag to Y so that Action Creation will Error
2102: -- At the End
2103:
2104: IF l_gre_id = l_tax_unit_id THEN
2105: hr_utility.trace('Same GRE ');
2106: ELSE
2107: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2108: hr_utility.trace('State Tax Rules Missing in GRE');
2109: l_gre_id := l_tax_unit_id;

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

2104: IF l_gre_id = l_tax_unit_id THEN
2105: hr_utility.trace('Same GRE ');
2106: ELSE
2107: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2108: hr_utility.trace('State Tax Rules Missing in GRE');
2109: l_gre_id := l_tax_unit_id;
2110: l_error_flag := 'Y';
2111: ELSE
2112: l_gre_id := l_tax_unit_id;

Line 2132: hr_utility.set_location(

2128: l_effective_end_date,
2129: l_assignment_action_id,
2130: l_w2_box17;
2131: end if;
2132: hr_utility.set_location(
2133: 'pay_us_mmref_reporting.create_assignement_act', 40);
2134: if g_action_param_val='Y' then
2135: EXIT WHEN c_state_range%NOTFOUND;
2136: else

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

2140: -- Set the Error Flag to Y so that Action Creation will Error
2141: -- At the End
2142:
2143: IF l_gre_id = l_tax_unit_id THEN
2144: hr_utility.trace('Same GRE ');
2145: ELSE
2146: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2147: hr_utility.trace('State Tax Rules Missing in GRE');
2148: l_gre_id := l_tax_unit_id;

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

2143: IF l_gre_id = l_tax_unit_id THEN
2144: hr_utility.trace('Same GRE ');
2145: ELSE
2146: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
2147: hr_utility.trace('State Tax Rules Missing in GRE');
2148: l_gre_id := l_tax_unit_id;
2149: l_error_flag := 'Y';
2150: ELSE
2151: l_gre_id := l_tax_unit_id;

Line 2167: hr_utility.set_location(

2163: l_tax_unit_id = l_prev_tax_unit_id) OR
2164: (NOT l_group_by_gre AND
2165: l_person_id = l_prev_person_id)) THEN
2166: --Do Nothing
2167: hr_utility.set_location(
2168: 'pay_us_mmref_reporting.create_assignement_act', 50);
2169: NULL;
2170: ELSE
2171: --Create the assignment action for the record

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

2168: 'pay_us_mmref_reporting.create_assignement_act', 50);
2169: NULL;
2170: ELSE
2171: --Create the assignment action for the record
2172: hr_utility.trace('Assignment Fetched - ');
2173: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
2174: hr_utility.trace('Person Id : '|| to_char(l_person_id));
2175: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
2176: hr_utility.trace('Effective End Date : '||

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

2169: NULL;
2170: ELSE
2171: --Create the assignment action for the record
2172: hr_utility.trace('Assignment Fetched - ');
2173: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
2174: hr_utility.trace('Person Id : '|| to_char(l_person_id));
2175: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
2176: hr_utility.trace('Effective End Date : '||
2177: to_char(l_effective_end_date));

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

2170: ELSE
2171: --Create the assignment action for the record
2172: hr_utility.trace('Assignment Fetched - ');
2173: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
2174: hr_utility.trace('Person Id : '|| to_char(l_person_id));
2175: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
2176: hr_utility.trace('Effective End Date : '||
2177: to_char(l_effective_end_date));
2178:

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

2171: --Create the assignment action for the record
2172: hr_utility.trace('Assignment Fetched - ');
2173: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
2174: hr_utility.trace('Person Id : '|| to_char(l_person_id));
2175: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
2176: hr_utility.trace('Effective End Date : '||
2177: to_char(l_effective_end_date));
2178:
2179: IF l_report_type = 'FEDW2' then

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

2172: hr_utility.trace('Assignment Fetched - ');
2173: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
2174: hr_utility.trace('Person Id : '|| to_char(l_person_id));
2175: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
2176: hr_utility.trace('Effective End Date : '||
2177: to_char(l_effective_end_date));
2178:
2179: IF l_report_type = 'FEDW2' then
2180:

Line 2263: hr_utility.set_location(

2259: (l_report_type = 'STW2') then
2260: SELECT pay_assignment_actions_s.nextval
2261: INTO lockingactid
2262: FROM dual;
2263: hr_utility.set_location(
2264: 'pay_us_mmref_reporting.create_assignement_act', 60);
2265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
2266: p_chunk, l_tax_unit_id);
2267: hr_utility.set_location(

Line 2267: hr_utility.set_location(

2263: hr_utility.set_location(
2264: 'pay_us_mmref_reporting.create_assignement_act', 60);
2265: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
2266: p_chunk, l_tax_unit_id);
2267: hr_utility.set_location(
2268: 'pay_us_mmref_reporting.create_assignement_act', 70);
2269: --update serial number for highly compensated people for the
2270: --state W2.
2271: /*IF l_report_type = 'STW2' THEN

Line 2272: hr_utility.set_location(

2268: 'pay_us_mmref_reporting.create_assignement_act', 70);
2269: --update serial number for highly compensated people for the
2270: --state W2.
2271: /*IF l_report_type = 'STW2' THEN
2272: hr_utility.set_location(
2273: 'pay_us_mmref_reporting.create_assignement_act', 80);
2274: IF l_w2_box17 > 9999999.99 THEN
2275: UPDATE pay_assignment_actions
2276: SET serial_number = 999999

Line 2281: hr_utility.set_location(

2277: WHERE assignment_action_id = lockingactid;
2278: END IF;
2279: END IF;*/ -- 4490252
2280: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
2281: hr_utility.set_location(
2282: 'pay_us_mmref_reporting.create_assignement_act', 90);
2283: hr_utility.trace('Interlock Created - ');
2284: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
2285: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

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

2279: END IF;*/ -- 4490252
2280: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
2281: hr_utility.set_location(
2282: 'pay_us_mmref_reporting.create_assignement_act', 90);
2283: hr_utility.trace('Interlock Created - ');
2284: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
2285: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
2286: --Store the current person/GRE for comparision during the
2287: --next iteration.

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

2280: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
2281: hr_utility.set_location(
2282: 'pay_us_mmref_reporting.create_assignement_act', 90);
2283: hr_utility.trace('Interlock Created - ');
2284: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
2285: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
2286: --Store the current person/GRE for comparision during the
2287: --next iteration.
2288: l_prev_person_id := l_person_id;

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

2281: hr_utility.set_location(
2282: 'pay_us_mmref_reporting.create_assignement_act', 90);
2283: hr_utility.trace('Interlock Created - ');
2284: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
2285: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
2286: --Store the current person/GRE for comparision during the
2287: --next iteration.
2288: l_prev_person_id := l_person_id;
2289: l_prev_tax_unit_id := l_tax_unit_id;

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

2323: end if;
2324: END IF;
2325:
2326: IF l_error_flag = 'Y' THEN
2327: hr_utility.trace('Error Flag was set to Y');
2328: hr_utility.raise_error;
2329: END IF;
2330:
2331: END create_assignment_act;

Line 2328: hr_utility.raise_error;

2324: END IF;
2325:
2326: IF l_error_flag = 'Y' THEN
2327: hr_utility.trace('Error Flag was set to Y');
2328: hr_utility.raise_error;
2329: END IF;
2330:
2331: END create_assignment_act;
2332:

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

2474: IS
2475: BEGIN
2476: /* get the Parameter Setting */
2477:
2478: hr_utility.trace('Calling the state archiving ');
2479: hr_utility.trace('Pactid ' || to_char(p_pactid));
2480: hr_utility.trace('tax id ' || to_char(p_tax_id));
2481: hr_utility.trace('Pactid ' || p_state_code);
2482:

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

2475: BEGIN
2476: /* get the Parameter Setting */
2477:
2478: hr_utility.trace('Calling the state archiving ');
2479: hr_utility.trace('Pactid ' || to_char(p_pactid));
2480: hr_utility.trace('tax id ' || to_char(p_tax_id));
2481: hr_utility.trace('Pactid ' || p_state_code);
2482:
2483: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);

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

2476: /* get the Parameter Setting */
2477:
2478: hr_utility.trace('Calling the state archiving ');
2479: hr_utility.trace('Pactid ' || to_char(p_pactid));
2480: hr_utility.trace('tax id ' || to_char(p_tax_id));
2481: hr_utility.trace('Pactid ' || p_state_code);
2482:
2483: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
2484:

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

2477:
2478: hr_utility.trace('Calling the state archiving ');
2479: hr_utility.trace('Pactid ' || to_char(p_pactid));
2480: hr_utility.trace('tax id ' || to_char(p_tax_id));
2481: hr_utility.trace('Pactid ' || p_state_code);
2482:
2483: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
2484:
2485: END ARCHIVE_STATE_EOY_DATA;

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

2572: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
2573: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2574: pay_core_utils.push_token('record_name',l_message_preprocess);
2575: pay_core_utils.push_token('description',l_message_text);
2576: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2577: l_control_num_flag := 'N';
2578: else
2579: if (l_control_number is NULL or l_control_number = 0) then
2580: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';

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

2577: l_control_num_flag := 'N';
2578: else
2579: if (l_control_number is NULL or l_control_number = 0) then
2580: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
2581: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2583: pay_core_utils.push_token('record_name',l_message_preprocess);
2584: pay_core_utils.push_token('description',l_message_text);
2585: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

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

2581: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2582: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2583: pay_core_utils.push_token('record_name',l_message_preprocess);
2584: pay_core_utils.push_token('description',l_message_text);
2585: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2586: l_control_num_flag := 'N';
2587: end if;
2588: end if;
2589: close c_get_pr_control_num;

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

2591: open c_sit_check(C1.payroll_action,c1.unit_id,l_w2_state);
2592: l_message_preprocess := 'GRE: ' ||substr(c1.name,1,220) || ' has ' ; --Modified for the Bug 14223392
2593: fetch c_sit_check INTO l_info ;
2594: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
2595: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
2596: if c_sit_check%notfound then
2597: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2599: pay_core_utils.push_token('record_name',l_message_preprocess);

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

2597: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
2598: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2599: pay_core_utils.push_token('record_name',l_message_preprocess);
2600: pay_core_utils.push_token('description',l_message_text);
2601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2602: l_flag := 'N';
2603: close c_sit_check;
2604: else
2605: if l_info IS NULL THEN

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

2604: else
2605: if l_info IS NULL THEN
2606: l_flag := 'N';
2607: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
2608: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
2609: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2610: pay_core_utils.push_token('record_name',l_message_preprocess);
2611: pay_core_utils.push_token('description',l_message_text);
2612: end if ;

Line 2621: hr_utility.raise_error;

2617: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2619: pay_core_utils.push_token('record_name',l_message_preprocess);
2620: pay_core_utils.push_token('description',l_message_text);
2621: hr_utility.raise_error;
2622: return 'N';
2623: END IF;
2624: return 'Y';
2625: EXCEPTION

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

2629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
2630: pay_core_utils.push_token('record_name',l_message_preprocess);
2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2634: hr_utility.set_message_token('MESSAGE', u_message_text);
2635: hr_utility.raise_error;
2636: return 'Y';
2637: END check_state_data;

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

2630: pay_core_utils.push_token('record_name',l_message_preprocess);
2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2634: hr_utility.set_message_token('MESSAGE', u_message_text);
2635: hr_utility.raise_error;
2636: return 'Y';
2637: END check_state_data;
2638:

Line 2635: hr_utility.raise_error;

2631: pay_core_utils.push_token('description',l_message_text);
2632: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
2633: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
2634: hr_utility.set_message_token('MESSAGE', u_message_text);
2635: hr_utility.raise_error;
2636: return 'Y';
2637: END check_state_data;
2638:
2639: -- ----------------------------------------------------------------------------

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

2693: );
2694:
2695: BEGIN
2696: --
2697: hr_utility.set_location('Entering:'||l_proc, 10);
2698: --
2699:
2700:
2701: -- Get the user entity id for A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER

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

2778: AND fai.value = 'Y'
2779: );
2780: BEGIN
2781: --
2782: hr_utility.set_location('Entering: ' || l_proc, 10);
2783: --
2784: -- Get the user entity id for A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER
2785:
2786: FOR c_rec IN c_get_user_entity_id

Line 2810: --raise hr_utility.hr_error;

2806: RETURN varchar2 IS
2807: BEGIN
2808: IF p_state = 'FED' and p_error = 'Y'
2809: THEN
2810: --raise hr_utility.hr_error;
2811: update pay_assignment_actions
2812: set SERIAL_NUMBER = 'E999999999'
2813: where assignment_action_id = p_assignment_action_id;
2814: return 'Y';

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

2852: l_payroll_action_id NUMBER;
2853: l_tax_jurisdiction_code VARCHAR2(200);
2854:
2855: BEGIN
2856: hr_utility.trace('In Procedure PAY_US_MMREF_REPORTING.GET_TAX_UNIT_INFO' );
2857: OPEN c_get_tax_unit_info(tax_unit_id,
2858: p_tax_year);
2859: FETCH c_get_tax_unit_info INTO l_federal_EIN,
2860: l_tax_unit_name;

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

2875: 'A_LC_W2_REPORTING_RULES_ORG_TAX_JURISDICTION');
2876: END IF;
2877: p_tax_jd_code := l_tax_jurisdiction_code;
2878: END;
2879: hr_utility.trace('Federal EIN '||l_federal_EIN );
2880: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2881: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2882: return l_tax_unit_name;
2883: EXCEPTION

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

2876: END IF;
2877: p_tax_jd_code := l_tax_jurisdiction_code;
2878: END;
2879: hr_utility.trace('Federal EIN '||l_federal_EIN );
2880: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2881: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2882: return l_tax_unit_name;
2883: EXCEPTION
2884: WHEN OTHERS THEN

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

2877: p_tax_jd_code := l_tax_jurisdiction_code;
2878: END;
2879: hr_utility.trace('Federal EIN '||l_federal_EIN );
2880: hr_utility.trace('Tax Unit Name '|| l_tax_unit_name);
2881: hr_utility.trace('Tax Jurisdiction Code '|| l_tax_jurisdiction_code);
2882: return l_tax_unit_name;
2883: EXCEPTION
2884: WHEN OTHERS THEN
2885: l_tax_unit_name := ' ';

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

3217: l_a73 number := 0;
3218: --l_a22 number := 0; /* 7109106 */
3219: l_direct_fed_bal_call varchar2(2) := 'N';
3220: BEGIN
3221: -- hr_utility.trace_on(NULL,'FEDW2MT');
3222: hr_utility.trace('In Procedure GET_W2_ER_ARCH_BAL' );
3223:
3224: a1 := '0';
3225: a2 := '0';

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

3218: --l_a22 number := 0; /* 7109106 */
3219: l_direct_fed_bal_call varchar2(2) := 'N';
3220: BEGIN
3221: -- hr_utility.trace_on(NULL,'FEDW2MT');
3222: hr_utility.trace('In Procedure GET_W2_ER_ARCH_BAL' );
3223:
3224: a1 := '0';
3225: a2 := '0';
3226: a3 := '0';

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

3414: IF i.user_entity_name = 'A_W2_NONQUAL_457_PER_GRE_YTD' THEN
3415: l_a70 := i.val;
3416: END IF;
3417:
3418: hr_utility.trace('UE Name : '|| i.user_entity_name || ' SumValue '|| to_char( i.val));
3419: END LOOP;
3420: /*
3421: a2 := to_char(round(l_a2, 2) * 100);
3422: a20 := to_char(round(l_a20, 2) * 100);

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

3464: -- a22 := a22 - l_a22 ; /* 7109106 */
3465: a39 := to_char(round(l_a39, 2) * 100 ) ;
3466: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
3467:
3468: hr_utility.trace('Value of a1 : '||a1 );
3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );

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

3465: a39 := to_char(round(l_a39, 2) * 100 ) ;
3466: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
3467:
3468: hr_utility.trace('Value of a1 : '||a1 );
3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );

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

3466: a41 := to_char(trunc( (l_a39 - l_a37 - l_a35 - l_a36 ) * 100));
3467:
3468: hr_utility.trace('Value of a1 : '||a1 );
3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );

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

3467:
3468: hr_utility.trace('Value of a1 : '||a1 );
3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );

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

3468: hr_utility.trace('Value of a1 : '||a1 );
3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );

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

3469: hr_utility.trace('Value of a2 : '||a2);
3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );

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

3470: hr_utility.trace('Value of a3 : '||a3 );
3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );

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

3471: hr_utility.trace('Value of a4 : '||a4 );
3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );

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

3472: hr_utility.trace('Value of a5 : '||a5 );
3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );

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

3473: hr_utility.trace('Value of a6 : '||a6 );
3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );

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

3474: hr_utility.trace('Value of a7 : '||a7 );
3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );

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

3475: hr_utility.trace('Value of a8 : '||a8 );
3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );

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

3476: hr_utility.trace('Value of a9 : '||a9 );
3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );

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

3477: hr_utility.trace('Value of a10 : '||a10 );
3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );

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

3478: hr_utility.trace('Value of a11 : '||a11 );
3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );

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

3479: hr_utility.trace('Value of a12 : '||a12 );
3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );

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

3480: hr_utility.trace('Value of a13 : '||a13 );
3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );

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

3481: hr_utility.trace('Value of a14 : '||a14 );
3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );

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

3482: hr_utility.trace('Value of a15 : '||a15 );
3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );

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

3483: hr_utility.trace('Value of a16 : '||a16 );
3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );

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

3484: hr_utility.trace('Value of a17 : '||a17 );
3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );

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

3485: hr_utility.trace('Value of a18 : '||a18 );
3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );

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

3486: hr_utility.trace('Value of a19 : '||a19 );
3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );

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

3487: hr_utility.trace('Value of a20 : '||a20 );
3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );

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

3488: hr_utility.trace('Value of a21 : '||a21 );
3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );

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

3489: hr_utility.trace('Value of a22 : '||a22 );
3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );

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

3490: hr_utility.trace('Value of a23 : '||a23 );
3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );

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

3491: hr_utility.trace('Value of a24 : '||a24 );
3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );

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

3492: hr_utility.trace('Value of a25 : '||a25 );
3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );

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

3493: hr_utility.trace('Value of a26 : '||a26 );
3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );

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

3494: hr_utility.trace('Value of a27 : '||a27 );
3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );

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

3495: hr_utility.trace('Value of a28 : '||a28 );
3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );

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

3496: hr_utility.trace('Value of a29 : '||a29 );
3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );

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

3497: hr_utility.trace('Value of a30 : '||a30 );
3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );

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

3498: hr_utility.trace('Value of a31 : '||a31 );
3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );

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

3499: hr_utility.trace('Value of a32 : '||a32 );
3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );

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

3500: hr_utility.trace('Value of a33 : '||a33 );
3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );

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

3501: hr_utility.trace('Value of a34 : '||a34 );
3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );

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

3502: hr_utility.trace('Value of a35 : '||a35 );
3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );

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

3503: hr_utility.trace('Value of a36 : '||a36 );
3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );

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

3504: hr_utility.trace('Value of a37 : '||a37 );
3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );

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

3505: hr_utility.trace('Value of a38 : '||a38 );
3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );

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

3506: hr_utility.trace('Value of a39 : '||a39 );
3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );

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

3507: hr_utility.trace('Value of a40 : '||a40 );
3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022

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

3508: hr_utility.trace('Value of a41 : '||a41 );
3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022

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

3509: hr_utility.trace('Value of a42 : '||a42 );
3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));

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

3510: hr_utility.trace('Value of a43 : '||a43 );
3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));

Line 3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022

3511: hr_utility.trace('Value of a44 : '||a44 );
3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));
3519: hr_utility.trace('Value of a73 : '||to_char(l_a73));

Line 3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022

3512: hr_utility.trace('Value of a45 : '||a45 );
3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));
3519: hr_utility.trace('Value of a73 : '||to_char(l_a73));
3520:

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

3513: hr_utility.trace('Value of a46 : '||a46 );
3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));
3519: hr_utility.trace('Value of a73 : '||to_char(l_a73));
3520:
3521: return '0' ;

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

3514: hr_utility.trace('Value of a47 : '||a47 );
3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));
3519: hr_utility.trace('Value of a73 : '||to_char(l_a73));
3520:
3521: return '0' ;
3522: END get_w2_er_arch_bal;

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

3515: hr_utility.trace('Value of a48 : '||a48 ); --Bug 13497022
3516: hr_utility.trace('Value of a49 : '||a49 ); --Bug 13497022
3517: hr_utility.trace('Value of a71 : '||to_char(l_a71));
3518: hr_utility.trace('Value of a72 : '||to_char(l_a72));
3519: hr_utility.trace('Value of a73 : '||to_char(l_a73));
3520:
3521: return '0' ;
3522: END get_w2_er_arch_bal;
3523:

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

3521: return '0' ;
3522: END get_w2_er_arch_bal;
3523:
3524: --BEGIN
3525: -- hr_utility.trace_on(NULL,'FEDW2MT');
3526: END pay_us_mmref_reporting;