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