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 166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');

162: p_lookup_code => 'BUDGET',
163: x_return_status => l_return_status,
164: x_meaning => l_fund_meaning);
165: END IF;
166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

163: x_return_status => l_return_status,
164: x_meaning => l_fund_meaning);
165: END IF;
166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

164: x_meaning => l_fund_meaning);
165: END IF;
166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);

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

165: END IF;
166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);
173: /*

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

166: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);
173: /*
174: wf_engine.setitemattrtext (

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

167: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);
173: /*
174: wf_engine.setitemattrtext (
175: itemtype=> l_item_type,

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

168: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
169: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
170: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
171: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
172: l_string := SUBSTR(fnd_message.get,1,1000);
173: /*
174: wf_engine.setitemattrtext (
175: itemtype=> l_item_type,
176: itemkey=> l_item_key,

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

177: aname => 'FYI_SUBJECT',
178: avalue=> l_string
179: );
180: */
181: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

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

178: avalue=> l_string
179: );
180: */
181: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

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

179: );
180: */
181: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

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

180: */
181: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

181: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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

182: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

183: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

184: fnd_message.set_token ('OWNER', l_requester, FALSE);
185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;

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

185: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;
193: /*

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

186: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;
193: /*
194: l_note := wf_engine.getitemattrtext(

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

187: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;
193: /*
194: l_note := wf_engine.getitemattrtext(
195: itemtype => l_item_type

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

188: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
189: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
190: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
191: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
192: --l_string1 := fnd_message.get;
193: /*
194: l_note := wf_engine.getitemattrtext(
195: itemtype => l_item_type
196: ,itemkey => l_item_key

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

382: x_return_status => l_return_status,
383: x_meaning => l_fund_meaning);
384: END IF;
385:
386: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

383: x_meaning => l_fund_meaning);
384: END IF;
385:
386: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

384: END IF;
385:
386: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);

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

385:
386: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');

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

386: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);

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

387: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);

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

388: --fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);

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

389: --fnd_message.set_token ('AMOUNT', l_approved_amt, FALSE);
390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

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

390: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

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

391: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

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

392: l_string := Substr(FND_MESSAGE.Get,1,1000);
393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

393: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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

394: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

395: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

396: fnd_message.set_token ('OWNER', l_requester, FALSE);
397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;

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

397: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;
405: /*

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

398: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;
405: /*
406: l_note := wf_engine.getitemattrtext(

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

399: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;
405: /*
406: l_note := wf_engine.getitemattrtext(
407: itemtype => l_item_type

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

400: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
401: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
402: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
403: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
404: --l_string1 := fnd_message.get;
405: /*
406: l_note := wf_engine.getitemattrtext(
407: itemtype => l_item_type
408: ,itemkey => l_item_key

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

419: itemtype=> l_item_type,
420: itemkey=> l_item_key,
421: aname => 'APPROVAL_NOTE'
422: );
423: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);

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

420: itemkey=> l_item_key,
421: aname => 'APPROVAL_NOTE'
422: );
423: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
428: l_string2 := fnd_message.get;

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

421: aname => 'APPROVAL_NOTE'
422: );
423: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
428: l_string2 := fnd_message.get;
429: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */

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

422: );
423: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
428: l_string2 := fnd_message.get;
429: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
430: -- IF (display_type = 'text/plain') THEN

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

423: fnd_message.set_name('AMS', 'AMS_WF_NTF_REQUESTER_ADDENDUM');
424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
428: l_string2 := fnd_message.get;
429: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
430: -- IF (display_type = 'text/plain') THEN
431: l_appr_notification := SUBSTR(l_string

Line 428: l_string2 := fnd_message.get;

424: fnd_message.set_token('APPROVER_NAME', l_approver, FALSE);
425: fnd_message.set_token('CURRENCY_CODE', l_curr_code, FALSE);
426: fnd_message.set_token('AMOUNT', l_approved_amt, FALSE);
427: fnd_message.set_token('NOTES_FROM_APPROVER', l_approver_note, FALSE);
428: l_string2 := fnd_message.get;
429: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVAL NOTE NOT SHOWING IN APPROVAL EMAIL */
430: -- IF (display_type = 'text/plain') THEN
431: l_appr_notification := SUBSTR(l_string
432: || fnd_global.local_chr (10)

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

586: x_return_status => l_return_status,
587: x_meaning => l_fund_meaning);
588: END IF;
589: CLOSE c_fund_rec;
590: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

587: x_meaning => l_fund_meaning);
588: END IF;
589: CLOSE c_fund_rec;
590: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

588: END IF;
589: CLOSE c_fund_rec;
590: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande

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

589: CLOSE c_fund_rec;
590: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

590: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);

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

591: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
592: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);
599: --l_string := fnd_message.get;

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

593: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);
599: --l_string := fnd_message.get;
600: /*
601: wf_engine.setitemattrtext (

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

594: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);
599: --l_string := fnd_message.get;
600: /*
601: wf_engine.setitemattrtext (
602: itemtype=> l_item_type,

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

595: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
596: -- 01/12/2001 mpande
597: --fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
598: l_string := Substr(FND_MESSAGE.Get,1,1000);
599: --l_string := fnd_message.get;
600: /*
601: wf_engine.setitemattrtext (
602: itemtype=> l_item_type,
603: itemkey=> l_item_key,

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

604: aname => 'REJECT_SUBJECT',
605: avalue=> l_string
606: );
607: */
608: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

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

605: avalue=> l_string
606: );
607: */
608: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

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

606: );
607: */
608: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

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

607: */
608: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

608: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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

609: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

610: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

611: fnd_message.set_token ('OWNER', l_requester, FALSE);
612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
619: /*

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

612: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
619: /*
620: l_note := wf_engine.getitemattrtext(

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

613: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
619: /*
620: l_note := wf_engine.getitemattrtext(
621: itemtype => l_item_type

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

614: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
615: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
616: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
617: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
618: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
619: /*
620: l_note := wf_engine.getitemattrtext(
621: itemtype => l_item_type
622: ,itemkey => l_item_key

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

633: itemtype=> l_item_type,
634: itemkey=> l_item_key,
635: aname => 'APPROVAL_NOTE'
636: );
637: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
638: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
639: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
640: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
641: -- IF (display_type = 'text/plain') THEN

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

634: itemkey=> l_item_key,
635: aname => 'APPROVAL_NOTE'
636: );
637: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
638: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
639: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
640: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
641: -- IF (display_type = 'text/plain') THEN
642: l_rej_notification := SUBSTR(l_string

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

635: aname => 'APPROVAL_NOTE'
636: );
637: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_NOTE');
638: fnd_message.set_token ('NOTES_FROM_APPROVER', l_note, FALSE);
639: l_string2 := SUBSTR(FND_MESSAGE.Get, 1, 2500);
640: /* yzhao: 01/23/2003 fix bug 2771105(same as 11.5.8 bug 2753608) ends - APPROVer's NOTE NOT SHOWING IN rejection EMAIL */
641: -- IF (display_type = 'text/plain') THEN
642: l_rej_notification := SUBSTR(l_string
643: || fnd_global.local_chr (10)

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

802: p_lookup_code => 'BUDGET',
803: x_return_status => l_return_status,
804: x_meaning => l_fund_meaning);
805: END IF;
806: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

803: x_return_status => l_return_status,
804: x_meaning => l_fund_meaning);
805: END IF;
806: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

804: x_meaning => l_fund_meaning);
805: END IF;
806: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

805: END IF;
806: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);

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

806: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);
814: /*

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

807: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);
814: /*
815: wf_engine.setitemattrtext (

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

808: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);
814: /*
815: wf_engine.setitemattrtext (
816: itemtype=> l_item_type,

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

809: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
810: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
811: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
812: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
813: l_string := SUBSTR(fnd_message.get,1,1000);
814: /*
815: wf_engine.setitemattrtext (
816: itemtype=> l_item_type,
817: itemkey=> l_item_key,

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

818: aname => 'APP_SUBJECT',
819: avalue=> l_string
820: );
821: */
822: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

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

819: avalue=> l_string
820: );
821: */
822: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

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

820: );
821: */
822: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

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

821: */
822: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

822: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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

823: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

824: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);

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

825: fnd_message.set_token ('OWNER', l_requester, FALSE);
826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
833: l_note :=

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

826: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
833: l_note :=
834: NVL(wf_engine.getitemattrtext (

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

827: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
833: l_note :=
834: NVL(wf_engine.getitemattrtext (
835: itemtype=> l_item_type,

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

828: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
829: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
830: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
831: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
832: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
833: l_note :=
834: NVL(wf_engine.getitemattrtext (
835: itemtype=> l_item_type,
836: itemkey=> l_item_key,

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

845: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
846: itemtype => l_item_type,
847: itemkey => l_item_key,
848: aname => 'AMS_APPROVAL_DATE')),'-');
849: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
850: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later

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

846: itemtype => l_item_type,
847: itemkey => l_item_key,
848: aname => 'AMS_APPROVAL_DATE')),'-');
849: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
850: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

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

847: itemkey => l_item_key,
848: aname => 'AMS_APPROVAL_DATE')),'-');
849: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
850: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

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

848: aname => 'AMS_APPROVAL_DATE')),'-');
849: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
850: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
856: */

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

850: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
856: */
857: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
858: l_string2 := SUBSTR(fnd_message.get,1,2500);

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

851: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
852: fnd_message.set_token ('COMMENTS', l_note, FALSE);
853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
856: */
857: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
858: l_string2 := SUBSTR(fnd_message.get,1,2500);
859: -- IF (display_type = 'text/plain') THEN

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

853: /* will set the tokens later
854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
856: */
857: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
858: l_string2 := SUBSTR(fnd_message.get,1,2500);
859: -- IF (display_type = 'text/plain') THEN
860: l_appreq_notification := l_string
861: || fnd_global.local_chr (10)

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

854: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
855: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
856: */
857: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
858: l_string2 := SUBSTR(fnd_message.get,1,2500);
859: -- IF (display_type = 'text/plain') THEN
860: l_appreq_notification := l_string
861: || fnd_global.local_chr (10)
862: || l_string1

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

1016: p_lookup_code => 'BUDGET',
1017: x_return_status => l_return_status,
1018: x_meaning => l_fund_meaning);
1019: END IF;
1020: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

1017: x_return_status => l_return_status,
1018: x_meaning => l_fund_meaning);
1019: END IF;
1020: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

1018: x_meaning => l_fund_meaning);
1019: END IF;
1020: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);

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

1019: END IF;
1020: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);

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

1020: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);
1028: /*

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

1021: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);
1028: /*
1029: wf_engine.setitemattrtext (

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

1022: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);
1028: /*
1029: wf_engine.setitemattrtext (
1030: itemtype=> l_item_type,

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

1023: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1024: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1025: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1026: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1027: l_string := SUBSTR(fnd_message.get,1,1000);
1028: /*
1029: wf_engine.setitemattrtext (
1030: itemtype=> l_item_type,
1031: itemkey=> l_item_key,

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

1032: aname => 'APP_SUBJECT',
1033: avalue=> l_string
1034: );
1035: */
1036: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);

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

1033: avalue=> l_string
1034: );
1035: */
1036: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);

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

1034: );
1035: */
1036: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);

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

1035: */
1036: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);

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

1036: fnd_message.set_name ('AMS', 'AMS_WF_NTF_ROOTBUDGET_REQ_INFO');
1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);

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

1037: fnd_message.set_token ('BUDGET_NAME', l_fund_name, FALSE);
1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);

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

1038: fnd_message.set_token ('BUDGET_NUMBER', l_fund_number, FALSE);
1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);

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

1039: fnd_message.set_token ('OWNER', l_requester, FALSE);
1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1047: l_note :=

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

1040: fnd_message.set_token ('START_DATE', l_start_date, FALSE);
1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1047: l_note :=
1048: NVL(wf_engine.getitemattrtext (

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

1041: fnd_message.set_token ('CURRENCY_CODE', l_curr_code, FALSE);
1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1047: l_note :=
1048: NVL(wf_engine.getitemattrtext (
1049: itemtype=> l_item_type,

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

1042: fnd_message.set_token ('AMOUNT', l_requested_amt, FALSE);
1043: fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE);
1044: fnd_message.set_token ('DESCRIPTION', l_note, FALSE);
1045: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1046: -- l_string1 := Substr(FND_MESSAGE.Get,1,2500);
1047: l_note :=
1048: NVL(wf_engine.getitemattrtext (
1049: itemtype=> l_item_type,
1050: itemkey=> l_item_key,

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

1059: l_approval_date := NVL(to_char(wf_engine.getitemattrdate (
1060: itemtype => l_item_type,
1061: itemkey => l_item_key,
1062: aname => 'AMS_APPROVAL_DATE')),'-');
1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1064: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);

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

1060: itemtype => l_item_type,
1061: itemkey => l_item_key,
1062: aname => 'AMS_APPROVAL_DATE')),'-');
1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1064: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later

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

1061: itemkey => l_item_key,
1062: aname => 'AMS_APPROVAL_DATE')),'-');
1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1064: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);

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

1062: aname => 'AMS_APPROVAL_DATE')),'-');
1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1064: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);

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

1063: l_string1 := SUBSTR(FND_MESSAGE.Get,1,2500);
1064: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_ADDENDUM');
1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1071: */

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

1065: fnd_message.set_token ('PREV_APPROVER_NAME', l_forwarder, FALSE);
1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1071: */
1072: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1073: l_string2 := SUBSTR(fnd_message.get,1,2500);

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

1066: fnd_message.set_token ('APPROVAL_DATE', l_approval_date, FALSE);
1067: fnd_message.set_token ('COMMENTS', l_note, FALSE);
1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1071: */
1072: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1073: l_string2 := SUBSTR(fnd_message.get,1,2500);
1074: /*

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

1068: /* will set the tokens later
1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1071: */
1072: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1073: l_string2 := SUBSTR(fnd_message.get,1,2500);
1074: /*
1075: l_note := wf_engine.getitemattrtext(
1076: itemtype => l_item_type

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

1069: fnd_message.set_token('BUDGET_NAME',l_fund_name,false);
1070: fnd_message.set_token('BUDGET_NUMBER',l_fund_number,false);
1071: */
1072: -- l_string2 := Substr(FND_MESSAGE.Get,1,2500);
1073: l_string2 := SUBSTR(fnd_message.get,1,2500);
1074: /*
1075: l_note := wf_engine.getitemattrtext(
1076: itemtype => l_item_type
1077: ,itemkey => l_item_key

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

1246: aname => 'AMS_REQUESTED_AMOUNT',
1247: avalue=> l_object_details.total_header_amount
1248: );
1249: --- set all the subjects here
1250: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
1251: fnd_message.set_token (
1252: 'BUDGET_NAME',
1253: l_object_details.name,
1254: FALSE

Line 1251: fnd_message.set_token (

1247: avalue=> l_object_details.total_header_amount
1248: );
1249: --- set all the subjects here
1250: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_FYI_SUB');
1251: fnd_message.set_token (
1252: 'BUDGET_NAME',
1253: l_object_details.name,
1254: FALSE
1255: );

Line 1256: fnd_message.set_token (

1252: 'BUDGET_NAME',
1253: l_object_details.name,
1254: FALSE
1255: );
1256: fnd_message.set_token (
1257: 'CURRENCY_CODE',
1258: l_object_details.currency,
1259: FALSE
1260: );

Line 1261: fnd_message.set_token (

1257: 'CURRENCY_CODE',
1258: l_object_details.currency,
1259: FALSE
1260: );
1261: fnd_message.set_token (
1262: 'AMOUNT',
1263: l_object_details.total_header_amount,
1264: FALSE
1265: );

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

1262: 'AMOUNT',
1263: l_object_details.total_header_amount,
1264: FALSE
1265: );
1266: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1267: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1268: l_string := fnd_message.get;
1269: wf_engine.setitemattrtext (
1270: itemtype=> itemtype,

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

1263: l_object_details.total_header_amount,
1264: FALSE
1265: );
1266: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1267: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1268: l_string := fnd_message.get;
1269: wf_engine.setitemattrtext (
1270: itemtype=> itemtype,
1271: itemkey=> itemkey,

Line 1268: l_string := fnd_message.get;

1264: FALSE
1265: );
1266: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1267: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE); -- ##
1268: l_string := fnd_message.get;
1269: wf_engine.setitemattrtext (
1270: itemtype=> itemtype,
1271: itemkey=> itemkey,
1272: aname => 'FYI_SUBJECT',

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

1271: itemkey=> itemkey,
1272: aname => 'FYI_SUBJECT',
1273: avalue=> l_string
1274: );
1275: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1276: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);

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

1272: aname => 'FYI_SUBJECT',
1273: avalue=> l_string
1274: );
1275: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1276: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);

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

1274: );
1275: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1276: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;

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

1275: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_APP_SUB');
1276: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;
1283: wf_engine.setitemattrtext (

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

1276: fnd_message.set_token ('BUDGET_NAME', l_object_details.name, FALSE );
1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;
1283: wf_engine.setitemattrtext (
1284: itemtype=> itemtype,

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

1277: -- 11/06/2001 mpande commented
1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;
1283: wf_engine.setitemattrtext (
1284: itemtype=> itemtype,
1285: itemkey=> itemkey,

Line 1282: l_string := fnd_message.get;

1278: --fnd_message.set_token ('CURRENCY_CODE', l_object_details.currency, FALSE );
1279: --fnd_message.set_token ('AMOUNT',l_object_details.total_header_amount, FALSE);
1280: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1281: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1282: l_string := fnd_message.get;
1283: wf_engine.setitemattrtext (
1284: itemtype=> itemtype,
1285: itemkey=> itemkey,
1286: aname => 'APRV_SUBJECT',

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

1285: itemkey=> itemkey,
1286: aname => 'APRV_SUBJECT',
1287: avalue=> l_string
1288: );
1289: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
1290: fnd_message.set_token (
1291: 'BUDGET_NAME',
1292: l_object_details.name,
1293: FALSE

Line 1290: fnd_message.set_token (

1286: aname => 'APRV_SUBJECT',
1287: avalue=> l_string
1288: );
1289: fnd_message.set_name ('AMS', 'AMS_WF_NTF_REQUESTER_REJ_SUB');
1290: fnd_message.set_token (
1291: 'BUDGET_NAME',
1292: l_object_details.name,
1293: FALSE
1294: );

Line 1295: fnd_message.set_token (

1291: 'BUDGET_NAME',
1292: l_object_details.name,
1293: FALSE
1294: );
1295: fnd_message.set_token (
1296: 'CURRENCY_CODE',
1297: l_object_details.currency,
1298: FALSE
1299: );

Line 1300: fnd_message.set_token (

1296: 'CURRENCY_CODE',
1297: l_object_details.currency,
1298: FALSE
1299: );
1300: fnd_message.set_token (
1301: 'AMOUNT',
1302: l_object_details.total_header_amount,
1303: FALSE
1304: );

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

1301: 'AMOUNT',
1302: l_object_details.total_header_amount,
1303: FALSE
1304: );
1305: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1306: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1307: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1308: l_string := fnd_message.get;
1309: wf_engine.setitemattrtext (

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

1302: l_object_details.total_header_amount,
1303: FALSE
1304: );
1305: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1306: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1307: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1308: l_string := fnd_message.get;
1309: wf_engine.setitemattrtext (
1310: itemtype=> itemtype,

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

1303: FALSE
1304: );
1305: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1306: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1307: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1308: l_string := fnd_message.get;
1309: wf_engine.setitemattrtext (
1310: itemtype=> itemtype,
1311: itemkey=> itemkey,

Line 1308: l_string := fnd_message.get;

1304: );
1305: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1306: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1307: -- yzhao: not a token in message fnd_message.set_token ('APPROVER_NAME', l_approver, FALSE); -- ##
1308: l_string := fnd_message.get;
1309: wf_engine.setitemattrtext (
1310: itemtype=> itemtype,
1311: itemkey=> itemkey,
1312: aname => 'REJECT_SUBJECT',

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

1311: itemkey=> itemkey,
1312: aname => 'REJECT_SUBJECT',
1313: avalue=> l_string
1314: );
1315: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1316: fnd_message.set_token (
1317: 'BUDGET_NAME',
1318: l_object_details.name,
1319: FALSE

Line 1316: fnd_message.set_token (

1312: aname => 'REJECT_SUBJECT',
1313: avalue=> l_string
1314: );
1315: fnd_message.set_name ('AMS', 'AMS_WF_NTF_APPROVER_OF_REQ_SUB');
1316: fnd_message.set_token (
1317: 'BUDGET_NAME',
1318: l_object_details.name,
1319: FALSE
1320: );

Line 1321: fnd_message.set_token (

1317: 'BUDGET_NAME',
1318: l_object_details.name,
1319: FALSE
1320: );
1321: fnd_message.set_token (
1322: 'CURRENCY_CODE',
1323: l_object_details.currency,
1324: FALSE
1325: );

Line 1326: fnd_message.set_token (

1322: 'CURRENCY_CODE',
1323: l_object_details.currency,
1324: FALSE
1325: );
1326: fnd_message.set_token (
1327: 'AMOUNT',
1328: l_object_details.total_header_amount,
1329: FALSE
1330: );

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

1327: 'AMOUNT',
1328: l_object_details.total_header_amount,
1329: FALSE
1330: );
1331: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1332: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1333: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1334: l_string := fnd_message.get;
1335: wf_engine.setitemattrtext (

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

1328: l_object_details.total_header_amount,
1329: FALSE
1330: );
1331: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1332: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1333: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1334: l_string := fnd_message.get;
1335: wf_engine.setitemattrtext (
1336: itemtype=> itemtype,

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

1329: FALSE
1330: );
1331: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1332: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1333: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1334: l_string := fnd_message.get;
1335: wf_engine.setitemattrtext (
1336: itemtype=> itemtype,
1337: itemkey=> itemkey,

Line 1334: l_string := fnd_message.get;

1330: );
1331: fnd_message.set_token ('REQUEST_NUMBER', '-', FALSE);
1332: fnd_message.set_token ('FUND_TYPE', l_fund_meaning, FALSE);
1333: -- l_string := Substr(FND_MESSAGE.Get,1,2500);
1334: l_string := fnd_message.get;
1335: wf_engine.setitemattrtext (
1336: itemtype=> itemtype,
1337: itemkey=> itemkey,
1338: aname => 'APP_SUBJECT',