66: --
67: -- The primary key is invalid therefore we must error
68: --
69: fnd_message.set_name('PAY','HR_7220_INVALID_PRIMARY_KEY');
70: hr_multi_message.add
71: (p_associated_column1
72: => nvl(p_associated_column1,'COMMUNICATION_MESSAGE_ID')
73: );
74: --
322: hr_utility.set_location(' Leaving:'||l_proc,40);
323: --
324: exception
325: when app_exception.application_exception then
326: if hr_multi_message.exception_add
327: (p_associated_column1 => 'IRC_COMM_MESSAGES.COMMUNICATION_TOPIC_ID'
328: ) then
329: --
330: hr_utility.set_location(' Leaving:'||l_proc,50);
378: hr_utility.set_location(l_proc,20);
379: --
380: exception
381: when app_exception.application_exception then
382: if hr_multi_message.exception_add
383: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_SUBJECT'
384: ) then
385: --
386: hr_utility.set_location(' Leaving:'||l_proc,30);
431: hr_utility.set_location(l_proc,20);
432: --
433: exception
434: when app_exception.application_exception then
435: if hr_multi_message.exception_add
436: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_BODY'
437: ) then
438: --
439: hr_utility.set_location(' Leaving:'||l_proc,30);
478: );
479: --
480: exception
481: when app_exception.application_exception then
482: if hr_multi_message.exception_add
483: (p_associated_column1 => 'IRC_COMM_MESSAGES.MESSAGE_POST_DATE'
484: ) then
485: --
486: hr_utility.set_location(' Leaving:'||l_proc,20);
577: end if;
578:
579: exception
580: when app_exception.application_exception then
581: if hr_multi_message.exception_add
582: (p_associated_column1 => 'IRC_COMM_MESSAGES.SENDER_TYPE'
583: ,p_associated_column2 => 'IRC_COMM_MESSAGES.SENDER_ID'
584: ) then
585: --
649: fnd_message.raise_error;
650: end if;
651: exception
652: when app_exception.application_exception then
653: if hr_multi_message.exception_add
654: (p_associated_column1 => 'IRC_COMM_MESSAGES.DOCUMENT_TYPE'
655: ,p_associated_column2 => 'IRC_COMM_MESSAGES.DOCUMENT_ID'
656: ) then
657: --
688: end if;
689: --
690: exception
691: when app_exception.application_exception then
692: if hr_multi_message.exception_add
693: (p_associated_column1 => 'IRC_COMM_MESSAGES.DELETED_FLAG'
694: ) then
695: --
696: hr_utility.set_location(' Leaving:'||l_proc,20);