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

Line 48: hr_utility.set_location

44: AND UE.creator_type = 'B'
45: AND UE.legislation_code = 'US'; /* Bug:2296797 */
46: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
47: BEGIN
48: hr_utility.set_location
49: ('pay_us_mmref_reporting_mt.bal_db_item - opening cursor', 10);
50: -- Open the cursor
51: OPEN csr_defined_balance;
52: -- Fetch the value

Line 57: hr_utility.set_location

53: FETCH csr_defined_balance
54: INTO l_defined_balance_id;
55: IF csr_defined_balance%NOTFOUND THEN
56: CLOSE csr_defined_balance;
57: hr_utility.set_location
58: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
59: hr_utility.raise_error;
60: ELSE
61: hr_utility.set_location

Line 59: hr_utility.raise_error;

55: IF csr_defined_balance%NOTFOUND THEN
56: CLOSE csr_defined_balance;
57: hr_utility.set_location
58: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
59: hr_utility.raise_error;
60: ELSE
61: hr_utility.set_location
62: ('pay_us_mmref_reporting_mt.bal_db_item - fetched from cursor', 30);
63: CLOSE csr_defined_balance;

Line 61: hr_utility.set_location

57: hr_utility.set_location
58: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
59: hr_utility.raise_error;
60: ELSE
61: hr_utility.set_location
62: ('pay_us_mmref_reporting_mt.bal_db_item - fetched from cursor', 30);
63: CLOSE csr_defined_balance;
64: END IF;
65: /* Return the value to the call */

Line 98: hr_utility.set_location

94: p_report_type IN OUT nocopy VARCHAR2,
95: p_business_group_id IN OUT nocopy NUMBER
96: ) IS
97: BEGIN
98: hr_utility.set_location
99: ('pay_us_mmref_reporting_mt.get_report_parameters', 10);
100: SELECT ppa.start_date,
101: ppa.effective_date,
102: ppa.business_group_id,

Line 117: hr_utility.set_location

113: SELECT state_code
114: INTO p_state_code
115: FROM pay_us_states
116: WHERE state_abbrev = p_state_abbrev;
117: hr_utility.set_location
118: ('pay_us_mmref_reporting_mt.get_report_parameters', 20);
119: ELSE
120: p_state_code := '';
121: hr_utility.set_location

Line 121: hr_utility.set_location

117: hr_utility.set_location
118: ('pay_us_mmref_reporting_mt.get_report_parameters', 20);
119: ELSE
120: p_state_code := '';
121: hr_utility.set_location
122: ('pay_us_mmref_reporting_mt.get_report_parameters', 30);
123: END IF;
124: IF p_state_abbrev = 'FED' AND p_report_type = 'W2' THEN
125: p_report_type := 'FEDW2';

Line 129: hr_utility.set_location

125: p_report_type := 'FEDW2';
126: ELSIF p_report_type = 'W2' THEN
127: p_report_type := 'STW2';
128: END IF;
129: hr_utility.set_location
130: ('pay_us_mmref_reporting_mt.get_report_parameters', 40);
131: END get_report_parameters;
132: -------------------------------------------------------------------------
133: -- Name : get_balance_value

Line 157: hr_utility.set_location

153: p_effective_date DATE
154: ) RETURN NUMBER IS
155: l_jurisdiction_code VARCHAR2(20);
156: BEGIN
157: hr_utility.set_location
158: ('pay_us_mmref_reporting_mt.get_balance_value', 10);
159: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
160: IF p_state_abbrev <> 'FED' THEN
161: SELECT jurisdiction_code

Line 165: hr_utility.set_location

161: SELECT jurisdiction_code
162: INTO l_jurisdiction_code
163: FROM pay_state_rules
164: WHERE state_code = p_state_abbrev;
165: hr_utility.set_location
166: ('pay_us_mmref_reporting_mt.get_balance_value', 15);
167: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
168: END IF;
169: hr_utility.trace(p_balance_name);

Line 169: hr_utility.trace(p_balance_name);

165: hr_utility.set_location
166: ('pay_us_mmref_reporting_mt.get_balance_value', 15);
167: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
168: END IF;
169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location

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

166: ('pay_us_mmref_reporting_mt.get_balance_value', 15);
167: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
168: END IF;
169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location
174: ('pay_us_mmref_reporting_mt.get_balance_value', 20);

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

167: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
168: END IF;
169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location
174: ('pay_us_mmref_reporting_mt.get_balance_value', 20);
175: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

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

168: END IF;
169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location
174: ('pay_us_mmref_reporting_mt.get_balance_value', 20);
175: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
176: p_assignment_id, p_effective_date);

Line 173: hr_utility.set_location

169: hr_utility.trace(p_balance_name);
170: hr_utility.trace('Context');
171: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
172: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
173: hr_utility.set_location
174: ('pay_us_mmref_reporting_mt.get_balance_value', 20);
175: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
176: p_assignment_id, p_effective_date);
177: END get_balance_value;

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

380: FETCH c_tax_ein INTO l_ein;
381: IF c_tax_ein%NOTFOUND THEN
382: CLOSE c_tax_ein;
383: l_package_error_status := 'Y';
384: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
385: message_text := 'EIN ID missing ';
386: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
387: pay_core_utils.push_token('record_name',message_preprocess);
388: pay_core_utils.push_token('description',message_text);

Line 389: hr_utility.raise_error;

385: message_text := 'EIN ID missing ';
386: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
387: pay_core_utils.push_token('record_name',message_preprocess);
388: pay_core_utils.push_token('description',message_text);
389: hr_utility.raise_error;
390: ELSE
391: CLOSE c_tax_ein;
392: END IF;
393:

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

398: IF c_user_entity_id_of_bal%NOTFOUND THEN
399: CLOSE c_user_entity_id_of_bal;
400: l_package_error_status := 'Y';
401: /* message to user - Database item missing */
402: hr_utility.trace('Database item for balacne missing ');
403: message_text := '-Database item missing ';
404: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
405: pay_core_utils.push_token('record_name',message_preprocess);
406: pay_core_utils.push_token('description',message_text);

Line 407: hr_utility.raise_error;

403: message_text := '-Database item missing ';
404: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
405: pay_core_utils.push_token('record_name',message_preprocess);
406: pay_core_utils.push_token('description',message_text);
407: hr_utility.raise_error;
408: ELSE
409: CLOSE c_user_entity_id_of_bal;
410: END IF;
411:

Line 421: hr_utility.raise_error;

417: message_text := 'Context_id value for tax_unit_id missing';
418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
419: pay_core_utils.push_token('record_name',message_preprocess);
420: pay_core_utils.push_token('description',message_text);
421: hr_utility.raise_error;
422: ELSE
423: CLOSE c_context_tax_unit_id;
424: END IF;
425:

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

429: CLOSE c_context_jurisdiction;
430: /* message to User -- Unable to find to context_id for jurisdiction */
431:
432: message_text := 'Context_id value for jurisdiction missing';
433: hr_utility.trace('Contxt_id value for jurisdction_id missing');
434: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
435: pay_core_utils.push_token('record_name',message_preprocess);
436: pay_core_utils.push_token('description',message_text);
437: hr_utility.raise_error;

Line 437: hr_utility.raise_error;

433: hr_utility.trace('Contxt_id value for jurisdction_id missing');
434: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
435: pay_core_utils.push_token('record_name',message_preprocess);
436: pay_core_utils.push_token('description',message_text);
437: hr_utility.raise_error;
438: ELSE
439: CLOSE c_context_jurisdiction;
440: eND IF;
441: /* Get the Tranmitter id of the Current Mag. W2. and check if it has

Line 453: hr_utility.raise_error;

449: message_text := 'Transmitter Not denfined';
450: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
451: pay_core_utils.push_token('record_name',message_preprocess);
452: pay_core_utils.push_token('description',message_text);
453: hr_utility.raise_error;
454: ELSE
455: CLOSE c_transmitter;
456: END IF;
457:

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

454: ELSE
455: CLOSE c_transmitter;
456: END IF;
457:
458: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
459: hr_utility.trace('Start date ' || to_char(p_year_start));
460: hr_utility.trace('End date ' || to_char(p_year_end));
461: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
462:

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

455: CLOSE c_transmitter;
456: END IF;
457:
458: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
459: hr_utility.trace('Start date ' || to_char(p_year_start));
460: hr_utility.trace('End date ' || to_char(p_year_end));
461: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
462:
463:

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

456: END IF;
457:
458: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
459: hr_utility.trace('Start date ' || to_char(p_year_start));
460: hr_utility.trace('End date ' || to_char(p_year_end));
461: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
462:
463:
464: /* Check if Archiver has been run for Transmitter */

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

457:
458: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
459: hr_utility.trace('Start date ' || to_char(p_year_start));
460: hr_utility.trace('End date ' || to_char(p_year_end));
461: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
462:
463:
464: /* Check if Archiver has been run for Transmitter */
465: OPEN c_gre_payroll_action (l_transmitter);

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

465: OPEN c_gre_payroll_action (l_transmitter);
466: FETCH c_gre_payroll_action INTO l_payroll_action_id;
467:
468: IF c_gre_payroll_action%NOTFOUND THEN
469: hr_utility.trace('Transmitter not Archvied ');
470: CLOSE c_gre_payroll_action;
471: /* message to user -- Transmitter has not been archived */
472: message_text := 'Transmitter not Archived';
473: hr_utility.trace('Transmitter has not been archived');

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

469: hr_utility.trace('Transmitter not Archvied ');
470: CLOSE c_gre_payroll_action;
471: /* message to user -- Transmitter has not been archived */
472: message_text := 'Transmitter not Archived';
473: hr_utility.trace('Transmitter has not been archived');
474: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
475: pay_core_utils.push_token('record_name',message_preprocess);
476: pay_core_utils.push_token('description',message_text);
477: -- hr_utility.raise_error;

Line 477: -- hr_utility.raise_error;

473: hr_utility.trace('Transmitter has not been archived');
474: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
475: pay_core_utils.push_token('record_name',message_preprocess);
476: pay_core_utils.push_token('description',message_text);
477: -- hr_utility.raise_error;
478: END IF;
479: CLOSE c_gre_payroll_action;
480:
481: /* end of Transmitter Checking */

Line 483: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check', 10);

479: CLOSE c_gre_payroll_action;
480:
481: /* end of Transmitter Checking */
482:
483: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check', 10);
484:
485: FOR gre_rec IN c_get_gre LOOP
486: /* set l_gre to gre Fethched */
487:

Line 514: -- hr_utility.raise_error;

510: --Some of the assignments have Errored
511: l_package_error_status := 'Y';
512: /* message to user -- assignment has errored out */
513: --
514: -- hr_utility.raise_error;
515: END IF;
516: CLOSE c_arch_errored_asg;
517:
518: /* Checking for Retry */

Line 529: -- hr_utility.raise_error;

525: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
526: pay_core_utils.push_token('record_name',message_preprocess);
527: pay_core_utils.push_token('description',message_text);
528: l_package_error_status := 'Y';
529: -- hr_utility.raise_error;
530:
531: END IF;
532:
533: CLOSE c_arch_retry_pending;

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

531: END IF;
532:
533: CLOSE c_arch_retry_pending;
534:
535: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
536: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
537: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
538:
539: l_no_of_gres_picked := l_no_of_gres_picked + 1;

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

532:
533: CLOSE c_arch_retry_pending;
534:
535: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
536: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
537: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
538:
539: l_no_of_gres_picked := l_no_of_gres_picked + 1;
540: /* All the condition have been met so it is safe to make Arhive

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

533: CLOSE c_arch_retry_pending;
534:
535: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
536: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
537: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
538:
539: l_no_of_gres_picked := l_no_of_gres_picked + 1;
540: /* All the condition have been met so it is safe to make Arhive
541: Call

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

543:
544: IF p_report_type = 'FEDW2' THEN --federal W2
545: archive_eoy_data(l_payroll_action_id,l_gre);
546: ELSE
547: hr_utility.trace('Federal smart archive call');
548: archive_eoy_data(l_payroll_action_id,l_gre);
549: hr_utility.trace('State Code :- ' || p_state_code);
550: hr_utility.trace('GRE - ' || to_char(l_gre));
551: hr_utility.trace('Before calling Smart State Archive');

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

545: archive_eoy_data(l_payroll_action_id,l_gre);
546: ELSE
547: hr_utility.trace('Federal smart archive call');
548: archive_eoy_data(l_payroll_action_id,l_gre);
549: hr_utility.trace('State Code :- ' || p_state_code);
550: hr_utility.trace('GRE - ' || to_char(l_gre));
551: hr_utility.trace('Before calling Smart State Archive');
552: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
553: hr_utility.trace('After call to state Archive');

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

546: ELSE
547: hr_utility.trace('Federal smart archive call');
548: archive_eoy_data(l_payroll_action_id,l_gre);
549: hr_utility.trace('State Code :- ' || p_state_code);
550: hr_utility.trace('GRE - ' || to_char(l_gre));
551: hr_utility.trace('Before calling Smart State Archive');
552: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
553: hr_utility.trace('After call to state Archive');
554: END IF;

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

547: hr_utility.trace('Federal smart archive call');
548: archive_eoy_data(l_payroll_action_id,l_gre);
549: hr_utility.trace('State Code :- ' || p_state_code);
550: hr_utility.trace('GRE - ' || to_char(l_gre));
551: hr_utility.trace('Before calling Smart State Archive');
552: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
553: hr_utility.trace('After call to state Archive');
554: END IF;
555:

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

549: hr_utility.trace('State Code :- ' || p_state_code);
550: hr_utility.trace('GRE - ' || to_char(l_gre));
551: hr_utility.trace('Before calling Smart State Archive');
552: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
553: hr_utility.trace('After call to state Archive');
554: END IF;
555:
556: hr_utility.trace('After Call to smart Archive ');
557:

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

552: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
553: hr_utility.trace('After call to state Archive');
554: END IF;
555:
556: hr_utility.trace('After Call to smart Archive ');
557:
558: /* Check EIN for the Employee */
559:
560: IF p_report_type = 'FEDW2' THEN --federal W2

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

573: /* Check for State */
574: -- OPEN c_chk_archive_state_code (l_gre,l_payroll_action_id);
575: -- FETCH c_chk_archive_state_code INTO l_state_tax_rules_exist;
576: -- IF c_chk_archive_state_code%NOTFOUND THEN
577: -- hr_utility.trace('State Tax Rules not Found ');
578: -- /* state Tax Rules have not been Defined */
579: -- message_text := 'State Tax Rules not Defind for GRE '
580: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
581: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

587: -- close c_chk_archive_state_code;
588:
589: /* Do check_er_data only if Record exist */
590: /* Add those checks for current Year */
591: hr_utility.trace('Check the State ER data ');
592: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
593: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
594: /* EIN check Failed */
595: -- IF l_ein_result = 'N'THEN

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

589: /* Do check_er_data only if Record exist */
590: /* Add those checks for current Year */
591: hr_utility.trace('Check the State ER data ');
592: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
593: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
594: /* EIN check Failed */
595: -- IF l_ein_result = 'N'THEN
596: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
597: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);

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

592: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
593: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
594: /* EIN check Failed */
595: -- IF l_ein_result = 'N'THEN
596: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
597: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
598: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
599: -- pay_core_utils.push_token('record_name',message_preprocess);
600: -- pay_core_utils.push_token('description',message_text);

Line 620: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check', 99);

616:
617: /* Code commented to fix Bug # 3069840
618:
619: IF p_report_type = 'FEDW2' THEN --federal W2
620: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check', 99);
621: OPEN c_gre_fed(gre_rec.gre);
622: ELSIF p_report_type = 'STW2' THEN --state W2
623: OPEN c_gre_state(gre_rec.gre);
624: END IF;

Line 634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);

630: -- Start feching Persons for GRE
631: FETCH c_gre_fed INTO l_person
632: ,l_assignment
633: ,l_asg_effective_dt;
634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);
635: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
636: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
637: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
638: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

631: FETCH c_gre_fed INTO l_person
632: ,l_assignment
633: ,l_asg_effective_dt;
634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);
635: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
636: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
637: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
638: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
639: IF c_gre_fed%NOTFOUND THEN

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

632: ,l_assignment
633: ,l_asg_effective_dt;
634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);
635: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
636: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
637: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
638: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
639: IF c_gre_fed%NOTFOUND THEN
640: -- get out of the Main Loop if You have reached No person Found

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

633: ,l_asg_effective_dt;
634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);
635: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
636: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
637: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
638: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
639: IF c_gre_fed%NOTFOUND THEN
640: -- get out of the Main Loop if You have reached No person Found
641: EXIT;

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

634: hr_utility.set_location('pay_us_mmref_reporting_mt.preprocess_check',20);
635: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
636: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
637: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
638: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
639: IF c_gre_fed%NOTFOUND THEN
640: -- get out of the Main Loop if You have reached No person Found
641: EXIT;
642: END IF;

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

646: FETCH c_gre_state INTO l_person
647: ,l_assignment
648: ,l_asg_effective_dt;
649:
650: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
651: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
652: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
653: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
654: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

647: ,l_assignment
648: ,l_asg_effective_dt;
649:
650: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
651: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
652: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
653: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
654: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
655: -- No Person Was found for the State So Exit

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

648: ,l_asg_effective_dt;
649:
650: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
651: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
652: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
653: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
654: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
655: -- No Person Was found for the State So Exit
656: IF c_gre_state%NOTFOUND THEN

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

649:
650: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
651: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
652: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
653: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
654: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
655: -- No Person Was found for the State So Exit
656: IF c_gre_state%NOTFOUND THEN
657: EXIT;

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

650: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
651: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
652: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
653: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
654: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
655: -- No Person Was found for the State So Exit
656: IF c_gre_state%NOTFOUND THEN
657: EXIT;
658: END IF;

Line 662: hr_utility.trace('pay_us_mmref_reporting_mt.preprocess_check');

658: END IF;
659: END IF; -- report type = 'STW2' and etc
660:
661:
662: hr_utility.trace('pay_us_mmref_reporting_mt.preprocess_check');
663: hr_utility.trace('GRE - '||to_char(l_gre));
664:
665: -- get the balance for person
666:

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

659: END IF; -- report type = 'STW2' and etc
660:
661:
662: hr_utility.trace('pay_us_mmref_reporting_mt.preprocess_check');
663: hr_utility.trace('GRE - '||to_char(l_gre));
664:
665: -- get the balance for person
666:
667: IF p_report_type = 'FEDW2' THEN

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

693: close c_gre_fed;
694: ELSE
695: close c_gre_state;
696: END IF; -- End Of Report_type 'FEDW2'
697: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
698: -- Person Found with Balance for given GRE
699: message_text := 'GRE_ID := ' || to_char(l_gre)
700: || ' has People with Balnace > 0';
701: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

735:
736: END LOOP; /* end of for statement */
737:
738: IF l_package_error_status = 'Y' THEN
739: hr_utility.trace('Error Condition Found');
740: message_text := 'Error Condition detected ' ;
741: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
742: pay_core_utils.push_token('record_name',message_preprocess);
743: pay_core_utils.push_token('description',message_text);

Line 749: hr_utility.raise_error;

745: message_text := 'Pay Message line and log have more Details' ;
746: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
747: pay_core_utils.push_token('record_name',message_preprocess);
748: pay_core_utils.push_token('description',message_text);
749: hr_utility.raise_error;
750: END IF;
751:
752: IF l_no_of_gres_picked = 0 THEN
753: --It means that no archived GRE was

Line 760: hr_utility.raise_error;

756: message_text := 'No GRE was picked for Magnetic Tape';
757: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
758: pay_core_utils.push_token('record_name',message_preprocess);
759: pay_core_utils.push_token('description',message_text);
760: hr_utility.raise_error;
761: END IF;
762:
763: RETURN TRUE;
764: hr_utility.trace('Succesful - Return True ');

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

760: hr_utility.raise_error;
761: END IF;
762:
763: RETURN TRUE;
764: hr_utility.trace('Succesful - Return True ');
765: exception
766: when others then
767: -- add message for this
768: message_text := message_text || '+ Exception';

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

765: exception
766: when others then
767: -- add message for this
768: message_text := message_text || '+ Exception';
769: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
770: hr_utility.set_message_token('MESSAGE', message_text);
771: hr_utility.raise_error;
772:
773: END preprocess_check;

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

766: when others then
767: -- add message for this
768: message_text := message_text || '+ Exception';
769: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
770: hr_utility.set_message_token('MESSAGE', message_text);
771: hr_utility.raise_error;
772:
773: END preprocess_check;
774: --

Line 771: hr_utility.raise_error;

767: -- add message for this
768: message_text := message_text || '+ Exception';
769: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
770: hr_utility.set_message_token('MESSAGE', message_text);
771: hr_utility.raise_error;
772:
773: END preprocess_check;
774: --
775: ----------------------------------------------------------------------------

Line 799: hr_utility.trace_on(null,'FEDW2');

795: p_state_abbrev VARCHAR2(3);
796: p_state_code VARCHAR2(2);
797: p_report_type VARCHAR2(30);
798: BEGIN
799: hr_utility.trace_on(null,'FEDW2');
800: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor', 10);
801: get_report_parameters(
802: p_pactid,
803: p_year_start,

Line 800: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor', 10);

796: p_state_code VARCHAR2(2);
797: p_report_type VARCHAR2(30);
798: BEGIN
799: hr_utility.trace_on(null,'FEDW2');
800: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor', 10);
801: get_report_parameters(
802: p_pactid,
803: p_year_start,
804: p_year_end,

Line 810: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor', 20);

806: p_state_code,
807: p_report_type,
808: p_business_group_id
809: );
810: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor', 20);
811: /* IF preprocess_check(p_pactid,
812: p_year_start,
813: p_year_end,
814: p_business_group_id,

Line 846: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor',

842: and hoi.org_information_context =
843: ''1099R Magnetic Report Rules'')
844: ORDER BY paf.person_id
845: ';
846: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor',
847: 30);
848: ELSIF p_report_type = 'STW2' THEN
849: p_sqlstr := '
850: SELECT DISTINCT

Line 895: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor',

891: and hoi.org_information_context =
892: ''1099R Magnetic Report Rules''
893: )
894: order by to_number(paa.serial_number)';
895: hr_utility.set_location( 'pay_us_mmref_reporting_mt.range_cursor',
896: 40);
897: END IF;
898: -- END IF;
899: END range_cursor;

Line 1143: hr_utility.set_location( 'pay_us_mmref_reporting_mt.create_assignement_act',

1139: l_gre_id := -1;
1140: l_error_flag := 'N';
1141:
1142: -- Get the report parameters. These define the report being run.
1143: hr_utility.set_location( 'pay_us_mmref_reporting_mt.create_assignement_act',
1144: 10);
1145: get_report_parameters(
1146: p_pactid,
1147: l_year_start,

Line 1157: hr_utility.set_location( 'pay_us_mmref_reporting_mt.create_assignement_act',

1153: );
1154: --Currently all reports group by GRE
1155: l_group_by_gre := TRUE;
1156: --Open the appropriate cursor
1157: hr_utility.set_location( 'pay_us_mmref_reporting_mt.create_assignement_act',
1158: 20);
1159: IF l_report_type = 'FEDW2' THEN
1160: OPEN c_federal;
1161: --

Line 1176: hr_utility.set_location(

1172: l_assignment_id,
1173: l_tax_unit_id,
1174: l_effective_end_date,
1175: l_assignment_action_id;
1176: hr_utility.set_location(
1177: 'pay_us_mmref_reporting_mt.create_assignement_act', 30);
1178: EXIT WHEN c_federal%NOTFOUND;
1179: ELSIF l_report_type = 'STW2' and l_state_abbrev = 'PR' THEN
1180: FETCH c_pr_state INTO l_person_id,

Line 1186: hr_utility.set_location(

1182: l_tax_unit_id,
1183: l_effective_end_date,
1184: l_assignment_action_id,
1185: l_w2_box17;
1186: hr_utility.set_location(
1187: 'pay_us_mmref_reporting_mt.create_assignement_act', 40);
1188: EXIT WHEN c_pr_state%NOTFOUND;
1189: -- Check the state Tax rules if new gre
1190: -- Set the Error Flag to Y so that Action Creation will Error

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

1190: -- Set the Error Flag to Y so that Action Creation will Error
1191: -- At the End
1192:
1193: IF l_gre_id = l_tax_unit_id THEN
1194: hr_utility.trace('Same GRE ');
1195: ELSE
1196: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1197: hr_utility.trace('State Tax Rules Missing in GRE');
1198: l_gre_id := l_tax_unit_id;

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

1193: IF l_gre_id = l_tax_unit_id THEN
1194: hr_utility.trace('Same GRE ');
1195: ELSE
1196: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1197: hr_utility.trace('State Tax Rules Missing in GRE');
1198: l_gre_id := l_tax_unit_id;
1199: l_error_flag := 'Y';
1200: ELSE
1201: l_gre_id := l_tax_unit_id;

Line 1212: hr_utility.set_location(

1208: l_tax_unit_id,
1209: l_effective_end_date,
1210: l_assignment_action_id,
1211: l_w2_box17;
1212: hr_utility.set_location(
1213: 'pay_us_mmref_reporting_mt.create_assignement_act', 40);
1214: EXIT WHEN c_state%NOTFOUND;
1215: -- Check the state Tax rules if new gre
1216: -- Set the Error Flag to Y so that Action Creation will Error

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

1216: -- Set the Error Flag to Y so that Action Creation will Error
1217: -- At the End
1218:
1219: IF l_gre_id = l_tax_unit_id THEN
1220: hr_utility.trace('Same GRE ');
1221: ELSE
1222: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1223: hr_utility.trace('State Tax Rules Missing in GRE');
1224: l_gre_id := l_tax_unit_id;

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

1219: IF l_gre_id = l_tax_unit_id THEN
1220: hr_utility.trace('Same GRE ');
1221: ELSE
1222: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1223: hr_utility.trace('State Tax Rules Missing in GRE');
1224: l_gre_id := l_tax_unit_id;
1225: l_error_flag := 'Y';
1226: ELSE
1227: l_gre_id := l_tax_unit_id;

Line 1243: hr_utility.set_location(

1239: l_tax_unit_id = l_prev_tax_unit_id) OR
1240: (NOT l_group_by_gre AND
1241: l_person_id = l_prev_person_id)) THEN
1242: --Do Nothing
1243: hr_utility.set_location(
1244: 'pay_us_mmref_reporting_mt.create_assignement_act', 50);
1245: NULL;
1246: ELSE
1247: --Create the assignment action for the record

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

1244: 'pay_us_mmref_reporting_mt.create_assignement_act', 50);
1245: NULL;
1246: ELSE
1247: --Create the assignment action for the record
1248: hr_utility.trace('Assignment Fetched - ');
1249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1252: hr_utility.trace('Effective End Date : '||

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

1245: NULL;
1246: ELSE
1247: --Create the assignment action for the record
1248: hr_utility.trace('Assignment Fetched - ');
1249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1252: hr_utility.trace('Effective End Date : '||
1253: to_char(l_effective_end_date));

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

1246: ELSE
1247: --Create the assignment action for the record
1248: hr_utility.trace('Assignment Fetched - ');
1249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1252: hr_utility.trace('Effective End Date : '||
1253: to_char(l_effective_end_date));
1254:

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

1247: --Create the assignment action for the record
1248: hr_utility.trace('Assignment Fetched - ');
1249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1252: hr_utility.trace('Effective End Date : '||
1253: to_char(l_effective_end_date));
1254:
1255: IF l_report_type = 'FEDW2' then

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

1248: hr_utility.trace('Assignment Fetched - ');
1249: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1250: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1251: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1252: hr_utility.trace('Effective End Date : '||
1253: to_char(l_effective_end_date));
1254:
1255: IF l_report_type = 'FEDW2' then
1256:

Line 1308: hr_utility.set_location(

1304: (l_report_type = 'STW2') then
1305: SELECT pay_assignment_actions_s.nextval
1306: INTO lockingactid
1307: FROM dual;
1308: hr_utility.set_location(
1309: 'pay_us_mmref_reporting_mt.create_assignement_act', 60);
1310: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1311: p_chunk, l_tax_unit_id);
1312: hr_utility.set_location(

Line 1312: hr_utility.set_location(

1308: hr_utility.set_location(
1309: 'pay_us_mmref_reporting_mt.create_assignement_act', 60);
1310: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1311: p_chunk, l_tax_unit_id);
1312: hr_utility.set_location(
1313: 'pay_us_mmref_reporting_mt.create_assignement_act', 70);
1314: --update serial number for highly compensated people for the
1315: --state W2.
1316: /*IF l_report_type = 'STW2' THEN

Line 1317: hr_utility.set_location(

1313: 'pay_us_mmref_reporting_mt.create_assignement_act', 70);
1314: --update serial number for highly compensated people for the
1315: --state W2.
1316: /*IF l_report_type = 'STW2' THEN
1317: hr_utility.set_location(
1318: 'pay_us_mmref_reporting_mt.create_assignement_act', 80);
1319: IF l_w2_box17 > 9999999.99 THEN
1320: UPDATE pay_assignment_actions
1321: SET serial_number = 999999

Line 1326: hr_utility.set_location(

1322: WHERE assignment_action_id = lockingactid;
1323: END IF;
1324: END IF;*/ -- 4490252
1325: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1326: hr_utility.set_location(
1327: 'pay_us_mmref_reporting_mt.create_assignement_act', 90);
1328: hr_utility.trace('Interlock Created - ');
1329: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1330: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

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

1324: END IF;*/ -- 4490252
1325: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1326: hr_utility.set_location(
1327: 'pay_us_mmref_reporting_mt.create_assignement_act', 90);
1328: hr_utility.trace('Interlock Created - ');
1329: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1330: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1331: --Store the current person/GRE for comparision during the
1332: --next iteration.

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

1325: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1326: hr_utility.set_location(
1327: 'pay_us_mmref_reporting_mt.create_assignement_act', 90);
1328: hr_utility.trace('Interlock Created - ');
1329: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1330: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1331: --Store the current person/GRE for comparision during the
1332: --next iteration.
1333: l_prev_person_id := l_person_id;

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

1326: hr_utility.set_location(
1327: 'pay_us_mmref_reporting_mt.create_assignement_act', 90);
1328: hr_utility.trace('Interlock Created - ');
1329: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1330: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1331: --Store the current person/GRE for comparision during the
1332: --next iteration.
1333: l_prev_person_id := l_person_id;
1334: l_prev_tax_unit_id := l_tax_unit_id;

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

1343: CLOSE c_state;
1344: END IF;
1345:
1346: IF l_error_flag = 'Y' THEN
1347: hr_utility.trace('Error Flag was set to Y');
1348: hr_utility.raise_error;
1349: END IF;
1350:
1351: END create_assignment_act;

Line 1348: hr_utility.raise_error;

1344: END IF;
1345:
1346: IF l_error_flag = 'Y' THEN
1347: hr_utility.trace('Error Flag was set to Y');
1348: hr_utility.raise_error;
1349: END IF;
1350:
1351: END create_assignment_act;
1352:

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

1494: IS
1495: BEGIN
1496: /* get the Parameter Setting */
1497:
1498: hr_utility.trace('Calling the state archiving ');
1499: hr_utility.trace('Pactid ' || to_char(p_pactid));
1500: hr_utility.trace('tax id ' || to_char(p_tax_id));
1501: hr_utility.trace('Pactid ' || p_state_code);
1502:

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

1495: BEGIN
1496: /* get the Parameter Setting */
1497:
1498: hr_utility.trace('Calling the state archiving ');
1499: hr_utility.trace('Pactid ' || to_char(p_pactid));
1500: hr_utility.trace('tax id ' || to_char(p_tax_id));
1501: hr_utility.trace('Pactid ' || p_state_code);
1502:
1503: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);

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

1496: /* get the Parameter Setting */
1497:
1498: hr_utility.trace('Calling the state archiving ');
1499: hr_utility.trace('Pactid ' || to_char(p_pactid));
1500: hr_utility.trace('tax id ' || to_char(p_tax_id));
1501: hr_utility.trace('Pactid ' || p_state_code);
1502:
1503: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1504:

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

1497:
1498: hr_utility.trace('Calling the state archiving ');
1499: hr_utility.trace('Pactid ' || to_char(p_pactid));
1500: hr_utility.trace('tax id ' || to_char(p_tax_id));
1501: hr_utility.trace('Pactid ' || p_state_code);
1502:
1503: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1504:
1505: END ARCHIVE_STATE_EOY_DATA;

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

1592: l_message_text := 'ERROR: PR 499R Starting Control Number not defined';
1593: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1594: pay_core_utils.push_token('record_name',l_message_preprocess);
1595: pay_core_utils.push_token('description',l_message_text);
1596: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1597: l_control_num_flag := 'N';
1598: else
1599: if (l_control_number is NULL or l_control_number = 0) then
1600: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';

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

1597: l_control_num_flag := 'N';
1598: else
1599: if (l_control_number is NULL or l_control_number = 0) then
1600: l_message_text := 'ERROR:PR 499R Starting control Number is NULL';
1601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1602: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1603: pay_core_utils.push_token('record_name',l_message_preprocess);
1604: pay_core_utils.push_token('description',l_message_text);
1605: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );

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

1601: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1602: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1603: pay_core_utils.push_token('record_name',l_message_preprocess);
1604: pay_core_utils.push_token('description',l_message_text);
1605: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1606: l_control_num_flag := 'N';
1607: end if;
1608: end if;
1609: close c_get_pr_control_num;

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

1611: open c_sit_check(C1.payroll_action,c1.unit_id,l_w2_state);
1612: l_message_preprocess := 'GRE: ' ||c1.name || ' has ' ;
1613: fetch c_sit_check INTO l_info ;
1614: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
1615: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
1616: if c_sit_check%notfound then
1617: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
1618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1619: pay_core_utils.push_token('record_name',l_message_preprocess);

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

1617: l_message_text := 'ERROR: Missing State Tax Rules For State of :' || p_transfer_state;
1618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1619: pay_core_utils.push_token('record_name',l_message_preprocess);
1620: pay_core_utils.push_token('description',l_message_text);
1621: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1622: l_flag := 'N';
1623: close c_sit_check;
1624: else
1625: if l_info IS NULL THEN

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

1624: else
1625: if l_info IS NULL THEN
1626: l_flag := 'N';
1627: l_message_text := 'ERROR: NULL EIN For State of ' || p_transfer_state;
1628: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1630: pay_core_utils.push_token('record_name',l_message_preprocess);
1631: pay_core_utils.push_token('description',l_message_text);
1632: end if ;

Line 1641: hr_utility.raise_error;

1637: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
1638: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1639: pay_core_utils.push_token('record_name',l_message_preprocess);
1640: pay_core_utils.push_token('description',l_message_text);
1641: hr_utility.raise_error;
1642: return 'N';
1643: END IF;
1644: return 'Y';
1645: EXCEPTION

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

1649: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1650: pay_core_utils.push_token('record_name',l_message_preprocess);
1651: pay_core_utils.push_token('description',l_message_text);
1652: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
1653: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1654: hr_utility.set_message_token('MESSAGE', u_message_text);
1655: hr_utility.raise_error;
1656: return 'Y';
1657: END check_state_data;

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

1650: pay_core_utils.push_token('record_name',l_message_preprocess);
1651: pay_core_utils.push_token('description',l_message_text);
1652: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
1653: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1654: hr_utility.set_message_token('MESSAGE', u_message_text);
1655: hr_utility.raise_error;
1656: return 'Y';
1657: END check_state_data;
1658:

Line 1655: hr_utility.raise_error;

1651: pay_core_utils.push_token('description',l_message_text);
1652: u_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
1653: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1654: hr_utility.set_message_token('MESSAGE', u_message_text);
1655: hr_utility.raise_error;
1656: return 'Y';
1657: END check_state_data;
1658:
1659: -- ----------------------------------------------------------------------------

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

1713: );
1714:
1715: BEGIN
1716: --
1717: hr_utility.set_location('Entering:'||l_proc, 10);
1718: --
1719:
1720:
1721: -- Get the user entity id for A_LC_FEDERAL_TAX_RULES_ORG_GOVERNMENT_EMPLOYER

Line 1754: raise hr_utility.hr_error;

1750: BEGIN
1751:
1752: IF p_state = 'FED' and p_error = 'Y'
1753: THEN
1754: raise hr_utility.hr_error;
1755: return 'Y';
1756: END IF;
1757: return 'N';
1758: END;