APPS.CSM_MAIL_MESSAGES_PKG dependencies on CSM_NOTIFICATION_EVENT_PKG

Line 138: l_notification_id:= CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess(p_record.receiver,l_wf_param);

134: l_wf_param.AddParameterToList('SUBJECT',p_record.subject);
135: l_wf_param.AddParameterToList('MESSAGE_BODY',p_record.message);
136: l_wf_param.AddParameterToList('#FROM_ROLE',l_sender);
137:
138: l_notification_id:= CSM_NOTIFICATION_EVENT_PKG.invoke_WF_NotifyProcess(p_record.receiver,l_wf_param);
139:
140: IF(l_notification_id = -1) THEN
141: RAISE_APPLICATION_ERROR(-20989, 'Unable to invoke CSM_MSGS- FYI_MESSAGE Workflow Process');
142: END IF;

Line 144: CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION(l_notification_id,l_return_status); --return_status doesn't matter here

140: IF(l_notification_id = -1) THEN
141: RAISE_APPLICATION_ERROR(-20989, 'Unable to invoke CSM_MSGS- FYI_MESSAGE Workflow Process');
142: END IF;
143:
144: CSM_NOTIFICATION_EVENT_PKG.DOWNLOAD_NOTIFICATION(l_notification_id,l_return_status); --return_status doesn't matter here
145:
146: BEGIN -- since FROM_ROLE column is filled only when mailer parses it.
147: SELECT 1 INTO l_num_grp FROM CSM_NOTIFICATIONS_ACC WHERE NOTIFICATION_ID=l_notification_id AND USER_ID=asg_base.get_user_id(l_sender);
148: EXCEPTION

Line 150: CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC(l_notification_id,asg_base.get_user_id(l_sender));

146: BEGIN -- since FROM_ROLE column is filled only when mailer parses it.
147: SELECT 1 INTO l_num_grp FROM CSM_NOTIFICATIONS_ACC WHERE NOTIFICATION_ID=l_notification_id AND USER_ID=asg_base.get_user_id(l_sender);
148: EXCEPTION
149: WHEN OTHERS THEN
150: CSM_NOTIFICATION_EVENT_PKG.INSERT_NOTIFICATIONS_ACC(l_notification_id,asg_base.get_user_id(l_sender));
151: END;
152:
153: x_return_status := FND_API.G_RET_STS_SUCCESS;
154: end if;