DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on HR_UTILITY

Line 856: hr_utility.set_message(801,'PAY_ASSIGNEE_NO_ADDRESS');

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;

Line 906: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');

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;

Line 907: 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;

Line 909: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');

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;

Line 910: hr_utility.raise_error;

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

Line 920: hr_utility.set_message(801,'PAY_GARNISHOR_PAYMENT_METHOD');

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;

Line 921: 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;

Line 923: hr_utility.set_message(801,'HR_7874_GARNISHMENT_IS_PAYEE');

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;

Line 924: hr_utility.raise_error;

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;

Line 971: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_BENF');

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;

Line 972: hr_utility.raise_error;

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

Line 997: hr_utility.set_message(801,'HR_CONTACT_MARKED_AS_COVDEP');

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;

Line 998: hr_utility.raise_error;

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