DBA Data[Home] [Help]

APPS.HR_CONTACT_RELATIONSHIPS dependencies on HR_UTILITY

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

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;

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

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;

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

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

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;

Line 912: hr_utility.raise_error;

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

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

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;

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

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

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;

Line 926: hr_utility.raise_error;

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;

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

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;

Line 974: hr_utility.raise_error;

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

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

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;

Line 1000: hr_utility.raise_error;

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