134: l_start_date,
135: l_requestor_id;
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
135: l_requestor_id;
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
136: CLOSE c_CTRL_rec;
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
144: itemtype=> l_item_type,
137: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
138: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
139: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
140: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
141: l_string := SUBSTR(fnd_message.get,1,1000);
142: /*
143: wf_engine.setitemattrtext (
144: itemtype=> l_item_type,
145: itemkey=> l_item_key,
146: aname => 'FYI_SUBJECT',
147: avalue=> l_string
148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
147: avalue=> l_string
148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
148: );
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
149: */
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
157: l_note := wf_engine.getitemattrtext(
150: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
151: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
152: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
153: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
154: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
155:
156: /*
157: l_note := wf_engine.getitemattrtext(
158: itemtype => l_item_type
311: l_CTRL_name,
312: l_start_date,
313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
312: l_start_date,
313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
313: l_requestor_id;
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
314: CLOSE c_CTRL_rec;
315: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
317: fnd_message.set_token ('OBJECT_TYPE', l_CTRL_name, FALSE);
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
318: l_string := Substr(FND_MESSAGE.Get,1,1000);
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
319: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
327: l_note := wf_engine.getitemattrtext(
320: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
321: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
322: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
323: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
324: l_string1 := Substr(FND_MESSAGE.Get,1,2500);
325:
326: /*
327: l_note := wf_engine.getitemattrtext(
328: itemtype => l_item_type
347: SELECT SYSDATE
348: INTO l_approval_date
349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
348: INTO l_approval_date
349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
349: FROM DUAL;
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:
350:
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:
358: -- IF (display_type = 'text/plain') THEN
351: fnd_message.set_name('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
352: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
353: fnd_message.set_token('COMMENTS', l_approver_note, FALSE);
354: fnd_message.set_token('APPROVAL_DATE', l_approval_date , FALSE);
355: l_string2 := Substr(FND_MESSAGE.Get,1,2500);
356:
357:
358: -- IF (display_type = 'text/plain') THEN
359: l_appr_notification := SUBSTR(l_string
506: l_CTRL_name,
507: l_start_date,
508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
507: l_start_date,
508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
508: l_requestor_id;
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
516: itemtype=> l_item_type,
509: CLOSE c_CTRL_rec;
510: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
511: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
512: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
513: l_string := Substr(FND_MESSAGE.Get,1,1000);
514: /*
515: wf_engine.setitemattrtext (
516: itemtype=> l_item_type,
517: itemkey=> l_item_key,
519: avalue=> l_string
520: );
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
520: );
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
521: */
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
522: --l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
523: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
524: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
525: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
533: itemtype => l_item_type
526: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
527: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
528: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
529: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
530: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
531: /*
532: l_note := wf_engine.getitemattrtext(
533: itemtype => l_item_type
534: ,itemkey => l_item_key
548: itemtype=> l_item_type,
549: itemkey=> l_item_key,
550: aname => 'APPROVAL_NOTE'
551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:
549: itemkey=> l_item_key,
550: aname => 'APPROVAL_NOTE'
551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:
557: l_rej_notification := SUBSTR(l_string
551: );
552: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
553: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
554:
555: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
556:
557: l_rej_notification := SUBSTR(l_string
558: || fnd_global.local_chr (10)
559: || l_string1
688: l_CTRL_name,
689: l_start_date,
690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
689: l_start_date,
690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
690: l_requestor_id;
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
698: itemtype=> l_item_type,
691: CLOSE c_CTRL_rec;
692: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
693: fnd_message.set_token ('NAME', l_CTRL_name, FALSE);
694: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
695: l_string := SUBSTR(fnd_message.get,1,1000);
696: /*
697: wf_engine.setitemattrtext (
698: itemtype=> l_item_type,
699: itemkey=> l_item_key,
701: avalue=> l_string
702: );
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
702: );
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
703: */
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
704: l_requestor_name := amw_utility_pvt.get_employee_name(l_requestor_id);
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
705: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
713: itemtype=> l_item_type,
706: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
707: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
708: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
709: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
710: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
711: l_note :=
712: NVL(wf_engine.getitemattrtext (
713: itemtype=> l_item_type,
714: itemkey=> l_item_key,
724: itemtype => l_item_type,
725: itemkey => l_item_key,
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
725: itemkey => l_item_key,
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
726: aname => 'AMW_APPROVAL_DATE')),'-');
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string
727:
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string
735: || fnd_global.local_chr (10)
728: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
729: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
730: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
731: fnd_message.set_token ('COMMENTS', l_note, FALSE);
732: l_string2 := SUBSTR(fnd_message.get,1,2500);
733: -- IF (display_type = 'text/plain') THEN
734: l_appreq_notification := l_string
735: || fnd_global.local_chr (10)
736: || l_string1
878: FETCH c_CTRL_rec INTO l_CTRL_id,
879: l_CTRL_name,
880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
879: l_CTRL_name,
880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
880: l_start_date;
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
888: itemtype=> l_item_type,
881: CLOSE c_CTRL_rec;
882: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
883: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
884: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
885: l_string := SUBSTR(fnd_message.get,1,1000);
886: /*
887: wf_engine.setitemattrtext (
888: itemtype=> l_item_type,
889: itemkey=> l_item_key,
890: aname => 'APP_SUBJECT',
891: avalue=> l_string
892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
891: avalue=> l_string
892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
892: );
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
893: */
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
901: l_note :=
894: fnd_message.set_name ('AMW', 'AMW_WF_NTF_CTRL_REQ_INFO');
895: fnd_message.set_token ('CTRL_NAME', l_CTRL_name, FALSE);
896: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
897: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
898: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
899:
900:
901: l_note :=
902: NVL(wf_engine.getitemattrtext (
914: itemtype => l_item_type,
915: itemkey => l_item_key,
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
915: itemkey => l_item_key,
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
916: aname => 'AMW_APPROVAL_DATE')),'-');
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
917:
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
918: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
926: itemtype => l_item_type
919: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
920: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
921: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
922: fnd_message.set_token ('COMMENTS', l_note, FALSE);
923: l_string2 := SUBSTR(fnd_message.get,1,2500);
924: /*
925: l_note := wf_engine.getitemattrtext(
926: itemtype => l_item_type
927: ,itemkey => l_item_key
1038: l_start_date;
1039: CLOSE c_CTRL_rec;
1040: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
1041: --- set all the subjects here
1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
1043: fnd_message.set_token (
1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE
1039: CLOSE c_CTRL_rec;
1040: l_lookup_meaning := amw_utility_pvt.get_lookup_meaning('AMW_OBJECT_TYPE','CTRL');
1041: --- set all the subjects here
1042: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
1043: fnd_message.set_token (
1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE
1047: );
1044: 'NAME',
1045: l_CTRL_name,
1046: FALSE
1047: );
1048: fnd_message.set_token (
1049: 'OBJECT_TYPE',
1050: l_lookup_meaning,
1051: FALSE
1052: );
1050: l_lookup_meaning,
1051: FALSE
1052: );
1053:
1054: l_string := Substr(FND_MESSAGE.Get,1,1000);
1055: wf_engine.setitemattrtext (
1056: itemtype=> itemtype,
1057: itemkey=> itemkey,
1058: aname => 'FYI_SUBJECT',
1058: aname => 'FYI_SUBJECT',
1059: avalue=> l_string
1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,
1059: avalue=> l_string
1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,
1067: FALSE
1060: );
1061:
1062: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
1063: fnd_message.set_token ('NAME', l_CTRL_name, FALSE );
1064: fnd_message.set_token (
1065: 'OBJECT_TYPE',
1066: l_lookup_meaning,
1067: FALSE
1068: );
1066: l_lookup_meaning,
1067: FALSE
1068: );
1069:
1070: l_string := Substr(FND_MESSAGE.Get,1,1000);
1071: wf_engine.setitemattrtext (
1072: itemtype=> itemtype,
1073: itemkey=> itemkey,
1074: aname => 'APRV_SUBJECT',
1073: itemkey=> itemkey,
1074: aname => 'APRV_SUBJECT',
1075: avalue=> l_string
1076: );
1077: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
1078: fnd_message.set_token (
1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE
1074: aname => 'APRV_SUBJECT',
1075: avalue=> l_string
1076: );
1077: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
1078: fnd_message.set_token (
1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE
1082: );
1079: 'NAME',
1080: l_CTRL_name,
1081: FALSE
1082: );
1083: fnd_message.set_token (
1084: 'OBJECT_TYPE',
1085: l_lookup_meaning,
1086: FALSE
1087: );
1085: l_lookup_meaning,
1086: FALSE
1087: );
1088:
1089: l_string := Substr(FND_MESSAGE.Get,1,1000);
1090: wf_engine.setitemattrtext (
1091: itemtype=> itemtype,
1092: itemkey=> itemkey,
1093: aname => 'REJECT_SUBJECT',
1092: itemkey=> itemkey,
1093: aname => 'REJECT_SUBJECT',
1094: avalue=> l_string
1095: );
1096: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
1097: fnd_message.set_token (
1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE
1093: aname => 'REJECT_SUBJECT',
1094: avalue=> l_string
1095: );
1096: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
1097: fnd_message.set_token (
1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE
1101: );
1098: 'NAME',
1099: l_CTRL_name,
1100: FALSE
1101: );
1102: fnd_message.set_token (
1103: 'OBJECT_TYPE',
1104: l_lookup_meaning,
1105: FALSE
1106: );
1104: l_lookup_meaning,
1105: FALSE
1106: );
1107:
1108: l_string := Substr(FND_MESSAGE.Get,1,1000);
1109: wf_engine.setitemattrtext (
1110: itemtype=> itemtype,
1111: itemkey=> itemkey,
1112: aname => 'APP_SUBJECT',