475: FND_MSG_PUB.ADD;
476: return;
477: end if;
478:
479: m_notification_id := WF_NOTIFICATION.Send(
480: role => m_role_name,
481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:
480: role => m_role_name,
481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
481: msg_type => 'AMWGUTIL',
482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
482: msg_name => 'ITA_MESG');
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
483:
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
484: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SUBJECT', m_message_subject);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
485: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_BODY', m_message_body);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
486: WF_NOTIFICATION.SetAttrText(m_notification_id, 'GEN_MSG_SEND_TO', m_role_name);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
487: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_GROUP', p_setup_group);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
488: WF_NOTIFICATION.SetAttrText(m_notification_id, 'APPLICATION', p_application);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
489: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG_TYPE', p_org_type);
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
490: WF_NOTIFICATION.SetAttrText(m_notification_id, 'ORG', p_org);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
491: WF_NOTIFICATION.SetAttrText(m_notification_id, 'SETUP_PARAMETER', p_setup_parameter);
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:
492: WF_NOTIFICATION.SetAttrText(m_notification_id, 'REC_VALUE', p_rec_value);
493: WF_NOTIFICATION.SetAttrText(m_notification_id, 'PRIOR_VALUE', p_prior_value);
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:
500: end loop;
494: WF_NOTIFICATION.SetAttrText(m_notification_id, 'CURRENT_VALUE', p_current_value);
495: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_ON', p_updated_on);
496: WF_NOTIFICATION.SetAttrText(m_notification_id, 'UPDATED_BY', p_updated_by);
497:
498: WF_NOTIFICATION.Denormalize_Notification(m_notification_id);
499:
500: end loop;
501:
502: p_return_status := m_return_status;