eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.OZF_FUND_APPROVAL_PVT dependencies on FND_MESSAGE

Line 202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');

198: p_lookup_code => 'BUDGET',
199: x_return_status => l_return_status,
200: x_meaning => l_fund_meaning);
201: END IF;
202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

199: x_return_status => l_return_status,
200: x_meaning => l_fund_meaning);
201: END IF;
202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

200: x_meaning => l_fund_meaning);
201: END IF;
202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);

Line 205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

201: END IF;
202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);
209: /*

Line 206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

202: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);
209: /*
210: wf_engine.setitemattrtext (

Line 207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

203: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);
209: /*
210: wf_engine.setitemattrtext (
211: itemtype=> l_item_type,

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

204: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
205: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
206: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
207: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
208: l_string := SUBSTR(fnd_message.get,1,1000);
209: /*
210: wf_engine.setitemattrtext (
211: itemtype=> l_item_type,
212: itemkey=> l_item_key,

Line 217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

213: aname => 'FYI_SUBJECT',
214: avalue=> l_string
215: );
216: */
217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

214: avalue=> l_string
215: );
216: */
217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

Line 219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

215: );
216: */
217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

Line 220: fnd_message.set_token ('OWNER', l_requester, FALSE);

216: */
217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

217: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

218: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

219: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

220: fnd_message.set_token ('OWNER', l_requester, FALSE);
221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;

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

221: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;
229: /*

Line 226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

222: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;
229: /*
230: l_note := wf_engine.getitemattrtext(

Line 227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

223: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;
229: /*
230: l_note := wf_engine.getitemattrtext(
231: itemtype => l_item_type

Line 228: --l_string1 := fnd_message.get;

224: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
225: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
226: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
227: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
228: --l_string1 := fnd_message.get;
229: /*
230: l_note := wf_engine.getitemattrtext(
231: itemtype => l_item_type
232: ,itemkey => l_item_key

Line 422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');

418: x_return_status => l_return_status,
419: x_meaning => l_fund_meaning);
420: END IF;
421:
422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

419: x_meaning => l_fund_meaning);
420: END IF;
421:
422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

420: END IF;
421:
422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);

421:
422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

Line 426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

422: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

Line 427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

423: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

Line 428: l_string := Substr(FND_MESSAGE.Get,1,1000);

424: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);

Line 429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

425: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

426: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

Line 431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

427: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

Line 432: fnd_message.set_token ('OWNER', l_requester, FALSE);

428: l_string := Substr(FND_MESSAGE.Get,1,1000);
429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

429: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

430: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

431: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

432: fnd_message.set_token ('OWNER', l_requester, FALSE);
433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;

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

433: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;
441: /*

Line 438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

434: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;
441: /*
442: l_note := wf_engine.getitemattrtext(

Line 439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

435: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;
441: /*
442: l_note := wf_engine.getitemattrtext(
443: itemtype => l_item_type

Line 440: --l_string1 := fnd_message.get;

436: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
437: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
438: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
439: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
440: --l_string1 := fnd_message.get;
441: /*
442: l_note := wf_engine.getitemattrtext(
443: itemtype => l_item_type
444: ,itemkey => l_item_key

Line 459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');

455: itemtype=> l_item_type,
456: itemkey=> l_item_key,
457: aname => 'APPROVAL_NOTE'
458: );
459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);

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

456: itemkey=> l_item_key,
457: aname => 'APPROVAL_NOTE'
458: );
459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
464: l_string2 := fnd_message.get;

Line 461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);

457: aname => 'APPROVAL_NOTE'
458: );
459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
464: l_string2 := fnd_message.get;
465: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */

Line 462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);

458: );
459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
464: l_string2 := fnd_message.get;
465: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
466: -- IF (display_type = 'text/plain') THEN

Line 463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);

459: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
464: l_string2 := fnd_message.get;
465: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
466: -- IF (display_type = 'text/plain') THEN
467: l_appr_notification := SUBSTR(l_string

Line 464: l_string2 := fnd_message.get;

460: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
461: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
462: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
463: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
464: l_string2 := fnd_message.get;
465: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
466: -- IF (display_type = 'text/plain') THEN
467: l_appr_notification := SUBSTR(l_string
468: || fnd_global.local_chr (10)

Line 626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');

622: x_return_status => l_return_status,
623: x_meaning => l_fund_meaning);
624: END IF;
625: CLOSE c_fund_rec;
626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

623: x_meaning => l_fund_meaning);
624: END IF;
625: CLOSE c_fund_rec;
626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

624: END IF;
625: CLOSE c_fund_rec;
626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande

Line 629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

625: CLOSE c_fund_rec;
626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

626: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);

Line 631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

627: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
628: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);
635: --l_string := fnd_message.get;

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

629: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);
635: --l_string := fnd_message.get;
636: /*
637: wf_engine.setitemattrtext (

Line 634: l_string := Substr(FND_MESSAGE.Get,1,1000);

630: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);
635: --l_string := fnd_message.get;
636: /*
637: wf_engine.setitemattrtext (
638: itemtype=> l_item_type,

Line 635: --l_string := fnd_message.get;

631: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
632: -- 01/12/2001 mpande
633: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
634: l_string := Substr(FND_MESSAGE.Get,1,1000);
635: --l_string := fnd_message.get;
636: /*
637: wf_engine.setitemattrtext (
638: itemtype=> l_item_type,
639: itemkey=> l_item_key,

Line 644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

640: aname => 'REJECT_SUBJECT',
641: avalue=> l_string
642: );
643: */
644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

641: avalue=> l_string
642: );
643: */
644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

Line 646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

642: );
643: */
644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

Line 647: fnd_message.set_token ('OWNER', l_requester, FALSE);

643: */
644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

644: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

645: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

646: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

647: fnd_message.set_token ('OWNER', l_requester, FALSE);
648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
655: /*

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

648: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
655: /*
656: l_note := wf_engine.getitemattrtext(

Line 653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

649: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
655: /*
656: l_note := wf_engine.getitemattrtext(
657: itemtype => l_item_type

Line 654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

650: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
651: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
652: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
653: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
654: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
655: /*
656: l_note := wf_engine.getitemattrtext(
657: itemtype => l_item_type
658: ,itemkey => l_item_key

Line 673: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');

669: itemtype=> l_item_type,
670: itemkey=> l_item_key,
671: aname => 'APPROVAL_NOTE'
672: );
673: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
674: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
675: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
676: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
677: -- IF (display_type = 'text/plain') THEN

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

670: itemkey=> l_item_key,
671: aname => 'APPROVAL_NOTE'
672: );
673: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
674: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
675: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
676: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
677: -- IF (display_type = 'text/plain') THEN
678: l_rej_notification := SUBSTR(l_string

Line 675: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);

671: aname => 'APPROVAL_NOTE'
672: );
673: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
674: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
675: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
676: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
677: -- IF (display_type = 'text/plain') THEN
678: l_rej_notification := SUBSTR(l_string
679: || fnd_global.local_chr (10)

Line 842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');

838: p_lookup_code => 'BUDGET',
839: x_return_status => l_return_status,
840: x_meaning => l_fund_meaning);
841: END IF;
842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

839: x_return_status => l_return_status,
840: x_meaning => l_fund_meaning);
841: END IF;
842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

840: x_meaning => l_fund_meaning);
841: END IF;
842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

841: END IF;
842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);

Line 846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

842: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);
850: /*

Line 847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

843: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);
850: /*
851: wf_engine.setitemattrtext (

Line 848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

844: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);
850: /*
851: wf_engine.setitemattrtext (
852: itemtype=> l_item_type,

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

845: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
846: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
847: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
848: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
849: l_string := SUBSTR(fnd_message.get,1,1000);
850: /*
851: wf_engine.setitemattrtext (
852: itemtype=> l_item_type,
853: itemkey=> l_item_key,

Line 858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

854: aname => 'APP_SUBJECT',
855: avalue=> l_string
856: );
857: */
858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

855: avalue=> l_string
856: );
857: */
858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

Line 860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

856: );
857: */
858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

Line 861: fnd_message.set_token ('OWNER', l_requester, FALSE);

857: */
858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

858: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

859: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

860: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

861: fnd_message.set_token ('OWNER', l_requester, FALSE);
862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
869: l_note :=

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

862: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
869: l_note :=
870: NVL(wf_engine.getitemattrtext (

Line 867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

863: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
869: l_note :=
870: NVL(wf_engine.getitemattrtext (
871: itemtype=> l_item_type,

Line 868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

864: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
865: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
866: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
867: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
868: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
869: l_note :=
870: NVL(wf_engine.getitemattrtext (
871: itemtype=> l_item_type,
872: itemkey=> l_item_key,

Line 885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');

881: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
882: itemtype => l_item_type,
883: itemkey => l_item_key,
884: aname => 'AMS_APPROVAL_DATE')),'-');
885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
886: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later

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

882: itemtype => l_item_type,
883: itemkey => l_item_key,
884: aname => 'AMS_APPROVAL_DATE')),'-');
885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
886: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

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

883: itemkey => l_item_key,
884: aname => 'AMS_APPROVAL_DATE')),'-');
885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
886: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

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

884: aname => 'AMS_APPROVAL_DATE')),'-');
885: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
886: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
892: */

Line 890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

886: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
892: */
893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
894: l_string2 := SUBSTR(fnd_message.get,1,2500);

Line 891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

887: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
888: fnd_message.set_token ('COMMENTS', l_note, FALSE);
889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
892: */
893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
894: l_string2 := SUBSTR(fnd_message.get,1,2500);
895: -- IF (display_type = 'text/plain') THEN

Line 893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);

889: /* will set the tokens later
890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
892: */
893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
894: l_string2 := SUBSTR(fnd_message.get,1,2500);
895: -- IF (display_type = 'text/plain') THEN
896: l_appreq_notification := l_string
897: || fnd_global.local_chr (10)

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

890: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
891: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
892: */
893: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
894: l_string2 := SUBSTR(fnd_message.get,1,2500);
895: -- IF (display_type = 'text/plain') THEN
896: l_appreq_notification := l_string
897: || fnd_global.local_chr (10)
898: || l_string1

Line 1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');

1052: p_lookup_code => 'BUDGET',
1053: x_return_status => l_return_status,
1054: x_meaning => l_fund_meaning);
1055: END IF;
1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

1053: x_return_status => l_return_status,
1054: x_meaning => l_fund_meaning);
1055: END IF;
1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

1054: x_meaning => l_fund_meaning);
1055: END IF;
1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

Line 1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

1055: END IF;
1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);

Line 1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

1056: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);
1064: /*

Line 1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1057: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);
1064: /*
1065: wf_engine.setitemattrtext (

Line 1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1058: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);
1064: /*
1065: wf_engine.setitemattrtext (
1066: itemtype=> l_item_type,

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

1059: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1060: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1061: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1062: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1063: l_string := SUBSTR(fnd_message.get,1,1000);
1064: /*
1065: wf_engine.setitemattrtext (
1066: itemtype=> l_item_type,
1067: itemkey=> l_item_key,

Line 1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

1068: aname => 'APP_SUBJECT',
1069: avalue=> l_string
1070: );
1071: */
1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

Line 1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

1069: avalue=> l_string
1070: );
1071: */
1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

Line 1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

1070: );
1071: */
1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

Line 1075: fnd_message.set_token ('OWNER', l_requester, FALSE);

1071: */
1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

Line 1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

1072: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

Line 1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

1073: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

Line 1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

1074: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

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

1075: fnd_message.set_token ('OWNER', l_requester, FALSE);
1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1083: l_note :=

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

1076: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1083: l_note :=
1084: NVL(wf_engine.getitemattrtext (

Line 1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1077: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1083: l_note :=
1084: NVL(wf_engine.getitemattrtext (
1085: itemtype=> l_item_type,

Line 1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

1078: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1079: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1080: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1081: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1082: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1083: l_note :=
1084: NVL(wf_engine.getitemattrtext (
1085: itemtype=> l_item_type,
1086: itemkey=> l_item_key,

Line 1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

1095: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
1096: itemtype => l_item_type,
1097: itemkey => l_item_key,
1098: aname => 'AMS_APPROVAL_DATE')),'-');
1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);

Line 1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');

1096: itemtype => l_item_type,
1097: itemkey => l_item_key,
1098: aname => 'AMS_APPROVAL_DATE')),'-');
1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later

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

1097: itemkey => l_item_key,
1098: aname => 'AMS_APPROVAL_DATE')),'-');
1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

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

1098: aname => 'AMS_APPROVAL_DATE')),'-');
1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

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

1099: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1100: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1107: */

Line 1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

1101: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1107: */
1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1109: l_string2 := SUBSTR(fnd_message.get,1,2500);

Line 1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

1102: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1103: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1107: */
1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1109: l_string2 := SUBSTR(fnd_message.get,1,2500);
1110: /*

Line 1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);

1104: /* will set the tokens later
1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1107: */
1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1109: l_string2 := SUBSTR(fnd_message.get,1,2500);
1110: /*
1111: l_note := wf_engine.getitemattrtext(
1112: itemtype => l_item_type

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

1105: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1106: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1107: */
1108: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1109: l_string2 := SUBSTR(fnd_message.get,1,2500);
1110: /*
1111: l_note := wf_engine.getitemattrtext(
1112: itemtype => l_item_type
1113: ,itemkey => l_item_key

Line 1286: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');

1282: aname => 'AMS_REQUESTED_AMOUNT',
1283: avalue=> l_object_details.total_header_amount
1284: );
1285: --- set all the subjects here
1286: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
1287: fnd_message.set_token (
1288: 'BUDGET_NAME',
1289: l_object_details.name,
1290: FALSE

Line 1287: fnd_message.set_token (

1283: avalue=> l_object_details.total_header_amount
1284: );
1285: --- set all the subjects here
1286: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
1287: fnd_message.set_token (
1288: 'BUDGET_NAME',
1289: l_object_details.name,
1290: FALSE
1291: );

Line 1292: fnd_message.set_token (

1288: 'BUDGET_NAME',
1289: l_object_details.name,
1290: FALSE
1291: );
1292: fnd_message.set_token (
1293: 'CURRENCY_CODE',
1294: l_object_details.currency,
1295: FALSE
1296: );

Line 1297: fnd_message.set_token (

1293: 'CURRENCY_CODE',
1294: l_object_details.currency,
1295: FALSE
1296: );
1297: fnd_message.set_token (
1298: 'AMOUNT',
1299: l_object_details.total_header_amount,
1300: FALSE
1301: );

Line 1302: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

1298: 'AMOUNT',
1299: l_object_details.total_header_amount,
1300: FALSE
1301: );
1302: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1303: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1304: l_string := fnd_message.get;
1305: wf_engine.setitemattrtext (
1306: itemtype=> itemtype,

Line 1303: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##

1299: l_object_details.total_header_amount,
1300: FALSE
1301: );
1302: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1303: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1304: l_string := fnd_message.get;
1305: wf_engine.setitemattrtext (
1306: itemtype=> itemtype,
1307: itemkey=> itemkey,

Line 1304: l_string := fnd_message.get;

1300: FALSE
1301: );
1302: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1303: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1304: l_string := fnd_message.get;
1305: wf_engine.setitemattrtext (
1306: itemtype=> itemtype,
1307: itemkey=> itemkey,
1308: aname => 'FYI_SUBJECT',

Line 1311: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');

1307: itemkey=> itemkey,
1308: aname => 'FYI_SUBJECT',
1309: avalue=> l_string
1310: );
1311: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);

Line 1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );

1308: aname => 'FYI_SUBJECT',
1309: avalue=> l_string
1310: );
1311: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

Line 1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );

1310: );
1311: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;

Line 1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);

1311: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;
1319: wf_engine.setitemattrtext (

Line 1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

1312: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;
1319: wf_engine.setitemattrtext (
1320: itemtype=> itemtype,

Line 1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1313: -- 11/06/2001 mpande commented
1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;
1319: wf_engine.setitemattrtext (
1320: itemtype=> itemtype,
1321: itemkey=> itemkey,

Line 1318: l_string := fnd_message.get;

1314: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1315: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1316: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1317: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1318: l_string := fnd_message.get;
1319: wf_engine.setitemattrtext (
1320: itemtype=> itemtype,
1321: itemkey=> itemkey,
1322: aname => 'APRV_SUBJECT',

Line 1325: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');

1321: itemkey=> itemkey,
1322: aname => 'APRV_SUBJECT',
1323: avalue=> l_string
1324: );
1325: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
1326: fnd_message.set_token (
1327: 'BUDGET_NAME',
1328: l_object_details.name,
1329: FALSE

Line 1326: fnd_message.set_token (

1322: aname => 'APRV_SUBJECT',
1323: avalue=> l_string
1324: );
1325: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
1326: fnd_message.set_token (
1327: 'BUDGET_NAME',
1328: l_object_details.name,
1329: FALSE
1330: );

Line 1331: fnd_message.set_token (

1327: 'BUDGET_NAME',
1328: l_object_details.name,
1329: FALSE
1330: );
1331: fnd_message.set_token (
1332: 'CURRENCY_CODE',
1333: l_object_details.currency,
1334: FALSE
1335: );

Line 1336: fnd_message.set_token (

1332: 'CURRENCY_CODE',
1333: l_object_details.currency,
1334: FALSE
1335: );
1336: fnd_message.set_token (
1337: 'AMOUNT',
1338: l_object_details.total_header_amount,
1339: FALSE
1340: );

Line 1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

1337: 'AMOUNT',
1338: l_object_details.total_header_amount,
1339: FALSE
1340: );
1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1344: l_string := fnd_message.get;
1345: wf_engine.setitemattrtext (

Line 1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1338: l_object_details.total_header_amount,
1339: FALSE
1340: );
1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1344: l_string := fnd_message.get;
1345: wf_engine.setitemattrtext (
1346: itemtype=> itemtype,

Line 1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##

1339: FALSE
1340: );
1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1344: l_string := fnd_message.get;
1345: wf_engine.setitemattrtext (
1346: itemtype=> itemtype,
1347: itemkey=> itemkey,

Line 1344: l_string := fnd_message.get;

1340: );
1341: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1342: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1343: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1344: l_string := fnd_message.get;
1345: wf_engine.setitemattrtext (
1346: itemtype=> itemtype,
1347: itemkey=> itemkey,
1348: aname => 'REJECT_SUBJECT',

Line 1351: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');

1347: itemkey=> itemkey,
1348: aname => 'REJECT_SUBJECT',
1349: avalue=> l_string
1350: );
1351: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1352: fnd_message.set_token (
1353: 'BUDGET_NAME',
1354: l_object_details.name,
1355: FALSE

Line 1352: fnd_message.set_token (

1348: aname => 'REJECT_SUBJECT',
1349: avalue=> l_string
1350: );
1351: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1352: fnd_message.set_token (
1353: 'BUDGET_NAME',
1354: l_object_details.name,
1355: FALSE
1356: );

Line 1357: fnd_message.set_token (

1353: 'BUDGET_NAME',
1354: l_object_details.name,
1355: FALSE
1356: );
1357: fnd_message.set_token (
1358: 'CURRENCY_CODE',
1359: l_object_details.currency,
1360: FALSE
1361: );

Line 1362: fnd_message.set_token (

1358: 'CURRENCY_CODE',
1359: l_object_details.currency,
1360: FALSE
1361: );
1362: fnd_message.set_token (
1363: 'AMOUNT',
1364: l_object_details.total_header_amount,
1365: FALSE
1366: );

Line 1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

1363: 'AMOUNT',
1364: l_object_details.total_header_amount,
1365: FALSE
1366: );
1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1370: l_string := fnd_message.get;
1371: wf_engine.setitemattrtext (

Line 1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

1364: l_object_details.total_header_amount,
1365: FALSE
1366: );
1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1370: l_string := fnd_message.get;
1371: wf_engine.setitemattrtext (
1372: itemtype=> itemtype,

Line 1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

1365: FALSE
1366: );
1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1370: l_string := fnd_message.get;
1371: wf_engine.setitemattrtext (
1372: itemtype=> itemtype,
1373: itemkey=> itemkey,

Line 1370: l_string := fnd_message.get;

1366: );
1367: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1368: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1369: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1370: l_string := fnd_message.get;
1371: wf_engine.setitemattrtext (
1372: itemtype=> itemtype,
1373: itemkey=> itemkey,
1374: aname => 'APP_SUBJECT',