116: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
117: CLOSE c_ap_rec;
118: l_requestor_name :=
119: amw_utility_pvt.get_employee_name (l_requestor_id);
120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
121: fnd_message.set_token ('NAME', l_ap_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
124: /*
117: CLOSE c_ap_rec;
118: l_requestor_name :=
119: amw_utility_pvt.get_employee_name (l_requestor_id);
120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
121: fnd_message.set_token ('NAME', l_ap_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
124: /*
125: wf_engine.setitemattrtext (
118: l_requestor_name :=
119: amw_utility_pvt.get_employee_name (l_requestor_id);
120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
121: fnd_message.set_token ('NAME', l_ap_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
124: /*
125: wf_engine.setitemattrtext (
126: itemtype=> l_item_type,
119: amw_utility_pvt.get_employee_name (l_requestor_id);
120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
121: fnd_message.set_token ('NAME', l_ap_name, FALSE);
122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
123: l_string := SUBSTR (fnd_message.get, 1, 1000);
124: /*
125: wf_engine.setitemattrtext (
126: itemtype=> l_item_type,
127: itemkey=> l_item_key,
128: aname => 'FYI_SUBJECT',
129: avalue=> l_string
130: );
131: */
132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
129: avalue=> l_string
130: );
131: */
132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
137: /*
130: );
131: */
132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
137: /*
138: l_note := wf_engine.getitemattrtext(
131: */
132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
137: /*
138: l_note := wf_engine.getitemattrtext(
139: itemtype => l_item_type
132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
137: /*
138: l_note := wf_engine.getitemattrtext(
139: itemtype => l_item_type
140: ,itemkey => l_item_key
278: OPEN c_ap_rec (l_ap_rev_id);
279: FETCH c_ap_rec
280: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
281: CLOSE c_ap_rec;
282: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
283: fnd_message.set_token ('NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
279: FETCH c_ap_rec
280: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
281: CLOSE c_ap_rec;
282: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
283: fnd_message.set_token ('NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
280: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
281: CLOSE c_ap_rec;
282: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
283: fnd_message.set_token ('NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
281: CLOSE c_ap_rec;
282: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
283: fnd_message.set_token ('NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
285: l_string := SUBSTR (fnd_message.get, 1, 1000);
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
293: /*
286: l_requestor_name :=
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
293: /*
294: l_note := wf_engine.getitemattrtext(
287: amw_utility_pvt.get_employee_name (l_requestor_id);
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
293: /*
294: l_note := wf_engine.getitemattrtext(
295: itemtype => l_item_type
288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
289: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
293: /*
294: l_note := wf_engine.getitemattrtext(
295: itemtype => l_item_type
296: ,itemkey => l_item_key
310: );
311: SELECT SYSDATE
312: INTO l_approval_date
313: FROM DUAL;
314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);
317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
311: SELECT SYSDATE
312: INTO l_approval_date
313: FROM DUAL;
314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);
317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
319: -- IF (display_type = 'text/plain') THEN
312: INTO l_approval_date
313: FROM DUAL;
314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);
317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
319: -- IF (display_type = 'text/plain') THEN
320: l_appr_notification :=
313: FROM DUAL;
314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);
317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
319: -- IF (display_type = 'text/plain') THEN
320: l_appr_notification :=
321: SUBSTR ( l_string
314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');
315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);
317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
319: -- IF (display_type = 'text/plain') THEN
320: l_appr_notification :=
321: SUBSTR ( l_string
322: || fnd_global.local_chr (10)
452: OPEN c_ap_rec (l_ap_rev_id);
453: FETCH c_ap_rec
454: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
455: CLOSE c_ap_rec;
456: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
457: fnd_message.set_token ('NAME', l_ap_name, FALSE);
458: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
459: l_string := SUBSTR (fnd_message.get, 1, 1000);
460: /*
453: FETCH c_ap_rec
454: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
455: CLOSE c_ap_rec;
456: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
457: fnd_message.set_token ('NAME', l_ap_name, FALSE);
458: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
459: l_string := SUBSTR (fnd_message.get, 1, 1000);
460: /*
461: wf_engine.setitemattrtext (
454: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
455: CLOSE c_ap_rec;
456: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
457: fnd_message.set_token ('NAME', l_ap_name, FALSE);
458: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
459: l_string := SUBSTR (fnd_message.get, 1, 1000);
460: /*
461: wf_engine.setitemattrtext (
462: itemtype=> l_item_type,
455: CLOSE c_ap_rec;
456: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
457: fnd_message.set_token ('NAME', l_ap_name, FALSE);
458: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
459: l_string := SUBSTR (fnd_message.get, 1, 1000);
460: /*
461: wf_engine.setitemattrtext (
462: itemtype=> l_item_type,
463: itemkey=> l_item_key,
466: );
467: */
468: l_requestor_name :=
469: amw_utility_pvt.get_employee_name (l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
467: */
468: l_requestor_name :=
469: amw_utility_pvt.get_employee_name (l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
468: l_requestor_name :=
469: amw_utility_pvt.get_employee_name (l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
469: amw_utility_pvt.get_employee_name (l_requestor_id);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
478: /*
471: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
478: /*
479: l_note := wf_engine.getitemattrtext(
472: --fnd_message.set_token ('OWNER', l_requestor, FALSE);
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
478: /*
479: l_note := wf_engine.getitemattrtext(
480: itemtype => l_item_type
473: --fnd_message.set_token ('START_DATE', l_start_date, FALSE);
474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);
475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);
476: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
478: /*
479: l_note := wf_engine.getitemattrtext(
480: itemtype => l_item_type
481: ,itemkey => l_item_key
492: wf_engine.getitemattrtext (itemtype => l_item_type,
493: itemkey => l_item_key,
494: aname => 'APPROVAL_NOTE'
495: );
496: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
497: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
498: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
499: l_rej_notification :=
500: SUBSTR ( l_string
493: itemkey => l_item_key,
494: aname => 'APPROVAL_NOTE'
495: );
496: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
497: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
498: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
499: l_rej_notification :=
500: SUBSTR ( l_string
501: || fnd_global.local_chr (10)
494: aname => 'APPROVAL_NOTE'
495: );
496: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');
497: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
498: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
499: l_rej_notification :=
500: SUBSTR ( l_string
501: || fnd_global.local_chr (10)
502: || l_string1
616: OPEN c_ap_rec (l_ap_rev_id);
617: FETCH c_ap_rec
618: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
619: CLOSE c_ap_rec;
620: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
621: fnd_message.set_token ('NAME', l_ap_name, FALSE);
622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
623: l_string := SUBSTR (fnd_message.get, 1, 1000);
624: /*
617: FETCH c_ap_rec
618: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
619: CLOSE c_ap_rec;
620: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
621: fnd_message.set_token ('NAME', l_ap_name, FALSE);
622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
623: l_string := SUBSTR (fnd_message.get, 1, 1000);
624: /*
625: wf_engine.setitemattrtext (
618: INTO l_ap_id, l_ap_name, l_start_date, l_requestor_id;
619: CLOSE c_ap_rec;
620: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
621: fnd_message.set_token ('NAME', l_ap_name, FALSE);
622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
623: l_string := SUBSTR (fnd_message.get, 1, 1000);
624: /*
625: wf_engine.setitemattrtext (
626: itemtype=> l_item_type,
619: CLOSE c_ap_rec;
620: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
621: fnd_message.set_token ('NAME', l_ap_name, FALSE);
622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
623: l_string := SUBSTR (fnd_message.get, 1, 1000);
624: /*
625: wf_engine.setitemattrtext (
626: itemtype=> l_item_type,
627: itemkey=> l_item_key,
630: );
631: */
632: l_requestor_name :=
633: amw_utility_pvt.get_employee_name (l_requestor_id);
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
631: */
632: l_requestor_name :=
633: amw_utility_pvt.get_employee_name (l_requestor_id);
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
632: l_requestor_name :=
633: amw_utility_pvt.get_employee_name (l_requestor_id);
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
640: l_note :=
633: amw_utility_pvt.get_employee_name (l_requestor_id);
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
640: l_note :=
641: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
640: l_note :=
641: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
642: itemkey => l_item_key,
635: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);
637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
640: l_note :=
641: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
642: itemkey => l_item_key,
643: aname => 'AMW_PREV_APPROVER_NOTE'
658: )
659: ),
660: '-'
661: );
662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
665: fnd_message.set_token ('COMMENTS', l_note, FALSE);
666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
659: ),
660: '-'
661: );
662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
665: fnd_message.set_token ('COMMENTS', l_note, FALSE);
666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
667: -- IF (display_type = 'text/plain') THEN
660: '-'
661: );
662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
665: fnd_message.set_token ('COMMENTS', l_note, FALSE);
666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
667: -- IF (display_type = 'text/plain') THEN
668: l_appreq_notification :=
661: );
662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
665: fnd_message.set_token ('COMMENTS', l_note, FALSE);
666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
667: -- IF (display_type = 'text/plain') THEN
668: l_appreq_notification :=
669: l_string
662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
665: fnd_message.set_token ('COMMENTS', l_note, FALSE);
666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
667: -- IF (display_type = 'text/plain') THEN
668: l_appreq_notification :=
669: l_string
670: || fnd_global.local_chr (10)
795: OPEN c_ap_rec (l_ap_rev_id);
796: FETCH c_ap_rec
797: INTO l_ap_id, l_ap_name, l_start_date;
798: CLOSE c_ap_rec;
799: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
800: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
802: l_string := SUBSTR (fnd_message.get, 1, 1000);
803: /*
796: FETCH c_ap_rec
797: INTO l_ap_id, l_ap_name, l_start_date;
798: CLOSE c_ap_rec;
799: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
800: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
802: l_string := SUBSTR (fnd_message.get, 1, 1000);
803: /*
804: wf_engine.setitemattrtext (
797: INTO l_ap_id, l_ap_name, l_start_date;
798: CLOSE c_ap_rec;
799: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
800: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
802: l_string := SUBSTR (fnd_message.get, 1, 1000);
803: /*
804: wf_engine.setitemattrtext (
805: itemtype=> l_item_type,
798: CLOSE c_ap_rec;
799: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
800: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);
802: l_string := SUBSTR (fnd_message.get, 1, 1000);
803: /*
804: wf_engine.setitemattrtext (
805: itemtype=> l_item_type,
806: itemkey=> l_item_key,
807: aname => 'APP_SUBJECT',
808: avalue=> l_string
809: );
810: */
811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
808: avalue=> l_string
809: );
810: */
811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
809: );
810: */
811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
817: l_note :=
810: */
811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
817: l_note :=
818: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
817: l_note :=
818: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
819: itemkey => l_item_key,
812: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);
813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);
815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);
817: l_note :=
818: NVL (wf_engine.getitemattrtext (itemtype => l_item_type,
819: itemkey => l_item_key,
820: aname => 'AMW_PREV_APPROVER_NOTE'
835: )
836: ),
837: '-'
838: );
839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
836: ),
837: '-'
838: );
839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
844: /*
837: '-'
838: );
839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
844: /*
845: l_note := wf_engine.getitemattrtext(
838: );
839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
844: /*
845: l_note := wf_engine.getitemattrtext(
846: itemtype => l_item_type
839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');
840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
842: fnd_message.set_token ('COMMENTS', l_note, FALSE);
843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);
844: /*
845: l_note := wf_engine.getitemattrtext(
846: itemtype => l_item_type
847: ,itemkey => l_item_key
951: CLOSE c_ap_rec;
952: l_lookup_meaning :=
953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');
954: --- set all the subjects here
955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_ap_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
958: l_string := SUBSTR (fnd_message.get, 1, 1000);
959: wf_engine.setitemattrtext (itemtype => itemtype,
952: l_lookup_meaning :=
953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');
954: --- set all the subjects here
955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_ap_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
958: l_string := SUBSTR (fnd_message.get, 1, 1000);
959: wf_engine.setitemattrtext (itemtype => itemtype,
960: itemkey => itemkey,
953: amw_utility_pvt.get_lookup_meaning ('AMW_OBJECT_TYPE', 'AP');
954: --- set all the subjects here
955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_ap_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
958: l_string := SUBSTR (fnd_message.get, 1, 1000);
959: wf_engine.setitemattrtext (itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'FYI_SUBJECT',
954: --- set all the subjects here
955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');
956: fnd_message.set_token ('NAME', l_ap_name, FALSE);
957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
958: l_string := SUBSTR (fnd_message.get, 1, 1000);
959: wf_engine.setitemattrtext (itemtype => itemtype,
960: itemkey => itemkey,
961: aname => 'FYI_SUBJECT',
962: avalue => l_string
960: itemkey => itemkey,
961: aname => 'FYI_SUBJECT',
962: avalue => l_string
963: );
964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
965: fnd_message.set_token ('NAME', l_ap_name, FALSE);
966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
967: l_string := SUBSTR (fnd_message.get, 1, 1000);
968: wf_engine.setitemattrtext (itemtype => itemtype,
961: aname => 'FYI_SUBJECT',
962: avalue => l_string
963: );
964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
965: fnd_message.set_token ('NAME', l_ap_name, FALSE);
966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
967: l_string := SUBSTR (fnd_message.get, 1, 1000);
968: wf_engine.setitemattrtext (itemtype => itemtype,
969: itemkey => itemkey,
962: avalue => l_string
963: );
964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
965: fnd_message.set_token ('NAME', l_ap_name, FALSE);
966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
967: l_string := SUBSTR (fnd_message.get, 1, 1000);
968: wf_engine.setitemattrtext (itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APRV_SUBJECT',
963: );
964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');
965: fnd_message.set_token ('NAME', l_ap_name, FALSE);
966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
967: l_string := SUBSTR (fnd_message.get, 1, 1000);
968: wf_engine.setitemattrtext (itemtype => itemtype,
969: itemkey => itemkey,
970: aname => 'APRV_SUBJECT',
971: avalue => l_string
969: itemkey => itemkey,
970: aname => 'APRV_SUBJECT',
971: avalue => l_string
972: );
973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
974: fnd_message.set_token ('NAME', l_ap_name, FALSE);
975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
976: l_string := SUBSTR (fnd_message.get, 1, 1000);
977: wf_engine.setitemattrtext (itemtype => itemtype,
970: aname => 'APRV_SUBJECT',
971: avalue => l_string
972: );
973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
974: fnd_message.set_token ('NAME', l_ap_name, FALSE);
975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
976: l_string := SUBSTR (fnd_message.get, 1, 1000);
977: wf_engine.setitemattrtext (itemtype => itemtype,
978: itemkey => itemkey,
971: avalue => l_string
972: );
973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
974: fnd_message.set_token ('NAME', l_ap_name, FALSE);
975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
976: l_string := SUBSTR (fnd_message.get, 1, 1000);
977: wf_engine.setitemattrtext (itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'REJECT_SUBJECT',
972: );
973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');
974: fnd_message.set_token ('NAME', l_ap_name, FALSE);
975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
976: l_string := SUBSTR (fnd_message.get, 1, 1000);
977: wf_engine.setitemattrtext (itemtype => itemtype,
978: itemkey => itemkey,
979: aname => 'REJECT_SUBJECT',
980: avalue => l_string
978: itemkey => itemkey,
979: aname => 'REJECT_SUBJECT',
980: avalue => l_string
981: );
982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
983: fnd_message.set_token ('NAME', l_ap_name, FALSE);
984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
985: l_string := SUBSTR (fnd_message.get, 1, 1000);
986: wf_engine.setitemattrtext (itemtype => itemtype,
979: aname => 'REJECT_SUBJECT',
980: avalue => l_string
981: );
982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
983: fnd_message.set_token ('NAME', l_ap_name, FALSE);
984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
985: l_string := SUBSTR (fnd_message.get, 1, 1000);
986: wf_engine.setitemattrtext (itemtype => itemtype,
987: itemkey => itemkey,
980: avalue => l_string
981: );
982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
983: fnd_message.set_token ('NAME', l_ap_name, FALSE);
984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
985: l_string := SUBSTR (fnd_message.get, 1, 1000);
986: wf_engine.setitemattrtext (itemtype => itemtype,
987: itemkey => itemkey,
988: aname => 'APP_SUBJECT',
981: );
982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');
983: fnd_message.set_token ('NAME', l_ap_name, FALSE);
984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);
985: l_string := SUBSTR (fnd_message.get, 1, 1000);
986: wf_engine.setitemattrtext (itemtype => itemtype,
987: itemkey => itemkey,
988: aname => 'APP_SUBJECT',
989: avalue => l_string