234: l_lookup_exists := csr_check_domain%found;
235: close csr_check_domain;
236: --
237: If not l_lookup_exists then
238: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
239: hr_utility.set_message_token('LOOKUP_TYPE', p_domain_type);
240: hr_utility.set_message_token('PROCEDURE', l_proc);
241: hr_utility.set_message_token('STEP','5');
242: hr_utility.raise_error;
235: close csr_check_domain;
236: --
237: If not l_lookup_exists then
238: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
239: hr_utility.set_message_token('LOOKUP_TYPE', p_domain_type);
240: hr_utility.set_message_token('PROCEDURE', l_proc);
241: hr_utility.set_message_token('STEP','5');
242: hr_utility.raise_error;
243: End if;
236: --
237: If not l_lookup_exists then
238: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
239: hr_utility.set_message_token('LOOKUP_TYPE', p_domain_type);
240: hr_utility.set_message_token('PROCEDURE', l_proc);
241: hr_utility.set_message_token('STEP','5');
242: hr_utility.raise_error;
243: End if;
244: --
237: If not l_lookup_exists then
238: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
239: hr_utility.set_message_token('LOOKUP_TYPE', p_domain_type);
240: hr_utility.set_message_token('PROCEDURE', l_proc);
241: hr_utility.set_message_token('STEP','5');
242: hr_utility.raise_error;
243: End if;
244: --
245: --
238: hr_utility.set_message(801, 'HR_7033_ELE_ENTRY_LKUP_INVLD');
239: hr_utility.set_message_token('LOOKUP_TYPE', p_domain_type);
240: hr_utility.set_message_token('PROCEDURE', l_proc);
241: hr_utility.set_message_token('STEP','5');
242: hr_utility.raise_error;
243: End if;
244: --
245: --
246: end if;
692: --
693: begin
694: --
695: if p_currency_code is not null and NOT Valid_currency (p_currency_code) then
696: hr_utility.set_message (810,'OTA_13038_INVALID_CURRENCY');
697: hr_utility.raise_error;
698: end if;
699: --
700: end check_currency_is_valid;
693: begin
694: --
695: if p_currency_code is not null and NOT Valid_currency (p_currency_code) then
696: hr_utility.set_message (810,'OTA_13038_INVALID_CURRENCY');
697: hr_utility.raise_error;
698: end if;
699: --
700: end check_currency_is_valid;
701: --------------------------------------------------------------------------------
733: --
734: begin
735: --
736: if p_language_id is not null and NOT valid_language (p_language_id) then
737: hr_utility.set_message (810,'OTA_13448_EVT_INVALID_LANGUAGE');
738: hr_utility.raise_error;
739: end if;
740: --
741: end check_language_is_valid;
734: begin
735: --
736: if p_language_id is not null and NOT valid_language (p_language_id) then
737: hr_utility.set_message (810,'OTA_13448_EVT_INVALID_LANGUAGE');
738: hr_utility.raise_error;
739: end if;
740: --
741: end check_language_is_valid;
742: --------------------------------------------------------------------------------
940: --
941: begin
942: --
943: if p_vendor_id is not null and NOT valid_vendor (p_vendor_id,p_date) then
944: hr_utility.set_message (810,'OTA_13039_INVALID_VENDOR');
945: hr_utility.raise_error;
946: end if;
947: --
948: end check_vendor_is_valid;
941: begin
942: --
943: if p_vendor_id is not null and NOT valid_vendor (p_vendor_id,p_date) then
944: hr_utility.set_message (810,'OTA_13039_INVALID_VENDOR');
945: hr_utility.raise_error;
946: end if;
947: --
948: end check_vendor_is_valid;
949: --------------------------------------------------------------------------------