352: --
353: x_mesg_attribute_rec.wf_msg_name := GetWFMessageName(p_nid => x_mesg_attribute_rec.notification_id) ;
354:
355: --
356: -- Get FND Message Names for HTML Body associated with Eng Workflow Message Name
357: --
358: GetMessageMapping( p_wf_msg_name => x_mesg_attribute_rec.wf_msg_name
359: , x_subject_msg_name => l_subject_msg_name
360: , x_text_body_msg_name => l_text_body_msg_name
532: -- Get Html Body Message
533: -- IF l_html_body_msg_name IS NOT NULL THEN
534:
535: -- Headline Message
536: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
537: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
538: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
539: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
540:
533: -- IF l_html_body_msg_name IS NOT NULL THEN
534:
535: -- Headline Message
536: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
537: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
538: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
539: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
540:
541: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
534:
535: -- Headline Message
536: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
537: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
538: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
539: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
540:
541: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
542:
535: -- Headline Message
536: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
537: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
538: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
539: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
540:
541: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
542:
543: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
539: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
540:
541: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
542:
543: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
544:
545: ELSIF x_wf_msg_name = G_STATUS_CHANGE_MSG THEN
546:
547: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
543: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
544:
545: ELSIF x_wf_msg_name = G_STATUS_CHANGE_MSG THEN
546:
547: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
548:
549: ELSIF x_wf_msg_name = G_REASSIGNMENT_MSG THEN
550:
551: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
547: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
548:
549: ELSIF x_wf_msg_name = G_REASSIGNMENT_MSG THEN
550:
551: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
552:
553: END IF ;
554:
555: l_headline_msg := FND_MESSAGE.GET ;
551: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
552:
553: END IF ;
554:
555: l_headline_msg := FND_MESSAGE.GET ;
556:
557: -- Content Message
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
554:
555: l_headline_msg := FND_MESSAGE.GET ;
556:
557: -- Content Message
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
555: l_headline_msg := FND_MESSAGE.GET ;
556:
557: -- Content Message
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
556:
557: -- Content Message
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
564:
557: -- Content Message
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
564:
565: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
558: FND_MESSAGE.SET_NAME('ENG', l_html_body_msg_name) ;
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
564:
565: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
566:
559: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
560: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', x_change_notice ) ;
561: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', x_change_name) ;
562: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', x_action_party_name) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
564:
565: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
566:
567: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
563: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', x_action_party_company) ;
564:
565: IF x_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
566:
567: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
568:
569: ELSIF x_wf_msg_name = G_STATUS_CHANGE_MSG THEN
570:
571: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
567: FND_MESSAGE.SET_TOKEN('PRIORITY', x_priority) ;
568:
569: ELSIF x_wf_msg_name = G_STATUS_CHANGE_MSG THEN
570:
571: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
572:
573: ELSIF x_wf_msg_name = G_REASSIGNMENT_MSG THEN
574:
575: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
571: FND_MESSAGE.SET_TOKEN('STATUS', x_change_status ) ;
572:
573: ELSIF x_wf_msg_name = G_REASSIGNMENT_MSG THEN
574:
575: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
576: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', x_assignee_company) ;
577:
578: END IF ;
579:
572:
573: ELSIF x_wf_msg_name = G_REASSIGNMENT_MSG THEN
574:
575: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', x_assignee ) ;
576: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', x_assignee_company) ;
577:
578: END IF ;
579:
580: l_content_msg := FND_MESSAGE.GET ;
576: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', x_assignee_company) ;
577:
578: END IF ;
579:
580: l_content_msg := FND_MESSAGE.GET ;
581:
582: -- How to respond or FYI instruction
583: IF CheckToDoNtf(p_nid => x_nid ) THEN
584:
589: -- Message : ENG_NTF_HOW_TO_RESPOND_NTF
590: -- 'To respond to this notification by email, please select
591: -- the link at the bottom of this email message.'
592:
593: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_HTML_MSG') ;
594: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', x_ntf_detail_url) ;
595: l_how_to_respond_msg := FND_MESSAGE.GET ;
596:
597: ELSE
590: -- 'To respond to this notification by email, please select
591: -- the link at the bottom of this email message.'
592:
593: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_HTML_MSG') ;
594: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', x_ntf_detail_url) ;
595: l_how_to_respond_msg := FND_MESSAGE.GET ;
596:
597: ELSE
598:
591: -- the link at the bottom of this email message.'
592:
593: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_HTML_MSG') ;
594: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', x_ntf_detail_url) ;
595: l_how_to_respond_msg := FND_MESSAGE.GET ;
596:
597: ELSE
598:
599: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
595: l_how_to_respond_msg := FND_MESSAGE.GET ;
596:
597: ELSE
598:
599: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
600: l_fyi_only_msg := FND_MESSAGE.GET ;
601:
602: END IF ;
603:
596:
597: ELSE
598:
599: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
600: l_fyi_only_msg := FND_MESSAGE.GET ;
601:
602: END IF ;
603:
604: -- Detail Page Link Message
613: , x_item_key
614: , 'CHANGE_DETAIL_PAGE_URL'
615: ) ;
616:
617: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_HTML_MSG') ;
618: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
619: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
620: l_detail_link_msg := FND_MESSAGE.GET ;
621:
614: , 'CHANGE_DETAIL_PAGE_URL'
615: ) ;
616:
617: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_HTML_MSG') ;
618: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
619: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
620: l_detail_link_msg := FND_MESSAGE.GET ;
621:
622: -- Thank you message
615: ) ;
616:
617: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_HTML_MSG') ;
618: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
619: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
620: l_detail_link_msg := FND_MESSAGE.GET ;
621:
622: -- Thank you message
623: -- l_thankyou_msg
616:
617: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_HTML_MSG') ;
618: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', x_change_management_type) ;
619: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
620: l_detail_link_msg := FND_MESSAGE.GET ;
621:
622: -- Thank you message
623: -- l_thankyou_msg
624: --
623: -- l_thankyou_msg
624: --
625: -- message ENG_NTF_THANK_YOU
626: -- 'Thank You.'
627: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_THANK_YOU') ;
628: l_thankyou_msg := FND_MESSAGE.GET ;
629:
630: END IF ;
631: *************************************************************************/
624: --
625: -- message ENG_NTF_THANK_YOU
626: -- 'Thank You.'
627: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_THANK_YOU') ;
628: l_thankyou_msg := FND_MESSAGE.GET ;
629:
630: END IF ;
631: *************************************************************************/
632:
638: -- Get Html Body Message
639: -- IF l_text_body_msg_name_body_msg_name IS NOT NULL THEN
640:
641: -- Headline Message
642: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
643: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
644: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
645: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
646:
639: -- IF l_text_body_msg_name_body_msg_name IS NOT NULL THEN
640:
641: -- Headline Message
642: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
643: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
644: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
645: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
646:
647: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
640:
641: -- Headline Message
642: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
643: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
644: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
645: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
646:
647: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
648:
641: -- Headline Message
642: FND_MESSAGE.SET_NAME('ENG', l_subject_msg_name) ;
643: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
644: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
645: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
646:
647: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
648:
649: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
645: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
646:
647: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
648:
649: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
650:
651: ELSIF l_wf_msg_name = G_STATUS_CHANGE_MSG THEN
652:
653: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
649: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
650:
651: ELSIF l_wf_msg_name = G_STATUS_CHANGE_MSG THEN
652:
653: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
654:
655: ELSIF l_wf_msg_name = G_REASSIGNMENT_MSG THEN
656:
657: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
653: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
654:
655: ELSIF l_wf_msg_name = G_REASSIGNMENT_MSG THEN
656:
657: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
658:
659: END IF ;
660:
661: l_headline_msg := FND_MESSAGE.GET ;
657: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
658:
659: END IF ;
660:
661: l_headline_msg := FND_MESSAGE.GET ;
662:
663: -- Content Message
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
660:
661: l_headline_msg := FND_MESSAGE.GET ;
662:
663: -- Content Message
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
661: l_headline_msg := FND_MESSAGE.GET ;
662:
663: -- Content Message
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
662:
663: -- Content Message
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
663: -- Content Message
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
671:
664: FND_MESSAGE.SET_NAME('ENG', l_text_body_msg_name) ;
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
671:
672: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
665: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
671:
672: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
673:
666: FND_MESSAGE.SET_TOKEN('CHANGE_NOTICE', l_change_notice ) ;
667: FND_MESSAGE.SET_TOKEN('CHANGE_NAME', l_change_name) ;
668: FND_MESSAGE.SET_TOKEN('BY_PERSON_NAME', l_action_party_name) ;
669: FND_MESSAGE.SET_TOKEN('BY_COMPANY_NAME', l_action_party_company) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
671:
672: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
673:
674: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
670: FND_MESSAGE.SET_TOKEN('ACTION_DESC', l_action_desc) ;
671:
672: IF l_wf_msg_name = G_PRIORITY_CHANGE_MSG THEN
673:
674: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
675:
676: ELSIF l_wf_msg_name = G_STATUS_CHANGE_MSG THEN
677:
678: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
674: FND_MESSAGE.SET_TOKEN('PRIORITY', l_priority) ;
675:
676: ELSIF l_wf_msg_name = G_STATUS_CHANGE_MSG THEN
677:
678: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
679:
680: ELSIF l_wf_msg_name = G_REASSIGNMENT_MSG THEN
681:
682: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
678: FND_MESSAGE.SET_TOKEN('STATUS', l_change_status ) ;
679:
680: ELSIF l_wf_msg_name = G_REASSIGNMENT_MSG THEN
681:
682: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
683: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', l_assignee_company) ;
684:
685: END IF ;
686:
679:
680: ELSIF l_wf_msg_name = G_REASSIGNMENT_MSG THEN
681:
682: FND_MESSAGE.SET_TOKEN('ASSIGNEE_PARTY_NAME', l_assignee ) ;
683: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', l_assignee_company) ;
684:
685: END IF ;
686:
687: l_content_msg := FND_MESSAGE.GET ;
683: FND_MESSAGE.SET_TOKEN('ASSIGNEE_COMPANY_NAME', l_assignee_company) ;
684:
685: END IF ;
686:
687: l_content_msg := FND_MESSAGE.GET ;
688:
689: -- How to respond or FYI instruction
690: IF CheckToDoNtf(p_nid => l_nid ) THEN
691:
696: -- Message : ENG_NTF_HOW_TO_RESPOND_NTF
697: -- 'To respond to this notification by email, please select
698: -- the link at the bottom of this email message.'
699:
700: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_MSG') ;
701: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', l_ntf_detail_url) ;
702: l_how_to_respond_msg := FND_MESSAGE.GET ;
703:
704: ELSE
697: -- 'To respond to this notification by email, please select
698: -- the link at the bottom of this email message.'
699:
700: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_MSG') ;
701: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', l_ntf_detail_url) ;
702: l_how_to_respond_msg := FND_MESSAGE.GET ;
703:
704: ELSE
705:
698: -- the link at the bottom of this email message.'
699:
700: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_HOW_TO_RESP_MSG') ;
701: FND_MESSAGE.SET_TOKEN('NTF_DETAIL_URL', l_ntf_detail_url) ;
702: l_how_to_respond_msg := FND_MESSAGE.GET ;
703:
704: ELSE
705:
706: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
702: l_how_to_respond_msg := FND_MESSAGE.GET ;
703:
704: ELSE
705:
706: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
707: l_fyi_only_msg := FND_MESSAGE.GET ;
708:
709: END IF ;
710:
703:
704: ELSE
705:
706: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_FYI_INSTRUCTION') ;
707: l_fyi_only_msg := FND_MESSAGE.GET ;
708:
709: END IF ;
710:
711: -- Detail Page Link Message
720: , l_item_key
721: , 'CHANGE_DETAIL_PAGE_URL'
722: ) ;
723:
724: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_TEXT_MSG') ;
725: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
726: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
727: l_detail_link_msg := FND_MESSAGE.GET ;
728:
721: , 'CHANGE_DETAIL_PAGE_URL'
722: ) ;
723:
724: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_TEXT_MSG') ;
725: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
726: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
727: l_detail_link_msg := FND_MESSAGE.GET ;
728:
729: -- Thank you message
722: ) ;
723:
724: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_TEXT_MSG') ;
725: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
726: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
727: l_detail_link_msg := FND_MESSAGE.GET ;
728:
729: -- Thank you message
730: -- l_thankyou_msg
723:
724: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_DETAIL_LINK_TEXT_MSG') ;
725: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_change_management_type) ;
726: FND_MESSAGE.SET_TOKEN('DETAIL_URL', l_detail_url) ;
727: l_detail_link_msg := FND_MESSAGE.GET ;
728:
729: -- Thank you message
730: -- l_thankyou_msg
731: --
730: -- l_thankyou_msg
731: --
732: -- message ENG_NTF_THANK_YOU
733: -- 'Thank You.'
734: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_THANK_YOU') ;
735: l_thankyou_msg := FND_MESSAGE.GET ;
736: END IF ;
737: *************************************************************************/
738:
731: --
732: -- message ENG_NTF_THANK_YOU
733: -- 'Thank You.'
734: FND_MESSAGE.SET_NAME('ENG', 'ENG_NTF_THANK_YOU') ;
735: l_thankyou_msg := FND_MESSAGE.GET ;
736: END IF ;
737: *************************************************************************/
738:
739:
1105:
1106:
1107:
1108: -- Get Field Prompt
1109: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_NAME') ;
1110: l_change_name_p := FND_MESSAGE.GET ;
1111:
1112: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DESCRIPTION') ;
1113: l_change_desc_p := FND_MESSAGE.GET ;
1106:
1107:
1108: -- Get Field Prompt
1109: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_NAME') ;
1110: l_change_name_p := FND_MESSAGE.GET ;
1111:
1112: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DESCRIPTION') ;
1113: l_change_desc_p := FND_MESSAGE.GET ;
1114:
1108: -- Get Field Prompt
1109: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_NAME') ;
1110: l_change_name_p := FND_MESSAGE.GET ;
1111:
1112: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DESCRIPTION') ;
1113: l_change_desc_p := FND_MESSAGE.GET ;
1114:
1115:
1116: IF l_mesg_attribute_rec.item_id IS NOT NULL THEN
1109: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_NAME') ;
1110: l_change_name_p := FND_MESSAGE.GET ;
1111:
1112: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DESCRIPTION') ;
1113: l_change_desc_p := FND_MESSAGE.GET ;
1114:
1115:
1116: IF l_mesg_attribute_rec.item_id IS NOT NULL THEN
1117:
1114:
1115:
1116: IF l_mesg_attribute_rec.item_id IS NOT NULL THEN
1117:
1118: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM') ;
1119: l_item_p := FND_MESSAGE.GET ;
1120:
1121: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM_REVISION') ;
1122: l_item_revision_p := FND_MESSAGE.GET ;
1115:
1116: IF l_mesg_attribute_rec.item_id IS NOT NULL THEN
1117:
1118: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM') ;
1119: l_item_p := FND_MESSAGE.GET ;
1120:
1121: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM_REVISION') ;
1122: l_item_revision_p := FND_MESSAGE.GET ;
1123:
1117:
1118: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM') ;
1119: l_item_p := FND_MESSAGE.GET ;
1120:
1121: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM_REVISION') ;
1122: l_item_revision_p := FND_MESSAGE.GET ;
1123:
1124:
1125: -- if item revision label is not null
1118: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM') ;
1119: l_item_p := FND_MESSAGE.GET ;
1120:
1121: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT_ITEM_REVISION') ;
1122: l_item_revision_p := FND_MESSAGE.GET ;
1123:
1124:
1125: -- if item revision label is not null
1126: -- revision field value should be 'revision - revision_lable'
1127: -- defined in message ENG_CHANGE_ITEM_REV_LABEL
1128: IF l_mesg_attribute_rec.item_revision_label IS NOT NULL
1129: THEN
1130:
1131: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_ITEM_REV_LABEL') ;
1132: FND_MESSAGE.SET_TOKEN('REVISION_CODE', l_mesg_attribute_rec.item_revision) ;
1133: FND_MESSAGE.SET_TOKEN('REVISION_LABEL', l_mesg_attribute_rec.item_revision_label) ;
1134: l_item_revision_label := FND_MESSAGE.GET ;
1135:
1128: IF l_mesg_attribute_rec.item_revision_label IS NOT NULL
1129: THEN
1130:
1131: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_ITEM_REV_LABEL') ;
1132: FND_MESSAGE.SET_TOKEN('REVISION_CODE', l_mesg_attribute_rec.item_revision) ;
1133: FND_MESSAGE.SET_TOKEN('REVISION_LABEL', l_mesg_attribute_rec.item_revision_label) ;
1134: l_item_revision_label := FND_MESSAGE.GET ;
1135:
1136: ELSE
1129: THEN
1130:
1131: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_ITEM_REV_LABEL') ;
1132: FND_MESSAGE.SET_TOKEN('REVISION_CODE', l_mesg_attribute_rec.item_revision) ;
1133: FND_MESSAGE.SET_TOKEN('REVISION_LABEL', l_mesg_attribute_rec.item_revision_label) ;
1134: l_item_revision_label := FND_MESSAGE.GET ;
1135:
1136: ELSE
1137:
1130:
1131: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_ITEM_REV_LABEL') ;
1132: FND_MESSAGE.SET_TOKEN('REVISION_CODE', l_mesg_attribute_rec.item_revision) ;
1133: FND_MESSAGE.SET_TOKEN('REVISION_LABEL', l_mesg_attribute_rec.item_revision_label) ;
1134: l_item_revision_label := FND_MESSAGE.GET ;
1135:
1136: ELSE
1137:
1138: l_item_revision_label := l_mesg_attribute_rec.item_revision ;
1173: l_mesg_attribute_rec.item_type = Eng_Workflow_Util.G_CHANGE_ROUTE_STEP_ITEM_TYPE AND
1174: l_mesg_attribute_rec.wf_msg_name <> G_ABORT_STEP_MSG
1175: THEN
1176:
1177: FND_MESSAGE.SET_NAME('ENG', 'ENG_STEP_INSTRUCTIONS') ;
1178: l_instrunctions_p := FND_MESSAGE.GET ;
1179:
1180: END IF ;
1181:
1174: l_mesg_attribute_rec.wf_msg_name <> G_ABORT_STEP_MSG
1175: THEN
1176:
1177: FND_MESSAGE.SET_NAME('ENG', 'ENG_STEP_INSTRUCTIONS') ;
1178: l_instrunctions_p := FND_MESSAGE.GET ;
1179:
1180: END IF ;
1181:
1182: IF l_mesg_attribute_rec.action_id IS NOT NULL AND
1186:
1187: IF l_mesg_attribute_rec.wf_msg_name = G_REQUEST_COMMENT_MSG
1188: THEN
1189:
1190: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT') ;
1191: l_action_p := FND_MESSAGE.GET ;
1192:
1193: ELSE
1194:
1187: IF l_mesg_attribute_rec.wf_msg_name = G_REQUEST_COMMENT_MSG
1188: THEN
1189:
1190: FND_MESSAGE.SET_NAME('ENG', 'ENG_SUBJECT') ;
1191: l_action_p := FND_MESSAGE.GET ;
1192:
1193: ELSE
1194:
1195: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMMENT') ;
1191: l_action_p := FND_MESSAGE.GET ;
1192:
1193: ELSE
1194:
1195: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMMENT') ;
1196: l_action_p := FND_MESSAGE.GET ;
1197:
1198: END IF ;
1199:
1192:
1193: ELSE
1194:
1195: FND_MESSAGE.SET_NAME('ENG', 'ENG_COMMENT') ;
1196: l_action_p := FND_MESSAGE.GET ;
1197:
1198: END IF ;
1199:
1200: END IF ;
1232:
1233: END IF ;
1234:
1235: -- Get Sub Header
1236: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_SUMMARY') ;
1237: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1238: l_additional_info_subh := FND_MESSAGE.GET ;
1239:
1240: -- Get Detail Url Link
1233: END IF ;
1234:
1235: -- Get Sub Header
1236: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_SUMMARY') ;
1237: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1238: l_additional_info_subh := FND_MESSAGE.GET ;
1239:
1240: -- Get Detail Url Link
1241: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DETAIL_LINK_NTF') ;
1234:
1235: -- Get Sub Header
1236: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_SUMMARY') ;
1237: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1238: l_additional_info_subh := FND_MESSAGE.GET ;
1239:
1240: -- Get Detail Url Link
1241: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DETAIL_LINK_NTF') ;
1242: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1237: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1238: l_additional_info_subh := FND_MESSAGE.GET ;
1239:
1240: -- Get Detail Url Link
1241: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DETAIL_LINK_NTF') ;
1242: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1243: l_change_detail_link := FND_MESSAGE.GET ;
1244:
1245: ELSIF l_mesg_attribute_rec.change_line_id IS NOT NULL
1238: l_additional_info_subh := FND_MESSAGE.GET ;
1239:
1240: -- Get Detail Url Link
1241: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DETAIL_LINK_NTF') ;
1242: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1243: l_change_detail_link := FND_MESSAGE.GET ;
1244:
1245: ELSIF l_mesg_attribute_rec.change_line_id IS NOT NULL
1246: THEN
1239:
1240: -- Get Detail Url Link
1241: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_DETAIL_LINK_NTF') ;
1242: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1243: l_change_detail_link := FND_MESSAGE.GET ;
1244:
1245: ELSIF l_mesg_attribute_rec.change_line_id IS NOT NULL
1246: THEN
1247: l_change_name := l_mesg_attribute_rec.line_name ;
1253: || TO_CHAR(l_mesg_attribute_rec.change_line_id)
1254: || '&OAFunc=ENG_CHANGE_LINE_DETAIL_PAGE' ;
1255:
1256: -- Get Sub Header
1257: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_LINE_SUMMARY') ;
1258: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1259: l_additional_info_subh := FND_MESSAGE.GET ;
1260:
1261:
1254: || '&OAFunc=ENG_CHANGE_LINE_DETAIL_PAGE' ;
1255:
1256: -- Get Sub Header
1257: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_LINE_SUMMARY') ;
1258: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1259: l_additional_info_subh := FND_MESSAGE.GET ;
1260:
1261:
1262: -- Get Detail Url Link
1255:
1256: -- Get Sub Header
1257: FND_MESSAGE.SET_NAME('ENG', 'ENG_CHANGE_LINE_SUMMARY') ;
1258: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1259: l_additional_info_subh := FND_MESSAGE.GET ;
1260:
1261:
1262: -- Get Detail Url Link
1263: FND_MESSAGE.SET_NAME('ENG', 'ENG_LINE_DETAIL_LINK_NTF') ;
1259: l_additional_info_subh := FND_MESSAGE.GET ;
1260:
1261:
1262: -- Get Detail Url Link
1263: FND_MESSAGE.SET_NAME('ENG', 'ENG_LINE_DETAIL_LINK_NTF') ;
1264: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1265: l_change_detail_link := FND_MESSAGE.GET ;
1266:
1267:
1260:
1261:
1262: -- Get Detail Url Link
1263: FND_MESSAGE.SET_NAME('ENG', 'ENG_LINE_DETAIL_LINK_NTF') ;
1264: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1265: l_change_detail_link := FND_MESSAGE.GET ;
1266:
1267:
1268: END IF ;
1261:
1262: -- Get Detail Url Link
1263: FND_MESSAGE.SET_NAME('ENG', 'ENG_LINE_DETAIL_LINK_NTF') ;
1264: FND_MESSAGE.SET_TOKEN('CHANGE_MGMT_TYPE', l_mesg_attribute_rec.change_management_type) ;
1265: l_change_detail_link := FND_MESSAGE.GET ;
1266:
1267:
1268: END IF ;
1269: