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_REPORTING1 dependencies on PAY_CORE_UTILS

Line 386: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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);
389: hr_utility.raise_error;
390: ELSE

Line 387: pay_core_utils.push_token('record_name',message_preprocess);

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);
389: hr_utility.raise_error;
390: ELSE
391: CLOSE c_tax_ein;

Line 388: pay_core_utils.push_token('description',message_text);

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);
389: hr_utility.raise_error;
390: ELSE
391: CLOSE c_tax_ein;
392: END IF;

Line 404: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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);
407: hr_utility.raise_error;
408: ELSE

Line 405: pay_core_utils.push_token('record_name',message_preprocess);

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);
407: hr_utility.raise_error;
408: ELSE
409: CLOSE c_user_entity_id_of_bal;

Line 406: pay_core_utils.push_token('description',message_text);

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);
407: hr_utility.raise_error;
408: ELSE
409: CLOSE c_user_entity_id_of_bal;
410: END IF;

Line 418: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

414: IF c_context_tax_unit_id%NOTFOUND THEN
415: CLOSE c_context_tax_unit_id;
416: /* message to user -- unable to find the context_id for tax_unit_id */
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

Line 419: pay_core_utils.push_token('record_name',message_preprocess);

415: CLOSE c_context_tax_unit_id;
416: /* message to user -- unable to find the context_id for tax_unit_id */
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;

Line 420: pay_core_utils.push_token('description',message_text);

416: /* message to user -- unable to find the context_id for tax_unit_id */
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;

Line 434: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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;
438: ELSE

Line 435: pay_core_utils.push_token('record_name',message_preprocess);

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;
438: ELSE
439: CLOSE c_context_jurisdiction;

Line 436: pay_core_utils.push_token('description',message_text);

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;
438: ELSE
439: CLOSE c_context_jurisdiction;
440: eND IF;

Line 450: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

446: IF c_transmitter%NOTFOUND THEN
447: CLOSE c_transmitter;
448: /* message to user -- transmitter has not been defined for the gre */
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

Line 451: pay_core_utils.push_token('record_name',message_preprocess);

447: CLOSE c_transmitter;
448: /* message to user -- transmitter has not been defined for the gre */
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;

Line 452: pay_core_utils.push_token('description',message_text);

448: /* message to user -- transmitter has not been defined for the gre */
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;

Line 474: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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;
478: END IF;

Line 475: pay_core_utils.push_token('record_name',message_preprocess);

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;
478: END IF;
479: CLOSE c_gre_payroll_action;

Line 476: pay_core_utils.push_token('description',message_text);

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;
478: END IF;
479: CLOSE c_gre_payroll_action;
480:

Line 507: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

503: INTO l_asg_errored;
504:
505: IF c_arch_errored_asg%FOUND THEN
506: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
507: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
508: pay_core_utils.push_token('record_name',message_preprocess);
509: pay_core_utils.push_token('description',message_text);
510: --Some of the assignments have Errored
511: l_package_error_status := 'Y';

Line 508: pay_core_utils.push_token('record_name',message_preprocess);

504:
505: IF c_arch_errored_asg%FOUND THEN
506: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
507: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
508: pay_core_utils.push_token('record_name',message_preprocess);
509: pay_core_utils.push_token('description',message_text);
510: --Some of the assignments have Errored
511: l_package_error_status := 'Y';
512: /* message to user -- assignment has errored out */

Line 509: pay_core_utils.push_token('description',message_text);

505: IF c_arch_errored_asg%FOUND THEN
506: message_text := 'Assignment in Error Conditon for GRE:= ' || to_char(l_gre);
507: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
508: pay_core_utils.push_token('record_name',message_preprocess);
509: pay_core_utils.push_token('description',message_text);
510: --Some of the assignments have Errored
511: l_package_error_status := 'Y';
512: /* message to user -- assignment has errored out */
513: --

Line 525: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

521: FETCH c_arch_retry_pending INTO l_asg_retry_pend;
522: IF c_arch_retry_pending%FOUND THEN
523: --Some of the assignments have been marked for retry
524: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
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;

Line 526: pay_core_utils.push_token('record_name',message_preprocess);

522: IF c_arch_retry_pending%FOUND THEN
523: --Some of the assignments have been marked for retry
524: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
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:

Line 527: pay_core_utils.push_token('description',message_text);

523: --Some of the assignments have been marked for retry
524: message_text := 'Assignment Marked for Retry: GRE_ID := ' || to_char(l_gre);
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;

Line 566: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

562: l_ein_result := check_er_data(l_payroll_action_id,l_gre);
563:
564: IF l_ein_result = 'N'THEN
565: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
566: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
567: pay_core_utils.push_token('record_name',message_preprocess);
568: pay_core_utils.push_token('description',message_text);
569: l_package_error_status := 'Y';
570: END IF;

Line 567: pay_core_utils.push_token('record_name',message_preprocess);

563:
564: IF l_ein_result = 'N'THEN
565: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
566: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
567: pay_core_utils.push_token('record_name',message_preprocess);
568: pay_core_utils.push_token('description',message_text);
569: l_package_error_status := 'Y';
570: END IF;
571: ELSE

Line 568: pay_core_utils.push_token('description',message_text);

564: IF l_ein_result = 'N'THEN
565: message_text := 'EIN for GRE:= ' || to_char(l_gre) || 'Not Set';
566: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
567: pay_core_utils.push_token('record_name',message_preprocess);
568: pay_core_utils.push_token('description',message_text);
569: l_package_error_status := 'Y';
570: END IF;
571: ELSE
572: /* If Report type is not Fed so state */

Line 581: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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');
582: -- pay_core_utils.push_token('record_name',message_preprocess);
583: -- pay_core_utils.push_token('description',message_text);
584: -- l_package_error_status := 'Y';
585: -- END IF; /* Missing State Tax Rules */

Line 582: -- pay_core_utils.push_token('record_name',message_preprocess);

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');
582: -- pay_core_utils.push_token('record_name',message_preprocess);
583: -- pay_core_utils.push_token('description',message_text);
584: -- l_package_error_status := 'Y';
585: -- END IF; /* Missing State Tax Rules */
586: --

Line 583: -- pay_core_utils.push_token('description',message_text);

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');
582: -- pay_core_utils.push_token('record_name',message_preprocess);
583: -- pay_core_utils.push_token('description',message_text);
584: -- l_package_error_status := 'Y';
585: -- END IF; /* Missing State Tax Rules */
586: --
587: -- close c_chk_archive_state_code;

Line 598: -- pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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);
601: -- l_package_error_status := 'Y';
602: -- END IF;

Line 599: -- pay_core_utils.push_token('record_name',message_preprocess);

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);
601: -- l_package_error_status := 'Y';
602: -- END IF;
603: END IF;

Line 600: -- pay_core_utils.push_token('description',message_text);

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);
601: -- l_package_error_status := 'Y';
602: -- END IF;
603: END IF;
604:

Line 701: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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');
702: pay_core_utils.push_token('record_name',message_preprocess);
703: pay_core_utils.push_token('description',message_text);
704:
705: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;

Line 702: pay_core_utils.push_token('record_name',message_preprocess);

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');
702: pay_core_utils.push_token('record_name',message_preprocess);
703: pay_core_utils.push_token('description',message_text);
704:
705: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
706: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 703: pay_core_utils.push_token('description',message_text);

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');
702: pay_core_utils.push_token('record_name',message_preprocess);
703: pay_core_utils.push_token('description',message_text);
704:
705: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
706: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
707: pay_core_utils.push_token('record_name',message_preprocess);

Line 706: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

702: pay_core_utils.push_token('record_name',message_preprocess);
703: pay_core_utils.push_token('description',message_text);
704:
705: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
706: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
707: pay_core_utils.push_token('record_name',message_preprocess);
708: l_package_error_status := 'Y';
709: END IF;
710: l_balance_exists := 0;

Line 707: pay_core_utils.push_token('record_name',message_preprocess);

703: pay_core_utils.push_token('description',message_text);
704:
705: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
706: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
707: pay_core_utils.push_token('record_name',message_preprocess);
708: l_package_error_status := 'Y';
709: END IF;
710: l_balance_exists := 0;
711:

Line 727: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');

723:
724: /* A warning is logged if GRE is not archived Buug # 3069840 */
725: l_package_error_status := 'N';
726: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
727: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
728: pay_core_utils.push_token('record_name',message_preprocess);
729: pay_core_utils.push_token('description',message_text);
730:
731: END IF; --end if for checking of person balance if the GRE has

Line 728: pay_core_utils.push_token('record_name',message_preprocess);

724: /* A warning is logged if GRE is not archived Buug # 3069840 */
725: l_package_error_status := 'N';
726: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
727: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
728: pay_core_utils.push_token('record_name',message_preprocess);
729: pay_core_utils.push_token('description',message_text);
730:
731: END IF; --end if for checking of person balance if the GRE has
732: --not been archived.

Line 729: pay_core_utils.push_token('description',message_text);

725: l_package_error_status := 'N';
726: message_text := 'Please Archive GRE With ID := ' || to_char(l_gre) ;
727: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA_WARNING','P');
728: pay_core_utils.push_token('record_name',message_preprocess);
729: pay_core_utils.push_token('description',message_text);
730:
731: END IF; --end if for checking of person balance if the GRE has
732: --not been archived.
733:

Line 741: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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);
744:
745: message_text := 'Pay Message line and log have more Details' ;

Line 742: pay_core_utils.push_token('record_name',message_preprocess);

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);
744:
745: message_text := 'Pay Message line and log have more Details' ;
746: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

Line 743: pay_core_utils.push_token('description',message_text);

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);
744:
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);

Line 746: 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);
744:
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;

Line 747: pay_core_utils.push_token('record_name',message_preprocess);

743: pay_core_utils.push_token('description',message_text);
744:
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:

Line 748: pay_core_utils.push_token('description',message_text);

744:
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

Line 757: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

753: --It means that no archived GRE was
754: --found for the Organization. This is an error.
755:
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;

Line 758: pay_core_utils.push_token('record_name',message_preprocess);

754: --found for the Organization. This is an error.
755:
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:

Line 759: pay_core_utils.push_token('description',message_text);

755:
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;

Line 1409: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1405:
1406: IF l_ein_status = 'N' THEN
1407: message_preprocess := 'Pre-Process Check-';
1408: message_text := 'EIN or Tax Unit Name Missing ';
1409: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1410: pay_core_utils.push_token('record_name',message_preprocess);
1411: pay_core_utils.push_token('description',message_text);
1412: END IF;
1413:

Line 1410: pay_core_utils.push_token('record_name',message_preprocess);

1406: IF l_ein_status = 'N' THEN
1407: message_preprocess := 'Pre-Process Check-';
1408: message_text := 'EIN or Tax Unit Name Missing ';
1409: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1410: pay_core_utils.push_token('record_name',message_preprocess);
1411: pay_core_utils.push_token('description',message_text);
1412: END IF;
1413:
1414: return l_ein_status ;

Line 1411: pay_core_utils.push_token('description',message_text);

1407: message_preprocess := 'Pre-Process Check-';
1408: message_text := 'EIN or Tax Unit Name Missing ';
1409: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');
1410: pay_core_utils.push_token('record_name',message_preprocess);
1411: pay_core_utils.push_token('description',message_text);
1412: END IF;
1413:
1414: return l_ein_status ;
1415:

Line 1593: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1589: open c_get_pr_control_num(C1.unit_id);
1590: fetch c_get_pr_control_num INTO l_control_number;
1591: if c_get_pr_control_num%notfound then
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';

Line 1594: pay_core_utils.push_token('record_name',l_message_preprocess);

1590: fetch c_get_pr_control_num INTO l_control_number;
1591: if c_get_pr_control_num%notfound then
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

Line 1595: pay_core_utils.push_token('description',l_message_text);

1591: if c_get_pr_control_num%notfound then
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

Line 1602: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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 );
1606: l_control_num_flag := 'N';

Line 1603: pay_core_utils.push_token('record_name',l_message_preprocess);

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 );
1606: l_control_num_flag := 'N';
1607: end if;

Line 1604: pay_core_utils.push_token('description',l_message_text);

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 );
1606: l_control_num_flag := 'N';
1607: end if;
1608: end if;

Line 1618: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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);
1620: pay_core_utils.push_token('description',l_message_text);
1621: hr_utility.trace(l_message_preprocess || ' ' || l_message_text );
1622: l_flag := 'N';

Line 1619: pay_core_utils.push_token('record_name',l_message_preprocess);

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);
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;

Line 1620: pay_core_utils.push_token('description',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);
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

Line 1629: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

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 ;
1633: close c_sit_check;

Line 1630: pay_core_utils.push_token('record_name',l_message_preprocess);

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 ;
1633: close c_sit_check;
1634: end if;

Line 1631: pay_core_utils.push_token('description',l_message_text);

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 ;
1633: close c_sit_check;
1634: end if;
1635: END loop;

Line 1638: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1634: end if;
1635: END loop;
1636: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
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';

Line 1639: pay_core_utils.push_token('record_name',l_message_preprocess);

1635: END loop;
1636: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
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;

Line 1640: pay_core_utils.push_token('description',l_message_text);

1636: IF l_flag = 'N' OR l_control_num_flag = 'N' THEN
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';

Line 1649: pay_core_utils.push_message(801,'PAY_INVALID_ER_DATA','P');

1645: EXCEPTION
1646: WHEN OTHERS THEN
1647: l_message_preprocess := 'Exception ';
1648: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
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');

Line 1650: pay_core_utils.push_token('record_name',l_message_preprocess);

1646: WHEN OTHERS THEN
1647: l_message_preprocess := 'Exception ';
1648: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
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);

Line 1651: pay_core_utils.push_token('description',l_message_text);

1647: l_message_preprocess := 'Exception ';
1648: l_message_text := 'Set your W2 Reporting Rules or State Tax Rules';
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;