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

Line 81: hr_utility.set_location

77: AND UE.creator_type = 'B'
78: AND UE.legislation_code = 'US'; /* Bug:2296797 */
79: l_defined_balance_id pay_defined_balances.defined_balance_id%TYPE;
80: BEGIN
81: hr_utility.set_location
82: ('pay_us_mmref_reporting.bal_db_item - opening cursor', 10);
83: -- Open the cursor
84: OPEN csr_defined_balance;
85: -- Fetch the value

Line 90: hr_utility.set_location

86: FETCH csr_defined_balance
87: INTO l_defined_balance_id;
88: IF csr_defined_balance%NOTFOUND THEN
89: CLOSE csr_defined_balance;
90: hr_utility.set_location
91: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
92: hr_utility.raise_error;
93: ELSE
94: hr_utility.set_location

Line 92: hr_utility.raise_error;

88: IF csr_defined_balance%NOTFOUND THEN
89: CLOSE csr_defined_balance;
90: hr_utility.set_location
91: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
92: hr_utility.raise_error;
93: ELSE
94: hr_utility.set_location
95: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
96: CLOSE csr_defined_balance;

Line 94: hr_utility.set_location

90: hr_utility.set_location
91: ('pay_us_mmref_reporting.bal_db_item - no rows found from cursor', 20);
92: hr_utility.raise_error;
93: ELSE
94: hr_utility.set_location
95: ('pay_us_mmref_reporting.bal_db_item - fetched from cursor', 30);
96: CLOSE csr_defined_balance;
97: END IF;
98: /* Return the value to the call */

Line 134: hr_utility.set_location

130: p_business_group_id IN OUT nocopy NUMBER,
131: p_locality_code IN OUT nocopy VARCHAR2
132: ) IS
133: BEGIN
134: hr_utility.set_location
135: ('pay_us_mmref_reporting.get_report_parameters', 10);
136: SELECT ppa.start_date,
137: ppa.effective_date,
138: ppa.business_group_id,

Line 161: hr_utility.set_location

157: SELECT state_code
158: INTO p_state_code
159: FROM pay_us_states
160: WHERE state_abbrev = p_state_abbrev;
161: hr_utility.set_location
162: ('pay_us_mmref_reporting.get_report_parameters', 20);
163: ELSE
164: p_state_code := '';
165: hr_utility.set_location

Line 165: hr_utility.set_location

161: hr_utility.set_location
162: ('pay_us_mmref_reporting.get_report_parameters', 20);
163: ELSE
164: p_state_code := '';
165: hr_utility.set_location
166: ('pay_us_mmref_reporting.get_report_parameters', 30);
167: END IF;
168: IF p_state_abbrev = 'FED' AND p_report_type = 'W2' THEN
169: p_report_type := 'FEDW2';

Line 173: hr_utility.set_location

169: p_report_type := 'FEDW2';
170: ELSIF p_report_type = 'W2' THEN
171: p_report_type := 'STW2';
172: END IF;
173: hr_utility.set_location
174: ('pay_us_mmref_reporting.get_report_parameters', 40);
175: END get_report_parameters;
176: -------------------------------------------------------------------------
177: -- Name : get_balance_value

Line 201: hr_utility.set_location

197: p_effective_date DATE
198: ) RETURN NUMBER IS
199: l_jurisdiction_code VARCHAR2(20);
200: BEGIN
201: hr_utility.set_location
202: ('pay_us_mmref_reporting.get_balance_value', 10);
203: pay_balance_pkg.set_context('TAX_UNIT_ID', p_tax_unit_id);
204: IF p_state_abbrev <> 'FED' THEN
205: SELECT jurisdiction_code

Line 209: hr_utility.set_location

205: SELECT jurisdiction_code
206: INTO l_jurisdiction_code
207: FROM pay_state_rules
208: WHERE state_code = p_state_abbrev;
209: hr_utility.set_location
210: ('pay_us_mmref_reporting.get_balance_value', 15);
211: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
212: END IF;
213: hr_utility.trace(p_balance_name);

Line 213: hr_utility.trace(p_balance_name);

209: hr_utility.set_location
210: ('pay_us_mmref_reporting.get_balance_value', 15);
211: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
212: END IF;
213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location

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

210: ('pay_us_mmref_reporting.get_balance_value', 15);
211: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
212: END IF;
213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location
218: ('pay_us_mmref_reporting.get_balance_value', 20);

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

211: pay_balance_pkg.set_context('JURISDICTION_CODE', l_jurisdiction_code);
212: END IF;
213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location
218: ('pay_us_mmref_reporting.get_balance_value', 20);
219: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),

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

212: END IF;
213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location
218: ('pay_us_mmref_reporting.get_balance_value', 20);
219: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
220: p_assignment_id, p_effective_date);

Line 217: hr_utility.set_location

213: hr_utility.trace(p_balance_name);
214: hr_utility.trace('Context');
215: hr_utility.trace('Tax Unit Id: '|| p_tax_unit_id);
216: hr_utility.trace('Jurisdiction: '|| l_jurisdiction_code);
217: hr_utility.set_location
218: ('pay_us_mmref_reporting.get_balance_value', 20);
219: RETURN pay_balance_pkg.get_value(bal_db_item(p_balance_name),
220: p_assignment_id, p_effective_date);
221: END get_balance_value;

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

430: FETCH c_tax_ein INTO l_ein;
431: IF c_tax_ein%NOTFOUND THEN
432: CLOSE c_tax_ein;
433: l_package_error_status := 'Y';
434: hr_utility.trace('A_TAX_UNIT_EMPLOYER_IDENTIFICATION_NUMBER missing ');
435: message_text := 'EIN ID missing ';
436: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
437: pay_core_utils.push_token('record_name',message_preprocess);
438: pay_core_utils.push_token('description',message_text);

Line 439: hr_utility.raise_error;

435: message_text := 'EIN ID missing ';
436: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
437: pay_core_utils.push_token('record_name',message_preprocess);
438: pay_core_utils.push_token('description',message_text);
439: hr_utility.raise_error;
440: ELSE
441: CLOSE c_tax_ein;
442: END IF;
443:

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

448: IF c_user_entity_id_of_bal%NOTFOUND THEN
449: CLOSE c_user_entity_id_of_bal;
450: l_package_error_status := 'Y';
451: /* message to user - Database item missing */
452: hr_utility.trace('Database item for balacne missing ');
453: message_text := '-Database item missing ';
454: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
455: pay_core_utils.push_token('record_name',message_preprocess);
456: pay_core_utils.push_token('description',message_text);

Line 457: hr_utility.raise_error;

453: message_text := '-Database item missing ';
454: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
455: pay_core_utils.push_token('record_name',message_preprocess);
456: pay_core_utils.push_token('description',message_text);
457: hr_utility.raise_error;
458: ELSE
459: CLOSE c_user_entity_id_of_bal;
460: END IF;
461:

Line 471: hr_utility.raise_error;

467: message_text := 'Context_id value for tax_unit_id missing';
468: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
469: pay_core_utils.push_token('record_name',message_preprocess);
470: pay_core_utils.push_token('description',message_text);
471: hr_utility.raise_error;
472: ELSE
473: CLOSE c_context_tax_unit_id;
474: END IF;
475:

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

479: CLOSE c_context_jurisdiction;
480: /* message to User -- Unable to find to context_id for jurisdiction */
481:
482: message_text := 'Context_id value for jurisdiction missing';
483: hr_utility.trace('Contxt_id value for jurisdction_id missing');
484: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
485: pay_core_utils.push_token('record_name',message_preprocess);
486: pay_core_utils.push_token('description',message_text);
487: hr_utility.raise_error;

Line 487: hr_utility.raise_error;

483: hr_utility.trace('Contxt_id value for jurisdction_id missing');
484: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
485: pay_core_utils.push_token('record_name',message_preprocess);
486: pay_core_utils.push_token('description',message_text);
487: hr_utility.raise_error;
488: ELSE
489: CLOSE c_context_jurisdiction;
490: END IF;
491: /* Get the Tranmitter id of the Current Mag. W2. and check if it has

Line 503: hr_utility.raise_error;

499: message_text := 'Transmitter Not denfined';
500: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
501: pay_core_utils.push_token('record_name',message_preprocess);
502: pay_core_utils.push_token('description',message_text);
503: hr_utility.raise_error;
504: ELSE
505: CLOSE c_transmitter;
506: END IF;
507:

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

504: ELSE
505: CLOSE c_transmitter;
506: END IF;
507:
508: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
509: hr_utility.trace('Start date ' || to_char(p_year_start));
510: hr_utility.trace('End date ' || to_char(p_year_end));
511: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
512:

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

505: CLOSE c_transmitter;
506: END IF;
507:
508: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
509: hr_utility.trace('Start date ' || to_char(p_year_start));
510: hr_utility.trace('End date ' || to_char(p_year_end));
511: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
512:
513:

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

506: END IF;
507:
508: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
509: hr_utility.trace('Start date ' || to_char(p_year_start));
510: hr_utility.trace('End date ' || to_char(p_year_end));
511: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
512:
513:
514: /* Check if Archiver has been run for Transmitter */

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

507:
508: hr_utility.trace('Transmetter Setting is ' || to_char(l_transmitter));
509: hr_utility.trace('Start date ' || to_char(p_year_start));
510: hr_utility.trace('End date ' || to_char(p_year_end));
511: hr_utility.trace('Bussiness_group id ' || to_char(p_business_group_id));
512:
513:
514: /* Check if Archiver has been run for Transmitter */
515: OPEN c_gre_payroll_action (l_transmitter);

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

515: OPEN c_gre_payroll_action (l_transmitter);
516: FETCH c_gre_payroll_action INTO l_payroll_action_id;
517:
518: IF c_gre_payroll_action%NOTFOUND THEN
519: hr_utility.trace('Transmitter not Archvied ');
520: CLOSE c_gre_payroll_action;
521: /* message to user -- Transmitter has not been archived */
522: message_text := 'Transmitter not Archived';
523: hr_utility.trace('Transmitter has not been archived');

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

519: hr_utility.trace('Transmitter not Archvied ');
520: CLOSE c_gre_payroll_action;
521: /* message to user -- Transmitter has not been archived */
522: message_text := 'Transmitter not Archived';
523: hr_utility.trace('Transmitter has not been archived');
524: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
525: pay_core_utils.push_token('record_name',message_preprocess);
526: pay_core_utils.push_token('description',message_text);
527: -- hr_utility.raise_error;

Line 527: -- hr_utility.raise_error;

523: hr_utility.trace('Transmitter has not been archived');
524: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
525: pay_core_utils.push_token('record_name',message_preprocess);
526: pay_core_utils.push_token('description',message_text);
527: -- hr_utility.raise_error;
528: END IF;
529: CLOSE c_gre_payroll_action;
530:
531: /* end of Transmitter Checking */

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

529: CLOSE c_gre_payroll_action;
530:
531: /* end of Transmitter Checking */
532:
533: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 10);
534:
535: FOR gre_rec IN c_get_gre LOOP
536: /* set l_gre to gre Fethched */
537:

Line 564: -- hr_utility.raise_error;

560: --Some of the assignments have Errored
561: l_package_error_status := 'Y';
562: /* message to user -- assignment has errored out */
563: --
564: -- hr_utility.raise_error;
565: END IF;
566: CLOSE c_arch_errored_asg;
567:
568: /* Checking for Retry */

Line 579: -- hr_utility.raise_error;

575: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
576: pay_core_utils.push_token('record_name',message_preprocess);
577: pay_core_utils.push_token('description',message_text);
578: l_package_error_status := 'Y';
579: -- hr_utility.raise_error;
580:
581: END IF;
582:
583: CLOSE c_arch_retry_pending;

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

581: END IF;
582:
583: CLOSE c_arch_retry_pending;
584:
585: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
586: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
587: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
588:
589: l_no_of_gres_picked := l_no_of_gres_picked + 1;

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

582:
583: CLOSE c_arch_retry_pending;
584:
585: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
586: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
587: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
588:
589: l_no_of_gres_picked := l_no_of_gres_picked + 1;
590: /* All the condition have been met so it is safe to make Arhive

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

583: CLOSE c_arch_retry_pending;
584:
585: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
586: hr_utility.trace('Payroll_action_id - '|| to_char(l_payroll_action_id));
587: hr_utility.trace('No. of GREs picked so far - '|| to_char(l_no_of_gres_picked));
588:
589: l_no_of_gres_picked := l_no_of_gres_picked + 1;
590: /* All the condition have been met so it is safe to make Arhive
591: Call

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

593:
594: IF p_report_type = 'FEDW2' THEN --federal W2
595: archive_eoy_data(l_payroll_action_id,l_gre);
596: ELSE
597: hr_utility.trace('Federal smart archive call');
598: archive_eoy_data(l_payroll_action_id,l_gre);
599: hr_utility.trace('State Code :- ' || p_state_code);
600: hr_utility.trace('GRE - ' || to_char(l_gre));
601: hr_utility.trace('Before calling Smart State Archive');

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

595: archive_eoy_data(l_payroll_action_id,l_gre);
596: ELSE
597: hr_utility.trace('Federal smart archive call');
598: archive_eoy_data(l_payroll_action_id,l_gre);
599: hr_utility.trace('State Code :- ' || p_state_code);
600: hr_utility.trace('GRE - ' || to_char(l_gre));
601: hr_utility.trace('Before calling Smart State Archive');
602: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
603: hr_utility.trace('After call to state Archive');

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

596: ELSE
597: hr_utility.trace('Federal smart archive call');
598: archive_eoy_data(l_payroll_action_id,l_gre);
599: hr_utility.trace('State Code :- ' || p_state_code);
600: hr_utility.trace('GRE - ' || to_char(l_gre));
601: hr_utility.trace('Before calling Smart State Archive');
602: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
603: hr_utility.trace('After call to state Archive');
604: END IF;

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

597: hr_utility.trace('Federal smart archive call');
598: archive_eoy_data(l_payroll_action_id,l_gre);
599: hr_utility.trace('State Code :- ' || p_state_code);
600: hr_utility.trace('GRE - ' || to_char(l_gre));
601: hr_utility.trace('Before calling Smart State Archive');
602: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
603: hr_utility.trace('After call to state Archive');
604: END IF;
605:

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

599: hr_utility.trace('State Code :- ' || p_state_code);
600: hr_utility.trace('GRE - ' || to_char(l_gre));
601: hr_utility.trace('Before calling Smart State Archive');
602: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
603: hr_utility.trace('After call to state Archive');
604: END IF;
605:
606: hr_utility.trace('After Call to smart Archive ');
607:

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

602: archive_state_eoy_data(l_payroll_action_id,l_gre,p_state_code);
603: hr_utility.trace('After call to state Archive');
604: END IF;
605:
606: hr_utility.trace('After Call to smart Archive ');
607:
608: /* Check EIN for the Employee */
609:
610: IF p_report_type = 'FEDW2' THEN --federal W2

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

623: /* Check for State */
624: -- OPEN c_chk_archive_state_code (l_gre,l_payroll_action_id);
625: -- FETCH c_chk_archive_state_code INTO l_state_tax_rules_exist;
626: -- IF c_chk_archive_state_code%NOTFOUND THEN
627: -- hr_utility.trace('State Tax Rules not Found ');
628: -- /* state Tax Rules have not been Defined */
629: -- message_text := 'State Tax Rules not Defind for GRE '
630: -- || to_char(l_gre) || ' for ' || P_state_abbrev;
631: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

637: -- close c_chk_archive_state_code;
638:
639: /* Do check_er_data only if Record exist */
640: /* Add those checks for current Year */
641: hr_utility.trace('Check the State ER data ');
642: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
643: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
644: /* EIN check Failed */
645: -- IF l_ein_result = 'N'THEN

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

639: /* Do check_er_data only if Record exist */
640: /* Add those checks for current Year */
641: hr_utility.trace('Check the State ER data ');
642: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
643: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
644: /* EIN check Failed */
645: -- IF l_ein_result = 'N'THEN
646: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
647: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);

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

642: -- l_ein_result := check_state_er_data(l_payroll_action_id,l_gre,p_state_code);
643: -- hr_utility.trace('return value for check_state_er_data ' || l_ein_result );
644: /* EIN check Failed */
645: -- IF l_ein_result = 'N'THEN
646: -- hr_utility.trace('ID missing in State Tax Rules' || to_char(l_gre));
647: -- message_text := 'Missing ID in State Tax Rules for GRE:= '|| to_char(l_gre);
648: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
649: -- pay_core_utils.push_token('record_name',message_preprocess);
650: -- pay_core_utils.push_token('description',message_text);

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

663: Warning an proceed to genrate W2 Mag Tape
664: */
665: /*
666: IF p_report_type = 'FEDW2' THEN --federal W2
667: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check', 99);
668: OPEN c_gre_fed(gre_rec.gre);
669: ELSIF p_report_type = 'STW2' THEN --state W2
670: OPEN c_gre_state(gre_rec.gre);
671: END IF;

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

677: -- Start feching Persons for GRE
678: FETCH c_gre_fed INTO l_person
679: ,l_assignment
680: ,l_asg_effective_dt;
681: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
682: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
683: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
684: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
685: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

678: FETCH c_gre_fed INTO l_person
679: ,l_assignment
680: ,l_asg_effective_dt;
681: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
682: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
683: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
684: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
685: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
686: IF c_gre_fed%NOTFOUND THEN

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

679: ,l_assignment
680: ,l_asg_effective_dt;
681: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
682: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
683: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
684: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
685: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
686: IF c_gre_fed%NOTFOUND THEN
687: -- get out of the Main Loop if You have reached No person Found

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

680: ,l_asg_effective_dt;
681: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
682: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
683: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
684: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
685: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
686: IF c_gre_fed%NOTFOUND THEN
687: -- get out of the Main Loop if You have reached No person Found
688: EXIT;

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

681: hr_utility.set_location('pay_us_mmref_reporting.preprocess_check',20);
682: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
683: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
684: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
685: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
686: IF c_gre_fed%NOTFOUND THEN
687: -- get out of the Main Loop if You have reached No person Found
688: EXIT;
689: END IF;

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

693: FETCH c_gre_state INTO l_person
694: ,l_assignment
695: ,l_asg_effective_dt;
696:
697: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
698: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
699: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
700: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
701: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));

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

694: ,l_assignment
695: ,l_asg_effective_dt;
696:
697: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
698: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
699: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
700: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
701: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
702: -- No Person Was found for the State So Exit

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

695: ,l_asg_effective_dt;
696:
697: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
698: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
699: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
700: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
701: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
702: -- No Person Was found for the State So Exit
703: IF c_gre_state%NOTFOUND THEN

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

696:
697: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
698: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
699: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
700: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
701: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
702: -- No Person Was found for the State So Exit
703: IF c_gre_state%NOTFOUND THEN
704: EXIT;

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

697: hr_utility.set_location('pay_us_magw2_reporting.preprocess_check', 40);
698: hr_utility.trace('GRE:' || TO_CHAR(l_gre));
699: hr_utility.trace('Assignment ID:' || TO_CHAR(l_assignment));
700: hr_utility.trace('Person ID:' || TO_CHAR(l_person));
701: hr_utility.trace('Effective Date:' || TO_CHAR(l_asg_effective_dt));
702: -- No Person Was found for the State So Exit
703: IF c_gre_state%NOTFOUND THEN
704: EXIT;
705: END IF;

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

705: END IF;
706: END IF; -- report type = 'STW2' and etc
707:
708:
709: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
710: hr_utility.trace('GRE - '||to_char(l_gre));
711:
712: -- get the balance for person
713:

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

706: END IF; -- report type = 'STW2' and etc
707:
708:
709: hr_utility.trace('pay_us_mmref_reporting.preprocess_check');
710: hr_utility.trace('GRE - '||to_char(l_gre));
711:
712: -- get the balance for person
713:
714: IF p_report_type = 'FEDW2' THEN

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

740: close c_gre_fed;
741: ELSE
742: close c_gre_state;
743: END IF; -- End Of Report_type 'FEDW2'
744: hr_utility.trace('Archive_Gre ' || to_char(l_gre));
745: -- Person Found with Balance for given GRE
746: message_text := 'GRE_ID := ' || to_char(l_gre)
747: || ' has People with Balnace > 0';
748: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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

782:
783: END LOOP; /* end of for statement */
784:
785: IF l_package_error_status = 'Y' THEN
786: hr_utility.trace('Error Condition Found');
787: message_text := 'Error Condition detected ' ;
788: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
789: pay_core_utils.push_token('record_name',message_preprocess);
790: pay_core_utils.push_token('description',message_text);

Line 796: hr_utility.raise_error;

792: message_text := 'Pay Message line and log have more Details' ;
793: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
794: pay_core_utils.push_token('record_name',message_preprocess);
795: pay_core_utils.push_token('description',message_text);
796: hr_utility.raise_error;
797: END IF;
798:
799: IF l_no_of_gres_picked = 0 THEN
800: --It means that no archived GRE was

Line 807: hr_utility.raise_error;

803: message_text := 'No GRE was picked for Magnetic Tape';
804: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
805: pay_core_utils.push_token('record_name',message_preprocess);
806: pay_core_utils.push_token('description',message_text);
807: hr_utility.raise_error;
808: END IF;
809:
810: RETURN TRUE;
811: hr_utility.trace('Succesful - Return True ');

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

807: hr_utility.raise_error;
808: END IF;
809:
810: RETURN TRUE;
811: hr_utility.trace('Succesful - Return True ');
812: exception
813: when others then
814: -- add message for this
815: message_text := message_text || '+ Exception';

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

812: exception
813: when others then
814: -- add message for this
815: message_text := message_text || '+ Exception';
816: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
817: hr_utility.set_message_token('MESSAGE', message_text);
818: hr_utility.raise_error;
819:
820: END preprocess_check;

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

813: when others then
814: -- add message for this
815: message_text := message_text || '+ Exception';
816: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
817: hr_utility.set_message_token('MESSAGE', message_text);
818: hr_utility.raise_error;
819:
820: END preprocess_check;
821: --

Line 818: hr_utility.raise_error;

814: -- add message for this
815: message_text := message_text || '+ Exception';
816: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
817: hr_utility.set_message_token('MESSAGE', message_text);
818: hr_utility.raise_error;
819:
820: END preprocess_check;
821: --
822: ----------------------------------------------------------------------------

Line 847: --hr_utility.trace_on(null,'oracle');

843: p_state_code VARCHAR2(2);
844: p_report_type VARCHAR2(30);
845: p_locality_code VARCHAR2(10);
846: BEGIN
847: --hr_utility.trace_on(null,'oracle');
848: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 10);
849: get_report_parameters(
850: p_pactid,
851: p_year_start,

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

844: p_report_type VARCHAR2(30);
845: p_locality_code VARCHAR2(10);
846: BEGIN
847: --hr_utility.trace_on(null,'oracle');
848: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 10);
849: get_report_parameters(
850: p_pactid,
851: p_year_start,
852: p_year_end,

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

855: p_report_type,
856: p_business_group_id,
857: p_locality_code
858: );
859: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor', 20);
860: IF preprocess_check(p_pactid,
861: p_year_start,
862: p_year_end,
863: p_business_group_id,

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

890: and hoi.org_information_context =
891: ''1099R Magnetic Report Rules'')
892: ORDER BY paf.person_id
893: ';
894: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
895: 30);
896: ELSIF p_report_type = 'STW2' THEN
897: p_sqlstr := '
898: SELECT DISTINCT

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

942: and hoi.org_information_context =
943: ''1099R Magnetic Report Rules''
944: )
945: order by to_number(paa.serial_number)';
946: hr_utility.set_location( 'pay_us_mmref_reporting.range_cursor',
947: 40);
948: END IF;
949: END IF;
950: END range_cursor;

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

1114: l_gre_id := -1;
1115: l_error_flag := 'N';
1116:
1117: -- Get the report parameters. These define the report being run.
1118: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1119: 10);
1120: get_report_parameters(
1121: p_pactid,
1122: l_year_start,

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

1129: );
1130: --Currently all reports group by GRE
1131: l_group_by_gre := TRUE;
1132: --Open the appropriate cursor
1133: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1134: 20);
1135: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
1136: IF l_report_type = 'FEDW2' THEN
1137: OPEN c_federal;

Line 1135: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);

1131: l_group_by_gre := TRUE;
1132: --Open the appropriate cursor
1133: hr_utility.set_location( 'pay_us_mmref_reporting.create_assignement_act',
1134: 20);
1135: hr_utility.trace('LOCALITY_CODE : '|| l_locality_code);
1136: IF l_report_type = 'FEDW2' THEN
1137: OPEN c_federal;
1138: ELSIF l_report_type = 'STW2' THEN
1139: OPEN c_state(l_state_code,

Line 1149: hr_utility.set_location(

1145: l_assignment_id,
1146: l_tax_unit_id,
1147: l_effective_end_date,
1148: l_assignment_action_id;
1149: hr_utility.set_location(
1150: 'pay_us_mmref_reporting.create_assignement_act', 30);
1151: EXIT WHEN c_federal%NOTFOUND;
1152: ELSIF l_report_type = 'STW2' THEN
1153: FETCH c_state

Line 1160: hr_utility.set_location(

1156: l_tax_unit_id,
1157: l_effective_end_date,
1158: l_assignment_action_id,
1159: l_w2_box17;
1160: hr_utility.set_location(
1161: 'pay_us_mmref_reporting.create_assignement_act', 40);
1162: EXIT WHEN c_state%NOTFOUND;
1163: -- Check the state Tax rules if new gre
1164: -- Set the Error Flag to Y so that Action Creation will Error

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

1164: -- Set the Error Flag to Y so that Action Creation will Error
1165: -- At the End
1166:
1167: IF l_gre_id = l_tax_unit_id THEN
1168: hr_utility.trace('Same GRE ');
1169: ELSE
1170: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1171: hr_utility.trace('State Tax Rules Missing in GRE');
1172: l_gre_id := l_tax_unit_id;

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

1167: IF l_gre_id = l_tax_unit_id THEN
1168: hr_utility.trace('Same GRE ');
1169: ELSE
1170: IF check_state_er_data(p_pactid,l_tax_unit_id,'A') = 'N' THEN
1171: hr_utility.trace('State Tax Rules Missing in GRE');
1172: l_gre_id := l_tax_unit_id;
1173: l_error_flag := 'Y';
1174: ELSE
1175: l_gre_id := l_tax_unit_id;

Line 1190: hr_utility.set_location(

1186: l_tax_unit_id = l_prev_tax_unit_id) OR
1187: (NOT l_group_by_gre AND
1188: l_person_id = l_prev_person_id)) THEN
1189: --Do Nothing
1190: hr_utility.set_location(
1191: 'pay_us_mmref_reporting.create_assignement_act', 50);
1192: NULL;
1193: ELSE
1194: --Create the assignment action for the record

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

1191: 'pay_us_mmref_reporting.create_assignement_act', 50);
1192: NULL;
1193: ELSE
1194: --Create the assignment action for the record
1195: hr_utility.trace('Assignment Fetched - ');
1196: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1197: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1198: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1199: hr_utility.trace('Effective End Date : '||

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

1192: NULL;
1193: ELSE
1194: --Create the assignment action for the record
1195: hr_utility.trace('Assignment Fetched - ');
1196: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1197: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1198: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1199: hr_utility.trace('Effective End Date : '||
1200: to_char(l_effective_end_date));

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

1193: ELSE
1194: --Create the assignment action for the record
1195: hr_utility.trace('Assignment Fetched - ');
1196: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1197: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1198: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1199: hr_utility.trace('Effective End Date : '||
1200: to_char(l_effective_end_date));
1201: IF l_report_type = 'FEDW2' then

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

1194: --Create the assignment action for the record
1195: hr_utility.trace('Assignment Fetched - ');
1196: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1197: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1198: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1199: hr_utility.trace('Effective End Date : '||
1200: to_char(l_effective_end_date));
1201: IF l_report_type = 'FEDW2' then
1202: open csr_get_fed_wages(l_assignment_action_id, l_tax_unit_id);

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

1195: hr_utility.trace('Assignment Fetched - ');
1196: hr_utility.trace('Assignment Id : '|| to_char(l_assignment_id));
1197: hr_utility.trace('Person Id : '|| to_char(l_person_id));
1198: hr_utility.trace('tax unit id : '|| to_char(l_tax_unit_id));
1199: hr_utility.trace('Effective End Date : '||
1200: to_char(l_effective_end_date));
1201: IF l_report_type = 'FEDW2' then
1202: open csr_get_fed_wages(l_assignment_action_id, l_tax_unit_id);
1203: fetch csr_get_fed_wages into l_value;

Line 1214: hr_utility.set_location(

1210: (l_report_type = 'STW2') then
1211: SELECT pay_assignment_actions_s.nextval
1212: INTO lockingactid
1213: FROM dual;
1214: hr_utility.set_location(
1215: 'pay_us_mmref_reporting.create_assignement_act', 60);
1216: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1217: p_chunk, l_tax_unit_id);
1218: hr_utility.set_location(

Line 1218: hr_utility.set_location(

1214: hr_utility.set_location(
1215: 'pay_us_mmref_reporting.create_assignement_act', 60);
1216: hr_nonrun_asact.insact(lockingactid, l_assignment_id, p_pactid,
1217: p_chunk, l_tax_unit_id);
1218: hr_utility.set_location(
1219: 'pay_us_mmref_reporting.create_assignement_act', 70);
1220: /*
1221: --update serial number for highly compensated people for the
1222: --state W2.

Line 1224: hr_utility.set_location(

1220: /*
1221: --update serial number for highly compensated people for the
1222: --state W2.
1223: IF l_report_type = 'STW2' THEN
1224: hr_utility.set_location(
1225: 'pay_us_mmref_reporting.create_assignement_act', 80);
1226: IF l_w2_box17 > 999999999.99 THEN
1227: UPDATE pay_assignment_actions
1228: SET serial_number = 9999999

Line 1234: hr_utility.set_location(

1230: END IF;
1231: END IF;
1232: */ -- Bug 4490252
1233: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1234: hr_utility.set_location(
1235: 'pay_us_mmref_reporting.create_assignement_act', 90);
1236: hr_utility.trace('Interlock Created - ');
1237: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1238: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));

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

1232: */ -- Bug 4490252
1233: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1234: hr_utility.set_location(
1235: 'pay_us_mmref_reporting.create_assignement_act', 90);
1236: hr_utility.trace('Interlock Created - ');
1237: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1238: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1239: --Store the current person/GRE for comparision during the
1240: --next iteration.

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

1233: hr_nonrun_asact.insint(lockingactid, l_assignment_action_id);
1234: hr_utility.set_location(
1235: 'pay_us_mmref_reporting.create_assignement_act', 90);
1236: hr_utility.trace('Interlock Created - ');
1237: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1238: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1239: --Store the current person/GRE for comparision during the
1240: --next iteration.
1241: l_prev_person_id := l_person_id;

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

1234: hr_utility.set_location(
1235: 'pay_us_mmref_reporting.create_assignement_act', 90);
1236: hr_utility.trace('Interlock Created - ');
1237: hr_utility.trace('Locking Action : '|| to_char(lockingactid));
1238: hr_utility.trace('Locked Action : '|| to_char(l_assignment_action_id));
1239: --Store the current person/GRE for comparision during the
1240: --next iteration.
1241: l_prev_person_id := l_person_id;
1242: l_prev_tax_unit_id := l_tax_unit_id;

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

1249: CLOSE c_state;
1250: END IF;
1251:
1252: IF l_error_flag = 'Y' THEN
1253: hr_utility.trace('Error Flag was set to Y');
1254: hr_utility.raise_error;
1255: END IF;
1256:
1257: END create_assignment_act;

Line 1254: hr_utility.raise_error;

1250: END IF;
1251:
1252: IF l_error_flag = 'Y' THEN
1253: hr_utility.trace('Error Flag was set to Y');
1254: hr_utility.raise_error;
1255: END IF;
1256:
1257: END create_assignment_act;
1258:

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

1400: IS
1401: BEGIN
1402: /* get the Parameter Setting */
1403:
1404: hr_utility.trace('Calling the state archiving ');
1405: hr_utility.trace('Pactid ' || to_char(p_pactid));
1406: hr_utility.trace('tax id ' || to_char(p_tax_id));
1407: hr_utility.trace('Pactid ' || p_state_code);
1408:

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

1401: BEGIN
1402: /* get the Parameter Setting */
1403:
1404: hr_utility.trace('Calling the state archiving ');
1405: hr_utility.trace('Pactid ' || to_char(p_pactid));
1406: hr_utility.trace('tax id ' || to_char(p_tax_id));
1407: hr_utility.trace('Pactid ' || p_state_code);
1408:
1409: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);

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

1402: /* get the Parameter Setting */
1403:
1404: hr_utility.trace('Calling the state archiving ');
1405: hr_utility.trace('Pactid ' || to_char(p_pactid));
1406: hr_utility.trace('tax id ' || to_char(p_tax_id));
1407: hr_utility.trace('Pactid ' || p_state_code);
1408:
1409: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1410:

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

1403:
1404: hr_utility.trace('Calling the state archiving ');
1405: hr_utility.trace('Pactid ' || to_char(p_pactid));
1406: hr_utility.trace('tax id ' || to_char(p_tax_id));
1407: hr_utility.trace('Pactid ' || p_state_code);
1408:
1409: pay_us_archive.eoy_archive_gre_data(p_pactid,p_tax_id,'STATE TAX RULES',p_state_code);
1410:
1411: END ARCHIVE_STATE_EOY_DATA;

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

1485: open c_sit_check(C1.payroll_action,c1.unit_id,l_w2_state);
1486: l_message_preprocess := 'GRE: ' ||c1.name || ' has ' ;
1487: fetch c_sit_check INTO l_info ;
1488: l_message_text := to_char(c1.unit_id) || 'Payroll_action_id ' || to_char(c1.payroll_action);
1489: hr_utility.trace(l_message_preprocess || ' ' || l_message_text) ;
1490: if c_sit_check%notfound then
1491: l_message_text := ' :Missing State Tax Rules For State of :' || p_transfer_state;
1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);

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

1491: l_message_text := ' :Missing State Tax Rules For State of :' || p_transfer_state;
1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);
1494: pay_core_utils.push_token('description',l_message_text);
1495: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1496: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1497: l_flag := 'N';
1498: close c_sit_check;
1499: else

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

1492: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1493: pay_core_utils.push_token('record_name',l_message_preprocess);
1494: pay_core_utils.push_token('description',l_message_text);
1495: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1496: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1497: l_flag := 'N';
1498: close c_sit_check;
1499: else
1500: if l_info IS NULL THEN

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

1499: else
1500: if l_info IS NULL THEN
1501: l_flag := 'N';
1502: l_message_text := ' NULL EIN For State of :' || p_transfer_state;
1503: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1504: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1505: pay_core_utils.push_token('record_name',l_message_preprocess);
1506: pay_core_utils.push_token('description',l_message_text);
1507: end if ;

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

1513: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1514: pay_core_utils.push_token('record_name',l_message_preprocess);
1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1518: hr_utility.set_message_token('MESSAGE', u_message_text);
1519: hr_utility.raise_error;
1520: return 'N';
1521:

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

1514: pay_core_utils.push_token('record_name',l_message_preprocess);
1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1518: hr_utility.set_message_token('MESSAGE', u_message_text);
1519: hr_utility.raise_error;
1520: return 'N';
1521:
1522: END IF;

Line 1519: hr_utility.raise_error;

1515: pay_core_utils.push_token('description',l_message_text);
1516: u_message_text := 'Error in EIN or State Tax Rule Missing ';
1517: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1518: hr_utility.set_message_token('MESSAGE', u_message_text);
1519: hr_utility.raise_error;
1520: return 'N';
1521:
1522: END IF;
1523: return 'Y';

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

1528: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1529: pay_core_utils.push_token('record_name',l_message_preprocess);
1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1533: hr_utility.set_message_token('MESSAGE', u_message_text);
1534: hr_utility.raise_error;
1535: return 'Y';
1536: END check_state_data;

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

1529: pay_core_utils.push_token('record_name',l_message_preprocess);
1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1533: hr_utility.set_message_token('MESSAGE', u_message_text);
1534: hr_utility.raise_error;
1535: return 'Y';
1536: END check_state_data;
1537:

Line 1534: hr_utility.raise_error;

1530: pay_core_utils.push_token('description',l_message_text);
1531: u_message_text := 'Exception : State Tax Rules Or EIN Checking ';
1532: hr_utility.set_message(801, 'HR_7998_ALL_EXEMACRO_MESSAGE');
1533: hr_utility.set_message_token('MESSAGE', u_message_text);
1534: hr_utility.raise_error;
1535: return 'Y';
1536: END check_state_data;
1537:
1538: