DBA Data[Home] [Help]

APPS.AMW_AP_APPROVAL_PVT dependencies on FND_MESSAGE

Line 120: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');

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: /*

Line 121: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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 (

Line 122: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

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,

Line 123: l_string := SUBSTR (fnd_message.get, 1, 1000);

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,

Line 132: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');

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

Line 133: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);

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: /*

Line 134: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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(

Line 135: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

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

Line 136: l_string1 := SUBSTR (fnd_message.get, 1, 2500);

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

Line 282: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');

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

Line 283: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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

Line 284: fnd_message.set_token ('OBJECT_TYPE', l_ap_name, FALSE);

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

Line 285: l_string := SUBSTR (fnd_message.get, 1, 1000);

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

Line 288: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');

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

Line 289: fnd_message.set_token ('AP_NAME', 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);
293: /*

Line 290: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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(

Line 291: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

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

Line 292: l_string1 := SUBSTR (fnd_message.get, 1, 2500);

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

Line 314: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_ADDENDUM');

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

Line 315: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

Line 316: fnd_message.set_token ('COMMENTS', l_approver_note, FALSE);

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

Line 317: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);

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

Line 318: l_string2 := SUBSTR (fnd_message.get, 1, 2500);

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)

Line 456: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');

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: /*

Line 457: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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 (

Line 458: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

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,

Line 459: l_string := SUBSTR (fnd_message.get, 1, 1000);

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,

Line 470: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');

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

Line 471: fnd_message.set_token ('AP_NAME', l_ap_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);

Line 472: --fnd_message.set_token ('OWNER', l_requestor, 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);

Line 473: --fnd_message.set_token ('START_DATE', l_start_date, 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);

Line 474: fnd_message.set_token ('APPROVER_NAME', '-', FALSE);

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: /*

Line 475: fnd_message.set_token ('REQUESTOR_NAME', '-', FALSE);

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(

Line 476: --fnd_message.set_token ('DESCRIPTION', l_note, 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(
480: itemtype => l_item_type

Line 477: l_string1 := SUBSTR (fnd_message.get, 1, 2500);

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

Line 496: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_NOTE');

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

Line 497: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);

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)

Line 498: l_string2 := SUBSTR (fnd_message.get, 1, 2500);

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

Line 620: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

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: /*

Line 621: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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 (

Line 622: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

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,

Line 623: l_string := SUBSTR (fnd_message.get, 1, 1000);

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,

Line 634: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');

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

Line 635: fnd_message.set_token ('AP_NAME', l_ap_name, 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);

Line 636: fnd_message.set_token ('REQUESTOR_NAME', l_requestor_name, FALSE);

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

Line 637: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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,

Line 638: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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,

Line 639: l_string1 := SUBSTR (fnd_message.get, 1, 2500);

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'

Line 662: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');

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

Line 663: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);

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

Line 664: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);

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

Line 665: fnd_message.set_token ('COMMENTS', l_note, FALSE);

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

Line 666: l_string2 := SUBSTR (fnd_message.get, 1, 2500);

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)

Line 799: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

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: /*

Line 800: fnd_message.set_token ('AP_NAME', l_ap_name, FALSE);

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 (

Line 801: fnd_message.set_token ('OBJECT_TYPE', l_object_meaning, FALSE);

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,

Line 802: l_string := SUBSTR (fnd_message.get, 1, 1000);

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,

Line 811: fnd_message.set_name ('AMW', 'AMW_WF_NTF_AP_REQ_INFO');

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

Line 812: fnd_message.set_token ('AP_NAME', l_ap_name, 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);

Line 813: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

Line 814: fnd_message.set_token ('REQUESTOR_NAME', l_approver, FALSE);

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,

Line 815: --fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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,

Line 816: l_string1 := SUBSTR (fnd_message.get, 1, 2500);

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'

Line 839: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_ADDENDUM');

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

Line 840: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);

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: /*

Line 841: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);

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(

Line 842: fnd_message.set_token ('COMMENTS', l_note, FALSE);

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

Line 843: l_string2 := SUBSTR (fnd_message.get, 1, 2500);

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

Line 955: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_FYI_SUB');

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,

Line 956: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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,

Line 957: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

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

Line 958: l_string := SUBSTR (fnd_message.get, 1, 1000);

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

Line 964: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_APP_SUB');

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,

Line 965: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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,

Line 966: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

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

Line 967: l_string := SUBSTR (fnd_message.get, 1, 1000);

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

Line 973: fnd_message.set_name ('AMW', 'AMW_WF_NTF_REQUESTOR_REJ_SUB');

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,

Line 974: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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,

Line 975: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

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

Line 976: l_string := SUBSTR (fnd_message.get, 1, 1000);

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

Line 982: fnd_message.set_name ('AMW', 'AMW_WF_NTF_APPROVER_OF_REQ_SUB');

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,

Line 983: fnd_message.set_token ('NAME', l_ap_name, FALSE);

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,

Line 984: fnd_message.set_token ('OBJECT_TYPE', l_lookup_meaning, FALSE);

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

Line 985: l_string := SUBSTR (fnd_message.get, 1, 1000);

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