319: --
320: close csr_comm_topic;
321: end if;
322: exception
323: when app_exception.application_exception then
324: if hr_multi_message.exception_add
325: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_TYPE'
326: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.COMMUNICATION_OBJECT_ID'
327: ) then
443: --
444: close csr_recipient;
445: --
446: exception
447: when app_exception.application_exception then
448: if hr_multi_message.exception_add
449: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.RECIPIENT_TYPE'
450: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.RECIPIENT_ID'
451: ) then
497: fnd_message.raise_error;
498: end if;
499: --
500: exception
501: when app_exception.application_exception then
502: if hr_multi_message.exception_add
503: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.START_DATE_ACTIVE'
504: ,p_associated_column2 => 'IRC_COMM_RECIPIENTS.END_DATE_ACTIVE'
505: ) then
536: hr_utility.raise_error;
537: end if;
538: --
539: exception
540: when app_exception.application_exception then
541: if hr_multi_message.exception_add
542: (p_associated_column1 => 'IRC_COMM_RECIPIENTS.PRIMARY_FLAG'
543: ) then
544: --