DBA Data[Home] [Help]

APPS.OZF_FUND_APPROVAL_PVT dependencies on FND_GLOBAL

Line 242: || fnd_global.local_chr (10)

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

Line 244: || fnd_global.local_chr (10)

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';

Line 254: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 256: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 468: || fnd_global.local_chr (10)

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

Line 470: || fnd_global.local_chr (10)

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';

Line 480: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 482: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 679: || fnd_global.local_chr (10)

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

Line 681: || fnd_global.local_chr (10)

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';

Line 897: || fnd_global.local_chr (10)

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

Line 899: || fnd_global.local_chr (10)

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';

Line 909: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 911: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 1123: || fnd_global.local_chr (10)

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

Line 1125: || fnd_global.local_chr (10)

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';

Line 1135: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 1137: FND_GLOBAL.LOCAL_CHR(10) ||

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;

Line 1625: --Bug 14725235 , comment out the FND_GLOBAL... code

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;

Line 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:

Line 1630: l_resp_id := FND_GLOBAL.resp_id;

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

Line 1631: l_appl_id := FND_GLOBAL.resp_appl_id;

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

Line 1632: l_security_group_id := FND_GLOBAL.security_group_id;*/

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'

Line 1690: FND_GLOBAL.apps_initialize( user_id => l_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: );