852: open address_exists;
853: fetch address_exists into l_dummy;
854: if address_exists%NOTFOUND
855: then
856: hr_utility.set_message(801,'PAY_ASSIGNEE_NO_ADDRESS');
857: return FALSE;
858: end if;
859: close address_exists;
860: RETURN TRUE;
902: if check_garnishor%FOUND
903: then
904: if p_mode = 'D' -- delete message
905: then
906: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
907: hr_utility.raise_error;
908: else
909: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
910: hr_utility.raise_error;
903: then
904: if p_mode = 'D' -- delete message
905: then
906: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
907: hr_utility.raise_error;
908: else
909: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
910: hr_utility.raise_error;
911: end if;
905: then
906: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
907: hr_utility.raise_error;
908: else
909: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
910: hr_utility.raise_error;
911: end if;
912: end if;
913: close check_garnishor;
906: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
907: hr_utility.raise_error;
908: else
909: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
910: hr_utility.raise_error;
911: end if;
912: end if;
913: close check_garnishor;
914: open check_garnishor(l_contact_id,l_contact_relationship_id);
916: if check_garnishor%FOUND
917: then
918: if p_mode = 'D' -- delete message
919: then
920: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
921: hr_utility.raise_error;
922: else
923: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
924: hr_utility.raise_error;
917: then
918: if p_mode = 'D' -- delete message
919: then
920: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
921: hr_utility.raise_error;
922: else
923: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
924: hr_utility.raise_error;
925: end if;
919: then
920: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
921: hr_utility.raise_error;
922: else
923: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
924: hr_utility.raise_error;
925: end if;
926: end if;
927: close check_garnishor;
920: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');
921: hr_utility.raise_error;
922: else
923: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');
924: hr_utility.raise_error;
925: end if;
926: end if;
927: close check_garnishor;
928: end check_ppm;
967: fetch cur_ben into l_check;
968: close cur_ben;
969: --
970: if l_check = 'Y' then
971: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_BENF');
972: hr_utility.raise_error;
973: end if;
974: --
975: end check_beneficiary;
968: close cur_ben;
969: --
970: if l_check = 'Y' then
971: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_BENF');
972: hr_utility.raise_error;
973: end if;
974: --
975: end check_beneficiary;
976: --
993: fetch cur_dep into l_check;
994: close cur_dep;
995: --
996: if l_check = 'Y' then
997: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_COVDEP');
998: hr_utility.raise_error;
999: end if;
1000: --
1001: end check_dependent;
994: close cur_dep;
995: --
996: if l_check = 'Y' then
997: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_COVDEP');
998: hr_utility.raise_error;
999: end if;
1000: --
1001: end check_dependent;
1002: --