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_ZA_EOY_VAL dependencies on FND_MESSAGE

Line 458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');

454: town_city OUT NOCOPY VARCHAR2,
455: employer_name OUT NOCOPY VARCHAR2) as
456: begin
457: -- File header record messages
458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');

Line 459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');

455: employer_name OUT NOCOPY VARCHAR2) as
456: begin
457: -- File header record messages
458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');

Line 460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');

456: begin
457: -- File header record messages
458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');

Line 461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');

457: -- File header record messages
458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');

Line 462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');

458: c_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR');
459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:

Line 463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');

459: c_ref_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_CREATOR_REF_NO');
460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:
467: -- Employer validation messages

Line 464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');

460: c_ref_no_invalid:=fnd_message.get_string('PAY','PY_ZA_INVALID_CREATOR_REF_NO');
461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:
467: -- Employer validation messages
468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');

Line 465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');

461: c_person_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_NAME');
462: c_telephone:=fnd_message.get_string('PAY','PY_ZA_ENTER_CONTACT_PHONE_NO');
463: c_add_line1:=fnd_message.get_string('PAY','PY_ZA_ENTER_ADDRESS_LINE1');
464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:
467: -- Employer validation messages
468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
469: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');

Line 468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');

464: c_pcode:=fnd_message.get_string('PAY','PY_ZA_ENTER_POSTAL_CODE');
465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:
467: -- Employer validation messages
468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
469: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
470: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
471: address:=c_add_line1;
472: pcode:= c_pcode;

Line 469: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');

465: c_pcode1:=fnd_message.get_string('PAY','PY_ZA_INVALID_POSTAL_CODE');
466:
467: -- Employer validation messages
468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
469: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
470: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
471: address:=c_add_line1;
472: pcode:= c_pcode;
473: pcode1:=c_pcode1;

Line 470: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');

466:
467: -- Employer validation messages
468: trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_TRADING_NAME');
469: paye_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_TAX_REF_NO');
470: paye_no1:=fnd_message.get_string('PAY','PY_ZA_INVALID_TAX_REF_NO');
471: address:=c_add_line1;
472: pcode:= c_pcode;
473: pcode1:=c_pcode1;
474: --Added for TYE09

Line 475: employer_name :=fnd_message.get_string('PAY','PY_ZA_INVALID_EMPLOYER_NAME');

471: address:=c_add_line1;
472: pcode:= c_pcode;
473: pcode1:=c_pcode1;
474: --Added for TYE09
475: employer_name :=fnd_message.get_string('PAY','PY_ZA_INVALID_EMPLOYER_NAME');
476: -- Payroll validation message
477: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
478:
479: --Employee validation messages

Line 477: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');

473: pcode1:=c_pcode1;
474: --Added for TYE09
475: employer_name :=fnd_message.get_string('PAY','PY_ZA_INVALID_EMPLOYER_NAME');
476: -- Payroll validation message
477: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
478:
479: --Employee validation messages
480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');

Line 480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');

476: -- Payroll validation message
477: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
478:
479: --Employee validation messages
480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');

Line 481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');

477: payroll_number:=fnd_message.get_string('PAY','PY_ZA_INVALID_IRP5_NO');
478:
479: --Employee validation messages
480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:

Line 482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');

478:
479: --Employee validation messages
480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');

Line 483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');

479: --Employee validation messages
480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');

Line 484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');

480: nature_entered:=fnd_message.get_string('PAY','PY_ZA_ENTER_NATURE_PERSON');
481: id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_AC_ID_PASSNO');
482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');

Line 486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');

482: no_id_passport:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_B_ID_PASSNO');
483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:

Line 487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');

483: sur_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEFGHK_TRADE');
484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');

Line 488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');

484: cc_no:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_DEHK_CC_NO');
485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:

Line 489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');

485:
486: sur_first_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_ABC_S_F_NAME');
487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:
493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');

Line 491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');

487: M_sur_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_S_F_NAME');
488: M_id_pno_fname:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_IDPNO_SF_NAM');
489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:
493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');

Line 493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');

489: M_cc_trade_name:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_CC_NO');
490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:
493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');

Line 494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');

490:
491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:
493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');

Line 495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');

491: M_lname_fname_cc:=fnd_message.get_string('PAY','PY_ZA_ENTER_NAT_M_FM_NAME_CCNO');
492:
493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');

Line 497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');

493: invalid_it_no:=fnd_message.get_string('PAY','PY_ZA_INVALID_IT_TAX_NO');
494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');

Line 498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');

494: birth_id:=fnd_message.get_string('PER','HR_ZA_INVALID_NI_DOB');
495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
502:

Line 499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');

495: legal_entity:=fnd_message.get_string('PAY','PY_ZA_ENTER_LEGAL_ENTITY');
496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
502:
503: exception

Line 500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');

496:
497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
502:
503: exception
504:

Line 501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');

497: no_site_paye_split:=fnd_message.get_string('PAY','PY_ZA_NO_SITE_PAYE_SPLIT');
498: neg_bal_not_alwd :=fnd_message.get_string('PAY','PY_ZA_NEG_BAL_NOT_ALWD');
499: clearance_num:=fnd_message.get_string('PAY','PA_ZA_ENTER_CLEARANCE_NUM');
500: terminate_emp:=fnd_message.get_string('PAY','PA_ZA_TERMINATE_EMP');
501: town_city := fnd_message.get_string('PAY','PAY_ZA_ENTER_TOWN_CITY');
502:
503: exception
504:
505: when others then

Line 1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');

1030: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;

Line 1035: fnd_message.set_token('EMPNO',l_empno);

1031: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;

Line 1036: l_msgtext := fnd_message.get('Y');

1032: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1033: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1034: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
1035: fnd_message.set_token('EMPNO',l_empno);
1036: l_msgtext := fnd_message.get('Y');
1037: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||l_tax_ytd) ;
1038: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||l_site) ;
1039: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||l_paye) ;
1040: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

1051: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);
1058: l_msgtext := fnd_message.get('Y');
1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1056: fnd_message.set_token('EMPno',l_empno);

1052: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);
1058: l_msgtext := fnd_message.get('Y');
1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1060: END LOOP ;

Line 1057: fnd_message.set_token('SARScode',neg_amt_check.code);

1053: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);
1058: l_msgtext := fnd_message.get('Y');
1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1060: END LOOP ;
1061:

Line 1058: l_msgtext := fnd_message.get('Y');

1054: end if;
1055: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1056: fnd_message.set_token('EMPno',l_empno);
1057: fnd_message.set_token('SARScode',neg_amt_check.code);
1058: l_msgtext := fnd_message.get('Y');
1059: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1060: END LOOP ;
1061:
1062: -- Rule 3) Check Lumpsum balances which may not contain negative amounts

Line 1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

1070: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');
1078: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1075: fnd_message.set_token('EMPno',l_empno);

1071: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');
1078: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1079: END LOOP ;

Line 1076: fnd_message.set_token('SARScode',lmpsum_bal.code);

1072: end if;
1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');
1078: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1079: END LOOP ;
1080: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number

Line 1077: l_msgtext := fnd_message.get('Y');

1073: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || g_default_dirno);
1074: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1075: fnd_message.set_token('EMPno',l_empno);
1076: fnd_message.set_token('SARScode',lmpsum_bal.code);
1077: l_msgtext := fnd_message.get('Y');
1078: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1079: END LOOP ;
1080: ---- Check for the Lump Sum Balances with Directive Number Other than the Defoult directive number
1081:

Line 1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

1088: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');
1096: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1093: fnd_message.set_token('EMPno',l_empno);

1089: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');
1096: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1097:

Line 1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);

1090: end if;
1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');
1096: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1097:
1098:

Line 1095: l_msgtext := fnd_message.get('Y');

1091: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_lmpsm_crt_bal.Tax_Directive_Number);
1092: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1093: fnd_message.set_token('EMPno',l_empno);
1094: fnd_message.set_token('SARScode',rec_lmpsm_crt_bal.code);
1095: l_msgtext := fnd_message.get('Y');
1096: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1097:
1098:
1099: END loop;

Line 1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

1112: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);
1119: l_msgtext := fnd_message.get('Y');
1120: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1117: fnd_message.set_token('EMPno',l_empno);

1113: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);
1119: l_msgtext := fnd_message.get('Y');
1120: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1121: END IF ;

Line 1118: fnd_message.set_token('SARScode',ded_bal.code);

1114: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);
1119: l_msgtext := fnd_message.get('Y');
1120: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1121: END IF ;
1122: IF ded_bal.clearance_num = g_default_clrno THEN

Line 1119: l_msgtext := fnd_message.get('Y');

1115: end if;
1116: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
1117: fnd_message.set_token('EMPno',l_empno);
1118: fnd_message.set_token('SARScode',ded_bal.code);
1119: l_msgtext := fnd_message.get('Y');
1120: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1121: END IF ;
1122: IF ded_bal.clearance_num = g_default_clrno THEN
1123: l_missing_clrno_flag := 'Y' ;

Line 1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');

1141: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);
1148: l_msgtext := fnd_message.get('Y');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 1146: fnd_message.set_token('EMPno',l_empno);

1142: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);
1148: l_msgtext := fnd_message.get('Y');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1150: END LOOP ;

Line 1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);

1143: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);
1148: l_msgtext := fnd_message.get('Y');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1150: END LOOP ;
1151: END LOOP ;

Line 1148: l_msgtext := fnd_message.get('Y');

1144: end if;
1145: fnd_message.set_name('PAY', 'PA_ZA_ENTER_CLEARANCE_NUM');
1146: fnd_message.set_token('EMPno',l_empno);
1147: fnd_message.set_token('ELEMENTname',elem_names.element_name);
1148: l_msgtext := fnd_message.get('Y');
1149: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
1150: END LOOP ;
1151: END LOOP ;
1152: END IF;

Line 1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');

1163: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
1164: end if;
1165:
1166: IF l_count1 <>1 then
1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
1168: fnd_message.set_token('EMPno',l_empno);
1169: l_msgtext := fnd_message.get('Y');
1170: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1171: l_count1:=1;

Line 1168: fnd_message.set_token('EMPno',l_empno);

1164: end if;
1165:
1166: IF l_count1 <>1 then
1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
1168: fnd_message.set_token('EMPno',l_empno);
1169: l_msgtext := fnd_message.get('Y');
1170: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1171: l_count1:=1;
1172: END IF;

Line 1169: l_msgtext := fnd_message.get('Y');

1165:
1166: IF l_count1 <>1 then
1167: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
1168: fnd_message.set_token('EMPno',l_empno);
1169: l_msgtext := fnd_message.get('Y');
1170: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1171: l_count1:=1;
1172: END IF;
1173:

Line 1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');

1172: END IF;
1173:
1174: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
1175: LOOP
1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
1179: l_msgtext := fnd_message.get('Y');
1180: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

Line 1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);

1173:
1174: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
1175: LOOP
1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
1179: l_msgtext := fnd_message.get('Y');
1180: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1181: END LOOP;

Line 1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);

1174: FOR pkg_ele IN fetch_pkg_ele(asgn.assignment_action_id, pkg_bal.bal_type_id)
1175: LOOP
1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
1179: l_msgtext := fnd_message.get('Y');
1180: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1181: END LOOP;
1182:

Line 1179: l_msgtext := fnd_message.get('Y');

1175: LOOP
1176: fnd_message.set_name('PAY', 'PY_ZA_ELE_FEED_PKG_BAL');
1177: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
1178: fnd_message.set_token('BALANCEname',pkg_bal.bal_name);
1179: l_msgtext := fnd_message.get('Y');
1180: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
1181: END LOOP;
1182:
1183: END LOOP;

Line 1546: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1542: if P_STYLE in ('ZA_GRE','ZA_SARS') then
1543: -- Validate Unit Number
1544: hr_utility.set_location('Validating Unit Number',10);
1545: if validate_character_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1546: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1547: fnd_message.set_token('FIELD', 'Unit Number in '||l_location);
1548: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1549: l_msg_count := l_msg_count + 1;
1550: end if;

Line 1547: fnd_message.set_token('FIELD', 'Unit Number in '||l_location);

1543: -- Validate Unit Number
1544: hr_utility.set_location('Validating Unit Number',10);
1545: if validate_character_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1546: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1547: fnd_message.set_token('FIELD', 'Unit Number in '||l_location);
1548: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1549: l_msg_count := l_msg_count + 1;
1550: end if;
1551:

Line 1548: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1544: hr_utility.set_location('Validating Unit Number',10);
1545: if validate_character_set(P_UNIT_NUMBER,'ALPHANUM') = false then
1546: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1547: fnd_message.set_token('FIELD', 'Unit Number in '||l_location);
1548: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1549: l_msg_count := l_msg_count + 1;
1550: end if;
1551:
1552: --Validate Complex

Line 1555: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1551:
1552: --Validate Complex
1553: hr_utility.set_location('Validating Complex',20);
1554: if validate_character_set(P_COMPLEX,'FREETEXT') = false then
1555: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1556: fnd_message.set_token('FIELD', 'Complex in '||l_location);
1557: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1558: l_msg_count := l_msg_count + 1;
1559: end if;

Line 1556: fnd_message.set_token('FIELD', 'Complex in '||l_location);

1552: --Validate Complex
1553: hr_utility.set_location('Validating Complex',20);
1554: if validate_character_set(P_COMPLEX,'FREETEXT') = false then
1555: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1556: fnd_message.set_token('FIELD', 'Complex in '||l_location);
1557: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1558: l_msg_count := l_msg_count + 1;
1559: end if;
1560:

Line 1557: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1553: hr_utility.set_location('Validating Complex',20);
1554: if validate_character_set(P_COMPLEX,'FREETEXT') = false then
1555: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1556: fnd_message.set_token('FIELD', 'Complex in '||l_location);
1557: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1558: l_msg_count := l_msg_count + 1;
1559: end if;
1560:
1561: --Validate Street Number

Line 1564: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1560:
1561: --Validate Street Number
1562: hr_utility.set_location('Validating Street Number',25);
1563: if validate_character_set(P_STREET_NUMBER,'ALPHANUM') = false then
1564: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1565: fnd_message.set_token('FIELD', 'Street Number in '||l_location);
1566: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1567: l_msg_count := l_msg_count + 1;
1568: end if;

Line 1565: fnd_message.set_token('FIELD', 'Street Number in '||l_location);

1561: --Validate Street Number
1562: hr_utility.set_location('Validating Street Number',25);
1563: if validate_character_set(P_STREET_NUMBER,'ALPHANUM') = false then
1564: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1565: fnd_message.set_token('FIELD', 'Street Number in '||l_location);
1566: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1567: l_msg_count := l_msg_count + 1;
1568: end if;
1569:

Line 1566: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1562: hr_utility.set_location('Validating Street Number',25);
1563: if validate_character_set(P_STREET_NUMBER,'ALPHANUM') = false then
1564: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1565: fnd_message.set_token('FIELD', 'Street Number in '||l_location);
1566: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1567: l_msg_count := l_msg_count + 1;
1568: end if;
1569:
1570: --For residential, it is mandatory irrespective of nature

Line 1574: fnd_message.set_name('PER', 'HR_ZA_ENTER_STREET_NAME_FARM');

1570: --For residential, it is mandatory irrespective of nature
1571: --Validate Street or Name of Farm
1572: hr_utility.set_location('Validating Street or Name of Farm',30);
1573: if P_STREET_NAME is null and nvl(P_NATURE,'X') <> 'N' then
1574: fnd_message.set_name('PER', 'HR_ZA_ENTER_STREET_NAME_FARM');
1575: fnd_message.set_token('LOCATION', l_location);
1576: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1577: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1578: l_msg_count := l_msg_count + 1;

Line 1575: fnd_message.set_token('LOCATION', l_location);

1571: --Validate Street or Name of Farm
1572: hr_utility.set_location('Validating Street or Name of Farm',30);
1573: if P_STREET_NAME is null and nvl(P_NATURE,'X') <> 'N' then
1574: fnd_message.set_name('PER', 'HR_ZA_ENTER_STREET_NAME_FARM');
1575: fnd_message.set_token('LOCATION', l_location);
1576: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1577: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1578: l_msg_count := l_msg_count + 1;
1579: else

Line 1577: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1573: if P_STREET_NAME is null and nvl(P_NATURE,'X') <> 'N' then
1574: fnd_message.set_name('PER', 'HR_ZA_ENTER_STREET_NAME_FARM');
1575: fnd_message.set_token('LOCATION', l_location);
1576: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1577: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1578: l_msg_count := l_msg_count + 1;
1579: else
1580: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1581: p_warn_txt(l_warn_count):=fnd_message.get('Y');

Line 1581: p_warn_txt(l_warn_count):=fnd_message.get('Y');

1577: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1578: l_msg_count := l_msg_count + 1;
1579: else
1580: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1581: p_warn_txt(l_warn_count):=fnd_message.get('Y');
1582: l_warn_count := l_warn_count + 1;
1583: end if;
1584: elsif validate_character_set(P_STREET_NAME,'FREETEXT') = false then
1585: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 1585: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1581: p_warn_txt(l_warn_count):=fnd_message.get('Y');
1582: l_warn_count := l_warn_count + 1;
1583: end if;
1584: elsif validate_character_set(P_STREET_NAME,'FREETEXT') = false then
1585: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1586: fnd_message.set_token('FIELD', 'Street or Name of Farm in '||l_location);
1587: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1588: l_msg_count := l_msg_count + 1;
1589: end if;

Line 1586: fnd_message.set_token('FIELD', 'Street or Name of Farm in '||l_location);

1582: l_warn_count := l_warn_count + 1;
1583: end if;
1584: elsif validate_character_set(P_STREET_NAME,'FREETEXT') = false then
1585: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1586: fnd_message.set_token('FIELD', 'Street or Name of Farm in '||l_location);
1587: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1588: l_msg_count := l_msg_count + 1;
1589: end if;
1590:

Line 1587: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1583: end if;
1584: elsif validate_character_set(P_STREET_NAME,'FREETEXT') = false then
1585: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1586: fnd_message.set_token('FIELD', 'Street or Name of Farm in '||l_location);
1587: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1588: l_msg_count := l_msg_count + 1;
1589: end if;
1590:
1591: --Validate Suburb or District

Line 1594: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1590:
1591: --Validate Suburb or District
1592: hr_utility.set_location('Validating Suburb/District',35);
1593: if validate_character_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1594: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1595: fnd_message.set_token('FIELD', 'Suburb or District in '||l_location);
1596: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1597: l_msg_count := l_msg_count + 1;
1598: end if;

Line 1595: fnd_message.set_token('FIELD', 'Suburb or District in '||l_location);

1591: --Validate Suburb or District
1592: hr_utility.set_location('Validating Suburb/District',35);
1593: if validate_character_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1594: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1595: fnd_message.set_token('FIELD', 'Suburb or District in '||l_location);
1596: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1597: l_msg_count := l_msg_count + 1;
1598: end if;
1599:

Line 1596: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1592: hr_utility.set_location('Validating Suburb/District',35);
1593: if validate_character_set(P_SUBURB_DISTRICT,'FREETEXT') = false then
1594: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1595: fnd_message.set_token('FIELD', 'Suburb or District in '||l_location);
1596: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1597: l_msg_count := l_msg_count + 1;
1598: end if;
1599:
1600: --Validate City or Town

Line 1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1599:
1600: --Validate City or Town
1601: hr_utility.set_location('Validating City/Town',40);
1602: if validate_character_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'City or Town in '||l_location);
1605: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1606: l_msg_count := l_msg_count + 1;
1607: end if;

Line 1604: fnd_message.set_token('FIELD', 'City or Town in '||l_location);

1600: --Validate City or Town
1601: hr_utility.set_location('Validating City/Town',40);
1602: if validate_character_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'City or Town in '||l_location);
1605: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1606: l_msg_count := l_msg_count + 1;
1607: end if;
1608:

Line 1605: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1601: hr_utility.set_location('Validating City/Town',40);
1602: if validate_character_set(P_TOWN_OR_CITY,'FREETEXT') = false then
1603: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1604: fnd_message.set_token('FIELD', 'City or Town in '||l_location);
1605: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1606: l_msg_count := l_msg_count + 1;
1607: end if;
1608:
1609: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null and nvl(P_NATURE,'X') <> 'N' then

Line 1610: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');

1606: l_msg_count := l_msg_count + 1;
1607: end if;
1608:
1609: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null and nvl(P_NATURE,'X') <> 'N' then
1610: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1611: fnd_message.set_token('LOCATION', l_location);
1612: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1613: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1614: l_msg_count := l_msg_count + 1;

Line 1611: fnd_message.set_token('LOCATION', l_location);

1607: end if;
1608:
1609: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null and nvl(P_NATURE,'X') <> 'N' then
1610: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1611: fnd_message.set_token('LOCATION', l_location);
1612: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1613: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1614: l_msg_count := l_msg_count + 1;
1615: else

Line 1613: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1609: if P_SUBURB_DISTRICT is null and P_TOWN_OR_CITY is null and nvl(P_NATURE,'X') <> 'N' then
1610: fnd_message.set_name('PER', 'HR_ZA_ENTER_DISTRICT_OR_TOWN');
1611: fnd_message.set_token('LOCATION', l_location);
1612: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1613: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1614: l_msg_count := l_msg_count + 1;
1615: else
1616: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1617: p_warn_txt(l_warn_count):=fnd_message.get('Y');

Line 1617: p_warn_txt(l_warn_count):=fnd_message.get('Y');

1613: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1614: l_msg_count := l_msg_count + 1;
1615: else
1616: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1617: p_warn_txt(l_warn_count):=fnd_message.get('Y');
1618: l_warn_count := l_warn_count + 1;
1619: end if;
1620: end if ;
1621:

Line 1625: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');

1621:
1622: --Validate Postal Code
1623: hr_utility.set_location('Validating Postal Code',50);
1624: if P_POSTAL_CODE is null and nvl(P_NATURE,'X') <> 'N' then
1625: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1626: fnd_message.set_token('LOCATION', l_location);
1627: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1628: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1629: l_msg_count := l_msg_count + 1;

Line 1626: fnd_message.set_token('LOCATION', l_location);

1622: --Validate Postal Code
1623: hr_utility.set_location('Validating Postal Code',50);
1624: if P_POSTAL_CODE is null and nvl(P_NATURE,'X') <> 'N' then
1625: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1626: fnd_message.set_token('LOCATION', l_location);
1627: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1628: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1629: l_msg_count := l_msg_count + 1;
1630: else

Line 1628: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1624: if P_POSTAL_CODE is null and nvl(P_NATURE,'X') <> 'N' then
1625: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1626: fnd_message.set_token('LOCATION', l_location);
1627: if P_STYLE = 'ZA_GRE' OR (P_STYLE='ZA_SARS' and P_TAX_YEAR <>2010) then
1628: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1629: l_msg_count := l_msg_count + 1;
1630: else
1631: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1632: p_warn_txt(l_warn_count):=fnd_message.get('Y');

Line 1632: p_warn_txt(l_warn_count):=fnd_message.get('Y');

1628: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1629: l_msg_count := l_msg_count + 1;
1630: else
1631: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
1632: p_warn_txt(l_warn_count):=fnd_message.get('Y');
1633: l_warn_count := l_warn_count + 1;
1634: end if;
1635: else
1636: if P_STYLE='ZA_GRE' and length(P_POSTAL_CODE) <> 4 then

Line 1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');

1634: end if;
1635: else
1636: if P_STYLE='ZA_GRE' and length(P_POSTAL_CODE) <> 4 then
1637: hr_utility.set_location('Invalid postal code',50);
1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );
1640: fnd_message.set_token('LENGTH', 4);
1641: fnd_message.set_token('UNITS', 'digits');
1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');

Line 1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );

1635: else
1636: if P_STYLE='ZA_GRE' and length(P_POSTAL_CODE) <> 4 then
1637: hr_utility.set_location('Invalid postal code',50);
1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );
1640: fnd_message.set_token('LENGTH', 4);
1641: fnd_message.set_token('UNITS', 'digits');
1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1643: l_msg_count := l_msg_count + 1;

Line 1640: fnd_message.set_token('LENGTH', 4);

1636: if P_STYLE='ZA_GRE' and length(P_POSTAL_CODE) <> 4 then
1637: hr_utility.set_location('Invalid postal code',50);
1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );
1640: fnd_message.set_token('LENGTH', 4);
1641: fnd_message.set_token('UNITS', 'digits');
1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1643: l_msg_count := l_msg_count + 1;
1644: end if;

Line 1641: fnd_message.set_token('UNITS', 'digits');

1637: hr_utility.set_location('Invalid postal code',50);
1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );
1640: fnd_message.set_token('LENGTH', 4);
1641: fnd_message.set_token('UNITS', 'digits');
1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1643: l_msg_count := l_msg_count + 1;
1644: end if;
1645: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then

Line 1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1638: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
1639: fnd_message.set_token('FIELD', 'Postal Code in '||l_location );
1640: fnd_message.set_token('LENGTH', 4);
1641: fnd_message.set_token('UNITS', 'digits');
1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1643: l_msg_count := l_msg_count + 1;
1644: end if;
1645: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1646: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 1646: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1642: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1643: l_msg_count := l_msg_count + 1;
1644: end if;
1645: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1646: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1647: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1648: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1649: l_msg_count := l_msg_count + 1;
1650: end if;

Line 1647: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);

1643: l_msg_count := l_msg_count + 1;
1644: end if;
1645: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1646: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1647: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1648: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1649: l_msg_count := l_msg_count + 1;
1650: end if;
1651: end if;

Line 1648: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1644: end if;
1645: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1646: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1647: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1648: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1649: l_msg_count := l_msg_count + 1;
1650: end if;
1651: end if;
1652:

Line 1656: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');

1652:
1653: elsif P_STYLE ='ZA' then
1654: --Validate Address Line1
1655: if P_ADDRESS_LINE1 is null then
1656: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1657: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1658: l_msg_count := l_msg_count + 1;
1659: elsif validate_character_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 1657: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1653: elsif P_STYLE ='ZA' then
1654: --Validate Address Line1
1655: if P_ADDRESS_LINE1 is null then
1656: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1657: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1658: l_msg_count := l_msg_count + 1;
1659: elsif validate_character_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Address Line1 in '||l_location);

Line 1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1656: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_ADDRESS_LINE1');
1657: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1658: l_msg_count := l_msg_count + 1;
1659: elsif validate_character_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Address Line1 in '||l_location);
1662: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1663: l_msg_count := l_msg_count + 1;
1664: end if;

Line 1661: fnd_message.set_token('FIELD', 'Address Line1 in '||l_location);

1657: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1658: l_msg_count := l_msg_count + 1;
1659: elsif validate_character_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Address Line1 in '||l_location);
1662: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1663: l_msg_count := l_msg_count + 1;
1664: end if;
1665:

Line 1662: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1658: l_msg_count := l_msg_count + 1;
1659: elsif validate_character_set(P_ADDRESS_LINE1,'FREETEXT') = false then
1660: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1661: fnd_message.set_token('FIELD', 'Address Line1 in '||l_location);
1662: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1663: l_msg_count := l_msg_count + 1;
1664: end if;
1665:
1666: --Validate address line2

Line 1668: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1664: end if;
1665:
1666: --Validate address line2
1667: if validate_character_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1668: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1669: fnd_message.set_token('FIELD', 'Address Line2 in '||l_location);
1670: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1671: l_msg_count := l_msg_count + 1;
1672: end if;

Line 1669: fnd_message.set_token('FIELD', 'Address Line2 in '||l_location);

1665:
1666: --Validate address line2
1667: if validate_character_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1668: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1669: fnd_message.set_token('FIELD', 'Address Line2 in '||l_location);
1670: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1671: l_msg_count := l_msg_count + 1;
1672: end if;
1673:

Line 1670: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1666: --Validate address line2
1667: if validate_character_set(P_ADDRESS_LINE2,'FREETEXT') = false then
1668: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1669: fnd_message.set_token('FIELD', 'Address Line2 in '||l_location);
1670: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1671: l_msg_count := l_msg_count + 1;
1672: end if;
1673:
1674: --Validate address line3

Line 1676: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1672: end if;
1673:
1674: --Validate address line3
1675: if validate_character_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1676: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1677: fnd_message.set_token('FIELD', 'Address Line3 in '||l_location);
1678: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1679: l_msg_count := l_msg_count + 1;
1680: end if;

Line 1677: fnd_message.set_token('FIELD', 'Address Line3 in '||l_location);

1673:
1674: --Validate address line3
1675: if validate_character_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1676: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1677: fnd_message.set_token('FIELD', 'Address Line3 in '||l_location);
1678: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1679: l_msg_count := l_msg_count + 1;
1680: end if;
1681:

Line 1678: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1674: --Validate address line3
1675: if validate_character_set(P_ADDRESS_LINE3,'FREETEXT') = false then
1676: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1677: fnd_message.set_token('FIELD', 'Address Line3 in '||l_location);
1678: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1679: l_msg_count := l_msg_count + 1;
1680: end if;
1681:
1682: --Validate postal code

Line 1684: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');

1680: end if;
1681:
1682: --Validate postal code
1683: if P_POSTAL_CODE is null then
1684: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1685: fnd_message.set_token('LOCATION', l_location);
1686: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1687: l_msg_count := l_msg_count + 1;
1688: end if;

Line 1685: fnd_message.set_token('LOCATION', l_location);

1681:
1682: --Validate postal code
1683: if P_POSTAL_CODE is null then
1684: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1685: fnd_message.set_token('LOCATION', l_location);
1686: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1687: l_msg_count := l_msg_count + 1;
1688: end if;
1689: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then

Line 1686: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1682: --Validate postal code
1683: if P_POSTAL_CODE is null then
1684: fnd_message.set_name('PER', 'HR_ZA_NEW_ENTER_POSTAL_CODE');
1685: fnd_message.set_token('LOCATION', l_location);
1686: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1687: l_msg_count := l_msg_count + 1;
1688: end if;
1689: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1690: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 1690: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

1686: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1687: l_msg_count := l_msg_count + 1;
1688: end if;
1689: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1690: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1691: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1692: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1693: l_msg_count := l_msg_count + 1;
1694: end if;

Line 1691: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);

1687: l_msg_count := l_msg_count + 1;
1688: end if;
1689: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1690: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1691: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1692: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1693: l_msg_count := l_msg_count + 1;
1694: end if;
1695: end if;

Line 1692: p_msg_txt(l_msg_count):=fnd_message.get('Y');

1688: end if;
1689: if validate_character_set(P_POSTAL_CODE,'ALPHANUM') = false then
1690: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
1691: fnd_message.set_token('FIELD', 'Postal Code in '||l_location);
1692: p_msg_txt(l_msg_count):=fnd_message.get('Y');
1693: l_msg_count := l_msg_count + 1;
1694: end if;
1695: end if;
1696:

Line 2078: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADING_NAME');

2074: --Validate the Company Trading Name (Code 2010):
2075: hr_utility.set_location('Validate Company Trading Name - Code 2010',15);
2076: if rec_tax_info.er_trade_name is null then
2077: hr_utility.set_location('Company Trading Name is null',15);
2078: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADING_NAME');
2079: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2080: l_msg_count := l_msg_count + 1;
2081: l_er_info :='Y';
2082: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010

Line 2079: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2075: hr_utility.set_location('Validate Company Trading Name - Code 2010',15);
2076: if rec_tax_info.er_trade_name is null then
2077: hr_utility.set_location('Company Trading Name is null',15);
2078: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADING_NAME');
2079: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2080: l_msg_count := l_msg_count + 1;
2081: l_er_info :='Y';
2082: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2083: elsif length(translate(rec_tax_info.er_trade_name,'~\/*?:><|','~')) <> length(rec_tax_info.er_trade_name)

Line 2086: fnd_message.set_name('PAY', 'PY_ZA_INVALID_EMPLOYER_NAME');

2082: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2083: elsif length(translate(rec_tax_info.er_trade_name,'~\/*?:><|','~')) <> length(rec_tax_info.er_trade_name)
2084: OR instr(rec_tax_info.er_trade_name,'""')<>0 then
2085: hr_utility.set_location('Company Trading Name is invalid',15);
2086: fnd_message.set_name('PAY', 'PY_ZA_INVALID_EMPLOYER_NAME');
2087: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2088: l_msg_count := l_msg_count + 1;
2089: l_er_info :='Y'; */
2090: elsif validate_character_set(rec_tax_info.er_trade_name,'FREETEXT') = FALSE then

Line 2087: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2083: elsif length(translate(rec_tax_info.er_trade_name,'~\/*?:><|','~')) <> length(rec_tax_info.er_trade_name)
2084: OR instr(rec_tax_info.er_trade_name,'""')<>0 then
2085: hr_utility.set_location('Company Trading Name is invalid',15);
2086: fnd_message.set_name('PAY', 'PY_ZA_INVALID_EMPLOYER_NAME');
2087: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2088: l_msg_count := l_msg_count + 1;
2089: l_er_info :='Y'; */
2090: elsif validate_character_set(rec_tax_info.er_trade_name,'FREETEXT') = FALSE then
2091: hr_utility.set_location('Company Trading Name is invalid',15);

Line 2092: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2088: l_msg_count := l_msg_count + 1;
2089: l_er_info :='Y'; */
2090: elsif validate_character_set(rec_tax_info.er_trade_name,'FREETEXT') = FALSE then
2091: hr_utility.set_location('Company Trading Name is invalid',15);
2092: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2093: fnd_message.set_token('FIELD','Company Trading or Other Name');
2094: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2095: l_msg_count := l_msg_count + 1;
2096: l_er_info :='Y';

Line 2093: fnd_message.set_token('FIELD','Company Trading or Other Name');

2089: l_er_info :='Y'; */
2090: elsif validate_character_set(rec_tax_info.er_trade_name,'FREETEXT') = FALSE then
2091: hr_utility.set_location('Company Trading Name is invalid',15);
2092: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2093: fnd_message.set_token('FIELD','Company Trading or Other Name');
2094: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2095: l_msg_count := l_msg_count + 1;
2096: l_er_info :='Y';
2097: end if;

Line 2094: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2090: elsif validate_character_set(rec_tax_info.er_trade_name,'FREETEXT') = FALSE then
2091: hr_utility.set_location('Company Trading Name is invalid',15);
2092: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2093: fnd_message.set_token('FIELD','Company Trading or Other Name');
2094: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2095: l_msg_count := l_msg_count + 1;
2096: l_er_info :='Y';
2097: end if;
2098:

Line 2108: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2104: (l_er_trade_name between '0' and '9') then
2105: null;
2106: else
2107: hr_utility.set_location('Company Trading Name is invalid',15);
2108: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2109: fnd_message.set_token('FIELD','Company Trading or Other Name');
2110: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2111: l_msg_count := l_msg_count + 1;
2112: l_er_info :='Y';

Line 2109: fnd_message.set_token('FIELD','Company Trading or Other Name');

2105: null;
2106: else
2107: hr_utility.set_location('Company Trading Name is invalid',15);
2108: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2109: fnd_message.set_token('FIELD','Company Trading or Other Name');
2110: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2111: l_msg_count := l_msg_count + 1;
2112: l_er_info :='Y';
2113: end if;

Line 2110: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2106: else
2107: hr_utility.set_location('Company Trading Name is invalid',15);
2108: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2109: fnd_message.set_token('FIELD','Company Trading or Other Name');
2110: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2111: l_msg_count := l_msg_count + 1;
2112: l_er_info :='Y';
2113: end if;
2114:

Line 2120: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADE_CLASS');

2116: --Updated as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2117: hr_utility.set_location('Validate Company Trade Classification - Code 2035',20);
2118: if rec_tax_info.er_trade_class is null and p_tax_year <> 2010 then
2119: hr_utility.set_location('Company Trade Classification is null',20);
2120: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADE_CLASS');
2121: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2122: l_msg_count := l_msg_count + 1;
2123: l_er_info :='Y';
2124: else

Line 2121: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2117: hr_utility.set_location('Validate Company Trade Classification - Code 2035',20);
2118: if rec_tax_info.er_trade_class is null and p_tax_year <> 2010 then
2119: hr_utility.set_location('Company Trade Classification is null',20);
2120: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TRADE_CLASS');
2121: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2122: l_msg_count := l_msg_count + 1;
2123: l_er_info :='Y';
2124: else
2125: hr_utility.set_location('Company Trade Classification is not null',20);

Line 2127: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2123: l_er_info :='Y';
2124: else
2125: hr_utility.set_location('Company Trade Classification is not null',20);
2126: if validate_character_set(rec_tax_info.er_trade_class,'NUMERIC')=FALSE then
2127: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2128: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2129: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2130: l_msg_count := l_msg_count + 1;
2131: l_er_info :='Y';

Line 2128: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');

2124: else
2125: hr_utility.set_location('Company Trade Classification is not null',20);
2126: if validate_character_set(rec_tax_info.er_trade_class,'NUMERIC')=FALSE then
2127: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2128: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2129: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2130: l_msg_count := l_msg_count + 1;
2131: l_er_info :='Y';
2132: end if;

Line 2129: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2125: hr_utility.set_location('Company Trade Classification is not null',20);
2126: if validate_character_set(rec_tax_info.er_trade_class,'NUMERIC')=FALSE then
2127: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2128: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2129: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2130: l_msg_count := l_msg_count + 1;
2131: l_er_info :='Y';
2132: end if;
2133: if length(rec_tax_info.er_trade_class) > 4 then

Line 2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');

2130: l_msg_count := l_msg_count + 1;
2131: l_er_info :='Y';
2132: end if;
2133: if length(rec_tax_info.er_trade_class) > 4 then
2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2136: fnd_message.set_token('LENGTH', '4');
2137: fnd_message.set_token('UNITS', 'digits');
2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

Line 2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');

2131: l_er_info :='Y';
2132: end if;
2133: if length(rec_tax_info.er_trade_class) > 4 then
2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2136: fnd_message.set_token('LENGTH', '4');
2137: fnd_message.set_token('UNITS', 'digits');
2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2139: l_msg_count := l_msg_count + 1;

Line 2136: fnd_message.set_token('LENGTH', '4');

2132: end if;
2133: if length(rec_tax_info.er_trade_class) > 4 then
2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2136: fnd_message.set_token('LENGTH', '4');
2137: fnd_message.set_token('UNITS', 'digits');
2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2139: l_msg_count := l_msg_count + 1;
2140: l_er_info :='Y';

Line 2137: fnd_message.set_token('UNITS', 'digits');

2133: if length(rec_tax_info.er_trade_class) > 4 then
2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2136: fnd_message.set_token('LENGTH', '4');
2137: fnd_message.set_token('UNITS', 'digits');
2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2139: l_msg_count := l_msg_count + 1;
2140: l_er_info :='Y';
2141: end if;

Line 2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2134: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2135: fnd_message.set_token('FIELD', 'Trade Classification in ZA Tax Information');
2136: fnd_message.set_token('LENGTH', '4');
2137: fnd_message.set_token('UNITS', 'digits');
2138: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2139: l_msg_count := l_msg_count + 1;
2140: l_er_info :='Y';
2141: end if;
2142: end if;

Line 2148: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TAX_REF_NO');

2144: -- Validate the PAYE Reference Number (Code 2020)
2145: hr_utility.set_location('Validating PAYE Ref Number - Code 2020',22);
2146: if rec_tax_info.paye_ref_num is null then
2147: hr_utility.set_location('PAYE Ref Number is null',22);
2148: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TAX_REF_NO');
2149: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2150: l_msg_count := l_msg_count + 1;
2151: l_er_info :='Y';
2152: elsif substr(rec_tax_info.paye_ref_num,1,1) not in ('0','1','2','3','7','9') then

Line 2149: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2145: hr_utility.set_location('Validating PAYE Ref Number - Code 2020',22);
2146: if rec_tax_info.paye_ref_num is null then
2147: hr_utility.set_location('PAYE Ref Number is null',22);
2148: fnd_message.set_name('PAY', 'PY_ZA_ENTER_TAX_REF_NO');
2149: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2150: l_msg_count := l_msg_count + 1;
2151: l_er_info :='Y';
2152: elsif substr(rec_tax_info.paye_ref_num,1,1) not in ('0','1','2','3','7','9') then
2153: hr_utility.set_location('PAYE Ref Number begins with invalid character',22);

Line 2154: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');

2150: l_msg_count := l_msg_count + 1;
2151: l_er_info :='Y';
2152: elsif substr(rec_tax_info.paye_ref_num,1,1) not in ('0','1','2','3','7','9') then
2153: hr_utility.set_location('PAYE Ref Number begins with invalid character',22);
2154: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');
2155: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2156: l_msg_count := l_msg_count + 1;
2157: l_er_info :='Y';
2158: elsif rec_tax_info.paye_ref_num_mod = 0 then

Line 2155: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2151: l_er_info :='Y';
2152: elsif substr(rec_tax_info.paye_ref_num,1,1) not in ('0','1','2','3','7','9') then
2153: hr_utility.set_location('PAYE Ref Number begins with invalid character',22);
2154: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');
2155: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2156: l_msg_count := l_msg_count + 1;
2157: l_er_info :='Y';
2158: elsif rec_tax_info.paye_ref_num_mod = 0 then
2159: hr_utility.set_location('PAYE Ref Number fails modulus 10 test',22);

Line 2160: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');

2156: l_msg_count := l_msg_count + 1;
2157: l_er_info :='Y';
2158: elsif rec_tax_info.paye_ref_num_mod = 0 then
2159: hr_utility.set_location('PAYE Ref Number fails modulus 10 test',22);
2160: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');
2161: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2162: l_msg_count := l_msg_count + 1;
2163: l_er_info :='Y';
2164: end if;

Line 2161: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2157: l_er_info :='Y';
2158: elsif rec_tax_info.paye_ref_num_mod = 0 then
2159: hr_utility.set_location('PAYE Ref Number fails modulus 10 test',22);
2160: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_REF_NO');
2161: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2162: l_msg_count := l_msg_count + 1;
2163: l_er_info :='Y';
2164: end if;
2165:

Line 2172: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');

2168: if rec_tax_info.sdl_ref_num is not null then
2169: hr_utility.set_location('SDL Number is not null',25);
2170: if substr(rec_tax_info.sdl_ref_num,1,1) <> 'L' OR length(rec_tax_info.sdl_ref_num) <> 10 then
2171: hr_utility.set_location('SDL Number begins with invalid character',25);
2172: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2173: fnd_message.set_token('FIELD','SDL Number');
2174: fnd_message.set_token('CHAR1','L');
2175: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2176: l_msg_count := l_msg_count + 1;

Line 2173: fnd_message.set_token('FIELD','SDL Number');

2169: hr_utility.set_location('SDL Number is not null',25);
2170: if substr(rec_tax_info.sdl_ref_num,1,1) <> 'L' OR length(rec_tax_info.sdl_ref_num) <> 10 then
2171: hr_utility.set_location('SDL Number begins with invalid character',25);
2172: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2173: fnd_message.set_token('FIELD','SDL Number');
2174: fnd_message.set_token('CHAR1','L');
2175: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2176: l_msg_count := l_msg_count + 1;
2177: l_er_info :='Y';

Line 2174: fnd_message.set_token('CHAR1','L');

2170: if substr(rec_tax_info.sdl_ref_num,1,1) <> 'L' OR length(rec_tax_info.sdl_ref_num) <> 10 then
2171: hr_utility.set_location('SDL Number begins with invalid character',25);
2172: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2173: fnd_message.set_token('FIELD','SDL Number');
2174: fnd_message.set_token('CHAR1','L');
2175: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2176: l_msg_count := l_msg_count + 1;
2177: l_er_info :='Y';
2178: end if;

Line 2175: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2171: hr_utility.set_location('SDL Number begins with invalid character',25);
2172: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2173: fnd_message.set_token('FIELD','SDL Number');
2174: fnd_message.set_token('CHAR1','L');
2175: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2176: l_msg_count := l_msg_count + 1;
2177: l_er_info :='Y';
2178: end if;
2179: if substr(rec_tax_info.sdl_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)

Line 2182: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');

2178: end if;
2179: if substr(rec_tax_info.sdl_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)
2180: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2181: hr_utility.set_location('SDL Number doesnt match with PAYE Number',25);
2182: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2183: fnd_message.set_token('FIELD','SDL Number');
2184: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2185: l_msg_count := l_msg_count + 1;
2186: l_er_info :='Y';

Line 2183: fnd_message.set_token('FIELD','SDL Number');

2179: if substr(rec_tax_info.sdl_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)
2180: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2181: hr_utility.set_location('SDL Number doesnt match with PAYE Number',25);
2182: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2183: fnd_message.set_token('FIELD','SDL Number');
2184: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2185: l_msg_count := l_msg_count + 1;
2186: l_er_info :='Y';
2187: end if;

Line 2184: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2180: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2181: hr_utility.set_location('SDL Number doesnt match with PAYE Number',25);
2182: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2183: fnd_message.set_token('FIELD','SDL Number');
2184: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2185: l_msg_count := l_msg_count + 1;
2186: l_er_info :='Y';
2187: end if;
2188: if pay_za_eoy_val.modulus_10_test(rec_tax_info.sdl_ref_num,'S') =0 then

Line 2190: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');

2186: l_er_info :='Y';
2187: end if;
2188: if pay_za_eoy_val.modulus_10_test(rec_tax_info.sdl_ref_num,'S') =0 then
2189: hr_utility.set_location('SDL Number fails modulus 10 test',25);
2190: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
2191: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2192: l_msg_count := l_msg_count + 1;
2193: l_er_info :='Y';
2194: end if;

Line 2191: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2187: end if;
2188: if pay_za_eoy_val.modulus_10_test(rec_tax_info.sdl_ref_num,'S') =0 then
2189: hr_utility.set_location('SDL Number fails modulus 10 test',25);
2190: fnd_message.set_name('PAY', 'PY_ZA_INVALID_SDL_NO');
2191: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2192: l_msg_count := l_msg_count + 1;
2193: l_er_info :='Y';
2194: end if;
2195: end if;

Line 2208: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');

2204: if rec_tax_info.uif_ref_num is not null then
2205: hr_utility.set_location('UIF Number not null',27);
2206: if substr(rec_tax_info.uif_ref_num,1,1) <> 'U' OR length(rec_tax_info.uif_ref_num) <> 10 then
2207: hr_utility.set_location('UIF Number begins with invalid character',27);
2208: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2209: fnd_message.set_token('FIELD','UIF Number');
2210: fnd_message.set_token('CHAR1','U');
2211: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2212: l_msg_count := l_msg_count + 1;

Line 2209: fnd_message.set_token('FIELD','UIF Number');

2205: hr_utility.set_location('UIF Number not null',27);
2206: if substr(rec_tax_info.uif_ref_num,1,1) <> 'U' OR length(rec_tax_info.uif_ref_num) <> 10 then
2207: hr_utility.set_location('UIF Number begins with invalid character',27);
2208: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2209: fnd_message.set_token('FIELD','UIF Number');
2210: fnd_message.set_token('CHAR1','U');
2211: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2212: l_msg_count := l_msg_count + 1;
2213: l_er_info :='Y';

Line 2210: fnd_message.set_token('CHAR1','U');

2206: if substr(rec_tax_info.uif_ref_num,1,1) <> 'U' OR length(rec_tax_info.uif_ref_num) <> 10 then
2207: hr_utility.set_location('UIF Number begins with invalid character',27);
2208: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2209: fnd_message.set_token('FIELD','UIF Number');
2210: fnd_message.set_token('CHAR1','U');
2211: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2212: l_msg_count := l_msg_count + 1;
2213: l_er_info :='Y';
2214: end if;

Line 2211: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2207: hr_utility.set_location('UIF Number begins with invalid character',27);
2208: fnd_message.set_name('PAY', 'PY_ZA_INVALID_FIRST_CHAR');
2209: fnd_message.set_token('FIELD','UIF Number');
2210: fnd_message.set_token('CHAR1','U');
2211: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2212: l_msg_count := l_msg_count + 1;
2213: l_er_info :='Y';
2214: end if;
2215: if substr(rec_tax_info.uif_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)

Line 2218: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');

2214: end if;
2215: if substr(rec_tax_info.uif_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)
2216: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2217: hr_utility.set_location('UIF Number doesnt match with PAYE Number',27);
2218: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2219: fnd_message.set_token('FIELD','UIF Number');
2220: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2221: l_msg_count := l_msg_count + 1;
2222: l_er_info :='Y';

Line 2219: fnd_message.set_token('FIELD','UIF Number');

2215: if substr(rec_tax_info.uif_ref_num,2,9) <> substr(rec_tax_info.paye_ref_num,2,9)
2216: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2217: hr_utility.set_location('UIF Number doesnt match with PAYE Number',27);
2218: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2219: fnd_message.set_token('FIELD','UIF Number');
2220: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2221: l_msg_count := l_msg_count + 1;
2222: l_er_info :='Y';
2223: end if;

Line 2220: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2216: AND substr(rec_tax_info.paye_ref_num,1,1) = '7' then
2217: hr_utility.set_location('UIF Number doesnt match with PAYE Number',27);
2218: fnd_message.set_name('PAY', 'PY_ZA_INVALID_LAST_NINE_CHAR');
2219: fnd_message.set_token('FIELD','UIF Number');
2220: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2221: l_msg_count := l_msg_count + 1;
2222: l_er_info :='Y';
2223: end if;
2224: if pay_za_eoy_val.modulus_10_test(rec_tax_info.uif_ref_num,'U') =0 then

Line 2226: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');

2222: l_er_info :='Y';
2223: end if;
2224: if pay_za_eoy_val.modulus_10_test(rec_tax_info.uif_ref_num,'U') =0 then
2225: hr_utility.set_location('UIF Number fails modulus 10 test',25);
2226: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
2227: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2228: l_msg_count := l_msg_count + 1;
2229: l_er_info :='Y';
2230: end if;

Line 2227: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2223: end if;
2224: if pay_za_eoy_val.modulus_10_test(rec_tax_info.uif_ref_num,'U') =0 then
2225: hr_utility.set_location('UIF Number fails modulus 10 test',25);
2226: fnd_message.set_name('PAY', 'PY_ZA_INVALID_UIF_NO');
2227: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2228: l_msg_count := l_msg_count + 1;
2229: l_er_info :='Y';
2230: end if;
2231: end if;

Line 2238: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_NAME');

2234: -- Validate Contact Person Name (Code 2025)
2235: hr_utility.set_location('Validating Contact Person Name - Code 2025',30);
2236: if rec_tax_file_creator_inf.er_contact_person is null then
2237: hr_utility.set_location('Contact Person Name is null',30);
2238: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_NAME');
2239: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2240: l_msg_count := l_msg_count + 1;
2241: l_er_info :='Y';
2242: elsif validate_character_set(rec_tax_file_creator_inf.er_contact_person,'ALPHA') = FALSE then

Line 2239: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2235: hr_utility.set_location('Validating Contact Person Name - Code 2025',30);
2236: if rec_tax_file_creator_inf.er_contact_person is null then
2237: hr_utility.set_location('Contact Person Name is null',30);
2238: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_NAME');
2239: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2240: l_msg_count := l_msg_count + 1;
2241: l_er_info :='Y';
2242: elsif validate_character_set(rec_tax_file_creator_inf.er_contact_person,'ALPHA') = FALSE then
2243: hr_utility.set_location('Contact Person Name contains invalid characters',30);

Line 2244: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2240: l_msg_count := l_msg_count + 1;
2241: l_er_info :='Y';
2242: elsif validate_character_set(rec_tax_file_creator_inf.er_contact_person,'ALPHA') = FALSE then
2243: hr_utility.set_location('Contact Person Name contains invalid characters',30);
2244: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2245: fnd_message.set_token('FIELD','Contact Person in ZA Tax File Information');
2246: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2247: l_msg_count := l_msg_count + 1;
2248: l_er_info :='Y';

Line 2245: fnd_message.set_token('FIELD','Contact Person in ZA Tax File Information');

2241: l_er_info :='Y';
2242: elsif validate_character_set(rec_tax_file_creator_inf.er_contact_person,'ALPHA') = FALSE then
2243: hr_utility.set_location('Contact Person Name contains invalid characters',30);
2244: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2245: fnd_message.set_token('FIELD','Contact Person in ZA Tax File Information');
2246: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2247: l_msg_count := l_msg_count + 1;
2248: l_er_info :='Y';
2249: end if;

Line 2246: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2242: elsif validate_character_set(rec_tax_file_creator_inf.er_contact_person,'ALPHA') = FALSE then
2243: hr_utility.set_location('Contact Person Name contains invalid characters',30);
2244: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2245: fnd_message.set_token('FIELD','Contact Person in ZA Tax File Information');
2246: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2247: l_msg_count := l_msg_count + 1;
2248: l_er_info :='Y';
2249: end if;
2250:

Line 2256: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_PH_NO');

2252: hr_utility.set_location('Validating Contact Person Number - Code 2026',32);
2253: if rec_tax_file_creator_inf.er_contact_number is null then
2254: hr_utility.set_location('Contact Person Number is null',32);
2255: hr_utility.set_location('l_msg_count:'||l_msg_count,32);
2256: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_PH_NO');
2257: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2258: l_msg_count := l_msg_count + 1;
2259: l_er_info :='Y';
2260: elsif length(rec_tax_file_creator_inf.er_contact_number) not between 9 and 11 then

Line 2257: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2253: if rec_tax_file_creator_inf.er_contact_number is null then
2254: hr_utility.set_location('Contact Person Number is null',32);
2255: hr_utility.set_location('l_msg_count:'||l_msg_count,32);
2256: fnd_message.set_name('PAY', 'PY_ZA_NEW_ENTER_CONTACT_PH_NO');
2257: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2258: l_msg_count := l_msg_count + 1;
2259: l_er_info :='Y';
2260: elsif length(rec_tax_file_creator_inf.er_contact_number) not between 9 and 11 then
2261: hr_utility.set_location('Contact Person Number length not between 9 and 11',32);

Line 2262: fnd_message.set_name('PAY', 'PY_ZA_INVALID_PH_NO');

2258: l_msg_count := l_msg_count + 1;
2259: l_er_info :='Y';
2260: elsif length(rec_tax_file_creator_inf.er_contact_number) not between 9 and 11 then
2261: hr_utility.set_location('Contact Person Number length not between 9 and 11',32);
2262: fnd_message.set_name('PAY', 'PY_ZA_INVALID_PH_NO');
2263: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2264: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2265: l_msg_count := l_msg_count + 1;
2266: l_er_info :='Y';

Line 2263: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');

2259: l_er_info :='Y';
2260: elsif length(rec_tax_file_creator_inf.er_contact_number) not between 9 and 11 then
2261: hr_utility.set_location('Contact Person Number length not between 9 and 11',32);
2262: fnd_message.set_name('PAY', 'PY_ZA_INVALID_PH_NO');
2263: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2264: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2265: l_msg_count := l_msg_count + 1;
2266: l_er_info :='Y';
2267:

Line 2264: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2260: elsif length(rec_tax_file_creator_inf.er_contact_number) not between 9 and 11 then
2261: hr_utility.set_location('Contact Person Number length not between 9 and 11',32);
2262: fnd_message.set_name('PAY', 'PY_ZA_INVALID_PH_NO');
2263: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2264: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2265: l_msg_count := l_msg_count + 1;
2266: l_er_info :='Y';
2267:
2268: /* Added for ZA Aug reconciliation Phase II */

Line 2272: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2268: /* Added for ZA Aug reconciliation Phase II */
2269: elsif (instr(rec_tax_file_creator_inf.er_contact_number,'+') > 0 )
2270: or (instr(rec_tax_file_creator_inf.er_contact_number,' ') > 0 ) then
2271: hr_utility.set_location('Contact Person Number contains invalid characters',32);
2272: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2273: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2274: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2275: l_msg_count := l_msg_count + 1;
2276: l_er_info :='Y';

Line 2273: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');

2269: elsif (instr(rec_tax_file_creator_inf.er_contact_number,'+') > 0 )
2270: or (instr(rec_tax_file_creator_inf.er_contact_number,' ') > 0 ) then
2271: hr_utility.set_location('Contact Person Number contains invalid characters',32);
2272: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2273: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2274: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2275: l_msg_count := l_msg_count + 1;
2276: l_er_info :='Y';
2277:

Line 2274: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2270: or (instr(rec_tax_file_creator_inf.er_contact_number,' ') > 0 ) then
2271: hr_utility.set_location('Contact Person Number contains invalid characters',32);
2272: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2273: fnd_message.set_token('FIELD','Contact Number in ZA Tax File Information');
2274: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2275: l_msg_count := l_msg_count + 1;
2276: l_er_info :='Y';
2277:
2278: end if;

Line 2286: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');

2282: if rec_tax_file_creator_inf.er_email_address is not null then
2283: hr_utility.set_location('Email Address not null',35);
2284: if validate_email_id(rec_tax_file_creator_inf.er_email_address) = FALSE then
2285: hr_utility.set_location('Email Address doesnt contain @ or .',35);
2286: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2287: fnd_message.set_token('CONTACT','Email Address in ZA Tax File Information');
2288: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2289: l_msg_count := l_msg_count + 1;
2290: l_er_info :='Y';

Line 2287: fnd_message.set_token('CONTACT','Email Address in ZA Tax File Information');

2283: hr_utility.set_location('Email Address not null',35);
2284: if validate_email_id(rec_tax_file_creator_inf.er_email_address) = FALSE then
2285: hr_utility.set_location('Email Address doesnt contain @ or .',35);
2286: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2287: fnd_message.set_token('CONTACT','Email Address in ZA Tax File Information');
2288: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2289: l_msg_count := l_msg_count + 1;
2290: l_er_info :='Y';
2291: end if;

Line 2288: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2284: if validate_email_id(rec_tax_file_creator_inf.er_email_address) = FALSE then
2285: hr_utility.set_location('Email Address doesnt contain @ or .',35);
2286: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2287: fnd_message.set_token('CONTACT','Email Address in ZA Tax File Information');
2288: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2289: l_msg_count := l_msg_count + 1;
2290: l_er_info :='Y';
2291: end if;
2292: if validate_character_set(rec_tax_file_creator_inf.er_email_address,'FREETEXT') = FALSE then

Line 2294: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2290: l_er_info :='Y';
2291: end if;
2292: if validate_character_set(rec_tax_file_creator_inf.er_email_address,'FREETEXT') = FALSE then
2293: hr_utility.set_location('Email Address contains invalid characters.',35);
2294: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2295: fnd_message.set_token('FIELD','Email Address in ZA Tax File Information');
2296: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2297: l_msg_count := l_msg_count + 1;
2298: l_er_info :='Y';

Line 2295: fnd_message.set_token('FIELD','Email Address in ZA Tax File Information');

2291: end if;
2292: if validate_character_set(rec_tax_file_creator_inf.er_email_address,'FREETEXT') = FALSE then
2293: hr_utility.set_location('Email Address contains invalid characters.',35);
2294: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2295: fnd_message.set_token('FIELD','Email Address in ZA Tax File Information');
2296: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2297: l_msg_count := l_msg_count + 1;
2298: l_er_info :='Y';
2299: end if;

Line 2296: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');

2292: if validate_character_set(rec_tax_file_creator_inf.er_email_address,'FREETEXT') = FALSE then
2293: hr_utility.set_location('Email Address contains invalid characters.',35);
2294: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2295: fnd_message.set_token('FIELD','Email Address in ZA Tax File Information');
2296: l_er_msg_tab(l_msg_count) := fnd_message.get('Y');
2297: l_msg_count := l_msg_count + 1;
2298: l_er_info :='Y';
2299: end if;
2300: end if;

Line 2418: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');

2414: end if ;
2415:
2416: if l_home_no is not null then
2417: if length(l_home_no) not between 9 and 11 then
2418: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2419: fnd_message.set_token('FIELD', 'Home Telephone Number');
2420: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2421: l_msg_count := l_msg_count + 1;
2422: end if;

Line 2419: fnd_message.set_token('FIELD', 'Home Telephone Number');

2415:
2416: if l_home_no is not null then
2417: if length(l_home_no) not between 9 and 11 then
2418: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2419: fnd_message.set_token('FIELD', 'Home Telephone Number');
2420: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2421: l_msg_count := l_msg_count + 1;
2422: end if;
2423: if validate_character_set(l_home_no,'NUMERIC') = FALSE then

Line 2420: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2416: if l_home_no is not null then
2417: if length(l_home_no) not between 9 and 11 then
2418: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2419: fnd_message.set_token('FIELD', 'Home Telephone Number');
2420: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2421: l_msg_count := l_msg_count + 1;
2422: end if;
2423: if validate_character_set(l_home_no,'NUMERIC') = FALSE then
2424: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2424: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2420: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2421: l_msg_count := l_msg_count + 1;
2422: end if;
2423: if validate_character_set(l_home_no,'NUMERIC') = FALSE then
2424: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2425: fnd_message.set_token('FIELD', 'Home Telephone Number');
2426: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2427: l_msg_count := l_msg_count + 1;
2428: end if;

Line 2425: fnd_message.set_token('FIELD', 'Home Telephone Number');

2421: l_msg_count := l_msg_count + 1;
2422: end if;
2423: if validate_character_set(l_home_no,'NUMERIC') = FALSE then
2424: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2425: fnd_message.set_token('FIELD', 'Home Telephone Number');
2426: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2427: l_msg_count := l_msg_count + 1;
2428: end if;
2429: end if;

Line 2426: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2422: end if;
2423: if validate_character_set(l_home_no,'NUMERIC') = FALSE then
2424: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2425: fnd_message.set_token('FIELD', 'Home Telephone Number');
2426: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2427: l_msg_count := l_msg_count + 1;
2428: end if;
2429: end if;
2430:

Line 2453: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_PH_NO');

2449: end if;
2450: end if ;
2451:
2452: if p_nature <> 'N' and l_work_no is null then
2453: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_PH_NO');
2454: if p_tax_year=2010 then
2455: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2456: l_warn_count := l_warn_count + 1;
2457: else

Line 2455: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

2451:
2452: if p_nature <> 'N' and l_work_no is null then
2453: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_PH_NO');
2454: if p_tax_year=2010 then
2455: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2456: l_warn_count := l_warn_count + 1;
2457: else
2458: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2459: l_msg_count := l_msg_count + 1;

Line 2458: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2454: if p_tax_year=2010 then
2455: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2456: l_warn_count := l_warn_count + 1;
2457: else
2458: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2459: l_msg_count := l_msg_count + 1;
2460: end if;
2461: elsif l_work_no is not null then
2462: if length(l_work_no) not between 9 and 11 then

Line 2463: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');

2459: l_msg_count := l_msg_count + 1;
2460: end if;
2461: elsif l_work_no is not null then
2462: if length(l_work_no) not between 9 and 11 then
2463: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2464: fnd_message.set_token('FIELD', 'Work Telephone Number');
2465: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2466: l_msg_count := l_msg_count + 1;
2467: end if;

Line 2464: fnd_message.set_token('FIELD', 'Work Telephone Number');

2460: end if;
2461: elsif l_work_no is not null then
2462: if length(l_work_no) not between 9 and 11 then
2463: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2464: fnd_message.set_token('FIELD', 'Work Telephone Number');
2465: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2466: l_msg_count := l_msg_count + 1;
2467: end if;
2468: if validate_character_set(l_work_no,'NUMERIC') = FALSE then

Line 2465: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2461: elsif l_work_no is not null then
2462: if length(l_work_no) not between 9 and 11 then
2463: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2464: fnd_message.set_token('FIELD', 'Work Telephone Number');
2465: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2466: l_msg_count := l_msg_count + 1;
2467: end if;
2468: if validate_character_set(l_work_no,'NUMERIC') = FALSE then
2469: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2469: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2465: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2466: l_msg_count := l_msg_count + 1;
2467: end if;
2468: if validate_character_set(l_work_no,'NUMERIC') = FALSE then
2469: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2470: fnd_message.set_token('FIELD', 'Work Telephone Number');
2471: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2472: l_msg_count := l_msg_count + 1;
2473: end if;

Line 2470: fnd_message.set_token('FIELD', 'Work Telephone Number');

2466: l_msg_count := l_msg_count + 1;
2467: end if;
2468: if validate_character_set(l_work_no,'NUMERIC') = FALSE then
2469: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2470: fnd_message.set_token('FIELD', 'Work Telephone Number');
2471: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2472: l_msg_count := l_msg_count + 1;
2473: end if;
2474: end if;

Line 2471: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2467: end if;
2468: if validate_character_set(l_work_no,'NUMERIC') = FALSE then
2469: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2470: fnd_message.set_token('FIELD', 'Work Telephone Number');
2471: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2472: l_msg_count := l_msg_count + 1;
2473: end if;
2474: end if;
2475:

Line 2492: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');

2488: end if;
2489:
2490: if l_fax is not null then
2491: if length(l_fax) not between 9 and 11 then
2492: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2493: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2494: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2495: l_msg_count := l_msg_count + 1;
2496: end if;

Line 2493: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');

2489:
2490: if l_fax is not null then
2491: if length(l_fax) not between 9 and 11 then
2492: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2493: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2494: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2495: l_msg_count := l_msg_count + 1;
2496: end if;
2497: if validate_character_set(l_fax,'NUMERIC') = FALSE then

Line 2494: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2490: if l_fax is not null then
2491: if length(l_fax) not between 9 and 11 then
2492: fnd_message.set_name('PER', 'HR_ZA_INVALID_PH_NO');
2493: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2494: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2495: l_msg_count := l_msg_count + 1;
2496: end if;
2497: if validate_character_set(l_fax,'NUMERIC') = FALSE then
2498: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2498: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2494: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2495: l_msg_count := l_msg_count + 1;
2496: end if;
2497: if validate_character_set(l_fax,'NUMERIC') = FALSE then
2498: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2499: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2500: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2501: l_msg_count := l_msg_count + 1;
2502: end if;

Line 2499: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');

2495: l_msg_count := l_msg_count + 1;
2496: end if;
2497: if validate_character_set(l_fax,'NUMERIC') = FALSE then
2498: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2499: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2500: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2501: l_msg_count := l_msg_count + 1;
2502: end if;
2503: end if;

Line 2500: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2496: end if;
2497: if validate_character_set(l_fax,'NUMERIC') = FALSE then
2498: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2499: fnd_message.set_token('FIELD', 'Work Fax/ Home Fax');
2500: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2501: l_msg_count := l_msg_count + 1;
2502: end if;
2503: end if;
2504:

Line 2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');

2509: close csr_phones;
2510:
2511: if l_cell_no is not null then
2512: if length(l_cell_no) <> 10 then
2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2514: fnd_message.set_token('FIELD', 'Mobile Number');
2515: fnd_message.set_token('LENGTH', '10');
2516: fnd_message.set_token('UNITS', 'digits');
2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */

Line 2514: fnd_message.set_token('FIELD', 'Mobile Number');

2510:
2511: if l_cell_no is not null then
2512: if length(l_cell_no) <> 10 then
2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2514: fnd_message.set_token('FIELD', 'Mobile Number');
2515: fnd_message.set_token('LENGTH', '10');
2516: fnd_message.set_token('UNITS', 'digits');
2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */
2518: p_ee_msg_tab(l_msg_count):='The Mobile Number is invalid. Its length must be between 10 and 11 digits.';

Line 2515: fnd_message.set_token('LENGTH', '10');

2511: if l_cell_no is not null then
2512: if length(l_cell_no) <> 10 then
2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2514: fnd_message.set_token('FIELD', 'Mobile Number');
2515: fnd_message.set_token('LENGTH', '10');
2516: fnd_message.set_token('UNITS', 'digits');
2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */
2518: p_ee_msg_tab(l_msg_count):='The Mobile Number is invalid. Its length must be between 10 and 11 digits.';
2519: l_msg_count := l_msg_count + 1;

Line 2516: fnd_message.set_token('UNITS', 'digits');

2512: if length(l_cell_no) <> 10 then
2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2514: fnd_message.set_token('FIELD', 'Mobile Number');
2515: fnd_message.set_token('LENGTH', '10');
2516: fnd_message.set_token('UNITS', 'digits');
2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */
2518: p_ee_msg_tab(l_msg_count):='The Mobile Number is invalid. Its length must be between 10 and 11 digits.';
2519: l_msg_count := l_msg_count + 1;
2520: end if;

Line 2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */

2513: /* fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2514: fnd_message.set_token('FIELD', 'Mobile Number');
2515: fnd_message.set_token('LENGTH', '10');
2516: fnd_message.set_token('UNITS', 'digits');
2517: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y'); */
2518: p_ee_msg_tab(l_msg_count):='The Mobile Number is invalid. Its length must be between 10 and 11 digits.';
2519: l_msg_count := l_msg_count + 1;
2520: end if;
2521: if validate_character_set(l_cell_no,'NUMERIC') = FALSE then

Line 2522: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2518: p_ee_msg_tab(l_msg_count):='The Mobile Number is invalid. Its length must be between 10 and 11 digits.';
2519: l_msg_count := l_msg_count + 1;
2520: end if;
2521: if validate_character_set(l_cell_no,'NUMERIC') = FALSE then
2522: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2523: fnd_message.set_token('FIELD', 'Mobile Number');
2524: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2525: l_msg_count := l_msg_count + 1;
2526: end if;

Line 2523: fnd_message.set_token('FIELD', 'Mobile Number');

2519: l_msg_count := l_msg_count + 1;
2520: end if;
2521: if validate_character_set(l_cell_no,'NUMERIC') = FALSE then
2522: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2523: fnd_message.set_token('FIELD', 'Mobile Number');
2524: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2525: l_msg_count := l_msg_count + 1;
2526: end if;
2527: end if;

Line 2524: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2520: end if;
2521: if validate_character_set(l_cell_no,'NUMERIC') = FALSE then
2522: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2523: fnd_message.set_token('FIELD', 'Mobile Number');
2524: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2525: l_msg_count := l_msg_count + 1;
2526: end if;
2527: end if;
2528:

Line 2563: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');

2559: if ((p_emp_num is null)
2560: or (length(p_emp_num) > 25 or per_za_user_hook_pkg.validate_charcter_set(p_emp_num, 'FREETEXT')= FALSE))
2561: then
2562:
2563: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');
2564: fnd_message.raise_error;
2565: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2566: l_msg_count := l_msg_count + 1;
2567:

Line 2564: fnd_message.raise_error;

2560: or (length(p_emp_num) > 25 or per_za_user_hook_pkg.validate_charcter_set(p_emp_num, 'FREETEXT')= FALSE))
2561: then
2562:
2563: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');
2564: fnd_message.raise_error;
2565: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2566: l_msg_count := l_msg_count + 1;
2567:
2568: end if;

Line 2565: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2561: then
2562:
2563: fnd_message.set_name('PER', 'HR_ZA_INVALID_EMP_NO');
2564: fnd_message.raise_error;
2565: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2566: l_msg_count := l_msg_count + 1;
2567:
2568: end if;
2569:

Line 2613: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NATURE_PERSON');

2609: --Validate Nature of Person (Code 3020)
2610: hr_utility.set_location('Validation Nature of Person -Code 3020',10);
2611: if p_nature is null then
2612: hr_utility.set_location('Nature of Person is null',10);
2613: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NATURE_PERSON');
2614: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2615: l_msg_count := l_msg_count + 1;
2616: elsif p_nature = 'M' then
2617: hr_utility.set_location('Nature of Person is M',10);

Line 2614: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2610: hr_utility.set_location('Validation Nature of Person -Code 3020',10);
2611: if p_nature is null then
2612: hr_utility.set_location('Nature of Person is null',10);
2613: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NATURE_PERSON');
2614: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2615: l_msg_count := l_msg_count + 1;
2616: elsif p_nature = 'M' then
2617: hr_utility.set_location('Nature of Person is M',10);
2618: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');

Line 2618: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');

2614: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2615: l_msg_count := l_msg_count + 1;
2616: elsif p_nature = 'M' then
2617: hr_utility.set_location('Nature of Person is M',10);
2618: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2619: fnd_message.set_token('NATURE', 'M');
2620: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2621: l_msg_count := l_msg_count + 1;
2622: elsif p_nature = 'K' then

Line 2619: fnd_message.set_token('NATURE', 'M');

2615: l_msg_count := l_msg_count + 1;
2616: elsif p_nature = 'M' then
2617: hr_utility.set_location('Nature of Person is M',10);
2618: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2619: fnd_message.set_token('NATURE', 'M');
2620: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2621: l_msg_count := l_msg_count + 1;
2622: elsif p_nature = 'K' then
2623: hr_utility.set_location('Nature of Person is K',10);

Line 2620: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2616: elsif p_nature = 'M' then
2617: hr_utility.set_location('Nature of Person is M',10);
2618: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2619: fnd_message.set_token('NATURE', 'M');
2620: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2621: l_msg_count := l_msg_count + 1;
2622: elsif p_nature = 'K' then
2623: hr_utility.set_location('Nature of Person is K',10);
2624: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');

Line 2624: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');

2620: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2621: l_msg_count := l_msg_count + 1;
2622: elsif p_nature = 'K' then
2623: hr_utility.set_location('Nature of Person is K',10);
2624: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2625: fnd_message.set_token('NATURE', 'K');
2626: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2627: l_msg_count := l_msg_count + 1;
2628: end if;

Line 2625: fnd_message.set_token('NATURE', 'K');

2621: l_msg_count := l_msg_count + 1;
2622: elsif p_nature = 'K' then
2623: hr_utility.set_location('Nature of Person is K',10);
2624: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2625: fnd_message.set_token('NATURE', 'K');
2626: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2627: l_msg_count := l_msg_count + 1;
2628: end if;
2629:

Line 2626: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2622: elsif p_nature = 'K' then
2623: hr_utility.set_location('Nature of Person is K',10);
2624: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NATURE_PERSON');
2625: fnd_message.set_token('NATURE', 'K');
2626: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2627: l_msg_count := l_msg_count + 1;
2628: end if;
2629:
2630: -- Validate Code Employee Surname/Trading Name (Code 3030)

Line 2635: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');

2631: hr_utility.set_location('Validation EE Surname/Trading Name -Code 3030',15);
2632: if p_nature in ('D','E','F','G','H') then
2633: if p_trading_name is null then
2634: hr_utility.set_location('EE Surname is null',15);
2635: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
2636: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2637: l_msg_count := l_msg_count + 1;
2638: elsif validate_character_set(p_trading_name,'FREETEXT')= FALSE then
2639: hr_utility.set_location('EE Surname contains invalid characters',15);

Line 2636: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2632: if p_nature in ('D','E','F','G','H') then
2633: if p_trading_name is null then
2634: hr_utility.set_location('EE Surname is null',15);
2635: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_DEFGH_TRADE');
2636: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2637: l_msg_count := l_msg_count + 1;
2638: elsif validate_character_set(p_trading_name,'FREETEXT')= FALSE then
2639: hr_utility.set_location('EE Surname contains invalid characters',15);
2640: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2640: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2636: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2637: l_msg_count := l_msg_count + 1;
2638: elsif validate_character_set(p_trading_name,'FREETEXT')= FALSE then
2639: hr_utility.set_location('EE Surname contains invalid characters',15);
2640: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2641: fnd_message.set_token('FIELD', 'Employee Trading Name');
2642: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2643: l_msg_count := l_msg_count + 1;
2644: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010

Line 2641: fnd_message.set_token('FIELD', 'Employee Trading Name');

2637: l_msg_count := l_msg_count + 1;
2638: elsif validate_character_set(p_trading_name,'FREETEXT')= FALSE then
2639: hr_utility.set_location('EE Surname contains invalid characters',15);
2640: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2641: fnd_message.set_token('FIELD', 'Employee Trading Name');
2642: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2643: l_msg_count := l_msg_count + 1;
2644: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2645: elsif translate(p_trading_name,'~/\*?:><|','~') is not null OR instr(p_trading_name,'""')<>0 then

Line 2642: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2638: elsif validate_character_set(p_trading_name,'FREETEXT')= FALSE then
2639: hr_utility.set_location('EE Surname contains invalid characters',15);
2640: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2641: fnd_message.set_token('FIELD', 'Employee Trading Name');
2642: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2643: l_msg_count := l_msg_count + 1;
2644: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2645: elsif translate(p_trading_name,'~/\*?:><|','~') is not null OR instr(p_trading_name,'""')<>0 then
2646: hr_utility.set_location('EE Surname contains invalid characters',15);

Line 2647: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2643: l_msg_count := l_msg_count + 1;
2644: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2645: elsif translate(p_trading_name,'~/\*?:><|','~') is not null OR instr(p_trading_name,'""')<>0 then
2646: hr_utility.set_location('EE Surname contains invalid characters',15);
2647: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2648: fnd_message.set_token('FIELD', 'Employee Trading Name');
2649: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2650: l_msg_count := l_msg_count + 1; */
2651: end if;

Line 2648: fnd_message.set_token('FIELD', 'Employee Trading Name');

2644: /* Commented as per revision 8.0.0 of SARS PAYE Reconiliation 2010
2645: elsif translate(p_trading_name,'~/\*?:><|','~') is not null OR instr(p_trading_name,'""')<>0 then
2646: hr_utility.set_location('EE Surname contains invalid characters',15);
2647: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2648: fnd_message.set_token('FIELD', 'Employee Trading Name');
2649: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2650: l_msg_count := l_msg_count + 1; */
2651: end if;
2652: elsif p_nature in ('A','B','C','N') then

Line 2649: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2645: elsif translate(p_trading_name,'~/\*?:><|','~') is not null OR instr(p_trading_name,'""')<>0 then
2646: hr_utility.set_location('EE Surname contains invalid characters',15);
2647: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2648: fnd_message.set_token('FIELD', 'Employee Trading Name');
2649: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2650: l_msg_count := l_msg_count + 1; */
2651: end if;
2652: elsif p_nature in ('A','B','C','N') then
2653: --Validate code 3030

Line 2657: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');

2653: --Validate code 3030
2654: --Checking IF the Surname IS Null
2655: IF p_lname IS NULL then
2656: hr_utility.set_location('EE Surname is null',16);
2657: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
2658: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
2659: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2660: l_msg_count := l_msg_count + 1;
2661: END if;

Line 2658: -- fnd_message.set_token('FIELD', 'Employee''s Surname');

2654: --Checking IF the Surname IS Null
2655: IF p_lname IS NULL then
2656: hr_utility.set_location('EE Surname is null',16);
2657: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
2658: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
2659: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2660: l_msg_count := l_msg_count + 1;
2661: END if;
2662: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/

Line 2659: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2655: IF p_lname IS NULL then
2656: hr_utility.set_location('EE Surname is null',16);
2657: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABC_S_F_NAME');
2658: -- fnd_message.set_token('FIELD', 'Employee''s Surname');
2659: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2660: l_msg_count := l_msg_count + 1;
2661: END if;
2662: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/
2663: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */

Line 2666: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2662: /* commented as the numeric are allowed in 3030 as it is free text bug 9507670*/
2663: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */
2664: if nvl(length(translate(p_lname,'~0123456789','~')),0) <> length(p_lname) then
2665: hr_utility.set_location('EE last name contains invalid characters',15);
2666: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2667: fnd_message.set_token('FIELD', 'Employee''s Surname');
2668: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2669: l_msg_count := l_msg_count + 1;
2670: end if;

Line 2667: fnd_message.set_token('FIELD', 'Employee''s Surname');

2663: /* uncommented for Aug 2010 reconciliation phase II as numeric are not allowed in 3030 */
2664: if nvl(length(translate(p_lname,'~0123456789','~')),0) <> length(p_lname) then
2665: hr_utility.set_location('EE last name contains invalid characters',15);
2666: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2667: fnd_message.set_token('FIELD', 'Employee''s Surname');
2668: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2669: l_msg_count := l_msg_count + 1;
2670: end if;
2671: end if;

Line 2668: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2664: if nvl(length(translate(p_lname,'~0123456789','~')),0) <> length(p_lname) then
2665: hr_utility.set_location('EE last name contains invalid characters',15);
2666: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2667: fnd_message.set_token('FIELD', 'Employee''s Surname');
2668: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2669: l_msg_count := l_msg_count + 1;
2670: end if;
2671: end if;
2672:

Line 2677: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABCN_F_NAME');

2673: --Validate First Two Names ( Code 3040 )
2674: hr_utility.set_location('Validation First Two Names -Code 3040',20);
2675: if p_nature in ('A','B','C','N') then
2676: if p_fname is null and p_mname is null then
2677: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABCN_F_NAME');
2678: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2679: l_msg_count := l_msg_count + 1;
2680: /* ucommented as the numeric are not allowed in first two Names bug 9507670*/
2681: elsif nvl(length(translate(p_fname,'~0123456789','~')),0) <> nvl(length(p_fname),0)

Line 2678: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2674: hr_utility.set_location('Validation First Two Names -Code 3040',20);
2675: if p_nature in ('A','B','C','N') then
2676: if p_fname is null and p_mname is null then
2677: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ABCN_F_NAME');
2678: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2679: l_msg_count := l_msg_count + 1;
2680: /* ucommented as the numeric are not allowed in first two Names bug 9507670*/
2681: elsif nvl(length(translate(p_fname,'~0123456789','~')),0) <> nvl(length(p_fname),0)
2682: OR nvl(length(translate(p_mname,'~0123456789','~')),0) <> nvl(length(p_mname),0) then

Line 2683: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2679: l_msg_count := l_msg_count + 1;
2680: /* ucommented as the numeric are not allowed in first two Names bug 9507670*/
2681: elsif nvl(length(translate(p_fname,'~0123456789','~')),0) <> nvl(length(p_fname),0)
2682: OR nvl(length(translate(p_mname,'~0123456789','~')),0) <> nvl(length(p_mname),0) then
2683: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2684: fnd_message.set_token('FIELD', 'First or Middle Name');
2685: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2686: l_msg_count := l_msg_count + 1;
2687: end if;

Line 2684: fnd_message.set_token('FIELD', 'First or Middle Name');

2680: /* ucommented as the numeric are not allowed in first two Names bug 9507670*/
2681: elsif nvl(length(translate(p_fname,'~0123456789','~')),0) <> nvl(length(p_fname),0)
2682: OR nvl(length(translate(p_mname,'~0123456789','~')),0) <> nvl(length(p_mname),0) then
2683: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2684: fnd_message.set_token('FIELD', 'First or Middle Name');
2685: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2686: l_msg_count := l_msg_count + 1;
2687: end if;
2688:

Line 2685: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2681: elsif nvl(length(translate(p_fname,'~0123456789','~')),0) <> nvl(length(p_fname),0)
2682: OR nvl(length(translate(p_mname,'~0123456789','~')),0) <> nvl(length(p_mname),0) then
2683: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2684: fnd_message.set_token('FIELD', 'First or Middle Name');
2685: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2686: l_msg_count := l_msg_count + 1;
2687: end if;
2688:
2689: --First and Middle name contains invalid characters only

Line 2695: fnd_message.set_name('PAY', 'PY_ZA_INVALID_INITIALS');

2691: --Validate Initials
2692: if nvl(length(translate(p_fname,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
2693: AND nvl(length(translate(p_mname,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
2694: AND (p_fname is not null OR p_mname is not null) then
2695: fnd_message.set_name('PAY', 'PY_ZA_INVALID_INITIALS');
2696: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2697: l_msg_count := l_msg_count + 1;
2698: end if;
2699: end if;

Line 2696: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2692: if nvl(length(translate(p_fname,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
2693: AND nvl(length(translate(p_mname,l_invalid_char||l_alpha,l_invalid_char)),0) = 0
2694: AND (p_fname is not null OR p_mname is not null) then
2695: fnd_message.set_name('PAY', 'PY_ZA_INVALID_INITIALS');
2696: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2697: l_msg_count := l_msg_count + 1;
2698: end if;
2699: end if;
2700:

Line 2706: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ACN_ID_PASSNO');

2702: --Validate Identity Number (Code 3060)
2703: hr_utility.set_location('Validating Identity Number -Code 3060',22);
2704: if p_nature in ('A','C','N') then
2705: if p_ni is null and p_passport_no is null and p_nature <> 'N' then
2706: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ACN_ID_PASSNO');
2707: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2708: l_msg_count := l_msg_count + 1;
2709: end if;
2710: if nvl(length(p_ni),13)<>13 then

Line 2707: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2703: hr_utility.set_location('Validating Identity Number -Code 3060',22);
2704: if p_nature in ('A','C','N') then
2705: if p_ni is null and p_passport_no is null and p_nature <> 'N' then
2706: fnd_message.set_name('PAY', 'PY_ZA_ENTER_NAT_ACN_ID_PASSNO');
2707: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2708: l_msg_count := l_msg_count + 1;
2709: end if;
2710: if nvl(length(p_ni),13)<>13 then
2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');

Line 2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');

2707: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2708: l_msg_count := l_msg_count + 1;
2709: end if;
2710: if nvl(length(p_ni),13)<>13 then
2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2712: fnd_message.set_token('FIELD', 'ID Number');
2713: fnd_message.set_token('LENGTH', '13');
2714: fnd_message.set_token('UNITS', 'digits');
2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

Line 2712: fnd_message.set_token('FIELD', 'ID Number');

2708: l_msg_count := l_msg_count + 1;
2709: end if;
2710: if nvl(length(p_ni),13)<>13 then
2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2712: fnd_message.set_token('FIELD', 'ID Number');
2713: fnd_message.set_token('LENGTH', '13');
2714: fnd_message.set_token('UNITS', 'digits');
2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2716: l_msg_count := l_msg_count + 1;

Line 2713: fnd_message.set_token('LENGTH', '13');

2709: end if;
2710: if nvl(length(p_ni),13)<>13 then
2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2712: fnd_message.set_token('FIELD', 'ID Number');
2713: fnd_message.set_token('LENGTH', '13');
2714: fnd_message.set_token('UNITS', 'digits');
2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2716: l_msg_count := l_msg_count + 1;
2717: end if;

Line 2714: fnd_message.set_token('UNITS', 'digits');

2710: if nvl(length(p_ni),13)<>13 then
2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2712: fnd_message.set_token('FIELD', 'ID Number');
2713: fnd_message.set_token('LENGTH', '13');
2714: fnd_message.set_token('UNITS', 'digits');
2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2716: l_msg_count := l_msg_count + 1;
2717: end if;
2718: if validate_character_set(p_ni,'NUMERIC')= FALSE then

Line 2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2711: fnd_message.set_name('PER', 'HR_ZA_INVALID_LENGTH');
2712: fnd_message.set_token('FIELD', 'ID Number');
2713: fnd_message.set_token('LENGTH', '13');
2714: fnd_message.set_token('UNITS', 'digits');
2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2716: l_msg_count := l_msg_count + 1;
2717: end if;
2718: if validate_character_set(p_ni,'NUMERIC')= FALSE then
2719: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2719: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2715: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2716: l_msg_count := l_msg_count + 1;
2717: end if;
2718: if validate_character_set(p_ni,'NUMERIC')= FALSE then
2719: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2720: fnd_message.set_token('FIELD', 'ID Number');
2721: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2722: l_msg_count := l_msg_count + 1;
2723: end if;

Line 2720: fnd_message.set_token('FIELD', 'ID Number');

2716: l_msg_count := l_msg_count + 1;
2717: end if;
2718: if validate_character_set(p_ni,'NUMERIC')= FALSE then
2719: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2720: fnd_message.set_token('FIELD', 'ID Number');
2721: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2722: l_msg_count := l_msg_count + 1;
2723: end if;
2724: if p_ni is not null then

Line 2721: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2717: end if;
2718: if validate_character_set(p_ni,'NUMERIC')= FALSE then
2719: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2720: fnd_message.set_token('FIELD', 'ID Number');
2721: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2722: l_msg_count := l_msg_count + 1;
2723: end if;
2724: if p_ni is not null then
2725: if modulus_13_test(p_ni)=0 then

Line 2726: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');

2722: l_msg_count := l_msg_count + 1;
2723: end if;
2724: if p_ni is not null then
2725: if modulus_13_test(p_ni)=0 then
2726: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');
2727: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2728: l_msg_count := l_msg_count + 1;
2729: end if;
2730: end if;

Line 2727: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2723: end if;
2724: if p_ni is not null then
2725: if modulus_13_test(p_ni)=0 then
2726: fnd_message.set_name('PER', 'HR_ZA_INVALID_NI');
2727: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2728: l_msg_count := l_msg_count + 1;
2729: end if;
2730: end if;
2731: if p_id_dob = 0 then

Line 2732: fnd_message.set_name('PAY', 'PY_ZA_INVALID_ID_DOB_CORRELAT');

2728: l_msg_count := l_msg_count + 1;
2729: end if;
2730: end if;
2731: if p_id_dob = 0 then
2732: fnd_message.set_name('PAY', 'PY_ZA_INVALID_ID_DOB_CORRELAT');
2733: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2734: l_msg_count := l_msg_count + 1;
2735: end if;
2736: end if;

Line 2733: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2729: end if;
2730: end if;
2731: if p_id_dob = 0 then
2732: fnd_message.set_name('PAY', 'PY_ZA_INVALID_ID_DOB_CORRELAT');
2733: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2734: l_msg_count := l_msg_count + 1;
2735: end if;
2736: end if;
2737:

Line 2745: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');

2741: -- bug 12914879
2742: -- if length(p_passport_no)< 7 then
2743: if length(p_passport_no)< 6 then
2744: -- bug 12914879
2745: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2746: fnd_message.set_token('FIELD', 'Passport Number');
2747: -- bug 12914879
2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');

Line 2746: fnd_message.set_token('FIELD', 'Passport Number');

2742: -- if length(p_passport_no)< 7 then
2743: if length(p_passport_no)< 6 then
2744: -- bug 12914879
2745: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2746: fnd_message.set_token('FIELD', 'Passport Number');
2747: -- bug 12914879
2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');
2750: -- bug 12914879

Line 2748: -- fnd_message.set_token('LENGTH', '7');

2744: -- bug 12914879
2745: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2746: fnd_message.set_token('FIELD', 'Passport Number');
2747: -- bug 12914879
2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');
2750: -- bug 12914879
2751: fnd_message.set_token('UNITS', 'characters');
2752: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

Line 2749: fnd_message.set_token('LENGTH', '6');

2745: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2746: fnd_message.set_token('FIELD', 'Passport Number');
2747: -- bug 12914879
2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');
2750: -- bug 12914879
2751: fnd_message.set_token('UNITS', 'characters');
2752: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2753: l_msg_count := l_msg_count + 1;

Line 2751: fnd_message.set_token('UNITS', 'characters');

2747: -- bug 12914879
2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');
2750: -- bug 12914879
2751: fnd_message.set_token('UNITS', 'characters');
2752: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2753: l_msg_count := l_msg_count + 1;
2754: end if;
2755:

Line 2752: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2748: -- fnd_message.set_token('LENGTH', '7');
2749: fnd_message.set_token('LENGTH', '6');
2750: -- bug 12914879
2751: fnd_message.set_token('UNITS', 'characters');
2752: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2753: l_msg_count := l_msg_count + 1;
2754: end if;
2755:
2756: -- bug 13006122

Line 2760: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');

2756: -- bug 13006122
2757:
2758: if length(p_passport_no)> 13 then
2759:
2760: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2761: fnd_message.set_token('FIELD', 'Passport Number picked');
2762:
2763: fnd_message.set_token('LENGTH', '13');
2764:

Line 2761: fnd_message.set_token('FIELD', 'Passport Number picked');

2757:
2758: if length(p_passport_no)> 13 then
2759:
2760: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2761: fnd_message.set_token('FIELD', 'Passport Number picked');
2762:
2763: fnd_message.set_token('LENGTH', '13');
2764:
2765: fnd_message.set_token('UNITS', 'characters');

Line 2763: fnd_message.set_token('LENGTH', '13');

2759:
2760: fnd_message.set_name('PAY', 'PY_ZA_INVALID_MIN_LENGTH');
2761: fnd_message.set_token('FIELD', 'Passport Number picked');
2762:
2763: fnd_message.set_token('LENGTH', '13');
2764:
2765: fnd_message.set_token('UNITS', 'characters');
2766: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2767: l_msg_count := l_msg_count + 1;

Line 2765: fnd_message.set_token('UNITS', 'characters');

2761: fnd_message.set_token('FIELD', 'Passport Number picked');
2762:
2763: fnd_message.set_token('LENGTH', '13');
2764:
2765: fnd_message.set_token('UNITS', 'characters');
2766: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2767: l_msg_count := l_msg_count + 1;
2768: end if;
2769:

Line 2766: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2762:
2763: fnd_message.set_token('LENGTH', '13');
2764:
2765: fnd_message.set_token('UNITS', 'characters');
2766: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2767: l_msg_count := l_msg_count + 1;
2768: end if;
2769:
2770: -- bug 13006122 ends

Line 2773: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2769:
2770: -- bug 13006122 ends
2771:
2772: if validate_character_set(p_passport_no,'ALPHANUM')= FALSE then
2773: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2774: fnd_message.set_token('FIELD', 'Passport Number');
2775: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2776: l_msg_count := l_msg_count + 1;
2777: end if;

Line 2774: fnd_message.set_token('FIELD', 'Passport Number');

2770: -- bug 13006122 ends
2771:
2772: if validate_character_set(p_passport_no,'ALPHANUM')= FALSE then
2773: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2774: fnd_message.set_token('FIELD', 'Passport Number');
2775: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2776: l_msg_count := l_msg_count + 1;
2777: end if;
2778: end if;

Line 2775: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2771:
2772: if validate_character_set(p_passport_no,'ALPHANUM')= FALSE then
2773: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2774: fnd_message.set_token('FIELD', 'Passport Number');
2775: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2776: l_msg_count := l_msg_count + 1;
2777: end if;
2778: end if;
2779:

Line 2784: fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');

2780: --Validate Country of Issue ( Code 3075 )
2781: --If Nature of Person is B, then country of Issue is archived as ZNC, hence validation not required.
2782: hr_utility.set_location('Validating Country of Issue -Code 3075',25);
2783: if p_country_passport is null and p_passport_no is not null then -- 9877034 fix removed B and N
2784: fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
2785: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
2786: if p_tax_year = 2010 then
2787: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2788: l_warn_count := l_warn_count + 1;

Line 2787: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

2783: if p_country_passport is null and p_passport_no is not null then -- 9877034 fix removed B and N
2784: fnd_message.set_name('PAY', 'PY_ZA_ENTER_PASS_COUNTRY_ISSUE');
2785: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
2786: if p_tax_year = 2010 then
2787: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2788: l_warn_count := l_warn_count + 1;
2789: else
2790: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2791: l_msg_count := l_msg_count + 1;

Line 2790: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2786: if p_tax_year = 2010 then
2787: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2788: l_warn_count := l_warn_count + 1;
2789: else
2790: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2791: l_msg_count := l_msg_count + 1;
2792: end if;
2793: elsif p_country_passport is not null then
2794: if validate_character_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B

Line 2795: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2791: l_msg_count := l_msg_count + 1;
2792: end if;
2793: elsif p_country_passport is not null then
2794: if validate_character_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
2795: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2796: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2797: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2798: l_msg_count := l_msg_count + 1;
2799: end if;

Line 2796: fnd_message.set_token('FIELD', 'Country of Passport Issue');

2792: end if;
2793: elsif p_country_passport is not null then
2794: if validate_character_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
2795: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2796: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2797: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2798: l_msg_count := l_msg_count + 1;
2799: end if;
2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B

Line 2797: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2793: elsif p_country_passport is not null then
2794: if validate_character_set(p_country_passport,'ALPHA')= FALSE then -- 9877034 fix removed B
2795: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2796: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2797: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2798: l_msg_count := l_msg_count + 1;
2799: end if;
2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B
2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');

Line 2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');

2797: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2798: l_msg_count := l_msg_count + 1;
2799: end if;
2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B
2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2803: fnd_message.set_token('LENGTH', '3');
2804: fnd_message.set_token('UNITS', 'characters');
2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

Line 2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');

2798: l_msg_count := l_msg_count + 1;
2799: end if;
2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B
2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2803: fnd_message.set_token('LENGTH', '3');
2804: fnd_message.set_token('UNITS', 'characters');
2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2806: l_msg_count := l_msg_count + 1;

Line 2803: fnd_message.set_token('LENGTH', '3');

2799: end if;
2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B
2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2803: fnd_message.set_token('LENGTH', '3');
2804: fnd_message.set_token('UNITS', 'characters');
2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2806: l_msg_count := l_msg_count + 1;
2807: end if;

Line 2804: fnd_message.set_token('UNITS', 'characters');

2800: if length(p_country_passport)> 3 then -- 9877034 fix removed B
2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2803: fnd_message.set_token('LENGTH', '3');
2804: fnd_message.set_token('UNITS', 'characters');
2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2806: l_msg_count := l_msg_count + 1;
2807: end if;
2808: end if;

Line 2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2801: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2802: fnd_message.set_token('FIELD', 'Country of Passport Issue');
2803: fnd_message.set_token('LENGTH', '3');
2804: fnd_message.set_token('UNITS', 'characters');
2805: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2806: l_msg_count := l_msg_count + 1;
2807: end if;
2808: end if;
2809:

Line 2813: fnd_message.set_name('PAY', 'PY_ZA_ENTER_IT_TAX_NO');

2809:
2810: --Validate code Income Tax Number (Code 3100)
2811: hr_utility.set_location('Validating Income Tax Number -Code 3100',27);
2812: if p_it_no_value is null and p_cert_type <> '2' and p_nature <> 'F' then
2813: fnd_message.set_name('PAY', 'PY_ZA_ENTER_IT_TAX_NO');
2814: --Made a warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
2815: /* Bug no 9939519 changes specific to Aug 2010 changes
2816: Added Or condition to make it warning for Aug Submission for from Feb2011 its an error.
2817: */

Line 2822: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

2818: if p_tax_year = 2010
2819: OR
2820: ( p_tax_year = 2011 and P_PERIOD_RECON = '08')
2821: then
2822: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2823: l_warn_count := l_warn_count + 1;
2824: else
2825: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2826: l_msg_count := l_msg_count + 1;

Line 2825: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2821: then
2822: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
2823: l_warn_count := l_warn_count + 1;
2824: else
2825: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2826: l_msg_count := l_msg_count + 1;
2827: end if;
2828: elsif p_it_no_value is not null and p_nature <> 'F' then
2829: --Check the modulus 10 test

Line 2831: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');

2827: end if;
2828: elsif p_it_no_value is not null and p_nature <> 'F' then
2829: --Check the modulus 10 test
2830: if p_it_no_val = 0 then
2831: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
2832: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2833: l_msg_count := l_msg_count + 1;
2834: end if;
2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then

Line 2832: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2828: elsif p_it_no_value is not null and p_nature <> 'F' then
2829: --Check the modulus 10 test
2830: if p_it_no_val = 0 then
2831: fnd_message.set_name('PAY', 'PY_ZA_INVALID_IT_TAX_NO');
2832: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2833: l_msg_count := l_msg_count + 1;
2834: end if;
2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');

Line 2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');

2832: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2833: l_msg_count := l_msg_count + 1;
2834: end if;
2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2837: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;

Line 2837: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');

2833: l_msg_count := l_msg_count + 1;
2834: end if;
2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2837: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then

Line 2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');

2834: end if;
2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2837: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');

Line 2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2835: if p_nature in ('A','B','C','D','N') and substr(p_it_no_value,1,1) not in ('0','1','2','3') then
2836: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2837: fnd_message.set_token('VALID_NUM', '0, 1, 2 or 3');
2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2843: fnd_message.set_token('VALID_NUM', '9');

Line 2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');

2838: fnd_message.set_token('VALID_NATURE', 'A, B, C, D, or N');
2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2843: fnd_message.set_token('VALID_NUM', '9');
2844: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2846: l_msg_count := l_msg_count + 1;

Line 2843: fnd_message.set_token('VALID_NUM', '9');

2839: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2843: fnd_message.set_token('VALID_NUM', '9');
2844: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2846: l_msg_count := l_msg_count + 1;
2847: end if;

Line 2844: fnd_message.set_token('VALID_NATURE', 'E, G, or H');

2840: l_msg_count := l_msg_count + 1;
2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2843: fnd_message.set_token('VALID_NUM', '9');
2844: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2846: l_msg_count := l_msg_count + 1;
2847: end if;
2848: if validate_character_set(p_it_no_value,'NUMERIC')= FALSE then

Line 2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2841: elsif p_nature in ('E','G','H') and substr(p_it_no_value,1,1) <> '9' then
2842: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NAT_IT_TAX_NO');
2843: fnd_message.set_token('VALID_NUM', '9');
2844: fnd_message.set_token('VALID_NATURE', 'E, G, or H');
2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2846: l_msg_count := l_msg_count + 1;
2847: end if;
2848: if validate_character_set(p_it_no_value,'NUMERIC')= FALSE then
2849: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2849: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2845: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2846: l_msg_count := l_msg_count + 1;
2847: end if;
2848: if validate_character_set(p_it_no_value,'NUMERIC')= FALSE then
2849: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2850: fnd_message.set_token('FIELD', 'Income Tax Number');
2851: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2852: l_msg_count := l_msg_count + 1;
2853: end if;

Line 2850: fnd_message.set_token('FIELD', 'Income Tax Number');

2846: l_msg_count := l_msg_count + 1;
2847: end if;
2848: if validate_character_set(p_it_no_value,'NUMERIC')= FALSE then
2849: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2850: fnd_message.set_token('FIELD', 'Income Tax Number');
2851: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2852: l_msg_count := l_msg_count + 1;
2853: end if;
2854: end if;

Line 2851: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2847: end if;
2848: if validate_character_set(p_it_no_value,'NUMERIC')= FALSE then
2849: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2850: fnd_message.set_token('FIELD', 'Income Tax Number');
2851: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2852: l_msg_count := l_msg_count + 1;
2853: end if;
2854: end if;
2855:

Line 2861: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2857: -- Commenting out the Validation for Employee Number as the validation is already done.
2858: /*
2859: --Validate Employee Number (Code 3160)
2860: if validate_character_set(P_EMPNO,'ALPHANUM')= FALSE then
2861: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2862: fnd_message.set_token('FIELD', 'Employee Number');
2863: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2864: l_msg_count := l_msg_count + 1;
2865: end if;

Line 2862: fnd_message.set_token('FIELD', 'Employee Number');

2858: /*
2859: --Validate Employee Number (Code 3160)
2860: if validate_character_set(P_EMPNO,'ALPHANUM')= FALSE then
2861: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2862: fnd_message.set_token('FIELD', 'Employee Number');
2863: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2864: l_msg_count := l_msg_count + 1;
2865: end if;
2866:

Line 2863: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2859: --Validate Employee Number (Code 3160)
2860: if validate_character_set(P_EMPNO,'ALPHANUM')= FALSE then
2861: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2862: fnd_message.set_token('FIELD', 'Employee Number');
2863: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2864: l_msg_count := l_msg_count + 1;
2865: end if;
2866:
2867: */

Line 2897: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');

2893: -- Validate email id (Code 3125)
2894: hr_utility.set_location('Validating Email Address -Code 3125',10);
2895: if p_email is not null then
2896: if validate_email_id(p_email) = FALSE then
2897: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2898: fnd_message.set_token('CONTACT', 'Employee');
2899: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2900: l_msg_count := l_msg_count + 1;
2901: end if;

Line 2898: fnd_message.set_token('CONTACT', 'Employee');

2894: hr_utility.set_location('Validating Email Address -Code 3125',10);
2895: if p_email is not null then
2896: if validate_email_id(p_email) = FALSE then
2897: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2898: fnd_message.set_token('CONTACT', 'Employee');
2899: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2900: l_msg_count := l_msg_count + 1;
2901: end if;
2902: if validate_character_set(p_email,'FREETEXT') = FALSE then

Line 2899: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2895: if p_email is not null then
2896: if validate_email_id(p_email) = FALSE then
2897: fnd_message.set_name('PER', 'HR_ZA_INVALID_CONTACT_EMAIL');
2898: fnd_message.set_token('CONTACT', 'Employee');
2899: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2900: l_msg_count := l_msg_count + 1;
2901: end if;
2902: if validate_character_set(p_email,'FREETEXT') = FALSE then
2903: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

Line 2903: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

2899: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2900: l_msg_count := l_msg_count + 1;
2901: end if;
2902: if validate_character_set(p_email,'FREETEXT') = FALSE then
2903: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2904: fnd_message.set_token('FIELD', 'Employee Email Address');
2905: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2906: l_msg_count := l_msg_count + 1;
2907: end if;

Line 2904: fnd_message.set_token('FIELD', 'Employee Email Address');

2900: l_msg_count := l_msg_count + 1;
2901: end if;
2902: if validate_character_set(p_email,'FREETEXT') = FALSE then
2903: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2904: fnd_message.set_token('FIELD', 'Employee Email Address');
2905: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2906: l_msg_count := l_msg_count + 1;
2907: end if;
2908: if length(p_email) > 70 then

Line 2905: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2901: end if;
2902: if validate_character_set(p_email,'FREETEXT') = FALSE then
2903: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
2904: fnd_message.set_token('FIELD', 'Employee Email Address');
2905: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2906: l_msg_count := l_msg_count + 1;
2907: end if;
2908: if length(p_email) > 70 then
2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');

Line 2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');

2905: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2906: l_msg_count := l_msg_count + 1;
2907: end if;
2908: if length(p_email) > 70 then
2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2910: fnd_message.set_token('FIELD', 'Employee Email Address');
2911: fnd_message.set_token('LENGTH', '70');
2912: fnd_message.set_token('UNITS', 'characters');
2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

Line 2910: fnd_message.set_token('FIELD', 'Employee Email Address');

2906: l_msg_count := l_msg_count + 1;
2907: end if;
2908: if length(p_email) > 70 then
2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2910: fnd_message.set_token('FIELD', 'Employee Email Address');
2911: fnd_message.set_token('LENGTH', '70');
2912: fnd_message.set_token('UNITS', 'characters');
2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2914: l_msg_count := l_msg_count + 1;

Line 2911: fnd_message.set_token('LENGTH', '70');

2907: end if;
2908: if length(p_email) > 70 then
2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2910: fnd_message.set_token('FIELD', 'Employee Email Address');
2911: fnd_message.set_token('LENGTH', '70');
2912: fnd_message.set_token('UNITS', 'characters');
2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2914: l_msg_count := l_msg_count + 1;
2915: end if;

Line 2912: fnd_message.set_token('UNITS', 'characters');

2908: if length(p_email) > 70 then
2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2910: fnd_message.set_token('FIELD', 'Employee Email Address');
2911: fnd_message.set_token('LENGTH', '70');
2912: fnd_message.set_token('UNITS', 'characters');
2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2914: l_msg_count := l_msg_count + 1;
2915: end if;
2916: end if;

Line 2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

2909: fnd_message.set_name('PER', 'HR_ZA_INVALID_MAX_LENGTH');
2910: fnd_message.set_token('FIELD', 'Employee Email Address');
2911: fnd_message.set_token('LENGTH', '70');
2912: fnd_message.set_token('UNITS', 'characters');
2913: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
2914: l_msg_count := l_msg_count + 1;
2915: end if;
2916: end if;
2917:

Line 3004: fnd_message.set_name('PAY', 'PY_ZA_INV_PERS_PAYM_DDF');

3000: and p_effective_date between effective_start_date and effective_end_date;
3001:
3002: --Only one account can be set to SARS reporting
3003: if l_count > 1 then
3004: fnd_message.set_name('PAY', 'PY_ZA_INV_PERS_PAYM_DDF');
3005: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3006: l_msg_count := l_msg_count + 1;
3007: elsif l_count = 1 then
3008: open csr_bank_ddf_info;

Line 3005: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3001:
3002: --Only one account can be set to SARS reporting
3003: if l_count > 1 then
3004: fnd_message.set_name('PAY', 'PY_ZA_INV_PERS_PAYM_DDF');
3005: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3006: l_msg_count := l_msg_count + 1;
3007: elsif l_count = 1 then
3008: open csr_bank_ddf_info;
3009: fetch csr_bank_ddf_info into rec_asg_bnk_det;

Line 3013: fnd_message.set_name('PAY', 'PY_ZA_ENTER_REP_ACC_NO');

3009: fetch csr_bank_ddf_info into rec_asg_bnk_det;
3010: close csr_bank_ddf_info;
3011: else --Bank Detail DDF not set. Hence retrieve from Assignment EIT
3012: if P_PAY_METHOD_ID is null and P_PAYMENT_TYPE = 1 then
3013: fnd_message.set_name('PAY', 'PY_ZA_ENTER_REP_ACC_NO');
3014: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3015: l_msg_count := l_msg_count + 1;
3016: elsif P_PAYMENT_TYPE = 1 then
3017: open csr_asg_eit_acc;

Line 3014: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3010: close csr_bank_ddf_info;
3011: else --Bank Detail DDF not set. Hence retrieve from Assignment EIT
3012: if P_PAY_METHOD_ID is null and P_PAYMENT_TYPE = 1 then
3013: fnd_message.set_name('PAY', 'PY_ZA_ENTER_REP_ACC_NO');
3014: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3015: l_msg_count := l_msg_count + 1;
3016: elsif P_PAYMENT_TYPE = 1 then
3017: open csr_asg_eit_acc;
3018: fetch csr_asg_eit_acc into rec_asg_bnk_det;

Line 3021: fnd_message.set_name('PAY', 'PY_ZA_DEL_PAY_METHOD');

3017: open csr_asg_eit_acc;
3018: fetch csr_asg_eit_acc into rec_asg_bnk_det;
3019: if csr_asg_eit_acc%notfound then
3020: --Raise an error stating the personal payment method doesnt exists
3021: fnd_message.set_name('PAY', 'PY_ZA_DEL_PAY_METHOD');
3022: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3023: l_msg_count := l_msg_count + 1;
3024: end if;
3025: close csr_asg_eit_acc;

Line 3022: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3018: fetch csr_asg_eit_acc into rec_asg_bnk_det;
3019: if csr_asg_eit_acc%notfound then
3020: --Raise an error stating the personal payment method doesnt exists
3021: fnd_message.set_name('PAY', 'PY_ZA_DEL_PAY_METHOD');
3022: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3023: l_msg_count := l_msg_count + 1;
3024: end if;
3025: close csr_asg_eit_acc;
3026: elsif P_PAYMENT_TYPE is null then

Line 3028: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_TYPE');

3024: end if;
3025: close csr_asg_eit_acc;
3026: elsif P_PAYMENT_TYPE is null then
3027: --Raise an error stating the account type is not configured
3028: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_TYPE');
3029: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3030: l_msg_count := l_msg_count + 1;
3031: end if;
3032: end if;

Line 3029: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3025: close csr_asg_eit_acc;
3026: elsif P_PAYMENT_TYPE is null then
3027: --Raise an error stating the account type is not configured
3028: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_TYPE');
3029: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3030: l_msg_count := l_msg_count + 1;
3031: end if;
3032: end if;
3033:

Line 3038: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_NAME');

3034: --Validate the information for account holder's name and relationship
3035: if rec_asg_bnk_det.account_type in ('Y','1') then
3036: --Added as per revision 8.0.0 of SARS PAYE Reconiliation 2010
3037: if rec_asg_bnk_det.acc_holder_name is null then
3038: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_NAME');
3039: if p_tax_year=2010 then
3040: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3041: l_warn_count := l_warn_count + 1;
3042: else

Line 3040: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

3036: --Added as per revision 8.0.0 of SARS PAYE Reconiliation 2010
3037: if rec_asg_bnk_det.acc_holder_name is null then
3038: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_NAME');
3039: if p_tax_year=2010 then
3040: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3041: l_warn_count := l_warn_count + 1;
3042: else
3043: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3044: l_msg_count := l_msg_count + 1;

Line 3043: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3039: if p_tax_year=2010 then
3040: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3041: l_warn_count := l_warn_count + 1;
3042: else
3043: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3044: l_msg_count := l_msg_count + 1;
3045: end if;
3046: end if;
3047:

Line 3049: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');

3045: end if;
3046: end if;
3047:
3048: if validate_character_set(rec_asg_bnk_det.acc_holder_name,'FREETEXT') = FALSE then
3049: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
3050: fnd_message.set_token('FIELD', 'Account Holder''s Name');
3051: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3052: l_msg_count := l_msg_count + 1;
3053: end if;

Line 3050: fnd_message.set_token('FIELD', 'Account Holder''s Name');

3046: end if;
3047:
3048: if validate_character_set(rec_asg_bnk_det.acc_holder_name,'FREETEXT') = FALSE then
3049: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
3050: fnd_message.set_token('FIELD', 'Account Holder''s Name');
3051: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3052: l_msg_count := l_msg_count + 1;
3053: end if;
3054: if rec_asg_bnk_det.acc_holder_reln is null then

Line 3051: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3047:
3048: if validate_character_set(rec_asg_bnk_det.acc_holder_name,'FREETEXT') = FALSE then
3049: fnd_message.set_name('PER', 'HR_ZA_INVALID_CHAR');
3050: fnd_message.set_token('FIELD', 'Account Holder''s Name');
3051: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3052: l_msg_count := l_msg_count + 1;
3053: end if;
3054: if rec_asg_bnk_det.acc_holder_reln is null then
3055: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_REL');

Line 3055: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_REL');

3051: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3052: l_msg_count := l_msg_count + 1;
3053: end if;
3054: if rec_asg_bnk_det.acc_holder_reln is null then
3055: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_REL');
3056: --Made warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
3057: if p_tax_year=2010 then
3058: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3059: l_warn_count := l_warn_count + 1;

Line 3058: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

3054: if rec_asg_bnk_det.acc_holder_reln is null then
3055: fnd_message.set_name('PAY', 'PY_ZA_ENTER_ACC_HOLDER_REL');
3056: --Made warning as per revision 8.0.0 of SARS PAYE Reconiliation 2010 for only Tax Year 2010
3057: if p_tax_year=2010 then
3058: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3059: l_warn_count := l_warn_count + 1;
3060: else
3061: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3062: l_msg_count := l_msg_count + 1;

Line 3061: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3057: if p_tax_year=2010 then
3058: p_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3059: l_warn_count := l_warn_count + 1;
3060: else
3061: p_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3062: l_msg_count := l_msg_count + 1;
3063: end if;
3064: end if;
3065: end if;

Line 3319: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');

3315: if l_legal_entity is null then
3316: hr_utility.set_location('Legal Entity not provided.',20);
3317:
3318: --create a warnings table for missing legal entities and populate it.
3319: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');
3320: -- l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3321: -- l_warn_count := l_warn_count + 1;
3322: l_miss_LE_tab(l_miss_LE_count).emp_no:=l_emp_no;
3323: l_miss_LE_tab(l_miss_LE_count).asg_no:=l_asg_no;

Line 3320: -- l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

3316: hr_utility.set_location('Legal Entity not provided.',20);
3317:
3318: --create a warnings table for missing legal entities and populate it.
3319: -- fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');
3320: -- l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3321: -- l_warn_count := l_warn_count + 1;
3322: l_miss_LE_tab(l_miss_LE_count).emp_no:=l_emp_no;
3323: l_miss_LE_tab(l_miss_LE_count).asg_no:=l_asg_no;
3324: l_miss_LE_tab(l_miss_LE_count).emp_name:=l_emp_name;

Line 3408: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');

3404: rec_sars_bus_address.ee_street_name:=null;
3405: rec_sars_bus_address.ee_suburb_district:=null;
3406: rec_sars_bus_address.ee_town_city:=null;
3407: rec_sars_bus_address.ee_postal_code:=null;
3408: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3409: fnd_message.set_token('LOCATION', 'Location');
3410: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3411: l_msg_count := l_msg_count + 1;
3412: end if;

Line 3409: fnd_message.set_token('LOCATION', 'Location');

3405: rec_sars_bus_address.ee_suburb_district:=null;
3406: rec_sars_bus_address.ee_town_city:=null;
3407: rec_sars_bus_address.ee_postal_code:=null;
3408: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3409: fnd_message.set_token('LOCATION', 'Location');
3410: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3411: l_msg_count := l_msg_count + 1;
3412: end if;
3413: close csr_sars_loc_address;

Line 3410: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3406: rec_sars_bus_address.ee_town_city:=null;
3407: rec_sars_bus_address.ee_postal_code:=null;
3408: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3409: fnd_message.set_token('LOCATION', 'Location');
3410: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3411: l_msg_count := l_msg_count + 1;
3412: end if;
3413: close csr_sars_loc_address;
3414: ELSIF (l_pos_location_id is not null) THEN

Line 3425: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');

3421: rec_sars_bus_address.ee_street_name:=null;
3422: rec_sars_bus_address.ee_suburb_district:=null;
3423: rec_sars_bus_address.ee_town_city:=null;
3424: rec_sars_bus_address.ee_postal_code:=null;
3425: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3426: fnd_message.set_token('LOCATION', 'Position''s Location');
3427: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3428: l_msg_count := l_msg_count + 1;
3429: end if;

Line 3426: fnd_message.set_token('LOCATION', 'Position''s Location');

3422: rec_sars_bus_address.ee_suburb_district:=null;
3423: rec_sars_bus_address.ee_town_city:=null;
3424: rec_sars_bus_address.ee_postal_code:=null;
3425: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3426: fnd_message.set_token('LOCATION', 'Position''s Location');
3427: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3428: l_msg_count := l_msg_count + 1;
3429: end if;
3430: close csr_sars_loc_address;

Line 3427: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3423: rec_sars_bus_address.ee_town_city:=null;
3424: rec_sars_bus_address.ee_postal_code:=null;
3425: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3426: fnd_message.set_token('LOCATION', 'Position''s Location');
3427: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3428: l_msg_count := l_msg_count + 1;
3429: end if;
3430: close csr_sars_loc_address;
3431: ELSIF (l_org_location_id is not null) THEN

Line 3442: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');

3438: rec_sars_bus_address.ee_street_name:=null;
3439: rec_sars_bus_address.ee_suburb_district:=null;
3440: rec_sars_bus_address.ee_town_city:=null;
3441: rec_sars_bus_address.ee_postal_code:=null;
3442: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3443: fnd_message.set_token('LOCATION', 'Organization''s Location');
3444: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3445: l_msg_count := l_msg_count + 1;
3446: end if;

Line 3443: fnd_message.set_token('LOCATION', 'Organization''s Location');

3439: rec_sars_bus_address.ee_suburb_district:=null;
3440: rec_sars_bus_address.ee_town_city:=null;
3441: rec_sars_bus_address.ee_postal_code:=null;
3442: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3443: fnd_message.set_token('LOCATION', 'Organization''s Location');
3444: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3445: l_msg_count := l_msg_count + 1;
3446: end if;
3447: close csr_sars_loc_address;

Line 3444: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3440: rec_sars_bus_address.ee_town_city:=null;
3441: rec_sars_bus_address.ee_postal_code:=null;
3442: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3443: fnd_message.set_token('LOCATION', 'Organization''s Location');
3444: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3445: l_msg_count := l_msg_count + 1;
3446: end if;
3447: close csr_sars_loc_address;
3448: ELSE

Line 3449: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');

3445: l_msg_count := l_msg_count + 1;
3446: end if;
3447: close csr_sars_loc_address;
3448: ELSE
3449: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3450: fnd_message.set_token('LOCATION', 'Location or Position''s Location or Organization''s Location');
3451: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3452: l_msg_count := l_msg_count + 1;
3453: END IF;

Line 3450: fnd_message.set_token('LOCATION', 'Location or Position''s Location or Organization''s Location');

3446: end if;
3447: close csr_sars_loc_address;
3448: ELSE
3449: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3450: fnd_message.set_token('LOCATION', 'Location or Position''s Location or Organization''s Location');
3451: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3452: l_msg_count := l_msg_count + 1;
3453: END IF;
3454:

Line 3451: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3447: close csr_sars_loc_address;
3448: ELSE
3449: fnd_message.set_name('PER', 'HR_ZA_ENTER_BUS_ADDRESS');
3450: fnd_message.set_token('LOCATION', 'Location or Position''s Location or Organization''s Location');
3451: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3452: l_msg_count := l_msg_count + 1;
3453: END IF;
3454:
3455: validate_address( P_STYLE => 'ZA_SARS'

Line 3507: fnd_message.set_name('PER', 'HR_ZA_PRIM_ADD_STYLE');

3503: fetch csr_postal_address into rec_postal_address;
3504: if csr_postal_address%notfound then
3505: l_msg_count :=l_ee_msg_tab.count;
3506: l_warn_count:=l_ee_warn_tab.count;
3507: fnd_message.set_name('PER', 'HR_ZA_PRIM_ADD_STYLE');
3508: if p_tax_year = 2010 then
3509: l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3510: l_warn_count := l_warn_count + 1;
3511: else

Line 3509: l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');

3505: l_msg_count :=l_ee_msg_tab.count;
3506: l_warn_count:=l_ee_warn_tab.count;
3507: fnd_message.set_name('PER', 'HR_ZA_PRIM_ADD_STYLE');
3508: if p_tax_year = 2010 then
3509: l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3510: l_warn_count := l_warn_count + 1;
3511: else
3512: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3513: l_msg_count := l_msg_count + 1;

Line 3512: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');

3508: if p_tax_year = 2010 then
3509: l_ee_warn_tab(l_warn_count):=fnd_message.get('Y');
3510: l_warn_count := l_warn_count + 1;
3511: else
3512: l_ee_msg_tab(l_msg_count):=fnd_message.get('Y');
3513: l_msg_count := l_msg_count + 1;
3514: end if;
3515: elsif rec_postal_address.ee_indicator = 'N' then
3516: validate_address( P_STYLE => 'ZA'

Line 3648: fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');

3644: g_xml_element_count := g_xml_element_count + 1;
3645: end if;
3646:
3647: if l_miss_LE_tab.count > 0 then
3648: fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');
3649: l_ee_missing_LE_msg:=fnd_message.get('Y');
3650:
3651: for i in l_miss_LE_tab.first .. l_miss_LE_tab.last
3652: loop

Line 3649: l_ee_missing_LE_msg:=fnd_message.get('Y');

3645: end if;
3646:
3647: if l_miss_LE_tab.count > 0 then
3648: fnd_message.set_name('PAY', 'PY_ZA_ENTER_LEGAL_ENTITY');
3649: l_ee_missing_LE_msg:=fnd_message.get('Y');
3650:
3651: for i in l_miss_LE_tab.first .. l_miss_LE_tab.last
3652: loop
3653: g_xml_element_table(g_xml_element_count).tagname := 'WARN_LE_EMP';

Line 4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');

4465: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;

Line 4470: fnd_message.set_token('EMPNO',l_empno);

4466: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;

Line 4471: l_msgtext := fnd_message.get('Y');

4467: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4468: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4469: fnd_message.set_name('PAY', 'PY_ZA_NO_SITE_PAYE_SPLIT');
4470: fnd_message.set_token('EMPNO',l_empno);
4471: l_msgtext := fnd_message.get('Y');
4472: FND_FILE.PUT_LINE(FND_FILE.LOG, ' Tax Amount : '||rec_info.tax) ;
4473: FND_FILE.PUT_LINE(FND_FILE.LOG, ' SITE balance : '||rec_info.site) ;
4474: FND_FILE.PUT_LINE(FND_FILE.LOG, ' PAYE balance : '||rec_info.paye) ;
4475: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4486: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);
4493: l_msgtext := fnd_message.get('Y');
4494: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4491: fnd_message.set_token('EMPno',l_empno);

4487: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);
4493: l_msgtext := fnd_message.get('Y');
4494: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4495: end loop;

Line 4492: fnd_message.set_token('SARScode',rec_neg_income.code);

4488: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);
4493: l_msgtext := fnd_message.get('Y');
4494: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4495: end loop;
4496:

Line 4493: l_msgtext := fnd_message.get('Y');

4489: end if;
4490: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4491: fnd_message.set_token('EMPno',l_empno);
4492: fnd_message.set_token('SARScode',rec_neg_income.code);
4493: l_msgtext := fnd_message.get('Y');
4494: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4495: end loop;
4496:
4497: --Validate negative lump sums in the main certificate

Line 4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4508:
4509: -- To Be Advised directive has negative value
4510: if rec_neg_lmpsm.to_be_adv_val < 0 then
4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);
4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');
4516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4513: fnd_message.set_token('EMPno',l_empno);

4509: -- To Be Advised directive has negative value
4510: if rec_neg_lmpsm.to_be_adv_val < 0 then
4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);
4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');
4516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4517: end if;

Line 4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);

4510: if rec_neg_lmpsm.to_be_adv_val < 0 then
4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);
4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');
4516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4517: end if;
4518:

Line 4515: l_msgtext := fnd_message.get('Y');

4511: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.to_be_adv);
4512: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4513: fnd_message.set_token('EMPno',l_empno);
4514: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4515: l_msgtext := fnd_message.get('Y');
4516: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4517: end if;
4518:
4519: --Directive 1 has negative value

Line 4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4518:
4519: --Directive 1 has negative value
4520: if rec_neg_lmpsm.value1 < 0 then
4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4523: fnd_message.set_token('EMPno',l_empno);

4519: --Directive 1 has negative value
4520: if rec_neg_lmpsm.value1 < 0 then
4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4527: end if;

Line 4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);

4520: if rec_neg_lmpsm.value1 < 0 then
4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4527: end if;
4528:

Line 4525: l_msgtext := fnd_message.get('Y');

4521: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4522: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4523: fnd_message.set_token('EMPno',l_empno);
4524: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4525: l_msgtext := fnd_message.get('Y');
4526: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4527: end if;
4528:
4529: --Directive 2 has negative value

Line 4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4528:
4529: --Directive 2 has negative value
4530: if rec_neg_lmpsm.value2 < 0 then
4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);
4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');
4536: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4533: fnd_message.set_token('EMPno',l_empno);

4529: --Directive 2 has negative value
4530: if rec_neg_lmpsm.value2 < 0 then
4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);
4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');
4536: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4537: end if;

Line 4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);

4530: if rec_neg_lmpsm.value2 < 0 then
4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);
4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');
4536: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4537: end if;
4538:

Line 4535: l_msgtext := fnd_message.get('Y');

4531: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct2);
4532: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4533: fnd_message.set_token('EMPno',l_empno);
4534: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4535: l_msgtext := fnd_message.get('Y');
4536: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4537: end if;
4538:
4539: --Directive 3 has negative value

Line 4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4538:
4539: --Directive 3 has negative value
4540: if rec_neg_lmpsm.value3 < 0 then
4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);
4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');
4546: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4543: fnd_message.set_token('EMPno',l_empno);

4539: --Directive 3 has negative value
4540: if rec_neg_lmpsm.value3 < 0 then
4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);
4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');
4546: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4547: end if;

Line 4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);

4540: if rec_neg_lmpsm.value3 < 0 then
4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);
4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');
4546: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4547: end if;
4548: end loop;

Line 4545: l_msgtext := fnd_message.get('Y');

4541: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct3);
4542: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4543: fnd_message.set_token('EMPno',l_empno);
4544: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4545: l_msgtext := fnd_message.get('Y');
4546: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4547: end if;
4548: end loop;
4549:

Line 4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4561:
4562: -- To Be Advised directive has negative value
4563: if rec_neg_lmpsm.value < 0 then
4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');
4569: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4566: fnd_message.set_token('EMPno',l_empno);

4562: -- To Be Advised directive has negative value
4563: if rec_neg_lmpsm.value < 0 then
4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');
4569: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4570: end if;

Line 4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);

4563: if rec_neg_lmpsm.value < 0 then
4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');
4569: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4570: end if;
4571: end loop;

Line 4568: l_msgtext := fnd_message.get('Y');

4564: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Tax Directive Number ' || rec_neg_lmpsm.direct1);
4565: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4566: fnd_message.set_token('EMPno',l_empno);
4567: fnd_message.set_token('SARScode',rec_neg_lmpsm.code);
4568: l_msgtext := fnd_message.get('Y');
4569: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4570: end if;
4571: end loop;
4572:

Line 4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4587:
4588: --Site has negative value
4589: if rec_neg_tax.site < 0 then
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');
4595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4592: fnd_message.set_token('EMPno',l_empno);

4588: --Site has negative value
4589: if rec_neg_tax.site < 0 then
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');
4595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4596: end if;

Line 4593: fnd_message.set_token('SARScode','4101');

4589: if rec_neg_tax.site < 0 then
4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');
4595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4596: end if;
4597:

Line 4594: l_msgtext := fnd_message.get('Y');

4590: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4591: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4592: fnd_message.set_token('EMPno',l_empno);
4593: fnd_message.set_token('SARScode','4101');
4594: l_msgtext := fnd_message.get('Y');
4595: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4596: end if;
4597:
4598: --Paye has negative value

Line 4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4597:
4598: --Paye has negative value
4599: if rec_neg_tax.paye < 0 then
4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');
4605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4602: fnd_message.set_token('EMPno',l_empno);

4598: --Paye has negative value
4599: if rec_neg_tax.paye < 0 then
4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');
4605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4606: end if;

Line 4603: fnd_message.set_token('SARScode','4102');

4599: if rec_neg_tax.paye < 0 then
4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');
4605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4606: end if;
4607:

Line 4604: l_msgtext := fnd_message.get('Y');

4600: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4601: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4602: fnd_message.set_token('EMPno',l_empno);
4603: fnd_message.set_token('SARScode','4102');
4604: l_msgtext := fnd_message.get('Y');
4605: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4606: end if;
4607:
4608: --Tax on Retirement Fund has negative value

Line 4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4607:
4608: --Tax on Retirement Fund has negative value
4609: if rec_neg_tax.tax_ret < 0 then
4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');
4615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4612: fnd_message.set_token('EMPno',l_empno);

4608: --Tax on Retirement Fund has negative value
4609: if rec_neg_tax.tax_ret < 0 then
4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');
4615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4616: end if;

Line 4613: fnd_message.set_token('SARScode','4115');

4609: if rec_neg_tax.tax_ret < 0 then
4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');
4615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4616: end if;
4617:

Line 4614: l_msgtext := fnd_message.get('Y');

4610: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4611: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4612: fnd_message.set_token('EMPno',l_empno);
4613: fnd_message.set_token('SARScode','4115');
4614: l_msgtext := fnd_message.get('Y');
4615: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4616: end if;
4617:
4618: --UIF has negative value

Line 4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4617:
4618: --UIF has negative value
4619: if rec_neg_tax.uif < 0 then
4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');
4625: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4622: fnd_message.set_token('EMPno',l_empno);

4618: --UIF has negative value
4619: if rec_neg_tax.uif < 0 then
4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');
4625: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4626: end if;

Line 4623: fnd_message.set_token('SARScode','4141');

4619: if rec_neg_tax.uif < 0 then
4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');
4625: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4626: end if;
4627:

Line 4624: l_msgtext := fnd_message.get('Y');

4620: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4621: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4622: fnd_message.set_token('EMPno',l_empno);
4623: fnd_message.set_token('SARScode','4141');
4624: l_msgtext := fnd_message.get('Y');
4625: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4626: end if;
4627:
4628: --SDL has negative value

Line 4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4627:
4628: --SDL has negative value
4629: if rec_neg_tax.sdl < 0 then
4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');
4635: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4632: fnd_message.set_token('EMPno',l_empno);

4628: --SDL has negative value
4629: if rec_neg_tax.sdl < 0 then
4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');
4635: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4636: end if;

Line 4633: fnd_message.set_token('SARScode','4142');

4629: if rec_neg_tax.sdl < 0 then
4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');
4635: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4636: end if;
4637:

Line 4634: l_msgtext := fnd_message.get('Y');

4630: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4631: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4632: fnd_message.set_token('EMPno',l_empno);
4633: fnd_message.set_token('SARScode','4142');
4634: l_msgtext := fnd_message.get('Y');
4635: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4636: end if;
4637:
4638: --total has negative value

Line 4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4637:
4638: --total has negative value
4639: if rec_neg_tax.total < 0 then
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');
4645: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4642: fnd_message.set_token('EMPno',l_empno);

4638: --total has negative value
4639: if rec_neg_tax.total < 0 then
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');
4645: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4646: end if;

Line 4643: fnd_message.set_token('SARScode','4149');

4639: if rec_neg_tax.total < 0 then
4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');
4645: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4646: end if;
4647:

Line 4644: l_msgtext := fnd_message.get('Y');

4640: FND_FILE.PUT_LINE(FND_FILE.LOG, l_directive1);
4641: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4642: fnd_message.set_token('EMPno',l_empno);
4643: fnd_message.set_token('SARScode','4149');
4644: l_msgtext := fnd_message.get('Y');
4645: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4646: end if;
4647:
4648: end loop;

Line 4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');

4657: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);
4664: l_msgtext := fnd_message.get('Y');
4665: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);

Line 4662: fnd_message.set_token('EMPno',l_empno);

4658: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);
4664: l_msgtext := fnd_message.get('Y');
4665: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4666: end loop;

Line 4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);

4659: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);
4664: l_msgtext := fnd_message.get('Y');
4665: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4666: end loop;
4667:

Line 4664: l_msgtext := fnd_message.get('Y');

4660: end if;
4661: fnd_message.set_name('PAY', 'PY_ZA_NEG_BAL_NOT_ALWD');
4662: fnd_message.set_token('EMPno',l_empno);
4663: fnd_message.set_token('SARScode',rec_neg_deduct.code);
4664: l_msgtext := fnd_message.get('Y');
4665: FND_FILE.PUT_LINE(FND_FILE.LOG, l_msgtext);
4666: end loop;
4667:
4668: -- Added for bug#10287216

Line 4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');

4733: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;
4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
4738: fnd_message.set_token('EMPno',l_empno);
4739: l_msgtext := fnd_message.get('Y');
4740: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4741:

Line 4738: fnd_message.set_token('EMPno',l_empno);

4734: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4735: end if;
4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
4738: fnd_message.set_token('EMPno',l_empno);
4739: l_msgtext := fnd_message.get('Y');
4740: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4741:
4742: select max(paa.action_sequence)

Line 4739: l_msgtext := fnd_message.get('Y');

4735: end if;
4736:
4737: fnd_message.set_name('PAY', 'PY_ZA_PKG_BAL_NT_ALLOW');
4738: fnd_message.set_token('EMPno',l_empno);
4739: l_msgtext := fnd_message.get('Y');
4740: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4741:
4742: select max(paa.action_sequence)
4743: into l_run_action_seq

Line 4765: fnd_message.set_name('PAY', 'PY_ZA_NEW_ELE_FEED_PKG_BAL');

4761:
4762: hr_utility.set_location('Employee not on Package structure but has PKG balances',25);
4763: FOR pkg_ele IN fetch_pkg_ele(l_run_ass_act_id)
4764: LOOP
4765: fnd_message.set_name('PAY', 'PY_ZA_NEW_ELE_FEED_PKG_BAL');
4766: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
4767: l_msgtext := fnd_message.get('Y');
4768: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4769: END LOOP;

Line 4766: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);

4762: hr_utility.set_location('Employee not on Package structure but has PKG balances',25);
4763: FOR pkg_ele IN fetch_pkg_ele(l_run_ass_act_id)
4764: LOOP
4765: fnd_message.set_name('PAY', 'PY_ZA_NEW_ELE_FEED_PKG_BAL');
4766: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
4767: l_msgtext := fnd_message.get('Y');
4768: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4769: END LOOP;
4770: end loop; --end loop for fetch_pkg_balances

Line 4767: l_msgtext := fnd_message.get('Y');

4763: FOR pkg_ele IN fetch_pkg_ele(l_run_ass_act_id)
4764: LOOP
4765: fnd_message.set_name('PAY', 'PY_ZA_NEW_ELE_FEED_PKG_BAL');
4766: fnd_message.set_token('ELEMENTname',pkg_ele.element_name);
4767: l_msgtext := fnd_message.get('Y');
4768: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4769: END LOOP;
4770: end loop; --end loop for fetch_pkg_balances
4771:

Line 4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');

4957: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');

Line 4962: fnd_message.set_token('EMPNO',l_empno);

4958: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');
4966: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

Line 4963: fnd_message.set_token('COUNT','7');

4959: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');
4966: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4967: end if;

Line 4964: fnd_message.set_token('TYPE','deductions and/or contribution');

4960: end if;
4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');
4966: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4967: end if;
4968:

Line 4965: l_msgtext := fnd_message.get('Y');

4961: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4962: fnd_message.set_token('EMPNO',l_empno);
4963: fnd_message.set_token('COUNT','7');
4964: fnd_message.set_token('TYPE','deductions and/or contribution');
4965: l_msgtext := fnd_message.get('Y');
4966: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4967: end if;
4968:
4969: -- Check that number of income codes must not exceed 13.

Line 4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');

4985: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');

Line 4990: fnd_message.set_token('EMPNO',l_empno);

4986: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');
4994: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);

Line 4991: fnd_message.set_token('COUNT','13');

4987: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');
4994: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4995: end if;

Line 4992: fnd_message.set_token('TYPE','income');

4988: end if;
4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');
4994: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4995: end if;
4996:

Line 4993: l_msgtext := fnd_message.get('Y');

4989: fnd_message.set_name('PAY', 'PY_ZA_INVALID_NUM_CODES');
4990: fnd_message.set_token('EMPNO',l_empno);
4991: fnd_message.set_token('COUNT','13');
4992: fnd_message.set_token('TYPE','income');
4993: l_msgtext := fnd_message.get('Y');
4994: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
4995: end if;
4996:
4997: --If the employer is not register for PAYE (Paye Reference number doesnot start with 7)

Line 5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');

5017: FND_FILE.PUT_LINE(FND_FILE.LOG,' ');
5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);
5023: l_msgtext := fnd_message.get('Y');
5024: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5025: end if;

Line 5022: fnd_message.set_token('EMPNO',l_empno);

5018: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Employee Number : ' || l_empno);
5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);
5023: l_msgtext := fnd_message.get('Y');
5024: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5025: end if;
5026: end if;

Line 5023: l_msgtext := fnd_message.get('Y');

5019: FND_FILE.PUT_LINE(FND_FILE.LOG, 'Assignment Number : ' || l_assgno);
5020: end if;
5021: fnd_message.set_name('PAY', 'PY_ZA_INVALID_TAX_PAYENUM_COM');
5022: fnd_message.set_token('EMPNO',l_empno);
5023: l_msgtext := fnd_message.get('Y');
5024: FND_FILE.PUT_LINE (FND_FILE.LOG,l_msgtext);
5025: end if;
5026: end if;
5027: