238: ,aname => 'AMS_FORWARD_FROM_USERNAME');
239: */
240: -- IF (display_type = 'text/plain') THEN
241: l_fyi_notification := SUBSTR(l_string
242: || fnd_global.local_chr (10)
243: || l_string1
244: || fnd_global.local_chr (10)
245: || l_string2,1,10000);
246: document := document
240: -- IF (display_type = 'text/plain') THEN
241: l_fyi_notification := SUBSTR(l_string
242: || fnd_global.local_chr (10)
243: || l_string1
244: || fnd_global.local_chr (10)
245: || l_string2,1,10000);
246: document := document
247: || l_fyi_notification;
248: document_type := 'text/plain';
250: -- END IF;
251: /* IF (display_type = 'text/html') THEN
252: l_fyi_notification :=
253: l_string ||
254: FND_GLOBAL.LOCAL_CHR(10) ||
255: l_string1 ||
256: FND_GLOBAL.LOCAL_CHR(10) ||
257: l_string2;
258: document := document||l_appreq_notification;
252: l_fyi_notification :=
253: l_string ||
254: FND_GLOBAL.LOCAL_CHR(10) ||
255: l_string1 ||
256: FND_GLOBAL.LOCAL_CHR(10) ||
257: l_string2;
258: document := document||l_appreq_notification;
259: document_type := 'text/html';
260: RETURN;
464: l_string2 := fnd_message.get;
465: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
466: -- IF (display_type = 'text/plain') THEN
467: l_appr_notification := SUBSTR(l_string
468: || fnd_global.local_chr (10)
469: || l_string1
470: || fnd_global.local_chr (10)
471: || l_string2,1,10000);
472: document := document
466: -- IF (display_type = 'text/plain') THEN
467: l_appr_notification := SUBSTR(l_string
468: || fnd_global.local_chr (10)
469: || l_string1
470: || fnd_global.local_chr (10)
471: || l_string2,1,10000);
472: document := document
473: || l_appr_notification;
474: document_type := 'text/plain';
476: -- END IF;
477: /* IF (display_type = 'text/html') THEN
478: l_appreq_notification :=
479: l_string ||
480: FND_GLOBAL.LOCAL_CHR(10) ||
481: l_string1 ||
482: FND_GLOBAL.LOCAL_CHR(10) ||
483: l_string2;
484: document := document||l_appreq_notification;
478: l_appreq_notification :=
479: l_string ||
480: FND_GLOBAL.LOCAL_CHR(10) ||
481: l_string1 ||
482: FND_GLOBAL.LOCAL_CHR(10) ||
483: l_string2;
484: document := document||l_appreq_notification;
485: document_type := 'text/html';
486: RETURN;
675: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
676: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
677: -- IF (display_type = 'text/plain') THEN
678: l_rej_notification := SUBSTR(l_string
679: || fnd_global.local_chr (10)
680: || l_string1
681: || fnd_global.local_chr (10)
682: || l_string2,1,10000);
683: document := document
677: -- IF (display_type = 'text/plain') THEN
678: l_rej_notification := SUBSTR(l_string
679: || fnd_global.local_chr (10)
680: || l_string1
681: || fnd_global.local_chr (10)
682: || l_string2,1,10000);
683: document := document
684: || l_rej_notification;
685: document_type := 'text/plain';
893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
894: l_string2 := SUBSTR(fnd_message.get,1,2500);
895: -- IF (display_type = 'text/plain') THEN
896: l_appreq_notification := l_string
897: || fnd_global.local_chr (10)
898: || l_string1
899: || fnd_global.local_chr (10)
900: || l_string2;
901: document := document
895: -- IF (display_type = 'text/plain') THEN
896: l_appreq_notification := l_string
897: || fnd_global.local_chr (10)
898: || l_string1
899: || fnd_global.local_chr (10)
900: || l_string2;
901: document := document
902: || l_appreq_notification;
903: document_type := 'text/plain';
905: -- END IF;
906: /* IF (display_type = 'text/html') THEN
907: l_appreq_notification :=
908: l_string ||
909: FND_GLOBAL.LOCAL_CHR(10) ||
910: l_string1 ||
911: FND_GLOBAL.LOCAL_CHR(10) ||
912: l_string2;
913: document := document||l_appreq_notification;
907: l_appreq_notification :=
908: l_string ||
909: FND_GLOBAL.LOCAL_CHR(10) ||
910: l_string1 ||
911: FND_GLOBAL.LOCAL_CHR(10) ||
912: l_string2;
913: document := document||l_appreq_notification;
914: document_type := 'text/html';
915: RETURN;
1119: ,aname => 'AMS_FORWARD_FROM_USERNAME');
1120: */
1121: -- IF (display_type = 'text/plain') THEN
1122: l_apprem_notification := l_string
1123: || fnd_global.local_chr (10)
1124: || l_string1
1125: || fnd_global.local_chr (10)
1126: || l_string2;
1127: document := document
1121: -- IF (display_type = 'text/plain') THEN
1122: l_apprem_notification := l_string
1123: || fnd_global.local_chr (10)
1124: || l_string1
1125: || fnd_global.local_chr (10)
1126: || l_string2;
1127: document := document
1128: || l_apprem_notification;
1129: document_type := 'text/plain';
1131: -- END IF;
1132: /* IF (display_type = 'text/html') THEN
1133: l_appreq_notification :=
1134: l_string ||
1135: FND_GLOBAL.LOCAL_CHR(10) ||
1136: l_string1 ||
1137: FND_GLOBAL.LOCAL_CHR(10) ||
1138: l_string2;
1139: document := document||l_appreq_notification;
1133: l_appreq_notification :=
1134: l_string ||
1135: FND_GLOBAL.LOCAL_CHR(10) ||
1136: l_string1 ||
1137: FND_GLOBAL.LOCAL_CHR(10) ||
1138: l_string2;
1139: document := document||l_appreq_notification;
1140: document_type := 'text/html';
1141: RETURN;
1621: -- [BEGIN OF BUG 2916480 FIXING by yzhao 23-APR-2003]
1622: -- yzhao: initialized PL/SQL security context(especially application_id)
1623: -- since self service workflow didn't set application_id when approver approves.
1624:
1625: --Bug 14725235 , comment out the FND_GLOBAL... code
1626: -- get details from the wf item attributes,
1627: -- These attributes were set by ams_gen_approval_pvt.StartProcess
1628:
1629: /*l_user_id := FND_GLOBAL.user_id;
1625: --Bug 14725235 , comment out the FND_GLOBAL... code
1626: -- get details from the wf item attributes,
1627: -- These attributes were set by ams_gen_approval_pvt.StartProcess
1628:
1629: /*l_user_id := FND_GLOBAL.user_id;
1630: l_resp_id := FND_GLOBAL.resp_id;
1631: l_appl_id := FND_GLOBAL.resp_appl_id;
1632: l_security_group_id := FND_GLOBAL.security_group_id;*/
1633:
1626: -- get details from the wf item attributes,
1627: -- These attributes were set by ams_gen_approval_pvt.StartProcess
1628:
1629: /*l_user_id := FND_GLOBAL.user_id;
1630: l_resp_id := FND_GLOBAL.resp_id;
1631: l_appl_id := FND_GLOBAL.resp_appl_id;
1632: l_security_group_id := FND_GLOBAL.security_group_id;*/
1633:
1634: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1627: -- These attributes were set by ams_gen_approval_pvt.StartProcess
1628:
1629: /*l_user_id := FND_GLOBAL.user_id;
1630: l_resp_id := FND_GLOBAL.resp_id;
1631: l_appl_id := FND_GLOBAL.resp_appl_id;
1632: l_security_group_id := FND_GLOBAL.security_group_id;*/
1633:
1634: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1635: , itemkey => itemkey
1628:
1629: /*l_user_id := FND_GLOBAL.user_id;
1630: l_resp_id := FND_GLOBAL.resp_id;
1631: l_appl_id := FND_GLOBAL.resp_appl_id;
1632: l_security_group_id := FND_GLOBAL.security_group_id;*/
1633:
1634: l_user_id := WF_ENGINE.getitemattrnumber( itemtype => itemtype
1635: , itemkey => itemkey
1636: , aname => 'USER_ID'
1686: resultout := 'COMPLETE:ERROR';
1687: RETURN;
1688: ELSIF l_update_status IN ('APPROVED', 'REJECTED') THEN
1689: --Bug 14725235
1690: FND_GLOBAL.apps_initialize( user_id => l_user_id
1691: , resp_id => l_resp_id
1692: , resp_appl_id => l_appl_id
1693: --, security_group_id => l_security_group_id
1694: );